Percent complete based off quantity finished and quantity remaining

If I'm building 35 assemblies and there are 10 different steps to the assembly, I'm trying to determine what percentage I am complete with finishing the 35 assemblies. There might be different quantities at each of the different steps. Additionally, some steps are much harder than the others, so if there is a method of applying a "weight" to each of the steps (10 being the hardest, 1 being the easiest), that would provide further accuracy in determining how far along I am with completing all 35 assemblies. What would the formula for this look like? I've attached my sample workbook.

I should also clarify that I would like this to be a live representation of where I'm at. In my sample, the quantity might be where I am at Monday, and I'd like then, on Tuesday, to enter the quantity at each step after having worked on the assemblies for another day, and so on.

Thank you!

Firstly, what is the figure that you are expecting the calculation to return? Secondly, how are you expecting us to know how much of each stage is complete when you don't appear to have told us what the TOTAL quantity at each step would be? Or am I missing something?

We really need a bit more flesh on the bones here, please.

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.