Apple Ask & Answer

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 ...

Duplicates on Photos? How can I quickly delete duplicate photos? Answer: What kind of duplicates do you have in your library? Photos is checking for duplicates, when you are importing photos. It should not be possible to have identical image files in your Photos Library, unless you are ignoring the warning about duplicate files on import, or are mixing different methods of import, so the duplicate detection will be disabled. To avoid duplicates, do not use two different kinds of importing. You will get duplicates, if you import manually via USB from an iPhone or iPad and have iCloud Photos or My Photo Stream enabled it the same time. Or if you are downloading photos from an iPhone or iPad and converting the photos to JPEGs during the import, The converted photos cannot be recognised as duplicates. It will help to find out what has created the duplicates and to avoid it in future. And knowing the kind of duplicates will help find them with smart albums. Photos has no tool ...