Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Mar 27, 2013, 08:56 AM   #1
ArtOfWarfare
macrumors 603
 
ArtOfWarfare's Avatar
 
Join Date: Nov 2007
Send a message via Skype™ to ArtOfWarfare
Numbers Equation Help...

I don't normally consider using Excel or Numbers to be programming but I know other people do and I feel like this might be beyond the people who frequent the other sections of the forums so here goes.

I want to be able to write a simple spreadsheet for calculating my grade in a class that has the following 3 input columns:

A: Names for all my assignments
B: The grades I got on each assignment
C: A list of weights

Now here's where it gets a bit confusing: The weight and grade in a given row aren't necessarily related to each other. Instead, the highest grade in column B gets the highest weight in column C, the second highest grade in column C gets the second highest weight in column C, and so on. I don't want the table sorted automatically by any column (I'll manually drag stuff around as necessary.)

I want an output column D which contains B, from the same row, multiplied by the correct value from C, as described in the preceding paragraph.

Does anyone know how I can do this in Numbers? I've looked up and down the available functions nothing is jumping out at me.

Edit: Naturally, it's right when I post the question after weeks of searching that an idea comes to me...

I see there's a RANK function and an INDEX function... I feel like between these two things I almost have an answer...

Actually, never mind, I just found an even more obvious function, LARGE...

D = B * LARGE(C:, RANK(B, B:, TRUE))

Now I just need to remember how exactly formatting equations works and this will be totally solved...

Edit 2X:

All done! Here's what the properly formatted formula looks like:

= (Scored Set 1) * LARGE((Available Weights), RANK((Scored Set 1), (Scored)))

It seems that getting the value from a specific cell in the same row of a different column is just (<Column Name> <Row Name>) and getting all the values from a specific column is just (<Column Name>).

Edit 3X:

Actually... it's not quite done yet... given multiple scores of equal value, it'll consider them to have the same rank, and so a single weight could be used multiple times. I may have to hack together a solution...
__________________
Battery Status - On the Mac App Store
The only app that'll estimate when your wireless devices will need their batteries changed.
Including the ones paired with other Macs on your network.

Last edited by ArtOfWarfare; Mar 27, 2013 at 10:01 AM.
ArtOfWarfare is online now   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Certain Equation editor for excel Knisse Mac Basics and Help 0 Oct 25, 2013 10:08 AM
Reconsidering the Applecare equation on the MBA clyde2801 MacBook Air 13 Sep 17, 2013 05:19 PM
The iMac / Mac mini equation jcmguitar iMac 12 Dec 19, 2012 02:52 PM
Presentation apps for iPad with equation editor support badboyz31 iPad Apps 3 Jul 26, 2012 06:05 AM

Forum Jump

All times are GMT -5. The time now is 08:58 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC