Its rather difficult to advise with the information given. I assume that you have one item per row, and there must be two columns somewhere for "COMPLETED" and "TO BE WORKED" with a suitable marker that you can count, placing two totalsat the bottom of the sheet. This is where I lose track.
When you say you erase data for the following week, this should be after you've taken a copy to avoid losing the previous weeks report? On the following weeks report, (being set up presumablythis week) all the items will be marked "TO BE WORKED", and "COMPLETE" would be 0.
So if you have active jobs this week that may not complete by the end of the week, you place these on the following week as well. You can then review later, and mark "COMPLETE" at the end of this week, if in fact they didn't need carrying over.
Does that work for you?
Bookmarks