## remain – SharePoint 2013 – Compare values ​​in the list to see if all column values ​​match – Dashboard

Check the syntax of your for loop. A parent is missing after "i ++".

And you probably want something like this:

``````var isYes = array.every (function (e) {return e == "Yes"})
``````

No loop needed.

In addition, you have incompatible quotation marks in the URL line:

``````var siteUrl = "https: xxx / _api / web / lists / GetByTitle (& # 39; listName & # 39;) / items? \$ select =" Title, Office, Human Resources, Accounting;
``````

should be something like:

``````var siteUrl = "https: xxx / _api / web / lists / GetByTitle (& # 39; listName & # 39;) / items? \$ select = Title, Office, Human Resources, Accounting";
``````

Are the four columns "Title, Office, Human Resources, Accounting" Yes / No columns? Your "data.d.results" does not select any particular data.

Another note: your REST statement returns all rows in the list. Is that what you wanted? You may need to add a filter to select a single line.

If you are testing a single line, the following solutions would work, assuming that Office, HR and Account are choice columns with Yes or No:

``````var isYes = data.d.results[0].Office == "Yes" ||
données.d.résultats[0].HR == "Yes" ||
données.d.résultats[0].Accountability == "Yes"
``````

## I want to get the values ​​of several URLs in Google Spreadsheet. IMPORTDATA does not work

Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10).
Each URL returns JSON like this:

``````{
"success": 1,
"goo_value": "80"
}
``````

I want to put `goo_value` in another cell of the same worksheet.

IMPORTDATA does not work: "Too many requests".

Is there a way to get these text values? A script or something?

## graphs – Visualization of data: Pie charts with very small values

#### Battery Exchange Network

The Stack Exchange network includes 176 question and answer communities, including Stack Overflow, the largest and most reliable online community on which developers can learn, share knowledge and build their careers.

Visit Stack Exchange

## select – Get the values ​​of the two lines before the selected line

I want to update a line based on the values ​​of two lines before the line, how can I do it?

Suppose my table looks like this

``````Amount of ID

1 1
2 3
7 5
``````

And I want to do that

``````UPDATE Amount of the SET table Amount = (Before Amount + Up Amount Before) / 2 WHERE ID = 7;
``````

The expected exit would be

``````    Amount of ID

1 1
2 3
7 2
``````

And if I do that, I do not know anything about the previous two lines, so no ID or anything is there a query to select the values ​​before the selected line?

## Binomial distribution – Critical values ​​/ Critical region: Statistics and mechanics Edexcel Year 1 AS: p.104 Ex.7B Q5.

I do not agree with the answer they give.

P (X = 0) = 0.0188 …> 0.01 = 1%. Let's go back to the definition of "critical region" and compare to the example of page 101/102 (which I will not publish here for the sake of brevity):

Now, it would be "surprising / unlikely" to get 0 success considering X ~ B (20.0.18). However, 1.88% is not "less than 1% (not) likely", and so if we performed these 20 tests and achieved 0 successes, it is certain that we would not reject the null hypothesis at the 1% significance level.

Am I right or is there a flaw in my reasoning?

## acefem – incremental values ​​AceGen from d.o.f

I have to use incremental values ​​of my degrees of freedom of rotation in my FE code. But I want these incremental rotations to be dependent on real rotations, which I use as degrees of freedom.

AceGen Offers `nd \$\$[i,"da", j]` as "increment value of the jth nodal d.o.f in the last iteration". But since I want the increment to depend on the rotations `{Phi_1, Phi_2}`, these are my degrees of freedom, I wrote this piece of code

