{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["SOIL SAMPLES DATA","Sheet1"],"not_rendered":{"images":2,"macros":1,"defined_names":18,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"SOIL SAMPLES DATA","index":0,"n_rows":88,"n_cols":32,"rows_kept":88,"merged":[[0,15,0,19],[5,0,5,15],[14,14,14,20],[15,14,15,20],[16,14,16,20],[17,14,17,20],[18,14,18,20],[19,14,19,20],[20,14,20,20],[21,14,21,20],[22,14,22,20],[29,13,29,24],[30,13,30,24],[31,13,31,24]]}
["Lawn Soil Fertility Tool",{"$nulls":14},"Created by www.TheComputerConnectors.com"]
["©2022, The Computer Connectors LLC.  All Rights Reserved"]
["Version: 20220126_a"]
[]
["How to use this tool…"]
["IMPORTANT:  When you opened this file, you were probably asked to \"Enable Content\" and \"Trust This Document.\"  Say YES to both.  Otherwise this tool will not work properly. \n     Additionally, many mobile devices (ex. iPad) don't fully support the macros and computer code used in this tool.  You will find it best to use this tool on a desktop computer."]
[]
["NOTE:  Certain sections within this tool are \"protected\" so that they cannot be accidentally broken.  If you need to print or copy any data, please first select and copy the data to a new file."]
["NOTE2:  If this is the first time you have downloaded this tool, the numbers you see in the first table below are examples of what you may find on a soil test.  You will replace those numbers with your own."]
[]
[1,"The first thing we are going to do is ask our local soil testing lab for some soil sample bags.  They are usually free - or very low cost."]
[null,"     A little known fact, soil testing is actually very easy and reasonably cheap."]
[null,"     Here in Sioux Falls, we have a lab called AgLab Express.  To find one in your area, just search the internet for \"soil testing lab.\""]
[null,"     The number of soil samples you submit depends upon the size of your lawn.  Three or four should get the job done for most average sized lawns."]
[2,"Now let's measure the lawn's approximate size.",{"$nulls":12},"7 STEPS TO A LIVABLE LAWN"]
[null,"     How many square/feet did you measure?",{"$nulls":3},4500,"sq/ft","=",{"$f":"F16/43560","v":{"v":0.10330578512396695,"d":"0.10"}},"acres","=",{"$f":"I16/COUNTIF(F62:F71,\">0\")","v":{"v":0.02066115702479339,"d":"0.021"}},"acres / sample",null,"https://www.delawarelivablelawns.org/7-steps-livable-lawn"]
[3,"The next thing we are going to do is identify a few areas within your lawn for soil testing.",{"$nulls":12},"Leave Grass Clippings On Your Lawn"]
[null,"     If you are like me, you kept a few of those utility marker flags from the last time you had them mark your utilities.",{"$nulls":12},"Include More Than One Grass Species"]
[null,"     Obviously, do NOT grab them until you are sure that they are no longer needed.",{"$nulls":12},"Test Your Soil"]
[4,"Now, walking around your lawn, use the flags to mark a few \"representative areas\" for both good and not-so-good areas.",{"$nulls":12},"Apply The Appropriate Amount of Fertilizer",{"$nulls":6},"==>","Did you know that most waterway contamination occurs downstream from large population areas?"]
[5,"     Good areas may be defined as \"green,\" \"healthy,\" \"weed free,\" etc.",{"$nulls":12},"Sweep Excess Fertilizer Off of Sidewalk And Driveway",{"$nulls":6},"==>","The Chicago area is thought to be the largest single contributor to the dead zone in the Gulf of Mexico where nothing can grow because of phosphorus."]
[null,"     Not-so-good areas would be - well - \"brown,\" \"diseased,\" \"weed infested,\" and just plain ugly",{"$nulls":12},"Fertilize In The Fall"]
[6,"Now, grab a shovel [or better yet, a soil sampling tool] and a bucket",{"$nulls":12},"Establish A No-Mow Buffer Around Waterways"]
[7,"At each of the areas you marked above, use your \"soil sampling tool\" to take a couple of samples around each flag."]
[null,"     Each of the soil samples should be a good representation of the soil profile from the surface to 6\" deep."]
[8,"Place the soil \"cores\" into the bucket and mix thorougly."]
[9,"Fill a sample bag to the level indicated on the bag (or in the instructions that came with the bags)."]
[null,"     IMPORTANT:  Make sure to label each bag so that you can later match your soil testing results with the originating soil location."]
[null,"Move on to your next flag (ie. Sample area) and repeat the sampling/bagging process."]
[10,"Put your shovel away, grab your sample bags, and head to the lab.",{"$nulls":11},"License Agreement"]
[null,"     If you use an out-of-town lab, just box up the sample bags and ship them to your lab.",{"$nulls":11},"By using this tool, you agree to be bound by our END USER LICENSE AGREEMENT."]
[null,"     IMPORTANT:  Each lab will have their own rules around labeling the shipment.  Make sure to follow your lab's guidance/requirements.",{"$nulls":11},"Please read that agreement at: https://www.thecomputerconnectors.com/terms-of-use-and-end-user-license-agreement.html"]
[11,"In a few days, you will receive your sample results."]
[null,"     You will see the nutrient levels in each of the submitted soil samples."]
[null,"     Nutrient levels will most likely include:  Nitrogen, Phosphorus, Potassium, pH, and possibly a few others."]
[null,"     Along with those nutrient results, your lab will probably give you fertilizer recommendations."]
[null,"     If your lab didn't give you recommendations, we will provide some guidance in the table below."]
[12,"Enter your lab results in the table below."]
[null,"     Don't worry if you don't have data for all of the columns.  We are primarily interested in N, P, K, and pH"]
["You are now ready to fertilize your lawn."]
[13,"To the best of your ability, purchase bags of fertilizer with N, P, and K contents that add up to exactly what you need."]
[null,"     Bags of fertilizer typically come with three numbers.  (Example: 10-10-10)"]
[null,"     The first number is usually Nitrogen.  The second is usually Phosphorus.  The third is usually Potassium."]
[null,"     (Example:  In a 50 pound bag of 10-10-10, there would be 5lbs of N, 5lbs of P, and 5lbs of K.)"]
[null,null,"https://www.youtube.com/watch?v=j41z5xueghU"]
[null,null,"Video quote: \"More is NOT necessarily better.\""]
[null,"     Enter the fertilizer bag Weight and N,P,K numbers:"]
[null,null,50,"lbs",10,10,10]
[null,"     Based on the numbers above, the fertilizer bag contains (lbs):"]
[null,null,{"$f":"$C$48*E48*0.01","v":{"v":5,"d":"5.00"}},"Nitrogen",{"$f":"$C$48*F48*0.01","v":{"v":5,"d":"5.00"}},"Phosphorus",{"$f":"$C$48*G48*0.01","v":{"v":5,"d":"5.00"}},"Potassium"]
[null,"     Now, refer to the bottom of the second table below for the total pounds of N, P, and K needed for your lawn."]
[]
[null,"     Don't be shocked if the numbers reveal that you don't need any P or K. "]
[null,"      A fall Nitrogen (N) application may be the only fertilizer you need. Especially if you don't remove your clippings."]
[null,"     As mentioned above, \"More is NOT necessarily better.\""]
[]
[14,"And finally, apply the appropriate amount of fertilizer to your lawn.  "]
[null,"     Use proportionally more where the soil tests say your lawn needs it. "]
[null,"     Use proportionally less where the soil tests say your lawn doesn't need it."]
[]
["SAMPLE ID/LOCATION","LATITUDE","LONGITUDE","Sample Depth","OM","P (1) (ppm)","P (2) (ppm)","K (ppm)","Mg","Ca","Na","pH","Buffer pH","H (meq)","CEC","K (%)","Mg (%)","Ca (%)","H (%)","Na (%)","N (ppm)","S","Zn","Mn","Fe","Cu","B","Soluable Salts","Cl","Mo","Bicarbonates ","Excess Lime"]
["Back Left Brown Spot",null,null,6,null,{"v":30,"d":"30.0"},null,{"v":267,"d":"267.0"},{"$nulls":3},6.8,{"$nulls":8},{"v":7,"d":"7.0"}]
["Back Mid Health Spot",null,null,6,null,{"v":10,"d":"10.0"},null,{"v":99,"d":"99.0"},{"$nulls":3},7.9,{"$nulls":8},{"v":7,"d":"7.0"}]
["Back Right Healthy Spot",null,null,6,null,{"v":22,"d":"22.0"},null,{"v":236,"d":"236.0"},{"$nulls":3},7.8,{"$nulls":8},{"v":8,"d":"8.0"}]
["Front Right Brown/Weedy Spot",null,null,6,null,{"v":102,"d":"102.0"},null,{"v":46,"d":"46.0"},{"$nulls":3},7.7,{"$nulls":8},{"v":7,"d":"7.0"}]
["Front Left Healthy Spot",null,null,6,null,{"v":80,"d":"80.0"},null,{"v":498,"d":"498.0"},{"$nulls":3},7.8,{"$nulls":8},{"v":8,"d":"8.0"}]
[]
[]
[]
[]
[]
[]
["RECOMMENDATIONS / REQUIREMENTS"]
["If provided, follow your lab's nutrient recommendations.  If not, we will try to provide you with some guidance (below) based upon details found at www.DelawareLivableLawns.org. "]
["[Save your money!   If in doubt, fertilize LESS to prevent waste water contamination.]"]
["SAMPLE ID/LOCATION",{"$nulls":4},"P\n(Est. LBS Required Per Area Sampled)",null,"K\n(Est. LBS Required Per Area Sampled)",{"$nulls":3},"pH",{"$nulls":8},"N (ppm)\n(Est. LBS Required Per Area Sampled)"]
[{"$f":"IF(A62<>\"\",A62,\"\")","v":"Back Left Brown Spot"},{"$nulls":4},{"$f":"IF(F62<>\"\",(80-F62)*2*$L$16,\"\")","v":{"v":2.066115702479339,"d":"2.07"}},null,{"$f":"IF(H62<>\"\",(120-H62)*2*$L$16,\"\")","v":{"v":-6.074380165289257,"d":"(6.07)"}},{"$nulls":3},{"$f":"IF(L62<>\"\",IF(OR(L62<6.2,L62>7),\"The pH level in this sample is out of optimal range.\",\"Ok\"),\"\")","v":"Ok"},{"$nulls":8},{"$f":"IF(U62<>\"\",3*$F$16/1000,\"\")","v":{"v":13.5,"d":"13.50"}}]
[{"$f":"IF(A63<>\"\",A63,\"\")","v":"Back Mid Health Spot"},{"$nulls":4},{"$f":"IF(F63<>\"\",(80-F63)*2*$L$16,\"\")","v":{"v":2.8925619834710745,"d":"2.89"}},null,{"$f":"IF(H63<>\"\",(120-H63)*2*$L$16,\"\")","v":{"v":0.8677685950413223,"d":"0.87"}},{"$nulls":3},{"$f":"IF(L63<>\"\",IF(OR(L63<6.2,L63>7),\"The pH level in this sample is out of optimal range.\",\"Ok\"),\"\")","v":"The pH level in this sample is out of optimal range."},{"$nulls":8},{"$f":"IF(U63<>\"\",3*$F$16/1000,\"\")","v":{"v":13.5,"d":"13.50"}}]
["Back Right Healthy Spot",{"$nulls":4},{"v":2.396694214876033,"d":"2.40"},null,{"v":-4.793388429752066,"d":"(4.79)"},{"$nulls":3},"The pH level in this sample is out of optimal range.",{"$nulls":8},{"v":13.5,"d":"13.50"}]
["Front Right Brown/Weedy Spot",{"$nulls":4},{"v":-0.9090909090909092,"d":"(0.91)"},null,{"v":3.0578512396694215,"d":"3.06"},{"$nulls":3},"The pH level in this sample is out of optimal range.",{"$nulls":8},{"v":13.5,"d":"13.50"}]
["Front Left Healthy Spot",{"$nulls":4},{"v":0,"d":"0.00"},null,{"v":-15.619834710743802,"d":"(15.62)"},{"$nulls":3},"The pH level in this sample is out of optimal range.",{"$nulls":8},{"v":13.5,"d":"13.50"}]
["",{"$nulls":4},"",null,"",{"$nulls":3},"",{"$nulls":8},""]
["",{"$nulls":4},"",null,"",{"$nulls":3},"",{"$nulls":8},""]
["",{"$nulls":4},"",null,"",{"$nulls":3},"",{"$nulls":8},""]
["",{"$nulls":4},"",null,"",{"$nulls":3},"",{"$nulls":8},""]
["",{"$nulls":4},"",null,"",{"$nulls":3},"",{"$nulls":8},""]
[{"$nulls":4},"TOTAL POUNDS (Entire lawn):",{"$f":"SUM(F77:F86)","v":{"v":6.446280991735537,"d":"6.4"}},null,{"$f":"SUM(H77:H86)","v":{"v":-22.56198347107438,"d":"(22.6)"}},{"$nulls":3},"If you pH level is not optimal, ",{"$nulls":7},"TOTAL POUNDS (Entire lawn):",{"$f":"SUM(U77:U86)","v":67.5}]
[{"$nulls":5},"Phosphorus",null,"Potassium",{"$nulls":3},"please contact your county extension office for advice.",{"$nulls":8},"Nitrogen"]

{"sheet":"Sheet1","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"hidden":true}
["RonL"]