Getting Ready For Placing Concrete In Wall Above Grade Beam For Building In SouthEastern Michigan -- ANAND Enterprises Project GSK_1J1502

.

I was at the job site this morning to look at the prep work for concrete placement in the wall above the Grade Beam. Also present at the site were Architect Mike Tsakoff, General Contractor Gary Sleiman, and Mike of CTS Foundations to check for general layout, grade elevations, and other site related and Architectural features.

The First Floor open-web top chord bearing steel joists will be fastened to bearing plates that will be anchored to the wall.

I present in the following pictures that I took during my field visit.

Readiness For Concrete Placement In Grade Beams For Building In SouthEastern Michigan -- ANAND Enterprises Project GSK_1J1502

.

The multi-span Grade Beam is along the entire periphery of the building and is supported on 12x53 H piles spaced at nominally 6 ft centers. The 12x53 members are used as soldier piles for the proposed 4 story building on the site of an earlier building that has since been demolished.

I was at the job site this morning to look at the prep work for concrete placement in Grade Beams. Also present at the site were Architect Mike Tsakoff, General Contractor Gary Sleiman, and Mike of CTS Foundations to check for general layout, grade elevations, and other site related and Architectural features.

I present in the following pictures that I took during my field visit

yogi_Compute Sum Of Hours For Persons By 'Name' And 'Surname' From Specified Date (say TODAY) Onward

Google Spreadsheet   Post  #2532

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-29-2018

question by: msmariaavlarez
https://productforums.google.com/forum/#!topic/docs/iKNdC2HkjTc;context-place=mydiscussions

Advanced SUMIF taking into account dates
Hello!!
As a continuation of the following post: https://groups.google.com/a/googleproductforums.com/d/msgid/docs/8763004d-6d90-4574-86a8-498021b955c4%40googleproductforums.com.

I'm trying to do SUMIFs across a whole sheet with two cells conditions.

This is the timings of people on day by day basis, and I want to get a summary within that spreadsheet that calculates the timings for each individual (they have name and surname across two different cells) but now I would like for the QUERY function to take into account the current date (e.g. A16:C22).

e.g. https://docs.google.com/spreadsheets/d/1T8p0VZ1VhTBA72LNTMwyYujy1o6WsDV5r_AW_lAmVQ8/edit?usp=sharing

Ben Liebrand mentioned is not a good idea to use merged cells, but how would you design it?

Also, Would it be possible to show the sum values but also add a breakdown of the hours showing the dates (e.g. A8:E13).?

Can anyone help?

Cheers!!!

Concrete Placement In Basement ICF Walls Of New House In Michigan -- ANAND Enterprises Project HomA1J1805

.
Concrete was placed on Oct-26-2018 by Michael Hanes Of Homes American Made between 11:30 AM and 5:00 PM. Following are some pictures taken during the concrete pour,

Engineering Evaluation For Permanent Foundation For Manufactured House In SouthEastern Michigan -- ANAND Enterprises Project SteK1J1801

I was at the project site today to look at this good looking manufactured home to confirm that the manufactured home has indeed been installed on a permanent foundation. The owner/builder wants to refinance the house and it is a HUD requirement that a manufactured home has a permanent foundation.

Engineering Evaluation Of Welded Beam Extension In New House In SouthEastern MI -- ANAND Enterprises Project HunP1J1801

.

I was at the project site on Mar-29-2018 to look at the welded beam extension in the new house under construction in Southeastern Michigan

In the following I present a few pictures that I took during my field visit

Engineering Evaluation Of Plywood Decking Subsequent To Long Exposure To Elements For New ICF House In SouthEastern MI -- ANAND Enterprises Project EneE1Bai_1

.

I was at the project site on Mar-26-2018 to look at the condition of the plywood decking of the house subsequent to long exposure to elements.

In the following I present some pictures of plywood decking that shows some damage, swelling, opening at seams, stripping,cracking etc -- the more severely damaged boards have been marked with a red x. 

ctures that I had during my field visit.