All in One LoTB Spreadsheet

[kjtaylor13]

Hi All,

I've started work on a Google sheet, where I am planning to collate all the stats and information that I can in a single place.

There are multiple sheets for:
Eddies
Allies
Talismans
Skills
Cosmos Levels
Time Rift Levels

I've taken the maxed stats from the Maxed Character sheet and input them.

I've shared it on Google, and any one can edit it:
https://goo.gl/RbWF5a

Please take a look, and feel free to update and add any missing information.

I will try to make it look a lot nicer and add some functions to it, when I can.

I've plently left to add but feel free to contribute.

Thanks All

Kevin

[Vertax616]

This is great, thanks for the work Kevin!

[vgta99]

I had make some update on talimans sheet.
It will be interresting to add the gold reward for all stages.
I had make an excel for it but I don't finish it yet...

[kjtaylor13]

Hi vgta99,

Thanks. If you want to email me what you have aleady on the gold rewards I can put that into the sheet.

Cheers

Kevin

[vgta99]

Hi vgta99,

Thanks. If you want to email me what you have aleady on the gold rewards I can put that into the sheet.

Cheers

Kevin

Ok but I need you mail

[slauki]

very nice work so far, this should be sticked...

[zamasu]

I love the Idea of "Character Builder" I know where you going there...
if you need help developing the function let me know, I have some pretty nice Excel skills

[kjtaylor13]

I love the Idea of "Character Builder" I know where you going there...
if you need help developing the function let me know, I have some pretty nice Excel skills

I'd love the help. Excel I can do. Google sheets not so much. Need to work out how to get a list of talismans based on there colour into a Temp Area for selection, and then giving the sub type as another list after it's selected.

Think It may be doable using Query(talismansrange, select A where C='Red') or something like that

cheers

Kevin

[zamasu]

I'd love the help. Excel I can do. Google sheets not so much. Need to work out how to get a list of talismans based on there colour into a Temp Area for selection, and then giving the sub type as another list after it's selected.

Think It may be doable using Query(talismansrange, select A where C='Red') or something like that

cheers

Kevin

I haven't work with Google Sheets that much. But I found a way to do it using Filter.

I saw you got it to work too. lol

[kjtaylor13]

Update:
Character Builder: This is a work in Progress Features so Far
Select Class, and Characters, auto updates Talisman COlours and Validation Lists
Select Talisman and Sub Type

ToDo: Working on a way to do the Talisman Effects based on data in the Talisman Table, will be coming shortly (I Hope)

Thanks

Kevin