Roast Logger by HC120606095948

VIEWS: 20 PAGES: 13

									Roast Log Plotter                          #NAME?
                             NUMBERS
First Data Row                   3        Row with the First Temperature
Data Time Interval              10        Seconds [Default : 10]
Bean Data Column                 2        Column with Bean Temperature
Enviro Data Column               5        Column with Roaster Environment Temperature [0 for None]
Time Series Column               9        Column with Log Time
Fixed Plot Width [minutes]       0        All Plots will be a minimum of [minutes] wide. Enter 0 for Automatic width
Min Temp                         0        Set Plot Min Temp [Default : 0]
Max Temp                       500        Set Plot Max Temp [Default : 500]
Nominal Voltage                120        Edit on Plot Data if changing, or use for Gas control value

                               TEXT
Default Extension               txt       Default Extension of Exported Data

                                              Data Path
AutoSave New Import             On        C:\Program Files\Extech dual datalogging thermometer\data\LasAlturas\
Auto Add Import to Group        On

   Compare Roast Plots        Plot No          Plot List
                                      1
                                      2
                                      3
                                      4
                                      5
                                      6
                                      7
                                      8
Compare Plot Ideal ON                 9
                                     10
                                                ^^^^       Set Font Color to Set Compare Plot Line Color
        Latest Version
http://www.ielogical.com/coffee
     ieales@ielogical.com
                     Compare Group File
 ith the First Temperature                                                   vvvv Plot Line is Font Color
ds [Default : 10]                                                      Bean Temp <<< Fill Color is Plot BG
n with Bean Temperature                                                Enviro Temp On
n with Roaster Environment Temperature [0 for None]                    Volts          On
n with Log Time                                                        DegPerMin      On Smooth
  s will be a minimum of [minutes] wide. Enter 0 for Automatic width   Power          Off
ot Min Temp [Default : 0]                                              Fan            On
ot Max Temp [Default : 500]                                            Ideal          On
   Plot Data if changing, or use for Gas control value                 ET/BT          On       20 sec
                                                                       Ideal Courtesy of Jim Schulman
                                                                       http://www.CoffeeCuppers.com
t Extension of Exported Data                                                               ° Rotation
                                                                                             Fan Power
             [ Filled after Import for Subsequent Imports ]                                     0 36%
gram Files\Extech dual datalogging thermometer\data\LasAlturas\                                45 45%
                                                                                               90 56%
              [ Position Cursor below Plot List and Click Select ]                            135 69%
                                                                                              180 84%
                                                                                              225 91%
                                                                                              Full 100%




^^^^    Set Font Color to Set Compare Plot Line Color
olor is Plot BG
Date:2006/08/20
Time:16:54:37
Interval:00:00:10
ID          T1           Unit   Type   T2           Unit   Type   Date     Time
          1      301.2   F      K           678.6   F      K      8/20/2006 16:54:37
          1      281.8   F      K           736.1   F      K      8/20/2006 16:54:47
          1      242.3   F      K             713   F      K      8/20/2006 16:54:57
          1      210.9   F      K           711.5   F      K      8/20/2006 16:55:07
          1      193.3   F      K           709.5   F      K      8/20/2006 16:55:17
          1        184   F      K           708.1   F      K      8/20/2006 16:55:27
          1        179   F      K           707.8   F      K      8/20/2006 16:55:37
          1      177.9   F      K           708.1   F      K      8/20/2006 16:55:47
          1      180.1   F      K           708.9   F      K      8/20/2006 16:55:57
          1      183.9   F      K           709.1   F      K      8/20/2006 16:56:07
          1      189.8   F      K           709.6   F      K      8/20/2006 16:56:17
          1      197.3   F      K           707.8   F      K      8/20/2006 16:56:27
          1      202.8   F      K           704.4   F      K      8/20/2006 16:56:37
          1        211   F      K           703.9   F      K      8/20/2006 16:56:47
          1      218.2   F      K           709.8   F      K      8/20/2006 16:56:57
          1      225.8   F      K           705.9   F      K      8/20/2006 16:57:07
          1      232.1   F      K           701.1   F      K      8/20/2006 16:57:17
          1      241.1   F      K           694.6   F      K      8/20/2006 16:57:27
          1      248.8   F      K           684.3   F      K      8/20/2006 16:57:37
          1        255   F      K           674.8   F      K      8/20/2006 16:57:47
          1      260.9   F      K           655.6   F      K      8/20/2006 16:57:57
          1      267.6   F      K           658.6   F      K      8/20/2006 16:58:07
          1      272.7   F      K           646.7   F      K      8/20/2006 16:58:17
          1      278.1   F      K           637.5   F      K      8/20/2006 16:58:27
          1      282.4   F      K           629.6   F      K      8/20/2006 16:58:37
          1      287.5   F      K           619.9   F      K      8/20/2006 16:58:47
          1      291.4   F      K           617.4   F      K      8/20/2006 16:58:57
          1      295.9   F      K           609.7   F      K      8/20/2006 16:59:07
          1      299.1   F      K           606.8   F      K      8/20/2006 16:59:17
          1        303   F      K           599.5   F      K      8/20/2006 16:59:27
          1      306.2   F      K           588.3   F      K      8/20/2006 16:59:37
          1      309.7   F      K           571.7   F      K      8/20/2006 16:59:47
          1      312.4   F      K           571.3   F      K      8/20/2006 16:59:57
          1      315.2   F      K           559.8   F      K      8/20/2006 17:00:07
          1      317.8   F      K           559.9   F      K      8/20/2006 17:00:17
          1      320.3   F      K           548.1   F      K      8/20/2006 17:00:27
          1      322.6   F      K           547.4   F      K      8/20/2006 17:00:37
          1      324.6   F      K           538.8   F      K      8/20/2006 17:00:47
          1        327   F      K           546.4   F      K      8/20/2006 17:00:57
          1        329   F      K             555   F      K      8/20/2006 17:01:07
          1      331.2   F      K           537.5   F      K      8/20/2006 17:01:17
          1      333.1   F      K           539.5   F      K      8/20/2006 17:01:27
          1      335.5   F      K           547.6   F      K      8/20/2006 17:01:37
          1      337.5   F      K           552.8   F      K      8/20/2006 17:01:47
          1      340.1   F      K             557   F      K      8/20/2006 17:01:57
          1      342.4   F      K           563.4   F      K      8/20/2006 17:02:07
          1      344.9   F      K           563.1   F      K      8/20/2006 17:02:17
          1      347.3   F      K           564.1   F      K      8/20/2006 17:02:27
1   350.3   F   K     572   F   K   8/20/2006   17:02:37
1     353   F   K   572.7   F   K   8/20/2006   17:02:47
1   356.5   F   K     574   F   K   8/20/2006   17:02:57
1   358.9   F   K     574   F   K   8/20/2006   17:03:07
1   362.4   F   K   580.6   F   K   8/20/2006   17:03:17
1   365.2   F   K   578.4   F   K   8/20/2006   17:03:27
1   368.5   F   K   578.9   F   K   8/20/2006   17:03:37
1   371.7   F   K   579.8   F   K   8/20/2006   17:03:47
1   375.1   F   K   579.5   F   K   8/20/2006   17:03:57
1   378.9   F   K   580.3   F   K   8/20/2006   17:04:07
1   382.5   F   K   581.3   F   K   8/20/2006   17:04:17
1   386.7   F   K   579.5   F   K   8/20/2006   17:04:27
1   389.9   F   K     579   F   K   8/20/2006   17:04:37
1   393.8   F   K   575.8   F   K   8/20/2006   17:04:47
1   397.2   F   K   575.5   F   K   8/20/2006   17:04:57
1   401.4   F   K   570.8   F   K   8/20/2006   17:05:07
1   404.3   F   K   564.3   F   K   8/20/2006   17:05:17
1   407.1   F   K   558.3   F   K   8/20/2006   17:05:27
1   410.4   F   K   551.1   F   K   8/20/2006   17:05:37
1   412.7   F   K   546.3   F   K   8/20/2006   17:05:47
1   415.4   F   K   542.9   F   K   8/20/2006   17:05:57
1   417.2   F   K   539.4   F   K   8/20/2006   17:06:07
1   419.6   F   K   534.3   F   K   8/20/2006   17:06:17
1   421.5   F   K   531.8   F   K   8/20/2006   17:06:27
1   424.1   F   K   528.9   F   K   8/20/2006   17:06:37
1   425.8   F   K   526.9   F   K   8/20/2006   17:06:47
1   427.7   F   K   525.3   F   K   8/20/2006   17:06:57
1   429.9   F   K     525   F   K   8/20/2006   17:07:07
1   432.3   F   K     522   F   K   8/20/2006   17:07:17
1   434.2   F   K   519.1   F   K   8/20/2006   17:07:27
1   436.6   F   K   514.5   F   K   8/20/2006   17:07:37
1   438.5   F   K   507.3   F   K   8/20/2006   17:07:47
1   440.5   F   K   504.9   F   K   8/20/2006   17:07:57
1   442.3   F   K   500.5   F   K   8/20/2006   17:08:07
1   444.3   F   K   494.3   F   K   8/20/2006   17:08:17
Courtesy of :          Jim Schulman          Tooth Fairy
           http://www.CoffeeCuppers.com
           Time        Slow       Fast       IR-12
                  0:00       70.0       70.0       70.0
                  0:10       85.0       85.0       75.9
                  0:20      100.0      100.0       81.8
                  0:30      115.0      115.0       87.7
                  0:40      130.0      130.0       93.6
                  0:50      145.0      145.0       99.5
                  1:00      160.0      160.0      105.4
                  1:10      175.0      175.0      111.3
                  1:20      190.0      190.0      117.2
                  1:30      205.0      205.0      123.1
                  1:40      220.0      220.0      129.0
                  1:50      235.0      235.0      134.9
                  2:00      250.0      250.0      140.8
                  2:10      254.2      254.2      146.7
                  2:20      258.3      258.3      152.6
                  2:30      262.5      262.5      158.5
                  2:40      266.7      266.7      164.4
                  2:50      270.8      270.8      170.3
                  3:00      275.0      275.0      176.2
                  3:10      279.2      279.2      182.1
                  3:20      283.3      283.3      187.9
                  3:30      287.5      287.5      193.8
                  3:40      291.7      291.7      199.7
                  3:50      295.8      295.8      205.6
                  4:00      300.0      300.0      211.5
                  4:10      304.0      305.3      217.4
                  4:20      307.9      310.6      223.3
                  4:30      311.9      315.8      229.2
                  4:40      315.8      321.1      235.1
                  4:50      319.8      326.4      241.0
                  5:00      323.8      331.7      246.9
                  5:10      327.7      336.9      252.8
                  5:20      331.7      342.2      258.7
                  5:30      335.6      347.5      264.6
                  5:40      339.6      352.8      270.5
                  5:50      343.5      358.1      276.4
                  6:00      347.5      363.3      282.3
                  6:10      351.5      368.6      288.2
                  6:20      355.4      373.9      294.1
                  6:30      359.4      379.2      300.0
                  6:40      363.3      384.5      304.7
                  6:50      367.3      389.7      309.3
                  7:00      371.3      395.0      314.0
                  7:10      375.2      397.5      318.7
                  7:20      379.2      400.0      323.3
                  7:30      383.1      402.5      328.0
                  7:40      387.1      405.0      330.9
                  7:50      391.1      407.5      333.8
                  8:00      395.0      410.0      336.7
 8:10   396.5   412.5   339.6
 8:20   398.0   414.9   342.4
 8:30   399.5   417.4   345.3
 8:40   401.0   419.9   348.2
 8:50   402.5   422.4   351.1
 9:00   403.9   424.9   354.0
 9:10   405.4   427.4   356.9
 9:20   406.9   429.9   359.8
 9:30   408.4   432.4   362.7
 9:40   409.9   434.9   365.6
 9:50   411.4   437.4   368.4
10:00   412.9   439.9   371.3
10:10   414.4   442.4   374.2
10:20   415.9   444.9   377.1
10:30   417.4   447.4   380.0
10:40   418.8   449.8   385.0
10:50   420.3   452.3   390.0
11:00   421.8   454.8   395.0
11:10   423.3   457.3   396.9
11:20   424.8   459.8   398.8
11:30   426.3   462.3   400.6
11:40   427.8   464.8   402.5
11:50   429.3   467.3   404.4
12:00   430.8   469.8   406.3
12:10   432.3   472.3   408.1
12:20   433.7   474.8   410.0
12:30   435.2   477.3   411.9
12:40   436.7   479.8   413.7
12:50   438.2   482.2   415.6
13:00   439.7   484.7   417.5
13:10   441.2   487.2   419.4
13:20   442.7   489.7   421.2
13:30   444.2   492.2   423.1
13:40   445.7   494.7   425.0
13:50   447.2   497.2   426.9
14:00   448.6   499.7   428.7
14:10   450.1   502.2   430.6
14:20   451.6   504.7   432.5
14:30   453.1   507.2   434.4
14:40   454.6   509.7   436.2
14:50   456.1   512.2   438.1
15:00   457.6   514.7   440.0
15:10   459.1   517.1   441.9
15:20   460.6   519.6   443.7
15:30   462.1   522.1   445.6
15:40   463.5   524.6   447.5
15:50   465.0   527.1   449.4
16:00   466.5   529.6   451.2
16:10   468.0   532.1   453.1
16:20   469.5   534.6   455.0
16:30   471.0   537.1   456.9
16:40   472.5   539.6   458.7
16:50   474.0   542.1   460.6
17:00   475.5   544.6   462.5
17:10   477.0   547.1   464.4
17:20   478.4   549.5   466.2
17:30   479.9   552.0   468.1
17:40   481.4   554.5   470.0
17:50   482.9   557.0   471.9
18:00   484.4   559.5   473.7
18:10   485.9   562.0   475.6
18:20   487.4   564.5   477.5
18:30   488.9   567.0   479.4
18:40   490.4   569.5   481.2
18:50   491.9   572.0   483.1
19:00   493.3   574.5   485.0
19:10   494.8   577.0   486.9
19:20   496.3   579.5   488.7
19:30   497.8   582.0   490.6
19:40   499.3   584.4   492.5
19:50   500.8   586.9   494.4
20:00   502.3   589.4   496.2
20:10   503.8   591.9   498.1
20:20   505.3   594.4   500.0
20:30   506.8   596.9   501.9
20:40   508.2   599.4   503.7
20:50   509.7   601.9   505.6
21:00   511.2   604.4   507.5
Rev                                         Changes
  1.00   Initial release
  1.10   Add Path and Plot Lists
  1.11   Add Volts and Power plots
  1.20   Add Bean Temp Ramp Degrees Per Minute, Auto Scale for Axis
  1.21   Remove 2nd Y Axis variance and use same numbers as main.
  1.22   Add Setting Plot Color from Line Column Interior Color
  1.23   Add Fan Column to Plots
  1.24   Add Ideal plots
  1.25   Add Plot On Off
  1.26   Add Deg Per Min Smoothing
  1.27   Fix Legend bug, add Category Gridlines, make gridlines dotted
         Set select to *.xls, name Compare plots by WkBk, check dup Compare
  1.28   files, allow format cells to set color for Compare plots
  1.29   Turn OFF ScreenUpdating
  1.30   Add Group Lists
  1.31   Change to Get[Open/Save]FileName to Support 2000
  1.32   Remove % for Fan
  1.33   Fix Y Axis Max to 550, Min to 0 for plot print overlay
  1.34   Format Compare with same gridlines as standard
  1.35   Add Plot Fill Color on Beans Fill Color
  1.36   Hardcode Plot Names to maximize plot area
  1.37   Check for Open WkBk on Compare Plots
  1.38   Add Margins to maximize plot window
  1.39   Add Fixed Plot Width option
  1.40   Add Open Button for files in Group List
  1.41   Updated Cup Sheet to same values as Coffee Cuppers
  1.42   Added IR-12 Drum profile
  1.43   Bug Fix when no plot 2nd Axis
  1.44   Add Sized w Window for Chart
  1.45   Add Sized w Window for Compare Chart
  1.46   Add Max Plot Temp
  1.47   Add Roast / Shot Toggle
  1.48   Add Min Plot Temp
  1.49   Data Time Interval
  1.50   Fan Knob Rotation Power Levels
  1.51   Compare Plot Ideal On / Off
  1.52   Move Legend and Set Chart Width
  1.53   Clear Group Button
  1.54   Add FileName to Chart
  1.55   Clear Group FileName, fix Ideal Bug on Shot Plot
  1.56   Align Shot Plots to Min Temp
  1.57   Set Plot Width to 1 Minute for Shot
  1.58   Set Horizontal Grid Lines for Shot Plot Import
  1.59   Add Setup Files
  1.60   Add AutoSave if New Import
  1.61   Fix 2nd Axis scale error
  1.62   Fix WkBk Name, Font size in Text Box
  1.63   Add Compare Chart name
  1.64   Move cell after group select
  1.65   Remove RevList and set rev to Max Revisons!A:A
  1.66   Minor text bug fixes, Check blank group list
1.67   Add Import to Group
1.68   Fix Group Compare Plot same file name
2.00   Add BT/ET plot
2.01   Change Deg / Min to smooth from end of roast
2.02   Change vertical gridlines to 1 minute
2.03   Plot Enviro on Left Axis, ETBT on right scale to 250
2.04   Add replace bad -9999 data as average of surrounding good data
2.05   Bug Fix import freeze panes on plot data
2.06   Remove Shot plotting

								
To top