Apple Numbers - Ranking wins and losses f… , FaceTime on ipad , Apple TV Subscription

Apple Numbers - Ranking wins and losses f…

I am trying to create a spreadsheet for a youth sports league I manage that will track teams standings live as they accrue wins and losses through the season. In column A4:A15 I have the team names, column B4:B15 is wins, C4:C15 is losses, D4:D15 is ties, and then E4:E15 is standing. So basically what I want is for the spreadsheet to rank the teams by wins first, then to use losses as the 1st tie break, then ties as the final tie break. How can I do this?? I am fairly new to Numbers (former excel user) so I don't know how to arrange the formula.

Help!!

Answer:

Would this do what you want?

First calculate a composite "score" that accounts for wins, losses, and ties, and then rank those scores.

Formula in E2, filled or copied down:

=B2−C2*0.1+D2*0.1

You may want to change the 0.1 weightings for a different relative importance of losses vs ties.

Formula in F2, filled or copied down:

=RANK(E2,E)

Replace the , in the formulas with ; if your region use , as a decimal separator.

If it does what you want then you can hide column E.

Answer:

This is very helpful. I applied it to my spreadsheet and it worked great. I do have two issues though that you could maybe help with also. How do you prevent ties and how do you flip the rankings so the highest score is ranked #1 and then descend from there?? I have one team that is 4-0-0 and one that is 4-1-0. It gives the 4-0-0 team a score of 4 and ranking of 10, and the 4-1-0 team a score of 3.9 and a ranking of 10. so ideally those would not be tied. And also how to do you flip the rankings because it has the teams with the lowest score ranked higher than the teams with higher scores. So I have a team that is 0-2 currently ranked higher than the team that is 4-0-0.

Answer:

TateRedd33 wrote:

How do you prevent ties and how do you flip the rankings so the highest score is ranked #1 and then descend from there??

The example does rank the highest score as 1 and descend from there (column F).

What kind of ties are you seeing?

It would help to see your data and what specifically you want to occur. To post a screenshot, shift-command-4, drag to select area with the "cross-hairs", release, start a new post here and insert the screenshot image from the Desktop using the "mountains and moon" Image Insertion icon below the compose window here.

Answer:

you could just sort the table, in SG's example table

Sort Column D in Descending order

then C in ascending order

then B in descending order.

this would produce the same result basically,

you can add a basic formula to compare one row to the one above to see if the Win/Loss/Tie is exact match to find true "ties" where the teams have the exact same record.

Jason

Answer:

Let me ask some questions.

Have all the teams the same numbers of games or have some teams not played all games when you create this chart?

In soccer we have the rule that a team gets 3 points for a win and 1 point for a tie, the total of your points will define your rang in the season. Do you have something similar?

Who is better? Team A has 1 win and lost 2 times, team B has 3 ties. Both teams played 3 games!

You have to define the weightings for a different relative importance of wins, losses & ties

Why do you go with 1st numbers of wins, 2nd numbers of losses and 3rd numbers of ties.

Wouldn't it be better to go with 1st numbers of wins, 2nd numbers of ties and 3rd numbers of losses (if really needed)?

Here my proposal:

Ralf

Answer:

FaceTime on ipad

I'm looking to buy my elderly mother a 10.2" iPad so that we can FaceTime her to talk to her. Can we FaceTime with an ipad that is on Wi-Fi that is not on a cellular plan? Or does it need to be assigned a line on my cellular plan in order to FaceTime with her?

Answer:

FaceTime can work on Wi-Fi only on non cellular devices. There's no need to get a cellular plan to FaceTime on an iPad no.

Answer:

FaceTime can work on Wi-Fi only on non cellular devices. There's no need to get a cellular plan to FaceTime on an iPad no.

Answer:

Thank you!

Answer:

Apple TV Subscription

I do not wish to continue with Apple TV subscription for Order ID: MQ1M9MXMDH

Answer:

Click here and follow the instructions.

(217259)

Answer:

Click here and follow the instructions.

(217259)

Answer:

Apple Watch wont scroll to the control ce…

Can't get to the control center after the recent software update. How can this be reset?

Answer:

new magic keyboard with touch id

I have a mid-2020 MacBook Pro with Intel and Touch ID. In my simplistic brain, if Touch ID works on this machine, is it possible it would work on the new magic keyboard with Touch ID?

Answer:

Yes, that is correct. 😉

Answer:

Yes, that is correct. 😉

Answer:

Face ID not work

Answer:

No details?

How to use Face ID:

Face ID not working?

Face ID issues that are triggered by a software update usually requires service.

Get expert service and support at the Genius Bar.

Answer:

No details?

How to use Face ID:

Face ID not working?

Face ID issues that are triggered by a software update usually requires service.

Get expert service and support at the Genius Bar.

Answer:

Siri messing up text message dictation

Sorry rug has been dictating and sending text correctly, all of a sudden doesn't dictate anything I say correctly.

Help please

Answer:

Original message should read…..Siri

Answer:

Can you use your card as a credit card to…

Can you use your card as a credit card to pay bills

Answer:

Yes. The Apple Card is a credit card. It can be used for anything a Credit Card can be used for.

Answer:

Yes, Apple Card is a MasterCard and can be used at any merchant/business that accepts MasterCard. If they accept Apple Pay you'll earn 2% in Daily Cash Back.

Answer:

If i reset my iphone8 will i lose my phot…

If i reset my iphone8 will i lose my pictures and contacts ?

Answer:

Hey RCE1113,

If you don't have your photos and contacts backed up, you certainly would. If you sync your contacts with iCloud or another mail account, they'll be stored safely there though and all you'd need to do is enable Contacts again for the mail account they're synced to after resetting to get them back.

As for photos and videos, if you use iCloud Photos, they'll be stored safely there. If you don't use iCloud Photos, but complete a regular backup to iCloud or a computer, then again they'll be stored safely there.

For help with ensuring all this data is stored safely and for more info on restoring backups, check out the following:

How to back up your iPhone, iPad, and iPod touch - Apple Support

Restore your iPhone, iPad, or iPod touch from a backup

Set up and use iCloud Contacts - Apple Support

We hope these resources help out with ensuring all your data is stored safely.

Take care!

Answer:

External/Mirror button in touch bar

When I connect an external display the extended/mirror option appears in the touch bar. If I happen to click the x, (to use another function), it disappears and I have no idea how to get back to it. I cant even find it in display setting. Can someone help me figure out how to display these settings in the touch bar and/or how to switch from ext to mirror on a MacBook Pro (16-inch, 2019), Big Sur 11.6.1, 2.3 GHz 8-Core Intel Core i9, 32 GB 2667 MHz DDR4, Intel UHD Graphics 630 1536 MB.

I need this switch from ProPresenter to my Keynote presentation and back to ProPresenter during our church services.

Thank you in advance for any help.

Answer:

Hi there D,

Welcome to Apple Support Communities.

After hitting the X, how are you using the external display? Is the MacBook closed?

If you choose or set up an extended display or mirroring, does the Touch Bar still disappear?

Use one or more external displays with your Mac - Apple Support

"Set up the displays as an extended desktop

You can arrange your displays in any configuration to create an extended desktop. For example, you can set your external display side by side with your Mac to create one large continuous desktop.

Note: You must be connected to a display to see these options.

On your Mac, choose Apple menu > System Preferences, click Displays , then click Display Settings.
Click the name of your display, then choose Extend Display from the pop-up menu.

Set up the displays for video mirroring

Video mirroring shows the entire desktop on each display.

Note: You must be connected to a display to see these options.

On your Mac, choose Apple menu > System Preferences, click Displays , then click Display Settings.
Select your display, then choose Mirror for Display from the pop-up menu."

Are you using an iPad? Use an iPad as a second display for a Mac - Apple Support

"Use the Touch Bar

Many apps on Mac have Touch Bar controls that make common actions even easier. With Sidecar, you get a Touch Bar on your iPad screen even if your Mac doesn't have a Touch Bar. Tap its controls with either your finger or Apple Pencil. If the Touch Bar doesn't appear when using an app that offers Touch Bar controls, choose Apple menu  > System Preferences, click Mission Control, then make sure that "Displays have separate Spaces" is selected."

Best regards!

Answer:

Apple Watch

Wie kann ich meine Apple Watch in „Wo ist" für andere Familienmitglieder unsichtbar machen?

Answer:

Danke für deine Teilnahme an der Apple Support Community. Seit Neuestem gibt es diese auch in deutscher Sprache. Über diesen Link erhältst du Zugang: Offizielle Apple Support Community. Wir würden uns freuen dich dort wiederzusehen um deine Fragen bestmöglich zu beantworten.

Answer:

Why doesn't Apple have an iPad upgrade pr…

Why doesn't Apple have an iPad or MacBook Pro upgrade program?

Answer:

Apple has a trade-in programme - which, effectively, allows you to "upgrade" your older model device to something new.

See >>> Apple Trade In - Apple

Answer:

There's no way to know why. Apple has not said why they don't haver an iPad upgrade program, and we cannot speculate on Apple decisions here.

Answer:

Apple has a trade-in programme - which, effectively, allows you to "upgrade" your older model device to something new.

See >>> Apple Trade In - Apple

Answer:

it is not the same as the iPhone upgrade program.

Answer:

There's no way to know why. Apple has not said why they don't haver an iPad upgrade program, and we cannot speculate on Apple decisions here.

Answer:

Technically, Apple does have an iPad upgrade program, in the form of their Apple device Trade-in program

Apple Trade In - Apple

Answer:

ipod won't sync with mc

ipod won't sync with mac

Answer:

Hi Nelson-,

Thanks for coming to Apple Support Communities for help today.

It seems you have been to the correct article.

Which iPod do you have? If you have an iPod touch what is the iOS showing in Settings > General > About?
Are you running High Sierra on the Mac or another macOS? You can find this in the Apple pull down menu and About This Mac.
What happens when you attempt to sync?
Are you able to test with another cable?

Does your computer even recognize the iPod? If not these steps can help: If your computer doesn't recognize your iPhone, iPad, or iPod.

Let us know more details if the issue is continuing.

Have a fantastic day!

Answer:

Thanks for getting back. After some time, running around to find a cable that fit (ipod classic) I found one that would sync up to the Mac. Thanks and have a good day. Nelson

Answer:

Nelson,

We appreciate the information. If you have other questions, let us know.

Thanks for being a part of Apple Support Communities.

Have a great day.

Answer:

iPad screen saturation

My iPad has suddenly changed to garish colour saturation on games and photos. Changing the brightness makes it worse. How can I change it back to normal?

All buttons are off on display Accommodations

Photos on the iCloud have become grainy and tooo colourful, as well as the screen colours. Text is ok

Answer:

If the screen colours appear to be distorted or unnatural, you need to check some key Accessibility settings that are intended to compensate for specific colour-vision issues:

Settings > Accessibility > Display & Text Size

Ensure that all settings enclosed within the red box above are switched OFF/Disabled.

Otherwise, depending upon your installed version of iOS/iPadOS, you'll need to look at your Dark Mode settings:

Settings > Display & Brightness > [Appearance]

If you continue to experience difficulties, you might be well advised to seek assistance directly from from Apple Support. You can contact the Support Team using the Get Support link at top-right of this page. Alternatively, you can initiate and manage your support cases using the excellent Apple Support App. If not already installed on your iPad, the App can be downloaded from the App Store:

https://apps.apple.com/gb/app/apple-support/id1130498044

You might also visit the Genius Bar at your local Apple Store or Apple Authorised Service Provider (AASP) - where the technicians will be able to test and assess your iPad:

Genius Bar Reservation and Apple Support Options - Apple

Answer:

If the screen colours appear to be distorted or unnatural, you need to check some key Accessibility settings that are intended to compensate for specific colour-vision issues:

Settings > Accessibility > Display & Text Size

Ensure that all settings enclosed within the red box above are switched OFF/Disabled.

Otherwise, depending upon your installed version of iOS/iPadOS, you'll need to look at your Dark Mode settings:

Settings > Display & Brightness > [Appearance]

https://apps.apple.com/gb/app/apple-support/id1130498044

You might also visit the Genius Bar at your local Apple Store or Apple Authorised Service Provider (AASP) - where the technicians will be able to test and assess your iPad:

Genius Bar Reservation and Apple Support Options - Apple

Answer:

GarageBand Fading In/Out Frustrations

Hi all....I've been using GarageBand for simple edits for a very long time. I have been fading in and out on tracks for years but since getting this new MacBook Pro, I cannot figure out for the the life of me how to fade in and out anymore in GB. I've watched some tutorials and there seems to be a button that I don't have access to. Can anyone help me figure this out? It used to be so simple!

