{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Ressources","Actes","DONNEES","Lyon","Paris","Strasbourg"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":120,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ressources","index":0,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Nom complet du type de dossier","Nom Dossier raccourci"]
["Déclaration préalable - Constructions, travaux, installations et aménagements non soumis à permis comprenant ou non des démolitions","DP"]
["Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP"]
["Certificat d'urbanisme opérationnel (Type b)","CuB"]
["Permis de construire comprenant ou non des démolitions","PC"]
["Permis de construire une maison individuelle et/ou ses annexes","PCMI"]
["Autorisation de construire, d'aménager ou de modifier un établissement recevant du public (ERP)","AT"]
["Dossier spécifique permettant de vérifier la conformité des établissements recevant du public aux règles d'accessibilité et de sécurité contre l'incendie et la panique","AT"]
["Autorisation préalable de nouvelle installation, de remplacement ou de modification d'un dispositif ou d'un matériel supportant de la publicité, une préenseigne ou une enseigne","AP"]
["Déclaration préalable - Lotissements et autres divisions foncières non soumis à permis d'aménager","DP"]
["Permis d'aménager comprenant ou non des constructions et/ou des démolitions","PA"]
["Permis de démolir","PD"]
["Permis de construire pour une maison individuelle et/ou ses annexes","PCMI"]
["Déclaration préalable de nouvelle installation, de remplacement ou de modification d'un dispositif ou d'un matériel supportant de la publicité ou une préenseigne","DP"]
["Déclaration préalable - Constructions, travaux, installations et aménagements non soumis à permis","DP"]
["Déclaration préalable - Constructions, travaux, installations et aménagements non soumis à permis","DP"]
[]
[]
["Tarifs"]
["AP",128]
["AT",128]
["CuB",128]
["DP",224]
["PA",960]
["PC",960]
["PCMI",320]
["PD",224]
[]
[]
["Actes"]
[]
["AP"]
["AT"]
["CuB"]
["DP"]
["PA"]
["PC"]
["PCMI"]
["PD"]

{"sheet":"Actes","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Commune"]
["Lyon","CuB / Toutes DP/ PCMI / PC / PA"]
["Paris","CuB / DP avec Taxes / PD / PCMI / PC / PA"]
["Strasbourg","DP avec Taxes / PCMI / PC / PA"]

