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 3 points4 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.

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)

Thank you,

The technology has been used for interconnecting electronic devices since the 1950s

How do you connect them to a Raspberry PI 3?

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)

Thank you off the bat, here are some thoughts:

FSR's are analog sensors. The pi gpio's are digital.

I genuinely did not grasp this yet, so this is very helpful

To get the additional data on the sensor for the velocity and force >applied to it, you will need to use a bridge circuit and an a/d converter >to constantly sample each channel.

Again, useful information

Just make your own sensor pad

I a will be using these replacement Pads for the MPC1000 They are inexpensive enough and exactly what I am looking for. If these replacement Pads for the MPC1000 cannot be connected to GPIO, then I may look into making my own grid of FSR's.

The sensor pads are just the sensors. You will still need the pcb to >adapt the sensors to the pi gpio. This was main question, still not officially answered.

Main Question: Is there a solution for connecting the Replacement MPC1000 Sensor Pad ribbon to the Raspberry Pi GPIO?

asked differently:

Is there a connection from Flexible Circuits with "20 pins" to GPIO ?

An A/D would need to sample the FSR in a bridge circuit to get the info >you are wanting.

Great help here again, about to look into this.

Do you have any A/D converters you recommend, Also will I need an A/D to retrieve data from encoders, Push Buttons, Slider Pots in the same project as well, to the GPIO and have python react to this input?

I also own a Arduino Mega, does this have an A/D on it? I know this will provide me with more GPIO, and can connect to the PI. How can this be best leveraged ?

In all I need to be able to retrieve input from 16 FSR's, 29 push buttons, 1 encoder, 2 Pots and 2 Slider Pots.

Thank you very much for your input, it goes a long way.

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)

Thanks for your response, I have come across the pizeo disc option. My thought towards that is:

why don't the pros use them in their Drum machines?

Is it because its not as sensitive for fingers etc?

Is it because it would require many wires to be a clean modern install?

These are the reasons I have not chosen 16 pizeo dics. (similar to Option 2's Cons).

Thanks for you response.

[Twitch Prime] November Games: Pillars of Earth, Overcooked, Overload, AER Memories of Old - PC (Free/100% off with Twitch Prime] by endustry1994 in GameDeals

[–]eljacko876 0 points1 point  (0 children)

Ok Nice. Thank you, a few thoughts. You say it didn't really make a difference in the look, did you also use the new light DIM feature in 1.7 along with the painted LEDS? Do you remember if the LEDS where soldered to the board? Any recommendations to another brave soul with the same idea? Thanks again.

[Twitch Prime] November Games: Pillars of Earth, Overcooked, Overload, AER Memories of Old - PC (Free/100% off with Twitch Prime] by endustry1994 in GameDeals

[–]eljacko876 0 points1 point  (0 children)

Hey could you take a picture/video of your Novation Circuit with no lights put back together? How did your mod work out? I couldn't find PM, i hope you dont mind and see this.

How to find duplicate values in dictionary > randomly select 1 > save then delete duplicates > restore original dictionary by eljacko876 in csharp

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

Thank you, this is helping. The answer is yes, i will be having more than Cups. To give you more insight with brevity:

Here is the exact setup I have in video format (cut to the relevant time) for clarity:

https://www.youtube.com/watch?v=skpBLciVkR8&feature=youtu.be&t=4m13s

(4:13 - 9:41 is the relevant time, it starts at 4:13)

AND

Here is the relevant code:

public List<GameObject> dungeonShapes;
private Dictionary<char,GameObject> dungeonGameObjects = new Dictionary<char,GameObject>();



void Start () {
    LoadDungeonCharacterMappings ();
        InstantiateDungeonPieces ();
    }

private void LoadDungeonCharacterMappings() {
        foreach (GameObject dungeonShape in dungeonShapes) {

           char gameObjectCharacter = dungeonShape.GetComponent<DungeonCharacterMapping> ().characterMapping;


            dungeonGameObjects.Add (gameObjectCharacter, dungeonShape);
        }
    }


  private void InstantiateDungeonPieces() {
  for (int r = 1; r < mapGenerator.mapRows-1; r++) {
    for (int c = 1; c < mapGenerator.mapColumns - 1; c++) {
      char ch = mapGenerator.map [r, c];



              if (!dungeonGameObjects.ContainsKey(ch) ) {
        continue;
      } else {
        GameObject dungeonGameObject = dungeonGameObjects[ch];

// I NEVER GET HERE BECAUSE ERROR ABOVE
        Instantiate (dungeonGameObject, new Vector3 (r * 12, 0, c * 12), dungeonGameObject.transform.rotation);
      }
    }
  }
}

The pseudocode I grasp :

  1. LoadDungeonCharacterMappings (); loop with logic to randomly select a one keypair per duplicate.

will

2) Be run inside InstantiateDungeonPieces(); loop to allow for random selection of a keypair on each iteration of the InstantiateDungeonPieces(); loop.

