{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","NTSSA Expense","Exp Receipts","DataSheet"],"not_rendered":{"images":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":42,"n_cols":9,"rows_kept":42}
["Instructions"]
[]
[1,"Click on NTSSA Expense Tab below"]
[2,"Enter your Input in Cells with Black Text Column Headers Only. Cells w/ Blue Headers are not modifiable except for Expense List below"]
[3,"For Expenses listed below, you will need to enter your own Cost/Value as the Tool will not Auto-Calculate it for you in the FEES Column"]
[null,null,"Assign Assessors"]
[null,null,"Assign Clinics"]
[null,null,"Baggage Fee"]
[null,null,"Indoor Clinic Instructor"]
[null,null,"Instructor Evaluation"]
[null,null,"Inservice Instructor"]
[null,null,"Other"]
[null,null,"State Instructor"]
[null,null,"Travel"]
[4,"To Attach Copies of your Expense Receipts: "]
[null,null,"Scan Receipt(s) and Save to a known Location as JPG File Format"]
[null,null,"Scan own Signature page and Save to a known Location as JPG File Format"]
[null,null,"Scanned Files must be Cropped to Size and in JPG File Format"]
[null,null,"Click on Exp Receipts Tab below"]
[null,null,"Click on Insert in the Tool Bar/Menu Above"]
[null,null,"Click on Object Option"]
[null,null,"Select Create From A File"]
[null,null,"Check \"Browse\" Box"]
[null,null,"Find where you saved your Scanned Receipt(s)"]
[null,null,"Click OK to attach Scanned Receipt(s)"]
[null,null,"If your Scanned File Opens, just close it and you will See an Icon Attached in your doc representing a copy of your receipt "]
[null,null,"Repeat Steps if you need to attach Multiple Scans (Receipt and Signature page)"]
[null,null,"DO NOT Attach Multiple Scans inside the same Cell in the Exp Receipts Tab. Skip multiple Rows to allow Icons/Docs to show once Attached"]
[]
[5,"Save your Expense Report as ",null,"LastName MM-DD-YY Assoc Code Grd or Event"]
[null,null,"Use three digit Association codes"]
[null,null,"Ex","Huey 08-10-12 RWL 08.xlsx",{"$nulls":4},"For a Grade 08 Clinic"]
[null,null,"Ex","Stringer 08-09-14 CRW 09.xlsx",{"$nulls":4},"For a Grade 09 Clinic"]
[null,null,"Ex","Hiler 09-16-12 NTX assess Curry.xlsx",{"$nulls":4},"For a State assigned assessment"]
[null,null,"Ex","Hiler 04-13-13 BRL assess day.xlsx",{"$nulls":4},"For an Assessor Day"]
[null,null,"Ex","Hiler 07-12-13 NTX travel XXX.xlsx",{"$nulls":4},"For any travel authorized by North Texas Soccer SRC (XXX is the event for the travel)"]
[]
[]
[6,"Email your Expense Report to"]
[null,null,"SDI for Instruction"]
[null,null,"SDA for Assessment"]
[null,null,"Chairman for Others"]