{"sheet":"DONNEES","index":2,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,2,9,3],[12,2,12,3],[0,12,0,15],[0,9,0,11],[0,7,0,8],[3,2,3,3],[2,2,2,20],[8,2,8,20],[11,2,11,20]]}
[null,null,"COMMUNE","Enregistrement dossier",null,null,null,"Service Instructeur\ndernière décision",null,"Saisie Commune",null,null,"Pétitionnaire",null,null,null,"Permis ",null,"instruction",null,null,null,"Facturation","Coût \nPermis "]
[null,"N° \nFACTURES","Nom ","Nom et prénom de l'instructeur",null,"Dossier","Date de dépôt","Date de rédaction","Avis ","Autorité compétente","Dernière décision \nAvis ","Dernière décision \nDate ","Demandeur - Prénom particulier","Demandeur - Nom particulier","Personne morale","Demandeur - Nom représentant","raccourci","Modif\nTransfert","en \ncours","en retard \n(noter la cause)","Annul°"]
[null,1,"Lyon"]
[null,null,{"$f":"VLOOKUP(C6,Actes!$A$2:$B$4,2,0)","v":"CuB / Toutes DP/ PCMI / PC / PA"}]
["X",null,"Lyon","Emilie DURAND","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 01235 17 C0010","19/10/2017","2017-11-18","favorable avec prescriptions","Maire au nom de la commune","favorable avec prescriptions","21/11/2017","Pierre","DURAND",0,0,"DP"]
["X",null,"Lyon","Emilie DURAND","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 01235 17 C0012","24/10/2017","2017-11-10","favorable","Maire au nom de la commune","favorable","21/11/2017","Laurent","JACQUES",0,0,"DP","",null,null,"",null,"",224]
["X",null,"Lyon","Christian DUPONT","Permis de construire pour une maison individuelle et/ou ses annexes","PC 01235 17 C0006","23/09/2017","2017-10-23","favorable avec prescriptions","Maire au nom de la commune","Accord avec prescriptions","21/11/2017","Cédric","DUMONT",0,0,"PCMI","",null,null,"",null,"",320]
["X",null,"Lyon","Marie PIERRE","Permis de construire pour une maison individuelle et/ou ses annexes","PC 01235 17 C0007","24/11/2017","2018-02-12","favorable avec prescriptions","Maire au nom de la commune",0,0,"Kamel","JEAN",0,0,"PCMI","",null,null,"",null,"",320]
[null,2,"Paris"]
[null,null,{"$f":"VLOOKUP(C11,Actes!$A$2:$B$4,2,0)","v":"CuB / DP avec Taxes / PD / PCMI / PC / PA"}]
["X",null,"Paris","Christian DUPONT","Déclaration préalable - Constructions, travaux, installations et aménagements non soumis à permis","DP 45698 17 C0005","23/10/2017","2017-12-08","favorable avec prescriptions","Maire au nom de la commune",0,0,0,0,"ORR Steven","ORR","DP","",null,null,"",null,"",224]
[null,3,"Strasbourg"]
[null,null,{"$f":"VLOOKUP(C15,Actes!$A$2:$B$4,2,0)","v":"DP avec Taxes / PCMI / PC / PA"}]
["X",null,"Strasbourg","Emilie DURAND","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 36985 17 C0023","06/10/2017","2017-11-27","favorable avec prescriptions","Maire au nom de la commune","favorable avec prescriptions","28/11/2017","Paolo","MARTIN",0,0,"DP","",null,null,"",null,"",224]
["X",null,"Strasbourg","Jean-Charles PATRICK","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 45632 17 C0024","06/10/2017","2017-11-27","favorable avec prescriptions","Maire au nom de la commune","favorable avec prescriptions","28/11/2018","Christophe","DUPONT",0,0,"DP"]
["X",{"$f":"IF(COUNTIF(R16,\"*Modif*\"),\"Pas de Fact\",IF(COUNTIF(R16,\"*Transfert*\"),\"Pas de Fact\",\"\"))","v":""},"Strasbourg","Marie PIERRE","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 45879 17 C0025","17/10/2017","2017-11-02","favorable avec prescriptions","Maire au nom de la commune","favorable avec prescriptions","21/11/2017","Jean-Philippe","CAMUS",0,0,"DP","",null,null,"",null,"",224]
[null,"","Strasbourg","Jean-Charles PATRICK","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 12365 17 C0026","30/10/2017","2018-01-31",0,"Maire au nom de la commune",0,0,"Gilles","FLAUBERT",0,0,"DP","",null,null,"",null,"",224]
["X","","Strasbourg","Emilie DURAND","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 12365 17 C0027","31/10/2017","2017-11-15","favorable avec prescriptions","Maire au nom de la commune","favorable avec prescriptions","21/11/2017","Aline","BLEUET",0,0,"DP","",null,null,"",null,"",224]
[null,"","Strasbourg","Laurence GUITOU","Déclaration préalable à la réalisation de constructions et travaux non soumis à permis de construire portant sur une maison individuelle et/ou ses annexes","DP 78965 17 C0029","17/11/2017","2018-02-09","favorable avec prescriptions","Maire au nom de la commune",0,0,"Alexandre","GAULARD",0,0,"DP","",null,null,"",null,"",224]
["X","","Strasbourg","Laurence GUITOU","Permis de construire pour une maison individuelle et/ou ses annexes","PC 45698 17 C0004","23/06/2017","2017-11-14","favorable avec prescriptions","Maire au nom de la commune",0,0,0,0,"MQPC","FOCK","PCMI","",null,null,"",null,"",320]
[null,"","Strasbourg","Marie PIERRE","Permis de construire comprenant ou non des démolitions","PC 14698 17 C0005","17/11/2017",null,0,"Maire au nom de la commune",0,0,0,0,"SCI MAV","GOMES DIAS","PC","","X",null,"",null,"",960]

