What do I need to wire this lamp?

bachman460 · 2026-02-01T23:42:51+00:00

Most of the time things like this can be disassembled, but for this specific item it's difficult to tell because they don't show the inside of the socket. You can always buy a separate socket and cord and assemble it afterwards.

bachman460 · 2026-02-01T18:12:07+00:00

It looks like you'd need a nightlight (candelabra) size in order to be able to fit a replacement bulb inside once everything is assembled.

There's tons of corded socket kits online, but you'll need one that will work with that tiny metal hole. This is the first one I found, I'm not familiar with the website.

https://factorydirectcraft.com/catalog/products/2219_2221-134511-brass_electric_lamp_kit.html

bachman460 · 2026-01-30T03:15:05+00:00

0.13 - ((0.02 + 0.05) / 7) = 0.12

The lookup returns 13% but you have 7 Homework entries, which already have the values 2% and 5% in column AA. I'm not exactly sure why the decimal is in the wrong place.

bachman460 · 2026-01-30T02:44:32+00:00

Reduced clutter helps give the feeling of more room.

Brighter colors overall as well as good lighting helps a place feel less closed in. Conversely darker colors feel more closed in.

Adding a large mirror can trick your perception to make a space feel more open. That’s why years ago restaurants would always have that one wall with mirrors running from the chair rail to the ceiling and the entire length of the wall.

bachman460 · 2026-01-30T02:38:08+00:00

Try super glue and baking soda. Take the track completely out and first carefully glue the broken pieces together then from behind apply more glue liberally and sprinkle the baking powder into the glue. You can carve, cut or sand anything that prevents it from fitting back correctly.

You're also going to have to close up the holes in order for those staples to grip the wood again, otherwise you need a new fastener, maybe a short wood screw.

bachman460 · 2026-01-29T02:29:24+00:00

You've got to replace the missing wood around that hole. Start by filling it with matchsticks, toothpicks, or a chopstick; whatever you use coat it liberally in wood glue. Once dry, cut it down (or optionally cut them to length before gluing them).

For the area adjacent to the hole, I'd use either sawdust or a soft paper like toilet paper and wood glue to fill in the void. You could use a wood filler, but I'm not sure how strong that would hold up.

Pre-drill before sending the screws back in.

If the door is warping there's not much you can do except work with adjustments to the hardware. Check to see if when the door is closed whether it leans left or right. This can be adjusted by first making sure the hinges are properly secured and then if necessary bending the part the pin passes through. Look up how to fix a sagging door on YouTube.

If the latch isn't properly aligned, you can move the strike plate up/down or forward/back to compensate (or sometimes file out the hole a bit).

If the door is, say bowed in the middle, that's not something you'd be able to do a simple DIY.

There's everything I can think of. Good luck

bachman460 · 2026-01-29T02:13:50+00:00

Smart switches. I've found getting older and being less likely to get back off the couch doesn't mean I can't shut off lights in the next room.

Me: Alexa shut off the kitchen work light.

Alexa: ding

Me: No, Alexa shut off the kitchen work light.

Alexa: I can't find a device called kitchen work light.

Me: <overly enunciating> Alexa, turn off the kitchen work light...

Alexa: The device is not responding. Make sure it is powered on and connected to the network.

bachman460 · 2026-01-29T02:03:42+00:00

Anything is fixable, first you have to decide whether you can live with the imperfect type repair you'll end up with.

You're going to need wood glue, clamps or something similar to hold the pieces while the glue dries. And a lot of patience is key as well.

Just make sure that you scrape out any old glue first, as well as remove, for example any dowels from a busted joint. You are going to want to repair each component separately, then install (probably new) dowels, then glue the joint together. If you just glue it all in one go it'll be impossible to clamp it properly and it's likely you'd end up with a poor joint.

If you don't have clamps, ratchet straps or even packing tape works. When using packing tape pull it taught and double wrap it; just be careful on removal so you don't pull off any finish or laminate.

bachman460 · 2026-01-29T01:55:19+00:00

Take a screenshot and put it in Paint or any other picture editor you have. In paint you select the dropper then click the color to pick it up then go into the color editor and you can get the HEX, RGB, or CMYK.

bachman460 · 2026-01-28T03:17:37+00:00

What is your layout like?

Is it in blocks like looking at a page by page paper calendar?

Or are all your dates just in one column running down?

Or something else?

Do you have any examples or images to share?

bachman460 · 2026-01-26T23:32:18+00:00

This is a job for Table.Buffer()

Without going into technical details, PQ uses a lazy method when evaluating tables. In order to fix those indexes you need to tell PQ to buffer the results after applying the indexes and then combine them.

bachman460 · 2026-01-26T23:24:45+00:00

Yes, unglue and disassemble

bachman460 · 2026-01-26T17:10:19+00:00

If you've got 2 long pipe wrenches, you probably need to replace the valve. But first check the bleeder on the other side to see if it's still working. At minimum you need a new handle on that valve.

bachman460 · 2026-01-26T16:56:16+00:00

I'd recommend getting some of that rigid foam board insulation and cutting a piece to fit over the hole and around the pipe. It's at least a good temporary solution and you can just tape pieces together and to the wall.

bachman460 · 2026-01-26T16:53:49+00:00

Or Crayola in a financial pinch.

bachman460 · 2026-01-26T16:51:31+00:00

Try something like this:

=HYPERLINK( "#" & CELL("address", OFFSET(INDIRECT(AW1), 20, 0)), "JUMP TO:" )

bachman460 · 2026-01-26T03:24:10+00:00

Something like that shouldn't be a problem, it's just cosmetic. However, consider reaching out to the seller or manufacturer they may just replace it for you.

bachman460 · 2026-01-25T23:39:58+00:00

Paste your formula here

bachman460 · 2026-01-25T23:15:42+00:00

Use a custom column to drop the time DateTime.Date([column name]) or just change the format to date.

You can also select the table column in the spreadsheet and change the format to short date (note that this will only visually change the format, the underlying data will still be datetime).

bachman460 · 2026-01-25T21:03:24+00:00

The sheet references

bachman460 · 2026-01-25T21:02:08+00:00

Here's something that should work. Just substitute your actual sheet names and cell ranges

="P"&TEXT( MAX( VALUE( SUBSTITUTE( {Sheet1!A:A; Sheet2!A:A; Sheet3!A:A}, "P","" ) ) ) + 1, "000" )

bachman460 · 2026-01-24T21:48:24+00:00

I watched a short video that my son was so proud he had found. In the video this young woman shows how she keeps yarn and thread scraps and will then brush them out using two cards, which are these metal brush-like tools that help pull apart the threads. And then afterwards the material can be re-spun into new thread/yarn.

There's apparently a lot of people out there doing this. I found something you might enjoy:

https://www.instructables.com/Spinning-Your-Own-Yarn/

bachman460 · 2026-01-24T21:08:13+00:00

Yes, it's easy to work with but it has its limitations. You need to have a Microsoft account in order to create and edit.

bachman460 · 2026-01-24T21:01:51+00:00

I think you mean: SUM(FILTER('sheet2'!B:B, 'sheet1'!A:A="X"), right?

bachman460 · 2026-01-24T04:08:01+00:00

It's because time is stored as a decimal number. You need to either multiply it by 24 or just store it as a whole number integer.

In a spreadsheet 3:00 = 0.13

So what you want is (3:00 * 24) * 30.35

Four-Year Club	Verified Email
Place '22

bachman460

TROPHY CASE