The ability to have one column that allow us to have excel formulas.

[Amme11]

For example in stockpile, were i manage corp fuel logistics, i use the data from stockpiles to see how long the materials lasts (in days).

I take the data and ad them to excel to see for example that i have enough Robotics that will fuel our structures for a certain amount of days.

If a column can have the ability to have formulas then excel is not needed.

I am not a coder so i dont know if this is easy or not, but if the basic excel formulas can be added to a "formula column", then that would make this app even better.

[GoldenGnu]

I feel like formulas are too much to implement. But, I have an alternative idea. What if you could set “consumed each hour” for each item in the stockpile and then jEveAssets would show you how much time was left?

[Amme11]

yes that would do the job, i set for each component a value and that would show me what i need.

Is this an existing feature or must you program it? If you are going to program it, is it possible to be able to chose between hours, days weeks and month?

[GoldenGnu]

It would be a new feature, that I would have to code.

After thinking a bit more about it.

This is the way I want to implement it: In each stockpile settings, you select time or quantity If quantity is selected, the stockpile would work as it does now. If time is selected, It would allow you to set a target time period in hours/days/months (This would determine the color coding of each item in the stockpile). Then the target for each item in stockpile would be used as "consumed each hour". In the table it would show you how much time is left for each item and the total would show the time when the tower runs out of the first type of fuel.

I hope that makes sense. I'm not very good at explain it...

[GoldenGnu]

Possible solutions: https://stackoverflow.com/questions/3422673/how-to-evaluate-a-math-expression-given-in-string-form

[GoldenGnu]

Options: http://javaluator.sourceforge.net/en/home/ https://github.com/Shy-Ta/expression-evaluator-demo https://github.com/uklimaschewski/EvalEx https://github.com/mariuszgromada/MathParser.org-mXparser

[GoldenGnu]

Going to use the EvalEx library, as that appears to be the most active one.

ToDo:

• [x] Add column
• [x] Remove column
• [x] Edit column
• [x] Save/Load columns
• [x] Update expressions on data change
• [x] Save/Load columns position
• [x] Update filters with new/removed/edited columns
• [x] Buttons:
  • [x] Mathematical Operators
  • [x] Boolean Operators
  • [x] Functions
• [x] Update filters when columns are moved
• [x] Migrate JMenuJumps
• [x] Export/Import filter with formula columns

[GoldenGnu]

Released in 6.9.0