{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["bar schedule","bar weights","shape codes","template","from author"],"not_rendered":{"images":4,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"bar schedule","index":0,"n_rows":57,"n_cols":173,"rows_kept":57,"merged":[[0,1,0,11],[0,12,0,22],[1,4,4,12],[1,13,3,16],[1,17,1,18],[1,19,1,22],[2,17,2,18],[2,19,2,22],[3,17,3,18],[3,19,3,22],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,19,4,22],[5,2,5,3],[5,4,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,22],[6,2,6,3],[6,4,6,12],[6,13,6,14],[6,15,6,16],[6,17,6,18],[6,19,6,22],[7,123,10,123],[7,124,10,124],[7,125,10,125],[7,126,10,126],[7,127,10,127],[7,128,10,128],[7,129,10,129],[8,2,11,4],[8,5,11,5],[8,6,11,7],[8,8,11,8],[8,9,11,9],[8,10,11,10],[8,11,11,11],[8,12,11,12],[8,13,11,13],[8,14,11,14],[8,15,11,15],[8,16,11,16],[8,17,11,17],[8,18,11,18],[8,19,11,19],[8,20,11,20],[8,21,11,21],[8,24,8,30],[8,117,11,117],[9,24,11,24],[9,25,11,25],[9,26,11,26],[9,27,11,27],[9,28,11,28],[9,29,11,29],[9,30,11,30],[9,31,11,31],[10,60,10,61],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,3,39,9],[39,11,39,14],[39,20,39,21],[40,3,40,8],[40,11,41,17],[41,3,41,8],[42,15,42,21]]}
[null,"Version: 3.1. - FREE LITE VERSION",{"$nulls":10},"© 2010-2021 Damian Janicki"]
[{"$nulls":4},"YourSpreadsheets™\nYour Office Address Goes Here\nwww.YourSpreadsheets.co.uk\nTel: 010 1234 567890 (example only)",{"$nulls":8},"86 MARGERY STREET, LONDON",{"$nulls":3},"Status:",null,"C"]
[{"$nulls":17},"Drawing No:",null,"A1/503"]
[{"$nulls":17},"Sheet No:",null,1]
[{"$nulls":13},"Job No:",null,22190,null,"Revision:",null,"A"]
[null,null,"Section: ",null,"Grid A/1 to grid D/6",{"$nulls":8},"Prepared By:",null,"DJ",null,"Date:",null,{"$f":"TODAY()","v":"2021-05-31"}]
[null,null,"Location: ",null,"Foundations",{"$nulls":8},"Checked By:",null,"DJ",null,"Last Revised:",null,"2013-11-26",{"$nulls":23},"extra dimension is 1: horizontal 2: vertical",{"$nulls":6},{"$f":"'bar weights'!$AM$2","v":1},{"$nulls":72},"NOTE: 1 means cell input required. And 2 means that user should specify something but this is not automatically calculated/checked - and so different hatching applies in the input lengths table"]
[{"$nulls":43},"calculate extra dims",{"$nulls":5},{"$f":"'bar weights'!AL2","v":true},{"$f":"IF(AX8=TRUE,1,0)","v":1},{"$nulls":9},"the below table is for checking only",{"$nulls":62},"Colour cell A","Colour cell B","Colour cell C","Colour cell D","Colour cell E","Colour cell F","Colour cell R"]
[null,null,"Member",null,null,"Bar \nmark","Type and \nsize",null,"No. of \nMbrs","No. of \nbars in \neach","Total\nNo.","Length \nof each bar †\n[mm]","Shape\ncode","A *\n[mm]","B *\n[mm]","C *\n[mm]","D *\n[mm]","E *\n[mm]","F *\n[mm]","R *\n[mm]","Weight\n[kg]","Rev.",null,null,"FILL IN LENGTHS BELOW",{"$nulls":18},"auto jump",{"$nulls":5},{"$f":"'bar weights'!AK2","v":true},{"$f":"IF(AX9=TRUE,1,0)","v":1},{"$nulls":9},"shape code:",null,"dia:",{"$nulls":54},"Shape Code"]
[{"$nulls":24},"A *\n[mm]","B *\n[mm]","C *\n[mm]","D *\n[mm]","E *\n[mm]","F *\n[mm]","R *\n[mm]","Overwrite\nlength\n[mm]",{"$nulls":11},"popup window",{"$nulls":5},{"$f":"'bar weights'!AJ2","v":true},{"$f":"IF(AX10=TRUE,1,0)","v":1},{"$nulls":9},"AA=",null,"BB=",null,"CC=",null,"DD=",null,"EE=",null,"FF=",null,"RR="]
[{"$nulls":48},"for calculating extra dimensions in shape code 14, 15, 24, 26, 27, 28, 29, 34, 35, 36, 46","below is a guide which bends are required for which shapde code:\nREQUIRED DIMENSION IS HORIZONTAL:\nIF(OR(M13=14,M13=15) A,B -> D\nIF(OR(M13=24,M13=26,M13=29) B,D -> E\nIF(OR(M13=27,M13=28) A,D -> E\nIF(OR(M13=34,M13=35,M13=46) B,D -> F\nIF(OR(M13=36) A,E -> F\nREQUIRED DIMENSION IS DIAGONAL:\nIF(OR(M13=14,M13=15) B,D -> A\nIF(OR(M13=24,M13=26,M13=29) D,E -> B\nIF(OR(M13=27,M13=28) D,E -> A\nIF(OR(M13=34,M13=35,M13=46) D,F -> B\nIF(OR(M13=36) E,F -> A","equations taken from a separate spreadsheet. And below is a guide which case applies to which bar:\ncase 1: 14, \ncase 2: 29\ncase 3: 26, 34, 35, 46\ncase 4: 15, 27, 28, 36\ncase 5: 24 -> d2+e2=b2",{"$nulls":9},"first calculates dimensions in the second cell [typically used to pick correct P1, P2, x,q, etc], and then in the first cell [typically used for any specific length requirements given in the code e.g. B/2+max(5d,90mm)]",{"$nulls":13},"shape code:",{"$nulls":56},"for calculating tonnage per this sheet",{"$nulls":4},"this area is used for merging/unmerging rows",{"$nulls":16},"this area is for clearing entries, and undoing it",{"$nulls":18},"this area is used for refreshing conditional formatting - was simpler to just include these cells than rewritting the whole vba I had for refreshing conditional formatting in the previous version of the spreadsheet"]
[{"$nulls":34},"L","A","B","C","D","E","F","R",null,"does shape code exist in the Standrad?","column of FIRST bend required to calculate extra dimension","column of SECOND bend required to calculate extra dimension","column of extra dimension",null,"A","B","D (extra dimension, not in BS8666:2005)","angle","A (for checking)",null,"d","x","P1","r","P2 (for links with bents <150deg)","q","A","A","B","B","C","C","D","D","E","E","F","F","R","R",0,1,11,12,13,14,15,21,22,23,24,25,26,27,28,29,31,32,33,34,35,36,41,44,46,47,48,51,52,56,63,64,67,75,77,98,null,"d","r","x","P1","P2","q",null,"Total Length of bar:",{"$nulls":3},"column reference:",7,8,9,10,11,12,13,null,"total length","all bar diameters that can be used","bar lengths per sheet",null,null,137,{"$nulls":13},151,"<- column number",null,154,{"$nulls":18},173]
[null,null,"Pile Cap 01",null,null,{"v":1,"d":"01"},"H",12,10,50,500,{"$f":"AI13","v":5975},21,{"$f":"AJ13","v":2500},{"$f":"AK13","v":1000},{"$f":"AL13","v":"(2500)"},{"$f":"AM13","v":""},{"$f":"AN13","v":""},{"$f":"AO13","v":""},{"$f":"AP13","v":""},{"$f":"IF($L13=\"?\",\"?\",IF(AND(H13<>\"\",K13<>\"\",AF13<>\"\",EG13=1),K13*AF13*(H13/2)^2*PI()*0.00000785,IF(AND(H13<>\"\",K13<>\"\",L13<>\"\"),K13*L13*(H13/2)^2*PI()*0.00000785,\"\")))","v":{"v":2652.34457566462,"d":"2652.3"}},{"$nulls":3},2500,1000,2500,{"$nulls":5},{"$f":"IF(AU13>0,\"*\",\"\")","v":""},"<- formulaes in column BC",{"$f":"IF(OR(H13=\"\",M13=\"\"),\"\",IF(AF13>0,AF13,IF($M13=99,\"?\",INDEX(BW13:DF13,,MATCH(M13,$BW$12:$DF$12,0)))))","v":5975},{"$f":"IF(ISERROR(BI13),L13,IF(OR(H13=\"\",M13=\"\",AR13=0),\"\",IF(M13=99,IF(Y13=\"\",\"\",CEILING(Y13,5)),BI13)))","v":2500},{"$f":"IF(OR(H13=\"\",M13=\"\",M13=0,M13=1,AR13=0),\"\",IF(M13=99,IF(Z13=\"\",\"\",CEILING(Z13,5)),IF(OR(M13=11,M13=12),\"(\"&BK13&\")\",BK13)))","v":1000},{"$f":"IF(OR(H13=\"\",M13=\"\",M13=0,M13=1,M13=11,M13=12,M13=75,AR13=0),\"\",IF(M13=99,IF(AA13=\"\",\"\",CEILING(AA13,5)),IF(OR(M13=13,M13=14,M13=15,M13=21,M13=23,M13=24,M13=26,M13=27,M13=28,M13=29,M13=33,M13=47,M13=48,M13=51,M13=52,M13=63),\"(\"&BM13&\")\",BM13)))","v":"(2500)"},{"$f":"IF(OR(H13=\"\",AR13=0,M13=\"\",M13=0,M13=1,M13=11,M13=12,M13=13,M13=21,M13=23,M13=33,M13=67,M13=75,M13=77,AND(AB13=\"\",$AU13=4)),\"\",IF(M13=99,IF(AB13=\"\",\"\",CEILING(AB13,5)),IF(OR(M13=22,M13=31,M13=32,M13=36,M13=47,M13=48,M13=51,M13=52,M13=56,M13=63,M13=98),\"(\"&BO13&\")\",BO13)))","v":""},{"$f":"IF(OR(H13=\"\",AR13=0,AND(AC13=\"\",$AU13=5)),\"\",IF(M13=99,IF(AC13=\"\",\"\",CEILING(AC13,5)),IF(OR(M13=24,M13=26,M13=27,M13=28,M13=29,M13=36,M13=64),BQ13,IF(OR(M13=25,M13=34,M13=35,M13=41,M13=44,M13=46,M13=56),\"(\"&BQ13&\")\",\"\"))))","v":""},{"$f":"IF(OR(H13=\"\",AR13=0,AND(AD13=\"\",$AU13=6)),\"\",IF(M13=99,IF(AD13=\"\",\"\",CEILING(AD13,5)),IF(OR(M13=34,M13=35,M13=36,M13=46),BS13,IF(OR(M13=56,M13=64),\"(\"&BS13&\")\",\"\"))))","v":""},{"$f":"IF(OR(H13=\"\",AR13=0),\"\",IF(M13=99,IF(AE13=\"\",\"\",CEILING(AE13,5)),IF(OR(M13=12,M13=67),BU13,\"\")))","v":""},null,{"$f":"IF(OR(M13=\"\",M13=0,M13=1,M13=11,M13=12,M13=13,M13=14,M13=15,M13=21,M13=22,M13=23,M13=24,M13=25,M13=26,M13=27,M13=28,M13=29,M13=31,M13=32,M13=33,M13=34,M13=35,M13=36,M13=41,M13=44,M13=46,M13=47,M13=48,M13=51,M13=52,M13=56,M13=63,M13=64,M13=67,M13=75,M13=77,M13=98,M13=99),1,0)","v":1},{"$f":"IF($AY$7=1,IF(OR($M13=14,$M13=15),1,IF(OR($M13=24,$M13=26,$M13=29),2,IF(OR($M13=27,$M13=28),1,IF(OR($M13=34,$M13=35,$M13=46),2,IF($M13=36,1,\"-\"))))),\nIF(OR($M13=14,$M13=15),2,IF(OR($M13=24,$M13=26,$M13=29),4,IF(OR($M13=27,$M13=28),4,IF(OR($M13=34,$M13=35,$M13=46),4,IF($M13=36,5,\"-\"))))))","v":"-"},{"$f":"IF($AY$7=1,IF(OR($M13=14,$M13=15),2,IF(OR($M13=24,$M13=26,$M13=29),4,IF(OR($M13=27,$M13=28),4,IF(OR($M13=34,$M13=35,$M13=46),4,IF($M13=36,5,\"-\"))))),\nIF(OR($M13=14,$M13=15),4,IF(OR($M13=24,$M13=26,$M13=29),5,IF(OR($M13=27,$M13=28),5,IF(OR($M13=34,$M13=35,$M13=46),6,IF($M13=36,6,\"-\"))))))","v":"-"},{"$f":"IF($AY$7=1,IF(OR(M13=14,M13=15),4,IF(OR(M13=24,M13=26,M13=27,M13=28,M13=29),5,IF(OR(M13=34,M13=35,M13=36,M13=46),6,0))),\nIF(OR(M13=14,M13=15,M13=27,M13=28,M13=36),1,IF(OR(M13=24,M13=26,M13=29,M13=34,M13=35,M13=46),2,0)))","v":0},{"$nulls":10},24,null,85,{"$f":"IF(OR(M13=47,M13=48,M13=51,M13=56,M13=63,M13=64,M13=98),CEILING(BJ13,5),CEILING(MAX(Y13,IF(M13=1,IF(Y13<6000,6000,IF(Y13>12000,Y13,12000)),IF(M13=12,MAX(BU13+12+MAX(5*12,90),125),IF(M13=13,MAX(125,BK13/2+MAX(5*12,90)),IF(M13=33,BK13/2+BM13,IF(M13=52,120,125)))))),5))","v":2500},{"$f":"IF(OR(M13=47,M13=48),MAX(Y13,AA13,125,120),IF(OR(M13=51,M13=63),MAX(Y13,AA13,155,120),IF(M13=56,MAX(Y13,AC13,155,120),IF(M13=64,MAX(Y13,155),IF(M13=98,MAX(Y13,120),0)))))","v":0},{"$f":"IF(OR(M13=\"\",M13=0,M13=1),\"\",IF(OR(M13=15,M13=51,M13=52,M13=56),CEILING(BL13,5),IF(M13=77,BL13,CEILING(IF(OR(M13=11,M13=25,M13=75),MAX(Z13,125),IF(M13=12,MAX(Z13,BU13+12+MAX(5*12,90),125),IF(OR(M13=13,M13=33),MIN(MAX(BH13,Z13),400+2*12),IF(M13=14,MAX(Z13,BH13),MAX(Z13,120))))),5))))","v":1000},{"$f":"IF(M13=77,MAX(Z13,12),CEILING(IF(M13=15,MAX(Z13,5),IF(M13=51,MAX(Z13,AA13,155,120),IF(M13=52,MAX(Z13,AA13,125,120),IF(M13=56,MAX(Z13,AC13,155,120),0)))),5))","v":0},{"$f":"IF(M13=77,MAX(AA13,1),IF(OR(M13=\"\",M13=0,M13=1,M13=11,M13=12,M13=75),\"\",IF(OR(M13=48,M13=51,M13=52,M13=56,M13=63,M13=67,M13=98),CEILING(BN13,5),CEILING(IF(OR(M13=13,M13=33),MAX(AA13,BK13/2+MAX(5*12,90)),IF(M13=22,MIN(MAX(BH13,AA13),400+2*12),IF(M13=25,MAX(AA13,5),IF(OR(M13=14,M13=15,M13=21,M13=23,M13=24,M13=26,M13=27,M13=28,M13=29,M13=47),MAX(AA13,125),MAX(AA13,120))))),5))))","v":2500},{"$f":"IF(OR(M13=51,M13=63),MAX(AA13,155),IF(OR(M13=48,M13=52,M13=98),MAX(AA13,125),IF(M13=56,MAX(AA13,120),IF(M13=67,MAX(AA13,5),0))))","v":0},{"$f":"IF(OR(M13=\"\",M13=0,M13=1,M13=11,M13=12,M13=13,M13=21,M13=23,M13=33,M13=67,M13=75,M13=77),\"\",IF(OR(M13=29,M13=31,M13=32,M13=36,M13=47,M13=48,M13=51,M13=52,M13=63,M13=98),CEILING(BP13,5),CEILING(IF(M13=22,MAX(AB13,BM13/2+MAX(5*12,90),125),IF(OR(M13=14,M13=15,M13=24,M13=25,M13=26,M13=27,M13=28,M13=34,M13=35,M13=46),MAX(AB13,5),MAX(AB13,120))),5)))","v":""},{"$f":"CEILING(IF(OR(M13=31,M13=32,M13=36,M13=98),MAX(AB13,125),IF(M13=29,MAX(AB13,BH13),IF(OR(M13=47,M13=48,M13=51,M13=52,M13=63),BM13,0))),5)","v":0},{"$f":"IF(OR(M13=24,M13=26,M13=27,M13=28,M13=29,M13=36),CEILING(MAX(AC13,5),5),IF(OR(M13=25,M13=64),CEILING(MAX(AC13,120),5),IF(OR(M13=34,M13=35,M13=41,M13=44,M13=46),CEILING(MAX(AC13,125),5),IF(M13=56,CEILING(MAX(AC13,155),5),IF(M13=99,0,\"\")))))","v":""},0,{"$f":"IF(OR(M13=34,M13=35,M13=36,M13=46),CEILING(MAX(AD13,5),5),IF(M13=56,BQ13,IF(M13=64,CEILING(MAX(AD13,155),5),IF(M13=99,0,\"\"))))","v":""},0,{"$f":"IF(OR(M13=12,M13=67),CEILING(MAX(AE13,BF13),5),IF(M13=99,0,\"\"))","v":""},0,{"$f":"IF($M13=BW$12,CEILING(BI13,25),\"\")","v":""},{"$f":"IF($M13=BX$12,CEILING(BI13,25),\"\")","v":""},{"$f":"IF($M13=BY$12,CEILING(BI13+BK13-0.5*BF13-12,25),\"\")","v":""},{"$f":"IF($M13=BZ$12,CEILING(BI13+BK13-0.43*BU13-1.2*12,25),\"\")","v":""},{"$f":"IF($M13=CA$12,CEILING(BI13+0.57*BK13+BM13-1.6*12,25),\"\")","v":""},null,null,{"$f":"IF($M13=CD$12,CEILING(BI13+BK13+BM13-BF13-2*12,25),\"\")","v":5975},{"$f":"IF($M13=CE$12,CEILING(BI13+BK13+0.57*BM13+BO13-0.5*BF13-2.6*12,25),\"\")","v":""},{"$f":"IF($M13=CF$12,CEILING(BI13+BK13+BM13-BF13-2*12,25),\"\")","v":""},{"$nulls":47},{"$f":"IF(OR(K13=\"\",L13=\"\",L13=\"?\"),0,K13*L13/1000)","v":2987.5},6,{"$f":"SUMIF($H$13:$H$39,EC13,$EB$13:$EB$39)","v":0},null,null,0]
[{"$nulls":5},{"v":2,"d":"02"},"H",12,10,40,400,7825,21,3500,860,"(3500)","","","","",{"$f":"IF($L14=\"?\",\"?\",IF(AND(H14<>\"\",K14<>\"\",AF14<>\"\",EG14=1),K14*AF14*(H14/2)^2*PI()*0.00000785,IF(AND(H14<>\"\",K14<>\"\",L14<>\"\"),K14*L14*(H14/2)^2*PI()*0.00000785,\"\")))","v":{"v":2778.858082621008,"d":"2778.9"}},{"$nulls":3},3500,860,3500,{"$nulls":5},{"$f":"IF(AU14>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H14=\"\",M14=\"\"),\"\",IF(AF14>0,AF14,IF($M14=99,\"?\",INDEX(BW14:DF14,,MATCH(M14,$BW$12:$DF$12,0)))))","v":7825},{"$f":"IF(ISERROR(BI14),L14,IF(OR(H14=\"\",M14=\"\",AR14=0),\"\",IF(M14=99,IF(Y14=\"\",\"\",CEILING(Y14,5)),BI14)))","v":3500},{"$f":"IF(OR(H14=\"\",M14=\"\",M14=0,M14=1,AR14=0),\"\",IF(M14=99,IF(Z14=\"\",\"\",CEILING(Z14,5)),IF(OR(M14=11,M14=12),\"(\"&BK14&\")\",BK14)))","v":860},{"$f":"IF(OR(H14=\"\",M14=\"\",M14=0,M14=1,M14=11,M14=12,M14=75,AR14=0),\"\",IF(M14=99,IF(AA14=\"\",\"\",CEILING(AA14,5)),IF(OR(M14=13,M14=14,M14=15,M14=21,M14=23,M14=24,M14=26,M14=27,M14=28,M14=29,M14=33,M14=47,M14=48,M14=51,M14=52,M14=63),\"(\"&BM14&\")\",BM14)))","v":"(3500)"},{"$f":"IF(OR(H14=\"\",AR14=0,M14=\"\",M14=0,M14=1,M14=11,M14=12,M14=13,M14=21,M14=23,M14=33,M14=67,M14=75,M14=77,AND(AB14=\"\",$AU14=4)),\"\",IF(M14=99,IF(AB14=\"\",\"\",CEILING(AB14,5)),IF(OR(M14=22,M14=31,M14=32,M14=36,M14=47,M14=48,M14=51,M14=52,M14=56,M14=63,M14=98),\"(\"&BO14&\")\",BO14)))","v":""},{"$f":"IF(OR(H14=\"\",AR14=0,AND(AC14=\"\",$AU14=5)),\"\",IF(M14=99,IF(AC14=\"\",\"\",CEILING(AC14,5)),IF(OR(M14=24,M14=26,M14=27,M14=28,M14=29,M14=36,M14=64),BQ14,IF(OR(M14=25,M14=34,M14=35,M14=41,M14=44,M14=46,M14=56),\"(\"&BQ14&\")\",\"\"))))","v":""},{"$f":"IF(OR(H14=\"\",AR14=0,AND(AD14=\"\",$AU14=6)),\"\",IF(M14=99,IF(AD14=\"\",\"\",CEILING(AD14,5)),IF(OR(M14=34,M14=35,M14=36,M14=46),BS14,IF(OR(M14=56,M14=64),\"(\"&BS14&\")\",\"\"))))","v":""},{"$f":"IF(OR(H14=\"\",AR14=0),\"\",IF(M14=99,IF(AE14=\"\",\"\",CEILING(AE14,5)),IF(OR(M14=12,M14=67),BU14,\"\")))","v":""},null,{"$f":"IF(OR(M14=\"\",M14=0,M14=1,M14=11,M14=12,M14=13,M14=14,M14=15,M14=21,M14=22,M14=23,M14=24,M14=25,M14=26,M14=27,M14=28,M14=29,M14=31,M14=32,M14=33,M14=34,M14=35,M14=36,M14=41,M14=44,M14=46,M14=47,M14=48,M14=51,M14=52,M14=56,M14=63,M14=64,M14=67,M14=75,M14=77,M14=98,M14=99),1,0)","v":1},{"$f":"IF($AY$7=1,IF(OR($M14=14,$M14=15),1,IF(OR($M14=24,$M14=26,$M14=29),2,IF(OR($M14=27,$M14=28),1,IF(OR($M14=34,$M14=35,$M14=46),2,IF($M14=36,1,\"-\"))))),\nIF(OR($M14=14,$M14=15),2,IF(OR($M14=24,$M14=26,$M14=29),4,IF(OR($M14=27,$M14=28),4,IF(OR($M14=34,$M14=35,$M14=46),4,IF($M14=36,5,\"-\"))))))","v":"-"},{"$f":"IF($AY$7=1,IF(OR($M14=14,$M14=15),2,IF(OR($M14=24,$M14=26,$M14=29),4,IF(OR($M14=27,$M14=28),4,IF(OR($M14=34,$M14=35,$M14=46),4,IF($M14=36,5,\"-\"))))),\nIF(OR($M14=14,$M14=15),4,IF(OR($M14=24,$M14=26,$M14=29),5,IF(OR($M14=27,$M14=28),5,IF(OR($M14=34,$M14=35,$M14=46),6,IF($M14=36,6,\"-\"))))))","v":"-"},{"$f":"IF($AY$7=1,IF(OR(M14=14,M14=15),4,IF(OR(M14=24,M14=26,M14=27,M14=28,M14=29),5,IF(OR(M14=34,M14=35,M14=36,M14=46),6,0))),\nIF(OR(M14=14,M14=15,M14=27,M14=28,M14=36),1,IF(OR(M14=24,M14=26,M14=29,M14=34,M14=35,M14=46),2,0)))","v":0},{"$nulls":10},24,null,85,3500,0,860,0,3500,0,"",0,"",0,"",0,{"$f":"IF(OR(M14=12,M14=67),CEILING(MAX(AE14,BF14),5),IF(M14=99,0,\"\"))","v":""},0,{"$f":"IF($M14=BW$12,CEILING(BI14,25),\"\")","v":""},{"$f":"IF($M14=BX$12,CEILING(BI14,25),\"\")","v":""},"","","",null,null,7825,"","",{"$nulls":33},0,"A",{"$nulls":4},1,{"$nulls":7},{"$f":"IF(OR(K14=\"\",L14=\"\",L14=\"?\"),0,K14*L14/1000)","v":3130},7,0,null,null,0]
[{"$nulls":5},{"v":3,"d":"03"},"H",12,10,4,40,3500,11,2500,"(1000)","","","","","",{"v":124.29397174662657,"d":"124.3"},{"$nulls":3},2500,1000,{"$nulls":6},{"$f":"IF(AU15>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H15=\"\",M15=\"\"),\"\",IF(AF15>0,AF15,IF($M15=99,\"?\",INDEX(BW15:DF15,,MATCH(M15,$BW$12:$DF$12,0)))))","v":3500},2500,"(1000)","","","","","",null,1,"-","-",0,{"$nulls":10},24,null,85,2500,0,1000,0,"",0,"",0,"",0,"",0,"",0,{"$f":"IF($M15=BW$12,CEILING(BI15,25),\"\")","v":""},{"$f":"IF($M15=BX$12,CEILING(BI15,25),\"\")","v":""},3500,"","",null,null,"","","",{"$nulls":33},1,"A (Stock Lengths)",{"$nulls":4},1,{"$nulls":7},140,8,0,null,null,0]
[{"$nulls":5},{"v":4,"d":"04"},"H",12,10,6,60,3500,11,2500,"(1000)","","","","","",{"v":186.44095761993987,"d":"186.4"},{"$nulls":3},2500,1000,{"$nulls":6},{"$f":"IF(AU16>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H16=\"\",M16=\"\"),\"\",IF(AF16>0,AF16,IF($M16=99,\"?\",INDEX(BW16:DF16,,MATCH(M16,$BW$12:$DF$12,0)))))","v":3500},2500,"(1000)","","","","","",null,1,"-","-",0,{"$nulls":10},24,null,85,2500,0,1000,0,"",0,"",0,"",0,"",0,"",0,{"$f":"IF($M16=BW$12,CEILING(BI16,25),\"\")","v":""},{"$f":"IF($M16=BX$12,CEILING(BI16,25),\"\")","v":""},3500,"","",null,null,"","","",{"$nulls":33},11,"A + (B) - 0.5r - d",{"$nulls":4},1,1,{"$nulls":6},210,9,0,null,null,0]
[{"$nulls":5},{"v":5,"d":"05"},"H",12,10,4,40,6000,11,3500,"(2500)","","","","","",{"v":213.07538013707412,"d":"213.1"},{"$nulls":3},3500,2500,{"$nulls":6},{"$f":"IF(AU17>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H17=\"\",M17=\"\"),\"\",IF(AF17>0,AF17,IF($M17=99,\"?\",INDEX(BW17:DF17,,MATCH(M17,$BW$12:$DF$12,0)))))","v":6000},3500,"(2500)","","","","","",null,1,"-","-",0,{"$nulls":10},24,null,85,3500,0,2500,0,"",0,"",0,"",0,"",0,"",0,{"$f":"IF($M17=BW$12,CEILING(BI17,25),\"\")","v":""},{"$f":"IF($M17=BX$12,CEILING(BI17,25),\"\")","v":""},6000,"","",null,null,"","","",{"$nulls":33},12,"A + (B) - 0.43R - 1.2d",{"$nulls":4},1,1,{"$nulls":4},1,null,240,10,0,null,null,0]
[{"$nulls":5},{"v":6,"d":"06"},"H",12,10,6,60,4975,23,1000,1500,"(2500)","","","","",{"v":265.0125040454859,"d":"265.0"},{"$nulls":3},1000,1500,2500,{"$nulls":5},{"$f":"IF(AU18>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H18=\"\",M18=\"\"),\"\",IF(AF18>0,AF18,IF($M18=99,\"?\",INDEX(BW18:DF18,,MATCH(M18,$BW$12:$DF$12,0)))))","v":4975},1000,1500,"(2500)","","","","",null,1,"-","-",0,{"$nulls":10},24,null,85,1000,0,1500,0,2500,0,"",0,"",0,"",0,"",0,{"$f":"IF($M18=BW$12,CEILING(BI18,25),\"\")","v":""},{"$f":"IF($M18=BX$12,CEILING(BI18,25),\"\")","v":""},"","","",null,null,"","",4975,{"$nulls":33},13,"A + 0.57B + (C) - 1.6d",{"$nulls":4},1,1,1,{"$nulls":5},298.5,11,0,null,null,0]
[{"$nulls":11},{"$f":"AI19","v":""},null,{"$f":"AJ19","v":""},"","","","","","","",{"$nulls":11},{"$f":"IF(AU19>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H19=\"\",M19=\"\"),\"\",IF(AF19>0,AF19,IF($M19=99,\"?\",INDEX(BW19:DF19,,MATCH(M19,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},14,"A + (C) ",{"$nulls":4},1,1,1,{"$f":"IF($AY$7=2,1,2)","v":2},{"$nulls":4},0,12,7073.5,null,null,0]
[null,null,"Ground Beam 1005",null,null,{"v":8,"d":"08"},"H",12,1,6,6,{"$f":"AI20","v":8000},{"v":0,"d":"00"},{"$f":"AJ20","v":8000},{"$f":"AK20","v":""},{"$f":"AL20","v":""},{"$f":"AM20","v":""},{"$f":"AN20","v":""},{"$f":"AO20","v":""},{"$f":"AP20","v":""},{"v":42.61507602741482,"d":"42.6"},{"$nulls":3},8000,{"$nulls":7},{"$f":"IF(AU20>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H20=\"\",M20=\"\"),\"\",IF(AF20>0,AF20,IF($M20=99,\"?\",INDEX(BW20:DF20,,MATCH(M20,$BW$12:$DF$12,0)))))","v":8000},8000,"","","","","","",null,1,"-","-",0,{"$nulls":10},24,null,85,{"$f":"IF(OR(M20=47,M20=48,M20=51,M20=56,M20=63,M20=64,M20=98),CEILING(BJ20,5),CEILING(MAX(Y20,IF(M20=1,IF(Y20<6000,6000,IF(Y20>12000,Y20,12000)),IF(M20=12,MAX(BU20+12+MAX(5*12,90),125),IF(M20=13,MAX(125,BK20/2+MAX(5*12,90)),IF(M20=33,BK20/2+BM20,IF(M20=52,120,125)))))),5))","v":8000},{"$f":"IF(OR(M20=47,M20=48),MAX(Y20,AA20,125,120),IF(OR(M20=51,M20=63),MAX(Y20,AA20,155,120),IF(M20=56,MAX(Y20,AC20,155,120),IF(M20=64,MAX(Y20,155),IF(M20=98,MAX(Y20,120),0)))))","v":0},{"$f":"IF(OR(M20=\"\",M20=0,M20=1),\"\",IF(OR(M20=15,M20=51,M20=52,M20=56),CEILING(BL20,5),IF(M20=77,BL20,CEILING(IF(OR(M20=11,M20=25,M20=75),MAX(Z20,125),IF(M20=12,MAX(Z20,BU20+12+MAX(5*12,90),125),IF(OR(M20=13,M20=33),MIN(MAX(BH20,Z20),400+2*12),IF(M20=14,MAX(Z20,BH20),MAX(Z20,120))))),5))))","v":""},{"$f":"IF(M20=77,MAX(Z20,12),CEILING(IF(M20=15,MAX(Z20,5),IF(M20=51,MAX(Z20,AA20,155,120),IF(M20=52,MAX(Z20,AA20,125,120),IF(M20=56,MAX(Z20,AC20,155,120),0)))),5))","v":0},{"$f":"IF(M20=77,MAX(AA20,1),IF(OR(M20=\"\",M20=0,M20=1,M20=11,M20=12,M20=75),\"\",IF(OR(M20=48,M20=51,M20=52,M20=56,M20=63,M20=67,M20=98),CEILING(BN20,5),CEILING(IF(OR(M20=13,M20=33),MAX(AA20,BK20/2+MAX(5*12,90)),IF(M20=22,MIN(MAX(BH20,AA20),400+2*12),IF(M20=25,MAX(AA20,5),IF(OR(M20=14,M20=15,M20=21,M20=23,M20=24,M20=26,M20=27,M20=28,M20=29,M20=47),MAX(AA20,125),MAX(AA20,120))))),5))))","v":""},{"$f":"IF(OR(M20=51,M20=63),MAX(AA20,155),IF(OR(M20=48,M20=52,M20=98),MAX(AA20,125),IF(M20=56,MAX(AA20,120),IF(M20=67,MAX(AA20,5),0))))","v":0},{"$f":"IF(OR(M20=\"\",M20=0,M20=1,M20=11,M20=12,M20=13,M20=21,M20=23,M20=33,M20=67,M20=75,M20=77),\"\",IF(OR(M20=29,M20=31,M20=32,M20=36,M20=47,M20=48,M20=51,M20=52,M20=63,M20=98),CEILING(BP20,5),CEILING(IF(M20=22,MAX(AB20,BM20/2+MAX(5*12,90),125),IF(OR(M20=14,M20=15,M20=24,M20=25,M20=26,M20=27,M20=28,M20=34,M20=35,M20=46),MAX(AB20,5),MAX(AB20,120))),5)))","v":""},{"$f":"CEILING(IF(OR(M20=31,M20=32,M20=36,M20=98),MAX(AB20,125),IF(M20=29,MAX(AB20,BH20),IF(OR(M20=47,M20=48,M20=51,M20=52,M20=63),BM20,0))),5)","v":0},{"$f":"IF(OR(M20=24,M20=26,M20=27,M20=28,M20=29,M20=36),CEILING(MAX(AC20,5),5),IF(OR(M20=25,M20=64),CEILING(MAX(AC20,120),5),IF(OR(M20=34,M20=35,M20=41,M20=44,M20=46),CEILING(MAX(AC20,125),5),IF(M20=56,CEILING(MAX(AC20,155),5),IF(M20=99,0,\"\")))))","v":""},0,{"$f":"IF(OR(M20=34,M20=35,M20=36,M20=46),CEILING(MAX(AD20,5),5),IF(M20=56,BQ20,IF(M20=64,CEILING(MAX(AD20,155),5),IF(M20=99,0,\"\"))))","v":""},0,"",0,{"$f":"IF($M20=BW$12,CEILING(BI20,25),\"\")","v":8000},{"$f":"IF($M20=BX$12,CEILING(BI20,25),\"\")","v":""},{"$f":"IF($M20=BY$12,CEILING(BI20+BK20-0.5*BF20-12,25),\"\")","v":""},{"$f":"IF($M20=BZ$12,CEILING(BI20+BK20-0.43*BU20-1.2*12,25),\"\")","v":""},{"$f":"IF($M20=CA$12,CEILING(BI20+0.57*BK20+BM20-1.6*12,25),\"\")","v":""},null,null,{"$f":"IF($M20=CD$12,CEILING(BI20+BK20+BM20-BF20-2*12,25),\"\")","v":""},{"$f":"IF($M20=CE$12,CEILING(BI20+BK20+0.57*BM20+BO20-0.5*BF20-2.6*12,25),\"\")","v":""},{"$f":"IF($M20=CF$12,CEILING(BI20+BK20+BM20-BF20-2*12,25),\"\")","v":""},{"$nulls":33},15,"A + (C) ",{"$nulls":4},1,1,1,{"$f":"IF($AY$7=2,1,2)","v":2},{"$nulls":4},48,13,0,null,null,0]
[{"$nulls":5},{"v":9,"d":"09"},"H",12,1,6,6,{"$f":"AI21","v":3250},99,1500,700,1000,400,575,"","",{"v":17.31237463613727,"d":"17.3"},{"$nulls":3},1500,700,1000,400,575,null,null,3250,{"$f":"IF(AU21>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H21=\"\",M21=\"\"),\"\",IF(AF21>0,AF21,IF($M21=99,\"?\",INDEX(BW21:DF21,,MATCH(M21,$BW$12:$DF$12,0)))))","v":3250},1500,700,1000,400,575,"","",null,1,"-","-",0,{"$nulls":10},24,null,85,{"$f":"IF(OR(M21=47,M21=48,M21=51,M21=56,M21=63,M21=64,M21=98),CEILING(BJ21,5),CEILING(MAX(Y21,IF(M21=1,IF(Y21<6000,6000,IF(Y21>12000,Y21,12000)),IF(M21=12,MAX(BU21+12+MAX(5*12,90),125),IF(M21=13,MAX(125,BK21/2+MAX(5*12,90)),IF(M21=33,BK21/2+BM21,IF(M21=52,120,125)))))),5))","v":1500},{"$f":"IF(OR(M21=47,M21=48),MAX(Y21,AA21,125,120),IF(OR(M21=51,M21=63),MAX(Y21,AA21,155,120),IF(M21=56,MAX(Y21,AC21,155,120),IF(M21=64,MAX(Y21,155),IF(M21=98,MAX(Y21,120),0)))))","v":0},{"$f":"IF(OR(M21=\"\",M21=0,M21=1),\"\",IF(OR(M21=15,M21=51,M21=52,M21=56),CEILING(BL21,5),IF(M21=77,BL21,CEILING(IF(OR(M21=11,M21=25,M21=75),MAX(Z21,125),IF(M21=12,MAX(Z21,BU21+12+MAX(5*12,90),125),IF(OR(M21=13,M21=33),MIN(MAX(BH21,Z21),400+2*12),IF(M21=14,MAX(Z21,BH21),MAX(Z21,120))))),5))))","v":700},{"$f":"IF(M21=77,MAX(Z21,12),CEILING(IF(M21=15,MAX(Z21,5),IF(M21=51,MAX(Z21,AA21,155,120),IF(M21=52,MAX(Z21,AA21,125,120),IF(M21=56,MAX(Z21,AC21,155,120),0)))),5))","v":0},{"$f":"IF(M21=77,MAX(AA21,1),IF(OR(M21=\"\",M21=0,M21=1,M21=11,M21=12,M21=75),\"\",IF(OR(M21=48,M21=51,M21=52,M21=56,M21=63,M21=67,M21=98),CEILING(BN21,5),CEILING(IF(OR(M21=13,M21=33),MAX(AA21,BK21/2+MAX(5*12,90)),IF(M21=22,MIN(MAX(BH21,AA21),400+2*12),IF(M21=25,MAX(AA21,5),IF(OR(M21=14,M21=15,M21=21,M21=23,M21=24,M21=26,M21=27,M21=28,M21=29,M21=47),MAX(AA21,125),MAX(AA21,120))))),5))))","v":1000},{"$f":"IF(OR(M21=51,M21=63),MAX(AA21,155),IF(OR(M21=48,M21=52,M21=98),MAX(AA21,125),IF(M21=56,MAX(AA21,120),IF(M21=67,MAX(AA21,5),0))))","v":0},{"$f":"IF(OR(M21=\"\",M21=0,M21=1,M21=11,M21=12,M21=13,M21=21,M21=23,M21=33,M21=67,M21=75,M21=77),\"\",IF(OR(M21=29,M21=31,M21=32,M21=36,M21=47,M21=48,M21=51,M21=52,M21=63,M21=98),CEILING(BP21,5),CEILING(IF(M21=22,MAX(AB21,BM21/2+MAX(5*12,90),125),IF(OR(M21=14,M21=15,M21=24,M21=25,M21=26,M21=27,M21=28,M21=34,M21=35,M21=46),MAX(AB21,5),MAX(AB21,120))),5)))","v":400},{"$f":"CEILING(IF(OR(M21=31,M21=32,M21=36,M21=98),MAX(AB21,125),IF(M21=29,MAX(AB21,BH21),IF(OR(M21=47,M21=48,M21=51,M21=52,M21=63),BM21,0))),5)","v":0},{"$f":"IF(OR(M21=24,M21=26,M21=27,M21=28,M21=29,M21=36),CEILING(MAX(AC21,5),5),IF(OR(M21=25,M21=64),CEILING(MAX(AC21,120),5),IF(OR(M21=34,M21=35,M21=41,M21=44,M21=46),CEILING(MAX(AC21,125),5),IF(M21=56,CEILING(MAX(AC21,155),5),IF(M21=99,0,\"\")))))","v":0},0,{"$f":"IF(OR(M21=34,M21=35,M21=36,M21=46),CEILING(MAX(AD21,5),5),IF(M21=56,BQ21,IF(M21=64,CEILING(MAX(AD21,155),5),IF(M21=99,0,\"\"))))","v":0},0,0,0,{"$f":"IF($M21=BW$12,CEILING(BI21,25),\"\")","v":""},{"$f":"IF($M21=BX$12,CEILING(BI21,25),\"\")","v":""},{"$f":"IF($M21=BY$12,CEILING(BI21+BK21-0.5*BF21-12,25),\"\")","v":""},{"$f":"IF($M21=BZ$12,CEILING(BI21+BK21-0.43*BU21-1.2*12,25),\"\")","v":""},{"$f":"IF($M21=CA$12,CEILING(BI21+0.57*BK21+BM21-1.6*12,25),\"\")","v":""},null,null,{"$f":"IF($M21=CD$12,CEILING(BI21+BK21+BM21-BF21-2*12,25),\"\")","v":""},{"$f":"IF($M21=CE$12,CEILING(BI21+BK21+0.57*BM21+BO21-0.5*BF21-2.6*12,25),\"\")","v":""},{"$f":"IF($M21=CF$12,CEILING(BI21+BK21+BM21-BF21-2*12,25),\"\")","v":""},{"$nulls":33},21,"A + B + (C) - r - 2d",{"$nulls":4},1,1,1,{"$nulls":5},19.5,14,0,null,null,0]
[{"$nulls":11},"",null,{"$f":"AJ22","v":""},{"$f":"AK22","v":""},{"$f":"AL22","v":""},{"$f":"AM22","v":""},{"$f":"AN22","v":""},{"$f":"AO22","v":""},{"$f":"AP22","v":""},"",{"$nulls":11},{"$f":"IF(AU22>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H22=\"\",M22=\"\"),\"\",IF(AF22>0,AF22,IF($M22=99,\"?\",INDEX(BW22:DF22,,MATCH(M22,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},22,"A + B + 0.57C + (D) - 0.5r - 2.6d",{"$nulls":4},1,1,1,1,{"$nulls":4},0,15,0]
[{"$nulls":11},"",null,{"$f":"AJ23","v":""},{"$f":"AK23","v":""},{"$f":"AL23","v":""},{"$f":"AM23","v":""},{"$f":"AN23","v":""},{"$f":"AO23","v":""},{"$f":"AP23","v":""},"",{"$nulls":11},{"$f":"IF(AU23>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H23=\"\",M23=\"\"),\"\",IF(AF23>0,AF23,IF($M23=99,\"?\",INDEX(BW23:DF23,,MATCH(M23,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},23,"A + B + (C) - r - 2d",{"$nulls":4},1,1,1,{"$nulls":5},0,16,0]
[{"$nulls":11},"",null,{"$f":"AJ24","v":""},{"$f":"AK24","v":""},{"$f":"AL24","v":""},{"$f":"AM24","v":""},{"$f":"AN24","v":""},{"$f":"AO24","v":""},{"$f":"AP24","v":""},"",{"$nulls":11},{"$f":"IF(AU24>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H24=\"\",M24=\"\"),\"\",IF(AF24>0,AF24,IF($M24=99,\"?\",INDEX(BW24:DF24,,MATCH(M24,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},24,"A + B + (C) ",{"$nulls":4},1,1,1,1,{"$f":"IF($AY$7=2,1,2)","v":2},{"$nulls":3},0,17,0]
[{"$nulls":11},"",null,"","","","","","","","",{"$nulls":11},{"$f":"IF(AU25>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H25=\"\",M25=\"\"),\"\",IF(AF25>0,AF25,IF($M25=99,\"?\",INDEX(BW25:DF25,,MATCH(M25,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},25,"A + B + (E) ",{"$nulls":4},1,1,1,1,1,{"$nulls":3},0,18,0,null,null,0]
[{"$nulls":11},"",null,{"$f":"AJ26","v":""},{"$f":"AK26","v":""},{"$f":"AL26","v":""},{"$f":"AM26","v":""},{"$f":"AN26","v":""},{"$f":"AO26","v":""},{"$f":"AP26","v":""},"",{"$nulls":11},{"$f":"IF(AU26>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H26=\"\",M26=\"\"),\"\",IF(AF26>0,AF26,IF($M26=99,\"?\",INDEX(BW26:DF26,,MATCH(M26,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},26,"A + B + (C) ",{"$nulls":4},1,1,1,1,{"$f":"IF($AY$7=2,1,2)","v":2},{"$nulls":3},0,19,0]
[{"$nulls":11},"",null,{"$f":"AJ27","v":""},{"$f":"AK27","v":""},{"$f":"AL27","v":""},{"$f":"AM27","v":""},{"$f":"AN27","v":""},{"$f":"AO27","v":""},{"$f":"AP27","v":""},"",{"$nulls":11},{"$f":"IF(AU27>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H27=\"\",M27=\"\"),\"\",IF(AF27>0,AF27,IF($M27=99,\"?\",INDEX(BW27:DF27,,MATCH(M27,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},27,"A + B + (C) - 0.5r - d",{"$nulls":4},1,1,1,1,2,{"$nulls":3},0,20,0]
[{"$nulls":11},"",null,{"$f":"AJ28","v":""},{"$f":"AK28","v":""},{"$f":"AL28","v":""},{"$f":"AM28","v":""},{"$f":"AN28","v":""},{"$f":"AO28","v":""},{"$f":"AP28","v":""},"",{"$nulls":11},{"$f":"IF(AU28>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H28=\"\",M28=\"\"),\"\",IF(AF28>0,AF28,IF($M28=99,\"?\",INDEX(BW28:DF28,,MATCH(M28,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},28,"A + B + (C) - 0.5r - d",{"$nulls":4},1,1,1,1,2,{"$nulls":3},0,21,0]
[{"$nulls":11},"",null,{"$f":"AJ29","v":""},{"$f":"AK29","v":""},{"$f":"AL29","v":""},{"$f":"AM29","v":""},{"$f":"AN29","v":""},{"$f":"AO29","v":""},{"$f":"AP29","v":""},"",{"$nulls":11},{"$f":"IF(AU29>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H29=\"\",M29=\"\"),\"\",IF(AF29>0,AF29,IF($M29=99,\"?\",INDEX(BW29:DF29,,MATCH(M29,$BW$12:$DF$12,0)))))","v":""},"","","",{"$f":"IF(OR(H29=\"\",AR29=0,M29=\"\",M29=0,M29=1,M29=11,M29=12,M29=13,M29=21,M29=23,M29=33,M29=67,M29=75,M29=77,AND(AB29=\"\",$AU29=4)),\"\",IF(M29=99,IF(AB29=\"\",\"\",CEILING(AB29,5)),IF(OR(M29=22,M29=31,M29=32,M29=36,M29=47,M29=48,M29=51,M29=52,M29=56,M29=63,M29=98),\"(\"&BO29&\")\",BO29)))","v":""},{"$f":"IF(OR(H29=\"\",AR29=0,AND(AC29=\"\",$AU29=5)),\"\",IF(M29=99,IF(AC29=\"\",\"\",CEILING(AC29,5)),IF(OR(M29=24,M29=26,M29=27,M29=28,M29=29,M29=36,M29=64),BQ29,IF(OR(M29=25,M29=34,M29=35,M29=41,M29=44,M29=46,M29=56),\"(\"&BQ29&\")\",\"\"))))","v":""},{"$f":"IF(OR(H29=\"\",AR29=0,AND(AD29=\"\",$AU29=6)),\"\",IF(M29=99,IF(AD29=\"\",\"\",CEILING(AD29,5)),IF(OR(M29=34,M29=35,M29=36,M29=46),BS29,IF(OR(M29=56,M29=64),\"(\"&BS29&\")\",\"\"))))","v":""},"",null,1,"-","-",0,{"$nulls":70},29,"A + B + (C)",{"$nulls":4},1,1,1,1,2,{"$nulls":3},0,22,0]
[{"$nulls":11},"",null,{"$f":"AJ30","v":""},{"$f":"AK30","v":""},{"$f":"AL30","v":""},{"$f":"AM30","v":""},{"$f":"AN30","v":""},{"$f":"AO30","v":""},{"$f":"AP30","v":""},"",{"$nulls":11},{"$f":"IF(AU30>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H30=\"\",M30=\"\"),\"\",IF(AF30>0,AF30,IF($M30=99,\"?\",INDEX(BW30:DF30,,MATCH(M30,$BW$12:$DF$12,0)))))","v":""},"","","",{"$f":"IF(OR(H30=\"\",AR30=0,M30=\"\",M30=0,M30=1,M30=11,M30=12,M30=13,M30=21,M30=23,M30=33,M30=67,M30=75,M30=77,AND(AB30=\"\",$AU30=4)),\"\",IF(M30=99,IF(AB30=\"\",\"\",CEILING(AB30,5)),IF(OR(M30=22,M30=31,M30=32,M30=36,M30=47,M30=48,M30=51,M30=52,M30=56,M30=63,M30=98),\"(\"&BO30&\")\",BO30)))","v":""},{"$f":"IF(OR(H30=\"\",AR30=0,AND(AC30=\"\",$AU30=5)),\"\",IF(M30=99,IF(AC30=\"\",\"\",CEILING(AC30,5)),IF(OR(M30=24,M30=26,M30=27,M30=28,M30=29,M30=36,M30=64),BQ30,IF(OR(M30=25,M30=34,M30=35,M30=41,M30=44,M30=46,M30=56),\"(\"&BQ30&\")\",\"\"))))","v":""},{"$f":"IF(OR(H30=\"\",AR30=0,AND(AD30=\"\",$AU30=6)),\"\",IF(M30=99,IF(AD30=\"\",\"\",CEILING(AD30,5)),IF(OR(M30=34,M30=35,M30=36,M30=46),BS30,IF(OR(M30=56,M30=64),\"(\"&BS30&\")\",\"\"))))","v":""},"",null,1,"-","-",0,{"$nulls":70},31,"A + B + C + (D) - 1.5r - 3d",{"$nulls":4},1,1,1,1,{"$nulls":4},0,23,0]
[{"$nulls":11},"",null,{"$f":"AJ31","v":""},{"$f":"AK31","v":""},{"$f":"AL31","v":""},{"$f":"AM31","v":""},{"$f":"AN31","v":""},{"$f":"AO31","v":""},{"$f":"AP31","v":""},"",{"$nulls":11},{"$f":"IF(AU31>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H31=\"\",M31=\"\"),\"\",IF(AF31>0,AF31,IF($M31=99,\"?\",INDEX(BW31:DF31,,MATCH(M31,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},32,"A + B + C + (D) - 1.5r - 3d",{"$nulls":4},1,1,1,1,{"$nulls":4},0,24,0]
[{"$nulls":11},"",null,{"$f":"AJ32","v":""},{"$f":"AK32","v":""},{"$f":"AL32","v":""},{"$f":"AM32","v":""},{"$f":"AN32","v":""},{"$f":"AO32","v":""},{"$f":"AP32","v":""},"",{"$nulls":11},{"$f":"IF(AU32>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H32=\"\",M32=\"\"),\"\",IF(AF32>0,AF32,IF($M32=99,\"?\",INDEX(BW32:DF32,,MATCH(M32,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},33,"2A + 1.7B + 2(C) - 4d",{"$nulls":4},1,1,1,{"$nulls":5},0,25,0]
[{"$nulls":11},"",null,{"$f":"AJ33","v":""},{"$f":"AK33","v":""},{"$f":"AL33","v":""},{"$f":"AM33","v":""},{"$f":"AN33","v":""},{"$f":"AO33","v":""},{"$f":"AP33","v":""},"",{"$nulls":11},{"$f":"IF(AU33>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H33=\"\",M33=\"\"),\"\",IF(AF33>0,AF33,IF($M33=99,\"?\",INDEX(BW33:DF33,,MATCH(M33,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},34,"A + B + C + (E) - 0.5r - d",{"$nulls":4},1,1,1,1,1,{"$f":"IF($AY$7=2,1,2)","v":2},null,null,0,26,0]
[{"$nulls":11},"",null,{"$f":"AJ34","v":""},{"$f":"AK34","v":""},{"$f":"AL34","v":""},{"$f":"AM34","v":""},{"$f":"AN34","v":""},{"$f":"AO34","v":""},{"$f":"AP34","v":""},"",{"$nulls":11},{"$f":"IF(AU34>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H34=\"\",M34=\"\"),\"\",IF(AF34>0,AF34,IF($M34=99,\"?\",INDEX(BW34:DF34,,MATCH(M34,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},35,"A + B + C + (E) - 0.5r - d",{"$nulls":4},1,1,1,1,1,2,null,null,0,27,0]
[{"$nulls":11},"",null,{"$f":"AJ35","v":""},{"$f":"AK35","v":""},{"$f":"AL35","v":""},{"$f":"AM35","v":""},{"$f":"AN35","v":""},{"$f":"AO35","v":""},{"$f":"AP35","v":""},"",{"$nulls":11},{"$f":"IF(AU35>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H35=\"\",M35=\"\"),\"\",IF(AF35>0,AF35,IF($M35=99,\"?\",INDEX(BW35:DF35,,MATCH(M35,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},36,"A + B + C + (D) - r - 2d",{"$nulls":4},1,1,1,1,1,2,null,null,0,28,0]
[{"$nulls":11},"",null,{"$f":"AJ36","v":""},{"$f":"AK36","v":""},{"$f":"AL36","v":""},{"$f":"AM36","v":""},{"$f":"AN36","v":""},{"$f":"AO36","v":""},{"$f":"AP36","v":""},"",{"$nulls":11},{"$f":"IF(AU36>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H36=\"\",M36=\"\"),\"\",IF(AF36>0,AF36,IF($M36=99,\"?\",INDEX(BW36:DF36,,MATCH(M36,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},41,"A + B + C + D + (E) - 2r - 4d",{"$nulls":4},1,1,1,1,1,{"$nulls":3},0,29,0]
[{"$nulls":11},"",null,{"$f":"AJ37","v":""},{"$f":"AK37","v":""},{"$f":"AL37","v":""},{"$f":"AM37","v":""},{"$f":"AN37","v":""},{"$f":"AO37","v":""},{"$f":"AP37","v":""},"",{"$nulls":11},{"$f":"IF(AU37>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H37=\"\",M37=\"\"),\"\",IF(AF37>0,AF37,IF($M37=99,\"?\",INDEX(BW37:DF37,,MATCH(M37,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},44,"A + B + C + D + (E) - 2r - 4d",{"$nulls":4},1,1,1,1,1,{"$nulls":3},0,30,0]
[{"$nulls":11},"",null,{"$f":"AJ38","v":""},{"$f":"AK38","v":""},{"$f":"AL38","v":""},{"$f":"AM38","v":""},{"$f":"AN38","v":""},{"$f":"AO38","v":""},{"$f":"AP38","v":""},"",{"$nulls":11},{"$f":"IF(AU38>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H38=\"\",M38=\"\"),\"\",IF(AF38>0,AF38,IF($M38=99,\"?\",INDEX(BW38:DF38,,MATCH(M38,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},46,"A + 2B + C + (E)",{"$nulls":4},1,1,1,1,1,{"$f":"IF($AY$7=2,1,2)","v":2},null,null,0,31,0]
[{"$nulls":11},"",null,{"$f":"AJ39","v":""},{"$f":"AK39","v":""},{"$f":"AL39","v":""},{"$f":"AM39","v":""},{"$f":"AN39","v":""},{"$f":"AO39","v":""},{"$f":"AP39","v":""},"",{"$nulls":11},{"$f":"IF(AU39>0,\"*\",\"\")","v":""},null,{"$f":"IF(OR(H39=\"\",M39=\"\"),\"\",IF(AF39>0,AF39,IF($M39=99,\"?\",INDEX(BW39:DF39,,MATCH(M39,$BW$12:$DF$12,0)))))","v":""},"","","","","","","",null,1,"-","-",0,{"$nulls":70},47,"2A + B + 2(C) +2q - 3r - 6d",{"$nulls":4},1,1,1,{"$nulls":5},0,32,0]
[{"$nulls":3},"This schedule conforms to BS 8666:2020",{"$nulls":7},"FREE LITE VERSION",{"$nulls":7},"Total weight on this page [kg] = ",{"$f":"SUM(U13:U39)","v":{"v":6279.952922498307,"d":"6279.953"}},{"$nulls":3},{"$f":"IF(AU40>0,IF(AX8,\"*make sure to enter accurate dimensions\",\"*make sure dimensions in lighter fill colour cells do not conflict with others\"),\"\")","v":""},{"$nulls":21},{"$f":"SUM(AU13:AU39)","v":0},{"$nulls":70},48,"2A + B + 2(C) - r - 2d",{"$nulls":4},1,1,1,{"$nulls":6},33,0]
[{"$nulls":3},"* Specified in multiples of 5mm",{"$nulls":7},"Status: P - Preliminary; T - Tender; C - Construction",{"$nulls":105},51,"2(A+B+(C)) - 2.5r - 5d",{"$nulls":4},1,1,1,{"$nulls":6},34,0]
[{"$nulls":3},"† Specified in multiples of 25mm",{"$nulls":113},52,"2(A+B+(C)) - 1.5r - 3d",{"$nulls":4},1,1,1,{"$nulls":6},35,0]
[{"$nulls":15},"Spreadsheet provided by: www.YourSpreadsheets.co.uk",{"$nulls":101},56,"A + B + C + (D) + 2(E) - 1.5r - 3d",{"$nulls":4},1,1,1,1,1,{"$nulls":4},36,0]
[{"$nulls":117},63,"2A + 3B + 2(C) - 3r - 6d",{"$nulls":4},1,1,1,{"$nulls":6},37,0]
[{"$nulls":117},64,"A + B + C + 2D + E + (F) - 3r - 6d",{"$nulls":4},1,1,1,1,1,1,{"$nulls":3},38,0]
[{"$nulls":117},67,"A",{"$nulls":4},1,1,1,{"$nulls":3},1,null,null,39,0]
[{"$nulls":117},75,"pi * (A - d) + B +25",{"$nulls":4},1,1,{"$nulls":7},40,0]
[{"$nulls":117},77,"C * pi * (A - d)",{"$nulls":4},1,1,1,{"$nulls":6},41,0]
[{"$nulls":117},98,"A + 2B + C + (D) - 2r - 4d",{"$nulls":4},1,1,1,1,{"$nulls":5},42,0]
[{"$nulls":117},99,{"$nulls":5},0,{"$nulls":8},43,0]
[{"$nulls":132},44,0]
[{"$nulls":132},45,0]
[{"$nulls":132},46,0]
[{"$nulls":132},47,0]
[{"$nulls":132},48,0]
[{"$nulls":132},49,0]
[{"$nulls":132},50,0]

{"sheet":"bar weights","index":1,"n_rows":70,"n_cols":41,"rows_kept":70,"merged":[[0,1,0,16],[0,17,0,32],[1,4,4,16],[1,17,3,23],[1,24,1,26],[1,27,1,32],[2,24,2,26],[2,27,2,32],[3,24,3,26],[3,27,3,32],[4,17,4,19],[4,20,4,23],[4,24,4,26],[4,27,4,32],[5,2,5,3],[5,4,5,16],[5,17,5,19],[5,20,5,23],[5,24,5,26],[5,27,5,32],[6,2,6,3],[6,4,6,16],[6,17,6,19],[6,20,6,23],[6,24,6,26],[6,27,6,32],[9,9,10,24],[11,9,12,11],[11,12,12,20],[11,21,12,24],[13,9,14,11],[13,12,14,20],[13,21,14,24],[15,9,16,11],[15,12,16,20],[15,21,16,24],[17,9,18,11],[17,12,18,20],[17,21,18,24],[19,9,20,11],[19,12,20,20],[19,21,20,24],[21,9,22,11],[21,12,22,20],[21,21,22,24],[23,9,24,11],[23,12,24,20],[23,21,24,24],[25,9,26,11],[25,12,26,20],[25,21,26,24],[27,9,28,11],[27,12,28,20],[27,21,28,24],[29,9,30,11],[29,12,30,20],[29,21,30,24],[31,9,32,11],[31,12,32,20],[31,21,32,24],[34,16,35,20],[34,21,35,24],[38,8,39,25],[42,2,42,31],[43,2,65,31],[67,12,68,23],[69,21,69,31]]}
[null,"Version: 3.1. - FREE LITE VERSION",{"$nulls":15},"© 2010-2021 Damian Janicki",{"$nulls":17},"global variables:"]
[{"$nulls":4},"YourSpreadsheets™\nYour Office Address Goes Here\nwww.YourSpreadsheets.co.uk\nTel: 010 1234 567890 (example only)",{"$nulls":12},{"$f":"IF('bar schedule'!N2=\"\",\"\",'bar schedule'!N2)","v":"86 MARGERY STREET, LONDON"},{"$nulls":6},"Status:",null,null,{"$f":"IF('bar schedule'!T2=\"\",\"\",'bar schedule'!T2)","v":"C"},{"$nulls":7},true,true,true,1]
[{"$nulls":24},"Drawing No:",null,null,{"$f":"IF('bar schedule'!T3=\"\",\"\",'bar schedule'!T3)","v":"A1/503"}]
[{"$nulls":24},"Sheet No:",null,null,{"$f":"IF('bar schedule'!T4=\"\",\"\",'bar schedule'!T4)","v":1}]
[{"$nulls":17},"Job No:",null,null,{"$f":"IF('bar schedule'!P5=\"\",\"\",'bar schedule'!P5)","v":22190},{"$nulls":3},"Revision:",null,null,{"$f":"IF('bar schedule'!T5=\"\",\"\",'bar schedule'!T5)","v":"A"}]
[null,null,"Section: ",null,"Summary of Bar weights",{"$nulls":12},"Prepared By:",null,null,{"$f":"IF('bar schedule'!P6=\"\",\"\",'bar schedule'!P6)","v":"DJ"},{"$nulls":3},"Date:",null,null,{"$f":"IF('bar schedule'!T6=\"\",\"\",'bar schedule'!T6)","v":"2021-05-31"}]
[null,null,"Location: ",null,{"$f":"IF('bar schedule'!E7=\"\",\"\",'bar schedule'!E7)","v":"Foundations"},{"$nulls":12},"Checked By:",null,null,{"$f":"IF('bar schedule'!P7=\"\",\"\",'bar schedule'!P7)","v":"DJ"},{"$nulls":3},"Last Revised:",null,null,{"$f":"IF('bar schedule'!T7=\"\",\"\",'bar schedule'!T7)","v":"2013-11-26"},{"$nulls":7},"bar diameter","total bar length per diametere [VBA column]","bar diameters used","counter","first 10 bar diameters to be summed","bar lengths"]
[{"$nulls":35},6,0,{"$f":"IF(AK8=0,\"\",AJ8)","v":""},1,{"$f":"IFERROR(SMALL($AL$8:$AL$52,AM8),\"\")","v":12},{"$f":"IFERROR(INDEX($AK$8:$AK$52,MATCH(AN8,$AJ$8:$AJ$52,0)),\"\")","v":7073.5}]
[{"$nulls":35},7,0,{"$f":"IF(AK9=0,\"\",AJ9)","v":""},2,"",""]
[{"$nulls":9},"Summary of bar lengths and weights",{"$nulls":25},8,0,"",3,"",""]
[{"$nulls":35},9,0,"",4,"",""]
[{"$nulls":9},"Bar size",null,null,"Total length [m]\n(of all bars in this size)",{"$nulls":8},"Weight [kg]",{"$nulls":13},10,0,"",5,"",""]
[{"$nulls":35},11,0,"",6,"",""]
[{"$nulls":9},{"$f":"AN8","v":12},null,null,{"$f":"AO8","v":{"v":7073.5,"d":"7073.500"}},{"$nulls":8},{"$f":"IF(J14=\"\",\"\",M14*(J14/2)^2*PI()*0.00785)","v":{"v":6279.952922498307,"d":"6279.953"}},{"$nulls":13},12,7073.5,12,7,"",""]
[{"$nulls":35},13,0,"",8,"",""]
[{"$nulls":9},{"$f":"AN9","v":""},null,null,{"$f":"AO9","v":""},{"$nulls":8},{"$f":"IF(J16=\"\",\"\",M16*(J16/2)^2*PI()*0.00785)","v":""},{"$nulls":13},14,0,"",9,"",""]
[{"$nulls":35},15,0,"",10,"",""]
[{"$nulls":9},{"$f":"AN10","v":""},null,null,{"$f":"AO10","v":""},{"$nulls":8},{"$f":"IF(J18=\"\",\"\",M18*(J18/2)^2*PI()*0.00785)","v":""},{"$nulls":13},16,0,""]
[{"$nulls":35},17,0,""]
[{"$nulls":9},{"$f":"AN11","v":""},null,null,{"$f":"AO11","v":""},{"$nulls":8},{"$f":"IF(J20=\"\",\"\",M20*(J20/2)^2*PI()*0.00785)","v":""},{"$nulls":13},18,0,""]
[{"$nulls":35},19,0,""]
[{"$nulls":9},{"$f":"AN12","v":""},null,null,{"$f":"AO12","v":""},{"$nulls":8},{"$f":"IF(J22=\"\",\"\",M22*(J22/2)^2*PI()*0.00785)","v":""},{"$nulls":13},20,0,""]
[{"$nulls":35},21,0,""]
[{"$nulls":9},{"$f":"AN13","v":""},null,null,{"$f":"AO13","v":""},{"$nulls":8},{"$f":"IF(J24=\"\",\"\",M24*(J24/2)^2*PI()*0.00785)","v":""},{"$nulls":13},22,0,""]
[{"$nulls":35},23,0,""]
[{"$nulls":9},{"$f":"AN14","v":""},null,null,{"$f":"AO14","v":""},{"$nulls":8},{"$f":"IF(J26=\"\",\"\",M26*(J26/2)^2*PI()*0.00785)","v":""},{"$nulls":13},24,0,""]
[{"$nulls":35},25,0,""]
[{"$nulls":9},{"$f":"AN15","v":""},null,null,{"$f":"AO15","v":""},{"$nulls":8},{"$f":"IF(J28=\"\",\"\",M28*(J28/2)^2*PI()*0.00785)","v":""},{"$nulls":13},26,0,""]
[{"$nulls":35},27,0,""]
[{"$nulls":9},{"$f":"AN16","v":""},null,null,{"$f":"AO16","v":""},{"$nulls":8},{"$f":"IF(J30=\"\",\"\",M30*(J30/2)^2*PI()*0.00785)","v":""},{"$nulls":13},28,0,""]
[{"$nulls":35},29,0,""]
[{"$nulls":9},{"$f":"AN17","v":""},null,null,{"$f":"AO17","v":""},{"$nulls":8},{"$f":"IF(J32=\"\",\"\",M32*(J32/2)^2*PI()*0.00785)","v":""},{"$nulls":13},30,0,""]
[{"$nulls":35},31,0,""]
[{"$nulls":35},32,0,""]
[{"$nulls":16},"Total weight [kg]",{"$nulls":4},{"$f":"SUM(V14:Y33)","v":{"v":6279.952922498307,"d":"6279.953"}},{"$nulls":13},33,0,""]
[{"$nulls":35},34,0,""]
[{"$nulls":35},35,0,""]
[{"$nulls":35},36,0,""]
[{"$nulls":8},{"$f":"IF(COUNT($AL$8:$AL$57)>10,\"PLEASE NOTE: only up to 10 bar diameters can be summed in this spreadsheet. BS8666:2020 covers 10 bar diameters only.\",\"\")","v":""},{"$nulls":26},37,0,""]
[{"$nulls":35},38,0,""]
[{"$nulls":35},39,0,""]
[{"$nulls":35},40,0,""]
[null,null,"Additional information:",{"$nulls":32},41,0,""]
[{"$nulls":35},42,0,""]
[{"$nulls":35},43,0,""]
[{"$nulls":35},44,0,""]
[{"$nulls":35},45,0,""]
[{"$nulls":35},46,0,""]
[{"$nulls":35},47,0,""]
[{"$nulls":35},48,0,""]
[{"$nulls":35},49,0,""]
[{"$nulls":35},50,0,""]
{"$rows_empty":14}
[{"$nulls":3},"This schedule conforms to BS 8666:2020"]
[{"$nulls":12},"Status: P - Preliminary; T - Tender; C - Construction"]
[]
[{"$nulls":21},"Spreadsheet provided by: www.YourSpreadsheets.co.uk"]

{"sheet":"shape codes","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"template","index":3,"n_rows":20,"n_cols":17,"rows_kept":20,"hidden":true,"merged":[[3,3,3,5],[12,14,12,18],[19,4,22,17]]}
[26]
[1]
[]
[{"$nulls":3},"drawing size:",null,null,{"v":7,"d":"7   x"},7]
[]
[{"$nulls":4},"drawing area:",{"$nulls":9},"drawing tools:"]
[]
[{"$nulls":14},"dimension: ",null,"box: "]
[{"$nulls":14},"line: ",null,"arrow: "]
[{"$nulls":14},"bend: ",null,"arrow: "]
[{"$nulls":14},"text: ",null,"thread: "]
[]
[{"$nulls":14},"drag elemens into the drawing area and adjust"]
[]
[]
[]
[]
[]
[{"$nulls":4},"INSTRUCTIONS:"]
[{"$nulls":4},"You may import a shape diagram from an external source, it must be an image but you may resize and annoate it here once imported. Alternatively you may draw a new shape diagram here. Use either the standard drawing tools in Excel (you will find these under the 'Insert' menu in the Ribbon), or drag elements from the 'drawing tools' to the 'drawing area' and adjust these to suit (e.g. change colour, text, size, rotation, scale).\nNOTE: to delete an object just select it and press 'delete' key.\nNOTE: avoid drawing right next to the drawing area's border line as edges will be cropped when importing to schedule."]

{"sheet":"from author","index":4,"n_rows":46,"n_cols":14,"rows_kept":46,"merged":[[0,1,0,5],[0,6,0,10],[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9],[4,12,4,13],[6,2,9,9],[6,13,7,25],[12,2,30,9],[25,13,30,25],[34,2,41,9],[45,2,85,9]]}
[null,"Version: 3.1. - FREE LITE VERSION",{"$nulls":4},"© 2010-2021 Damian Janicki"]
[]
[null,null,"For latest updates and news visit:",{"$nulls":3},"Contact me at:"]
[null,null,"www.YourSpreadsheets.co.uk",{"$nulls":3},"info@yourspreadsheets.co.uk"]
[]
[]
[null,null,"General information:\nNOTE: This spreadsheet contains macros.\nAs this spreadsheets contains 'conditional formatting' it is recommended, when pasting data, to paste 'values only'. Furthermore to protect conditional formatting macro pasting 'values only' is assigned to Ctrl+v.",{"$nulls":10},"Video tutorial:\nIt is recommended to watch the video tutorial linked below to learn how to use the spreadsheet efficiently."]
[]
[]
[]
[]
[]
[null,null,"The Author takes no liability for use of this spreadsheet and gives no guarantee that it is error free. \n\nIn no event shall the Author be responsible for any special, incidental or consequential damages whatsoever arising from the use of this spreadsheet, even if the Author has been advised of the possibility of such damage.\n\nThis spreadsheet is a lite version and is a freeware and can be distributed freely but only in its original form.\n\nReverse-engineering, decompiling or disassembling of this spreadsheet is not allowed.\n\nBy using this spreadsheet you understand and agree with the above terms and conditions. You also acknowledge that you do not become the owner of this spreadsheet.\n\nDamian Janicki"]
{"$rows_empty":12}
[{"$nulls":13},"Keyboard shortcuts:\nCtrl + Shift + P to activate/deactivate pop-up window with Shapes Codes\nCtrl + Shift + N to activate/deactivate auto-jump to next input cell\nCtrl + Shift + E to activate/deactivate calculation of extra dimensions. In 'Settings' chose whether the extra dimension is horizontal or diagonal"]
{"$rows_empty":8}
[null,null,"This is a Free Lite version. The full version of the spreadsheet allows to:\n- input your company details and change logo;\n- change bar diameter and number;\n- use all shape codes from BS 8666:2020;\n- input data in the highlighted locked cells;\n- add/rename/delete/export sheets;\n- detail a different bar diameter than 12mm;"]
{"$rows_empty":10}
[null,null,"This spreadsheet is based on BS 8666: 2020.\n\nChangelog:\n31.05.2021 - v.3.1. - updated to BS8666:2020 - added two new shape codes, updated length calculations, updated bends, introduced calculation of extra dimensions (e.g. shape code 15). Input cell are now 1x1 rather than 2x2 (making it easier to copy and paste bar details between diffferent sources). It is now possible to sum bar diameters that are not covered by BS8666 (e.g. bar diameter 22 is used in Singapore together with BS8666). You can now insert images for shape code 99 - these can be imported and annotated; or can be drawn directly in this spreadsheet. Shape code 99 images can be re-arranged once inserted into schedule.\n17.12.2020 - v.2.8. - when exporting parentheses now do not change to negative numbers.\n24.11.2013 - v.2.7. - increased minimum P value for links with bents < 150 degrees. Added option to select a printer and pages to print when printing using 'Print Me' button or by pressing Ctrl+P (for standard printing options use Ribbon/Menu)\n27.05.2013 - v.2.6. - added an indication when user enters a length that is lower than a minimum required.\n18.07.2012 - v.2.5. - it is now possible to refresh conditional formatting by press Ctrl + Shift + R. This helps if spreadsheet runs slow. It is also possible to export BBS to a new file which is editable and not password protected (file can be sent to Client etc). Press Ctrl + Shift + E to export. Added shortcuts for activating/deactivating auto-jump to next 'fill in' cell Ctrl + Shift + N and pop up window with Shape Codes Ctrl + Shift + P.\n24.03.2012 - v.2.4. - option to show pop-up window or jump to next cell is now global. This means that changing it on one sheet will change it on all sheets.\n03.01.2012 - v.2.3. - when cells are merged, for mesh or bar mark 99, then bar weight is calculated based on length given in 'overwrite length' cell.\n22.10.2011 - v.2.2. - added graphic for shape code 14 in shape code reference tab.\n14.08.2011 - v.2.1. - assigned to a new domain: www.YourSpreadsheets.co.uk\n12.08.2011 - v.1.10. - after entering shape code, active cell is set to input field - length 'A'.\n10.03.2011 - v.1.9. - added button to print all pages. Other minor changes.\n27.11.2010 - v.1.8. - cell protection revised to work on Excel 97 and older.\n29.09.2010 - v.1.7. - spreadsheet activation is now required (note from the Author revised). Minor changes to company/project input table.\n04.09.2010 - v.1.6. - added option to merge cells (for scheduling mesh).\n31.07.2010 - v.1.5. - sheet with summary of bar weights added.\n06.07.2010 - v.1.4. - revised macros and 'shape code' sheet (with option to delete it).\n01.06.2010 - v.1.3. - conditional formatting revised. shape code pop-up window added. 'delete entries' macro is now reversible. Note from the Author revised.\n22.05.2010 - v.1.2. - official release of the spreadsheets."]