Home     Contact Us    
Main Board Job Seeker's Board Job Wanted Board Resume Bank Company Board Word Help Medquist New MTs Classifieds Offshore Concerns VR/Speech Recognition Tech Help Coding/Medical Billing
Gab Board Politics Comedy Stop Health Issues
ADVERTISEMENT




Serving Over 20,000 US Medical Transcriptionists

Hmm - care to share the spreadsheet?

Posted By: The Other Sunshine on 2008-02-07
In Reply to: I also made a daily spreadsheet - jmr

Is it in Excel? Does it tally for you? This would be awesome to have!


Complete Discussion Below: marks the location of current message within thread

The messages you are viewing are archived/old.
To view latest messages and participate in discussions, select the boards given in left menu


Other related messages found in our database

Care to share
x
Would you care to share
nm
would you care to share who you IC with?
if you do not mind.  Thanks. 
You wouldn't care to share
the name of your "awesome" company, would you? I have to find something stable and secure, making at least what I do now (8.5 cpl), with some flexibility. I have worked from home for 7 years now, and have only received one or two phone calls in that time about a mistake I made on a report; otherwise have had positive comments from my QA.

I absolutely loved my job and company until 01/01 when all H**L broke less with MQ.

I'd like to continue working from home, so I can keep volunteering at my boys' school (they're 8 and almost 10 years old), and be here for them when they're sick, off school, etc., but if I can't find a good company, I'm afraid I'll be forced to join the 8-5rs working outside the home. Then that would open up another whole can of worms, such as what to do with the kids during their days off/summer vacation; when they're sick; etc.

I don't blame you if you don't want to give the company's name out, so as not to have an avalanche of applicants with them. I guess I just needed to ask anyway!

Glad you found a good company. Hope I can, too! :)
Care to share the name of the company??? nm
x
Care to share your method and/or company?
Sounds like you might be in Radiology. Appreciate.
Anyone care to share name of Company that pays so much?
I'm interested
Care to share the recipe for the meatloaf?
x
Care to share the cake recipe?
x
care to share? i have been struggling with the same thing. nm
;
Would you care to share the eggplant parmesan receipe?
x
Line check, anyone care to share where you're at this morning.

Would anyone care to share where you work? I love OPs, but do CONS and DS all day.YUCK! nm
x
Care to share the charity that doesn't pester after receiving a donation? x
x
What spreadsheet program?
xx
excel spreadsheet
It is a simple Excel spreadsheet with 5 columns. First column is the date. Second column is daily lines. Third column is lines to date. Fourth column is daily money. Fifth column is money earned to date.

I'll just give you the formulas of how I did mine, but I start at cell B5 for first date and all formulas are based off that. If you start someplace else, it won't work. Also I have a 15 or 16 day pay period, so I keep this at 16 days.

In cell B5, I put the first date of pay period. Then copy cell B5 and paste down the column from B6 to B20. Excel will automatically change the dates down the column. On the next pay period, I only have to change the first date, and the rest change automatically.

Column C is for input of daily counts, so nothing to do there.

In cell D5, I put =C5. In cell D6, put =C6+D5. Then copy D6 and paste from D7 to D20.

Column E is daily money, so I will give formula with a 10 cpl rate. But obviously, put whatever your line rate is here. In cell E5, I put =C5*.10 Then copy E5 and paste from E6 to E20.

Column F, in F5 put =E5. In cell F6 put =E6+F5. Then copy F6 and paste to F7 through F20.

I also have totals at bottom. In cell D22, I put =D20. And in cell D23, I put =d22*.10 Those are formatted in a big, bold font so they jump out at me.

Long-winded but if you know Excel and use the same cells as I, it should work. I start in B column because I think it is easier to read, and I have headings, titles etc. in first 4 rows.


I also made a daily spreadsheet
that I plug my daily line count into, and it gives me a daily and to-date pay period earnings total. I just keep updating all day with my counts until I reach my goal for the day. I also see my pay period total and figure out how close I am to paying off those bills.

When I having an especially good day, it really motivates me because I see the numbers going up quickly and I just want to work more.
Depending on what is wanted by the office, I have an Excel spreadsheet-sm
that has the date of service, pts name, line count. At end of pay period, I total lines.

Then in a Word document that looks like this, I fill in info and send in for payment---

DATE OF SERVICE: ---- TO ----
TOTAL LINE COUNT:
AMOUNT DUE:
DATE OF INVOICE:

