{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["CÁLC. ICMS ST e CRÉD.OUTORG.","CÁLC. ICMS ST OUTROS PRODUTOS","GNRE","Supérfluos","RESUMO APURAÇÃO ICMS ST","LEGENDA","História","LISTA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"comments":3,"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":"CÁLC. ICMS ST e CRÉD.OUTORG.","index":0,"n_rows":9,"n_cols":33,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Período:","  __ /____"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inscrição Estadual:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cidade:",null,null,null,null,null,"CNPJ:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V9:V1048576)","v":0},{"$f":"SUM(W9:W1048576)","v":0},null,null,{"$f":"SUM(Z9:Z1048576)","v":0},0,0,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"}]
["ANO","MÊS","DATA","CHAVE DE ACESSO","Nº NF","RAZÃO REMTE","CNPJ REMTE","UF REMTE","CÓD. NCM","CÓD. EAN/ GTIN TRIB.","CÓD. CFOP","CÓD. PRODUTO (NF ORIGEM)","Nº ITEM","DESCRIÇÃO PRODUTO","UNID.","QTDE","VLR UNIT TRIB.","FRETE","SEGURO","OUTRAS DESPESAS ACESSÓRIAS","DESCONTO","BC ICMS (ORIGEM)","VLR ICMS (ORIGEM)","PMC","MOD. BC ICMS ST","BC ICMS ST RETIDO","VLR ICMS ST RETIDO","BC ICMS ST APURADO","VLR ICMS ST APURADO","CRÉDITO OUTORGADO É DEVIDO? (S ou N)","CALC. 1","CALC. 2","CRÉD. OUTORG."]
[null," "," "," "," "," "," "," "," "," ",null," "," "," "," ",null,null,null,null,null,null,null,null,null,null," ","  ",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9))","v":0},{"$f":"IF(AND(AD9=\"S\",W9/V9>0.07),(AB9*0.17)-(V9*0.07),(AB9*0.17)-(W9))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(H9<>\"MS\",Y9=0),\"S\",\"N\")","v":"S"},{"$f":"IF(AD9=\"S\",(((P9*Q9)+R9+S9+T9-U9)*1.983*0.153)-(V9*0.07),\"\")","v":0},{"$f":"IF(AD9=\"S\",(P9*X9*0.6*0.153)-(V9*0.07),\"\")","v":0},{"$f":"IF(AD9=\"S\",IF(AC9-MAX(AE9:AF9)>0,AC9-MAX(AE9:AF9),\"\"),\"\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"CÁLC. ICMS ST OUTROS PRODUTOS","index":1,"n_rows":9,"n_cols":29,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Período:","  __ /____"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contribuinte:",null,null,null,null,null,null,"Inscrição Estadual:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cidade:",null,null,null,null,null,null,"CNPJ:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V9:V1048576)","v":0},{"$f":"SUM(W9:W1048576)","v":0},null,null,{"$f":"SUM(Z9:Z1048576)","v":0},{"$f":"SUM(AA9:AA1048576)","v":0},{"$f":"SUM(AB9:AB1048576)","v":0},{"$f":"SUM(AC9:AC1048576)","v":0}]
["ANO","MÊS","DATA","CHAVE DE ACESSO","Nº NF","RAZÃO REMTE","CNPJ REMTE","UF REMTE","CÓD. NCM","CÓD. EAN/ GTIN TRIB.","CÓD. CFOP","CÓD. PRODUTO (NF ORIGEM)","Nº ITEM","DESCRIÇÃO PRODUTO","UNID.","QTDE","VLR UNIT TRIB.","FRETE","SEGURO","OUTRAS DESPESAS ACESSÓRIAS","DESCONTO","BC ICMS (ORIGEM)","VLR ICMS (ORIGEM)","MOD. BC ICMS ST","MVA","BC ICMS ST RETIDO","VLR ICMS ST RETIDO","BC ICMS ST APURADO","VLR ICMS ST APURADO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(P9*Q9+R9+S9+T9)*(1+Y9)","v":0},{"$f":"IF(ISBLANK(VLOOKUP(I9,'[1]Supérfluos '!A$1:A$15,1,0)),AC9*0.17-W9,AC9*0.2-W9)","v":0}]

