IF functions spread sheet
Jvaldez9
AEEC350Lab2-IFFunctions_Spring2024.xlsxShort Answer
| 1. What is an additional IF function that is equivalent to IF(X>300,44,23)? | ||
| 2. Suppose we want to assign a price based on a customers location: price = $30 if the customer's location is not "Texas" and price = $45 if the customer's location is Texas. Suppose the customer's location is provided in cell C1. Write two IF functions that would return the correct price. | ||
| 3. Are the IF functions IF(A1>=5,5,25) and IF(A1<5,25,5) equivalent? Why or why not? | ||
Projected 2018 PLC Rates
| PROJECTED 2018 PRICE LOSS (PLC) COVERAGE PAYMENT RATES | |||||||||
| (A) Commodity | (B) Marketing Year | (C) Unit | (D) Statutory Reference Price | (E) Projected 2018/2019 MYA Price | (F) 2018 National Loan Rate | (G) Projected 2018 Effective Price | (H) Projected 2018 PLC Payment Rate | (I) Maximum PLC Payment Rate | |
| Wheat | Jun. 1 - May 31 | Bushel | $5.50 | $5.20 | $2.94 | $2.56 | |||
| Barley | Jun. 1 - May 31 | Bushel | $4.95 | $4.60 | $1.95 | $3.00 | |||
| Oats | Jun. 1 - May 31 | Bushel | $2.40 | $2.65 | $1.39 | $1.01 | |||
| Peanuts | Aug. 1 - Jul. 31 | Bushel | $0.2675 | $0.2110 | $0.1775 | $0.0900 | |||
| Corn | Sep. 1 - Aug. 31 | Bushel | $3.70 | $3.60 | $1.95 | $1.75 | |||
| Grain Sorghum | Sep. 1 - Aug. 31 | Bushel | $3.95 | $3.20 | $1.95 | $2.00 | |||
| Soybeans | Sep. 1 - Aug. 31 | Bushel | $8.40 | $8.50 | $5.00 | $3.40 | |||
| Dry Peas | Jul. 1 - Jun. 30 | Pound | $0.1100 | $0.1050 | $0.0540 | $0.0560 | |||
| Lentils | Jul. 1 - Jun. 30 | Pound | $0.1997 | $0.1900 | $0.1128 | $0.0869 | |||
| Canola | Jul. 1 - Jun. 30 | Pound | $0.2015 | $0.1600 | $0.1009 | $0.1006 | |||
| Large Chickpeas | Sep. 1 - Aug. 31 | Pound | $0.2154 | $0.2100 | $0.1128 | $0.1026 | |||
| Small Chickpeas | Sep. 1 - Aug. 31 | Pound | $0.1904 | $0.2150 | $0.0743 | $0.1161 | |||
| Sunflower Seed | Sep. 1 - Aug. 31 | Pound | $0.2015 | $0.1725 | $0.1009 | $0.1006 | |||
| Flaxseed | Jul. 1 - Jun. 30 | Bushel | $11.2840 | $9.8500 | $5.6500 | $5.6340 | |||
| Mustard Seed | Sep. 1 - Aug. 31 | Pound | $0.2015 | $0.2860 | $0.1009 | $0.1006 | |||
| Rapeseed | Jul. 1 - Jun. 30 | Pound | $0.2015 | $0.1850 | $0.1009 | $0.1006 | |||
| Safflower | Sep. 1 - Aug. 31 | Pound | $0.2015 | $0.2030 | $0.1009 | $0.1006 | |||
| Crambe | Sep. 1 - Aug. 31 | Pound | $0.2015 | $0.2220 | $0.1009 | $0.1006 | |||
| Sesame Seed | Sep. 1 - Aug. 31 | Pound | $0.2015 | $0.3500 | $0.1009 | $0.1006 | |||
| Seed Cotton | Aug. 1 - Jul. 31 | Pound | $0.3670 | $0.3432 | $0.2500 | $0.1170 | |||
| Rice (long grain) | Aug. 1 - Jul. 31 | Pound | $0.1400 | $0.1070 | $0.0650 | $0.0750 | |||
| Rice (med/short grain) | Aug. 1 - Jul. 31 | Pound | $0.1400 | $0.1220 | $0.0650 | $0.0750 | |||
| Rice (temperate japonica) | Oct. 1 - Sep. 30 | Pound | $0.1610 | $0.1780 | $0.0650 | $0.0960 |
Crop Revenues
| Table 1. Projected Prices | ||||||||||||||
| Alfalfa | Corn | Cotton, Upland | Cotton, Cottonseed | Hay (Excluding Alfalfa) | Pecans | Peanuts | Peppers, Chile | Sorghum | Wheat | |||||
| Unit | tons/acre | bu/acre | lbs/acre | tons/acre | tons/acre | lbs/acre | lbs/acre | cwt/acre | bu/acre | bu/acre | ||||
| Price/Unit | $250.00 | $4.45 | $0.717 | $230.00 | $170.00 | $1.90 | $0.30 | $37.80 | $6.65 | $4.75 | ||||
| Table 2. Projected Revenues | ||||||||||||||
| Commodity | Acres | Yield | Revenues | |||||||||||
| Alfalfa | Corn | Cotton, Upland | Cotton, Cottonseed | Hay (Excluding Alfalfa) | Pecans | Peanuts | Peppers, Chile | Sorghum | Wheat | |||||
| 1 | ||||||||||||||
| 2 | ||||||||||||||
| 3 | ||||||||||||||
| 4 | ||||||||||||||
| 5 | ||||||||||||||
| 6 | ||||||||||||||
| 7 | ||||||||||||||
| 8 | ||||||||||||||
| 9 | ||||||||||||||
| 10 | ||||||||||||||
| 11 | ||||||||||||||
| AVERAGE REVENUE |
Net Farm Income
| 2017 Agricultural Census: Net Cash Farm Income of Operations, Arizona | State Summary NCFI Statistics | |||||
| State | County | NCFI | State: | |||
| Arizona | Apache | -$25,396,000 | Statistic | |||
| Arizona | Coconino | -$4,378,000 | Total | |||
| Arizona | Gila | -$748,000 | County-Average | |||
| Arizona | Mohave | $5,908,000 | Minimum | |||
| Arizona | Navajo | -$18,088,000 | Maximum | |||
| Arizona | Yavapai | -$7,933,000 | ||||
| Arizona | Cochise | $12,701,000 | ||||
| Arizona | Graham | $8,137,000 | ||||
| Arizona | Greenlee | $1,736,000 | ||||
| Arizona | Lapaz | $11,345,000 | ||||
| Arizona | Maricopa | $113,299,000 | ||||
| Arizona | Pima | $8,661,000 | ||||
| Arizona | Pinal | $97,827,000 | ||||
| Arizona | Santa Cruz | $62,000 | ||||
| Arizona | Yuma | $144,825,000 | ||||
| 2017 Agricultural Census: Net Cash Farm Income of Operations, New Mexico | ||||||
| State | County | NCFI | ||||
| New Mexico | Colfax | $12,332,000 | ||||
| New Mexico | Curry | $60,761,000 | ||||
| New Mexico | De Baca | (D) | ||||
| New Mexico | Guadalupe | $622,000 | ||||
| New Mexico | Harding | -$173,000 | ||||
| New Mexico | Mora | $6,479,000 | ||||
| New Mexico | Quay | $8,001,000 | ||||
| New Mexico | Roosevelt | $50,500,000 | ||||
| New Mexico | San Miguel | -$2,288,000 | ||||
| New Mexico | Torrance | $4,593,000 | ||||
| New Mexico | Union | $12,953,000 | ||||
| New Mexico | Bernalillo | -$4,776,000 | ||||
| New Mexico | Cibola | (D) | ||||
| New Mexico | Los Alamos | (D) | ||||
| New Mexico | Mckinley | -$11,722,000 | ||||
| New Mexico | Rio Arriba | $298,000 | ||||
| New Mexico | San Juan | -$2,566,000 | ||||
| New Mexico | Sandoval | -$517,000 | ||||
| New Mexico | Santa Fe | -$3,484,000 | ||||
| New Mexico | Taos | -$1,822,000 | ||||
| New Mexico | Valencia | -$4,782,000 | ||||
| New Mexico | Chaves | $55,666,000 | ||||
| New Mexico | Dona Ana | $81,075,000 | ||||
| New Mexico | Eddy | $20,699,000 | ||||
| New Mexico | Lea | $23,424,000 | ||||
| New Mexico | Lincoln | $284,000 | ||||
| New Mexico | Otero | $1,808,000 | ||||
| New Mexico | Catron | $1,044,000 | ||||
| New Mexico | Grant | $3,318,000 | ||||
| New Mexico | Hidalgo | $7,451,000 | ||||
| New Mexico | Luna | $11,900,000 | ||||
| New Mexico | Sierra | $645,000 | ||||
| New Mexico | Socorro | $7,282,000 | ||||
Points
| Worksheet | Component | Points Possible | Points Earned | |
| Short Answer | Question 1 | |||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| Question 2 | ||||
| logical_test 1 | 1.250 | 0.000 | ||
| value_if_true 1 | 1.250 | 0.000 | ||
| value_if_false 1 | 1.250 | 0.000 | ||
| logical_test 2 | 1.250 | 0.000 | ||
| value_if_true 2 | 1.250 | 0.000 | ||
| value_if_false 2 | 1.250 | 0.000 | ||
| Question 3 | 2.250 | 0.000 | ||
| Projected 2018 PLC Rates | Projected 2018 Effective Price | |||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| Projected 2018 PLC Payment Rate | ||||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| Crop Revenues | C10:C11 Drop-down lists | 2.250 | 0.000 | |
| Cell F10: | ||||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| Referencing | 1.250 | 0.000 | ||
| F10 replicated throughout | 2.250 | 0.000 | ||
| Average revenue calculation | 2.250 | 0.000 | ||
| Net Farm Income | G4 Drop-down list | 2.250 | 0.000 | |
| Total | ||||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| County-Average | ||||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| Minimum | ||||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| Maximum | ||||
| logical_test | 1.250 | 0.000 | ||
| value_if_true | 1.250 | 0.000 | ||
| value_if_false | 1.250 | 0.000 | ||
| TOTAL | TOTAL | 50.000 | 0.000 |
