Lurker > PiOverlord

LurkerFAQs, Active DB, DB1, DB2, DB3, DB4, Database 5 ( 01.01.2019-12.31.2019 ), DB6, DB7, DB8, DB9, DB10, DB11, DB12, Clear
Board List
Page List: 1 ... 44, 45, 46, 47, 48, 49, 50
TopicI am working on a project and I have no zero idea how to even get started.
PiOverlord
05/16/19 3:57:25 AM
#10
totalnerdken posted...
PiOverlord posted...
totalnerdken posted...
PiOverlord posted...
ArchiePeck posted...
Well, what is it you are starting with and what is it you are trying to end up with?

I am given these three files related to securities: HTM, AFS, TS, and FVTNI. I have to recognize the unrealized gains/losses, and the ending balances. I have to include the Pivot Table results to prepare journal entries. It doesn't seem like it should be hard, I just need a slight nudge in the right direction.

That honestly just doesn't seem that hard. Can't you just input the values then create a pivot table?

I was thinking that, I'm just wondering why I need to use VLOOKUP.

I should just be able to add up the entirety of the four securities separately, and multiply by the prices and amounts, row by row; just will have to remember that formula for Excel. Then do the same for the February and March prices. It says I need to use VLOOKUP to merge the data, though, but I don't see why to be honest.

Well, you'd use VLookup on another sheet if I'm correct. So if they want you to summarize the data in a nice package on a separate sheet, Vlookup would be good for that.

But I don't recall exactly what Vlookup does, so I might be wrong.

Okay, I think I might have just realized what to do, but I don't know for sure, I am about to see.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI am working on a project and I have no zero idea how to even get started.
PiOverlord
05/16/19 3:49:54 AM
#8
totalnerdken posted...
PiOverlord posted...
ArchiePeck posted...
Well, what is it you are starting with and what is it you are trying to end up with?

I am given these three files related to securities: HTM, AFS, TS, and FVTNI. I have to recognize the unrealized gains/losses, and the ending balances. I have to include the Pivot Table results to prepare journal entries. It doesn't seem like it should be hard, I just need a slight nudge in the right direction.

That honestly just doesn't seem that hard. Can't you just input the values then create a pivot table?

I was thinking that, I'm just wondering why I need to use VLOOKUP.

I should just be able to add up the entirety of the four securities separately, and multiply by the prices and amounts, row by row; just will have to remember that formula for Excel. Then do the same for the February and March prices. It says I need to use VLOOKUP to merge the data, though, but I don't see why to be honest.

Other than HTM securities, wouldn't use FV for that.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI am working on a project and I have no zero idea how to even get started.
PiOverlord
05/16/19 3:45:35 AM
#5
ArchiePeck posted...
Well, what is it you are starting with and what is it you are trying to end up with?

I am given these three files related to securities: HTM, AFS, TS, and FVTNI. I have to recognize the unrealized gains/losses, and the ending balances. I have to include the Pivot Table results to prepare journal entries. It doesn't seem like it should be hard, I just need a slight nudge in the right direction.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI am working on a project and I have no zero idea how to even get started.
PiOverlord
05/16/19 3:17:13 AM
#1
Something to do with Excel: vlookup, Pivot tables; Idk.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicNew pic of me and my WAIFU fam!
PiOverlord
05/16/19 12:00:22 AM
#26
Nice picture Fam! She looks stunning.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicNHLCE playoff topic 1
PiOverlord
05/15/19 11:33:30 PM
#412
Doesn't help us now, so I would not give a fuck if they change it at that point.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicNHLCE playoff topic 1
PiOverlord
05/15/19 11:20:45 PM
#409
So dumb. That was stupid beyond stupid, the refs can suck a big one.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI will create a business empire.
PiOverlord
05/15/19 7:14:11 PM
#12
averagejoel posted...
Crono99 posted...
PiOverlord posted...
We have just announced that we are going to have to layoff the entire workforce besides top-level executives. Thank you for your cooperation.


*organizes a picket line*

*builds a functional guillotine outside TC's home*

Whoa there friends. Let's talk about this. No need to spill any red today.

modena posted...
I will call an extractor and give you inception to break up your empire.

I don't think you would be able to give me a genuine seed of thought to do so. It does have to feel natural, right?

YookaLaylee posted...
Is your business producing red suits and ties?

No, we run Bingo Halls, what would give you that idea?!?
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI will create a business empire.
PiOverlord
05/15/19 7:01:55 PM
#7
Solid Snake07 posted...
Sounds like a solid business plan

Thank you. It means a lot.

Crazyman93 posted...
This sounds like you're ripping off a TV show or movie. I've never seen such, but it sounds like you are.

If I am, then it is subconscious.

Crono99 posted...
*unionizes the workers in PiOverlord's business*

