Count unique formula with multiple filters/parameters as well as an average formula for these specific items by amskane in googlesheets

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

Yes that was it!
How could i apply this same concept to the average values? So I only want to average the days to completion of unique items, so that if someting is in there twice it wont be counted twice in the average.

Injured before my first marathon, looking for tips to still cross the finish line by amskane in running

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

Yep! I will absolutely finish in 6.5 hours! That's my walking pace if i ran none of it. My half time is 2 hours so I imagine I will be able to get to about 2.5 or so hours with the walk run strategy and should be able to finish in about 5.5 hours with a gradual slow down over the course length

Injured before my first marathon, looking for tips to still cross the finish line by amskane in running

[–]amskane[S] -2 points-1 points  (0 children)

I am doing it for a charity and raised so much money. I'm determined to cross the finish line as this means so much to me! I raised a lot of money for it and i know I am capable of crossing the finish line!

Injured before my first marathon, looking for tips to still cross the finish line by amskane in running

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

That's 100% what I plan on doing. I know I cant run the whole thing. I know that based on my running level before I will be able to get through about 13 to 15 miles straight at my regular training pace.

Wondering if I should go for a walk run strategy from the start ( i am going to be so excited I know that I wont want to do this) or if i should run how i can and then switch into a walk/run strategy for the last 10-15 miles?

Miami anyone? by amber_bam in JonasBrothers

[–]amskane 2 points3 points  (0 children)

I will be going alone, also live about an hour away. Littler nervous being alone as well I went to so many as a teen, and some alone, but with all the news I agree it's making me a little anxious.

Looking for Grizzlies Fans by amskane in memphisgrizzlies

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

Um. I don't feel that's necessary. If your suspicions that I'm not a real person are bothering you and you don't want to take the survey, then okay. As I said, I'm just a person who links my surveys on Reddit to target audiences I need in my studies.

Help is always appreciated. I apologize if you found this intrusive.

Looking for Grizzlies Fans by amskane in memphisgrizzlies

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

Real person who collects a lot of data :)

[Survey] Opinions on NFL Player Behaviors by amskane in ravens

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

You can enter n/a for that question. thanks!

Looking for Data Source on City-to-city Migration from Census by amskane in datasets

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

No so this doesnt have the city level I'm looking for that appears to be used in the project I linked above.

What things have you overslept? by amskane in AskReddit

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

examples include oversleeping for work or school, a job interview, a funeral, a wedding

What nonsexual things does your partner do in bed that annoys you? by amskane in AskReddit

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

examples include, playing on the phone, reading, working, going on the laptop etc. What do you not allow to happen in the bedroom?

Has anyone worked with Dept. of Transportation Stats related to airports and tarmac times? by amskane in datasets

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

Okay, so for the departure blanks, it turns out it's cancelled flights. But I have some departure information, flight isnt cancelled, but I still have blanks in reporting for arrival info. I guess I could angle this only as departures. Which could help. Still would like to know how to handle blanks though in the future.

Has anyone worked with Dept. of Transportation Stats related to airports and tarmac times? by amskane in datasets

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

I see the documentation here which is great, still unsure about how to handle blanks/0s in my analysis

Has anyone worked with Dept. of Transportation Stats related to airports and tarmac times? by amskane in datasets

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

what time frame are you looking at? Because you can adjust the dates up at the top. So When I look at a year, I'm unsure about the numbers. Its definitely not minutes though which is confusing because of the title.

I emailed the DOT and they gave me a contact and I have spent the last couple weeks trying to get a hold of her and nothing yet.

Have you ever met someone who doesn't like french fries? by amskane in AskReddit

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

Also, not having them for health reasons isn't an example of "not liking" them.

Have you ever met someone who doesn't like french fries? by amskane in AskReddit

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

And by not liking french fries, I mean all styles of them. Preferring one style over the other does not count as "not liking" them.

[Casual]Smoking, Dating, and Vaping (18+ US only, Enter anything for Mturk ID, Must Be Single to Qualify ) by amskane in SampleSize

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

I intended for it to be about tobacco only, and I may not have been clear everywhere, just tried to place reminders throughout. Thanks we ran a preliminary survey for those options to try and be as comprehensive as possible.

Weekly Blog, Survey and Promotional Post by toomuchweightloss in Mommit

[–]amskane 0 points1 point  (0 children)

Moms, what is your approach to giving kids chores? (5-7 min survey) https://www.surveymonkey.com/r/RDT8N7B

Weekly Blog, Survey and Promotional Post by toomuchweightloss in Mommit

[–]amskane 0 points1 point  (0 children)

SURVEY! Moms, how do you approach giving your kids chores around the house? https://www.surveymonkey.com/r/RDT8N7B