Spreadsheet to Help You Count Pieces

User avatar
Vegomatic
Ogre
Ogre
Posts: 822
Joined: Fri Apr 03, 2015 4:18 pm
Location: Kansas City, MO

Re: Spreadsheet to Help You Count Pieces

Post by Vegomatic » Fri Sep 22, 2017 1:53 pm

Thanks for checking my work. I appreciate the feedback.

The narrow door is part of the "vaulted door corner with narrow ancient door." Don't know if it is removeable but i intentionally listed it separately like all the other doors.

DevGuy
Goblin
Goblin
Posts: 43
Joined: Mon Oct 10, 2016 5:21 am

Re: Spreadsheet to Help You Count Pieces

Post by DevGuy » Fri Sep 22, 2017 5:37 am

Vegomatic thanks for this.

When adding 1x Classic Advanced Builder it incorrectly adds 1x Narrow Ancient Door which is not in the add-on.

User avatar
Harneloot
Minotaur Lord
Minotaur Lord
Posts: 3280
Joined: Mon Apr 02, 2012 8:32 pm

Re: Spreadsheet to Help You Count Pieces

Post by Harneloot » Fri Sep 15, 2017 7:28 pm

Followed your delete instructions (who wants unpainted? :) ) and the sheet if working smoothly.

A beautiful thing - many thanks!

Alphyns
Goblin
Goblin
Posts: 48
Joined: Tue Aug 30, 2016 6:48 pm
Location: Chicagoland

Re: Spreadsheet to Help You Count Pieces

Post by Alphyns » Fri Sep 15, 2017 6:00 pm

Thank You! And have a great weekend! It looks like mine will be spent playing with the spreadsheet.

User avatar
Vegomatic
Ogre
Ogre
Posts: 822
Joined: Fri Apr 03, 2015 4:18 pm
Location: Kansas City, MO

Re: Spreadsheet to Help You Count Pieces

Post by Vegomatic » Fri Sep 15, 2017 1:50 pm

OK. I have waded through all the data in the pledge manager and have made adjustments to the spreadsheet. By my figuring these are the changes to the sets from the campaign to the pledge manager (not counting magnets):

Eldritch Pools:
4 1x1 floors instead of 2
5 1x2 floors instead of 6
2 large curved floors instead of 4 small curved wall backfill

Doomroller's Labyrinth
10 Passage Short Walls instead of 6
10 Passage Walls instead of 12

Dais of the Dead
2 1x1 Dungeon Floors instead of 0
2 1x1 Walls instead of 0

Lava Bridge
1 Classic Dungeon Wall with LED instead of 2
2 Vaulted Door Corner with narrow door instead of 0
8 1x1 Dungeon Floor instead of 7
9 1x2 Dungeon Floor instead of 7

Forsaken Temple
4 Forked Spike instead of 3 (also applies to golden forked spike in jade temple)

My first attempt at all the updates and changes (including pre-installed magnets) is here:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Many of the sheets are unwieldy large (due to double number of columns taking into account pre-installed magnets). To remove unwanted columns... Do them one at a time. Remove one from the right side then remove the corresponding one from the left. In other words, remove the formula column before removing the column you type in. But really... do one at a time as the formulas can be a little persnickety.

Post corrections or questions here or as a comment on the sheet. My weekend is pretty much booked up. I will have a little time later today to try to address issues, but almost none the rest of the weekend. After tonight I expect to be back online Monday evening 9/18.

Good luck!

User avatar
Harneloot
Minotaur Lord
Minotaur Lord
Posts: 3280
Joined: Mon Apr 02, 2012 8:32 pm

Re: Spreadsheet to Help You Count Pieces

Post by Harneloot » Thu Sep 14, 2017 2:08 pm

marcoreds wrote:
Thu Sep 14, 2017 1:27 pm
Thank you man, I am lost without your spreadsheet :-)
Agreed - it is a godsend!!!

marcoreds
Orc
Orc
Posts: 101
Joined: Sat Feb 27, 2016 10:24 am

Re: Spreadsheet to Help You Count Pieces

Post by marcoreds » Thu Sep 14, 2017 1:27 pm

Thank you man, I am lost without your spreadsheet :-)

User avatar
Vegomatic
Ogre
Ogre
Posts: 822
Joined: Fri Apr 03, 2015 4:18 pm
Location: Kansas City, MO

Re: Spreadsheet to Help You Count Pieces

Post by Vegomatic » Wed Sep 13, 2017 12:02 pm

Working on sheet updates in the evenings. Verifying content of each set. Working on way to add preinstalled magnets. Hope to make it available this weekend.

User avatar
Vegomatic
Ogre
Ogre
Posts: 822
Joined: Fri Apr 03, 2015 4:18 pm
Location: Kansas City, MO

Re: Spreadsheet to Help You Count Pieces

Post by Vegomatic » Fri Jul 21, 2017 4:25 pm

Sheet has been updated to include the 4 Serpentine Corner Pillars for the Shrine of Sysuul encounters.

https://docs.google.com/spreadsheets/d/ ... sp=sharing

User avatar
Vegomatic
Ogre
Ogre
Posts: 822
Joined: Fri Apr 03, 2015 4:18 pm
Location: Kansas City, MO

Re: Spreadsheet to Help You Count Pieces

Post by Vegomatic » Fri Jul 14, 2017 12:17 am

"My DF KS5 Planner" has been updated to include a tab to compare up to 4 pairs of gray configurations (All Gray), and a tab to compare 4 pairs of painted configurations (All Painted).

There is column with each pair that highlights how many more (or less) the first of the the two columns has.

https://docs.google.com/spreadsheets/d/ ... sp=sharing

I found I was doing it for me, so I cleaned it up to share with others.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests