Assistance in correcting ranking formulae

So several years ago, I worked with someone to develop a spreadsheet to help me with my ADHD as I couldn't find anything suitable in the marketplace.

Well, we had some complications and never finished it and it sort of faded into the background. But now I'm revisiting it as it's more necessary in my life than ever. I need the help of a master user to fix it.

The Expected Result: The spreadsheet is supposed to take several determining factors and provide a final rank for a list of items. And as the items are 'closed' it should remove them and re-rank the remaining items. It's not doing so and that's what I need help with.

You may private message me with any questions or for the spreadsheet. (I am not able to provide attachments to posts on this forum.) Thank you in advance for any help you can provide!

Advice

Remove you e-mail adres, otherwise you can get a lot of spam on your adress.

I bet you get better help if you add the file, without confidential information on this forum.

Please also add the expected result in your file.