n8n_6_使用LLM为Revit和IFC进行施工造价估算
高级
这是一个AI Summarization, Multimodal AI领域的自动化工作流，包含 55 个节点。主要使用 If, Set, Code, Merge, ManualTrigger 等节点。 使用GPT-4和Claude基于Revit/IFC模型估算施工成本
前置要求
- •OpenAI API Key
- •Anthropic API Key
使用的节点 (55)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "Z1UKztds8E5oQSMe",
"meta": {
"instanceId": "faa70e11b7175129a74fd834d3451fdc1862589b16d68ded03f91ca7b1ecca12",
"templateCredsSetupCompleted": true
},
"name": "n8n_6_使用LLM为Revit和IFC进行施工造价估算",
"tags": [],
"nodes": [
{
"id": "44ac22bc-92ff-450d-ac53-b2b587cc0318",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
944,
-64
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2b81e046-ebc1-4687-8fd2-b9d2a3347a12",
"name": "查找分类字段1",
"type": "n8n-nodes-base.code",
"position": [
1360,
768
],
"parameters": {
"jsCode": "\nconst items = $input.all();\nif (items.length === 0) {\n return [{json: {error: 'No grouped data found'}}];\n}\n\n\nconst headers = Object.keys(items[0].json);\n\n\nconst categoryPatterns = [\n { pattern: /^category$/i, type: 'Category' },\n { pattern: /^ifc[\\s_-]?type$/i, type: 'IFC' },\n { pattern: /^host[\\s_-]?category$/i, type: 'Host' },\n { pattern: /^ifc[\\s_-]?export[\\s_-]?as$/i, type: 'Export' },\n { pattern: /^layer$/i, type: 'Layer' }\n];\n\nlet categoryField = null;\nlet categoryFieldType = 'None';\n\n\nfor (const header of headers) {\n for (const {pattern, type} of categoryPatterns) {\n if (pattern.test(header)) {\n categoryField = header;\n categoryFieldType = type;\n break;\n }\n }\n if (categoryField) break;\n}\n\n\nconst volumetricPatterns = /volume|area|length|count|quantity|thickness|perimeter|depth|size|dimension|weight|mass/i;\nconst volumetricFields = headers.filter(header => volumetricPatterns.test(header));\n\n\nconst categoryValues = new Set();\nif (categoryField) {\n items.forEach(item => {\n const value = item.json[categoryField];\n if (value && value !== '' && value !== null) {\n categoryValues.add(value);\n }\n });\n}\n\nconsole.log('Category field analysis:');\nconsole.log('- Field found:', categoryField || 'None');\nconsole.log('- Field type:', categoryFieldType);\nconsole.log('- Unique values:', categoryValues.size);\nconsole.log('- Volumetric fields:', volumetricFields.length);\n\n\nreturn [{\n json: {\n categoryField: categoryField,\n categoryFieldType: categoryFieldType,\n categoryValues: Array.from(categoryValues),\n volumetricFields: volumetricFields,\n groupedData: items.map(item => item.json),\n totalGroups: items.length\n }\n}];"
},
"typeVersion": 2
},
{
"id": "65f07357-2e47-41ac-87ee-43d692b7511d",
"name": "对分组应用分类1",
"type": "n8n-nodes-base.code",
"position": [
1872,
832
],
"parameters": {
"jsCode": "\nconst categoryInfo = $node['Find Category Fields1'].json;\nconst groupedData = categoryInfo.groupedData;\nconst categoryField = categoryInfo.categoryField;\nconst volumetricFields = categoryInfo.volumetricFields || [];\n\n\nlet classifications = {};\nlet buildingCategories = [];\nlet drawingCategories = [];\n\ntry {\n const aiResponse = $input.first().json;\n const content = aiResponse.content || aiResponse.message || aiResponse.response || '';\n \n const jsonMatch = content.match(/\\{[\\s\\S]*\\}/);\n if (jsonMatch) {\n const parsed = JSON.parse(jsonMatch[0]);\n classifications = parsed.classifications || {};\n buildingCategories = parsed.building_categories || [];\n drawingCategories = parsed.drawing_categories || [];\n console.log(`AI classified ${Object.keys(classifications).length} categories`);\n console.log(`Building categories: ${buildingCategories.length}`);\n console.log(`Drawing categories: ${drawingCategories.length}`);\n }\n} catch (error) {\n console.error('Error parsing AI classification:', error.message);\n}\n\n\nreturn groupedData.map(group => {\n let isBuildingElement = false;\n let reason = '';\n let confidence = 0;\n \n if (categoryField && group[categoryField]) {\n \n const categoryValue = group[categoryField];\n \n if (classifications[categoryValue] !== undefined) {\n isBuildingElement = classifications[categoryValue];\n confidence = 95;\n reason = `Category '${categoryValue}' classified by AI as ${isBuildingElement ? 'building element' : 'drawing/annotation'}`;\n } else {\n \n const lowerCategory = categoryValue.toLowerCase();\n const drawingKeywords = /annotation|drawing|text|dimension|tag|view|sheet|grid|section|elevation|callout|revision|legend|symbol|mark|note|detail items|filled region|detail line/i;\n const buildingKeywords = /wall|floor|roof|column|beam|door|window|stair|pipe|duct|equipment|fixture|furniture/i;\n \n if (drawingKeywords.test(lowerCategory)) {\n isBuildingElement = false;\n confidence = 85;\n reason = `Category '${categoryValue}' matched drawing keywords`;\n } else if (buildingKeywords.test(lowerCategory)) {\n isBuildingElement = true;\n confidence = 85;\n reason = `Category '${categoryValue}' matched building keywords`;\n } else {\n \n isBuildingElement = true;\n confidence = 70;\n reason = `Category '${categoryValue}' assumed as building element (no clear match)`;\n }\n }\n } else {\n \n let hasSignificantVolumetricData = false;\n let volumetricCount = 0;\n \n for (const field of volumetricFields) {\n const value = parseFloat(group[field]);\n if (!isNaN(value) && value > 0) {\n hasSignificantVolumetricData = true;\n volumetricCount++;\n }\n }\n \n isBuildingElement = hasSignificantVolumetricData;\n confidence = hasSignificantVolumetricData ? 80 : 60;\n reason = hasSignificantVolumetricData ? \n `Has ${volumetricCount} volumetric parameters with values` : \n 'No category field and no significant volumetric data';\n }\n \n return {\n json: {\n ...group,\n is_building_element: isBuildingElement,\n element_confidence: confidence,\n element_reason: reason\n }\n };\n});"
},
"typeVersion": 2
},
{
"id": "50462cce-7978-4147-b215-25749d3bbf79",
"name": "非建筑元素输出1",
"type": "n8n-nodes-base.set",
"position": [
2272,
848
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "message",
"name": "message",
"type": "string",
"value": "Non-building elements (drawings, annotations, etc.)"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "93e37bf0-a126-4174-9bc6-a8a5378885a1",
"name": "AI分类类别1",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1536,
832
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {
"maxTokens": 4000,
"temperature": 0.1
},
"messages": {
"values": [
{
"role": "system",
"content": "You are an expert in Revit, BIM (Building Information Modeling) and construction classification. Your task is to classify category values as either building elements or non-building elements (drawings, annotations, etc.).\n\nBuilding elements include:\n- Structural elements (walls, floors, roofs, columns, beams, foundations, slabs)\n- MEP elements (pipes, ducts, equipment, fixtures, mechanical equipment)\n- Architectural elements (doors, windows, stairs, railings, curtain walls)\n- Site elements (parking, roads, landscaping)\n- Furniture and fixtures\n- Any physical construction element that has volume, area, or physical properties\n\nNon-building elements include:\n- Drawings and sheets\n- Annotations, dimensions, text notes\n- Views, sections, elevations, plans\n- Tags, symbols, legends, schedules\n- Grids, levels, reference planes\n- Revision clouds, callouts, detail items\n- Lines, filled regions, detail lines\n- Any 2D documentation or annotation element\n\nIMPORTANT: Analyze the actual category name, not just keywords. For example:\n- \"Detail Items\" = non-building (annotation)\n- \"Plumbing Fixtures\" = building element\n- \"Room Tags\" = non-building (annotation)\n- \"Structural Columns\" = building element\n\nReturn ONLY valid JSON in this exact format:\n{\n \"classifications\": {\n \"category_value_1\": true,\n \"category_value_2\": false\n },\n \"building_categories\": [\"list\", \"of\", \"building\", \"categories\"],\n \"drawing_categories\": [\"list\", \"of\", \"drawing\", \"categories\"]\n}"
},
{
"content": "{{ $json.categoryField ? `Classify these ${$json.categoryValues.length} category values from field '${$json.categoryField}' as building elements (true) or drawings/annotations (false):\n\nCategory values:\n${JSON.stringify($json.categoryValues, null, 2)}\n\nCategory field type: ${$json.categoryFieldType}` : 'No category field found. Please classify based on volumetric data presence.'}}"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "5SwKOx6OOukR6C0w",
"name": "OpenAi account n8n"
}
},
"typeVersion": 1.3
},
{
"id": "2adc7c4e-1133-43bd-a3b8-8648a95861be",
"name": "是否为建筑元素1",
"type": "n8n-nodes-base.if",
"position": [
2064,
832
],
"parameters": {
"conditions": {
"boolean": [
{
"value1": "={{ $json.is_building_element }}",
"value2": true
}
]
}
},
"typeVersion": 1
},
{
"id": "a6b94ddd-8674-4072-8bb0-f2a813b4c042",
"name": "检查所有批次是否完成",
"type": "n8n-nodes-base.if",
"position": [
1024,
1280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9af8b6d4-3a3a-4c4a-8d4d-d5a8c2958f5f",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $node['Process in Batches1'].context['noItemsLeft'] }}",
"rightValue": true
}
]
}
},
"typeVersion": 2
},
{
"id": "6a62ad33-7c47-495d-b81b-3be78ae0cd81",
"name": "收集所有结果",
"type": "n8n-nodes-base.code",
"position": [
1200,
1568
],
"parameters": {
"jsCode": "// Get all accumulated data and prepare for reporting\nconst storedData = $getWorkflowStaticData('global');\nconst allProcessedItems = storedData.accumulatedData || [];\n\nconsole.log(`\\n=== BATCH PROCESSING COMPLETE ===`);\nconsole.log(`Total items processed: ${allProcessedItems.length}`);\n\n// Clear accumulated data for next run\nstoredData.accumulatedData = [];\n\n// Return all items for report generation\nreturn allProcessedItems;"
},
"typeVersion": 2
},
{
"id": "e3ab164d-d34c-4415-9ecc-d1e2dcd35ebe",
"name": "分批处理1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1184,
1152
],
"parameters": {
"options": {},
"batchSize": 1
},
"typeVersion": 1
},
{
"id": "b1504e4e-6a04-4014-aeed-b38dbaa9b12d",
"name": "清理空值1",
"type": "n8n-nodes-base.code",
"position": [
1360,
1152
],
"parameters": {
"jsCode": "// Clean empty values from the item\nreturn $input.all().map(item => {\n const cleanedJson = {};\n Object.entries(item.json).forEach(([key, value]) => {\n if (value !== null) {\n if (typeof value === 'number') {\n if (value !== 0 || key === 'Element Count') {\n cleanedJson[key] = value;\n }\n } else if (value !== '') {\n cleanedJson[key] = value;\n }\n }\n });\n return { json: cleanedJson };\n});"
},
"typeVersion": 2
},
{
"id": "d152a0a9-71c9-4532-9743-15225429bcc8",
"name": "AI代理增强",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1712,
1152
],
"parameters": {
"text": "={{ $json.userPrompt }}",
"options": {
"systemMessage": "={{ $json.systemPrompt }}"
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "72e3dd39-013c-43b4-a0e1-9ce4167d37f0",
"name": "累积结果",
"type": "n8n-nodes-base.code",
"position": [
2288,
1264
],
"parameters": {
"jsCode": "// Accumulate all processed items\nconst currentItem = $input.first();\nconst storedData = $getWorkflowStaticData('global');\n\n// Initialize accumulator if needed\nif (!storedData.accumulatedData) {\n storedData.accumulatedData = [];\n}\n\n// Add current item to accumulated data\nstoredData.accumulatedData.push(currentItem);\n\nconsole.log(`Item processed. Total accumulated: ${storedData.accumulatedData.length} items`);\n\n// Return the current item to continue the flow\nreturn [currentItem];"
},
"typeVersion": 2
},
{
"id": "7f62341e-e758-4664-aa1d-62cdba49cd84",
"name": "Anthropic聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
1472,
1312
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-opus-4-20250514",
"cachedResultName": "Claude Opus 4"
},
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "af7za1FRO2jVYY9L",
"name": "Anthropic account"
}
},
"typeVersion": 1.3
},
{
"id": "dfb09d43-49c8-47be-af77-e3bef30a5053",
"name": "计算项目总计1",
"type": "n8n-nodes-base.code",
"position": [
1376,
1568
],
"parameters": {
"jsCode": "// Aggregate all results and calculate project totals\nconst items = $input.all();\n\n// Initialize aggregators\nconst projectTotals = {\n totalElements: 0,\n totalCost: 0,\n totalVolume: 0,\n totalArea: 0,\n byMaterial: {},\n byCategory: {},\n byImpact: {}\n};\n\n// Process each item\nitems.forEach(item => {\n const data = item.json;\n const elementCount = parseFloat(data['Element Count']) || 1;\n const cost = parseFloat(data['Total Cost (EUR)']) || 0;\n const volume = parseFloat(data['Volume (m³)']) || 0;\n const area = parseFloat(data['Area (m²)']) || 0;\n const material = data['Material (EU Standard)'] || 'Unknown';\n const category = data['Element Category'] || 'Unknown';\n const impact = data['Impact Category'] || 'Unknown';\n \n // Update totals\n projectTotals.totalElements += elementCount;\n projectTotals.totalCost += cost;\n projectTotals.totalVolume += volume;\n projectTotals.totalArea += area;\n \n // Aggregate by material\n if (!projectTotals.byMaterial[material]) {\n projectTotals.byMaterial[material] = {\n elements: 0,\n cost: 0,\n volume: 0,\n types: new Set()\n };\n }\n projectTotals.byMaterial[material].elements += elementCount;\n projectTotals.byMaterial[material].cost += cost;\n projectTotals.byMaterial[material].volume += volume;\n projectTotals.byMaterial[material].types.add(data['Element Name']);\n \n // Aggregate by category\n if (!projectTotals.byCategory[category]) {\n projectTotals.byCategory[category] = {\n elements: 0,\n cost: 0\n };\n }\n projectTotals.byCategory[category].elements += elementCount;\n projectTotals.byCategory[category].cost += cost;\n \n // Aggregate by impact\n if (!projectTotals.byImpact[impact]) {\n projectTotals.byImpact[impact] = {\n elements: 0,\n cost: 0\n };\n }\n projectTotals.byImpact[impact].elements += elementCount;\n projectTotals.byImpact[impact].cost += cost;\n});\n\n// Add percentages and rankings to each item\nconst enrichedItems = items.map((item, index) => {\n const data = item.json;\n const cost = parseFloat(data['Total Cost (EUR)']) || 0;\n const elementCount = parseFloat(data['Element Count']) || 1;\n \n return {\n json: {\n ...data,\n // Add project percentages\n 'Cost % of Total': projectTotals.totalCost > 0 ? \n ((cost / projectTotals.totalCost) * 100).toFixed(2) : '0.00',\n 'Elements % of Total': projectTotals.totalElements > 0 ? \n ((elementCount / projectTotals.totalElements) * 100).toFixed(2) : '0.00',\n // Add ranking\n 'Cost Rank': index + 1,\n // Project totals (same for all rows)\n 'Project Total Elements': projectTotals.totalElements,\n 'Project Total Cost (EUR)': projectTotals.totalCost.toFixed(3),\n 'Project Total Volume (m³)': projectTotals.totalVolume.toFixed(2),\n 'Project Total Area (m²)': projectTotals.totalArea.toFixed(2)\n }\n };\n});\n\n// Sort by Cost (highest first)\nenrichedItems.sort((a, b) => \n parseFloat(b.json['Total Cost (EUR)']) - parseFloat(a.json['Total Cost (EUR)'])\n);\n\n// Store aggregated data for summary\n$getWorkflowStaticData('global').projectTotals = projectTotals;\n\nreturn enrichedItems;"
},
"typeVersion": 2
},
{
"id": "4d061758-4051-4bcc-85db-d7ed7fa06ec7",
"name": "增强Excel输出",
"type": "n8n-nodes-base.code",
"position": [
1936,
1744
],
"parameters": {
"jsCode": "// Enhanced Excel styling configuration\nconst excelBuffer = $input.first().binary.data;\nconst fileName = `Price_Estimation_Report_${new Date().toISOString().slice(0,10)}.xlsx`;\n\n// Add metadata to the file\nconst metadata = {\n title: 'Price Estimation Analysis Report',\n author: 'DataDrivenConstruction.io',\n company: 'Automated Price Estimation System',\n created: new Date().toISOString(),\n description: 'Comprehensive project cost assessment with multi-standard material classification',\n keywords: 'Price, Cost Estimation, Building Materials'\n};\n\n// Return the enhanced Excel file\nreturn [{\n json: {\n fileName: fileName,\n fileSize: excelBuffer.data.length,\n sheets: 8,\n metadata: metadata,\n timestamp: new Date().toISOString()\n },\n binary: {\n data: {\n ...excelBuffer,\n fileName: fileName,\n fileExtension: 'xlsx',\n mimeType: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'\n }\n }\n}];"
},
"typeVersion": 2
},
{
"id": "d006c84f-3df6-493e-8965-2552f06cc862",
"name": "准备Excel数据",
"type": "n8n-nodes-base.code",
"position": [
1600,
1744
],
"parameters": {
"jsCode": "// Prepare comprehensive data for multi-sheet Excel export\nconst items = $input.all();\nconst projectTotals = $getWorkflowStaticData('global').projectTotals;\n\n// Helper function to format numbers\nconst formatNumber = (num, decimals = 2) => {\n return typeof num === 'number' ? parseFloat(num.toFixed(decimals)) : 0;\n};\n\n// Sheet 1: Executive Summary with project metrics\nconst executiveSummary = [\n {\n 'Category': 'PROJECT OVERVIEW',\n 'Metric': 'Total Elements Analyzed',\n 'Value': projectTotals.totalElements,\n 'Unit': 'elements'\n },\n {\n 'Category': 'PROJECT OVERVIEW',\n 'Metric': 'Element Groups',\n 'Value': items.length,\n 'Unit': 'groups'\n },\n {\n 'Category': 'COST METRICS',\n 'Metric': 'Total Estimated Cost',\n 'Value': formatNumber(projectTotals.totalCost, 2),\n 'Unit': 'EUR'\n },\n {\n 'Category': 'COST METRICS',\n 'Metric': 'Average Cost per Element',\n 'Value': formatNumber(projectTotals.totalCost / projectTotals.totalElements, 3),\n 'Unit': 'EUR/element'\n },\n {\n 'Category': 'MATERIAL METRICS',\n 'Metric': 'Unique Material Types',\n 'Value': Object.keys(projectTotals.byMaterial).length,\n 'Unit': 'materials'\n },\n {\n 'Category': 'VOLUMETRIC DATA',\n 'Metric': 'Total Volume',\n 'Value': formatNumber(projectTotals.totalVolume, 2),\n 'Unit': 'm³'\n },\n {\n 'Category': 'VOLUMETRIC DATA',\n 'Metric': 'Total Area',\n 'Value': formatNumber(projectTotals.totalArea, 2),\n 'Unit': 'm²'\n }\n];\n\n// Sheet 2: Detailed Elements Analysis - ALL fields from processing\nconst detailedElements = items.map((item, index) => {\n const data = item.json;\n return {\n 'Cost_Rank': index + 1,\n 'Element_Group': data['Element Name'] || data['Type Name'] || 'Unknown',\n 'Element_Category': data['Element Category'] || 'Unknown',\n 'Element_Type': data['Element Type'] || 'Unknown',\n 'Element_Function': data['Element Function'] || 'Unknown',\n 'Element_Count': parseInt(data['Element Count']) || 0,\n 'Material_EU_Standard': data['Material (EU Standard)'] || 'Unknown',\n 'Material_DE_Standard': data['Material (DE Standard)'] || 'Unknown',\n 'Material_US_Standard': data['Material (US Standard)'] || 'Unknown',\n 'Primary_Material': data['Primary Material'] || 'Unknown',\n 'Secondary_Materials': data['Secondary Materials'] || 'None',\n 'Quantity_Value': formatNumber(data['Quantity'] || 0, 3),\n 'Quantity_Unit': data['Quantity Unit'] || 'piece',\n 'Volume_m3': formatNumber(data['Volume (m³)'] || 0, 3),\n 'Area_m2': formatNumber(data['Area (m²)'] || 0, 3),\n 'Price_per_Unit_EUR': formatNumber(data['Price per Unit (EUR)'] || 0, 2),\n 'Total_Cost_EUR': formatNumber(data['Total Cost (EUR)'] || 0, 2),\n 'Cost_per_Element_EUR': formatNumber(data['Cost per Element (EUR)'] || 0, 2),\n 'Cost_Percent_of_Total': formatNumber(data['Cost % of Total'] || 0, 2),\n 'Price_Source': data['Price Source'] || 'Unknown',\n 'Overall_Confidence_%': parseInt(data['Overall Confidence (%)']) || 0,\n 'Assumptions': data['Assumptions'] || 'None',\n 'Warnings': data['Warnings'] || 'None'\n };\n});\n\n// Sheet 3: Material Summary with detailed breakdown\nconst materialSummary = Object.entries(projectTotals.byMaterial)\n .sort((a, b) => b[1].cost - a[1].cost)\n .map(([material, data], index) => {\n const costPercent = (data.cost / projectTotals.totalCost) * 100;\n return {\n 'Rank': index + 1,\n 'Material_Type': material,\n 'Element_Count': data.elements,\n 'Cost_EUR': formatNumber(data.cost, 2),\n 'Cost_%': formatNumber(costPercent, 1),\n 'Volume_m3': formatNumber(data.volume, 2)\n };\n });\n\n// Sheet 4: Top 10 Expensive Groups\nconst top10Groups = items\n .slice(0, 10)\n .map((item, index) => {\n const data = item.json;\n const cost = parseFloat(data['Total Cost (EUR)']) || 0;\n const costPercent = parseFloat(data['Cost % of Total']) || 0;\n const elementCount = parseInt(data['Element Count']) || 1;\n \n return {\n 'Rank': index + 1,\n 'Element_Group': data['Element Name'] || 'Unknown',\n 'Category': data['Element Category'] || 'Unknown',\n 'Material': data['Material (EU Standard)'] || 'Unknown',\n 'Element_Count': elementCount,\n 'Cost_EUR': formatNumber(cost, 2),\n 'Cost_%': formatNumber(costPercent, 1),\n 'Cost_per_Element': formatNumber(cost / elementCount, 1)\n };\n });\n\n// Create worksheet structure with proper sheet names\nconst worksheets = [\n { name: 'Summary', data: executiveSummary },\n { name: 'Detailed Elements', data: detailedElements },\n { name: 'Material Summary', data: materialSummary },\n { name: 'Top 10 Groups', data: top10Groups }\n];\n\n// Flatten all data with sheet markers\nconst allData = [];\nworksheets.forEach(sheet => {\n sheet.data.forEach(row => {\n allData.push({\n json: {\n ...row,\n _sheetName: sheet.name\n }\n });\n });\n});\n\nreturn allData;"
},
"typeVersion": 2
},
{
"id": "b55dc4f5-1309-4a06-9924-d796733a21f5",
"name": "创建Excel文件",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
1760,
1744
],
"parameters": {
"options": {
"fileName": "=Price_Estimation_Report_{{ $now.format('yyyy-MM-dd') }}",
"headerRow": true,
"sheetName": "={{ $json._sheetName }}"
},
"operation": "toFile",
"fileFormat": "xlsx"
},
"typeVersion": 2
},
{
"id": "750047a0-76ea-41a6-8e6e-83447eaef026",
"name": "准备增强提示",
"type": "n8n-nodes-base.code",
"position": [
1536,
1152
],
"parameters": {
"jsCode": "// Enhanced prompts for comprehensive price estimation analysis\nconst inputData = $input.first().json;\nconst originalGroupedData = { ...inputData };\nconst country = $node['Process AI Response1'].json.country;\n\nconst systemPrompt = `You are an expert in construction cost estimation, material pricing, and building element classification. Analyze the provided building element data and return a comprehensive price estimation assessment.\n\nUse tools like web_search or browse_page to find current prices from reliable sources (e.g., manufacturer websites, construction databases like RSMeans, ÖKOBAUDAT for ${country}, etc.). Prioritize sources from ${country} or relevant region.\n\nIMPORTANT NOTE ON DATA:\n- All quantitative fields like Volume, Area, Length, etc. in the input data represent ALREADY AGGREGATED TOTALS for the entire group of elements.\n- 'Element Count' indicates the number of individual elements in this group.\n- DO NOT multiply volumes/areas by Element Count - they are already total sums.\n- Infer the best unit for pricing (e.g., per m³ for volumes, per m² for areas, per piece for counts) based on parameters.\n- Search for prices using element parameters (material, dimensions, type).\n- If exact price not found, use average or rough estimate and note it.\n- Consider secondary materials if possible, otherwise focus on primary.\n- For additional factors (e.g., labor, transport), note percentages but do not include in calculations.\n- If no price found, state 'Price not found' and suggest average if possible.\n\n## Your Analysis Must Include:\n\n### 1. Element Identification\n- Element type and category\n- Primary material composition\n- Secondary materials if applicable\n- Functional classification\n\n### 2. Material Classification (All 3 Standards, prioritize ${country}'s if applicable)\n- **European (EN 15978/15804)**: Concrete/Steel/Wood/Glass/Insulation/etc.\n- **German (ÖKOBAUDAT)**: Mineralische/Metalle/Holz/Dämmstoffe/etc.\n- **US (MasterFormat)**: Division classifications\n\n### 3. Quantity Analysis\n- Primary quantity with unit (m³, m², m, kg, pieces) - use aggregated total from input\n- Calculation method used (e.g., 'Direct from provided total volume')\n- Confidence level (0-100%)\n- Data quality assessment\n\n### 4. Price Estimation\n- Price per unit (EUR/unit)\n- Total price (for the entire group)\n- Price source (URL or database name)\n- Additional factors (percentages only, e.g., labor: 20%)\n\n### 5. Data Quality & Confidence\n- Overall confidence score\n- Data completeness assessment\n- Key assumptions made\n- Warnings or limitations\n\n## Output Format\nReturn ONLY valid JSON with this exact structure:\n{\n \"element_identification\": {\n \"name\": \"string\",\n \"category\": \"string\",\n \"type\": \"string\",\n \"function\": \"string\"\n },\n \"material_classification\": {\n \"european\": \"string\",\n \"german\": \"string\",\n \"us\": \"string\",\n \"primary_material\": \"string\",\n \"secondary_materials\": [\"string\"]\n },\n \"quantities\": {\n \"value\": number,\n \"unit\": \"string\",\n \"calculation_method\": \"string\",\n \"raw_dimensions\": {\n \"length\": number,\n \"width\": number,\n \"height\": number,\n \"thickness\": number,\n \"area\": number,\n \"volume\": number\n }\n },\n \"price_analysis\": {\n \"price_per_unit_eur\": number,\n \"total_price_eur\": number,\n \"price_source\": \"string\",\n \"additional_factors\": {\"labor\": number, \"transport\": number},\n \"data_source\": \"string\"\n },\n \"confidence\": {\n \"overall_score\": number,\n \"material_confidence\": number,\n \"quantity_confidence\": number,\n \"price_confidence\": number,\n \"data_quality\": \"high/medium/low\"\n },\n \"metadata\": {\n \"assumptions\": [\"string\"],\n \"warnings\": [\"string\"],\n \"notes\": \"string\"\n }\n}`;\n\nconst userPrompt = `Analyze this building element group for price estimation in ${country}. Remember: Volumes and areas are already total for the group, not per element. Use tools to search for prices.\n\n${JSON.stringify(inputData, null, 2)}\n\nProvide comprehensive price analysis following the specified format. Focus on accuracy and use conservative estimates where data is uncertain.`;\n\nreturn [{\n json: {\n ...originalGroupedData,\n systemPrompt,\n userPrompt,\n _originalGroupedData: originalGroupedData\n }\n}];"
},
"typeVersion": 2
},
{
"id": "f5d3ae3d-68fe-43e3-a6df-4bed5a82aefa",
"name": "解析增强响应",
"type": "n8n-nodes-base.code",
"position": [
2064,
1152
],
"parameters": {
"jsCode": "// Parse and enrich AI response with all necessary data\nconst aiResponse = $input.first().json.output || $input.first().json.response || $input.first().json.text || $input.first().json;\nconst originalData = $node[\"Prepare Enhanced Prompts\"].json._originalGroupedData || $node[\"Prepare Enhanced Prompts\"].json;\n\ntry {\n // Extract JSON from response\n let jsonStr = aiResponse;\n if (typeof jsonStr === 'string') {\n const jsonMatch = jsonStr.match(/```json\\n?([\\s\\S]*?)\\n?```/) || jsonStr.match(/\\{[\\s\\S]*\\}/);\n if (jsonMatch) {\n jsonStr = jsonMatch[1] || jsonMatch[0];\n }\n }\n \n const analysis = typeof jsonStr === 'string' ? JSON.parse(jsonStr) : jsonStr;\n \n // Calculate additional metrics - use total price for group\n const total_price_eur = analysis.price_analysis?.total_price_eur || 0;\n const elementCount = parseFloat(originalData['Element Count']) || 1;\n const price_per_element = total_price_eur / elementCount;\n \n // Determine impact category\n let impactCategory = 'Unknown';\n const pricePerUnit = analysis.price_analysis?.price_per_unit_eur || 0;\n if (pricePerUnit <= 10) {\n impactCategory = 'Very Low Cost';\n } else if (pricePerUnit <= 50) {\n impactCategory = 'Low Cost';\n } else if (pricePerUnit <= 200) {\n impactCategory = 'Medium Cost';\n } else if (pricePerUnit <= 500) {\n impactCategory = 'High Cost';\n } else {\n impactCategory = 'Very High Cost';\n }\n \n // Create comprehensive output record\n return [{\n json: {\n // Original data\n ...originalData,\n \n // Element identification\n 'Element Name': analysis.element_identification?.name || originalData['Type Name'] || 'Unknown',\n 'Element Category': analysis.element_identification?.category || originalData['Category'] || 'Unknown',\n 'Element Type': analysis.element_identification?.type || 'Unknown',\n 'Element Function': analysis.element_identification?.function || 'Unknown',\n \n // Material classification\n 'Material (EU Standard)': analysis.material_classification?.european || 'Unknown',\n 'Material (DE Standard)': analysis.material_classification?.german || 'Unknown',\n 'Material (US Standard)': analysis.material_classification?.us || 'Unknown',\n 'Primary Material': analysis.material_classification?.primary_material || 'Unknown',\n 'Secondary Materials': (analysis.material_classification?.secondary_materials || []).join(', ') || 'None',\n \n // Quantities\n 'Quantity': analysis.quantities?.value || 0,\n 'Quantity Unit': analysis.quantities?.unit || 'piece',\n 'Calculation Method': analysis.quantities?.calculation_method || 'Not specified',\n \n // Dimensions (from raw data) - these are totals\n 'Length (mm)': analysis.quantities?.raw_dimensions?.length || originalData['Length'] || 0,\n 'Width (mm)': analysis.quantities?.raw_dimensions?.width || originalData['Width'] || 0,\n 'Height (mm)': analysis.quantities?.raw_dimensions?.height || originalData['Height'] || 0,\n 'Thickness (mm)': analysis.quantities?.raw_dimensions?.thickness || originalData['Thickness'] || 0,\n 'Area (m²)': analysis.quantities?.raw_dimensions?.area || originalData['Area'] || 0,\n 'Volume (m³)': analysis.quantities?.raw_dimensions?.volume || originalData['Volume'] || 0,\n \n // Price Analysis\n 'Price per Unit (EUR)': analysis.price_analysis?.price_per_unit_eur || 0,\n 'Total Cost (EUR)': total_price_eur,\n 'Cost per Element (EUR)': price_per_element,\n 'Price Source': analysis.price_analysis?.price_source || 'Unknown',\n 'Additional Factors': JSON.stringify(analysis.price_analysis?.additional_factors || {}),\n 'Data Source': analysis.price_analysis?.data_source || 'Industry average',\n 'Impact Category': impactCategory,\n \n // Confidence scores\n 'Overall Confidence (%)': analysis.confidence?.overall_score || 0,\n 'Material Confidence (%)': analysis.confidence?.material_confidence || 0,\n 'Quantity Confidence (%)': analysis.confidence?.quantity_confidence || 0,\n 'Price Confidence (%)': analysis.confidence?.price_confidence || 0,\n 'Data Quality': analysis.confidence?.data_quality || 'unknown',\n \n // Metadata\n 'Assumptions': (analysis.metadata?.assumptions || []).join('; ') || 'None',\n 'Warnings': (analysis.metadata?.warnings || []).join('; ') || 'None',\n 'Analysis Notes': analysis.metadata?.notes || '',\n 'Processing Timestamp': new Date().toISOString(),\n 'Analysis Status': 'Complete'\n }\n }];\n \n} catch (error) {\n // Return error record with original data preserved\n return [{\n json: {\n ...originalData,\n 'Analysis Status': 'Failed',\n 'Error': error.message,\n 'Processing Timestamp': new Date().toISOString()\n }\n }];\n}"
},
"typeVersion": 2
},
{
"id": "428bb655-a1e9-45df-a80c-57c00810e5e9",
"name": "生成HTML报告",
"type": "n8n-nodes-base.code",
"position": [
1600,
1568
],
"parameters": {
"jsCode": "// Generate professional McKinsey/Accenture style HTML report with visualizations\nconst items = $input.all();\nconst projectTotals = $getWorkflowStaticData('global').projectTotals;\n\n// Get project name from file path\nconst projectFile = $node['Setup - Define file paths'].json.project_file || '';\nconst projectName = projectFile.split('\\\\').pop().replace('.rvt', '').replace(/_/g, ' ').toUpperCase();\n\n// Sort items by total cost descending\nconst sortedItems = [...items].sort((a, b) => \n parseFloat(b.json['Total Cost (EUR)'] || 0) - parseFloat(a.json['Total Cost (EUR)'] || 0)\n);\n\n// Calculate additional metrics\nconst avgConfidence = sortedItems.reduce((sum, item) => sum + (parseInt(item.json['Overall Confidence (%)']) || 0), 0) / sortedItems.length;\nconst completeItems = sortedItems.filter(item => item.json['Analysis Status'] === 'Complete').length;\nconst coveragePercent = (completeItems / sortedItems.length) * 100;\n\n// Get top material\nconst topMaterial = Object.entries(projectTotals.byMaterial)\n .sort((a, b) => b[1].cost - a[1].cost)[0];\n\n// Calculate high impact items\nconst highImpactItems = sortedItems.filter(item => \n parseFloat(item.json['Total Cost (EUR)']) >= projectTotals.totalCost * 0.05\n).length;\n\n// Calculate top 3 materials percentage\nconst top3Materials = Object.entries(projectTotals.byMaterial)\n .sort((a, b) => b[1].cost - a[1].cost)\n .slice(0, 3);\nconst top3Percentage = (top3Materials.reduce((sum, [, data]) => sum + data.cost, 0) / projectTotals.totalCost) * 100;\n\n// Prepare data for charts\nconst materialChartData = Object.entries(projectTotals.byMaterial)\n .sort((a, b) => b[1].cost - a[1].cost)\n .slice(0, 6)\n .map(([material, data]) => ({\n label: material,\n value: data.cost\n }));\n\nconst barChartData = sortedItems.slice(0, 10).map(item => ({\n label: item.json['Element Name'] || 'Unknown',\n value: parseFloat(item.json['Total Cost (EUR)'] || 0)\n}));\n\n// Generate HTML\nconst html = `<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <title>Project Cost Intelligence | Executive Report</title>\n <script src=\"https://cdn.jsdelivr.net/npm/chart.js\"></script>\n <link href=\"https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700;800&family=Poppins:wght@600;700;800&display=swap\" rel=\"stylesheet\">\n <style>\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n \n :root {\n --primary-gradient: linear-gradient(135deg, #0F4C75 0%, #3282B8 50%, #1B262C 100%);\n --secondary-gradient: linear-gradient(135deg, #3282B8 0%, #0F4C75 100%);\n --light-gradient: linear-gradient(180deg, #f8fafc 0%, #f1f5f9 100%);\n --accent-gradient: linear-gradient(135deg, #BBE1FA 0%, #3282B8 100%);\n }\n \n body {\n font-family: 'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', sans-serif;\n background: linear-gradient(180deg, #fafbfc 0%, #ffffff 100%);\n min-height: 100vh;\n color: #0f172a;\n line-height: 1.6;\n }\n \n .container {\n max-width: 1600px;\n margin: 0 auto;\n background: white;\n box-shadow: 0 0 40px rgba(0, 0, 0, 0.05);\n position: relative;\n }\n \n /* Professional Header */\n .header {\n background: var(--primary-gradient);\n color: white;\n padding: 45px 80px;\n position: relative;\n overflow: hidden;\n }\n \n .header::before {\n content: '';\n position: absolute;\n top: -50%;\n right: -10%;\n width: 800px;\n height: 800px;\n background: radial-gradient(circle, rgba(50, 130, 184, 0.15) 0%, transparent 70%);\n animation: float 6s ease-in-out infinite;\n }\n \n .header::after {\n content: '';\n position: absolute;\n bottom: -30%;\n left: -10%;\n width: 600px;\n height: 600px;\n background: radial-gradient(circle, rgba(187, 225, 250, 0.1) 0%, transparent 70%);\n animation: float 6s ease-in-out infinite 3s;\n }\n \n @keyframes float {\n 0%, 100% { transform: translateY(0) scale(1); }\n 50% { transform: translateY(-20px) scale(1.05); }\n }\n \n .header-content {\n position: relative;\n z-index: 1;\n }\n \n .header-top {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 50px;\n }\n \n .company-brand {\n display: flex;\n align-items: center;\n gap: 20px;\n }\n \n .company-logo {\n font-size: 13px;\n font-weight: 800;\n letter-spacing: 3px;\n text-transform: uppercase;\n padding-left: 20px;\n border-left: 4px solid #BBE1FA;\n opacity: 0.95;\n }\n \n .report-badge {\n background: linear-gradient(135deg, rgba(255,255,255,0.2) 0%, rgba(255,255,255,0.05) 100%);\n backdrop-filter: blur(20px);\n padding: 12px 24px;\n border-radius: 50px;\n font-size: 11px;\n font-weight: 700;\n letter-spacing: 2px;\n text-transform: uppercase;\n border: 1px solid rgba(255,255,255,0.2);\n box-shadow: 0 4px 20px rgba(0,0,0,0.1);\n }\n \n h1 {\n font-family: 'Poppins', sans-serif;\n font-size: 48px;\n font-weight: 800;\n margin-bottom: 16px;\n letter-spacing: -2px;\n line-height: 1.1;\n color: white;\n }\n \n .subtitle {\n font-size: 18px;\n font-weight: 300;\n opacity: 0.9;\n margin-bottom: 30px;\n color: #cbd5e1;\n letter-spacing: 0.5px;\n }\n \n .meta-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));\n gap: 30px;\n padding-top: 30px;\n border-top: 1px solid rgba(255,255,255,0.15);\n }\n \n .meta-card {\n display: flex;\n align-items: flex-start;\n gap: 16px;\n flex-direction: column;\n }\n \n .meta-info {\n flex: 1;\n }\n \n .meta-label {\n font-size: 12px;\n opacity: 0.8;\n text-transform: uppercase;\n letter-spacing: 1px;\n margin-bottom: 4px;\n font-weight: 500;\n }\n \n .meta-value {\n font-size: 20px;\n font-weight: 700;\n }\n \n /* KPI Cards Section */\n .kpi-section {\n padding: 80px;\n background: linear-gradient(180deg, #f8fafc 0%, #ffffff 100%);\n position: relative;\n }\n \n .kpi-section::before {\n content: '';\n position: absolute;\n top: 0;\n left: 0;\n right: 0;\n height: 2px;\n background: var(--accent-gradient);\n }\n \n .kpi-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));\n gap: 32px;\n }\n \n .kpi-card {\n background: white;\n padding: 40px;\n border-radius: 20px;\n border: 1px solid #e5e7eb;\n box-shadow: 0 4px 20px rgba(0, 0, 0, 0.04);\n transition: all 0.4s cubic-bezier(0.4, 0, 0.2, 1);\n position: relative;\n overflow: hidden;\n }\n \n .kpi-card::before {\n content: '';\n position: absolute;\n top: 0;\n left: 0;\n width: 100%;\n height: 3px;\n background: linear-gradient(90deg, #3282B8 0%, #0F4C75 100%);\n }\n \n .kpi-card:hover {\n transform: translateY(-8px);\n box-shadow: 0 12px 40px rgba(0, 0, 0, 0.08);\n border-color: #cbd5e1;\n }\n \n .kpi-icon {\n width: 56px;\n height: 56px;\n background: linear-gradient(180deg, #f8fafc 0%, #f1f5f9 100%);\n border-radius: 16px;\n display: flex;\n align-items: center;\n justify-content: center;\n font-size: 24px;\n margin-bottom: 20px;\n border: 1px solid #e5e7eb;\n color: #94a3b8;\n }\n \n .kpi-label {\n font-size: 11px;\n color: #64748b;\n text-transform: uppercase;\n letter-spacing: 1.5px;\n margin-bottom: 12px;\n font-weight: 700;\n }\n \n .kpi-value {\n font-size: 42px;\n font-weight: 800;\n color: #1e293b;\n margin-bottom: 8px;\n font-family: 'Poppins', sans-serif;\n }\n \n .kpi-unit {\n font-size: 14px;\n color: #94a3b8;\n font-weight: 500;\n }\n \n .kpi-trend {\n position: absolute;\n top: 24px;\n right: 24px;\n padding: 8px 16px;\n background: linear-gradient(135deg, #dbeafe 0%, #e0f2fe 100%);\n border-radius: 20px;\n font-size: 12px;\n font-weight: 600;\n color: #3282B8;\n }\n \n /* Executive Summary */\n .executive-section {\n padding: 80px;\n background: white;\n }\n \n .section-header {\n display: flex;\n align-items: center;\n gap: 20px;\n margin-bottom: 50px;\n padding-bottom: 30px;\n border-bottom: 2px solid #e0f2fe;\n }\n \n .section-number {\n width: 60px;\n height: 60px;\n background: linear-gradient(135deg, #3282B8 0%, #0F4C75 100%);\n color: white;\n border-radius: 16px;\n display: flex;\n align-items: center;\n justify-content: center;\n font-weight: 800;\n font-size: 24px;\n box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1);\n }\n \n h2 {\n font-size: 36px;\n font-weight: 800;\n color: #1e293b;\n font-family: 'Poppins', sans-serif;\n letter-spacing: -1px;\n }\n \n .summary-grid {\n display: grid;\n grid-template-columns: 1.5fr 1fr;\n gap: 60px;\n margin-top: 50px;\n }\n \n .summary-content {\n font-size: 17px;\n line-height: 1.9;\n color: #475569;\n }\n \n .summary-content p {\n margin-bottom: 20px;\n }\n \n .summary-content strong {\n color: #3282B8;\n font-weight: 700;\n }\n \n .insight-panel {\n background: linear-gradient(180deg, #f8fafc 0%, #f1f5f9 100%);\n padding: 40px;\n border-radius: 20px;\n border: 1px solid #e5e7eb;\n position: relative;\n box-shadow: 0 4px 20px rgba(0, 0, 0, 0.04);\n }\n \n .insight-panel h3 {\n font-size: 20px;\n margin-bottom: 30px;\n color: #1e293b;\n font-weight: 800;\n font-family: 'Poppins', sans-serif;\n }\n \n .insight-item {\n display: flex;\n align-items: center;\n gap: 20px;\n margin-bottom: 24px;\n padding: 16px 20px;\n background: white;\n border-radius: 12px;\n transition: all 0.3s;\n border: 1px solid transparent;\n }\n \n .insight-item:hover {\n transform: translateX(8px);\n border-color: #cbd5e1;\n box-shadow: 0 4px 12px rgba(0, 0, 0, 0.05);\n }\n \n .insight-icon {\n width: 40px;\n height: 40px;\n background: linear-gradient(135deg, #3282B8 0%, #0F4C75 100%);\n border-radius: 10px;\n display: flex;\n align-items: center;\n justify-content: center;\n color: white;\n font-size: 18px;\n font-weight: bold;\n flex-shrink: 0;\n }\n \n .insight-icon::before {\n content: '⦿';\n opacity: 0.7;\n }\n \n .insight-text {\n flex: 1;\n font-size: 15px;\n color: #334155;\n font-weight: 500;\n }\n \n /* Charts Section */\n .charts-section {\n padding: 80px;\n background: linear-gradient(180deg, #f8fafc 0%, #ffffff 100%);\n }\n \n .charts-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(500px, 1fr));\n gap: 50px;\n margin-top: 50px;\n }\n \n .chart-container {\n background: white;\n padding: 50px;\n border-radius: 20px;\n border: 1px solid #e5e7eb;\n box-shadow: 0 4px 20px rgba(0, 0, 0, 0.04);\n transition: all 0.3s;\n }\n \n .chart-container:hover {\n box-shadow: 0 8px 30px rgba(0, 0, 0, 0.08);\n }\n \n .chart-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 40px;\n padding-bottom: 20px;\n border-bottom: 2px solid #e0f2fe;\n }\n \n .chart-title {\n font-size: 22px;\n font-weight: 700;\n color: #1e293b;\n }\n \n .chart-badge {\n padding: 6px 12px;\n background: linear-gradient(180deg, #f8fafc 0%, #f1f5f9 100%);\n border-radius: 20px;\n font-size: 11px;\n font-weight: 600;\n color: #64748b;\n text-transform: uppercase;\n letter-spacing: 1px;\n }\n \n /* Data Tables */\n .data-section {\n padding: 80px;\n background: white;\n }\n \n .table-container {\n margin-top: 50px;\n border-radius: 16px;\n overflow: hidden;\n box-shadow: 0 0 0 1px #e0f2fe;\n }\n \n .data-table {\n width: 100%;\n border-collapse: separate;\n border-spacing: 0;\n background: white;\n }\n \n .data-table thead {\n background: var(--primary-gradient);\n }\n \n .data-table th {\n padding: 20px;\n text-align: left;\n font-size: 11px;\n font-weight: 800;\n color: white;\n text-transform: uppercase;\n letter-spacing: 1.5px;\n }\n \n .data-table td {\n padding: 20px;\n font-size: 14px;\n color: #1e293b;\n border-bottom: 1px solid #f1f5f9;\n transition: all 0.2s;\n }\n \n .data-table tbody tr {\n transition: all 0.3s;\n }\n \n .data-table tbody tr:hover {\n background: linear-gradient(90deg, #f0f9ff 0%, #e0f2fe 100%);\n }\n \n .rank-badge {\n display: inline-flex;\n width: 36px;\n height: 36px;\n background: linear-gradient(135deg, #3282B8 0%, #0F4C75 100%);\n color: white;\n border-radius: 10px;\n align-items: center;\n justify-content: center;\n font-size: 14px;\n font-weight: 800;\n box-shadow: 0 2px 8px rgba(0, 0, 0, 0.1);\n }\n \n .cost-bar-container {\n display: flex;\n align-items: center;\n gap: 12px;\n }\n \n .cost-bar {\n height: 10px;\n background: var(--accent-gradient);\n border-radius: 5px;\n box-shadow: 0 2px 8px rgba(50, 130, 184, 0.2);\n transition: all 0.3s;\n }\n \n .data-table tbody tr:hover .cost-bar {\n transform: scaleY(1.4);\n }\n \n .impact-badge {\n padding: 6px 12px;\n background: linear-gradient(135deg, #dbeafe 0%, #bae6fd 100%);\n border-radius: 20px;\n font-size: 12px;\n font-weight: 700;\n color: #0F4C75;\n }\n \n /* Methodology Section */\n .methodology-section {\n padding: 80px;\n background: linear-gradient(180deg, #f8fafc 0%, #f1f5f9 100%);\n }\n \n .methodology-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));\n gap: 40px;\n margin-top: 50px;\n }\n \n .step-card {\n text-align: center;\n padding: 40px 30px;\n background: white;\n border-radius: 20px;\n border: 1px solid #e5e7eb;\n transition: all 0.4s cubic-bezier(0.4, 0, 0.2, 1);\n position: relative;\n overflow: hidden;\n }\n \n .step-card::before {\n content: '';\n position: absolute;\n top: 0;\n left: 0;\n right: 0;\n height: 3px;\n background: linear-gradient(90deg, #1B262C 0%, #3282B8 100%);\n transform: scaleX(0);\n transition: transform 0.4s;\n }\n \n .step-card:hover {\n transform: translateY(-12px);\n box-shadow: 0 12px 30px rgba(0, 0, 0, 0.1);\n }\n \n .step-card:hover::before {\n transform: scaleX(1);\n }\n \n .step-number {\n width: 80px;\n height: 80px;\n background: linear-gradient(135deg, #ffffff 0%, #f0f9ff 100%);\n border: 4px solid;\n border-image: var(--secondary-gradient) 1;\n border-radius: 24px;\n display: flex;\n align-items: center;\n justify-content: center;\n margin: 0 auto 24px;\n font-size: 32px;\n font-weight: 800;\n color: #3282B8;\n font-family: 'Poppins', sans-serif;\n }\n \n .step-title {\n font-size: 18px;\n font-weight: 700;\n color: #0c4a6e;\n margin-bottom: 12px;\n font-family: 'Poppins', sans-serif;\n }\n \n .step-description {\n font-size: 14px;\n color: #64748b;\n line-height: 1.6;\n }\n \n /* Footer */\n .footer {\n background: linear-gradient(135deg, #0F4C75 0%, #3282B8 50%, #1B262C 100%);\n color: white;\n padding: 60px 80px;\n position: relative;\n overflow: hidden;\n }\n \n .footer::before {\n content: '';\n position: absolute;\n top: 0;\n left: 0;\n right: 0;\n height: 2px;\n background: linear-gradient(90deg, transparent 0%, #BBE1FA 50%, transparent 100%);\n }\n \n .footer-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));\n gap: 60px;\n margin-bottom: 50px;\n }\n \n .footer-section h3 {\n font-size: 20px;\n font-weight: 700;\n margin-bottom: 24px;\n color: #bae6fd;\n font-family: 'Poppins', sans-serif;\n }\n \n .footer-text {\n color: #cbd5e1;\n font-size: 14px;\n line-height: 1.8;\n margin-bottom: 20px;\n }\n \n .footer-links {\n display: flex;\n flex-direction: column;\n gap: 12px;\n }\n \n .footer-link {\n color: #cbd5e1;\n text-decoration: none;\n font-size: 14px;\n transition: all 0.3s;\n display: inline-flex;\n align-items: center;\n gap: 8px;\n }\n \n .footer-link:hover {\n color: #BBE1FA;\n transform: translateX(4px);\n }\n \n .footer-link::before {\n content: '→';\n color: #BBE1FA;\n }\n \n .footer-bottom {\n padding-top: 40px;\n border-top: 1px solid rgba(255,255,255,0.1);\n text-align: center;\n font-size: 13px;\n color: #94a3b8;\n }\n \n /* Responsive Design */\n @media (max-width: 768px) {\n .header {\n padding: 60px 40px;\n }\n \n h1 {\n font-size: 48px;\n }\n \n .kpi-section,\n .executive-section,\n .charts-section,\n .data-section,\n .methodology-section {\n padding: 50px 30px;\n }\n \n .summary-grid {\n grid-template-columns: 1fr;\n }\n \n .charts-grid {\n grid-template-columns: 1fr;\n }\n \n .data-table {\n font-size: 12px;\n }\n \n .data-table th,\n .data-table td {\n padding: 12px;\n }\n }\n \n /* Print Styles */\n @media print {\n body {\n background: white;\n }\n \n .container {\n box-shadow: none;\n }\n \n .header {\n background: #3282B8;\n print-color-adjust: exact;\n -webkit-print-color-adjust: exact;\n }\n }\n </style>\n</head>\n<body>\n <div class=\"container\">\n <!-- Professional Header -->\n <div class=\"header\">\n <div class=\"header-content\">\n <div class=\"header-top\">\n <div class=\"company-brand\">\n <div class=\"company-logo\">${projectName}</div>\n </div>\n <div class=\"report-badge\">Cost Analysis</div>\n </div>\n \n <h1>Project Cost Intelligence</h1>\n <div class=\"subtitle\">Building Element Cost Analysis & Strategic Insights</div>\n \n <div class=\"meta-grid\">\n <div class=\"meta-card\">\n <div class=\"meta-info\">\n <div class=\"meta-label\">Report Date</div>\n <div class=\"meta-value\">${new Date().toLocaleDateString('en-US', { month: 'short', day: 'numeric', year: 'numeric' })}</div>\n </div>\n </div>\n <div class=\"meta-card\">\n <div class=\"meta-info\">\n <div class=\"meta-label\">Total Elements</div>\n <div class=\"meta-value\">${projectTotals.totalElements.toLocaleString()}</div>\n </div>\n </div>\n <div class=\"meta-card\">\n <div class=\"meta-info\">\n <div class=\"meta-label\">Element Groups</div>\n <div class=\"meta-value\">${items.length}</div>\n </div>\n </div>\n <div class=\"meta-card\">\n <div class=\"meta-info\">\n <div class=\"meta-label\">Total Cost</div>\n <div class=\"meta-value\">€${(projectTotals.totalCost / 1000).toFixed(1)}K</div>\n </div>\n </div>\n <div class=\"meta-card\">\n <div class=\"meta-info\">\n <div class=\"meta-label\">Confidence</div>\n <div class=\"meta-value\">${avgConfidence.toFixed(0)}%</div>\n </div>\n </div>\n <div class=\"meta-card\">\n <div class=\"meta-info\">\n <div class=\"meta-label\">Material Types</div>\n <div class=\"meta-value\">${Object.keys(projectTotals.byMaterial).length}</div>\n </div>\n </div>\n </div>\n </div>\n </div>\n \n <!-- Key Performance Indicators -->\n <div class=\"kpi-section\">\n <div class=\"kpi-grid\">\n <div class=\"kpi-card\">\n <div class=\"kpi-icon\">€</div>\n <div class=\"kpi-label\">Total Project Investment</div>\n <div class=\"kpi-value\">€${(projectTotals.totalCost / 1000).toFixed(1)}K</div>\n <div class=\"kpi-unit\">EUR Total Cost</div>\n </div>\n <div class=\"kpi-card\">\n <div class=\"kpi-icon\">↗</div>\n <div class=\"kpi-label\">Average Unit Cost</div>\n <div class=\"kpi-value\">€${(projectTotals.totalCost / projectTotals.totalElements).toFixed(2)}</div>\n <div class=\"kpi-unit\">Per Element</div>\n </div>\n <div class=\"kpi-card\">\n <div class=\"kpi-icon\">□</div>\n <div class=\"kpi-label\">Material Categories</div>\n <div class=\"kpi-value\">${Object.keys(projectTotals.byMaterial).length}</div>\n <div class=\"kpi-unit\">Unique Types</div>\n </div>\n </div>\n </div>\n \n <!-- Executive Summary -->\n <div class=\"executive-section\">\n <div class=\"section-header\">\n <div class=\"section-number\">1</div>\n <h2>Executive Summary</h2>\n </div>\n <div class=\"summary-grid\">\n <div class=\"summary-content\">\n <p>The comprehensive cost analysis reveals a total project estimation of <strong>€${projectTotals.totalCost.toFixed(2)}</strong> across ${projectTotals.totalElements.toLocaleString()} building elements. This assessment encompasses ${Object.keys(projectTotals.byMaterial).length} distinct material categories, providing detailed insights into cost distribution and optimization opportunities.</p>\n \n <p>Our analysis indicates that the top ${Math.min(3, Object.keys(projectTotals.byMaterial).length)} material categories account for <strong>${top3Percentage.toFixed(1)}%</strong> of total project costs, suggesting that focused optimization strategies in these areas could yield significant cost reductions without compromising project quality.</p>\n \n <p>The cost distribution analysis reveals concentration patterns that align with industry benchmarks, while also identifying specific areas where strategic interventions could improve cost efficiency. The high confidence level of ${avgConfidence.toFixed(0)}% in our estimations provides a solid foundation for decision-making.</p>\n </div>\n <div class=\"insight-panel\">\n <h3>Key Strategic Insights</h3>\n <div class=\"insight-item\">\n <div class=\"insight-icon\"></div>\n <div class=\"insight-text\">Primary cost driver: <strong>${topMaterial[0]}</strong> (${((topMaterial[1].cost / projectTotals.totalCost) * 100).toFixed(1)}%)</div>\n </div>\n <div class=\"insight-item\">\n <div class=\"insight-icon\"></div>\n <div class=\"insight-text\">High-impact elements: <strong>${highImpactItems}</strong> groups (>5% each)</div>\n </div>\n <div class=\"insight-item\">\n <div class=\"insight-icon\"></div>\n <div class=\"insight-text\">Analysis confidence: <strong>${avgConfidence.toFixed(0)}%</strong> average</div>\n </div>\n <div class=\"insight-item\">\n <div class=\"insight-icon\"></div>\n <div class=\"insight-text\">Coverage rate: <strong>${coveragePercent.toFixed(0)}%</strong> analyzed</div>\n </div>\n <div class=\"insight-item\">\n <div class=\"insight-icon\"></div>\n <div class=\"insight-text\">Cost per m³: <strong>€${(projectTotals.totalCost / projectTotals.totalVolume).toFixed(2)}</strong></div>\n </div>\n </div>\n </div>\n </div>\n \n <!-- Charts Section -->\n <div class=\"charts-section\">\n <div class=\"section-header\">\n <div class=\"section-number\">2</div>\n <h2>Cost Distribution Analytics</h2>\n </div>\n <div class=\"charts-grid\">\n <div class=\"chart-container\">\n <div class=\"chart-header\">\n <div class=\"chart-title\">Material Cost Distribution</div>\n <div class=\"chart-badge\">Top 6</div>\n </div>\n <canvas id=\"materialPieChart\" style=\"max-height: 350px;\"></canvas>\n </div>\n <div class=\"chart-container\">\n <div class=\"chart-header\">\n <div class=\"chart-title\">Top Cost Contributors</div>\n <div class=\"chart-badge\">Top 10</div>\n </div>\n <canvas id=\"top10BarChart\" style=\"max-height: 350px;\"></canvas>\n </div>\n </div>\n </div>\n \n <!-- Top Contributors Table -->\n <div class=\"data-section\">\n <div class=\"section-header\">\n <div class=\"section-number\">3</div>\n <h2>Cost Leadership Analysis</h2>\n </div>\n <div class=\"table-container\">\n <table class=\"data-table\">\n <thead>\n <tr>\n <th style=\"width: 80px;\">Rank</th>\n <th>Element Group</th>\n <th>Material Type</th>\n <th style=\"width: 120px;\">Quantity</th>\n <th style=\"width: 120px;\">Unit Cost</th>\n <th style=\"width: 200px;\">Total Cost</th>\n <th style=\"width: 100px;\">Impact</th>\n </tr>\n </thead>\n <tbody>\n ${sortedItems.slice(0, 10).map((item, index) => {\n const data = item.json;\n const costPercent = parseFloat(data['Cost % of Total']) || 0;\n const totalCost = parseFloat(data['Total Cost (EUR)']) || 0;\n const maxCost = parseFloat(sortedItems[0].json['Total Cost (EUR)']) || 1;\n const barWidth = (totalCost / maxCost) * 100;\n \n return `<tr>\n <td><span class=\"rank-badge\">${index + 1}</span></td>\n <td><strong>${data['Element Name'] || 'Unknown'}</strong></td>\n <td>${data['Material (EU Standard)'] || 'Unknown'}</td>\n <td>${data['Element Count'] || 0} units</td>\n <td>€${parseFloat(data['Price per Unit (EUR)'] || 0).toFixed(2)}</td>\n <td>\n <div class=\"cost-bar-container\">\n <strong>€${totalCost.toFixed(2)}</strong>\n <div style=\"width: ${barWidth}px; max-width: 80px;\" class=\"cost-bar\"></div>\n </div>\n </td>\n <td><span class=\"impact-badge\">${costPercent.toFixed(1)}%</span></td>\n </tr>`;\n }).join('')}\n </tbody>\n </table>\n </div>\n </div>\n \n <!-- Material Summary -->\n <div class=\"data-section\" style=\"background: linear-gradient(180deg, #f8fafc 0%, #ffffff 100%);\">\n <div class=\"section-header\">\n <div class=\"section-number\">4</div>\n <h2>Material Cost Intelligence</h2>\n </div>\n <div class=\"table-container\">\n <table class=\"data-table\">\n <thead>\n <tr>\n <th>Material Category</th>\n <th style=\"width: 120px;\">Elements</th>\n <th style=\"width: 120px;\">Volume (m³)</th>\n <th style=\"width: 150px;\">Total Cost</th>\n <th style=\"width: 200px;\">Cost Share</th>\n <th style=\"width: 150px;\">Avg. Cost/Unit</th>\n </tr>\n </thead>\n <tbody>\n ${Object.entries(projectTotals.byMaterial)\n .sort((a, b) => b[1].cost - a[1].cost)\n .slice(0, 8)\n .map(([material, data]) => {\n const costPercent = (data.cost / projectTotals.totalCost) * 100;\n const avgCost = data.cost / data.elements;\n \n return `<tr>\n <td><strong>${material}</strong></td>\n <td>${data.elements.toLocaleString()}</td>\n <td>${data.volume.toFixed(2)}</td>\n <td><strong>€${data.cost.toFixed(2)}</strong></td>\n <td>\n <div class=\"cost-bar-container\">\n <span class=\"impact-badge\">${costPercent.toFixed(1)}%</span>\n <div style=\"width: ${costPercent * 2}px; max-width: 100px;\" class=\"cost-bar\"></div>\n </div>\n </td>\n <td>€${avgCost.toFixed(2)}</td>\n </tr>`;\n }).join('')}\n </tbody>\n </table>\n </div>\n </div>\n \n <!-- Cumulative Price Impact -->\n <div class=\"data-section\">\n <div class=\"section-header\">\n <div class=\"section-number\">5</div>\n <h2>Cumulative Price Impact</h2>\n </div>\n <p style=\"color: #64748b; font-size: 14px; margin-top: -20px; margin-bottom: 40px;\">\n Pareto analysis showing concentration of costs\n </p>\n \n <!-- Cumulative Chart -->\n <div style=\"background: white; padding: 40px; border-radius: 16px; border: 1px solid #e5e7eb; margin-bottom: 40px;\">\n <canvas id=\"cumulativeChart\" style=\"max-height: 400px;\"></canvas>\n </div>\n \n <!-- Summary Stats -->\n <div style=\"display: grid; grid-template-columns: repeat(3, 1fr); gap: 24px; margin-top: 40px;\">\n <div style=\"background: #f8fafc; padding: 24px; border-radius: 12px; border-left: 3px solid #3282B8;\">\n <div style=\"font-size: 12px; color: #64748b; margin-bottom: 8px; font-weight: 600;\">TOP 20% OF ITEMS</div>\n <div style=\"font-size: 28px; font-weight: 700; color: #1e293b;\">${(() => {\n const twentyPercentIndex = Math.floor(sortedItems.length * 0.2);\n let sum = 0;\n for(let i = 0; i < twentyPercentIndex && i < sortedItems.length; i++) {\n sum += parseFloat(sortedItems[i].json['Total Cost (EUR)'] || 0);\n }\n return ((sum / projectTotals.totalCost) * 100).toFixed(0);\n })()}%</div>\n <div style=\"font-size: 13px; color: #64748b;\">of total cost</div>\n </div>\n <div style=\"background: #f8fafc; padding: 24px; border-radius: 12px; border-left: 3px solid #0F4C75;\">\n <div style=\"font-size: 12px; color: #64748b; margin-bottom: 8px; font-weight: 600;\">CONCENTRATION RATIO</div>\n <div style=\"font-size: 28px; font-weight: 700; color: #1e293b;\">${(() => {\n let sum = 0;\n let count = 0;\n for(let i = 0; i < sortedItems.length; i++) {\n sum += parseFloat(sortedItems[i].json['Total Cost (EUR)'] || 0);\n count++;\n if(sum >= projectTotals.totalCost * 0.8) break;\n }\n return ((count / sortedItems.length) * 100).toFixed(0);\n })()}%</div>\n <div style=\"font-size: 13px; color: #64748b;\">items = 80% cost</div>\n </div>\n <div style=\"background: #f8fafc; padding: 24px; border-radius: 12px; border-left: 3px solid #1B262C;\">\n <div style=\"font-size: 12px; color: #64748b; margin-bottom: 8px; font-weight: 600;\">OPTIMIZATION POTENTIAL</div>\n <div style=\"font-size: 28px; font-weight: 700; color: #1e293b;\">High</div>\n <div style=\"font-size: 13px; color: #64748b;\">cost concentration</div>\n </div>\n </div>\n </div>\n \n <!-- Methodology Section -->\n <div class=\"methodology-section\">\n <div class=\"section-header\">\n <div class=\"section-number\">6</div>\n <h2>Analysis Methodology</h2>\n </div>\n \n <div class=\"methodology-grid\">\n <div class=\"step-card\">\n <div class=\"step-number\">1</div>\n <div class=\"step-title\">Data Extraction</div>\n <div class=\"step-description\">Automated extraction of building element data from CAD (BIM) projects (Revit or IFC (in certain cases DWG)), including geometric parameters, material specifications, volumes, and quantities. This step ensures comprehensive capture of all relevant project elements using specialized parsing algorithms.</div>\n </div>\n <div class=\"step-card\">\n <div class=\"step-number\">2</div>\n <div class=\"step-title\">AI Classification & Enrichment</div>\n <div class=\"step-description\"> AI models classify elements into standardized EU material categories, identify potential substitutes, and enrich data with market insights. Machine learning algorithms analyze patterns to determine accurate material mappings and cost drivers.</div>\n </div>\n <div class=\"step-card\">\n <div class=\"step-number\">3</div>\n <div class=\"step-title\">Cost Estimation & Validation</div>\n <div class=\"step-description\">Integration of real-time market pricing data with quantity takeoffs to compute unit and total costs. Multi-source validation ensures accuracy, with confidence scoring based on data completeness, market volatility, and historical benchmarks.</div>\n </div>\n <div class=\"step-card\">\n <div class=\"step-number\">4</div>\n <div class=\"step-title\">Analytics & Visualization</div>\n <div class=\"step-description\">Aggregation of cost data into strategic insights, including Pareto analysis, distribution charts, and optimization recommendations. Interactive visualizations enable deep dives into cost structures for informed decision-making.</div>\n </div>\n </div>\n </div>\n \n <!-- Footer -->\n <div class=\"footer\">\n <div class=\"footer-grid\">\n <div class=\"footer-section\">\n <h3>About This Report</h3>\n <p class=\"footer-text\">\n \n </p>\n <p class=\"footer-text\">\n Analysis Date: ${new Date().toLocaleString()}<br>\n Confidence Level: ${avgConfidence.toFixed(0)}%<br>\n Coverage: ${items.length} element groups analyzed\n </p>\n </div>\n \n <div class=\"footer-section\">\n <h3>Contact & Resources</h3>\n <div class=\"footer-links\">\n <a href=\"https://datadrivenconstruction.io\" class=\"footer-link\">DataDrivenConstruction.io</a>\n <a href=\"https://github.com/datadrivenconstruction\" class=\"footer-link\">GitHub Repository</a>\n <a href=\"mailto:info@datadrivenconstruction.io\" class=\"footer-link\">Contact Support</a>\n \n </div>\n </div>\n \n <div class=\"footer-section\">\n <h3>Report</h3>\n <p class=\"footer-text\">\n This comprehensive cost analysis report was generated using advanced AI-powered estimation algorithms developed by DataDrivenConstruction.io. Our tools combines machine learning with industry expertise to deliver accurate, actionable insights.\n </p>\n </div>\n </div>\n <div class=\"footer-bottom\">\n <p>© ${new Date().getFullYear()} DataDrivenConstruction.io </p>\n </div>\n </div>\n </div>\n \n <script>\n // Configure Chart.js defaults\n Chart.defaults.font.family = \"'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', sans-serif\";\n \n // Prepare cumulative data with element names\n const cumulativeData = [];\n const cumulativePercentages = [];\n const elementNames = [];\n const individualCosts = [];\n let cumSum = 0;\n \n ${(() => {\n let jsData = 'const itemsData = [\\n';\n sortedItems.forEach((item, index) => {\n const cost = parseFloat(item.json['Total Cost (EUR)'] || 0);\n const name = item.json['Element Name'] || 'Unknown';\n if(index > 0) jsData += ',\\n';\n jsData += ` {cost: ${cost.toFixed(2)}, name: \"${name.replace(/\"/g, '\\\\\"')}\"}`;\n });\n jsData += '\\n];\\n';\n jsData += `const totalCost = ${projectTotals.totalCost};\\n`;\n return jsData;\n })()}\n \n // Calculate cumulative values\n itemsData.forEach((item, index) => {\n cumSum += item.cost;\n cumulativeData.push(cumSum);\n cumulativePercentages.push((cumSum / totalCost) * 100);\n elementNames.push(item.name);\n individualCosts.push(item.cost);\n });\n \n // Create labels for x-axis (just empty for clean look)\n const labels = cumulativeData.map((_, index) => '');\n \n // Cumulative Chart\n const cumulativeCtx = document.getElementById('cumulativeChart').getContext('2d');\n new Chart(cumulativeCtx, {\n type: 'line',\n data: {\n labels: labels,\n datasets: [\n {\n label: 'Cumulative Cost',\n data: cumulativeData,\n borderColor: '#3282B8',\n backgroundColor: 'rgba(50, 130, 184, 0.1)',\n borderWidth: 3,\n fill: true,\n tension: 0.4,\n pointRadius: 1,\n pointHoverRadius: 6,\n pointBackgroundColor: '#3282B8',\n pointBorderColor: '#fff',\n pointBorderWidth: 2,\n yAxisID: 'y'\n },\n {\n label: 'Cumulative %',\n data: cumulativePercentages,\n borderColor: '#3282B8',\n borderWidth: 2,\n borderDash: [5, 5],\n fill: false,\n tension: 0.4,\n pointRadius: 0,\n pointHoverRadius: 5,\n yAxisID: 'y1'\n }\n ]\n },\n options: {\n responsive: true,\n maintainAspectRatio: true,\n interaction: {\n mode: 'index',\n intersect: false\n },\n plugins: {\n legend: {\n display: true,\n position: 'top',\n labels: {\n usePointStyle: true,\n padding: 20,\n font: {\n size: 12,\n weight: '500'\n }\n }\n },\n tooltip: {\n backgroundColor: 'rgba(15, 23, 42, 0.95)',\n titleFont: {\n size: 14,\n weight: '600'\n },\n bodyFont: {\n size: 12\n },\n padding: 14,\n cornerRadius: 8,\n displayColors: false,\n callbacks: {\n title: function(context) {\n const index = context[0].dataIndex;\n return elementNames[index];\n },\n label: function(context) {\n const index = context.dataIndex;\n if (context.datasetIndex === 0) {\n return [\n 'Position: ' + (index + 1) + ' of ' + itemsData.length,\n 'Individual Cost: €' + individualCosts[index].toFixed(2),\n 'Cumulative Cost: €' + context.parsed.y.toFixed(2),\n 'Cumulative %: ' + cumulativePercentages[index].toFixed(1) + '%'\n ];\n }\n return null;\n }\n }\n }\n },\n scales: {\n x: {\n display: true,\n grid: {\n display: false\n },\n ticks: {\n display: false\n },\n title: {\n display: true,\n text: 'Elements (sorted by cost)',\n font: {\n size: 12,\n weight: '500'\n },\n color: '#64748b'\n }\n },\n y: {\n type: 'linear',\n display: true,\n position: 'left',\n beginAtZero: true,\n grid: {\n color: 'rgba(0, 0, 0, 0.05)',\n borderDash: [3, 3]\n },\n ticks: {\n font: {\n size: 11\n },\n callback: function(value) {\n if (value >= 1000) {\n return '€' + (value / 1000).toFixed(0) + 'k';\n }\n return '€' + value.toFixed(0);\n }\n },\n title: {\n display: true,\n text: 'Cumulative Cost (EUR)',\n font: {\n size: 12,\n weight: '500'\n },\n color: '#64748b'\n }\n },\n y1: {\n type: 'linear',\n display: true,\n position: 'right',\n beginAtZero: true,\n max: 110,\n grid: {\n drawOnChartArea: false\n },\n ticks: {\n font: {\n size: 11\n },\n callback: function(value) {\n return value + '%';\n }\n },\n title: {\n display: true,\n text: 'Cumulative Percentage',\n font: {\n size: 12,\n weight: '500'\n },\n color: '#64748b'\n }\n }\n }\n }\n });\n \n // Material Distribution Pie Chart\n const materialCtx = document.getElementById('materialPieChart').getContext('2d');\n const materialData = ${JSON.stringify(materialChartData)};\n \n new Chart(materialCtx, {\n type: 'doughnut',\n data: {\n labels: materialData.map(d => d.label),\n datasets: [{\n data: materialData.map(d => d.value),\n backgroundColor: [\n '#3282B8',\n '#0F4C75',\n '#1B262C',\n '#BBE1FA',\n '#4F6D7A',\n '#6D9CBE'\n ],\n borderWidth: 3,\n borderColor: '#fff',\n hoverOffset: 8\n }]\n },\n options: {\n responsive: true,\n maintainAspectRatio: true,\n plugins: {\n legend: {\n position: 'bottom',\n labels: {\n padding: 20,\n font: {\n size: 13,\n weight: '500'\n },\n usePointStyle: true,\n pointStyle: 'circle'\n }\n },\n tooltip: {\n backgroundColor: 'rgba(15, 23, 42, 0.9)',\n titleFont: {\n size: 14,\n weight: '600'\n },\n bodyFont: {\n size: 13\n },\n padding: 12,\n cornerRadius: 8,\n callbacks: {\n label: function(context) {\n const value = context.raw;\n const total = context.dataset.data.reduce((a, b) => a + b, 0);\n const percentage = ((value / total) * 100).toFixed(1);\n return context.label + ': €' + value.toFixed(2) + ' (' + percentage + '%)';\n }\n }\n }\n }\n }\n });\n \n // Top 10 Bar Chart\n const barCtx = document.getElementById('top10BarChart').getContext('2d');\n const barData = ${JSON.stringify(barChartData)};\n \n new Chart(barCtx, {\n type: 'bar',\n data: {\n labels: barData.map(d => d.label.length > 25 ? d.label.substring(0, 25) + '...' : d.label),\n datasets: [{\n label: 'Cost (EUR)',\n data: barData.map(d => d.value),\n backgroundColor: 'rgba(50, 130, 184, 0.8)',\n borderColor: 'rgba(15, 76, 117, 1)',\n borderWidth: 2,\n borderRadius: 8,\n hoverBackgroundColor: 'rgba(50, 130, 184, 0.9)'\n }]\n },\n options: {\n responsive: true,\n maintainAspectRatio: true,\n indexAxis: 'y',\n plugins: {\n legend: {\n display: false\n },\n tooltip: {\n backgroundColor: 'rgba(15, 23, 42, 0.9)',\n titleFont: {\n size: 14,\n weight: '600'\n },\n bodyFont: {\n size: 13\n },\n padding: 12,\n cornerRadius: 8,\n callbacks: {\n label: function(context) {\n return '€' + context.raw.toFixed(2);\n }\n }\n }\n },\n scales: {\n x: {\n beginAtZero: true,\n grid: {\n color: 'rgba(50, 130, 184, 0.05)',\n borderDash: [5, 5]\n },\n ticks: {\n font: {\n size: 12\n },\n callback: function(value) {\n return '€' + value.toLocaleString();\n }\n }\n },\n y: {\n grid: {\n display: false\n },\n ticks: {\n font: {\n size: 12,\n weight: '500'\n }\n }\n }\n }\n }\n });\n </script>\n</body>\n</html>`;\n\nreturn [{\n json: {\n html: html,\n timestamp: new Date().toISOString(),\n reportType: 'Executive Cost Analysis',\n totalItems: items.length,\n totalCost: projectTotals.totalCost\n }\n}];"
},
"typeVersion": 2
},
{
"id": "e99d0ff0-79ea-4ed1-9878-a23986efe41b",
"name": "转换为二进制",
"type": "n8n-nodes-base.code",
"position": [
1776,
1568
],
"parameters": {
"jsCode": "const html = $json.html;\n\nreturn [{\n binary: {\n data: {\n data: Buffer.from(html).toString('base64'),\n mimeType: 'text/html',\n fileName: 'price_estimation_report.html'\n }\n }\n}];"
},
"typeVersion": 2
},
{
"id": "80908a5f-3838-4f47-b579-cadb189cea31",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
432
],
"parameters": {
"width": 340,
"height": 116,
"content": "⭐ **如果您觉得我们的工具有用**，请考虑在[GitHub](https://github.com/datadrivenconstruction/cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto)上**给我们的仓库加星**。"
},
"typeVersion": 1
},
{
"id": "478155e4-eb87-4684-9546-871dfb3577f0",
"name": "使用AI规则分组数据1",
"type": "n8n-nodes-base.code",
"position": [
2256,
544
],
"parameters": {
"jsCode": "\n const input = $input.first().json;\n const aggregationRules = input.aggregationRules;\n const headerMapping = input.headerMapping;\n const rawData = input.rawData;\n const groupByParamOriginal = input.groupByParam;\n\n\n const groupByParam = headerMapping[groupByParamOriginal] || groupByParamOriginal;\n\n console.log(`Grouping ${rawData.length} items by: ${groupByParam}`);\n\n\n const cleanedData = rawData.map(item => {\n const cleaned = {};\n Object.entries(item).forEach(([key, value]) => {\n const newKey = headerMapping[key] || key;\n cleaned[newKey] = value;\n });\n return cleaned;\n });\n\n\n const grouped = {};\n\n\n cleanedData.forEach(item => {\n const groupKey = item[groupByParam];\n \n if (!groupKey || groupKey === '' || groupKey === null) return;\n \n if (!grouped[groupKey]) {\n grouped[groupKey] = {\n _count: 0,\n _values: {}\n };\n \n \n Object.keys(aggregationRules).forEach(param => {\n if (param !== groupByParam) {\n grouped[groupKey]._values[param] = [];\n }\n });\n }\n \n grouped[groupKey]._count++;\n \n \n Object.entries(item).forEach(([key, value]) => {\n if (key === groupByParam) return;\n \n if (value !== null && value !== undefined && value !== '' && grouped[groupKey]._values[key]) {\n grouped[groupKey]._values[key].push(value);\n }\n });\n });\n\n\n const result = [];\n\n Object.entries(grouped).forEach(([groupKey, groupData]) => {\n const aggregated = {\n [groupByParam]: groupKey,\n 'Element Count': groupData._count\n };\n \n \n Object.entries(groupData._values).forEach(([param, values]) => {\n const rule = aggregationRules[param] || 'first';\n \n if (values.length === 0) {\n aggregated[param] = null;\n return;\n }\n \n switch(rule) {\n case 'sum':\n const numericValues = values.map(v => {\n const num = parseFloat(String(v).replace(',', '.'));\n return isNaN(num) ? 0 : num;\n });\n aggregated[param] = numericValues.reduce((a, b) => a + b, 0);\n \n if (aggregated[param] % 1 !== 0) {\n aggregated[param] = Math.round(aggregated[param] * 100) / 100;\n }\n break;\n \n case 'mean':\n case 'average':\n const avgValues = values.map(v => {\n const num = parseFloat(String(v).replace(',', '.'));\n return isNaN(num) ? null : num;\n }).filter(v => v !== null);\n \n if (avgValues.length > 0) {\n const avg = avgValues.reduce((a, b) => a + b, 0) / avgValues.length;\n aggregated[param] = Math.round(avg * 100) / 100;\n } else {\n aggregated[param] = values[0];\n }\n break;\n \n case 'first':\n default:\n aggregated[param] = values[0];\n break;\n }\n });\n \n result.push({ json: aggregated });\n });\n\n\n result.sort((a, b) => {\n const aVal = a.json[groupByParam];\n const bVal = b.json[groupByParam];\n if (aVal < bVal) return -1;\n if (aVal > bVal) return 1;\n return 0;\n });\n\n console.log(`\\nGrouping complete:`);\n console.log(`- Input items: ${cleanedData.length}`);\n console.log(`- Output groups: ${result.length}`);\n console.log(`- Parameters processed: ${Object.keys(aggregationRules).length}`);\n\n\n const rulesSummary = { sum: [], mean: [], first: [] };\n Object.entries(aggregationRules).forEach(([param, rule]) => {\n if (rulesSummary[rule]) rulesSummary[rule].push(param);\n });\n\n console.log('\\nAggregation summary:');\n if (rulesSummary.sum.length > 0) {\n console.log(`- SUM (${rulesSummary.sum.length}): ${rulesSummary.sum.slice(0, 5).join(', ')}${rulesSummary.sum.length > 5 ? '...' : ''}`);\n }\n if (rulesSummary.mean.length > 0) {\n console.log(`- MEAN (${rulesSummary.mean.length}): ${rulesSummary.mean.slice(0, 5).join(', ')}${rulesSummary.mean.length > 5 ? '...' : ''}`);\n }\n if (rulesSummary.first.length > 0) {\n console.log(`- FIRST (${rulesSummary.first.length}): ${rulesSummary.first.slice(0, 5).join(', ')}${rulesSummary.first.length > 5 ? '...' : ''}`);\n }\n\n return result;"
},
"typeVersion": 2
},
{
"id": "45d8e0e5-591b-4469-9766-501806e5f7a1",
"name": "提取表头和数据",
"type": "n8n-nodes-base.code",
"position": [
1584,
544
],
"parameters": {
"jsCode": "\n const items = $input.all();\n if (items.length === 0) {\n throw new Error('No data found in Excel file');\n }\n\n\n const allHeaders = new Set();\n items.forEach(item => {\n Object.keys(item.json).forEach(key => allHeaders.add(key));\n });\n\n\n const headers = Array.from(allHeaders);\n const cleanedHeaders = headers.map(header => {\n return header.replace(/:\\s*(string|double|int|float|boolean|number)\\s*$/i, '').trim();\n });\n\n\n const headerMapping = {};\n headers.forEach((oldHeader, index) => {\n headerMapping[oldHeader] = cleanedHeaders[index];\n });\n\n\n const sampleValues = {};\n cleanedHeaders.forEach((header, index) => {\n const originalHeader = headers[index];\n for (const item of items) {\n const value = item.json[originalHeader];\n if (value !== null && value !== undefined && value !== '') {\n sampleValues[header] = value;\n break;\n }\n }\n if (!sampleValues[header]) {\n sampleValues[header] = null;\n }\n });\n\n console.log(`Found ${headers.length} unique headers across ${items.length} items`);\n\n\n return [{\n json: {\n headers: cleanedHeaders,\n originalHeaders: headers,\n headerMapping: headerMapping,\n sampleValues: sampleValues,\n totalRows: items.length,\n totalHeaders: headers.length,\n \n rawData: items.map(item => item.json)\n }\n }];"
},
"typeVersion": 2
},
{
"id": "d501723a-bf02-4e1b-8f24-5811500868f4",
"name": "AI 分析所有表头",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1728,
544
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {
"temperature": 0.1
},
"messages": {
"values": [
{
"role": "system",
"content": "You are an expert in construction classification systems. Analyze building element groups and assign aggregation methods for grouping data.\n\nRules:\n1. 'sum' - for quantities that should be totaled:\n - Volume, Area, Length, Width, Height, Depth, Size\n - Count, Quantity, Number, Amount, Total\n - Thickness, Perimeter, Dimension\n - Weight, Mass, Load\n - Any measurable physical property that accumulates\n\n2. 'mean' (average) - for rates and unit values:\n - Price, Cost, Rate (per unit)\n - Coefficient, Factor, Ratio\n - Percentage, Percent\n - Efficiency, Performance metrics\n - Any per-unit or normalized values\n\n3. 'first' - for descriptive/categorical data:\n - ID, Code, Number (when used as identifier)\n - Name, Title, Description\n - Type, Category, Class, Group\n - Material, Component, Element\n - Project, Building, Location\n - Status, Phase, Stage\n - Any text or categorical field\n\nIMPORTANT: \n- Analyze each header carefully\n- Consider both the header name AND sample value\n- Return aggregation rule for EVERY header provided\n- Use exact header names from input\n\nReturn ONLY valid JSON in this exact format:\n{\n \"aggregation_rules\": {\n \"Header1\": \"sum\",\n \"Header2\": \"first\",\n \"Header3\": \"mean\"\n }\n}"
},
{
"content": "Analyze these {{ $json.totalHeaders }} headers and determine aggregation method for each:\n\nHeaders with sample values:\n{{ JSON.stringify($json.sampleValues, null, 2) }}\n\nProvide aggregation rule for EACH header listed above."
}
]
}
},
"credentials": {
"openAiApi": {
"id": "5SwKOx6OOukR6C0w",
"name": "OpenAi account n8n"
}
},
"typeVersion": 1.3
},
{
"id": "03b8267f-6ff1-4793-8a03-1c8ba934dbe9",
"name": "读取 Excel 文件1",
"type": "n8n-nodes-base.readBinaryFile",
"position": [
1216,
544
],
"parameters": {
"filePath": "={{ $json.path_to_file }}"
},
"typeVersion": 1
},
{
"id": "b265c8fd-6d6b-49a1-802f-e25598569273",
"name": "解析 Excel1",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
1408,
544
],
"parameters": {
"options": {
"headerRow": true,
"sheetName": "={{ $node['Set Parameters1'].json.sheet_name }}",
"includeEmptyCells": false
},
"fileFormat": "xlsx"
},
"typeVersion": 2
},
{
"id": "4430c041-3a5d-4235-b092-fcd6c7b4a0ba",
"name": "创建 - Excel 文件名1",
"type": "n8n-nodes-base.set",
"position": [
1376,
-64
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "xlsx-filename-id",
"name": "xlsx_filename",
"type": "string",
"value": "={{ $json[\"project_file\"].slice(0, -4) + \"_rvt.xlsx\" }}"
},
{
"id": "path-to-converter-pass",
"name": "path_to_converter",
"type": "string",
"value": "={{ $json[\"path_to_converter\"] }}"
},
{
"id": "project-file-pass",
"name": "project_file",
"type": "string",
"value": "={{ $json[\"project_file\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "7ff93cb0-8c5a-4dfb-97d0-3caaa1940bc8",
"name": "检查 - Excel 文件是否存在？1",
"type": "n8n-nodes-base.readBinaryFile",
"position": [
1568,
-64
],
"parameters": {
"filePath": "={{ $json[\"xlsx_filename\"] }}"
},
"typeVersion": 1,
"continueOnFail": true,
"alwaysOutputData": true
},
{
"id": "93cc0ed5-4eac-4907-8638-65010834605a",
"name": "如果 - 文件存在？1",
"type": "n8n-nodes-base.if",
"position": [
1744,
-64
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e7fb1577-e753-43f5-9f5a-4d5285aeb96e",
"operator": {
"type": "boolean",
"operation": "equals"
},
"leftValue": "={{ $binary.data ? true : false }}",
"rightValue": "={{ true }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "85ead84d-193e-46c0-9d9f-9ccc07f2518b",
"name": "提取 - 运行转换器1",
"type": "n8n-nodes-base.executeCommand",
"position": [
1504,
144
],
"parameters": {
"command": "=\"{{$node[\"Setup - Define file paths\"].json[\"path_to_converter\"]}}\" \"{{$node[\"Setup - Define file paths\"].json[\"project_file\"]}}\""
},
"typeVersion": 1,
"continueOnFail": true
},
{
"id": "8b6b3e88-90b9-4dbc-81fd-9aa8378f8981",
"name": "信息 - 跳过转换1",
"type": "n8n-nodes-base.set",
"position": [
1936,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "status-id",
"name": "status",
"type": "string",
"value": "File already exists - skipping conversion"
},
{
"id": "xlsx-filename-id",
"name": "xlsx_filename",
"type": "string",
"value": "={{ $node[\"Create - Excel filename1\"].json[\"xlsx_filename\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5b2c4e88-5254-4682-a1d2-8f200952fba4",
"name": "检查 - 提取是否成功？1",
"type": "n8n-nodes-base.if",
"position": [
1712,
144
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "condition1",
"operator": {
"type": "object",
"operation": "exists",
"rightType": "any"
},
"leftValue": "={{ $node[\"Extract - Run converter1\"].json.error }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "672e73cc-d8a8-4033-8b7a-347ef46ba89a",
"name": "错误 - 显示问题详情1",
"type": "n8n-nodes-base.set",
"position": [
1936,
80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "error-message-id",
"name": "error_message",
"type": "string",
"value": "=Extraction failed: {{ $node[\"Extract - Run converter1\"].json.error || \"Unknown error\" }}"
},
{
"id": "error-code-id",
"name": "error_code",
"type": "number",
"value": "={{ $node[\"Extract - Run converter1\"].json.code || -1 }}"
},
{
"id": "xlsx-filename-error",
"name": "xlsx_filename",
"type": "string",
"value": "={{ $node[\"Create - Excel filename1\"].json[\"xlsx_filename\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "a99bdd3b-76e0-4517-8258-c78f009d0653",
"name": "成功后设置 xlsx 文件名1",
"type": "n8n-nodes-base.set",
"position": [
1936,
256
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "xlsx-filename-success",
"name": "xlsx_filename",
"type": "string",
"value": "={{ $node[\"Create - Excel filename1\"].json[\"xlsx_filename\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c60ea846-191c-43d1-a883-131524e2f152",
"name": "合并 - 继续工作流1",
"type": "n8n-nodes-base.merge",
"position": [
2128,
-16
],
"parameters": {},
"typeVersion": 3
},
{
"id": "642d6337-d6a4-4079-ba9d-f42b7c69286f",
"name": "设置参数1",
"type": "n8n-nodes-base.set",
"position": [
2272,
272
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "path-id",
"name": "path_to_file",
"type": "string",
"value": "={{ $json.xlsx_filename }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "52e54e39-139e-4985-a654-fce750204100",
"name": "处理AI响应1",
"type": "n8n-nodes-base.code",
"position": [
2064,
544
],
"parameters": {
"jsCode": "\n const aiResponse = $input.first().json;\n const headerData = $node['Extract Headers and Data'].json;\n\n\n let aiRules = {};\n try {\n const content = aiResponse.content || aiResponse.message || aiResponse.response || '';\n console.log('AI Response received, length:', content.length);\n \n \n const jsonMatch = content.match(/\\{[\\s\\S]*\\}/);\n if (jsonMatch) {\n const parsed = JSON.parse(jsonMatch[0]);\n aiRules = parsed.aggregation_rules || parsed.parameter_aggregation || {};\n console.log(`AI provided ${Object.keys(aiRules).length} rules`);\n } else {\n console.warn('No JSON found in AI response');\n }\n } catch (error) {\n console.error('Error parsing AI response:', error.message);\n }\n\n\n const finalRules = {};\n headerData.headers.forEach(header => {\n if (aiRules[header]) {\n finalRules[header] = aiRules[header];\n } else {\n \n const lowerHeader = header.toLowerCase();\n \n if (lowerHeader.match(/volume|area|length|width|height|count|quantity|thickness|perimeter|depth|size|dimension|weight|mass|total|amount|number/)) {\n finalRules[header] = 'sum';\n } else if (lowerHeader.match(/price|rate|cost|coefficient|factor|percent|ratio|efficiency|avg|average|mean/)) {\n finalRules[header] = 'mean';\n } else {\n finalRules[header] = 'first';\n }\n }\n });\n\n const groupByParam = $node['Setup - Define file paths'].json.group_by;\n\n console.log(`\\nAggregation rules summary:`);\n console.log(`- Total headers: ${headerData.headers.length}`);\n console.log(`- AI rules: ${Object.keys(aiRules).length}`);\n console.log(`- Default rules: ${headerData.headers.length - Object.keys(aiRules).length}`);\n console.log(`- Group by: ${groupByParam}`);\n\n\n return [{\n json: {\n aggregationRules: finalRules,\n headerMapping: headerData.headerMapping,\n headers: headerData.headers,\n originalHeaders: headerData.originalHeaders,\n rawData: headerData.rawData,\n groupByParam: groupByParam,\n totalRows: headerData.totalRows\n }\n }];"
},
"typeVersion": 2
},
{
"id": "0cb35fda-f4ee-4428-9bfa-a6630519908e",
"name": "造价分析与报告模块1",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1504
],
"parameters": {
"color": 5,
"width": 1920,
"height": 448,
"content": "## 模块 4：造价计算与报告"
},
"typeVersion": 1
},
{
"id": "77e86578-5835-4b05-9ed0-0cf4789f9e73",
"name": "元素分类块",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
752
],
"parameters": {
"color": 6,
"width": 1920,
"height": 320,
"content": "## 模块 2：构件分类"
},
"typeVersion": 1
},
{
"id": "a96c6ebe-b70a-444e-bbff-10db7b42be76",
"name": "材料分析块",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1088
],
"parameters": {
"color": 6,
"width": 1920,
"height": 400,
"content": "## 模块 3：材料分析"
},
"typeVersion": 1
},
{
"id": "20b27e18-a7bd-491d-9972-6a096633b6ed",
"name": "转换块",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
-272
],
"parameters": {
"color": 5,
"width": 1912,
"height": 708,
"content": "## 转换模块"
},
"typeVersion": 1
},
{
"id": "3bd50143-1a76-4ae4-8e4a-904375a45201",
"name": "数据加载模块1",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
464
],
"parameters": {
"color": 6,
"width": 1920,
"height": 272,
"content": "## 模块 1：数据加载与分组"
},
"typeVersion": 1
},
{
"id": "95340b29-d6b6-4aa4-b850-4166f1ff186e",
"name": "重要说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
128
],
"parameters": {
"width": 336,
"height": 288,
"content": "## ⚠️ 重要信息"
},
"typeVersion": 1
},
{
"id": "9887f607-85f0-41d5-92d8-9c6e655f6581",
"name": "准备HTML路径",
"type": "n8n-nodes-base.code",
"position": [
1936,
1568
],
"parameters": {
"jsCode": "// Get the project file path from the original setup\nconst projectFile = $node['Setup - Define file paths'].json.project_file;\nconst htmlContent = $node['Convert to Binary'].json.html || $input.first().binary.data;\n\n// Extract directory path from project file\nconst path = projectFile.substring(0, projectFile.lastIndexOf('\\\\'));\n\n// Create filename with timestamp\nconst timestamp = new Date().toISOString().slice(0,10);\nconst htmlFileName = `CO2_Analysis_Report_${timestamp}.html`;\nconst fullPath = `${path}\\\\${htmlFileName}`;\n\nconsole.log('Project file:', projectFile);\nconsole.log('Directory:', path);\nconsole.log('HTML file will be saved to:', fullPath);\n\nreturn [{\n json: {\n html_filename: htmlFileName,\n full_path: fullPath,\n directory: path,\n project_file: projectFile\n },\n binary: $input.first().binary\n}];"
},
"typeVersion": 2
},
{
"id": "24be1fea-bdcb-491b-afb8-170431f8f198",
"name": "将HTML写入项目文件夹",
"type": "n8n-nodes-base.writeBinaryFile",
"position": [
2112,
1568
],
"parameters": {
"options": {},
"fileName": "={{ $json.full_path }}"
},
"typeVersion": 1
},
{
"id": "c4d015d4-b040-4aa7-a4c5-cc22d3ab7eb4",
"name": "在浏览器中打开HTML",
"type": "n8n-nodes-base.executeCommand",
"position": [
2288,
1568
],
"parameters": {
"command": "=start \"\" \"{{ $json.full_path }}\""
},
"typeVersion": 1
},
{
"id": "01bcb7a4-534b-46ee-9462-b8f1aaf813e8",
"name": "准备 Excel 路径1",
"type": "n8n-nodes-base.code",
"position": [
2112,
1744
],
"parameters": {
"jsCode": "// Similar logic for Excel file\nconst projectFile = $node['Setup - Define file paths'].json.project_file;\n\n// Extract directory path from project file\nconst path = projectFile.substring(0, projectFile.lastIndexOf('\\\\'));\n\n// Create filename with timestamp\nconst timestamp = new Date().toISOString().slice(0,10);\nconst excelFileName = `CO2_Analysis_Professional_Report_${timestamp}.xlsx`;\nconst fullPath = `${path}\\\\${excelFileName}`;\n\nconsole.log('Excel file will be saved to:', fullPath);\n\nreturn [{\n json: {\n excel_filename: excelFileName,\n full_path: fullPath,\n directory: path,\n project_file: projectFile\n },\n binary: $input.first().binary\n}];"
},
"typeVersion": 2
},
{
"id": "694efc44-ce97-44d1-a34d-84fce917a0e9",
"name": "写入 Excel 到项目文件夹1",
"type": "n8n-nodes-base.writeBinaryFile",
"position": [
2288,
1744
],
"parameters": {
"options": {},
"fileName": "={{ $json.full_path }}"
},
"typeVersion": 1
},
{
"id": "297ac011-ea69-4975-b9e5-e14a1b6730b9",
"name": "设置 - 定义文件路径",
"type": "n8n-nodes-base.set",
"position": [
1168,
-64
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "9cbd4ec9-df24-41e8-b47a-720a4cdb733b",
"name": "path_to_converter",
"type": "string",
"value": "C:\\Users\\Artem Boiko\\Desktop\\n8n pipelines\\DDC_Converter_Revit\\datadrivenlibs\\RvtExporter.exe"
},
{
"id": "aa834467-80fb-476a-bac1-6728478834f0",
"name": "project_file",
"type": "string",
"value": "C:\\Users\\Artem Boiko\\Desktop\\n8n\\cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto-main\\cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto-main\\Sample_Projects\\ra_basic_sample_revit_somegroups.rvt"
},
{
"id": "4e4f5e6f-7a8b-4c5d-9e0f-1a2b3c4d5e6f",
"name": "group_by",
"type": "string",
"value": "Type Name"
},
{
"id": "5f6a7b8c-9d0e-4f1a-2b3c-4d5e6f7a8b9c",
"name": "country",
"type": "string",
"value": "Germany"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "a2363cf4-bd62-410c-a52b-e5d2c4760940",
"name": "转换块1",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
-400
],
"parameters": {
"color": 5,
"width": 952,
"height": 112,
"content": "# 使用 AI（LLM）为 Revit 和 IFC 进行项目成本计算"
},
"typeVersion": 1
},
{
"id": "0af0bac5-4f11-4a99-bc74-0d99827754cb",
"name": "设置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-272
],
"parameters": {
"width": 336,
"height": 384,
"content": "## 📝 设置说明"
},
"typeVersion": 1
},
{
"id": "b2243495-e0c0-4bd7-8118-701d33d20c6f",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1616,
1312
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-3.5-turbo",
"cachedResultName": "gpt-3.5-turbo"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "5SwKOx6OOukR6C0w",
"name": "OpenAi account n8n"
}
},
"typeVersion": 1.2
},
{
"id": "2c6de4d3-cf23-4748-aff3-2bdc1f602ae5",
"name": "xAI Grok聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatXAiGrok",
"position": [
1776,
1312
],
"parameters": {
"options": {}
},
"credentials": {
"xAiApi": {
"id": "JKhw9fFrSig9QNQB",
"name": "xAi account"
}
},
"typeVersion": 1
},
{
"id": "80f0dd52-efa5-45ce-9812-d75ec19d9fb0",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1104,
-240
],
"parameters": {
"color": 4,
"width": 224,
"height": 368,
"content": "## ⬇️ 仅在此处修改变量"
},
"typeVersion": 1
},
{
"id": "9d8c252c-4dd6-434e-a3c6-18f7a0b1d2e5",
"name": "在标准3D视图上",
"type": "n8n-nodes-base.if",
"position": [
1184,
816
],
"parameters": {
"conditions": {
"boolean": [
{
"value1": "={{ $json['On the standard 3D View'] }}",
"value2": true
}
]
}
},
"typeVersion": 1
},
{
"id": "549c23ba-0839-4221-9401-fc4b63011211",
"name": "非3D视图元素输出",
"type": "n8n-nodes-base.set",
"position": [
1360,
912
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "message",
"name": "message",
"type": "string",
"value": "Elements not visible in standard 3D view"
},
{
"id": "filtered_count",
"name": "filtered_count",
"type": "number",
"value": "={{ $input.all().length }}"
},
{
"id": "reason",
"name": "reason",
"type": "string",
"value": "Parameter 'On the standard 3D View' is not True"
}
]
}
},
"typeVersion": 3.4
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "df99202c-1ae9-46a0-9d9f-1b46aa6273ea",
"connections": {
"Parse Excel1": {
"main": [
[
{
"node": "Extract Headers and Data",
"type": "main",
"index": 0
}
]
]
},
"Set Parameters1": {
"main": [
[
{
"node": "Read Excel File1",
"type": "main",
"index": 0
}
]
]
},
"Read Excel File1": {
"main": [
[
{
"node": "Parse Excel1",
"type": "main",
"index": 0
}
]
]
},
"AI Agent Enhanced": {
"main": [
[
{
"node": "Parse Enhanced Response",
"type": "main",
"index": 0
}
]
]
},
"Convert to Binary": {
"main": [
[
{
"node": "Prepare HTML Path",
"type": "main",
"index": 0
}
]
]
},
"Create Excel File": {
"main": [
[
{
"node": "Enhance Excel Output",
"type": "main",
"index": 0
}
]
]
},
"Prepare HTML Path": {
"main": [
[
{
"node": "Write HTML to Project Folder",
"type": "main",
"index": 0
}
]
]
},
"Accumulate Results": {
"main": [
[
{
"node": "Check If All Batches Done",
"type": "main",
"index": 0
}
]
]
},
"If - File exists?1": {
"main": [
[
{
"node": "Info - Skip conversion1",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract - Run converter1",
"type": "main",
"index": 0
}
]
]
},
"Prepare Excel Data": {
"main": [
[
{
"node": "Create Excel File",
"type": "main",
"index": 0
}
]
]
},
"Clean Empty Values1": {
"main": [
[
{
"node": "Prepare Enhanced Prompts",
"type": "main",
"index": 0
}
]
]
},
"Collect All Results": {
"main": [
[
{
"node": "Calculate Project Totals1",
"type": "main",
"index": 0
}
]
]
},
"Prepare Excel Path1": {
"main": [
[
{
"node": "Write Excel to Project Folder1",
"type": "main",
"index": 0
}
]
]
},
"Process in Batches1": {
"main": [
[
{
"node": "Clean Empty Values1",
"type": "main",
"index": 0
}
]
]
},
"Enhance Excel Output": {
"main": [
[
{
"node": "Prepare Excel Path1",
"type": "main",
"index": 0
}
]
]
},
"Generate HTML Report": {
"main": [
[
{
"node": "Convert to Binary",
"type": "main",
"index": 0
}
]
]
},
"Is Building Element1": {
"main": [
[
{
"node": "Process in Batches1",
"type": "main",
"index": 0
}
],
[
{
"node": "Non-Building Elements Output1",
"type": "main",
"index": 0
}
]
]
},
"Process AI Response1": {
"main": [
[
{
"node": "Group Data with AI Rules1",
"type": "main",
"index": 0
}
]
]
},
"Anthropic Chat Model1": {
"ai_languageModel": [
[
{
"node": "AI Agent Enhanced",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Find Category Fields1": {
"main": [
[
{
"node": "AI Classify Categories1",
"type": "main",
"index": 0
}
]
]
},
"AI Analyze All Headers": {
"main": [
[
{
"node": "Process AI Response1",
"type": "main",
"index": 0
}
]
]
},
"AI Classify Categories1": {
"main": [
[
{
"node": "Apply Classification to Groups1",
"type": "main",
"index": 0
}
]
]
},
"Info - Skip conversion1": {
"main": [
[
{
"node": "Merge - Continue workflow1",
"type": "main",
"index": 0
}
]
]
},
"On the standard 3D View": {
"main": [
[
{
"node": "Find Category Fields1",
"type": "main",
"index": 0
}
],
[
{
"node": "Non-3D View Elements Output",
"type": "main",
"index": 0
}
]
]
},
"Parse Enhanced Response": {
"main": [
[
{
"node": "Accumulate Results",
"type": "main",
"index": 0
}
]
]
},
"Create - Excel filename1": {
"main": [
[
{
"node": "Check - Does Excel file exist?1",
"type": "main",
"index": 0
}
]
]
},
"Extract - Run converter1": {
"main": [
[
{
"node": "Check - Did extraction succeed?1",
"type": "main",
"index": 0
}
]
]
},
"Extract Headers and Data": {
"main": [
[
{
"node": "AI Analyze All Headers",
"type": "main",
"index": 0
}
]
]
},
"Prepare Enhanced Prompts": {
"main": [
[
{
"node": "AI Agent Enhanced",
"type": "main",
"index": 0
}
]
]
},
"Calculate Project Totals1": {
"main": [
[
{
"node": "Prepare Excel Data",
"type": "main",
"index": 0
},
{
"node": "Generate HTML Report",
"type": "main",
"index": 0
}
]
]
},
"Check If All Batches Done": {
"main": [
[
{
"node": "Collect All Results",
"type": "main",
"index": 0
}
],
[
{
"node": "Process in Batches1",
"type": "main",
"index": 0
}
]
]
},
"Group Data with AI Rules1": {
"main": [
[
{
"node": "On the standard 3D View",
"type": "main",
"index": 0
}
]
]
},
"Setup - Define file paths": {
"main": [
[
{
"node": "Create - Excel filename1",
"type": "main",
"index": 0
}
]
]
},
"Merge - Continue workflow1": {
"main": [
[
{
"node": "Set Parameters1",
"type": "main",
"index": 0
}
]
]
},
"Write HTML to Project Folder": {
"main": [
[
{
"node": "Open HTML in Browser",
"type": "main",
"index": 0
}
]
]
},
"Error - Show what went wrong1": {
"main": [
[
{
"node": "Merge - Continue workflow1",
"type": "main",
"index": 1
}
]
]
},
"Apply Classification to Groups1": {
"main": [
[
{
"node": "Is Building Element1",
"type": "main",
"index": 0
}
]
]
},
"Check - Does Excel file exist?1": {
"main": [
[
{
"node": "If - File exists?1",
"type": "main",
"index": 0
}
]
]
},
"Check - Did extraction succeed?1": {
"main": [
[
{
"node": "Error - Show what went wrong1",
"type": "main",
"index": 0
}
],
[
{
"node": "Set xlsx_filename after success1",
"type": "main",
"index": 0
}
]
]
},
"Set xlsx_filename after success1": {
"main": [
[
{
"node": "Merge - Continue workflow1",
"type": "main",
"index": 1
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Setup - Define file paths",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - AI 摘要总结, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
n8n_7_Revit和IFC碳足迹CO2估算器
使用AI分类计算Revit/IFC模型的隐含碳（CO2）
If
Set
Code
+13
55 节点Artem Boiko
AI 摘要总结
n8n_3_CAD-BIM-批量转换器-管道
批量转换 CAD/BIM 文件为 XLSX/DAE，带验证和报告
If
Set
Code
+14
82 节点Artem Boiko
文档提取
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
If
Set
Code
+26
116 节点Paul
内容创作
我的工作流11
根据Excel标准验证CAD-BIM文件（Revit/IFC/DWG/DGN）
If
Set
Code
+6
26 节点Artem
工程
YNAB自动预算
使用GPT-5-Mini自动分类YNAB交易并发送Discord通知
If
Set
Merge
+11
29 节点spencer owen
AI 摘要总结
工作流信息
难度等级
高级
节点数量55
分类2
节点类型16
作者
Artem Boiko
@datadrivenconstructionFounder DataDrivenConstruction.io | AEC Tech Consultant & Automation Expert | Bridging Software and Construction
外部链接
在 n8n.io 查看 →
分享此工作流