Depending on what is wanted by the office, I have an Excel spreadsheet-sm
Posted By: Debra on 2005-07-04
In Reply to: Need help with invoice... - DG
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.
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
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.
My office did not allow feedback. They just wanted us to push the numbers. They just did not care.
They don't care if you get it or not as long as it is fixed by QA.
What spreadsheet program?
xx
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.
Hmm - care to share the spreadsheet?
Is it in Excel? Does it tally for you? This would be awesome to have!
New. Wanted to put in a better card to support a game my 17yo DD wanted to play.
x
Yes, I have Excel
but I am a total Excel n00b and don't use it if I have to. Is this something that can be converted to an Excel file, sorted there, and reloaded to MSWord?
Go to the Excel help and in the
It will bring up a list of different instructions for labels. Hope this helps. It really is not very hard to do. Good luck
You can do this if you have Excel.
There are templates on the MS site that you can download to make your forms look more professional.
Excel nm
nm
Excel
After you do your one cell with multiplication/division formula, just copy it to the ones you want it to work in. Copy and past.
Excel question
I know a little bit about Excel, but not a whole lot. I'm trying to learn from books and through trial and error, but it's slow going.
So here's what I want to do: I need to set up a spreadsheet so I can record date, exam number, number of characters, divide number of characters by 65 to get number of lines, multiply lines by 10 cents to get amount for each report.
I know how to set up individual cells to divide or multiple, but how do I set them up for the entire spreadsheet, or at least within a range of, say, 100 cells/rows?
TIA! 
If I read you right - Excel ?
If I am reading you correctly and if not sorry --but if you do not need every report divided but the entire month or a section of the spreadsheet -- what I do is I enter the lines and at the bottom I have a total of B1.B65 (sum=(B1:B65) then the next cell I have it * my cpl (I have gross lines) but if you are doing 65 cpl, then you would put in your total characters, the spread sheet would total on line B66 and then B67 you write formula to divide sum=(B66/65)by 65 and then B68 would be sum=(B67* cpl). I enter daily line counts by doctors and have then total vertically and horizontally so I get totals by doctor and by day and then month total. This probably sounds very confusing but you can E-mail me if you have specific questions. Patti
don't have Excel, but working on it.
Thanks for your help. It took about 20 minutes to decide whether or not I have Excel on my computer; wasn't even sure where to look. I found something called openoffice.org that looks like a generic version and I'm trying to see if that will work. If not, I suppose a trial version, just to get the list organized, right? Thanks so much for your help!
Making labels in Excel sm
One of my clients uses Medical Manager software and they want to make a list of docs in Excel. I don't think you can copy from Med Man but is there an easy way, say out of the "Little Blue Book", etc. to make labels or at least addresses of area docs without killing oneself? E-mail or just answer on board, I am trying to help them and save them some time. They are insisting on using Excel and I don't know that program. 
I use an Excel workbook file
on my laptop (not the work computer) with 2 different spreadsheets for each account. I list dictator-specific shortcuts and notes on one, and general account specifics on the other. I also have one spreadsheet in the workbook for "terms"...with multiple columns for different categories (derm products, lab nomenclature, vaccination drugs, etc.) Finally, I have a worksheet for "blanks" with specific but common quotes from dictators and the correctly typed translation.
I am up to about a dozen spreadsheets in this one workbook file, but it is quick and easy to bring up the one I need and keep it in front of me as I move from client to client. Good luck.
Fastest/safest way via Excel
Assuming:
- your physician names in a table / list with firstname, lastname, specialty, address1, address2, etc. in their own columns?
- you are able to sort / modify the data
- you are interested in having a better way to find the ESL / "difficult" spellings
a. Which tool to use for list management?
I strongly recommend you keep the raw data in an Excel table for safety and speed of sorting. I just ran a test with just over 14,000 rows in a Word table - for sorting by specialty/last/first name. In Word, it crashed once and took more than 3 minutes to sort the second try. Same function in Excel is stable and takes only seconds.
b. How to most safely sort the list?
You can use VERY simple macros within Excel to select the entire list then sort by:
- last / first / specialty
- specialty / last / first
- etc.
Then, assign each macro to an on-screen button labeled according to how it sorts, e.g.:
[sort by specialty] [sort by lastname] [etc]
c. What about "difficult" last names?
You could add a column to the list for "sounds like" and as you encounter new physicians whose names don't look like they sound, enter what the physician says -- or what you would guess -- the name sounds like. You could enter a representation of the whole name, or just the first couple of syllables, e.g.
- for written Wojcicki use a sounds like of voychits or voychitski
If you are interested in getting these (or some variant) into practice, reply here or contact me off list, I'd be glad to help further.
Excel works great too, has a template too.
xxx
Is each address on a separate line? And do you have Excel?
/
I made up my own abcz list; based on yrs of how it's already stored on Excel.
You need a macro to rearrange the name. Excel makes it easier to extract first or last names. nm
x
wanted to try it but wanted to make sure
nm
Have most people had good luck with their MQ office closing and moving to the regional office. Have
things gotten better or worse for you.
Yes, I lost mine. I upgraded the Office 2000 package to Office 2003. sm
I have over 2000 autocorrect entries and lost them all as well as my supplemental dictionary for my Stedman's spellcheck. Lots of grief!
Maybe you will be lucky and not lose anything. Good luck to you.
Might be able to rent one from an office supply or office machine repair shop
s
I gave a tin of toffee for each office and a Lia Sophia necklace to each office manager. ~nm~
x
I gave a tin of toffee for each office and a Lia Sophia necklace to each office manager. ~nm~
x
I do too, sometimes $50-60, depending on the day! nm
x
Depending on where you are sm
Experienced radiology MTs can be hard to find. I work for a local MTSO as a rad MT and my workload recently doubled so we have been looking for someone part-time to help with the extra work. It has been very difficult, and we are searching nationally, not just locally.
So I would say if you have someone lined up to do the work, go for it. Otherwise test the waters and see how many resumes or applications you get and how much experience those who are applying actually have before making a decision like this.
Just my 2 cents.
Oh, and I have been paid both by the report and by the line. I much prefer getting paid by the line.
Does the same to me depending...
on what kind of sound file I'm opening. Other times it doesn't do it, but sometimes it does because it's going through some conversion process. I think it might have something to do with a codec but would like to know how to avoid it as well.
I do anywhere from 20 to 30, depending on
the dictator and type of report.
Office politics. That is why I enjoy working at home. In the office,
people are in other people business. Just mind your own business.
Depending on the company....sm
you would probably finding yourself typing as much or more than in a MT role. With the companies I've supervised with, there were not only the generalized e-mails to the MTs but also those answering questions from clients as well as employees. I currently receive 150-200 e-mails a day alone to respond to, plus do a lot of other typing with the various aspects of the job.
I suggest you talk with the HR department at the company you work with to see if there is a position you can apply for that would be less typing.
Actually, you can get one for about $500+ depending on the purse.
nm
Depending on where you live in the US, sm
I think its a good deal. The great thing about working for a hospital is that once you add all their benefits (health, dental, vision, 401 K, etc.) you are much making much more per hour. My wage is very similar to yours, but if I add all my benefits with it, I making more like 25.00 an hour. They cover my spouse and children for insurance as well.
Yup - 3 to 4K, depending on the day and the dictator. NM.....
Yes it is possible, depending on how good....
incentives are. It was very possible with MQ pre 1/1/2006. Now it's hard to make $20 an hour, let alone $100,000/year.
I average anywhere from 350-400 lph depending on the day! nm
x
DOE = depending on experience
nm
depending when you filed,
I used to Efile with them every year, and it was always the 2nd Friday from when I filed that I got my refund, but if it was towards the end of the week, thurs/fri, it may be the 3rd, which would be about 2 full weeks. Good luck!
Depending on your company...sm
they will go by different names, or titles. But its usually your supervisor assigning the work. Most are called Lead MTs and often are the direct supervisor for each shift -- thus assigning the work. The QA has no part in assigning work... they are there for that specific function only, for the most part. HINT: WHOEVER HAS RESPONSIBILITY OF ENSURING TAT -- that's you gal (maybe guy) -- that assigns the specific jobs. The Lead MTs also have their own lines to make... and will usually keep the best for themselves. If you work on more than 1 shift, you'll notice this.
Don't believe for a moment, though, that jobs are assigned at random, first come, first served... just look at the time/date of the transcription. I, myself, have been known to e-mail a Lead and ask why I was getting the sh---y work and cc'd the supervisor. Often works bec. they're not supposed to be cherry picking for themselves.
I avg. anywhere from 3-5 minutes depending on the dictator-nm
x
i dunno, maybe 20? it varies depending
on hot topics, mental duldrums, needing breaks from bad dictators, etc. Its usually very momentary.
it does matter depending on what part of LA
Shreveport pays much less than New Orleans. There are some backwoods towns they still use tapes in the hospitals, so I do not need to tell you how much they pay - I'm sure you can guess. Outside of New Orleans can pay better than certain hospitals in New Orleans. Oschner is not, in my opinion, very good pay - $12/hour to start
Try FT for a service as an employee. Depending on your
area of expertise, many are flexible as to hours and offer insurance. Not cheap, but with kids you need it no matter what.
No to tax relief agencies. Depending sm
on your situation, you can do this yourself through an offer in compromise. Most are a scam or a ruse to flush out people who do not pay taxes. I answered an ad on TV for NADN for help with taxes, and ended up with someone from the Treasury Department at my front door. That was just the beginning of my nightmare.
Probably 8 to 10 an hour, of depending on what part of the
Depending on you in terms of experience - sm
and knowledge, 5 minutes can take anywhere from 15-30 minutes. I can do anywhere from 12-20 minutes of dictation in an hour, but it depends on the Dr. dictating, ESL, difficulty of specialty, how much I have to look up (addresses generally), etc. When I first started it I would take me an hour to do 10 minutes of dictation. Hope this helps.
Depending on the quality of the dictation...
you could figure on 2-3 mins transcription/1 min dictation. I would say $50/hour is low.
$1.10 - $2.20/report depending on modality (sm)
?'s to ask:
- # of CTs/MRIs of account you'll be working on. Lots of CTs/MRIs = lots of lines, usually not worth $1.25/report. If there is a good mix of x-rays, normals and CTs/MRIs, then you're good; it balances out
- Pay for links, e.g., right ankle and foot = two reports
FT range out here is 32-40 hrs. depending on company. nm
s
|
