{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ميزانية المصاريف"],"not_rendered":{"charts":2,"external_links":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"ميزانية المصاريف","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,4],[0,5,0,6],[16,1,16,6],[47,1,47,6]]}
[null,"ميزانية المصاريف",{"$nulls":3},"الشركة الوطنية 2013"]
[]
[]
[null," ميزانية الموظف"]
{"$rows_empty":7}
[null,"الحالة","الموظف","الميزانية","الفعلي","الفرق (بالريال)","الفرق (بالنسبة)"]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"مكتب",{"v":500,"d":" 500.00 ر.س.‏"},{"v":565,"d":" 565.00 ر.س.‏"},{"$f":"tblPersonnelExpenses[[#This Row],[الميزانية]]-tblPersonnelExpenses[[#This Row],[الفعلي]]","v":{"v":-65,"d":"65.00- ر.س.‏"}},{"$f":"IFERROR(tblPersonnelExpenses[الفرق (بالريال)]/tblPersonnelExpenses[الميزانية],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"متجر",{"v":125,"d":" 125.00 ر.س.‏"},{"v":150,"d":" 150.00 ر.س.‏"},{"$f":"tblPersonnelExpenses[[#This Row],[الميزانية]]-tblPersonnelExpenses[[#This Row],[الفعلي]]","v":{"v":-25,"d":"25.00- ر.س.‏"}},{"$f":"IFERROR(tblPersonnelExpenses[الفرق (بالريال)]/tblPersonnelExpenses[الميزانية],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"مندوبو المبيعات",{"v":100,"d":" 100.00 ر.س.‏"},{"v":100,"d":" 100.00 ر.س.‏"},{"$f":"tblPersonnelExpenses[[#This Row],[الميزانية]]-tblPersonnelExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblPersonnelExpenses[الفرق (بالريال)]/tblPersonnelExpenses[الميزانية],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"غير ذلك",{"v":100,"d":" 100.00 ر.س.‏"},{"v":90,"d":" 90.00 ر.س.‏"},{"$f":"tblPersonnelExpenses[[#This Row],[الميزانية]]-tblPersonnelExpenses[[#This Row],[الفعلي]]","v":{"v":10,"d":" 10.00 ر.س.‏"}},{"$f":"IFERROR(tblPersonnelExpenses[الفرق (بالريال)]/tblPersonnelExpenses[الميزانية],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null," ميزانية التشغيل"]
{"$rows_empty":7}
[null,"الحالة","التشغيل","الميزانية","الفعلي","الفرق (بالريال)","الفرق (بالنسبة)"]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الإعلانات",{"v":250,"d":" 250.00 ر.س.‏"},{"v":245,"d":" 245.00 ر.س.‏"},{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":5,"d":" 5.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الديون",{"v":125,"d":" 125.00 ر.س.‏"},{"v":150,"d":" 150.00 ر.س.‏"},{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":-25,"d":"25.00- ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الفوائد",{"v":100,"d":" 100.00 ر.س.‏"},{"v":100,"d":" 100.00 ر.س.‏"},{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"التجهيزات",{"v":100,"d":" 100.00 ر.س.‏"},{"v":90,"d":" 90.00 ر.س.‏"},{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":10,"d":" 10.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"البريد",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الإيجار أو الرهن",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"مصاريف المبيعات",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الضرائب",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"المرافق",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"غير ذلك",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"التأمين",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الفائدة",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الهاتف",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الصيانة والإصلاحات",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الرسوم القانونية",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الإهلاك",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"الشحن",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"التخزين",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,{"$f":"IFERROR(#REF!/#REF!,\"\")","v":""},"غير ذلك",null,null,{"$f":"tblOperatingExpenses[[#This Row],[الميزانية]]-tblOperatingExpenses[[#This Row],[الفعلي]]","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[الفرق (بالريال)]]/tblOperatingExpenses[[#This Row],[الميزانية]],\"\")","v":""}]
[null,null,"إجمالي المصاريف",{"$f":"SUBTOTAL(109,tblOperatingExpenses[الميزانية],tblPersonnelExpenses[الميزانية])","v":{"v":1400,"d":" 1400.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[الفعلي],tblPersonnelExpenses[الفعلي])","v":{"v":1490,"d":" 1490.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[الفرق (بالريال)],tblPersonnelExpenses[الفرق (بالريال)])","v":{"v":-90,"d":"90.00- ر.س.‏"}},{"$f":"IFERROR(SUM(tblOperatingExpenses[[#Totals],[الفرق (بالريال)]]/tblOperatingExpenses[[#Totals],[الميزانية]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]