{"text_format":"1","workbook":"xlsx","n_sheets":37,"sheets":["Contents","Field information template","Farm templates (b)","Livestock manure farm limit","poultry manure production","Storage","Volume, rainfall and washwater","Table 4","Table 5","Tables 6 & 7","Table 8","Table 9","Table 10","Table 11","Table 12","Table 13","Table 14","Table 15","Tables 16, 17 & 18","Table 19","Table 20","Table 21","Table 23","Table 24","Sheet7","Table 25","Table 26","Table 27","Table 28","Table 29","Table 30","Table 31","Table 32","Table 33","Table 34","Table 35","Table 36"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":29,"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":"Contents","index":0,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,"NVZ Guidance - Blank 'farmer completion' and 'standard values' tables"]
[null,null,"The tables in this file relate to the November 2013 NVZ guidance update - PB 14050"]
[null,null,"Table of contents"]
[null,null,"■ Click on a Table of content entry below to display the required table for printing.  ■ To return to this Table of Contents click the title of the table displayed."]
[]
[null,null,"General farm information"]
[null,null,"Field information template "]
[null,null,"Livestock manure farm limit"]
[null,null,"poultry manure production"]
[null,null,"Storage"]
[null,null,"Volume, rainfall and washwater"]
[]
[null,null,"Numbered completion tables"]
[null,null,"Table 5: Manure N produced by livestock on the farm"]
[null,null,"Table 6: Manure N content of IMPORTED livestock manure"]
[null,null,"Table 7: Manure N content of EXPORTED livestock manure"]
[null,null,"Table 8: The total agricultural area of the farm on 1 January"]
[null,null,"Table 9: Manure nitrogen (N) and phosphate (P2O5) produced by grazing livestock on the farm"]
[null,null,"Table 10: Manure N in imported and exported manure from grazing livestock"]
[null,null,"Table 11: Total loading of manure N from non-grazing livestock "]
[null,null,"Table 12: Manure nitrogen (N) and phosphate (P2O5) produced by non-grazing livestock on the farm"]
[null,null,"Table 13: Manure N in imported and exported manure from non-grazing livestock"]
[null,null,"Table 14: Total loading of manure N from non-grazing livestock"]
[null,null,"Table 15: Area required to comply with the livestock manure N limits and associated comparison table"]
[null,null,"Table 16: Manufactured nitrogen fertiliser stocks on farm on 1 January"]
[null,null,"Table 17: Manufactured nitrogen fertilisers (purchased/imported and sold/exported)"]
[null,null,"Table 18: Manufactured nitrogen fertiliser stocks on farm on 31 December"]
[null,null,"Table 19: Calculation of N max for a crop"]
[null,null,"Table 20: The crop available nitrogen from organic manure applications"]
[null,null,"Table 21: Nitrogen from applications of manufactured fertilizer"]
[null,null,"Table 23: Calculating the field area for spreading (in those fields where there are red or white areas marked)"]
[null,null,"Table 24: Slurry production per month (based on undiluted slurry)"]
[null,null,"Table 25: Wash water use for pig units"]
[null,null,"Table 26: Capacity of existing slurry storage facilities"]
[null,null,"Table 27: Poultry manure production per month"]
[null,null,"Table 28: Capacity of existing poultry stores"]
[null,null,"Table 29: Cattle, sheep or pig solid manure production per month"]
[]
[null,null,"Standard values tables"]
[null,null,"Table 4: The N max limits"]
[null,null,"Table 30: Nitrogen and excreta production from cattle"]
[null,null,"Table 31: Nitrogen and excreta production by pigs places"]
[null,null,"Table 32  Nitrogen and excreta production by poultry places"]
[null,null,"Table 33: Nitrogen and excreta production by sheep, goats, deer and horses"]
[null,null,"Table 34: Crops to which manufactured nitrogen fertiliser may be applied during the closed spreading period"]
[null,null,"Table 35: The total N content of organic manures and maximum application rates to supply 250 kg N/ha of total nitrogen"]
[null,null,"Table 36: The % of the total nitrogen content of livestock manure available for crop uptake in the growing season in which it is spread (Only for use in N max calculation)"]

{"sheet":"Field information template","index":1,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,0,24,7],[25,0,25,1],[25,2,25,7],[0,0,0,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[10,8,10,9],[5,0,5,4],[5,5,5,6],[2,0,2,2],[1,0,1,1],[20,8,20,9],[21,8,21,9],[22,8,22,9],[5,7,5,9],[4,0,4,9],[14,8,14,9],[13,8,13,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[11,8,11,9],[12,8,12,9]]}
["Part B Template for keeping field records"]
["Field name / reference "]
[null,null,null,"Field area (ha):",null,"Harvest year:",null,"Soil type:"]
[]
["Cropping, soil nitrogen supply and the crop N requirement"]
["Cropping",null,null,null,null,"Soil N Supply",null,"Crop N requirement"]
["Crop","Crop area\n(ha)","Date sown\n(month/year)","Market (tillage crops) or\ncut/grazed (grass)","Yield\n(arable crops only)","kg N/ha\nor \nSNS Index","Method of assessment","Nitrogen application rate\n(kg N/ha)","Source of information"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Planned and/or actual applications of manufactured nitrogen fertilizers and organic manures"]
["Manufactured nitrogen fertilisers",null,"Organic manures"]
["Date applied","Nitrogen rate\nkg N/ha","Date applied","Manure type","Application rate\nt/ha or m3/ha","Method of application","Total N content \nkg/t or kg/m3","Crop available N rate\nkg N/ha"]

{"sheet":"Farm templates (b)","index":2,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[[1,0,1,1],[3,0,3,7],[4,0,4,1],[4,2,4,7]]}
["Field name/Ref",null,null,"Field area (ha)","Harvest year","Soil type"]
[]
[]
["Planned and/or actual applications of manufactured nitrogen fertilizers and organic manures"]
["Manufactured nitrogen fertilisers",null,"Organic manures"]
["Date","Nitrogen rate\nkg N/ha","Date","Manure type","Application rate\nt/ha or m3/ha","Method of application","Total N content \nkg/t or kg/m3","Crop available N rate\nkg N/ha"]

{"sheet":"Livestock manure farm limit","index":3,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Livestock Manure N farm limit kg N"]
["Area of the farm in an NVZ (ha)\n(A)",null,"Livestock manure N farm limit (kg N/ha)",null,"Livestock manure N capacity kg N \n(B)"]
[null,"x",170,"="]

{"sheet":"poultry manure production","index":4,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,0,2,1],[5,0,5,5],[0,0,0,7]]}
["Monthly poultry manure production"]
[]
["Monthly production from A (laying hens) or B (poultry litter) (tonnes)",null,null,"Months (6)",null,"Density",null,"Store volume (m3)"]
["A ",null,"x",6,"¸",0.9,"="]
["B",null,"x",6,"¸",0.5,"="]
[null,null,null,null,null,null,"C"]

{"sheet":"Storage","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,1],[0,0,0,1]]}
["Storage "]
[]
["1. Exported poultry manure "]
[]
["2. Storage on field sites  "]
[]
["3. poultry manure spread on low run-off risk land "]
[]
["Insert your revised minimum volume to be stored (m3):",null," (C Rev)"]
[]
["If (C Rev) is greater than (D from Table 28) you will need to consider providing extra storage capacity to make up the difference."]

{"sheet":"Volume, rainfall and washwater","index":6,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,12],[18,0,18,8],[1,0,1,12],[9,0,9,9],[12,0,12,9],[15,0,15,9],[8,0,8,13],[10,0,10,9],[13,0,13,9],[16,0,16,9],[6,4,6,5],[5,4,5,5]]}
["Volume, rainfall and washwater "]
["Monthly rainfall and total (mm)"]
["Oct",null,"Nov",null,"Dec",null,"Jan",null,"Feb",null,"March\npig farms only",null,"Total"]
[null,"+",null,"+",null,"+",null,"+",null,"+",null,"="]
[]
["Number of dairy cows",null,"Wash water used per cow per month (m3)",null,"Monthly wash water production (m3) (D)"]
[null,"x",null,"=",null,null,"see page 106 of guidance"]
[]
["Record of calculation and justification for reducing volume of slurry (plus dilution) to be stored"]
["(i)            Exported slurry  (Retain a copy of any agreements with your records)"]
[]
[]
["(ii)          Mechanically separated slurry"]
[]
[]
["(iii)         Slurry spread on low run-off risk land "]
[]
[]
["(iv)            Diverted rainfall "]
["Total rainfall collection area that could be excluded\nm2",null,"Monthly rainfall\n(insert B)\nmm",null,"operand",null,"Storage period (months)\n(Enter 6 for pigs, 5 for other livestock)",null,"Potential volume excluded from slurry store\nm3"]
[null,"x",null,"¸ ",1000,"x",null,"="]

{"sheet":"Table 4","index":7,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,2],[0,0,0,2],[2,0,3,0],[2,2,3,2],[6,0,7,0],[6,2,7,2],[8,0,9,0],[8,2,9,2],[10,0,11,0],[10,2,11,2],[26,0,26,2],[17,0,18,0],[17,2,18,2],[19,0,19,2],[21,0,21,2],[23,0,23,2]]}
["Table 4: The N max limits"]
["Crop","N max limit\n(kg N/ha)","Standard crop yield (t/ha)"]
["Wheat, autumn or early winter sown",220,8]
[null,"(notes b, c, d)"]
["Wheat, spring sown",180,7]
[null,"(notes c, d)"]
["Barley, winter",180,6.5]
[null,"(notes b, c)"]
["Barley, spring",150,5.5]
[null,"(note c)"]
["Oilseed rape, winter",250,3.5]
[null,"(note e)"]
["Sugar beet",120,"n/a"]
["Potatoes",270,"n/a"]
["Forage maize",150,"n/a"]
["Field beans",0,"n/a"]
["Peas",0,"n/a"]
["Grass",300,"n/a"]
[null,"(note f)"]
["Group 1"]
["Asparagus, carrots, radishes, swedes",180,"n/a"]
["Group 2"]
["Celery, courgettes, dwarf beans, lettuce, onions, parsnips, runner beans, sweetcorn, turnips",280,"n/a"]
["Group 3"]
["Beetroot, brussels sprouts, cabbage, calabrese, cauliflower, leeks",370,"n/a"]
[]
["Notes\na) An additional 80 kg N/ha is permitted to all crops grown in fields where the previous or current crop received an application of straw for mulching or paper sludge.\n\nb) An additional 20 kg N/ha is permitted on fields with a shallow soil type (not shallow soils over sandstone).\n\nc) An additional 20 kg N/ha is permitted for every tonne that the expected yield exceeds the standard yield.\n\nd) An additional 40 kg N/ha is permitted to milling wheat varieties.\n\ne) This consists of a maximum autumn application of 30 kg N/ha (allowed as an exemption to the closed period for manufactured nitrogen fertiliser) and a maximum spring application of 220 kg N/ha.  The spring application can be increased to 30 kg N/ha for every half tonne that the expected yield exceeds the standard yield.\n\nf) Where grass is grown to achieve a protein content of at least 16% of the dried product, nitrogen may be applied up to the level recommended by a FACTS advisor.   A FACTS advisor may recommend no more than 700 kg N/ha per year if the grass is irrigated, and 500 kg N/ha per year if the grass is not irrigated.  In addition, for the second and subsequent years, the FACTS advisor must be supplied with soil analyses from representative autumn soil samples (taken between 1 Sept and 31 Oct) to be incorporated into the calculation of N demand.\n\ng) An additional 40 kg N/ha is permitted to grass cut at least 3 times in a year."]

