Welcome to the Lounge

David O'Neil3-Jul-17 11:51

David O'Neil

3-Jul-17 11:51

Does this help? Time Value of Money Calculator

It Is The Absolute Verifiable Truth & Proven Fact
That Your Belly-Button Signature Ties
To Viviparous Mama.

Jeremy Falcon3-Jul-17 11:55

3-Jul-17 11:55

Nope, not really after time value for this. This is more along the lines of forecasting taxes. Not really compounded interest, etc.

So far I've come up with stuff like 0.8 = ($100 / ($100 * 1.25)) to get a ratio, but something doesn't seem right to have a 20% tax on more money. So I know I'm doing it wrong. I blame old age. Laugh | :laugh:

Jeremy Falcon

David O'Neil3-Jul-17 12:07

David O'Neil

3-Jul-17 12:07

Sorry, didn't understand the phrasing of your question correctly. But if you wanted to know the rate that you would need to make the following year to have $100 again at the end without any additions from the $75, it is about 29.5% compounded monthly. Poke tongue | ;-P

(This site works: Money calculator: Present and future values - MSN Money. The previous one doesn't!)

It Is The Absolute Verifiable Truth & Proven Fact
That Your Belly-Button Signature Ties
To Viviparous Mama.

Jeremy Falcon3-Jul-17 12:08

3-Jul-17 12:08

Oh snap.

Jeremy Falcon

Richard Deeming3-Jul-17 11:56

Richard Deeming

3-Jul-17 11:56

Given a new amount, A, and a new rate, R:

A (1 - R) = 100
A = 100 / (1 - R)
R = 1 - 100 / A

For example, R = 20% gives A = 125.
R = 25% gives A = 133.33333...

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Jeremy Falcon3-Jul-17 12:00

3-Jul-17 12:00

Dude... thank you! Why did I not think of this? Have a virtual Beer | [beer]

on me.

Jeremy Falcon

Munchies_Matt3-Jul-17 18:45

Munchies_Matt

3-Jul-17 18:45

he wants 100, he keeps .75 of his earnings.

SO its 100/.75

Pretty simple and definitely not guru stuff. Smile | :)

Jeremy Falcon3-Jul-17 19:21

3-Jul-17 19:21

Thanks for the elegant answer. But be nice...

Jeremy Falcon

Munchies_Matt3-Jul-17 22:25

Munchies_Matt

3-Jul-17 22:25

SO think, 'what is 100 three quarters of'

Means you need to break 100 into 3 and add that much to 100.

Just another way of visualising it.

Jeremy Falcon4-Jul-17 5:53

4-Jul-17 5:53

It's an awesome way of visualizing it. Simple and it works. Thumbs Up | :thumbsup:

Jeremy Falcon

Munchies_Matt4-Jul-17 8:58

Munchies_Matt

4-Jul-17 8:58

As an ex mech-aero engineer I was always taught to guestimate the result, then when you do the exact figures you can check if you are in the ball park. If not, your figures could be wrong, so just getting a feel for the problem, painting a picture in your head, is a good place to start. Smile | :)

Jeremy Falcon3-Jul-17 12:02

3-Jul-17 12:02

I think know what threw me off. Given A = 133.33 and we use a rate of 25% to get the $100 again, I know that the rate of 25% will actually change with a higher amount, say it's now 27% because of the extra $33.33. But I'd still like to get the original $100.

Don't you just love taxes? Laugh | :laugh:

Jeremy Falcon

How to get support for Skype without going through Microsoft Live?

Fueled By Decaff5-Jul-17 1:58

Fueled By Decaff

5-Jul-17 1:58

I multiply to get money after tax and divide to get money required before tax. For example:

25% tax rate = 75% in pocket.
75% = 0.75
£100 * 0.75 = £75
£100 / 0.75 = £133.33

swampwiz3-Jul-17 7:14

swampwiz

3-Jul-17 7:14

Here's my situation. I have Skype, and in addition to the normal window, I get this other stupid window that says "Sorry, we didn't recognize your sign-in details. Pleas check your Skype Name and password, then try again." But that doesn't matter because I am signed in with no problem and can make calls. (I only make toll-free calls to the USA, so I don't need to put up any cash.) And I can't close this stupid window.

