Generative Urban Design Spreadsheet Integration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current urban design processes are fragmented and labor-intensive, requiring separate analyses by different experts using different software, making it difficult to coordinate competing elements and integrate data from generative design systems with spreadsheet models, especially when generating multiple scenarios.
Innovation Solution
A method and system that integrates models with generative design systems by receiving design constraints and inputs, generating design options with geometric data, and automatically creating a global spreadsheet that connects geometric data to user-created models, converting values, and transmitting outputs back to the generative design system.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If separate analyses are run by different experts using different software, then each expert can specialize in their domain, but the coordination and integration of competing elements becomes time-consuming and costly
Solution Approach 1:
The patent combines multiple separate analysis tools and expert workflows into a single integrated generative design system. Different experts' specialized analyses (architectural, engineering, economic) are merged into one unified platform that can process and coordinate all elements simultaneously, eliminating the need for separate software and reducing coordination time.
Solution Approach 2:
The generative design system performs multiple functions within a single platform: it handles geometric design, economic modeling, sunlight analysis, street grid planning, and other specialized analyses that previously required separate tools. This multi-functional approach allows different experts to work within a universal system rather than switching between specialized software.
2Loss of information
If models are integrated through re-implementation or API access, then data can be shared between systems, but the process becomes labor intensive
Solution Approach 1:
Instead of integrating models through separate systems via APIs or re-implementation, the patent merges all models directly into the generative design system. Economic models, sunlight models, and other specialized models are combined within the same platform, allowing automatic data sharing without manual intervention or complex integration processes.
Solution Approach 2:
The system uses an automated intermediary mechanism (the generative design platform) that handles data translation and coordination between different model types. Rather than requiring experts to manually connect models through APIs, the system automatically mediates data flow between geometric data, economic models, and other analyses.
3Productivity
If multiple scenarios are generated using machine learning, then comprehensive planning options can be evaluated, but the complexity of managing spreadsheet models with multiple scenarios increases
Solution Approach 1:
The patent combines spreadsheet modeling capabilities directly within the generative design system, allowing multiple scenarios to be managed in a unified environment. Instead of using separate spreadsheet files that require manual coordination, the system merges scenario management with the generative design process, automatically handling the complexity of multiple scenarios across different model types.
Data Source
AI summary
Methods, systems, and media for generative urban design with spreadsheet and model integration features are provided. In some embodiments, the method comprises: receiving one or more design constraints and one or more inputs for generating one or more proposed district designs; generating a plurality of design options that meet the one or more design constraints and the one or more inputs using a generative design system, wherein each of the plurality of design options include geometric data for a district design; automatically generating a global spreadsheet having a plurality of sheets that connects the geometric data from each of the plurality of design options to a plurality of received user-created models, wherein first sheets of the plurality of sheets are generated to include each of the plurality of user-created models, wherein second sheets of the plurality of sheets are generated to include the geometric data for each of the plurality of design options, wherein third sheets of the plurality of sheets are configured to convert values from the geometric data in the second sheets to values required by each of plurality of user-created models; receiving outputs from each of the plurality of user-generated models using the converted values in the third sheets of the global spreadsheet; and transmitting the outputs from each of the plurality of user-generated models to the generative design system.