{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Leere Vorlage","Bauernbrot","Butterzopf","Schokoladeguetzli","Himbeerkonfitüre","Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Leere Vorlage","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,9,1,13],[3,12,3,13],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,7],[3,8,3,9],[21,13,22,13],[3,10,3,11],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12]]}
[]
["Nährwertberechnung",null,null,"Bitte nur die grau/grün unterlegten Felder ausfüllen",null,null,null,null,null,"Produktname"]
[]
["Zutaten","Menge im Rezept \nin g/ml","Energie",null,null,null,"Fett",null,"Kohlenhydrate\nhydrate",null,"Eiweiss/Protein",null,"Salz"]
[null,null,"kJ/100 g","im Produkt","kcal/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt"]
[null,null,null,{"$f":"(B6*C6)/100","v":0},null,{"$f":"(B6*E6)/100","v":0},null,{"$f":"(B6*G6)/100","v":0},null,{"$f":"(B6*I6)/100","v":0},null,{"$f":"(B6*K6)/100","v":0},null,{"$f":"(B6*M6)/100","v":0}]
[null,null,null,{"$f":"(B7*C7)/100","v":0},null,{"$f":"(B7*E7)/100","v":0},null,{"$f":"(B7*G7)/100","v":0},null,{"$f":"(B7*I7)/100","v":0},null,{"$f":"(B7*K7)/100","v":0},null,{"$f":"(B7*M7)/100","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,{"$f":"(B17*G17)/100","v":0},null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,{"$f":"(B21*C21)/100","v":0},null,0,null,0,null,0,null,0,null,0]
["Gesamtmenge\nnach der Zubereitung",null,null,{"$f":"SUM(D6:D21)","v":0},null,{"$f":"SUM(F6:F21)","v":0},null,{"$f":"SUM(H6:H21)","v":0},null,{"$f":"SUM(J6:J21)","v":0},null,{"$f":"SUM(L6:L21)","v":0},null,{"$f":"SUM(N6:N21)","v":0}]
[]
[]
["Menge pro 100 g",null,null,{"$f":"(D22*100)/$B$22","v":{"$error":"#DIV/0!"}},null,{"$f":"(F22*100)/$B$22","v":{"$error":"#DIV/0!"}},null,{"$f":"(H22*100)/$B$22","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
["© BFS Fachgruppe Direktvermarktung 2020 (Layout)"]
[]
[" "]

{"sheet":"Bauernbrot","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,9,1,13],[3,10,3,11],[3,12,3,13],[18,6,19,6],[18,7,19,7],[18,11,19,11],[18,12,19,12],[18,10,19,10],[18,13,19,13],[18,3,19,3],[18,4,19,4],[3,6,3,7],[3,8,3,9],[18,9,19,9],[3,2,3,5],[18,5,19,5],[18,8,19,8],[3,1,4,1],[3,0,4,0],[18,0,19,0],[18,1,19,1],[18,2,19,2]]}
[]
["Nährwertberechnung",null,null,null,null,null,null,null,null,"Bauernbrot"]
[]
["Zutaten","Menge im Rezept \nin g/ml","Energie",null,null,null,"Fett",null,"Kohlenhydrate\nhydrate",null,"Eiweiss/Protein",null,"Salz"]
[null,null,"kJ/100 g","im Produkt","kcal/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt"]
["Weizenmehl, weiss",3000,1470,{"$f":"(B6*C6)/100","v":44100},346,{"$f":"(B6*E6)/100","v":10380},1.1000000000000001,{"$f":"(B6*G6)/100","v":33.000000000000007},71,{"$f":"(B6*I6)/100","v":2130},11.5,{"$f":"(B6*K6)/100","v":345},0,{"$f":"(B6*M6)/100","v":0}]
["Dinkelmehl, weiss",1000,1480,{"$f":"(B7*C7)/100","v":14800},348,{"$f":"(B7*E7)/100","v":3480},1.5,{"$f":"(B7*G7)/100","v":15},69,{"$f":"(B7*I7)/100","v":690},13.3,{"$f":"(B7*K7)/100","v":133},6.7999999999999996E-3,{"$f":"(B7*M7)/100","v":6.8000000000000005E-2}]
["Roggenmehl, Ruch",1000,1420,14200,336,3360,1.3,13,67.8,{"$f":"(B8*I8)/100","v":678},9,90,3.5999999999999997E-2,0.36]
["Vollmilch, pasteurisiert",2500,284,7100,68,1700,4,100,4.7,117.5,3.2,80,0.13500000000000001,3.375]
["Kochsalz mit Jod & Fluor",100,0,0,0,0,0,0,0,0,0,0,99,99]
["Frischhefe",100,353,353,83,83,1,1,1,1,17,17,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
["Gesamtmenge\nnach der Zubereitung",6470,null,{"$f":"SUM(D6:D18)","v":80553},null,{"$f":"SUM(F6:F18)","v":19003},null,{"$f":"SUM(H6:H18)","v":162},null,{"$f":"SUM(J6:J18)","v":3616.5},null,{"$f":"SUM(L6:L18)","v":665},null,102.803]
[]
[]
["Menge pro 100 g",null,null,{"$f":"(D19*100)/$B$19","v":1245.0231839258115},null,{"$f":"(F19*100)/$B$19","v":293.70942812982997},null,{"$f":"(H19*100)/$B$19","v":2.5038639876352398},null,55.896445131375579,null,10.278207109737249,null,1.5889180834621328]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["© BFS Fachgruppe Direktvermarktung 2020",null,null,null,null,null,null,null,"Quelle Nährwertdaten: www.naehrwertdaten.ch "]
["Eva Flückiger, Paula Furrer-Amrein, Andrea Heimberg Müller, Manuela Isenschmid",null,null,null,null,null,null,null,"Bundesamt für Lebensmittelsicherheit und Veterinärwesen BLV"]

{"sheet":"Butterzopf","index":2,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,9,1,13],[3,12,3,13],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,7],[3,8,3,9],[18,13,19,13],[3,10,3,11],[18,9,19,9],[18,10,19,10],[18,11,19,11],[18,12,19,12]]}
[]
["Nährwertberechnung",null,null,null,null,null,null,null,null,"Butterzopf"]
[]
["Zutaten","Menge im Rezept \nin g/ml","Energie",null,null,null,"Fett",null,"Kohlenhydrate\nhydrate",null,"Eiweiss/Protein",null,"Salz"]
[null,null,"kJ/100 g","im Produkt","kcal/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt"]
["Weizenmehl weiss",4500,1470,{"$f":"(B6*C6)/100","v":66150},346,{"$f":"(B6*E6)/100","v":15570},1.1000000000000001,{"$f":"(B6*G6)/100","v":49.5},71,{"$f":"(B6*I6)/100","v":3195},11.5,{"$f":"(B6*K6)/100","v":517.5},0,{"$f":"(B6*M6)/100","v":0}]
["Dinkelmehl weiss",500,1480,{"$f":"(B7*C7)/100","v":7400},348,{"$f":"(B7*E7)/100","v":1740},1.5,{"$f":"(B7*G7)/100","v":7.5},69,{"$f":"(B7*I7)/100","v":345},13.3,{"$f":"(B7*K7)/100","v":66.5},6.7999999999999996E-3,{"$f":"(B7*M7)/100","v":3.4000000000000002E-2}]
["Kochbutter",500,3060,15300,745,3725,82.2,411,0.7,{"$f":"(B8*I8)/100","v":3.5},0.5,2.5,2.1999999999999999E-2,0.11]
["Vollmilch, pasteurisiert",3000,282,8460,68,2040,4,120,4.7,141,3.2,96,0.13500000000000001,4.05]
["Kochsalz mit Jod & Fluor",100,0,0,0,0,0,0,0,0,0,0,100,100]
["Frischhefe",100,353,353,83,83,1,1,1,1,17,17,0,0]
["Hühnerei, ganz, roh",90,589,530.1,142,127.8,10.3,9.2700000000000014,0.3,0.27,11.9,10.71,0.4,0.36]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
["Gesamtmenge\nnach der Zubereitung",7660,null,{"$f":"SUM(D6:D18)","v":98193.1},null,{"$f":"SUM(F6:F18)","v":23285.8},null,{"$f":"SUM(H6:H18)","v":598.27},null,{"$f":"SUM(J6:J18)","v":3685.77},null,{"$f":"SUM(L6:L18)","v":710.21},null,104.554]
[]
[]
["Menge pro 100 g",null,null,{"$f":"(D19*100)/$B$19","v":1281.8942558746737},null,{"$f":"(F19*100)/$B$19","v":303.9921671018277},null,{"$f":"(H19*100)/$B$19","v":7.8103133159268934},null,48.117101827676237,null,9.2716710182767628,null,1.364934725848564]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["© BFS Fachgruppe Direktvermarktung 2020",null,null,null,null,null,null,null,"Quelle Nährwertdaten: www.naehrwertdaten.ch "]
["Eva Flückiger, Paula Furrer-Amrein, Andrea Heimberg Müller, Manuela Isenschmid",null,null,null,null,null,null,null,"Bundesamt für Lebensmittelsicherheit und Veterinärwesen BLV"]

{"sheet":"Schokoladeguetzli","index":3,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,9,1,13],[3,12,3,13],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,7],[3,8,3,9],[18,13,19,13],[3,10,3,11],[18,9,19,9],[18,10,19,10],[18,11,19,11],[18,12,19,12]]}
[]
["Nährwertberechnung",null,null,null,null,null,null,null,null,"Schokoladeguetzli"]
[]
["Zutaten","Menge im Rezept \nin g/ml","Energie",null,null,null,"Fett",null,"Kohlenhydrate\nhydrate",null,"Eiweiss/Protein",null,"Salz"]
[null,null,"kJ/100 g","im Produkt","kcal/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt"]
["Kochbutter",270,3060,{"$f":"(B6*C6)/100","v":8262},745,{"$f":"(B6*E6)/100","v":2011.5},82.2,{"$f":"(B6*G6)/100","v":221.94},0.7,{"$f":"(B6*I6)/100","v":1.89},0.5,{"$f":"(B6*K6)/100","v":1.35},0,{"$f":"(B6*M6)/100","v":0}]
["Zucker, weiss",220,1700,3740,400,880,0,0,100,220,0,0,1.5E-3,3.3E-3]
["Hühnerei, ganz, roh",160,589,942.4,142,227.2,10.3,16.48,0.3,0.48,11.9,19.04,0.4,0.64]
["Schokolade dunkel (bitter)",150,2240,3360,537,805.5,31.8,47.7,53.4,80.099999999999994,5.2,7.8,1.4999999999999999E-2,2.2499999999999999E-2]
["Weizenmehl, halbweiss",450,1440,6480,340,1530,1.5,6.75,66.2,297.89999999999998,13,58.5,0,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"(B11*M11)/100","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,{"$f":"(B12*M12)/100","v":0}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
["Gesamtmenge\nnach der Zubereitung",1060,null,{"$f":"SUM(D6:D18)","v":22784.400000000001},null,{"$f":"SUM(F6:F18)","v":5454.2},null,{"$f":"SUM(H6:H18)","v":292.87},null,{"$f":"SUM(J6:J18)","v":600.36999999999989},null,{"$f":"SUM(L6:L18)","v":86.69},null,{"$f":"SUM(N6:N18)","v":0.66579999999999995}]
[]
[]
["Menge pro 100 g",null,null,{"$f":"(D19*100)/$B$19","v":2149.4716981132074},null,{"$f":"(F19*100)/$B$19","v":514.54716981132071},null,{"$f":"(H19*100)/$B$19","v":27.629245283018868},null,56.638679245283008,null,8.1783018867924522,null,6.2811320754716973E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["© BFS Fachgruppe Direktvermarktung 2020",null,null,null,null,null,null,null,"Quelle Nährwertdaten: www.naehrwertdaten.ch "]
["Eva Flückiger, Paula Furrer-Amrein, Andrea Heimberg Müller, Manuela Isenschmid",null,null,null,null,null,null,null,"Bundesamt für Lebensmittelsicherheit und Veterinärwesen BLV"]

{"sheet":"Himbeerkonfitüre","index":4,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,9,1,13],[3,12,3,13],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[3,0,4,0],[3,1,4,1],[3,2,3,5],[3,6,3,7],[3,8,3,9],[18,13,19,13],[3,10,3,11],[18,9,19,9],[18,10,19,10],[18,11,19,11],[18,12,19,12]]}
[]
["Nährwertberechnung",null,null,null,null,null,null,null,null,"Himbeerkonfitüre"]
[]
["Zutaten","Menge im Rezept \nin g/ml","Energie",null,null,null,"Fett",null,"Kohlenhydrate\nhydrate",null,"Eiweiss/Protein",null,"Salz"]
[null,null,"kJ/100 g","im Produkt","kcal/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt","g/100 g","im Produkt"]
["Himbeeren*",1000,186,{"$f":"(B6*C6)/100","v":1860},44,{"$f":"(B6*E6)/100","v":440},0.5,{"$f":"(B6*G6)/100","v":5},7.6,{"$f":"(B6*I6)/100","v":76},0.8,{"$f":"(B6*K6)/100","v":8},2.5000000000000001E-2,{"$f":"(B6*M6)/100","v":0.25}]
["Zucker, weiss",900,1700,{"$f":"(B7*C7)/100","v":15300},400,{"$f":"(B7*E7)/100","v":3600},0,{"$f":"(B7*G7)/100","v":0},100,{"$f":"(B7*I7)/100","v":900},0,{"$f":"(B7*K7)/100","v":0},1.5E-3,{"$f":"(B7*M7)/100","v":1.3500000000000002E-2}]
["Zitronensaft",20,125,25,30,6,0.3,0.06,6.1,1.22,0.4,0.08,0.1,0.02]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0]
["Gesamtmenge\nnach der Zubereitung",1800,null,{"$f":"SUM(D6:D18)","v":17185},null,{"$f":"SUM(F6:F18)","v":4046},null,{"$f":"SUM(H6:H18)","v":5.0599999999999996},null,{"$f":"SUM(J6:J18)","v":977.22},null,{"$f":"SUM(L6:L18)","v":8.08},null,0.28350000000000003]
[]
[]
["Menge pro 100 g",null,null,{"$f":"(D19*100)/$B$19","v":954.72222222222217},null,{"$f":"(F19*100)/$B$19","v":224.77777777777777},null,{"$f":"(H19*100)/$B$19","v":0.28111111111111109},null,54.29,null,0.44888888888888889,null,1.575E-2]
[]
[]
["* Werte übernommen von Beeren (Durchschnitt), gekocht (ohne Zugabe von Zucker)"]
[]
[]
[]
[]
[]
[]
[]
[]
["© BFS Fachgruppe Direktvermarktung 2020",null,null,null,null,null,null,null,"Quelle Nährwertdaten: www.naehrwertdaten.ch "]
["Eva Flückiger, Paula Furrer-Amrein, Andrea Heimberg Müller, Manuela Isenschmid",null,null,null,null,null,null,null,"Bundesamt für Lebensmittelsicherheit und Veterinärwesen BLV"]

{"sheet":"Tabelle1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}