{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Auto Submit Instructions","Per Call Form"],"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":[[18,1,18,10],[1,1,1,15]]}
[]
[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":"Per Call Form","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[50,0,50,4],[49,0,49,4],[44,5,44,7],[45,1,45,4],[48,0,48,4],[47,0,47,4],[44,1,44,4],[46,0,46,4],[45,5,47,8],[43,5,43,7],[21,6,21,8],[4,1,4,2],[2,1,2,2],[3,1,3,2],[3,3,3,5],[20,0,21,5],[25,0,25,8],[28,8,29,8],[5,0,5,5],[42,5,42,7],[41,6,41,7],[42,2,42,4],[43,1,43,4],[28,0,28,7],[2,3,2,6],[4,3,4,5],[0,9,1,10],[0,1,0,8],[20,6,20,7],[3,7,3,8],[1,3,1,6],[5,7,5,8],[6,0,6,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:                                "]
["EQUIPMENT TIME LOG",null,null,null,null,null,"UC Contract #:"]
["The personal data collected on this form is classified as a public record and may be made available to the public as provided by Utah Code 63G-2-201."]
["Apparatus Radio Call # and Class # *","Alarm","Enroute","Arrived","Completed","Available",null,"X $Rate"," Total cost"]
[null,null,null,null,null,null,{"$f":"(F9-B9+(F9<B9))*24","v":0},null,{"$f":"(G9*H9)","v":0}]
[null,null,null,null,null,null,{"$f":"(F10-B10+(F10<B10))*24","v":0},null,{"$f":"(G10*H10)","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]
["Mileage*","Miles To",null,null,null,"From","Total Miles"]
[null,null,null,null,null,null,0,null,{"$f":"(G18*H18)","v":0}]
[null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,{"$f":"SUM(F20+B20)","v":0},null,0]
["* Example: Engine 00 (type 1), \nSee Current DNR Fire Department Manual For Apparatus Rates",null,null,null,null,null,"Total Equipment Cost",null,{"$f":"SUM(I9:I20)","v":0}]
[]
[]
[]
[]
[]
[]
["***Rates for Federally Owned Equipment (FEPP) will be billed according to the State Federal Excess Rates and do not include personnel cost. "]
["PERSONNEL REQUIRED                                       ",null,null,null,null,null,null,null," Total Cost"]
["Name & Position/ Certification*","Alarm","Enroute","Arrived","Completed","Available",null,"X $Rate*"]
[null,null,null,null,null,null,{"$f":"(F31-B31+(F31<B31))*24","v":0},null,{"$f":"(G31*H31)","v":0}]
[null,null,null,null,null,null,{"$f":"(F32-B32+(F32<B32))*24","v":0},null,{"$f":"(G32*H32)","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,"Total Personnel",null,{"$f":"SUM(I31:I41)","v":0}]
[null,null,null,null,null,"Total Equipment:",null,null,{"$f":"SUM(I21)","v":0}]
[null,null,null,null,null,"Total Personnel:",null,null,{"$f":"SUM(I42)","v":0}]
[null,null,null,null,null,"TOTAL BILLING:",null,null,{"$f":"SUM(I43:I44)","v":0}]
["Actions Taken:",null,null,null,null,"Auto Submit Instructions"]
[]
[]
[null,null,null,null,null,"Reports must be submitted within 30 days*"]
[null,null,null,null,null,"Questions call: 801-851-8348",null,"Email: UCFM@utahcounty.gov"]
["REVIEWED / PAYMENT APPROVAL",null,null,null,null,"CHARGES REVIEWED PRIOR TO PAYMENT "]
[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," "]