As I was getting ready to make the changes and fixes to the DQ spreadsheet/email program, it suddenly occured to me, that I might be making this more difficult than it needs to be. Especially since, I believe everyone is accepting the print it yourself DQ card instead while they were waiting for fixes to spread sheet program.
Some History: When we first started the program, there was only Klingspor. My original intention, was to send them a complete list of dq people every month. Coleman, however, said the computer entry was manual and he wanted to minimize the amount of data entry. What he wanted was something like he did with the more conventional WWing clubs. Once a year they would send him a complete list of members. And periodically, (monthly?) they would send a list of changes.
Remember, from Klingspor's point of view, they are trading a mailing list for the discount. There really is not a whole lot of need fror them to remove someone from their list. except it is a condition of our sending them the list. Thus was born the DQ spreadsheet.
Of course, Klingspor's employees would accept any "proof" that person was a member of NCWW, even if they weren't in the Klinspor computer system.. In fact, some people are in the Klingspor computer system multiple times. Once from the spreadsheet and another becuase the person said they were a member and the Klingspor employee would simply add them to the system.
Since then, we have 2 more vendors that have been added to the spreadsheet program, but I don't remember, or never knew what they really wanted. The fact that they are currently accepting just the self print card may imply that we are trying to do more than the vendors really need or want.
So here are 3 options that we could use. We could dictate one and/or let each vendor pick their poison.
Monthly list of all qualified.
Monthly list with add and deletes (what we are supposed to be doing now)
Discount card list which lists the address and the vendors that the holder is qualified for. Or something like it.
Personally, what I would like to see is vendor choice of 2 options.
1 or 3 above
Anyway what do they really require? Is ashville hardware providing a discount and if so, what are they using?
Some History: When we first started the program, there was only Klingspor. My original intention, was to send them a complete list of dq people every month. Coleman, however, said the computer entry was manual and he wanted to minimize the amount of data entry. What he wanted was something like he did with the more conventional WWing clubs. Once a year they would send him a complete list of members. And periodically, (monthly?) they would send a list of changes.
Remember, from Klingspor's point of view, they are trading a mailing list for the discount. There really is not a whole lot of need fror them to remove someone from their list. except it is a condition of our sending them the list. Thus was born the DQ spreadsheet.
Of course, Klingspor's employees would accept any "proof" that person was a member of NCWW, even if they weren't in the Klinspor computer system.. In fact, some people are in the Klingspor computer system multiple times. Once from the spreadsheet and another becuase the person said they were a member and the Klingspor employee would simply add them to the system.
Since then, we have 2 more vendors that have been added to the spreadsheet program, but I don't remember, or never knew what they really wanted. The fact that they are currently accepting just the self print card may imply that we are trying to do more than the vendors really need or want.
So here are 3 options that we could use. We could dictate one and/or let each vendor pick their poison.
Monthly list of all qualified.
Monthly list with add and deletes (what we are supposed to be doing now)
Discount card list which lists the address and the vendors that the holder is qualified for. Or something like it.
Personally, what I would like to see is vendor choice of 2 options.
1 or 3 above
Anyway what do they really require? Is ashville hardware providing a discount and if so, what are they using?