+ Reply to Thread
Results 1 to 8 of 8

Needing a formula that I can input into excel for Concrete Maturity

  1. #1
    Registered User
    Join Date
    07-03-2018
    Location
    Everett, Wa
    MS-Off Ver
    Newest
    Posts
    2

    Smile Needing a formula that I can input into excel for Concrete Maturity

    Greetings everyone! Im in sorts of a pickle, and require some assistance as to save time on this project of mine. Im testing for concrete maturity, and the probes that we used were not the correct ones, not logging a critical value during testing, which is called the Maturity, or Time Temperature Factor. Can anyone give me a function of formula that I can easily place into a work sheet? Any assistance would be most helpful. Below is the formula

    M(t)=Σ(Ta-To)ΔT

    M(t)= Time Temp Factor
    ΔT = Time interval, days or hours
    Ta = Average Concrete Temp during time interval
    To = Datum Temp (Usually stays as a zero value, 'C)

    I have also attached a worksheet that has maturity values inputted from the correct probe, and the other attachment is an example of the data stream and what is missing.
    Attached Files Attached Files
    Last edited by Lokasjoa; 07-03-2018 at 10:00 AM. Reason: Additonal info

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Needing a formula that I can input into excel for Concrete Maturity

    What values are known?

    I'd recommend uploading sample workbook, along with few sample of manually calculated result.

    To upload file, use "Go Advanced" button found at bottom right of Edit/Quick Reply screen. And follow "Manage Attachment" hyperlink. It will launch new tab/window.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    07-03-2018
    Location
    Everett, Wa
    MS-Off Ver
    Newest
    Posts
    2

    Re: Needing a formula that I can input into excel for Concrete Maturity

    I have uploaded the two sheets that I have been currently tasked with deciphering.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Needing a formula that I can input into excel for Concrete Maturity

    In "ST2D3476S A sn8422248"

    First, you'd convert °C to F using...
    In C19: Copy down
    =(B19-32)/9*5

    Then in D19: Copy down.
    =(Average($B$19:B19)-0)*A19

    This will give relatively accurate Maturity (°C-Hrs).
    Validate it against Lot 148's Maturity (°C-Hrs), by using same calculation.

    Max absolute variance around 4.2, but since I don't know the industry standard... you'll have to decide if this is acceptable.

  5. #5
    Registered User
    Join Date
    07-05-2018
    Location
    austin, tx
    MS-Off Ver
    2016
    Posts
    2

    Re: Needing a formula that I can input into excel for Concrete Maturity

    NOTE to OP: The conversion to C is correct, but the maturity calcs recommended by CK76 would definitely not be correct, and is actually grossly overestimating the concrete maturity.
    ΔT is the data interval, not the accumulated time.
    In your case, the ΔT is 1 hour. (This, however, is not the ASTM C1074 recommended ΔT, which is 0.5 hours or less.)
    Also, Ta is not supposed to be an average of all the temperature values up to the current time, but an average of the temperatures across the ΔT.
    Additionally, the formula recommended by CK76 is using the F values, and not the C values they had you convert in row C.

    A more accurate formula would be to enter "0" in D19
    In D20 enter the formula =(AVERAGE(C19:C20)-0)*1
    In D21 enter the formula =(AVERAGE(C20:C21)-0)*1+F20, and then copy down.

    Your Time Temperature Factor at 24 hours is approximately 608 C-Hr.

    Note that the maturity method is a mix-specific test. Each mix must be calibrated as per ASTM C 1074. If you have a target maturity value, it was determined using a specific datum temperature for this mix. That could be a default value like 0C, but it is important to confirm this against the original maturity calculations used to calibrate for this specific mix design.

    I hope this helps, feel free to reply here or PM me with questions. I would also recommend you find a new system. COMMAND Center is a superior alternative to the system you are using currently. It is more affordable, much easier to implement, and offers much more flexibility in terms of data collection. The sensors can be used for both temperature and maturity monitoring, so you will never have the issue you are currently experiencing where you have the "wrong" sensor for the job. Switching systems is easy, because COMMAND Center includes free software specifically designed for concrete temperature, maturity, and strength analysis, and you can use your own devices (Windows or iOS) to collect data from the sensors.

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Needing a formula that I can input into excel for Concrete Maturity

    Glad someone more knowledgeable in the field came to help

    Though I'm not sure what you mean by below.
    Additionally, the formula recommended by CK76 is using the F values, and not the C values they had you convert in row C.
    See attached files with formula applied.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-05-2018
    Location
    austin, tx
    MS-Off Ver
    2016
    Posts
    2

    Re: Needing a formula that I can input into excel for Concrete Maturity

    Happy to chime in! You were pretty close there. As far as the statement you mentioned, I was referring to your recommendation of:
    Then in D19: Copy down.
    =(Average($B$19:B19)-0)*A19
    Since the the Celsius values are what we are intending to use (assuming the OP wants the TTF values in C-Hr), I believe what you meant to use was the Celsius values you had him convert in row C.

  8. #8
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Needing a formula that I can input into excel for Concrete Maturity

    Ah, thanks. I had missed the typo.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mark concrete day before end
    By Jose123456 in forum Excel General
    Replies: 4
    Last Post: 05-07-2018, 05:30 AM
  2. Help with Graph for Concrete Beams
    By carlitosperez in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-08-2017, 03:11 PM
  3. Replies: 2
    Last Post: 03-10-2017, 12:56 AM
  4. Making space before concrete word
    By rolex in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2015, 10:49 AM
  5. Making space before concrete word
    By rolex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2015, 09:51 AM
  6. How much time for Concrete Truck
    By herbieinla in forum Excel General
    Replies: 6
    Last Post: 03-27-2009, 10:54 AM
  7. [SOLVED] Concrete Job V Program
    By concrete lady in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-02-2005, 02:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1