Home     Contact Us    
Main Board Job Seeker's Board Job Wanted Board Resume Bank Company Board Word Help Medquist New MTs Classifieds Offshore Concerns VR/Speech Recognition Tech Help Coding/Medical Billing
Gab Board Politics Comedy Stop Health Issues
ADVERTISEMENT




Serving Over 20,000 US Medical Transcriptionists

Excel question

Posted By: Rad MT on 2007-07-28
In Reply to:

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!




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.
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. 


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
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.