{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Situation bancaire","Exercice","Bilan AVION","Bilan ULM","Bilan Savannah","Bilan CLUB","Bilan 2022","Resultat 2022","Immos","Stock","Prêt ULM - OLd","Prêt ULM","Prêt 4204","Prêt Kit ULM"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":5,"defined_names":13,"comments":3,"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":"Situation bancaire","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,4]]}
[]
[null,null,"        Situation bancaire"]
[]
[]
[null,null,null,"2015-12-31","2016-12-31","2017-12-31","2018-12-31","2019-12-31","2020-12-31","2021-12-31","2022-12-31"]
[null,"A","Compte Courant",1619.66,1647.55,8289.3799999999992,1454.03,11413.08,18369.919999999998,20209.349999999999,3642.55]
[null,"B","Livret Association",41425.97,43315.47,57252.800000000003,39752.82,33070.14,33070.14,39137.199999999997,15137.2]
[null,"C","Comptes Pilotes",2630.13,1474.74,2040.89,4698.95,9607.09,8674.16,11629.03,9888.93]
[null,null,"TOTAL ( A + B - C )",{"$f":"D6+D7-D8","v":40415.500000000007},43488.280000000006,63501.290000000008,36507.9,34876.130000000005,42765.899999999994,47717.52,{"$f":"K6+K7-K8","v":8890.82}]
[]
[null,null,"Exercice 2022 :",{"$f":"+(K9-J9)","v":-38826.699999999997},"  NEGATIF",null,"Hors kit ULM: -43,69€"]
[null,null,"Exercice 2021 :",{"$f":"+(J9-I9)","v":4951.6200000000026},"  POSITIF"]
[null,null,"Exercice 2020 :",{"$f":"+(I9-H9)","v":7889.7699999999895}]
[null,null,"Exercice 2019 :",{"$f":"+(H9-G9)","v":-1631.7699999999968}]
[null,null,"Exercice 2018 :",{"$f":"+(G9-F9)","v":-26993.390000000007}]
[null,null,"Exercice 2017 :",{"$f":"+(F9-E9)","v":20013.010000000002}]

{"sheet":"Exercice","index":1,"n_rows":49,"n_cols":42,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,37,0,41],[1,37,1,38],[1,40,1,41],[39,37,39,40],[0,31,0,35],[1,31,1,32],[1,34,1,35],[39,31,39,34],[0,13,0,17],[1,13,1,14],[1,16,1,17],[39,13,39,17],[0,25,0,29],[1,25,1,26],[1,28,1,29],[39,25,39,28],[0,19,0,23],[1,19,1,20],[1,22,1,23],[39,19,39,22],[39,1,39,5],[0,1,0,5],[1,1,1,2],[1,4,1,5],[39,7,39,11],[0,7,0,11],[1,7,1,8],[1,10,1,11]]}
[null,"Charges et produits",null,null,null,null,null,"Charges et produits",null,null,null,null,null,"Charges et produits",null,null,null,null,null,"Charges et produits",null,null,null,null,null,"Charges et produits",null,null,null,null,null,"Charges et produits",null,null,null,null,null,"Charges et produits"]
[null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS"]
[]
[null,"Assemblée Générale",514.1,null,"Assemblée Générale",306,null,"AG_2016",658.4,null,"AG_2016",322.29999999999995,null,"AG_2017",492.2,null,"AG_2017",321.29999999999995,null,"AG_2018",234.6,null,"AG_2018",0,null,"AG_2019",625,null,"AG_2019",525,null,"AG_2020",null,null,"AG_2020",null,null,"AG_2021",623.20000000000005,null,"AG_2021",475.03999999999985]
[null,"Soirée crêpes",186,null,"Soirée crêpes",655,null,"Soirée_crêpes",358.53999999999996,null,"Soirée_crêpes",490,null,"Soirée_crêpes",0,null,"Soirée_crêpes",0,null,"Soirée_crêpes",328.8,null,"Soirée_crêpes",1030,null,"Journée_crêpes",305.83,null,"Journée_crêpes",385,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",410.59999999999997,null,"Journée_crêpes",1380]
[null,"Cartes OACI",1520.17,null,"Cartes OACI",1405.35,null,"Cartes_OACI",1108.3800000000001,null,"Cartes_OACI",1016.9000000000002,null,"Cartes_OACI",1347.04,null,"Cartes_OACI",1271.75,null,"Cartes_OACI",1386.94,null,"Cartes_OACI",1282.5,null,"Cartes_OACI",1270.22,null,"Cartes_OACI",1085.5,null,"Cartes_OACI",1206.1500000000001,null,"Cartes_OACI",1050,null,"Cartes_OACI",1465.3899999999999,null,"Cartes_OACI",1263.3999999999999]
[null,"Locations hangars 2016",3360,null,"Locations hangars 2014",3360,null,"Hangars_2017",3800,null,"Location_hangar",3800,null,"Hangars_2018",0,null,"Location_hangar",3720,null,"Hangars_2018",3600,null,"Location_hangar",3880,null,"Hangars_2019",3600,null,"Location_hangar",4020,null,"Hangars_2019",7600,null,"Location_hangar",3840,null,"Hangars_2019",4000,null,"Location_hangar",3840]
[null,"Taxes d'atterrissages",43.64,null,"Taxes d'atterrissages",43.64,null,"Taxe_atterrissage",175.13,null,"Taxe_atterrissage",175.13000000000002,null,"Taxe_atterrissage",19.190000000000001,null,"Taxe_atterrissage",19.190000000000001,null,"Taxe_atterrissage",65.790000000000006,null,"Taxe_atterrissage",0,null,"Taxe_atterrissage",100.24,null,"Taxe_atterrissage",141.02000000000001,null,"Taxe_atterrissage",9.35,null,"Taxe_atterrissage",9.35,null,"Taxe_atterrissage",57.269999999999996,null,"Taxe_atterrissage",35.51]
[null,"Essence - Approvision cuve",5516.46,null,"Essence - Pilotes basés",1140.71,null,"Essence_approvisionnement",7470.4,null,"Essence_basés",1018.6,null,"Essence_approvisionnement",26717.79,null,"Essence_basés",4038.6599999999989,null,"Essence_approvisionnement",7878.52,null,"Essence_basés",3977.4599999999996,null,"Essence_approvisionnement",24702.13,null,"Essence_basés",3490.22,null,"Essence_approvisionnement",25383.82,null,"Essence_basés",4853.42,null,"Essence_approvisionnement",22546.85,null,"Essence_basés",4620.7999999999993]
[null,"Essence - Terrains extérieurs",2174.54,null,"Essence - Avions extérieurs",715.75,null,"Essence_prise_extérieur",2174.0700000000002,null,"Essence_extérieur",6184.8499999999995,null,"Essence_prise_extérieur",642.96,null,"Essence_extérieur",1213.71,null,"Essence_prise_extérieur",488.55,null,"Essence_extérieur",214.92000000000002,null,"Essence_prise_extérieur",508.7,null,"Essence_extérieur",671.99,null,"Essence_prise_extérieur",521.07000000000005,null,"Essence_extérieur",1496.15,null,"Essence_prise_extérieur",388.32,null,"Essence_extérieur",5626.5499999999993]
[null,"Cartes Vac",81,null,"Cotisations membres",245,null,"Cartes_VAC",83,null,"cotis_membre",420,null,"Cartes_VAC",101.91,null,"cotis_membre",350,null,"Cartes_VAC",130.49,null,"cotis_membre",245,null,"Cartes_VAC",107.49,null,"cotis_membre",315,null,"Cartes_VAC",109.43,null,"cotis_membre",445,null,"Cartes_VAC",0,null,"cotis_membre",590]
[null,"Entretien Océanair",14867.44,null,"Cotisations pilotes",4770,null,"Entretien_avion",2927.08,null,"cotis_pilote",4167.5,null,"Frais_déplacement",2262.6,null,"cotis_pilote",4114.2,null,"Frais_déplacement",2174.6000000000004,null,"cotis_pilote",3830,null,"Frais_déplacement",661.2,null,"cotis_pilote",4765,null,"Frais_déplacement",1734.2,null,"cotis_pilote",5240,null,"Frais_déplacement",289.8,null,"cotis_pilote",4845]
[null,"Assurance de l'Océanair",2625,null,"Vols Océanair en simple",15119,null,"Assurance_avion",2555.13,null,"Océanair_simple",16092.9987,null,"Entretien_avion",13198.580000000002,null,"Océanair_simple",13414.8,null,"Entretien_avion",37325.61,null,"Océanair_simple",15514.9,null,"Entretien_avion",6063.21,null,"Océanair_simple",15824.5,null,"Entretien_avion",8708.7000000000007,null,"Océanair_simple",18457,null,"Entretien_avion",10938.59,null,"Océanair_simple",15899.520000000002]
[null,"Frais de déplacement instructeur",1309,null,"Vols Océanair en double",14262,null,"Déplacement_Instructeur",1276,null,"Océanair_double",10374,null,"Assurance_avion",2603.92,null,"Océanair_double",7401.8,null,"Assurance_avion",3323.4,null,"Océanair_double",8320.2000000000007,null,"Assurance_avion",2900.77,null,"Océanair_double",10654,null,"Assurance_avion",2981.09,null,"Océanair_double",15516,null,"Assurance_avion",4712.53,null,"Océanair_double",9252.3999999999978]
[null,"Cotisation FFA",2826,null,"Cotisation FFA",2826,null,"Cotisation_FFA",2947.5,null,"Océanair_initiation",712,null,"Déplacement_Instructeur",1309,null,"Océanair_initiation",723,null,"Déplacement_Instructeur",1463,null,"Océanair_initiation",1962.4,null,"Déplacement_Instructeur",1725,null,"Océanair_initiation",1806,null,"Déplacement_Instructeur",2847.6,null,"Océanair_initiation",768,null,"Déplacement_Instructeur",1872.5999999999979,null,"Océanair_initiation",462.3]
[null,"Approvisionnement Bar",212.13,null,"Caisse bar",460,null,"Bar",344.14,null,"Cotisation_FFA",2688,null,"Cotisation_FFA",2879,null,"Cotisation_FFA",2617,null,"Cotisation_FFA",2543,null,"Cotisation_FFA",2661,null,"Cotisation_FFA",3438,null,"Cotisation_FFA",3258,null,"Cotisation_FFA",3742.5,null,"Cotisation_FFA",3561,null,"Cotisation_FFA",3481.5,null,"Cotisation_FFA",3123]
[null,"Bourse",0,null,"Bourse",0,null,"Bourse",0,null,"Caisse_Bar",450.18,null,"Bar",353.41,null,"Caisse_Bar",645,null,"Bar",655.05000000000007,null,"Caisse_Bar",862,null,"Bar",648.27,null,"Caisse_Bar",805.05,null,"Bar",884.09,null,"Caisse_Bar",1129.5999999999999,null,"Bar",1289.6499999999999,null,"Caisse_Bar",1065.5]
[null,"BIA",990,null,"BIA",940,null,"BIA",840,null,"Bourse",0,null,"Bourse",0,null,"Bourse",0,null,"Bourse",0,null,"Bourse",0,null,"Bourse",1000,null,"Bourse",1000,null,"Bourse",0,null,"Bourse",0,null,"Bourse",0,null,"Bourse",0]
[null,"Nourriture",928.92,null,"Nourriture",376,null,"Nourriture",665.96999999999991,null,"BIA",300,null,"BIA",450,null,"BIA",700,null,"BIA",167,null,"BIA",367,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0]
[null,"Manuels et Carnets de vol",392.01,null,"Manuels et Carnets de vol",312,null,"Manuel_Carnet_de_vol",23.95,null,"Nourriture",156,null,"Nourriture",821.0100000000001,null,"Nourriture",205,null,"Nourriture",1836.1000000000001,null,"Nourriture",194,null,"Nourriture",1445.65,null,"Nourriture",822,null,"Nourriture",1732.08,null,"Nourriture",898,null,"Nourriture",1451.9999999999998,null,"Nourriture",780]
[null,"Location avion extérieur",1472.5,null,"Remboursement avion extérieur",1472.5,null,"Location_Avion extérieur",800,null,"Manuel_Carnet_de_vol",0,null,"Manuel_Carnet_de_vol",182.4,null,"Manuel_Carnet_de_vol",160,null,"Manuel_Carnet_de_vol",135,null,"Manuel_Carnet_de_vol",135,null,"Manuel_Carnet_de_vol",610.75,null,"Manuel_Carnet_de_vol",554,null,"Manuel_Carnet_de_vol",0,null,"Manuel_Carnet_de_vol",80,null,"Manuel_Carnet_de_vol",294.02999999999997,null,"Manuel_Carnet_de_vol",177]
[null,"Frais de déplacements autres",366.47,null,"Dons",2395,null,"Frais_déplacement",701.79999999999973,null,"Don",200,null,"Assurance_locaux",368,null,"Don",0,null,"Assurance_locaux",380,null,"Don",0,null,"Assurance_locaux",1711,null,"Don",5861.92,null,"Assurance_locaux",1056,null,"Don",5100,null,"Assurance_locaux",1096,null,"Don",258.3]
[null,"Assurance locaux Aéroclub",347,null,"Locations tables",54,null,"Assurance_locaux",358,null,"Intérêts_Livret",252.8,null,"Cotisation_CRA20_RSA",120,null,"Intérêts_Livret",0,null,"Cotisation_CRA20_RSA",287.5,null,"Intérêts_Livret",70.14,null,"Cotisation_CRA20_RSA",140,null,"Intérêts_Livret",0,null,"Cotisation_CRA20_RSA",190,null,"Intérêts_Livret",32.6,null,"Cotisation_CRA20_RSA",150,null,"Intérêts_Livret",0]
[null,"Cotisation CRA 20 et RSA",260,null,"Intérêts livret association",315.47000000000003,null,"Cotisation_CRA20_RSA",240,null,"Location_tables",0,null,"Papeterie",179.63,null,"Location_tables",74,null,"Papeterie",148.21,null,"Location_tables",0,null,"Papeterie",235.79,null,"Location_tables",0,null,"Papeterie",246.22,null,"Location_tables",0,null,"Papeterie",229.98,null,"Location_tables",30]
[null,"Orange internet",543.86,null,"Divers",233.5,null,"Orange",550.65,null,"Remboursement_Avion extérieur",800,null,"Location_Avion extérieur",710.25,null,"Remboursement_Avion extérieur",406.25,null,"Location_Avion extérieur",3971.52,null,"Remboursement_Avion extérieur",390,null,"Location_Avion extérieur",501,null,"Remboursement_Avion extérieur",501,null,"Location_Avion extérieur",0,null,"Remboursement_Avion extérieur",0,null,"Location_Avion extérieur",170,null,"Remboursement_Avion extérieur",170]
[null,"Papeterie",241.83,null,"Vols initiation Océanair",140,null,"Papeterie",23.7,null,"Divers",2019.19,null,"Orange",524.56000000000006,null,"Divers",1121.28,null,"Free",153.64000000000001,null,"Divers",696.06000000000006,null,"Free",305.25,null,"Divers",1573.38,null,"Free",305.19,null,"Divers",1003.48,null,"Free",299.88000000000005,null,"Divers",974.77]
[null,"Divers",1701.11,null,"Baptême en ULM",140,null,"Divers",3966.4499999999989,null,"ULM_simple",2856,null,"Divers",1354.4,null,"ULM_simple",4603.6000000000022,null,"Divers",2235.9999999999995,null,"ULM_simple",5136.0000000000018,null,"Divers",2346.89,null,"ULM_simple",5410.8,null,"Divers",830.34,null,"ULM_simple",7876.8,null,"Divers",787.31999999999994,null,"ULM_simple",6479.6999999999971]
[null,"Remboursements prêt ULM",2753.4,null,"Vols ULM en simple",1809.8,null,"ULM_Prêt_CIC",2753.3999999999996,null,"ULM_double",8194.2000000000007,null,"ULM_Prêt_CIC",2753.3999999999996,null,"ULM_double",8055.5999999999976,null,"ULM_Prêt_CIC",2753.3999999999996,null,"ULM_double",12002.199999999993,null,"ULM_Prêt_CIC",2753.4,null,"ULM_double",6816.6,null,"ULM_Prêt_CIC",2753.4,null,"ULM_double",11233.6,null,"ULM_Prêt_CIC",1147.2,null,"ULM_double",10820.100000000002]
[null,"Entretien ULM",1065.01,null,"Vols ULM en double",7344.6,null,"ULM_entretien",557.66999999999996,null,"ULM_baptême",159.19999999999999,null,"ULM_entretien",18689.809999999998,null,"ULM_baptême",120,null,"ULM_entretien",1594.9,null,"ULM_baptême",180.2,null,"ULM_entretien",361.41,null,"ULM_initiation",541.20000000000005,null,"ULM_entretien",2210.52,null,"ULM_initiation",262.8,null,"ULM_entretien",1266.45,null,"ULM_initiation",307.85000000000002]
[null,"Essence pour ULM",1680.11,null,"Subventions Océanair",2400,null,"ULM_essence",2213.14,null,"ULM_souscription_trésorerie",0,null,"ULM_essence",937.00999999999988,null,"ULM_souscription_trésorerie",0,null,"ULM_essence",0,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",200.25,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",238.48,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",2977.0199999999991,null,"ULM_souscription_trésorerie",0]
[null,"Assurance de l'ULM",1930,null,null,null,null,"ULM_assurance",1333.94,null,"Océanair_Subventions",0,null,"ULM_assurance",1356.35,null,"Océanair_Subventions",0,null,"ULM_assurance",1911.74,null,"Océanair_Subventions",0,null,"ULM_assurance",1600,null,"Océanair_Subventions",0,null,"ULM_assurance",1838.78,null,"Océanair_Subventions",0,null,"ULM_assurance",2019.6599999999999,null,"Océanair_Subventions",0]
[null,"Baptême en ULM remise",60,null,null,null,null,"ULM_baptême_remise",30,null,null,0,null,"ULM_baptême_remise",35,null,null,0,null,"ULM_baptême_remise",0,null,"Prêt CIC",15000,null,"ULM_baptême_remise",0,null,"Prêt CIC",null,null,"Kit ULM",21400,null,"Prêt CIC kit ULM",21400,null,"Kit ULM",38783.009999999995]
[null,"Remboursement souscription ULM",1900,null,null,null,null,"ULM_rembt_souscription",1900,null,null,0,null,"ULM_rembt_souscription",1900,null,null,0,null,"ULM_rembt_souscription",1800,null,"ULM subvention",223.96,null,"ULM_rembt_souscription",0,null,"ULM subvention",null,null,"Mezzanine",9702.2099999999991,null,"ULM subvention",2000,null,"Mezzanine",1976.6699999999996,null,"ULM subvention"]
[null,"Moteur Avion Océanair",8300.84,null,null,null,null,"Moteur_avion",0,null,null,0,null,"Moteur_avion",0,null,null,0,null,"Prêt CIC",833.35,null,null,0,null,"Prêt CIC",3069.96,null,null,0,null,"Prêt CIC",3069.96,null,null,0,null,"Prêt CIC",3069.96,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repas construction kit ULM",2017.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prêt  Kit ULM",3652.2299999999996,null,"Repas construction kit ULM",2301.4499999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repas rassemblement ACAA",853.11000000000013,null,"Repas rassemblement ACAA",713]
[null,"TOTAL Charges",{"$f":"SUM(C4:C34)","v":60168.540000000008},null,"TOTAL Produits",{"$f":"SUM(F4:F34)","v":63241.32},null,"TOTAL Charges",{"$f":"SUM(I4:I34)","v":42836.44},null,"TOTAL Produits",{"$f":"SUM(L4:L34)","v":62849.848700000002},null,"TOTAL Charges",{"$f":"SUM(O4:O34)","v":82309.42},null,"TOTAL Produits",{"$f":"SUM(R4:R34)","v":55296.139999999992},null,"TOTAL Charges",{"$f":"SUM(U4:U34)","v":79806.710000000006},null,"TOTAL Produits",{"$f":"SUM(X4:X34)","v":78174.939999999988},null,"TOTAL Charges",{"$f":"SUM(AA4:AA34)","v":62937.41},null,"TOTAL Produits",{"$f":"SUM(AD4:AD34)","v":70827.179999999993},null,"TOTAL Charges",{"$f":"SUM(AG4:AG34)","v":101301.18000000001},null,"TOTAL Produits",{"$f":"SUM(AJ4:AJ34)","v":106252.8},null,"TOTAL Charges",{"$f":"SUM(AM4:AM37)","v":114317.88999999998},null,"TOTAL Produits",{"$f":"SUM(AP4:AP37)","v":75491.19}]
[]
[null,"Exercice 2016 (Produits - Charges) = + 3072,78 €",null,null,null,null,null,"Exercice 2017 (Produits - Charges) = + 20013,01€",null,null,null,null,null,"Exercice 2018 (Produits - Charges) = - 27013,28 €",null,null,null,null,null,"Exercice 2019 (Produits - Charges) = ",null,null,null,{"$f":"X38-U38","v":-1631.7700000000186},null,"Exercice 2020 (Produits - Charges) = ",null,null,null,{"$f":"AD38-AA38","v":7889.7699999999895},null,"Exercice 2021 (Produits - Charges) = ",null,null,null,{"$f":"AJ38-AG38","v":4951.6199999999953},null,"Exercice 2022 (Produits - Charges) = ",null,null,null,{"$f":"AP38-AM38","v":-38826.699999999983}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Info, 4060L essence en cuve",null,null,null,null,null,"Info, env, 9500L essence en cuve",null,null,null,null,null,"Info, env, 8675L essence en cuve soit 15600€",null,null,null,null,null,"Info: 5453L essence en cuve soit 15050€ au dernier prix d'achat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-X32","v":-15000},null,null,null,null,null,{"$f":"-AD32","v":0},null,null,null,null,null,{"$f":"-AJ32","v":-21400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U34","v":833.35},null,null,null,null,null,{"$f":"+AA34","v":3069.96},null,null,null,null,null,{"$f":"+AG34","v":3069.96}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U28","v":2753.3999999999996},null,null,null,null,null,{"$f":"+AA28","v":2753.4},null,null,null,null,null,{"$f":"+AG28","v":2753.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Immos!C48","v":36239.82},null,null,null,null,null,{"$f":"+Immos!I48","v":0},null,null,null,null,null,{"$f":"+Immos!O48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-Immos!B71-'Resultat 2022'!I20","v":-14495.704641492115},null,null,null,null,null,{"$f":"-Immos!H71-'Resultat 2022'!O20","v":-153.86324345784351},null,null,null,null,null,{"$f":"-Immos!N71-'Resultat 2022'!U20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-'Resultat 2022'!I18","v":-8987.2990732760336},null,null,null,null,null,{"$f":"-'Resultat 2022'!O18","v":2895.0025000000005},null,null,null,null,null,{"$f":"-'Resultat 2022'!U18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X40:X48)","v":-288.20371476816763},null,null,null,null,null,{"$f":"SUM(AD40:AD48)","v":16454.269256542146},null,null,null,null,null,{"$f":"SUM(AJ40:AJ48)","v":-10625.020000000006}]

{"sheet":"Bilan AVION","index":2,"n_rows":37,"n_cols":43,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,38,0,42],[1,38,1,39],[1,41,1,42],[36,38,36,41],[0,32,0,36],[1,32,1,33],[1,35,1,36],[36,32,36,35],[0,14,0,18],[1,14,1,15],[1,17,1,18],[36,14,36,18],[0,26,0,30],[1,26,1,27],[1,29,1,30],[36,26,36,29],[0,20,0,24],[1,20,1,21],[1,23,1,24],[36,20,36,23],[1,11,1,12],[36,8,36,12],[0,8,0,12],[0,1,0,5],[1,1,1,2],[1,4,1,5],[36,1,36,5],[1,8,1,9]]}
[null,"Charges et produits Océanair 2016",null,null,null,null,null,null,"Charges et produits Océanair 2017",null,null,null,null,null,"Charges et produits Océanair 2018",null,null,null,null,null,"Charges et produits Océanair 2019",null,null,null,null,null,"Charges et produits Océanair 2020",null,null,null,null,null,"Charges et produits Océanair 2021",null,null,null,null,null,"Charges et produits Océanair 2022"]
[null,"CHARGES",null,null,"PRODUITS",null,null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS"]
[]
[null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"AG_2018",null,null,"AG_2018",0,null,"AG_2019",null,null,"AG_2019",null,null,"AG_2019",null,null,"AG_2019",null,null,"AG_2021",null,null,"AG_2021"]
[null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée_crêpes",null,null,"Soirée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes"]
[null,"Cartes OACI",114.82,null,"Cartes OACI",null,null,null,"Cartes OACI",{"$f":"Exercice!I6-Exercice!L6","v":91.479999999999905},null,"Cartes OACI",null,null,"Cartes OACI",{"$f":"Exercice!O6-Exercice!R6","v":75.289999999999964},null,"Cartes OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI"]
[null,"Locations hangars 2014",null,null,"Locations hangars 2014",null,null,null,"Locations hangars 2014",null,null,"Locations hangars 2014",null,null,"Locations hangars 2018",null,null,"Locations hangars 2018",null,null,"Hangars_2018",null,null,"Location_hangar",null,null,"Hangars_2018",null,null,"Location_hangar",null,null,"Hangars_2018",null,null,"Location_hangar",null,null,"Hangars_2018",null,null,"Location_hangar"]
[null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxe_atterrissage",65.790000000000006,null,"Taxe_atterrissage",0,null,"Taxe_atterrissage",100.24,null,"Taxe_atterrissage",141.02000000000001,null,"Taxe_atterrissage",9.35,null,"Taxe_atterrissage",9.35,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage"]
[null,"Essence - Approvision cuve",7866.43,null,"Essence - Pilotes basés",null,null,null,"Essence - Approvision cuve",8283.15,null,"Essence - Pilotes basés",null,null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence_approvisionnement",null,null,"Essence_basés",null,null,"Essence_approvisionnement",null,null,"Essence_basés",null,null,"Essence_approvisionnement",null,null,"Essence_basés",null,null,"Essence_approvisionnement",null,null,"Essence_basés"]
[null,"Essence - Terrains extérieurs",2174.54,null,"Essence - Avions extérieurs",null,null,null,"Essence - Terrains extérieurs",{"$f":"Exercice!I10","v":2174.0700000000002},null,"Essence - Avions extérieurs",null,null,"Essence - Terrains extérieurs",{"$f":"Exercice!O10","v":642.96},null,"Essence - Avions extérieurs",null,null,"Essence_prise_extérieur",488.55,null,"Essence_extérieur",null,null,"Essence_prise_extérieur",508.7,null,"Essence_extérieur",null,null,"Essence_prise_extérieur",0,null,"Essence_extérieur",null,null,"Essence_prise_extérieur",{"$f":"Exercice!AM10","v":388.32},null,"Essence_extérieur"]
[null,"Cartes Vac",81,null,"Cotisations membres",null,null,null,"Cartes Vac",{"$f":"Exercice!I11","v":83},null,"Cotisations membres",null,null,"Cartes Vac",{"$f":"Exercice!O11","v":101.91},null,"Cotisations membres",null,null,"Cartes_VAC",null,null,"cotis_membre",null,null,"Cartes_VAC",null,null,"cotis_membre",null,null,"Cartes_VAC",null,null,"cotis_membre",null,null,"Cartes_VAC",null,null,"cotis_membre"]
[null,"Entretien Océanair",14867.44,null,"Cotisations pilotes",null,null,null,"Entretien Océanair",{"$f":"Exercice!I12","v":2927.08},null,"Cotisations pilotes",null,null,"Entretien Océanair",{"$f":"Exercice!O13","v":13198.580000000002},null,"Cotisations pilotes",null,null,"Frais_déplacement",null,null,"cotis_pilote",null,null,"Frais_déplacement",null,null,"cotis_pilote",null,null,"Frais_déplacement",null,null,"cotis_pilote",null,null,"Frais_déplacement",null,null,"cotis_pilote"]
[null,"Assurance de l'Océanair",2625,null,"Vols Océanair en simple",15119,null,null,"Assurance de l'Océanair",{"$f":"Exercice!I13","v":2555.13},null,"Vols Océanair en simple",{"$f":"Exercice!L13","v":16092.9987},null,"Assurance de l'Océanair",2603.92,null,"Vols Océanair en simple",{"$f":"Exercice!R13","v":13414.8},null,"Entretien_avion",37325.61,null,"Océanair_simple",15514.9,null,"Entretien_avion",6063.21,null,"Océanair_simple",15824.5,null,"Entretien_avion",8708.7000000000007,null,"Océanair_simple",18457,null,"Entretien_avion",10938.59,null,"Océanair_simple",{"$f":"Exercice!AP13","v":15899.520000000002}]
[null,"Frais de déplacement instructeur",759,null,"Vols Océanair en double",14262,null,null,"Frais de déplacement instructeur",594,null,"Vols Océanair en double",{"$f":"Exercice!L14","v":10374},null,"Frais de déplacement instructeur",627,null,"Vols Océanair en double",{"$f":"Exercice!R14","v":7401.8},null,"Assurance_avion",3323.4,null,"Océanair_double",8320.2000000000007,null,"Assurance_avion",2900.77,null,"Océanair_double",10654,null,"Assurance_avion",2981.09,null,"Océanair_double",15516,null,"Assurance_avion",{"$f":"Exercice!AM14","v":4712.53},null,"Océanair_double",{"$f":"Exercice!AP14","v":9252.3999999999978}]
[null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",2879,null,"Cotisation FFA",2617,null,"Déplacement_Instructeur",638,null,"Océanair_initiation",1962.4,null,"Déplacement_Instructeur",660,null,"Océanair_initiation",1806,null,"Déplacement_Instructeur",990,null,"Océanair_initiation",768,null,"Déplacement_Instructeur",528,null,"Océanair_initiation",{"$f":"Exercice!AP15","v":462.3}]
[null,"Approvisionnement Bar",null,null,"Caisse bar",null,null,null,"Approvisionnement Bar",null,null,"Caisse bar",null,null,"Approvisionnement Bar",null,null,"Caisse bar",null,null,"Cotisation_FFA",2543,null,"Cotisation_FFA",2661,null,"Cotisation_FFA",3438,null,"Cotisation_FFA",3258,null,"Cotisation_FFA",0,null,"Cotisation_FFA",0,null,"Cotisation_FFA",null,null,"Cotisation_FFA"]
[null,"Bourse",null,null,"Bourse",null,null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bar",null,null,"Caisse_Bar",null,null,"Bar",null,null,"Caisse_Bar",null,null,"Bar",null,null,"Caisse_Bar",null,null,"Bar",null,null,"Caisse_Bar"]
[null,"BIA",990,null,"BIA",940,null,null,"BIA",{"$f":"Exercice!I18","v":840},null,"BIA",{"$f":"Exercice!L19","v":300},null,"BIA",450,null,"BIA",{"$f":"Exercice!R19","v":700},null,"Bourse",0,null,"Bourse",0,null,"Bourse",1000,null,"Bourse",1000,null,"Bourse",0,null,"Bourse",0,null,"Bourse",0,null,"Bourse",0]
[null,"Nourriture",null,null,"Nourriture",null,null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"BIA",167,null,"BIA",367,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0]
[null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",22.4,null,"Manuels et Carnets de vol",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture"]
[null,"Location avion extérieur",1472.5,null,"Remboursement avion extérieur",1472.5,null,null,"Location avion extérieur",{"$f":"Exercice!I21","v":800},null,"Remboursement avion extérieur",{"$f":"Exercice!L25","v":800},null,"Location avion extérieur",710.25,null,"Remboursement avion extérieur",{"$f":"Exercice!R25","v":406.25},null,"Manuel_Carnet_de_vol",135,null,"Manuel_Carnet_de_vol",135,null,"Manuel_Carnet_de_vol",610.75,null,"Manuel_Carnet_de_vol",554,null,"Manuel_Carnet_de_vol",0,null,"Manuel_Carnet_de_vol",80,null,"Manuel_Carnet_de_vol",{"$f":"Exercice!AM21","v":294.02999999999997},null,"Manuel_Carnet_de_vol",{"$f":"Exercice!AP21","v":177}]
[null,"Frais de déplacements autres",284.87,null,"Dons",null,null,null,"Frais de déplacements autres",237,null,"Dons",null,null,"Frais de déplacements autres",null,null,"Dons",null,null,"Assurance_locaux",null,null,"Don",0,null,"Assurance_locaux",null,null,"Don",null,null,"Assurance_locaux",null,null,"Don",null,null,"Assurance_locaux",null,null,"Don"]
[null,"Assurance locaux Aéroclub",null,null,"Locations tables",null,null,null,"Assurance locaux Aéroclub",null,null,"Locations tables",null,null,"Assurance locaux Aéroclub",null,null,"Locations tables",null,null,"Cotisation_CRA20_RSA",287.5,null,"Intérêts_Livret",null,null,"Cotisation_CRA20_RSA",140,null,"Intérêts_Livret",0,null,"Cotisation_CRA20_RSA",190,null,"Intérêts_Livret",0,null,"Cotisation_CRA20_RSA",{"$f":"Exercice!AM23","v":150},null,"Intérêts_Livret",0]
[null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",null,null,null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",null,null,"Cotisation CRA 20 et RSA",120,null,"Intérêts livret association",null,null,"Papeterie",null,null,"Location_tables",0,null,"Papeterie",null,null,"Location_tables",0,null,"Papeterie",null,null,"Location_tables",0,null,"Papeterie",null,null,"Location_tables",0]
[null,"Orange internet",null,null,"Divers",null,null,null,"Orange internet",null,null,"Divers",null,null,"Orange internet",null,null,"Divers",null,null,"Location_Avion extérieur",3971.52,null,"Remboursement_Avion extérieur",390,null,"Location_Avion extérieur",501,null,"Remboursement_Avion extérieur",501,null,"Location_Avion extérieur",0,null,"Remboursement_Avion extérieur",0,null,"Location_Avion extérieur",{"$f":"Exercice!AM25","v":170},null,"Remboursement_Avion extérieur",{"$f":"Exercice!AP25","v":170}]
[null,"Papeterie",null,null,"Vols initiation Océanair",140,null,null,"Papeterie",null,null,"Vols initiation Océanair",{"$f":"Exercice!L15","v":712},null,"Papeterie",null,null,"Vols initiation Océanair",{"$f":"Exercice!R15","v":723},null,"Free",null,null,"Divers",null,null,"Free",null,null,"Divers",null,null,"Free",null,null,"Divers",null,null,"Free",null,null,"Divers"]
[null,"Divers",null,null,"Baptême en ULM",null,null,null,"Divers",null,null,"Baptême en ULM",null,null,"Divers",null,null,"Baptême en ULM",null,null,"Divers",null,null,"ULM_simple",null,null,"Divers",null,null,"ULM_simple",null,null,"Divers",null,null,"ULM_simple",null,null,"Divers",null,null,"ULM_simple"]
[null,"Remboursements prêt ULM",null,null,"Vols ULM en simple",null,null,null,"Remboursements prêt ULM",null,null,"Vols ULM en simple",null,null,"Remboursements prêt ULM",null,null,"Vols ULM en simple",null,null,"ULM_Prêt_CIC",null,null,"ULM_double",null,null,"ULM_Prêt_CIC",null,null,"ULM_double",null,null,"ULM_Prêt_CIC",null,null,"ULM_double",null,null,"ULM_Prêt_CIC",null,null,"ULM_double"]
[null,"Entretien ULM",null,null,"Vols ULM en double",null,null,null,"Entretien ULM",null,null,"Vols ULM en double",null,null,"Entretien ULM",null,null,"Vols ULM en double",null,null,"ULM_entretien",null,null,"ULM_baptême",null,null,"ULM_entretien",null,null,"ULM_initiation",null,null,"ULM_entretien",null,null,"ULM_initiation",null,null,"ULM_entretien",null,null,"ULM_initiation"]
[null,"Essence pour ULM",null,null,"Subventions Océanair",2400,null,null,"Essence pour ULM",null,null,"Subventions Océanair",{"$f":"Exercice!L31","v":0},null,"Essence pour ULM",null,null,"Subventions Océanair",{"$f":"Exercice!R31","v":0},null,"ULM_essence",0,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",null,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",null,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",null,null,"ULM_souscription_trésorerie",0]
[null,"Assurance de l'ULM",null,null,null,null,null,null,"Assurance de l'ULM",null,null,null,null,null,"Assurance de l'ULM",null,null,null,null,null,"ULM_assurance",null,null,"Océanair_Subventions",0,null,"ULM_assurance",null,null,"Océanair_Subventions",0,null,"ULM_assurance",null,null,"Océanair_Subventions",0,null,"ULM_assurance",null,null,"Océanair_Subventions",0]
[null,"Baptême en ULM remise",null,null,null,null,null,null,"Baptême en ULM remise",null,null,null,null,null,"Baptême en ULM remise",null,null,null,null,null,"ULM_baptême_remise",0,null,"Prêt CIC",null,null,"ULM_baptême_remise",null,null,"Prêt CIC",null,null,"ULM_baptême_remise",null,null,"Prêt CIC",null,null,"ULM_baptême_remise",null,null,"Prêt CIC"]
[null,"Remboursement souscription ULM",0,null,null,null,null,null,"Remboursement souscription ULM",0,null,null,null,null,"Remboursement souscription ULM",0,null,null,null,null,"ULM_rembt_souscription",null,null,"ULM subvention",null,null,"ULM_rembt_souscription",null,null,"ULM subvention",null,null,"ULM_rembt_souscription",null,null,"ULM subvention",null,null,"ULM_rembt_souscription",null,null,"ULM subvention"]
[null,"Moteur Avion Océanair",8300.84,null,null,null,null,null,"Moteur Avion Océanair",{"$f":"Exercice!I34","v":0},null,null,null,null,"Moteur Avion Océanair",{"$f":"Exercice!O34","v":0},null,null,null,null,"Prêt CIC",null,null,null,0,null,"Prêt CIC",null,null,null,0,null,"Prêt CIC",null,null,null,0,null,"Prêt CIC",null,null,null,0]
[null,"TOTAL Charges",{"$f":"SUM(C4:C34)","v":39536.44},null,"TOTAL Produits",{"$f":"SUM(F4:F34)","v":34333.5},null,null,"TOTAL Charges",{"$f":"SUM(J4:J34)","v":18584.91},null,"TOTAL Produits",{"$f":"SUM(M4:M34)","v":28278.9987},null,"TOTAL Charges",{"$f":"SUM(P4:P34)","v":21431.310000000005},null,"TOTAL Produits",{"$f":"SUM(S4:S34)","v":25262.85},null,"TOTAL Charges",{"$f":"SUM(V4:V34)","v":48945.369999999995},null,"TOTAL Produits",{"$f":"SUM(Y4:Y34)","v":29350.5},null,"TOTAL Charges",{"$f":"SUM(AB4:AB34)","v":15922.67},null,"TOTAL Produits",{"$f":"SUM(AE4:AE34)","v":33738.520000000004},null,"TOTAL Charges",{"$f":"SUM(AH4:AH34)","v":12879.140000000001},null,"TOTAL Produits",{"$f":"SUM(AK4:AK34)","v":34830.35},null,"TOTAL Charges",{"$f":"SUM(AN4:AN34)","v":17181.469999999998},null,"TOTAL Produits",{"$f":"SUM(AQ4:AQ34)","v":25961.219999999998}]
[]
[null,"Exercice 2016 (Produits - Charges) =  -5202,94 €",null,null,null,null,null,null,"Exercice 2017 (Produits - Charges) =  +9694,09 €",null,null,null,null,null,"Exercice 2018 (Produits - Charges) =  +3831,54 €",null,null,null,null,null,"Exercice 2019 (Produits - Charges) = ",null,null,null,{"$f":"Y35-V35","v":-19594.869999999995},null,"Exercice 2020 (Produits - Charges) = ",null,null,null,{"$f":"AE35-AB35","v":17815.850000000006},null,"Exercice 2021 (Produits - Charges) = ",null,null,null,{"$f":"AK35-AH35","v":21951.21},null,"Exercice 2022 (Produits - Charges) = ",null,null,null,{"$f":"AQ35-AN35","v":8779.75}]

{"sheet":"Bilan ULM","index":3,"n_rows":37,"n_cols":42,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,31,0,35],[1,31,1,32],[1,34,1,35],[36,31,36,34],[36,37,36,40],[0,37,0,41],[1,37,1,38],[1,40,1,41],[0,13,0,17],[1,13,1,14],[1,16,1,17],[36,13,36,17],[0,25,0,29],[1,25,1,26],[1,28,1,29],[36,25,36,28],[0,19,0,23],[1,19,1,20],[1,22,1,23],[36,19,36,22],[0,1,0,5],[1,1,1,2],[1,4,1,5],[36,1,36,5],[0,7,0,11],[1,7,1,8],[1,10,1,11],[36,7,36,11]]}
[null,"Charges et produits ULM 2016",null,null,null,null,null,"Charges et produits ULM 2017",null,null,null,null,null,"Charges et produits ULM 2018",null,null,null,null,null,"Charges et produits ULM 2019",null,null,null,null,null,"Charges et produits ULM 2020",null,null,null,null,null,"Charges et produits ULM 2021",null,null,null,null,null,"Charges et produits ULM 2022"]
[null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS"]
[]
[null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"Assemblée Générale",null,null,"AG_2019",null,null,"AG_2019",null,null,"AG_2019",null,null,"AG_2019",null,null,"AG_2019",null,null,"AG_2019"]
[null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Soirée crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes",null,null,"Journée_crêpes"]
[null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI",null,null,"Cartes_OACI"]
[null,"Locations hangars 2016",null,null,"Locations hangars 2016",null,null,"Locations hangars 2017",null,null,"Locations hangars 2017",null,null,"Locations hangars 2018",null,null,"Locations hangars 2018",null,null,"Locations hangars 2018",null,null,"Locations hangars 2018",null,null,"Hangars_2018",null,null,"Location_hangar",null,null,"Hangars_2018",null,null,"Location_hangar",null,null,"Hangars_2018",null,null,"Location_hangar"]
[null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage"]
[null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence_approvisionnement",null,null,"Essence_basés",null,null,"Essence_approvisionnement",null,null,"Essence_basés",null,null,"Essence_approvisionnement",null,null,"Essence_basés"]
[null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",null,null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",null,null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",null,null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",null,null,"Essence_prise_extérieur",null,null,"Essence_extérieur",null,null,"Essence_prise_extérieur",null,null,"Essence_extérieur",null,null,"Essence_prise_extérieur",null,null,"Essence_extérieur"]
[null,"Cartes Vac",null,null,"Cotisations membres",null,null,"Cartes Vac",null,null,"Cotisations membres",null,null,"Cartes Vac",null,null,"Cotisations membres",null,null,"Cartes Vac",null,null,"Cotisations membres",null,null,"Cartes_VAC",null,null,"cotis_membre",null,null,"Cartes_VAC",null,null,"cotis_membre",null,null,"Cartes_VAC",null,null,"cotis_membre"]
[null,"Entretien Océanair",null,null,"Cotisations pilotes",null,null,"Entretien Océanair",null,null,"Cotisations pilotes",null,null,"Entretien Océanair",null,null,"Cotisations pilotes",null,null,"Entretien Océanair",null,null,"Cotisations pilotes",null,null,"Frais_déplacement",null,null,"cotis_pilote",null,null,"Frais_déplacement",null,null,"cotis_pilote",null,null,"Frais_déplacement",null,null,"cotis_pilote"]
[null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Entretien_avion",null,null,"Océanair_simple",null,null,"Entretien_avion",null,null,"Océanair_simple",null,null,"Entretien_avion",null,null,"Océanair_simple"]
[null,"Frais de déplacement instructeur",550,null,"Vols Océanair en double",null,null,"Frais de déplacement instructeur",682,null,"Vols Océanair en double",null,null,"Frais de déplacement instructeur",682,null,"Vols Océanair en double",null,null,"Frais de déplacement instructeur",825,null,"Vols Océanair en double",null,null,"Assurance_avion",null,null,"Océanair_double",null,null,"Assurance_avion",null,null,"Océanair_double",null,null,"Assurance_avion",null,null,"Océanair_double"]
[null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Déplacement_Instructeur",1065,null,"Océanair_initiation",null,null,"Déplacement_Instructeur",1857.6,null,"Océanair_initiation",null,null,"Déplacement_Instructeur",1344.6,null,"Océanair_initiation"]
[null,"Approvisionnement Bar",null,null,"Caisse bar",null,null,"Approvisionnement Bar",null,null,"Caisse bar",null,null,"Approvisionnement Bar",null,null,"Caisse bar",null,null,"Approvisionnement Bar",null,null,"Caisse bar",null,null,"Cotisation_FFA",null,null,"Cotisation_FFA",null,null,"Cotisation_FFA",null,null,"Cotisation_FFA",null,null,"Cotisation_FFA",null,null,"Cotisation_FFA"]
[null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bar",null,null,"Caisse_Bar",null,null,"Bar",null,null,"Caisse_Bar",null,null,"Bar",null,null,"Caisse_Bar"]
[null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse"]
[null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0]
[null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture",null,null,"Nourriture"]
[null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol"]
[null,"Frais de déplacements autres",81.599999999999994,null,"Dons",null,null,"Frais de déplacements autres",223.8,null,"Dons",null,null,"Frais de déplacements autres",null,null,"Dons",null,null,"Frais de déplacements autres",null,null,"Dons",null,null,"Assurance_locaux",null,null,"Don",null,null,"Assurance_locaux",null,null,"Don",null,null,"Assurance_locaux",null,null,"Don"]
[null,"Assurance locaux Aéroclub",null,null,"Locations tables",null,null,"Assurance locaux Aéroclub",null,null,"Locations tables",null,null,"Assurance locaux Aéroclub",null,null,"Locations tables",null,null,"Assurance locaux Aéroclub",null,null,"Locations tables",null,null,"Cotisation_CRA20_RSA",null,null,"Intérêts_Livret",null,null,"Cotisation_CRA20_RSA",null,null,"Intérêts_Livret",null,null,"Cotisation_CRA20_RSA",null,null,"Intérêts_Livret"]
[null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",null,null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",null,null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",null,null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",null,null,"Papeterie",null,null,"Location_tables",null,null,"Papeterie",null,null,"Location_tables",null,null,"Papeterie",null,null,"Location_tables"]
[null,"Orange internet",null,null,"Divers",null,null,"Orange internet",null,null,"Divers",null,null,"Orange internet",null,null,"Divers",null,null,"Orange internet",null,null,"Divers",null,null,"Location_Avion extérieur",null,null,"Remboursement_Avion extérieur",null,null,"Location_Avion extérieur",null,null,"Remboursement_Avion extérieur",null,null,"Location_Avion extérieur",null,null,"Remboursement_Avion extérieur"]
[null,"Papeterie",null,null,"Vols initiation Océanair",null,null,"Papeterie",null,null,"Vols initiation Océanair",null,null,"Papeterie",null,null,"Vols initiation Océanair",null,null,"Papeterie",null,null,"Vols initiation Océanair",null,null,"Free",null,null,"Divers",null,null,"Free",null,null,"Divers",null,null,"Free",null,null,"Divers"]
[null,"Divers",null,null,"Baptême en ULM",140,null,"Divers",null,null,"Baptême en ULM",{"$f":"Exercice!L29","v":159.19999999999999},null,"Divers",null,null,"Baptême en ULM",{"$f":"Exercice!R29","v":120},null,"Divers",null,null,"Baptême en ULM",{"$f":"Exercice!X29","v":180.2},null,"Divers",null,null,"ULM_simple",5410.8,null,"Divers",null,null,"ULM_simple",7876.8,null,"Divers",null,null,"ULM_simple",{"$f":"Exercice!AP27","v":6479.6999999999971}]
[null,"Remboursements prêt ULM",2753.4,null,"Vols ULM en simple",1809.8,null,"Remboursements prêt ULM",{"$f":"Exercice!I28","v":2753.3999999999996},null,"Vols ULM en simple",{"$f":"Exercice!L27","v":2856},null,"Remboursements prêt ULM",{"$f":"Exercice!O28","v":2753.3999999999996},null,"Vols ULM en simple",{"$f":"Exercice!R27","v":4603.6000000000022},null,"Remboursements prêt ULM",{"$f":"Exercice!U28","v":2753.3999999999996},null,"Vols ULM en simple",{"$f":"Exercice!X27","v":5136.0000000000018},null,"ULM_Prêt_CIC",2753.4,null,"ULM_double",6816.6,null,"ULM_Prêt_CIC",2753.4,null,"ULM_double",11233.6,null,"ULM_Prêt_CIC",{"$f":"Exercice!AM28","v":1147.2},null,"ULM_double",{"$f":"Exercice!AP28","v":10820.100000000002}]
[null,"Entretien ULM",1065.01,null,"Vols ULM en double",7344.6,null,"Entretien ULM",{"$f":"Exercice!I29","v":557.66999999999996},null,"Vols ULM en double",{"$f":"Exercice!F29","v":7344.6},null,"Entretien ULM",{"$f":"Exercice!O29","v":18689.809999999998},null,"Vols ULM en double",{"$f":"Exercice!R28","v":8055.5999999999976},null,"Entretien ULM",{"$f":"Exercice!U29","v":1594.9},null,"Vols ULM en double",{"$f":"Exercice!X28","v":12002.199999999993},null,"ULM_entretien",361.41,null,"ULM_initiation",541.20000000000005,null,"ULM_entretien",2210.52,null,"ULM_initiation",262.8,null,"ULM_entretien",{"$f":"Exercice!AM29","v":1266.45},null,"ULM_initiation",{"$f":"Exercice!AP29","v":307.85000000000002}]
[null,"Essence pour ULM",1680.11,null,"Subventions Océanair",null,null,"Essence pour ULM",{"$f":"Exercice!I30","v":2213.14},null,"Subventions Océanair",null,null,"Essence pour ULM",{"$f":"Exercice!O30","v":937.00999999999988},null,"Subventions Océanair",null,null,"Essence pour ULM",{"$f":"Exercice!U30","v":0},null,"Subventions Océanair",null,null,"Entretien locaux",null,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",null,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",null,null,"ULM_souscription_trésorerie",0]
[null,"Assurance de l'ULM",1930,null,null,null,null,"Assurance de l'ULM",{"$f":"Exercice!I31","v":1333.94},null,null,null,null,"Assurance de l'ULM",{"$f":"Exercice!O31","v":1356.35},null,null,null,null,"Assurance de l'ULM",{"$f":"Exercice!U31","v":1911.74},null,"Subventions ULM",223.96,null,"ULM_assurance",1600,null,"Océanair_Subventions",0,null,"ULM_assurance",1838.78,null,"Océanair_Subventions",0,null,"ULM_assurance",{"$f":"Exercice!AM31","v":2019.6599999999999},null,"Océanair_Subventions",0]
[null,"Baptême en ULM remise",60,null,null,null,null,"Baptême en ULM remise",{"$f":"Exercice!I32","v":30},null,null,null,null,"Baptême en ULM remise",{"$f":"Exercice!O32","v":35},null,null,null,null,"Baptême en ULM remise",{"$f":"Exercice!U32","v":0},null,null,null,null,"ULM_baptême_remise",0,null,"Prêt CIC",null,null,"Kit ULM",21400,null,"Prêt CIC kit ULM",21400,null,"Kit ULM",null,null,"Prêt CIC kit ULM"]
[null,"Remboursement souscription ULM",0,null,null,null,null,"Remboursement souscription ULM",0,null,null,null,null,"Remboursement souscription ULM",0,null,null,null,null,"Remboursement souscription ULM",0,null,null,null,null,"ULM_rembt_souscription",0,null,"ULM subvention",null,null,"ULM_rembt_souscription",0,null,"ULM subvention",2000,null,"ULM_rembt_souscription",0,null,"ULM subvention"]
[null,"Moteur Avion Océanair",null,null,null,null,null,"Moteur Avion Océanair",null,null,null,null,null,"Moteur Avion Océanair",null,null,null,null,null,"Moteur Avion Océanair",null,null,null,null,null,"Prêt CIC",null,null,null,0,null,"Prêt CIC",null,null,null,0,null,"Prêt CIC",null,null,null,0]
[null,"TOTAL Charges",{"$f":"SUM(C4:C34)","v":8120.12},null,"TOTAL Produits",{"$f":"SUM(F4:F34)","v":9294.4},null,"TOTAL Charges",{"$f":"SUM(I4:I34)","v":7793.9500000000007},null,"TOTAL Produits",{"$f":"SUM(L4:L34)","v":10359.799999999999},null,"TOTAL Charges",{"$f":"SUM(O4:O34)","v":24453.569999999996},null,"TOTAL Produits",{"$f":"SUM(R4:R34)","v":12779.2},null,"TOTAL Charges",{"$f":"SUM(U4:U34)","v":7085.0399999999991},null,"TOTAL Produits",{"$f":"SUM(X4:X34)","v":17542.359999999993},null,"TOTAL Charges",{"$f":"SUM(AA4:AA34)","v":5779.81},null,"TOTAL Produits",{"$f":"SUM(AD4:AD34)","v":12768.600000000002},null,"TOTAL Charges",{"$f":"SUM(AG4:AG34)","v":30060.300000000003},null,"TOTAL Produits",{"$f":"SUM(AJ4:AJ34)","v":42773.2},null,"TOTAL Charges",{"$f":"SUM(AM4:AM34)","v":5777.91},null,"TOTAL Produits",{"$f":"SUM(AP4:AP34)","v":17607.649999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,"Exercice 2016 (Produits - Charges) = + 1174,28 €",null,null,null,null,null,"Exercice 2017 (Produits - Charges) = + 2565,85 €",null,null,null,null,null,"Exercice 2018 (Produits - Charges) = - 11673,72 € ",null,null,null,null,null,"Exercice 2019 (Produits - Charges) =  ",null,null,null,{"$f":"X35-U35","v":10457.319999999994},null,"Exercice 2020 (Produits - Charges) = ",null,null,null,{"$f":"AD35-AA35","v":6988.7900000000018},null,"Exercice 2021 (Produits - Charges) = ",null,null,null,{"$f":"AJ35-AG35","v":12712.899999999994},null,"Exercice 2022 (Produits - Charges) = ",null,null,null,{"$f":"AP35-AM35","v":11829.739999999998}]

{"sheet":"Bilan Savannah","index":4,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,2],[1,4,1,5],[39,1,39,4]]}
[null,"Charges et produits Savannah 2022"]
[null,"CHARGES",null,null,"PRODUITS"]
[]
[null,"AG_2021",null,null,"AG_2021"]
[null,"Journée_crêpes",null,null,"Journée_crêpes"]
[null,"Cartes_OACI",null,null,"Cartes_OACI"]
[null,"Hangars_2019",null,null,"Location_hangar"]
[null,"Taxe_atterrissage",null,null,"Taxe_atterrissage"]
[null,"Essence_approvisionnement",null,null,"Essence_basés"]
[null,"Essence_prise_extérieur",null,null,"Essence_extérieur"]
[null,"Cartes_VAC",null,null,"cotis_membre"]
[null,"Frais_déplacement",null,null,"cotis_pilote"]
[null,"Entretien_avion",null,null,"Océanair_simple"]
[null,"Assurance_avion",null,null,"Océanair_double"]
[null,"Déplacement_Instructeur",null,null,"Océanair_initiation"]
[null,"Cotisation_FFA",null,null,"Cotisation_FFA"]
[null,"Bar",null,null,"Caisse_Bar"]
[null,"Bourse",0,null,"Bourse",0]
[null,"BIA",0,null,"BIA",0]
[null,"Nourriture",null,null,"Nourriture"]
[null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol"]
[null,"Assurance_locaux",null,null,"Don"]
[null,"Cotisation_CRA20_RSA",null,null,"Intérêts_Livret"]
[null,"Papeterie",null,null,"Location_tables"]
[null,"Location_Avion extérieur",null,null,"Remboursement_Avion extérieur"]
[null,"Free",null,null,"Divers"]
[null,"Divers",null,null,"ULM_simple"]
[null,"ULM_Prêt_CIC",null,null,"ULM_double"]
[null,"ULM_entretien",null,null,"ULM_initiation"]
[null,"Entretien locaux",null,null,"ULM_souscription_trésorerie",0]
[null,"ULM_assurance",null,null,"Océanair_Subventions",0]
[null,"Kit ULM",38783.009999999995]
[null,"Mezzanine",null,null,"ULM subvention"]
[null,"Prêt CIC",null,null,null,0]
[null,"Repas construction kit ULM",2017.07,null,"Repas construction kit ULM",2301.4499999999998]
[null,"Prêt  Kit ULM",3652.2299999999996]
[null,"Repas rassemblement ACAA",null,null,"Repas rassemblement ACAA"]
[null,"TOTAL Charges",{"$f":"SUM(C4:C37)","v":44452.31},null,"TOTAL Produits",{"$f":"SUM(F4:F37)","v":2301.4499999999998}]
[]
[null,"Exercice 2022 (Produits - Charges) = ",null,null,null,{"$f":"F38-C38","v":-42150.86}]

{"sheet":"Bilan CLUB","index":5,"n_rows":40,"n_cols":42,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,37,0,41],[1,37,1,38],[1,40,1,41],[37,37,37,40],[0,31,0,35],[1,31,1,32],[1,34,1,35],[37,31,37,34],[0,13,0,17],[1,13,1,14],[1,16,1,17],[37,13,37,17],[0,25,0,29],[1,25,1,26],[1,28,1,29],[37,25,37,28],[0,19,0,23],[1,19,1,20],[1,22,1,23],[37,19,37,22],[0,1,0,5],[1,1,1,2],[1,4,1,5],[37,1,37,5],[0,7,0,11],[1,7,1,8],[1,10,1,11],[37,7,37,11]]}
[null,"Charges et produits Club 2016",null,null,null,null,null,"Charges et produits Club 2017",null,null,null,null,null,"Charges et produits Club 2018",null,null,null,null,null,"Charges et produits Club 2019",null,null,null,null,null,"Charges et produits Club 2020",null,null,null,null,null,"Charges et produits Club 2021",null,null,null,null,null,"Charges et produits Club 2022"]
[null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS",null,null,"CHARGES",null,null,"PRODUITS"]
[]
[null,"Assemblée Générale",514.1,null,"Assemblée Générale",306,null,"Assemblée Générale",{"$f":"Exercice!I4","v":658.4},null,"Assemblée Générale",{"$f":"Exercice!L4","v":322.29999999999995},null,"Assemblée Générale",{"$f":"Exercice!O4","v":492.2},null,"Assemblée Générale",{"$f":"Exercice!R4","v":321.29999999999995},null,"Assemblée Générale",{"$f":"Exercice!U4","v":234.6},null,"Assemblée Générale",{"$f":"Exercice!X4","v":0},null,"AG_2019",625,null,"AG_2019",525,null,"AG_2020",0,null,"AG_2020",0,null,"AG_2021",{"$f":"Exercice!AM4","v":623.20000000000005},null,"AG_2021",{"$f":"Exercice!AP4","v":475.03999999999985}]
[null,"Soirée crêpes",186,null,"Soirée crêpes",655,null,"Soirée crêpes",{"$f":"Exercice!I5","v":358.53999999999996},null,"Soirée crêpes",{"$f":"Exercice!L5","v":490},null,"Soirée crêpes",{"$f":"Exercice!O5","v":0},null,"Soirée crêpes",{"$f":"Exercice!R5","v":0},null,"Soirée crêpes",{"$f":"Exercice!U5","v":328.8},null,"Soirée crêpes",{"$f":"Exercice!X5","v":1030},null,"Journée_crêpes",305.83,null,"Journée_crêpes",385,null,"Journée_crêpes",0,null,"Journée_crêpes",0,null,"Journée_crêpes",{"$f":"Exercice!AM5","v":410.59999999999997},null,"Journée_crêpes",{"$f":"Exercice!AP5","v":1380}]
[null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",null,null,"Cartes OACI",104.44,null,"Cartes OACI",null,null,"Cartes_OACI",184.72,null,"Cartes_OACI",null,null,"Cartes_OACI",156.15,null,"Cartes_OACI",null,null,"Cartes_OACI",{"$f":"Exercice!AM6-Exercice!AP6","v":201.99},null,"Cartes_OACI"]
[null,"Locations hangars 2014",null,null,"Locations hangars 2014",null,null,"Locations hangars 2014",null,null,"Locations hangars 2014",null,null,"Locations hangars 2018",null,null,"Locations hangars 2018",3720,null,"Locations hangars 2018",3600,null,"Locations hangars 2018",3880,null,"Hangars_2018",3600,null,"Location_hangar",4020,null,"Hangars_2018",7600,null,"Location_hangar",3840,null,"Hangars_2018",{"$f":"Exercice!AM7","v":4000},null,"Location_hangar",3840]
[null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxes d'atterrissages",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",null,null,"Taxe_atterrissage",{"$f":"Exercice!AM8-Exercice!AP8","v":21.759999999999998},null,"Taxe_atterrissage"]
[null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence - Approvision cuve",null,null,"Essence - Pilotes basés",null,null,"Essence - Approvision cuve",7878.52,null,"Essence - Pilotes basés",3977.46,null,"Essence_approvisionnement",24702.13,null,"Essence_basés",3490.22,null,"Essence_approvisionnement",25383.82,null,"Essence_basés",4853.42,null,"Essence_approvisionnement",{"$f":"Exercice!AM9","v":22546.85},null,"Essence_basés",{"$f":"Exercice!AP9","v":4620.7999999999993}]
[null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",null,null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",null,null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",1213.71,null,"Essence - Terrains extérieurs",null,null,"Essence - Avions extérieurs",214.92,null,"Essence_prise_extérieur",null,null,"Essence_extérieur",671.99,null,"Essence_prise_extérieur",521.07000000000005,null,"Essence_extérieur",1496.15,null,"Essence_prise_extérieur",null,null,"Essence_extérieur",{"$f":"Exercice!AP10","v":5626.5499999999993}]
[null,"Cartes Vac",null,null,"Cotisations membres",245,null,"Cartes Vac",null,null,"Cotisations membres",{"$f":"Exercice!L11","v":420},null,"Cartes Vac",null,null,"Cotisations membres",{"$f":"Exercice!R11","v":350},null,"Cartes Vac",130.49,null,"Cotisations membres",{"$f":"Exercice!X11","v":245},null,"Cartes_VAC",107.49,null,"cotis_membre",315,null,"Cartes_VAC",109.43,null,"cotis_membre",445,null,"Cartes_VAC",null,null,"cotis_membre",{"$f":"Exercice!AP11","v":590}]
[null,"Entretien Océanair",null,null,"Cotisations pilotes",4770,null,"Entretien Océanair",null,null,"Cotisations pilotes",{"$f":"Exercice!L12","v":4167.5},null,"Entretien Océanair",null,null,"Cotisations pilotes",{"$f":"Exercice!R12","v":4114.2},null,"Entretien Océanair",null,null,"Cotisations pilotes",{"$f":"Exercice!X12","v":3830},null,"Frais_déplacement",661.2,null,"cotis_pilote",4765,null,"Frais_déplacement",1734.2,null,"cotis_pilote",5240,null,"Frais_déplacement",{"$f":"Exercice!AM12","v":289.8},null,"cotis_pilote",{"$f":"Exercice!AP12","v":4845}]
[null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Assurance de l'Océanair",null,null,"Vols Océanair en simple",null,null,"Entretien_avion",null,null,"Océanair_simple",null,null,"Entretien_avion",null,null,"Océanair_simple",null,null,"Entretien_avion",null,null,"Océanair_simple"]
[null,"Frais de déplacement instructeur",null,null,"Vols Océanair en double",null,null,"Frais de déplacement instructeur",null,null,"Vols Océanair en double",null,null,"Frais de déplacement instructeur",null,null,"Vols Océanair en double",null,null,"Frais de déplacement instructeur",null,null,"Vols Océanair en double",null,null,"Assurance_avion",null,null,"Océanair_double",null,null,"Assurance_avion",null,null,"Océanair_double",null,null,"Assurance_avion",null,null,"Océanair_double"]
[null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Cotisation FFA",null,null,"Déplacement_Instructeur",null,null,"Océanair_initiation",null,null,"Déplacement_Instructeur",null,null,"Océanair_initiation",null,null,"Déplacement_Instructeur",null,null,"Océanair_initiation"]
[null,"Approvisionnement Bar",212.13,null,"Caisse bar",460,null,"Approvisionnement Bar",{"$f":"Exercice!I16","v":344.14},null,"Caisse bar",{"$f":"Exercice!L17","v":450.18},null,"Approvisionnement Bar",{"$f":"Exercice!O17","v":353.41},null,"Caisse bar",{"$f":"Exercice!R17","v":645},null,"Approvisionnement Bar",{"$f":"Exercice!U17","v":655.05000000000007},null,"Caisse bar",{"$f":"Exercice!X17","v":862},null,"Cotisation_FFA",null,null,"Cotisation_FFA",null,null,"Cotisation_FFA",181.5,null,"Cotisation_FFA",null,null,"Cotisation_FFA",{"$f":"Exercice!AM16-Exercice!AP16","v":358.5},null,"Cotisation_FFA"]
[null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bar",648.27,null,"Caisse_Bar",805.05,null,"Bar",884.09,null,"Caisse_Bar",1129.5999999999999,null,"Bar",{"$f":"Exercice!AM17","v":1289.6499999999999},null,"Caisse_Bar",{"$f":"Exercice!AP17","v":1065.5}]
[null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"BIA",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse",null,null,"Bourse"]
[null,"Nourriture",928.92,null,"Nourriture",376,null,"Nourriture",{"$f":"Exercice!I19","v":665.96999999999991},null,"Nourriture",{"$f":"Exercice!L20","v":156},null,"Nourriture",{"$f":"Exercice!O20","v":821.0100000000001},null,"Nourriture",{"$f":"Exercice!R20","v":205},null,"Nourriture",{"$f":"Exercice!U20","v":1836.1000000000001},null,"Nourriture",{"$f":"Exercice!X20","v":194},null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0,null,"BIA",0]
[null,"Manuels et Carnets de vol",392.01,null,"Manuels et Carnets de vol",312,null,"Manuels et Carnets de vol",{"$f":"Exercice!I20","v":23.95},null,"Manuels et Carnets de vol",{"$f":"Exercice!L21","v":0},null,"Manuels et Carnets de vol",{"$f":"Exercice!O21","v":182.4},null,"Manuels et Carnets de vol",{"$f":"Exercice!R21","v":160},null,"Manuels et Carnets de vol",null,null,"Manuels et Carnets de vol",null,null,"Nourriture",1445.65,null,"Nourriture",822,null,"Nourriture",1732.08,null,"Nourriture",898,null,"Nourriture",{"$f":"Exercice!AM20","v":1451.9999999999998},null,"Nourriture",{"$f":"Exercice!AP20","v":780}]
[null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Location avion extérieur",null,null,"Remboursement avion extérieur",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol",null,null,"Manuel_Carnet_de_vol"]
[null,"Frais de déplacements autres",null,null,"Dons",2395,null,"Frais de déplacements autres",105.6,null,"Dons",{"$f":"Exercice!L22","v":200},null,"Frais de déplacements autres",2262.6,null,"Dons",{"$f":"Exercice!R22","v":0},null,"Frais de déplacements autres",2174.6,null,"Dons",{"$f":"Exercice!X22","v":0},null,"Assurance_locaux",1711,null,"Don",5861.92,null,"Assurance_locaux",1056,null,"Don",5100,null,"Assurance_locaux",{"$f":"Exercice!AM22","v":1096},null,"Don",{"$f":"Exercice!AP22","v":258.3}]
[null,"Assurance locaux Aéroclub",347,null,"Locations tables",54,null,"Assurance locaux Aéroclub",{"$f":"Exercice!I23","v":358},null,"Locations tables",{"$f":"Exercice!L24","v":0},null,"Assurance locaux Aéroclub",{"$f":"Exercice!O22","v":368},null,"Locations tables",{"$f":"Exercice!R24","v":74},null,"Assurance locaux Aéroclub",{"$f":"Exercice!U22","v":380},null,"Locations tables",{"$f":"Exercice!X24","v":0},null,"Cotisation_CRA20_RSA",null,null,"Intérêts_Livret",0,null,"Cotisation_CRA20_RSA",null,null,"Intérêts_Livret",32.6,null,"Cotisation_CRA20_RSA",null,null,"Intérêts_Livret",{"$f":"Exercice!AP23","v":0}]
[null,"Cotisation CRA 20 et RSA",260,null,"Intérêts livret association",315.47000000000003,null,"Cotisation CRA 20 et RSA",{"$f":"Exercice!I24","v":240},null,"Intérêts livret association",{"$f":"Exercice!L23","v":252.8},null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",{"$f":"Exercice!R23","v":0},null,"Cotisation CRA 20 et RSA",null,null,"Intérêts livret association",{"$f":"Exercice!X23","v":70.14},null,"Papeterie",235.79,null,"Location_tables",0,null,"Papeterie",246.22,null,"Location_tables",0,null,"Papeterie",{"$f":"Exercice!AM24","v":229.98},null,"Location_tables",{"$f":"Exercice!AP24","v":30}]
[null,"Orange internet",543.86,null,"Divers",233.5,null,"Orange internet",{"$f":"Exercice!I25","v":550.65},null,"Divers",{"$f":"Exercice!L26","v":2019.19},null,"Orange internet",{"$f":"Exercice!O26","v":524.56000000000006},null,"Divers",{"$f":"Exercice!R26","v":1121.28},null,"FREE",{"$f":"Exercice!U26","v":153.64000000000001},null,"Divers",{"$f":"Exercice!X26","v":696.06000000000006},null,"Location_Avion extérieur",null,null,"Remboursement_Avion extérieur",null,null,"Location_Avion extérieur",null,null,"Remboursement_Avion extérieur",null,null,"Location_Avion extérieur",null,null,"Remboursement_Avion extérieur"]
[null,"Papeterie",241.83,null,"Vols initiation Océanair",0,null,"Papeterie",{"$f":"Exercice!I26","v":23.7},null,"Vols initiation Océanair",0,null,"Papeterie",{"$f":"Exercice!O26","v":524.56000000000006},null,"Vols initiation Océanair",0,null,"Papeterie",{"$f":"Exercice!U24","v":148.21},null,"Vols initiation Océanair",0,null,"Free",305.25,null,"Divers",1473.38,null,"Free",305.19,null,"Divers",1003.48,null,"Free",{"$f":"Exercice!AM26","v":299.88000000000005},null,"Divers",{"$f":"Exercice!AP26","v":974.77}]
[null,"Divers",1701.11,null,"Baptême en ULM",null,null,"Divers",{"$f":"Exercice!I27","v":3966.4499999999989},null,"Baptême en ULM",null,null,"Divers",{"$f":"Exercice!O27","v":1354.4},null,"Baptême en ULM",null,null,"Divers",{"$f":"Exercice!U27","v":2235.9999999999995},null,"Baptême en ULM",null,null,"Divers",2346.89,null,"ULM_simple",null,null,"Divers",830.34,null,"ULM_simple",null,null,"Divers",{"$f":"Exercice!AM27","v":787.31999999999994},null,"ULM_simple"]
[null,"Remboursements prêt ULM",null,null,"Vols ULM en simple",null,null,"Remboursements prêt ULM",null,null,"Vols ULM en simple",null,null,"Remboursements prêt ULM",null,null,"Vols ULM en simple",null,null,"Remboursements prêt ULM",null,null,"Vols ULM en simple",null,null,"ULM_Prêt_CIC",null,null,"ULM_double",null,null,"ULM_Prêt_CIC",null,null,"ULM_double",null,null,"ULM_Prêt_CIC",null,null,"ULM_double"]
[null,"Entretien ULM",null,null,"Vols ULM en double",null,null,"Entretien ULM",null,null,"Vols ULM en double",null,null,"Entretien ULM",null,null,"Vols ULM en double",null,null,"Entretien ULM",null,null,"Vols ULM en double",null,null,"ULM_entretien",null,null,"ULM_initiation",null,null,"ULM_entretien",null,null,"ULM_initiation",null,null,"ULM_entretien",null,null,"ULM_initiation"]
[null,"Essence pour ULM",null,null,"Subventions Océanair",null,null,"Essence pour ULM",null,null,"Subventions Océanair",null,null,"Essence pour ULM",null,null,"Subventions Océanair",null,null,"Essence pour ULM",null,null,"Subventions Océanair",null,null,"Entretien locaux",200.25,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",238.48,null,"ULM_souscription_trésorerie",0,null,"Entretien locaux",{"$f":"Exercice!AM30","v":2977.0199999999991},null,"ULM_souscription_trésorerie",0]
[null,"Assurance de l'ULM",null,null,null,null,null,"Assurance de l'ULM",null,null,null,null,null,"Assurance de l'ULM",null,null,null,null,null,"Assurance de l'ULM",null,null,null,null,null,"ULM_assurance",null,null,"Océanair_Subventions",0,null,"ULM_assurance",null,null,"Océanair_Subventions",0,null,"ULM_assurance",null,null,"Océanair_Subventions",0]
[null,"Baptême en ULM remise",null,null,null,null,null,"Baptême en ULM remise",null,null,null,null,null,"Baptême en ULM remise",null,null,null,null,null,"Baptême en ULM remise",null,null,null,null,null,"ULM_baptême_remise",null,null,"Prêt CIC",null,null,"ULM_baptême_remise",null,null,"Prêt CIC",null,null,"ULM_baptême_remise",null,null,"Prêt CIC"]
[null,"Remboursement souscription ULM",1900,null,null,null,null,"Remboursement souscription ULM",{"$f":"Exercice!I33","v":1900},null,null,null,null,"Remboursement souscription ULM",{"$f":"Exercice!O33","v":1900},null,null,null,null,"Remboursement souscription ULM",{"$f":"Exercice!U33","v":1800},null,null,null,null,"ULM_rembt_souscription",null,null,"ULM subvention",null,null,"Mezzanine",9702.2099999999991,null,"ULM subvention",null,null,"Mezzanine",{"$f":"Exercice!AM33","v":1976.6699999999996},null,"ULM subvention"]
[null,"Moteur Avion Océanair",null,null,null,null,null,"Moteur Avion Océanair",null,null,null,null,null,"Moteur Avion Océanair",null,null,null,null,null,"Prêt CIC",833.35,null,"Prêt CIC",15000,null,"Prêt CIC",3069.96,null,null,0,null,"Prêt CIC",3069.96,null,"Prêt kit ULM",0,null,"Prêt CIC",{"$f":"Exercice!AM34","v":3069.96},null,"Prêt kit ULM",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repas rassemblement ACAA",853.11000000000013,null,"Repas rassemblement ACAA",713]
[null,"TOTAL Charges",{"$f":"SUM(C4:C34)","v":7226.96},null,"TOTAL Produits",{"$f":"SUM(F4:F34)","v":10121.969999999999},null,"TOTAL Charges",{"$f":"SUM(I4:I34)","v":9195.3999999999978},null,"TOTAL Produits",{"$f":"SUM(L4:L34)","v":8477.9700000000012},null,"TOTAL Charges",{"$f":"SUM(O4:O34)","v":8783.1400000000012},null,"TOTAL Produits",{"$f":"SUM(R4:R34)","v":11924.49},null,"TOTAL Charges",{"$f":"SUM(U4:U34)","v":22493.799999999996},null,"TOTAL Produits",{"$f":"SUM(X4:X34)","v":29999.579999999998},null,"TOTAL Charges",{"$f":"SUM(AA4:AA34)","v":40149.430000000008},null,"TOTAL Produits",{"$f":"SUM(AD4:AD34)","v":23134.560000000001},null,"TOTAL Charges",{"$f":"SUM(AG4:AG34)","v":53750.74},null,"TOTAL Produits",{"$f":"SUM(AJ4:AJ34)","v":24038.249999999996},null,"TOTAL Charges",{"$f":"SUM(AM4:AM35)","v":42484.289999999994},null,"TOTAL Produits",{"$f":"SUM(AP4:AP35)","v":25198.959999999999}]
[]
[null,"Exercice 2016 (Produits - Charges) = + 2895,01 € ",null,null,null,null,null,"Exercice 2017 (Produits - Charges) = - 717,43 € ",null,null,null,null,null,"Exercice 2018 (Produits - Charges) = + 3141,35 € ",null,null,null,null,null,"Exercice 2019 (Produits - Charges) = ",null,null,null,{"$f":"+(X36-U36)","v":7505.7800000000025},null,"Exercice 2020 (Produits - Charges) = ",null,null,null,{"$f":"AD36-AA36","v":-17014.870000000006},null,"Exercice 2021 (Produits - Charges) = ",null,null,null,{"$f":"AJ36-AG36","v":-29712.49},null,"Exercice 2022 (Produits - Charges) = ",null,null,null,{"$f":"AP36-AM36","v":-17285.329999999994}]
[null,null,null,null,"Dont 1900 € Remboursement Souscription ULM",null,null,null,null,null,"Dont 1900 € Remboursement Souscription ULM",null,null,null,null,null,"Dont 1900 € Remboursement Souscription ULM",null,null,null,null,null,"Dont 1800 € Remboursement Souscription ULM"]
[null,null,null,null,"Solde + 4795,01 €",null,null,null,null,null,"Solde + 1182,57 €",null,null,null,null,null,"Solde + 5041,35 €",null,null,null,null,null,"Solde + 9305,78 €"]

{"sheet":"Bilan 2022","index":6,"n_rows":202,"n_cols":7,"rows_kept":202,"cut":false,"hidden":false,"merged":[[4,0,4,3],[5,0,5,1],[5,2,5,3],[20,0,20,3],[21,0,21,1],[21,2,21,3],[39,0,39,3],[40,0,40,1],[40,2,40,3],[58,0,58,3],[59,0,59,1],[59,2,59,3],[78,0,78,3],[79,0,79,1],[79,2,79,3],[98,0,98,3],[99,0,99,1],[99,2,99,3],[140,0,140,3],[141,0,141,1],[141,2,141,3],[119,0,119,3],[120,0,120,1],[120,2,120,3],[182,0,182,3],[183,0,183,1],[183,2,183,3],[161,0,161,3],[162,0,162,1],[162,2,162,3]]}
["AERO CLUB DU BOCAGE",null,null,"2023-01-11"]
[]
[null,"BILAN"]
[]
[2013]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",{"$f":"60000-2000-6000-6000-6000","v":40000},"KX PROPRES",{"$f":"SUM(D9:D10)","v":66531.22}]
[null,null,"réserves",67301.27]
["STOCK (carburant)",{"$f":"4700*2.05144+0.23","v":9641.9979999999996},"résultat",-770.05]
[]
["DEBITEURS",0,"DETTES",{"$f":"SUM(D13:D14)","v":4429.92}]
[null,null,"emprunts",0]
[null,null,"fournisseurs",4429.92]
[]
["BANQUE",{"$f":"2601.47+21198.74","v":23800.210000000003},"CREDITEURS",2481.0700000000002,null,null,{"$f":"+B16-D16","v":21319.140000000003}]
[]
[null,{"$f":"SUM(B7:B17)","v":73442.207999999999},null,{"$f":"D8+D12+D16","v":73442.210000000006}]
[]
[]
[2014]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D25:D26)","v":67659.839999999997}]
["     - Océanair ",{"$f":"60000-2000-6000-6000-6000-6000","v":34000},"réserves",{"$f":"D8","v":66531.22}]
["     - ULM 2014",{"$f":"20000-2000","v":18000},"résultat",{"$f":"+'[2]Resultat 2014-2015'!E30","v":1128.6199999999953}]
[]
["STOCK (carburant)",{"$f":"+[3]STOCK!C7","v":13033.000636000001},null,null,null,null,{"$f":"20000-18669.29","v":1330.7099999999991}]
[]
["DEBITEURS",null,"DETTES",{"$f":"SUM(D31:D32)","v":28169.29}]
[null,null,"emprunts",{"$f":"9500+ 18669.29","v":28169.29},null,"Nouvel emprunt / ULM  + souscription"]
[null,null,"fournisseurs",0,null,"Facture entretien de 2014, non reçue et non payée au 31/12/2014 ?"," = non"]
[]
["BANQUE",{"$f":"3999.04+30243.52","v":34242.559999999998},"CREDITEURS",3446.43,null,"COMPTE PILOTE",{"$f":"+B34-D34","v":30796.129999999997}]
[]
[null,{"$f":"SUM(B23:B35)","v":99275.560635999995},null,{"$f":"D24+D30+D34","v":99275.56},null,{"$f":"+B36-D36","v":6.3599999703001231E-4}]
[]
[]
[]
[2015]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D44:D45)","v":73772.465682800015}]
["     - Océanair ",{"$f":"60000-2000-6000-6000-6000-6000-6000","v":28000},"réserves",{"$f":"+D24","v":67659.839999999997}]
["     - ULM 2014",{"$f":"20000-2000-4000","v":14000},"résultat",{"$f":"+'[2]Resultat 2014-2015'!H30","v":6112.6256828000114}]
[]
["STOCK (carburant)",{"$f":"+[2]Stock!C7","v":15300.745682800001}]
[]
["DEBITEURS",null,"DETTES",{"$f":"SUM(D50:D51)","v":23943.78}]
[null,null,"emprunts",{"$f":"(9500-1900)+ 16343.78","v":23943.78},null,null,{"$f":"18669.29-16343.78","v":2325.5100000000002}]
[null,null,"fournisseurs",0,null,"Facture entretien de 2015, non reçue et non payée au 31/12/2015 ?"," = non"]
[]
["BANQUE",{"$f":"1619.66+41425.97","v":43045.630000000005},"CREDITEURS",2630.13,null,"COMPTE PILOTE"]
[]
[null,{"$f":"SUM(B42:B54)","v":100346.3756828},null,{"$f":"D43+D49+D53","v":100346.37568280002},null,null,{"$f":"+D55-B55","v":0}]
[]
[]
[]
[2016]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D63:D64)","v":75714.407369600012}]
["     - Océanair ",{"$f":"60000-2000-6000-6000-6000-6000-6000-6000","v":22000},"réserves",{"$f":"+D43","v":73772.465682800015}]
["     - ULM 2014",{"$f":"20000-2000-4000-4000","v":10000},"résultat",{"$f":"+'[4]résultat 2016'!H30","v":1941.9416867999971}]
["     - moteur avion 2016",{"$f":"(8300.84+3300)-2320.17","v":9280.67}]
[]
["STOCK (carburant)",{"$f":"+[4]Stock!C7","v":10606.569686800001}]
[]
["DEBITEURS",null,"DETTES",{"$f":"SUM(D70:D71)","v":19661.11}]
[null,null,"emprunts",{"$f":"(9500-1900-1900)+13961.11","v":19661.11}]
[null,null,"fournisseurs",0]
[]
["BANQUE",44963.02,"CREDITEURS",1474.74]
[]
[null,{"$f":"SUM(B61:B74)","v":96850.259686799996},null,{"$f":"D62+D69+D73","v":96850.257369600018},{"$f":"+B75-D75","v":2.3171999782789499E-3}]
[]
[]
[]
[2017]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D83:D84)","v":80119.709369599994}]
["     - Océanair ",{"$f":"60000-2000-6000-6000-6000-6000-6000-6000-6000","v":16000},"réserves",{"$f":"+D62","v":75714.407369600012}]
["     - ULM 2014",{"$f":"20000-2000-4000-4000-4000","v":6000},"résultat",{"$f":"+'[5]résultat 2017'!H30","v":4405.3019999999888}]
["     - moteur avion 2016",{"$f":"(8300.84+3300)-2320.17*2","v":6960.5}]
[]
["STOCK (carburant)",{"$f":"+[5]Stock!C7","v":2977.44}]
[]
["DEBITEURS",null,"DETTES",{"$f":"SUM(D90:D91)","v":15319.92}]
[null,null,"emprunts",{"$f":"(9500-1900-1900-1900)+11519.92","v":15319.92}]
[null,null,"fournisseurs",0]
[]
["BANQUE",{"$f":"8289.38+57252.8","v":65542.180000000008},"CREDITEURS",2040.49]
[]
[null,{"$f":"SUM(B81:B94)","v":97480.12000000001},null,{"$f":"D82+D89+D93","v":97480.119369599997},{"$f":"+B95-D95","v":6.3040001259651035E-4}]
[]
[]
[]
[2018]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D103:D104)","v":75134.702569599991}]
["     - Océanair ",{"$f":"60000-2000-6000-6000-6000-6000-6000-6000-6000-6000","v":10000},"réserves",{"$f":"+D82","v":80119.709369599994}]
["     - ULM 2014",{"$f":"20000-2000-4000-4000-4000-4000","v":2000},"résultat",{"$f":"+'Resultat 2022'!H33","v":-4985.0068000000028}]
["     - moteur avion 2016",{"$f":"(8300.84+3300)-2320.17*3","v":4640.33}]
["     - moteur ULM 2018",{"$f":"14896.8-372.42","v":14524.38}]
["IMMOS EN-COURS"]
["     - Entoilage 2018-2019",3000]
[]
["STOCK (carburant)",{"$f":"+Stock!C7","v":15380.8212}]
[]
["DEBITEURS",null,"DETTES",{"$f":"SUM(D113:D114)","v":10918.73}]
[null,null,"emprunts",{"$f":"(9500-1900-1900-1900-1900)+9018.73","v":10918.73}]
[null,null,"fournisseurs",0]
[]
["BANQUE",{"$f":"1454.03+39752.82","v":41206.85},"CREDITEURS",4698.95]
[]
[null,{"$f":"SUM(B101:B117)","v":90752.381200000003},null,{"$f":"D102+D112+D116","v":90752.382569599984},{"$f":"+B118-D118","v":-1.3695999805349857E-3}]
[]
[2019]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D124:D125)","v":73646.498854831836}]
["     - Océanair ",{"$f":"Immos!C14","v":4000},"réserves",{"$f":"+D103+D104","v":75134.702569599991}]
["     - ULM 2014",0,"résultat",{"$f":"'Resultat 2022'!I33","v":-1488.2037147681549}]
["     - moteur avion 2016",{"$f":"Immos!C32","v":2320.168000000001}]
["     - moteur ULM 2018",{"$f":"Immos!C39","v":11545.02}]
["     - Entoilage 2018-2019",{"$f":"Immos!C49","v":35333.824500000002}]
[]
[null,null,"DETTES",{"$f":"SUM(D131:D133)","v":20822.165658617814}]
["STOCK (carburant)",{"$f":"Stock!D7","v":6393.5221267239658},"Prêt ULM",{"$f":"'Prêt ULM'!I73","v":6456.0731000374553}]
[null,null,"Prêt Réentoilage",{"$f":"'Prêt 4204'!I9","v":14266.09255858036}]
["DEBITEURS",null,"Souscription ULM",100]
[]
[]
[]
["BANQUE",44483.22,"CREDITEURS",9607.09]
[]
[null,{"$f":"SUM(B122:B138)","v":104075.75462672397},null,{"$f":"D123+D130+D137","v":104075.75451344965},{"$f":"+B139-D139","v":1.1327432002872229E-4}]
[]
[2020]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D145:D146)","v":82482.772459894739}]
["     - Océanair ",{"$f":"Immos!C15","v":0},"réserves",{"$f":"+D124+D125","v":73646.498854831836}]
["     - ULM 2014",0,"résultat",{"$f":"'Resultat 2022'!L33","v":8836.2736050629028}]
["     - moteur avion 2016",{"$f":"Immos!C33","v":0}]
["     - moteur ULM 2018",{"$f":"Immos!C40","v":8565.66}]
["     - Entoilage 2018-2019",{"$f":"Immos!C50","v":33521.833500000001}]
[]
[null,null,"DETTES",{"$f":"SUM(D152:D154)","v":15244.165926830934}]
["STOCK (carburant)",{"$f":"Stock!H7","v":12873.545},"Prêt ULM",{"$f":"'Prêt ULM'!I85","v":3830.4502781225001}]
[null,null,"Prêt Réentoilage",{"$f":"'Prêt 4204'!I21","v":11313.715648708434}]
["DEBITEURS",null,"Souscription ULM",100]
[]
[]
[]
["BANQUE",{"$f":"'Situation bancaire'!I6+'Situation bancaire'!I7","v":51440.06},"CREDITEURS",{"$f":" 'Situation bancaire'!I8","v":8674.16}]
[]
[null,{"$f":"SUM(B143:B159)","v":106401.09849999999},null,{"$f":"D144+D151+D158","v":106401.09838672567},{"$f":"+B160-D160","v":1.1327432002872229E-4}]
[]
[2021]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D166:D167)","v":90807.540716436924}]
["     - Océanair ",{"$f":"Immos!C15","v":0},"réserves",{"$f":"+D145+D146","v":82482.772459894739}]
["     - ULM 2014",0,"résultat",{"$f":"'Resultat 2022'!O33","v":8324.7682565421856}]
["     - moteur avion 2016",0]
["     - moteur ULM 2018",{"$f":"Immos!C41","v":5586.3}]
["     - Entoilage 2018-2019",{"$f":"Immos!C51","v":31709.842499999999}]
["     - Kit ULM",{"$f":"Immos!C63","v":21000}]
[null,null,"DETTES",{"$f":"SUM(D173:D176)","v":30974.669170288777}]
["STOCK (carburant)",{"$f":"Stock!I7","v":15768.547500000001},"Prêt ULM",{"$f":"'Prêt ULM'!I97","v":1140.3094013047096}]
[null,null,"Prêt Réentoilage",{"$f":"'Prêt 4204'!I33","v":8334.3597689840662}]
["DEBITEURS",null,"Prêt Kit ULM",21400]
[null,null,"Souscription ULM",100]
[]
[]
["BANQUE",{"$f":"'Situation bancaire'!J6+'Situation bancaire'!J7","v":59346.549999999996},"CREDITEURS",{"$f":" 'Situation bancaire'!J8","v":11629.03}]
[]
[null,{"$f":"SUM(B164:B180)","v":133411.24},null,{"$f":"D165+D172+D179","v":133411.2398867257},{"$f":"+B181-D181","v":1.1327429092489183E-4}]
[]
[2022]
["ACTIF",null,"PASSIF"]
[]
["IMMOS",null,"KX PROPRES",{"$f":"SUM(D187:D188)","v":49905.0435591399}]
["     - Océanair ",null,"réserves",{"$f":"+D166+D167","v":90807.540716436924}]
["     - ULM 2014",0,"résultat",{"$f":"'Resultat 2022'!R33","v":-40902.497157297024}]
["     - moteur avion 2016",0]
["     - moteur ULM 2018",{"$f":"Immos!C42","v":2606.9400000000005}]
["     - Entoilage 2018-2019",{"$f":"Immos!C52","v":29897.851499999997}]
["     - Kit ULM",{"$f":"Immos!C64","v":16800}]
[null,null,"DETTES",{"$f":"SUM(D194:D197)","v":23340.847827585796}]
["STOCK (carburant)",{"$f":"Stock!J7","v":15050.279999999999},"Prêt ULM",{"$f":"'Prêt ULM'!I109","v":3.950617610826157E-12}]
[null,null,"Prêt Réentoilage",{"$f":"'Prêt 4204'!I45","v":5327.7783842132376}]
["DEBITEURS",null,"Prêt Kit ULM",{"$f":"'Prêt Kit ULM'!I18","v":17913.069443372555}]
[null,null,"Souscription ULM",100]
[]
[]
["BANQUE",{"$f":"'Situation bancaire'!K6+'Situation bancaire'!K7","v":18779.75},"CREDITEURS",{"$f":" 'Situation bancaire'!K8","v":9888.93}]
[]
[null,{"$f":"SUM(B185:B201)","v":83134.821499999991},null,{"$f":"D186+D193+D200","v":83134.8213867257},{"$f":"+B202-D202","v":1.1327429092489183E-4}]

{"sheet":"Resultat 2022","index":7,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,5,1,10],[3,11,3,13],[3,17,3,19],[3,14,3,16],[3,2,3,4],[3,5,3,7],[3,8,3,10]]}
["AERO CLUB DU BOCAGE",null,null,null,null,null,null,null,null,null,{"$f":"+'Bilan 2022'!D1","v":"2023-01-11"}]
[null,null,null,null,null,"COMPTE DE RESULTAT"]
[]
[null,null,2017,null,null,2018,null,null,2019,null,null,2020,null,null,2021,null,null,2022]
[null,null,"Résultat","reclassement","Résultat","Résultat","reclassement","Résultat","Résultat","reclassement","Résultat","Résultat","reclassement","Résultat","Résultat","reclassement","Résultat","Résultat","reclassement","Résultat"]
[null,null,"présenté",null,"reclassé","présenté",null,"reclassé","présenté",null,"reclassé","présenté",null,"reclassé","présenté",null,"reclassé","présenté",null,"reclassé"]
["PRODUITS",null,{"$f":"SUM(C8:C14)","v":62849.849999999991},{"$f":"SUM(D8:D14)","v":0},{"$f":"+C7+D7","v":62849.849999999991},55296.14,0,55296.14,{"$f":"SUM(I8:I14)","v":63174.939999999988},{"$f":"SUM(J8:J14)","v":0},{"$f":"+I7+J7","v":63174.939999999988},{"$f":"SUM(L8:L14)","v":70827.179999999993},{"$f":"SUM(M8:M14)","v":0},{"$f":"+L7+M7","v":70827.179999999993},{"$f":"SUM(O8:O14)","v":106252.80000000002},{"$f":"SUM(P8:P14)","v":0},{"$f":"+O7+P7","v":106252.80000000002},{"$f":"SUM(R8:R15)","v":75491.189999999988},{"$f":"SUM(S8:S14)","v":0},{"$f":"+R7+S7","v":75491.189999999988}]
[null,"Adhésions, participation",{"$f":"420+4167.5","v":4587.5},null,{"$f":"+C8+D8","v":4587.5},4464.2,null,4464.2,{"$f":"Exercice!X11+Exercice!X12","v":4075},null,{"$f":"+I8+J8","v":4075},{"$f":"Exercice!AD11+Exercice!AD12","v":5080},null,{"$f":"+L8+M8","v":5080},{"$f":"Exercice!AJ11+Exercice!AJ12","v":5685},null,{"$f":"+O8+P8","v":5685},{"$f":"Exercice!AP11+Exercice!AP12","v":5435},null,{"$f":"+R8+S8","v":5435}]
[null,"Heures de vol",{"$f":"16093+10374+712+2856+8194.2+159.2","v":38388.399999999994},null,{"$f":"+C9+D9","v":38388.399999999994},34318.799999999996,null,34318.799999999996,{"$f":"Exercice!X13+Exercice!X14+Exercice!X15+Exercice!X27+Exercice!X28+Exercice!X29","v":43115.899999999994},null,{"$f":"+I9+J9","v":43115.899999999994},{"$f":"Exercice!AD13+Exercice!AD14+Exercice!AD15+Exercice!AD27+Exercice!AD28+Exercice!AD29","v":41053.1},null,{"$f":"+L9+M9","v":41053.1},{"$f":"Exercice!AJ13+Exercice!AJ14+Exercice!AJ15+Exercice!AJ27+Exercice!AJ28+Exercice!AJ29","v":54114.200000000004},null,{"$f":"+O9+P9","v":54114.200000000004},{"$f":"Exercice!AP13+Exercice!AP14+Exercice!AP15+Exercice!AP27+Exercice!AP28+Exercice!AP29","v":43221.869999999995},null,{"$f":"+R9+S9","v":43221.869999999995}]
[null,"Ventes carburants",{"$f":"1018.6+6184.85","v":7203.4500000000007},null,7203.4500000000007,5252.37,null,5252.37,{"$f":"Exercice!X9+Exercice!X10","v":4192.3799999999992},null,4192.3799999999992,{"$f":"Exercice!AD9+Exercice!AD10","v":4162.21},null,4162.21,{"$f":"Exercice!AJ9+Exercice!AJ10","v":6349.57},null,6349.57,{"$f":"Exercice!AP9+Exercice!AP10","v":10247.349999999999},null,10247.349999999999]
[null,"Souscription",0,null,0,0,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Bar",450.18,null,450.18,645,null,645,{"$f":"Exercice!X17","v":862},null,862,{"$f":"Exercice!AD17","v":805.05},null,805.05,{"$f":"Exercice!AJ17","v":1129.5999999999999},null,1129.5999999999999,{"$f":"Exercice!AP17","v":1065.5},null,1065.5]
[null,"Subventions reçus",300,null,300,700,null,700,{"$f":"Exercice!X19+Exercice!X33","v":590.96},null,590.96,{"$f":"Exercice!AD18","v":1000},null,1000,{"$f":"Exercice!AJ18+Exercice!AJ33","v":2000},null,2000,{"$f":"Exercice!AP18+Exercice!AP33","v":0},null,0]
[null,"Autres produits exploitation",{"$f":"322.3+490+1016.9+3800+175.13+2688+156+200+252.8+800+2019.19","v":11920.32},0,11920.32,9915.77,0,9915.77,{"$f":"SUM(Exercice!X4:X8)+SUM(Exercice!X16)+SUM(Exercice!X20:X26)","v":10338.700000000001},0,10338.700000000001,{"$f":"SUM(Exercice!AD4:AD8)+SUM(Exercice!AD16)+SUM(Exercice!AD20:AD26)","v":18726.82},0,18726.82,{"$f":"SUM(Exercice!AJ4:AJ8)+SUM(Exercice!AJ16)+SUM(Exercice!AJ20:AJ26)+Exercice!AJ32","v":36974.43},0,36974.43,{"$f":"SUM(Exercice!AP4:AP8)+SUM(Exercice!AP16)+SUM(Exercice!AP20:AP26)+Exercice!AP32+Exercice!AP37","v":13220.02},0,13220.02]
[null,"Kit ULM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Exercice!AP36","v":2301.4499999999998}]
["CHARGES",null,{"$f":"SUM(C17:C27)","v":58444.55},{"$f":"SUM(D17:D27)","v":0},{"$f":"+C16+D16","v":58444.55},60281.146800000002,0,60281.146800000002,{"$f":"SUM(I17:I27)","v":64663.143714768143},{"$f":"SUM(J17:J27)","v":0},{"$f":"+I16+J16","v":64663.143714768143},{"$f":"SUM(L17:L27)","v":61990.90639493709},{"$f":"SUM(M17:M27)","v":0},{"$f":"+L16+M16","v":61990.90639493709},{"$f":"SUM(O17:O27)","v":97928.031743457832},{"$f":"SUM(P17:P27)","v":0},{"$f":"+O16+P16","v":97928.031743457832},{"$f":"SUM(R17:R27)","v":116393.68715729701},{"$f":"SUM(S17:S27)","v":0},{"$f":"+R16+S16","v":116393.68715729701}]
[null,"Carburant",7470.4,null,7470.4,26717.79,null,26717.79,{"$f":"Exercice!U9+Exercice!U10","v":8367.07},null,8367.07,{"$f":"Exercice!AA9+Exercice!AA10","v":25210.83},null,25210.83,{"$f":"Exercice!AG9+Exercice!AG10","v":25904.89},null,25904.89,{"$f":"Exercice!AM9+Exercice!AM10","v":22935.17},null,22935.17]
[null,"var stock carburant",7629.13,null,7629.13,-12403.3812,null,-12403.3812,{"$f":"-Stock!D8","v":8987.2990732760336},null,8987.2990732760336,{"$f":"-Stock!H8","v":-6480.0228732760343},null,-6480.0228732760343,{"$f":"-Stock!I8","v":-2895.0025000000005},null,-2895.0025000000005,{"$f":"-Stock!J8","v":718.26750000000175},null,718.26750000000175]
[null,"Entretien",{"$f":"2927.08+557.67","v":3484.75},null,3484.75,13991.590000000002,null,13991.590000000002,{"$f":"Exercice!U13+Exercice!U29-19231.79-13500-508.03","v":5680.6900000000014},null,5680.6900000000014,{"$f":"Exercice!AA13+Exercice!AA29+Exercice!AA30","v":6624.87},null,6624.87,{"$f":"Exercice!AG13+Exercice!AG29+Exercice!AG30","v":11157.7},null,11157.7,{"$f":"Exercice!AM13+Exercice!AM29+Exercice!AM30","v":15182.06},null,15182.06]
[null,"Intérêt emprunt et frais",{"$f":"28.27+27.86+27.46+27.05+26.64+26.23+25.81+25.4+24.99+24.57+24.16+23.74+0.03","v":312.21000000000004},null,312.21000000000004,252.21,null,252.21,{"$f":"'Prêt ULM'!N73+'Prêt 4204'!N9+Exercice!U34-SUM('Prêt 4204'!M9:N9)","v":290.18114149211635},null,290.18114149211635,{"$f":"-'Prêt ULM'!M85-'Prêt 4204'!M21+Exercice!AA34+Exercice!AA28","v":245.36026821311998},null,245.36026821311998,{"$f":"-'Prêt ULM'!M97-'Prêt 4204'!M33+Exercice!AG34+Exercice!AG28","v":153.86324345784351},null,153.86324345784351,{"$f":"-'Prêt ULM'!M109-'Prêt 4204'!M45+Exercice!AM34+Exercice!AM28+Exercice!AM36-'Prêt Kit ULM'!M18","v":235.56865729701576},null,235.56865729701576]
[null,"Bar",344.14,null,344.14,353.41,null,353.41,{"$f":"Exercice!U17","v":655.05000000000007},null,655.05000000000007,{"$f":"Exercice!AA17","v":648.27},null,648.27,{"$f":"Exercice!AG17","v":884.09},null,884.09,{"$f":"Exercice!AM17","v":1289.6499999999999},null,1289.6499999999999]
[null,"Frais deplacement",1276,null,1276,1309,null,1309,{"$f":"Exercice!U15","v":1463},null,1463,{"$f":"Exercice!AA15","v":1725},null,1725,{"$f":"Exercice!AG15","v":2847.6},null,2847.6,{"$f":"Exercice!AM15","v":1872.5999999999979},null,1872.5999999999979]
[null,"Assurances",null,null,null,{"$f":"Exercice!O14+Exercice!O31","v":3960.27},null,3960.27,{"$f":"Exercice!U14+Exercice!U31","v":5235.1400000000003},null,5235.1400000000003,{"$f":"Exercice!AA14+Exercice!AA31","v":4500.7700000000004},null,4500.7700000000004,{"$f":"Exercice!AG14+Exercice!AG31","v":4819.87},null,4819.87,{"$f":"Exercice!AM14+Exercice!AM31","v":6732.19},null,6732.19]
[null,"Locatoin avion extérieur",null,null,null,710.25,null,710.25,{"$f":"Exercice!U25","v":3971.52},null,3971.52,{"$f":"Exercice!AA25","v":501},null,501,{"$f":"Exercice!AG25","v":0},null,0,{"$f":"Exercice!AM25","v":170},null,170]
[null,"Autres",{"$f":"658.4+358.54+1108.38+3800+175.13+2174.07+83+2555.13+2947.5+840+665.97+23.95+800+701.8+358+240+550.65+23.7+3966.45+2213.14+1333.94+30","v":25607.750000000004},null,25607.750000000004,{"$f":"17367.94-3960.27-710.25","v":12697.419999999998},null,12697.419999999998,{"$f":"SUM(Exercice!U4:U8)+SUM(Exercice!U11:U12)+SUM(Exercice!U18:U27)+Exercice!U32+Exercice!U16-I24","v":15807.669999999998},null,15807.669999999998,{"$f":"SUM(Exercice!AA4:AA8)+SUM(Exercice!AA11:AA12)+SUM(Exercice!AA18:AA27)+Exercice!AA32+Exercice!AA16-L24","v":17903.309999999998},null,17903.309999999998,{"$f":"SUM(Exercice!AG4:AG8)+SUM(Exercice!AG11:AG12)+SUM(Exercice!AG18:AG27)+Exercice!AG32+Exercice!AG16+Exercice!AG33-O24","v":49863.67},null,49863.67,{"$f":"SUM(Exercice!AM4:AM8)+SUM(Exercice!AM11:AM12)+SUM(Exercice!AM18:AM27)+Exercice!AM16+Exercice!AM33-R24+Exercice!AM37","v":17466.75},null,17466.75]
[null,"Kit ULM",null,null,null,null,null,null,null,null,0,null,null,0,null,null,0,{"$f":"Exercice!AM35+Exercice!AM32","v":40800.079999999994},null,40800.079999999994]
[null,"Amortissement",12320.17,null,12320.17,12692.588,null,12692.588,{"$f":"Immos!B71","v":14205.523499999999},null,14205.523499999999,{"$f":"Immos!B73","v":11111.518999999998},null,11111.518999999998,{"$f":"Immos!B75","v":5191.3509999999997},null,5191.3509999999997,{"$f":"Immos!B77","v":8991.3509999999987},null,8991.3509999999987]
[]
["RESULTAT EXPLOITATION",null,{"$f":"+C7-C16","v":4405.2999999999884},{"$f":"+D7-D16","v":0},{"$f":"+C29+D29","v":4405.2999999999884},-4985.0068000000028,0,-4985.0068000000028,{"$f":"+I7-I16","v":-1488.2037147681549},{"$f":"+J7-J16","v":0},{"$f":"+I29+J29","v":-1488.2037147681549},{"$f":"+L7-L16","v":8836.2736050629028},{"$f":"+M7-M16","v":0},{"$f":"+L29+M29","v":8836.2736050629028},{"$f":"+O7-O16","v":8324.7682565421856},{"$f":"+P7-P16","v":0},{"$f":"+O29+P29","v":8324.7682565421856},{"$f":"+R7-R16","v":-40902.497157297024},{"$f":"+S7-S16","v":0},{"$f":"+R29+S29","v":-40902.497157297024}]
[]
["Produit (ou perte) exceptionel",null,null,null,{"$f":"+C31+D31","v":0},null,null,0,null,null,{"$f":"+I31+J31","v":0},null,null,{"$f":"+L31+M31","v":0},null,null,{"$f":"+O31+P31","v":0},null,null,{"$f":"+R31+S31","v":0}]
[]
["BENEFICE OU PERTE",null,{"$f":"C29+C31","v":4405.2999999999884},{"$f":"D29+D31","v":0},{"$f":"+C33+D33","v":4405.2999999999884},-4985.0068000000028,0,-4985.0068000000028,{"$f":"I29+I31","v":-1488.2037147681549},{"$f":"J29+J31","v":0},{"$f":"+I33+J33","v":-1488.2037147681549},{"$f":"L29+L31","v":8836.2736050629028},{"$f":"M29+M31","v":0},{"$f":"+L33+M33","v":8836.2736050629028},{"$f":"O29+O31","v":8324.7682565421856},{"$f":"P29+P31","v":0},{"$f":"+O33+P33","v":8324.7682565421856},{"$f":"R29+R31","v":-40902.497157297024},{"$f":"S29+S31","v":0},{"$f":"+R33+S33","v":-40902.497157297024}]
[]
[]
[]
[null,null,null,null,"vérif si = dépenses",{"$f":"+F16+1900+'Prêt ULM - OLd'!A15+Immos!B36+Immos!B46-F18-F27","v":115529.75000000001}]

{"sheet":"Immos","index":8,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Immo et amort"]
[]
["Base",60000,"Oceanair 2010"]
[null,"AMORT","VNC","durée = 10 ans"]
[2010,2000,{"$f":"+B3-B5","v":58000}]
[2011,6000,{"$f":"C5-B6","v":52000}]
[2012,6000,{"$f":"C6-B7","v":46000}]
[2013,6000,{"$f":"C7-B8","v":40000}]
[2014,6000,{"$f":"C8-B9","v":34000}]
[2015,6000,{"$f":"C9-B10","v":28000}]
[2016,6000,22000]
[2017,6000,16000]
[2018,6000,10000]
[2019,6000,4000]
[2020,4000,0]
[]
["Base",20000,"ULM 2014","2014-06-02"]
[null,"AMORT","VNC","durée = 5 ans"]
[2014,{"$f":"$B$17/5*6/12","v":2000},{"$f":"+B17-B19","v":18000}]
[2015,{"$f":"$B$17/5","v":4000},{"$f":"C19-B20","v":14000}]
[2016,{"$f":"$B$17/5","v":4000},{"$f":"C20-B21","v":10000}]
[2017,{"$f":"$B$17/5","v":4000},{"$f":"C21-B22","v":6000}]
[2018,{"$f":"$B$17/5","v":4000},{"$f":"C22-B23","v":2000}]
[2019,{"$f":"$B$17/5*6/12","v":2000},{"$f":"C23-B24","v":0}]
[]
[]
["Base",{"$f":"8300.84+3300","v":11600.84},"moteur avion","2016-01-01"]
[null,"AMORT","VNC","durée = 5 ans"]
[2016,{"$f":"$B$27/5","v":2320.1680000000001},{"$f":"+B27-B29","v":9280.6720000000005}]
[2017,{"$f":"$B$27/5","v":2320.1680000000001},{"$f":"C29-B30","v":6960.5040000000008}]
[2018,{"$f":"$B$27/5","v":2320.1680000000001},{"$f":"C30-B31","v":4640.3360000000011}]
[2019,{"$f":"$B$27/5","v":2320.1680000000001},{"$f":"C31-B32","v":2320.168000000001}]
[2020,{"$f":"$B$27/5","v":2320.1680000000001},{"$f":"C32-B33","v":0}]
[]
[]
["Base",14896.8,"moteur ULM","2018-11-14","( sans emprunt )"]
[null,"AMORT","VNC","durée = 5 ans"]
[2018,{"$f":"$B$36/5*1.5/12","v":372.4199999999999},{"$f":"+B36-B38","v":14524.38}]
[2019,{"$f":"$B$36/5","v":2979.3599999999997},{"$f":"C38-B39","v":11545.02}]
[2020,{"$f":"$B$36/5","v":2979.3599999999997},{"$f":"C39-B40","v":8565.66}]
[2021,2979.3599999999997,{"$f":"C40-B41","v":5586.3}]
[2022,2979.3599999999997,{"$f":"C41-B42","v":2606.9400000000005}]
[2023,{"$f":"$B$36/5*10.5/12","v":2606.9399999999996},{"$f":"C42-B43","v":0}]
[]
[]
["Base",{"$f":"19231.79+3000+13500+508.03","v":36239.82},"Entoilage","mi - 2019",null,null,{"$f":"11500+2000","v":13500}]
[null,"AMORT","VNC","durée = 20 ans"]
[2018,0,{"$f":"+B46-B48","v":36239.82}]
[2019,{"$f":"$B$46/20/2","v":905.99549999999999},{"$f":"C48-B49","v":35333.824500000002}]
[2020,{"$f":"$B$46/20","v":1811.991},{"$f":"C49-B50","v":33521.833500000001}]
[2021,{"$f":"$B$46/20","v":1811.991},{"$f":"C50-B51","v":31709.842499999999}]
[2022,1811.991,{"$f":"C51-B52","v":29897.851499999997}]
[2023,1811.991,{"$f":"C52-B53","v":28085.860499999995}]
[2024,1811.991,{"$f":"C53-B54","v":26273.869499999993}]
[2025,1811.991,24461.878499999992]
[2026,1811.991,22649.88749999999]
[2027,1811.991,20837.896499999988]
[2028,1811.991,19025.905499999986]
[2029,1811.991,17213.914499999984]
[]
["Base",21400,null,"2021-12-09"]
[null,"AMORT","VNC","durée = 6 ans"]
[2021,400,{"$f":"B61-B63","v":21000}]
[2022,{"$f":"21000/5","v":4200},{"$f":"C63-B64","v":16800}]
[2023,{"$f":"21000/5","v":4200},{"$f":"C64-B65","v":12600}]
[2024,4200,8400]
[2025,4200,4200]
[2026,4200,0]
[]
[]
[null,{"$f":"+B14+B24+B32+B39+B49","v":14205.523499999999},{"$f":"+C14+C24+C32+C39+C49","v":53199.012500000004}]
[]
[null,{"$f":"+B15+B25+B33+B40+B50","v":11111.518999999998},{"$f":"+C15+C25+C33+C40+C50","v":42087.493499999997}]
[]
[null,{"$f":"+B41+B51+B63","v":5191.3509999999997},{"$f":"+C41+C51+C63","v":58296.142500000002}]
[]
[null,{"$f":"+B42+B52+B64","v":8991.3509999999987},{"$f":"+C42+C52+C64","v":49304.791499999999}]

{"sheet":"Stock","index":9,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Stock carburant",null,"EN EURO",null,null,"En LITRE"]
[null,null,null,null,null,null,null,null,null,null,"le 26/12/2018"]
[null,2017,2018,2019,2015,2016,null,2020,2021,2022,7207,"litres",1.599,{"$f":"K4*M4","v":11523.993}]
[null,null,null,null,null,null,null,null,null,null,"le 23/05/2018"]
["SI",10606.57,{"$f":"B7","v":2977.44},{"$f":"C7","v":15380.8212},7563,{"$f":"E7","v":10257},null,{"$f":"D7","v":6393.5221267239658},{"$f":"H7","v":12873.545},{"$f":"I7","v":15768.547500000001},{"$f":"9800-K4","v":2593},"litres",1.4874000000000001,{"$f":"K6*M6","v":3856.8281999999999}]
["SF",{"$f":"2000*1.48872","v":2977.44},{"$f":"+K4*M4+K6*M6","v":15380.8212},{"$f":"K11*M10","v":6393.5221267239658},10257,7426,null,{"$f":"K14*M14","v":12873.545},{"$f":"K17*M17","v":15768.547500000001},{"$f":"K20*M20","v":15050.279999999999}]
["VAR",{"$f":"B7-B6","v":-7629.1299999999992},{"$f":"C7-C6","v":12403.3812},{"$f":"D7-D6","v":-8987.2990732760336},{"$f":"E7-E6","v":2694},{"$f":"F7-F6","v":-2831},null,{"$f":"H7-H6","v":6480.0228732760343},{"$f":"I7-I6","v":2895.0025000000005},{"$f":"J7-J6","v":-718.26750000000175},{"$f":"SUM(K4:K7)","v":9800},null,null,{"$f":"SUM(N4:N7)","v":15380.8212}]
[null,null,null,null,null,null,null,null,null,null,"2019-09-02"]
[null,null,null,null,null,null,null,null,null,null,5003,"litres",{"$f":"N10/K10","v":1.574759144513292},7878.52]
[null,null,null,null,null,null,null,null,null,null,4060,null,{"$f":"M10","v":1.574759144513292}]
[]
[null,null,null,null,null,null,null,null,null,null,"2020-12-31"]
[null,null,null,null,null,null,null,null,null,null,9500,"litres",1.35511]
[]
[null,null,null,null,null,null,null,null,null,null,"2021-12-31"]
[null,null,null,null,null,null,null,null,null,null,8675,"litres",1.8177000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,"2022-12-31"]
[null,null,null,null,null,null,null,null,null,null,5453,"litres",2.76]

{"sheet":"Prêt ULM - OLd","index":10,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["K","INT"]
[206.12,23.33]
[206.54,22.91]
[206.96,22.49]
[207.38,22.07]
[207.8,21.65]
[208.22,21.23]
[208.64,20.81]
[209.06,20.39]
[209.48,19.96]
[209.91,19.54]
[210.33,19.12]
[210.76,18.690000000000001]
[-0.01,0.02]
[{"$f":"SUM(A2:A14)","v":2501.1899999999996},{"$f":"SUM(B2:B14)","v":252.21},null,{"$f":"+A15+B15","v":2753.3999999999996}," = dépenses 2018"]
[]
[]
[11519.92]
[{"$f":"+A18-A15","v":9018.73}]
[6671.97,{"$f":"A19-A20","v":2346.7599999999993}]

{"sheet":"Prêt ULM","index":11,"n_rows":201,"n_cols":14,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
[null,null,"Montant",20000]
[null,null,"Durée",96]
[null,null,"Taux",{"$f":"2.43%/12","v":2.0250000000000003E-3}]
[null,null,"Décalage en mois",0]
[]
["Période","Année","Mois","Capital début Période","Mensualité","Capital Remboursé","Intérêts","Assurance","Capital Fin de Période",null,"Contrôle"]
[1,{"$f":"YEAR(C7)","v":2014},"2014-06-01",{"$f":"D1","v":20000},{"$f":"IF(D1=0,,-PMT(D3,D2,D1)+H7)","v":229.44922468148866},{"$f":"IF(D1=0,,-PPMT($D$3,A7,$D$2,$D$1))","v":188.94922468148863},{"$f":"E7-F7","v":40.500000000000028},0,{"$f":"D7-F7","v":19811.050775318512},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A7,$D$2,$D$1))","v":40.500000000000007},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":275.43776089199469}]
[{"$f":"IF(ROUND(I7,0)=0,0,A7+1)","v":2},2014,{"$f":"EDATE(C7,1)","v":"2014-07-01"},{"$f":"I7","v":19811.050775318512},{"$f":"IF(A8=0,0,E7)","v":229.44922468148866},{"$f":"IF(A8=0,,-PPMT($D$3,A8,$D$2,$D$1))","v":189.33184686146868},40.117377820019982,{"$f":"H7","v":0},19621.718928457045,null,40.117377820019989,275.43776089199469]
[3,2014,"2014-08-01",19621.718928457045,229.44922468148866,189.71524385136311,39.733980830125546,0,19432.003684605683,null,39.73398083012551,275.43776089199469]
[4,2014,"2014-09-01",19432.003684605683,229.44922468148866,190.09941722016214,39.34980746132652,0,19241.904267385522,null,39.349807461326506,275.43776089199469]
[5,2014,"2014-10-01",19241.904267385522,229.44922468148866,190.48436854003299,38.96485614145567,0,19051.419898845488,null,38.96485614145567,275.43776089199469]
[6,2014,"2014-11-01",19051.419898845488,229.44922468148866,190.87009938632656,38.5791252951621,0,18860.549799459161,null,38.579125295162108,275.43776089199469]
[7,2014,"2014-12-01",18860.549799459161,229.44922468148866,191.25661133758385,38.19261334390481,0,18669.293188121577,null,38.192613343904796,275.43776089199469]
[8,2015,"2015-01-01",18669.293188121577,229.44922468148866,191.64390597554248,37.805318705946178,0,18477.649282146034,null,37.805318705946185,427.87693699901411]
[9,2015,"2015-02-01",18477.649282146034,229.44922468148866,192.03198488514295,37.417239796345712,0,18285.617297260891,null,37.417239796345712,427.87693699901411]
[10,2015,"2015-03-01",18285.617297260891,229.44922468148866,192.42084965453535,37.028375026953313,0,18093.196447606355,null,37.028375026953299,427.87693699901411]
[11,2015,"2015-04-01",18093.196447606355,229.44922468148866,192.81050187508578,36.638722806402882,0,17900.385945731268,null,36.63872280640286,427.87693699901411]
[12,2015,"2015-05-01",17900.385945731268,229.44922468148866,193.20094314138282,36.248281540105836,0,17707.185002589886,null,36.248281540105808,427.87693699901411]
[13,2015,"2015-06-01",17707.185002589886,229.44922468148866,193.59217505124414,35.857049630244518,0,17513.592827538643,null,35.857049630244511,427.87693699901411]
[14,2015,"2015-07-01",17513.592827538643,229.44922468148866,193.98419920572289,35.465025475765771,0,17319.60862833292,null,35.465025475765742,427.87693699901411]
[15,2015,"2015-08-01",17319.60862833292,229.44922468148866,194.37701720911451,35.072207472374146,0,17125.231611123807,null,35.072207472374153,427.87693699901411]
[16,2015,"2015-09-01",17125.231611123807,229.44922468148866,194.77063066896295,34.678594012525707,0,16930.460980454845,null,34.6785940125257,427.87693699901411]
[17,2015,"2015-10-01",16930.460980454845,229.44922468148866,195.16504119606759,34.284183485421067,0,16735.295939258776,null,34.284183485421046,427.87693699901411]
[18,2015,"2015-11-01",16735.295939258776,229.44922468148866,195.56025040448961,33.888974276999051,0,16539.735688854285,null,33.888974276999008,427.87693699901411]
[19,2015,"2015-12-01",16539.735688854285,229.44922468148866,195.9562599115587,33.492964769929955,0,16343.779428942727,null,33.49296476992992,427.87693699901411]
[20,2016,"2016-01-01",16343.779428942727,229.44922468148866,196.35307133787961,33.096153343609046,0,16147.426357604847,null,33.096153343609011,370.73330496637789]
[21,2016,"2016-02-01",16147.426357604847,229.44922468148866,196.75068630733884,32.69853837414982,0,15950.675671297508,null,32.698538374149805,370.73330496637789]
[22,2016,"2016-03-01",15950.675671297508,229.44922468148866,197.14910644711119,32.300118234377464,0,15753.526564850396,null,32.300118234377443,370.73330496637789]
[23,2016,"2016-04-01",15753.526564850396,229.44922468148866,197.54833338766662,31.900891293822042,0,15555.978231462728,null,31.900891293822049,370.73330496637789]
[24,2016,"2016-05-01",15555.978231462728,229.44922468148866,197.94836876277662,31.500855918712034,0,15358.029862699952,null,31.50085591871202,370.73330496637789]
[25,2016,"2016-06-01",15358.029862699952,229.44922468148866,198.34921420952125,31.100010471967408,0,15159.68064849043,null,31.100010471967401,370.73330496637789]
[26,2016,"2016-07-01",15159.68064849043,229.44922468148866,198.75087136829555,30.69835331319311,0,14960.929777122134,null,30.698353313193117,370.73330496637789]
[27,2016,"2016-08-01",14960.929777122134,229.44922468148866,199.15334188281633,30.295882798672324,0,14761.776435239317,null,30.295882798672327,370.73330496637789]
[28,2016,"2016-09-01",14761.776435239317,229.44922468148866,199.55662740012903,29.892597281359627,0,14562.219807839188,null,29.892597281359613,370.73330496637789]
[29,2016,"2016-10-01",14562.219807839188,229.44922468148866,199.96072957061429,29.488495110874368,0,14362.259078268575,null,29.488495110874354,370.73330496637789]
[30,2016,"2016-11-01",14362.259078268575,229.44922468148866,200.36565004799479,29.083574633493868,0,14161.893428220579,null,29.083574633493864,370.73330496637789]
[31,2016,"2016-12-01",14161.893428220579,229.44922468148866,200.77139048934194,28.677834192146719,0,13961.122037731237,null,28.677834192146676,370.73330496637789]
[32,2017,"2017-01-01",13961.122037731237,229.44922468148866,201.1779525550829,28.271272126405762,0,13759.944085176154,null,28.271272126405748,312.18551238255452]
[33,{"$f":"YEAR(C39)","v":2017},"2017-02-01",13759.944085176154,229.44922468148866,201.58533790900694,{"$f":"E39-F39","v":27.86388677248172},0,{"$f":"D39-F39","v":13558.358747267146},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A39,$D$2,$D$1))","v":27.863886772481713},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":312.18551238255452}]
[{"$f":"IF(ROUND(I39,0)=0,0,A39+1)","v":34},2017,{"$f":"EDATE(C39,1)","v":"2017-03-01"},{"$f":"I39","v":13558.358747267146},{"$f":"IF(A40=0,0,E39)","v":229.44922468148866},{"$f":"IF(A40=0,,-PPMT($D$3,A40,$D$2,$D$1))","v":201.99354821827268},27.45567646321598,{"$f":"H39","v":0},13356.365199048874,null,27.455676463215976,312.18551238255452]
[35,2017,"2017-04-01",13356.365199048874,229.44922468148866,202.40258515341469,27.046639528073968,0,13153.962613895459,null,27.046639528073968,312.18551238255452]
[36,2017,"2017-05-01",13153.962613895459,229.44922468148866,202.81245038835036,26.636774293138302,0,12951.150163507109,null,26.636774293138306,312.18551238255452]
[37,2017,"2017-06-01",12951.150163507109,229.44922468148866,203.22314560038677,26.226079081101886,0,12747.927017906723,null,26.226079081101897,312.18551238255452]
[38,2017,"2017-07-01",12747.927017906723,229.44922468148866,203.63467247022751,25.814552211261145,0,12544.292345436495,null,25.814552211261109,312.18551238255452]
[39,2017,"2017-08-01",12544.292345436495,229.44922468148866,204.04703268197974,25.402191999508915,0,12340.245312754516,null,25.402191999508904,312.18551238255452]
[40,2017,"2017-09-01",12340.245312754516,229.44922468148866,204.46022792316074,24.988996758327914,0,12135.785084831356,null,24.98899675832789,312.18551238255452]
[41,2017,"2017-10-01",12135.785084831356,229.44922468148866,204.8742598847052,24.574964796783462,0,11930.91082494665,null,24.57496479678349,312.18551238255452]
[42,2017,"2017-11-01",11930.91082494665,229.44922468148866,205.28913026097169,24.16009442051697,0,11725.621694685678,null,24.160094420516963,312.18551238255452]
[43,2017,"2017-12-01",11725.621694685678,229.44922468148866,205.70484074975016,23.744383931738497,0,11519.916853935929,null,23.744383931738501,312.18551238255452]
[44,2018,"2018-01-01",11519.916853935929,229.44922468148866,206.12139305226839,23.32783162922027,0,11313.795460883661,null,23.327831629220253,252.19905554549806]
[45,2018,"2018-02-01",11313.795460883661,229.44922468148866,206.53878887319922,22.910435808289435,0,11107.256672010462,null,22.910435808289407,252.19905554549806]
[46,2018,"2018-03-01",11107.256672010462,229.44922468148866,206.95702992066748,22.492194760821178,0,10900.299642089794,null,22.492194760821178,252.19905554549806]
[47,2018,"2018-04-01",10900.299642089794,229.44922468148866,207.37611790625681,22.073106775231849,0,10692.923524183538,null,22.073106775231825,252.19905554549806]
[48,2018,"2018-05-01",10692.923524183538,229.44922468148866,207.79605454501697,21.653170136471687,0,10485.127469638521,null,21.653170136471655,252.19905554549806]
[49,2018,"2018-06-01",10485.127469638521,229.44922468148866,208.21684155547064,21.232383126018021,0,10276.910628083049,null,21.232383126017996,252.19905554549806]
[50,2018,"2018-07-01",10276.910628083049,229.44922468148866,208.63848065962048,20.810744021868175,0,10068.272147423429,null,20.810744021868171,252.19905554549806]
[51,2018,"2018-08-01",10068.272147423429,229.44922468148866,209.06097358295619,20.388251098532464,0,9859.2111738404728,null,20.388251098532436,252.19905554549806]
[52,2018,"2018-09-01",9859.2111738404728,229.44922468148866,209.48432205446167,19.964902627026987,0,9649.726851786012,null,19.964902627026952,252.19905554549806]
[53,2018,"2018-10-01",9649.726851786012,229.44922468148866,209.90852780662198,19.540696874866683,0,9439.8183239793907,null,19.540696874866661,252.19905554549806]
[54,2018,"2018-11-01",9439.8183239793907,229.44922468148866,210.33359257543037,19.115632106058285,0,9229.4847314039598,null,19.115632106058257,252.19905554549806]
[55,2018,"2018-12-01",9229.4847314039598,229.44922468148866,210.75951810039564,18.68970658109302,0,9018.7252133035636,null,18.689706581093009,252.19905554549806]
[56,2019,"2019-01-01",9018.7252133035636,229.44922468148866,211.18630612454893,18.262918556939724,0,8807.5389071790141,null,18.262918556939709,190.73858291175611]
[57,2019,"2019-02-01",8807.5389071790141,229.44922468148866,211.61395839445115,17.835266287037513,0,8595.9249487845627,null,17.835266287037495,190.73858291175611]
[58,2019,"2019-03-01",8595.9249487845627,229.44922468148866,212.0424766601999,17.406748021288763,0,8383.8824721243636,null,17.406748021288735,190.73858291175611]
[59,2019,"2019-04-01",8383.8824721243636,229.44922468148866,212.47186267543682,16.977362006051834,0,8171.4106094489271,null,16.977362006051827,190.73858291175611]
[60,2019,"2019-05-01",8171.4106094489271,229.44922468148866,212.90211819735458,16.547106484134076,0,7958.5084912515722,null,16.547106484134069,190.73858291175611]
[61,2019,"2019-06-01",7958.5084912515722,229.44922468148866,213.33324498670424,16.115979694784414,0,7745.1752462648683,null,16.115979694784425,190.73858291175611]
[62,2019,"2019-07-01",7745.1752462648683,229.44922468148866,213.7652448078023,15.683979873686354,0,7531.4100014570658,null,15.683979873686351,190.73858291175611]
[63,2019,"2019-08-01",7531.4100014570658,229.44922468148866,214.19811942853809,15.251105252950566,0,7317.2118820285277,null,15.25110525295055,190.73858291175611]
[64,2019,"2019-09-01",7317.2118820285277,229.44922468148866,214.63187062038088,14.817354061107778,0,7102.5800114081467,null,14.817354061107762,190.73858291175611]
[65,{"$f":"YEAR(C71)","v":2019},"2019-10-01",7102.5800114081467,229.44922468148866,215.06650015838713,{"$f":"E71-F71","v":14.38272452310153},0,{"$f":"D71-F71","v":6887.5135112497592},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A71,$D$2,$D$1))","v":14.382724523101489},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":190.73858291175611}]
[{"$f":"IF(ROUND(I71,0)=0,0,A71+1)","v":66},2019,{"$f":"EDATE(C71,1)","v":"2019-11-01"},{"$f":"I71","v":6887.5135112497592},{"$f":"IF(A72=0,0,E71)","v":229.44922468148866},{"$f":"IF(A72=0,,-PPMT($D$3,A72,$D$2,$D$1))","v":215.50200982120791},13.947214860280752,{"$f":"H71","v":0},6672.0115014285511,null,13.947214860280756,190.73858291175611]
[67,2019,"2019-12-01",6672.0115014285511,229.44922468148866,215.93840139109585,13.510823290392807,0,6456.0731000374553,null,13.510823290392809,190.73858291175611,{"$f":"SUM(F62:F73)","v":2562.6521132661078},{"$f":"SUM(G62:G73)","v":190.73858291175611}]
[68,2020,"2020-01-01",6456.0731000374553,229.44922468148866,216.37567665391282,13.073548027575839,0,6239.6974233835426,null,13.073548027575839,127.76787426290915]
[69,2020,"2020-02-01",6239.6974233835426,229.44922468148866,216.81383739913699,12.635387282351672,0,6022.8835859844057,null,12.635387282351669,127.76787426290915]
[70,2020,"2020-03-01",6022.8835859844057,229.44922468148866,217.25288541987024,12.196339261618419,0,5805.6307005645358,null,12.196339261618414,127.76787426290915]
[71,2020,"2020-04-01",5805.6307005645358,229.44922468148866,217.69282251284548,11.756402168643177,0,5587.9378780516899,null,11.756402168643177,127.76787426290915]
[72,2020,"2020-05-01",5587.9378780516899,229.44922468148866,218.13365047843399,11.315574203054666,0,5369.804227573256,null,11.315574203054664,127.76787426290915]
[73,2020,"2020-06-01",5369.804227573256,229.44922468148866,218.57537112065282,10.87385356083584,0,5151.2288564526034,null,10.873853560835837,127.76787426290915]
[74,2020,"2020-07-01",5151.2288564526034,229.44922468148866,219.01798624717213,10.431238434316526,0,4932.2108702054311,null,10.431238434316512,127.76787426290915]
[75,2020,"2020-08-01",4932.2108702054311,229.44922468148866,219.46149766932265,9.9877270121660047,0,4712.7493725361082,null,9.9877270121659887,127.76787426290915]
[76,2020,"2020-09-01",4712.7493725361082,229.44922468148866,219.90590720210301,9.5433174793856494,0,4492.8434653340055,null,9.5433174793856104,127.76787426290915]
[77,2020,"2020-10-01",4492.8434653340055,229.44922468148866,220.35121666418729,9.0980080173013675,0,4272.4922486698179,null,9.0980080173013516,127.76787426290915]
[78,2020,"2020-11-01",4272.4922486698179,229.44922468148866,220.79742787793228,8.6517968035563797,0,4051.6948207918854,null,8.6517968035563726,127.76787426290915]
[79,2020,"2020-12-01",4051.6948207918854,229.44922468148866,221.24454266938505,8.2046820121036035,0,3830.4502781225001,null,8.2046820121035609,127.76787426290915,{"$f":"SUM(F74:F85)","v":2625.6228219149552},{"$f":"SUM(G74:G85)","v":127.76787426290915}]
[80,2021,"2021-01-01",3830.4502781225001,229.44922468148866,221.69256286829062,7.7566618131980363,0,3608.7577152542094,null,7.7566618131980549,63.249819360073644]
[81,2021,"2021-02-01",3608.7577152542094,229.44922468148866,222.14149030809887,7.3077343733897919,0,3386.6162249461104,null,7.3077343733897679,63.249819360073644]
[82,2021,"2021-03-01",3386.6162249461104,229.44922468148866,222.59132682597277,6.8578978555158869,0,3164.0248981201375,null,6.8578978555158665,63.249819360073644]
[83,2021,"2021-04-01",3164.0248981201375,229.44922468148866,223.04207426279538,6.4071504186932771,0,2940.9828238573423,null,6.4071504186932708,63.249819360073644]
[84,2021,"2021-05-01",2940.9828238573423,229.44922468148866,223.49373446317753,5.9554902183111267,0,2717.4890893941647,null,5.9554902183111116,63.249819360073644]
[85,2021,"2021-06-01",2717.4890893941647,229.44922468148866,223.94630927546547,5.5029154060231917,0,2493.5427801186993,null,5.5029154060231766,63.249819360073644]
[86,2021,"2021-07-01",2493.5427801186993,229.44922468148866,224.39980055174829,5.0494241297403732,0,2269.142979566951,null,5.0494241297403573,63.249819360073644]
[87,2021,"2021-08-01",2269.142979566951,229.44922468148866,224.85421014786559,4.5950145336230719,0,2044.2887694190854,null,4.5950145336230683,63.249819360073644]
[88,2021,"2021-09-01",2044.2887694190854,229.44922468148866,225.309539923415,4.1396847580736562,0,1818.9792294956703,null,4.1396847580736402,63.249819360073644]
[89,2021,"2021-10-01",1818.9792294956703,229.44922468148866,225.76579174175993,3.683432939728732,0,1593.2134377539105,null,3.6834329397287249,63.249819360073644]
[90,2021,"2021-11-01",1593.2134377539105,229.44922468148866,226.22296747003699,3.2262572114516672,0,1366.9904702838735,null,3.226257211451661,63.249819360073644]
[91,2021,"2021-12-01",1366.9904702838735,229.44922468148866,226.68106897916383,2.7681557023248331,0,1140.3094013047096,null,2.7681557023248358,63.249819360073644,{"$f":"SUM(F86:F97)","v":2690.1408768177903},{"$f":"SUM(G86:G97)","v":63.249819360073644}]
[92,2022,"2022-01-01",1140.3094013047096,229.44922468148866,227.14009814384661,2.3091265376420438,0,913.16930316086291,null,2.3091265376420291,6.9367221027377184]
[93,2022,"2022-02-01",913.16930316086291,229.44922468148866,227.60005684258792,1.8491678389007404,0,685.56924631827496,null,1.8491678389007398,6.9367221027377184]
[94,2022,"2022-03-01",685.56924631827496,229.44922468148866,228.06094695769414,1.3882777237945163,0,457.50829936058085,null,1.3882777237944994,6.9367221027377184]
[95,2022,"2022-04-01",457.50829936058085,229.44922468148866,228.52277037528347,0.92645430620518709,0,228.98552898529738,null,0.92645430620516855,6.9367221027377184]
[96,2022,"2022-05-01",228.98552898529738,229.44922468148866,228.98552898529343,0.46369569619523077,0,3.950617610826157E-12,null,0.46369569619521928,6.9367221027377184]
[0,{"$f":"YEAR(C103)","v":2022},"2022-06-01",3.950617610826157E-12,0,0,{"$f":"E103-F103","v":0},0,{"$f":"D103-F103","v":3.950617610826157E-12},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A103,$D$2,$D$1))","v":{"$error":"#NUM!"}},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":6.9367221027377184}]
[{"$f":"IF(ROUND(I103,0)=0,0,A103+1)","v":0},2022,{"$f":"EDATE(C103,1)","v":"2022-07-01"},{"$f":"I103","v":3.950617610826157E-12},{"$f":"IF(A104=0,0,E103)","v":0},{"$f":"IF(A104=0,,-PPMT($D$3,A104,$D$2,$D$1))","v":0},0,{"$f":"H103","v":0},3.950617610826157E-12,null,{"$error":"#NUM!"},6.9367221027377184]
[0,2022,"2022-08-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},6.9367221027377184]
[0,2022,"2022-09-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},6.9367221027377184]
[0,2022,"2022-10-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},6.9367221027377184]
[0,2022,"2022-11-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},6.9367221027377184]
[0,2022,"2022-12-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},6.9367221027377184,{"$f":"SUM(F98:F109)","v":1140.3094013047055},{"$f":"SUM(G98:G109)","v":6.9367221027377184}]
[0,2023,"2023-01-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-02-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-03-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-04-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-05-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-06-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-07-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-08-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-09-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-10-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-11-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2023,"2023-12-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-01-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-02-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-03-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-04-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-05-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-06-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-07-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-08-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-09-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-10-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-11-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2024,"2024-12-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-01-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,{"$f":"YEAR(C135)","v":2025},"2025-02-01",3.950617610826157E-12,0,0,{"$f":"E135-F135","v":0},0,{"$f":"D135-F135","v":3.950617610826157E-12},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A135,$D$2,$D$1))","v":{"$error":"#NUM!"}},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":0}]
[{"$f":"IF(ROUND(I135,0)=0,0,A135+1)","v":0},2025,{"$f":"EDATE(C135,1)","v":"2025-03-01"},{"$f":"I135","v":3.950617610826157E-12},{"$f":"IF(A136=0,0,E135)","v":0},{"$f":"IF(A136=0,,-PPMT($D$3,A136,$D$2,$D$1))","v":0},0,{"$f":"H135","v":0},3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-04-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-05-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-06-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-07-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-08-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-09-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-10-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-11-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-12-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-01-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-02-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-03-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-04-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-05-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-06-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-07-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-08-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-09-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-10-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-11-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-12-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-01-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-02-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-03-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-04-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-05-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-06-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-07-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-08-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-09-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,{"$f":"YEAR(C167)","v":2027},"2027-10-01",3.950617610826157E-12,0,0,{"$f":"E167-F167","v":0},0,{"$f":"D167-F167","v":3.950617610826157E-12},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A167,$D$2,$D$1))","v":{"$error":"#NUM!"}},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":0}]
[{"$f":"IF(ROUND(I167,0)=0,0,A167+1)","v":0},2027,{"$f":"EDATE(C167,1)","v":"2027-11-01"},{"$f":"I167","v":3.950617610826157E-12},{"$f":"IF(A168=0,0,E167)","v":0},{"$f":"IF(A168=0,,-PPMT($D$3,A168,$D$2,$D$1))","v":0},0,{"$f":"H167","v":0},3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-12-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-01-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-02-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-03-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-04-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-05-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-06-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-07-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-08-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-09-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-10-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-11-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-12-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-01-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-02-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-03-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-04-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-05-01",3.950617610826157E-12,0,0,0,0,3.950617610826157E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-06-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2029,"2029-07-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2029,"2029-08-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2029,"2029-09-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2029,"2029-10-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2029,"2029-11-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2029,"2029-12-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2030,"2030-01-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2030,"2030-02-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2030,"2030-03-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2030,"2030-04-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2030,"2030-05-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,{"$f":"YEAR(C199)","v":2030},"2030-06-01",3.950617610826157E-12,0,0,{"$f":"E199-F199","v":0},null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2030,"2030-07-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]
[0,2030,"2030-08-01",3.950617610826157E-12,0,0,0,null,3.950617610826157E-12,null,{"$error":"#NUM!"}]

{"sheet":"Prêt 4204","index":12,"n_rows":201,"n_cols":14,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
[null,null,"Montant",15000]
[null,null,"Durée",60]
[null,null,"Taux",{"$f":"0.91%/12","v":7.5833333333333341E-4}]
[null,null,"Décalage en mois"]
[]
["Période","Année","Mois","Capital début Période","Mensualité","Capital Remboursé","Intérêts","Assurance","Capital Fin de Période",null,"Contrôle"]
[1,{"$f":"YEAR(C7)","v":2019},"2019-10-01",{"$f":"D1","v":15000},{"$f":"IF(D1=0,,-PMT(D3,D2,D1)+H7)","v":255.82539206724525},{"$f":"IF(D1=0,,-PPMT($D$3,A7,$D$2,$D$1))","v":244.45039206724525},{"$f":"E7-F7","v":11.375},0,{"$f":"D7-F7","v":14755.549607932755},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A7,$D$2,$D$1))","v":11.375},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":33.568734782095845}]
[{"$f":"IF(ROUND(I7,0)=0,0,A7+1)","v":2},2019,{"$f":"EDATE(C7,1)","v":"2019-11-01"},{"$f":"I7","v":14755.549607932755},{"$f":"IF(A8=0,0,E7)","v":255.82539206724525},{"$f":"IF(A8=0,,-PPMT($D$3,A8,$D$2,$D$1))","v":244.63576694789626},11.189625119348989,{"$f":"H7","v":0},14510.913840984858,null,11.189625119349007,33.568734782095845]
[3,2019,"2019-12-01",14510.913840984858,255.82539206724525,244.82128240449839,11.004109662746856,0,14266.09255858036,null,11.004109662746853,33.568734782095845,{"$f":"SUM(F7:F9)","v":733.90744141963989},{"$f":"SUM(G7:G9)","v":33.568734782095845}]
[4,2020,"2020-01-01",14266.09255858036,255.82539206724525,245.00693854365511,10.818453523590136,0,14021.085620036705,null,10.818453523590108,117.52779493501777]
[5,2020,"2020-02-01",14021.085620036705,255.82539206724525,245.19273547205074,10.632656595194504,0,13775.892884564655,null,10.632656595194504,117.52779493501777]
[6,2020,"2020-03-01",13775.892884564655,255.82539206724525,245.37867329645039,10.44671877079486,0,13530.514211268204,null,10.446718770794865,117.52779493501777]
[7,2020,"2020-04-01",13530.514211268204,255.82539206724525,245.56475212370023,10.260639943545016,0,13284.949459144504,null,10.260639943545057,117.52779493501777]
[8,2020,"2020-05-01",13284.949459144504,255.82539206724525,245.75097206072735,10.074420006517897,0,13039.198487083777,null,10.074420006517915,117.52779493501777]
[9,2020,"2020-06-01",13039.198487083777,255.82539206724525,245.93733321454005,9.8880588527051998,0,12793.261153869236,null,9.8880588527051962,117.52779493501777]
[10,2020,"2020-07-01",12793.261153869236,255.82539206724525,246.12383569222777,9.7015563750174749,0,12547.137318177009,null,9.7015563750175051,117.52779493501777]
[11,2020,"2020-08-01",12547.137318177009,255.82539206724525,246.31047960096106,9.5149124662841871,0,12300.826838576048,null,9.5149124662842315,117.52779493501777]
[12,2020,"2020-09-01",12300.826838576048,255.82539206724525,246.49726504799173,9.3281270192535146,0,12054.329573528055,null,9.328127019253504,117.52779493501777]
[13,2020,"2020-10-01",12054.329573528055,255.82539206724525,246.68419214065315,9.141199926592094,0,11807.645381387401,null,9.14119992659211,117.52779493501777]
[14,2020,"2020-11-01",11807.645381387401,255.82539206724525,246.87126098635983,8.9541310808854178,0,11560.774120401042,null,8.9541310808854462,117.52779493501777]
[15,2020,"2020-12-01",11560.774120401042,255.82539206724525,247.05847169260778,8.7669203746374649,0,11313.715648708434,null,8.7669203746374578,117.52779493501777,{"$f":"SUM(F10:F21)","v":2952.3769098719249},{"$f":"SUM(G19:G21)","v":26.862251382114977}]
[16,2021,"2021-01-01",11313.715648708434,255.82539206724525,247.24582436697472,8.5795677002705304,0,11066.469824341459,null,8.5795677002705641,90.548825082576542]
[17,2021,"2021-02-01",11066.469824341459,255.82539206724525,247.43331911711962,8.3920729501256233,0,10819.03650522434,null,8.3920729501256091,90.548825082576542]
[18,2021,"2021-03-01",10819.03650522434,255.82539206724525,247.62095605078343,8.2044360164618126,0,10571.415549173556,null,8.2044360164617931,90.548825082576542]
[19,2021,"2021-04-01",10571.415549173556,255.82539206724525,247.80873527578865,8.0166567914565974,0,10323.606813897768,null,8.0166567914566151,90.548825082576542]
[20,2021,"2021-05-01",10323.606813897768,255.82539206724525,247.99665690003943,7.8287351672058207,0,10075.610156997729,null,7.8287351672058092,90.548825082576542]
[21,2021,"2021-06-01",10075.610156997729,255.82539206724525,248.18472103152197,7.6406710357232726,0,9827.4254359662064,null,7.6406710357232788,90.548825082576542]
[22,2021,"2021-07-01",9827.4254359662064,255.82539206724525,248.37292777830419,7.4524642889410586,0,9579.0525081879023,null,7.4524642889410417,90.548825082576542]
[23,2021,"2021-08-01",9579.0525081879023,255.82539206724525,248.5612772485361,7.264114818709146,0,9330.4912309393658,null,7.2641148187091611,90.548825082576542]
[24,2021,"2021-09-01",9330.4912309393658,255.82539206724525,248.7497695504496,7.0756225167956472,0,9081.7414613889159,null,7.0756225167956881,90.548825082576542]
[25,2021,"2021-10-01",9081.7414613889159,255.82539206724525,248.93840479235863,6.8869872748866214,0,8832.8030565965564,null,6.8869872748865966,90.548825082576542]
[26,2021,"2021-11-01",8832.8030565965564,255.82539206724525,249.12718308265954,6.6982089845857047,0,8583.6758735138974,null,6.6982089845857251,90.548825082576542]
[27,2021,"2021-12-01",8583.6758735138974,255.82539206724525,249.31610452983054,6.509287537414707,0,8334.3597689840662,null,6.5092875374147079,90.548825082576542,{"$f":"SUM(F22:F33)","v":2979.3558797243663},{"$f":"SUM(G31:G33)","v":20.094483796887033}]
[28,2022,"2022-01-01",8334.3597689840662,255.82539206724525,249.50516924243232,6.3202228248129302,0,8084.854599741634,null,6.3202228248129186,63.323320036114012]
[29,2022,"2022-02-01",8084.854599741634,255.82539206724525,249.69437732910785,6.1310147381373952,0,7835.1602224125263,null,6.1310147381374085,63.323320036114012]
[30,2022,"2022-03-01",7835.1602224125263,255.82539206724525,249.8837288985824,5.9416631686628421,0,7585.2764935139439,null,5.9416631686628341,63.323320036114012]
[31,2022,"2022-04-01",7585.2764935139439,255.82539206724525,250.07322405966383,5.7521680075814174,0,7335.2032694542804,null,5.7521680075814103,63.323320036114012]
[32,2022,"2022-05-01",7335.2032694542804,255.82539206724525,250.2628629212424,5.562529146002845,0,7084.9404065330382,null,5.5625291460028317,63.323320036114012]
[33,{"$f":"YEAR(C39)","v":2022},"2022-06-01",7084.9404065330382,255.82539206724525,250.45264559229105,{"$f":"E39-F39","v":5.372746474954198},0,{"$f":"D39-F39","v":6834.4877609407467},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A39,$D$2,$D$1))","v":5.3727464749542229},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":63.323320036114012}]
[{"$f":"IF(ROUND(I39,0)=0,0,A39+1)","v":34},2022,{"$f":"EDATE(C39,1)","v":"2022-07-01"},{"$f":"I39","v":6834.4877609407467},{"$f":"IF(A40=0,0,E39)","v":255.82539206724525},{"$f":"IF(A40=0,,-PPMT($D$3,A40,$D$2,$D$1))","v":250.64257218186518},5.18281988538007,{"$f":"H39","v":0},6583.8451887588817,null,5.1828198853800691,63.323320036114012]
[35,2022,"2022-08-01",6583.8451887588817,255.82539206724525,250.83264279910313,4.9927492681421199,0,6333.0125459597784,null,4.9927492681421537,63.323320036114012]
[36,2022,"2022-09-01",6333.0125459597784,255.82539206724525,251.02285755322575,4.8025345140194986,0,6081.9896884065529,null,4.8025345140194995,63.323320036114012]
[37,2022,"2022-10-01",6081.9896884065529,255.82539206724525,251.21321655353697,4.6121755137082801,0,5830.7764718530161,null,4.612175513708304,63.323320036114012]
[38,2022,"2022-11-01",5830.7764718530161,255.82539206724525,251.40371990942339,4.4216721578218596,0,5579.3727519435924,null,4.4216721578218721,63.323320036114012]
[39,2022,"2022-12-01",5579.3727519435924,255.82539206724525,251.59436773035469,4.231024336890556,0,5327.7783842132376,null,4.2310243368905587,63.323320036114012,{"$f":"SUM(F34:F45)","v":3006.5813847708287},{"$f":"SUM(G43:G45)","v":13.264872008420696}]
[40,2023,"2023-01-01",5327.7783842132376,255.82539206724525,251.78516012588355,4.0402319413616965,0,5075.9932240873541,null,4.040231941361708,35.849026944530976]
[41,2023,"2023-02-01",5075.9932240873541,255.82539206724525,251.97609720564569,3.8492948615995601,0,4824.0171268817085,null,3.8492948615995792,35.849026944530976]
[42,2023,"2023-03-01",4824.0171268817085,255.82539206724525,252.16717907935998,3.6582129878852641,0,4571.8499478023487,null,3.6582129878852978,35.849026944530976]
[43,2023,"2023-04-01",4571.8499478023487,255.82539206724525,252.35840585682845,3.4669862104167919,0,4319.4915419455201,null,3.4669862104167826,35.849026944530976]
[44,2023,"2023-05-01",4319.4915419455201,255.82539206724525,252.54977764793659,3.2756144193086527,0,4066.9417642975836,null,3.2756144193086878,35.849026944530976]
[45,2023,"2023-06-01",4066.9417642975836,255.82539206724525,252.74129456265291,3.0840975045923358,0,3814.2004697349307,null,3.0840975045923358,35.849026944530976]
[46,2023,"2023-07-01",3814.2004697349307,255.82539206724525,252.93295671102956,2.8924353562156853,0,3561.2675130239013,null,2.8924353562156573,35.849026944530976]
[47,2023,"2023-08-01",3561.2675130239013,255.82539206724525,253.12476420320212,2.7006278640431276,0,3308.1427488206991,null,2.7006278640431267,35.849026944530976]
[48,2023,"2023-09-01",3308.1427488206991,255.82539206724525,253.31671714938955,2.5086749178557,0,3054.8260316713095,null,2.5086749178556982,35.849026944530976]
[49,2023,"2023-10-01",3054.8260316713095,255.82539206724525,253.50881565989451,2.3165764073507376,0,2801.317216011415,null,2.3165764073507442,35.849026944530976]
[50,2023,"2023-11-01",2801.317216011415,255.82539206724525,253.70105984510326,2.1243322221419874,0,2547.6161561663116,null,2.1243322221419914,35.849026944530976]
[51,2023,"2023-12-01",2547.6161561663116,255.82539206724525,253.89344981548581,1.9319422517594376,0,2293.7227063508258,null,1.9319422517594544,35.849026944530976]
[52,2024,"2024-01-01",2293.7227063508258,255.82539206724525,254.08598568159587,1.7394063856493744,0,2039.6367206692298,null,1.7394063856493778,8.7058222543796262]
[53,2024,"2024-02-01",2039.6367206692298,255.82539206724525,254.27866755407109,1.5467245131741549,0,1785.3580531151588,null,1.5467245131741674,8.7058222543796262]
[54,2024,"2024-03-01",1785.3580531151588,255.82539206724525,254.4714955436329,1.3538965236123488,0,1530.8865575715258,null,1.3538965236123304,8.7058222543796262]
[55,2024,"2024-04-01",1530.8865575715258,255.82539206724525,254.66446976108685,1.1609223061583975,0,1276.222087810439,null,1.1609223061584086,8.7058222543796262]
[56,2024,"2024-05-01",1276.222087810439,255.82539206724525,254.85759031732238,0.96780174992287016,0,1021.3644974931167,null,0.9678017499229179,8.7058222543796262]
[57,2024,"2024-06-01",1021.3644974931167,255.82539206724525,255.05085732331295,0.77453474393229271,0,766.31364016980376,null,0.77453474393228172,8.7058222543796262]
[58,2024,"2024-07-01",766.31364016980376,255.82539206724525,255.2442708901165,0.58112117712875033,0,511.06936927968729,null,0.58112117712876921,8.7058222543796262]
[59,2024,"2024-08-01",511.06936927968729,255.82539206724525,255.43783112887485,0.38756093837039884,0,255.63153815081245,null,0.38756093837043087,8.7058222543796262]
[60,2024,"2024-09-01",255.63153815081245,255.82539206724525,255.63153815081421,0.19385391643103844,0,-1.7621459846850485E-12,null,0.19385391643103417,8.7058222543796262]
[0,2024,"2024-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},8.7058222543796262]
[0,2024,"2024-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},8.7058222543796262]
[0,2024,"2024-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},8.7058222543796262]
[0,2025,"2025-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,{"$f":"YEAR(C71)","v":2025},"2025-02-01",-1.7621459846850485E-12,0,0,{"$f":"E71-F71","v":0},0,{"$f":"D71-F71","v":-1.7621459846850485E-12},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A71,$D$2,$D$1))","v":{"$error":"#NUM!"}},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":0}]
[{"$f":"IF(ROUND(I71,0)=0,0,A71+1)","v":0},2025,{"$f":"EDATE(C71,1)","v":"2025-03-01"},{"$f":"I71","v":-1.7621459846850485E-12},{"$f":"IF(A72=0,0,E71)","v":0},{"$f":"IF(A72=0,,-PPMT($D$3,A72,$D$2,$D$1))","v":0},0,{"$f":"H71","v":0},-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0,{"$f":"SUM(F62:F73)","v":1276.2220878104408},{"$f":"SUM(G62:G73)","v":2.9048725257853505}]
[0,2025,"2025-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2025,"2025-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2026,"2026-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,{"$f":"YEAR(C103)","v":2027},"2027-10-01",-1.7621459846850485E-12,0,0,{"$f":"E103-F103","v":0},0,{"$f":"D103-F103","v":-1.7621459846850485E-12},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A103,$D$2,$D$1))","v":{"$error":"#NUM!"}},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":0}]
[{"$f":"IF(ROUND(I103,0)=0,0,A103+1)","v":0},2027,{"$f":"EDATE(C103,1)","v":"2027-11-01"},{"$f":"I103","v":-1.7621459846850485E-12},{"$f":"IF(A104=0,0,E103)","v":0},{"$f":"IF(A104=0,,-PPMT($D$3,A104,$D$2,$D$1))","v":0},0,{"$f":"H103","v":0},-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2027,"2027-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2028,"2028-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2029,"2029-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,{"$f":"YEAR(C135)","v":2030},"2030-06-01",-1.7621459846850485E-12,0,0,{"$f":"E135-F135","v":0},0,{"$f":"D135-F135","v":-1.7621459846850485E-12},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A135,$D$2,$D$1))","v":{"$error":"#NUM!"}},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":0}]
[{"$f":"IF(ROUND(I135,0)=0,0,A135+1)","v":0},2030,{"$f":"EDATE(C135,1)","v":"2030-07-01"},{"$f":"I135","v":-1.7621459846850485E-12},{"$f":"IF(A136=0,0,E135)","v":0},{"$f":"IF(A136=0,,-PPMT($D$3,A136,$D$2,$D$1))","v":0},0,{"$f":"H135","v":0},-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2030,"2030-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2031,"2031-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2032,"2032-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,{"$f":"YEAR(C167)","v":2033},"2033-02-01",-1.7621459846850485E-12,0,0,{"$f":"E167-F167","v":0},0,{"$f":"D167-F167","v":-1.7621459846850485E-12},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A167,$D$2,$D$1))","v":{"$error":"#NUM!"}},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":0}]
[{"$f":"IF(ROUND(I167,0)=0,0,A167+1)","v":0},2033,{"$f":"EDATE(C167,1)","v":"2033-03-01"},{"$f":"I167","v":-1.7621459846850485E-12},{"$f":"IF(A168=0,0,E167)","v":0},{"$f":"IF(A168=0,,-PPMT($D$3,A168,$D$2,$D$1))","v":0},0,{"$f":"H167","v":0},-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-10-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-11-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2033,"2033-12-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-01-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-02-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-03-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-04-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-05-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-06-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-07-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-08-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-09-01",-1.7621459846850485E-12,0,0,0,0,-1.7621459846850485E-12,null,{"$error":"#NUM!"},0]
[0,2034,"2034-10-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2034,"2034-11-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2034,"2034-12-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-01-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-02-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-03-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-04-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-05-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-06-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-07-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-08-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-09-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,{"$f":"YEAR(C199)","v":2035},"2035-10-01",-1.7621459846850485E-12,0,0,{"$f":"E199-F199","v":0},null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-11-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]
[0,2035,"2035-12-01",-1.7621459846850485E-12,0,0,0,null,-1.7621459846850485E-12,null,{"$error":"#NUM!"}]

{"sheet":"Prêt Kit ULM","index":13,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,null,"Montant",21400]
[null,null,"Durée",72]
[null,null,"Taux",{"$f":"0.9%/12","v":7.5000000000000012E-4}]
[null,null,"Décalage en mois",1]
[]
["Période","Année","Mois","Capital début Période","Mensualité","Capital Remboursé","Intérêts","Assurance","Capital Fin de Période",null,"Contrôle"]
[1,{"$f":"YEAR(C7)","v":2022},"2022-01-01",{"$f":"D1","v":21400},{"$f":"IF(D1=0,,-PMT(D3,D2,D1)+H7)","v":305.43086105169931},{"$f":"IF(A7=0,,-PPMT($D$3,A7,$D$2,$D$1))","v":289.3808610516993},{"$f":"E7-F7","v":16.050000000000011},0,{"$f":"D7-F7","v":21110.619138948299},null,{"$f":"IF(D$1=0,,-IPMT($D$3,A7,$D$2,$D$1))","v":16.050000000000004},{"$f":"SUMIF($B$7:$G$165,$B$7:$B$165,$G$7:$G$165)","v":178.23977599294255}]
[{"$f":"IF(ROUND(I7,0)=0,0,A7+1)","v":2},2022,{"$f":"EDATE(C7,1)","v":"2022-02-01"},{"$f":"I7","v":21110.619138948299},{"$f":"IF(A8=0,0,E7)","v":305.43086105169931},{"$f":"IF(A8=0,,-PPMT($D$3,A8,$D$2,$D$1))","v":289.59789669748807},15.832964354211242,{"$f":"H7","v":0},20821.021242250812,null,{"$f":"IF(D$1=0,,-IPMT($D$3,A8,$D$2,$D$1))","v":15.83296435421123},{"$f":"SUMIF($B$7:$G$162,$B$7:$B$162,$G$7:$G$162)","v":178.23977599294255}]
[3,2022,"2022-03-01",20821.021242250812,305.43086105169931,289.81509512001122,15.615765931688088,0,20531.206147130801,null,15.615765931688111,{"$f":"SUMIF($B$4:$G$162,$B$4:$B$162,$G$4:$G$162)","v":178.23977599294255},{"$f":"SUM(F7:F9)","v":868.79385286919864},{"$f":"SUM(G7:G9)","v":47.498730285899342}]
[4,2022,"2022-04-01",20531.206147130801,305.43086105169931,290.0324564413512,15.398404610348109,0,20241.173690689451,null,15.398404610348104,178.23977599294255]
[5,2022,"2022-05-01",20241.173690689451,305.43086105169931,290.24998078368225,15.180880268017063,0,19950.923709905768,null,15.180880268017093,178.23977599294255]
[6,2022,"2022-06-01",19950.923709905768,305.43086105169931,290.46766826927001,14.963192782429303,0,19660.456041636498,null,14.963192782429328,178.23977599294255]
[7,2022,"2022-07-01",19660.456041636498,305.43086105169931,290.68551902047199,14.745342031227324,0,19369.770522616025,null,14.745342031227374,178.23977599294255]
[8,2022,"2022-08-01",19369.770522616025,305.43086105169931,{"$f":"IF(D8=0,,-PPMT($D$3,A14,$D$2,$D$1))","v":290.90353315973726},14.527327891962045,0,19078.866989456288,null,14.527327891962024,178.23977599294255]
[9,2022,"2022-09-01",19078.866989456288,305.43086105169931,291.12171080960707,14.309150242092244,0,18787.745278646682,null,14.309150242092221,178.23977599294255]
[10,2022,"2022-10-01",18787.745278646682,305.43086105169931,291.3400520927143,14.090808958985008,0,18496.405226553969,null,14.090808958985013,178.23977599294255]
[11,2022,"2022-11-01",18496.405226553969,305.43086105169931,291.55855713178386,13.872303919915453,0,18204.846669422186,null,13.872303919915481,178.23977599294255]
[12,2022,"2022-12-01",18204.846669422186,305.43086105169931,291.77722604963265,13.653635002066665,0,17913.069443372555,null,13.653635002066641,178.23977599294255,{"$f":"SUM(F7:F18)","v":3486.9305566274493}]
[13,2023,"2023-01-01",17913.069443372555,305.43086105169931,291.99605896916989,13.434802082529416,0,17621.073384403386,null,13.434802082529416,146.72762450885557]
[14,2023,"2023-02-01",17621.073384403386,305.43086105169931,292.2150560133968,13.215805038302506,0,17328.85832838999,null,13.215805038302539,146.72762450885557]
[15,2023,"2023-03-01",17328.85832838999,305.43086105169931,292.43421730540683,12.996643746292477,0,17036.424111084583,null,12.996643746292492,146.72762450885557,{"$f":"SUM(F10:F21)","v":3494.7820360462242},{"$f":"SUM(G19:G21)","v":39.647250867124399}]
[16,2023,"2023-04-01",17036.424111084583,305.43086105169931,292.65354296838592,12.777318083313389,0,16743.770568116197,null,12.777318083313437,146.72762450885557]
[17,2023,"2023-05-01",16743.770568116197,305.43086105169931,292.87303312561215,12.557827926087157,0,16450.897534990585,null,12.557827926087148,146.72762450885557]
[18,2023,"2023-06-01",16450.897534990585,305.43086105169931,293.09268790045638,12.338173151242927,0,16157.804847090129,null,12.338173151242938,146.72762450885557]
[19,2023,"2023-07-01",16157.804847090129,305.43086105169931,293.31250741638172,12.11835363531759,0,15864.492339673747,null,12.118353635317595,146.72762450885557]
[20,2023,"2023-08-01",15864.492339673747,305.43086105169931,293.53249179694399,11.898369254755323,0,15570.959847876802,null,11.898369254755307,146.72762450885557]
[21,2023,"2023-09-01",15570.959847876802,305.43086105169931,293.75264116579172,11.678219885907595,0,15277.207206711011,null,11.6782198859076,146.72762450885557]
[22,2023,"2023-10-01",15277.207206711011,305.43086105169931,293.97295564666604,11.457905405033273,0,14983.234251064345,null,11.457905405033257,146.72762450885557]
[23,2023,"2023-11-01",14983.234251064345,305.43086105169931,294.19343536340108,11.237425688298231,0,14689.040815700944,null,11.237425688298257,146.72762450885557]
[24,2023,"2023-12-01",14689.040815700944,305.43086105169931,294.41408043992362,11.016780611775687,0,14394.626735261021,null,11.016780611775708,146.72762450885557]
[25,2024,"2024-01-01",14394.626735261021,305.43086105169931,294.63489100025356,10.79597005144575,0,14099.991844260767,null,10.795970051445765,114.93069084312509]
[26,2024,"2024-02-01",14099.991844260767,305.43086105169931,294.85586716850372,10.574993883195589,0,13805.135977092263,null,10.574993883195575,114.93069084312509]
[27,2024,"2024-03-01",13805.135977092263,305.43086105169931,295.0770090688801,10.353851982819208,0,13510.058968023382,null,10.353851982819195,114.93069084312509,{"$f":"SUM(F22:F33)","v":3526.3651430611999},{"$f":"SUM(G31:G33)","v":31.724815917460546}]
[28,2024,"2024-04-01",13510.058968023382,305.43086105169931,295.29831682568181,10.132544226017501,0,13214.760651197701,null,10.132544226017536,114.93069084312509]
[29,2024,"2024-05-01",13214.760651197701,305.43086105169931,295.51979056330106,9.9110704883982521,0,12919.2408606344,null,9.9110704883982734,114.93069084312509]
[30,2024,"2024-06-01",12919.2408606344,305.43086105169931,295.74143040622351,9.6894306454757952,0,12623.499430228176,null,9.6894306454757988,114.93069084312509]
[31,2024,"2024-07-01",12623.499430228176,305.43086105169931,295.96323647902818,9.4676245726711272,0,12327.536193749147,null,9.4676245726711308,114.93069084312509]
[32,2024,"2024-08-01",12327.536193749147,305.43086105169931,{"$f":"IF(D32=0,,-PPMT($D$3,A38,$D$2,$D$1))","v":296.18520890638746},9.2456521453118512,0,12031.35098484276,null,9.2456521453118601,114.93069084312509]
[33,2024,"2024-09-01",12031.35098484276,305.43086105169931,{"$f":"IF(D33=0,,-PPMT($D$3,A39,$D$2,$D$1))","v":296.40734781306725},9.0235132386320629,0,11734.943637029693,null,9.0235132386320682,114.93069084312509]
[34,2024,"2024-10-01",11734.943637029693,305.43086105169931,{"$f":"IF(D34=0,,-PPMT($D$3,A40,$D$2,$D$1))","v":296.62965332392707},8.8012077277722369,0,11438.313983705766,null,8.8012077277722671,114.93069084312509]
[35,2024,"2024-11-01",11438.313983705766,305.43086105169931,296.85212556391997,8.5787354877793405,0,11141.461858141845,null,8.5787354877793227,114.93069084312509]
[36,2024,"2024-12-01",11141.461858141845,305.43086105169931,297.07476465809293,8.3560963936063786,0,10844.387093483752,null,8.3560963936063839,114.93069084312509]
[37,2025,"2025-01-01",10844.387093483752,305.43086105169931,297.29757073158652,8.133290320112792,0,10547.089522752165,null,8.1332903201128151,82.84640135710174]
[38,2025,"2025-02-01",10547.089522752165,305.43086105169931,297.52054390963519,7.9103171420641161,0,10249.56897884253,null,7.9103171420641241,82.84640135710174]
[39,2025,"2025-03-01",10249.56897884253,305.43086105169931,297.74368431756744,7.6871767341318673,0,9951.8252945249624,null,7.6871767341318984,82.84640135710174]
[40,2025,"2025-04-01",9951.8252945249624,305.43086105169931,297.9669920808056,7.4638689708937136,0,9653.8583024441559,null,7.4638689708937234,82.84640135710174]
[41,2025,"2025-05-01",9653.8583024441559,305.43086105169931,298.19046732486618,7.2403937268331333,0,9355.6678351192895,null,7.2403937268331182,82.84640135710174]
[42,2025,"2025-06-01",9355.6678351192895,305.43086105169931,298.41411017535984,7.0167508763394721,0,9057.2537249439301,null,7.0167508763394686,82.84640135710174]
[43,2025,"2025-07-01",9057.2537249439301,305.43086105169931,298.63792075799137,6.7929402937079431,0,8758.615804185938,null,6.7929402937079475,82.84640135710174]
[44,2025,"2025-08-01",8758.615804185938,305.43086105169931,298.86189919855985,6.5689618531394558,0,8459.7539049873776,null,6.5689618531394549,82.84640135710174]
[45,2025,"2025-09-01",8459.7539049873776,305.43086105169931,299.08604562295881,6.3448154287405032,0,8160.6678593644192,null,6.3448154287405361,82.84640135710174]
[46,2025,"2025-10-01",8160.6678593644192,305.43086105169931,299.31036015717598,6.1205008945233317,0,7861.3574992072436,null,6.1205008945233157,82.84640135710174]
[47,2025,"2025-11-01",7861.3574992072436,305.43086105169931,299.53484292729388,5.8960181244054297,0,7561.82265627995,null,5.8960181244054333,82.84640135710174]
[48,2025,"2025-12-01",7561.82265627995,305.43086105169931,299.75949405948933,5.6713669922099825,0,7262.063162220461,null,5.6713669922099639,82.84640135710174]
[49,2026,"2026-01-01",7262.063162220461,305.43086105169931,{"$f":"IF(D49=0,,-PPMT($D$3,A55,$D$2,$D$1))","v":299.98431368003395},5.4465473716653605,0,6962.0788485404273,null,5.4465473716653463,50.472159153602774]
[50,2026,"2026-02-01",6962.0788485404273,305.43086105169931,{"$f":"IF(D50=0,,-PPMT($D$3,A56,$D$2,$D$1))","v":300.20930191529396},5.2215591364053466,0,6661.8695466251338,null,5.2215591364053209,50.472159153602774]
[51,2026,"2026-03-01",6661.8695466251338,305.43086105169931,{"$f":"IF(D51=0,,-PPMT($D$3,A57,$D$2,$D$1))","v":300.43445889173046},4.9964021599688522,0,6361.4350877334036,null,4.9964021599688495,50.472159153602774]
[52,2026,"2026-04-01",6361.4350877334036,305.43086105169931,300.65978473589928,4.7710763158000304,0,6060.7753029975047,null,4.7710763158000526,50.472159153602774]
[53,2026,"2026-05-01",6060.7753029975047,305.43086105169931,300.8852795744512,4.5455814772481062,0,5759.8900234230532,null,4.5455814772481276,50.472159153602774]
[54,2026,"2026-06-01",5759.8900234230532,305.43086105169931,301.11094353413199,4.319917517567319,0,5458.7790798889209,null,4.3199175175672897,50.472159153602774]
[55,2026,"2026-07-01",5458.7790798889209,305.43086105169931,301.33677674178261,4.0940843099166955,0,5157.4423031471379,null,4.094084309916691,50.472159153602774]
[56,2026,"2026-08-01",5157.4423031471379,305.43086105169931,301.56277932433898,3.8680817273603338,0,4855.8795238227985,null,3.8680817273603534,50.472159153602774]
[57,2026,"2026-09-01",4855.8795238227985,305.43086105169931,301.78895140883219,3.6419096428671196,0,4554.0905724139666,null,3.6419096428670996,50.472159153602774]
[58,2026,"2026-10-01",4554.0905724139666,305.43086105169931,302.01529312238887,3.4155679293104413,0,4252.0752792915773,null,3.4155679293104755,50.472159153602774]
[59,2026,"2026-11-01",4252.0752792915773,305.43086105169931,302.24180459223066,3.1890564594686452,0,3949.8334746993469,null,3.1890564594686834,50.472159153602774]
[60,2026,"2026-12-01",3949.8334746993469,305.43086105169931,302.46848594567479,2.962375106024524,0,3647.3649887536722,null,2.9623751060245103,50.472159153602774]
[61,2027,"2027-01-01",3647.3649887536722,305.43086105169931,302.69533731013405,2.7355237415652596,0,3344.669651443538,null,2.7355237415652547,17.805343866719511]
[62,2027,"2027-02-01",3344.669651443538,305.43086105169931,302.92235881311666,2.5085022385826505,0,3041.7472926304213,null,2.5085022385826541,17.805343866719511]
[63,2027,"2027-03-01",3041.7472926304213,305.43086105169931,303.14955058222648,2.2813104694728281,0,2738.597742048195,null,2.2813104694728161,17.805343866719511]
[64,2027,"2027-04-01",2738.597742048195,305.43086105169931,303.37691274516322,2.0539483065360855,0,2435.2208293030317,null,2.0539483065361464,17.805343866719511]
[65,{"$f":"YEAR(C71)","v":2027},"2027-05-01",2435.2208293030317,305.43086105169931,303.60444542972203,{"$f":"E71-F71","v":1.8264156219772758},0,{"$f":"D71-F71","v":2131.6163838733096},null,1.826415621977274,{"$f":"SUMIF($B$4:$G$162,$B$4:$B$162,$G$4:$G$162)","v":17.805343866719511}]
[{"$f":"IF(ROUND(I71,0)=0,0,A71+1)","v":66},2027,{"$f":"EDATE(C71,1)","v":"2027-06-01"},{"$f":"I71","v":2131.6163838733096},{"$f":"IF(A72=0,0,E71)","v":305.43086105169931},303.83214876379435,1.5987122879049593,{"$f":"H71","v":0},1827.7842351095153,null,{"$f":"IF(D$1=0,,-IPMT($D$3,A72,$D$2,$D$1))","v":1.5987122879049824},17.805343866719511]
[67,2027,"2027-07-01",1827.7842351095153,305.43086105169931,304.06002287536717,1.3708381763321427,0,1523.7242122341481,null,1.3708381763321364,17.805343866719511,{"$f":"SUM(F62:F73)","v":3633.7180909129893},{"$f":"SUM(G62:G73)","v":31.452241707402266}]
[68,2027,"2027-08-01",1523.7242122341481,305.43086105169931,{"$f":"IF(D68=0,,-PPMT($D$3,A74,$D$2,$D$1))","v":304.28806789252371},1.1427931591755964,0,1219.4361443416244,null,1.1427931591756113,17.805343866719511]
[69,2027,"2027-09-01",1219.4361443416244,305.43086105169931,{"$f":"IF(D69=0,,-PPMT($D$3,A75,$D$2,$D$1))","v":304.51628394344306},0.91457710825625327,0,914.9198603981813,null,0.91457710825621841,17.805343866719511]
[70,2027,"2027-10-01",914.9198603981813,305.43086105169931,{"$f":"IF(D70=0,,-PPMT($D$3,A76,$D$2,$D$1))","v":304.74467115640067},0.68618989529863939,0,610.17518924178057,null,0.68618989529863617,17.805343866719511]
[71,2027,"2027-11-01",610.17518924178057,305.43086105169931,304.97322965976798,0.45763139193132929,0,305.20195958201259,null,0.45763139193133556,17.805343866719511]
[72,2027,"2027-12-01",305.20195958201259,305.43086105169931,305.20195958201282,0.22890146968649105,0,0,null,0.22890146968650957,17.805343866719511]