I need a tool reviewed and updated
- or -
Post a project like this2254
$50
- Posted:
- Proposals: 6
- Remote
- #1878132
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
Description of excel work: I need someone to review the attached excel tool and cross-check the following:
• Formulas and codes
• Validations
• Macros
• Ensure that the entry form works and populates all required fields after entry
• All calculations are accurate and populated the desired results
• Graphs and charts are accurate and populates desired results
Also, I would like the following edits to be made:
• Addition of a line graph for the Cashflow page
• Validation code that ensures quantity sold is =< quantity processed and that quantity is =< total tonnes harvested for each the crop specified.
• Validation code that ensures that the breakdown of the sales at a point in time is =< the total sales highlighted above?
• Addition of an update button for previous entries
• Move the add button to the last page on the data entry form
A few quick notes:
• A brief background about the use of the tool is in the introduction page.
• The sheets are protected but without a password so they can be unlocked before reviews
• Sheet names are hidden, so you will need to open it
• VBA was used to create the data entry form, so any updates on this will need to be done from developer
I would like to be notified before any major changes are made and I need this completed 48-hours post award of contract.
I'm available to answer any questions you might have.
Extra notes:
• Formulas and codes
• Validations
• Macros
• Ensure that the entry form works and populates all required fields after entry
• All calculations are accurate and populated the desired results
• Graphs and charts are accurate and populates desired results
Also, I would like the following edits to be made:
• Addition of a line graph for the Cashflow page
• Validation code that ensures quantity sold is =< quantity processed and that quantity is =< total tonnes harvested for each the crop specified.
• Validation code that ensures that the breakdown of the sales at a point in time is =< the total sales highlighted above?
• Addition of an update button for previous entries
• Move the add button to the last page on the data entry form
A few quick notes:
• A brief background about the use of the tool is in the introduction page.
• The sheets are protected but without a password so they can be unlocked before reviews
• Sheet names are hidden, so you will need to open it
• VBA was used to create the data entry form, so any updates on this will need to be done from developer
I would like to be notified before any major changes are made and I need this completed 48-hours post award of contract.
I'm available to answer any questions you might have.
Extra notes:
Okeoghene A.
100% (3)Projects Completed
3
Freelancers worked with
2
Projects awarded
50%
Last project
8 May 2019
Nigeria
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