AP Room Rates vs Rack Rates vs General Public Discounts

Is there any place I can find actual historical room prices with AP discounts applied? I’m looking for actual prices, not %. And I want to see that price compared to the room rack rate for that time. Or even compared to a general public discount price.
I’d love to see real examples of previous rates from places like WL or Pop. But all data would be welcomed.

I am considering buying Disney AP’s, which will be a first. I want to do calculations on how much of my discounts received can offset the cost of the AP. (room price, DAH, food, etc.)

If there is a spreadsheet/calculator out there that already exists, let me know!

I assume I cannot view current AP room prices without actually owning an AP, right?