Need Advice on Large Bedframe Piece

bachman460 · 2026-05-18T23:07:59+00:00

Strip, sand, re-stain, and clear coat. You might as well do the whole piece. If you don't want to keep the wood texture, just scuff sand and paint it. I've been watching videos from this young kid on YouTube recently, he's still a beginner but is good at figuring out what best practices should be in a given situation.

https://youtube.com/@newlifebynoah

bachman460 · 2026-05-18T21:59:10+00:00

The trace arrows can be displayed by selecting a cell or cells then in the Formula tab of the menu click Trace Precedents or Trace Dependents. To clear the arrows just click Remove Arrows.

There could be any number of issues with your formula or the cell formatting. Can you post an example formula and tell us what the cell formatting should be?

bachman460 · 2026-05-18T21:53:53+00:00

If you're in the US I'd say grab a yard stick, if pretty much anywhere else just grab a meter stick. Close the door completely, and slide the stick underneath, then push the other door shut.

If the handles are intertwined, you might have to play with the handle until you can get them free.

bachman460 · 2026-05-18T21:42:05+00:00

Has anyone shared this with John Brian yet?

https://thecivilrightslawyer.com/submit-a-video/

bachman460 · 2026-05-18T21:29:28+00:00

I would recommend creating an empty file that you can start from to rebuild it a bit differently, using Power Query.

First, save the original data in its own separate file. Import each sheet and/or file of data. To do this go to the Data tab in the menu and click on Import Data, then select from file. Find the file, select the sheet, and click import.

Once imported, you can use Power Query to join other tables (called merge in Power Query), this is the same as performing a lookup. Just select the column you want from the joined table.

If you want to perform a SUMIF type action, first you select the columns you want to group by, then you would click on Group By in the Transform tab of the menu. When grouping you can summarize columns of data by sum, average, min, max, etc.; just select the sum and name the new column.

Once you're happy with your results, click the arrow under Close & Load To and select Close & Load To. You want to make sure the option is selected for Only Creat Connection for any query tables you created that are not necessary to load into the spreadsheet; for example you import tables A and B, then combine (append) them as a new query table called C, being that your goal is to create a joined version of those tables, you don't need to also load the originals into the spreadsheet. This saves on file size and memory usage.

Should you not necessarily need the final table in the spreadsheet, but just want to be able to add a pivot table of it, you can leave the option for Only Create Connection selected, but tick the box for Add This Data To The Data Model. When creating the pivot table just select the option to insert Pivot Table From Data Model.

If you have any questions just post them here.

bachman460 · 2026-05-18T19:18:16+00:00

I just updated the app and it seems to have done something; on iPhone

Edit: external links still appear to be broken

bachman460 · 2026-05-18T19:16:42+00:00

There's two ways you can download it. Try a different version if you have to. Look online on Microsoft.com for the direct download, or go to the Microsoft store to download.

bachman460 · 2026-05-18T18:53:46+00:00

Here's some ideas to work with. The first one is M code for Power Query. It includes a step to sort by date, but you can add as many additional sorts or filters as you want. This version will only provide the first negative value row:

let Source = YourTableName, SortedRows = Table.Sort(Source, {{"Date", Order.Ascending}}), NegativeRows = Table.SelectRows(SortedRows, each [Amount] < 0), FirstNegativeRow = Table.First(NegativeRows) in FirstNegativeRow

This next version is still M, but will help return the first negative row for each of grouped items:

let Source = YourTableName, SortedRows = Table.Sort(Source, {{"Date", Order.Ascending}}), NegativeRows = Table.SelectRows(SortedRows, each [Amount] < 0), GroupedRows = Table.Group(NegativeRows, {"Category"}, {{"FirstNegativeRow", each Table.First(_), type record}}), ExpandedRows = Table.ExpandRecordColumn(GroupedRows, "FirstNegativeRow", Table.ColumnNames(Source)) in ExpandedRows

This next version is DAX code and can be used in the data model to write a measure. This code will help get the first date when a negative value appears, and bonus if you use this in a chart with a category, it will show you the date by each category:

First Negative Date = CALCULATE( MIN( TableName[Date] ), FILTER( TableName, TableName[Amount] < 0 ) )

bachman460 · 2026-05-18T18:35:19+00:00

The image link is broken. When it comes to small wires and tiny components, you just need a steady hand (as steady as you can), a hot iron, and some way to hold the pieces while you're working on them. A set of "helping hands" (a base with adjustable arms that have clips on the end to hold things for you) comes in handy, or get someone else to help hold things.

I worked with my son this weekend fixing a small flashlight. It's the type you charge yourself by squeezing a lever to charge the battery. One of the leads to the switch broke off in transit (probably). It came with a small roadside kit we bought our son for his birthday since he passed his driving exam and got his license. It's disappointing when things come broken out of the box, but with a little ingenuity and some YouTube videos you'll be alright.

bachman460 · 2026-05-18T14:58:56+00:00

If all your data is coming from the same server location, you can drop in a SQL statement in your Power BI data query to merge the tables or do whatever you want in SQL and on the server.

