The widely accepted answer for the Monty Hall problem is that it is better for a contestant to switch doors because there is a $\frac23$ probability he picked the door with a goat behind it the first time and only a $\frac13$ probability the he picked the door with the car behind it.
We can look at this problem in a different way. There are three ways of arranging one car and two goats behind three doors, assuming that we do not distinguish between the two goats:
Door1 Door2 Door3
1. CAR goat goat
2. goat CAR goat
3. goat goat CAR
Consider arrangement $1$. If the contestant first picks door $1$ and then the host opens say, door $2$ to reveal a goat and the contestant then switches to door $3$, the contestant ends up with a goat. Thus we have a combination of contestant's first pick, the door the host opens and whether the contestant then switches doors or not. There are eight such combinations for each arrangement.
The eight combinations and their outcomes for arrangement $1$ are listed here.
The contestant gets the car in four of these eight combinations, in two of them by switching doors and in two by not switching doors. The other arrangements will be similar. So considering all three arrangements, the contestant will get the car in $12$ of the $24$ total combinations, in $6$ of them by switching doors and $6$ by not switching.
Analyzing the Monty Hall problem this way we see that switching doors or not switching doors is all the same. What is wrong with this analysis ?

The second choice you list, the door the host opens, is not independent of the door the contestant chooses. If the contestant chooses a door with a goat, Monty has only one door to open to show a goat.
Now that your spreadsheet has been posted, the first four lines are half as probable as the last four lines.