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

Make yourself an Excel sheet to do the calculations for you.

Posted By: Busy MT'ing on 2005-10-01
In Reply to: more $ for night and weekends - yeah

Not hard to do.

Once I get my packet, I'm going to do that. If you want I'll post when I do that and would be glad to send it to those who want it.


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

You fill out a time sheet. If you need to make a change sm
to your schedule, you just email them.  They seem pretty flexible about everything.

Hope this helps.


calculations
You just have to put in what hours you worked. The system will calculate the work done in those hours. It will mean trusting the computer, but in my time with them, I've never been shorted on lines.
My calculations
I went from being paid for spaces to not. My calculations showed that I lost about 18% to 20% in line count without the spaces.
LOL .. but if my calculations are right, it's over 10 cpl (65ccl). nm

shift differential calculations
Not hard at all, I work all 3 shifts at times, so when I start second shift, I total those before going into 3rd.
by my calculations, 10/78 character is equal to 8.33/65 characters - nm
 nm
?excel
On their ad it says Excel required. Is that just for timesheets? Thanks
or excel
nm
anyone know anything about Excel Transcription? TIA! nm
.
Any information on Excel transcription?
Pay is very low but no weekend work and not married to the computer for hours at a time, does anyone know anything about this company?
Could it be done in an Excel file and attached?
I have to send an Excel log with my secondary account, and I created a column with a formula that sums up my line count so I don't have to add it up. I keep it open while I'm transcribing and toggle over and record the information rather than writing it down, then at the end of the day I just have to delete the unused cells, highlight my totals, then attach it to an email. Seems like that would work well for what you're describing.
More on Excel date/time
Sounds like you don't mind doing it, but if you're curious - check your formatting.

Go to the cell in question, then use the menu: Format > Cells
Make sure the format is GENERAL then close the dialog

Then type in 5:03 (or any time with just m:ss)

Also, try to type this in: 4:63 -- see what Excel changes it to

Good luck Excelling!


Excel logs and adding up job lengths (sm)

This is for the MTs who have to keep an Excel log for jobs and need to add up the minutes transcribed at the end of the day.


I've done some footwork today and discovered a Microsoft page which tells you how to enter times into cells:  http://support.microsoft.com/kb/266691


I haven't figured how to automate it, but basically Excel recognizes minutes and hours if entered in the following format:  hh:mm:ss.  So if you have a 5 minute 12 second job, you would enter 00:05:12 in that cell.  Then at the end of the day you enter the formula =Sum and the cell range (the link gives specific example) and it adds up your minutes and seconds automatically for you. 


I thought I'd share.  I've been adding my account by hand because I didn't know how to sum with minutes and seconds till now.


Excel date/time value vs. format
It's helpful to understand how Excel handles date/time. (In all examples below, you don't actually type the quotes)

Excel maintains a distinction between the VALUE of the date/time and the FORMAT. For instance, when you type 5:12 in cell A3, Excel understands that you mean a date/time value, and stores this as 0.2166666. By default, if you do not specify a date, Excel uses the mythical 1/9/1900 for the date portion, and the time specified.

As another example, go to any cell and type in =NOW(). Excel will store this as a date/time, but format it on screen to your default preference -- mine looks like 1/26/2008 14:23. But if you click on that date again, then go to the Format menu, choose Number, select 4 Decimal places, you will see it change to 39473.6000 -- representing 39473.6 full days from the beginning of time (according to Excel - 1/0/1900).

Bottom line: go ahead and enter your data as just h:mm, then add them up / see if it behaves -- shouldn't require any special formatting....

Also, fwiw - if you have any Excel questions, I would be happy to reply here or answer emails....
Anyone work for Excel Transcription out of IL - send me an e-mail nm
nm
time sheet
You have to keep a time sheet. It's done online and it's pretty brainless to do. I wonder about people who have nothing better to do than complain about things 98% of the workforce deals with.
SPi fact sheet
http://www.spi-bpo.com/web/spi/text_page.jsp?fldr_id=239&service=_Show_All
You fill in a time sheet
but why dread it? attitude is 60% of the challenge (or more). You might just like it better, i do.
No, it is a manual time sheet (sm)

Bonus is paid on total for pay period, not hourly bonus. I never put potty breaks on it, just my lunch break, cause that's longer.


