{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["MASTER","TBR_BCR_0","BCR_S_TBR_1","BCR_B_TBR_1","BCR_T_TBR_1","BCRTBR_S_BCR","BCRTBR_S_TBR","BCRTBR_B_BCR","BCRTBR_B_TBR","BCRTBR_T_BCR","BCRTBR_T_TBR"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"comments":2,"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":"MASTER","index":0,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[26,1,26,4],[1,1,1,2],[2,1,2,2],[13,1,13,2],[21,1,21,4]]}
[]
[null,"INPUT"]
[null,"PAVEMENT SECTION PARAMETERS"]
[null,"AC Thickness, D1 (mm)",75]
[null,"AC Structural Layer Coefficient, a1",0.4]
[null,"Base Thickness, D2 (mm)",300]
[null,"Base Strucural Layer Coefficient, a2",0.14000000000000001]
[null,"Base Layer Drainage Coefficient, m2",1]
[null,"Subbase Thickness, D3 (mm)",0]
[null,"Subbase Structural Layer Coefficient, a3",0.1]
[null,"Subbase Layer Drainage Coefficient, m3",1]
[null,"Subgrade CBR",1.5]
[]
[null,"GEOSYNTHETIC PROPERTIES"]
[null,"Geosynthetic Modulus, GSM-2% (kN/m)",425]
[null,"Geosynthetic Modulus Ratio, GMR",0.59499999999999997]
[null,"Reduction Factor for Interface Shear",1]
[]
[]
[]
[]
[null,"DESIRED REINFORCEMENT BENEFIT"]
[null,null,"Subgrade","Base","Total"]
[null,"Desired TBR",1,1,2]
[null,"Desired BCR",0,0,23]
[]
[null,"OUTPUT"]
[null,null,"Subgrade","Base","Total"]
[null,"TBRBCR=0",2.5385916219812885,1.7110729637803475,4.3437154904514825]
[null,"BCRTBR=1",21.519326052853891,13.315556142649163,30.988588470210015]
[null,"Desired TBR",1,1,2]
[null,"Remaining BCR",21.51457984066754,13.310313797711103,17.149105727150573]
[null,"Desired BCR",0,0,23]
[null,"Remaining TBR",2.538808406856762,1.7111893928042039,1.5048112192033547]
[null,"MR-R/U ",1.4261596313805867,1.2200195795684665,1.7884214888851091]

