Visio Guy

Hi I am wondering if it is possible to make a resistance diagram in Visio report/display the equivalent resistance of a circuit. Ideally this would work where the resistances can change and the resistors can be placed in parallel or in series and then the appropriate math would be done to determine an equivalent resistance.

This is cross-post or not ?

Quote from: Surrogate on August 09, 2017, 03:58:03 PM
This is cross-post or not ?

Yes, but Yacine did point the OP here for a Visio related response, so fair enough.

Right, I thought we can help Vincent better here, than in S.O. because of the high restrictions there.

Vincent, I'll have a look at your problem these days.

Thank you very much.

I'm sure this forum is a heap better than Stack Overflow for Visio stuff.

So the generic resistance network calculation was too difficult. But I found a page for reliability calculations:
http://reliawiki.org/index.php/RBDs_and_Analytical_System_Reliability

Series: Product of reliabilities
Parallel: 1- product( (1-Ri) )

The next thing was to write the dependencies of the shapes when they get connected.

I used the "connectIT" macro, that I found a long time ago in June's work.

The solution I implemented for you is still buggy, but I trust, that you can go the remaining way by yourself.

Regards,
Yacine.

Yeah I can definitely play around with this new information. It appears that the model needs to assume that the initial (far left) reliability is 1 and then is adjusted from there. It also appears that the end (far right) should be the Reliability of the entire system.

Thanks a million this should get me somewhere at least.

   "heap better than Stack"??  I thought it was the other way around!  But I won't push it, Pop.

I am trying to do exactly what you did instead of copying and pasting to improve my knowledge on Visio.

Currently I can use Visio 2003 because that is what my company owns. If I can come up with a good argument I may be able to get an upgrade.

Within Visio 2003 I can see that the connectors and the shapes have custom properties. I however cannot figure out how to edit a blank connector. I can get to the Define Custom Properties page but I cannot put in a value. Looking at your example, the Value for the connectors is "User.EndValue" however, when I try this I receive an error that says "Field validation error: Entry must be a number."

Also I would like to know if there is an easy way of inputting a specific connector/input into the value. For example you have

"1-(1-Sheet.38!Prop.ReliabilityOutput)*(1-Sheet.44!Prop.ReliabilityOutput)*(1-Sheet.45!Prop.ReliabilityOutput)"

and I am wondering if I have to type out "Sheet.38!Prop.ReliabilityOutput" or is there a shorcut way of getting this information.

I am super new to Visio but I am more than capable of learning the software quickly so please be a little more detailed but not to the point where you spend hours trying to tell me something small.

Thanks again.