{"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":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[10,0,10,5],[10,6,10,8],[12,0,12,5],[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],[9,0,9,8],[12,6,12,8],[42,0,42,13],[43,0,43,13],[44,0,44,13],[14,0,14,3],[18,0,18,2],[19,0,19,13],[30,0,30,2],[30,3,30,4],[28,6,28,10],[30,6,30,10],[25,0,25,13],[26,0,26,2],[26,3,26,4],[28,0,28,2],[28,3,28,4],[45,0,45,13],[46,0,46,13],[47,0,47,13],[15,0,15,13],[16,0,16,13],[18,3,18,4],[17,3,17,4],[17,6,17,9],[20,0,20,2],[20,3,20,4],[21,0,21,13],[22,0,22,2],[22,3,22,4],[23,0,23,13],[24,0,24,2],[24,3,24,4],[41,0,41,13],[18,6,18,10],[20,6,20,10],[22,6,22,10],[24,6,24,10],[26,6,26,10],[35,0,35,13],[36,0,36,2],[36,3,36,4],[37,0,37,13],[38,0,38,2],[38,3,38,4],[36,6,36,10],[38,6,38,10],[31,0,31,13],[32,0,32,2],[13,0,13,8],[8,9,14,13],[40,6,40,10],[14,4,14,8],[11,0,11,8],[39,0,39,13],[40,0,40,2],[40,3,40,4],[32,3,32,4],[33,0,33,13],[34,0,34,2],[34,3,34,4],[32,6,32,10],[34,6,34,10],[27,0,27,13],[29,0,29,13]]}
["Rental Vehicle Use Tracking\nand Cost Allocation Tool",null,null,null,null,null,"Je vous prie de me contacter a l'adresse e-mail a gouche si vous avez des problems avec ce cahier Excel.  Les cahiers Excel que je cree sont proteges, mais sans mot de pass.  Ce systeme protege les formules et fonctions dans le cahier et ses fichiers, mais l'utilisateur pourra changer les fichiers si necessaire.  Pour unlever la protection, cliquer \"Outils / Protection / Desactiver protection de la feuille.\" Je suggere fortement qu'apres avoir modifier une feuille, que l'utilsateur rends active la protection encore.  Ne pas mettre un mot de pass quand demande par Excel."]
["Workbook cree en 2015 par: ",null,null,"Dave Coddington\nEmergency Operations TA\nBangui, CAR\ndave_coddington@netzero.com"]
["Use of the Workbook"]
["CRS loue souvent des vehicules, a court et a long terme.  Il faut gerer and suivre l'utilisation de ces vehicules pour pouvoir justifier un paiement de services, selon le contrat.  En plus, plusieurs projets pourront beneficier de l'utilisation des vehicules, et il faut faire une allocation des couts lies a cette utilsation.  Ce cahier est ces fichers a ete cree pour aider les gestionnaire des projets, les agents d'opertions, et les agents de la logistique a suivre les depenses lies aux vehicules de location et d'attibuer ces depenses aux projets d'un facon equitable et justificable.  La personne resonsable pour la gestion des vehicles de locations fera l'entrer des donners comme necessaire, et finira par imprimer les feuilles de chaque vehicule mensuellement ou selon les demands du staff cadre.  Ces documents servent a justifier le paiement oux fournissuers ainsi que l'attribution des couts au niveau de Finance."]
["Macros"]
["Ce cahier contient des Macros ecrit en code Visual Basic (VBA).  Ces macros font des operations de formatting en utilisant des liens et des command inities sur le clavier.  Pour faire fonctionner ces macro, le niveau de securite de votre ordinateur devrait etre mis a moyen ou minimum.  Cliquer \"Ficher / Options / Securite / Macro\" et choisir Moyen ou Minimum.  \nSi la buton Haut Security est activee, les macros ne fonctionnent pas.\nSi la buton Moyen Securite est activee, chaque fois que le cahier est ouvert, chaque fois que le cahier est ouvert Excel demadera si l'utilsateur voudrait bien activer ou desactiver les macros (choisir \"Activer\").  Nous recommandons ce niveau de securite.\nSi la buton Minimum Securite est activee, les macros fonctionnent sans massage d'alerte.  Mais, cela pourra mettre en risque votre ordinateur vis a vis des macros importes des sources inconnues.  Ce niveau n'est pas recommande."]
["Set default options"]
["Mettre les valuer defaults si-dessus:"]
["Entrer le nom du pays:",null,null,null,null,null,"RCA",null,null,"ENTRER L'INFORMATION EN MAJISCULES!"]
[]
["Entrer le nom du bureau ou sous-bureau:",null,null,null,null,null,"BOSSANGOA"]
[]
["Entrer la code de la monnaie locale (e.g., FCFA, USD, KWA):",null,null,null,null,null,"FCFA"]
[]
["Entrer le periode du rapport:",null,null,null,"DECEMBRE 2014"]
[]
[]
[null,null,null,"No. Plaque d'Immatriculation",null,null,"Marque et Modele"]
["Vehicule de Location #1:",null,null,"607AGQ60",null,null,"Camion de Location"]
[]
["Vehicule de Location #2:",null,null,"206CD038",null,null,"Camion UNHCR"]
[]
["Vehicule de Location #3:",null,null,"DA153MB",null,null,"Location Mobile 6"]
[]
["Vehicule de Location #4:",null,null,"DE502BG",null,null,"Location Mobile 8"]
[]
["Vehicule de Location #5:"]
[]
["Vehicule de Location #6:"]
[]
["Vehicule de Location #7:"]
[]
["Vehicule de Location #8:"]
[]
["Vehicule de Location #9:"]
[]
["Vehicule de Location #10:"]
[]
["Vehicule de Location #11:"]
[]
["Vehicule de Location #12:"]
[]
["Apres avoir entrer les defaults si-dessus, sauvegarder le cahier avec un autre nom. Par exemple, donner le nom \"Vehicule de Location Gestion et Allocation (CAR Bossangoa - Vierge).\""]
["Pour l'utiliser, ouvrir le cahier \"Vehicule de Location Gestion et Allocation (CAR Bossangoa - Vierge),\" et sauvegarde avec le nom \"Vehicule de Location Gestion et Allocation (CAR Bossangoa) (periode du rapport).\""]
["ATTENTION!"]
["NE PAS CHANGER l'ordre des colons dans les fichers."]
["NE PAS CHANGER le nom de ce fichier \"Instructions.\""]
["NE PAS EMPLOYE un mot de pass nul part das ce cahier."]

