{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vendas","Seleção","Resumo","Tabela"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vendas","index":0,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["BANCAS LEIA BEM - VENDAS DO MÊS ANTERIOR"]
["Revista","Grupo","B. Vista","Centro","C. Norte","Eldorado","Iguatemi","9 de julho","Paraiso","Paulista","Mínimo","Médio","Máximo","Vendas","Part/V","CMV","Lucro","Part/L"]
["Veja","OUT",3231,2926,2720,2093,1929,1817,1600,1397,{"$f":"MIN($C3:$J3)","v":1397},{"$f":"AVERAGE($C3:$J3)","v":2214.125},{"$f":"MAX($C3:$J3)","v":3231},{"$f":"SUM(C3:J3)","v":17713},{"$f":"N3/$N$23","v":0.12900477040166053},{"$f":"N3*VLOOKUP(Grupo,TAB_GRUPO,2,FALSE)","v":6553.8099999999995},{"$f":"N3-P3","v":11159.19},{"$f":"Q3/$Q$23","v":0.15436201876464622}]
["Capricho","FEM",2443,2135,1950,1551,1467,1334,1127,1323,1127,1666.25,2443,13330,9.7083136083900803E-2,6665,6665,9.2195119454581129E-2]
["Exame","NEG",2587,2279,2195,1663,1519,1425,1281,1211,1211,1770,2587,14160,0.10312807253923746,8920.7999999999993,5239.2000000000007,7.2472418581611631E-2]
["Nova","FEM",1796,1488,1498,1201,1099,994,893,893,893,1232.75,1796,9862,7.1825497978951963E-2,4931,4931,6.8209172397680345E-2]
["Marie Claire","FEM",1743,1642,1572,1159,1089,956,851,739,739,1218.875,1743,9751,7.1017078766250324E-2,4875.5,4875.5,6.7441456099146327E-2]
["Play boy","OUT",1138,935,984,749,686,669,525,532,525,777.25,1138,6218,4.5286042023232949E-2,2300.66,3917.34,5.4187491259446184E-2]
["Ex. Informática","NEG",1764,1561,1498,1127,945,984,914,658,658,1181.375,1764,9451,6.8832161975164785E-2,5954.13,3496.87,4.8371244916300238E-2]
["Mônica","MSP",1047,840,861,749,686,697,553,585,553,752.25,1047,6018,4.3829430829175925E-2,2527.56,3490.44,4.8282300487479092E-2]
["Quatro Rodas","OUT",798,662,694,891,557,729,686,430,430,680.875,891,5447,3.9670805870143114E-2,2015.3899999999999,3431.61,4.7468521211033031E-2]
["Cebolinha","MSP",977,872,812,669,595,595,452,473,452,680.625,977,5445,3.9656239758202538E-2,2286.9,3158.1,4.3685132295500771E-2]
["Alm Disney","WDP",1068,861,903,791,627,648,595,543,543,754.5,1068,6036,4.3960525836641055E-2,2897.2799999999997,3138.7200000000003,4.3417054063688357E-2]
["Mickey","WDP",966,760,791,707,658,595,410,574,410,682.625,966,5461,3.9772768653727107E-2,2621.2799999999997,2839.7200000000003,3.9281068959874439E-2]
["Tio Patinhas","WDP",994,791,728,686,658,595,410,515,410,672.125,994,5377,3.9160991952223154E-2,2580.96,2796.04,3.8676855483839007E-2]
["Magali","MSP",749,648,676,553,515,420,371,410,371,542.75,749,4342,3.162302902297804E-2,1823.6399999999999,2518.36,3.483578410047096E-2]
["Cascão","MSP",686,585,595,494,420,308,399,308,308,474.375,686,3795,2.7639197407232075E-2,1593.8999999999999,2201.1000000000004,3.04472134180763E-2]
["Pato Donald","WDP",697,595,606,420,441,504,319,494,319,509.5,697,4076,2.9685736134882196E-2,1956.48,2119.52,2.9318739622861783E-2]
["Chico Bento","MSP",525,420,462,371,340,308,277,308,277,376.375,525,3011,2.1929281526528531E-2,1264.6199999999999,1746.38,2.4157196206015211E-2]
["Zé Carioca","WDP",585,389,420,319,410,329,256,504,256,401.5,585,3212,2.3393175776555843E-2,1541.76,1670.24,2.3103972440783133E-2]
["Video News","OUT",431,494,319,350,235,207,217,186,186,304.875,494,2439,1.7763373511525436E-2,902.43,1536.5700000000002,2.1254951943034617E-2]
["Placar","OUT",308,308,329,224,266,256,235,235,224,270.125,329,2161,1.5738683951786171E-2,799.56999999999994,1361.43,1.8832288293931042E-2]
["TOTAL",{"$f":"SUM(C23:J23)","v":137305},{"$f":"SUM(C3:C22)","v":24533},21191,20613,16767,15142,14370,12371,12318,null,null,null,{"$f":"SUM(N3:N22)","v":137305},null,{"$f":"SUM(P3:P22)","v":65012.670000000006},{"$f":"SUM(Q3:Q22)","v":72292.330000000016}]
[null,null,{"$f":"C23/$B$23","v":0.17867521211900514},0.15433523906631222,0.15012563271548743,0.1221149994537708,0.11028003350205746,0.10465751429299734,9.0098685408397369E-2,8.9712683441972252E-2]

{"sheet":"Seleção","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Vendas!B2","v":"Grupo"},"Lucro"]
[null,"FEM",">4000"]
[null,"OUT",">7000"]
[]
[{"$f":"Vendas!A2","v":"Revista"},{"$f":"Vendas!B2","v":"Grupo"},{"$f":"Vendas!C2","v":"B. Vista"},{"$f":"Vendas!D2","v":"Centro"},{"$f":"Vendas!E2","v":"C. Norte"},{"$f":"Vendas!F2","v":"Eldorado"},{"$f":"Vendas!G2","v":"Iguatemi"},{"$f":"Vendas!H2","v":"9 de julho"},{"$f":"Vendas!I2","v":"Paraiso"},{"$f":"Vendas!J2","v":"Paulista"},{"$f":"Vendas!N2","v":"Vendas"},{"$f":"Vendas!P2","v":"CMV"},{"$f":"Vendas!Q2","v":"Lucro"}]
["Veja","OUT",3231,2926,2720,2093,1929,1817,1600,1397,17713,6553.8099999999995,11159.19]
["Capricho","FEM",2443,2135,1950,1551,1467,1334,1127,1323,13330,6665,6665]
["Nova","FEM",1796,1488,1498,1201,1099,994,893,893,9862,4931,4931]
["Marie Claire","FEM",1743,1642,1572,1159,1089,956,851,739,9751,4875.5,4875.5]

