Nine attributes are 75% of the total and 21 attributes are worth 25% of the total.

Nine attributes are 75% of the total and 21 attributes are worth 25% of the total.  I need to create a worksheet that can use x's instead of numbers in the individual attribute cells and then calculate the 9 attributes to equal 75% (9 attributes are the
strongest weighted) and then the 21 attributes to equal 25% (total of 30 attributes scored).  I need the x's to add up the total score.  Do I count each one of the 9 attributes at 8.3 (since 9 doesn't go into 75 evenly)?  Need help - or there is an easier
way to do this?

Keys to the Problem Nine attributes are 75% of the total and 21 attributes are worth 25% of the total.


Hi,

Condtion 1 :sum(Attribute 1: Attribute9)=75% of total
Condition 2:Sum(Attribute10:Attribute30)=255 to total

Value of each attribute according to condition 1 = "2.5*X"   (Reason : (75%*30)/9=2.5)
Value of each attribute according to condition 1 = "0.35*X"   (Reason : (25%*30)/21=0.35)

In the following example, Cell E1 = X

Hope this solves your query.
Post back if you need any help.

Vote for my post if it helps resolve your issue


The Maker


Click here to download the registry repair application


Another Safe way to Repair the problem: Nine attributes are 75% of the total and 21 attributes are worth 25% of the total.:

Click here to download the registry repair application .

How to Fix Nine attributes are 75% of the total and 21 attributes are worth 25% of the total. with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your system. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Computer goes blank when attempting to access a website.,how do i remove fingerprints from my computer screen?,Solution to Error: How to use recovery tools in Windows 7 from the 100mb partition?,References tab APA Citations Margins,How to Fix - Someone please help me. DVD RW drive not showing up! WIN7(STARTER)32 bit?,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22),Missing Microsoft Windows ashoutxt.dll File - How to Fix,How Can I Fix cxcore096.dll Error by Myself,How Can I Fix dsauth.dll Error by Myself,msde.dll Missing,How Can I Fix psizewizres.dll Error by Myself,How to Download ASUS XGI Compatible Super VGA Driver Package Version R1.13.00/Driver Version 6.14.10.1130 for Windows XP 32/64 bit(WHQL),Windows Server 2003 32/64 bit(WHQL),Windows Vista 32/64 bit(WHQL),Windows Server 2008 32/64 bit(WHQL),Windows 7 32/64 bit(WHQL),Window,Update NeoMagic® MagicMedia 256AVP Display Adapter Driver,How to Update NVIDIA RIVA TNT2 Model 64,Download Realtek ALC850 AC'97 Driver V5.10.0.5900 WHQL for Windows 2000/XP/2003 & 64bit XP/2003.,How to Update Realtek LAN V6.203.0214.2008
Read More: How Can I Fix - New Contact \/ Group not appearing in task bar?,Troubleshooting:Networks will not retain the "automatic" connection feature,Troubleshoot:New SSD, Computer no Longer Sleeps via start menu Error,Network Rede Descoberta Compartilhamento Compartilhar Sistema de Rede Entrada Entrada Assist ncia Remota rea de Trabalho Remota RDP TS Remota rea de trabalho Tech Support,How to Resolve new IE tab opens that says internet explorer restricted this webpage from running scripts or active x controls,my shortcuts formates change to .lnk how can i fix it?,My telstra turbo next g network cuts in and out continually while I am n the internet and it is quite difficule at times actually getting internet.,My seagate expansion drive cant be ejected,My word program is locked and I cant edit documents!! HELP,Need to reinstall IE 11