Visual Basic Program (Math Calculator) Needs Modification

Source code is included! See attachments Modifiactions needed 1. I need the program to make up to 14 new reports per batch and it needs to be done in Excel. It needs to make all 14 reports at a time, not one at a time. It's ok if the program takes a while to run, but it shouldn't crash. 2. The program does NOT need to display the combination files that pop up inside the Batch Math Calculator . This should make it run faster and smoother. All I need is the results in one excel file. 3. I have attached 4 excel batch files that were used to generate the reports as I need them to be done. 4. Let's say there are 181 results inside each of the 4 batch excel files. Let's call it 180 results since the first line contains header info and is not an actual result. 5. I need the program to run the batch just like before but I need a new batch report for each multiple of 10 from 180 results per file down to 50 results per file. ## Deliverables Visual Basic Program (Math Calculator) Needs Modification Source code is included! See attachments Here's how to run the existing Visual Basic "Math Batch Calculator" program. 1. Open bach math calculator 2. Go to "File" then "Import" 3. Find the path and select ALL 4 excel files called qpoll. 4. Go To "File" then "Combinations" 5. Wait until all 15 files are created and then go to "File" then "Results". This is the current report that is in .jpg format Modifiactions needed 1. I need the program to make up to 14 new reports per batch and it needs to be done in Excel. It needs to make all 14 reports at a time, not one at a time. It's ok if the program takes a while to run, but it shouldn't crash. 2. The program does NOT need to display the combination files that pop up inside the Batch Math Calculator . This should make it run faster and smoother. All I need is the results in one excel file. 3. I have attached 4 excel batch files that were used to generate the reports as I need them to be done. 4. Let's say there are 181 results inside each of the 4 batch excel files. Let's call it 180 results since the first line contains header info and is not an actual result. 5. I need the program to run the batch just like before but I need a new batch report for each multiple of 10 from 180 results per file down to 50 results per file. 180 results 170 results 160 etc etc 150 140 130 120 110 100 90 80 70 60 50 If there are only 100 results in each of the 4 excel files, then the program will still work, but will only generate 6 reports. 100 90 80 70 60 50 The program will always start at the highest multiple of 10 and work its way down the last report at 50 results per file. There will be a maximum of 14 generated reports displayed in Excel. I need all 14 reports to go into one excel file like in the example. The attached report that I did manually will show exactly how to create it. 6. There are only 8 numbers to worry about inside the newly created excel report. 1 2 3 4 5 6 7 8 There is a relationship between the 8 numbers. They are paired for coloring. 14 Blue 72 Green 38 Yellow 65 Orange The report is exactly the same as before, but it is just displayed differently. There are 8 rows and 8 columns. Only numbers that have data will show up in the report (largest results to lowest / left to right) so there will usually be a lot less numbers in each report than the full 8x8 or 64 number results. All results now need to be rounded down to one decimal so no more 1.833333 would now become 1.8 There are two numbers in each grid. The first number should be BOLD (font size 10) and is the 1-8 numbers. the 2nd number should be non bold (font size 8) 3 spaces to the right and corresponds to the number of times the left number shows up. Just compare the existing jpg report and the new excel report I made and it should make sense. ***It may have to be opened in Excel 2007 or later to show the different text sizes**