Tool Excel table for crops

Discussion in 'Mods' started by borsTiHD, Mar 5, 2016.

  1. borsTiHD

    borsTiHD Seal Broken

    Hi all,

    I made a quick and dirty excel table to see which crop is worth the most.
    I think there are still many errors and bugs contained, but I hope it helps someone.

    If anyone can help me to make it better I would be very happy. :3

    By the way... awesome game. :D

    With best regards.

    Preview:
    StardewValley_Crops_v04_screenshot.PNG

    €dit:
    Added v0.5

    - Strawberry fix
     

      Attached Files:

      Last edited: Mar 10, 2016
    • Khranos

      Khranos Scruffy Nerf-Herder

      Useful table! I've always been one to like knowing exactly what I'm working with.

      My only suggestion would be to add "cost" or something similar to the "per day" column. It took me a bit to realize what it meant, but otherwise, I see no issues or improvements.
       
      • dahavik

        dahavik Void-Bound Voyager

        Hey nice table. I did something similar with crops also but not on excel. How did you get your maximum harvest numbers?
         
        • borsTiHD

          borsTiHD Seal Broken

          Thanks for your reply. :)
          Maximum harvest numbers was a little tricky for me... the first way I tried is:
          - "days per month / days to grow = x"

          But with the regrow it was a little complicated.
          My formal now is:
          - "(days per month - days to grow) / regrow after x days + 1" and round down

          After I count with my hands (yes I did :D ) it fits for all.

          @Khranos: What exactly do you mean by costs? Or did you mean "per day" minus the seed price?
           
          • heartphilia

            heartphilia Subatomic Cosmonaut

            Oh good to have someone around who knows his maths! Thank you! I've been using a list I found on the internet, but they only had "profit" listed and I don't know how they actually calculated it.
             
            • AFKmuch

              AFKmuch Big Damn Hero

              There are some things that you have got wrong, like your total potential profit, as you only account for the value of 1 seed, also I feel like there are some errors with maximum harvests, as I calculated that strawberry's should be harvestable 6 times (according to the current wiki values anyway).

              Anyway, I threw together this spreadsheet too if anyone is interested...
              (Zip is the excel files, png is for people who just want an image)

              (Winter is broken as the wiki is empty for it)
               

                Attached Files:

              • borsTiHD

                borsTiHD Seal Broken

                Hm... did they change the regrow time?
                I thought it would be every 3 days for strawberry's.

                Thanks for helping. :nurunaughty:
                I will look into it tomorrow.
                 
                • bruvinito

                  bruvinito Void-Bound Voyager

                  Thanks a lot!
                   
                  • Zaggeh

                    Zaggeh Space Hobo

                    Thank you for sharing this.
                     
                    • KamiCrit

                      KamiCrit Void-Bound Voyager

                      I'd suggest porting this excel sheet over to Google Sheets. That way we can all view the table and keep up with the live edits rather than per-version distribution.

                      https://www.google.ca/sheets/about/
                       
                      • Eternalmyst

                        Eternalmyst Big Damn Hero

                        I love your sheet. Quick question, what does the Maximum Gross mean?
                         
                        • subedod

                          subedod Orbital Explorer

                        • borsTiHD

                          borsTiHD Seal Broken

                          Google Sheets are a perfect way.
                          I think you already got it @subedod?
                          Thanks for sharing. ;)

                          @Eternalmyst: Maximum harvest means how often you can harvest one type of crop per month on one field.
                          So this is theoretically the maximum you can get from a crop per month (some crops need to be seed again, some regrow by itself).
                           
                          • killerroy

                            killerroy Scruffy Nerf-Herder

                            Hey mates! Isn't the crops Profit per day wrong? Its missing the seed price in the calculation (i think) :p?
                            THX in advice. im searching for a good spreed sheet since I will request a "difficutly" Mod and I want to calculat how much it will need to Nerf crops income prices and such
                             

                            Share This Page