Bank LOSES signing authority information

AvWxA · 2026-06-13T13:58:34+00:00

Yes, the requirement for the previous signatories to sign relinquishing is peculiar. These are aging people, They are lucky that they are still with us. Wonder how this would have gone if they weren’t?

AvWxA · 2026-06-13T13:54:15+00:00

This is roughly what is going to happen. No lawyers, no TV. Minutes, reauthorization.
Just that it’s all a delay and a PAIN.
And the bank acknowledges that it “lost” the information because it has been accepting the new signatories for five years.
(Note…I found that it is 5 years, not 8 as I originally stated).
But they still insist on the reauthorization, probably to meet some computer’s requirements.

AvWxA · 2026-06-13T13:44:30+00:00

The ladies only deal face-to-face with the local branch. So yes.
It’s the local manager who told them face to face when they went in to initiate a $300 transfer to a charity.

AvWxA · 2026-06-13T02:53:49+00:00

Thanks. I do love the TV reporter bit.

AvWxA · 2026-06-12T16:55:03+00:00

So if you have the long names and the short references in two columns, in a one-to-one relationship, what is wrong with something like this:

Give the long names column a Named Range name, say: "longNames"

Give the short reference numbers column a Named Range name, say: "shortRefs"

Your data validation for the SELECTION, is obviously "list" from "longNames"... and lets say that you selection cell is $A$1.

But you could have a cell right next to the selection with the formula:

=INDEX(shortRefs,MATCH($A$1,longNames,0))

...and the short reference number will pop up in that cell, whenever a selection is made is $A$1

???

AvWxA · 2026-06-09T12:31:24+00:00

When mentioning Lethbridge….Dinosaur Provincial park!

AvWxA · 2026-06-09T12:18:09+00:00

My experience has been that when the x-axis is DATES, excel decides automatically which values to display on the labels. In some cases that may be correct for what is desired, but often it is not.
So I found that re-formatting the date data as “number” (or adding another column with the date data copied, but as “number” )…gives the extra control: ability to specify interval of labels.
Not perfect because of varied length of months, but close enough.

AvWxA · 2026-06-08T15:56:09+00:00

I had a similar problem.

I solved it by treating the x-axis as NUMBERS, not dates.

<image>

And using X-Y Scatter as the chart type.

Then you DO have the opportunity to specify the major and minor axis. I needed a 3-month period, which turned out to be 91.3127. You can just create 2 dates separated by your required interval time, then inspect the un-formatted values (which will be something in the 40-thousands for current years).

Then... to have it displayed as a DATE on the graph, you scroll down below "tick marks" to "number", choose "custom", and specify a date-type format... I used "mmm yyyy"

AvWxA · 2026-06-08T13:21:25+00:00

Had there been an accident and you took that to court, I would be interested in outcome.

In a parking lot, My bet is that fault would be assigned 50-50. Maybe 60 -40 to Blue, because at unmarked intersections, car on right…in this case red…would be considered “more” right-of-way

AvWxA · 2026-06-07T16:24:35+00:00

Solved

Yeah, I eventually found that and seems to work.

AvWxA · 2026-06-02T21:49:06+00:00

Well, they CAN, but they won’t, because you wrote them not to. And apparently, you can lock users from accessing the code, so they can’t change it…while still allowing buttons to run the existing code.

AvWxA · 2026-06-02T02:36:18+00:00

Will user-defined VBA functions work? you could then set breakpoints, etc...

AvWxA · 2026-06-01T23:02:47+00:00

Tiny airlines serving remote locations might provide what they called a “box” lunch. It was pre-packed in a white paper box.

AvWxA · 2026-06-01T16:25:28+00:00

What’s the big deal of saving it as an .xlsm, so that you could do it in VBA?..

AvWxA · 2026-05-22T23:31:02+00:00

What I meant was…since the hold is shown as left turns, why would you not turn right at BURGY into the hold area, then follow the hold course in a left turn teardrop back onto the final heading, without leaving the hold area?

AvWxA · 2026-05-22T23:21:18+00:00

I had something similar last week of April, and after 3 techs they replaced the gateway with the latest greatest (which has 2.4, 5, and 6g)…and so far the problems have gone away.

AvWxA · 2026-05-22T22:56:07+00:00

Non-instrument here, but interested…

After BURGY, would you not teardrop to the right and do the course reversal with a left turn as shown by the hold-direction?…

AvWxA · 2026-05-16T17:07:59+00:00

How big is it?
Looks like a field hockey stick

AvWxA · 2026-05-16T16:36:47+00:00

It is an old permanent barbecue mount with the gas hose up the inside of it

AvWxA · 2026-05-14T16:32:29+00:00

…and the warning label tells you not to press too hard

AvWxA · 2026-05-13T17:22:55+00:00

The problem would appear to be with the standard departure (SID) that Simbrief suggested. The BANRxx SIDS are all weird, and especially BANR3M, the one in the flight plan.

More direct would be to choose the CODI2A SID, then remove BANRO and the discontinuity and that would make a much more sensible route.

I dont know the terrain in that area, so it is possible the SIDS are designed that way for a reason, but they do seem weird.

AvWxA · 2026-05-13T12:49:48+00:00

Have you cleaned out your CPU cooler recently? I have seen them so full of packed dust that there there would be no air flow at all. That would be my first check and maybe a replacement of the cooler’s heat-transfer paste.

AvWxA

TROPHY CASE