Find Jobs
Hire Freelancers

Develop a .XLS Macro

$30-250 USD

In Progress
Posted almost 8 years ago

$30-250 USD

Paid on delivery
I have a table that I need to fill in. It is a table that shows businesses what the actual percentage discount they are giving up after a deduction for the people who pay for gift certificate never redeem the gift certificate and the business got free money. Example: Math Walk Through: Business sells 200 certificates with redemption value of $100 for $82 per certificate with 20% non-redemption's. Total Sales $200 X $82= $16,400 instead of the normal $200 X $100 =$20,000. So total discount given up is $3,600 (3,600= $20,000 -$16,400). Or simply ($3,600 = 200 sales X $18 per sale discounted) If 20% of the 200 certificates did not redeem the business freely received $82 from 40 people (40 = 20% of 200 sold). So the total free dollars received is $3280 ($3280 = 40 non-redemption's X $82 paid). So the business total discount was $3,600 but the free money received is $3,280 and therefore the net total discount given up is: $320 Now divide $320 net discount over the 160 people that did redeem and that means the effective discount percentage given per customer redeemed is actually only 2% ($320 divided by 160 redemptions = $2.00 per sale.) This would be like selling each $100 certificate for $98. I need to complete the uploaded table for various percentages of non redemptions and various levels of initial percentages offered. If you can create a .xls macro that would allow me to plug in the X and Y coordinates and find out the answer that would be great. I need to show in the table 3 digits max for the answer. In the example that I did it worked out to 2% exactly but there will be answers that may be 2.54% So only show three total digits either rounding up when above 5. So 3.656% becomes 3.66 in the table.
Project ID: 10731835

About the project

5 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
We have team of 40+ developers, and these developers work in 4 teams. The team leads of these teams are highly expert and skilled developers. I can assign one of the TLs to your project so that he could lead and work with your two developers. I am sure you have reviewed our profile and our work. [login to view URL] [login to view URL] [login to view URL] [login to view URL] I’m quite confident that with the skill set that our company has and the experience that we bring will add a phenomenal value in your product. Regards, Bakhtawar Sr. Business Developer Cooperative Computing
$147 USD in 3 days
0.0 (0 reviews)
0.0
0.0
5 freelancers are bidding on average $185 USD for this job
User Avatar
I can do it for you quickly and exactly .
$200 USD in 4 days
5.0 (5 reviews)
3.8
3.8
User Avatar
Hi, I have 6 years of experience in java and web development. I understood the requirement . Hope we can have more conversation about the requirement and impementation
$222 USD in 8 days
5.0 (4 reviews)
3.1
3.1
User Avatar
i will complete your work as per your instructions and complete it within given time...thank you....
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, we don't believe in long copy pasted bids, to know us better kindly ready our reviews, we can deliver you state of the art quality design with free Seo suggestions and 1 month free support after the project completion as well. Regards AZ
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
North Caldwell, United States
5.0
415
Payment method verified
Member since Feb 14, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.