{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Help","Revision Log","Traveler Information","Travel Request","TA with Exp Report","Continuation","Continuation (2)","Continuation (3)","Continuation (4)","Continuation (5)","Instructions for TR","Instructions for TA","trRanges","Ranges"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":396,"comments":8,"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":"Help","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,1,24,2],[1,1,1,2],[3,1,3,2],[5,1,5,2],[7,1,7,2],[9,1,9,2],[10,1,10,2],[12,1,12,2],[16,1,16,2],[20,1,20,2]]}
[]
[null,"INSTRUCTIONS FOR USE OF THIS WORKBOOK"]
[]
[null,"The functionality provided by this workbook relies on Excel macros. \nHere are some tips for making efficient use of this workbook."]
[]
[null,"1) DO NOT attempt to use this workbook within your internet browser (such as Internet Explorer). To use this workbook, you must open it in Microsoft Excel. This workbook must be saved as an Excel Macro-Enabled Workbook (*.xlsm) in order for the macros to function correctly after saving. "]
[]
[null,"2) Macros must be enabled to use this workbook. For assistance, please refer to the Microsoft Office Online Support links provided below. Steps are specific to your version of Excel. If you are unable to complete these steps, you will need to contact your department IT staff for assistance."]
[]
[null,"Click here for instructions on how to check which version of Excel you are using."]
[null,"Click here to instructions on how to enable macros in Office files."]
[]
[null,"3) You must save this workbook as a Excel Macro-Enabled Workbook (*.xlsm) in order for the workbook to continue functioning as designed next time you open it."]
[]
[null,"Steps to complete this workbook"]
[]
[null,"1) Traveler Information tab"]
[]
[null,null,"Select the department on the top left and begin entering traveler data.  The information entered on this tab will map to the blue fields on the TR and TA for the selected traveler.  Not all fields are required, just enter the data you would normally enter.  If SSoA is booking the travel they may require more information for non-profiled travelers.  "]
[]
[null,"2) Travel Request tab"]
[]
[null,null,"Complete the itinerary and financial coding, which will map to the TA.  Only the fields in orange will accept data entry on this tab. You cannot enter/edit data in the blue fields on this tab. To enter/edit blue data, go to the applicable tab."]
[]
[null,"3) TA with Exp Report tab"]
[]
[null,null,"Complete the approval and expense information as normal.  Only the fields in yellow will accept data entry on this tab.  You cannot enter/edit data in the orange or blue fields on this tab.  To enter/edit orange or blue data, go to the applicable tab."]

{"sheet":"Revision Log","index":1,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"REVISION LOG"]
[]
[null,"DATE","DESCRIPTION OF REVISION"]
[null,"2025-02-20","Add new ZVSA Division for 12-DPS. Corrected the formula so that the Traveler's Mailing Address from the Traveler Information tab will populate to the TA with Exp Report tab."]
[null,"2024-12-31","Updated personal vehicle mileage rate for travel on or after January 1, 2025. Added field for IRIS TRQS number to Travel Request and TA with Exp Report tabs."]
[null,"2024-01-04","Updated personal vehicle mileage rate for travel on or after January 1, 2024."]
[null,"2023-08-28","Updated Accounting Template field length validation to allow for up to twelve characters."]
[null,"2023-04-27","Updated Accounting Template field length validation to allow for up to eight characters."]
[null,"2023-01-06","Updated personal vehicle mileage rate for travel on or after January 1, 2023."]
[null,"2022-12-07","Add new ZINV Division for 08-CED. Correct field labels on TA with Exp Report tab for travel associated with DPS Prisoner Transport."]
[null,"2022-07-01","Updated personal vehicle mileage rate for travel on or after July 1, 2022."]
[null,"2022-06-30","Updated Agency and Division selection fields for new Department of Health and Department of Family and Community Services departments."]
[null,"2022-01-11","Updated personal vehicle mileage rate for travel on or after January 1, 2022. Added fields for Printed Name and Signature for Travel Approvals to the TA with Exp Report tab."]
[null,"2021-01-01","Updated personal vehicle mileage rate for travel on or after January 1, 2021."]
[null,"2020-01-06","Updated personal vehicle mileage rate for travel on or after January 1, 2020.\nTraveler Information tab.\n  - Add optional note to PERSONAL PHYSICAL ADDRESS column."]
[null,"2019-09-30","Traveler Information tab.\n  - Updated logic so any character can be entered in the SELECT TRAVELER column to activate Traveler.\n  - Updated list of divisions available for selection based on department selection.\n  - Added column for Traveler's Mailing Address if different than the physical address."]
[null,"2019-07-15","Updated list of divisions available for selection based on department selection on Traveler Information tab."]
[null,"2019-05-29","Removed two Executive Travel Options per decision by SSoA and SFOA from the Travel Request."]
[null,"2019-03-19","Configured data validation for values entered in FINANCIAL CODING section of the Travel Request to ensure that the correct number of characters are entered for each value. "]
[null,"2018-12-12","Updated personal vehicle mileage rate for travel on or after January 1, 2019."]
[null,"2018-09-17","Corrected error that came up when adding more than four financial coding split options on the Travel Request, changed the label AWD/4WD to SPECIAL REQUEST on the Travel Request in the Rental Car Reservation section."]
[null,"2018-06-29","Corrected printing issue for TA Continuation pages. Added Note to Car Rental Request section on Travel Request tab. Added additional financial coding split options to Travel Request, users may now define up to ten coding splits. Changed formula for SURFACE TRANSPORTATION total on TA with Exp Report to round to two-digits."]
[null,"2018-04-05","Added Minimum Business Itinerary (MBI) Details to email request for approval. Added section to capture Executive Travel Purpose on TA with Exp Report if selected on Travel Request tab. Other updates to the TA with Expense Report and Continuation tabs include: added new TYPE codes to Traveler's Reimbursement Warrant and State PCard Charges section; new TYPE(s) include CADV=ATM Cash Advance, TADV=Travel Advance, M&IE-TAX=M&IE Taxable, and LODG-TAX=Lodging Taxable; and added a Grand Total of the Traveler's Reimbursement Warrant section which should match the TOTAL DUE TO/FROM TRAVELER total from above. "]
[null,"2018-02-21","Updates to Traveler Information tab include: removed filter buttons, shortened picklist values for Division to three-character abbreviation, added Section column that is free-form, standardized Bargaining Unit picklist, removed Gender and DOB columns, and added comment to Traveler Profile columns to indicate that information is only needed if booking travel through SSoA."]
[null,"2018-02-06","Repaired macro that displayed/hid sections of the TA with Exp Report tab based on selections at the top of the tab."]
[null,"2018-02-02","Fixed link for Traveler's Duty Station on TA with Exp Report tab. Made DOB and Gender optional fields on Travel Request tab, this information is only needed when booking travel for travelers who do not have a profile."]
[null,"02/01/2018b","Fixed link for Traveler's Vendor Customer Number (VCN). Added conditional formatting and data validation to Traveler Information tab."]
[null,"02/01/2018a","Changed Agency selection to one field on Traveler Information tab so users don't have to select for each row. Fixed buttons on Travel Request tab. Added drop-down options to DPS Prisoner Transport section of TA with Exp Report tab."]
[null,"2018-02-01","Corrected Data Validation issue on Traveler Information tab where Division drop-down was not populating correctly."]
[null,"2018-01-31","Added Traveler Information tab on which traveler information is populated. Data entered on this new tab populates fields on the Travel Request and TA with Exp Report tabs. Added color coding to Travel Request and TA with Exp Report tabs to indicate where fields are populated from; field labels that are light blue are tied to the Traveler Information tab and light orange are tied to the Travel Request tab."]
[null,"2018-01-30","Added or modified many fields on the Travel Request to accommodate travel bookings arranged by SSoA. These fields include CTS Account, Executive Travel Reporting, Financial Coding, Personal Travel, and a section for AMHS travel."]
[null,"2018-01-10","Added mileage rate for travel on or after January 1, 2018."]
[null,"2017-07-26","Added numerous fields to Travel Request and TA with Exp Report to accommodate travel bookings arranged by SSoA. Rearranged some fields on Travel Request Itinerary portion of form. Converted many Cell Comments to Input Messages. "]
[null,"2017-03-31","Added TAPO Field to Travel Request and TA with Exp Report. Inserted additional continuation pages."]
[null,"2016-12-31","Added mileage rate for travel on or after January 1, 2017."]
[null,"2016-05-16","Removed Reapproval Signature from TA form per AAM Transmittal 89 effective 5/16/2016."]
[null,"2016-01-18","Updated logic for mileage rate to select rate based on travel date entered for the line. Mileage rate is now unlocked to allow for entry of other POV mileage rates than the most commonly used automobile rate if necessary."]
[null,"2015-12-31","Added mileage rate for travel on or after January 1, 2016."]
[null,"2015-08-27","Added Continuation (3) page per agency request; removed protection from some locked fields on TR and TA."]
[null,"2015-08-11","Removed radio buttons and checkboxes, converted form controls to list drop-down boxes; simplified macros for TR and TA; added descriptive text to Financial Coding fields."]
[null,"2015-07-01","Converted form to .XLTM format, added IRIS references, removed AKSAS references."]
[null,"2015-06-20","Added Spell Check Button to Travel Request, TA with Exp Report, and Continuation tabs."]
[null,"2015-01-28","Modified Mileage calculation to use a ROUND formula."]
[null,"2015-01-01","Added mileage rate for travel on or after January 1, 2015."]
[null,"2014-07-24","Modified cell protection so that formulas are visible in locked cells."]
[null,"2014-06-25","Increased  \"Total Not to Exceed\" amount on Travel Authorization form to $25,000."]
[null,"2014-01-01","Added mileage rate for travel on or after January 1, 2014."]

{"sheet":"Traveler Information","index":2,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,12,2,13]]}
["TRAVELER INFORMATION"]
[null,"Select Agency",null,{"$f":"IF(trDept<>\"\",VLOOKUP(trDept,dept_lookup,3,FALSE),\"\")","v":""}]
[]
[{"$f":"COUNTA(AllTravelers[SELECT TRAVELER])","v":0},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],B5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],B5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],C5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],C5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],D5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],D5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],E5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],E5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],F5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],F5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],G5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],G5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],H5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],H5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],I5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],I5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],J5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],J5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],K5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],K5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],L5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],L5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],M5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],M5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],N5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],N5,FALSE),\"\")),\" \")","v":" "},{"$f":"IFERROR((IF(VLOOKUP(\"*\",AllTravelers[],O5,FALSE)<>\"\",VLOOKUP(\"*\",AllTravelers[],O5,FALSE),\"\")),\" \")","v":" "}]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["SELECT TRAVELER","DIVISION (3-CHAR)","SECTION","EMPL NUM","TRAVELER'S LEGAL NAME","JOB TITLE","BARGAINING UNIT","DUTY STATION","VCUST NUMBER","PHONE NO.","PERSONAL PHYSICAL ADDRESS\n(Street No., City, State Zip)\noptional","PERSONAL MAILING ADDRESS\n(If different from Physical Address)","DOES TRAVELER HAVE E-TRAVEL PROFILE?","IF NO, PROVIDE GENERIC PROFILE TO BE USED"]