{"sheet":"NTSSA Expense","index":1,"n_rows":53,"n_cols":15,"rows_kept":53,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,7],[5,1,5,2],[5,3,5,7],[6,10,6,14],[7,1,7,2],[7,3,7,7],[7,10,7,14],[9,1,9,2],[9,3,9,7],[9,11,9,12],[11,1,11,2],[11,3,11,6],[12,1,12,2],[12,3,12,6],[13,1,13,2],[13,3,13,6],[14,1,14,2],[14,3,14,6],[15,1,15,2],[15,3,15,6],[16,1,16,2],[16,3,16,6],[17,1,17,2],[17,3,17,6],[18,1,18,2],[18,3,18,6],[20,2,20,3],[20,4,20,6],[20,10,20,14],[21,2,21,3],[21,4,21,6],[21,7,26,9],[21,11,21,12],[22,2,22,3],[22,4,22,6],[22,11,22,12],[23,2,23,3],[23,4,23,6],[23,11,23,12],[24,2,24,3],[24,4,24,6],[24,11,24,12],[25,2,25,3],[25,4,25,6],[25,11,25,12],[26,2,26,3],[26,4,26,6],[26,11,26,12],[35,1,35,5],[35,6,35,14],[36,1,36,14],[37,1,37,14],[38,1,38,14],[39,1,39,14],[40,1,40,14],[41,1,41,14],[47,1,48,14],[49,7,49,9],[50,1,50,5],[50,7,50,9],[50,10,50,13],[51,1,51,5],[51,7,51,9],[51,10,51,13]]}
[]
[null,null,"REFEREE PROGRAM EXPENSE REIMBURSEMENT VOUCHER"]
[]
[null,"Name"]
[]
[null,"Address"]
[]
[null,"City, State, Zip",{"$nulls":8},"Enter Expense Reason Above"]
[]
[null,"Phone #",{"$nulls":8},"Function"]
[]
[null,"Date",null,"Expense Type",{"$nulls":3},"Hotel 1,6","Meals 1,4,5","Airfare                                Car Rental 1","Phone / Misc.1,3,7","Auto Miles 2","Mileage Fee","Fees","Total"]
[{"$nulls":3},"Select Expense Type",{"$nulls":8},{"$f":"(ROUNDUP(L13,0)*DataSheet!$F$2)","v":0},{"$f":"IF(ISBLANK(D13),\" \",VLOOKUP(D13,DataSheet!$A$3:$B$38,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D13),\" \",SUM(H13+I13+J13+K13+M13+N13))","v":{"$error":"#N/A"}}]
[{"$nulls":12},{"$f":"(ROUNDUP(L14,0)*DataSheet!$F$2)","v":0},{"$f":"IF(ISBLANK(D14),\" \",VLOOKUP(D14,DataSheet!$A$3:$B$38,2,FALSE))","v":" "},{"$f":"IF(ISBLANK(D14),\" \",SUM(H14+I14+J14+K14+M14+N14))","v":" "}]
[{"$nulls":12},{"$f":"(ROUNDUP(L15,0)*DataSheet!$F$2)","v":0},{"$f":"IF(ISBLANK(D15),\" \",VLOOKUP(D15,DataSheet!$A$3:$B$38,2,FALSE))","v":" "}," "]
[{"$nulls":12},{"$f":"(ROUNDUP(L16,0)*DataSheet!$F$2)","v":0},{"$f":"IF(ISBLANK(D16),\" \",VLOOKUP(D16,DataSheet!$A$3:$B$38,2,FALSE))","v":" "}," "]
[{"$nulls":12},{"$f":"(ROUNDUP(L17,0)*DataSheet!$F$2)","v":0},{"$f":"IF(ISBLANK(D17),\" \",VLOOKUP(D17,DataSheet!$A$3:$B$38,2,FALSE))","v":" "}," "]
[{"$nulls":12},{"$f":"(ROUNDUP(L18,0)*DataSheet!$F$2)","v":0},{"$f":"IF(ISBLANK(D18),\" \",VLOOKUP(D18,DataSheet!$A$3:$B$38,2,FALSE))","v":" "}," "]
[{"$nulls":3},"Total",{"$nulls":3},{"$f":"SUM(H13:H18)","v":0},0,0,0,{"v":0,"d":"0.0"},0,{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Miles","From",null,"To",{"$nulls":5},"For Office Use ONLY"]
[{"$nulls":10},"Chairman","5019-113"]
[{"$nulls":10},"Clinics","5020-113"]
[{"$nulls":10},"Assess.","5085-113"]
[{"$nulls":10},"Assign.","5086-113"]
[{"$nulls":10},"Merchan.","5110-113"]
[{"$nulls":10},"Travel","5240-113"]
[]
[null,"1 Receipts must be attached in  ",{"$nulls":3},"\"Exp Receipts\" Tab"]
[null,"2 Total mileage will be paid for all miles roundtrip. Please Enter Miles in Whole Numbers"]
[null,"3 Enter Total Tollway Fees under Misc Column and attach Receipt in ",{"$nulls":5},"\"Exp Receipts\" Tab"]
[null,"4 No more than $10.00 Breakfast, $15.00 Lunch, $20.00 Dinner (1 meal per 4 Hours of service)"]
[null,"5 No alcoholic beverage expense will be reimbursed."]
[null,"6 Necessary hotel charges must be pre approved."]
[]
[null,"7 Comments for Miscellaneous"]
{"$rows_empty":7}
[{"$nulls":6},"Email to","SDI for Instruction"]
[{"$nulls":7},"SDA for Assessment"]
[{"$nulls":7},"Chairman for other"]
[]
[null,"SUBMIT EXPENSE FORM WITHIN 30 DAYS OF EXPENSE ITEM"]
[]
[]
[null,"Signature",{"$nulls":4},"Date","Program Director ",null,null,"Approved By ",{"$nulls":3},"Date"]
[null," "]
[{"$nulls":12},"Revised","2014-09-01"]

{"sheet":"Exp Receipts","index":2,"n_rows":2,"n_cols":1,"rows_kept":2}
[]
["Please attach all Expense Receipts into this Tab"]

{"sheet":"DataSheet","index":3,"n_rows":35,"n_cols":6,"rows_kept":35,"hidden":true}
["Expense_Types_Values","Session $$ Rate",null,"Select Function","IIC Rate","Mileage Rate"]
["Select Expense Type",null,null,"Assessor",{"v":25,"d":"$25.00"},{"v":0.56,"d":"$0.56"}]
["Assessment",{"v":60,"d":"$60.00"},null,"Assignor"]
["Assessment Cancel",{"v":30,"d":"$30.00"},null,"Instructor"]
["Assessor Day - 1 Session",{"v":30,"d":"$30.00"},null,"Other"]
["Assessor Day - 2 Sessions",{"v":60,"d":"$60.00"},null,"Travel"]
["Assessor Day - 3 Sessions",{"v":90,"d":"$90.00"}]
["Assessor Day - 4 Sessions",{"v":120,"d":"$120.00"}]
["Assessor In Charge",{"v":30,"d":"$30.00"}]
["Assign Assessors",{"v":0,"d":"$0.00"}]
["Assign Clinics",{"v":0,"d":"$0.00"}]
["Assignor Course - 1 Session",{"v":25,"d":"$25.00"}]
["Assignor Course - 2 Sessions",{"v":50,"d":"$50.00"}]
["Assignor Course - 3 Sessions",{"v":75,"d":"$75.00"}]
["Assignor Course - 4 Sessions",{"v":100,"d":"$100.00"}]
["Assignor Course - 5 Sessions",{"v":125,"d":"$125.00"}]
["Baggage Fee",{"v":0,"d":"$0.00"}]
["Grd 8 - IIC-Sessions C/D/E",{"v":137.5,"d":"$137.50"}]
["Grd 8 - Session B",{"v":87.5,"d":"$87.50"}]
["Grd 9 - 2 Sessions           ",{"v":50,"d":"$50.00"}]
["Grd 9 - 3 Sessions           ",{"v":75,"d":"$75.00"}]
["Grd 9 - Full IFK Clinic     ",{"v":175,"d":"$175.00"}]
["Grd 9 - IIC + 3 Sessions  ",{"v":100,"d":"$100.00"}]
["IIC Fitness Test",{"v":30,"d":"$30.00"}]
["Indoor Clinic Instructor",{"v":0,"d":"$0.00"}]
["Inservice Instructor",{"v":0,"d":"$0.00"}]
["Instructor Evaluation",{"v":0,"d":"$0.00"}]
["Natl Assessment",{"v":100,"d":"$100.00"}]
["Other",{"v":0,"d":"$0.00"}]
["State Instructor",{"v":0,"d":"$0.00"}]
["Travel",{"v":0,"d":"$0.00"}]
[]
[]
[]
["To ensure adding a new Expense Type to the Selection List, Insert a new Row and add the new Type within the existing List and just Resort the entire List (shaded) Ascending by Col \"A\""]