{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","الفرق"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,9,21,17],[9,10,17,11],[19,18,20,18],[19,19,20,19],[19,2,20,2],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[19,8,20,8],[4,1,4,5],[5,1,5,5],[6,1,6,5],[9,1,9,5],[19,9,19,17],[16,1,16,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[21,2,23,2],[19,1,20,1],[19,3,20,3],[21,3,23,3],[1,1,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,11],[3,1,3,5],[48,2,50,2],[48,3,50,3],[33,2,35,2],[33,3,35,3],[36,2,38,2],[36,3,38,3],[39,2,41,2],[39,3,41,3],[8,1,8,5],[8,10,8,11],[42,2,44,2],[42,3,44,3],[45,2,47,2],[45,3,47,3],[24,2,26,2],[24,3,26,3],[27,2,29,2],[27,3,29,3],[30,2,32,2],[30,3,32,3],[10,1,10,5],[11,1,11,5],[17,1,17,5],[15,1,15,5]]}
[]
[null,"المبلغ المحصل من العقار",null,null,{"$f":"SUM(H22:H51)","v":0},null,"الـــــــــــشـــــــــــهــــــــــــــــــــــــــــــــــــر "]
[]
[null,"المبلغ المطلوب من ( ملاك ــــــــــ سكان ) العقار شهرياً",null,null,null,null,"المبلغ المطلوب"]
[null,"المبلغ المطلوب من كل شقة بالادوار التى بها اسانسير",null,null,null,null,400]
[null,"المبلغ المطلوب من كل شقة بالادوار التى لايوجد بها اسانسير",null,null,null,null,300]
[null,"المبلغ المطلوب من الشقق المقفولة ولايوجد بها سكان",null,null,null,null,50]
[]
[null,"الخدمـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــات واعمــــــــــــــــــــــــــــال الصيانة الشهرية",null,null,null,null,"المبلغ المطلوب","المبلغ المدفوع مقدماً","المبلغ المتبقى للخدمات","اجمالى المدفوع ","المبلغ المتبقى بالصندوق"]
[null,"راتب حارس العقار",null,null,null,null,1500,1000,{"$f":"G10-H10","v":500},{"$f":"G10-I10","v":1000},{"$f":"SUM((E2)-J10:J18)","v":-1000}]
[null,"مبلغ صيانة الاسانسير ( اجر عامل ــــــــــ لوازم اعمال الصيانة )",null,null,null,null,null,null,{"$f":"G11-H11","v":0},0]
[null,"مبلغ صيانة المياه ( اجر عامل ـــــــــ مواتير ـــــــــ مواسير ــــــــــ لوازم اعمال الصيانة )",null,null,null,null,null,null,0,0]
[null,"مبلغ صيانة الكهرباء ( اجر عامل ـــــــــ لوازم اعمال الصيانة )",null,null,null,null,null,null,0,0]
[null,"مبلغ اعمال صيانة اخرى",null,null,null,null,null,null,0,0]
[null,"مبلغ المياه التجارى",null,null,null,null,null,null,0,0]
[null,"مبلغ الكهرباء التجارى",null,null,null,null,null,null,0,0]
[null,"مبلغ خامات نظافة ( شهرى )",null,null,null,null,null,null,0,0]
[null,"مبلغ نظير خدمات اخرى",null,null,null,null,null,null,0,{"$f":"G18-I18","v":0}]
[]
[null,"نوع السكن","الدور","اسانسير","رقم الشقه","اسم صاحب الشقه","رقم الهاتف","المبلغ المحصل","المبلغ المتبقي ","توزيع المبلغ الشهري على الخدمات",null,null,null,null,null,null,null,null,"اجمالى المصروفات","المتبقي بالصندوق"]
[null,null,null,null,null,null,null,null,null,"اجر حارس العقار","كهرباء","مياه","صيانة اسانسير","صيانة كهرباء","صيانة مياه","اعمال صيانة اخري","خامات نظافة","مصروفات اخري"]
[null,"ساكن","الاول","لايوجد اسانسير",1,null,null,null,null,"مطلوب معادلة لمعرفة النسبة من الاجر الاساسي من الخدمات واعمال الصيانة على كل شقة ماعدا الشقق الغير ساكنة"]
[null,"ساكن",null,null,2]
[null,"ساكن",null,null,3]
[null,"ساكن","الثانى","يوجد اسانسير",4]
[null,"ساكن",null,null,5]
[null,"ساكن",null,null,6]
[null,"ساكن","الثالث","يوجد اسانسير",7]
[null,"ساكن",null,null,8]
[null,"ساكن",null,null,9]
[null,"ساكن","الرابع","يوجد اسانسير",10]
[null,"ساكن",null,null,11]
[null,"ساكن",null,null,12]
[null,"ساكن","الخامس","يوجد اسانسير",13]
[null,"غير ساكن",null,null,14]
[null,"ساكن",null,null,15]
[null,"ساكن","السادس","يوجد اسانسير",16]
[null,"ساكن",null,null,17]
[null,"ساكن",null,null,18]
[null,"ساكن","السابع","يوجد اسانسير",19]
[null,"ساكن",null,null,20]
[null,"غير ساكن",null,null,21]
[null,"ساكن","الثامن","يوجد اسانسير",22]
[null,"ساكن",null,null,23]
[null,"ساكن",null,null,24]
[null,"ساكن","التاسع","يوجد اسانسير",25]
[null,"ساكن",null,null,26]
[null,"ساكن",null,null,27]
[null,"ساكن","العاشر","يوجد اسانسير",28]
[null,"ساكن",null,null,29]
[null,"ساكن",null,null,30]

{"sheet":"الفرق","index":1,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":true,"merged":[[41,1,41,6],[24,8,24,11],[40,8,40,11],[41,8,41,12],[43,8,43,11],[32,8,32,11],[33,8,33,12],[33,1,33,6],[1,8,1,12],[1,1,1,6],[3,8,3,12],[3,1,3,6],[25,8,25,12],[25,1,25,6]]}
[]
[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,{"$f":"ROW()-4","v":1},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D5<=70,#REF!*70,IF(D5<=70,#REF!*70,D5*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D5<100,0,MROUND(D5*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$f":"E5-F5","v":{"$error":"#REF!"}},null,{"$f":"ROW()-4","v":1},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$20","v":14960},{"$f":"'[1]اجمالى افراد شمال'!$N$20","v":720},{"$f":"K5-L5","v":14240},null,{"$f":"G5-M5","v":{"$error":"#REF!"}}]
[null,{"$f":"ROW()-4","v":2},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D6<=70,#REF!*70,IF(D6<=70,#REF!*70,D6*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D6<100,0,MROUND(D6*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$f":"E6-F6","v":{"$error":"#REF!"}},null,{"$f":"ROW()-4","v":2},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$15","v":11680},{"$f":"'[1]اجمالى افراد شمال'!$N$15","v":735},{"$f":"K6-L6","v":10945},null,{"$f":"G6-M6","v":{"$error":"#REF!"}}]
[null,3,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D7<=70,#REF!*70,IF(D7<=70,#REF!*70,D7*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D7<100,0,MROUND(D7*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,3,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$19","v":3150},{"$f":"'[1]اجمالى افراد شمال'!$N$19","v":200},2950,null,{"$error":"#REF!"}]
[null,4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D8<=70,#REF!*70,IF(D8<=70,#REF!*70,D8*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D8<100,0,MROUND(D8*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$16","v":5425},{"$f":"'[1]اجمالى افراد شمال'!$N$16","v":300},5125,null,{"$error":"#REF!"}]
[null,5,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D9<=70,#REF!*70,IF(D9<=70,#REF!*70,D9*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D9<100,0,MROUND(D9*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,5,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$21","v":20125},{"$f":"'[1]اجمالى افراد شمال'!$N$21","v":1200},18925,null,{"$error":"#REF!"}]
[null,6,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D10<=70,#REF!*70,IF(D10<=70,#REF!*70,D10*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D10<100,0,MROUND(D10*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,6,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$17","v":3515},{"$f":"'[1]اجمالى افراد شمال'!$N$17","v":160},3355,null,{"$error":"#REF!"}]
[null,7,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,MROUND(((#REF!+#REF!)*50)/(#REF!+#REF!),5)))","v":{"$error":"#REF!"}},{"$f":"IF(D11<=70,#REF!*70,IF(D11<=70,#REF!*70,D11*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D11<100,0,MROUND(D11*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,7,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$18","v":6300},{"$f":"'[1]اجمالى افراد شمال'!$N$18","v":330},5970,null,{"$error":"#REF!"}]
[null,8,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,MROUND((#REF!+#REF!)*50/(#REF!+#REF!),5)))","v":{"$error":"#REF!"}},{"$f":"IF(D12<=70,#REF!*70,IF(D12<=70,#REF!*70,D12*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D12<100,0,MROUND(D12*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,8,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$22","v":1200},{"$f":"'[1]اجمالى افراد شمال'!$N$22","v":0},1200,null,{"$error":"#REF!"}]
[null,9,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D13*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D13/#REF!)<100,0,الفرق!D13*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,9,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$13","v":14800},{"$f":"'[1]اجمالى افراد شمال'!$N$13","v":0},14800,null,{"$error":"#REF!"}]
[null,10,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D14*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D14/#REF!)<100,0,الفرق!D14*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,10,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$14","v":12000},{"$f":"'[1]اجمالى افراد شمال'!$N$14","v":0},12000,null,{"$error":"#REF!"}]
[null,11,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D15*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D15/#REF!)<100,0,الفرق!D15*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,11,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$23","v":6000},{"$f":"'[1]اجمالى افراد شمال'!$N$23","v":0},6000,null,{"$error":"#REF!"}]
[null,12,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D16*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D16/#REF!)<100,0,الفرق!D16*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,12,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$24","v":1800},{"$f":"'[1]اجمالى افراد شمال'!$N$24","v":0},1800,null,{"$error":"#REF!"}]
[null,13,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D17*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D17/#REF!)<100,0,الفرق!D17*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,13,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$28","v":1700},{"$f":"'[1]اجمالى افراد شمال'!$N$28","v":0},1700,null,{"$error":"#REF!"}]
[null,14,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D18*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D18/#REF!)<100,0,الفرق!D18*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,14,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$26","v":2900},{"$f":"'[1]اجمالى افراد شمال'!$N$26","v":0},2900,null,{"$error":"#REF!"}]
[null,15,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D19*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D19/#REF!)<100,0,الفرق!D19*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,15,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$29","v":1800},{"$f":"'[1]اجمالى افراد شمال'!$N$29","v":0},1800,null,{"$error":"#REF!"}]
[null,16,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D20*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D20/#REF!)<100,0,الفرق!D20*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,16,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$27","v":2900},{"$f":"'[1]اجمالى افراد شمال'!$N$27","v":0},2900,null,{"$error":"#REF!"}]
[null,17,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D21*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D21/#REF!)<100,0,الفرق!D21*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,17,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$25","v":500},{"$f":"'[1]اجمالى افراد شمال'!$N$25","v":0},500,null,{"$error":"#REF!"}]
[null,18,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D22*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D22/#REF!)<100,0,الفرق!D22*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,18,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$30","v":4000},{"$f":"'[1]اجمالى افراد شمال'!$N$30","v":0},{"$f":"K22-L22","v":4000},null,{"$error":"#REF!"}]
[null,19,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5)))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D23*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF((D23/#REF!)<100,0,الفرق!D23*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,19,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$31","v":3700},{"$f":"'[1]اجمالى افراد شمال'!$N$31","v":0},{"$f":"K23-L23","v":3700},null,{"$error":"#REF!"}]
[null,20,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"D24","v":{"$error":"#REF!"}},{"$f":"IF((D24/#REF!)<100,0,الفرق!D24*10%)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,20,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[1]اجمالى افراد شمال'!$B$32","v":6600},{"$f":"'[1]اجمالى افراد شمال'!$N$32","v":0},6600,null,{"$error":"#REF!"}]
[null,"الاجمـــــــــــــــــــــــــــــــــــــــالى",null,{"$f":"SUM(D5:D24)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(G5:G24)","v":{"$error":"#REF!"}},null,"الاجمـــــــــــــــــــــــــــــــــــــــالى",null,null,null,{"$f":"SUM(M5:M24)","v":121410},null,{"$f":"SUM(O5:O24)","v":{"$error":"#REF!"}}]
[null,"قطاع الــــــــغـــــــرب",null,null,null,null,null,null,"قطاع الــــــــغـــــــرب",null,null,null,null,null,"قطاع الغرب"]
[null,1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D27<=70,#REF!*70,IF(D27<=70,#REF!*70,D27*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D27<100,0,MROUND(D27*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$f":"E27-F27","v":{"$error":"#REF!"}},null,1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[2]اجمالى افراد الغرب'!$B$13","v":8540},{"$f":"'[2]اجمالى افراد الغرب'!$S$13","v":0},{"$f":"K27-L27","v":8540},null,{"$f":"G27-M27","v":{"$error":"#REF!"}}]
[null,2,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D28<=70,#REF!*70,IF(D28<=70,#REF!*70,D28*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D28<100,0,MROUND(D28*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$f":"E28-F28","v":{"$error":"#REF!"}},null,2,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[2]اجمالى افراد الغرب'!$B$14","v":2700},{"$f":"'[2]اجمالى افراد الغرب'!$S$14","v":0},2700,null,{"$f":"G28-M28","v":{"$error":"#REF!"}}]
[null,3,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D29<=70,#REF!*70,IF(D29<=70,#REF!*70,D29*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D29<100,0,MROUND(D29*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,3,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[2]اجمالى افراد الغرب'!$B$17","v":4875},{"$f":"'[2]اجمالى افراد الغرب'!$S$17","v":0},4875,null,{"$error":"#REF!"}]
[null,4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D30<=70,#REF!*70,IF(D30<=70,#REF!*70,D30*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D30<100,0,MROUND(D30*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[2]اجمالى افراد الغرب'!$B$15","v":3700},{"$f":"'[2]اجمالى افراد الغرب'!$S$15","v":0},3700,null,{"$error":"#REF!"}]
[null,5,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D31<=70,#REF!*70,IF(D31<=70,#REF!*70,D31*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D31<100,0,MROUND(D31*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,5,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[2]اجمالى افراد الغرب'!$B$16","v":7875},{"$f":"'[2]اجمالى افراد الغرب'!$S$16","v":0},7875,null,{"$error":"#REF!"}]
[null,6,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(D32<=70,#REF!*70,IF(D32<=70,#REF!*70,D32*#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(D32<100,0,MROUND(D32*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,6,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[2]اجمالى افراد الغرب'!$B$18","v":11960},{"$f":"'[2]اجمالى افراد الغرب'!$S$18","v":0},11960,null,{"$error":"#REF!"}]
[null,"الاجمـــــــــــــــــــــــــــــــــــــــالى",null,{"$f":"SUM(D27:D32)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(G27:G32)","v":{"$error":"#REF!"}},null,"الاجمـــــــــــــــــــــــــــــــــــــــالى",null,null,null,{"$f":"SUM(M27:M32)","v":39650},null,{"$f":"SUM(O27:O32)","v":{"$error":"#REF!"}}]
[null,"قطاع اكتوبر",null,null,null,null,null,null,"قطاع اكتوبر",null,null,null,null,null,"قطاع اكتوبر"]
[null,1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D35*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(D35<100,0,MROUND(D35*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$f":"E35-F35","v":{"$error":"#REF!"}},null,1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[3]اجمالى افراد اكتوبر'!$B$13","v":18000},{"$f":"'[3]اجمالى افراد اكتوبر'!$S$13","v":0},{"$f":"K35-L35","v":18000},null,{"$f":"G35-M35","v":{"$error":"#REF!"}}]
[null,2,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D36*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(D36<100,0,MROUND(D36*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$f":"E36-F36","v":{"$error":"#REF!"}},null,2,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[3]اجمالى افراد اكتوبر'!$B$14","v":4900},{"$f":"'[3]اجمالى افراد اكتوبر'!$S$14","v":0},4900,null,{"$f":"G36-M36","v":{"$error":"#REF!"}}]
[null,3,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D37*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(D37<100,0,MROUND(D37*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,3,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[3]اجمالى افراد اكتوبر'!$B$16","v":4700},0,4700,null,{"$f":"M37","v":4700}]
[null,4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D38*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(D38<100,0,MROUND(D38*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[3]اجمالى افراد اكتوبر'!$B$17","v":15000},{"$f":"'[3]اجمالى افراد اكتوبر'!$S$17","v":0},15000,null,{"$error":"#REF!"}]
[null,5,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[3]اجهزة معاونه اكتوبر'!$S$232","v":0},{"$error":"#REF!"},null,5,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[3]اجمالى افراد اكتوبر'!$B$19","v":248900},{"$f":"'[3]اجمالى افراد اكتوبر'!$S$19","v":35838},213062,null,{"$error":"#REF!"}]
[null,6,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"D40","v":{"$error":"#REF!"}},0,{"$f":"D40-F40","v":{"$error":"#REF!"}},null,6,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[3]اجمالى افراد اكتوبر'!$B$18","v":1150},{"$f":"'[3]اجمالى افراد اكتوبر'!$S$18","v":0},1150,null,{"$error":"#REF!"}]
[null,"الاجمـــــــــــــــــــــــــــــــــــــــالى",null,{"$f":"SUM(D35:D40)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(G35:G40)","v":{"$error":"#REF!"}},null,"الاجمـــــــــــــــــــــــــــــــــــــــالى",null,null,null,{"$f":"SUM(M35:M40)","v":256812},null,{"$f":"SUM(O35:O40)","v":{"$error":"#REF!"}}]
[null,"قطاع الطرق الجنوبية",null,null,null,null,null,null,"قطاع الطرق الجنوبية",null,null,null,null,null,"قطاع الطرق"]
[null,1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,70,IF(#REF!=0,#REF!*70,IF((#REF!*50/#REF!)<70,70,MROUND(#REF!*50/#REF!,5))))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,#REF!*70,D43*#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(D43<100,0,MROUND(D43*10%,5)*#REF!)","v":{"$error":"#REF!"}},{"$f":"E43-F43","v":{"$error":"#REF!"}},null,1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'[4]ضباط الطرق'!$B$134","v":16800},{"$f":"'[4]ضباط الطرق'!$N$134","v":190},{"$f":"K43-L43","v":16610},null,{"$f":"G43-M43","v":{"$error":"#REF!"}}]
[null,"اجمالى نهــــــــــــــــــــائى",null,{"$f":"D25+D33+D41+D43","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"G25+G33+G41+G43","v":{"$error":"#REF!"}},null,"اجمالى نهــــــــــــــــــــائى",null,null,null,{"$f":"M25+M33+M41+M43","v":434482},null,{"$f":"O25+O33+O41+O43","v":{"$error":"#REF!"}}]