{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Extenso Recibo","Extenso Consulta","Extenso Recibo x emitente","Empresa","Recibo","Recibo x emitente","Consulta","Cadastro","Transf"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Extenso Recibo","index":0,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,1,0,5],[0,6,0,10],[0,11,1,11],[0,12,1,12],[0,13,1,13]]}
[null,"Parte 1",null,null,null,null,"Parte 2",null,null,null,null,"Moeda","Centavos","Valor por Extenso"]
["Valor para extenso","trilhões","bilhões","milhões","milhares","unidades","trilhões","bilhões","milhões","milhares","unidades"]
[{"$f":"Recibo!$D$3","v":0},{"$f":"TRUNC(($A3-((10^{15,12,9,6,3})*INT($A3/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,{"$f":"IF($A3<10^15,\"\",IF(OR(B3=1,AND(B3>=100,MOD(B3,100)=0)),IF(TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0,_e_,_sp_),IF(B3<100,\"\",_sp_)))&IF(B3=1,INDEX(Sng,1,5),IF(B3<100,\"\",IF(B3=100,OCem,INDEX(Cem,1,TRUNC(B3/100)))))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(OR(MOD(B3,100)>=20,MOD(B3,100)=10),IF(OR(B3>100,AND($A3>10^15,TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0)),_e_,IF($A3>10^15,_sp_,\"\")),\"\")))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(OR(MOD(B3,100)>=20,MOD(B3,100)=10),INDEX(Dez,1,TRUNC(MOD(B3,100)/10)),\"\")))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(MOD(MOD(B3,100),10)<>0,IF(OR(B3>20,AND($A3>10^15,TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0)),_e_,IF($A3>10^15,_sp_,\"\")),\"\")))&IF(B3=0,\"\",IF(B3=1,\"\",IF(MOD(MOD(B3,100),10)=0,\"\",IF(MOD(B3,100)<20,INDEX(Sml,1,MOD(B3,100)),INDEX(Sml,1,MOD(MOD(B3,100),10)))))) & IF(B3<=1,\"\",INDEX(Plu,1,5))","v":""},{"$f":"IF($A3<10^12,\"\",IF(OR(C3=1,AND(C3>=100,MOD(C3,100)=0)),IF(TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0,_e_,_sp_),IF(C3<100,\"\",_sp_)))&IF(C3=1,INDEX(Sng,1,4),IF(C3<100,\"\",IF(C3=100,OCem,INDEX(Cem,1,TRUNC(C3/100)))))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(OR(MOD(C3,100)>=20,MOD(C3,100)=10),IF(OR(C3>100,AND($A3>10^12,TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0)),_e_,IF($A3>10^12,_sp_,\"\")),\"\")))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(OR(MOD(C3,100)>=20,MOD(C3,100)=10),INDEX(Dez,1,TRUNC(MOD(C3,100)/10)),\"\")))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(MOD(MOD(C3,100),10)<>0,IF(OR(C3>20,AND($A3>10^12,TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0)),_e_,IF($A3>10^12,_sp_,\"\")),\"\")))&IF(C3=0,\"\",IF(C3=1,\"\",IF(MOD(MOD(C3,100),10)=0,\"\",IF(MOD(C3,100)<20,INDEX(Sml,1,MOD(C3,100)),INDEX(Sml,1,MOD(MOD(C3,100),10)))))) & IF(C3<=1,\"\",INDEX(Plu,1,4))","v":""},{"$f":"IF($A3<10^9,\"\",IF(OR(D3=1,AND(D3>=100,MOD(D3,100)=0)),IF(TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0,_e_,_sp_),IF(D3<100,\"\",_sp_)))&IF(D3=1,INDEX(Sng,1,3),IF(D3<100,\"\",IF(D3=100,OCem,INDEX(Cem,1,TRUNC(D3/100)))))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(OR(MOD(D3,100)>=20,MOD(D3,100)=10),IF(OR(D3>100,AND($A3>10^9,TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0)),_e_,IF($A3>10^9,_sp_,\"\")),\"\")))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(OR(MOD(D3,100)>=20,MOD(D3,100)=10),INDEX(Dez,1,TRUNC(MOD(D3,100)/10)),\"\")))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(MOD(MOD(D3,100),10)<>0,IF(OR(D3>20,AND($A3>10^9,TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0)),_e_,IF($A3>10^9,_sp_,\"\")),\"\")))&IF(D3=0,\"\",IF(D3=1,\"\",IF(MOD(MOD(D3,100),10)=0,\"\",IF(MOD(D3,100)<20,INDEX(Sml,1,MOD(D3,100)),INDEX(Sml,1,MOD(MOD(D3,100),10)))))) & IF(D3<=1,\"\",INDEX(Plu,1,3))","v":""},{"$f":"IF($A3<10^6,\"\",IF(OR(E3=1,AND(E3>=100,MOD(E3,100)=0)),IF(TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0,_e_,_sp_),IF(E3<100,\"\",_sp_)))&IF(E3=1,INDEX(Sng,1,2),IF(E3<100,\"\",IF(E3=100,OCem,INDEX(Cem,1,TRUNC(E3/100)))))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(OR(MOD(E3,100)>=20,MOD(E3,100)=10),IF(OR(E3>100,AND($A3>10^6,TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0)),_e_,IF($A3>10^6,_sp_,\"\")),\"\")))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(OR(MOD(E3,100)>=20,MOD(E3,100)=10),INDEX(Dez,1,TRUNC(MOD(E3,100)/10)),\"\")))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(MOD(MOD(E3,100),10)<>0,IF(OR(E3>20,AND($A3>10^6,TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0)),_e_,IF($A3>10^6,_sp_,\"\")),\"\")))&IF(E3=0,\"\",IF(E3=1,\"\",IF(MOD(MOD(E3,100),10)=0,\"\",IF(MOD(E3,100)<20,INDEX(Sml,1,MOD(E3,100)),INDEX(Sml,1,MOD(MOD(E3,100),10)))))) & IF(E3<=1,\"\",INDEX(Plu,1,2))","v":""},{"$f":"IF($A3<10^3,\"\",IF(OR(F3=1,AND(F3>=100,MOD(F3,100)=0)),IF(TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0,_e_,_sp_),IF(F3<100,\"\",_sp_)))&IF(F3=1,INDEX(Sng,1,1),IF(F3<100,\"\",IF(F3=100,OCem,INDEX(Cem,1,TRUNC(F3/100)))))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(OR(MOD(F3,100)>=20,MOD(F3,100)=10),IF(OR(F3>100,AND($A3>10^3,TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0)),_e_,IF($A3>10^3,_sp_,\"\")),\"\")))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(OR(MOD(F3,100)>=20,MOD(F3,100)=10),INDEX(Dez,1,TRUNC(MOD(F3,100)/10)),\"\")))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(MOD(MOD(F3,100),10)<>0,IF(OR(F3>20,AND($A3>10^3,TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0)),_e_,IF($A3>10^3,_sp_,\"\")),\"\")))&IF(F3=0,\"\",IF(F3=1,\"\",IF(MOD(MOD(F3,100),10)=0,\"\",IF(MOD(F3,100)<20,INDEX(Sml,1,MOD(F3,100)),INDEX(Sml,1,MOD(MOD(F3,100),10)))))) & IF(F3<=1,\"\",INDEX(Plu,1,1))","v":""},{"$f":"IF($A3<1,\"\",IF(TRUNC($A3)=1,\" real\",IF(AND($A3>=10^6,TRUNC(MOD($A3,10^6))=0),\" de\",\"\") & \" reais\"))","v":""},{"$f":"IF((ROUND($A3-TRUNC($A3),2)*100)=0,\"\",IF($A3>=1,_e_,\"\") & IF((ROUND($A3-TRUNC($A3),2)*100)=1,\"um centavo\",IF((ROUND($A3-TRUNC($A3),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($A3-TRUNC($A3),2)*100)/10)) & IF(MOD((ROUND($A3-TRUNC($A3),2)*100),10)<>0,_e_ & INDEX(Sml,1,MOD((ROUND($A3-TRUNC($A3),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($A3-TRUNC($A3),2)*100))) & \" centavos\"))","v":""},{"$f":"G3&H3&I3&J3&K3&L3&M3","v":""}]
["Para Recibo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N3<>\"\",\"( \" & N3 & \" )\",\"\")","v":""}]

{"sheet":"Extenso Consulta","index":1,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,1,0,5],[0,6,0,10],[0,11,1,11],[0,12,1,12],[0,13,1,13]]}
[null,"Parte 1",null,null,null,null,"Parte 2",null,null,null,null,"Moeda","Centavos","Valor por Extenso"]
["Valor para extenso","trilhões","bilhões","milhões","milhares","unidades","trilhões","bilhões","milhões","milhares","unidades"]
[{"$f":"Consulta!$D$3","v":0},{"$f":"TRUNC(($A3-((10^{15,12,9,6,3})*INT($A3/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,{"$f":"IF($A3<10^15,\"\",IF(OR(B3=1,AND(B3>=100,MOD(B3,100)=0)),IF(TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0,_e_,_sp_),IF(B3<100,\"\",_sp_)))&IF(B3=1,INDEX(Sng,1,5),IF(B3<100,\"\",IF(B3=100,OCem,INDEX(Cem,1,TRUNC(B3/100)))))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(OR(MOD(B3,100)>=20,MOD(B3,100)=10),IF(OR(B3>100,AND($A3>10^15,TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0)),_e_,IF($A3>10^15,_sp_,\"\")),\"\")))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(OR(MOD(B3,100)>=20,MOD(B3,100)=10),INDEX(Dez,1,TRUNC(MOD(B3,100)/10)),\"\")))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(MOD(MOD(B3,100),10)<>0,IF(OR(B3>20,AND($A3>10^15,TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0)),_e_,IF($A3>10^15,_sp_,\"\")),\"\")))&IF(B3=0,\"\",IF(B3=1,\"\",IF(MOD(MOD(B3,100),10)=0,\"\",IF(MOD(B3,100)<20,INDEX(Sml,1,MOD(B3,100)),INDEX(Sml,1,MOD(MOD(B3,100),10)))))) & IF(B3<=1,\"\",INDEX(Plu,1,5))","v":""},{"$f":"IF($A3<10^12,\"\",IF(OR(C3=1,AND(C3>=100,MOD(C3,100)=0)),IF(TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0,_e_,_sp_),IF(C3<100,\"\",_sp_)))&IF(C3=1,INDEX(Sng,1,4),IF(C3<100,\"\",IF(C3=100,OCem,INDEX(Cem,1,TRUNC(C3/100)))))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(OR(MOD(C3,100)>=20,MOD(C3,100)=10),IF(OR(C3>100,AND($A3>10^12,TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0)),_e_,IF($A3>10^12,_sp_,\"\")),\"\")))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(OR(MOD(C3,100)>=20,MOD(C3,100)=10),INDEX(Dez,1,TRUNC(MOD(C3,100)/10)),\"\")))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(MOD(MOD(C3,100),10)<>0,IF(OR(C3>20,AND($A3>10^12,TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0)),_e_,IF($A3>10^12,_sp_,\"\")),\"\")))&IF(C3=0,\"\",IF(C3=1,\"\",IF(MOD(MOD(C3,100),10)=0,\"\",IF(MOD(C3,100)<20,INDEX(Sml,1,MOD(C3,100)),INDEX(Sml,1,MOD(MOD(C3,100),10)))))) & IF(C3<=1,\"\",INDEX(Plu,1,4))","v":""},{"$f":"IF($A3<10^9,\"\",IF(OR(D3=1,AND(D3>=100,MOD(D3,100)=0)),IF(TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0,_e_,_sp_),IF(D3<100,\"\",_sp_)))&IF(D3=1,INDEX(Sng,1,3),IF(D3<100,\"\",IF(D3=100,OCem,INDEX(Cem,1,TRUNC(D3/100)))))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(OR(MOD(D3,100)>=20,MOD(D3,100)=10),IF(OR(D3>100,AND($A3>10^9,TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0)),_e_,IF($A3>10^9,_sp_,\"\")),\"\")))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(OR(MOD(D3,100)>=20,MOD(D3,100)=10),INDEX(Dez,1,TRUNC(MOD(D3,100)/10)),\"\")))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(MOD(MOD(D3,100),10)<>0,IF(OR(D3>20,AND($A3>10^9,TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0)),_e_,IF($A3>10^9,_sp_,\"\")),\"\")))&IF(D3=0,\"\",IF(D3=1,\"\",IF(MOD(MOD(D3,100),10)=0,\"\",IF(MOD(D3,100)<20,INDEX(Sml,1,MOD(D3,100)),INDEX(Sml,1,MOD(MOD(D3,100),10)))))) & IF(D3<=1,\"\",INDEX(Plu,1,3))","v":""},{"$f":"IF($A3<10^6,\"\",IF(OR(E3=1,AND(E3>=100,MOD(E3,100)=0)),IF(TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0,_e_,_sp_),IF(E3<100,\"\",_sp_)))&IF(E3=1,INDEX(Sng,1,2),IF(E3<100,\"\",IF(E3=100,OCem,INDEX(Cem,1,TRUNC(E3/100)))))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(OR(MOD(E3,100)>=20,MOD(E3,100)=10),IF(OR(E3>100,AND($A3>10^6,TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0)),_e_,IF($A3>10^6,_sp_,\"\")),\"\")))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(OR(MOD(E3,100)>=20,MOD(E3,100)=10),INDEX(Dez,1,TRUNC(MOD(E3,100)/10)),\"\")))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(MOD(MOD(E3,100),10)<>0,IF(OR(E3>20,AND($A3>10^6,TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0)),_e_,IF($A3>10^6,_sp_,\"\")),\"\")))&IF(E3=0,\"\",IF(E3=1,\"\",IF(MOD(MOD(E3,100),10)=0,\"\",IF(MOD(E3,100)<20,INDEX(Sml,1,MOD(E3,100)),INDEX(Sml,1,MOD(MOD(E3,100),10)))))) & IF(E3<=1,\"\",INDEX(Plu,1,2))","v":""},{"$f":"IF($A3<10^3,\"\",IF(OR(F3=1,AND(F3>=100,MOD(F3,100)=0)),IF(TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0,_e_,_sp_),IF(F3<100,\"\",_sp_)))&IF(F3=1,INDEX(Sng,1,1),IF(F3<100,\"\",IF(F3=100,OCem,INDEX(Cem,1,TRUNC(F3/100)))))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(OR(MOD(F3,100)>=20,MOD(F3,100)=10),IF(OR(F3>100,AND($A3>10^3,TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0)),_e_,IF($A3>10^3,_sp_,\"\")),\"\")))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(OR(MOD(F3,100)>=20,MOD(F3,100)=10),INDEX(Dez,1,TRUNC(MOD(F3,100)/10)),\"\")))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(MOD(MOD(F3,100),10)<>0,IF(OR(F3>20,AND($A3>10^3,TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0)),_e_,IF($A3>10^3,_sp_,\"\")),\"\")))&IF(F3=0,\"\",IF(F3=1,\"\",IF(MOD(MOD(F3,100),10)=0,\"\",IF(MOD(F3,100)<20,INDEX(Sml,1,MOD(F3,100)),INDEX(Sml,1,MOD(MOD(F3,100),10)))))) & IF(F3<=1,\"\",INDEX(Plu,1,1))","v":""},{"$f":"IF($A3<1,\"\",IF(TRUNC($A3)=1,\" real\",IF(AND($A3>=10^6,TRUNC(MOD($A3,10^6))=0),\" de\",\"\") & \" reais\"))","v":""},{"$f":"IF((ROUND($A3-TRUNC($A3),2)*100)=0,\"\",IF($A3>=1,_e_,\"\") & IF((ROUND($A3-TRUNC($A3),2)*100)=1,\"um centavo\",IF((ROUND($A3-TRUNC($A3),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($A3-TRUNC($A3),2)*100)/10)) & IF(MOD((ROUND($A3-TRUNC($A3),2)*100),10)<>0,_e_ & INDEX(Sml,1,MOD((ROUND($A3-TRUNC($A3),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($A3-TRUNC($A3),2)*100))) & \" centavos\"))","v":""},{"$f":"G3&H3&I3&J3&K3&L3&M3","v":""}]
["Para Consulta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N3<>\"\",\"( \" & N3 & \" )\",\"\")","v":""}]

