{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Page1 - Expense Report","Page 2 - Travel Expenses","per diem tables","Cities"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":26,"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":77,"n_cols":6,"rows_kept":77,"cut":false,"hidden":false,"merged":[[37,0,37,12],[32,2,32,12],[35,2,35,12],[35,0,35,1],[33,2,33,12],[32,0,32,1],[33,0,33,1],[46,2,46,12],[50,2,50,12],[39,2,40,12],[71,2,71,11],[44,0,44,12],[46,0,46,1],[48,2,48,12],[48,0,48,1],[50,0,50,1],[41,2,41,12],[39,0,39,1],[79,0,79,12],[52,0,52,1],[76,2,76,11],[57,0,57,1],[55,0,55,12],[65,2,65,11],[67,2,67,11],[69,2,69,11],[63,2,63,11],[57,2,57,11],[61,2,61,11],[52,2,53,12],[59,2,59,11],[72,2,72,11],[74,2,74,11],[0,0,0,3],[0,5,0,12],[9,0,9,1],[1,0,1,12],[19,2,19,12],[13,2,13,12],[19,0,19,1],[5,2,5,12],[7,0,7,1],[13,0,13,1],[9,2,9,12],[11,2,11,12],[2,5,2,12],[3,0,3,11],[24,0,24,1],[23,2,23,12],[5,0,5,1],[11,0,11,1],[7,2,7,12],[15,2,15,12],[15,0,15,1],[17,0,17,1],[17,2,17,12],[21,2,21,12],[24,2,24,12],[21,0,21,1],[23,0,23,1]]}
[null,null,null,null,null,"Travel Expense Statement - Instructions\n"]
["This form should be completed by any agency that is not using the Concur Travel and Expense Management System.  Use the Per Diem Calculator Tool (included with this form) to determine the total meal allowance due to the traveler (if applicable).\n"]
[]
["Section 1: Expense Submitter & Preparer Information"]
[]
["Agency & Traveler Name",null,"Enter the expense submitter's agency name and in the appropriate field enter the Traveler's name"]
[]
["Employee ID#",null,"Enter expense submitter's employee ID #"]
[]
["Home Address",null,"Enter the expense submitter's street address"]
[]
["City, State, Zip",null,"Enter the expense submitter's home city, state, and zip"]
[]
["Office Phone:",null,"Enter expense submitter's phone number"]
[]
["Email Address:",null,"Enter expense submitter's email address"]
[]
["Type of Travel:",null,"Select dropdown box for: In State, Out of State, or International Travel"]
[]
["Travel To Date:",null,"Enter first date of the trip"]
[]
["Travel From Date:",null,"Enter last date of trip"]
[]
["Departure & Return Time:",null,"Enter the time you left on the first day of your trip and the time you returned on the last day of your trip"]
["Section 2: Record of Expenses",null,"This section summarizes the Travel Expenses from page 2, the Mileage Expenses from page 3, and the M&IE Per diem amount calculated with the Per diem Calculator Tool on page 4."]
[]
["Date",null,"Write out the date in the MM/DD/YY format"]
[]
["Per Diem",null,"For the First and Last Day, check the box in the per diem field (Only 75% of Per Diem Eligible for Reimbursement on the First and Last Day "]
[null,null,"of an authorized trip.  Also, note that when a meal is provided the eligible reimbursable per diem is reduced by the amount allocated for that"]
[null,null,"particular meal at the 100% rate -- this is a State Policy)."]
[]
["Total Expenses",null,"The sum of the expenses in the Amount column will total here"]
["Travel Advance ",null,"If the expense submitter obtained a travel advance prior to the trip, enter the amount of the advance"]
[]
["Due TO/FROM the Expense Submitter",null,"If the expenses were greater than the total of the advances, the net amount owed TO the expense submitter will total here. If the advances were greater than the expense amount, the net amount due FROM the expense submitter will total here. If the expense submitter owes the State money, please attach a personal check to the expense report"]
[]
["Section 3: Certification and Attestation"]
[]
["Traveler Signature",null,"Enter the name of the traveler"]
[]
["Approver Signatures",null,"Note:  The individual/s below who approve the Travel and Expense Statement are certifying the following: \n           \n           *      Appropriateness of the expenditure and reasonableness of the amount            \n           *      Availability of funds            \n           *      Compliance with Statewide Travel Regulations          \n           *      Completeness of documentation and accuracy           "]
[]
[]
["Page 2  - Itemized Travel Expenses"]
[]
["Purpose of Trip/Event",null,"Clearly state the business purpose of the trip or event; include the conference name if applicable"]
[]
["Record of Travel Expenses",null,"Itemize all expenses by date and type. An original receipt is required for any item $25 or greater. Original receipts are also required for all lodging and airline expenses, regardless of amount."]
[]
["Common Carrier, Etc…",null,"Enter amount of any commercial transportation used during a trip (Receipts are required) Other expenses charged to this account include parking, taxes, and tolls"]
[]
["Miscellaneous Expenses",null,"Use this space to include expenses that do not apply to any of the above categories. List the date and provide a description of the expense.  Attach an additional sheet if necessary. "]
[]
[]
["Page 3 - Personal Vehicle Mileage"]
[]
["Traveler Name",null,"Enter the name of the employee: last name, first name, middle initial"]
[]
["Date",null,"Enter date of the traveler's departure"]
[]
["Origin",null,"Enter location where the trip began"]
[]
["Destination",null,"Enter final destination of business trip"]
[]
["Business Miles",null,"Enter total business miles for the travel"]
[]
["Commute Miles",null,"Enter total commute miles for the travel (Miles from home to work location)"]
[]
["Personal Miles",null,"Enter any personal miles that occurred during the travel"]
[]
["State Use Miles",null,"State use miles will automatically calculate (deducting any commute miles and personal miles)"]
["Mileage Rate",null,"Verify that correct mileage rate populated.   Total State use miles will automatically populate in Page 1 of the expense report."]
[]
["Motor Pool",null,"Mark the box if motor pool vehicle was used"]
[]
["Shared Transportation",null,"Enter names of individuals that rode with the traveler"]

