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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

CCP add spreadsheets to EVE
Author
Previous Topic Next Topic
Corvus Borealis
AUS-BadBadNotGood
#1 - 2012-07-04 06:07:02 UTC
We need ingame speadsheets like we have ingame browser!

There are many open source ones that you could use!
Mouse-Fitzgerald en Cedoulain
en Cedoulain Trade and Freight
#2 - 2012-07-04 06:23:44 UTC
Although I'm putting off using spreadsheets as long as I possibly can (everyone says you need them at some point), I totally agree. Then again, I realize they don't want to do everything for you - it's kind of like if you put in the effort to go do all that stuff off-client, then that's an advantage you're making for yourself.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-07-04 07:44:45 UTC
Spreadsheets bah.

/Real/ geeks use databases. Only time your data should hit a spreadsheet is /maybe/ for visualisation of an extract. And even then, there are better reporting packages available.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Lady Zarrina
New Eden Browncoats
#4 - 2012-07-04 13:23:38 UTC
Or Just use google spreadsheets in your IGB

EVE: All about Flying Frisky and Making Iskie
Lucy Ferrr
Sebiestor Tribe
Minmatar Republic
#5 - 2012-07-04 14:35:04 UTC
What the hell do people use spreadsheets for in Eve anyways? I don't get it. I always hear people call Eve spreadsheets in space, yet I've never used a spreadsheet for Eve. I do T2 manufacturer/invention, and I used to be a trader. There are programs specifically designed for anything a spreadsheet can do with much less work on the users end. What can a spreadsheet do that one of the 100s of 3rd party programs cannot?
Anubis Star
Federal Navy Academy
Gallente Federation
#6 - 2012-07-04 16:25:37 UTC
db + your own little programm is your friend
Fiat Money
EVE Sky Corp
#7 - 2012-07-04 16:46:49 UTC
What's the advantage of an ingame spreadsheet compared by the offline one?
Nikodiemus
Ganja Clade
Shadow Cartel
#8 - 2012-07-04 19:40:55 UTC
I would prefer if eve just allowed for simple in wallet summations or tabulations across a specified range with just a few simple options to view your transaction and market data better in game. I like my monster spreadsheet just fine and dont want to take the time to make a database or write my own program especially when I have at least 3 bookmarked that already can do that sort of thing for me for free. Why reinvent the wheel?
Wescro
Deep Core Mining Inc.
Caldari State
#9 - 2012-07-05 04:35:19 UTC
Fiat Money wrote:
What's the advantage of an ingame spreadsheet compared by the offline one?


Real time updating for things like price of an item. That would save me so much time. Right now I have to manually look up the price for everything in my spreadsheet and update it in excel. Self-updating entries based on market data would be awesome.

http://crossingzebras.com/2013/02/17/csm8ripardteg/
Dersk
Perkone
Caldari State
#10 - 2012-07-05 05:26:04 UTC  |  Edited by: Dersk
Lucy Ferrr wrote:
What the hell do people use spreadsheets for in Eve anyways? I don't get it. I always hear people call Eve spreadsheets in space, yet I've never used a spreadsheet for Eve. I do T2 manufacturer/invention, and I used to be a trader. There are programs specifically designed for anything a spreadsheet can do with much less work on the users end. What can a spreadsheet do that one of the 100s of 3rd party programs cannot?


I know that my first inclination to managing various parts of eve was to open a spreadsheet rather than search online for an app. I can't say that's the common reaction to eve's various activities, but with the prevalence of tables giving Eve a spreadsheet like interface (overview, skillsheet, market, inventory, log, S&I, etc) this seems to be a natural step.

Using some of the varied applications made for eve would be more efficient than the spreadsheet I have going. However, I've managed to teach myself a lot about some more advanced topics within excel that would have been meaningless to me otherwise. So, when someone refers to Eve as "spreadsheets in space", I think of it as an endearing term.
Lfod Shi
Lfod's Ratting and Salvage
#11 - 2012-07-05 11:28:36 UTC
Lucy Ferrr wrote:
What the hell do people use spreadsheets for in Eve anyways? I don't get it. I always hear people call Eve spreadsheets in space, yet I've never used a spreadsheet for Eve. I do T2 manufacturer/invention, and I used to be a trader. There are programs specifically designed for anything a spreadsheet can do with much less work on the users end. What can a spreadsheet do that one of the 100s of 3rd party programs cannot?


I don't know what the other software can do, but I've used spreadsheets to plan mining runs based on what I want to build at the time, mineral compression, and working out some other ideas that I think are far more clever than they turn out to be... mostly.

Best of all, Open Office is free and can be used for more than just Eve.

♪ They'll always be bloodclaws to me ♫
Fiat Money
EVE Sky Corp
#12 - 2012-07-05 12:17:34 UTC
Wescro wrote:
Fiat Money wrote:
What's the advantage of an ingame spreadsheet compared by the offline one?


Real time updating for things like price of an item. That would save me so much time. Right now I have to manually look up the price for everything in my spreadsheet and update it in excel. Self-updating entries based on market data would be awesome.


EVE has two options to (semi) automate:

1. use EVE API ( see http://wiki.eveonline.com/en/wiki/EVE_API_Functions)
Advantage: Full automated extraction of any character based data.
Disadvantage: No realtime data, cause you have to wait a certain timeframe to update again (1hour for orders etc.) so that's not an appropriate solution for fast traders etc.

2. Export Orders via Order tab ingame and import them via VBA in your spreadsheet
Advantage: Real time data of your orders
Disadvantage: Semi auttomated: You need to login and export, just orders only
Fiat Money
EVE Sky Corp
#13 - 2012-07-05 12:19:42 UTC
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#14 - 2012-07-05 17:42:10 UTC
Fiat Money wrote:
Just one example of a google doc with current PI prices based on API.

https://docs.google.com/spreadsheet/ccc?key=0Ar_YTOcXpvb9dGFIdHJlb0VmYXBORWRrcXFkeHNjcWc&hl=en_GB#gid=10



Not that that's from the /Eve/ API.

That's from eve-central. Which isn't from CCP. Blink

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Fiat Money
EVE Sky Corp
#15 - 2012-07-05 19:54:20 UTC
Steve Ronuken wrote:
Fiat Money wrote:
Just one example of a google doc with current PI prices based on API.

https://docs.google.com/spreadsheet/ccc?key=0Ar_YTOcXpvb9dGFIdHJlb0VmYXBORWRrcXFkeHNjcWc&hl=en_GB#gid=10



Not that that's from the /Eve/ API.

That's from eve-central. Which isn't from CCP. Blink


Sorry, mixed it up. True, that's the third option. Big smile
Corvus Borealis
AUS-BadBadNotGood
#16 - 2012-07-06 21:23:20 UTC
Fiat Money wrote:
What's the advantage of an ingame spreadsheet compared by the offline one?

When you log in from different locations, it would be very handy. Also those files aren´t really large, they can be hosted on server.
Corvus Borealis
AUS-BadBadNotGood
#17 - 2012-07-06 21:25:28 UTC
Lfod Shi wrote:

Best of all, Open Office is free and can be used for more than just Eve.

Libre Office Blink
Katriana Mosvani
Aliastra
Gallente Federation
#18 - 2012-07-06 21:31:45 UTC
Lady Zarrina wrote:
Or Just use google spreadsheets in your IGB


This one.