{"sheet":"GNRE","index":2,"n_rows":140,"n_cols":28,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOMA DAS GNRE ",null,{"$f":"SUM(AB:AB)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N. GNRE","DATA PGTO","RAZÃO SOCIAL DO CONTRIBUINTE EMITENTE","CNPJ DO CONTRIBUINTE EMITENTE","UF DO CONTRIBUINTE EMITENTE ","CHAVE DE ACESSO","Nº NF","VALOR GNRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA3>0,AA3/COUNTIF(T:T,T3),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA35>0,AA35/COUNTIF(T:T,T35),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA67>0,AA67/COUNTIF(T:T,T67),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA99>0,AA99/COUNTIF(T:T,T99),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA131>0,AA131/COUNTIF(T:T,T131),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Supérfluos","index":3,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[12119090]
[12119090]
[3301]
[33030010]
[33030020]
[33041000]
[33042010]
[33042090]
[33043000]
[33049100]
[33049910]
[33049990]
[33052000]
[33053000]
[33059000]
[33059000]
[33059000]
[33073000]

{"sheet":"RESUMO APURAÇÃO ICMS ST","index":4,"n_rows":8,"n_cols":30,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,27,0,29]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apuração ICMS ST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.","BC ICMS ST APURADO",{"$f":"'CÁLC. ICMS ST OUTROS PRODUTOS'!AB7+'CÁLC. ICMS ST e CRÉD.OUTORG.'!AB7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.","VLR ICMS ST APURADO",{"$f":"SUM('CÁLC. ICMS ST e CRÉD.OUTORG.'!AC7+'CÁLC. ICMS ST OUTROS PRODUTOS'!AC7)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.","SALDO CREDOR DO PERÍODO ANTERIOR EM FAVOR DO ESTABELECIMENTO (QUANDO EXISTENTE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.","CRÉDITO OUTORGADO APURADO",{"$f":"SUM('CÁLC. ICMS ST e CRÉD.OUTORG.'!AG7)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GNRE PAGAS NO PERÍODO",{"$f":"GNRE!AB1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.","ICMS ST A RECOLHER",{"$f":"IF((AD3-AD4-AD5-AD6)>0,AD3-AD4-AD5-AD6,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.","SALDO CREDOR EM FAVOR DO ESTABELECIMENTO A TRANSPORTAR PARA O PERÍODO SEGUINTE",{"$f":"IF((AD3-AD4-AD5-AD6)<0,(AD3-AD4-AD5-AD6)*-1,0)","v":{"$error":"#VALUE!"}}]

{"sheet":"LEGENDA","index":5,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["OBS.: As informações prestadas referem-se sempre ao item da NF-e, sendo prestadas por produto e não por documento fiscal."]
["ANO","Ano de emissão da Nota Fiscal"]
["MÊS","Mês de emissão da Nota Fiscal"]
["DATA","Data de emissão da Nota Fiscal"]
["CHAVE DE ACESSO","Chave de acesso da Nota Fiscal"]
["Nº NF","Número da Nota Fiscal"]
["RAZÃO REMTE","Razão social do estabelecimento emitente da nota fiscal"]
["CNPJ REMTE","CNPJ do estabelecimento emitente da nota fiscal"]
["UF REMTE","Unidade federada do estabelecimento emitente da nota fiscal"]
["CÓD. NCM","Código NCM do item da nota fiscal"]
["CÓD. EAN/ GTIN TRIB.","Código EAN/GTIN tributário, e não comercial, do item da nota fiscal"]
["CÓD. CFOP","Código CFOP da operação relativa ao item da nota fiscal"]
["CÓD. PRODUTO (NF ORIGEM)","Código do produto relativo ao item da nota fiscal"]
["Nº ITEM","Número do item conforme a nota fiscal de aquisição"]
["DESCRIÇÃO PRODUTO","Descrição do produto conforme o item da nota fiscal"]
["UNID.","Unidade tributável"]
["QTDE","Quantidade tributável"]
["VLR UNIT TRIB.","Valor unitário tributável"]
["FRETE","Valor unitário do frete quando preenchido na NF-e"]
["SEGURO","Valor unitário do seguro quando preenchido na NF-e"]
["OUTRAS DESPESAS ACESSÓRIAS","Valor unitário das outras despesas acessórias quando preenchido na NF-e"]
["DESCONTO","Valor unitário do desconto aplicado ao item"]
["BC ICMS (ORIGEM)","Base de cálculo  do ICMS operação própria do remetente relativa ao item"]
["VLR ICMS (ORIGEM)","Valor do ICMS operação própria do remetente relativo ao item"]
["PMC","Valor do preço máximo de venda a consumidor sugerido ao público pelo estabelecimento fornecedor, industrial ou importador, publicado pela ABCFARMA ou constante em relação por ele fornecida."]
["MOD. BC ICMS ST","Modalidade da base de cálculo do ICMS devido por substituição tributária nos moldes do item 179 do Manual de Orientação ao contribuinte: 0 - PMC, 1 - LISTA NEGATIVA, 2 - LISTA POSITIVA, 3 - LISTA NEUTRA e 4 - MVA"]
["BC ICMS ST RETIDO","Valor da base de cálculo do ICMS retido relativo ao item no documento fiscal a título de ICMS substituição tributária"]
["VLR ICMS ST RETIDO","Valor do ICMS retido relativo ao item no documento fiscal a título de ICMS substituição tributária"]
["BC ICMS ST APURADO","Refere-se à base de cálculo do ICMS devido por substituição tributária relativo ao item quando o contribuinte declarante for responsável pela apuração e pagamento do imposto (nos casos em que o remetente ou não for inscrito no cadastro de contribuintes de MS, ou não efetuar a retenção no documento fiscal de aquisição)."]
["VLR ICMS ST APURADO","Refere-se ao valor do ICMS devido por substituição tributária relativo ao item quando o contribuinte declarante for responsável pela apuração e pagamento do imposto (nos casos em que o remetente ou não for inscrito no cadastro de contribuintes de MS, ou não efetuar a retenção no documento fiscal de aquisição)."]
["CRÉDITO OUTORGADO É DEVIDO? (S ou N)","Preencher com \"S\" para SIM e \"N\" para \"NÃO\", conforme tenham ou não sido preenchidos os requisitos constantes no §4º do art. 5º desta portaria."]
["CALC. 1","Resultado do cálculo previsto no inc. I do §2º do art. 1º do decreto nº 12.415/2007. Somente deve ser preenchido se preenchido \"S\" na pergunta \"Crédito outorgado é devido?\"."]
["CALC. 2","Resultado do cálculo previsto no inc. II do §2º do art. 1º do decreto nº 12.415/2007. Somente deve ser preenchido se preenchido \"S\" na pergunta \"Crédito outorgado é devido?\"."]
["CRÉD. OUTORG.","Valor previsto no caput do §2º do art. 1º do decreto nº 12.415/2007. Somente deve ser preenchido se preenchido \"S\" na pergunta \"Crédito outorgado é devido?\"."]
["MVA","Margem de valor agregado a ser utilizada no cálculo do ICMS ST devido, conforme percentuais fixados no subanexo único ao anexo III ao Regulamento do ICMS-MS."]
["SALDO CREDOR DO PERÍODO ANTERIOR EM FAVOR DO ESTABELECIMENTO (QUANDO EXISTENTE)","Preencher somente quando a empresa tiver acumulado crédito no período anterior e este montante puder ser utilizado para a compensação com o ICMS ST devido no período."]
["CRÉDITO OUTORGADO APURADO","Montante total do crédito outorgado apurado no período, conforme previsto no caput do §2º do art. 1º do decreto nº 12.415/2007. É O SOMATÓRIO DA COLUNA \"AG\" DA ABA \"CÁLC. ICMS ST e CRÉD.OUTORG.\"."]
["ICMS ST A RECOLHER","É a diferença entre o montante total do ICMS ST apurado no período e o montante total do crédito outorgado apurado no período."]
["SALDO CREDOR EM FAVOR DO ESTABELECIMENTO A TRANSPORTAR PARA O PERÍODO SEGUINTE","Refere-se ao crédito acumulado no período a ser transportado para o período seguinte, em virtude de o montante de créditos acumulados em períodos anteriores e no período serem superiores ao débitos apurados no período."]

{"sheet":"História","index":6,"n_rows":112,"n_cols":5,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
["DIA E HORA","PLANILHA ALTERADA","USUÁRIO DE REDE","ENDEREÇO","NOVO VALOR"]
["2014-07-17T08:54:14","GNRE","scarvalho","$AC$3:$AC$5","Valores Alterados"]
["2016-07-27T09:47:37","CÁLC. ICMS ST e CRÉD.OUTORG.","scbarbosa","$AC$10",{"$f":"(AB10*0.17)-(V10*0.07)","v":0}]
["2016-07-27T09:47:40","CÁLC. ICMS ST e CRÉD.OUTORG.","scbarbosa","$AC$11:$AC$101","Valores Alterados"]
["2017-02-13T09:32:25","CÁLC. ICMS ST OUTROS PRODUTOS","jsouza","$AC$10",{"$f":"IF(ISBLANK(VLOOKUP(I9,'[1]Supérfluos '!A$1:A$15,1,0)),AC9*0.17-W9,AC9*0.2-W9)","v":0}]
["2017-02-13T09:38:35","CÁLC. ICMS ST OUTROS PRODUTOS","jsouza","$AC$10",{"$f":"IF(ISBLANK(VLOOKUP(I9,'[1]Supérfluos '!A$1:A$15,1,0)),AC9*0.17-W9,AC9*0.2-W9)","v":0}]
["2017-02-13T09:38:51","CÁLC. ICMS ST OUTROS PRODUTOS","jsouza","$AC$10",{"$f":"IF(ISBLANK(VLOOKUP(I9,'[1]Supérfluos '!A$1:A$15,1,0)),AC9*0.17-W9,AC9*0.2-W9)","v":0}]
["2017-02-13T09:41:09","CÁLC. ICMS ST OUTROS PRODUTOS","jsouza","$AC$9",{"$f":"IF(ISBLANK(VLOOKUP(I9,'[1]Supérfluos '!A$1:A$15,1,0)),AC9*0.17-W9,AC9*0.2-W9)","v":0}]
["2017-02-13T09:41:44","CÁLC. ICMS ST OUTROS PRODUTOS","jsouza","$10:$1048576"]
["2017-02-13T09:53:58","CÁLC. ICMS ST e CRÉD.OUTORG.","jsouza","$10:$1048576"]
["2017-02-13T10:41:10","CÁLC. ICMS ST e CRÉD.OUTORG.","jsouza","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9*0.9))","v":0}]
["2017-02-15T11:28:01","CÁLC. ICMS ST e CRÉD.OUTORG.","jsouza","$AC$9",{"$f":"(AB9*0.17)-(V9*0.07)","v":0}]
["2018-03-08T11:06:13","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9*0.9))","v":0}]
["2018-03-08T11:07:08","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$10:$10","Valores Alterados"]
["2018-03-08T11:07:10","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$11:$11","Valores Alterados"]
["2018-03-08T11:07:12","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$12:$12","Valores Alterados"]
["2018-03-08T11:08:06","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$13:$16","Valores Alterados"]
["2018-03-08T11:08:10","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$17:$20","Valores Alterados"]
["2018-03-08T11:15:27","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$20",{"$f":"(AB20*0.17)-(V20*0.07)","v":0}]
["2018-03-08T11:19:55","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AD$20","SE(E(H20<>\"MS\";Y20=0);\"S\";\"N\")"]
["2018-03-08T11:19:56","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AD$20",{"$f":"IF(AND(H20<>\"MS\",Y20=0),\"S\",\"N\")","v":"S"}]
["2018-03-08T11:21:20","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AD$20",{"$f":"IF(AND(H20<>\"MS\",Y20=0),\"S\",\"N\")","v":"S"}]
["2018-03-08T11:28:13","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$20",{"$f":"IF(AND(AD20=\"S\",W20/V20>0.07),(AB20*0.17)-(V20*0.07),(AB20*0.17)-(W20))","v":{"$error":"#DIV/0!"}}]
["2018-03-08T11:28:33","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC:$AC","Valores Alterados"]
["2018-03-08T11:28:39","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$20",{"$f":"IF(AND(AD20=\"S\",V20/U20>0.07),(AA20*0.17)-(U20*0.07),(AA20*0.17)-(V20))","v":{"$error":"#DIV/0!"}}]
["2018-03-08T11:28:48","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$20",{"$f":"IF(AND(AD20=\"S\",V20/U20>0.07),(AA20*0.17)-(U20*0.07),(AA20*0.17)-(V20))","v":{"$error":"#DIV/0!"}}]
["2018-03-08T11:29:08","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$20"]
["2018-03-08T11:29:22","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AD$20",{"$f":"IF(AND(AE20=\"S\",W20/V20>0.07),(AB20*0.17)-(V20*0.07),(AB20*0.17)-(W20))","v":{"$error":"#DIV/0!"}}]
["2018-03-08T11:31:44","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AD$9",{"$f":"IF(AND(AE9=\"S\",W9/V9>0.07),(AB9*0.17)-(V9*0.07),(AB9*0.17)-(W9))","v":{"$error":"#DIV/0!"}}]
["2018-03-08T11:31:48","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AD$9",{"$f":"IF(AND(AE9=\"S\",W9/V9>0.07),(AB9*0.17)-(V9*0.07),(AB9*0.17)-(W9))","v":{"$error":"#DIV/0!"}}]
["2018-03-08T11:31:58","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AD$10:$AD$20","Valores Alterados"]
["2018-03-08T11:53:58","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9))","v":0}]
["2018-03-08T11:54:02","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$10:$AB$20","Valores Alterados"]
["2018-03-08T12:00:39","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$27:$38","Valores Alterados"]
["2018-03-08T12:06:51","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$25",{"$f":"(P12*Q12*1.983*0.153)-7","v":-7}]
["2018-03-08T12:07:15","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$25",{"$f":"(P12*Q12*1.983*0.153)-12","v":-12}]
["2018-03-08T12:07:51","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AG$25","0,153*"]
["2018-03-08T12:08:21","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AG$25","0,153*10*20*0,6"]
["2018-03-08T12:08:33","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AG$25",{"$f":"(0.153*10*20*0.6)-12","v":6.3599999999999994}]
["2018-03-08T12:09:09","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$25",{"$f":"(P12*Q12*1.983*0.153)-7","v":-7}]
["2018-03-08T12:09:14","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AG$25",{"$f":"(0.153*10*20*0.6)-7","v":11.36}]
["2018-03-08T12:09:23","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$25",{"$f":"(P12*Q12*1.983*0.153)-4","v":-4}]
["2018-03-08T12:09:28","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AG$25",{"$f":"(0.153*10*20*0.6)-4","v":14.36}]
["2018-03-08T12:09:31","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$25:$AH$25","Valores Alterados"]
["2018-03-08T12:11:07","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$10:$20","Valores Alterados"]
["2018-03-08T12:12:00","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE)*0.9,(P9*X9*0.9))","v":0}]
["2018-03-08T12:16:17","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC:$AC","Valores Alterados"]
["2018-05-07T08:15:33","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$9",{"$f":"IF(AD9=\"S\",(((P9*Q9)+R9+S9+T9-U9)*1.983*0.153)-(V9*0.07),\"\")","v":""}]
["2018-05-07T08:16:11","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$9",{"$f":"IF(AD9=\"S\",(P9*X9*0.6*0.153)-(V9*0.07),\"\")","v":""}]
["2018-05-07T08:38:01","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$10:$AG$10","Valores Alterados"]
["2018-05-07T08:38:02","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$11:$AG$11","Valores Alterados"]
["2018-05-07T08:38:03","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$12:$AG$12","Valores Alterados"]
["2018-05-07T08:38:03","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$13:$AG$13","Valores Alterados"]
["2018-05-07T08:38:04","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$14:$AG$14","Valores Alterados"]
["2018-05-07T08:38:04","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$15:$AG$15","Valores Alterados"]
["2018-05-07T08:38:05","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$16:$AG$16","Valores Alterados"]
["2018-05-07T08:38:05","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$17:$AG$17","Valores Alterados"]
["2018-05-07T08:38:05","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$18:$AG$18","Valores Alterados"]
["2018-05-07T08:38:06","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$19:$AG$19","Valores Alterados"]
["2018-05-07T08:38:06","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$20:$AG$20","Valores Alterados"]
["2018-05-07T08:38:06","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$21:$AG$21","Valores Alterados"]
["2018-05-07T08:38:07","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$22:$AG$22","Valores Alterados"]
["2018-05-07T08:38:07","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$23:$AG$23","Valores Alterados"]
["2018-05-07T08:38:07","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$24:$AG$24","Valores Alterados"]
["2018-05-07T08:38:08","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$25:$AG$25","Valores Alterados"]
["2018-05-07T08:38:08","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$26:$AG$26","Valores Alterados"]
["2018-05-07T08:38:08","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$27:$AG$27","Valores Alterados"]
["2018-05-07T08:38:18","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$30"]
["2018-05-07T08:38:24","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$25:$27","Valores Alterados"]
["2018-05-07T08:38:44","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$22:$24","Valores Alterados"]
["2018-05-07T08:40:01","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$23",{"$f":"P10*X10*0.9","v":0}]
["2018-05-07T08:40:17","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$23",{"$f":"AB23*0.17","v":0}]
["2018-05-07T08:41:58","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$23",{"$f":"(AB23*0.17)-W10","v":0}]
["2018-05-07T08:42:08","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$23",{"$f":"(AB23*0.17)-W11","v":0}]
["2018-05-07T08:42:27","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$23"]
["2018-05-07T08:42:45","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$23",{"$f":"P10*Q10*0.9","v":0}]
["2018-05-07T08:45:33","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$23",{"$f":"P10*Q10*0.9*1.5389","v":0}]
["2018-05-07T08:45:51","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$23",{"$f":"(AB23*0.17)-W13","v":0}]
["2018-05-07T08:46:10","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$23",{"$f":"P10*Q10*0.9*1.4986","v":0}]
["2018-05-07T08:46:25","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$23",{"$f":"(AB23*0.17)-W21","v":0}]
["2018-05-07T08:47:07","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$23",{"$f":"(AB23*0.17)-70","v":-70}]
["2018-05-07T08:48:20","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$26",{"$f":"IF(AD26=\"S\",(((P26*Q26)+R26+S26+T26-U26)*1.983*0.153)-(V26*0.07),\"\")","v":""}]
["2018-05-07T08:48:53","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$26",{"$f":"IF(AD26=\"S\",(((P26*Q26)+R26+S26+T26-U26)*1.983*0.153)-(V26*0.07),\"\")","v":""}]
["2018-05-07T08:49:05","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$26:$AD$26","Valores Alterados"]
["2018-05-07T08:49:13","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$26:$AG$26","Valores Alterados"]
["2018-05-07T08:49:52","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$26",{"$f":"IF(AD26=\"S\",(((P26*Q26)+R26+S26+T26-U26)*1.983*0.153)-40,\"\")","v":""}]
["2018-05-07T08:51:04","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$26",{"$f":"IF(AD26=\"S\",(((P26*Q26)+R26+S26+T26-U26)*1.983*0.153)-70,\"\")","v":""}]
["2018-05-07T08:51:14","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$26",{"$f":"IF(AD26=\"S\",(((P26*Q26)+R26+S26+T26-U26)*1.983*0.153)-120,\"\")","v":""}]
["2018-05-07T08:51:46","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$27:$AG$27","Valores Alterados"]
["2018-05-07T08:51:47","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$28:$AG$28","Valores Alterados"]
["2018-05-07T08:51:51","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AG$30"]
["2018-05-07T08:52:12","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$26",{"$f":"IF(AD26=\"S\",(((P26*Q26)+R26+S26+T26-U26)*1.983*0.153)-70,\"\")","v":""}]
["2018-05-07T08:52:26","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$27",{"$f":"IF(AD27=\"S\",(((P27*Q27)+R27+S27+T27-U27)*1.983*0.153)-70,\"\")","v":""}]
["2018-05-07T08:52:36","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$28",{"$f":"IF(AD28=\"S\",(((P28*Q28)+R28+S28+T28-U28)*1.983*0.153)-70,\"\")","v":""}]
["2018-05-07T09:06:12","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$26",{"$f":"IF(AD26=\"S\",(((P26*Q26)+R26+S26+T26-U26)*1.983*0.153)-40,\"\")","v":""}]
["2018-05-07T09:06:24","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$26",{"$f":"IF(AD26=\"S\",(P26*X26*0.6*0.153)-40,\"\")","v":""}]
["2018-05-07T09:06:47","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AE$28",{"$f":"IF(AD28=\"S\",(((P28*Q28)+R28+S28+T28-U28)*1.983*0.153)-120,\"\")","v":""}]
["2018-05-07T09:06:56","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AF$28",{"$f":"IF(AD28=\"S\",(P28*X28*0.6*0.153)-120,\"\")","v":""}]
["2018-05-07T10:08:43","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$N$10:$AH$31","Valores Alterados"]
["2018-05-07T10:09:16","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$10:$37","Valores Alterados"]
["2018-06-18T09:48:00","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9*0.9))","v":0}]
["2018-06-18T09:48:55","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9*0.9))","v":0}]
["2018-06-18T09:48:56","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$19"]
["2018-06-18T09:50:53","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9*0.9))","v":0}]
["2018-06-18T10:10:25","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9))","v":0}]
["2018-06-18T10:11:08","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE),(P9*X9*0.9))","v":0}]
["2018-06-18T14:39:56","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$9",{"$f":"IF(Y9<>0,(P9*Q9+R9+S9+T9)*VLOOKUP(IF(W9/V9<0.058,\"0,04\",IF(W9/V9<0.09,\"0,07\",\"0,12\"))+Y9,LISTA!G:L,5,FALSE)*0.9,(P9*X9*0.9))","v":0}]
["2018-06-25T10:38:51","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$10:$10","Valores Alterados"]
["2018-06-25T10:41:34","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AB$10",{"$f":"IF(Y10<>0,(P10*Q10+R10+S10+T10)*VLOOKUP(IF(W10/V10<0.058,\"0,04\",IF(W10/V10<0.09,\"0,07\",\"0,12\"))+Y10,LISTA!G:L,5,FALSE),(P10*X10))","v":0}]
["2018-06-25T10:41:54","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$14",{"$f":"AC9-AG9","v":0}]
["2018-06-25T10:41:59","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$15",{"$f":"AC10-AG10","v":0}]
["2018-06-25T10:42:39","CÁLC. ICMS ST e CRÉD.OUTORG.","mverbisck","$AC$14",{"$f":"AC9-AG9","v":0}]

