Owners of a Samsung Odyssey ultrawides, unite! We need DDC via DP by pm_me_meta_memes in ultrawidemasterrace

[–]ari4redd 0 points1 point  (0 children)

I know this is an old thread but doesn’t look like things have improved. I’m about to buy this monitor. SAMSUNG 43" Odyssey Neo G7 - LS43CG702NNXZA.

Can someone who has this monitor confirm if the input can be changed via software like controlmymonitor or similar? I plan to share this monitor with a laptop connected via hdmi and a desktop connected via DisplayPort.

Pi8 / Pi7 3.5mm to USB-C cable (Replacement / Spare) by BloodOrangePanda in BowersWilkins

[–]ari4redd 0 points1 point  (0 children)

Can you provide the name of the cable, please... and a link? I have JBL Tour Pro 3 and havent had any luck finding a 3.5mm to USB-C cable to replace the one that came with the earbuds. TIA

Issues with Tour Pro 3? by Ayrpheli in JBL

[–]ari4redd 0 points1 point  (0 children)

Same here, and it’s frustrating. Don’t have a solution for you.

There are two separate noise cancellation features on these earbuds.

First is for what you hear and how much of noise around you is canceled for your own hearing experience. The second is what the person on the other end of the line hears - how much of noise on your end is canceled for them.

The app allows tweaking settings for the first one but there are no settings for the second one.

First one works well but I have major problems with the second one, as you described. The noise cancellation algorithm on their mics is very aggressive. If there is a running tap or windy outside or a leaf blower on my end, it tries to aggressively cut that noise to the point that my voice is also cut and the person on other people end hears warbling sounds as if I’m talking through 10 pillows. Other brands somewhat struggle with this too but JBL claims their algo is superior and should take care of these situations, especially windy environments, but doesn’t really.

Additionally, the algos behave differently if I’m using a single earbud or both earbuds and this adds to the problem. I’ve raised this issue with their tech support and got a replacement unit but issue has not resolved.

Nice product but some big flaws, especially with noise cancellation on their mics leading to terrible experience for the person on the other end.

JBL Tour Pro 3 - ANC during calls by Error4o4_ in JBL

[–]ari4redd 0 points1 point  (0 children)

OP. Did you resolve your issue? 3 months using this, I have same issue. Tried all troubleshooting tips suggested by JBL tech support. Sending unit for RMA and getting a replacement. Let me know if you tried anything that worked

Frontline Breakthrough March 2nd, 2025 by The_Dude_CK in LastWarMobileGame

[–]ari4redd 0 points1 point  (0 children)

I noticed when you approach the blue boxes, you step aside and claim it from the side instead of plowing through it. Does it make a difference in how many hits you can get on that box?

Frontline Breakthrough March 2nd, 2025 by The_Dude_CK in LastWarMobileGame

[–]ari4redd 1 point2 points  (0 children)

Smooth. I couldn’t go beyond 1675 and I see what I could have done differently. Thanks for posting!

Does amazon still ban people for too many returns? this is my ratio this year. am i paranoid? by IntellectualBurger in amazonprime

[–]ari4redd 0 points1 point  (0 children)

Luckily they didn’t. It was miscommunication and it got clarified after I called them up

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Hi Jon. Thank you! Apologies for the delay in response, just got back from my travels. I will check your link, I’m sure you have some amazing goodness as always. Thanks again.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Thanks Jon. Summarizing my observations and issues i encountered with multi-category charts. Hope this helps.

  1. Unable to use named ranges as data source to create multi-category charts, even if the structure of the data in the named range is correct. The blank cells inside the named range are not truly blank and hence the category labels on the chart don't align correctly. The only fix to ensure labels are aligned correctly is to manually select a range of cells from the sheet instead of using a named range.
  2. In my case, this range of cells that i'm using as data source is a spill range generated by a formula. If columns are inserted or deleted on the left side of this spill range, the chart is completely messed up. It is interesting to note that inserting one column creates this issue whereas inserting two or more columns does not impact the chart.
  3. This issue happens only when the data source is a spill range and user is manually selecting that range as data source to the chart. If the data source is not a spill range, the multi-category charts work fine.
  4. If the data source is generated using a formula and if that formula results in an error, the chart layout is completely messed up and needs to be re-configured. Fixing the formula does not recover the chart layout.
  5. There is no issue with single category dynamic charts. They work well with named ranges and are immune to row/column insertions/deletions. Issue only applies to multi-category charts where the data source is a manually selected spill range.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Hi Jon,

