You're talking about a heating boiler, right?
What you need to do won't fit on one spreadsheet. You need to do a Manual J load calculation to find the heating needs of your space and then size the boiler as required. Manual J is very involved; the only practical way to do the calculation is with specialized software. HVAC Calc and RHVAC work well.