{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["N°factures","FACTURATION JANVIER 2019","F201901","F201902","Feuil1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"N°factures","index":0,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["F201901",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$f":"INDIRECT(A1&\"!$B$16\")","v":"2019 - 01"}]
["F201902",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$f":"INDIRECT(A2&\"!$B$16\")","v":"2019 - 02"}]
["F201903",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201904",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201905",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201906",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201907",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201908",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201909",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201910",{"$f":"'F201901'!$B$16","v":"2019 - 01"},{"$error":"#REF!"}]
["F201911",null,{"$error":"#REF!"}]
["F201912"]
["F201913"]
["F201914"]
["F201915"]
["F201916"]
["F201917"]
["F201918"]
["F201919"]
["F201920"]
["F201921"]
["F201922"]
["F201923"]
["F201924"]
["F201925"]
["F201926"]
["F201927"]
["F201928"]
["F201929"]
["F201930"]
["F201931"]
["F201932"]
["F201933"]
["F201934"]
["F201935"]
["F201936"]
["F201937"]
["F201938"]
["F201939"]
["F201940"]
["F201941"]
["F201942"]
["F201943"]
["F201944"]
["F201945"]
["F201946"]
["F201947"]
["F201948"]
["F201949"]
["F201950"]

{"sheet":"FACTURATION JANVIER 2019","index":1,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,10,1,12],[1,2,2,5]]}
[]
[null,null,"SYNTHESE DE LA FACTURATION MENSUELLE - TAHITI PARACHUTISME",null,null,null,null,null,null,null,"Facturation TTC totale du mois"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L70)","v":146200}]
[]
[]
["Dates des factures","N° des factures","Nom des clients","Libellés des factures","Montants HT (Prestations 5%)","Montants TVA (Prestations 5%)","Montants HT (Prestations 13%)","Montants TVA (Prestations 13%)","Montants HT (Ventes 16%)","Montants TVA (Prestation 16%)","Débours / Divers","Montant total TTC","Modes de règlement","Dates de règlement"]
[{"$f":"'F201901'!B15","v":"2019-01-02"},{"$f":"'F201901'!B16","v":"2019 - 01"},{"$f":"'F201901'!F16","v":"MARTIN Philippe"},{"$f":"'F201901'!A27","v":"Saut en parachute tandem Moorea "},{"$f":"'F201901'!H38","v":128571.42857142857},{"$f":"+E9*0.05","v":6428.5714285714284},{"$f":"'F201901'!H39","v":0},{"$f":"+G9*0.13","v":0},{"$f":"'F201901'!H40","v":9655.1724137931033},{"$f":"I9*0.16","v":1544.8275862068965},{"$f":"'F201901'!H41","v":0},{"$f":"+E9+F9+G9+H9+I9+J9+K9","v":146200},{"$f":"'F201901'!B46","v":"ESP"}]
[null,null,null,null,null,{"$f":"+E10*0.05","v":0},null,{"$f":"+G10*0.13","v":0},null,{"$f":"I10*0.16","v":0},null,{"$f":"+E10+F10+G10+H10+I10+J10+K10","v":0}]
[null,null,null,null,null,{"$f":"+E11*0.05","v":0},null,{"$f":"+G11*0.13","v":0},null,{"$f":"I11*0.16","v":0},null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,{"$f":"+E14+F14+G14+H14+I14+J14+K14","v":0}]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,{"$f":"+E18*0.05","v":0},null,{"$f":"+G18*0.13","v":0},null,{"$f":"I18*0.16","v":0},null,{"$f":"+E18+F18+G18+H18+I18+J18+K18","v":0}]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]