{"sheet":"Extenso Recibo x emitente","index":2,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,1,0,5],[0,6,0,10],[0,11,1,11],[0,12,1,12],[0,13,1,13]]}
[null,"Parte 1",null,null,null,null,"Parte 2",null,null,null,null,"Moeda","Centavos","Valor por Extenso"]
["Valor para extenso","trilhões","bilhões","milhões","milhares","unidades","trilhões","bilhões","milhões","milhares","unidades"]
[{"$f":"'Recibo x emitente'!D3","v":0},{"$f":"TRUNC(($A3-((10^{15,12,9,6,3})*INT($A3/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,{"$f":"IF($A3<10^15,\"\",IF(OR(B3=1,AND(B3>=100,MOD(B3,100)=0)),IF(TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0,_e_,_sp_),IF(B3<100,\"\",_sp_)))&IF(B3=1,INDEX(Sng,1,5),IF(B3<100,\"\",IF(B3=100,OCem,INDEX(Cem,1,TRUNC(B3/100)))))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(OR(MOD(B3,100)>=20,MOD(B3,100)=10),IF(OR(B3>100,AND($A3>10^15,TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0)),_e_,IF($A3>10^15,_sp_,\"\")),\"\")))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(OR(MOD(B3,100)>=20,MOD(B3,100)=10),INDEX(Dez,1,TRUNC(MOD(B3,100)/10)),\"\")))&IF(MOD(B3,100)=0,\"\",IF(B3=1,\"\",IF(MOD(MOD(B3,100),10)<>0,IF(OR(B3>20,AND($A3>10^15,TRUNC(($A3-(10^12*INT($A3/(10^12)))))=0)),_e_,IF($A3>10^15,_sp_,\"\")),\"\")))&IF(B3=0,\"\",IF(B3=1,\"\",IF(MOD(MOD(B3,100),10)=0,\"\",IF(MOD(B3,100)<20,INDEX(Sml,1,MOD(B3,100)),INDEX(Sml,1,MOD(MOD(B3,100),10)))))) & IF(B3<=1,\"\",INDEX(Plu,1,5))","v":""},{"$f":"IF($A3<10^12,\"\",IF(OR(C3=1,AND(C3>=100,MOD(C3,100)=0)),IF(TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0,_e_,_sp_),IF(C3<100,\"\",_sp_)))&IF(C3=1,INDEX(Sng,1,4),IF(C3<100,\"\",IF(C3=100,OCem,INDEX(Cem,1,TRUNC(C3/100)))))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(OR(MOD(C3,100)>=20,MOD(C3,100)=10),IF(OR(C3>100,AND($A3>10^12,TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0)),_e_,IF($A3>10^12,_sp_,\"\")),\"\")))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(OR(MOD(C3,100)>=20,MOD(C3,100)=10),INDEX(Dez,1,TRUNC(MOD(C3,100)/10)),\"\")))&IF(MOD(C3,100)=0,\"\",IF(C3=1,\"\",IF(MOD(MOD(C3,100),10)<>0,IF(OR(C3>20,AND($A3>10^12,TRUNC(($A3-(10^9*INT($A3/(10^9)))))=0)),_e_,IF($A3>10^12,_sp_,\"\")),\"\")))&IF(C3=0,\"\",IF(C3=1,\"\",IF(MOD(MOD(C3,100),10)=0,\"\",IF(MOD(C3,100)<20,INDEX(Sml,1,MOD(C3,100)),INDEX(Sml,1,MOD(MOD(C3,100),10)))))) & IF(C3<=1,\"\",INDEX(Plu,1,4))","v":""},{"$f":"IF($A3<10^9,\"\",IF(OR(D3=1,AND(D3>=100,MOD(D3,100)=0)),IF(TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0,_e_,_sp_),IF(D3<100,\"\",_sp_)))&IF(D3=1,INDEX(Sng,1,3),IF(D3<100,\"\",IF(D3=100,OCem,INDEX(Cem,1,TRUNC(D3/100)))))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(OR(MOD(D3,100)>=20,MOD(D3,100)=10),IF(OR(D3>100,AND($A3>10^9,TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0)),_e_,IF($A3>10^9,_sp_,\"\")),\"\")))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(OR(MOD(D3,100)>=20,MOD(D3,100)=10),INDEX(Dez,1,TRUNC(MOD(D3,100)/10)),\"\")))&IF(MOD(D3,100)=0,\"\",IF(D3=1,\"\",IF(MOD(MOD(D3,100),10)<>0,IF(OR(D3>20,AND($A3>10^9,TRUNC(($A3-(10^6*INT($A3/(10^6)))))=0)),_e_,IF($A3>10^9,_sp_,\"\")),\"\")))&IF(D3=0,\"\",IF(D3=1,\"\",IF(MOD(MOD(D3,100),10)=0,\"\",IF(MOD(D3,100)<20,INDEX(Sml,1,MOD(D3,100)),INDEX(Sml,1,MOD(MOD(D3,100),10)))))) & IF(D3<=1,\"\",INDEX(Plu,1,3))","v":""},{"$f":"IF($A3<10^6,\"\",IF(OR(E3=1,AND(E3>=100,MOD(E3,100)=0)),IF(TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0,_e_,_sp_),IF(E3<100,\"\",_sp_)))&IF(E3=1,INDEX(Sng,1,2),IF(E3<100,\"\",IF(E3=100,OCem,INDEX(Cem,1,TRUNC(E3/100)))))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(OR(MOD(E3,100)>=20,MOD(E3,100)=10),IF(OR(E3>100,AND($A3>10^6,TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0)),_e_,IF($A3>10^6,_sp_,\"\")),\"\")))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(OR(MOD(E3,100)>=20,MOD(E3,100)=10),INDEX(Dez,1,TRUNC(MOD(E3,100)/10)),\"\")))&IF(MOD(E3,100)=0,\"\",IF(E3=1,\"\",IF(MOD(MOD(E3,100),10)<>0,IF(OR(E3>20,AND($A3>10^6,TRUNC(($A3-(10^3*INT($A3/(10^3)))))=0)),_e_,IF($A3>10^6,_sp_,\"\")),\"\")))&IF(E3=0,\"\",IF(E3=1,\"\",IF(MOD(MOD(E3,100),10)=0,\"\",IF(MOD(E3,100)<20,INDEX(Sml,1,MOD(E3,100)),INDEX(Sml,1,MOD(MOD(E3,100),10)))))) & IF(E3<=1,\"\",INDEX(Plu,1,2))","v":""},{"$f":"IF($A3<10^3,\"\",IF(OR(F3=1,AND(F3>=100,MOD(F3,100)=0)),IF(TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0,_e_,_sp_),IF(F3<100,\"\",_sp_)))&IF(F3=1,INDEX(Sng,1,1),IF(F3<100,\"\",IF(F3=100,OCem,INDEX(Cem,1,TRUNC(F3/100)))))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(OR(MOD(F3,100)>=20,MOD(F3,100)=10),IF(OR(F3>100,AND($A3>10^3,TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0)),_e_,IF($A3>10^3,_sp_,\"\")),\"\")))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(OR(MOD(F3,100)>=20,MOD(F3,100)=10),INDEX(Dez,1,TRUNC(MOD(F3,100)/10)),\"\")))&IF(MOD(F3,100)=0,\"\",IF(F3=1,\"\",IF(MOD(MOD(F3,100),10)<>0,IF(OR(F3>20,AND($A3>10^3,TRUNC(($A3-(10^0*INT($A3/(10^0)))))=0)),_e_,IF($A3>10^3,_sp_,\"\")),\"\")))&IF(F3=0,\"\",IF(F3=1,\"\",IF(MOD(MOD(F3,100),10)=0,\"\",IF(MOD(F3,100)<20,INDEX(Sml,1,MOD(F3,100)),INDEX(Sml,1,MOD(MOD(F3,100),10)))))) & IF(F3<=1,\"\",INDEX(Plu,1,1))","v":""},{"$f":"IF($A3<1,\"\",IF(TRUNC($A3)=1,\" real\",IF(AND($A3>=10^6,TRUNC(MOD($A3,10^6))=0),\" de\",\"\") & \" reais\"))","v":""},{"$f":"IF((ROUND($A3-TRUNC($A3),2)*100)=0,\"\",IF($A3>=1,_e_,\"\") & IF((ROUND($A3-TRUNC($A3),2)*100)=1,\"um centavo\",IF((ROUND($A3-TRUNC($A3),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($A3-TRUNC($A3),2)*100)/10)) & IF(MOD((ROUND($A3-TRUNC($A3),2)*100),10)<>0,_e_ & INDEX(Sml,1,MOD((ROUND($A3-TRUNC($A3),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($A3-TRUNC($A3),2)*100))) & \" centavos\"))","v":""},{"$f":"G3&H3&I3&J3&K3&L3&M3","v":""}]
["Para Consulta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N3<>\"\",\"( \" & N3 & \" )\",\"\")","v":""}]

