--- title: How do I log weather days from daily reports against the contract's anticipated weather allowance with AI? | AEC Agents url: https://aecagents.si/use-cases/weather-days-log-vs-contract-allowance description: Weather time is usually argued at the end of the job from memory. Many contracts set a monthly number of anticipated adverse weather days that are already in the schedule and only allow extra time for days beyond it, often only when weather stopped critical work for a set part of the day. Keep a log of every day weather affected work (from the daily reports, with recorded weather data and what was on the critical path), and have Copilot in Excel or Gemini in Google Sheets tally qualifying days by month against the allowance you type from your contract. Claude or ChatGPT can pull weather remarks out of daily reports into the log and draft the monthly weather letter. Whether a day qualifies, and any time request, stays with the scheduler and the project manager. last_modified: 2026-11-11 source: AEC Agents (free, open workflows; not engineering advice) --- [AI assists](https://aecagents.si/use-cases/weather-days-log-vs-contract-allowance#honesty-labels)Workflow guide · not independently tested # How do I log weather days from daily reports against the contract's anticipated weather allowance with AI? Weather time is usually argued at the end of the job from memory. Many contracts set a monthly number of anticipated adverse weather days that are already in the schedule and only allow extra time for days beyond it, often only when weather stopped critical work for a set part of the day. Keep a log of every day weather affected work (from the daily reports, with recorded weather data and what was on the critical path), and have Copilot in Excel or Gemini in Google Sheets tally qualifying days by month against the allowance you type from your contract. Claude or ChatGPT can pull weather remarks out of daily reports into the log and draft the monthly weather letter. Whether a day qualifies, and any time request, stays with the scheduler and the project manager. [Scheduler](https://aecagents.si/roles/scheduler) · Planning & scheduling · Claude · ChatGPT · Microsoft Excel · Microsoft Copilot · Google Sheets · NOAA Climate Data Online Content updated 11 November 2026 · Tool links listed below; vendor features and pricing change, so confirm with the vendor ## Short answer Use Copilot in Excel or Gemini in Google Sheets, plus Claude or ChatGPT: Claude or ChatGPT pulls weather remarks, hours lost and affected activities out of daily reports into a log and drafts the monthly weather letter; Copilot or Gemini marks each date against the qualifying rules you typed from your contract and tallies qualifying days by month against the anticipated allowance. Weather time is usually argued at the end of the job from memory. Many contracts set a monthly number of anticipated adverse weather days that are already in the schedule and only allow extra time for days beyond it, often only when weather stopped critical work for a set part of the day. Keep a log of every day weather affected work (from the daily reports, with recorded weather data and what was on the critical path), and have Copilot in Excel or Gemini in Google Sheets tally qualifying days by month against the allowance you type from your contract. Claude or ChatGPT can pull weather remarks out of daily reports into the log and draft the monthly weather letter. Whether a day qualifies, and any time request, stays with the scheduler and the project manager. A person still checks: the contract terms you typed, each qualifying day against the daily report and weather record, critical path calls from the schedule, and any notice or time request, with the project manager. ## AI tie-in **Tool:** Copilot in Excel or Gemini in Google Sheets, plus Claude or ChatGPT Claude or ChatGPT pulls weather remarks, hours lost and affected activities out of daily reports into a log and drafts the monthly weather letter; Copilot or Gemini marks each date against the qualifying rules you typed from your contract and tallies qualifying days by month against the anticipated allowance. ### Prompt 1 ``` Here are this month's daily reports [paste or upload]. Build a table with one row per date: date, weather remarks copied exactly, hours lost, crews sent home, activities affected. Write NOT STATED where a report says nothing. Do not judge whether a day qualifies as a weather day. ``` ### Prompt 2 ``` Here are the headers and a few sample rows of my Log tab [paste] and the rules and monthly allowance I typed from my contract [paste]. Write Excel formulas (or a step-by-step Copilot plan) that mark each date QUALIFIES, DOES NOT QUALIFY or REVIEW using only my rules, build a monthly table of qualifying days, anticipated days, excess and running total, and flag dates where the remarks and the recorded weather disagree. Do not use thresholds or allowances from memory and do not say whether time is owed. ``` **Human check:** The contract terms you typed, each qualifying day against the daily report and weather record, critical path calls from the schedule, and any notice or time request, with the project manager. ## The problem Log weather days from daily reports against the contract's anticipated weather allowance with AI. This is a common, time-consuming task for a scheduler. ## What this workflow does Weather time is usually argued at the end of the job from memory. Many contracts set a monthly number of anticipated adverse weather days that are already in the schedule and only allow extra time for days beyond it, often only when weather stopped critical work for a set part of the day. Keep a log of every day weather affected work (from the daily reports, with recorded weather data and what was on the critical path), and have Copilot in Excel or Gemini in Google Sheets tally qualifying days by month against the allowance you type from your contract. Claude or ChatGPT can pull weather remarks out of daily reports into the log and draft the monthly weather letter. Whether a day qualifies, and any time request, stays with the scheduler and the project manager. **How it works:** AI drafts or analyzes. A person operates the tools, checks the work, and takes action. **Your checkpoint:** The log counts days against rules you typed from your contract. It does not interpret the contract, prove a delay to the critical path or decide whether a time extension is owed. Qualifying days, critical path calls, notices and any request for time stay with the scheduler, the project manager and, where needed, counsel. ## Before you start - Access to the named tool; confirm license, version and cost with the vendor. - A small, non-confidential sample to try the workflow on first. - A qualified person to review the output before it is used. ### Tools and access - [Claude (Anthropic)](https://www.anthropic.com/claude) - [ChatGPT](https://chatgpt.com/) - [Microsoft Excel](https://www.microsoft.com/microsoft-365/excel) - [Microsoft Copilot](https://www.microsoft.com/microsoft-365/copilot) - [Google Sheets](https://workspace.google.com/products/sheets/) - [NOAA Climate Data Online](https://www.ncei.noaa.gov/cdo-web/) ## Follow the steps 1. Read your contract's weather clause and type its terms into a Settings tab in your own words: the anticipated days per month (from your copy, not from memory or the AI), the conditions it lists, the share of the workday that must be lost, whether dry-out days count, and the notice and reporting deadlines. 2. Export or collect the daily reports for the month. Have Claude or ChatGPT pull, for each date, the weather remarks, hours lost, crews sent home and activities affected into a Log tab, copying text exactly and writing NOT STATED where a report says nothing. 3. Add recorded weather for each date from a source your contract accepts (site station, or a nearby station on NOAA Climate Data Online), and add whether the affected activities were on the critical path in the current schedule update. You fill that column from the schedule. 4. Have Copilot in Excel or Gemini in Google Sheets mark each date QUALIFIES, DOES NOT QUALIFY or REVIEW using only the rules on your Settings tab, then tally by month: qualifying days, the allowance, the difference and the running total carried forward if your contract allows it. 5. Mark dates where the daily report and the weather record disagree, and dates with lost time but no critical work recorded, for you to review before anything goes out. 6. Have Claude or ChatGPT draft the monthly weather letter from the tally, including months with no excess days if the contract asks for those. The project manager edits and sends it, and records each weather day as an impact activity in the schedule if that is your practice. ## Try a small example Replace the bracketed fields with your own project details. No tested sample run is published for this workflow yet. ### Sample input ``` Fill in the bracketed [fields] in the text below with your project data. ``` ### Starter prompt ``` Here are the headers and a few sample rows of my Log tab [paste: date, weather remarks, hours lost, activities affected, critical path yes or no, recorded precipitation, recorded wind, recorded temperature] and my Settings tab [paste the anticipated days per month and the qualifying rules I typed from my contract]. Write Excel formulas (or a step-by-step Copilot plan) that mark each date QUALIFIES, DOES NOT QUALIFY or REVIEW using only my Settings rules, and build a monthly table with qualifying days, anticipated days, excess days and a running total. Flag dates where the remarks report lost time but the recorded weather is below my thresholds, or the reverse. Do not use any thresholds or monthly allowances from memory and do not say whether time is owed. ``` ### Expected output ``` Not published yet. Treat any output as a draft and check it against the source documents. ``` ## Check the result - Every value, citation or quantity traces back to a source document. - Missing information is marked as missing, not filled in. ## Limits and recovery - The log counts days against rules you typed from your contract. It does not interpret the contract, prove a delay to the critical path or decide whether a time extension is owed. Qualifying days, critical path calls, notices and any request for time stay with the scheduler, the project manager and, where needed, counsel. - Check your organization’s data policy before sharing project files with third-party tools. **Stop or switch when:** The source cannot be verified, permissions are missing, or the result contains unsupported facts. ## Frequently asked questions How does AI help with this? Copilot in Excel or Gemini in Google Sheets, plus Claude or ChatGPT: Claude or ChatGPT pulls weather remarks, hours lost and affected activities out of daily reports into a log and drafts the monthly weather letter; Copilot or Gemini marks each date against the qualifying rules you typed from your contract and tallies qualifying days by month against the anticipated allowance. A person still checks: The contract terms you typed, each qualifying day against the daily report and weather record, critical path calls from the schedule, and any notice or time request, with the project manager. How do I how do I log weather days from daily reports against the contract's anticipated weather allowance with AI?? Read your contract's weather clause and type its terms into a Settings tab in your own words: the anticipated days per month (from your copy, not from memory or the AI), the conditions it lists, the share of the workday that must be lost, whether dry-out days count, and the notice and reporting deadlines. Export or collect the daily reports for the month. Have Claude or ChatGPT pull, for each date, the weather remarks, hours lost, crews sent home and activities affected into a Log tab, copying text exactly and writing NOT STATED where a report says nothing. Add recorded weather for each date from a source your contract accepts (site station, or a nearby station on NOAA Climate Data Online), and add whether the affected activities were on the critical path in the current schedule update. You fill that column from the schedule. The full step list is above. Does this use an AI agent or regular software? It is labeled AI assists: AI drafts or analyzes. A person operates the tools, checks the work, and takes action. What tools do I need? Claude, ChatGPT, Microsoft Excel, Microsoft Copilot, Google Sheets, NOAA Climate Data Online. Confirm license, version and cost with the vendor, and try it on a small non-confidential sample first. Has this workflow been tested? Workflow guide · not independently tested. Written from vendor documentation and practitioner use. Labels apply to the steps described here, not every feature of a product. Links were checked when the page was written. ## Where to go next - [How do I compare two P6 schedule updates and list every date, duration, logic and float change with an AI-written script?](https://aecagents.si/use-cases/schedule-update-comparison-xer) - [How do I pull actual start and finish dates from daily reports into the schedule update with AI?](https://aecagents.si/use-cases/daily-reports-to-schedule-actual-dates) - [How do I capture site progress and topography with drone mapping?](https://aecagents.si/use-cases/drone-site-surveys) - [All Scheduler workflows](https://aecagents.si/roles/scheduler) - [All Field, quality and safety workflows](https://aecagents.si/tasks/field-safety) ## Evidence and maintenance Written from vendor documentation and practitioner use. Labels apply to the steps described here, not every feature of a product. Links were checked when the page was written. - [Claude (Anthropic) (vendor site)](https://www.anthropic.com/claude) - [ChatGPT (vendor site)](https://chatgpt.com/) - [Microsoft Excel (vendor site)](https://www.microsoft.com/microsoft-365/excel) - [Microsoft Copilot (vendor site)](https://www.microsoft.com/microsoft-365/copilot) - [Google Sheets (vendor site)](https://workspace.google.com/products/sheets/) - [NOAA Climate Data Online (vendor site)](https://www.ncei.noaa.gov/cdo-web/) ## Put it to work Start with a small sample and keep the original record open while you verify the result. ## Know what does the work. Agent executes : An AI agent calls connected tools to carry out bounded actions. You set permissions and review the result. AI assists : AI drafts or analyzes. A person operates the tools, checks the work, and takes action. Conventional automation : Rules or specialist software perform the task. No AI agent is required.