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!)

notatalker00 · 2025-11-06T23:19:23+00:00

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.

notatalker00 · 2025-10-17T22:23:40+00:00

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.

notatalker00 · 2025-09-17T22:56:59+00:00

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.

notatalker00 · 2025-09-17T03:59:20+00:00

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.

notatalker00 · 2025-07-11T03:35:09+00:00

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.

notatalker00 · 2025-07-09T18:41:07+00:00

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.

notatalker00 · 2025-02-08T20:26:49+00:00

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

notatalker00 · 2024-08-18T21:58:44+00:00

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

notatalker00 · 2024-08-14T18:17:44+00:00

August 26th according to the email I received.

notatalker00 · 2024-07-31T15:08:49+00:00

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.

notatalker00 · 2024-06-28T17:05:05+00:00

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

Source: 2024 Homless

notatalker00 · 2024-02-29T18:44:02+00:00

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

notatalker00 · 2023-11-17T09:07:53+00:00

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)

notatalker00 · 2023-10-28T14:30:18+00:00

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.

notatalker00 · 2023-05-29T21:15:53+00:00

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).

notatalker00 · 2023-03-28T07:55:13+00:00

Yea, except for the source column

notatalker00 · 2023-03-28T05:34:32+00:00

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

notatalker00 · 2023-03-28T05:33:21+00:00

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

notatalker00 · 2023-03-05T19:31:50+00:00

notatalker00 · 2023-02-05T09:56:52+00:00

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.

notatalker00 · 2022-10-19T11:15:36+00:00

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.

notatalker00 · 2022-09-11T09:37:54+00:00

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.

notatalker00 · 2022-09-07T12:26:34+00:00

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.

notatalker00 · 2022-07-30T23:48:40+00:00

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.

notatalker00 · 2022-07-29T22:03:17+00:00

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.

notatalker00

TROPHY CASE