ImportRange in Google Spreadsheets returns error despite

I’ve a formula with approximately 40 ImportRanges that fetches data from other tables. That formula is repeated 1166 times.

The problem is that the ImportRange stops fetching data somewhere in the middle.

It could’ve been the ImportRange limit, but the whole thing already worked in the existing spritesheet. When I moved all sheets with that formula to other table it stopped working.

c – fopen in binary mode returns null to existintg file

I have a binary file (”’simdisk.bin”’). I opened it in ‘r’ mode and i’ve no problems to read it. Now, i want to open it in binary mode (rb+) to write and read in binary, but i get a nill pointer.

I made a test.c file to try it with this main:

int main(int argc, char const *argv())
 fp = fopen("simdisk.bin", "rb+");
 printf("Ptr: %pn", fp);

Lightning LND gRPC send direct payment returns invalid_key_length error

I’m trying to send a direct payment on testnet from my node A to my node B. Both have only channels with public nodes, not between themselves, so that a route contains multiple hops.

I followed the Bidirectional-streaming RPC example from

//var dest_pubkey = <RECEIVER_ID_PUBKEY>;
var dest_pubkey = '033d4933c29885ab84cc5eacbcf3cd3bc87d3c36b36e81d9b09a0691946dfa3493';

var dest_pubkey_bytes = ByteBuffer.fromHex(dest_pubkey);

