Help with calculating/organizing a dynamic chart

[iluvweed]

Hello thank you for taking the time to read this and help me, because I need it! I have been working on this for weeks. What I am trying to accomplish is create a list of training courses for employees. I listed all the training in columns and on the left are their names. I made the columns one for each chapter of training. In the column is where the date goes that they completed. It goes all the way to column CB2. There are 65 training courses. My problem is, I want there to be a way to display the percentage complete for an individual employee. However, here is where it gets tricky. For the columns, I want there to be 15 extra "blank spots". These spots are for the trainer to add additional training custom to them. If they want to add a special course, etc. So I want it to show 100% (when all completed) but take into consideration any additional courses they took if any. If not, it will just read the 100, etc. I'm sure you get the point. However, I can't come up with a way to calculate under these conditions. I can do it now, based off the set 65. I can even do it so the formula reads there is an extra course and takes that into consideration with the percentage, but there's no way for me to actually mark it complete. Thats the big problem for me because the two lists are using different parameters and I need to merge them. What I mean is, The first 65 courses only mark true or false if they see a date, the custom list is true or false based off the addition of a new course, not a date. So I need a cell to show the percentage trying to combine these two. Any help or insight into this would be greatly appreciated, thank you!