Finish a database where upon data entry the system will make some calculations and display it on a "form" and show some comparison charts. 4 “forms” need to be created.
1. The calculations are based on their power bill. We work out the annual cost. We compare this side by side with what we propose.
2. Lights: similar to bills we compare the existing lights annual running cost and replacement cost. We compare what they have now and what we have offer for them. It will involve some filters to be able to select the compatible products
3. Motor driven products. Simple calculation based on the existing power and some products they have. We show the potential savings.
4. Solar system. We calculate a "system" recommended Solar System size, and one we recommend and show it side by side. The client can make some selections, like split it or not. If split what percentage (30 -70; 60-40 etc), which direction and a few more user selection. All of this makes a difference in the output.
On all forms we show 1 year and 5 year savings with inflation and 25 year charts for the same. From the second form onward we show the previous forms savings, the current forms savings and an accumulative savings. The charts are for the current forms savings and the accumulative savings.
On completion we need to store all of this data and create some pdf documents and email it the clients.
Most of the clients related tables and products tables are complete.
This is an urgent job. Only apply if you can start NOW!
12 freelancers are bidding on average $183 for this job
Dear client, I have a lot of experience with VBA and Access. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA