{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Rental Vehicle (1)","Rental Vehicle (2)","Rental Vehicle (3)","Rental Vehicle (4)","Rental Vehicle (5)","Rental Vehicle (6)","Rental Vehicle (7)","Rental Vehicle (8)","Rental Vehicle (9)","Rental Vehicle (10)","Rental Vehicle (11)","Rental Vehicle (12)"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":1,"defined_names":14,"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":"Instructions","index":0,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[30,3,30,4],[12,0,12,5],[12,6,12,8],[14,0,14,5],[29,0,29,13],[16,4,16,8],[13,0,13,8],[20,12,20,13],[22,12,22,13],[24,12,24,13],[26,12,26,13],[28,12,28,13],[30,12,30,13],[26,0,26,2],[26,3,26,4],[14,6,14,8],[0,0,0,5],[0,6,1,13],[1,0,1,2],[1,3,1,5],[2,0,2,13],[3,0,3,13],[4,0,4,13],[5,0,5,13],[6,0,6,13],[7,0,7,13],[8,0,8,5],[8,6,8,8],[24,3,24,4],[17,0,17,13],[18,0,18,13],[20,3,20,4],[19,3,19,4],[19,6,19,9],[25,0,25,13],[9,0,9,8],[10,0,10,5],[34,6,34,10],[36,6,36,10],[22,6,22,10],[24,6,24,10],[26,6,26,10],[28,6,28,10],[36,0,36,2],[36,3,36,4],[15,0,15,8],[8,9,16,13],[11,0,11,8],[23,0,23,13],[24,0,24,2],[44,0,44,13],[16,0,16,3],[20,0,20,2],[21,0,21,13],[32,0,32,2],[32,3,32,4],[30,6,30,10],[32,6,32,10],[27,0,27,13],[28,0,28,2],[28,3,28,4],[30,0,30,2],[22,0,22,2],[22,3,22,4],[43,0,43,13],[20,6,20,10],[47,0,47,13],[48,0,48,13],[49,0,49,13],[45,0,45,13],[46,0,46,13],[37,0,37,13],[38,0,38,2],[38,3,38,4],[39,0,39,13],[40,0,40,2],[40,3,40,4],[38,6,38,10],[40,6,40,10],[42,6,42,10],[33,0,33,13],[42,12,42,13],[19,12,19,13],[32,12,32,13],[34,12,34,13],[36,12,36,13],[38,12,38,13],[40,12,40,13],[31,0,31,13],[34,0,34,2],[41,0,41,13],[42,0,42,2],[42,3,42,4],[34,3,34,4],[35,0,35,13]]}
["Rental Vehicle Use Tracking\nand Cost Allocation Tool",null,null,null,null,null,"Please contact the DRD-MQ in you region or OPEX if problems occur with this workbook.  Excel workbooks like this are protected, but no password is used.  Protection prevents users from inadvertently deleting formulas and other functions within the workbook and individual worksheets.  Users may modify anything in this workbook by unprotecting one or more worksheets, but it is highly recommended this be avoided.  To remove protection, click \"Tools/Protection/Unprotect Sheet.\"  We strongly suggest that after modifying a worksheet the user once again protect it.  When the password window open, click \"OK\" without setting a password."]
["Workbook created in 2015 by: ",null,null,"Dave Coddington\nEmergency Operations TA\nBangui, CAR\ndaveacoddington@gmail.com"]
["Use of the Workbook"]
["CRS often rent vehicles, for shirt or long terms.  Vehicle Management Unit staff must oversee and manage the use of these assets to document and justify payment of rental fees, according to the lease agreement.  In addition, multiple projects and DSPNs may benefit from the use of rental vehicles, and it is necessary to allocate all related costs across those DSPNs.  This workbook was created to assist operations and support staff, project managers, logistics staff and others to document expenses related to rental vehicles and allocate the costs across multiple projects in a way that is equitable and justifiable.  The staff person assigned responsibility for managing rental vehicles will enter data into each vehicle's worksheet as appropriate (weekly at a minimum), will print out hard copies as requested by supervisors or senior managers, and must print them out or prior to payment (monthly at a minimum) as an attachment to payment requests sent to Finance.  A copy of each printout must be kept on file in the rental vehicle dossier kept in the VMU."]
["Macros"]
["This workbook contains macros written in Visual Basic (VBA).  The macros facilitate formatting and other actions through keyboard commands..  The computer's macro security level must be set to a Medium or Low security level.  Click \"Worksheet / Options / Security / Macro\" and select Medium or Low.  \nIf the High Security button is activated, the macros will not work.\nIf the Medium Security button is activated, each time the workbook opens the user will be asked  to activate or deactivate the macros (select \"Activate\").  We recommend setting macro security to Medium.\nIf the Low Security button is activated, the macros will function without an alert message and selection request when the workbook opens.  This can be dangerous and is not the recommended setting."]
["Set default options"]
["Enter the default settings below.  The entries link to all worksheets in the workbook."]
["Country name:",null,null,null,null,null,null,null,null,"ENTER THE INFORMATION IN ALL CAPS!"]
[]
["Country Code:"]
[]
["Office or Sub-Office name:"]
[]
["Enter the code of the local currency (e.g., FCFA, USD, KWA):"]
[]
["Enter the period reported:"]
[]
[]
[null,null,null,"License Plate Number",null,null,"Make and Model",null,null,null,null,null,"Contract Number"]
["Rental Vehicle #1:"]
[]
["Rental Vehicle #2:"]
[]
["Rental Vehicle #3:"]
[]
["Rental Vehicle #4:"]
[]
["Rental Vehicle #5:"]
[]
["Rental Vehicle #6:"]
[]
["Rental Vehicle #7:"]
[]
["Rental Vehicle #8:"]
[]
["Rental Vehicle #9:"]
[]
["Rental Vehicle #10:"]
[]
["Rental Vehicle #11:"]
[]
["Rental Vehicle #12:"]
[]
["After setting the defaults, save the workbook under a different name.  For example, rename the workbook \"Rental Vehicle Use and Cost Tracking (CAR Bossangoa - Dec 15).\""]
["For the next month, open the prior period workbook and save it with a new name \"Rental Vehicle Use and Cost Tracking (CAR Bossangoa) (reporting period).\""]
["ATTENTION!"]
["DO NOT CHANGE the order of the columns in the worksheets."]
["DO NOT CHANGE the name of this worksheet entitled \"Instructions.\""]
["DO NOT ENTER A PASSWORD anywhere in this workbook."]

