Find Jobs
Hire Freelancers

Create excel calculator / formula page (retrieve information, non-repeating dropdowns, display information, etc)

$30-250 AUD

Completed
Posted over 9 years ago

$30-250 AUD

Paid on delivery
Hello all I have a small project, to create a 'calculator'. I have attached a spreadsheet that sets out what the calculator will look like. It also attempts to explain how it will be made. The data for this calculator is not included, but it will more or less appear as follows: - 10 sheets, each sheet representing a farm - Each farm has a list of flower varieties - Each variety has a number of stem lengths - Each variety has a fixed type and colour Each sheet has repeating data, e.g. a flower variety will be listed 5 times with a different stem length for each listing, each which have a different price. The calculator is described as below. In the calculator you will be able to select a farm from a dropdown. You will then be able to select a flower variety from a dropdown but you will be presented with a non-repeating/no-duplicate list of the flower varieties for the selected farm. The calculator will then display the colour and type of that variety (simply retrieve corresponding information from a sheet). The calculator will then have a dropdown to select the stem length for the variety/farm selected. Again, it will be a non-repeating/no-duplicate list of the stem lengths available for the particular variety in question. You can then input how many stems you want (any integer). The calculator will then calculate the total price for that number of stems by matching the price for the chosen farm/variety/stemlength with the number of stems, and multiplying those two figures. The calculator will then display the currency for the total price, retrieved from the relevant sheet (EUR or USD will be present). There will then be a field that allows you to input the relevant exchange rate. The final field will calculate the total price in AUD (simply multiplying the total price in EUR or USD by the manually inserted exchange rate). I will send the successful applicant the spreadsheet complete with the full data. I am hoping to get a freelancer who can do an additional job pending the success of this one, i.e. there are more parts to the calculator e.g. calculating freight etc. Thank you!
Project ID: 6452325

About the project

10 proposals
Remote project
Active 10 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
Hi There I'm the Operations Manager for a Timber Import and Processing company in Auckland, and Excel is my right-hand when it comes to analyzing data or performing tricky calculations. I have developed a number of applications, including one called "Length Spread Calculator" which allows me to examine all of the different lengths of timber I have in a specific species and size, which I choose from a dropdown that lists all of the different types we have in stock. It does a number of other nifty things, but I mention this because it's very similar to your requirements. What I would do for you is create a "Main Menu" page, where you can select the calculator, which will open up a custom dialog with the dropdowns as you've specified. As you select something from a dropdown, the program will update the other dropdowns with the relevant data from the relevant sheet. At the bottom of the dialog will be two edit boxes where you enter (1) the number of flowers and (2) the exchange rate (although this could be automated too if you'd like). Et voila! Your calculation is complete. Other possible features could be a data entry sheet where you can add or update details of the different farms, and draw reports on the current stocks. If you're interested, please feel free to IM me through Freelancer, I keep an eye on my messages throughout the day, and I am available for a in-depth chat after work (around 4.30 p.m. NZ time). Regards Johnvz
$133 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
10 freelancers are bidding on average $100 AUD for this job
User Avatar
Hello I can do your task. I have experience with working on excel VBA. Thanks.
$210 AUD in 3 days
5.0 (5 reviews)
5.0
5.0
User Avatar
Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on business analysis, excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$155 AUD in 3 days
4.9 (17 reviews)
4.8
4.8
User Avatar
Hello, I would be glad to help you. Please contact me to discuss details. I have great experience with this kind of projects. Regards, Grig
$100 AUD in 2 days
5.0 (6 reviews)
3.6
3.6
User Avatar
Hi I have seen your job post and understood your requirement . Having 2 year experience with excel, I can do the job you posted within given time frame with maximum accuracy, and looking forward to work with you for longer period of time. Thanks Khushh Freelancer INDIA
$55 AUD in 2 days
5.0 (5 reviews)
3.4
3.4
User Avatar
Dear Employer, I am a dedicated freelancer from India, with over 9 years experience in excel. I have executed similar projects with 5* ratings for all. I have looked at the excel sheet you attached and understood your requirements. I can prepare a calculator to do this task. Kindly message me to discuss further. Thank you. Have a nice day.
$61 AUD in 3 days
5.0 (17 reviews)
3.3
3.3
User Avatar
Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done these type of similar projects before. Thanks Abhinov
$100 AUD in 3 days
4.8 (6 reviews)
2.9
2.9
User Avatar
Hi, I have seen the project description. I'm very much interested in doing it. I can complete it within the preferred deadline and with 100% accuracy. I have great experience with Excel and VB programming. I can do this. Please do consider my request. You wont regret for hiring me. Thanks
$45 AUD in 3 days
4.7 (11 reviews)
2.9
2.9
User Avatar
Hi, i am knowledgeable in using MS Excel, i can also do vba codes/macro to some processes. Please contact me if you are interested in hiring me. Thanks.
$100 AUD in 3 days
4.9 (13 reviews)
2.7
2.7
User Avatar
I am expert in excel and excel macros and handled complex projects. Please provide me an opportunity to work with you.
$155 AUD in 3 days
5.0 (2 reviews)
1.9
1.9
User Avatar
Hello, I have read whole description and attached spreadsheet. I am very interested in doing this job. I have been working in a US based IT firm as a financial analyst and I have a great grip on MS Excel. I will complete the calculator according to your requirements as stated in attached Spreadsheet. Let's talk further to discuss the project and my suitability for this job. Looking forward! Saghir Hussain
$100 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, WORK EXPERIENCE: VBA Projects including merging of spreadsheets, currency conversion macro, Project Maintenance sheet, Calculating Profit / Loss in shares. Done professional project presentation in powerpoint and experience of OCR Conversion Projects(115 Pages). Knowledge in MS Word, Excel & PowerPoint. Thanks, Anto
$150 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Southbank, Australia
5.0
2
Payment method verified
Member since Oct 13, 2013

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.