{"sheet":"Resumo","index":2,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["DESCRIÇÃO","GRUPO",{"$f":"Vendas!C2","v":"B. Vista"},{"$f":"Vendas!D2","v":"Centro"},{"$f":"Vendas!E2","v":"C. Norte"},{"$f":"Vendas!F2","v":"Eldorado"},{"$f":"Vendas!G2","v":"Iguatemi"},{"$f":"Vendas!H2","v":"9 de julho"},{"$f":"Vendas!I2","v":"Paraiso"},{"$f":"Vendas!J2","v":"Paulista"},"Vendas","Part/V"]
["Revistas Femininas","FEM",{"$f":"DSUM(BDADOS,Resumo!C$2,$B$2:$B$3)","v":5982},{"$f":"DSUM(BDADOS,Resumo!D$2,$B$2:$B$3)","v":5265},{"$f":"DSUM(BDADOS,Resumo!E$2,$B$2:$B$3)","v":5020},{"$f":"DSUM(BDADOS,Resumo!F$2,$B$2:$B$3)","v":3911},{"$f":"DSUM(BDADOS,Resumo!G$2,$B$2:$B$3)","v":3655},{"$f":"DSUM(BDADOS,Resumo!H$2,$B$2:$B$3)","v":3284},{"$f":"DSUM(BDADOS,Resumo!I$2,$B$2:$B$3)","v":2871},{"$f":"DSUM(BDADOS,Resumo!J$2,$B$2:$B$3)","v":2955},{"$f":"SUM(C3:J3)","v":32943},{"$f":"K3/$K$8","v":0.2399257128291031}]
["Maurício de Souza","MSP",{"$f":"DSUM(BDADOS,Resumo!C$2,$B$2:$B$4)-C3","v":3984},{"$f":"DSUM(BDADOS,Resumo!D$2,$B$2:$B$4)-D3","v":3365},{"$f":"DSUM(BDADOS,Resumo!E$2,$B$2:$B$4)-E3","v":3406},{"$f":"DSUM(BDADOS,Resumo!F$2,$B$2:$B$4)-F3","v":2836},{"$f":"DSUM(BDADOS,Resumo!G$2,$B$2:$B$4)-G3","v":2556},{"$f":"DSUM(BDADOS,Resumo!H$2,$B$2:$B$4)-H3","v":2328},{"$f":"DSUM(BDADOS,Resumo!I$2,$B$2:$B$4)-I3","v":2052},{"$f":"DSUM(BDADOS,Resumo!J$2,$B$2:$B$4)-J3","v":2084},{"$f":"SUM(C4:J4)","v":22611},{"$f":"K4/$K$8","v":0.16467717854411712}]
["Negócios","NEG",{"$f":"DSUM(BDADOS,Resumo!C$2,$B$2:$B$5)-C3-C4","v":4351},{"$f":"DSUM(BDADOS,Resumo!D$2,$B$2:$B$5)-D3-D4","v":3840},{"$f":"DSUM(BDADOS,Resumo!E$2,$B$2:$B$5)-E3-E4","v":3693},{"$f":"DSUM(BDADOS,Resumo!F$2,$B$2:$B$5)-F3-F4","v":2790},{"$f":"DSUM(BDADOS,Resumo!G$2,$B$2:$B$5)-G3-G4","v":2464},{"$f":"DSUM(BDADOS,Resumo!H$2,$B$2:$B$5)-H3-H4","v":2409},{"$f":"DSUM(BDADOS,Resumo!I$2,$B$2:$B$5)-I3-I4","v":2195},{"$f":"DSUM(BDADOS,Resumo!J$2,$B$2:$B$5)-J3-J4","v":1869},23611,0.17196023451440223]
["Disney","WDP",{"$f":"DSUM(BDADOS,Resumo!C$2,$B$2:$B$6)-C3-C4-C5","v":4310},{"$f":"DSUM(BDADOS,Resumo!D$2,$B$2:$B$6)-D3-D4-D5","v":3396},{"$f":"DSUM(BDADOS,Resumo!E$2,$B$2:$B$6)-E3-E4-E5","v":3448},{"$f":"DSUM(BDADOS,Resumo!F$2,$B$2:$B$6)-F3-F4-F5","v":2923},{"$f":"DSUM(BDADOS,Resumo!G$2,$B$2:$B$6)-G3-G4-G5","v":2794},{"$f":"DSUM(BDADOS,Resumo!H$2,$B$2:$B$6)-H3-H4-H5","v":2671},{"$f":"DSUM(BDADOS,Resumo!I$2,$B$2:$B$6)-I3-I4-I5","v":1990},{"$f":"DSUM(BDADOS,Resumo!J$2,$B$2:$B$6)-J3-J4-J5","v":2630},24162,0.17597319835402936]
["Outros","OUT",{"$f":"DSUM(BDADOS,Resumo!C$2,$B$2:$B$7)-C3-C4-C5-C6","v":5906},{"$f":"DSUM(BDADOS,Resumo!D$2,$B$2:$B$7)-D3-D4-D5-D6","v":5325},{"$f":"DSUM(BDADOS,Resumo!E$2,$B$2:$B$7)-E3-E4-E5-E6","v":5046},{"$f":"DSUM(BDADOS,Resumo!F$2,$B$2:$B$7)-F3-F4-F5-F6","v":4307},{"$f":"DSUM(BDADOS,Resumo!G$2,$B$2:$B$7)-G3-G4-G5-G6","v":3673},{"$f":"DSUM(BDADOS,Resumo!H$2,$B$2:$B$7)-H3-H4-H5-H6","v":3678},{"$f":"DSUM(BDADOS,Resumo!I$2,$B$2:$B$7)-I3-I4-I5-I6","v":3263},{"$f":"DSUM(BDADOS,Resumo!J$2,$B$2:$B$7)-J3-J4-J5-J6","v":2780},33978,0.24746367575834821]
[null,"Total por banca",{"$f":"SUM(C3:C7)","v":24533},{"$f":"SUM(D3:D7)","v":21191},20613,16767,15142,14370,12371,12318,{"$f":"SUM(K3:K7)","v":137305},{"$f":"SUM(L3:L7)","v":1}]

{"sheet":"Tabela","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["DESCRIÇÃO","GRUPO","% CUSTO"]
["Revistas Femininas","FEM",0.5]
["Maurício de Souza","MSP",0.42]
["Negócios","NEG",0.63]
["Disney","WDP",0.48]
["Outros","OUT",0.37]