| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |

Sidrat Flush
Life is Experience
1
|
Posted - 2012.02.16 20:21:00 -
[1] - Quote
Returns (Soon-ish).
This is primarily an Eve forum presence to announce updates and milestones reached in the continued saga of the Eve Industrial Organiser re-boot. A little history.
It all started when I really really wanted to know how many minerals it would take to build all the ammo types the corp was getting through each week. Asking that question led to a lot of paper based calculations and searches and there was absolutely nothing around that could or would calculate the amounts of two or more different items and in multiple runs with different ME levels etc. etc.
Anyway, I created a standalone Access version which produced a report based on the shopping list you entered. It was nasty but it did answer the question above.
Fast forward a few years and due to my absolute fear of coding anything more than 'Hello World' it turned in to an oversized excel inventory management tool spanning seven or eight work books mostly interconnected with each other.
Needless to say it was a pain to keep updated and remembering where and how things were stored was a pain. I rarely used it past it's release which says a lot about how disorganised it was. I believe it was trying to do too many things around a central inventory system, which was manually updated by the user. No one wants to keep track of even 8 different minerals on a fast moving production line where things get built and purchased on an hourly basis. I certainly couldn't be bothered so why should anyone else?
Back to the present - the need for the Eve Industrial Organiser has waned (if it ever existed beyond my self taught excel skills), with alliances and corporations using server fronted solutions all ticking away nicely. However I can't play Eve and NOT use an industrial tool of my own creation, but it will have to be sleeker, easier to maintain and fulfil the original question.
How much material do I need to achieve the monthly/weekly goal?
Does it really need to tell me the build price per unit? Should it tell me how much profit I could make if I sold the materials on the open market and purchased the same quantity of items anyway?
Answer to both, not really important. It's a game, if I make a profit so be it. If I lose out on an opportunity to make a profit and I don't know about it, did I actually miss out, or did I spend more time in game having fun?
Sometimes you can chase the figures around a spreadsheet and miss the important things such as call to arms, and interesting conversations about interesting topics.
While it would be nice possibly. The simplistic approach out of game - could lead to a more warm and fuzzy feeling in-game.
I hope to see you with a release very soon.
|

Sidrat Flush
Eve Industrial Corp
8
|
Posted - 2012.03.28 17:44:00 -
[2] - Quote
The workbook is being tidied up, the front page on the site has been updated.
I foresee a download being made available some time on Saturday, possibly sooner, although I would like to get some screen images and an overview (especially the market price import method).
Any questions don't hesitate to post. I thank you, on a side note it's the smoothest sheet every, I just hope the updated datadump doesn't break anything :p
Have fun and fly hard!
Sidrat |

Sidrat Flush
Eve Industrial Corp
8
|
Posted - 2012.03.29 07:22:00 -
[3] - Quote
You know how things are, now that it's done and in a usable state I just had to upload it at the earliest opportunity - well click the link below which will take you to the google site and the download link is on the left.
All feedback and donations appreciated.
|

D3F4ULT
Aliastra Gallente Federation
1
|
Posted - 2012.03.29 18:25:00 -
[4] - Quote
Sidrat Flush wrote:You know how things are, now that it's done and in a usable state I just had to upload it at the earliest opportunity - well click the link below which will take you to the google site and the download link is on the left.
All feedback and donations appreciated.
link? |

Sidrat Flush
Eve Industrial Corp
8
|
Posted - 2012.03.29 19:06:00 -
[5] - Quote
D3F4ULT wrote:Sidrat Flush wrote:You know how things are, now that it's done and in a usable state I just had to upload it at the earliest opportunity - well click the link below which will take you to the google site and the download link is on the left.
All feedback and donations appreciated.
link?
D'oh!! |

Revolution Rising
Gentlemen of Better Ilk
234
|
Posted - 2012.03.29 20:59:00 -
[6] - Quote
Openoffice? pls pls pls
CSM7 Skype Leak
|

Sidrat Flush
Eve Industrial Corp
8
|
Posted - 2012.03.29 21:00:00 -
[7] - Quote
Revolution Rising wrote:Openoffice? pls pls pls
Sorry it just don't have the power! |

D3F4ULT
Aliastra Gallente Federation
2
|
Posted - 2012.03.29 22:37:00 -
[8] - Quote
What are all the files I need to upload via EVEHQ xml?
Just the Marketeer right?
Which I grab from my roaming data that EVEHQ market uploads, but it gave me an error saying, "Some data was imported as text" |

Reileen Kawahara
Bio-Tech Research Luna Sanguinem
4
|
Posted - 2012.03.29 22:51:00 -
[9] - Quote
Instructions on how to use it would be good. |

D3F4ULT
Aliastra Gallente Federation
2
|
Posted - 2012.03.29 22:56:00 -
[10] - Quote
Reileen Kawahara wrote:Instructions on how to use it would be good.
Yeah, It' doesn't work without a database that you included with your original work to make this spreadsheet work. Which in that case, it's broken until you tell us how you created your database for the spreadsheet to work or provide yours. |

D3F4ULT
Aliastra Gallente Federation
2
|
Posted - 2012.03.30 00:08:00 -
[11] - Quote
I'm still testing it but the method you have for Converting to number is painfully slow.
I'm not 100% sure this will work, still trying it, but do this to convert to number.
DATA (tab) > Select Column > Text to Columns > Delimited > Uncheck all Delimiters > General data Format (Finish) > Right click Column > Format Cells > Number
So much faster, but as I said will come back if results were successful with this method ;) |

Sidrat Flush
Eve Industrial Corp
8
|
Posted - 2012.03.30 06:39:00 -
[12] - Quote
Thanks to Default for stepping up and covering my arse
A full Tutorial is on its way, I believe I hastened to upload it before it was documented. I can only apologise, admit I was too excited to get it out to the public, and work faster on the tutorial. In my haste to get the workbook out to the public arena, I left the pivot tables linked to the database. I didn't normally do this as it involves packing the database and a second download. It's not really necessary as any update to the datadump, usually means changing the layout to the spreadsheet. Why keep two files updated when it can be done once by me and you get the spreadsheet? I'm still debating on uploading the database, if you really want it, please mention it here along with positives that I am missing myself
To Do List
Increase font size in the navigation pane. (done
Links on the front page perhaps as navigation pane is barely visible
Complete Tutorial and remember that I understand column titles but not everyone will
Price sheet, Column formatting. - Wow, that's a much faster method thank you for that, I'll be updated the tutorial to do it that way instead of error checking method. Much appreciated
I've been told that it would go faster with a macro that minimizes the excel window then updates, and resets the window, but hey a macro in an eve tool. Hmm, probably not a popular move. Feel free to write it yourself though, this applies to the initial update fr
I appreciate the feedback it will be addressed during the course of the day
|

Sidrat Flush
Eve Industrial Corp
9
|
Posted - 2012.04.02 16:46:00 -
[13] - Quote
A bit later than expected a busier than usual weekend occurred.
As stated in the original post, the formulas have been fixed, please read the revision history on the Instructions Tab on the workbook.
|

Th0rII
Asgard Empire Wing
0
|
Posted - 2012.04.21 12:08:00 -
[14] - Quote
Has anybody used this in Open Office? And can possibly post any setup steps necessary with OO.
|

Sidrat Flush
EntroPrelatial Industria EntroPraetorian Aegis
11
|
Posted - 2012.04.21 15:51:00 -
[15] - Quote
It's not compatible with open office sorry. As stated before it doesn't have the same features (that I'm aware of anyway) that Excel has.
If OO has pivot tables and an import from access feature then it's pretty close but I haven't attempted to convert it.
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |