tabella variabili solid edge + excel: problem

[Sbabba]

Hello everyone, I am a mechanical engineering student and I have a problem with solid edge, I hope you can help me. I am doing with other people a project of a pressure vessel for an examination, and the 3d design of the model we would like to do it with if. Now, the sizing of the container we did it in excel and the results are clearly derived from some formulas, so we thought to use the solid edge function that allows to bind the quotas of a model to a file of excel. All right, the process is simple, but at the end when it comes to saying "ok, pass me the file" we realized that if it has a limit according to me to say little ridiculous. the formula with which I attach a variable to a cell is "file address, row, column", then for example "@'c:\users\mauro\documents\uni\parte5. ♪

if I had to move the file of if and the .xls file from my pc to that of a professor/companion course, he clearly would not have the folder c:\users\mauro, so if you would go looking for the cell in a place that does not exist! It really seems ridiculous that you can't tell the program that, for example, the excel file is in the same folder as the .par file, so that moving them he can always follow the source file.

Is there a way to solve the problem? It seems to me really absurd that a program arrived at the 21st version presents such a problem.. .

Thank you in advance

 

[cacciatorino]

Is there a way to solve the problem? It seems to me really absurd that a program arrived at the 21st version presents such a problem.. .

Thank you in advance

So, it seems to me that the "relative" paths, as clearly you have noticed, are not implemented, unless be_on_edge knows the trick that makes things work.

to solve the rpoblema you have two ways:
1) Always use the review manager to move files (e.g. from your disk to usb key, and then from the usb key to the pc disk of your studio companion)
2) pass the files via key by copying them with the file manager of windows, but then you have to reopen them with the revision manager and use the function "refine links".

For the future, I invite you to avoid using terms such as a "ridiculous" referring to a product, because they are offensive to those who work to do so. I guess you wouldn't like someone to call your pressure vessel project, would you?


p.s. the proof I made it between two files par, ninth I sell excel. You should see if the rm works equally between rows of if and spreadsheets.
Good job.

 

[Be_on_edge]

Hello everyone, I am a mechanical engineering student and I have a problem with solid edge, I hope you can help me. I am doing with other people a project of a pressure vessel for an examination, and the 3d design of the model we would like to do it with if. Now, the sizing of the container we did it in excel and the results are clearly derived from some formulas, so we thought to use the solid edge function that allows to bind the quotas of a model to a file of excel. All right, the process is simple, but at the end when it comes to saying "ok, pass me the file" we realized that if it has a limit according to me to say little ridiculous. the formula with which I attach a variable to a cell is "file address, row, column", then for example "@'c:\users\mauro\documents\uni\parte5. ♪

if I had to move the file of if and the .xls file from my pc to that of a professor/companion course, he clearly would not have the folder c:\users\mauro, so if you would go looking for the cell in a place that does not exist! It really seems ridiculous that you can't tell the program that, for example, the excel file is in the same folder as the .par file, so that moving them he can always follow the source file.

Is there a way to solve the problem? It seems to me really absurd that a program arrived at the 21st version presents such a problem.. .

Thank you in advance

uses revision managers and live happy.

Plus if the excel file is in the same folder as the connected file you can move the whole folder without problems.

you can also use the linkmngt file to define additional paths in which to search for linked files.

as you see there are several ways to manage links, much more than other software put you at your disposal.

Hi.

p.s.: the same excel if you move files chaoticly you lose links.

 

[gerod]

Yes, links lose them excel, word, and many other programs when you move files and you still have to redefine the paths.
same thing if you move a dft or a par of an asm.
Therefore, as the hunter said, the criticisms can be there but without being offensive.
Hi.

 

[cacciatorino]

Of course these too, in the guide they generally speak of spreadsheets, then discover that it works only and exclusively with ms-excel.. . .
Yet among the excel prerequisites is never mentioned, on this I use openoffice a bit I took it.. .

 

[Marco74]

Of course these too, in the guide they generally speak of spreadsheets, then discover that it works only and exclusively with ms-excel.. . .
Yet among the excel prerequisites is never mentioned, on this I use openoffice a bit I took it.. .

use pure open office or any different distribution?

Bye.

 

[cacciatorino]

use pure open office or any different distribution?

Bye.

the pure one downloaded from it.openoffice. Org.

Why did you try other versions that work in this respect? I'd be interested... .

 

[Marco74]

the pure one downloaded from it.openoffice. Org.

Why did you try other versions that work in this respect? I'd be interested... .

www.[B]go[/B]-oo.org/ download is in English, but then there is the language pack, reading in magazines it seems that it has been implemented some functions that the original version does not have, and it seems that it manages the vba programming macros as excel, but sincerely I have never tried.

Hi.

 

[gerod]

I asked in his time for assistance if they could implement if with ooo and they told me craze!
Well, I bought msexcel but I use it little by little.
Anyway, I have several files pointing to a sheet in excell made in 2004. keeping it in the same position compared to par I never had problems and I don't tell you how many laps did that folder on different computers.

 

[Sbabba]

So, it seems to me that the "relative" paths, as clearly you have noticed, are not implemented, unless be_on_edge knows the trick that makes things work.

