Percentage for multiple columns with rounding

So Im working on a weightlifting periodization program and want to make a convenient calculator for the different sets. What I have is two charts, one with all my maxlifts on different repetitions and then the other one which tells the intensity (percent of max).

So for example 100 kg in the first chart. The specific column in the other chart should take this amount and multiply with 0.7, round of to the nearest integer and keep the kg-prefix.

Since there will be diffrent intesity there will be diffrent percents in the second chart referring to a single column in the first chart. Is this possible without the diffrent columns in the second chart interfering with each other?

If this works, the convenience will be that I only have to change the amounts in the first charts and the 480 columns in the second chart will change the values automatically.

Im sure excel already have one formula for this, I couldnt find it tho.

Hope I was clear enough, grateful for help

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)