Aged care facility: Our Organisation has engaged a developer to complete a new web site, however the developer is unable to develop one of the elements for us. We need an Interactive fee calculator that links room type (4 x room types), RAD fee (4 x based on room type) and calculates an equivalent Daily fee based on amount of RAD paid and a specified interest rate/MPIR. Once completed I will need to be able to change the Room Types, RAD amounts and MPIR as these change over time. I have attached a small spreadsheet that has 2 tabs. The input tab contains 2 input cells and 2 cells that return an automatic results.
1) Input cell 1: a drop down selection box with limited selections,
2) Auto Value A: a lookup cell that returns a value based on the item selected in first cell,
3) Input Cell 2: a cell that allows the user to add a $ value, but this should be restricted to the value returned in Auto Value A and
4) Auto Value B: a cell that calculates a daily fee based on Auto Value A minus Input cell 2 and the MPIR. Formula for this is in the spreadsheet.
Tab 2 Contains a) the List relating to Input Cell 1, b) the Lookup Values to be returned for Input Cell 2 and c) the MPIR.
You must be able to add this calculator to our new web site with is currently nearing completion.
23 фрилансеров(-а) готовы выполнить эту работу в среднем за $177
Hi there, I've gone through the project details and can code the calc for desired purpose. Have worked on similar projects before so not gonna take me too long. Ready to start. Awaiting your response !!
Hello, I could do the work without problem, if you are interested, call me to the private to ask for some details for the work and in 3 days or less I will deliver the work done, thank you, your query does not bother