The wiki numbers are outdated. The system got updated in patch 211. The coin numbers were doubled, but you get less footfall for returning visitors and also less footfall overall the more visitors your beacon has.
(most of the numbers in the spreadsheet were calculated once we had figured out the math, only the black numbers were proven through testing)
If you have multiple beacons in one settlement you can not get footfall from the same visitor twice per day, only the first beacon visited counts. Players that have permissions on your beacons don’t generate footfall, only visitors.