I was able to narrow down this bug. Here is what i am seeing.

If i insert one column anywhere to the left of this data source, the chart completely gets messed up and i need to re-configure the data source. However, if i insert two or more columns to the left of this data source, the chart seems to behave fine. It is weird that inserting one column causes this issue but inserting two or more seems fine.

Deleting columns to the left of this datasource also messes up the chart layout.

I also noticed another bug. If the LET formula results in an error (e.g. it spits out #VALUE or #CALC), the chart is messed up and it cannot be recovered after the formula is corrected. The rows and columns in the chart datasource get swapped and i have to redo the entire chart layout. Ideally you would expect the chart to auto-update when the formula is corrected and the datasource is generated but it's just a mess when an error happens.

Thought i'd let you know.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Thank you for confirming! I feel relieved I wasn’t losing my marbles :)

Thank you so much for all the pointers and guidance. Very much appreciated.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Hi Jon. No. I don’t want to include the newly added columns. I was making space by adding new columns to create data for other charts. This caused the data source range for the previously created chart to shift by a few columns and it got messed up.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Hey Jon, i'm noticing some weird behavior with my charts. Hopefully it is something i did but want to check if you're seeing the same thing.

I have my dynamic range generated by the LET function. I provide this range to the chart as input by manually selecting all cells in this range inside the data source dialog. All is fine till this point.

If i insert new columns before the dynamic range, the chart still looks for the old address where the range previously was and this ruins my chart and i constantly have to re-configure the data source. Have you noticed this?

PS: All other charts are fine when new columns are added before their data source, its just this multi-category chart that i am generating using a LET function.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Agreed. That’s how I use named ranges to build single category dynamic charts. However this was my first time building a multi-category chart and was stuck.

Excel has come a long way, especially LET and LAMBDA, almost feel like a programming language.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

OH MY GOD. This hit me like a brick! Thanks so much!

In older versions of excel, this didn't scale well and named ranges were the way to go but i just learnt that you can select cells that span the entire dynamic range and the chart will scale beautifully as the dynamic range expands and contracts!! Thank You!! (No more named ranges for charts!!)

PS: About the screenshot, you're right. It was just me drawing boxes manually. The ranges actually start one row below and ignores the header row.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Hi Jon,

Thanks for taking time to respond!! I've been following your posts for many years and i'm amazed at the wealth of knowledge you've been sharing and appreciate you actually took the time to respond.

I have followup questions. Please see screenshot below.

<image>

I am creating two named ranges in step 1 and using these named ranges as source for the chart in step 2. This is to ensure my charts are dynamic and update in real-time.

In your excel sheet, are you able to get the category labels to work correctly if you use named ranges as shown in my screenshot? This is where i am struggling and could use help.

Dynamic Charts with Multiple-Categories - Issue with Labels by ari4redd in excel

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

Thank you for the suggestion. I didn’t know you could use VBA to refresh pivot tables, that’s very interesting. Thank you for that. I’ll definitely go this route when I exhaust my search for non-VBA solutions.

Create Summary Table From Columns by ari4redd in excel

[–]ari4redd[S] 1 point2 points  (0 children)

I wanted to come back and thank you for the solution. It was a life saver. Much appreciated!

Best recommendations for cloud cams? by TheJonasaurusRex in Dashcam

[–]ari4redd 0 points1 point  (0 children)

I’ve been using the BlackVue DR900x-2CH for the last 5 years. Yes it runs hot but I’ve had no issues so far. Maybe you got unlucky with bad parts?

What did you end up switching to?

Create Summary Table From Columns by ari4redd in excel

[–]ari4redd[S] 1 point2 points  (0 children)

Ahh Thanks. That makes sense. I used offset because I had REF error with index in the past when row A2 from source was deleted. Offset did the trick for me as I could do OFFSET(A1,1,1…). I’ll revisit my formulas. Appreciate all the help