{"sheet":"Table 5","index":8,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[24,0,24,2]]}
["Table 5: Manure N produced by livestock on the farm"]
["Livestock type","Number of livestock units","Total N produced by 1 livestock unit \nkg N/year","Total N produced by all these livestock\nkg N/year"]
["Column 1",2,3,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total N produced by all livestock on the farm (kg N/year)"]

{"sheet":"Tables 6 & 7","index":9,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[21,0,21,2],[0,0,0,3],[23,0,23,3],[44,0,44,2]]}
["Table 6: Manure N content of IMPORTED livestock manure"]
["Manure type","Quantity\nt or m3","Total N content\nkg/m3 or kg/t","Total N\nkg N"]
["Column 1",2,3,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total N of all imported livestock manure (kg N/year)"]
[]
["Table 7: Manure N content of EXPORTED livestock manure"]
["Manure type","Quantity\nt or m3","Total N content\nkg/m3 or kg/t","Total N\nkg N"]
["Column 1",2,3,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total N of all exported livestock manure (kg N/year)"]

{"sheet":"Table 8","index":10,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,4],[6,1,6,2],[6,3,6,4],[25,1,25,2],[25,3,25,4],[27,1,27,2],[27,3,27,4],[0,0,0,4],[1,1,1,2],[1,3,1,4],[4,1,4,2],[4,3,4,4],[21,3,21,4],[21,1,21,2],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4],[5,1,5,2],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4],[24,1,24,2],[24,3,24,4],[29,1,29,2],[29,3,29,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[26,1,26,2],[26,3,26,4],[28,1,28,2],[28,3,28,4],[12,1,12,2],[12,3,12,4],[13,1,13,2],[13,3,13,4],[14,1,14,2],[14,3,14,4],[15,1,15,2],[15,3,15,4],[16,1,16,2],[16,3,16,4],[20,1,20,2],[20,3,20,4],[17,1,17,2],[17,3,17,4],[18,1,18,2],[18,3,18,4],[19,1,19,2],[19,3,19,4]]}
["Table 8: The total agricultural area of the farm on 1 January (for derogation)"]
["Field name or number","Area\n(ha)",null,"Grass\n(tick)"]
["Column 1",2,null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals","A",{"$f":"SUM(B4:C30)","v":0},"A1",{"$f":"SUMIFS(B4:C30,D4:E30,\"y\")","v":0}]

