{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["All CMF Coeff","Instructions","Tgt StraightGrade","HCurve StraightGrade","Tgt VCurve","HCurve VCurve"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":21,"comments":1,"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":"All CMF Coeff","index":0,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,2,42,5]]}
["Obs","Cat","RT","Category","Crash type","Parameter","Estimate"]
[1,1,"R2U","Straight Grades","FI","Grade",4.3999999999999997E-2]
[2,1,"R2U","Straight Grades","FI","ln(2x5730/R)",0.19]
[3,1,"R2U","Straight Grades","FI","(1/R)x(1/Lc)",4.5199999999999996]
[4,1,"R2U","Straight Grades","PDO","Grade",0.04]
[5,1,"R2U","Straight Grades","PDO","ln(2x5730/R)",0.13]
[6,1,"R2U","Straight Grades","PDO","(1/R)x(1/Lc)",3.8]
[7,2,"R2U","Type 1 Crest","FI","(5730/R)xA",8.8000000000000005E-3]
[8,2,"R2U","Type 1 Crest","PDO","(5730/R)xA",4.5999999999999999E-3]
[9,3,"R2U","Type 1 Sag","FI","A/LVC",10.51]
[10,3,"R2U","Type 1 Sag","FI","(5730/R)xA",1.0999999999999999E-2]
[11,3,"R2U","Type 1 Sag","PDO","A/LVC",8.6199999999999992]
[12,3,"R2U","Type 1 Sag","PDO","(5730/R)xA",0.01]
[13,4,"R2U","Type 2 Crest","FI","ln(2x5730/R)",0.2]
[14,4,"R2U","Type 2 Crest","PDO","ln(2x5730/R)",0.1]
[15,5,"R2U","Type 2 Sag","FI","ln(2x5730/R)",0.188]
[16,5,"R2U","Type 2 Sag","PDO","(5730/R)xA",2.1999999999999999E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Adapted from: American Association of State Highway and Transportation Officials, A Policy on Geometric Design of Highways and Streets, (2011)."]

{"sheet":"Instructions","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Tgt StraightGrade","index":2,"n_rows":15,"n_cols":30,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,2,12,3],[12,4,13,4],[12,8,13,8],[12,9,13,9],[12,5,13,5],[12,6,13,6],[12,7,13,7]]}
[null,"Rural Two-Lane Roads: CMFs for Tangents on Straight Grades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)","v":1}]
[]
[null,"Parameter","Description","Unit","Value"]
[null,"G","Grade","Percent",-5,"(1 percent is entered as 1.0)"]
[null,"PFI","Proportion of FI crashes","None",0.32100000000000001,"(default is 0.321)"]
[null,"PPDO","Proportion of PDO crashes","None",{"$f":"1-E5","v":0.67900000000000005}]
[]
[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,"Tangent Analysis"]
[]
[]
[]
[null,"Rural Two-Lane Roads: CMFs for Tangents on Straight Grades"]
[null,"Record","Geometrics",null,"Grade\n(Percent)","PFI","PPDO","CMFFI","CMFPDO","CMFTOT"]
[null,null,"Horizontal","Vertical",null,null,null,null,null,null,null,null,null,"Grade (used)",null,null,null,null,null,null,null,null,null,null,null,"tangent analysis indicator","FI Coef1","PDO Coef1","CMFFI","CMFPDO"]
[null,1,"Tangent",{"$f":"IF(N15>0,\"Straight grade\",\"Level\")","v":"Straight grade"},{"$f":"E$4","v":-5},{"$f":"E$5","v":0.32100000000000001},{"$f":"E$6","v":0.67900000000000005},{"$f":"AC15","v":1.2460767305873808},{"$f":"AD15","v":1.2214027581601699},{"$f":"(H15-1)*F15+(I15-1)*G15+1","v":1.2293231033093046},null,null,null,{"$f":"IF(ABS($E$4)<1,0,ABS($E$4))","v":5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"1","v":1},{"$f":"'All CMF Coeff'!$G$2","v":4.3999999999999997E-2},{"$f":"'All CMF Coeff'!$G$5","v":0.04},{"$f":"Z15*EXP(AA15*ABS(N15))","v":1.2460767305873808},{"$f":"Z15*EXP(AB15*ABS(N15))","v":1.2214027581601699}]