{"sheet":"Rental Vehicle (1)","index":1,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[59,5,59,6],[59,7,59,8],[56,9,56,10],[57,7,57,8],[57,9,57,10],[58,7,58,8],[58,9,58,10],[51,7,51,8],[51,9,51,10],[55,7,55,8],[55,9,55,10],[59,9,59,10],[49,7,49,8],[49,9,49,10],[48,9,48,10],[47,6,47,9],[50,9,50,10],[48,2,48,3],[48,5,48,6],[44,2,44,3],[44,0,44,1],[45,12,47,12],[45,10,47,11],[48,7,48,8],[59,2,59,3],[59,0,59,1],[44,4,44,5],[44,7,44,8],[50,7,50,8],[56,7,56,8],[49,5,49,6],[50,5,50,6],[51,5,51,6],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[55,0,55,1],[56,0,56,1],[57,0,57,1],[7,0,7,12],[58,0,58,1],[47,2,47,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[47,0,47,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[48,0,48,1],[2,1,2,5],[1,6,1,8],[2,9,2,12],[2,6,2,8],[6,0,6,6],[0,0,0,12],[5,0,5,12],[3,0,3,12],[62,6,62,8],[4,1,4,2],[4,7,4,9],[4,3,4,4],[61,10,61,12],[62,10,62,12],[62,0,62,4],[61,6,61,8],[8,1,8,7],[8,8,8,11],[61,0,61,4],[1,1,1,5],[1,9,1,12],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[43,0,43,12],[52,5,52,6],[52,7,52,8],[52,9,52,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[52,2,52,3],[54,0,54,1],[44,10,44,11]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D21=0,0,Instructions!D21&\", \"&Instructions!G21)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
["2016-02-09",null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,{"$f":"E12+G12","v":0},null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},{"$f":"IF(O12>H$7,H$7,O12)","v":"00:00:00"},{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,{"$f":"IF(P17=0,0,P17)","v":"00:00:00"},0,"00:00:00",0,{"$f":"E17+G17","v":0},null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,{"$f":"IF(P26=0,0,P26)","v":"00:00:00"},0,"00:00:00",0,{"$f":"E26+G26","v":0},null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,null,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"\"1550-\"&Instructions!G11&\"-9101\"","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,{"$f":"E53*M$42","v":0},null,{"$f":"E53*M$45","v":0},null,{"$f":"F53+H53","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (2)","index":2,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D23=0,0,Instructions!D23&\", \"&Instructions!G23)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (3)","index":3,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D25=0,0,Instructions!D25&\", \"&Instructions!G25)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},70000,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (4)","index":4,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D27=0,0,Instructions!D27&\", \"&Instructions!G27)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (5)","index":5,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D29=0,0,Instructions!D29&\", \"&Instructions!G29)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (6)","index":6,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D31=0,0,Instructions!D31&\", \"&Instructions!G31)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (7)","index":7,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D33=0,0,Instructions!D33&\", \"&Instructions!G33)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (8)","index":8,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D35=0,0,Instructions!D35&\", \"&Instructions!G35)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (9)","index":9,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D37=0,0,Instructions!D37&\", \"&Instructions!G37)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (10)","index":10,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D39=0,0,Instructions!D39&\", \"&Instructions!G39)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (11)","index":11,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D41=0,0,Instructions!D41&\", \"&Instructions!G41)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]

{"sheet":"Rental Vehicle (12)","index":12,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,0,6,6],[0,0,0,12],[1,1,1,5],[1,6,1,8],[1,9,1,12],[2,1,2,5],[2,6,2,8],[2,9,2,12],[3,0,3,12],[4,1,4,2],[4,3,4,4],[4,7,4,9],[5,0,5,12],[7,0,7,12],[8,1,8,7],[8,8,8,11],[43,0,43,12],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[48,0,48,1],[48,2,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[45,10,47,11],[45,12,47,12],[47,0,47,1],[47,2,47,3],[47,6,47,9],[50,0,50,1],[50,2,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[49,0,49,1],[49,2,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,0,52,1],[52,2,52,3],[52,5,52,6],[52,7,52,8],[52,9,52,10],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,1],[54,2,54,3],[54,5,54,6],[54,7,54,8],[54,9,54,10],[53,0,53,1],[53,2,53,3],[53,5,53,6],[53,7,53,8],[53,9,53,10],[56,0,56,1],[56,2,56,3],[56,5,56,6],[56,7,56,8],[56,9,56,10],[55,0,55,1],[55,2,55,3],[55,5,55,6],[55,7,55,8],[55,9,55,10],[58,0,58,1],[58,2,58,3],[58,5,58,6],[58,7,58,8],[58,9,58,10],[57,0,57,1],[57,2,57,3],[57,5,57,6],[57,7,57,8],[57,9,57,10],[62,0,62,4],[62,6,62,8],[62,10,62,12],[59,0,59,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[61,0,61,4],[61,6,61,8],[61,10,61,12]]}
["CRS RENTAL VEHICLE USE AND COST TRACKING "]
["Office:",{"$f":"Instructions!G13","v":0},null,null,null,null,"Vehicle ID, Make and Model:",null,null,{"$f":"IF(Instructions!D43=0,0,Instructions!D43&\", \"&Instructions!G43)","v":0}]
["Period:",{"$f":"Instructions!E17","v":"00:00:00"},null,null,null,null,"Vehicle Owner (Leasor):"]
[]
["Code LC:",{"$f":"Instructions!G15","v":0},null,"Daily Rate:",null,{"$f":"B5","v":0},null,"Overtime Supplement:",null,null,{"$f":"B5","v":0}]
[]
["MAX hours of service:"]
[]
[null,"CALCULATION - RENTAL PAYMENT ESPENSE",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"AMOUNT DUE"]
["Date","Start Time","End Time","Hours in Service",{"$f":"\"Amount (\"&B5&\")\"","v":"Amount (0)"},"OT Hours","Payment - OT Hours",{"$f":"\"Payment Due (\"&B5&\")\"","v":"Payment Due (0)"},"Fuel Advances","Salary Advances","Other Advances","Total Deductions",{"$f":"\"Daily Amount Due (\"&B5&\")\"","v":"Daily Amount Due (0)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2016-02-09"},null,null,{"$f":"IF(P11=0,0,P11)","v":"00:00:00"},{"$f":"IF(D11=0,0,G$5)","v":0},{"$f":"Q11","v":"00:00:00"},{"$f":"IF(F11=0,0,R11*L$5)","v":0},{"$f":"E11+G11","v":0},null,null,null,{"$f":"-SUM(I11:K11)","v":0},{"$f":"IF(H11=0,0,H11+L11)","v":0},null,{"$f":"IF(C11=0,0,IF(C11>B11,C11-B11,C11+1-B11))","v":"00:00:00"},{"$f":"IF(O11>H$7,H$7,O11)","v":"00:00:00"},{"$f":"IF(O11>P11,O11-P11,0)","v":0},{"$f":"(O11-P11)*24","v":0}]
[{"$f":"IF(A11=0,0,A11+1)","v":"2016-02-10"},null,null,{"$f":"IF(P12=0,0,P12)","v":"00:00:00"},{"$f":"IF(D12=0,0,G$5)","v":0},{"$f":"Q12","v":"00:00:00"},0,0,null,null,null,{"$f":"-SUM(I12:K12)","v":0},{"$f":"IF(H12=0,0,H12+L12)","v":0},null,{"$f":"IF(C12=0,0,IF(C12>B12,C12-B12,C12+1-B12))","v":"00:00:00"},"00:00:00",{"$f":"IF(O12>P12,O12-P12,0)","v":0},{"$f":"(O12-P12)*24","v":0}]
[{"$f":"IF(A12=0,0,A12+1)","v":"2016-02-11"},null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-12",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-13",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-14",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-15",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-16",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-17",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-18",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-19",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-20",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-21",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-22",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-23",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-24",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-25",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-26",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-27",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-28",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-02-29",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-01",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-02",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-03",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-04",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-05",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-06",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-07",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-08",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-09",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2016-03-10",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTALS:",{"$f":"IF(COUNT(B11:B41)=0,0,COUNT(B11:B41)&\" Day\")","v":0},null,{"$f":"SUM(D11:D41)","v":0},0,0,0,0,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":0}]
[]
[]
["Total work KM \naccording to Log Sheets:",null,null,null,"Qty (L) of fuel \nprovided by CRS:",null,null,"Per liter cost \nof fuel:",null,870,"Cost of fuel =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount to allocate = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Cost Allocation"]
["DSPNs\n(benefitting from vehicle use)",null,"KM used per DSPN (according to Logs)",null,"% utilisation by DSPN","Rental",null,"Fuel",null,"Total"]
[{"$f":"'Rental Vehicle (1)'!A50:B50","v":"1550--9101"},null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":0},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":0},null,{"$f":"F50+H50","v":0}]
[null,null,null,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":0},null,{"$f":"F51+H51","v":0}]
[null,null,null,null,0,0,null,0,null,{"$f":"F52+H52","v":0}]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,0]
[null,null,null,null,0,0,null,0,null,{"$f":"F59+H59","v":0}]
["TOTAL (for verification):",null,{"$f":"SUM(C50:D59)","v":0},null,{"$f":"SUM(E50:E59)","v":0},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":0},null,{"$f":"SUM(J50:K59)","v":0}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Report prepared by (signature and date)",null,null,null,null,null,"Report verified and approved (signature and date)",null,null,null,"Payment approved by (signature and date)"]