How to create a database out of 2 channels with data?

[Sander_Novek]

Hello,

I want to create a database in DIAdem wich DIAdem can consult to find a corrosponding value.

I have a excel add-in from solkane wich when tell it what pressure there is, it finds the corresponding tempature.  This is for refrigirant R134a.

I want to use this in DIAdem, so when i got a certain pressure in a channel. DIAdem finds the corresponding tempature.

I already made an excel sheet with al the corresponding tempatures for the pressure range i need. I loaded this in DIAdem.

So now i got two channels with data wich i want to connect to each other. But here it goes wrong.

I've tried to make an calculation wich says when the pressure in channel (x) = pressure in channel (y) then search in the database for the corresponding tempature by pressure in channel (y).

But because i dont have the database working, where DIAdem can find the corresponding value. It doesn't work.

I hope someone can help me.

Thanks

[ThiCop]

Hello Sander,

The explanation you gave kind of confused me.

Do you want to reuse the excel add-in inside DIAdem?

Or do you want to create soemthing similar in DIAdem itself?

When you're talking about using and creating databases, which type of database (Access, sql, ...) are you talking about?

Do you need to access that database from something externally or should everything just happen from inside DIAdem?

Can you share the conversion table you made in excel as well as what you already have made in DIAdem?

Then I can adapt this to more fully suit your needs.

[Sander_Novek]

It doen't matter, as long as it works. I prefer to let every thing happen in Diadem.

The database only exists of a pressure vs tempature table.

I've attached the  acces database i've made. And my Diadem TDM file.  There both in the zip file

The excel file needs the add in to show the corrosponding values.

In DIAdem you will find a channel with a discharge pressure PT20.1 and a suction pressure PT10.1. I would like to let Diadem find the corrosponding tempature in the database by these  pressures.

The pressure values come from a sensor.

In another post on this forum i found that you van use an SQLwizard to insert an acces database. Is this the way to go?

Kind regards,

Sander

[ThiCop]

Hello Sander,

Before actually making an example the following question popped up:

Is this databases with the values going to remain the same forever?

Or might this Pressure vs Temperature table change in the future?

[Sander_Novek]

These values are going to stay the same.

[Brad_Turpin]

Hi Sander,

Is the relationship between Pressure and Temperature a lookup list or an equation?  In the former case, will the lookup list have all possible values in it, or will you need to interpolate?  Can you provide us with either the equation or lookup list?

Regards,

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Sander_Novek]

Hi Brad,

It is a look up list, there is no equation.

I've made the list with an excel add-in from the manufacturer. Actually this add-in does exactly what i want Diadem to do. It finds the corrosponding tempature by a pressure.

I have attached the add-in, but i don't know if this will help you. I couldn't made a zip of the add-in only. Its protected. You can find it in the zipfile under Ref_Cal_7.zip\Installation Refcalc 7.1\Sol_Excel

The file name is Solkane.xlam.

If you can get the add-in to work with Diadem this wil be the best solution. Because it will find the exact values. The refrigerant (chemical) used is R134a.

My point of view was that Diadem will find the closest value. But interpolating is better.

The differences are smal enough. But it is less exact.

Many thanks for all the work so far,

Sander

[Brad_Turpin]

Hi Sander,

It looks like there is a VB6 wrapper for the DLL that this functionality provides.  There might be a way to communicate with that DLL from a DIAdem VBScript, but you may just be stuck using the Addin in Excel.

Brad Turpin

DIAdem Product Support Engineer

National Instruments