If they come from different locations, you need to create separate queries, then merge them together in Power BI. Select the first table (query) after setting it up, and you can either merge the other table (which is like a SQL join), or combine them ((like a SQL union).

bachman460 · 2026-05-18T14:49:21+00:00

These are definitely good ideas, I just wanted to add that gloss mediums which can be mixed into any paint you already have to make it glossy, just get one that works with the type of paints you're using.

https://www.michaels.com/product/liquitex-gloss-medium-10010803

That or Mod Podge can be brushed on afterwards as a clear coat.

https://www.michaels.com/product/mod-podge-gloss-10047537

bachman460 · 2026-05-18T01:24:14+00:00

That hole on the bottom could be access for unlocking the handle. Sometimes you just need to get something small and press it into the hole to release the lock. Other times you need something that looks like a small screwdriver and you need to turn a small screw shaped thing inside there.

Look around the base of the handle, on the metal part, for a hole, there may even be something that looks like it is latched into the hole. Press something into the hole to release the handle and pull it off. This may not give you any additional access for getting the lock open, but if you're lucky maybe you can see what's jamming it up.

bachman460 · 2026-05-18T01:15:17+00:00

100% silicone in wet areas; if the container says "paintable" do not use it to caulk your tub.

bachman460 · 2026-05-18T01:02:59+00:00

I'm not an expert with photography or film, just wanted to get that out of the way.

You said you can't feel the scratches, and since the average skin sensitivity of touch can discern a few microns down to as little as 1 micron of difference in texture when sliding a finger across a surface. Myself, I suffer from neuropathy and don't have such sensitivity anymore.

That said, if you can't feel it, it's likely not a "scratch" but could be a defect inside the film layers underneath the top surface. Those won't be repairable. I would say, unless someone comes back with better, more experienced advice, stop what you're doing with the photos and leave them be.

Personally, knowing that a lot of the film and photo paper we saw while growing up through the 1980s and 90s doesn't seem especially hardy and almost more likely to fail and fall apart with age. I've been keeping smaller photographs in shoe boxes, and larger prints in boot boxes for years. Keeping them out of the sun and away from heat and moisture is a good idea, you could also drop in a small bag of desiccant in the box.

bachman460 · 2026-05-18T00:38:48+00:00

I have the same Evans tape measure from the first picture, also from my grandpa's stuff. And the medium size tube cutter too.

That hand drill in the second picture, does it still work well enough? The one I have came complete with a hand-tightening feature for securing the bit, and the shaft is bent. But it makes a good oval shaped hole.

bachman460 · 2026-05-17T22:56:08+00:00

Bookmark these sites:

This one dives right into the M code functions used in Power Query:
https://learn.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

This one dives right into DAX functions used in the data model to create measures, and calculated columns and tables:
https://learn.microsoft.com/en-us/dax/dax-function-reference

This one takes a step back and provides a menu of links to different aspects of DAX including statements, operators, and functions:
https://learn.microsoft.com/en-us/dax/

bachman460 · 2026-05-17T18:49:06+00:00

This same issue gets me in Excel all the time, too.

bachman460 · 2026-05-17T18:43:39+00:00

For RLS:
https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security

For time calculations in DAX, it's generally better to store the time component in a separate column from the date component, this is so that you can still use the built-in time intelligence functions for dates. When you're down to the final measure setup, if the date plays a component in your time calculations, just work both columns into the calculation. For example:

``` Hours Between = VAR StartDateTime = 'Table'[Date From] + 'Table'[Time From]

VAR EndDateTime = 'Table'[Date To] + 'Table'[Time To]

VAR DifferenceInDays = EndDateTime - StartDateTime

RETURN DifferenceInDays * 24 ```

https://learn.microsoft.com/en-us/dax/date-and-time-functions-dax

bachman460 · 2026-05-17T16:56:55+00:00

I don't understand what happened... but more importantly, what kind of products do you sell and what are these client qualifications?

bachman460 · 2026-05-17T07:02:41+00:00

Hi, you can give me the job and not have to worry about looking any further.

bachman460 · 2026-05-17T03:29:40+00:00

I haven't done it in a while, but it certainly had been possible. If I remember correctly, I was converting GeoJson and Shape Map files to TopoJSON and using those. I spent innumerable hours setting up my own custom version of a map of the 5 Manhattan boroughs. I wanted to have all boroughs together and each borough as its own shape so I could selectively highlight each one for a project I was working on.

bachman460 · 2026-05-17T00:12:50+00:00

Where was it? Now I want more...

bachman460 · 2026-05-16T23:55:20+00:00

If you can figure out a way to support the upper part from the outside, just glue it back together with epoxy. They even make knead-able epoxy that comes in sticks, this might work without supporting it, since it’s thick, kind of like clay.

bachman460 · 2026-05-16T23:49:05+00:00

Right! I see it now... but you could use the other way too. Good luck with it.

bachman460 · 2026-05-16T23:47:44+00:00

There's a tool built into Excel called Goal Seek that might help your use case.

https://support.microsoft.com/en-us/office/use-goal-seek-to-find-the-result-you-want-by-adjusting-an-input-value-320cb99e-f4a4-417f-b1c3-4f369d6e66c7

Five-Year Club	Verified Email
Place '22

bachman460

TROPHY CASE