We have just announced that we are going to have to layoff the entire workforce besides top-level executives. Thank you for your cooperation.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI will create a business empire.
PiOverlord
05/15/19 6:53:22 PM
#3
Zerocide posted...
Will the CEO also be named Randy Pitchford?

... No, the only red he will wear is his clown nose and wig.

The CEO will have the same name as mine, and so will the Chairman of the Board.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI will create a business empire.
PiOverlord
05/15/19 6:45:21 PM
#1
and the top-level executives will have to wear Red Suits/Ties. We will be known as the Red Suits, and be feared by all. The CEO will wear a gold tie.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicMario Maker 2 looks amazing
PiOverlord
05/15/19 6:37:40 PM
#6
Be careful when using the vouchers, some of the games are $49.99 now.

The best bet would be to get Mario Maker and Pokemon/LM3/AC2019/any surprises/FE
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicTrump has made his position clear on gamers...
PiOverlord
05/15/19 5:32:02 PM
#24
GAMERS RISE UP!!!!

#VoteHimOut
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicBeep Bep
PiOverlord
05/15/19 2:14:30 PM
#32
Alpha218 posted...
I still dont get why Gamefaqs has that as a theme lmao

It's a beautiful theme is why. If I'm feeling a little joyful, and wanna have some fun, cotton candy is the way to go.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicA man wants you to bang his attractive wife. WYD?
PiOverlord
05/15/19 2:13:40 PM
#10
If I get to pick in this scenario which attractive wife in particular...
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
Topic''I'm only complaining so hard because I'm so passionate about the product!''
PiOverlord
05/15/19 2:11:37 PM
#14
Remember how people chanted that Mega Man was soooo disrespected by Capcom, just for the sales of MM11 to be relatively low for such a hyped up franchise. I mean, I guess it did well enough for a MM12, but still, the people on the internet made it sound like it was a blockbuster series.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicBeep Bep
PiOverlord
05/15/19 2:06:23 PM
#28
ThyCorndog posted...
who here likes cotton candy?

Cotton Candy can be pretty good. I don't ever go out of my way to eat it, but I won't refuse it if given.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicBeep Bep
PiOverlord
05/15/19 2:02:01 PM
#25
Error1355 posted...
what has happened to my beautiful topic

It was made even more beautiful.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicEurovision is getting an American adaption! American Song Contest
PiOverlord
05/15/19 2:00:28 PM
#25
Hope it is a 50 states thing. Let's go Missouri!!!
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicBeep Bep
PiOverlord
05/15/19 1:17:26 PM
#22
Cotton Candy is the best anyways.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI am going to delete this topic if no one posts in it by 11:46 AM CST
PiOverlord
05/15/19 12:38:47 PM
#1
You can't see it right now, but I think I'm blushing, and my heart is beating ever-so-slightly faster.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicMuscle spasm from freshly slaughtered animal. *warning might be disturbing*
PiOverlord
05/15/19 3:10:49 AM
#6
I think a shiver just went down my spine.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicC/D you lie about your height to mess with da manlets
PiOverlord
05/15/19 2:40:17 AM
#16
I am 5'6.5", so no bother trying to lie at that point.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicTexas and Boston are voted most SEXIEST ACCENTS as Long Island/Jersey are LAST!!
PiOverlord
05/15/19 2:07:32 AM
#50
St. Louis has just the tiniest bit of Southern flair, like a drop of spice to give it life. I got one, and I love my people.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicTexas and Boston are voted most SEXIEST ACCENTS as Long Island/Jersey are LAST!!
PiOverlord
05/15/19 12:40:31 AM
#46
pres_madagascar posted...
PiOverlord posted...
St. Louis is #1 when adjusted for big city bias.

We don't even have an accent.

Say that to our English brothers and sisters across the pond.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
Topichow do you feel about the direction the MCU took from Iron Man, where *spoilers*
PiOverlord
05/15/19 12:37:32 AM
#4
I feel like a supergenius could then just find out his real identity at that point.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicTexas and Boston are voted most SEXIEST ACCENTS as Long Island/Jersey are LAST!!
PiOverlord
05/14/19 11:52:57 PM
#41
St. Louis is #1 when adjusted for big city bias.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicWhat have you done Hershey's?!?
PiOverlord
05/14/19 11:37:14 PM
#13
This is supposed to help spark conversations?

Nah, this would end conversations... permanently
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicWhat have you done Hershey's?!?
PiOverlord
05/14/19 11:29:17 PM
#1
https://thetakeout.com/hersheys-emoji-chocolate-bar-redesign-1834748876

You. Can. Not. Do. This.

#Boycott
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicCE, I'mma gonna ask this lady out tomorrow
PiOverlord
05/14/19 5:05:17 PM
#10
Turbam posted...
PiOverlord posted...
my friend was being a cock block who decided to show up when I was trying to ask and kept moving the conversation away from the topic.

smh tbh fam
U need to defriend him

