Engineers Engineering Database And Calculator [Engineers Update]

Jack Lawless

Jack Lawless
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?
 

Qohen Leth

Qohen Leth
tresch said:
Hmm. I can only get it to open in HTMLview... and there's no File menu to make a copy
Click to expand...

Use the Duplicate.

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...

The idea is good, but i can't help with that, it's out of my league :(
 

bigity

bigity
Is there a tool or way to dump your mats/data lists at logout/logon/at will to some spreadsheet?

EDIT: Hah! Someone already asked.
 
Last edited:

Jack Lawless

Jack Lawless
bigity said:
Is there a tool or way to dump your mats/data lists at logout/logon/at will to some spreadsheet?

EDIT: Hah! Someone already asked.
Click to expand...

Yea, i was curios too. It would not be hard to add an other column to the excel you guys are working with and then use vlookup to just populate a new column, for how much you have with need. But the question is, can those things be exported?
 

Qohen Leth

Qohen Leth
Jack Lawless said:
Yea, i was curios too. It would not be hard to add an other column to the excel you guys are working with and then use vlookup to just populate a new column, for how much you have with need. But the question is, can those things be exported?
Click to expand...

If you use a copy like you should do, it's not a problem to do it yourself ;) It's not in the pipes cause I'd like to play sometime this week. For once...

- - - - - Additional Content Posted / Auto Merge - - - - -

jgm said:
Your materials inventory is not available in the companion API, I'm afraid.
Click to expand...

huh??
 

jgm

jgm
Qohen Leth said:
huh??
Click to expand...

Sorry I should have quoted someone. It was a response to those that were wondering if there was some way of obtaining the information about the materials you have directly from the game itself. The API that is used to obtain information about the commander, however, does not contain material information.
 

Qohen Leth

Qohen Leth
jgm said:
Sorry I should have quoted someone. It was a response to those that were wondering if there was some way of obtaining the information about the materials you have directly from the game itself. The API that is used to obtain information about the commander, however, does not contain material information.
Click to expand...

Oh :D
 

Chongo

C
30 or 31% into rank 3 with dweller to get Lei Cheung's invite it looks like. Noticed there wasn't an exact on your sheet and people were ballparking it.
 

Rumik

R
Thank you for this, it's absolutely awesome!

Can I make one suggestion? Change "LVL" to "GRADE" to match the terminology used in-game, avoiding confusion.

Thanks again! Looking forward to a website version! :D
 

Qohen Leth

Qohen Leth
Rumik said:
Thank you for this, it's absolutely awesome!

Can I make one suggestion? Change "LVL" to "GRADE" to match the terminology used in-game, avoiding confusion.

Thanks again! Looking forward to a website version! :D
Click to expand...

Thanks :)

Absolutely, it had slipped my mind!
 

eugeniy

E
updated
ccf83d9c2919.png
any ideas?
085ca0bbbb4e.png
 
Last edited:

Peuwi

P
Just found in a new tab "inventory management"
=IF(AND(IF(ISBLANK(VLOOKUP($H3,$BG$3:$BR$1000,3,TRUE)),TRUE,(VLOOKUP(VLOOKUP($H3,$BG$3:$BR$1000,3,TRUE),$A$3:$B$1000,2,TRUE)>0)),IF(ISBLANK(VLOOKUP($H3,$BG$3:$BR$1000,5,TRUE)),TRUE,(VLOOKUP(VLOOKUP($H3,$BG$3:$BR$1000,5,TRUE),$A$3:$B$1000,2,TRUE)>0)),IF(ISBLANK(VLOOKUP($H3,$BG$3:$BR$1000,7,TRUE)),TRUE,(VLOOKUP(VLOOKUP($H3,$BG$3:$BR$1000,7,TRUE),$A$3:$B$1000,2,TRUE)>0)),IF(ISBLANK(VLOOKUP($H3,$BG$3:$BR$1000,9,TRUE)),TRUE,(VLOOKUP(VLOOKUP($H3,$BG$3:$BR$1000,9,TRUE),$A$3:$B$1000,2,TRUE)>0)),IF(ISBLANK(VLOOKUP($H3,$BG$3:$BR$1000,11,TRUE)),TRUE,(VLOOKUP(VLOOKUP($H3,$BG$3:$BR$1000,11,TRUE),$A$3:$B$1000,2,TRUE)>0))),"Y","N")
Click to expand...
... I told you, if you need help for formula, I can help !

(but here, this is crazy :D)
 
You must log in or register to reply here.
Back
Top Bottom