Engineers Engineering Database And Calculator [Engineers Update]

Qohen Leth

Qohen Leth
Peuwi said:
Just found in a new tab "inventory management"

... I told you, if you need help for formula, I can help !

(but here, this is crazy :D)
Click to expand...

Hehe :D Well, the last tricky part is the formula to calculate how many rolls of each mod you can do with your current stock. Hop on FleetComm if ya wish to help :D
 

Peuwi

P
Qohen Leth said:
Hehe :D Well, the last tricky part is the formula to calculate how many rolls of each mod you can do with your current stock. Hop on FleetComm if ya wish to help :D
Click to expand...
View attachment Engineering Database & Calculator_Inventory Mgnt.zip

Here, I did it in excel, in both ways. (components -> upgrades / upgrades -> components)

Reminder : you need 1 table for each relation of your data model, or it will just be a huuuuuge mess

I also had to clean a bit the data, some values are still missing ...
 

frostypaw

frostypaw
Is there a way we can contribute listing the various secondary effects we get on non-weapon modifications at various levels? I can't see them on the doc just now, but may be being slow
 

ExoForce

ExoForce
Jack Lawless said:
Out of curiosity, is there a way to export our materials and data to an excel? I was thinking it would be nice to know how much of what we need to make something for the engineers we have, in combination with your excel. If you can export your materials and data you collected, maybe using something like vlookup, it will populate a field for how much you have. This will give a comparison to how much you need. But don't know if you can actually export this, seems weird not to, since you can export the logs and stations market commodities.

Any idea if its possible to export them?
Click to expand...

For this, we need (hardcore) hardcode CMDRs to do OCR voodoo stuff.
 

Qohen Leth

Qohen Leth
An inventory management sheet will soon be available (WIP atm). We're also planning on turning the doc to a webapp. If there's a skilled buddy around, with motivation and a bit of free time, feel free to poke me.
 

bad-r0bot

bad-r0bot
Qohen Leth said:
An inventory management sheet will soon be available (WIP atm). We're also planning on turning the doc to a webapp. If there's a skilled buddy around, with motivation and a bit of free time, feel free to poke me.
Click to expand...

Did... did you just make the one thing I was attempting to consider making?! For a WIP it's beautiful! I wanted to make some kind of excel sheet like yours but you're already working on one :D THANK YOU!

edit: I've already given you too much rep. I have to spread it around lol
 
Last edited:

Qohen Leth

Qohen Leth
bad-r0bot said:
Did... did you just make the one thing I was attempting to consider making?! For a WIP it's beautiful! I wanted to make some kind of excel sheet like yours but you're already working on one :D THANK YOU!

edit: I've already given you too much rep. I have to spread it around lol
Click to expand...

Haha :D We'll just slow things down a bit, it's been a very (too) intense week. And it's only been a week!!!!
 

Lasse B.

Lasse B.
Thank you very much. These sheets are an absolute gold mine.

Btw, when trying to unhide the hidden tabs, the entries are greyed out. Is this a Google thing too? Sorry for asking such basic questions but I never got into any of these crowd working always online things.
 

Qohen Leth

Qohen Leth
Lasse B. said:
Thank you very much. These sheets are an absolute gold mine.

Btw, when trying to unhide the hidden tabs, the entries are greyed out. Is this a Google thing too? Sorry for asking such basic questions but I never got into any of these crowd working always online things.
Click to expand...

No pb. Usually, cells appear grey when someone else is modifying them. Is that what you mean by 'entries'?
 

Derath

D
can I just say the unlock requirement for broo is unbelievably grief :p 100 tea when it restocks 2 at a time and the maximum allocation is 10 :/ we are talking a bit over 8 hours just to refresh that much tea, the journey is about 20 minutes there 20 minutes back in a python, maybe 12-15 in an asp so your looking at round about 15 hours if you sat and grinded it out straight.
 
Last edited:

Jabezz

J
When I open the viewer tab its just all grey. Is this part of the sheet working yet?

And that is on the copy version also.
 
Last edited:

Qohen Leth

Qohen Leth
Jabezz said:
When I open the viewer tab its just all grey. Is this part of the sheet working yet?

And that is on the copy version also.
Click to expand...

Lasse B. said:
Thank you very much. These sheets are an absolute gold mine.

Btw, when trying to unhide the hidden tabs, the entries are greyed out. Is this a Google thing too? Sorry for asking such basic questions but I never got into any of these crowd working always online things.
Click to expand...

Can you provide a screenshot? Nothing has moved, it's weird.
 

Lasse B.

Lasse B.
Qohen Leth said:
Can you provide a screenshot? Nothing has moved, it's weird.
Click to expand...

Sure thing:

Esmnj1m.png

It's the same with Chrome and IE and with the original document, too.
 
Last edited:

Lasse B.

Lasse B.
I must be doing something wrong...

SqRoppk.png

All I can do is download the file as an .xlsx, but when doing so the other tabs have faulty entries. Downloading as .ods results in an even more broken file.
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom