{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["التدفق النقدي","الدخل الشهري","المصاريف الشهرية","بيانات المخطط"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"التدفق النقدي","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," اسم العائلة"]
[null,"ميزانية العائلة"]
[null,{"$f":"\" لشهر \" & TEXT(TODAY(),\"mmmm yyyy\")","v":" لشهر سبتمبر 2021"}]
[]
[]
[null,"تحليل التدفق النقدي"]
[]
[]
[null," ","المتوقع","الفعلي","الفرق"]
[{"$f":"الدخل[[#Totals],[الفرق]]","v":300},"إجمالي الدخل",{"$f":"الدخل[[#Totals],[المتوقع]]","v":{"v":5700,"d":"ر.س.‏ 5,700"}},{"$f":"الدخل[[#Totals],[الفعلي]]","v":{"v":6000,"d":"ر.س.‏ 6,000"}},{"$f":"A12","v":{"v":300,"d":"ر.س.‏ 300"}}]
[{"$f":"المصاريف[[#Totals],[الفرق]]","v":-52},"إجمالي المصاريف",{"$f":"المصاريف[[#Totals],[المتوقع]]","v":{"v":3603,"d":"ر.س.‏ 3,603"}},{"$f":"المصاريف[[#Totals],[الفعلي]]","v":{"v":3655,"d":"ر.س.‏ 3,655"}},{"$f":"A13","v":{"v":-52,"d":"ر.س.‏ 52-"}}]
[null,"إجمالي النقد",{"$f":"C12-C13","v":{"v":2097,"d":"ر.س.‏ 2,097"}},{"$f":"D12-D13","v":{"v":2345,"d":"ر.س.‏ 2,345"}},{"$f":"SUBTOTAL(109,التدفق_النقدي[الفرق])","v":{"v":248,"d":"ر.س.‏ 248"}}]

{"sheet":"الدخل الشهري","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"الدخل الشهري"]
[]
[]
[null," ","المتوقع","الفعلي","الفرق"]
[null,"الدخل 1",{"v":4000,"d":"ر.س.‏ 4,000.00"},{"v":4000,"d":"ر.س.‏ 4,000.00"},{"$f":"الدخل[[#This Row],[الفعلي]]-الدخل[[#This Row],[المتوقع]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"الدخل 2",{"v":1400,"d":"ر.س.‏ 1,400.00"},{"v":1500,"d":"ر.س.‏ 1,500.00"},{"$f":"الدخل[[#This Row],[الفعلي]]-الدخل[[#This Row],[المتوقع]]","v":{"v":100,"d":"ر.س.‏ 100.00"}}]
[null,"دخل آخر",{"v":300,"d":"ر.س.‏ 300.00"},{"v":500,"d":"ر.س.‏ 500.00"},{"$f":"الدخل[[#This Row],[الفعلي]]-الدخل[[#This Row],[المتوقع]]","v":{"v":200,"d":"ر.س.‏ 200.00"}}]
[null,"إجمالي الدخل",{"$f":"SUBTOTAL(109,الدخل[المتوقع])","v":{"v":5700,"d":"ر.س.‏ 5,700.00"}},{"$f":"SUBTOTAL(109,الدخل[الفعلي])","v":{"v":6000,"d":"ر.س.‏ 6,000.00"}},{"$f":"SUBTOTAL(109,الدخل[الفرق])","v":{"v":300,"d":"ر.س.‏ 300.00"}}]

{"sheet":"المصاريف الشهرية","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"المصروفات الشهرية"]
[]
[]
[null," ","المتوقع","الفعلي","الفرق"]
[null,"السكن",{"v":1500,"d":"ر.س.‏ 1,500.00"},{"v":1500,"d":"ر.س.‏ 1,500.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"البقالة",{"v":250,"d":"ر.س.‏ 250.00"},{"v":280,"d":"ر.س.‏ 280.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":-30,"d":"ر.س.‏ 30.00-"}}]
[null,"الهاتف",{"v":38,"d":"ر.س.‏ 38.00"},{"v":38,"d":"ر.س.‏ 38.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"الكهرباء/الوقود",{"v":65,"d":"ر.س.‏ 65.00"},{"v":78,"d":"ر.س.‏ 78.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":-13,"d":"ر.س.‏ 13.00-"}}]
[null,"المياه/الصرف الصحي/القمامة",{"v":25,"d":"ر.س.‏ 25.00"},{"v":21,"d":"ر.س.‏ 21.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":4,"d":"ر.س.‏ 4.00"}}]
[null,"القنوات الفضائية",{"v":75,"d":"ر.س.‏ 75.00"},{"v":83,"d":"ر.س.‏ 83.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":-8,"d":"ر.س.‏ 8.00-"}}]
[null,"الإنترنت",{"v":60,"d":"ر.س.‏ 60.00"},{"v":60,"d":"ر.س.‏ 60.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"الصيانة/الإصلاحات",{"v":0,"d":"ر.س.‏ 0.00"},{"v":60,"d":"ر.س.‏ 60.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":-60,"d":"ر.س.‏ 60.00-"}}]
[null,"رعاية الأطفال",{"v":180,"d":"ر.س.‏ 180.00"},{"v":150,"d":"ر.س.‏ 150.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":30,"d":"ر.س.‏ 30.00"}}]
[null,"الرسوم الدراسية",{"v":250,"d":"ر.س.‏ 250.00"},{"v":250,"d":"ر.س.‏ 250.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"الحيوانات الأليفة",{"v":75,"d":"ر.س.‏ 75.00"},{"v":80,"d":"ر.س.‏ 80.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":-5,"d":"ر.س.‏ 5.00-"}}]
[null,"وسائل النقل",{"v":280,"d":"ر.س.‏ 280.00"},{"v":260,"d":"ر.س.‏ 260.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":20,"d":"ر.س.‏ 20.00"}}]
[null,"الرعاية الشخصية",{"v":75,"d":"ر.س.‏ 75.00"},{"v":65,"d":"ر.س.‏ 65.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":10,"d":"ر.س.‏ 10.00"}}]
[null,"التأمين",{"v":255,"d":"ر.س.‏ 255.00"},{"v":255,"d":"ر.س.‏ 255.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"بطاقات الائتمان",{"v":100,"d":"ر.س.‏ 100.00"},{"v":100,"d":"ر.س.‏ 100.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"القروض",{"v":0,"d":"ر.س.‏ 0.00"},{"v":0,"d":"ر.س.‏ 0.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"الضرائب",{"v":0,"d":"ر.س.‏ 0.00"},{"v":0,"d":"ر.س.‏ 0.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"الهدايا/التبرعات",{"v":150,"d":"ر.س.‏ 150.00"},{"v":150,"d":"ر.س.‏ 150.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"المدخرات",{"v":225,"d":"ر.س.‏ 225.00"},{"v":225,"d":"ر.س.‏ 225.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"أخرى",{"v":0,"d":"ر.س.‏ 0.00"},{"v":0,"d":"ر.س.‏ 0.00"},{"$f":"المصاريف[[#This Row],[المتوقع]]-المصاريف[[#This Row],[الفعلي]]","v":{"v":0,"d":"ر.س.‏ 0.00"}}]
[null,"الإجمالي",{"$f":"SUBTOTAL(109,المصاريف[المتوقع])","v":{"v":3603,"d":"ر.س.‏ 3,603.00"}},{"$f":"SUBTOTAL(109,المصاريف[الفعلي])","v":{"v":3655,"d":"ر.س.‏ 3,655.00"}},{"$f":"SUBTOTAL(109,المصاريف[الفرق])","v":{"v":-52,"d":"ر.س.‏ 52.00-"}}]

{"sheet":"بيانات المخطط","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"بيانات المخطط"]
[]
[null,null,"المتوقعة","الفعلي"]
[null,"الدخل الشهري",{"$f":"الدخل[[#Totals],[المتوقع]]","v":5700},{"$f":"الدخل[[#Totals],[الفعلي]]","v":6000}]
[null,"المصاريف الشهرية",{"$f":"المصاريف[[#Totals],[المتوقع]]","v":3603},{"$f":"المصاريف[[#Totals],[الفعلي]]","v":3655}]
[null,"التدفق النقدي",{"$f":"التدفق_النقدي[[#Totals],[المتوقع]]","v":2097},{"$f":"التدفق_النقدي[[#Totals],[الفعلي]]","v":2345}]