Announcement

Collapse
No announcement yet.

Follow up patients without EMR

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Follow up patients without EMR

    I have designed a spreadsheet that can be used to follow patient's labs, outstanding tests, dictations, consults.
    It's provided as is, it's free, no warranties, but I will give support on here if needed

    BD
    Bigdoc

  • #2
    EMR w/out EMR?

    Why not use Access as it will let you do much more with the data, including custom input forms etc?

    Not being critical of your choice, just a suggestion.

    JW

    Comment


    • #3
      I don't have Access at work, yes that would certainly have been my first choice
      Last edited by mel; 07-24-2004, 09:25 PM. Reason: typos
      Bigdoc

      Comment


      • #4
        Excel/Access

        Depending on how you set up your worksheets, you may be able to import things from Excel into Access at a later date. MS Office Pro will have both for a couple hundred dollars.

        Keep on plugging!

        JW

        Comment


        • #5
          Patient follow up with an Excel Spreadsheet

          For those of you without an EMR and on a budget, here is a spreadsheet I am using to follow patients in my practice. I dont have Micro$oft access, I would have designed this in access, but this has been working perfectly for about 4 months now, I have several improvements coming, and do not plan to charge anyone to use it. Feel free to replace your lab book with this spreadsheet, the advantage over the book will become clear very quickly.
          Few basic instructions, this workbook uses macros, so you need to have them enabled.

          You enter a new patient from Patients menu -> Patients -> Add
          You go to the first worksheet where you select the patient from a dropdown menu, and select the patient, date test ordered and details about the test, Saddam for instance has had a PSA and a CBC drawn, I only have his CBC back, and have not informed him yet of the results. When you inform the patient (3 ticks) and you hit archive patient, the entry will be moved to archive, where you can always look to see what labs were done when. The archives worksheet has not got code in it, meaning you can purge it manually if you like.
          When you have several patients, you can order by patient name, so you can see all the labs, tests, consult for a particular patient that are still pending before you go in to see the patient.
          My worksheet is up to about row 300 with about 200 patient entries, but it still very manageable, I purge it once every 2 weeks, by looking up which patients I may not have informed of their labs (Can come in handy when u have high volumes such as Pap smears) and click on all 3 columns, then purge. If you have any questions, please do post them on here, I will answer them as soon as possible.
          Until you are very comfortable using the spreadsheet, get into the habit of printing a copy the 1st worksheet every so often, and please do backup the file on a frequent basis. I do have mine on a server shared drive, my nurse has read-only access to it from her computer.
          Enjoy
          Attached Files
          Bigdoc

          Comment


          • #6
            To get maximum benefit from the worksheet, you need some basic knowlege of Excel, you are able to copy and paste which makes entering patient info quite painless, I'd like to get a feedback from anyone who has tried the worksheet.
            Bigdoc

            Comment


            • #7
              You need to fix the date

              Comment


              • #8
                Guys, we need more feedback from the 57 members that have downloaded the tool, Ozzie is kindly updating it for us, for free, please email or PM comments or suggestions
                Bigdoc
                Bigdoc

                Comment


                • #9
                  I tried to download the xls and I get this error
                  snip
                  ozzie, you do not have permission to access this page. This could be due to one of several reasons:

                  Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
                  snip..

                  i was trying to work with the xls but I think last time i saved it I did without the macros so i need a clean copy to work from..

                  Comment


                  • #10
                    i'm getting an error too

                    Comment


                    • #11
                      i also got error

                      this file is corrupted or something to that effect

                      Comment


                      • #12
                        Originally posted by fpmdtx
                        i also got error

                        this file is corrupted or something to that effect
                        I'm updating the file, will be back online in a few days
                        BD
                        Bigdoc

                        Comment


                        • #13
                          Have you fixed the tool yet?

                          Comment


                          • #14
                            We will have an updated copy of the file very soon
                            Only Docsboard Registered Physicians can download it
                            BD
                            Bigdoc

                            Comment


                            • #15
                              Originally posted by MHDoc
                              Have you fixed the tool yet?
                              Yes it is fixed, and a newer version will be out soon
                              Mel
                              Mel
                              There is no place like 127.0.0.1

                              Comment

                              Working...
                              X