Is each address on a separate line? And do you have Excel?
Posted By: sj on 2006-11-27
In Reply to: Easier way to sort an address list in MSWord? - probono
/
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
Not on a separate line, per se
but separated by paragraphs. It looks something like:
Name #1
Address
City, State, Zip
Name #2
Address
City, State, Zip
...and so on.
Sound is usually good. Separate line is better if you don't want to tie up your main phone all
s
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.
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
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
A gross line is anything on a line is a line. A line set at 65 characters means it sm
has 1-inch margins on each side. The maximum number of characters on that line would be 65 and that includes spaces. If there is 1 character on that line it is a line.
A standard 65-character line usually consists of 65 characters with spaces unless, of course, the employer does not pay for spaces and then it would be 65-characters without spaces.
I would have to separate by category!
first 3 that come to mind are: The Notebook, Hope Floats and Sweet Home Alabama (SHA didn't get rave reviews, but I just loved that movie!)
ET, Titanic and Forrest Gump are like classics and you HAVE to love them!
Independence Day, MIB, most of the Marvel (comics) movies, Van Helsing and both Underworlds top my list too!
Oh, and then there is the animated stuff... the list is never ending! (and we own over 400 DVDs!)
MS Word not separate (SM)
MS bundles Word with their MS Office product. Previous companies I have worked for had MS Word alone on a generic disk. As far as I know, none of them are in jail yet.
OpenOffice.org provides a program that rivals MS Office. You can download it for FREE from their site. If you are doing this for work however, I don't know that it would be compatible with platforms you would be using - I'd say probably not.
Should you need to purchase MS Office so you can have MS Word, check out newegg.com. I know with operating systems such as Windows XP, you can buy versions that computer builders use - no fancy packages, just a disk and a license - for significantly less than what you'd pay for an off-the-shelf product at say Staples. Don't know if you can do the same with Office. Check out CNet.com for reviews. CNet.com also has forums where you can post a question and an Editor will answer you.
Good Luck!
I have a separate office
Although it's open and doesn't have doors.
I use a separate room
I have a 2 bedroom place, hubby and I use the master room and I transcribe in the "office." This keeps me, for the most part, without distractions other than those I create myself. I set up a place for my cats to sleep so they don't sleep on the computer desk, and have found that this works the best for me...very short attention span when I tried it in the living room. Just don't move work into the bedroom you sleep in, might cause sleep problems.
Are they separate checks (sm)
totalling 12,000+. You'd have to check the court system, but that may actually be over the amount for small claims court and you'd have to go to the next level. Has she made ANY attempt to pay any of it? Do you have any "demands" for payment in writing? If not, I think I'd get that in the mail today. You need to establish a papertrail. Formal demand asking for payment in a set period of time by cash or money order. Send it cert mail with return receipt.
Yes I did have a separate firewall....sm
I have also used the AVG for years. My friend has also used it for years. I know a lot of people who have used it and continue to with no problems. I had no problems until someone hacked into my computer. When I took it to the computer guy, he said you are using a free AVG version. He said that is the problem. He said why do you think they are free? They don't fully protect your computer. I have no idea with a firewall on how they still got into my computer but they did. My friend had someone hack into hers while using AVG free version and separate firewall and stole her identity. I am just trying to keep the expensive mistake I made from happening to other people. It is costing me $250 to have the computer repaired.
Yes, separate computer sm
I have kept an older computer with SP2 but don't have the original CD rom. I use it for checking personal e-mails etc.,, will try it tomorrow, sore neck from trying to "make it work". Will try tomorrow when my neck feels better. Stress........Thanks for trying to help me. Of all things, to misplace a CD rom, how dumb am I????
Yes, separate computer sm
I have kept an older computer with SP2 but don't have the original CD rom. I use it for checking personal e-mails etc.,, will try it tomorrow, sore neck from trying to "make it work". Will try tomorrow when my neck feels better. Stress........Thanks for trying to help me. Of all things, to misplace a CD rom, how dumb am I????
Two separate issues
Her medical records were indeed compromised several years ago and they did a sting with the doctor to find out who it was. The person responsible, ironically, died of cancer before she could be prosecuted. Farrah talks about it in the documentary. The documentary itself is Farrah and Alanna filming her treatment and journey over the last year or so.
Yes, it sure is. I was told on 3 separate occasions that
I could use it for work but when they saw how much I was racking up in charges, they told me I was not eligible and sent me a $2500 bill. I would be careful if I were you!!!!!
Or try to get the kids a separate policy
xx
set up a separate entry for that with all caps. that's what I do.
x
its separate from hair and nails
is around 40k a year. Thats the highest ive made as an MT. You need a license, go through state board, and there are several schools throughout the US. Just do a search on "aesthetic or esthetic schools"
I use a C phone and 2 separate lines.. sm
I have DSL and I was not able to have my DSL on the same line as my C phone though now I cannot remember why it did not work. I do know that if it had worked I would not have had a phone to use to call out or receive calls while I was working (which was fine by me.. my family knows to call my cell). At any rate, because of the fact the C phone and DSL did not co-exist I had to use a separate line for my C phone and then my DSL is on another line and that frees up my main phone line for calls in and out.
Are the numbers in a separate column? sm
If yes, go to the Data menu and choose sort, then sort by the letter of the column.
Also fortunate enough to have a separate room. And
s
It doesnt separate. You end up transcribing at
gf
2 separate companies/offers
x
Each 401K is a separate entity. You can have...sm
as many as you want. Sure helps with the taxes!
These are separate reports, called sm
corrections or addendums. We are not even allowed to change any report once it has been sent, and chances are that we are not the original transcriptionists who transcribed it. It is simply a new report.
I don't really mind at all when they say "go back up to History of Present Illness and put this in". It is just part of the job, not a big deal at all.
If it were me, I would have a separate hourly rate that
I would charge for things such as that, and keep a total of the time you spend doing this, but definitely bill them!!
Is it possible to use 2 separate monitors with just one computer?
I'd have two monitors but only one computer. I guess there would have to be somewhere to plug it in...and I only see one place to plug in a monitor but was hoping someone knew of some kind of adapter or a way to get around this? Thanks!!
Transcend bought MDI-FL. MDI-FL and MDI-MD are 2 separate entities. nm
x
MDI-FL and MDI-MD are 2 separate entities. Transcend owns MDI-FL. nm
x
What for? 95% of us ARE geezers - no need for a separate geezer board!
x
Info on using 2 computers to separate jobs
Does anyone else use 2 computers to work different jobs? I'm having conflicts between 2 companies so decided to buy another computer to separate the them. I plan to use my monitor and cable on this computer too.
I was told by the one company that I cannot use a router. Does anyone know why? I'm not very computer literate anymore so... how else can this be done?
I certainly don't relish the thought of unplugging and plugging my monitor and cable every day and definitely do not want the expense of another cable line. I am not reimbursed for my cable or equipment by either company. Thanks for any info you can provide.
My office is in a separate room, yet close enough
I can hear what is going on. I have a shock collar that I put on my dogs to keep them quiet when they are outside (I don't have to shock them but very rare occasion). I work late afternoon/early evening so that part of my schedule, pets and husband are in bed and I have total peace and quiet.
separate bedroom makes sense
at my last 2 places that I lived I always had my office in a separate room but Iwas on 1 floor and I guess I felt more "together" that way. I am going to give my upstairs extra room a chance. At least I will have a window that sees a pretty scene small creek, tall trees. The only downfall my little dog cannot look out the window there as the windows are too high! Thanks all.
No, having a separate office doesn't make
me concentrate any better. The part that is nice about it is when I'm not working, I can close the door and not think about work. When I can't concentrate, I usually put in some soft music, light a stinky candle, make a cup of tea and force myself to type for at least one hour before taking a quickie break. I pretty much make a deal with myself as a reward to get it done.
It sounds like you are talking about a separate platform
in addition to the Express Scribe. Maybe part of those steps would work for the OP, though.
When I left my former employer, they cut me a separate check. (nm)
x
You're talking about a separate program add-in.
In the standard MS Word program, there is no such creature as "word count" on the Tools menu. Either you're not useing MS Word or your company added this program. The other poster is telling you how to get the line count using the MS Word statistics/properties for a document.
If your company has added this program feature, they can configure it any way then want to and you're at their mercy.
Please make sure in the future when you say you're working in "Word" that it is MS Word as that is the assumption that will be made by anyone reading your post.
|
