Fastest/safest way via Excel
Posted By: speechpro on 2008-02-02
In Reply to: Know any shortcuts for list re-organizations? - Renee
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.
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
Hi Terry. Sorry due to late reply here, but, your safest option would be
to have the test emailed as an attachment to you, your pc's software scans it before allowing you, or at least prompting you, to open, which ensures safety. You can also scan it using winamp, possibly real player. Doubtful on others. It's been my experience, most cos send it the way I described. Why the other? Are they adamant?
I have only had the fastest DSL, but my ISP
has a speed test on-line that will supposedly show the difference in the various high-speed services. I don't do VR, so can't say how that would be affected.
N is the fastest, but it isn't
widely available ye. Most are backdoor compatible with each other, so that if you got an N it would be compatible with b and g. I don't know that all are backdoor compatible so check to be sure. I definitely wouldn't get anything less than a g.
The FAQ's on this thing say the fastest
Don't think so.
Ops and ERs -- my fastest money-makers. NM
.
Easiest and fastest way is to Google sm
once found, click on the manufacturer's website. That way you will always have the correct spelling, etc.
Fastest typist in the World
Transcribing speed and typing speed are two different numbers.
Interesting link below.
Which companies fastest to pay 1st check? (sm)
Someone said Proscript was fast (invoice period ends Saturday, direct deposit the following Weds/Thurs), but they're not hiring.
NEMT pays weekly, but a friend said it is several weeks until the first check, and they pay with paper checks.
Anybody else know a company that pays fast? I'm good!
fastest/cheapest way if you already have MT stuff
Set the mini handheld recorder to play in front of your computer mic and record it digitally to a file - play the voice file back on your MT equipment/foot pedal and transcribe - done this a few times for a PRN tape for a local doctor, works great! (no kids home, no barking dogs though!) Otherwise you have to get a mini-player with footpedal (about $250 for a cheap Sony at Office Depot).
MTSO just wants work done by fastest, most
x
the reason it is the fastest growing sm
industry is because of the schools out there selling MT training! The schools don't know what they are doing, they are just ripping prospective MTs off.
This profession will NEVER be something that can be learned totally in a classroom setting. If you go to school then you have to be willing to work in a facility for several years. you ahve to be willing to learn to transcribe any and everything and the worst of the worst before you EVER EVER go home to work especially on a production basis.
I don't care who it ticks off but at least it can't be said I didn't tell you the way it was.
The poster "hot pink" is telling it EXACTLY how it is but she words it better than I do. Im sorry for the folks who are losing their jobs (especially the MQ folks) to VR and India etc. But I think alot of the MQ employees used MQ as their very first job and didn't get the experience they really need. MQ should have been after you have worked for several years in a facility. With the training in every kind of work type and every foreign accent, etc. etc you wouldn't have a hard time finding a job now. They are still out there.
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.
Siren, I find googling key words fastest and most helpful. SM
After that, my medication software, then my dictionary software rarely but valuable when needed. For books, I still use my Stedman's equipment book and Sloan's abbreviations/eponyms (invaluable when needed). As a new MT, I purchased most of the Stedmans books, plus many other books, and found them invaluable then, but now as a skilled MT they mostly just gather dust as doing a quick search with hands on the keyboard is much, much faster.
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.
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.
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
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.
|
