Creating an auto-fill formula with currency conversion

Hello r/excel
I recently created an excel document for my Dungeons and Dragons group
to track inventory items / loot / house bank etc and I thought, "Hey it would be really
cool if there was a way to convert and condense the in-game currency to a sum total inside the document."

Admittedly I am very new to formulas in excel and I have been reading up on the basics though I
feel like this one is a bit more tricky so I think I need someone to hold my hand.
The conversion of gold copper silver + the sum of all of them into gold pieces seems to
be throwing me for a loop.

So simply put, I am trying to Convert Copper, Silver, Gold, Platinum (Common Currency in D&D)
and their values into gold pieces then total it all up in the final cell.

The values in game of each type of currency are as follows

| Copper | Silver | Gold | Platinum ---------|----------|----------|----------|---------- CP | 1 | 1/10 | 1/100| 1/1000 SP| 10 | 1 | 1/10| 1/100 GP| 100 | 10 | 1| 1/10 PP|1000| 100| 10| 1

Thank you for taking the time to read this and I apologize for any formatting issues or other noob errors in my post :)

Edit : Thank you for your hasty responses! I am going to check out all of your provided solutions and see which works
best for our application.