These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Google Docs Ore Buy spreadsheet?
Author
Previous Topic Next Topic
Barlkin
Aliastra
Gallente Federation
#1 - 2013-04-07 07:02:07 UTC
Hey everyone,

First things first, I have no idea how to make this, thats why I'm here. My corp is thinking of implenting a Ore Buy program and I was thinking there is a way to set up a google spreadsheet to do this. Something that pulls the last price info update, takes like 15% off then has a box where you enter the quantity you have and it spits back a value?

ie:

Ore Price(-15%) Quantity Value
Veld 4isk 1000 4000


Something like that?

Any help is greatly appreciated!

Under new management
AzAkiR NaLDa
Council of Exiles
Brave Collective
#2 - 2013-04-07 07:38:52 UTC
I used to have a spreadsheet for it and I think I still have it laying around somewhere. Only downside is that it will become slow as you expand it. I eventually had 4 different spreadsheet to feed into the 1 main sheet. Now a days we upgraded to a web application.

I will dig up the spreadsheet for you.

Lone Star Warrior
Troy Aihaken
Quekz
#3 - 2013-04-07 09:35:30 UTC  |  Edited by: Troy Aihaken
Say the Latest Ore buy price is in B1, and the amount of ore you have is A1.
so

=(B1*0.85)*A1

This will take 15% off the buy price and then times it by how much ore you have. :)

I have some ORE spreadsheet that pull the latest market data from eve-marketdata

NodeJS Developer | Frontend Development | Programming Enthusiast
AzAkiR NaLDa
Council of Exiles
Brave Collective
#4 - 2013-04-07 13:33:01 UTC
there you go here is what used to be my old master spreadsheet

https://docs.google.com/spreadsheet/ccc?key=0AgVgBDF7ODQIdENtTkhnbGhyYTA3X3B6VTh5VDRfdFE#gid=0

Lone Star Warrior
Tonto Auri
Vhero' Multipurpose Corp
#5 - 2013-04-07 16:06:41 UTC
You need permission to access this item.

You are signed in as --- but you don't have permission to access this item. You can request access from the owner or choose a different account. Learn more

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Barlkin
Aliastra
Gallente Federation
#6 - 2013-04-07 17:08:34 UTC
AzAkiR NaLDa wrote:
there you go here is what used to be my old master spreadsheet

https://docs.google.com/spreadsheet/ccc?key=0AgVgBDF7ODQIdENtTkhnbGhyYTA3X3B6VTh5VDRfdFE#gid=0


says I don't have permissions so I requested it. Thanks for sharing it though!

Under new management
Barlkin
Aliastra
Gallente Federation
#7 - 2013-04-07 17:10:47 UTC
Troy Aihaken wrote:
Say the Latest Ore buy price is in B1, and the amount of ore you have is A1.
so

=(B1*0.85)*A1

This will take 15% off the buy price and then times it by how much ore you have. :)

I have some ORE spreadsheet that pull the latest market data from eve-marketdata



yes! That's exactly what I'm looking for! I was trying to use the importXml= but it kept yelling at me about the wrong number of arguments but I don't know what that means.

Under new management
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2013-04-07 17:36:04 UTC
It's not quite what you're asking for, but:
http://www.fuzzwork.co.uk/ore/

might be of interest.

At least to give you prices, with a percentage reduction. It's not based off ore pricing (which can be all out of whack) but off the constituent mineral prices.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Barlkin
Aliastra
Gallente Federation
#9 - 2013-04-07 18:09:24 UTC
So update,

For straight up veld this is what im using to import : =importXml("http://api.eve-central.com/api/marketstat?&typeid=1230") however it gives the error "to many argruments to import xml data)

Under new management
Troy Aihaken
Quekz
#10 - 2013-04-07 18:30:42 UTC
ORE MINERALS VS ORE
https://docs.google.com/spreadsheet/ccc?key=0ApjF-il4wvzwdFNzMVB6MzNEY2xzaDdNTUhwX3RDdkE&usp=sharing

NodeJS Developer | Frontend Development | Programming Enthusiast
Barlkin
Aliastra
Gallente Federation
#11 - 2013-04-07 19:47:39 UTC
Good News!

Got the xml import to work, now just gotta lock down certain cells so they cant be edited....any ideas for google spredsheet?

Under new management
Troy Aihaken
Quekz
#12 - 2013-04-07 20:13:59 UTC
Hope this helps

http://googledocs.blogspot.co.uk/2012/08/lock-down-cells-with-protected-ranges.html

NodeJS Developer | Frontend Development | Programming Enthusiast
AzAkiR NaLDa
Council of Exiles
Brave Collective
#13 - 2013-04-07 21:15:49 UTC
forgot that i locked the sheet after the corp moved over to the application instead of spreadsheet.

sharing made public now and the people who requested access have been granted access to it. hope it helps

Lone Star Warrior
Wingmate
Perkone
Caldari State
#14 - 2013-04-08 13:42:33 UTC
btw, barlkin, i make spreads for people in google docs by request. i might have what you want ready to go already. check out my thread for more info.

i make spreadsheets for pretty cheap. contact me for more info.

https://forums.eveonline.com/default.aspx?g=posts&t=197433
Mylock Miannapan
The StarDust Collective
#15 - 2013-04-12 22:09:39 UTC  |  Edited by: Mylock Miannapan
Hi,

I have made the spreadsheet that we have developed available for public viewing. I would download your own copy and play with it.

Originally it was developed just to work out how much to pay one or two corp miners for ore, and the prices were manually updated. Over time, I added the automatic pricing which is pretty accurate.

I am not responsible for most of the formulas, but I think the guy who did put it the amount we lose when we refine at our local null station. There is also an extra little section added so that i could buy pure minerals from other alliance members at 20% current Jita price.

That spreadsheet is not the prettiest as it does what we need it to and saves a hell of time and hassle, especially as we are now buying up to 5 bil m3 of ore a week.


oops, forgot the link: https://docs.google.com/spreadsheet/ccc?key=0ArPyYbBY15mIdEpRUS02OUl4Z3dxQ21ZNTFyM1JXVlE&usp=sharing
Hustomte
Veritex Industrial Inc.
#16 - 2013-04-14 06:36:44 UTC  |  Edited by: Hustomte
I put together a 15% off Jita Google spreadsheet for you.
This link is publicly view-able, but not editable (to prevent trolls). You however can go to File -> Make a Copy and save your own sheet and edit that one to your hearts content Big smile

https://docs.google.com/spreadsheet/ccc?key=0Al5uRKjDNbkddGpFd1RWWk1FUC0zS1ViSElZcTR3elE&usp=sharing

The main page just enters in the amount mined, it then checks the "math" sheet for prices that are automatically pulled from Eve-Central. It then takes the top percentage buy price (the fairest in my opinion) then reduces 15% off. This tallies on the main sheet and gives you a nice sum at the bottom.

A lot easier to look at, pleasant colors, simple, just works.
Let me know if you have any problems.

...Signature...