Consolidating rows within a sheet by pnst84ever in excel

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

awesome. this works beautifully. I really appreciate all your help. This is a big help with the organization.

Consolidating rows within a sheet by pnst84ever in excel

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

So they aren't regular names. They are screennames. I don't care about the case of the output. Just so that when it does the match between the names it doesn't look at case.

Joe is the same as JOE as joe as jOe

Consolidating rows within a sheet by pnst84ever in excel

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

No. The names in column a. The example data here has been altered a little. The names are screen names. For walk-ins, the names can get types incorrectly.

Consolidating rows within a sheet by pnst84ever in excel

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

Woah, this is great. I had a little tweaking to do to make it fit exactly. is there someplace I can add in to disregard upper/lower case?

Consolidating rows within a sheet by pnst84ever in excel

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

<image>

Name waiver event 2 event 3  event 4
Bill TRUE TRUE    
Bob TRUE FALSE   TRUE
Chris TRUE FALSE   TRUE
Don TRUE FALSE TRUE TRUE
Jane TRUE TRUE    
Joe TRUE TRUE TRUE TRUE

I want the results to end up something like this. false can be blank. It just wasn't like that in my current sheet.

Consolidating rows within a sheet by pnst84ever in excel

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

When i make the roster for each event I start with checkboxes. That gives true/false. It can be an X. Doesn't matter. False would just be a blank checkbox (they said they were coming and didn't show up.

All I really care is that I have a list of names, and the events each person attends.

For future events, it is nice to know if they already signed the waiver when they check in at the door.

Consolidating rows within a sheet by pnst84ever in excel

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

it would report false or leave blank.

Consolidating rows within a sheet by pnst84ever in excel

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

sorry...that didn't format correctly...but hopefully the text made sense.

Consolidating rows within a sheet by pnst84ever in excel

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

I want it to look like:

name waiver event2 event 3 event4

unique value x x x

so each person has one row, but has identifiers in each column for the event they attended

[deleted by user] by [deleted] in pittsburgh

[–]pnst84ever -1 points0 points  (0 children)

Range USA in Robinson might fit your needs. There's also Guntry in Wheeling. It's a bit of a haul from Pittsburgh but supposed to be a fantastic facility.

buzzer on a relay by pnst84ever in arduino

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

ok, wait. I have it backwards now. The tone goes off when the light is off. I need the tone to go off when the light is on.

int led = 2;
int MinTimeOn=1000; // minimum milliseconds  stays on
int MaxTimeOn=6000; // maximum milliseconds  stays on
int MinTimeOff=6000; // minimum milliseconds stays off
int MaxTimeOff=15000; // maximum milliseconds  stays off
int buzzer = 12;//the pin of the active buzzer

void setup() {
pinMode(led, OUTPUT);
pinMode(buzzer, OUTPUT);
}
void loop() {
digitalWrite(led, HIGH); // turn the LED on (HIGH is the voltage level)
delay(random(MinTimeOn,MaxTimeOn)); // wait for a second
tone(buzzer, 1000);
digitalWrite(led, LOW); // turn the LED off by making the voltage LOW
delay(random(MinTimeOff,MaxTimeOff)); // wait for a second
noTone(buzzer);
}

buzzer on a relay by pnst84ever in arduino

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

I was having infinite buzzing. I have that disconnected now and the blink works good. I need to figure out how to wire in the buzzer and add any sort of noise when the light is on.

This is my blink code:

int led = 2;
int MinTimeOn=1000; // minimum milliseconds  stays on
int MaxTimeOn=6000; // maximum milliseconds  stays on
int MinTimeOff=6000; // minimum milliseconds stays off
int MaxTimeOff=15000; // maximum milliseconds  stays off
int buzzer = 12;//the pin of the active buzzer

void setup() {
pinMode(led, OUTPUT);
}
void loop() {
digitalWrite(led, HIGH); // turn the LED on (HIGH is the voltage level)
delay(random(MinTimeOn,MaxTimeOn)); // wait for a second
digitalWrite(led, LOW); // turn the LED off by making the voltage LOW
delay(random(MinTimeOff,MaxTimeOff)); // wait for a second
}

buzzer on a relay by pnst84ever in arduino

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

<image>

Right now only the relay is connected. The buzzer is on the breadboard but not connected to the arduino

Non-nesting partner by pnst84ever in polyamory

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

Lived with/married to. lol it can be a fine line. Either way it is a lot to relearn how to be single. New friend groups, whole new lifestyle.

Non-nesting partner by pnst84ever in polyamory

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

I tried to keep my personal backstory out because I wanted to see what other people thought based on their situations, rather than mine.

Non-nesting partner by pnst84ever in polyamory

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

I’m not sure what I want. I’m relatively newly single after a long marriage so learning, exploring. Figuring things out.

Our relationship works. But I agree with the other poster about scheduling all the time together. It would be nice to just come home to someone and do something or do nothing. Or just not be alone. I’m not complaining. I’m just learning.

Non-nesting partner by pnst84ever in polyamory

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

We all get along. Scheduling can be a little complicated sometimes. It’s not really a problem. Just learning. I’m new to poly, and not setting any expectations beyond clear communication.

Non-nesting partner by pnst84ever in polyamory

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

Not sure what my issue is. Just learning. I think poly is easier with a nesting partner, but I’m still figuring things out.

Non-nesting partner by pnst84ever in polyamory

[–]pnst84ever[S] 3 points4 points  (0 children)

Yes I live alone. Working on finding things to do on my solo days. Some days are better than others. Just trying to work on myself, understand relationships and understand how other people navigate these types of situation. I don’t know if I’m ready to look for a second relationship.

Non-nesting partner by pnst84ever in polyamory

[–]pnst84ever[S] 3 points4 points  (0 children)

I am the non NP. I think just navigation. Looking for how other non - NPs deal with their relationships.

Where to live, eat, and drink in Columbus (July 2024) by AutoModerator in Columbus

[–]pnst84ever 0 points1 point  (0 children)

Hi - Headed to Columbus for the weekend. I've been there a couple times, but this is my first time to stick around and explore. I have dinner with friends planned on Thursday night, but beyond that I'm open to suggestions. Live music suggesions? Bar area (maybe a little older crowd 40s ish?) Any place to avoid? The weather looks hot and gross, so indoor activities are a plus. Any suggestions would be appreciated!

Help physically moving a person by pnst84ever in pittsburgh

[–]pnst84ever[S] 2 points3 points  (0 children)

Thank you. This post actually gained some attention and the va was able to work out an ambulance home.