{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["लाभक्षमता विश्लेषण","सारांश मैट्रिक्स चार्ट"],"not_rendered":{"charts":1,"defined_names":5},"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":{"v":21,"d":"21 "}}]
[null,"जोड़े गए ग्राहकों की संख्या",2,4,4,{"$f":"SUM(C8:E8)","v":{"v":10,"d":"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":"रु 1,500,000"},{"v":1800000,"d":"रु 1,800,000"},{"v":2500000,"d":"रु 2,500,000"},{"$f":"SUM('लाभक्षमता विश्लेषण'!$C13:$E13)","v":{"v":5800000,"d":"रु 5,800,000"}}]
[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":"रु 1,000,000"},{"v":1400000,"d":"रु 1,400,000"},{"v":1400000,"d":"रु 1,400,000"},{"$f":"SUM('लाभक्षमता विश्लेषण'!$C17:$E17)","v":{"v":3800000,"d":"रु 3,800,000"}}]
[null,"अन्य प्रत्यक्ष ग्राहक लागत",{"v":200000,"d":"200,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"$f":"SUM('लाभक्षमता विश्लेषण'!$C18:$E18)","v":{"v":400000,"d":"400,000 "}}]
[null,"कुल बिक्री की लागत",{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$C$17:$C$18)","v":{"v":1200000,"d":"1,200,000 "}},{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$D$17:$D$18)","v":{"v":1500000,"d":"1,500,000 "}},{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$E$17:$E$18)","v":{"v":1500000,"d":"1,500,000 "}},{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$F$17:$F$18)","v":{"v":4200000,"d":"4,200,000 "}}]
[null,"सकल मार्जिन",{"$f":"C13-'लाभक्षमता विश्लेषण'!$C$19","v":{"v":300000,"d":"रु 300,000"}},{"$f":"D13-'लाभक्षमता विश्लेषण'!$D$19","v":{"v":300000,"d":"रु 300,000"}},{"$f":"E13-'लाभक्षमता विश्लेषण'!$E$19","v":{"v":1000000,"d":"रु 1,000,000"}},{"$f":"F13-'लाभक्षमता विश्लेषण'!$F$19","v":{"v":1600000,"d":"रु 1,600,000"}}]
[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":"रु 105,000"},{"v":120000,"d":"रु 120,000"},{"v":235000,"d":"रु 235,000"},{"$f":"SUM('लाभक्षमता विश्लेषण'!$C24:$E24)","v":{"v":460000,"d":"रु 460,000"}}]
[null,"ग्राहक विपणन",{"v":150000,"d":"150,000 "},{"v":125000,"d":"125,000 "},{"v":275000,"d":"275,000 "},{"$f":"SUM('लाभक्षमता विश्लेषण'!$C25:$E25)","v":{"v":550000,"d":"$550,000"}}]
[null,"ग्राहक निष्कासन",{"v":80000,"d":"80,000 "},{"v":190000,"d":"190,000 "},{"v":140000,"d":"140,000 "},{"$f":"SUM('लाभक्षमता विश्लेषण'!$C26:$E26)","v":{"v":410000,"d":"$410,000"}}]
[null,"कुल अन्य ग्राहक लागतें",{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$C$24:$C$26)","v":{"v":335000,"d":"335,000 "}},{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$D$24:$D$26)","v":{"v":435000,"d":"435,000 "}},{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$E$24:$E$26)","v":{"v":650000,"d":"650,000 "}},{"$f":"SUBTOTAL(109,'लाभक्षमता विश्लेषण'!$F$24:$F$26)","v":{"v":1420000,"d":"1,420,000 "}}]
[]
[null,"अनुभाग के आधार पर ग्राहक लाभ",{"$f":"C20-C27","v":{"v":-35000,"d":"(रु 35,000)"}},{"$f":"D20-D27","v":{"v":-135000,"d":"(रु 135,000)"}},{"$f":"E20-E27","v":{"v":350000,"d":"रु 350,000"}},{"$f":"F20-'लाभक्षमता विश्लेषण'!$F$27","v":{"v":180000,"d":"रु 180,000"}}]
[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":"रु 52,500"}},{"$f":"D24/D8","v":{"v":30000,"d":"रु 30,000"}},{"$f":"E24/E8","v":{"v":58750,"d":"रु 58,750"}}]
[null,"प्रति स्थगित ग्राहक के लिए औसत लागत",{"$f":"-C26/C9","v":{"v":80000,"d":"रु 80,000"}},{"$f":"-D26/D9","v":{"v":95000,"d":"रु 95,000"}},{"$f":"-E26/E9","v":{"v":70000,"d":"रु 70,000"}}]
[null,"प्रति सक्रिय ग्राहक के लिए औसत विपणन लागत",{"$f":"C25/'लाभक्षमता विश्लेषण'!$C$10","v":{"v":25000,"d":"रु 25,000"}},{"$f":"D25/'लाभक्षमता विश्लेषण'!$D$10","v":{"v":12500,"d":"रु 12,500"}},{"$f":"E25/'लाभक्षमता विश्लेषण'!$E$10","v":{"v":27500,"d":"रु 27,500"}}]
[null,"प्रति ग्राहक के लिए औसत लाभ या हानि",{"$f":"C29/'लाभक्षमता विश्लेषण'!$C$10","v":{"v":-5833.333333333333,"d":"(रु 5,833.33)"}},{"$f":"D29/'लाभक्षमता विश्लेषण'!$D$10","v":{"v":-13500,"d":"(रु 13,500.00)"}},{"$f":"E29/'लाभक्षमता विश्लेषण'!$E$10","v":{"v":35000,"d":"रु 35,000.00"}}]

{"sheet":"सारांश मैट्रिक्स चार्ट","index":1,"n_rows":3,"n_cols":18,"rows_kept":3}
[]
[null,"प्रति ग्राहक सारांश मैट्रिक्स",{"$nulls":13}," "]
[null,{"$f":"ReportDate","v":"20 जनवरी 2013"},{"$nulls":15},{"$f":"CompanyName","v":"कंपनी का नाम"}]