{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Bedingung","Rechnen","Wer ist ..","Schleifen","Zahlen","Tabelle3"],"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":"Bedingung","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,0,9,6],[24,2,24,3]]}
[]
[]
["1. Aufgabe",null,null,"Befehl: "]
[]
[null,"Zahl 1","Zahl 2"]
[null,12345,123]
[]
["Beim klicken auf die Schalftfläche Hintergrundfarbe, soll eine bestimmte Hintergrundfarbe gesetzt werden, wenn die Zahl 1 kleiner als die Zahl 2 ist, ansonsten eine andere."]
[]
[]
[1,2,3,4,5,6,7,8]
["2. Aufgabe "]
[null,null,null,null,null,"geg.","zu berechnen","info"]
[null,null,null,null,"Coloirindex",2,3,45]
[]
[null,"Patient"]
[null,"Name","Größe in m","Gewicht ","BMI","Bewertung"]
[null,"Max",1.7,56,19.377162629757787,"normal"]
[null,"Peter ",1.65,85,31.221303948576679,"übergewichtig"]
[null,"Gamze",1.85,74,21.621621621621621,"normal"]
[null,"Ferhat",1.9,102,28.254847645429365,"übergewichtig"]
[null,"Emir",1.56,78,32.051282051282051,"übergewichtig"]
[null,"Marie",1.55,41,17.065556711758582,"untergewichtig"]
[]
[null,null,"BMI"]
[null,null,"von","bis"]
[null,"normal",18.5,24.9]
[null,"untergewichtig",0,18.399999999999999]
[null,"übergewichtig",25,100]
[]
[]
["1. Felder farblich hinterlegen (colorindex)"]
["2. BMI beim ersten ausrechnen ausrechnen und bewerten sowie farblich makieren BMI = gewicht / größe*größe"]
["3. Schleife über alle Patienten und wie 2."]

{"sheet":"Rechnen","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Potenzen berechnen"]
[]
["Potenz bis (Exponent)",5,"Zahl bis (Basis)",10]
[]
["Exponent"]
[0,1,2,3,4,5]
[1,0,0,0,0,0]
[1,1,1,1,1,1]
[1,2,4,8,16,32]
[1,3,9,27,81,243]
[1,4,16,64,256,1024]
[1,5,25,125,625,3125]
[1,6,36,216,1296,7776]
[1,7,49,343,2401,16807]
[1,8,64,512,4096,32768]
[1,9,81,729,6561,59049]
[1,10,100,1000,10000,100000]

{"sheet":"Wer ist ..","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Zahl 1","Zahl 2","Wer ist größer?"]
[5,10,"Zahl 1 ist kleiner als Zahl 2."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Coloindex 34 & 35"]

{"sheet":"Schleifen","index":3,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl","Hintergrundfarbe"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11,null,null,null,"Befehl: "]
[null,12,null,null,null,"Cells(zeile, 3).Interior.ColorIndex = zahl"]
[null,13,null,null,null,"Die zahl muss einen Wert zwischen 1 und 56 enthalten"]
[null,14]
[null,15]
[null,16,null,null,null,"For zaehler = 1 To 56"]
[null,17,null,null,null,"<Befehle, die nun 56 mal ausgeführt werden>"]
[null,18,null,null,null,"Next"]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42,0]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]

