What you want to do is make a separate spreadsheet for each of those categories that I mentioned earlier. Start out by making one for the affiliate programs that you have joined. Label the top left cell ‘Affiliate Name‘. Now you have a choice. In my spreadsheet program, I can right click on that cell and add a hyperlink. If you can do that, I recommend that you make a hyperlink to the place you can look at your stats. If you can‘t do that with your program name the next column ‘stats‘.
Nearly every strength and conditioning coach in the country relies on percentages to enforce desired intensities to athletes for certain lifts. Basically, the client would perform their lift at a percentage of their 1 repetition max. If they had a max bench press of 100lbs, and you wanted to do 3 sets of 12 reps at 60%, they would do 3x12 at 60lbs. This is absolutely necessary in most strength and conditioning environments for multiple reasons, including consistent program design as well as enforcement of intensity (speaking from experience, some people WILL slack if given the chance). So the question becomes, are percentages right for you?