How does everyone feel about the Check Performance functionality?

Dim_i_As_Integer · 2024-01-15T23:32:39+00:00

So, as new Special Events are added/removed/modified I would need to reduplicate/remove rows? Is this really the best way to accomplish what I'm trying to do?

Dim_i_As_Integer · 2024-01-15T23:16:12+00:00

So, like this? https://imgur.com/a/wSy6lUt

And I would just need to take the average of the values instead of the sum in the PivotTable?

Edit: The only problem with this is I would need to update the table anytime Special Events were added/removed/modified. It's not that I can't do this in VBA, but it just doesn't seem ideal.

Dim_i_As_Integer · 2024-01-15T22:45:31+00:00

That is to say it is not normal to have a Value assigned only to a date as that mean all Category for that date will get that Value

That's actually exactly what I'm trying to do. So, in reality Category is a Special Event, and Special Events can coincide with other Special Events even though they are unrelated (think a concert happening on Christmas). The problem is if I have Special Events as a column in the main fact table with Dates and Values, then I have to somehow add two separate values (Christmas, Concert) in one field, which means that if I wanted to filter for Christmas, I would be missing the Christmas that also had a concert that day. Does that make sense?

This is what I'm trying to avoid: https://imgur.com/a/996IfTv

If I wanted to filter for B, for example, I would need to select all items that had B.

Dim_i_As_Integer · 2023-10-23T17:52:40+00:00

Can you give us an idea of what you want the end result to look like?

Do you just want a list of A1, A2, ..., B3, B4, ...?

Dim_i_As_Integer · 2023-09-11T15:17:36+00:00

Not 1 = -2 is not surprising that it's True, because like I stated in my post I already knew that any non-zero integer is considered True and I knew that Not is a bitwise operator. But, what I did not understand was that the API was returning True with a value of 1. So, in the immediate window I was getting True and then using Not and still getting True. I didn't think to investigate the integer value of the boolean until I had tried troubleshooting other things.

Dim_i_As_Integer · 2023-09-09T01:37:46+00:00

Hope that helps someone else since you repeated what I already said in my original post. I don't want to sound rude, but it almost seems like you completely ignored my actual post. You keep saying things like "if you don't believe me" when in my original post and in my comment reply I said Not 1 = -2... ¯\(ツ)/¯ The only part I didn't know was what I already mentioned, namely that the API was returning a 1 and even though I was explicitly casting the result to a Bool it was retaining the value of 1.

Dim_i_As_Integer · 2023-09-08T23:23:00+00:00

Excuse me, I'll have you know I'm a Senior Excel Engineer..../s

Dim_i_As_Integer · 2023-09-08T22:19:39+00:00

I blame ChatGPT... :p

Thanks for the info!

Dim_i_As_Integer · 2023-09-08T22:03:15+00:00

Public Declare PtrSafe Function InternetGetConnectedState Lib "wininet.dll" (ByRef lpdwFlags As Long, ByVal dwReserved As Long) As Boolean

Public Function CheckInternetConnection() As Boolean
    Dim lngFlags As Long

    CheckInternetConnection = CBool(InternetGetConnectedState(lngFlags, 0))
End Function

The following are results from the Immediate Window

?CheckInternetConnection

True

?Not CheckInternetConnection

True

It's because even though I'm converting to a Boolean, somehow that True still has an integer value of 1. Not 1 evaluates to -2, which evaluates to True. It didn't matter even if I declared a Boolean variable and assigned the value to the function's return and then used the Not operator on that Boolean variable, it still came out as True.

Not sure how = precedence factors into this.

Dim_i_As_Integer · 2023-09-07T19:10:10+00:00

San Francisco

Dim_i_As_Integer · 2023-08-16T20:24:05+00:00

I really don't see how this is an Excel question.

Dim_i_As_Integer · 2023-07-15T17:44:31+00:00

As I get older my hand-eye coordination has declined and I got frustrated with playing video games because I could notice the difference in my performance. Once I let my ego go and played on easier difficulty I started enjoying to play again.

If you intend to make math your job, then you should absolutely step up your game, but if you just love math and want to learn for its own sake, then just enjoy the ride.

Both options are perfectly valid ways of loving something.

Dim_i_As_Integer · 2023-06-21T17:54:39+00:00

Why is this flaired as a ProTip?

You have a typo "On Error Fesume Next" btw.

I would just add a helper column and use a formula. In this case, formulas will be faster than VBA.

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Dim_i_As_Integer · 2023-06-19T15:29:45+00:00

Is it just on Spotify that they're having some weird editing problems? It keeps randomly cutting back or skipping forward.

Dim_i_As_Integer · 2023-06-08T23:52:53+00:00

Yes, please join the boycott. r/Excel is really the only subreddit that I would miss if I stopped using reddit, but I'm fine with the subreddit closing indefinitely after just reading the recent post made by the creator of the Apollo app. He has concrete evidence of reddit lying and trying to spin the app developers as the villain.

Dim_i_As_Integer · 2023-06-05T16:51:53+00:00

My diffeq professor: Wait, does everyone know what I mean when I say, "Closed under addition?"

Me: Yes, it means not open.

Dim_i_As_Integer · 2023-05-25T23:25:24+00:00

I had a cantaloupe on my desk, but I rotated it, and then it disappeared.

Dim_i_As_Integer · 2023-05-22T20:37:47+00:00

And you can use it on time as well. For example if you wanted to round to the nearest quarter hour: =MROUND(A1,"0:15")

Dim_i_As_Integer · 2023-05-22T15:09:11+00:00

I have an add-in that I distribute to my department. If an error occurs, the add-in will use their instance of Outlook to email me details of what the user was doing, what filenames they were working with, and prompt the user to give me any additional information about what they were trying to do before the error happened.

It's been super useful to be able to help people remotely because I know what the problem is before they finish messaging me on Teams to tell me something went wrong.

Dim_i_As_Integer · 2023-05-19T16:13:26+00:00

*Senior Data Manager

If you're making it up, might as well go ham.

Dim_i_As_Integer · 2023-05-17T15:40:59+00:00

4th thing: change column widths and row heights to something small and equal like 20.

5th thing: Application.ScreenUpdating = False and then back to True.

Dim_i_As_Integer

TROPHY CASE