{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dateneingabe","Ergebnisse","data","res","data2"],"not_rendered":{"charts":0,"images":4,"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":"Dateneingabe","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,27,7]]}
[]
[]
[]
[]
[]
[null,"Anzahl produktiver Sauen",null,150,null,"im Betrieb"]
[]
[null,"Beleggruppengröße",null,20]
[]
[null,"Anzahl Würfe",null,2.2999999999999998,null,"je Sau und Jahr"]
[]
[null,"Anzahl lebend geborener Ferkel",null,13.5,null,"je Sau und Wurf"]
[]
[null,"Wochenrhythmus"]
[]
[null,"Bundesland des Betriebes"]
[]
[null,"Lohnansatz für den Landwirt",null,20,null,"in EUR je Stunde"]
[]
[null,"Ferkelpreis",null,65,null,"in EUR je Ferkel"]
[]
[]
[null,"Hinweis:"]
[null,"In den Ergebnissen werden die kalkulatorischen Mehrkosten je männliches Ferkel, Sau und für den Betrieb angegeben. Die Variationsrechnungen mit der Durchführung der Narkose durch den Landwirt dienen als Orientierung und basieren nicht auf einer Rechtsgrundlage. Das Gleiche gilt für die Lokalanästhesie mit Procain, die momentan für deutsche Ferkelerzeuger nicht zugelassen ist."]