{"sheet":"Lyon","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,5],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,7]]}
[{"$f":"C3","v":"Lyon"}]
["2018-03-15",null,null,"N° de facture :",null,null,{"$f":"INDEX(DONNEES!B:B,MATCH(C3,DONNEES!C:C,0),1)","v":1},"/ 2018"]
["Commune :",null,"Lyon"]
["Adresse de facturation :"]
[]
[]
["Permis\ninstruits","N° Dossier","Date \nde dépôt","Date  prop. de décision","Nom \nDemandeur","Prix \nunitaire","Nbre","Montant"]
["DP",{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A5=\"x\",DONNEES!C5= \"AMAGNEY\"),DONNEES!G5,\"\")","v":""},{"$f":"IF(AND(DONNEES!$A$5=\"x\",DONNEES!$C$5= \"AMAGNEY\"),DONNEES!H5,\"\")","v":""},{"$f":"IF(AND(DONNEES!$A$5=\"x\",DONNEES!$C$5= \"AMAGNEY\"),DONNEES!N5,\"\")","v":""},{"$f":"IF(A8=\"CuB\",128,IF(A8=\"AT\",128,IF(A8=\"DP\",224,IF(A8=\"PD\",224,IF(A8=\"PCMI\",320,IF(A8=\"PC\",960,IF(A8=\"PA\",960,)))))))","v":224},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":224}]
["DP",{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A6=\"x\",DONNEES!C6= \"AMAGNEY\"),DONNEES!G6,\"\")","v":""},{"$f":"IF(AND(DONNEES!$A$6=\"x\",DONNEES!$C$6= \"AMAGNEY\"),DONNEES!H6,\"\")","v":""},{"$f":"IF(AND(DONNEES!$A$6=\"x\",DONNEES!$C$6= \"AMAGNEY\"),DONNEES!N6,\"\")","v":""},{"$f":"IF(A9=\"CuB\",128,IF(A9=\"AT\",128,IF(A9=\"DP\",224,IF(A9=\"PD\",224,IF(A9=\"PCMI\",320,IF(A9=\"PC\",960,IF(A9=\"PA\",960,)))))))","v":224},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":224}]
["PCMI",{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!$A$7=\"x\",DONNEES!$C$7= \"AMAGNEY\"),DONNEES!G7,\"\")","v":""},{"$f":"IF(AND(DONNEES!$A$7=\"x\",DONNEES!$C$7= \"AMAGNEY\"),DONNEES!H7,\"\")","v":""},{"$f":"IF(AND(DONNEES!$A$7=\"x\",DONNEES!$C$7= \"AMAGNEY\"),DONNEES!N7,\"\")","v":""},{"$f":"IF(A10=\"CuB\",128,IF(A10=\"AT\",128,IF(A10=\"DP\",224,IF(A10=\"PD\",224,IF(A10=\"PCMI\",320,IF(A10=\"PC\",960,IF(A10=\"PA\",960,)))))))","v":320},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":320}]
["PCMI",{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},null,null,null,320,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":320}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A10=\"x\",DONNEES!C10= \"AMAGNEY\"),DONNEES!G10,\"\")","v":""},{"$f":"IF(AND(DONNEES!A10=\"x\",DONNEES!C10= \"AMAGNEY\"),DONNEES!H10,\"\")","v":""},{"$f":"IF(AND(DONNEES!A10=\"x\",DONNEES!C10= \"AMAGNEY\"),DONNEES!N10,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A11=\"x\",DONNEES!C11= \"AMAGNEY\"),DONNEES!G11,\"\")","v":""},{"$f":"IF(AND(DONNEES!A11=\"x\",DONNEES!C11= \"AMAGNEY\"),DONNEES!H11,\"\")","v":""},{"$f":"IF(AND(DONNEES!A11=\"x\",DONNEES!C11= \"AMAGNEY\"),DONNEES!N11,\"\")","v":""},{"$f":"IF(A13=\"CuB\",128,IF(A13=\"AT\",128,IF(A13=\"DP\",224,IF(A13=\"PD\",224,IF(A13=\"PCMI\",320,IF(A13=\"PC\",960,IF(A13=\"PA\",960,)))))))","v":0},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A12=\"x\",DONNEES!C12= \"AMAGNEY\"),DONNEES!G12,\"\")","v":""},{"$f":"IF(AND(DONNEES!A12=\"x\",DONNEES!C12= \"AMAGNEY\"),DONNEES!H12,\"\")","v":""},{"$f":"IF(AND(DONNEES!A12=\"x\",DONNEES!C12= \"AMAGNEY\"),DONNEES!N12,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A13=\"x\",DONNEES!C13= \"AMAGNEY\"),DONNEES!G13,\"\")","v":""},{"$f":"IF(AND(DONNEES!A13=\"x\",DONNEES!C13= \"AMAGNEY\"),DONNEES!H13,\"\")","v":""},{"$f":"IF(AND(DONNEES!A13=\"x\",DONNEES!C13= \"AMAGNEY\"),DONNEES!N13,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A14=\"x\",DONNEES!C14= \"AMAGNEY\"),DONNEES!G14,\"\")","v":""},{"$f":"IF(AND(DONNEES!A14=\"x\",DONNEES!C14= \"AMAGNEY\"),DONNEES!H14,\"\")","v":""},{"$f":"IF(AND(DONNEES!A14=\"x\",DONNEES!C14= \"AMAGNEY\"),DONNEES!N14,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A15=\"x\",DONNEES!C15= \"AMAGNEY\"),DONNEES!G15,\"\")","v":""},{"$f":"IF(AND(DONNEES!A15=\"x\",DONNEES!C15= \"AMAGNEY\"),DONNEES!H15,\"\")","v":""},{"$f":"IF(AND(DONNEES!A15=\"x\",DONNEES!C15= \"AMAGNEY\"),DONNEES!N15,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A11=\"x\",DONNEES!C11= \"AMAGNEY\"),DONNEES!G11,\"\")","v":""},{"$f":"IF(AND(DONNEES!A11=\"x\",DONNEES!C11= \"AMAGNEY\"),DONNEES!H11,\"\")","v":""},{"$f":"IF(AND(DONNEES!A11=\"x\",DONNEES!C11= \"AMAGNEY\"),DONNEES!N11,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A13=\"x\",DONNEES!C13= \"AMAGNEY\"),DONNEES!G13,\"\")","v":""},{"$f":"IF(AND(DONNEES!A13=\"x\",DONNEES!C13= \"AMAGNEY\"),DONNEES!H13,\"\")","v":""},{"$f":"IF(AND(DONNEES!A13=\"x\",DONNEES!C13= \"AMAGNEY\"),DONNEES!N13,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},{"$f":"IF(AND(DONNEES!A14=\"x\",DONNEES!C14= \"AMAGNEY\"),DONNEES!G14,\"\")","v":""},{"$f":"IF(AND(DONNEES!A14=\"x\",DONNEES!C14= \"AMAGNEY\"),DONNEES!H14,\"\")","v":""},{"$f":"IF(AND(DONNEES!A14=\"x\",DONNEES!C14= \"AMAGNEY\"),DONNEES!N14,\"\")","v":""},0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},null,null,null,{"$f":"IF(A22=\"CuB\",128,IF(A22=\"AT\",128,IF(A22=\"DP\",224,IF(A22=\"PD\",224,IF(A22=\"PCMI\",320,IF(A22=\"PC\",960,IF(A22=\"PA\",960,)))))))","v":0},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""},null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952[[#This Row],[Nbre]]","v":0}]
[null,{"$f":"IF(AND(DONNEES!A:A=\"x\",DONNEES!C:C= \"AMAGNEY\"),DONNEES!F:F,\"\")","v":""}]
[null,null,null,null,null,"    Total Permis",{"$f":"COUNTIF(G9:G24,1)","v":15},{"$f":"SUM(H9:H24)","v":864}]
[]
[null,null,null,null,null,"Total facturation Permis",{"$f":"G25","v":15},{"$f":"H25","v":864}]

{"sheet":"Paris","index":4,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,5],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,7]]}
[]
[{"$f":"Lyon!A2","v":"2018-03-15"},null,null,"N° de facture :",null,null,{"$f":"INDEX(DONNEES!B:B,MATCH(C3,DONNEES!C:C,0),1)","v":2},"/ 2018"]
["Commune :",null,"Paris"]
["Adresse de facturation :"]
[]
["Permis\ninstruits","N° Dossier","Date \nde dépôt","Date  prop. de décision","Nom \nDemandeur","Prix \nunitaire","Nbre","Montant"]
[]
[null,null,null,null,null,{"$f":"IF(A8=\"CuB\",128,IF(A8=\"AT\",128,IF(A8=\"DP\",224,IF(A8=\"PD\",224,IF(A8=\"PCMI\",320,IF(A8=\"PC\",960,IF(A8=\"PA\",960,)))))))","v":0},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,{"$f":"IF(A9=\"CuB\",128,IF(A9=\"AT\",128,IF(A9=\"DP\",224,IF(A9=\"PD\",224,IF(A9=\"PCMI\",320,IF(A9=\"PC\",960,IF(A9=\"PA\",960,)))))))","v":0},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture573456171820212578952546[[#This Row],[Prix \nunitaire]]*tblFacture573456171820212578952546[[#This Row],[Nbre]]","v":0}]
[]
[]
[]
[null,null,null,null,null,"    Total Permis",{"$f":"COUNTIF(G8:G18,1)","v":8},{"$f":"SUM(H8:H18)","v":0}]
[]
[null,null,null,null,null,"Total facturation Permis",{"$f":"G19","v":8},{"$f":"H19","v":0}]

{"sheet":"Strasbourg","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,5],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,7]]}
[]
[{"$f":"Lyon!A2","v":"2018-03-15"},null,null,"N° de facture :",null,null,{"$f":"INDEX(DONNEES!B:B,MATCH(C3,DONNEES!C:C,0),1)","v":3},"/ 2018"]
["Commune :",null,"Strasbourg"]
["Adresse de facturation :"]
[]
["Permis\ninstruits","N° Dossier","Date \nde dépôt","Date  prop. de décision","Nom \nDemandeur","Prix \nunitaire","Nbre","Montant"]
[]
[null,null,null,null,null,{"$f":"IF(A8=\"CuB\",128,IF(A8=\"AT\",128,IF(A8=\"DP\",224,IF(A8=\"PD\",224,IF(A8=\"PCMI\",320,IF(A8=\"PC\",960,IF(A8=\"PA\",960,)))))))","v":0},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture5734561718202125789525455[[#This Row],[Prix \nunitaire]]*tblFacture5734561718202125789525455[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,{"$f":"IF(A9=\"CuB\",128,IF(A9=\"AT\",128,IF(A9=\"DP\",224,IF(A9=\"PD\",224,IF(A9=\"PCMI\",320,IF(A9=\"PC\",960,IF(A9=\"PA\",960,)))))))","v":0},{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture5734561718202125789525455[[#This Row],[Prix \nunitaire]]*tblFacture5734561718202125789525455[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture5734561718202125789525455[[#This Row],[Prix \nunitaire]]*tblFacture5734561718202125789525455[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture5734561718202125789525455[[#This Row],[Prix \nunitaire]]*tblFacture5734561718202125789525455[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture5734561718202125789525455[[#This Row],[Prix \nunitaire]]*tblFacture5734561718202125789525455[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture5734561718202125789525455[[#This Row],[Prix \nunitaire]]*tblFacture5734561718202125789525455[[#This Row],[Nbre]]","v":0}]
[null,null,null,null,null,0,{"$f":"IF(ISBLANK(#REF!),0,1)","v":1},{"$f":"tblFacture5734561718202125789525455[[#This Row],[Prix \nunitaire]]*tblFacture5734561718202125789525455[[#This Row],[Nbre]]","v":0}]
[]
[]
[null,null,null,null,null,"    Total Permis",{"$f":"COUNTIF(G8:G16,1)","v":7},{"$f":"SUM(H8:H16)","v":0}]
[]
["Forfait Optionnel","N° Dossier","Date \nde dépôt","Date  de récolement","Nom \nDemandeur","Prix \nunitaire","Nbre","Montant"]
[]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(B21),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(B22),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(B23),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(B24),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(B25),0,1)","v":0}]
[]
[null,null,null,null,null,"   Total Forfait Optionnel",{"$f":"COUNTIF(G20:G26,1)","v":0},{"$f":"SUM(H20:H26)","v":0}]
[]
[null,null,null,null,null,"Total facturation Permis + forfait Optionnel",{"$f":"G17+G27","v":7},{"$f":"H17+H27","v":0}]