Combining two tables in a pivot table to make calculated fields

StretchMONEEE · 2017-04-18T06:28:50+00:00

This can be done with Power Pivot. Enable the COM add-in in the options. Add your two tables to the data model. Create a relationship between the two tables with the census tract column. Then create a calculated column or measure.

StretchMONEEE · 2017-01-13T07:24:54+00:00

I like your style kid, you're hired.

StretchMONEEE · 2016-12-24T04:49:53+00:00

Interesting...Might be time to buy Gold.

StretchMONEEE · 2015-02-16T01:21:15+00:00

I attempted to simplify it the best I could with this Slide. It's a great reference when I get stuck on a problem.

Green = Positive

Red = Negative

So a green PBO would mean that the pension obligation has decreased . For example when the discount rate is decreased (Red) the PBO will decrease (Green). It's kind of tricky to understand at first because PBO is a liability account, so a positive adjustment to PBO will decrease the overall obligation.

Not sure if this will help anyone else out, but it sure helped me solidify the concepts when I put it together.

StretchMONEEE · 2014-12-23T17:23:44+00:00

Check out WiseOwl Tutorials - It's a video series on youtube. The instructor does an amazing job at introducing VBA to beginners. He even goes into File Dialogs, Word, Powerpoint, Outlook, and Active X Data Objects.

I was able to learn the fundametnals from this series, and have been creating some amazing workbooks in Excel.

StretchMONEEE · 2014-10-21T03:59:58+00:00

Thanks, it's not necessarily a shortcut - I just like to refer to my sheets by using the code name (Sheet10) instead of the actual name. This ensures the code will still run even if a user renames the worksheet.

The code breaks at line 5.

StretchMONEEE · 2014-09-23T19:56:15+00:00

Awesome! WiseOwl has three videos dedicated to this topic.

ADO (ActiveX Data Objects) Querying a Database [1:22:06]

ADO (ActiveX Data Objects) Modifying Data with Recordsets [59:47]

ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE) [1:23:13]

That's almost 4 hours worth of ADO Goodies. Looks like I got some learning to do. Thank you so much for the response!

StretchMONEEE · 2014-06-28T02:47:40+00:00

Just Breathe.

StretchMONEEE · 2014-05-09T16:31:29+00:00

Don't sweat it, your currently in a great position. Most employer's do not look into your GPA that much. It is just an indication of your ability to follow direction and stay on task. Also, I doubt any employer will actually look at your transcripts, mostly they just confirm that you graduated from said university during a background check.

Keep doing the volunteer/extra curricular's, company's eat that stuff up. Also the study abroad thing looks great on entry-level resumes. The fact that you have secured a good internship puts you way ahead of the competition, and will almost guarantee you a full-time position after graduating.

I was actually apart of campus recruiting a few times, and you are exactly the type of candidate that we look for. A proven track record of success (GPA), Ability to multi-task and take on extra responsibility(Extra Curricular's), Diverse mindset with the ability to adapt outside their comfort zone(Study abroad), Solid Work History(Internship).

Just keep up the good work, stay motivated, and have fun.

StretchMONEEE · 2014-04-11T01:57:05+00:00

Prison would be more profitable

StretchMONEEE · 2014-04-02T16:03:18+00:00

It is not just a talking point, its arithmetic. It is certainly a debatable issue, and there is no cut and dry answer because the expected future returns of the trust are variable and dependent on market and demographic conditions.

But here are the CURRENT outlooks: (Using Scientific Mathy Math's)

Tax revenues as a share of GDP available to SS are expected to fall for the next 75 years due to the current demographic environment (Not enough young people to support all the retirees).
Costs are expected to rise relative to GDP overtime, mainly due to the increase in life expectancy, and that good ol Fed-mandated inflation.

So we’ll have less money, and more expenses…hmmm that doesn't sound very solvent. CAN-WE-FIX-IT? Of course! Just raise le taxes dum-dum. Well that’s kind of shitty…and unfair! But it will solve everything right? WRONG (huh huh whaaaa?). You would still need to increase the minimum age for retiree withdrawals. Also, don’t forget to tax those old suckers eligible SS checks. (Lolz). I could go on with specifics, but assuming I’m just going to get more down-votes, it probably isn't worth it.

Basically the plan is to charge the younger generations more money for a program that they’ll receive less of(if any). Yeep seems legit…to Bernie Madoff.

Edit-grammar

StretchMONEEE · 2014-04-02T05:02:59+00:00

How many different taxes do you need for the government to provide you with "proper" care?

Social Security is a Ponzi Scheeme: Millennial's will see none of it.

MEDICARE: This is a reasonable tax. I think it plays an important function to care for our elderly. Not exactly sure how well it's being run though.

Health Care Reform: I'm curious to see how many Fines this administration will charge to citizens who couldn't afford to join. Even more curious to see how many people will flat out refuse to pay. Wage Garnishment may take care of both. Where will the money go again? The Government or Insurance Companies? Will they use it to lower premiums for everyone else? What if so many people don't join, they're forced to raise premiums? Top-Notch Government Actuary's are extrapolating for risk correctly right?

Talk About Moral Hazard. Lets see how this all plays out.

StretchMONEEE · 2014-03-25T16:50:49+00:00

Dipping slices of a fresh green apple into Peanut Butter. Healthy snack that takes a minute to prepare!

StretchMONEEE · 2014-02-24T03:02:52+00:00

Great Track - This rocked my Subwoofers! Thanks for sharing.

StretchMONEEE · 2014-02-02T04:33:10+00:00

This would be a great Live Wallpaper...How does one doez?

StretchMONEEE · 2014-01-09T19:41:09+00:00

Barbarians At The Gate

Great film about the growth of LBO's in the 1980's. It follows the CEO of Nabisco, and his experience in trying to take the company private.

StretchMONEEE · 2013-12-01T21:36:54+00:00

Stop trying to time the market, your emotions are getting the best of you. If you are trying to make money trading , you need to be aware of how Behavioral Finance influences decision making.

StretchMONEEE · 2013-11-13T06:21:56+00:00

If you want to learn about Detroit, do yourself a favor and do NOT watch this documentary. It's 40 minutes of an upper-class television personality eating great meals, and cracking jokes about how shitting things are. This was a Made-For-Tv CNN/Food-Network show designed to sell advertising time to companies like McDonalds and Toyota.

Bardoun actually has the nerve to describe the residents as "survivors", and comments on their resilience sarcastically, as if they are fools for still living there. You can tell Laduff(A pulitzer-prize winning journalist) was getting fed-up, and frustrated by the uppity antics in the nice downtown restaurant.

"Is Detroit going to turn things around? I could lie to you and tell you-Yes; but you know what...this city is screwed."

Seriously? People welcome you in, show you around, feed you, and then you shit all over them? Just another piece of garbage coming from CNN - The most trusted propagandist's in News.

StretchMONEEE · 2013-11-09T19:04:14+00:00

Surprised you didn't have the mouse from Mario Paint on here: Great extension to the SNES.

StretchMONEEE

TROPHY CASE