A MEDICATIONS TRACKING AND RE-ORDERING spreadsheet

  • Posted:
  • Proposals: 1
  • Remote
  • #686415
  • Awarded
Ali H.
has already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Ali,

This should be an easy one for you...

I need a spreadsheet that will tell me when to re-order medications for my mother. Here is what I'm wanting it to do:

1. Will input starting quantities (quantities of pills she has on-hand currently);
2. Will input "Frequency" of how often she needs to take them;
3. Will input the date and quantity when a new order of pills is received;
4. For "Walmart" medications, will add a two-week period for order processing, & so my sister can then mail it to my mother;
5. For "Canada", will add a three-week period for order processing and mail-time delay.

So the result of the formula(s) need to take into consideration how many pills are currently on-hand; how often she needs to take each medication; the particular processing/mail-time delay (Walmart or Canada); and how adding new orders of pills effects the date of the next order.

I want to be able to have the spreadsheet tell me the date for when we need to re-order the medications.

I've attached a file giving you the data to use.

Michael Dixon
Cell 214-709-1980

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.