Ghazari B.

1) Gas Pipeline Project Cost Estimation Spreadsheet. The user would input pipe lengths of various sizes, valves, authority fees, station sizes and it gives a single sheet summary bill of material for the project, distribution of cost, rough Investment Return Analysis as well as estimated duration from start to finish. 2) Automated formating and reporting. Formats an excel datasheet generated by in house gas network simuation software in to a standardized report. Highlights critical cells containing lowest pressure point and links to an existing database within MS network in order to ease comparision of software result & actual reading of pressure. 3) Automated gas usage history graph generation at a click of cell containing customer name list. User can define the resolution of history as well as set trendlines at cell C1 through H1 (attached & its partial code) 4) Automated data manipulation. Making a pivot table, selecting fields and filtering some fileds. 5) Summarizing one set of tables into another format required by reporting structure. Referencing another file for Vlookup formula.