{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["التدفق النقدي لاثني عشر شهراً","ملخص التدفق النقدي"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"التدفق النقدي لاثني عشر شهراً","index":0,"n_rows":42,"n_cols":16,"rows_kept":42,"merged":[[7,0,7,15],[11,0,11,15],[17,0,17,15],[34,0,34,15]]}
[]
["التدفق النقدي لاثني عشر شهراً",{"$nulls":12},"السنة المالية تبدأ في:",null,"2013-07-01"]
["اسم الشركة"]
["العنوان والمدينة والمنطقة والرمز البريدي"]
["الهاتف والبريد الإلكتروني وموقع ويب"]
[]
[null,"البداية",{"$f":"FiscalYear","v":"2013-07-01"},{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2013-08-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+1,1)","v":"2013-09-01"},"2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","المتوسط الشهري","نظرة عامة"]
["الملخص النقدي"]
["النقد في الصندوق\n(بداية الشهر)",55000,{"$f":"IF(الإيصالات[[#Totals],[العمود 3]]+PaidOut[[#Totals],[العمود 3]]=0,\"\",B11)","v":67593},{"$f":"IF(الإيصالات[[#Totals],[العمود 4]]+PaidOut[[#Totals],[العمود 4]]=0,\"\",C11)","v":54265},{"$f":"IF(الإيصالات[[#Totals],[العمود 5]]+PaidOut[[#Totals],[العمود 5]]=0,\"\",D11)","v":55739},{"$f":"IF(الإيصالات[[#Totals],[العمود 6]]+PaidOut[[#Totals],[العمود 6]]=0,\"\",E11)","v":69290},{"$f":"IF(الإيصالات[[#Totals],[العمود 7]]+PaidOut[[#Totals],[العمود 7]]=0,\"\",F11)","v":65618},{"$f":"IF(الإيصالات[[#Totals],[العمود 8]]+PaidOut[[#Totals],[العمود 8]]=0,\"\",G11)","v":""},{"$f":"IF(الإيصالات[[#Totals],[العمود 9]]+PaidOut[[#Totals],[العمود 9]]=0,\"\",H11)","v":""},{"$f":"IF(الإيصالات[[#Totals],[العمود 10]]+PaidOut[[#Totals],[العمود 10]]=0,\"\",I11)","v":""},{"$f":"IF(الإيصالات[[#Totals],[العمود 11]]+PaidOut[[#Totals],[العمود 11]]=0,\"\",J11)","v":""},{"$f":"IF(الإيصالات[[#Totals],[العمود 12]]+PaidOut[[#Totals],[العمود 12]]=0,\"\",K11)","v":""},{"$f":"IF(الإيصالات[[#Totals],[العمود 13]]+PaidOut[[#Totals],[العمود 13]]=0,\"\",L11)","v":""},{"$f":"IF(الإيصالات[[#Totals],[العمود 14]]+PaidOut[[#Totals],[العمود 14]]=0,\"\",M11)","v":""},{"$f":"IFERROR(AVERAGE(الملخص[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":62501}]
["النقد المتوفر\n(في الصندوق + الإيصالات، قبل دفع النقود) ",{"$f":"SUM(B9,الإيصالات[[#Totals],[العمود 2]])","v":67593},{"$f":"IF(C9=\"\",\"\",SUM(C9,الإيصالات[[#Totals],[العمود 3]]))","v":76065},{"$f":"IF(D9=\"\",\"\",SUM(D9,الإيصالات[[#Totals],[العمود 4]]))","v":83301},{"$f":"IF(E9=\"\",\"\",SUM(E9,الإيصالات[[#Totals],[العمود 5]]))","v":91032},{"$f":"IF(F9=\"\",\"\",SUM(F9,الإيصالات[[#Totals],[العمود 6]]))","v":89662},{"$f":"IF(G9=\"\",\"\",SUM(G9,الإيصالات[[#Totals],[العمود 7]]))","v":76200},{"$f":"IF(H9=\"\",\"\",SUM(H9,الإيصالات[[#Totals],[العمود 8]]))","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I9,الإيصالات[[#Totals],[العمود 9]]))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J9,الإيصالات[[#Totals],[العمود 10]]))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K9,الإيصالات[[#Totals],[العمود 11]]))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L9,الإيصالات[[#Totals],[العمود 12]]))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M9,الإيصالات[[#Totals],[العمود 13]]))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N9,الإيصالات[[#Totals],[العمود 14]]))","v":""},{"$f":"IFERROR(AVERAGE(الملخص[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":83252}]
["الوضع النقدي\n(نهاية الشهر)",{"$f":"(B10-PaidOut[[#Totals],[العمود 2]])","v":67593},{"$f":"IFERROR(C10-PaidOut[[#Totals],[العمود 3]],\"\")","v":54265},{"$f":"IFERROR(D10-PaidOut[[#Totals],[العمود 4]],\"\")","v":55739},{"$f":"IFERROR(E10-PaidOut[[#Totals],[العمود 5]],\"\")","v":69290},{"$f":"IFERROR(F10-PaidOut[[#Totals],[العمود 6]],\"\")","v":65618},{"$f":"IFERROR(G10-PaidOut[[#Totals],[العمود 7]],\"\")","v":51413},{"$f":"IFERROR(H10-PaidOut[[#Totals],[العمود 8]],\"\")","v":""},{"$f":"IFERROR(I10-PaidOut[[#Totals],[العمود 9]],\"\")","v":""},{"$f":"IFERROR(J10-PaidOut[[#Totals],[العمود 10]],\"\")","v":""},{"$f":"IFERROR(K10-PaidOut[[#Totals],[العمود 11]],\"\")","v":""},{"$f":"IFERROR(L10-PaidOut[[#Totals],[العمود 12]],\"\")","v":""},{"$f":"IFERROR(M10-PaidOut[[#Totals],[العمود 13]],\"\")","v":""},{"$f":"IFERROR(N10-PaidOut[[#Totals],[العمود 14]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(الملخص[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":59265}]
[]
["إيصالات النقد"]
["المبيعات النقدية",5616,3889,24411,31642,14647,3034,{"$nulls":7},{"$f":"IFERROR(AVERAGE(الإيصالات[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":15524.6,"d":"15525"}}]
["مجموعات من حسابات المدين",4498,3493,1987,1029,2911,4234,{"$nulls":7},{"$f":"IFERROR(AVERAGE(الإيصالات[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":2730.8,"d":"2731"}}]
["القرض/النقدية الأخرى",2479,1090,2638,2622,2814,3314,{"$nulls":7},{"$f":"IFERROR(AVERAGE(الإيصالات[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":2495.6,"d":"2496"}}]
["إجمالي إيصالات النقد",{"$f":"SUBTOTAL(109,الإيصالات[العمود 2])","v":12593},{"$f":"SUBTOTAL(109,الإيصالات[العمود 3])","v":8472},{"$f":"SUBTOTAL(109,الإيصالات[العمود 4])","v":29036},{"$f":"SUBTOTAL(109,الإيصالات[العمود 5])","v":35293},{"$f":"SUBTOTAL(109,الإيصالات[العمود 6])","v":20372},{"$f":"SUBTOTAL(109,الإيصالات[العمود 7])","v":10582},{"$f":"SUBTOTAL(109,الإيصالات[العمود 8])","v":0},{"$f":"SUBTOTAL(109,الإيصالات[العمود 9])","v":0},{"$f":"SUBTOTAL(109,الإيصالات[العمود 10])","v":0},{"$f":"SUBTOTAL(109,الإيصالات[العمود 11])","v":0},{"$f":"SUBTOTAL(109,الإيصالات[العمود 12])","v":0},{"$f":"SUBTOTAL(109,الإيصالات[العمود 13])","v":0},{"$f":"SUBTOTAL(109,الإيصالات[العمود 14])","v":0},{"$f":"IFERROR(AVERAGE(الإيصالات[[#Totals],[العمود 3]:[العمود 14]]),\"\")","v":{"v":8646.25,"d":"8646"}}]
[]
["الدفع نقداً"]
["المشتريات (تحديد)",null,521,323,274,451,104,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":334.6,"d":"335"}}]
["إجمالي الأجور (السحب المضبوط)",null,10572,14514,10561,13170,12478,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":12259}]
["التجهيزات (المكتب والتشغيل)",null,250,428,165,1168,345,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":471.2,"d":"471"}}]
["الإصلاحات والصيانة",null,null,2200,163,67,{"$nulls":8},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":810}]
["الإعلانات",null,1100,625,1356,null,2560,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":1410.25,"d":"1410"}}]
["الإيجار",null,3500,3500,3500,3500,3500,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":3500}]
["الأدوات المساعدة",null,285,318,151,134,228,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":223.2,"d":"223"}}]
["غير ذلك (تحديد)",null,123,234,123,234,123,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":167.4,"d":"167"}}]
["قيمة دفعة القرض",null,4000,4000,4000,4000,4000,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":4000}]
["شراء الأصول (تحديد)",null,679,700,679,650,679,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":{"v":677.4,"d":"677"}}]
["تكاليف بدء المشروع الأخرى",null,400,350,400,300,400,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":370}]
["الاحتياطي و/أو الأموال المودعة لدى الغير",null,300,300,300,300,300,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":300}]
["سحب الملاك",null,70,70,70,70,70,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[العمود 3]:[العمود 14]]),\"\")","v":70}]
["إجمالي الدفع نقداً",null,{"$f":"SUBTOTAL(109,PaidOut[العمود 3])","v":21800},{"$f":"SUBTOTAL(109,PaidOut[العمود 4])","v":27562},{"$f":"SUBTOTAL(109,PaidOut[العمود 5])","v":21742},{"$f":"SUBTOTAL(109,PaidOut[العمود 6])","v":24044},{"$f":"SUBTOTAL(109,PaidOut[العمود 7])","v":24787},{"$f":"SUBTOTAL(109,PaidOut[العمود 8])","v":0},{"$f":"SUBTOTAL(109,PaidOut[العمود 9])","v":0},{"$f":"SUBTOTAL(109,PaidOut[العمود 10])","v":0},{"$f":"SUBTOTAL(109,PaidOut[العمود 11])","v":0},{"$f":"SUBTOTAL(109,PaidOut[العمود 12])","v":0},{"$f":"SUBTOTAL(109,PaidOut[العمود 13])","v":0},{"$f":"SUBTOTAL(109,PaidOut[العمود 14])","v":0},{"$f":"SUM(O20:O32)","v":{"v":24593.050000000007,"d":"24593"}}]
[]
[]
[" (معلومات التدفق غير النقدي)بيانات التشغيل الأساسية"]
["حجم المبيعات (بالريال)",2000,2500,2257,2387,2664,2324,{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[العمود 2]:[العمود 14]]),\"\")","v":{"v":2355.3333333333335,"d":"2355"}}]
["حسابات مدينة",1500,500,886,1035,1775,839,{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[العمود 2]:[العمود 14]]),\"\")","v":{"v":1089.1666666666667,"d":"1089"}}]
["الدين المعدوم (نهاية الشهر)",300,200,225,269,448,359,{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[العمود 2]:[العمود 14]]),\"\")","v":{"v":300.1666666666667,"d":"300"}}]
["المخزون الفعلي (نهاية الشهر)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(#REF!),\"\")","v":""}]
["حسابات المدفوعات (نهاية الشهر)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(#REF!),\"\")","v":""}]
["الإهلاك",{"$nulls":13},{"$f":"IFERROR(AVERAGE(#REF!),\"\")","v":""}]

{"sheet":"ملخص التدفق النقدي","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"نقاط البيانات:",3]
[null,null,"(اسحب شريط التمرير أعلاه لتغيير نقاط البيانات الإجمالية في المخطط.)"]