{"sheet":"F201901","index":2,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,0,52,3],[54,0,54,3],[55,0,55,3],[40,5,40,6],[41,5,41,6],[43,5,43,6],[44,5,44,6],[3,0,3,3],[23,0,25,3],[23,4,25,4],[23,5,25,5],[23,6,25,6],[23,7,25,7],[27,0,27,3],[23,8,25,8],[23,9,25,9],[42,5,42,6],[38,5,38,6],[39,5,39,6],[35,7,35,8],[37,5,37,6],[26,0,26,3],[32,0,32,3],[33,0,33,3],[36,0,36,3],[37,0,37,3]]}
[]
[]
["TAHITI PARACHUTISME S.A.R.L"]
["BP 2914"]
["98703 – PUNAAUIA TAHITI"]
["Polynésie Française"]
["Tel: +689 87 33 97 23"]
["contact@tahiti-parachutisme.com"]
["www.tahiti-parachutisme.com"]
[]
["RCS PAPEETE TPI 12 288 B "]
["N° TAHITI : A52941"]
[]
[]
["DATE","2019-01-02"]
["N° DE FACTURE","2019 - 01",null,null,null,"MARTIN Philippe"]
[null,null,null,null,null,"1 impasse des saules",null,null," "]
[null,null,null,null,null,"40220 Tarnos"]
[]
[]
[]
[]
[]
["DESIGNATION ",null,null,null,"P.U.  TTC","P.U.  H.T.","QUANTITE","H.T.","TVA","TVA"]
[]
[]
["Saut en parachute tandem Moorea ",null,null,null,40000,{"$f":"E27/(1+J27)","v":38095.238095238092},1,{"$f":"F27*G27","v":38095.238095238092},{"$f":"H27*J27","v":1904.7619047619046},0.05]
["Saut en parachute tandem Bora ",null,null,null,45000,{"$f":"E28/(1+J28)","v":42857.142857142855},1,{"$f":"F28*G28","v":42857.142857142855},{"$f":"H28*J28","v":2142.8571428571427},0.05]
["Option video et photos incluse",null,null,null,25000,23809.523809523809,2,47619.047619047618,2380.9523809523812,0.05]
["Prestations diverses ",null,null,null,0,0,0,0,0,0.13]
["Ventes d'accessoires (tee-shirts..)",null,null,null,2800,{"$f":"E31/1.16","v":2413.7931034482758},4,9655.1724137931033,1544.8275862068965,0.16]
[]
["Débours non soumis à TVA",null,null,null,0,null,null,{"$f":"E33","v":0},null,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H27:H34)","v":138226.60098522168},{"$f":"SUM(I27:I34)","v":7973.3990147783252}]
[null,null,null,null,null,null,null,{"$f":"+H35+I35","v":146200}]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,"H.T. soumis à 5%",null,{"$f":"SUM(H27:H29)","v":128571.42857142857}]
[null,null,null,null,null,"H.T. soumis à 13%",null,{"$f":"H30","v":0}]
[null,null,null,null,null,"H.T. soumis à 16%",null,{"$f":"H31","v":9655.1724137931033}]
[null,null,null,null,null,"H.T. non soumis",null,{"$f":"H33","v":0}]
[null,null,null,null,null,"TVA 5,00%",null,{"$f":"SUM(I27:I29)","v":6428.5714285714284}]
[null,null,null,null,null,"TVA 13,00%",null,{"$f":"I30","v":0}]
[null,null,null,null,null,"TVA 16,00%",null,{"$f":"I31","v":1544.8275862068965}]
[null,null,null,null,null,"TOTAL T.T.C.",null,{"$f":"H38+H39+H40+H41+H42+H43+H44","v":146200}]
["PAIEMENT : ","ESP"]
[]
[]
[]
[]
[]
[" "]
["TAHITI PARACHUTISME"]
["RIB : 12149 06730 30004178577 36"]
["IBAN : FR76 1214 9067 3030 0041 7857 736 "]
["SWIFT : BPOLPFTP"]

{"sheet":"F201902","index":3,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,0,3,3],[23,0,25,3],[23,4,25,4],[23,5,25,5],[23,6,25,6],[39,5,39,6],[23,8,25,8],[23,9,25,9],[26,0,26,3],[27,0,27,3],[32,0,32,3],[33,0,33,3],[23,7,25,7],[35,7,35,8],[36,0,36,3],[37,0,37,3],[37,5,37,6],[38,5,38,6],[54,0,54,3],[55,0,55,3],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[52,0,52,3]]}
[]
[]
["TAHITI PARACHUTISME S.A.R.L"]
["BP 2914"]
["98703 – PUNAAUIA TAHITI"]
["Polynésie Française"]
["Tel: +689 87 33 97 23"]
["contact@tahiti-parachutisme.com"]
["www.tahiti-parachutisme.com"]
[]
["RCS PAPEETE TPI 12 288 B "]
["N° TAHITI : A52941"]
[]
[]
["DATE","XX/01/2019"]
["N° DE FACTURE","2019 - 02",null,null,null,"MARTIN Philippe"]
[null,null,null,null,null,"1 impasse des saules",null,null," "]
[null,null,null,null,null,"40220 Tarnos"]
[]
[]
[]
[]
[]
["DESIGNATION ",null,null,null,"P.U.  TTC","P.U.  H.T.","QUANTITE","H.T.","TVA","TVA"]
[]
[]
["Saut en parachute tandem Moorea ",null,null,null,null,{"$f":"E27/(1+J27)","v":0},null,{"$f":"F27*G27","v":0},{"$f":"H27*J27","v":0},0.05]
["Saut en parachute tandem Bora ",null,null,null,null,{"$f":"E28/(1+J28)","v":0},null,{"$f":"F28*G28","v":0},{"$f":"H28*J28","v":0},0.05]
["Option video et photos incluse",null,null,null,null,0,null,0,0,0.05]
["Prestations diverses ",null,null,null,null,0,null,0,0,0.13]
["Ventes d'accessoires (tee-shirts..)",null,null,null,null,{"$f":"E31/1.16","v":0},null,0,0,0.16]
[]
["Débours non soumis à TVA",null,null,null,null,null,null,{"$f":"E33","v":0},null,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H27:H34)","v":0},{"$f":"SUM(I27:I34)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+H35+I35","v":0}]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,"H.T. soumis à 5%",null,{"$f":"SUM(H27:H29)","v":0}]
[null,null,null,null,null,"H.T. soumis à 13%",null,{"$f":"H30","v":0}]
[null,null,null,null,null,"H.T. soumis à 16%",null,{"$f":"H31","v":0}]
[null,null,null,null,null,"H.T. non soumis",null,{"$f":"H33","v":0}]
[null,null,null,null,null,"TVA 5,00%",null,{"$f":"SUM(I27:I29)","v":0}]
[null,null,null,null,null,"TVA 13,00%",null,{"$f":"I30","v":0}]
[null,null,null,null,null,"TVA 16,00%",null,{"$f":"I31","v":0}]
[null,null,null,null,null,"TOTAL T.T.C.",null,{"$f":"H38+H39+H40+H41+H42+H43+H44","v":0}]
["PAIEMENT : "]
[]
[]
[]
[]
[]
[" "]
["TAHITI PARACHUTISME"]
["RIB : 12149 06730 30004178577 36"]
["IBAN : FR76 1214 9067 3030 0041 7857 736 "]
["SWIFT : BPOLPFTP"]

{"sheet":"Feuil1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}