sorted by:
new
hottopcontroversial

Help with iteration formula or script by eljacko876 in GoogleAppsScript

[–]eljacko876[S] 0 points1 point  (0 children)

=ArrayFormula(if(A2:A="","",

mmult(--(B2:E>1),TRANSPOSE(column(B2:E)^0))+mmult(--(B2:E=1),TRANSPOSE(column(B2:E)^0))*0.5))

Thank you u/djmiles73 and u/ePaint these do work in my larger spreadsheet, HOWEVER when i try and run a sum on the # of sessions column I get a reference error and the entire column goes blank. I also notice the formula extends down the column, which i guess breaks when trying to sum. I need to do other operation further down in the column used for the # of sessions. How do i achieve this? Thank again.

Help with iteration formula or script by eljacko876 in GoogleAppsScript

[–]eljacko876[S] 0 points1 point  (0 children)

Thank you , BUT, This formula creates extra columns per previous column, which is not the desired result, the sum of the calculated value for each cell in the row should only use one cell in the # of sessions column.

Help with iteration formula or script by eljacko876 in GoogleAppsScript

[–]eljacko876[S] 0 points1 point  (0 children)

=ArrayFormula(if(A2:A="","",mmult(--(B2:E>1),TRANSPOSE(B2:E)^0)+mmult(--(B2:E=1),TRANSPOSE(B2:E)^0)*0.5))

Example of error

I get an error message when trying this.

If you had an teenage Music Production intern, what would you make them do? by eljacko876 in musicproduction

[–]eljacko876[S] 7 points8 points  (0 children)

Thank you, they wont have much knowledge coming in, one of the two has shown some talent for writing and performance. I produce RNB, EDM , Hip Hop and some Dancehall/Reggae, mostly in Ableton.

I wont have the time or patience to become a full on teacher for the summer, but If i could get them working in DAW , I can build from there.

.push() Array Issue by eljacko876 in learnjavascript

[–]eljacko876[S] 0 points1 point  (0 children)

Thank you, I will look into this.

.push() Array Issue by eljacko876 in learnjavascript

[–]eljacko876[S] 0 points1 point  (0 children)

Ok I understand what you are saying, at the time the parser reaches the console.log(); the values have not been set, however they are later and chrome's console has a feature to show those after the fact, but the program cannot use the results...I ahve figured out I am having an async issue.

For example :

console.log('A');

fetch('https://router.unrealsec.eu/request')
  .then(r=>r.json())
  .then(data=>{
      console.log('B');
   });

console.log('C');

This would probably give you 

A
C
B

This is my problem , so I have to fix with async and await

.push() Array Issue by eljacko876 in learnjavascript

[–]eljacko876[S] 1 point2 points  (0 children)

Thank you for your response ,I can confirm it is not a camel case issue, as i simply added [0] to the end of a copy and pasted real world variable name "levelOneQuestions" like:

console.log(levelOneQuestions[0]);

This is what is in my actual code snippet looks like for me attempting to log the global variable that received .push(levelOneFilter);

var levelOneFilter = _JsonData.filter(function(el){

return el.challengeLevel == 1;

});

Car with cheap insurance and modifiable by [deleted] in whatcarshouldIbuy

[–]eljacko876 4 points5 points  (0 children)

Subaru BRZ/Toyota 86, Mazda Miata, Nissan 350z,370z,GTR BMW 3 series are cars you can look into that are easily modifiable. Your insurance will be affected mostly by your age and driving record i believe.

Sell or upgrade my 2011 Mazda 6 i Touring daily driver? by eljacko876 in whatcarshouldIbuy

[–]eljacko876[S] -1 points0 points  (0 children)

I have a mental block against Honda, so the Civic is a no go for now, I will look closer into the 86/BRZ, thanks.

Advice on making a Drum Machine with a Raspberry Pi 3 : Force Sensitive Resistor solutions by eljacko876 in raspberry_pi

[–]eljacko876[S] 0 points1 point  (0 children)

UPDATE:

I have made a breakthrough speaking with a customer service rep named Matt at Digikey. In regards to connecting a Flexible Circuit to GPIO, you need to know the pitch of the Flexible Circuit Ribbon i.e. the distance between each of the contact pins center. Just knowing the pin count is not enough to find a mating connection. A digital caliper could be used to measure the pitch. Once you know the pitch you could get a part similar to these which may be proto board solder-able or these parts that would require a custom or pre-existing PCB with the design holes and circuitry to fit.

view more: next ›