{"sheet":"Table 9","index":11,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,0,25,2],[2,2,2,3],[2,5,2,6],[0,0,0,7],[1,2,1,3],[1,5,1,6]]}
["Table 9: Manure nitrogen (N) and phosphate (P2O5) produced by grazing livestock on the farm"]
["Livestock type and units\n\n\nGreen bracketed letters in columns 3 and 5 refer to indicated notes","Number of livestock units","Total N produced by 1 livestock unit\nkg N/year\n(notes a, b)",null,"Total N produced by all these livestock\nkg N/year","Total P2O5 produced by 1 livestock unit\nkg P2O5/year\n(notes a, b)",null,"Total P2O5 produced by all these livestock\nkg P2O5/year"]
["Column 1",2,3,null,4,5,null,6]
["1 calf (all categories) younger than 2 months",null,1.4,"(c)","=",0.77,"(c)","="]
["1 dairy cow from 2 months and less than 12 months ",null,29,"(d)","=",10.3,"(d)","="]
["1 dairy cow from 12 months up to first calf",null,61,null,"=",25,null,"="]
["1 dairy cow after first calf (over 9,000 litres milk yield)",null,115,null,"=",52,null,"="]
["1 dairy cow after first calf (6,000 to 9,000 litres milk yield)",null,101,null,"=",44,null,"="]
["1 dairy cow after first calf (up to 6,000 litres milk yield)",null,77,null,"=",34,null,"="]
["1 beef cow or steer (castrated male) from 2 months and less than 12 months",null,28,"(c)","=",10,"(d)","="]
["1 beef cow or steer from 12 months and less than 24 months",null,50,null,"=",15.7,null,"="]
["1 beef cow or steer for slaughter 24 months and over",null,50,null,"=",22,null,"="]
["1 beef cow for breeding 24 months and over weighing up to 500 kg",null,61,null,"=",24,null,"="]
["1 beef cow for breeding 24 months and over weighing over 500 kg",null,83,null,"=",31,null,"="]
["1 non-breeding bull 2 months and over",null,54,null,"=",8.8000000000000007,null,"="]
["1 bull for breeding from 2 to 24 months ",null,50,null,"=",15.7,null,"="]
["1 bull for breeding from 24 months",null,48,null,"=",22,null,"="]
["1 lamb, 6 to 9 months ",null,0.5,"(e)","=",7.0000000000000007E-2,"(e)","="]
["1 lamb, 9 months and over, to first lambing, first tupping or slaughter ",null,0.7,"(f)","=",0.38,"(f)","="]
["1 sheep, less than 60 kg, after lambing or tupping. For ewes this includes one or more suckled lambs up to 6 months",null,7.6,null,"=",3.2,null,"="]
["1 sheep, over 60 kg, after lambing or tupping. For ewes this includes one or more suckled lambs up to 6 months",null,11.9,null,"=",3.7,null,"="]
["1 goat ",null,15,null,"=",6.9,null,"="]
["1 deer for breeding",null,15.2,null,"=",6.4,null,"="]
["1 deer, other",null,12,null,"=",4.3,null,"="]
["1 horse",null,21,null,"=",20,null,"="]
["Total N & P2O5 produced by all grazing livestock on the farm",null,null,"B","=",null,"C","="]
[]
["Table 9 Notes"]
["a)  Includes an allowance for N losses from livestock housing and manure storage."]
["b)  Different units are used for cattle less than 12 months and for lambs – see notes c, d, e & f below."]
["c)  Total N produced (kg) during the 2 months that the animal is in this category."]
["d)  Total N produced (kg) during the 10 months that the animal is in this category."]
["e)  Total N produced (kg) during the 3 months that the animal is in this category."]
["f)   Total N produced (kg) assuming the animal is in this category for 6 months."]

{"sheet":"Table 10","index":12,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,2,1,4],[1,5,1,7],[2,2,2,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[14,5,14,6],[1,1,2,1],[1,0,2,0],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[12,2,12,3],[13,2,13,3],[14,2,14,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6]]}
["Table 10: Manure N in imported and exported manure from grazing livestock"]
["Manure type","Total N content\nkg/m3 or kg/t","Imported",null,null,"Exported"]
[null,null,"Quantity\nt or m3",null,"Total N\nkg N","Quantity\nt or m3",null,"Total N\nkg N"]
["Column 1",2,3,null,4,5,null,6]
["Cattle farmyard manure",6,"x",null,"=","x",null,"="]
["Pig farmyard manure",7,"x",null,"=","x",null,"="]
["Sheep farmyard manure",7,"x",null,"=","x",null,"="]
["Horse farmyard manure",7,"x",null,"=","x",null,"="]
["Goat farmyard manure",6,"x",null,"=","x",null,"="]
["Cattle slurry",2.6,"x",null,"=","x",null,"="]
["Separated cattle slurry, liquid fraction, strainer box",1.5,"x",null,"=","x",null,"="]
["Separated cattle slurry, liquid fraction, weeping-wall ",2,"x",null,"=","x",null,"="]
["Separated cattle slurry, liquid fraction, mechanically separated ",3,"x",null,"=","x",null,"="]
["Separated cattle slurry, solid fraction",4,"x",null,"=","x",null,"="]
["Dirty water",0.5,"x",null,"=","x",null,"="]
["Total N: ",null,"Imported","D","=","Exported ","E","="]

