Questions tagged [modeling]
The modeling tag has no usage guidance.
20
questions
0
votes
1
answer
289
views
Running several sets of assumptions through a model in Excel
Hello and thank you in advance for your help! This question is for excel.
I have created a dynamic model which outputs estimated annual interest revenue, and it depends on 5 inputs (average term ...
0
votes
1
answer
21
views
Index and match give an error
I want my Excel sheet to work as a model. And I want to find the value which is on the 'crossing point' of G37 and G38, which are respectively 12 and 6.
The following function worked out for several ...
0
votes
1
answer
60
views
Select minimum value but higher than certain value
I want to select the minimum value in a table with 147 values, which is easy with the MIN-function in Excel. Now i want to select the minimum value which is bigger than 100%.
I tried MINIFS, but it ...
1
vote
3
answers
1k
views
Compiling NOAA WAVEWATCH III got error in Ubuntu
I'm trying to compile the NOAA WW3 model and every time I try to execute w3_make file, I get this message:
*****************************
*** WAVEWATCH III make ***...
0
votes
1
answer
91
views
How to implement many-to-many relationship between a dimension and the fact table in Iccube?
I need help to implement the following example in icCube: A patient can have many dental procedures (the same example applies to diagnostics). The key here is that it must be a many-to-many ...
1
vote
1
answer
90
views
Power BI: advanced query relationships
I need to do left joins in my data model in Power BI. I import my model from SQL Server where I have one big fact table with multiple relationships to dimension tables. Power BI only allows me to do ...
0
votes
0
answers
417
views
Dialect class not found: org.hibernate.dialect.ExtendedSQLServerDialect
I'm using a BI suite called Knowage (I hope there are some users here). When i try to build a Meta-Model i get the following error:
Error while initializing Qbe interface
java.lang.RuntimeException: ...
1
vote
2
answers
598
views
Excel Forecast model for subscriptions received in advance for next 2 years
I am working on a financial model that contains:
Months in columns (Jan-2020 to Dec-2025)
Number of subscribers per month (column) per package in rows
Price of each package in rows
Doing cash flow ...
1
vote
1
answer
3k
views
Automating converstion of files from .MQO to .OBJ
I have a full folder of .MQO 3D model files that I converted from .DAT 3D model files These files can be imported with the program "Metasequoia 4".
I want to import the .MQO file and then export it ...
0
votes
2
answers
832
views
Automated Visio Database Model Diagrams
Is it possible to automatically create a Visio database model diagram from a edge list or some sort of source/target file? I am looking to automatically create some sort of data flow diagram in Visio ...
1
vote
1
answer
4k
views
How do I flip a lens from a catalog in Zemax?
I am pretty new to this ray tracing software. It is simple to add custom surfaces and insert lenses from a catalog, but I can't figure out how to flip left-right a component without having to modify ...
4
votes
2
answers
7k
views
Installing Network Simulator (NS-2, allinone) on Linux Mandriva
I downloaded the Network Simulator NS-2 from here -
http://www.isi.edu/nsnam/ns/ns-build.html#allinone
Build ns via GCC 4.2.2 -
tar-xzf ns-allinone-2.35.tar.gz
cd ns-allinone-2.35
./install
Get ...
0
votes
0
answers
319
views
Excel/OpenOffice spreadsheet template for expected and actual values
I would like to create a spreadsheet to generate graphs about cost items (anything with a cost, doesn't matter what) in order to have:
expected values: these would be created using some formulas to ...
1
vote
1
answer
142
views
3ds Max Rendering
Hey I render 36 frames from different angles to PNG files on 3Ds Max 2013 but now I want to hide a model and make it so all the parts its blocking to also become transparent.
If you don't understand ...
0
votes
1
answer
166
views
Network modeling software [closed]
What software is good for modeling network architecture?
Essentially, I want to do this:
With what software could this be achieved? I need a free or open source solution. I don't need to do a ...
3
votes
4
answers
63k
views
What's a simple way to do sensitivity analysis in Excel?
I have an Excel model of medium complexity that I'm trying to do some sensitivity analysis on. The ideal would be to have, for each of a set of inputs, run over a range of possible values and store ...
2
votes
2
answers
2k
views
Add a bitmap to the ground of a Google SketchUp model?
Is it possible to add a bitmap to the floor ground of a Google SketchUp model?
0
votes
2
answers
530
views
Collaborative data modelling software?
I'm trying to find a tool where a lot of people can work on a data model collaboratively. Embarcadero has a an ER application called ER/studio which apparently comes with a repository system that ...
0
votes
3
answers
2k
views
Any examples of a complex, changeable system modelled with a spreadsheet?
When I asked this question using games as the example (hoping it would be more likely to have been done), it was closed as being off topic so let me ask it this way...
Has anyone used a spreadsheet ...
1
vote
1
answer
148
views
How can I perform business/programming/mindmap 'modeling' in 3d?
Are there any possibilities of modeling in a 3d environment? Not in a Maya or 3d studio MAX way (which I do not have any experience with), but in a UML diagram software kind of way..?