ࡱ> SR ZO\p Ba==;8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1.Times New Roman1Arial1Arial1Arial1Arial1Arial1Arial1@Arial1@Arial1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,6Calibri16Calibri16Calibri1>141<Calibri1?Calibri1*h6 Calibri Light1Calibri1 Calibri1 Arial1 Arial1Arial"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.0000.0 0.00000 0.0000 0.0000000 0.000000                                                                      ff          P  P !  !  "   # ` $      %   & ' a> (                            H(  H(  D(  L(    H3  H(  H      L  D(  L(  L(  L(  L  L  L    D( * L( + L   4" 4"      4"  4 " (   )  * 3 *  3 ) 3 * 3  3 ) 3  3   3  3 ||v$q3}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}/ 00\);_(*}A}1 a00\);_(*;_(@_) }A}2 00\);_(*;_(@_) }A}3 00\);_(*?;_(@_) }A}4 00\);_(*23;_(@_) }-}5 00\);_(*}}7 ??v00\);_(*̙;_(@_)    }A}8 }00\);_(*;_(@_) }A}9 W00\);_(*;_(@_) }x}:00\);_(*;_(  }}; ???00\);_(*;_(??? ???  ??? ???}-}= 00\);_(*}U}> 00\);_(*;_( }-}? 00\);_(*}(}L00\);_(*}(}M00\);_(*}(}N00\);_(*}(}O00\);_(*}(}Q00\);_(*}(}R00\);_(*}(}S00\);_(*}(}V00\);_(*}(}W00\);_(*}(}X00\);_(*}(}Y00\);_(*}(}Z00\);_(*}(}[00\);_(*}(}\00\);_(*}(}]00\);_(*}(}_00\);_(*}<}` 00\);_(*;_(}<}a 00\);_(*;_(}(}l 00\);_(*}<}m 00\);_(*;_(}<}n 00\);_(*;_(}<}o 00\);_(*;_(}<}p 00\);_(*;_(}(}q00\);_(*}<}r 00\);_(*;_(}(}s00\);_(*}(}t00\);_(*}(}u00\);_(* 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L˭ % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  L % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23 % 60% - Accent3M( 60% - Accent3 23 % 60% - Accent4M, 60% - Accent4 23f % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23Ў % "Accent1AAccent1 Dr % #Accent2A!Accent2 }1 % $Accent3A%Accent3  % %Accent4A)Accent4  % &Accent5A-Accent5 [ % 'Accent6A1Accent6  pG %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 DTj%Dr3 Heading 2G Heading 2 DTj%?4 Heading 3G Heading 3 DTj%235 Heading 49 Heading 4 DTj%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  W%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title DTj% >TotalMTotal %DrDr? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`WSheet1>ySheet2{Sheet3"~Sheet4= * solver_adj*" solver_cvg-C6? solver_drv solver_eng solver_est" solver_itrA" solver_mipA solver_mni" solver_mrt333333? solver_msl solver_neg" solver_nodA solver_num solver_nwt solver_opt*" solver_preư> solver_rbv solver_rlx solver_rsd solver_scl solver_sho solver_sszd" solver_timA" solver_tol{Gz? solver_typ" solver_val? solver_ver5 iVNitrogen loadings *ParametersPhosphorous loadingsResultskg/m^2 kg/ha/year kg/ha/day mg/ha/day mg/m2/dayCritical loading rates calcs%Phosphate Retention Index (PRI) CalcsTopsoil depth (mm)Topsoil PRI (mg P/kg) Bulk densityKey Input required Calculations-Output value required for management purposes+LAA required based on nitrogen loadings is /Design life (years) - default value is 50 years!Nitrogen losses to volatalisation Vegetation N uptake (kg/ha/year)Bulk density default values Sandy soil 1.8 g/cm3 1.5 g/cm3 1.3 g/cm3 IntermediateClay,Phosphorus uptake by vegetation (kg/ha/year)kg/m2kg square metresSubsoil A PRI (mg P/kg)Subsoil B PRI (mg P/kg)(Subsoil A depths (mm) (max depth 1000mm)(Subsoil B depths (mm) (max dpeth 1000mm)% of PRI capacityLMaxiumum N loading rate (N uptake by vegetation, plus volatalisation losses)-Phosphate generated during design life period2Phosphorus vegetation uptake in deisgn life period)C (conc. Of N in treated wastewater mg/L)/Lx (critical loading rate mg/m^2/d) /Q (wastewater flow rate L/day) 9Depth weight PRI to 1 metre (PRI) (g P/kg) 6Critical loading rate of phosphate (mg/m^2/day) =Wastewater flow rate L/day 3Conc. of phosphate in treated wastewater (mg/L) 6Phosphorous sorption capacity (kg/ha) for design life haDesign yield (t/ha)MMaximum P loading rate (P vegetation uptake, plus P absorbed for design life)GPhosphorus adsorbed in design life period (adjusted for % PRI capacity)Design yield deficit (%)9Potassium deficit (i.e. potassium fertiliser requirement)7Nitrogen deficit (i.e. nitrogen fertiliser requirement)4Maximum potassium loading rate (K vegetation uptake)-LAA required based on Phosphorus loadings is Yield potential (t/ha)N demand (kg/tonne)(Nitrogen applied with wastewater (kg/ha)JNitrogen deficit (i.e. fertiliser required to achieve design yield (kg/ha)1Nitrogen required to achieve design yield (kg/ha)Determination of minimum Land Application Area required based on nutrient loadings (formulas based on Environment and Health Protection Guidelines 1998)LAND APPLICATION AREA: *Phosphorus uptake by vegetation (kg/tonne)Yield estimation Potassium0Vegetation K uptake (kg/ha/year) at design yield$LAA required based on K loadings is (C (conc of K in treated wastewater mg/L))Potassium applied with wastewater (kg/ha)2Potassium required to achieve design yield (kg/ha)KPotassium deficit (i.e. fertiliser required to achieve design yield (kg/ha)K demand (kg/tonne)*Design LAA (ha) based on N, P or K loading Brewery XXX5Compatibility Report for N P K Loading calculator.xlsRun on 2/09/2025 10:49If the workbook is saved in an earlier file format or opened in an earlier version of Microsoft Excel, the listed features will not be available.Minor loss of fidelity# of occurrencesVersionSome cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. Excel 97-2003Z= ]>}> @+@A5CUD,FLG I# cca  PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V'> BHLrT6-O:h#CZqVbiIqĀD7 o߼9o/^?ef[Pr/IM/ⅉ~Caǹ+~Woϟ^:r7=a3`/' $P2SD]]CqON,ݐO$qX~F1`逇ʖ$=Beb+IeT6Cl<((1;v˯d`#=%^Kzo%R.G"EBm`Ե>X r}4(r졈G2tNĵH2=Bd8C0id#$c}Ęlq3DQvIRyL~B5+`+P\MJy;}̬NaWU]w9qfGcX1Egh3K,PU+ ;Wu\"RtLQ!J!Dy!_N9HZCd.u-:VyA!ZϬA@ [ DD U UUU5VSnΘ@ DDDDD U!BX && &&C&=;A;7&&TB= " # $ 8% 8& ' ( ) * + , 8- . / 0123456789:;<=>?\ [ER? ] D' U2"E "B"FFFFFFF#FFFFFFFFF$F $F$FFFFGHH%F %C %FFFFGHH&F &C &FFFF~ &r8@ &HH'F 'C 'FFF'sry@ 'HH(F (C"(FFFF~ (r@ (HH)F )C$ )FFF)sy@r@ )HH*F *C#*FFFF~ *r *HH+F +C% +FFF+s@r@@ +HH,FFFFFFGHH-H -C--HHHH~-LA`"? hD'D'D&D)D)D(D*D+D+D'D'D)D)D+D+ -FF.HCHHHHAFF/H /C /HHHH~ /p@`@ /FF / C0HHHHHHAFF 0 C 0 C1H 1C1HHHH~ 1pI@ 1FF 1 C 1 C2H 2C&2HHHH2tUUUUUU? 2FF 2 C 2 C3HHHHHHAFF4H 4 4HHHHAFF5H5H 5CB 5HH~ 5r@ 5FF6H6H 6C 6HH!6uF85@7 D D56F7H7H 7 7HH7Niĭ?8 D6m7F 8HHH 8 8HH%8Wݹsc@9D7.A8F 9HHH 9 9HH9NPA@: D8'9F:F :C.:FFFF:OPA@AD9 :FF;F ;C0;FFFF~ ;pJ@ ;FF<F <C/<FFFF<LL@BD <FF=FFFFFFFFF >FFF >I>JJJJJ ?JJJ ?C1 ?JJ&?M^@@D-'D/?JPPPPP B X1000FLFLFLT8bf0L_]_YWFW2@ A B C D XE XF ,@G H I J K L M N O P Q R S T U W X Y Y@Z [ \ @] @^ @_ @ @JJJ @C @C5@J%@X?6D?D2'@J AJJJ AJ AC)AJ/AXOc*?DD:mD1.AAJ BJJJ BC BC(BJ5BY(\P@?D;D<mD1.ABJCJJJJJJJJJ DU:)Da[ebT@EDB%@A' DT!EUE\T? DD' ET2FB FBD GAA H HAA IKIA~ IoD@ JCEJA!JW(\q@_ DID  KKAKN4n-?L DJm LLA%LW9p'AMDK.A MMAMW}aS@N DL' N+NANZ}aS@WDM OAA PCGPA~ Ppt@PCQCQA RCLRA{ROT?SeDEDX )DED   $E $ ",DXD   $X $ "B SCHSA8SZ,N]@`"DPD.AmDR TCITATZ(\q@KDJ UCJUA!UZ mukd@, DTDS WUF WUUU(WVR&ʈ@XDDPDN WU!X[/BJO? DW' XU2 ZU''Z]~?5^r@DDD Z^Z^ [U8e[]ϬA@ROD DE -D DX DZD"DZDB [^[^ \^^^ ]U4+]]v8_@TD6D?2 ]^]^^U ^^^^ _U9_](\q@<DJ _^_^B XisyI;&=;A;70T7=X1QU` @a @b \c \d \e \ `U7!`] mukd@U DTDS `^`^ bP bP bPPPcQ cP cPPPdR dP dPPPeS ejejjjkkkmdK,((>@dkj ee7ggD ZO 2{  dMbP?_*+%&?'?(?)?MS odLetter"d??&U>@7ggD ZO }  dMbP?_*+%&?'?(?)?MS odLetter"d??&U>@7ggD ZO  8  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U} } q@} } }   $   bNbfff bObfffccggg cPcgggccggg bQ bf fR fSccggg dT eh~ h5@ iUccggg ccggg  88>@gbggD Oh+'0@HT` x Microsoft Excel@ET@15%7 ՜.+,0 PXd lt|  Sheet1Sheet2Sheet3Sheet4  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ACDEFGHIKLMNOPQRoot Entry FWorkbookSummaryInformation(BDocumentSummaryInformation8J