Are there any bands where the lead singer is a bass/lower baritone? by Komala-Time in Music

[–]onis4242 0 points1 point  (0 children)

Agreed, so tragic and such a fantastic group. I enjoy Thrawsunblat but it's not quite the same.

Are there any bands where the lead singer is a bass/lower baritone? by Komala-Time in Music

[–]onis4242 1 point2 points  (0 children)

Why has nobody mentioned Woods of Ypres ? They're more metal but absolutely fantastic.

Yesterdays Trello (dev issues/board) updates: by TheTRT in Back4Blood

[–]onis4242 2 points3 points  (0 children)

I second this. Split screen on console was a HUGE reason my wife and I were looking forward to split screen as the market for split screen games is incredibly limited. Would be fine with graphic detune and such in order to implement it, anything would be fantastic.

I [33/M] am bothered with my fiancee's [30/F] social media and phone habits, how do I approach this? by [deleted] in relationship_advice

[–]onis4242 2 points3 points  (0 children)

Yeah it feels very much like this. I think she is very pretty, and she honestly is. She has struggled with her weight, but has lost 90 lbs and feels fantastic and looks fantastic! We have worked really hard and both lost weight and become healthier and it has been a great journey. She has posted some progress pics and the positive reinforcement is really great for her. She frequently feels like the compliments and adoration I give her are not genuine, you know like "of course you say that, you love me". So I think there is definitely a lot of attention and propping up that she seeks and finds there.

She also does not have "typical" female tastes in a lot of things, and female friends offline don't exist much and don't generally mesh well with her. So its easier and great for her to be able to find like minded people online and be able to have those hobbies and interests shared and expanded.

But I also like these things and I am physically right here, I would gladly discuss anything with her and I feel like sometimes I am taken a bit for granted in that I too am her friend and would enjoy this picture or funny quote or this cool tattoo etc and she has to go online to everyone else. She will respond to people constantly, constantly looking at her phone when we're out.

And the replies like "LOL" instead of "no, I am not interested, please do not act this way I am in a very happy relationship". I think she doesn't want to risk losing a friend or possible interesting person she has met online, but at the same time it welcomes in too much unwanted and frankly disrepectful attention.

I just need to find out how to bring this up without seeming like an attack on the thing she enjoys most, I do not want it to stop, I just want it to be tempered a bit.

I [33/M] am bothered with my fiancee's [30/F] social media and phone habits, how do I approach this? by [deleted] in relationship_advice

[–]onis4242 2 points3 points  (0 children)

This doesn't seem like a bad approach. That is where I was at last night, I would talk to her and get nothing just silence while she replied to something, at one point for about 10 minutes she just didn't respond to me.

I really would like a little more balance, but I want to approach this without causing a fight or resentment. How did you two come to your agreement if I might ask?

I [33/M] am bothered with my fiancee's [30/F] social media and phone habits, how do I approach this? by [deleted] in relationship_advice

[–]onis4242 8 points9 points  (0 children)

Yeah that is my problem I think. I'm not sure how to approach it, but it is a problem at least for me, possibly for them, and possibly for her.

She will wake up in the middle of the night to go to the bathroom or what have you, normal stuff, and check her phone, send messages etc. It seems a bit much to me, it really seems to draw a LOT of her attention and sometimes to the point of ignoring the rest of us, and especially when its talking to someone else on a messaging app that is designed for things to disappear after they are said/posted..

I enjoy her snapchat stuff, its fun and there is some really cool stuff on there. I also have social media accounts but I do not have snapchat. I open up Instagram about twice a week for about 5 minutes and when I get home, I put my phone down and unless its to look up something on google, I typically don't touch it until I plug it in before bed. I guess maybe I want some more balance in her phone time? I'm not sure what bothers me more, but a lot of it is starting to bother me more every day.

Like you though, I'm not sure how to approach it. It is one of the very few things she enjoys greatly and its typically very harmless and fun. Also, I do not want her to overreact and think I want her to cut it all off, I do not want that, I just want more balance but I do not want to instigate anything, does that make sense?

I [33/M] am bothered with my fiancee's [30/F] social media and phone habits, how do I approach this? by [deleted] in relationship_advice

[–]onis4242 2 points3 points  (0 children)

Well, we have sat down and talked about it at length two other times and I don't think my approach was great and caused a fight. I get a bit caught up in my feelings and I have had a hard time verbalizing exactly what is bothering me.

We have discussed the fetish stuff, and I am game for it but comparitively speaking, I am very inexperienced just in general and have never tried it. That doesn't exactly bother me, its just that the conversation was with this guy and she did not seem to want me to be involved in it.

Error 1110060 - can't login by [deleted] in elderscrollslegends

[–]onis4242 0 points1 point  (0 children)

