Cant get extra columns to follow database when refreshing

Hi there
I'm trying to make report on how members in our alliance is progressing and for that I need to make extra columns in the Table I'm using aside from those from the Database
All was working out great untill new members joined in ...
I'm getting the Data from an External Database on my own Computer

The columns I created doesn't follow the queries I get in .....
How do I get them (Column18/3) to follow the rows when members go up/down in the internal ranks ? (when I click Refresh)
Also is it possible to get arrows to show if they go up / down ?

before.png After.jpg

The columns that doesn't follow up/down isn't pulled from the database no ...
offDBupdate.xlsx

The information is coming a localhost database and is pulled Data>From other sources> microsoft query ... which might be reason that others can't see it correctly ...
D, I, L - columns are inserted manually as I can't get those informations from the Database
When a new player enters the list after I refresh, those columns doesn't go up/down with the Database columns (E, J, M, O) which is my current problem

I tried that and didn't work though I might have done the formula wrong....
but isn't there a way to enter new rows/columns into a Database sheet ??? or is the only way for that to work to do it manually ?

uhhh :p
do you then mean the DB on localhost ? cause that doesn't seem easy
or through the query somehow ?

If I'm looking right then it should be .TRG and/or .TRN not sure which of them is the one to open

hehe thats okay .. but you think that might be the best way to do it?
I can look at the DB through PhpMyAdmin if that can help

hmmm damn now I was just beginning to get the hang of excel... somewhat
Though I thank you for all the help... now its time for me to figure out how to edit the DB