{"sheet":"Zahlen","index":4,"n_rows":102,"n_cols":11,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Zahlen"]
[null,"Zahl 1",5]
[null,"Zahl 2",150]
[]
[null,5,20,35,50,65,80,95,110,125,140]
[null,6,21,36,51,66,81,96,111,126,141]
[null,7,22,37,52,67,82,97,112,127,142]
[null,8,23,38,53,68,83,98,113,128,143]
[null,9,24,39,54,69,84,99,114,129,144]
[null,10,25,40,55,70,85,100,115,130,145]
[null,11,26,41,56,71,86,101,116,131,146]
[null,12,27,42,57,72,87,102,117,132,147]
[null,13,28,43,58,73,88,103,118,133,148]
[null,14,29,44,59,74,89,104,119,134,149]
[null,15,30,45,60,75,90,105,120,135,150]
[null,16,31,46,61,76,91,106,121,136,151]
[null,17,32,47,62,77,92,107,122,137,152]
[null,18,33,48,63,78,93,108,123,138,153]
[null,19,34,49,64,79,94,109,124,139,154]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,111,208,305,402,499,596,693,790,887,984]
[null,112,209,306,403,500,597,694,791,888,985]
[null,113,210,307,404,501,598,695,792,889,986]
[null,114,211,308,405,502,599,696,793,890,987]
[null,115,212,309,406,503,600,697,794,891,988]
[null,116,213,310,407,504,601,698,795,892,989]
[null,117,214,311,408,505,602,699,796,893,990]
[null,118,215,312,409,506,603,700,797,894,991]
[null,119,216,313,410,507,604,701,798,895,992]
[null,120,217,314,411,508,605,702,799,896,993]
[null,121,218,315,412,509,606,703,800,897,994]
[null,122,219,316,413,510,607,704,801,898,995]
[null,123,220,317,414,511,608,705,802,899,996]
[null,124,221,318,415,512,609,706,803,900,997]
[null,125,222,319,416,513,610,707,804,901,998]
[null,126,223,320,417,514,611,708,805,902,999]
[null,127,224,321,418,515,612,709,806,903,1000]
[null,128,225,322,419,516,613,710,807,904,1001]
[null,129,226,323,420,517,614,711,808,905,1002]
[null,130,227,324,421,518,615,712,809,906,1003]
[null,131,228,325,422,519,616,713,810,907,1004]
[null,132,229,326,423,520,617,714,811,908,1005]
[null,133,230,327,424,521,618,715,812,909,1006]
[null,134,231,328,425,522,619,716,813,910,1007]
[null,135,232,329,426,523,620,717,814,911,1008]
[null,136,233,330,427,524,621,718,815,912,1009]
[null,137,234,331,428,525,622,719,816,913,1010]
[null,138,235,332,429,526,623,720,817,914,1011]
[null,139,236,333,430,527,624,721,818,915,1012]
[null,140,237,334,431,528,625,722,819,916,1013]
[null,141,238,335,432,529,626,723,820,917,1014]
[null,142,239,336,433,530,627,724,821,918,1015]
[null,143,240,337,434,531,628,725,822,919,1016]
[null,144,241,338,435,532,629,726,823,920,1017]
[null,145,242,339,436,533,630,727,824,921,1018]
[null,146,243,340,437,534,631,728,825,922,1019]
[null,147,244,341,438,535,632,729,826,923,1020]
[null,148,245,342,439,536,633,730,827,924,1021]
[null,149,246,343,440,537,634,731,828,925,1022]
[null,150,247,344,441,538,635,732,829,926,1023]
[null,151,248,345,442,539,636,733,830,927,1024]
[null,152,249,346,443,540,637,734,831,928,1025]

{"sheet":"Tabelle3","index":5,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"' Variablen werden als ganze Zahlen definiert und bekommen Werte zugewiesen"]
[null,"Dim zeile, spalte, ende, zahl As Integer"]
[null,"zeile = 5"]
[null,"spalte = 2"]
[null,"ende = 10"]
[null,"' Schleife von 0 bis ende (=10), d.h. die Anweisungen werden 11 Mal ausgeführt"]
[null,"' For zahl = 0 To ende"]
[null,"' In die Zelle wird die Zahl reingeschrieben und die Hintergrundfarbe gesetzt"]
[null,"Cells(zeile, spalte).Value = zahl"]
[null,"Cells(zeile, spalte).Interior.ColorIndex = 1 + zahl"]
[null,"'Zeile wird um 1 erhöht um in die nächsten Zeile zu schreiben."]
[null,"zeile = zeile + 1"]
[null,"Next"]
[null,"-> Von Zeile 5 bis 10 in Spalte B wird der Zellenhintergrund verändert. "]
[null,"While-Schleife"]