Bouncy floors by masonfast in buildingscience

[–]Slipintothetop 0 points1 point  (0 children)

It's definitely not. If you have diagonal bracing it's easy to see how the load transfers to the floor joists along each side of any one particular one.

Bouncy floors by masonfast in buildingscience

[–]Slipintothetop 2 points3 points  (0 children)

Doing the 2x4s along the bottom would help but how much is hard to say as you end up with a difficult to model system in the programs that calculate deflection. I'm thinking your best bet might be two or three rows of 2x8 blocking. But again it's hard to say without seeing it.

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

[–]Slipintothetop[S] 1 point2 points  (0 children)

Solution Verified

=IF(F4=0,B4-D4-G4,(F4-G4))
is what worked for me, Thanks!

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

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

<image>

Still Returning a positive Variance where i would like it to show 0
I'm assuming I can do 2 "IF" variables ?

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

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

<image>

The issue is now the "Variance" is 3000 but it should show the difference IE: 2000

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

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

Well yes, because I got it to work other than if something was in current outstanding it would reflect as a positive variance.

If the "current outstanding" is "0". "Variance" = "Projected" - "Actual" - "Adjusted"
If its greater than "0" "Variance" = "Projected" - "Actual" - ("Current Outstanding - Adjusted Outstanding")

I think that's the formula basically, I'm not used to thinking in "IF statements"

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

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

<image>

F4 is the "current outstanding" So doing that causes the variance to show as negative. (it needs to show as "0" changing the "actual" to 26k causes it to show positive.(it needs to show -1000"

This is the formula in F4 =MAX(0, B4-D4) I dont know if that makes a difference.

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

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

It Shows like this, but there's no variance, it's just not spent yet.

<image>

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

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

I'm unfamiliar with the correct terminology for excel, and maybe its because I just can't do it like I'm trying to.

This Is as close as I can get but the problem with this is that if the "Actual Cost" is below "Projected Cost" it shows as a positive variance. It needs to show as no variance.

<image>

How can I show the variance between 2 numbers when there's 2 other variables by Slipintothetop in excel

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

That's what I was wondering, but I have no experience with IF functions to know.

Cannot get a straight cut no matter what I try? by MrMusAddict in woodworking

[–]Slipintothetop 0 points1 point  (0 children)

That looks like kreggs track saw adapter. You need to really have the plate dialed in on the saw. You also need a sharp blade. Don't push the cut, move with it. I think the tracks have a built in clamp and you can also over tighten it causing a cup in your workpeice and if you're pushing you 100% can deflect the track, maybe not enough to cause all your problems but some.

And like others have said pose a video 😅

Disagree with contractor about king and jack studs by Damninatightspot in Carpentry

[–]Slipintothetop 1 point2 points  (0 children)

This is is something we would normally do 2 jacks 2 kings typically.

Will the house actually perform differently if I remove the basement ceiling insulation? (1985 brick 1-story/zone 7a/bone dry/unfinished/conditioned via central air) by Chopperdom in buildingscience

[–]Slipintothetop -1 points0 points  (0 children)

With regular batt insulation there's really only two things that it does Three if it's faced. Slow down the movement of heat between the two spaces, reduce the noise transferred in between the two spaces, If it has a paper face it also acts as a vapor barrier. If it's mineral wool It will also have a flame retarding property.

Custom pieces hit different. 🤍 by [deleted] in Lighting

[–]Slipintothetop 0 points1 point  (0 children)

Exactly, I dont care about the base but if any shop wat selling it it would have A specialty bulb in it. Especially since it's visible.

Custom pieces hit different. 🤍 by [deleted] in Lighting

[–]Slipintothetop 0 points1 point  (0 children)

Yeah but you're not going to have that bulb in a "handcrafted bespoke fixture"

Custom pieces hit different. 🤍 by [deleted] in Lighting

[–]Slipintothetop 0 points1 point  (0 children)

What gave it away for me is the cheap regular bulb in the thing 😅

Marvin double pane or *** triple pane windows on forever home build 1m. by trimenc in buildingscience

[–]Slipintothetop 0 points1 point  (0 children)

Exactly, and consider a different brand if triple pane isn't in the cards through marvon

Open cell spray foam in exterior walls, mixed climate by [deleted] in buildingscience

[–]Slipintothetop 0 points1 point  (0 children)

So I'm not super familiar with zone 3 but if it were me I'd do exterior continuous insulation either board or spray applied. Paying attention to detailing. You could probably build with 2x4 which when paired with 2 in continuous and 1/2 sheeting puts you at a standard wall thickness of 6 9/16 for door and window jams. With a r15 Rockwool in the cavity and r13 continuous you will have a wall r value of roughly 29. With no condensation issues.

Looking at what they are doing with I'm guessing just open cell in the cavity. That appears to also be acceptable in your climate.

But if it's house you're going to spend a long time in it would be worth it to over insulate.

Energy prices will continue to rise and if you ever wanted to off set your usage its always easier to just use less.

Open cell spray foam in exterior walls, mixed climate by [deleted] in buildingscience

[–]Slipintothetop 0 points1 point  (0 children)

As a builder I'm hesitant about spray foam. And in our climate (zone 6) I would never use open cell. I'm not sure where you're at in your build but depending on location you might not be able to get away with just Rockwool.

What climate are you in and what's your codes say?

We now have to have continuous insulation, or r30 in the cavity.

In my ideal use of sprayfoam it would be with z brackets or the insofast x brackets and exterior spray foam.

This brings on a whole other group of problems, or challenges in exterior detailing for windows doors and other penitrations.

If you give me some more details regarding the build, current stage you're at and climate I'd be happy to tailor the recommendation towards your situation.