hi can u please answer this question no one seems to understand what im asking for

I want every column to equal 100%, when you add everything up in 2022 it adds up to 100% that column is perfect it doesnt need to be fixed however in the other columns it is way over 100% so the numbers need to change

for example when I start adding petroleum which is 34 natural gas 34 coal 8 nuclear electric 10 im already at 86% when you add everything up in 2022 it equals to 100 perfectly the only other thing that doesnt need fixing is the green hydrogen in all columns

please fix the 2033-2053 columns so that they equal 100%

2. Determine the Optimal Future Energy \% Usage Mix by Category (Fossil Fuels by Type, Nuclear, Solar, Hydroelectric, Wind, Potential Others Like Green/Renewable Hydrogen) for the USA in Years 2033, 2043, and 2053 (show 2022 for reference in your table) (MS Word Table Mandatory) (The Mix Must be Feasible; 100% of Any One Source is NOT Feasible/Realistic) (16 points) (22.2\%) (See EIA Predictions as a Reference Only). You only need to submit the table for full credit, 2. Optimal Future Energy % Usage Mix \begin{tabular}{|l|c|c|c|c|} \hline Coal & 10% & 8% & 6% & 4% \\ \hline Geothermal & 0.2% & 2% & 2.5% & 3% \\ \hline Wind & 3.8% & 38% & 40% & 42% \\ \hline Solar & 1.8% & 16% & 18% & 20% \\ \hline Wood & 2.1% & 22% & 12% & 6% \\ \hline Hydroelectric & 2.3% & 20% & 22% & 22% \\ \hline Biomass Waste & 0.4% & 4% & 4.5% & 5% \\ \hline Biofuels & 2.3% & 18% & 15.5% & 15% \\ \hline Green Hydrogen & N/A & 0.8% & 1% & 1% \\ \hline \end{tabular}