{"sheet":"Travel Request","index":3,"n_rows":160,"n_cols":44,"rows_kept":160,"cut":false,"hidden":false,"merged":[[67,1,67,3],[67,4,67,5],[67,6,67,10],[67,11,67,12],[67,13,67,17],[67,18,67,19],[67,20,67,23],[67,24,67,25],[67,26,67,30],[66,1,66,3],[66,4,66,5],[66,6,66,10],[66,11,66,12],[66,13,66,17],[66,18,66,19],[66,20,66,23],[66,24,66,25],[66,26,66,30],[64,1,65,3],[64,4,64,30],[65,4,65,5],[65,6,65,10],[65,11,65,12],[65,13,65,17],[65,18,65,19],[65,20,65,23],[65,24,65,25],[65,26,65,30],[63,1,63,3],[63,4,63,5],[63,6,63,10],[63,11,63,12],[63,13,63,17],[63,18,63,19],[63,20,63,23],[63,24,63,25],[63,26,63,30],[62,1,62,3],[62,4,62,5],[62,6,62,10],[62,11,62,12],[62,13,62,17],[62,18,62,19],[62,20,62,23],[62,24,62,25],[62,26,62,30],[60,1,61,3],[60,4,60,30],[61,4,61,5],[61,6,61,10],[61,11,61,12],[61,13,61,17],[61,18,61,19],[61,20,61,23],[61,24,61,25],[61,26,61,30],[59,1,59,3],[59,4,59,5],[59,6,59,10],[59,11,59,12],[59,13,59,17],[59,18,59,19],[59,20,59,23],[59,24,59,25],[59,26,59,30],[58,1,58,3],[58,4,58,5],[58,6,58,10],[58,11,58,12],[58,13,58,17],[58,18,58,19],[58,20,58,23],[58,24,58,25],[58,26,58,30],[56,1,57,3],[56,4,56,30],[57,4,57,5],[57,6,57,10],[57,11,57,12],[57,13,57,17],[57,18,57,19],[57,20,57,23],[57,24,57,25],[57,26,57,30],[55,1,55,3],[55,4,55,5],[55,6,55,10],[55,11,55,12],[55,13,55,17],[55,18,55,19],[55,20,55,23],[55,24,55,25],[55,26,55,30],[54,1,54,3],[54,4,54,5],[54,6,54,10],[54,11,54,12],[54,13,54,17],[54,18,54,19],[54,20,54,23],[54,24,54,25],[54,26,54,30],[52,1,53,3],[52,4,52,30],[53,4,53,5],[53,6,53,10],[53,11,53,12],[53,13,53,17],[53,18,53,19],[53,20,53,23],[53,24,53,25],[53,26,53,30],[51,1,51,3],[51,4,51,5],[51,6,51,10],[51,11,51,12],[51,13,51,17],[51,18,51,19],[51,20,51,23],[51,24,51,25],[51,26,51,30],[50,1,50,3],[50,4,50,5],[50,6,50,10],[50,11,50,12],[50,13,50,17],[50,18,50,19],[50,20,50,23],[50,24,50,25],[50,26,50,30],[47,6,47,10],[47,11,47,12],[47,13,47,17],[47,18,47,19],[47,20,47,23],[47,24,47,25],[47,26,47,30],[48,1,49,3],[48,4,48,30],[49,4,49,5],[49,6,49,10],[49,11,49,12],[49,13,49,17],[49,18,49,19],[49,20,49,23],[49,24,49,25],[49,26,49,30],[114,1,115,30],[116,1,116,30],[44,1,45,3],[44,4,44,30],[45,4,45,5],[45,6,45,10],[45,11,45,12],[45,13,45,17],[45,18,45,19],[45,20,45,23],[45,24,45,25],[45,26,45,30],[46,1,46,3],[46,4,46,5],[46,6,46,10],[46,11,46,12],[46,13,46,17],[46,18,46,19],[46,20,46,23],[46,24,46,25],[46,26,46,30],[47,1,47,3],[47,4,47,5],[110,1,110,8],[141,21,141,26],[141,27,141,30],[142,9,142,14],[142,15,142,20],[142,21,142,26],[142,27,142,30],[43,4,43,5],[43,6,43,10],[122,10,122,13],[122,14,122,17],[122,18,122,26],[122,27,122,30],[106,1,106,8],[106,9,106,16],[117,10,117,13],[106,17,106,19],[106,20,106,22],[106,23,106,30],[109,1,109,8],[109,9,109,16],[109,17,109,19],[109,20,109,22],[140,1,140,2],[141,1,141,5],[142,1,142,5],[141,6,141,8],[142,6,142,8],[141,9,141,14],[33,24,33,25],[33,26,33,30],[73,4,73,9],[73,13,73,18],[73,10,73,12],[73,1,73,3],[73,19,73,26],[73,27,73,30],[74,1,74,3],[74,4,74,30],[39,13,39,17],[39,18,39,19],[39,20,39,23],[39,24,39,25],[39,26,39,30],[39,4,39,5],[39,6,39,10],[141,15,141,20],[39,11,39,12],[42,11,42,12],[42,13,42,17],[42,18,42,19],[42,20,42,23],[42,24,42,25],[42,26,42,30],[38,11,38,12],[38,13,38,17],[38,18,38,19],[38,20,38,23],[38,24,38,25],[38,26,38,30],[35,4,35,5],[35,6,35,10],[35,11,35,12],[37,6,37,10],[37,11,37,12],[37,13,37,17],[37,18,37,19],[37,20,37,23],[37,24,37,25],[35,13,35,17],[35,18,35,19],[35,20,35,23],[35,24,35,25],[35,26,35,30],[85,13,85,14],[31,4,31,5],[31,6,31,10],[31,11,31,12],[31,13,31,17],[31,18,31,19],[31,20,31,23],[31,24,31,25],[31,26,31,30],[40,4,40,30],[41,4,41,5],[41,6,41,10],[41,11,41,12],[41,13,41,17],[41,18,41,19],[41,20,41,23],[41,24,41,25],[41,26,41,30],[42,4,42,5],[42,6,42,10],[37,26,37,30],[43,13,43,17],[43,18,43,19],[110,9,110,16],[111,9,111,16],[111,17,111,19],[111,20,111,22],[111,23,111,30],[107,1,107,8],[107,9,107,16],[107,17,107,19],[109,23,109,30],[89,27,89,30],[90,1,90,8],[107,20,107,22],[107,23,107,30],[119,1,119,9],[119,10,119,13],[119,14,119,17],[119,18,119,26],[119,27,119,30],[118,18,118,26],[118,27,118,30],[112,23,112,30],[118,1,118,9],[118,10,118,13],[118,14,118,17],[117,18,117,26],[110,17,110,19],[110,20,110,22],[110,23,110,30],[111,1,111,8],[93,27,93,30],[95,1,95,8],[95,9,95,11],[95,12,95,15],[87,24,87,26],[87,27,87,30],[112,1,112,8],[112,9,112,16],[82,1,83,30],[84,1,84,15],[84,16,84,30],[86,1,86,8],[86,9,86,11],[86,12,86,15],[86,16,86,23],[86,24,86,26],[86,27,86,30],[94,12,94,15],[94,16,94,23],[94,24,94,26],[94,27,94,30],[96,24,96,26],[96,16,96,23],[88,27,88,30],[93,1,93,8],[93,9,93,11],[93,12,93,15],[93,16,93,23],[4,15,4,30],[4,1,4,14],[2,1,3,6],[2,8,3,17],[2,23,2,26],[3,23,3,26],[2,27,2,30],[3,27,3,30],[2,18,2,22],[3,18,3,22],[80,1,80,3],[80,4,80,30],[79,1,79,3],[16,27,16,30],[6,14,6,16],[7,14,7,16],[14,1,14,30],[15,1,15,11],[15,12,15,15],[15,16,15,26],[15,27,15,30],[16,1,16,11],[16,12,16,15],[16,16,16,26],[6,1,6,13],[7,1,7,13],[8,1,8,3],[43,11,43,12],[9,1,9,2],[6,17,6,20],[7,17,7,20],[6,21,6,30],[7,21,7,30],[8,4,8,5],[43,20,43,23],[43,24,43,25],[43,26,43,30],[138,1,138,9],[134,14,134,26],[134,27,134,30],[131,10,131,13],[70,17,70,30],[68,1,68,30],[69,5,69,6],[75,1,75,30],[69,1,69,4],[69,7,69,30],[71,1,71,30],[70,2,70,15],[78,16,78,25],[78,26,78,30],[77,1,77,15],[77,16,77,25],[77,26,77,30],[78,1,78,15],[79,4,79,30],[87,1,87,8],[87,9,87,11],[87,12,87,15],[87,16,87,23],[113,1,113,2],[126,18,126,26],[139,14,139,26],[137,1,137,9],[137,10,137,13],[136,27,136,30],[139,1,139,9],[139,10,139,13],[139,27,139,30],[129,1,129,9],[129,10,129,13],[129,27,129,30],[138,10,138,13],[138,27,138,30],[135,1,135,9],[135,10,135,13],[135,27,135,30],[135,14,135,26],[136,14,136,26],[137,14,137,26],[138,14,138,26],[134,1,134,9],[134,10,134,13],[137,27,137,30],[76,1,76,2],[81,1,81,2],[85,1,85,2],[129,14,129,26],[130,14,130,26],[117,14,117,17],[96,12,96,15],[105,17,105,19],[90,27,90,30],[91,1,91,8],[91,9,91,11],[91,12,91,15],[91,16,91,23],[91,24,91,26],[97,1,97,2],[96,27,96,30],[103,1,103,8],[103,9,103,16],[93,24,93,26],[90,24,90,26],[95,24,95,26],[94,1,94,8],[147,1,147,30],[148,1,148,30],[98,1,101,30],[102,1,102,8],[102,9,102,16],[102,17,102,19],[102,20,102,22],[102,23,102,30],[112,17,112,19],[112,20,112,22],[117,27,117,30],[127,1,127,9],[127,10,127,13],[127,14,127,17],[117,1,117,9],[136,1,136,9],[136,10,136,13],[127,27,127,30],[108,1,108,8],[108,9,108,16],[108,17,108,19],[108,20,108,22],[108,23,108,30],[105,9,105,16],[29,6,29,10],[29,13,29,17],[18,1,18,30],[20,14,20,18],[19,14,19,18],[19,10,19,13],[20,10,20,13],[30,20,30,23],[30,4,30,5],[30,26,30,30],[30,6,30,10],[30,11,30,12],[30,18,30,19],[24,3,24,30],[20,1,20,9],[28,25,28,29],[28,1,29,3],[88,16,88,23],[88,24,88,26],[89,1,89,8],[89,9,89,11],[89,12,89,15],[89,16,89,23],[89,24,89,26],[95,16,95,23],[88,1,88,8],[88,9,88,11],[88,12,88,15],[90,9,90,11],[90,12,90,15],[90,16,90,23],[91,27,91,30],[92,1,92,8],[92,9,92,11],[92,12,92,15],[92,16,92,23],[92,24,92,26],[92,27,92,30],[105,20,105,22],[105,23,105,30],[103,17,103,19],[103,20,103,22],[103,23,103,30],[104,1,104,8],[104,9,104,16],[104,17,104,19],[104,20,104,22],[104,23,104,30],[105,1,105,8],[95,27,95,30],[96,1,96,8],[96,9,96,11],[94,9,94,11],[131,14,131,26],[131,27,131,30],[130,27,130,30],[128,1,128,2],[126,27,126,30],[123,1,123,9],[123,10,123,13],[123,14,123,17],[123,18,123,26],[123,27,123,30],[125,1,125,9],[125,10,125,13],[125,14,125,17],[125,18,125,26],[125,27,125,30],[124,1,124,9],[124,10,124,13],[124,14,124,17],[124,18,124,26],[127,18,127,26],[130,1,130,9],[130,10,130,13],[132,1,132,9],[132,10,132,13],[132,14,132,26],[132,27,132,30],[133,1,133,9],[133,10,133,13],[133,14,133,26],[133,27,133,30],[120,1,120,9],[120,10,120,13],[120,14,120,17],[120,18,120,26],[120,27,120,30],[121,1,121,9],[121,10,121,13],[121,14,121,17],[121,18,121,26],[121,27,121,30],[124,27,124,30],[126,1,126,9],[126,10,126,13],[126,14,126,17],[131,1,131,9],[122,1,122,9],[34,24,34,25],[32,1,33,3],[35,1,35,3],[39,1,39,3],[43,1,43,3],[20,19,20,20],[11,1,11,2],[11,3,11,30],[36,4,36,30],[37,4,37,5],[25,9,25,13],[26,9,26,13],[25,14,25,30],[26,14,26,30],[29,11,29,12],[29,18,29,19],[29,24,29,25],[29,26,29,30],[30,13,30,17],[29,20,29,23],[38,4,38,5],[38,6,38,10],[29,4,29,5],[34,26,34,30],[8,7,8,20],[9,7,9,20],[9,21,9,30],[12,18,12,30],[12,1,12,17],[27,1,27,30],[24,1,24,2],[25,1,25,6],[26,1,26,6],[25,7,25,8],[26,7,26,8],[36,1,37,3],[40,1,41,3],[30,1,30,3],[34,1,34,3],[38,1,38,3],[42,1,42,3],[13,18,13,30],[13,1,13,17],[9,4,9,6],[32,4,32,30],[33,4,33,5],[33,6,33,10],[33,11,33,12],[33,13,33,17],[33,18,33,19],[33,20,33,23],[30,24,30,25],[31,1,31,3],[34,4,34,5],[34,6,34,10],[34,11,34,12],[34,13,34,17],[34,18,34,19],[34,20,34,23],[143,1,143,5],[143,6,143,8],[143,9,143,14],[143,15,143,20],[143,21,143,26],[143,27,143,30],[144,1,144,5],[144,6,144,8],[144,9,144,14],[144,15,144,20],[144,21,144,26],[144,27,144,30],[145,1,145,5],[145,6,145,8],[145,9,145,14],[145,15,145,20],[145,21,145,26],[145,27,145,30],[146,1,146,5],[146,6,146,8],[146,9,146,14],[146,15,146,20],[146,21,146,26],[146,27,146,30]]}
[]
[]
[null,"State of Alaska",null,null,null,null,null,null,"Request for Travel\nAuthorization and Booking",null,null,null,null,null,null,null,null,null,"TRAVEL AUTH NO.",null,null,null,null,"TRQS NO.",null,null,null,"TAPO NO."]
[]
[null,"Send New Booking Requests to: doa.ssoa.newbooking@alaska.gov",null,null,null,null,null,null,null,null,null,null,null,null,null,"Send Requests TAPO Only requests to: doa.ssoa.selfbooking@alaska.gov"]
[null,"TRAVELER INFORMATION"]
[null,"TRAVELER'S LEGAL NAME (AS SHOWN ON GOV'T ID)",null,null,null,null,null,null,null,null,null,null,null,null,"EMPL NUM",null,null,"PHONE NO.",null,null,null,"JOB TITLE"]
[null,{"$f":"trLegalName","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"trEmplNum","v":" "},null,null,{"$f":"trPhone","v":" "},null,null,null,{"$f":"trTitle","v":" "}]
[null,"AGENCY",null,null,"DIVISION",null,null,"SECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,"DUTY STATION"]
[null,{"$f":"IF(trDept=\"\",\"\",trDept)","v":""},null,{"$f":"IF(trDept<>\"\",VLOOKUP(trDept,dept_lookup,3,FALSE),\"\")","v":""},{"$f":"trDivision","v":" "},null,null,{"$f":"trSection","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"trDutyStation","v":" "}]
[null,"DOES TRAVELER HAVE AN E-TRAVEL PROFILE? IF NO, PLEASE PROVIDE GENERIC TRAVEL PROFILE TO BE USED FOR BOOKING."]
[null,{"$f":"trProfile","v":" "},null,{"$f":"trGenProf","v":" "}]
[null,"PERSONAL PHYSICAL ADDRESS (Street No., City, State Zip)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARGAINING UNIT"]
[null,{"$f":"trAddress","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"trBU","v":" "}]
[null,"ITINERARY"]
[null,"FROM",null,null,null,null,null,null,null,null,null,null,"DEPARTURE DATE",null,null,null,"TO (DESTINATION)",null,null,null,null,null,null,null,null,null,null,"RETURN DATE"]
[]
[null,"PURPOSE OF TRIP"]
[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,{"$f":"IF(trPurpose=\"\",\"\",trPurpose)","v":""}]
[null,"ESTIMATED COST",null,null,null,null,null,null,null,null,"CARD ACCT TYPE",null,null,null,"LAST FOUR DIGITS",null,null,null,null,"EXECUTIVE TRAVEL?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null," If [YES] select TYPE(s) OF TRAVEL below."]
[null,"SELECT TYPE(S) OF EXECUTIVE TRAVEL FOR THIS TRAVEL REQUEST"]
[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,false,false,false,false,false,false,null,null,{"$f":"OR(AJ23:AO23)","v":false}]
[null,"SHOULD ITINERARY MATCH OTHER TRAVELERS? (include additional information for coordinating with other traveler(s) if applicable)"]
[null,"No"]
[null,"ACTUALS REQUESTED",null,null,null,null,null,"No",null,"MEALS PROVIDED"]
[null,"THIRD PARTY PAYER",null,null,null,null,null,"No",null,"NAME/COMMENTS"]
[null,"FINANCIAL CODING"]
[null,"CODING \nSPLIT 1",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of Coding Splits: ",null,null,null,null,1]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent1","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,1,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 2",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent2","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 3",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent3","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 4",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent4","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 5",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent5","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 6",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent6","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 7",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent7","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 8",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent8","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 9",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent9","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"CODING \nSPLIT 10",null,null,"Required - Accounting Template OR Fund-Unit-Appr Unit-%"]
[null,null,null,null,"Template",null,null,null,null,null,null,"Fund",null,null,null,null,null,null,"Unit",null,null,null,null,null,"Appr"]
[null,{"$f":"trEstCost*trFinPercent10","v":0},null,null,"Location",null,null,null,null,null,null,"Program",null,null,null,null,null,null,"Phase",null,null,null,null,null,"P Period"]
[null,0,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,null,"(choose)",null,null,null,null,null,"(choose)"]
[null,"PERSONAL TRAVEL"]
[null,"REQUEST INCLUDES \nPERSONAL TRAVEL",null,null,null,"No",null,"Does this request include any itinerary changes to include personal travel? This includes changes to the return or departure date with no other routing changes, e.g. extending your stay through the weekend. If there are any routing changes, or if the traveler wishes to use a companion certificate for a non-state traveler to accompany them, then the traveler is responsible for purchasing the airfare.  The state will cover airfare costs up to the estimated amount of the state authorized travel. The state is not responsible for the cost of any travel purchased by the employee prior to receiving formal authorization for state travel."]
[null,"No","This request includes a personal travel extension with NO routing change from the state authorized destination(s) AND NO companion certificate.",null,null,null,null,null,null,null,null,null,null,null,null,null,"No","This request is for a state authorized airfare quote only. The traveler is responsible for purchasing the air travel themselves due to personal travel that includes a routing change or the use of a companion certificate."]
[null,"STATE AUTHORIZED TRAVEL (DATES, TIMES, DESTINATION, REQUESTED LEAVE)"]
[null,"Minimum Business Itinerary (MBI) Details"]
[null,"Begin Date",null,null,null,null,null,null,null,null,"End Date",null,null,null,null,null,null,null,null,"State Authorized Airfare/MBI Quote"]
[null,"Notes",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,{"$f":"IF(trStAuthTrav=\"\",\"\",trStAuthTrav)","v":""}]
[null,"REQUESTED ARRANGEMENTS / ITINERARY"]
[null,"No",null,"Will the traveler be attending a conference or training?"]
[null,"CONFERENCE NAME/CLASS TITLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOTEL CONFERENCE # or NIGHTLY RATE",null,null,null,null,null,null,null,null,null,"SHUTTLE PROVIDED?"]
[]
[null,"PRESENTER?",null,null,"COMMENTS"]
[null,"No",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,{"$f":"IF(trConfComments=\"\",\"\",trConfComments)","v":""}]
[null,"No",null,"Will the traveler be requesting a travel advance?  (Please do not answer Yes for ATM withdrawals)."]
[null,"Note: Travel advances are paid in accordance with Alaska Administrative Manual (AAM) guidelines as defined in section 60.070. In order to receive a travel advance, you must first have a signed Travel Advance Authorization Form on file with the state."]
[]
[null,"http://doa.alaska.gov/dof/manuals/aam/resource/60t.pdf#070",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://doa.alaska.gov/dof/forms/resource/trvl_adv_auth.pdf"]
[null,"No",null,"Does itinerary include Air Travel?",null,null,null,null,null,null,null,null,null,"No",null,"Is a refundable ticket required?"]
[null,"FROM",null,null,null,null,null,null,null,"DEPART DATE",null,null,"TIME/FLT NO",null,null,null,"TO",null,null,null,null,null,null,null,"ARRIVE",null,null,"TIME"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"No",null,"Does itinerary include a Hotel Booking? (If Yes, please provide multiple hotel choices.)"]
[null,"Note: Actual lodging expenses that exceed $300 room rate per night, excluding taxes, must be approved in advance by commissioners or designee. All requests shall include justification that clearly demonstrates the lodging is a government rate and cannot be acquired for less than $300 per night. Quotes from a least three moderately priced hotels in the same vicinity should be included with the justification. Alaska Administrative Manual (AAM) Section 60.240. "]
[]
[]
[]
[null,"CITY",null,null,null,null,null,null,null,"HOTEL/LOCATION",null,null,null,null,null,null,null,"CHECK-IN",null,null,"CHECK-OUT",null,null,"COMMENTS"]
[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,{"$f":"IF(X104=\"\",\"\",X104)","v":""}]
[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,{"$f":"IF(X105=\"\",\"\",X105)","v":""}]
[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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X109=\"\",\"\",X109)","v":""}]
[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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"No",null,"Does itinerary include a Rental Car Reservation?"]
[null,"Note: Alaska Administrative Manual (AAM) section 60.120 Rental Cars authorizes the use of mid-size or less.\nSituations when larger vehicles are needed must be documented on the completed Travel Authorization."]
[]
[null,"http://doa.alaska.gov/dof/manuals/aam/resource/60t.pdf#120"]
[null,"CITY",null,null,null,null,null,null,null,null,"PICK-UP DATE",null,null,null,"RETURN DATE",null,null,null,"RETURN LOCATION (if different)",null,null,null,null,null,null,null,null,"SPECIAL REQUEST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"No",null,"Does Itinerary include any Rural or Non-Standard Travel?"]
[null,"DESTINATION",null,null,null,null,null,null,null,null,"TYPE",null,null,null,"ADDITIONAL DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,"MILEAGE/COST"]
[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,{"$f":"IF(O131=\"\",\"\",O131)","v":""}]
[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,{"$f":"IF(O132=\"\",\"\",O132)","v":""}]
[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,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,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,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,{"$f":"IF(O136=\"\",\"\",O136)","v":""}]
[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,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,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,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,"No",null,"Does Itinerary include Alaska Marine Highway System (AMHS) Travel?"]
[null,"VEHICLE TYPE",null,null,null,null,"YEAR",null,null,"MAKE",null,null,null,null,null,"MODEL",null,null,null,null,null,"SUB-MODEL",null,null,null,null,null,"LENGTH (FEET)"]
[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,{"$f":"IF(O143=\"\",\"\",O143)","v":""}]
[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,{"$f":"IF(O144=\"\",\"\",O144)","v":""}]
[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,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,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,"OTHER SPECIAL INSTRUCTIONS"]
[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,{"$f":"IF(trOther=\"\",\"\",trOther)","v":""}]
[]
[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,{"$f":"IF(trCoding>0,(CONCATENATE(\"Financial Coding Split 1 - \",IF(trFinAmt1<>0,CONCATENATE(\"Amount: $\",trFinAmt1,\"; \"),\"\"),IF(trFinPercent1<>0,CONCATENATE(\"Percent: \",trFinPercent1*100,\"%; \"),\"\"),IF(trFinTempl1<>\"\",CONCATENATE(E30,\": \",trFinTempl1,\"; \"),\"\"),IF(trFinFund1<>\"\",CONCATENATE(L30,\": \",trFinFund1,\"; \"),\"\"),IF(trFinDept1<>\"\",CONCATENATE(S30,\": \",,trFinUnit1,\"; \"),\"\"),IF(trFinAppr1<>\"\",CONCATENATE(Y30,\": \",trFinAppr1,\"; \"),\"\"),IF(trFinFunc1<>\"\",CONCATENATE(E31,\": \",trFinFunc1,\"; \"),\"\"),IF(trFinProg1<>\"\",CONCATENATE(L31,\": \",trFinProg1,\"; \"),\"\"),IF(trFinPhase1<>\"\",CONCATENATE(S31,\": \",trFinPhase1,\"; \"),\"\"),IF(trFinOtherA1<>\"\",CONCATENATE(Y31,\": \",trFinOtherA1,\"; \"),\"\"),IF(trFinOtherB1<>\"\",CONCATENATE(E32,\": \",trFinOtherB1,\"; \"),\"\"),IF(trFinOtherC1<>\"\",CONCATENATE(L32,\": \",trFinOtherC1,\"; \"),\"\"),IF(trFinOtherD1<>\"\",CONCATENATE(S32,\": \",trFinOtherD1,\"; \"),\"\"),IF(trFinOtherE1<>\"\",CONCATENATE(Y32,\": \",trFinOtherE1,\"; \"),\"\"))),\"\")","v":"Financial Coding Split 1 - Percent: 100%; "}]
[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,{"$f":"IF(trCoding>1,(CONCATENATE(\"Financial Coding Split 2 - \",IF(trFinAmt2<>0,CONCATENATE(\"Amount: $\",trFinAmt2,\"; \"),\"\"),IF(trFinPercent2<>0,CONCATENATE(\"Percent: \",trFinPercent2*100,\"%; \"),\"\"),IF(trFinTempl2<>\"\",CONCATENATE(E34,\": \",trFinTempl2,\"; \"),\"\"),IF(trFinFund2<>\"\",CONCATENATE(L34,\": \",trFinFund2,\"; \"),\"\"),IF(trFinDept2<>\"\",CONCATENATE(S34,\": \",,trFinUnit2,\"; \"),\"\"),IF(trFinAppr2<>\"\",CONCATENATE(Y34,\": \",trFinAppr2,\"; \"),\"\"),IF(trFinFunc2<>\"\",CONCATENATE(E35,\": \",trFinFunc2,\"; \"),\"\"),IF(trFinProg2<>\"\",CONCATENATE(L35,\": \",trFinProg2,\"; \"),\"\"),IF(trFinPhase2<>\"\",CONCATENATE(S35,\": \",trFinPhase2,\"; \"),\"\"),IF(trFinOtherA2<>\"\",CONCATENATE(Y35,\": \",trFinOtherA2,\"; \"),\"\"),IF(trFinOtherB2<>\"\",CONCATENATE(E36,\": \",trFinOtherB2,\"; \"),\"\"),IF(trFinOtherC2<>\"\",CONCATENATE(L36,\": \",trFinOtherC2,\"; \"),\"\"),IF(trFinOtherD2<>\"\",CONCATENATE(S36,\": \",trFinOtherD2,\"; \"),\"\"),IF(trFinOtherE2<>\"\",CONCATENATE(Y36,\": \",trFinOtherE2,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>2,(CONCATENATE(\"Financial Coding Split 3 - \",IF(trFinAmt3<>0,CONCATENATE(\"Amount: $\",trFinAmt3,\"; \"),\"\"),IF(trFinPercent3<>0,CONCATENATE(\"Percent: \",trFinPercent3*100,\"%; \"),\"\"),IF(trFinTempl3<>\"\",CONCATENATE(E38,\": \",trFinTempl3,\"; \"),\"\"),IF(trFinFund3<>\"\",CONCATENATE(L38,\": \",trFinFund3,\"; \"),\"\"),IF(trFinDept3<>\"\",CONCATENATE(S38,\": \",,trFinUnit3,\"; \"),\"\"),IF(trFinAppr3<>\"\",CONCATENATE(Y38,\": \",trFinAppr3,\"; \"),\"\"),IF(trFinFunc3<>\"\",CONCATENATE(E39,\": \",trFinFunc3,\"; \"),\"\"),IF(trFinProg3<>\"\",CONCATENATE(L39,\": \",trFinProg3,\"; \"),\"\"),IF(trFinPhase3<>\"\",CONCATENATE(S39,\": \",trFinPhase3,\"; \"),\"\"),IF(trFinOtherA3<>\"\",CONCATENATE(Y39,\": \",trFinOtherA3,\"; \"),\"\"),IF(trFinOtherB3<>\"\",CONCATENATE(E40,\": \",trFinOtherB3,\"; \"),\"\"),IF(trFinOtherC3<>\"\",CONCATENATE(L40,\": \",trFinOtherC3,\"; \"),\"\"),IF(trFinOtherD3<>\"\",CONCATENATE(S40,\": \",trFinOtherD3,\"; \"),\"\"),IF(trFinOtherE3<>\"\",CONCATENATE(Y40,\": \",trFinOtherE3,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>3,(CONCATENATE(\"Financial Coding Split 4 - \",IF(trFinAmt4<>0,CONCATENATE(\"Amount: $\",trFinAmt4,\"; \"),\"\"),IF(trFinPercent4<>0,CONCATENATE(\"Percent: \",trFinPercent4*100,\"%; \"),\"\"),IF(trFinTempl4<>\"\",CONCATENATE(E42,\": \",trFinTempl4,\"; \"),\"\"),IF(trFinFund4<>\"\",CONCATENATE(L42,\": \",trFinFund4,\"; \"),\"\"),IF(trFinDept4<>\"\",CONCATENATE(S42,\": \",,trFinUnit4,\"; \"),\"\"),IF(trFinAppr4<>\"\",CONCATENATE(Y42,\": \",trFinAppr4,\"; \"),\"\"),IF(trFinFunc4<>\"\",CONCATENATE(E43,\": \",trFinFunc4,\"; \"),\"\"),IF(trFinProg4<>\"\",CONCATENATE(L43,\": \",trFinProg4,\"; \"),\"\"),IF(trFinPhase4<>\"\",CONCATENATE(S43,\": \",trFinPhase4,\"; \"),\"\"),IF(trFinOtherA4<>\"\",CONCATENATE(Y43,\": \",trFinOtherA4,\"; \"),\"\"),IF(trFinOtherB4<>\"\",CONCATENATE(E44,\": \",trFinOtherB4,\"; \"),\"\"),IF(trFinOtherC4<>\"\",CONCATENATE(L44,\": \",trFinOtherC4,\"; \"),\"\"),IF(trFinOtherD4<>\"\",CONCATENATE(S44,\": \",trFinOtherD4,\"; \"),\"\"),IF(trFinOtherE4<>\"\",CONCATENATE(Y44,\": \",trFinOtherE4,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>4,(CONCATENATE(\"Financial Coding Split 5 - \",IF(trFinAmt5<>0,CONCATENATE(\"Amount: $\",trFinAmt5,\"; \"),\"\"),IF(trFinPercent5<>0,CONCATENATE(\"Percent: \",trFinPercent5*100,\"%; \"),\"\"),IF(trFinTempl5<>\"\",CONCATENATE(E46,\": \",trFinTempl5,\"; \"),\"\"),IF(trFinFund5<>\"\",CONCATENATE(L46,\": \",trFinFund5,\"; \"),\"\"),IF(trFinDept5<>\"\",CONCATENATE(S46,\": \",,trFinUnit5,\"; \"),\"\"),IF(trFinAppr5<>\"\",CONCATENATE(Y46,\": \",trFinAppr5,\"; \"),\"\"),IF(trFinFunc5<>\"\",CONCATENATE(E47,\": \",trFinFunc5,\"; \"),\"\"),IF(trFinProg5<>\"\",CONCATENATE(L47,\": \",trFinProg5,\"; \"),\"\"),IF(trFinPhase5<>\"\",CONCATENATE(S47,\": \",trFinPhase5,\"; \"),\"\"),IF(trFinOtherA5<>\"\",CONCATENATE(Y47,\": \",trFinOtherA5,\"; \"),\"\"),IF(trFinOtherB5<>\"\",CONCATENATE(E48,\": \",trFinOtherB5,\"; \"),\"\"),IF(trFinOtherC5<>\"\",CONCATENATE(L48,\": \",trFinOtherC5,\"; \"),\"\"),IF(trFinOtherD5<>\"\",CONCATENATE(S48,\": \",trFinOtherD5,\"; \"),\"\"),IF(trFinOtherE5<>\"\",CONCATENATE(Y48,\": \",trFinOtherE5,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>5,(CONCATENATE(\"Financial Coding Split 6 - \",IF(trFinAmt6<>0,CONCATENATE(\"Amount: $\",trFinAmt6,\"; \"),\"\"),IF(trFinPercent6<>0,CONCATENATE(\"Percent: \",trFinPercent6*100,\"%; \"),\"\"),IF(trFinTempl6<>\"\",CONCATENATE(E50,\": \",trFinTempl6,\"; \"),\"\"),IF(trFinFund6<>\"\",CONCATENATE(L50,\": \",trFinFund6,\"; \"),\"\"),IF(trFinDept6<>\"\",CONCATENATE(S50,\": \",,trFinUnit6,\"; \"),\"\"),IF(trFinAppr6<>\"\",CONCATENATE(Y50,\": \",trFinAppr6,\"; \"),\"\"),IF(trFinFunc6<>\"\",CONCATENATE(E51,\": \",trFinFunc6,\"; \"),\"\"),IF(trFinProg6<>\"\",CONCATENATE(L51,\": \",trFinProg6,\"; \"),\"\"),IF(trFinPhase6<>\"\",CONCATENATE(S51,\": \",trFinPhase6,\"; \"),\"\"),IF(trFinOtherA6<>\"\",CONCATENATE(Y51,\": \",trFinOtherA6,\"; \"),\"\"),IF(trFinOtherB6<>\"\",CONCATENATE(E52,\": \",trFinOtherB6,\"; \"),\"\"),IF(trFinOtherC6<>\"\",CONCATENATE(L52,\": \",trFinOtherC6,\"; \"),\"\"),IF(trFinOtherD6<>\"\",CONCATENATE(S52,\": \",trFinOtherD6,\"; \"),\"\"),IF(trFinOtherE6<>\"\",CONCATENATE(Y52,\": \",trFinOtherE6,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>6,(CONCATENATE(\"Financial Coding Split 7 - \",IF(trFinAmt7<>0,CONCATENATE(\"Amount: $\",trFinAmt7,\"; \"),\"\"),IF(trFinPercent7<>0,CONCATENATE(\"Percent: \",trFinPercent7*100,\"%; \"),\"\"),IF(trFinTempl7<>\"\",CONCATENATE(E42,\": \",trFinTempl7,\"; \"),\"\"),IF(trFinFund7<>\"\",CONCATENATE(L42,\": \",trFinFund7,\"; \"),\"\"),IF(trFinDept7<>\"\",CONCATENATE(S42,\": \",,trFinUnit7,\"; \"),\"\"),IF(trFinAppr7<>\"\",CONCATENATE(Y42,\": \",trFinAppr7,\"; \"),\"\"),IF(trFinFunc7<>\"\",CONCATENATE(E43,\": \",trFinFunc7,\"; \"),\"\"),IF(trFinProg7<>\"\",CONCATENATE(L43,\": \",trFinProg7,\"; \"),\"\"),IF(trFinPhase7<>\"\",CONCATENATE(S43,\": \",trFinPhase7,\"; \"),\"\"),IF(trFinOtherA7<>\"\",CONCATENATE(Y43,\": \",trFinOtherA7,\"; \"),\"\"),IF(trFinOtherB7<>\"\",CONCATENATE(E44,\": \",trFinOtherB7,\"; \"),\"\"),IF(trFinOtherC7<>\"\",CONCATENATE(L44,\": \",trFinOtherC7,\"; \"),\"\"),IF(trFinOtherD7<>\"\",CONCATENATE(S44,\": \",trFinOtherD7,\"; \"),\"\"),IF(trFinOtherE7<>\"\",CONCATENATE(Y44,\": \",trFinOtherE7,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>7,(CONCATENATE(\"Financial Coding Split 8 - \",IF(trFinAmt8<>0,CONCATENATE(\"Amount: $\",trFinAmt8,\"; \"),\"\"),IF(trFinPercent8<>0,CONCATENATE(\"Percent: \",trFinPercent8*100,\"%; \"),\"\"),IF(trFinTempl8<>\"\",CONCATENATE(E58,\": \",trFinTempl8,\"; \"),\"\"),IF(trFinFund8<>\"\",CONCATENATE(L58,\": \",trFinFund8,\"; \"),\"\"),IF(trFinDept8<>\"\",CONCATENATE(S58,\": \",,trFinUnit8,\"; \"),\"\"),IF(trFinAppr8<>\"\",CONCATENATE(Y58,\": \",trFinAppr8,\"; \"),\"\"),IF(trFinFunc8<>\"\",CONCATENATE(E59,\": \",trFinFunc8,\"; \"),\"\"),IF(trFinProg8<>\"\",CONCATENATE(L59,\": \",trFinProg8,\"; \"),\"\"),IF(trFinPhase8<>\"\",CONCATENATE(S59,\": \",trFinPhase8,\"; \"),\"\"),IF(trFinOtherA8<>\"\",CONCATENATE(Y59,\": \",trFinOtherA8,\"; \"),\"\"),IF(trFinOtherB8<>\"\",CONCATENATE(E60,\": \",trFinOtherB8,\"; \"),\"\"),IF(trFinOtherC8<>\"\",CONCATENATE(L60,\": \",trFinOtherC8,\"; \"),\"\"),IF(trFinOtherD8<>\"\",CONCATENATE(S64,\": \",trFinOtherD8,\"; \"),\"\"),IF(trFinOtherE8<>\"\",CONCATENATE(Y60,\": \",trFinOtherE8,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>8,(CONCATENATE(\"Financial Coding Split 9 - \",IF(trFinAmt9<>0,CONCATENATE(\"Amount: $\",trFinAmt9,\"; \"),\"\"),IF(trFinPercent9<>0,CONCATENATE(\"Percent: \",trFinPercent9*100,\"%; \"),\"\"),IF(trFinTempl9<>\"\",CONCATENATE(E62,\": \",trFinTempl9,\"; \"),\"\"),IF(trFinFund9<>\"\",CONCATENATE(L62,\": \",trFinFund9,\"; \"),\"\"),IF(trFinDept9<>\"\",CONCATENATE(S62,\": \",,trFinUnit9,\"; \"),\"\"),IF(trFinAppr9<>\"\",CONCATENATE(Y62,\": \",trFinAppr9,\"; \"),\"\"),IF(trFinFunc9<>\"\",CONCATENATE(E63,\": \",trFinFunc9,\"; \"),\"\"),IF(trFinProg9<>\"\",CONCATENATE(L63,\": \",trFinProg9,\"; \"),\"\"),IF(trFinPhase9<>\"\",CONCATENATE(S63,\": \",trFinPhase9,\"; \"),\"\"),IF(trFinOtherA9<>\"\",CONCATENATE(Y63,\": \",trFinOtherA9,\"; \"),\"\"),IF(trFinOtherB9<>\"\",CONCATENATE(E64,\": \",trFinOtherB9,\"; \"),\"\"),IF(trFinOtherC9<>\"\",CONCATENATE(L64,\": \",trFinOtherC9,\"; \"),\"\"),IF(trFinOtherD9<>\"\",CONCATENATE(S64,\": \",trFinOtherD9,\"; \"),\"\"),IF(trFinOtherE9<>\"\",CONCATENATE(Y64,\": \",trFinOtherE9,\"; \"),\"\"))),\"\")","v":""}]
[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,{"$f":"IF(trCoding>9,(CONCATENATE(\"Financial Coding Split 10 - \",IF(trFinAmt10<>0,CONCATENATE(\"Amount: $\",trFinAmt10,\"; \"),\"\"),IF(trFinPercent10<>0,CONCATENATE(\"Percent: \",trFinPercent10*100,\"%; \"),\"\"),IF(trFinTempl10<>\"\",CONCATENATE(E66,\": \",trFinTempl10,\"; \"),\"\"),IF(trFinFund10<>\"\",CONCATENATE(L66,\": \",trFinFund10,\"; \"),\"\"),IF(trFinDept10<>\"\",CONCATENATE(S66,\": \",,trFinUnit10,\"; \"),\"\"),IF(trFinAppr10<>\"\",CONCATENATE(Y66,\": \",trFinAppr10,\"; \"),\"\"),IF(trFinFunc10<>\"\",CONCATENATE(E67,\": \",trFinFunc10,\"; \"),\"\"),IF(trFinProg10<>\"\",CONCATENATE(L67,\": \",trFinProg10,\"; \"),\"\"),IF(trFinPhase10<>\"\",CONCATENATE(S67,\": \",trFinPhase10,\"; \"),\"\"),IF(trFinOtherA10<>\"\",CONCATENATE(Y67,\": \",trFinOtherA10,\"; \"),\"\"),IF(trFinOtherB10<>\"\",CONCATENATE(E68,\": \",trFinOtherB10,\"; \"),\"\"),IF(trFinOtherC10<>\"\",CONCATENATE(L68,\": \",trFinOtherC10,\"; \"),\"\"),IF(trFinOtherD10<>\"\",CONCATENATE(S68,\": \",trFinOtherD10,\"; \"),\"\"),IF(trFinOtherE10<>\"\",CONCATENATE(Y68,\": \",trFinOtherE10,\"; \"),\"\"))),\"\")","v":""}]

{"sheet":"TA with Exp Report","index":4,"n_rows":66,"n_cols":47,"rows_kept":66,"cut":false,"hidden":false,"merged":[[7,24,7,27],[7,28,7,31],[6,24,6,27],[6,28,6,31],[7,20,7,23],[6,17,6,19],[6,1,6,7],[7,1,7,7],[6,9,7,16],[6,20,6,23],[40,30,40,31],[39,30,39,31],[40,24,40,26],[48,26,48,28],[59,11,59,17],[50,10,50,11],[50,17,50,18],[50,15,50,16],[64,24,64,25],[54,1,54,31],[55,1,55,31],[60,21,60,23],[63,24,63,25],[62,11,62,17],[59,24,59,25],[60,11,60,17],[64,26,64,27],[57,29,58,31],[59,29,59,31],[59,18,59,20],[60,26,60,27],[59,1,59,2],[61,21,61,23],[62,5,62,10],[65,29,65,31],[63,26,63,27],[65,26,65,27],[63,11,63,17],[64,11,64,17],[61,11,61,17],[61,24,61,25],[60,24,60,25],[60,18,60,20],[65,11,65,17],[65,24,65,25],[65,21,65,23],[65,18,65,20],[63,29,63,31],[64,29,64,31],[62,18,62,20],[62,24,62,25],[61,29,61,31],[62,29,62,31],[60,29,60,31],[63,18,63,20],[63,21,63,23],[64,18,64,20],[64,21,64,23],[33,30,33,31],[36,30,36,31],[37,27,37,29],[36,24,36,26],[34,30,34,31],[34,24,34,26],[37,24,37,26],[33,24,33,26],[33,27,33,29],[34,27,34,29],[37,30,37,31],[35,30,35,31],[35,24,35,26],[35,27,35,29],[59,5,59,10],[53,5,53,8],[61,26,61,27],[57,26,58,27],[59,26,59,27],[62,21,62,23],[57,28,58,28],[59,21,59,23],[59,3,59,4],[57,11,58,17],[57,18,58,20],[57,3,58,4],[57,5,58,10],[61,18,61,20],[62,26,62,27],[57,21,58,23],[57,1,58,2],[50,23,50,31],[50,20,50,22],[53,23,53,31],[53,19,53,22],[50,7,50,8],[51,7,51,8],[47,1,47,16],[52,10,52,11],[53,1,53,4],[51,23,51,31],[47,17,47,22],[48,17,49,18],[48,19,49,19],[48,20,49,22],[48,1,49,1],[53,9,53,11],[53,12,53,14],[48,12,49,14],[49,26,49,28],[52,4,52,6],[52,12,52,14],[57,24,58,25],[51,2,51,3],[38,30,38,31],[49,29,49,31],[56,1,56,25],[42,16,43,19],[56,26,56,31],[40,20,40,23],[45,1,45,11],[38,1,38,3],[39,18,39,19],[53,15,53,18],[52,2,52,3],[50,2,50,3],[50,4,50,6],[51,10,51,11],[46,29,46,31],[48,23,48,25],[39,22,39,23],[40,27,40,29],[39,20,39,21],[39,14,39,15],[40,16,40,19],[40,1,40,15],[48,7,49,8],[45,13,45,15],[33,22,33,23],[37,18,37,19],[37,1,37,3],[36,14,36,15],[37,4,37,13],[38,18,38,19],[34,1,34,3],[35,4,35,13],[36,16,36,17],[38,14,38,15],[35,16,35,17],[35,18,35,19],[35,1,35,3],[34,14,34,15],[36,4,36,13],[34,20,34,21],[35,20,35,21],[37,14,37,15],[38,4,38,13],[36,18,36,19],[35,14,35,15],[37,22,37,23],[33,20,33,21],[34,16,34,17],[21,1,21,5],[20,6,20,10],[21,6,21,10],[22,4,22,13],[23,4,23,13],[22,18,22,27],[39,16,39,17],[65,1,65,2],[65,3,65,4],[65,5,65,10],[60,1,60,2],[60,3,60,4],[61,1,61,2],[61,3,61,4],[61,5,61,10],[62,3,62,4],[64,3,64,4],[64,5,64,10],[63,3,63,4],[63,5,63,10],[60,5,60,10],[64,1,64,2],[63,1,63,2],[62,1,62,2],[33,18,33,19],[38,16,38,17],[37,16,37,17],[39,1,39,3],[42,20,42,28],[42,13,42,15],[17,30,17,31],[18,23,18,24],[19,1,19,5],[19,6,19,31],[22,1,23,3],[20,22,20,25],[21,18,21,21],[21,22,21,25],[18,30,18,31],[21,26,21,31],[20,26,20,31],[18,20,18,22],[18,25,18,29],[18,1,18,7],[22,28,22,31],[17,20,17,29],[23,28,23,31],[20,1,20,5],[51,4,51,6],[48,4,49,6],[41,29,41,31],[45,29,45,31],[42,29,42,31],[43,29,43,31],[48,29,48,31],[48,15,49,16],[49,23,49,25],[44,16,44,28],[51,12,51,14],[42,1,42,11],[48,10,49,11],[48,2,49,3],[48,9,49,9],[43,20,43,24],[47,23,47,31],[51,20,51,22],[52,20,52,22],[52,17,52,18],[32,24,32,26],[52,7,52,8],[34,4,34,13],[33,16,33,17],[35,22,35,23],[33,4,33,13],[33,14,33,15],[38,24,38,26],[43,25,43,28],[46,13,46,15],[45,16,45,28],[51,15,51,16],[52,15,52,16],[52,23,52,31],[44,29,44,31],[41,16,41,19],[41,20,41,28],[46,16,46,28],[51,17,51,18],[50,12,50,14],[39,27,39,29],[46,1,46,12],[36,1,36,3],[39,4,39,13],[36,20,36,21],[36,22,36,23],[38,27,38,29],[38,22,38,23],[38,20,38,21],[34,18,34,19],[36,27,36,29],[37,20,37,21],[39,24,39,26],[33,1,33,3],[34,22,34,23],[25,4,25,10],[32,14,32,15],[32,16,32,17],[32,30,32,31],[25,11,25,13],[25,20,25,22],[31,22,31,23],[25,23,25,28],[30,30,31,31],[27,4,27,10],[25,29,25,31],[30,4,31,13],[32,22,32,23],[32,18,32,19],[32,4,32,13],[32,27,32,29],[26,23,26,28],[26,11,27,13],[26,20,27,22],[26,29,27,31],[32,20,32,21],[32,1,32,3],[23,18,23,27],[22,14,22,17],[30,1,31,3],[24,1,24,3],[23,14,23,17],[30,20,30,23],[31,27,31,29],[25,14,25,19],[27,14,27,19],[31,24,31,26],[30,18,31,19],[28,1,28,31],[27,23,27,28],[26,4,26,10],[26,14,26,19],[24,4,24,31],[29,1,29,31],[30,14,31,15],[30,24,30,29],[31,20,31,21],[25,1,25,3],[26,1,26,3],[27,1,27,3],[30,16,31,17],[1,1,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[20,16,21,17],[20,18,20,21],[18,8,18,19],[8,1,8,31],[15,1,15,3],[20,11,21,15],[16,1,16,3],[16,4,16,5],[16,8,16,31],[16,6,16,7],[7,17,7,19],[15,4,15,31],[17,1,17,19],[10,30,10,31],[11,1,11,8],[11,16,11,20],[13,1,13,24],[14,1,14,24],[13,25,14,27],[9,15,9,26],[10,15,10,26],[9,1,9,14],[10,1,10,14],[10,27,10,29],[12,1,12,8],[12,9,12,15],[12,28,12,31],[12,23,12,25],[12,16,12,20]]}
[null,"TRAVEL AUTHORIZATION / EXPENSE REPORT OPTIONS:"]
[null,"State Employee",null,null,null,null,"Is the traveler a State Employee (EE) or a Non-Employee (EE)?"]
[null,"In-State",null,null,null,null,"Is this form for in-state (intra-Alaska) travel or travel outside of Alaska?",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,"trav_non_ee",false]
[null,"Yes",null,null,null,null,"Is the Warrant Mailing Address different than the mailing address on the Traveler's VN Customer Number record?",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,"dest_intra",true]
[null,"No",null,null,null,null,"DPS Only: Does this form contain Prisoner Transport Travel?",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,"dest_out",false]
[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,"trav_adv",false]
[null,"TRAVEL AUTHORIZATION",null,null,null,null,null,null,null,"STATE OF ALASKA",null,null,null,null,null,null,null,"EMP NO.",null,null,"TRAVEL AUTH NO.",null,null,null,"TRQS NO.",null,null,null,"TAPO NO."]
[null,"AND EXPENSE REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trEmplNum<>\"\",trEmplNum,\" \")","v":" "},null,null,{"$f":"IF(trTANumber<>\"\",trTANumber,\" \")","v":" "},null,null,null,{"$f":"IF(trTRQS<>\"\",trTRQS,\" \")","v":" "},null,null,null,{"$f":"IF(trTAPO<>\"\",trTAPO,\" \")","v":" "}]
[null,"TRAVEL AUTHORIZATION"]
[null,"NAME OF TRAVELER",null,null,null,null,null,null,null,null,null,null,null,null,null,"JOB TITLE",null,null,null,null,null,null,null,null,null,null,null,"AGENCY",null,null,"DIVISION"]
[null,{"$f":"trLegalName","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"trTitle","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trDept<>\"\",(CONCATENATE(trDept,\"  (\",VLOOKUP(trDept,trRanges!C3:E21,3,FALSE),\")\")),\" \")","v":" "},null,null,{"$f":"trDivision","v":" "}]
[null,"SECTION",null,null,null,null,null,null,null,"BARGAINING UNIT",null,null,null,null,null,null,"DUTY STATION",null,null,null,null,"NORMAL WORK SCHEDULE (DOT ONLY)"]
[null,{"$f":"trSection","v":" "},null,null,null,null,null,null,null,{"$f":"trBU","v":" "},null,null,null,null,null,null,{"$f":"trDutyStation","v":" "},null,null,null,null,"DAYS",null,null,null,null,"TIME"]
[null,"PERSONAL PHYSICAL ADDRESS (Street No., City, State Zip) (optional)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REQUEST INCLUDES",null,null,{"$f":"trActuals","v":"No"},"Actuals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01",0.7]
[null,{"$f":"trAddress","v":" "},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,{"$f":"trTravAdv","v":"No"},"Travel Advance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01",0.67]
[null,"PURPOSE\nOF TRIP",null,null,{"$f":"IF(trPurpose<>\"\",trPurpose,\" \")","v":" "},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,{"$f":"IF(trPurpose=\"\",\"\",trPurpose)","v":""},"PURPOSE OF TRIP"]
[null,"EXECUTIVE TRAVEL?",null,null,{"$f":"trExecTrav","v":"No"},null,"TYPE",null,{"$f":"IF(ExecTrav=\"No\",\"\",LEFT(AH17,LEN(AH17)-2))","v":""},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":"IF(trExecTrav=\"Yes\",(CONCATENATE(IF('Travel Request'!$AJ$23=TRUE,\"Board/Comm/Council Related, \",\"\"),IF('Travel Request'!$AK$23=TRUE,\"Conf/Training Related, \",\"\"),IF('Travel Request'!$AL$23=TRUE,\"Constituent Related, \",\"\"),IF('Travel Request'!$AM$23=TRUE,\"Exec Branch/Dept Related, \",\"\"),IF('Travel Request'!$AN$23=TRUE,\"Federal Related, \",\"\"),IF('Travel Request'!$AO$23=TRUE,\"Legislative Related, \",\"\"),IF('Travel Request'!$AP$23=TRUE,\"Gov Office Related, \",\"\"),IF('Travel Request'!$AQ$23=TRUE,\"Third-Party Reimbursement\",\"\"))),\"\")","v":""},"EXECUTIVE TRAVEL"]
[null,"PRISONER TRANSPORT TRAVEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORT BEFORE/AFTER ARRAIGNMENT?"]
[null,"TRANSPORT REQ/ORDERED BY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUVENILE?",null,null,null,null,"MENTAL HEALTH?"]
[null,"PRISONER DETAILS - NAME(S), DOB(S), and COURT CASE(S)"]
[null,"ESTIMATED COST",null,null,null,null,"CARD INFO",null,null,null,null,"REQUEST INCLUDES PERSONAL TRAVEL",null,null,null,null,{"$f":"'Travel Request'!F70","v":"No"},null,"MBI DATE BEGINS",null,null,null,"MBI DATE ENDS",null,null,null,"STATE AUTH AIRFARE"]
[null,{"$f":"IF(trEstCost<>\"\",trEstCost,\"$0.00\")","v":"$0.00"},null,null,null,null,{"$f":"IF(CARDTYP<>\"\",CONCATENATE(CARDTYP,\" \",LAST_4),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trMBIBegin<>\"\",trMBIBegin,\" \")","v":" "},null,null,null,{"$f":"IF(trMBIEnd<>\"\",trMBIEnd,\" \")","v":" "},null,null,null,{"$f":"IF(trMBIFare<>\"\",trMBIFare,\" \")","v":" "}]
[null,"ITINERARY",null,null,"FROM",null,null,null,null,null,null,null,null,null,"DEPARTURE DATE",null,null,null,"TO (DESTINATION)",null,null,null,null,null,null,null,null,null,"RETURN DATE"]
[null,null,null,null,{"$f":"IF(trHdrFrom<>\"\",trHdrFrom,\" \")","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(trHdrDepart<>\"\",trHdrDepart,\" \")","v":" "},null,null,null,{"$f":"IF(trHdrDest<>\"\",trHdrDest,\" \")","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF(trHdrReturn<>\"\",trHdrReturn,\" \")","v":" "}]
[null,"FINANCIAL \nCODING",null,null,{"$f":"CONCATENATE(trCodeSplit1,IF(trCodeSplit2<>\"\",CONCATENATE(\" | \",trCodeSplit2),\"\"),IF(trCodeSplit3<>\"\",CONCATENATE(\" | \",trCodeSplit3),\"\"),IF(trCodeSplit4<>\"\",CONCATENATE(\" | \",trCodeSplit4),\"\"),IF(trCodeSplit5<>\"\",CONCATENATE(\" | \",trCodeSplit5),\"\"),IF(trCodeSplit6<>\"\",CONCATENATE(\" | \",trCodeSplit6),\"\"),IF(trCodeSplit7<>\"\",CONCATENATE(\" | \",trCodeSplit7),\"\"),IF(trCodeSplit8<>\"\",CONCATENATE(\" | \",trCodeSplit8),\"\"),IF(trCodeSplit9<>\"\",CONCATENATE(\" | \",trCodeSplit9),\"\"),IF(trCodeSplit10<>\"\",CONCATENATE(\" | \",trCodeSplit10),\"\"))","v":"Financial Coding Split 1 - Percent: 100%; "},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,{"$f":"IF(taFinCoding=\"\",\"\",taFinCoding)","v":"Financial Coding Split 1 - Percent: 100%; "},"FINANCIAL CODING"]
[null,"TRAVEL APRV",null,null,"DIVISION (IN-STATE)",null,null,null,null,null,null,"DATE",null,null,"DEPT (INTERSTATE)",null,null,null,null,null,"DATE",null,null,"GOV (INTERSTATE/FOREIGN)",null,null,null,null,null,"DATE"]
[null,"PRINTED NAME"]
[null,"SIGNATURE"]
[null,"EXPENSE REPORT"]
[null,"ACTUAL TRAVEL, PER DIEM, AND REIMBURSABLE EXPENSES (NO PCARD CHARGES)"]
[null,"DATE",null,null,"EXPLANATION",null,null,null,null,null,null,null,null,null,"MEALS PROV",null,"FACIL-\nITY",null,"# OF\nMILES",null,"SURFACE TRANS",null,null,null,"PER DIEM",null,null,null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILEAGE",null,"OTHER",null,"LODGING",null,null,"M&IE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(B33=\"\", S33=\"\"),0,(IF(B33>=mileagedate1,ROUND(S33*mileagerate1,3),ROUND(S33*mileagerate2,3))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Claimant certifies by signing that the facts contained on this form and supporting documents are correct and constitute a valid claim against the State of Alaska.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALS",null,null,null,{"$f":"ROUND(SUM(U33:X40)+surf_cont+surf_cont2+surf_cont3+surf_cont4+surf_cont5,2)","v":0},null,null,null,{"$f":"SUM(Y33:AA40)+lodg_cont+lodg_cont2+lodg_cont3+lodg_cont4+lodg_cont5","v":0},null,null,{"$f":"SUM(AB33:AD40)+mie_cont+mie_cont2+mie_cont3+mie_cont4+mie_cont5","v":0},null,null,{"$f":"SUM(AE33:AF40)+other_cont+other_cont2+other_cont3+other_cont4+other_cont5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST VARIANCE",null,null,null,"TOTAL OUT OF POCKET EXPENSES",null,null,null,null,null,null,null,null,{"$f":"SUM(U41:AF41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((OR(ACTUAL<=est*1.2,ACTUAL-est<=100,est=\" \")),\"N/A\",ACTUAL-est)","v":"N/A"},null,null,null,"ATM WITHDRAWAL"]
[null,"TRAVELER SIGNATURE",null,null,null,null,null,null,null,null,null,null,null,"DATE",null,null,null,null,null,null,"TRAVEL ADV. TRANS #"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DUE TO/FROM TRAVELER",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD42-AD43-AD44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STATE PAID EXPENSES (PCARD / DIRECT BILL)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S60:U66)+ap_cont+ap_cont2+ap_cont3+AD44+ap_cont4+ap_cont5","v":0}]
[null,"EXPENSE REPORT APPROVAL SIGNATURE",null,null,null,null,null,null,null,null,null,null,null,"DATE",null,null,"TOTAL TRIP EXPENSE",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD45+AD46","v":0}]
[null,"TRAVELER'S REIMBURSEMENT WARRANT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRIS TRANSACTION ID",null,null,null,null,null,"TAXABLE TRAVEL REPORTING"]
[null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,"PAGE CODE",null,"DEPT","TRANS ID",null,null,"TOTAL",null,null,"NONTAX",null,null,"TAXABLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA50+AD50","v":0}]
[null,1,null,null,null,null,null,{"$f":"IF(C51=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(C51,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(C51,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(C51,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(C51,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$f":"IF(AND($AJ$2=TRUE,$AI$4=TRUE),VLOOKUP($C40,TYP_AC_TRAV,2),(IF(AND($AJ$2=TRUE,$AI$4=FALSE),VLOOKUP($C40,TYP_AC_TRAV,3))))","v":false},4,null,null,null,null,null,{"$f":"IF(K51=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(K51,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(K51,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(K51,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(K51,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$f":"IF(AND($AJ$2=TRUE,$AI$4=TRUE),VLOOKUP($C40,TYP_AC_TRAV,2),(IF(AND($AJ$2=TRUE,$AI$4=FALSE),VLOOKUP($C40,TYP_AC_TRAV,3))))","v":false},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}},null,null,null,"PREPARED BY"]
[null,2,null,null,null,null,null,{"$f":"IF(C52=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(C52,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(C52,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(C52,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(C52,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$f":"IF(AND($AJ$2=TRUE,$AI$4=TRUE),VLOOKUP($C41,TYP_AC_TRAV,2),(IF(AND($AJ$2=TRUE,$AI$4=FALSE),VLOOKUP($C41,TYP_AC_TRAV,3))))","v":false},5,null,null,null,null,null,{"$f":"IF(K52=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(K52,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(K52,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(K52,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(K52,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$f":"IF(AND($AJ$2=TRUE,$AI$4=TRUE),VLOOKUP($C41,TYP_AC_TRAV,2),(IF(AND($AJ$2=TRUE,$AI$4=FALSE),VLOOKUP($C41,TYP_AC_TRAV,3))))","v":false},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}}]
[null,3,null,null,null,null,null,{"$f":"IF(C53=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(C53,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(C53,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(C53,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(C53,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$f":"IF(AND($AJ$2=TRUE,$AI$4=TRUE),VLOOKUP($C42,TYP_AC_TRAV,2),(IF(AND($AJ$2=TRUE,$AI$4=FALSE),VLOOKUP($C42,TYP_AC_TRAV,3))))","v":false},6,null,null,null,null,null,{"$f":"IF(K53=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(K53,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(K53,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(K53,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(K53,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$f":"IF(AND($AJ$2=TRUE,$AI$4=TRUE),VLOOKUP($C42,TYP_AC_TRAV,2),(IF(AND($AJ$2=TRUE,$AI$4=FALSE),VLOOKUP($C42,TYP_AC_TRAV,3))))","v":false},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}},null,null,null,"PREPARER'S PHONE NUMBER"]
[null,"TRAVELER VCN",null,null,null,{"$f":"vcn","v":" "},null,null,null,"TOTAL PG 1",null,null,{"$f":"SUM(E51:G53,M51:O53)-SUMIF(C51:D53,\"T ADV\",E51:G53)-SUMIF(K51:L53,\"T ADV\",M51:O53)","v":0},null,null,"GRAND TOTAL",null,null,null,{"$f":"M54+Continuation!Z31+'Continuation (2)'!Z31+'Continuation (3)'!Z31+'Continuation (4)'!Z31+'Continuation (5)'!Z31","v":0}]
[null,"WARRANT MAILING ADDRESS (Address, City, State Zip)"]
[null,{"$f":"trMailing","v":" "}]
[null,"STATE PCARD CHARGES AND OTHER STATE PAID EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRIS TRANSACTION ID"]
[null,"TYPE",null,"REF ID",null,"REFERENCE / \nINV NUMBER",null,null,null,null,null,"VENDOR CUST NUM / \nVENDOR DESC",null,null,null,null,null,null,"AMOUNT",null,null,"DATE PAID",null,null,"IRIS OBJECT",null,"PAGE CODE",null,"DEPT","TRANS ID"]
[]
[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":"IF(B60=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($B60,TYP_AC_STATE,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($B60,TYP_AC_STATE,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($B60,TYP_AC_STATE,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($B60,TYP_AC_STATE,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]

{"sheet":"Continuation","index":5,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,1,15],[0,16,0,18],[0,19,0,22],[0,23,0,26],[0,27,0,30],[1,0,1,6],[1,16,1,18],[1,19,1,22],[1,23,1,26],[1,27,1,30],[49,17,49,19],[49,20,49,30],[49,4,49,16],[46,10,46,16],[46,17,46,19],[46,20,46,22],[46,23,46,24],[46,28,46,30],[47,10,47,16],[47,17,47,19],[47,20,47,22],[47,23,47,24],[47,28,47,30],[46,25,46,26],[48,25,48,26],[48,28,48,30],[44,10,44,16],[44,17,44,19],[44,20,44,22],[44,23,44,24],[44,28,44,30],[45,10,45,16],[45,17,45,19],[45,20,45,22],[45,23,45,24],[45,28,45,30],[44,25,44,26],[45,25,45,26],[42,10,42,16],[42,17,42,19],[42,20,42,22],[42,23,42,24],[42,28,42,30],[43,10,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,24],[43,28,43,30],[42,25,42,26],[43,25,43,26],[39,28,39,30],[40,10,40,16],[40,17,40,19],[40,20,40,22],[40,23,40,24],[40,28,40,30],[41,10,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,24],[41,28,41,30],[39,25,39,26],[39,20,39,22],[40,25,40,26],[41,25,41,26],[39,23,39,24],[32,25,33,26],[35,0,35,1],[32,4,33,9],[37,20,37,22],[37,23,37,24],[37,28,37,30],[38,10,38,16],[38,17,38,19],[38,20,38,22],[38,23,38,24],[38,28,38,30],[37,25,37,26],[36,25,36,26],[35,25,35,26],[38,0,38,1],[38,25,38,26],[35,10,35,16],[35,17,35,19],[35,20,35,22],[35,23,35,24],[22,29,22,30],[21,29,21,30],[20,26,20,28],[13,26,13,28],[35,28,35,30],[36,10,36,16],[36,17,36,19],[36,20,36,22],[36,23,36,24],[31,0,31,24],[31,25,31,30],[32,10,33,16],[32,17,33,19],[32,20,33,22],[32,23,33,24],[32,27,33,27],[32,28,33,30],[34,10,34,16],[34,17,34,19],[34,20,34,22],[34,23,34,24],[34,28,34,30],[34,25,34,26],[36,28,36,30],[8,29,8,30],[9,26,9,28],[8,26,8,28],[8,23,8,25],[9,29,9,30],[11,29,11,30],[10,23,10,25],[10,26,10,28],[10,29,10,30],[11,26,11,28],[13,29,13,30],[14,26,14,28],[12,23,12,25],[14,23,14,25],[18,21,18,22],[18,26,18,28],[18,29,18,30],[18,23,18,25],[17,23,17,25],[17,26,17,28],[15,26,15,28],[16,21,16,22],[13,23,13,25],[14,29,14,30],[17,21,17,22],[16,23,16,25],[16,29,16,30],[15,29,15,30],[16,26,16,28],[17,29,17,30],[12,26,12,28],[12,29,12,30],[20,29,20,30],[20,23,20,25],[19,23,19,25],[21,19,21,20],[21,21,21,22],[21,23,21,25],[21,26,21,28],[19,19,19,20],[19,21,19,22],[19,26,19,28],[20,21,20,22],[19,29,19,30],[8,17,8,18],[8,19,8,20],[8,21,8,22],[14,21,14,22],[10,17,10,18],[10,19,10,20],[10,21,10,22],[15,21,15,22],[16,19,16,20],[12,17,12,18],[9,21,9,22],[11,17,11,18],[12,19,12,20],[12,21,12,22],[11,19,11,20],[9,19,9,20],[12,3,12,12],[12,13,12,14],[12,15,12,16],[10,0,10,2],[10,3,10,12],[10,13,10,14],[10,15,10,16],[11,13,11,14],[11,15,11,16],[21,15,21,16],[21,17,21,18],[19,13,19,14],[18,13,18,14],[22,15,22,16],[15,13,15,14],[15,15,15,16],[14,19,14,20],[18,19,18,20],[16,13,16,14],[16,15,16,16],[16,17,16,18],[18,15,18,16],[17,15,17,16],[17,19,17,20],[17,17,17,18],[19,17,19,18],[19,15,19,16],[18,17,18,18],[20,19,20,20],[22,17,22,18],[22,19,22,20],[15,17,15,18],[20,17,20,18],[27,14,27,16],[27,12,27,13],[28,6,28,8],[29,6,29,8],[29,3,29,5],[28,3,28,5],[23,19,23,22],[23,23,23,25],[24,0,24,30],[23,29,23,30],[25,3,26,5],[27,3,27,5],[27,6,27,8],[25,23,26,24],[25,0,26,0],[25,25,26,27],[28,28,28,30],[27,28,27,30],[29,17,29,19],[29,28,29,30],[27,25,27,27],[27,23,27,24],[23,26,23,28],[28,25,28,27],[22,26,22,28],[22,0,22,2],[22,3,22,12],[22,13,22,14],[30,25,30,30],[28,1,28,2],[27,1,27,2],[25,1,26,2],[25,11,26,11],[25,12,26,13],[29,23,29,24],[28,14,28,16],[29,14,29,16],[29,12,29,13],[28,12,28,13],[28,17,28,19],[30,0,30,24],[25,28,26,30],[25,17,26,19],[25,6,26,8],[25,14,26,16],[25,22,26,22],[29,25,29,27],[28,23,28,24],[41,0,41,1],[37,0,37,1],[37,2,37,3],[37,4,37,9],[41,2,41,3],[41,4,41,9],[39,10,39,16],[36,0,36,1],[39,17,39,19],[37,10,37,16],[37,17,37,19],[48,0,48,1],[48,2,48,3],[48,4,48,9],[47,0,47,1],[47,2,47,3],[47,4,47,9],[47,25,47,26],[48,10,48,16],[48,17,48,19],[48,20,48,22],[48,23,48,24],[46,0,46,1],[46,2,46,3],[46,4,46,9],[45,2,45,3],[45,4,45,9],[45,0,45,1],[44,0,44,1],[44,2,44,3],[44,4,44,9],[29,1,29,2],[43,0,43,1],[43,2,43,3],[43,4,43,9],[32,0,33,1],[32,2,33,3],[34,0,34,1],[34,2,34,3],[38,4,38,9],[39,0,39,1],[39,2,39,3],[39,4,39,9],[34,4,34,9],[38,2,38,3],[35,2,35,3],[36,2,36,3],[42,0,42,1],[42,2,42,3],[42,4,42,9],[36,4,36,9],[35,4,35,9],[40,0,40,1],[40,2,40,3],[40,4,40,9],[27,17,27,19],[5,0,5,30],[6,0,7,2],[6,3,7,12],[6,13,7,14],[6,15,7,16],[6,17,7,18],[6,29,7,30],[7,19,7,20],[7,21,7,22],[7,23,7,25],[7,26,7,28],[6,19,6,22],[6,23,6,28],[22,21,22,22],[22,23,22,25],[8,0,8,2],[8,3,8,12],[8,13,8,14],[9,0,9,2],[9,3,9,12],[8,15,8,16],[9,13,9,14],[12,0,12,2],[23,9,23,18],[2,0,2,11],[2,12,2,19],[3,0,3,11],[3,12,3,19],[20,0,20,2],[20,3,20,12],[19,0,19,2],[19,3,19,12],[14,0,14,2],[14,3,14,12],[14,13,14,14],[14,15,14,16],[20,13,20,14],[15,3,15,12],[18,0,18,2],[18,3,18,12],[21,0,21,2],[21,3,21,12],[20,15,20,16],[17,0,17,2],[17,3,17,12],[17,13,17,14],[21,13,21,14],[16,0,16,2],[16,3,16,12],[15,19,15,20],[11,0,11,2],[11,3,11,12],[9,15,9,16],[2,20,2,25],[3,20,3,25],[3,26,3,30],[4,0,4,30],[15,0,15,2],[9,23,9,25],[15,23,15,25],[13,19,13,20],[13,21,13,22],[11,21,11,22],[11,23,11,25],[13,0,13,2],[13,3,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[14,17,14,18],[9,17,9,18]]}
["TRAVEL AUTHORIZATION",null,null,null,null,null,null,null,"STATE OF ALASKA",null,null,null,null,null,null,null,"EMP NO.",null,null,"TRAVEL AUTH NO.",null,null,null,"TRQS NO.",null,null,null,"TAPO NO."]
["AND EXPENSE REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(empl_num=\"\",\"\",empl_num)","v":" "},null,null,{"$f":"IF(ta_num=\"\",\"\",ta_num)","v":" "},null,null,null,{"$f":"IF(TRQS<>\"\",TRQS,\" \")","v":" "},null,null,null,{"$f":"IF(TAPO=\"\",\"\",TAPO)","v":" "}]
["NAME OF TRAVELER",null,null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,"AGENCY",null,null,null,null,null,"DIVISION"]
[{"$f":"IF(trav_name=\"\",\"\",trav_name)","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trav_title=\"\",\"\",trav_title)","v":" "},null,null,null,null,null,null,null,{"$f":"IF(dept_opt=\"\",\"\",dept_opt)","v":" "},null,null,null,null,null,{"$f":"IF(div=\"\",\"\",div)","v":" "}]
["EXPENSE REPORT (CONTINUATION)"]
["ACTUAL TRAVEL, PER DIEM, AND REIMBURSABLE EXPENSES (NO PCARD CHARGES)"]
["DATE",null,null,"EXPLANATION",null,null,null,null,null,null,null,null,null,"MEALS PROV",null,"FACIL-\nITY",null,"# OF\nMILES",null,"SURFACE TRANS",null,null,null,"PER DIEM",null,null,null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILEAGE",null,"OTHER",null,"LODGING",null,null,"M&IE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A9=\"\", R9=\"\"),0,(IF(A9>=mileagedate1,ROUND(R9*mileagerate1,3),ROUND(R9*mileagerate2,3))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"TOTALS (CONTINUATION PAGE 1)",null,null,null,null,null,null,null,null,null,{"$f":"SUM(T9:W23)","v":0},null,null,null,{"$f":"SUM(X9:Z23)","v":0},null,null,{"$f":"SUM(AA9:AC23)","v":0},null,null,{"$f":"SUM(AD9:AE23)","v":0}]
["TRAVELER'S REIMBURSEMENT WARRANT"]
["FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,{"$f":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"*TAX*\",D28:F30)-SUMIF(M28:N30,\"*TAX*\",O28:Q30)-SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"NONTAX"]
[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,{"$f":"SUMIF(B28:C30,\"*TAX*\",D28:F30)+SUMIF(M28:N30,\"*TAX*\",O28:Q30)+SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"TAX"]
[7,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"A30+1","v":10},null,null,null,null,null,{"$f":"IF(M28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L30+1","v":13},null,null,null,null,null,{"$f":"IF(X28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A28+1","v":8},null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L28+1","v":11},null,null,null,null,null,{"$f":"IF(M29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W28+1","v":14},null,null,null,null,null,{"$f":"IF(X29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A29+1","v":9},null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L29+1","v":12},null,null,null,null,null,{"$f":"IF(M30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W29+1","v":15},null,null,null,null,null,{"$f":"IF(X30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
["TOTAL (CONTINUATION PAGE 1)",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":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"T ADV\",D28:F30)-SUMIF(M28:N30,\"T ADV\",O28:Q30)-SUMIF(X28:Y30,\"T ADV\",Z28:AB30)","v":0},null,null,{"$f":"SUM(U28:W31,AC28:AE30)-SUMIF(S28:T31,\"T ADV\",U28:W31)-SUMIF(AA28:AB30,\"T ADV\",AC28:AE30)","v":{"$error":"#REF!"}}]
["STATE PCARD CHARGES AND OTHER STATE PAID EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRIS TRANSACTION ID"]
["TYPE",null,"REF ID",null,"REFERENCE / \nINV NUMBER",null,null,null,null,null,"VENDOR CUST NUM / \nVENDOR DESC",null,null,null,null,null,null,"AMOUNT",null,null,"DATE PAID",null,null,"IRIS OBJECT",null,"PAGE CODE",null,"DEPT","TRANS ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,"TOTALS (CONTINUATION PAGE 1)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R35:T49)","v":0}]

{"sheet":"Continuation (2)","index":6,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":false,"merged":[[46,23,46,24],[46,28,46,30],[47,10,47,16],[47,17,47,19],[47,20,47,22],[47,23,47,24],[47,28,47,30],[48,10,48,16],[48,17,48,19],[48,20,48,22],[48,23,48,24],[48,28,48,30],[47,25,47,26],[42,23,42,24],[42,28,42,30],[43,10,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,24],[43,28,43,30],[44,10,44,16],[44,17,44,19],[44,20,44,22],[44,23,44,24],[44,28,44,30],[39,10,39,16],[39,17,39,19],[39,20,39,22],[39,23,39,24],[39,28,39,30],[40,10,40,16],[40,17,40,19],[40,20,40,22],[40,23,40,24],[40,28,40,30],[48,0,48,1],[48,2,48,3],[48,4,48,9],[48,25,48,26],[47,0,47,1],[47,2,47,3],[47,4,47,9],[49,4,49,16],[49,17,49,19],[49,20,49,30],[45,28,45,30],[46,10,46,16],[46,17,46,19],[46,20,46,22],[43,25,43,26],[44,0,44,1],[44,2,44,3],[44,4,44,9],[44,25,44,26],[43,0,43,1],[43,2,43,3],[43,4,43,9],[45,25,45,26],[46,0,46,1],[46,2,46,3],[46,4,46,9],[46,25,46,26],[45,0,45,1],[45,2,45,3],[45,4,45,9],[45,10,45,16],[45,17,45,19],[45,20,45,22],[45,23,45,24],[41,28,41,30],[42,10,42,16],[42,17,42,19],[42,20,42,22],[39,25,39,26],[40,0,40,1],[40,2,40,3],[40,4,40,9],[40,25,40,26],[39,0,39,1],[39,2,39,3],[39,4,39,9],[41,25,41,26],[42,0,42,1],[42,2,42,3],[42,4,42,9],[42,25,42,26],[41,0,41,1],[41,2,41,3],[41,4,41,9],[41,10,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,24],[38,0,38,1],[38,2,38,3],[38,4,38,9],[38,25,38,26],[37,0,37,1],[37,2,37,3],[37,4,37,9],[37,10,37,16],[37,17,37,19],[37,20,37,22],[37,23,37,24],[38,23,38,24],[36,0,36,1],[36,2,36,3],[36,4,36,9],[36,25,36,26],[35,0,35,1],[35,2,35,3],[35,4,35,9],[35,10,35,16],[35,17,35,19],[35,20,35,22],[35,23,35,24],[36,10,36,16],[36,17,36,19],[36,20,36,22],[36,23,36,24],[35,25,35,26],[32,27,33,27],[32,28,33,30],[34,10,34,16],[34,17,34,19],[34,20,34,22],[34,23,34,24],[37,28,37,30],[38,10,38,16],[38,17,38,19],[38,20,38,22],[35,28,35,30],[36,28,36,30],[37,25,37,26],[38,28,38,30],[34,28,34,30],[34,0,34,1],[34,2,34,3],[34,4,34,9],[34,25,34,26],[29,1,29,2],[29,3,29,5],[29,6,29,8],[29,12,29,13],[29,14,29,16],[29,17,29,19],[29,23,29,24],[29,25,29,27],[30,0,30,24],[30,25,30,30],[32,0,33,1],[32,2,33,3],[32,4,33,9],[32,25,33,26],[31,0,31,24],[31,25,31,30],[32,10,33,16],[32,17,33,19],[32,20,33,22],[32,23,33,24],[29,28,29,30],[27,23,27,24],[27,25,27,27],[27,28,27,30],[28,1,28,2],[28,3,28,5],[28,6,28,8],[28,12,28,13],[28,14,28,16],[28,17,28,19],[28,23,28,24],[28,25,28,27],[28,28,28,30],[22,3,22,12],[22,13,22,14],[22,15,22,16],[22,17,22,18],[22,19,22,20],[27,1,27,2],[27,3,27,5],[27,6,27,8],[27,12,27,13],[27,14,27,16],[27,17,27,19],[23,19,23,22],[22,21,22,22],[23,23,23,25],[23,26,23,28],[23,29,23,30],[24,0,24,30],[25,0,26,0],[25,1,26,2],[25,3,26,5],[25,6,26,8],[25,11,26,11],[25,12,26,13],[25,14,26,16],[25,17,26,19],[25,22,26,22],[25,23,26,24],[25,25,26,27],[25,28,26,30],[23,11,23,18],[22,23,22,25],[22,26,22,28],[20,29,20,30],[21,0,21,2],[21,3,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[21,19,21,20],[21,21,21,22],[21,23,21,25],[21,26,21,28],[21,29,21,30],[20,0,20,2],[20,3,20,12],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,22],[20,23,20,25],[20,26,20,28],[22,29,22,30],[22,0,22,2],[18,29,18,30],[19,0,19,2],[19,3,19,12],[19,13,19,14],[19,15,19,16],[19,17,19,18],[19,19,19,20],[19,21,19,22],[19,23,19,25],[19,26,19,28],[19,29,19,30],[18,0,18,2],[18,3,18,12],[18,13,18,14],[18,15,18,16],[18,17,18,18],[18,19,18,20],[18,21,18,22],[18,23,18,25],[18,26,18,28],[16,29,16,30],[17,0,17,2],[17,3,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[17,19,17,20],[17,21,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,30],[16,0,16,2],[16,3,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,25],[16,26,16,28],[14,29,14,30],[15,0,15,2],[15,3,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[15,19,15,20],[15,21,15,22],[15,23,15,25],[15,26,15,28],[15,29,15,30],[14,0,14,2],[14,3,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,25],[14,26,14,28],[12,29,12,30],[13,0,13,2],[13,3,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,30],[12,0,12,2],[12,3,12,12],[12,13,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,25],[12,26,12,28],[10,29,10,30],[11,0,11,2],[11,3,11,12],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,25],[11,26,11,28],[11,29,11,30],[10,0,10,2],[10,3,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,25],[10,26,10,28],[9,29,9,30],[8,0,8,2],[8,3,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[8,19,8,20],[8,21,8,22],[8,23,8,25],[8,26,8,28],[9,0,9,2],[9,3,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,25],[9,26,9,28],[8,29,8,30],[6,0,7,2],[6,3,7,12],[6,13,7,14],[6,15,7,16],[6,17,7,18],[6,19,6,22],[2,0,2,11],[2,12,2,19],[3,0,3,11],[3,12,3,19],[5,0,5,30],[2,20,2,25],[3,20,3,25],[3,26,3,30],[6,23,6,28],[6,29,7,30],[7,19,7,20],[7,21,7,22],[7,23,7,25],[7,26,7,28],[4,0,4,30],[0,0,0,6],[0,8,1,15],[0,16,0,18],[0,19,0,22],[0,23,0,26],[0,27,0,30],[1,0,1,6],[1,16,1,18],[1,19,1,22],[1,23,1,26],[1,27,1,30]]}
["TRAVEL AUTHORIZATION",null,null,null,null,null,null,null,"STATE OF ALASKA",null,null,null,null,null,null,null,"EMP NO.",null,null,"TRAVEL AUTH NO.",null,null,null,"TRQS NO.",null,null,null,"TAPO NO."]
["AND EXPENSE REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(empl_num=\"\",\"\",empl_num)","v":" "},null,null,{"$f":"IF(ta_num=\"\",\"\",ta_num)","v":" "},null,null,null,{"$f":"IF(TRQS<>\"\",TRQS,\" \")","v":" "},null,null,null,{"$f":"IF(TAPO=\"\",\"\",TAPO)","v":" "}]
["NAME OF TRAVELER",null,null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,"AGENCY",null,null,null,null,null,"DIVISION"]
[{"$f":"IF(trav_name=\"\",\"\",trav_name)","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trav_title=\"\",\"\",trav_title)","v":" "},null,null,null,null,null,null,null,{"$f":"IF(dept_opt=\"\",\"\",dept_opt)","v":" "},null,null,null,null,null,{"$f":"IF(div=\"\",\"\",div)","v":" "}]
["EXPENSE REPORT (CONTINUATION)"]
["ACTUAL TRAVEL, PER DIEM, AND REIMBURSABLE EXPENSES (NO PCARD CHARGES)"]
["DATE",null,null,"EXPLANATION",null,null,null,null,null,null,null,null,null,"MEALS PROV",null,"FACIL-\nITY",null,"# OF\nMILES",null,"SURFACE TRANS",null,null,null,"PER DIEM",null,null,null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILEAGE",null,"OTHER",null,"LODGING",null,null,"M&IE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A9=\"\", R9=\"\"),0,(IF(A9>=mileagedate1,ROUND(R9*mileagerate1,3),ROUND(R9*mileagerate2,3))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"TOTALS (CONTINUATION PAGE 2)",null,null,null,null,null,null,null,{"$f":"SUM(T9:W23)","v":0},null,null,null,{"$f":"SUM(X9:Z23)","v":0},null,null,{"$f":"SUM(AA9:AC23)","v":0},null,null,{"$f":"SUM(AD9:AE23)","v":0}]
["TRAVELER'S REIMBURSEMENT WARRANT"]
["FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,{"$f":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"*TAX*\",D28:F30)-SUMIF(M28:N30,\"*TAX*\",O28:Q30)-SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"NONTAX"]
[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,{"$f":"SUMIF(B28:C30,\"*TAX*\",D28:F30)+SUMIF(M28:N30,\"*TAX*\",O28:Q30)+SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"TAX"]
[16,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"A30+1","v":19},null,null,null,null,null,{"$f":"IF(M28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L30+1","v":22},null,null,null,null,null,{"$f":"IF(X28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A28+1","v":17},null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L28+1","v":20},null,null,null,null,null,{"$f":"IF(M29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W28+1","v":23},null,null,null,null,null,{"$f":"IF(X29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A29+1","v":18},null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L29+1","v":21},null,null,null,null,null,{"$f":"IF(M30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W29+1","v":24},null,null,null,null,null,{"$f":"IF(X30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
["TOTAL (CONTINUATION PAGE 2)",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":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"T ADV\",D28:F30)-SUMIF(M28:N30,\"T ADV\",O28:Q30)-SUMIF(X28:Y30,\"T ADV\",Z28:AB30)","v":0},null,null,{"$f":"SUM(U28:W31,AC28:AE30)-SUMIF(S28:T31,\"T ADV\",U28:W31)-SUMIF(AA28:AB30,\"T ADV\",AC28:AE30)","v":{"$error":"#REF!"}}]
["STATE PCARD CHARGES AND OTHER STATE PAID EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRIS TRANSACTION ID"]
["TYPE",null,"REF ID",null,"REFERENCE / \nINV NUMBER",null,null,null,null,null,"VENDOR CUST NUM / \nVENDOR DESC",null,null,null,null,null,null,"AMOUNT",null,null,"DATE PAID",null,null,"IRIS OBJECT",null,"PAGE CODE",null,"DEPT","TRANS ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,"TOTALS (CONTINUATION PAGE 2)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R35:T49)","v":0}]

{"sheet":"Continuation (3)","index":7,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,1,15],[0,16,0,18],[0,19,0,22],[0,23,0,26],[0,27,0,30],[1,0,1,6],[1,16,1,18],[5,0,5,30],[1,19,1,22],[1,23,1,26],[1,27,1,30],[4,0,4,30],[2,0,2,11],[2,12,2,19],[3,0,3,11],[3,12,3,19],[2,20,2,25],[3,20,3,25],[3,26,3,30],[6,0,7,2],[6,3,7,12],[6,13,7,14],[6,15,7,16],[6,17,7,18],[6,19,6,22],[6,23,6,28],[6,29,7,30],[7,19,7,20],[7,21,7,22],[7,23,7,25],[7,26,7,28],[8,29,8,30],[9,0,9,2],[9,3,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,25],[9,26,9,28],[9,29,9,30],[8,0,8,2],[8,3,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[8,19,8,20],[8,21,8,22],[8,23,8,25],[8,26,8,28],[10,29,10,30],[11,0,11,2],[11,3,11,12],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,25],[11,26,11,28],[11,29,11,30],[10,0,10,2],[10,3,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,25],[10,26,10,28],[12,29,12,30],[13,0,13,2],[13,3,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,30],[12,0,12,2],[12,3,12,12],[12,13,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,25],[12,26,12,28],[14,29,14,30],[15,0,15,2],[15,3,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[15,19,15,20],[15,21,15,22],[15,23,15,25],[15,26,15,28],[15,29,15,30],[14,0,14,2],[14,3,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,25],[14,26,14,28],[16,29,16,30],[17,0,17,2],[17,3,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[17,19,17,20],[17,21,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,30],[16,0,16,2],[16,3,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,25],[16,26,16,28],[18,29,18,30],[19,0,19,2],[19,3,19,12],[19,13,19,14],[19,15,19,16],[19,17,19,18],[19,19,19,20],[19,21,19,22],[19,23,19,25],[19,26,19,28],[19,29,19,30],[18,0,18,2],[18,3,18,12],[18,13,18,14],[18,15,18,16],[18,17,18,18],[18,19,18,20],[18,21,18,22],[18,23,18,25],[18,26,18,28],[22,19,22,20],[22,21,22,22],[22,23,22,25],[22,26,22,28],[20,29,20,30],[21,0,21,2],[21,3,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[21,19,21,20],[21,21,21,22],[21,23,21,25],[21,26,21,28],[21,29,21,30],[20,0,20,2],[20,3,20,12],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,22],[20,23,20,25],[20,26,20,28],[22,29,22,30],[23,11,23,18],[23,19,23,22],[23,23,23,25],[23,26,23,28],[23,29,23,30],[24,0,24,30],[25,0,26,0],[25,1,26,2],[25,3,26,5],[25,6,26,8],[25,11,26,11],[25,12,26,13],[25,14,26,16],[25,17,26,19],[25,22,26,22],[25,23,26,24],[25,25,26,27],[25,28,26,30],[22,0,22,2],[22,3,22,12],[22,13,22,14],[22,15,22,16],[22,17,22,18],[27,1,27,2],[27,3,27,5],[27,6,27,8],[27,12,27,13],[27,14,27,16],[27,17,27,19],[27,23,27,24],[27,25,27,27],[27,28,27,30],[28,1,28,2],[28,3,28,5],[28,6,28,8],[28,12,28,13],[28,14,28,16],[28,17,28,19],[28,23,28,24],[28,25,28,27],[28,28,28,30],[29,1,29,2],[29,3,29,5],[29,6,29,8],[29,12,29,13],[29,14,29,16],[29,17,29,19],[29,23,29,24],[29,25,29,27],[29,28,29,30],[30,0,30,24],[30,25,30,30],[31,0,31,24],[31,25,31,30],[32,0,33,1],[32,2,33,3],[32,4,33,9],[32,10,33,16],[32,17,33,19],[32,20,33,22],[32,23,33,24],[32,25,33,26],[32,27,33,27],[32,28,33,30],[34,0,34,1],[34,2,34,3],[34,4,34,9],[34,10,34,16],[34,17,34,19],[34,20,34,22],[34,23,34,24],[34,25,34,26],[34,28,34,30],[35,0,35,1],[35,2,35,3],[35,4,35,9],[35,10,35,16],[35,17,35,19],[35,20,35,22],[35,23,35,24],[35,25,35,26],[35,28,35,30],[36,0,36,1],[36,2,36,3],[36,4,36,9],[36,10,36,16],[36,17,36,19],[36,20,36,22],[36,23,36,24],[36,25,36,26],[36,28,36,30],[37,0,37,1],[37,2,37,3],[37,4,37,9],[37,10,37,16],[37,17,37,19],[37,20,37,22],[37,23,37,24],[37,25,37,26],[37,28,37,30],[38,23,38,24],[38,25,38,26],[38,28,38,30],[39,0,39,1],[39,2,39,3],[39,4,39,9],[39,10,39,16],[39,17,39,19],[39,20,39,22],[39,23,39,24],[38,0,38,1],[38,2,38,3],[38,4,38,9],[38,10,38,16],[38,17,38,19],[38,20,38,22],[39,25,39,26],[39,28,39,30],[40,0,40,1],[40,2,40,3],[40,4,40,9],[40,10,40,16],[40,17,40,19],[40,20,40,22],[40,23,40,24],[40,25,40,26],[40,28,40,30],[41,0,41,1],[41,2,41,3],[41,4,41,9],[41,10,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,24],[41,25,41,26],[41,28,41,30],[42,23,42,24],[42,25,42,26],[42,28,42,30],[43,0,43,1],[43,2,43,3],[43,4,43,9],[43,10,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,24],[42,0,42,1],[42,2,42,3],[42,4,42,9],[42,10,42,16],[42,17,42,19],[42,20,42,22],[43,25,43,26],[43,28,43,30],[44,0,44,1],[44,2,44,3],[44,4,44,9],[44,10,44,16],[44,17,44,19],[44,20,44,22],[44,23,44,24],[44,25,44,26],[44,28,44,30],[45,0,45,1],[45,2,45,3],[45,4,45,9],[45,10,45,16],[45,17,45,19],[45,20,45,22],[45,23,45,24],[45,25,45,26],[45,28,45,30],[46,23,46,24],[46,25,46,26],[46,28,46,30],[47,0,47,1],[47,2,47,3],[47,4,47,9],[47,10,47,16],[47,17,47,19],[47,20,47,22],[47,23,47,24],[46,0,46,1],[46,2,46,3],[46,4,46,9],[46,10,46,16],[46,17,46,19],[46,20,46,22],[48,28,48,30],[49,4,49,16],[49,17,49,19],[49,20,49,30],[47,25,47,26],[47,28,47,30],[48,0,48,1],[48,2,48,3],[48,4,48,9],[48,10,48,16],[48,17,48,19],[48,20,48,22],[48,23,48,24],[48,25,48,26]]}
["TRAVEL AUTHORIZATION",null,null,null,null,null,null,null,"STATE OF ALASKA",null,null,null,null,null,null,null,"EMP NO.",null,null,"TRAVEL AUTH NO.",null,null,null,"TRQS NO.",null,null,null,"TAPO NO."]
["AND EXPENSE REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(empl_num=\"\",\"\",empl_num)","v":" "},null,null,{"$f":"IF(ta_num=\"\",\"\",ta_num)","v":" "},null,null,null,{"$f":"IF(TRQS<>\"\",TRQS,\" \")","v":" "},null,null,null,{"$f":"IF(TAPO=\"\",\"\",TAPO)","v":" "}]
["NAME OF TRAVELER",null,null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,"AGENCY",null,null,null,null,null,"DIVISION"]
[{"$f":"IF(trav_name=\"\",\"\",trav_name)","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trav_title=\"\",\"\",trav_title)","v":" "},null,null,null,null,null,null,null,{"$f":"IF(dept_opt=\"\",\"\",dept_opt)","v":" "},null,null,null,null,null,{"$f":"IF(div=\"\",\"\",div)","v":" "}]
["EXPENSE REPORT (CONTINUATION)"]
["ACTUAL TRAVEL, PER DIEM, AND REIMBURSABLE EXPENSES (NO PCARD CHARGES)"]
["DATE",null,null,"EXPLANATION",null,null,null,null,null,null,null,null,null,"MEALS PROV",null,"FACIL-\nITY",null,"# OF\nMILES",null,"SURFACE TRANS",null,null,null,"PER DIEM",null,null,null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILEAGE",null,"OTHER",null,"LODGING",null,null,"M&IE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A9=\"\", R9=\"\"),0,(IF(A9>=mileagedate1,ROUND(R9*mileagerate1,3),ROUND(R9*mileagerate2,3))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"TOTALS (CONTINUATION PAGE 3)",null,null,null,null,null,null,null,{"$f":"SUM(T9:W23)","v":0},null,null,null,{"$f":"SUM(X9:Z23)","v":0},null,null,{"$f":"SUM(AA9:AC23)","v":0},null,null,{"$f":"SUM(AD9:AE23)","v":0}]
["TRAVELER'S REIMBURSEMENT WARRANT"]
["FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,{"$f":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"*TAX*\",D28:F30)-SUMIF(M28:N30,\"*TAX*\",O28:Q30)-SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"NONTAX"]
[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,{"$f":"SUMIF(B28:C30,\"*TAX*\",D28:F30)+SUMIF(M28:N30,\"*TAX*\",O28:Q30)+SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"TAX"]
[25,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"A30+1","v":28},null,null,null,null,null,{"$f":"IF(M28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L30+1","v":31},null,null,null,null,null,{"$f":"IF(X28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A28+1","v":26},null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L28+1","v":29},null,null,null,null,null,{"$f":"IF(M29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W28+1","v":32},null,null,null,null,null,{"$f":"IF(X29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A29+1","v":27},null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L29+1","v":30},null,null,null,null,null,{"$f":"IF(M30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W29+1","v":33},null,null,null,null,null,{"$f":"IF(X30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
["TOTAL (CONTINUATION PAGE 3)",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":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"T ADV\",D28:F30)-SUMIF(M28:N30,\"T ADV\",O28:Q30)-SUMIF(X28:Y30,\"T ADV\",Z28:AB30)","v":0},null,null,{"$f":"SUM(U28:W31,AC28:AE30)-SUMIF(S28:T31,\"T ADV\",U28:W31)-SUMIF(AA28:AB30,\"T ADV\",AC28:AE30)","v":{"$error":"#REF!"}}]
["STATE PCARD CHARGES AND OTHER STATE PAID EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRIS TRANSACTION ID"]
["TYPE",null,"REF ID",null,"REFERENCE / \nINV NUMBER",null,null,null,null,null,"VENDOR CUST NUM / \nVENDOR DESC",null,null,null,null,null,null,"AMOUNT",null,null,"DATE PAID",null,null,"IRIS OBJECT",null,"PAGE CODE",null,"DEPT","TRANS ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,"TOTALS (CONTINUATION PAGE 3)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R35:T49)","v":0}]

{"sheet":"Continuation (4)","index":8,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,1,15],[0,16,0,18],[0,19,0,22],[0,23,0,26],[0,27,0,30],[1,0,1,6],[1,16,1,18],[5,0,5,30],[1,19,1,22],[1,23,1,26],[1,27,1,30],[4,0,4,30],[2,0,2,11],[2,12,2,19],[3,0,3,11],[3,12,3,19],[2,20,2,25],[3,20,3,25],[3,26,3,30],[6,0,7,2],[6,3,7,12],[6,13,7,14],[6,15,7,16],[6,17,7,18],[6,19,6,22],[6,23,6,28],[6,29,7,30],[7,19,7,20],[7,21,7,22],[7,23,7,25],[7,26,7,28],[8,29,8,30],[9,0,9,2],[9,3,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,25],[9,26,9,28],[9,29,9,30],[8,0,8,2],[8,3,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[8,19,8,20],[8,21,8,22],[8,23,8,25],[8,26,8,28],[10,29,10,30],[11,0,11,2],[11,3,11,12],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,25],[11,26,11,28],[11,29,11,30],[10,0,10,2],[10,3,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,25],[10,26,10,28],[12,29,12,30],[13,0,13,2],[13,3,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,30],[12,0,12,2],[12,3,12,12],[12,13,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,25],[12,26,12,28],[14,29,14,30],[15,0,15,2],[15,3,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[15,19,15,20],[15,21,15,22],[15,23,15,25],[15,26,15,28],[15,29,15,30],[14,0,14,2],[14,3,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,25],[14,26,14,28],[16,29,16,30],[17,0,17,2],[17,3,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[17,19,17,20],[17,21,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,30],[16,0,16,2],[16,3,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,25],[16,26,16,28],[18,29,18,30],[19,0,19,2],[19,3,19,12],[19,13,19,14],[19,15,19,16],[19,17,19,18],[19,19,19,20],[19,21,19,22],[19,23,19,25],[19,26,19,28],[19,29,19,30],[18,0,18,2],[18,3,18,12],[18,13,18,14],[18,15,18,16],[18,17,18,18],[18,19,18,20],[18,21,18,22],[18,23,18,25],[18,26,18,28],[22,19,22,20],[22,21,22,22],[22,23,22,25],[22,26,22,28],[20,29,20,30],[21,0,21,2],[21,3,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[21,19,21,20],[21,21,21,22],[21,23,21,25],[21,26,21,28],[21,29,21,30],[20,0,20,2],[20,3,20,12],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,22],[20,23,20,25],[20,26,20,28],[22,29,22,30],[23,11,23,18],[23,19,23,22],[23,23,23,25],[23,26,23,28],[23,29,23,30],[24,0,24,30],[25,0,26,0],[25,1,26,2],[25,3,26,5],[25,6,26,8],[25,11,26,11],[25,12,26,13],[25,14,26,16],[25,17,26,19],[25,22,26,22],[25,23,26,24],[25,25,26,27],[25,28,26,30],[22,0,22,2],[22,3,22,12],[22,13,22,14],[22,15,22,16],[22,17,22,18],[27,1,27,2],[27,3,27,5],[27,6,27,8],[27,12,27,13],[27,14,27,16],[27,17,27,19],[27,23,27,24],[27,25,27,27],[27,28,27,30],[28,1,28,2],[28,3,28,5],[28,6,28,8],[28,12,28,13],[28,14,28,16],[28,17,28,19],[28,23,28,24],[28,25,28,27],[28,28,28,30],[29,1,29,2],[29,3,29,5],[29,6,29,8],[29,12,29,13],[29,14,29,16],[29,17,29,19],[29,23,29,24],[29,25,29,27],[29,28,29,30],[30,0,30,24],[30,25,30,30],[31,0,31,24],[31,25,31,30],[32,0,33,1],[32,2,33,3],[32,4,33,9],[32,10,33,16],[32,17,33,19],[32,20,33,22],[32,23,33,24],[32,25,33,26],[32,27,33,27],[32,28,33,30],[34,0,34,1],[34,2,34,3],[34,4,34,9],[34,10,34,16],[34,17,34,19],[34,20,34,22],[34,23,34,24],[34,25,34,26],[34,28,34,30],[35,0,35,1],[35,2,35,3],[35,4,35,9],[35,10,35,16],[35,17,35,19],[35,20,35,22],[35,23,35,24],[35,25,35,26],[35,28,35,30],[36,0,36,1],[36,2,36,3],[36,4,36,9],[36,10,36,16],[36,17,36,19],[36,20,36,22],[36,23,36,24],[36,25,36,26],[36,28,36,30],[37,0,37,1],[37,2,37,3],[37,4,37,9],[37,10,37,16],[37,17,37,19],[37,20,37,22],[37,23,37,24],[37,25,37,26],[37,28,37,30],[38,23,38,24],[38,25,38,26],[38,28,38,30],[39,0,39,1],[39,2,39,3],[39,4,39,9],[39,10,39,16],[39,17,39,19],[39,20,39,22],[39,23,39,24],[38,0,38,1],[38,2,38,3],[38,4,38,9],[38,10,38,16],[38,17,38,19],[38,20,38,22],[39,25,39,26],[39,28,39,30],[40,0,40,1],[40,2,40,3],[40,4,40,9],[40,10,40,16],[40,17,40,19],[40,20,40,22],[40,23,40,24],[40,25,40,26],[40,28,40,30],[41,0,41,1],[41,2,41,3],[41,4,41,9],[41,10,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,24],[41,25,41,26],[41,28,41,30],[42,23,42,24],[42,25,42,26],[42,28,42,30],[43,0,43,1],[43,2,43,3],[43,4,43,9],[43,10,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,24],[42,0,42,1],[42,2,42,3],[42,4,42,9],[42,10,42,16],[42,17,42,19],[42,20,42,22],[43,25,43,26],[43,28,43,30],[44,0,44,1],[44,2,44,3],[44,4,44,9],[44,10,44,16],[44,17,44,19],[44,20,44,22],[44,23,44,24],[44,25,44,26],[44,28,44,30],[45,0,45,1],[45,2,45,3],[45,4,45,9],[45,10,45,16],[45,17,45,19],[45,20,45,22],[45,23,45,24],[45,25,45,26],[45,28,45,30],[46,23,46,24],[46,25,46,26],[46,28,46,30],[47,0,47,1],[47,2,47,3],[47,4,47,9],[47,10,47,16],[47,17,47,19],[47,20,47,22],[47,23,47,24],[46,0,46,1],[46,2,46,3],[46,4,46,9],[46,10,46,16],[46,17,46,19],[46,20,46,22],[48,28,48,30],[49,4,49,16],[49,17,49,19],[49,20,49,30],[47,25,47,26],[47,28,47,30],[48,0,48,1],[48,2,48,3],[48,4,48,9],[48,10,48,16],[48,17,48,19],[48,20,48,22],[48,23,48,24],[48,25,48,26]]}
["TRAVEL AUTHORIZATION",null,null,null,null,null,null,null,"STATE OF ALASKA",null,null,null,null,null,null,null,"EMP NO.",null,null,"TRAVEL AUTH NO.",null,null,null,"TRQS NO.",null,null,null,"TAPO NO."]
["AND EXPENSE REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(empl_num=\"\",\"\",empl_num)","v":" "},null,null,{"$f":"IF(ta_num=\"\",\"\",ta_num)","v":" "},null,null,null,{"$f":"IF(TRQS<>\"\",TRQS,\" \")","v":" "},null,null,null,{"$f":"IF(TAPO=\"\",\"\",TAPO)","v":" "}]
["NAME OF TRAVELER",null,null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,"AGENCY",null,null,null,null,null,"DIVISION"]
[{"$f":"IF(trav_name=\"\",\"\",trav_name)","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trav_title=\"\",\"\",trav_title)","v":" "},null,null,null,null,null,null,null,{"$f":"IF(dept_opt=\"\",\"\",dept_opt)","v":" "},null,null,null,null,null,{"$f":"IF(div=\"\",\"\",div)","v":" "}]
["EXPENSE REPORT (CONTINUATION)"]
["ACTUAL TRAVEL, PER DIEM, AND REIMBURSABLE EXPENSES (NO PCARD CHARGES)"]
["DATE",null,null,"EXPLANATION",null,null,null,null,null,null,null,null,null,"MEALS PROV",null,"FACIL-\nITY",null,"# OF\nMILES",null,"SURFACE TRANS",null,null,null,"PER DIEM",null,null,null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILEAGE",null,"OTHER",null,"LODGING",null,null,"M&IE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A9=\"\", R9=\"\"),0,(IF(A9>=mileagedate1,ROUND(R9*mileagerate1,3),ROUND(R9*mileagerate2,3))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"TOTALS (CONTINUATION PAGE 4)",null,null,null,null,null,null,null,{"$f":"SUM(T9:W23)","v":0},null,null,null,{"$f":"SUM(X9:Z23)","v":0},null,null,{"$f":"SUM(AA9:AC23)","v":0},null,null,{"$f":"SUM(AD9:AE23)","v":0}]
["TRAVELER'S REIMBURSEMENT WARRANT"]
["FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,{"$f":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"*TAX*\",D28:F30)-SUMIF(M28:N30,\"*TAX*\",O28:Q30)-SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"NONTAX"]
[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,{"$f":"SUMIF(B28:C30,\"*TAX*\",D28:F30)+SUMIF(M28:N30,\"*TAX*\",O28:Q30)+SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"TAX"]
[34,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"A30+1","v":37},null,null,null,null,null,{"$f":"IF(M28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L30+1","v":40},null,null,null,null,null,{"$f":"IF(X28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A28+1","v":35},null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L28+1","v":38},null,null,null,null,null,{"$f":"IF(M29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W28+1","v":41},null,null,null,null,null,{"$f":"IF(X29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A29+1","v":36},null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L29+1","v":39},null,null,null,null,null,{"$f":"IF(M30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W29+1","v":42},null,null,null,null,null,{"$f":"IF(X30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
["TOTAL (CONTINUATION PAGE 4)",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":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"T ADV\",D28:F30)-SUMIF(M28:N30,\"T ADV\",O28:Q30)-SUMIF(X28:Y30,\"T ADV\",Z28:AB30)","v":0},null,null,{"$f":"SUM(U28:W31,AC28:AE30)-SUMIF(S28:T31,\"T ADV\",U28:W31)-SUMIF(AA28:AB30,\"T ADV\",AC28:AE30)","v":{"$error":"#REF!"}}]
["STATE PCARD CHARGES AND OTHER STATE PAID EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRIS TRANSACTION ID"]
["TYPE",null,"REF ID",null,"REFERENCE / \nINV NUMBER",null,null,null,null,null,"VENDOR CUST NUM / \nVENDOR DESC",null,null,null,null,null,null,"AMOUNT",null,null,"DATE PAID",null,null,"IRIS OBJECT",null,"PAGE CODE",null,"DEPT","TRANS ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,"TOTALS (CONTINUATION PAGE 4)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R35:T49)","v":0}]

{"sheet":"Continuation (5)","index":9,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,1,15],[0,16,0,18],[0,19,0,22],[0,23,0,26],[0,27,0,30],[1,0,1,6],[1,16,1,18],[5,0,5,30],[1,19,1,22],[1,23,1,26],[1,27,1,30],[4,0,4,30],[2,0,2,11],[2,12,2,19],[3,0,3,11],[3,12,3,19],[2,20,2,25],[3,20,3,25],[3,26,3,30],[6,0,7,2],[6,3,7,12],[6,13,7,14],[6,15,7,16],[6,17,7,18],[6,19,6,22],[6,23,6,28],[6,29,7,30],[7,19,7,20],[7,21,7,22],[7,23,7,25],[7,26,7,28],[8,29,8,30],[9,0,9,2],[9,3,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,25],[9,26,9,28],[9,29,9,30],[8,0,8,2],[8,3,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[8,19,8,20],[8,21,8,22],[8,23,8,25],[8,26,8,28],[10,29,10,30],[11,0,11,2],[11,3,11,12],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,25],[11,26,11,28],[11,29,11,30],[10,0,10,2],[10,3,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,25],[10,26,10,28],[12,29,12,30],[13,0,13,2],[13,3,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,30],[12,0,12,2],[12,3,12,12],[12,13,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,25],[12,26,12,28],[14,29,14,30],[15,0,15,2],[15,3,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[15,19,15,20],[15,21,15,22],[15,23,15,25],[15,26,15,28],[15,29,15,30],[14,0,14,2],[14,3,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,25],[14,26,14,28],[16,29,16,30],[17,0,17,2],[17,3,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[17,19,17,20],[17,21,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,30],[16,0,16,2],[16,3,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,25],[16,26,16,28],[18,29,18,30],[19,0,19,2],[19,3,19,12],[19,13,19,14],[19,15,19,16],[19,17,19,18],[19,19,19,20],[19,21,19,22],[19,23,19,25],[19,26,19,28],[19,29,19,30],[18,0,18,2],[18,3,18,12],[18,13,18,14],[18,15,18,16],[18,17,18,18],[18,19,18,20],[18,21,18,22],[18,23,18,25],[18,26,18,28],[22,19,22,20],[22,21,22,22],[22,23,22,25],[22,26,22,28],[20,29,20,30],[21,0,21,2],[21,3,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[21,19,21,20],[21,21,21,22],[21,23,21,25],[21,26,21,28],[21,29,21,30],[20,0,20,2],[20,3,20,12],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,22],[20,23,20,25],[20,26,20,28],[22,29,22,30],[23,11,23,18],[23,19,23,22],[23,23,23,25],[23,26,23,28],[23,29,23,30],[24,0,24,30],[25,0,26,0],[25,1,26,2],[25,3,26,5],[25,6,26,8],[25,11,26,11],[25,12,26,13],[25,14,26,16],[25,17,26,19],[25,22,26,22],[25,23,26,24],[25,25,26,27],[25,28,26,30],[22,0,22,2],[22,3,22,12],[22,13,22,14],[22,15,22,16],[22,17,22,18],[27,1,27,2],[27,3,27,5],[27,6,27,8],[27,12,27,13],[27,14,27,16],[27,17,27,19],[27,23,27,24],[27,25,27,27],[27,28,27,30],[28,1,28,2],[28,3,28,5],[28,6,28,8],[28,12,28,13],[28,14,28,16],[28,17,28,19],[28,23,28,24],[28,25,28,27],[28,28,28,30],[29,1,29,2],[29,3,29,5],[29,6,29,8],[29,12,29,13],[29,14,29,16],[29,17,29,19],[29,23,29,24],[29,25,29,27],[29,28,29,30],[30,0,30,24],[30,25,30,30],[31,0,31,24],[31,25,31,30],[32,0,33,1],[32,2,33,3],[32,4,33,9],[32,10,33,16],[32,17,33,19],[32,20,33,22],[32,23,33,24],[32,25,33,26],[32,27,33,27],[32,28,33,30],[34,0,34,1],[34,2,34,3],[34,4,34,9],[34,10,34,16],[34,17,34,19],[34,20,34,22],[34,23,34,24],[34,25,34,26],[34,28,34,30],[35,0,35,1],[35,2,35,3],[35,4,35,9],[35,10,35,16],[35,17,35,19],[35,20,35,22],[35,23,35,24],[35,25,35,26],[35,28,35,30],[36,0,36,1],[36,2,36,3],[36,4,36,9],[36,10,36,16],[36,17,36,19],[36,20,36,22],[36,23,36,24],[36,25,36,26],[36,28,36,30],[37,0,37,1],[37,2,37,3],[37,4,37,9],[37,10,37,16],[37,17,37,19],[37,20,37,22],[37,23,37,24],[37,25,37,26],[37,28,37,30],[38,23,38,24],[38,25,38,26],[38,28,38,30],[39,0,39,1],[39,2,39,3],[39,4,39,9],[39,10,39,16],[39,17,39,19],[39,20,39,22],[39,23,39,24],[38,0,38,1],[38,2,38,3],[38,4,38,9],[38,10,38,16],[38,17,38,19],[38,20,38,22],[39,25,39,26],[39,28,39,30],[40,0,40,1],[40,2,40,3],[40,4,40,9],[40,10,40,16],[40,17,40,19],[40,20,40,22],[40,23,40,24],[40,25,40,26],[40,28,40,30],[41,0,41,1],[41,2,41,3],[41,4,41,9],[41,10,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,24],[41,25,41,26],[41,28,41,30],[42,23,42,24],[42,25,42,26],[42,28,42,30],[43,0,43,1],[43,2,43,3],[43,4,43,9],[43,10,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,24],[42,0,42,1],[42,2,42,3],[42,4,42,9],[42,10,42,16],[42,17,42,19],[42,20,42,22],[43,25,43,26],[43,28,43,30],[44,0,44,1],[44,2,44,3],[44,4,44,9],[44,10,44,16],[44,17,44,19],[44,20,44,22],[44,23,44,24],[44,25,44,26],[44,28,44,30],[45,0,45,1],[45,2,45,3],[45,4,45,9],[45,10,45,16],[45,17,45,19],[45,20,45,22],[45,23,45,24],[45,25,45,26],[45,28,45,30],[46,23,46,24],[46,25,46,26],[46,28,46,30],[47,0,47,1],[47,2,47,3],[47,4,47,9],[47,10,47,16],[47,17,47,19],[47,20,47,22],[47,23,47,24],[46,0,46,1],[46,2,46,3],[46,4,46,9],[46,10,46,16],[46,17,46,19],[46,20,46,22],[48,28,48,30],[49,4,49,16],[49,17,49,19],[49,20,49,30],[47,25,47,26],[47,28,47,30],[48,0,48,1],[48,2,48,3],[48,4,48,9],[48,10,48,16],[48,17,48,19],[48,20,48,22],[48,23,48,24],[48,25,48,26]]}
["TRAVEL AUTHORIZATION",null,null,null,null,null,null,null,"STATE OF ALASKA",null,null,null,null,null,null,null,"EMP NO.",null,null,"TRAVEL AUTH NO.",null,null,null,"TRQS NO.",null,null,null,"TAPO NO."]
["AND EXPENSE REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(empl_num=\"\",\"\",empl_num)","v":" "},null,null,{"$f":"IF(ta_num=\"\",\"\",ta_num)","v":" "},null,null,null,{"$f":"IF(TRQS<>\"\",TRQS,\" \")","v":" "},null,null,null,{"$f":"IF(TAPO=\"\",\"\",TAPO)","v":" "}]
["NAME OF TRAVELER",null,null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,"AGENCY",null,null,null,null,null,"DIVISION"]
[{"$f":"IF(trav_name=\"\",\"\",trav_name)","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(trav_title=\"\",\"\",trav_title)","v":" "},null,null,null,null,null,null,null,{"$f":"IF(dept_opt=\"\",\"\",dept_opt)","v":" "},null,null,null,null,null,{"$f":"IF(div=\"\",\"\",div)","v":" "}]
["EXPENSE REPORT (CONTINUATION)"]
["ACTUAL TRAVEL, PER DIEM, AND REIMBURSABLE EXPENSES (NO PCARD CHARGES)"]
["DATE",null,null,"EXPLANATION",null,null,null,null,null,null,null,null,null,"MEALS PROV",null,"FACIL-\nITY",null,"# OF\nMILES",null,"SURFACE TRANS",null,null,null,"PER DIEM",null,null,null,null,null,"OTHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILEAGE",null,"OTHER",null,"LODGING",null,null,"M&IE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A9=\"\", R9=\"\"),0,(IF(A9>=mileagedate1,ROUND(R9*mileagerate1,3),ROUND(R9*mileagerate2,3))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"TOTALS (CONTINUATION PAGE 4)",null,null,null,null,null,null,null,{"$f":"SUM(T9:W23)","v":0},null,null,null,{"$f":"SUM(X9:Z23)","v":0},null,null,{"$f":"SUM(AA9:AC23)","v":0},null,null,{"$f":"SUM(AD9:AE23)","v":0}]
["TRAVELER'S REIMBURSEMENT WARRANT"]
["FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,"FIN","TYPE",null,"AMOUNT",null,null,"IRIS OBJECT",null,null,null,null,{"$f":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"*TAX*\",D28:F30)-SUMIF(M28:N30,\"*TAX*\",O28:Q30)-SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"NONTAX"]
[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,{"$f":"SUMIF(B28:C30,\"*TAX*\",D28:F30)+SUMIF(M28:N30,\"*TAX*\",O28:Q30)+SUMIF(X28:Y30,\"*TAX*\",Z28:AB30)","v":0},"TAX"]
[43,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"A30+1","v":46},null,null,null,null,null,{"$f":"IF(M28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L30+1","v":49},null,null,null,null,null,{"$f":"IF(X28=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X28,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A28+1","v":44},null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L28+1","v":47},null,null,null,null,null,{"$f":"IF(M29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W28+1","v":50},null,null,null,null,null,{"$f":"IF(X29=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X29,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
[{"$f":"A29+1","v":45},null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(B30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"L29+1","v":48},null,null,null,null,null,{"$f":"IF(M30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(M30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,null,{"$f":"W29+1","v":51},null,null,null,null,null,{"$f":"IF(X30=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP(X30,TYP_AC_TRAV,5,FALSE))))))))","v":""},{"$error":"#REF!"}]
["TOTAL (CONTINUATION PAGE 4)",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":"SUM(D28:F30,O28:Q30,Z28:AB30)-SUMIF(B28:C30,\"T ADV\",D28:F30)-SUMIF(M28:N30,\"T ADV\",O28:Q30)-SUMIF(X28:Y30,\"T ADV\",Z28:AB30)","v":0},null,null,{"$f":"SUM(U28:W31,AC28:AE30)-SUMIF(S28:T31,\"T ADV\",U28:W31)-SUMIF(AA28:AB30,\"T ADV\",AC28:AE30)","v":{"$error":"#REF!"}}]
["STATE PCARD CHARGES AND OTHER STATE PAID EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRIS TRANSACTION ID"]
["TYPE",null,"REF ID",null,"REFERENCE / \nINV NUMBER",null,null,null,null,null,"VENDOR CUST NUM / \nVENDOR DESC",null,null,null,null,null,null,"AMOUNT",null,null,"DATE PAID",null,null,"IRIS OBJECT",null,"PAGE CODE",null,"DEPT","TRANS ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",IF(AND(trav_typ=\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,2,FALSE),(IF(AND(trav_typ=\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,3,FALSE),IF(AND(trav_typ<>\"State Employee\",dest_typ=\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,4,FALSE),(IF(AND(trav_typ<>\"State Employee\",dest_typ<>\"In-State\"),VLOOKUP($A35,TYP_AC_STATE,5,FALSE))))))))","v":""},{"$error":"#REF!"},null,null,{"$f":"IF(trDept=\"\",VLOOKUP(dept_opt,dept_lookup2,2,FALSE),VLOOKUP(trDept,dept_lookup,3,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$error":"#REF!"},null,null,{"$error":"#N/A"}]
[null,null,null,null,"TOTALS (CONTINUATION PAGE 5)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R35:T49)","v":0}]

{"sheet":"Instructions for TR","index":10,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Request for Travel Authorization and Booking Form Field Matrix and Instructions"]
[]
[null,"Field Name","Instructions","Source","Required to send Email Request?","Printed in email message?"]
[null,"TRAVELER INFORMATION (* FIELDS ARE POPULATED FROM THE TRAVELER INFORMATION WORKSHEET TAB)"]
[null,"TRAVEL AUTH NO.","Enter the travel authorization number for this request if known (not required).","Travel Request","No","Yes"]
[null,"TRQS NO.","Enter the TRQS transaction number from IRIS FIN.","Travel Request","No","No"]
[null,"TAPO NO.","TAPO (Travel Purchase Order) transaction ID from IRIS FIN. ","Travel Request","No","Yes"]
[null,"TRAVELER'S LEGAL NAME *","The traveler's legal name as indicated on the government issued ID that will be used for travel. ","Traveler Information","Yes","Yes"]
[null,"DATE OF BIRTH","Enter the traveler's date of birth, this information is needed if booking travel for travelers who do not have a traveler profile and are booking using a generic profile.","Traveler Information","No","No"]
[null,"EMPL NUM *","The traveler's six-digit Employee Number. ","Traveler Information","No","Yes"]
[null,"GENDER","Enter the traveler's gender, this information is needed if booking travel for travelers who do not have a traveler profile and are booking using a generic profile.","Traveler Information","No","No"]
[null,"PHONE NO. *","The traveler's phone number for contact while in travel status.","Traveler Information","No","No"]
[null,"AGENCY *","The traveler's agency (department) from the drop-down list. If the traveler is not a state employee, use \"SECTION\", or \"PURPOSE OF TRIP\", to enter the agency or company that employs the traveler. ","Traveler Information","Yes","Yes"]
[null,"DIVISION *","The traveler's division/agency information.","Traveler Information","No","Yes"]
[null,"SECTION *","The traveler's section (sub-division) information. (See AGENCY information regarding non-employees.) ","Traveler Information","No","Yes"]
[null,"JOB TITLE *","The traveler's position/job title. ","Traveler Information","No","Yes"]
[null,"DOES TRAVELER HAVE AN E-TRAVEL PROFILE? IF NO, PLEASE PROVIDE GENERIC TRAVEL PROFILE TO BE USED FOR BOOKING. *","Whether the traveler has a profile in E-Travel, if no you must provide the name of the generic travel profile to be used.","Traveler Information","No","No"]
[null,"PERSONAL PHYSICAL ADDRESS *","The traveler's personal physical address.","Traveler Information","No","No"]
[null,"BARGAINING UNIT *","The traveler's bargaining unit. Select NA-Non-Employee for travelers who are not state employees.","Traveler Information","No","No"]
[null,"DUTY STATION *","The traveler's duty station.","Traveler Information","No","No"]
[]
[null,"ITINERARY"]
[null,"FROM","Enter the city from which the traveler is departing (the city in which travel begins). If the city is not in Alaska, include the state abbreviation. ","Travel Request","Yes","Yes"]
[null,"DEPARTURE DATE","Enter the actual departure date that is being requested. NOTE: If personal deviation is requested, this date may reflect a departure date that is for a personal deviation. ","Travel Request","Yes","Yes"]
[null,"TO (DESTINATION)","Enter the primary destination city for the travel request. If the destination city is not in Alaska, include the state abbreviation. ","Travel Request","Yes","Yes"]
[null,"RETURN DATE","Enter the actual date that the traveler will be returning to their duty station (the day travel concludes). NOTE: If personal deviation is requested, this date may reflect a return date that reflects a personal deviation. ","Travel Request","Yes","Yes"]
[null,"PURPOSE OF TRIP","Provide a brief description of the purpose and business need for the trip. Do not use acronyms. If the traveler is someone who will have their travel costs reported in the annual Executive Compensation and Travel Report, make sure to provide as much detail as required. (See AGENCY information regarding non-employees.) ","Travel Request","Yes","Yes"]
[null,"ESTIMATED COST","Enter the total estimated state cost of travel, including traveler reimbursements, based on the requested itinerary.","Travel Request","No","Yes - If completed in TR."]
[null,"CARD ACCT TYPE","Select \"ONE CARD\" or \"CTS\".","Travel Request","No","No"]
[null,"LAST FOUR DIGITS","Enter the last four digits of the card account number.","Travel Request","No","No"]
[null,"EXECUTIVE TRAVEL and TYPE OF TRAVEL [IF YES]","Select \"Yes\" if request is for an executive employee whose travel is reported in the State of Alaska Compensation and Travel Report. Select the type of travel from the check-box options.","Travel Request","No","No"]
[null,"SHOULD ITINERARY MATCH OTHER TRAVELERS?","Select the response that is accurate for this travel request. If it is known that more than one department employee will be attending the same function, even if they are in different divisions or sections, select \"Yes\". Add any relevant details for matching your itinerary with other traveler(s).","Travel Request","No","Yes - If \"Yes\" is selected, \"This is part of a group request.\" will be included in the email request in the \"Other Information\" section."]
[null,"ACTUALS REQUESTED","Only for members of the LTC bargaining unit. Select \"Yes\" if the traveler would  like to be reimbursed for actual expenses rather than receive a daily allowance.","Travel Request","No","Yes - If \"Yes\" is selected, \"Requesting Actuals\" will be identified in the \"Other Information\" section."]
[null,"MEALS PROVIDED","Will any meals be provided during the trip? If so, provide additional detail in the \"COMMENTS\" box (Requested Arrangements/Itinerary section), or as an attachment. If travel is for a conference or training, the agenda should be reviewed to determine if meals will be provided as part of the event cost. Refer to the Alaska Administrative Manual (AAM) travel section for specific instruction for meal reimbursement. ","Travel Request","No","No"]
[null,"THIRD PARTY PAYER","If a third party is paying for all or some of the requested travel, select the \"Yes\" response. ","Travel Request","No","Yes - If \"Yes\" is selected, \"Third Party Payer\" is included in the email message in the \"Other Information\" section. Additionally, if \"Yes\" was selected in this field, data entry is required in NAME/COMMENTS."]
[null,"NAME/COMMENTS","Provide the name of the third party and any other pertinent information, e.g. percentage paid.","Travel Request","Yes - If \"Yes\" is selected in Field 17, then data is required in this field.","Yes – If THIRD PARTY PAYER response is “Yes”, the data entered in this field is included in the email message in the “Other Information” section. "]
[]
[null,"FINANCIAL CODING"]
[null,"# OF CODING SPLITS","You may select up to ten splits for financial coding. Your selection will unhide the appropriate number of text entry boxes.","Travel Request","No","Yes"]
[null,"FINANCIAL CODING SPLIT(S) 1 - 10","Enter the financial coding to which the travel is to be charged.\n\nRequired IRIS Elements - Percentage and Accounting Template OR Fund-Unit-Appr Unit\nOptional IRIS Elements - Detail Accounting elements","Travel Request","No","Yes"]
[]
[null,"PERSONAL TRAVEL"]
[null,"REQUEST INCLUDES PERSONAL TRAVEL","Select the response that is accurate for this travel request. Any travel request that is beyond the minimum business itinerary is considered to be a deviated travel request. If \"Yes\" is selected, one of the deviation descriptions in PERSONAL DEVIATION TYPE must be selected, and \"STATE AUTHORIZED TRAVEL (DATES, TIMES, DESTINATION, REQUESTED LEAVE) is required. ","Travel Request","No","Yes - If \"Yes\" is selected, \"Personal Travel\" will be indicated."]
[null,"PERSONAL DEVIATION TYPE","Select the type of personal deviation being requested.  ","Travel Request","Yes - If \"Yes\" was selected in REQUEST INCLUDES PERSONAL TRAVEL.","Yes - If \"Yes\" was selected in PERSONAL DEVIATION TYPE, the description (type) of deviation is included in the email message in the \"Personal Travel\" section."]
[null,"STATE AUTHORIZED TRAVEL (DATES, TIMES, DESTINATION, REQUESTED LEAVE)","Minimum Business Itinerary (MBI) Details - Date MBI Begins and Ends, State Authorized Airfare/MBI Quote, and any other notes related to request. The State is responsible for the MBI costs, and will reimburse the lesser of either the MBI or the actual cost of the required travel services. Any additional costs resulting from the personal deviation are the responsibility of the traveler. ","Travel Request","No","Yes"]
[]
[null,"REQUESTED ARRANGEMENTS/ITINERARY"]
[null,"Will the traveler be attending a conference or training?"]
[null,"CONFERENCE NAME/CLASS TITLE","Enter the name of the conference or of the training class that you will be attending. ","Travel Request","Yes - If \"Attending Conference or Training\" is selected.","Yes - The CONFERENCE NAME/CLASS TITLE of the event is included in the \"Other Information\" section."]
[null,"HOTEL CONFERENCE # or NIGHTLY RATE","If a special conference rate is being provided by the hotel, provide detail information here.","Travel Request","No","No"]
[null,"SHUTTLE PROVIDED?","Is a shuttle provided by the conference hotel? Select response (Yes or No) from the drop-down list.","Travel Request","No","No"]
[null,"PRESENTER?","Will you be a formal presenter at the conference or training? Select response from the drop-down list (Yes or No).","Travel Request","No","Yes - If \"Yes\" is selected, \"Presenting Training: Class Title.\" will be included in the email request in the \"Other Information\" section. If \"No\" is selected, \"Attending Training: Class Title\" is displayed in the \"Other Information\" section of the email. "]
[null,"COMMENTS","Enter information regarding the class or conference that would be useful to the person with the delegated authority to approve the travel request.  ","Travel Request","No","No"]
[null,"Will the traveler be requesting a travel advance from SSoA?"]
[null,"TRAVEL ADVANCE NOTICE","If the check-box for \"REQUESTING TRAVEL ADVANCE\" is selected, this informational text displays. ","Travel Request","No","Yes - If checkbox is selected, \"Requesting Travel Advance\" is displayed in the \"Other Information\" section of the email message."]
[null,"Does itinerary include Air Travel?"]
[null,"IS A REFUNDABLE TICKET REQUIRED?","Select \"Yes\" if a refundable ticket is required.","Travel Request","No","No"]
[null,"FROM","Indicate the departure city or airport code for the travel request.","Travel Request","No","No"]
[null,"DEPART ","Enter the date of departure.","Travel Request","No","No"]
[null,"TIME/FLIGHT","If desired, the traveler may request a specific flight number or a general time. Example: \"AS75\", or \"Early Morning\"","Travel Request","No","No"]
[null,"TO  ","Traveler will indicate the airport code or the name of the city that they will be traveling to. Example: \"Seattle, WA\", or \"SEA\"","Travel Request","No","No"]
[null,"ARRIVE","Enter the date of arrival for the flight.","Travel Request","No","No"]
[null,"TIME ","Traveler may request to arrive by a specific time or at a general time of day.","Travel Request","No","No"]
[null,"Does itinerary include a Hotel Booking?"]
[null,"CITY","Traveler indicates the city in which they are requesting a hotel.","Travel Request","No","No"]
[null,"HOTEL/LOCATION","Traveler may select a specific hotel or a general location (downtown, near the airport) where they would like to stay. ","Travel Request","No","No"]
[null,"CHECK-IN","Indicate the date that the traveler plans to check into the requested hotel.","Travel Request","No","No"]
[null,"CHECK-OUT","Indicate the date that the traveler plans to check out of the requested hotel.","Travel Request","No","No"]
[null,"COMMENTS","Traveler indicates special requests or comments, e.g. conference code for a special rate, handicapped equipped room required, etc.","Travel Request","No","No"]
[null,"Does itinerary include a Rental Car Reservation?"]
[null,"CITY","Indicate the city in which the traveler is requesting a rental vehicle.","Travel Request","No","No"]
[null,"PICK-UP","Indicate the date the traveler will be picking up the requested rental vehicle.","Travel Request","No","No"]
[null,"RETURN  ","Indicate the date the traveler will be returning the requested rental vehicle.","Travel Request","No","No"]
[null,"RETURN LOCATION (if different)","The name of the city or the location where the car will be returned, if different than the pick-up location.","Travel Request","No","No"]
[null,"AWD/4WD","At the State's discretion, travelers may be allowed to request a four-wheel (4WD) or all-wheel drive (AWD) vehicle. Provide additional information in the OTHER/SPECIAL INSTRUCTIONS section.","Travel Request","No","No"]
[null,"Does Itinerary include any Rural or Non-Standard Travel?"]
[null,"DESTINATION","Indicate the city in which the traveler is requesting Rural/Non-Standard travel.","Travel Request","No","No"]
[null,"TYPE","Indicate the type of Rural/Non-Standard travel.","Travel Request","No","No"]
[null,"ADDITIONAL DETAILS","Indicate any additional details that may be helpful when booking this travel.","Travel Request","No","No"]
[null,"MILEAGE/COST","Enter mileage or cost that may be associated with this travel request.","Travel Request","No","No"]
[null,"Does Itinerary include Alaska Marine Highway System (AMHS) Travel?"]
[null,"VEHICLE TYPE","Select the type of vehicle that you will be traveling with.","Travel Request","No","No"]
[null,"YEAR","Enter the year for the vehicle.","Travel Request","No","No"]
[null,"MAKE","Enter the make of the vehicle.","Travel Request","No","No"]
[null,"MODEL","Enter the model of the vehicle.","Travel Request","No","No"]
[null,"SUB-MODEL","Enter the sub-model of the vehicle.","Travel Request","No","No"]
[null,"LENGTH (FEET)","Enter the length of the vehicle in feet.","Travel Request","No","No"]
[null,"OTHER SPECIAL INSTRUCTIONS"]
[null,"OTHER SPECIAL INSTRUCTIONS","Use this area to provide any other details or requested itinerary items for the trip. For example, special needs such as handicapped access or a request to upgrade to a full-size car. Further justification may be required for some requests, e.g. upgrading a rental car, and can be included in this box or as attached documentation to the travel request. All state travel will be arranged in accordance with state policies as outlined in the Alaska Administrative Manual (AAM) Section 60. ","Travel Request","No","Yes"]

{"sheet":"Instructions for TA","index":11,"n_rows":105,"n_cols":4,"rows_kept":105,"cut":false,"hidden":false,"merged":[[61,1,61,3],[86,1,86,3]]}
[]
[null,"Travel Authorization / Expense Report Field Matrix and Instructions"]
[]
[null,"Field Name","Instructions","Source"]
[null,"REPORT OPTIONS"]
[null,"TRAVELER","Select whether the traveler is a State Employee (EE) or a Non-Employee (EE).","TA with Exp Report"]
[null,"TYPE OF TRAVEL","Select the option for In-State (intra-Alaska) travel or for travel outside of Alaska.","TA with Exp Report"]
[null,"WARRANT MAILING ADDRESS OPTION","Select \"Yes\" if the traveler's warrant mailing address is different than the mailing address entered on the traveler's vendor customer number (VCN) in IRIS. This will unhide the WARRANT MAILING ADDRESS section of the form.","TA with Exp Report"]
[null,"PRISIONER TRANSPORT TRAVEL","DPS Only - Select \"Yes\" if this form contains Prisoner Transport Travel. This will unhide the PRISIONER TRANSPORT TRAVEL section of the form.","TA with Exp Report"]
[]
[null,"TRAVEL AUTHORIZATION"]
[null,"EMP NO.","The traveler's six-digit Employee Number. ","Traveler Information"]
[null,"TRAVEL AUTH NO.","The travel authorization number for this request.","Travel Request"]
[null,"TRAVEL AUTH NO.","The TRQS transaction ID from IRIS FIN.","Travel Request"]
[null,"TAPO NO.","The TAPO (Travel Purchase Order) transaction ID from IRIS FIN.","Travel Request"]
[null,"NAME OF TRAVELER","The traveler's legal name as indicated on the government issued ID that will be used for travel. ","Traveler Information"]
[null,"JOB TITLE","The traveler's position/job title. ","Traveler Information"]
[null,"AGENCY","The traveler's agency (department) from the drop-down list. If the traveler is not a state employee, use \"SECTION\", or \"PURPOSE OF TRIP\", to enter the agency or company that employs the traveler. ","Traveler Information"]
[null,"DIVISION","The traveler's division/agency information.","Traveler Information"]
[null,"SECTION","The traveler's section (sub-division) information. (See AGENCY information regarding non-employees.) ","Traveler Information"]
[null,"BARGAINING UNIT","The traveler's bargaining unit. Select NA-Non-Employee for travelers who are not state employees.","Traveler Information"]
[null,"DUTY STATION","The traveler's duty station.","Traveler Information"]
[null,"NORMAL WORK SCHEDULE (DOT ONLY)"]
[null,"DAYS","Enter the normal days of the week worked.","TA with Exp Report"]
[null,"TIME","Enter the employee's normal work hours.","TA with Exp Report"]
[]
[null,"PERSONAL PHYSICAL ADDRESS","Enter the traveler's physical personal, do not enter PO Box info or office address.","Traveler Information"]
[null,"REQUEST INCLUDES"]
[null,"ACTUALS","For LTC bargaining unit members only, select if actuals are requested.","Travel Request"]
[null,"TRAVEL ADVANCE","Select if the traveler needs a travel advance for estimated meals and incidental expenses (M&IE). Travel advances are generally calculated at 80% of estimated M&IE. Selection of this field should be accompanied with the entry in field TRAVEL ADVANCE DN and TRAVEL ADVANCE AMOUNT in Expense Report at the bottom of the form. See AAM 60.070 for more information.","Travel Request"]
[]
[null,"PURPOSE OF TRIP","Enter the purpose of the trip.","Travel Request"]
[null,"EXECUTIVE TRAVEL? and TYPE","If trip is for executive travel to be reported in the Compensation and Travel Report, this field will display the type of travel.","Travel Request"]
[null,"PRISONER TRANSPORT TRAVEL"]
[null,"TRANSPORT BEFORE/AFTER ARRAIGNMENT","Select whether transport was completed before or after arraignment from drop-down list.","TA with Exp Report"]
[null,"TRANSPORT REQ/ORDERED BY","Enter information for person who requested or ordered prisoner transport.","TA with Exp Report"]
[null,"JUVENILE?","Indicate whether transport was for a juvenile prisoner.","TA with Exp Report"]
[null,"MENTAL HEALTH?","Indicate whether transport was for a mental-health prisoner.","TA with Exp Report"]
[null,"PRISONER DETAILS - NAME(S), DOB(S), and COURT CASE(S)","Enter Prisoner Name, Date of Birth (DOB), and Court Case Number for each prisoner transported.","TA with Exp Report"]
[]
[null,"ESTIMATED COST","The total estimated State cost of travel (include all travel expenses).","Travel Request"]
[null,"CARD INFO","The Card Type and last four digits used to pay for the travel.","Travel Request"]
[null,"PERSONAL TRAVEL (See AAM 60.080 for more information.)"]
[null,"REQUEST INCLUDES PERSONAL TRAVEL","Indicate whether this trip includes an interruption or deviation for personal travel before, during, or after the State-authorized portion of the trip.  A \"Yes\" selection should be documented with entries in fields DATE BEGINS, DATE ENDS, and STATE AUTH AIRFARE for details about the personal travel.","Travel Request"]
[null,"MBI DATE BEGINS","Enter the date the Minimum Business Itinerary (MBI) begins i.e., MM/DD/YYYY.","Travel Request"]
[null,"MBI DATE ENDS","Enter the date the Minimum Business Itinerary (MBI) ends i.e., MM/DD/YYYY.","Travel Request"]
[null,"STATE AUTH AIRFARE","Enter the amount from the State-authorized fare quote for the State-portion of airfare. This will be used to calculate reimbursement at the end of travel.","Travel Request"]
[null,"ITINERARY"]
[null,"FROM","Enter the traveler's departure city (defaults to Duty Station).","Travel Request"]
[null,"DEPARTURE DATE","Enter the traveler's departure date i.e., MM/DD/YYYY.","Travel Request"]
[null,"TO (DESTINATION)","Enter the traveler's destination city.","Travel Request"]
[null,"RETURN DATE","Enter the traveler's return date , i.e.,  MM/DD/YYYY.","Travel Request"]
[]
[null,"FINANCIAL CODING","Enter the financial coding to which the travel is to be charged.\n\nRequired IRIS Elements - Accounting Template OR Fund-Department-Unit-Appr Unit-%\nOptional IRIS Elements - Detail Accounting elements","Travel Request"]
[null,"APPROVAL TO TRAVEL (See AAM 60.040 for more information.)"]
[null,"DIVISION (IN-STATE)","For travel within Alaska prior approval is required by the division approver. Approval can be made by signing this form or by attaching email approval with all required travel authorization information: traveler, purpose, destination, departure and return dates and times, a total not-to-exceed amount, and whether a personal deviation is requested. ","TA with Exp Report"]
[null,"DEPT (INTERSTATE)","If traveling outside Alaska to the contiguous United States, Hawaii, British Columbia, or the Yukon Territory prior approval is required by the division approver and the department's commissioner or designee.","TA with Exp Report"]
[null,"GOV (INTERSTATE/FOREIGN)","If traveling outside Alaska or the United States, prior approval is required by the division approver, the department's commissioner, and the Governor's Office.","TA with Exp Report"]
[]
[]
[null,"ACTUAL TRAVEL, PER DIEM, AND REIMBURSABLE EXPENSES (NO PCARD CHARGES)"]
[null,"Additional entry detail lines are available on the Continuation worksheet."]
[null,"DATE","Enter the date for the detailed expense line item, i.e., MM/DD/YYYY.","TA with Exp Report"]
[null,"EXPLANATION","Enter a detailed explanation for expense line item. This field can include information such as actual dates and departure times, actual arrival times, and actual costs. Agency may also use this area to deduct any vendor payments which are to be deducted from the employee's reimbursement, i.e., room service or movie charges which were on the hotel invoice and charged to the employee's travel card.","TA with Exp Report"]
[null,"MEALS PROV","Select a meal option from the drop-down list if meals were provided to traveler. B=Breakfast, L=Lunch, and D=Dinner.","TA with Exp Report"]
[null,"FACILITY","Select a lodging facility type from the drop-down list or leave blank. COMM = Commercial Facility, FIELD = Field Facility (Employee Provided Meals), STATE = State Facility (Meals Provided-No Per Diem), NONC = Non-Commercial Facility.","TA with Exp Report"]
[null,"# OF MILES","Enter the miles driven in a personally owned vehicle.   ","TA with Exp Report"]
[null,"SURFACE TRANS - MILEAGE","This field will calculate the mileage reimbursement based on the Date entered in DATE times field # OF MILES driven.","TA with Exp Report"]
[null,"SURFACE TRANS - OTHER","Enter any surface transportation charges paid out-of-pocket. These charges can include taxi, parking, ferry, bus, and shuttle charges.","TA with Exp Report"]
[null,"PER DIEM - LODGING","Enter any lodging per diem expenses paid out-of-pocket. ","TA with Exp Report"]
[null,"PER DIEM - M&IE","Enter claimed M&IE per diem expenses, reduce reimbursement amount for any meals provided to traveler.","TA with Exp Report"]
[null,"OTHER","Enter any other reimbursable travel expenses such as telephone, internet charges, copies, airfare reimbursement for travel with personal deviation, etc.","TA with Exp Report"]
[null,"TRAVEL COMPLETION APPROVALS (Post Travel)"]
[null,"TRAVELER SIGNATURE","Traveler signs certifying the information provided is correct and constitutes a valid claim against the State of Alaska.","TA with Exp Report"]
[null,"EXPENSE REPORT APPROVER SIGNATURE","Division approver signs to approve expenditure amounts claimed on this form.","TA with Exp Report"]
[null,"COST VARIANCE","This field displays the difference between the TOTAL TRIP EXPENSE to field EST COST FROM TRAVEL REQUEST from the TRAVEL AUTHORIZATION section. It is for informational purposes only.","TA with Exp Report"]
[null,"TRAVEL TOTALS"]
[null,"TOTAL OUT OF POCKET EXPENSES","The total of the Actual Expenses entered for Surface Transportation, Per Diem, and Other expenses in the rows above.","TA with Exp Report"]
[null,"ATM WITHDRAWAL","Enter the amount of ATM cash withdrawal taken by the traveler. The traveler's reimbursement total (TOTAL DUE TO/FROM TRAVELER) will be reduced by entering information in this field.","TA with Exp Report"]
[null,"TRAVEL ADV. TRANS #","Enter the IRIS Transaction Number of the travel advance payment (if applicable). IRIS Transaction Numbers consist of the Transaction (Page) Code-Department Number-Transaction ID.","TA with Exp Report"]
[null,"TRAVEL ADVANCE AMOUNT","Enter the amount of the travel advance issued. The traveler's reimbursement total (TOTAL DUE TO/FROM TRAVELER) will be reduced by entering information in this field.","TA with Exp Report"]
[null,"TAXABLE TRAVEL REPORTING"]
[null,"TOTAL","Enter the total amount to be reimbursed to the traveler if taxable travel is included in the Expense Report.","TA with Exp Report"]
[null,"NONTAX","Enter the non-taxable portion of the total amount to be reimbursed.","TA with Exp Report"]
[null,"TAXABLE","Enter the taxable portion of the total amount to be reimbursed. This amount will default to a calculation of the TOTAL less NONTAX amount entered.","TA with Exp Report"]
[null,"TRAVELER'S REIMBURSEMENT WARRANT"]
[null,{"$f":"B62","v":"Additional entry detail lines are available on the Continuation worksheet."}]
[null,"TYPE","Select from the drop-down list of expense types. Selection of a value from the drop-down field combined with options set in the Report Options area of the form will help to auto-select IRIS Object Code.","TA with Exp Report"]
[null,"AMOUNT","Enter the amount of the financial line to be reimbursed to the traveler.","TA with Exp Report"]
[null,"IRIS OBJECT","Enter the IRIS Object Code for the financial line. This field may be pre-populated based on the combination of selections on the form. (Formula can be overridden in these cells if necessary.)","TA with Exp Report"]
[null,"IRIS TRANSACTION ID","Enter the IRIS Transaction Number for the traveler's reimbursement warrant transaction(s). IRIS Transaction Numbers consist of the Transaction (Page) Code-Department Number-Transaction ID.","TA with Exp Report"]
[null,"VN CUST NUM","Enter the traveler's Vendor Customer Number (VCN).  If the traveler does not have a customer number, please contact your fiscal office to establish one.","Traveler Information"]
[null,"PREPARED BY","Enter name of the person who prepared this Expense Report.","TA with Exp Report"]
[null,"PREPARER'S PHONE NUMBER","Enter the phone number of the person who prepared this Expense Report.","TA with Exp Report"]
[null,"WARRANT MAILING ADDRESS","Enter the warrant mailing address only if different than the mailing address entered on the traveler's Customer Record in IRIS. This section is hidden by default, to unhide it select \"Yes\" in field at top of worksheet (see above).","TA with Exp Report"]
[null,"STATE PCARD CHARGES AND OTHER STATE PAID EXPENSES"]
[null,{"$f":"B62","v":"Additional entry detail lines are available on the Continuation worksheet."}]
[null,{"$f":"$B$88","v":"TYPE"},"Select from the drop-down list of expense types. Selection of a value from the drop-down field combined with options set in the Report Options area of the form will help to auto-select the IRIS Object Code.","TA with Exp Report"]
[null,"REF ID","Select from the drop-down list of reference types.","TA with Exp Report"]
[null,"REFERENCE / INV NUMBER","Enter Reference / Invoice number for the line item.","TA with Exp Report"]
[null,"VENDOR CUST NUM / VENDOR DESC","Enter Vendor Customer Number (VCN) and/or Description for the line item.","TA with Exp Report"]
[null,{"$f":"$B$89","v":"AMOUNT"},"Enter the PCard or State Paid amount for the financial line.","TA with Exp Report"]
[null,{"$f":"$B$90","v":"IRIS OBJECT"},{"$f":"$D$90","v":"TA with Exp Report"},"TA with Exp Report"]
[null,"DATE PAID","Enter the transaction date information for the line item, i.e., MM/DD/YYYY.","TA with Exp Report"]
[null,"IRIS TRANSACTION ID","Enter the IRIS Transaction Number from IRIS. IRIS Transaction Numbers consist of the Transaction (Page) Code-Department Number-Transaction ID.","TA with Exp Report"]

{"sheet":"trRanges","index":12,"n_rows":178,"n_cols":21,"rows_kept":178,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY","DEPT","DIV","DIV SHORT NAME","DIV NAME"]
["Y",null,"Departments",null,null,null,"ACCOUNTING ELEMENTS",null,null,null,"EXECUTIVE TRAVEL OPTIONS FOR PURPOSE",null,null,null,null,null,"2025","01","DAS","DAS-Administrat","DAS-Administrative Services"]
["N",null,"ACS","Alaska Court System","41",null,"Sub Fund","(choose)",null,null,"Board/Comm/Council Related Travel",null,null,null,null,null,"2025","01","ELE","ELE-Elections","ELE-Elections"]
[null,null,"CED","Commerce, Community & Econ Dev","08",null,"Sub Unit","Activity",null,null,"Conference/Training Related Travel",null,null,null,null,null,"2025","01","EXE","EXE-Executive O","EXE-Executive Office"]
["Yes",null,"DEC","Environmental Conservation","18",null,"Sub Obj","BFY",null,null,"Constituent Related Travel",null,null,null,null,null,"2025","01","HRC","HRC-Human Right","HRC-Human Rights Commission"]
["No",null,"DFG","Fish & Game","11",null,"Revenue","BSA",null,null,"Executive Branch/Dept Related Travel",null,null,null,null,null,"2025","01","LTG","LTG-Lieutenant","LTG-Lieutenant Governor"]
[null,null,"DNR","Natural Resources","10",null,"Sub Rev","Dept Obj",null,null,"Federal Related Travel",null,null,null,null,null,"2025","01","OMB","OMB-Office of M","OMB-Office of Management and Budget"]
[null,null,"DOA","Administration","02",null,"BSA","Dept Rev",null,null,"Legislative Related Travel",null,null,null,null,null,"2025","01","RDE","RDE-Redistrict","RDE-Redistricting Board"]
["AWD",null,"DOC","Corrections","20",null,"Sub BSA","Function",null,null,"Office of the Governor Related Travel",null,null,null,null,null,"2025","02","AOG","AOG-Alaska AOG","AOG-Alaska Oil and Gas Conservation Commission"]
["4WD",null,"DOH","Health","16",null,"OBSA","OBSA",null,null,"Third-Party Reimbursement Travel",null,null,null,null,null,"2025","02","COM","COM-Office of t","COM-Office of the Commissioner"]
[null,null,"DOL","Labor & Workforce Development","07",null,"Sub OBSA","Revenue",null,null,null,null,null,null,null,null,"2025","02","DAS","DAS-Administrat","DAS-Administrative Services"]
[null,null,"DOR","Revenue","04",null,"Dept Obj","Rprting",null,null,null,null,null,null,null,null,"2025","02","DLR","DLR-Labor Relat","DLR-Labor Relations"]
["None",null,"DOT","Transportation & Public Fac","25",null,"Dept Rev","Sub Act",null,null,null,null,null,null,null,null,"2025","02","DMV","DMV-Motor Vehic","DMV-Motor Vehicles"]
["B",null,"DPS","Public Safety","12",null,"Sub Loc","Sub BSA",null,null,null,null,null,null,null,null,"2025","02","DOP","DOP-Personnel","DOP-Personnel"]
["L",null,"EED","Education & Early Development","05",null,"Activity","Sub Fnct",null,null,null,null,null,null,null,null,"2025","02","DRB","DRB-Retirement","DRB-Retirement and Benefits"]
["D",null,"FCS","Family & Community Services","26",null,"Sub Act","Sub Fund",null,null,null,null,null,null,null,null,"2025","02","DRM","DRM-Risk Manage","DRM-Risk Management"]
["BL",null,"GOV","Office of the Governor","01",null,"Function","Sub Loc",null,null,null,null,null,null,null,null,"2025","02","DSS","DSS-Shared Serv","DSS-Shared Services"]
["LD",null,"LAW","Law","03",null,"Sub Fnct","Sub Obj",null,null,null,null,null,null,null,null,"2025","02","ETS","ETS-Enterprise","ETS-Enterprise Technology Services"]
["BD",null,"LEG","Legislature","30",null,"Rprting","Sub OBSA",null,null,null,null,null,null,null,null,"2025","02","FIN","FIN-Finance","FIN-Finance"]
["BLD",null,"MVA","Military & Veterans Affairs","09",null,"Sub Rprt","Sub Rev",null,null,null,null,null,null,null,null,"2025","02","OAH","OAH-Office of A","OAH-Office of Administrative Hearings"]
["Other",null,null,null,null,null,"Task","Sub Rprt",null,null,null,null,null,null,null,null,"2025","02","OIT","OIT-Office of I","OIT-Office of Information Technology"]
[null,null,null,null,null,null,"Sub Task","Sub Task",null,null,null,null,null,null,null,null,"2025","02","OPA","OPA-Office of P","OPA-Office of Public Advocacy"]
[null,null,null,null,null,null,"Tsk Ordr","Sub Unit",null,null,null,null,null,null,null,null,"2025","02","PDA","PDA-Public Defe","PDA-Public Defender Agency"]
[null,null,null,null,null,null,null,"Task",null,null,null,null,null,null,null,null,"2025","02","POC","POC-Alaska Publ","POC-Alaska Public Offices Commission"]
[null,null,null,null,null,null,null,"Tsk Ordr",null,null,null,null,null,null,null,null,"2025","02","PPM","PPM-PROC-PROP","PPM-Office of Procurement and Property Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","03","AGO","AGO-Office of t","AGO-Office of the Attorney General"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","03","ASD","ASD-Administrat","ASD-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","03","CIV","CIV-Civil Divis","CIV-Civil Division"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","03","CRM","CRM-Criminal Di","CRM-Criminal Division"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","ASD","ASD-Administrat","ASD-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","CIU","CIU-Criminal In","CIU-Criminal Investigations Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","CSS","CSS-Child Suppo","CSS-Child Support Services Division"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","MHT","MHT-Mental Heal","MHT-Mental Health Trust Authority"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","OCC","OCC-Comm Off","OCC-Office of Commissioner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","PFC","PFC-Alaska Perm","PFC-Alaska Permanent Fund Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","PFD","PFD-Permanent F","PFD-Permanent Fund Dividend Division"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","TAX","TAX-Tax Divisio","TAX-Tax Division"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","04","TRS","TRS-Treasury Di","TRS-Treasury Division"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","ADS","ADS-Admin Svcs","ADS-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","ARA","ARA-AlyRdgAcad","ARA-Alyeska Reading Academy and Institute"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","ART","ART-Alaska Stat","ART-Alaska State Council on the Arts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","ESE","ESE-EDUC EXCE","ESE-EDUCATOR AND SCHOOL EXCELLENCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","EXA","EXA-Executive A","EXA-Executive Administration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","FSS","FSS-FINSUPPORT","FSS-FINANCE AND SUPPORT SERVICES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","IEE","IEE-Innovation","IEE-Innovation and Education Excellence"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","LAM","LAM-Alaska Libr","LAM-Alaska Library, Archives and Museums"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","MTE","MTE-Mt. Edgecum","MTE-Mt. Edgecumbe Boarding School"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","PSE","PSE-Alaska Post","PSE-Alaska Postsecondary Education Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","PTP","PTP-Professiona","PTP-Professional Teaching Practices Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","STL","STL-STUDENT LRN","STL-STUDENT LEARNING"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","05","TLS","TLS-Teaching an","TLS-Teaching and Learning Support"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","APH","APH-Alaska Pion","APH-Alaska Pioneers Homes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","DBH","DBH-Behavioral","DBH-Behavioral Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","DJJ","DJJ-Juvenile Ju","DJJ-Juvenile Justice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","DPA","DPA-Public Assi","DPA-Public Assistance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","DPH","DPH-Public Heal","DPH-Public Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","DSS","DSS-Sup Serv","DSS-Support Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","HCS","HCS-Health Care","HCS-Health Care Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","OCS","OCS-Office of C","OCS-Office of Children's Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","06","SDS","SDS-Sen Dis Svs","SDS-Senior and Disabilities Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","07","ASD","ASD-Administrat","ASD-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","07","AVT","AVT-Alaska Voca","AVT-Alaska Vocational Technical Center"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","07","COM","COM-Office of t","COM-Office of the Commissioner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","07","DET","DET-Employment","DET-Employment & Training Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","07","DVR","DVR-Vocational","DVR-Vocational Rehabilitation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","07","LSS","LSS-Labor Stand","LSS-Labor Standards and Safety"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","07","WCD","WCD-Workers' Co","WCD-Workers' Compensation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","ABO","ABO-AKBroadOffc","ABO-Alaska Broadband Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","AID","AID-Alaska Indu","AID-Alaska Industrial Development and Export Authority"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","AMC","AMC-Alc Mar Ctl","AMC-Alcohol & Marijuana Control Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","AOG","AOG-Alaska AOG","AOG-Alaska Oil and Gas Conservation Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","ASM","ASM-Alaska Seaf","ASM-Alaska Seafod Marketing Institute"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","BSC","BSC-Banking and","BSC-Banking and Securities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","CBP","CBP-CBPL","CBP-Corporations Business & Professional Licensing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","COM","COM-Commissione","COM-Commissioner's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","CRA","CRA-Community a","CRA-Community and Regional Affairs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","DAS","DAS-Administrat","DAS-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","DED","DED-Division of","DED-Division of Economic Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","INS","INS-Division of","INS-Division of Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","INV","INV-Investments","INV-Division of Investments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","08","RCA","RCA-Regulatory","RCA-Regulatory Commission of Alaska"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","AAC","AAC-Alaska Aero","AAC-Alaska Aerospace Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","AFM","AFM-Aerospace F","AFM-Aerospace Facilities Maintenance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","AIR","AIR-Natl Grd","AIR-Air National Guard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","ARM","ARM-Natl Grd","ARM-Army National Guard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","COM","COM-Office of t","COM-Office of the Commissioner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","DAS","DAS-Administrat","DAS-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","HLS","HLS-HL Security","HLS-Homeland Security"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","MHQ","MHQ-AKNG Milita","MHQ-Alaska National Guard Military Headquarters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","MYC","MYC-Alaska Mili","MYC-Alaska Military Youth Academy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","TEL","TEL-APSCS-MVA","TEL-Alaska Public Safety Communication Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","09","VET","VET-Veterans Af","VET-Veterans Affairs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","ADM","ADM-Administrat","ADM-Administration and Support Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","AGR","AGR-Division of","AGR-Division of Agriculture"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","COM","COM-Commissione","COM-Commissioner's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","FOR","FOR-Forest-DNR","FOR-Division of Forestry and Fire Protection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","GGS","GGS-Division of","GGS-Division of Geological and Geophysical Surveys"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","IRM","IRM-Information","IRM-Information Resource Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","MHL","MHL-Mental Heal","MHL-Mental Health Trust Lands Administration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","MLW","MLW-Division of","MLW-Division of Mining, Land and Water"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","NSG","NSG-North Slope","NSG-North Slope Gas Commercialization"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","OIL","OIL-Oil and Gas","OIL-Oil and Gas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","OPM","OPM-Office of P","OPM-Office of Project Management and Permitting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","PKS","PKS-Division of","PKS-Division of Parks and Outdoor Recreation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","10","REC","REC-Recorder's","REC-Recorder's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","BDS","BDS-Boards Supp","BDS-Boards Support"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","CFE","CFE-Commercial","CFE-Commercial Fisheries Entry Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","COF","COF-Commercial","COF-Commercial Fisheries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","COM","COM-Commissione","COM-Commissioner's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","DAS","DAS-Administrat","DAS-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","DWC","DWC-Wildlife Co","DWC-Wildlife Conservation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","EVO","EVO-Exxon Valde","EVO-Exxon Valdez Oil Spill Trustee Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","HAB","HAB-Habitat","HAB-Habitat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","SPF","SPF-Sport Fish","SPF-Sport Fish"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","11","SUB","SUB-Subsistence","SUB-Subsistence"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","12","AST","AST-Alaska Stat","AST-Alaska State Trooper Detachments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","12","AWT","AWT-Alaska Wild","AWT-Alaska Wildlife Troopers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","12","COM","COM-Commissione","COM-Commissioner's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","12","DAS","DAS-Administrat","DAS-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","12","FLS","FLS-Fire and Li","FLS-Fire and Life Safety"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","12","STW","STW-Statewide S","STW-Statewide Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","12","VSA","VSA-VICSVCS-DPS","VSA-Victim Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","16","DBH","DBH-Behavioral","DBH-Behavioral Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","16","DPA","DPA-Public Assi","DPA-Public Assistance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","16","DPH","DPH-Public Heal","DPH-Public Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","16","DSS","DSS-Sup Serv","DSS-Support Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","16","HCS","HCS-Health Care","HCS-Health Care Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","16","SDS","SDS-Sen Dis Svs","SDS-Senior and Disabilities Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","16","XXX","XXX-Default","XXX-Default"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","18","COM","COM-Office of t","COM-Office of the Commissioner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","18","DAS","DAS-Administrat","DAS-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","18","DEH","DEH-Environment","DEH-Environmental Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","18","DOA","DOA-Division of","DOA-Division of Air Quality"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","18","DOW","DOW-Division of","DOW-Division of Water"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","18","SPR","SPR-Division of","SPR-Division of Spill Prevention and Response"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","ADS","ADS-Administrat","ADS-Administration and Support"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","HRS","HRS-Hlth Rehab","HRS-Health Rehab Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","INS","INS-Division of","INS-Division of Institutions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","OHP","OHP-Offender Ha","OHP-Offender Habilitation Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","PAP","PAP-Division of","PAP-Division of Probation and Parole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","PBO","PBO-Parole Boar","PBO-Parole Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","PPP","PPP-Division of","PPP-Division of Pretrial, Probation and Parole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","20","PTS","PTS-Pre-Trial S","PTS-Pre-Trial Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","ASD","ASD-Adm Serv","ASD-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","AVI","AVI-Aviation","AVI-Aviation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","CRD","CRD-Central Reg","CRD-Central Region Director's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","DES","DES-Statewide D","DES-Statewide Design"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","DFS","DFS-Facilities","DFS-Facilities Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","DMI","DMI-DataMod-DOT","DMI-Data Modernization and Innovation Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","IAD","IAD-Intl Arpt","IAD-International Airports"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","ISD","ISD-Information","ISD-Information Systems and Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","MHD","MHD-Mar Hwy","MHD-Marine Highways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","MSC","MSC-Measurement","MSC-Measurement Standards & Commercial Vehicle Enforcement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","NRD","NRD-Northern Re","NRD-Northern Region Director's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","PUF","PUF-Public Faci","PUF-Public Facilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","SEF","SEF-Northern St","SEF-Northern State Equipment Fleet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","SRD","SRD-South Coast","SRD-South Coast Region Director's Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","25","SWP","SWP-Statewide P","SWP-Statewide Program Development"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","26","APH","APH-Alaska Pion","APH-Alaska Pioneers Homes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","26","API","API-AK Psy Inst","API-Alaska Psychiatric Institute"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","26","DJJ","DJJ-Juvenile Ju","DJJ-Juvenile Justice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","26","DSS","DSS-Sup Serv","DSS-Support Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","26","OCS","OCS-Office of C","OCS-Office of Children's Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","LAA","LAA-Legislative","LAA-Legislative Affairs Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","LAU","LAU-Legislative","LAU-Legislative Audit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","LEG","LEG-Legislative","LEG-Legislative Branch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","LFD","LFD-Legislative","LFD-Legislative Finance Division"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","LRD","LRD-Redistr Brd","LRD-Redistricting Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","LRS","LRS-Legal and R","LRS-Legal and Research Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","OOM","OOM-Office of t","OOM-Office of the Ombudsman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","30","OVR","OVR-Office of t","OVR-Office of the Victim's Rights"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","41","ACJ","ACJ-Alaska Comm","ACJ-Alaska Commission on Judicial Conduct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","41","ADM","ADM-Administrat","ADM-Administrative Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","41","AJC","AJC-Alaska Judi","AJC-Alaska Judicial Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","41","APP","APP-Court of Ap","APP-Court of Appeals Slip Opinions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","41","JPT","JPT-Judges PT","JPT-Judges Pro Tem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025","41","TRC","TRC-Alaska Tria","TRC-Alaska Trial Courts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Ranges","index":13,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":true,"merged":[]}
["Bargaining Units",null,null,"IRIS OBJECTS"]
["AA-PSEA/PUBLIC SAFETY OFFIC","AA",null,null,"INSTATE","OUT","INSTATE","OUT"]
["AP-PSEA/AIRPORT SAFETY OFFIC","AP",null,"REF","EE","EE","NON-EE","NON-EE"]
["BB-MEBA","BB",null,"ACC"]
["CC-MASTERS, MATES & PILOTS","CC",null,"CAR",2001,2013,2006,2018]
["EE-EXCLUDED EMPL","EE",null,"CO"]
["GC-ACOA/CORRECTIONAL OFFIC","GC",null,"CUS"]
["GG-ASEA/GENERAL GOVT","GG",null,"DO"]
["GP-ASEA/GENERAL GOVT","GP",null,"INV"]
["GY-ASEA/GENERAL GOVT","GY",null,"LOD",2002,2014,2007,2019]
["GZ-ASEA/GENERAL GOVT","GZ",null,"MCC"]
["KK-APEA/CEA","KK",null,"TKT",2000,2012,2005,2017]
["LL-LABOR, TRADES, & CRAFTS","LL",null,"UDR"]
["MM-INLANDBOATMEN'S UNION","MM"]
["NA-NON-EMPLOYEE","NA"]
["NG-NATIONAL GUARD EMPL","NG"]
["SS-APEA/SU","SS"]
["TA-AVTECTA","TA",null,"TYPE -- TRAVEL REIMB"]
["TM-TEAME/MT EDGECUMBE","TM",null,"",0,0,0,0]
["XA-EXEC BR EXEMPT-AEROSPACE","XA",null,"AIR",2000,2012,2010,2022]
["XE-EXEC BR EXEMPT","XE",null,"C ADV",2003,2015,2008,2020]
["XJ-JUDICIAL BR EXEMPT","XJ",null,"LODG",2002,2014,2010,2022]
["XL-LEG BR EXEMPT","XL",null,"LODG TAX",2002,2014,2009,2021]
["XP-EXEC BR PARTIAL EXEMPT","XP",null,"M&IE",2003,2015,2008,2020]
[null,null,null,"M&IE TAX",2003,2015,2009,2021]
["Type of Lodging",null,null,"OTHER",0,0,0,0]
["COMM",null,null,"REIMB",2004,2016,2010,2022]
["FIELD",null,null,"SURF",2001,2013,2010,2022]
["STATE",null,null,"T ADV",2003,2015,2008,2020]
["NONC"]
[]
["Departments",null,null,"TYPE -- STATE PAID"]
["Administration (02)","02",null,"",0,0,0,0]
["AK Comm on Postsecondary Education (05)","05",null,"AIR",2000,2012,2005,2017]
["Alaska Court System (41)","41",null,"C ADV",2003,2015,2008,2020]
["Alaska Seafood Marketing Institute (08)","08",null,"COMM",3069,3069,3069,3069]
["Commerce, Community & Econ Dev (08)","08",null,"FEE",2036,2036,0,0]
["Corrections (20)","20",null,"LODG",2002,2014,2007,2019]
["Education & Early Development (05)","05",null,"M&IE",2003,2015,2008,2020]
["Environmental Conservation (18)","18",null,"OTHER",0,0,0,0]
["Family & Community Services (26)","26",null,"SURF",2001,2013,2006,2018]
["Fish & Game (11)","11"]
["Health (16)",16]
["Labor & Workforce Development (07)","07"]
["Law (03)","03"]
["Legislative Affairs (31)","31"]
["Legislative Audit (33)","33"]
["Military & Veterans Affairs (09)","09"]
["Natural Resources (10)","10"]
["Office of the Governor (01)","01"]
["Office of the Lt. Governor (01)","01"]
["Public Safety (12)","12"]
["Revenue (04)","04"]
["Transportation & Public Fac (25)","25"]
[]
["Arraignment"]
["Before"]
["After"]
[]
["Yes"]
["No"]
["See Attached"]
[]
["Meals"]
["B"]
["L"]
["D"]
["B/L"]
["B/D"]
["L/D"]
["B/L/D"]
[]
["PERS VEHICLE MILEAGE RATE"]
[0.7]
[0.67]
[]
["REQUEST INCLUDES PERSONAL TRAVEL"]
["Yes"]
["No"]