don't have Excel, but working on it.
Posted By: Renee on 2008-01-31
In Reply to: Organizing a referring physician list - Beth
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!
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
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
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.
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?
/
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 get more working the evening or night shifts and working w/o benefits. And producing like a mad
,
Ditto....granted I am not working much these days, but am currently trying out a new way of working
when I do work which seems to be helping. I am timing myself and keeping a log of how long it takes to to type however many minutes. I am averaging anywhere from 13-18 minutes of dictation an hour now doing this. Granted the time fluctuates between who I am typing, and if I have to look up names, addresses, etc., just depends on the division I am doing at the time. But work that used to take me 3 hours to do is now taking me under 2 hours, I am also trying to put in more macros as I go along, which slows me down initially but pays off in the long run of course. I was working "all the time" before but took forever to get done since I was not applying myself. This new "attitude" has helped me a lot. My goal, in the Fall, is to do 90 minutes a day consistently at 6 hours, and then maybe get up to 120 minutes a day at 8 hours, still while having at least half of the day free (do 60 minutes at night, and the other 60 by Noon). Thereby doing 1200-1400 lines a day. I have never really buckled down and done more than 8000 lines per pay period, so it will be a nice change. Maybe you can do something like that and have a specific knock off time as was suggested below. 
Working holidays? Out shopping in stores where someone IS working
that holiday you refuse to work? Grocery stores, food joints & seems any store is open on holidays and you expect them to be fully staffed, so why shouldn't we?
Yes, I took off for the first time on Christmas day, in 18 years and it was great, but I worked Christmas eve and this whole past weekend.
Someone has to do it!
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.
working IN A HOSPITAL is different than working at home.
Someone can steal you identity from the internet if they want to. Why would you go to the time and trouble to jeopardize a job that requires some level of skill to steal someone's identity or medical records? You could get a job as a retail clerk and get info easier than going through the testing required to become an MT.
Somehow working at home translates into not really working
My in-laws are the worst. Whenever they plan something last minute and my husband says that I had to work, they say, "but she works at home!". When I one time mentioned I had a "schedule" and basically punch a clock and work full time, I don't think they believed me. They will sometimes call mid-day during the week if they are in the area to see if I want to go for lunch, etc! The best is, my husband doesn't make all that much money, so where is it coming from, the money fairy? I am ready to strangle someone! So I know how you feel and I'm sorry it upset you. You are not alone.
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.
I daydream about NOT working while I'm working.
There are so many other things I need and want to get done. I've been working way too hard lately, and summer is just slipping by again. Well, I'm outty.
Working. LOL What else? nm
..
working out
Spinning is great if you only want aerobics, but a personal trainer deals with weight training. That's for building muscle, which speeds up your metabolism. You really need both (aerobics and weight training) if you want to slim down and shape up.
In either case, make sure you drink ice water. The body's reaction is, "What the heck is this stuff?! I'm getting cold here. Turn on the shiver mechanism." That's another way to speed up your metabolism. 
Working for self
It is harder now to break in than it was 15 to 20 years ago when I started but there is still accounts out there. I got started part-time when working for a local hospital -- not even doing medical transcription. I was an Admin Ass't but had done this in the past and one of our physicians on one of our boards could not get anyone to do his transcription so I started doing it part-time. I had been a CMA, CMT, x-ray tech in the old days. But had not kept up on my certifications when I went to work in the hospital. But this started the ball rolling. Since my hubbie then was a truck driver I did it to keep me out of trouble when he was out of town. Then I started doing it full time. I get accounts from the private docs that no one really wants, larger companies, and still do tapes, printing, delivering and pick ups. I advertise and send out flyers and seem to get a bite when I need a new account. I have 2 Surgical Oncologists, 2 IM's, 1 Plastic/Hand surgeon, and 1 Psych. I have one permanent part-timer and one that helps out with overflow. I charge from 10.5 to 12.5 cents a line depending on the account. My rates are going up this month. I also work in a clinic doing electronic charts but that is as an employee. These docs are small and I keep my prices lower because I know what they get back from insurances, etc. are not that great. I am paid within 3 days of receipt of invoice (usually the next day) have never had my line count questioned, have never had a check bounce and they make me a part of their team. And yes, I am the one from six months ago that said I would bake them cookies and you know why. But all I can say is look through the County AMA directories or phone books or if your hospital has physician offices in them, see who works alone and try sending out flyers or going door to door -- never hurts to bring cookies either. But have been doing it for 15 years fulltime and make enough to support myself through a yucky divorce and pay an attorney $10,000 -- barely but did it. Good luck. Maybe if enough would do this for themselves much cheaper than the nationals we could all go back to making a good living. Am going digital here in the next six months or so, but only to pick up a new account as my docs still prefer the tapes. Trying to get them to change.
You can E-mail me for any more questions.
It will get better--just keep working..nm
nm
why because I tried working for both
I have nothing really bad to say about SS, I have had no lines stolen, I just dont understand what is being dictated I'm sort of new I have about a year's experience but in my opinion this is easier to learn in English before you go to extreme ESL work, I will say that SS gives you back all of your reports so that you can learn your accounts but they almost have to so you know what the people are saying
are you working on?
Been with another office 8 years myself. Was a top producer for many years, then got put on DocQScribe over a year ago, now cant get my line count (???) - plus HATE the account. Requested to change accounts numerous times and pretty much got told to be quiet and type. Do they ever transfer MTs to different offices?
It is working now!
I went and updated my Norton AV (but I have it set up to update automatically whenever there are new updates) and restarted my computer, logged on, and opened IE and my WW page loaded! Go figure! :D
Thanks for suggesting updating my AV but I don't understand how that would have effected just that one web site. Perhaps, it is just coincidence but then again maybe not.
In any event, thank you so much for trying so hard to help me. I really appreciate it. :)
Are you currently working on ASR?
x
Working.
dd
working
got an email from them about the horrible weekend backlog, but I also had no work - Amherst, 5 different accounts
working more than one IC job
Don't know where you got your info, but I've never been told by the IRS that I must work more than one job as an IC. I must have missed that Big Brother memo, lol. 
I too like working for MQ.
I never said I didn't like working for them. The only thing I responded to was your attitude. Why do you feel the need to defend MQ? If you're happy who gives a rats rear what anyone else thinks.
Working on it.... NM
NM
where are u working for 11 cpl ??????
???????????
I am working on it.
I work at my Mom's house, but am setting up duplicate system at home. I have DSL here at Mom's, at home only dial-up.
Should be working
LOL - that is funny. Why would anyone assume a male typist is gay? I never would. Know too many that are not only straight, but have kids.
Working Too!!
Hi: No mee too...I am working! Fancy that. I am a single mom and I have to make ends meet, so well here I am typing away but I will take a few hours to be with friends in about an hour. It's ok I am ok with it. I do the best I can with what I have. God blessed me with a beautiful daughter.
When I was in NYC working 5 hr/day
I could make anywhere between $20 and $90 an hour depending on how the work flowed any particular day but the yearly average was $45 an hour before taxes. My only benefits were 2 weeks paid vacation a year and health insurance for which the company paid the complete premiums. Since they took care of my taxes, I didn't have anything else to worry about.
Actually, when I kept that job and moved to several other states (Jersey, PA, GA, AL), I continued to make the same pay but the cost of living was less in the south so my disposible income was much greater, giving me a better lifestyle.
How well can I do working for a co. as sub-c? nm
x
working as an IC
I am considering working as an IC employee. I have always been a full-time employee. I would like information on what it involves. Thanks so much.
KG
Working as an IC
Good luck to you, too! I knew there would be some expense in getting set up. I just don't know about being considered self-employed and having to keep up with the paperwork for the IRS. I know nothing about all of that. Let us know how it goes! Thanks.
See, it's all working out for you!
Jodi, I am so happy that it is working out so well for you. You are finding out that you are a lot stronger than you first thought. I'm glad you took those tears and turned them into strength! You will make it!! You have already done the hardest part....even though there will still be rough times, you have made it through the hardest part already. Nothing can stop you now. You are a strong, smart woman. Your children are blessed
I will keep you and your children in my thougths and prayers. Keep us updated - we care!
Working for MQ
Currently applied and was offered a job to work for them, then I see this page and all the nasty things that are being said about then and wonder what is going on, should I take the job or not? Please help.
anyone working for JLG
Anyone working for JLG? Could you please Email me? Thanks.
working for DBS
Anyone out there w/experience or knowledge about working for Domenichelli Business Services? Looks interesting. Trying to broaden horizons.
Why is he not working? You should be...(nt)
Thank you!! I got it working! SM
I'm so glad! I see everything now...it's all working wonderfully! Thank you for all of your help!
Sincerely,
Chickadee
|
