I am looking for an excel spread sheet of all pieces and all of their powers and commander effects. I'm trying to build a database that will export all characters for a squad onto a spreadsheet and then be able to print the spread sheet for easy squad building without going through the mountain of cards that eventually get all messed up and out of order.

Do any of you bloomilkers have such a spread sheet?

Thanks

howdy;
surf's custom statcard maker is pretty awesome,
though if you're wanting a quick and easy printable squad thing,
the custom squads on bloomilk do allow you to print the squad composition
(if not each of the statcards all at once).

a couple of folks were working on a 'get.that' page json/python
converter script,
which would scan the url's ranges input,
and take the text-string and convert that into
a by-layer for a pre-formatted statcard.
that would have been awesome,
but due to other committments,
that team dissolved...

are you envisaging something like the existing bloomilk squad-at-a-glance,
though with all of the SAs, CEs and FPs all on the page too?
that would be awesome.

apologies if this doesn't help much -
I wanted to send a strong signal that this would be an awesome thing to see made.
(@swmplay, do you think something like this would be doable with your existing framework?)

@donnyrides,
it would be handy to have all the cards
in a squad composition, to also be able to print them out with the present
bloomilk custom squad printout,
to as you say, get away from having to manually pull out the cards and put them away again heheh.
for newer users, it would also be handy to have on
the 'cheat sheet', all of the SA's, CEs and FPs etc the squad has.
(aside: imagine if that updated in real time, reminding the user when a SA or CE no longer applies etc...
it may reduce the number of errors during a game?)

no known excel or python chart yet exists for all statcards,
though the bloomilk index would be fairly close.
i think that bloomilk indexes were written in javascript...

as to the card reader/converter project...
a while back, maybe 2012 or so?
a few folks were wondering,
'could we write a 'get.that|string|', algorithm,
given that bloomilk is fairly well structured,
could we write a google search that would
index the site from say 'wayback machine' or '8hrsprior'
and convert the stat cards on the custom statcard directory,
'wholeus bolus',
into 'transparent .jpg layers'
for to make statcards?

that way, all a person has to do,
is input the front character image,
input the back character image,
update the year the card was made/any R-reserved changes (such as c disney etc)
and input the faction background . jpg.

ie

Name
Cost
HP
DEF
ATK
DMG
SAs
FPs
CEs
get.that|{line number of "ATK" string value}.pageURL{enumstring_variable/write_variable:b3}}}
write.input|appname in gimp, {values which make layer transparent, 3 lines till input.textstring
get.that|{line number of "DEF" string value...
^^ above is illustrative pseudocode for approach purposes only, so as we can see how to break this down into smaller parts: don't feed your computer this, as it will 'vomit' and get quite ill hehe

it is the same concept as having a program look up a sequence from OEIS or check the clock,
but instead of going to the OEIS or clock, it looks up bloomilk...
or if you're brave enough, you can do a batch Google search to populate a database and dump that on a tb drive,
it takes a few hours for it to finish hehe.
it reads the pageview code, and duplicates the appropriate text strings.

a few folks began looking into the coding,
in json and python
(json would use screenshots indexed from 8hrsprior and 'waybackmachine', 'reading' for certain keywords.
python would convert text strings as throughput into say GIMP as a transparent text layer)

I had seen on the opencog, repetier, boardgamegeek and whirpool forums a few folks trying that out,
- the code snippet variant produced interesting leads but petered out..
the image reader variant was nasty - it didn't get all of the special abilities etc,
and had blurry edges on the fonts etc,
so it was almost as much effort correcting that
as it would be to manually convert
all the custom statcards from the statcard index
and transcribe them onto a formatted 'blank' statcard
for the values of each layer,
we made some assumptions for formatting -
8pt font, -3.0kerning etc
in testing, those direct reads ended up layering the ability layers over one another,
such that it became illegible (for cards with a lot of abilities etc)

now,
for existing statcards,
we have hi-res images of those...
so, it would be a simple database lookup,
ie "|character name textstring|= |hires_imageNox,y,z|.jpg
to find those.
however, for VSetcards or custom ones, we don't have all of those quite,
so maybe a conversion script would still be useful?

when you have a finished squad say on the bloomilk site squad builder,
you could then copy the url,
and have a python get.that read the page for character names,
then check through a database of .jpgs (sorta like a jukebox)
to find the matching .jpg string.
then,
the get.that could format the .jpgs onto an A4 paper (clockwise from 'slot 1' to 'slot 6' per sheet of A4) --
I don't know quite how a get.that could work with .doc etc,
though maybe another way would be to throw all those .jpgs its found,
onto a .jpg/.bmp of the same dimensions as A4, take an image or save as pdf etc...
that would be a modulus-enumarray, so it would go through and
pigeonhole the statcards of your list to the page...

a more exhaustive variant... might be
(dare I say it), a hexadecimal squad composition code...
that hexadecimal string converts to pulling all the .jpgs and
arraying them on the A4 paper (in mod ~6)

sadly, my coding abilities are poor
my coding-fu is weak lol.
it could be a fun project though to spark interest in again,
as those would be SWMinis 'killer apps'
thanks for reading - and i'd like to hear from those more in the know
or with stronger code-fu than yours-truly on these ideas

---

side note:
how would such an app function at tournament?
do you still need to have the physical cards 'to-hand', so that you could produce the physical cards,
yet you can use these easier proxies?
or, would proxies be perfectly fine at tournament?
(proxy cards, proxy miniatures... etc)