n8n_6_Usar LLM para estimar costos de construcción en Revit y IFC
Avanzado
Este es unAI Summarization, Multimodal AIflujo de automatización del dominio deautomatización que contiene 55 nodos.Utiliza principalmente nodos como If, Set, Code, Merge, ManualTrigger. usoGPT-4yClaude基于Revit/IFC模型估算施工成本
Requisitos previos
- •Clave de API de OpenAI
- •Clave de API de Anthropic
Nodos utilizados (55)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"id": "Z1UKztds8E5oQSMe",
"meta": {
"instanceId": "faa70e11b7175129a74fd834d3451fdc1862589b16d68ded03f91ca7b1ecca12",
"templateCredsSetupCompleted": true
},
"name": "n8n_6_Construction_Price_Estimation_with_LLM_for_Revt_and_IFC",
"tags": [],
"nodes": [
{
"id": "44ac22bc-92ff-450d-ac53-b2b587cc0318",
"name": "Al hacer clic en 'Ejecutar flujo de trabajo'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
944,
-64
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2b81e046-ebc1-4687-8fd2-b9d2a3347a12",
"name": "Encontrar Campos de Categoría1",
"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": "Aplicar Clasificación a Grupos1",
"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": "Salida de Elementos No Edificatorios1",
"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": "Clasificar Categorías con IA1",
"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": "¿Es Elemento de Edificación?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": "Verificar Si Todos los Lotes Están Completos",
"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": "Recopilar Todos los Resultados",
"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": "Procesar en Lotes1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1184,
1152
],
"parameters": {
"options": {},
"batchSize": 1
},
"typeVersion": 1
},
{
"id": "b1504e4e-6a04-4014-aeed-b38dbaa9b12d",
"name": "Limpiar Valores Vacíos1",
"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": "Agente de IA Mejorado",
"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": "Acumular Resultados",
"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 Modelo de Chat1",
"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": "Calcular Totales del Proyecto1",
"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": "Mejorar Salida de 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": "Preparar Datos para 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": "Crear Archivo 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": "Preparar Indicaciones Mejoradas",
"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": "Analizar Respuesta Mejorada",
"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": "Generar Informe 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": "Convertir a Binario",
"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": "Nota Adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
432
],
"parameters": {
"width": 340,
"height": 116,
"content": "⭐ **If you find our tools helpful**, please consider **starring our repository** on [GitHub](https://github.com/datadrivenconstruction/cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto). \n\nYour support helps us improve and continue developing open solutions for the community!\n"
},
"typeVersion": 1
},
{
"id": "478155e4-eb87-4684-9546-871dfb3577f0",
"name": "Agrupar Datos con Reglas de IA1",
"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": "Extraer Encabezados y Datos",
"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": "Analizar Todos los Encabezados con IA",
"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": "Leer Archivo Excel1",
"type": "n8n-nodes-base.readBinaryFile",
"position": [
1216,
544
],
"parameters": {
"filePath": "={{ $json.path_to_file }}"
},
"typeVersion": 1
},
{
"id": "b265c8fd-6d6b-49a1-802f-e25598569273",
"name": "Analizar 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": "Crear - Nombre de archivo Excel1",
"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": "Verificar - ¿Existe el archivo 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": "Si - ¿Archivo existe?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": "Extraer - Ejecutar convertidor1",
"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": "Información - Omitir conversión1",
"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": "Verificar - ¿Extracción exitosa?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": "Error - Mostrar qué falló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": "Establecer xlsx_filename tras éxito1",
"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": "Fusionar - Continuar flujo de trabajo1",
"type": "n8n-nodes-base.merge",
"position": [
2128,
-16
],
"parameters": {},
"typeVersion": 3
},
{
"id": "642d6337-d6a4-4079-ba9d-f42b7c69286f",
"name": "Establecer Parámetros1",
"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": "Procesar Respuesta de IA1",
"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": "Bloque de Análisis de Precios e Informes1",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1504
],
"parameters": {
"color": 5,
"width": 1920,
"height": 448,
"content": "## Block 4: Price Calculation & Reporting\nThis block:\n- Estimates costs using material types, volumes/areas, and online price searches\n- Creates charts: pie for material distribution, bar for top costs\n- Calculates summary stats like total cost and elements\n- Generates a professional HTML report with visuals\n- Exports detailed data to Excel with multiple sheets (Summary, Details, etc.)\n\nKey nodes:\n- Calculate Project Totals1: Aggregates costs and stats\n- Generate HTML Report: Creates visual report\n- Create Excel File: Builds multi-sheet Excel export"
},
"typeVersion": 1
},
{
"id": "77e86578-5835-4b05-9ed0-0cf4789f9e73",
"name": "Bloque de Clasificación de Elementos",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
752
],
"parameters": {
"color": 6,
"width": 1920,
"height": 320,
"content": "## Block 2: Element Classification\nThis block:\n- Detects category fields (e.g., Category, IFC Type)\n- Uses AI to classify as building elements (e.g., walls, doors) \nor non-building (e.g., annotations, texts)\n- Splits data: building elements go to analysis, \nnon-building are noted separately\n\nKey nodes:\n- Find Category Fields1: Identifies categories\n- AI Classify Categories1: AI classification\n- Is Building Element1: Splits the flow"
},
"typeVersion": 1
},
{
"id": "a96c6ebe-b70a-444e-bbff-10db7b42be76",
"name": "Bloque de Análisis de Materiales",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1088
],
"parameters": {
"color": 6,
"width": 1920,
"height": 400,
"content": "## Block 3: Material Analysis\nThis block:\n- Processes building elements in batches\n- Classifies materials by EU/DE/US standards\n- Determines units (m³, m², etc.) and densities\n- Uses AI (Anthropic) for detailed analysis and price estimation\n- Accumulates results and calculates distributions\n\nKey nodes:\n- Process in Batches1: Handles data in chunks\n- AI Agent Enhanced: AI analysis with tools\n- Accumulate Results: Collects all data"
},
"typeVersion": 1
},
{
"id": "20b27e18-a7bd-491d-9972-6a096633b6ed",
"name": "Bloque de Conversión",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
-272
],
"parameters": {
"color": 5,
"width": 1912,
"height": 708,
"content": "## Conversion Block\nThis block:\n- Checks if Excel file exists from Revit project\n- If not, runs converter to extract data\n- If yes, skips to save time\n\nSimply: Converts Revit file to Excel for analysis.\n\nKey nodes:\n- Check - Does Excel file exist?1: Verifies file\n- Extract - Run converter1: Converts if needed"
},
"typeVersion": 1
},
{
"id": "3bd50143-1a76-4ae4-8e4a-904375a45201",
"name": "Bloque de Carga de Datos1",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
464
],
"parameters": {
"color": 6,
"width": 1920,
"height": 272,
"content": "## Block 1: Data Loading & Grouping\nThis block:\n- Loads Excel data\n- Cleans headers\n- Uses AI to decide aggregation (sum for quantities, mean for rates, first for texts)\n- Groups data by parameter (e.g., Type Name)\nSimply: Prepares raw data for classification."
},
"typeVersion": 1
},
{
"id": "95340b29-d6b6-4aa4-b850-4166f1ff186e",
"name": "Notas Importantes",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
128
],
"parameters": {
"width": 336,
"height": 288,
"content": "## ⚠️ Important Information\n\n- Pipeline uses AI (OpenAI, Grok, Anthropic) - check credits and limits.\n- Revit converter requires downloaded DDC_Converter_Revit\n- Data is aggregated by groups, volumes are already summed - do not multiply by element count\n- Reports are generated in HTML and in Excel wfor detailed analysis"
},
"typeVersion": 1
},
{
"id": "9887f607-85f0-41d5-92d8-9c6e655f6581",
"name": "Preparar Ruta 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": "Escribir HTML en Carpeta del Proyecto",
"type": "n8n-nodes-base.writeBinaryFile",
"position": [
2112,
1568
],
"parameters": {
"options": {},
"fileName": "={{ $json.full_path }}"
},
"typeVersion": 1
},
{
"id": "c4d015d4-b040-4aa7-a4c5-cc22d3ab7eb4",
"name": "Abrir HTML en Navegador",
"type": "n8n-nodes-base.executeCommand",
"position": [
2288,
1568
],
"parameters": {
"command": "=start \"\" \"{{ $json.full_path }}\""
},
"typeVersion": 1
},
{
"id": "01bcb7a4-534b-46ee-9462-b8f1aaf813e8",
"name": "Preparar Ruta Excel1",
"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": "Escribir Excel en Carpeta del Proyecto1",
"type": "n8n-nodes-base.writeBinaryFile",
"position": [
2288,
1744
],
"parameters": {
"options": {},
"fileName": "={{ $json.full_path }}"
},
"typeVersion": 1
},
{
"id": "297ac011-ea69-4975-b9e5-e14a1b6730b9",
"name": "Configuración - Definir rutas de archivo",
"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": "Bloque de Conversión1",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
-400
],
"parameters": {
"color": 5,
"width": 952,
"height": 112,
"content": "# Project Cost Calculation for Revit and IFC with AI (LLM) \nDataDrivenConstruction [GitHub](https://github.com/datadrivenconstruction/cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto)"
},
"typeVersion": 1
},
{
"id": "0af0bac5-4f11-4a99-bc74-0d99827754cb",
"name": "Instrucciones de Configuración",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-272
],
"parameters": {
"width": 336,
"height": 384,
"content": "## 📝 Setup Instructions\n\n1. In the 'Setup - Define file paths' node, specify:\n - Path to converter (RvtExporter.exe)\n - Path to project file (.rvt)\n - Grouping parameter (group_by, e.g. 'Type Name', 'IfcType' for IFC or other)\n - Country (country for which the values will be calculated, e.g. 'Germany'or 'Brazil')\n\n2. Ensure API keys for OpenAI and Anthropic are set in credentials or just connect other models that you use in your work (of course, these can be open source LLMs)"
},
"typeVersion": 1
},
{
"id": "b2243495-e0c0-4bd7-8118-701d33d20c6f",
"name": "OpenAI Modelo de Chat",
"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": "Modelo de Chat 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": "Nota Adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1104,
-240
],
"parameters": {
"color": 4,
"width": 224,
"height": 368,
"content": "## ⬇️ Only modify the variables here \n— everything else works automatically"
},
"typeVersion": 1
},
{
"id": "9d8c252c-4dd6-434e-a3c6-18f7a0b1d2e5",
"name": "En la Vista 3D Estándar",
"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": "Salida de Elementos de Vista No-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": {
"b265c8fd-6d6b-49a1-802f-e25598569273": {
"main": [
[
{
"node": "45d8e0e5-591b-4469-9766-501806e5f7a1",
"type": "main",
"index": 0
}
]
]
},
"642d6337-d6a4-4079-ba9d-f42b7c69286f": {
"main": [
[
{
"node": "03b8267f-6ff1-4793-8a03-1c8ba934dbe9",
"type": "main",
"index": 0
}
]
]
},
"03b8267f-6ff1-4793-8a03-1c8ba934dbe9": {
"main": [
[
{
"node": "b265c8fd-6d6b-49a1-802f-e25598569273",
"type": "main",
"index": 0
}
]
]
},
"d152a0a9-71c9-4532-9743-15225429bcc8": {
"main": [
[
{
"node": "f5d3ae3d-68fe-43e3-a6df-4bed5a82aefa",
"type": "main",
"index": 0
}
]
]
},
"e99d0ff0-79ea-4ed1-9878-a23986efe41b": {
"main": [
[
{
"node": "9887f607-85f0-41d5-92d8-9c6e655f6581",
"type": "main",
"index": 0
}
]
]
},
"b55dc4f5-1309-4a06-9924-d796733a21f5": {
"main": [
[
{
"node": "4d061758-4051-4bcc-85db-d7ed7fa06ec7",
"type": "main",
"index": 0
}
]
]
},
"9887f607-85f0-41d5-92d8-9c6e655f6581": {
"main": [
[
{
"node": "24be1fea-bdcb-491b-afb8-170431f8f198",
"type": "main",
"index": 0
}
]
]
},
"72e3dd39-013c-43b4-a0e1-9ce4167d37f0": {
"main": [
[
{
"node": "a6b94ddd-8674-4072-8bb0-f2a813b4c042",
"type": "main",
"index": 0
}
]
]
},
"93cc0ed5-4eac-4907-8638-65010834605a": {
"main": [
[
{
"node": "8b6b3e88-90b9-4dbc-81fd-9aa8378f8981",
"type": "main",
"index": 0
}
],
[
{
"node": "85ead84d-193e-46c0-9d9f-9ccc07f2518b",
"type": "main",
"index": 0
}
]
]
},
"d006c84f-3df6-493e-8965-2552f06cc862": {
"main": [
[
{
"node": "b55dc4f5-1309-4a06-9924-d796733a21f5",
"type": "main",
"index": 0
}
]
]
},
"b1504e4e-6a04-4014-aeed-b38dbaa9b12d": {
"main": [
[
{
"node": "750047a0-76ea-41a6-8e6e-83447eaef026",
"type": "main",
"index": 0
}
]
]
},
"6a62ad33-7c47-495d-b81b-3be78ae0cd81": {
"main": [
[
{
"node": "dfb09d43-49c8-47be-af77-e3bef30a5053",
"type": "main",
"index": 0
}
]
]
},
"01bcb7a4-534b-46ee-9462-b8f1aaf813e8": {
"main": [
[
{
"node": "694efc44-ce97-44d1-a34d-84fce917a0e9",
"type": "main",
"index": 0
}
]
]
},
"e3ab164d-d34c-4415-9ecc-d1e2dcd35ebe": {
"main": [
[
{
"node": "b1504e4e-6a04-4014-aeed-b38dbaa9b12d",
"type": "main",
"index": 0
}
]
]
},
"4d061758-4051-4bcc-85db-d7ed7fa06ec7": {
"main": [
[
{
"node": "01bcb7a4-534b-46ee-9462-b8f1aaf813e8",
"type": "main",
"index": 0
}
]
]
},
"428bb655-a1e9-45df-a80c-57c00810e5e9": {
"main": [
[
{
"node": "e99d0ff0-79ea-4ed1-9878-a23986efe41b",
"type": "main",
"index": 0
}
]
]
},
"2adc7c4e-1133-43bd-a3b8-8648a95861be": {
"main": [
[
{
"node": "e3ab164d-d34c-4415-9ecc-d1e2dcd35ebe",
"type": "main",
"index": 0
}
],
[
{
"node": "50462cce-7978-4147-b215-25749d3bbf79",
"type": "main",
"index": 0
}
]
]
},
"52e54e39-139e-4985-a654-fce750204100": {
"main": [
[
{
"node": "478155e4-eb87-4684-9546-871dfb3577f0",
"type": "main",
"index": 0
}
]
]
},
"7f62341e-e758-4664-aa1d-62cdba49cd84": {
"ai_languageModel": [
[
{
"node": "d152a0a9-71c9-4532-9743-15225429bcc8",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"2b81e046-ebc1-4687-8fd2-b9d2a3347a12": {
"main": [
[
{
"node": "93e37bf0-a126-4174-9bc6-a8a5378885a1",
"type": "main",
"index": 0
}
]
]
},
"d501723a-bf02-4e1b-8f24-5811500868f4": {
"main": [
[
{
"node": "52e54e39-139e-4985-a654-fce750204100",
"type": "main",
"index": 0
}
]
]
},
"93e37bf0-a126-4174-9bc6-a8a5378885a1": {
"main": [
[
{
"node": "65f07357-2e47-41ac-87ee-43d692b7511d",
"type": "main",
"index": 0
}
]
]
},
"8b6b3e88-90b9-4dbc-81fd-9aa8378f8981": {
"main": [
[
{
"node": "c60ea846-191c-43d1-a883-131524e2f152",
"type": "main",
"index": 0
}
]
]
},
"9d8c252c-4dd6-434e-a3c6-18f7a0b1d2e5": {
"main": [
[
{
"node": "2b81e046-ebc1-4687-8fd2-b9d2a3347a12",
"type": "main",
"index": 0
}
],
[
{
"node": "549c23ba-0839-4221-9401-fc4b63011211",
"type": "main",
"index": 0
}
]
]
},
"f5d3ae3d-68fe-43e3-a6df-4bed5a82aefa": {
"main": [
[
{
"node": "72e3dd39-013c-43b4-a0e1-9ce4167d37f0",
"type": "main",
"index": 0
}
]
]
},
"4430c041-3a5d-4235-b092-fcd6c7b4a0ba": {
"main": [
[
{
"node": "7ff93cb0-8c5a-4dfb-97d0-3caaa1940bc8",
"type": "main",
"index": 0
}
]
]
},
"85ead84d-193e-46c0-9d9f-9ccc07f2518b": {
"main": [
[
{
"node": "5b2c4e88-5254-4682-a1d2-8f200952fba4",
"type": "main",
"index": 0
}
]
]
},
"45d8e0e5-591b-4469-9766-501806e5f7a1": {
"main": [
[
{
"node": "d501723a-bf02-4e1b-8f24-5811500868f4",
"type": "main",
"index": 0
}
]
]
},
"750047a0-76ea-41a6-8e6e-83447eaef026": {
"main": [
[
{
"node": "d152a0a9-71c9-4532-9743-15225429bcc8",
"type": "main",
"index": 0
}
]
]
},
"dfb09d43-49c8-47be-af77-e3bef30a5053": {
"main": [
[
{
"node": "d006c84f-3df6-493e-8965-2552f06cc862",
"type": "main",
"index": 0
},
{
"node": "428bb655-a1e9-45df-a80c-57c00810e5e9",
"type": "main",
"index": 0
}
]
]
},
"a6b94ddd-8674-4072-8bb0-f2a813b4c042": {
"main": [
[
{
"node": "6a62ad33-7c47-495d-b81b-3be78ae0cd81",
"type": "main",
"index": 0
}
],
[
{
"node": "e3ab164d-d34c-4415-9ecc-d1e2dcd35ebe",
"type": "main",
"index": 0
}
]
]
},
"478155e4-eb87-4684-9546-871dfb3577f0": {
"main": [
[
{
"node": "9d8c252c-4dd6-434e-a3c6-18f7a0b1d2e5",
"type": "main",
"index": 0
}
]
]
},
"297ac011-ea69-4975-b9e5-e14a1b6730b9": {
"main": [
[
{
"node": "4430c041-3a5d-4235-b092-fcd6c7b4a0ba",
"type": "main",
"index": 0
}
]
]
},
"c60ea846-191c-43d1-a883-131524e2f152": {
"main": [
[
{
"node": "642d6337-d6a4-4079-ba9d-f42b7c69286f",
"type": "main",
"index": 0
}
]
]
},
"24be1fea-bdcb-491b-afb8-170431f8f198": {
"main": [
[
{
"node": "c4d015d4-b040-4aa7-a4c5-cc22d3ab7eb4",
"type": "main",
"index": 0
}
]
]
},
"672e73cc-d8a8-4033-8b7a-347ef46ba89a": {
"main": [
[
{
"node": "c60ea846-191c-43d1-a883-131524e2f152",
"type": "main",
"index": 1
}
]
]
},
"65f07357-2e47-41ac-87ee-43d692b7511d": {
"main": [
[
{
"node": "2adc7c4e-1133-43bd-a3b8-8648a95861be",
"type": "main",
"index": 0
}
]
]
},
"7ff93cb0-8c5a-4dfb-97d0-3caaa1940bc8": {
"main": [
[
{
"node": "93cc0ed5-4eac-4907-8638-65010834605a",
"type": "main",
"index": 0
}
]
]
},
"5b2c4e88-5254-4682-a1d2-8f200952fba4": {
"main": [
[
{
"node": "672e73cc-d8a8-4033-8b7a-347ef46ba89a",
"type": "main",
"index": 0
}
],
[
{
"node": "a99bdd3b-76e0-4517-8258-c78f009d0653",
"type": "main",
"index": 0
}
]
]
},
"a99bdd3b-76e0-4517-8258-c78f009d0653": {
"main": [
[
{
"node": "c60ea846-191c-43d1-a883-131524e2f152",
"type": "main",
"index": 1
}
]
]
},
"44ac22bc-92ff-450d-ac53-b2b587cc0318": {
"main": [
[
{
"node": "297ac011-ea69-4975-b9e5-e14a1b6730b9",
"type": "main",
"index": 0
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Resumen de IA, IA Multimodal
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
n8n_7_Revit y IFC estimador de huella de carbono CO2
Cálculo de carbono embutido (CO2) en modelos Revit/IFC con clasificación por IA
If
Set
Code
+
If
Set
Code
55 NodosArtem Boiko
Resumen de IA
n8n_3_CAD-BIM-conversor por lotes-tubería
Conversión por lotes de archivos CAD/BIM a XLSX/DAE, con verificación e informes
If
Set
Code
+
If
Set
Code
82 NodosArtem Boiko
Extracción de documentos
Explorar nodos de n8n en la biblioteca de referencias visuales
Explorar nodos de n8n en la base de referencia visual
If
Ftp
Set
+
If
Ftp
Set
113 NodosI versus AI
Otros
Proceso de ventas B2B completo: generación de leads con Apollo, prospección con Mailgun y gestión de respuestas con AI
完整de B2B ventas流程：Apollo 潜在clientegeneración、Mailgun 外展y AI 回复gestión
If
Set
Code
+
If
Set
Code
116 NodosPaul
Creación de contenido
Presupuesto automático de YNAB
Usar GPT-5-Mini para clasificar transacciones de YNAB y enviar notificaciones de Discord automáticamente
If
Set
Merge
+
If
Set
Merge
29 Nodosspencer owen
Resumen de IA
Envío automático de facturas a los clientes
Automatización de procesamiento de facturas con OCR.Space, GPT-4 y Google Drive a Gmail
If
Set
Code
+
If
Set
Code
29 NodosMichael Taleb
Resumen de IA
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos55
Categoría2
Tipos de nodos16
Descripción de la dificultad
Autor
Artem Boiko
@datadrivenconstructionFounder DataDrivenConstruction.io | AEC Tech Consultant & Automation Expert | Bridging Software and Construction
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo