{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Taul1","Ohje","Työt","Välisummat"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Taul1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Ohje","index":1,"n_rows":24,"n_cols":9,"rows_kept":24}
[1,"Laske päiväpalkat Työt-taulukon E-sarakkeeseen. Ne lasketaan kaavalla tunnit*tuntipalkka"]
[null,"Pisteet:","Kaavat soluosoitteilla",{"$nulls":3},2,"p"]
[null,null,"Kaavat aluenimillä",{"$nulls":3},4,"p"]
[2,"Tee seuraavat koosteet"]
[null,"Työntekijät","Viikkopalkka","Viikon työtunnit","Vapaapäivät","Työpäivät"]
[null,"Aapo",248,31,3,4]
[null,"Eero",896,32,5,2]
[null,"Juhani",912,72,1,6]
[null,"Lauri",312,52,3,4]
[null,"Simeoni",400,40,2,5]
[null,"Timo",456,38,2,5]
[null,"Tuomas",750,60,1,6]
[null,"Venla",1020,70,0,7]
[null,"Yhteensä",4994,395,17,39]
[null,"Pisteet:","Mitkä tahansa oikeat kaavat",{"$nulls":3},4,"p"]
[null,null,"Summa.jos palkkaan",{"$nulls":3},6,"p","SUMMA.JOS(Työntekijä;Työntekijät;Päiväpalkka)"]
[null,null," ja tunteihin",{"$nulls":5},"SUMMA.JOS(Työntekijä;Työntekijät;Tunnit)"]
[null,null,"Laske.jos.joukko vapaapäivien laskentaan",{"$nulls":3},8,"p","LASKE.JOS.JOUKKO(Tunnit;\"\";Työntekijä;Työntekijät)"]
[null,null,"Täydellinen suoritus aluenimillä",{"$nulls":3},10,"p"]
[3,"Tee ylläoleva kooste taulukkoon Välisummat välisummilla. Kopioi ensin taulukon Työt tiedot taulukkoon Välisummat."]
[null,"Pisteet:",{"$nulls":4},4,"p"]
[4,"Nauhoita makro, joka valitsee taulukon Työt solut (Ctrl-a) ja tekee niistä Pivot-taulukon, jossa näkyy työntekijöiden viikkopalkka, työpäivät ja työtunnit"]
[null,"Pisteet:",{"$nulls":4},6,"p"]
[null,"Malli:"]

{"sheet":"Työt","index":2,"n_rows":57,"n_cols":5,"rows_kept":57}
["Työntekijä","Päivä","Tunnit","Tuntipalkka","Päiväpalkka"]
["Tuomas","ma",10,10]
["Tuomas","ti",10,10]
["Tuomas","ke",null,10]
["Tuomas","to",10,10]
["Tuomas","pe",10,10]
["Tuomas","la",10,15]
["Tuomas","su",10,20]
["Aapo","ma",null,8]
["Aapo","ti",7,8]
["Aapo","ke",8,8]
["Aapo","to",9,8]
["Aapo","pe",7,8]
["Aapo","la",null,12]
["Aapo","su",null,16]
["Juhani","ma",12,12]
["Juhani","ti",12,12]
["Juhani","ke",12,12]
["Juhani","to",12,12]
["Juhani","pe",12,12]
["Juhani","la",12,16]
["Juhani","su",null,24]
["Eero","ma",null,16]
["Eero","ti",null,16]
["Eero","ke",null,16]
["Eero","to",null,16]
["Eero","pe",null,16]
["Eero","la",16,24]
["Eero","su",16,32]
["Lauri","ma",null,6]
["Lauri","ti",16,6]
["Lauri","ke",16,6]
["Lauri","to",12,6]
["Lauri","pe",8,6]
["Lauri","la",null,9]
["Lauri","su",null,12]
["Timo","ma",8,12]
["Timo","ti",9,12]
["Timo","ke",8,12]
["Timo","to",7,12]
["Timo","pe",6,12]
["Timo","la",null,18]
["Timo","su",null,24]
["Simeoni","ma",8,10]
["Simeoni","ti",8,10]
["Simeoni","ke",8,10]
["Simeoni","to",8,10]
["Simeoni","pe",8,10]
["Simeoni","la",null,15]
["Simeoni","su",null,20]
["Venla","ma",10,12]
["Venla","ti",10,12]
["Venla","ke",10,12]
["Venla","to",10,12]
["Venla","pe",10,12]
["Venla","la",10,18]
["Venla","su",10,24]

{"sheet":"Välisummat","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}