Jack Parsons
New member
- Joined
- Nov 7, 2008
- Messages
- 1
- Programming Experience
- Beginner
Let me start of with an explanation of what I am trying to do. I work for the Air Force in Texas in a radio maintenance shop. I learned some basic VB several years back and am now presented with an opportunity to create a program for our replacement plans we have with our radio equipment. I am having trouble just getting started, so I guess I need a kick start or something.
Note: The form is attached.
There is a simple formula to this. We keep track of how old the equipment is and how many maintanence actions have been performed on the equipment. So, for the age of the equipment in years we multiply that by 2. We multiply the amount of maintanence actions by 3. If the equipment has been phased out we add 15. We add the results and apply to our points system below.
So breaking it down:
2 points per year of age
3 points per repair action
15 points per year for phased out equipment
If the value is
0 - 45 Doesn't need to be replaced
46-50 Needs to be replaced in 5 years (Current date + 5)
51-55 Needs to be replaced in 4 years (Current date +4)
56-60 Current date + 3
61-65 Current date + 2
66-75 Current date + 1
76 + Current date
With that, I am trying to take the users input from "Age (In Years)", "Prev Maint Actions", and "Year Phased Out (if applicable)" and display the replacement date in the "Replacement Date" text box.
I would also pay someone if they would be interested in writing this (I don't know if this is against forum rules, if it is I will delete this statement.)
I can't even begin getting the forumlas to work correctly I am just presented with tons of errors. Thanks for any help!
the text boxes are named
AgeTextBox
MaintTextBox
PhasedTextBox
DateTextBox
the buttons are named
GenerateButton
NewButton
ExitButton
Note: The form is attached.
There is a simple formula to this. We keep track of how old the equipment is and how many maintanence actions have been performed on the equipment. So, for the age of the equipment in years we multiply that by 2. We multiply the amount of maintanence actions by 3. If the equipment has been phased out we add 15. We add the results and apply to our points system below.
So breaking it down:
2 points per year of age
3 points per repair action
15 points per year for phased out equipment
If the value is
0 - 45 Doesn't need to be replaced
46-50 Needs to be replaced in 5 years (Current date + 5)
51-55 Needs to be replaced in 4 years (Current date +4)
56-60 Current date + 3
61-65 Current date + 2
66-75 Current date + 1
76 + Current date
With that, I am trying to take the users input from "Age (In Years)", "Prev Maint Actions", and "Year Phased Out (if applicable)" and display the replacement date in the "Replacement Date" text box.
I would also pay someone if they would be interested in writing this (I don't know if this is against forum rules, if it is I will delete this statement.)
I can't even begin getting the forumlas to work correctly I am just presented with tons of errors. Thanks for any help!
the text boxes are named
AgeTextBox
MaintTextBox
PhasedTextBox
DateTextBox
the buttons are named
GenerateButton
NewButton
ExitButton