I am performing the Huff model with 10.000+ facilities and dwellings. As a result, each facility has a value between 0 and 1 that determines the probability a consumer patronages a facility from a certain dwelling. The script generates this value for each store, thus I end up with 10.000+ probability columns. Now I want to add all these probabilities in one accessibility field (per dwelling), since the I am interested in the accessibility from a consumers´ perspective. Is there a function available where all the values are summarized into one field, but exceptions can be given? E.g. Sum all variables horizontally (rows) into one field, where certain columns can be excluded?
Ps. The HUFF-model script also generates a sales potential column per facility in an adjacent column (next to the probability column), which is copied from another cell. This leads towards unnecessary fields. Is there a shortcut to delete all columns that contain facility_X_"SALES". Or can be this be deleted in the HUFF-script?