{"sheet":"TBR_BCR_0","index":1,"n_rows":15,"n_cols":36,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["AC","Base ","CBR","Modulus","Anisotropy","RF_S_Nu","RF_B_Nu","RF_S_G","RF_B_G","RF_Contact","SN","y1","y1","y2","m1","yo_1","SN at TBR=1","m2","yo_2","TBR_S","TBR_S","TBR_S","TBR_S_M","TBR_S_AR","TBR_S_Nu","TBR_S_G","TBR__S_Contact","TBR__S","TBR_B","TBR_B_M","TBR_B_AR","TBR_B_Nu","TBR_B_G","TBR__B_Contact","TBR_B","TBR_T"]
["Thickness","Thickness",null,null,"Ratio",0.83,0.96,0.92,0.99,0.76,null,null,"used",null,null,null,null,null,null,"SN<3.3","SN>3.3"]
[]
[{"$f":"+MASTER!C4*(MASTER!C5/0.4)","v":75},{"$f":"+MASTER!C6*(MASTER!C7/0.14)*(MASTER!C8/1)+MASTER!C9*(MASTER!C10/0.14)*(MASTER!C11/1)","v":300},{"$f":"+MASTER!C12","v":1.5},{"$f":"+MASTER!C15*4400","v":1870000},{"$f":"+MASTER!C16","v":0.59499999999999997},{"$f":"+IF(A14=TRUE,F2,1)","v":1},{"$f":"+IF(A14=TRUE,G2,1)","v":1},{"$f":"+IF(A15=TRUE,H2,1)","v":1},{"$f":"+IF(A15=TRUE,I2,1)","v":1},{"$f":"+MASTER!C17","v":1},{"$f":"0.4*A4/25.4+0.14*B4/25.4","v":2.8346456692913389},{"$f":"(49.8111*LOG(D4)-260.78)/100*(10^(LOG(8)-LOG(C4))-1)+1","v":3.2371842760518437},{"$f":"IF(L4>=1,L4,1)","v":3.2371842760518437},{"$f":"(0.0000018*LOG(C4)+0.00000157479)*D4/100*(10^(LOG(100)-1.7*LOG(C4))-1)+1","v":2.740248938215883},{"$f":"+LOG(N4/M4)/1.7","v":-4.2574943581278023E-2},{"$f":"+M4/10^(1.6*O4)","v":3.7869304755611486},{"$f":"2.54*(C4-0.28)^0.028*D4^0.0504","v":5.2887447697474332},{"$f":"+-LOG(N4)/(Q4-3.3)","v":-0.22013383758545479},{"$f":"+N4/10^(3.3*R4)","v":14.595926985038316},{"$f":"10^(O4*K4+LOG(P4))","v":2.8681539094629085},{"$f":"10^(R4*K4+LOG(S4))","v":3.4692073097850979},{"$f":"IF(K4<=3.3,T4,U4)","v":2.8681539094629085},{"$f":"+IF(V4>=1,V4,1)","v":2.8681539094629085},{"$f":"+W4*(0.62*LOG(W4)*E4+1-0.62*LOG(W4))","v":2.5385916219812885},{"$f":"+X4*F4","v":2.5385916219812885},{"$f":"+Y4*H4","v":2.5385916219812885},{"$f":"+Z4*J4","v":2.5385916219812885},{"$f":"+IF(AA4>=1,AA4,1)","v":2.5385916219812885},{"$f":"+(1-4.4511*C4^-0.5223)*A4/160+4.4511*C4^-0.5223","v":2.3820973969034371},{"$f":"(55.81466*LOG(D4)-287.7)/100*(AC4-1)+1","v":1.8618857059633813},{"$f":"+AD4*(0.2*E4+0.8)","v":1.7110729637803475},{"$f":"+AE4*G4","v":1.7110729637803475},{"$f":"+AF4*I4","v":1.7110729637803475},{"$f":"+AG4*J4","v":1.7110729637803475},{"$f":"+IF(AH4>1,AH4,1)","v":1.7110729637803475},{"$f":"+AI4*AB4","v":4.3437154904514825}]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+MASTER!C24*MASTER!D24*MASTER!E24*MASTER!C25*MASTER!D25*MASTER!E25","v":0}]
[false]
[false]

{"sheet":"BCR_S_TBR_1","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["BCR_S for TBR=1","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AB4","v":2.5385916219812885},{"$f":"+B5","v":2.5385916219812885}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+(B9-C3/25.4*C4)/(C7*C8)*25.4","v":235.44202184143833}]
["Base Structural Layer Coefficient",0.14000000000000001,0.17838786666674769,null,"Ratio of",{"$f":"10^((C7+0.977)/0.249)/10^((B7+0.977)/0.249)","v":1.4261596313805867}]
["Base Layer Drainage Coefficient",1,{"$f":"+B8","v":1},null,"base layer"]
["Structural Number",{"$f":"+B3/25.4*B4+B6/25.4*B7*B8","v":2.8346456692913389},{"$f":"+C3/25.4*C4+C6/25.4*C7*C8","v":2.8346456692913389},null,"resilient modulus"]
["Reliability",95,{"$f":"+B10","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B14*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B11*B12+9.36*LOG(B9+1)-0.2+(LOG(B13/(4.2-1.5)))/(0.4+1094/((B9+1)^5.19))+2.32*LOG(B15)-8.07)","v":19393.967362236206},{"$f":"10^(+C11*C12+9.36*LOG(C9+1)-0.2+(LOG(C13/(4.2-1.5)))/(0.4+1094/((C9+1)^5.19))+2.32*LOG(C15)-8.07)","v":19393.967362236206}]
[]
["BCR",null,{"$f":"+(B6-C6)/B6*100","v":21.519326052853891}]

