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

{"sheet":"تقرير المصاريف","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["اسم الشركة"]
["تقرير المصاريف"]
[]
[null,"الموظف:","جاكلين حداد",{"$nulls":3},"معتمد من قبل:"]
[null,"القسم:","المبيعات"]
[null,"نهاية الأسبوع:","2013-03-07",{"$nulls":3},"التاريخ:"]
[null,"معدل المسافة المقطوعة بالكيلومتر:",{"v":0.67,"d":" 0.67 ر.س.‏"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"الجمعة"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"السبت"},"الأحد",{"$f":"UPPER(TEXT(F10,\"dddd\"))","v":"الإثنين"},"الثلاثاء","الأربعاء","الخميس"]
[null,"وسيلة النقل",{"$f":"WeekEnding-6","v":"2013-03-01"},{"$f":"WeekEnding-5","v":"2013-03-02"},{"$f":"WeekEnding-4","v":"2013-03-03"},{"$f":"WeekEnding-3","v":"2013-03-04"},{"$f":"WeekEnding-2","v":"2013-03-05"},{"$f":"WeekEnding-1","v":"2013-03-06"},{"$f":"WeekEnding","v":"2013-03-07"},"الإجمالي"]
[null,"عدد الكيلومترات المقطوعة",145,{"$nulls":6},{"$f":"SUM(وسيلة_النقل[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":145,"d":" 145.00 ر.س.‏"}}]
[null,"مقابل المسافة المقطوعة بالكيلومتر",{"$f":"C11*MileageRate","v":{"v":97.15,"d":" 97.15 ر.س.‏"}},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"$f":"SUM(وسيلة_النقل[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":97.15,"d":" 97.15 ر.س.‏"}}]
[null,"مكان انتظار السيارات والرسوم",{"$nulls":3},{"v":17,"d":" 17.00 ر.س.‏"},{"$nulls":3},{"$f":"SUM(وسيلة_النقل[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":17,"d":" 17.00 ر.س.‏"}}]
[null,"تأجير السيارات",{"v":79,"d":" 79.00 ر.س.‏"},null,null,{"v":79,"d":" 79.00 ر.س.‏"},{"$nulls":3},{"$f":"SUM(وسيلة_النقل[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":158,"d":" 158.00 ر.س.‏"}}]
[null,"التاكسي/الليموزين",{"$nulls":7},{"$f":"SUM(وسيلة_النقل[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}}]
[null,"غير ذلك (سكك حديدية أو حافلة)",{"$nulls":7},{"$f":"SUM(وسيلة_النقل[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}}]
[null,"ثمن تذكرة السفر",{"$nulls":3},{"v":235,"d":" 235.00 ر.س.‏"},{"$nulls":3},{"$f":"SUM(وسيلة_النقل[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":235,"d":" 235.00 ر.س.‏"}}]
[null,"الإجمالي",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":" 176.15 ر.س.‏"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":" 0.00 ر.س.‏"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":331,"d":" 331.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUM(J12:J17)","v":{"v":507.15,"d":" 507.15 ر.س.‏"}}]
[]
[null,"السكن والوجبات"]
[null,"السكن",{"v":145,"d":" 145.00 ر.س.‏"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":145,"d":" 145.00 ر.س.‏"}}]
[null,"الفطور",{"v":11.49,"d":" 11.49 ر.س.‏"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":11.49,"d":" 11.49 ر.س.‏"}}]
[null,"الغداء",{"v":12,"d":" 12.00 ر.س.‏"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":12,"d":" 12.00 ر.س.‏"}}]
[null,"العشاء",{"v":17,"d":" 17.00 ر.س.‏"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":17,"d":" 17.00 ر.س.‏"}}]
[null,"وجبة خفيفة",{"$f":"C24*MileageRate","v":{"v":11.39,"d":" 11.39 ر.س.‏"}},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":11.39,"d":" 11.39 ر.س.‏"}}]
[null,"الإجمالي الفرعي للوجبات",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":" 40.49 ر.س.‏"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"$f":"SUM(LodgingMeals[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":40.49,"d":" 40.49 ر.س.‏"}}]
[null,"الإجمالي",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":" 185.49 ر.س.‏"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"v":0,"d":" 0.00 ر.س.‏"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":185.49,"d":" 185.49 ر.س.‏"}}]
[]
[null,"متنوعات"]
[null,"التجهيزات",{"$nulls":7},{"$f":"SUM(متنوعات[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}}]
[null,"المعدات",{"$nulls":7},{"$f":"SUM(متنوعات[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}}]
[null,"الهاتف والفاكس والإنترنت",{"$nulls":7},{"$f":"SUM(متنوعات[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}}]
[null,"مصاريف أخرى*",{"$nulls":7},{"$f":"SUM(متنوعات[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}}]
[null,"التسلية*",{"$nulls":3},{"v":199,"d":" 199.00 ر.س.‏"},{"$nulls":3},{"$f":"SUM(متنوعات[[#This Row],[اليوم 1]:[اليوم 7]])","v":{"v":199,"d":" 199.00 ر.س.‏"}}]
[null,"الإجمالي",{"$f":"SUBTOTAL(109,متنوعات[[#All],[اليوم 1]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,متنوعات[[#All],[اليوم 2]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,متنوعات[[#All],[اليوم 3]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,متنوعات[[#All],[اليوم 4]])","v":{"v":199,"d":" 199.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,متنوعات[[#All],[اليوم 5]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,متنوعات[[#All],[اليوم 6]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,متنوعات[[#All],[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUBTOTAL(109,متنوعات[[#All],[الإجمالي]])","v":{"v":199,"d":" 199.00 ر.س.‏"}}]
[]
[null,"الإجماليات الكلية",{"$f":"SUM(C35,LodgingMeals[[#Totals],[اليوم 1]],وسيلة_النقل[[#Totals],[اليوم 1]])","v":{"v":361.64,"d":" 361.64 ر.س.‏"}},{"$f":"SUM(D35,LodgingMeals[[#Totals],[اليوم 2]],وسيلة_النقل[[#Totals],[اليوم 2]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUM(E35,LodgingMeals[[#Totals],[اليوم 3]],وسيلة_النقل[[#Totals],[اليوم 3]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUM(F35,LodgingMeals[[#Totals],[اليوم 4]],وسيلة_النقل[[#Totals],[اليوم 4]])","v":{"v":530,"d":" 530.00 ر.س.‏"}},{"$f":"SUM(G35,LodgingMeals[[#Totals],[اليوم 5]],وسيلة_النقل[[#Totals],[اليوم 5]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUM(H35,LodgingMeals[[#Totals],[اليوم 6]],وسيلة_النقل[[#Totals],[اليوم 6]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUM(I35,LodgingMeals[[#Totals],[اليوم 7]],وسيلة_النقل[[#Totals],[اليوم 7]])","v":{"v":0,"d":" 0.00 ر.س.‏"}},{"$f":"SUM(J35,LodgingMeals[[#Totals],[الإجمالي]],وسيلة_النقل[[#Totals],[الإجمالي]])","v":{"v":891.64,"d":" 891.64 ر.س.‏"}}]
[]
[{"$nulls":9},"إجمالي المصاريف"]
[null,"*الغرض المهني للعناصر ضمن \"التسلية\" والعناصر ضمن \"مصاريف أخرى\":",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":" 891.64 ر.س.‏"}}]
[{"$nulls":9},"سلفيات"]
[]
[{"$nulls":9},"إجمالي التعويض"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":" 891.64 ر.س.‏"}}]
[{"$nulls":9},"الرجاء إرفاق جميع الإيصالات."]