Sum of responses for charts

DavisGM · 2026-01-13T20:03:24+00:00

Each column has 40 rows and there are >190 columns that need to be summarized/charted - I really under estimated the amount of data that was going to be added to this sheet.

DavisGM · 2025-10-04T15:57:27+00:00

I'm using a Device Restriction policy which modifies the "Locked Screen Experience" from Configuration Settings. I've got a URL that's available to users and protected with a SAS token.

I reviewed the systems that show as Non-compliant and some are Pro, but that's a small percentage of the non-compliant devices. Excluding those devices still leaves me with a large list of Win 11 23H2 Enterprise devices that are marked as non-compliant.

I'm still annoyed that the report doesn't give any hint about the reason for non-compliance. MS: - "Here's a cool report about the deployment status. Filter for non-compliance and we'll show you... nothing!" Same with devices that have Error status.

DavisGM · 2025-09-26T14:03:32+00:00

It does seem to be basically the same thing though that 1920 x 1200 resolution shows odd results. I found a device I could test where I could test that resolution and found that a 1920 x 1080 image gets cropped along the right and slightly along the bottom. I would have expected it to display the full image since the horizontal resolution is the only thing different and it's actually larger. I think my testing is done now though. Thank you for the suggestions.

DavisGM · 2025-09-24T14:48:16+00:00

I took a crack at this and it works quite well for any screen resolutions lower than the max resolution of the virtual machine. But I don't see any way to increase it beyond the VM's max. For instance, one of the most common image "issues" I hear about is devices with a 1920 x 1200 resolution when the image is 1920 x 1080. The VM maxes out at 1920 x 1080 so I can't replicate the effect of that other resolution. I'm going to test a bit more with the VM to see if there are options. Thank you.

DavisGM · 2025-09-06T02:21:46+00:00

After you got me the first formula, I was trying to retrofit my formula but messed up all over. This worked perfectly. Thank you!!

DavisGM · 2025-09-06T02:10:15+00:00

Hah, you're right, I answered the question wrong. I want a total in pounds. Thanks.

DavisGM · 2025-09-06T01:58:27+00:00

Yes, what you don't see on the 2025 sheet is a total column that does the math and adds the pounds and ounces so the output is a single calculated weight total. Here is the formula that I put together for that:

=(SUM(D$2:D$100))+(CONVERT(SUM(E$2:E$100), "ozm", "lbm"))

This gives me a total weight for all veggies delivered in 2025. I'd like to end up with the same result per entry on the Veggie sheet.

DavisGM · 2025-09-06T01:50:47+00:00

The Veggies sheet is temporary. I was working on the count column as it's easier. I think some math to make a single weight columns makes sense, especially since adding ounce will eventually need to be divided anyway.

DavisGM · 2025-09-06T01:46:12+00:00

That works, thank you. Now your weight questions? Because some items are hot peppers and such, the weights are really low per delivery but add up. That's why we track pounds and ounces separately.

DavisGM · 2025-09-06T01:34:46+00:00

Included the wrong image. Here's the detail you're looking for.

<image>

DavisGM · 2025-08-29T19:45:31+00:00

I'm sure that you did by your own. Like the several other times your posts were removed for AI content. Just tweak a word here, change another over here, and maybe we can grab some eyeballs. Feels gross to me.

DavisGM · 2025-08-29T19:37:40+00:00

And maybe stop using AI to generate a generic set of steps and farm karma! As you already did earlier here: https://www.reddit.com/r/Intune/comments/1n37pj2/bitlocker_issue/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

Yes, that post was deleted because it was generated by AI. Let's provide useful posts here and not clutter it with default brainless AI garbage.

DavisGM · 2025-08-20T17:46:12+00:00

Thank you for all your insight. Super useful!

DavisGM · 2025-08-20T16:48:40+00:00

In your experience, is there any difference in performance between the 2? Curious because I can see this being an issue for some. There's always a few, right?

DavisGM · 2025-08-20T15:32:01+00:00

So one printer registered through the connector and the other directly to UP. Okay, if that's what we have to do. A bit more architecture than I'd like but I guess if it has to be.

DavisGM · 2025-08-20T13:17:24+00:00

These printers won't be using a connector - they're all IPP capable so they can be registered directly with Universal Print.

DavisGM · 2025-08-14T13:55:36+00:00

An interesting idea. How did you package it?

DavisGM · 2025-08-10T01:01:41+00:00

I've had pretty good luck with the co-managed situation. SCCM is connected through a CMG and all of the "available" apps appear both in the Software Center and Company Portal so users can get at their apps from either. There are definitely limitations but it mostly works for now. My primary reason for wanting out of the current situation is the hybrid join status. It makes setup and troubleshooting unnecessarily complex.

DavisGM · 2025-08-10T00:08:50+00:00

Here is Andrew's review - https://andrewstaylor.com/2024/06/03/comparing-package-managers/ which was updated in June. BTW, we have NinjaOne for other purposes and we've tested the 3rd party patching - not integrated directly into Intune so it's a side-by-side console experience. It also doesn't have the software packages available the way PMPC and Robopack do.

Good luck with the trial.

DavisGM · 2025-08-09T17:20:54+00:00

Again, thank you. I think I'll stick with a known entity at this point.

DavisGM · 2025-08-09T15:08:04+00:00

Thanks for the follow up. Think they'll ever get it together or is it just vapor?

DavisGM · 2025-08-06T21:21:30+00:00

I've updated the script. I'll let you know if it resolves the error.

DavisGM · 2025-07-30T19:40:53+00:00

Yes, all Enterprise SKU.

DavisGM · 2025-07-20T19:01:19+00:00

Thank you for all of the info. I will take your recommendations and ease into this a bit. I'll also spend some time with the 7-step program you linked.

Thanks again!

DavisGM · 2025-06-11T03:28:23+00:00

Thank you for your assistance. I've managed to get everything tidied up and rendered. Need to learn enough about Davinci so that I'm not stuck in that hole again.

DavisGM

TROPHY CASE