| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Mistress D'Malice
   |
Posted - 2005.06.13 19:45:00 -
[1]
Does anyone have an Excel sheet or something that will help calqulate POS fitting reqs for each type of module? Something that starts with the tower....then as you add silos it subracts fitting reqs and then tells you have much room you have left?
Something close at least I am sure if out there....I am Excel'd out after all the Tech2 Comps/reacions experiments I have done over the past 4-5 months. 
------------------------------------------------
Black Lotus Official Forums - www.blacklotusclan.com
Contact Me - [email protected] |
Fubar
|
Posted - 2005.06.13 19:59:00 -
[2]
Does this sheet, Eve-POS.xls 47KB, fit your needs?
|
Archangel Deck
|
Posted - 2005.06.15 07:43:00 -
[3]
Dude i think i may turn *** just for u, thanks a bunch this is REALLY helpful
|
Sollytear
|
Posted - 2005.06.15 11:58:00 -
[4]
simply uber, compared 2 mine.
U mind if i change this a bit where i add an extra row of feul. Its simply a row for a user creasted time, i.e. there is a cell for you to put the number of days in and it coems up with feul.
|
Fubar
|
Posted - 2005.06.15 17:12:00 -
[5]
Anyone can use my workbook anyway they want. Change it, add to it, use parts of it in your workbooks, I don't mind.
|
Vulkyn
|
Posted - 2005.06.18 08:40:00 -
[6]
 Originally by: Fubar
Anyone can use my workbook anyway they want. Change it, add to it, use parts of it in your workbooks, I don't mind.
Excellent sheet mate, i have a couple of good sheets myself i did earlier. if your intrested i have a good idea how to integrate both for some really good stuff! :D contact me online if you are intrested!
The Drone Master
|
Mistress D'Malice
|
Posted - 2005.06.19 21:24:00 -
[7]
GREAT SHEET!! Thank you!
Once thing, there isnt any option for a medium reactors that I can see... :?
------------------------------------------------
Black Lotus Official Forums - www.blacklotusclan.com
Contact Me - [email protected] |
Fubar
|
Posted - 2005.06.20 04:50:00 -
[8]
Originally by: Mistress D'Malice
GREAT SHEET!! Thank you!
Once thing, there isnt any option for a medium reactors that I can see... :?
The Medium Reactor Array is in the drop down list of modules. Maybe you just missed it?
Let me know if you can't find it and I will upload another version.
|
Vigilant
|
Posted - 2005.06.20 21:11:00 -
[9]
This worksheet alone makes me want to play  Nice job
|
Mistress D'Malice
|
Posted - 2005.06.21 00:36:00 -
[10]
You are correct Fubar...I just missed it. Your sheet is awesome!!! 
------------------------------------------------
Black Lotus Official Forums - www.blacklotusclan.com
Contact Me - [email protected] |
Nyphur
|
Posted - 2005.06.21 03:47:00 -
[11]
Oh man, excellent sheet! The only gripe I have with it is that Open Office doesn't have the dropdown menus. I have to type the words in manually.
|
Fubar
|
Posted - 2005.06.21 05:19:00 -
[12]
Originally by: Nyphur
Oh man, excellent sheet! The only gripe I have with it is that Open Office doesn't have the dropdown menus. I have to type the words in manually.
Give this sheet a try.
I didn't add any macros. I am not familiar enough with OpenOffice.org Calc to get rid of the macro prompt.
|
N1fty
|
Posted - 2005.06.21 05:36:00 -
[13]
Simply awesome Fubar, really clear and easy to use, unlike so many calculators out there [i make my own for most things, but this one suits me perfectly].
Have you done anymore spreadsheets? I could really do with s spreadsheet for moon minerals reactions all the way up to Making the T2 Components. Now THATS a big job :P
.................
"When i see a naked man chasing a woman down a dark alley with a butcher knife and a hard-on, i figure he's not out collecting for the red cross" |
Nyphur
|
Posted - 2005.06.21 05:56:00 -
[14]
Originally by: Fubar
Originally by: Nyphur
Oh man, excellent sheet! The only gripe I have with it is that Open Office doesn't have the dropdown menus. I have to type the words in manually.
Give this sheet a try.
I didn't add any macros. I am not familiar enough with OpenOffice.org Calc to get rid of the macro prompt.
*thumbs up* You are a wizard, Fubar. A god damn wizard. Thank you very much :).
|
Fubar
|
Posted - 2005.06.21 06:14:00 -
[15]
Originally by: N1fty
Simply awesome Fubar, really clear and easy to use, unlike so many calculators out there [i make my own for most things, but this one suits me perfectly].
Have you done anymore spreadsheets? I could really do with s spreadsheet for moon minerals reactions all the way up to Making the T2 Components. Now THATS a big job :P
I have been thinking about just THAT.
Combining the simple workbook I made public in this thread, combine a little from the workbook I use myself, and add the reactions to it.
The user would have to have the ability to add costs into the chain. I don't know what all the costs would be but I am sure people would come up with things I would have never thought of.
The workbook should have one sheet for each moon. The user should have the ability to select the moon minerals available at that moon, define the outputs of reactor arrays and mining arrays, define silo and coupling array storage. The user should also be able to define the reaction used in each reactor. A totals sheet(s) would be available to total costs and output from the moon sheets to give a total cost overview of the final output of the POS chain.
Tons to think about. Any thoughts?
|
Fubar
|
Posted - 2005.06.21 06:17:00 -
[16]
Originally by: Nyphur
EDIT: It doesn't work :/. I thought ti did. The dropdown menu appears but selecting things in it doesn't do anything.
I created the workbook in Open Office 1.1.3. I don't think the listboxes work in Open Office 1.0.x.
|
Nyphur
|
Posted - 2005.06.21 06:23:00 -
[17]
Originally by: Fubar
Originally by: Nyphur
EDIT: It doesn't work :/. I thought ti did. The dropdown menu appears but selecting things in it doesn't do anything.
I created the workbook in Open Office 1.1.3. I don't think the listboxes work in Open Office 1.0.x.
I'm using 1.1.0. I'll see if there's an upgrade I can get.
|
Nyphur
|
Posted - 2005.06.21 08:17:00 -
[18]
It's working now :).
Fubar, you are a wizard :)
|
Shadoc
|
Posted - 2005.06.21 21:08:00 -
[19]
You know what really really sucks about your sheet?!?!
it's better than mine :(
I have the simple pull down menu's using v-lookup's for the stations..then on a seperate column, all the pull down menus like what you have so that the stations are seperate..which is what i like about mine..but yours has all the fuel info.. i was going to add that next after the patch..but oh well...anyways, very nice.
|
InverseBlue
|
Posted - 2005.06.23 17:23:00 -
[20]
Edited by: InverseBlue on 23/06/2005 17:25:32
Edited by: InverseBlue on 23/06/2005 17:24:16
Edited by: InverseBlue on 23/06/2005 17:23:55
Originally by: Fubar
Does this sheet, Eve-POS.xls 47KB, fit your needs?
hey fubar nice sheet :) help alot with stuff , i dont even have to use my head now :) ,,, u ever thought of putting ur sheet live on some corps website or creating ur own website with all the eve xls sheets, just a idea for ya :) anyways very well done :)
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |