Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 15 March 2022
  1 Replies
  2.5K Visits
Hi Guys,

I need a help from our community in a project. Please help me :)

Topic: Data Entry for a patient.

I work in a hospital and I need to keep the record of the medicines which I dispense to a specific patient.

For Example:

Patient ID 1234 was dispensed 10 tablets of Amoxycillin, 20 Tablets of Paracetamol and 5 Tablets of levocetirizine.
Patient ID 5678 was dispensed 15 tablets of Amoxycillin, 5 Tablets of Dexamethasone and 2 Tablets of Albendazole.

And 500-700 patients per day like them.

Now I want to get a database at the end of the day which can tell me the patient wise consumption and specific drug consumption so that I can keep a record of the same at the end of the day.

I am not that much technically sound but I hope you guys will understand my pain and help me with an excel module or anything like data entry tool to get me out of this problem.

p.s. I have about 300 medicines in my hand.
8 months ago
Hi anonymousgirl,

To do so, you can make a table to record per day as shown in the picture below:
Note: The numbers are examples, so don't copy them.

After you finish the information (name and price) of all the drugs and patients, you should first make a copy of it. Then in the cell I3 (in this example), enter the formula: =SUMPRODUCT($B$2:$H$2,B3:H3); enter =SUM(B3:B11)*B2 in the cell B12 (in this example).
Note that you should change $B$2:$H$2, B3:H3 and B3:B11 according to the actual ranges in your table. (The dollar signs added to the range reference make the it absolute, so do not delete them.)

After entering the two formulats, drag or copy the cell I3 to below cells, drag or copy the cell B12 to right cells.

Then you can record for the day and see the consumptions automatically updated.

Hope this could help you.

  • Page :
  • 1
There are no replies made for this post yet.