CSTARS / farm-budgets-app

Application for calculating farm budgets
1 stars 0 forks source link

Get a first stab at farm budgets. #1

Closed qjhart closed 9 years ago

qjhart commented 9 years ago

The farm budget app needs to have some data generated from some existing spreadsheets. Santiago's spreadsheet includes a number of these data. We need to simplify and standardize this spreadsheet. This can be done either by replicating and modifying, or someother manner, but we need sheets (or CSVs ) that are of the form:

State commodity item amount unit
CA alfalfa 11-52-0 75 lb
CA alfalfa Lorsban 4E 2 pint
CA alfalfa ... ... ...

You can see this could all go on a single sheet in the database.

We will also need to collect costs as well. That could be done either with the same table (with a new row), or since that's not normalized, with a second table, however, it's fine to normalize on in the dB after, so whichever is easiest.

State item cost unit
CA 11-52-0 $0.44 lb
CA Lorsban 4E $8.65 pint
CA ... ... ...

I

jrmerz commented 9 years ago

Do we need to protect the demo if I start adding sample data from this spreadsheet?

On Wed Oct 29 2014 at 5:02:00 PM Quinn Hart notifications@github.com wrote:

The farm budget app needs to have some data generated from some existing spreadsheets. Santiago's spreadsheet https://docs.google.com/spreadsheets/d/1FEcafJQj2sCzQ6vGxlLp-DAEB4p28mC_g37IVD5L4UU/edit#gid=385810702 includes a number of these data. We need to simplify and standardize this spreadsheet. This can be done either by replicating and modifying, or someother manner, but we need sheets (or CSVs ) that are of the form: State commodity item amount unit CA alfalfa 11-52-0 75 lb CA alfalfa Lorsban 4E 2 pint CA alfalfa ... ... ...

You can see this could all go on a single sheet in the database.

We will also need to collect costs as well. That could be done either with the same table (with a new row), or since that's not normalized, with a second table, however, it's fine to normalize on in the dB after, so whichever is easiest. State item cost unit CA 11-52-0 75 lb CA Lorsban 4E 2 pint CA ... ... ...

I

Reply to this email directly or view it on GitHub https://github.com/CSTARS/farm-budgets-app/issues/1.

qjhart commented 9 years ago

Yes, that's not and issue.

jrmerz commented 9 years ago

I split this out a little bit more, hoping to provide human-readable/editable csv files. Example file structure / csv structure: https://github.com/CSTARS/farm-budgets-data/blob/master/data/California/costs/default.csv and https://github.com/CSTARS/farm-budgets-data/blob/master/data/California/amounts/Alfalfa/default.csv.

Basically: