{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Auto Submit Instructions","PERCALL"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":1,"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":"Auto Submit Instructions","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,15],[18,1,18,10]]}
[]
[null,"Quick submit feature available by filling out form, then clicking \"Click Here to Submit Form\", \nthis creates an email with prefilled subject and email text from the document and sends it to the correct department."]
[null,"Due to increased Microsoft security policies, to use this feature you have to \"Unblock\" the macro feature on the document to allow the auto submission."]
[]
[null,"After opening the file: click the \"Enable Editing\" banner button"]
[]
[null,"Open the location of the downloaded file"]
[null,null,"Click File ( in Header Menu )> Info ( Along left menu ) > Open File Location ( Right-most button underneath headers )"]
[null,"Open the Properties menu for the downloaded file"]
[null,null,"Right-click the downloaded file > Click \"Properties\" at bottom of list"]
[null,"Check the \"Unblock\" box property to allow Macros for just this file, and click 'OK'"]
[]
[null,"Close and reopen the file"]
[]
[null,"Click \"Enable Content\" Banner button"]
[]
[null,"Fill out form, and click \"Click Here to Submit Form\""]

{"sheet":"PERCALL","index":1,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[55,5,55,8],[45,6,45,7],[22,0,23,5],[22,6,22,7],[32,7,33,7],[52,0,52,4],[46,5,46,7],[47,5,47,7],[48,5,48,7],[49,1,49,4],[50,0,50,4],[48,2,48,4],[32,8,33,8],[28,0,29,8],[51,0,51,4],[21,1,21,5],[0,1,0,8],[0,9,1,10],[1,3,1,6],[2,1,2,2],[2,3,2,6],[3,1,3,2],[3,3,3,5],[3,7,3,8],[4,1,4,2],[4,3,4,5],[5,0,5,8],[19,1,19,5],[20,1,20,5],[53,5,53,8],[54,0,54,4],[54,5,54,8],[53,0,53,4],[49,5,51,8],[56,5,56,8],[57,5,57,8],[58,5,58,8],[60,5,60,8],[61,5,61,8]]}
[null,"UTAH COUNTY FIRE REPORT AND BILLING FORM"]
[null,"Billing Agency Name",null,null,null,null,null,"FDID#"]
[null,"Incident Location:",null,null,null,null,null,"UFIRS INC#"]
[null,"City Incident #",null,null,null,null,"Incident Date"]
[null,"County Incident #",null,null,null,null,"Prepared by:                                "]
["PERSONNEL AND EQUIPMENT TIME LOG:"]
["Apparatus Radio Call # and Class #","Alarm","Enroute","Arrived","Completed","Available",null,"X $Rate"," Total cost"]
[null,null,null,null,null,null,{"$f":"ROUND((F8-B8)*24/0.1,0)*0.1","v":0},null,{"$f":"(G8*H8)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND((F9-B9)*24/0.1,0)*0.1","v":0},null,{"$f":"(G9*H9)","v":0}]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,{"$f":"(G19*H19)","v":0}]
["Ambulance",null,null,null,null,null,"HOURLY RATE",160,0]
["Extrication/Rescue","Flat Rate per vehicle(s) on scene (As per contract calc. this line)",null,null,null,null,"FLAT RATE",200,0]
["False Alarm","Flat Rate per vehicle(s) on scene (As per contract calc. this line)",null,null,null,null,"FLAT RATE",200,0]
[null,null,null,null,null,null,"Total Equipment Cost",null,{"$f":"SUM(I8:I22)","v":0}]
[]
[]
[]
[]
[]
["See Your Contract and Appendix for Rates"]
[]
["*Rates for Federally Owned Equipment (FEPP) will be billed according to the State Federal Excess Rates and do not include personnel cost. "]
["ADDITIONAL PERSONNEL REQUIRED                                           ('Personnel' does not apply to ambulance calls)"]
[null,null,null,null,null,null,null,"X $Rate"," Total Cost"]
["Name","Alarm","Enroute","Arrived","Completed","Available"]
[null,null,null,null,null,null,{"$f":"ROUND((F35-B35)*24/0.1,0)*0.1","v":0},null,{"$f":"(G35*H35)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND((F36-B36)*24/0.1,0)*0.1","v":0},null,{"$f":"(G36*H36)","v":0}]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,0,null,0]
["Class #:",null,null,null,null,null,"Total Personnel",null,{"$f":"SUM(I35:I45)","v":0}]
["1. Standby",7,"By using the Certified rate of $15 you",null,null,"Total Equipment:",null,null,{"$f":"SUM(I23)","v":0}]
["2. Non Certified",12,"are confirming the additional person",null,null,"Total Personnel:",null,null,{"$f":"SUM(I46)","v":0}]
["3. Certified",15,"is a Certified Responder. ",null,null,"TOTAL BILLING:",null,null,{"$f":"SUM(I47:I48)","v":0}]
["Actions Taken:",null,null,null,null,"Auto Submit Instructions",null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,"Reports must be submitted within 30 days*"]
[null,null,null,null,null,"Questions regarding this form call: 801-851-8348"]
["REVIEWED / PAYMENT APPROVAL",null,null,null,null,"CHARGES REVIEWED PRIOR TO PAYMENT EMAIL TO:"]
[null,null,null,null,null,"SEND TO UTAH COUNTY FIRE DEPARTMENT IF THIS WAS"]
[null,null,null,null,null,"A BRUSH FIRE. "]
[null,"UC Fire Chief / Utah County Fire Department",null,null,null,"EMAIL: AmyS@utahcounty.gov & UCFM@utahcounty.gov"]
[null,null,null,null,null,"SENT TO UTAH COUNTY FIRE MARSHAL IF THIS FIRE"]
[null,null,null,null,null,"INVOLVED ANYTHING OTHER THAN A BRUSH FIRE"]
[null,null,null,null,null,"EMAIL UCFM@utahcounty.gov"]
[null,"UC Fire Marshal",null,null,null,"             "]
[]
[]
[]
[null,null,null,null," "]