{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Tabelle1","Mit Zahlen rechnen","Mit Zahlen rechnen Lösung","Zellbezüge","Zellbezüge Lösung","SUMME","Relative Bezüge","Relative Bezüge Lösung","Absolute Bezüge","Absolute Bezüge Lösung","Provisionen","Provisionen Lösung","Rabatt","Rabatt Lösung"],"not_rendered":{"charts":0,"images":1,"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":"Tabelle1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Mit Zahlen rechnen","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Mit Zahlen rechnen Lösung","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"(6*45+180-50)/2","v":200}]

{"sheet":"Zellbezüge","index":3,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Anzahl Stühle","Preis Stuhl","Preis \nTisch","Gut-schrift","Preis/Person"]
[6,45,180,50]

{"sheet":"Zellbezüge Lösung","index":4,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Anzahl Stühle","Preis Stuhl","Preis \nTisch","Gut-schrift","Preis/Person"]
[6,45,180,50,{"$f":"(A2*B2+C2-D2)/2","v":200}]

{"sheet":"SUMME","index":5,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[12,89,48]
[45,459,246]

{"sheet":"Relative Bezüge","index":6,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Studierendenstatistik 2018/19"]
[]
["Studierendenstatus","Inland Frauen","Inland Männer","Ausland Frauen","Ausland Männer","gesamt"]
["Ordentlich",3,12,12,17]
["Außerordentlich",0,0,0,2]
["Summe:"]

{"sheet":"Relative Bezüge Lösung","index":7,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Studierendenstatistik 2018/19"]
[]
["Studierendenstatus","Inland Frauen","Inland Männer","Ausland Frauen","Ausland Männer","gesamt"]
["Ordentlich",3,12,12,17,{"$f":"SUM(B4:E4)","v":44}]
["Außerordentlich",0,0,0,2,{"$f":"SUM(B5:E5)","v":2}]
["Summe:",{"$f":"SUM(B4:B5)","v":3},{"$f":"SUM(C4:C5)","v":12},{"$f":"SUM(D4:D5)","v":12},{"$f":"SUM(E4:E5)","v":19},{"$f":"SUM(B6:E6)","v":46}]

{"sheet":"Absolute Bezüge","index":8,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Gemüsekonserven"]
["Gesamtfüllgewicht",400]
[]
["Ware","Abtropf-\ngewicht","Tara"]
["Junge Erbsen",280]
["Kidney Bohnen",285]
["Goldmais",285]

{"sheet":"Absolute Bezüge Lösung","index":9,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Gemüsekonserven"]
["Gesamtfüllgewicht",400]
[]
["Ware","Abtropf-\ngewicht","Tara"]
["Junge Erbsen",280,{"$f":"$B$2-B5","v":120}]
["Kidney Bohnen",285,{"$f":"$B$2-B6","v":115}]
["Goldmais",285,115]

{"sheet":"Provisionen","index":10,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Provisionen"]
[null,null,"Projektvol. 1","Projektvol. 2","Projektvol. 3","Projektvol. 4"]
["Mitarbeiter","Anteil",280000,64000,520000,94000]
["Bauer",0.4]
["Huber",0.25]
["Fischer",0.2]
["Maier",0.15]

{"sheet":"Provisionen Lösung","index":11,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Provisionen"]
[null,null,"Projektvol. 1","Projektvol. 2","Projektvol. 3","Projektvol. 4"]
["Mitarbeiter","Anteil",280000,64000,520000,94000]
["Bauer",0.4,{"$f":"C$3*$B4","v":112000},{"$f":"D$3*$B4","v":25600},208000,37600]
["Huber",0.25,{"$f":"C$3*$B5","v":70000},16000,130000,23500]
["Fischer",0.2,56000,12800,104000,18800]
["Maier",0.15,42000,9600,78000,14100]

{"sheet":"Rabatt","index":12,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Rabatt"]
["Preis",0.05,0.1,0.15]
[98.9]
[17.75]
[66]
[49.95]

{"sheet":"Rabatt Lösung","index":13,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Rabatt"]
["Preis",0.05,0.1,0.15]
[98.9,{"$f":"$A3*B$2","v":4.9450000000000003},{"$f":"$A3*C$2","v":9.89},14.835000000000001]
[17.75,{"$f":"$A4*B$2","v":0.88750000000000007},1.7750000000000001,2.6625000000000001]
[66,3.3000000000000003,6.6000000000000005,9.9]
[49.95,2.4975000000000005,4.995000000000001,7.4924999999999997]