I use an Excel workbook file
Posted By: FBL on 2008-01-25
In Reply to: Need tips for remembering - Lucy
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. 
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 could buy a medical terminology workbook or textbook. SM
Those usually have self-testing questions. Plus you could use the help of the textbook to form your own test. I know you said you wanted something free, but that sounds a little unprofessional to me and no offense, it sounds a little like laziness. You are hiring employees for your service and you want someone else to provide you with a ready made test for free because you can't be bothered with creating one on your own?
Coming here for help is one thing, but to look for a ready made test or even consider stealing a test from another service - I don't know, it just bothers me a little.
Book of Style Workbook - helpful?
Thinking of ordering it - anyone use it with the BOS?
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.
Rename your normal.dot file to something else then restart Word. It will create a new file.
x
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.
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.
I think it is the same type of file, so rename it and replace your autocorrect file with your DQS us
x
Help..I lost my word file. How can I retreive a file that has been changed? sm
I was working on a large file and had saved it in Word. I then went back to work on the file and hit a key that made the page go blank. When I went to close the document it asked me to save any changes on the document. I answered yes, and now when I click on that document it is all blank! Shouldnt the previous info saved be there, even if the current stuff is not? Please help me!! Thank you
Depends on the file format of the Short Cuts file.
ShortHand comes with a utility file that can import various formats. You can get that file with the trial download of SH.
Depends on the file format of the Short Cuts file.
ShortHand comes with a utility file that can import various formats. You can get that file with the trial download of SH.
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.
...with your user.aco file. Save your autocorrect file to somewhere else. nm
x
You can save the SH file in a text file and import to IT that way. sm
You may have to do some cleanup in the SH text file, but it sure would be faster than re-entering them all manually.
File taxes under the name on file w Social Security....
Name on W2 doesn't have to match, but your tax return has to match SS records. They don't want your marriage license or anything else. Did that for 13 years as instructed by IRS. Didn't have to change it with SS until state changed rules requiring drivers license to match SS records. Still use my maiden name in some limited circumstances.
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
an .exe file is not a voice file
I'm no techie, but it sounds like they might've sent the wrong file by mistake. Or could it be a program you need for testing/working for them that they sent? What is the name of the file (if it is something you can say here)?
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.
Maybe they are going to file
a Chapter 11 (I think that's the number) where they do a corporate restructuring. I'm hardly an expert on bankruptcy law and stuff, but, if I'm not mistaken, some of the airlines have filed bankruptcy, are still flying, and trying to get back on top of things. Businesses do it all the time. Of course, it would help with MQ if those fat cats at the top would stop giving themselves million dollar bonuses. Not saying that would put them in the black, but it would be a little easier to hear when they send memos out saying MQ is losing money.
Bad DSS file
Why do doctors think we are miracle workers? Or better yet, mindreaders? A bad connection is a bad connection. Unless you have some miracle machine like on CSI, etc. (haha), there's nothing here that can be done. Doctor's loss as he will not re-dictate it, but sadly enough - you're the one who takes the blame. You horrible transcriptionist, you. :-) Good luck.
This is the help file you need.
http://www.columbia.edu/~em36/wpdos/medtrans.html
They each have their own file SM
I like the idea about the macro, but am not sure how to do it as there are headers and footers on the original template.
Chickadee
BOS pdf file?
Does anyone have the BOS pdf file they could spare a copy of? I just need to print out a couple of pages. I used to have it but have no idea what i did with it... I think I lost it when my hard drive crashed. TIA!
I did file by file BUT
My files were every note for the day of that particular doctor. I would only divide it up by doctor and their date of service. That should be good enough. It is good for them to have for expensing, and if they do question something, the counts are right there in front of them. If they want the detail it is there, if not they can decide. If for some reason they tell you they don't need the details, get it in writing via e-mail or something.
have pdf file for ...
0420, 0421 and 0424 email me I'll be glad to send it.
wav file - sm
I guess I am old school. haha
.acl file
Add something to your Autocorrect. Search for .acl file and backup the one that has today's date/time (that would reflect the addition you made to Autocorrect). Depending on your operating system, I would make note of where that file is located.
Did you file at all???
If you filed and just mainly forgot to mail the check then they have been hounding you so imply send the check or let them take it out of your state return this year -- they will not touch your federal return. If you did not file but prepared them, go back into Turbo and just print out and send it with your 2007 and and they will send you whatever is owed between the two, taking the 2006 out. I would simply file both at the same time and pay with a check for 2006 and let the return come. Remeber there will be interest and penalty. Good luck.
exe file
That is an executable file, like to install a program. If you will click settings in express scribe, it shows you what files it will play.
EXE.File s/m
"Exe" file is not a voice file - it is a program file - and may be a virus. I would double check with the service if they sent the correct file.
Tell them they can't have it in one file.
They shouldn't be losing work that often. Put each pt in its own file.
How was the file sent to you?
I'm thinking that if it was e-mail, can't you say to "save as" or once you download it, "open with"?
I may (again) be showing my computer iliteracy, but I really want to help you!
Right out of the Help File in ES.
Set User's Decryption Key
Express Dictate, Pocket Dictate, DialDictate and WebDictate can encrypt the recordings prior to transmission to protect security and privacy. If this has been done, you must enter the same key in Express Scribe to decrypt the audio. The key is based on the user id of the sender (obtained when you register Express Dictate or DialDictate). If you have not yet registered, use the id 0.
All I had to do to get this information for you was hit the HELP key at the bottom of the screen. If your voice files were NOT encrypted using any of the above-mentioned methods, you will need to decrypt the file before importing it into ES.
File name?
I used to use Smartype and I know I have it installed on this computer but heck if I can find the patch file. You don't happen to know the file name do you?
wav file
If the file is now on your computer, right click and depending on what you use, you might see an "open with" option, in which case click on that and see if the option "compressed zip folders" comes up. This should open it.
not sure I just know it is a file in my...
computer for DocQScribe word expander. Supervisor sent e-mail saying how to update this file but can't find.
If they use the same file
You can interchange if they use the same file, i.e. spf file. If they do both use spf, you can open up both programs and just drag your files over, very simple, takes seconds. If they don't have the same file, I wouldn't mess with it unless some IT person knows the protocol.
WAV file?
I have been asked to transcribe a speech for an area company. How can it be recorded/saved to disk so that I can use my foot pedal to transcribe it? I do have a WAV pedal from using Bayscribe in the past but I have no idea how to get it to function without Bayscribe. I would appreciate any help. Thanks!
big file
Thanks. I will try that.
Definitely file an appeal
A lot of times if you file appeals, your insurance company will readjust and allow for "special circumstances". It is worth a try especially if you send in information documenting it being an emergency
|
