{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Blank Time Chart","Example Time Chart"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Instructions","index":0,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Instructions for Contract Time for Completion Spreadsheet"]
[]
["See FDM 19-10-30 for general information on the Contract Time for Completion analysis."]
[]
["1.  The form is locked.  Information can only be entered in the yellow shaded cells."]
["2.  Enter project information at the top of the form."]
["3.  Enter controlling items on left side of page under Item Analysis."]
["4.  Enter item quantities for each stage (all stages do not need to be used)."]
["5.  Enter item units and production rates (see FDM 19-10 Attachment 30.3 for example rates)."]
["6.  Enter begin day for each item and stage (the end date will be calculated automatically). Tip: You can use a formula here, for instance to start Item 2 when Item 1 is done, you would enter =W30 in cell V31.  That way if you add 2 days to Item 1, the start date for Item 2 will automatically adjust by 2 days."]
["7.  If the default \"Stage 1\", \"Stage 2\", etc., doesn't work for your project, you can edit them in the yellow shaded cells.  The legend and other column headings will update automatically."]
["8.  Enter the construction year at the bottom of the page to automatically fill out all the Begin and End dates for each month.  Then, delete Begin and End dates for months before the start date or after the completion date.  Change the Begin date for the applicable month to the actual probable date of beginning and change the End date for the applicable month to the anticipated completion date.  Under the Month column, delete names for unused months (those with no working days) to remove the labels from the Gantt Chart."]
["9.  Enter number of holidays days each month."]
["10.  Enter probable working day percentage based on the work type (see FDM 19-10 Attachment 30.2)."]
["11.  Enter remarks as necessary."]
["12. Enter number of calendar days, working days, and completion date based on the time of completion chart."]
["13.  To get rid of extra days (blank space) on the right side of the Gantt Chart, right click on the top axis and select \"Format Axis\".  Under \"Axis Options\", Change \"Maximum\" from \"Auto\" to \"Fixed\" and set the value to the total number of working days for the contract."]
[]
["Contact David Layton (david.layton@dot.wi.gov) with any suggested revisions to this form."]
[]
[]
[]
[]
[]
["Release Notes"]
["10/2009 - Fixed Stage 3 formula error"]
["01/2010 - Added ability to rename stages."]
["09/2010 - Updated FDM links to account for FDM file revisions."]

{"sheet":"Blank Time Chart","index":1,"n_rows":75,"n_cols":37,"rows_kept":75,"cut":false,"hidden":false,"merged":[[31,0,31,1],[31,9,31,10],[42,9,42,10],[45,9,45,10],[0,0,0,29],[1,0,1,29],[3,1,3,2],[3,5,3,6],[3,10,3,21],[3,27,3,29],[29,28,29,29],[4,1,4,2],[4,5,4,6],[4,10,4,21],[4,27,4,29],[29,0,30,1],[29,20,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[28,0,28,29],[29,2,29,6],[29,7,30,7],[29,8,30,8],[29,9,30,10],[29,11,30,19],[32,0,32,1],[32,9,32,10],[35,9,35,10],[33,9,33,10],[34,9,34,10],[56,9,56,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[55,0,55,1],[55,9,55,10],[42,0,42,1],[36,9,36,10],[37,9,37,10],[38,9,38,10],[41,9,41,10],[44,9,44,10],[43,9,43,10],[53,0,53,1],[53,9,53,10],[54,0,54,1],[54,9,54,10],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[39,9,39,10],[45,0,45,1],[46,0,46,1],[52,0,52,1],[52,9,52,10],[59,23,59,29],[60,23,68,29],[69,27,69,29],[57,9,57,10],[59,1,59,2],[59,3,59,5],[59,7,59,9],[74,8,74,9],[70,27,70,29],[71,27,71,29],[72,27,72,29],[72,10,72,19]]}
["CONTRACT TIME FOR COMPLETION"]
["Wisconsin Department of Transportation      DT1923      04/2011"]
[]
["Project ID","1430-18-71/1430-23-71",null,null,"Highway","STH 23",null,null,null,"Project Title","Rosendale - Fond du Lac/Village of Rosendale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Letting","2018-05-08"]
["Work Type","Resurface",null,null,"County","Fond du Lac",null,null,null,"Project Limits","Lafayette - Becker Blvd/Becker Blvd - Townline Rd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probable Date of Beginning","2018-06-18"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ITEM ANALYSIS"]
["Item",null,"Contract Quantity per Stage",null,null,null,null,"Total Quantity","Unit","Production Rate",null,"Working Days\n(per Stage)",null,null,null,null,null,null,null,null,"Stage 1",null,"Stage 2",null,"Stage 3",null,"Stage 4",null,"Stage 5"]
[null,null,{"$f":"U30","v":"Stage 1"},{"$f":"W30","v":"Stage 2"},{"$f":"Y30","v":"Stage 3"},{"$f":"AA30","v":"Stage 4"},{"$f":"AC30","v":"Stage 5"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Begin","End","Begin","End","Begin","End","Begin","End","Begin","End",null,null,"Gap 1","Gap 2","Gap 3","Gap 4","Gap 5"]
["Traffic Control",null,1,1,1,1,null,{"$f":"IF(AND(ISBLANK(C32),ISBLANK(D32),ISBLANK(E32),ISBLANK(F32),ISBLANK(G32)),\"\",SUM(C32:G32))","v":4},"DAY",1,null,{"$f":"IF(ISBLANK(C32),\"\",ROUNDUP(C32/$J32,0))","v":1},"/",{"$f":"IF(ISBLANK(D32),\"\",ROUNDUP(D32/$J32,0))","v":1},"/",{"$f":"IF(ISBLANK(E32),\"\",ROUNDUP(E32/$J32,0))","v":1},"/",{"$f":"IF(ISBLANK(F32),\"\",ROUNDUP(F32/$J32,0))","v":1},"/",{"$f":"IF(ISBLANK(G32),\"\",ROUNDUP(G32/$J32,0))","v":""},1,{"$f":"IF(ISBLANK(U32),\"\",U32+L32)","v":2},18,{"$f":"IF(ISBLANK(W32),\"\",W32+N32)","v":19},34,{"$f":"IF(ISBLANK(Y32),\"\",Y32+P32)","v":35},46,{"$f":"IF(ISBLANK(AA32),\"\",AA32+R32)","v":47},null,{"$f":"IF(ISBLANK(AC32),\"\",AC32+T32)","v":""},null,null,{"$f":"U32","v":1},{"$f":"IF(W32>0,IF(V32=\"\",W32,W32-V32),0)","v":16},{"$f":"IF(Y32>0,IF(X32=\"\",IF(V32=\"\",Y32,Y32-V32),Y32-X32),0)","v":15},{"$f":"IF(AA32>0,IF(Z32=\"\",IF(X32=\"\",IF(V32=\"\",AA32,AA32-V32),AA32-X32),AA32-Z32),0)","v":11},{"$f":"IF(AC32>0,IF(AB32=\"\",IF(Z32=\"\",IF(X32=\"\",IF(V32=\"\",AC32,AC32-V32),AC32-X32),AC32-Z32),AC32-AB32),0)","v":0}]
["1430-23-71",null,null,null,null,null,null,"",null,null,null,"","/","","/","","/","","/",{"$f":"IF(ISBLANK(G33),\"\",ROUNDUP(G33/$J33,0))","v":""},null,{"$f":"IF(ISBLANK(U33),\"\",U33+L33)","v":""},null,{"$f":"IF(ISBLANK(W33),\"\",W33+N33)","v":""},null,{"$f":"IF(ISBLANK(Y33),\"\",Y33+P33)","v":""},null,{"$f":"IF(ISBLANK(AA33),\"\",AA33+R33)","v":""},null,{"$f":"IF(ISBLANK(AC33),\"\",AC33+T33)","v":""}," ",null,{"$f":"U33","v":0},{"$f":"IF(W33>0,IF(V33=\"\",W33,W33-V33),0)","v":0},{"$f":"IF(Y33>0,IF(X33=\"\",IF(V33=\"\",Y33,Y33-V33),Y33-X33),0)","v":0},{"$f":"IF(AA33>0,IF(Z33=\"\",IF(X33=\"\",IF(V33=\"\",AA33,AA33-V33),AA33-X33),AA33-Z33),0)","v":0},{"$f":"IF(AC33>0,IF(AB33=\"\",IF(Z33=\"\",IF(X33=\"\",IF(V33=\"\",AC33,AC33-V33),AC33-X33),AC33-Z33),AC33-AB33),0)","v":0}]
[" -Storm Sewer structures",null,4,1,null,null,null,5,"EACH",3,null,2,"/",1,"/","","/","","/",{"$f":"IF(ISBLANK(G34),\"\",ROUNDUP(G34/$J34,0))","v":""},1,{"$f":"IF(ISBLANK(U34),\"\",U34+L34)","v":3},18,19,null,"",null,"",null,"",null,null,1,15,{"$f":"IF(Y34>0,IF(X34=\"\",IF(V34=\"\",Y34,Y34-V34),Y34-X34),0)","v":0},0,0]
[" -Storm Sewer pipe",null,54,8,null,null,null,62,"LF",50,null,2,"/",1,"/","","/","","/","",1,3,18,19,null,"",null,"",null,"",null,null,1,15,0,0,0]
[" -Removing Asph. Surf. Milling",null,null,5543,5179,null,null,{"$f":"IF(AND(ISBLANK(C36),ISBLANK(D36),ISBLANK(E36),ISBLANK(F36),ISBLANK(G36)),\"\",SUM(C36:G36))","v":10722},"SY",10000,null,{"$f":"IF(ISBLANK(C36),\"\",ROUNDUP(C36/$J36,0))","v":""},"/",{"$f":"IF(ISBLANK(D36),\"\",ROUNDUP(D36/$J36,0))","v":1},"/",{"$f":"IF(ISBLANK(E36),\"\",ROUNDUP(E36/$J36,0))","v":1},"/",{"$f":"IF(ISBLANK(F36),\"\",ROUNDUP(F36/$J36,0))","v":""},"/",{"$f":"IF(ISBLANK(G36),\"\",ROUNDUP(G36/$J36,0))","v":""},null,{"$f":"IF(ISBLANK(U36),\"\",U36+L36)","v":""},19,{"$f":"IF(ISBLANK(W36),\"\",W36+N36)","v":20},34,{"$f":"IF(ISBLANK(Y36),\"\",Y36+P36)","v":35},null,{"$f":"IF(ISBLANK(AA36),\"\",AA36+R36)","v":""},null,{"$f":"IF(ISBLANK(AC36),\"\",AC36+T36)","v":""},null,null,{"$f":"U36","v":0},{"$f":"IF(W36>0,IF(V36=\"\",W36,W36-V36),0)","v":19},{"$f":"IF(Y36>0,IF(X36=\"\",IF(V36=\"\",Y36,Y36-V36),Y36-X36),0)","v":14},{"$f":"IF(AA36>0,IF(Z36=\"\",IF(X36=\"\",IF(V36=\"\",AA36,AA36-V36),AA36-X36),AA36-Z36),0)","v":0},{"$f":"IF(AC36>0,IF(AB36=\"\",IF(Z36=\"\",IF(X36=\"\",IF(V36=\"\",AC36,AC36-V36),AC36-X36),AC36-Z36),AC36-AB36),0)","v":0}]
[" -HMA",null,null,974,1057,null,null,2031,"TON",1100,null,"","/",1,"/",1,"/","","/","",null,"",20,21,35,36,null,"",null,"",null,null,0,20,14,0,0]
[" -BASE AGG",null,null,335,335,null,null,670,"TON",500,null,"","/",1,"/",1,"/","","/","",null,"",21,22,36,37,null,"",null,"",null,null,0,21,14,0,0]
[" -PAVEMENT MARKING",null,null,null,null,16346,null,16346,"LF",8200,null,"","/","","/","","/",2,"/","",null,"",null,"",null,"",46,48,null,"",null,null,0,0,0,46,0]
["sidewalk/curb ramps",null,null,null,6,null,null,{"$f":"IF(AND(ISBLANK(C40),ISBLANK(D40),ISBLANK(E40),ISBLANK(F40),ISBLANK(G40)),\"\",SUM(C40:G40))","v":6},"EACH",0.25,null,{"$f":"IF(ISBLANK(C40),\"\",ROUNDUP(C40/$J40,0))","v":""},"/",{"$f":"IF(ISBLANK(D40),\"\",ROUNDUP(D40/$J40,0))","v":""},"/",{"$f":"IF(ISBLANK(E40),\"\",ROUNDUP(E40/$J40,0))","v":24},"/",{"$f":"IF(ISBLANK(F40),\"\",ROUNDUP(F40/$J40,0))","v":""},"/",{"$f":"IF(ISBLANK(G40),\"\",ROUNDUP(G40/$J40,0))","v":""},null,{"$f":"IF(ISBLANK(U40),\"\",U40+L40)","v":""},null,{"$f":"IF(ISBLANK(W40),\"\",W40+N40)","v":""},35,{"$f":"IF(ISBLANK(Y40),\"\",Y40+P40)","v":59},null,{"$f":"IF(ISBLANK(AA40),\"\",AA40+R40)","v":""},null,{"$f":"IF(ISBLANK(AC40),\"\",AC40+T40)","v":""},null,null,{"$f":"U40","v":0},{"$f":"IF(W40>0,IF(V40=\"\",W40,W40-V40),0)","v":0},{"$f":"IF(Y40>0,IF(X40=\"\",IF(V40=\"\",Y40,Y40-V40),Y40-X40),0)","v":35},{"$f":"IF(AA40>0,IF(Z40=\"\",IF(X40=\"\",IF(V40=\"\",AA40,AA40-V40),AA40-X40),AA40-Z40),0)","v":0},{"$f":"IF(AC40>0,IF(AB40=\"\",IF(Z40=\"\",IF(X40=\"\",IF(V40=\"\",AC40,AC40-V40),AC40-X40),AC40-Z40),AC40-AB40),0)","v":0}]
[]
["1430-18-71",null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(C42),ISBLANK(D42),ISBLANK(E42),ISBLANK(F42),ISBLANK(G42)),\"\",SUM(C42:G42))","v":""},null,null,null,{"$f":"IF(ISBLANK(C42),\"\",ROUNDUP(C42/$J42,0))","v":""},"/",{"$f":"IF(ISBLANK(D42),\"\",ROUNDUP(D42/$J42,0))","v":""},"/",{"$f":"IF(ISBLANK(E42),\"\",ROUNDUP(E42/$J42,0))","v":""},"/",{"$f":"IF(ISBLANK(F42),\"\",ROUNDUP(F42/$J42,0))","v":""},"/",{"$f":"IF(ISBLANK(G42),\"\",ROUNDUP(G42/$J42,0))","v":""},null,{"$f":"IF(ISBLANK(U42),\"\",U42+L42)","v":""},null,"",null,"",null,"",null,"",null,null,0,0,{"$f":"IF(Y42>0,IF(X42=\"\",IF(V42=\"\",Y42,Y42-V42),Y42-X42),0)","v":0},0,0]
["SAWING",null,7340,null,null,null,null,{"$f":"IF(AND(ISBLANK(C43),ISBLANK(D43),ISBLANK(E43),ISBLANK(F43),ISBLANK(G43)),\"\",SUM(C43:G43))","v":7340},"LF",1500,null,{"$f":"IF(ISBLANK(C43),\"\",ROUNDUP(C43/$J43,0))","v":5},"/",{"$f":"IF(ISBLANK(D43),\"\",ROUNDUP(D43/$J43,0))","v":""},"/",{"$f":"IF(ISBLANK(E43),\"\",ROUNDUP(E43/$J43,0))","v":""},"/",{"$f":"IF(ISBLANK(F43),\"\",ROUNDUP(F43/$J43,0))","v":""},"/",{"$f":"IF(ISBLANK(G43),\"\",ROUNDUP(G43/$J43,0))","v":""},1,{"$f":"IF(ISBLANK(U43),\"\",U43+L43)","v":6},null,{"$f":"IF(ISBLANK(W43),\"\",W43+N43)","v":""},null,{"$f":"IF(ISBLANK(Y43),\"\",Y43+P43)","v":""},null,{"$f":"IF(ISBLANK(AA43),\"\",AA43+R43)","v":""},null,{"$f":"IF(ISBLANK(AC43),\"\",AC43+T43)","v":""},null,null,{"$f":"U43","v":1},{"$f":"IF(W43>0,IF(V43=\"\",W43,W43-V43),0)","v":0},{"$f":"IF(Y43>0,IF(X43=\"\",IF(V43=\"\",Y43,Y43-V43),Y43-X43),0)","v":0},{"$f":"IF(AA43>0,IF(Z43=\"\",IF(X43=\"\",IF(V43=\"\",AA43,AA43-V43),AA43-X43),AA43-Z43),0)","v":0},{"$f":"IF(AC43>0,IF(AB43=\"\",IF(Z43=\"\",IF(X43=\"\",IF(V43=\"\",AC43,AC43-V43),AC43-X43),AC43-Z43),AC43-AB43),0)","v":0}]
["Removing Asph. Deck Overlay",null,327,327,null,null,null,{"$f":"IF(AND(ISBLANK(C44),ISBLANK(D44),ISBLANK(E44),ISBLANK(F44),ISBLANK(G44)),\"\",SUM(C44:G44))","v":654},"LF",327,null,{"$f":"IF(ISBLANK(C44),\"\",ROUNDUP(C44/$J44,0))","v":1},"/",{"$f":"IF(ISBLANK(D44),\"\",ROUNDUP(D44/$J44,0))","v":1},"/",{"$f":"IF(ISBLANK(E44),\"\",ROUNDUP(E44/$J44,0))","v":""},"/",{"$f":"IF(ISBLANK(F44),\"\",ROUNDUP(F44/$J44,0))","v":""},"/",{"$f":"IF(ISBLANK(G44),\"\",ROUNDUP(G44/$J44,0))","v":""},1,{"$f":"IF(ISBLANK(U44),\"\",U44+L44)","v":2},18,{"$f":"IF(ISBLANK(W44),\"\",W44+N44)","v":19},null,{"$f":"IF(ISBLANK(Y44),\"\",Y44+P44)","v":""},null,{"$f":"IF(ISBLANK(AA44),\"\",AA44+R44)","v":""},null,{"$f":"IF(ISBLANK(AC44),\"\",AC44+T44)","v":""}]
["deck prep",null,327,327,null,null,null,{"$f":"IF(AND(ISBLANK(C45),ISBLANK(D45),ISBLANK(E45),ISBLANK(F45),ISBLANK(G45)),\"\",SUM(C45:G45))","v":654},"SY",50,null,{"$f":"IF(ISBLANK(C45),\"\",ROUNDUP(C45/$J45,0))","v":7},"/",{"$f":"IF(ISBLANK(D45),\"\",ROUNDUP(D45/$J45,0))","v":7},"/",{"$f":"IF(ISBLANK(E45),\"\",ROUNDUP(E45/$J45,0))","v":""},"/",{"$f":"IF(ISBLANK(F45),\"\",ROUNDUP(F45/$J45,0))","v":""},"/",{"$f":"IF(ISBLANK(G45),\"\",ROUNDUP(G45/$J45,0))","v":""},2,{"$f":"IF(ISBLANK(U45),\"\",U45+L45)","v":9},19,{"$f":"IF(ISBLANK(W45),\"\",W45+N45)","v":26},null,{"$f":"IF(ISBLANK(Y45),\"\",Y45+P45)","v":""},null,{"$f":"IF(ISBLANK(AA45),\"\",AA45+R45)","v":""},null,{"$f":"IF(ISBLANK(AC45),\"\",AC45+T45)","v":""}]
["bridge overlay",null,45,46,null,null,null,{"$f":"IF(AND(ISBLANK(C46),ISBLANK(D46),ISBLANK(E46),ISBLANK(F46),ISBLANK(G46)),\"\",SUM(C46:G46))","v":91},"CY",45,null,{"$f":"IF(ISBLANK(C46),\"\",ROUNDUP(C46/$J46,0))","v":1},"/",{"$f":"IF(ISBLANK(D46),\"\",ROUNDUP(D46/$J46,0))","v":2},"/",{"$f":"IF(ISBLANK(E46),\"\",ROUNDUP(E46/$J46,0))","v":""},"/",{"$f":"IF(ISBLANK(F46),\"\",ROUNDUP(F46/$J46,0))","v":""},"/",{"$f":"IF(ISBLANK(G46),\"\",ROUNDUP(G46/$J46,0))","v":""},9,{"$f":"IF(ISBLANK(U46),\"\",U46+L46)","v":10},26,{"$f":"IF(ISBLANK(W46),\"\",W46+N46)","v":28},null,{"$f":"IF(ISBLANK(Y46),\"\",Y46+P46)","v":""},null,{"$f":"IF(ISBLANK(AA46),\"\",AA46+R46)","v":""},null,{"$f":"IF(ISBLANK(AC46),\"\",AC46+T46)","v":""},null,null,{"$f":"U46","v":9},{"$f":"IF(W46>0,IF(V46=\"\",W46,W46-V46),0)","v":16},{"$f":"IF(Y46>0,IF(X46=\"\",IF(V46=\"\",Y46,Y46-V46),Y46-X46),0)","v":0},{"$f":"IF(AA46>0,IF(Z46=\"\",IF(X46=\"\",IF(V46=\"\",AA46,AA46-V46),AA46-X46),AA46-Z46),0)","v":0},{"$f":"IF(AC46>0,IF(AB46=\"\",IF(Z46=\"\",IF(X46=\"\",IF(V46=\"\",AC46,AC46-V46),AC46-X46),AC46-Z46),AC46-AB46),0)","v":0}]
["Removing Asph. Surf. Milling",null,null,75000,75000,null,null,{"$f":"IF(AND(ISBLANK(C47),ISBLANK(D47),ISBLANK(E47),ISBLANK(F47),ISBLANK(G47)),\"\",SUM(C47:G47))","v":150000},"SY",10000,null,{"$f":"IF(ISBLANK(C47),\"\",ROUNDUP(C47/$J47,0))","v":""},"/",{"$f":"IF(ISBLANK(D47),\"\",ROUNDUP(D47/$J47,0))","v":8},"/",{"$f":"IF(ISBLANK(E47),\"\",ROUNDUP(E47/$J47,0))","v":8},"/",{"$f":"IF(ISBLANK(F47),\"\",ROUNDUP(F47/$J47,0))","v":""},"/",{"$f":"IF(ISBLANK(G47),\"\",ROUNDUP(G47/$J47,0))","v":""},null,{"$f":"IF(ISBLANK(U47),\"\",U47+L47)","v":""},20,28,35,43,null,"",null,"",null,null,0,20,{"$f":"IF(Y47>0,IF(X47=\"\",IF(V47=\"\",Y47,Y47-V47),Y47-X47),0)","v":7},0,0]
["Removing Asph. Surface",null,null,1100,1000,null,null,{"$f":"IF(AND(ISBLANK(C48),ISBLANK(D48),ISBLANK(E48),ISBLANK(F48),ISBLANK(G48)),\"\",SUM(C48:G48))","v":2100},"SY",600,null,{"$f":"IF(ISBLANK(C48),\"\",ROUNDUP(C48/$J48,0))","v":""},"/",{"$f":"IF(ISBLANK(D48),\"\",ROUNDUP(D48/$J48,0))","v":2},"/",{"$f":"IF(ISBLANK(E48),\"\",ROUNDUP(E48/$J48,0))","v":2},"/",{"$f":"IF(ISBLANK(F48),\"\",ROUNDUP(F48/$J48,0))","v":""},"/",{"$f":"IF(ISBLANK(G48),\"\",ROUNDUP(G48/$J48,0))","v":""},null,{"$f":"IF(ISBLANK(U48),\"\",U48+L48)","v":""},20,{"$f":"IF(ISBLANK(W48),\"\",W48+N48)","v":22},35,{"$f":"IF(ISBLANK(Y48),\"\",Y48+P48)","v":37},null,{"$f":"IF(ISBLANK(AA48),\"\",AA48+R48)","v":""},null,{"$f":"IF(ISBLANK(AC48),\"\",AC48+T48)","v":""},null,null,{"$f":"U48","v":0},{"$f":"IF(W48>0,IF(V48=\"\",W48,W48-V48),0)","v":20},{"$f":"IF(Y48>0,IF(X48=\"\",IF(V48=\"\",Y48,Y48-V48),Y48-X48),0)","v":13},{"$f":"IF(AA48>0,IF(Z48=\"\",IF(X48=\"\",IF(V48=\"\",AA48,AA48-V48),AA48-X48),AA48-Z48),0)","v":0},{"$f":"IF(AC48>0,IF(AB48=\"\",IF(Z48=\"\",IF(X48=\"\",IF(V48=\"\",AC48,AC48-V48),AC48-X48),AC48-Z48),AC48-AB48),0)","v":0}]
["concrete base patching",null,2300,2300,null,null,null,4600,"SY",150,null,16,"/",16,"/","","/","","/","",2,18,18,34,null,"",null,"",null,"",null,null,2,0,0,0,0]
["culvert pipes",null,11,null,null,null,null,{"$f":"IF(AND(ISBLANK(C50),ISBLANK(D50),ISBLANK(E50),ISBLANK(F50),ISBLANK(G50)),\"\",SUM(C50:G50))","v":11},"EACH",2,null,{"$f":"IF(ISBLANK(C50),\"\",ROUNDUP(C50/$J50,0))","v":6},"/",{"$f":"IF(ISBLANK(D50),\"\",ROUNDUP(D50/$J50,0))","v":""},"/",{"$f":"IF(ISBLANK(E50),\"\",ROUNDUP(E50/$J50,0))","v":""},"/",{"$f":"IF(ISBLANK(F50),\"\",ROUNDUP(F50/$J50,0))","v":""},"/",{"$f":"IF(ISBLANK(G50),\"\",ROUNDUP(G50/$J50,0))","v":""},3,{"$f":"IF(ISBLANK(U50),\"\",U50+L50)","v":9},null,{"$f":"IF(ISBLANK(W50),\"\",W50+N50)","v":""},null,{"$f":"IF(ISBLANK(Y50),\"\",Y50+P50)","v":""},null,{"$f":"IF(ISBLANK(AA50),\"\",AA50+R50)","v":""},null,{"$f":"IF(ISBLANK(AC50),\"\",AC50+T50)","v":""},null,null,{"$f":"U50","v":3},{"$f":"IF(W50>0,IF(V50=\"\",W50,W50-V50),0)","v":0},{"$f":"IF(Y50>0,IF(X50=\"\",IF(V50=\"\",Y50,Y50-V50),Y50-X50),0)","v":0},{"$f":"IF(AA50>0,IF(Z50=\"\",IF(X50=\"\",IF(V50=\"\",AA50,AA50-V50),AA50-X50),AA50-Z50),0)","v":0},{"$f":"IF(AC50>0,IF(AB50=\"\",IF(Z50=\"\",IF(X50=\"\",IF(V50=\"\",AC50,AC50-V50),AC50-X50),AC50-Z50),AC50-AB50),0)","v":0}]
["HMA",null,null,22500,22500,null,null,45000,"TON",3000,null,"","/",8,"/",8,"/","","/","",null,"",21,29,36,44,null,"",null,"",null,null,0,21,7,0,0]
["base agg ",null,null,3000,3000,null,null,6000,"TON",1500,null,"","/",2,"/",2,"/","","/","",null,"",29,31,44,46,null,"",null,"",null,null,0,29,13,0,0]
["landscaping",null,null,null,null,10000,null,10000,"SY",5000,null,"","/","","/","","/",2,"/","",null,"",null,"",null,"",46,48,null,"",null,null,0,0,0,46,0]
["CL rumble strips",null,null,null,null,33200,null,33200,"LF",10000,null,"","/","","/","","/",4,"/","",null,"",null,"",null,"",46,50,null,"",null,null,0,0,0,46,0]
["shoulder runble strips",null,null,null,null,54900,null,54900,"LF",10000,null,"","/","","/","","/",6,"/","",null,"",null,"",null,"",50,56,null,"",null,null,0,0,0,50,0]
["pavement marking",null,null,null,null,115000,null,{"$f":"IF(AND(ISBLANK(C56),ISBLANK(D56),ISBLANK(E56),ISBLANK(F56),ISBLANK(G56)),\"\",SUM(C56:G56))","v":115000},"LF",15000,null,{"$f":"IF(ISBLANK(C56),\"\",ROUNDUP(C56/$J56,0))","v":""},"/",{"$f":"IF(ISBLANK(D56),\"\",ROUNDUP(D56/$J56,0))","v":""},"/",{"$f":"IF(ISBLANK(E56),\"\",ROUNDUP(E56/$J56,0))","v":""},"/",{"$f":"IF(ISBLANK(F56),\"\",ROUNDUP(F56/$J56,0))","v":8},"/",{"$f":"IF(ISBLANK(G56),\"\",ROUNDUP(G56/$J56,0))","v":""},null,{"$f":"IF(ISBLANK(U56),\"\",U56+L56)","v":""},null,{"$f":"IF(ISBLANK(W56),\"\",W56+N56)","v":""},null,{"$f":"IF(ISBLANK(Y56),\"\",Y56+P56)","v":""},57,{"$f":"IF(ISBLANK(AA56),\"\",AA56+R56)","v":65},null,{"$f":"IF(ISBLANK(AC56),\"\",AC56+T56)","v":""},null,null,{"$f":"U56","v":0},{"$f":"IF(W56>0,IF(V56=\"\",W56,W56-V56),0)","v":0},{"$f":"IF(Y56>0,IF(X56=\"\",IF(V56=\"\",Y56,Y56-V56),Y56-X56),0)","v":0},{"$f":"IF(AA56>0,IF(Z56=\"\",IF(X56=\"\",IF(V56=\"\",AA56,AA56-V56),AA56-X56),AA56-Z56),0)","v":57},{"$f":"IF(AC56>0,IF(AB56=\"\",IF(Z56=\"\",IF(X56=\"\",IF(V56=\"\",AC56,AC56-V56),AC56-X56),AC56-Z56),AC56-AB56),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(C57),ISBLANK(D57),ISBLANK(E57),ISBLANK(F57),ISBLANK(G57)),\"\",SUM(C57:G57))","v":""},null,null,null,{"$f":"IF(ISBLANK(C57),\"\",ROUNDUP(C57/$J57,0))","v":""},"/",{"$f":"IF(ISBLANK(D57),\"\",ROUNDUP(D57/$J57,0))","v":""},"/",{"$f":"IF(ISBLANK(E57),\"\",ROUNDUP(E57/$J57,0))","v":""},"/",{"$f":"IF(ISBLANK(F57),\"\",ROUNDUP(F57/$J57,0))","v":""},"/",{"$f":"IF(ISBLANK(G57),\"\",ROUNDUP(G57/$J57,0))","v":""},null,"",null,"",null,"",null,"",null,"",null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(C58),ISBLANK(D58),ISBLANK(E58),ISBLANK(F58),ISBLANK(G58)),\"\",SUM(C58:G58))","v":""},null,null,null,{"$f":"IF(ISBLANK(C58),\"\",ROUNDUP(C58/$J58,0))","v":""},"/",{"$f":"IF(ISBLANK(D58),\"\",ROUNDUP(D58/$J58,0))","v":""},"/",{"$f":"IF(ISBLANK(E58),\"\",ROUNDUP(E58/$J58,0))","v":""},"/",{"$f":"IF(ISBLANK(F58),\"\",ROUNDUP(F58/$J58,0))","v":""},"/",{"$f":"IF(ISBLANK(G58),\"\",ROUNDUP(G58/$J58,0))","v":""},null,"",null,"",null,"",null,"",null,"",null,null,0,0,0,0,0]
[]
[null,"Date",null,"Days",null,null,"Possible","Probable Working Days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REMARKS"]
["Month","Begin","End","Month","Total","Holiday","Work Days","%","Month","Total"]
[null,null,null,{"$f":"IF(AND(B62>0,C62>0),((C62+1)-B62),0)","v":0},{"$f":"D62","v":0},null,{"$f":"NETWORKDAYS(B62,C62)-F62","v":0},null,{"$f":"ROUND(IF(G62>0,G62*H62*0.01,0),0)","v":0},{"$f":"I62","v":0}]
[null,null,null,0,{"$f":"E62+D63","v":0},null,0,null,0,{"$f":"J62+I63","v":0}]
[null,null,null,0,0,null,0,null,0,0]
[null,null,null,0,0,null,0,null,0,0]
[null,null,null,0,0,null,0,68,0,0]
["June",{"$f":"DATE($U$73,6,18)","v":"2018-06-18"},{"$f":"DATE($U$73,6,30)","v":"2018-06-30"},13,13,0,10,81,8,8]
["July",{"$f":"DATE($U$73,7,1)","v":"2018-07-01"},{"$f":"DATE($U$73,7,31)","v":"2018-07-31"},31,44,1,21,85,18,26]
["August",{"$f":"DATE($U$73,8,1)","v":"2018-08-01"},{"$f":"DATE($U$73,8,31)","v":"2018-08-31"},31,75,0,23,85,20,46]
["September",{"$f":"DATE($U$73,9,1)","v":"2018-09-01"},{"$f":"DATE($U$73,9,30)","v":"2018-09-30"},30,105,1,19,70,13,59,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calendar Days",null,null,null,{"$f":"E73","v":115}]
["October",{"$f":"DATE($U$73,10,1)","v":"2018-10-01"},{"$f":"DATE($U$73,10,10)","v":"2018-10-10"},10,115,0,8,70,6,65,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working Days",null,null,null,65]
[null,null,null,0,115,null,0,null,0,65,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completion Date",null,null,null,"2018-10-10"]
[null,null,null,0,115,null,0,null,0,65,"CONSTRUCTION YEAR:",null,null,null,null,null,null,null,null,null,2018,null,null,"Prepared By"]
[]
[null,null,null,null,null,null,null,null,"Page 1 of 1"]

{"sheet":"Example Time Chart","index":2,"n_rows":68,"n_cols":37,"rows_kept":68,"cut":false,"hidden":false,"merged":[[67,8,67,9],[49,0,49,1],[49,9,49,10],[50,0,50,1],[50,9,50,10],[52,1,52,2],[52,3,52,5],[52,7,52,9],[52,23,52,29],[53,23,61,29],[65,10,65,19],[62,27,62,29],[63,27,63,29],[64,27,64,29],[65,27,65,29],[46,0,46,1],[46,9,46,10],[47,0,47,1],[47,9,47,10],[48,0,48,1],[48,9,48,10],[43,0,43,1],[43,9,43,10],[44,0,44,1],[44,9,44,10],[45,0,45,1],[45,9,45,10],[40,0,40,1],[40,9,40,10],[41,0,41,1],[41,9,41,10],[42,0,42,1],[42,9,42,10],[37,0,37,1],[37,9,37,10],[38,0,38,1],[38,9,38,10],[39,0,39,1],[39,9,39,10],[34,0,34,1],[34,9,34,10],[35,0,35,1],[35,9,35,10],[36,0,36,1],[36,9,36,10],[31,0,31,1],[31,9,31,10],[32,0,32,1],[32,9,32,10],[33,0,33,1],[33,9,33,10],[29,28,29,29],[4,1,4,2],[4,5,4,6],[4,10,4,21],[4,27,4,29],[29,0,30,1],[29,2,29,6],[29,7,30,7],[29,8,30,8],[29,9,30,10],[29,11,30,19],[29,20,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[28,0,28,29],[0,0,0,29],[1,0,1,29],[3,1,3,2],[3,5,3,6],[3,10,3,21],[3,27,3,29]]}
["CONTRACT TIME FOR COMPLETION"]
["Wisconsin Department of Transportation      DT1923      09/2010"]
[]
["Project ID","5992-05-88",null,null,"Highway","USH 151",null,null,null,"Project Title","East Washington Ave., City of Madison",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Letting","2004-12-14"]
["Work Type","Reconstruction",null,null,"County","Dane",null,null,null,"Project Limits","Melvin Court to Thierer Road",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probable Date of Beginning","2005-03-14"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ITEM ANALYSIS"]
["Item",null,"Contract Quantity per Stage",null,null,null,null,"Total Quantity","Unit","Production Rate",null,"Working Days\n(per Stage)",null,null,null,null,null,null,null,null,"Stage 1",null,"Stage 2",null,"Stage 3",null,"Stage 4",null,"Stage 5"]
[null,null,{"$f":"U30","v":"Stage 1"},{"$f":"W30","v":"Stage 2"},{"$f":"Y30","v":"Stage 3"},{"$f":"AA30","v":"Stage 4"},{"$f":"AC30","v":"Stage 5"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Begin","End","Begin","End","Begin","End","Begin","End","Begin","End",null,null,"Gap 1","Gap 2","Gap 3","Gap 4","Gap 5"]
["1. Traffic Control",null,3,1,3,1,null,{"$f":"IF(AND(ISBLANK(C32),ISBLANK(D32),ISBLANK(E32),ISBLANK(F32),ISBLANK(G32)),\"\",SUM(C32:G32))","v":8},"Days",1,null,{"$f":"IF(ISBLANK(C32),\"\",ROUNDUP(C32/$J32,0))","v":3},"/",{"$f":"IF(ISBLANK(D32),\"\",ROUNDUP(D32/$J32,0))","v":1},"/",{"$f":"IF(ISBLANK(E32),\"\",ROUNDUP(E32/$J32,0))","v":3},"/",{"$f":"IF(ISBLANK(F32),\"\",ROUNDUP(F32/$J32,0))","v":1},"/",{"$f":"IF(ISBLANK(G32),\"\",ROUNDUP(G32/$J32,0))","v":""},0,{"$f":"IF(U32<>\"\",U32+L32,\"\")","v":3},{"$f":"V33","v":11},{"$f":"IF(ISBLANK(W32),\"\",W32+N32)","v":12},{"$f":"X48","v":68},{"$f":"IF(ISBLANK(Y32),\"\",Y32+P32)","v":71},{"$f":"Z33","v":88},{"$f":"IF(ISBLANK(AA32),\"\",AA32+R32)","v":89},null,{"$f":"IF(ISBLANK(AC32),\"\",AC32+T32)","v":""}," ",null,{"$f":"U32","v":0},{"$f":"IF(W32>0,IF(V32=\"\",W32,W32-V32),0)","v":8},{"$f":"IF(Y32>0,IF(X32=\"\",IF(V32>0,Y32-V32,Y32),Y32-X32),0)","v":56},{"$f":"IF(AA32>0,IF(Z32=\"\",IF(X32=\"\",IF(V32=\"\",AA32,AA32-V32),AA32-X32),AA32-Z32),0)","v":17},{"$f":"IF(AC32>0,IF(AB32=\"\",IF(Z32=\"\",IF(X32=\"\",IF(V32=\"\",AC32,AC32-V32),AC32-X32),AC32-Z32),AC32-AB32),0)","v":0}]
["2. Temporary Pavement",null,7700,null,7250,null,null,14950,"S.Y.",1000,null,{"$f":"IF(ISBLANK(C33),\"\",ROUNDUP(C33/$J33,0))","v":8},"/",{"$f":"IF(ISBLANK(D33),\"\",ROUNDUP(D33/$J33,0))","v":""},"/",{"$f":"IF(ISBLANK(E33),\"\",ROUNDUP(E33/$J33,0))","v":8},"/",{"$f":"IF(ISBLANK(F33),\"\",ROUNDUP(F33/$J33,0))","v":""},"/",{"$f":"IF(ISBLANK(G33),\"\",ROUNDUP(G33/$J33,0))","v":""},{"$f":"V32","v":3},11,null,"",{"$f":"Z39","v":80},88,null,"",null,"",null,null,3,0,69,0,0]
["3. Removing Pavement",null,null,34000,2000,34000,null,70000,"S.Y.",4000,null,"","/",9,"/",1,"/",9,"/","",null,"",{"$f":"X32","v":12},21,{"$f":"Z32-1","v":70},71,{"$f":"AB32","v":89},98,null,"",null,null,0,12,49,18,0]
["4. Sanitary Sewer",null,500,1550,150,500,null,2700,"L.F.",400,null,2,"/",4,"/",1,"/",2,"/","",3,5,{"$f":"X32+2","v":14},18,{"$f":"Z34","v":71},72,{"$f":"AB34-7","v":91},93,null,"",null,null,3,9,53,19,0]
["5. Sanitary Manholes",null,null,8,null,8,null,16,"Each",7,null,"","/",2,"/","","/",2,"/","",null,"",{"$f":"X35","v":18},20,null,"",{"$f":"AB35","v":93},95,null,"",null,null,0,18,0,73,0]
["6. Water Main (Inc. Laterals)",null,null,6800,600,2900,null,10300,"L.F.",200,null,"","/",34,"/",3,"/",15,"/","",null,"",{"$f":"X34-8","v":13},47,{"$f":"Z35","v":72},75,{"$f":"AB36-2","v":93},108,null,"",null,null,0,13,25,18,0]
["7. Storm Sewer",null,null,4000,650,4000,null,8650,"L.F.",400,null,"","/",10,"/",2,"/",10,"/","",null,"",{"$f":"X37-15","v":32},42,{"$f":"Z37","v":75},77,{"$f":"AB37-13","v":95},105,null,"",null,null,0,32,33,18,0]
["8. Storm Inlets and Manholes",null,null,72,23,93,null,188,"Each",10,null,"","/",8,"/",3,"/",10,"/","",null,"",{"$f":"X38","v":42},50,{"$f":"Z38","v":77},80,{"$f":"AB38","v":105},115,null,"",null,null,0,42,27,25,0]
["9. Structure (Ped Tunnel)",null,null,23,20,18,null,61,"Days",1,null,"","/",23,"/",20,"/",18,"/","",null,"",45,68,{"$f":"X40","v":68},88,{"$f":"Z40","v":88},106,null,"",null,null,0,45,0,0,0]
["10. Common Excavation (Urban)",null,null,42000,null,41000,5000,88000,"C.Y.",2000,null,"","/",21,"/","","/",21,"/",3,null,"",{"$f":"X39-21","v":29},50,null,"",{"$f":"AB39-10","v":105},126,{"$f":"AB48","v":136},139,null,null,0,29,0,55,10]
["11. Breaker Run (Urban)",null,null,37500,null,35500,6100,79100,"Ton",2000,null,"","/",19,"/","","/",18,"/",4,null,"",{"$f":"X41-12","v":38},57,null,"",{"$f":"AB41-16","v":110},128,{"$f":"AD41-2","v":137},141,null,null,0,38,0,53,9]
["12 CABC (Urban)",null,null,21000,null,21000,3450,45450,"Ton",2000,null,"","/",11,"/","","/",11,"/",2,null,"",{"$f":"X42-10","v":47},58,null,"",{"$f":"AB42-15","v":113},124,{"$f":"AD42","v":141},143,null,null,0,47,0,55,17]
["13. Concrete Pavement (Urban)",null,null,33500,null,33500,6850,73850,"S.Y.",3500,null,"","/",10,"/","","/",10,"/",2,null,"",{"$f":"X43-9","v":49},59,null,"",{"$f":"AB43-7","v":117},127,{"$f":"AD43","v":143},145,null,null,0,49,0,58,16]
["14. Concrete Curb and Gutter",null,null,8400,null,8400,16000,32800,"L.F.",2000,null,"","/",5,"/","","/",5,"/",8,null,"",{"$f":"X44-3","v":56},61,null,"",{"$f":"AB44-3","v":124},129,{"$f":"AD44-1","v":144},152,null,null,0,56,0,63,15]
["15. Concrete Sidewalk",null,null,2000,null,2000,null,4000,"S.F.",500,null,"","/",4,"/","","/",4,"/","",null,"",{"$f":"X45-2","v":59},63,null,"",{"$f":"AB45-2","v":127},131,null,"",null,null,0,59,0,64,0]
["16. Concrete Driveway",null,null,1100,null,500,null,1600,"S.Y.",150,null,"","/",8,"/","","/",4,"/","",null,"",{"$f":"X46-6","v":57},65,null,"",{"$f":"AB46-2","v":129},133,null,"",null,null,0,57,0,64,0]
["17. Seeding and Finishing",null,null,6200,null,6200,null,12400,"S.Y.",1500,null,"","/",5,"/","","/",5,"/","",null,"",{"$f":"X47-2","v":63},68,null,"",{"$f":"AB47-2","v":131},136,null,"",null,null,0,63,0,63,0]
[null,null,null,null,null,null,null,"",null,null,null,"","/","","/","","/","","/","",null,"",null,"",null,"",null,"",null,"",null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,null,"","/","","/","","/","","/","",null,"",null,"",null,"",null,"",null,"",null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,"",null,null,null,"","/","","/","","/","","/","",null,"",null,"",null,"",null,"",null,"",null,null,0,0,0,0,0]
[]
[null,"Date",null,"Days",null,null,"Possible","Probable Working Days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REMARKS"]
["Month","Begin","End","Month","Total","Holiday","Work Days","%","Month","Total"]
[null,null,null,{"$f":"IF(AND(B55>0,C55>0),((C55+1)-B55),0)","v":0},{"$f":"D55","v":0},null,{"$f":"NETWORKDAYS(B55,C55)-F55","v":0},null,{"$f":"ROUND(IF(G55>0,G55*H55*0.01,0),0)","v":0},{"$f":"I55","v":0}]
[null,null,null,0,{"$f":"E55+D56","v":0},null,0,null,0,{"$f":"J55+I56","v":0}]
["March","2005-03-14",{"$f":"DATE($U$66,3,31)","v":"2005-03-31"},18,18,0,14,75,11,11]
["April",{"$f":"DATE($U$66,4,1)","v":"2005-04-01"},{"$f":"DATE($U$66,4,30)","v":"2005-04-30"},30,48,0,21,80,17,28]
["May",{"$f":"DATE($U$66,5,1)","v":"2005-05-01"},{"$f":"DATE($U$66,5,31)","v":"2005-05-31"},31,79,1,21,85,18,46]
["June",{"$f":"DATE($U$66,6,1)","v":"2005-06-01"},{"$f":"DATE($U$66,6,30)","v":"2005-06-30"},30,109,0,22,95,21,67]
["July",{"$f":"DATE($U$66,7,1)","v":"2005-07-01"},{"$f":"DATE($U$66,7,31)","v":"2005-07-31"},31,140,1,20,95,19,86]
["August",{"$f":"DATE($U$66,8,1)","v":"2005-08-01"},{"$f":"DATE($U$66,8,31)","v":"2005-08-31"},31,171,0,23,85,20,106]
["September",{"$f":"DATE($U$66,9,1)","v":"2005-09-01"},{"$f":"DATE($U$66,9,30)","v":"2005-09-30"},30,201,1,21,80,17,123,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calendar Days",null,null,null,{"$f":"E66","v":262}]
["October",{"$f":"DATE($U$66,10,1)","v":"2005-10-01"},{"$f":"DATE($U$66,10,31)","v":"2005-10-31"},31,232,0,21,75,16,139,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working Days",null,null,null,{"$f":"J66","v":152}]
["November",{"$f":"DATE($U$66,11,1)","v":"2005-11-01"},{"$f":"DATE($U$66,11,30)","v":"2005-11-30"},30,262,1,21,60,13,152,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completion Date",null,null,null,"2005-12-01"]
[null,null,null,0,262,null,0,null,0,152,"CONSTRUCTION YEAR:",null,null,null,null,null,null,null,null,null,2005,null,null,"Prepared By",null,null,null,"D. Layton"]
[]
[null,null,null,null,null,null,null,null,"Page 1 of 1"]