Making labels in Excel sm
Posted By: Speedqueen on 2006-12-13
In Reply to:
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. 
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
In her defense, there are far too many men out there that really should come with warning labels. nm
nm
Look for like inside directly from Microsoft about how to print mailing labels
and mailing lists.
http://office.microsoft.com/en-us/word/HA011269731033.aspx
Anyone know how I can take addresses from a Word document and transfer them to mailing labels?
I have several hundred typed out, but cannot for the life of me figure out how to turn it into a mailing list. I have downloaded Avrey Wizard, but when I try to do it, it asks me about field delimiters and no matter what I pick it doesn't work. Maybe there is a simpler way??
Thanks!
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!
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.
sure i was. i'm making fun of the people who are making a case for background checks, etc
to do medical transcription at home as if they may do something AWFUL with the info they receive. So if you want an invasion of privacy let's REALLY invade it and make sure fat chicks don't transcribe because they are so busy eating they can't get the work done, they mess up the keyboard with food and if they are provided health insurance they will raise the rates for the company sky high because their health risks are higher than others. Then there are the psychological issues overweight people bring to the table. After we eliminate fat people, we can go on to eliminate diabetic people who may have low blood sugar while typing and go into a spell and type the wrong thing. I could go on and on through the process of elimination. How about prescribed medications that may cloud your thinking? So you take Ambien to sleep but you have an Ambien groggy hangover when you are transcribing? Should they transcribe. How about your teens are on your last nerves and you take a Xanax? Should you be allowed to transcribe?
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?
/
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.
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
You realize by doing that they're making more money & you're making less? You should reconsid
Works is a dumbed down version of Word and Excel. You get the full version of Word in the Suite.
The Works Suite is a cheaper way of getting a full version of Word if you don't want or need the other applications in Office.
Changing Excel 2003 Addresses Into Word 2003 Addresses
Hello !
I have a large amount of addresses listed on an Excel 2003 spreadsheet. I need these addresses for Word 2003 letters. I end up copying the address from Excel and pasting it into Word, but as you can imagine, the pasted address is in a straight line and I end up having to type the address so it displays correctly for a letter. Does anyone know if there is a simple way to change the Excel address format to a Word letter address format? Thank you for your help.
making up.....
I suggest you have your father read my post and explain it to you. Apparently you have poor comprehension skills. Talk about ignorance.
My point was NEW immigrants who come here not to become American. Obviously, this is not apply to all NEW immigrants, because as we know, many of them bust their butts to become American in every way including service in the military. My point was that so many of the NEW immigrants, meaning those from the last 25-30 years, come with different aspirations than previous groups. This is documented by social scientists who have been studying this very point for a couple of decades. Look up some articles in any journal of American sociology or political science and you will find research on this subject.
I am perfectly aware of New Spain and New France and even that Russia once owned parts what is now Washington state and Oregon. Do the people in Northwest US demand to have legal papers printed in Russian because 400 years ago, Russia settled that land? Are you aware of the language controversy in Quebec, Canada? We don't need that in this country and having English as our accepted common language has helped prevent some of the fighting and death that results from people coming to blows over language. Language is the root of "the Troubles" as the Irish call their 100 years of conflict with England. England passed a law making English the official language and forbad Gaelic in public places, including schools. Look how that has worked for them. In the U.S., it has worked because it has been understood as a custom and new immigrants were proud to learn English, because it was a mark of American citizenship.
You need a history lesson - New Spain was SOLD to the U.S. government and New France was sold to the U.S. government by their respective kings because France and Spain needed money to finance their wars with each other. So, Spain left voluntarily.
BTW, my brother wrote my parents in English during WWII and his letters were confiscated - is there a group that will protest such actions again Irish-German Americans?
Wnat to see what ignorace looks like? Got a mirror?
I am making......
17.00 per hour with a home-based hospital job (you have to be local to the hospita) PLUS a generous incentive with a "quite easy to attain" minimum line count and then 8 cents a line after the minimum is met. Plus I have all the benefits of being an employee (which I am) including paid vacation and benefits. I've been the national route and I didn't find any of them to be paying well, plus I was always running out of work. We are swamped all the time and NEVER run out at the hospital. If we do run out, which has never happened, we can go into the department and shred paper or something. I wish more hospitals would go back to having a department. That's where you'll find your dignity IMHO.
You were making LESS than THIS????
unless u r making $25/hr
not impressed one bit
you can make $12.50 an hour being a secretary and be dumb as
dirt.
you can make $12.50 an hour doing data entry and not know one
word of medicine or the other junk we have to know and be responsible
for and get grief from QA about.
you can make $12.50 an hour doing a lot of things and not have to
put up with the junk MTs are having to put up with now.
IT is making me
My eyes keep moving up, down, up, down. I'm getting a headache. How long does it take to adjust to this?
No, making way more. nm
x
Making more now
I worked for a hospital for 5 years and then we moved... tried another national who didn't pay much, and then started with OSi and am making more than I ever have (including 25 years of secretarial work)! I've read so many negative posts here about OSi, but I think those who have complaints tend to voice them more than those who don't. I'm very happy with them as far as money, schedule, and flexibility. I know from reading previous posts that many will assume I'm part of management just trying to give them a plug. No, I'm not part of OSi management. Just a very happy transcriptionist.
Men Making More LOL
That is because they choose wisely and don't accept just anything. I am female and quite often make more than most women. Having been in the MT business for only 3-4 yrs I am constantly amazed at the rates offered and accepted, and the lack of understanding at the complexity and enormity of education required to do this job. When someone offers me a low salary I tell them what I think of it and just go on to the next company. I have always known why there aren't a lot of men in MT work - the salary. In places where typing pays decent $$$ there are tons and tons of men.
making the big $$$
I was actually referring to the above posts that state they are making $50 to $60K per year.
Making $100,000/yr?
Is that really possible without having your own service?
ya know, when I'm making
70k a year, I can have the 850 square foot bedroom if I want. In fact, my home is a mere 2200 square foot, on 5 acres in the country, only worth $450,000 but I paid off the mortgage in full in 7 years, by- yep, you guessed it-- working my MTSO. I have no debts. I own 4 cars. I have money stuffed in my 401k. The point was made in an earlier post by our beloved Patti, who chooses to live in 1000 square feet - and also put 15K in her retirement account and takes home 50K. When Patti mentioned her home was 1000 square feet, some ignorant troll said (now say this in a high falsetto) "shocked! my bedroom is 850 square feet! How can you possibly live in only 1000 square feet." Jealous, no. Anyone who wants to own, maintain, clean their 850 square foot bedroom can be my guest. Me - I go for a little smaller but still nice, with more freedom and lifestyle. That's why I put in my 5-10 hours a week running my service while you're working full time. LOL!
What we SHOULD be making, and what most of us ARE making (sm)
are two different things. We SHOULD be getting from 12-18 cents per line. In reality, most of us are somewhere between 7 and 9 cents a line.
I'm making nowhere near that much
I'm either working for the wrong companies or am really slow, my best is 200 lines an hour, which translates to at best 18 bucks an hour, Wish I was faster I guess
What I would like to know..... IF they are indeed making that much then.... sm
how are they doing it? VR? Would love to know the secret. Those of you claiming to make a ton of money, please do share how you do it. Have been doing this for 15+ years and I am seeing a quick decline in pay and seeing these companies getting away with making the lines harder to get with how they calculate them. This profession quickly going downhill.
More than what she is making, I'm sure.
x
If you are making 9.5....
I would ask for at least 11. If you have been there that long, why not? I always ask for more than i really want cause you can negotiate. If you end up with 10.5 that is still a good rate.
For ESL's I want 11, but I don't get snippy if i have some here and there. I do one now exclusively and he can be a big pain but i can understand him fine and ESLs are great for making normals because in my experience they repeat A LOT.
The going rates around here seems to be 8 cpl with many companies...you are doing good at what you have but there is nothing wrong with levering your experience and services for more money. You have proven yourself already to these people. If they turn you down you can start looking elsewhere but only do so if you are taking a step up.
I was making 16/hr when i was QA n/m
x
Making changes
Alright folks let's move this off the word help board because it's become a different discussion. First of all, I personally believe that we should type what doctors say, everything they say and not change a thing. So if they say Synthroid 100 mg, leave it. If they say There was changes. Leave it. However, our companies and many hospitals don't agree.
If you were to try to get a job editing books at a publlishing house you would need a degree in English and you'd get paid a whole heck of a lot more than we do. But we do the same job, fixing the English of doctors, having perfect punctuation, correcting verb tenses. Not to mention the medical side, knowing all the drug dosages, correct lab values (yeah we get marked off for those too). I love it when I have to leave something blank like I just did "H&H 13/4/38" ???
IMHO we don't get paid enough to do all we have to do. We are not just typists. My friend is a nurse and when I told her everything we have to know she told me we could all be nurses! This is because I carried on a conversation with her about cardiac cath, CABG and people who have IV dye allergies and the compliance issues with Mucomyst. She was shocked.
We get no respect from many doctors. I actually had a PCP that I went to when I was sick say that because I was an MT I knew too much about medicine in a really condescending voice. Had another say then what do you suggest when he tried to tell me he'd done all the possible tests. Corrected another to his face.
So call me whatever you want but if I hear the doctor say something that is inappropriate in the same manner that Potassium 132 is inappropriate or Synthroid 100 mg is inappropriate, I'm going to leave a blank. Maybe the doctor is mad or frustrated but the medical record is a legal document that the patient can get access to anytime they want. So when the doctor calls a patient a land whale or says she's f-ing pregnant again or is a retard or is an SOB (and I don't mean short of breath), IMO I am covering their butt by giving them a chance to rethink what they say before they put it in a legal document.
VR and making only 10.00 a day!
No work this entire week at Sten-Tel. What is up? A job here and there but that is VR and I am making like 10.00 a day...this is total bullcrap. So glad I am training for a new company starting tomorrow.
Well you could have put down what you are making???? - sm
But with that said I do $375 to $450 a week.
I will say what I'm making
I make close to 3,000 dollars a month typing....I'm not sure if anyone thinks that's a lot, but I feel very fortunate to be making this kind of money. I have been doing this for a little over 20 years.
I hope this helps! 
It is entirely possible to be making that
much money. I make close to 50K, but also work FT and as an IC at another facility, and luckily I work for 2 companies that actually appreciate their employees and pay a decent cpl.
I am currently making
about 52K, but I work 50+ hours a week.
I am definitely not one of those making...sm
the high annual income. My income is rather pitiful to be honest. But I don't have enough work and that is why. And due to not enough exp yet I am going to have to tough it out until I can obtain a better paying job or preferably where I am has more work for me or higher line rate. I love where I am.
Some people may make up income or cpl or they may not. Who knows? Who cares? What do they have to gain by doing that? I understand your selfish longing to have that. Who wouldn't but remember you are doing your best and that is all you can do.
Nothing like making up history
There are in fact many Hispanics who died and continue to die for this country. I am the daughter of a WWII veteran whose mail was confiscated because he wrote letters to his mother in Spanish. While my dad was literate in both English and Spanish, his mother could only read in Spanish, as was the primary language of New Mexico, Colorado, etc. 50+ years before the Mayflower landed. Also, my brother is a Sgt.Major who retired after 25 years in the army and 3 of his sons are also currently in the army (including Iraq). But as I said before, you can ignore all that 'cause you make up your own history....and telling Native Americans to get over it only displays your ignorance.
Yep...had an old doc who would always say, when making a correction (sm)
"Ummm, STENOGRAPHER, please change..." etc. Yeah, like I'm sitting here doing Gregg shorthand!!! Drove me nuts!
Also used to have one who loved to editorialize as he dictated...had a great sense of humor, tho', & I really enjoyed him. He'd always start off with "Hello Transcription!!!"
Sometimes I wish I had a tape of all the docs' bloopers to listen to on the days when I wonder why I do this for a living 
150 lph at .06 = $9.00....if you are new count on making less than that. - nm
x
any advice on making over $55?
May I ask how you do it? Unless working for private physician with gross lines, I can't see how. I work for a pool--difficult to get in sync with the docs and really put out the lines.
|
