I made a simple DIY battery calc in Excel to work out voltage, Ah, the amount of cells needed, cost, weight etc. Thanks to Woosh for correcting it.
Link to calc:
https://www.dropbox.com/scl/fi/5cb6wq8op52ik561zhy6k/DIY-eBike-Battery-Calc.xlsx?dl=1
Screenshot: