Content deleted Content added

Inline

Revision as of 14:20, 3 December 2023

Welcome to the computing section
of the Wikipedia reference desk.

skip to bottom

Select a section:

Shortcut

WP:RD/C

Want a faster answer?

Main page: Help searching Wikipedia

How can I get my question answered?

Select the section of the desk that best fits the general topic of your question (see the navigation column to the right).
Post your question to only one section, providing a short header that gives the topic of your question.
Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
Don't post personal contact information – it will be removed. Any answers will be provided here.
Please be as specific as possible, and include all relevant context – the usefulness of answers may depend on the context.
Note:
- We don't answer (and may remove) questions that require medical diagnosis or legal advice.
- We don't answer requests for opinions, predictions or debate.
- We don't do your homework for you, though we'll help you past the stuck point.
- We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.

Ready? Ask a new question!

How do I answer a question?

Main page: Wikipedia:Reference desk/Guidelines

The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.

November 26

Excel Question

Assume we have two columns 'ID' and 'Score' in an Excel spreadsheet, both entered as numbers. There can be multiple entries of the same ID in the ID column, each with an associated score, so ID 4 might appear 50 times. What is the easiest way in Excel to sum all the scores for a particular ID? 2.100.107.194 (talk) 12:37, 26 November 2023 (UTC)[reply]

There are multiple ways of doing this, but for me the easiest is to select the whole table, click the Data tab and then the Filter icon. You should see small arrows on the column headings. Click the arrow to select the value of ID you want. Then go to the cell below the Score entries (or, more clearly, leave one cell gap between the scores and the selected cell) and go to the Home tab. Click the autosum icon. Done. You can repeat this with different ID values selected. Phil Holmes (talk) 13:13, 26 November 2023 (UTC)[reply]

Thank you. I've got rather a lot of IDs and would ideally like to automate this process. Is it possible for me to generate a distinct list of IDs from the first table, enter this list into a separate second table (so all IDs are present in the second table precisely once) and then do some sort of 'sum if' where for each unique ID in the second table Excel searches the first table for all references to it, sums the corresponding scores, and then places this summed value against the given ID in the second table? 2.100.107.194 (talk) 14:42, 26 November 2023 (UTC)[reply]

That is called a pivot table. Don't try to reinvent a pivot table. Just highlight the data and insert a pivot table. 97.82.165.112 (talk) 20:13, 26 November 2023 (UTC)[reply]

I would select the table, then go to insert-pivot table. In the pivot table dialog, select scores with the function "sum". Done. It will make a new table that has each ID with the associated total score. 97.82.165.112 (talk) 14:37, 26 November 2023 (UTC)[reply]

You can use the SUMIF() function for this. For example, if the IDs are in cells A1 to A100 and the scores in B1 to B100 then the sum of scores with ID=1 would be =SUMIF($A$1:$A$100,1,$B$1:$B$100) (the second parameter could be replaced by a cell reference or other formula). But the pivot table is probably better for the summary list that you want. AndrewWTaylor (talk) 12:04, 29 November 2023 (UTC)[reply]

November 27

Text in SVG file not appearing

I tried to make an SVG version of File:Jade gisements.jpg, it works when the file is opened as a page but the text did not show up in Media Viewer, I tried converting the text into paths but that did not work either. How can I fix this? Svenurban (talk) 05:19, 27 November 2023 (UTC)[reply]

When I open https://commons.wikimedia.org/wiki/File:Jade_gisements.svg#/media/File:Jade_gisements.svg, the text shows up just fine (in Chrome, Firefox and Safari on macOS). --Lambiam 12:33, 27 November 2023 (UTC)[reply]

Sorry, that does not apply to the in-image country name labels 'Canada (n)', 'Guatemala (j)', 'Russie (j, n)', etc. But these do also not show up for me on the page File:Jade gisements.svg. Can you convert first to png and then to SVG? --Lambiam 12:47, 27 November 2023 (UTC)[reply]

The original picture file is File:Jade gisements.jpg. Svenurban (talk) 13:11, 28 November 2023 (UTC)[reply]

When I look at it on Firefox on Windows, the text is white, and when it is on a white background does not show up. Even over the grey sea, it is very hard to read. Graeme Bartlett (talk) 20:56, 27 November 2023 (UTC)[reply]

I suggest telling it to save as a "Plain SVG" instead of an "Inkscape SVG" file. Many of the tags and attributes in the file are clearly Inkscape-only. It is a possibiliity that one or more of them are causing errors on non-Inkscape image viewers. 12.116.29.106 (talk) 15:44, 28 November 2023 (UTC)[reply]