{"sheet":"Table 11","index":13,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,9],[4,1,4,9],[0,0,0,9]]}
["Table 11: Total loading of manure N from non-grazing livestock "]
[null,"B Table 9",null," D Table 10",null,"E Table 10",null,null,"Manure N loading"]
[null,null,"+",null,"-",null,"=","F"]
[]
[null,"B, D and E input values and output (F) are kg N/year"]

{"sheet":"Table 12","index":14,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,0,25,3],[27,0,27,8],[2,3,2,4],[2,6,2,7],[0,0,0,8],[1,3,1,4],[1,6,1,7]]}
["Table 12: Manure nitrogen (N) and phosphate (P2O5) produced by non-grazing livestock on the farm"]
["Livestock type and units\n\n\nGreen bracketed letters at head of columns 4 and 6 refer to indicated notes","Occupancy %","Number of livestock units","Total N produced by 1 livestock unit \nkg N/year\n(note a)",null,"Total N produced by all these livestock\nkg N/year","Total P2O5 produced by 1 livestock unit\nkg P2O5/year\n(notes a, b)",null,"Total P2O5 produced by all these livestock\nkg P2O5/year"]
["Column 1",2,3,4,null,5,6,null,7]
["1 veal calf","n/a",null,1.4," (c)","=",0.77," (d)","="]
["1,000 replacement layer pullet places, up to 17 weeks",89,null,210,null,"=",150,null,"="]
["1,000 laying hens in cages, 17 weeks and over",97,null,400,null,"=",350,null,"="]
["1,000 laying hen places, free range, 17 weeks and over",97,null,530,null,"=",390,null,"="]
["1,000 broiler places",85,null,330,null,"=",220,null,"="]
["1,000 replacement broiler breeder pullet places, up to 25 weeks",92,null,290,null,"=",260,null,"="]
["1,000 broiler breeder places, 25 weeks and over",95,null,700,null,"=",520,null,"="]
["1,000 turkey places (male)",90,null,1230,null,"=",1020,null,"="]
["1,000 turkey places (female)",88,null,910,null,"=",740,null,"="]
["1,000 duck places",83,null,750,null,"=",730,null,"="]
["1 ostrich place",100,null,1.4,null,"=",6.8,null,"="]
["1 weaner place, 7 to 13 kg",71,null,1,null,"=",0.34,null,"="]
["1 weaner place, 13 to 31 kg",82,null,4.2,null,"=",1.8,null,"="]
["1 grower place, 31 to 66 kg (dry fed)",88,null,7.7,null,"=",3.9,null,"="]
["1 grower place, 31 to 66 kg (liquid fed)",88,null,7.7,null,"=",3.9,null,"="]
["1 finisher place, 66 kg and over (dry fed)",86,null,10.6,null,"=",5.6,null,"="]
["1 finisher place, 66 kg and over (liquid fed)",86,null,10.6,null,"=",5.6,null,"="]
["1 maiden gilt place, 66 kg and over",80,null,11.1,null,"=",5.8,null,"="]
["1 sow place, 66 kg and over, with litter up to 7 kg, fed on a lower protein diet but supplemented with synthetic amino acids",100,null,16,null,"=",13.5,null,"="]
["1 sow place, 66 kg and over, with litter up to 7 kg, fed on a diet without synthetic amino acids",100,null,18,null,"=",13.5,null,"="]
["1 breeding boar, from 66 kg to 150 kg",100,null,12,null,"=",6.5,null,"="]
["1 breeding boar, 150 kg and over",100,null,17.5,null,"=",10.199999999999999,null,"="]
["Total N and P2O5 produced by all non-grazing livestock on the farm",null,null,null,"G","=",null,"H","="]
[]
["Table 12 Notes\na) N produced in excreta is per 1,000 poultry places (except ostriches) or per pig place and includes an allowance for N losses from livestock housing and manure storage.  \nb) Includes an allowance for occupancy. \nc) Total N produced (kg) during the 2 months that the animal is in this category.  \nd) Total P2O5 produced (kg) during the 2 months the animal is in this category."]

{"sheet":"Table 13","index":15,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,5,2,6],[1,3,1,6],[0,0,0,9],[1,7,1,9],[2,3,2,4],[2,7,2,8],[1,0,2,0],[1,1,2,2]]}
["Table 13: Manure N in imported and exported manure from non-grazing livestock"]
["Manure type","Total N content\nkg/m3 or kg/t",null,"Imported",null,null,null,"Exported"]
[null,null,null,"Quantity\nt or m3",null,"Total N\nkg N",null,"Quantity\nt or m3",null,"Total N\nkg N"]
["Column 1",2,"x",3,"=",4,"x",5,"=",6]
["Duck farmyard manure",6.5,"x",null,"=",{"$f":"IF(ISBLANK(D5),\"\",$B5*D5)","v":""},"x",null,"=",{"$f":"IF(ISBLANK(H5),\"\",H5*B5)","v":""}]
["Poultry layer manure",19,"x",null,"=",{"$f":"IF(ISBLANK(D6),\"\",$B6*D6)","v":""},"x",null,"=",{"$f":"IF(ISBLANK(H6),\"\",H6*B6)","v":""}]
["Poultry broiler litter",30,"x",null,"=","","x",null,"=",""]
["Turkey litter",30,"x",null,"=","","x",null,"=",""]
["Pig slurry",3.6,"x",null,"=","","x",null,"=",""]
["Separated pig slurry, liquid fraction",3.6,"x",null,"=","","x",null,"=",""]
["Separated pig slurry, solid fraction",5,"x",null,"=","","x",null,"=",""]
["Dirty water",0.5,"x",null,"=","","x",null,"=",""]
["Total N: ",null,null,"Imported","I",{"$f":"IF(SUM(F5:F12)=0,\"=\",SUM(F5:F12))","v":"="},null,"Exported","J",{"$f":"IF(SUM(J5:J12)=0,\"=\",SUM(J5:J12))","v":"="}]

{"sheet":"Table 14","index":16,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,1,3,9],[4,1,4,9]]}
["Table 14: Total loading of manure N from non-grazing livestock"]
[null,"G Table 12",null," I Table 13",null,"J Table 13",null,null,"Manure N loading"]
[null,null,"+",null,"-",null,"=","K"]
[]
[null,"G, I and J input values and output (K) are kg N/year"]

{"sheet":"Table 15","index":17,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,3,9,4],[8,0,8,6],[0,0,0,6],[1,0,1,2],[1,4,2,4],[2,0,2,2],[5,0,5,4]]}
["Table 15: Area required to comply with the livestock manure N limits"]
["Column  1",null,null,null,"kg N/ha",null,"Column 2 "]
["Manure N loading (kg N)",null,null,null,null,null,"Area required (ha)"]
["from grazing livestock","F",null,"÷  ",250,"="]
["from non-grazing livestock","K",null,"÷ ",170,"="]
["Total",null,null,null,null,"L"]
[]
[]
["Comparison of area required and area of your farm to meet livestock manure farm limit"]
["Area required to comply with the livestock manure N farm limits (ha)","L",null,"Total area of your farm (ha)",null,"A"]

{"sheet":"Tables 16, 17 & 18","index":18,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[41,0,41,1],[42,0,42,1],[43,0,43,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[0,0,0,3],[30,0,30,3],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[2,0,2,1],[13,2,13,3],[15,0,15,3],[1,2,1,3],[14,2,14,3],[1,0,1,1],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[2,2,2,3],[13,0,13,1],[14,0,14,1]]}
["Table 16: Manufactured nitrogen fertiliser stocks on farm on 1 January"]
["Fertiliser type (eg 25:5:5)\nN content (%, liquids % on w/v basis)",null,"Quantity\n(tonnes or m3)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 17: Manufactured nitrogen fertilisers (purchased/imported and sold/exported)"]
["Date","Fertiliser type \n(eg 25:5:5)","Amount purchased or imported onto farm (tonnes)","Amount sold or exported off farm (tonnes)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 18: Manufactured nitrogen fertiliser stocks on farm on 31 December"]
["Fertiliser type (eg 25:5:5)",null,"Quantity (tonnes)"]

{"sheet":"Table 19","index":19,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,8,7,9],[21,0,21,8],[4,4,4,7],[4,3,5,3],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[19,8,19,9],[20,8,20,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[18,8,18,9],[2,0,2,1],[1,0,1,1],[0,0,0,11],[6,10,6,11],[4,10,5,11],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,8,5,9],[6,8,6,9],[21,10,21,11],[2,9,2,10],[1,9,1,10],[18,10,18,11],[19,10,19,11],[20,10,20,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[7,10,7,11],[8,10,8,11],[9,10,9,11],[10,10,10,11]]}
["Table 19: Calculation of N max for a crop"]
["Crop type:",null,null,"Harvest year",null,"N max limit (before adjustments):",null,null,null,"kg N/ha"]
[]
[]
["Field  name / reference","Crop area\nha","Expected yield\nt/ha","Soil type\nkg N/ha","Adjustments",null,null,null,"Adjusted N max limit \nkg N/ha",null,"Maximum limit for N applied\nkg N"]
[null,null,null,null,"Expected yield\nkg N/ha","Milling wheat\nkg N/ha","Paper sludge or straw\nkg N/ha","3 or more cuts of grass\nkg N/ha"]
["Column 1",2,3,4,5,6,7,8,9,null,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Maximum limit for N applied to the crop  (kg N) ",null,null,null,null,null,null,null,null,"A","="]

{"sheet":"Table 20","index":20,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,6,1,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[19,0,19,6],[5,6,5,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[16,6,16,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[17,6,17,7],[18,6,18,7],[15,6,15,7]]}
["Table 20: The crop available nitrogen from organic manure applications"]
["Field name / reference","Crop area\nha","Manure type","Application rate\nt/ha or m3/ha","Quantity applied\nt or m3","Total N content\nkg/t or kg/m3","Manure N availability\n%",null,"Crop available N\nkg N"]
["Column 1",2,3,4,5,6,7,null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total amount of crop available N from all applications of organic manure (kg N)",null,null,null,null,null,null,"B"]

{"sheet":"Table 21","index":21,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,2,1,3],[2,2,2,3],[3,2,3,3],[31,0,31,2],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[15,2,15,3],[4,2,4,3],[25,2,25,3],[29,2,29,3],[30,2,30,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[28,2,28,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[27,2,27,3]]}
["Table 21: Nitrogen from applications of manufactured fertilizer"]
["Field name/reference","Crop area\nha","Total nitrogen rate\nkg N/ha",null,"Total amount of nitrogen applied to the field\nkg N"]
["Column 1",2,3,null,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total amount of N from manufactured fertiliser",null,null,"C"]

{"sheet":"Table 23","index":22,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,2,0],[3,2,3,3],[1,2,1,3],[1,1,2,1],[1,4,2,4],[1,5,2,5],[1,6,2,6]]}
["Table 23: Calculating the field area for spreading (in those fields where there are red or white areas marked)"]
["Field name or number","Whole field area \n(ha)","Ditches and watercourses",null,"Other red areas\n(ha)","White areas\n(ha)","Field spreading area\n(ha)"]
[null,null,"Total length in metres  (m)","m/1,000 = area\n(ha)\n(note a)"]
["Column 1",2,3,null,4,5,6]

{"sheet":"Table 24","index":23,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,4],[16,0,16,3]]}
["Table 24: Slurry production per month (based on undiluted slurry)"]
["Livestock type on slurry or part-slurry based system","Number of livestock units on slurry or part-slurry based system","Proportion of excreta collected as slurry\neg half = 0.5, all = 1","Volume per livestock unit (or place) per month\n(m3)","Volume produced per month\n(m3)"]
["Column 1",2,3,4,5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total volume of slurry produced per month (m³)      (A)"]

{"sheet":"Sheet7","index":24,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,3,1,3],[0,4,1,4],[0,5,1,5],[5,0,6,0],[5,1,6,1],[5,3,6,3],[5,4,6,4]]}
["Area of slurry store(s) plus concrete surface area","x","Average monthly rainfall","¸  ",1000,"=","Average volume of rainfall entering slurry store(s) per month"]
["m2",null,"(B) mm",null,null,null,"m3 (C)"]
[]
[]
[]
["Number of dairy cows","x","Wash water used per cow per month","=","Monthly wash water production (m3) (D)"]
[null,null,"(m3)"]

