[Radiance-general] rcollate troubles in Five-Phase CFS tutorial

[Greg Ward]

Hi Chris,

I think the answer to your question is 'yes,' but you probably want something more specific.  Unfortunately, I don't understand your format well enough from your description, so it's difficult for me to instruct you.  If your 6 points each have 3 values for RGB and you just want to arrange them into rows that look like this (ignore labels before the colon):

hour1:	R1 G1 B1 R2 G2 B2 R3 G3 B3 R4 G4 B4 R5 G5 B5 R6 G6 B6
hour2:	R1 G1 B1 R2 G2 B2 R3 G3 B3 R4 G4 B4 R5 G5 B5 R6 G6 B6
....
hour8760:		R1 G1 B1 R2 G2 B2 R3 G3 B3 R4 G4 B4 R5 G5 B5 R6 G6 B6

This can be achieved with a simple rcollate command, here assuming no header:

	rcollate -h -oc 6 input.txt > output.txt

If instead, your input is ordered with 8760 RGB values for sensor 1, followed by 8760 RGB values for sensor 2, etc., you'll need to transpose using:

	rcollate -h -ic 8760 -ir 6 -t input.txt > output.txt

I hope this is clear enough, but I realize it's confusing.

-Greg

> From: Chris Coulter <Chris.Coulter at BuroHappold.com>
> Subject: Re: [Radiance-general] rcollate troubles in Five-Phase CFS tutorial
> Date: April 15, 2014 10:55:35 PM PDT
> 
> Greg-
> Thanks for the quick response.  Yes, it all makes sense and works. I was expecting –h to suppress the header rather than not to expect it.
>  
> Rcollate is still a bit confusing (especially at this lovely hour on the east coast). Is there a quick way I can take the single column of 52560 values (8760hrs * 6pts) and place them in a matrix/array that is 8760 hours long/rows and the data points read across the columns? This would help me import the illuminance profiles into Excel templates I had already created using the 2-phase method. I’m sure I can write a script to clip the files into 8760 rows each then rlam them back together, but if I can just manage it on output from rcollate that would be better/cleaner. I see the note in the man page about it being inflexible – maybe this is the only behavior.
>  
> Thanks again!
> Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.radiance-online.org/pipermail/radiance-general/attachments/20140416/a5300e68/attachment-0001.html>