{"sheet":"Page1 - Expense Report","index":1,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":false,"merged":[[23,0,23,3],[24,0,24,3],[25,0,25,3],[25,6,25,7],[23,4,23,5],[25,4,25,5],[23,6,23,7],[24,6,24,7],[24,4,24,5],[14,8,14,12],[14,0,14,7],[22,0,22,3],[22,4,22,5],[15,4,15,5],[20,0,20,3],[21,0,21,3],[20,4,20,5],[21,4,21,5],[19,6,19,7],[20,6,20,7],[18,6,18,7],[22,6,22,7],[21,6,21,7],[32,0,32,11],[33,0,33,11],[26,4,26,5],[31,0,31,11],[30,0,30,6],[26,0,26,3],[26,6,26,7],[45,0,45,11],[35,0,35,11],[40,0,40,11],[42,0,42,11],[44,0,44,11],[43,0,43,11],[38,0,38,12],[37,0,37,12],[41,0,41,11],[39,0,39,11],[34,2,34,4],[6,11,6,12],[0,0,0,6],[19,4,19,5],[16,4,16,5],[17,4,17,5],[17,0,17,3],[18,0,18,3],[15,0,15,3],[17,6,17,7],[3,3,3,7],[18,4,18,5],[16,0,16,3],[15,6,15,7],[16,6,16,7],[19,0,19,3],[0,7,0,12],[1,0,1,12],[12,0,12,12],[2,9,2,10],[4,3,4,7],[5,3,5,7],[9,3,9,7],[7,3,7,7],[6,3,6,7],[8,3,8,7],[3,11,3,12],[8,11,8,12],[7,11,7,12],[4,11,4,12],[5,11,5,12],[9,11,9,12]]}
[null,null,null,null,null,null,null,"DOMESTIC"]
["Section 1: Expense Submitter and Personal Information"]
[]
["Agency:",null,null,"Savannah State University",null,null,null,null,null,"Type of Travel",null,null,null,null,null,null,null,null,null,null,"In State"]
["Traveler's Name:",null,null,null,null,null,null,null,null,"From Date: MM/DD/YY",null,null,null,null,null,null,null,null,null,null,"Out of State"]
["Employee ID #:",null,null,null,null,null,null,null,null,"To Date: MM/DD/YY",null,null,null,null,null,null,null,null,null,null,"International"]
["Home Address:",null,null,null,null,null,null,null,null,"Departure Time:"]
["City, State, Zip:",null,null,null,null,null,null,null,null,"Return Time:"]
["Office Phone:",null,null,null,null,null,null,null,null,"Travel Destination:",null,"GA, Athens"]
["Email Address:",null,null,null,null,null,null,null,null,"If Other, Specify"]
[]
[]
["Section 2: Record of Expenses"]
["Daily Per Diem:",{"$f":"VLOOKUP(L9,Table1[#All],6,FALSE)","v":50},null,null,"In-State: $28.00, High Cost Areas $36.00 (Cobb, DeKalb, Fulton, Glynn, and Richmond Counties);                                                                   For Out-of-State Per Diems, refer to www.gsa.gov, and deduct Incidentals ($5.00/Day)"]
[" þ First & Last Day, Please Check Box in Per Diem Column",null,null,null,null,null,null,null,"þ For Provided Meals, Please Check Box"]
["Date: (Ex: 10/01/2012)",null,null,null,"Per Diem ",null,"Location",null,"Breakfast","Lunch","Dinner","Lodging","Amount",null,"Per Diem","Is Blank A17","B","L","D"]
[{"$f":"IF(ISBLANK(L5),\"\",SUM(L5))","v":""},null,null,null,{"$f":"IF(COUNTBLANK(A17),\"\",IF(O17=TRUE,$B$14*0.75,$B$14))","v":""},null,{"$f":"IF(COUNTBLANK(A17)=1,\"\",IF(ISBLANK($B$14),\"\",IF($B$14=0,\"\",$L$9)))","v":""},null,{"$f":"IF($E$17=\"\",\"\",IF(Q17=TRUE,SUM(VLOOKUP($E$17,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R17=TRUE,SUM(VLOOKUP($E$17,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S17=TRUE,SUM(VLOOKUP($E$17,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,{"$f":"IF(COUNTBLANK(E17),\"\",E17+SUM(I17:K17)+L17)","v":""},null,false,{"$f":"ISBLANK(A17)","v":false},false,false,false]
[{"$f":"IF(A17<$L$6,A17+1,\"\")","v":""},null,null,null,{"$f":"IF(COUNTBLANK(A18),\"\",IF(O18=TRUE,$B$14*0.75,$B$14))","v":""},null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q18=TRUE,SUM(VLOOKUP($E$18,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R18=TRUE,SUM(VLOOKUP($E$18,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S18=TRUE,SUM(VLOOKUP($E$18,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,{"$f":"IF(COUNTBLANK(E18),\"\",E18+SUM(I18:K18)+L18)","v":""},null,false,{"$f":"ISBLANK(A18)","v":false},false,false,false]
[{"$f":"IF(A18<$L$6,A18+1,\"\")","v":""},null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q19=TRUE,SUM(VLOOKUP($E$19,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R19=TRUE,SUM(VLOOKUP($E$19,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S19=TRUE,SUM(VLOOKUP($E$19,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q20=TRUE,SUM(VLOOKUP($E$20,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R20=TRUE,SUM(VLOOKUP($E$20,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S20=TRUE,SUM(VLOOKUP($E$20,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,{"$f":"IF(COUNTBLANK(A21),\"\",IF(O21=TRUE,$B$14*0.75,$B$14))","v":""},null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q21=TRUE,SUM(VLOOKUP($E$21,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R21=TRUE,SUM(VLOOKUP($E$21,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S21=TRUE,SUM(VLOOKUP($E$21,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q22=TRUE,SUM(VLOOKUP($E$22,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R22=TRUE,SUM(VLOOKUP($E$22,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S22=TRUE,SUM(VLOOKUP($E$22,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q23=TRUE,SUM(VLOOKUP($E$23,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R23=TRUE,SUM(VLOOKUP($E$23,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S23=TRUE,SUM(VLOOKUP($E$23,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q24=TRUE,SUM(VLOOKUP($E$24,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R24=TRUE,SUM(VLOOKUP($E$24,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S24=TRUE,SUM(VLOOKUP($E$24,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q25=TRUE,SUM(VLOOKUP($E$25,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R25=TRUE,SUM(VLOOKUP($E$25,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S25=TRUE,SUM(VLOOKUP($E$25,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q26=TRUE,SUM(VLOOKUP($E$26,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R26=TRUE,SUM(VLOOKUP($E$26,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S26=TRUE,SUM(VLOOKUP($E$26,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["",null,null,null,"",null,"",null,{"$f":"IF($E$17=\"\",\"\",IF(Q27=TRUE,SUM(VLOOKUP($E$27,'per diem tables'!$A$2:$D$18,2,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(R27=TRUE,SUM(VLOOKUP($E$27,'per diem tables'!$A$2:$D$18,3,FALSE)*-1),\"\"))","v":""},{"$f":"IF($E$17=\"\",\"\",IF(S27=TRUE,SUM(VLOOKUP($E$27,'per diem tables'!$A$2:$D$18,4,FALSE)*-1),\"\"))","v":""},null,"",null,false,false,false,false,false]
["Explain Any Unusual Amounts for Subsistence:",null,null,null,null,null,null,"Amount by Column",{"$f":"SUM(I17:I27)","v":0},{"$f":"SUM(J17:J27)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(M17:M28)","v":0}]
[]
["State Use Miles:           Over 50 Miles                           Within 50 Mile Radius",null,null,null,null,null,null,"Rate",{"$f":"IF(O31=TRUE,0.585,IF(P31=TRUE,0.18,\"\"))","v":""},"Total Miles",{"$f":"'Page 2 - Travel Expenses'!I23","v":0},null,{"$f":"IF(COUNTBLANK(I31),\"\",I31*K31)","v":""},null,false,false]
["Common Carrier / Limousine (Explain in Section on Page 2)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Page 2 - Travel Expenses'!I40","v":0}]
["Miscellaneous Expenses (Explain in Section on Page 2)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Page 2 - Travel Expenses'!I47","v":0}]
["TOTAL TRAVEL EXPENSE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M29:M33)","v":0}]
["Travel Advance V#:  ",null,null,null,null,"← Enter Cash Advance #, if applicable"]
["Due TO/FROM Expense Submitter:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M34-M35","v":0}]
[]
["Section 3: Certification and Attestation"]
["I do solemnly swear, under criminal penalty of a felony for false statements subject to punishment by fine of not more than $1,000 or by imprisonment of not less than one nor more than five years, that the above statements are true and I have incurred the described expenses and the state use mileage in the discharge of my official duties of the state.\""]
[]
["Traveler Signature:",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["Supervisor Signature",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["Budget Unit Head Signature:",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["Title III Signature (if applicable):",null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Page 2 - Travel Expenses","index":2,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":false,"merged":[[25,0,25,1],[44,1,44,7],[45,1,45,7],[31,0,32,0],[6,7,7,7],[27,0,27,8],[42,1,42,7],[43,1,43,7],[35,1,35,7],[34,1,34,7],[6,3,6,4],[6,8,7,8],[46,0,46,7],[28,0,28,8],[29,0,29,8],[33,1,33,7],[31,1,32,7],[39,0,39,7],[41,1,41,7],[37,1,37,7],[38,1,38,7],[40,1,40,7],[36,1,36,7],[31,8,32,8],[30,0,30,8],[0,0,0,1],[0,2,0,3],[1,0,1,3],[3,1,3,2],[6,6,7,6],[6,0,7,0],[6,1,7,1],[6,2,7,2],[3,3,3,4],[5,2,5,4]]}
[null,null,null,null,null,"Itemized Travel Expenses"]
[]
[]
["Traveler Name:",{"$f":"'Page1 - Expense Report'!D5","v":0},null,"GA License Plate Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES",null,"Automobile"]
[]
[null,null,"Select type of personal vehicle:",null,null,"Automobile"]
["Date","Origin","Destination","Odometer Readings (Optional)",null,null,"Commute Miles","Personal Miles","State Use Miles"]
[null,null,null,"Starting ","Ending","Total Miles"]
[null,null,null,null,null,{"$f":"E9-D9","v":0},null,null,{"$f":"+F9-G9-H9","v":0}]
[null,null,null,null,null,0,null,null,{"$f":"+F10-G10-H10","v":0}]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
["Indicate use of motor pool vehicle or shared transportation:",null,null,null,null,null,"Total State Use Miles",null,{"$f":"SUM(I9:I22)","v":0}]
[]
["        Motor Pool Vehicle was used for travel"]
["Person(s) traveled with: "]
[]
["Purpose of the Trip:"]
[]
[]
["All reimbursable expenses must be listed and appropriate original receipts attached. "]
["Date","Commercial Transportation (Including Parking, Taxi, Tolls)",null,null,null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
["TOTAL COMMON CARRIER, ETC…",null,null,null,null,null,null,null,{"$f":"SUM(I34:I39)","v":0}]
["Date","Miscellaneous Expenses",null,null,null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
["TOTAL MISCELLANEOUS",null,null,null,null,null,null,null,{"$f":"SUM(I42:I46)","v":0}]
["Note:  Please be sure to attach all necessary receipts, indicate travel start time on the departure date and the travel return time on the return date, and to"]
["attach program agendas (conference schedule), if applicable."]

{"sheet":"per diem tables","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Domestic"]
["M&IE Total","Breakfast","Lunch","Dinner","Incidentals","Column1"]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":50},13,14,23,0]
[{"$f":"A3*0.75","v":37.5},{"$f":"B3*0.75","v":9.75},10.5,17.25,0]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":54},13,15,26,0]
[{"$f":"A5*0.75","v":40.5},{"$f":"B5*0.75","v":9.75},{"$f":"C5*0.75","v":11.25},19.5,0]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":59},14,16,29,0]
[{"$f":"A7*0.75","v":44.25},{"$f":"B7*0.75","v":10.5},{"$f":"C7*0.75","v":12},{"$f":"D7*0.75","v":21.75},0]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":64},16,17,31,0]
[{"$f":"A9*0.75","v":48},{"$f":"B9*0.75","v":12},{"$f":"C9*0.75","v":12.75},{"$f":"D9*0.75","v":23.25},0]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":69},17,18,34,0]
[{"$f":"A11*0.75","v":51.75},{"$f":"B11*0.75","v":12.75},{"$f":"C11*0.75","v":13.5},{"$f":"D11*0.75","v":25.5},0]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":74},18,20,36,0]
[{"$f":"A13*0.75","v":55.5},{"$f":"B13*0.75","v":13.5},{"$f":"C13*0.75","v":15},{"$f":"D13*0.75","v":27},0]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":79},19,22,38,0]
[{"$f":"A15*0.75","v":59.25},{"$f":"B15*0.75","v":14.25},{"$f":"C15*0.75","v":16.5},{"$f":"D15*0.75","v":28.5},0]
[{"$f":"SUM(Table2[[#This Row],[Breakfast]:[Dinner]])","v":84},20,24,40,0]
[{"$f":"A17*0.75","v":63},{"$f":"B17*0.75","v":15},{"$f":"C17*0.75","v":18},{"$f":"D17*0.75","v":30},0]

{"sheet":"Cities","index":4,"n_rows":370,"n_cols":6,"rows_kept":370,"cut":false,"hidden":true,"merged":[]}
["FY2022 Per Diem Rates - Effective February 1, 2022",null,null,null,null,"Less Incidentals"]
["City,State","DESTINATION CITY","DESTINATION STATE","COUNTY","FY22 Meals","SSU Meals"]
[{"$f":"CONCATENATE(C3,\", \",B3)","v":"AL, Birmingham"},"Birmingham","AL","Jefferson",69,{"$f":"E3-5","v":64}]
["AL, Gulf Shores","Gulf Shores","AL","Baldwin",69,64]
["AL, Mobile","Mobile","AL","Mobile",59,54]
[{"$f":"CONCATENATE(C6,\", \",B6)","v":"AL, Other"},"Other","AL","AL, Other",59,{"$f":"E6-5","v":54}]
["AR, Hot Springs","Hot Springs","AR","Garland",64,59]
[{"$f":"CONCATENATE(C8,\", \",B8)","v":"AR, Other"},"Other","AR","AR, Other",59,{"$f":"E8-5","v":54}]
["AZ, Grand Canyon / Flagstaff","Grand Canyon / Flagstaff","AZ","Coconino / Yavapai less the city of Sedona",74,69]
[{"$f":"CONCATENATE(C10,\", \",B10)","v":"AZ, Kayenta"},"Kayenta","AZ","Navajo",64,{"$f":"E10-5","v":59}]
["AZ, Phoenix / Scottsdale","Phoenix / Scottsdale","AZ","Maricopa",69,64]
["AZ, Sedona","Sedona","AZ","City Limits of Sedona",79,74]
["AZ, Tucson","Tucson","AZ","Pima",64,59]
[{"$f":"CONCATENATE(C14,\", \",B14)","v":"AZ, Other"},"Other","AZ","AZ, Other",59,{"$f":"E14-5","v":54}]
["CA, Antioch / Brentwood / Concord","Antioch / Brentwood / Concord","CA","Contra Costa",74,69]
["CA, Bakersfield / Ridgecrest","Bakersfield / Ridgecrest","CA","Kern",64,59]
["CA, Barstow / Ontario / Victorville","Barstow / Ontario / Victorville","CA","San Bernardino",64,59]
["CA, Death Valley","Death Valley","CA","Inyo / NAWS China Lake",69,64]
["CA, Eureka / Arcata / McKinleyville","Eureka / Arcata / McKinleyville","CA","Humboldt",69,64]
["CA, Fresno","Fresno","CA","Fresno",69,64]
["CA, Los Angeles","Los Angeles","CA","Los Angeles / Orange / Ventura / Edwards AFB less the city of Santa Monica",74,69]
["CA, Mammoth Lakes","Mammoth Lakes","CA","Mono",79,74]
["CA, Mill Valley / San Rafael / Novato","Mill Valley / San Rafael / Novato","CA","Marin",74,69]
["CA, Monterey","Monterey","CA","Monterey",74,69]
["CA, Napa","Napa","CA","Napa",79,74]
["CA, Oakhurst","Oakhurst","CA","Madera ",69,64]
["CA, Oakland","Oakland","CA","Alameda",74,69]
["CA, Palm Springs","Palm Springs","CA","Riverside",69,64]
["CA, Point Arena / Gualala","Point Arena / Gualala","CA","Mendocino",79,74]
["CA, Sacramento","Sacramento","CA","Sacramento",69,64]
["CA, San Diego","San Diego","CA","San Diego",74,69]
[{"$f":"CONCATENATE(C32,\", \",B32)","v":"CA, San Francisco"},"San Francisco","CA","San Francisco",79,{"$f":"E32-5","v":74}]
[{"$f":"CONCATENATE(C33,\", \",B33)","v":"CA, San Luis Obispo"},"San Luis Obispo","CA","San Luis Obispo",74,{"$f":"E33-5","v":69}]
["CA, San Mateo / Foster City / Belmont","San Mateo / Foster City / Belmont","CA","San Mateo",74,69]
["CA, Santa Barbara","Santa Barbara","CA","Santa Barbara",74,69]
["CA, Santa Cruz","Santa Cruz","CA","Santa Cruz",69,64]
["CA, Santa Monica ","Santa Monica ","CA","City limits of Santa Monica",79,74]
["CA, Santa Rosa","Santa Rosa","CA","Sonoma",74,69]
["CA, South Lake Tahoe","South Lake Tahoe","CA","El Dorado",74,69]
["CA, Stockton ","Stockton ","CA","San Joaquin",74,69]
["CA, Sunnyvale / Palo Alto / San Jose","Sunnyvale / Palo Alto / San Jose","CA","Santa Clara",74,69]
["CA, Tahoe City","Tahoe City","CA","Placer",74,69]
["CA, Truckee","Truckee","CA","Nevada ",79,74]
["CA, Visalia","Visalia","CA","Tulare",69,64]
["CA, West Sacramento / Davis","West Sacramento / Davis","CA","Yolo",69,64]
["CA, Yosemite National Park","Yosemite National Park","CA","Mariposa",79,74]
[{"$f":"CONCATENATE(C47,\", \",B47)","v":"CA, Other"},"Other","CA","CA, Other",59,{"$f":"E47-5","v":54}]
["CO, Aspen","Aspen","CO","Pitkin",79,74]
["CO, Boulder / Broomfield","Boulder / Broomfield","CO","Boulder / Broomfield",69,64]
["CO, Colorado Springs","Colorado Springs","CO","El Paso",69,64]
["CO, Cortez","Cortez","CO","Montezuma",64,59]
["CO, Crested Butte / Gunnison","Crested Butte / Gunnison","CO","Gunnison",74,69]
["CO, Denver / Aurora","Denver / Aurora","CO","Denver / Adams / Arapahoe / Jefferson",79,74]
["CO, Douglas ","Douglas ","CO","Douglas",69,64]
["CO, Durango","Durango","CO","La Plata",74,69]
["CO, Fort Collins / Loveland","Fort Collins / Loveland","CO","Larimer",69,64]
["CO, Grand Lake","Grand Lake","CO","Grand",79,74]
["CO, Montrose","Montrose","CO","Montrose",69,64]
[{"$f":"CONCATENATE(C59,\", \",B59)","v":"CO, Silverthorne / Breckenridge"},"Silverthorne / Breckenridge","CO","Summit",79,36]
["CO, Steamboat Springs","Steamboat Springs","CO","Routt",79,{"$f":"E60-5","v":74}]
["CO, Telluride","Telluride","CO","San Miguel",79,74]
["CO, Vail","Vail","CO","Eagle",79,74]
[{"$f":"CONCATENATE(C63,\", \",B63)","v":"CO, Other"},"Other","CO","CO, Other",59,{"$f":"E63-5","v":54}]
["CT, Bridgeport / Danbury","Bridgeport / Danbury","CT","Fairfield",69,64]
["CT, Cromwell / Old Saybrook","Cromwell / Old Saybrook","CT","Middlesex",64,59]
["CT, Hartford","Hartford","CT","Hartford",69,64]
["CT, New Haven","New Haven","CT","New Haven",69,64]
["CT, New London / Groton","New London / Groton","CT","New London",69,64]
[{"$f":"CONCATENATE(C69,\", \",B69)","v":"CT, Other"},"Other","CT","CT, Other",59,{"$f":"E69-5","v":54}]
["DC, District of Columbia","District of Columbia","DC","Washington DC (also the cities of Alexandria, Falls Church and Fairfax, and the counties of Arlington and Fairfax, in Virginia; and the counties of Montgomery and Prince George's in Maryland)",79,74]
["DE, Lewes","Lewes","DE","Sussex",64,59]
["DE, Wilmington","Wilmington","DE","New Castle",64,59]
[{"$f":"CONCATENATE(C73,\", \",B73)","v":"DE, Other"},"Other","DE","DE, Other",59,{"$f":"E73-5","v":54}]
["FL, Boca Raton / Delray Beach / Jupiter","Boca Raton / Delray Beach / Jupiter","FL","Palm Beach / Hendry",69,64]
["FL, Bradenton","Bradenton","FL","Manatee",64,59]
["FL, Cocoa Beach","Cocoa Beach","FL","Brevard",74,69]
["FL, Daytona Beach","Daytona Beach","FL","Volusia",69,64]
["FL, Fort Lauderdale","Fort Lauderdale","FL","Broward",69,64]
["FL, Fort Myers","Fort Myers","FL","Lee",64,59]
["FL, Fort Walton Beach / De Funiak Springs","Fort Walton Beach / De Funiak Springs","FL","Okaloosa / Walton",69,64]
["FL, Gulf Breeze","Gulf Breeze","FL","Santa Rosa",59,54]
["FL, Key West","Key West","FL","Monroe",69,64]
[{"$f":"CONCATENATE(C83,\", \",B83)","v":"FL, Miami"},"Miami","FL","Miami-Dade",69,{"$f":"E83-5","v":64}]
["FL, Naples","Naples","FL","Collier",69,64]
["FL, Orlando","Orlando","FL","Orange",69,64]
["FL, Panama City","Panama City","FL","Bay",64,59]
["FL, Pensacola ","Pensacola ","FL","Escambia",64,59]
["FL, Punta Gorda","Punta Gorda","FL","Charlotte",64,59]
["FL, Sarasota","Sarasota","FL","Sarasota",69,64]
["FL, Sebring","Sebring","FL","Highlands",64,59]
["FL, St. Augustine","St. Augustine","FL","St. Johns",69,64]
["FL, Stuart","Stuart","FL","Martin",69,64]
["FL, Tallahassee","Tallahassee","FL","Leon",64,59]
["FL, Tampa / St. Petersburg","Tampa / St. Petersburg","FL","Pinellas / Hillsborough",69,64]
["FL, Vero Beach","Vero Beach","FL","Indian River",69,64]
[{"$f":"CONCATENATE(C96,\", \",B96)","v":"FL, Other"},"Other","FL","FL, Other",59,{"$f":"E96-5","v":54}]
["GA, Athens","Athens","GA","Clarke",50,{"$f":"E97","v":50}]
["GA, Atlanta","Atlanta","GA","Fulton / Dekalb",50,{"$f":"E98","v":50}]
["GA, Augusta","Augusta","GA","Richmond",50,50]
[{"$f":"CONCATENATE(C100,\", \",B100)","v":"GA, Other"},"Other","GA","GA, Other",50,50]
["GA, Jekyll Island / Brunswick","Jekyll Island / Brunswick","GA","Glynn",50,50]
[{"$f":"CONCATENATE(C102,\", \",B102)","v":"GA, Marietta"},"Marietta","GA","Cobb",50,50]
["GA, Savannah","Savannah","GA","Chatham",50,50]
["IA, Dallas","Dallas","IA","Dallas",69,{"$f":"E104","v":69}]
["IA, Des Moines","Des Moines","IA","Polk",64,64]
[{"$f":"CONCATENATE(C106,\", \",B106)","v":"IA, Other"},"Other","IA","IA, Other",59,{"$f":"E106-5","v":54}]
["ID, Boise","Boise","ID","Ada",74,69]
["ID, Coeur d'Alene","Coeur d'Alene","ID","Kootenai",64,59]
[{"$f":"CONCATENATE(C109,\", \",B109)","v":"ID, Sun Valley / Ketchum"},"Sun Valley / Ketchum","ID","Blaine / Elmore",74,{"$f":"E109-5","v":69}]
[{"$f":"CONCATENATE(C110,\", \",B110)","v":"ID, Other"},"Other","ID","ID, Other",59,{"$f":"E110-5","v":54}]
["IL, Bolingbrook / Romeoville / Lemont","Bolingbrook / Romeoville / Lemont","IL","Will",64,59]
["IL, Chicago","Chicago","IL","Cook / Lake",79,74]
["IL, East St. Louis / O'Fallon / Fairview Heights","East St. Louis / O'Fallon / Fairview Heights","IL","St. Clair",64,59]
["IL, Oak Brook Terrace","Oak Brook Terrace","IL","DuPage",64,59]
[{"$f":"CONCATENATE(C115,\", \",B115)","v":"IL, Other"},"Other","IL","IL, Other",59,{"$f":"E115-5","v":54}]
["IN, Bloomington ","Bloomington ","IN","Monroe",64,59]
["IN, Ft. Wayne","Ft. Wayne","IN","Allen",64,59]
["IN, Hammond / Munster / Merrillville","Hammond / Munster / Merrillville","IN","Lake",64,59]
["IN, Indianapolis / Carmel","Indianapolis / Carmel","IN","Marion / Hamilton",69,64]
[{"$f":"CONCATENATE(C120,\", \",B120)","v":"IN, Lafayette / West Lafayette"},"Lafayette / West Lafayette","IN","Tippecanoe",64,{"$f":"E120-5","v":59}]
[{"$f":"CONCATENATE(C121,\", \",B121)","v":"IN, Other"},"Other","IN","IN, Other",59,{"$f":"E121-5","v":54}]
["KS, Kansas City / Overland Park","Kansas City / Overland Park","KS","Wyandotte / Johnson / Leavenworth",64,59]
["KS, Wichita","Wichita","KS","Sedgwick",64,59]
[{"$f":"CONCATENATE(C124,\", \",B124)","v":"KS, Other"},"Other","KS","KS, Other",59,{"$f":"E124-5","v":54}]
["KY, Boone","Boone","KY","Boone",64,59]
["KY, Kenton","Kenton","KY","Kenton",74,69]
["KY, Lexington","Lexington","KY","Fayette",64,59]
["KY, Louisville","Louisville","KY","Jefferson",64,59]
[{"$f":"CONCATENATE(C129,\", \",B129)","v":"KY, Other"},"Other","KY","KY, Other",59,{"$f":"E129-5","v":54}]
["LA, Alexandria / Leesville / Natchitoches","Alexandria / Leesville / Natchitoches","LA","Allen / Jefferson Davis / Natchitoches / Rapides / Vernon Parishes",64,59]
["LA, Baton Rouge","Baton Rouge","LA","East Baton Rouge Parish",69,64]
["LA, New Orleans","New Orleans","LA","Orleans / Jefferson Parishes",74,69]
[{"$f":"CONCATENATE(C133,\", \",B133)","v":"LA, Other"},"Other","LA","LA, Other",59,{"$f":"E133-5","v":54}]
["MA, Andover","Andover","MA","Essex",64,59]
["MA, Boston / Cambridge","Boston / Cambridge","MA","Suffolk, city of Cambridge",79,74]
["MA, Burlington / Woburn","Burlington / Woburn","MA","Middlesex less the city of Cambridge",69,64]
["MA, Falmouth","Falmouth","MA","City limits of Falmouth",69,64]
["MA, Hyannis","Hyannis","MA","Barnstable less the city of Falmouth",69,64]
["MA, Martha's Vineyard","Martha's Vineyard","MA","Dukes",79,74]
["MA, Nantucket","Nantucket","MA","Nantucket",79,74]
["MA, Northampton","Northampton","MA","Hampshire",69,64]
["MA, Pittsfield","Pittsfield","MA","Berkshire",64,59]
["MA, Plymouth / Taunton / New Bedford","Plymouth / Taunton / New Bedford","MA","Plymouth / Bristol",69,64]
["MA, Quincy","Quincy","MA","Norfolk",69,64]
["MA, Springfield","Springfield","MA","Hampden",64,59]
["MA, Worcester","Worcester","MA","Worcester",69,64]
[{"$f":"CONCATENATE(C147,\", \",B147)","v":"MA, Other"},"Other","MA","MA, Other",59,{"$f":"E147-5","v":54}]
["MD, Aberdeen / Bel Air / Belcamp","Aberdeen / Bel Air / Belcamp","MD","Harford",64,59]
["MD, Annapolis","Annapolis","MD","Anne Arundel",69,64]
["MD, Baltimore City","Baltimore City","MD","Baltimore City",69,64]
["MD, Baltimore County","Baltimore County","MD","Baltimore",64,59]
["MD, Cambridge / St. Michaels","Cambridge / St. Michaels","MD","Dorchester / Talbot",64,59]
["MD, Centreville","Centreville","MD","Queen Anne",64,59]
["MD, Columbia","Columbia","MD","Howard",69,64]
["MD, Frederick","Frederick","MD","Frederick",64,59]
["MD, Ocean City","Ocean City","MD","Worcester",69,64]
[{"$f":"CONCATENATE(C157,\", \",B157)","v":"MD, Other"},"Other","MD","MD, Other",59,{"$f":"E157-5","v":54}]
["ME, Bar Harbor / Rockport","Bar Harbor / Rockport","ME","Hancock / Knox",74,69]
[{"$f":"CONCATENATE(C159,\", \",B159)","v":"ME, Kennebunk / Kittery / Sanford"},"Kennebunk / Kittery / Sanford","ME","York ",69,{"$f":"E159-5","v":64}]
["ME, Portland","Portland","ME","Cumberland / Sagadahoc",64,59]
[{"$f":"CONCATENATE(C161,\", \",B161)","v":"ME, Other"},"Other","ME","ME, Other",59,{"$f":"E161-5","v":54}]
["MI, Ann Arbor","Ann Arbor","MI","Washtenaw",69,64]
["MI, Detroit","Detroit","MI","Wayne",64,59]
["MI, East Lansing / Lansing","East Lansing / Lansing","MI","Ingham / Eaton",64,59]
["MI, Grand Rapids","Grand Rapids","MI","Kent",64,59]
["MI, Holland","Holland","MI","Ottawa",64,59]
["MI, Kalamazoo / Battle Creek ","Kalamazoo / Battle Creek ","MI","Kalamazoo / Calhoun",64,59]
["MI, Mackinac Island","Mackinac Island","MI","Mackinac",74,69]
["MI, Midland","Midland","MI","Midland",59,54]
["MI, Muskegon","Muskegon","MI","Muskegon",64,59]
["MI, Petoskey","Petoskey","MI","Emmet",64,59]
["MI, Pontiac / Auburn Hills ","Pontiac / Auburn Hills ","MI","Oakland",64,59]
["MI, South Haven","South Haven","MI","Van Buren",64,59]
["MI, Traverse City","Traverse City","MI","Grand Traverse",64,59]
[{"$f":"CONCATENATE(C175,\", \",B175)","v":"MI, Other"},"Other","MI","MI, Other",59,{"$f":"E175-5","v":54}]
["MN, Duluth","Duluth","MN","St. Louis",79,74]
["MN, Eagan / Burnsville / Mendota Heights","Eagan / Burnsville / Mendota Heights","MN","Dakota",69,64]
["MN, Minneapolis / St. Paul","Minneapolis / St. Paul","MN","Hennepin / Ramsey",79,74]
["MN, Rochester","Rochester","MN","Olmsted",64,59]
[{"$f":"CONCATENATE(C180,\", \",B180)","v":"MN, Other"},"Other","MN","MN, Other",59,{"$f":"E180-5","v":54}]
["MO, Kansas City","Kansas City","MO","Jackson / Clay / Cass / Platte",64,59]
["MO, St. Louis","St. Louis","MO","St. Louis / St. Louis City / St. Charles",64,59]
[{"$f":"CONCATENATE(C183,\", \",B183)","v":"MO, Other"},"Other","MO","MO, Other",59,{"$f":"E183-5","v":54}]
["MS, Oxford","Oxford","MS","Lafayette",64,59]
["MS, Southaven","Southaven","MS","Desoto",59,54]
["MS, Starkville ","Starkville ","MS","Oktibbeha",64,59]
[{"$f":"CONCATENATE(C187,\", \",B187)","v":"MS, Other"},"Other","MS","MS, Other",59,{"$f":"E187-5","v":54}]
["MT, Big Sky / West Yellowstone/Gardiner","Big Sky / West Yellowstone/Gardiner","MT","Gallatin/Park",79,74]
["MT, Helena","Helena","MT","Lewis and Clark",64,59]
["MT, Kalispell/Whitefish","Kalispell/Whitefish","MT","Flathead",64,59]
["MT, Missoula","Missoula","MT","Missoula",69,64]
[{"$f":"CONCATENATE(C192,\", \",B192)","v":"MT, Other"},"Other","MT","MT, Other",59,{"$f":"E192-5","v":54}]
["NC, Asheville ","Asheville ","NC","Buncombe",64,59]
["NC, Atlantic Beach / Morehead City","Atlantic Beach / Morehead City","NC","Carteret",64,59]
["NC, Chapel Hill","Chapel Hill","NC","Orange",74,69]
["NC, Charlotte","Charlotte","NC","Mecklenburg",69,64]
["NC, Durham","Durham","NC","Durham",64,59]
["NC, Fayetteville","Fayetteville","NC","Cumberland",64,59]
[{"$f":"CONCATENATE(C199,\", \",B199)","v":"NC, Greensboro"},"Greensboro","NC","Guilford",64,{"$f":"E199-5","v":59}]
["NC, Kill Devil Hills","Kill Devil Hills","NC","Dare",74,69]
["NC, Raleigh","Raleigh","NC","Wake",64,59]
["NC, Wilmington","Wilmington","NC","New Hanover",59,54]
[{"$f":"CONCATENATE(C203,\", \",B203)","v":"NC, Other"},"Other","NC","NC, Other",59,{"$f":"E203-5","v":54}]
[{"$f":"CONCATENATE(C204,\", \",B204)","v":"ND, Other"},"Other","ND","ND, Other",59,{"$f":"E204-5","v":54}]
["NE, Omaha","Omaha","NE","Douglas",64,59]
[{"$f":"CONCATENATE(C206,\", \",B206)","v":"NE, Other"},"Other","NE","NE, Other",59,{"$f":"E206-5","v":54}]
["NH, Concord","Concord","NH","Merrimack",64,59]
["NH, Conway","Conway","NH","Caroll",69,64]
["NH, Durham","Durham","NH","Strafford",59,54]
["NH, Laconia","Laconia","NH","Belknap",64,59]
["NH, Lebanon / Lincoln / West Lebanon","Lebanon / Lincoln / West Lebanon","NH","Grafton",59,54]
["NH, Manchester","Manchester","NH","Hillsborough",64,59]
["NH, Portsmouth","Portsmouth","NH","Rockingham",64,59]
[{"$f":"CONCATENATE(C214,\", \",B214)","v":"NH, Other"},"Other","NH","NH, Other",59,{"$f":"E214-5","v":54}]
["NJ, Cherry Hill / Moorestown","Cherry Hill / Moorestown","NJ","Camden / Burlington",69,64]
["NJ, Eatontown / Freehold","Eatontown / Freehold","NJ","Monmouth",69,64]
["NJ, Edison / Piscataway","Edison / Piscataway","NJ","Middlesex ",69,64]
["NJ, Flemington","Flemington","NJ","Hunterdon",69,64]
["NJ, Newark","Newark","NJ","Essex / Bergen / Hudson / Passaic",69,64]
["NJ, Parsippany","Parsippany","NJ","Morris",69,64]
["NJ, Princeton / Trenton","Princeton / Trenton","NJ","Mercer",69,64]
["NJ, Somerset","Somerset","NJ","Somerset",64,59]
["NJ, Springfield / Cranford / New Providence","Springfield / Cranford / New Providence","NJ","Union",69,64]
["NJ, Toms River","Toms River","NJ","Ocean",69,64]
[{"$f":"CONCATENATE(C225,\", \",B225)","v":"NJ, Other"},"Other","NJ","NJ, Other",59,{"$f":"E225-5","v":54}]
["NM, Albuquerque","Albuquerque","NM","Bernalillo",69,64]
["NM, Carlsbad","Carlsbad","NM","Eddy",64,59]
["NM, Santa Fe","Santa Fe","NM","Santa Fe",69,64]
["NM, Taos","Taos","NM","Taos",64,59]
[{"$f":"CONCATENATE(C230,\", \",B230)","v":"NM, Other"},"Other","NM","NM, Other",59,{"$f":"E230-5","v":54}]
["NV, Incline Village / Reno / Sparks","Incline Village / Reno / Sparks","NV","Washoe",69,64]
["NV, Las Vegas","Las Vegas","NV","Clark",69,64]
[{"$f":"CONCATENATE(C233,\", \",B233)","v":"NV, Other"},"Other","NV","NV, Other",59,{"$f":"E233-5","v":54}]
["NY, Albany","Albany","NY","Albany",69,64]
["NY, Binghamton","Binghamton","NY","Broome",64,59]
["NY, Buffalo","Buffalo","NY","Erie",69,64]
["NY, Floral Park / Garden City / Great Neck","Floral Park / Garden City / Great Neck","NY","Nassau",74,69]
["NY, Glens Falls","Glens Falls","NY","Warren",69,64]
["NY, Ithaca","Ithaca","NY","Tompkins",74,69]
["NY, Kingston","Kingston","NY","Ulster",69,64]
["NY, Lake Placid","Lake Placid","NY","Essex",79,74]
[{"$f":"CONCATENATE(C242,\", \",B242)","v":"NY, New York City"},"New York City","NY","Bronx / Kings / New York / Queens / Richmond",79,{"$f":"E242-5","v":74}]
["NY, Niagara Falls","Niagara Falls","NY","Niagara",69,64]
["NY, Nyack / Palisades","Nyack / Palisades","NY","Rockland",69,64]
["NY, Poughkeepsie","Poughkeepsie","NY","Dutchess",69,64]
["NY, Riverhead / Ronkonkoma / Melville","Riverhead / Ronkonkoma / Melville","NY","Suffolk",69,64]
["NY, Rochester","Rochester","NY","Monroe",69,64]
["NY, Saratoga Springs / Schenectady","Saratoga Springs / Schenectady","NY","Saratoga / Schenectady",64,59]
["NY, Syracuse / Oswego","Syracuse / Oswego","NY","Onondaga / Oswego",64,59]
["NY, Tarrytown / White Plains / New Rochelle","Tarrytown / White Plains / New Rochelle","NY","Westchester",74,69]
["NY, Troy ","Troy ","NY","Rensselaer",64,59]
["NY, West Point","West Point","NY","Orange",64,59]
[{"$f":"CONCATENATE(C253,\", \",B253)","v":"NY, Other"},"Other","NY","NY, Other",59,{"$f":"E253-5","v":54}]
["OH, Akron","Akron","OH","Summit",64,59]
["OH, Canton","Canton","OH","Stark",64,59]
["OH, Cincinnati","Cincinnati","OH","Hamilton / Clermont",74,69]
["OH, Cleveland","Cleveland","OH","Cuyahoga",69,64]
["OH, Columbus","Columbus","OH","Franklin",64,59]
["OH, Dayton / Fairborn","Dayton / Fairborn","OH","Greene / Montgomery",64,59]
["OH, Hamilton","Hamilton","OH","Butler / Warren",59,54]
["OH, Mentor","Mentor","OH","Lake",59,54]
["OH, Sandusky","Sandusky","OH","Erie",64,59]
["OH, Wooster","Wooster","OH","Wayne",59,54]
[{"$f":"CONCATENATE(C264,\", \",B264)","v":"OH, Other"},"Other","OH","OH, Other",59,{"$f":"E264-5","v":54}]
["OK, Oklahoma City","Oklahoma City","OK","Oklahoma",64,59]
[{"$f":"CONCATENATE(C266,\", \",B266)","v":"OK, Other"},"Other","OK","OK, Other",59,{"$f":"E266-5","v":54}]
["OR, Beaverton","Beaverton","OR","Washington",64,59]
["OR, Bend","Bend","OR","Deschutes",64,59]
["OR, Clackamas","Clackamas","OR","Clackamas",64,59]
["OR, Eugene / Florence","Eugene / Florence","OR","Lane",64,59]
["OR, Lincoln City","Lincoln City","OR","Lincoln",69,64]
["OR, Portland","Portland","OR","Multnomah",74,69]
["OR, Seaside","Seaside","OR","Clatsop",69,64]
[{"$f":"CONCATENATE(C274,\", \",B274)","v":"OR, Other"},"Other","OR","OR, Other",59,{"$f":"E274-5","v":54}]
["PA, Allentown / Easton / Bethlehem","Allentown / Easton / Bethlehem","PA","Lehigh / Northampton",64,59]
["PA, Bucks","Bucks","PA","Bucks",64,59]
["PA, Chester / Radnor / Essington","Chester / Radnor / Essington","PA","Delaware",64,59]
["PA, Erie","Erie","PA","Erie",59,54]
["PA, Gettysburg","Gettysburg","PA","Adams",64,59]
[{"$f":"CONCATENATE(C280,\", \",B280)","v":"PA, Harrisburg"},"Harrisburg","PA","Dauphin County excluding Hershey",64,{"$f":"E280-5","v":59}]
["PA, Hershey","Hershey","PA","Hershey",74,69]
["PA, Lancaster","Lancaster","PA","Lancaster",59,54]
["PA, Malvern / Frazer / Berwyn","Malvern / Frazer / Berwyn","PA","Chester",64,59]
["PA, Montgomery","Montgomery","PA","Montgomery",69,64]
["PA, Philadelphia","Philadelphia","PA","Philadelphia",79,74]
["PA, Pittsburgh","Pittsburgh","PA","Allegheny",64,59]
["PA, Reading","Reading","PA","Berks",59,54]
["PA, State College ","State College ","PA","Centre",69,64]
[{"$f":"CONCATENATE(C289,\", \",B289)","v":"PA, Other"},"Other","PA","PA, Other",59,{"$f":"E289-5","v":54}]
["RI, East Greenwich / Warwick","East Greenwich / Warwick","RI","Kent",69,64]
["RI, Jamestown / Middletown / Newport","Jamestown / Middletown / Newport","RI","Newport ",64,59]
["RI, Providence / Bristol","Providence / Bristol","RI","Providence / Bristol",64,59]
[{"$f":"CONCATENATE(C293,\", \",B293)","v":"RI, Other"},"Other","RI","RI, Other",59,{"$f":"E293-5","v":54}]
["SC, Charleston","Charleston","SC","Charleston / Berkeley / Dorchester",79,74]
["SC, Columbia","Columbia","SC","Richland / Lexington",64,59]
["SC, Hilton Head","Hilton Head","SC","Beaufort",69,64]
["SC, Myrtle Beach","Myrtle Beach","SC","Horry",69,64]
[{"$f":"CONCATENATE(C298,\", \",B298)","v":"SC, Other"},"Other","SC","SC, Other",59,{"$f":"E298-5","v":54}]
["SD, Deadwood / Spearfish ","Deadwood / Spearfish ","SD","Lawrence",74,69]
["SD, Hot Springs","Hot Springs","SD","Fall River / Custer",64,59]
["SD, Rapid City","Rapid City","SD","Pennington",64,59]
[{"$f":"CONCATENATE(C302,\", \",B302)","v":"SD, Other"},"Other","SD","SD, Other",59,{"$f":"E302-5","v":54}]
["TN, Brentwood / Franklin","Brentwood / Franklin","TN","Williamson",69,64]
["TN, Chattanooga ","Chattanooga ","TN","Hamilton",64,59]
["TN, Knoxville","Knoxville","TN","Knox",64,59]
["TN, Memphis","Memphis","TN","Shelby",69,64]
["TN, Nashville","Nashville","TN","Davidson",79,74]
[{"$f":"CONCATENATE(C308,\", \",B308)","v":"TN, Other"},"Other","TN","TN, Other",59,{"$f":"E308-5","v":54}]
["TX, Arlington / Fort Worth / Grapevine","Arlington / Fort Worth / Grapevine","TX","Tarrant County / City of Grapevine",64,59]
["TX, Austin","Austin","TX","Travis",64,59]
["TX, Big Spring","Big Spring","TX","Howard",64,59]
[{"$f":"CONCATENATE(C312,\", \",B312)","v":"TX, Corpus Christi"},"Corpus Christi","TX","Nueces",64,{"$f":"E312-5","v":59}]
["TX, Dallas","Dallas","TX","Dallas ",69,64]
["TX, El Paso","El Paso","TX","El Paso",64,59]
["TX, Galveston","Galveston","TX","Galveston",64,59]
["TX, Houston","Houston","TX","Montgomery / Fort Bend / Harris",69,64]
["TX, Midland / Odessa","Midland / Odessa","TX","Midland / Andrews / Ector / Martin",64,59]
["TX, Pecos","Pecos","TX","Reeves",59,54]
["TX, Plano","Plano","TX","Collin",64,59]
["TX, Round Rock ","Round Rock ","TX","Williamson",64,59]
["TX, San Antonio","San Antonio","TX","Bexar",64,59]
["TX, South Padre Island","South Padre Island","TX","Cameron",59,54]
["TX, Waco","Waco","TX","McLennan",64,59]
[{"$f":"CONCATENATE(C324,\", \",B324)","v":"TX, Other"},"Other","TX","TX, Other",59,{"$f":"E324-5","v":54}]
["UT, Moab","Moab","UT","Grand",69,64]
["UT, Park City","Park City","UT","Summit",79,74]
["UT, Provo","Provo","UT","Utah",64,59]
["UT, Salt Lake City","Salt Lake City","UT","Salt Lake / Tooele",64,59]
[{"$f":"CONCATENATE(C329,\", \",B329)","v":"UT, Other"},"Other","UT","UT, Other",59,{"$f":"E329-5","v":54}]
["VA, Blacksburg","Blacksburg","VA","Montgomery",59,54]
["VA, Charlottesville","Charlottesville","VA","City of Charlottesville / Albemarle",69,64]
["VA, Loudoun","Loudoun","VA","Loudoun",69,64]
["VA, Lynchburg","Lynchburg","VA","Campbell / Lynchburg City",64,59]
["VA, Richmond","Richmond","VA","City of Richmond",64,59]
["VA, Roanoke","Roanoke","VA","City limits of Roanoke",59,54]
[{"$f":"CONCATENATE(C336,\", \",B336)","v":"VA, Virginia Beach"},"Virginia Beach","VA","City of Virginia Beach",64,{"$f":"E336-5","v":59}]
["VA, Wallops Island","Wallops Island","VA","Accomack",64,59]
["VA, Williamsburg / York","Williamsburg / York","VA","James City / York Counties / City of Williamsburg",64,59]
[{"$f":"CONCATENATE(C339,\", \",B339)","v":"VA, Other"},"Other","VA","VA, Other",59,{"$f":"E339-5","v":54}]
["VT, Burlington","Burlington","VT","Chittenden",69,64]
["VT, Manchester","Manchester","VT","Bennington",79,74]
["VT, Montpelier","Montpelier","VT","Washington",69,64]
["VT, Stowe ","Stowe ","VT","Lamoille",79,74]
[{"$f":"CONCATENATE(C344,\", \",B344)","v":"VT, White River Junction"},"White River Junction","VT","Windsor",64,{"$f":"E344-5","v":59}]
[{"$f":"CONCATENATE(C345,\", \",B345)","v":"VT, Other"},"Other","VT","VT, Other",59,{"$f":"E345-5","v":54}]
["WA, Everett / Lynnwood","Everett / Lynnwood","WA","Snohomish",74,69]
["WA, Ocean Shores","Ocean Shores","WA","Grays Harbor",74,69]
["WA, Olympia / Tumwater","Olympia / Tumwater","WA","Thurston",74,69]
["WA, Port Angeles / Port Townsend","Port Angeles / Port Townsend","WA","Clallam / Jefferson",74,69]
["WA, Richland / Pasco","Richland / Pasco","WA","Benton / Franklin",69,64]
["WA, Seattle","Seattle","WA","King",79,74]
["WA, Spokane","Spokane","WA","Spokane",74,69]
["WA, Tacoma","Tacoma","WA","Pierce",69,64]
["WA, Vancouver","Vancouver","WA","Clark / Cowlitz / Skamania",74,69]
[{"$f":"CONCATENATE(C355,\", \",B355)","v":"WA, Other"},"Other","WA","WA, Other",59,{"$f":"E355-5","v":54}]
["WI, Appleton","Appleton","WI","Outagamie",59,54]
["WI, Brookfield / Racine","Brookfield / Racine","WI","Waukesha / Racine",64,59]
["WI, Madison","Madison","WI","Dane",64,59]
["WI, Milwaukee","Milwaukee","WI","Milwaukee",64,59]
["WI, Sturgeon Bay","Sturgeon Bay","WI","Door",74,69]
["WI, Wisconsin Dells","Wisconsin Dells","WI","Columbia",59,54]
[{"$f":"CONCATENATE(C362,\", \",B362)","v":"WI, Other"},"Other","WI","WI, Other",59,{"$f":"E362-5","v":54}]
["WV, Charleston","Charleston","WV","Kanawha",64,59]
["WV, Morgantown","Morgantown","WV","Monongalia",59,54]
[{"$f":"CONCATENATE(C365,\", \",B365)","v":"WV, Other"},"Other","WV","WV, Other",59,{"$f":"E365-5","v":54}]
["WY, Cody","Cody","WY","Park",69,64]
["WY, Jackson / Pinedale","Jackson / Pinedale","WY","Teton / Sublette",79,74]
["WY, Rock Springs","Rock Springs","WY","Sweetwater",69,64]
[{"$f":"CONCATENATE(C369,\", \",B369)","v":"WY, Other"},"Other","WY","WY, Other",59,{"$f":"E369-5","v":54}]
["Please Select"]