I then print and keep both sets.
Congrats, girl, and get your share of any money that you share before he wipes you out. nm
s
Share, share, I've been looking for some time...sm
sending out resumes gallor, have great experience, but they sound like clones of each other in what they offer, yet what they want is it all!!!  I'm so discouraged, in the depression boat myself!  They want you to commit to FT, new equip, DSL, on and on!!!
Kinship care versus foster care/adoption
Having been placed in a position where I now have custody of my 3 YO granddaughter and going through the legal system, I sought an online network of relative caregivers for children. I would encourage you, especially since you are in Georgia, that if you take any children into foster care with the idea of adopting them, there is federal law that requires the state to take certain actions in a specific time frame. When a child is removed from it's bio parent(s), the state is required to investigate any possible relatives who can take the child before foster care is considered, but even before that, reunification with the parents is the priority. Once a child enters the system and is in the system for 15 out of any 22 months, the state is required to find permanent placement for the child.

The problem with this is that there are case workers who may favor a foster family and do not seek out relative care. I have a good friend in Georgia who had to fight all the way to the state level to get custody of her grandson after the child was placed from the hospital into a foster care home with the promise that the foster parents would be allowed to adopt. She has now adopted her grandson, but it was a long, hard battle to get the state to admit their own interests were placed above those of the child and/or family.

If you get a child placed through the state, please make certain there is not a relative who wants that child before you get your hopes up. The courts are now favoring return of children to relatives even after a child has spent years with a foster family who hoped to adopt them.

States get bonus federal funds by complying with the time lines and being able to close the case, so some states place children in foster care because it is easier than trying to locate relatives.

Didn't mean to go off on a tangent, but I can't imagine my sweet bella going to someone outside her family.
If it was a clinic, it might have been urgent care, but it was NOT acute care. sm
Acute care refers to work in an acute care setting, a hospital, doing at least History and Physicals, Discharge Summaries, Consultations, Surgery notes, Emergency Department notes, and much more, including GI procedures, Cardiology procedures, Neurological procedures, Pulmonary Function Studies.  It goes on and on and it means and acute care hospital setting, not a clinic.
I always figure if they don't care about their dictation, they probably don't care about their
nm
Dont care how many languages you took. Care
x
oh, so if I don't care about my job, I "should" care
you come off as narcissistic.
Please share...
Favorite small appliance.  I have 2 jobs now, love my crock pot but am looking for something a little more versitile... Something I can  throw everything  into in the morning and just set it and forget it! Any suggestions? Thanks!
share
share any work ??
share
That is great pay. Where do you work. I read so many people who love where they are but yet no one shares the info. I have been looking the past few months but have yet to find one that starts out with a decent pay. I would have to take a cut in pay just to get more flexibility which I don't think is a fair trade.
Share what?

Our jobs that are limited as it is?  So when we all lose our jobs to people in India, China, etc., can we assume you personally are going to share the money from what used to be our jobs with us so we can keep our homes and feed our families?  I think not.  Transcribe for your own damn doctors and leave the American patients to us.


yes please share with us !

Just had to share

Our Rottie had puppies Saturday morning!!!!!  11 in all,  6 girls and 5 boys.   We lost a baby girl yesterday morning, but the rest are doing great.  We're exhausted, but they're fine.  They're sooooo cute.....


Yes, please share
info about this.
Share What?
There are a lot of claims by a lot of MTs that cpl is the only way to go, and claiming that they are being paid more than most astronauts, but being given a salary/hourly rate to be recognized as the professionals that we are would be nice. When I started out the main issue was understanding the content of what you were transcribing and it was expected that you kept updated on all new terminology, meds, etc. You definitely would not find a nurse or other professional agreeing to be paid by how many blood draws they do and yes, it does boil down to the same thing.

Happy Thanksgiving Everybody!
had to share, doc just said...sm
The patient was taped to the operating room.....   Wish I could see that!
Let me share with you....
not really sure what you mean by the long-time MTs getting angry, maybe you can share- I didn’t have internet at all prior to 2004. OMG but made really big money years ago and has it ever dropped now days! But back to sharing… my grandkids who you know can show us all we need to know about the latest gadgets, computers, blackberries, whatever went with me up to my father's home. He was in his late 80s then. I asked the 14-year-old gdaughter to go in the bedroom and call someone for me. She went back but soon returned to where we were and called her brother, a 16-year-old with a puzzled look on her face. Finally the both of them came back into the living room and said they had no idea how to use granddaddys phone- it was a rotary. Laugh, laugh. See it is all when you grow up and with what.
yes PLEASE SHARE
We would all like to work for a great company to! Email me if you prefer.
Just have to share - sm
I have a discharge summary - the guy was in the hospital for a month.  It's 42 minutes long.  The doctor is dictating every consult that saw the patient every day, their impression, and then just reading the assessment and plan, numbering the recommendations, and then....."Thank you for allowing us to see this patient."  Do they even think about what they're dictating???????
had to share this one!!

"She wil be put in an Aircast splint and with crutches and treated with Motrin 800 every 8 hours as needed for pain with food."


often HR will share your ap

Like, I applied for coding and ended up being recruited as an MT (and they never DID fill the coding position as that department was undergoing "internal issues").


Although it is a major slam when you apply for clerical work you get pushed towards being part of the janitorial staff!  Do you have very little MT experience?  I could understand if they offered you something in medical records, but wow, that's quite a leap to think you'd want to wash dishes!


just had to share this one - s/m

a local college has a job posted for an ESL instructor. Any takers?


had to share
ESL dictates, "MRS. So-and-so is a 10-year-old female."  Might be able to be a MRS. in your country but not in the USA.
Could you please share
the name of this company?  It sounds an awful lot like what Medquist is doing to us.   Thanks in advance.
I think you and I share the same sm
sense of irony! I totally get where you are coming from... :)
How funny. I have my share as well and when I
was trying to break my boys of the habit of leaving their dirty clothes wherever they took them off, I wondered how much it would take.

I taught them to do their own laundry when they were about 11 or 12 and then I stopped doing it for them. They were in control of it; if they didn't get it done, they wore dirty clothes.

However, they had a bad habit of taking their socks off in the living room and leaving them there, or in the bathroom and leaving their clothes there. They had clothes baskets in their rooms and in the laundry room for that. I would ask them to pick up and it was always, "later" or "in a minute" but those times never came around.

Finally, I started telling them one time then when they went to bed or left the house and it was not done, I started collecting those things in an old shopping bag. Each night I would quietly put the bag in the trunk of my car. I mean this went on for a few days...quite a few. They had a tendency to wait until the weekend to do their laundry and I remember the frantic desperate search for their clothes. They couldn't find them! Hadd I done their laundry? Nooo. Had I seen their clothes in the bathroom or their socks in the living room? Nooo. They were accusing each other, even! Hahaha They had practically nothing left to wear. HAHAHA I finally told them to bring in the stuff I had in the trunk (of course, they delayed all day on doing that -- all day while they were whining about not finding their clothes and it could have been resolved earlier) and when they did, they had a few bags of dirty stinky laundry! Hahaha I told them next time, I would not store it in the trunk of the car but store it in the garbage dump. They have done pretty well since. On occasion I ask them to pick something up and they realize if it isn't, it goes out in the garbage without another word. Hahahaha
Please share which program your are using.

From what I have read, it seems that EditScript is the only VR program that seems to work quite well.  I hope this is not the one you are using.  Could you tell us which one?


Well, share in the wealth, how?nm
x
can you please share what you found out
That would be greatly appreciated.
Share your secret, PLEASE!
Who do you work for? I used to do that, but got a crappy account now. I miss those paychecks.

You have every right to be happy. I'm happy for you (and jealous LOL)!
Had to share this e-mail (sm)

Little Johnny says "Daddy, how was I born?"


Daddy says "Well, son, I guess one day you will need to find out anyway.  You see, your mom and I first got together in a chat room on MSN.  Then, I set up a date via e-mail with your mom, and we first met at a cyber cafe.  We sneaked into a secluded room where your mother agreed to download from my hard drive.  As soon as I was ready to upload, we discovered that neither one of us had used a firewall, and since it was too late to hit the delete button, nine months later a blessed little Pop-Up appeared and said You've Got Male!"



Let me share my dog story...
Our little girl was scared to death of animals!! Especially dogs. A dog showed up on our porch and we did everything we could think of to get rid of her, i.e. throwing shoes at her (that was my daughter's idea), shooing her away. We didn't feed her hoping she would move on to the neighbor's house. Anyway, she didn't leave....she adopted us! After a couple of days, my daughter became more comfortable with her (she finally stopped crying whenever the dog was in sight) and we fell in love with her. She is a real doll!! Needless to say, that was six years ago and the dog is still just as sweet as ever.

With that story told, have you called the game warden? They will come and get stray dogs. Maybe they can find out who owns her? Also, an area SPCA would take her. Just a thought. Good luck!!
Would you share the exact name -sm
of this keyboard? I'd like to find one with wrist rests like you describe. I have one that is split, but the wrist rests are quite right. TIA.