{"sheet":"LISTA","index":7,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["AC ",null,0,null,null,null,{"$f":"H1+J1","v":3.04},3,"neutra",0.04,1.4713000000000001]
["AL ",null,1,null,null,null,{"$f":"H2+J2","v":3.07},3,"neutra",7.0000000000000007E-2,1.4253]
["AP ",null,2,null,null,null,3.12,3,"neutra",0.12,1.3487]
["AM ",null,3,null,null,null,1.04,1,"negativa",0.04,1.385]
["BA ",null,4,null,null,null,1.07,1,"negativa",7.0000000000000007E-2,1.3416999999999999]
["CE ",null,null,null,null,null,1.1200000000000001,1,"negativa",0.12,1.2695000000000001]
["DF ",null,null,null,null,null,2.04,2,"positiva",0.04,1.4390000000000001]
["ES ",null,null,null,null,null,2.0699999999999998,2,"positiva",7.0000000000000007E-2,1.3939999999999999]
["GO ",null,null,null,null,null,2.12,2,"positiva",0.12,1.319]
["MA "]
["MT "]
["MS "]
["MG "]
["PA "]
["PB "]
["PR "]
["PE "]
["PI "]
["RJ "]
["RN "]
["RS "]
["RO "]
["RR "]
["SC "]
["SP "]
["SE "]
["TO "]