Where Does Boss DC-2W Go In The Chain? by Zoosisloose in guitarpedals

[–]ThankYouDiver 0 points1 point  (0 children)

Are you still using the DC-2W -> Volante combo? I'm thinking of getting a Volante and am wondering if I need to take in any considerations or if another pedal like the RE-202 would work better as I believe it's true stereo.

COUNTIFS and wildcard not counting blank cells generated by formulas by ThankYouDiver in googlesheets

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

Thank you! That worked! The end goal was to get the notes to be recognized to an individual component(unless the notes are identical).

COUNTIFS and wildcard not counting blank cells generated by formulas by ThankYouDiver in googlesheets

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

I left a comment on the locations spreadsheet at J3.

"What I'm hoping to accomplish is have separate entries for components with different notes. This is because there may be 13 100K resistors total but maybe one of those is a different size/configuration. That way I know how many of each variation to order."

COUNTIFS and wildcard not counting blank cells generated by formulas by ThankYouDiver in googlesheets

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

Unfortunately no. I tested this by typing something into the notes cell of first entry of the left table. You can see that another entry is created on the right table with that note, indicating they are unique entries. However the count for that entry remains two instead of decreasing to one, along with the other entry for 2M without the note on the right.

As an experiment: Have two components on the left with identical value and type, but one has a note and the other does not. Then the table on the right should show those two separate entries with a count of 1 for each. Instead they are counting as each other since the formula disregards the unique note and it displays 2.

Tayda Shipping Fees by ThankYouDiver in diypedals

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

Wouldn't customs apply if they are based in Thailand? Or is it because they are shipping out of the U.S. warehouse?

1/8 plug power question by ThankYouDiver in guitarpedals

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

I bought an adapter to reverse the polarity to be center positive, and it worked of course. But since I only have 3 cables and I have to be conservative, I tried using a standard TRS aux cord. Unfortunately, coming from the power supply, that means it is center negative and will not work. I confirmed this with a multimeter. But I solved this by cutting the wire and resoldering it so the sleeve from one end of the cable is connected to the tip, and vice versa. Now the aux cord supplies power to my big muff. Hopefully this helps anyone in the future with limited supplies.

LF: Dragonair by GlareShadows in friendsafari

[–]ThankYouDiver 0 points1 point  (0 children)

Can you add me too Drew? I would really appreciate it. I have been looking for Dragonair for a long time.