Modify Excel Macros/Visual Basic calculations sheet
$10-30 AUD
Paid on delivery
We have an Excel Sheet which we use for calculating things.
We need added in/modified:
- When we press calculate the lines that it calculates out are numbered.
- A reset button that resets four values. 50,50,65,16
This next one is not as straight forward and is a little tricky.
The current line values that it produces is like this.
1 0.00 165.60 165.60
2 165.60 165.60 331.20
3 331.20 165.60 496.80
4 496.80 165.60 662.40
5 662.40 165.60 828.00
6 828.00 165.60 993.60
7 993.60 165.60 1159.20
8 1159.20 165.60 1324.80
We need the ability to punch in 2,2,2 into a cell on the sheet, which then when the macro is working out the line calculations it adds on another column and calculates an extra value which is just dividing a cell by two before adding the cell on. (minor modification to the current calculation)
1 0.00 165.60 165.60
2 165.60 165.60 331.20
3 331.20 165.60 496.80 464.30
4 496.80 165.60 662.40
5 662.40 165.60 828.00
6 828.00 165.60 993.60 961.1
7 993.60 165.60 1159.20
8 1159.20 165.60 1324.80
Need this sorted today within the next few hours, if you can't sort it today in the next few hours don't bother bidding.
Project ID: #13499699
About the project
4 freelancers are bidding on average $33 for this job
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More
