I understand your point and am inclined to agree on the whole. However, even considering that we are muttling up the situation with generalizations that cannot in any real sense speak to the reality, I think it unfair to say that being unable to understand the intricacies of female thought is a result of applying a spreadsheet mentality to it. It might be more fair to say that human relationships do not abide by deductive reasoning. That may be what you are saying when you emphasize "assigning numbers", but I'd argue it is not the same thing. "Assigning numbers" is an -GAG!- application.
Find a woman who will be happy to hear "Come, let us reason together" and you have found an unusual one, if not unique!
It is a fair criticism, imo, to say that too much emphasis on reason blocks an appreciation of a genuine life. But in my experience, very little of a woman's conclusions about anything are based upon an application of logic. To be sure, they "feel" more than we do, on the whole. The trouble is in trying to understand them, you must abandon your normal approach of studying the facts, agreeing on premises, applying logic and coming to a conclusion and instead try to figure out how a position makes you "feel". "Does that make sense?" is how, I think, most men look at anything while "How do I feel about that?" is the approach most women take.
On the whole, men who try to "figure women out" fail because of their method. They apply reason as the means to figuring them out and reason, on the whole, does not apply to the way a woman thinks.
Of course, this discussion has diluted into sweeping generalizations. But most, of course not all, women I've known fit the above.