{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Graphique ","BP 2011","Prévision","salaires"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"Graphique ","index":0,"reason":"not_a_worksheet"}],"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":"BP 2011","index":1,"n_rows":65,"n_cols":13,"rows_kept":65,"cut":false,"hidden":false,"merged":[[14,4,14,5]]}
[]
["fonctionnement",2011,"subventions=>65",{"$f":"SUM(D3:D21)","v":4558},"Particip=>65",{"$f":"SUM(F3:F13)","v":39370}]
["Dépenses",{"$f":"SUM(B4:B17)","v":368488},"Comité de fêtes",500,null,null,null,"Investissement"]
["générales 011",{"$f":"F16+F17","v":65000},"ADMR",90,"Perte  sur créance ",1250,null,"Invest Diff",{"$f":"I24-I5","v":-1499.7899999999208}]
["personnel 012",{"$f":"127560-D26","v":110560},"Chasse",170,null,null,null,"Dépenses",{"$f":"SUM(I6:I23)","v":586137.18999999994}]
["gest courante 65",{"$f":"D2+F2+D26","v":60928},"Anc Comb",170,"Sivos ATAV *",{"$f":"(4000)+13*2200","v":32600}]
["charges financière 66",25335,"Club cyclo",390]
["charges exceptio 67",0,"Mnt",250,"Syndicat Elect",1320]
["amortissement 68",null,"Ass Maire ",209,"Fourrière",250]
["revers sur rec 739",null,"TS16",150,"SDITEC",1700,null,"RAR ",{"$f":"K23","v":52605},"RAR dépenses","Reste ","cpl","Total"]
["dépenses imprévues 022",0,"CCAS",1400,"CLIS MANSLE",1000,null,"cpl 2010 sur op existantes",{"$f":"L23","v":446665},"Caution cpte 165",600,null,{"$f":"K11+L11","v":600}]
["virement invest 023",106665,"Club Aînés",350,"Maternelle mansle",1250,null,"D001",35635.19,null,0,null,{"$f":"K12+L12","v":0}]
["déficit reporté 002",null,"CJM",90,null,null,null,"24 FDAC 2011",{"$f":"Prévision!C18","v":13500},null,null,0,0]
["dot Amo 042",0,"Aipe",250,null,null,null,"Emprunt",null,"35 voirie",2000,null,2000]
[null,null,"course montignac",75,"détails du 011",null,null,null,null,"41 traverse de ravaud",10905,{"$f":"432400-K15","v":421495},432400]
[null,null,"APISAB",90,"Divers",49000,null,null,null,null,null,null,0]
[null,null,"Banque Alimentaire",90,"Ecole",16000,null,null,null,"45 OP Communale",9100,{"$f":"Prévision!C16-'BP 2011'!K17","v":25170},34270]
[null,null,"FCOL",75,null,null,null,null,null,"remb prêt TVA",30000,0,30000]
["Recettes",{"$f":"SUM(B20:B34)","v":237636},"Donneurs de sang",90,null,null,null,null,null,"op non affectée",null,null,0]
["Service et domaine 70",15000,"Musique ",75,null,null,null,"Remb emprunt ",37732,null,null,null,0]
["Travaux en régie 72",null,"Razed ",44,null,null,null,null,null,null,0,null,0]
["impôts et taxes 73",{"$f":"B52","v":159456},null,null,null,null,null,"Dépenses Imp. INV",0,null,null,null,0]
["dotation sub  74","l",null,null,null,null,null,null,null,"total",{"$f":"SUM(K11:K22)","v":52605},{"$f":"SUM(L11:L22)","v":446665},{"$f":"SUM(M11:M22)","v":499270}]
["produits gest cour 75",32000,null,null,null,null,null,"Recette",{"$f":"SUM(I25:I39)","v":584637.4}]
["produit financiers 76",null,null,null,null,null,null,"Report 023",{"$f":"B12","v":106665}]
["produits exceptio 77",4600,"ind. Élus+ retraite",17000,null,null,null,"CPL SUR rar",{"$f":"L39","v":252956},"RAR Recette","Reste ","cpl","Total"]
["reprise sur amort 78",0,null,null,null,null,null,"FCTVA",8100,"caution",600,0,{"$f":"K27+L27","v":600}]
["transfert charges 79",null,null,null,null,"Balance inter section ",null,"R001",null,"41 traverse de ravaud",3135,{"$f":"55831+37221+37221+92683+30000","v":252956},256091]
["atténuat charges 013",{"$f":"12000+2163","v":14163},null,null,null,{"$f":"D30+I4","v":-132351.78999999992},null,1068,77505,"35 voirie",7000,null,7000]
["excédent reporté 002",{"$f":"89922-I29","v":12417},"diff fonct ",{"$f":"B19-B3","v":-130852},null,null,null,"RAR",{"$f":"K39","v":10735},null,null,null,0]
[null,null,null,null,null,null,null,"Prêt relais à 2014",{"$f":"Prévision!E17","v":62306.400000000001},null,null,null,0]
[null,null,null,null,null,null,null,"Prêt Ravaud",66370,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,"Total",{"$f":"SUM(K27:K38)","v":10735},{"$f":"SUM(L27:L38)","v":252956},{"$f":"SUM(M27:M38)","v":263691}]
["Dotations",2011,2010,2009,"DELTA"]
["chapitre 74",{"$f":"SUM(B42:B50)","v":130852},{"$f":"SUM(C42:C47)","v":86689},{"$f":"SUM(D42:D47)","v":87661},{"$f":"C41-D41","v":-972}]
["Cpte 7411 dgf forfaitaire",{"$f":"78425-B43-B44","v":67504},66917,{"$f":"28878+5651+22018+11008","v":67555},{"$f":"C42-D42","v":-638}]
["cpte74121 dsr",8128,7922,7922,0]
["cpte 742 élus locaux",2793,2783,2762,21]
["cpte74883* compens TP",554,{"$f":"481+43+95+23","v":642},{"$f":"25+104+514","v":643},-1,null,null,"A 4% un emprunt de 80 000€ sur 20 ans c'est 6K€ par an et sur 10 ans c'est 9K€"]
["cpte 74834*Compens TF",{"$f":"923+4717","v":5640},{"$f":"4707+1235","v":5942},{"$f":"1451+4679","v":6130},-188]
["Cpte 74835* compens TH",4240,2483,2649,-166]
["total compensation",{"$f":"SUM(B45:B47)","v":10434},{"$f":"SUM(C45:C47)","v":9067},{"$f":"SUM(D45:D47)","v":9422}]
["7482 compen Mutations",7900]
["GIR",23659]
[]
["Chapitre 73",{"$f":"SUM(B53:B55)","v":159456},{"$f":"SUM(C53:C55)","v":174536},{"$f":"SUM(D53:D55)","v":165801}]
[" cpte 7311 impôts",149163,100024,151701,null,2010]
["cpte 7381 droit mutation",0,7915,14100,null,"compte 7311 : 100.024,00 €"]
["7318 - Autres impôts locaux ou assimilés",{"$f":"271+2186+7836","v":10293},{"$f":"C60+C61","v":66597},null,null,"- compte 7318 :   66.597,00 €",null,"+"]
[null,null,null,null,null,"- compte 7381 :     7.915,00 €"]
[null,null,33129,"TH"]
[null,null,47922,"TFB"]
[null,null,18973,"TFNB"]
[null,null,66597,"TP 1compo"]
[null,null,0,"TP2 compo",null,"2010-03-31"]
[null,null,{"$f":"SUM(C57:C61)","v":166621}]
[]
[]
[null,149163]

{"sheet":"Prévision","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"DM","BP 2011"]
["cuve fioul",null,1200]
["Divers out et matos",null,500]
["Portique",null,650]
["récup Tombes 33",null,9900]
["Défibrilateur",null,2000]
["Haie bache incendie",null,400]
["Marteaux",null,300]
["Mur Cimetière",null,400,null,null,{"$f":"1/0.196","v":5.1020408163265305}]
["Tableau+ Robinet chauf.+ Plafond ECOLE",null,{"$f":"150+540+300","v":990}]
["Colombarium- Osuaire",null,6030]
["SOCOTEC TRX Elect",null,1000]
["Podium",null,3600]
["banquette vadalle + mur RD15 accidenté",null,{"$f":"200+4600","v":4800},null,null,null,null,null,{"$f":"100-19.6","v":80.400000000000006}]
["Parking aussac + Toit Mairie",null,{"$f":"1000+1500","v":2500}]
[null,"sous total",{"$f":"SUM(C2:C15)","v":34270}]
["Traverse de ravaud",null,{"$f":"368200+12000+19200+33000","v":432400},"FTVA ",{"$f":"(C17-33000)*0.156","v":62306.400000000001}]
["FDAC 2011",null,13500]
["Total",{"$f":"SUM(B2:B18)","v":0},{"$f":"SUM(C2:C18)","v":514440}]

{"sheet":"salaires","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Simulation SALAIRES"]
[]
[]
[null,"brut","ch patronales","total",2010,"remb"]
["Titulaires"]
["BAUD 35 h",680,205.82,{"$f":"B6+C6","v":885.81999999999994},{"$f":"D6+(680+680+680)","v":2925.8199999999997},{"$f":"1004.66+1561.89+677.27+677.27","v":3921.09}]
["Françoise 29,5h",1187,565,1752,{"$f":"SUM(D7+1752+((1206+574)*10))","v":21304}]
["Sabrina 35h",1501,675,2176,{"$f":"D8*12","v":26112}]
["Daniel 17,5 h",808,348,1156,{"$f":"D9*12","v":13872}]
["Pascal",1625,715,2340,{"$f":"D10*12","v":28080}]
["Sarah 8 h",325,135,460,{"$f":"D11*5","v":2300}]
["Christelle 14h",611,252,863,{"$f":"D12*12","v":10356}]
[]
[]
["GENERAL",{"$f":"SUM(B6:B13)","v":6737},{"$f":"SUM(C6:C13)","v":2895.8199999999997},null,{"$f":"SUM(E6:E14)","v":104949.82}]
[]
[]
[]
[]
["indemnités ELUS",null,null,null,2010]
["g LIOT",644,22,{"$f":"B21+C21","v":666},{"$f":"D21*12","v":7992}]
["Martine",250,9,{"$f":"B22+C22","v":259},{"$f":"D22*12","v":3108}]
["Luc",250,9,{"$f":"B23+C23","v":259},{"$f":"D23*12","v":3108}]
["Jacky",125,5,{"$f":"B24+C24","v":130},{"$f":"D24*12","v":1560}]
["peze",null,null,null,400]
[null,null,null,null,{"$f":"SUM(E21:E25)","v":16168}]