[2026-06-03T20:54:12.756155+00:00] autoquoter.INFO: step {"message":"Received request","keys":["buildingConstructionType","buildingFinish","buildingGrossSquareFootage","buildingNewRenoAddition","buildingOccupancyType","buildingStart","buildingsTotal","buildingTotalBuildings","buildingTotalFloorsAbove","buildingTotalFloorsBelow","formName","projectCity","projectEstBuildingEnclosure","projectEstWaterMain","projectFinish","projectName","projectStart","projectState","projectStreet","submissionDate","submissionTime","typeOfTechnology","underwriterEmail","underwriterName"]} []
[2026-06-03T20:54:12.757023+00:00] autoquoter.INFO: step {"message":"Starting autoquote job","folderIdentity":"Itforless test","folder":"12 AutoQuoting submissions/Form Submissions/itforless-test-20260603-205412"} []
[2026-06-03T20:54:12.757061+00:00] autoquoter.INFO: step {"message":"Resolving site"} []
[2026-06-03T20:54:12.757083+00:00] autoquoter.INFO: step {"message":"Fetching Graph token"} []
[2026-06-03T20:54:14.805237+00:00] autoquoter.INFO: step {"message":"Creating folder","folder":"itforless-test-20260603-205412"} []
[2026-06-03T20:54:15.670750+00:00] autoquoter.INFO: step {"message":"Copying template","source":"12 AutoQuoting submissions/TechBD Rater.xlsx","target":"TechBD Rater-itforless-test-20260603-205412.xlsx"} []
[2026-06-03T20:54:20.360341+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"A4","value":"2026-06-03","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:20.442540+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"B4","value":"4:54 PM","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:20.540816+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"E4","value":"Itforless test","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:20.616041+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"F4","value":"lisa.behning@insightrisktec.com","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:20.737502+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"G4","value":"Yes","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:20.812758+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"H4","value":"No","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:20.885645+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"I4","value":"No","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:20.958897+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"J4","value":"No","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.024791+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"R4","value":"itforless test","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.097056+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"S4","value":"abcd","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.177156+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"T4","value":"Illinois","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.247778+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"V4","value":"US","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.332287+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"X4","value":"2026-05-31","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.402936+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"Y4","value":"2026-06-29","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.496122+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"I9","value":"2026-06-29","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.569858+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"J9","value":"2026-05-31","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.641767+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"Z4","value":"10","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.710783+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"G9","value":"2026-05-31","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.782578+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"H9","value":"2026-06-29","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:21.922924+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"K9","value":"Wood Frame (spread)","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:22.013577+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"M9","value":"Modular","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:22.086854+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"O9","value":"New","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:22.157443+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"W9","value":"100","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:22.238429+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"Y9","value":"10","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:22.316429+00:00] autoquoter.INFO: step {"message":"Updating cell range","range":"Z9","value":"5","sheet":"Data_Input_Table"} []
[2026-06-03T20:54:22.384451+00:00] autoquoter.INFO: step {"message":"Refreshing workbook","itemId":"01LC73GKD6IZJY5EA5H5BKH2AP7N5CXWQL"} []
[2026-06-03T20:54:22.438923+00:00] autoquoter.INFO: step {"message":"Triggering workbook calculation","calculationType":"FullRebuild","itemId":"01LC73GKD6IZJY5EA5H5BKH2AP7N5CXWQL"} []
[2026-06-03T20:54:27.609554+00:00] autoquoter.INFO: step {"message":"WORKSHEET LIST","worksheets":["DBB_Instructions","Data_Input_Table","Application","Puck Calculation","T_Data_Entry","T_Summary_Page","T_Labor","T_Temp_water","T_Flow_Shutoff","T_RoR","T_Motion","work done","DBB_Refer","Underwriting Rater","Project Specific Rater","Contractor Member","Owner Member","InfoLookups","DBB_County_Lookup","Taxes & fees","Data_Output_tables","Carrier_Tech_Proposal","DA_Solution_1","DA_Solution_2","DA_Solution_3","Project_DA","Project_2sol_DA","Project_sol1_DA","Project_sol3_DA","McGill_Tech","McGill_Alliant_Tech","McGill_Aliant_DA","Lockton_Tech"]} []
[2026-06-03T20:54:27.609648+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"Q8"} []
[2026-06-03T20:54:27.676189+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"Q8","key":"solution1Cost","value":6007} []
[2026-06-03T20:54:27.676273+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"R8"} []
[2026-06-03T20:54:27.741570+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"R8","key":"solution1PerAdditionalMonth","value":835} []
[2026-06-03T20:54:27.741645+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"S8"} []
[2026-06-03T20:54:27.806685+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"S8","key":"solution2Cost","value":8708} []
[2026-06-03T20:54:27.806765+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"T8"} []
[2026-06-03T20:54:27.869522+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"T8","key":"solution2PerAdditionalMonth","value":1127} []
[2026-06-03T20:54:27.869602+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"U8"} []
[2026-06-03T20:54:27.942221+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"U8","key":"solution3Cost","value":15386} []
[2026-06-03T20:54:27.942294+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"V8"} []
[2026-06-03T20:54:28.025419+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"V8","key":"solution3PerAdditionalMonth","value":1143} []
[2026-06-03T20:54:28.025492+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"Q8"} []
[2026-06-03T20:54:28.131802+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"Q8","key":"waterTechFee","value":6007} []
[2026-06-03T20:54:28.131920+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"W8"} []
[2026-06-03T20:54:28.197264+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"W8","key":"highHeatDetectionFee","value":0} []
[2026-06-03T20:54:28.197362+00:00] autoquoter.INFO: step {"message":"Fetching cell range","sheet":"Carrier_Tech_Proposal","range":"Y8"} []
[2026-06-03T20:54:28.258572+00:00] autoquoter.INFO: step {"message":"Fetched quote value","sheet":"Carrier_Tech_Proposal","cell":"Y8","key":"intrusionFee","value":0} []
[2026-06-03T20:54:28.258685+00:00] autoquoter.INFO: step {"message":"Quote validation check","selectedQuote":6007.0,"requiresManualReview":true} []
[2026-06-03T20:54:28.258721+00:00] autoquoter.INFO: step {"message":"Closing workbook session","itemId":"01LC73GKD6IZJY5EA5H5BKH2AP7N5CXWQL"} []
[2026-06-03T20:54:40.975690+00:00] autoquoter.INFO: step {"message":"PDF GENERATED","size":2225454,"sheet":"Carrier_Tech_Proposal"} []
[2026-06-03T20:54:40.981076+00:00] autoquoter.INFO: step {"message":"Pruned PDF pages","sheet":"Carrier_Tech_Proposal","keptPages":[46,47,48],"totalPages":119} []
[2026-06-03T20:54:40.981588+00:00] autoquoter.INFO: step {"message":"Saved local PDF copy","path":"/tmp/autoquote_pdfs/Carrier Tech Proposal.pdf","file":"Carrier Tech Proposal.pdf"} []
[2026-06-03T20:54:42.028552+00:00] autoquoter.INFO: step {"message":"Uploaded PDF","sheet":"Carrier_Tech_Proposal","file":"Carrier Tech Proposal.pdf"} []
[2026-06-03T20:54:42.028672+00:00] autoquoter.INFO: step {"message":"Skipping missing sheet","sheet":"Final_Estimate"} []
[2026-06-03T20:54:45.379237+00:00] autoquoter.INFO: step {"message":"PDF GENERATED","size":2225454,"sheet":"T_Data_Entry"} []
[2026-06-03T20:54:45.379949+00:00] autoquoter.INFO: step {"message":"Saved local PDF copy","path":"/tmp/autoquote_pdfs/T_Data_Entry-pdf.pdf","file":"T_Data_Entry-pdf.pdf"} []
[2026-06-03T20:54:47.218060+00:00] autoquoter.INFO: step {"message":"Uploaded PDF","sheet":"T_Data_Entry","file":"T_Data_Entry-pdf.pdf"} []
[2026-06-03T20:54:50.148733+00:00] autoquoter.INFO: step {"message":"Closing workbook session","itemId":"01LC73GKD6IZJY5EA5H5BKH2AP7N5CXWQL"} []
[2026-06-03T20:54:50.391249+00:00] autoquoter.INFO: step {"message":"Processing failed","error":"Client error: `POST https://hooks.zapier.com/hooks/catch/25741504/4bfpuah/` resulted in a `404 Not Found` response:\nplease unsubscribe me!\n"} []