{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1","Feuil3","formules","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Feuil1","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[16,9,17,9],[19,1,19,5],[7,9,8,9],[9,9,10,9],[12,1,12,5],[13,1,13,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[7,6,8,6],[9,6,10,6],[7,7,8,7],[9,7,10,7],[7,8,8,8],[9,8,10,8],[7,0,13,0],[14,0,20,0],[21,0,22,0],[16,6,17,6],[16,7,17,7],[20,1,20,5],[25,0,25,8],[16,8,17,8],[21,1,21,5],[22,1,22,5],[23,0,23,8],[24,0,24,8]]}
[]
[null,null,null,null,null,{"$f":"TEXT(\"CALCUL FACTURE SONELGAZ\",1)","v":"CALCUL FACTURE SONELGAZ"}]
[]
[null,null,null,null,null,null,{"$f":"TEXT(\"NOUVEL INDEX\",1)","v":"NOUVEL INDEX"},{"$f":"TEXT(\"ANCIEN INDEX\",1)","v":"ANCIEN INDEX"}]
[null,null,null,null,null,{"$f":"TEXT(\"INDEX ELECTRICITE\",1)","v":"INDEX ELECTRICITE"},20293,19524,{"$f":"G5-H5","v":769},{"$f":"N(1)","v":1},{"$f":"I5*J5","v":769},{"$f":"IF(D12=K5,\"Bon\",\"Erreur\")","v":"Bon"}]
[null,null,null,null,null,{"$f":"TEXT(\"INDEX GAZ\",1)","v":"INDEX GAZ"},85089,83141,{"$f":"G6-H6","v":1948},{"$f":"N(8.7)","v":8.6999999999999993},{"$f":"I6*J6","v":16947.599999999999},{"$f":"IF(D19=K6,\"Bon\",\"Erreur\")","v":"Bon"}]
[null,null,null,null,null," "]
[{"$f":"TEXT(\"ELECTRICITE\",1)","v":"ELECTRICITE"},{"$f":"TEXT(\"Tranche 1\",1)","v":"Tranche 1"},125,{"$f":"IF((IF(IF($K$5<125,$K$5,125)<0,0,IF($K$5<125,$K$5,125)))<0,0,(IF(IF($K$5<125,$K$5,125)<0,0,IF($K$5<125,$K$5,125))))","v":125},{"$f":"N(1.7787)","v":1.7786999999999999},{"$f":"D8*E8","v":222.33750000000001},{"$f":"SUM(F8,F9)","v":744.69999999999993},{"$f":"N(0.09)","v":0.09},{"$f":"G8*H8","v":67.022999999999996},{"$f":"SUM(G8,I8)","v":811.72299999999996}]
[null,{"$f":"TEXT(\"Tranche 2\",1)","v":"Tranche 2"},125,{"$f":"IF(IF(($K$5-125)<250,($K$5-125),125)<0,0,IF(($K$5-125)<250,($K$5-125),125))","v":125},{"$f":"N(4.1789)","v":4.1788999999999996},{"$f":"E9*D9","v":522.36249999999995}]
[null,{"$f":"TEXT(\"Tranche 3\",1)","v":"Tranche 3"},750,{"$f":"IF(IF(($K$5-250)<250,0,IF(($K$5-250)>750,750,IF(($K$5-250)>250,($K$5-250))))<0,0,IF(($K$5-250)<250,0,IF(($K$5-250)>750,750,IF(($K$5-250)>250,($K$5-250)))))","v":519},{"$f":"N(4.812)","v":4.8120000000000003},{"$f":"E10*D10","v":2497.4280000000003},{"$f":"SUM(F10,F11)","v":2497.4280000000003},{"$f":"N(0.19)","v":0.19},{"$f":"G10*H10","v":474.51132000000007},{"$f":"SUM(G10,I10)","v":2971.9393200000004}]
[null,{"$f":"TEXT(\"Tranche 4\",1)","v":"Tranche 4"},">750",{"$f":"IF(IF(($K$5-1000)<1000,($K$5-1000),($K$5-1000))<0,0,IF(($K$5-1000)<1000,($K$5-1000),($K$5-1000)))","v":0},{"$f":"N(5.4796)","v":5.4795999999999996},{"$f":"E11*D11","v":0}]
[null,null,null,{"$f":"SUM(D8:D11)","v":769},null,{"$f":"SUM(F8:F11)","v":3242.1280000000002},{"$f":"SUM(G8:G11)","v":3242.1280000000002},null,{"$f":"SUM(I8:I11)","v":541.53432000000009},{"$f":"SUM(J8:J11)","v":3783.6623200000004}]
[null,{"$f":"TEXT(\"Taxe fixe\",1)","v":"Taxe fixe"},null,null,null,null,{"$f":"N(78.66)","v":78.66},{"$f":"N(9%)","v":0.09},{"$f":"G13*H13","v":7.0793999999999997},{"$f":"SUM(G13,I13)","v":85.739399999999989},"                   "]
[null,{"$f":"TEXT(\"Sous-total electricité\",1)","v":"Sous-total electricité"},null,null,null,null,{"$f":"SUM(G12,G13)","v":3320.788},null,{"$f":"SUM(I12,I13)","v":548.61372000000006},{"$f":"SUM(J12,J13)","v":3869.4017200000003}]
[{"$f":"TEXT(\"GAZ\",1)","v":"GAZ"},{"$f":"TEXT(\"Tranche 1\",1)","v":"Tranche 1"},1125,{"$f":"IF(IF($K$6<1125,$K$6,1125)<0,0,IF($K$6<1125,$K$6,1125))","v":1125},{"$f":"N(0.1682)","v":0.16819999999999999},{"$f":"D15*E15","v":189.22499999999999},{"$f":"SUM(F15,F16)","v":635.41250000000002},{"$f":"N(9%)","v":0.09},{"$f":"G15*H15","v":57.187125000000002},{"$f":"SUM(G15,I15)","v":692.59962500000006}]
[null,{"$f":"TEXT(\"Tranche 2\",1)","v":"Tranche 2"},1375,{"$f":"IF(IF(($K$6-1125)<2500,($K$6-1125),1375)<0,0,IF(($K$6-1125)<2500,($K$6-1125),1375))","v":1375},{"$f":"N(0.3245)","v":0.32450000000000001},{"$f":"D16*E16","v":446.1875}]
[null,{"$f":"TEXT(\"Tranche 3\",1)","v":"Tranche 3"},5000,{"$f":"IF(IF(($K$6-2500)<2500,($K$6-2500),5000)<0,0,IF(($K$6-2500)<2500,($K$6-2500),5000))","v":5000},{"$f":"N(0.4025)","v":0.40250000000000002},{"$f":"D17*E17","v":2012.5000000000002},{"$f":"SUM(F17,F18)","v":6357.4512399999994},{"$f":"N(19%)","v":0.19},{"$f":"G17*H17","v":1207.9157355999998},{"$f":"SUM(G17,I17)","v":7565.366975599999}]
[null,{"$f":"TEXT(\"Tranche 4\",1)","v":"Tranche 4"},">5000",{"$f":"IF(IF(($K$6-7500)<7500,($K$6-7500),($K$6-7500))<0,0,IF(($K$6-7500)<7500,($K$6-7500),($K$6-7500)))","v":9447.5999999999985},{"$f":"N(0.4599)","v":0.45989999999999998},{"$f":"D18*E18","v":4344.9512399999994}]
[null,null,null,{"$f":"SUM(D15:D18)","v":16947.599999999999},null,{"$f":"SUM(F15:F18)","v":6992.8637399999998},{"$f":"SUM(G15:G18)","v":6992.8637399999998},null,{"$f":"SUM(I15:I18)","v":1265.1028605999998},{"$f":"SUM(J15:J18)","v":8257.9666005999989}]
[null,{"$f":"TEXT(\"Taxe fixe\",1)","v":"Taxe fixe"},null,null,null,null,{"$f":"N(85.5)","v":85.5},{"$f":"N(9%)","v":0.09},{"$f":"G20*H20","v":7.6949999999999994},{"$f":"SUM(G20,I20)","v":93.194999999999993}]
[null,{"$f":"TEXT(\"Sous-total gaz\",1)","v":"Sous-total gaz"},null,null,null,null,{"$f":"SUM(G15,G17,G20)","v":7078.3637399999998},null,{"$f":"SUM(I15,I17,I20)","v":1272.7978605999997},{"$f":"SUM(G21,I21)","v":8351.1616006000004}]
[{"$f":"TEXT(\"TAXE\",1)","v":"TAXE"},{"$f":"TEXT(\"TAXE FIXE\",1)","v":"TAXE FIXE"},null,null,null,null,null,null,null,{"$f":"N(100)","v":100}]
[null,{"$f":"TEXT(\"TAXE HABITATION\",1)","v":"TAXE HABITATION"},null,null,null,null,null,null,null,{"$f":"N(150)","v":150}]
[{"$f":"TEXT(\"Montant à payer\",1)","v":"Montant à payer"},null,null,null,null,null,null,null,null,{"$f":"SUM(J14,J21,J22,J23)+0.02","v":12470.583320600001}]
[{"$f":"TEXT(\"Droit de timbre\",1)","v":"Droit de timbre"},null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((J24*1%),0)","v":125}]
[{"$f":"TEXT(\"Montant total à payer espéces\",1)","v":"Montant total à payer espéces"},null,null,null,null,null,null,null,null,{"$f":"J24+J25","v":12595.583320600001}]

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

{"sheet":"formules","index":2,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["=SI((SI(SI($I$1<125;0;125)<0;0;SI($I$1<125;0;125)))<0;0;(SI(SI($I$1<125;0;125)<0;0;SI($I$1<125;0;125))))"]
["=SI(SI(($I$1-125)<250;($I$1-125);125)<0;0;SI(($I$1-125)<250;($I$1-125);125))"]
["=SI(SI(($I$1-250)<250;0;SI(($I$1-250)>750;750;SI(($I$1-250)>250;($I$1-250))))<0;0;SI(($I$1-250)<250;0;SI(($I$1-250)>750;750;SI(($I$1-250)>250;($I$1-250)))))"]
["=SI(SI(($I$1-1000)<1000;($I$1-1000);SI(($I$1-1000)>1000;0))<0;0;SI(($I$1-1000)<1000;($I$1-1000);SI(($I$1-1000)>1000;0)))"]
[]
["=SI(SI($I$2<1125;$I$2;1125)<0;0;SI($I$2<1125;$I$2;1125))"]
["=SI(SI(($I$2-1125)<2500;($I$2-1125);1375)<0;0;SI(($I$2-1125)<2500;($I$2-1125);1375))"]
["=SI(SI(($I$2-2500)<2500;($I$2-2500);5000)<0;0;SI(($I$2-2500)<2500;($I$2-2500);5000))"]
["=SI(SI(($I$2-7500)<7500;($I$2-7500);($I$2-7500))<0;0;SI(($I$2-7500)<7500;($I$2-7500);($I$2-7500)))"]

{"sheet":"Feuil2","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,22255,20293,{"$f":"D1-E1","v":1962},1,{"$f":"F1*G1","v":1962}]
[null,null,null,85317,85089,{"$f":"D2-E2","v":228},8.6999999999999993,{"$f":"F2*G2","v":1983.6}]
[null,null,null,null," "]
["tr1",125,{"$f":"IF((IF(IF($H$1<125,0,125)<0,0,IF($H$1<125,0,125)))<0,0,(IF(IF($H$1<125,0,125)<0,0,IF($H$1<125,0,125))))","v":125},1.7786999999999999,{"$f":"C4*D4","v":222.33750000000001},{"$f":"SUM(E4,E5)","v":744.69999999999993},0.09,{"$f":"F4*G4","v":67.022999999999996},{"$f":"H4+F4","v":811.72299999999996}]
["tr2",125,{"$f":"IF(IF(($H$1-125)<250,($H$1-125),125)<0,0,IF(($H$1-125)<250,($H$1-125),125))","v":125},4.1788999999999996,{"$f":"C5*D5","v":522.36249999999995},{"$f":"SUM(E6,E7)","v":8880.3751999999986},0.19,{"$f":"F5*G5","v":1687.2712879999997},{"$f":"H5+F5","v":10567.646487999998}]
["tr3",750,{"$f":"IF(IF(($H$1-250)<250,0,IF(($H$1-250)>750,750,IF(($H$1-250)>250,($H$1-250))))<0,0,IF(($H$1-250)<250,0,IF(($H$1-250)>750,750,IF(($H$1-250)>250,($H$1-250)))))","v":750},4.8120000000000003,{"$f":"C6*D6","v":3609}]
["tr4",">750",{"$f":"IF(IF(($H$1-1000)<1000,($H$1-1000),IF(($H$1-1000)>1000,0))<0,0,IF(($H$1-1000)<1000,($H$1-1000),IF(($H$1-1000)>1000,0)))","v":962},5.4795999999999996,{"$f":"C7*D7","v":5271.3751999999995}]
[null,null,{"$f":"SUM(C7,C6,C5,C4)","v":1962}]
[null,null,null,null,null,78.66,0.09,{"$f":"F9*G9","v":7.0793999999999997},{"$f":"H9+F9","v":85.739399999999989}]
[null,null,null,null,null,{"$f":"SUM(F9,F5,F4)","v":9703.7351999999992},null,{"$f":"SUM(H9,H5,H4)","v":1761.3736879999997},{"$f":"SUM(I9,I5,I4)","v":11465.108887999999},"ELECTRICITE"]
[]
["tr1",1125,{"$f":"IF(IF($H$2<1125,$H$2,1125)<0,0,IF($H$2<1125,$H$2,1125))","v":1125},0.16819999999999999,{"$f":"C12*D12","v":189.22499999999999},{"$f":"SUM(E12:E13)","v":467.84069999999997},0.09,{"$f":"F12*G12","v":42.105662999999993},{"$f":"F12+H12","v":509.94636299999996}]
["tr2",1375,{"$f":"IF(IF(($H$2-1125)<2500,($H$2-1125),1375)<0,0,IF(($H$2-1125)<2500,($H$2-1125),1375))","v":858.59999999999991},0.32450000000000001,{"$f":"C13*D13","v":278.6157},{"$f":"SUM(E14:E15)","v":0},0.19,{"$f":"F13*G13","v":0},{"$f":"F13+H13","v":0}]
["tr3",5000,{"$f":"IF(IF(($H$2-2500)<2500,($H$2-2500),5000)<0,0,IF(($H$2-2500)<2500,($H$2-2500),5000))","v":0},0.40250000000000002,{"$f":"C14*D14","v":0}]
["tr4",">5000",{"$f":"IF(IF(($H$2-7500)<7500,($H$2-7500),($H$2-7500))<0,0,IF(($H$2-7500)<7500,($H$2-7500),($H$2-7500)))","v":0},0.45989999999999998,{"$f":"C15*D15","v":0}]
[null,null,{"$f":"SUM(C12:C15)","v":1983.6}]
[null,null,null,null,null,85.5,0.09,{"$f":"F17*G17","v":7.6949999999999994},{"$f":"F17+H17","v":93.194999999999993}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17,I13,I12)","v":603.14136299999996},"GAZ"]
[null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,150]
[null,null,null,null,null,null,null,null,{"$f":"I20+I19+I18+I10","v":12318.250250999999},"TOTAL"]