Pages: 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14 15 .. 15 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |

Shooter Mclean
|
Posted - 2004.06.02 06:38:00 -
[61]
Just downloaded this sheet to see what goes on. I feel it may help me understand the mechanics of the game a bit better.
Many thanks
If I have any ideas I will post them.
|

Lachenlaud
|
Posted - 2004.06.02 13:29:00 -
[62]
Originally by: Shooter Mclean Just downloaded this sheet to see what goes on. I feel it may help me understand the mechanics of the game a bit better.
Many thanks
If I have any ideas I will post them.
Cool deal! Hope it helps you out!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

ChernoChiel
|
Posted - 2004.06.04 11:24:00 -
[63]
v400 is even better :)
wicked stuff m8 thanx for all ur work on it!
but one thing, all these new versions make it a bit crappy to use the newest one... u gotta copy/pase all the Skill points into the next sheet...
but little effort for a great way to plan ur skills :)
___________________________ "what did that button do??"
|

number 258
|
Posted - 2004.06.06 12:30:00 -
[64]
 this is amazing!!! keep up the good work |

Lachenlaud
|
Posted - 2004.06.06 20:23:00 -
[65]
Originally by: ChernoChiel v400 is even better :)
wicked stuff m8 thanx for all ur work on it!
but one thing, all these new versions make it a bit crappy to use the newest one... u gotta copy/pase all the Skill points into the next sheet...
but little effort for a great way to plan ur skills :)
Once I get all the features to where I want them to be - it is very likely that i will turn it into an 'installable' program that you will simply have to update without cutting/pasting stuff. Thats a bit down the road though.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.06.06 20:24:00 -
[66]
Originally by: number 258
 this is amazing!!! keep up the good work
My thanks! And I shall!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Aloris Crow
|
Posted - 2004.06.06 23:32:00 -
[67]
This definitely deserves a sticky, Keep up the awesome work.
One thing I would change is the OreCalc sheet, It would be nice if it was a little more versatile for yield rates. Maybe allow the user to just add in the station efficiency and the cut the station takes to calculate the end yield. Also a price for buying and selling the ore, handy for those who aren't sure whether their ore will be worth more in a processed or unprocessed state.
Since I'm not in a corp, or be in a position to be producing equipment I can't comment on those sections, but I hope you stick at this, it shows a hell of a lot of promise.
|

Lachenlaud
|
Posted - 2004.06.08 14:43:00 -
[68]
Originally by: Aloris Crow This definitely deserves a sticky, Keep up the awesome work.
One thing I would change is the OreCalc sheet, It would be nice if it was a little more versatile for yield rates. Maybe allow the user to just add in the station efficiency and the cut the station takes to calculate the end yield. Also a price for buying and selling the ore, handy for those who aren't sure whether their ore will be worth more in a processed or unprocessed state.
Since I'm not in a corp, or be in a position to be producing equipment I can't comment on those sections, but I hope you stick at this, it shows a hell of a lot of promise.
Excellent ideas all! I'll look at this next. Just finished making some changes (not yet released) to the 'Research' page of the sheet. It now calculates the 'Finish' time on a research slot and flags you when it's done. Some other cosmetic changes and bug fixes. Should be a v4.0x release by this coming weekend.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Aloris Crow
|
Posted - 2004.06.08 16:58:00 -
[69]
I've actually made an attempt on redesigning the ore sheet myself, my god is the maths complicated. I've only got the Veldspar calculations done, and I'm hoping that the maths will continue to work right through to the end.
On a side note, does anyone know how to force excel to leave specific cell references in formulae alone when copying and pasting, its a swine to keep rejigging it.
|

Oskiy
|
Posted - 2004.06.09 23:55:00 -
[70]
Originally by: Aloris Crow On a side note, does anyone know how to force excel to leave specific cell references in formulae alone when copying and pasting, its a swine to keep rejigging it.
=A1 will change to A2 if you copy down 1 row and B1 if you copy to the right one column. If you want a reference to remain pointed to a particular location when copying, use the $ symbol...
$A1 will keep the column fixed, but the row can change A$1 will keep the row fixed, but the column can change $A$1 will keep both fixed.
|
|