``````d_Phi_1 = MapThread[#1-#2&{Phi_1Array[SMSReal[DakotaduNord[#1-#2&{Phi_1Array[SMSReal[nd[#1-#2&{Phi_1Array[SMSReal[DakotaduNord[#1-#2&{Phi_1Array[SMSReal[nd$$[#, "ht", 1]]&, 4]}]; d_Phi_2 = MapThread[#1-#2&{Phi_2Array[SMSReal[Nd[#1-#2&{Phi_2Array[SMSReal[Nd[#1-#2&{Phi_2Array[SMSReal[nd[#1-#2&{Phi_2Array[SMSReal[nd$$[#, "ht", 2]]&, 4]}];

SMSExport[Phi_1tableau[DakotaduNord[Phi_1Array[nd[Phi_1tableau[DakotaduNord[Phi_1Array[nd$$[#1, "ht", 1] &, 4]]; SMSExport[Phi_2tableau[Nd[Phi_2Array[Nd[Phi_2tableau[nd[Phi_2Array[nd$$[#1, "ht", 2] &, 4]];
``````

I think this should give absolutely the same values ​​as those offered by AceGen, but it turns out that this is sometimes not the case.

Is this an explanation for this or the cause of this elsewhere in my code?

## wp query – How to rearrange the publications according to the values ​​of the input fields added by WordPress "Advanced custom fields"

I want to sort publications in ascending order based on the value of the input field added in Advanced Custom Fields.

``````    & # 39; & # 39 ;, post
& # 39; post_status & # 39; => & Quot; publish & quot;
& # 39; category_name & # 39; => & # 39; events & # 39 ;,
& # 39; orderby & # 39; => & # 39; meta_value & # 39;;
& # 39; meta_key & # 39; => & # 39; event_date & # 39;
& # 39; order & # 39; => & # 39; ASC & # 39 ;,
& # 39; posts_per_page & # 39; => 10,
)
?>

have_posts ()) {
while (\$ query-> have_posts ()) {
\$ query-> the_post ();
echo & # 39;& # 39 ;. get_field (& # 39; event_date & # 39;). & # 39; & # 39; get_field (& # 39; event_start_time & # 39;). & # 39; & # 39 ;. ~ get_field (& # 39; event_end_time & # 39;). & # 39;& # 39 ;;
}
wp_reset_postdata ();
}
?>
``````

Outcome
The start time and the end time are not changed even if they are sorted according to the date of the event.

``````20190718 1800 ~ 1900
20190718 1900 ~ 2100
20190718 1000 ~ 1500
20190718 1715 ~ 1815
20190718 0900 ~ 1030
20190718 1400 ~ 1600
20190718 0900 ~ 1000
20190719 1900 ~ 2300
20190719 2000 ~ 2200
20190719 0900 ~ 1600
``````

ideal result

``````    20190718 0900 ~ 1000
20190718 0900 ~ 1030
20190718 1000 ~ 1300
20190718 1000 ~ 1500
20190718 1400 ~ 1600
20190718 1700 ~ 1800
20190718 1715 ~ 1815
20190718 1800 ~ 1900
20190718 1900 ~ 2100
20190719 0900 ~ 1600
20190719 1900 ~ 2300
20190719 2000 ~ 2200
``````

## python – Empty image after normalizing RGB pixel values ​​by dividing them by 255

I'm trying to turn a 3D image into 2D. To do this, I normalized the pixel values ​​by dividing them by 255 in order to keep the values ​​in a range from 0 to 1. However, I find that my image becomes completely dark.

``````from skimage.color import rgb2gray
import numpy as np
import cv2
#% matplotlib inline
& # 39; exec (% matplotlib inline) & # 39;
import matplotlib.pyplot as a plt
from scipy import ndimage
from import data skimage

# read the image and print RGB pixel values
pic = plt.imread (# 1.jpeg) / 255 # dividing by 255 to bring the pixel values ​​between 0 and 1
print (pic.shape)
plt.imshow (pic)
plt.show ()
``````

## matrix – Creates a table from an index / values ​​list

Is there a powerful way to convert something like

{{0,0}, a}, {{0,1}, c}, {{1,0}, d}, {{1,1}, e}

in

{{a B c d}}

The indices are not always ordered and the only solution I can think of is to look for the maximum indices, to create a matrix filled with 0 and then to use map to modify the matrix.
Is there a better way?

Thank you,
Martin

## design – Should setters only set values?

I always like to think too much about things, so here is my thought of the day:

Should setters only set class property values ​​and not make any other logic?

Suppose I have a class

``````User class {
private:
int age;
bool is_alive;
public:
int GetAge ();
void SetAge ();
boolerate GetIsAlive ();
empty SetIsAlive ();
};
``````

Calling `User :: SetAge (5)`, we could assume that `user.age == 5`. But what about `User :: GetIsAlive ()`? Should setting the age of the user also run internal logic `is alive` property, or should it belong to the user of the class?

Should he just do exactly what the function says?

``````void User :: SetAge (int age) {
this-> age = age;
}
``````

``````void User :: SetAge (int age) {
this-> age = age;
this-> is_alive = (age <100);
}
``````

Should this be more explicit?

``````void User :: DetermineIsAlive () {
this-> is_alive = (age <100);
}
``````

Obviously, this is a simple case, but in my real examples, I do something like setting the activated state of a class (`Device.SetState (false)`) can then stop subcomponents, update status, and so on.

I'm just curious if we think that setters should ONLY set values ​​or properties, and multi-instructional functions should be more explicit in their naming.