Wikipedia:Reference desk/Archives/Computing/2018 April 4

= April 4 =

digital textual analysis
You want to search the other similar instances or slightly modified versions of a given piece of text from digital text available online from various sources. Like a statute on proportional representation, where hundreds of statutes written all over the English speaking world has clauses which are very similar or exactly alike. The purpose could be that you want to remove some corruption some clause has acquired over years or through various statutes. Or it could be to see if some thing has been plagiarised from some source. It is not exactly non-linear reading. It is more than that. What do you call this process? --Skillguru (talk) 12:25, 4 April 2018 (UTC)
 * Some of the links in the article-section Plagiarism_detection, might bring you close to what you're looking for. Hope this helps. ApLundell (talk) 17:20, 4 April 2018 (UTC)
 * Also look at Semantic similarity and links thereof. --Hofhof (talk) 17:26, 4 April 2018 (UTC)
 * Fixed the link. I wish the Wiki software would automatically figure these out. ApLundell (talk) 20:01, 4 April 2018 (UTC)

Pivot tables in Excel
When you create a pivot table, there is an option you can check that will "Add this data to the Data Model" (it's unchecked by default). Among other things, if you check that box, the resulting pivot table can then perform "count unique" functions, at least as of 2013 and later versions. I have a situation I'm trying to resolve and I can think of two possible ways to address it, but neither seems to be working for me. I've got a functioning pivot table (made with that option un-checked) that I then grab data from using GETPIVOTDATA. I need to do the exact same thing, but to a pivot that includes a "count unique" column.
 * a) Is there a way to "update" an existing pivot table so that it acts as if the box was checked at creation? I can't seem to find a way and it's difficult to search on because it doesn't have a specific term for it.
 * b) If I forget about trying to update my pivot table and just make a new one with the box checked, the GETPIVOTDATA formulas I use no longer work; I just get #REF! error messages. I can re-target the formulas however I like, I can delete the old pivot tab first, I can rename stuff; it just doesn't seem to matter - I can't avoid that error message.

Any thoughts? I can't help feeling like there's something really obvious I'm doing wrong (I don't often use GETPIVOTDATA), but I'm stymied. Matt Deres (talk) 19:07, 4 April 2018 (UTC)


 * On the off chance that someone stumbles over this question, the answer can be found here. Whew! Matt Deres (talk) 19:07, 10 April 2018 (UTC)

What's included in phone data download charges?
I have a Samsung Galaxy S6 and my wife has an S5. The provider is Verizon. I'm unsure what is counted as part of the metered "data download." Does it make a difference whether I have WiFi on?

In other words, am I charged for everything that comes through the phone? What about phone calls themselves, and text? text with pictures? Does it cost more if no WiFi is available? Thanks for clarifying. --Halcatalyst (talk) 23:51, 4 April 2018 (UTC)


 * You are not charged for data that comes over wifi, only data that comes over your cellular service.
 * (Phone calls and texts are metered separately.)
 * So ... in general ... if you have Wifi enabled, and you're actually connected to wifi, then you're not using up your data plan.
 * However, there is one exception. Some phones have an option to use both services at once if you're downloading a large file, or if the phone detects that the wifi is too slow. On the S5 this option is called "Download Booster" and is found in the "More Networks" menu. It's off by default, and if you're concerned about data plan usage I would recommend keeping it off. ApLundell (talk) 00:01, 5 April 2018 (UTC)
 * (E/C) Providers are typically concerned with cellular data - the amount of material sent via their cellular network. Stuff you get via WiFi would not be counted against that because it comes via your home internet provider. Phone calls also would not count, but they are also usually metered in some way. For example, your plan might allow for 100 local minutes per month. However, Verizon pays folks to answer your questions and I would encourage you to contact them; there may be specific restrictions in your particular contract and the only one who would know that is them (well, and you). In particular, some providers attempt to bill customers for SMS messaging, while others do not. Matt Deres (talk) 00:02, 5 April 2018 (UTC)
 * In some cases, some data plan services like Facebook are specifically free or metered separately too. But that was probably a brightly advertised feature when you signed up, so you would probably know about it already.  Hayttom (talk) 18:09, 5 April 2018 (UTC)