{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Rezept Anmerkungen","Rezept 6.2","Rezept 6.3","Rezept 6.4","Rezept 6.5","Rezept 6.6","Rezept 6.7","Rezept 6.8","Rezept 6.9","Rezept 6.10","Rezept 6.11","Rezept 6.12","Rezept 6.13","Rezept 6.14","Rezept 6.15","Rezept 6.16","Rezept 7.1","Rezept 7.2","Rezept 7.3","Rezept 7.4","Rezept 7.5"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Rezept Anmerkungen","index":0,"n_rows":19,"n_cols":1,"rows_kept":19}
{"$rows_empty":7}
["Rezepte aus dem THW-Handbuch"]
[]
["Anmerkungen zu den nachfolgenden Rezepten:"]
[]
["Bei den nachfolgenden Excel-Dateien bitte beachten:"]
[]
["Im braun hinterlegten Feld ist die Personenzahl einzugeben."]
[]
["Die Zellen Ek-Preis in Euro (Spalte E) sollten laufend aktualisiert werden."]
[]
["Die grün hinterlegten Felder nach Möglichkeit nicht verändern,"]
["da dies größteneils Formelfelder sind."]

{"sheet":"Rezept 6.2","index":1,"n_rows":51,"n_cols":7,"rows_kept":51,"merged":[[5,1,5,3],[30,4,30,5],[31,0,32,0],[41,0,42,0]]}
[]
[]
[]
["6.2 Bratfisch mit Kartoffelsalat (Mayonnaise)"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR ","ausblenden"]
[null,10]
[null,null,1]
["Seelachsfilet ",{"v":2,"d":"2.000"},{"$f":"ROUND(B9/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.200"}},"kg",{"v":3.5,"d":"3.50 €"},{"$f":"SUM(E9*C9)","v":{"v":0.7000000000000001,"d":"0.70 €"}}]
["Paniermehl ",{"v":0.2,"d":"0.200"},{"v":0.02,"d":"0.020"},"kg",{"v":2.3,"d":"2.30 €"},{"$f":"SUM(E10*C10)","v":{"v":0.046,"d":"0.05 €"}}]
["Hühnerei, ganz ",{"v":2.5,"d":"2.500"},{"v":0.25,"d":"0.250"},"Stück",{"v":0.14,"d":"0.14 €"},{"v":0.035,"d":"0.04 €"}]
["Bratfett ",{"v":0.1,"d":"0.100"},{"v":0.01,"d":"0.010"},"kg",{"v":1.71,"d":"1.71 €"},{"v":0.0171,"d":"0.02 €"}]
["Kartoffeln, gegart ",{"v":4,"d":"4.000"},{"v":0.4,"d":"0.400"},"kg",{"v":1.3,"d":"1.30 €"},{"v":0.52,"d":"0.52 €"}]
["Mayonnaise 50 % Fett ",{"v":0.5,"d":"0.500"},{"v":0.05,"d":"0.050"},"kg",{"v":2.5,"d":"2.50 €"},{"v":0.125,"d":"0.13 €"}]
["Gewürzgurken ",{"v":0.25,"d":"0.250"},{"v":0.03,"d":"0.030"},"kg",{"v":1.28,"d":"1.28 €"},{"v":0.0384,"d":"0.04 €"}]
["Essig ","ng",null,"ng"]
["Salz ","ng",null,"ng"]
["Pfeffer, weiß ","ng",null,"ng"]
["Zucker ","ng",null,"ng"]
["Senf, mittelscharf ","ng",null,"ng"]
["Petersilie, gehackt ","ng",null,"ng"]
["Teigwaren (ohne Ei) ",{"v":1,"d":"1.000"},{"$f":"ROUND(B22/$B$7*$C$8,2)","v":{"v":0.1,"d":"0.10"}},"kg",{"v":1.04,"d":"1.04 €"},{"$f":"SUM(E22*C22)","v":{"v":0.10400000000000001,"d":"0.10 €"}}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.000"},{"$f":"ROUND(B23/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20 €"}},null,null,{"$f":"SUM(C23)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.500"},{"$f":"ROUND(B24/$B$7*$C$8,2)","v":{"v":0.15,"d":"0.15 €"}},null,null,{"$f":"SUM(C24)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F24)","v":{"v":1.9355000000000002,"d":"1.94 €"}}]
[]
[]
["Eine Portion Verpflegung enthält:"]
[]
["Rohgewicht",720,{"$f":"SUM(B31*$C$8)","v":720},"g","Materialkosten:"]
["Energiewerte ",{"v":3469,"d":"3,469"},{"v":3469,"d":"3,469"},"kJ","Gesamtpreis:",{"$f":"SUM(F26)","v":{"v":1.9355000000000002,"d":"1.94 €"}}]
[null,829,829,"kcal","MwSt.",{"$f":"ROUND(F32*G33,2)","v":0}]
["Eiweiß gesamt ",44,44,"g","Bruttopreis ",{"$f":"SUM(F31:F33)","v":{"v":1.9355000000000002,"d":"1.94 €"}}]
["Fett ",38,38,"g"]
["Kohlenhydrate ",76,76,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht ",null,{"$f":"B31","v":720},"g"]
["Energiewerte ",null,{"v":3469,"d":"3,469"},"kJ"]
[null,null,829,"kcal"]
["Eiweiß gesamt ",null,44,"g"]
["Fett ",null,38,"g"]
["Kohlenhydrate ",null,76,"g"]
[]
["Besondere Hinweise:"]
[]
["Kartoffelsalat gekühlt, max. + 7 °C"]
["Mayonnaise nach Anbruch kühlen "]

{"sheet":"Rezept 6.3","index":2,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[5,1,5,3],[28,4,28,5],[29,0,30,0],[39,0,40,0]]}
[]
[]
[]
["6.3 Bratfisch mit Kartoffelsalat (Brühe)"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Seelachsfilet",{"v":2,"d":"2.000"},{"$f":"ROUND(B9/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.200"}},"kg",{"v":3.5,"d":"3.50 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":0.7,"d":"0.70 €"}}]
["Paniermehl",{"v":0.2,"d":"0.200"},{"$f":"ROUND(B10/$B$7*$C$8,2)","v":{"v":0.02,"d":"0.020"}},"kg",{"v":2.3,"d":"2.30 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":0.05,"d":"0.05 €"}}]
["Hühnerei, ganz",{"v":2.5,"d":"2.500"},{"$f":"ROUND(B11/$B$7*$C$8,2)","v":{"v":0.25,"d":"0.250"}},"Stück",{"v":0.14,"d":"0.14 €"},{"v":0.04,"d":"0.04 €"}]
["Bratfett",{"v":0.1,"d":"0.100"},{"$f":"ROUND(B12/$B$7*$C$8,2)","v":{"v":0.01,"d":"0.010"}},"kg",{"v":1.71,"d":"1.71 €"},{"v":0.02,"d":"0.02 €"}]
["Pellkartoffeln",{"v":1.5,"d":"1.500"},{"$f":"ROUND(B13/$B$7*$C$8,2)","v":{"v":0.15,"d":"0.150"}},"kg",{"v":1.28,"d":"1.28 €"},{"v":0.19,"d":"0.19 €"}]
["Essig",null,null,"ng"]
["Speiseöl",{"v":0.08,"d":"0.080"},{"$f":"ROUND(B15/$B$7*$C$8,2)","v":{"v":0.01,"d":"0.010"}},"ml",{"v":3.83,"d":"3.83 €"},{"v":0.04,"d":"0.04 €"}]
["Fleischbrühe",{"v":0.25,"d":"0.250"},{"$f":"ROUND(B16/$B$7*$C$8,2)","v":{"v":0.03,"d":"0.030"}},"ml",{"v":1.36,"d":"1.36 €"},{"v":0.04,"d":"0.04 €"}]
["Zwiebeln, geschält",{"v":0.15,"d":"0.150"},{"$f":"ROUND(B17/$B$7*$C$8,2)","v":{"v":0.02,"d":"0.020"}},"kg",{"v":1.09,"d":"1.09 €"},{"v":0.02,"d":"0.02 €"}]
["Salz","ng",null,"ng"]
["Pfeffer, weiß","ng",null,"ng"]
["Zucker","ng",null,"ng"]
["Kräuter, gemischt",{"v":1,"d":"1.000"},null,"ng"]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.000"},{"$f":"ROUND(B22/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20 €"}},null,null,{"$f":"SUM(C22)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.500"},{"$f":"ROUND(B23/$B$7*$C$8,2)","v":{"v":0.15,"d":"0.15 €"}},null,null,{"$f":"SUM(C23)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F23)","v":{"v":1.45,"d":"1.45 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht",720,{"$f":"SUM(B29*$C$8)","v":720},"g","Materialkosten:"]
["Energiewerte ",{"v":2340,"d":"2,340"},{"v":2340,"d":"2,340"},"kJ","Gesamtpreis:",{"$f":"SUM(F25)","v":{"v":1.45,"d":"1.45 €"}}]
[null,559,559,"kcal","MwSt.",{"$f":"ROUND(F30*G31,2)","v":0}]
["Eiweiß gesamt ",39,39,"g","Bruttopreis ",{"$f":"SUM(F29:F31)","v":{"v":1.45,"d":"1.45 €"}}]
["Fett ",28,28,"g"]
["Kohlenhydrate ",39,39,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B29","v":720},"g"]
["Energiewerte",null,{"v":2340,"d":"2,340"},"kJ"]
[null,null,559,"kcal"]
["Eiweiß gesamt",null,39,"g"]
["Fett",null,28,"g"]
["Kohlenhydrate",null,39,"g"]
[]
["Besondere Hinweise:"]
[]
["Kartoffelsalat gekühlt, max. + 7 °C"]
["Mayonnaise nach Anbruch kühlen "]

{"sheet":"Rezept 6.4","index":3,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[5,1,5,3],[25,4,25,5],[26,0,27,0],[36,0,37,0]]}
[]
[]
[]
["6.4 Curryhackpfanne mit Butterreis"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Rinder-/Schweinehackfleisch gemischt ",{"v":1.6,"d":"1.600"},{"$f":"ROUND(B9/$B$7*$C$8,2)","v":{"v":0.16,"d":"0.160"}},"kg",{"v":7.2,"d":"7.20 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":1.15,"d":"1.15 €"}}]
["Bratfett ",{"v":0.15,"d":"0.150"},{"$f":"ROUND(B10/$B$7*$C$8,2)","v":{"v":0.02,"d":"0.020"}},"kg",{"v":1.71,"d":"1.71 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":0.03,"d":"0.03 €"}}]
["Zwiebelwürfel ",{"v":1.5,"d":"1.500"},{"$f":"ROUND(B11/$B$7*$C$8,2)","v":{"v":0.15,"d":"0.150"}},"kg",{"v":1.35,"d":"1.35 €"},{"v":0.2,"d":"0.20 €"}]
["Curry ",{"$nulls":4},0]
["Gemüsebrühe ",{"v":5,"d":"5.000"},{"$f":"ROUND(B13/$B$7*$C$8,2)","v":{"v":0.5,"d":"0.500"}},"kg",{"v":0.26,"d":"0.26 €"},{"v":0.13,"d":"0.13 €"}]
["Salz ",null,null,"ng"]
["Schlagsahne 30 % Fett ",{"v":0.3,"d":"0.300"},{"$f":"ROUND(B15/$B$7*$C$8,2)","v":{"v":0.03,"d":"0.030"}},"ml",{"v":1.84,"d":"1.84 €"},{"v":0.06,"d":"0.06 €"}]
["Schmand 20 % Fett ",{"v":0.3,"d":"0.300"},{"v":0.03,"d":"0.030"},"ml",{"v":2.1,"d":"2.10 €"},{"v":0.06,"d":"0.06 €"}]
["Reis, ungeschält ",{"v":0.5,"d":"0.500"},{"v":0.05,"d":"0.050"},"kg",{"v":0.9,"d":"0.90 €"},{"v":0.05,"d":"0.05 €"}]
["Butter ",{"v":0.05,"d":"0.050"},{"v":0.01,"d":"0.010"},"kg",{"v":4.17,"d":"4.17 €"},{"v":0.04,"d":"0.04 €"}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.000"},{"v":0.2,"d":"0.20 €"},null,null,{"$f":"SUM(C19)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.500"},{"v":0.15,"d":"0.15 €"},null,null,{"$f":"SUM(C20)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F18)","v":{"v":1.72,"d":"1.72 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",940,{"$f":"SUM(B26*$C$8)","v":940},"g","Materialkosten:"]
["Energiewerte ",{"v":4089,"d":"4,089"},{"v":4089,"d":"4,089"},"kJ","Gesamtpreis:",{"$f":"SUM(F22)","v":{"v":1.72,"d":"1.72 €"}}]
[null,977,977,"kcal","MwSt.",{"$f":"ROUND(F27*G28,2)","v":0}]
["Eiweiß gesamt ",38,38,"g","Bruttopreis ",{"$f":"SUM(F26:F28)","v":{"v":1.72,"d":"1.72 €"}}]
["Fett ",70,70,"g"]
["Kohlenhydrate ",50,50,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B26","v":940},"g"]
["Energiewerte",null,{"v":4089,"d":"4,089"},"kJ"]
[null,null,977,"kcal"]
["Eiweiß gesamt",null,38,"g"]
["Fett",null,70,"g"]
["Kohlenhydrate",null,50,"g"]

{"sheet":"Rezept 6.5","index":4,"n_rows":45,"n_cols":6,"rows_kept":45,"merged":[[5,1,5,3],[25,4,25,5],[26,0,27,0],[36,0,37,0]]}
[]
[]
[]
["6.5 Erbseneintopf mit Bockwurst"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Erbsen, getrocknet ",{"v":1,"d":"1.000"},{"$f":"ROUND(B9/$B$7*$C$8,2)","v":{"v":0.1,"d":"0.100"}},"kg",{"v":0.56,"d":"0.56 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":0.06,"d":"0.06 €"}}]
["Kartoffeln, geschält ",{"v":2,"d":"2.000"},{"v":0.2,"d":"0.200"},"kg",{"v":1.3,"d":"1.30 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":0.26,"d":"0.26 €"}}]
["Sellerie ",{"v":0.2,"d":"0.200"},{"v":0.02,"d":"0.020"},"g",{"v":2.04,"d":"2.04 €"},{"v":0.04,"d":"0.04 €"}]
["Möhren (Karotten) ",{"v":0.3,"d":"0.300"},{"v":0.03,"d":"0.030"},"g",{"v":0.77,"d":"0.77 €"},{"v":0.02,"d":"0.02 €"}]
["Kasseler ",{"v":0.8,"d":"0.800"},{"v":0.08,"d":"0.080"},"g",{"v":7.94,"d":"7.94 €"},{"v":0.64,"d":"0.64 €"}]
["Speck, durchwachsen, geräuchert ",{"v":0.4,"d":"0.400"},{"v":0.04,"d":"0.040"},"g",{"v":2.81,"d":"2.81 €"},{"v":0.11,"d":"0.11 €"}]
["Lauch ",{"v":0.4,"d":"0.400"},{"v":0.04,"d":"0.040"},"g",{"v":1.53,"d":"1.53 €"},{"v":0.06,"d":"0.06 €"}]
["Fleischbrühe ",{"v":3,"d":"3.000"},{"v":0.3,"d":"0.300"},"l",{"v":1.36,"d":"1.36 €"},{"v":0.41,"d":"0.41 €"}]
["Salz, Pfeffer schwarz, Majoran, getrocknet ",null,null,"ng",null,0]
["Bockwurst ",{"v":1,"d":"1.000"},{"$f":"ROUND(B18/$B$7*$C$8,2)","v":{"v":0.1,"d":"0.100"}},"kg",{"v":7.7,"d":"7.70 €"},{"v":0.77,"d":"0.77 €"}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.00 €"},{"$f":"ROUND(B19/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20 €"}},null,null,{"$f":"SUM(C19)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.50 €"},{"$f":"ROUND(B20/$B$7*$C$8,2)","v":{"v":0.15,"d":"0.15 €"}},null,null,{"$f":"SUM(C20)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F20)","v":{"v":2.72,"d":"2.72 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",910,{"$f":"SUM(B26*$C$8)","v":910},"g","Materialkosten:"]
["Energiewerte ",{"v":4783,"d":"4,783"},{"v":4783,"d":"4,783"},"kJ","Gesamtpreis:",{"$f":"SUM(F22)","v":{"v":2.72,"d":"2.72 €"}}]
[null,{"v":1142,"d":"1,142"},{"v":1142,"d":"1,142"},"kcal","MwSt.",{"$f":"ROUND(F27*G28,2)","v":0}]
["Eiweiß gesamt ",65,65,"g","Bruttopreis ",{"$f":"SUM(F26:F28)","v":{"v":2.72,"d":"2.72 €"}}]
["Fett ",64,64,"g"]
["Kohlenhydrate ",77,77,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B26","v":910},"g"]
["Energiewerte",null,{"v":4783,"d":"4,783"},"kJ"]
[null,null,{"v":1142,"d":"1,142"},"kcal"]
["Eiweiß gesamt",null,65,"g"]
["Fett",null,64,"g"]
["Kohlenhydrate",null,77,"g"]
[]
["Besondere Hinweise:"]
[]
["ggf. Zusatzstoffe: Bockwurst mit Phosphat (s. Etikett/Lieferschein) "]

{"sheet":"Rezept 6.6","index":5,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[5,1,5,3],[23,4,23,5],[24,0,25,0],[34,0,35,0]]}
[]
[]
[]
["6.6 Gedünsteter Seelachs mit Dillrahmsoße und Salzkartoffeln"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Seelachsfilet ",2,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.2},"kg",{"v":3.5,"d":"3.50 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":0.7,"d":"0.70 €"}}]
["Butter ",0.09,{"$f":"ROUND(B10/$B$7*$C$8,3)","v":0.009},"kg",{"v":4.17,"d":"4.17 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":0.04,"d":"0.04 €"}}]
["Kräuter, gemischt ",null,null,"ng"]
["Weizenmehl Type 405 ",0.06,{"$f":"ROUND(B12/$B$7*$C$8,3)","v":0.006},"g",{"v":0.43,"d":"0.43 €"},{"$f":"ROUND(E12*C12,3)","v":{"v":0.003,"d":"0.00 €"}}]
["Gemüsebrühe ",1.25,{"$f":"ROUND(B13/$B$7*$C$8,2)","v":0.13},"l",{"v":0.26,"d":"0.26 €"},{"v":0.03,"d":"0.03 €"}]
["Sahne 10 % Fett ",0.1,{"$f":"ROUND(B14/$B$7*$C$8,2)","v":0.01},"l",{"v":1.59,"d":"1.59 €"},{"v":0.02,"d":"0.02 €"}]
["Salzkartoffeln ",5,{"$f":"ROUND(B15/$B$7*$C$8,2)","v":0.5},"kg",{"v":1.53,"d":"1.53 €"},{"v":0.77,"d":"0.77 €"}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.00 €"},{"$f":"ROUND(B16/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20 €"}},null,null,{"$f":"SUM(C16)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.50 €"},{"$f":"ROUND(B17/$B$7*$C$8,2)","v":{"v":0.15,"d":"0.15 €"}},null,null,{"$f":"SUM(C17)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F17)","v":{"v":1.913,"d":"1.91 €"}}]
[]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",850,{"$f":"SUM(B24*$C$8)","v":850},"g","Materialkosten:"]
["Energiewerte ",{"v":2749,"d":"2,749"},{"v":2749,"d":"2,749"},"kJ","Gesamtpreis:",{"$f":"SUM(F19)","v":{"v":1.913,"d":"1.91 €"}}]
[null,657,657,"kcal","MwSt.",{"$f":"ROUND(F25*G26,2)","v":0}]
["Eiweiß gesamt ",43,43,"g","Bruttopreis ",{"$f":"SUM(F24:F26)","v":{"v":1.913,"d":"1.91 €"}}]
["Fett ",19,19,"g"]
["Kohlenhydrate ",78,78,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B24","v":850},"g"]
["Energiewerte",null,{"v":2749,"d":"2,749"},"kJ"]
[null,null,657,"kcal"]
["Eiweiß gesamt",null,43,"g"]
["Fett",null,19,"g"]
["Kohlenhydrate",null,78,"g"]

{"sheet":"Rezept 6.7","index":6,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[5,1,5,3],[31,4,31,5],[32,0,33,0],[42,0,43,0]]}
[]
[]
[]
["6.7 Geschnetzeltes nach Gyros-Art mit Krautsalat, Tsatziki und Reis"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Schweinefleisch, mager ",2.2,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.22},"kg",{"v":8.18,"d":"8.18 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":1.8,"d":"1.80 €"}}]
["Zwiebelwürfel ",2,{"$f":"ROUND(B10/$B$7*$C$8,2)","v":0.2},"kg",{"v":1.35,"d":"1.35 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":0.27,"d":"0.27 €"}}]
["Salz ",null,null,"ng"]
["Weißkohl ",1.65,{"$f":"ROUND(B12/$B$7*$C$8,2)","v":0.17},"kg",{"v":1.12,"d":"1.12 €"},{"$f":"ROUND(E12*C12,2)","v":{"v":0.19,"d":"0.19 €"}}]
["Zwiebeln, geschält ",2.75,{"$f":"ROUND(B13/$B$7*$C$8,2)","v":0.28},"kg",{"v":1.09,"d":"1.09 €"},{"$f":"ROUND(E13*C13,2)","v":{"v":0.31,"d":"0.31 €"}}]
["Essig ",null,null,"ng"]
["Öl ",null,null,"ng"]
["Pfeffer, weiß ",null,null,"ng"]
["Zucker ",null,null,"ng"]
["Kümmel ",null,null,"ng"]
["Quark 10 % Fett i. Tr. ",0.6,{"$f":"ROUND(B19/$B$7*$C$8,2)","v":0.06},"kg",{"v":1.5,"d":"1.50 €"},{"$f":"ROUND(E19*C19,2)","v":{"v":0.09,"d":"0.09 €"}}]
["Joghurt 3,5 % Fett ",0.4,{"$f":"ROUND(B20/$B$7*$C$8,2)","v":0.04},"kg",{"v":0.81,"d":"0.81 €"},{"$f":"ROUND(E20*C20,2)","v":{"v":0.03,"d":"0.03 €"}}]
["Gurke ",0.4,{"$f":"ROUND(B21/$B$7*$C$8,2)","v":0.04},"kg",{"v":1.1,"d":"1.10 €"},{"$f":"ROUND(E21*C21,2)","v":{"v":0.04,"d":"0.04 €"}}]
["Knoblauch ",null,null,"ng"]
["Petersilie, gehackt ",null,null,"ng"]
["Reis, ungeschält ",{"v":0.75,"d":"0.750"},{"$f":"ROUND(B24/$B$7*$C$8,2)","v":{"v":0.08,"d":"0.080"}},"kg",{"v":0.899,"d":"0.90 €"},{"$f":"ROUND(E24*C24,2)","v":{"v":0.07,"d":"0.07 €"}}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.00 €"},{"$f":"ROUND(B25/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20 €"}},null,null,{"$f":"SUM(C25)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.50 €"},{"$f":"ROUND(B26/$B$7*$C$8,2)","v":{"v":0.15,"d":"0.15 €"}},null,null,{"$f":"SUM(C26)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F26)","v":{"v":3.15,"d":"3.15 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",1090,{"$f":"SUM(B32*$C$8)","v":1090},"g","Materialkosten:"]
["Energiewerte ",{"v":2444,"d":"2,444"},{"v":2444,"d":"2,444"},"kJ","Gesamtpreis:",{"$f":"SUM(F28)","v":{"v":3.15,"d":"3.15 €"}}]
[null,583,583,"kcal","MwSt.",{"$f":"ROUND(F33*G34,2)","v":0}]
["Eiweiß gesamt ",45,45,"g","Bruttopreis ",{"$f":"SUM(F32:F34)","v":{"v":3.15,"d":"3.15 €"}}]
["Fett ",11,11,"g"]
["Kohlenhydrate ",76,76,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B32","v":1090},"g"]
["Energiewerte",null,{"v":2444,"d":"2,444"},"kJ"]
[null,null,583,"kcal"]
["Eiweiß gesamt",null,45,"g"]
["Fett",null,11,"g"]
["Kohlenhydrate",null,76,"g"]

{"sheet":"Rezept 6.8","index":7,"n_rows":40,"n_cols":6,"rows_kept":40,"merged":[[6,1,6,3],[24,4,24,5],[25,0,26,0],[35,0,36,0]]}
[]
[]
[]
["6.8 Hähnchenbrustfilet an Pfefferrahm, Hartweizennudel"]
["und Gemüse"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Hähnchenbrust, tiefgefroren",1.7,{"$f":"ROUND(B10/$B$8*$C$9,2)","v":0.17},"kg",7.42,{"$f":"ROUND(E10*C10,2)","v":1.26}]
["Weizenmehl Type 405 ",0.06,{"$f":"ROUND(B11/$B$8*$C$9,2)","v":0.01},"kg",0.43,{"$f":"ROUND(E11*C11,2)","v":0}]
["Butter ",0.06,{"$f":"ROUND(B12/$B$8*$C$9,2)","v":0.01},"kg",4.17,{"$f":"ROUND(E12*C12,2)","v":0.04}]
["Geflügelbrühe ",1.25,{"$f":"ROUND(B13/$B$8*$C$9,2)","v":0.13},"l",1.36,{"$f":"ROUND(E13*C13,2)","v":0.18}]
["Sahne 10 % Fett ",0.1,{"$f":"ROUND(B14/$B$8*$C$9,2)","v":0.01},"l",1.59,{"$f":"ROUND(E14*C14,2)","v":0.02}]
["Pfefferkörner, grün ",null,null,"ng"]
["Teigwaren aus Hartgrieß ",1,{"$f":"ROUND(B16/$B$8*$C$9,2)","v":0.1},"kg",1.04,{"$f":"ROUND(E16*C16,2)","v":0.1}]
["Mischgemüse ",1.8,{"$f":"ROUND(B17/$B$8*$C$9,2)","v":0.18},"kg",2.18,{"$f":"ROUND(E17*C17,2)","v":0.39}]
["Nutzung Einrichtung, FKH u. Gerät",2,{"$f":"ROUND(B18/$B$8*$C$9,2)","v":{"v":0.2,"d":"0.20"}},null,null,{"$f":"SUM(C18)","v":0.2}]
["Energiekosten",1.5,{"$f":"ROUND(B19/$B$8*$C$9,2)","v":0.15},null,null,{"$f":"SUM(C19)","v":0.15}]
[]
[{"$nulls":5},{"$f":"SUM(F10:F19)","v":2.3400000000000003}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",597,{"$f":"SUM(B25*$C$9)","v":597},"g","Materialkosten:"]
["Energiewerte ",{"v":3312,"d":"3,312"},{"v":3312,"d":"3,312"},"kJ","Gesamtpreis:",{"$f":"SUM(F21)","v":{"v":2.3400000000000003,"d":"2.34 €"}}]
[null,791,791,"kcal","MwSt.",{"$f":"ROUND(F26*G27,2)","v":0}]
["Eiweiß gesamt ",68,68,"g","Bruttopreis ",{"$f":"SUM(F25:F27)","v":{"v":2.3400000000000003,"d":"2.34 €"}}]
["Fett ",17,17,"g"]
["Kohlenhydrate ",89,89,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B25","v":597},"g"]
["Energiewerte",null,{"v":3312,"d":"3,312"},"kJ"]
[null,null,791,"kcal"]
["Eiweiß gesamt",null,68,"g"]
["Fett",null,17,"g"]
["Kohlenhydrate",null,89,"g"]

{"sheet":"Rezept 6.9","index":8,"n_rows":34,"n_cols":6,"rows_kept":34,"merged":[[5,1,5,3],[19,4,19,5],[20,0,21,0],[29,0,30,0]]}
[]
[]
[]
["6.9 Karottentopf, holländisch"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Möhren (Karotten) ",3,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.3},"kg",{"v":0.77,"d":"0.77 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":0.23,"d":"0.23 €"}}]
["Zwiebeln, geschält ",2,0.2,"kg",{"v":1.09,"d":"1.09 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":0.22,"d":"0.22 €"}}]
["Kartoffeln, geschält ",2.5,0.25,"kg",{"v":1.3,"d":"1.30 €"},{"$f":"ROUND(E11*C11,2)","v":{"v":0.33,"d":"0.33 €"}}]
["Bratwurst, Grundbrät ",1.2,0.12,"kg",{"v":7.2,"d":"7.20 €"},{"$f":"ROUND(E12*C12,2)","v":{"v":0.86,"d":"0.86 €"}}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.0"},{"v":0.2,"d":"0.20"},null,null,{"$f":"SUM(C13)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",1.5,0.15,null,null,{"$f":"SUM(C14)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F14)","v":{"v":1.99,"d":"1.99 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",870,{"$f":"SUM(B20*$C$8)","v":870},"g","Materialkosten:"]
["Energiewerte ",{"v":2719,"d":"2,719"},{"v":2719,"d":"2,719"},"kJ","Gesamtpreis:",{"$f":"SUM(F16)","v":{"v":1.99,"d":"1.99 €"}}]
[null,649,649,"kcal","MwSt.",{"$f":"ROUND(F21*G22,2)","v":0}]
["Eiweiß gesamt ",25,25,"g","Bruttopreis ",{"$f":"SUM(F20:F22)","v":{"v":1.99,"d":"1.99 €"}}]
["Fett ",34,34,"g"]
["Kohlenhydrate ",62,62,"g"]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B20","v":870},"g"]
["Energiewerte",null,{"v":2719,"d":"2,719"},"kJ"]
[null,null,649,"kcal"]
["Eiweiß gesamt",null,25,"g"]
["Fett",null,34,"g"]
["Kohlenhydrate",null,62,"g"]

{"sheet":"Rezept 6.10","index":9,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[5,1,5,3],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[22,4,22,5],[23,0,24,0],[33,0,34,0]]}
[]
[]
[]
["6.10 Nudeln “Bologneser Art“"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Rinder-/ Schweinehackfleisch gemischt ",1.5,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.15},"kg",{"v":7.2,"d":"7.20 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":1.08,"d":"1.08 €"}}]
[]
["Bratfett ",0.2,{"$f":"ROUND(B11/$B$7*$C$8,2)","v":0.02},"kg",{"v":1.71,"d":"1.71 €"},{"$f":"ROUND(E11*C11,2)","v":{"v":0.03,"d":"0.03 €"}}]
["Zwiebelwürfel ",1.5,0.15,"kg",{"v":1.35,"d":"1.35 €"},{"$f":"ROUND(E12*C12,2)","v":{"v":0.2,"d":"0.20 €"}}]
["Tomatenmark ",0.5,0.05,"kg",{"v":3.58,"d":"3.58 €"},{"$f":"ROUND(E13*C13,2)","v":{"v":0.18,"d":"0.18 €"}}]
["Brühe, gekörnt ",0.1,0.01,"kg",{"v":4.79,"d":"4.79 €"},{"$f":"ROUND(E14*C14,2)","v":{"v":0.05,"d":"0.05 €"}}]
["Teigwaren aus Hartgrieß ",1.1,0.11,"kg",{"v":1.04,"d":"1.04 €"},{"$f":"ROUND(E15*C15,2)","v":{"v":0.11,"d":"0.11 €"}}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.0"},{"v":0.2,"d":"0.20"},null,null,{"$f":"SUM(C16)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",1.5,0.15,null,null,{"$f":"SUM(C17)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F17)","v":{"v":2,"d":"2.00 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",870,{"$f":"SUM(B23*$C$8)","v":870},"g","Materialkosten:"]
["Energiewerte ",{"v":2719,"d":"2,719"},{"v":2719,"d":"2,719"},"kJ","Gesamtpreis:",{"$f":"SUM(F19)","v":{"v":2,"d":"2.00 €"}}]
[null,649,649,"kcal","MwSt.",{"$f":"ROUND(F24*G25,2)","v":0}]
["Eiweiß gesamt ",25,25,"g","Bruttopreis ",{"$f":"SUM(F23:F25)","v":{"v":2,"d":"2.00 €"}}]
["Fett ",34,34,"g"]
["Kohlenhydrate ",62,62,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B23","v":870},"g"]
["Energiewerte",null,{"v":2719,"d":"2,719"},"kJ"]
[null,null,649,"kcal"]
["Eiweiß gesamt",null,25,"g"]
["Fett",null,34,"g"]
["Kohlenhydrate",null,62,"g"]

{"sheet":"Rezept 6.11","index":10,"n_rows":45,"n_cols":6,"rows_kept":45,"merged":[[6,1,6,3],[29,4,29,5],[30,0,31,0],[40,0,41,0]]}
[]
[]
[]
["6.11 Truthahnschnitzel “Texas Art“ mit Potato Wedges"]
["(Ofenkartoffeln)"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Putenschnitzel ",1.7,{"$f":"ROUND(B10/$B$8*$C$9,2)","v":0.17},"kg",{"v":11.5,"d":"11.50 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":1.96,"d":"1.96 €"}}]
["Zwiebelwürfel ",1,0.1,"kg",{"v":1.35,"d":"1.35 €"},{"v":0.14,"d":"0.14 €"}]
["Paprika, grün ",0.25,0.03,"kg",{"v":2.56,"d":"2.56 €"},{"v":0.08,"d":"0.08 €"}]
["Geflügelbrühe ",1.25,0.13,"l",{"v":1.36,"d":"1.36 €"},{"v":0.18,"d":"0.18 €"}]
["Tomatenmark ",0.5,0.05,"kg",{"v":3.58,"d":"3.58 €"},{"v":0.18,"d":"0.18 €"}]
["Tomaten-Ketchup ",0.3,0.03,"kg",{"v":3.9,"d":"3.90 €"},{"v":0.12,"d":"0.12 €"}]
["Kidney-Bohnen (Konserve) ",0.3,0.03,"kg",{"v":2,"d":"2.00 €"},{"v":0.06,"d":"0.06 €"}]
["Mais (Konserve) ",0.1,0.01,"kg",{"v":5.9,"d":"5.90 €"},{"v":0.06,"d":"0.06 €"}]
["Salz ",null,null,"ng",null,0]
["Paprika, edelsüß ",null,null,"ng",null,0]
["Basilikum ",null,null,"ng",null,0]
["Kartoffeln ",3,{"$f":"ROUND(B21/$B$8*$C$9,2)","v":0.3},"kg",{"v":1.02,"d":"1.02 €"},{"v":0.31,"d":"0.31 €"}]
["Paprika ",null,null,"ng"]
["Nutzung Einrichtung, FKH u. Gerät",2,{"$f":"ROUND(B23/$B$8*$C$9,2)","v":{"v":0.2,"d":"0.20"}},null,null,{"$f":"SUM(C23)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",1.5,{"$f":"ROUND(B24/$B$8*$C$9,2)","v":0.15},null,null,{"$f":"SUM(C24)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F10:F24)","v":{"v":3.440000000000001,"d":"3.44 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",840,{"$f":"SUM(B30*$C$9)","v":840},"g","Materialkosten:"]
["Energiewerte ",{"v":2545,"d":"2,545"},{"v":2545,"d":"2,545"},"kJ","Gesamtpreis:",{"$f":"SUM(F26)","v":{"v":3.440000000000001,"d":"3.44 €"}}]
[null,608,608,"kcal","MwSt.",{"$f":"ROUND(F31*G32,2)","v":0}]
["Eiweiß gesamt ",58,58,"g","Bruttopreis ",{"$f":"SUM(F30:F32)","v":{"v":3.440000000000001,"d":"3.44 €"}}]
["Fett ",13,13,"g"]
["Kohlenhydrate ",65,65,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B30","v":840},"g"]
["Energiewerte",null,{"v":2545,"d":"2,545"},"kJ"]
[null,null,608,"kcal"]
["Eiweiß gesamt",null,58,"g"]
["Fett",null,13,"g"]
["Kohlenhydrate",null,65,"g"]

{"sheet":"Rezept 6.12","index":11,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[6,1,6,3],[32,4,32,5],[33,0,34,0],[42,0,43,0]]}
[]
[]
[]
["6.12 Rindersaftgulasch mit Erbsengemüse und Bandnudeln"]
["(Tagliatelle)"]
[null,"Spalte ausblenden"]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Rindergulasch ",1.8,{"$f":"ROUND(B10/$B$8*$C$9,2)","v":0.18},"kg",{"v":9,"d":"9.00 €"},{"$f":"ROUND(E10*C10,2)","v":{"v":1.62,"d":"1.62 €"}}]
["Bratfett ",0.5,0.05,"kg",{"v":1.71,"d":"1.71 €"},{"v":0.09,"d":"0.09 €"}]
["Zwiebelwürfel ",1,0.1,"kg",{"v":1.35,"d":"1.35 €"},{"v":0.14,"d":"0.14 €"}]
["Tomatenmark ",0.05,0.01,"kg",{"v":3.58,"d":"3.58 €"},{"v":0.04,"d":"0.04 €"}]
["Champignon, gegart (Konserve) ",0.5,0.05,"kg",{"v":3.14,"d":"3.14 €"},{"v":0.16,"d":"0.16 €"}]
["Bratensaft (Braune klare Sauce) ",2.5,0.25,"l",{"v":3.04,"d":"3.04 €"},{"v":0.76,"d":"0.76 €"}]
["Salz ",null,null,"ng",null,0]
["Paprika, edelsüß ",null,null,"ng",null,0]
["Pfeffer, schwarz ",null,null,"ng",null,0]
["Majoran, getrocknet ",null,null,"ng",null,0]
["Knoblauch ",null,null,"ng",null,0]
["Erbsen, grün ",1.5,{"$f":"ROUND(B21/$B$8*$C$9,2)","v":0.15},"kg",{"v":2.49,"d":"2.49 €"},{"v":0.37,"d":"0.37 €"}]
["Butter ",0.2,{"$f":"ROUND(B22/$B$8*$C$9,2)","v":0.02},"kg",null,0]
["Pfeffer, weiß ",null,null,"ng",{"v":4.17,"d":"4.17 €"},0]
["Zucker ",null,null,"ng",null,0]
["Teigwaren( ohne Ei) ",1,{"$f":"ROUND(B25/$B$8*$C$9,2)","v":0.1},"kg",{"v":1.04,"d":"1.04 €"},{"v":0.1,"d":"0.10 €"}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.0"},{"$f":"ROUND(B26/$B$8*$C$9,2)","v":{"v":0.2,"d":"0.20"}},null,null,{"$f":"SUM(C26)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",1.5,{"$f":"ROUND(B27/$B$8*$C$9,2)","v":0.15},null,null,{"$f":"SUM(C27)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F10:F27)","v":{"v":3.630000000000001,"d":"3.63 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",840,{"$f":"SUM(B33*$C$9)","v":840},"g","Materialkosten:"]
["Energiewerte ",{"v":2545,"d":"2,545"},{"v":2545,"d":"2,545"},"kJ","Gesamtpreis:",{"$f":"SUM(F29)","v":{"v":3.630000000000001,"d":"3.63 €"}}]
[null,608,608,"kcal","MwSt.",{"$f":"ROUND(F34*G35,2)","v":0}]
["Eiweiß gesamt ",58,58,"g","Bruttopreis ",{"$f":"SUM(F33:F35)","v":{"v":3.630000000000001,"d":"3.63 €"}}]
["Fett ",13,13,"g"]
["Kohlenhydrate ",65,65,"g"]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B33","v":840},"g"]
["Energiewerte",null,{"v":2545,"d":"2,545"},"kJ"]
[null,null,608,"kcal"]
["Eiweiß gesamt",null,58,"g"]
["Fett",null,13,"g"]
["Kohlenhydrate",null,65,"g"]

{"sheet":"Rezept 6.13","index":12,"n_rows":51,"n_cols":6,"rows_kept":51,"merged":[[4,1,4,3],[36,4,36,5],[37,0,38,0],[46,0,47,0]]}
[]
[]
["6.13 Rinderschmorbraten mit Rotkohl und Kartoffelpüree"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Rinderschmorfleisch ",1.9,{"$f":"ROUND(B8/$B$6*$C$7,2)","v":0.19},"kg",{"v":8.18,"d":"8.18 €"},{"$f":"ROUND(E8*C8,2)","v":{"v":1.55,"d":"1.55 €"}}]
["Bratfett ",0.2,{"$f":"ROUND(B9/$B$6*$C$7,2)","v":0.02},"kg",{"v":1.71,"d":"1.71 €"},{"$f":"ROUND(E9*C9,2)","v":{"v":0.03,"d":"0.03 €"}}]
["Zwiebelwürfel ",0.4,{"$f":"ROUND(B10/$B$6*$C$7,2)","v":0.04},"kg",{"v":1.35,"d":"1.35 €"},{"v":0.05,"d":"0.05 €"}]
["Brühe, instant ",0.02,{"$f":"ROUND(B11/$B$6*$C$7,3)","v":{"v":2E-3,"d":"0.002"}},"kg",{"v":0.02,"d":"0.020 €"},{"$f":"ROUND(E11*C11,5)","v":{"v":4e-05,"d":"0.00 €"}}]
["Tomatenmark ",null,null,"ng",null,0]
["Senf ",null,null,"ng",null,0]
["Weizenmehl Type 405 ",0.1,{"$f":"ROUND(B14/$B$6*$C$7,2)","v":0.01},"kg",{"v":0.43,"d":"0.43 €"},0]
["Rotkohl ",2.2,{"$f":"ROUND(B15/$B$6*$C$7,2)","v":0.22},"kg",{"v":0.7,"d":"0.70 €"},{"v":0.15,"d":"0.15 €"}]
["Schweineschmalz ",0.04,{"$f":"ROUND(B16/$B$6*$C$7,3)","v":0.004},"kg",{"v":1.12,"d":"1.12 €"},{"$f":"ROUND(E16*C16,4)","v":{"v":0.0045,"d":"0.00 €"}}]
["Zwiebeln ",0.3,{"$f":"ROUND(B17/$B$6*$C$7,2)","v":0.03},"kg",{"v":0.87,"d":"0.87 €"},{"v":0.03,"d":"0.03 €"}]
["Apfel ",0.4,{"$f":"ROUND(B18/$B$6*$C$7,2)","v":0.04},"kg",{"v":1.59,"d":"1.59 €"},{"v":0.06,"d":"0.06 €"}]
["Zucker ",null,null,"ng",null,0]
["Salz ",null,null,"ng",null,0]
["Pfeffer, weiß ",null,null,"ng",null,0]
["Nelken ",null,null,"ng",null,0]
["Lorbeerblatt ",null,null,"ng",null,0]
["Wacholderbeeren ",null,null,"ng",null,0]
["Essig ",null,null,"ng",null,0]
["Salzkartoffeln ",1.5,{"$f":"ROUND(B26/$B$6*$C$7,2)","v":0.15},"kg",{"v":1.53,"d":"1.53 €"},{"v":0.23,"d":"0.23 €"}]
["Butter ",0.15,{"$f":"ROUND(B27/$B$6*$C$7,2)","v":0.02},"kg",{"v":4.17,"d":"4.17 €"},{"v":0.08,"d":"0.08 €"}]
["Trinkmilch 3,5 % Fett ",0.3,{"$f":"ROUND(B28/$B$6*$C$7,2)","v":0.03},"ml",{"v":0.56,"d":"0.56 €"},{"v":0.02,"d":"0.02 €"}]
["Muskat ",null,null,"ng"]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.00"},{"$f":"ROUND(B30/$B$6*$C$7,2)","v":{"v":0.2,"d":"0.20"}},null,null,{"$f":"SUM(C30)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.50"},{"$f":"ROUND(B31/$B$6*$C$7,2)","v":0.15},null,null,{"$f":"SUM(C31)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F8:F31)","v":{"v":2.5545400000000003,"d":"2.55 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",749,{"$f":"SUM(B37*$C$7)","v":749},"g","Materialkosten:"]
["Energiewerte ",{"v":3244,"d":"3,244"},{"v":3244,"d":"3,244"},"kJ","Gesamtpreis:",{"$f":"SUM(F33)","v":{"v":2.5545400000000003,"d":"2.55 €"}}]
[null,775,775,"kcal","MwSt.",{"$f":"ROUND(F38*G39,2)","v":0}]
["Eiweiß gesamt ",51,51,"g","Bruttopreis ",{"$f":"SUM(F37:F39)","v":{"v":2.5545400000000003,"d":"2.55 €"}}]
["Fett ",43,43,"g"]
["Kohlenhydrate ",46,46,"g"]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B37","v":749},"g"]
["Energiewerte",null,{"v":3244,"d":"3,244"},"kJ"]
[null,null,775,"kcal"]
["Eiweiß gesamt",null,51,"g"]
["Fett",null,43,"g"]
["Kohlenhydrate",null,46,"g"]

{"sheet":"Rezept 6.14","index":13,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[5,1,5,3],[26,4,26,5],[27,0,28,0],[37,0,38,0]]}
[]
[]
[]
["6.14 Spätzlepfanne, Schwäbisch"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Zwiebelwürfel ",0.3,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.03},"kg",{"v":1.35,"d":"1.35 €"},{"$f":"SUM(E9*C9)","v":{"v":0.0405,"d":"0.04 €"}}]
["Butter ",0.1,{"$f":"ROUND(B10/$B$7*$C$8,2)","v":0.01},"kg",{"v":4.17,"d":"4.17 €"},{"$f":"SUM(E10*C10)","v":{"v":0.0417,"d":"0.04 €"}}]
["Stärke ",0.1,{"$f":"ROUND(B11/$B$7*$C$8,2)","v":0.01},"kg",{"v":1.53,"d":"1.53 €"},{"v":0.015300000000000001,"d":"0.02 €"}]
["Brühe, instant ",0.05,{"$f":"ROUND(B12/$B$7*$C$8,3)","v":0.005},"kg",{"v":20,"d":"20.00 €"},{"v":0.1,"d":"0.10 €"}]
["Schmelzkäse 60 % Fett i. Tr.",0.3,{"$f":"ROUND(B13/$B$7*$C$8,2)","v":0.03},"ng",{"v":6.5,"d":"6.50 €"},{"v":0.195,"d":"0.20 €"}]
["Schlagsahne 30 % Fett ",0.5,0.05,"l",{"v":1.84,"d":"1.84 €"},{"v":0.09200000000000001,"d":"0.09 €"}]
["Schinken, gekocht, gewürfelt",0.5,0.05,"kg",{"v":12.89,"d":"12.89 €"},{"v":0.6445000000000001,"d":"0.64 €"}]
["Erbsen, grün, tiefgefroren ",0.15,{"$f":"ROUND(B16/$B$7*$C$8,3)","v":0.015},"kg",{"v":2.56,"d":"2.56 €"},{"v":0.0384,"d":"0.04 €"}]
["Paprikafrucht, gelb ",0.1,0.01,"kg",{"v":2.56,"d":"2.56 €"},{"v":0.0256,"d":"0.03 €"}]
["Paprikafrucht, grün ",0.1,0.01,"kg",{"v":2.56,"d":"2.56 €"},{"v":0.0256,"d":"0.03 €"}]
["Spätzle ",0.8,0.08,"kg",{"v":2.3,"d":"2.30 €"},{"v":0.184,"d":"0.18 €"}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.00"},{"$f":"ROUND(B20/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20"}},null,null,{"$f":"SUM(C20)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.50"},{"$f":"ROUND(B21/$B$7*$C$8,2)","v":0.15},null,null,{"$f":"SUM(C21)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F21)","v":{"v":1.7526,"d":"1.75 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",310,{"$f":"SUM(B27*$C$8)","v":310},"g","Materialkosten:"]
["Energiewerte ",{"v":3195,"d":"3,195"},{"v":3195,"d":"3,195"},"kJ","Gesamtpreis:",{"$f":"SUM(F23)","v":{"v":1.7526,"d":"1.75 €"}}]
[null,763,763,"kcal","MwSt.",{"$f":"ROUND(F28*G29,2)","v":0}]
["Eiweiß gesamt ",{"v":33.39,"d":"33"},{"v":33.39,"d":"33"},"g","Bruttopreis ",{"$f":"SUM(F27:F29)","v":{"v":1.7526,"d":"1.75 €"}}]
["Fett ",39,39,"g"]
["Kohlenhydrate ",71,71,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B27","v":310},"g"]
["Energiewerte",null,{"v":3195,"d":"3,195"},"kJ"]
[null,null,763,"kcal"]
["Eiweiß gesamt",null,{"v":33.39,"d":"33"},"g"]
["Fett",null,39,"g"]
["Kohlenhydrate",null,71,"g"]

{"sheet":"Rezept 6.15","index":14,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[5,1,5,3],[20,4,20,5],[21,0,22,0],[31,0,32,0]]}
[]
[]
[]
["6.15 Schweinebraten mit Blumenkohl und Kartoffelklößen"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Zwiebeln, geschält ",0.4,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.04},"kg",{"v":1.09,"d":"1.09 €"},{"$f":"SUM(E9*C9)","v":{"v":0.04360000000000001,"d":"0.04 €"}}]
["Schweinebratenfleisch ",1.8,{"$f":"ROUND(B10/$B$7*$C$8,2)","v":0.18},"kg",{"v":8.5,"d":"8.50 €"},{"$f":"SUM(E10*C10)","v":{"v":1.53,"d":"1.53 €"}}]
["Blumenkohl ",3,{"$f":"ROUND(B11/$B$7*$C$8,2)","v":{"v":0.3,"d":"0.30"}},"kg",{"v":2.2,"d":"2.20 €"},{"$f":"SUM(E11*C11)","v":{"v":0.66,"d":"0.66 €"}}]
["Kartoffelklöße (Trockenprodukt)",{"v":0.9,"d":"0.90"},{"$f":"ROUND(B12/$B$7*$C$8,3)","v":{"v":0.09,"d":"0.090"}},"kg",{"v":3.42,"d":"3.42 €"},{"$f":"SUM(E12*C12)","v":{"v":0.30779999999999996,"d":"0.31 €"}}]
["Butter ",0.1,{"$f":"ROUND(B13/$B$7*$C$8,2)","v":0.01},"kg",{"v":4.17,"d":"4.17 €"},{"$f":"SUM(E13*C13)","v":{"v":0.0417,"d":"0.04 €"}}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.00"},{"$f":"ROUND(B14/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20"}},null,null,{"$f":"SUM(C14)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.50"},{"$f":"ROUND(B15/$B$7*$C$8,2)","v":0.15},null,null,{"$f":"SUM(C15)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F15)","v":{"v":2.9331,"d":"2.93 €"}}]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",620,{"$f":"SUM(B21*$C$8)","v":620},"g","Materialkosten:"]
["Energiewerte ",{"v":3065,"d":"3,065"},{"v":3065,"d":"3,065"},"kJ","Gesamtpreis:",{"$f":"SUM(F17)","v":{"v":2.9331,"d":"2.93 €"}}]
[null,732,732,"kcal","MwSt.",{"$f":"ROUND(F22*G23,2)","v":0}]
["Eiweiß gesamt ",50,50,"g","Bruttopreis ",{"$f":"SUM(F21:F23)","v":{"v":2.9331,"d":"2.93 €"}}]
["Fett ",25,25,"g"]
["Kohlenhydrate ",75,75,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B21","v":620},"g"]
["Energiewerte",null,{"v":3065,"d":"3,065"},"kJ"]
[null,null,732,"kcal"]
["Eiweiß gesamt",null,50,"g"]
["Fett",null,25,"g"]
["Kohlenhydrate",null,75,"g"]

{"sheet":"Rezept 6.16","index":15,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[5,1,5,3],[23,4,23,5],[24,0,25,0],[33,0,34,0]]}
[]
[]
[]
["6.16 Schweineschnitzel \"Jäger Art\" mit Pommes frites"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Schweineschnitzel ",1.7,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.17},"kg",{"v":7.41,"d":"7.41 €"},{"$f":"SUM(E9*C9)","v":{"v":1.2597,"d":"1.26 €"}}]
["Bratfett ",0.2,{"$f":"ROUND(B10/$B$7*$C$8,2)","v":0.02},"kg",{"v":1.71,"d":"1.71 €"},{"v":0.0342,"d":"0.03 €"}]
["Zwiebelwürfel ",0.5,0.05,"kg",{"v":1.35,"d":"1.35 €"},{"v":0.0675,"d":"0.07 €"}]
["Champignon ",{"v":1,"d":"1.00"},{"v":0.1,"d":"0.10"},"kg",{"v":4.6,"d":"4.60 €"},{"v":0.45999999999999996,"d":"0.46 €"}]
["Braune Kraftsauce (10 l) l ",1.25,{"$f":"ROUND(B13/$B$7*$C$8,3)","v":0.125},"l",{"v":0.81,"d":"0.81 €"},{"v":0.10125,"d":"0.10 €"}]
["Schlagsahne 30 % Fett ",0.1,0.01,"l",{"v":0.184,"d":"0.18 €"},{"v":0.00184,"d":"0.00 €"}]
["Pommes Frites ",1.4,0.14,"kg",{"v":1.45,"d":"1.45 €"},{"v":0.203,"d":"0.20 €"}]
["Nutzung Einrichtung, FKH u. Gerät",{"v":2,"d":"2.00"},{"$f":"ROUND(B16/$B$7*$C$8,2)","v":{"v":0.2,"d":"0.20"}},null,null,{"$f":"SUM(C16)","v":{"v":0.2,"d":"0.20 €"}}]
["Energiekosten",{"v":1.5,"d":"1.50"},{"$f":"ROUND(B17/$B$7*$C$8,2)","v":0.15},null,null,{"$f":"SUM(C17)","v":{"v":0.15,"d":"0.15 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F17)","v":{"v":2.4774900000000004,"d":"2.48 €"}}]
[]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",542,{"$f":"SUM(B24*$C$8)","v":542},"g","Materialkosten:"]
["Energiewerte ",{"v":2706,"d":"2,706"},{"v":2706,"d":"2,706"},"kJ","Gesamtpreis:",{"$f":"SUM(F19)","v":{"v":2.4774900000000004,"d":"2.48 €"}}]
[null,646,646,"kcal","MwSt.",{"$f":"ROUND(F25*G26,2)","v":0}]
["Eiweiß gesamt ",43,43,"g","Bruttopreis ",{"$f":"SUM(F24:F26)","v":{"v":2.4774900000000004,"d":"2.48 €"}}]
["Fett ",43,43,"g"]
["Kohlenhydrate ",24,24,"g"]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B24","v":542},"g"]
["Energiewerte",null,{"v":2706,"d":"2,706"},"kJ"]
[null,null,646,"kcal"]
["Eiweiß gesamt",null,43,"g"]
["Fett",null,43,"g"]
["Kohlenhydrate",null,24,"g"]

{"sheet":"Rezept 7.1","index":16,"n_rows":34,"n_cols":6,"rows_kept":34,"merged":[[5,1,5,3],[18,4,18,5],[19,0,20,0],[29,0,30,0]]}
[]
[]
[]
["7.1 Karamelcreme mit Sahne"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Zucker ",0.3,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.03},"kg",{"v":0.97,"d":"0.97 €"},{"$f":"SUM(E9*C9)","v":{"v":0.029099999999999997,"d":"0.03 €"}}]
["Trinkmilch 3,5 % Fett ",1.25,{"$f":"ROUND(B10/$B$7*$C$8,2)","v":0.13},"l",{"v":0.56,"d":"0.56 €"},{"$f":"SUM(E10*C10)","v":{"v":0.0728,"d":"0.07 €"}}]
["Stärke ",0.1,{"$f":"ROUND(B11/$B$7*$C$8,2)","v":0.01},"kg",{"v":1.53,"d":"1.53 €"},{"$f":"SUM(E11*C11)","v":{"v":0.015300000000000001,"d":"0.02 €"}}]
["Schlagsahne 30 % Fett ",{"v":0.1,"d":"0.10"},{"$f":"ROUND(B12/$B$7*$C$8,2)","v":0.01},"l",{"v":1.84,"d":"1.84 €"},{"$f":"SUM(E12*C12)","v":{"v":0.0184,"d":"0.02 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F12)","v":{"v":0.1356,"d":"0.14 €"}}]
[]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",175,{"$f":"SUM(B19*$C$8)","v":175},"g","Materialkosten:"]
["Energiewerte ",{"v":1110,"d":"1,110"},{"v":1110,"d":"1,110"},"kJ","Gesamtpreis:",{"$f":"SUM(F14)","v":{"v":0.1356,"d":"0.14 €"}}]
[null,265,265,"kcal","MwSt.",{"$f":"ROUND(F20*G21,2)","v":0}]
["Eiweiß gesamt ",4,4,"g","Bruttopreis ",{"$f":"SUM(F19:F21)","v":{"v":0.1356,"d":"0.14 €"}}]
["Fett ",7,7,"g"]
["Kohlenhydrate ",45,45,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B19","v":175},"g"]
["Energiewerte",null,{"v":1110,"d":"1,110"},"kJ"]
[null,null,265,"kcal"]
["Eiweiß gesamt",null,4,"g"]
["Fett",null,7,"g"]
["Kohlenhydrate",null,45,"g"]

{"sheet":"Rezept 7.2","index":17,"n_rows":35,"n_cols":6,"rows_kept":35,"merged":[[5,1,5,3],[19,4,19,5],[20,0,21,0],[30,0,31,0]]}
[]
[]
[]
["7.2 Haselnussquark"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Quark, Magerstufe ",1,{"$f":"ROUND(B9/$B$7*$C$8,2)","v":0.1},"kg",{"v":1.5,"d":"1.50 €"},{"$f":"SUM(E9*C9)","v":{"v":0.15000000000000002,"d":"0.15 €"}}]
["Schlagsahne 30 % Fett ",0.2,{"$f":"ROUND(B10/$B$7*$C$8,2)","v":0.02},"l",{"v":1.84,"d":"1.84 €"},{"$f":"SUM(E10*C10)","v":{"v":0.0368,"d":"0.04 €"}}]
["Butter ",0.05,{"$f":"ROUND(B11/$B$7*$C$8,3)","v":0.005},"kg",{"v":4.17,"d":"4.17 €"},{"$f":"SUM(E11*C11)","v":{"v":0.02085,"d":"0.02 €"}}]
["Haselnüsse, gehackt ",0.1,{"$f":"ROUND(B12/$B$7*$C$8,2)","v":0.01},"kg",{"v":6.5,"d":"6.50 €"},{"$f":"SUM(E12*C12)","v":{"v":0.065,"d":"0.07 €"}}]
["Zucker ",0.15,{"$f":"ROUND(B13/$B$7*$C$8,2)","v":0.02},"kg",{"v":0.97,"d":"0.97 €"},{"$f":"SUM(E13*C13)","v":{"v":0.0194,"d":"0.02 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F13)","v":{"v":0.29205000000000003,"d":"0.29 €"}}]
[]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",150,{"$f":"SUM(B20*$C$8)","v":150},"g","Materialkosten:"]
["Energiewerte ",{"v":1222,"d":"1,222"},{"v":1222,"d":"1,222"},"kJ","Gesamtpreis:",{"$f":"SUM(F15)","v":{"v":0.29205000000000003,"d":"0.29 €"}}]
[null,292,292,"kcal","MwSt.",{"$f":"ROUND(F21*G22,2)","v":0}]
["Eiweiß gesamt ",15,15,"g","Bruttopreis ",{"$f":"SUM(F20:F22)","v":{"v":0.29205000000000003,"d":"0.29 €"}}]
["Fett ",17,17,"g"]
["Kohlenhydrate ",21,21,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B20","v":150},"g"]
["Energiewerte",null,{"v":1222,"d":"1,222"},"kJ"]
[null,null,292,"kcal"]
["Eiweiß gesamt",null,15,"g"]
["Fett",null,17,"g"]
["Kohlenhydrate",null,21,"g"]

{"sheet":"Rezept 7.3","index":18,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[5,1,5,3],[20,4,20,5],[21,0,22,0],[31,0,32,0]]}
[]
[]
[]
["7.3 Milchreis mit Fruchtsoße"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Trinkmilch 3,5 % Fett ",1.25,{"$f":"ROUND(B9/$B$7*$C$8,3)","v":0.125},"l",{"v":0.56,"d":"0.56 €"},{"$f":"SUM(E9*C9)","v":{"v":0.07,"d":"0.07 €"}}]
["Zucker ",0.15,{"$f":"ROUND(B10/$B$7*$C$8,3)","v":0.015},"kg",{"v":0.97,"d":"0.97 €"},{"$f":"SUM(E10*C10)","v":{"v":0.014549999999999999,"d":"0.01 €"}}]
["Reis, Rundkorn ",0.2,{"$f":"ROUND(B11/$B$7*$C$8,3)","v":{"v":0.02,"d":"0.020"}},"kg",{"v":2.04,"d":"2.04 €"},{"$f":"SUM(E11*C11)","v":{"v":0.0408,"d":"0.04 €"}}]
["Aprikose (Konserve) ",0.4,{"$f":"ROUND(B12/$B$7*$C$8,2)","v":0.04},"kg",{"v":2.7,"d":"2.70 €"},{"$f":"SUM(E12*C12)","v":{"v":0.10800000000000001,"d":"0.11 €"}}]
["Schlagsahne 30 % Fett ",0.1,{"$f":"ROUND(B13/$B$7*$C$8,2)","v":0.01},"l",{"v":1.84,"d":"1.84 €"},{"$f":"SUM(E13*C13)","v":{"v":0.0184,"d":"0.02 €"}}]
["Zitrone, Fruchtsaft ",null,"ng"]
[]
[{"$nulls":5},{"$f":"SUM(F9:F14)","v":{"v":0.25175000000000003,"d":"0.25 €"}}]
[]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",210,{"$f":"SUM(B21*$C$8)","v":210},"g","Materialkosten:"]
["Energiewerte ",{"v":1126,"d":"1,126"},{"v":1126,"d":"1,126"},"kJ","Gesamtpreis:",{"$f":"SUM(F16)","v":{"v":0.25175000000000003,"d":"0.25 €"}}]
[null,269,269,"kcal","MwSt.",{"$f":"ROUND(F22*G23,2)","v":0}]
["Eiweiß gesamt ",6,6,"g","Bruttopreis ",{"$f":"SUM(F21:F23)","v":{"v":0.25175000000000003,"d":"0.25 €"}}]
["Fett ",8,8,"g"]
["Kohlenhydrate ",44,44,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B21","v":210},"g"]
["Energiewerte",null,{"v":1126,"d":"1,126"},"kJ"]
[null,null,269,"kcal"]
["Eiweiß gesamt",null,6,"g"]
["Fett",null,8,"g"]
["Kohlenhydrate",null,44,"g"]

{"sheet":"Rezept 7.4","index":19,"n_rows":35,"n_cols":6,"rows_kept":35,"merged":[[5,1,5,3],[19,4,19,5],[20,0,21,0],[30,0,31,0]]}
[]
[]
[]
["7.4 Obstsalat"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Banane ",0.3,{"$f":"ROUND(B9/$B$7*$C$8,3)","v":{"v":0.03,"d":"0.030"}},"kg",{"v":1.33,"d":"1.33 €"},{"$f":"SUM(E9*C9)","v":{"v":0.0399,"d":"0.04 €"}}]
["Apfel ",0.4,{"$f":"ROUND(B10/$B$7*$C$8,3)","v":0.04},"kg",{"v":1.59,"d":"1.59 €"},{"$f":"SUM(E10*C10)","v":{"v":0.0636,"d":"0.06 €"}}]
["Obst, gemischt ",0.5,{"$f":"ROUND(B11/$B$7*$C$8,3)","v":{"v":0.05,"d":"0.050"}},"kg",{"v":2.04,"d":"2.04 €"},{"$f":"SUM(E11*C11)","v":{"v":0.10200000000000001,"d":"0.10 €"}}]
["Zitrone, Fruchtsaft ",null,"ng"]
["Zucker ",0.05,{"$f":"ROUND(B13/$B$7*$C$8,2)","v":0.01},"kg",{"v":0.97,"d":"0.97 €"},{"$f":"SUM(E13*C13)","v":{"v":0.0097,"d":"0.01 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F13)","v":{"v":0.2152,"d":"0.22 €"}}]
[]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",125,{"$f":"SUM(B20*$C$8)","v":125},"g","Materialkosten:"]
["Energiewerte ",465,465,"kJ","Gesamtpreis:",{"$f":"SUM(F15)","v":{"v":0.2152,"d":"0.22 €"}}]
[null,111,111,"kcal","MwSt.",{"$f":"ROUND(F21*G22,2)","v":0}]
["Eiweiß gesamt ","<1","<1","g","Bruttopreis ",{"$f":"SUM(F20:F22)","v":{"v":0.2152,"d":"0.22 €"}}]
["Fett ","<1","<1","g"]
["Kohlenhydrate ",26,26,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B20","v":125},"g"]
["Energiewerte",null,465,"kJ"]
[null,null,111,"kcal"]
["Eiweiß gesamt",null,"<1","g"]
["Fett",null,"<1","g"]
["Kohlenhydrate",null,26,"g"]

{"sheet":"Rezept 7.5","index":20,"n_rows":35,"n_cols":6,"rows_kept":35,"merged":[[5,1,5,3],[19,4,19,5],[20,0,21,0],[30,0,31,0]]}
[]
[]
[]
["7.5 Quarkspeise mit Früchten\n"]
[]
["Zutaten ","Menge ",null,null,"Ek-Preis in EUR ","Summe in EUR "]
[null,10]
[null,null,1]
["Quark, Magerstufe ",1,{"$f":"ROUND(B9/$B$7*$C$8,3)","v":{"v":0.1,"d":"0.100"}},"kg",{"v":1.5,"d":"1.50 €"},{"$f":"SUM(E9*C9)","v":{"v":0.15000000000000002,"d":"0.15 €"}}]
["Trinkmilch 3,5 % Fett ",0.5,{"$f":"ROUND(B10/$B$7*$C$8,3)","v":0.05},"l",{"v":0.56,"d":"0.56 €"},{"$f":"SUM(E10*C10)","v":{"v":0.028000000000000004,"d":"0.03 €"}}]
["Zucker ",0.15,{"$f":"ROUND(B11/$B$7*$C$8,3)","v":0.015},"kg",{"v":0.97,"d":"0.97 €"},{"$f":"SUM(E11*C11)","v":{"v":0.014549999999999999,"d":"0.01 €"}}]
["Erdbeere ",0.5,{"$f":"ROUND(B12/$B$7*$C$8,3)","v":0.05},"kg",{"v":2.48,"d":"2.48 €"},{"$f":"SUM(E12*C12)","v":{"v":0.124,"d":"0.12 €"}}]
["Schlagsahne 30 % Fett ",0.15,{"$f":"ROUND(B13/$B$7*$C$8,3)","v":0.015},"l",{"v":1.84,"d":"1.84 €"},{"$f":"SUM(E13*C13)","v":{"v":0.0276,"d":"0.03 €"}}]
[]
[{"$nulls":5},{"$f":"SUM(F9:F13)","v":{"v":0.34415,"d":"0.34 €"}}]
[]
[]
["Die Verpflegung enthält:"]
[]
["Rohgewicht ",230,{"$f":"SUM(B20*$C$8)","v":230},"g","Materialkosten:"]
["Energiewerte ",935,935,"kJ","Gesamtpreis:",{"$f":"SUM(F15)","v":{"v":0.34415,"d":"0.34 €"}}]
[null,223,223,"kcal","MwSt.",{"$f":"ROUND(F21*G22,2)","v":0}]
["Eiweiß gesamt ",16,16,"g","Bruttopreis ",{"$f":"SUM(F20:F22)","v":{"v":0.34415,"d":"0.34 €"}}]
["Fett ",7,7,"g"]
["Kohlenhydrate ",25,25,"g"]
[]
[]
["Eine Portion enthält:"]
[]
["Rohgewicht",null,{"$f":"B20","v":230},"g"]
["Energiewerte",null,935,"kJ"]
[null,null,223,"kcal"]
["Eiweiß gesamt",null,16,"g"]
["Fett",null,7,"g"]
["Kohlenhydrate",null,25,"g"]