{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Tabelle1","farm1","farbe","Halle","Fahrer","LKW","Mast","Impf"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":10,"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":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[[20,0,25,15],[0,15,0,16]]}
[null,"Anzahl",null,null,"Anzahl ","Höhe",null,null,null,null,null,null,null,null,null,"Eingabemaske"]
[null,"Eier",null,null,"Küken/H","WG/H",null,null,null,null,null,null,"LKW",null,null,4,{"$f":"Q8/E3","v":26.409638554216869}]
[null,50000,null,null,83,32,null,null,null,null,null,null,"Fahrer",null,null,2,{"$f":"ROUND(Q2,0)","v":26}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B12*E3","v":2158}]
[null,"ETH",null,null,"Farbe","Halle",null,null,null,null,null,null,"Mast",null,null,17,{"$f":"B3/E3/F3","v":18.825301204819276},{"$f":"ROUNDDOWN(Q5,0)","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Impfung",null,null,4]
[null,13,null,null,10,2,null,null,null,null,null,null,null,null,null,null,{"$f":"B10*E3*F3","v":47808}]
[null,{"$f":"B7-1","v":12},null,null,{"$f":"E7-1","v":9},{"$f":"F7-1","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"B3-Q7","v":2192}]
[]
[null,{"$f":"R5","v":18},null,null,"WG",{"$f":"Q7","v":47808}]
[null,null,null,null,null,null,null,{"$f":"F10+F12","v":49966}]
[null,{"$f":"Q3","v":26},null,null,"H",{"$f":"Q4","v":2158}]
[]
[]
[]
[null,{"$f":"_xlfn.IFNA(VLOOKUP(B8,farm1,2),\"0\")","v":"Farm 12"},null,null,{"$f":"_xlfn.IFNA(VLOOKUP(E8,farbe1,2),\"0\")","v":"grau"},{"$f":"B10","v":18},"x",{"$f":"F3","v":32},null,"=",{"$f":"F10","v":47808},null,{"$f":"H11","v":49966},null,{"$f":"VLOOKUP(P6,Impf!A1:B11,2)","v":"Primer 1/1"},{"$f":"VLOOKUP(P2,LKW!A1:B16,2)","v":"LKW 3"}]
[{"$f":"E3","v":83},null,null,{"$f":"_xlfn.IFNA(VLOOKUP(F8,halle,2),\"0\")","v":"H 1"},null,1,"x",{"$f":"B12","v":26},"H","=",{"$f":"F12","v":2158},null,null,null,null,{"$f":"VLOOKUP(P3,Fahrer!A1:B24,2)","v":"Fahrer 1"},"Rechenformular"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P5,Mast!A1:B75,2)","v":"Mast 16"}]
[]
["In den oberen grünen Feldern kann ich Daten eingeben, die in dem Rechenformular eingefügt werden. Weiterhin kann ich noch Stall, LKW, Fahrer usw auswählen wenn es mit stehen soll.\nJetzt komme ich an diesem Punkt nicht wirklich weiter. Ich möchte mehrere Rechenformulare untereinander anzeigen lassen, damit ich diese Aufstellung später nach kompletter Eingabe ausdrucken kann.In dem oberen Fenster würde ich gern ein Kombinationsfeld einfügen, wo ich den einzelnen Abschnitt auswählen kann, wo es dann hinkopiert werden soll. Ebenfalls einen Button den man anklickt und die Daten die im Rechenformular stehen kopiert und dem zugeordnetem Abschnitt einfügt. Es sollte dann so aussehen wie unten, nur ohne Farben und Abschnitt.\nIch möchte gern eine Auswahl von 10 Abschnitten haben.\nGeht das auf irgendeine Art und Weise primitiv umzusetzen, oder muss ich da schwer mit VBA arbeiten?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschnitt 1"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschnitt 2"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschnitt 3"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschnitt 4"]

{"sheet":"farm1","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[1,"Farm 1"]
[2,"Farm 2"]
[3,"Farm 3"]
[4,"Farm 4"]
[5,"Farm 5"]
[6,"Farm 6"]
[7,"Farm 7"]
[8,"Farm 8"]
[9,"Farm 9"]
[10,"Farm 10"]
[11,"Farm 11"]
[12,"Farm 12"]
[13,"Farm 13"]
[14,"Farm 14"]
[15,"Farm 15"]

{"sheet":"farbe","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[1,"weiß"]
[2,"rot"]
[3,"blau"]
[4,"gelb"]
[5,"grün"]
[6,"lila"]
[7,"rosa"]
[8,"orange"]
[9,"grau"]

{"sheet":"Halle","index":3,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[1,"H 1"]
[2,"H 2"]
[3,"H 3"]
[4,"H 4"]
[5,"H 5"]
[6,"H 6"]
[7,"H 7"]
[8,"H 8"]
[9,"H 9"]
[10,"H 10"]
[11,"H 11"]
[12,"H 12"]
[13,"H 13"]
[14,"H 14"]
[15,"H 15"]
[16,"H 16"]
[17,"H 17"]
[18,"H 18"]
[19,"H 19"]
[20,"H 20"]
[21,"H 21"]
[22,"H 22"]
[23,"H 23"]
[24,"H 24"]
[25,"H 25"]
[26,"H 26"]
[27,"H 27"]
[28,"H 28"]
[29,"H 29"]
[30,"H 30"]

{"sheet":"Fahrer","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[1]
[2,"Fahrer 1"]
[3,"Fahrer 2"]
[4,"Fahrer 3"]
[5,"Fahrer 4"]
[6,"Fahrer 5"]
[7,"Fahrer 6"]
[8,"Fahrer 7"]
[9,"Fahrer 8"]
[10,"Fahrer 9"]
[11,"Fahrer 10"]
[12,"Fahrer 11"]
[13,"Fahrer 12"]
[14,"Fahrer 13"]

{"sheet":"LKW","index":5,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[1]
[2,"LKW 1"]
[3,"LKW 2"]
[4,"LKW 3"]
[5,"LKW 4"]
[6,"LKW 5"]
[7,"LKW 6"]
[8,"LKW 7"]
[9,"LKW 8"]
[10,"LKW 9"]
[11,"LKW 10"]
[12,"LKW 11"]
[13,"LKW 12"]
[14,"LKW 13"]
[15,"LKW 14"]
[16,"LKW 15"]

{"sheet":"Mast","index":6,"n_rows":75,"n_cols":2,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[1]
[2,"Mast 1"]
[3,"Mast 2"]
[4,"Mast 3"]
[5,"Mast 4"]
[6,"Mast 5"]
[7,"Mast 6"]
[8,"Mast 7"]
[9,"Mast 8"]
[10,"Mast 9"]
[11,"Mast 10"]
[12,"Mast 11"]
[13,"Mast 12"]
[14,"Mast 13"]
[15,"Mast 14"]
[16,"Mast 15"]
[17,"Mast 16"]
[18,"Mast 17"]
[19,"Mast 18"]
[20,"Mast 19"]
[21,"Mast 20"]
[22,"Mast 21"]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]

{"sheet":"Impf","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[1]
[2,"H120"]
[3,"Primer ½"]
[4,"Primer 1/1"]
[5,"QX ½"]
[6,"QX 1/1"]
[7,"ohne"]
[8]
[9]
[10]
[11]