{"action":"created","issue":{"url":"https://api.github.com/repos/CSTARS/farm-budgets-data/issues/28","labels_url":"https://api.github.com/repos/CSTARS/farm-budgets-data/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/CSTARS/farm-budgets-data/issues/28/comments","events_url":"https://api.github.com/repos/CSTARS/farm-budgets-data/issues/28/events","html_url":"https://github.com/CSTARS/farm-budgets-data/issues/28","id":81161156,"number":28,"title":"Poplar yield at the county level ","user":{"login":"blyeo","id":11095078,"avatar_url":"https://avatars.githubusercontent.com/u/11095078?v=3","gravatar_id":"","url":"https://api.github.com/users/blyeo","html_url":"https://github.com/blyeo","followers_url":"https://api.github.com/users/blyeo/followers","following_url":"https://api.github.com/users/blyeo/following{/other_user}","gists_url":"https://api.github.com/users/blyeo/gists{/gist_id}","starred_url":"https://api.github.com/users/blyeo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blyeo/subscriptions","organizations_url":"https://api.github.com/users/blyeo/orgs","repos_url":"https://api.github.com/users/blyeo/repos","events_url":"https://api.github.com/users/blyeo/events{/privacy}","received_events_url":"https://api.github.com/users/blyeo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"qjhart","id":344953,"avatar_url":"https://avatars.githubusercontent.com/u/344953?v=3","gravatar_id":"","url":"https://api.github.com/users/qjhart","html_url":"https://github.com/qjhart","followers_url":"https://api.github.com/users/qjhart/followers","following_url":"https://api.github.com/users/qjhart/following{/other_user}","gists_url":"https://api.github.com/users/qjhart/gists{/gist_id}","starred_url":"https://api.github.com/users/qjhart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qjhart/subscriptions","organizations_url":"https://api.github.com/users/qjhart/orgs","repos_url":"https://api.github.com/users/qjhart/repos","events_url":"https://api.github.com/users/qjhart/events{/privacy}","received_events_url":"https://api.github.com/users/qjhart/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-05-26T22:15:53Z","updated_at":"2015-05-27T21:52:45Z","closed_at":null,"body":"@qjhart @ncparker Quinn had sent the poplar yield by county last week and provided data with the following column headings:\r\n1) fips\r\n2) irrigated yield (what unit is this in?)\r\n3) nonirrigated yield (what unit is this in?)\r\n4) irrigation (cm/acre) \r\n\r\nI am comparing and contrasting it to the OLD poplar yield at the CMZ level we had and what we had to do with the data to get it into the form we need. \r\n\r\nIn the previous/old poplar yield and irrigation table we had in the CMZ level, we have the following data supplied by Quinn: \r\n1) [first 2 years of poplar biomass] irrigated_2 years\r\n2) irrigation_2yr (I am presuming these are the irrigation levels in cm/acre)?\r\n3) nonirrigation_2yr (I am presuming these are the irrigation levels in cm/acre)?\r\n4) [mature poplar biomss] irrigated \r\n5) [mature poplar biomass] irrigation (I am presuming these are irrigation levels in cm/acre)? \r\n6) [mature poplar biomass] nonirrigatiom (I am presuming these are nonirrigation levels in cm/acre)? \r\n\r\nWe then used the \"[first 2 years of poplar biomass] irrigated_2years\" and \"[mature poplar biomass] irrigated\" variables to calculate \"average annual yield (fresh ET/acre)\".  The \"average annual yield (fresh ET/acre)\" is the poplar yield that we included in the BCAM model. Should this also be the yield level we provide SWAP? If so, then when calculating the cost per acre, why are we only including the mature_yield and not also the [first 2 years of poplar biomass]. In other words, why aren't we applying \"average annual yield (Fresh ET/acre)\" in the formula below to calculate the variable poplar cost per acre? \r\n\r\nNathan says:\r\nCost per acre = $51.11/acre/year + ($15.28/BDT)*mature_yield\r\nwhere mature_yield is the yield in dry tons (US or English) per acre (column R in the Poplar _yield... spreadsheet you sent earlier in this email chain)\r\n\r\nI calculated the costs with labor separated from the Sustainability Metrics 1.0.xlsx.  The calculations are in the attached sheet. \r\n\r\nNon-machine labor: 2.53 hrs/acre/year\r\nMachine labor: 0.93 hrs/acre/year + (0.378 hrs/BDT)*mature_yield\r\nOther variable costs: $51.11/acre/year + ($15.28/BDT)*mature_yield\r\n\r\n    Prices, Ton /acre - This is a model parameter that is varied (AGREE)\r\n    Yield, Ton/acre - 3PG result from Quinn (AGREE--DONE)\r\n    Area (acres) - 0 or some small started value that is a calibration factor (AGREE)\r\n    cost of land rental ($/acre) - get it from the land cost of incumbent crops (***I need help here--see my e-mail to Quinn. But for now, I just went ahead and used state level land rent)\r\n    use of labor (hours/acre) - Calculate from info this morning (Non-machine labor: 2.53 hrs/acre/year and Machine labor: 0.93 hrs/acre/year + (0.378 hrs/BDT)*mature_yield) (DONE--See calculations in the Poplar Yield by State Excel sheet--already cut and pasted onto Mastersheet as well)\r\n    cost of labor ($/hour) - use the costs you developed for machine and non machine labor for other crop budgets (DONE)\r\n    applied water ( acre-ft per acre (ft)) - Did Steve answer this question (Yes--see below what he said and I've included these values in the Excel file)\r\n    all other variable costs ($/acre) - $51.11/acre/year + ($15.28/BDT)*mature_yield (See column AA in the poplar yield by state Excel file)\r\n    (DONE--See calculations in the Poplar Yield by State Excel sheet--already cut and pasted onto Mastersheet as well)\r\n    cost of water ($ per acre-ft) - use irrigation cost values Judy was working on (Same problem as land rental rate--but I went ahead and just used state level average irrigation cost)\r\n\r\n***7. applied water ( acre-ft per acre (ft)) - Did Steve answer this question (Yes--here is what he said and I've included these values in the Excel file)\r\n\r\nCalifornia--use almond trees as proxy for poplar trees\r\n\r\nWashington--use apple trees as proxy for poplar trees\r\n\r\nIdaho--use alfalfa hay irrigation levels\r\n\r\nMontana--use alfalfa hay irrigation levels\r\nOregon--use alfalfa hay irrigation levels"},"comment":{"url":"https://api.github.com/repos/CSTARS/farm-budgets-data/issues/comments/106088995","html_url":"https://github.com/CSTARS/farm-budgets-data/issues/28#issuecomment-106088995","issue_url":"https://api.github.com/repos/CSTARS/farm-budgets-data/issues/28","id":106088995,"user":{"login":"blyeo","id":11095078,"avatar_url":"https://avatars.githubusercontent.com/u/11095078?v=3","gravatar_id":"","url":"https://api.github.com/users/blyeo","html_url":"https://github.com/blyeo","followers_url":"https://api.github.com/users/blyeo/followers","following_url":"https://api.github.com/users/blyeo/following{/other_user}","gists_url":"https://api.github.com/users/blyeo/gists{/gist_id}","starred_url":"https://api.github.com/users/blyeo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blyeo/subscriptions","organizations_url":"https://api.github.com/users/blyeo/orgs","repos_url":"https://api.github.com/users/blyeo/repos","events_url":"https://api.github.com/users/blyeo/events{/privacy}","received_events_url":"https://api.github.com/users/blyeo/received_events","type":"User","site_admin":false},"created_at":"2015-05-27T21:52:45Z","updated_at":"2015-05-27T21:52:45Z","body":"@qjhart Could you please let us know what is the unit for all the poplar yield data you provided us last week? 1) fips\r\n2) irrigated yield (what unit is this in?)\r\n3) nonirrigated yield (what unit is this in?)\r\n4) irrigation (cm/acre) \r\n\r\n@ncparker asks: are the yields Quinn gave mature or avg annual yield and what units they are in? Does it take into account the [first 2 years of poplar biomass] irrigated_2 years? "}}