{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Curva ABC"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Curva ABC","index":0,"n_rows":90,"n_cols":12,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["CLIENTE","VALOR","Acumulado","CLASSIFICAÇÃO",null,null,null,"Categoria","Percentual","Qtde.","Valor","Total"]
["SAVEA",6683.7,{"$f":"B2/SUM($B$2:$B$90)","v":0.10291689488070177},{"$f":"IF(B2>=LARGE($B$2:$B$90,$J$2),$H$2,IF(B2>=LARGE($B$2:$B$90,$J$3),$H$3,$H$4))","v":"A"},null,null,null,"A",0.2,{"$f":"COUNT($B$2:$B$90)*I2","v":17.8},{"$f":"SUMIF(D:D,H2,B:B)","v":40647.79},{"$f":"K2","v":40647.79}]
["ERNSH",6205.39,{"$f":"B3/SUM($B$2:$B$90)+C2","v":0.19846868061670997},"A",null,null,null,"B",{"$f":"0.3","v":0.3},{"$f":"COUNT($B$2:$B$90)*(I3+I2)","v":44.5},{"$f":"SUMIF(D:D,H3,B:B)","v":16944.830000000002},{"$f":"L2+K3","v":57592.62}]
["QUICK",5605.63,{"$f":"B4/SUM($B$2:$B$90)+C3","v":0.28478524680760847},"A",null,null,null,"C",{"$f":"0.5","v":0.5},{"$f":"COUNT($B$2:$B$90)*(I4+I3+I2)","v":89},{"$f":"SUMIF(D:D,H4,B:B)","v":7350.07},{"$f":"L3+K4","v":64942.69}]
["HUNGO",2755.24,{"$f":"B5/SUM($B$2:$B$90)+C4","v":0.32721096092570245},"A"]
["RATTC",2134.21,{"$f":"B6/SUM($B$2:$B$90)+C5","v":0.36007393595799631},"A"]
["QUEEN",1982.7,{"$f":"B7/SUM($B$2:$B$90)+C6","v":0.39060393094280521},"A"]
["FOLKO",1678.08,{"$f":"B8/SUM($B$2:$B$90)+C7","v":0.41644332872568118},"A"]
["BERGS",1559.52,{"$f":"B9/SUM($B$2:$B$90)+C8","v":0.44045711688259309},"A"]
["FRANK",1403.44,{"$f":"B10/SUM($B$2:$B$90)+C9","v":0.46206755525525678},"A"]
["MEREP",1394.22,{"$f":"B11/SUM($B$2:$B$90)+C10","v":0.48353602229904569},"A"]
["BONAP",1357.87,{"$f":"B12/SUM($B$2:$B$90)+C11","v":0.50444476506901714},"A"]
["WHITC",1353.06,{"$f":"B13/SUM($B$2:$B$90)+C12","v":0.52527944253618086},"A"]
["HILAA",1259.1600000000001,{"$f":"B14/SUM($B$2:$B$90)+C13","v":0.54466822978844898},"A"]
["PICCO",1186.1099999999999,{"$f":"B15/SUM($B$2:$B$90)+C14","v":0.56293217912593407},"A"]
["GREAL",1087.6099999999999,{"$f":"B16/SUM($B$2:$B$90)+C15","v":0.5796794065660047},"A"]
["LEHMS",1017.03,{"$f":"B17/SUM($B$2:$B$90)+C16","v":0.59533982962516652},"A"]
["RICSU",1001.29,{"$f":"B18/SUM($B$2:$B$90)+C17","v":0.61075788514457907},"A"]
["OLDWO",983.53,{"$f":"B19/SUM($B$2:$B$90)+C18","v":0.62590246877670153},"A"]
["VAFFE",947.34,{"$f":"B20/SUM($B$2:$B$90)+C19","v":0.64048979184570287},"B"]
["SEVES",913.81,{"$f":"B21/SUM($B$2:$B$90)+C20","v":0.6545608135419092},"B"]
["OTTIK",862.74,{"$f":"B22/SUM($B$2:$B$90)+C21","v":0.66784544958023773},"B"]
["EASTC",832.34,{"$f":"B23/SUM($B$2:$B$90)+C22","v":0.68066198058626781},"B"]
["WARTH",822.48,{"$f":"B24/SUM($B$2:$B$90)+C23","v":0.69332668542063791},"B"]
["SUPRD",821.23,{"$f":"B25/SUM($B$2:$B$90)+C24","v":0.70597214251519314},"B"]
["KOENE",813.68,{"$f":"B26/SUM($B$2:$B$90)+C25","v":0.71850134326126636},"B"]
["BOTTM",793.95,{"$f":"B27/SUM($B$2:$B$90)+C26","v":0.73072673768210106},"B"]
["LILAS",734.41,{"$f":"B28/SUM($B$2:$B$90)+C27","v":0.74203532376007231},"B"]
["HANAR",724.77,{"$f":"B29/SUM($B$2:$B$90)+C28","v":0.75319547126859099},"B"]
["LINOD",673.81,{"$f":"B30/SUM($B$2:$B$90)+C29","v":0.76357092692033568},"B"]
["FOLIG",637.94000000000005,{"$f":"B31/SUM($B$2:$B$90)+C30","v":0.77339404943035184},"B"]
["LAMAI",635.82000000000005,{"$f":"B32/SUM($B$2:$B$90)+C31","v":0.78318452777364189},"B"]
["RICAR",632.95000000000005,{"$f":"B33/SUM($B$2:$B$90)+C32","v":0.79293081330631698},"B"]
["BLONP",623.66,{"$f":"B34/SUM($B$2:$B$90)+C33","v":0.80253404963668762},{"$f":"IF(B34>=LARGE($B$2:$B$90,$J$2),$H$2,IF(B34>=LARGE($B$2:$B$90,$J$3),$H$3,$H$4))","v":"B"}]
["GODOS",568.27,{"$f":"B35/SUM($B$2:$B$90)+C34","v":0.81128438012038029},"B"]
["SPLIR",558.66999999999996,{"$f":"B36/SUM($B$2:$B$90)+C35","v":0.81988688796229447},"B"]
["VICTE",493.25,{"$f":"B37/SUM($B$2:$B$90)+C36","v":0.82748204609325582},"B"]
["TORTU",475.63,{"$f":"B38/SUM($B$2:$B$90)+C37","v":0.8348058880837862},"B"]
["AROUT",471.95,{"$f":"B39/SUM($B$2:$B$90)+C38","v":0.84207306472830157},"B"]
["MAGAA",469.75,{"$f":"B40/SUM($B$2:$B$90)+C39","v":0.84930636535074266},"B"]
["MAISD",458.91,{"$f":"B41/SUM($B$2:$B$90)+C40","v":0.85637274957350895},"B"]
["SIMOB",448.85,{"$f":"B42/SUM($B$2:$B$90)+C41","v":0.86328422798624482},"B"]
["WANDK",432.87,{"$f":"B43/SUM($B$2:$B$90)+C42","v":0.86994964329318702},"B"]
["CHOPS",367.24,{"$f":"B44/SUM($B$2:$B$90)+C43","v":0.87560447526888741},"B"]
["PRINI",364.86,{"$f":"B45/SUM($B$2:$B$90)+C44","v":0.88122265954798029},"B"]
["ISLAT",363.65,{"$f":"B46/SUM($B$2:$B$90)+C45","v":0.88682221201493228},"B"]
["QUEDE",327.55,{"$f":"B47/SUM($B$2:$B$90)+C46","v":0.89186588975602987},"C"]
["GOURL",322.38,{"$f":"B48/SUM($B$2:$B$90)+C47","v":0.89682995884525296},"C"]
["MORGK",322.04000000000002,{"$f":"B49/SUM($B$2:$B$90)+C48","v":0.90178879254924649},"C"]
["REGGC",319.56,{"$f":"B50/SUM($B$2:$B$90)+C49","v":0.90670943873744725},"C"]
["OCEAN",306.64,{"$f":"B51/SUM($B$2:$B$90)+C50","v":0.91143114028692107},"C"]
["DRACD",306.04000000000002,{"$f":"B52/SUM($B$2:$B$90)+C51","v":0.91614360292128372},"C"]
["BSBEV",281.31,{"$f":"B53/SUM($B$2:$B$90)+C52","v":0.92047526827114834},"C"]
["FURIB",278.67,{"$f":"B54/SUM($B$2:$B$90)+C53","v":0.92476628239452385},"C"]
["PERIC",277.95999999999998,{"$f":"B55/SUM($B$2:$B$90)+C54","v":0.92904636380168448},"C"]
["SANTG",275.5,{"$f":"B56/SUM($B$2:$B$90)+C55","v":0.93328856565688945},"C"]
["TRADH",274.56,{"$f":"B57/SUM($B$2:$B$90)+C56","v":0.93751629321175356},"C"]
["ANTON",268.52,{"$f":"B58/SUM($B$2:$B$90)+C57","v":0.94165101568783205},"C"]
["THEBI",262.08999999999997,{"$f":"B59/SUM($B$2:$B$90)+C58","v":0.94568672779030272},"C"]
["FAMIA",232.75,{"$f":"B60/SUM($B$2:$B$90)+C59","v":0.94927065694383794},"C"]
["ALFKI",225.58,{"$f":"B61/SUM($B$2:$B$90)+C60","v":0.95274418106179481},"C"]
["RANCH",219.18,{"$f":"B62/SUM($B$2:$B$90)+C61","v":0.9561191567518994},"C"]
["HUNGC",207.08,{"$f":"B63/SUM($B$2:$B$90)+C62","v":0.95930781432059575},"C"]
["LETSS",202.11,{"$f":"B64/SUM($B$2:$B$90)+C63","v":0.96241994287578803},"C"]
["WELLI",194.71,{"$f":"B65/SUM($B$2:$B$90)+C64","v":0.96541812481127609},"C"]
["BOLID",191.17,{"$f":"B66/SUM($B$2:$B$90)+C65","v":0.96836179714760828},{"$f":"IF(B66>=LARGE($B$2:$B$90,$J$2),$H$2,IF(B66>=LARGE($B$2:$B$90,$J$3),$H$3,$H$4))","v":"C"}]
["COMMI",187.82,{"$f":"B67/SUM($B$2:$B$90)+C66","v":0.97125388554123659},"C"]
["WOLZA",175.74,{"$f":"B68/SUM($B$2:$B$90)+C67","v":0.97395996377729366},"C"]
["FRANR",171.42,{"$f":"B69/SUM($B$2:$B$90)+C68","v":0.97659952182455045},"C"]
["BLAUS",168.26,{"$f":"B70/SUM($B$2:$B$90)+C69","v":0.97919042158555514},"C"]
["THECR",129.96,{"$f":"B71/SUM($B$2:$B$90)+C70","v":0.98119157059863116},"C"]
["TOMSP",125.97,{"$f":"B72/SUM($B$2:$B$90)+C71","v":0.98313128082621792},"C"]
["SPECD",108.28,{"$f":"B73/SUM($B$2:$B$90)+C72","v":0.98479859703994421},"C"]
["ANATR",97.42,{"$f":"B74/SUM($B$2:$B$90)+C73","v":0.98629868889015859},"C"]
["WILMK",88.41,{"$f":"B75/SUM($B$2:$B$90)+C74","v":0.98766004303178712},"C"]
["LACOR",87.49,{"$f":"B76/SUM($B$2:$B$90)+C75","v":0.98900723083691189},"C"]
["LONEP",79.86,{"$f":"B77/SUM($B$2:$B$90)+C76","v":0.99023693043820649},"C"]
["FRANS",75.13,{"$f":"B78/SUM($B$2:$B$90)+C77","v":0.99139379659204152},"C"]
["CACTU",72.760000000000005,{"$f":"B79/SUM($B$2:$B$90)+C78","v":0.9925141690311875},"C"]
["TRAIH",70.010000000000005,{"$f":"B80/SUM($B$2:$B$90)+C79","v":0.99359219644274066},"C"]
["GROSR",67.8,{"$f":"B81/SUM($B$2:$B$90)+C80","v":0.99463619385030111},"C"]
["ROMEY",64.47,{"$f":"B82/SUM($B$2:$B$90)+C81","v":0.99562891527899466},"C"]
["DUMON",63.7,{"$f":"B83/SUM($B$2:$B$90)+C82","v":0.99660978009996215},"C"]
["VINET",58.41,{"$f":"B84/SUM($B$2:$B$90)+C83","v":0.99750918848603298},"C"]
["CONSH",53.62,{"$f":"B85/SUM($B$2:$B$90)+C84","v":0.99833483953313318},"C"]
["GALED",37.979999999999997,{"$f":"B86/SUM($B$2:$B$90)+C85","v":0.99891966285966927},"C"]
["NORTS",37.590000000000003,{"$f":"B87/SUM($B$2:$B$90)+C86","v":0.99949848089138305},"C"]
["LAZYK",19.399999999999999,{"$f":"B88/SUM($B$2:$B$90)+C87","v":0.99979720581331033},"C"]
["LAUGB",9.92,{"$f":"B89/SUM($B$2:$B$90)+C88","v":0.99994995587648139},"C"]
["CENTC",3.25,{"$f":"B90/SUM($B$2:$B$90)+C89","v":1.0000000000000002},"C"]