Format has changed again Go here to discuss...again!

https://www.reddit.com/r/FFBraveExvius/comments/5ifdu1/new_new_survey_prototype/

So here's the new format I'm working with so far. (only done the 10 1 format for now) The unit list is alphabetical so you can type the name of the unit and it will auto-track them. You can also use Ctrl F:

https://goo.gl/forms/FX45Ew5oEm3aEZta2

I already have concerns about the new format but also want to precede some problems that are already apparent from doing it like this.

Earlier u/nekoramza gave me a format that had the rarity of the unit included in the name choice. This kind of answer format literally makes it impossible to put in something invalid which is really cool, but I found that by doing that, I could not use pivot tables in a way that would (easily) summarize a unit's total rate later on, because their names were "different" after noting their rarity in the same response. I also would not be able to make rates on the actual rarity of the crystal (easily) this way, because as already said, the rarity is tethered to the unit's name.

Do understand that yes, doing it the way above can still result in data we want, but I would be working on it for much longer than normal each time I needed to update the rates. Lots of steps are added from doing it like this. I definitely don't want to do it this way and ask for help either, because in the end someone is still sinking hours of their life into this.

So what's the deal with this format I did?

It takes the question and splits it into two. One for the unit name and one for the rarity. I've already tested this and I can use pivot tables to analyze this data much more easily and quickly. I have to crop and merge all 10 normal roll results into two columns but I think that will be ok. I can get rarity rates and unit rates, but not sure if I can get unit distribution per rarity, I will see about that later.

The only problem with this is someone can input something like a 3* Ramza, or a 5* Vivi. I don't think this is a huge problem? But that's what your opinion is for.

Questions from me to you:

1. How does this format look to you?

2. Should I make the daily/ticket survey a single question survey you can take many times so you don't have to keep track of them?

Advantage: You'll be able to input your data partially for when I update on the weekend halfway through the banner. (I will update this 3-4 times. Friday, Saturday, Sunday, and Thursday. It may seem weird to do it this way but most submissions come in in the first three days or on the last.)

Risk: I will no longer be able to tell if someone's submission is a troll/crazy outlier.

Oh and a video will have to be done on Friday, as in I would probably get it done Friday night, so sadly it will not be present on banner launch.

If you see problems I don't, or have suggestions let me know in the comments.

Oh and if you wanna mess around with that survey and put stuff in I can test how it'll work in a pivot table so go ahead.