November 28

Any image hosted on wikimedia.org gives an SSL error

Since yesterday I'm having trouble with anything related to the https://upload.wikimedia.org/ URLs, they all give an ERR_CERT_COMMON_NAME_INVALID error.

I tried some troubleshooting and I noticed that SSL Checker detects no errors ( https://www.sslshopper.com/ssl-checker.html#hostname=https://upload.wikimedia.org/ ) and even trying visiting the URLs with a proxy website like https://www.proxysite.com/ works.

I noticed that the certificate I get on my side looks suspicious to say the least ( https://i.stack.imgur.com/lKu8m.png )

This happens with every browser and even within the Windows 11 Sandbox Mode.

Could this be malware related? Please note that this is the only site I'm having trouble with, Wikipedia works fine, except all the images not showing being hosted on wikimedia.org Bimbo1989 (talk) 17:58, 28 November 2023 (UTC)[reply]

Bimbo1989 Since it seems like no one else is having this problem, it must be your computer. Check on another computer or smartphone to see if the problem is there too and check on your computer to see if an update is available. Killarnee (talk) 19:20, 2 December 2023 (UTC)[reply]

November 29

Liking your shared posting on Facebook

Many consider it a no-go to self-like your own postings on Facebook (and I agree with that). But what about liking your postings shared by someone else? There are much less opinions about this. I think it shows gratefulness and respect to the sharing person and is generally a good idea. Or does it resemble a self-like too much? --KnightMove (talk) 08:57, 29 November 2023 (UTC)[reply]

Welcome to the reference desk where volunteers try to answer factual questions. In response to your question there are different opinions so, and as stated at the top of this page, we can't answer requests for opinions. Just do what you feel is appropriate. Shantavira|^{feed me} 10:05, 29 November 2023 (UTC)[reply]

I think the questioner wants to avoid to appear acting inappropriately. While there will be different opinions concerning this issue, there are also different opinions as to whether the shape of the Earth is (approximately) spherical. There might exist objective evidence that one specific opinion is predominant. --Lambiam 22:08, 29 November 2023 (UTC)[reply]

Depending on the social media platform, when you like or thumbs up someone else's post, it shows up in your feed for others to see. So, if someone shares your post and you like it, people viewing your feed will see that you liked it. This has two benefits. The person sharing your post will get a like, which promotes the entry. People viewing your feed will see that others are sharing your posts, making it more likely others will share your posts. For many, the point of social media is build a hefty quantity of followers. So, this is a good way to do so. You may find it embarassing to follow a lot of people, share posts from others, and thumbs up all your own stuff. But, that is how it works. It is all about self-promotion. 97.82.165.112 (talk) 14:46, 30 November 2023 (UTC)[reply]

December 3

Windows 11 vs. Windows 10

I've got a strange problem. Until about a week ago I had as my working computer HP Pavilion with Windows 10. Over time it seems to have become much longer to boot. I began thinking perhaps one of the four processors died out. So, I bought a much faster Dell machine., It came with Windows 11. I cannot find a way to shut it off through software. In Windows 10, in the lower left corner, exists a small pop up. I can invoke it, find a proper button and a choice of shutting off will appear: Restart, Shut down and Sleep. It is a very convenient arrangement. Where is a similar option in Windows 11? Did they forgot to implement it? Now I do everything hard way, by pressing a hidden button on the left of the computer frame. Will appreciate guidance. Thank you, AboutFace 22 (talk) 14:20, 3 December 2023 (UTC)[reply]

@@ Line 66: / Line 66: @@
 = December 3 =
+== Windows 11 vs. Windows 10 ==
+I've got a strange problem. Until about a week ago I had as my working computer HP Pavilion with Windows 10. Over time it seems to have become much longer to boot. I began thinking perhaps one of the four processors died out. So, I bought a much faster Dell machine., It came with Windows 11. I cannot find a way to shut it off through software. In Windows 10, in the lower left corner, exists a small pop up. I can invoke it, find a proper button and a choice of shutting off will appear: Restart, Shut down and Sleep. It is a very convenient arrangement. Where is a similar option in Windows 11? Did they forgot to implement it? Now I do everything hard way, by pressing a hidden button on the left of the computer frame. Will appreciate guidance. Thank you, [[User:AboutFace 22|AboutFace 22]] ([[User talk:AboutFace 22|talk]]) 14:20, 3 December 2023 (UTC)