Jump to content

Lord Paul

Members
  • Posts

    1527
  • Joined

  • Last visited

Everything posted by Lord Paul

  1. Working fine for me running FF 14. Have you tried different browser, running your browser in safe mode, checking add on/plugin compatibility?
  2. The issue with that is that your advice is subjective to your own personal idea of fun.
  3. Yep, Paul Ryan got the nod from Romney. Story. Will be interesting to see what campaigns come out of Obama camp now.
  4. [spoiler=longish]'The purpose of this UDF is to determine if there are unallowable errors in the range numbers 'of a single street segment. For the purposes of routing, there can only be odd numbers '(not inlcuding 0, because this is considered as a null value since <null> isn't a valid integer) 'on the "odd/left" side and even numbers of the "even/right" side of the street. Also, the starting range 'number must be lower than the ending range number on both sides. All of these possibilites '(of which there are actually 256--in practice, there are few null values though) are checked by this. '---- 'in order for this UDF to work, the data must be ordered in a certain way 'there needs to be 5 columns in the following order: 'Unique object identifier, starting range on the "left/odd", ending range on the "left/odd", 'starting range on the "right/even", ending range on the "right/even" Function RANGE_CHECK(FRADDL As Double, TOADDL As Double, FRADDR As Double, TOADDR As Double) As String 'FRADDL is the starting odd range number (FRom ADDress Left) 'TOADDL is the ending odd range number (To ADDress Left) 'FRADDR is the starting even range number (FRom ADDress Right) 'TOADDR is the ending even range number (To ADDress Right) If (FRADDL > TOADDL Or FRADDR > TOADDR) Then RANGE_CHECK = "wrong" 'checks for the starting range to be higher than the ending range ElseIf (WorksheetFunction.IsEven(FRADDR) = False Or WorksheetFunction.IsEven(TOADDR) = False) Then RANGE_CHECK = "wrong" 'checks for odd values on even side ElseIf (FRADDL = 0 And TOADDL = 0) Then RANGE_CHECK = "correct" 'checks for 0 on odd side, and the range is good ElseIf (FRADDL = 0 And WorksheetFunction.IsOdd(TOADDL) = False) Then RANGE_CHECK = "wrong" 'checks for instances of 0 and even on odd side ElseIf (WorksheetFunction.IsOdd(TOADDL) = False) Then RANGE_CHECK = "wrong" 'checks for even values on odd side, starting value ElseIf (FRADDL <> 0 And WorksheetFunction.IsOdd(FRADDL) = False) Then RANGE_CHECK = "wrong" 'checks for rare instances of non 0 and even on odd side Else: RANGE_CHECK = "correct" 'if all checks fail, the range is good End If End Function A pain in the ass to read without indentation and colors. Wish it would keep that formatting when I copy pasted it.
  5. What do you mean? It's a new IPB feature. Basically if you get a warning and then go to post, it doesn't let you post again until you acknowledge your warning (read it and press some sort of "I acknowledge" button). Okay thanks :razz: It's awesome for us. There are no issues with users claiming that they never read their warning message and continued posting in the same manner, not knowing that they were breaking the rules. The warning system as a whole makes our job more efficient and better for the users as all the information is in one place. Great stuff. :thumbup:
  6. [item=43] vs. [item=44] 100 vs. 100 So yes, they are equal.
  7. Depends on what you are fighting. I wouldn't want to use black knives (or ranging at all for that matter) on steels or irons.
  8. Appealing to morality in a video game is just... ehhh
  9. I have the G400 mouse and it's a piece of cake to bind the buttons. I just edit the button and choose 'shortcut'. You can either specify an executable or a website directly. Presumably it's pretty much the same for the keyboard with "Logitech Gaming Software." If you don't want to use that, you can always use AHK, which is also very easy.
  10. That's how my ex and I got started. My friend and I were in her room trolling her and quasi writing her poetry paper at around 1:30. We then called it a night, so I half jokingly invited her up to my room because we both had school to work on (I lied.. I didn't). We ended up chatting from 2-4:30. :D Great girl. Shame she decided that she never wanted to convert. We should still be good friends in the Fall. Currently, I'm trying to hook up with another girl from school, but apparently she did not like that I "prank called" her when she was doing a telethon for cerebral palsy. I actually was completely legit and even whipped out my credit card. I wasn't even trolling her.. just being really mysterious. hehe So I'll either just overwhelm her some more or back the [bleep] off until school starts in 2.5 weeks.
  11. Welcome to Tip.It! :smile: Hopefully your poor underwhelmed heart will now suffer from ventricular hypertrophy, as we rush to fill the void that once was, but will be no longer.
  12. Sad that I dropped this link in Skype and was double ninja'd. :P Forums decided to crap out on me as soon as I hit post. Based on the (almost) same version over there, I'm impressed. Good luck!
  13. Hiyo, Matt. Welcome to Zybez! :smile: Good to see that you live on Earth and not some other plane of existence.
  14. Just because they are "under no requirement to conduct background checks on purchasers or maintain records of sale" ,doesn't mean that that the majority of gun shows don't require it. For an individual that doesn't live in the US, you need a more substantial argument to justify your first sentence. For that matter, what do Wisconsin's laws have to do with this? Anyone could just as easily obtain any number of guns legally and bring them into another state legally. What's from stopping someone from doing this in the state with the strictest gun laws?
  15. Welcome to Tip.It! :smile: Nice stats. Define "a while". :P
  16. Oh, sorry, I didn't think it would cause trouble. It's not causing any trouble at all, really. It was just a reminder.
  17. I'm reading the 1000 page thriller, Excel 2010 Bible. Is it sad that I can't put it down? I'm already 200 pages in and boy, I feel like a kid in a candy shop. Definitely reading this from cover to cover, even though it's mostly a reference book haha. :geek: I thought I was pretty well versed on Excel, but it's very exciting to learn a few basics that will be very useful for work and just leisure editing. Yes, I play around in Excel as a hobby. I have around another 1,500 pages after this one as well on more Excel stuff. I look forward to diving into VBA. /nerd moment As for the last "real" book that I've read, I have no clue. Probably something from the Inheritance quadrilogy over a year ago. :sad:
  18. I came here to suggest getting an SSD, but you already have that covered. =D> I'm not very well versed on the finer points, but that seems to be quite good so far with the choices you have left.
  19. Clever trick to get views on your thread. The only reason I took a look at it was because I was expecting a phishing link. ;) Be that as it may, I've edited your title since - for obvious reasons - we can't allow threads to have misleading titles. Feel free to change it to whatever you want as I just put in the generic; just make sure that it actually reflects your OP. PM me if you have some questions. Welcome to Tip.It! :smile:
  20. I don't even work on the Crew related stuff, but it still means a lot to hear you say that. I'll be dropping this link to them. Welcome to Tip.It! :smile:
  21. Got double ninja'd but still here
  22. Will our answers be the basis of an upcoming Times? Personally, the RAPTOR. But out of your choices, Reldo for sure.
  23. It worked for me. Damn handy, hmm.. Oh, you edited in that you got it. Good, good.
  24. I wasn't exactly going to put it in the OP, Jer. :razz: Image is from the 1964 World Fair.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.