{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["تحليل الربحية","مخطط مقاييس الملخص "],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"تحليل الربحية","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[2,3,2,7],[10,1,10,5],[14,1,14,5],[21,1,21,5],[27,1,27,5],[30,1,30,5]]}
[]
[null,"تحليل ربحية العملاء"]
[null,"'20 يناير 2013",null,"اسم الشركة"]
[]
[]
[null,"نشاط العملاء","العميل 1","العميل 2","العميل 3","الإجمالي",null," "]
[null,"عدد العملاء النشطين ـــ بداية الفترة",5,8,8,{"$f":"SUM(C7:E7)","v":21}]
[null,"عدد العملاء الذين تمت إضافتهم",2,4,4,{"$f":"SUM(C8:E8)","v":10}]
[null,"عدد العملاء الذين تم فقدانهم/إنهاء التعامل معهم",{"v":-1,"d":" (1)"},{"v":-2,"d":" (2)"},{"v":-2,"d":" (2)"},{"v":-5,"d":" (5)"}]
[null,"عدد العملاء النشطين ـــ نهاية الفترة",{"$f":"SUBTOTAL(109,'تحليل الربحية'!$C$7:$C$9)","v":6},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$D$7:$D$9)","v":10},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$E$7:$E$9)","v":10},26]
[]
[null,"تحليل الربحية"," ","  ","   ","    "]
[null,"العائد لكل شريحة",{"v":1500000,"d":" 1500000 ر.س.‏"},{"v":1800000,"d":" 1800000 ر.س.‏"},{"v":2500000,"d":" 2500000 ر.س.‏"},{"$f":"SUM('تحليل الربحية'!$C13:$E13)","v":{"v":5800000,"d":" 5800000 ر.س.‏"}}]
[null,"القيمة",{"$f":"C13/$F$13","v":{"v":0.25862068965517243,"d":"25.9%"}},{"$f":"D13/$F$13","v":{"v":0.3103448275862069,"d":"31.0%"}},{"v":0.43103448275862066,"d":"43.1%"},{"$f":"SUM(C14:E14)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"تكلفة المبيعات"," ","  ","   ","    "]
[null,"تكاليف الدعم والخدمة المحددة",{"v":1000000,"d":" 1000000 ر.س.‏"},{"v":1400000,"d":" 1400000 ر.س.‏"},{"v":1400000,"d":" 1400000 ر.س.‏"},{"$f":"SUM('تحليل الربحية'!$C17:$E17)","v":{"v":3800000,"d":" 3800000 ر.س.‏"}}]
[null,"تكاليف العملاء المباشرة الأخرى",{"v":200000,"d":" 200000"},{"v":100000,"d":" 100000"},{"v":100000,"d":" 100000"},{"$f":"SUM('تحليل الربحية'!$C18:$E18)","v":{"v":400000,"d":" 400000"}}]
[null,"إجمالي تكلفة المبيعات",{"$f":"SUBTOTAL(109,'تحليل الربحية'!$C$17:$C$18)","v":{"v":1200000,"d":" 1200000"}},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$D$17:$D$18)","v":{"v":1500000,"d":" 1500000"}},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$E$17:$E$18)","v":{"v":1500000,"d":" 1500000"}},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$F$17:$F$18)","v":{"v":4200000,"d":" 4200000"}}]
[null,"هامش الربح الإجمالي",{"$f":"C13-'تحليل الربحية'!$C$19","v":{"v":300000,"d":" 300000 ر.س.‏"}},{"$f":"D13-'تحليل الربحية'!$D$19","v":{"v":300000,"d":" 300000 ر.س.‏"}},{"$f":"E13-'تحليل الربحية'!$E$19","v":{"v":1000000,"d":" 1000000 ر.س.‏"}},{"$f":"F13-'تحليل الربحية'!$F$19","v":{"v":1600000,"d":" 1600000 ر.س.‏"}}]
[null,"القيمة",{"$f":"MAX(0,MIN(1,C20/$F$20))","v":{"v":0.1875,"d":"18.8%"}},{"$f":"MAX(0,MIN(1,D20/$F$20))","v":{"v":0.1875,"d":"18.8%"}},{"v":0.625,"d":"62.5%"},{"$f":"SUM('تحليل الربحية'!$C21:$E21)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"تكاليف أخرى"," ","  ","   ","    "]
[null,"كسب العملاء",{"v":105000,"d":" 105000 ر.س.‏"},{"v":120000,"d":" 120000 ر.س.‏"},{"v":235000,"d":" 235000 ر.س.‏"},{"$f":"SUM('تحليل الربحية'!$C24:$E24)","v":{"v":460000,"d":" 460000 ر.س.‏"}}]
[null,"التسويق لكسب العملاء",{"v":150000,"d":" 150000"},{"v":125000,"d":" 125000"},{"v":275000,"d":" 275000"},{"$f":"SUM('تحليل الربحية'!$C25:$E25)","v":{"v":550000,"d":" 550000 ر.س.‏"}}]
[null,"إنهاء التعامل مع العملاء",{"v":80000,"d":" 80000"},{"v":190000,"d":" 190000"},{"v":140000,"d":" 140000"},{"$f":"SUM('تحليل الربحية'!$C26:$E26)","v":{"v":410000,"d":" 410000 ر.س.‏"}}]
[null,"إجمالي تكاليف العملاء الأخرى",{"$f":"SUBTOTAL(109,'تحليل الربحية'!$C$24:$C$26)","v":{"v":335000,"d":" 335000"}},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$D$24:$D$26)","v":{"v":435000,"d":" 435000"}},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$E$24:$E$26)","v":{"v":650000,"d":" 650000"}},{"$f":"SUBTOTAL(109,'تحليل الربحية'!$F$24:$F$26)","v":{"v":1420000,"d":" 1420000"}}]
[]
[null,"ربح العملاء لكل شريحة",{"$f":"C20-C27","v":{"v":-35000,"d":" (35000 ر.س.‏)"}},{"$f":"D20-D27","v":{"v":-135000,"d":" (135000 ر.س.‏)"}},{"$f":"E20-E27","v":{"v":350000,"d":" 350000 ر.س.‏"}},{"$f":"F20-'تحليل الربحية'!$F$27","v":{"v":180000,"d":" 180000 ر.س.‏"}}]
[null,"القيمة",{"$f":"MAX(0,MIN(1,C29/$F$29))","v":{"v":0,"d":"0.0%"}},{"$f":"MAX(0,MIN(1,D29/$F$29))","v":{"v":0,"d":"0.0%"}},{"v":1,"d":"100.0%"},{"$f":"SUM('تحليل الربحية'!$C30:$E30)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"مقاييس الملخص"]
[null,"متوسط التكلفة لكل عميل تم اكتسابه",{"$f":"C24/C8","v":{"v":52500,"d":" 52500 ر.س.‏"}},{"$f":"D24/D8","v":{"v":30000,"d":" 30000 ر.س.‏"}},{"$f":"E24/E8","v":{"v":58750,"d":" 58750 ر.س.‏"}}]
[null,"متوسط التكلفة لكل عميل تم إنهاء التعامل معه",{"$f":"-C26/C9","v":{"v":80000,"d":" 80000 ر.س.‏"}},{"$f":"-D26/D9","v":{"v":95000,"d":" 95000 ر.س.‏"}},{"$f":"-E26/E9","v":{"v":70000,"d":" 70000 ر.س.‏"}}]
[null,"متوسط تكلفة التسويق لكل عميل نشط",{"$f":"C25/'تحليل الربحية'!$C$10","v":{"v":25000,"d":" 25000 ر.س.‏"}},{"$f":"D25/'تحليل الربحية'!$D$10","v":{"v":12500,"d":" 12500 ر.س.‏"}},{"$f":"E25/'تحليل الربحية'!$E$10","v":{"v":27500,"d":" 27500 ر.س.‏"}}]
[null,"متوسط الربح أو الخسارة لكل عميل",{"$f":"C29/'تحليل الربحية'!$C$10","v":{"v":-5833.333333333333,"d":" (5833 ر.س.‏)"}},{"$f":"D29/'تحليل الربحية'!$D$10","v":{"v":-13500,"d":" (13500 ر.س.‏)"}},{"$f":"E29/'تحليل الربحية'!$E$10","v":{"v":35000,"d":" 35000 ر.س.‏"}}]

{"sheet":"مخطط مقاييس الملخص ","index":1,"n_rows":3,"n_cols":18,"rows_kept":3}
[]
[null,"مقاييس الملخص لكل عميل",{"$nulls":13}," "]
[null,{"$f":"تقريرتاريخ","v":"'20 يناير 2013"},{"$nulls":15},{"$f":"اسمالشركة","v":"اسم الشركة"}]