Aloris Crow
|
Posted - 2004.06.10 12:36:00 -
[71]
That's it, I knew it was a $ that did it, but couldn't remember the usage.
I've managed to get the veldspar calculations working great, scordite needs some tweaking as it's out by a single unit of minerals.
|

Oskiy
|
Posted - 2004.06.11 20:43:00 -
[72]
Lachenlaud,
I just emailed you with a copy of a simple spreadsheet that might be of interest to others. I made this quick and dirty to meet my needs. There are three calculators that work this way:
1. You supply the quality and level of the agent that you want to work with, and it tells you the effective standing you need to work with that agent.
2. Works the same as number one, but also tells you the Agent's Corp -> Your Char standing you need to work with research agents. Actually, you can reword number 2 and drop number 1 since it repeats the same information.
3. You supply your highest effective standing, be it Agent->You, Agent's Corp->You, or Agent's Faction->You, and the level of agent that you want to work with, and it tells you what quality agent that you can work with.
|

Lachenlaud
|
Posted - 2004.06.12 14:37:00 -
[73]
Ok, bunch of updates have been done! Check out Version 5.00!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Plutu
|
Posted - 2004.06.16 08:01:00 -
[74]
A few ideas for your awesome skills chart:
1)Automatic checkmark next to "have skill" in "skills" tab if you have any skillpoints in that skill. Something like: =IF(($F$13)>0,"YES","NO"), (I know the formula is not correct) - could also introduce red/green color codes instead of yes/no.
2)A third kind of color code (yellow) next to "have skill" in "skills" tab if you are able to begin training a specific skill (you have the requirements) but have not yet begun training it. (alot of work, I know)
3)Incorporating your present refining, refining eff. and the specific ore refining skills from the "skills" tab into the calculations used in the "orecalc" tab as these are very inaccurate, atleast for me :) (alot of work too)
4) incorporate an option to specify your mining speed (m3 per minute for an example) and make a earning per hour formula for each ore type according to this speed. (A further option would be to also consider the time (2-3 minuttes) used for each hauling of ore, according to the selected cargo capacity)(I imagine a bs would be able to fill up a hauler 4-5 times per hour)
5)many newbies sell their ore instead of refining it because of their low refining skills. And some corps have members that sell their ore to the corp for specific corp prices. So incorporate an option to specify ore prices aswell in the "orecalc" tab as you have done with minerals. Each ore type should now have 2 isk values, one for when the ore is refined, and one for the ore that is not.
6)A new addition: A list of all the known NPC pirats with: Name, Bounty, Security rise, the range of system security levels of which they have been spotted(0,0-0,3 for an example), notes about their weaponry etc. (insane amount of work, I know)
well, that was a few ideas, I know some of them might sound strange or simply requires too much work in order make, but perhaps you can use some of them anyway.
Thx for the great skill chart, keep up the good work :)
|

Aloris Crow
|
Posted - 2004.06.20 14:38:00 -
[75]
Just noticed some small errors, the Iteron's cargo sizes are wrong.
Should be: Mk I : 3000 Mk II : 3750 Mk III : 4875 Mk IV : 5250 Mk V : 6000
Again, keep it up, it's an awesome help to have this.
|

Eridicus
|
Posted - 2004.06.22 16:21:00 -
[76]
In the production calculations would it be possible if the needed ammount is <0 of the onhand you return a negative number or notated number (suchaswithinparans) of how much remains to get?
|

Lachenlaud
|
Posted - 2004.06.23 00:10:00 -
[77]
Originally by: Aloris Crow Just noticed some small errors, the Iteron's cargo sizes are wrong.
Should be: Mk I : 3000 Mk II : 3750 Mk III : 4875 Mk IV : 5250 Mk V : 6000
Again, keep it up, it's an awesome help to have this.
FIXED! v6.00!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.06.23 00:11:00 -
[78]
Originally by: Plutu A few ideas for your awesome skills chart:
1)Automatic checkmark next to "have skill" in "skills" tab if you have any skillpoints in that skill. Something like: =IF(($F$13)>0,"YES","NO"), (I know the formula is not correct) - could also introduce red/green color codes instead of yes/no.
2)A third kind of color code (yellow) next to "have skill" in "skills" tab if you are able to begin training a specific skill (you have the requirements) but have not yet begun training it. (alot of work, I know)
These are added! v6.00!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.06.23 00:12:00 -
[79]
Originally by: Eridicus In the production calculations would it be possible if the needed ammount is <0 of the onhand you return a negative number or notated number (suchaswithinparans) of how much remains to get?
I'll have to look at this one. The production page is by no means complete yet though! Thanks for the idea!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

