Attached here are the LPVs that will be fainter than 13.5V at some point in June (usually a good portion of thre month).
There is a Word doc file, and a .csv file. For some reason the RA gets truncated going from word to .csv, so the .csv file is less useful if you want to sort. If anyone can tell me how to fix this, or do it yourself, post a revised version here for others to use, and tell me what the heck I'm doing wrong!
Thanks, and enjoy.
Name
RA
Dec
Period
Range
Nobs
Status June
Z PEG
00:00:06.55
+25:53:11.2
334.8
<8.4-13.2>
220
fading
R AND
00:24:01.94
+38:34:37.3
409.33
<6.9-14.3>
460
fading
U CAS
00:46:21.36
+48:14:38.6
277.2
<8.4-14.8>
121
rising
RW AND
00:47:18.9
+32:41:08.8
430.3
<8.7-14.8>
50
fading
V AND
00:50:06.28
+35:39:10.1
257.73
<9.5-14.4>
103
rising
RV CAS
00:52:42.78
+47:24:56.4
331.68
<9.4-15.2>
89
rising
UZ AND
01:16:11.16
+41:44:58.3
314.3
<10.1-14.9>
68
min(7)
S PSC
01:17:34.54
+08:55:52.6
404.62
<9.6-15.0>
35
fading
RR PER
02:28:29.42
+51:16:17.1
389.62
<9.2-14.4>
79
fading
RR CEP
02:43:15.47
+81:08:09.5
384.18
<10.2-14.7>
103
min(20)
U ARI
03:11:03.04
+14:48:00.2
371.13
<8.1-14.6>
86
fading
R TAU
04:28:18
+10:09:44.7
320.9
<8.6-14.2>
146
rising
S TAU
04:29:11.75
+09:56:43.5
374.5
<10.2-15.3>
46
fading
V ORI
05:06:03.43
+04:06:08.7
263.7
<9.4-14.1>
40
min(21)
RU AUR
05:40:07.93
+37:38:10.6
466.47
<9.6-14.5>
61
fading
Z TAU
05:52:24.85
+15:47:43.8
453
<9.8-13.9>
14
fading
V CAM
06:02:32.28
+74:30:27.2
522.45
<9.9-15.4>
22
fading
S LYN
06:44:34.11
+57:54:39.8
296.34
<9.6-14.3>
45
rising
V CMI
07:06:58.84
+08:52:36.8
366.1
<8.7-14.9>
85
rising
V CMI
07:06:58.84
+08:52:36.8
366.1
<8.7-14.9>
85
rising
U CNC
08:35:46.28
+18:53:44.6
304.78
<9.9-14.6>
94
min(15)
X UMA
08:40:49.49
+50:08:11.7
249.04
<9.7-14.4>
82
fading
Y DRA
09:42:22.58
+77:51:06.5
325.79
<9.2-14.5>
79
min(7)
RR HYA
09:44:58.96
-24:01:15.7
343.49
<9.3-14.4>
29
fading
Z VEL
09:52:54.28
-54:10:47.8
411.4
<9.0-14.3>
7
rising
RV CAR
09:58:20.86
-63:53:51.6
365.68
<11.3-16.2>
21
fading
CAR
10:13:54.61
-58:51:08.4
384.01
<10.7-15.2>
4
rising
RZ CAR
10:35:37.25
-70:43:00.1
272.77
<10.0-15.4>
15
min(7)
RS HYA
10:51:19.05
-28:37:41.3
338.6
<10.0-14.1>
31
min(15)
T VIR
12:14:36.67
-06:02:08.7
339.47
<9.6-14.2>
24
fading
RV VIR
13:07:55.39
-13:09:58.8
265.87
<10.8-14.9>
26
fading
RX CEN
13:51:25.44
-36:56:37.7
327.9
<9.4>-(15.0
12
min(6)
Z BOO
14:06:29.54
+13:29:05.7
281.14
<9.3-14.8>
107
rising
Y LIB
15:11:41.3
-06:00:41.3
275.7
<8.6-14.1>
46
min(16)
U LIB
15:42:03.11
-21:10:50.5
226.59
<9.6-14.4>
30
min(5)
R LIB
15:53:36.03
-16:14:11.3
241.85
<10.3-14.8>
32
rising
R HER
16:06:11.7
+18:22:13.2
318.14
<8.8-14.6>
85
min(4)
W SCO
16:11:45.78
-20:08:13.4
221.27
<11.5-14.6>
26
min(2)
S SCO
16:17:40.2
-22:53:35.8
177.92
<10.5-14.6>
50
fading
W OPH
16:21:24.46
-07:42:00.2
332.68
<9.9-14.5>
26
rising
Y SCO
16:29:26.42
-19:20:50.7
351.88
<11.3-15.0>
18
risin
RR OPH
16:49:02.46
-19:27:52.3
292.03
<8.9-14.6>
23
fading
RT SCO
17:03:32.56
-36:55:13.6
449.04
<8.2>-14.6
29
fading
RW SCO
17:14:51.67
-33:25:54.5
388.45
<9.6>-15.0
24
min(3)
RU OPH
17:32:52.63
+09:25:24.8
202.29
<9.3-13.8>
65
rising
W PAV
17:50:26.94
-62:24:33
283.35
<9.0-14.1>
14
rising
RT OPH
17:56:32.04
+11:10:10
426.34
<9.6-15.1>
59
fading
TV HER
18:14:40.55
+31:49:09.5
304.28
<9.7-14.5>
104
min(13)
RZ HER
18:36:47.01
+26:02:57.3
329.05
<9.5-14.9>
26
rising
RT LYR
19:01:14.88
+37:31:19.9
253.7
<10.1-14.6>
95
rising
ST SGR
19:01:29.22
-12:45:33.9
395.12
<9.0-15.2>
46
fading
U DRA
19:10:00.64
+67:16:36.5
316.13
<9.5-13.8>
48
fading
RU LYR
19:12:21.24
+41:18:13.5
371.84
<10.6-15.1>
26
fading
RS LYR
19:13:01.32
+33:24:49.1
301.41
<10.2-15.0>
55
min(21)
S SGR
19:19:25.91
-19:01:24.4
230.64
<10.2-14.8>
38
rising
TU CYG
19:46:10.67
+49:04:24.4
219.44
<9.4-14.2>
175
rising
X AQL
19:51:29.8
+04:27:51.6
347.04
<8.9-14.9>
28
rising
RU AQL
20:12:44.82
+12:59:41.2
274.24
<9.4-14.0>
24
min(9)
W CAP
20:14:29
-21:58:45
209.67
<11.7-14.8>
10
rising
Y DEL
20:41:38.99
+11:52:38.4
468.4
<9.9-14.0>
47
fading
T DEL
20:45:21.04
+16:23:55.8
332.02
<9.3-14.8>
185
fading
W AQR
20:46:25.01
-04:05:00.3
381.1
<8.9-14.2>
97
fading
V DEL
20:47:46.06
+19:20:06.2
533
<10.1-15.5>
59
fading
U CAP
20:48:08.59
-14:47:00.9
203.14
<11.1-14.8>
7
rising
X DEL
20:54:54.13
+17:38:29.9
281.04
<9.0-14.1>
115
rising
UX CYG
20:55:05.51
+30:24:52
565
<9.7-14.7>
45
fading
X CEP
20:56:09.39
+83:03:26.2
535.19
<9.4-15.7>
42
fading
S IND
20:56:23.27
-54:19:26.7
399.95
<8.2-15>
22
fading
X CAP
21:08:33.01
-21:20:51.7
217.94
<11.1-14.8>
7
min(2)
Z CAP
21:10:37.51
-16:10:25.2
181.48
<9.5-14.0>
40
min(7)
R EQU
21:13:11.49
+12:48:06.1
260.76
<9.3-14.5>
59
rising
RR PEG
21:44:30.59
+25:00:26.3
264.05
<9.2-14.1>
69
fading
Z CAS
23:44:31.54
+56:34:52.3
495.71
<10.0-14.7>
80
fading
I looked at the .csv file with a text editor, and all the RAs have one digit to the right of the decimal point, so the truncation happens when the .csv file is created.
Looks like the .csv RAs are in the Excel "Custom" format of mm:ss.0. The RA cells are default-formatted to that format by Excel, so R And's RA (wink wink, nudge nudge) is displayed as 24:01.9. To get the RA displayed normally, the cell format must be set to a "Custom" format you create (isn't this fun?). Use the mm:ss.0 format already in the Custom format list as a base and change it to hh:mm:ss.0.
If you can get two digits to the right of the decimal point in the .csv file, then just change the Custom format in Excel to hh:mm:ss.00 and Bob's your uncle. Even better is if you can create the .csv file with the RAs already in the hh:mm:ss.00 format.
Thom
The same problem appears in the .csv files that are generated by the basic observation planner. I sent a message about it last week via the feedback page but I don't know if it ever got to someone. I was going to follow up after everyone returned from the meeting.
...Tim
Hi Tim,
If you're able to, please try making a .csv file with the Basic Observation Planner, but open it with a text editor like notepad before you open it with Excel. My strong suspicion is that you'll see it properly formatted in the .csv file before Excel gets ahold of it, and that this is a "feature" of Excel rather than a bug in the observation planner. I just created a .csv file and opened it with OpenOffice without any problem.
I'm technically on vacation at the moment, but I'll see if I can figure out a fast workaround for Excel that won't break it in other programs.
Matthew
Matt,
The files now generated by the observation planner format the RA correctly if the column is formatted to Excel custom format h:mm:ss. However, I wasn't able to pull the same trick for Mike's files above.
Thanks for putting a fix in so fast.
...Tim