{"sheet":"Empresa","index":3,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[12,1,12,2],[3,1,3,2]]}
[]
[{"$f":"IF(A15=1,\"Nome da Loja .............. :\",\"Nome ................ :\")","v":"Nome da Loja .............. :"},"LOJA - ME"]
[{"$f":"IF(A15=1,\"CNPJ ............................ :\",\"CPF / RG .......... :\")","v":"CNPJ ............................ :"},"CNPJ: 00.000.000/0000-00"]
["Endereço ","Avenida Vai e Vem, 9999   -  Centro"]
["Cidade-UF","Cidade-UF"]
[]
["Prazo de validade (em dias):",120]
[{"$f":"IF(B7=0,\"\",\"Válido até\")","v":"Válido até"},{"$f":"IF(B7=0,\"\",TODAY()+B7)","v":"2016-08-10"}]
[]
[]
[]
[]
[null,"www.planilhasparaconfeccao.com.br"]
[]
[1]
[]
[]
[]
[]
[]
[null,null,null,null,"Versão 1.0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"www.planilhasparaconfeccao.com.br"]
[null,{"$f":"IF(B13<>B56,0,1)","v":1}]

{"sheet":"Recibo","index":4,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,8,2,11],[19,2,19,3],[8,2,8,3],[1,1,2,1],[6,2,6,3],[7,2,7,3],[5,2,5,3],[4,2,4,3],[16,2,17,3],[16,1,17,1],[14,2,14,3],[15,2,15,3]]}
[]
[null,{"$f":"MAX(Cadastro!A:A)+1","v":1},null,"Valor"]
[]
[]
[null,"Declaramos que"]
[null,"CNPJ / CPF / RG"]
[null,"Endereço"]
[null,"Possui a importância de",{"$f":"UPPER('Extenso Recibo'!N5)","v":""}]
[null,"Referente"]
[]
[null,"Para maior clareza firmamos o presente."]
[null,null,null,{"$f":"Empresa!A8","v":"Válido até"}]
[null,{"$f":"Empresa!B5","v":"Cidade-UF"},{"$f":"TODAY()","v":"2016-04-12"},{"$f":"Empresa!B8","v":"2016-08-10"}]
[]
[null,"Emitente",{"$f":"Empresa!B2","v":"LOJA - ME"}]
[null,null,{"$f":"Empresa!B3","v":"CNPJ: 00.000.000/0000-00"}]
[null,"Endereço",{"$f":"Empresa!B4","v":"Avenida Vai e Vem, 9999   -  Centro"}]
[]
[]
[null,"Assinatura",null,null,null,null,null,null,null,null,"Versão 1.0"]
[]
[]
[]
[{"$f":"B2","v":1},{"$f":"C13","v":"2016-04-12"},{"$f":"D3","v":0},{"$f":"C5","v":0},{"$f":"C6","v":0},{"$f":"C7","v":0},{"$f":"C9","v":0},{"$f":"D13","v":"2016-08-10"}]

{"sheet":"Recibo x emitente","index":5,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,1,17,1],[16,2,17,3],[1,1,2,1],[2,8,2,11],[4,2,4,3],[5,2,5,3],[6,2,6,3],[19,2,19,3],[7,2,7,3],[8,2,8,3],[14,2,14,3],[15,2,15,3]]}
[]
[null,{"$f":"MAX(Cadastro!A:A)+1","v":1},null,"Valor"]
[]
[]
[null,"Declaramos que",{"$f":"Consulta!C5","v":"Esta linha é só para não dar erro enquanto não tiver recibo. Favor excluir após incluir algum."}]
[null,null,{"$f":"Consulta!C6","v":0}]
[null,"Endereço",{"$f":"Consulta!C7","v":0}]
[null,"Possui a importância de",{"$f":"UPPER('Extenso Recibo x emitente'!N5)","v":""}]
[null,"Referente",0]
[]
[null,"Para maior clareza firmamos o presente."]
[null,null,null,{"$f":"Empresa!A8","v":"Válido até"}]
[null,{"$f":"Empresa!B5","v":"Cidade-UF"},{"$f":"TODAY()","v":"2016-04-12"},{"$f":"Empresa!B8","v":"2016-08-10"}]
[]
[null,"Emitente",{"$f":"Empresa!B2","v":"LOJA - ME"}]
[null,"CNPJ / CPF / RG",{"$f":"Empresa!B3","v":"CNPJ: 00.000.000/0000-00"}]
[null,"Endereço",{"$f":"Empresa!B4","v":"Avenida Vai e Vem, 9999   -  Centro"}]
[]
[]
[null,"Assinatura",null,null,null,null,null,null,null,null,"Versão 1.0"]
[]
[]
[]
[{"$f":"B2","v":1},{"$f":"C13","v":"2016-04-12"},{"$f":"D3","v":0},{"$f":"C5","v":"Esta linha é só para não dar erro enquanto não tiver recibo. Favor excluir após incluir algum."},{"$f":"C6","v":0},{"$f":"C7","v":0},{"$f":"C9","v":0},{"$f":"D13","v":"2016-08-10"}]