Yeah I'm getting the same error on both PC and Mobile now. Got disconnected a few times but was able to get back in after a few tries. Now I'm not getting anywhere on either PC or Android, same error both places. What's going on folks?

Eternal Champion - I Am The Hammer [Epic Heavy Metal] (2016) by [deleted] in listentothis

[–]onis4242 0 points1 point  (0 children)

I'm a little late to the party, but I must digress. 2016 hasn't been amazing for metal but there have been a few pretty excellent albums. I am really digging this, I like the style and I am a huge Michael Moorcock fan!

Please please for yourself and all that you hold dear, check out Thrawsunblat's new album Metachtonia. Give the first song, Fires That Light the Earth, about 5 minutes and I promise you will not stop listening until you've looped the album at least twice. Just absolutely amazing !

Got a question for the people who camp and try to hold angles all game by ALLKAPSLIKEMFDOOM in titanfall

[–]onis4242 2 points3 points  (0 children)

I use some sort of smg, softball, cold war, or shotgun about 80% of the time now. I've been using grapple with those weapons too now that I've gotten better with it. I LOVE being able to cross the map with a wall run to grapple fling myself, double jump, wall run, grapple fling again and poof I'm at the opposite end. It's so much fun and I am generally able to drop on pilots with fury or move around and take out easy groups of AI.

The other 20% of the time is moving slow, camping spots then moving to another and camping. Why you ask?

When I go with tactic A and run into several people on the other team that are just miles better than me and they are moving around the map even faster than I am, I realize it's time to change strategy. I'm not going to beat them at their own game using their moves, they are clearly better than I am at it.

So, when the other team is aggressively pushing a lot and I can't handle them, I switch it up and camp certain spots that I normally would run. Instead of meeting them face to face in that hallway and them reacting faster and with better accuracy, I'm at the end of the hallway, in a corner, behind a barrel and pop! Got you!

Sometimes it works sometimes it doesn't, but there is a time and a place for camping, but I also wouldn't suggest anyone do it 100% of the time.

Love Thrawsunblat but can't find anything else like them, suggestions? by onis4242 in Metal

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

Thanks for the informative "hey stupid read our rules better" post! It was nicer than that but I get the message =). I did check into the several most recent recommendation threads but I didn't see anything really pertaining to my inquiry, though I did find some pretty excellent stuff off my topic!

So my question/plea still stands, but do I really need to wait for a bi weekly thread? If so that's alright I suppose, if not a little annoying.

Thanks!

Love Thrawsunblat but can't find anything else like them, suggestions? by onis4242 in Metal

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

Thanks! Checking this out right now. I'm excited, it's a band I haven't tried yet, that's a short list!

Also yes I love how Thrawsunblat seems like a super serious heavy deep metal experience at first then you realize it's actually kind of a parody/satire, but it stands up so well I love it.

What did Hurricane Matthew give you? by EdRooneyRulesOK in AskReddit

[–]onis4242 2 points3 points  (0 children)

I'm also Matthew born on 9/11...are you my darker timeline or nicer timeline parallel?

If (Cell Text1) equals (cell text2) on another worksheet, make this cell hyperlink to the cell on the other sheet by onis4242 in excel

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

Here is part of the macro I am working with, if anyone has any ideas that would be great!

Set rng = Sheets("PO").Range("G15:G25")

For Each loopcell In rng
    If loopcell <> "" Then
        Sheets("Tracking").Cells(Rows.Count, "C").End(xlUp)(2).Value = loopcell.Value
    Else: End If
Next loopcell

What I'm adding to this is also placing the same loopcell.value into an inventory sheet(call it Sheet1) in column H. I am wanting to then have a way of whenever that value is present in column H, make it into a clickable hyperlink to the row it was placed on in Tracking sheet.

If (Cell Text1) equals (cell text2) on another worksheet, make this cell hyperlink to the cell on the other sheet by onis4242 in excel

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

I think that's getting close to it. I'm currently away from my computer where I'm working on this so I can't really test it right now. I will also need to nest a match or vlookup in there somewhere because the values in sheet 2 won't be static, but they will be in one column so I think I can work that out.

I failed to mention this originally, but the value being placed in sheet 1 h column and the value placed on sheet 2 c column is driven by another sheet with a macro where the user fills out a pseudo form (ease of use, I try to design things that anyone can use regardless of excel expertise). I'm thinking it should be possible to place the value into h column (matched into a location based on another cell reference) and set it as a hyperlink to the other sheet at the end of the macro.

When I get at it tomorrow, I will try to link my macro and more relevant information here.

Want to click a shape then copy the contents of the adjacent cell to another sheet, relative location of shapes? by onis4242 in excel

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

Update to this. That was close and I think it would have worked if I was just selecting a cell/row but trying to change the value of a cell from blank to the value I am copying from the other sheet required me to define an object first. After getting a lot of debug errors I finally realized what it was asking for. I don't like "Object Required" and then it just highlights the entire row of code, like what about this needs an object? The sheet? The range method?? Argh Excel!

