A user has a problem with Excel 2016 (0365): Excel closes randomly without error

Troubleshooting steps:

  • If the user started getting this problem, the user is on Windows 7
  • Re-imaged The device on Windows 10
  • Installed the latest Office 2016 x86 issue
  • Tried x64-bit problem
  • User-prompted problem to use Excel safe mode
  • Exactly on different devices tried Excel closes it even without warnings or errors
  • Tried to check event logs. No critical or warning information about event logs
  • Even if the user opens the Excel and locks the PC, Excel will stop after some time

    • device specifications
    • Standard HP 840 G3

macos – My iTunes media files are sometimes deleted randomly

My iTunes library is on an external hard drive.

When I try to play an old saved podcast episode, I occasionally get the following warning message:

Notifications panel

This means that the file was mysteriously deleted (or moved) from its original location without the knowledge of iTunes (if iTunes had deliberately deleted it, it would no longer be listed in my library). If I check the location in the Finder, I can determine that the file is missing. This podcast episode is Rescued and I've set options in podcast settings to prevent iTunes from deleting old episodes.

Why is this happening? I always eject my external hard drive safely, and sometimes I check the hard drive for errors, but it's always OK.

I've noticed this problem in the last three to four years using different external hard drives, keeping my computer and iTunes up to date, and the problem persists. It can even happen sometimes on normal (non-podcast) songs.

I also sync some tracks to / from my iPhone.

Is iTunes synonymous unreliable for others?

9.0 pie – Samsung Galaxy S9 + stops music randomly when the screen is off

Android Version: Pie (last update)

Phone age: approx. 1 year (warranty expired in June 2019)

Since the update a month ago, my phone has randomly paused Spotify and other apps when the screen is off, regardless of the battery level or power save settings. I checked it and the apps are allowed to run as background processes. It only seems to affect apps that play sounds.

It's so annoying because I do not see any patterns. I noticed that this is prevented by a restart of the phone, and I have set it so that it is restarted every morning. This worked for a while, but now the problem came back.

Right after this update, something else happened. I turned off my phone and the next morning refused to turn on. Booting to recovery mode took a while to activate.

Do you have any idea what to do about it? Ideally, I do not want to reset my phone.

Probability – Two machines produce 30%, 70% materials with 3%, 5% faulty units, probably a randomly selected material is faulty

If I have no idea how to start. Two machines A, B produce 30.70% material for one company respectively 3%, 5% defective units.
a] What is the probability that a material of the entire output is faulty?
b] Probability that the defective material was produced by machine A.
c] Probability that this faulty material was produced by Machine B.

javascript – Google Script Retrieve URL data and randomly missing data values ​​during an iteration

I draw vehicle dimensions from a generated URL column in Google Sheets. Here's an example of a leaf I work with:


I have a function that gets all the values ​​in the "Generated URL" column. For each URL value, we retrieve the HTML code from the site and override these values:

  • Rear main room
  • Rear shoulder room
  • Loading capacity, all seats available
  • Max. Freight capacity

After running the full code, the returned vehicle dimension values ​​are never static. Sometimes the values ​​are pushed correctly to the Google Sheet, but sometimes I get my value "no data".

I used an if / else loop with isNaN to check if the value is a number before sliding it on the sheet. The else sets the value equal to "no data", which sometimes is set even if the connection contains correct data.

function getData(url, i, skip) {

  var temp = i;
  var tempurl = url;
  var options = {
    method : "GET",
    muteHttpExceptions : true

  var response = UrlFetchApp.fetch(url, options);
  var content = response.getContentText();

  var start1 = 'Rear head room';
  var end1 = 'in.';
  var start2 = 'Rear shoulder room';
  var end2 = 'in.';
  var start3 = 'Cargo capacity, all seats in place';
  var end3 = 'cu.ft.';
  var start4 = 'Maximum cargo capacity';
  var end4 = 'cu.ft.';

  //var dataa;
  var cut1 = content.indexOf(start1);
  var cut2 = content.indexOf(start2);
  var cut3 = content.indexOf(start3);
  var cut4 = content.indexOf(start4);

  var finish1 = content.indexOf(end1, cut1);
  var finish2 = content.indexOf(end2, cut2);
  var finish3 = content.indexOf(end3, cut3);
  var finish4 = content.indexOf(end4, cut4);

  var data1 = content.substring(cut1, finish1);
  var data2 = content.substring(cut2, finish2);
  var data3 = content.substring(cut3, finish3);
  var data4 = content.substring(cut4, finish4);

  var value1 = data1.substring(62, 66);
  var value2 = data2.substring(66, 70);
  var value3 = data3.substring(82, 86);
  var value4 = data4.substring(70, 75);

  var comp1 = isNaN(value1);
  var comp2 = isNaN(value2);
  var comp3 = isNaN(value3);
  var comp4 = isNaN(value4);

  var comp = new Array;

  var checktest1 = 'n" c';
  var checktest2 = 'lass';
  var checktest3 = '   2) {
    var x = 0;
    while (x <= 3) {
      if (comp(x) == true) {
        switch(x) {
          case 0:
            value1 = "No Data";
          case 1:
            value2 = "No Data";
          case 2:
            value3 = "No Data";
          case 3:
            value4 = "No Data";
      else {
    setData(value1, value2, value3, value4, temp);
  else if (value1 === checktest1 || value2 === checktest2 || value3 === checktest3 || value4 === checktest4) {
    var dataa = content;
    delete content;
    getData(tempurl, temp, skip); 

  else {
    setData(value1, value2, value3, value4, temp);


function setData(value1, value2, value3, value4, temp) {

  var index = temp - 2;
  var x = 0;
  var ss1 = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss1.getActiveSheet();
  var cell = sheet.getRange(2, 10);

  var cell1 = value1;
  var cell2 = value2;
  var cell3 = value3;
  var cell4 = value4;

  var isEmp = new Array;
  var coltest = '="">';

  while (x <= 3) {   
    if (isEmp(x) === '' || isEmp(x) === coltest) {
      switch(x) {
        case 0:
          value1 = "No Data";
        case 1:
          value2 = "No Data";
        case 2:
          value3 = "No Data";
        case 3:
          value4 = "No Data";
    else {


  cell.offset(index, 0).setValue(cell1);
  cell.offset(index, 1).setValue(cell2);
  cell.offset(index, 2).setValue(cell3);
  cell.offset(index, 3).setValue(cell4);


Of the 148 iterations, my program does not get random 20-25 lines of data. The random false lines are never the same, but contain the correct values, but were overlooked randomly.

MacBook Pro hangs randomly after water damage

I have a water damage on the trackpad. After that, the mouse cursor started to tremble randomly. I turned off the Macbook and washed it with isopropyl alcohol. After that, the MacBook hangs randomly. It hangs when booting, after logging in or after some time of work. How can I tell which hardware part is defective? I think, check it by the order of the deactivated Kexte in the normal mode.
In safe mode, the MacBook works without hanging.
I decide to compare texts that only start in normal mode.
This is a list of these relationships.

 com.apple.driver.AppleFIVRDriver (4.1.0)  
 com.apple.driver.AppleSMCLMU (211)  
 com.apple.vecLib.kext (1.2.0)  
 com.apple.iokit.IOAudioFamily (206.5)  
 com.apple.iokit.IOHDAFamily (281.52)  
 com.apple.driver.AppleHDAController (281.52)  
 com.apple.iokit.IOSlowAdaptiveClockingFamily (1.0.0)  
 com.apple.driver.AppleIntelSlowAdaptiveClocking (4.0.0)  
 com.apple.driver.AppleOSXWatchdog (1)  
 com.apple.driver.AppleHV (1)  
 com.apple.driver.AppleSSE (1.0)  
 com.apple.plugin.IOgPTPPlugin (680.15)  
 com.apple.iokit.IOAVBFamily (683.1)  
 com.apple.iokit.IOSerialFamily (11)  
 com.apple.iokit.IOBluetoothSerialManager (6.0.7f15)  
 com.apple.iokit.IOUserEthernet (1.0.1)  
 com.apple.driver.pmtelemetry (1)  
 com.apple.AGDCPluginDisplayMetrics (3.20.16)  
 com.apple.GeForceTesla (10.0.4)  
 com.apple.driver.AppleUpstreamUserClient (3.6.5)  
 com.apple.driver.AppleMikeyDriver (281.52)  
 com.apple.kext.OSvKernDSPLib (526)  
 com.apple.driver.DspFuncLib (281.52)  
 com.apple.driver.AppleHDA (281.52)  
 com.apple.driver.AppleHDAHardwareConfigDriver (281.52)  
 com.apple.driver.AppleMikeyHIDDriver (131)  
 com.apple.driver.AppleTyMCEDriver (1.0.3d2)  
 com.apple.driver.AudioAUUC (1.70)  

I tried to start Apple Hardware Test, but it did not work.

macos monitor displays do not display a picture in the display settings and turn black randomly

This is my first question, please excuse my mistakes.
I'm using a Mid 2017 MacBook Pro with an HP V270 monitor. The monitor can be easily connected via a USB-C to HDMI cable, but the problem I currently have is that my monitor will go out randomly and turn on again after a few seconds. It seems to be a connection issue, but I'm not sure how to check it. A special feature that I noticed in the settings is that no image is displayed on the monitor display settings However, an image is displayed on my MacBook screen. Please do not confuse the image I am referring to with the one on the hardware screen. The hardware screen will show a picture, but will go out randomly. The screen in the picture above will remain black no matter how I changed the settings next to it. Also, I'm currently working on the beta version of Catalina, but I do not think it's a beta version because the same problems have occurred with other users.

Combinatorics – The proof of a randomly generated function is positively distorted

Mathematically, I have $ r_n = p ^ {a + n} q ^ {n} ({a + 2n choose a + n} – {a + 2n choose a + n + 1}) $ for an integer $ a $ and probability $ p in (0,1) $ (as usual $ q = 1-p $). We have to prove that $ r_n $ is positively distorted.

Background: I am trying to prove that drift diffusion (a cognitive model for decision making) produces a response time distribution that is positively skewed. If you are interested in how it all works; $ {a + 2n choose a + n} – {a + 2n choose a + n + 1} $ indicates how many random walks (representing noisy sample sequences of neurons) are of length $ a + 2n $ that reach a threshold $ 2n + a $ Steps are exactly there (think of it as a balanced bracket problem).

A simple Excel spreadsheet shows that the distribution for different values ​​is indeed positively skewed $ p $ but I can not calculate the mean or standard deviation to get the Pearson coefficient. Any help is greatly appreciated.

How do I prevent Windows 10 from randomly executing "Shutdown, Collect Information and Restart"?

Windows 10 randomly gives me a BSOD stating that it has encountered a problem and is gathering some information and restarting my PC for me. It also means that it was due to "Critical System Corruption".
However, there is no real problem or system corruption.
I know that because I executed the chkdsk / f command before and after these random shutdowns, ALSO by holding down the power button, turning off my PC and then running CHKDSK / F manually. At no time have I ever encountered problems. (except for those annoying random shutdowns by the operating system).
I have lost data that I have worked on so many times that I now only use Windows 10 to play and still lose game progress when that shutdown occurs.
I spent weeks trying everything I could find on the internet and sometimes fixing it up for others.
I've been to Microsoft Support MANY times, even up to Tier 3. The problem persists.
Microsoft Support will close my questions or drop them BEFORE I ever get an answer, in 98% of the cases. I also had callbacks that I never recalled. I will not tell you how many times I accidentally "disconnected" (hung up).

I start to believe that these shutdowns are just for MS to try to steal my data and have no other real purpose.

Any help or advice is greatly appreciated.
Thank you very much for all the help offered and also for those who have just read this.