Freeze.Panes revisited

Howdy all people and animals and dentists.

Just a quick blurb here to tell youse that I finished typing in my
deductions tables into four Excel sheets this weekend. This is for
doing the source deductions for my employees' pays for Fed/QC income
taxes, QC pensions plan and unemployment insurance. I can now do their
pays myself in about one minute. All courtesy of XL's VLOOKUP function
on those tables. A short addendum will give me the totals I need to
send in the $$$ each month.

I still have to proof read my accounting routines, run them by the
crooked secretary, and find some place to sell me rolls of computer
paper suitably perforated for receipts, but the macro is basically
ready to go.

I'll be using File Maker Pro (Very old version for the Mac, but it
works) to input patient file info, (what we call 'Civil info' in
French), and Claris Organizer for appointment info. I will see if I can
open two pages of calander at once, one for me and one for the
hygienist. If not, I'll make double entries for each room, or just use
different colors for her and myself. Any one who has Claris Works on
their computer has this and a watered down version of File Maker in the
Claris software package.

Amatus was right: it is a HELL of a lot of work, but it will tide us
over 'till I have the $$$ for a _real_ dental program (that can work
with the RAMQ and Dentaide and the other insurers). Such a dental
program will cost about 3K to 5K. It also permits me to function alone,
or have either my assistant or my hygienist do the billing and
scheduling for the patient. This is because I want to take my time in
finding a secretary that is good on the phone and not lazy. (I've had
some comments in that vein from the secretary of the now-retired Mad
Dogs, with whom we shared the waiting room.)

The new batch of Mad Dogs are taking the place of the old group, but
will only be up here for a couple of months: then they will go
downstairs to a huge location attached to the pharmacy. This was a
video rental place, but they moved a couple of years ago. It has been
basically unrented since then. I have asked if I can move with them,
and they say there would be enough space, but my CPA tells me it can
cost up to 60K just to get it set up and running...(!) I'm gonna talk
to the pharmacist owner and see if he's willing to help with the
relocation, and how much it'll cost to rent once I'm there, and where
I'll put my lab stuff...(Noise...). It would be nice to get out of this
location, as the waiting room is dim, smelly and 'hospital-ish'.

The purists amoung youse may take exception to my 'stringing along' my
secretary when I know she is crooked, but I look at it differently: she
has been stringing _me_ along since March when she came back from
maternity leave, and probably even before that. You would say: 'get rid
of her NOW.' _I_ say: when my CPA confirms what I have seen, and when I
can turn around and function autonomously. I have _no idea_ what the
upheaval will do to the situation with my assistant and my hygienist. I
just may end up all alone in the little shop.

In the meantime, I have put an ad in one of the local morning papers,
and the CV's are going into a post office box I took out for that
reason. The local locksmith will be notified at the ablolute last
minute, as he is a patient.

Cheers, gang
SP

.