I know that this is a involved problem, but I thought I'd post anyway in case someone is up to a challenge.
My problem is this. I understand that Top Values can't be programmed, you can't create a input box to input Top value. So I thought about it and I have a chart where you can determine what your sample size should be (the Top Values) I am new to this portion of programming so I just need help to start this. On the Left side of the chart (Column 1)there are 10 rows that list limits R1 is 1 to 100, R2 is 101 thru 300, R3 is 301 to 500 etc. Column's 2 thru 4 are the types of audits to be performed Reduced, Normal, and Tightened under these colums you also have ten rows with letters A thru R. At the top of the page is a chart that list this letter vertically with a corresponding number. So basically you find how many files you have determine your which audit you want to run find your letter and then go to the top of the chart and see what number corresponds with the letter and that is you Sample Size (Top Value). Is it possible to put that into a formula? Where you choose which audit you want, your files are counted and based off what audit you run and how many files you have that is the number of files returned.
I know that this is long, and a lot of people might not want to read it, but for the few that will try to wade through my mess, I thank you ahead of time.
My problem is this. I understand that Top Values can't be programmed, you can't create a input box to input Top value. So I thought about it and I have a chart where you can determine what your sample size should be (the Top Values) I am new to this portion of programming so I just need help to start this. On the Left side of the chart (Column 1)there are 10 rows that list limits R1 is 1 to 100, R2 is 101 thru 300, R3 is 301 to 500 etc. Column's 2 thru 4 are the types of audits to be performed Reduced, Normal, and Tightened under these colums you also have ten rows with letters A thru R. At the top of the page is a chart that list this letter vertically with a corresponding number. So basically you find how many files you have determine your which audit you want to run find your letter and then go to the top of the chart and see what number corresponds with the letter and that is you Sample Size (Top Value). Is it possible to put that into a formula? Where you choose which audit you want, your files are counted and based off what audit you run and how many files you have that is the number of files returned.
I know that this is long, and a lot of people might not want to read it, but for the few that will try to wade through my mess, I thank you ahead of time.
