▲ 4 r/excel

One-button formatting of a cell, in different workbooks, but personal macros aren’t working for me.

I am trying to sort a very particular problem. I want to be able to tap one button (which will be assigned to a keyboard macro, so could be a short string of keypresses) that formats a cell in a particular way.

The use case is running a daily timetable to send out to teaching staff, with a different colour scheme in those cells representing lessons which are different. None of the default “cell styles” really work, as they need to stand out against the timetable colour scheme to be instantly apparent.

I have been using format painter, which is fine, but I have to leave a copy of the “changed” format at the side when I am working on the sheet. I’d really like a one-button solution. I tried saving macros in a couple of ways, but even when I got a macro perfectly working, running it clears the undo function, which when I am solving a complex timetable puzzle is not ideal…

Am I missing a clever way of achieving this?

reddit.com
u/Stewtheking — 6 hours ago

Macropad Placement?

Where do you guys have your macropad on the desk? I used to have mine a little bit out of the way in the corner of my desk pad, when it wasn’t getting used as often, and was more of a fun toy than anything (position A). Now I am using some more complex macros as part of my work (excel shortcuts mainly) it has just moved to between my keyboard and trackball (position B) (I have also just made a little riser to bring the height up to sensibly use it *almost* as an extra thumb cluster for the trackball). I am wondering whether having it set up to use left handed (position C) would be better, though, as I would keep my hand on the trackball.

I know there are clever "out of the way" positions, mounting under the monitor and under the desk, but those are a bit out of the way for workflow stuff. Is there anything else I am missing? What positions have people experimented with (successfully or otherwise)?

Yes, I do have a lot of macropads.

Edit: okay, you have all convinced me. Evidently C is the only sensible way to go. I have shuffled some cables, re-mapped so that the layers make sense with the other hand, and will aim to refresh my muscle memory!!!

u/Stewtheking — 13 days ago

Nearfield (desktop) setup

I have a pair of speakers set up in the near field on my desk, in approximately the above configuration. When I was placing them, logic seemed to be that I should have them as wide as possible, but doing some further reading that doesn't seem to be true. Recieved wisdom seems to be that an equilateral triangle would be more optimal, but I can't seem to find any detailed discussion of precisely why.

I have some latitude to be able to move the speakers on their stands. I can probably move each speaker in by approximately 10/12 cm without too much juggling of cables, however any further would necessitate some fairly significant reorganisation on the desk.

I am guessing the advice will be "give it a try and see", but can anybody give me some idea of what the changes are likely to be, so I can make a determination as to whether it is likely to be worth the hassle?

u/Stewtheking — 22 days ago
▲ 131 r/desksetup

Teaching lab desk setup

This is my setup in my teaching lab. I am pretty happy with it at present, but definitely room for tweaks.

• Flexispot standing desk legs, on old corner desk top.
• Iiyama 34 inch monitor, with a 24 inch either side. Right monitor hardware-mirrored to the classroom display screen.
• Usage: left monitor for music and whatsapp, main monitor for emails, what I'm working on and a file folder, right monitor for reference, presenting to class, and when I have just too many spreadsheets I need open at once...
• iPad as a digital photo frame, (all pics of my kids). Phone on charging stand (need handy for 2FA).
• DIY full-range speakers, from IKEA salad bowls, on ear-height speaker stands. Powered by Loxjie A30, and low range boosted by a subwoofer (Yamaha YST-FSW050).
• Loxjie amp mounted by cable-tying to vesa mount on otherwise surplus side of dual monitor arm.
• Speaker switch (hidden) to swap between desk speakers and big floorstanders to feed sound to the room (class watching videos etc.)
• Keyboard - own design; Helvellyn. Numpad - RoMac Macropad. Macropad - pcb based on Joe Scotto's Scotto9.
• Trackball - Ploopy adept.
• Deskpad - busy town!
• Fan - mounted (homebrew, with lab cork) on monitor stand.
• Lighting - Quntis ScreenLinear, and 2 desk lamps.
• Pen rack - borrowed test-tube-rack.
• Cable management - desk-dinosaurs, a Univivi cable-management tray, and many velcro cable ties.
• Mug - Daddy Pig (Fathers' Day Gift)

u/Stewtheking — 2 months ago

Noticing upgrades, by noticing downgrades

I have been improving my setup recently. I built some speakers, added a sub, added a few tweaks here and there. I have been really enjoying both the process and the music I have been hearing.

One interesting thing I have noticed, however, is that all of the other ways I often listen to music (the headphones I throw on in the supermarket, the speakers in my car) suddenly sound like hot garbage. I definitely appreciated the improvements in sound quality of my main rig, but the relative downgrade of all the rest is even more striking.

Anybody else experience this kind of effect?

reddit.com
u/Stewtheking — 2 months ago

I currently use a loxjie a30 on my desk, which I have had for about 4 years, but am feeling the itch to upgrade. I recently DIY'ed some new speakers for my desk setup, based on small full-range drivers, and want to try and get a little better sound out of them. I also use a subwoofer (with a single RCA input, the yamaha FSW050) to flesh out the bottom end.

Looking around for amplifiers, there are no shortage of options, with endless small class D offerings. When I narrow down to what I am looking for (one box with DAC (preferably USB, but easy enough to get a DDC for a coax in) and speaker amplifier, single RCA out for the subwoofer, small footprint for desk) then I always seem to end up reccomended the loxjie a30 as a sensible option that ticks all of my boxes!

The Fosi BT20A Max was looking like a good contender, but then I am going to be using it on my desk at barely arms length away, and I am not excited by the thought of fan noise.

So, anybody have experience with the same sort of upgrade situation? Is the loxjie A30 the best I am going to get without really splashing some big cash around? Would I be better served by something class AB (and if so, any options that have the right IO I need?)? Any suggestions for things to investigate?

reddit.com
u/Stewtheking — 2 months ago

I’m thinking vaguely about building a subwoofer, to complement the IKEA bowl speakers I built for my desk a couple of weeks ago. They definitely need a bit of help in the low end, and I also have the big to build something else.

So, I am considering building a passive sub with the larger size of IKEA bowl. I may be barking up all kinds of wrong trees, but I am thinking about trying a dual-opposed with 2 smaller drivers on opposite “bowls” so visually it mirrors the speakers. Currently assuming it will be a sealed enclosure.

(a) Is this seven kinds of stupid?
(b) Any recommendations for small subwoofer drivers I could source for cheap?

reddit.com
u/Stewtheking — 2 months ago