let's say there is a constant value, $/hr or price of an item. so every line
number has a column to multiply by this value. once or twice a year, this
value may change.

do you just hide a column with that value replicated down until it needs to
be changed?

example, every line item is a day of the year. somebody makes $10 per hour.
sometime during the year, they get a raise and from then on the value in the
hours column needs to be multipled by the new rate.

what's the best way?

--


Gary