{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Documentation","Forecast","16-24 Vehicle C.C.1","16-24 Vehicle C.C.2","16-24 Vehicle C.C.3","16-24 Vehicle C.C.4","New Avg Vehicle C.C.","Least Squares","Cumesal-A","Esal Report - A","Cumesal-B","Esal Report - B"],"not_rendered":{"charts":5,"images":6,"macros":1,"external_links":0,"defined_names":124,"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":"Documentation","index":0,"n_rows":66,"n_cols":3,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,null,"NEW FOR 2009 - COUNTY GROWTH PROFILES"]
[]
["The Office of Transportation Data and Analysis has recently added an enhancement to the \"Least"]
["Squares Worksheet.\"  Because of recent leveling off and in some cases declines in traffic volumes over"]
["the last few years, we began an analysis of causal factors.  We looked at socio-economic data by county "]
["from 1992 through 2007.  The data we analyzed was population, labor force, employment and "]
["number of households.  From these inputs we cartegorized the counties into one of four growth profiles -"]
["high, medium high, medium low and low. Now the analyst will have the option of applying a factor based "]
["on the socio-economic data for that county to the Base and Forecast year projections derived from the least"]
["squares regression analysis."]
[]
["The factors are meant for use in the non-urban areas within the specific county.  If the project is within a "]
["with city over 5,000 population, the factors do not apply - similar to the concept of urban and rural factors"]
["on the vehicle class count expansion worksheets."]
[]
["These factors are automatically applied to the historic least squares regression analysis. They originate "]
["from the Forecast tab when you enter the county that the project is located in. Please note that the"]
["forecaster has the option to accept the projection based on historic data or to use the historic data "]
["projection tempered by the county factor - or, some value in between.  Whatever the analyst chooses to"]
["do, he/she should document their procedure in the Remarks area of the Forecast Tab.  This guideline"]
["serves as another tool to improve the quality and inputs of our traffic forecasting process."]
[]
["If you have further questions, contact Tom Nelson at (651) 366-3868"]
[]
[]
[]
[null,"As of April 1, 2008, we have changed the seasonal adjustment factors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: The URBAN vehicle types discussed on the Cumesal-B sheet were developed "]
[null,"primarily for use in the Seven County Metropolitan Area. They can also be used"]
[null,"for segments that are near cities with over 5,000 population."]
[]
[null,"CAUTION: USE ONLY ONE SET OF DEFAULTS ON EACH \"B\" SEGMENT FOR THE"]
[null,"CORRESPPONDING  \"A\" SEGMENT- feel free to mix urban and rural defaults in the"]
[null,"same forecast if necessaryi"]
[]
[null,"More comprehensive information on the use of this spreadsheet on TDA's web site."]
[null,"Refer to \"Procedures Manual for Forecasting Traffic on Minnesota's Highways\""]
[null,"in downloadable PDF format."]

{"sheet":"Forecast","index":1,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[23,0,23,1],[24,0,24,1],[25,0,25,1],[27,0,27,1]]}
[]
[null,null,"MINNESOTA DEPARTMENT OF TRANSPORTATION"]
[]
[null,null,"MEMO"]
[]
[null,null,"Transportation Data and Analysis"]
[null,null,"395 John Ireland Boulevard - MS 450",null,null,null,"Phone:","(651) 366-3856"]
[null,null,"St. Paul, Minnesota 55155",null,null,null,"Fax:","(651) 366-3886"]
[]
[null,null,{"$f":"NOW()","v":"2013-02-15T09:32:49.330"}]
[]
[null,"To:"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"From:","Gene Hicks"]
[null,null,"Section Director"]
[null,null,"Traffic Forecasting and Analysis, MS 450"]
[]
[null,"Subject:","TRAFFIC FORECAST"]
[null,null,null,null,null,null,"Beg Pt"]
[null," Route Type:",null,null,null,null,"End Pt"]
[null,"Route Num",null,null,null,null,"SP#"]
["    Letting Date:",null,null,null,null,null,"Forecast #"]
["Program Category:",null,null,null,null,null,"County:",""]
[" Project Manager:",null,null,null,null,null,"District:"]
[null,null,null,null,null,null,"Miles:"]
["  Project Limits:"]
[]
["Enclosures (check those that apply):"]
[]
[null,"Project map",null,null,null,null,"VCL expansion worksheet",null,null,"INTERSTATE"]
[null,null,null,null,null,null,null,null,null,"MN TRUNK"]
[null,"Least squares analysis",null,null,null,null,"Cumulative ESAL Report",null,null,"US TRUNK "]
[null,null,null,null,null,null,null,null,null,"CSAH"]
[null,"Cumulative ESAL worksheet, Segment A",null,null,null,null,"Other (describe)",null,null,"CR"]
[null,null,null,null,null,null,null,null,null,"OTHER"]
[null,"Cumulative ESAL worksheet, Segment B",null,null,null,null,"Other (describe)"]
[]
[null,"AADT and/or DHV traffic schematic diagram"]
[]
[null,"REMARKS:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" FILE"]

{"sheet":"16-24 Vehicle C.C.1","index":2,"n_rows":52,"n_cols":30,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,17,1,29],[12,17,13,29],[1,10,1,11],[2,10,2,11],[52,0,52,1],[53,0,53,1],[9,7,9,8],[10,7,10,8],[17,2,17,6],[18,0,18,8],[19,0,19,8],[51,0,51,8]]}
["16 HR. OR 24 HR. VEHICLE CLASS COUNT EXPANSION WORKSHEET 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Urban Area"]
["SITE NUMBER:",null,null,null,null,null,"COUNTY:",{"$f":"IF(+Forecast!$H$25=0,\" \",+Forecast!$H$25)","v":""},null,null,"Area type must be selected "]
["SITE DESCRIPTION:",null,null,null,null,null,null,null,null,null,"for correct adjustment factors",null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["PROJECT SP#:",{"$f":"IF(+Forecast!$H$23=0,\" \",+Forecast!$H$23)","v":" "},null,null,null,null,"YEAR OF COUNT ->:",null,null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.1018185676627199,1.0423996055399734,1.020715235235951,0.98255951109647888,0.9804214302718508,0.95244541007083505,0.90216726525086255,0.8851863968910807,0.84632042908361105,0.97665284468265745,1.0547545544577273,1.1297004186575983]
["MONTH NUMBER OF COUNT:",null,null,null,null,null,"CONSTRAIN AADT ->:",null,null,null,null,null,null,null,null,null,null,"2ASU",0.90263649125519896,0.91520953448461206,0.88096934353246148,0.84331498006255301,0.80495140578982816,0.90779238890720149,0.79842162995687838,0.74639564934170721,0.67424238816764226,0.81108236948338686,0.87806128604032396,0.94976185659471002]
["16 or 24 HR",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.1924856045804944,1.1967811633488727,1.1496917146229904,0.8838166573741878,0.79005604362787696,0.84049043990544692,0.6830196814803593,0.66856166970197961,0.57864519180378138,0.61345269707607175,0.7366804616504824,1.0011650843817974]
["VEHICLE TYPE",null,"RAW COUNT","AADT ADJ FACTOR",null,"ADJUSTED RAW","VEH. TYPE PERCENTS","A.C.F.",null,null,"Note: The URBAN adjustment factors were ",null,null,null,null,null,null,"3A Semi",1.11964778503192,1.0988656878061378,1.0323559840116212,0.90312120328168821,0.83524055323834678,0.85644951312117357,0.78679585454877188,0.67427555927715088,0.66694771051948576,0.88866836853554376,0.82793302695465165,1.0807728582129452]
["CARS AND PICKUPS",null,null,{"$f":"IF(O9=1,IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.31,1.23,1.19,1.06,0.98,0.92,0.84,0.88,0.91,0.95,1.08,1.12)),NA()),IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.08,1.04,1.04,0.97,0.97,0.96,0.91,0.9,0.93,0.88,0.97,1)),NA()))","v":1},null,{"$f":"IF(+I5=0,ROUND(+D8*C8,0),+I5-SUM(F9:F15))","v":0},null,{"$f":"C16/(((C8+C9)*2+(C10+C11)*3+(C12+C14)*4+(C13+C15)*5)/2)","v":{"$error":"#DIV/0!"}},null,null,"developed primarily for use in the Seven",null,null,null,null,null,null,"4A Semi",1.119647785031916,1.0988656878061382,1.0323559840116214,0.90312120328168821,0.83524055323834712,0.85644951312117357,0.7867958545487721,0.67427555927715088,0.66694771051948609,0.88866836853554398,0.82793302695465187,1.0807728582129454]
["2 AXLE 6 TIRE",null,null,{"$f":"IF(O9=1,IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,1.02,0.93,0.96,0.89,0.85,0.87,0.83,0.83,0.76,0.77,0.88,1),IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,0.96,0.88,0.92,0.9,0.89,0.86,0.8,0.76,0.83,0.76,0.79,0.84))","v":1},null,{"$f":"IF(B6=16,ROUND(+D9*C9,0),(IF(B6=24,ROUND(D9*C9,0),#VALUE!)))","v":0},{"$f":"IF(F9=0,0,+F9/F16)","v":0},null,null,null,"County Metropolitan Area.  They can also",null,null,null,1,null,null,"5+A SEMI",0.86942071785393904,0.87769046245725946,0.86475403821150698,0.80940641424647031,0.79229291302650162,0.8333092409344941,0.71498062831051845,0.71083502542786892,0.65989290833686787,0.75058644434637201,0.89675857454450747,0.94138016862075991]
["3+ AXLE SINGLE UNIT",null,null,{"$f":"IF(O9=1,IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.24,1.17,1.12,0.89,0.76,0.71,0.7,0.66,0.65,0.64,0.86,1.09),IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.23,1.16,1.21,0.86,0.75,0.67,0.59,0.54,0.64,0.64,0.8,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D10*C10,0),(IF(B6=24,ROUND(D10*C10,0),#VALUE!)))","v":0},{"$f":"IF(F10=0,0,+F10/F16)","v":0},null,null,null,"be used for other cities with over 5,000 in pop.",null,null,2,2,16,null,"TT/BUS",1.4066146231040682,1.3288036638848086,1.15873877091399,1.0261577176178078,0.93270732951272139,0.86210040919048259,0.77051789867293574,0.6232459159642002,0.58992754026695837,0.77892275431298452,0.88038502237281158,1.1683821812126145]
["3 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D11*C11,0),(IF(B6=24,ROUND(D11*C11,0),#VALUE!)))","v":0},{"$f":"IF(F11=0,0,+F11/F16)","v":0},null,null,null,null,null,null,null,null,24,null,"TWINS",0.89018355801878479,0.84528264938896014,0.82462988286654948,0.75360709179751284,0.77877654317931966,0.91488343699026875,0.83132303327571377,0.72280274769227226,0.69724925390569048,0.75256534869628855,0.88867547548025327,0.88210398706503734]
["4 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D12*C12,0),(IF(B6=24,ROUND(D12*C12,0),#VALUE!)))","v":0},{"$f":"IF(F12=0,0,+F12/F16)","v":0}]
["5+ AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1, IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,0.93,0.86,0.87,0.82,0.79,0.79,0.82,0.78,0.8,0.73,0.87,0.9),IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,1.02,0.99,1,0.79,0.75,0.71,0.69,0.65,0.7,0.76,0.76,0.99))","v":1},null,{"$f":"IF(B6=16,ROUND(+D13*C13,0),(IF(B6=24,ROUND(D13*C13,0),#VALUE!)))","v":0},{"$f":"IF(F13=0,0,+F13/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Rural Area"]
["TR TR, BUSES",null,null,{"$f":"IF(O9=1,IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.6,1.44,1.31,0.99,0.81,0.75,0.67,0.68,0.7,0.68,0.96,1.4),IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.51,1.31,1.19,1.03,0.92,0.82,0.76,0.71,0.74,0.77,0.94,1.07))","v":1},null,{"$f":"IF(B6=16,ROUND(+D14*C14,0),(IF(B6=24,ROUND(D14*C14,0),#VALUE!)))","v":0},{"$f":"IF(F14=0,0,+F14/F16)","v":0}]
["TWIN TRAILERS",null,null,{"$f":"IF(O9=1,IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,0.95,0.86,0.92,0.86,0.86,0.75,0.8,0.76,0.75,0.7,0.82,0.76),IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,1.07,1.02,1.02,0.84,0.78,0.74,0.69,0.65,0.67,0.77,0.93,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D15*C15,0),(IF(B6=24,ROUND(D15*C15,0),#VALUE!)))","v":0},{"$f":"IF(F15=0,0,+F15/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["TOTALS ----------->",null,{"$f":"SUM(C8:C15)","v":0},"-------->",{"$f":"+F16/C16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F8:F15)","v":0},{"$f":"SUM(F9:F15)/F16","v":{"$error":"#DIV/0!"}},"(%HC)",null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.3147434096163959,1.260555415508084,1.2191063204366583,1.1335792360817896,0.96743651827253996,0.88113341055029792,0.80686674313002726,0.83571055323589394,0.94925259857541666,1.0297515161892752,1.1254370827613058,1.1984997233393948]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2ASU",1.0421136678796159,1.0796151955298507,1.073531771489727,0.97003737605495022,0.87660615954238774,0.85182942754266922,0.85051864263193822,0.8291160375969,0.80998807036307507,0.82575550489882676,0.93365664144644978,0.96446600029888474]
[null,null,"DO YOU HAVE THE CORRECT RURAL OR URBAN FACTOR?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.3391976341936089,1.4397711133479576,1.2792395002653094,0.93245159180452619,0.81219085629561705,0.60723176419294977,0.70997757651811144,0.68740797870198267,0.70418899546913249,0.69666824377689318,0.84923786590404304,1.2455765405645749]
[{"$f":"+B2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - January","3A Semi",1.5740285150379849,1.5407913377030271,1.49264888061556,1.2233547531417996,0.89924025118841999,0.81883527709828285,0.73474864877864943,0.68030211317161005,0.74435725796352192,0.87560862613624846,1.0963565956498842,1.2736579553015599]
[{"$f":"+B3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - February","4A Semi",1.5740285150379849,1.5407913377030276,1.4926488806155604,1.2233547531418001,0.8992402511884201,0.81883527709828297,0.73474864877864943,0.68030211317161016,0.74435725796352203,0.8756086261362489,1.0963565956498846,1.2736579553015606]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - March","5+A SEMI",0.97742736051615664,0.9048104914965911,0.85990705226462538,0.82063154007684946,0.77787213019245971,0.71713378416711093,0.77320084394568978,0.74712290228442568,0.76375782282762339,0.73921514671402577,0.87755200696696622,0.93105325954953666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - April","TT/BUS",2.0530650919060474,2.0594572192363545,1.5493404798648853,1.1114678000636622,0.87368160419327356,0.74178140463417197,0.70589749299503979,0.66796906328373884,0.70162102278790783,0.78889438143426527,1.0116812496784142,1.575509804412097]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - May","TWINS",1.4200652049607598,0.95161350386861687,0.94147345631703649,0.93602224460982308,0.86013894109429645,0.86659745641719899,0.82948792163548768,0.66127893190165599,0.69357705556398819,0.60965550773846622,0.75571979277386525,0.89495364134448219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 - July"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 - August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9 - September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 - October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11 - November"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - December"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF($O$9=1,\"You Have Selected the Rural Factor\", \"You Have Selected the Urban Factor\")","v":"You Have Selected the Rural Factor"}]

{"sheet":"16-24 Vehicle C.C.2","index":3,"n_rows":52,"n_cols":30,"rows_kept":52,"cut":false,"hidden":false,"merged":[[53,0,53,1],[0,17,1,29],[1,10,1,11],[2,10,2,11],[9,7,9,8],[10,7,10,8],[12,17,13,29],[17,2,17,6],[18,0,18,8],[19,0,19,8],[51,0,51,8],[52,0,52,1]]}
["16 HR. OR 24 HR. VEHICLE CLASS COUNT EXPANSION WORKSHEET 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Urban Area"]
["SITE NUMBER:",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$2=0,\" \",+'16-24 Vehicle C.C.1'!$B$2)","v":" "},null,null,null,null,"COUNTY:",{"$f":"IF(+Forecast!$H$25=0,\" \",+Forecast!$H$25)","v":""},null,null,"Area type must be selected "]
["SITE DESCRIPTION:",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$3=0,\" \",+'16-24 Vehicle C.C.1'!$B$3)","v":" "},null,null,null,null,null,null,null,null,"for correct adjustment factors",null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["PROJECT SP#:",{"$f":"IF(+Forecast!$H$23=0,\" \",+Forecast!$H$23)","v":" "},null,null,null,null,"YEAR OF COUNT ->:",null,null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.1018185676627199,1.0423996055399734,1.020715235235951,0.98255951109647888,0.9804214302718508,0.95244541007083505,0.90216726525086255,0.8851863968910807,0.84632042908361105,0.97665284468265745,1.0547545544577273,1.1297004186575983]
["MONTH NUMBER OF COUNT:",null,null,null,null,null,"CONSTRAIN AADT ->:",null,null,null,null,null,null,null,null,null,null,"2ASU",0.90263649125519896,0.91520953448461206,0.88096934353246148,0.84331498006255301,0.80495140578982816,0.90779238890720149,0.79842162995687838,0.74639564934170721,0.67424238816764226,0.81108236948338686,0.87806128604032396,0.94976185659471002]
["16 or 24 HR",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.1924856045804944,1.1967811633488727,1.1496917146229904,0.8838166573741878,0.79005604362787696,0.84049043990544692,0.6830196814803593,0.66856166970197961,0.57864519180378138,0.61345269707607175,0.7366804616504824,1.0011650843817974]
["VEHICLE TYPE",null,"RAW COUNT","AADT ADJ FACTOR",null,"ADJUSTED RAW","VEH. TYPE PERCENTS","A.C.F.",null,null,"Note: The URBAN adjustment factors were ",null,null,null,null,null,null,"3A Semi",1.11964778503192,1.0988656878061378,1.0323559840116212,0.90312120328168821,0.83524055323834678,0.85644951312117357,0.78679585454877188,0.67427555927715088,0.66694771051948576,0.88866836853554376,0.82793302695465165,1.0807728582129452]
["CARS AND PICKUPS",null,null,{"$f":"IF(O9=1,IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.31,1.23,1.19,1.06,0.98,0.92,0.84,0.88,0.91,0.95,1.08,1.12)),NA()),IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.08,1.04,1.04,0.97,0.97,0.96,0.91,0.9,0.93,0.88,0.97,1)),NA()))","v":1},null,{"$f":"IF(+I5=0,ROUND(+D8*C8,0),+I5-SUM(F9:F15))","v":0},null,{"$f":"C16/(((C8+C9)*2+(C10+C11)*3+(C12+C14)*4+(C13+C15)*5)/2)","v":{"$error":"#DIV/0!"}},null,null,"developed primarily for use in the Seven",null,null,null,null,null,null,"4A Semi",1.119647785031916,1.0988656878061382,1.0323559840116214,0.90312120328168821,0.83524055323834712,0.85644951312117357,0.7867958545487721,0.67427555927715088,0.66694771051948609,0.88866836853554398,0.82793302695465187,1.0807728582129454]
["2 AXLE 6 TIRE",null,null,{"$f":"IF(O9=1,IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,1.02,0.93,0.96,0.89,0.85,0.87,0.83,0.83,0.76,0.77,0.88,1),IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,0.96,0.88,0.92,0.9,0.89,0.86,0.8,0.76,0.83,0.76,0.79,0.84))","v":1},null,{"$f":"IF(B6=16,ROUND(+D9*C9,0),(IF(B6=24,ROUND(D9*C9,0),#VALUE!)))","v":0},{"$f":"IF(F9=0,0,+F9/F16)","v":0},null,null,null,"County Metropolitan Area.  They can also",null,null,null,1,null,null,"5+A SEMI",0.86942071785393904,0.87769046245725946,0.86475403821150698,0.80940641424647031,0.79229291302650162,0.8333092409344941,0.71498062831051845,0.71083502542786892,0.65989290833686787,0.75058644434637201,0.89675857454450747,0.94138016862075991]
["3+ AXLE SINGLE UNIT",null,null,{"$f":"IF(O9=1,IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.24,1.17,1.12,0.89,0.76,0.71,0.7,0.66,0.65,0.64,0.86,1.09),IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.23,1.16,1.21,0.86,0.75,0.67,0.59,0.54,0.64,0.64,0.8,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D10*C10,0),(IF(B6=24,ROUND(D10*C10,0),#VALUE!)))","v":0},{"$f":"IF(F10=0,0,+F10/F16)","v":0},null,null,null,"be used for other cities with over 5,000 in pop.",null,null,2,2,16,null,"TT/BUS",1.4066146231040682,1.3288036638848086,1.15873877091399,1.0261577176178078,0.93270732951272139,0.86210040919048259,0.77051789867293574,0.6232459159642002,0.58992754026695837,0.77892275431298452,0.88038502237281158,1.1683821812126145]
["3 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D11*C11,0),(IF(B6=24,ROUND(D11*C11,0),#VALUE!)))","v":0},{"$f":"IF(F11=0,0,+F11/F16)","v":0},null,null,null,null,null,null,null,null,24,null,"TWINS",0.89018355801878479,0.84528264938896014,0.82462988286654948,0.75360709179751284,0.77877654317931966,0.91488343699026875,0.83132303327571377,0.72280274769227226,0.69724925390569048,0.75256534869628855,0.88867547548025327,0.88210398706503734]
["4 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D12*C12,0),(IF(B6=24,ROUND(D12*C12,0),#VALUE!)))","v":0},{"$f":"IF(F12=0,0,+F12/F16)","v":0}]
["5+ AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1, IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,0.93,0.86,0.87,0.82,0.79,0.79,0.82,0.78,0.8,0.73,0.87,0.9),IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,1.02,0.99,1,0.79,0.75,0.71,0.69,0.65,0.7,0.76,0.76,0.99))","v":1},null,{"$f":"IF(B6=16,ROUND(+D13*C13,0),(IF(B6=24,ROUND(D13*C13,0),#VALUE!)))","v":0},{"$f":"IF(F13=0,0,+F13/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Rural Area"]
["TR TR, BUSES",null,null,{"$f":"IF(O9=1,IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.6,1.44,1.31,0.99,0.81,0.75,0.67,0.68,0.7,0.68,0.96,1.4),IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.51,1.31,1.19,1.03,0.92,0.82,0.76,0.71,0.74,0.77,0.94,1.07))","v":1},null,{"$f":"IF(B6=16,ROUND(+D14*C14,0),(IF(B6=24,ROUND(D14*C14,0),#VALUE!)))","v":0},{"$f":"IF(F14=0,0,+F14/F16)","v":0}]
["TWIN TRAILERS",null,null,{"$f":"IF(O9=1,IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,0.95,0.86,0.92,0.86,0.86,0.75,0.8,0.76,0.75,0.7,0.82,0.76),IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,1.07,1.02,1.02,0.84,0.78,0.74,0.69,0.65,0.67,0.77,0.93,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D15*C15,0),(IF(B6=24,ROUND(D15*C15,0),#VALUE!)))","v":0},{"$f":"IF(F15=0,0,+F15/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["TOTALS ----------->",null,{"$f":"SUM(C8:C15)","v":0},"-------->",{"$f":"+F16/C16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F8:F15)","v":0},{"$f":"SUM(F9:F15)/F16","v":{"$error":"#DIV/0!"}},"(%HC)",null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.3147434096163959,1.260555415508084,1.2191063204366583,1.1335792360817896,0.96743651827253996,0.88113341055029792,0.80686674313002726,0.83571055323589394,0.94925259857541666,1.0297515161892752,1.1254370827613058,1.1984997233393948]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2ASU",1.0421136678796159,1.0796151955298507,1.073531771489727,0.97003737605495022,0.87660615954238774,0.85182942754266922,0.85051864263193822,0.8291160375969,0.80998807036307507,0.82575550489882676,0.93365664144644978,0.96446600029888474]
[null,null,"DO YOU HAVE THE CORRECT RURAL OR URBAN FACTOR?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.3391976341936089,1.4397711133479576,1.2792395002653094,0.93245159180452619,0.81219085629561705,0.60723176419294977,0.70997757651811144,0.68740797870198267,0.70418899546913249,0.69666824377689318,0.84923786590404304,1.2455765405645749]
[{"$f":"+B2","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - January","3A Semi",1.5740285150379849,1.5407913377030271,1.49264888061556,1.2233547531417996,0.89924025118841999,0.81883527709828285,0.73474864877864943,0.68030211317161005,0.74435725796352192,0.87560862613624846,1.0963565956498842,1.2736579553015599]
[{"$f":"+B3","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - February","4A Semi",1.5740285150379849,1.5407913377030276,1.4926488806155604,1.2233547531418001,0.8992402511884201,0.81883527709828297,0.73474864877864943,0.68030211317161016,0.74435725796352203,0.8756086261362489,1.0963565956498846,1.2736579553015606]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - March","5+A SEMI",0.97742736051615664,0.9048104914965911,0.85990705226462538,0.82063154007684946,0.77787213019245971,0.71713378416711093,0.77320084394568978,0.74712290228442568,0.76375782282762339,0.73921514671402577,0.87755200696696622,0.93105325954953666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - April","TT/BUS",2.0530650919060474,2.0594572192363545,1.5493404798648853,1.1114678000636622,0.87368160419327356,0.74178140463417197,0.70589749299503979,0.66796906328373884,0.70162102278790783,0.78889438143426527,1.0116812496784142,1.575509804412097]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - May","TWINS",1.4200652049607598,0.95161350386861687,0.94147345631703649,0.93602224460982308,0.86013894109429645,0.86659745641719899,0.82948792163548768,0.66127893190165599,0.69357705556398819,0.60965550773846622,0.75571979277386525,0.89495364134448219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 - July"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 - August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9 - September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 - October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11 - November"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - December"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF($O$9=1,\"You Have Selected the Rural Factor\", \"You Have Selected the Urban Factor\")","v":"You Have Selected the Rural Factor"}]

{"sheet":"16-24 Vehicle C.C.3","index":4,"n_rows":52,"n_cols":30,"rows_kept":52,"cut":false,"hidden":false,"merged":[[53,0,53,1],[0,17,1,29],[1,10,1,11],[2,10,2,11],[9,7,9,8],[10,7,10,8],[12,17,13,29],[17,2,17,6],[18,0,18,8],[19,0,19,8],[51,0,51,8],[52,0,52,1]]}
["16 HR. OR 24 HR. VEHICLE CLASS COUNT EXPANSION WORKSHEET 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Urban Area"]
["SITE NUMBER:",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$2=0,\" \",+'16-24 Vehicle C.C.1'!$B$2)","v":" "},null,null,null,null,"COUNTY:",{"$f":"IF(+Forecast!$H$25=0,\" \",+Forecast!$H$25)","v":""},null,null,"Area type must be selected "]
["SITE DESCRIPTION:",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$3=0,\" \",+'16-24 Vehicle C.C.1'!$B$3)","v":" "},null,null,null,null,null,null,null,null,"for correct adjustment factors",null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["PROJECT SP#:",{"$f":"IF(+Forecast!$H$23=0,\" \",+Forecast!$H$23)","v":" "},null,null,null,null,"YEAR OF COUNT ->:",null,null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.1018185676627199,1.0423996055399734,1.020715235235951,0.98255951109647888,0.9804214302718508,0.95244541007083505,0.90216726525086255,0.8851863968910807,0.84632042908361105,0.97665284468265745,1.0547545544577273,1.1297004186575983]
["MONTH NUMBER OF COUNT:",null,null,null,null,null,"CONSTRAIN AADT ->:",null,null,null,null,null,null,null,null,null,null,"2ASU",0.90263649125519896,0.91520953448461206,0.88096934353246148,0.84331498006255301,0.80495140578982816,0.90779238890720149,0.79842162995687838,0.74639564934170721,0.67424238816764226,0.81108236948338686,0.87806128604032396,0.94976185659471002]
["16 or 24 HR",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.1924856045804944,1.1967811633488727,1.1496917146229904,0.8838166573741878,0.79005604362787696,0.84049043990544692,0.6830196814803593,0.66856166970197961,0.57864519180378138,0.61345269707607175,0.7366804616504824,1.0011650843817974]
["VEHICLE TYPE",null,"RAW COUNT","AADT ADJ FACTOR",null,"ADJUSTED RAW","VEH. TYPE PERCENTS","A.C.F.",null,null,"Note: The URBAN adjustment factors were ",null,null,null,null,null,null,"3A Semi",1.11964778503192,1.0988656878061378,1.0323559840116212,0.90312120328168821,0.83524055323834678,0.85644951312117357,0.78679585454877188,0.67427555927715088,0.66694771051948576,0.88866836853554376,0.82793302695465165,1.0807728582129452]
["CARS AND PICKUPS",null,null,{"$f":"IF(O9=1,IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.31,1.23,1.19,1.06,0.98,0.92,0.84,0.88,0.91,0.95,1.08,1.12)),NA()),IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.08,1.04,1.04,0.97,0.97,0.96,0.91,0.9,0.93,0.88,0.97,1)),NA()))","v":1},null,{"$f":"IF(+I5=0,ROUND(+D8*C8,0),+I5-SUM(F9:F15))","v":0},null,{"$f":"C16/(((C8+C9)*2+(C10+C11)*3+(C12+C14)*4+(C13+C15)*5)/2)","v":{"$error":"#DIV/0!"}},null,null,"developed primarily for use in the Seven",null,null,null,null,null,null,"4A Semi",1.119647785031916,1.0988656878061382,1.0323559840116214,0.90312120328168821,0.83524055323834712,0.85644951312117357,0.7867958545487721,0.67427555927715088,0.66694771051948609,0.88866836853554398,0.82793302695465187,1.0807728582129454]
["2 AXLE 6 TIRE",null,null,{"$f":"IF(O9=1,IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,1.02,0.93,0.96,0.89,0.85,0.87,0.83,0.83,0.76,0.77,0.88,1),IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,0.96,0.88,0.92,0.9,0.89,0.86,0.8,0.76,0.83,0.76,0.79,0.84))","v":1},null,{"$f":"IF(B6=16,ROUND(+D9*C9,0),(IF(B6=24,ROUND(D9*C9,0),#VALUE!)))","v":0},{"$f":"IF(F9=0,0,+F9/F16)","v":0},null,null,null,"County Metropolitan Area.  They can also",null,null,null,1,null,null,"5+A SEMI",0.86942071785393904,0.87769046245725946,0.86475403821150698,0.80940641424647031,0.79229291302650162,0.8333092409344941,0.71498062831051845,0.71083502542786892,0.65989290833686787,0.75058644434637201,0.89675857454450747,0.94138016862075991]
["3+ AXLE SINGLE UNIT",null,null,{"$f":"IF(O9=1,IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.24,1.17,1.12,0.89,0.76,0.71,0.7,0.66,0.65,0.64,0.86,1.09),IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.23,1.16,1.21,0.86,0.75,0.67,0.59,0.54,0.64,0.64,0.8,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D10*C10,0),(IF(B6=24,ROUND(D10*C10,0),#VALUE!)))","v":0},{"$f":"IF(F10=0,0,+F10/F16)","v":0},null,null,null,"be used for other cities with over 5,000 in pop.",null,null,2,2,16,null,"TT/BUS",1.4066146231040682,1.3288036638848086,1.15873877091399,1.0261577176178078,0.93270732951272139,0.86210040919048259,0.77051789867293574,0.6232459159642002,0.58992754026695837,0.77892275431298452,0.88038502237281158,1.1683821812126145]
["3 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D11*C11,0),(IF(B6=24,ROUND(D11*C11,0),#VALUE!)))","v":0},{"$f":"IF(F11=0,0,+F11/F16)","v":0},null,null,null,null,null,null,null,null,24,null,"TWINS",0.89018355801878479,0.84528264938896014,0.82462988286654948,0.75360709179751284,0.77877654317931966,0.91488343699026875,0.83132303327571377,0.72280274769227226,0.69724925390569048,0.75256534869628855,0.88867547548025327,0.88210398706503734]
["4 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D12*C12,0),(IF(B6=24,ROUND(D12*C12,0),#VALUE!)))","v":0},{"$f":"IF(F12=0,0,+F12/F16)","v":0}]
["5+ AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1, IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,0.93,0.86,0.87,0.82,0.79,0.79,0.82,0.78,0.8,0.73,0.87,0.9),IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,1.02,0.99,1,0.79,0.75,0.71,0.69,0.65,0.7,0.76,0.76,0.99))","v":1},null,{"$f":"IF(B6=16,ROUND(+D13*C13,0),(IF(B6=24,ROUND(D13*C13,0),#VALUE!)))","v":0},{"$f":"IF(F13=0,0,+F13/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Rural Area"]
["TR TR, BUSES",null,null,{"$f":"IF(O9=1,IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.6,1.44,1.31,0.99,0.81,0.75,0.67,0.68,0.7,0.68,0.96,1.4),IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.51,1.31,1.19,1.03,0.92,0.82,0.76,0.71,0.74,0.77,0.94,1.07))","v":1},null,{"$f":"IF(B6=16,ROUND(+D14*C14,0),(IF(B6=24,ROUND(D14*C14,0),#VALUE!)))","v":0},{"$f":"IF(F14=0,0,+F14/F16)","v":0}]
["TWIN TRAILERS",null,null,{"$f":"IF(O9=1,IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,0.95,0.86,0.92,0.86,0.86,0.75,0.8,0.76,0.75,0.7,0.82,0.76),IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,1.07,1.02,1.02,0.84,0.78,0.74,0.69,0.65,0.67,0.77,0.93,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D15*C15,0),(IF(B6=24,ROUND(D15*C15,0),#VALUE!)))","v":0},{"$f":"IF(F15=0,0,+F15/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["TOTALS ----------->",null,{"$f":"SUM(C8:C15)","v":0},"-------->",{"$f":"+F16/C16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F8:F15)","v":0},{"$f":"SUM(F9:F15)/F16","v":{"$error":"#DIV/0!"}},"(%HC)",null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.3147434096163959,1.260555415508084,1.2191063204366583,1.1335792360817896,0.96743651827253996,0.88113341055029792,0.80686674313002726,0.83571055323589394,0.94925259857541666,1.0297515161892752,1.1254370827613058,1.1984997233393948]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2ASU",1.0421136678796159,1.0796151955298507,1.073531771489727,0.97003737605495022,0.87660615954238774,0.85182942754266922,0.85051864263193822,0.8291160375969,0.80998807036307507,0.82575550489882676,0.93365664144644978,0.96446600029888474]
[null,null,"DO YOU HAVE THE CORRECT RURAL OR URBAN FACTOR?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.3391976341936089,1.4397711133479576,1.2792395002653094,0.93245159180452619,0.81219085629561705,0.60723176419294977,0.70997757651811144,0.68740797870198267,0.70418899546913249,0.69666824377689318,0.84923786590404304,1.2455765405645749]
[{"$f":"+B2","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - January","3A Semi",1.5740285150379849,1.5407913377030271,1.49264888061556,1.2233547531417996,0.89924025118841999,0.81883527709828285,0.73474864877864943,0.68030211317161005,0.74435725796352192,0.87560862613624846,1.0963565956498842,1.2736579553015599]
[{"$f":"+B3","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - February","4A Semi",1.5740285150379849,1.5407913377030276,1.4926488806155604,1.2233547531418001,0.8992402511884201,0.81883527709828297,0.73474864877864943,0.68030211317161016,0.74435725796352203,0.8756086261362489,1.0963565956498846,1.2736579553015606]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - March","5+A SEMI",0.97742736051615664,0.9048104914965911,0.85990705226462538,0.82063154007684946,0.77787213019245971,0.71713378416711093,0.77320084394568978,0.74712290228442568,0.76375782282762339,0.73921514671402577,0.87755200696696622,0.93105325954953666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - April","TT/BUS",2.0530650919060474,2.0594572192363545,1.5493404798648853,1.1114678000636622,0.87368160419327356,0.74178140463417197,0.70589749299503979,0.66796906328373884,0.70162102278790783,0.78889438143426527,1.0116812496784142,1.575509804412097]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - May","TWINS",1.4200652049607598,0.95161350386861687,0.94147345631703649,0.93602224460982308,0.86013894109429645,0.86659745641719899,0.82948792163548768,0.66127893190165599,0.69357705556398819,0.60965550773846622,0.75571979277386525,0.89495364134448219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 - July"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 - August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9 - September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 - October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11 - November"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - December"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF($O$9=1,\"You Have Selected the Rural Factor\", \"You Have Selected the Urban Factor\")","v":"You Have Selected the Rural Factor"}]

{"sheet":"16-24 Vehicle C.C.4","index":5,"n_rows":52,"n_cols":30,"rows_kept":52,"cut":false,"hidden":false,"merged":[[53,0,53,1],[0,17,1,29],[1,10,1,11],[2,10,2,11],[9,7,9,8],[10,7,10,8],[12,17,13,29],[17,2,17,6],[18,0,18,8],[19,0,19,8],[51,0,51,8],[52,0,52,1]]}
["16 HR. OR 24 HR. VEHICLE CLASS COUNT EXPANSION WORKSHEET 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Urban Area"]
["SITE NUMBER:",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$2=0,\" \",+'16-24 Vehicle C.C.1'!$B$2)","v":" "},null,null,null,null,"COUNTY:",{"$f":"IF(+Forecast!$H$25=0,\" \",+Forecast!$H$25)","v":""},null,null,"Area type must be selected "]
["SITE DESCRIPTION:",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$3=0,\" \",+'16-24 Vehicle C.C.1'!$B$3)","v":" "},null,null,null,null,null,null,null,null,"for correct adjustment factors",null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["PROJECT SP#:",{"$f":"IF(+Forecast!$H$23=0,\" \",+Forecast!$H$23)","v":" "},null,null,null,null,"YEAR OF COUNT ->:",null,null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.1018185676627199,1.0423996055399734,1.020715235235951,0.98255951109647888,0.9804214302718508,0.95244541007083505,0.90216726525086255,0.8851863968910807,0.84632042908361105,0.97665284468265745,1.0547545544577273,1.1297004186575983]
["MONTH NUMBER OF COUNT:",null,null,null,null,null,"CONSTRAIN AADT ->:",null,null,null,null,null,null,null,null,null,null,"2ASU",0.90263649125519896,0.91520953448461206,0.88096934353246148,0.84331498006255301,0.80495140578982816,0.90779238890720149,0.79842162995687838,0.74639564934170721,0.67424238816764226,0.81108236948338686,0.87806128604032396,0.94976185659471002]
["16 or 24 HR",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.1924856045804944,1.1967811633488727,1.1496917146229904,0.8838166573741878,0.79005604362787696,0.84049043990544692,0.6830196814803593,0.66856166970197961,0.57864519180378138,0.61345269707607175,0.7366804616504824,1.0011650843817974]
["VEHICLE TYPE",null,"RAW COUNT","AADT ADJ FACTOR",null,"ADJUSTED RAW","VEH. TYPE PERCENTS","A.C.F.",null,null,"Note: The URBAN adjustment factors were ",null,null,null,null,null,null,"3A Semi",1.11964778503192,1.0988656878061378,1.0323559840116212,0.90312120328168821,0.83524055323834678,0.85644951312117357,0.78679585454877188,0.67427555927715088,0.66694771051948576,0.88866836853554376,0.82793302695465165,1.0807728582129452]
["CARS AND PICKUPS",null,null,{"$f":"IF(O9=1,IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.31,1.23,1.19,1.06,0.98,0.92,0.84,0.88,0.91,0.95,1.08,1.12)),NA()),IF(+I5=0,(IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.08,1.04,1.04,0.97,0.97,0.96,0.91,0.9,0.93,0.88,0.97,1)),NA()))","v":1},null,{"$f":"IF(+I5=0,ROUND(+D8*C8,0),+I5-SUM(F9:F15))","v":0},null,{"$f":"C16/(((C8+C9)*2+(C10+C11)*3+(C12+C14)*4+(C13+C15)*5)/2)","v":{"$error":"#DIV/0!"}},null,null,"developed primarily for use in the Seven",null,null,null,null,null,null,"4A Semi",1.119647785031916,1.0988656878061382,1.0323559840116214,0.90312120328168821,0.83524055323834712,0.85644951312117357,0.7867958545487721,0.67427555927715088,0.66694771051948609,0.88866836853554398,0.82793302695465187,1.0807728582129454]
["2 AXLE 6 TIRE",null,null,{"$f":"IF(O9=1,IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,1.02,0.93,0.96,0.89,0.85,0.87,0.83,0.83,0.76,0.77,0.88,1),IF(B6=16,1.08,1)*CHOOSE((C5)+1,1,0.96,0.88,0.92,0.9,0.89,0.86,0.8,0.76,0.83,0.76,0.79,0.84))","v":1},null,{"$f":"IF(B6=16,ROUND(+D9*C9,0),(IF(B6=24,ROUND(D9*C9,0),#VALUE!)))","v":0},{"$f":"IF(F9=0,0,+F9/F16)","v":0},null,null,null,"County Metropolitan Area.  They can also",null,null,null,1,null,null,"5+A SEMI",0.86942071785393904,0.87769046245725946,0.86475403821150698,0.80940641424647031,0.79229291302650162,0.8333092409344941,0.71498062831051845,0.71083502542786892,0.65989290833686787,0.75058644434637201,0.89675857454450747,0.94138016862075991]
["3+ AXLE SINGLE UNIT",null,null,{"$f":"IF(O9=1,IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.24,1.17,1.12,0.89,0.76,0.71,0.7,0.66,0.65,0.64,0.86,1.09),IF(B6=16,1.07,1)*CHOOSE((C5)+1,1,1.23,1.16,1.21,0.86,0.75,0.67,0.59,0.54,0.64,0.64,0.8,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D10*C10,0),(IF(B6=24,ROUND(D10*C10,0),#VALUE!)))","v":0},{"$f":"IF(F10=0,0,+F10/F16)","v":0},null,null,null,"be used for other cities with over 5,000 in pop.",null,null,2,2,16,null,"TT/BUS",1.4066146231040682,1.3288036638848086,1.15873877091399,1.0261577176178078,0.93270732951272139,0.86210040919048259,0.77051789867293574,0.6232459159642002,0.58992754026695837,0.77892275431298452,0.88038502237281158,1.1683821812126145]
["3 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D11*C11,0),(IF(B6=24,ROUND(D11*C11,0),#VALUE!)))","v":0},{"$f":"IF(F11=0,0,+F11/F16)","v":0},null,null,null,null,null,null,null,null,24,null,"TWINS",0.89018355801878479,0.84528264938896014,0.82462988286654948,0.75360709179751284,0.77877654317931966,0.91488343699026875,0.83132303327571377,0.72280274769227226,0.69724925390569048,0.75256534869628855,0.88867547548025327,0.88210398706503734]
["4 AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1,IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.25,1.15,1.11,0.97,0.84,0.77,0.72,0.72,0.72,0.83,1.07,1.25),IF(B6=16,1.1,1)*CHOOSE((C5)+1,1,1.24,1.18,1.02,0.88,0.86,0.8,0.74,0.7,0.72,0.71,0.87,1.17))","v":1},null,{"$f":"IF(B6=16,ROUND(+D12*C12,0),(IF(B6=24,ROUND(D12*C12,0),#VALUE!)))","v":0},{"$f":"IF(F12=0,0,+F12/F16)","v":0}]
["5+ AXLE SEMI (TST)",null,null,{"$f":"IF(O9=1, IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,0.93,0.86,0.87,0.82,0.79,0.79,0.82,0.78,0.8,0.73,0.87,0.9),IF(B6=16,1.17,1)*CHOOSE((C5)+1,1,1.02,0.99,1,0.79,0.75,0.71,0.69,0.65,0.7,0.76,0.76,0.99))","v":1},null,{"$f":"IF(B6=16,ROUND(+D13*C13,0),(IF(B6=24,ROUND(D13*C13,0),#VALUE!)))","v":0},{"$f":"IF(F13=0,0,+F13/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"New Seasonal Adjustment Factors For Rural Area"]
["TR TR, BUSES",null,null,{"$f":"IF(O9=1,IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.6,1.44,1.31,0.99,0.81,0.75,0.67,0.68,0.7,0.68,0.96,1.4),IF(B6=16,1.09,1)*CHOOSE((C5)+1,1,1.51,1.31,1.19,1.03,0.92,0.82,0.76,0.71,0.74,0.77,0.94,1.07))","v":1},null,{"$f":"IF(B6=16,ROUND(+D14*C14,0),(IF(B6=24,ROUND(D14*C14,0),#VALUE!)))","v":0},{"$f":"IF(F14=0,0,+F14/F16)","v":0}]
["TWIN TRAILERS",null,null,{"$f":"IF(O9=1,IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,0.95,0.86,0.92,0.86,0.86,0.75,0.8,0.76,0.75,0.7,0.82,0.76),IF(B6=16,1.3,1)*CHOOSE((C5)+1,1,1.07,1.02,1.02,0.84,0.78,0.74,0.69,0.65,0.67,0.77,0.93,1.09))","v":1},null,{"$f":"IF(B6=16,ROUND(+D15*C15,0),(IF(B6=24,ROUND(D15*C15,0),#VALUE!)))","v":0},{"$f":"IF(F15=0,0,+F15/F16)","v":0},null,null,null,null,null,null,null,null,null,null,"Body Type","Jan ","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["TOTALS ----------->",null,{"$f":"SUM(C8:C15)","v":0},"-------->",{"$f":"+F16/C16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F8:F15)","v":0},{"$f":"SUM(F9:F15)/F16","v":{"$error":"#DIV/0!"}},"(%HC)",null,null,null,null,null,null,null,null,null,"CARS+PICKUP",1.3147434096163959,1.260555415508084,1.2191063204366583,1.1335792360817896,0.96743651827253996,0.88113341055029792,0.80686674313002726,0.83571055323589394,0.94925259857541666,1.0297515161892752,1.1254370827613058,1.1984997233393948]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2ASU",1.0421136678796159,1.0796151955298507,1.073531771489727,0.97003737605495022,0.87660615954238774,0.85182942754266922,0.85051864263193822,0.8291160375969,0.80998807036307507,0.82575550489882676,0.93365664144644978,0.96446600029888474]
[null,null,"DO YOU HAVE THE CORRECT RURAL OR URBAN FACTOR?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3+ASU",1.3391976341936089,1.4397711133479576,1.2792395002653094,0.93245159180452619,0.81219085629561705,0.60723176419294977,0.70997757651811144,0.68740797870198267,0.70418899546913249,0.69666824377689318,0.84923786590404304,1.2455765405645749]
[{"$f":"+B2","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - January","3A Semi",1.5740285150379849,1.5407913377030271,1.49264888061556,1.2233547531417996,0.89924025118841999,0.81883527709828285,0.73474864877864943,0.68030211317161005,0.74435725796352192,0.87560862613624846,1.0963565956498842,1.2736579553015599]
[{"$f":"+B3","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - February","4A Semi",1.5740285150379849,1.5407913377030276,1.4926488806155604,1.2233547531418001,0.8992402511884201,0.81883527709828297,0.73474864877864943,0.68030211317161016,0.74435725796352203,0.8756086261362489,1.0963565956498846,1.2736579553015606]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - March","5+A SEMI",0.97742736051615664,0.9048104914965911,0.85990705226462538,0.82063154007684946,0.77787213019245971,0.71713378416711093,0.77320084394568978,0.74712290228442568,0.76375782282762339,0.73921514671402577,0.87755200696696622,0.93105325954953666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - April","TT/BUS",2.0530650919060474,2.0594572192363545,1.5493404798648853,1.1114678000636622,0.87368160419327356,0.74178140463417197,0.70589749299503979,0.66796906328373884,0.70162102278790783,0.78889438143426527,1.0116812496784142,1.575509804412097]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - May","TWINS",1.4200652049607598,0.95161350386861687,0.94147345631703649,0.93602224460982308,0.86013894109429645,0.86659745641719899,0.82948792163548768,0.66127893190165599,0.69357705556398819,0.60965550773846622,0.75571979277386525,0.89495364134448219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 - July"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 - August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9 - September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 - October"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11 - November"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - December"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF($O$9=1,\"You Have Selected the Rural Factor\", \"You Have Selected the Urban Factor\")","v":"You Have Selected the Rural Factor"}]

{"sheet":"New Avg Vehicle C.C.","index":6,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,12],[25,10,25,11],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9]]}
["Vehicle Class Count Averages Worksheet"]
["VCC Site Num.",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$2=0,\" \",+'16-24 Vehicle C.C.1'!$B$2)","v":" "}]
[{"$f":"Forecast!C22","v":0},{"$f":"IF(Forecast!C23=0,\" \",Forecast!C23)","v":" "}]
["Description",{"$f":"IF(+'16-24 Vehicle C.C.1'!$B$3=0,\" \",'16-24 Vehicle C.C.1'!$B$3)","v":" "}]
[]
[null,null,"16-24 Vehicle C.C.1",null,"16-24 Vehicle C.C.2",null,"16-24 Vehicle C.C.3",null,"16-24 Vehicle C.C.4"]
[null,"Type","Year","Pct","Year","Pct","Year","Pct","Year","Pct","Avg","Avg",""]
[null,null,{"$f":"+'16-24 Vehicle C.C.1'!$I$4","v":0},null,{"$f":"+'16-24 Vehicle C.C.2'!$I$4","v":0},null,{"$f":"+'16-24 Vehicle C.C.3'!$I$4","v":0},null,{"$f":"+'16-24 Vehicle C.C.4'!$I$4","v":0},null,"Truck","Vehicle"]
[null,"Man/Tube",{"$f":"+IF('16-24 Vehicle C.C.1'!$B$6=16,\"Manual\",IF('16-24 Vehicle C.C.1'!$B$6=24,\"tube\",0))","v":"tube"},null,{"$f":"+IF('16-24 Vehicle C.C.2'!$B$6=16,\"Manual\",IF('16-24 Vehicle C.C.2'!$B$6=24,\"tube\",0))","v":"tube"},null,{"$f":"+IF('16-24 Vehicle C.C.3'!$B$6=16,\"Manual\",IF('16-24 Vehicle C.C.3'!$B$6=24,\"tube\",0))","v":"tube"},null,{"$f":"+IF('16-24 Vehicle C.C.4'!$B$6=16,\"Manual\",IF('16-24 Vehicle C.C.4'!$B$6=24,\"tube\",0))","v":"tube"},null,"Volumes","Pctages"]
[1,"Cars",{"$f":"+'16-24 Vehicle C.C.1'!$F8","v":0},{"$f":"C10/C$18","v":{"$error":"#DIV/0!"}},{"$f":"+'16-24 Vehicle C.C.2'!$F8","v":0},{"$f":"E10/E$18","v":{"$error":"#DIV/0!"}},{"$f":"+'16-24 Vehicle C.C.3'!$F8","v":0},{"$f":"G10/G$18","v":{"$error":"#DIV/0!"}},{"$f":"+'16-24 Vehicle C.C.4'!$F8","v":0},{"$f":"I10/I$18","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C10,E10,G10,I10)","v":0},{"$f":"AVERAGE(D10:D10,F10:F10,H10:H10,J10:J10)","v":{"$error":"#DIV/0!"}}]
[2,"2 ASU",{"$f":"+'16-24 Vehicle C.C.1'!$F9","v":0},{"$f":"C11/C$18","v":{"$error":"#DIV/0!"}},{"$f":"+'16-24 Vehicle C.C.2'!$F9","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.3'!$F9","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.4'!$F9","v":0},{"$f":"I11/I$18","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C11:C11,E11:E11,G11:G11,I11:I11)","v":0},{"$f":"AVERAGE(D11:D11,F11:F11,H11:H11,J11:J11)","v":{"$error":"#DIV/0!"}}]
[3,"3+ASU",{"$f":"+'16-24 Vehicle C.C.1'!$F10","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.2'!$F10","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.3'!$F10","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.4'!$F10","v":0},{"$error":"#DIV/0!"},{"$f":"AVERAGE(C12:C12,E12:E12,G12:G12,I12:I12)","v":0},{"$f":"AVERAGE(D12:D12,F12:F12,H12:H12,J12:J12)","v":{"$error":"#DIV/0!"}}]
[4,"3ASemi",{"$f":"+'16-24 Vehicle C.C.1'!$F11","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.2'!$F11","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.3'!$F11","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.4'!$F11","v":0},{"$error":"#DIV/0!"},0,{"$f":"AVERAGE(D13:D13,F13:F13,H13:H13,J13:J13)","v":{"$error":"#DIV/0!"}}]
[5,"4ASemi",{"$f":"+'16-24 Vehicle C.C.1'!$F12","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.2'!$F12","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.3'!$F12","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.4'!$F12","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[6,"5+Asemi",{"$f":"+'16-24 Vehicle C.C.1'!$F13","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.2'!$F13","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.3'!$F13","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.4'!$F13","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[7,"TT/BUS",{"$f":"+'16-24 Vehicle C.C.1'!$F14","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.2'!$F14","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.3'!$F14","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.4'!$F14","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[8,"Twins",{"$f":"+'16-24 Vehicle C.C.1'!$F15","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.2'!$F15","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.3'!$F15","v":0},{"$error":"#DIV/0!"},{"$f":"+'16-24 Vehicle C.C.4'!$F15","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["Total",null,{"$f":"SUM(C10:C17)","v":0},{"$f":"SUM(D11:D17)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E10:E17)","v":0},{"$f":"SUM(F11:F17)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G10:G17)","v":0},{"$f":"SUM(H11:H17)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I10:I17)","v":0},{"$f":"SUM(J11:J17)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["Total Heavy Comm",null,{"$f":"SUM(C11:C17)","v":0},null,{"$f":"SUM(E11:E17)","v":0},null,{"$f":"SUM(G11:G17)","v":0},null,{"$f":"SUM(I11:I17)","v":0},null,{"$f":"AVERAGE(C19:C19,E19:E19,G19:G19,I19:I19)","v":0},{"$f":"SUM(L10:L17)","v":{"$error":"#DIV/0!"}}]
["Heavy 5+ Ax Semi*",null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(C20:J20)","v":{"$error":"#DIV/0!"}}]
["Axle Corr Factor",null,null,{"$f":"+'16-24 Vehicle C.C.1'!H8","v":{"$error":"#DIV/0!"}},null,{"$f":"+'16-24 Vehicle C.C.2'!H8","v":{"$error":"#DIV/0!"}},null,{"$f":"+'16-24 Vehicle C.C.3'!H8","v":{"$error":"#DIV/0!"}},null,{"$f":"+'16-24 Vehicle C.C.4'!H8","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(C21:J21)","v":{"$error":"#DIV/0!"}}]
[]
["*    Heavy 5+ Ax Semi = Tank, Dump, Grain,and Stake Loaded",null,null,null,null,null,null,null,null,null,"Heavy 5 Axle Semi Split"]
["      When the Tank, Dumps, & Grains and loaded stakes are 30% or more of the",null,null,null,null,null,null,null,null,null,{"$f":"$L$15*$L$20","v":{"$error":"#DIV/0!"}},"Max"]
["      5 axle semis, then split into max and other categories (AUTOMATICALLY DONE) ----------->",null,null,null,null,null,null,null,null,null,{"$f":"$L$15-$K$24","v":{"$error":"#DIV/0!"}},"Others"]
["     Check out tube counts prior to 1996 carefully, body types are N/A prior to 1982, don't use tube",null,null,null,null,null,null,null,null,null,{"$f":"IF(L20<30%,\"DON'T SPLIT\",\"SPLIT\")","v":{"$error":"#DIV/0!"}}]
["      collected previous to 1990."]
[]
["NOTE:  IF LESS THAN 4 ENTRIES, BE SURE "]
["TO DELETE YEAR AND PCT COLUMN"]
["DO NOT USE 0, LEAVE BLANK."]
["USER MUST THEN COPY THE FORMULA IN THE"]
["PCT COLUMNS BACK TO THE APPROPRIATE COLUMN"]

{"sheet":"Least Squares","index":7,"n_rows":261,"n_cols":21,"rows_kept":261,"cut":false,"hidden":false,"merged":[[57,0,57,9],[52,1,52,2],[52,5,52,6],[1,1,1,2],[1,4,1,5],[29,6,29,7],[51,1,51,2],[51,3,51,4],[52,3,52,4],[35,6,35,7],[46,6,46,7],[45,6,45,7]]}
["LEAST SQUARES WORKSHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"max",{"$f":"IF(B34>2,MAX(P32:P55),1)","v":1},{"$f":"R1","v":1},null,{"$f":"S2+200","v":200}]
["ROUTE:",{"$f":"CONCATENATE('New Avg Vehicle C.C.'!A3,\" \",'New Avg Vehicle C.C.'!B3)","v":"0  "},null,"SP#:",{"$f":"IF(+Forecast!H23=0,\" \",Forecast!H23)","v":" "},null,"DATE",{"$f":"+Forecast!C10","v":"2013-02-15T09:32:49.330"},null,null,null,null,null,null,null,null,"min",{"$f":"MIN(B7:B17)","v":0},{"$f":"R2","v":0}]
["LOCATION:",null,null,null,null,null,null,""]
["BASE YEAR:",null,null,null,"  FORECAST YEAR:",{"$f":"B4+20","v":20}]
[]
["YEAR","FLOW MAP AADT (SEG A)"]
[1990]
[1992]
[1994]
[1996]
[1998,null,null,null," "]
[2000]
[2002]
[2004]
[2006]
[2008]
[2010]
[]
[]
[]
[]
[]
["_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________"]
["LEAST SQUARES BASED FORECASTS:"]
["Year","AADT    (Seg. A)",null,"Calc","ADT Calc"]
[{"$f":"MAX(A7:A22)","v":2010},{"$f":"IF(A26=0,NA,10*ROUND((($A$26*B$32)+B$33)/10,0))","v":0},null,{"$f":"VLOOKUP(A26,$A$17:$B$22,2,FALSE)-B26","v":0},{"$f":"B26+D26","v":0}]
[{"$f":"B4","v":0},{"$f":"IF(B34=0,NA,10*ROUND((($A$27*B$32)+B$33)/10,0))","v":{"$error":"#NAME?"}},null,null,{"$f":"B27+D26","v":{"$error":"#NAME?"}}]
[{"$f":"F4","v":20},{"$f":"IF(G37=0,NA,10*ROUND((($A$28*B$32)+B$33)/10,0))","v":{"$error":"#NAME?"}},null,null,{"$f":"B28+D26","v":{"$error":"#NAME?"}}]
["_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________"]
["Statistics","AADT       (Seg. A)"]
["R 2",{"$f":"((A120-(SUM(A62:A78)*SUM(B7:B22))/A60)/SQRT((A101-((SUM(A62:A78))^2)/A60)*(C101-((SUM(B7:B22))^2)/A60)))^2","v":{"$error":"#DIV/0!"}},null,null,null,null,"YEAR","AADT"]
["SLOPE",{"$f":"IF(+B4=0,0,((A60*A120-SUM(A62:A78)*SUM(B7:B22))/(A60*A101-(SUM(A62:A78)^2))))","v":0},null,null,null,null,{"$f":"A26","v":2010},{"$f":"+ROUND(E26,-2)","v":0},null,null,null,null,null,null,{"$f":"IF(P32=\" \", ,A7)","v":0},{"$f":"IF(B7=0,\" \",B7)","v":" "}]
["INTERCEPT",{"$f":"IF(+B4=0,0,+((SUM(B7:B22)*A101-SUM(A62:A78)*A120)/(A60*A101-(SUM(A62:A78)^2))))","v":0},null,null,null,null,{"$f":"A27","v":0},{"$f":"+ROUND(E27,-2)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"IF(P33=\" \",0,A8)","v":0},{"$f":"IF(B8=0,\" \",B8)","v":" "}]
["N",{"$f":"A60","v":0},null,null,null,null,{"$f":"A28","v":20},{"$f":"ROUND(IF(G37<0,H32*(1+1%*20),IF(G37<0,+ROUND(H32*(1+0.005*(F4-B4)),-2),+ROUND(E28,-2))),-2)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,"Slope Over Base Year",null,null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,{"$f":"B32/H33","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,null,null,null,null,null," ",null,null,0," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(B16=0,\" \",B16)","v":" "}]
[null,null,null,null,null,null,"YEAR","AADT",null,null,null,null,null,null,0," ",{"$f":"H43","v":0}]
[null,null,null,null,null,null,{"$f":"A26","v":2010},{"$f":"H32","v":0},null,null,null,null,null,null,{"$f":"VALUE(G33)","v":0},{"$f":"H33","v":{"$error":"#NAME?"}},{"$f":"H44","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,{"$f":"A27","v":0},{"$f":"ROUND(((H45-H43)/(G45-G43)*(G44-G43)+H43)/50,0)*50","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"VALUE(O43+2)","v":2},{"$f":"($P$53-$P$43)/($O$53-$O$43)*(O44-$O$43)+$P$43","v":{"$error":"#NAME?"}},{"$f":"($Q$53-$Q$43)/($O$53-$O$43)*(O44-$O$43)+$Q$43","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,{"$f":"A28","v":20},{"$f":"ROUND(H33*(1+G48*20)/50,0)*50","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"VALUE(O44+2)","v":4},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,"Slope Over Base Year",null,null,null,null,null,null,null,8,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,{"$f":"IF(G37*D53<=0.5%,0.5%,G37*D53)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,10,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,"COUNTY",null,"COUNTY FACTOR",null,"GROWTH PROFILE",null,null,null,null,null,null,null,null,{"$f":"VALUE(O51+2)","v":18},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$f":"UPPER(VLOOKUP(Forecast!H25,'Least Squares'!$A$174:$C$261,1,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(Forecast!H25,'Least Squares'!$A$174:$C$261,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"UPPER(VLOOKUP(Forecast!H25,'Least Squares'!$A$174:$C$261,3,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"VALUE(O52+2)","v":20},{"$f":"H34","v":{"$error":"#NAME?"}},{"$f":"IF(G48<0,I45,H45)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________","_______________________",null,null,null,null,null,{"$f":"O53+6","v":26}]
[]
["LEAST SQUARES WORK AREA"]
["NADT1"]
[{"$f":"COUNTA(B7:B22)","v":0}]
["YRADT1"]
[{"$f":"IF(B7=0,0,A7)","v":0},{"$f":"IF(A62=0,1,0)","v":1}]
[{"$f":"IF(B8=0,0,A8)","v":0},{"$f":"IF(A63=0,1,0)","v":1}]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[0,1]
[]
["COUNT ABOVE",null,"COUNT ABOVE"]
[{"$f":"COUNTA(A62:A77)","v":16},null,{"$f":"COUNT(B7:B17)","v":0}]
["AVG ABOVE  NON \"0\"",null,"AVG ABOVE  NON \"0\""]
[{"$f":"SUM(A62:A77)/(A80-SUM(B62:B77))","v":{"$error":"#DIV/0!"}}]
["YEARS^2","----->","ADTS1^2"]
[{"$f":"A62^2","v":0},null,{"$f":"B7^2","v":0}]
[{"$f":"A63^2","v":0},null,{"$f":"B8^2","v":0}]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
[0,null,0]
["SUM YR 2",null,"SUM ADT 2"]
[{"$f":"SUM(A84:A99)","v":0},null,{"$f":"SUM(C84:C99)","v":0}]
["YR*ADT1"]
[{"$f":"B7*A62","v":0}]
[{"$f":"B8*A63","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
["SUMA1*YR"]
[{"$f":"SUM(A103:A118)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["County","Factor","Area Type"]
["Aitkin",0.95,"High Growth Area"]
["Anoka",0.95,"High Growth Area"]
["Becker",0.93873396087730454,"Medium Growth Area"]
["Beltrami",0.95,"High Growth Area"]
["Benton",0.95,"High Growth Area"]
["Big Stone",0.89447592017127719,"Low Growth Area"]
["Blue Earth",0.75,"Medium Growth Area"]
["Brown",0.78969226588867858,"Low Growth Area"]
["Carlton",0.95,"Medium Growth Area"]
["Carver",0.95,"High Growth Area"]
["Cass",0.95,"High Growth Area"]
["Chippewa",0.87331044336148567,"Low Growth Area"]
["Chisago",0.88127983695119472,"High Growth Area"]
["Clay",0.75,"Low Growth Area"]
["Clearwater",0.84382342182931469,"Low Growth Area"]
["Cook",0.75,"Medium Growth Area"]
["Cottonwood",0.83317056959686586,"Low Growth Area"]
["Crow Wing",0.88323126455254153,"High Growth Area"]
["Dakota",0.85474219621715841,"High Growth Area"]
["Dodge",0.95,"High Growth Area"]
["Douglas",0.88738319575257085,"High Growth Area"]
["Faribault",0.86598112098365787,"Low Growth Area"]
["Fillmore",0.88960614184298614,"Low Growth Area"]
["Freeborn",0.75555282701061066,"Low Growth Area"]
["Goodhue",0.92736479871937938,"Medium Growth Area"]
["Grant",0.75,"Low Growth Area"]
["Hennepin",0.82725664222459405,"Low Growth Area"]
["Houston",0.83780152255891194,"Low Growth Area"]
["Hubbard",0.83462051375287627,"High Growth Area"]
["Isanti",0.95,"High Growth Area"]
["Itasca",0.88867168489288284,"Medium Growth Area"]
["Jackson",0.91806262484062329,"Medium Growth Area"]
["Kanabec",0.81358389223210814,"Medium Growth Area"]
["Kandiyohi",0.89384198311405494,"Medium Growth Area"]
["Kittson",0.80243584578634863,"Low Growth Area"]
["Koochiching",0.79374895490018815,"Low Growth Area"]
["Lac qui Parle",0.75,"Low Growth Area"]
["Lake",0.85629191359199075,"Low Growth Area"]
["Lake of the Woods",0.91388628166776253,"Low Growth Area"]
["Le Sueur",0.95,"Medium Growth Area"]
["Lincoln",0.88574499912266458,"Low Growth Area"]
["Lyon",0.75,"Low Growth Area"]
["Mahnomen",0.75,"Low Growth Area"]
["Marshall",0.95,"Low Growth Area"]
["Martin",0.82013036036756282,"Low Growth Area"]
["McLeod",0.89281641057236028,"Medium Growth Area"]
["Meeker",0.92611141102997574,"Medium Growth Area"]
["Mille Lacs",0.95,"High Growth Area"]
["Morrison",0.94956947120414292,"Medium Growth Area"]
["Mower",0.83029784586639388,"Low Growth Area"]
["Murray",0.83872472105224793,"Medium Growth Area"]
["Nicollet",0.82400139334223987,"Medium Growth Area"]
["Nobles",0.75499600931341793,"Low Growth Area"]
["Norman",0.80224479617449751,"Low Growth Area"]
["Olmsted",0.95,"High Growth Area"]
["Otter Tail",0.86140262845136861,"Medium Growth Area"]
["Pennington",0.95,"Medium Growth Area"]
["Pine",0.84487766588871849,"High Growth Area"]
["Pipestone",0.75,"Low Growth Area"]
["Polk",0.75,"Low Growth Area"]
["Pope",0.90290746427640389,"Medium Growth Area"]
["Ramsey",0.80878581085549095,"Low Growth Area"]
["Red Lake",0.95,"Medium Growth Area"]
["Redwood",0.75,"Low Growth Area"]
["Renville",0.84802514757711567,"Low Growth Area"]
["Rice",0.82200401622755881,"Medium Growth Area"]
["Rock",0.75,"Low Growth Area"]
["Roseau",0.88475171975423528,"Medium Growth Area"]
["Scott",0.95,"High Growth Area"]
["Sherburne",0.95,"High Growth Area"]
["Sibley",0.86465490651289234,"Medium Growth Area"]
["St. Louis",0.85077785496337155,"Low Growth Area"]
["Stearns",0.85861203780260431,"High Growth Area"]
["Steele",0.88486642092733336,"Medium Growth Area"]
["Stevens",0.79995671134297652,"Low Growth Area"]
["Swift",0.87064293805673265,"Low Growth Area"]
["Todd",0.89887080256358043,"Medium Growth Area"]
["Traverse",0.76522789525578694,"Low Growth Area"]
["Wabasha",0.81824784694731301,"Low Growth Area"]
["Wadena",0.95,"Medium Growth Area"]
["Waseca",0.79630733552471189,"Low Growth Area"]
["Washington",0.95,"High Growth Area"]
["Watonwan",0.75,"Low Growth Area"]
["Wilkin",0.75,"Low Growth Area"]
["Winona",0.82840125387816577,"Low Growth Area"]
["Wright",0.95,"High Growth Area"]
["Yellow Medicine",0.87807134546380905,"Low Growth Area"]

{"sheet":"Cumesal-A","index":8,"n_rows":98,"n_cols":9,"rows_kept":98,"cut":false,"hidden":false,"merged":[[29,4,29,5]]}
["CUMULATIVE ESALS WORKSHEET",null,null,"SEGMENT A"]
["    SP#:",{"$f":"IF(+Forecast!H23=0,\" \",+Forecast!H23)","v":" "}]
["ROUTE:",{"$f":"'Least Squares'!B2:C2","v":"0  "},"# LANES:",null,"   DATE: ",{"$f":"+Forecast!C10","v":"2013-02-15T09:32:49.330"}]
["LOCATION:"]
["VCL SITE #:",{"$f":"+'New Avg Vehicle C.C.'!B2","v":" "}]
[null,"YEAR","AADT","INIT CALC HCADT","CONSTRN HCADT","INIT CALC 5AX TST","CONSTRAIN 5AX TST"]
["VEH.CLASS YR.:",null,null,{"$f":"IF(C7=\"NA\",\"NA\",10*ROUND((SUM(B13:B21)*C7/10),0))","v":{"$error":"#DIV/0!"}},0,"---","---"]
["BASE YEAR:",{"$f":"+'Least Squares'!B4","v":0},null,{"$f":"10*ROUND(SUM(B13:B21)*C8/10,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(SUM(B17:B19)*C8,0)","v":{"$error":"#DIV/0!"}}]
["FORECAST YEAR:",{"$f":"'Least Squares'!F4","v":20},null,{"$f":"10*ROUND(SUM(F13:F21)*C9/10,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(SUM(F17:F19)*C9,0)","v":{"$error":"#DIV/0!"}}]
[]
["BASE YEAR PROPORTIONS",null,null," BASE YR. VOLUME "," % TREND","FORECAST %","FUTURE VOL."]
["------------------------------------","------------------------------------","------------------------------------","------------------------------------","------------------------------------","------------------------------------","------------------------------------"]
["2AX-6TIRE SU",{"$f":"+'New Avg Vehicle C.C.'!L11","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(IF(AND($G$8>0,$E$8>0),(B13/(SUM($B$13:$B$21)-SUM($B$17:$B$19)))*($E$8-$G$8),IF(AND($G$8>0,$E$8=0),(B13/(SUM($B$13:$B$21)-SUM($B$17:$B$19)))*($D$8-$G$8),IF(AND($G$8=0,$E$8>0),(B13/SUM($B$13:$B$21))*$E$8,(B13/SUM($B$13:$B$21))*$D$8))),0)","v":{"$error":"#DIV/0!"}},1,{"$f":"E13*B13","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F13/(SUM(B13:B21)-SUM(F13:F21)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F13/(SUM(B13:B21)-SUM(F13:F21)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F13/SUM(B13:B21))*$E$9,(F13/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["3AX+ SU",{"$f":"+'New Avg Vehicle C.C.'!L12","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$f":"E14*B14","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F14/(SUM(B13:B21)-SUM(F14:F22)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F14/(SUM(B13:B21)-SUM(F14:F22)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F14/SUM(B13:B21))*$E$9,(F14/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["3AX TST",{"$f":"+'New Avg Vehicle C.C.'!L13","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F15/(SUM(B13:B21)-SUM(F15:F23)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F15/(SUM(B13:B21)-SUM(F15:F23)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F15/SUM(B13:B21))*$E$9,(F15/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["4AX TST",{"$f":"+'New Avg Vehicle C.C.'!L14","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F16/(SUM(B13:B21)-SUM(F16:F24)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F16/(SUM(B13:B21)-SUM(F16:F24)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F16/SUM(B13:B21))*$E$9,(F16/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["5AX+ TST",{"$f":"+IF('New Avg Vehicle C.C.'!L20<0.3,'New Avg Vehicle C.C.'!L15,\"0\")","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F17/(SUM(B13:B21)-SUM(F17:F25)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F17/(SUM(B13:B21)-SUM(F17:F25)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F17/SUM(B13:B21))*$E$9,(F17/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["(5AX+ TST MAX)",{"$f":"+IF('New Avg Vehicle C.C.'!L20>=0.3,'New Avg Vehicle C.C.'!K24,\"0\")","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F18/(SUM(B13:B21)-SUM(F18:F26)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F18/(SUM(B13:B21)-SUM(F18:F26)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F18/SUM(B13:B21))*$E$9,(F18/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["(5AX+ TST OTH)",{"$f":"+IF('New Avg Vehicle C.C.'!L20>=0.3,'New Avg Vehicle C.C.'!K25,\"0\")","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F19/(SUM(B13:B21)-SUM(F19:F27)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F19/(SUM(B13:B21)-SUM(F19:F27)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F19/SUM(B13:B21))*$E$9,(F19/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["TR TR, BUSES",{"$f":"+'New Avg Vehicle C.C.'!L16","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F20/(SUM(B13:B21)-SUM(F20:F28)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F20/(SUM(B13:B21)-SUM(F20:F28)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F20/SUM(B13:B21))*$E$9,(F20/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["TWIN TRAILERS",{"$f":"+'New Avg Vehicle C.C.'!L17","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},1,{"$error":"#DIV/0!"},{"$f":"ROUND(IF(AND($G$9>0,$E$9>0),(F21/(SUM(B13:B21)-SUM(F21:F29)))*($E$9-$G$9),IF(AND($G$9>0,$E$9=0),(F21/(SUM(B13:B21)-SUM(F21:F29)))*($D$9-$G$9),IF(AND($G$9=0,$E$9>0),(F21/SUM(B13:B21))*$E$9,(F21/SUM(B13:B21))*$D$9))),0)","v":{"$error":"#DIV/0!"}}]
["------------------------------------","------------------------------------","------------------------------------","------------------------------------","------------------------------------","------------------------------------","------------------------------------"," "]
["SUMMARIES:",null,"AADT","HCADT","HCADT %",{"$f":"A26-A25","v":20},"YR DESIGN"]
[{"$f":"B7","v":0},"   COUNT:",{"$f":"C7","v":0},{"$f":"D7","v":{"$error":"#DIV/0!"}},{"$f":"IF(C24=\"NA\",\"NA\",+D24/C24)","v":{"$error":"#DIV/0!"}},"   LANE CUMULATIVE ESAL   "]
[{"$f":"B8","v":0},"FORECAST:",{"$f":"C8","v":0},{"$f":"IF(E8>0,E8,D8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E8>0,E8,D8)/C25","v":{"$error":"#DIV/0!"}},"|","|",null,{"$f":"30/815","v":3.6809815950920248E-2}]
[{"$f":"B9","v":20},"FORECAST:",{"$f":"C9","v":0},{"$f":"IF(E9>0,E9,D9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E9>0,E9,D9)/C26","v":{"$error":"#DIV/0!"}},"*****************","*****************"]
[null,null,null,null,null,"FLEXIBLE","RIGID"]
["DESIGN LANE FACTOR:",null,{"$f":"CHOOSE((D3)+1,#VALUE!,1,0.5,0.5,0.45,0.45,0.35,0.35)","v":{"$error":"#VALUE!"}},null,null,{"$f":"1000*ROUND(IF((C63-1)+1>29,CHOOSE(C63,F92,F93,F94,F95,F96,F97,F98),CHOOSE(C63,F63,F64,F65,F66,F67,F68,F69,F70,F71,F72,F73,F74,F75,F76,F77,F78,F79,F80,F81,F82,F83,F84,F85,F86,F87,F88,F89,F90,F91))*1.12/1000,0)","v":{"$error":"#DIV/0!"}},{"$f":"1000*ROUND(IF((C63-1)+1>29,CHOOSE((C63-1)+1,G92,G93,G94,G95,G96,G97,G98),CHOOSE(C63,G63,G64,G65,G66,G67,G68,G69,G70,G71,G72,G73,G74,G75,G76,G77,G78,G79,G80,G81,G82,G83,G84,G85,G86,G87,G88,G89,G90,G91))*1.12/1000,0)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"*****************","*****************"]
["ADDITIONAL OUTPUTS:",null,null,null,"ESAL FACTORS"]
[null,"BASE %","FORECAST %",null,"FLEXIBLE","RIGID"]
["2AX-6TIRE SU",{"$f":"D13/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"G13/$C$26","v":{"$error":"#DIV/0!"}},null,0.25,{"$f":"IF(E32<0.11,E32,E32-0.01)","v":0.24}]
["3AX+ SU",{"$f":"D14/$C$25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,0.57999999999999996,{"$f":"IF(E33<0.36,(E33*1.62364-0.070909)+0.01,(IF(E33<0.4,E33*1.62364-0.07909,(IF(E33<0.66,(E33*1.62364-0.07909)-0.01,(IF(E33<0.69,E33*1.62364-0.07909,(E33*1.62364-0.07909)+0.02)))))))","v":0.85262119999999997}]
["3AX TST",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0.39,{"$f":"IF(E34<0.28,E34-0.01,(IF(E34<0.56,E34-0.02,E34-0.03)))","v":0.37}]
["4AX TST",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0.51,{"$f":"IF(E35<0.41,E35,(IF(E35<0.47,E35+0.01,(IF(E35<0.54,E35+0.02,(IF(E35<0.61,E35+0.03,(IF(E35<0.67,E35+0.04,E35+0.05)))))))))","v":0.53}]
["5AX+ TST",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,1.1299999999999999,{"$f":"(+E36*1.71536-0.05351)+0.005","v":1.8898467999999997}]
["(5AX+ TST MAX)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,2.4,{"$f":"(+E37*1.71536-0.05351)+0.005","v":4.0683539999999994}]
["(5AX+ TST OTH)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0.87,{"$f":"(+E38*1.71536-0.05351)+0.005","v":1.4438531999999999}]
["TR TR, BUSES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0.56999999999999995,{"$f":"E39*1.35636-0.03091","v":0.74221519999999996}]
["TWIN TRAILERS",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,2.4,{"$f":"(+E40*0.97519-0.01494)+0.005","v":2.3305159999999998}]
["Notes:"]
[]
[]
[]
[]
[null,"-","-","-","-","-","-"]
["CUMULATIVE ESAL WORK AREA",null,null,"BY VOL","BY","FY","FY"]
["|","BYVOLS","FYVOLS","* BESAL"," VOL*CESAL","VOL*BESAL","VOL*CESAL"]
["|",{"$f":"D13","v":{"$error":"#DIV/0!"}},{"$f":"G13","v":{"$error":"#DIV/0!"}},{"$f":"E32*B49","v":{"$error":"#DIV/0!"}},{"$f":"F32*B49","v":{"$error":"#DIV/0!"}},{"$f":"E32*C49","v":{"$error":"#DIV/0!"}},{"$f":"F32*C49","v":{"$error":"#DIV/0!"}}]
["|",{"$f":"D14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["|",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["|",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["|",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["|",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["|",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["|",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["|",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["TWO WAY ADL -->",null,null,"FLEX ADL","  RIG ADL","FLEX ADL","  RIG ADL"]
["|",null,null,{"$f":"($C$8-SUM($B$49:$B$57))*0.0007+SUM(D49:D57)","v":{"$error":"#DIV/0!"}},{"$f":"($C$8-SUM($B$49:$B$57))*0.0007+SUM(E49:E57)","v":{"$error":"#DIV/0!"}},{"$f":"(((C9-SUM($C$49:$C$57))*0.0007)+SUM(F49:F57))","v":{"$error":"#DIV/0!"}},{"$f":"($C$9-SUM($C$49:$C$57))*0.0007+SUM(G49:G57)","v":{"$error":"#DIV/0!"}}]
[]
["CUMULATIVE ESAL CALCULATIONS (DESIGN LANE)",null,null,null,null,"FLEXIBLE","RIGID"]
[null,"INCLUSIVE","YEARS",null,"DAYS"]
["FUTURE YR - BASE YR =",null,{"$f":"B9-B8+1","v":21},null,365.25,{"$f":"$D$59*$E63*$C$28+F62","v":{"$error":"#DIV/0!"}},{"$f":"$E$59*$E63*$C$28+G62","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"+E63+365.25","v":730.5},{"$f":"(365.25*$D$59+$E63*$A$67)*$C$28+F63","v":{"$error":"#DIV/0!"}},{"$f":"(365.25*$E$59+$E63*$B$67)*$C$28+G63","v":{"$error":"#DIV/0!"}}]
["ANNUAL AVERAGE CHANGE IN 2 WAY ADL",null,null,null,{"$f":"+E64+365.25","v":1095.75},{"$f":"(365.25*$D$59+$E64*$A$67)*$C$28+F64","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["FLEXIBLE","RIGID",null,null,1461,{"$f":"(365.25*$D$59+$E65*$A$67)*$C$28+F65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"(+F59-D59)/($C$63-1)","v":{"$error":"#DIV/0!"}},{"$f":"(+G59-E59)/($C$63-1)","v":{"$error":"#DIV/0!"}},null,null,1826.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,2191.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,2556.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,2922,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,3287.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,3652.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,4017.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,4383,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,4748.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,5113.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,5478.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,5844,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,6209.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,6574.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,6939.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,7305,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,7670.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,8035.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,8400.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,8766,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,9131.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,9496.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,9861.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,10227,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,10592.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,10957.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,11322.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,11688,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,12053.25,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,12418.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,12783.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,13149,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Esal Report - A","index":9,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,1,0,6],[27,5,27,6]]}
[null,"CUMULATIVE ESAL REPORT - A"]
[null,null,null,null,null,"DATE:",{"$f":"+Forecast!C10","v":"2013-02-15T09:32:49.330"}]
[null,"ROUTE #:",{"$f":"'Least Squares'!B2","v":"0  "},"DISTRICT:",{"$f":"IF(Forecast!H26=0,\" \",Forecast!H26)","v":" "},"SP#:",{"$f":"IF(Forecast!H23=0,\" \",Forecast!H23)","v":" "}]
[null,"FORECAST #:",{"$f":"IF(Forecast!H24=0,\" \",Forecast!H24)","v":" "},"COUNTY:",{"$f":"IF(+Forecast!H25=0,\" \",Forecast!H25)","v":""},"MILES:"]
[null,"DESCRIPTION:",{"$f":"'Cumesal-A'!B4","v":0}]
[null,"AUTHOR'S DISTRICT: --->",null,null,"AUTHOR:"]
[]
[null,"TRAFFIC SUMMARY"]
[null,"BASE YEAR NUMBER OF LANES (two way):",null,null,{"$f":"+'Cumesal-A'!D3","v":0}]
[null,null,"BASE YEAR --->",{"$f":"+'Least Squares'!B4","v":0},"DESIGN YEAR ---->",{"$f":"'Least Squares'!F4","v":20},"GROWTH / YR    (SIMPLE %)"]
[]
[null,"AADT: two-way",null,{"$f":"+'Cumesal-A'!C8","v":0},null,{"$f":"+'Cumesal-A'!C9","v":0},{"$f":"((F12-D12)/(F10-D10))/D12","v":{"$error":"#DIV/0!"}}]
[null,"design-lane",null,{"$f":"10*ROUND(CHOOSE((E9)+1,#VALUE!,1,0.5,0.5,0.45,0.45,0.35,0.35)*D12/10,0)","v":{"$error":"#VALUE!"}},null,{"$f":"10*ROUND(CHOOSE((E9)+1,#VALUE!,1,0.5,0.5,0.45,0.45,0.35,0.35)*F12/10,0)","v":{"$error":"#VALUE!"}},{"$f":"((F13-D13)/(F10-D10))/D13","v":{"$error":"#VALUE!"}}]
[null,"HCADT: two-way",null,{"$f":"IF(+$C$58=0,10*ROUND(SUM('Cumesal-A'!D13:D21)/10,0),10*ROUND((SUM('Cumesal-A'!D13:D21)+SUM('Cumesal-B'!D11:D19))/10,0))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(+C58=0,10*ROUND(SUM('Cumesal-A'!G13:G21)/10,0),10*ROUND((SUM('Cumesal-A'!G13:G21)+SUM('Cumesal-B'!G11:G19))/10,0))","v":{"$error":"#DIV/0!"}},{"$f":"((F14-D14)/(F10-D10))/D14","v":{"$error":"#DIV/0!"}}]
[null,"SINGLE UNITS:two-way",null,{"$f":"IF(C58=0,10*ROUND(('Cumesal-A'!D13+'Cumesal-A'!D14)/10,0),10*ROUND((+'Cumesal-B'!D11+'Cumesal-B'!D12+'Cumesal-A'!D13+'Cumesal-A'!D14)/10,0))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($C$58=0,10*ROUND(('Cumesal-A'!G13+'Cumesal-A'!G14)/10,0),10*ROUND((+'Cumesal-B'!G11+'Cumesal-B'!G12+'Cumesal-A'!G13+'Cumesal-A'!G14)/10,0))","v":{"$error":"#DIV/0!"}},{"$f":"((F15-D15)/(F10-D10))/D15","v":{"$error":"#DIV/0!"}}]
[null,"TST'S: two-way",null,{"$f":"IF($C$58=0,SUM('Cumesal-A'!D15:D19),SUM('Cumesal-A'!D15:D19)+SUM('Cumesal-B'!D13:D17))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($C$58=0,SUM('Cumesal-A'!G15:G19),SUM('Cumesal-A'!G15:G19)+SUM('Cumesal-B'!G13:G17))","v":{"$error":"#DIV/0!"}},{"$f":"((F16-D16)/(F10-D10))/D16","v":{"$error":"#DIV/0!"}}]
[null,"5 Ax +: two-way",null,{"$f":"SUM('Cumesal-A'!D17:D19)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM('Cumesal-A'!G17:G19)","v":{"$error":"#DIV/0!"}},{"$f":"((F17-D17)/(F10-D10))/D17","v":{"$error":"#DIV/0!"}}]
[null,"ESAL SUMMARY"]
[null,"  ANNUAL DESIGN LANE ESAL"]
[null,"     FLEXIBLE:",null,{"$f":"IF(C58=0,+'Cumesal-A'!D59*'Cumesal-A'!C28*365.25,('Cumesal-A'!D59*'Cumesal-A'!C28+'Cumesal-B'!D61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C58=0,+'Cumesal-A'!F59*'Cumesal-A'!C28*365.25,('Cumesal-A'!F59*'Cumesal-A'!C28+'Cumesal-B'!F61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},"+"]
[null,"     RIGID:",null,{"$f":"IF(C58=0,+'Cumesal-A'!E59*'Cumesal-A'!C28*365.25,('Cumesal-A'!E59*'Cumesal-A'!C28+'Cumesal-B'!E61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C58=0,'Cumesal-A'!G59*'Cumesal-A'!C28*365.25,('Cumesal-A'!G59*'Cumesal-A'!C28+'Cumesal-B'!G61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},"+"]
[]
[null,"CUMULATIVE DESIGN-LANE ESALS (10 TON)",null,null,null,"Design-lane factor:",{"$f":"+'Cumesal-A'!C28","v":{"$error":"#VALUE!"}}]
[null,"FOR VARIABLE TIME PERIODS"]
[]
[]
[]
["BASE","DESIGN","TIME","DESIGN-LANE",null,"ESALS"]
["YEAR","YEAR","PERIOD","TST'S",null,"FLEXIBLE","RIGID"]
[]
[]
[{"$f":"D10","v":0},{"$f":"D10+10","v":10},"10 Year",{"$f":"G23*(10*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C58=0,1000*ROUND('Cumesal-A'!F73*1.12/1000,0),1000*ROUND(('Cumesal-A'!F73*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!F75)*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D58=0,1000*ROUND('Cumesal-A'!G73*1.12/1000,0),1000*ROUND(('Cumesal-A'!G73*'Cumesal-B'!D24/'Cumesal-A'!D28+'Cumesal-B'!G75)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+15","v":15},"15 Year",{"$f":"G23*(15*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C58=0,1000*ROUND('Cumesal-A'!F78*1.12/1000,0),1000*ROUND(('Cumesal-A'!F78*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!F80)*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D58=0,1000*ROUND('Cumesal-A'!G78*1.12/1000,0),1000*ROUND(('Cumesal-A'!G78*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!G80)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+20","v":20},"20 Year",{"$f":"G23*(20*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C58=0,1000*ROUND('Cumesal-A'!F83*1.12/1000,0),1000*ROUND(('Cumesal-A'!F83*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!F85)*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D58=0,1000*ROUND('Cumesal-A'!G83*1.12/1000,0),1000*ROUND(('Cumesal-A'!G83*'Cumesal-B'!D24/'Cumesal-A'!D28+'Cumesal-B'!G85)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+25","v":25},"25 Year",{"$f":"G23*(25*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C58=0,1000*ROUND('Cumesal-A'!F88*1.12/1000,0),1000*ROUND(('Cumesal-A'!F88*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!F90)*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D58=0,1000*ROUND('Cumesal-A'!G88*1.12/1000,0),1000*ROUND(('Cumesal-A'!G88*'Cumesal-B'!D24/'Cumesal-A'!D28+'Cumesal-B'!G90)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+30","v":30},"30 Year",{"$f":"G23*(30*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C58=0,1000*ROUND('Cumesal-A'!F93*1.12/1000,0),1000*ROUND(('Cumesal-A'!F93*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!F95)*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D58=0,1000*ROUND('Cumesal-A'!G93*1.12/1000,0),1000*ROUND(('Cumesal-A'!G93*'Cumesal-B'!D24/'Cumesal-A'!D28+'Cumesal-B'!G95)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+35","v":35},"35 Year",{"$f":"G23*(35*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(+$C$58=0,1000*ROUND((+'Cumesal-A'!F98*1.12/1000),0),1000*ROUND(((+'Cumesal-A'!F98*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!F100)-('Cumesal-A'!F62*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!F64))*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(+$C$58=0,1000*ROUND((+'Cumesal-A'!G98*1.12/1000),0),1000*ROUND(((+'Cumesal-A'!G98*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!G100)-('Cumesal-A'!G62*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!G64))*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"APPROVED BY:",null,null,null,"DATE:"]
[]
[]
[]
[]
[]
[null,null,0]

{"sheet":"Cumesal-B","index":10,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[[3,1,3,6],[27,4,27,5],[25,8,28,10],[31,8,34,10],[41,0,44,1],[41,3,44,5],[38,7,42,10],[53,7,57,10],[44,8,47,10],[48,8,51,10],[45,0,47,1],[45,3,47,5]]}
["CUMULATIVE ESAL WORKSHEET",null,null,"SEGMENT B",null,null,null,null,"USE THE RURAL OR","ENTER RURAL"]
["    SP#:",{"$f":"IF(+Forecast!H23=0,\" \",Forecast!H23)","v":" "},null,null,null,null,null,null,"URBAN PCT'S","OR URBAN BELOW"]
["ROUTE:",{"$f":"'Least Squares'!B2:C2","v":"0  "},"# LANES:",2,"DATE:",{"$f":"+Forecast!C10","v":"2013-02-15T09:32:49.330"},null,null,"BELOW FOR"]
["LOCATION:",null,null,null,null,null,null,null,"TYPE OF FORECAST"]
[null,"YEAR","AADT  ",null,null,"CALCULATED HCADT","CONSTRAIN HCADT",null,"Check cells A42-F48"]
["BASE YEAR:",{"$f":"+'Least Squares'!B4","v":0},null,{"$f":"IF(C6=0,0,+C6-'Cumesal-A'!C8)","v":0},"DIFFERENCE",{"$f":"10*ROUND(IF('Cumesal-A'!E8>0,'Cumesal-A'!E8+SUM(F10:F18)*D6,'Cumesal-A'!D8+SUM(F10:F18)*D6)/10,0)","v":{"$error":"#DIV/0!"}},0,null,"ENTER RURAL OR URBAN "]
["FORECAST YEAR:",{"$f":"'Least Squares'!F4","v":20},null,{"$f":"IF(C7=0,0,+C7-'Cumesal-A'!C9)","v":0},"DIFFERENCE",{"$f":"10*ROUND(IF('Cumesal-A'!E9>0,'Cumesal-A'!E9+SUM(F11:F19)*D7,'Cumesal-A'!D9+SUM(F11:F19)*D7)/10,0)","v":{"$error":"#DIV/0!"}},0,null,"IN COLUMN J3"]
[]
["INCREMENTAL HCADT ON SEGMENT B (2000-2004 Local Road Studies)"]
["BASE YEAR PROPORTIONS",null,null," BASE YR. VOLUME","  % TREND","FORECAST %","FUTURE VOL.",null,"VEHICLE TYPE","Urban","Rural"]
["2AX-6TIRE SU",{"$f":"IF($J$3=\"urban\",J11,IF($J$3=\"rural\",K11,\"See J3\"))","v":"See J3"},null,{"$f":"ROUND(IF(AND('Cumesal-A'!E7>0,$G$6>0),($G$6-'Cumesal-A'!E7)*B11/SUM($B$11:$B$17),IF(AND('Cumesal-A'!E7>0,$G$6=0),B11*$D$6,IF(AND('Cumesal-A'!E8=0,$G$6>0),($G$6-$R$7)*B11/SUM($B$11:$B$17),B11*$D$6))),0)","v":{"$error":"#VALUE!"}},1,{"$f":"E11*B11","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F11/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F11*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F11/SUM($F$11:$F$19),F11*$D$7))),0)","v":{"$error":"#VALUE!"}},null,"2AX-6TIRE SU",1.52E-2,3.1699999999999999E-2]
["3AX+ SU",{"$f":"IF($J$3=\"urban\",J12,IF($J$3=\"rural\",K12,\"See J3\"))","v":"See J3"},null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B12/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B12*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B12/SUM($B$11:$B$17),B12*$D$6))),0)","v":{"$error":"#VALUE!"}},1,{"$error":"#VALUE!"},{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F12/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F12*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F12/SUM($F$11:$F$19),F12*$D$7))),0)","v":{"$error":"#VALUE!"}},null,"3AX+ SU",4.5999999999999999E-3,1.6400000000000001E-2]
["3AX TST",{"$f":"IF($J$3=\"urban\",J13,IF($J$3=\"rural\",K13,\"See J3\"))","v":"See J3"},null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B13/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B13*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B13/SUM($B$11:$B$17),B13*$D$6))),0)","v":{"$error":"#VALUE!"}},1,{"$error":"#VALUE!"},{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F13/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F13*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F13/SUM($F$11:$F$19),F13*$D$7))),0)","v":{"$error":"#VALUE!"}},null,"3AX TST",8.9999999999999998E-4,2.8E-3]
["4AX TST",{"$f":"IF($J$3=\"urban\",J14,IF($J$3=\"rural\",K14,\"See J3\"))","v":"See J3"},null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B14/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B14*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B14/SUM($B$11:$B$17),B14*$D$6))),0)","v":{"$error":"#VALUE!"}},1,{"$error":"#VALUE!"},{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F14/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F14*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F14/SUM($F$11:$F$19),F14*$D$7))),0)","v":{"$error":"#VALUE!"}},null,"4AX TST",1.1999999999999999E-3,5.0000000000000001E-3]
["5AX+ TST",{"$f":"IF($J$3=\"urban\",J15,IF($J$3=\"rural\",K15,\"See J3\"))","v":"See J3"},null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B15/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B15*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B15/SUM($B$11:$B$17),B15*$D$6))),0)","v":{"$error":"#VALUE!"}},1,{"$error":"#VALUE!"},{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F15/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F15*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F15/SUM($F$11:$F$19),F15*$D$7))),0)","v":{"$error":"#VALUE!"}},null,"5AX+ TST",8.8999999999999999E-3,3.2599999999999997E-2]
["(5AX+ TST MAX)",0,null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B16/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B16*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B16/SUM($B$11:$B$17),B16*$D$6))),0)","v":0},1,0,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F16/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F16*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F16/SUM($F$11:$F$19),F16*$D$7))),0)","v":0},null,"TR TR, BUSES",4.7000000000000002E-3,1.2E-2]
["(5AX+ TST OTH)",0,null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B17/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B17*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B17/SUM($B$11:$B$17),B17*$D$6))),0)","v":0},1,0,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F17/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F17*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F17/SUM($F$11:$F$19),F17*$D$7))),0)","v":0},null,"TWIN TRAILERS",2.0000000000000001E-4,2.0000000000000001E-4]
["TR TR, BUSES",{"$f":"IF($J$3=\"urban\",J16,IF($J$3=\"rural\",K16,\"See J3\"))","v":"See J3"},null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B18/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B18*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B18/SUM($B$11:$B$17),B18*$D$6))),0)","v":{"$error":"#VALUE!"}},1,{"$error":"#VALUE!"},{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F18/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F18*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F18/SUM($F$11:$F$19),F18*$D$7))),0)","v":{"$error":"#VALUE!"}},null,"TOTAL",{"$f":"SUM(J11:J17)","v":3.5700000000000003E-2},{"$f":"SUM(K11:K17)","v":0.1007}]
["TWIN TRAILERS",{"$f":"IF($J$3=\"urban\",J17,IF($J$3=\"rural\",K17,\"See J3\"))","v":"See J3"},null,{"$f":"ROUND(IF(AND('Cumesal-A'!$E$7>0,$G$6>0),($G$6-'Cumesal-A'!$E$7)*B19/SUM($B$11:$B$17),IF(AND('Cumesal-A'!$E$7>0,$G$6=0),B19*$D$6,IF(AND('Cumesal-A'!$E$7=0,$G$6>0),($G$6-$R$7)*B19/SUM($B$11:$B$17),B19*$D$6))),0)","v":{"$error":"#VALUE!"}},1,{"$error":"#VALUE!"},{"$f":"ROUND(IF(AND('Cumesal-A'!$E$9>0,$G$7>0),($G$7-'Cumesal-A'!$E$9)*F19/SUM($F$11:$F$19),IF(AND('Cumesal-A'!$E$9>0,$G$7=0),F19*$D$7,IF(AND('Cumesal-A'!$E$9=0,$G$7>0),($G$7-$R$8)*F19/SUM($F$11:$F$19),F19*$D$7))),0)","v":{"$error":"#VALUE!"}}]
["SUMMARIES:",{"$f":"J3","v":0},0,"ADDED","COMBINED",{"$f":"B23-B22","v":20},"YR DESIGN",null,"Note: The URBAN vehicle types were developed primarily for use"]
[null,null,"AADT","HCADT %","HCADT %","  LANE CUMULATIVE ESAL   ",null,null,"in the Seven County Metropolitan Area + Chisago Cty. They can also be used"]
["BASE YEAR:",{"$f":"B6","v":0},{"$f":"D6","v":0},{"$f":"IF(SUM(D11:D19)=0,\"\",(SUM(D11:D19)/C22))","v":{"$error":"#VALUE!"}},{"$f":"IF(SUM(D11:D19)=0,\"\",(SUM(D11:D19)+SUM('Cumesal-A'!D13:D21))/C6)","v":{"$error":"#VALUE!"}},"|","|",null,"for segments that are near cities with over 5,000 population."]
["FORECAST YEAR:",{"$f":"B7","v":20},{"$f":"D7","v":0},{"$f":"SUM(G11:G19)/C23","v":{"$error":"#VALUE!"}},{"$f":"IF(C7=0,\"\",(SUM(G11:G19)+SUM('Cumesal-A'!G13:G21))/C7)","v":""},"*****************","*****************",null,"CAUTION: USE ONLY ONE SET OF DEFAULTS ON EACH \"A\" SEGMENT"]
["DESIGN LANE FACTOR:",null,{"$f":"CHOOSE((D3)+1,'Cumesal-A'!C28,1,0.5,0.5,0.45,0.45,0.35,0.35)","v":0.5},null,null,"FLEXIBLE","RIGID"]
[null,null,"SEGMENT B INCREMENT ONLY:",null,null,{"$f":"1000*ROUND(IF((C65-1)+1>29,CHOOSE(C65,F94,F95,F96,F97,F98,F99,F100),CHOOSE(C65,F65,F66,F67,F68,F69,F70,F71,F72,F73,F74,F75,F76,F77,F78,F79,F80,F81,F82,F83,F84,F85,F86,F87,F88,F89,F90,F91,F92,F93))*1.12/1000,0)","v":{"$error":"#VALUE!"}},{"$f":"1000*ROUND(IF((C65-1)+1>29,CHOOSE(C65,G94,G95,G96,G97,G98,G99,G100),CHOOSE(C65,G65,G66,G67,G68,G69,G70,G71,G72,G73,G74,G75,G76,G77,G78,G79,G80,G81,G82,G83,G84,G85,G86,G87,G88,G89,G90,G91,G92,G93))*1.12/1000,0)","v":{"$error":"#VALUE!"}}]
[null,null,"SEGMENT A + SEGMENT B:",null,null,{"$f":"1000*(ROUND((+F25+'Cumesal-A'!F28*C24/'Cumesal-A'!C28)/1000,0))","v":{"$error":"#VALUE!"}},{"$f":"1000*(ROUND((+G25+'Cumesal-A'!G28*C24/'Cumesal-A'!C28)/1000,0))","v":{"$error":"#VALUE!"}},null,{"$f":"B40","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"*****************","*****************"]
["ADDITIONAL OUTPUTS:",null,null,null,"ESAL FACTORS"]
[null,"BASE %","FORECAST %",null,"FLEXIBLE","RIGID"]
["2AX-6TIRE SU",{"$f":"D11/$C$22","v":{"$error":"#VALUE!"}},{"$f":"G11/$C$23","v":{"$error":"#VALUE!"}},null,0.25,{"$f":"IF(E30<0.11,E30,E30-0.01)","v":0.24}]
["3AX+ SU",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0.57999999999999996,{"$f":"IF(E31<0.36,(E31*1.62364-0.070909)+0.01,(IF(E31<0.4,E31*1.62364-0.07909,(IF(E31<0.66,(E31*1.62364-0.07909)-0.01,(IF(E31<0.69,E31*1.62364-0.07909,(E31*1.62364-0.07909)+0.02)))))))","v":0.85262119999999997}]
["3AX TST",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0.39,{"$f":"IF(E32<0.28,E32-0.01,(IF(E32<0.56,E32-0.02,E32-0.03)))","v":0.37},null,null,{"$f":"C40","v":{"$error":"#VALUE!"}}]
["4AX TST",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0.51,{"$f":"IF(E33<0.41,E33,(IF(E33<0.47,E33+0.01,(IF(E33<0.54,E33+0.02,(IF(E33<0.61,E33+0.03,(IF(E33<0.67,E33+0.04,E33+0.05)))))))))","v":0.53}]
["5AX+ TST",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,1.1299999999999999,{"$f":"(+E34*1.71536-0.05351)+0.005","v":1.8898467999999997}]
["(5AX+ TST MAX)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,2.4,{"$f":"(+E35*1.71536-0.05351)+0.005","v":4.0683539999999994}]
["(5AX+ TST OTH)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0.87,{"$f":"(+E36*1.71536-0.05351)+0.005","v":1.4438531999999999}]
["TR TR, BUSES",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,0.56999999999999995,{"$f":"E37*1.35636-0.03091","v":0.74221519999999996}]
["TWIN TRAILERS",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,2.4,{"$f":"(+E38*0.97519-0.01494)+0.005","v":2.3305159999999998}]
["BSEGment",null,null,null,null,null,null,"When B segment ESALS and AADT vary significantly from each other with no trunk highway junction in between segments, then the difference may be mainly cars. In these instances, the default B segment percentages may need to be adjusted to reflect logical addition or subtraction of trucks, or to smooth out the volume of trucks between all B segments"]
[null,{"$f":"IF(OR(D11<0-'Cumesal-A'!D13*0.5,D12<0-'Cumesal-A'!D14*0.5,D13<0-'Cumesal-A'!D15*0.5,D14<0-'Cumesal-A'!D16*0.5,SUM(D15:D17)<0-SUM('Cumesal-A'!D17:'Cumesal-A'!D19)*0.5,D18<0-'Cumesal-A'!D20*0.5,D19<0-'Cumesal-A'!D21*0.5),\"Warning-taking away more than 50% of trucks from A segment. Reduce B segment truck percentages in base year\",\"OK\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(G11<0-'Cumesal-A'!G13*0.5,G12<0-'Cumesal-A'!G14*0.5,G13<0-'Cumesal-A'!G15*0.5,G14<0-'Cumesal-A'!G16*0.5,SUM(G15:G17)<0-SUM('Cumesal-A'!G17:'Cumesal-A'!G19)*0.5,G18<0-'Cumesal-A'!G20*0.5,G19<0-'Cumesal-A'!G21*0.5),\"Warning-taking away more than 50% of trucks from A segment. Reduce B segment truck percentages in forecast year\",\"OK\")","v":{"$error":"#VALUE!"}}]
["BASE YEAR",{"$f":"IF(OR(D11>'Cumesal-A'!D13*0.5,D12>'Cumesal-A'!D14*0.5,D13>'Cumesal-A'!D15*0.5,D14>'Cumesal-A'!D16*0.5,SUM(D15:D17)>SUM('Cumesal-A'!D17:'Cumesal-A'!D19)*0.5,D18>'Cumesal-A'!D20*0.5,D19>'Cumesal-A'!D21*0.5),\"Warning-Adding more than 50% of trucks from A segment. Reduce B segment truck percentages in base year\",\"OK\")","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(G11>'Cumesal-A'!G13*0.5,G12>'Cumesal-A'!G14*0.5,G13>'Cumesal-A'!G15*0.5,G14>'Cumesal-A'!G16*0.5,SUM(G15:G17)>SUM('Cumesal-A'!G17:'Cumesal-A'!G19)*0.5,G18>'Cumesal-A'!G20*0.5,G19>'Cumesal-A'!G21*0.5),\"Adding more than 50% of trucks from A segment. Reduce B segment truck percentages in forecast year\",\"OK\")","v":{"$error":"#VALUE!"}},"FORECAST YEAR"]
[{"$f":"B40","v":{"$error":"#VALUE!"}},null,"Subtraction",{"$f":"C40","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"of Trucks",null,null,null,null,null,{"$f":"B41","v":{"$error":"#VALUE!"}}]
[{"$f":"B41","v":{"$error":"#VALUE!"}},null,"Addition",{"$f":"C41","v":{"$error":"#VALUE!"}}]
[]
[null,null,"of Trucks"]
["CUMULATIVE ESAL WORK AREA",null,null,null,null,null,null,null,{"$f":"C41","v":{"$error":"#VALUE!"}}]
[null,"BYVOLS","FYVOLS","BY VOL   * BESAL"," BY VOL   *CESAL","FY VOL   *BESAL","FY VOL   *CESAL"]
[null,{"$f":"D11","v":{"$error":"#VALUE!"}},{"$f":"G11","v":{"$error":"#VALUE!"}},{"$f":"E30*B51","v":{"$error":"#VALUE!"}},{"$f":"F30*B51","v":{"$error":"#VALUE!"}},{"$f":"E30*C51","v":{"$error":"#VALUE!"}},{"$f":"F30*C51","v":{"$error":"#VALUE!"}}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0,0,0,0,0]
[null,0,0,0,0,0,0]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["TWO WAY ADL -->",null,null,"FLEX ADL","  RIG ADL","FLEX ADL","  RIG ADL"]
["|",null,null,{"$f":"$C$22*0.0007+SUM(D51:D59)","v":{"$error":"#VALUE!"}},{"$f":"$C$22*0.0007+SUM(E51:E59)","v":{"$error":"#VALUE!"}},{"$f":"$C$23*0.0007+SUM(F51:F59)","v":{"$error":"#VALUE!"}},{"$f":"$C$23*0.0007+SUM(G51:G59)","v":{"$error":"#VALUE!"}}]
[]
["CUMULATIVE ESAL CALCULATIONS (DESIGN LANE)",null,null,null,null,"FLEXIBLE","RIGID"]
[null,"INCLUSIVE","YEARS",null,"DAYS"]
["FUTURE YR - BASE YR =",null,{"$f":"B7-B6+1","v":21},null,365.25,{"$f":"$D$61*$E65*$C$24+F64","v":{"$error":"#VALUE!"}},{"$f":"$E$61*$E65*$C$24+G64","v":{"$error":"#VALUE!"}}]
[null,null,null,null,730.5,{"$f":"(365.25*$D$61+$E65*$A$69)*$C$24+F65","v":{"$error":"#VALUE!"}},{"$f":"(365.25*$E$61+$E65*$B$69)*$C$24+G65","v":{"$error":"#VALUE!"}}]
["ANNUAL AVERAGE CHANGE IN 2 WAY ADL",null,null,null,1095.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["FLEXIBLE","RIGID",null,null,1461,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$f":"(+F61-D61)/($C$65-1)","v":{"$error":"#VALUE!"}},{"$f":"(+G61-E61)/($C$65-1)","v":{"$error":"#VALUE!"}},null,null,1826.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,2191.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,2556.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,2922,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,3287.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,3652.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,4017.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,4383,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,4748.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,5113.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,5478.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,5844,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,6209.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,6574.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,6939.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,7305,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,7670.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,8035.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,8400.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,8766,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,9131.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,9496.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,9861.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,10227,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,10592.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,10957.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,11322.75,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,11688,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,12053.25,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,12418.5,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,12783.75,{"$f":"(365.25*$D$61+$E98*$A$69)*$C$24+F98","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,13149,{"$f":"(365.25*$D$61+$E99*$A$69)*$C$24+F99","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]

{"sheet":"Esal Report - B","index":11,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,1,0,6],[28,5,28,6]]}
[null,"CUMULATIVE ESAL REPORT - B"]
[null,null,null,null,null,"DATE:",{"$f":"+Forecast!C10","v":"2013-02-15T09:32:49.330"}]
[null,"ROUTE #:",{"$f":"'Least Squares'!B2","v":"0  "},"DISTRICT:",{"$f":"IF(Forecast!H26=0,\" \",Forecast!H26)","v":" "},"SP#:",{"$f":"IF(Forecast!H23=0,\" \",Forecast!H23)","v":" "}]
[null,"FORECAST #:",{"$f":"IF(Forecast!H24=0,\" \",Forecast!H24)","v":" "},"COUNTY:",{"$f":"IF(Forecast!H25=0,\" \",Forecast!H25)","v":""},"MILES:"]
[null,"DESCRIPTION:",{"$f":"+'Cumesal-B'!B4","v":0}]
[null,"AUTHOR'S DISTRICT: --->",null,{"$f":"+'Esal Report - A'!D6","v":0},"AUTHOR:",{"$f":"+'Esal Report - A'!F6","v":0}]
[]
[null,"TRAFFIC SUMMARY"]
[null,"BASE YEAR NUMBER OF LANES (two way):",null,null,{"$f":"+'Cumesal-B'!D3","v":2}]
[null,null,"BASE YEAR --->",{"$f":"+'Least Squares'!B4","v":0},"DESIGN YEAR ---->",{"$f":"'Least Squares'!F4","v":20},"GROWTH / YR    (SIMPLE %)"]
[]
[null,"AADT: two-way",null,{"$f":"+'Cumesal-B'!C6","v":0},null,{"$f":"IF(C57=1,'Cumesal-B'!C7,IF(C57=0,'Cumesal-A'!C9))","v":0},{"$f":"((F12-D12)/(F10-D10))/D12","v":{"$error":"#DIV/0!"}}]
[null,"design-lane",null,{"$f":"10*ROUND(CHOOSE((E9)+1,#VALUE!,1,0.5,0.5,0.45,0.45,0.35,0.35)*D12/10,0)","v":0},null,{"$f":"10*ROUND(CHOOSE((E9)+1,#VALUE!,1,0.5,0.5,0.45,0.45,0.35,0.35)*F12/10,0)","v":0},{"$f":"((F13-D13)/(F10-D10))/D13","v":{"$error":"#DIV/0!"}}]
[null,"HCADT: two-way",null,{"$f":"IF(+$C$57=0,10*ROUND(SUM('Cumesal-A'!D13:D21)/10,0),10*ROUND((SUM('Cumesal-A'!D13:D21)+SUM('Cumesal-B'!D11:D19))/10,0))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(+C57=0,10*ROUND(SUM('Cumesal-A'!G13:G21)/10,0),10*ROUND((SUM('Cumesal-A'!G13:G21)+SUM('Cumesal-B'!G11:G19))/10,0))","v":{"$error":"#DIV/0!"}},{"$f":"((F14-D14)/(F10-D10))/D14","v":{"$error":"#DIV/0!"}}]
[null,"SINGLE UNITS:two-way",null,{"$f":"IF(C57=0,10*ROUND(('Cumesal-A'!D13+'Cumesal-A'!D14)/10,0),10*ROUND((+'Cumesal-B'!D11+'Cumesal-B'!D12+'Cumesal-A'!D13+'Cumesal-A'!D14)/10,0))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($C$57=0,10*ROUND(('Cumesal-A'!G13+'Cumesal-A'!G14)/10,0),10*ROUND((+'Cumesal-B'!G11+'Cumesal-B'!G12+'Cumesal-A'!G13+'Cumesal-A'!G14)/10,0))","v":{"$error":"#VALUE!"}},{"$f":"((F15-D15)/(F10-D10))/D15","v":{"$error":"#VALUE!"}}]
[null,"TST'S: two-way",null,{"$f":"IF($C$57=0,SUM('Cumesal-A'!D15:D19),SUM('Cumesal-A'!D15:D19)+SUM('Cumesal-B'!D13:D17))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($C$57=0,SUM('Cumesal-A'!G15:G19),SUM('Cumesal-A'!G15:G19)+SUM('Cumesal-B'!G13:G17))","v":{"$error":"#DIV/0!"}},{"$f":"((F16-D16)/(F10-D10))/D16","v":{"$error":"#DIV/0!"}}]
[null,"5 Ax +: two-way",null,{"$f":"('Esal Report - A'!D17)+SUM('Cumesal-B'!D15:D17)","v":{"$error":"#DIV/0!"}},null,{"$f":"('Esal Report - A'!F17)+SUM('Cumesal-B'!G15:G17)","v":{"$error":"#DIV/0!"}},{"$f":"((F17-D17)/(F10-D10))/D17","v":{"$error":"#DIV/0!"}}]
[null,"ESAL SUMMARY"]
[null,"  ANNUAL DESIGN LANE ESAL"]
[null,"     FLEXIBLE:",null,{"$f":"IF(C57=0,+'Cumesal-A'!D59*'Cumesal-A'!C28*365.25,('Cumesal-A'!D59*'Cumesal-A'!C28+'Cumesal-B'!D61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C57=0,+'Cumesal-A'!F59*'Cumesal-A'!C28*365.25,('Cumesal-A'!F59*'Cumesal-A'!C28+'Cumesal-B'!F61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},"+"]
[null,"     RIGID:",null,{"$f":"IF(C57=0,+'Cumesal-A'!E59*'Cumesal-A'!C28*365.25,('Cumesal-A'!E59*'Cumesal-A'!C28+'Cumesal-B'!E61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C57=0,'Cumesal-A'!G59*'Cumesal-A'!C28*365.25,('Cumesal-A'!G59*'Cumesal-A'!C28+'Cumesal-B'!G61*'Cumesal-B'!C24)*365.25)","v":{"$error":"#DIV/0!"}},"+"]
[]
[null,"CUMULATIVE DESIGN-LANE ESALS (10 TON)",null,null,null,"Design-lane factor:",{"$f":"+'Cumesal-B'!C24","v":0.5}]
[null,"FOR VARIABLE TIME PERIODS"]
[]
[]
[]
[]
["BASE","DESIGN","TIME","DESIGN-LANE",null,"ESALS"]
["YEAR","YEAR","PERIOD","TST'S",null,"FLEXIBLE","RIGID"]
[]
[{"$f":"D10","v":0},{"$f":"D10+10","v":10},"10 YEAR",{"$f":"G23*(10*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!F73*1.12/1000,0),1000*ROUND(('Cumesal-A'!F73*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!F75)*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!G73*1.12/1000,0),1000*ROUND(('Cumesal-A'!G73*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!G75)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+15","v":15},"15 YEAR",{"$f":"G23*(15*($F$16-$D$16)/(F10-D10)+D16)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!F78*1.12/1000,0),1000*ROUND(('Cumesal-A'!F78*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!F80)*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!G78*1.12/1000,0),1000*ROUND(('Cumesal-A'!G78*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!G80)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+20","v":20},"20 YEAR",{"$f":"G23*(20*($F$16-$D$16)/(F10-D10)+$D$16)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!F83*1.12/1000,0),1000*ROUND(('Cumesal-A'!F83*1.12*'Cumesal-B'!C24/'Cumesal-A'!C28+1000*ROUND('Cumesal-B'!F85*1.12/1000,0))/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!G83*1.12/1000,0),1000*ROUND(('Cumesal-A'!G83*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!G85)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+25","v":25},"25 YEAR",{"$f":"G23*(25*($F$16-$D$16)/(F10-D10)+$D$16)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!F88*1.12/1000,0),1000*ROUND(('Cumesal-A'!F88*1.12*'Cumesal-B'!C24/'Cumesal-A'!C28+1000*ROUND('Cumesal-B'!F90*1.12/1000,0))/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!G88*1.12/1000,0),1000*ROUND(('Cumesal-A'!G88*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!G90)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+30","v":30},"30 YEAR",{"$f":"G23*(30*($F$16-$D$16)/(F10-D10)+$D$16)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!F93*1.12/1000,0),1000*ROUND(('Cumesal-A'!F93*1.12*'Cumesal-B'!C24/'Cumesal-A'!C28+1000*ROUND('Cumesal-B'!F95*1.12/1000,0))/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C57=0,1000*ROUND('Cumesal-A'!G93*1.12/1000,0),1000*ROUND(('Cumesal-A'!G93*'Cumesal-B'!C24/'Cumesal-A'!C28+'Cumesal-B'!G95)*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"D10","v":0},{"$f":"D10+35","v":35},"35 YEAR",{"$f":"G23*(35*($F$16-$D$16)/(F10-D10)+$D$16)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(+$C$57=0,1000*ROUND((+'Cumesal-A'!F98*1.12/1000),0),1000*ROUND(((+'Cumesal-A'!F98*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!F100)-('Cumesal-A'!F62*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!F64))*1.12/1000,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(+$C$57=0,1000*ROUND((+'Cumesal-A'!G98*1.12/1000),0),1000*ROUND(((+'Cumesal-A'!G98*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!G100)-('Cumesal-A'!G62*'Cumesal-B'!$C$24/'Cumesal-A'!$C$28+'Cumesal-B'!G64))*1.12/1000,0))","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"APPROVED BY:",null,null,null,"DATE:"]
[]
[]
[]
[]
[]
[null,null,1]