to solve the rpoblema you have two ways:
1) Always use the review manager to move files (e.g. from your disk to usb key, and then from the usb key to the pc disk of your studio companion)
2) pass the files via key by copying them with the file manager of windows, but then you have to reopen them with the revision manager and use the function "refine links".

For the future, I invite you to avoid using terms such as a "ridiculous" referring to a product, because they are offensive to those who work to do so. I guess you wouldn't like someone to call your pressure vessel project, would you?


p.s. the proof I made it between two files par, ninth I sell excel. You should see if the rm works equally between rows of if and spreadsheets.
Good job.

Thank you very much, I will try. I had the program under university license, but if I thought I had to buy it and then find myself with this problem I think that defining it "ridiculous" would be the least, with all respect for who did it.

Similarly I also define windows seen for the speed of transfer of files via usb before service pack 1, and who did not have to offend, because I consumer, having paid, I have the right to express my opinion, and who makes a program and sells it must know that the product can please or not.

cmq there was no intention of offending anyone, it was a direct way to express my disappointment

rather, one last thing since you have been so available and fast, and for that I thank you. I have 2 monitors attached to the pc, one in 1920x1080 and one in 1280x1024, when with if I open the variable table, sometimes I open it on the secondary screen (the full-hd) even if this is turned off and disabled in windows. Obviously the problem is solved, because I just turn on the TV, set it as the main monitor and at that point the window appears, only that the thing is boring enough to do. Is there a way to prevent the program from using the secondary monitor? I don't understand why you do it, because this monitor is disabled in windows so the output from the video card should not be used instead... .

Thank you very much again, great forum

 

[Sbabba]

I asked in his time for assistance if they could implement if with ooo and they told me craze!
Well, I bought msexcel but I use it little by little.
Anyway, I have several files pointing to a sheet in excell made in 2004. keeping it in the same position compared to par I never had problems and I don't tell you how many laps did that folder on different computers.

So you confirm that with open office I can't tie the variables of if to a calculation file??? but this happens either by saving the file as .ods or as .xls or only in case you use the native extension of oo?

 

[cacciatorino]

So you confirm that with open office I can't tie the variables of if to a calculation file??? but this happens either by saving the file as .ods or as .xls or only in case you use the native extension of oo?

You can't.
it is not enough to save in xls format from openoffice, it is necessary to have ms-excel installed on the pc.

 

[marcof]

You can't.
it is not enough to save in xls format from openoffice, it is necessary to have ms-excel installed on the pc.

it's the same bazza even with swx; where if you don't have excel installed you can't just connect to external sheets, but just the internal data table doesn't work. when you edit the data table the menus above become those of excel.. .
Then they say Colombian coke cartels...

 

[cacciatorino]

but the internal data table does not work.

What???? :Mad::3559:

My god where I'm going to finish... at least if he has his internal spreadsheet... .

 

[marcof]

What???? :Mad::3559:
My god where I'm about to finish. . .

It will be good that you start getting used to the idea then:redface:

 

[cacciatorino]

It will be good that you start getting used to the idea then:redface:

cable you of the swx forum made believe that swx was the mejo of the universe, even cooler than the smearss of the apple.... and instead to the end.... wink:tongue:

 

[marcof]

You're from the swx forum that swx was the mejo of the universe, even cooler than the smearss of the apple... and at the end.... .

What do you want, every scarrafone is beautiful to his mother:smile:
[mode bastard ON]Well, come on, don't let me talk about the variable table of if inside, which is like shooting on the red cross :tongue:
better then sell to gugliemo gates, which then someone sells for the data table (excel) and someone else for the iterface office style [mode bastard OFF]p.s.
more cool than the apple comuterss, those who do not repair laptops to smokers because their tectonics are half weaker than lungs, those who are so userfrendly that even my grandfather is able to use them just lit (but rotfl !!!) there is no one. :tongue:

 

[Sbabba]

What???? :Mad::3559:

My god where I'm going to finish... at least if he has his internal spreadsheet... .

Do you see that I don't have all the twists to give you a "ricle" at the end? make you spend money on a propie program when you can do the same thing with a free program. I don't know if you laugh or cry, I hope you don't feel it normal. . .

 

[cacciatorino]

Do you see that I don't have all the twists to give you a "ricle" at the end? make you spend money on a propie program when you can do the same thing with a free program. I don't know if you laugh or cry, I hope you don't feel it normal. . .

in fact I have commented not on the criticism but on the way to put it.

However welcome to the world of propietario software... I also use free soft, but unfortunately at the moment the panorama of opensource cad is at least desolate.

 

[cacciatorino]

it's the same bazza even with swx; where if you don't have excel installed you can't just connect to external sheets, but just the internal data table doesn't work. when you edit the data table the menus above become those of excel.. .
Then they say Colombian coke cartels...

I misunderstood:

also in swx, as in itself, although not having excel it is possible to connect through equations the variables of the model, and also create new variables generated by the user according to which then drive the model.
It's slightly more uncomfortable than in itself but you can do the same.

it is also possible to export the lists part without having excel, you have to save them in csv and import them into openoffice. a little bit more uncomfortable than if it allows the copy paste directly between the table on the drawing and openoffice or from the assieme export directly to rtf or csv without passing from the draft, but you can do it equally.