Just spent a couple hours revising, updating, and improving my spreadsheet.
Now I have a summary tab that, using the master tab, shows--
In increasingly specific order:
--Total global available credit* between all users**
--Total global available credit per user
--Total available credit per user per bank
--Total available credit per user per type***
--Total available credit per user per bank per type
*Available credit = total credit line extended by bank on open cards, regardless of current utilization
**Users = AJK + Mrs. AJK
***Type = Personal + Business
All of which is updated live based on figures in the master tab. Thus, at any given moment, I can tell you (i) how much credit I have access to from a
global perspective, (ii) how much
personal credit is available to me that can be seen by banks who pull my report (they cannot see business credit as you know), all the way to (iii) how much *personal* available credit *I* have at *Citi.*
I find this info useful as it provides me with a quick snapshop of my current credit profile vis a vis the banks.
For the visual learners:
(Note: Data has been randomized and unformatted to protect the innocent)
I also, for the heck of it, added a portion on the summary tab which shows how many miles/points each of us has earned since inception and the total of all miles earned from credit card signup bonuses.
Possible add for the future: Import award wallet figures so I can see total current mileage balances per user. But for another day.