I'm creating an SFAS Table. I need help creating and combining the bottom 2 pictures. I also need help on getting the total to exactly 1 on weight and 3 on the weighted score. Example is the 2nd picture.

NOTES: 1. List each of the most important factors developed in your IFAS and EFAS Tables in Column 1. 2. Weight each factor from 1.0 (Most Important) to 0.0 (Not Important) in Column 2 based on that factor's probable impact on the company's strategic position. The total weights must sum to 1.00 . 3. Rate each factor from 5.0 (Outstanding) to 1.0 (Poor) in Column 3 based on the company's response to that factor. 4. Multiply each factor's weight times its rating to obtain each factor's weighted score in Column 4. 5. For the duration in Column 5, check the appropriate column (short termless than 1 year; intermediate - 1 to 3 years; long termover 3 years). 6. Use Column 6 (comments) for rationale used for each factor. External Factors Weigh Rating Weighted Score Comments 1.Economic Marketplace is global Uncertain global economic conditions The great recession and its slow recovery Unfavorable foreign exchange rates 2. Technological Communication technology constantly changing Communication methods becoming inexpensive Bringing local commerce onto the internet First-mover advantage based on "tipping point" 3. Political and legal Consumer protection and regulations Evolving regulation of internet business Ethics of using Groupons and daily deals Restatement of earnings in 2021 0.06 0.2 Groupon's global presence offers growth opportunities 0.14 Economic instability may affect to consumer spending 0.07 0.12 Lingering effects may reduce consumer discretionary spending 0.1 Adverse currency fluctuations may impact internal operations 4. Sociocultural Increased availability of price information Information conscious consumers Reduced loyalty if prices aren't competitive Changing consumer behaviors on discounts Total 0.14 0.14 0.12 0.18 0.32 0.06 0.27 0.1 0.24 0.28 0.18 0.12 2.71 Groupon needs to adapt to new communication methods Cost-effective communication benefits Groupon Opportunities in expanding the online marketplace Early adoption offers benefits but competition may arise Compliance is essential for consumer trust Not applicable to Groupon's operations Maintaining ethical practices is crucial for reputation Past financial issues may impact investor confidence Transparency can attract informed consumers Catering to consumer information needs is essential Price competitiveness is critical for customer retention Understanding consumer trends is important for success 1 3 - 1. In Column 1 (Strategic Factors), list the most important EFAS and IFAS items. After each factor, indicate whether it is a Strength (S), Weakness (W), an Opportunity (O), or a Threat (T). 2. In Column 2 (Weight), assign weights for all of the internal and external strategic factors. As with the EFAS and IFAS Tables presented earlier, the weight column must total 1.00. This means that the weights calculated earlier for EFAS and IFAS will probably have to be adjusted. 3. In Column 3 (Rating) assign a rating of how the company's management is responding to each of the strategic factors. These ratings will probably (but not always) be the same as those listed in the EFAS and IFAS Tables. 4. In Column 4 (Weighted Score) multiply the weight in Column 2 for each factor by its rating in Column 3 to obtain the factor's rated score. 5. In Column 5 (Duration), depicted in Figure 6-1, indicate short-term (less than one year), intermediate-term (one to three years), or long-term (three years and beyond). 6. In Column 6 (Comments), repeat or revise your comments for each strategic factor from the previous EFAS and IFAS Tables. The total weighted score for the average firm in an industry is always 3.0. NOTES: 1. List each of the most important factors developed in your IFAS and EFAS Tables in Column 1. 2. Weight each factor from 1.0 (Most Important) to 0.0 (Not Important) in Column 2 based on that factor's probable impact on the company's strategic position. The total weights must sum to 1.00 . 3. Rate each factor from 5.0 (Outstanding) to 1.0 (Poor) in Column 3 based on the company's response to that factor. 4. Multiply each factor's weight times its rating to obtain each factor's weighted score in Column 4. 5. For the duration in Column 5, check the appropriate column (short termless than 1 year; intermediate - 1 to 3 years; long termover 3 years). 6. Use Column 6 (comments) for rationale used for each factor. External Factors Weigh Rating Weighted Score Comments 1.Economic Marketplace is global Uncertain global economic conditions The great recession and its slow recovery Unfavorable foreign exchange rates 2. Technological Communication technology constantly changing Communication methods becoming inexpensive Bringing local commerce onto the internet First-mover advantage based on "tipping point" 3. Political and legal Consumer protection and regulations Evolving regulation of internet business Ethics of using Groupons and daily deals Restatement of earnings in 2021 0.06 0.2 Groupon's global presence offers growth opportunities 0.14 Economic instability may affect to consumer spending 0.07 0.12 Lingering effects may reduce consumer discretionary spending 0.1 Adverse currency fluctuations may impact internal operations 4. Sociocultural Increased availability of price information Information conscious consumers Reduced loyalty if prices aren't competitive Changing consumer behaviors on discounts Total 0.14 0.14 0.12 0.18 0.32 0.06 0.27 0.1 0.24 0.28 0.18 0.12 2.71 Groupon needs to adapt to new communication methods Cost-effective communication benefits Groupon Opportunities in expanding the online marketplace Early adoption offers benefits but competition may arise Compliance is essential for consumer trust Not applicable to Groupon's operations Maintaining ethical practices is crucial for reputation Past financial issues may impact investor confidence Transparency can attract informed consumers Catering to consumer information needs is essential Price competitiveness is critical for customer retention Understanding consumer trends is important for success 1 3 - 1. In Column 1 (Strategic Factors), list the most important EFAS and IFAS items. After each factor, indicate whether it is a Strength (S), Weakness (W), an Opportunity (O), or a Threat (T). 2. In Column 2 (Weight), assign weights for all of the internal and external strategic factors. As with the EFAS and IFAS Tables presented earlier, the weight column must total 1.00. This means that the weights calculated earlier for EFAS and IFAS will probably have to be adjusted. 3. In Column 3 (Rating) assign a rating of how the company's management is responding to each of the strategic factors. These ratings will probably (but not always) be the same as those listed in the EFAS and IFAS Tables. 4. In Column 4 (Weighted Score) multiply the weight in Column 2 for each factor by its rating in Column 3 to obtain the factor's rated score. 5. In Column 5 (Duration), depicted in Figure 6-1, indicate short-term (less than one year), intermediate-term (one to three years), or long-term (three years and beyond). 6. In Column 6 (Comments), repeat or revise your comments for each strategic factor from the previous EFAS and IFAS Tables. The total weighted score for the average firm in an industry is always 3.0