{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Asetukset","Laskupohja","Tuotetietokanta","Tuotehinnat","Myyntitietokanta","Myyntiraportti"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"Tuotehinnat","index":3,"reason":"not_a_worksheet"}],"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":"Asetukset","index":0,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Yrityksen nimi","Rakkopojat Oy"]

{"sheet":"Laskupohja","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,4,4,7],[5,4,5,7]]}
[]
[]
[]
[]
[null,null,null,null,{"$f":"yrityksen_nimi","v":"Rakkopojat Oy"}]
[null,null,null,null,{"$f":"TODAY()","v":"2020-04-22"}]
[]
[]
[null,null,null,null,"Tuote","Kpl","Veroton hinta","Veroton Yht"]
[null,null,null,null,"Juomapullo",100,{"$f":"IFERROR(VLOOKUP(E10,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":5},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":500}]
[null,null,null,null,"Teltta",2,{"$f":"IFERROR(VLOOKUP(E11,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":429},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":858}]
[null,null,null,null,"Lenkkitossut",1,{"$f":"IFERROR(VLOOKUP(E12,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":90},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":90}]
[null,null,null,null,"Juoksureppu",4,{"$f":"IFERROR(VLOOKUP(E13,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":50},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":200}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E14,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":""},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E15,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":""},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E16,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":""},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E17,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":""},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E18,Tuotetietokanta!$A$2:$C$5,3,0),\"\")","v":""},{"$f":"IF(Taulukko2[[#This Row],[Tuote]]=\"\",\"\",Taulukko2[[#This Row],[Kpl]]*Taulukko2[[#This Row],[Veroton hinta]])","v":""}]
[null,null,null,null,"Summa",null,{"$f":"SUBTOTAL(101,Taulukko2[Veroton hinta])","v":143.5},{"$f":"SUBTOTAL(109,Taulukko2[Veroton Yht])","v":1648}]

{"sheet":"Tuotetietokanta","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Tuotten nimi","Tuotekategoria","Veroton hinta","Veroprosentti"]
["Juoksureppu","Juoksu",50]
["Juomapullo","Retkeily",5]
["Lenkkitossut","Juoksu",90]
["Teltta","Retkeily",429]

{"sheet":"Myyntitietokanta","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Tuote","Kpl","Veroton hinta","Veroton Yht","Myyntiaika"]
["Teltta",10,429,4290,"2020-04-22T18:00:00"]
["Lenkkitossut",1,90,90,"2020-04-22T18:00:00"]
["Juoksureppu",1,50,50,"2020-04-22T20:00:00"]
["Teltta",2,429,858,"2020-04-22T20:00:00"]
["Juoksureppu",1,50,50,"2020-04-22T20:00:00"]
["Juomapullo",100,5,500,"2020-04-23T08:00:00"]
["Teltta",2,429,858,"2020-04-23T08:00:00"]
["Lenkkitossut",1,90,90,"2020-04-23T08:00:00"]
["Juoksureppu",4,100,200,"2020-04-23T08:00:00"]
["Juomapullo",100,5,500]
["Teltta",2,429,858]
["Lenkkitossut",1,90,90]
["Juoksureppu",4,50,200]

{"sheet":"Myyntiraportti","index":5,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Kpl","(Useita kohteita)"]
[]
["Summa  / Veroton Yht","Sarakeotsikot"]
["Riviotsikot","Juoksureppu","Juomapullo","Teltta","Kaikki yhteensä"]
["22.huhti",null,null,5148,5148]
["23.huhti",200,500,858,1558]
["Kaikki yhteensä",200,500,6006,6706]