{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Title","Tutorial (4)","Tutorial (3)","Tutorial (2)","Tutorial","Copyright","Intro","Main","Example","Worksheet","Report","TableReport","Table 1","Table 2","Table 3","Table 4","Conversions","Sheet6","Sheet5","Sheet4","Sheet3","Sheet2","Sheet1","ZZZ","versions"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":371,"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":"Title","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"   Worksheet Calculations for using Animal "]
[null,null,null,"            Manures as Nutrient Sources"]
[null,null,null,null,"          A complement to AGR-146"]
[null,null,null,null,null,"               ( ManureUse1-2.xls, version 1.2 )"]
[null,null,null,null,"         Frank Sikora, Monroe Rasnake, and Bill Thom"]
[]
[null,null,"     @Copyright 2001 University of Kentucky Cooperative Extension Service.  All rights reserved."]
[]
[]
[null,null,null,null,null,"First time users hit button on left",null,null,"Go to Main Menu"]
[]
[]
[]
[null,null,null,null,null,"Zoom to Big View",null,null,"Tutorials on how to use the program."]
[]
[null,null,null,null,null,"Zoom to Medium View",null,null,"Information on Copyright"]
[]
[null,null,null,null,null,"Zoom to Small View"]
[]
[]
[null,null,null,null,null,"Remove standard toolbars",null,null,"Add standard                toolbars"]
[]
[]
[null,"           Please provide questions, comments, and suggested modifications of the program to one of the above authors."]
[]
[null,"           *Kyle Ramey provided assistance in developing initial stages of this program."]

{"sheet":"Tutorial (4)","index":1,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EXAMPLE 3:","Dairy Manure, Many Fields, Fertilizer Recomm."]
[]
[null,null,"It is highly recommended you print these tutorial steps"]
[null,null,"and follow them from the printout."]
[]
[null,"                                                                Late                                                Late"]
[null,"                                                              Winter                 Spring                 Summer               Fall"]
[null,"       Field   acres      Crop                                   N              N     P2O5   K2O          N             N   P2O5   K2O"]
[null,"11       52       alfalfa/orchardgrass hay          0             80       0       180            80             0        0        0"]
[null,"12       58       alfalfa/orchardgrass hay          0             80       0       220            80             0        0        0"]
[null,"13       67       corn/small grain silage         105           150       0       110             0             30       0       30"]
[null,"14       57       alfalfa/orchardgrass hay          0             80       0       140            80             0        0        0"]
[null,"15       92       corn silage                              0           150       0         70             0              0        0        0"]
[null,"16       44       corn/small grain silage         105           150       0       110             0             30       0       30"]
[null,"17       49       corn/small grain silage         105           150      40      110             0             30      50      30"]
[]
[null,"Steps in blue.  Actions to take in bold black."]
[]
[null,"Step 1.","Go to the Main Menu."]
[null,"Step 2.","Go to Worksheet."]
[null,"Step 3.","Before entering any data, hit the Clear All button to clear out any data already existing in the worksheet."]
[null,"Step 4.","Assume the dairy manure will be applied to all fields in the spring.  Begin by entering the Background Information for Field 11 into section 1.  Type in the Field ID (11,Spring) and the number of acres the field contains (52).  Select the crop to be grown, manure type, manure management, manure history, manure units, and basis for calculations from the drop down lists.  The crop to be grown is all other hay (except alfalfa) since there is less than 25% alfalfa.  Manure type is Liquid/Dairy/Lagoon.  Manure management is Pasture(Fall or Early Spring).  Manure history is None.  Manure units available for selection are gallons or acre-inch.  Select acre-inch for this example.  Since fertilizer recommendations are given, the basis for calculation is Fertilizer Recom.  After selecting Fertilizer Recom. as the basis for calculation, yield unit and estimated yield per acre comes up as “not needed”.  These entries are only needed if crop removal is used as the basis to calculate manure application."]
[null,"Step 5.","Enter Fertilizer Recommendations in section 2.   The recommendations from the soil test are 80 lbs/acre of N, 0 lbs/acre of P2O5, and 180 lbs/acre of K2O.  If the basis for calculation was chosen to be crop removal, these values would automatically be calculated based on yield unit and estimated yield using the crop removal values in Table 4."]
[null,"Step 6.","Enter Fertilizer Already Applied in section 3.  In this example, no fertilizer was applied.  Enter 0 for N, P2O5, and K2O."]
[null,"Step 7.","Section 4 makes an estimate of how much N is available from previous year manure application.  In this example, no past manure application is assumed."]
[null,"Step 8.","The net nutrient needs the field will require are automatically calculated in Section 5 taking into account nutrients required, nutrients already applied, and residual N from last years manure application.  Observe the net nutrient needs of 80, 0, and 180 lbs/acre for N, P2O5, and K2O."]
[null,"Step 9.","Section 6 determines the available nutrients in the manure.  Enter the total N, P2O5, and K2O contents of the manure in sections 6a, 6b, and 6c, respectively.  These values can be from a laboratory analysis, historical laboratory analysis of the manure under the same management conditions, or estimates taken from Table 1.  To get estimated nutrient content from Table 1, hit Retrieve Manure Table Values.  Values of 109, 54, and 82 lbs/acre-inch should appear for N, P2O5, and K2O, respectively.  The available P2O5 and K2O is automatically calculated.  The fraction of total N that is available to plants depends on how the manure is managed during land application.  Hit Auto Retrieve to automatically retrieve the availability coefficient from Table 2.  This value should be 0.8 to result in 87 lbs of available N/acre-inch."]
[null,"Step 10.","Section 7 determines how much manure should be applied to meet the crop needs for either N, P2O5, or K2O.  In 7a, select N to be the priority nutrient from the drop down box.  The priority nutrient needed and the available amount in the manure automatically appear in section 7b.  To calculate the amount of manure needed to supply the lbs/acre of the priority nutrient, hit the Calc button on the right hand side of the yellow box of section 7c.  If N was selected as the priority nutrient, the manure application rate should show 0.9 acre-inch/acre.  "]
[null,null,"The Nutrient Management Plan being developed by NRCS restricts application rate of liquid manure to 0.5 acre-inch/acre for each application event allowing up to 1.5 acre-inch/acre application for 3 application events.  Following the NRCS Nutrient Management Plan, enter 0.5 in section 7c. Notice you are made aware that the value is a manually entered value by the words directly beneath.  You can always go back to the calculated value by hitting Calc.  Section 7d contains the total amount of manure it would take to apply manure at the designated rate to the whole field with the number of acres entered in section 1b.  This value should be 26 acre-inches at 0.5 acre-inch/acre.  The total amount of manure needed is blank if the number of acres is not entered in section 1b."]
[null,"Step 11.","Sections 8 and 9 are automatically calculated.  Section 8 shows the nutrients supplied by the manure in lbs/acre at the application rate shown in 7c.  Section 9 shows a balance of nutrients with respect to the nutrient levels needed as shown in section 5.  A positive number means an excess of nutrient applied according to what is needed.  A negative number indicates a deficit of nutrient applied according to what is needed.  Observe section 8 that shows 44, 22, and 41 lbs/acre of N, P2O5, and K2O are applied in the manure at 5 tons/acre.  Observe section 9 that shows the corn would still need 36 and 139 lbs/acre of N and K2O, respectively, and would receive 22 lbs/acre of P2O5 more than it needs. "]
[null,"Step 12.","Select the Multiple Field Report button to go to a report form that summarizes manure nutrient application rates for several field."]
[null,"Step 13.","Hit the Clear All button to clear all the table.  You will be asked if you are really sure you want to clear the table."]
[null,"Step 14.","From the drop down box in the upper left-hand corner, select the type of manure which is Liquid/Dairy/Lagoon.  It has to be the same as selected in the worksheet."]
[null,"Step 15.","Enter the first field by selecting the first Enter button.  Pertinent information from the worksheet will be copied onto the first row.  A delete button will appear for the first row to choose if you wish to delete the information just entered.  If the manure type in the report was not the same as on the worksheet, a warning message would appear alerting you of this.  You would have to hit the OK button and select the correct manure type."]
[null,"Step 16.","Hit the Worksheet button to go back to the worksheet.  Calculate the nutrient needs of field 12 assuming the same application rate of 0.5 acre-inch/acre.  Enter the Field ID (12,spring) and number of acres (58) in section 1.a. and 1.b.  Field 12 has the same crop as field 11, so section 1.c. does not need changed.  Go to section 2, and enter the N, P2O5, and K2O requirements of 80, 0, and 220, respectively.  Everything else remains the same."]
[null,"Step 17.","Go back to the Multiple Field Report and select the second row entry button.  This adds the pertinent information from the worksheet onto the multiple field report.  The total manure used for fields 11 and 12 is shown on the summation line as 55 acre-inch.  Also notice the total acres of 110 for both fields.  These values will continuously be summed for the data entered into the report."]
[null,"Step 18.","This step involves repeating Steps 16 and 17 until the spring nutrient requirements are entered for every field and entered into the multiple field report.  When going to the worksheet, remember to change the field ID, field acres, crop to be grown, manure type managment, and Fertilizer Recommendations according the table in the summary of this example for spring application of nutrients.  Then go to Multiple Field report and enter the information for the field in the next row.  "]
[null,"Step 19.","After spring nutrient application for all the fields are entered in the Multiple Field Report (fields 11 to 17), the total number of acres should equal 419 and the total manure used should equal 210 acre-inch.  The outline of this example said there was 6 million gallons (or 221 acre-inch) of liquid dairy manure per year to dispose.  By applying the manure on all the fields in the spring, you could come very close to achieving this goal.  However, applying all of the manure in the spring may not be feasible because of time constraints with other spring activities.  You can analyze the situation a little differently by seeing what happens if you split the application of the manure in the year.  The hay fields need an extra dose of N late in the summer.  Also, field 17 is low in P and could use some extra manure to add P to the soil.  Go through an exercise in the following steps to split the manure application on fields 11, 12, 14, and 17 and delete manure application on fields 13, 15, and 16."]
[null,"Step 20.","In the Multiple Field report, delete the rows representing fields 13, 15, and 16 for spring application.  If you accidentally delete one of the other rows, hitting enter will only enter the most recent information put in the worksheet which in this case would be field 17.  To reenter the appropriate information after and accidental delete, you would have to reenter the information in the worksheet."]
[null,"Step 21.","Go to the Worksheet and enter 11,late sum for field ID, 52 for field acres, all other hay (except Alfalfa) for crop to be grown, and 80/0/0 for later summer fertilizer recommendations."]
[null,"Step 22.","Go back to the Multiple Field report and hit the enter button for the row following field 17,spring.  The pertinent information entered and calculated in the Worksheet will be entered into the row for field 11,late summer."]
[null,"Step 23.","Repeat steps 21 and 22 for fields 12, 14, and 17 for late summer application.  Remember to change the field ID, field acres, crop to be grown, and Fertilizer Recommendations according to the table in the summary of this example.  For field 17 choose “winter wheat for grain” for the crop to be grown.  There is currently not a selection of small grains for silage.  Also select “Small Grain(pre-plant)” for Manure management in section 1.e."]
[null,"Step 24.","With split application of the manure in the year, the total manure applied is now 216 acre-inch.  This split-application will come very close to disposing the total 221 acre-inch/year that is required.  It also may be easier applying the manure two times a year instead of only in the spring due to time constraints in the spring.  Notice the nutrients applied are calculated for each field in units of lbs/acre.  The balance of nutrients on the fields are also shown.  A negative value means that field needs that additional amount of nutrient according to the fertilizer recommendation entered.  A positive number means the manure is supplying that nutrient in excess of what is recommended by the amount shown.  If there are negative values, as is the case with N in all the fields, fertilizer needs to be added to supplement the nutrients supplied by the manure."]
[null,"Step 25.","The last and final step is to print the report.  Hit the print button to perform this action."]

{"sheet":"Tutorial (3)","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EXAMPLE 2:","Poultry Litter, One Field, Crop Removal"]
[]
[null,null,"It is highly recommended you print these tutorial steps"]
[null,null,"and follow them from the printout."]
[]
[null,"Steps in blue.  Actions to take in bold black."]
[]
[null,"Step 1.","Go to Main Menu.  Go to Worksheet."]
[null,"Step 2.","Assume the same conditions for Example 1, except that the P and K soil test levels are very high and no P or K fertilizer is recommended.  Go to section 1.h. and select Crop Removal from drop down box.  Section 1.i. automatically gets a yield unit depending on the crop entered in Section 1.c.  The cursor automatically goes to Section 1.j. awaiting your entry of the estimated yield.  For this example, enter an estimated yield of 150 bushels/acre.  You only need to enter the number.  Hit the enter key after entering the number."]
[null,"Step 3.","Hit the Calculate button next to Crop Removal to calculate nutrient application rates based on the estimated yield.  After the calculation, Section 2 will show the basis for nutrient recommendation rates is Crop Removal.  The values are determined from data present in Table 4.  After hitting the calculation button the first time after selecting Crop Removal in Section 1.h., you can always go back to Section 1.j. and enter another estimate for yield.  The nutrient application rates will automatically be calculated from the new entry.  For this example, you think 150 bushels/acre may be too low.  Go back to section 1.j. and enter 180.  With an estimated yield of 180 bushels/acre, the nutrient removal values should show 126, 72, and 63 lbs/acre for N, P2O5, and K2O, respectively."]
[null,"Step 4.","If you think the application rates in Section 2 are too low or too high, you have the option of modifying any of the rates shown.  In this example, basing N application on N removed in grain may be too little for optimizing corn growth.  A rule of thumb for N application on well-drained soils is 1 to 1.1 pounds of N per bushel of grain.  For 180 bushels/acre, that would mean 180 to 198 pounds of N per acre.  Go to section 2.a. and type in 180.  Notice the basis for nutrient application now shows “Both” which refers to both Fertilizer Recommendation (180 for N) and Crop Removal (72 and 63 for P2O5 and K2O).  If you typed in new values for P2O5 and K2O directly, the basis for nutrient application would show Fertilizer Recommendations.  To go back and recalculate based on Crop Removal, go to section 1.h. select Fertilizer Recommendation, then select Crop Removal."]
[null,"Step 5.","Since all the information is the same as for Example 1, go to section 7.a. and select P2O5 as the priority nutrient to base manure application rates.  Hit the Calc button to calculate the rate.  Notice the nutrient balance for P2O5 in section 9.b. is 0 lbs/acre because the application of 1.6 tons/acre applies just the amount of P2O5 anticipated to be removed in corn grain."]
[null,"Step 6.","Hit the Report button to go to the report.  The priority nutrient is shown as phosphorus in the upper section of the report with the background information.  Notice the manure application rate of 2 tons/acre is different than the 1.6 tons/acre shown on the worksheet.  A rounded value is reported since applying poultry litter (or any other type of manure) as accurate as to the tenth of a ton per acre is unrealistic.  The total amount of manure needed for the field, the amount of nutrients applied, and the nutrient balance reflects the rounded value of 2 tons/acre of litter application.  You can enter 2 tons/acre of manure application in the worksheet in section 7.c.  However, the report would look exactly the same except phosphorus would not be shown as a priority nutrient.  The computer only knows when to report the priority nutrient used for a calculation if a calculated value is used in section 7.c."]
[null,"Step 7.","Type in any comments you wish to make.  The last and final step is to hit the Print button to print out the report.  The report can be signed on the signature line and sent to the farmer."]

{"sheet":"Tutorial (2)","index":3,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EXAMPLE 1:","Poultry Litter, One Field, Fertilizer Recomm."]
[]
[null,null,"It is highly recommended you print these tutorial steps"]
[null,null,"and follow them from the printout."]
[]
[null,"Steps in blue.  Actions to take in bold black."]
[]
[null,"Step 1.","Go to the Main Menu."]
[null,"Step 2.","Go to Worksheet."]
[null,"Step 3.","Before entering any data, hit the Clear All button to clear out any data already existing in the worksheet."]
[null,"Step 4.","Enter the Background Information into section 1.  Type in the Field ID (tract#103) and the number of acres the field contains (50).  Select the crop to be grown, manure type, manure management, manure history, manure units, and basis for calculations from the drop down lists.  The crop to be grown is corn for grain.  Manure type is Solid/Broiler/fresh.  Manure management is Corn&Others/Spring/>7d incor.  Manure history is PoultryorLiquid/4-8yrs out of 10.  Manure unit automatically comes up as tons since the manure is solid and this is the only available unit for solid manures.  Since fertilizer recommendations are given, the basis for calculation is Fertilizer Recom.  After selecting Fertilizer Recom. as the basis for calculation, yield unit and estimated yield per acre comes up as “not needed”.  These entries are only needed if crop removal is used as the basis to calculate manure application."]
[null,"Step 5.","Enter Fertilizer Recommendations in section 2.   The recommendations from the soil test are 180 lbs/acre of N, 70 lbs/acre of P2O5, and 125 lbs/acre of K2O.  If the basis for calculation was chosen to be crop removal, these values would automatically be calculated based on yield unit and estimated yield using the crop removal values in Table 4."]
[null,"Step 6.","Enter Fertilizer Already Applied in section 3.  In this example, no fertilizer was applied.  Enter 0 for N, P2O5, and K2O."]
[null,"Step 7.","Enter Information in section 4 so an estimate can be made on N available from previous year manure application.  The amount of manure applied last year was 2 tons/acre.  Next, enter the lbs/ton of N in the manure applied last year.  If you do not have an analysis, an estimate of the N content can be obtained from Table 1.  Go to Main Menu, then Table 1.  An average N content of fresh broiler litter is 55 lbs/ton.  Go back to Main Menu, then Worksheet.  Enter 55 lbs/ton for the lbsN/unit.  The fraction of the N applied last year that will be available the current crop year can be automatically retrieved from Table 3 by hitting the Auto Retrieve button.  The available N is automatically calculated to be 7.7 lbs N/acre."]
[null,"Step 8.","The net nutrient needs the field will require are automatically calculated in Section 5 taking into account nutrients required, nutrients already applied, and residual N from last years manure application.  Observe the net nutrient needs of 172, 70, and 125 lbs/acre for N, P2O5, and K2O."]
[null,"Step 9.","Section 6 determines the available nutrients in the manure.  Enter the total N, P2O5, and K2O contents of the manure in sections 6a, 6b, and 6c, respectively.  These values can be from a laboratory analysis, historical laboratory analysis of the manure under the same management conditions, or estimates taken from Table 1.  To get estimated nutrient content from Table 1, hit Retrieve Manure Table Values.  Values of 55, 55, and 45 lbs/ton should appear for N, P2O5, and K2O, respectively.  The available P2O5 and K2O is automatically calculated.  The fraction of total N that is available to plants depends on how the manure is managed during land application.  Hit Auto Retrieve to automatically retrieve the availability coefficient from Table 2.  This value should be 0.45 to result in 25 lbs of available N/ton.  Go back to section 1.e. (manure type management) and change to Corn&Others/Spring/<2d incorp. to see how it affects the availability coefficient of N from 0.45 to 0.6.  Less of the nitrogen is lost to as ammonia if the manure is incorporated sooner after application.  Change 1.e. back to Corn&Others/Spring/>7d incorp."]
[null,"Step 10.","Section 7 determines how much manure should be applied to meet the crop needs for either N, P2O5, or K2O.  In 7a, select N to be the priority nutrient from the drop down box.  The priority nutrient needed and the available amount in the manure automatically appear in section 7b.  To calculate the amount of manure needed to supply the lbs/acre of the priority nutrient, hit the Calc button on the right hand side of the yellow box of section 7c.  If N was selected as the priority nutrient, the manure application rate should show 7 tons/acre.  If for some reason, this application rate seemed unreasonable you can manually enter a value in 7c.  Some examples for unreasonable rates may be if the calculated value was something extremely high or low for feasible application.  Or, if the value was 5.2 tons/acre and you wanted to round it to 5, you could enter 5.  Let’s assume 7 tons/acre is too high of an application rate and you believe 5 tons/acre would be more feasible.  Enter 5 in section 7c.  "]
[null,null,"Notice you are made aware that the value is a manually entered value by the words directly beneath.  You can always go back to the calculated value by hitting Calc.  Section 7d contains the total amount of manure it would take to apply manure at the designated rate to the whole field with the number of acres entered in section 1b.  This value should be 250 tons at 5 tons/acre application.  The total amount of manure needed is blank if the number of acres is not entered in section 1b."]
[null,"Step 11.","Sections 8 and 9 are automatically calculated.  Section 8 shows the nutrients supplied by the manure in lbs/acre at the application rate shown in 7c.  Section 9 shows a balance of nutrients with respect to the nutrient levels needed as shown in section 5.  A positive number means an excess of nutrient applied according to what is needed.  A negative number indicates a deficit of nutrient applied according to what is needed.  Observe section 8 that shows 124, 220, and 225 lbs/acre of N, P2O5, and K2O are applied in the manure at 5 tons/acre.  Observe section 9 that shows the corn would still need 49 lbs/acre of N and would receive 150 and 100 lbs/acre of P2O5 and K2O more than it needs. "]
[null,"Step 12.","Now that you are done with calculating manure application rate, it is time to report the results for the client.  Hit the Report button to enter the report page."]
[null,"Step 13.","You will see that all the background information on the worksheet is automatically placed on the report in the upper portion of the report.  The background information that needs to be entered on the report is the County name, farmer name and address.  Enter county, farmer name and address in place of the red # #."]
[null,"Step 14.","The middle part of the report shows the manure application rate and the total amount of manure needed for the field.  Observe the manure application rate should be 5 tons/acre with a total of 250 tons needed for the field."]
[null,"Step 15.","The last section of the report shows how much nutrients would be applied to the field and the balance of the nutrients with respect to what the crop needs.  The values are rounded to the tens.  Notice 120, 220, and 230 lbs/acre of N, P2O5, and K2O are applied and the crop needs 50 lbs/acre of additional N.  Phosphate and potash are applied at levels of 150 and 100 lbs/acre more than what the crop needs for current year growth."]
[null,"Step 16.","You can type in any notes you want regarding the calculation of manure application rate.  For this example, you could type a note telling the farmer to make sure to put on additional N because 5 tons/acre will not supply all the N needs.  You may want to indicate how much fertilizer would be needed to supply the additional 50 lbs/acre.  Also, you can indicate the fertilizer could be sidedressed to improve the efficient use of the N."]
[null,"Step 17.","The last and final step is to hit the Print button to print out the report.  The report can be signed on the signature line and sent to the farmer."]

{"sheet":"Tutorial","index":4,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Example 1.\nPoultry Litter,\n  One Field,\n Fertilizer Recomm.","This example is for fresh broiler litter to be used to provide the nitrogen needs of a corn crop grown for grain.  Fertilizer recommendations from soil test results call for 180 pounds of nitrogen, 70 pounds of phosphate, and 125 pounds of potash.  Two tons per acre of broiler litter was applied last year and has been applied four out of the last ten years.  The litter will be broadcast on the surface and corn planted in no-till soil.  The field to which the litter will be applied is identified as tract#103 and contains 50 acres."]
[]
[null,"Example 2.\nPoultry Litter,\n  One Field,\n Crop Removal","This example uses the same background information given in example 1, but calculates manure application based on crop removal and not on fertilizer recommendations from a soil test.  Calculating based on crop removal can be used when soil test P and K levels are very high and no fertilizer P and K are recommended.  In this situation you should account for how much P and K are removed in the crop grown and have these values entered for recommended nutrient application.  Crop removal values represent how much P and K could be added to the soil via manure without increasing or decreasing soil P and K levels.  The final manure application rate is based on P as the priority nutrient.  You have to complete Example 1 before performing Example 2.  "]
[]
[null,"Example 3.\nDairy Manure,\n  Many Fields,\n Fertilizer Recomm.","This example walks you through a calculation of how much liquid dairy manure to apply to several fields on a dairy farm.  The manure is stored in lagoons and there is approximately 6,000,000 gallons (221 acre-inches) that has to be disposed of each year.  Assume the availability of residual N is negligible.  There are 7 fields having access to dairy liquid manure disposal through irrigation sprayers (fields 11, 12, 13, 14, 15, 16, and 17).  Fields 11, 12, and 14 are in alafalfa/orchardgrass hay with less than 25% in alfalfa.  Fields 13, 16, and 17 are in corn/small grain silage.  Field 15 is in corn silage.  The fertilizer recommendations and the size of the fields are summarized in the table below.  "]
[]
[null,"                                                                Late                                                Late"]
[null,"                                                              Winter                 Spring                 Summer               Fall"]
[null,"       Field   acres      Crop                                   N              N     P2O5   K2O          N             N   P2O5   K2O"]
[null,"11       52       alfalfa/orchardgrass hay          0             80       0       180            80             0        0        0"]
[null,"12       58       alfalfa/orchardgrass hay          0             80       0       220            80             0        0        0"]
[null,"13       67       corn/small grain silage         105           150       0       110             0             30       0       30"]
[null,"14       57       alfalfa/orchardgrass hay          0             80       0       140            80             0        0        0"]
[null,"15       92       corn silage                              0           150       0         70             0              0        0        0"]
[null,"16       44       corn/small grain silage         105           150       0       110             0             30       0       30"]
[null,"17       49       corn/small grain silage         105           150      40      110             0             30      50      30"]

{"sheet":"Copyright","index":5,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Worksheet Calculations for using Animal "]
[null,"Manures as Nutrient Sources"]
[null,"A compliment to AGR-146"]
[null,"( ManureUse.xls, version 1.0 )"]
[null,"Frank Sikora, Monroe Rasnake, and Bill Thom"]
[]
[null," @Copyright 2001 University of Kentucky Cooperative Extension Service.  All rights reserved."]
[]
[]
[]
[null,"THIS PROGRAM/APPLICATION IS PROVIDED WITH NO WARRANTY, EXPRESS OR IMPLIED."]
[]
[null,"VIRUS PROTECTION related to the installation of this program/application and/or any use of the distribution diskettes, CD-ROMs, or email transmissions IS THE RESPONSIBILITY OF THE USER.  Neither the program, the application, nor the distribution media are guaranteed to be free of computer viruses or errors."]
[]
[null,"This program may be used by any individual who is required to complete a Nutirent Managment Plan, or by an employee of a governmental agency (such as a Kentucky Cooperative Extension Office or a local Kentucky Conservation District) that is responsible for assisting landowners and/or farm operators developing Nutrient Management Plans."]
[]
[null,"Permission for such persons to run this program is granted subject to the following condition: the program may not be sold, nor bundled with any other product(s) (such as software, printed information, etc.) for which a user is charged, or for which a user must pay any kind of fee (license fee or otherwise)."]

{"sheet":"Intro","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"The rates of manure to use for a particular crop depends on: 1) the nutrient needs of the crop, 2) the nutrients available from manure, and 3) the amount of a priority nutrient to be supplied by the manure (N, P, or K)."]
[]
[null,"This program can be used to calculate how much manure should be applied to provide the priority nutrient needed by a crop.  A nutrient balance is also calculatd to show if some nutrients need to be added from other sources.  The calculations are based on tables presented in UK extension publication AGR-146 for nutrient availability in manure and UK extension publication ID-56 for crop removal values."]
[]
[null,"The program is an EXCEL file that needs to be opened with EXCEL97 or EXCEL2000.  Select \"Enable Macros\" when opening.  The title page will be the first page that appears the very first time ManureUse(v.#).xls is opened.  Hit the button that says \"- Toolbars\" to remove the toolbars and adjust the screen for optimum viewing.  You will still have the main EXCEL menu function available from the top of the screen.  You can always have the toolbars reappear by hitting       \"+ Toolbars\".  If you save the file from a page other than the title page, the page that you saved from will be the one that appears upon reopening.  You should renavigate to the title page and select \"- Toolbars\" button to readjust the screen for optimum viewing."]
[]
[null,"When ManureUse.xls is opened, the first window that appears is a Title Page.  From the Title Page, you can go to the Main Menu, which is the gateway to all the program functions."]
[]
[null,"The Title Page also contains buttons to make the screen bigger or smaller.  Depending on the resolution of your computer, you may have to adjust the size to fit the program windows on the computer screen with minimal to no scrolling.  If the buttons don't help, you can go to View / Zoom to adjust the screen resolution.  View / Zoom will work only for the current screen."]
[]
[null,"Copyright information on the program is obtained by hitting the copyright button."]
[]
[null,"The tutorial button takes you to a description of how to use the program.  There are three examples set up as tutorials to step you through the use of the program.  Two of the examples involves the land application of poultry litter onto one field.  The third example involves land application of dairy manure onto several fields."]

{"sheet":"Main","index":7,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"                               MAIN MENU"]
[]
[null,null,null,"Includes copyright information, tutorial, and screen settings.",null,null,"Nutrient content of manures"]
[]
[null,null,null,"An example worksheet with poultry manure",null,null,"Nutrient availability in manures"]
[]
[null,null,null,"The worksheet for calculating manure application rates",null,null,"Nitrogen availability from past manure application"]
[]
[null,null,null,"A report summarizing results from the worksheet",null,null,"Nutrient removal in agronomic crops"]
[]
[null,null,null,"A report for multiple fields summarizing worksheet results",null,null,"Table of conversions"]

{"sheet":"Example","index":8,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"YOU CAN NOT MODIFY ANYTHING HERE.  THIS IS JUST AN EXAMPLE WORKSHEET."]
[]
[null,null," 1.  Background Information",null,null,null,null,null,null,"6.  Available Nutrients in Manure"]
[null,null,"     a.  Field ID",null,"","tract#103",null,null,null,"     (from Table 1 or test results)"]
[null,null,"     b.  Field acres",null,null,50]
[null,null,"     c.  Crop to be grown",null,"",null,null,null,null,"     a.  N (lbs N/unit)",null,"",55,null,"lbs/ton"]
[null,null,"     d.  Manure type (Table 1)",null,"",null,null,null,null,"     avail. coefficient (Table2)",null,"",0.45]
[null,null,"     e.  ...management (Table 2)",null,"",null,null,null,null,"                        Available N",null,null,24.75,null,"lbs/ton"]
[null,null,"     f.   …history (Table 3)",null,"",null,null,null,null,"     b.  P205 (lbs P2O5/unit)",null,"",55,null,"lbs/ton"]
[null,null,"     g.  …units (Table 5) ",null,"",null,null,null,null,"                   Available P2O5",null,null,44,null,"lbs/ton"]
[null,null,"     h.  Basis for calculations",null,"",null,null,null,null,"     c.  K2O (lbs K2O/unit)",null,"",45,null,"lbs/ton"]
[null,null,"     i.   Yield unit",null,null,"not needed",null,null,null,"                    Available K2O ",null,null,45,null,"lbs/ton"]
[null," ","     j.   Estimated yield per acre",null,"","not needed",null,""]
[null,null,null,null,null,null,null,null,null,"7.  Application Rate to Supply Priority Nutrient"]
[null,null," 2.  Fertilizer Recom. or Crop Removal",null,null,"Fertilizer Recom."]
[null,null,"     a.  Nitrogen",null,"",180,null,"lbs/A",null,"     a.  Priority Nutrient"]
[null,null,"     b.  Phosphorus (P2O5)",null,"",70,null,"lbs/A",null,"     b.  Priority Nutrient Needed",null,null,172,null,"lbs/A"]
[null,null,"     c.  Potassium (K2O)",null,"",125,null,"lbs/A",null,"         …....Available in Manure",null,null,24.75,null,"lbs/ton"]
[null,null,null,null,null,null,null,null,null,"     c.  Manure Application Rate",null,null,3,null,"tons/A"]
[null,null,null,null,null,null,null,null,null,"          (units/A)",null,null,"        entered value"]
[null,null," 3.  Fertilizer Already Applied",null,null,null,null,null,null,"     d. Total Manure Applied (units)",null,null,{"$f":"IF(fieldacres=0,\"\",fieldacres*manureneeded)","v":""},null,{"$f":"IF(unitm=1,\"tons\",IF(unitm=2,\"1000gal\",IF(unitm=3,\"acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     a.  N",null,"",0,null,"lbs/A"]
[null,null,"     b.  P2O5",null,"",0,null,"lbs/A",null,"8.  Nutrients Supplied by 7c"]
[null,null,"     c.  K2O",null,"",0,null,"lbs/A",null,"     a.  N (7c x 6a)",null,null,{"$f":"AN*MN","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,null,null,null,null,null,null,null,"     b.  P2O5 (7c x 6b)",null,null,{"$f":"MN*AP","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null," 4.  Residual N from Manure",null,null,null,null,null,null,"     c.  K2O (7c x 6c)",null,null,{"$f":"MN*KPU","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,"     Units applied per acre last year ",null,"",2,null,"tons/A"]
[null,null,"     lbs N/unit ",null,"",55,null,"lbs N/ton",null,"9.  Nutrient Balance"]
[null,null,"     availability coefficient (Table 3)",null,"",7.0000000000000007E-2,null,95,null,"     (-) indicates need; (+) indicates excess"]
[null,null,"                              Available N(lbs/unit)     ",null,null,7.7,null,"lbs N/A",null,"     a.  N (8a - 5a)",null,{"$f":"IF(ROUND(adtN,0)=0,\"\",IF(adtN>0,\"excess\",\"need\"))","v":{"$error":"#DIV/0!"}},{"$f":"NS-N","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,null,null,null,null,null,null,null,"     b.  P2O5 (8b - 5b)",null,{"$f":"IF(ROUND(adtP,0)=0,\"\",IF(adtP>0,\"excess\",\"need\"))","v":{"$error":"#DIV/0!"}},{"$f":"PS-P","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null," 5.  Net Nutrient Needs",null,null,null,null,null,null,"     c.  K2O (8c - 5c)",null,{"$f":"IF(ROUND(adtK,0)=0,\"\",IF(adtK>0,\"excess\",\"need\"))","v":{"$error":"#DIV/0!"}},{"$f":"KS-K","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,"     a.  N (2a - 3a - 4)",null,null,172.3,null,"lbs/A"]
[null,null,"     b.  P2O5 (2b - 3b)",null,null,70,null,"lbs/A"]
[null,null,"     c.  K2O (2c - 3c)",null,null,125,null,"lbs/A"]

{"sheet":"Worksheet","index":9,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null," 1.  Background Information",null,null,null,null,null,null,"6.  Available Nutrients in Manure"]
[null,null,"     a.  Field ID",null,{"$f":"IF(fieldID=\"\",\"Enter >\",\"\")","v":"Enter >"},null,null,null,null,"     (from Table 1 or test results)"]
[null,null,"     b.  Field acres",null,{"$f":"IF(fieldacres=\"\",\"Enter >\",\"\")","v":"Enter >"}]
[null,null,"     c.  Crop to be grown",{"$f":"IF(crop<21,\"\",\"Enter >\")","v":"Enter >"},null,null,null,null,null,"     a.  N (lbs N/unit)",null,{"$f":"IF(NPU=\"\",\"Enter >\",\"\")","v":"Enter >"},null,null,{"$f":"IF(unitm=1,\"lbs/ton\",IF(unitm=2,\"lbs/1000gal\",IF(unitm=3,\"lbs/acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     d.  Manure type (Table 1)",{"$f":"IF(mantype<16,\"\",\"Enter >\")","v":"Enter >"},null,null,null,null,null,"     avail. coefficient (Table2)",null,{"$f":"IF(AC=\"\",\"Enter >\",\"\")","v":"Enter >"}]
[null,null,"     e.  ...management (Table 2)",{"$f":"IF(manmanage<10,\"\",\"Enter >\")","v":"Enter >"},null,null,null,null,null,"                        Available N",null,null,{"$f":"NPU*AC","v":0},null,{"$f":"IF(unitm=1,\"lbs/ton\",IF(unitm=2,\"lbs/1000gal\",IF(unitm=3,\"lbs/acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     f.   …history (Table 3)",{"$f":"IF(hn<8,\"\",\"Enter >\")","v":"Enter >"},null,null,null,null,null,"     b.  P205 (lbs P2O5/unit)",null,{"$f":"IF(PPU=\"\",\"Enter >\",\"\")","v":"Enter >"},null,null,{"$f":"IF(unitm=1,\"lbs/ton\",IF(unitm=2,\"lbs/1000gal\",IF(unitm=3,\"lbs/acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     g.  …units (Table 5) ",{"$f":"IF(unitm=0,\"Enter >\",IF(unitm=4,\"Enter >\",\"\"))","v":"Enter >"},null,null,null,null,null,"                   Available P2O5",null,null,{"$f":"PPU*0.8","v":0},null,{"$f":"IF(unitm=1,\"lbs/ton\",IF(unitm=2,\"lbs/1000gal\",IF(unitm=3,\"lbs/acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     h.  Basis for calculations",{"$f":"IF(calcbase<3,\"\",\"Enter >\")","v":"Enter >"},null,null,null,null,null,"     c.  K2O (lbs K2O/unit)",null,{"$f":"IF(kku=\"\",\"Enter >\",\"\")","v":"Enter >"},null,null,{"$f":"IF(unitm=1,\"lbs/ton\",IF(unitm=2,\"lbs/1000gal\",IF(unitm=3,\"lbs/acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     i.   Yield unit",null,null,null,null,null,null,"                    Available K2O ",null,null,{"$f":"kku","v":0},null,{"$f":"IF(unitm=1,\"lbs/ton\",IF(unitm=2,\"lbs/1000gal\",IF(unitm=3,\"lbs/acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null," ","     j.   Estimated yield per acre",null,{"$f":"IF(calcbase=2,IF(workyield=\"\",\"Enter >\",\"\"),\"\")","v":""},null,null,{"$f":"IF(calcbase=2,rate,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"7.  Application Rate to Supply Priority Nutrient"]
[null,null," 2.  Fertilizer Recom. or Crop Removal",null,null,{"$f":"IF(allcheck0=0,\"Fertilizer Recom.\",IF(npkcheck=0,\"Both\",IF(calcbase=3,\"\",IF(calcbase=2,\"Crop Removal\",IF(calcbase=1,\"Fertilizer Recom.\",0)))))","v":"Fertilizer Recom."}]
[null,null,"     a.  Nitrogen",null,{"$f":"IF(calcbase=2,\"\",IF(WORKNUP=\"\",\"Enter >\",\"\"))","v":"Enter >"},null,null,"lbs/A",null,"     a.  Priority Nutrient"]
[null,null,"     b.  Phosphorus (P2O5)",null,{"$f":"IF(calcbase=2,\"\",IF(WORKPUP=\"\",\"Enter >\",\"\"))","v":"Enter >"},null,null,"lbs/A",null,"     b.  Priority Nutrient Needed",null,null,{"$f":"IF(PriNut=1,N,IF(PriNut=2,P,IF(PriNut=3,K)))","v":0},null,"lbs/A"]
[null,null,"     c.  Potassium (K2O)",null,{"$f":"IF(calcbase=2,\"\",IF(WORKKUP=\"\",\"Enter >\",\"\"))","v":"Enter >"},null,null,"lbs/A",null,"         …....Available in Manure",null,null,{"$f":"IF(PriNut=1,AvN,IF(PriNut=2,AvP,IF(PriNut=3,AvK)))","v":0},null,{"$f":"IF(unitm=1,\"lbs/ton\",IF(unitm=2,\"lbs/1000gal\",IF(unitm=3,\"lbs/acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,"     c.  Manure Application Rate",null,null,{"$f":"PriN/AvPri","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(unitm=1,\"tons/A\",IF(unitm=2,\"1000gal/A\",IF(unitm=3,\"acre-inch/A\",IF(unitm=0,\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,"          (units/A)",null,null,{"$f":"IF(AvPri=0,\"\",IF(MN=PriN/AvPri,\"     calculated value\",\"        entered value\"))","v":""}]
[null,null," 3.  Fertilizer Already Applied",null,null,null,null,null,null,"     d. Total Manure Applied (units)",null,null,{"$f":"IF(fieldacres=0,\"\",fieldacres*manureneeded)","v":""},null,{"$f":"IF(unitm=1,\"tons\",IF(unitm=2,\"1000gal\",IF(unitm=3,\"acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     a.  N",null,{"$f":"IF(XX=\"\",\"Enter >\",\"\")","v":"Enter >"},null,null,"lbs/A"]
[null,null,"     b.  P2O5",null,{"$f":"IF(YY=\"\",\"Enter >\",\"\")","v":"Enter >"},null,null,"lbs/A",null,"8.  Nutrients Supplied by Manure"]
[null,null,"     c.  K2O",null,{"$f":"IF(ZZ=\"\",\"Enter >\",\"\")","v":"Enter >"},null,null,"lbs/A",null,"     a.  N (7c x 6a)",null,null,{"$f":"AN*MN","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,null,null,null,null,null,null,null,"     b.  P2O5 (7c x 6b)",null,null,{"$f":"MN*AP","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null," 4.  Residual N from Manure",null,null,null,null,null,null,"     c.  K2O (7c x 6c)",null,null,{"$f":"MN*KPU","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,"     a. Amount applied/acre last year ",null,{"$f":"IF(hn=7,\"\",IF(hn=8,\"\",IF(MLY=\"\",\"Enter >\",\"\")))","v":"Enter >"},null,null,{"$f":"IF(unitm=1,\"tons/A\",IF(unitm=2,\"1000 gal/A\",IF(unitm=3,\"acre-inch/A\",IF(unitm=0,\"\"))))","v":""}]
[null,null,"     b. lbs N/unit ",null,{"$f":"IF(hn=7,\"\",IF(hn=8,\"\",IF(lbsN=\"\",\"Enter >\",\"\")))","v":"Enter >"},null,null,{"$f":"IF(unitm=1,\"lbs N/ton\",IF(unitm=2,\"lbs N/1000gal\",IF(unitm=3,\"lbs N/acre-inch\",IF(unitm=0,\"\"))))","v":""},null,"9.  Nutrient Balance"]
[null,null,"     c. availability coefficient (Table 3)",null,{"$f":"IF(hn=7,\"\",IF(hn=8,\"\",IF(avC=\"\",\"Enter >\",\"\")))","v":"Enter >"},null,null,null,null,"     (-) indicates need; (+) indicates excess"]
[null,null,"     d.                        Available N(lbs/unit)     ",null,null,{"$f":"IF(MLY=0,0,MLY*lbsN*avC)","v":0},null,{"$f":"IF(unitm=1,\"lbs N/A\",IF(unitm=2,\"lbs N/A\",IF(unitm=3,\"lbs N/A\",IF(unitm=0,\"\"))))","v":""},null,"     a.  N (8a - 5a)",null,{"$f":"IF(ROUND(adtN,0)=0,\"\",IF(adtN>0,\"excess\",\"need\"))","v":{"$error":"#DIV/0!"}},{"$f":"NS-N","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,null,null,null,null,null,null,null,"     b.  P2O5 (8b - 5b)",null,{"$f":"IF(ROUND(adtP,0)=0,\"\",IF(adtP>0,\"excess\",\"need\"))","v":{"$error":"#DIV/0!"}},{"$f":"PS-P","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null," 5.  Net Nutrient Needs",null,null,null,null,null,null,"     c.  K2O (8c - 5c)",null,{"$f":"IF(ROUND(adtK,0)=0,\"\",IF(adtK>0,\"excess\",\"need\"))","v":{"$error":"#DIV/0!"}},{"$f":"KS-K","v":{"$error":"#DIV/0!"}},null,"lbs/A"]
[null,null,"     a.  N (2a - 3a - 4d)",null,null,{"$f":"X-XX-RN","v":0},null,"lbs/A"]
[null,null,"     b.  P2O5 (2b - 3b)",null,null,{"$f":"Y-YY","v":0},null,"lbs/A"]
[null,null,"     c.  K2O (2c - 3c)",null,null,{"$f":"Z-ZZ","v":0},null,"lbs/A"]

{"sheet":"Report","index":10,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["frank"]
[]
[]
[null,null,null,null,null,null,null,null,"              Manure Application Report Form",null,null,null,null,{"$f":"TODAY()","v":"2021-03-10"}]
[]
[]
[]
[null,null,null,"County",null,null,null,{"$f":"IF(report_county=\"\",\"# #                           <Enter\",\"\")","v":"# #                           <Enter"},null,"Manure type",null,null,{"$f":"report_mantype","v":0}]
[null,null,null,"Name",null,null,null,{"$f":"IF(report_name=\"\",\"# #                           <Enter\",\"\")","v":"# #                           <Enter"},null,"Manure management",null,null,{"$f":"report_manmanage","v":0}]
[null,null,null,"Address",null,null,null,{"$f":"IF(report_address1=\"\",\"# #                           <Enter\",\"\")","v":"# #                           <Enter"},null,"Manure history",null,null,{"$f":"report_manhist","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(report_address2=\"\",\"# #                           <Enter\",\"\")","v":"# #                           <Enter"},null,{"$f":"IF(report_manhist=\"none\",\"\",\"     Residual N=\")","v":"     Residual N="},null,null,{"$f":"IF(RN=0,\"\",RN)","v":""},{"$f":"IF(RN=0,\"\",rnunits)","v":""}]
[null,null,null,null,null,null,null,null,null,"Basis for calculation",null,null,{"$f":"report_calc","v":"Fertilizer Recommendation"}]
[null,null,null,"Field ID",{"$f":"fieldID","v":0},null,null,null,null,{"$f":"IF(calcbase=2,\"Estimated yield\",\"\")","v":""},null,null,{"$f":"IF(calcbase=2,workyield,\"\")","v":""},{"$f":"qq","v":""}]
[null,null,null,"Field acres",{"$f":"fieldacres","v":0}]
[null,null,null,"Crop grown",{"$f":"report_crop","v":0},null,null,null,null,{"$f":"IF(status=\"        entered value\",\"\",\"Priority Nutrient\")","v":"Priority Nutrient"},null,null,{"$f":"IF(status=\"        entered value\",\"\",report_prinut)","v":"Potassium"}]
[]
[]
[null,null,null,null,null,"Manure Application Rate =",null,null,null,null,{"$f":"IF(unitm=3,ROUND(MN,1),ROUND(MN,1))","v":{"$error":"#DIV/0!"}},{"$f":"IF(unitm=1,\"tons\",IF(unitm=2,\"1000gal\",IF(unitm=3,\"acre-inch\",IF(unitm=0,\"\"))))","v":""},"/acre"]
[null,null,null,null,null,"Total manure applied =",null,null,null,null,{"$f":"ROUND(totalmanure,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(unitm=1,\"tons\",IF(unitm=2,\"1000gal\",IF(unitm=3,\"acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[]
[]
[null,null,null,"Available Nutrients Supplied",null,null,null,null,null,null,"Nutrient Balance"]
[null,null,null,"by Manure (lbs/acre)"]
[null,null,null,"    Nitrogen (N)",null,null,{"$f":"ROUND(NS,-1)","v":{"$error":"#DIV/0!"}},null,null,null," Nitrogen (N)",null,null,{"$f":"IF(ROUND(adtN,-1)=0,\"balanced\",IF(adtN>0,\"excess of \"&ROUND(adtN,-1)&\" lbs/A\"&\" added\",\"need \"&-ROUND(adtN,-1)&\" lbs/A more\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"    Phosphate (P2O5)",null,null,{"$f":"ROUND(PS,-1)","v":{"$error":"#DIV/0!"}},null,null,null," Phosphate (P2O5)",null,null,{"$f":"IF(ROUND(adtP,-1)=0,\"balanced\",IF(adtP>0,\"excess of \"&ROUND(adtP,-1)&\" lbs/A\"&\" added\",\"need \"&-ROUND(adtP,-1)&\" lbs/A more\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"    Potash (K2O)",null,null,{"$f":"ROUND(KS,-1)","v":{"$error":"#DIV/0!"}},null,null,null," Potash (K2O)",null,null,{"$f":"IF(ROUND(adtK,-1)=0,\"balanced\",IF(adtK>0,\"excess of \"&ROUND(adtK,-1)&\" lbs/A\"&\" added\",\"need \"&-ROUND(adtK,-1)&\" lbs/A more\"))","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"Notes:"]
[]
[null,null,null,{"$f":"IF(tobmess1=1,IF(tobmess2=1,tobacco_message1,\"\"),\"\")","v":""}]
[null,null,null,{"$f":"IF(tobmess1=1,IF(tobmess2=1,tobacco_message2,\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Report by:"]

{"sheet":"TableReport","index":11,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"  Manure Application Report for Multiple Fields",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-03-10"}]
[]
[]
[]
[null,null,null,null,null,"County",null,null,{"$f":"IF(table_county=\"\",\"# #                                      <Enter\",\"\")","v":"# #                                      <Enter"},null,null,"Address",null,null,null,null,{"$f":"IF(table_address1=\"\",\"# #                                     <Enter\",\"\")","v":"# #                                     <Enter"}]
[null,null,null,null,null,"Name",null,null,{"$f":"IF(table_name=\"\",\"# #                                      <Enter\",\"\")","v":"# #                                      <Enter"},null,null,null,null,null,null,null,{"$f":"IF(table_address2=\"\",\"# #                                     <Enter\",\"\")","v":"# #                                     <Enter"}]
[]
[null,null,null,null,null,"Manure Type="]
[null,null,null,null,null,{"$f":"IF(toggleClearmantype=1,\"You can't change manure type on this report until you clear all data\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(toggleMantype=1,\"Data can't be entered. Manure type chosen here is not what is on worksheet.\",\"\")","v":""},null,null,null,null,null,null,null,null,"Manure","Total","   Nutrients Applied (lbs/acre)",null,null,null,"   Nutrient Balance (lbs/acre)"]
[null,{"$f":"IF(toggleClear=1,\"Are you sure you want to clear this report?\",\"\")","v":""},null,null,null,null,null,null,"  Manure",null,"Calculation","           Estimated",null,null,"Application","Manure",null,null,null,null,"     (-) = Need, (+) = Excess"]
[null,null,null,null,null,"Field","Acres","Crop"," Residual N",null,"Basis","           Yield",null,null,"Rate","Applied","N","P2O5","K2O",null,"N","P2O5","K2O"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(totalacressum)","v":0},"= Total Acres",null,null,null,null,null,null,"Total Manure=",{"$f":"SUM(totalmanuresum)","v":0}]

{"sheet":"Table 1","index":12,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,"Table 1.  Nutrient Content of Manures Commonly Used in Kentucky*"]
[]
[null,null,null,null,null,null,"N","P2O5","K2O","Moisture"]
[null,null,null,"Solid Manures",null,null,null,"(lbs/ton)",null,"%"]
[]
[null,null,null,"Beef",null,null,11,7,10,80]
[null,null,null,"Dairy",null,null,11,9,12,80]
[null,null,null,"Swine",null,null,9,9,8,82]
[null,null,null,"Broiler","(fresh)",null,55,55,45,20]
[null,null,null,null,"(stockpiled)",null,40,80,35,20]
[null,null,null,null,"(cake)",null,60,70,40,30]
[null,null,null,null,"(pullet)",null,40,68,40,25]
[null,null,null,null,"(breeder)",null,35,55,30,40]
[null,null,null,"Layer",null,null,30,40,30,40]
[]
[null,null,null,"Liquid Manures",null,null,null,"(lbs/1000gal)"]
[]
[null,null,null,"Holding pit","Swine",null,36,27,22,96]
[null,null,null,null,"Dairy",null,31,15,19,94]
[]
[null,null,null,"Lagoon","Swine",null,4,2,4,99]
[null,null,null,null,"Dairy",null,4,2,3,98]
[]
[]
[null,null,null,"*All values on an \"as-is\" moisture basis."]

{"sheet":"Table 2","index":13,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Table 2.  Percent of Nurients from Manure Available to a   "]
[null,null,null,"Crop During the Year of Application in Comparison with  "]
[null,null,null,"Fertilizer Nutrients"]
[]
[]
[]
[null,null,null,"Nutrient","Crop",null,"Incorporation",null,"Availability Coefficient"]
[]
[null,null,null,"Nitrogen",null,null,null,null,"Poultry","  Other"]
[null,null,null,null,null,null,null,null,"or liquid","   Manures"]
[null,null,null,"Corn&Others: Corn, Tobacco,"]
[null,null,null,"Annual Grasses or Sorghum"]
[null,null,null,null,"Spring Applied",null,"2 days or less",null,0.6,0.5]
[null,null,null,null,null,null,"3-4 days",null,0.55000000000000004,0.45]
[null,null,null,null,null,null,"5-6 days",null,0.5,0.4]
[null,null,null,null,null,null,"7 days or more",null,0.45,0.35]
[null,null,null,null,"Fall Applied"]
[null,null,null,null,"  wo/Cover crop",null,null,null,0.15,0.2]
[null,null,null,null,"  w/Cover crop",null,null,null,0.5,0.4]
[null,null,null,"Small Grains (pre-plant)",null,null,null,null,0.5,0.4]
[null,null,null,"Pasture (Fall or Early Spring)",null,null,null,null,0.8,0.6]
[]
[null,null,null,"Phosphate (P2O5)",null,null,null,null,0.8,0.8]
[]
[null,null,null,"Potash (K2O)",null,null,null,null,1,1]

{"sheet":"Table 3","index":14,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,"Table 3.  Estimates of Available Nitrogen from Manure Applied Last Year*"]
[]
[]
[]
[null,null,null,"Frequency of Manure",null,null,null,null,"Manure Type"]
[null,null,null,"Applications"]
[null,null,null,null,null,null,"    Poultry or Liquids",null,null,"Other"]
[]
[null,null,null,null,null,null,null,null,"N availability coefficients**"]
[]
[null,null,null,"less than 4 out of ten years",null,null,null,0.03,null,0.05]
[]
[null,null,null,"4-8 out of ten years ",null,null,null,7.0000000000000007E-2,null,0.15]
[]
[null,null,null,"more than 8 out of ten years",null,null,null,0.12,null,0.25]
[]
[null,null,null,"*From D.B. Beegle, Penn State University."]
[null,null,null,"**Percentage of total nitrogen applied last year."]

{"sheet":"Table 4","index":15,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["table4"]
[]
[null,null,null,null,"Table 4.  Nutrient Removal Values for Selected Crops*"]
[]
[]
[null,null,null,null,null,null,"    Nutrients removed (lbs per yield unit)"]
[null,null,null,"Crop","Yield Unit","Lbs per yield unit","N","P2O5","K2O"]
[]
[null,null,null,"Alfalfa hay  /1","ton",2000,50,14,55]
[null,null,null,"All other hay (except Alfalfa)  /1","ton",2000,35,12,53]
[null,null,null,"Barley for grain  /1","bushel",48,0.9,0.41,0.3]
[null,null,null,"Corn for grain  /1","bushel",56,0.7,0.4,0.35]
[null,null,null,"Corn for silage or green chop  /1","ton",2000,7.5,3.6,8]
[null,null,null,"Forage from pastureland  /1","ton",2000,10.5,3.6,15.9]
[null,null,null,"Soybean for beans  /1","bushel",56,0.95,0.41,0.3]
[null,null,null,"Soybean for beans  /1","bushel",60,3,0.7,1.1000000000000001]
[null,null,null,"Tobacco, burley  /1","pound",1,7.0000000000000007E-2,1.0999999999999999E-2,7.4999999999999997E-2]
[null,null,null,"Tobacco, dark air-cured  /1","pound",1,7.0000000000000007E-2,6.0000000000000001E-3,0.06]
[null,null,null,"Tobacco, dark fire-cured  /1","pound",1,7.0000000000000007E-2,6.0000000000000001E-3,0.06]
[null,null,null,"Winter wheat for grain  /1","bushel",60,1.2,0.5,0.3]
[null,null,null,"Rye for grain  /2","bushel",56,1.1599999999999999,0.33,0.32]
[null,null,null,"Oats for grain  /2","bushel",32,0.62,0.25,0.19]
[null,null,null,"Barley for grain  /2","bushel",48,0.9,0.41,0.3]
[null,null,null,"Warm season native grass hay  /2","ton",2000,20,6.8,25]
[null,null,null,"Bermudagrass hay  /2","ton",2000,37.6,8.6999999999999993,33.6]
[null,null,null,"Reed canary grass hay  /2","ton",2000,27,8.1999999999999993,25]
[null,null,null,"Eastern gamagrass hay  /2","ton",2000,35,16.100000000000001,31.2]
[]
[null,null,null,"1   Taken from UK Extension publication IP56: \"Assessment of the Potential for Livestock"]
[null,null,null,"and Poultry Manure to Provide the Nutrients Removed by Crops and Forages in Kentucky\""]
[null,null,null,"2   Taken from Appendix A of NRCS Nutrient Management Standard (590), Appendix A."]

{"sheet":"Conversions","index":16,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"Conversions"]
[]
[]
[]
[null,null,null,"unit for solid manure = Ton"]
[null,null,null,"unit for liquid manure = 1000 gal or acre inch"]
[]
[null,null,null,"P (elemental phosphorus) x 2.27 = P2O5 (phosphate)"]
[null,null,null,"K (elemental potassium) x 1.2 = K2O (potash)"]
[]
[null,null,null,"percent (%) x 20 = pounds per ton"]
[null,null,null,"percent (%) x 80 = pounds per 1000 gallons"]
[null,null,null,"percent (%) x 2254 = pounds per acre-inch"]
[]
[null,null,null,"mg/L x 0.002 = pounds per ton"]
[null,null,null,"mg/L x 0.008 = pounds per 1000 gallons"]
[null,null,null,"mg/L x 0.225 = pounds per acre-inch"]
[]
[null,null,null,"pounds per ton x 4.17 = pounds per 1000 gallons"]
[null,null,null,"pounds per ton x 113 = pounds per acre-inch"]
[]
[null,null,null,"pounds per 1000 gallons x 0.24 = pounds per ton"]
[null,null,null,"pounds per 1000 gallons x 27.2 = pounds per acre-inch"]
[]
[null,null,null,"pounds per acre-inch x 0.037 = pounds per 1000 gallons"]
[null,null,null,"pounds per acre-inch x 0.0089 = pounds per ton"]
[]
[null,null,null,"1 gallon = 8.34 pounds"]
[null,null,null,"1 acre-inch = 27,200 gallons"]
[null,null,null,"mg/L = ppm"]
[]
[null,null,null,"1 acre = 43,560 square feet"]
[null,null,null,"1 cubic foot = 7.5 gallons"]

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

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

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

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

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

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

{"sheet":"ZZZ","index":23,"n_rows":48,"n_cols":34,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["IF FOR SOME REASON YOU ARE HERE, PLEASE LEAVE. ",null,null,null,null,null,null,"N","P2O5","K2O","N*Y","P*Y","K*Y",null,null,"N","P2O5","K2O",null,null,null,null,null,null,null,"PL","O",null,null,null,null,null,null,"HIS"]
["N","tons",null,"Fertilizer Recom.","Alfalfa hay",1,"ton",50,14,55,{"$f":"IF(workyield=\"not needed\",0,workyield*H2)","v":0},{"$f":"IF(workyield=\"not needed\",0,workyield*I2)","v":0},0,"Solid/Beef","Solid/Beef",11,7,10,null,null,null,null,"Corn&Others/Spring/<2d incorp.",null,null,0.6,0.5,null,null,null,"PoultryorLiquid/<4yrs out of 10",null,null,0.03]
["P2O5","1000 gal",null,"Crop Removal","Other hay (excluding Alfalfa or warm season grass)",2,"ton",35,12,53,{"$f":"IF(workyield=\"not needed\",0,workyield*H3)","v":0},0,0,"Solid/Dairy","Solid/Dairy",11,9,12,null,null,null,null,"Corn&Others/Spring/3-4d incorp.",null,null,0.55000000000000004,0.45,null,null,null,"PoultryorLiquid/4-8yrs out of 10",null,null,7.0000000000000007E-2]
["K2O","acre-inch","calc value",null,"Barley for grain",3,"bushel",0.9,0.41,0.3,{"$f":"IF(workyield=\"not needed\",0,workyield*H4)","v":0},0,0,"Solid/Swine","Solid/Swine",9,9,8,null,null,null,null,"Corn&Others/Spring/5-6d incorp.",null,null,0.5,0.4,null,null,null,"PoultryorLiquid/>8yrs out of 10",null,null,0.12]
[null,null,{"$f":"PriN/AvPri","v":{"$error":"#DIV/0!"}},null,"Corn for grain",4,"bushel",0.7,0.4,0.35,0,0,0,"Solid/Broiler/fresh","Solid/Broiler/fresh",55,55,45,null,null,null,null,"Corn&Others/Spring/>7d incorp.",null,null,0.45,0.35,null,null,null,"OtherManure/<4yrs out of 10",null,null,0.05]
[null,null,null,null,"Corn for silage or green chop",5,"ton",7.5,3.6,8,0,0,0,"Solid/Broiler/stockpiled","Solid/Broiler/stockpiled",40,80,35,null,null,null,null,"Corn&Others/Fall/woCover",null,null,0.15,0.2,null,null,null,"OtherManure/4-8yrs out of 10",null,null,0.15]
[3,4,null,3,"Forage from pastureland",6,"ton",10.5,3.6,15.9,0,0,0,"Solid/Broiler/cake","Solid/Broiler/cake",60,70,40,null,null,null,null,"Corn&Others/Fall/wCover",null,null,0.5,0.4,null,null,null,"OtherManure/>8yrs out of 10",null,null,0.25]
[null,null,null,null,"Sorghum for grain",7,"bushel",0.95,0.41,0.3,0,0,0,"Solid/Broiler/pullet","Solid/Broiler/pullet",40,68,40,null,null,null,null,"Small Grains(pre-plant)",null,null,0.5,0.4,null,null,null,"None",null,null,0]
[null,null,null,null,"Soybean for beans",8,"bushel",3,0.7,1.1000000000000001,0,0,0,"Solid/Broiler/breeder","Solid/Broiler/breeder",35,55,30,null,null,null,null,"Pasture(Fall or Early Spring)",null,null,0.8,0.6]
[null,"1000 gal",null,null,"Tobacco, burley",9,"pound",7.0000000000000007E-2,1.0999999999999999E-2,7.4999999999999997E-2,0,0,0,"Solid/PoultryLayer","Solid/PoultryLayer",30,40,30,null,null,null,null,"Other",null,null,"no data","no data"]
[null,"acre-inch",null,null,"Tobacco, dark air-cured",10,"pound",7.0000000000000007E-2,6.0000000000000001E-3,0.06,0,0,0,"Solid/General","Solid/General","no data","no data","no data","acre-inch"]
[null,null,null,null,"Tobacco, dark fire-cured",11,"pound",7.0000000000000007E-2,6.0000000000000001E-3,0.06,0,0,0,"Liquid/Swine/Holding pit","Liquid/Swine/Holding pit",36,27,22,{"$f":"P12*27.2","v":979.19999999999993},{"$f":"Q12*27.2","v":734.4},598.4]
[null,null,null,null,"Winter wheat for grain",12,"bushel",1.2,0.5,0.3,0,0,0,"Liquid/Dairy/Holding pit","Liquid/Dairy/Holding pit",31,15,19,{"$f":"P13*27.2","v":843.19999999999993},408,516.79999999999995]
[null,null,null,null,"Rye for grain",13,"bushel",1.1599999999999999,0.33,0.32,{"$f":"IF(workyield=\"not needed\",0,workyield*H14)","v":0},{"$f":"IF(workyield=\"not needed\",0,workyield*I14)","v":0},{"$f":"IF(workyield=\"not needed\",0,workyield*J14)","v":0},"Liquid/Swine/Lagoon","Liquid/Swine/Lagoon",4,2,4,{"$f":"P14*27.2","v":108.8},54.4,108.8]
[null,null,null,null,"Oats for grain",14,"bushel",0.62,0.25,0.19,0,0,0,"Liquid/Dairy/Lagoon","Liquid/Dairy/Lagoon",4,2,3,{"$f":"P15*27.2","v":108.8},54.4,81.599999999999994]
[null,null,null,null,"Barley for grain",15,"bushel",0.9,0.41,0.3,0,0,0,"Liquid/General","Liquid/General","no data","no data","no data",null,null,null,null,10,null,null,{"$f":"IF(mm=1,_pl1,IF(mm=2,_pl2,IF(mm=3,_pl3,IF(mm=4,_pl4,IF(mm=5,_pl5,IF(mm=6,_pl6,IF(mm=7,_pl7,IF(mm=8,_pl8,0))))))))","v":0},{"$f":"IF(mm=1,_ot1,IF(mm=2,_ot2,IF(mm=3,_ot3,IF(mm=4,_ot4,IF(mm=5,_ot5,IF(mm=6,_ot6,IF(mm=7,_ot7,IF(mm=8,_ot8,0))))))))","v":0},null,null,null,9,null,null,{"$f":"IF(hn=1,_his1,IF(hn=2,_his2,IF(hn=3,_his3,IF(hn=4,_his4,IF(hn=5,_his5,IF(hn=6,_his6,IF(hn=7,_his7,0)))))))","v":0}]
[null,{"$f":"IF(mantype>10.5,IF(unitz=1,0,IF(unitz=4,0,unitz)),unitz)","v":0},null,null,"Warm season native grass hay",16,"ton",20,6.8,25,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(mm=9,\"no data\",IF(mantype>3.5,plz,otz))","v":0}]
[null,null,null,null,"Bermudagrass hay",17,"ton",37.6,8.6999999999999993,33.6,0,0,0,1,16,{"$f":"IF(mantype=1,_nv1,IF(mantype=2,_nv2,IF(mantype=3,_nv3,IF(mantype=4,_nv4,IF(mantype=5,_nv5,IF(mantype=6,_nv6,IF(mantype=7,_nv7,0)))))))","v":0},{"$f":"IF(mantype=1,_pv1,IF(mantype=2,_pv2,IF(mantype=3,_pv3,IF(mantype=4,_pv4,IF(mantype=5,_pv5,IF(mantype=6,_pv6,IF(mantype=7,_pv7,0)))))))","v":0},{"$f":"IF(mantype=1,_kv1,IF(mantype=2,_kv2,IF(mantype=3,_kv3,IF(mantype=4,_kv4,IF(mantype=5,_kv5,IF(mantype=6,_kv6,IF(mantype=7,_kv7,0)))))))","v":0}]
[null,null,null,null,"Reed canary grass hay",18,"ton",27,8.1999999999999993,25,0,0,0,null,null,{"$f":"IF(mantype=8,_nv8,IF(mantype=9,_nv9,IF(mantype=11,_nv10,IF(mantype=12,_nv11,IF(mantype=13,_nv12,IF(mantype=14,_nv13,0))))))","v":0},{"$f":"IF(mantype=8,_pv8,IF(mantype=9,_pv9,IF(mantype=11,_pv10,IF(mantype=12,_pv11,IF(mantype=13,_pv12,IF(mantype=14,_pv13,0))))))","v":0},{"$f":"IF(mantype=8,_kv8,IF(mantype=9,_kv9,IF(mantype=11,_kv10,IF(mantype=12,_kv11,IF(mantype=13,_kv12,IF(mantype=14,_kv13,0))))))","v":0},{"$f":"IF(mantype=11,nvai10,IF(mantype=12,nvai11,IF(mantype=13,nvai12,IF(mantype=14,nvai13,0))))","v":0},{"$f":"IF(mantype=11,pvai10,IF(mantype=12,pvai11,IF(mantype=13,pvai12,IF(mantype=14,pvai13,0))))","v":0},{"$f":"IF(mantype=11,kvai10,IF(mantype=12,kvai11,IF(mantype=13,kvai12,IF(mantype=14,kvai13,0))))","v":0}]
[null,null,null,null,"Eastern gamagrass hay",19,"ton",35,16.100000000000001,31.2,0,0,0,null,null,{"$f":"IF(mantype=10,_nv15,IF(mantype=15,_nv16,0))","v":0},{"$f":"IF(mantype=10,_pv15,IF(mantype=15,_pv16,0))","v":0},{"$f":"IF(mantype=10,_kv15,IF(mantype=15,_kv16,0))","v":0}]
[null,null,null,null,"Other",20,null,null,null,null,null,null,null,null,null,{"$f":"IF(mantype<7.5,nq,IF(mantype=10,nz,IF(mantype=15,nz,IF(mantype=8,nw,IF(mantype=9,nw,IF(mantype>10,IF(unitz=2,nw,nwai),0))))))","v":0},{"$f":"IF(mantype<7.5,pq,IF(mantype=10,pz,IF(mantype=15,pz,IF(mantype=8,pw,IF(mantype=9,pw,IF(mantype>10,IF(unitz=2,pw,pwai),0))))))","v":0},{"$f":"IF(mantype<7.5,kq,IF(mantype=10,kz,IF(mantype=15,kz,IF(mantype=8,kw,IF(mantype=9,kw,IF(mantype>10,IF(unitz=2,kw,kwai),0))))))","v":0}]
[]
[null,null,null,null,21,null,null,null,null,null,null,null,null,null,null,{"$f":"NPU","v":0},{"$f":"PPU","v":0},{"$f":"KPU","v":0}]
[{"$f":"IF(PriNut=1,\"Nitrogen\",IF(PriNut=2,\"Phosphorus\",\"Potassium\"))","v":"Potassium"},null,null,{"$f":"IF(allcheck0=0,\"Fertilizer Recommendation\",IF(npkcheck=0,\"Fertilizer recom. & Crop removal\",IF(calcbase=1,\"Fertilizer Recommendation\",IF(calcbase=2,\"Crop Removal\",0))))","v":"Fertilizer Recommendation"},null,"crop 1 to 8","crop 9 to 14","crop 15 to 19",null,null,null,null,null,null,{"$f":"IF(mantype=1,\"Solid/Beef\",IF(mantype=2,\"Solid/Dairy\",IF(mantype=3,\"Solid/Swine\",IF(mantype=4,\"Solid/Broiler/fresh\",IF(mantype=5,\"Solid/Broiler/stockpiled\",IF(mantype=6,\"Solid/Broiler/cake\",IF(mantype=7,\"Solid/Broiler/pullet\",IF(mantype=8,\"Solid/Broiler/breeder\",0))))))))","v":0},{"$f":"IF(NPU=nval,1,0)","v":1},{"$f":"IF(PPU=pval,1,0)","v":1},{"$f":"IF(kku=kval,1,0)","v":1},null,null,null,null,{"$f":"IF(manmanage=1,\"CornAnnual/Spring/<2d incorp.\",IF(manmanage=2,\"CornAnnual/Spring/3-4d incorp.\",IF(manmanage=3,\"CornAnnual/Spring/5-6d incorp.\",IF(manmanage=4,\"CornAnnual/Spring/>7d incorp.\",IF(manmanage=5,\"CornAnnual/Fall/woCover\",IF(manmanage=6,\"CornAnnual/Fall/wCover\",IF(manmanage=7,\"Small Grains(pre-plant)\",IF(manmanage=8,\"Pasture(Fall or Early Spring)\",0))))))))","v":0},null,null,null,null,null,null,null,{"$f":"IF(hn=1,\"PoultryorLiquid/<4yrs out of 10\",IF(hn=2,\"PoultryorLiquid/4-8yrs out of 10.\",IF(hn=3,\"PoultryorLiquid/>8yrs out of 10\",IF(hn=4,\"OtherManure/<4yrs out of 10\",IF(hn=5,\"OtherManure/4-8yrs out of 10\",IF(hn=6,\"OtherManure/>8yrs out of 10\",IF(hn=7,\"None\",0)))))))","v":0}]
[null,null,null,null,{"$f":"IF(crop<8.5,unitx,IF(crop<14.5,unity,unitzz))","v":0},{"$f":"IF(crop<2.5,\"ton\",IF(crop=3,\"bushel\",IF(crop=4,\"bushel\",IF(crop=5,\"ton\",IF(crop=6,\"ton\",IF(crop=7,\"bushel\",IF(crop=8,\"bushel\",0)))))))","v":0},{"$f":"IF(crop=9,\"pound\",IF(crop=10,\"pound\",IF(crop=11,\"pound\",IF(crop=12,\"bushel\",IF(crop=13,\"bushel\",IF(crop=14,\"bushel\",0))))))","v":0},{"$f":"IF(crop=15,\"bushel\",IF(crop=16,\"ton\",IF(crop=17,\"ton\",IF(crop=18,\"ton\",IF(crop=19,\"ton\",0)))))","v":0},null,"crop 1 to 6",{"$f":"IF(crop=1,_NY1,IF(crop=2,_NY2,IF(crop=3,_NY3,IF(crop=4,_NY4,IF(crop=5,_NY5,IF(crop=6,_NY6,0))))))","v":0},{"$f":"IF(crop=1,_PY1,IF(crop=2,_PY2,IF(crop=3,_PY3,IF(crop=4,_PY4,IF(crop=5,_PY5,IF(crop=6,_PY6,0))))))","v":0},{"$f":"IF(crop=1,_KY1,IF(crop=2,_KY2,IF(crop=3,_KY3,IF(crop=4,_KY4,IF(crop=5,_KY5,IF(crop=6,_KY6,0))))))","v":0},null,{"$f":"IF(mantype=9,\"Solid/PoultryLayer\",IF(mantype=10,\"Solid/General\",IF(mantype=11,\"Liquid/Swine/holding pit\",IF(mantype=12,\"Liquid/Dairy/holding pit\",IF(mantype=13,\"Liquid/Swine/lagoon\",IF(mantype=14,\"Liquid/Dairy/lagoon\",0))))))","v":0}]
[null,null,null,null,{"$f":"IF(crop<8.5,ratex,IF(crop<14.5,ratey,ratezz))","v":0},{"$f":"IF(crop<2.5,\"tons/A\",IF(crop=3,\"bu/A\",IF(crop=4,\"bu/A\",IF(crop=5,\"tons/A\",IF(crop=6,\"tons/A\",IF(crop=7,\"bu/A\",IF(crop=8,\"bu/A\",0)))))))","v":0},{"$f":"IF(crop=9,\"lbs/A\",IF(crop=10,\"lbs/A\",IF(crop=11,\"lbs/A\",IF(crop=12,\"bu/A\",IF(crop=13,\"bu/A\",IF(crop=14,\"bu/A\",0))))))","v":0},{"$f":"IF(crop=15,\"bu/A\",IF(crop=16,\"tons/A\",IF(crop=17,\"tons/A\",IF(crop=18,\"tons/A\",IF(crop=19,\"tons/A\",0)))))","v":0},null,"crops 7 to 12",{"$f":"IF(crop=7,_NY7,IF(crop=8,_NY8,IF(crop=9,_NY9,IF(crop=10,_NY10,IF(crop=11,_NY11,IF(crop=12,_ny12,0))))))","v":0},{"$f":"IF(crop=7,_PY7,IF(crop=8,_PY8,IF(crop=9,_PY9,IF(crop=10,_PY10,IF(crop=11,_PY11,IF(crop=12,_PY12,0))))))","v":0},{"$f":"IF(crop=7,_KY7,IF(crop=8,_KY8,IF(crop=9,_KY9,IF(crop=10,_KY10,IF(crop=11,_KY11,IF(crop=12,_KY12,0))))))","v":0},null,null,null,null,{"$f":"IF(nind=0,0,IF(pind=0,0,IF(kind=0,0,1)))","v":1},"\"=table value IND"]
[null,null,null,null,{"$f":"IF(calcbase=1,\"not needed\",\"\")","v":""},null,null,null,null,"crop 13 to 19",{"$f":"IF(crop=13,_ny13,IF(crop=14,_ny14,IF(crop=15,_ny15,IF(crop=16,_ny16,IF(crop=17,_ny17,IF(crop=18,_ny18,IF(crop=19,_ny19,0)))))))","v":0},{"$f":"IF(crop=13,_py13,IF(crop=14,_py14,IF(crop=15,_py15,IF(crop=16,_py16,IF(crop=17,_py17,IF(crop=18,_py18,IF(crop=19,_py19,0)))))))","v":0},{"$f":"IF(crop=13,_ky13,IF(crop=14,_ky14,IF(crop=15,_ky15,IF(crop=16,_ky16,IF(crop=17,_ky17,IF(crop=18,_ky18,IF(crop=19,_ky19,0)))))))","v":0},null,{"$f":"IF(mantype<8.5,mnq,IF(mantype=15,\"Liquid/General\",mnz))","v":0},null,null,null,null,null,null,null,{"$f":"IF(manmanage=9,\"Miscellaneous\",mmz)","v":0}]
[null,null,null,null,{"$f":"IF(calcbase=1,\"not needed\",unit)","v":0},null,null,null,null,"value from above",{"$f":"IF(crop<6.1,NYF,IF(crop<12.1,NYS,nyt))","v":0},{"$f":"IF(crop<6.1,PYF,IF(crop<12.1,PYS,pyt))","v":0},{"$f":"IF(crop<6.1,KYF,IF(crop<12.1,KYS,kyt))","v":0},null,{"$f":"IF(mantype=4,1,IF(mantype=5,1,IF(mantype=6,1,IF(mantype=7,1,IF(mantype=8,1,IF(mantype=9,1,0))))))","v":0}]
[null,null,null,null,null,null,null,null,null,"if crop removal",{"$f":"IF(calcbase=2,nnz,\"\")","v":""},{"$f":"IF(calcbase=2,ppz,\"\")","v":""},{"$f":"IF(calcbase=2,kkz,\"\")","v":""}]
[]
[null,null,null,null,{"$f":"IF(crop=1,\"Alfalfa hay\",IF(crop=2,\"All other hay (except Alfalfa)\",IF(crop=3,\"Barley for grain\",IF(crop=4,\"Corn for grain\",IF(crop=5,\"Corn for silage or green chop\",IF(crop=6,\"Forage from pastureland\",IF(crop=7,\"Sorghum for grain\",IF(crop=8,\"Soybean for beans\",0))))))))","v":0},"crop 1 to 8",null,null,null,null,{"$f":"IF(nnz=0,0,IF(WORKNUP=nnz,1,0))","v":0},{"$f":"IF(ppz=0,0,IF(WORKPUP=ppz,1,0))","v":0},{"$f":"IF(kkz=0,0,IF(WORKKUP=kkz,1,0))","v":0}]
[null,null,null,null,{"$f":"IF(crop=9,\"Tobacco, burley\",IF(crop=10,\"Tobacco, dark air-cured\",IF(crop=11,\"Tobacco, dark fire-cured\",IF(crop=12,\"Winter wheat for grain\",IF(crop=13,\"Rye for Grain\",0)))))","v":0},"crop 9 to 13",null,null,null,null,{"$f":"IF(ncheck=0,0,IF(pcheck=0,0,IF(kcheck=0,0,1)))","v":0}]
[null,null,null,null,{"$f":"IF(crop=14,\"Oats for grain\",IF(crop=15,\"Barley for grain\",IF(crop=16,\"Warm season native grass\",IF(crop=17,\"Bermudagrass\",IF(crop=18,\"Reed cannarygrass hay\",IF(crop=19,\"Eastern gamagrass hay),if(crop=20,\"\"other\",0))))))","v":0},"crop 14 to 20",null,null,null,null,{"$f":"ncheck+pcheck+kcheck","v":0}]
[null,null,null,null,{"$f":"IF(crop<8.5,ca,IF(crop<13.5,cb,cc))","v":0}]
[null,null,null,null,{"$f":"IF(crop=9,1,IF(crop=10,1,IF(crop=11,1,0)))","v":0}]
[]
[null,null,null,null,"Tobacco message:"]
[null,null,null,null,"To avoid problems with excess chloride addition to tobacco fields, poultry litter "]
[null,null,null,null,"application should be restricted to 4 tons/acre."]
[]
[]
[]
[null,null,"dataEntered",0]
[null,null,"toggleMantype",0]
[null,null,"toggleClearmantype",0]
["Table Report",null,"toggleClear",0]
[null,null,{"$f":"IF(unitm=1,\"tons/A\",IF(unitm=2,\"1000gal/A\",IF(unitm=3,\"acre-inch/A\",IF(unitm=0,\"\"))))","v":""},{"$f":"IF(unitm=1,\"tons\",IF(unitm=2,\"1000gal\",IF(unitm=3,\"acre-inch\",IF(unitm=0,\"\"))))","v":""}]
[null,{"$f":"fieldID","v":0},{"$f":"fieldacres","v":0},{"$f":"report_crop","v":0},{"$f":"IF(RN=0,\"\",RN)","v":""},{"$f":"IF(RN=0,\"\",\"lbs/A\")","v":""},{"$f":"IF(report_calc=\"Fertilizer Recommendation\",\"Fert Recom\",\"Crop Rem\")","v":"Fert Recom"},{"$f":"IF(calcbase=2,workyield,\"\")","v":""},{"$f":"qq","v":""},{"$f":"report_prinut","v":"Potassium"},{"$f":"MN","v":{"$error":"#DIV/0!"}},{"$f":"totalmanure","v":""},{"$f":"AN*MN","v":{"$error":"#DIV/0!"}},{"$f":"MN*AP","v":{"$error":"#DIV/0!"}},{"$f":"MN*KPU","v":{"$error":"#DIV/0!"}},null,{"$f":"adtN","v":{"$error":"#DIV/0!"}},{"$f":"adtP","v":{"$error":"#DIV/0!"}},{"$f":"adtK","v":{"$error":"#DIV/0!"}}]

{"sheet":"versions","index":24,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["version #"]
[1,"original version created"]
[1.1000000000000001,"modifications:"]
[null,"1. Took out a lot of the rounding features.  Allow user to have values to the tenth decimal, rather than rounding."]
[null,"Still kept the balance of nutrients rounded to the tenth decimal"]
[null,"2.  Fixed it so balance would show even if rounded difference between needed and applied were 0."]
[null,"3.  Added warm season grasses and other small grains to crop removal table to mesh with NRCS 590 standard."]
[null,"4.  Nutrient values were not being auto retrieved for broiler breeder or poultry layer.  Fixed this."]
[null,"5.  Unit for winter wheat was coming up as pounds.  Changed to bushel."]
[null,"6.  Removed the do not distribute title."]
[null,"7.  Changed 43,600 ft2 to 43,560 ft2 in an acre in conversion table."]
[null,"8.  Changed uptake to removal in tutorial 2."]
[]
[1.2,"modifications"]
[null,"1. All the info from worksheet wasn't being transported to multiple table because of an error in data in zzz sheet."]
[null,"      Fixed this."]