{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["قاعدة البيانات","الخلاصة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"قاعدة البيانات","index":0,"n_rows":568,"n_cols":6,"rows_kept":568,"cut":false,"hidden":false,"merged":[]}
[]
["رقم الطلبية","التسلسل2","اسم الزبونة","دولار","يمني","المبلغ المدفوع"]
[100,1,"المقطري",5.33,{"$f":"D3*555","v":2958.15},20000]
[100,null,"المقطري",10.93,{"$f":"D4*555","v":6066.15}]
[100,null,"المقطري",1.07,593.85]
[100,null,"المقطري",12.53,6954.15]
[100,null,"المقطري",6.13,3402.15]
[100,null,"المقطري",6.93,3846.1499999999996]
[100,null,"المقطري",11.73,6510.1500000000005]
[100,null,"المقطري",7.73,4290.1500000000005]
[100,null,"المقطري",6.93,3846.1499999999996]
[100,null,"المقطري",10.39,5766.4500000000007]
[100,null,"المقطري",6.66,3696.3]
[100,null,"المقطري",5.86,3252.3]
[100,2,"صفية",10.66,5916.3,51700]
[100,null,"صفية",1.33,738.15000000000009]
[100,null,"صفية",1.6,888]
[100,null,"صفية",10.39,5766.4500000000007]
[100,null,"صفية",{"$f":"3.2*2","v":6.4},3552]
[100,null,"صفية",{"$f":"8*2","v":16},8880]
[100,null,"صفية",8.26,4584.3]
[100,null,"صفية",3.73,2070.15]
[100,null,"صفية",6.4,3552]
[100,null,"صفية",14.12,7836.5999999999995]
[100,null,"صفية",14.39,7986.4500000000007]
[100,3,"سحر",16.79,9318.4499999999989,8000]
[100,4,"عليا إبراهيم",9.33,5178.1499999999996,0]
[100,null,"عليا إبراهيم",15.19,8430.4499999999989]
[100,null,"عليا إبراهيم",10.66,5916.3]
[100,null,"عليا إبراهيم",9.59,5322.45]
[100,5,"ملكة",4,2220,52200]
[100,null,"ملكة",23.72,13164.599999999999]
[100,null,"ملكة",6.66,3696.3]
[100,null,"ملكة",5.33,2958.15]
[100,null,"ملكة",14.92,8280.6]
[100,null,"ملكة",17.32,9612.6]
[100,null,"ملكة",19.72,10944.599999999999]
[100,null,"ملكة",{"$f":"5.06*2","v":10.119999999999999},5616.5999999999995]
[100,null,"ملكة",{"$f":"8.26*2","v":16.52},9168.6]
[100,null,"ملكة",26.12,14496.6]
[100,null,"ملكة",6.13,3402.15]
[100,null,"ملكة",15.46,8580.3000000000011]
[100,6,"عبير",16.52,9168.6,0]
[100,7,"ام رودينا",5.33,2958.15,0]
[100,null,"ام رودينا",5.86,3252.3]
[100,null,"ام رودينا",4.8,2664]
[100,null,"ام رودينا",5.0599999999999996,2808.2999999999997]
[100,null,"ام رودينا",4,2220]
[100,null,"ام رودينا",10.130000000000001,5622.1500000000005]
[100,null,"ام رودينا",23.99,13314.449999999999]
[100,null,"ام رودينا",0.8,444]
[100,null,"ام رودينا",8,4440]
[100,8,"سناء",21.59,11982.45,0]
[100,null,"سناء",2.13,1182.1499999999999]
[100,null,"سناء",11.99,6654.45]
[100,null,"سناء",6.4,3552]
[100,null,"سناء",14.66,8136.3]
[100,9,"كفاية",12.53,6954.15,10000]
[100,null,"كفاية",11.19,6210.45]
[100,null,"كفاية",8.7899999999999991,4878.45]
[100,10,"ريم",11.73,6510.1500000000005,50000]
[100,null,"ريم",8.7899999999999991,4878.45]
[100,null,"ريم",11.46,6360.3]
[100,null,"ريم",11.99,6654.45]
[100,null,"ريم",21.59,11982.45]
[100,null,"ريم",17.059999999999999,9468.2999999999993]
[100,null,"ريم",17.059999999999999,9468.2999999999993]
[100,null,"ريم",6.93,{"$f":"D68*555","v":3846.1499999999996}]
[100,null,"ريم",5.33,2958.15]
[100,null,"ريم",5.6,3108]
[100,null,"ريم",4.53,2514.15]
[100,null,"ريم",19.45,10794.75]
[100,11,"هبة",8.5299999999999994,4734.1499999999996,4700]
[100,12,"عليا",1.07,593.85,0]
[100,null,"عليا",2.4,1332]
[100,null,"عليا",15.19,8430.4499999999989]
[100,13,"ملاك",1.33,738.15000000000009,2200]
[100,null,"ملاك",1.33,738.15000000000009]
[100,null,"ملاك",1.2,666]
[100,14,"شيماء",1.87,1037.8500000000001,2400]
[100,null,"شيماء",1.6,888]
[100,null,"شيماء",0.8,444]
[100,null,"ريم",5.33,2958.15]
[100,15,"غادة",6.93,3846.1499999999996,28700]
[100,null,"غادة",1.33,738.15000000000009]
[100,null,"غادة",16.79,9318.4499999999989]
[100,null,"غادة",10.130000000000001,5622.1500000000005]
[100,null,"غادة",6.13,3402.15]
[100,null,"غادة",4,2220]
[100,null,"غادة",6.4,3552]
[100,16,"اسرار",5.0599999999999996,2808.2999999999997,0]
[100,null,"اسرار",13.59,7542.45]
[100,null,"اسرار",12.26,6804.3]
[100,null,"سنا",1.2,666]
[100,null,"سنا",1.07,593.85]
[100,null,"سنا",2.67,1481.85]
[100,null,"سنا",1.87,1037.8500000000001]
[100,17,"بشرى",7.2,3996,0]
[100,null,"بشرى",6.93,3846.1499999999996]
[100,null,"بشرى",8.5299999999999994,4734.1499999999996]
[100,null,"بشرى",2.67,1481.85]
[100,null,"بشرى",2.13,1182.1499999999999]
[100,null,"بشرى",2.67,1481.85]
[100,null,"بشرى",3.2,1776]
[100,null,"بشرى",1.87,1037.8500000000001]
[100,null,"بشرى",2.4,1332]
[100,null,"بشرى",{"$f":"3.2*2","v":6.4},3552]
[100,null,"بشرى",2.13,1182.1499999999999]
[100,null,"بشرى",3.73,2070.15]
[100,null,"بشرى",3.46,1920.3]
[101,1,"هناء",5.86,3252.3,2500]
[101,null,"هناء",4.79,2658.45]
[101,2,"ولاء",7.72,4284.5999999999995,40000]
[101,null,"ولاء",5.86,3252.3]
[101,null,"ولاء",21.3,11821.5]
[101,null,"ولاء",1.33,738.15000000000009]
[101,null,"ولاء",10.39,5766.4500000000007]
[101,null,"ولاء",1.33,738.15000000000009]
[101,null,"ولاء",12.78,7092.9]
[101,null,"ولاء",15.45,8574.75]
[101,null,"ولاء",10.130000000000001,5622.1500000000005]
[101,null,"ولاء",10.39,5766.4500000000007]
[101,null,"ولاء",14.38,7980.9000000000005]
[101,null,"ولاء",12.52,6948.5999999999995]
[101,null,"ولاء",5.59,3102.45]
[101,null,"ولاء",5.33,2958.15]
[101,null,"ولاء",1.33,738.15000000000009]
[101,null,"ولاء",1.33,738.15000000000009]
[101,null,"ولاء",4.26,2364.2999999999997]
[101,3,"فنية",4.26,2364.2999999999997,0]
[101,null,"فنية",4.8,2664]
[101,null,"فنية",2.13,1182.1499999999999]
[101,4,"ايمان",1.87,1037.8500000000001,0]
[101,null,"ايمان",1.87,1037.8500000000001]
[101,5,"اسرا",1.33,738.15000000000009,0]
[101,6,"شذا",25.85,14346.75,0]
[101,null,"شذا",16.260000000000002,9024.3000000000011]
[101,null,"شذا",10.130000000000001,5622.1500000000005]
[101,null,"شذا",1.07,593.85]
[101,7,"ملاك",16.260000000000002,9024.3000000000011,5000]
[101,8,"سحر",6.13,3402.15,0]
[101,9,"ميمونة",18.64,10345.200000000001,0]
[101,10,"عبير",9.59,5322.45,0]
[101,11,"شيماء",11.73,6510.1500000000005]
[101,null,"شيماء",5.86,3252.3,5000]
[101,null,"شيماء",10.119999999999999,5616.5999999999995]
[101,12,"هديل",18.11,10051.049999999999,30000]
[101,null,"هديل",17.579999999999998,9756.9]
[101,null,"هديل",13.85,7686.75]
[101,null,"هديل",24.23,13447.65]
[101,null,"هديل",13.85,7686.75]
[101,null,"هديل",25.83,14335.65]
[101,13,"هبة",11.72,6504.6,6900]
[101,14,"فائدة",15.99,8874.4500000000007,16000]
[101,null,"فائدة",17.04,9457.1999999999989]
[101,15,"علا",26.1,14485.5,15000]
[101,null,"علا",2.4,1332]
[101,null,"علا",7.72,4284.5999999999995]
[101,null,"علا",8.7899999999999991,4878.45]
[101,null,"علا",1.86,1032.3]
[101,null,"علا",9.0500000000000007,5022.75]
[101,null,"علا",10.119999999999999,5616.5999999999995]
[101,null,"علا",15.18,8424.9]
[101,null,"علا",28.76,15961.800000000001]
[101,null,"علا",3.46,1920.3]
[101,null,"هديل",11.19,6210.45]
[101,16,"ام مارينا",2.13,1182.1499999999999,15000]
[101,null,"ام مارينا",1.86,1032.3]
[101,null,"ام مارينا",2.13,1182.1499999999999]
[101,null,"ام مارينا",1.6,888]
[101,null,"ام مارينا",1.6,888]
[101,null,"ام مارينا",1.6,888]
[101,null,"ام مارينا",8.52,4728.5999999999995]
[101,null,"ام مارينا",5.33,2958.15]
[101,null,"ام مارينا",8.7899999999999991,4878.45]
[101,null,"ام مارينا",9.59,5322.45]
[101,null,"ام مارينا",5.86,3252.3]
[101,null,"ام مارينا",3.99,2214.4500000000003]
[101,null,"ام مارينا",9.9499999999999993,5522.25]
[102,1,"ليناء",1.6,{"$f":"D180*558","v":892.80000000000007},10000]
[102,null,"ليناء",2.93,{"$f":"D181*558","v":1634.94}]
[102,null,"ليناء",10.65,5942.7]
[102,null,"ليناء",3.2,1785.6000000000001]
[102,2,"امل",9.06,5055.4800000000005,5200]
[102,3,"ملكة",19.440000000000001,10847.52,15000]
[102,null,"ملكة",15.18,8470.44]
[102,null,"ملكة",14.11,7873.38]
[102,null,"ملكة",1.86,1037.8800000000001]
[102,null,"ملكة",15.45,8621.1]
[102,4,"نبض",7.19,4012.0200000000004,5000]
[102,null,"نبض",1.6,892.80000000000007]
[102,null,"نبض",2.66,1484.28]
[102,null,"نبض",2.4,1339.2]
[102,null,"نبض",2.66,1484.28]
[102,null,"نبض",2.66,1484.28]
[102,null,"نبض",0.8,446.40000000000003]
[102,5,"أحلام عصام",5.66,3158.28,0]
[102,null,"أحلام عصام",3.46,1930.68]
[102,6,"عبير",9.59,5351.22,7868]
[102,null,"عبير",2.66,1484.28]
[102,null,"عبير",2.4,1339.2]
[102,null,"عبير",1.86,1037.8800000000001]
[102,null,"عبير",1.86,1037.8800000000001]
[102,null,"عبير",0.8,446.40000000000003]
[102,null,"عبير",1.86,1037.8800000000001]
[102,null,"عبير",2.66,1484.28]
[102,7,"ريم",12.53,6991.74,13900]
[102,null,"ريم",6.4,3571.2000000000003]
[102,null,"ريم",23.19,12940.02]
[102,8,"ميمونة",18.64,10401.120000000001]
[102,9,"ايمان",9.59,5351.22,5200]
[102,10,"أحلام محفوظ",7.73,4313.34,9200]
[102,null,"أحلام محفوظ",9.06,5055.4800000000005]
[102,11,"يسرى صالح",12.26,6841.08,28000]
[102,null,"يسرى صالح",2.93,1634.94]
[102,null,"يسرى صالح",0.8,446.40000000000003]
[102,null,"يسرى صالح",1.07,597.06000000000006]
[102,null,"يسرى صالح",0.8,446.40000000000003]
[102,null,"يسرى صالح",4.26,2377.08]
[102,null,"يسرى صالح",1.87,1043.46]
[102,null,"يسرى صالح",1.33,742.14]
[102,null,"يسرى صالح",1.07,597.06000000000006]
[102,null,"يسرى صالح",1.6,892.80000000000007]
[102,null,"يسرى صالح",1.6,892.80000000000007]
[102,null,"يسرى صالح",{"$f":"18.39*2","v":36.78},20523.240000000002]
[102,null,"يسرى صالح",16.79,9368.82]
[102,null,"يسرى صالح",5.0599999999999996,2823.4799999999996]
[102,null,"يسرى صالح",5.86,3269.88]
[102,null,"يسرى صالح",1.87,1043.46]
[102,null,"يسرى صالح",2.13,1188.54]
[102,null,"يسرى صالح",1.6,892.80000000000007]
[102,null,"يسرى صالح",0.8,446.40000000000003]
[102,null,"يسرى صالح",3.73,2081.34]
[102,12,"نبيهة",8.7899999999999991,4904.82,0]
[102,13,"ام رودينا3",1.33,742.14,8000]
[102,null,"ام رودينا3",{"$f":"2.03*2","v":4.0599999999999996},2265.4799999999996]
[102,null,"ام رودينا3",2.67,1489.86]
[102,null,"ام رودينا3",{"$f":"1.87*4","v":7.48},4173.84]
[102,null,"ام رودينا3",{"$f":"2.67*2","v":5.34},2979.72]
[102,null,"ام رودينا3",4.8,2678.4]
[102,null,"ام رودينا3",1.33,742.14]
[102,null,"ام رودينا3",1.33,742.14]
[102,14,"ام رودينا2",1.07,{"$f":"D243*558","v":597.06000000000006},16000]
[102,null,"ام رودينا2",9.59,5351.22]
[102,null,"ام رودينا2",7.46,4162.68]
[102,null,"ام رودينا2",12.26,6841.08]
[102,null,"ام رودينا2",10.130000000000001,5652.5400000000009]
[102,null,"ام رودينا2",6.4,3571.2000000000003]
[102,null,"ام رودينا2",9.59,5351.22]
[102,15,"ام رودينا1",6.93,3866.94,18800]
[102,null,"ام رودينا1",{"$f":"1.33*2","v":2.66},1484.28]
[102,null,"ام رودينا1",3.2,1785.6000000000001]
[102,null,"ام رودينا1",2.4,1339.2]
[102,null,"ام رودينا1",1.66,926.28]
[102,null,"ام رودينا1",{"$f":"3.2*2","v":6.4},3571.2000000000003]
[102,null,"ام رودينا1",{"$f":"1.86*2","v":3.72},2075.7600000000002]
[102,null,"ام رودينا1",2.13,1188.54]
[102,null,"ام رودينا1",{"$f":"1.6+0.8+1.33+1.6+3.73+1.6+1.6+4.79+2.66+2.14+2.14+1.86+1.86+3.2+4.53+4.53+0.8","v":40.769999999999996},22749.659999999996]
[102,16,"سناء الحيدري",2.67,1489.86,0]
[102,null,"سناء الحيدري",2.67,1489.86]
[102,17,"ذكرى",9.59,5351.22,0]
[102,18,"ندى",5.6,3124.7999999999997,10200]
[102,null,"ندى",{"$f":"15.46*2","v":30.92},17253.36]
[102,null,"اسراء",1.33,742.14,0]
[102,null,"سحر",2.13,1188.54,0]
[102,null,"وهيبة",1.6,892.80000000000007,0]
[102,null,"وهيبة",1.87,1043.46]
[102,19,"اماني",4.8,2678.4,2700]
[102,20,"صفية",1.33,742.14,49800]
[102,null,"صفية",5.0599999999999996,2823.4799999999996]
[102,null,"صفية",3.73,2081.34]
[102,null,"صفية",4.26,2377.08]
[102,null,"صفية",1.87,1043.46]
[102,null,"صفية",26.12,14574.960000000001]
[102,null,"صفية",12.79,7136.82]
[102,null,"صفية",17.59,9815.2199999999993]
[102,null,"صفية",4.26,2377.08]
[102,null,"صفية",12.53,6991.74]
[102,21,"شذا",15.99,8922.42,10000]
[102,null,"شذا",21.85,12192.300000000001]
[102,null,"شذا",17.86,9965.8799999999992]
[102,22,"أسماء ",9.59,5351.22,19800]
[102,null,"أسماء ",8.7899999999999991,4904.82]
[102,null,"أسماء ",8.7899999999999991,4904.82]
[102,null,"أسماء ",1.07,597.06000000000006]
[102,null,"أسماء ",2.93,1634.94]
[102,null,"أسماء ",7.73,4313.34]
[102,null,"أسماء ",4,2232]
[102,null,"أسماء ",1.33,742.14]
[102,null,"أسماء ",3.2,1785.6000000000001]
[102,null,"أسماء ",5.87,3275.46]
[102,null,"أسماء ",2.13,1188.54]
[102,null,"أسماء ",1.33,742.14]
[102,null,"أسماء ",2.14,1194.1200000000001]
[102,23,"ابتسام",{"$f":"8.79*2","v":17.579999999999998},9809.64,5000]
[102,24,"ليناء2",12.53,6991.74,22000]
[102,null,"ليناء2",13.33,7438.14]
[102,null,"ليناء2",{"$f":"22.65","v":22.65},12638.699999999999]
[102,null,"ليناء2",17.86,9965.8799999999992]
[102,25,"سندس",13.06,7287.4800000000005]
[102,null,"سندس",9.0500000000000007,5049.9000000000005]
[103,1,"ملكة",3.46,1920.3,11100]
[103,null,"ملكة",21.83,12115.65]
[103,null,"ملكة",14.11,7831.0499999999993]
[103,2,"سحر",5.32,2952.6000000000004,5000]
[103,null,"سحر",10.119999999999999,5616.5999999999995]
[103,3,"لينا",3.46,{"$f":"D307*555","v":1920.3},15000]
[103,null,"لينا",11.98,6648.9000000000005]
[103,null,"لينا",7.45,4134.75]
[103,null,"لينا",2.13,1182.1499999999999]
[103,null,"لينا",1.33,738.15000000000009]
[103,null,"لينا",14.37,7975.3499999999995]
[103,4,"اميمة",10.65,5910.75,15000]
[103,null,"اميمة",18.899999999999999,10489.5]
[103,null,"اميمة",17.84,9901.2000000000007]
[103,null,"اميمة",6.92,3840.6]
[103,null,"اميمة",12.78,7092.9]
[103,5,"ريم",2.13,1182.1499999999999,10000]
[103,null,"ريم",1.06,588.30000000000007]
[103,null,"ريم",3.46,1920.3]
[103,null,"ريم",1.6,888]
[103,null,"ريم",7.72,4284.5999999999995]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D371*555","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D383*560","v":0}]
[null,null,null,null,{"$f":"D384*560","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D440*560","v":0}]
[null,null,null,null,{"$f":"D441*560","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D453*555","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D499*555","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D514*555","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[105,null,"الإجمالي",{"$f":"SUM(D3:D567)","v":2610.6299999999992},{"$f":"SUM(E3:E567)","v":1451523.12},{"$f":"SUM(F3:F567)","v":683068}]

{"sheet":"الخلاصة","index":1,"n_rows":112,"n_cols":10,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["الاسم","دولار","يمني","المبلغ المدفوع","الباقي عندها او لها","يمني","المبلغ المدفوع","الباقي عندها او لها",103]
["ملكة",39.4,21867,11100,{"$f":"C2-D2","v":10767},{"$f":"B2*555","v":21867},{"$f":"D2","v":11100},{"$f":"F2-G2","v":10767},null,"المطلوب دالة او كود عندما ادخل رقم  الطلبية الموجودة في الصفحة قاعدة البيانات في الخلية I1 تترحل الطلبية بالاجماليات الى جدول الخلاصة "]
["سحر",15.44,8569.2000000000007,5000,3569.2000000000007,{"$f":"B3*555","v":8569.1999999999989},{"$f":"D3","v":5000},{"$f":"F3-G3","v":3569.1999999999989}]
["لينا",40.72,22599.599999999999,15000,7599.5999999999985,22599.599999999999,15000,7599.5999999999985]
["اميمة",67.09,37234.949999999997,15000,22234.949999999997,37234.950000000004,15000,22234.950000000004]
["ريم",15.97,8863.3499999999985,10000,-1136.6500000000015,8863.35,10000,-1136.6499999999996]
[null,53.31,29587.050000000003,0,29587.050000000003,29587.050000000003,0,29587.050000000003]
[null,16.260000000000002,9024.3000000000011,5000,4024.3000000000011,9024.3000000000011,5000,4024.3000000000011]
[null,6.13,3402.15,0,3402.15,3402.15,0,3402.15]
[null,18.64,10345.200000000001,0,10345.200000000001,10345.200000000001,0,10345.200000000001]
[null,9.59,5322.45,0,5322.45,5322.45,0,5322.45]
[null,27.71,15379.05,5000,10379.049999999999,15379.050000000001,5000,10379.050000000001]
[null,124.64,69175.199999999997,30000,39175.199999999997,69175.199999999997,30000,39175.199999999997]
[null,11.72,6504.6,6900,-395.39999999999964,6504.6,6900,-395.39999999999964]
[null,33.03,18331.650000000001,16000,2331.6500000000015,18331.650000000001,16000,2331.6500000000015]
[null,113.44,62959.200000000004,15000,47959.200000000004,62959.199999999997,15000,47959.199999999997]
[null,62.95,34937.25,15000,19937.25,34937.25,15000,19937.25]
[null,{"$f":"SUMIF('قاعدة البيانات'!A19:F1015,A18,'قاعدة البيانات'!B19:B1015)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A19:F1015,A18,'قاعدة البيانات'!C19:C1015)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A19:F1015,A18,'قاعدة البيانات'!D19:D1015)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A20:F1016,A19,'قاعدة البيانات'!B20:B1016)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A20:F1016,A19,'قاعدة البيانات'!C20:C1016)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A20:F1016,A19,'قاعدة البيانات'!D20:D1016)","v":0},{"$f":"C19-D19","v":0},0,{"$f":"D19","v":0},{"$f":"F19-G19","v":0}]
[null,{"$f":"SUMIF('قاعدة البيانات'!A21:F1017,A20,'قاعدة البيانات'!B21:B1017)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A21:F1017,A20,'قاعدة البيانات'!C21:C1017)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A21:F1017,A20,'قاعدة البيانات'!D21:D1017)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A22:F1018,A21,'قاعدة البيانات'!B22:B1018)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A22:F1018,A21,'قاعدة البيانات'!C22:C1018)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A22:F1018,A21,'قاعدة البيانات'!D22:D1018)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A23:F1019,A22,'قاعدة البيانات'!B23:B1019)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A23:F1019,A22,'قاعدة البيانات'!C23:C1019)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A23:F1019,A22,'قاعدة البيانات'!D23:D1019)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A24:F1020,A23,'قاعدة البيانات'!B24:B1020)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A24:F1020,A23,'قاعدة البيانات'!C24:C1020)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A24:F1020,A23,'قاعدة البيانات'!D24:D1020)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A25:F1021,A24,'قاعدة البيانات'!B25:B1021)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A25:F1021,A24,'قاعدة البيانات'!C25:C1021)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A25:F1021,A24,'قاعدة البيانات'!D25:D1021)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A26:F1022,A25,'قاعدة البيانات'!B26:B1022)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A26:F1022,A25,'قاعدة البيانات'!C26:C1022)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A26:F1022,A25,'قاعدة البيانات'!D26:D1022)","v":0},0,{"$f":"B25*566","v":0},0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A27:F1023,A26,'قاعدة البيانات'!B27:B1023)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A27:F1023,A26,'قاعدة البيانات'!C27:C1023)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A27:F1023,A26,'قاعدة البيانات'!D27:D1023)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A28:F1024,A27,'قاعدة البيانات'!B28:B1024)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A28:F1024,A27,'قاعدة البيانات'!C28:C1024)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A28:F1024,A27,'قاعدة البيانات'!D28:D1024)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A29:F1025,A28,'قاعدة البيانات'!B29:B1025)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A29:F1025,A28,'قاعدة البيانات'!C29:C1025)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A29:F1025,A28,'قاعدة البيانات'!D29:D1025)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A30:F1026,A29,'قاعدة البيانات'!B30:B1026)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A30:F1026,A29,'قاعدة البيانات'!C30:C1026)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A30:F1026,A29,'قاعدة البيانات'!D30:D1026)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A31:F1027,A30,'قاعدة البيانات'!B31:B1027)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A31:F1027,A30,'قاعدة البيانات'!C31:C1027)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A31:F1027,A30,'قاعدة البيانات'!D31:D1027)","v":0},0,0,0,0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A32:F1028,A31,'قاعدة البيانات'!B32:B1028)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A32:F1028,A31,'قاعدة البيانات'!C32:C1028)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A32:F1028,A31,'قاعدة البيانات'!D32:D1028)","v":0},{"$f":"C31-D31","v":0}]
[null,{"$f":"SUMIF('قاعدة البيانات'!A33:F1029,A32,'قاعدة البيانات'!B33:B1029)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A33:F1029,A32,'قاعدة البيانات'!C33:C1029)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A33:F1029,A32,'قاعدة البيانات'!D33:D1029)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A34:F1030,A33,'قاعدة البيانات'!B34:B1030)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A34:F1030,A33,'قاعدة البيانات'!C34:C1030)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A34:F1030,A33,'قاعدة البيانات'!D34:D1030)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A35:F1031,A34,'قاعدة البيانات'!B35:B1031)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A35:F1031,A34,'قاعدة البيانات'!C35:C1031)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A35:F1031,A34,'قاعدة البيانات'!D35:D1031)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A36:F1032,A35,'قاعدة البيانات'!B36:B1032)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A36:F1032,A35,'قاعدة البيانات'!C36:C1032)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A36:F1032,A35,'قاعدة البيانات'!D36:D1032)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A37:F1033,A36,'قاعدة البيانات'!B37:B1033)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A37:F1033,A36,'قاعدة البيانات'!C37:C1033)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A37:F1033,A36,'قاعدة البيانات'!D37:D1033)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A38:F1034,A37,'قاعدة البيانات'!B38:B1034)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A38:F1034,A37,'قاعدة البيانات'!C38:C1034)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A38:F1034,A37,'قاعدة البيانات'!D38:D1034)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A39:F1035,A38,'قاعدة البيانات'!B39:B1035)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A39:F1035,A38,'قاعدة البيانات'!C39:C1035)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A39:F1035,A38,'قاعدة البيانات'!D39:D1035)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A40:F1036,A39,'قاعدة البيانات'!B40:B1036)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A40:F1036,A39,'قاعدة البيانات'!C40:C1036)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A40:F1036,A39,'قاعدة البيانات'!D40:D1036)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A41:F1037,A40,'قاعدة البيانات'!B41:B1037)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A41:F1037,A40,'قاعدة البيانات'!C41:C1037)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A41:F1037,A40,'قاعدة البيانات'!D41:D1037)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A42:F1038,A41,'قاعدة البيانات'!B42:B1038)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A42:F1038,A41,'قاعدة البيانات'!C42:C1038)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A42:F1038,A41,'قاعدة البيانات'!D42:D1038)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A43:F1039,A42,'قاعدة البيانات'!B43:B1039)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A43:F1039,A42,'قاعدة البيانات'!C43:C1039)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A43:F1039,A42,'قاعدة البيانات'!D43:D1039)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A44:F1040,A43,'قاعدة البيانات'!B44:B1040)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A44:F1040,A43,'قاعدة البيانات'!C44:C1040)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A44:F1040,A43,'قاعدة البيانات'!D44:D1040)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A45:F1041,A44,'قاعدة البيانات'!B45:B1041)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A45:F1041,A44,'قاعدة البيانات'!C45:C1041)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A45:F1041,A44,'قاعدة البيانات'!D45:D1041)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A46:F1042,A45,'قاعدة البيانات'!B46:B1042)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A46:F1042,A45,'قاعدة البيانات'!C46:C1042)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A46:F1042,A45,'قاعدة البيانات'!D46:D1042)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A47:F1043,A46,'قاعدة البيانات'!B47:B1043)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A47:F1043,A46,'قاعدة البيانات'!C47:C1043)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A47:F1043,A46,'قاعدة البيانات'!D47:D1043)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A48:F1044,A47,'قاعدة البيانات'!B48:B1044)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A48:F1044,A47,'قاعدة البيانات'!C48:C1044)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A48:F1044,A47,'قاعدة البيانات'!D48:D1044)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A49:F1045,A48,'قاعدة البيانات'!B49:B1045)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A49:F1045,A48,'قاعدة البيانات'!C49:C1045)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A49:F1045,A48,'قاعدة البيانات'!D49:D1045)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A50:F1046,A49,'قاعدة البيانات'!B50:B1046)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A50:F1046,A49,'قاعدة البيانات'!C50:C1046)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A50:F1046,A49,'قاعدة البيانات'!D50:D1046)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A51:F1047,A50,'قاعدة البيانات'!B51:B1047)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A51:F1047,A50,'قاعدة البيانات'!C51:C1047)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A51:F1047,A50,'قاعدة البيانات'!D51:D1047)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A52:F1048,A51,'قاعدة البيانات'!B52:B1048)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A52:F1048,A51,'قاعدة البيانات'!C52:C1048)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A52:F1048,A51,'قاعدة البيانات'!D52:D1048)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A53:F1049,A52,'قاعدة البيانات'!B53:B1049)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A53:F1049,A52,'قاعدة البيانات'!C53:C1049)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A53:F1049,A52,'قاعدة البيانات'!D53:D1049)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A54:F1050,A53,'قاعدة البيانات'!B54:B1050)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A54:F1050,A53,'قاعدة البيانات'!C54:C1050)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A54:F1050,A53,'قاعدة البيانات'!D54:D1050)","v":0},0]
[null,{"$f":"SUMIF('قاعدة البيانات'!A55:F1051,A54,'قاعدة البيانات'!B55:B1051)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A55:F1051,A54,'قاعدة البيانات'!C55:C1051)","v":0},{"$f":"SUMIF('قاعدة البيانات'!A55:F1051,A54,'قاعدة البيانات'!D55:D1051)","v":0},0]
["الإجمالي",{"$f":"SUM(B2:B30)","v":656.04},364102.2,149000,215102.2,364102.2,149000,215102.2]
[]
[null,{"$f":"B55-#REF!","v":{"$error":"#REF!"}}]
[null,null,311000,99000,146000]
[null,851.64,{"$f":"C58-C55","v":-53102.200000000012},{"$f":"D58-D55","v":-50000},{"$f":"E58-E55","v":-69102.200000000012}]
[null,{"$f":"B59-B55","v":195.60000000000002},null,null,null,null,79400]
[null,null,{"$f":"C55*10/100","v":36410.22}]
[null,{"$f":"623.88","v":623.88},null,{"$f":"C58-D58","v":212000}]
[null,{"$f":"B55-B62","v":32.159999999999968},{"$f":"B63*558","v":17945.279999999981},166000]
[null,3.99,null,{"$f":"D63-D55","v":17000},143.1]
[null,{"$f":"B63-B64","v":28.169999999999966},null,null,{"$f":"E64-B3","v":127.66},null,8000]
[null,null,null,null,null,null,20000]
[null,null,null,null,null,null,52200]
[null,null,null,null,null,null,34000]
[null,null,null,null,null,null,2200]
[null,null,null,null,null,null,2400]
[null,null,null,null,52.14,null,{"$f":"SUM(G65:G70)","v":118800},"الموجود نقدا"]
[null,null,null,null,{"$f":"B13-E71","v":72.5},null,{"$f":"D55-G71","v":30200},"الباقي من حساب الدفعة"]
[]
[]
[null,null,null,null,null,null,4700]
[null,null,null,null,162963,null,0]
[null,"اجمالي الحسبة بسعر560",{"$f":"C55","v":364102.2},null,{"$f":"F80-E76","v":0},null,17700]
[null,"اجملي الحسبة بسعر 566",{"$f":"B55*566","v":371318.63999999996},null,null,null,10000]
[null,"الفارق",{"$f":"C78-C77","v":7216.4399999999441},null,null,null,50000]
[null,null,null,null,"اجمالي رصيد البنك",{"$f":"158263+G75+G76","v":162963},28700]
[null,null,null,null,"ينزل منة مايخص الدفعة ",{"$f":"F80-G81","v":51863},{"$f":"SUM(G75:G80)","v":111100},"الموجود في البنك من حساب الدفعة"]
[null,null,{"$f":"C78-C55","v":7216.4399999999441},null,"الباقي",38000]
[null,null,null,null,null,13000]
[null,null,null,null,null,10000]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F82:F85)","v":61000}]
[null,null,null,null,null,{"$f":"F81-F86","v":-9137}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"A101/C101","v":149.25373134328359}]
[]
[50000,700,335,{"$f":"B101*C101","v":234500}]
[null,150,336,{"$f":"B102*C102","v":50400}]
[]
[]
[]
[]
[]
[83000,null,{"$f":"1270*100","v":127000}]
[50000]
[50000]
[{"$f":"SUM(A108:A110)","v":183000}]
[{"$f":"A111/C101","v":546.26865671641792}]