{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Read First","Sheet1"],"not_rendered":{"charts":0,"images":290,"macros":1,"external_links":0,"defined_names":2,"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":"Read First","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,10,19,18],[21,11,25,18],[3,0,5,8],[6,10,9,18],[3,10,4,18],[11,10,15,18]]}
["Macro Settings",null,null,null,null,null,null,null,null,null,"Spreadsheet Instructions"]
[]
[]
["In order to utilize the Application as designed, users will need to activate the macros.  Instructions on how to enable the macro settings are listed below.  (Please Note:  Users will only need to be complete this action one time.)",null,null,null,null,null,null,null,null,null,"1.  Input only the cells with a \"yellow\" background.  Once data is input into the cells and select a different cell, the cell's background will revert to its original color."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"2.  There are several macros embedded within the spreadsheet to help the user create the application.  Therefore, several cells within the spreadsheet will trigger certain actions as in selecting a cell which will contain a date, will dynamically display a calendar for the user to select then automatically input a date into the cell."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"3.  The \"Existing Road Facilities\" Input will check to ensure the limits input by the user are within the limits of the NLF ID.  If the input values are valid, a green check mark is highlighted next to the row (within the gray area).  If the input values are not valid, the maximum and minimum values are shown to the right of the input value within the gray area."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"4.  Capturing the Beginning and Ending Lat. Long. for new facilities or for roadways which do not have a NLF ID, can be captured from Google maps.  Outlined below are instructions on how to capture the Lat. and Long. from Google maps."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"i.  Open Google Maps (Click the Link to the Right).",null,null,null,null,"Google Maps"]
[null,null,null,null,null,null,null,null,null,null,null,"ii.  Zoom into the location of the Begin Point of the Facility and right click on the Begin Point.  A dialog box will be displayed with several options, select \"What's here?\".  The Lat. Long. will then be displayed in the Search Box at the top of the Input box.  See Below for further details.  Input these values into the TRAC Application for further use and review."]