YoYonis
|
Posted - 2004.06.27 01:16:00 -
[80]
Sweet love the new version.  "HDY building it's way to greatness one ship at a time."
|
|

AtoningUnifex
|
Posted - 2004.06.28 15:25:00 -
[81]
Very nice work. 
But you're missing 2 skills which are readily available on the market...
Cloaking Rank 6 Req: Electronics lvl 5 Pri: Intelligence Sec Memory Skill at using Cloaking devices. 10% per level reduction in targeting delay after uncloaking.
and
Covert Ops Rank 4 Req: Spaceship Command lvl 3 & Electronics Upgrades lvl 5 Pri: Willpower Sec: Perception Covert operations frigates are designed for recon and espionage operation. Their main strength is the ability to travel unseen through enemy territory and to avoid unfavorable encounters Much of their free space is sacrificed to house an advanced spatial field control system. This allows it to utilize very advanced forms of cloaking at greatly reduced CPU cost.
Info grabbed from eve-db since I'm at work... I'm sure the Perception & Willpower attributes are actually switched around.
No sign of Hypereuclidian Navigation or Astrometrics yet...
------------------------ Collector and flyer of starships
|

Iskander
|
Posted - 2004.06.29 07:02:00 -
[82]
Great stuff, I'm looking forward to setting this up when I'm at home. What chance an option to sync up with EVE-DB or EVE-DB source files? You should sell this back to CCP and improve their Character Info section on the web!! 
|

Lachenlaud
|
Posted - 2004.07.02 04:07:00 -
[83]
Originally by: AtoningUnifex Very nice work. 
But you're missing 2 skills which are readily available on the market... Cloaking Covert Ops
Already added - and will be coming out with the next version!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.07.02 04:07:00 -
[84]
Originally by: AtoningUnifex Very nice work. 
But you're missing 2 skills which are readily available on the market... Cloaking Covert Ops
Already added - and will be coming out with the next version!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.07.02 04:08:00 -
[85]
Originally by: Iskander Great stuff, I'm looking forward to setting this up when I'm at home. What chance an option to sync up with EVE-DB or EVE-DB source files? You should sell this back to CCP and improve their Character Info section on the web!! 
Dunno about the source files or DB - it's excel so I should be able to do something with a vbasic macro or somesuch. I'll look into this.
If CCP wants it, they can have it - just like anyone else. It's free to all - I do this because I enjoy it. Of course, I'd GLADLY accept a STICKY as a token of appreciation. :-P
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.07.02 04:08:00 -
[86]
Originally by: Iskander Great stuff, I'm looking forward to setting this up when I'm at home. What chance an option to sync up with EVE-DB or EVE-DB source files? You should sell this back to CCP and improve their Character Info section on the web!! 
Dunno about the source files or DB - it's excel so I should be able to do something with a vbasic macro or somesuch. I'll look into this.
If CCP wants it, they can have it - just like anyone else. It's free to all - I do this because I enjoy it. Of course, I'd GLADLY accept a STICKY as a token of appreciation. :-P
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.07.02 04:09:00 -
[87]
Originally by: YoYonis Sweet love the new version. 
Thanks!
I should be releasing the NEXT version some time around the 10th or 11th.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Lachenlaud
|
Posted - 2004.07.02 04:09:00 -
[88]
Originally by: YoYonis Sweet love the new version. 
Thanks!
I should be releasing the NEXT version some time around the 10th or 11th.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |

Reva Ortov
|
Posted - 2004.07.09 22:13:00 -
[89]
I stumbled across your thread while browsing the forums and tried out your sheet. Its really great for my needs. Its a lot of work and you should get a sticky 
|

Reva Ortov
|
Posted - 2004.07.09 22:13:00 -
[90]
I stumbled across your thread while browsing the forums and tried out your sheet. Its really great for my needs. Its a lot of work and you should get a sticky 
|
|
|
|
|
Pages: 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14 15 .. 15 :: one page |
First page | Previous page | Next page | Last page |