Grower Comparison Excel VB Macros contest

  • Status: Closed
  • Hadiah: $158
  • Penyertaan diterima: 8
  • Pemenang: xsanjayiitr

Ringkasan Peraduan

Excel Spreadsheet: Comparison of open field growing to hydroponic high tech glass greenhouse (HHTGG).
Based on an FDA study that produced the attached PDF “ROI Comparison different farming methods” we would like to have an Excel spreadsheet that models a tomato crop grown hydroponically in a high tech glass greenhouse (HHTGG) when an open field farmer enters information related to their open field farming operations. The input column will be “Open Field Farm” the resulting model will be “HHTGG”.
For example, if the open field farmer farms 120 acres, the comparison will return the quantity of acres required by the HHTGG to produce the same quantity of tomatoes and will base all other variables and returns on the quantity of tomatoes and area of the HHTGG.
The current study is in metric units (kg, sq m, hectares etc.) the excel spreadsheet must have the ability to allow the selection and entry of either US (lb, sq ft, acre, etc.) or metric measurements and will provide the model in the matching units (if the open field farmer selects “US” as a unit of measure, they must enter US and the model will be in U.S. units, if they select “Metric” the model will be in metric units). All unit labels will also change with the selection of U.S. or Metric. If the user selects the unit of measure after entering data the spreadsheet must issue a warning and ask if they would like to clear the form to start over or leave the values. Default setting will be US units.
The study compares several different growing environments. We are ONLY interested in modeling a HHTGG based on inputs from an open field farm.

We will also want VB Macros that create visually appealing representations of the comparison outcomes. This can come in the form of an additional tab in the spreadsheet or populate a webpage. The functionality and design should be complementary to the [login to view URL] website.

I have attached in image of the types of macros we would like created.


Files:
ROI Comparison different farming [login to view URL] - This is the data from the study, again disregard other types of growing.

Kemahiran Disyorkan

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • leoojeda
    leoojeda
    • 2 tahun yang lalu

    Hi, Please Check my entry #10 , I'll be for here, Greetings guys!! Good Luck.

    • 2 tahun yang lalu
  • xsanjayiitr
    xsanjayiitr
    • 2 tahun yang lalu

    Working on it.

    • 2 tahun yang lalu
  • nadimvicky
    nadimvicky
    • 2 tahun yang lalu

    Please check entry #8 . and let me know if this required correction.

    • 2 tahun yang lalu
  • monmohon
    monmohon
    • 2 tahun yang lalu

    working............

    • 2 tahun yang lalu
  • SeanPLyle
    Penganjur Peraduan
    • 2 tahun yang lalu

    Really looking for more of a robust excel spreadsheet with VB Macro outputs. Not a webpage. The Freelancer site won't allow me to change the name of the project.

    • 2 tahun yang lalu
  • reliefdesign
    reliefdesign
    • 2 tahun yang lalu

    I'm participating, will upload the Excel spreadsheet first in few hours, then the webpage with same functionality.

    • 2 tahun yang lalu
  • selfvictim
    selfvictim
    • 2 tahun yang lalu

    #increaseprize

    • 2 tahun yang lalu
  • abdullraahmaan
    abdullraahmaan
    • 2 tahun yang lalu

    if you are interested in , private message me

    • 2 tahun yang lalu
  • abdullraahmaan
    abdullraahmaan
    • 2 tahun yang lalu

    i can design the web page as you asked

    • 2 tahun yang lalu
  • deepbisht1611
    deepbisht1611
    • 2 tahun yang lalu

    Though I guess so, but just to be sure..Only Excel part (and not the webpage) wouldn't be considered for award..right?

    • 2 tahun yang lalu

Tunjukkan lebih banyak komen

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!