{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Read Me","Cashflow","Schedule","Model","Validation","Manual","Remark"],"not_rendered":{"charts":8,"images":7,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cashflow","index":1,"n_rows":21,"n_cols":28,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["Project Name",null,"Start",null,"Finish",null,null,null,"Model",null,"Duration","Year",2008,2008,2008,2008,2008,2008,2009,2009,2009,2009,2009,2009,2009,2009,2009,2009]
[null,null,"(mm/dd/yyyy)",null,"(mm/dd/yyyy)",null,null,null,null,null,"(days)","Month",7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10]
["XXX Project",null,"2008-07-01",null,"2009-10-31",null,null,null,"S curve",null,{"$f":"E4-C4+1","v":488}]
[]
["Activity",null,"Start",null,"Finish",null,"Cost",null,"Model",null,"Duration","Cumulative Cost",437156,875086,1297403,1736380,2159471,3650457,5225175,6758842,8452410,8778843,9466871,11077906,13063450,14605812,15637201,15688665]
[null,null,"(mm/dd/yyyy)",null,"(mm/dd/yyyy)",null,"($)",null,null,null,"(days)","Monthly Cost",437156,437930,422317,438977,423091,1490986,1574718,1533667,1693568,326433,688028,1611035,1985544,1542362,1031389,51464]
["TOTAL DIVISION 1",null,"2008-07-01",null,"2009-10-01",null,1046422.2422857016,null,"straight line",null,458,null,71157,70110,69064,71157,68017,71157,70110,64878,70110,69064,70110,69064,71157,70110,69064,2093]
["TOTAL SITE WORK",null,"2008-07-01",null,"2008-12-01",null,1820890.2609487404,null,"straight line",null,154,null,365999,367820,353253,367820,355074,10925]
["TOTAL CONCRETE",null,"2008-12-01",null,"2009-04-01",null,5521982.6109109959,null,"straight line",null,122,null,null,null,null,null,null,1402584,1402584,1270056,1402584,44176]
["TOTAL MASONRY",null,"2009-05-01",null,"2009-09-01",null,942366.49468249991,null,"straight line",null,124,null,null,null,null,null,null,null,null,null,null,null,235592,228053,235592,235592,7539]
["TOTAL METAL",null,"2009-02-01",null,"2009-09-01",null,814044.34735599998,null,"straight line",null,213,null,null,null,null,null,null,null,null,106640,118850,114780,118036,114780,118850,118036,4070]
["TOTAL WOOD AND PLASTIC",null,"2009-09-01",null,"2009-10-01",null,54777.569195838107,null,"straight line",null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53025,1753]
["TOTAL THERMAL AND MOISTURE",null,"2009-06-15",null,"2009-07-15",null,856077,null,"straight line",null,31,null,null,null,null,null,null,null,null,null,null,null,null,441736,414341]
["TOTAL DOORS AND WINDOWS",null,"2009-06-01",null,"2009-09-30",null,912090.40767400002,null,"straight line",null,122,null,null,null,null,null,null,null,null,null,null,null,null,224374,231671,231671,224374]
["TOTAL FINISHES",null,"2009-06-15",null,"2009-09-30",null,984634.33729999978,null,"straight line",null,108,null,null,null,null,null,null,null,null,null,null,null,null,145726,282590,282590,273728]
["TOTAL SPECIALTIES",null,"2009-10-01",null,"2009-10-15",null,41484.49748057143,null,"straight line",null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41484]
["TOTAL EQUIPMENT",null,"2009-09-01",null,"2009-10-15",null,18421.544904000002,null,"straight line",null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12287,6134]
["TOTAL CONVEYING SYSTEMS",null,"2009-07-15",null,"2009-08-15",null,435156,null,"straight line",null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,231068,204088]
["TOTAL MECHANICAL",null,"2009-05-15",null,"2009-09-30",null,1337449.4499999997,null,"straight line",null,139,null,null,null,null,null,null,null,null,null,null,null,163169,288889,298251,298251,288889]
["TOTAL ELECTRICAL",null,"2008-12-30",null,"2009-09-30",null,902870,null,"straight line",null,275,null,null,null,null,null,null,6320,102024,92093,102024,98413,101121,98413,102024,102024,98413]

{"sheet":"Schedule","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Year - Month","Cumulative","Monthly"]
["2008-7",437156,437156]
["2008-8",875086,437930]
["2008-9",1297403,422317]
["2008-10",1736380,438977]
["2008-11",2159471,423091]
["2008-12",3650457,1490986]
["2009-1",5225175,1574718]
["2009-2",6758842,1533667]
["2009-3",8452410,1693568]
["2009-4",8778843,326433]
["2009-5",9466871,688028]
["2009-6",11077906,1611035]
["2009-7",13063450,1985544]
["2009-8",14605812,1542362]
["2009-9",15637201,1031389]
["2009-10",15688665,51464]

{"sheet":"Model","index":3,"n_rows":6,"n_cols":43,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
["Cost Model",null,"Parameters",null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,"Sum"]
["straight line",null,null,null,null,null,{"$f":"1/36","v":2.7777777777777776E-2},{"$f":"1/36","v":2.7777777777777776E-2},2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,2.7777777777777776E-2,{"$f":"SUM(G2:AP2)","v":1.0000000000000002}]
["normal",null,7,null,null,null,{"$f":"NORMDIST(G1,18,$C$3,FALSE)+(1-NORMDIST($AP$1, 18, $C$3, TRUE))*2/36","v":3.2673100959292908E-3},{"$f":"NORMDIST(H1,18,$C$3,FALSE)+(1-NORMDIST($AP$1, 18, $C$3, TRUE))*2/36","v":4.4627982178393755E-3},6.0186302766597095E-3,7.9943282869861312E-3,1.0440910003544045E-2,1.3393215065688982E-2,1.6861591214538802E-2,2.08238848920833E-2,2.5218915111016427E-2,2.9942698515845051E-2,3.4848579430694027E-2,3.9752073861459368E-2,4.4440677473540177E-2,4.8688181036071768E-2,5.2272293315885496E-2,5.4993727348560999E-2,5.6694495917996544E-2,5.7273087413878217E-2,5.6694495917996544E-2,5.4993727348560999E-2,5.2272293315885496E-2,4.8688181036071768E-2,4.4440677473540177E-2,3.9752073861459368E-2,3.4848579430694027E-2,2.9942698515845051E-2,2.5218915111016427E-2,2.08238848920833E-2,1.6861591214538802E-2,1.3393215065688982E-2,1.0440910003544045E-2,7.9943282869861312E-3,6.0186302766597095E-3,4.4627982178393755E-3,3.2673100959292908E-3,2.3705391925209823E-3,{"$f":"SUM(G3:AP3)","v":0.99987224673507824}]
["left skewed",null,2,12,null,null,{"$f":"GAMMADIST(G1,$C$4,$D$4,FALSE)+(1-GAMMADIST($AP$1, $C$4, $D$4, TRUE))/36","v":1.1921093810155409E-2},{"$f":"GAMMADIST(H1,$C$4,$D$4,FALSE)+(1-GAMMADIST($AP$1, $C$4, $D$4, TRUE))/36","v":1.7288587110281774E-2},2.1756912801171868E-2,2.5435544003438358E-2,2.8422196147493556E-2,3.0804007309319939E-2,3.2658604963052118E-2,3.4055069767827482E-2,3.5054806034638217E-2,3.5712327634706068E-2,3.6075967306421555E-2,3.6188516586042226E-2,3.6087802921660951E-2,3.5807209924530757E-2,3.537614616128882E-2,3.4820467390052109E-2,3.4162856688290152E-2,3.3423166506738572E-2,3.261872630768721E-2,3.1764619104370624E-2,3.0873929907822791E-2,2.9957968805618664E-2,2.9026471140852661E-2,2.8087777027162697E-2,2.7148992224473631E-2,2.6216132208468676E-2,2.5294251092837214E-2,2.438755690548864E-2,2.3499514576698605E-2,2.2632937867238315E-2,2.179007134671479E-2,2.0972663425517339E-2,2.018203134691967E-2,1.9419118958113032E-2,1.8684547999412111E-2,1.7978663578826194E-2,{"$f":"SUM(G4:AP4)","v":1.0055872568913327}]
["right skewed",null,2,12,null,null,{"$f":"GAMMADIST(36-G1+1,$C$5,$D$5,FALSE)+(1-GAMMADIST($AP$1, $C$5, $D$5, TRUE))/36","v":1.7978663578826194E-2},{"$f":"GAMMADIST(36-H1+1,$C$5,$D$5,FALSE)+(1-GAMMADIST($AP$1, $C$5, $D$5, TRUE))/36","v":1.8684547999412111E-2},1.9419118958113032E-2,2.018203134691967E-2,2.0972663425517339E-2,2.179007134671479E-2,2.2632937867238315E-2,2.3499514576698605E-2,2.438755690548864E-2,2.5294251092837214E-2,2.6216132208468676E-2,2.7148992224473631E-2,2.8087777027162697E-2,2.9026471140852661E-2,2.9957968805618664E-2,3.0873929907822791E-2,3.1764619104370624E-2,3.261872630768721E-2,3.3423166506738572E-2,3.4162856688290152E-2,3.4820467390052109E-2,3.537614616128882E-2,3.5807209924530757E-2,3.6087802921660951E-2,3.6188516586042226E-2,3.6075967306421555E-2,3.5712327634706068E-2,3.5054806034638217E-2,3.4055069767827482E-2,3.2658604963052118E-2,3.0804007309319939E-2,2.8422196147493556E-2,2.5435544003438358E-2,2.1756912801171868E-2,1.7288587110281774E-2,1.1921093810155409E-2,{"$f":"SUM(G5:AP5)","v":1.0055872568913329}]
["trapezoid",null,0.25,0.75,5,3,1.3370000000000001E-6,4.1446399999999997E-5,2.8210289999999999E-4,1.0441819E-3,2.8089962999999999E-3,6.2182968000000002E-3,1.2074271899999999E-2,2.1339547600000001E-2,3.5137187600000001E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,4.3859649100000002E-2,3.91668472E-2,3.0503212799999999E-2,2.2922532700000001E-2,1.6424806899999998E-2,1.10100354E-2,6.6782181999999997E-3,3.4293552999999999E-3,1.2634466999999999E-3,1.8049240000000001E-4,{"$f":"SUM(G6:AP6)","v":0.99999999979999965}]

{"sheet":"Validation","index":4,"n_rows":5,"n_cols":28,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
[259910.1675898956,200491.16790598261,312306.65340837021,426034.92758390115,585436.2220807767,742041.74375714757,804396.24147419445,1029817.3298808904,1119268.5621422492,1259673.8723080866,1292715.4027000819,1383452.2947051926,1403749.961473498,1353276.2795971725,1371064.906387005,1283092.7008032892,1266587.1690817541,1195969.9396428782,1048736.0721170129,1042520.436502818,930431.8279199861,881109.42422642186,777121.38194447756,728342.84095464647,656681.61477663741,571771.75227960944,529880.89838851988,458556.33601337299]
[345000,378250,436750,493250,561750,677500,811500.00000000012,921000,1025000,1065000,1121500,1178500,1356500,1435000,1508500,1499750,1462750,1412500,1100000,995500,886999.99999999988,803250,701750,595000,371750,359000,346750,373250]
[{"$f":"(NORMDIST(A1,15,$A$5,FALSE)+(1-NORMDIST(28, 15, $A$5, TRUE))*2/28)*25000000","v":249334.55204115843},{"$f":"(NORMDIST(B1,15,$A$5,FALSE)+(1-NORMDIST(28, 15, $A$5, TRUE))*2/28)*25000000","v":310499.09495510621},384306.72150872962,471016.12522997515,570073.46716858761,679949.22264191578,798043.80776263145,920690.83063385589,1043278.1914029893,1160493.2817050095,1266680.8707682993,1356283.6777636425,1424319.5285805301,1466838.7428164189,1481303.5302134606,1466838.7428164189,1424319.5285805301,1356283.6777636425,1266680.8707682993,1160493.2817050095,1043278.1914029893,920690.83063385589,798043.80776263145,679949.22264191578,570073.46716858761,471016.12522997515,384306.72150872962,310499.09495510621]
[7]

{"sheet":"Manual","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[1,null,"Read Me",null,"A quick guide that shows how to set up the cashflow in literally eight steps only (i.e. steps indicated by red boxes) ."]
[]
[2,null,"Cashflow",null,"Main worksheet to enter project cost/time data and view/print output cashflow charts."]
[]
[3,null,"Schedule",null,"Worksheet that lists the project time span versus (1) cost accumulated (to the end of the time period), and (2) cost occurs in that period"]
[]
[4,null,"Model",null,"Worksheet where the cost models are set up with different parameters. If a model's parameters are modified, the corresponding curve displayed in the sheet will also change to reflect the updates. When a user re-plot the cashflow sheet, the modified parameters will also be effective."]
[]
[5,null,"Validation",null,"Worksheet where the normal distribution parameter is determined by referencing two other heuristic cost models to fit the curves. "]

{"sheet":"Remark","index":6,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["This program is developed by Ken-Yu Lin Runner. Please e-mail Ken-Yu (kengyuli@hotmail.com) for any questions, comments, or bugs found."]
[]
["The terminology of left-skew and right-skew in the \"Model\" sheet is different from what is commonly interpreted in the field of statistics (for more information on the statistical contexts of left-skew and right skew, please see http://www.itl.nist.gov/div898/handbook/eda/section3/histogr6.htm). It is designed so in the program on purpose so that the terminology is more consistent with the interpretations of common users."]
[]
["Program last updated on 10.28.2009"]