{"sheet":"Table 25","index":25,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,1,1,2],[8,0,8,5],[1,4,1,6]]}
["Table 25: Wash water use for pig units"]
["Pig type","Wash water (litres per pig place per week)",null,"Number of pig places","Factor to convert into volume per month",null,null,"Monthly wash water production \n(m3)"]
["Sows with litter up to 7 kg",10,"x",null,"x",4.3E-3,null,{"$f":"IF(ISBLANK(D3),\"\",B3*D3*F3)","v":""}]
["Maiden gilts and breeding boars",0.6,"x",null,"x",4.3E-3,null,{"$f":"IF(ISBLANK(D4),\"\",B4*D4*F4)","v":""}]
["Weaners (7 – 12 kg)",2,"x",null,"x",4.3E-3,null,""]
["Weaners (13 – 30 kg)",2.6,"x",null,"x",4.3E-3,null,""]
["Growers (31 – 65 kg)",1.9,"x",null,"x",4.3E-3,null,""]
["Finishers (66 kg and over)",1.6,"x",null,"x",4.3E-3,null,""]
["Total volume (m³) =",null,null,null,null,null,"E",{"$f":"IF(SUM(H3:H8)=0,\"\",SUM(H3:H8))","v":""}]

{"sheet":"Table 26","index":26,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[20,0,20,6],[0,0,0,6],[1,0,2,0],[16,0,16,6],[17,0,17,6],[1,6,2,6],[18,0,18,1],[1,1,1,5],[14,0,14,4],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5]]}
["Table 26: Capacity of existing slurry storage facilities"]
["Store ref","metres",null,null,null,null,"Capacity\n(m3)"]
[null,"Length","Width","Radius \n(cyclindrical stores) (note b)","Working height or depth "]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E4),\"\",IF(NOT(ISBLANK(D4)),3.142*(D4*D4)*E4,B4*C4*E4))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E5),\"\",IF(NOT(ISBLANK(D5)),3.142*(D5*D5)*E5,B5*C5*E5))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
["Total existing capacity (m³) =",null,null,null,null,"H"]
["Table 26 Notes"]
["(a) When calculating the capacity of slurry lagoons, you will need to take into account the internal sloping (\"wet slope\") ends and sides of lagoons to avoid (overestimation) errors in calculating your storage capacity.  \nCalculators for carrying out slurry lagoon capacity calculations can be found by searching on the internet, for example the link below:"]
["www.agric.gov.ab.ca/app19/calc/volume/dugout.jsp"]
["(b) Calculation for a cylindrical store is: π r² h "]
["Pi x radius-squared x working height - see table at bottom left below."]
["If the radius of a cyclindrical store is not known and measuring its diameter to obtain the radius is difficult, you can use an alternative calculation from measuring the circumference of the store - see table at bottom right below.  If you're using this file onscreen, in either of the example tables below, you can enter the variables in the white cells to perform the calculations."]
[" Example below using radius (π r² h) measurement",null,null,"Example below using circumference measurement "]
["Pi",3.1419999999999999,null,"Circumference (C)",12.57]
["Radius",2,"m","Pi",3.1419999999999999]
["Radius ²",{"$f":"B24*B24","v":4},"m","Diameter (D)",{"$f":"E23/E24","v":4.0006365372374288},"(C ÷ Pi)"]
["Working height",3,"m","Floor area (a)",{"$f":"(E25*E25)*0.785","v":12.563997771917084},"(D x D x 0.785)"]
["Result",{"$f":"B23*B25*B26","v":37.704000000000001},"m³","Working height (h)",3]
[null,null,null,"Result",{"$f":"E26*E27","v":37.691993315751247},"(a x h)"]

