I tried make terrain meshes but is not what i need. So the only way is exporting the SKP to another modeling software, like solidworks, autodesk simulation cfd and now Xflow CFD

@tig said:

You can only import XLS files directly into a SKP if you were to write a custom PC tool to read the XLS file binary data using Win32ole.so linked into Ruby
However, you can save_as XLS files from within Excel, as CSV [Comma Separated Variable text files] which are easily read in Ruby and the data converted into geometry. There are many examples of this - the most common being importing XYZ data via CSVs for making terrain meshes- one point per line [1.2,3.4,5.6] etc...

But i want export my 3D model Sketchup to another software, and then, import my *.xls files on that software

I think that's not what i pretend. I did some research and i found two interesting software: Solidworks and Autodesk Simulation CFD. But i dont know if i can import my *.xls files.
My thought is:
1- Import my 3D model into one of this softwares
2- Chose points in my model where my data loggers record the temperature
3- On that points, import the *.xls files with the values of temperatures
4- Hopefully see the multiples temperatures in my lab, something like that: http://www.youtube.com/watch?v=CxHVLqUYYL8

or

@beginner said:

Hi diogofsousa92,

Again, I don't know how to do it yet but, I try to follow your assignment...

You said that you have data loggers:

1. What kind of data do you collect (just temperature over time)?
2. What kind of data format it is (*.csv, *.xls)?
3. What kind of graph do you want to see in SketchUp (2D - where X is the time and Y is the temperature)?
4. Do you have to show the temperature distribution within a room/shape? - I'm just thinking out loud here...

If this is the case it is almost like a 2D point cloud but, it could me more fun - you could create 3D point cloud...Easily done in SketchUp.

You could use:
X axis = as a time (24 hours),
Y axis = as a day (365 days)
Z axis = as a temperature (whatever you read from your loggers in Excel)
Each logger would produce separate graph...

You will get surface...which you could slice and colour with different temperature thresholds and slice again day-by-day etc - I see that as 'terrain with contours' with fixed/predicted plan area.

Have a look at point cloud and terrain topics in SU.

PS. I think it could be beautifully presented in SketchUp

Hi beginner,

i think that is just what i looking for, but how i can do it?

1. Yes, i collect temperature over time (time is data and time "yyyy-mm-dd hh:mm")
2. The file is .xls
3. What i realy wanna see is my graphic moving when time is passing, i mean, as time progresses, the temperature will range.

Thank you

@notareal said:

Perhaps something like EnergyPlus is usable?
http://apps1.eere.energy.gov/buildings/energyplus/

I already knew that plugin but is not what i need. The EnergyPlus is usefull when you have your house/room, but my laboratory is underground, so the sun is not important for the case. I only have in lab HVAC controllated.

Best regards,
Diogo Sousa

@beginner said:

Hi diogofsousa92,

I don't know how to do it but, temperature and light have similarities in the way how you draw the gradients / distribution.
There are few plugins for SketchUp which are dealing with light and energy 'Element'.

I can only assume - if this is possible with light and energy it would be possible with temperature.
Temperature could be more trickier (more external factors could disturb the distribution) but, some basic modelling should be possible.

Just a thought...
Look for Analysis Tools for SketchUp.

The idea is using some data loggers in the lab to record the temperatures. After that, i have to describe the variation of temperature in function of time (data/hour).
The energy is not important for the case but thank you for your quick reply.
Best regards,
Diogo Sousa

Hi everyone,

i'm a new user of google sketchup. I'm working in a company and they told me to do the laboratory where i am in 3D. So far so good, but now they told me to do the temperature gradient of the room. I wanna know if is possible do it on skhetchup.

Please help me!

Best Regards,
Diogo Sousa