var call = lightning.sendPayment();
call.on('data', function(payment) {
  console.log("Payment sent:");

call.write({ dest: dest_pubkey_bytes, amt: 11 });

I get the response

Payment sent:
  payment_error: 'invalid key length',
  payment_preimage: <Buffer >,
  payment_route: null,
  payment_hash: <Buffer 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00>

from which I get the impression that I am providing the wrong pub key. Is my nodes’ public identifier the pubkey which can be obtained by the identity_pubkey property from getinfo command?

When I use a Buffer instead of ByteBuffer:

var dest_pubkey_bytes = Buffer.from(dest_pubkey, 'hex');

instead of

var dest_pubkey_bytes = ByteBuffer.fromHex(dest_pubkey);

I don’t get the invalid_key_length error but an incorrect_payment_details error:

Payment sent:
  payment_error: 'incorrect_payment_details',
  payment_preimage: <Buffer >,
  payment_route: null,
  payment_hash: <Buffer 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00>

from which I get the impression that I need provide other data in the request besides dest and amt. Do I need to add something more to the request? e.g. a keysend flag or something similar to lncli sendpayment —keysend

sending direct payment via cli works:

tlncli2 sendpayment --keysend --dest 033d4933c29885ab84cc5eacbcf3cd3bc87d3c36b36e81d9b09a0691946dfa3493 --amt 11


Amount + fee:   11 + 2.001 sat
Payment hash:   644beaa4aafbaa2c1c4bace2735c038446bfdaae6942e4900f511f1a0fbec1b1
Payment status: SUCCEEDED, preimage: 92a304c1c5b47afe887faf3e0e137d618c014a9d27edd6897b49411121c5d2e9

My nodes have version

lnd version 0.10.0-beta commit=v0.10.0-beta

mathematical optimization – NMinimize returns “Function is not a number at …”

I am currently trying to minimize MSE between two sets of data, using NMinimize. One of the question threads here offered a solution to use Method -> "RandomSearch to potentially avoid local minimum trap, and setting MaxIterations allows me to save some time, even tho this code runs for almost 4 hours.

Below is my running code,

 NMinimize({(Sum((Re(GenericFunction(ptstry((i)), r, s)) - nums((i, 2)))^2,
      {i, 1, Length(nums)}))/Length(nums),
   rUpper >= r >= rLower, sUpper >= s >= sLower}, {r, s},
  Method -> "RandomSearch",
  MaxIterations -> 10^2)

and the return is below,

NMinimize::nnum: The function value 1/304 (2558.86 +(-1.10968+Re({0,1,2,3,4}.Re(PDF(<<2>>))/(1+Times(<<2>>))))^2+(-1.13174+Re({0,1,2,3,4}.Re(PDF(<<2>>))/(1+Times(<<2>>))))^2+(-1.05333+Re({0,1,2,3,4}.Re(PDF(<<2>>))/(1+Times(<<2>>))))^2+(-1.08594+Re({0,1,2,3,4}.Re(PDF(<<2>>))/(1+Times(<<2>>))))^2+(-1.06962+Re({0,1,2,3,4}.Re(PDF(<<2>>))/(1+Times(<<2>>))))^2) is not a number at {r,s} = {9.91862,8.48582}.

I have checked couple of questions on mathematica stack exchange but none of the solutions/tips helped me with my problem.

I was wondering if either my code is wrong somewhere, or the function GenericFunction is causing me problems. GenericFunction is calculated using the stationary distribution of a DiscreteMarkovProcess. I can provide more details on the GenericFunction if needed.

PS: I had to change some of the names in the code, so if there is a nameing mismatch do not mind that.

sharepoint server – Using DATEIF only if another column returns 2 out of the 3 column entries

I’m attempting to calculate the difference in dates (the current date & Date Opened column) only if the Status? Column reads Open or Hold.
I’ve tried:

=IF(Status?,"Open" OR "Hold",(DATEDIF((Date Opened),NOW(),"D")))


=IF(Status?,"Open","Hold",(DATEDIF((Date Opened),NOW(),"D")))

But get a syntax error.

Help please!

mysql – Error Code: 1242. Subquery returns more than 1 row in Case statement

I have table called tblDailyCheckIn(DailyCheckInID, EmployeeID, WorkingDate, CheckIn, Checkout, WorkingHours, Comment, IsActive, CreatedBy, CreatedDate, ModifyBy, ModifyDate).

Here I want to select Distinct EmployeeID, Distinct CheckIn and workingHours if Some condition is meet. I tried following code?

Select Distinct EmployeeId , date(CheckIn), 
When EmployeeId = 1001 and WorkingDate = '2020-05-03'

Then   (Select WorkingHours from tbldailycheckin)
from tblDailycheckIn;  

Here CheckIn is timestamp and I only need date so use date() function .But I m getting an error “Error Code: 1242. Subquery returns more than 1 row. “. How to solve this.

Transparent checkout API (PagSeguro) – JavaScript function that should return an object only returns "undefined" under IOS

I have a Cordova app that implements PagSeguro's transparent checkout API. I get all API responses on Android, but the function in the IOS app PagSeguroDirectPayment.onSenderHashReady() That should return an object, return "undefined". This only happens for this particular function because the others of the same API work fine.

My code:

function directPayment(resultId, cb) {


       if(response.status == 'error') {
           return false;
       var hashUser = response.senderHash;
       createCard(hashUser, cb);


I refer to the API with:

I use:

  • Xcode 11.4.1
  • Cordova ios 5.1.1

Google Sheets – How can I get my WordPress site to run a Python script in the background that receives and returns data?

So basically I want users to enter a company name after accessing my WordPress site, which is then assigned to a Python script that accesses another site's API and then calculates some key financial statistics displayed on my WordPress site.

I'm concerned about what happens when multiple people access the site. Do I have to worry about client server problems because I'm quite a novice in this regard?

If it is absolutely not feasible with Python, could it work if I use PHP or maybe Google Sheets?

boot – Can not log in to elementray os, always returns to the password query

NOOB alarm
I have been using Elementary OS for a few months without any problems. I noticed a low file space alert a few days ago. So I increased my root partition from 12 GB to 26 GB, which apparently worked well.

I had a freeze this afternoon, so I restarted and since then everything I get is thrown back after a couple of black to gray screen flashes for password verification.

I booted from a USB stick and can see that the root partition is full, but I have no idea why or how to examine it.

Please help with detailed instructions on how to get the diagnostic information you need.
Latest basic operating systems with updates in the last 24 hours
1 TB SSD, 64 GB RAM Alienware PC