{"sheet":"Consulta","index":6,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,2,19,3],[1,1,2,1],[6,2,6,3],[7,2,7,3],[8,2,8,3],[4,2,4,3],[5,2,5,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(O2=0,\"Esta Planilha foi violada. Baixe nova Planilha gratuitamente no site: www.planilhasparaconfeccao.com.br\",\"\")","v":""}]
[null,{"$f":"IF(O2=0,\"\",IF(O1=0,\"\",OFFSET(Cadastro!A1,O1,0)))","v":0},null,"Valor",null,null,null,null,null,null,null,null,null,null,{"$f":"Empresa!B57","v":1}]
[null,null,null,{"$f":"IF(O2=0,\"\",IF(O1=0,\"\",OFFSET(Cadastro!C1,O1,0)))","v":0}]
[]
[null,"Declaramos que",{"$f":"IF(O2=0,\"\",IF(O1=0,\"\",OFFSET(Cadastro!D1,O1,0)))","v":"Esta linha é só para não dar erro enquanto não tiver recibo. Favor excluir após incluir algum."}]
[null,"CNPJ / CPF / RG",{"$f":"IF(O2=0,\"\",IF(O1=0,\"\",OFFSET(Cadastro!E1,O1,0)))","v":0}]
[null,"Endereço",{"$f":"IF(O2=0,\"\",IF(O1=0,\"\",OFFSET(Cadastro!F1,O1,0)))","v":0}]
[null,"Possui a importância de",{"$f":"IF(O2=0,\"\",UPPER('Extenso Consulta'!N5))","v":""}]
[null,"Referente",{"$f":"IF(O2=0,\"\",IF(O1=0,\"\",OFFSET(Cadastro!G1,O1,0)))","v":0}]
[]
[null,"Para maior clareza firmamos o presente."]
[null,null,null,{"$f":"IF(O13=0,\"\",Empresa!A8)","v":""}]
[null,{"$f":"Empresa!B5","v":"Cidade-UF"},{"$f":"IF(O2=0,\"\",IF(C5=0,\"\",OFFSET(Cadastro!B1,O1,0)))","v":"2015-03-21"},{"$f":"IF(O13=0,\"\",O13)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O2=0,\"\",IF(C5=0,\"\",OFFSET(Cadastro!H1,O1,0)))","v":0}]
[]
[null,"Emitente",{"$f":"IF(O2=1,Empresa!B2,\"\")","v":"LOJA - ME"}]
[null,null,{"$f":"IF(O2=1,Empresa!B3,\"\")","v":"CNPJ: 00.000.000/0000-00"}]
[null,"Endereço",{"$f":"IF(O2=1,Empresa!B4,\"\")","v":"Avenida Vai e Vem, 9999   -  Centro"}]
[]
[]
[null,"Assinatura",null,null,null,null,null,null,null,null,"Versão 1.0"]

{"sheet":"Cadastro","index":7,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Nº\nRecibo","Data","Valor","Cliente","CNPJ / CPF / RG","Endereço","Referente","Validade do\nVale-Compra","Data do uso do Vale-Compra","Observações\ndo uso do\nVale-Compra","Concatenar para Consulta"]
[0,"2015-03-21",null,"Esta linha é só para não dar erro enquanto não tiver recibo. Favor excluir após incluir algum.",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nº \",A2,\"  -  \",D2,\"  -  R$ \",C2)","v":"Nº 0  -  Esta linha é só para não dar erro enquanto não tiver recibo. Favor excluir após incluir algum.  -  R$ "}]

{"sheet":"Transf","index":8,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[2,"2015-10-28",6.66,"Pepe Teste","kdlsd","kkklkl","jkkj hshs  jsjsjsj","2016-02-25",null,null,{"$f":"CONCATENATE(\"Nº \",A3,\"  -  \",D3,\"  -  R$ \",C3)","v":"Nº 2  -  Pepe Teste  -  R$ 6,66"}]