Search found 10 matches

by DjZU
Tuesday 10 July, 2012 - 14:20
Forum: Enterprise Dynamics 4DScript
Topic: Bernoulli distribution of 5 products
Replies: 3
Views: 7536

Re: Bernoulli distribution of 5 products

Hello! Indeed, I suspected the calculation of the percentages bps1, bp2 to be wrong but was wondering what would be right: you've got it marlies! Now my function works perfectly like I expected. However, I will finally use the Empirical Distribution atom as recommended. I did'nt know this atom that ...
by DjZU
Monday 09 July, 2012 - 15:52
Forum: Enterprise Dynamics 4DScript
Topic: Bernoulli distribution of 5 products
Replies: 3
Views: 7536

Bernoulli distribution of 5 products

Hello! I need the Source atom to generate 5 types of products identified by a label. To do this, and starting from post http://community.incontrolsim.com/4d-skript-for-my-warehouse-t140.html I have made the following function: RegisterFunction( [Bernoulli5], [Various], 5, 5, [ Do( var([pSum], vbValu...
by DjZU
Friday 29 June, 2012 - 10:34
Forum: Enterprise Dynamics 4DScript
Topic: Control ED through VBA
Replies: 1
Views: 2211

Re: Control ED through VBA

Hello ED Community! I finally get by with a slight change in the call of ED by VBA: unused = ShellExecute(0, vbNullString, ThisWorkbook.Path & "\Simulation.mod", vbNullString, ThisWorkbook.Path & "\", vbNormalFocus) I provided the directory parameter and change "/&qu...
by DjZU
Wednesday 27 June, 2012 - 10:32
Forum: Enterprise Dynamics 4DScript
Topic: Control ED through VBA
Replies: 1
Views: 2211

Control ED through VBA

Hello ! As the title said, I would like to run and control Enterprise Dynamics through Excel with VBA code. I'm used to work with the following function to open files with the associated program, declared like this: Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellEx...
by DjZU
Thursday 07 June, 2012 - 09:10
Forum: Enterprise Dynamics 4DScript
Topic: Rotating camera
Replies: 4
Views: 3945

Re: Rotating camera

Hello HarryBunnik,

Thank you again, that's exactly what I was looking for: the function Now. I achieved to do what I need.

Cheers!

DjZU
by DjZU
Monday 04 June, 2012 - 16:18
Forum: Enterprise Dynamics 4DScript
Topic: Rotating camera
Replies: 4
Views: 3945

Re: Rotating camera

Hello HarryBunnik, Thank you very much for your help and explanation, the camera is now moving like I expected it to do. I would have other request: how to do to have a fixed speed of rotation of the camera? You suggest to update the position of the camera with this code, where Time depends on the s...
by DjZU
Wednesday 23 May, 2012 - 14:09
Forum: Enterprise Dynamics 4DScript
Topic: Rotating camera
Replies: 4
Views: 3945

Rotating camera

Hello, I would like to visualize the entire model in 3D with a defined camera that would rotate around a center point. I mean the targeted point would remain the same while the camera (the point of view) would rotate around the same targeted point. I tried to achieve this goal without success in two...
by DjZU
Friday 13 April, 2012 - 14:08
Forum: Enterprise Dynamics 4DScript
Topic: Read Excel values with OLE ActiveX
Replies: 4
Views: 5121

Re: Read Excel values with OLE ActiveX

It works perfectly for boths values and strings using .Value and the according variable type (vbString or vbValue).
Thank you again for responding quickly.
by DjZU
Friday 13 April, 2012 - 11:40
Forum: Enterprise Dynamics 4DScript
Topic: Read Excel values with OLE ActiveX
Replies: 4
Views: 5121

Re: Read Excel values with OLE ActiveX

I get by with a little help from Marlies! I expected that the Ole function would return the value in parameter e3 or e4. I finally created a function to read the value of a cell which coordonates are given in parameters and I call this function and keep its result in a variable. If it can helps some...
by DjZU
Friday 13 April, 2012 - 10:39
Forum: Enterprise Dynamics 4DScript
Topic: Read Excel values with OLE ActiveX
Replies: 4
Views: 5121

Read Excel values with OLE ActiveX

Hello, I develop models which read and write datas from and to Excel. I first have done it using the DDE functions ExcelRead and ExcelWrite and recently had experimented some stability problems while writing datas. So I decided to prefer the OLE method. I have already changed the scripts of writing ...