1. Welcome to Tacoma World!

    You are currently viewing as a guest! To get full-access, you need to register for a FREE account.

    As a registered member, you’ll be able to:
    • Participate in all Tacoma discussion topics
    • Communicate privately with other Tacoma owners from around the world
    • Post your own photos in our Members Gallery
    • Access all special features of the site
    Quick Links: Best Way to Stream from a Laptop to Multiple TV's Wirelessly Netbook ?? Home Security Cameras Apple Watch SanDisk Cruzer 16GB rocks Nimble9 Nerds Out - Custom Water Cooled Computer and 3D printer build

Excel Experts out there?

Discussion in 'Technology' started by memario1214, Oct 28, 2011.

Page 2 of 2
  1. Oct 28, 2011 at 3:37 PM
    #21
    Saskquatch11

    #21
    Saskquatch11 TRUCK YEAH

    Joined:
    Apr 25, 2011
    Member:
    #55548
    Messages:
    13,290
    90.32%
     
    Saskquatch11, Oct 28, 2011
    #21
  2. Oct 31, 2011 at 12:48 PM
    #22
    Evil Monkey

    #22
    Evil Monkey There's an evil monkey in my truck

    Joined:
    Aug 8, 2007
    Member:
    #2352
    Messages:
    8,262
    Gender:
    Male
    First Name:
    Robert
    Escondido, CA
    Vehicle:
    07 4x4 DC SR5 TRD Off-road
    Weathertech front & rear mats, rear suspension TSB, Toytec AAL for TSB, Hi-Lift Jack, Bilstein 5100 & Toytec Adjustable coilovers, Built Right UCAs, KMC XD 795 Hoss Wheels, Definity Dakota MTs 285/75R16, Leer XR, Thule Tracker II & Thule MOAB basket
    You can use "isblank" and "not" functions along with IF() to check the contents of a cell.

    IF(condition, if true do this, if false do this)

    IF(ISBLANK(A1),do something if A1 is blank, do something else if it's not blank)

    Or you can add a Not function to reverse the order
    IF(NOT(ISBLANK(A1)),do something if A1 is not blank, do something else if A1 is blank)
     
    Evil Monkey, Oct 31, 2011
    #22
  3. Nov 1, 2011 at 11:09 AM
    #23
    memario1214

    #23
    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,797
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    Okay, Rob's suggestion helped me out part ways... That allowed me to get my estimated grade figured out. Mark's solution gave me the "answer" I was looking for, but he assigned a percentage value to every score. I still cannot for the life of me get it to calculate my percentage based on the scores I already have. The only number I need this to calculate would be my overall % (Cell D32)... WTF
     
    memario1214, Nov 1, 2011
    #23
  4. Nov 1, 2011 at 12:08 PM
    #24
    memario1214

    #24
    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,797
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    I figured it out!!! WOOT! I can post up my solution later if anyones interested
     
    memario1214, Nov 1, 2011
    #24
  5. Nov 6, 2011 at 2:50 PM
    #25
    memario1214

    #25
    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,797
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    Okay, new question...

    I am not really sure how to word this, but here is what I have got... I have the fields Precinct, Population, # of Violent Crimes, # of Police Officers.

    I have already calculated additional fields out to population per police officer and crimes per police officer. Without adding officers, I need to ensure that no precinct has no more than 1,100 residents per police officer and no precinct has more than 7 violent crimes per officer. The department will transfer police officers from precincts that easily meet these goals to precincts that violate one or more of these ratios.

    A suggestion I got was to use "goal seeking", but I am unfamiliar with it. I tried it, but it will only look at one cell at a time so I don't know if it will help me. Any guidance?
     
    memario1214, Nov 6, 2011
    #25
  6. Nov 8, 2011 at 9:39 AM
    #26
    memario1214

    #26
    memario1214 [OP] Hotshot Offroad Moderator Vendor

    Joined:
    Oct 1, 2009
    Member:
    #23628
    Messages:
    19,797
    Gender:
    Male
    First Name:
    Colton
    Missoula, MT
    Vehicle:
    SOLD - 05 Dub Cab TRD Sport 4x4, CURRENT - '21 Tundra MGM Limited
    And I got that one too!
     
    memario1214, Nov 8, 2011
    #26
Page 2 of 2

Products Discussed in

Official Creality Ender 3 V2 Neo 3D Printer CR Touch Auto Leveling Resume Printing Full-Metal Extruder FDM DIY Printers 220x220x250mm
$199.00
Sovol SV06 3D Printer Open Source with All Metal Hotend Planetary Dual Gear Direct Drive Extruder 25-Point Auto Leveling PEI Build Plate 32 Bit Silent Board Printing Size 8.66x8.66x9.84"
$189.28
Auxbeam 12 Gang Switch Panel Bluetooth RGB AC-1200 with APP&Remote Control Toggle Momentary Pulsed Switch Pod Off Backlight for Truck Offroad UTV ATV Car Marine 12-24V Waterproof 2 Years Warranty
$359.99
DC-DC Boost Module 9-14V to 13.8V 10A 138Wmax Power Supply Converter
$21.00
EKWB EK-CryoFuel Premix PC Coolant, 1000mL, Clear
$22.79
EK-Quantum Torque Rotary 90° - Black Nickel, 90 Degree Fitting
$24.99
HATCHBOX ABS 3D Printer Filament, Dimensional Accuracy +/- 0.03 mm, 1 kg Spool, 1.75 mm, Black
$23.99
WD Blue 500GB Desktop Hard Disk Drive - 7200 RPM SATA 6 Gb/s 16MB Cache 3.5" - WD5000AAKX
$24.36
I/O Crest 4 Port SATA III PCI-e 2.0 x1 Controller Card Marvell 9215 Non-Raid with Low Profile Bracket SI-PEX40064
$26.28
TRENDnet Wireless N Gaming Adapter TEW-647GA (Black)
$34.82
Anker USB C Hub, 341 USB-C Hub (7-in-1) with 4K HDMI, 100W Power Delivery, USB-C and 2 USB-A 5 Gbps Data Ports, microSD and SD Card Reader, for MacBook Air, MacBook Pro, XPS, and More
$34.99
EKWB EK-Tube Zero Maintenance Soft Tubing, 9.5/15.9mm (3/8" ID, 5/8" OD), 3 Meter, Black
$33.99
TP-Link AV600 Powerline Ethernet Adapter - Plug&Play, Power Saving, Nano Powerline Adapter, Expand Home Network with Stable Connections (TL-PA4010 KIT)
$33.99
TP-Link USB Wifi Dongle 300Mbps High Gain Wireless Network Adapter for PC Desktop and Laptops. Supports Win10/8.1/8/7/XP, Linux 2.6.24 - 4.9.60, Mac OS 10.9 - 10.15 (TL-WN822N)
$34.99
SilverStone Technology SST-FN124 120mm Fan with Slim 15mm Design with 3-Pins in Black FN124
$22.68
Transcend TS128GMTS430S 128GB M.2 2242 SATAIII B+M Key MTS430S Solid State Drive
$26.99
CORSAIR VENGEANCE RGB PRO Light Enhancement Kit (Memory Not Included) – Black
$29.99
BrosTrend 1200Mbps Long Range USB WiFi Adapter for PC Desktop Laptop of Windows 11/10/8.1/8/7, Wireless Adapter Dual Band 2.4GHz 300Mbps + 5GHz 867Mbps, 2X 5dBi High Gain Antennas, USB 3.0 Cradle
$29.99
Antec PSU Cables, Sleeved Cable Extension Kit /24pin ATX /4+4pin EPS /8-pin PCI-E /6pin PCI-E PSU Extension Cable Kit 30cm Length with Combs, White Connector，White
$32.99
AC Infinity MULTIFAN S7, Quiet Dual 120mm USB Fan, UL-Certified for Receiver DVR Playstation Xbox Computer Cabinet Cooling
$19.98
Exam Cram CompTIA A+: Exams 220-701, 220-702
$29.95
Lifelong Office Chair Wheels Replacement Rubber Chair Casters for Hardwood Floors and Carpet, Set of 5, Heavy Duty Casters for Chairs to Replace Office Chair Mats - Fits 98%
$29.98
StarTech.com USB to VGA Adapter - 1920x1200 - External Video & Graphics Card - Dual Monitor Display Adapter - Supports Windows (USB2VGAE3)
$42.50
Corsair Vengeance LPX 16GB (2x8GB) DDR4 DRAM 3200MHz C16 Desktop Memory Kit - Black (CMK16GX4M2B3200C16)
$44.99
NETGEAR 5-Port Gigabit Ethernet Unmanaged Switch (GS105NA) - Desktop or Wall Mount, and Limited Lifetime Protection Gray
$44.99
Western Digital 1TB WD Blue PC Internal Hard Drive HDD - 7200 RPM, SATA 6 Gb/s, 64 MB Cache, 3.5" - WD10EZEX
$39.19
Koss Porta Pro Classic On-Ear Headphones, Retro Style, 3.5mm Wired Plug, Durable, Black/Silver
$39.99
Corsair Vengeance 8 GB (2 x 4 GB) DDR3 1600 MHz PC3 12800 240-Pin DDR3 Dual Channel Memory Kit 1.5V (CMZ8GX3M2A1600C9)
$56.19
Linksys SE2500 5-Port Gigabit Ethernet Switch
$59.98
2K Security Camera Outdoor/Home, DEKCO WiFi Outdoor Security Cameras Pan-Tilt 360° View, 3MP Dome Surveillance Cameras with Motion Detection and Siren, 2-Way Audio,Full Color Night Vision, Waterproof
$39.99
Diamond Multimedia VC500 One Touch VHS to Digital File, DVD Converter with Easy to use Software, Convert, Edit and Save For Win781011
$39.99
Wiha 26199 Slotted and Phillips Screwdriver Set in Rugged Canvas Pouch, 8 Piece
$39.76
TP-Link Powerline Ethernet Adapter Starter Kit - AV1000 Gigabit Port, Plug&Play, Ethernet Over Power, Nano Size, Ideal for Smart TV, Online Gaming, Wired Connection Only (TL-PA7017 KIT)
$49.99
A-Tech 16GB DDR4 2133 MHz SODIMM PC4-17000 (PC4-2133P) CL15 2Rx8 Non-ECC Laptop RAM Memory Module
$53.19
CompTIA A+ Certification All-in-One Exam Guide, Seventh Edition (Exams 220-701 & 220-702)
$59.99
CarlinKit Wireless CarPlay USB Adapter, The APK Must be Successfully Installed Before Using USB, for Android car radios with Android System 4.4.2 or Above, only Android car radios, Wired to Wireless
$55.99
Starting Out with Programming Logic and Design (3rd Edition)
$56.72
Samsung SSD 860 EVO 1TB 2.5" SATA III Internal SSD (MZ-76E1T0B/AM)
$140.99
EVGA Z15 RGB USB Gaming Keyboard, RGB Backlit LED, Hotswappable Mechanical Kaihl Speed Bronze Switches (Clicky), 822-W1-15US-KR, Black
$149.94
ASRock Mini-ITX Motherboard (B450 Gaming-ITX/AC)
$145.59
Tobedora Solar Router Solar WiFi Router 4g Outdoor with Solar Power WiFi, Waterproof IP66 Suitable for Trail Camera IP Security Camera, Provide Network for Devices That Require Network connectivity.
$139.00
Razer Wolverine V2 Chroma Wired Gaming Pro Controller for Xbox Series X|S, Xbox One, PC: RGB Lighting - Remappable Buttons & Triggers - Mecha-Tactile Buttons & D-Pad - Trigger Stop-Switches - Black
$149.99
To Top