I have a financial spreadsheet that allows small organisations to track financial information on a per project basis.
It has a front page that asks a list of financial / project based questions and then creates a spreadsheet based on the time that a project will be delivered over.
I want to reprogram this into a web based application and do away with using a spreadsheet program altogether.
I require a webpage that will have a list of questions once you have answered all the question a submit button is pressed and a page is then produced, laid out like a spreadsheet.
On this page will be a button that creates an A4 sized PDF of the results in the format of a spreadsheet for printing or as a report to distribute.
However if the organisation needs to change/adjust figures or remove projects as they go along we would need to present a webpage for each project to enable them to change the figures and then remake the PDF's for printing and distribution.
We need to present a webpage for each project and an overall webpage where all the projects data is merged together to give an overview based on all projects.
As projects are added or removed a webpage is created for each project and a Yearly page is created with all the data merged again a button that creates a PDF giving the organisation a pdf of individual projects and another PDF of all projects combined offering an overview of its financial position.
I have attached some pictures from the Microsoft Excel spreadsheet that you can look.
I will supply the winner with a copy of the Microsoft excel spreadsheet as a model of the end product.