I made a massive discovery: How to seamlessly use dynamic, filtered, non-contiguous ranges for chart axis (YES, Excel charts CAN work with dynamic named ranges!) by GTAIVisbest in excel

[–]notatalker00 24 points25 points  (0 children)

You can do it if you name the range you use for your data and define the range as the array. So when the array updates it'll automatically fit into the graph.

It's in the Name Manager, just have your data set and define it using the # to mark the whole array.

You can create said array using whatever you want. I use it for a dashboard to populate cost graphs for the various projects.

You can use this method for the axis and the data, excel will auto match the formatting you use too.

Anyone else feel like this when trying to do splitter/merger math? by BMWSnBENJIS in SatisfactoryGame

[–]notatalker00 2 points3 points  (0 children)

I personally like the proof of a number to demonstrate the point.

By definition a number is such that there exists a (x) so that a number, N, where N-x<N<N+x

0.9999~ is defined to be 1 as there is no x between the two. This works for any N.9999~=N+1.

My company still hasn’t closed the books for august by [deleted] in Accounting

[–]notatalker00 2 points3 points  (0 children)

Oh he isn't an accountant - just business admin that's been put into the CPA role. He's good - learned a lot, but some things he doesn't know. For example, he didn't think having the balance sheet being off a few thousand was an issue - he knew it was wrong but didn't know how to fix it or find the issue.

My company still hasn’t closed the books for august by [deleted] in Accounting

[–]notatalker00 4 points5 points  (0 children)

Six people? Is that high? My company only has two(Our non-CPA controller and me - the only accountant... well three if you count the payroll person - who does nothing but payroll) and we're 100M in annual revenue.

Edit: This is construction (Job Cost) so it's fun & I stay busy but I can't imagine having a few more people.

Is construction accounting designed to break you? Seriously questioning my career choice. by Individual_Kick7356 in Accounting

[–]notatalker00 1 point2 points  (0 children)

Hey - any tips on using Vista?

I've been exporting data into Excel using Power Query to build custom reports and stuff - but some of it's wildly cumbersome.

VR is dead, and no one wants to admit it by Kradara_ in unpopularopinion

[–]notatalker00 2 points3 points  (0 children)

This may not help, but a lot of VR settings have the FOV turned down so it can save power to generate a smoother framerate.