{"sheet":"Table 27","index":27,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,0,3,5],[15,0,15,3],[16,0,16,5],[1,3,1,4],[2,3,2,4],[9,3,9,4],[10,3,10,4],[21,3,21,4],[17,0,17,5],[29,0,29,3],[4,3,4,4],[14,3,14,4],[18,3,18,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[19,3,19,4],[20,3,20,4],[28,3,28,4],[27,3,27,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4]]}
["Table 27: Poultry manure production per month"]
["Livestock type","Number of stock on solid manure or part-solid manure based system","Proportion of excreta collected as solid manure\neg half = 0.5, all = 1","Weight per 1,000 birds per month\n(tonnes)",null,"Weight produced each month\n(tonnes)"]
["Column 1",2,3,4,null,5]
["Laying hens"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total monthly production laying hen excreta (tonnes)",null,null,null,"A"]
[]
["Other poultry"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total monthly production of poultry litter (tonnes)",null,null,null,"B","="]

{"sheet":"Table 28","index":28,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,6],[31,0,31,4],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[36,0,36,6],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[30,4,30,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[29,4,29,5],[18,4,18,5],[26,4,26,5],[27,4,27,5],[9,4,9,5],[28,4,28,5],[34,0,34,1]]}
["Table 28: Capacity of existing poultry stores"]
["Store reference","Length \n(m)","Width \n(m)","Radius \n(cylindrical store)*","Working height (m)",null,"Capacity (m3)"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E3),\"\",IF(NOT(ISBLANK(D3)),3.142*(D3*D3)*E3,B3*C3*E3))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E4),\"\",IF(NOT(ISBLANK(D4)),3.142*(D4*D4)*E4,B4*C4*E4))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
["Total existing capacity (m³) =",null,null,null,null,"D",{"$f":"IF(SUM(G3:G31)=0,\"\",SUM(G3:G31))","v":""}]
[]
["Table 28 Note"]
["*Calculation for a cylindrical store is: π r² h "]
["Pi x radius-squared x working height - see table at bottom left below."]
["If the radius of a cyclindrical store is not known and measuring its diameter to obtain the radius is difficult, you can use an alternative calculation from measuring the circumference of the store - see table at bottom right below.  If you're using this file onscreen, in either of the example tables below, you can enter the variables in the white cells to perform the calculations."]
[" Example below using radius (π r² h) measurement",null,null,"Example below using circumference measurement "]
["Pi",3.1419999999999999,null,"Circumference (C)",12.57]
["Radius",2,"m","Pi",3.1419999999999999]
["Radius ²",{"$f":"B40*B40","v":4},"m","Diameter (D)",{"$f":"E39/E40","v":4.0006365372374288},"(C ÷ Pi)"]
["Working height",3,"m","Floor area (a)",{"$f":"(E41*E41)*0.785","v":12.563997771917084},"(D x D x 0.785)"]
["Result",{"$f":"B39*B41*B42","v":37.704000000000001},"m³","Working height (h)",3]
[null,null,null,"Result",{"$f":"E42*E43","v":37.691993315751247},"(a x h)"]

{"sheet":"Table 29","index":29,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,3],[0,0,0,5],[3,0,3,5],[25,0,25,3],[26,0,26,3],[1,3,1,4],[2,3,2,4],[27,0,27,5],[28,0,28,5],[36,0,36,5],[44,0,44,5],[55,0,55,3]]}
["Table 29: Cattle, sheep or pig solid manure production per month"]
["Livestock type on solid manure or part-solid manure based system","Number of stock on solid manure or part-solid manure  based system","Proportion of excreta collected as solid manure\neg half = 0.5, \nall = 1","Volume per livestock type (or place) per month\n(m3)",null,"Volume produced each month\n(m3 and tonnes)"]
["Columns 1",2,3,4,null,5]
["Dairy cows"]
["Example entry: 1 dairy cow (more than 9,000 litres annual milk yield)",100,"x   0.6","x    1.92",null,{"$f":"     115.2","v":115.2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"x","x",null,"="]
["Total monthly volume of excreta from dairy cows = ",null,null,null,"E"]
["Multiply E by 1.3 to give solid manure production (tonnes) = ",null,null,null,"F"]
[]
["Cattle"]
[null,null,"x","x",null,"="]
[]
[]
[]
[]
[]
[]
["Sheep"]
[null,null,"x","x",null,"="]
[]
[]
[]
[]
[]
[]
["Pigs"]
[null,null,"x","x",null,"="]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total monthly volume of excreta from cattle, sheep and pigs = ",null,null,null,"G"]
["Multiply G by 1.15 to give solid manure production (tonnes) =",null,null,null,"H"]

{"sheet":"Table 30","index":30,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,2]]}
["Table 30: Nitrogen and excreta production from cattle"]
["Cattle\n\n\n\n\n\nbracketed letters in the 2nd column refer to notes","Total N produced by cattle (kg/year)\n(note a)",null,"Volume of excreta \n(m3/month)","Animal number per ha to comply with maximum N loading (170 kg/ha N per year)"]
["1 calf (all categories) youger than to 2 months",1.4,"(b)",0.21,21.2]
["1 dairy cow from 2 months and less than 12 months",29,"(c)",0.6,4.9000000000000004]
["1 dairy cow from 12 months up to first calf",61,null,1.2,2.8]
["1 dairy cow after first calf (over 9,000 litres milk yield)",115,null,1.92,1.5]
["1 dairy cow after first calf (6,000 to 9,000 litres milk yield)",101,null,1.59,1.7]
["1 dairy cow after first calf (up to 6,000 litres milk yield)",77,null,1.26,2.2000000000000002]
["1 beef cow or steer (castrated male) from 2 months and less than 12 months",28,"(c)",0.6,5.0999999999999996]
["1 beef cow or steer  from 12 months and less than 24 months",50,null,0.78,3.4]
["1 female or steer for slaughter 24 months and over",50,null,0.96,3.4]
["1 female for breeding 24 months and over weighing up to 500 kg",61,null,0.96,2.8]
["1 female for breeding 25 months and over weighing over 500 kg",83,null,1.35,2]
["1 non-breeding bull 2 months and over",54,null,0.78,3.1]
["1 bull for breeding from 2 and less than 24 months",50,null,0.78,3.4]
["1 bull for breeding from 24 months",48,null,0.78,3.5]
[]
["Table 30 Notes"]
["(a)  Different units are used for cattle less than 12 months – see notes (b) and (c) below."]
["(b) Total N produced (kg) during the 2 months that the animal is in this category. This is calculated from 23 g x 60 days (2 months)."]
["(c) Total N produced (kg) during the 10 months that the animal is in this category. This is calculated from 95 g x 300 days (10 months)."]

{"sheet":"Table 31","index":31,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[14,0,14,4]]}
["Table 31: Nitrogen and excreta production by pigs places"]
["Pigs","Occupancy (%)","Total N produced\n(kg/year)\n(note a)","Volume of excreta\n(m3/month)","Animal places per ha to comply with maximum N loading (170 kg/ha N per year)"]
["1 weaner place, 7 to 13 kg",71,1,0.03,170]
["1 weaner place, 13 to 31 kg",82,4.2,0.05,40.5]
["1 grower place, 31 to 66 kg (dry fed)",88,7.7,0.1,22.1]
["1 grower place, 31 to 66 kg (liquid fed)",88,7.7,0.18,22.1]
["1 finisher place, 66 kg and over (dry fed)",86,10.6,0.13,16]
["1 finisher place, 66 kg and over (liquid fed)",86,10.6,0.26,16]
["1 maiden gilt place, 66 kg and over",80,11.1,0.13,15.3]
["1 sow place, 66 kg and over, with litter, up to 7 kg, fed on diet supplement with synthetic amino acids",100,16,0.33,10.6]
["1 sow place, 66 kg and over, with litter, up to 7 kg, diet without synthetic amino acids (low protein diet)",100,18,0.33,9.4]
["1 breeding boar from 66 kg to 150 kg",100,12,0.15,14.2]
["1 breeding boar, 150 kg and over",100,17.5,0.26,9.6999999999999993]
[]
["Table 31 Note (a): N produced in excreta is per pig place and includes an allowance for N losses from livestock housing and manure storage."]

