1 (edited by Black Flag 2011-02-08 21:38:09)

Topic: Accumulator Cap Stability Spreadsheet

Input your fitted data into the spreadsheet to find out if you are cap stable.  This will be very useful for all of you trying to get a miner bot/mech stable.

Download the spreadsheet here.
v1.03
Updates:
Corrected Chassis Module 7 name.                   
Reformulated to give 0 values instead of error messages.               
Added time to fail algorithm if stablity = NO.

Common sense is the least common of all the senses.

Re: Accumulator Cap Stability Spreadsheet

Thanks! <3

Re: Accumulator Cap Stability Spreadsheet

Thanks wink

Re: Accumulator Cap Stability Spreadsheet

A little thing... There are 2 cells with the same label : Chassis Module 6

Otherwise, good work, thanks a lot smile

We do not stop playing because we are old; we grow old because we stop playing. - Rose
-----
It has the worst community I have ever seen. Even worse than almighty Barrens chat. - gordiflu

Re: Accumulator Cap Stability Spreadsheet

does anyone know the cycletime for accumulator recharge? it seems like less then 1s to me.
I would like to extend that spreadsheet abit with that.

*Disclaimer: This post can contain strong sarcasm or cynical remarks. keep that in mind!
Whining - It's amazing how fast your trivial concerns will disappear

Re: Accumulator Cap Stability Spreadsheet

Annihilator wrote:

does anyone know the cycletime for accumulator recharge? it seems like less then 1s to me.
I would like to extend that spreadsheet abit with that.

I haven't had any luck getting an answer to that question myself, if you do get one, let me know.

Thanks

Common sense is the least common of all the senses.

Re: Accumulator Cap Stability Spreadsheet

Sticky?  I've had over 300 downloads of this spreadsheet big_smile

Common sense is the least common of all the senses.

Re: Accumulator Cap Stability Spreadsheet

Nice work! Can you deploy and support g-docs version? Thanks.

Re: Accumulator Cap Stability Spreadsheet

Bump, perfect tool, thanks for this one.

Re: Accumulator Cap Stability Spreadsheet

Thank you for the effort!

Re: Accumulator Cap Stability Spreadsheet

This really seems like something that should be included in the client when your on the equip window.

Re: Accumulator Cap Stability Spreadsheet

awesome tool! thx

13 (edited by OptimizedAwesome 2011-07-20 02:43:01)

Re: Accumulator Cap Stability Spreadsheet

When I tried to open it:

Problem found with formula J38.
The formula is too long or complex, or contains a function that is not supported.
Click Yes to continue loading and display other errors, click No to continue loading and suppress further errors, or click Cancel to stop loading the document.

If I click No:

20 errors were found when the spreadsheet or database was opened.

If I click Yes, I have to keep clicking yes 19 more times until it gives me the same message as if I clicked No.

Why is this? I'm running it in Microsoft Works Spreadsheet v1.03

Re: Accumulator Cap Stability Spreadsheet

Black flag is not with us anymore sad He died to the grind.

From what I see in his other works, you need to have Excel for them to work. (not open office, not microsoft something, but excel smile

<GargajCNS> we maim to please

Re: Accumulator Cap Stability Spreadsheet

can someone post a screenshot of this one? dont have excel installed, so i cannot look. sad

*Disclaimer: This post can contain strong sarcasm or cynical remarks. keep that in mind!
Whining - It's amazing how fast your trivial concerns will disappear

Re: Accumulator Cap Stability Spreadsheet

Theres q complete formulq you can use to get the recharge rate at a specific cap a mount as its on a bell curve it the peak being at 50%. Alternatively if your not worried about what you cap out at, ust take the  (capacity/regen)*2 and that's what your regen is at peak. To find your use age just do acum usage/cycle time for every module and then run a check to see if usege < peak recharge.

Accumulator Peak Recharge rate = (Axumulator Capacity/Accumulator Rcharge Rate)*2
Accumulator Drain per Second = Module Accumulator Use/Module Cycle Time

Re: Accumulator Cap Stability Spreadsheet

Googled subject


https://docs.google.com/spreadsheet/ccc … UxmTmpPOWc

Version 1.03

All Thanks to its Author  Black Flag

PS Keep in mind - stable means your Accu always stable at 50% capacity

Re: Accumulator Cap Stability Spreadsheet

ahh, necro of outdated spreadsheet...

*Disclaimer: This post can contain strong sarcasm or cynical remarks. keep that in mind!
Whining - It's amazing how fast your trivial concerns will disappear