{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Conta 1","Conta 2","Consolidação de Contas"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Conta 1","index":0,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Data","Dia da Semana","Tipo","Valor","Documento","Status","Saldo Anterior","Saldo Final"]
["2015-10-27","Terça-feira","Entrada",2386,"E27102C1","Finalizado",-100,{"$f":"IF(C2=\"Entrada\",G2+D2,G2-D2)","v":2286}]
["2015-10-27","Terça-feira","Saída",9228,"S27103C1","Pendente",{"$f":"H2","v":2286},{"$f":"IF(C3=\"Entrada\",G3+D3,G3-D3)","v":-6942}]
["2015-10-27","Terça-feira","Entrada",8833,"E27104C1","Finalizado",{"$f":"H3","v":-6942},{"$f":"IF(C4=\"Entrada\",G4+D4,G4-D4)","v":1891}]
["2015-10-27","Terça-feira","Entrada",8387,"E27105C1","Finalizado",1891,10278]
["2015-10-27","Terça-feira","Entrada",99,"E27106C1","Finalizado",10278,10377]
["2015-10-27","Terça-feira","Saída",6741,"S27107C1","Finalizado",10377,3636]
["2015-10-28","Quarta-feira","Entrada",694,"E28108C1","Finalizado",3636,4330]
["2015-10-28","Quarta-feira","Saída",6167,"S28109C1","Finalizado",4330,-1837]
["2015-10-28","Quarta-feira","Saída",3512,"S281010C1","Finalizado",-1837,-5349]
["2015-10-28","Quarta-feira","Saída",5665,"S281011C1","Finalizado",-5349,-11014]
["2015-10-28","Quarta-feira","Saída",9126,"S281012C1","Finalizado",-11014,-20140]
["2015-10-28","Quarta-feira","Saída",4163,"S281013C1","Finalizado",-20140,-24303]
["2015-10-28","Quarta-feira","Entrada",9982,"E281014C1","Finalizado",-24303,-14321]
["2015-10-28","Quarta-feira","Entrada",7388,"E281015C1","Finalizado",-14321,-6933]
["2015-10-28","Quarta-feira","Entrada",9974,"E281016C1","Finalizado",-6933,3041]
["2015-10-28","Quarta-feira","Entrada",7380,"E281017C1","Finalizado",3041,10421]
["2015-10-29","Quinta-feira","Entrada",8901,"E291018C1","Finalizado",10421,19322]
["2015-10-30","Sexta-feira","Entrada",5569,"E301019C1","Finalizado",19322,24891]
["2015-10-30","Sexta-feira","Entrada",8906,"E301020C1","Finalizado",24891,33797]
["2015-10-30","Sexta-feira","Saída",3405,"S301021C1","Finalizado",33797,30392]
["2015-10-30","Sexta-feira","Entrada",9326,"E301022C1","Finalizado",30392,39718]
["2015-10-30","Sexta-feira","Entrada",855,"E301023C1","Finalizado",39718,40573]
["2015-10-30","Sexta-feira","Entrada",9863,"E301024C1","Finalizado",40573,50436]
["2015-11-02","Segunda-feira","Saída",2813,"S21125C1","Finalizado",50436,47623]
["2015-11-02","Segunda-feira","Entrada",1294,"E21126C1","Finalizado",47623,48917]
["2015-11-02","Segunda-feira","Saída",6929,"S21127C1","Finalizado",48917,41988]
["2015-11-02","Segunda-feira","Saída",9471,"S21128C1","Finalizado",41988,32517]
["2015-11-02","Segunda-feira","Saída",9650,"S21129C1","Finalizado",32517,22867]
["2015-11-02","Segunda-feira","Saída",4581,"S21130C1","Finalizado",22867,18286]
["2015-11-02","Segunda-feira","Saída",1894,"S21131C1","Finalizado",18286,16392]
["2015-11-02","Segunda-feira","Entrada",9109,"E21132C1","Pendente",16392,25501]
["2015-11-02","Segunda-feira","Entrada",4845,"E21133C1","Finalizado",25501,30346]
["2015-11-03","Terça-feira","Entrada",3249,"E31134C1","Finalizado",30346,33595]
["2015-11-03","Terça-feira","Entrada",9888,"E31135C1","Finalizado",33595,43483]
["2015-11-03","Terça-feira","Entrada",8005,"E31136C1","Finalizado",43483,51488]
["2015-11-03","Terça-feira","Entrada",7307,"E31137C1","Finalizado",51488,58795]
["2015-11-03","Terça-feira","Saída",4132,"S31138C1","Finalizado",58795,54663]
["2015-11-03","Terça-feira","Saída",7526,"S31139C1","Finalizado",54663,47137]

{"sheet":"Conta 2","index":1,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Data","Dia da Semana","Tipo","Valor","Documento","Status","Saldo Anterior","Saldo Final"]
["2015-10-27","Terça-feira","Entrada",7869,"E27102C1","Finalizado",23000,{"$f":"IF(C2=\"Entrada\",G2+D2,G2-D2)","v":30869}]
["2015-10-27","Terça-feira","Entrada",5111,"S27103C1","Finalizado",{"$f":"H2","v":30869},{"$f":"IF(C3=\"Entrada\",G3+D3,G3-D3)","v":35980}]
["2015-10-27","Terça-feira","Entrada",9826,"E27104C1","Finalizado",{"$f":"H3","v":35980},{"$f":"IF(C4=\"Entrada\",G4+D4,G4-D4)","v":45806}]
["2015-10-27","Terça-feira","Entrada",6784,"E27105C1","Finalizado",45806,52590]
["2015-10-27","Terça-feira","Entrada",4830,"E27106C1","Finalizado",52590,57420]
["2015-10-27","Terça-feira","Entrada",1531,"S27107C1","Finalizado",57420,58951]
["2015-10-27","Terça-feira","Entrada",2256,"E28108C1","Finalizado",58951,61207]
["2015-10-27","Terça-feira","Saída",1674,"S28109C1","Finalizado",61207,59533]
["2015-10-27","Terça-feira","Saída",8654,"S281010C1","Finalizado",59533,50879]
["2015-10-27","Terça-feira","Saída",3514,"S281011C1","Pendente",50879,47365]
["2015-10-27","Terça-feira","Saída",9434,"S281012C1","Finalizado",47365,37931]
["2015-10-27","Terça-feira","Saída",1409,"S281013C1","Finalizado",37931,36522]
["2015-10-28","Quarta-feira","Saída",2786,"E281014C1","Finalizado",36522,33736]
["2015-10-28","Quarta-feira","Saída",8751,"E281015C1","Finalizado",33736,24985]
["2015-10-28","Quarta-feira","Saída",9595,"E281016C1","Finalizado",24985,15390]
["2015-10-28","Quarta-feira","Entrada",6306,"E281017C1","Finalizado",15390,21696]
["2015-10-29","Quinta-feira","Entrada",1173,"E291018C1","Finalizado",21696,22869]
["2015-10-29","Quinta-feira","Entrada",6729,"E301019C1","Finalizado",22869,29598]
["2015-10-29","Quinta-feira","Entrada",832,"E301020C1","Finalizado",29598,30430]
["2015-10-29","Quinta-feira","Saída",6723,"S301021C1","Finalizado",30430,23707]
["2015-10-29","Quinta-feira","Entrada",1923,"E301022C1","Finalizado",23707,25630]
["2015-10-29","Quinta-feira","Saída",1998,"E301023C1","Finalizado",25630,23632]
["2015-10-30","Sexta-feira","Entrada",2311,"E301024C1","Finalizado",23632,25943]
["2015-10-31","Sábado","Saída",2160,"S21125C1","Finalizado",25943,23783]
["2015-11-01","Domingo","Entrada",6115,"E21126C1","Finalizado",23783,29898]
["2015-11-02","Segunda-feira","Saída",4963,"S21127C1","Finalizado",29898,24935]
["2015-11-03","Terça-feira","Saída",9989,"S21128C1","Finalizado",24935,14946]
["2015-11-04","Quarta-feira","Saída",7339,"S21129C1","Finalizado",14946,7607]
["2015-11-05","Quinta-feira","Saída",174,"S21130C1","Finalizado",7607,7433]
["2015-11-05","Quinta-feira","Saída",6778,"S21131C1","Finalizado",7433,655]
["2015-11-05","Quinta-feira","Entrada",3062,"E21132C1","Pendente",655,3717]
["2015-11-05","Quinta-feira","Entrada",131,"E21133C1","Finalizado",3717,3848]
["2015-11-05","Quinta-feira","Entrada",8091,"E31134C1","Finalizado",3848,11939]
["2015-11-05","Quinta-feira","Entrada",3537,"E31135C1","Finalizado",11939,15476]
["2015-11-05","Quinta-feira","Entrada",2550,"E31136C1","Finalizado",15476,18026]
["2015-11-05","Quinta-feira","Entrada",1351,"E31137C1","Finalizado",18026,19377]
["2015-11-05","Quinta-feira","Saída",3275,"S31138C1","Finalizado",19377,16102]
["2015-11-05","Quinta-feira","Saída",3090,"S31139C1","Finalizado",16102,13012]

{"sheet":"Consolidação de Contas","index":2,"n_rows":159,"n_cols":8,"rows_kept":159,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Resumo do Consolidado Diário das Contas"]
["Data","Tipo","Valor Entrada","Valor Saída","Origem","Documentos","Saldo Anterior","Saldo Final"]
["2015-10-27","Entrada",19705,null,"Conta 1","E27102C1;E27104C1;E27105C1;E27106C1",0,{"$f":"G3+C3+D3","v":19705}]
["2015-10-27","Saída",null,-6741,"Conta 1","S27107C1",{"$f":"IF(A4<>\"\",H3,\"\")","v":19705},{"$f":"IF(G4<>\"\",G4+C4+D4,\"\")","v":12964}]
["2015-10-28","Entrada",35418,null,"Conta 1","E28108C1;E281014C1;E281015C1;E281016C1;E281017C1",{"$f":"IF(A5<>\"\",H4,\"\")","v":12964},{"$f":"IF(G5<>\"\",G5+C5+D5,\"\")","v":48382}]
["2015-10-28","Saída",null,-28633,"Conta 1","S28109C1;S281010C1;S281011C1;S281012C1;S281013C1",48382,19749]
["2015-10-29","Entrada",8901,null,"Conta 1","E291018C1",19749,28650]
["2015-10-30","Entrada",34519,null,"Conta 1","E301019C1;E301020C1;E301022C1;E301023C1;E301024C1",28650,63169]
["2015-10-30","Saída",null,-3405,"Conta 1","S301021C1",63169,59764]
["2015-11-02","Saída",null,-35338,"Conta 1","S21125C1;S21127C1;S21128C1;S21129C1;S21130C1;S21131C1",59764,24426]
["2015-11-02","Entrada",6139,null,"Conta 1","E21126C1;E21133C1",24426,30565]
["2015-11-03","Entrada",28449,null,"Conta 1","E31134C1;E31135C1;E31136C1;E31137C1",30565,59014]
["2015-11-03","Saída",null,-11658,"Conta 1","S31138C1;S31139C1",59014,47356]
["2015-10-27","Entrada",38207,null,"Conta 2","E27102C1;S27103C1;E27104C1;E27105C1;E27106C1;S27107C1;E28108C1",47356,85563]
["2015-10-27","Saída",null,-21171,"Conta 2","S28109C1;S281010C1;S281012C1;S281013C1",85563,64392]
["2015-10-28","Saída",null,-21132,"Conta 2","E281014C1;E281015C1;E281016C1",64392,43260]
["2015-10-28","Entrada",6306,null,"Conta 2","E281017C1",43260,49566]
["2015-10-29","Entrada",10657,null,"Conta 2","E291018C1;E301019C1;E301020C1;E301022C1",49566,60223]
["2015-10-29","Saída",null,-8721,"Conta 2","S301021C1;E301023C1",60223,51502]
["2015-10-30","Entrada",2311,null,"Conta 2","E301024C1",51502,53813]
["2015-10-31","Saída",null,-2160,"Conta 2","S21125C1",53813,51653]
["2015-11-01","Entrada",6115,null,"Conta 2","E21126C1",51653,57768]
["2015-11-02","Saída",null,-4963,"Conta 2","S21127C1",57768,52805]
["2015-11-03","Saída",null,-9989,"Conta 2","S21128C1",52805,42816]
["2015-11-04","Saída",null,-7339,"Conta 2","S21129C1",42816,35477]
["2015-11-05","Saída",null,-13317,"Conta 2","S21130C1;S21131C1;S31138C1;S31139C1",35477,22160]
["2015-11-05","Entrada",15660,null,"Conta 2","E21133C1;E31134C1;E31135C1;E31136C1;E31137C1",22160,37820]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[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(A69<>\"\",H68,\"\")","v":""},{"$f":"IF(G69<>\"\",G69+C69+D69,\"\")","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[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(A133<>\"\",H132,\"\")","v":""},{"$f":"IF(G133<>\"\",G133+C133+D133,\"\")","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]