Trust your gut instinct over spreadsheets. There are too many variables in the real world that you simply can't put into a spreadsheet. Spreadsheets spit out results from your inexact assumptions and give you a false sense of security. In most cases your heart and gut are still your best guide.
That said ID does not qualify as science because it gives us nothing to test or measure. Science requires replicable tests involving measurable variables.
Study after study confirms that even when you control for variables like profession education hours worked age marital status and children men still are compensated substantially more - even in professions like nursing dominated by women. No wonder there's a gender gap.