Thanks

Answer:

Greetings TourmalineZ,

You can find steps to record and edit content using Garage Band here:

macOS app user guides: GarageBand for MacUser Guide - Apple Support

Take care.

Answer:

No Power!!

I have an older Mac that I'm unable to update the operating system. I just experienced a power outage and now my Mac will not power up all the way and powers itself off. I've unplugged the computer, held down the power button, and nothing is happening. I do not have access to the start-up disk.

Answer:

Welcome to Apple Support Community.

Depending on your issue, see:

Cheers,

Jack

Answer:

Is there a way to get a utility disk for my older Mac? It powers up, but during the boot up it shuts down each time. I'm sure it's the operating system which I'm unable to update.

Answer:

OlderMAC62 wrote:

Is there a way to get a utility disk for my older Mac? It powers up, but during the boot up it shuts down each time. I'm sure it's the operating system which I'm unable to update.

What year is your iMac? If you don't know, enter the serial number, which can be found on the bottom of the stand, here: Check Your Service and Support Coverage - Apple Support.

Jack

Answer:

It was purchased back in 2010. Yes, it's an older system. I know that I'm unable to update the operating system because of it. Recently moved states and have absolutely no idea where the recovery disks are.

Answer:

Typing

When typing on my iMac I get blue dots between the words where I should be spices

Answer:

Web search finds: blue dots appear in between words in Page… - Apple Community

Answer:

Web search finds: blue dots appear in between words in Page… - Apple Community

Answer:

How do I restore by video projects in iMo…

How do I restore on my Mac mini my video projects in iMovie

Answer:

You can use your Time Machine backup to restore your iMovie library to a point in time before the crash.

Or, you can try looking in the iMovie Backups folder to open a previously saved iMovie library.

To get to the iMovie Backups folder, follow this file path from the Finder menu:

Go/Home/Library/Containers/com.apple.iMovieApp/Data/Library/Caches/iMovieBackups

When you get there you will see a list of previous backups of your iMovie library. Click on one dated just before

your issue started. iMovie will open in that library. Navigate to your projects browser (where your projects are displayed as icons) and see if your projects are intact.

-- Rich

Answer:

Screenshot resolution

I have an iPad Pro 9.7 in., running 15.4.1 OS. Lately when I do a screenshot to email or text to someone, the resulting image is blurry and unreadable on the receiver's end. This has not always been a problem, as previous photos and docs have gone through just fine. What's going on, and is there anything I can do to fix it?

Answer:

Hey CruBev,

We'd be happy to help out. To clarify, are you using iCloud Photos? If so, it's possible there was a slow network connection at the time you attempted to send the photo. Were you on cellular, Wi-Fi, or are you noticing it on both?

Also, you might want to save the screenshot first and then go to Photos > Albums > Screenshots to then send it and see if that helps at all.

Let us know if that helps out and also let us know more about the network connection and iCloud Photos status so we can begin isolating further.

Lastly, here's a great resource on sending photos on iPad: Send and receive photos, videos, and audio messages on iPad - Apple Support

Take care!

Answer:

Hey CruBev,

Also, you might want to save the screenshot first and then go to Photos > Albums > Screenshots to then send it and see if that helps at all.

Let us know if that helps out and also let us know more about the network connection and iCloud Photos status so we can begin isolating further.

Lastly, here's a great resource on sending photos on iPad: Send and receive photos, videos, and audio messages on iPad - Apple Support

Take care!

Answer:

I need help empty my apple store credit

Hi my apple store credit is $0.019 and I need to empty it

Answer:

Buy something more expensive and pay the balance with a credit card or contact iTunes Support and ask them to zero balance your account. See the Apple Support articles below for contact information.

iTunes Support – world wide -

Apple Support schedule phone call -

Billings and Subscriptions -

Apple on Twitter

Answer:

Buy something more expensive and pay the balance with a credit card or contact iTunes Support and ask them to zero balance your account. See the Apple Support articles below for contact information.

iTunes Support – world wide -

Apple Support schedule phone call -

Billings and Subscriptions -

Apple on Twitter

Answer:

Search This Blog

Apple Ask & Answer