[Solved] Sorting Numbers after calculations

Discuss the spreadsheet application

[Solved] Sorting Numbers after calculations

Postby Boothulu » Sun Feb 17, 2019 6:39 pm

I have 16 names and numbers that I want to sort highest to lowest. The numbers are averages so their value will change. Is there a way to have these 16 lines sort automatically as I change the source of the averages?

For example take 3 people who perform a task for 7 days. Each day the number of times they complete the task changes. If MIke has the highest average for those 7 days I want his name sorted first on a list, followed by the runner up, and so on. If I only want to change the number of times the task was completed for Wednesday because Tom actually did more that day and it makes him the new leader how can I have my list automatically sort to reflect the change?
Last edited by Hagar Delest on Mon Feb 18, 2019 9:10 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.5 in Windows 10
Boothulu
 
Posts: 3
Joined: Sun Feb 17, 2019 6:29 pm

Re: Sorting Numbers after calculations

Postby RusselB » Sun Feb 17, 2019 11:11 pm

Welcome to the Forums.
A macro could do what you are wanting, as it can be associated with the event 'Modified' status has changed.
I am not an expert with macros, and suspect that this may be more work than what it's worth.

In the Standard toolbar, by default, I see two buttons marked Sort Ascending and Sort Descending. These automatically sort in ascending or descending order based on the information in the column that the cursor is in.
This may give you unwanted extra results, but it's the option I would recommend.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 5019
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Sorting Numbers after calculations

Postby Boothulu » Mon Feb 18, 2019 12:05 am

That sounds pretty much like what I'm looking for. The sort ascending/descending does exactly what I need it to... I just want it to sort as soon as a change is made :/
OpenOffice 4.1.5 in Windows 10
Boothulu
 
Posts: 3
Joined: Sun Feb 17, 2019 6:29 pm

Re: Sorting Numbers after calculations

Postby Lupp » Mon Feb 18, 2019 1:04 am

I have 16 names and numbers that I want to sort highest to lowest. The numbers are averages so their value will change.
Where are the numbers the averages are calculated from? How do you keep the association between the primary values and the averages?

For such a small number -in specific a fix one- of rows (data-couples) a sorting by helper formulas would be efficient enough. The original entries stay in place then.

See attachment.
Attachments
aoo97042Ranking_1.ods
(15.77 KiB) Downloaded 12 times
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2414
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Sorting Numbers after calculations

Postby Boothulu » Mon Feb 18, 2019 7:10 am

Lupp wrote:
I have 16 names and numbers that I want to sort highest to lowest. The numbers are averages so their value will change.
Where are the numbers the averages are calculated from? How do you keep the association between the primary values and the averages?

For such a small number -in specific a fix one- of rows (data-couples) a sorting by helper formulas would be efficient enough. The original entries stay in place then.

See attachment.


This is exactly what I needed it to do. The numbers are all on the same sheet, exactly as you did it. TY!!!! Now for the sake of actually knowing how its done vs. just getting the answer. What is the point of the Helper1 and Helper2 rows? I'm trying to dissasemble the formula to understand it. My knowledge of calc is limited. =\
OpenOffice 4.1.5 in Windows 10
Boothulu
 
Posts: 3
Joined: Sun Feb 17, 2019 6:29 pm

Re: [Solved] Sorting Numbers after calculations

Postby Lupp » Mon Feb 18, 2019 2:11 pm

It's a hard fate to be equipped with a teacher's soul: You expend hours trying to give explanations when asked - and next time you will be asked the same questions.

Well, I enriched my example with slightly reworked data (concening the stable/antistable issue) and with explanations. See new attachment!
Attachments
aoo97042Ranking_2_WithExplanations.ods
(24.07 KiB) Downloaded 8 times
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2414
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Calc

Who is online

Users browsing this forum: bhcmtr, Google [Bot], RPG and 14 guests