You don't need a spreadsheet, but if you want one it's probably in one or another version of this thread
https://endless-sphere.com/forums/viewtopic.php?t=3484
https://endless-sphere.com/forums/viewtopic.php?t=32455
https://endless-sphere.com/forums/viewtopic.php?f=2&t=6241
https://www.google.com/search?q=brushless+motor+phase+hall+wiring+combo+site:endless-sphere.com
This is one variation on an easier way; another is posted by JohninCR in one or more of the threads above.
Setup the motor so it is unloaded, wheel offground.
Setup a wattmeter or amp meter (or multimeter capable of at least 10A set to that) between battery positive and controller positive.
If your phase wires are easier to swap than the hall wires, then plug in the hall wires, and plug in the phase wires.
Gently at very low throttle try engaging the motor just a little bit. If the motor spins in the right direction, smoothly, no wierd noises, and the current is less than an amp or so, you probably have the rigth combo. Increase throttle slowly until either something gets wierd/wrong, or amps go way up, or you reach full throttle. If nothing goes wierd or wrong, then try riding it. Note that you'll have to take the ampmeter out if it's not capable of more than the full current your controller can draw, but a wattmeter should be fine to leave in. If it's still ok, doesnt get hot, etc. and doesn't draw excessive current, you've found the right one.
If it's not the right one, then start from step one, but swap any two phase wires, leaving everythign else the same. You can note down which colors you started with, and whcih you swap, each time, if you like. Retest the same way.
If it still doesn't give what you need, swap the last two phase wires, again leaving all else the same, and retest.
If you find a combination that is correct but spins the wrong way, then you swap any two phase wires and then swap hall wires until you find the right combination.
Generally, you'll find the right combination a lot faster this way than going thru all 36 phase/hall wiring combinations in a spreadsheet--it usually takes less than 5 tries.
