{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Reimbursement","Dropdown","Guidelines"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Reimbursement","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[25,0,35,8],[36,0,37,8],[7,2,7,4],[7,5,7,8],[8,2,8,4],[8,5,8,8],[9,0,9,1],[9,2,9,4],[9,5,9,8],[24,1,24,5],[24,7,24,8],[1,0,1,8],[4,1,4,8],[5,1,5,8],[3,0,3,8],[6,2,6,4],[6,5,6,8]]}
[]
["V D D - G N A  J U D G E  E X P E N S E  R E P O R T"]
[]
["  Mail/Email To: Larry McNeese\n19495 CR 37.5\nSterling, CO 80751\n  Email: vddgnatreasurer@gmail.com"]
["Name:"]
["Address:"]
["Phone:",null,"Email:"]
["Test Type:\n(Dropdown)",null,"Test Location/Test Director:"]
["Test Dates:",null,"# of Dogs Tested"]
["Percent GNA Business: (Drop Down)",null,1,null,null,"This percentage will auto-calculate subtotal!"]
[]
["Date","Description","Airfare","Gas","Hotel","Parking","Car Rental","Other","Total"]
[null,null,null,null,null,null,null,null,{"$f":"IF((C13)>0, (SUM(C13:H13)*$C$10), IF(D13>0, (SUM(D13:H13)*$C$10), IF(E13>0, (SUM(E13:H13)*$C$10), IF(F13>0, (SUM(F13:H13)*$C$10), IF(G13>0, (SUM(G13:H13)*$C$10), IF(H13>0, (H13*$C$10), \"\"))))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF((C14)>0, (SUM(C14:H14)*$C$10), IF(D14>0, (SUM(D14:H14)*$C$10), IF(E14>0, (SUM(E14:H14)*$C$10), IF(F14>0, (SUM(F14:H14)*$C$10), IF(G14>0, (SUM(G14:H14)*$C$10), IF(H14>0, (H14*$C$10), \"\"))))))","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,"Total Owed",{"$f":"IF(SUM(I13:I19)>0, SUM(I13:I19), \"\")","v":""}]
[]
[]
["Judge Signature",null,null,null,null,null,"Date:"]
["Additional Information/Comments: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Receipts must be attached to expense form. Please review Guidelines tab for expense questions"]

{"sheet":"Dropdown","index":1,"n_rows":100,"n_cols":3,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[1,"VJP",0.01]
[0.75,"HZP",0.02]
[0.5,"VGP",0.03]
[0.25,"VSwP",0.04]
[0,"Breedshow",0.05]
[null,"Other",0.06]
[null,null,7.0000000000000007E-2]
[null,null,0.08]
[null,null,0.09]
[null,null,0.1]
[null,null,0.11]
[null,null,0.12]
[null,null,0.13]
[null,null,0.14000000000000001]
[null,null,0.15]
[null,null,0.16]
[null,null,0.17]
[null,null,0.18]
[null,null,0.19]
[null,null,0.2]
[null,null,0.21]
[null,null,{"$f":"C21+0.01","v":0.22}]
[null,null,{"$f":"C22+0.01","v":0.23}]
[null,null,0.24000000000000002]
[null,null,0.25]
[null,null,0.26]
[null,null,0.27]
[null,null,0.28000000000000003]
[null,null,0.29000000000000004]
[null,null,0.30000000000000004]
[null,null,0.31000000000000005]
[null,null,0.32000000000000006]
[null,null,0.33000000000000007]
[null,null,0.34000000000000008]
[null,null,0.35000000000000009]
[null,null,0.3600000000000001]
[null,null,0.37000000000000011]
[null,null,0.38000000000000012]
[null,null,0.39000000000000012]
[null,null,0.40000000000000013]
[null,null,0.41000000000000014]
[null,null,0.42000000000000015]
[null,null,0.43000000000000016]
[null,null,0.44000000000000017]
[null,null,0.45000000000000018]
[null,null,0.46000000000000019]
[null,null,0.4700000000000002]
[null,null,0.4800000000000002]
[null,null,0.49000000000000021]
[null,null,0.50000000000000022]
[null,null,0.51000000000000023]
[null,null,0.52000000000000024]
[null,null,0.53000000000000025]
[null,null,0.54000000000000026]
[null,null,0.55000000000000027]
[null,null,0.56000000000000028]
[null,null,0.57000000000000028]
[null,null,0.58000000000000029]
[null,null,0.5900000000000003]
[null,null,0.60000000000000031]
[null,null,0.61000000000000032]
[null,null,0.62000000000000033]
[null,null,0.63000000000000034]
[null,null,0.64000000000000035]
[null,null,0.65000000000000036]
[null,null,0.66000000000000036]
[null,null,0.67000000000000037]
[null,null,0.68000000000000038]
[null,null,0.69000000000000039]
[null,null,0.7000000000000004]
[null,null,0.71000000000000041]
[null,null,0.72000000000000042]
[null,null,0.73000000000000043]
[null,null,0.74000000000000044]
[null,null,0.75000000000000044]
[null,null,0.76000000000000045]
[null,null,0.77000000000000046]
[null,null,0.78000000000000047]
[null,null,0.79000000000000048]
[null,null,0.80000000000000049]
[null,null,0.8100000000000005]
[null,null,0.82000000000000051]
[null,null,0.83000000000000052]
[null,null,0.84000000000000052]
[null,null,0.85000000000000053]
[null,null,0.86000000000000054]
[null,null,{"$f":"C86+0.01","v":0.87000000000000055}]
[null,null,0.88000000000000056]
[null,null,0.89000000000000057]
[null,null,0.90000000000000058]
[null,null,0.91000000000000059]
[null,null,0.9200000000000006]
[null,null,0.9300000000000006]
[null,null,0.94000000000000061]
[null,null,0.95000000000000062]
[null,null,0.96000000000000063]
[null,null,0.97000000000000064]
[null,null,0.98000000000000065]
[null,null,0.99000000000000066]
[null,null,1.0000000000000007]

{"sheet":"Guidelines","index":2,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Guidelines for claiming reimbursement of expenses incurred on behalf of VDD-GNA"]
["Travel expenses will be reimbursed consistent, with VDD-GNA procedures. Expenses must be reasonable"]
["and adequately documented so as to satisfy the VDD-GNA Treasury, auditors and the IRS regulations."]
["Original receipts or quality photocopies are required for all items to be reimbursed. These receipts must be"]
["submitted with your expense report to qualify for reimbursement. "]
["Expense reports must be submitted within 60 days after travel to be eligible for reimbursement."]
["The GNA Treasury is responsible for questioning expenses, which appear excessive or are"]
["unsubstantiated. Reasonable and documented expenses in the following categories will be"]
["reimbursed without question:"]
["A. Travel"]
["1. Necessary air and rail fare not to exceed coach class. Maximum airfare reimbursement is the"]
["least expensive non-refundable fare (normally 14-day advance purchase)."]
["2. Personal automobile travel will be reimbursed for fuel receipts submitted. Mileage figures"]
["(Mapquest will be used to determine mileage) are also required for comparison to fuel"]
["consumed. If more than 1 person travels in the same automobile, only one person may claim"]
["reimbursement for such transportation expenses."]
["3. Necessary car rental expenses."]
["4. Necessary parking, shuttle, bus, road tolls and other transportation expenses."]
["B. Lodging"]
["1. Reasonable, comfortable accommodations."]
["C. Other Expenses"]
["1. Other miscellaneous expenses must be listed and fully described. Personal expenses will not be"]
["reimbursed."]
["At this time VDD-GNA does not have a policy to reimburse for any meals associated with travel."]
["For questions regarding the reimbursement guidelines, please contact the VDD-GNA Treasurer,"]
["Johnathan Pearson at (804) 229-9284 or VDDTreasurer@gmail.com"]