{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Liste Operation","Formulaire","Detail Operation","Conclusion","Edition","Feuil1"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":2,"defined_names":6,"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":"Liste Operation","index":0,"n_rows":74,"n_cols":38,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Les Operations",null,null,null,null,null,"الرقم","الاسم","العنوان","الهاتف1","الهاتف2","أقصى دين","الرصيد",null,"الرقم","الاسم","العنوان","الهاتف1","الهاتف2","أقصى دين","الرصيد",null,null,null,"رقم الفاتورة","الاسم","المشروع","طريقة الإتفاقية","نسبة الإتفاقية","نوع المشروع"]
[null,"الزبون","مج.  الزابون groupe ",null,"الممول",null,"المصاريف",null,"الحرفي",null,"العمال",null,"N°","Nom","Adresse","Tel1","Tel2","Max credit","Solde",null,"N°","Nom","Adresse","Tel1","Tel2","Max credit","Solde",null,null,"Assemble","N° Facture","N° Pojet","Nom","Adresse","Type Contrat","%Contrat","Type Projet"]
["ARB","Clients","Grp. Operation",null,"Fourniceur",null,"Frais",null,"Soutraitan",null,"Travailleur",null,1,"الحاج عشور بانوح","باردو","0555-19-28-68","0663-58-70-99",null,null,null,1,"مورد مختلف",null,null,null,null,null,null,null,"حاجي الهاشمي_P1_Tout",1,"P1","حاجي الهاشمي","Centre ville","FP",null,"Tout"]
["دفعات","versements","GR1",null,"Achats",null,"Ecart",null,"Travaux Aluminium",null,"مجاهد مصطفى",null,2,"الشيخ بالحاج مصطفى","الشيخ بالحاج",null,null,null,null,null,2,"باللو عبد الرحمان","حديد","القرارة","0662-44-33-53","0560-32-16-24",null,null,null,"حاجي الهاشمي_P2_Structure",{"$f":"AE3+1","v":2},"P2","حاجي الهاشمي","Bardou","%",0.125,"Structure"]
["بلوك","Bloc","GR1",null,"Avoir",null,"Frais Divers",null,"soudeur ",null,"صياغ محمد",null,1,"الحاج عشور بانوح","باردو","0555-19-28-68","0663-58-70-99",null,null,null,3,"كريزو إبراهيم","مواد البناء","القرارة","0696-04-06-03 جمال","0657-06-13-06 عمر",null,null,null,"جهلان أحمد_P3_Divers",{"$f":"AE4+1","v":3},"P3","جهلان أحمد","LAAMIED لعميد","FP",null,"Divers"]
["ايصال كهرباء","Branchement Electricité","GR6",null,null,null,"transport Dim bire",null,"Mandeuvre pinter",null,"حميد أوجانه جمال",null,2,"الشيخ بالحاج مصطفى","الشيخ بالحاج",null,null,null,null,null,4,"طالب عيسى","كريار","القرارة","0662-88-79-32 عيسى","0551-88-95-45",null,null,null,"حاجي يوسف بن مصطفى_P4_BrIcole",4,"P4","حاجي يوسف بن مصطفى","القرية","FP",null,"BrIcole"]
["ايصال الغاز","Branchement GAZE","GR2",null,null,null,"Bereau المكتب",null,"Montage climatiseur",null,null,null,3,"بيوض عمارة","القرارة",null,null,null,null,null,5,"سليمان محمد","كنكاري","القرارة","029-26-23-83","0699-60-85-76 محمد",null,null,null,"الحاج عشور بانوح_P5_Finition",5,"P5","الحاج عشور بانوح","Centre ville","%",0.125,"Finition"]
["ايصال الماء","Branchement L'eau","GR2",null,null,null,"Investissement إستثمار",null,"كرلور أحمد Carleur  ",null,null,null,4,"جهلان أحمد","الشيخ بالحاج",null,null,null,null,null,6,"نجار يحي","رخام","القرارة","0552-20-94-06",null,null,null,null,"حاجي الهاشمي_P6_BrIcole",6,"P6","حاجي الهاشمي","Centre ville","%",0.125,"BrIcole"]
["بريكول","Bricole divers","GR3",null,null,null,"Reparation hirbil",null,"ماصو أحمد Macon",null,null,null,5,"حاجي الحاج","القرارة",null,null,null,null,null,7,"حفار مصطفى","فايونص","القرارة","0662-51-41-20",null,null,null,null,"حاجي الهاشمي_p6_BrIcole",7,"p6","حاجي الهاشمي","Centre ville","%",0.125,"BrIcole"]
["بريك","Brique","GR4",null,null,null,"Carbure إسونس",null,"كرلور ابراهم Carleur",null,null,null,6,"حاجي الهاشمي","القرارة",null,null,null,null,null,8,"نجار تامجرت صالح رومبوس","نجارة","القرارة","0549-64-59-17"]
["كارلور","Carreleur","GR6",null,null,null,null,null,null,null,null,null,7,"حاجي يوسف بن مصطفى",null,null,null,null,null,null,9,"حميد أوجانه زواري","كهرباء عامة","القرارة","0555-14-81-59 عمر","029-26-14-07"]
["سيمون","Cimon","GR5",null,null,null,null,null,null,null,null,null,8,"حاجي نورالدين","القرارة",null,null,null,null,null,10,"دبيلي إبراهيم","رخام","القرارة","0659-61-82-52 "]
["سيمون كول","Cimon colle","GR6",null,null,null,null,null,null,null,null,null,9,"حفار محمد","بوقرطاس",null,null,null,null,null,11,"نجار الناصر الحاج","نجارة","القرارة","0552-20-94-06"]
["سانتورة راقدة","Cinture Dorme","GR1",null,null,null,null,null,null,null,null,null,10,"كروم حمو","القرارة",null,null,null,null,null,12,"عبداللاوي بشير بلاطر","بلاطر","القرارة","0698-56-67-07"]
["بنيان بريك","Construction Brique","GR6",null,null,null,null,null,null,null,null,null,11,"مشترك","مدرسة طاهر شوشان",null,null,null,null,null,13,"آدار اينورار","بلومبي","القرارة","0553-00-77-65 ويرو",null,null,null,null,null,null,null,"حاجي يوسف بن مصطفى",null,{"$f":"VLOOKUP(AG15,AE3:AL9,2,FALSE)","v":{"$error":"#N/A"}}]
["بنيان قالب بلان","Construction Moule plain","GR6",null,null,null,null,null,null,null,null,null,12,"جديد1",null,null,null,null,null,null,14]
["بنيان حجرة","Construction Piere","GR6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["كهربائي","Electricien","GR4",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,1,"P1","حاجي الهاشمي","Centre ville","FP",null,"Tout",{"$f":"AG18&\"_\"&AF18&\"_\"&AK18","v":"حاجي الهاشمي_P1_Tout"}]
["دروج","Escalier","GR5",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,{"$f":"AE18+1","v":2},"P2","حاجي الهاشمي","Bardou","%",0.125,"Structure","حاجي الهاشمي_P2_Structure"]
["فايونص","Faïence","GR6",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,{"$f":"AE19+1","v":3},"P3","جهلان أحمد","LAAMIED لعميد","FP",null,"Divers","جهلان أحمد_P3_Divers"]
["بيفيسي","Faux Plafond PVC","GR6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"كريزو إبراهيم",null,{"$f":"VLOOKUP(T21,U3:Z8,1,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,4,"P4","حاجي يوسف بن مصطفى","القرية","FP",null,"BrIcole","حاجي يوسف بن مصطفى_P4_BrIcole"]
["حديد","Fère","GR2",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,5,"P5","الحاج عشور بانوح","Centre ville","%",0.125,"Finition","الحاج عشور بانوح_P5_Finition"]
["فيش بوطو","Fiche Poteaux","GR1",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,6,"P6","حاجي الهاشمي","Centre ville","%",0.125,"BrIcole","حاجي الهاشمي_P6_BrIcole"]
["حفر","Forage","GR1",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,7,"p6","حاجي الهاشمي","Centre ville","%",0.125,"BrIcole","حاجي الهاشمي_p6_BrIcole"]
["قرانيتو","Granito","GR1"]
["قرافي","Gravis","GR6"]
["تحراش ","Harcèlement","GR2"]
["لفابو","lavabo","GR2"]
["سينسمو","la Cenis sement","GR3"]
["ادخال السلعة","L'entree de produit","GR4"]
["دامبير","les boule marbre escalier","GR6"]
["بومب ضالة","Location pompe pour sol","GR5"]
["قالب","Macon","GR6"]
["ماربر","Marbre","GR1"]
["سلع, بانتور","Produit Peinture","GR6"]
["رخام","Marbre","GR6"]
["ألمنيوم","Menuiseries Aluminium","GR6"]
["نجار","Menuiseries Bois","GR4"]
["تركيب كوادر","Montage carreleur","GR5"]
["تركاب كادر","Montage des cadre","GR6"]
["تركاب أنبوسط","Montage Imposte","GR6"]
["بلاك شوفونت","Montage plaque chauffante","GR2"]
["تركاب بورطاي","Montage Portail","GR1"]
["تركاب باب","Montage Porte","GR6"]
["تركاب ريزين","Montage Rizine escalier","GR2"]
["قالب بلان","Moule Plain","GR2"]
["نيتواياج","Nettoyage","GR3"]
["بانتر ","Peintre","GR4"]
["بانتور بوا","Peinture chambre","GR6"]
["سلعة بانتورة","Peinture du Portes","GR5"]
["بنتر فينال","peinture final","GR6"]
["حجرة","Pier","GR1"]
["لابلانت","Plainte","GR6"]
["بلاط فورم ","Plate Forme","GR6"]
["بلاطري","plâtrerie","GR6"]
["بلومبي","Plomberie","GR4"]
["بوطو","Poteaux","GR5"]
["سلعة سينسمو","produit de Cenis sèment","GR6"]
["سلعة كهربائي","Produit d'électricité","GR6"]
["سلعة بلاطر","produit Plâtre","GR2"]
["سلعة بلومبي","produit Plomberie","GR1"]
["سلعة كانكاري","Produit Quinqueillrie","GR6"]
["تراب","Sable","GR1"]
["اخراج الردم","Sortie de remplissage","GR6"]
["حداد","soudeur","GR6"]
["سومال","Soumel","GR6"]
["تيف","TIFE","GR4"]
["نقل","Transport","GR5"]
["مونوفري","Travailleur","GR6"]
["خدمات مختلفة","Travaux Divers","GR6"]
["زجاج","Verre","GR2"]
[]
[]
[null,null,"O"]

{"sheet":"Formulaire","index":1,"n_rows":29,"n_cols":26,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"تم تعديل تطبيق المعادله ",null,null,"Programe Gestionaire Des projets"]
[]
[null,null,null,null,null,null,{"$f":"COUNTA(OFFSET('Liste Operation'!$AH$2,MATCH(Formulaire!D6,'Liste Operation'!$AG$3:$AH$9,0),,COUNTIF('Liste Operation'!$AH$3:$AH$9,Formulaire!D6),1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"حاجي ",null,null,{"$f":"VLOOKUP(U3,V6:AE11,2,FALSE)","v":"Centre ville"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(Detailoperation[N° Enr.])","v":1}]
[null,null,"حاجي الهاشمي_P6_BrIcole",{"$f":"VLOOKUP(C6,Table4[#All],4,0)","v":"حاجي الهاشمي"},null,null,"Adresse",{"$f":"VLOOKUP(C6,Table4[#All],5,0)","v":"Centre ville"},null,"Type Contrat",{"$f":"VLOOKUP(C6,Table4[#All],6,0)","v":"%"},null,"Type Projet",{"$f":"VLOOKUP(C6,Table4[#All],8,0)","v":"BrIcole"},null,"الرصيد النظري",{"$f":"Conclusion!B5","v":15000},null,{"$f":"V6&\"_\"&U6&\"_\"&Z6","v":"أحمد_P3_Divers"},{"$f":"T5+1","v":1},"P3","أحمد","LAAMIED لعميد","FP",null,"Divers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الخزانة Caisse",{"$f":"Conclusion!B6","v":15000},null,"حاجي يوسف_P4_BrIcole",2,"P4","حاجي يوسف","القرية","FP",null,"BrIcole"]
[null,null,"DATE","2021-10-02",null,null,"N° Projet",{"$f":"VLOOKUP(C6,Table4[#All],3,0)","v":"P6"},null,"%Contrat",{"$f":"VLOOKUP(C6,Table4[#All],7,0)","v":0.125},null,"N° FACTURE",{"$f":"VLOOKUP(C6,Table4[#All],2,0)","v":6},null,null,null,null," بانوح_P5_Finition",3,"P5"," بانوح","Centre ville","%",0.125,"Finition"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حاجي _P6_BrIcole",4,"P6","حاجي ","Centre ville","%",0.125,"BrIcole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حاجي _p6_BrIcole",5,"p6","حاجي ","Centre ville","%",0.125,"BrIcole"]
[null,null,null,null,null,null,null,null,null,"Reglements",null,null,null,null,null,null,null,null,"_P8_",6,"P8"]
[null,null,"Clients-Fourniceur",null,null,null,"Emploi- Frais-Soutreton"]
[]
[]
[null,1,"Type Operation","Clients",null,6,"Longueur"]
[]
[null,2,"Operation/ Nom","Branchement Electricité",null,7,"Largeur"]
[null,null,null,{"$f":"IF(D15=\"fourniceur\",\"Detail_Clients\",\"\")","v":""}]
[null,3,"Fourniceur","كريزو إبراهيم",null,8,"Jour de Travail"]
[]
[null,4,"Mantont",25000,null,9,"M²",{"$f":"+H15*H17","v":0}]
[]
[null,5,"Observation",null,null,10,"ML"]
[]
[null,null,"Fourniture et Pose",30000,null,11,"Prix",75]
[]
[null,null,null,null,null,null,"Valeur",{"$f":"H25*H21","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"الحقوق محفوظة HABA"]

{"sheet":"Detail Operation","index":2,"n_rows":8,"n_cols":58,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,{"$f":"SUM('Detail Operation'!AC6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,AA8:AA1101)","v":0},{"$f":"SUBTOTAL(109,AB8:AB1101)","v":15000}]
["الرقم","التاريخ","إسم الزابون","العنوان","رقم المشروع","رقم الفاتورة","نوع الإتفاقية","نسبة الإتفاقية","نوع المشروع","نوع العملية","العملية","إسم الممول","الحرفي","العمال","الطول","العرض","أيام العمل","متر مربع-أيام","متر طولي","السعر","المبلغ","نسبة الزابون","مبلغ F/P","المجموع","الدفعه","خالص","الدفعات","السحوبات","ملاحظات"]
["N° Enr.","DATE","Clients","Adresse","N° PROJET","N° Facture","Type Contrat","%Contrat","Type Projet","Type operation","Operation","Fournisseur","sou triton","Travaeullre","Longueur","Largeur","N. JOUR","M²","ML","Prix","Valeur","% Client","Mantont F/P","Mt.TOTAL","VERSEMENTS","Régler","Crédit","Début","Observation",null,null,null,null,null,null,null,1,"12/012021","الشيخ بالحاج مصطفى","Bardou","p1","Clients","versements",null,12,14,15,null,null,75,1125,0.05,1181.25,15000,"x","",16181.25,"qsdqsfqsf"]
[{"$f":"1+A9","v":1},"12/012021","الشيخ بالحاج مصطفى","Bardou","p1",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Branchement Electricité",null,"دبيلي إبراهيم","كرلور أحمد Carleur  ","مجاهد مصطفى",0,0,0,{"$f":"Detailoperation[[#This Row],[Largeur]]*Detailoperation[[#This Row],[Longueur]]","v":0},null,75,{"$f":"IF(Detailoperation[[#This Row],[N. JOUR]]>0,Detailoperation[[#This Row],[N. JOUR]]*Detailoperation[[#This Row],[Prix]],IF(Detailoperation[[#This Row],[M²]]>0,Detailoperation[[#This Row],[M²]]*Detailoperation[[#This Row],[Prix]],Detailoperation[[#This Row],[ML]]*Detailoperation[[#This Row],[Prix]]))","v":0},0.05,null,{"$f":"IF(Detailoperation[[#This Row],[% Client]]>0,Detailoperation[[#This Row],[Valeur]]*Detailoperation[[#This Row],[% Client]]+Detailoperation[[#This Row],[Valeur]],Detailoperation[[#This Row],[Valeur]])","v":0},15000,"x",{"$f":"IF(OR(Detailoperation[[#This Row],[Operation]]=\"avoir\",Detailoperation[[#This Row],[Operation]]=\"versements\"),Detailoperation[[#This Row],[VERSEMENTS]],\"\")","v":""},{"$f":"IF(OR(Detailoperation[[#This Row],[Operation]]=\"avoir\",Detailoperation[[#This Row],[Operation]]=\"versements\"),\"\",Detailoperation[[#This Row],[Mantont F/P]]+Detailoperation[[#This Row],[VERSEMENTS]]+Detailoperation[[#This Row],[Mt.TOTAL]])","v":15000},"qsdqsfqsf"]

{"sheet":"Conclusion","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Operation","MONTAN"]
["الدفعات",{"$f":"SUM(Detailoperation[Début])","v":15000}]
["المبلغ السالك",{"$f":"SUMIF(Detailoperation[Régler],\"√\",Detailoperation[Crédit])","v":0}]
["المبلغ الغير سالك",{"$f":"SUMIF(Detailoperation[Régler],\"x\",Detailoperation[Crédit])","v":0}]
["الرصيد النظري",{"$f":"B6-B4","v":15000}]
["الخزانة Caisse",{"$f":"B2-B3","v":15000}]

{"sheet":"Edition","index":4,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[37,1,37,2],[5,0,5,3],[32,0,32,2],[33,0,33,2],[34,0,34,2]]}
[null,null,"M.M Entrepreneur"]
["Date:",44467]
["Clients:","Hadji Rachid"]
[null,"Chantier Guerrara"]
[]
["Finition Final"]
[]
["Quantité","Détail","prix","Total"]
[1,"Travaux Aluminium",173500,{"$f":"+C9*A9","v":173500}]
[1,"Pinter bricole garage chambre cave)",23140,{"$f":"+C10*A10","v":23140}]
[1,"Peinture chambre",18000,18000]
[1,"Montage plaque chauffante",5000,5000]
[1,"Bricole porte tirasse",1500,1500]
[1,"soudeur porte couloire et gréage",33000,33000]
[1,"Montage Rizine escalier",15000,15000]
[1,"Branchement GAZE",16345,16345]
[1,"Branchement L'eau",45000,45000]
[1,"verre",{"$f":"20300+4000+650","v":24950},24950]
[1,"Mandeuvre pinter",292770,292770]
[1,"peinture final",102500,102500]
[1,"Marbre",{"$f":"3500+11000+94091","v":108591},108591]
[1,"transport Dim bire",{"$f":"7500+2400+2000","v":11900},11900]
[1,"Marchandise Peinture",166660,166660]
[1,"Cimon",1320,1320]
[1,"Cimon colle",530,530]
[1,"l lavabo",8800,8800]
[1,"Faux Plafond PVC",6500,6500]
[1,"Montage climatiseur",60000,60000]
[1,"les boule marbre escalier",1600,1600]
[1,"Macon",92500,92500]
[1,"Menuiserie (Placard Baguette Etagère)",{"$f":"75000+1500+10000+29640","v":116140},116140]
[1,"Peinture du Portes",145000,145000]
["TOTAL",null,null,{"$f":"SUM(D9:D32)","v":1470246}]
["% DE TRAVAIL",null,null,{"$f":"+D33*12.5%","v":183780.75}]
["TOTAL GLOBAL",null,null,{"$f":"SUM(D33:D34)","v":1654026.75}]
[]
["Avance"]
["Date","Détail",null,"Total"]
[44257,"Rachid MUSTAFA ",null,200000]
[44292,"Rachid MUSTAFA (CPH)",null,200000]
[null,"Reste du ben aoumeur Verre",null,185000]
[null,null,null,{"$f":"SUM(D39:D41)","v":585000}]
[]
[]
[44467,"Solde Final",null,{"$f":"D35-D42","v":1069026.75}]

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