The nerve of him. He was being so damn talkative.

Now I have to spend the whole summer thinking up a new plan.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicSTUDY: kids with same-sex parents do better in school
PiOverlord
05/14/19 3:16:02 PM
#13
Is there a difference between male-male and female-female couples in how well their children do? Just curious.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicCE, I'mma gonna ask this lady out tomorrow
PiOverlord
05/14/19 3:04:24 PM
#6
She said... nothing because I never asked.

You can't get rejected if you don't ask.... actually, my friend was being a cock block who decided to show up when I was trying to ask and kept moving the conversation away from the topic. I don't think he realized it.

There's always next year.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicAfter Endgame, why didnt they.....in IW? (SPOILERS)
PiOverlord
05/14/19 12:24:10 PM
#8
Iron Man always builds suits around his past failures. He realized before that they failed because they relied on trying to pull the glove off a man much more powerful than the Avengers. This time, he took that out of the equation.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicElizabeth Warren with that subtweet at Sanders & Buttigeig *eye emoji*
PiOverlord
05/14/19 12:21:22 PM
#16
Eyeroll emoji
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI love ghetto Asian women so much.
PiOverlord
05/14/19 12:18:42 PM
#183
On a scale from 1-7, how much?!?
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicCE, I'mma gonna ask this lady out tomorrow
PiOverlord
05/14/19 2:18:44 AM
#1
Or well, later today technically.

Give me a pep talk. Tell me why she will say yes!!!
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicAre you there, sex havers? It's me, GB
PiOverlord
05/14/19 12:44:05 AM
#53
Boooooooooooooooooooooooooooooooo
Ooooooooooooooooooooooooooooooooo
Ooooooooooowo
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicWhat card did you get when watching Detective Pikachu?
PiOverlord
05/13/19 8:56:59 PM
#3
I'm keeping mine sealed forever, so I can sell it for a few thousand later.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI missed the bus, and now I must wait an hour.
PiOverlord
05/13/19 8:52:59 PM
#9
Lordgold666 posted...
Prestoff posted...
Subway sells popcorn?

^ that

They really do this?

If i make an ass of myself during my next visit, im holding the whole board accountable

Not all Subways, again, this was a Walmart Subway.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI missed the bus, and now I must wait an hour.
PiOverlord
05/13/19 8:46:51 PM
#6
Prestoff posted...
Subway sells popcorn?

This one in a Walmart did, so I had to get it. I lost a precious hour of my time to do so... maybe if the lady wasn't so slow making the subs.... Guy just came by and grabbed something out of the trash can, wtf.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI missed the bus, and now I must wait an hour.
PiOverlord
05/13/19 8:40:23 PM
#1
Saw Subway had popcorn for a dollar and I just had to get it.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicDamn, the Fam is already cancelled...
PiOverlord
05/13/19 7:32:19 PM
#15
Gafemage posted...
SomeLikeItHoth posted...
I demand it be brought back!

---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicWaking a Sleeping Giant The Tobacco Industrys Response to Polonium-210 issue
PiOverlord
05/13/19 7:27:37 PM
#8
I have no idea why, but lately I have been desiring the fresh smell of cigarette smoke.

I have never smoked, nor want to but lately it's been in the back of my mind, and I have no idea why.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicRemember when you were pissed the drinking age was so high >_>
PiOverlord
05/13/19 7:25:11 PM
#14
I am turning 21 in 1 month, 2 weeks, and 6 days from now.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicAmericans, would you vote in 35 or more years, for a British Royal?
PiOverlord
05/13/19 2:32:23 PM
#9
The royal family has no place in modern times, and I'm pretty sure he would not be allowed to keep his title anyways.

Yeah, they would have to give up their title of nobility: https://en.wikipedia.org/wiki/Title_of_Nobility_Clause
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
Topicliterally a new Game of Thrones episode tonight and no topic about it *spoilers*
PiOverlord
05/12/19 11:56:49 PM
#340
It's sounding like I made the right decision to never get into GoT.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicHow do you personally define "human life"?
PiOverlord
05/12/19 11:25:58 PM
#19
I believe at conception. Any other point feels arbitrary.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicI'm going to do something bolder than anything I've ever done in my life.
PiOverlord
05/12/19 11:17:54 PM
#1
73/80

Is that the right word to describe it?!?
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
TopicWow, my crotch has never felt better.
PiOverlord
05/12/19 11:04:45 PM
#5
DarkieDLXVI posted...
But did you shave balls? Its heaven sent

Somewhat, definitely feels shaved to an extent, but I won't lie, I get a little nervous around there.
---
Number of legendary 500 post topics: 28, 500th posts: 25; PiO ATTN: 5
RotM wins 1, LETTEN MY ARROW FLYEN TRUE
Board List
Page List: 1 ... 44, 45, 46, 47, 48, 49, 50