{"sheet":"Rental Vehicle (1)","index":1,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[59,9,59,10],[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],[50,9,50,10],[51,7,51,8],[51,9,51,10],[55,7,55,8],[55,9,55,10],[45,12,47,12],[45,10,47,11],[48,7,48,8],[49,7,49,8],[49,9,49,10],[48,9,48,10],[47,6,47,9],[48,0,48,1],[48,2,48,3],[48,5,48,6],[44,2,44,3],[44,0,44,1],[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],[6,0,6,6],[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],[1,9,1,12],[2,1,2,5],[1,6,1,8],[2,9,2,12],[2,6,2,8],[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],[41,1,41,2],[1,1,1,5],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D19=0,0,Instructions!D19&\", \"&Instructions!G19)","v":"607AGQ60, Camion de Location"}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},70000,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
["2014-12-01",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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-07",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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-16",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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,160,null,"Qté (L) de Carburant Fournis par CRS:",null,40,"Prix par Litre \nde Carburant:",null,870,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":34800}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":34800}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,null,{"$f":"IF(SUM(C51:D59)>=C45,0,(C45-SUM(C51:D59)))","v":45},null,{"$f":"IF(C$45=0,0,C50/C$45)","v":0.28125},{"$f":"E50*M$42","v":0},null,{"$f":"E50*M$45","v":9787.5},null,{"$f":"F50+H50","v":9787.5}]
[67716200059,null,115,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0.71875},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":25012.5},null,{"$f":"F51+H51","v":25012.5}]
[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 (pour vérification):",null,{"$f":"SUM(C50:D59)","v":160},null,{"$f":"SUM(E50:E59)","v":1},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":34800},null,{"$f":"SUM(J50:K59)","v":34800}]
[]
[]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D21=0,0,Instructions!D21&\", \"&Instructions!G21)","v":"206CD038, Camion UNHCR"}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30","07:00:00","17:00:00","10:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"10:00:00","10:00:00",0,0]
["2014-12-31","07:00:00","17:00:00","10:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"10:00:00","10:00:00",0,0]
["TOTAUX:",null,null,{"$f":"SUM(D11:D41)","v":0.83333333333333337},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 KM parcourue \nselon le Log Sheets:",null,200,null,"Qté (L) de Carburant Fournis par CRS:",null,100,"Prix par Litre \nde Carburant:",null,870,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":87000}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":87000}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67716200059,null,200,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":1},{"$f":"E51*M$42","v":0},null,{"$f":"E51*M$45","v":87000},null,{"$f":"F51+H51","v":87000}]
[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 (pour vérification):",null,{"$f":"SUM(C50:D59)","v":200},null,{"$f":"SUM(E50:E59)","v":1},{"$f":"SUM(F50:G59)","v":0},null,{"$f":"SUM(H50:I59)","v":87000},null,{"$f":"SUM(J50:K59)","v":87000}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D23=0,0,Instructions!D23&\", \"&Instructions!G23)","v":"DA153MB, Location Mobile 6"}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},70000,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-04","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-05","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-06","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-07","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-08","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-09","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-10","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-11","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-12","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-13","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-14","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-15","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-16","07:00:00","17:00:00","10:00:00",70000,"00:00:00",0,70000,null,null,null,0,70000,null,"10:00:00","10:00:00",0,0]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,null,{"$f":"SUM(D11:D41)","v":5.416666666666667},910000,0,0,910000,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":910000}]
[]
[]
["Total KM parcourue \nselon le Log Sheets:",null,1400,null,"Qté (L) de Carburant Fournis par CRS:",null,186,"Prix par Litre \nde Carburant:",null,870,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":161820}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":1071820}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67716200059,null,{"$f":"0.5*C45","v":700},null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0.5},{"$f":"E51*M$42","v":455000},null,{"$f":"E51*M$45","v":80910},null,{"$f":"F51+H51","v":535910}]
[35006200062,null,{"$f":"(1/6)*C45","v":233.33333333333331},null,0.16666666666666666,151666.66666666666,null,26970,null,{"$f":"F52+H52","v":178636.66666666666}]
[82196200055,null,{"$f":"(1/6)*C45","v":233.33333333333331},null,0.16666666666666666,151666.66666666666,null,26970,null,178636.66666666666]
[15506200051,null,{"$f":"(1/6)*C45","v":233.33333333333331},null,0.16666666666666666,151666.66666666666,null,26970,null,178636.66666666666]
[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 (pour vérification):",null,{"$f":"SUM(C50:D59)","v":1399.9999999999998},null,{"$f":"SUM(E50:E59)","v":0.99999999999999989},{"$f":"SUM(F50:G59)","v":909999.99999999988},null,{"$f":"SUM(H50:I59)","v":161820},null,{"$f":"SUM(J50:K59)","v":1071820}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D25=0,0,Instructions!D25&\", \"&Instructions!G25)","v":"DE502BG, Location Mobile 8"}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},65000,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-04","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-05","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-06","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-07","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-08","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-09","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-10","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-11","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-12","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-13","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-14","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-15","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-16","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-17","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-18","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-19","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-20","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-21","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-22","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-23","07:00:00","17:00:00","10:00:00",65000,"00:00:00",0,65000,null,null,null,0,65000,null,"10:00:00","10:00:00",0,0]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,null,{"$f":"SUM(D11:D41)","v":8.3333333333333357},1300000,0,0,1300000,0,{"$f":"SUM(J10:J41)","v":0},{"$f":"SUM(K10:K41)","v":0},{"$f":"SUM(L11:L41)","v":0},{"$f":"SUM(M11:M41)","v":1300000}]
[]
[]
["Total KM parcourue \nselon le Log Sheets:",null,1400,null,"Qté (L) de Carburant Fournis par CRS:",null,272,"Prix par Litre \nde Carburant:",null,870,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":236640}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":1536640}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67716200059,null,1050,null,{"$f":"IF(C$45=0,0,C51/C$45)","v":0.75},{"$f":"E51*M$42","v":975000},null,{"$f":"E51*M$45","v":177480},null,{"$f":"F51+H51","v":1152480}]
[82196200055,null,175,null,0.125,162500,null,29580,null,{"$f":"F52+H52","v":192080}]
[35006200062,null,175,null,0.125,162500,null,29580,null,192080]
[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 (pour vérification):",null,{"$f":"SUM(C50:D59)","v":1400},null,{"$f":"SUM(E50:E59)","v":1},{"$f":"SUM(F50:G59)","v":1300000},null,{"$f":"SUM(H50:I59)","v":236640},null,{"$f":"SUM(J50:K59)","v":1536640}]
[]
[{"$f":"'Rental Vehicle (1)'!A62:E62","v":0}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D27=0,0,Instructions!D27&\", \"&Instructions!G27)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D29=0,0,Instructions!D29&\", \"&Instructions!G29)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D31=0,0,Instructions!D31&\", \"&Instructions!G31)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D33=0,0,Instructions!D33&\", \"&Instructions!G33)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D35=0,0,Instructions!D35&\", \"&Instructions!G35)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D37=0,0,Instructions!D37&\", \"&Instructions!G37)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D39=0,0,Instructions!D39&\", \"&Instructions!G39)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et 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],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,10,44,11],[7,0,7,12],[8,1,8,7],[8,8,8,11],[41,1,41,2],[43,0,43,12],[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 VEHICULE DE LOCATION -- \nFICHE D'UTILSATION ET ALLOCATION DES COUTS"]
["Bureau:",{"$f":"Instructions!G11","v":"BOSSANGOA"},null,null,null,null,"Véhicule ID, Marque et Modèle:",null,null,{"$f":"IF(Instructions!D41=0,0,Instructions!D41&\", \"&Instructions!G41)","v":0}]
["Période:",{"$f":"Instructions!E15","v":"DECEMBRE 2014"},null,null,null,null,"Propriétaire du Véhicule:"]
[]
["Code LC:",{"$f":"Instructions!G13","v":"FCFA"},null,"Taux Journalier:",null,{"$f":"B5","v":"FCFA"},null,"Supplément Horaire:",null,null,{"$f":"B5","v":"FCFA"}]
[]
["MAX Heures de Service:",null,null,null,null,null,null,"23:59:00"]
[]
[null,"CALCULE - PAIEMENT POUR LOCATION",null,null,null,null,null,null,"DEDUCTIONS",null,null,null,"MONTANT DU"]
["Date","Heure Début","Heure Fin","Heures de Service",{"$f":"\"Montant (\"&B5&\")\"","v":"Montant (FCFA)"},"Heures Supp","Paiement - Heures Supp",{"$f":"\"Paiement Dû (\"&B5&\")\"","v":"Paiement Dû (FCFA)"},"Avances Carburant","Avances Salaire","Autres Avances","Déductions Totales",{"$f":"\"Montant Journalier (\"&B5&\")\"","v":"Montant Journalier (FCFA)"},null,"Total","Reg","OT1","OT2"]
[{"$f":"'Rental Vehicle (1)'!A11","v":"2014-12-01"},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":"2014-12-02"},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":"2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-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]
["2014-12-30",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["2014-12-31",null,null,"00:00:00",0,"00:00:00",0,0,null,null,null,0,0,null,"00:00:00","00:00:00",0,0]
["TOTAUX:",null,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 KM parcourue \nselon le Log Sheets:",null,null,null,"Qté (L) de Carburant Fournis par CRS:",null,null,"Prix par Litre \nde Carburant:",null,null,"Cout de Carburant =",null,{"$f":"IF(G45=0,0,G45*J45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Montant d'Allocation = ",null,{"$f":"M42+M45","v":0}]
[]
[null,null,null,null,null,null,"Allocation des Couts"]
["DSPNs\n(ayant bénéficié du véhicule)",null,"KM parcourus par DSPN ",null,"% utilisation par DSPN","Location",null,"Carburant",null,"Total"]
[15506209101,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}]
[67726200061,null,{"$f":"0.9*C45","v":0},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}]
[87506200065,null,{"$f":"0.07*C45","v":0},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 (pour vérification):",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}]
["Repport prepare par (signature et date)",null,null,null,null,null,"Rapport verifie et approve (signature et date)",null,null,null,"Payment approve par (signature et date)"]