{"sheet":"BCR_B_TBR_1","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["BCR_B for TBR=1","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AI4","v":1.7110729637803475},{"$f":"+B5","v":1.7110729637803475}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+(B9-C3/25.4*C4)/(C7*C8)*25.4","v":260.05333157205251}]
["Base Structural Layer Coefficient",0.14000000000000001,0.16150533333337871,null,"Ratio of",{"$f":"10^((C7+0.977)/0.249)/10^((B7+0.977)/0.249)","v":1.2200195795684665}]
["Base Layer Drainage Coefficient",1,{"$f":"+B8","v":1},null,"base layer"]
["Structural Number",{"$f":"+B3/25.4*B4+B6/25.4*B7*B8","v":2.8346456692913389},{"$f":"+C3/25.4*C4+C6/25.4*C7*C8","v":2.8346456692913389},null,"resilient modulus"]
["Reliability",95,{"$f":"+B10","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B14*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B11*B12+9.36*LOG(B9+1)-0.2+(LOG(B13/(4.2-1.5)))/(0.4+1094/((B9+1)^5.19))+2.32*LOG(B15)-8.07)","v":19393.967362236206},{"$f":"10^(+C11*C12+9.36*LOG(C9+1)-0.2+(LOG(C13/(4.2-1.5)))/(0.4+1094/((C9+1)^5.19))+2.32*LOG(C15)-8.07)","v":19393.967362236206}]
[]
["BCR",null,{"$f":"+(B6-C6)/B6*100","v":13.315556142649163}]

{"sheet":"BCR_T_TBR_1","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["BCR_T for TBR=1","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AJ4","v":4.3437154904514825},{"$f":"+B5","v":4.3437154904514825}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+(B9-C3/25.4*C4)/(C7*C8)*25.4","v":207.03423458936996}]
["Base Structural Layer Coefficient",0.14000000000000001,0.20286500000013266,null,"Ratio of",{"$f":"10^((C7+0.977)/0.249)/10^((B7+0.977)/0.249)","v":1.7884214888851091}]
["Base Layer Drainage Coefficient",1,{"$f":"+B8","v":1},null,"base layer"]
["Structural Number",{"$f":"+B3/25.4*B4+B6/25.4*B7*B8","v":2.8346456692913389},{"$f":"+C3/25.4*C4+C6/25.4*C7*C8","v":2.8346456692913389},null,"resilient modulus"]
["Reliability",95,{"$f":"+B10","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B14*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B11*B12+9.36*LOG(B9+1)-0.2+(LOG(B13/(4.2-1.5)))/(0.4+1094/((B9+1)^5.19))+2.32*LOG(B15)-8.07)","v":19393.967362236206},{"$f":"10^(+C11*C12+9.36*LOG(C9+1)-0.2+(LOG(C13/(4.2-1.5)))/(0.4+1094/((C9+1)^5.19))+2.32*LOG(C15)-8.07)","v":19393.967362236206}]
[]
["BCR",null,{"$f":"+(B6-C6)/B6*100","v":30.988588470210015}]

