Wikipedia:Reference desk/Archives/Computing/2019 March 20

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

March 20

International Face Recognition Challenge

Hello,I am an Intelligent algorithmic engineer.Now,I want to participate in an international face recognition challenge,but when I search for information about it,there are some difficulties，such as some challenges had ended,or no longer be organized since several years ago.SO,who can offer me more information about international face recognition challenge which will be holding in 2019? Thank you very much. — Preceding unsigned comment added by Wenhuizhang321 (talk • contribs) 01:40, 20 March 2019 (UTC)

First hit of https://duckduckgo.com/?q=+international+face+recognition+challenge looks promising to me. You might also try some Kaggle competitions (kaggle.com). 173.228.123.166 (talk) 11:50, 20 March 2019 (UTC)

Excel pivot table - conditional formatting each row separately

I've got a pivot table that I have conditional formatting on. Each row is a day and each column is an product group. I've properly applied conditional formatting to the pivot so that new data gets including in the formatting, etc. but what I want is for each day's values to be considered separately. For example, let's pretend this wikitable is my pivot:

Day	Bags	Boxes	Cartons
Jan 1	12	4	6
Jan 2	3	7	0
Jan 3	5	17	4

And let's say that I've got conditional formatting to highlight the top value. In this case, the 17 boxes on Jan 3 would be highlighted (and will remain so unless some subsequent date has a value greater than that). Fine, but what I'd like is to have each day's largest value highlighted. So, the Jan 1 bags, the Jan 2 boxes, and the Jan 3 boxes should all be highlighted. Can it be done? Googling has not helped, mostly because many people find applying any conditional formatting to pivot tables confusing so all the sources I've clicked on are regarding getting to the state I'm already at. Matt Deres (talk) 14:29, 20 March 2019 (UTC)

I think the row-by-row conditional formatting you want is not available in the Excel GUI but may be achieved if you are willing to edit the Excel file. Referring to (page numbers) in the OpenOffice documentation, at offset 72 in Font Formatting Block (p.142) expect 0190_H for normal text and 02BC_H for bold text. This is inside a CFRULE - Conditional Formatting Rule (p.140). The CFRULE follows a CFHEADER record (p.139) that specifies to which cells the rule applies. Starting at offset 4 in the CFHEADER is the cell range address that you may modify. Cell Range Address (p.26) and Cell Range Address List (p.27) are explained on the given pages. I have not tested this and see that the CFHEADER may limit you to maximum 3 CFRULE records, which may be only enough for your 3-row example. DroneB (talk) 15:12, 26 March 2019 (UTC)

Looking for a flexible LED ticker

I'm looking for a LED ticker, around 60cm wide. But all I find is heavy and thick and looks like 20 year old. There are many flexible LED stripes, so why isn't it possible to make a flexible and thin LED ticker? --85.212.150.218 (talk) 20:24, 20 March 2019 (UTC)

Make one. Multiple strips of NEOPixel / WS2812 LEDs, daisy-chained.

Designing the power supply and the connectors is non-trivial - remember decoupling capacitors on each strip, and resistors to limit the current on the data line. Andy Dingley (talk) 12:43, 21 March 2019 (UTC)