{"sheet":"Ergebnisse","index":1,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[10,4,11,4],[10,6,11,6],[10,8,11,8],[22,4,23,4],[22,6,23,6],[22,8,23,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Mehrkosten der alternativen Verfahren",null,null,null,"EUR                                    je Ferkel (m)",null,"EUR je Sau",null,"EUR pro Jahr"]
[null,"durchgeführt vom Veterinär"]
[]
[null,"Injektionsnarkose",null,null,6.9808000000000003,null,108.3772,null,16256.582399999999]
[]
[null,"Isofluran mit 4 Ferkelschalen",null,null,3.625,null,56.277799999999999,null,8441.6689999999999]
[]
[null,"Isofluran mit 3 Ferkelschalen",null,null,3.5249999999999999,null,54.725200000000001,null,8208.7826000000005]
[]
[null,"Lokalanästhesie",null,null,1.9297,null,29.9588,null,4493.8243000000002]
[]
[]
["Mehrkosten der alternativen Verfahren",null,null,null,"EUR                                    je Ferkel (m)",null,"EUR je Sau",null,"EUR pro Jahr"]
[null,"in Variationsrechnungen"]
[]
[null,"Injektionsnarkose mit Nachkontrolle "]
[null,"durch den Landwirt",null,null,3.6476999999999999,null,56.6312,null,8494.6851999999999]
[]
[null,"Isofluran mit 4 Ferkelschalen"]
[null,"angewendet durch den Landwirt",null,null,1.4431,null,22.403400000000001,null,3360.5174000000002]
[]
[null,"Isofluran mit 3 Ferkelschalen"]
[null,"angewendet durch den Landwirt",null,null,1.8270999999999999,null,28.3657,null,4254.8535000000002]
[]
[null,"Lokalanästhesie"]
[null,"angewendet durch den Landwirt",null,null,0.73280000000000001,null,11.3764,null,1706.4579000000001]
[]
["Zusätzliche Arbeitszeit für den Landwirt",null,null,null,"min je Wurf",null,"h pro Jahr"]
[null,"Injektionsnarkose",null,null,9.3085822034399985,null,53.524347669779992]
[null,null,"NK durch den Landwirt",null,17.194534854744422,null,98.868575414780423]
[]
[null,"Isofluran mit 4 Ferkelschalen",null,null,8.2224134165316549,null,47.27887714505701]
[null,null,"angewendet durch den Landwirt",null,17.667059295187656,null,101.58559094732901]
[]
[null,"Isofluran mit 3 Ferkelschalen",null,null,10.577230313841024,null,60.819074304585889]
[null,null,"angewendet durch den Landwirt",null,17.22132353026927,null,99.022610299048296]
[]
[null,"Lokalanästhesie",null,null,7.2235360840384164,null,41.535332483220898]
[null,null,"angewendet durch den Landwirt",null,10.972071812269578,null,63.089412920550068]

{"sheet":"data","index":2,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[null,null,"Klein","Klein","Mittel","Mittel","Mittel","Groß",null,null,"Eingabe"]
["Index",null,1,2,3,4,5,6,null,"Index",{"$f":"IF(K4<=C4,1,IF(K4<=D4,2,IF(K4<=E4,3,IF(K4<=F4,4,IF(AND(K3>=G3,K3<=H3),5,6)))))","v":3}]
["Anzahl Sauen",null,190,280,490,648,651,1050,null,null,{"$f":"Dateneingabe!$D$6","v":150}]
["Beleggruppengröße",null,10,18,22,33,33,70,null,null,{"$f":"Dateneingabe!$D$8","v":20}]
["Anzahl lebend geborener Ferkel",null,null,null,null,null,null,null,null,null,{"$f":"Dateneingabe!$D$12","v":13.5}]
["Anzahl Würfe",null,null,null,null,null,null,null,null,null,{"$f":"Dateneingabe!$D$10","v":2.2999999999999998}]
["Wochenrhythmus",null,1,1,1,1,1,1,null,null,{"$f":"IF(data2!G19=0,1,IF(data2!G19>4,4,data2!G19))","v":1}]
["Lohnansatz",null,null,null,null,null,null,null,null,null,{"$f":"Dateneingabe!$D$18","v":20}]
["Ferkelpreis",null,null,null,null,null,null,null,null,null,{"$f":"Dateneingabe!$D$20","v":65}]
[]
["Max Anzahl Kastrationen am Tag"]
["Injektionsnarkose TA","No.",60.583644189383065,87.76406226687223,119.12290992191964,111.00884493375629,123.78058392986409,170.0105207785376,1,{"$f":"INDEX($C$12:$H$19,I12,$K$2)","v":119.12290992191964},{"$f":"(($K$3*$K$6)/(52/$K$7))*(($K$5/2))","v":44.783653846153847}]
["Injektionsnarkose TA","No.",692.24262295081974,814.33871712044299,402.26006430868159,342.87976945244947,370.56681916686733,489.86737400530501,2,{"$f":"INDEX($C$12:$H$19,I13,$K$2)","v":402.26006430868159},{"$f":"(($K$3*$K$6)/(52/$K$7))*(($K$5/2))","v":44.783653846153847}]
["IsofluranA TA","No.",534.56657914478569,455.07074089577253,300.17006846247455,531.91886824612232,815.12093463845918,631.95101212995837,3,300.17006846247455,44.783653846153847]
["IsofluranA LW","No.",0,0,0,0,0,0,4,0,44.783653846153847]
["IsofluranB TA","No.",376.41368735372481,304.93205140978404,426.69479606188463,438.69172168613511,479.6212804328224,566.04999664901811,5,426.69479606188463,44.783653846153847]
["IsofluranB LW","No.",0,0,0,0,0,0,6,0,44.783653846153847]
["Lokalanästhesie TA","No.",713.62307692307695,769.89545454545453,756.29531250000002,1004.7115384615386,1273.3363636363636,918.89209138840067,7,756.29531250000002,44.783653846153847]
["Lokalanästhesie LW","No.",0,0,0,0,0,0,8,0,44.783653846153847]
[]
["Kosten Behandlung",null,null,null,null,null,null,null,null,null,null,"Zubehör"]
["Injektionsnarkose TA","EUR",11.40218221603342,8.0610522182025903,5.9628186393790452,6.6456126346705089,5.6015096392118329,4.1750810363872652,{"$f":"IF(K12<J12,1,IF(K12<J12*2,2,IF(K12<J12*3,3,4)))","v":1},{"$f":"INDEX($C$22:$H$29,I12,$K$2)","v":5.9628186393790452},{"$f":"(($K$31*3.2)*I22)/(K12/I22)+J22+L22","v":6.5512796634809281},{"$f":"20.5/($K$3*$K$6*$K$5*0.5)","v":8.8030059044551801E-3}]
["Injektionsnarkose TA","EUR",1.9134215237716328,1.6563492479055602,2.240314409260602,2.8077679275920988,2.2119566672124877,1.7554903931124111,{"$f":"IF(K13<J13,1,IF(K13<J13*2,2,IF(K13<J13*3,3,4)))","v":1},{"$f":"INDEX($C$22:$H$29,I13,$K$2)","v":2.240314409260602},{"$f":"(($K$31*3.2)*I23)/(K13/I23)+J23+L23","v":2.8287754333624848},{"$f":"20.5/($K$3*$K$6*$K$5*0.5)","v":8.8030059044551801E-3}]
["IsofluranA TA","EUR",1.376011065535077,1.7895306999583456,2.3969772980702588,1.3552021624143213,0.9455362181332142,1.202193386785267,1,2.3969772980702588,{"$f":"(($K$31*3.2)*I24)/(K14/I24)+J24+L24","v":3.0203211884065975},4.3685872138910807E-2]
["IsofluranA LW","EUR",0.19748621086142473,0.40513055425815758,0.29816710281336967,0.17081101254352013,0.17264476948034432,0.20528067059763494,4,0.29816710281336967,{"$f":"+J25+L25","v":0.34185297495228045},4.3685872138910807E-2]
["IsofluranB TA","EUR",2.0722818470984277,2.659105747686723,1.9652754253955476,1.8326781460633088,1.6947242762717356,1.4808757692878485,1,1.9652754253955476,{"$f":"(($K$31*3.2)*I26)/(K16/I26)+J26+L26","v":2.7749334435929756},0.23]
["IsofluranB LW","EUR",0.39859138055602972,0.5930717014546586,0.48881026618927115,0.3965899573494639,0.38118789725312308,0.3678998771766181,4,0.48881026618927115,{"$f":"+J27+L27","v":0.71881026618927113},0.23]
["Lokalanästhesie TA","EUR",1.0138687894564753,1.1413876051648095,1.0234830274632305,0.80618263795578504,0.74998291246332094,0.73463979018057957,1,1.0234830274632305,{"$f":"(($K$31*3.2)*I28)/(K18/I28)+J28","v":1.6031410456606583}]
["Lokalanästhesie LW","EUR",0.12949040971855433,0.32468132272976818,0.19094777647620267,0.17482243123743876,0.25345749962517922,4.6764653621232534E-2,4,0.19094777647620267,{"$f":"+J29","v":0.19094777647620267}]
[]
["Anfahrt","km",null,null,null,null,null,null,null,null,{"$f":"INDEX(data2!A1:E16,data2!G1,5)","v":8.112251261281612}]
[]
["Abschreibungen"]
["IsofluranA TA","EUR",0.14502562209256831,0.41799966166375224,0.2287559828518555,0.17880222782303956,0.17371391967553862,0.11458954388557974,1,{"$f":"INDEX($C$34:$H$37,I34,$K$2)","v":0.2287559828518555},{"$f":"J34","v":0.2287559828518555}]
["IsofluranA LW","EUR",0.14502553197385692,0.41799958502882051,0.2287559828518555,0.17880217566736201,0.17371391967553862,0.11458954388557974,2,{"$f":"INDEX($C$34:$H$37,I35,$K$2)","v":0.2287559828518555},{"$f":"J35","v":0.2287559828518555}]
["IsofluranB TA","EUR",0.1634715585651727,0.47116534226419615,0.25785160844494603,0.2015442273112843,0.19580870864751088,0.12916426418016247,3,0.25785160844494603,0.25785160844494603]
["IsofluranB LW","EUR",0.16347144387947554,0.47116523534347499,0.25785160844494603,0.20154416585543988,0.19580870864751088,0.12916426418016247,4,0.25785160844494603,0.25785160844494603]
[]
["Arbeitszeit Landwirt"]
["Injektionsnarkose TA","min/T(m)",0.64848510851857522,0.81739779956413194,1.3790492153244442,1.1257412695242881,0.49025237841920616,0.57605577621908699,1,{"$f":"INDEX($C$40:$H$47,I40,$K$2)","v":1.3790492153244442},{"$f":"($K$8/60)*J40","v":0.45968307177481471}]
["Injektionsnarkose TA","min/T(m)",6.4142702490331169,4.3464330239071574,2.5473384969991737,2.6139274627829758,2.2834238706112453,1.6322622880572057,2,{"$f":"INDEX($C$40:$H$47,I41,$K$2)","v":2.5473384969991737},{"$f":"($K$8/60)*J41","v":0.8491128323330579}]
["IsofluranA TA","min/T(m)",0.92390604800573051,1.2392244187197881,1.2181353209676526,0.87378857658481168,0.65842731718365921,0.76847119571770939,3,1.2181353209676526,0.40604510698921753]
["IsofluranA LW","min/T(m)",1.7095892844548319,2.1621578491865803,2.6173421178055785,1.6633826764986792,1.1736882829522393,1.4330796731761308,4,2.6173421178055785,0.87244737260185945]
["IsofluranB TA","min/T(m)",1.0864615992546074,1.4029091863649508,1.5669970835320037,1.3283177181294579,1.0593476049059805,1.0036404925741271,5,1.5669970835320037,0.5223323611773345]
["IsofluranB LW","min/T(m)",2.2022552436162059,2.7802652171863271,2.5513071896695214,2.285709843938688,1.9350385242517221,1.7456244206482809,6,2.5513071896695214,0.8504357298898404]
["Lokalanästhesie TA","min/T(m)",0.48660828550842206,0.71249866922176075,1.0701534939316173,0.81837418286292507,0.1877761105175467,0.48633872340116208,7,1.0701534939316173,0.35671783131053908]
["Lokalanästhesie LW","min/T(m)",1.0751542750956853,1.2580272829060273,1.6254921203362336,1.2364046163972344,0.51761825749006707,0.94341089099964548,8,1.6254921203362336,0.54183070677874445]

{"sheet":"res","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Mehrkosten",null,null,"je männliches Ferkel","je Sau und Jahr","pro Jahr"]
["Injektionsnarkose TA","EUR",null,{"$f":"data!K22+data!K40","v":7.0109627352557427},{"$f":"D2*data!$K$6*data!$K$5*0.5","v":108.84519646484539},{"$f":"E2*data!$K$3","v":16326.779469726807}]
["Injektionsnarkose TA","EUR",null,{"$f":"data!K23+data!K41","v":3.6778882656955427},{"$f":"D3*data!$K$6*data!$K$5*0.5","v":57.0992153249233},{"$f":"E3*data!$K$3","v":8564.8822987384956}]
["IsofluranA TA","EUR",null,{"$f":"data!K24+data!K42+data!K34","v":3.6551222782476707},{"$f":"D4*data!$K$6*data!$K$5*0.5","v":56.745773369795074},{"$f":"E4*data!$K$3","v":8511.8660054692609}]
["IsofluranA LW","EUR",null,{"$f":"data!K25+data!K43+data!K35","v":1.4430563304059953},{"$f":"D5*data!$K$6*data!$K$5*0.5","v":22.403449529553075},{"$f":"E5*data!$K$3","v":3360.5174294329613}]
["IsofluranB TA","EUR",null,{"$f":"data!K26+data!K44+data!K36","v":3.5551174132152563},{"$f":"D6*data!$K$6*data!$K$5*0.5","v":55.193197840166846},{"$f":"E6*data!$K$3","v":8278.9796760250265}]
["IsofluranB LW","EUR",null,{"$f":"data!K27+data!K45+data!K37","v":1.8270976045240577},{"$f":"D7*data!$K$6*data!$K$5*0.5","v":28.365690310235994},{"$f":"E7*data!$K$3","v":4254.8535465353989}]
["Lokalanästhesie TA","EUR",null,{"$f":"data!K28+data!K46","v":1.9598588769711973},{"$f":"D8*data!$K$6*data!$K$5*0.5","v":30.426809064977835},{"$f":"E8*data!$K$3","v":4564.0213597466754}]
["Lokalanästhesie LW","EUR",null,{"$f":"data!K29+data!K47","v":0.7327784832549471},{"$f":"D9*data!$K$6*data!$K$5*0.5","v":11.376385952533054},{"$f":"E9*data!$K$3","v":1706.4578928799581}]
[]
["Zusätzliche Arbeitszeit Landwirt",null,null,"min / Wurf","h / Jahr"]
["Injektionsnarkose TA",null,null,{"$f":"data!J40*data!$K$5*0.5","v":9.3085822034399985},{"$f":"(D12*data!$K$6*data!$K$3)/60","v":53.524347669779992}]
["Injektionsnarkose TA",null,null,{"$f":"data!J41*data!$K$5*0.5","v":17.194534854744422},{"$f":"(D13*data!$K$6*data!$K$3)/60","v":98.868575414780423}]
["IsofluranA TA",null,null,{"$f":"data!J42*data!$K$5*0.5","v":8.2224134165316549},{"$f":"(D14*data!$K$6*data!$K$3)/60","v":47.27887714505701}]
["IsofluranA LW",null,null,{"$f":"data!J43*data!$K$5*0.5","v":17.667059295187656},{"$f":"(D15*data!$K$6*data!$K$3)/60","v":101.58559094732901}]
["IsofluranB TA",null,null,{"$f":"data!J44*data!$K$5*0.5","v":10.577230313841024},{"$f":"(D16*data!$K$6*data!$K$3)/60","v":60.819074304585889}]
["IsofluranB LW",null,null,{"$f":"data!J45*data!$K$5*0.5","v":17.22132353026927},{"$f":"(D17*data!$K$6*data!$K$3)/60","v":99.022610299048296}]
["Lokalanästhesie TA",null,null,{"$f":"data!J46*data!$K$5*0.5","v":7.2235360840384164},{"$f":"(D18*data!$K$6*data!$K$3)/60","v":41.535332483220898}]
["Lokalanästhesie LW",null,null,{"$f":"data!J47*data!$K$5*0.5","v":10.972071812269578},{"$f":"(D19*data!$K$6*data!$K$3)/60","v":63.089412920550068}]

{"sheet":"data2","index":4,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Bayern",287,70542.03,{"$f":"C1/B1","v":245.79104529616725},{"$f":"SQRT(D1/PI())","v":8.8452088530016031},null,4]
["Niedersachsen",206,47709.83,{"$f":"C2/B2","v":231.60111650485439},{"$f":"SQRT(D2/PI())","v":8.586089041857127}]
["Baden-Württemberg",192,35673.71,185.80057291666665,7.690393957268201]
["Nordrhein-Westfalen",{"$f":"67+98","v":165},34112.74,206.74387878787877,8.112251261281612]
["Brandenburg",58,29654.38,511.28241379310344,12.757203727394829]
["Mecklenburg-Vorpommern",42,23292.73,554.58880952380946,13.286500699519335]
["Hessen",27,21115.67,782.06185185185177,15.777769774326392]
["Sachsen-Anhalt",30,20452.14,681.73799999999994,14.731053770425422]
["Rheinland-Pfalz",12,19858,1654.8333333333333,22.951030695515097]
["Sachsen",33,18449.990000000002,559.09060606060609,13.340317356853925]
["Thüringen",24,16202.37,675.09875,14.659147528943127]
["Schleswig-Holstein",44,15802.27,359.14249999999998,10.691988042397075]
["Saarland",1,2571.1,2571.1,28.607805724437242]
["Berlin",1,891.12,891.12,16.841980458844489]
["Hamburg",3,755.09,251.69666666666669,8.9508400342932148]
["Bremen",2,419.84,209.92,8.174326351920465]
["Quelle:","Deutsches Tierärzteblatt","Destatis"]
[]
["1-Wochenrhythmus",1,null,null,null,null,1]
["2-Wochenrhythmus",2]
["3-Wochenrhythmus",3]
["4-Wochenrhythmus",4]
["anderer Rhythmus",5]