{"sheet":"Table 32","index":32,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,3,1,4],[13,0,13,5],[0,0,0,5]]}
["Table 32: Nitrogen and excreta production by poultry places"]
["Poultry","Occupancy (%)","Total N produced\n(kg/year)\n(note a)","Weight of excreta\n(tones / month)",null,"Animal places per ha to comply with maximum N loading\n(170 kg/ha N /year)"]
["1,000 replacement layer pullet places, up to 17 weeks",89,210,1.1000000000000001,null,800]
["1,000 laying hens in cages, 17 weeks and over",97,400,3.5,null,420]
["1,000 laying hen places, free range (note b), 17 weeks and over",97,530,3.5,"(b)",320]
["1,000 broiler places ",85,330,1.5,null,510]
["1,000 replacement broiler breeder pullet places, up to 25 weeks ",92,290,1.1000000000000001,null,590]
["1,000 broiler breeder places, 25 weeks and over ",95,700,3.4,null,240]
["1,000 turkey places (male)",90,1230,4.3,null,140]
["1,000 turkey places (female)",88,910,3.2,null,190]
["1,000 duck places",83,750,2.5,null,230]
["1 ostrich",100,1.4,0.05,"(b)",121]
[]
["Table 32 Notes\n(a)  N produced in excreta is per 1,000 poultry places (except ostriches) and includes an allowance for N losses from livestock housing and manure storage.\n\n(b)  When calculating storage requirements, you should make an allowance for the proportion of time that birds are not housed. Commonly, free range laying hens are housed for 80% to 90% of the time.  Figures given assume 80% of excreta are deposited in buildings.\n"]

{"sheet":"Table 33","index":33,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,0,0,4]]}
["Table 33: Nitrogen and excreta production by sheep, goats, deer and horses"]
["Livestock type","Total N produced\n(kg/year)\n(notes a, b)",null,"Volume of excreta\n(m3/month)","Animal numbers per ha to comply with maximum N loading\n(170 kg/ha N per year)"]
["1 lamb, 6 to 9 months",0.5,"(c)",0.05,340]
["1 lamb, 9 months and over, to first lambing, first tupping or slaughter",0.7,"(d)",0.05,242.8]
["1 sheep, less than 60 kg, after lambing or tupping.  For ewes this includes one or more suckled lambs up to 6 months",7.6,null,0.1,22.4]
["1 sheep, over 60 kg, after lambing or tupping.  For ewes this includes one or more suckled lambs up to 6 months",11.9,null,0.15,14.3]
["1 goat ",15,null,0.11,11.3]
["1 deer for breeding",15.2,null,0.15,11.2]
["1 deer, other",12,null,0.11,14.2]
["1 horse",21,null,0.74,8.1]
[]
["Table 33 Notes\n(a)  Includes an allowance for N losses from livestock housing and manure storage.\n(b)  Different units are used for lambs – see notes c & d below.\n(c)  Total N produced (kg) during the three months that the animal is in this category.\n(d)  Total N produced (kg) assuming the animal is in this category for six months."]

{"sheet":"Table 34","index":34,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[10,0,10,1]]}
["Table 34: Crops to which manufactured nitrogen fertiliser may be applied during the closed spreading period"]
["Crop","Maximum nitrogen rate\n(kg/ha)"]
["Oilseed rape, winter (note a)",30]
["Asparagus ",50]
["Brassica (note b)",100]
["Bulb onions",40]
["Over-wintered salad onions",40]
["Parsley",40]
["Grass (notes a, c)",80]
[]
["Table 34 Notes\n(a)  Nitrogen must not be applied to these crops after 31 October.\n(b)  An additional 50 kg N/ha may be applied every four weeks during the closed spreading period up to the date of harvest.\n(c)  A maximum of 40 kg N/ha may be applied at any one time.\n"]

{"sheet":"Table 35","index":35,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,2,0],[1,1,2,1],[1,2,1,3]]}
["Table 35: The total N content of organic manures and maximum application rates to supply 250 kg N/ha of total nitrogen"]
["Manure type","Total N content","The maximum application rate to supply 250 kg/ha/N"]
[null,null,"Metric Units","Imperial Units"]
["Solid manure","kg/m3 or kg/t","tonnes/ha","tons/acre"]
["Cattle farmyard manure",6,42,17]
["Pig farmyard manure",7,36,14.5]
["Sheep farmyard manure",6,42,17]
["Duck farmyard manure",6.5,38,15]
["Poultry layer manure",16,16,6.5]
["Poultry broiler litter",30,8,3.2]
["Turkey litter",30,8,3.2]
["Horse farmyard manure",7,36,1.5]
["Goat  farmyard manure",6,42,17]
["Slurry","kg/m3 or kg/t","m3/ ha","gallons/acre"]
["Dairy cattle",3,83,7400]
["Beef cattle",2,125,11200]
["Pigs",4,63,5600]
["Separated manures","kg/m3 or kg/t","m3/ ha","gallons/acre"]
["Separated cattle slurry, liquid fraction, strainer box",1.5,167,14900]
["Separated cattle slurry, liquid fraction, weeping-wall",2,125,11200]
["Separated cattle slurry, liquid fraction, mechanically separated",3,83,7400]
["Separated cattle slurry, solid fraction",4,63,5600]
["Separated pig slurry, liquid fraction",3,70,6300]
["Separated pig slurry, solid fraction",5,50,4500]

{"sheet":"Table 36","index":36,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2],[9,0,9,2],[1,0,2,0],[6,1,7,1],[6,0,7,0]]}
["Table 36: The % of the total nitrogen content of livestock manure available for crop uptake in the growing season in which it is spread (Only for use in N max calculation)"]
["Manure type","Crop-available N\n(% of total N applied)","Crop-available N\n(% of total N applied)"]
[null,"from 1 January 2012","from 1 January 2014"]
["Cattle slurry",35,40]
["Pig slurry",45,50]
["Poultry manure",30,30]
["Other livestock manures",10,10]
[null,null,"(see note)"]
[]
["Table 36 Note: The value for farmyard manure is at the lower end of the range of values in European countries.  We will review the available evidence before the Regulations are next amended in 2016."]