Putting aside the question at #3, the solution is the same as any other mass added/removed problem .. add/subtract the weight and moment changes into the calculation mix and redo the CG division ...
Specifically, for the loadsheet, the process will be defined .. generally either a simple adjustment to the entry data or a correction in the sheet.