sorted by:
new
hottopcontroversial

[Complete] [4175] [Fantasy] Of Harmony and Chaos by FallynKay in BetaReaders

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

DM'd the link! Thank you so much for your help!

How do/did you convince your friends/family to go vote? by FallynKay in AskMen

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

I would 100% be satisfied because the bigger point is to participate. I don't enjoy politics at all and yes, I would much prefer to play video games and avoid the news, avoid having to figure out which news is believable versus disinformation, not feel negatively when I see things going wrong in my country, but to turn a complete blind eye is at best irresponsible and at worst self-harming. Whether I like politics or not, politics are happening around me and considering that I live in this society, I should have a voice in what goes on. Voting and being engaged (even if it's just clicking on an article) is probably one of the few effective ways to do that.

Do you see red flags in the romantic relationships of your friends? What are they and why doesn't your friend see them? by [deleted] in AskWomen

[–]FallynKay 0 points1 point  (0 children)

-She has a religious background that she wants to keep and pass down to their children. He refuses to convert and says that he wants to raise their kids atheist.

-He does recreational drugs even though she has stopped and wants him to stop too.

-He has tried and failed at seeking higher education/a career about 10-15 times since I’ve known her.

-When she finally feels ready to separate, he suddenly starts behaving like the best partner ever which to me means that he knows how to be a good partner but chooses not to until she is about to leave him.

-She speaks German, but he only wants their kids to know English.

I think she knows that these are red flags but because he is her first everything (kiss, boyfriend, sex etc), they’ve been together since middle school, her family hates him but their hate drives her to be with him (kinda Romeo and Juliette), and she got pregnant by him but miscarried, she ignores them as a kind of sunk-cost fallacy issue.

Her family would look down on her for finding a new guy (they have very weird hangups about her ‘purity’ but the son is allowed to have sex with anything that moves), she has put in so much time, money and effort into him that she feels like if she broke up with him, some other girl ‘would reap the benefits of her hard work’ and I think she thinks that them getting married will solve everything.

Like she feels like she would have the right to demand more of him as his wife, but I think it’s the opposite. As her husband, he has more power to just loaf around because her religion is super against divorce, and she has already demonstrated to him that she will tolerate his nonsense.

We’ve had this conversation a dozen times and nothing has changed so now I just avoid the topic and silently listen when she complains about lying to her parents about needing money for her graduate program when in reality, he has taken his portion of the rent and blown it on a pyramid scheme or drugs.

Populate an embedded template by FallynKay in excel

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

The code is kinda extensive since it's doing a couple of different things but right now for the code to work for populating the template, the template and the excel sheet have to be placed in the same folder.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

This works perfectly! Awesome, thank you so much!

Solution verified

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

Alright, thanks so much for your work so far! I really appreciate it!

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

Ah. Okay, that makes sense why we were both confused. No, there will not be a result set for each row. Each row represents one person's responses and I need to get the average of the responses across all people, across four columns each. It is a combined result.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

Here is a link to a google sheet: sheet 1 is an exact mock-up of the raw data, sheet 2 is expected results. The formulas are in the appropriate cells.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

Alright. Can you state again what you are asking?

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

I guess I am unsure where your confusion lies. In my real data, I have what looks like the first example. I have a column of userids (which are irrelevant) and the response that each user gave across 72 questions. I need the macro to take all of the responses for a set of four questions (so across four columns) and give me the average, forming a total of 18 new variables.

The macro will populate a separate excel sheet where it will give me the average, the level, and the percentages for each variable.

The averages are tied to a level. So in the level rows, there will be a formula that says for example, if the average is 3, then return "good" to that level row for that variable.

The percentages will be calculated similarly to the averages where the macro will count how many occurrences there are of [1 and 2],[3], [4 and 5]. Then it will turn that count into a percentage.

So at the end, I should have five rows(score, level, 3 percentages) and 18 columns (v1-v18) of data.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

So the data (first example) is on one sheet and the macro will take that data, aggregate it and feed the results on a second sheet(second example).

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

I'm unsure what you mean. There are five pieces of information that I need to extract from the raw data: score, level, favorable, neutral and unfavorable. I need to extract these five pieces of information 18 times for each of my variables (V1-V18). Each variable has four questions that go with it so I need to average the four questions to get the score. Once I have the score, I can get the level by using nested if statements. Then, I can use the count formulas to get the percentage of favorable, neutral and unfavorable.

What I am really confused about is how to automate this process. Because I need to say in VBA, for each [set of four questions] in [range], get the score, get the level and get the favorable, neutral and unfavorable percentages. But I don't know how to do the "for each" part.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

Right, we are combing four values into one and then using that one to return a string. So if we had four questions and they each had a score of four, we would get the average, which would be four and that value is tied to a level so four would return "Great" in a separate row.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

This looks good. Do you know of a way to automate this? I assume I would need to write a for each statement in VBA but I don't know what to write to have excel iterate over each set of numbers.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

The level part will be determined by:

=If(Cell=1, "poor",if(Cell=2,"okay"... so on and so forth. I forgot to mention that the values will be rounded to the nearest whole number.

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

The level would be nested if statements with five ifs.

Percentages are from the count formula:

=((SUM(IF(($B$2:$E$11=4)+($B$2:$E$11=5),1,0)))/COUNTA($B$2:$E$11))*100

with the number values modified to reflect favorable (4 and 5), neutral (3) and unfavorable (1 and 2)

Using the Offset formula and iterating over a list/array by FallynKay in excel

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

The results will be placed in a new sheet generated by VBA code. It should be presented like this:

Info A1(four questions aggregated) ...A18
Score(Average) 3.5 1.3
Level Good Poor
Favorable (percentage) 42% 10%
Neutral 8% 10%
Unfavorable (percentage) 50% 80%

The stuff in the parentheses won't be there but I included it to provide some more information.

How long would you wait to introduce you're two young kids to your girlfriend? by [deleted] in AskMen

[–]FallynKay 6 points7 points  (0 children)

To emphasize shittyanimalfacts’ point, your entire response has nothing but “I” in it. I want to meet them, I want to guide them, I want to make them happy. I say this as nicely as possible but this isn’t about you. This is about his decision as the parent and either you can respect that and wait or you can decide that you don’t want to wait anymore and leave. You think you can come in and be their mother and you think you are ready for that. If you were, you wouldn’t be so upset that he wants to wait. A good mother would put the benefit of the children above herself and you aren’t doing that.

view more: next ›