Basic Report generation tool. Build data input interface & create reports in word, excel & ppt.(repost)

Build for me a simple ROI tool (for investment appraisal in lighting) which generates reports. The calculations involved are straight forward excel functions including NPV, IRR, Payback period and Economic Value Added (EVA). The actual task is the automation of report generation. However you must first build an interface to input data/information & have the calculations done in the background. The input variables are clear from the sample report & spreadsheet I have provided. Pick them from the sample report.(Sample just shows arrangement of the report). The key report will be generated in word. It will have predefined text which is made complete by the results of the computations and other variables such as company names etc. It will have NPV & IRR tables. It will also have 4 graphs of NPV & IRR cashflows, Kwh & CO2 savings. There will be 2 versions of the report ??" long form & short form. Since this report can have several types of lights, summary table should show individual measure (NPV, cost, IRR etc) while in the cashflow tables, consolidated data is used. The other report is exactly the excel sheet I have provided as an example. It should be in word with an automatic header and all other details captured automatically. Logo included. It can also be an excel workbook with summaries of the individual light types plus a summary page. All ready to print. The last report is a powerpoint presentation with summary result and graphs. Create a tab for reports where summary results can be viewed & buttons to click on to generate the desired report. I expect the input interface to be organized in Tabs. Tab 1 can contain general information about the tool. Tab 2 is for customer information. Tab 3 onwards is for luminaire type & can provide input for several types as space will allow for input of variables. The last tab will be for reports ??" view summary info & have generation buttons for each. I will provide any clarifications required. I’m not an expert but I would imagine, the input interface will feed into several excel tabs which will have an aggregation tab. From the tabs, data is picked to calculate NPV,IRR, payback etc. In turn these are fed into the reports. Let me see what you can do. Graphs: create 2 per page. One page for cashflows, the other savings. Have customer name in the graphs.

PHP XML

Project ID: #3600485

About the project