Excel

 https://support.microsoft.com/en-au/office/import-data-from-the-web-b13eed81-33fe-410d-9247-1747269c28e4

https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b#:~:text=If%20you%20want%2C%20you%20can,%3AB5%20equal%20%22John.%22

https://www.reddit.com/r/excel/comments/eji3gd/repeating_two_alternating_formulas_down_a_column/

https://www.mrexcel.com/board/threads/formula-to-find-the-value-of-the-closest-non-blank-cell-to-the-left.1011122/

https://www.quora.com/How-do-I-replace-value-with-0-in-Excel