{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Information","Sheet","Calculations","Variables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":40,"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":"Information","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,0,14,1],[11,3,11,4],[5,1,5,4],[9,3,10,4],[7,5,8,5],[1,1,1,4],[3,1,3,4],[4,1,4,4],[7,1,7,4],[2,1,2,4],[8,3,8,4]]}
[null,"Information"]
[{"$f":"OFFSET(A2,-1,0)+1","v":1},"Add project/sheet information below.  Use the \"Reload Data\" button to select the correct CSV file.    Fill in the constants below."]
[{"$f":"OFFSET(A3,-1,0)+1","v":2},"Make modifications to the Sheet tab before adding additional sheets.  \n - The column widths for the description and remarks may be resized and the content will reformat to match the width of the columns on the first sheet (F9 to recalculate).  Ensure that the content fits on the sheet.\n - Only resize columns F to Y.  Keep columns D and AA outside the sheet border.\n - Notes may be added to the bottom right half of the sheet.  ",null,null,null,{"$f":"IFERROR(IF(OR(trunDesc,trunRemarks),\"Content truncated from:\"&IF(trunDesc,CHAR(10)&\" - Description\",\"\")&IF(trunRemarks,CHAR(10)&\" - Remarks\",\"\")&CHAR(10)&\"Check and adjust columns to fit entire text.\",\"\"),\"The Description and/or Remarks columns are too short to see content.  Resize.\")","v":""}]
[{"$f":"OFFSET(A4,-1,0)+1","v":3},"The Summary of Quantity sheets are located on the Sheet, Sheet (2), etc. tabs.  To copy a sheet, hold the left mouse button on the worksheet's tab (below) while pressing the <CTRL> key.  A mini sheet with a plus sign should appear.  Drag this and drop it to the desired location.  "]
[{"$f":"OFFSET(A5,-1,0)+1","v":4},"Until the file is saved, the filename block will be blank.  Sheet numbers may not update until having exited and reentered the file."]
[]
[null,"Constants"]
[null,"Insert the following values (they will appear on every sheet):",null,null,null,"Use this spreadsheet with 26 column data only"]
[null,"Project: ","AZ FTNP GRCA 13(1)\nMT OMAD 18(38)","Note:  If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines."]
[null,"NPS PMIS No. ","NPS PMIS No. ","Note: NPS fields do not appear on the sheet unless additional text is added."]
[null,"NPS Drwg No. ","NPS Drwg No. "]
[null,"First sheet num: ","B.1",{"$f":"MIN(Sheets.needed,Sheets.available)&\" of \"&Sheets.needed&\" Needed sheets available\"","v":"1 of 5 Needed sheets available"}]
[{"$f":"\"(\"&IF(ISNUMBER(FIND(\".\",Sheet)),\"WFL\",\"CFL or EFL\")&\" format shown.  \"&IF(ISNUMBER(FIND(\".\",Sheet)),\"CFL or EFL\",\"WFL\")&\" format \"&IF(ISNUMBER(FIND(\".\",Sheet)),\"does not contain\",\"contains\")&\" a \"\"period\"\" separator)\"","v":"(WFL format shown.  CFL or EFL format does not contain a \"period\" separator)"}]
[null,null,null,{"$f":"IF(ISNA(Metric),\"Error in Units\",IF(Metric,\"Metric\",\"US Customary\")&\" units used\")","v":"Metric units used"}]
[null,null,null,"Revised:","2022-11-03"]

