{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","MainMenu_2023","ProjectInfo","Template","Help"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,16],[4,1,4,16],[8,2,11,5],[12,2,14,6],[16,2,27,6],[18,11,19,16],[21,11,22,16],[25,11,26,16],[28,2,29,6],[28,11,29,16],[30,11,30,16],[30,2,32,6],[31,11,31,16],[32,11,32,15],[34,11,36,16],[36,2,37,6],[37,11,38,16],[39,11,40,16],[41,11,42,16],[33,2,34,6],[39,2,40,6],[33,11,33,16]]}
[]
[null,"Equivalent Single Axle Load Analysis Tool "]
[]
[null,"Overview"]
[null,"This macro-based spreadsheet has been developed to calculate the 18-KIP ESAL specified in the FDOT Project Traffic Forecasting Handbook."]
[]
[null,"Steps for 18-KIP ESAL analysis:",null,null,null,null,null,null,"Description for each input:"]
[]
[null,"1.","Enter project information. The project information includes FM number, project description, and number of segments. The information is optional and only for project identification purpose. Number of segments is a required input.",null,null,null,null,null,"The Input includes the following:"]
[null,null,null,null,null,null,null,null,"Project Information",null,null,"Contents"]
[null,null,null,null,null,null,null,null,null,"FM #: ",null,"Project Identification number."]
[null,null,null,null,null,null,null,null,null,"County:",null,"County Name"]
[null,null,"Click on the button \"Clear Project Info\" to clear all the project information, including the data for the old roadway segment. The number of segments will be set to 1.",null,null,null,null,null,null,"Project Description",null,"Project information such as type of projects, location, and limits."]
[]
[null,null,null,null,null,null,null,null,"Segment"]
[null,null,null,null,null,null,null,null,null,"Roadway ID:",null,"Roadway ID for the study roadway segment."]
[null,"2.","Enter roadway segment information for all segments.\nThe information includes:\nRoadway ID\nLocation Description\nType of Roadway for Flexible Pavement\nType of Roadway for Rigid Pavement\nGrowth Rate Calculation Method\nYears\nNumber of Lanes\nGrowth Option\nAADT Volumes and Growth Rate\nTruck Percentages.",null,null,null,null,null,null,"Location Description:",null,"Location of the roadway segment."]
[null,null,null,null,null,null,null,null,null,"Flexible Pavement:",null,"Type of roadway for flexible pavement. "]
[null,null,null,null,null,null,null,null,null,null,null,"Rural Freeway, Urban Freeway, Rural Arterial, Urban Arterial, other flexible pavement type, or no flexible pavement."]
[]
[null,null,null,null,null,null,null,null,null,"Rigid Pavement:",null,"Type of roadway for rigid pavement. "]
[null,null,null,null,null,null,null,null,null,null,null,"Rural Freeway, Urban Freeway, Rural Arterial, Urban Arterial, other flexible pavement type, or no flexible pavement."]
[]
[null,null,null,null,null,null,null,null,null,"AADT Growth Method:",null,"How the AADTs are calculated or direct input. The option includes:"]
[null,null,null,null,null,null,null,null,null,null,1,"Existing/Design Year Traffic (Interpolation):"]
[null,null,null,null,null,null,null,null,null,null,null,"AADTs for existing year and design Year are typed in. AADTs for opening year and interim year are interpolated from existing year and design year."]
[]
[null,null,null,null,null,null,null,null,null,null,2,"Existing Traffic Only"]
[null,null,"If the data for a new segment data is needed, click on button \"Clear Input Data\" to clear the data for the segment.",null,null,null,null,null,null,null,null,"AADTs for existing year are typed in. AADTs for future years will be calculated using existing year and growth rate with the growth rate method option."]
[]
[null,null,"If the number of segments need to be changed, click on \"Back to Project Info\" to go back to Project Info page, then change the number of segments.",null,null,null,null,null,null,null,3,"Enter AADTs: All AADTs will be typed in."]
[null,null,null,null,null,null,null,null,null,null,4,"Future AADTs: This option is for new facility only. The AADTs for future years will be typed in."]
[null,null,null,null,null,null,null,null,null,"Years:",null,"Existing Year, Opening Year, Interim Year, and Design Year."]
[null,null,"Once the data for all segments is finished, click the button \"OK\" to complete the ESAL analysis.",null,null,null,null,null,null,"Number of Lanes",null,"This includes roadway type (one way or two-way) and number of lanes for each direction."]
[null,null,null,null,null,null,null,null,null,"Growth Option:",null,"The growth option is used for how the future AADTs were calculated when \"Existing/Design Year Traffic\" or \"Existing Traffic Only\" is selected. The annual growth rate will be defined in the AADT input."]
[]
[null,"3.","Preview results. The preview button will preview all the input and output for each roadway segment."]
[null,null,null,null,null,null,null,null,null,"AADT:",null,"This includes the AADT for all years. The annual growth rate is used as an input when \"Existing/Design Year Traffic\" or \"Existing Traffic Only\" is selected.  "]
[]
[null,"4.","Print results. The print button will print all the input and output for all the roadway segments.",null,null,null,null,null,null,"Recommended Growth Rate:",null,"Growth rates for each leg of the intersection. The growth rate will present when \"Existing/Design Year Traffic\" or \"Existing Traffic Only\" is selected. "]
[]
[null,null,null,null,null,null,null,null,null,"Truck Percentages:",null,"The truck percentages from existing year to opening year, opening year to interim year, and interim year to design year."]

{"sheet":"MainMenu_2023","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,1,2,3],[3,1,3,3]]}
[]
["Equivalent Single Axle Load Analysis Tool"]
[null,"Version 2023"]
[null,"Main Menu"]
[]
[]
[null,null,null,null,null,"NOTES"]
[null,null,null,null,null,"The input process is fully menu driven - just fill in data at the prompts."]
[null,null,null,null,null,"Manually changing the data will NOT invoke the macros to update calculations."]
[null,null,null,null,null,"The input from previous runs will automatically be shown in prompts."]
[null,null,null,null,null,"This program allows input of up to five segments at one time, and you can print"]
[null,null,null,null,null,"the input and output for all the segments and save data file."]

{"sheet":"ProjectInfo","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["FM ID"]
["County"]
["Project Description"]
["Number of Segments",0]
["Segment1"]
["Segment2"]
["Segment3"]
["Segment4"]
["Segment5"]

{"sheet":"Template","index":3,"n_rows":187,"n_cols":25,"rows_kept":187,"cut":false,"hidden":true,"merged":[[43,11,43,15],[43,19,43,23],[44,11,44,15],[44,19,44,23],[45,0,47,8],[45,9,47,16],[45,17,47,24],[10,0,10,1],[10,2,10,8],[9,5,9,6],[6,9,6,10],[30,0,30,2],[13,0,13,1],[15,3,15,5],[17,3,17,5],[18,0,18,2],[18,3,18,5],[19,0,19,2],[19,3,19,5],[20,0,20,2],[20,3,20,5],[22,0,22,1],[24,5,24,6],[6,17,6,18],[0,0,0,8],[0,9,0,16],[0,17,0,24],[1,0,1,8],[1,9,1,16],[1,17,1,24],[23,5,23,6],[31,3,31,5],[31,6,31,8],[32,3,32,5],[32,6,32,8],[25,5,25,6],[24,7,24,8],[25,7,25,8],[27,7,27,8],[28,7,28,8],[29,7,29,8]]}
[{"$f":"\"18 KIP EQUIVALENT SINGLE AXLE LOAD ANALYSIS - LOCATION \" &B63","v":"18 KIP EQUIVALENT SINGLE AXLE LOAD ANALYSIS - LOCATION 1"},null,null,null,null,null,null,null,null,{"$f":"\"18 KIP EQUIVALENT SINGLE AXLE LOAD ANALYSIS - LOCATION \" &B63","v":"18 KIP EQUIVALENT SINGLE AXLE LOAD ANALYSIS - LOCATION 1"},null,null,null,null,null,null,null,{"$f":"\"18 KIP EQUIVALENT SINGLE AXLE LOAD ANALYSIS - LOCATION \" &B63","v":"18 KIP EQUIVALENT SINGLE AXLE LOAD ANALYSIS - LOCATION 1"}]
["PROJECT TRAFFIC FOR PD&E and DESIGN ANALYSIS INFO / FACTORS",null,null,null,null,null,null,null,null,"PROJECT TRAFFIC FOR PD&E and DESIGN ANALYSIS INFO / FACTORS",null,null,null,null,null,null,null,"PROJECT TRAFFIC FOR PD&E and DESIGN ANALYSIS INFO / FACTORS"]
[null,null,null,null,null,null,null,null,null," "]
[null,"FM #:",{"$f":"B64","v":0},null,null,null,null,null,null,null,"FM #:",{"$f":"B64","v":0},null,"LOCATION:",{"$f":"B67","v":0},null,null,null,"FM #:",{"$f":"B64","v":0},null,"LOCATION:",{"$f":"B67","v":0}]
[null,"COUNTY:",{"$f":"B66","v":0},null,null,null,null,null,null,null,"COUNTY:",{"$f":"B66","v":0},null,"PAVEMENT TYPE",{"$f":"\"Flexible Pavement \"&IF(B77=1,\"Rural Freeway\",IF(B77=2,\"Urban Freeway\",IF(B77=3,\"Rural Arterial\",IF(B77=4,\"Urban Arterial\",\"Other Factor\"))))","v":"Flexible Pavement Rural Freeway"},null,null,null,"COUNTY:",{"$f":"B66","v":0},null,"PAVEMENT TYPE",{"$f":"\"Rigid Pavement \"&IF(B77=1,\"Rural Freeway\",IF(B77=2,\"Urban Freeway\",IF(B77=3,\"Rural Arterial\",IF(B77=4,\"Urban Arterial\",\"Other Factor\"))))","v":"Rigid Pavement Rural Freeway"}]
[null,"ROADWAY ID:",{"$f":"B62","v":0},null,null,null,null,null,null,null,"ROADWAY ID:",{"$f":"B62","v":0},null,"SN:","5 Inch Thick",null,null,null,"ROADWAY ID:",{"$f":"B62","v":0},null,"SN:","12 Inch Thick"]
[null,"PROJECT DESCRIPTION:",{"$f":"B65","v":0},null,null,null,null,null,null,"PROJECT DESCRIPTION:",null,{"$f":"B65","v":0},null,"YEARS:",{"$f":"IF(B68<>4,B69&\" to \"&D70,B70&\" to \"&D70)","v":"2025 to 2050"},null,null,"PROJECT DESCRIPTION:",null,{"$f":"B65","v":0},null,"YEARS:",{"$f":"IF(B68<>4,B69&\" to \"&D70,B70&\" to \"&D70)","v":"2025 to 2050"}]
[null,null,null,null,null,null,null,null,null,null,null,"ESAL","ACCUM",null,null,null,null,null,null,"ESAL","ACCUM"]
[null,null,null,null,null,null,null,null,null,"YEAR","AADT","(1000S)","(1000s)","D","T","LF","EF","YEAR","AADT","(1000S)","(1000s)","D","T","LF","EF"]
[null,null,null,null,null,"LOCATION #:",null,null,{"$f":"B63","v":1},{"$f":"IF(A83>0,A83,\"\")","v":2025},{"$f":"IF(J10<>\"\",B83,\"\")","v":0},{"$f":"IF(J10<>\"\",C83,\"\")","v":{"$error":"#NUM!"}},{"$f":"IF(J10<>\"\",D83,\"\")","v":0},{"$f":"IF($J10<>\"\",I83,\"\")","v":0.5},{"$f":"IF($J10<>\"\",J83,\"\")","v":0},{"$f":"IF($J10<>\"\",K83,\"\")","v":{"$error":"#NUM!"}},{"$f":"IF($J10<>\"\",L83,\"\")","v":1.05},{"$f":"J10","v":2025},{"$f":"IF(R10<>\"\",B83,\"\")","v":0},{"$f":"IF(J10<>\"\",F83,\"\")","v":{"$error":"#NUM!"}},{"$f":"IF(R10<>\"\",G83,\"\")","v":0},{"$f":"IF($R10<>\"\",I83,\"\")","v":0.5},{"$f":"IF($R10<>\"\",J83,\"\")","v":0},{"$f":"IF($R10<>\"\",K83,\"\")","v":{"$error":"#NUM!"}},{"$f":"IF($R10<>\"\",M83,\"\")","v":0}]
["LOCATION DESCRIPTION:",null,{"$f":"B67","v":0},null,null,null,null,null,null,2026,0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},1.05,{"$f":"J11","v":2026},0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},0]
[null,null,null,null,null,null,null,null,null,2027,0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},1.05,2027,0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},0]
[null,null,null,null,null,null,null,null,null,2028,0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},1.05,2028,0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},0]
["GROWTH RATE FORMULA",null,null,null,null,null,null,null,null,2029,0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},1.05,2029,0,{"$error":"#NUM!"},0,0.5,0,{"$error":"#NUM!"},0]
["  A:  Interpolation",null,null,null,null,null,null,null,null,2030,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2030,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["  B:  Enter Growth Rate",null,null,"Choose A, B, C, or D here:",null,null,{"$f":"IF(B68=1,\"A\",IF(B68=2,\"B\",IF(B68=3,\"C\",\"D\")))","v":"C"},null,null,2031,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2031,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["  C:  Enter All AADTs",null,null,null,null,null,null,null,null,2032,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2032,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["  D:  New Facility",null,null,"Linear Growth Rate",null,null,{"$f":"IF(C68=\"A\",IF(G16=\"B\",B73,IF(G16=\"A\",\"X\",\"\")),\"\")","v":""},null,"%",2033,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2033,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["   If \"A\" select an interpolation function",null,null,"Compounded Growth Rate",null,null,{"$f":"IF(C68=\"B\",IF(G16=\"B\",B73/100,IF(G16=\"A\",\"X\",\"\")),\"\")","v":""},null,"%",2034,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2034,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["   If \"B\" enter rate as decimals (1%=1.01)",null,null,"Decaying Growth Rate",null,null,{"$f":"IF(C68=\"C\",IF(G16=\"B\",B73,IF(G16=\"A\",\"X\",\"\")),\"\")","v":""},null,"%",2035,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2035,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["   If \"\"C\", or \"D\" continue to next section",null,null,"(select one)",null,null,null,null,null,2036,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2036,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
[null,null,null,null,null,null,null,null,null,2037,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2037,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["DESIGN INFORMATION",null,null,null,null,null,null,null,null,2038,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2038,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
[null,null,null,"AADT",null,null,null,null,null,2039,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2039,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["Existing Year",null,{"$f":"IF(B68=4,\"N/A\",B69)","v":2025},{"$f":"IF(B68=4,0,B71)","v":10000},null,{"$f":"\" Daily Direction Split \"","v":" Daily Direction Split "},null,{"$f":"B74","v":0.5},null,2040,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2040,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["Opening Year",null,{"$f":"B70","v":2030},{"$f":"IF(B68<3,IF(B68=1,\"N/A\",VLOOKUP(C26,A83:B187,2,TRUE)),B72)","v":20000},null,{"$f":"\"Lanes in One Direction \"","v":"Lanes in One Direction "},null,{"$f":"MAX(B76,C76)","v":2},null,2041,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2041,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["Interim Year",null,{"$f":"C70","v":2040},{"$f":"IF(B68<3,IF(B68=1,\"N/A\",VLOOKUP(C27,A83:B187,2,TRUE)),C72)","v":30000},null,{"$f":"\"T24  values\"","v":"T24  values"},null,null,null,2042,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2042,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["Design Year",null,{"$f":"D70","v":2050},{"$f":"IF(B68=2,VLOOKUP(C28,A83:B187,2,TRUE),D72)","v":40000},null,null,"Existing to Opening Year",{"$f":"B75","v":0},null,2043,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2043,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["    Note:  AADT values have been rounded to the nearest 100",null,null,null,null,null,"Opening to Interim Year",{"$f":"C75","v":0},null,2044,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2044,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
[null,null,null,null,null,null,"Interim Year to Design-Year",{"$f":"D75","v":0},null,2045,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2045,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["1995 EQUIVALENCY FACTORS |u(1)|",null,null,null,null,null,null,null,null,2046,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2046,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
["   (selected with an X)",null,null,"FLEXIBLE PAVEMENT",null,null,{"$f":"\"     RIGID PAVEMENT\"","v":"     RIGID PAVEMENT"},null,null,2047,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2047,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
[null,null,null,"SN = 5/THICK",null,null,{"$f":"\"     SN = 12/THICK\"","v":"     SN = 12/THICK"},null,null,2048,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2048,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
[null,"RURAL FREEWAY:",null,"1.050",{"$f":"IF($B$77=1,\"   X   \",\"       \")","v":"   X   "},null,"1.600",{"$f":"IF($B$79=1,\"   X   \",\"       \")","v":"       "},null,2049,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2049,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
[null,"URBAN FREEWAY:",null,"0.900",{"$f":"IF($B$77=2,\"   X   \",\"       \")","v":"       "},null,"1.270",{"$f":"IF($B$79=2,\"   X   \",\"       \")","v":"       "},null,2050,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},1.05,2050,0,{"$error":"#NUM!"},{"$error":"#NUM!"},0.5,0,{"$error":"#NUM!"},0]
[null,"RURAL HIGHWAY:",null,"0.960",{"$f":"IF($B$77=3,\"   X   \",\"       \")","v":"       "},null,"1.350",{"$f":"IF($B$79=3,\"   X   \",\"       \")","v":"       "},null,"","","","","","","","","","","","","","","",""]
[null,"URBAN HIGHWAY:",null,"0.890",{"$f":"IF($B$77=4,\"   X   \",\"       \")","v":"       "},null,"1.220",{"$f":"IF($B$79=4,\"   X   \",\"       \")","v":"       "},null,"","","","","","","","","","","","","","","",""]
[null,"OTHER (Enter Factor and X):",null,{"$f":"IF($B$77=5,$B$78,\"\")","v":""},{"$f":"IF($B$77=5,\"   X   \",\"       \")","v":"       "},null,{"$f":"IF($B$79=5,$B$80,\"\")","v":""},{"$f":"IF($B$79=5,\"   X   \",\"       \")","v":"       "},null,"","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",""]
["  (1)  Equivalency Factors are based on Updated Pavement Damage Factors Memorandum, dated July 2, 1998.",null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",""]
["  Lane Factors developed by Copes equation",null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"Opening to Interim Year ESAL Accumulation (1000s):",null,null,null,null,{"$f":"VLOOKUP(C70,J10:M43,4,FALSE)-VLOOKUP(B70,J10:M43,3,FALSE)","v":{"$error":"#NUM!"}},null,null,"Opening to Interim Year ESAL Accumulation (1000s):",null,null,null,null,{"$f":"VLOOKUP(C70,R10:U43,4,FALSE)-VLOOKUP(B70,R10:U43,3,FALSE)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Opening to Design Year ESAL Accumulation (1000s):",null,null,null,null,{"$f":"VLOOKUP(D70,J10:M43,4,FALSE)-VLOOKUP(B70,J10:M43,3,FALSE)","v":{"$error":"#NUM!"}},null,null,"Opening to Design Year ESAL Accumulation (1000s):",null,null,null,null,{"$f":"VLOOKUP(D70,R10:U43,4,FALSE)-VLOOKUP(B70,R10:U43,4,FALSE)","v":{"$error":"#NUM!"}}]
[" I have reviewed the 18 KIP Equivalent Single Axle Loads (ESAL's) to be used for pavement design on this project.  I hereby attest that these have been developed in accordance with the FDOT Project Traffic Forecasting Procedure using historical traffic data and other available information.",null,null,null,null,null,null,null,null," I have reviewed the 18 KIP Equivalent Single Axle Loads (ESAL's) to be used for pavement design on this project.  I hereby attest that these have been developed in accordance with the FDOT Project Traffic Forecasting Procedure using historical traffic data and other available information.",null,null,null,null,null,null,null," I have reviewed the 18 KIP Equivalent Single Axle Loads (ESAL's) to be used for pavement design on this project.  I hereby attest that these have been developed in accordance with the FDOT Project Traffic Forecasting Procedure using historical traffic data and other available information."]
[]
[]
["Prepared by:",null,null,null,null,null,null,null,null,"Prepared by:",null,null,null,null,null,null,null,"Prepared by:"]
[null,"Name",null,"Title",null,null,"Org. Unit or Firm",null,"Date",null,"Name",null,null,"Title",null,"Org. Unit or Firm","Date",null,"Name",null,null,"Title",null,"Org. Unit or Firm","Date"]
[]
[]
[null,"Signature",null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,"Signature"]
[]
["Reviewed by:",null,null,null,null,null,null,null,null,"Reviewed by:",null,null,null,null,null,null,null,"Reviewed by:"]
[null,"Name",null,"Title",null,null,"Org. Unit or Firm",null,"Date",null,"Name",null,null,"Title",null,"Org. Unit or Firm","Date",null,"Name",null,null,"Title",null,"Org. Unit or Firm","Date"]
[]
[]
[null,"Signature",null,null,null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,"Signature"]
[]
["User Input"]
["RoadwayID"]
["Location",1]
["FM ID#"]
["Project Desc."]
["County"]
["Location Desc."]
["Calc Method",3,"A","(A=straight line,B=compounded/exponential, C=decaying)"]
["Current Year",{"$f":"YEAR(NOW())","v":2025}]
["Design Years",{"$f":"YEAR(NOW())+5","v":2030},{"$f":"YEAR(NOW())+15","v":2040},{"$f":"YEAR(NOW())+25","v":2050}]
["AADTs",10000]
[null,20000,30000,40000]
["Growth Rate",0.5]
["DDS",{"$f":"MAX(B76:C76)/SUM(B76,C76)","v":0.5}]
["T Percentages",0,0,0]
["# Lanes",2,2,"Two-way"]
["Flexible",1]
["E18 Factor",1.05]
["Rigid",6]
["Value",0]
[]
["Year","AADT","ESAL1","ACCUM1",null,"ESAL2","ACCUM2",null,"D","T","LF","EF1","EF2"]
[{"$f":"B69","v":2025},0,{"$f":"CEILING(B83*PRODUCT(I83:L83)*365/1000,1)","v":{"$error":"#NUM!"}},{"$f":"IF(A83>=$B$70,C83,0)","v":0},null,{"$f":"CEILING(B83*PRODUCT(I83:K83,M83)*365/1000,1)","v":{"$error":"#NUM!"}},{"$f":"IF(A83>=$B$70,F83,0)","v":0},null,{"$f":"$B$74","v":0.5},{"$f":"IF(A83<$B$70,$B$75,IF(A83<$C$70,$C$75,$D$75))","v":0},{"$f":"IF($B$76=1,1,1.567-0.0826*LN(B83*$B$74)-0.12368*IF($B$76=2,0,1))","v":{"$error":"#NUM!"}},{"$f":"$B$78","v":1.05},{"$f":"$B$80","v":0}]
[{"$f":"A83+1","v":2026},0,{"$f":"CEILING(B84*PRODUCT(I84:L84)*365/1000,1)","v":{"$error":"#NUM!"}},{"$f":"IF(A84>=$B$70,C84,0)+D83","v":0},null,{"$f":"CEILING(B84*PRODUCT(I84:K84,M84)*365/1000,1)","v":{"$error":"#NUM!"}},{"$f":"IF(A84>=$B$70,F84,0)+G83","v":0},null,{"$f":"$B$74","v":0.5},{"$f":"IF(A84<$B$70,$B$75,IF(A84<$C$70,$C$75,$D$75))","v":0},{"$f":"IF($B$76=1,1,1.567-0.0826*LN(B84*$B$74)-0.12368*IF($B$76=2,0,1))","v":{"$error":"#NUM!"}},{"$f":"$B$78","v":1.05},{"$f":"$B$80","v":0}]
[{"$f":"A84+1","v":2027},0,{"$error":"#NUM!"},{"$f":"IF(A85>=$B$70,C85,0)+D84","v":0},null,{"$error":"#NUM!"},{"$f":"IF(A85>=$B$70,F85,0)+G84","v":0},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2028,0,{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2029,0,{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2030,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2031,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2032,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2033,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2034,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2035,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2036,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2037,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2038,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2039,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2040,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2041,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2042,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2043,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2044,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2045,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2046,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2047,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2048,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2049,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[2050,0,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$f":"CEILING(B148*PRODUCT(I148:L148)*365/1000,1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$f":"CEILING(B148*PRODUCT(I148:K148,M148)*365/1000,1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$f":"$B$74","v":0.5},{"$f":"IF(A148<$B$70,$B$75,IF(A148<$C$70,$C$75,$D$75))","v":0},{"$f":"IF($B$76=1,1,1.567-0.0826*LN(B148*$B$74)-0.12368*IF($B$76=2,0,1))","v":{"$error":"#NUM!"}},{"$f":"$B$78","v":1.05},{"$f":"$B$80","v":0}]
[null,null,{"$error":"#NUM!"},{"$f":"IF(A149>=$B$70,C149,0)+D148","v":{"$error":"#NUM!"}},null,{"$error":"#NUM!"},{"$f":"IF(A149>=$B$70,F149,0)+G148","v":{"$error":"#NUM!"}},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]
[null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},null,0.5,0,{"$error":"#NUM!"},1.05,0]

{"sheet":"Help","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["FM #","Enter the FM #. FM # can be obtained from the FDOT District Office."]
["Location","Enter the location number for the section that is being analyzed. For example, you may enter 1 if this is the first location in your project."]
["Roadway ID","Enter the 8-digit Roadway ID."]
["County","Enter the name of the County where the section is located."]
["Project Description","Enter description about the project. For example, Roadway starts from Roadway/MP x.xxx and ends at Roadway/MP x.xxx."]
["Location Description","Enter information on the location that is being analyzed. For example, this location starts at MP x.xxx and ends at MP x.xxx."]
["No. Segments","Enter the number of segments for ESAL calculations."]