I require an excel expert to help me calculate a bill.
The first guy didnt have the skills to finish.
On the first sheet(billmax) it will have all of the formulas and totals.
I’ve already created the layout of the totals but will need the formulas and macros to retrieve the right amount for the bill.
The totals will be calculated from a bill that is provided on the next excel sheet.
Suit someone with advanced knowledge in mathematics and excel.
Most of the work is done, you just need to finish this off.
just updated the excel sheet at http://automax.tv/joini3.xlsm
what will happen is the first sheet will list the totals.
There are 5 telephone plans that take the values from
b12 to k23.
These values determine the cost of the bill.
Now the bill values come from sheet1. These has the types of calls , stds, locals.
So the first sheet will need to call the third sheet and any sheet that is added.
The main values are the
1) Call type
2) Duration
3) Time of call
4) Some calls are timed in 30 second and others in 1min block.
5) Need if formulas if duration is past an amount.
The goal of the project is to insert a bill and then calculate which plan will save the most money.
Need someone to start asap and finish soon.