{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Calcs","List","updates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"Summary","index":0,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[45,0,45,2],[46,0,46,2],[60,0,60,10],[2,8,2,10],[3,8,3,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[15,8,15,10],[17,8,17,10],[18,8,18,10],[56,0,56,10],[57,0,57,10],[58,0,58,10],[8,1,8,2],[9,8,9,10],[9,1,9,2],[0,8,0,10],[59,0,59,10],[1,0,1,10],[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[8,8,8,10],[4,4,4,6],[51,1,51,3],[53,1,53,3],[50,1,50,3],[52,1,52,3],[51,4,51,5],[51,6,51,7],[14,4,14,6],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[21,10,22,10],[52,5,52,7],[5,4,5,6],[20,6,20,10],[15,4,15,5],[19,8,19,10],[21,4,22,4],[17,4,17,5],[18,4,18,5],[21,8,22,8],[16,8,16,10],[16,4,16,5],[21,5,22,5],[20,2,20,5],[39,0,39,2],[21,6,22,6],[21,7,22,7],[6,4,6,6],[7,4,7,6],[8,4,8,6],[9,4,9,6],[7,1,7,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[40,0,40,1],[19,0,19,2],[15,0,15,2],[14,0,14,3],[16,0,16,2],[17,0,17,2],[18,0,18,2],[20,0,22,0],[20,1,22,1],[21,2,22,2],[21,3,22,3],[10,1,10,3]]}
[]
["  Bridge Load Rating Summary Sheet"]
["Bridge Data"]
[]
["District    ",null,null,"Structure Number",null,null,null,"Bridge Name "," "]
["Parish   ",null,null,"Recall Number",null,null,null,"Inspection Date"," "]
["Route"," ",null,"Year Built"," ",null,null,"Overall"," "]
["Bridge Posting"," ",null,"Design Load"," ",null,null,"Deck"," "]
["Bridge Type"," ",null,"Roadway Width"," ",null,null,"Super"," "]
["Bridge Length"," ",null,"Plan Location","-",null,null,"Sub"," "]
["Standard Plan","-",null,null,"Std Plan Yr | Rev-","-","-","Culvert | Channel","-",null,"-"]
[]
["Bridge/Culvert Load Rating Summary"]
[]
["Dead Load",null,null,null,"LRFR Evaluation Factors",null,null,"Traffic"]
["Wearing Surface Thickness (in)",null,null,"-","Condition Factor, super (φc)",null,1,"ADTT (one way)"," "]
["Wearing Surface Type",null,null,null,"Condition Factor, sub (φc)"]
["Non-Structural Attachments",null,null,"-","System Factor, super (φs)",null,1]
["Fill Thickness (in)",null,null," ","System Factor, sub (φs)"]
[]
["Vehicle Type","GVW (kips)","Superstructure/Deck/Culvert",null,null,null,"Substructure"]
[null,null,"Rating Factor","Posting Weight (tons)","Controlling Member","Controlling Load Effect","Rating Factor","Posting Weight (tons)","Controlling Member",null,"Controlling Load Effect"]
[]
["HL-93 (INV)","N/A"]
["HL-93 (OPR)","N/A"]
["LADV-11(INV)","N/A"]
["LA Type 3",41,null,{"$f":"+Calcs!X25","v":"-"},null,null,null,{"$f":"Calcs!W25","v":"-"}]
["LA Type 3S2",73,null,{"$f":"+Calcs!X33","v":"-"},null,null,null,{"$f":"Calcs!W33","v":"-"}]
["Type 3-3",80,null,{"$f":"+Calcs!X34","v":"-"},null,null,null,{"$f":"Calcs!W34","v":"-"}]
["LA Type 6",80,null,{"$f":"+Calcs!X35","v":"-"},null,null,null,{"$f":"Calcs!W35","v":"-"}]
["LA Type 8",88,null,{"$f":"+Calcs!X36","v":"-"},null,null,null,{"$f":"Calcs!W36","v":"-"}]
["SU4",54,null,{"$f":"+Calcs!X26","v":"-"},null,null,null,{"$f":"Calcs!W26","v":"-"}]
["SU5",62,null,{"$f":"+Calcs!X27","v":"-"},null,null,null,{"$f":"Calcs!W27","v":"-"}]
["SU6",69.5,null,{"$f":"+Calcs!X28","v":"-"},null,null,null,{"$f":"Calcs!W28","v":"-"}]
["SU7",77.5,null,{"$f":"+Calcs!X29","v":"-"},null,null,null,{"$f":"Calcs!W29","v":"-"}]
["Lane-Type I","N/A"]
["Lane Type II","N/A"]
["EV2",57.5,null,{"$f":"+Calcs!X30","v":"-*"},null,null,null,{"$f":"Calcs!W30","v":"-*"}]
["EV3",86,null,{"$f":"+Calcs!X31","v":"-*"},null,null,null,{"$f":"Calcs!W31","v":"-*"}]
["* Informational purposes only"]
[]
["Posting Analysis Summary"]
[null,null,"PV-Single","PV-Comb"]
["Superstructure",null,{"$f":"Calcs!W48","v":" "},{"$f":"Calcs!W55","v":" "}]
["Substructure",null,{"$f":"Calcs!Z48","v":" "},{"$f":"Calcs!Z55","v":" "}]
["Recommended Legal Posting Load",null,null,{"$f":"+Calcs!H39","v":"No Limit"}]
["Recommended EV Posting Load",null,null,{"$f":"Calcs!Q10","v":"No Limit"}]
["As-Design Rating"]
["QC/QA"]
[]
["Rated By:"," "]
["Checked By:"," ",null,null,"Design Project Number:",null," "]
["QA By:"," ",null,null,"Rating Software:"]
["Date Rated:"," "]
[]
["NOTES"]
[" "]
[" "]
[" "]
[" "]

{"sheet":"Calcs","index":1,"n_rows":55,"n_cols":26,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,2,1,7],[23,0,30,0],[31,0,37,0],[1,11,1,13]]}
[]
[null,null,"Posting Sign Table",null,null,null,null,null,null,null,null,"EV Posting Sign Table"]
[null,null,"Group A (min WT)","Group B (min WT)","Group A (min RF)","Group B (min RF)","Sign #","Post Sign",null,null,null,"Min wreight","Max weight","EV posting",null,null,"SUP","SUB","MIN"]
[null,null,0,0,"<1","<1",1,"Closed",null,null,null,null,"<20","CLOSED",null,"EV2",{"$f":"X30","v":"-*"},{"$f":"W30","v":"-*"},{"$f":"IF(Q4=\"-*\",\"-*\",MIN(Q4:R4))","v":"-*"}]
[null,null,">=3",">=3","<1","<1",2,"3",null,null,null,">=20","<30","20 TONS",null,"EV3",{"$f":"X31","v":"-*"},{"$f":"W31","v":"-*"},{"$f":"IF(Q5=\"-*\",\"-*\",MIN(Q5:R5))","v":"-*"}]
[null,null,">=5",">=5","<1","<1",3,"5",null,null,null,">=30","<40","30 TONS"]
[null,null,">=10",">=15","<1","<1",4,"10-15",null,null,null,">=40","<44","40 TONS",null,"Min Ev posted weight",{"$f":"MIN(S4:S5)","v":0}]
[null,null,">=15",">=25","<1","<1",5,"15-25",null,null,null,">=44",null,"NO LIMIT",null,"Rounded down",{"$f":"ROUNDDOWN(Q7,0)","v":0}]
[null,null,">=20",">=35","<1","<1",6,"20-35",null,null,null,null,null,null,null,"just for maco coding",{"$f":"PostingSignC(Q8)","v":"Closed"}]
[null,null,">=25",">=40","<1","<1",7,"25-40",null,null,null,null,null,null,null,"PostingSignC",{"$f":"IF(Q4=\"-*\",\"No Limit\",Q9)","v":"No Limit"}]
[null,null,">=25",null,"<1",">=1",8,"25-44"]
[null,null,">=30",">=40","<1","<1",7,"25-40"]
[null,null,">=30",null,"<1",">=1",9,"30-44"]
[null,null,">=35",">=40","<1","<1",7,"25-40"]
[null,null,">=35",null,"<1",">=1",10,"35-44"]
[null,null,null,">=40",">=1","<1",10,"35-44"]
[null,null,null,null,">=1",">=1",11,"No Limit"]
[]
[]
[]
[]
[]
[null,"Vehicle Type","GVW (kips)","Super RF","Sub RF","Min RF","Post Weight"," Post Sign ","Sign #",null,"WT IF RF<1",null,"Sub WT","Super Wt",null,"Sub WT","Super WT",null,"sub wt","sup wt","sub wt round down","sup wt roudn down","Sub wt","sup wt"]
["Group A","LA Type 3",41,{"$f":"Summary!C27","v":0},{"$f":"Summary!G27","v":0},{"$f":"IF(E24=0,D24,MIN(D24:E24))","v":0},{"$f":"PostingWeight(F24,C24)","v":0},{"$f":"postingsignA(G24,F24,MinRatingB)","v":"Closed"},{"$f":"INDEX($G$4:$G$17,MATCH($H24,$H$4:$H$17,0))","v":1}]
[null,"SU4",54,{"$f":"Summary!C32","v":0},{"$f":"Summary!G32","v":0},{"$f":"IF(E25=0,D25,MIN(D25:E25))","v":0},0,"Closed",{"$f":"INDEX($G$4:$G$17,MATCH($H25,$H$4:$H$17,0))","v":1},null,{"$f":"IF(F24<1,PostingWeight(F24,C24), 40)","v":0},null,{"$f":"INT((IF(E24<0.3,0,IF(AND(E24>=0.3,E24<1),(C24/(2*0.7))*(E24-0.3),IF(E24>=1,(C24/2)*(E24),\"error\")))*100+0.5))/100","v":0},{"$f":"PostingWeight(D24,C24)","v":0},null,{"$f":"IF(M25<99,M25,IF(M25>=99,99))","v":0},{"$f":"IF(N25<99,N25,IF(N25>=99,99))","v":0},null,{"$f":"IF(AND(E24>=1,P25<44),44,P25)","v":0},{"$f":"IF(AND(D24>=1,Q25<44),44,Q25)","v":0},{"$f":"ROUNDDOWN(S25,1)","v":0},{"$f":"ROUNDDOWN(T25,1)","v":0},{"$f":"IF(Summary!G27=\"\",\"-\",U25)","v":"-"},{"$f":"IF(Summary!C27=\"\",\"-\",V25)","v":"-"}]
[null,"SU5",62,{"$f":"Summary!C33","v":0},{"$f":"Summary!G33","v":0},0,0,"Closed",1,null,0,null,0,0,null,0,0,null,{"$f":"IF(AND(E25>=1,P26<44),44,P26)","v":0},0,{"$f":"ROUNDDOWN(S26,1)","v":0},{"$f":"ROUNDDOWN(T26,1)","v":0},{"$f":"IF(Summary!G32=\"\",\"-\",U26)","v":"-"},{"$f":"IF(Summary!C32=\"\",\"-\",V26)","v":"-"}]
[null,"SU6",69.5,{"$f":"Summary!C34","v":0},{"$f":"Summary!G34","v":0},0,0,"Closed",1,null,0,null,0,0,null,0,0,null,0,0,0,0,{"$f":"IF(Summary!G33=\"\",\"-\",U27)","v":"-"},{"$f":"IF(Summary!C33=\"\",\"-\",V27)","v":"-"}]
[null,"SU7",77.5,{"$f":"Summary!C35","v":0},{"$f":"Summary!G35","v":0},0,0,"Closed",1,null,0,null,0,0,null,0,0,null,0,0,0,0,{"$f":"IF(Summary!G34=\"\",\"-\",U28)","v":"-"},{"$f":"IF(Summary!C34=\"\",\"-\",V28)","v":"-"}]
[null,"EV2",57.5,{"$f":"Summary!C38","v":0},{"$f":"Summary!G38","v":0},0,0,"Closed",1,null,0,null,0,0,null,0,0,null,0,0,0,0,{"$f":"IF(Summary!G35=\"\",\"-\",U29)","v":"-"},{"$f":"IF(Summary!C35=\"\",\"-\",V29)","v":"-"}]
[null,"EV3",86,{"$f":"Summary!C39","v":0},{"$f":"Summary!G39","v":0},0,0,"Closed",1,null,0,null,0,0,null,{"$f":"IF(M30<99,M30,IF(M30>=99,99))","v":0},{"$f":"IF(N30<99,N30,IF(N30>=99,99))","v":0},null,0,0,0,0,{"$f":"IF(Summary!G38=\"\",\"-*\",U30)","v":"-*"},{"$f":"IF(Summary!C38=\"\",\"-*\",V30)","v":"-*"}]
[null,{"$f":"IF(F31>=1,INDEX(B24:B28,MATCH(F31,F24:F28,0)),INDEX(B24:B28,MATCH($G$31,$G24:$G28,0)))","v":"LA Type 3"},null,null,null,{"$f":"MIN(F24:F28)","v":0},{"$f":"IF(I31=11,INDEX(G24:G28,MATCH(F31,F24:F28,0)),K32)","v":0},{"$f":"INDEX(H24:H28,MATCH($G$31,$G24:$G28,0))","v":"Closed"},{"$f":"+MIN(I24:I28)","v":1},null,0,null,0,0,null,0,0,null,0,0,0,0,{"$f":"IF(Summary!G39=\"\",\"-*\",U31)","v":"-*"},{"$f":"IF(Summary!C39=\"\",\"-*\",V31)","v":"-*"}]
["Group B","LA Type 3S2",73,{"$f":"Summary!C28","v":0},{"$f":"Summary!G28","v":0},{"$f":"IF(E32=0,D32,MIN(D32:E32))","v":0},{"$f":"PostingWeight(F32,C32)","v":0},{"$f":"postingsignb(G32, F32)","v":"Closed"},{"$f":"INDEX($G$4:$G$17,MATCH($H32,$H$4:$H$17,))","v":1},null,{"$f":"IF(I31=11,0,IF(MAX(K25:K29)=0,0,SMALL(K25:K29,COUNTIF(K25:K29,0)+1)))","v":0}]
[null,"Type 3-3",80,{"$f":"Summary!C29","v":0},{"$f":"Summary!G29","v":0},{"$f":"IF(E33=0,D33,MIN(D33:E33))","v":0},{"$f":"PostingWeight(F33,C33)","v":0},{"$f":"postingsignb(G33, F33)","v":"Closed"},{"$f":"INDEX($G$4:$G$17,MATCH($H33,$H$4:$H$17,))","v":1},null,{"$f":"IF(F32<1,PostingWeight(F32,C32), 44)","v":0},null,{"$f":"INT((IF(E32<0.3,0,IF(AND(E32>=0.3,E32<1),(C32/(2*0.7))*(E32-0.3),IF(E32>=1,(C32/2)*(E32),\"error\")))*100+0.5))/100","v":0},{"$f":"PostingWeight(D32,C32)","v":0},null,{"$f":"IF(M33<99,M33,IF(M33>=99,99))","v":0},{"$f":"IF(N33<99,N33,IF(N33>=99,99))","v":0},null,{"$f":"IF(AND(E32>=1,P33<44),44,P33)","v":0},{"$f":"IF(AND(D32>=1,Q33<44),44,Q33)","v":0},0,0,{"$f":"IF(Summary!G28=\"\",\"-\",U33)","v":"-"},{"$f":"IF(Summary!C28=\"\",\"-\",V33)","v":"-"}]
[null,"LA Type 6",80,{"$f":"Summary!C30","v":0},{"$f":"Summary!G30","v":0},{"$f":"IF(E34=0,D34,MIN(D34:E34))","v":0},{"$f":"PostingWeight(F34,C34)","v":0},"Closed",{"$f":"INDEX($G$4:$G$17,MATCH($H34,$H$4:$H$17,))","v":1},null,{"$f":"IF(F33<1,PostingWeight(F33,C33), 44)","v":0},null,0,0,null,{"$f":"IF(M34<99,M34,IF(M34>=99,99))","v":0},{"$f":"IF(N34<99,N34,IF(N34>=99,99))","v":0},null,0,0,0,0,{"$f":"IF(Summary!G29=\"\",\"-\",U34)","v":"-"},{"$f":"IF(Summary!C29=\"\",\"-\",V34)","v":"-"}]
[null,"LA Type 8",88,{"$f":"Summary!C31","v":0},{"$f":"Summary!G31","v":0},{"$f":"IF(E35=0,D35,MIN(D35:E35))","v":0},{"$f":"PostingWeight(F35,C35)","v":0},"Closed",1,null,{"$f":"IF(F34<1,PostingWeight(F34,C34), 44)","v":0},null,0,0,null,{"$f":"IF(M35<99,M35,IF(M35>=99,99))","v":0},{"$f":"IF(N35<99,N35,IF(N35>=99,99))","v":0},null,0,0,0,0,{"$f":"IF(Summary!G30=\"\",\"-\",U35)","v":"-"},{"$f":"IF(Summary!C30=\"\",\"-\",V35)","v":"-"}]
[null,"EV2",57.5,{"$f":"Summary!C38","v":0},{"$f":"Summary!G38","v":0},{"$f":"IF(E36=0,D36,MIN(D36:E36))","v":0},{"$f":"PostingWeight(F36,C36)","v":0},{"$f":"postingsignb(G36, F36)","v":"Closed"},1,null,{"$f":"IF(F35<1,PostingWeight(F35,C35), 40)","v":0},null,0,0,null,0,{"$f":"IF(N36<99,N36,IF(N36>=99,99))","v":0},null,0,0,0,0,{"$f":"IF(Summary!G31=\"\",\"-\",U36)","v":"-"},{"$f":"IF(Summary!C31=\"\",\"-\",V36)","v":"-"}]
[null,"EV3",86,{"$f":"Summary!C39","v":0},{"$f":"Summary!G39","v":0},0,0,"Closed",1,null,{"$f":"IF(F36<1,PostingWeight(F36,C36), 40)","v":0},null,0,0,null,{"$f":"IF(M37<99,M37,IF(M37>=99,99))","v":0},{"$f":"IF(N37<99,N37,IF(N37>=99,99))","v":0},null,0,0,0,0,{"$f":"IF(Summary!G38=\"\",\"-*\",U37)","v":"-*"},{"$f":"IF(Summary!C38=\"\",\"-*\",V37)","v":"-*"}]
[null,{"$f":"IF(F38>=1,INDEX(B32:B35,MATCH(F38,F32:F35,0)),INDEX(B32:B35,MATCH($G$38,$G32:$G35,0)))","v":"LA Type 3S2"},null,null,null,{"$f":"MIN(F32:F35)","v":0},{"$f":"IF(I38=11,INDEX(G32:G35,MATCH(F38,F32:F35,0)),K39)","v":0},{"$f":"INDEX(H32:H35,MATCH($G$38,$G32:$G35,0))","v":"Closed"},{"$f":"MIN(I32:I35)","v":1},null,{"$f":"IF(F37<1,PostingWeight(F37,C37), 40)","v":0},null,0,0,null,0,0,null,0,0,0,0,{"$f":"IF(Summary!G39=\"\",\"-*\",U38)","v":"-*"},{"$f":"IF(Summary!C39=\"\",\"-*\",V38)","v":"-*"}]
["Critical",{"$f":"IF(F39=\"\",\"\",IF(F39>=1,INDEX(B24:B35,MATCH(F39,F24:F35,0)),INDEX(B24:B35,MATCH($G$39,$G24:$G35,0))))","v":""},null,null,null,{"$f":"IF(MinRatingA+MinRatingB=0,\"\",IF(I39=11,SMALL(F$24:F$35,COUNTIF($F$24:$F$35,0)+1),INDEX(F24:F35,MATCH($G$39,$G24:$G35,0))))","v":""},{"$f":"IF(I31<I38,G31,IF(I31=I38,MIN(MinPostingWeightA,MinPostingWeightB),G38))","v":0},{"$f":"IF(F39=\"\",\"No Limit\",INDEX(H24:H38,MATCH($I$39,$I24:$I38,0)))","v":"No Limit"},{"$f":"MIN(I31,I38)","v":1},null,{"$f":"IF(I38=11,0,IF(MAX(K33:K36)=0,0,SMALL(K33:K36,COUNTIF(K33:K36,0)+1)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INV","OPR",null,"INV","OPR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!C24","v":0},{"$f":"Summary!C25","v":0},null,{"$f":"Summary!G24","v":0},{"$f":"Summary!G25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sup single rf","sup singel wt",null,"sub single rf","sub sing wt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA type 3",{"$f":"D24","v":0},{"$f":"X25","v":"-"},null,{"$f":"E24","v":0},{"$f":"W25","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SU4",{"$f":"D25","v":0},{"$f":"X26","v":"-"},null,{"$f":"E25","v":0},{"$f":"W26","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SU5",{"$f":"D26","v":0},{"$f":"X27","v":"-"},null,{"$f":"E26","v":0},{"$f":"W27","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SU6",{"$f":"D27","v":0},{"$f":"X28","v":"-"},null,{"$f":"E27","v":0},{"$f":"W28","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SU7",{"$f":"D28","v":0},{"$f":"X29","v":"-"},null,{"$f":"E28","v":0},{"$f":"W29","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(U43:U47)","v":0},{"$f":"IF(U48=0,44,MIN(V43:V47))","v":44},{"$f":"IF(U41=0,\" \",ROUNDDOWN(V48,0))","v":" "},{"$f":"MIN(X43:X47)","v":0},{"$f":"IF(X48=0,44,MIN(Y43:Y47))","v":44},{"$f":"IF(X41=0,\" \",ROUNDDOWN(Y48,0))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(V43:V47)","v":0},{"$f":"ROUNDDOWN(W48,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sup combo rf","sup combo wt",null,"sub combo rf","sub combo wt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA Type 3S2",{"$f":"D32","v":0},{"$f":"X33","v":"-"},null,{"$f":"E32","v":0},{"$f":"W33","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 3-3",{"$f":"D33","v":0},{"$f":"X34","v":"-"},null,{"$f":"E33","v":0},{"$f":"W34","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA Type 6",{"$f":"D34","v":0},{"$f":"X35","v":"-"},null,{"$f":"E34","v":0},{"$f":"W35","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA Type 8",{"$f":"D35","v":0},{"$f":"X36","v":"-"},null,{"$f":"E35","v":0},{"$f":"W36","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(U51:U54)","v":0},{"$f":"IF(U55=0,44,MIN(V51:V54))","v":44},{"$f":"IF(U41=0,\" \",ROUNDDOWN(V55,0))","v":" "},{"$f":"MIN(X51:X54)","v":0},{"$f":"IF(X55=0,44,MIN(Y51:Y54))","v":44},{"$f":"IF(X41=0,\" \",ROUNDDOWN(Y55,0))","v":" "}]

{"sheet":"List","index":2,"n_rows":66,"n_cols":3,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Disticts","Districts","Parish"]
["02-Bridge City","02-Bridge City","26-Jefferson"]
["03-Lafayette","02-Bridge City","29-Lafourche"]
["04-Bossier City","02-Bridge City","36-Orleans"]
["05-Monroe","02-Bridge City","38-Plaquemines"]
["07-Lake Charles","02-Bridge City","44-St. Bernard"]
["08-Alexandria","02-Bridge City","45-St. Charles"]
["58-Chase","02-Bridge City","55-Terrebonne"]
["61-Baton Rouge","03-Lafayette","01-Acadia"]
["62-Hammond","03-Lafayette","20-Evangeline"]
[null,"03-Lafayette","23-Iberia"]
[null,"03-Lafayette","28-Lafayette"]
[null,"03-Lafayette","49-St. Landry"]
[null,"03-Lafayette","50-St. Martin"]
[null,"03-Lafayette","51-St. Mary"]
[null,"03-Lafayette","57-Vermilion"]
[null,"04-Bossier City","07-Bienville"]
[null,"04-Bossier City","08-Bossier"]
[null,"04-Bossier City","09-Caddo"]
[null,"04-Bossier City","14-Claiborne"]
[null,"04-Bossier City","16-DeSoto"]
[null,"04-Bossier City","41-Red River"]
[null,"04-Bossier City","60-Webster"]
[null,"05-Monroe","18-E. Carroll"]
[null,"05-Monroe","25-Jackson"]
[null,"05-Monroe","31-Lincoln"]
[null,"05-Monroe","33-Madison"]
[null,"05-Monroe","34-Morehouse"]
[null,"05-Monroe","37-Ouachita"]
[null,"05-Monroe","42-Richland"]
[null,"05-Monroe","56-Union"]
[null,"05-Monroe","62-W. Carroll"]
[null,"07-Lake Charles","02-Allen"]
[null,"07-Lake Charles","06-Beauregard"]
[null,"07-Lake Charles","10-Calcasieu"]
[null,"07-Lake Charles","12-Cameron"]
[null,"07-Lake Charles","27-Jefferson Davis"]
[null,"08-Alexandria","05-Avoyelles"]
[null,"08-Alexandria","22-Grant"]
[null,"08-Alexandria","35-Natchitoches"]
[null,"08-Alexandria","40-Rapides"]
[null,"08-Alexandria","43-Sabine"]
[null,"08-Alexandria","58-Vernon"]
[null,"08-Alexandria","64-Winn"]
[null,"58-Chase","11-Caldwell"]
[null,"58-Chase","13-Catahoula"]
[null,"58-Chase","15-Concordia"]
[null,"58-Chase","21-Franklin"]
[null,"58-Chase","30-LaSalle"]
[null,"58-Chase","54-Tensas"]
[null,"61-Baton Rouge","03-Ascension"]
[null,"61-Baton Rouge","04-Assumption"]
[null,"61-Baton Rouge","17-E. Baton Rouge"]
[null,"61-Baton Rouge","19-E. Feliciana"]
[null,"61-Baton Rouge","24-Iberville"]
[null,"61-Baton Rouge","39-Pointe Coupee"]
[null,"61-Baton Rouge","47-St. James"]
[null,"61-Baton Rouge","50-St. Martin"]
[null,"61-Baton Rouge","61-W. Baton Rouge"]
[null,"61-Baton Rouge","63-W. Feliciana"]
[null,"62-Hammond","32-Livingston"]
[null,"62-Hammond","46-St. Helena"]
[null,"62-Hammond","48-St. John the Baptist"]
[null,"62-Hammond","52-St. Tammany"]
[null,"62-Hammond","53-Tangipahoa"]
[null,"62-Hammond","59-Washington"]

{"sheet":"updates","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Verison","Notes"]
["2018-09-04","Changed cover sheet to show inspectech input data. If greated then 1 but less then 44 show 44. Also added dropped down for parish and district"]
["2019-07-22","Added emergency vehicle and updated the calcs sheet for posting weight of those vehicle."]
["2022-05-31","Added EV posting sign"]
["2022-11-21","Fixed EV posting sign to show closed when vaule is less then 0.30"]