I am working on a report at work and need to determine the atmospheric pressure for small intervals over a 24 hour period. Searching Google, I've found charts which give a base pressure of 14.65 psia at sea level. This is at 68F. That changes to 13.17 psia at 3000ft above sea level.
What I am looking to do is create a spreadsheet where I enter the elevation as a constant, then provide the temperature (F), then have it calculate the atmospheric pressure. Knowing it is 13/17 psia at 68F is useful only if the temperature is 68F for the entire 24 hour period, but it isn't. Currently it ranges from 30F to 75F but could move either direction substantially depending on time of year.
Is this possible to determine?