So I go to Skype help, and through a bunch of screens it tells me that I need to get a Microsoft account, so I set one up, and it sends me an E-mail confirmation, which I do. So then I get to a Virtual agent window, and after a few back & forth messages, it gets me to Microsoft support, where it logs me in, but then wants a mobile phone number to send me an SMS. The problem is that I don't have such a mobile phone number (I use Magicjack), and I see no way to get around this other than to click around in which case I go in a giant loop and get back to the same damn screen asking me for a mobile phone. Mad | :mad:

I don't how to contact Microsoft without getting past this step.

UPDATE: I dug around a bit and came across a phone number for Microsoft assistance for disabled folks, so I guess I did the equivalent of parking in a handicapped zone and called. I learned that going through the options, if I choose the dropdown list option for account problems, I get the option of doing chat.

modified 3-Jul-17 14:00pm.

Finally

#realJSOP3-Jul-17 6:34

#realJSOP

3-Jul-17 6:34

I got to write some actual code today - whipped up a quick WPF app that discovers available AD groups, finds users in the selected group, and then finds all groups in which the select user is a member.

I had to do this because we wanted to prune unnecessary users from the AD groups within our sphere of influence, and our IT department refuses to provide the info we needed to do so.

In any case, it was good to get back into actual development instead of having to do Qlikview crap...

EDIT =============================================

My boss sent an email requesting removal of certain individuals from our groups this morning. She just got an phone call from an irate IT guy asking "how in the world" we got the names of the users in our groups. She laughed somewhat maniacally, and hung up on them.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

modified 3-Jul-17 12:46pm.

lopatir3-Jul-17 7:22

lopatir

3-Jul-17 7:22

sounds like your company 'organisation' isn't. (IT is a service dept., they shouldn't have refused the earlier request.)

Sin tack
the any key okay

#realJSOP3-Jul-17 7:30

#realJSOP

3-Jul-17 7:30

I have yet to encounter an IT department that sees itself as being in a service role.

Our database group has a dozen SAs, but absolutely NO database developers. That means it's up to the various customers to craft SQL jobs (and their subordinate SSIS packages), or stored procs, or UDFs.

I stared open-mouthed at the head of the department when he stated this. I think I'm the only one in the organization that knows how to develop a SSIS package.

Foothill3-Jul-17 7:56

Foothill

3-Jul-17 7:56

John Simmons / outlaw programmer wrote:
She laughed somewhat maniacally, and hung up on them.

I like your manager already.

I find that some people in IT departments like the power of control and get upset when they get circumvented by developers. They don't realized that all the fun little tools that they get to play were, in fact, created by developers. For sh*ts and giggles, you should dig into Windows Management Instrumentation classes so you can read back a list of programs running on the Admin's workstation*** along with a whole cornucopia of information they like to think is locked down.

*** if they have RPC enabled, which most users do

if (Object.DividedByZero == true) { Universe.Implode(); }
Meus ratio ex fortis machina. Simplicitatis de formae ac munus. -Foothill, 2016

#realJSOP3-Jul-17 8:01

#realJSOP

3-Jul-17 8:01

Last time I poked the bear, I got "officially" reprimanded. I think it went on my permanent record (the one they always told you about in elementary school). I have zero f*cks to give.

Mycroft Holmes3-Jul-17 13:13

Mycroft Holmes

3-Jul-17 13:13

And now there is some IT weanie burrowing into AD doco trying to find a way to shut you down... again.

I find having to circumventing their little tyrannies really irritating so I now escalate the the issue.

My standard response to any request for a solution is the requester is to get access to the source data before we accept a requirement. I have a project that has been waiting 20 months for IT to supply the data for it.

Never underestimate the power of human stupidity
RAH

PIEBALDconsult3-Jul-17 14:07

PIEBALDconsult

3-Jul-17 14:07

I have an SSIS package that contains a C# Script to get all users and groups from Active directory and saves it to SQL Server for integration with other data.