{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Parametri","Firme","Articole","Vanzari","Diagrama"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Diagrama","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Parametri","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Situaţii vânzări",null,"EXEMPLU DEMONSTRATIV"]
[]
["Perioada:","-data început:","2014-01-01"]
[null,"-data sfârşit:","2014-02-28"]
[]
["Monitorizare:",null,"X","Valori posibile:","-X-monitorizare"]
[{"$nulls":4},"-altceva -fără monitorizare"]
[]
["Formular:","firme pe verticală\narticole pe orizontală","X"]
[null,"articole pe verticală\nfirme pe orizontală"]
[]
[null,"valoare livrare","X"]
[null,"cantităţi"]
[]
["Filtru de extragere",null,"\"V\" $ fac->STARE .and. (\"F\" $ fac->CODL.or.fac->TIP=\"TBON\")"]
[]
["Observatii",null,"Exemple de filtre la Firme:"]
[null,null,"- selectati filtru Tip: custom, contains, C  - pentru clienti "]
[null,null,"- selectati filtru Tip: custom, contains, 1  - pentru agent 1"]
[null,null,"- scrieti in coloana Filtru formula =IF(ISERROR(SEARCH(\"Sf*Gheorghe*\",E2)),\"\",\"x\"), "]
[null,null,"   copiati pana la ~ Alte firme, stergeti/adaugati x la anumite pozitii, selectati randurile cu x"]
[]
[]
[null,null,"Exemple de filtre la Articole:"]
[null,null,"- selectati filtru Grupa: custom, begin with, M  - pentru marfuri "]
[null,null,"- selectati filtru Denumire: custom, contains, Cafea - pentru Cafea"]
[null,null,"- scrieti in coloana Filtru formula =IF(ISERROR(SEARCH(\"P?INE*\",B2)),\"\",\"x\")"]
[null,null,"   pentru a selecta articolele PIINE, PAINE, copiati pana la ~ Alte articole,"]
[null,null,"  stergeti/adaugati x la anumite pozitii, selectati randurile cu x"]
[]
[null,null,"Atentie ! Separatorul de liste (cu care se despart argumentele din functie) depinde de setarile din Excel"]

{"sheet":"Firme","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["      Cod      ","           Initiale           ","   Tip    ","      CIF      ","     Localitate     ","Filtru"]
["%TVA   ","TAXA PE VALOAREA ADAUGATA     ","T         ","               ","                    "]
["%UBASFS","BUGET ASIG.SOCIALE SI FD.SPEC.","T         ","               ","                    "]
["%UBS   ","BUGET DE STAT                 ","T         ","               ","                    "]
["0000   ","HAMOR SOFT - DEMONSTRATIE     ","          ","RO547548       ","Sfantu Gheorghe     "]
["0001   ","CONCORDIA SRL                 ","          ","RO22220        ","Sfantu Gheorghe     "]
["0002   ","TABCOM SRL                    ","          ","RO36713        ","Brasov              "]
["0003   ","CALCUL                        ","          ","RO56567        ","Sfantu Gheorghe     "]
["0004   ","BANK SA                       ","          ","RO456890       ","Sfantu Gheorghe     "]
["0005   ","INVEST&TRADING SRL            ","          ","RO27           ","Targu Secuiesc      ","x"]
["0006   ","TOURIST SA                    ","          ","RO1111111119   ","Bucuresti           "]
["0007   ","COPYCALC SRL                  ","          ","RO34127        ","Craiova             ","x"]
["0008   ","EXTAZ-SEE SA                  ","          ","RO88887        ","Constanta           ","x"]
["0009   ","INTERNATIONAL SA              ","          ","RO35           ","Brasov              ","x"]
["0010   ","COMTOUR RA                    ","          ","RO9999997      ","Ploiesti            ","x"]
["0011   ","ELCOMP GMBH.                  ","          ","DE123456788    ","Berlin              ","x"]
["0012   ","ABC LTD.                      ","          ","GB123456782    ","London              ","x"]
["0013   ","BELLA ROMA                    ","          ","IT12345670017  ","Roma                "]
["0014   ","AUSTRALIAN TRADER             ","          ","112233445      ","Sydney              ","x"]
["0015   ","UNREGISTERED LTD.             ","F         ","GB245678920    ","London              "]
["9999   ","ALTII                         ","          ","0              ","Sfantu Gheorghe     ","x"]
["~~~~~~~","Alti parteneri"," "," "," "]

{"sheet":"Articole","index":2,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["      Cod      ","           Denumire           ","Um ","Grupa "," Pret livrare  ","Filtru"]
["!-24%          ","Articol 24%                   ","   ","      ",0]
["!-9%           ","Articol 9%                    ","   ","      ",0]
["!-N            ","Articol neimpozabil           ","   ","GC8   ",0]
["!-SD           ","Articol scutit cu drept deduc.","   ","      ",0]
["!-SF           ","Articol scutit f. drept deduc.","   ","      ",0]
["G-CHERESTEA    ","Cherestea stejar              ","MC ","GP    ",0]
["G-COMBUST      ","Combustibil deduc./nededuc.   ","LT ","GC2   ",0," "]
["G-COMBUST-DEDUC","Combustibil deductibil        ","LT ","GC2   ",0," "]
["G-COMBUST-NEDED","Combustibil nedeductibil      ","LT ","GC2N  ",0]
["G-CUIE         ","Cuie                          ","KG ","GC1   ",0]
["M-APA MINERALA ","Apa minerala                  ","LT ","MA1   ",0.73,"x"]
["M-CAFEA-M      ","Cafea macinata                ","KG ","MA1   ",21.42,"x"]
["M-CAFEA-S      ","Cafea solubila                ","CUT","MA1   ",7.72,"x"]
["M-GRAU-DUR     ","Grau dur                      ","TO ","MCP   ",1000,"x"]
["M-MARFA TVA 24%","Marfa vanduta in magazin aman.","BUC","      ",0]
["M-MARFA TVA 9% ","Marfa vanduta in magazin aman.","BUC","      ",0]
["M-MARFA TVA SD ","Marfa vanduta in magazin aman.","BUC","      ",0]
["M-MARFA TVA SF ","Marfa vanduta in magazin aman.","BUC","      ",0]
["M-PAINE MARE   ","Paine 2 kg                    ","BUC","MA1   ",3.63]
["M-PAINE MICA   ","Paine 1 kg                    ","BUC","MA1   ",2.02]
["M-REVISTA X    ","Revista \"X\"                   ","BUC","MN    ",9.17,"x"]
["M-SFECLA-ZAHAR ","Sfecla de zahar               ","TO ","MCP   ",820,"x"]
["M-TIG-AA       ","Tigarete AA                   ","PAC","MA2   ",4.5,"x"]
["M-ULEI-SOARE   ","Ulei de floarea soarelui      ","LT ","MA1   ",3.3,"x"]
["O-             ","Obiect de inventar            ","   ","GO    ",0]
["P-MASA         ","Masa stejar                   ","BUC","P     ",299.4,"x"]
["S-CONSTRUCTII  ","Lucrari de constructii-montaj ","ORE","S     ",41.92]
["S-TRANSPORT    ","Transport                     ","TKM","S     ",16.77,"x"]
["X-IMOBILIZAR-5%","Imobilizare cu cota de 5%     ","BUC","Y-I   ",0]
["Y-AVANS PRIMIT ","Avans primit                  ","   ","Y-P   ",0]
["Y-AVANS-AIC -24","Avans acordat imob.corporale  ","   ","Y-AIC ",0]
["Y-AVANS-AIN -24","Avans acordat imob.necorporale","   ","Y-AIN ",0]
["Y-AVANS-ASER-00","Avans acordat pt. servicii    ","   ","Y-ASER",0]
["Y-AVANS-ASER-24","Avans acordat pt. servicii    ","   ","Y-ASER",0]
["Y-AVANS-ASTO-24","Avans acordat pt. stocuri     ","   ","Y-ASTO",0]
["Y-AVANS-PRIM-24","Avans primit                  ","   ","Y-P   ",0]
["Y-IMOBILIZAR-24","-                             ","BUC","Y-I   ",0]
["Y-OBIINV-FOL-24","-                             ","BUC","Y-O   ",0]
["~~~~~~~~~~~~~~~","Alte articole"," "," ",0,"x"]

{"sheet":"Vanzari","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["HAMOR Soft - demonstratie"]
["Creat la: 2014.06.05 ora: 11:18:43"]
[null,null,"Vanzari valorice in perioada     01.01.2014   -   28.02.2014  "]
[]
[null,null,"M-CAFEA-M","M-CAFEA-S","Total","~~~~~~~~~~~~~~~","Total"]
[null,null,"Cafea macinata","Cafea solubila",null,"Alte articole","general"]
["0005","INVEST&TRADING SRL",null,null,0,2800,2800]
["0007","COPYCALC SRL"]
["0008","EXTAZ-SEE SA",270,1640,1910,1221.8,3131.8]
["0009","INTERNATIONAL SA",null,null,0,3810,3810]
["0010","COMTOUR RA"]
["0011","ELCOMP GMBH.",null,null,0,4497.9,4497.9]
["0012","ABC LTD.",135,null,135,263.85,398.85]
["0014","AUSTRALIAN TRADER",null,null,0,252.8,252.8]
["9999","ALTII"]
[]
["Total:",null,405,1640,2045,12846.35,14891.349999999999]