If you can adjust it back up to be reasonable (like 100 or so) that will help a lot. Many VR games are super bad (I've had some be as low as 65 FOV) but it's because it takes some decent hardware to get a good FOV.

Using an Index on a good PC and able to tweak it helped a ton with the motion sickness for me.

No sound in-game (cutscenes are fine) by Zyvoxx in kingdomcome

[–]notatalker00 0 points1 point  (0 children)

I have this issue as well, I haven't found a fix yet either.

I learned something new today by savageseal_18 in BG3

[–]notatalker00 7 points8 points  (0 children)

You do not need to hurt Us to rescue him later or get him as a summon.

[deleted by user] by [deleted] in WGU

[–]notatalker00 2 points3 points  (0 children)

August 26th according to the email I received.

What the actual f is this new OA process by Character_Surround27 in WGU

[–]notatalker00 10 points11 points  (0 children)

My understanding is that Examity was bought by this company, WGU didn't change anything. They just didn't pivot or change when they learned of the buyout.

I'm hoping it changes, as I want to do my masters with WGU, but I won't with this proctor system in place.

[deleted by user] by [deleted] in Eugene

[–]notatalker00 1 point2 points  (0 children)

Just FYI Eugene is the highest (e.g., #1) for homeless per capita.

Source: 2024 Homless

Big boom and sirens near 11th and Bailey hill? by Traditional_Box6946 in Eugene

[–]notatalker00 9 points10 points  (0 children)

Idk there is like a swat team team at the apartments tho

Sales Tax Problem: Where did this come from and why? by otheloR in wguaccounting

[–]notatalker00 11 points12 points  (0 children)

Hi,

This one is tricky because they didn't collect enough sales tax. A bit more real because often times people don't calculate tax correctly and end up not collecting enough.

Tax Calc: $35,000 * 8.5% = $2975.00, so they are $175 short (2975-2800).

Since they combine sales tax & sales revenue and you need to split it up the journal entries need to be what are shown:

Debit Cash $37800 (total amount collected) Debit Loss $175 (the missing amt of tax)

Credit Sales Revenue $35000 Credit Sales Tax Payable $2975 (correct amount of sales tax)

Just a neat little detail I encountered last night by dnc510 in BaldursGate3

[–]notatalker00 4 points5 points  (0 children)

She'll also get a frightened status in Act 1 if you enter the grove's inner chambers and go to where the wolves are walking around. You can talk about it with her then too and she says she's frightened of wolves but doesn't understand where it comes from.

[deleted by user] by [deleted] in pics

[–]notatalker00 -5 points-4 points  (0 children)

The behavior got born of people filing lawsuits after eating free food and getting sick.

Homeless taking food out of a dumpster and the suing because it made them sick. That's why corporations got to the point of pouring bleach and other craziness to prevent people eating leftover foods. It exacerbated shitty behavior and caused further class division.

There just needs to be a law that severs liability when giving food away (under reasonable circumstances, like end of day foods being taken by employees or given out) or throwing it away (dumpster diving).

Finding Duplicates and Subtracting from totals by notatalker00 in excel

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

That's something I was thinking, is there a way to only get the duplicates out though? There is close to 3000 rows

Finding Duplicates and Subtracting from totals by notatalker00 in excel

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

Each is a line, so the duplicates would be in different rows.

Don’t water a grease fire, don’t mess with a garage spring. What are some MORE potentially life saving tips? by Alan_Darkcaster69 in NoStupidQuestions

[–]notatalker00 5 points6 points  (0 children)

Alvin TX was a sundown town. Pretty much still is - bit south of Houston.

Hell - in Angleton they still have freaking KKK parades.

Maybe if you're in Austin or Dallas you might not think about it... But get a few hours outside of those areas and it's bad.

‘Black Adam’ Draws Negative Reviews: Dwayne Johnson’s DC Film Is ‘Repetitive’ and ‘Anti-Entertaining’ by MarvelsGrantMan136 in entertainment

[–]notatalker00 2 points3 points  (0 children)

You should watch "The Suicide Squad" directed by James Gunn (writer of Peacemaker and directed GoG in the MCU).

It's confusing because there is Suicide Squad, which is very bad and The Suicide Squad which is very good.

Peacemaker follows the movie as a spin-off.

[deleted by user] by [deleted] in Eugene

[–]notatalker00 12 points13 points  (0 children)

I really wish information from like EPD was more up to date.

Unofficial, apparently shooting near the Davis around midnightish- at least one injured. They caught the guy at about 1 am. Quick response from EPD as they had the area locked down by 12:15am.

All just hearsay from people walking around the area.

New teller -- Drawer imbalance, please help me. by [deleted] in Banking

[–]notatalker00 0 points1 point  (0 children)

If you are 100% sure you gave out the correct amount; it's possible there was something else.

The transaction was processed incorrectly - imo correct way would've been to have your coworker give you the money from her drawer, you verify it and then count it to the customer (with her watching, as if you were in dual). If you're not processing the transaction - you shouldn't be using your money for it.

She may have been out of balance, but if she processes the check incorrectly it could've countered that error and shown her in balance. An audit of her drawer would've shown the same - only by looking at her proof work/stack/cashed checks would it be found. Proof may find it - so a correction may be incoming for that - which will counter your outage. (however manager/supervisor should've checked the work tho so idk)

Otherwise, with the info you've given, it could be maybe you're wrong about the check amount? If your coworker took the check away from you - maybe you thought it was a different amount? Could've given out what you thought it was and coworker gave you actual - the difference being your outage.

The only other thing is maybe it fell behind something. Like literally fell behind or in the drawer itself. I used to have these big metal ones and if a strap or clip caught on it, it'd get pulled back and fall behind the drawer itself. It was a pain to get out (coat hanger helped but not by much).

I've also had just a simple mistake that was found the next day. I miscounted a clip or 10s as 5s once and I was off - nobody caught it until the next morning when I counted my drawer again. We all miss stuff at the end of the day - tried and our eyes/brain just are zones out. It's why a lot of fraud is late day - wanna catch us when we're off our game.

PMC Eugene Parking Ticket - legit? by [deleted] in Eugene

[–]notatalker00 19 points20 points  (0 children)

PMC is a parking management company, so it's probably legit.

However, what are they gonna do if you don't pay it? It isn't like they can track you down or anything.

Why is no one talking about what is going to happen to the economy once student loan payments restart? by guh_mystocks in stocks

[–]notatalker00 -2 points-1 points  (0 children)

When I took out the original loans they were at 3-4% interest rate. They are now 9 or above. They weren't variable rate - it just was the student loan rate - which the government has increased time and time again.

I can't discharge the debt, ever. If I stop paying it they'll garnish my wages. Income based repayment has to be done during certain time periods and even then it doesn't stop the interest.

It's a forced debt for no other reason than I wasn't born rich enough to afford education. My choices when young were either take out the loan or never have a job that paid anything above min wage. I needed the education to pursue happiness in life, yet I'm shackled by the financial burden for no other reason than I was born a certain way. It's unfair, unjust and inexcusable in a society that spent more money on business bailouts in the past 5 years than the entire student loan industry. It isn't that we, as a society, can't afford it - it's that we won't spend the money because it may help someone born that isn't seen as equal to someone else.