Freeze.Panes revisited
in [Dentistry]
|
From: StovePipe on 17 Oct 2005 09:39 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
From: Amatus Cremona on 17 Oct 2005 10:36 > > The purists among 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. > Do enjoy being held hostage by your staff ? -- / Amatus / "StovePipe" <stove99pipe(a)yahoo.ca> wrote in message news:1129556394.796471.25540(a)g43g2000cwa.googlegroups.com... > 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 >
From: StovePipe on 17 Oct 2005 12:07 Amatus Cremona wrote: > > > >> I have asked if I can move with them,(The new batch of Mad Dogs > > 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 going talk > > to the pharmacist owner ....> > > > > Will you be sharing space, being a partner, being an employee, sharing a > common space, or just neighbors ? > > -- > / > > Amatus > > / We shared waiting room space and the taxes on that with the last group. I imagine I will be a neighbor with shared common space again in this case. I may need to share secretarial space with them as well; it depends on the size of the space, and where I can put the lab stuff. The difference is that I have my CPA who has more experience with these kinds of arrangements to tell me if I can swallow it or not. I will be paying my rent to the pharmacist again, but any 'common fees' will be run by the CPA before I say yes. I say that because I was taken by the old group of Mad Dogs with that the last time, and it won't happen again. Thanks SP
From: Amatus Cremona on 17 Oct 2005 13:31 > > We shared waiting room space and the taxes on that with the last group. > I imagine I will be a neighbor with shared common space again in this > case. I may need to share secretarial space with them as well; it > depends on the size of the space, and where I can put the lab stuff. > The difference is that I have my CPA who has more experience with these > kinds of arrangements to tell me if I can swallow it or not. I will be > paying my rent to the pharmacist again, but any 'common fees' will be > run by the CPA before I say yes. I say that because I was taken by the > old group of Mad Dogs with that the last time, and it won't happen > again. > Are the _Mad Dogs_ physicians or dentists ? What happens if they are sloppy and you aren't. Then, what if you want to decorate the reception area differently, or if the principal _Mad-Dog_ wants to display his collection of hunting trophies (or shrunken heads for that matter). I always suggest you not share more than a parking lot, a vestibule, and maybe a staff lunch room. Unless, you have know the other party for many years, and find that both they and you keep virtually identical offices. -- / Amatus / "StovePipe" <stove99pipe(a)yahoo.ca> wrote in message news:1129565232.638084.25810(a)g49g2000cwa.googlegroups.com... > > Amatus Cremona wrote: >> > >> >> I have asked if I can move with them,(The new batch of Mad Dogs >> > 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 going talk >> > to the pharmacist owner ....> >> > >> >> Will you be sharing space, being a partner, being an employee, sharing a >> common space, or just neighbors ? >> >> -- >> / >> >> Amatus >> >> / > We shared waiting room space and the taxes on that with the last group. > I imagine I will be a neighbor with shared common space again in this > case. I may need to share secretarial space with them as well; it > depends on the size of the space, and where I can put the lab stuff. > The difference is that I have my CPA who has more experience with these > kinds of arrangements to tell me if I can swallow it or not. I will be > paying my rent to the pharmacist again, but any 'common fees' will be > run by the CPA before I say yes. I say that because I was taken by the > old group of Mad Dogs with that the last time, and it won't happen > again. > > Thanks > SP >
From: StovePipe on 17 Oct 2005 23:29
Amatus Cremona wrote: > > > Do enjoy being held hostage by your staff ? > Amatus Non, Monsieur! That is why I'm getting the XL routines going; so that if they all decide to support my secretary, they can all leave, and I can still function. Being held hostage? No. But if we can't be on good terms, then what is the point? The point that matters to me is that this lady (popular though she is) has stolen money from me (when I sorely needed it) and then tried her damnedest to cover it up. I cannot trust her with the petty cash, or with any form of payment involving money. If that isn't enought to make the rest see things in a different light, then there is no justice here. Thanks SP |