All I got wa a time sheet via email from TT
I don't have anything set up like you do. That would be nice to have that.
Naaa, can put it on one sheet but you'll have a separate
column(s) for ASR figures.
How do MTs get paid if it is not on time sheet. Are they just working to keep
p
Right and if they are offering OT, you just note it on sheet. No biggee.
nm
my instruction sheet says 222 for for slow, 333 for speed.
nm
Luckily, I ALWAYS print out my time sheet, so...
that will be my proof, I suppose. Needless to say, 40 hours is IT for me, lines or no lines. And now I need to start looking AGAIN for a better job, if such a thing even exists. Don't bother lauding TT - been there and done that and with the honesty about them of late I won't go there. But any other suggestions would be greatly appreciated!
Thanks a million!! I guess the spread sheet confused my eyes. :)
nm
Any companies out there where you do not have to fill in a time sheet or on a time clock?
I would like to do my lines and be done, and still get my benefits.  Any companies out there that go by line production rather than hours to qualify for bennies?
No, not a time clock. You just fill out a time sheet sm
with your days and times and lines and email it every 2 weeks.

It really seems to be a great place to work so far -- the people are great and the work has not run out.  I have been paid more, but then again, I am an employee and have benefits and do not have to mess with that tax hassle anymore, so I'm happy.

Good luck in whatever you decide.




I doubt you will make enough money in 5 hours a week to make
nm
I make 4 cents a line, work part and make
over $500 a week on part.
Great post! I make 0.085 at Keystrokes and make more than at any sm
other company in the last 5 years. Why? Because there is always work for me. I love starting work each day, knowing that the company I work for appreciates me and has plenty of work. Transtech and Keystrokes sound very similar; those of us that work for either can count our blessings that we are not part of the cesspool or huge corporate mess that makes up the biggest few companies. We do not have to worry about our jobs getting sent overseas and we see a future in this business!!!
Yeah, but we don't make what docs make. nm
nm
But we don't even make what in-house make.
It would be different if we made the same as the in-house MTs.  In a lot of cases, most of the people working in-house make much more including benefits than we do at home as full-time employees.  That's where I think the unfairness comes in.  The in-house employees don't all work every single weekend.  Most of them rotate at a much higher salary and much better benefits.  The MTs at home are expected to fill in for the in-house for less money, less benefits and give more and more back in the form of weekends and holidays.   Most remote MTs only receive benefits contingent on production, and even then they're not nearly as good as in-house benefits.  How is that equal in the healthcare team perspective?
you might want to make sure you don't make yourself look like an IDOT before you go any further.
/
I make $1.10 per report and make much more sm
than by the line. Day by day it varies and goes back and forth, but over a long period, it is better by the report. Make sure they pay links though; this is key.
Do Shapin MTs really only make 6 cpl and QAs make 1.5 cpl?
/
Why can't you make money with all OPs? I do all OPs and make
good money.  I'm not with WebMedX though. 
I'm happy with what I make. I still make more than if I went anywhere else and hardly noone in th
biz gives raises so I feel blessed that I make a lot more than most, raise or no raise.
And always make sure you don't make line
counts that amount to anything.  They always place you with impossible ESLs as soon as you start making decent money. 
I make more than that with Spheris but never have work. I would rather make $1.25 and have work. s
My SIL works for KS, and she gets paid double for linked reports too. Where do you get $2.25? I am ready to leave Spheris.
Make sure you have some (sm)

money saved up so when they don't bother to send your paycheck or give you excuses, run out of work constantly or take a long time setting you up, you won't go bankrupt.


 


Okay, those using DQS, how do you do it? How do you make (sm)
your line count?  How do you everything???  Is Instant Text V Pro anything like Smartype where you key in a few letters and the list comes up?  I'm so stressed from trying to learn this program.  Any, and I mean any, positive pointers you can share would so oh so appreciated!!!  Please help!
Did you make more as an MT or are you
nm
make, not may nt
 
Well you would still make more if
you typed 15,000 instead of 11,000.
I make even less than that for IC . Nm : (
x
PS - I make top $$
well over 0.10/line on one a/c. Nobody does 20-25 reports/hr on this 100+ MD a/c.
Why not? Do you think they are just trying to make themselves look better on the
to all the outsourcing talk? It's okay now since they got a bonus?

None of what they make you go SM
through is really worth the job you end up with.  It's a very average place, with average work, average pay.  You can do the same elsewhere without the hassle.
How much do you make (FT or PT)? (sm)

and how are you paid?


see and I say take the IC, just make sure
you have a professional prepare your taxes and find a CPA who is up on at home business laws. I have been an IC for nine years. I get to write off a portion of my mortgage payment, utilities, etc. It works for me.