{"sheet":"HCurve StraightGrade","index":3,"n_rows":15,"n_cols":32,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,1,13,1],[12,2,12,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7]]}
[null,"Rural Two-Lane Roads: CMFs for Horizontal Curves on Straight Grades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)","v":1}]
[]
[null,"Parameter","Description","Unit","Value"]
[null,"G","Grade","Percent",-5,"(1 percent is entered as 1.0)"]
[null,"R","Curve radius","ft",12000]
[null,"LC","Horizontal curve length","mi",5]
[null,"PFI","Proportion of FI crashes","None",0.32100000000000001,"(default is 0.321)"]
[null,"PPDO","Proportion of PDO crashes","None",{"$f":"1-E7","v":0.67900000000000005},null,null,null,null,null,null,null,null,"Horizontal Curve Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tangent Analysis"]
[]
[]
[]
[null,"Rural Two-Lane Roads: CMFs for Horizontal Curves on Straight Grades"]
[null,"Record","Geometrics",null,"Grade\n(Percent)","R          (ft)","LC            (mi)","PFI","PPDO","CMFFI","CMFPDO","CMFTOT"]
[null,null,"Horizontal","Vertical",null,null,null,null,null,null,null,null,null,"Grade (used)","Curve Radius (used)","Curve length\n(mi)","FI Coef1","FI Coef2","FI Coef3","PDO Coef1","PDO Coef2","PDO Coef3","CMFFI","CMFPDO",null,null,"Grade","tangent analysis indicator","FI Coef1","PDO Coef1","CMFFI","CMFPDO"]
[null,1,"Horizontal curve",{"$f":"IF(E15>0,\"Straight grade\",\"Level\")","v":"Level"},{"$f":"E$4","v":-5},{"$f":"E$5","v":12000},{"$f":"E$6","v":5},{"$f":"E$7","v":0.32100000000000001},{"$f":"E$8","v":0.67900000000000005},{"$f":"IFERROR(W15,AE15)","v":1.2460767305873808},{"$f":"IFERROR(X15,AF15)","v":1.2214027581601699},{"$f":"(J15-1)*H15+(K15-1)*I15+1","v":1.2293231033093046},null,{"$f":"IF(ISNA(AB15),IF($E$4<1,0,$E$4),NA())","v":{"$error":"#N/A"}},{"$f":"IF(F15<100,100,IF(F15>=11460,NA(),F15))","v":{"$error":"#N/A"}},{"$f":"G15","v":5},{"$f":"'All CMF Coeff'!$G$2","v":4.3999999999999997E-2},{"$f":"'All CMF Coeff'!$G$3","v":0.19},{"$f":"'All CMF Coeff'!$G$4","v":4.5199999999999996},{"$f":"'All CMF Coeff'!$G$5","v":0.04},{"$f":"'All CMF Coeff'!$G$6","v":0.13},{"$f":"'All CMF Coeff'!$G$7","v":3.8},{"$f":"EXP(Q15*ABS(N15)+R15*LN(2*5730/O15)+S15*1/O15/P15)","v":{"$error":"#N/A"}},{"$f":"EXP(T15*N15+U15*LN(2*5730/O15)+V15*1/O15/P15)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(ABS($E$4)<1,0,ABS($E$4))","v":5},{"$f":"IF($E$5>11460,1,NA())","v":1},{"$f":"'All CMF Coeff'!$G$2","v":4.3999999999999997E-2},{"$f":"'All CMF Coeff'!$G$5","v":0.04},{"$f":"AB15*EXP(AC15*ABS(AA15))","v":1.2460767305873808},{"$f":"AB15*EXP(AD15*ABS(AA15))","v":1.2214027581601699}]

