Upgrade excel product pricing spreadsheets for manufacturing business
- or -
Post a project like this£25/hr(approx. $31/hr)
- Posted:
- Proposals: 19
- Remote
- #2192974
- Expired
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
1449433248299324628772435389233277822235642195169196367918894541792694964751394015
Description
Experience Level: Intermediate
We are a metal manufacturing business based in London, but run from offices in East Sussex.
We have a number of pricing and calculation spreadsheets, which we would like to upgrade.
They currently contain vlookups, selective drop-downs and IF statements BUT i'd like to add the following:
1. Sheet protection so users can save and clear a spreadsheet without deleting formulas
2. Each time a user saves a price for a particular job, the quote is to be saved to another sheet within excel with the tab named with the job number and initials of the person who created the quote and the entry sheet cleared
3. Rewrite some of the formulas to reduce the calculation steps
Most of the calculators are written and just need tweaking, others will need to be developed from scratch.
For the most part you would be working with converting areas (square mm to square feet), but all the formulas will be provided.
Ideally, you would be local to Hastings (or be able to travel to us) as i think being able to discuss face-to-face would be a real bonus.
NOTE: This is an interim stage before all are integrated into our upgraded website. Please email some examples of previous work.
We have a number of pricing and calculation spreadsheets, which we would like to upgrade.
They currently contain vlookups, selective drop-downs and IF statements BUT i'd like to add the following:
1. Sheet protection so users can save and clear a spreadsheet without deleting formulas
2. Each time a user saves a price for a particular job, the quote is to be saved to another sheet within excel with the tab named with the job number and initials of the person who created the quote and the entry sheet cleared
3. Rewrite some of the formulas to reduce the calculation steps
Most of the calculators are written and just need tweaking, others will need to be developed from scratch.
For the most part you would be working with converting areas (square mm to square feet), but all the formulas will be provided.
Ideally, you would be local to Hastings (or be able to travel to us) as i think being able to discuss face-to-face would be a real bonus.
NOTE: This is an interim stage before all are integrated into our upgraded website. Please email some examples of previous work.
Decomet Ltd t/a J.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
27 Apr 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies