Solar-h2o:Copper-Graphs - Revision history

Copelco at 01:48, 22 November 2006

2006-11-22T01:48:16Z

← Older revision		Revision as of 01:48, 22 November 2006
Line 1:		Line 1:
			== Plots of Ehren's Equation Against Recorded Values ==

	http://cs.earlham.edu/~hip/enpr256/test1.png		http://cs.earlham.edu/~hip/enpr256/test1.png

			[[http://cs.earlham.edu/~hip/enpr256/test1.eps EPS]]

	http://cs.earlham.edu/~hip/enpr256/test2.png		http://cs.earlham.edu/~hip/enpr256/test2.png

			[[http://cs.earlham.edu/~hip/enpr256/test1.eps EPS]]

	http://cs.earlham.edu/~hip/enpr256/test3.png		http://cs.earlham.edu/~hip/enpr256/test3.png

			[[http://cs.earlham.edu/~hip/enpr256/test1.eps EPS]]

			== Process (so I can remember) ==
	=== Export database table to file ===		=== Export database table to file ===
	hip=# BEGIN;		hip=# BEGIN;
Line 24:		Line 35:
	006 076.55 076.66 074.41		006 076.55 076.66 074.41
	...		...
			[[http://cs.earlham.edu/~hip/enpr256/copper_lab.txt Data File]]

	=== Create gnuplot file ===		=== Create gnuplot file ===
Line 77:		Line 89:
	set output "test3.eps"		set output "test3.eps"
	replot		replot

			[[http://cs.earlham.edu/~hip/enpr256/graph.plot Plot File]]

Copelco at 01:43, 22 November 2006

2006-11-22T01:43:31Z

← Older revision		Revision as of 01:43, 22 November 2006
Line 1:		Line 1:
			http://cs.earlham.edu/~hip/enpr256/test1.png
			http://cs.earlham.edu/~hip/enpr256/test2.png
			http://cs.earlham.edu/~hip/enpr256/test3.png

	=== Export database table to file ===		=== Export database table to file ===

Copelco: /* Export database table to file */

2006-11-22T01:40:15Z

Export database table to file

← Older revision		Revision as of 01:40, 22 November 2006
Line 10:		Line 10:
	to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;		to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;
	SELECT		SELECT
	hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt' NULL AS '-';COPY		hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt' NULL AS '-';
			COPY
	hip=# ROLLBACK;		hip=# ROLLBACK;
	ROLLBACK		ROLLBACK

Copelco: /* Export database table to file */

2006-11-22T01:39:41Z

Export database table to file

← Older revision		Revision as of 01:39, 22 November 2006
Line 7:		Line 7:
	hip=# CREATE TEMP TABLE copper_runs AS		hip=# CREATE TEMP TABLE copper_runs AS
	hip-# SELECT to_char(run3,'099.99') as run3, \		hip-# SELECT to_char(run3,'099.99') as run3, \
	to_char(run2,'099.99') as run2,		to_char(run2,'099.99') as run2, \
	to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;		to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;
	SELECT		SELECT

Copelco: /* Export database table to file */

2006-11-22T01:39:31Z

Export database table to file

← Older revision		Revision as of 01:39, 22 November 2006
Line 6:		Line 6:
	BEGIN		BEGIN
	hip=# CREATE TEMP TABLE copper_runs AS		hip=# CREATE TEMP TABLE copper_runs AS
	hip-# SELECT to_char(run3,'099.99') as run3,to_char(run2,'099.99') as run2,to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;		hip-# SELECT to_char(run3,'099.99') as run3, \
			to_char(run2,'099.99') as run2,
			to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;
	SELECT		SELECT
	hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt' NULL AS '-';COPY		hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt' NULL AS '-';COPY

Copelco: /* Export database table to file */

2006-11-22T01:39:03Z

Export database table to file

← Older revision		Revision as of 01:39, 22 November 2006
Line 5:		Line 5:
	hip=# BEGIN;		hip=# BEGIN;
	BEGIN		BEGIN
	hip=# CREATE TEMP TABLE copper_runs ~~AShip~~-# SELECT to_char(run3,'099.99') as run3,to_char(run2,'099.99') as run2,to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;		hip=# CREATE TEMP TABLE copper_runs AS
			hip-# SELECT to_char(run3,'099.99') as run3,to_char(run2,'099.99') as run2,to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;
	SELECT		SELECT
	hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt' NULL AS '-';COPY		hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt' NULL AS '-';COPY

Copelco: /* Create gnuplot file */

2006-11-22T01:38:42Z

Create gnuplot file

← Older revision		Revision as of 01:38, 22 November 2006
Line 25:		Line 25:
	set ylabel "Temperature (F)"		set ylabel "Temperature (F)"

	########### Test 1 ###########		########### Test 1 ###########
	set title "Copper Pipe Heat Exchanger Test - Test #1"		set title "Copper Pipe Heat Exchanger Test - Test #1"

Copelco: /* Export database table to file */

2006-11-22T01:38:22Z

Export database table to file

@@ Line 1: / Line 1: @@
 === Export database table to file ===
-  hip=# BEGIN;BEGIN
+  hip=# BEGIN;
   hip=# CREATE TEMP TABLE copper_runs AShip-# SELECT to_char(run3,'099.99') as run3,to_char(run2,'099.99') as run2,to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;
   SELECT
-  hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt';COPY
+  hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt' NULL AS '-';COPY
-  hip=# ROLLBACK;ROLLBACK
+  hip=# ROLLBACK;
   hip=#

Copelco: /* Export database table to file */

2006-11-21T23:22:28Z

Export database table to file

← Older revision		Revision as of 23:22, 21 November 2006
Line 1:		Line 1:

	=== Export database table to file ===		=== Export database table to file ===
	hip=# BEGIN;		hip=# BEGIN;BEGIN
	BEGIN		hip=# CREATE TEMP TABLE copper_runs AShip-# SELECT to_char(run3,'099.99') as run3,to_char(run2,'099.99') as run2,to_char(run1,'099.99') as run1 FROM ss_copper_lab ORDER BY date ASC;
	hip=# CREATE TEMP TABLE ~~copper_over_time AS~~
	~~hip~~-# SELECT to_char(~~date~~, '~~MI:SS~~'),~~run1~~,run2,~~run3~~ FROM ss_copper_lab ORDER BY date ASC;
	SELECT		SELECT
	hip=# COPY ~~copper_over_time~~ TO '/clients/users/copelco/copper_lab.txt';		hip=# COPY copper_runs TO '/clients/users/copelco/copper_lab.txt';COPY
	COPY		hip=# ROLLBACK;ROLLBACK
	hip=# ROLLBACK;		hip=#
	~~ROLLBACK~~

Copelco at 22:16, 21 November 2006

2006-11-21T22:16:30Z

New page

=== Export database table to file ===
hip=# BEGIN;
BEGIN
hip=# CREATE TEMP TABLE copper_over_time AS
hip-# SELECT to_char(date, 'MI:SS'),run1,run2,run3 FROM ss_copper_lab ORDER BY date ASC;
SELECT
hip=# COPY copper_over_time TO '/clients/users/copelco/copper_lab.txt';
COPY
hip=# ROLLBACK;
ROLLBACK