Formula/Button question

W

Wayne Wells

I have an add-in, PI DATALINK, that retrieves process data from our process
database and imports it in to excel where we then massage the data just like
any other. Due to the massive amount of data being stored, I find myself
having to make repeated calls to the database since I can only load about ten
days worth of information without crashing the server. Here is my question.
Currently I am hand typing in *-10d to * where * is the current time.Next
would be *-20d to *-10d, and so on. This is all internal to the formula
string. Is it possible to make a button that contains a formula that will
ratchet up the start and end times with each click. I was thinking that I
would have to reference two different cells instead of having one long
formula with the start and end times in the formula. I am not at work right
now otherwise I would copy over the formula for everyone to eyeball but if
people need to see the exact formula, ask, and I'll get it posted.
 
W

Wayne Wells

Here are the various formula components. In the first instance cell B8 is the
start time and cell D8 is the end time. Is there some way to have a button
increase the two cells by say 10 days at a pop. I have to do this for 1.5
years worth of data on 4 different tags and would prefer to not have to do
the repetative typing if possible

Start Time: *-5d End Time: *
('501fc240.vo' > 38 and '501fc240.vo' < 45)

=PIAdvCalcFilVal($B$9,$B$8,$D$8,$B$10,"total","time-weighted","interpolated","1m", 0, 1, 0,"S769PI01")
 
Top