Eve Online Industry - Your Job Tracker PT.6

[@jean-pierrevanaswegen9289]

I didn't know I would like sheet work so much. Thank you.

[@edwardnaylor7265]

Glad you continued with this mate!

[@ACreator89]

exactly. the most helpfull fella i ever found with this stuff. he even spent some hours helping me one on one :D recently returned to eve so glad he is keeping this up!

[@Mupersega]

Yeehboiii

[@Mupersega]

Yeehboii, more on the way.

[@sustainedcruelty]

Thanks for keeping up this amazing work. Your videos have helped me a lot.

[@Mupersega]

Terrific :) if you want more, twitch.tv/muperserga monday and wednesay nights.

[@sustainedcruelty]

@@Mupersega Thanks for the suggestion but I was lucky enough to already find them :P . You might recognize my twitch name: Sustained_Cruelty

[@Mupersega]

Sustaiiiined

[@Yaratoma]

I have already learnt a lot and thanks for the spreadsheet!

[@Mupersega]

Yaratoma, I am so glad that it has helped you out. If you have any questions or would like to learn more, please head on over to twitch.tv/mupersega where I stream monday and wednesday nights Australian time :)

[@Yaratoma]

@@Mupersega thanks, I am supposed to be asleep then

[@Elliath]

Thank you. I didn't know about that dynamic list trick.

[@Mupersega]

Elliath you are very welcome, if you have any questions or would like to learn more, please head on over to twitch.tv/mupersega where I stream monday and wednesday nights Australian time :)

[@danielzajac3397]

Thanks a lot! Great work

[@JeremyAmor-m1d]

Just curious are you still playing Eve and if you are I was wondering if you could help me with the concat list for ammo. is it possible to have all charges, missiles, crystals... ect all in one build sheet or should I create one sheet for each type of charge. Thank you in advance

[@WilhelmEdrasill]

Another great vid! Thank you Sir! Thanks XD

[@Samji3877]

:facepalm: I typed it aaalllll out before finding out you had provided the lists... :rofl:

[@merlin3717]

I have managed to do everything before this part on google sheets however this part is where I seem to be getting stuck as I just can’t seem to get the lists to change dynamically

[@Mupersega]

david wharrier talk me through it.

[@Mupersega]

You have copied the lists across? You have made each one into its own named range? You have a conclist that is updating dependent on the parameters? You have the data validation in the type column set to indirect the conclist column?

[@merlin3717]

Mupersega I don’t think google sheets supports dynamic lists like this as I had to get the static lists a different way but I’m gonna keep experimenting as I don’t think I’ll be able to use the extra I did on my google sheets version on excel ( I get current market prices for the minerals and the built ships, then compare the full manufacturing plus 10% to the current market price. For this I used evepraisals google sheets tools)

[@Mupersega]

You're right, google sheets most certainly doesn't support dynamic lists like this. I uploaded those lists to google sheets so that one may copy and paste into excel. Each group needs to then be turned into a named range. I hear what you are doing with google sheets to pull data, great work, might I suggest something if you want to get that same data into excel. If you are content with the data you have set up in sheets you can go to file - publish to the web - entire document as (comma separated values) - select publish - copy link - open excel go to data tab - get data (from web) - paste link - import to excel. All that to say that the solutions and the formulas used in excel, while similar to google sheets, will not translate well. Conclists are not a thing in sheets, in fact dynamic dependent drop downs for multiple rows are impossible in my experience (at the moment)

[@Mupersega]

I spent a loooong time trying to get it working in sheets, dependent drop downs are possible but not like we are doing in excel. The indirect function doesn't seem to work as a pointer to a named range in sheets.

[@taffareldelimaoliveira]

If you guys are have trouble with google sheets when making the conditional drop here the apps scripts to do the same paste.ofcode.org/39qRcL84u4pGhe2GJ368sMh

[@Mupersega]

Woot, Taffarel I have looked at the code and does this just take what is in the top row and assign it as the range name for the selected cells?

[@taffareldelimaoliveira]

​ @Mupersega The behavior is when the user selects an option at Tech column and if not the first row then clear any value and the data validation on it. get the conclist range and its value, verify if the conclist value is in the shipDB sheet return the position or -1 if not create a validation range with the column of values found it build the data validation then put the data validation side of the currentCell

[@Mupersega]

Taffarel de Lima Oliveira yikes, love it