What is this for?
For any table that needs stat test switching and/or reordering of the variables in a banner.
For example, if you receive a table that has variables in a certain order across your banner (ABCD) and you want to exclude variable B from reporting. You can switch the table so it reads ACDB but the tool will reformat it do you have the stat testing in proper alphabetical order rather than just removing variable B stat testing.
How do I use it?
STEP 1:Go to: https://map.hotspex.com/StatTestSwitcher
STEP 2:Copy and paste the table you want stat testing switched in a separate excel file. Make sure all cells are unmerged, the stubs are on the very left and there are no extra rows you do not need at the bottom of the sheet.
STEP 3:Upload the file to the tool by pressing "Choose File", Choose the file you just created and press "Upload".
STEP 4:Reorder the banner in the order you will be reporting in by clicking and dragging on the variable and placing it in the order that you want it (You can rearrange any of the variables in any way you want!).
STEP 5:Click "Generate Sheet" the new file will download.
STEP 6:VOILA! New Banner! With stat testing letters in alphabetical order!