{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Taul1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Taul1","index":0,"n_rows":40,"n_cols":34,"rows_kept":40,"cut":false,"hidden":false,"merged":[[31,10,31,11],[32,10,32,11],[39,0,39,11],[1,0,1,1],[2,0,2,1],[2,2,2,3],[3,14,15,24],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[0,0,0,11],[35,0,35,11],[36,0,36,11],[37,0,37,11],[38,0,38,11],[2,11,2,12],[1,2,1,3],[34,4,34,5],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[29,10,29,11],[30,10,30,11]]}
["Tällä excelillä saat tehtyä 22 satunnaista jakolaskua ja laskuruudukkoa.\nTehtävät voit tulostaa oppilaille. Lopussa myös vastaukset, jos niin haluat.\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaettava","Jakaja","Tulos1","Tulos2","Lasku",null,"Jaettava","Jakaja","Tulos1","Tulos2","Lasku",null,null,"Jakaja","Tulos","Desim",null,"Jakaja","Tulos","Desim"]
["Versio",null,"2.2 -makroilla"]
["Muokattu",null,"2024-09-17",null,null,null,null,null,null,null,null,"Desimaalit"]
[null,null,null,null,"Jakaja","Tulos",null,null,"Jakaja","Tulos",null,"Min","Max",null,"Kun haluat arpoa uudet luvut, paina CTRL + k\nSen jälkeen voit vielä muuttaa alla olevia arvoja.\n\nVoit myös itse syöttää jaettavan, jolloin Tulos1 ei vaikuta."]
["Kerrottavat sivu1",null,null,"Min",2,2,null,"Max",9,100,null,0,0]
["Kerrottavat sivu2",null,null,"Min",2,2,null,"Max",9,200,null,0,0]
["Kerrottavat sivu3",null,null,"Min",2,2,null,"Max",9,300,null,0,0]
["Kerrottavat sivu4",null,null,"Min",2,2,null,"Max",9,500,null,0,2]
[]
[]
["Laskutyypit sivu1",null,null,null,"Min",1,null,"Max",1]
["Laskutyypit sivu2",null,null,null,"Min",1,null,"Max",1]
["Laskutyypit sivu3",null,null,null,"Min",1,null,"Max",1]
["Laskutyypit sivu4",null,null,null,"Min",1,null,"Max",1]
["Tulosta vastaukset toisen sivun loppuun (0 = ei, 1 = kyllä)",null,null,null,null,null,null,null,1]
["Tulostuva alue alkaa"]
["Laske allekkain/jakokulmassa. ",null,null,null,null,null,null,null,null,null,null,null,"Sivu1",null,"Jaettava","Jakaja","Tulos1","Tulos2","Lasku",null,"Jaettava","Jakaja","Tulos1","Tulos2","Lasku",null,null,"Jakaja","Tulos","Desim",null,"Jakaja","Tulos","Desim"]
["1.",{"$f":"S18","v":"126 : 3"},null,null,null,null,"4.",{"$f":"Y18","v":"729 : 9"},null,null,null,null,null,null,null,3,42,{"$f":"IF(ISBLANK(O18),,O18/P18)","v":0},{"$f":"IF(ISBLANK(O18),CONCATENATE(P18*Q18,\" : \",P18),CONCATENATE(O18,\" : \",P18))","v":"126 : 3"},{"$f":"IF(ISBLANK(O18),Q18,O18/P18)","v":42},null,9,81,{"$f":"IF(ISBLANK(U18),,U18/V18)","v":0},{"$f":"IF(ISBLANK(U18),CONCATENATE(V18*W18,\" : \",V18),CONCATENATE(U18,\" : \",V18))","v":"729 : 9"},{"$f":"IF(ISBLANK(U18),W18,U18/V18)","v":81},null,{"$f":"RANDBETWEEN($E$5,$I$5)","v":2},{"$f":"RANDBETWEEN($F$5*10^AD18,$J$5*10^AD18)/10^AD18","v":42},{"$f":"RANDBETWEEN($L$5,$M$5)","v":0},null,{"$f":"RANDBETWEEN($E$5,$I$5)","v":7},{"$f":"RANDBETWEEN($F$5*10^AH18,$J$5*10^AH18)/10^AH18","v":7},{"$f":"RANDBETWEEN($L$5,$M$5)","v":0}]
["2.","63 : 9",null,null,null,null,"5.","180 : 9",null,null,null,null,null,null,null,9,7,0,{"$f":"IF(ISBLANK(O19),CONCATENATE(P19*Q19,\" : \",P19),CONCATENATE(O19,\" : \",P19))","v":"63 : 9"},{"$f":"IF(ISBLANK(O19),Q19,O19/P19)","v":7},null,9,20,0,{"$f":"IF(ISBLANK(U19),CONCATENATE(V19*W19,\" : \",V19),CONCATENATE(U19,\" : \",V19))","v":"180 : 9"},{"$f":"IF(ISBLANK(U19),W19,U19/V19)","v":20},null,{"$f":"RANDBETWEEN($E$5,$I$5)","v":9},{"$f":"RANDBETWEEN($F$5*10^AD19,$J$5*10^AD19)/10^AD19","v":85},{"$f":"RANDBETWEEN($L$5,$M$5)","v":0},null,{"$f":"RANDBETWEEN($E$5,$I$5)","v":4},{"$f":"RANDBETWEEN($F$5*10^AH19,$J$5*10^AH19)/10^AH19","v":61},{"$f":"RANDBETWEEN($L$5,$M$5)","v":0}]
["3.","290 : 5",null,null,null,null,"6.","666 : 9",null,null,null,null,null,null,null,5,58,0,"290 : 5",58,null,9,74,0,"666 : 9",74,null,7,45,0,null,9,88,0]
["7.","264 : 3",null,null,null,null,"10.","920 : 8",null,null,null,null,"Sivu2",null,null,3,88,0,"264 : 3",88,null,8,115,0,"920 : 8",115,null,{"$f":"RANDBETWEEN($E$6,$I$6)","v":4},{"$f":"RANDBETWEEN($F$6*10^AD21,$J$6*10^AD21)/10^AD21","v":79},{"$f":"RANDBETWEEN($L$6,$M$6)","v":0},null,{"$f":"RANDBETWEEN($E$6,$I$6)","v":5},{"$f":"RANDBETWEEN($F$6*10^AH21,$J$6*10^AH21)/10^AH21","v":116},{"$f":"RANDBETWEEN($L$6,$M$6)","v":0}]
["8.","450 : 5",null,null,null,null,"11.","508 : 4",null,null,null,null,null,null,null,5,90,0,"450 : 5",90,null,4,127,0,"508 : 4",127,null,{"$f":"RANDBETWEEN($E$6,$I$6)","v":9},{"$f":"RANDBETWEEN($F$6*10^AD22,$J$6*10^AD22)/10^AD22","v":25},{"$f":"RANDBETWEEN($L$6,$M$6)","v":0},null,{"$f":"RANDBETWEEN($E$6,$I$6)","v":7},{"$f":"RANDBETWEEN($F$6*10^AH22,$J$6*10^AH22)/10^AH22","v":56},{"$f":"RANDBETWEEN($L$6,$M$6)","v":0}]
["9.","160 : 2",null,null,null,null,12,"805 : 7",null,null,null,null,null,null,null,2,80,0,"160 : 2",80,null,7,115,0,"805 : 7",115,null,{"$f":"RANDBETWEEN($E$6,$I$6)","v":3},121,0,null,{"$f":"RANDBETWEEN($E$6,$I$6)","v":8},17,0]
["13.","60 : 6",null,null,null,null,"16.","80 : 4",null,null,null,null,"Sivu3",null,null,6,10,0,"60 : 6",10,null,4,20,0,"80 : 4",20,null,{"$f":"RANDBETWEEN($E$7,$I$7)","v":2},{"$f":"RANDBETWEEN($F$7*10^AD24,$J$7*10^AD24)/10^AD24","v":182},{"$f":"RANDBETWEEN($L$7,$M$7)","v":0},null,{"$f":"RANDBETWEEN($E$7,$I$7)","v":4},{"$f":"RANDBETWEEN($F$7*10^AH24,$J$7*10^AH24)/10^AH24","v":260},{"$f":"RANDBETWEEN($L$7,$M$7)","v":0}]
["14.","1064 : 7",null,null,null,null,"17.","704 : 8",null,null,null,null,null,null,null,7,152,0,"1064 : 7",152,null,8,88,0,"704 : 8",88,null,{"$f":"RANDBETWEEN($E$7,$I$7)","v":8},{"$f":"RANDBETWEEN($F$7*10^AD25,$J$7*10^AD25)/10^AD25","v":255},{"$f":"RANDBETWEEN($L$7,$M$7)","v":0},null,{"$f":"RANDBETWEEN($E$7,$I$7)","v":2},{"$f":"RANDBETWEEN($F$7*10^AH25,$J$7*10^AH25)/10^AH25","v":290},{"$f":"RANDBETWEEN($L$7,$M$7)","v":0}]
[15,"1065 : 5",null,null,null,null,"18.","1165 : 5",null,null,null,null,null,null,null,5,213,0,"1065 : 5",213,null,5,233,0,"1165 : 5",233,null,{"$f":"RANDBETWEEN($E$7,$I$7)","v":4},129,0,null,{"$f":"RANDBETWEEN($E$7,$I$7)","v":2},256,0]
["19.","1084 : 4",null,null,null,null,"21.","41,35 : 5",null,null,null,null,"Sivu4",null,null,4,271,0,"1084 : 4",271,null,5,8.27,0,"41,35 : 5",8.27,null,{"$f":"RANDBETWEEN($E$8,$I$8)","v":6},{"$f":"RANDBETWEEN($F$8*10^AD27,$J$8*10^AD27)/10^AD27","v":107.8},{"$f":"RANDBETWEEN($L$8,$M$8)","v":1},null,{"$f":"RANDBETWEEN($E$8,$I$8)","v":9},{"$f":"RANDBETWEEN($F$8*10^AH27,$J$8*10^AH27)/10^AH27","v":410},{"$f":"RANDBETWEEN($L$8,$M$8)","v":0}]
[20,"3645 : 9",null,null,null,null,"22.","864,8 : 4",null,null,null,null,null,null,null,9,405,0,"3645 : 9",405,null,4,216.2,0,"864,8 : 4",216.2,null,{"$f":"RANDBETWEEN($E$8,$I$8)","v":8},{"$f":"RANDBETWEEN($F$8*10^AD28,$J$8*10^AD28)/10^AD28","v":37},{"$f":"RANDBETWEEN($L$8,$M$8)","v":0},null,{"$f":"RANDBETWEEN($E$8,$I$8)","v":8},{"$f":"RANDBETWEEN($F$8*10^AH28,$J$8*10^AH28)/10^AH28","v":91.7},{"$f":"RANDBETWEEN($L$8,$M$8)","v":1}]
["Vastaukset:"]
["1.",{"$f":"T18","v":42},null,"7.",{"$f":"T21","v":88},null,"13.",{"$f":"T24","v":10},null,"19.",{"$f":"T27","v":271}]
["2.",{"$f":"T19","v":7},null,"8.",{"$f":"T22","v":90},null,"14.",{"$f":"T25","v":152},null,"20.",{"$f":"T28","v":405}]
["3.",{"$f":"T20","v":58},null,"9.",{"$f":"T23","v":80},null,"15.",{"$f":"T26","v":213},null,"21.",{"$f":"Z27","v":8.27}]
["4.",{"$f":"Z18","v":81},null,"10.",{"$f":"Z21","v":115},null,"16.",{"$f":"Z24","v":20},null,"22.",{"$f":"Z28","v":216.2}]
["5.",{"$f":"Z19","v":20},null,"11.",{"$f":"Z22","v":127},null,"17.",{"$f":"Z25","v":88}]
["6.",{"$f":"Z20","v":74},null,"12.",{"$f":"Z23","v":115},null,"18.",{"$f":"Z26","v":233}]
["Tulostuva alue loppuu"]
["Tämän sovelman käyttöoikeudet:\nTekijänoikeudet tähän sovellukseen/tiedostoon omistaa Janne Koponen.\nTämä sovellus on ladattavissa osoitteesta http://koulut.tampere.fi/hatanpaa/matikka/monisteita/\nKysymyksiä ja palautetta voi laittaa Janne Koposelle (janne.koponen@tampere.fi)"]
["Mitä saat luvallani tehdä:\n- Saat käyttää sovellusta omassa opetuksessasi ilman erillistä korvausta.\n- Saat antaa tämän sovelluksen vastikkeetta toiselle opettajalle, jonka tunnet. (Jos kollegasi tarjoaa sinulle tästä hyvästä kahvit, on se kuitenkin ok.) Tämä jako-oikeus ei tarkoita kuitenkaan massajakamisia, heitä varten on seuraava kohta.\n- Saat kertoa, mistä tämän latasit, jotta muutkin tätä tarvitsevat tämän löytävät."]
["Mitä et saa tehdä:\n- Ilman erillistä lupaa et saa liittää tätä sovellusta osaksi maksullista tai ilmaista oppimateriaalipakettia.\n- Ilman erillistä lupaa et saa laittaa tätä yleiseen jakoon."]
["Miksi tällaiset ehdot:\n- Tämän systeemin tekemiseen on käytetty jonkin verran aikaa ja suklaata.\n- Käytetty aika on omalla osallani säästynyt jo sillä, ettei minun ole enää tarvinnut yhtä paljon tehdä käsin monisteita tai muokata niitä tarpeen mukaan.\n- Suklaata en tarvitse lisää, mutta haluan pitää itselläni oikeuden vaatia rahallista korvausta, jos joku oppimateriaalivalmistaja haluaa lisätä tämän sovelluksen jakamaansa oppimateriaaliin.\n- Ajansäästön lisäksi uskon myös opetukseni parantuneen, kun olen voinut tarjota oppilailleni juuri heidän taitotasolleen sopivia tehtäviä. Ja toivon muidenkin saavan saman hyödyn."]