{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":35,"n_cols":16,"rows_kept":35,"merged":[[0,5,0,7],[0,8,0,10],[0,11,0,12],[0,13,0,15],[3,0,10,0],[4,1,5,1],[6,1,10,1],[15,2,21,6],[24,5,24,7],[24,8,24,10],[24,11,24,12],[24,13,24,15],[25,5,25,7],[25,8,25,10],[25,11,25,13],[25,14,25,16],[27,0,34,0],[28,1,29,1],[30,1,34,1]],"flags":["formulas_cached_only"]}
[{"$nulls":3},"SUPERGROUP","Total","VITAMINS / MINERALS / NUTRIENTS",null,null,"NEURO / CNS",null,null,"OPHTHAL / OTOLOGICALS",null,"CARDIAC"]
["CORPORATE","ACUTE/CHRONIC","Launch Date","BRAND",null,"NUSAM","CONSEVEL","TRINORM","OPIPROL","PANAZEP","DONETAZ","NORMO TEARS","GATILOX DF","OLMEZEST CH","ADPEP R","THROMBONIL"]
["Total",{"$nulls":3},{"v":1869.786886,"d":"1,869.8"},{"v":532.1769558,"d":"532.2"},{"v":125.58234980000002,"d":"125.6"},{"v":15.203534600000001,"d":"15.2"},{"v":119.76872850000001,"d":"119.8"},{"v":111.07057850000002,"d":"111.1"},{"v":55.909413900000004,"d":"55.9"},{"v":126.5331046,"d":"126.5"},{"v":43.6389426,"d":"43.6"},{"v":161.0753268,"d":"161.1"},{"v":0.44720000000000004,"d":"0.4"},{"v":0.0031008000000000008,"d":"0.0"}]
["SUN","Total",null,null,{"v":1869.786886,"d":"1,869.8"},{"v":532.1769558,"d":"532.2"},{"v":125.58234980000002,"d":"125.6"},{"v":15.203534600000001,"d":"15.2"},{"v":119.76872850000001,"d":"119.8"},{"v":111.07057850000002,"d":"111.1"},{"v":55.909413900000004,"d":"55.9"},{"v":126.5331046,"d":"126.5"},{"v":43.6389426,"d":"43.6"},{"v":161.0753268,"d":"161.1"},{"v":0.44720000000000004,"d":"0.4"},{"v":0.0031008000000000008,"d":"0.0"}]
[null,"CHRONIC","2013-05-01",null,{"v":0.6907152,"d":"0.7"},"-","-","-","-","-",{"v":0.24041440000000006,"d":"0.2"},"-","-","-",{"v":0.44720000000000004,"d":"0.4"},{"v":0.0031008000000000008,"d":"0.0"}]
[null,null,"2013-04-01",null,{"v":618.1703027,"d":"618.2"},"-","-","-",{"v":119.76872850000001,"d":"119.8"},{"v":111.07057850000002,"d":"111.1"},{"v":55.6689995,"d":"55.7"},"-","-",{"v":161.0753268,"d":"161.1"},"-","-"]
[null,"ACUTE","2013-05-01",null,{"v":0.1756977,"d":"0.2"},"-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"2013-04-01",null,{"v":920.6469341999999,"d":"920.6"},{"v":532.1769558,"d":"532.2"},{"v":125.58234980000002,"d":"125.6"},"-","-","-","-",{"v":126.5331046,"d":"126.5"},{"v":43.6389426,"d":"43.6"},"-","-","-"]
[null,null,"2013-06-01",null,{"v":7.053321600000001,"d":"7.1"},"-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"2013-07-01",null,{"v":307.84638,"d":"307.8"},"-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"2013-08-01",null,{"v":15.203534600000001,"d":"15.2"},"-","-",{"v":15.203534600000001,"d":"15.2"},"-","-","-","-","-","-","-","-"]
[]
[]
[]
[]
[null,null,"Each supergroup has certain number of brands which is  a dimension this is data about brands launched in a certain period, i have a requiremnt that i need to show the count......when i use count(distinct brand) it shows total brand count irrespective of date so i need the count in that particular launch period....."]
[]
[]
[]
[]
[]
[]
[null,null,"The Report requirement is as follows"]
[]
[{"$nulls":3},"SUPERGROUP","Total","VITAMINS / MINERALS / NUTRIENTS",null,null,"NEURO / CNS",null,null,"OPHTHAL / OTOLOGICALS",null,"CARDIAC"]
["CORPORATE","ACUTE/CHRONIC","Launch Date","BRAND",null,3,null,null,3,null,null,3,null,null,2]
["Total",{"$nulls":3},{"v":1869.786886,"d":"1,869.8"},{"v":532.1769558,"d":"532.2"},{"v":125.58234980000002,"d":"125.6"},{"v":15.203534600000001,"d":"15.2"},{"v":119.76872850000001,"d":"119.8"},{"v":111.07057850000002,"d":"111.1"},{"v":55.909413900000004,"d":"55.9"},{"v":126.5331046,"d":"126.5"},{"v":43.6389426,"d":"43.6"},{"v":161.0753268,"d":"161.1"},{"v":0.44720000000000004,"d":"0.4"},{"v":0.0031008000000000008,"d":"0.0"}]
["SUN","Total",null,null,{"v":1869.786886,"d":"1,869.8"},{"v":532.1769558,"d":"532.2"},{"v":125.58234980000002,"d":"125.6"},{"v":15.203534600000001,"d":"15.2"},{"v":119.76872850000001,"d":"119.8"},{"v":111.07057850000002,"d":"111.1"},{"v":55.909413900000004,"d":"55.9"},{"v":126.5331046,"d":"126.5"},{"v":43.6389426,"d":"43.6"},{"v":161.0753268,"d":"161.1"},{"v":0.44720000000000004,"d":"0.4"},{"v":0.0031008000000000008,"d":"0.0"}]
[null,"CHRONIC","2013-05-01",null,{"v":0.6907152,"d":"0.7"},"-","-","-","-","-",{"v":0.24041440000000006,"d":"0.2"},"-","-","-",{"v":0.44720000000000004,"d":"0.4"},{"v":0.0031008000000000008,"d":"0.0"}]
[null,null,"2013-04-01",null,{"v":618.1703027,"d":"618.2"},"-","-","-",{"v":119.76872850000001,"d":"119.8"},{"v":111.07057850000002,"d":"111.1"},{"v":55.6689995,"d":"55.7"},"-","-",{"v":161.0753268,"d":"161.1"},"-","-"]
[null,"ACUTE","2013-05-01",null,{"v":0.1756977,"d":"0.2"},"-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"2013-04-01",null,{"v":920.6469341999999,"d":"920.6"},{"v":532.1769558,"d":"532.2"},{"v":125.58234980000002,"d":"125.6"},"-","-","-","-",{"v":126.5331046,"d":"126.5"},{"v":43.6389426,"d":"43.6"},"-","-","-"]
[null,null,"2013-06-01",null,{"v":7.053321600000001,"d":"7.1"},"-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"2013-07-01",null,{"v":307.84638,"d":"307.8"},"-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"2013-08-01",null,{"v":15.203534600000001,"d":"15.2"},"-","-",{"v":15.203534600000001,"d":"15.2"},"-","-","-","-","-","-","-","-"]