{"sheet":"Sheet1","index":1,"n_rows":345,"n_cols":34,"rows_kept":345,"cut":false,"hidden":false,"merged":[[338,6,338,7],[205,0,205,8],[206,14,206,15],[212,14,212,15],[206,11,206,13],[207,11,207,13],[225,9,225,13],[225,14,225,15],[208,11,208,13],[224,14,224,15],[211,14,211,15],[218,0,219,8],[217,0,217,16],[227,0,227,8],[228,14,228,15],[218,14,218,15],[218,9,218,13],[219,9,219,13],[219,14,219,15],[226,0,226,8],[229,9,229,13],[229,14,229,15],[229,0,229,8],[220,9,220,13],[203,9,203,10],[204,9,204,10],[205,9,205,10],[203,11,203,13],[204,11,204,13],[205,11,205,13],[212,9,212,10],[212,11,212,13],[209,9,209,10],[210,9,210,10],[211,9,211,10],[209,11,209,13],[210,11,210,13],[211,11,211,13],[220,14,220,15],[221,9,221,13],[221,14,221,15],[222,9,222,13],[222,14,222,15],[220,0,220,8],[221,0,221,8],[222,0,222,8],[223,0,223,8],[224,0,224,8],[225,0,225,8],[226,9,226,13],[226,14,226,15],[227,9,227,13],[227,14,227,15],[228,9,228,13],[223,9,223,13],[223,14,223,15],[224,9,224,13],[228,0,228,8],[209,0,209,8],[204,14,204,15],[205,14,205,15],[213,9,213,10],[214,9,214,10],[213,11,213,13],[214,11,214,13],[212,0,212,8],[209,14,209,15],[206,0,206,8],[208,0,208,8],[208,14,208,15],[207,0,207,8],[207,14,207,15],[206,9,206,10],[207,9,207,10],[208,9,208,10],[214,0,214,8],[214,14,214,15],[213,0,213,8],[213,14,213,15],[210,0,210,8],[210,14,210,15],[211,0,211,8],[203,14,203,15],[92,17,94,17],[109,14,109,15],[110,14,110,15],[111,14,111,15],[112,14,112,15],[113,14,113,15],[114,14,114,15],[98,14,98,15],[157,17,159,17],[128,14,128,16],[129,14,129,16],[105,14,105,15],[106,14,106,15],[107,14,107,15],[108,14,108,15],[97,14,97,15],[202,0,202,16],[203,0,204,8],[97,0,97,1],[101,2,101,6],[122,0,122,11],[121,0,121,11],[102,0,102,1],[245,17,246,17],[260,12,260,16],[261,12,261,16],[123,14,123,16],[203,17,204,17],[218,17,219,17],[126,14,126,16],[236,7,236,14],[237,7,237,14],[127,0,127,11],[126,0,126,11],[172,17,174,17],[173,0,174,2],[175,0,175,2],[141,0,141,16],[188,17,189,17],[188,9,189,16],[183,9,183,16],[184,9,184,16],[166,0,166,2],[168,0,168,2],[169,0,169,2],[169,3,169,4],[168,3,168,4],[101,14,101,15],[102,14,102,15],[103,14,103,15],[104,14,104,15],[100,14,100,15],[119,0,119,11],[122,14,122,16],[161,9,161,16],[165,0,165,2],[164,9,164,16],[162,9,162,16],[163,9,163,16],[165,9,165,16],[162,3,162,4],[102,2,102,6],[103,2,103,6],[104,2,104,6],[103,0,103,1],[110,2,110,6],[111,0,111,1],[112,0,112,1],[111,2,111,6],[112,2,112,6],[105,2,105,6],[166,3,166,4],[164,5,164,6],[164,0,164,2],[163,3,163,4],[164,3,164,4],[165,5,165,6],[163,5,163,6],[165,3,165,4],[163,0,163,2],[196,9,196,16],[197,9,197,16],[198,9,198,16],[199,9,199,16],[168,9,168,16],[191,9,191,16],[192,9,192,16],[193,9,193,16],[194,9,194,16],[195,9,195,16],[175,9,175,16],[178,9,178,16],[179,9,179,16],[173,9,174,16],[180,9,180,16],[181,9,181,16],[182,9,182,16],[177,9,177,16],[169,9,169,16],[188,5,189,5],[188,4,189,4],[187,0,187,16],[167,5,167,6],[168,5,168,6],[169,5,169,6],[176,0,176,2],[176,9,176,16],[177,0,177,2],[167,9,167,16],[167,3,167,4],[167,0,167,2],[172,0,172,16],[184,0,184,2],[173,3,174,3],[173,4,174,4],[173,5,174,5],[173,6,174,6],[181,0,181,2],[182,0,182,2],[178,0,178,2],[179,0,179,2],[173,7,173,8],[305,8,305,10],[305,11,305,16],[298,9,298,10],[255,12,255,16],[234,15,235,15],[257,12,257,16],[258,12,258,16],[259,12,259,16],[244,0,244,16],[245,13,245,16],[255,0,255,6],[240,7,240,14],[238,7,238,14],[256,0,256,4],[257,0,257,4],[258,0,258,4],[259,0,259,4],[260,0,260,4],[261,0,261,4],[262,0,262,4],[251,0,251,8],[239,0,239,6],[239,7,239,14],[248,0,248,8],[313,0,317,16],[295,13,295,14],[299,0,299,6],[298,0,298,5],[297,0,297,5],[296,0,296,5],[295,0,295,5],[294,0,294,5],[266,0,266,4],[267,0,267,4],[268,0,268,4],[269,0,269,4],[270,0,270,4],[271,0,271,4],[272,0,272,4],[273,0,273,4],[280,12,280,16],[281,12,281,16],[305,0,305,1],[305,2,305,7],[306,11,306,14],[306,15,306,16],[279,12,279,16],[292,11,292,15],[106,0,106,1],[106,2,106,6],[107,0,107,1],[105,0,105,1],[107,2,107,6],[104,0,104,1],[108,0,108,1],[108,2,108,6],[109,0,109,1],[109,2,109,6],[110,0,110,1],[101,0,101,1],[98,2,98,6],[120,0,120,11],[114,2,114,6],[255,29,255,33],[273,12,273,16],[274,12,274,16],[264,12,264,16],[265,12,265,16],[255,24,255,28],[266,12,266,16],[268,12,268,16],[272,12,272,16],[271,12,271,16],[256,12,256,16],[269,12,269,16],[270,12,270,16],[267,12,267,16],[263,12,263,16],[254,17,256,17],[262,12,262,16],[254,0,254,16],[255,7,255,11],[238,0,238,6],[236,0,236,6],[237,0,237,6],[190,9,190,16],[166,9,166,16],[166,5,166,6],[241,0,241,6],[240,0,240,6],[190,0,190,2],[188,0,189,2],[180,0,180,2],[183,0,183,2],[188,3,189,3],[188,7,188,8],[191,0,191,2],[192,0,192,2],[195,0,195,2],[196,0,196,2],[193,0,193,2],[194,0,194,2],[197,0,197,2],[198,0,198,2],[234,16,235,16],[188,6,189,6],[0,2,2,16],[14,0,14,16],[18,0,18,16],[22,0,22,16],[26,0,26,16],[38,0,47,16],[37,0,37,16],[30,11,30,16],[30,2,30,7],[32,9,32,10],[32,11,32,12],[6,13,6,14],[6,11,6,12],[31,3,31,16],[30,8,30,10],[13,0,13,16],[21,0,21,16],[30,0,30,1],[31,0,31,2],[32,1,32,8],[10,8,10,9],[33,3,33,4],[99,14,99,15],[5,0,5,16],[25,0,25,16],[10,13,10,14],[10,6,10,7],[10,15,10,16],[17,0,17,16],[10,0,10,2],[29,0,29,16],[33,5,33,7],[33,8,33,16],[32,13,32,14],[32,15,32,16],[100,2,100,6],[99,2,99,6],[92,0,92,16],[36,0,36,16],[50,0,50,16],[51,0,89,16],[93,0,93,1],[93,7,93,11],[93,2,93,6],[94,0,94,1],[100,0,100,1],[94,2,94,6],[96,2,96,6],[93,12,93,13],[93,14,93,15],[94,14,94,15],[97,2,97,6],[99,0,99,1],[96,0,96,1],[95,0,95,1],[95,2,95,6],[95,14,95,15],[96,14,96,15],[98,0,98,1],[158,9,159,16],[130,14,130,16],[160,9,160,16],[162,5,162,6],[158,3,159,4],[158,5,159,6],[160,3,160,4],[157,0,157,16],[160,0,160,2],[160,5,160,6],[161,3,161,4],[140,0,140,16],[162,0,162,2],[133,0,135,16],[161,5,161,6],[142,0,153,16],[131,12,131,13],[131,0,131,11],[130,0,130,11],[131,14,131,16],[158,7,158,8],[158,0,159,2],[161,0,161,2],[113,2,113,6],[114,0,114,1],[117,0,117,16],[130,12,130,13],[124,0,124,11],[123,0,123,11],[119,14,119,16],[118,0,118,11],[124,14,124,16],[125,14,125,16],[118,14,118,16],[125,0,125,11],[120,14,120,16],[121,14,121,16],[129,0,129,11],[127,14,127,16],[128,0,128,11],[129,12,129,13],[113,0,113,1],[199,0,199,2],[293,13,293,14],[294,13,294,14],[278,12,278,16],[297,7,297,8],[298,7,298,8],[299,9,299,10],[296,9,296,10],[294,11,294,12],[293,7,293,8],[297,9,297,10],[265,0,265,4],[274,0,274,4],[275,0,275,4],[276,0,276,4],[277,0,277,4],[278,0,278,4],[279,0,279,4],[280,0,280,4],[281,0,281,4],[233,15,233,16],[241,7,241,14],[233,0,235,6],[233,7,235,14],[247,13,247,14],[263,0,263,4],[264,0,264,4],[249,0,249,8],[245,0,246,8],[248,13,248,14],[249,13,249,14],[250,13,250,14],[245,9,245,12],[250,0,250,8],[246,13,246,14],[247,0,247,8],[296,13,296,14],[295,11,295,12],[296,11,296,12],[293,11,293,12],[292,0,293,5],[292,6,293,6],[292,7,292,10],[275,12,275,16],[276,12,276,16],[277,12,277,16],[291,0,291,16],[321,8,321,10],[321,11,321,16],[338,2,338,3],[232,0,232,16],[284,0,284,16],[285,0,288,16],[251,13,251,14],[292,16,293,16],[293,9,293,10],[297,13,297,14],[322,1,322,10],[298,13,298,14],[297,11,297,12],[298,11,298,12],[295,7,295,8],[296,7,296,8],[294,9,294,10],[294,7,294,8],[295,9,295,10],[320,0,320,16],[304,0,304,16],[299,13,299,14],[299,7,299,8],[299,11,299,12],[340,0,340,16],[341,2,341,4],[341,9,341,16],[342,9,342,11],[338,17,341,17],[322,17,325,17],[306,17,309,17],[345,0,349,16],[338,11,338,14],[338,15,338,16],[338,0,338,1],[329,0,333,16],[306,1,306,10],[337,0,337,1],[337,2,337,7],[337,8,337,10],[337,11,337,16],[321,0,321,1],[321,2,321,7],[322,15,322,16],[322,11,322,14],[326,0,326,1],[310,0,310,1],[336,0,336,16]]}
[null,null,"2011 TRAC Project Application",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District","County","County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"ALL","ADA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"DEF","ALL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"HAN","ASD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"HAR","ATB"]
["General Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"PAU","ATH"]
[null,null,null,null,null,null,null,null,null,null,null,"New",null,"Tier 1",null,"Tier 2",null,null,1,"PUT","AUG"]
["Previous TRAC Status …………………………………………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"VAN","BEL",false,false,false]
["Proposed TRAC Status …………………………………………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"WYA","BRO",null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"FUL","BUT"]
["ODOT District:",null,null,null,null,null,"County:",null,null,null,null,null,null,"ODOT PID:",null,null,null,null,2,"HEN","CAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"LUC","CHP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"OTT","CLA"]
["Local Jurisdictions (Counties, Townships, and/or Cities)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"SAN","CLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"SEN","CLI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"WIL","COL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"WOO","COS"]
["Facility Name (Route, Rail, Terminal, or Port Name)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"ASD","CRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"CRA","CUY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"ERI","DAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"HUR","DEF"]
["Principal Agency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"LOR","DEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"MED","ERI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"RIC","FAI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"WAY","FAY"]
["Participating Agencies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"ATB","FRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"MAH","FUL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"POR","GAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"STA","GEA"]
["Project Sponsor\n(Principal Contact Representing the TRAC Application)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"SUM","GRE"]
["First Name:",null,null,null,null,null,null,null,"Last Name:",null,null,null,null,null,null,null,null,null,4,"TRU","GUE"]
["Street Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"COS","HAM"]
["City:",null,null,null,null,null,null,null,null,"State:",null,null,null,"ZIP Code:",null,null,null,null,5,"FAI","HAN"]
["Phone Number:",null,null,null,null,"Email Address:",null,null,null,null,null,null,null,null,null,null,null,null,5,"GUE","HAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"KNO","HAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"LIC","HEN"]
["Project Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"MUS","HIG"]
["Description of Work (100 Words or Less)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"PER","HOC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A39=\"\",\"\",LEN(TRIM(A39))-LEN(SUBSTITUTE(A39,\" \",\"\"))+1)","v":""},6,"DEL","HOL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"FAY","HUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"FRA","JAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"MAD","JEF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"MAR","KNO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"MRW","LAK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"PIC","LAW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"UNI","LIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"AUG","LOG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"CHP","LOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"CLA","LUC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"DAR","MAD"]
["Purpose and Need (500 Words or Less)                                                              Note: To Start a New Paragraph Type \"Alt + Enter\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"LOG","MAH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A52=\"\",\"\",LEN(TRIM(A52))-LEN(SUBSTITUTE(A52,\" \",\"\"))+1)","v":""},7,"MER","MAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"MIA","MED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"MOT","MEG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"SHE","MER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"BUT","MIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"CLE","MOE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"CLI","MOT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"GRE","MRG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"HAM","MRW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"PRE","MUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"WAR","NOB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"ADA","OTT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"BRO","PAU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"HIG","PER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"JAC","PIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"LAW","PIK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"PIK","POR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"ROS","PRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"SCI","PUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"ATH","RIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"GAL","ROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"HOC","SAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"MEG","SCI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"MOE","SEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"MRG","SHE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"NOB","STA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"VIN","SUM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"WAS","TRU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"BEL","TUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"CAR","UNI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"COL","VAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"HAS","VIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"HOL","WAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"JEF","WAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"TUS","WAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"CUY","WIL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"GEA","WOO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"LAK","WYA"]
[]
[]
[]
["Project Relationship",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click the Plus Sign Below to Add a Row."]
["ODOT PID",null,"Project Name",null,null,null,null,"Phases Included",null,null,null,null,"Ex. TRAC Project",null,"TRAC List Date",null,"TRAC List Line No."]
[null,null,"County-Route-Section",null,null,null,null,"PS","PE","DD","RW","CO","Yes","No","MM/DD/YY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[]
[]
["Community and Economic Growth and Development Components"]
["Component",null,null,null,null,null,null,null,null,null,null,null,"Yes","No","Comment"]
["Project Location Map is Attached, Map 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Economic Impact Map is Attached, Map 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Redevelopment Map is Attached, Map 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Employment Map is Attached, Map 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Land Use Plan (LUP) is Attached",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["LUP Coordinates with Transportation Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Zoning Supports Transportation Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["On State/RPC/MPO Long Range Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Buisness Data Added to Map 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Improves Investment and Employment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
["Percent of Developed Land, Map 3"]
["* Sub-County 5 Year Unemployment Rate"]
["* Sub-County 5 Year Poverty Rate"]
[]
["* - Optional.  If omitted, the 5 year rates for the primary county will be obtained from the US Bureau of Labor Statistics (www.bls.gov) and US Census Bureau (www.census.gov)."]
[]
[]
[]
[]
[]
[]
["Intermodal Connectivity"]
["If the project connects different transportation modes, please describe the connections."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Existing Road Facilities By NLFID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click the Plus Sign Below to Add a Row."]
["ODOT NLFID",null,null,"Begin Log Point",null,"End Log\nPoint",null,"Primary Road",null,"Location Termini"]
[null,null,null,null,null,null,null,"Yes","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,{"$f":"IF(AND(A161<>\"\",OR(D161<S161,D161>T161)),1,\"\")","v":""},{"$f":"IF(AND(A161<>\"\",OR(F161<S161,F161>T161)),1,\"\")","v":""},{"$f":"IF(OR(D161=\"\",F161=\"\"),1,\"\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,{"$f":"IF(AND(A162<>\"\",OR(D162<S162,D162>T162)),1,\"\")","v":""},{"$f":"IF(AND(A162<>\"\",OR(F162<S162,F162>T162)),1,\"\")","v":""},{"$f":"IF(OR(D162=\"\",F162=\"\"),1,\"\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"","",1]
[]
[]
["Existing Road Facilities By Lat Long (Not within the NLFID Inventory)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click the Plus Sign Below to Add a Row."]
["Name or Designation",null,null,"Begin Lat.","Begin Long.","End Lat.","End Long.","Primary Road",null,"Location Termini"]
[null,null,null,null,null,null,null,"Yes","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,{"$f":"IF(AND(A176<>\"\",OR(D176<S176,D176>T176)),1,\"\")","v":""},{"$f":"IF(AND(A176<>\"\",OR(F176<S176,F176>T176)),1,\"\")","v":""},{"$f":"IF(OR(D176=\"\",F176=\"\"),1,\"\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(A177=\"\",D177=\"\",F177=\"\"),\"\",IF(OR(D177=\"\",F177=\"\"),\"Min:\"&S177&\", Max:\"&T177,IF(AND(OR(U177=1,V177=1),W177=\"\"),\"Min:\"&S177&\", Max:\"&T177,1)))","v":""},false,false,{"$f":"IF(AND(A177<>\"\",OR(D177<S177,D177>T177)),1,\"\")","v":""},{"$f":"IF(AND(A177<>\"\",OR(F177<S177,F177>T177)),1,\"\")","v":""},{"$f":"IF(OR(D177=\"\",F177=\"\"),1,\"\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",false,false,"","",1]
[]
[]
["New Road Facilities"]
["Name or Designation",null,null,"Begin Lat.","Begin Long.","End Lat.","End Long.","Primary Road",null,"Location Termini",null,null,null,null,null,null,null,"Click the Plus Sign Below to Add a Row."]
[null,null,null,null,null,null,null,"Yes","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
[]
["Transit Facilities"]
["Transit Type and Route/Name",null,null,null,null,null,null,null,null,"Peak Hour Ridership",null,"Existing Capacity",null,null,"Added Peak Hour Capacity",null,"VMT Reduction","Click the Plus Sign Below to Add a Row."]
[null,null,null,null,null,null,null,null,null,"(Riders)",null,"(Seats)",null,null,"(Seats)",null,"(VMT)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Freight Facilities"]
["Freight Type and Route/Name",null,null,null,null,null,null,null,null,"Ex. Freight Volume/\nEx. Facility Capacity Ratio",null,null,null,null,"Reduction in Truck Miles Traveled",null,"Freight Capaacity Increase\nRatio","Click the Plus Sign Below to Add a Row."]
[null,null,null,null,null,null,null,null,null,"(x.xxx)",null,null,null,null,"(TMT)",null,"(TEU/Day)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Project Development"]
["Project Phase",null,null,null,null,null,null,"Performed By\n(Agency Name)",null,null,null,null,null,null,null,"Actual or Proposed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start\nDate","Finish\nDate"]
[]
["Planning Study, PS"]
["Interchange Modification Study, IMS"]
["Interchange Justification Study, IJS"]
["Preliminary Engineering/NEPA, PE"]
["Detailed Design, DD"]
["Right of Way / Utilities, RW"]
[]
[]
["Financing Tools"]
["Description",null,null,null,null,null,null,null,null,"Financing Type",null,null,null,"Status",null,null,null,"Click the Plus Sign Below to Add a Row."]
[null,null,null,null,null,null,null,null,null,"TIF","SID","TIA","Other","Created",null,"Under Development","Under Consideration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false]
[]
[]
["Funding Sources  (Non-TRAC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click the Plus Sign Below to Add a Row."]
["Source",null,null,null,null,null,null,"Project Phase",null,null,null,null,"Amount",null,null,null,null,null,null,null,null,null,null,null,"ODOT Funded",null,null,null,null,"Local Funded"]
["Description",null,null,null,null,"ODOT\nFunds"," Federal\nEarmark\nFunds","PS","PE","DD","RW","CO","(Dollars)",null,null,null,null,null,"PS","PE","DD","RW","CO","Local Funded","PS","PE","DD","RW","CO","PS","PE","DD","RW","CO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,{"$f":"IF(G258=\"Yes\",TRUE,IF(F258=\"Yes\",FALSE,TRUE))","v":true},{"$f":"IF(AND(S258=TRUE,$X258=FALSE),$M258,\"\")","v":""},{"$f":"IF(AND(T258=TRUE,$X258=FALSE),$M258,\"\")","v":""},{"$f":"IF(AND(U258=TRUE,$X258=FALSE),$M258,\"\")","v":""},{"$f":"IF(AND(V258=TRUE,$X258=FALSE),$M258,\"\")","v":""},{"$f":"IF(AND(W258=TRUE,$X258=FALSE),$M258,\"\")","v":""},{"$f":"IF(AND(S258=TRUE,$X258=TRUE),$M258,\"\")","v":""},{"$f":"IF(AND(T258=TRUE,$X258=TRUE),$M258,\"\")","v":""},{"$f":"IF(AND(U258=TRUE,$X258=TRUE),$M258,\"\")","v":""},{"$f":"IF(AND(V258=TRUE,$X258=TRUE),$M258,\"\")","v":""},{"$f":"IF(AND(W258=TRUE,$X258=TRUE),$M258,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,{"$f":"IF(G259=\"Yes\",TRUE,IF(F259=\"Yes\",FALSE,TRUE))","v":true},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,true,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Y258:Y282)/1000000,3)","v":0},{"$f":"ROUND(SUM(Z258:Z282)/1000000,3)","v":0},0,0,0,0,0,0,0,0]
[]
["Explanation of Other Funding"]
[]
[]
[]
[]
[]
[]
["Project Funding (in Millions)"]
["Project Phase",null,null,null,null,null,"FY","Non-TRAC",null,null,null,"TRAC",null,null,null,null,"Phase Total"]
[null,null,null,null,null,null,null,"Local",null,"ODOT",null,"Previous",null,"New",null,"Future"]
["Planning Study, PS",null,null,null,null,null,null,{"$f":"AD283","v":0},null,{"$f":"Y283","v":0},null,null,null,null,null,null,{"$f":"SUM(H295:P295)","v":0}]
["Preliminary Engineering, PE",null,null,null,null,null,null,{"$f":"AE283","v":0},null,{"$f":"Z283","v":0},null,null,null,null,null,null,{"$f":"SUM(H296:P296)","v":0}]
["Detailed Design, DD",null,null,null,null,null,null,{"$f":"AF283","v":0},null,{"$f":"AA283","v":0},null,null,null,null,null,null,{"$f":"SUM(H297:P297)","v":0}]
["Right of Way / Utilities, RW",null,null,null,null,null,null,{"$f":"AG283","v":0},null,{"$f":"AB283","v":0},null,null,null,null,null,null,{"$f":"SUM(H298:P298)","v":0}]
["Construction, CO",null,null,null,null,null,null,{"$f":"AH283","v":0},null,{"$f":"AC283","v":0},null,null,null,null,null,null,{"$f":"SUM(H299:P299)","v":0}]
["Totals",null,null,null,null,null,null,{"$f":"SUM(H295:I299)","v":0},null,{"$f":"SUM(J295:K299)","v":0},null,{"$f":"SUM(L295:M299)","v":0},null,{"$f":"SUM(N295:O299)","v":0},null,{"$f":"SUM(P295:P299)","v":0},{"$f":"SUM(Q295:Q299)","v":0}]
[]
[]
[]
[]
["Applicant Information"]
["First Name:",null,null,null,null,null,null,null,"Last Name:"]
["Title: ",null,null,null,null,null,null,null,null,null,null,"Phone Number:"]
[]
[]
[]
["Signature: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date: "]
[]
["Comments:"]
[]
[]
[]
[]
[]
[]
[]
["MPO Acknowledgement   (if applicable)"]
["First Name:",null,null,null,null,null,null,null,"Last Name:"]
["MPO:",null,null,null,null,null,null,null,null,null,null,"Phone Number:"]
[]
["Sent to MPO:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date: "]
[]
["Comments/MPO Ranking(s):"]
[]
[]
[]
[]
[]
[]
[]
["ODOT District Acknowledgement"]
["First Name:",null,null,null,null,null,null,null,"Last Name:"]
["District:",null,null,null,null,"Date:",null,null,null,null,null,"Phone Number:"]
[]
["MPO Information"]
["MPO Agency:",null,null,null,null,null,null,null,"Individual Contacted:"]
["Date District Received Email of MPO Acknowledgement:"]
[]
["Comments/Safety Rankings/Congestion Rankings/MPO Rankings:"]