09-23-2017, 07:50 AM
|
|
Expert
|
|
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
|
|
A nagging date/recurring event proof?
I think Excel can quantitatively resolve a nagging problem/question. Presuming so, the involved Excel mechanics are way above my ability.
Given:
- I request a prescription to be written every 90 days for a medication that requires the pharmacy (mail order) to be in possession of the physical prescription and not a fax. The prescription must be mailed.
- USPS transit + pharmacy processing time = 2 1/2 weeks.
- The provider had written the prescription several times. For each subsequent refill prescription after the initial, he would write the prescription 2 1/2 weeks in advance of the end of 90 days and I would mail it.
- Then the provider said he would stop writing the prescription 2 ½ weeks in advance. Going forward, as long as the prescription was written 90 days from the date he last wrote it, the 2 1/2 week transit/processing time was now 'built in' to the time frame.
I’ve been coming up a bit short at the tail end of the 90 days. Either I’m inadvertently taking extra tablets (5/day) periodically or his ‘the 2 ½ weeks are built-in’ isn’t.
I’m hoping that Excel in the proper hands can resolve the question fairly simply?
Mark
|
Similar Threads
saving a Proof
Windows 7 64bit 
Office 2016
Hybrid Mode