Excel/Numbers spreadsheet formulas for repairs

[Clayton P.]

Hey all!

I have ballpark estimates I use for what certain repairs to a property will cost, i.e. :

1 New window w/ trim: $220

Bay Window: 220 x 3

Exterior Door: $250

Framed Porch: $12/sq.foot

A/C: $1400/Unit

etc.

How do I go about creating a spreadsheet that lists the items, and as I'm walking the property with an iPad, I can input quantity values, i.e. Windows: _15_ & in the next cell, it spits out $3300?

(220 price per unit x 15 units) So when I finish walking the property, I have a cost amount for repair thats easier to keep track of?

I'm completely novice to Excel/Spreadsheeting, so as step-by-step as you knowledgeable folks can get would be appreciated!

Thanks in advance!

Clay