{"sheet":"Sheet","index":1,"n_rows":50,"n_cols":26,"rows_kept":50,"cut":false,"hidden":false,"merged":[[7,24,11,24],[7,8,11,8],[7,9,11,9],[7,0,7,1],[2,0,2,1],[3,0,3,1],[6,0,6,1],[10,23,11,23],[7,23,9,23],[6,5,6,24],[44,3,49,3],[6,3,43,3],[49,6,49,9],[0,0,1,2],[7,5,11,5],[7,6,11,6],[7,7,11,7]]}
["Sheet Information",null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(EEBACS,2,K2,1,1)","v":"C: Typical Section"},"D: Plan, Roadway","E: Layout, Parking Area","F: Drainage","G: Walls","M: Temp. Erosion Control","P: Perm. Traffic Control","***: Column 8","B.66-B.85`: Column 9","-: Column 10","Plan: Allow- ance","C12: Column 12","C13: Column 13"]
[null,null,null,null,null,{"$f":"MATCH(F8&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":0},{"$f":"MATCH(G8&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":1},{"$f":"MATCH(H8&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":2},{"$f":"MATCH(I8,OFFSET(Calcs,0,0,1,COLUMNS(Calcs)),0)","v":4},{"$f":"MATCH(J8&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":4},{"$f":"IF(OFFSET(K2,0,-1)+1<$X2,OFFSET(K2,0,-1)+1,$X2+2)","v":5},6,7,8,9,10,11,12,13,14,15,16,17,{"$f":"MATCH(X8&\"*\",OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":31},{"$f":"MATCH(Y8,OFFSET(Calcs,0,0,1,COLUMNS(Calcs)),0)","v":46}]
["Sheet num:",null,{"$f":"INDEX(SheetNames[Sheet],MATCH(C4,SheetNames[Worksheet],0))","v":"B.1"},null,null,null,null,null,null,null,{"$f":"OFFSET(EEBACS,2,K4,1,1)","v":"C14: Column 14"},"C15: Column 15","C16: Column 16","C17: Column 17","C18: Column 18","C19: Column 19","C20: Column 20","C21: Column 21","C22: Column 22","C23: Column 23","C24: Column 24","C25: Column 25","C26: Column 26"]
["Sheet name:",null,{"$f":"RIGHT(Filename,LEN(Filename)-FIND(\"]\",Filename))","v":"Sheet"},null,null,null,null,null,null,null,{"$f":"K2+COUNTIF(Column.widths,\">0\")","v":18},19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,"left",null,null,null,null,null,{"$f":"CELL(\"width\",K5)","v":9},{"$f":"CELL(\"width\",L5)","v":9},9,9,9,9,9,9,9,9,9,9,9,null,null,"right"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(NPS.PMIS,\".\",\"\"),\" \",\"\"))>9,NPS.PMIS,\"\")&IF(LEN(SUBSTITUTE(SUBSTITUTE(NPS.Drwg,\".\",\"\"),\" \",\"\"))>9,REPT(\" \",3)&NPS.Drwg,\"\")","v":""}]
["Show \"Schedule / Option\" text in sheet title?",null,null,{"$f":"CELL(\"filename\",Filename)","v":"C:\\pw-work\\d0561506\\[summary26.xlsm]Sheet"},null,{"$f":"\"SUMMARY OF QUANTITIES\"&IF(LEFT(Type,1)=\"<\",\"\",\" - \"&Type&\" \"&LEFT(VLOOKUP(OFFSET(Begin,1,2),Calcs,col_Schedule,0),1))","v":"SUMMARY OF QUANTITIES - Schedule A"}]
["Schedule",null,null,null,null,"AMENDMENT","Line Item No.","Pay Item Number","Pay Item Description","Unit","Sheet and Description",null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Quantities","Remarks and/or Determination of Estimated Quantity"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(FIND(\":\",K1)),LEFT(K1,FIND(\":\",K1)-1),\"\")","v":"C"},"D","E","F","G","M","P","***","B.66-B.85`","-","Plan","C12","C13"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(FIND(\":\",K1)),TRIM(SUBSTITUTE(K1,K9&\":\",\"\")),\"\")","v":"Typical Section"},"Plan, Roadway","Layout, Parking Area","Drainage","Walls","Temp. Erosion Control","Perm. Traffic Control","Column 8","Column 9","Column 10","Allow- ance","Column 12","Column 13"]
[null,{"$f":"MATCH(B12,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)-1","v":33},{"$f":"IF(OFFSET(C11,1,0)>0,-OFFSET(C11,1,0),OFFSET(C11,1,0)-1)","v":-3},null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(FIND(\":\",K3)),LEFT(K3,FIND(\":\",K3)-1),\"\")","v":"C14"},"C15","C16","C17","C18","C19","C20","C21","C22","C23","C24","C25","C26","Bid Schedule"]
[{"$f":"INDEX(SheetNames[Begins],MATCH(Sheet.number,SheetNames[Sheet],0))","v":0},"Deleted",{"$f":"IF(OFFSET(C12,1,0)>0,-OFFSET(C12,1,0),OFFSET(C12,1,0)-1)","v":-2},null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(FIND(\":\",K3)),TRIM(SUBSTITUTE(K3,K11&\":\",\"\")),\"\")","v":"Column 14"},"Column 15","Column 16","Column 17","Column 18","Column 19","Column 20","Column 21","Column 22","Column 23","Column 24","Column 25","Column 26"]
[{"$f":"OFFSET(A13,-1,0)+1","v":1},{"$f":"IF($A13>End,\"\",OFFSET(EEBACS,MATCH($C13,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),B$11,1,1)=1)","v":false},{"$f":"IFERROR(VLOOKUP(A13,Calcs,1,0),OFFSET(C13,1,0))","v":2},null,null,{"$f":"IF(OR($C13=OFFSET($C13,-1,0),$A13>End),\"\",OFFSET(EEBACS,MATCH($C13,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),F$2,1,1))","v":0},"A0010","15101-0000",{"$f":"IF(OR($A13>End,COUNTIF($C$12:$C13,$C13)>lines_D),\"\",IF(COUNTIF($C$12:$C13,$C13)=1,LEFT(VLOOKUP($C13,Calcs,col_Description,0),VLOOKUP($C13,Calcs,col_D,0)),MID(VLOOKUP($C13,Calcs,col_Description,0),VLOOKUP($C13,Calcs,col_D+COUNTIF($C$12:$C13,$C13)-2,0)+1,VLOOKUP($C13,Calcs,col_D+COUNTIF($C$12:$C13,$C13)-1,0)-VLOOKUP($C13,Calcs,col_D+COUNTIF($C$12:$C13,$C13)-2,0))))","v":"Mobilization"},{"$f":"IF(OR($C13=OFFSET($C13,1,0),$A13>End),\"\",OFFSET(EEBACS,MATCH($C13,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),J$2,1,1))","v":""},{"$f":"IF(OR($C13=OFFSET($C13,2,0),$A13>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C13,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),IF($C13=OFFSET($C13,1,0),K$2,K$4),1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"","","","","","","","","","","","",{"$f":"IF(OR($C13=OFFSET($C13,1,0),$A13>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C13,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),X$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},{"$f":"IF(OR($A13>End,COUNTIF($C$12:$C13,$C13)>lines_R),\"\",IF(COUNTIF($C$12:$C13,$C13)=1,LEFT(VLOOKUP($C13,Calcs,col_Remarks,0),VLOOKUP($C13,Calcs,col_R,0)),MID(VLOOKUP($C13,Calcs,col_Remarks,0),VLOOKUP($C13,Calcs,col_R+COUNTIF($C$12:$C13,$C13)-2,0)+1,VLOOKUP($C13,Calcs,col_R+COUNTIF($C$12:$C13,$C13)-1,0)-VLOOKUP($C13,Calcs,col_R+COUNTIF($C$12:$C13,$C13)-2,0))))","v":""}]
[2,false,2,null,null,"","","",{"$f":"IF(OR($A14>End,COUNTIF($C$12:$C14,$C14)>lines_D),\"\",IF(COUNTIF($C$12:$C14,$C14)=1,LEFT(VLOOKUP($C14,Calcs,col_Description,0),VLOOKUP($C14,Calcs,col_D,0)),MID(VLOOKUP($C14,Calcs,col_Description,0),VLOOKUP($C14,Calcs,col_D+COUNTIF($C$12:$C14,$C14)-2,0)+1,VLOOKUP($C14,Calcs,col_D+COUNTIF($C$12:$C14,$C14)-1,0)-VLOOKUP($C14,Calcs,col_D+COUNTIF($C$12:$C14,$C14)-2,0))))","v":""},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A14>End,COUNTIF($C$12:$C14,$C14)>lines_R),\"\",IF(COUNTIF($C$12:$C14,$C14)=1,LEFT(VLOOKUP($C14,Calcs,col_Remarks,0),VLOOKUP($C14,Calcs,col_R,0)),MID(VLOOKUP($C14,Calcs,col_Remarks,0),VLOOKUP($C14,Calcs,col_R+COUNTIF($C$12:$C14,$C14)-2,0)+1,VLOOKUP($C14,Calcs,col_R+COUNTIF($C$12:$C14,$C14)-1,0)-VLOOKUP($C14,Calcs,col_R+COUNTIF($C$12:$C14,$C14)-2,0))))","v":""}]
[3,false,4,null,null,0,"A0020","15201-0000",{"$f":"IF(OR($A15>End,COUNTIF($C$12:$C15,$C15)>lines_D),\"\",IF(COUNTIF($C$12:$C15,$C15)=1,LEFT(VLOOKUP($C15,Calcs,col_Description,0),VLOOKUP($C15,Calcs,col_D,0)),MID(VLOOKUP($C15,Calcs,col_Description,0),VLOOKUP($C15,Calcs,col_D+COUNTIF($C$12:$C15,$C15)-2,0)+1,VLOOKUP($C15,Calcs,col_D+COUNTIF($C$12:$C15,$C15)-1,0)-VLOOKUP($C15,Calcs,col_D+COUNTIF($C$12:$C15,$C15)-2,0))))","v":"Construction survey and staking"},"","","All","","","","","","","","","","","","",{"$f":"IF(OR($A15>End,COUNTIF($C$12:$C15,$C15)>lines_R),\"\",IF(COUNTIF($C$12:$C15,$C15)=1,LEFT(VLOOKUP($C15,Calcs,col_Remarks,0),VLOOKUP($C15,Calcs,col_R,0)),MID(VLOOKUP($C15,Calcs,col_Remarks,0),VLOOKUP($C15,Calcs,col_R+COUNTIF($C$12:$C15,$C15)-2,0)+1,VLOOKUP($C15,Calcs,col_R+COUNTIF($C$12:$C15,$C15)-1,0)-VLOOKUP($C15,Calcs,col_R+COUNTIF($C$12:$C15,$C15)-2,0))))","v":""}]
[4,false,4,null,null,"","","",{"$f":"IF(OR($A16>End,COUNTIF($C$12:$C16,$C16)>lines_D),\"\",IF(COUNTIF($C$12:$C16,$C16)=1,LEFT(VLOOKUP($C16,Calcs,col_Description,0),VLOOKUP($C16,Calcs,col_D,0)),MID(VLOOKUP($C16,Calcs,col_Description,0),VLOOKUP($C16,Calcs,col_D+COUNTIF($C$12:$C16,$C16)-2,0)+1,VLOOKUP($C16,Calcs,col_D+COUNTIF($C$12:$C16,$C16)-1,0)-VLOOKUP($C16,Calcs,col_D+COUNTIF($C$12:$C16,$C16)-2,0))))","v":""},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A16>End,COUNTIF($C$12:$C16,$C16)>lines_R),\"\",IF(COUNTIF($C$12:$C16,$C16)=1,LEFT(VLOOKUP($C16,Calcs,col_Remarks,0),VLOOKUP($C16,Calcs,col_R,0)),MID(VLOOKUP($C16,Calcs,col_Remarks,0),VLOOKUP($C16,Calcs,col_R+COUNTIF($C$12:$C16,$C16)-2,0)+1,VLOOKUP($C16,Calcs,col_R+COUNTIF($C$12:$C16,$C16)-1,0)-VLOOKUP($C16,Calcs,col_R+COUNTIF($C$12:$C16,$C16)-2,0))))","v":""}]
[5,false,6,null,null,0,"A0030","15301-0010",{"$f":"IF(OR($A17>End,COUNTIF($C$12:$C17,$C17)>lines_D),\"\",IF(COUNTIF($C$12:$C17,$C17)=1,LEFT(VLOOKUP($C17,Calcs,col_Description,0),VLOOKUP($C17,Calcs,col_D,0)),MID(VLOOKUP($C17,Calcs,col_Description,0),VLOOKUP($C17,Calcs,col_D+COUNTIF($C$12:$C17,$C17)-2,0)+1,VLOOKUP($C17,Calcs,col_D+COUNTIF($C$12:$C17,$C17)-1,0)-VLOOKUP($C17,Calcs,col_D+COUNTIF($C$12:$C17,$C17)-2,0))))","v":"Contractor quality control and "},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A17>End,COUNTIF($C$12:$C17,$C17)>lines_R),\"\",IF(COUNTIF($C$12:$C17,$C17)=1,LEFT(VLOOKUP($C17,Calcs,col_Remarks,0),VLOOKUP($C17,Calcs,col_R,0)),MID(VLOOKUP($C17,Calcs,col_Remarks,0),VLOOKUP($C17,Calcs,col_R+COUNTIF($C$12:$C17,$C17)-2,0)+1,VLOOKUP($C17,Calcs,col_R+COUNTIF($C$12:$C17,$C17)-1,0)-VLOOKUP($C17,Calcs,col_R+COUNTIF($C$12:$C17,$C17)-2,0))))","v":""}]
[6,false,6,null,null,"","","",{"$f":"IF(OR($A18>End,COUNTIF($C$12:$C18,$C18)>lines_D),\"\",IF(COUNTIF($C$12:$C18,$C18)=1,LEFT(VLOOKUP($C18,Calcs,col_Description,0),VLOOKUP($C18,Calcs,col_D,0)),MID(VLOOKUP($C18,Calcs,col_Description,0),VLOOKUP($C18,Calcs,col_D+COUNTIF($C$12:$C18,$C18)-2,0)+1,VLOOKUP($C18,Calcs,col_D+COUNTIF($C$12:$C18,$C18)-1,0)-VLOOKUP($C18,Calcs,col_D+COUNTIF($C$12:$C18,$C18)-2,0))))","v":"assurance"},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A18>End,COUNTIF($C$12:$C18,$C18)>lines_R),\"\",IF(COUNTIF($C$12:$C18,$C18)=1,LEFT(VLOOKUP($C18,Calcs,col_Remarks,0),VLOOKUP($C18,Calcs,col_R,0)),MID(VLOOKUP($C18,Calcs,col_Remarks,0),VLOOKUP($C18,Calcs,col_R+COUNTIF($C$12:$C18,$C18)-2,0)+1,VLOOKUP($C18,Calcs,col_R+COUNTIF($C$12:$C18,$C18)-1,0)-VLOOKUP($C18,Calcs,col_R+COUNTIF($C$12:$C18,$C18)-2,0))))","v":""}]
[7,false,8,null,null,0,"A0040","15401-0000",{"$f":"IF(OR($A19>End,COUNTIF($C$12:$C19,$C19)>lines_D),\"\",IF(COUNTIF($C$12:$C19,$C19)=1,LEFT(VLOOKUP($C19,Calcs,col_Description,0),VLOOKUP($C19,Calcs,col_D,0)),MID(VLOOKUP($C19,Calcs,col_Description,0),VLOOKUP($C19,Calcs,col_D+COUNTIF($C$12:$C19,$C19)-2,0)+1,VLOOKUP($C19,Calcs,col_D+COUNTIF($C$12:$C19,$C19)-1,0)-VLOOKUP($C19,Calcs,col_D+COUNTIF($C$12:$C19,$C19)-2,0))))","v":"Contractor testing"},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A19>End,COUNTIF($C$12:$C19,$C19)>lines_R),\"\",IF(COUNTIF($C$12:$C19,$C19)=1,LEFT(VLOOKUP($C19,Calcs,col_Remarks,0),VLOOKUP($C19,Calcs,col_R,0)),MID(VLOOKUP($C19,Calcs,col_Remarks,0),VLOOKUP($C19,Calcs,col_R+COUNTIF($C$12:$C19,$C19)-2,0)+1,VLOOKUP($C19,Calcs,col_R+COUNTIF($C$12:$C19,$C19)-1,0)-VLOOKUP($C19,Calcs,col_R+COUNTIF($C$12:$C19,$C19)-2,0))))","v":""}]
[8,false,8,null,null,"","","",{"$f":"IF(OR($A20>End,COUNTIF($C$12:$C20,$C20)>lines_D),\"\",IF(COUNTIF($C$12:$C20,$C20)=1,LEFT(VLOOKUP($C20,Calcs,col_Description,0),VLOOKUP($C20,Calcs,col_D,0)),MID(VLOOKUP($C20,Calcs,col_Description,0),VLOOKUP($C20,Calcs,col_D+COUNTIF($C$12:$C20,$C20)-2,0)+1,VLOOKUP($C20,Calcs,col_D+COUNTIF($C$12:$C20,$C20)-1,0)-VLOOKUP($C20,Calcs,col_D+COUNTIF($C$12:$C20,$C20)-2,0))))","v":""},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A20>End,COUNTIF($C$12:$C20,$C20)>lines_R),\"\",IF(COUNTIF($C$12:$C20,$C20)=1,LEFT(VLOOKUP($C20,Calcs,col_Remarks,0),VLOOKUP($C20,Calcs,col_R,0)),MID(VLOOKUP($C20,Calcs,col_Remarks,0),VLOOKUP($C20,Calcs,col_R+COUNTIF($C$12:$C20,$C20)-2,0)+1,VLOOKUP($C20,Calcs,col_R+COUNTIF($C$12:$C20,$C20)-1,0)-VLOOKUP($C20,Calcs,col_R+COUNTIF($C$12:$C20,$C20)-2,0))))","v":""}]
[9,false,10,null,null,0,"A0050","15501-0000",{"$f":"IF(OR($A21>End,COUNTIF($C$12:$C21,$C21)>lines_D),\"\",IF(COUNTIF($C$12:$C21,$C21)=1,LEFT(VLOOKUP($C21,Calcs,col_Description,0),VLOOKUP($C21,Calcs,col_D,0)),MID(VLOOKUP($C21,Calcs,col_Description,0),VLOOKUP($C21,Calcs,col_D+COUNTIF($C$12:$C21,$C21)-2,0)+1,VLOOKUP($C21,Calcs,col_D+COUNTIF($C$12:$C21,$C21)-1,0)-VLOOKUP($C21,Calcs,col_D+COUNTIF($C$12:$C21,$C21)-2,0))))","v":"Construction schedule"},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A21>End,COUNTIF($C$12:$C21,$C21)>lines_R),\"\",IF(COUNTIF($C$12:$C21,$C21)=1,LEFT(VLOOKUP($C21,Calcs,col_Remarks,0),VLOOKUP($C21,Calcs,col_R,0)),MID(VLOOKUP($C21,Calcs,col_Remarks,0),VLOOKUP($C21,Calcs,col_R+COUNTIF($C$12:$C21,$C21)-2,0)+1,VLOOKUP($C21,Calcs,col_R+COUNTIF($C$12:$C21,$C21)-1,0)-VLOOKUP($C21,Calcs,col_R+COUNTIF($C$12:$C21,$C21)-2,0))))","v":""}]
[10,false,10,null,null,"","","",{"$f":"IF(OR($A22>End,COUNTIF($C$12:$C22,$C22)>lines_D),\"\",IF(COUNTIF($C$12:$C22,$C22)=1,LEFT(VLOOKUP($C22,Calcs,col_Description,0),VLOOKUP($C22,Calcs,col_D,0)),MID(VLOOKUP($C22,Calcs,col_Description,0),VLOOKUP($C22,Calcs,col_D+COUNTIF($C$12:$C22,$C22)-2,0)+1,VLOOKUP($C22,Calcs,col_D+COUNTIF($C$12:$C22,$C22)-1,0)-VLOOKUP($C22,Calcs,col_D+COUNTIF($C$12:$C22,$C22)-2,0))))","v":""},"LPSM","","","","","","","","","","","","","","ALL",{"$f":"IF(OR($A22>End,COUNTIF($C$12:$C22,$C22)>lines_R),\"\",IF(COUNTIF($C$12:$C22,$C22)=1,LEFT(VLOOKUP($C22,Calcs,col_Remarks,0),VLOOKUP($C22,Calcs,col_R,0)),MID(VLOOKUP($C22,Calcs,col_Remarks,0),VLOOKUP($C22,Calcs,col_R+COUNTIF($C$12:$C22,$C22)-2,0)+1,VLOOKUP($C22,Calcs,col_R+COUNTIF($C$12:$C22,$C22)-1,0)-VLOOKUP($C22,Calcs,col_R+COUNTIF($C$12:$C22,$C22)-2,0))))","v":""}]
[11,false,12,null,null,0,"A0060","15704-1000",{"$f":"IF(OR($A23>End,COUNTIF($C$12:$C23,$C23)>lines_D),\"\",IF(COUNTIF($C$12:$C23,$C23)=1,LEFT(VLOOKUP($C23,Calcs,col_Description,0),VLOOKUP($C23,Calcs,col_D,0)),MID(VLOOKUP($C23,Calcs,col_Description,0),VLOOKUP($C23,Calcs,col_D+COUNTIF($C$12:$C23,$C23)-2,0)+1,VLOOKUP($C23,Calcs,col_D+COUNTIF($C$12:$C23,$C23)-1,0)-VLOOKUP($C23,Calcs,col_D+COUNTIF($C$12:$C23,$C23)-2,0))))","v":"Soil erosion control, plastic "},"",{"$f":"IF(OR($C23=OFFSET($C23,2,0),$A23>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C23,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),IF($C23=OFFSET($C23,1,0),K$2,K$4),1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"","","","","165","","","","","","","",{"$f":"IF(OR($C23=OFFSET($C23,1,0),$A23>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C23,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),X$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},{"$f":"IF(OR($A23>End,COUNTIF($C$12:$C23,$C23)>lines_R),\"\",IF(COUNTIF($C$12:$C23,$C23)=1,LEFT(VLOOKUP($C23,Calcs,col_Remarks,0),VLOOKUP($C23,Calcs,col_R,0)),MID(VLOOKUP($C23,Calcs,col_Remarks,0),VLOOKUP($C23,Calcs,col_R+COUNTIF($C$12:$C23,$C23)-2,0)+1,VLOOKUP($C23,Calcs,col_R+COUNTIF($C$12:$C23,$C23)-1,0)-VLOOKUP($C23,Calcs,col_R+COUNTIF($C$12:$C23,$C23)-2,0))))","v":""}]
[12,false,12,null,null,"","","",{"$f":"IF(OR($A24>End,COUNTIF($C$12:$C24,$C24)>lines_D),\"\",IF(COUNTIF($C$12:$C24,$C24)=1,LEFT(VLOOKUP($C24,Calcs,col_Description,0),VLOOKUP($C24,Calcs,col_D,0)),MID(VLOOKUP($C24,Calcs,col_Description,0),VLOOKUP($C24,Calcs,col_D+COUNTIF($C$12:$C24,$C24)-2,0)+1,VLOOKUP($C24,Calcs,col_D+COUNTIF($C$12:$C24,$C24)-1,0)-VLOOKUP($C24,Calcs,col_D+COUNTIF($C$12:$C24,$C24)-2,0))))","v":"lining"},"m2","","","","","","","","","","","","","","165",{"$f":"IF(OR($A24>End,COUNTIF($C$12:$C24,$C24)>lines_R),\"\",IF(COUNTIF($C$12:$C24,$C24)=1,LEFT(VLOOKUP($C24,Calcs,col_Remarks,0),VLOOKUP($C24,Calcs,col_R,0)),MID(VLOOKUP($C24,Calcs,col_Remarks,0),VLOOKUP($C24,Calcs,col_R+COUNTIF($C$12:$C24,$C24)-2,0)+1,VLOOKUP($C24,Calcs,col_R+COUNTIF($C$12:$C24,$C24)-1,0)-VLOOKUP($C24,Calcs,col_R+COUNTIF($C$12:$C24,$C24)-2,0))))","v":""}]
[13,false,14,null,null,0,"A0070","15705-0100",{"$f":"IF(OR($A25>End,COUNTIF($C$12:$C25,$C25)>lines_D),\"\",IF(COUNTIF($C$12:$C25,$C25)=1,LEFT(VLOOKUP($C25,Calcs,col_Description,0),VLOOKUP($C25,Calcs,col_D,0)),MID(VLOOKUP($C25,Calcs,col_Description,0),VLOOKUP($C25,Calcs,col_D+COUNTIF($C$12:$C25,$C25)-2,0)+1,VLOOKUP($C25,Calcs,col_D+COUNTIF($C$12:$C25,$C25)-1,0)-VLOOKUP($C25,Calcs,col_D+COUNTIF($C$12:$C25,$C25)-2,0))))","v":"Soil erosion control, silt fence"},"","","","","","","1,630","","","","","","","","",{"$f":"IF(OR($A25>End,COUNTIF($C$12:$C25,$C25)>lines_R),\"\",IF(COUNTIF($C$12:$C25,$C25)=1,LEFT(VLOOKUP($C25,Calcs,col_Remarks,0),VLOOKUP($C25,Calcs,col_R,0)),MID(VLOOKUP($C25,Calcs,col_Remarks,0),VLOOKUP($C25,Calcs,col_R+COUNTIF($C$12:$C25,$C25)-2,0)+1,VLOOKUP($C25,Calcs,col_R+COUNTIF($C$12:$C25,$C25)-1,0)-VLOOKUP($C25,Calcs,col_R+COUNTIF($C$12:$C25,$C25)-2,0))))","v":""}]
[14,false,14,null,null,"","","",{"$f":"IF(OR($A26>End,COUNTIF($C$12:$C26,$C26)>lines_D),\"\",IF(COUNTIF($C$12:$C26,$C26)=1,LEFT(VLOOKUP($C26,Calcs,col_Description,0),VLOOKUP($C26,Calcs,col_D,0)),MID(VLOOKUP($C26,Calcs,col_Description,0),VLOOKUP($C26,Calcs,col_D+COUNTIF($C$12:$C26,$C26)-2,0)+1,VLOOKUP($C26,Calcs,col_D+COUNTIF($C$12:$C26,$C26)-1,0)-VLOOKUP($C26,Calcs,col_D+COUNTIF($C$12:$C26,$C26)-2,0))))","v":""},"m","","","","","","","","","","","","","","1,630",{"$f":"IF(OR($A26>End,COUNTIF($C$12:$C26,$C26)>lines_R),\"\",IF(COUNTIF($C$12:$C26,$C26)=1,LEFT(VLOOKUP($C26,Calcs,col_Remarks,0),VLOOKUP($C26,Calcs,col_R,0)),MID(VLOOKUP($C26,Calcs,col_Remarks,0),VLOOKUP($C26,Calcs,col_R+COUNTIF($C$12:$C26,$C26)-2,0)+1,VLOOKUP($C26,Calcs,col_R+COUNTIF($C$12:$C26,$C26)-1,0)-VLOOKUP($C26,Calcs,col_R+COUNTIF($C$12:$C26,$C26)-2,0))))","v":""}]
[15,false,16,null,null,0,"A0080","15705-0600",{"$f":"IF(OR($A27>End,COUNTIF($C$12:$C27,$C27)>lines_D),\"\",IF(COUNTIF($C$12:$C27,$C27)=1,LEFT(VLOOKUP($C27,Calcs,col_Description,0),VLOOKUP($C27,Calcs,col_D,0)),MID(VLOOKUP($C27,Calcs,col_Description,0),VLOOKUP($C27,Calcs,col_D+COUNTIF($C$12:$C27,$C27)-2,0)+1,VLOOKUP($C27,Calcs,col_D+COUNTIF($C$12:$C27,$C27)-1,0)-VLOOKUP($C27,Calcs,col_D+COUNTIF($C$12:$C27,$C27)-2,0))))","v":"Soil erosion control, temporary "},"","","","","","","16","","","","","4","","","",{"$f":"IF(OR($A27>End,COUNTIF($C$12:$C27,$C27)>lines_R),\"\",IF(COUNTIF($C$12:$C27,$C27)=1,LEFT(VLOOKUP($C27,Calcs,col_Remarks,0),VLOOKUP($C27,Calcs,col_R,0)),MID(VLOOKUP($C27,Calcs,col_Remarks,0),VLOOKUP($C27,Calcs,col_R+COUNTIF($C$12:$C27,$C27)-2,0)+1,VLOOKUP($C27,Calcs,col_R+COUNTIF($C$12:$C27,$C27)-1,0)-VLOOKUP($C27,Calcs,col_R+COUNTIF($C$12:$C27,$C27)-2,0))))","v":""}]
[16,false,16,null,null,"","","",{"$f":"IF(OR($A28>End,COUNTIF($C$12:$C28,$C28)>lines_D),\"\",IF(COUNTIF($C$12:$C28,$C28)=1,LEFT(VLOOKUP($C28,Calcs,col_Description,0),VLOOKUP($C28,Calcs,col_D,0)),MID(VLOOKUP($C28,Calcs,col_Description,0),VLOOKUP($C28,Calcs,col_D+COUNTIF($C$12:$C28,$C28)-2,0)+1,VLOOKUP($C28,Calcs,col_D+COUNTIF($C$12:$C28,$C28)-1,0)-VLOOKUP($C28,Calcs,col_D+COUNTIF($C$12:$C28,$C28)-2,0))))","v":"600mm culvert pipe"},"m","","","","","","","","","","","","","","20",{"$f":"IF(OR($A28>End,COUNTIF($C$12:$C28,$C28)>lines_R),\"\",IF(COUNTIF($C$12:$C28,$C28)=1,LEFT(VLOOKUP($C28,Calcs,col_Remarks,0),VLOOKUP($C28,Calcs,col_R,0)),MID(VLOOKUP($C28,Calcs,col_Remarks,0),VLOOKUP($C28,Calcs,col_R+COUNTIF($C$12:$C28,$C28)-2,0)+1,VLOOKUP($C28,Calcs,col_R+COUNTIF($C$12:$C28,$C28)-1,0)-VLOOKUP($C28,Calcs,col_R+COUNTIF($C$12:$C28,$C28)-2,0))))","v":""}]
[17,false,18,null,null,0,"A0090","15705-1300",{"$f":"IF(OR($A29>End,COUNTIF($C$12:$C29,$C29)>lines_D),\"\",IF(COUNTIF($C$12:$C29,$C29)=1,LEFT(VLOOKUP($C29,Calcs,col_Description,0),VLOOKUP($C29,Calcs,col_D,0)),MID(VLOOKUP($C29,Calcs,col_Description,0),VLOOKUP($C29,Calcs,col_D+COUNTIF($C$12:$C29,$C29)-2,0)+1,VLOOKUP($C29,Calcs,col_D+COUNTIF($C$12:$C29,$C29)-1,0)-VLOOKUP($C29,Calcs,col_D+COUNTIF($C$12:$C29,$C29)-2,0))))","v":"Soil erosion control, temporary "},"","","","","","","33","","","","","2","","","",{"$f":"IF(OR($A29>End,COUNTIF($C$12:$C29,$C29)>lines_R),\"\",IF(COUNTIF($C$12:$C29,$C29)=1,LEFT(VLOOKUP($C29,Calcs,col_Remarks,0),VLOOKUP($C29,Calcs,col_R,0)),MID(VLOOKUP($C29,Calcs,col_Remarks,0),VLOOKUP($C29,Calcs,col_R+COUNTIF($C$12:$C29,$C29)-2,0)+1,VLOOKUP($C29,Calcs,col_R+COUNTIF($C$12:$C29,$C29)-1,0)-VLOOKUP($C29,Calcs,col_R+COUNTIF($C$12:$C29,$C29)-2,0))))","v":""}]
[18,false,18,null,null,"","","",{"$f":"IF(OR($A30>End,COUNTIF($C$12:$C30,$C30)>lines_D),\"\",IF(COUNTIF($C$12:$C30,$C30)=1,LEFT(VLOOKUP($C30,Calcs,col_Description,0),VLOOKUP($C30,Calcs,col_D,0)),MID(VLOOKUP($C30,Calcs,col_Description,0),VLOOKUP($C30,Calcs,col_D+COUNTIF($C$12:$C30,$C30)-2,0)+1,VLOOKUP($C30,Calcs,col_D+COUNTIF($C$12:$C30,$C30)-1,0)-VLOOKUP($C30,Calcs,col_D+COUNTIF($C$12:$C30,$C30)-2,0))))","v":"diversion channel"},"m","","","","","","","","","","","","","","35",{"$f":"IF(OR($A30>End,COUNTIF($C$12:$C30,$C30)>lines_R),\"\",IF(COUNTIF($C$12:$C30,$C30)=1,LEFT(VLOOKUP($C30,Calcs,col_Remarks,0),VLOOKUP($C30,Calcs,col_R,0)),MID(VLOOKUP($C30,Calcs,col_Remarks,0),VLOOKUP($C30,Calcs,col_R+COUNTIF($C$12:$C30,$C30)-2,0)+1,VLOOKUP($C30,Calcs,col_R+COUNTIF($C$12:$C30,$C30)-1,0)-VLOOKUP($C30,Calcs,col_R+COUNTIF($C$12:$C30,$C30)-2,0))))","v":""}]
[19,false,20,null,null,0,"A0100","15705-1400",{"$f":"IF(OR($A31>End,COUNTIF($C$12:$C31,$C31)>lines_D),\"\",IF(COUNTIF($C$12:$C31,$C31)=1,LEFT(VLOOKUP($C31,Calcs,col_Description,0),VLOOKUP($C31,Calcs,col_D,0)),MID(VLOOKUP($C31,Calcs,col_Description,0),VLOOKUP($C31,Calcs,col_D+COUNTIF($C$12:$C31,$C31)-2,0)+1,VLOOKUP($C31,Calcs,col_D+COUNTIF($C$12:$C31,$C31)-1,0)-VLOOKUP($C31,Calcs,col_D+COUNTIF($C$12:$C31,$C31)-2,0))))","v":"Soil erosion control, sediment log"},"","","","","","","36","","","","","4","","","",{"$f":"IF(OR($A31>End,COUNTIF($C$12:$C31,$C31)>lines_R),\"\",IF(COUNTIF($C$12:$C31,$C31)=1,LEFT(VLOOKUP($C31,Calcs,col_Remarks,0),VLOOKUP($C31,Calcs,col_R,0)),MID(VLOOKUP($C31,Calcs,col_Remarks,0),VLOOKUP($C31,Calcs,col_R+COUNTIF($C$12:$C31,$C31)-2,0)+1,VLOOKUP($C31,Calcs,col_R+COUNTIF($C$12:$C31,$C31)-1,0)-VLOOKUP($C31,Calcs,col_R+COUNTIF($C$12:$C31,$C31)-2,0))))","v":""}]
[20,false,20,null,null,"","","",{"$f":"IF(OR($A32>End,COUNTIF($C$12:$C32,$C32)>lines_D),\"\",IF(COUNTIF($C$12:$C32,$C32)=1,LEFT(VLOOKUP($C32,Calcs,col_Description,0),VLOOKUP($C32,Calcs,col_D,0)),MID(VLOOKUP($C32,Calcs,col_Description,0),VLOOKUP($C32,Calcs,col_D+COUNTIF($C$12:$C32,$C32)-2,0)+1,VLOOKUP($C32,Calcs,col_D+COUNTIF($C$12:$C32,$C32)-1,0)-VLOOKUP($C32,Calcs,col_D+COUNTIF($C$12:$C32,$C32)-2,0))))","v":""},"m","","","","","","","","","","","","","","40",{"$f":"IF(OR($A32>End,COUNTIF($C$12:$C32,$C32)>lines_R),\"\",IF(COUNTIF($C$12:$C32,$C32)=1,LEFT(VLOOKUP($C32,Calcs,col_Remarks,0),VLOOKUP($C32,Calcs,col_R,0)),MID(VLOOKUP($C32,Calcs,col_Remarks,0),VLOOKUP($C32,Calcs,col_R+COUNTIF($C$12:$C32,$C32)-2,0)+1,VLOOKUP($C32,Calcs,col_R+COUNTIF($C$12:$C32,$C32)-1,0)-VLOOKUP($C32,Calcs,col_R+COUNTIF($C$12:$C32,$C32)-2,0))))","v":""}]
[21,false,22,null,null,{"$f":"IF(OR($C33=OFFSET($C33,-1,0),$A33>End),\"\",OFFSET(EEBACS,MATCH($C33,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),F$2,1,1))","v":0},"A0110","15706-0300",{"$f":"IF(OR($A33>End,COUNTIF($C$12:$C33,$C33)>lines_D),\"\",IF(COUNTIF($C$12:$C33,$C33)=1,LEFT(VLOOKUP($C33,Calcs,col_Description,0),VLOOKUP($C33,Calcs,col_D,0)),MID(VLOOKUP($C33,Calcs,col_Description,0),VLOOKUP($C33,Calcs,col_D+COUNTIF($C$12:$C33,$C33)-2,0)+1,VLOOKUP($C33,Calcs,col_D+COUNTIF($C$12:$C33,$C33)-1,0)-VLOOKUP($C33,Calcs,col_D+COUNTIF($C$12:$C33,$C33)-2,0))))","v":"Soil erosion control, sandbag"},"",{"$f":"IF(OR($C33=OFFSET($C33,2,0),$A33>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C33,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),IF($C33=OFFSET($C33,1,0),K$2,K$4),1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"","","","","200","","","","","10","","",{"$f":"IF(OR($C33=OFFSET($C33,1,0),$A33>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C33,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),X$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},{"$f":"IF(OR($A33>End,COUNTIF($C$12:$C33,$C33)>lines_R),\"\",IF(COUNTIF($C$12:$C33,$C33)=1,LEFT(VLOOKUP($C33,Calcs,col_Remarks,0),VLOOKUP($C33,Calcs,col_R,0)),MID(VLOOKUP($C33,Calcs,col_Remarks,0),VLOOKUP($C33,Calcs,col_R+COUNTIF($C$12:$C33,$C33)-2,0)+1,VLOOKUP($C33,Calcs,col_R+COUNTIF($C$12:$C33,$C33)-1,0)-VLOOKUP($C33,Calcs,col_R+COUNTIF($C$12:$C33,$C33)-2,0))))","v":""}]
[22,false,22,null,null,"","","",{"$f":"IF(OR($A34>End,COUNTIF($C$12:$C34,$C34)>lines_D),\"\",IF(COUNTIF($C$12:$C34,$C34)=1,LEFT(VLOOKUP($C34,Calcs,col_Description,0),VLOOKUP($C34,Calcs,col_D,0)),MID(VLOOKUP($C34,Calcs,col_Description,0),VLOOKUP($C34,Calcs,col_D+COUNTIF($C$12:$C34,$C34)-2,0)+1,VLOOKUP($C34,Calcs,col_D+COUNTIF($C$12:$C34,$C34)-1,0)-VLOOKUP($C34,Calcs,col_D+COUNTIF($C$12:$C34,$C34)-2,0))))","v":""},"Each","","","","","","","","","","","","","","210",{"$f":"IF(OR($A34>End,COUNTIF($C$12:$C34,$C34)>lines_R),\"\",IF(COUNTIF($C$12:$C34,$C34)=1,LEFT(VLOOKUP($C34,Calcs,col_Remarks,0),VLOOKUP($C34,Calcs,col_R,0)),MID(VLOOKUP($C34,Calcs,col_Remarks,0),VLOOKUP($C34,Calcs,col_R+COUNTIF($C$12:$C34,$C34)-2,0)+1,VLOOKUP($C34,Calcs,col_R+COUNTIF($C$12:$C34,$C34)-1,0)-VLOOKUP($C34,Calcs,col_R+COUNTIF($C$12:$C34,$C34)-2,0))))","v":""}]
[23,false,24,null,null,0,"A0120","20101-0000",{"$f":"IF(OR($A35>End,COUNTIF($C$12:$C35,$C35)>lines_D),\"\",IF(COUNTIF($C$12:$C35,$C35)=1,LEFT(VLOOKUP($C35,Calcs,col_Description,0),VLOOKUP($C35,Calcs,col_D,0)),MID(VLOOKUP($C35,Calcs,col_Description,0),VLOOKUP($C35,Calcs,col_D+COUNTIF($C$12:$C35,$C35)-2,0)+1,VLOOKUP($C35,Calcs,col_D+COUNTIF($C$12:$C35,$C35)-1,0)-VLOOKUP($C35,Calcs,col_D+COUNTIF($C$12:$C35,$C35)-2,0))))","v":"Clearing and grubbing"},"","","0.11","0.45","","","","","","","","0.02","","","",{"$f":"IF(OR($A35>End,COUNTIF($C$12:$C35,$C35)>lines_R),\"\",IF(COUNTIF($C$12:$C35,$C35)=1,LEFT(VLOOKUP($C35,Calcs,col_Remarks,0),VLOOKUP($C35,Calcs,col_R,0)),MID(VLOOKUP($C35,Calcs,col_Remarks,0),VLOOKUP($C35,Calcs,col_R+COUNTIF($C$12:$C35,$C35)-2,0)+1,VLOOKUP($C35,Calcs,col_R+COUNTIF($C$12:$C35,$C35)-1,0)-VLOOKUP($C35,Calcs,col_R+COUNTIF($C$12:$C35,$C35)-2,0))))","v":""}]
[24,false,24,null,null,"","","",{"$f":"IF(OR($A36>End,COUNTIF($C$12:$C36,$C36)>lines_D),\"\",IF(COUNTIF($C$12:$C36,$C36)=1,LEFT(VLOOKUP($C36,Calcs,col_Description,0),VLOOKUP($C36,Calcs,col_D,0)),MID(VLOOKUP($C36,Calcs,col_Description,0),VLOOKUP($C36,Calcs,col_D+COUNTIF($C$12:$C36,$C36)-2,0)+1,VLOOKUP($C36,Calcs,col_D+COUNTIF($C$12:$C36,$C36)-1,0)-VLOOKUP($C36,Calcs,col_D+COUNTIF($C$12:$C36,$C36)-2,0))))","v":""},"ha","","","","","","","","","","","","","","0.58",{"$f":"IF(OR($A36>End,COUNTIF($C$12:$C36,$C36)>lines_R),\"\",IF(COUNTIF($C$12:$C36,$C36)=1,LEFT(VLOOKUP($C36,Calcs,col_Remarks,0),VLOOKUP($C36,Calcs,col_R,0)),MID(VLOOKUP($C36,Calcs,col_Remarks,0),VLOOKUP($C36,Calcs,col_R+COUNTIF($C$12:$C36,$C36)-2,0)+1,VLOOKUP($C36,Calcs,col_R+COUNTIF($C$12:$C36,$C36)-1,0)-VLOOKUP($C36,Calcs,col_R+COUNTIF($C$12:$C36,$C36)-2,0))))","v":""}]
[25,false,26,null,null,0,"A0130","20103-0000",{"$f":"IF(OR($A37>End,COUNTIF($C$12:$C37,$C37)>lines_D),\"\",IF(COUNTIF($C$12:$C37,$C37)=1,LEFT(VLOOKUP($C37,Calcs,col_Description,0),VLOOKUP($C37,Calcs,col_D,0)),MID(VLOOKUP($C37,Calcs,col_Description,0),VLOOKUP($C37,Calcs,col_D+COUNTIF($C$12:$C37,$C37)-2,0)+1,VLOOKUP($C37,Calcs,col_D+COUNTIF($C$12:$C37,$C37)-1,0)-VLOOKUP($C37,Calcs,col_D+COUNTIF($C$12:$C37,$C37)-2,0))))","v":"Clearing and grubbing"},"","","","","","675","","","","","","25","","","",{"$f":"IF(OR($A37>End,COUNTIF($C$12:$C37,$C37)>lines_R),\"\",IF(COUNTIF($C$12:$C37,$C37)=1,LEFT(VLOOKUP($C37,Calcs,col_Remarks,0),VLOOKUP($C37,Calcs,col_R,0)),MID(VLOOKUP($C37,Calcs,col_Remarks,0),VLOOKUP($C37,Calcs,col_R+COUNTIF($C$12:$C37,$C37)-2,0)+1,VLOOKUP($C37,Calcs,col_R+COUNTIF($C$12:$C37,$C37)-1,0)-VLOOKUP($C37,Calcs,col_R+COUNTIF($C$12:$C37,$C37)-2,0))))","v":""}]
[26,false,26,null,null,"","","",{"$f":"IF(OR($A38>End,COUNTIF($C$12:$C38,$C38)>lines_D),\"\",IF(COUNTIF($C$12:$C38,$C38)=1,LEFT(VLOOKUP($C38,Calcs,col_Description,0),VLOOKUP($C38,Calcs,col_D,0)),MID(VLOOKUP($C38,Calcs,col_Description,0),VLOOKUP($C38,Calcs,col_D+COUNTIF($C$12:$C38,$C38)-2,0)+1,VLOOKUP($C38,Calcs,col_D+COUNTIF($C$12:$C38,$C38)-1,0)-VLOOKUP($C38,Calcs,col_D+COUNTIF($C$12:$C38,$C38)-2,0))))","v":""},"m2","","","","","","","","","","","","","","700",{"$f":"IF(OR($A38>End,COUNTIF($C$12:$C38,$C38)>lines_R),\"\",IF(COUNTIF($C$12:$C38,$C38)=1,LEFT(VLOOKUP($C38,Calcs,col_Remarks,0),VLOOKUP($C38,Calcs,col_R,0)),MID(VLOOKUP($C38,Calcs,col_Remarks,0),VLOOKUP($C38,Calcs,col_R+COUNTIF($C$12:$C38,$C38)-2,0)+1,VLOOKUP($C38,Calcs,col_R+COUNTIF($C$12:$C38,$C38)-1,0)-VLOOKUP($C38,Calcs,col_R+COUNTIF($C$12:$C38,$C38)-2,0))))","v":""}]
[27,false,28,null,null,0,"A0140","20212-0000",{"$f":"IF(OR($A39>End,COUNTIF($C$12:$C39,$C39)>lines_D),\"\",IF(COUNTIF($C$12:$C39,$C39)=1,LEFT(VLOOKUP($C39,Calcs,col_Description,0),VLOOKUP($C39,Calcs,col_D,0)),MID(VLOOKUP($C39,Calcs,col_Description,0),VLOOKUP($C39,Calcs,col_D+COUNTIF($C$12:$C39,$C39)-2,0)+1,VLOOKUP($C39,Calcs,col_D+COUNTIF($C$12:$C39,$C39)-1,0)-VLOOKUP($C39,Calcs,col_D+COUNTIF($C$12:$C39,$C39)-2,0))))","v":"Special clearing"},"","","1,672","","","","","","","","","78","","","",{"$f":"IF(OR($A39>End,COUNTIF($C$12:$C39,$C39)>lines_R),\"\",IF(COUNTIF($C$12:$C39,$C39)=1,LEFT(VLOOKUP($C39,Calcs,col_Remarks,0),VLOOKUP($C39,Calcs,col_R,0)),MID(VLOOKUP($C39,Calcs,col_Remarks,0),VLOOKUP($C39,Calcs,col_R+COUNTIF($C$12:$C39,$C39)-2,0)+1,VLOOKUP($C39,Calcs,col_R+COUNTIF($C$12:$C39,$C39)-1,0)-VLOOKUP($C39,Calcs,col_R+COUNTIF($C$12:$C39,$C39)-2,0))))","v":""}]
[28,false,28,null,null,"","","",{"$f":"IF(OR($A40>End,COUNTIF($C$12:$C40,$C40)>lines_D),\"\",IF(COUNTIF($C$12:$C40,$C40)=1,LEFT(VLOOKUP($C40,Calcs,col_Description,0),VLOOKUP($C40,Calcs,col_D,0)),MID(VLOOKUP($C40,Calcs,col_Description,0),VLOOKUP($C40,Calcs,col_D+COUNTIF($C$12:$C40,$C40)-2,0)+1,VLOOKUP($C40,Calcs,col_D+COUNTIF($C$12:$C40,$C40)-1,0)-VLOOKUP($C40,Calcs,col_D+COUNTIF($C$12:$C40,$C40)-2,0))))","v":""},"m2","","","","","","","","","","","","","","1,750",{"$f":"IF(OR($A40>End,COUNTIF($C$12:$C40,$C40)>lines_R),\"\",IF(COUNTIF($C$12:$C40,$C40)=1,LEFT(VLOOKUP($C40,Calcs,col_Remarks,0),VLOOKUP($C40,Calcs,col_R,0)),MID(VLOOKUP($C40,Calcs,col_Remarks,0),VLOOKUP($C40,Calcs,col_R+COUNTIF($C$12:$C40,$C40)-2,0)+1,VLOOKUP($C40,Calcs,col_R+COUNTIF($C$12:$C40,$C40)-1,0)-VLOOKUP($C40,Calcs,col_R+COUNTIF($C$12:$C40,$C40)-2,0))))","v":""}]
[29,false,30,null,null,0,"A0150","20301-0080",{"$f":"IF(OR($A41>End,COUNTIF($C$12:$C41,$C41)>lines_D),\"\",IF(COUNTIF($C$12:$C41,$C41)=1,LEFT(VLOOKUP($C41,Calcs,col_Description,0),VLOOKUP($C41,Calcs,col_D,0)),MID(VLOOKUP($C41,Calcs,col_Description,0),VLOOKUP($C41,Calcs,col_D+COUNTIF($C$12:$C41,$C41)-2,0)+1,VLOOKUP($C41,Calcs,col_D+COUNTIF($C$12:$C41,$C41)-1,0)-VLOOKUP($C41,Calcs,col_D+COUNTIF($C$12:$C41,$C41)-2,0))))","v":"Removal of bench"},"","","","6","","","","","","","","","","","",{"$f":"IF(OR($A41>End,COUNTIF($C$12:$C41,$C41)>lines_R),\"\",IF(COUNTIF($C$12:$C41,$C41)=1,LEFT(VLOOKUP($C41,Calcs,col_Remarks,0),VLOOKUP($C41,Calcs,col_R,0)),MID(VLOOKUP($C41,Calcs,col_Remarks,0),VLOOKUP($C41,Calcs,col_R+COUNTIF($C$12:$C41,$C41)-2,0)+1,VLOOKUP($C41,Calcs,col_R+COUNTIF($C$12:$C41,$C41)-1,0)-VLOOKUP($C41,Calcs,col_R+COUNTIF($C$12:$C41,$C41)-2,0))))","v":""}]
[30,false,30,null,null,"","","",{"$f":"IF(OR($A42>End,COUNTIF($C$12:$C42,$C42)>lines_D),\"\",IF(COUNTIF($C$12:$C42,$C42)=1,LEFT(VLOOKUP($C42,Calcs,col_Description,0),VLOOKUP($C42,Calcs,col_D,0)),MID(VLOOKUP($C42,Calcs,col_Description,0),VLOOKUP($C42,Calcs,col_D+COUNTIF($C$12:$C42,$C42)-2,0)+1,VLOOKUP($C42,Calcs,col_D+COUNTIF($C$12:$C42,$C42)-1,0)-VLOOKUP($C42,Calcs,col_D+COUNTIF($C$12:$C42,$C42)-2,0))))","v":""},"Each","","","","","","","","","","","","","","6",{"$f":"IF(OR($A42>End,COUNTIF($C$12:$C42,$C42)>lines_R),\"\",IF(COUNTIF($C$12:$C42,$C42)=1,LEFT(VLOOKUP($C42,Calcs,col_Remarks,0),VLOOKUP($C42,Calcs,col_R,0)),MID(VLOOKUP($C42,Calcs,col_Remarks,0),VLOOKUP($C42,Calcs,col_R+COUNTIF($C$12:$C42,$C42)-2,0)+1,VLOOKUP($C42,Calcs,col_R+COUNTIF($C$12:$C42,$C42)-1,0)-VLOOKUP($C42,Calcs,col_R+COUNTIF($C$12:$C42,$C42)-2,0))))","v":""}]
[31,false,32,null,null,0,"A0160","20301-0500",{"$f":"IF(OR($A43>End,COUNTIF($C$12:$C43,$C43)>lines_D),\"\",IF(COUNTIF($C$12:$C43,$C43)=1,LEFT(VLOOKUP($C43,Calcs,col_Description,0),VLOOKUP($C43,Calcs,col_D,0)),MID(VLOOKUP($C43,Calcs,col_Description,0),VLOOKUP($C43,Calcs,col_D+COUNTIF($C$12:$C43,$C43)-2,0)+1,VLOOKUP($C43,Calcs,col_D+COUNTIF($C$12:$C43,$C43)-1,0)-VLOOKUP($C43,Calcs,col_D+COUNTIF($C$12:$C43,$C43)-2,0))))","v":"Removal of catch basin"},"",{"$f":"IF(OR($C43=OFFSET($C43,2,0),$A43>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C43,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),IF($C43=OFFSET($C43,1,0),K$2,K$4),1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},"","","2","","","","","","","","","",{"$f":"IF(OR($C43=OFFSET($C43,1,0),$A43>End),\"\",SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,MATCH($C43,OFFSET(Calcs,0,0,ROWS(Calcs),1),0),X$2,1,1),\"All|\",\"\",1),\"||\",\"\"))","v":""},{"$f":"IF(OR($A43>End,COUNTIF($C$12:$C43,$C43)>lines_R),\"\",IF(COUNTIF($C$12:$C43,$C43)=1,LEFT(VLOOKUP($C43,Calcs,col_Remarks,0),VLOOKUP($C43,Calcs,col_R,0)),MID(VLOOKUP($C43,Calcs,col_Remarks,0),VLOOKUP($C43,Calcs,col_R+COUNTIF($C$12:$C43,$C43)-2,0)+1,VLOOKUP($C43,Calcs,col_R+COUNTIF($C$12:$C43,$C43)-1,0)-VLOOKUP($C43,Calcs,col_R+COUNTIF($C$12:$C43,$C43)-2,0))))","v":""}]
[32,false,32,null,null,"","","",{"$f":"IF(OR($A44>End,COUNTIF($C$12:$C44,$C44)>lines_D),\"\",IF(COUNTIF($C$12:$C44,$C44)=1,LEFT(VLOOKUP($C44,Calcs,col_Description,0),VLOOKUP($C44,Calcs,col_D,0)),MID(VLOOKUP($C44,Calcs,col_Description,0),VLOOKUP($C44,Calcs,col_D+COUNTIF($C$12:$C44,$C44)-2,0)+1,VLOOKUP($C44,Calcs,col_D+COUNTIF($C$12:$C44,$C44)-1,0)-VLOOKUP($C44,Calcs,col_D+COUNTIF($C$12:$C44,$C44)-2,0))))","v":""},"Each","","","","","","","","","","","","","","2",{"$f":"IF(OR($A44>End,COUNTIF($C$12:$C44,$C44)>lines_R),\"\",IF(COUNTIF($C$12:$C44,$C44)=1,LEFT(VLOOKUP($C44,Calcs,col_Remarks,0),VLOOKUP($C44,Calcs,col_R,0)),MID(VLOOKUP($C44,Calcs,col_Remarks,0),VLOOKUP($C44,Calcs,col_R+COUNTIF($C$12:$C44,$C44)-2,0)+1,VLOOKUP($C44,Calcs,col_R+COUNTIF($C$12:$C44,$C44)-1,0)-VLOOKUP($C44,Calcs,col_R+COUNTIF($C$12:$C44,$C44)-2,0))))","v":""}]
[33,false,34,{"$f":"TEXT(NOW(),\"d-mmm-yyyy h:mm AM/PM\")","v":"3-Nov-2022 2:43 PM"},null,0,"A0170","20301-1200",{"$f":"IF(OR($A45>End,COUNTIF($C$12:$C45,$C45)>lines_D),\"\",IF(COUNTIF($C$12:$C45,$C45)=1,LEFT(VLOOKUP($C45,Calcs,col_Description,0),VLOOKUP($C45,Calcs,col_D,0)),MID(VLOOKUP($C45,Calcs,col_Description,0),VLOOKUP($C45,Calcs,col_D+COUNTIF($C$12:$C45,$C45)-2,0)+1,VLOOKUP($C45,Calcs,col_D+COUNTIF($C$12:$C45,$C45)-1,0)-VLOOKUP($C45,Calcs,col_D+COUNTIF($C$12:$C45,$C45)-2,0))))","v":"Removal of headwall"},"","","","","1","","","","","","","","","","",{"$f":"IF(OR($A45>End,COUNTIF($C$12:$C45,$C45)>lines_R),\"\",IF(COUNTIF($C$12:$C45,$C45)=1,LEFT(VLOOKUP($C45,Calcs,col_Remarks,0),VLOOKUP($C45,Calcs,col_R,0)),MID(VLOOKUP($C45,Calcs,col_Remarks,0),VLOOKUP($C45,Calcs,col_R+COUNTIF($C$12:$C45,$C45)-2,0)+1,VLOOKUP($C45,Calcs,col_R+COUNTIF($C$12:$C45,$C45)-1,0)-VLOOKUP($C45,Calcs,col_R+COUNTIF($C$12:$C45,$C45)-2,0))))","v":""}]
[34,false,34,null,null,"","","",{"$f":"IF(OR($A46>End,COUNTIF($C$12:$C46,$C46)>lines_D),\"\",IF(COUNTIF($C$12:$C46,$C46)=1,LEFT(VLOOKUP($C46,Calcs,col_Description,0),VLOOKUP($C46,Calcs,col_D,0)),MID(VLOOKUP($C46,Calcs,col_Description,0),VLOOKUP($C46,Calcs,col_D+COUNTIF($C$12:$C46,$C46)-2,0)+1,VLOOKUP($C46,Calcs,col_D+COUNTIF($C$12:$C46,$C46)-1,0)-VLOOKUP($C46,Calcs,col_D+COUNTIF($C$12:$C46,$C46)-2,0))))","v":""},"Each","","","","","","","","","","","","","","1",{"$f":"IF(OR($A46>End,COUNTIF($C$12:$C46,$C46)>lines_R),\"\",IF(COUNTIF($C$12:$C46,$C46)=1,LEFT(VLOOKUP($C46,Calcs,col_Remarks,0),VLOOKUP($C46,Calcs,col_R,0)),MID(VLOOKUP($C46,Calcs,col_Remarks,0),VLOOKUP($C46,Calcs,col_R+COUNTIF($C$12:$C46,$C46)-2,0)+1,VLOOKUP($C46,Calcs,col_R+COUNTIF($C$12:$C46,$C46)-1,0)-VLOOKUP($C46,Calcs,col_R+COUNTIF($C$12:$C46,$C46)-2,0))))","v":""}]
[35,false,36,null,null,0,"A0180","20301-1400",{"$f":"IF(OR($A47>End,COUNTIF($C$12:$C47,$C47)>lines_D),\"\",IF(COUNTIF($C$12:$C47,$C47)=1,LEFT(VLOOKUP($C47,Calcs,col_Description,0),VLOOKUP($C47,Calcs,col_D,0)),MID(VLOOKUP($C47,Calcs,col_Description,0),VLOOKUP($C47,Calcs,col_D+COUNTIF($C$12:$C47,$C47)-2,0)+1,VLOOKUP($C47,Calcs,col_D+COUNTIF($C$12:$C47,$C47)-1,0)-VLOOKUP($C47,Calcs,col_D+COUNTIF($C$12:$C47,$C47)-2,0))))","v":"Removal of inlet"},"","","","","7","","","","","","","","","","",{"$f":"IF(OR($A47>End,COUNTIF($C$12:$C47,$C47)>lines_R),\"\",IF(COUNTIF($C$12:$C47,$C47)=1,LEFT(VLOOKUP($C47,Calcs,col_Remarks,0),VLOOKUP($C47,Calcs,col_R,0)),MID(VLOOKUP($C47,Calcs,col_Remarks,0),VLOOKUP($C47,Calcs,col_R+COUNTIF($C$12:$C47,$C47)-2,0)+1,VLOOKUP($C47,Calcs,col_R+COUNTIF($C$12:$C47,$C47)-1,0)-VLOOKUP($C47,Calcs,col_R+COUNTIF($C$12:$C47,$C47)-2,0))))","v":""}]
[36,false,36,null,null,"","","",{"$f":"IF(OR($A48>End,COUNTIF($C$12:$C48,$C48)>lines_D),\"\",IF(COUNTIF($C$12:$C48,$C48)=1,LEFT(VLOOKUP($C48,Calcs,col_Description,0),VLOOKUP($C48,Calcs,col_D,0)),MID(VLOOKUP($C48,Calcs,col_Description,0),VLOOKUP($C48,Calcs,col_D+COUNTIF($C$12:$C48,$C48)-2,0)+1,VLOOKUP($C48,Calcs,col_D+COUNTIF($C$12:$C48,$C48)-1,0)-VLOOKUP($C48,Calcs,col_D+COUNTIF($C$12:$C48,$C48)-2,0))))","v":""},"Each","","","","","","","","","","","","","","7",{"$f":"IF(OR($A48>End,COUNTIF($C$12:$C48,$C48)>lines_R),\"\",IF(COUNTIF($C$12:$C48,$C48)=1,LEFT(VLOOKUP($C48,Calcs,col_Remarks,0),VLOOKUP($C48,Calcs,col_R,0)),MID(VLOOKUP($C48,Calcs,col_Remarks,0),VLOOKUP($C48,Calcs,col_R+COUNTIF($C$12:$C48,$C48)-2,0)+1,VLOOKUP($C48,Calcs,col_R+COUNTIF($C$12:$C48,$C48)-1,0)-VLOOKUP($C48,Calcs,col_R+COUNTIF($C$12:$C48,$C48)-2,0))))","v":""}]
[37,"",0,null,null,"","","",{"$f":"IF(OR($A49>End,COUNTIF($C$12:$C49,$C49)>lines_D),\"\",IF(COUNTIF($C$12:$C49,$C49)=1,LEFT(VLOOKUP($C49,Calcs,col_Description,0),VLOOKUP($C49,Calcs,col_D,0)),MID(VLOOKUP($C49,Calcs,col_Description,0),VLOOKUP($C49,Calcs,col_D+COUNTIF($C$12:$C49,$C49)-2,0)+1,VLOOKUP($C49,Calcs,col_D+COUNTIF($C$12:$C49,$C49)-1,0)-VLOOKUP($C49,Calcs,col_D+COUNTIF($C$12:$C49,$C49)-2,0))))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(OR($A49>End,COUNTIF($C$12:$C49,$C49)>lines_R),\"\",IF(COUNTIF($C$12:$C49,$C49)=1,LEFT(VLOOKUP($C49,Calcs,col_Remarks,0),VLOOKUP($C49,Calcs,col_R,0)),MID(VLOOKUP($C49,Calcs,col_Remarks,0),VLOOKUP($C49,Calcs,col_R+COUNTIF($C$12:$C49,$C49)-2,0)+1,VLOOKUP($C49,Calcs,col_R+COUNTIF($C$12:$C49,$C49)-1,0)-VLOOKUP($C49,Calcs,col_R+COUNTIF($C$12:$C49,$C49)-2,0))))","v":""}]
[{"$f":"IFERROR(INDEX(SheetNames[Begins],MATCH(Sheet.number,SheetNames[Sheet],0)+1),MAX(SheetNames[Begins]))","v":36},null,null,null,null,null,{"$f":"SUBSTITUTE(SUBSTITUTE(OFFSET(EEBACS,1,0),\" Date: \",\" Date: \"),\", \",CHAR(10))","v":"MileStone: PIH\nDate Completed: In Progress\nReport Date: 12/15/10"}]

{"sheet":"Calculations","index":2,"n_rows":92,"n_cols":123,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,39,1,70],[1,71,1,78],[1,81,1,112],[1,113,1,120]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AJ:AJ)","v":179},null,null,null,{"$f":"CELL(\"width\",INDIRECT(CELL(\"address\",OFFSET(INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0,MATCH(AM4,INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0)-1,1,1))))+IF(Metric,4,0)","v":34},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CELL(\"width\",INDIRECT(CELL(\"address\",OFFSET(INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0,MATCH(CC4,INDIRECT(OFFSET(SheetNames[[#Headers],[Worksheet]],1,0)&\"!Header\"),0)-1,1,1))))","v":22}]
[null,{"$f":"ROWS(Data.26)","v":89},{"$f":"COLUMNS(Data.26)","v":34},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(AL4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":2},{"$f":"MATCH(AM4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":4},{"$f":"\"Maximum \"&COLUMNS(AN2:BS2)&\" words in Pay Item Description.\"","v":"Maximum 32 words in Pay Item Description."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMNS(BT2:CA2)","v":8},null,null,null,null,null,null,null,null,{"$f":"MATCH(CC4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":33},{"$f":"\"Maximum \"&COLUMNS(CD2:DI2)&\" words in Remarks.\"","v":"Maximum 32 words in Remarks."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMNS(DJ2:DQ2)","v":8}]
["Data from EEBACS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sched.","Calcs",null,{"$f":"COLUMN(AL3)-COLUMN(Calcs)+1","v":3},{"$f":"COLUMN(AM4)-COLUMN(Calcs)+1","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(BT4)-COLUMN(Calcs)+1","v":37},null,null,null,null,null,null,null,null,{"$f":"COLUMN(CC4)-COLUMN(Calcs)+1","v":46},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(DJ4)-COLUMN(Calcs)+1","v":79},null,null,null,null,null,null,null,null,{"$f":"MATCH(DS4,OFFSET(EEBACS,2,0,1,EEBACS.cols),0)","v":5}]
["MileStone: PIH, Date Completed: In Progress, Report Date: 12/15/10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Counter",{"$f":"OFFSET(AK4,1,0)","v":0},"Line Item No.","Pay Item Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",null,null,null,null,null,null,null,null,"Remarks and/or Determination of Estimated Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,null,null,null,null,null,"Unit"]
["Amendment No.","Line Item No.","Pay Item Number","Pay Item Description","Unit","C: Typical Section","D: Plan, Roadway","E: Layout, Parking Area","F: Drainage","G: Walls","M: Temp. Erosion Control","P: Perm. Traffic Control","***: Column 8","B.66-B.85`: Column 9","-: Column 10","Plan: Allow- ance","C12: Column 12","C13: Column 13","C14: Column 14","C15: Column 15","C16: Column 16","C17: Column 17","C18: Column 18","C19: Column 19","C20: Column 20","C21: Column 21","C22: Column 22","C23: Column 23","C24: Column 24","C25: Column 25","C26: Column 26","Estimated Quantities\\Bid Schedule","Remarks and/or Determination of Estimated Quantity","Deleted",{"$f":"OFFSET(AI5,-1,0)+IF(AK5=OFFSET(AK5,1,0),0,1)","v":1},{"$f":"IF(OFFSET(AJ5,0,col_Unit-COLUMN(AJ5))=\"Unit\",0,OFFSET(AJ5,-1,0)+IF(AL5=AL$4,0,MAX(2,CB5,DR5)))","v":0},{"$f":"IF(OR(AL5=AL$4,OFFSET(AL5,-1,0)=AL$4,LEFT(AL5,1)<>LEFT(OFFSET(AL5,-1,0),1)),AJ5,OFFSET(AK5,-1,0))","v":0},{"$f":"OFFSET(AL5,0,-COLUMN(AL$2)+AL$2)","v":"Line Item No."},{"$f":"SUBSTITUTE(TRIM(OFFSET(AM5,0,-COLUMN(AM$2)+AM$2)),\" , \",\", \")","v":"Pay Item Description"},{"$f":"IFERROR(FIND(\" \",$AM5,IFERROR(OFFSET(AN5,0,-1)+1,1)),LEN($AM5))","v":4},9,20,20,20,20,20,20,20,20,{"$f":"IFERROR(FIND(\" \",$AM5,IFERROR(OFFSET(AX5,0,-1)+1,1)),LEN($AM5))","v":20},20,20,20,20,20,20,20,20,20,{"$f":"IFERROR(FIND(\" \",$AM5,IFERROR(OFFSET(BH5,0,-1)+1,1)),LEN($AM5))","v":20},20,20,20,20,20,20,20,20,20,20,20,{"$f":"HLOOKUP(IF(COLUMN(BT5)-COLUMN($BT$4)=0,0,OFFSET(BT5,0,-1))+width_Pay.item,$AN5:$BS5,1)","v":20},20,20,20,20,20,20,20,{"$f":"IF(LEN(DS5)>0,COUNTIF(BT5:CA5,\"<\"&MAX(BT5:CA5))+1,0)","v":0},{"$f":"TRIM(OFFSET(CC5,0,-COLUMN(CC$2)+CC$2))","v":"Remarks and/or Determination of Estimated Quantity"},{"$f":"IFERROR(FIND(\" \",$CC5,IFERROR(OFFSET(CD5,0,-1)+1,1)),LEN($CC5))","v":8},15,29,32,42,50,50,50,50,50,{"$f":"IFERROR(FIND(\" \",$CC5,IFERROR(OFFSET(CN5,0,-1)+1,1)),LEN($CC5))","v":50},50,50,50,50,50,50,50,50,50,{"$f":"IFERROR(FIND(\" \",$CC5,IFERROR(OFFSET(CX5,0,-1)+1,1)),LEN($CC5))","v":50},50,50,50,50,50,50,50,50,50,50,50,{"$f":"HLOOKUP(IF(COLUMN(DJ5)-COLUMN($DJ$4)=0,0,OFFSET(DJ5,0,-1))+width_Remarks,$CD5:$DI5,1)","v":15},32,50,50,50,50,50,50,{"$f":"IF(LEN(DS5)>0,COUNTIF(DJ5:DQ5,\"<\"&MAX(DJ5:DQ5))+1,0)","v":0},{"$f":"IFERROR(VLOOKUP(OFFSET(DS5,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":""}]
[null,"A0010","15101-0000","Mobilization   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,{"$f":"OFFSET(AI6,-1,0)+IF(AK6=OFFSET(AK6,1,0),0,1)","v":1},{"$f":"IF(OFFSET(AJ6,0,col_Unit-COLUMN(AJ6))=\"Unit\",0,OFFSET(AJ6,-1,0)+IF(AL6=AL$4,0,MAX(2,CB6,DR6)))","v":2},{"$f":"IF(OR(AL6=AL$4,OFFSET(AL6,-1,0)=AL$4,LEFT(AL6,1)<>LEFT(OFFSET(AL6,-1,0),1)),AJ6,OFFSET(AK6,-1,0))","v":2},"A0010","Mobilization",12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,{"$f":"IF(LEN(DS6)>0,COUNTIF(BT6:CA6,\"<\"&MAX(BT6:CA6))+1,0)","v":1},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(LEN(DS6)>0,COUNTIF(DJ6:DQ6,\"<\"&MAX(DJ6:DQ6))+1,0)","v":1},{"$f":"IFERROR(VLOOKUP(OFFSET(DS6,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0020","15201-0000","Construction survey and staking   ","LPSM","All|||","All|All||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,4,2,"A0020","Construction survey and staking",13,20,24,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS7,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0030","15301-0010","Contractor quality control and assurance   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,6,2,"A0030","Contractor quality control and assurance",11,19,27,31,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,31,40,40,40,40,40,40,40,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS8,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0040","15401-0000","Contractor testing   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,8,2,"A0040","Contractor testing",11,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS9,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0050","15501-0000","Construction schedule   ","LPSM","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|ALL||",null,null,1,10,2,"A0050","Construction schedule",13,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS10,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0060","15704-1000","Soil erosion control, plastic lining   ","m2","All|||","All|||","All|||","All|||","All|||","All|165||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|165||",null,null,1,12,2,"A0060","Soil erosion control, plastic lining",5,13,22,30,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,30,36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS11,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0070","15705-0100","Soil erosion control, silt fence   ","m","All|||","All|||","All|||","All|||","All|||","All|1,630||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1,630||",null,null,1,14,2,"A0070","Soil erosion control, silt fence",5,13,22,27,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS12,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0080","15705-0600","Soil erosion control, temporary 600mm culvert pipe   ","m","All|||","All|||","All|||","All|||","All|||","All|16||","All|||","All|||","All|||","All|||","All|4||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20||",null,null,1,16,2,"A0080","Soil erosion control, temporary 600mm culvert pipe",5,13,22,32,38,46,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,32,50,50,50,50,50,50,50,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS13,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0090","15705-1300","Soil erosion control, temporary diversion channel   ","m","All|||","All|||","All|||","All|||","All|||","All|33||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|35||",null,null,1,18,2,"A0090","Soil erosion control, temporary diversion channel",5,13,22,32,42,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,49,32,49,49,49,49,49,49,49,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS14,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0100","15705-1400","Soil erosion control, sediment log   ","m","All|||","All|||","All|||","All|||","All|||","All|36||","All|||","All|||","All|||","All|||","All|4||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||",null,null,1,20,2,"A0100","Soil erosion control, sediment log",5,13,22,31,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS15,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0110","15706-0300","Soil erosion control, sandbag   ","Each","All|||","All|||","All|||","All|||","All|||","All|200||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|210||",null,null,1,22,2,"A0110","Soil erosion control, sandbag",5,13,22,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS16,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0120","20101-0000","Clearing and grubbing   ","ha","All|||","All|0.11||","All|0.45||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|0.02||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|0.58||",null,null,1,24,2,"A0120","Clearing and grubbing",9,13,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS17,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0130","20103-0000","Clearing and grubbing   ","m2","All|||","All|||","All|||","All|||","All|675||","All|||","All|||","All|||","All|||","All|||","All|25||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|700||",null,null,1,26,2,"A0130","Clearing and grubbing",9,13,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS18,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0140","20212-0000","Special clearing   ","m2","All|||","All|1,672||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|78||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1,750||",null,null,1,28,2,"A0140","Special clearing",8,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS19,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0150","20301-0080","Removal of bench   ","Each","All|||","All|||","All|6||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|6||",null,null,1,30,2,"A0150","Removal of bench",8,11,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS20,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0160","20301-0500","Removal of catch basin   ","Each","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||",null,null,1,32,2,"A0160","Removal of catch basin",{"$f":"IFERROR(FIND(\" \",$AM21,IFERROR(OFFSET(AN21,0,-1)+1,1)),LEN($AM21))","v":8},11,17,22,22,22,22,22,22,22,22,22,22,22,22,22,{"$f":"IFERROR(FIND(\" \",$AM21,IFERROR(OFFSET(BD21,0,-1)+1,1)),LEN($AM21))","v":22},22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,1,"",{"$f":"IFERROR(FIND(\" \",$CC21,IFERROR(OFFSET(CD21,0,-1)+1,1)),LEN($CC21))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC21,IFERROR(OFFSET(CT21,0,-1)+1,1)),LEN($CC21))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS21,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0170","20301-1200","Removal of headwall   ","Each","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||",null,null,1,34,2,"A0170","Removal of headwall",8,11,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS22,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0180","20301-1400","Removal of inlet   ","Each","All|||","All|||","All|||","All|7||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|7||",null,null,1,36,2,"A0180","Removal of inlet",8,11,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS23,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0190","20301-2400","Removal of signs   ","Each","All|||","All|||","All|||","All|||","All|||","All|||","All|33||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|34||",null,null,1,38,2,"A0190","Removal of signs",8,11,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS24,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0200","20301-2700","Removal of structure   , timber sidewalk","Each","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||",null,null,1,40,2,"A0200","Removal of structure, timber sidewalk",8,11,22,29,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,29,37,37,37,37,37,37,37,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS25,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0210","20301-2700","Removal of structure   , information box","Each","All|||","All|||","All|||","All|||","All|||","All|||","All|3||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|3||",null,null,1,42,2,"A0210","Removal of structure, information box",8,11,22,34,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,{"$f":"IFERROR(FIND(\" \",$AM26,IFERROR(OFFSET(BN26,0,-1)+1,1)),LEN($AM26))","v":37},37,37,37,37,37,34,37,37,37,37,37,37,37,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC26,IFERROR(OFFSET(DD26,0,-1)+1,1)),LEN($CC26))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS26,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0220","20301-3000","Removal of trash receptacle   ","Each","All|||","All|||","All|7||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|7||",null,null,1,44,2,"A0220","Removal of trash receptacle",8,11,17,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,27,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS27,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0230","20302-0300","Removal of curb and gutter, concrete   ","m","All|||","All|||","All|756||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|44||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|800||",null,null,1,46,2,"A0230","Removal of curb and gutter, concrete",8,11,16,20,28,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,28,36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS28,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0240","20302-0400","Removal of curb, asphalt   ","m","All|||","All|104||","All|727||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|34||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|865||",null,null,1,48,2,"A0240","Removal of curb, asphalt",8,11,17,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS29,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0250","20302-0500","Removal of curb, concrete   ","m","All|||","All|||","All|161||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|9||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|170||",null,null,1,50,2,"A0250","Removal of curb, concrete",8,11,17,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS30,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0260","20302-0625","Removal of curb, log   ","m","All|||","All|||","All|38||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||",null,null,1,52,2,"A0260","Removal of curb, log",8,11,17,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS31,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0270","20302-0700","Removal of fence   , pedestrian railing","m","All|||","All|||","All|160||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|170||",null,null,1,54,2,"A0270","Removal of fence, pedestrian railing",8,11,18,29,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,29,36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS32,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0280","20302-0700","Removal of fence   , log barrier","m","All|||","All|||","All|4||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|4||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|9||",null,null,1,56,2,"A0280","Removal of fence, log barrier",8,11,18,22,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS33,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0290","20302-2100","Removal of pipe culvert   ","m","All|||","All|||","All|||","All|19||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20||",null,null,1,58,2,"A0290","Removal of pipe culvert",8,11,16,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS34,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0300","20302-2500","Removal of handrail   ","m","All|||","All|||","All|58||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|60||",null,null,1,60,2,"A0300","Removal of handrail",8,11,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS35,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0310","20303-0300","Removal of concrete   , pads and stairs","m2","All|||","All|||","All|18||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20||",null,null,1,62,2,"A0310","Removal of concrete, pads and stairs",8,11,21,26,30,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,{"$f":"HLOOKUP(IF(COLUMN(BT36)-COLUMN($BT$4)=0,0,OFFSET(BT36,0,-1))+width_Pay.item,$AN36:$BS36,1)","v":30},36,36,36,36,36,36,36,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"HLOOKUP(IF(COLUMN(DJ36)-COLUMN($DJ$4)=0,0,OFFSET(DJ36,0,-1))+width_Remarks,$CD36:$DI36,1)","v":0},0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS36,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0320","20303-1200","Removal of paved waterway, asphalt   ","m2","All|||","All|||","All|||","All|||","All|13||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|15||",null,null,1,64,2,"A0320","Removal of paved waterway, asphalt",8,11,17,27,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS37,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0330","20303-3000","Removal of sidewalk, asphalt   ","m2","All|||","All|||","All|3,628||","All|||","All|138||","All|||","All|||","All|||","All|||","All|||","All|104||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|3,870||",null,null,1,66,2,"A0330","Removal of sidewalk, asphalt",8,11,21,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS38,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0340","20303-3600","Removal of wall   , timber crib","m2","All|||","All|||","All|50||","All|||","All|170||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|230||",null,null,1,68,2,"A0340","Removal of wall, timber crib",8,11,17,24,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS39,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0350","20401-0000","Roadway excavation  ","m3","All|||","All|63||","All|1,561||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|76||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1,700||",null,null,1,70,2,"A0350","Roadway excavation",8,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS40,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0360","20402-0000","Subexcavation   ","m3","All|8,719||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|431||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|9,150||",null,null,1,72,2,"A0360","Subexcavation",13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS41,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0370","20402-0000","Subexcavation   , drywell","m3","All|||","All|||","All|||","All|8,595||","All|||","All|||","All|||","All|||","All|||","All|||","All|205||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|8,800||",null,null,1,74,2,"A0370","Subexcavation, drywell",15,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS42,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0380","20411-0000","Select borrow   ","t","All|17,100||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|850||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|17,950||",null,null,1,76,2,"A0380","Select borrow",7,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS43,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0390","20411-0000","Select borrow   , permeable","t","All|||","All|||","All|||","All|6,600||","All|||","All|||","All|||","All|||","All|||","All|||","All|200||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|6,800||",null,null,1,78,2,"A0390","Select borrow, permeable",7,15,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS44,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0400","20701-1100","Earthwork geotextile, type III-B   ","m2","All|13,460||","All|||","All|||","All|||","All|140||","All|||","All|||","All|||","All|||","All|||","All|600||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|14,200||",null,null,1,80,2,"A0400","Earthwork geotextile, type III-B",10,22,27,32,32,32,32,32,32,{"$f":"IFERROR(FIND(\" \",$AM45,IFERROR(OFFSET(AW45,0,-1)+1,1)),LEN($AM45))","v":32},32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,1,"",0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC45,IFERROR(OFFSET(CM45,0,-1)+1,1)),LEN($CC45))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS45,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0410","20701-1200","Earthwork geotextile, type IV-A   ","m2","All|||","All|||","All|||","All|2,447||","All|||","All|||","All|||","All|||","All|||","All|||","All|103||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2,550||",null,null,1,82,2,"A0410","Earthwork geotextile, type IV-A",10,22,27,31,31,31,31,31,31,31,31,31,31,31,31,{"$f":"IFERROR(FIND(\" \",$AM46,IFERROR(OFFSET(BC46,0,-1)+1,1)),LEN($AM46))","v":31},31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC46,IFERROR(OFFSET(CS46,0,-1)+1,1)),LEN($CC46))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS46,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0420","20701-1300","Earthwork geotextile, type IV-B   ","m2","All|||","All|||","All|||","All|2,350||","All|||","All|||","All|||","All|||","All|||","All|||","All|100||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2,450||",null,null,1,84,2,"A0420","Earthwork geotextile, type IV-B",10,22,27,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,{"$f":"IFERROR(FIND(\" \",$AM47,IFERROR(OFFSET(BQ47,0,-1)+1,1)),LEN($AM47))","v":31},31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC47,IFERROR(OFFSET(DG47,0,-1)+1,1)),LEN($CC47))","v":0},0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS47,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0430","21301-1000","Subgrade stabilization with lime, 150mm depth   ","m2","All|7,096||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|354||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|7,450||",null,null,1,86,2,"A0430","Subgrade stabilization with lime, 150mm depth",9,23,28,34,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,34,45,45,45,45,45,45,45,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS48,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0440","21302-0000","Lime   ","t","All|||","All|||","All|||","All|64||","All|||","All|||","All|||","All|||","All|||","All|||","All|6||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|70||",null,null,1,88,2,"A0440","Lime",4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS49,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0450","25101-1000","Placed riprap, class 1   , slope protection","m3","All|||","All|||","All|20||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|25||",null,null,1,90,2,"A0450","Placed riprap, class 1, slope protection",7,15,21,24,30,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,40,30,40,40,40,40,40,40,40,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS50,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0460","25101-2000","Placed riprap, class 2   , energy dissipator","m3","All|||","All|||","All|||","All|18.0||","All|0.8||","All|||","All|||","All|||","All|||","All|||","All|2.2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|21.0||",null,null,1,92,2,"A0460","Placed riprap, class 2, energy dissipator",7,15,21,24,31,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,31,41,41,41,41,41,41,41,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS51,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0470","25101-3000","Placed riprap, class 3   , headwall","m3","All|||","All|||","All|||","All|21||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|22||",null,null,1,94,2,"A0470","Placed riprap, class 3, headwall",7,15,21,24,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,32,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS52,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0480","25101-3000","Placed riprap, class 3   , energy dissipator","m3","All|||","All|||","All|||","All|16||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|17||",null,null,1,96,2,"A0480","Placed riprap, class 3, energy dissipator",7,15,21,24,31,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,41,31,41,41,41,41,41,41,41,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS53,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0490","25120-1000","Riprap ditch, class 1   ","m","All|||","All|||","All|182||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|8||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|190||",null,null,1,98,2,"A0490","Riprap ditch, class 1",7,14,20,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,21,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS54,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0500","25125-0000","Boulder   , landscape, type 1","Each","All|||","All|||","All|25||","All|||","All|25||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|55||",null,null,1,100,2,"A0500","Boulder, landscape, type 1",9,20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS55,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0510","25125-0000","Boulder   , landscape, type 2","Each","All|||","All|||","All|40||","All|||","All|15||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|60||",null,null,1,102,2,"A0510","Boulder, landscape, type 2",9,20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS56,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0520","25125-0000","Boulder   , landscape, type 3","Each","All|||","All|||","All|42||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|3||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|45||",null,null,1,104,2,"A0520","Boulder, landscape, type 3",9,20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS57,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0530","25125-0000","Boulder   , barrier, type 1","Each","All|||","All|||","All|34||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|35||",null,null,1,106,2,"A0530","Boulder, barrier, type 1",9,18,23,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS58,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0540","25125-0000","Boulder   , barrier, type 2","Each","All|||","All|||","All|329||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|6||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|335||",null,null,1,108,2,"A0540","Boulder, barrier, type 2",9,18,23,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS59,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0550","25126-0000","Remove and reset boulder   ","Each","All|||","All|||","All|208||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|6||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|215||",null,null,1,110,2,"A0550","Remove and reset boulder",7,11,17,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS60,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0560","25210-0000","Rockery   , type 1","m2","All|||","All|||","All|||","All|||","All|212||","All|||","All|||","All|||","All|||","All|||","All|8||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|220||",null,null,1,112,2,"A0560","Rockery, type 1",9,14,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS61,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0570","25210-0000","Rockery   , type 2","m2","All|||","All|||","All|||","All|||","All|130||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|140||",null,null,1,114,2,"A0570","Rockery, type 2",9,14,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS62,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0580","25210-0000","Rockery   , type 3","m2","All|||","All|||","All|||","All|||","All|102||","All|||","All|||","All|||","All|||","All|||","All|8||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|110||",null,null,1,116,2,"A0580","Rockery, type 3",9,14,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS63,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0590","25410-0000","Treated timber crib retaining wall   ","m2","All|||","All|||","All|||","All|||","All|175||","All|||","All|||","All|||","All|||","All|||","All|10||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|185||",null,null,1,118,2,"A0590","Treated timber crib retaining wall",8,15,20,30,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS64,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0600","25410-0000","Treated timber crib retaining wall   , facing","m2","All|||","All|||","All|||","All|||","All|39||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||",null,null,1,120,2,"A0600","Treated timber crib retaining wall, facing",8,15,20,30,36,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,30,42,42,42,42,42,42,42,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS65,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0610","25501-1000","Mechanically stabilized earth wall, welded wire face    with dry-laid stone facing","m2","All|||","All|||","All|||","All|||","All|38||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||",null,null,1,123,2,"A0610","Mechanically stabilized earth wall, welded wire face with dry-laid stone facing",13,24,30,36,43,48,53,58,67,73,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,79,30,58,79,79,79,79,79,79,3,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS66,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0620","27201-1000","Reinforced soil slope, geogrid   ","m2","All|||","All|||","All|||","All|||","All|35||","All|||","All|||","All|||","All|||","All|||","All|5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||",null,null,1,125,2,"A0620","Reinforced soil slope, geogrid",11,16,23,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,{"$f":"HLOOKUP(IF(COLUMN(CA67)-COLUMN($BT$4)=0,0,OFFSET(CA67,0,-1))+width_Pay.item,$AN67:$BS67,1)","v":30},1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"HLOOKUP(IF(COLUMN(DQ67)-COLUMN($DJ$4)=0,0,OFFSET(DQ67,0,-1))+width_Remarks,$CD67:$DI67,1)","v":0},1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS67,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0630","30302-1000","Ditch reconditioning   ","m","All|||","All|2,684||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|126||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2,810||",null,null,1,127,2,"A0630","Ditch reconditioning",6,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS68,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0640","31001-0000","Recycled aggregate base   , type 1, 200 mm depth","m2","All|2,251||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|59||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2,310||",null,null,1,129,2,"A0640","Recycled aggregate base, type 1, 200 mm depth",9,19,25,30,33,37,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,{"$f":"IFERROR(FIND(\" \",$AM69,IFERROR(OFFSET(BN69,0,-1)+1,1)),LEN($AM69))","v":45},45,45,45,45,45,33,45,45,45,45,45,45,45,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC69,IFERROR(OFFSET(DD69,0,-1)+1,1)),LEN($CC69))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS69,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0650","31001-0000","Recycled aggregate base   , type 2, 125 mm depth","m2","All|36,242||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|908||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|37,150||",null,null,{"$f":"OFFSET(AI70,-1,0)+IF(AK70=OFFSET(AK70,1,0),0,1)","v":1},{"$f":"IF(OFFSET(AJ70,0,col_Unit-COLUMN(AJ70))=\"Unit\",0,OFFSET(AJ70,-1,0)+IF(AL70=AL$4,0,MAX(2,CB70,DR70)))","v":131},{"$f":"IF(OR(AL70=AL$4,OFFSET(AL70,-1,0)=AL$4,LEFT(AL70,1)<>LEFT(OFFSET(AL70,-1,0),1)),AJ70,OFFSET(AK70,-1,0))","v":2},"A0650","Recycled aggregate base, type 2, 125 mm depth",9,19,25,30,33,37,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,33,45,45,45,45,45,45,45,{"$f":"IF(LEN(DS70)>0,COUNTIF(BT70:CA70,\"<\"&MAX(BT70:CA70))+1,0)","v":2},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(LEN(DS70)>0,COUNTIF(DJ70:DQ70,\"<\"&MAX(DJ70:DQ70))+1,0)","v":1},{"$f":"IFERROR(VLOOKUP(OFFSET(DS70,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0660","31001-0000","Recycled aggregate base   , type 3, 150 mm depth","m2","All|17,223||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|277||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|17,500||",null,null,1,133,2,"A0660","Recycled aggregate base, type 3, 150 mm depth",9,19,25,30,{"$f":"IFERROR(FIND(\" \",$AM71,IFERROR(OFFSET(AR71,0,-1)+1,1)),LEN($AM71))","v":33},37,40,45,45,45,45,45,45,45,{"$f":"IFERROR(FIND(\" \",$AM71,IFERROR(OFFSET(BB71,0,-1)+1,1)),LEN($AM71))","v":45},45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,33,45,45,45,45,45,45,45,2,"",0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC71,IFERROR(OFFSET(CH71,0,-1)+1,1)),LEN($CC71))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC71,IFERROR(OFFSET(CR71,0,-1)+1,1)),LEN($CC71))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS71,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0670","31101-0000","Stockpiled aggregate   , Government-furnished","t","All|1,669||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|81||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1,750||",null,null,1,135,2,"A0670","Stockpiled aggregate, Government-furnished",11,22,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,22,42,42,42,42,42,42,42,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS72,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0680","40301-0000","Hot asphalt concrete pavement   ","t","All|7,714.8||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|196.2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|7,911.0||",null,null,1,137,2,"A0680","Hot asphalt concrete pavement",4,12,21,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,29,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS73,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0690","40305-3000","Antistrip additive, type 3   ","t","All|77.15||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|3.75||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|80.90||",null,null,1,139,2,"A0690","Antistrip additive, type 3",10,20,25,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS74,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0700","41201-1000","Tack coat grade CSS-1, CSS-1h, SS-1, or SS-1h   ","t","All|10.21||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|0.49||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|10.70||",null,null,1,141,2,"A0700","Tack coat grade CSS-1, CSS-1h, SS-1, or SS-1h",5,10,16,23,31,37,40,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,31,45,45,45,45,45,45,45,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS75,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0710","50101-0900","Reinforced rigid pavement, 200mm depth, type C smoothness   ","m2","All|||","All|||","All|9||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|10||",null,null,1,143,2,"A0710","Reinforced rigid pavement, 200mm depth, type C smoothness",11,17,27,33,40,45,47,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,33,57,57,57,57,57,57,57,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS76,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0730","55505-0000","Structural steel soldier piles   , HP 310 x 125","m","All|||","All|||","All|||","All|||","All|91.2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|91.2||",null,null,1,145,2,"A0730","Structural steel soldier piles, HP 310 x 125",11,17,25,32,35,39,41,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,32,44,44,44,44,44,44,44,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS77,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0740","55701-2000","Structural timber and lumber, treated   ","m3","All|||","All|||","All|||","All|||","All|3.7||","All|||","All|||","All|||","All|||","All|||","All|0.3||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|4.0||",null,null,1,147,2,"A0740","Structural timber and lumber, treated",11,18,22,30,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,37,30,37,37,37,37,37,37,37,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS78,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0750","56302-1000","Painting, concrete structure   ","m2","All|||","All|||","All|||","All|875||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|915||",null,null,1,149,2,"A0750","Painting, concrete structure",10,19,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS79,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0760","56501-0000","Drilled shafts   , 610 mm diameter","m","All|||","All|||","All|||","All|||","All|81||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|81||",null,null,1,151,2,"A0760","Drilled shafts, 610 mm diameter",8,16,20,23,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS80,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0770","60101-0000","Concrete   ","m3","All|||","All|||","All|||","All|||","All|19.6||","All|||","All|||","All|||","All|||","All|||","All|1.0||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20.6||",null,null,1,153,2,"A0770","Concrete",8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS81,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0780","60101-0000","Concrete   , anchor system","m3","All|||","All|||","All|1.5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|0.1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|1.6||",null,null,1,155,2,"A0780","Concrete, anchor system",10,17,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,23,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS82,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0790","60102-0000","Concrete   , pad","m2","All|||","All|||","All|43||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|45||",null,null,1,157,2,"A0790","Concrete, pad",10,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS83,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0800","60704-0000","Cleaning culvert in place   ","Each","All|||","All|||","All|||","All|19||","All|||","All|||","All|||","All|||","All|||","All|||","All|1||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20||",null,null,1,159,2,"A0800","Cleaning culvert in place",9,17,20,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS84,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0810","60706-0000","Cleaning drainage structure   , inlet","Each","All|||","All|||","All|||","All|5||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|5||",null,null,1,161,2,"A0810","Cleaning drainage structure, inlet",9,18,29,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS85,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0820","60707-0300","Lining 450mm pipe culvert   ","m","All|||","All|||","All|||","All|31||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|33||",null,null,1,163,2,"A0820","Lining 450mm pipe culvert",7,13,18,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS86,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0830","60709-0000","Cleaning drainage structures in place   , concrete gutter","m","All|||","All|||","All|||","All|223||","All|||","All|||","All|||","All|||","All|||","All|||","All|12||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|235||",null,null,1,165,2,"A0830","Cleaning drainage structures in place, concrete gutter",9,18,29,32,39,48,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,54,32,54,54,54,54,54,54,54,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS87,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Metric"}]
[null,"A0840","62201-0600","Backhoe loader, 240 liter minimum rated capacity bucket, 750mm width   ","Hour","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|100||",null,null,1,167,2,"A0840","Backhoe loader, 240 liter minimum rated capacity bucket, 750mm width",8,16,20,26,34,40,49,57,63,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,34,68,68,68,68,68,68,68,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS88,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0850","62201-2600","Crane, truck mounted or self-propelled, 90 metric tons minimum capacity, 55m min. boom, with dragline bucket, wrecking ball, 6m dozer track   ","Hour","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||",null,null,1,172,2,"A0850","Crane, truck mounted or self-propelled, 90 metric tons minimum capacity, 55m min. boom, with dragline bucket, wrecking ball, 6m dozer track",7,13,21,24,40,43,50,55,63,73,77,82,88,93,102,110,119,125,128,134,139,139,139,139,139,139,139,139,139,139,139,139,24,55,88,119,139,139,139,139,5,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS89,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0860","62201-3400","Hydraulic excavator, 1.1 cubic meter minimum capacity with thumb attachment     ","Hour","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|40||",null,null,1,175,2,"A0860","Hydraulic excavator, 1.1 cubic meter minimum capacity with thumb attachment",10,21,25,31,37,45,54,59,65,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"IFERROR(FIND(\" \",$AM90,IFERROR(OFFSET(BQ90,0,-1)+1,1)),LEN($AM90))","v":75},75,75,31,65,75,75,75,75,75,75,3,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(FIND(\" \",$CC90,IFERROR(OFFSET(DG90,0,-1)+1,1)),LEN($CC90))","v":0},0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS90,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0870","63502-0700","Temporary traffic control, cone   ","Each","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|20||",null,null,1,177,2,"A0870","Temporary traffic control, cone",10,18,27,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,1,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS91,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]
[null,"A0880","64601-1000","Building, restroom facility   , tank installation, government-furnished","Each","All|||","All|||","All|2||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|||","All|2||",null,null,2,179,2,"A0880","Building, restroom facility, tank installation, government-furnished",10,19,29,34,48,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,68,34,68,68,68,68,68,68,68,2,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$f":"IFERROR(VLOOKUP(OFFSET(DS92,0,col_Unit-COLUMN(DS$3)),Units[],2,0),\"\")","v":"Dual"}]

{"sheet":"Variables","index":3,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[41,9,45,10]]}
["Variables"]
[null,"Base sheet name:","Sheet",null,null,"Prefix:",{"$f":"LEFT(Sheet,MIN(FIND({0,1,2,3,4,5,6,7,8,9},Sheet&\"0123456789\"))-1)","v":"B."}]
[null,"Min. rows/sheet",5,null,null,"Sheets needed:",{"$f":"MATCH(MAX(SheetNames[Begins]),SheetNames[Begins],0)-1","v":5}]
[null,"Max. row/sheet",37,null,null,"Current sheets:",{"$f":"COUNTIF(SheetNames[Sheet num],\">0\")","v":1}]
[null,"Metric?",{"$f":"ISNUMBER(MATCH(\"Metric\",Units.check,0))","v":true},null,null,"Description truncated?",{"$f":"MAX(OFFSET(Calcs,0,col_D-1+lines_D,ROWS(Calcs),1))=lines_D","v":false}]
[null,null,null,null,null,"Remarks truncated?",{"$f":"MAX(OFFSET(Calcs,0,col_R-1+lines_R,ROWS(Calcs),1))=lines_R","v":false}]
["SheetNames",null,null,null,null,null,null,null,null,"Units"]
["Sheet num","Worksheet","Sheet","Begins","Draft","Lines","Adjust","Sect",null,"Symbol","Unit"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":1},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"B.1"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":0},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":0},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":36},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"ACRE","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-2},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (2)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":36},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":36},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":36},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"CTSM","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-3},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (3)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":72},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":72},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":36},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"CUFT","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-4},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (4)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":108},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":108},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":37},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"CUYD","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-5},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (5)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":145},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":145},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":34},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":1},null,"DAY","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-6},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (6)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"EACH","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-7},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (7)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"FXHR","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-8},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (8)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"GAL","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-9},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (9)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"ha","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-10},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (10)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"HOUR","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-11},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (11)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"kg","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-12},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (12)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"km","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-13},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (13)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"l","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-14},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (14)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"LB","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-15},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (15)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"LNFT","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-16},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (16)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"LPSM","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-17},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (17)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"m","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-18},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (18)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"m2","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-19},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (19)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"m3","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-20},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (20)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MFBM","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-21},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (21)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MGAL","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-22},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (22)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MILE","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-23},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (23)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"MO","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-24},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (24)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"SLRY","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-25},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (25)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"SQFT","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-26},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (26)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"SQYD","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-27},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (27)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"STA","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-28},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (28)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"t","Metric"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-29},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (29)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"TON","US Customary"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-30},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (30)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"WEEK","Dual"]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-31},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (31)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-32},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (32)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-33},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (33)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-34},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (34)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2},null,"Note:  To resolve sheets with less than desired minimum rows, assume that slightly less than half of the other sheets could give up a row."]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-35},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (35)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-36},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (36)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-37},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (37)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-38},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (38)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-39},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (39)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-40},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (40)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-41},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (41)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-42},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (42)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-43},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (43)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-44},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (44)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-45},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (45)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-46},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (46)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-47},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (47)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-48},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (48)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-49},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (49)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]
[{"$f":"IFERROR(IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),1,-1)*(ABS(OFFSET(SheetNames[[#This Row],[Sheet num]],-1,0))+1),VALUE(SUBSTITUTE(Sheet,Prefix,\"\")))","v":-50},{"$f":"Base&IF(ROW()=ROW(SheetNames[]),\"\",\" (\"&ROW()-ROW(SheetNames[#Headers])&\")\")","v":"Sheet (50)"},{"$f":"IF(ISREF(INDIRECT(\"'\"&SheetNames[[#This Row],[Worksheet]]&\"'!A1\")),Prefix&SheetNames[[#This Row],[Sheet num]],\"Undefined\")","v":"Undefined"},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Begins]],-1,0)+maxRows-SheetNames[[#This Row],[Adjust]],Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"IF(SheetNames[[#This Row],[Sect]]=OFFSET(SheetNames[[#This Row],[Sect]],-1,0),IF(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)=TotalLines,TotalLines,VLOOKUP(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,Calcs,1)),INDEX(Calcs,MATCH(SheetNames[[#This Row],[Sect]],OFFSET(Calcs,0,-1,ROWS(Calcs),1),0),1))","v":179},{"$f":"MAX(OFFSET(SheetNames[[#This Row],[Draft]],1,0)-SheetNames[[#This Row],[Draft]],0)","v":0},{"$f":"CEILING(IF(SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]])>0,minRows-SUMIFS(SheetNames[Lines],SheetNames[Lines],\"<\"&minRows,SheetNames[Sect],SheetNames[[#This Row],[Sect]]),0)/(0.49*COUNTIFS(SheetNames[Sect],SheetNames[[#This Row],[Sect]])),1)","v":0},{"$f":"MIN(OFFSET(Calcs,MATCH(IFERROR(OFFSET(SheetNames[[#This Row],[Draft]],-1,0)+maxRows,0),OFFSET(Calcs,0,0,ROWS(Calcs),1),1)-1,-1,1,1),IFERROR(OFFSET(SheetNames[[#This Row],[Sect]],-1,0)+1,1))","v":2}]