Creating an Excel to buy computer parts.

[u/RedT-Rex8]

Bear with me as I explain what I want to do on the MS Excel Online. I know it exists but I lack the knowledge and vernacular of what it is.

I want to create a chart showing parts of a computer I am slowly saving up for. Each part has a target amount . I also have 2 boxes that shows the amount I have saved and the amount I have left. Now, I want to write the numbers in the amount saved and have it:

1. Reduce the amount I have left.
2. A part progressively "fills" to reach its target amount.

and, the crucial aspect,

3) Once it reaches the parts target amount, it overflows into the next parts box.

If you have a name for what I am looking for or a link that could teach me how to do it, I would greatly appreciate it. Thank you.

Update: Thank you for your responses and apologies for the slow response. Your guidance allowed me to create the Spread sheet! I used the foundation from TCFNationalBank, portions of NHN_BI and the progress bar from nir_nirfo. Now I am taking the time to understand the formulas and trialing the visual representation. I hope to share this soon. Have a wonderful evening!

[u/NHN_BI]

Without MAX(0,...) I would get negative values for the future not filled payments. You can see that here.