|
C3V and SoV Customs A place for C3V and SoV customs |
|
Thread Tools | Search this Thread | Display Modes |
#13
|
||||
|
||||
There's a Spreadsheet For That
Quote:
~Dysole, very sad Excel doesn't have a filter, sort, or unique function as those are much more convenient than the ways to make those happen in Excel My Twitch Channel where I play Scape and other things My YouTube Channel where the games get uploaded later Dysole's Draft Rankings Map Thread (Not responsible for psychic damage) Customs Battle Reports This sentence is seven words long. This sentence is not seven words long. |
#14
|
||||
|
||||
Re: VC Partial Points Sheet
Quote:
Quote:
My only regret with this format is that I can either make it the right way around for heroes and backwards for squads (which is what I chose), or right for squads but backwards for heroes. I suppose I could do them backwards to each other on the same sheet, but that seems even more confusing. I suppose if it gets too big for one page, I could do heroes on one page and squads on another ... Oh, believe me: I am making copious use of the filter function (and the sort function, and the importhtml function, and probably the unique function, and maybe even the dget function ...) I suppose I could share my spreadsheets out with people if they were interested, but it's kind of a complex mishmash among three different workbooks that requires manual copy-paste at various points to avoid circular references ... I mean, I think I'd spend more time explaining it than any benefit anyone could get out of it. Quote:
Why I Left the C3V |
#15
|
||||
|
||||
Formatt Damon
I guess I'm confused then as to why if it's a Google sheet, it's being offered as an Excel download rather than linked directly.
~Dysole, theorizing that it's got something to do with how many formulas are involved My Twitch Channel where I play Scape and other things My YouTube Channel where the games get uploaded later Dysole's Draft Rankings Map Thread (Not responsible for psychic damage) Customs Battle Reports This sentence is seven words long. This sentence is not seven words long. |
#16
|
||||
|
||||
Re: Formatt Damon
Quote:
There are at least 3 crosslinked spreadsheets with a metric butt-ton of tabs and some manual copy-pasting involved ... heck, I think one of the spreadsheets isn't even mine. I think I'm still using Arch-vile's old sheet for the VC data, which I have permission to edit, but I dunno if I have permission to share it or not. The classic data I pull straight from GaryLASQ's site via an importhtml function. I'm not sure what value anyone could wrangle out of getting read-only access to any of these spreadsheets, but I'm certainly open to considering any arguments that anyone wants to put forth. Quote:
Why I Left the C3V |
#17
|
||||
|
||||
Re: VC Partial Points Sheet
I actually use an all-in spreadsheet for this kind of stuff... with filter abuses too. And when I want a specific information about a precise figure, the 3rd sheet allows to find a figure by its name (with auto-completion) and get all its information.. except synergies. This is still in progress to get also the figure picture and hitzone but I struggled to automate the database creation !
Unfortunately, is it not up-to-date since end of 2017... :/ |
#18
|
||||
|
||||
Sheetfulness
Solid sheet. I prefer INDEX (MATCH ()) to VLOOKUP but I like what you have there. I've looked at my sheet and I see that I could pretty easily install some of these partial points things. If I do so, I'll definitely share the results.
~Dysole, who likes her sheets My Twitch Channel where I play Scape and other things My YouTube Channel where the games get uploaded later Dysole's Draft Rankings Map Thread (Not responsible for psychic damage) Customs Battle Reports This sentence is seven words long. This sentence is not seven words long. |
|
Thread Tools | Search this Thread |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you handle partial hexes? | LMB | Custom Terrain & Obstacles | 5 | July 9th, 2013 03:29 PM |
PDF for Partial Cover rules | hextr1p | Other Customization & HS Additions | 20 | January 17th, 2013 11:44 AM |
TTO attendee partial map pick 'em | Supergeek | National Heroscape Day | 7 | October 9th, 2010 09:33 PM |
Partial Points Scoring (Schedules for Destroyed & Remaining) | boom | Official Units | 41 | October 15th, 2009 03:29 AM |
Possible partial cover rules? | Sherman Davies | HeroScape General Discussion | 17 | July 26th, 2007 05:26 AM |