spreadsheet for prices

Hi all,

I started this spreadsheet, the prices aren't dead on and are capped by my level, but at least it's worked as a quick guide for me as I've moved up and spent a lot of time buying and selling. I'm not sure if there's something like this here already that I missed so sorry if there is.

The funny thing is the prices go up as you buy more, opposite of the real world. :) Let me me know if this is useful or lame or even already exists, it's open to editing, so feel free to do so.

https://docs.google.com/spreadsheet/...FE&usp=sharing

gc:gherkindil

i love it!i'm on my phone now so i can't edit but if you're interested we can so it via kik-i will send you the prices and all that is missing.you can send me a pm if you would like that :)
if not it would be nice for someone to do that pretty please ^^ :D

Quote:

---

Originally Posted by vali46

i love it!i'm on my phone now so i can't edit but if you're interested we can so it via kik-i will send you the prices and all that is missing.you can send me a pm if you would like that :)
if not it would be nice for someone to do that pretty please ^^ :D

---

It should be open for public editing. I haven't figured out the actual price ratios like I said, but it works a general guideline I hope?

It might be good to star items that sell fast or something like that too? Like I say this is just an initial pass and has helped me figure it all out.



gc: gherkindil

yes,but i can't edit it since i'm on my phone :( then i hope someone else will.

i don't have the need to star something that sells out fast since,in my experience,every product has it's customer :) but since i'm on a hunt for coins to buy 3 machines i love it.i do know all the max prices for every product (i'm addicted lol) but for those who don't and need coins this is a great thing :) i just wish someone will have the will to fill it up all the way with all the products and prices :)

Wow! That looks like a lot of work! Thanx for doing that for the community. :)

happy to. I couldn't keep all the prices in my head. :) And like I say it's a pretty naive attempt, but at least lets me know when I'm straying out into buying things at full price.

cheers,

gc: gherkindil

oh, btw, just add a description, the price and then select a row above or below from the second column. you should see a little blue box when you do. drag that down onto the new row and all the forumulas will be copied over. like i say it's not exact but pretty close.


gc: gherkindil

I've been updating your spreadsheet.

However, someone is also updating it at the same time. Only I am hard coding the prices and the other person is turning my prices into formulas.

If you use formulas in the spreadsheet, you may or may not get the same prices that are being displayed in the RSS. The numbers will be off by 1-2.

Quote:

---

Originally Posted by gherkindil

The funny thing is the prices go up as you buy more, opposite of the real world. :)

---

With this, you are just refering to the rounding errors on the prices, right? (For instance 1 Apple Jam = 219 gold, 10 Apple Jam = 2196 gold.)

Quote:

---

Originally Posted by alcibiades

With this, you are just refering to the rounding errors on the prices, right? (For instance 1 Apple Jam = 219 gold, 10 Apple Jam = 2196 gold.)

---

exactly, I'm just taking the one for base price and use the formulas to pump it out to 10 :) I started to look at corn and carrots as 7.2 rounded down and gave up, it's close enough for me. :)


cheers


gc:gherkindil