On 2019-12-20T21:59:12, Sage Weil <sage@newdream.net> wrote:
I added a red column that is supposed to add up the scores, but I can't figure out why =sum(...) isn't working. But maybe we don't need that yet until we have the scores in.
The fields were formatted as "plain text" and thus SUM took all their values as 0. I've changed that to "number" now and converted the 3/4 and other comments (which then show up as 384765 and other funny values) to things like 3.5 etc. On the pivot sheet you can also see how many talks we currently have at a given total score, and how many talks we'd end up with in the program if we picked a given threshold score (barring any other considerations). -- Architect SDS, Distinguished Engineer SUSE Software Solutions Germany GmbH, MD: Felix Imendörffer, HRB 36809 (AG Nürnberg) "Architects should open possibilities and not determine everything." (Ueli Zbinden)