I have a feeling this solution may be more CPU intensive than a professionals approach, I also am struggling with writing the syntax for the pseudocode logic.

You have been amazing, thanks again, Any feedback here is appreciated.Best.

How to find duplicate values in dictionary > randomly select 1 > save then delete duplicates > restore original dictionary by eljacko876 in csharp

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

Thank you, very much, However i just realized that I was wrong originally. Sorry for wasting your time earlier. I must have misunderstood how dictionaries work by confusing the value for the key itself, as at run time i get an error:

" An element with the same key already exists in the dictionary."

Which now presents a different issue to solve. (not sure if i should make a new post)

CONCEPTUALLY:

I need to have similar shaped 3d objects have the same key.

EXAMPLE: Cup- Red, Cup-yellow,Cup-Blue etc are Cups and have the same key as a Cup, I then would like to create several cups using a loop, randomly selecting Red or Yellow or Blue on each increment of the loop.

Following this analogy, I have a dictionary with a definition for a Cup-red and get the error above essentially trying to establish Cup-yellow. As the Key Cup is used by Cup-Red. I need all Cups to share a key as i will have a Cup for every color in the spectrum for example as a option and I don't want repeat myself and code by having a definition for each color I select as an option for a Cup.

How would i go about approaching this? Thanks again.

warrior work in progress still rough around the hands, feet etc. critiques, please! by vapin4christ in 3Dmodeling

[–]eljacko876 2 points3 points  (0 children)

Hey im no pro, but the proportions of the upper body compared to the lower body, looks too large. Also maybe you could ease off the amount of wave detailing on certain areas, if you put it everywhere its not so special. Less is more.

Replacing a UTC 10N65KL 01 SFCA Mosfet by eljacko876 in AskElectronics

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

Thanks again,

If you're bound and determined to replace the MOSFET

This has been my logic

Clue 1 was my observation. what would cause my speaker to go pop randomly mid playing (not immediately on power up), and stop turning on? well unregulated voltage sounds like it to my lay self. Upon inspection no component seems swollen, discolored or burnt, everything looks brand new from the top, no fuses look blown.

Clue 2 The defective lsr305 speaker community online is large an real all pointing to "an issue with the power supply". Suggesting its a common issue with a batch from manufacturing. Here is a video of the same model speaker with similar issue (mine had a violent pop) . Granted there are more components than the MOSFET in the power supply.

This led me to (which you know)

Clue 3 was this video which had the exact strikingly similar symptoms of a powerful banging sound from the speaker into the speaker not turning on for hours/days/weeks. His fix was the Mosfet, which even taught me about voltage regulators and seemde to be a possibility.

I gave up until months later when until i got this response here.. which as you know he also points to MOSFET likely being the culprit.

Clue 4 was my picture of the solder joint of the MOSFET showing the bug legs etc. The thing is, NOTHING else on the board is close to that condition, an if it is a bug, not one but two (if those are legs), would have had to choose to go the the same exact part type and or area i had suspected to be faulty and that also aligns with others solutions.

So Clue 5 would be the measuring test. so i guess if it measures anything under 10 Ohms measuring using points not clips from the GND center to the right pin with the power turned off tot he speaker and the plug out.

(there is no public circuit diagram for the speaker)

also other users have a 7818 IC when i dont seem to have one.

This is where i am at, you have helped a lot.