{"sheet":"BCRTBR_S_BCR","index":5,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["BCR/TBR_S Comb. for known BCR","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AB4","v":2.5385916219812885},{"$f":"+B5","v":2.5385916219812885}]
["Desired BCR",null,{"$f":"+MASTER!C25","v":0}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+B7-C6/100*B7","v":300}]
["Base Structural Layer Coefficient",0.14000000000000001,0.17838786666674769]
["Base Layer Drainage Coefficient",1,{"$f":"+B9","v":1}]
["Structural Number",{"$f":"+B3/25.4*B4+B7/25.4*B8*B9","v":2.8346456692913389},{"$f":"+C3/25.4*C4+C7/25.4*C8*C9","v":3.2880456692922957}]
["Reliability",95,{"$f":"+B11","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B15*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B12*B13+9.36*LOG(B10+1)-0.2+(LOG(B14/(4.2-1.5)))/(0.4+1094/((B10+1)^5.19))+2.32*LOG(B16)-8.07)","v":19393.967362236206},{"$f":"10^(+C12*C13+9.36*LOG(C10+1)-0.2+(LOG(C14/(4.2-1.5)))/(0.4+1094/((C10+1)^5.19))+2.32*LOG(C16)-8.07)","v":49237.567381550944}]
[]
["TBR",null,{"$f":"+C17/B17","v":2.538808406856762}]

{"sheet":"BCRTBR_S_TBR","index":6,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["BCR/TBR_S Comb. for known TBR","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AB4","v":2.5385916219812885},{"$f":"+B5","v":2.5385916219812885}]
["Desired TBR",null,{"$f":"+MASTER!C24","v":1}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+(C10-C3/25.4*C4)/(C8*C9)*25.4","v":235.45626047799738}]
["Base Structural Layer Coefficient",0.14000000000000001,0.17838786666674769]
["Base Layer Drainage Coefficient",1,{"$f":"+B9","v":1}]
["Structural Number",{"$f":"+B3/25.4*B4+B7/25.4*B8*B9","v":2.8346456692913389},2.8347456692913391]
["Reliability",95,{"$f":"+B11","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B15*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B12*B13+9.36*LOG(B10+1)-0.2+(LOG(B14/(4.2-1.5)))/(0.4+1094/((B10+1)^5.19))+2.32*LOG(B16)-8.07)","v":19393.967362236206},{"$f":"+B17*C6","v":19393.967362236206}]
[]
["BCR",null,{"$f":"+(B7-C7)/B7*100","v":21.51457984066754}]

{"sheet":"BCRTBR_B_BCR","index":7,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["BCR/TBR_B Comb. for known BCR","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AI4","v":1.7110729637803475},{"$f":"+B5","v":1.7110729637803475}]
["Desired BCR",null,{"$f":"+MASTER!D25","v":0}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+B7-C6/100*B7","v":300}]
["Base Structural Layer Coefficient",0.14000000000000001,0.16150533333337871]
["Base Layer Drainage Coefficient",1,{"$f":"+B9","v":1}]
["Structural Number",{"$f":"+B3/25.4*B4+B7/25.4*B8*B9","v":2.8346456692913389},{"$f":"+C3/25.4*C4+C7/25.4*C8*C9","v":3.0886456692918749}]
["Reliability",95,{"$f":"+B11","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B15*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B12*B13+9.36*LOG(B10+1)-0.2+(LOG(B14/(4.2-1.5)))/(0.4+1094/((B10+1)^5.19))+2.32*LOG(B16)-8.07)","v":19393.967362236206},{"$f":"10^(+C12*C13+9.36*LOG(C10+1)-0.2+(LOG(C14/(4.2-1.5)))/(0.4+1094/((C10+1)^5.19))+2.32*LOG(C16)-8.07)","v":33186.75123464952}]
[]
["TBR",null,{"$f":"+C17/B17","v":1.7111893928042039}]

{"sheet":"BCRTBR_B_TBR","index":8,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["BCR/TBR_B Comb. for known TBR","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AI4","v":1.7110729637803475},{"$f":"+B5","v":1.7110729637803475}]
["Desired TBR",null,{"$f":"+MASTER!D24","v":1}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+(C10-C3/25.4*C4)/(C8*C9)*25.4","v":260.06905860686669}]
["Base Structural Layer Coefficient",0.14000000000000001,0.16150533333337871]
["Base Layer Drainage Coefficient",1,{"$f":"+B9","v":1}]
["Structural Number",{"$f":"+B3/25.4*B4+B7/25.4*B8*B9","v":2.8346456692913389},2.8347456692913391]
["Reliability",95,{"$f":"+B11","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B15*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B12*B13+9.36*LOG(B10+1)-0.2+(LOG(B14/(4.2-1.5)))/(0.4+1094/((B10+1)^5.19))+2.32*LOG(B16)-8.07)","v":19393.967362236206},{"$f":"+B17*C6","v":19393.967362236206}]
[]
["BCR",null,{"$f":"+(B7-C7)/B7*100","v":13.310313797711103}]

{"sheet":"BCRTBR_T_BCR","index":9,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["BCR/TBR_T Comb. for known BCR","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AJ4","v":4.3437154904514825},{"$f":"+B5","v":4.3437154904514825}]
["Desired BCR",null,{"$f":"+MASTER!E25","v":23}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+B7-C6/100*B7","v":231}]
["Base Structural Layer Coefficient",0.14000000000000001,0.20286500000013266]
["Base Layer Drainage Coefficient",1,{"$f":"+B9","v":1}]
["Structural Number",{"$f":"+B3/25.4*B4+B7/25.4*B8*B9","v":2.8346456692913389},{"$f":"+C3/25.4*C4+C7/25.4*C8*C9","v":3.0260557086626241}]
["Reliability",95,{"$f":"+B11","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B15*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B12*B13+9.36*LOG(B10+1)-0.2+(LOG(B14/(4.2-1.5)))/(0.4+1094/((B10+1)^5.19))+2.32*LOG(B16)-8.07)","v":19393.967362236206},{"$f":"10^(+C12*C13+9.36*LOG(C10+1)-0.2+(LOG(C14/(4.2-1.5)))/(0.4+1094/((C10+1)^5.19))+2.32*LOG(C16)-8.07)","v":29184.259671556734}]
[]
["TBR",null,{"$f":"+C17/B17","v":1.5048112192033547}]

{"sheet":"BCRTBR_T_TBR","index":10,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["BCR/TBR_T Comb. for known TBR","Unreinforced ","Reinforced"]
[]
["AC Thickness (mm)",{"$f":"+TBR_BCR_0!A4","v":75},{"$f":"+B3","v":75}]
["AC Structural Layer Coefficient",0.4,{"$f":"+B4","v":0.4}]
["TBR for BCR=0",{"$f":"+TBR_BCR_0!AJ4","v":4.3437154904514825},{"$f":"+B5","v":4.3437154904514825}]
["Desired TBR",null,{"$f":"+MASTER!E24","v":2}]
["Base Thickness (mm)",{"$f":"+TBR_BCR_0!B4","v":300},{"$f":"+(C10-C3/25.4*C4)/(C8*C9)*25.4","v":248.55268281854828}]
["Base Structural Layer Coefficient",0.14000000000000001,0.20286500000013266]
["Base Layer Drainage Coefficient",1,{"$f":"+B9","v":1}]
["Structural Number",{"$f":"+B3/25.4*B4+B7/25.4*B8*B9","v":2.8346456692913389},3.1662456692920387]
["Reliability",95,{"$f":"+B11","v":95}]
["Standard Normal Deviate (Zr)",-1.645,-1.645]
["Overall Standard Deviation (So)",0.35,0.35]
["Design Serviceability Loss (Delta psi)",1.9,1.9]
["Subgrade CBR",{"$f":"+MASTER!C12","v":1.5},1.5]
["Subgrade Resilient Modulus (psi)",{"$f":"+B15*1500","v":2250},2250]
["ESAL's",{"$f":"10^(+B12*B13+9.36*LOG(B10+1)-0.2+(LOG(B14/(4.2-1.5)))/(0.4+1094/((B10+1)^5.19))+2.32*LOG(B16)-8.07)","v":19393.967362236206},{"$f":"+B17*C6","v":38787.934724472412}]
[]
["BCR",null,{"$f":"+(B7-C7)/B7*100","v":17.149105727150573}]