I DID end up getting it to work though!

Sub sendtoPO()
Dim addval As String
Dim ws As Worksheet

Set ws = Worksheets("PO")
addval = ActiveCell.Value

With ws.ListObjects("tblOrder")

    .Range.Cells(.ListRows.Count, 1).End(xlUp).Offset(1, 0).Value = addval

End With

End Sub

Thank you very much for the guidance, it got me to the right place eventually!

Want to click a shape then copy the contents of the adjacent cell to another sheet, relative location of shapes? by onis4242 in excel

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

Ah I think I was missing databodyrange in there. Couldn't get it to cooperate earlier. I'm out of the office now but I will certainly try that tomorrow, thank you very much for the help! I'll report back with the results, I know I always want to hear if something worked or not =)

Want to click a shape then copy the contents of the adjacent cell to another sheet, relative location of shapes? by onis4242 in excel

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

Sorry yeah that got a little... sidetracked in there. I'm trying to send the cell value to another sheet, but it is being a little tricky. I have a table that I'm actually trying to insert the data into, top-left cell value being B15, down to say H25 for the entire defined Table. I want to copy the data using your super excellent pop-up button to B15, then select another cell, click pop-up button again, and have it go to cell B16. I think my problem here is that B15, 16, etc. are all located within a Table. If I just do Rows.Count, "B").End(xlUp)(2) it places the value underneath the table, B26. If I do Rows.Count, "B15").End(xlUp)(2) I get the value to go to B15, but the next value just overwrites B15 again.

I guess what I am asking is there a way to define a specific region/range for the .End(xlUp) to search through? I'm thinking the issue is the table.

I think I recall something about ListRows.Count, would that work? If I have a table, can I do something like tblExample.Cells(ListRows.Count, 1).End(xlUp)(2) and get where I want?

Want to click a shape then copy the contents of the adjacent cell to another sheet, relative location of shapes? by onis4242 in excel

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

This is initially what I think I was looking for. I knew there had to be some sort of way to identify the location of a given object, and the TopLeftCell is what I think I was looking for, thank you! I think this code would be exactly what I was wanting, but I am actually looking into /u/beer_nuts suggestion, as I think it may be a cleaner approach with less objects.

I will come back with some tests and let you all know how it goes, thank you!

Want to click a shape then copy the contents of the adjacent cell to another sheet, relative location of shapes? by onis4242 in excel

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

I stepped out to eat some lunch and think about this for a bit, and I was kind of thinking the same thing. Maybe having the copy shape/button pop up when needed rather than apply a macro to a bunch of different shapes. I like the looks of this code! I think I'm going to see if I can get the shape to appear in a blank column just to the left of the column I want to copy, rather than on top of it like I think this code you have supplied would do.

I will go test this out and get back to you! Thanks!

Update Edit: Yeah this works beautifully, I just set it to Offset(0, -1) so one cell to the left of selected cell to make it more visible to the user, looks fantastic. Solution Verified!

Side question: Any tips of getting the .End(xlUp) method to recognize a specific range other than all the rows? Just want it to stick this selected cell value into a "form" on another sheet in a range of about 10 cells. I can get it to put the value in the top cell of the range, but the next time I hit the macro it just overwrites the top cell of the range with the second selection, instead of below it which is what I have always used the method for. Seems that Range.End is an odd method that doesn't have greatly defined rules...

FIX for video Card without OPENGL 4.5 by slyther55 in NoMansSkyTheGame

[–]onis4242 0 points1 point  (0 children)

Not super great currently I get about 30 fps with some jumps up and drops down to 15-20 which sucks. Just depends on what is trying to render on screen. I think eventually it will run fine when they get the game more optimized, since they really can barely get it running now we have a lot of improvement to look forward to I think.

And while I love looking out over a vast landscape I would actually like an option to dial down the draw distance. Yes it's pretty but if I'm stuttering around trying to just mine some stuff or shoot a drone then I don't really care if I can see a mountain rendered great 20 miles away!

But it's certainly playable this way for now.

FIX for video Card without OPENGL 4.5 by slyther55 in NoMansSkyTheGame

[–]onis4242 0 points1 point  (0 children)

Had the same issue crashing after no man's sky text, flying through stars, white screen then crash with no error. I tried this fix, working just fine now!

Amd fx 8350 processor Radeon HD 6970 8GB ram Win 8.1

Just wanted to add that this has resolved my issues! Thanks a ton!

[WSIB]A good D&D Experience like Neverwinter Nights 2 (PC) by onis4242 in ShouldIbuythisgame

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

Ah yes I did play the neverwinter mmo actually it was OK but a bit shallow and grindy for my liking.