{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Conversion","Reinf. Schedules","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":"Conversion","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Equivalent WWR & Combinations for Grade 60 Rebar Schedules",null,null,null,null,null,null,"(Version 4 - 1/1/13)"]
[]
[null,"Conversion based on the requirements on Index 200 & 201"]
[null,"   - Equivalent Area for Strength"]
[null,"   - Equivalent Spacing for Increased Service Stress"]
[]
[null,"Original Reinf. Steel Area = ",null,null,0.2,"in^2/ft","(Grade 60)"]
[null,"Yield Strength of Reinforcing =",null,null,60,"ksi"]
[null,"Minimum Bar Spacing =",null,null,6,"in."]
[]
["1.0  ","Basic WWR Configurations:"]
[]
[null,"DWWR Equiv. Area (Gr. 70) =",null,null,{"$f":"+E7*Fyo/70","v":0.17142857142857143},"in^2/ft",null,"Equiv. Min. Wire Sp. =",{"$f":"+E9*(Fyo/70)^2","v":4.408163265306122},"in."]
[null,"SWWR Equiv. Area (Gr. 65) =",null,null,{"$f":"+E7*Fyo/65","v":0.18461538461538463},"in^2/ft",null,"Equiv. Min. Wire Sp. =",{"$f":"+E9*(Fyo/65)^2","v":5.1124260355029598},"in."]
[]
[]
["2.0  ","Combination WWR & Supplemental Deformed Bars:"]
[]
[null,"Base WWR Grade =",null,null,65,"ksi","(D=70 ksi; W=65 ksi)"]
[null,"Base WWR Wire Size =",null,null,0,"100* in^2"]
[null,"Base WWR Wire Spacing =",null,null,3,"in."]
[null,null,"Gross Area =",null,{"$f":"+E20/100*12/E21","v":0},"in^2/ft"]
[]
[null,"Supplemental Bar Grade =",null,null,60,"ksi","(ASTM A 416 - Grade 60)"]
[null,"Supplemental Bar Area =",null,null,0.2,"in^2","(#3 = 0.11; #4 = 0.20; #5 = 0.31)"]
[null,"Supplemental Bar Spacing =",null,null,10,"in.","(Not greater than 2 x Minimum Design Bar Spacing)"]
[null,null,"Gross Area =",null,{"$f":"+E25*12/E26","v":0.24000000000000005},"in^2/ft"]
[]
[null,"Total Gross Area =",null,null,{"$f":"+E22+E27","v":0.24000000000000005},"in^2/ft"]
[null,"Total Equivalent Area =",null,null,{"$f":"+E22*E19/Fyo+E27*E24/Fyo","v":0.24000000000000005},"in^2/ft",{"$f":"+IF(E30<E7,\"NO GOOD (Stress)\", \"OK (Stress)\")","v":"OK (Stress)"}]
[null,"Equivalent Stress Ratio =",null,null,{"$f":"+E7/E29","v":0.83333333333333326},null,"(Design/Provided)"]
[]
[null,"Average Bar/Wire Sp. =",null,null,{"$f":"+E22/E29*E21+E27/E29*E26","v":10},"in"]
[null,"Equivalent Bar Spacing Req'd =",null,null,{"$f":"+E9/(E31)^2","v":8.6400000000000023},"in",{"$f":"+IF(E33>E34,\"NO GOOD (Spacing)\", \"OK (Spacing)\")","v":"NO GOOD (Spacing)"}]
[]
[null,null,"Summary Check =",null,{"$f":"+IF(E30<E7,\"NO GOOD\",+IF(E33>E34,\"NO GOOD\",\"OK\"))","v":"NO GOOD"}]

{"sheet":"Reinf. Schedules","index":1,"n_rows":53,"n_cols":31,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"DESIGN INDEX NO. 201 REINFORCING SCHEDULE"]
[]
[null,"NEW","AREA","BAR",null," SCHEDULE"," SCHEDULE","GRADE ",null,60,"KSI BAR",null,null,null,"GRADE ",null,40,"KSI BAR",null,null,null,"GRADE ",null,65,"KSI WWF"]
[null,"SCHEDULE","(in^2/ft)","DIA. (in.)"]
[null,"A",0.2,0.5,null,"OLD","NEW","BAR SIZE &",null,null,"SPACING",null,"AREA",null,"BAR SIZE &",null,null,"SPACING",null,"MIN.AREA",null,null,null,"SPACING",null,"STYLE DESIGNATION",null,null,null,null,"MIN. AREA"]
[null,"B",0.24,0.5,null,"(2004)",-2006,null,null,null,"(in)",null,"(in^2)",null,null,null,null,"(in)",null,"(in^2)",null,null,null,"(in)",null,"(WIRE SIZE)",null,null,null,null,"(in^2)"]
[null,"C",0.37,0.5]
[null,"D",0.53,0.625,null,{"$f":"VLOOKUP(M9,OLDSCHTABLE,2,0)","v":"A"},"A","#",3,"@",{"$f":"VLOOKUP(I9,BARtable,2)/M9*12","v":6.6},"Ctrs.",{"$f":"+VLOOKUP(G9,SCHEDULETABLE,2,0)","v":0.2},null,"#",{"$f":"+I9","v":3},"@",{"$f":"VLOOKUP(P9,BARtable,2)/T9*12","v":4.4000000000000004},"Ctrs.",{"$f":"+M9/$Q$4*60","v":0.3},null,{"$f":"+X9","v":3},"X",3,"-","W",{"$f":"+X9*AE9/12*100","v":4.6153846153846159},"X","W",{"$f":"+AA9","v":4.6153846153846159},{"$f":"+M9/$X$4*60","v":0.18461538461538463}]
[null,"E",0.73,0.625,null,null,null,"#",{"$f":"+I9+1","v":4},"@",{"$f":"VLOOKUP(I10,BARtable,2)/M10*12","v":12},"Ctrs",{"$f":"+M9","v":0.2},null,"#",{"$f":"+P9+1","v":4},"@",{"$f":"VLOOKUP(P10,BARtable,2)/T10*12","v":8},"Ctrs",{"$f":"+M10/$Q$4*60","v":0.3},null,{"$f":"+X10","v":4},"X",4,"-","W",{"$f":"+X10*AE10/12*100","v":6.1538461538461542},"X","W",{"$f":"+AA10","v":6.1538461538461542},{"$f":"+M10/$X$4*60","v":0.18461538461538463}]
[null,"F",1.06,0.75,null,null,null,"#",{"$f":"+I10+1","v":5},"@",{"$f":"VLOOKUP(I11,BARtable,2)/M11*12","v":18.599999999999998},"Ctrs",{"$f":"+M10","v":0.2},null,"#",{"$f":"+P10+1","v":5},"@",{"$f":"VLOOKUP(P11,BARtable,2)/T11*12","v":12.400000000000002},"Ctrs",{"$f":"+M11/$Q$4*60","v":0.3},null,{"$f":"+X11","v":6},"X",6,"-","W",{"$f":"+X11*AE11/12*100","v":9.2307692307692317},"X","W",{"$f":"+AA11","v":9.2307692307692317},{"$f":"+M11/$X$4*60","v":0.18461538461538463}]
[null,"G",1.46,0.875,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"H",1.75,0.875,null,{"$f":"VLOOKUP(M13,OLDSCHTABLE,2,0)","v":"B"},"B","#",3,"@",{"$f":"VLOOKUP(I13,BARtable,2)/M13*12","v":5.5},"Ctrs.",{"$f":"+VLOOKUP(G13,SCHEDULETABLE,2,0)","v":0.24},null,"#",{"$f":"+I13","v":3},"@",{"$f":"VLOOKUP(P13,BARtable,2)/T13*12","v":3.666666666666667},"Ctrs.",{"$f":"+M13/$Q$4*60","v":0.36},null,{"$f":"+X13","v":3},"X",3,"-","W",{"$f":"+X13*AE13/12*100","v":5.5384615384615383},"X","W",{"$f":"+AA13","v":5.5384615384615383},{"$f":"+M13/$X$4*60","v":0.22153846153846155}]
[null,"S1",0.26700000000000002,0.5,null,null,null,"#",{"$f":"+I13+1","v":4},"@",{"$f":"VLOOKUP(I14,BARtable,2)/M14*12","v":10},"Ctrs",{"$f":"+M13","v":0.24},null,"#",{"$f":"+P13+1","v":4},"@",{"$f":"VLOOKUP(P14,BARtable,2)/T14*12","v":6.666666666666667},"Ctrs",{"$f":"+M14/$Q$4*60","v":0.36},null,{"$f":"+X14","v":4},"X",4,"-","W",{"$f":"+X14*AE14/12*100","v":7.384615384615385},"X","W",{"$f":"+AA14","v":7.384615384615385},{"$f":"+M14/$X$4*60","v":0.22153846153846155}]
[null,"S2",1.24,0.875,null,null,null,"#",{"$f":"+I14+1","v":5},"@",{"$f":"VLOOKUP(I15,BARtable,2)/M15*12","v":15.5},"Ctrs",{"$f":"+M14","v":0.24},null,"#",{"$f":"+P14+1","v":5},"@",{"$f":"VLOOKUP(P15,BARtable,2)/T15*12","v":10.333333333333334},"Ctrs",{"$f":"+M15/$Q$4*60","v":0.36},null,{"$f":"+X15","v":6},"X",6,"-","W",{"$f":"+X15*AE15/12*100","v":11.076923076923077},"X","W",{"$f":"+AA15","v":11.076923076923077},{"$f":"+M15/$X$4*60","v":0.22153846153846155}]
[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":"VLOOKUP(M17,OLDSCHTABLE,2,0)","v":{"$error":"#N/A"}},"S1","#",3,"@",{"$f":"VLOOKUP(I17,BARtable,2)/M17*12","v":4.9438202247191008},"Ctrs.",{"$f":"+VLOOKUP(G17,SCHEDULETABLE,2,0)","v":0.26700000000000002},null,"#",{"$f":"+I17","v":3},"@",{"$f":"VLOOKUP(P17,BARtable,2)/T17*12","v":3.2958801498127341},"Ctrs.",{"$f":"+M17/$Q$4*60","v":0.40050000000000002},null,{"$f":"+X17","v":3},"X",3,"-","W",{"$f":"+X17*AE17/12*100","v":6.1615384615384619},"X","W",{"$f":"+AA17","v":6.1615384615384619},{"$f":"+M17/$X$4*60","v":0.24646153846153848}]
[null,null,null,null,null,null,null,"#",{"$f":"+I17+1","v":4},"@",{"$f":"VLOOKUP(I18,BARtable,2)/M18*12","v":8.9887640449438209},"Ctrs",{"$f":"+M17","v":0.26700000000000002},null,"#",{"$f":"+P17+1","v":4},"@",{"$f":"VLOOKUP(P18,BARtable,2)/T18*12","v":5.9925093632958806},"Ctrs",{"$f":"+M18/$Q$4*60","v":0.40050000000000002},null,{"$f":"+X18","v":4},"X",4,"-","W",{"$f":"+X18*AE18/12*100","v":8.2153846153846164},"X","W",{"$f":"+AA18","v":8.2153846153846164},{"$f":"+M18/$X$4*60","v":0.24646153846153848}]
[null,"BAR #","AREA",null,null,null,null,"#",{"$f":"+I18+1","v":5},"@",{"$f":"VLOOKUP(I19,BARtable,2)/M19*12","v":13.932584269662922},"Ctrs",{"$f":"+M18","v":0.26700000000000002},null,"#",{"$f":"+P18+1","v":5},"@",{"$f":"VLOOKUP(P19,BARtable,2)/T19*12","v":9.2883895131086138},"Ctrs",{"$f":"+M19/$Q$4*60","v":0.40050000000000002},null,{"$f":"+X19","v":6},"X",6,"-","W",{"$f":"+X19*AE19/12*100","v":12.323076923076924},"X","W",{"$f":"+AA19","v":12.323076923076924},{"$f":"+M19/$X$4*60","v":0.24646153846153848}]
[null,3,0.11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,4,0.2,null,null,{"$f":"VLOOKUP(M21,OLDSCHTABLE,2,0)","v":"C"},"C","#",3,"@",{"$f":"VLOOKUP(I21,BARtable,2)/M21*12","v":3.5675675675675675},"Ctrs.",{"$f":"+VLOOKUP(G21,SCHEDULETABLE,2,0)","v":0.37},null,"#",{"$f":"+I21","v":3},"@",{"$f":"VLOOKUP(P21,BARtable,2)/T21*12","v":2.378378378378379},"Ctrs.",{"$f":"+M21/$Q$4*60","v":0.55499999999999994},null,{"$f":"+X21","v":3},"X",3,"-","W",{"$f":"+X21*AE21/12*100","v":8.5384615384615383},"X","W",{"$f":"+AA21","v":8.5384615384615383},{"$f":"+M21/$X$4*60","v":0.34153846153846151}]
[null,5,0.31,null,null,null,null,"#",{"$f":"+I21+1","v":4},"@",{"$f":"VLOOKUP(I22,BARtable,2)/M22*12","v":6.4864864864864868},"Ctrs",{"$f":"+M21","v":0.37},null,"#",{"$f":"+P21+1","v":4},"@",{"$f":"VLOOKUP(P22,BARtable,2)/T22*12","v":4.3243243243243246},"Ctrs",{"$f":"+M22/$Q$4*60","v":0.55499999999999994},null,{"$f":"+X22","v":4},"X",4,"-","W",{"$f":"+X22*AE22/12*100","v":11.384615384615383},"X","W",{"$f":"+AA22","v":11.384615384615383},{"$f":"+M22/$X$4*60","v":0.34153846153846151}]
[null,6,0.44,null,null,null,null,"#",{"$f":"+I22+1","v":5},"@",{"$f":"VLOOKUP(I23,BARtable,2)/M23*12","v":10.054054054054054},"Ctrs",{"$f":"+M22","v":0.37},null,"#",{"$f":"+P22+1","v":5},"@",{"$f":"VLOOKUP(P23,BARtable,2)/T23*12","v":6.7027027027027035},"Ctrs",{"$f":"+M23/$Q$4*60","v":0.55499999999999994},null,{"$f":"+X23","v":6},"X",6,"-","W",{"$f":"+X23*AE23/12*100","v":17.076923076923077},"X","W",{"$f":"+AA23","v":17.076923076923077},{"$f":"+M23/$X$4*60","v":0.34153846153846151}]
[null,7,0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,8,0.79,null,null,{"$f":"VLOOKUP(M25,OLDSCHTABLE,2,0)","v":"D"},"D","#",4,"@",{"$f":"VLOOKUP(I25,BARtable,2)/M25*12","v":4.5283018867924536},"Ctrs.",{"$f":"+VLOOKUP(G25,SCHEDULETABLE,2,0)","v":0.53},null,"#",{"$f":"+I25","v":4},"@",{"$f":"VLOOKUP(P25,BARtable,2)/T25*12","v":3.0188679245283021},"Ctrs.",{"$f":"+M25/$Q$4*60","v":0.79500000000000004},null,{"$f":"+X25","v":3},"X",3,"-","W",{"$f":"+X25*AE25/12*100","v":12.23076923076923},"X","W",{"$f":"+AA25","v":12.23076923076923},{"$f":"+M25/$X$4*60","v":0.48923076923076925}]
[null,9,1,null,null,null,null,"#",{"$f":"+I25+1","v":5},"@",{"$f":"VLOOKUP(I26,BARtable,2)/M26*12","v":7.0188679245283012},"Ctrs",{"$f":"+M25","v":0.53},null,"#",{"$f":"+P25+1","v":5},"@",{"$f":"VLOOKUP(P26,BARtable,2)/T26*12","v":4.6792452830188678},"Ctrs",{"$f":"+M26/$Q$4*60","v":0.79500000000000004},null,{"$f":"+X26","v":4},"X",4,"-","W",{"$f":"+X26*AE26/12*100","v":16.30769230769231},"X","W",{"$f":"+AA26","v":16.30769230769231},{"$f":"+M26/$X$4*60","v":0.48923076923076925}]
[null,10,1.27,null,null,null,null,"#",{"$f":"+I26+1","v":6},"@",{"$f":"VLOOKUP(I27,BARtable,2)/M27*12","v":9.9622641509433958},"Ctrs",{"$f":"+M26","v":0.53},null,"#",{"$f":"+P26+1","v":6},"@",{"$f":"VLOOKUP(P27,BARtable,2)/T27*12","v":6.6415094339622645},"Ctrs",{"$f":"+M27/$Q$4*60","v":0.79500000000000004},null,{"$f":"+X27","v":6},"X",6,"-","W",{"$f":"+X27*AE27/12*100","v":24.46153846153846},"X","W",{"$f":"+AA27","v":24.46153846153846},{"$f":"+M27/$X$4*60","v":0.48923076923076925}]
[null,11,1.56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,14,2.25,null,null,{"$f":"VLOOKUP(#REF!,OLDSCHTABLE,2,0)","v":{"$error":"#REF!"}},"E","#",4,"@",{"$f":"VLOOKUP(I29,BARtable,2)/M29*12","v":3.287671232876713},"Ctrs.",{"$f":"+VLOOKUP(G29,SCHEDULETABLE,2,0)","v":0.73},null,"#",5,"@",{"$f":"VLOOKUP(P29,BARtable,2)/T29*12","v":3.3972602739726026},"Ctrs.",{"$f":"+M29/$Q$4*60","v":1.095},null,{"$f":"+X29","v":3},"X",3,"-","W",{"$f":"+X29*AE29/12*100","v":16.846153846153843},"X","W",{"$f":"+AA29","v":16.846153846153843},{"$f":"+M29/$X$4*60","v":0.67384615384615376}]
[null,null,null,null,null,null,null,"#",{"$f":"+I29+1","v":5},"@",{"$f":"VLOOKUP(I30,BARtable,2)/M30*12","v":5.0958904109589049},"Ctrs",{"$f":"+M29","v":0.73},null,"#",{"$f":"+P29+1","v":6},"@",{"$f":"VLOOKUP(P30,BARtable,2)/T30*12","v":4.8219178082191787},"Ctrs",{"$f":"+M30/$Q$4*60","v":1.095},null,{"$f":"+X30","v":4},"X",4,"-","W",{"$f":"+X30*AE30/12*100","v":22.461538461538456},"X","W",{"$f":"+AA30","v":22.461538461538456},{"$f":"+M30/$X$4*60","v":0.67384615384615376}]
[null,null,null,null,null,null,null,"#",{"$f":"+I30+1","v":6},"@",{"$f":"VLOOKUP(I31,BARtable,2)/M31*12","v":7.2328767123287667},"Ctrs",{"$f":"+M30","v":0.73},null,"#",{"$f":"+P30+1","v":7},"@",{"$f":"VLOOKUP(P31,BARtable,2)/T31*12","v":6.5753424657534243},"Ctrs",{"$f":"+M31/$Q$4*60","v":1.095},null,{"$f":"+X31","v":6},"X",6,"-","W",{"$f":"+X31*AE31/12*100","v":33.692307692307686},"X","W",{"$f":"+AA31","v":33.692307692307686},{"$f":"+M31/$X$4*60","v":0.67384615384615376}]
[null,null,"OLD (2204)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"AREA","SCHEDULE",null,null,{"$f":"VLOOKUP(M29,OLDSCHTABLE,2,0)","v":"E"},"F","#",5,"@",{"$f":"VLOOKUP(I33,BARtable,2)/M33*12","v":3.5094339622641506},"Ctrs.",{"$f":"+VLOOKUP(G33,SCHEDULETABLE,2,0)","v":1.06},null,"#",6,"@",{"$f":"VLOOKUP(P33,BARtable,2)/T33*12","v":3.3207547169811322},"Ctrs.",{"$f":"+M33/$Q$4*60","v":1.59},null,{"$f":"+X33","v":3},"X",3,"-","W",{"$f":"+X33*AE33/12*100","v":24.46153846153846},"X","W",{"$f":"+AA33","v":24.46153846153846},{"$f":"+M33/$X$4*60","v":0.97846153846153849}]
[null,0.2,"A",null,null,null,null,"#",{"$f":"+I33+1","v":6},"@",{"$f":"VLOOKUP(I34,BARtable,2)/M34*12","v":4.9811320754716979},"Ctrs",{"$f":"+M33","v":1.06},null,"#",{"$f":"+P33+1","v":7},"@",{"$f":"VLOOKUP(P34,BARtable,2)/T34*12","v":4.5283018867924527},"Ctrs",{"$f":"+M34/$Q$4*60","v":1.59},null,{"$f":"+X34","v":4},"X",4,"-","W",{"$f":"+X34*AE34/12*100","v":32.61538461538462},"X","W",{"$f":"+AA34","v":32.61538461538462},{"$f":"+M34/$X$4*60","v":0.97846153846153849}]
[null,0.24,"B",null,null,null,null,"#",{"$f":"+I34+1","v":7},"@",{"$f":"VLOOKUP(I35,BARtable,2)/M35*12","v":6.7924528301886795},"Ctrs",{"$f":"+M34","v":1.06},null,"#",{"$f":"+P34+1","v":8},"@",{"$f":"VLOOKUP(P35,BARtable,2)/T35*12","v":5.9622641509433958},"Ctrs",{"$f":"+M35/$Q$4*60","v":1.59},null,{"$f":"+X35","v":6},"X",6,"-","W",{"$f":"+X35*AE35/12*100","v":48.92307692307692},"X","W",{"$f":"+AA35","v":48.92307692307692},{"$f":"+M35/$X$4*60","v":0.97846153846153849}]
[null,0.37,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,0.53,"D",null,null,{"$f":"VLOOKUP(#REF!,OLDSCHTABLE,2,0)","v":{"$error":"#REF!"}},"S2","#",5,"@",{"$f":"VLOOKUP(I37,BARtable,2)/M37*12","v":3},"Ctrs.",{"$f":"+VLOOKUP(G37,SCHEDULETABLE,2,0)","v":1.24},null,"#",7,"@",{"$f":"VLOOKUP(P37,BARtable,2)/T37*12","v":3.870967741935484},"Ctrs.",{"$f":"+M37/$Q$4*60","v":1.8599999999999999},null,{"$f":"+X37","v":3},"X",3,"-","W",{"$f":"+X37*AE37/12*100","v":28.615384615384613},"X","W",{"$f":"+AA37","v":28.615384615384613},{"$f":"+M37/$X$4*60","v":1.1446153846153846}]
[null,0.73,"E",null,null,null,null,"#",{"$f":"+I37+1","v":6},"@",{"$f":"VLOOKUP(I38,BARtable,2)/M38*12","v":4.258064516129032},"Ctrs",{"$f":"+M37","v":1.24},null,"#",{"$f":"+P37+1","v":8},"@",{"$f":"VLOOKUP(P38,BARtable,2)/T38*12","v":5.0967741935483879},"Ctrs",{"$f":"+M38/$Q$4*60","v":1.8599999999999999},null,{"$f":"+X38","v":4},"X",4,"-","W",{"$f":"+X38*AE38/12*100","v":38.153846153846153},"X","W",{"$f":"+AA38","v":38.153846153846153},{"$f":"+M38/$X$4*60","v":1.1446153846153846}]
[null,1.06,"F",null,null,null,null,"#",{"$f":"+I38+1","v":7},"@",{"$f":"VLOOKUP(I39,BARtable,2)/M39*12","v":5.8064516129032251},"Ctrs",{"$f":"+M38","v":1.24},null,"#",{"$f":"+P38+1","v":9},"@",{"$f":"VLOOKUP(P39,BARtable,2)/T39*12","v":6.4516129032258078},"Ctrs",{"$f":"+M39/$Q$4*60","v":1.8599999999999999},null,{"$f":"+X39","v":6},"X",6,"-","W",{"$f":"+X39*AE39/12*100","v":57.230769230769226},"X","W",{"$f":"+AA39","v":57.230769230769226},{"$f":"+M39/$X$4*60","v":1.1446153846153846}]
[null,1.46,"G",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":"VLOOKUP(M33,OLDSCHTABLE,2,0)","v":"F"},"G","#",6,"@",{"$f":"VLOOKUP(I41,BARtable,2)/M41*12","v":3.6164383561643834},"Ctrs.",{"$f":"+VLOOKUP(G41,SCHEDULETABLE,2,0)","v":1.46},null,"#",7,"@",{"$f":"VLOOKUP(P41,BARtable,2)/T41*12","v":3.2876712328767121},"Ctrs.",{"$f":"+M41/$Q$4*60","v":2.19},null,{"$f":"+X41","v":3},"X",3,"-","W",{"$f":"+X41*AE41/12*100","v":33.692307692307686},"X","W",{"$f":"+AA41","v":33.692307692307686},{"$f":"+M41/$X$4*60","v":1.3476923076923075}]
[null,null,null,null,null,null,null,"#",{"$f":"+I41+1","v":7},"@",{"$f":"VLOOKUP(I42,BARtable,2)/M42*12","v":4.9315068493150687},"Ctrs",{"$f":"+M41","v":1.46},null,"#",{"$f":"+P41+1","v":8},"@",{"$f":"VLOOKUP(P42,BARtable,2)/T42*12","v":4.3287671232876717},"Ctrs",{"$f":"+M42/$Q$4*60","v":2.19},null,{"$f":"+X42","v":4},"X",4,"-","W",{"$f":"+X42*AE42/12*100","v":44.923076923076913},"X","W",{"$f":"+AA42","v":44.923076923076913},{"$f":"+M42/$X$4*60","v":1.3476923076923075}]
[null,null,null,null,null,null,null,"#",{"$f":"+I42+1","v":8},"@",{"$f":"VLOOKUP(I43,BARtable,2)/M43*12","v":6.493150684931507},"Ctrs",{"$f":"+M42","v":1.46},null,"#",{"$f":"+P42+1","v":9},"@",{"$f":"VLOOKUP(P43,BARtable,2)/T43*12","v":5.4794520547945211},"Ctrs",{"$f":"+M43/$Q$4*60","v":2.19},null,{"$f":"+X43","v":6},"X",6,"-","W",{"$f":"+X43*AE43/12*100","v":67.384615384615373},"X","W",{"$f":"+AA43","v":67.384615384615373},{"$f":"+M43/$X$4*60","v":1.3476923076923075}]
[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":"VLOOKUP(M37,OLDSCHTABLE,2,0)","v":{"$error":"#N/A"}},"H","#",7,"@",{"$f":"VLOOKUP(I45,BARtable,2)/M45*12","v":4.1142857142857139},"Ctrs.",{"$f":"+VLOOKUP(G45,SCHEDULETABLE,2,0)","v":1.75},null,"#",{"$f":"+I45","v":7},"@",{"$f":"VLOOKUP(P45,BARtable,2)/T45*12","v":2.7428571428571429},"Ctrs.",{"$f":"+M45/$Q$4*60","v":2.625},null,{"$f":"+X45","v":3},"X",3,"-","W",{"$f":"+X45*AE45/12*100","v":40.384615384615394},"X","W",{"$f":"+AA45","v":40.384615384615394},{"$f":"+M45/$X$4*60","v":1.6153846153846154}]
[null,null,null,null,null,null,null,"#",{"$f":"+I45+1","v":8},"@",{"$f":"VLOOKUP(I46,BARtable,2)/M46*12","v":5.4171428571428573},"Ctrs",{"$f":"+M45","v":1.75},null,"#",{"$f":"+P45+1","v":8},"@",{"$f":"VLOOKUP(P46,BARtable,2)/T46*12","v":3.6114285714285717},"Ctrs",{"$f":"+M46/$Q$4*60","v":2.625},null,{"$f":"+X46","v":4},"X",4,"-","W",{"$f":"+X46*AE46/12*100","v":53.846153846153847},"X","W",{"$f":"+AA46","v":53.846153846153847},{"$f":"+M46/$X$4*60","v":1.6153846153846154}]
[null,null,null,null,null,null,null,"#",{"$f":"+I46+1","v":9},"@",{"$f":"VLOOKUP(I47,BARtable,2)/M47*12","v":6.8571428571428568},"Ctrs",{"$f":"+M46","v":1.75},null,"#",{"$f":"+P46+1","v":9},"@",{"$f":"VLOOKUP(P47,BARtable,2)/T47*12","v":4.5714285714285712},"Ctrs",{"$f":"+M47/$Q$4*60","v":2.625},null,{"$f":"+X47","v":6},"X",6,"-","W",{"$f":"+X47*AE47/12*100","v":80.769230769230788},"X","W",{"$f":"+AA47","v":80.769230769230788},{"$f":"+M47/$X$4*60","v":1.6153846153846154}]
[]
[null,null,null,null,null,{"$f":"VLOOKUP(M41,OLDSCHTABLE,2,0)","v":"G"}]
[]
[]
[]
[null,null,null,null,null,{"$f":"VLOOKUP(M45,OLDSCHTABLE,2,0)","v":{"$error":"#N/A"}}]

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