-
Notifications
You must be signed in to change notification settings - Fork 5
/
MISC.rake
558 lines (441 loc) · 39.6 KB
/
MISC.rake
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
#MISC DATA DOWNLOADS
###*******************************************************************
###NOTES BOX
#uic_upd works and is complete
#misc_const_upd_q works and is complete
#misc_const_upd_m works and is complete
###*******************************************************************
task :uic_upd => :environment do
t= Time.now
uic = {
"UICININS@HONO.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 2, :frequency => "W" })/1000|,
"UICININS@KANE.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 3, :frequency => "W" })/1000|,
"UICININS@WPHU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 4, :frequency => "W" })/1000|,
"UICININS@HON.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 5, :frequency => "W" })/1000|,
"UICININS@HILO.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 6, :frequency => "W" })/1000|,
"UICININS@KONA.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 7, :frequency => "W" })/1000|,
"UICININS@HAW.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 8, :frequency => "W" })/1000|,
"UICININS@WLKU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 9, :frequency => "W" })/1000|,
"UICININS@MOLK.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 10, :frequency => "W" })/1000|,
"UICININS@MAU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 11, :frequency => "W" })/1000|,
"UICININS@KAU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 12, :frequency => "W" })/1000|,
"UICININS@OT.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 13, :frequency => "W" })/1000|,
"UICININS@HI.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "icweekly", :row => "increment:7:1", :col => 14, :frequency => "W" })/1000|,
"UICNS@HONO.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 2, :frequency => "W" })/1000|,
"UICNS@KANE.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 3, :frequency => "W" })/1000|,
"UICNS@WPHU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 4, :frequency => "W" })/1000|,
"UICNS@HON.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 5, :frequency => "W" })/1000|,
"UICNS@HILO.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 6, :frequency => "W" })/1000|,
"UICNS@KONA.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 7, :frequency => "W" })/1000|,
"UICNS@HAW.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 8, :frequency => "W" })/1000|,
"UICNS@WLKU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 9, :frequency => "W" })/1000|,
"UICNS@MOLK.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 10, :frequency => "W" })/1000|,
"UICNS@MAU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 11, :frequency => "W" })/1000|,
"UICNS@KAU.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 12, :frequency => "W" })/1000|,
"UICNS@OT.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 13, :frequency => "W" })/1000|,
"UICNS@HI.W" => %Q|Series.load_from_download( "UIC@hawaii.gov", { :file_type => "xls", :start_date => "2000-08-19", :sheet => "iwcweekly", :row => "increment:7:1", :col => 14, :frequency => "W" })/1000|
}
p = Packager.new
p.add_definitions uic
p.write_definitions_to "/Volumes/UHEROwork/data/misc/uiclaims/update/UIC_upd_NEW.xls"
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["uic_upd", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end
task :const_upd_q => :environment do
t = Time.now
const_q = {
"KNRSDNS@HON.Q" => %Q|Series.load_from_download "QSER_G@hawaii.gov", { :file_type => "xls", :start_date => "1993-01-01", :sheet => "G-25", :row => "block:6:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"KNRSDNS@HAW.Q" => %Q|Series.load_from_download "QSER_G@hawaii.gov", { :file_type => "xls", :start_date => "1993-01-01", :sheet => "G-26", :row => "block:5:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"KNRSDNS@MAU.Q" => %Q|Series.load_from_download "QSER_G@hawaii.gov", { :file_type => "xls", :start_date => "1993-01-01", :sheet => "G-27", :row => "block:5:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"KNRSDNS@KAU.Q" => %Q|Series.load_from_download "QSER_G@hawaii.gov", { :file_type => "xls", :start_date => "1993-01-01", :sheet => "G-28", :row => "block:5:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"KPGOVNS@HI.Q" => %Q|Series.load_from_download "QSER_E@hawaii.gov", { :file_type => "xls", :start_date => "1998-01-01", :sheet => "E-1", :row => "increment:39:1", :col => 7, :frequency => "Q" }|,
"KNRSDNS@HI.Q" => %Q|Series.load_from_download "QSER_E@hawaii.gov", { :file_type => "xls", :start_date => "1982-01-01", :sheet => "E-3", :row => "block:5:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"KNRSDSGFNS@HI.Q" => %Q|Series.load_from_download "QSER_E@hawaii.gov", { :file_type => "xls", :start_date => "1982-01-01", :sheet => "E-4", :row => "block:5:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"KNRSDMLTNS@HI.Q" => %Q|Series.load_from_download "QSER_E@hawaii.gov", { :file_type => "xls", :start_date => "1982-01-01", :sheet => "E-5", :row => "block:5:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"PICTSGFNS@HON.Q" => %Q|Series.load_from_download "QSER_E@hawaii.gov", { :file_type => "xls", :start_date => "1982-01-01", :sheet => "E-6", :row => "block:6:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
"PICTCONNS@HON.Q" => %Q|Series.load_from_download "QSER_E@hawaii.gov", { :file_type => "xls", :start_date => "1982-01-01", :sheet => "E-7", :row => "block:6:1:4", :col => "repeat:2:5", :frequency => "Q" }|,
}
p = Packager.new
p.add_definitions const_q
p.write_definitions_to "/Volumes/UHEROwork/data/misc/const/update/const_upd_q_NEW.xls"
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["const_upd_q", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end
task :const_upd_m => :environment do
t = Time.now
const_m = {
"KPPRVNS@HI.M" => %Q|Series.load_from_download( "CONST_HI@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:6:1", :col => 41, :frequency => "M" })/1000|,
"KPPRVRSDNS@HI.M" => %Q|Series.load_from_download( "CONST_HI@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:6:1", :col => 42, :frequency => "M" })/1000|,
"KPPRVCOMNS@HI.M" => %Q|Series.load_from_download( "CONST_HI@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:6:1", :col => 43, :frequency => "M" })/1000|,
"KPPRVADDNS@HI.M" => %Q|Series.load_from_download( "CONST_HI@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:6:1", :col => 44, :frequency => "M" })/1000|,
"KPPRVNS@HON.M" => %Q|Series.load_from_download( "CONST_HON@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 41, :frequency => "M" })/1000|,
"KPPRVRSDNS@HON.M" => %Q|Series.load_from_download( "CONST_HON@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 42, :frequency => "M" })/1000|,
"KPPRVCOMNS@HON.M" => %Q|Series.load_from_download( "CONST_HON@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 43, :frequency => "M" })/1000|,
"KPPRVADDNS@HON.M" => %Q|Series.load_from_download( "CONST_HON@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 44, :frequency => "M" })/1000|,
"KPPRVNS@HAW.M" => %Q|Series.load_from_download( "CONST_HAW@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 41, :frequency => "M" })/1000|,
"KPPRVRSDNS@HAW.M" => %Q|Series.load_from_download( "CONST_HAW@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 42, :frequency => "M" })/1000|,
"KPPRVCOMNS@HAW.M" => %Q|Series.load_from_download( "CONST_HAW@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 43, :frequency => "M" })/1000|,
"KPPRVADDNS@HAW.M" => %Q|Series.load_from_download( "CONST_HAW@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 44, :frequency => "M" })/1000|,
"KPPRVNS@MAU.M" => %Q|Series.load_from_download( "CONST_MAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 41, :frequency => "M" })/1000|,
"KPPRVRSDNS@MAU.M" => %Q|Series.load_from_download( "CONST_MAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 42, :frequency => "M" })/1000|,
"KPPRVCOMNS@MAU.M" => %Q|Series.load_from_download( "CONST_MAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 43, :frequency => "M" })/1000|,
"KPPRVADDNS@MAU.M" => %Q|Series.load_from_download( "CONST_MAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 44, :frequency => "M" })/1000|,
"KPPRVNS@KAU.M" => %Q|Series.load_from_download( "CONST_KAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 41, :frequency => "M" })/1000|,
"KPPRVRSDNS@KAU.M" => %Q|Series.load_from_download( "CONST_KAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 42, :frequency => "M" })/1000|,
"KPPRVCOMNS@KAU.M" => %Q|Series.load_from_download( "CONST_KAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 43, :frequency => "M" })/1000|,
"KPPRVADDNS@KAU.M" => %Q|Series.load_from_download( "CONST_KAU@hawaii.gov", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "sheet_num:1", :row => "increment:5:1", :col => 44, :frequency => "M" })/1000|,
"PICTSGFNS@US.M" => %Q|Series.load_from_download( "CONST_PICT@census.gov", { :file_type => "xls", :start_date => "1964-01-01", :sheet => "fixed", :row => "block:7:1:12", :col => "repeat_with_step:7:29:2", :frequency => "M" })|,
}
poil = {
"POILEIASTNS@US.M" => %Q|Series.load_from_download("STEO@eia.gov", { :file_type => "xls", :start_date => "2008-01-01", :sheet => "2tab", :row => "6", :col =>"increment:3:1", :frequency => "M"})/1|,
"POILEIAB@US.A" => %Q|Series.load_from_download("LTEO_B@eia.gov", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "sheet_num:1", :row => "66", :col =>"increment:2:1", :frequency => "A"})/1|,
# "POILEIAH@US.A" => %Q|Series.load_from_download("LTEO_H@eia.gov", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "EIA_LTEO_H", :row => "56", :col =>"increment:2:1", :frequency => "A"})/1|,
# "POILEIAL@US.A" => %Q|Series.load_from_download("LTEO_L@eia.gov", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "EIA_LTEO_L", :row => "56", :col =>"increment:2:1", :frequency => "A"})/1|,
}
#move these and remove other
# const_m_nowrite = {
# "KPPRVNRSDNS@HI.M" => %Q|"KPPRVNS@HI.M".ts - "KPPRVRSDNS@HI.M".ts|,
# "KPPRVNRSDNS@HON.M" => %Q|"KPPRVNS@HON.M".ts - "KPPRVRSDNS@HON.M".ts|,
# "KPPRVNRSDNS@HAW.M" => %Q|"KPPRVNS@HAW.M".ts - "KPPRVRSDNS@HAW.M".ts|,
# "KPPRVNRSDNS@MAU.M" => %Q|"KPPRVNS@MAU.M".ts - "KPPRVRSDNS@MAU.M".ts|,
# "KPPRVNRSDNS@KAU.M" => %Q|"KPPRVNS@KAU.M".ts - "KPPRVRSDNS@KAU.M".ts|,
# "KPPRVNS@NBI.M" => %Q|"KPPRVNS@HAW.M".ts + "KPPRVNS@MAU.M".ts + "KPPRVNS@KAU.M".ts|,
# "KPPRVRSDNS@NBI.M" => %Q|"KPPRVRSDNS@HAW.M".ts + "KPPRVRSDNS@MAU.M".ts + "KPPRVRSDNS@KAU.M".ts|,
# "KPPRVCOMNS@NBI.M" => %Q|"KPPRVCOMNS@HAW.M".ts + "KPPRVCOMNS@MAU.M".ts + "KPPRVCOMNS@KAU.M".ts|,
# "KPPRVADDNS@NBI.M" => %Q|"KPPRVADDNS@HAW.M".ts + "KPPRVADDNS@MAU.M".ts + "KPPRVADDNS@KAU.M".ts|,
# "KPPRVNRSDNS@NBI.M" => %Q|"KPPRVNRSDNS@HAW.M".ts + "KPPRVNRSDNS@MAU.M".ts + "KPPRVNRSDNS@KAU.M".ts|
#
#
# }
p = Packager.new
p.add_definitions const_m
p.write_definitions_to "/Volumes/UHEROwork/data/misc/const/update/const_upd_m_NEW.xls"
p = Packager.new
p.add_definitions poil
p.write_definitions_to "/Volumes/UHEROwork/data/misc/const/update/poil.xls"
# p = Packager.new
# p.add_definitions const_m_nowrite
# p.write_definitions_to "/Volumes/UHEROwork/data/rawdata/trash/const_upd_m_ID.xls"
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["const_upd_m", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end
task :const_identities => :environment do
t= Time.now
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/Manual/census_imp.xls"
#not sure if these should go in misc or what...
#Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/Manual/AltUnemplStats.xls"
#Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/Manual/AltUnemplStats.xls", "Q"
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/Manual/AltURA.xls"
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/Manual/AltURQ.xls"
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/History/prud_upd.xls"
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/Manual/hbr_upd_m.csv"
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/Manual/hud_upd.xls"
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/manual/HAWpermits.xls"
# ["KPPRVNS", "KPPRVRSDNS"].each do |s_name|
# "#{s_name}@HI.M".ts_eval= %Q|("#{s_name}@HAW.M".ts + "#{s_name}@MAU.M".ts + "#{s_name}@KAU.M".ts + "#{s_name}@HON.M".ts).trim("2012-04-01")|
# end
["KPPRVRSDNS"].each do |s_name|
"#{s_name}@HI.M".ts_eval= %Q|("#{s_name}@HAW.M".ts + "#{s_name}@MAU.M".ts + "#{s_name}@KAU.M".ts + "#{s_name}@HON.M".ts).trim("2012-04-01")|
end
["KPPRVCOMNS", "KPPRVADDNS"].each do |s_name|
"#{s_name}@HI.M".ts_eval= %Q|("#{s_name}@HAW.M".ts + "#{s_name}@MAU.M".ts + "#{s_name}@HON.M".ts).trim("2012-04-01")|
end
"KPPRVNRSDNS@HI.M".ts_eval= %Q|"KPPRVNS@HI.M".ts - "KPPRVRSDNS@HI.M".ts|
"KPPRVNRSDNS@HON.M".ts_eval= %Q|"KPPRVNS@HON.M".ts - "KPPRVRSDNS@HON.M".ts|
"KPPRVNRSDNS@HAW.M".ts_eval= %Q|"KPPRVNS@HAW.M".ts - "KPPRVRSDNS@HAW.M".ts|
"KPPRVNRSDNS@MAU.M".ts_eval= %Q|"KPPRVNS@MAU.M".ts - "KPPRVRSDNS@MAU.M".ts|
"KPPRVNRSDNS@KAU.M".ts_eval= %Q|"KPPRVNS@KAU.M".ts - "KPPRVRSDNS@KAU.M".ts|
"KPPRVNS@NBI.M".ts_eval= %Q|"KPPRVNS@HAW.M".ts + "KPPRVNS@MAU.M".ts + "KPPRVNS@KAU.M".ts|
"KPPRVRSDNS@NBI.M".ts_eval= %Q|"KPPRVRSDNS@HAW.M".ts + "KPPRVRSDNS@MAU.M".ts + "KPPRVRSDNS@KAU.M".ts|
#"KPPRVCOMNS@NBI.M".ts_eval= %Q|"KPPRVCOMNS@HAW.M".ts + "KPPRVCOMNS@MAU.M".ts + "KPPRVCOMNS@KAU.M".ts|
#"KPPRVADDNS@NBI.M".ts_eval= %Q|"KPPRVADDNS@HAW.M".ts + "KPPRVADDNS@MAU.M".ts + "KPPRVADDNS@KAU.M".ts|
"KPPRVADDNS@NBI.M".ts_eval= %Q|("KPPRVADDNS@HAW.M".ts + "KPPRVADDNS@MAU.M".ts).zero_add "KPPRVADDNS@KAU.M".ts|
"KPPRVCOMNS@NBI.M".ts_eval= %Q|("KPPRVCOMNS@HAW.M".ts + "KPPRVCOMNS@MAU.M".ts).zero_add "KPPRVCOMNS@KAU.M".ts|
"KPPRVNRSDNS@NBI.M".ts_eval= %Q|"KPPRVNRSDNS@HAW.M".ts + "KPPRVNRSDNS@MAU.M".ts + "KPPRVNRSDNS@KAU.M".ts|
"NRCNM@HI.A".ts_eval = %Q|"NR@HI.A".ts - "NRM@HI.A".ts - "NRCMD@HI.A".ts| #replaces the census data completely
"NRC@HI.A".ts_eval = %Q|"NR@HI.A".ts - "NRM@HI.A".ts|
"NBIRCNM@HI.A".ts_eval = %Q|"NBIR@HI.A".ts - "NBIRCMD@HI.A".ts|
"NDEACNM@HI.A".ts_eval= %Q|"NDEA@HI.A".ts - "NDEAM@HI.A".ts - "NDEACMD@HI.A".ts|
"NMIGCNM@HI.A".ts_eval = %Q|"NRCNM@HI.A".ts.absolute_change - "NBIRCNM@HI.A".ts + "NDEACNM@HI.A".ts|
"NRC@HON.A".ts_eval = %Q|"NR@HON.A".ts - "NRM@HI.A".ts|
"NRCNM@HON.A".ts_eval = %Q|"NR@HON.A".ts - "NRM@HI.A".ts - "NRCMD@HI.A".ts|
"NR@NBI.A".ts_eval = %Q|"NR@HI.A".ts - "NR@HON.A".ts|
"NRC@NBI.A".ts_eval = %Q|"NRC@HI.A".ts - "NRC@HON.A".ts|
"NRCNM@NBI.A".ts_eval = %Q|"NRCNM@HI.A".ts - "NRCNM@HON.A".ts|
"NRBEA@NBI.A".ts_eval = %Q|"NRBEA@HI.A".ts - "NRBEA@HON.A".ts|
["HI", "HON", "HAW", "MAU", "KAU"].each do |cnty|
"NMIG@#{cnty}.A".ts_eval= %Q|"NR@#{cnty}.A".ts.absolute_change - "NBIR@#{cnty}.A".ts + "NDEA@#{cnty}.A".ts|
"NBIRR@#{cnty}.A".ts_eval = %Q|"NBIR@#{cnty}.A".ts / "NR@#{cnty}.A".ts * 1000|
"NDEAR@#{cnty}.A".ts_eval = %Q|"NDEA@#{cnty}.A".ts / "NR@#{cnty}.A".ts * 1000|
"NMIGR@#{cnty}.A".ts_eval = %Q|"NMIG@#{cnty}.A".ts / "NR@#{cnty}.A".ts * 1000|
end
"NBIRRCMD@HI.A".ts_eval = %Q|"NBIRCMD@HI.A".ts / "NRCMD@HI.A".ts * 1000|
"NBIRRCNM@HI.A".ts_eval = %Q|"NBIRCNM@HI.A".ts / "NRCNM@HI.A".ts * 1000|
"NDEARCNM@HI.A".ts_eval = %Q|"NDEACNM@HI.A".ts / "NRCNM@HI.A".ts * 1000|
"NDEARM@HI.A".ts_eval = %Q|"NDEAM@HI.A".ts / "NRM@HI.A".ts * 1000|
"NDEARCMD@HI.A".ts_eval = %Q|"NDEACMD@HI.A".ts / "NRCMD@HI.A".ts * 1000|
"NMIGRCNM@HI.A".ts_eval = %Q|"NMIGCNM@HI.A".ts / "NRCNM@HI.A".ts * 1000|
["HI", "HON", "HAW", "MAU", "KAU"].each do |county|
"NNAT@#{county}.A".ts_eval = %Q|"NBIR@#{county}.A".ts - "NDEA@#{county}.A".ts|
"NCHG@#{county}.A".ts_eval = %Q|"NNAT@#{county}.A".ts + "NMIG@#{county}.A".ts|
end
["NR", "NDF"].each do |pre|
("#{pre}@HI.Q".ts_eval= %Q|"#{pre}@HI.A".ts.census_interpolate(:quarter)|) rescue puts "ERROR HI"
("#{pre}@HAW.Q".ts_eval= %Q|"#{pre}@HAW.A".ts.census_interpolate(:quarter)|) rescue puts "ERROR HAW"
("#{pre}@KAU.Q".ts_eval= %Q|"#{pre}@KAU.A".ts.census_interpolate(:quarter)|) rescue puts "ERROR MAU"
("#{pre}@MAU.Q".ts_eval= %Q|"#{pre}@MAU.A".ts.census_interpolate(:quarter)|) rescue puts "ERROR KAU"
end
"NR@NBI.Q".ts_eval= %Q|"NR@HI.Q".ts - "NR@HON.Q".ts|
"NRC@NBI.Q".ts_eval= %Q|"NRC@HI.Q".ts - "NRC@HON.Q".ts|
"NRCNM@NBI.Q".ts_eval= %Q|"NRCNM@HI.Q".ts - "NRCNM@HON.Q".ts|
"NRCMD@HI.Q".ts_eval= %Q|"NRCMD@HI.A".ts.census_interpolate(:quarter)|
"NRM@HI.Q".ts_eval= %Q|"NRM@HI.A".ts.census_interpolate(:quarter)|
"NRM@KAU.Q".ts_eval= %Q|"NRM@KAU.A".ts.census_interpolate(:quarter)|
"NBIRCMD@HI.Q".ts_eval= %Q|("NBIRCMD@HI.A".ts / 4).census_interpolate(:quarter)|
"NDEAM@HI.Q".ts_eval= %Q|("NDEAM@HI.A".ts / 4).census_interpolate(:quarter)|
"NDEACMD@HI.Q".ts_eval= %Q|("NDEACMD@HI.A".ts / 4).census_interpolate(:quarter)|
"NBIR@HI.Q".ts_eval= %Q|("NBIR@HI.A".ts / 4).census_interpolate(:quarter)|
"NBIR@HAW.Q".ts_eval= %Q|("NBIR@HAW.A".ts / 4).census_interpolate(:quarter)|
"NBIR@KAU.Q".ts_eval= %Q|("NBIR@KAU.A".ts / 4).census_interpolate(:quarter)|
"NBIR@MAU.Q".ts_eval= %Q|("NBIR@MAU.A".ts / 4).census_interpolate(:quarter)|
"NDEA@HI.Q".ts_eval= %Q|("NDEA@HI.A".ts / 4).census_interpolate(:quarter)|
"NDEA@HAW.Q".ts_eval= %Q|("NDEA@HAW.A".ts / 4).census_interpolate(:quarter)|
"NDEA@KAU.Q".ts_eval= %Q|("NDEA@KAU.A".ts / 4).census_interpolate(:quarter)|
"NDEA@MAU.Q".ts_eval= %Q|("NDEA@MAU.A".ts / 4).census_interpolate(:quarter)|
"NRBEA@NBI.Q".ts_eval= %Q|("NRBEA@NBI.A".ts / 4).census_interpolate(:quarter)|
["NR", "NBIR", "NDEA", "NDF"].each do |pre|
"#{pre}@HON.Q".ts_eval = %Q|"#{pre}@HI.Q".ts - ("#{pre}@HAW.Q".ts + "#{pre}@MAU.Q".ts + "#{pre}@KAU.Q".ts)|
end
"NRCNM@HI.Q".ts_eval = %Q|"NR@HI.Q".ts - "NRM@HI.Q".ts - "NRCMD@HI.Q".ts| #replaces the census data completely
"NRC@HI.Q".ts_eval = %Q|"NR@HI.Q".ts - "NRM@HI.Q".ts|
"NBIRCNM@HI.Q".ts_eval = %Q|"NBIR@HI.Q".ts - "NBIRCMD@HI.Q".ts|
"NDEACNM@HI.Q".ts_eval= %Q|"NDEA@HI.Q".ts - "NDEAM@HI.Q".ts - "NDEACMD@HI.Q".ts|
"NMIGCNM@HI.Q".ts_eval = %Q|"NRCNM@HI.Q".ts.absolute_change - "NBIRCNM@HI.Q".ts + "NDEACNM@HI.Q".ts|
"NRC@HON.Q".ts_eval = %Q|"NR@HON.Q".ts - "NRM@HI.Q".ts|
"NRCNM@HON.Q".ts_eval = %Q|"NR@HON.Q".ts - "NRM@HI.Q".ts - "NRCMD@HI.Q".ts|
"NR@NBI.Q".ts_eval = %Q|"NR@HI.Q".ts - "NR@HON.Q".ts|
"NRC@NBI.Q".ts_eval = %Q|"NRC@HI.Q".ts - "NRC@HON.Q".ts|
"NRCNM@NBI.Q".ts_eval = %Q|"NRCNM@HI.Q".ts - "NRCNM@HON.Q".ts|
["HI", "HON", "HAW", "MAU", "KAU"].each do |cnty|
"NMIG@#{cnty}.Q".ts_eval= %Q|"NR@#{cnty}.Q".ts.absolute_change - "NBIR@#{cnty}.Q".ts + "NDEA@#{cnty}.Q".ts|
"NBIRR@#{cnty}.Q".ts_eval = %Q|"NBIR@#{cnty}.Q".ts / "NR@#{cnty}.Q".ts * 1000|
"NDEAR@#{cnty}.Q".ts_eval = %Q|"NDEA@#{cnty}.Q".ts / "NR@#{cnty}.Q".ts * 1000|
"NMIGR@#{cnty}.Q".ts_eval = %Q|"NMIG@#{cnty}.Q".ts / "NR@#{cnty}.Q".ts * 1000|
"NNAT@#{cnty}.Q".ts_eval = %Q|"NBIR@#{cnty}.Q".ts - "NDEA@#{cnty}.Q".ts|
"NCHG@#{cnty}.Q".ts_eval = %Q|"NNAT@#{cnty}.Q".ts + "NMIG@#{cnty}.Q".ts|
end
"NBIRRCMD@HI.Q".ts_eval = %Q|"NBIRCMD@HI.Q".ts / "NRCMD@HI.Q".ts * 1000|
"NBIRRCNM@HI.Q".ts_eval = %Q|"NBIRCNM@HI.Q".ts / "NRCNM@HI.Q".ts * 1000|
"NDEARCNM@HI.Q".ts_eval = %Q|"NDEACNM@HI.Q".ts / "NRCNM@HI.Q".ts * 1000|
"NDEARM@HI.Q".ts_eval = %Q|"NDEAM@HI.Q".ts / "NRM@HI.Q".ts * 1000|
"NDEARCMD@HI.Q".ts_eval = %Q|"NDEACMD@HI.Q".ts / "NRCMD@HI.Q".ts * 1000|
"NMIGRCNM@HI.Q".ts_eval = %Q|"NMIGCNM@HI.Q".ts / "NRCNM@HI.Q".ts * 1000|
#works for HON, but other counties are not defined
["HON", "HAW", "MAU", "KAU"].each do |cnty|
"SH_NR@#{cnty}.A".ts_eval = %Q|"NR@#{cnty}.A".ts / "NR@HI.A".ts|
"SH_NR@#{cnty}.Q".ts_eval = %Q|"NR@#{cnty}.Q".ts / "NR@HI.Q".ts|
end
["HON"].each do |cnty|
"SH_NRCNM@#{cnty}.A".ts_eval = %Q|"NRCNM@#{cnty}.A".ts / "NRCNM@HI.A".ts|
"SH_NRCNM@#{cnty}.Q".ts_eval = %Q|"NRCNM@#{cnty}.Q".ts / "NRCNM@HI.Q".ts|
end
["HAW", "MAU", "KAU"].each do |cnty|
"SH_NRCNM@#{cnty}.A".ts_eval = %Q|"NR@#{cnty}.A".ts / "NRCNM@HI.A".ts|
"SH_NRCNM@#{cnty}.Q".ts_eval = %Q|"NR@#{cnty}.Q".ts / "NRCNM@HI.Q".ts|
end
"SH_MD@HI.A".ts_eval = %Q|"NRCMD@HI.A".ts / "NRM@HI.A".ts|
"SH_MD@HI.Q".ts_eval= %Q| "NRCMD@HI.Q".ts / "NRM@HI.Q".ts |
#PRUD identities included here
"PAKRCON@HAW.Q".ts_eval= %Q|"PAKRCONNS@HAW.Q".ts|
"PAKRCON@HON.Q".ts_eval= %Q|"PAKRCONNS@HON.Q".ts|
"PAKRCON@KAU.Q".ts_eval= %Q|"PAKRCONNS@KAU.Q".ts|
"PAKRCON@MAU.Q".ts_eval= %Q|"PAKRCONNS@MAU.Q".ts|
"PAKRSGF@HAW.Q".ts_eval= %Q|"PAKRSGFNS@HAW.Q".ts|
"PAKRSGF@HON.Q".ts_eval= %Q|"PAKRSGFNS@HON.Q".ts|
"PAKRSGF@KAU.Q".ts_eval= %Q|"PAKRSGFNS@KAU.Q".ts|
"PAKRSGF@MAU.Q".ts_eval= %Q|"PAKRSGFNS@MAU.Q".ts|
["KRSGFNS", "KRCONNS"].each do |s_name|
["HON", "HAW", "MAU", "KAU"].each do |county|
"#{s_name}_NMC@#{county}.Q".ts_append_eval %Q|"#{s_name}@#{county}.Q".ts.load_from "/Volumes/UHEROwork/data/rawdata/History/prud_upd.xls"|
# "#{s_name}_NMC@#{county}.Q".ts_append_eval %Q|"#{s_name}@#{county}.Q".ts.load_from "/Volumes/UHEROwork/data/misc/prud/update/prud_upd.xls"|
end
end
["KRSGFNS", "KRCONNS"].each do |s_name|
["HAW", "MAU", "KAU"].each do |county|
"#{s_name}@#{county}.Q".ts_eval= %Q|"#{s_name}@HI.Q".ts.share_using("#{s_name}_NMC@#{county}.Q".ts, "#{s_name}_NMC@HON.Q".ts + "#{s_name}_NMC@HAW.Q".ts + "#{s_name}_NMC@MAU.Q".ts + "#{s_name}_NMC@KAU.Q".ts).round|
end
"#{s_name}_SHARED@HON.Q".ts_eval= %Q|"#{s_name}@HI.Q".ts.share_using("#{s_name}_NMC@HON.Q".ts, "#{s_name}_NMC@HON.Q".ts + "#{s_name}_NMC@HAW.Q".ts + "#{s_name}_NMC@MAU.Q".ts + "#{s_name}_NMC@KAU.Q".ts).round|
end
["KRSGFNS", "KRCONNS"].each do |s_name|
"#{s_name}_SUM@HI.Q".ts_eval= %Q|"#{s_name}_SHARED@HON.Q".ts + "#{s_name}@MAU.Q".ts + "#{s_name}@KAU.Q".ts + "#{s_name}@HAW.Q".ts|
"#{s_name}_ERR@HI.Q".ts_eval= %Q|"#{s_name}@HI.Q".ts - "#{s_name}_SUM@HI.Q".ts|
["HAW", "MAU", "KAU"].each do |cnty|
"#{s_name}_TEMP@#{cnty}.Q".ts_eval= %Q|("#{s_name}@#{cnty}.Q".ts + ("#{s_name}@#{cnty}.Q".ts/"#{s_name}_SUM@HI.Q".ts)*"#{s_name}_ERR@HI.Q".ts).round|
end
"#{s_name}_TEMP@HON.Q".ts_eval= %Q|("#{s_name}_SHARED@HON.Q".ts + ("#{s_name}_SHARED@HON.Q".ts/"#{s_name}_SUM@HI.Q".ts)*"#{s_name}_ERR@HI.Q".ts).round|
"#{s_name}_NEWERR@HI.Q".ts_eval= %Q|"#{s_name}@HI.Q".ts - ("#{s_name}_TEMP@HON.Q".ts + "#{s_name}_TEMP@HAW.Q".ts + "#{s_name}_TEMP@MAU.Q".ts + "#{s_name}_TEMP@KAU.Q".ts)|
"#{s_name}@HON.Q".ts_eval= %Q|"#{s_name}_TEMP@HON.Q".ts + "#{s_name}_NEWERR@HI.Q".ts|
end
#maybe the line below is already handled in a historical load...
"KBCONNS@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/manual/hbr_upd_m.csv"
"KBCON@HON.M".ts_eval= %Q|"KBCON@HON.M".tsn.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/hbr/seasadj/sadata.xls"|
"KBCON@HON.M".ts_eval= %Q|"KBCON@HON.M".ts.apply_seasonal_adjustment :multiplicative|
"KBSGFNS@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/manual/hbr_upd_m.csv"
"KBSGF@HON.M".ts_eval= %Q|"KBSGF@HON.M".tsn.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/hbr/seasadj/sadata.xls"|
"KBSGF@HON.M".ts_eval= %Q|"KBSGF@HON.M".ts.apply_seasonal_adjustment :multiplicative|
"KBCONNS@MAU.M".ts_eval= %Q|"KBCONNS@MAU.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/manual/mbr_upd_m.csv"|
"KBCON@MAU.M".ts_eval= %Q|"KBCON@MAU.M".tsn.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/hbr/seasadj/mbr_sa.xls"|
"KBCON@MAU.M".ts_eval= %Q|"KBCON@MAU.M".ts.apply_seasonal_adjustment :multiplicative|
"KBSGFNS@MAU.M".ts_eval= %Q|"KBSGFNS@MAU.M".tsn.load_from " /Volumes/UHEROwork/data/rawdata/manual/mbr_upd_m.csv"|
"KBSGF@MAU.M".ts_eval= %Q|"KBSGF@MAU.M".tsn.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/hbr/seasadj/mbr_sa.xls"|
"KBSGF@MAU.M".ts_eval= %Q|"KBSGF@MAU.M".ts.apply_seasonal_adjustment :multiplicative|
"KB@HON.M".ts_eval= %Q|Series.add_demetra_series_and_mean_correct("KBSGF@HON.M", "KBCON@HON.M", "KBNS@HON.M", "/Volumes/UHEROwork/data/misc/hbr/seasadj/sadata.xls")|
"KB@MAU.M".ts_eval= %Q|Series.add_demetra_series_and_mean_correct("KBSGF@MAU.M", "KBCON@MAU.M", "KBNS@MAU.M", "/Volumes/UHEROwork/data/misc/hbr/seasadj/mbr_sa.xls")|
"KB@MAU.Q".ts_eval= %Q|"KB@MAU.M".ts.aggregate(:quarter, :sum)|
"KB@HON.Q".ts_eval= %Q|"KB@HON.M".ts.aggregate(:quarter, :sum)|
"KB@MAU.A".ts_eval= %Q|"KB@MAU.M".ts.aggregate(:year, :sum)|
"KB@HON.A".ts_eval= %Q|"KB@HON.M".ts.aggregate(:year, :sum)|
["HON", "MAU"].each do |cnty|
["Q", "M"].each do |f|
"KBNS@#{cnty}.#{f}".ts_eval = %Q|"KBSGFNS@#{cnty}.#{f}".ts + "KBCONNS@#{cnty}.#{f}".ts|
end
end
"PMKBSGF@HON.M".ts_eval= %Q|"PMKBSGF@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/manual/hbr_upd_m.csv"|
"PMKBCON@HON.M".ts_eval= %Q|"PMKBCON@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/manual/hbr_upd_m.csv"|
"PMKBSGF@MAU.M".ts_eval= %Q|"PMKBSGF@MAU.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/manual/mbr_upd_m.csv"|
"PMKBCON@MAU.M".ts_eval= %Q|"PMKBCON@MAU.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/manual/mbr_upd_m.csv"|
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/History/hbr_histQ.xls"
"PMKBSGF@HON.Q".ts_eval= %Q|"PMKBSGF@HON.M".ts.aggregate(:quarter, :average)|
"PMKBCON@HON.Q".ts_eval= %Q|"PMKBCON@HON.M".ts.aggregate(:quarter, :average)|
# Not sure why these were even here. Just circular references
# "PMKBSGF@HON.Q".ts_eval= %Q|"PMKBSGF@HON.Q".ts.trim("1980-01-01","1986-12-01")|
# "PMKBCON@HON.Q".ts_eval= %Q|"PMKBCON@HON.Q".ts.trim("1980-01-01","1986-12-01")|
"PMKRCON@HON.Q".ts_eval=%Q|"PMKRCON@HON.Q".ts.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/prud/seasadj/prud_sa.xls", "prud_sa" |
"PMKRSGF@HON.Q".ts_eval=%Q|"PMKRSGF@HON.Q".ts.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/prud/seasadj/prud_sa.xls", "prud_sa" |
["HI", "HAW", "KAU", "MAU"].each do |cnty|
"PMKRSGF@#{cnty}.Q".ts_eval= %Q|"PMKRSGF@HON.Q".ts.mc_price_share_for("#{cnty}")|
"PMKRCON@#{cnty}.Q".ts_eval= %Q|"PMKRCON@HON.Q".ts.mc_price_share_for("#{cnty}") |
end
"KRCON@HI.Q".ts_eval=%Q|"KRCON@HI.Q".tsn.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/prud/seasadj/prud_sa.xls", "prud_sa" |
"KRSGF@HI.Q".ts_eval=%Q|"KRSGF@HI.Q".tsn.load_mean_corrected_sa_from "/Volumes/UHEROwork/data/misc/prud/seasadj/prud_sa.xls", "prud_sa" |
["HON", "HAW", "KAU", "MAU"].each do |cnty|
"KRCON@#{cnty}.Q".ts_eval= %Q|"KRCON@HI.Q".ts.mc_price_share_for("#{cnty}")|
"KRSGF@#{cnty}.Q".ts_eval= %Q|"KRSGF@HI.Q".ts.mc_price_share_for("#{cnty}")|
end
["HI","HAW", "KAU","HON", "MAU"].each do |cnty|
"KRNS@#{cnty}.Q".ts_eval = %Q|"KRSGFNS@#{cnty}.Q".ts + "KRCONNS@#{cnty}.Q".ts|
"KR@#{cnty}.Q".ts_eval = %Q|"KRSGF@#{cnty}.Q".ts + "KRCON@#{cnty}.Q".ts|
"KR@#{cnty}.A".ts_eval = %Q|"KRSGF@#{cnty}.A".ts + "KRCON@#{cnty}.A".ts|
end
"PMKRCON@HON.Q".ts_eval= %Q| "PMKRCON@HON.Q".ts.apply_seasonal_adjustment :multiplicative |
"KRCON@HI.Q".ts_eval= %Q| "KRCON@HI.Q".ts.apply_seasonal_adjustment :multiplicative|
"KRSGF@HI.Q".ts_eval= %Q| "KRSGF@HI.Q".ts.apply_seasonal_adjustment :multiplicative|
"PMKRSGF@HON.Q".ts_eval= %Q| "PMKRSGF@HON.Q".ts.apply_seasonal_adjustment :multiplicative |
#these don't match
"PAKRSGF@HI.Q".ts_eval= %Q|(("PAKRSGF@HON.Q".ts * "KRSGF@HON.Q".ts) + ("PAKRSGF@HAW.Q".ts * "KRSGF@HAW.Q".ts) + ("PAKRSGF@MAU.Q".ts * "KRSGF@MAU.Q".ts) + ("PAKRSGF@KAU.Q".ts * "KRSGF@KAU.Q".ts))/ "KRSGF@HI.Q".ts|
"PAKRCON@HI.Q".ts_eval= %Q|(("PAKRCON@HON.Q".ts * "KRCON@HON.Q".ts) + ("PAKRCON@HAW.Q".ts * "KRCON@HAW.Q".ts) + ("PAKRCON@MAU.Q".ts * "KRCON@MAU.Q".ts) + ("PAKRCON@KAU.Q".ts * "KRCON@KAU.Q".ts))/ "KRCON@HI.Q".ts|
#{}"PAKRSGF@HI.Q".ts_eval= %Q|(("PAKRSGF@HON.Q".ts * "KRSGF@HON.Q".ts) + ("PAKRSGF@HAW.Q".ts * "KRSGF@HAW.Q".ts) + ("PAKRSGF@MAU.Q".ts * "KRSGF@MAU.Q".ts) + ("PAKRSGF@KAU.Q".ts * "KRSGF@KAU.Q".ts))/ "KRSGF@HI.Q".ts|
#these are ok
"PAKRSGFNS@HI.Q".ts_eval= %Q|(("PAKRSGFNS@HON.Q".ts * "KRSGFNS@HON.Q".ts) + ("PAKRSGFNS@HAW.Q".ts * "KRSGFNS@HAW.Q".ts) + ("PAKRSGFNS@MAU.Q".ts * "KRSGFNS@MAU.Q".ts) + ("PAKRSGFNS@KAU.Q".ts * "KRSGFNS@KAU.Q".ts))/ "KRSGFNS@HI.Q".ts|
"PAKRCONNS@HI.Q".ts_eval= %Q|(("PAKRCONNS@HON.Q".ts * "KRCONNS@HON.Q".ts) + ("PAKRCONNS@HAW.Q".ts * "KRCONNS@HAW.Q".ts) + ("PAKRCONNS@MAU.Q".ts * "KRCONNS@MAU.Q".ts) + ("PAKRCONNS@KAU.Q".ts * "KRCONNS@KAU.Q".ts))/ "KRCONNS@HI.Q".ts|
["HI", "HON", "HAW", "KAU", "MAU"].each do |cnty|
"PMKRSGFNS@#{cnty}.A".ts_eval= %Q|"PMKRSGFNS@#{cnty}.Q".ts.aggregate(:year, :average)|
"PMKRCONNS@#{cnty}.A".ts_eval= %Q|"PMKRCONNS@#{cnty}.Q".ts.aggregate(:year, :average)|
end
["HI","HON","HAW","MAU","KAU"].each do |cnty|
"PAKR@#{cnty}.Q".ts_eval= %Q|("PAKRSGF@#{cnty}.Q".ts * "KRSGF@#{cnty}.Q".ts + "PAKRCON@#{cnty}.Q".ts * "KRCON@#{cnty}.Q".ts) / "KR@#{cnty}.Q".ts|
"PMKR@#{cnty}.Q".ts_eval= %Q|("PMKRSGF@#{cnty}.Q".ts * "KRSGF@#{cnty}.Q".ts + "PMKRCON@#{cnty}.Q".ts * "KRCON@#{cnty}.Q".ts) / "KR@#{cnty}.Q".ts|
"PAKR@#{cnty}.A".ts_eval= %Q|("PAKR@#{cnty}.Q".ts * "KR@#{cnty}.Q".ts).aggregate(:year, :sum) / "KR@#{cnty}.A".ts|
"PMKR@#{cnty}.A".ts_eval= %Q|"PMKR@#{cnty}.Q".ts.aggregate(:year, :average)|
"PAKRSGF@#{cnty}.A".ts_eval= %Q|("PAKRSGF@#{cnty}.Q".ts * "KRSGF@#{cnty}.Q".ts).aggregate(:year, :sum) / "KRSGF@#{cnty}.A".ts|
"PAKRCON@#{cnty}.A".ts_eval= %Q|("PAKRCON@#{cnty}.Q".ts * "KRCON@#{cnty}.Q".ts).aggregate(:year, :sum) / "KRCON@#{cnty}.A".ts|
"PMKRSGF@#{cnty}.A".ts_eval= %Q|"PMKRSGF@#{cnty}.Q".ts.aggregate(:year, :average)|
"PMKRCON@#{cnty}.A".ts_eval= %Q|"PMKRCON@#{cnty}.Q".ts.aggregate(:year, :average)|
end
"PMKBCONNS@HON.Q".ts_eval= %Q|"PMKBCON@HON.Q".ts.trim("1980-01-01","1986-12-01") |
"PMKBSGFNS@HON.Q".ts_eval= %Q| "PMKBSGF@HON.Q".ts.trim("1980-01-01","1986-12-01") |
"PMKBCONNS@HON.M".ts_eval= %Q|"PMKBCON@HON.M".ts|
"PMKBSGFNS@HON.M".ts_eval= %Q|"PMKBSGF@HON.M".ts|
"PMKBCONNS@MAU.M".ts_eval= %Q|"PMKBCON@MAU.M".ts|
"PMKBSGFNS@MAU.M".ts_eval= %Q|"PMKBSGF@MAU.M".ts|
"PMKBCONNS@HON.Q".ts_eval= %Q|"PMKBCON@HON.M".ts.aggregate(:quarter, :average)|
"PMKBSGFNS@HON.Q".ts_eval= %Q|"PMKBSGF@HON.M".ts.aggregate(:quarter, :average)|
"PMKBCONNS@MAU.Q".ts_eval= %Q|"PMKBCON@MAU.M".ts.aggregate(:quarter, :average)|
"PMKBSGFNS@MAU.Q".ts_eval= %Q|"PMKBSGF@MAU.M".ts.aggregate(:quarter, :average)|
"PMKBCON@HON.Q".ts_eval= %Q|"PMKBCON@HON.M".ts.aggregate(:quarter, :average)|
"PMKBSGF@HON.Q".ts_eval= %Q|"PMKBSGF@HON.M".ts.aggregate(:quarter, :average)|
"PMKBCON@MAU.Q".ts_eval= %Q|"PMKBCON@MAU.M".ts.aggregate(:quarter, :average)|
"PMKBSGF@MAU.Q".ts_eval= %Q|"PMKBSGF@MAU.M".ts.aggregate(:quarter, :average)|
"PMKBCON@HON.A".ts_eval= %Q|"PMKBCON@HON.M".ts.aggregate(:year, :average)|
"PMKBSGF@HON.A".ts_eval= %Q|"PMKBSGF@HON.M".ts.aggregate(:year, :average)|
"PMKBCON@MAU.A".ts_eval= %Q|"PMKBCON@MAU.M".ts.aggregate(:year, :average)|
"PMKBSGF@MAU.A".ts_eval= %Q|"PMKBSGF@MAU.M".ts.aggregate(:year, :average)|
#these RMORTS are from US, but that's ok
"RMORT@US.Q".ts_eval= %Q|"RMORT@US.M".ts.aggregate(:quarter, :average)|
"RMORT@US.A".ts_eval= %Q|"RMORT@US.M".ts.aggregate(:year, :average)|
#HOUSING AFFORDABILITY INDEX|
["HI", "HON", "HAW", "KAU", "MAU"].each do |cnty|
"PAFSGF@#{cnty}.A".ts_eval= %Q|"YMED@#{cnty}.A".ts/"RMORT@US.A".ts * (300/8.0) * (((("RMORT@US.A".ts/1200.0)+1)**-360)*-1+1)|
"HPMT@#{cnty}.A".ts_eval= %Q|"PMKRSGFNS@#{cnty}.A".ts * 0.8 * ("RMORT@US.A".ts/1200.0) / (((("RMORT@US.A".ts/1200.0)+1)**-360)*-1+1)|
"HYQUAL@#{cnty}.A".ts_eval= %Q|"HPMT@#{cnty}.A".ts*10/3*12.0|
"HAI@#{cnty}.A".ts_eval= %Q|"YMED@#{cnty}.A".ts / "HYQUAL@#{cnty}.A".ts*100.0|
end
#CONDO AFFORDABILITY INDEX|
["HI", "HON", "HAW", "KAU", "MAU"].each do |cnty|
"HPMTCON@#{cnty}.A".ts_eval= %Q|"PMKRCONNS@#{cnty}.A".ts*0.8*("RMORT@US.A".ts/1200.0)/(((("RMORT@US.A".ts/1200.0)+1)**-360)*-1+1)|
"HYQUALCON@#{cnty}.A".ts_eval= %Q|"HPMTCON@#{cnty}.A".ts*10/3*12.0|
"HAICON@#{cnty}.A".ts_eval= %Q|"YMED@#{cnty}.A".ts / "HYQUALCON@#{cnty}.A".ts*100.0|
end
"HPMTCON@HI.Q".ts_eval= %Q|"PMKRCON@HI.Q".ts * 0.8 * ("RMORT@US.Q".ts/1200.0)/(((("RMORT@US.Q".ts/1200.0)+1)**-360)*-1+1)|
"HPMTCON@HON.Q".ts_eval= %Q|"PMKRCON@HON.Q".ts * 0.8 * ("RMORT@US.Q".ts/1200.0)/(((("RMORT@US.Q".ts/1200.0)+1)**-360)*-1+1)|
"HPMT@HI.Q".ts_eval= %Q|"PMKRSGF@HI.Q".ts * 0.8 * ("RMORT@US.Q".ts/1200.0)/(((("RMORT@US.Q".ts/1200.0)+1)**-360)*-1+1)|
"HPMT@HON.Q".ts_eval= %Q|"PMKRSGF@HON.Q".ts * 0.8 * ("RMORT@US.Q".ts/1200.0)/(((("RMORT@US.Q".ts/1200.0)+1)**-360)*-1+1)|
"HYQUAL@HI.Q".ts_eval= %Q|"HPMT@HI.Q".ts*10/3*12.0|
"HYQUAL@HON.Q".ts_eval= %Q|"HPMT@HON.Q".ts*10/3*12.0|
"HYQUALCON@HI.Q".ts_eval= %Q|"HPMTCON@HI.Q".ts*10/3*12.0|
"HYQUALCON@HON.Q".ts_eval= %Q|"HPMTCON@HON.Q".ts*10/3*12.0|
"PICTSGF@HON.Q".ts_eval= %Q|"PICTSGFNS@HON.Q".ts|
#this may work eventually, but KPNS is not defined yet
"KPGOV@HI.Q".ts_eval= %Q|"KPGOVNS@HI.Q".ts|
"KPGOV_R@HI.A".ts_eval= %Q|"KPGOV@HI.A".ts / "PICTSGF@HON.A".ts * 100|
"KPGOV_R@HI.Q".ts_eval= %Q|"KPGOV@HI.Q".ts / "PICTSGF@HON.Q".ts * 100|
"KPNS@HI.Q".ts_eval= %Q|"KPPRV@HI.Q".ts + "KPGOV@HI.Q".ts|
"KP@HI.Q".ts_eval= %Q|"KPPRV@HI.Q".ts + "KPGOV@HI.Q".ts|
"KPNS@HI.A".ts_eval= %Q|"KPPRV@HI.A".ts + "KPGOV@HI.A".ts|
"KP@HI.A".ts_eval= %Q|"KPPRV@HI.A".ts + "KPGOV@HI.A".ts|
"KP_R@HI.A".ts_eval= %Q|"KPNS@HI.A".ts / "PICTSGF@HON.A".ts * 100|
"KP_R@HI.Q".ts_eval= %Q|"KPNS@HI.Q".ts / "PICTSGF@HON.Q".ts * 100|
#KB, KBNS, KNRSD, #KR, KRNS
["HI", "HON", "MAU", "HAW", "KAU"].each do |cnty|
"KNRSD@#{cnty}.Q".ts_eval= %Q|"KNRSDNS@#{cnty}.Q".ts|
end
"KNRSDMLT@HI.Q".ts_eval= %Q|"KNRSDMLTNS@HI.Q".ts|
"KNRSDSGF@HI.Q".ts_eval= %Q|"KNRSDSGFNS@HI.Q".ts|
["KPPRVADD","KPPRVCOM", "KPPRVNRSD", "KPPRVRSD", "KPPRV"].each do |pre|
["Q","M"].each do |f|
["HI", "HON", "MAU", "HAW", "KAU"].each do |cnty|
"#{pre}@#{cnty}.#{f}".ts_eval= %Q|"#{pre}NS@#{cnty}.#{f}".ts|
end
#some of these don't work
"#{pre}@NBI.#{f}".ts_eval= %Q|"#{pre}@HI.#{f}".ts - "#{pre}@HON.#{f}".ts|
end
end
["KPGOV", "KPPRVADD","KPPRVCOM", "KPPRVNRSD", "KPPRVRSD", "KPPRV", "KP"].each do |pre|
["HI", "HON", "MAU", "HAW", "KAU"].each do |cnty|
("#{pre}_R@#{cnty}.A".ts_eval= %Q|"#{pre}@#{cnty}.A".ts / "PICTSGF@HON.A".ts * 100|) rescue puts "_R ERROR FORM #{pre}_R@#{cnty} A"
("#{pre}_R@#{cnty}.Q".ts_eval= %Q|"#{pre}@#{cnty}.Q".ts / "PICTSGF@HON.Q".ts * 100|) rescue puts "_R ERROR FORM #{pre}_R@#{cnty} Q"
end
end
"KB@HON.M".ts_eval= %Q|"KBSGF@HON.M".ts.get_last_incomplete_year + "KBCON@HON.M".ts.get_last_incomplete_year|
"KB@MAU.M".ts_eval= %Q|"KBSGF@MAU.M".ts.get_last_incomplete_year + "KBCON@MAU.M".ts.get_last_incomplete_year|
"UICNS@HIONLY.W".ts_eval= %Q|"UICNS@HI.W".ts - "UICNS@OT.W".ts|
"UICININS@HIONLY.W".ts_eval= %Q|"UICININS@HI.W".ts - "UICININS@OT.W".ts|
["UICINI", "UIC"].each do |pre|
["HIONLY", "HI", "HON", "HONO", "KANE", "KAU", "HILO", "HAW", "MOLK", "KONA", "WLKU", "OT", "WPHU", "MAU"].each do |cnty|
("#{pre}NS@#{cnty}.M".ts_eval= %Q|"#{pre}NS@#{cnty}.W".ts.distribute_days_interpolation.aggregate(:month, :sum)|) rescue puts "ERROR FORM #{pre}@#{cnty} M"
("#{pre}NS@#{cnty}.Q".ts_eval= %Q|"#{pre}NS@#{cnty}.W".ts.distribute_days_interpolation.aggregate(:quarter, :sum)|) rescue puts "ERROR FORM #{pre}@#{cnty} Q"
("#{pre}@#{cnty}.A".ts_eval= %Q|"#{pre}NS@#{cnty}.W".ts.distribute_days_interpolation.aggregate(:year, :sum)|) rescue puts "ERROR FORM #{pre}@#{cnty} A"
end
end
"POILEIALTB@US.A".ts_eval= %Q|"POILEIALTB@US.A".tsn.load_from "/Volumes/UHEROwork/data/rawdata/Manual/EIA_LT.xls"|
"POILEIALTH@US.A".ts_eval= %Q|"POILEIALTH@US.A".tsn.load_from "/Volumes/UHEROwork/data/rawdata/Manual/EIA_LT.xls"|
"POILEIALTL@US.A".ts_eval= %Q|"POILEIALTL@US.A".tsn.load_from "/Volumes/UHEROwork/data/rawdata/Manual/EIA_LT.xls"|
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["const_identities", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end