{"sheet":"Tgt VCurve","index":4,"n_rows":15,"n_cols":41,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,2,12,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,12,13,12],[12,13,13,13],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11]]}
[null,"Rural Two-Lane Roads: CMFs for Tangents at Vertical Curves",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)","v":1}]
[]
[null,"Parameter","Description","Unit","Value"]
[null,"G1","Initial grade (include sign)","Percent",2,"(1 percent is entered as 1.0)"]
[null,"G2","Final grade (include sign)","Percent",3]
[null,"LVC","Vertical curve length","ft",600]
[null,"PFI","Proportion of FI crashes","None",0.32100000000000001,"(default is 0.321)"]
[null,"PPDO","Proportion of PDO crashes","None",{"$f":"1-E7","v":0.67900000000000005},null,null,null,null,null,null,null,null,null,null,null,"Type 1 Sag",null,null,null,null,null,null,null,null,"Type 1 Sag",null,null,null,null,"Type 1 Crest",null,null,null,"Type 2 Crest",null,null,null,"Type 2 Sag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(tangent analysis)",null,null,null,null,null,null,null,null,"(level tangent analysis)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF(g1<0 and g2>0 and LVC/A<=1000 and either [abs(g1)>=1 or abs(g2)>=1])",null,null,null,null,null,null,null,null,"IF(g1<0 and g2>0 and either [LVC/A>1000 or both {abs(g1)<1 and abs(g2)<1}])"]
[]
[null,"Rural Two-Lane Roads: CMFs for Tangents at Vertical Curves"]
[null,"Record","Geometrics",null,"Initial Grade\n(Percent)","Final Grade\n(Percent)","A\n(Percent)","LVC        (ft)","K (Lvc/A)","PFI","PPDO","CMFFI","CMFPDO","CMFTOT"]
[null,null,"Horizontal","Vertical",null,null,null,null,null,null,null,null,null,null,null,null,"analysis indicator","A","Lvc","FI Coef","PDO Ccoef","CMFFI","CMFPDO",null,null,"analysis indicator","CMFFI","CMFPDO",null,null,"analysis indicator","CMFFI","CMFPDO",null,"analysis indicator","CMFFI","CMFPDO",null,"analysis indicator","CMFFI","CMFPDO"]
[null,1,"Horizontal curve",{"$f":"IF(ISNUMBER(Q15),$Q$8,IF(ISNUMBER(Z15),$Z$8,IF(ISNUMBER(AE15),$AE$8,IF(ISNUMBER(AI15),$AI$8,IF(ISNUMBER(AM15),$AM$8,NA())))))","v":"Type 2 Sag"},{"$f":"$E$4","v":2},{"$f":"$E$5","v":3},{"$f":"ABS(E15-F15)","v":1},{"$f":"$E$6","v":600},{"$f":"H15/G15","v":600},{"$f":"E$7","v":0.32100000000000001},{"$f":"E$8","v":0.67900000000000005},{"$f":"IF(ISNUMBER(Q15),V15,IF(ISNUMBER(Z15),AA15,IF(ISNUMBER(AE15),AF15,IF(ISNUMBER(AI15),AJ15,IF(ISNUMBER(AM15),AN15,NA())))))","v":1},{"$f":"IF(ISNUMBER(Q15),W15,IF(ISNUMBER(Z15),AB15,IF(ISNUMBER(AE15),AG15,IF(ISNUMBER(AI15),AK15,IF(ISNUMBER(AM15),AO15,NA())))))","v":1},{"$f":"(L15-1)*J15+(M15-1)*K15+1","v":1},null,null,{"$f":"IF(AND(E15<0,F15>0,H15/G15<=1000,OR(ABS(E15)>=1,ABS(F15)>=1)),1,NA())","v":{"$error":"#N/A"}},{"$f":"G15","v":1},{"$f":"H15","v":600},{"$f":"'All CMF Coeff'!$G$10","v":10.51},{"$f":"'All CMF Coeff'!$G$12","v":8.6199999999999992},{"$f":"Q15*EXP(T15*R15/S15)","v":{"$error":"#N/A"}},{"$f":"Q15*EXP(U15*R15/S15)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(AND(E15<0,F15>0,OR(H15/G15>1000,AND(ABS(E15)<1,ABS(F15)<1))),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(Z15),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(Z15),1,NA())","v":{"$error":"#N/A"}},null,null,{"$f":"IF(AND(E15>0,F15<0),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(AE15),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(AE15),1,NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(AND(E15>0,F15>=0,E15>F15),AND(E15<=0,F15<0,ABS(E15)<ABS(F15))),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(AI15),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(AI15),1,NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(AND(E15>=0,F15>0,E15<F15),AND(E15<0,F15<=0,ABS(E15)>ABS(F15))),1,NA())","v":1},{"$f":"IF(ISNUMBER(AM15),1,NA())","v":1},{"$f":"IF(ISNUMBER(AM15),1,NA())","v":1}]

