Hello all, What can I say.. I have been perfecting my time and attendance system for while now and its getting there. Custom ribbon, better security, better server end procedures. Overall, It's been coming along quite well. I have taken up a job at a garment manufacturing company. This program, Gerber Accumark is something I have never used before. It's a pattern design program which seems to have excellent functionality. The Concept: The company uses a standard set of sizes of patterns to make Riding Apparels. These sizes range from child 4 to child 12, women 6 to women 22 and men 34 to men 48. From these patterns, the alterations are made. The Problem: The patterns are inconsistent, simply put. The sloppiness on the point to point of a 6 child is different from the sloppiness women 22. This creates a problem for the alterations. You would think that if you reduce the point to point on the 6 and the same on the 22, then it would be the same movement. However, that's not how the guy who was doing it before me did it. Alterations: The company hired a guy who spent over one year designing a system that will facilitate the "uniqueness" of this problem. The guy built an excel file and had all the base data set up. each point moves independently. What he did was move the points based on percentages on X,Y format. So if the point to point was reduced he moved the point by a certain percent on the X and a certain percent on the Y giving the final position of the point. This worked but not perfect. If he used an order for 6 child, he would change the percent to suite that but remember I said earlier that the sloppiness is different from size to size. Hence, whatever percent he used for on size 6 would not work on size 22! This back and forth adjustments to "formulas" went on forever. It was a circle. The solution: Mathematics, High school mathematics. Recall that we are dealing with lines and most of them are straight lines. Recall also that we are moving based on X and Y. This tells me that I can use geometry to solve the problems. Do you remember how to find the Gradient of a line? Do you remember how to find the equation of a line? Do you remember Pythagoras Theorem? Gradient (m) = (Y2 - Y1) / (X2 - X1) Equation of the line = Y = mX+C where C is the Y intercept. Now if we know the gradient and we X,Y we can say that: C = Y - mX Using those we can properly calculate exactly where the point should fall accurately. Pythagoras Theorem states that the square of the hypotenuse of a right angle triangle is equal to the sum of the squares of the other two sides. a^2 + b^2 = c^2 Extended problem to consider. In these patterns, we know how much we need to move along c but we don't know a or b. This is a very difficult problem if you don't become creative. I searched all over the internet for a solution but I couldn't find one. I came up with something that gives me an extremely close answer and I am willing to work with it. To know how much I need to move on a, I subtract the absolute value gradient from 100 represented by a percent and multiply that by c. So assume that I need to reduce the point to point by 1.25 inches and the gradient is -2.5 i would move a (Y) by 1.25*(100-2.5)% = 1.21875 I would use the gradient formula to find where on the line b needs to fall. In the end I should have the correct answer or close enough. There are lots of other mathematical formulas I am using now in the excel file. Later, I will make the excel file into a database that will be able to store orders, etc. If you need any assistance in finalizing the Gerber Accumark Program, let me know. I'm sure I could be of assistance. |

Help >