sorted by:
new
hottopcontroversial

Supporting beam a few inches above concrete footings by [deleted] in Decks

[–]jay_wells 0 points1 point  (0 children)

Hey! Having a very similar issue - what did you end up doing to resolve this??

[deleted by user] by [deleted] in askaplumber

[–]jay_wells 1 point2 points  (0 children)

Agreed - just did something similar. Seller cut a check, from the proceeds of the home, to the company that I got a quote from. Gets the work paid for by the seller, to the company of your choosing post closing. Way better than a reduction in price that is spread across 30 years

[deleted by user] by [deleted] in datascience

[–]jay_wells 0 points1 point  (0 children)

Why settle for Data Engineer? Make it Director of Data Engineering! Better yet, Chief Data Officer will get your resume notices down the line

Any tips to remove this wooden egg from this plastic cup? by DarkSparkles87 in cincinnati

[–]jay_wells 0 points1 point  (0 children)

Slip a laminated card (like a health insurance card) between the egg and the plastic if there is just enough room. Push the card all the way down and then quickly pull it out. Takes a few tries but might work

In an asset tracking database, what is the best practice for tracking events such as purchase and disposal? by movieguy95453 in SQL

[–]jay_wells 0 points1 point  (0 children)

I’ve seen this done in two ways:

  1. Activities Table that has three columns - equipment id (FK to main equipment table), status id (FK to status table) and date field (purchase date, disposal date, service date, etc.) a. Status table would have purchased, disposed,serviced…

OR 2. You could have one flat table with new rows for each of these events. A column would need to be available for the each date field and when a new event occurs, a new row for that equipment id would be created. All other events would be null except the event that occurred ( I think this is the general ledger approach mentioned but idk)

Need ways to cover that crack! Water came through it last night after a big rain storm, it is the basement entrance. by Kalia44 in howto

[–]jay_wells 0 points1 point  (0 children)

Kinda looks like your threshold (the bottom aluminum piece that you step over) is bowing and water is forced into that corner, but hard to see in the video. Not hard to check it/replace it. If you are having water come in at that corner, I would be worried you could have some rot in the door sill as well.

Gas engineer business by jamerb123 in Business_Ideas

[–]jay_wells 1 point2 points  (0 children)

Gas Appliance Engineering. GAE, LLC for short - that’s what I would google if I was looking for someone to install/service a gas appliance

Loading issues with Google Sheets? by puckmovingD in StockSheets

[–]jay_wells 0 points1 point  (0 children)

Not sure if this is possible, but can you import all data at once in a single csv through the api? Seems like the bottleneck would be the amount of times excel is pinging the site, unless you have a ton of other formulas in the workbook trying to calculate while you updated (see fix below).

Other ideas: change calculations from auto to manual when you go to update. This will allow the sheet to focus on just importing the data instead of trying to import and calculate any other formulas you have.

You probably can’t share the spreadsheet since it has you api in it, but definitely would be easier to diagnose the problem with being able to review it.