{"sheet":"HCurve VCurve","index":5,"n_rows":15,"n_cols":150,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,2,12,3],[12,4,13,4],[12,7,13,7],[12,6,13,6],[12,5,13,5],[12,15,13,15],[12,14,13,14],[12,8,13,8],[12,13,13,13],[12,12,13,12],[12,11,13,11],[12,10,13,10],[12,9,13,9]]}
[null,"Rural Two-Lane Roads: CMFs for Horizontal Curves at Vertical Curves",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)","v":1}]
[]
[null,"Parameter","Description","Unit","Value"]
[null,"G1","Initial grade (include sign)","Percent",-3,"(1 percent is entered as 1.0)"]
[null,"G2","Final grade (include sign)","Percent",2]
[null,"R","Curve radius","ft",1430]
[null,"LC","Horizontal curve length","mi",0.12]
[null,"LVC","Vertical curve length","ft",600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 1 Crest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 1 Crest",null,null,null,"Type 1 Crest",null,null,null,null,null,null,null,null,null,"Type 1 Sag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 1 Sag",null,null,null,null,null,null,null,"Type 1 Sag",null,null,null,null,null,null,null,null,null,null,null,"Type 2 Crest","Type 2 Crest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 2 Crest",null,null,null,null,"Type 2 Crest",null,null,null,null,null,null,null,null,"Type 2 Sag","Type 2 Sag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type 2 Sag",null,null,null,null,"Type 2 Sag"]
[null,"PFI","Proportion FI crashes","None",0.32100000000000001,"(default is 0.321)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(h curve, straight grade analysis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(tangent type 1 crest)",null,null,null,"normal",null,null,null,null,null,null,null,null,null,"(h curve, straight grade analysis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(tangent type 1 sag)",null,null,null,null,null,null,null,"normal",null,null,null,null,null,null,null,null,null,null,null,"[all]","(h curve, straight grade analysis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(tangent at Type 2 crest)",null,null,null,null,"normal",null,null,null,null,null,null,null,null,"[all]","(h curve, straight grade analysis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(tangent analysis)",null,null,null,null,"normal"]
[null,"PPDO","Proportion PDO crashes","None",{"$f":"1-E9","v":0.67900000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF(g1 > 0 and g2 <0  and R <11460 and either[ABS(g1) < 1 and ABS(g2) < 1] or [K>1000]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF(g1>0 and g2<0 and R>=11460)",null,null,null,"IF(g1>0 and g2<0 and R<11460 and K<1000 and either [ABS(g1) >= 1 or ABS(g2) >= 1])",null,null,null,null,null,null,null,null,null,"IF(g1<0 and g2>0 and R<11460 and either [ABS(g1) < 1 and ABS(g2) < 1] or [K>1000])",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF(g1<0 and g2>0 and R>=11460)",null,null,null,null,null,null,null,"IF(g1<0 and g2>0 and R<11460 and K<1000 and either [ABS(g1) >= 1 or ABS(g2) >= 1] and K<=1000)",null,null,null,null,null,null,null,null,null,null,null,"IF(either [g1>0 and g2>=0 and g1>g2] or [E15<=0 and F15<0 and ABS(g1)<ABS(g2)]","IF(A<1 or K>1000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if(R>=11460)",null,null,null,null,"if(A>=1 and K<=1000 and R <11460)",null,null,null,null,null,null,null,null,"IF either [g1>=0 and g2>0 and g1<g2] or [g1<0 and g2<=0 and ABS(g1)>ABS(g2)]","if [R<11460 and A<1] or [R<11460 and LVC/A>1000]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if R>=11460",null,null,null,null,"if R<11460 and A>=1 and LVC/A<=1000"]
[]
[null,"Rural Two-Lane Roads: CMFs for Horizontal Curves at Vertical Curves"]
[null,"Record","Geometrics",null,"Initial Grade\n(Percent)","Final Grade\n(Percent)","A\n(Percent)","R         (ft)","LC         (mi)","LVC         (ft)","K\n(Lvc/A)","PFI","PPDO","CMFFI","CMFPDO","CMFTOT"]
[null,null,"Horizontal","Vertical",null,null,null,null,null,null,null,null,null,null,null,null,null,"Curve Radius (used)",null,null,"analysis indicator","Grade 1","Grade 2","Grade (used)","K","R","Curve length\n(mi)","FI Coef1","FI Coef2","FI Coef3","PDO Coef1","PDO Coef2","PDO Coef3","CMFFI","CMFPDO",null,"analysis indicator","CMFFI","CMFPDO",null,"analysis indicator","R","Grade 1","Grade 2","A","FI coef","PDO coef","CMFFI","CMFPDO",null,"analysis indicator","Grade 1","Grade 2","Grade (used)","K","R","Lvc","FI Coef1","FI Coef2","FI Coef3","PDO Coef1","PDO Coef2","PDO Coef3","CMFFI","CMFPDO",null,"analysis indicator","A","Lvc","FI Coef","PDO Ccoef","CMFFI","CMFPDO",null,"analysis indicator","K","A","Lvc","R","FI Coef 1","FI Coef 2","PDO Coef 1","PDO Coef 2","CMFFI","CMFPDO",null,"analysis indicator 1","analysis indicator 2","A","Grade 1","Grade 2","Grade (used)","K","R","Curve length\n(mi)","FI Coef1","FI Coef2","FI Coef3","PDO Coef1","PDO Coef2","PDO Coef3","CMFFI","CMFPDO",null,"analysis indicator 2","R","CMFFI","CMFPDO",null,"analysis indicator 2","A","K","R","FI Coef","PDO Coef","CMFFI","CMFPDO",null,"analysis indicator","analysis indicator 2","A","LVC","Grade 1","Grade 2","Grade (used)","K","R","Curve length\n(mi)","FI Coef1","FI Coef2","FI Coef3","PDO Coef1","PDO Coef2","PDO Coef3","CMFFI","CMFPDO",null,"analysis indicator 2","R","CMFFI","CMFPDO",null,"analysis indicator 2","R","A","LVC","FI coef","PDO coef","CMFFI","CMFPDO"]
[null,1,"Horizontal curve",{"$f":"IF(ISNUMBER(U15),$U$8,IF(ISNUMBER(AK15),$AK$8,IF(ISNUMBER(AO15),$AO$8,IF(ISNUMBER(AY15),$AY$8,IF(ISNUMBER(BO15),$BO$8,IF(ISNUMBER(BW15),$BW$8,IF(ISNUMBER(CI15),$CI$8,IF(ISNUMBER(DA15),$DA$8,IF(ISNUMBER(DF15),$DF$8,IF(ISNUMBER(DP15),$DP$8,IF(ISNUMBER(EH15),$EH$8,IF(ISNUMBER(EM15),$EM$8,NA()))))))))))))","v":"Type 1 Sag"},{"$f":"$E$4","v":-3},{"$f":"$E$5","v":2},{"$f":"ABS(E15-F15)","v":5},{"$f":"E$6","v":1430},{"$f":"E$7","v":0.12},{"$f":"$E$8","v":600},{"$f":"J15/G15","v":120},{"$f":"E$9","v":0.32100000000000001},{"$f":"E$10","v":0.67900000000000005},{"$f":"IF(ISNUMBER(U15),AH15,IF(ISNUMBER(AK15),AL15,IF(ISNUMBER(AO15),AV15,IF(ISNUMBER(AY15),BL15,IF(ISNUMBER(BO15),BT15,IF(ISNUMBER(BW15),CF15,IF(ISNUMBER(CJ15),CX15,IF(ISNUMBER(DA15),DC15,IF(ISNUMBER(DF15),DL15,IF(ISNUMBER(DP15),EE15,IF(ISNUMBER(EH15),EJ15,IF(ISNUMBER(EM15),ES15,NA()))))))))))))","v":1.3606573774248725},{"$f":"IF(ISNUMBER(U15),AI15,IF(ISNUMBER(AK15),AM15,IF(ISNUMBER(AO15),AW15,IF(ISNUMBER(AY15),BM15,IF(ISNUMBER(BO15),BU15,IF(ISNUMBER(BW15),CG15,IF(ISNUMBER(CJ15),CY15,IF(ISNUMBER(DA15),DD15,IF(ISNUMBER(DF15),DM15,IF(ISNUMBER(DP15),EF15,IF(ISNUMBER(EH15),EK15,IF(ISNUMBER(EM15),ET15,NA()))))))))))))","v":1.3128272052908789},{"$f":"(N15-1)*L15+(O15-1)*M15+1","v":1.3281806905458908},null,{"$f":"IF(H15<100,100,H15)","v":1430},null,null,{"$f":"IF(AND(E15>0,F15<0,R15<11460,OR(AND(ABS(V15) < 1, ABS(W15) < 1),Y15>1000)),1,NA())","v":{"$error":"#N/A"}},{"$f":"E15","v":-3},{"$f":"F15","v":2},{"$f":"0","v":0},{"$f":"K15","v":120},{"$f":"R15","v":1430},{"$f":"I15","v":0.12},{"$f":"'All CMF Coeff'!$G$2","v":4.3999999999999997E-2},{"$f":"'All CMF Coeff'!$G$3","v":0.19},{"$f":"'All CMF Coeff'!$G$4","v":4.5199999999999996},{"$f":"'All CMF Coeff'!$G$5","v":0.04},{"$f":"'All CMF Coeff'!$G$6","v":0.13},{"$f":"'All CMF Coeff'!$G$7","v":3.8},{"$f":"U15*EXP(AB15*ABS(X15)+AC15*LN(2*5730/Z15)+AD15*1/Z15/AA15)","v":{"$error":"#N/A"}},{"$f":"U15*EXP(AE15*X15+AF15*LN(2*5730/Z15)+AG15*1/Z15/AA15)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(E15>0,F15<0,H15>=11460),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(AK15),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(AK15),1,NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(E15>0,F15<0,H15<11460,K15<1000,OR(ABS(E15) >= 1, ABS(F15) >= 1)),1,NA())","v":{"$error":"#N/A"}},{"$f":"R15","v":1430},{"$f":"E15","v":-3},{"$f":"F15","v":2},{"$f":"ABS(AQ15-AR15)","v":5},{"$f":"'All CMF Coeff'!$G$8","v":8.8000000000000005E-3},{"$f":"'All CMF Coeff'!$G$9","v":4.5999999999999999E-3},{"$f":"AO15*EXP(AT15*5730/AP15*AS15)","v":{"$error":"#N/A"}},{"$f":"AO15*EXP(AU15*5730/AP15*AS15)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(E15<0,F15>0,R15<11460,OR(AND(ABS(E15) < 1, ABS(F15) < 1),K15>1000)),1,NA())","v":{"$error":"#N/A"}},{"$f":"E15","v":-3},{"$f":"F15","v":2},{"$f":"0","v":0},{"$f":"K15","v":120},{"$f":"R15","v":1430},{"$f":"I15","v":0.12},{"$f":"'All CMF Coeff'!$G$2","v":4.3999999999999997E-2},{"$f":"'All CMF Coeff'!$G$3","v":0.19},{"$f":"'All CMF Coeff'!$G$4","v":4.5199999999999996},{"$f":"'All CMF Coeff'!$G$5","v":0.04},{"$f":"'All CMF Coeff'!$G$6","v":0.13},{"$f":"'All CMF Coeff'!$G$7","v":3.8},{"$f":"AY15*EXP(BF15*ABS(BB15)+BG15*LN(2*5730/BD15)+BH15*1/BD15/BE15)","v":{"$error":"#N/A"}},{"$f":"AY15*EXP(BI15*BB15+BJ15*LN(2*5730/BD15)+BK15*1/BD15/BE15)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(E15<0,F15>0,R15>=11460),1,NA())","v":{"$error":"#N/A"}},{"$f":"G15","v":5},{"$f":"J15","v":600},{"$f":"'All CMF Coeff'!$G$10","v":10.51},{"$f":"'All CMF Coeff'!$G$12","v":8.6199999999999992},{"$f":"BO15*EXP(BR15*BP15/BQ15)","v":{"$error":"#N/A"}},{"$f":"BO15*EXP(BS15*BP15/BQ15)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(E15<0,F15>0,H15<11460,OR(ABS(E15) >= 1, ABS(F15) >= 1), BX15<=1000),1,NA())","v":1},{"$f":"K15","v":120},{"$f":"G15","v":5},{"$f":"J15","v":600},{"$f":"R15","v":1430},{"$f":"'All CMF Coeff'!$G$10","v":10.51},{"$f":"'All CMF Coeff'!$G$11","v":1.0999999999999999E-2},{"$f":"'All CMF Coeff'!$G$12","v":8.6199999999999992},{"$f":"'All CMF Coeff'!$G$13","v":0.01},{"$f":"BW15*EXP(CB15*BY15/BZ15+CC15*5730/CA15*BY15)","v":1.3606573774248725},{"$f":"BW15*EXP(CD15*BY15/BZ15+CE15*5730/CA15*BY15)","v":1.3128272052908789},null,{"$f":"IF(OR(AND(E15>0,F15>=0,E15>F15),AND(E15<=0,F15<0,ABS(E15)<ABS(F15))),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND(CI15=1,OR(CK15<1,CO15>1000)),1,NA())","v":{"$error":"#N/A"}},{"$f":"G15","v":5},{"$f":"E15","v":-3},{"$f":"F15","v":2},{"$f":"(CL15+CM15)/2","v":-0.5},{"$f":"K15","v":120},{"$f":"R15","v":1430},{"$f":"I15","v":0.12},{"$f":"'All CMF Coeff'!$G$2","v":4.3999999999999997E-2},{"$f":"'All CMF Coeff'!$G$3","v":0.19},{"$f":"'All CMF Coeff'!$G$4","v":4.5199999999999996},{"$f":"'All CMF Coeff'!$G$5","v":0.04},{"$f":"'All CMF Coeff'!$G$6","v":0.13},{"$f":"'All CMF Coeff'!$G$7","v":3.8},{"$f":"CJ15*EXP(CR15*ABS(CN15)+CS15*LN(2*5730/CP15)+CT15*1/CP15/CQ15)","v":{"$error":"#N/A"}},{"$f":"CJ15*EXP(CU15*CN15+CV15*LN(2*5730/CP15)+CW15*1/CP15/CQ15)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(CI15=1,DB15>=11460),1,NA())","v":{"$error":"#N/A"}},{"$f":"R15","v":1430},{"$f":"IF(ISNUMBER(DA15),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(DA15),1,NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(CI15=1,DG15>=1,DH15<=1000,DI15<11460),1,NA())","v":{"$error":"#N/A"}},{"$f":"G15","v":5},{"$f":"K15","v":120},{"$f":"R15","v":1430},{"$f":"'All CMF Coeff'!$G$14","v":0.2},{"$f":"'All CMF Coeff'!$G$15","v":0.1},{"$f":"DF15*EXP(DJ15*LN(2*5730/DI15))","v":{"$error":"#N/A"}},{"$f":"DF15*EXP(DK15*LN(2*5730/DI15))","v":{"$error":"#N/A"}},null,{"$f":"IF(OR(AND(E15>=0,F15>0,E15<F15),AND(E15<0,F15<=0,ABS(E15)>ABS(F15))),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(AND(DO15=1,DW15<11460,OR(DQ15<1,DR15/DQ15>1000)),1,NA())","v":{"$error":"#N/A"}},{"$f":"G15","v":5},{"$f":"J15","v":600},{"$f":"E15","v":-3},{"$f":"F15","v":2},{"$f":"(DS15+DT15)/2","v":-0.5},{"$f":"K15","v":120},{"$f":"R15","v":1430},{"$f":"I15","v":0.12},{"$f":"'All CMF Coeff'!$G$2","v":4.3999999999999997E-2},{"$f":"'All CMF Coeff'!$G$3","v":0.19},{"$f":"'All CMF Coeff'!$G$4","v":4.5199999999999996},{"$f":"'All CMF Coeff'!$G$5","v":0.04},{"$f":"'All CMF Coeff'!$G$6","v":0.13},{"$f":"'All CMF Coeff'!$G$7","v":3.8},{"$f":"DP15*EXP(DY15*ABS(DU15)+DZ15*LN(2*5730/DW15)+EA15*1/DW15/DX15)","v":{"$error":"#N/A"}},{"$f":"DP15*EXP(EB15*DU15+EC15*LN(2*5730/DW15)+ED15*1/DW15/DX15)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(DO15=1,EI15>=11460),1,NA())","v":{"$error":"#N/A"}},{"$f":"R15","v":1430},{"$f":"IF(ISNUMBER(EH15),1,NA())","v":{"$error":"#N/A"}},{"$f":"IF(ISNUMBER(EH15),1,NA())","v":{"$error":"#N/A"}},null,{"$f":"IF(AND(DO15=1,EN15<11460,EO15>=1,EP15<=1000),1,NA())","v":{"$error":"#N/A"}},{"$f":"R15","v":1430},{"$f":"G15","v":5},{"$f":"J15","v":600},{"$f":"'All CMF Coeff'!$G$16","v":0.188},{"$f":"'All CMF Coeff'!$G$17","v":2.1999999999999999E-2},{"$f":"EM15*EXP(EQ15*LN(2*5730/EN15))","v":{"$error":"#N/A"}},{"$f":"EM15*EXP(ER15*5730/EN15*EO15)","v":{"$error":"#N/A"}}]