-
Notifications
You must be signed in to change notification settings - Fork 5
/
BLS.rake
1069 lines (936 loc) · 117 KB
/
BLS.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
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
#BLS AND HIWI DATA DOWNLOADS
###*******************************************************************
###NOTES BOX
#BLS_CPI only pulling through 1986 and jumps to 1997 with one month (may be okay due to S download)
#BLS_CPI prints in a random order
#BLS_JOB_UPD_M works (have some series commented out, and need to check on the status of these)
###*******************************************************************
task :bls_cpi_upd_m => :environment do
t = Time.now
bls_cpi_m = {
"PC@HON.M" => %Q|Series.load_from_bls("CUURA426SA0", "M")|,
"PCFB@HON.M" => %Q|Series.load_from_bls("CUURA426SAF", "M")|,
"PCFBFD@HON.M" => %Q|Series.load_from_bls("CUURA426SAF1", "M")|,
"PCFBFDHM@HON.M" => %Q|Series.load_from_bls("CUURA426SAF11", "M")|,
"PCFBFDAW@HON.M" => %Q|Series.load_from_bls("CUURA426SEFV", "M")|,
"PCFBFDBV@HON.M" => %Q|Series.load_from_bls("CUURA426SAF116", "M")|,
"PCHS@HON.M" => %Q|Series.load_from_bls("CUURA426SAH", "M")|,
"PCHSSH@HON.M" => %Q|Series.load_from_bls("CUURA426SAH1", "M")|,
"PCHSSHRT@HON.M" => %Q|Series.load_from_bls("CUURA426SEHA", "M")|,
"PCHSSHOW@HON.M" => %Q|Series.load_from_bls("CUURA426SEHC", "M")|,
"PCHSFU@HON.M" => %Q|Series.load_from_bls("CUURA426SAH2", "M")|,
"PCHSFUEL@HON.M" => %Q|Series.load_from_bls("CUURA426SAH21", "M")|,
"PCHSFUGS@HON.M" => %Q|Series.load_from_bls("CUURA426SEHF", "M")|,
"PCHSFUGSE@HON.M" => %Q|Series.load_from_bls("CUURA426SEHF01", "M")|,
"PCHSFUGSU@HON.M" => %Q|Series.load_from_bls("CUURA426SEHF02", "M")|,
"PCHSHF@HON.M" => %Q|Series.load_from_bls("CUURA426SAH3", "M")|,
"PCAP@HON.M" => %Q|Series.load_from_bls("CUURA426SAA", "M")|,
"PCTR@HON.M" => %Q|Series.load_from_bls("CUURA426SAT", "M")|,
"PCTRPR@HON.M" => %Q|Series.load_from_bls("CUURA426SAT1", "M")|,
"PCTRMF@HON.M" => %Q|Series.load_from_bls("CUURA426SETB", "M")|,
"PCTRGS@HON.M" => %Q|Series.load_from_bls("CUURA426SETB01", "M")|,
"PCTRGSRG@HON.M" => %Q|Series.load_from_bls("CUURA426SS47014", "M")|,
"PCTRGSPR@HON.M" => %Q|Series.load_from_bls("CUURA426SS47016", "M")|,
"PCMD@HON.M" => %Q|Series.load_from_bls("CUURA426SAM", "M")|,
"PCRE@HON.M" => %Q|Series.load_from_bls("CUURA426SAR", "M")|,
"PCED@HON.M" => %Q|Series.load_from_bls("CUURA426SAE", "M")|,
"PCOT@HON.M" => %Q|Series.load_from_bls("CUURA426SAG", "M")|,
"PCCM@HON.M" => %Q|Series.load_from_bls("CUURA426SAC", "M")|,
"PCCM_FD@HON.M" => %Q|Series.load_from_bls("CUURA426SACL1", "M")|,
"PCCM_FB@HON.M" => %Q|Series.load_from_bls("CUURA426SACL11", "M")|,
"PCCMND@HON.M" => %Q|Series.load_from_bls("CUURA426SAN", "M")|,
"PCCMND_FD@HON.M" => %Q|Series.load_from_bls("CUURA426SANL1", "M")|,
"PCCMND_FB@HON.M" => %Q|Series.load_from_bls("CUURA426SANL11", "M")|,
"PCCMDR@HON.M" => %Q|Series.load_from_bls("CUURA426SAD", "M")|,
"PCSV@HON.M" => %Q|Series.load_from_bls("CUURA426SAS", "M")|,
"PCSV_MD@HON.M" => %Q|Series.load_from_bls("CUURA426SASL5", "M")|,
"PCSV_RN@HON.M" => %Q|Series.load_from_bls("CUURA426SASL2RS", "M")|,
"PC_MD@HON.M" => %Q|Series.load_from_bls("CUURA426SA0L5", "M")|,
"PC_EN@HON.M" => %Q|Series.load_from_bls("CUURA426SA0LE", "M")|,
"PC_FDEN@HON.M" => %Q|Series.load_from_bls("CUURA426SA0L1E", "M")|,
"PC_SH@HON.M" => %Q|Series.load_from_bls("CUURA426SA0L2", "M")|,
"PCEN@HON.M" => %Q|Series.load_from_bls("CUURA426SA0E", "M")|
}
p = Packager.new
p.add_definitions bls_cpi_m
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/bls_cpi_upd_m_NEW.xls"
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["bls_cpi_upd_m", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end
task :bls_cpi_upd_s => :environment do
t = Time.now
bls_cpi_s = {
"PC@HON.S" => %Q|Series.load_from_bls("CUUSA426SA0", "S")|,
"PCFB@HON.S" => %Q|Series.load_from_bls("CUUSA426SAF", "S")|,
"PCFBFD@HON.S" => %Q|Series.load_from_bls("CUUSA426SAF1", "S")|,
"PCFBFDHM@HON.S" => %Q|Series.load_from_bls("CUUSA426SAF11", "S")|,
"PCFBFDAW@HON.S" => %Q|Series.load_from_bls("CUUSA426SEFV", "S")|,
"PCFBFDBV@HON.S" => %Q|Series.load_from_bls("CUUSA426SAF116", "S")|,
"PCHS@HON.S" => %Q|Series.load_from_bls("CUUSA426SAH", "S")|,
"PCHSSH@HON.S" => %Q|Series.load_from_bls("CUUSA426SAH1", "S")|,
"PCHSSHRT@HON.S" => %Q|Series.load_from_bls("CUUSA426SEHA", "S")|,
"PCHSSHOW@HON.S" => %Q|Series.load_from_bls("CUUSA426SEHC", "S")|,
"PCHSFU@HON.S" => %Q|Series.load_from_bls("CUUSA426SAH2", "S")|,
"PCHSFUEL@HON.S" => %Q|Series.load_from_bls("CUUSA426SAH21", "S")|,
"PCHSFUGS@HON.S" => %Q|Series.load_from_bls("CUUSA426SEHF", "S")|,
"PCHSFUGSE@HON.S" => %Q|Series.load_from_bls("CUUSA426SEHF01", "S")|,
"PCHSFUGSU@HON.S" => %Q|Series.load_from_bls("CUUSA426SEHF02", "S")|,
"PCHSHF@HON.S" => %Q|Series.load_from_bls("CUUSA426SAH3", "S")|,
"PCAP@HON.S" => %Q|Series.load_from_bls("CUUSA426SAA", "S")|,
"PCTR@HON.S" => %Q|Series.load_from_bls("CUUSA426SAT", "S")|,
"PCTRPR@HON.S" => %Q|Series.load_from_bls("CUUSA426SAT1", "S")|,
"PCTRMF@HON.S" => %Q|Series.load_from_bls("CUUSA426SETB", "S")|,
"PCTRGS@HON.S" => %Q|Series.load_from_bls("CUUSA426SETB01", "S")|,
"PCTRGSRG@HON.S" => %Q|Series.load_from_bls("CUUSA426SS47014", "S")|,
"PCTRGSMD@HON.S" => %Q|Series.load_from_bls("CUUSA426SS47015", "S")|,
"PCTRGSPR@HON.S" => %Q|Series.load_from_bls("CUUSA426SS47016", "S")|,
"PCMD@HON.S" => %Q|Series.load_from_bls("CUUSA426SAM", "S")|,
"PCRE@HON.S" => %Q|Series.load_from_bls("CUUSA426SAR", "S")|,
"PCED@HON.S" => %Q|Series.load_from_bls("CUUSA426SAE", "S")|,
"PCOT@HON.S" => %Q|Series.load_from_bls("CUUSA426SAG", "S")|,
"PCCM@HON.S" => %Q|Series.load_from_bls("CUUSA426SAC", "S")|,
"PCCM_FD@HON.S" => %Q|Series.load_from_bls("CUUSA426SACL1", "S")|,
"PCCM_FB@HON.S" => %Q|Series.load_from_bls("CUUSA426SACL11", "S")|,
"PCCMND@HON.S" => %Q|Series.load_from_bls("CUUSA426SAN", "S")|,
"PCCMND_FD@HON.S" => %Q|Series.load_from_bls("CUUSA426SANL1", "S")|,
"PCCMND_FB@HON.S" => %Q|Series.load_from_bls("CUUSA426SANL11", "S")|,
"PCCMDR@HON.S" => %Q|Series.load_from_bls("CUUSA426SAD", "S")|,
"PCSV@HON.S" => %Q|Series.load_from_bls("CUUSA426SAS", "S")|,
"PCSV_MD@HON.S" => %Q|Series.load_from_bls("CUUSA426SASL5", "S")|,
"PCSV_RN@HON.S" => %Q|Series.load_from_bls("CUUSA426SASL2RS", "S")|,
"PC_MD@HON.S" => %Q|Series.load_from_bls("CUUSA426SA0L5", "S")|,
"PC_EN@HON.S" => %Q|Series.load_from_bls("CUUSA426SA0LE", "S")|,
"PC_FDEN@HON.S" => %Q|Series.load_from_bls("CUUSA426SA0L1E", "S")|,
"PC_SH@HON.S" => %Q|Series.load_from_bls("CUUSA426SA0L2", "S")|,
"PCEN@HON.S" => %Q|Series.load_from_bls("CUUSA426SA0E", "S")|
}
p = Packager.new
p.add_definitions bls_cpi_s
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/bls_cpi_upd_s_NEW.xls"
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["bls_cpi_upd_s", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end
task :bls_job_upd_m => :environment do
t = Time.now
bls_job_m = {
#These top several lines pull EMPL, LF, and UR data from HIWI as a temporary placeholder
#because HIWI releases the data a week before BLS.
#once BLS releases official values, these will be overwritten
"E_NFSA@HI.M" => %Q|Series.load_from_bls("SMS15000000000000001", "M")|,
"ECTSA@HI.M" => %Q|Series.load_from_bls("SMS15000001500000001", "M")|,
# "EMNSA@HI.M" => %Q|Series.load_from_bls("SMS15000003000000001", "M")|,
"E_TTUSA@HI.M" => %Q|Series.load_from_bls("SMS15000004000000001", "M")|,
"E_EDHCSA@HI.M" => %Q|Series.load_from_bls("SMS15000006500000001", "M")|,
"E_LHSA@HI.M" => %Q|Series.load_from_bls("SMS15000007000000001", "M")|,
"EOSSA@HI.M" => %Q|Series.load_from_bls("SMS15000008000000001", "M")|,
"EGVSA@HI.M" => %Q|Series.load_from_bls("SMS15000009000000001", "M")|,
"EWTSA@HI.M" => %Q|Series.load_from_bls("SMS15000004100000001", "M")|,
"ERTSA@HI.M" => %Q|Series.load_from_bls("SMS15000004200000001", "M")|,
"E_FIRSA@HI.M" => %Q|Series.load_from_bls("SMS15000005500000001", "M")|,
"ERESA@HI.M" => %Q|Series.load_from_bls("SMS15000005553000001", "M")|,
"E_PBSSA@HI.M" => %Q|Series.load_from_bls("SMS15000006000000001", "M")|,
"EPSSA@HI.M" => %Q|Series.load_from_bls("SMS15000006054000001", "M")|,
"EEDSA@HI.M" => %Q|Series.load_from_bls("SMS15000006561000001", "M")|,
"EHCSA@HI.M" => %Q|Series.load_from_bls("SMS15000006562000001", "M")|,
"EAESA@HI.M" => %Q|Series.load_from_bls("SMS15000007071000001", "M")|,
"EAFSA@HI.M" => %Q|Series.load_from_bls("SMS15000007072000001", "M")|,
"EGVFDSA@HI.M" => %Q|Series.load_from_bls("SMS15000009091000001", "M")|,
"EGVSTSA@HI.M" => %Q|Series.load_from_bls("SMS15000009092000001", "M")|,
"EGVLCSA@HI.M" => %Q|Series.load_from_bls("SMS15000009093000001", "M")|,
"EMNSA@HI.M" => %Q|Series.load_from_bls("SMS15000003000000001", "M")|,
"EMA@HI.M" => %Q|Series.load_from_bls("SMS15000006055000001", "M")|,
# divide these all by 1000?
"EMPLSA@HI.M" => %Q|Series.load_from_bls("LASST15000005", "M")|,
#We only need to keep the BLS EMPL, UR, LF commented out for benchmarking in the beginning of the year
#For the rest of the year, we want to uncomment it for the other 11 months in the year so BLS overwrites HIWI
#The reason is because BLS has more accuracy (HIWI rounds to 50 people) and BLS does backward revisions for 3 months
"EMPLNS@HI.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1976-01-01", :sheet => "State", :row => "increment:51:1", :col =>4, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUST15000005", "M")|],
"EMPLNS@HON.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Honolulu", :row => "increment:36:1", :col =>4, :frequency => "M"})/1|] ,
#%Q|Series.load_from_bls("LAUPS15007005", "M")|],
"EMPLNS@HAW.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Hawaii Cty", :row => "increment:36:1", :col =>4, :frequency => "M"})/1|] ,
#%Q|Series.load_from_bls("LAUPA15010005", "M")|],
"EMPLNS@MAU.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Maui Cty", :row => "increment:36:1", :col =>4, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUPA15015005", "M")|],
"EMPLNS@KAU.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Kauai Cty", :row => "increment:36:1", :col =>4, :frequency => "M"})/1|] ,
#%Q|Series.load_from_bls("LAUCN15007005", "M")|],
#"EMPLNS@MAUI.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Maui Isl", :row => "increment:37:1", :col =>4, :frequency => "M"})/1|,
#"EMPLNS@MOL.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Molokai", :row => "increment:37:1", :col =>4, :frequency => "M"})/1|,
#"EMPLNS@LAN.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Lanai", :row => "increment:51:1", :col =>4, :frequency => "M"})/1|,
"LFSA@HI.M" => %Q|Series.load_from_bls("LASST15000006", "M")|,
"LFNS@HI.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1976-01-01", :sheet => "State", :row => "increment:51:1", :col =>3, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUST15000006", "M")|],
"LFNS@HON.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Honolulu", :row => "increment:36:1", :col =>3, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUPS15007006", "M")|],
"LFNS@HAW.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Hawaii Cty", :row => "increment:36:1", :col =>3, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUPA15010006", "M")|],
"LFNS@MAU.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Maui Cty", :row => "increment:36:1", :col =>3, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUPA15015006", "M")|],
"LFNS@KAU.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Kauai Cty", :row => "increment:36:1", :col =>3, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUCN15007006", "M")|],
#"LFNS@MAUI.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Maui Isl", :row => "increment:37:1", :col =>3, :frequency => "M"})/1|,
#"LFNS@MOL.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Molokai", :row => "increment:37:1", :col =>3, :frequency => "M"})/1|,
#"LFNS@LAN.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Lanai", :row => "increment:51:1", :col =>3, :frequency => "M"})/1|,
"URSA@HI.M" => %Q|Series.load_from_bls("LASST15000003", "M")|,
"URNS@HI.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1976-01-01", :sheet => "State", :row => "increment:51:1", :col =>6, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUST15000003", "M")|],
"URNS@HON.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Honolulu", :row => "increment:36:1", :col =>6, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUPS15007003", "M")|],
"URNS@HAW.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Hawaii Cty", :row => "increment:36:1", :col =>6, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUPA15010003", "M")|],
"URNS@MAU.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Maui Cty", :row => "increment:36:1", :col =>6, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUPA15015003", "M")|],
"URNS@KAU.M" => [%Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Kauai Cty", :row => "increment:36:1", :col =>6, :frequency => "M"})/1|],
#%Q|Series.load_from_bls("LAUCN15007003", "M")|],
#"URNS@MAUI.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Maui Isl", :row => "increment:37:1", :col =>6, :frequency => "M"})/1|,
#"URNS@MOL.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Molokai", :row => "increment:37:1", :col =>6, :frequency => "M"})/1|,
#"URNS@LAN.M" => %Q|Series.load_from_download("LF@hiwi.org", { :file_type => "xls", :start_date => "1990-01-01", :sheet => "Lanai", :row => "increment:51:1", :col =>6, :frequency => "M"})/1|,
"WWCTNS@HI.M" => %Q|Series.load_from_bls("SMU15000001500000030", "M")|,
"WHCTNS@HI.M" => %Q|Series.load_from_bls("SMU15000001500000008", "M")|,
"WWMNNS@HI.M" => %Q|Series.load_from_bls("SMU15000003000000030", "M")|,
"WHMNNS@HI.M" => %Q|Series.load_from_bls("SMU15000003000000008", "M")|,
"WW_TTUNS@HI.M" => %Q|Series.load_from_bls("SMU15000004000000030", "M")|,
"WH_TTUNS@HI.M" => %Q|Series.load_from_bls("SMU15000004000000008", "M")|,
"WWWTNS@HI.M" => %Q|Series.load_from_bls("SMU15000004100000030", "M")|,
"WHWTNS@HI.M" => %Q|Series.load_from_bls("SMU15000004100000008", "M")|,
"WWRTNS@HI.M" => %Q|Series.load_from_bls("SMU15000004200000030", "M")|,
"WHRTNS@HI.M" => %Q|Series.load_from_bls("SMU15000004200000008", "M")|,
# "WWIFNS@HI.M" => %Q|Series.load_from_bls("SMU15000005000000030", "M")|,
# "WHIFNS@HI.M" => %Q|Series.load_from_bls("SMU15000005000000008", "M")|,
"WW_FINNS@HI.M" => %Q|Series.load_from_bls("SMU15000005500000030", "M")|,
"WH_FINNS@HI.M" => %Q|Series.load_from_bls("SMU15000005500000008", "M")|,
"WWAFNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072000030", "M")|,
"WHAFNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072000008", "M")|,
#"WWAFACNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072100030", "M")|,
#"WHAFACNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072100008", "M")|,
# "WWAFFDNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072200030", "M")|,
# "WHAFFDNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072200008", "M")|,
"WHAFFDNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072200008", "M")|,
"WWAFFDNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072200030", "M")|,
"WWCTNS@HON.M" => %Q|Series.load_from_bls("SMU15261801500000030", "M")|,
"WHCTNS@HON.M" => %Q|Series.load_from_bls("SMU15261801500000008", "M")|,
"WWMNNS@HON.M" => %Q|Series.load_from_bls("SMU15261803000000030", "M")|,
"WHMNNS@HON.M" => %Q|Series.load_from_bls("SMU15261803000000008", "M")|,
"WW_TTUNS@HON.M" => %Q|Series.load_from_bls("SMU15261804000000030", "M")|,
"WH_TTUNS@HON.M" => %Q|Series.load_from_bls("SMU15261804000000008", "M")|,
"WWWTNS@HON.M" => %Q|Series.load_from_bls("SMU15261804100000030", "M")|,
"WHWTNS@HON.M" => %Q|Series.load_from_bls("SMU15261804100000008", "M")|,
"WWRTNS@HON.M" => %Q|Series.load_from_bls("SMU15261804200000030", "M")|,
"WHRTNS@HON.M" => %Q|Series.load_from_bls("SMU15261804200000008", "M")|,
# "WWIFNS@HON.M" => %Q|Series.load_from_bls("SMU15261805000000030", "M")|,
# "WHIFNS@HON.M" => %Q|Series.load_from_bls("SMU15261805000000008", "M")|,
"WW_FINNS@HON.M" => %Q|Series.load_from_bls("SMU15261805500000030", "M")|,
"WH_FINNS@HON.M" => %Q|Series.load_from_bls("SMU15261805500000008", "M")|,
"WWAFNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072000030", "M")|,
"WHAFNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072000008", "M")|,
# "WWAFACNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072100030", "M")|,
# "WHAFACNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072100008", "M")|,
"WWAFFDNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072200030", "M")|,
"WHAFFDNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072200008", "M")|,
"E_NFNS@HI.M" => %Q|Series.load_from_bls("SMU15000000000000001", "M")|,
"E_PRNS@HI.M" => %Q|Series.load_from_bls("SMU15000000500000001", "M")|,
"E_GDSPRNS@HI.M" => %Q|Series.load_from_bls("SMU15000000600000001", "M")|,
"E_SVCPRNS@HI.M" => %Q|Series.load_from_bls("SMU15000000700000001", "M")|,
"E_PRSVCPRNS@HI.M" => %Q|Series.load_from_bls("SMU15000000800000001", "M")|,
"ECTNS@HI.M" => %Q|Series.load_from_bls("SMU15000001500000001", "M")|,
"ECTBLNS@HI.M" => %Q|Series.load_from_bls("SMU15000001523600001", "M")|,
"ECTSPNS@HI.M" => %Q|Series.load_from_bls("SMU15000001523800001", "M")|,
"EMNNS@HI.M" => %Q|Series.load_from_bls("SMU15000003000000001", "M")|,
"EMNDRNS@HI.M" => %Q|Series.load_from_bls("SMU15000003100000001", "M")|,
"EMNNDNS@HI.M" => %Q|Series.load_from_bls("SMU15000003200000001", "M")|,
"E_TTUNS@HI.M" => %Q|Series.load_from_bls("SMU15000004000000001", "M")|,
"EWTNS@HI.M" => %Q|Series.load_from_bls("SMU15000004100000001", "M")|,
"ERTNS@HI.M" => %Q|Series.load_from_bls("SMU15000004200000001", "M")|,
"ERTFDNS@HI.M" => %Q|Series.load_from_bls("SMU15000004244500001", "M")|,
"ERTFDGSNS@HI.M" => %Q|Series.load_from_bls("SMU15000004244510001", "M")|,
"ERTCLNS@HI.M" => %Q|Series.load_from_bls("SMU15000004244800001", "M")|,
"ERTGMNS@HI.M" => %Q|Series.load_from_bls("SMU15000004245200001", "M")|,
"ERTGMDSNS@HI.M" => %Q|Series.load_from_bls("SMU15000004245210001", "M")|,
"E_TUNS@HI.M" => %Q|Series.load_from_bls("SMU15000004300000001", "M")|,
"EUTNS@HI.M" => %Q|Series.load_from_bls("SMU15000004322000001", "M")|,
"ETWNS@HI.M" => %Q|Series.load_from_bls("SMU15000004340008901", "M")|,
"ETWTANS@HI.M" => %Q|Series.load_from_bls("SMU15000004348100001", "M")|,
"EIFNS@HI.M" => %Q|Series.load_from_bls("SMU15000005000000001", "M")|,
"EIFTCNS@HI.M" => %Q|Series.load_from_bls("SMU15000005051700001", "M")|,
"E_FIRNS@HI.M" => %Q|Series.load_from_bls("SMU15000005500000001", "M")|,
"EFINS@HI.M" => %Q|Series.load_from_bls("SMU15000005552000001", "M")|,
"ERENS@HI.M" => %Q|Series.load_from_bls("SMU15000005553000001", "M")|,
"E_PBSNS@HI.M" => %Q|Series.load_from_bls("SMU15000006000000001", "M")|,
"EPSNS@HI.M" => %Q|Series.load_from_bls("SMU15000006054000001", "M")|,
"EMANS@HI.M" => %Q|Series.load_from_bls("SMU15000006055000001", "M")|,
"EADNS@HI.M" => %Q|Series.load_from_bls("SMU15000006056000001", "M")|,
"EADESNS@HI.M" => %Q|Series.load_from_bls("SMU15000006056130001", "M")|,
"E_EDHCNS@HI.M" => %Q|Series.load_from_bls("SMU15000006500000001", "M")|,
"EEDNS@HI.M" => %Q|Series.load_from_bls("SMU15000006561000001", "M")|,
"EED12NS@HI.M" => %Q|Series.load_from_bls("SMU15000006561110001", "M")|,
"EHCNS@HI.M" => %Q|Series.load_from_bls("SMU15000006562000001", "M")|,
"EHCAMNS@HI.M" => %Q|Series.load_from_bls("SMU15000006562100001", "M")|,
"EHCHONS@HI.M" => %Q|Series.load_from_bls("SMU15000006562200001", "M")|,
"EHCNRNS@HI.M" => %Q|Series.load_from_bls("SMU15000006562300001", "M")|,
"EHCSONS@HI.M" => %Q|Series.load_from_bls("SMU15000006562400001", "M")|,
"EHCSOIFNS@HI.M" => %Q|Series.load_from_bls("SMU15000006562410001", "M")|,
"E_LHNS@HI.M" => %Q|Series.load_from_bls("SMU15000007000000001", "M")|,
"EAENS@HI.M" => %Q|Series.load_from_bls("SMU15000007071000001", "M")|,
"EAFNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072000001", "M")|,
"EAFACNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072100001", "M")|,
"EAFFDNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072200001", "M")|,
"EAFFDRSNS@HI.M" => %Q|Series.load_from_bls("SMU15000007072251101", "M")|,
"EOSNS@HI.M" => %Q|Series.load_from_bls("SMU15000008000000001", "M")|,
"EGVNS@HI.M" => %Q|Series.load_from_bls("SMU15000009000000001", "M")|,
"EGVFDNS@HI.M" => %Q|Series.load_from_bls("SMU15000009091000001", "M")|,
"EGVFDSPNS@HI.M" => %Q|Series.load_from_bls("SMU15000009091336601", "M")|,
#{}"EGVFDDDNS@HI.M" => %Q|Series.load_from_bls("SMU15000009091911001", "M")|,
"EGVSTNS@HI.M" => %Q|Series.load_from_bls("SMU15000009092000001", "M")|,
"EGVSTEDNS@HI.M" => %Q|Series.load_from_bls("SMU15000009092161101", "M")|,
"EGVLCNS@HI.M" => %Q|Series.load_from_bls("SMU15000009093000001", "M")|,
"E_NFNS@HON.M" => %Q|Series.load_from_bls("SMU15261800000000001", "M")|,
"E_PRNS@HON.M" => %Q|Series.load_from_bls("SMU15261800500000001", "M")|,
"E_GDSPRNS@HON.M" => %Q|Series.load_from_bls("SMU15261800600000001", "M")|,
"E_SVCPRNS@HON.M" => %Q|Series.load_from_bls("SMU15261800700000001", "M")|,
"E_PRSVCPRNS@HON.M" => %Q|Series.load_from_bls("SMU15261800800000001", "M")|,
"ECTNS@HON.M" => %Q|Series.load_from_bls("SMU15261801500000001", "M")|,
"ECTSPNS@HON.M" => %Q|Series.load_from_bls("SMU15261801523800001", "M")|,
"EMNNS@HON.M" => %Q|Series.load_from_bls("SMU15261803000000001", "M")|,
"EMNDRNS@HON.M" => %Q|Series.load_from_bls("SMU15261803100000001", "M")|,
"EMNNDNS@HON.M" => %Q|Series.load_from_bls("SMU15261803200000001", "M")|,
"E_TTUNS@HON.M" => %Q|Series.load_from_bls("SMU15261804000000001", "M")|,
"EWTNS@HON.M" => %Q|Series.load_from_bls("SMU15261804100000001", "M")|,
"ERTNS@HON.M" => %Q|Series.load_from_bls("SMU15261804200000001", "M")|,
"ERTFDNS@HON.M" => %Q|Series.load_from_bls("SMU15261804244500001", "M")|,
"ERTFDGSNS@HON.M" => %Q|Series.load_from_bls("SMU15261804244510001", "M")|,
"ERTCLNS@HON.M" => %Q|Series.load_from_bls("SMU15261804244800001", "M")|,
"ERTGMNS@HON.M" => %Q|Series.load_from_bls("SMU15261804245200001", "M")|,
"ERTGMDSNS@HON.M" => %Q|Series.load_from_bls("SMU15261804245210001", "M")|,
"E_TUNS@HON.M" => %Q|Series.load_from_bls("SMU15261804300000001", "M")|,
"ETWNS@HON.M" => %Q|Series.load_from_bls("SMU15261804340008901", "M")|,
"ETWTANS@HON.M" => %Q|Series.load_from_bls("SMU15261804348100001", "M")|,
"EIFNS@HON.M" => %Q|Series.load_from_bls("SMU15261805000000001", "M")|,
"EIFTCNS@HON.M" => %Q|Series.load_from_bls("SMU15261805051700001", "M")|,
"E_FIRNS@HON.M" => %Q|Series.load_from_bls("SMU15261805500000001", "M")|,
"EFINS@HON.M" => %Q|Series.load_from_bls("SMU15261805552000001", "M")|,
"ERENS@HON.M" => %Q|Series.load_from_bls("SMU15261805553000001", "M")|,
"E_PBSNS@HON.M" => %Q|Series.load_from_bls("SMU15261806000000001", "M")|,
"EPSNS@HON.M" => %Q|Series.load_from_bls("SMU15261806054000001", "M")|,
"EMANS@HON.M" => %Q|Series.load_from_bls("SMU15261806055000001", "M")|,
"EADNS@HON.M" => %Q|Series.load_from_bls("SMU15261806056000001", "M")|,
"EADESNS@HON.M" => %Q|Series.load_from_bls("SMU15261806056130001", "M")|,
"E_EDHCNS@HON.M" => %Q|Series.load_from_bls("SMU15261806500000001", "M")|,
"EEDNS@HON.M" => %Q|Series.load_from_bls("SMU15261806561000001", "M")|,
"EED12NS@HON.M" => %Q|Series.load_from_bls("SMU15261806561110001", "M")|,
"EHCNS@HON.M" => %Q|Series.load_from_bls("SMU15261806562000001", "M")|,
"EHCAMNS@HON.M" => %Q|Series.load_from_bls("SMU15261806562100001", "M")|,
"EHCHONS@HON.M" => %Q|Series.load_from_bls("SMU15261806562200001", "M")|,
"E_LHNS@HON.M" => %Q|Series.load_from_bls("SMU15261807000000001", "M")|,
"EAFNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072000001", "M")|,
"EAFACNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072100001", "M")|,
"EAFFDNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072200001", "M")|,
"EAFFDRSNS@HON.M" => %Q|Series.load_from_bls("SMU15261807072251101", "M")|,
"EOSNS@HON.M" => %Q|Series.load_from_bls("SMU15261808000000001", "M")|,
"EGVNS@HON.M" => %Q|Series.load_from_bls("SMU15261809000000001", "M")|,
"EGVFDNS@HON.M" => %Q|Series.load_from_bls("SMU15261809091000001", "M")|,
"EGVFDSPNS@HON.M" => %Q|Series.load_from_bls("SMU15261809091336601", "M")|,
#{}"EGVFDDDNS@HON.M" => %Q|Series.load_from_bls("SMU15261809091911001", "M")|,
#we are going to use EGVFDDDNS@HON.M from BLS because that is what AREMOS is using...although HIWI has more data"
"EGVSTNS@HON.M" => %Q|Series.load_from_bls("SMU15261809092000001", "M")|,
"EGVSTEDNS@HON.M" => %Q|Series.load_from_bls("SMU15261809092161101", "M")|,
"EGVLCNS@HON.M" => %Q|Series.load_from_bls("SMU15261809093000001", "M")|,
"EGVFDDDNS@HI.M" => %Q|Series.load_from_bls("SMU15000009091911901", "M")|,
"EGVFDDDNS@HON.M" => %Q|Series.load_from_bls("SMU15261809091911901", "M")|,
}
p = Packager.new
p.add_definitions bls_job_m
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/bls_job_upd_m_NEW.xls"
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["bls_job_upd_m", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end
task :hiwi_upd => :environment do
t = Time.now
hiwi_upd = {
'E_NFNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:WAGE & SALARY JOBS", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Total Private", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_GDSPRNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Goods-Producing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Nat. Resources & Mining & Construction", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTBLNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Construction of Buildings", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTSPNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Special Trade Contractors", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Manufacturing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNDRNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNDNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Non-Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_SVCPRNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRSVCPRNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Private Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TTUNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Trade, Transportation & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EWTNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Wholesale Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Retail Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Food & Beverage Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDGSNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Grocery Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTCLNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Clothing & Clothing Accessories Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:General Merchandise", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMDSNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Department Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TUNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Transportation, Warehousing & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EUTNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Utilites", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ETWNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Transportation & Warehousing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ETWTANS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Air Transportation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Information", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFTCNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Telecommunications", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_FIRNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Financial Activities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EFINS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Finance & Insurance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERENS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Real Estate & Rental & Leasing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PBSNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Professional & Business Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EPSNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Professional, Scientific & Tech. Svcs.", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMANS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Management of Companies & Enterprises", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EADNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Management & Remediation Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EADESNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Employment Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_EDHCNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Educational & Health Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EEDNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Educational Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EED12NS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Elementary & Secondary Schools", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Health Care & Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCAMNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Ambulatory Health Care Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCHONS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Hospitals", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCNRNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Nursing & Residenial Care Facilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCSONS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCSOIFNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Individual & Family Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_LHNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Leisure and Hospitality", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAENS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Arts, Entertainment, & Recreation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Accommodation & Food Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFACNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Accommodation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Food Services & Drinking Places", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDRSNS@HI.M' => [%Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Full-Service Restaurants", :col => "repeat:2:13" , :frequency => "M"})/1000|,
%Q|Series.load_from_bls("SMU15000007072251101", "M")|],
'EOSNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Other Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Federal Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDDDNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Department of Defense", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDSPNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Naval Shipyard", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:State Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTEDNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:State Education", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVLCNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:Local Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAGNS@HI.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "State", :row => "header:col:1:AGRICULTURE", :col => "repeat:2:13" , :frequency => "M"})/1000|
}
hiwi_upd_hon = {
'E_NFNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:WAGE & SALARY JOBS", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Total Private", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_GDSPRNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Goods-Producing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Nat. Resources & Mining & Construction", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ECTBLNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Construction of Buildings", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTSPNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Special Trade Contractors", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Manufacturing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNDRNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNDNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Non-Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_SVCPRNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRSVCPRNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Private Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TTUNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Trade, Transportation & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EWTNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Wholesale Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Retail Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Food & Beverage Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDGSNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Grocery Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTCLNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Clothing & Clothing Accessories Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:General Merchandise", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMDSNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Department Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TUNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Transportation, Warehousing & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ETWNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Transportation & Warehousing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ETWTANS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Air Transportation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Information", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFTCNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Telecommunications", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_FIRNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Financial Activities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EFINS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Finance & Insurance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERENS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Real Estate & Rental & Leasing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PBSNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Professional & Business Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EPSNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Professional, Scientific & Tech. Svcs.", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMANS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Management of Companies & Enterprises", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EADNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Management & Remediation Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EADESNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Employment Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_EDHCNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Educational & Health Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EEDNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Educational Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EED12NS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Elementary & Secondary Schools", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Health Care & Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCAMNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Ambulatory Health Care Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCHONS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Hospitals", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCNRNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Nursing & Residenial Care Facilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSONS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSOIFNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Individual & Family Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_LHNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Leisure and Hospitality", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Accommodation & Food Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFACNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Accommodation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Food Services & Drinking Places", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDRSNS@HON.M' => [%Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Full-Service Restaurants", :col => "repeat:2:13" , :frequency => "M"})/1000|,
%Q|Series.load_from_bls("SMU15261807072251101", "M")|],
'EOSNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Other Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Federal Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDDDNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Department of Defense", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDSPNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Naval Shipyard", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:State Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTEDNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:State Education", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVLCNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:Local Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAGNS@HON.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "Oahu", :row => "header:col:1:AGRICULTURE", :col => "repeat:2:13" , :frequency => "M"})/1000|,
}
hiwi_upd_haw = {
'E_NFNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:WAGE & SALARY JOBS", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Total Private", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_GDSPRNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Goods-Producing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Nat. Resources & Mining & Construction", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ECTBLNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Construction of Buildings", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTSPNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Special Trade Contractors", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Manufacturing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNDRNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNDNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Non-Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_SVCPRNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRSVCPRNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Private Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TTUNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Trade, Transportation & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EWTNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Wholesale Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Retail Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Food & Beverage Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDGSNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Grocery Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTCLNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Clothing & Clothing Accessories Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:General Merchandise", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMDSNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Department Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TUNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Transportation, Warehousing & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EUTNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Utilites", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ETWNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Transportation & Warehousing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ETWTANS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Air Transportation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Information", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFTCNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Telecommunications", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_FIRNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Financial Activities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EFINS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Finance & Insurance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ERENS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Real Estate & Rental & Leasing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PBSNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Professional & Business Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EPSNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Professional, Scientific & Tech. Svcs.", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EMANS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Management of Companies & Enterprises", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EADNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Management & Remediation Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EADESNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Employment Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_EDHCNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Educational & Health Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EEDNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Educational Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EED12NS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Elementary & Secondary Schools", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Health Care & Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCAMNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Ambulatory Health Care Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCHONS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Hospitals", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCNRNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Nursing & Residenial Care Facilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSONS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSOIFNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Individual & Family Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_LHNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Leisure and Hospitality", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EAENS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :end_date=>"2010-12-01", :sheet => "HCty", :row => "header:col:1:Arts, Entertainment, & Recreation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Accommodation & Food Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFACNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Accommodation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Food Services & Drinking Places", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDRSNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Full-Service Restaurants", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EOSNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Other Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Federal Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDDDNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Department of Defense", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EGVFDSPNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Naval Shipyard", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:State Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTEDNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:State Education", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVLCNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:Local Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAGNS@HAW.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "HCty", :row => "header:col:1:AGRICULTURE", :col => "repeat:2:13" , :frequency => "M"})/1000|
}
hiwi_upd_kau = {
'E_NFNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:WAGE & SALARY JOBS", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Total Private", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_GDSPRNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Goods-Producing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Nat. Resources & Mining & Construction", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ECTBLNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Construction of Buildings", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTSPNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Special Trade Contractors", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Manufacturing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNDRNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNDNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Non-Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_SVCPRNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRSVCPRNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Private Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TTUNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Trade, Transportation & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EWTNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Wholesale Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Retail Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Food & Beverage Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDGSNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Grocery Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTCLNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Clothing & Clothing Accessories Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:General Merchandise", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMDSNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Department Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TUNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Transportation, Warehousing & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EUTNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Utilites", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ETWNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Transportation & Warehousing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ETWTANS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Air Transportation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Information", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFTCNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Telecommunications", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_FIRNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Financial Activities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EFINS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Finance & Insurance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ERENS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Real Estate & Rental & Leasing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PBSNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Professional & Business Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EPSNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Professional, Scientific & Tech. Svcs.", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EMANS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Management of Companies & Enterprises", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EADNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Management & Remediation Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EADESNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Employment Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_EDHCNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Educational & Health Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EEDNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Educational Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EED12NS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Elementary & Secondary Schools", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Health Care & Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCAMNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Ambulatory Health Care Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCHONS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Hospitals", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCNRNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Nursing & Residenial Care Facilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSONS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSOIFNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Individual & Family Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_LHNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Leisure and Hospitality", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EAENS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :end_date=>"2010-12-01", :sheet => "KCty", :row => "header:col:1:Arts, Entertainment, & Recreation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Accommodation & Food Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFACNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Accommodation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Food Services & Drinking Places", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDRSNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Full-Service Restaurants", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EOSNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Other Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Federal Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDDDNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Department of Defense", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EGVFDSPNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Naval Shipyard", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:State Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTEDNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:State Education", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVLCNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:Local Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAGNS@KAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "KCty", :row => "header:col:1:AGRICULTURE", :col => "repeat:2:13" , :frequency => "M"})/1000|
}
hiwi_upd_mau = {
'E_NFNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:WAGE & SALARY JOBS", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Total Private", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_GDSPRNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Goods-Producing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Nat. Resources & Mining & Construction", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ECTBLNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Construction of Buildings", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ECTSPNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Special Trade Contractors", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Manufacturing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNDRNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EMNNDNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Non-Durable Goods", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_SVCPRNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PRSVCPRNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Private Service-Providing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TTUNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Trade, Transportation & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EWTNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Wholesale Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Retail Trade", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Food & Beverage Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTFDGSNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Grocery Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTCLNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Clothing & Clothing Accessories Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:General Merchandise", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ERTGMDSNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Department Stores", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_TUNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Transportation, Warehousing & Utilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EUTNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Utilites", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ETWNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Transportation & Warehousing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'ETWTANS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Air Transportation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Information", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EIFTCNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Telecommunications", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_FIRNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Financial Activities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EFINS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Finance & Insurance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'ERENS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Real Estate & Rental & Leasing", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_PBSNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Professional & Business Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EPSNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Professional, Scientific & Tech. Svcs.", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EMANS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Management of Companies & Enterprises", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EADNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Management & Remediation Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EADESNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Employment Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_EDHCNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Educational & Health Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EEDNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Educational Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EED12NS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Elementary & Secondary Schools", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EHCNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Health Care & Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCAMNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Ambulatory Health Care Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCHONS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Hospitals", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCNRNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Nursing & Residenial Care Facilities", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSONS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Social Assistance", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EHCSOIFNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Individual & Family Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'E_LHNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Leisure and Hospitality", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EAENS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :end_date=>"2010-12-01", :sheet => "MCty", :row => "header:col:1:Arts, Entertainment, & Recreation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Accommodation & Food Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFACNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Accommodation", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Food Services & Drinking Places", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAFFDRSNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Full-Service Restaurants", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EOSNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Other Services", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Federal Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVFDDDNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Department of Defense", :col => "repeat:2:13" , :frequency => "M"})/1000|,
#'EGVFDSPNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Naval Shipyard", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:State Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVSTEDNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:State Education", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EGVLCNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:Local Government", :col => "repeat:2:13" , :frequency => "M"})/1000|,
'EAGNS@MAU.M' => %Q|Series.load_from_download( "%Y@hiwi.org", { :file_type => "xls", :start_date => "2009-01-01", :sheet => "MCty", :row => "header:col:1:AGRICULTURE", :col => "repeat:2:13" , :frequency => "M"})/1000|,
}
p = Packager.new
p.add_definitions hiwi_upd
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/hiwi_HI.xls"
p = Packager.new
p.add_definitions hiwi_upd_hon
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/hiwi_HON.xls"
p = Packager.new
p.add_definitions hiwi_upd_haw
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/hiwi_HAW.xls"
p = Packager.new
p.add_definitions hiwi_upd_kau
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/hiwi_KAU.xls"
p = Packager.new
p.add_definitions hiwi_upd_mau
p.write_definitions_to "/Volumes/UHEROwork/data/bls/update/hiwi_MAU.xls"
CSV.open("public/rake_time.csv", "a") {|csv| csv << ["hiwi_upd", "%.2f" % (Time.now - t) , t.to_s, Time.now.to_s] }
end
task :bls_nbis => :environment do
["E", "EAD", "EADES", "EADESNS", "EADNS", "EAE", "EAENS", "EAF", "EAFAC", "EAFACNS", "EAFFD", "EAFFDNS", "EAFFDRS", "EAFFDRSNS", "EAFNS", "EAG", "EAGNS", "ECT", "ECTNS", "ECTSP", "ECTSPNS", "EED12", "EED12NS", "EED", "EEDNS", "EFI", "EFINS", "EGV", "EGVFD", "EGVFDDD", "EGVFDDDNS", "EGVFDNS", "EGVFDSP", "EGVFDSPNS", "EGVLC", "EGVLCNS", "EGVNS", "EGVST", "EGVSTED", "EGVSTEDNS", "EGVSTNS", "EHC", "EHCAM", "EHCAMNS", "EHCHO", "EHCHONS", "EHCNS", "EIF", "EIFNS", "EIFTC", "EIFTCNS", "EMA", "EMANS", "EMN", "EMNDR", "EMNDRNS", "EMNND", "EMNNDNS", "EMNNS", "EMPL", "EMPLNS", "ENS", "EOS", "EOSNS", "EPS", "EPSNS", "ERE", "ERENS", "ERT", "ERTCL", "ERTCLNS", "ERTFD", "ERTFDGS", "ERTFDGSNS", "ERTFDNS", "ERTGM", "ERTGMDS", "ERTGMDSNS", "ERTGMNS", "ERTNS", "ETW", "ETWNS", "ETWTA", "ETWTANS", "EUT", "EUTNS", "EWT", "EWTNS", "E_EDHC", "E_EDHCNS", "E_ELSE", "E_ELSENS", "E_FIR", "E_FIRNS", "E_GDSPR", "E_GDSPRNS", "E_GVSL", "E_GVSLNS", "E_LH", "E_LHNS", "E_NF", "E_NFNS", "E_PBS", "E_PBSNS", "E_PR", "E_PRNS", "E_PRSVCPR", "E_PRSVCPRNS", "E_SV", "E_SVCPR", "E_SVCPRNS", "E_SVNS", "E_TRADE", "E_TRADENS", "E_TTU", "E_TTUNS", "E_TU", "E_TUNS"].each do |pre|
["A", "Q", "M"].each do |f|
("#{pre}@NBI.#{f}".ts_eval= %Q|"#{pre}@HI.#{f}".ts - "#{pre}@HON.#{f}".ts|) rescue "puts error #{pre}@NBI.#{f}"
end
end
end
task :bls_identities => :environment do
t= Time.now
"PC@HON.Q".ts_append_eval %Q|"PC@HON.S".ts.interpolate(:quarter, :linear).trim("1985-01-01")|
"PC@HON.Q".ts_append_eval %Q|"PC@HON.M".ts.aggregate(:quarter, :average)|
"PC@HON.A".ts_append_eval %Q|"PC@HON.S".ts.aggregate(:year, :average)|
"PC@HON.A".ts_append_eval %Q|"PC@HON.M".ts.aggregate(:year, :average)|
"CPI@HON.S".ts_eval= %Q|"PC@HON.S".ts|
"CPI@HON.A".ts_eval= %Q|"PC@HON.A".ts|
"CPI@HON.Q".ts_eval= %Q|"PC@HON.Q".ts|
"PCDMNS@HI.Q".ts_eval=%Q|"PCDMNS@HI.M".ts.aggregate(:quarter, :sum)|
"PCITJPNS@HI.Q".ts_eval=%Q|"PCITJPNS@HI.M".ts.aggregate(:quarter, :sum)|
"PCITOTNS@HI.Q".ts_eval=%Q|"PCITOTNS@HI.M".ts.aggregate(:quarter, :sum)|
"PCNS@HI.Q".ts_eval=%Q|"PCNS@HI.M".ts.aggregate(:quarter, :sum)|
"PCE@US.Q".ts_eval=%Q|"PCE@US.M".ts.aggregate(:quarter, :average)|
"PCECORE@US.Q".ts_eval=%Q|"PCECORE@US.M".ts.aggregate(:quarter, :average)|
"PCE@US.A".ts_eval=%Q|"PCE@US.Q".ts.aggregate(:year, :average)|
"PCECORE@US.A".ts_eval=%Q|"PCECORE@US.Q".ts.aggregate(:year, :average)|
["PC_FDEN", "PC_MD", "PC_SH", "PCAP", "PCCM_FB", "PCCM_FD","PCCM", "PCCMDR", "PCCMND_FB","PCCMND_FD","PCCMND", "PCED",
"PCEN", "PCFB", "PCFBFD", "PCFBFDAW", "PCFBFDBV", "PCFBFDHM", "PCHS", "PCHSFU", "PCHSFUEL", "PCHSFUGS", "PCHSFUGSE","PCHSFUGSU",
"PCHSHF","PCHSSH","PCHSSHOW", "PCHSSHRT", "PCMD", "PCOT", "PCRE", "PCSV_MD","PCSV_RN","PCSV", "PCTR", "PCTRGS", "PCTRGSMD", "PCTRGSPR",
"PCTRGSRG", "PCTRMF", "PCTRPR", "PC_EN"].each do |prefix|
"#{prefix}@HON.Q".ts_eval= %Q|"#{prefix}@HON.M".ts.aggregate(:quarter, :average)|
"#{prefix}@HON.Q".ts_eval= %Q|"#{prefix}@HON.S".ts.interpolate(:quarter, :linear).trim("1987-01-01")|
"#{prefix}@HON.A".ts_eval= %Q|"#{prefix}@HON.Q".ts.aggregate(:year, :average)|
end
"INF@HON.Q".ts_eval= %Q|"CPI@HON.Q".ts.rebase("2010-01-01").annualized_percentage_change|
"INFCORE@HON.Q".ts_eval= %Q|"PC_FDEN@HON.Q".ts.annualized_percentage_change|
"INF_SH@HON.Q".ts_eval= %Q|"PC_SH@HON.Q".ts.annualized_percentage_change|
"INF@HON.S".ts_eval= %Q|"CPI@HON.S".ts.rebase("2010-01-01").annualized_percentage_change|
"INFCORE@HON.S".ts_eval= %Q|"PC_FDEN@HON.S".ts.annualized_percentage_change|
"INF_SH@HON.S".ts_eval= %Q|"PC_SH@HON.S".ts.annualized_percentage_change|
"INF@HON.A".ts_eval= %Q|"CPI@HON.A".ts.rebase("2010-01-01").annualized_percentage_change|
"INFCORE@HON.A".ts_eval= %Q|"PC_FDEN@HON.A".ts.annualized_percentage_change|
"INF_SH@HON.A".ts_eval= %Q|"PC_SH@HON.A".ts.annualized_percentage_change|
"WPCSH@HON.A".ts_eval= %Q|("PC@HON.A".ts - "PC_SH@HON.A".ts) / ("PCHSSH@HON.A".ts - "PC_SH@HON.A".ts)|
"WPCEN@HON.A".ts_eval= %Q|("PC@HON.A".ts - "PC_EN@HON.A".ts) / ("PCEN@HON.A".ts - "PC_EN@HON.A".ts)|
"WPCFD@HON.A".ts_eval= %Q|("PC@HON.A".ts - "WPCEN@HON.A".ts * "PCEN@HON.A".ts - (("WPCEN@HON.A".ts - 1) * -1) * "PC_FDEN@HON.A".ts) / ("PCFBFD@HON.A".ts - "PC_FDEN@HON.A".ts)|
"WPCSH@HON.S".ts_eval= %Q|("PC@HON.S".ts - "PC_SH@HON.S".ts) / ("PCHSSH@HON.S".ts - "PC_SH@HON.S".ts)|
"WPCEN@HON.S".ts_eval= %Q|("PC@HON.S".ts - "PC_EN@HON.S".ts) / ("PCEN@HON.S".ts - "PC_EN@HON.S".ts)|
"WPCFD@HON.S".ts_eval= %Q|("PC@HON.S".ts - "WPCEN@HON.S".ts * "PCEN@HON.S".ts - (("WPCEN@HON.S".ts - 1) * -1) * "PC_FDEN@HON.S".ts) / ("PCFBFD@HON.S".ts - "PC_FDEN@HON.S".ts)|
"WPCSH@HON.Q".ts_eval=%Q|"WPCSH@HON.S".ts.interpolate(:quarter, :linear)|
"WPCEN@HON.Q".ts_eval=%Q|"WPCEN@HON.S".ts.interpolate(:quarter, :linear)|
"WPCFD@HON.Q".ts_eval=%Q|"WPCFD@HON.S".ts.interpolate(:quarter, :linear)|
"PC_SHFDEN@HON.Q ".ts_eval= %Q|("PC@HON.Q".ts - "WPCSH@HON.Q".ts * "PCHSSH@HON.Q".ts - "WPCEN@HON.Q".ts * "PCEN@HON.Q".ts - "WPCFD@HON.Q".ts * "PCFBFD@HON.Q".ts) / (("WPCSH@HON.Q".ts * -1) - "WPCEN@HON.Q".ts - "WPCFD@HON.Q".ts + 1)|
"PC_SHEN@HON.Q ".ts_eval= %Q|("PC@HON.Q".ts - "WPCSH@HON.Q".ts * "PCHSSH@HON.Q".ts - "WPCEN@HON.Q".ts * "PCEN@HON.Q".ts) / ( ("WPCSH@HON.Q".ts * -1) - "WPCEN@HON.Q".ts + 1)|
#Series loaded from this history sheet... may not need to load every day. But relatively fast...
#["E_FIR@HI.M", "E_FIR@HON.M", "E_GDSPR@HON.M", "E_GVSL@HON.M", "E_TTU@HAW.M", "E_TTU@HON.M", "E_TTU@KAU.M", "E_TTU@MAU.M", "E_TU@HI.M", "E_TU@HON.M", "EAF@HI.M", "EAF@HON.M", "EAFAC@HI.M", "EAFAC@HON.M", "EAFFD@HI.M", "EAFFD@HON.M", "ECT@HI.M", "ECT@HON.M", "EFI@HI.M", "EFI@HON.M", "EGVFD@HI.M", "EGVFD@HON.M", "EGVLC@HI.M", "EGVLC@HON.M", "EGVST@HI.M", "EGVST@HON.M", "EHC@HI.M", "EHC@HON.M", "EMN@HI.M", "EMN@HON.M", "ERE@HI.M", "ERE@HON.M"]
Series.load_all_series_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"
#needs EMN up here....
["HI", "HON", "HAW", "MAU", "KAU"].each do |cnty|
"ENS@#{cnty}.M".ts_append_eval %Q|"E_NFNS@#{cnty}.M".ts + "EAGNS@#{cnty}.M".ts|
"E_TRADENS@#{cnty}.M".ts_append_eval %Q|"EWTNS@#{cnty}.M".ts + "ERTNS@#{cnty}.M".ts|
"E_GVSLNS@#{cnty}.M".ts_append_eval %Q|"EGVNS@#{cnty}.M".ts - "EGVFDNS@#{cnty}.M".ts|
"E_SVNS@#{cnty}.M".ts_append_eval %Q|"E_NFNS@#{cnty}.M".ts - ("ECTNS@#{cnty}.M".ts + "EMNNS@#{cnty}.M".ts + "E_TRADENS@#{cnty}.M".ts + "E_TUNS@#{cnty}.M".ts + "E_FIRNS@#{cnty}.M".ts + "EGVNS@#{cnty}.M".ts) |
"E_ELSENS@HI.M".ts_append_eval %Q|"E_NFNS@HI.M".ts - ("ECTNS@HI.M".ts + "EMNNS@HI.M".ts + "E_TRADENS@HI.M".ts + "E_TUNS@HI.M".ts + "E_FIRNS@HI.M".ts + "EAFNS@HI.M".ts + "EHCNS@HI.M".ts + "EGVNS@HI.M".ts)|
end
#NEW SECTION BEN ADDED. Not totally reliable
["HI", "HON", "HAW", "MAU", "KAU"].each do |cnty|
["Q", "M"].each do |f| #?
("E_ELSENS@#{cnty}.#{f}".ts_eval= %Q|"E_NFNS@#{cnty}.#{f}".ts - ("ECTNS@#{cnty}.#{f}".ts + "EMNNS@#{cnty}.#{f}".ts + "E_TRADENS@#{cnty}.#{f}".ts + "E_TUNS@#{cnty}.#{f}".ts + "E_FIRNS@#{cnty}.#{f}".ts + "EAFNS@#{cnty}.#{f}".ts + "EHCNS@#{cnty}.#{f}".ts + "EGVNS@#{cnty}.#{f}".ts)|) rescue puts "ERROR E_ELSENS@#{cnty}.#{f}"
end
end
["HI", "HON", "HAW", "MAU", "KAU"].each do |cnty|
("EMN@#{cnty}.Q".ts_eval= %Q|"EMN@#{cnty}.M".ts.aggregate(:quarter, :average)|) rescue puts "ERROR EMN@#{cnty}.Q"
("E_GVSL@#{cnty}.Q".ts_eval= %Q|"E_GVSL@#{cnty}.M".ts.aggregate(:quarter, :average)|) rescue puts "ERROR E_GVSL@#{cnty}.Q"
("EMPL@#{cnty}.Q".ts_eval= %Q|"EMPL@#{cnty}.M".ts.aggregate(:quarter, :average)|) rescue puts "ERROR EMPL@#{cnty}.Q"
("EMPL@#{cnty}.A".ts_eval= %Q|"EMPLNS@#{cnty}.M".ts.aggregate(:year, :average)|) rescue puts "ERROR EMPL@#{cnty}.A"
("EMPLNS@#{cnty}.Q".ts_eval= %Q|"EMPLNS@#{cnty}.M".ts.aggregate(:quarter, :average)|) rescue puts "ERROR EMPLNS@#{cnty}.Q"
end
["HI", "HON", "HAW", "MAU", "KAU"].each do |cnty|
["Q", "M"].each do |f| #?
("E_GDSPR@#{cnty}.#{f}".ts_eval= %Q|"ECT@#{cnty}.#{f}".ts + "EMN@#{cnty}.#{f}".ts|) rescue puts "ERROR E_GDSPR@#{cnty}.#{f}"
("E_SV@#{cnty}.#{f}".ts_eval= %Q|"E_NF@#{cnty}.#{f}".ts - ("ECT@#{cnty}.#{f}".ts + "EMN@#{cnty}.#{f}".ts + "E_TTU@#{cnty}.#{f}".ts + "E_FIR@#{cnty}.#{f}".ts + "EGV@#{cnty}.#{f}".ts)|) rescue puts "ERROR E_ELSENS@#{cnty}.#{f}"
("E_SVCPR@#{cnty}.#{f}".ts_eval= %Q|"E_NF@#{cnty}.#{f}".ts - "E_GDSPR@#{cnty}.#{f}".ts|) rescue puts "ERROR E_SVCPR@#{cnty}.#{f}"
("E_ELSE@#{cnty}.#{f}".ts_eval= %Q|"E_SV@#{cnty}.#{f}".ts - ("EAF@#{cnty}.#{f}".ts + "EHC@#{cnty}.#{f}".ts)|) rescue puts "ERROR E_ELSE@#{cnty}.#{f}"
("E_PRSVCPR@#{cnty}.#{f}".ts_eval= %Q|"E_SVCPR@#{cnty}.#{f}".ts - "EGV@#{cnty}.#{f}".ts|) rescue puts "ERROR E_PRSVCPR@#{cnty}.#{f}"
end
end
["HI", "HON", "HAW", "MAU", "KAU"].each do |cnty|
f = "A"
("E_ELSE@#{cnty}.#{f}".ts_eval= %Q|"E_SV@#{cnty}.#{f}".ts - ("EAF@#{cnty}.#{f}".ts + "EHC@#{cnty}.#{f}".ts)|) rescue puts "ERROR E_ELSE@#{cnty}.#{f}"
end
"EAENS@HON.M".ts_eval= %Q|"E_LHNS@HON.M".ts - "EAFNS@HON.M".ts|
'EAENS@HAW.M'.ts_eval= %Q|"E_LHNS@HAW.M".ts - "EAFNS@HAW.M".ts|
'EAENS@KAU.M'.ts_eval= %Q|"E_LHNS@KAU.M".ts - "EAFNS@KAU.M".ts|
'EAENS@MAU.M'.ts_eval= %Q|"E_LHNS@MAU.M".ts - "EAFNS@MAU.M".ts|
'EUTNS@HON.M'.ts_eval= %Q|"E_TUNS@HON.M".ts - "ETWNS@HON.M".ts|
["HAW", "MAU", "KAU"].each do |cnty|
"ERENS@#{cnty}.M".ts_append_eval %Q|"E_FIRNS@#{cnty}.M".ts - "EFINS@#{cnty}.M".ts|
"EMANS@#{cnty}.M".ts_append_eval %Q|"E_PBSNS@#{cnty}.M".ts - "EPSNS@#{cnty}.M".ts - "EADNS@#{cnty}.M".ts|
"E_OTNS@#{cnty}.M".ts_append_eval %Q|"EMANS@#{cnty}.M".ts + "EADNS@#{cnty}.M".ts + "EEDNS@#{cnty}.M".ts + "EOSNS@#{cnty}.M".ts|
end
"UR@HI.M".ts_eval= %Q|"URSA@HI.M".ts|
"LF_MC@HI.M".ts_eval= %Q|"LFSA@HI.M".ts / "LFSA@HI.M".ts.annual_sum * "LFNS@HI.M".ts.annual_sum|
"LF@HI.M".ts_append_eval %Q|"LFSA@HI.M".ts.trim|
"LF@HI.M".ts_append_eval %Q|"LF_MC@HI.M".ts|
"EMPL_MC@HI.M".ts_eval= %Q|"EMPLSA@HI.M".ts / "EMPLSA@HI.M".ts.annual_sum * "EMPLNS@HI.M".ts.annual_sum|
"EMPL@HI.M".ts_append_eval %Q|"EMPLSA@HI.M".ts.trim|
"EMPL@HI.M".ts_append_eval %Q|"EMPL_MC@HI.M".ts|
["LF", "EMPL"].each do |s_name|
["HON", "HAW", "MAU", "KAU"].each do |county|
puts "distributing #{s_name}, #{county}"
"#{s_name}@#{county}.M".ts_eval= %Q|"#{s_name}@HI.M".ts.share_using("#{s_name}NS@#{county}.M".ts.backward_looking_moving_average.trim,"#{s_name}NS@HI.M".ts.backward_looking_moving_average.trim)|
"#{s_name}@#{county}.M".ts_eval= %Q|"#{s_name}_MC@HI.M".ts.share_using("#{s_name}NS@#{county}.M".ts, "#{s_name}NS@HI.M".ts)|
end
end
["HON", "HAW", "MAU", "KAU"].each do |county|
puts "distributing UR, #{county}"
("UR@#{county}.M".ts_eval= %Q|(("EMPL@#{county}.M".ts / "LF@#{county}.M".ts) * -1 + 1)*100|) rescue puts "problem with UR, #{county}"
end
["HI","HON", "HAW", "MAU", "KAU"].each do |county|
["LF", "LFNS"].each do |pre|
"#{pre}@#{county}.Q".ts_eval = %Q|"#{pre}@#{county}.M".ts.aggregate(:quarter, :average)|
end
"LF@#{county}.A".ts_eval = %Q|"LFNS@#{county}.M".ts.aggregate(:year, :average)|
end
"LFSA@HI.Q".ts_eval = %Q|"LFSA@HI.M".ts.aggregate(:quarter, :average)|
"LFPRNS@HI.Q".ts_eval= %Q|"LFNS@HI.Q".ts / "NRC@HI.Q".ts * 100|
"LFPRNS@HON.Q".ts_eval= %Q|"LFNS@HON.Q".ts / "NRC@HON.Q".ts * 100|
"LFPR@HI.Q".ts_eval= %Q|"LF@HI.Q".ts / "NRC@HI.Q".ts * 100|
"LFPR@HON.Q".ts_eval= %Q|"LF@HON.Q".ts / "NRC@HON.Q".ts * 100|
"LFPR@HI.A".ts_eval= %Q|"LF@HI.A".ts / "NRC@HI.A".ts * 100|
"LFPR@HON.A".ts_eval= %Q|"LF@HON.A".ts / "NRC@HON.A".ts * 100|
"LF@NBI.M".ts_eval = %Q|"LF@HI.M".ts - "LF@HON.M".ts|
"LF@NBI.Q".ts_eval = %Q|"LF@HI.Q".ts - "LF@HON.Q".ts|
"LF@NBI.A".ts_eval = %Q|"LF@HI.A".ts - "LF@HON.A".ts|
"LFNS@NBI.M".ts_eval= %Q|"LFNS@HI.M".ts - "LFNS@HON.M".ts|
"LFNS@NBI.Q".ts_eval= %Q|"LFNS@HI.Q".ts - "LFNS@HON.Q".ts|
["HAW", "MAU", "KAU","NBI"].each do |county|
"LFPRNS@#{county}.Q".ts_eval= %Q|"LFNS@#{county}.Q".ts / "NR@#{county}.Q".ts * 100|
"LFPR@#{county}.Q".ts_eval= %Q|"LF@#{county}.Q".ts / "NR@#{county}.Q".ts * 100|
"LFPR@#{county}.A".ts_eval= %Q|"LF@#{county}.A".ts / "NR@#{county}.A".ts * 100|
end
#technically these are US bank, but putting here with other LF series
"LFNS@CA.Q".ts_eval = %Q|"LFNS@CA.M".ts.aggregate(:quarter, :average)|
"LF@CA.Q".ts_eval = %Q|"LF@CA.M".ts.aggregate(:quarter, :average)|
"URNS@NBI.M".ts_eval= %Q|("LFNS@NBI.M".ts - "EMPLNS@NBI.M".ts) / "LFNS@NBI.M".ts * 100|
"UR@NBI.M".ts_eval= %Q| ("LF@NBI.M".ts - "EMPL@NBI.M".ts) / "LF@NBI.M".ts * 100|
"UR@NBI.A".ts_eval= %Q|"URNS@NBI.M".ts.aggregate(:year, :average)|
["UR", "URNS"].each do |pre|
"#{pre}@NBI.Q".ts_eval= %Q|"#{pre}@NBI.M".ts.aggregate(:quarter, :average)|
end
["ECT", "E_TTU", "E_EDHC", "E_LH", "EOS", "EGV", "EWT", "ERT", "E_FIR", "ERE", "E_PBS", "EPS", "EED", "EHC", "EAE", "EAF", "EGVFD", "EGVST", "EGVLC"].each do |list|
"#{list}@HI.M".ts_append_eval %Q|"#{list}SA@HI.M".ts|
end
"E_GVSL@HI.M".ts_eval= %Q|"EGVST@HI.M".ts + "EGVLC@HI.M".ts|
"EAFAC@HI.M".ts_append_eval %Q|"EAF@HI.M".ts.share_using("EAFACNS@HI.M".ts.backward_looking_moving_average.trim,"EAFNS@HI.M".ts.backward_looking_moving_average.trim)|
"EAFFD@HI.M".ts_append_eval %Q|"EAF@HI.M".ts.share_using("EAFFDNS@HI.M".ts.backward_looking_moving_average.trim,"EAFNS@HI.M".ts.backward_looking_moving_average.trim)|
"EAFAC@HI.M".ts_eval= %Q|"EAF@HI.M".ts.share_using("EAFACNS@HI.M".ts.annual_average,"EAFNS@HI.M".ts.annual_average).trim("1990-01-01")|
"EAFFD@HI.M".ts_eval= %Q|"EAF@HI.M".ts.share_using("EAFFDNS@HI.M".ts.annual_average,"EAFNS@HI.M".ts.annual_average).trim("1990-01-01")|
#{}"EMA@HI.M".ts_eval= %Q|("E_PBS@HI.M".ts - "EPS@HI.M".ts).share_using("EMANS@HI.M".ts.annual_sum, ("EMANS@HI.M".ts + "EADNS@HI.M".ts).annual_sum)|
#{}"#EMA@HI.M".ts_eval= %Q|("E_PBS@HI.M".ts - "EPS@HI.M".ts).share_using("EMANS@HI.M".ts.backward_looking_moving_average.trim, ("EMANS@HI.M".ts + "EADNS@HI.M".ts).backward_looking_moving_average.trim)|
#{}"EAD@HI.M".ts_eval= %Q|("E_PBS@HI.M".ts - "EPS@HI.M".ts).share_using("EADNS@HI.M".ts.annual_sum, ("EMANS@HI.M".ts + "EADNS@HI.M".ts).annual_sum)|
#{}"EAD@HI.M".ts_eval= %Q|("E_PBS@HI.M".ts - "EPS@HI.M".ts).share_using("EADNS@HI.M".ts.backward_looking_moving_average.trim, ("EMANS@HI.M".ts + "EADNS@HI.M".ts).backward_looking_moving_average.trim)|
"EAD@HI.M".ts_eval = %Q|"E_PBS@HI.M".ts - "EPS@HI.M".ts - "EMA@HI.M".ts|
"EMN@HI.M".ts_eval= %Q|"EMN@HI.M".ts.load_sa_from("/Volumes/UHEROwork/data/bls/seasadj/sadata.xls").trim("1990-01-01","2006-12-01")|
"EMN@HI.M".ts_eval= %Q|"EMNSA@HI.M".ts|
#"EMN@HI.M".ts_eval= %Q|"EMN@HI.M".ts.apply_seasonal_adjustment :multiplicative|
"EIF@HI.M".ts_eval= %Q|"EIF@HI.M".ts.load_sa_from "/Volumes/UHEROwork/data/bls/seasadj/sadata.xls"|
"EIF@HI.M".ts_eval= %Q|"EIF@HI.M".ts.apply_seasonal_adjustment :additive|
"EFI@HI.M".ts_eval= %Q|"E_FIR@HI.M".ts - "ERE@HI.M".ts|
"EAG@HI.M".ts_eval= %Q|"EAG@HI.M".tsn.load_sa_from "/Volumes/UHEROwork/data/bls/seasadj/sadata.xls"|
"E_TRADE@HI.M".ts_append_eval %Q|"EWT@HI.M".ts + "ERT@HI.M".ts|
"E_TU@HI.M".ts_eval= %Q|"E_TTU@HI.M".ts - "E_TRADE@HI.M".ts|
"E_NF@HI.M".ts_append_eval %Q|"E_NFSA@HI.M".ts.trim("1957-12-01","1989-12-01")|
"E_NF@HI.M".ts_append_eval %Q|"ECT@HI.M".ts + "EMN@HI.M".ts + "E_TTU@HI.M".ts + "EIF@HI.M".ts + "E_FIR@HI.M".ts + "E_PBS@HI.M".ts + "E_EDHC@HI.M".ts + "E_LH@HI.M".ts + "EOS@HI.M".ts + "EGV@HI.M".ts|
"E_PR@HI.M".ts_append_eval %Q|"E_NF@HI.M".ts - "EGV@HI.M".ts|
["EAG", "ECT", "EWT","ERT", "EED", "EHC", "EOS", "EGVST", "EGVLC", "EGVFD", "EAE", "ERE", "EPS", "EAFAC", "EAFFD", "EMA", "EAD", "EMN", "EIF", "EFI", "E_TU"].each do |s_name|
["HON", "HAW", "MAU", "KAU"].each do |county|
puts "distributing #{s_name}, #{county}"
"#{s_name}@#{county}.M".ts_eval= %Q|"#{s_name}@HI.M".ts.aa_state_based_county_share_for("#{county}").trim("1990-01-01")|
end
end
#this might repeat what's above?
"EGVST@HI.M".ts_eval= %Q|"EGVST@HI.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EGVFD@HI.M".ts_eval= %Q|"EGVFD@HI.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EGVFD@HON.M".ts_eval= %Q|"EGVFD@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EGVST@HON.M".ts_eval= %Q|"EGVST@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EGVLC@HON.M".ts_eval= %Q|"EGVLC@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EMN@HON.M".ts_eval= %Q|"EMN@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"ECT@HON.M".ts_eval= %Q|"ECT@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EAFAC@HON.M".ts_eval= %Q|"EAFAC@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EAFFD@HON.M".ts_eval= %Q|"EAFFD@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"ERE@HON.M".ts_eval= %Q|"ERE@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EFI@HON.M".ts_eval= %Q|"EFI@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"E_TU@HON.M".ts_eval= %Q|"E_TU@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
"EHC@HON.M".ts_eval= %Q|"EHC@HON.M".tsn.load_from "/Volumes/UHEROwork/data/rawdata/History/bls_sa_history.xls"|
["HON", "HAW", "MAU", "KAU"].each do |county|
puts county
"E_GVSL@#{county}.M".ts_append_eval %Q|"EGVST@#{county}.M".ts + "EGVLC@#{county}.M".ts|
"EGV@#{county}.M".ts_eval= %Q|"EGV@HI.M".ts.aa_state_based_county_share_for("#{county}").trim("1959-12-01","1989-12-01")|
"EGV@#{county}.M".ts_append_eval %Q|("EGVFD@#{county}.M".ts + "E_GVSL@#{county}.M".ts).trim("1990-01-01")|
"EAF@#{county}.M".ts_eval= %Q|"EAFAC@#{county}.M".ts + "EAFFD@#{county}.M".ts|
"E_LH@#{county}.M".ts_append_eval %Q|"EAE@#{county}.M".ts + "EAF@#{county}.M".ts|
"E_EDHC@#{county}.M".ts_append_eval %Q|"EED@#{county}.M".ts + "EHC@#{county}.M".ts|
"E_PBS@#{county}.M".ts_append_eval %Q|"EPS@#{county}.M".ts + "EMA@#{county}.M".ts + "EAD@#{county}.M".ts|
"E_FIR@#{county}.M".ts_append_eval %Q|"EFI@#{county}.M".ts + "ERE@#{county}.M".ts|
"E_TRADE@#{county}.M".ts_append_eval %Q|"EWT@#{county}.M".ts + "ERT@#{county}.M".ts|
"E_TTU@#{county}.M".ts_append_eval %Q|"E_TU@#{county}.M".ts + "E_TRADE@#{county}.M".ts|
"E_GDSPR@#{county}.M".ts_append_eval %Q|"ECT@#{county}.M".ts + "EMN@#{county}.M".ts|
"E_NF@#{county}.M".ts_append_eval %Q|"E_NF@HI.M".ts.aa_state_based_county_share_for("#{county}").trim("1960-01-01","1989-12-01")|
"E_NF@#{county}.M".ts_append_eval %Q|"ECT@#{county}.M".ts + "EMN@#{county}.M".ts + "E_TTU@#{county}.M".ts + "EIF@#{county}.M".ts + "E_FIR@#{county}.M".ts + "E_PBS@#{county}.M".ts + "E_EDHC@#{county}.M".ts + "E_LH@#{county}.M".ts + "EOS@#{county}.M".ts + "EGV@#{county}.M".ts|
"E_PR@#{county}.M".ts_append_eval %Q|"E_NF@#{county}.M".ts - "EGV@#{county}.M".ts|
"E_SVCPR@#{county}.M".ts_append_eval %Q|"E_NF@#{county}.M".ts - "E_GDSPR@#{county}.M".ts|
"E_PRSVCPR@#{county}.M".ts_append_eval %Q|"E_SVCPR@#{county}.M".ts - "EGV@#{county}.M".ts|
end
["HON", "HAW", "MAU", "KAU"].each do |cnty|
"EAG@#{cnty}.Q".ts_eval= %Q|"EAG@#{cnty}.M".ts.aggregate(:quarter, :average)|
["M", "Q", "A"].each do |f|
"E@#{cnty}.#{f}".ts_eval = %Q|"EAG@#{cnty}.#{f}".ts + "E_NF@#{cnty}.#{f}".ts|
end
end
["ETW", "EUT"].each do |pre|
"#{pre}@HI.M".ts_eval= %Q|(("#{pre}NS@HI.M".ts.backward_looking_moving_average / "E_TUNS@HI.M".ts.backward_looking_moving_average) * "E_TU@HI.M".ts).trim|
"#{pre}@HON.M".ts_eval= %Q|(("#{pre}NS@HON.M".ts.backward_looking_moving_average / "E_TUNS@HON.M".ts.backward_looking_moving_average) * "E_TU@HON.M".ts).trim|
"#{pre}@HI.M".ts_eval= %Q|("#{pre}@HI.A".ts / "E_TU@HI.A".ts).fill_interpolate_to(:month) * "E_TU@HI.M".ts|
"#{pre}@HON.M".ts_eval= %Q|("#{pre}@HON.A".ts / "E_TU@HON.A".ts).fill_interpolate_to(:month) * "E_TU@HON.M".ts|
"#{pre}@HI.Q".ts_eval= %Q|"#{pre}@HI.M".ts.aggregate(:quarter, :average)|