C6: field6_list_full.csv
---------------------------------------------------------
TypeNo Type             size     Row_end  order  Selection function      
---------------------------------------------------------
0      APOGEE           129      129      V sort (0.5<(J-K))&(logg<3.8)
1      RAVE             607      736      V sort 
3      MISC             5        741      V sort Metal poor stars by Josh Simon
10     2MASS Main       7630     8371     V sort (0.5<(J-K))&(9<V(J,K)<=15.0) 


C7: field7_list_full.csv
---------------------------------------------------------
TypeNo Type             size     Row_end  order  Selection function      
---------------------------------------------------------
0      APOGEE           222      222      V sort (0.5<(J-K))&(logg<3.8)
3      MISC             23       245      V sort Josh Simon NGC6717, 3 without epic id
10     2MASS Main       1692     1937     V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
11     2MASS Main       1443     3380     V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
12     2MASS Main       1385     4765     V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
13     2MASS Main       2160     6925     V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
14     2MASS Main       2189     9114     V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
15     2MASS Main       1710     10824    V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
16     2MASS Main       1733     12557    V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
17     2MASS Main       2579     15136    V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
18     2MASS Main       1214     16350    V sort (0.5<(J-K))&(9<V(J,K)<=14.5) 
19     2MASS Main       2384     18698    V sort (0.5<(J-K))&(9<V(J,K)<=14.5)

Following 3 without epic id by Josh Simon NGC6717 put at top in xls file but does not exist 
in field7_list_full.csv file.

object        ra        dec       Kp     cadence  comment
stello_srgb11 283.77046 -22.67208 14.554 30       not in EPIC Kp is V mag
stello_rgb16  283.78189 -22.69003 14.415 30       not in EPIC Kp is V mag
stello_rgb24  283.79672 -22.68131 13.923 30       not in EPIC Kp is V mag


Number counts and giant fractions
--------------------------------------------------------------------------------------------
The numbers given below are for 2MASS stars in 8 deg radius of the field center.
The columns gf(vc), gf(<vc), mf(v<c) show predictions using the code GALAXIA.
(Sharma et al 2011, http://adsabs.harvard.edu/abs/2011ApJ...730....3S, http://galaxia.sourceforge.net)

v1,v2           : mag range for the specified band
n(v)            : stars with (v>v1)&(v<v2)
n(v,c)          : stars with (v>v1)&(v<v2)&((J-K)>0.5)
n(<v) or n(<vc) : are corresponding cumulative numbers
n1d(<vc)        : average cumulative number of stars per 1 deg radius region with (v>v1)&(v<v2)&((J-K)>0.5)
n1d(<v)         : average cumulative number of stars per 1 deg radius region with (v>v1)&(v<v2)
gf(vc)          : giant fraction of stars with (v>v1)&(v<v2)&((J-K)>0.5)
gf(<vc)         : cumulative giant fraction of stars with (v>v1)&(v<v2)&((J-K)>0.5)
mf(<vc)         : cumulative M dwarf fraction with (v>v1)&(v<v2)&((J-K)>0.5)
ns(<vc)         : (On silica)&(twomass_qual_flag=True)&(v>v1)&(v<v2)&((J-K)>0.5)
ncs(<vc)        : (On silica)&(twomass_qual_flag=True)&(in 1 deg circles)&(v>v1)&(v<v2)&((J-K)>0.5)
-------------------------------------------------------------------------------------------------

Campaign-6
Using V(J,K)
     v1      v2      Kp  n(v,c)    n(v) n(<v,c)   n(<v) n1d(<vc) n1d(<v)  gf(vc) gf(<vc) mf(<vc) ns(<vc) ncs(<vc)
   9.00    9.25    8.76      56     115      56     115       0       1    0.99    0.99    0.00      23      14
   9.25    9.50    9.04      61     134     117     249       1       3    0.95    0.97    0.00      53      32
   9.50    9.75    9.26      70     152     187     401       2       6    0.94    0.95    0.00      87      51
   9.75   10.00    9.51      75     179     262     580       4       9    0.97    0.96    0.00     129      74
  10.00   10.25    9.75     105     202     367     782       5      12    0.94    0.95    0.00     186     105
  10.25   10.50   10.03     116     269     483    1051       7      16    0.97    0.96    0.00     237     125
  10.50   10.75   10.27     146     355     629    1406       9      22    0.95    0.96    0.00     307     163
  10.75   11.00   10.52     177     439     806    1845      12      28    0.94    0.95    0.00     383     189
  11.00   11.25   10.79     220     559    1026    2404      16      37    0.90    0.94    0.00     470     225
  11.25   11.50   11.04     293     693    1319    3097      20      48    0.90    0.93    0.00     602     297
  11.50   11.75   11.31     332     820    1651    3917      25      61    0.88    0.92    0.00     766     379
  11.75   12.00   11.57     407    1003    2058    4920      32      76    0.82    0.91    0.00     959     475
  12.00   12.25   11.83     467    1209    2525    6129      39      95    0.82    0.89    0.00    1187     596
  12.25   12.50   12.08     521    1379    3046    7508      47     117    0.78    0.87    0.00    1445     721
  12.50   12.75   12.33     660    1761    3706    9269      57     145    0.75    0.85    0.01    1745     884
  12.75   13.00   12.58     721    2029    4427   11298      69     176    0.68    0.83    0.01    2083    1076
  13.00   13.25   12.84     845    2311    5272   13609      82     212    0.63    0.79    0.01    2488    1302
  13.25   13.50   13.10     988    2756    6260   16365      97     256    0.59    0.76    0.01    2960    1552
  13.50   13.75   13.35    1167    3204    7427   19569     116     306    0.55    0.73    0.01    3541    1844
  13.75   14.00   13.60    1336    3789    8763   23358     137     365    0.53    0.70    0.01    4213    2198
  14.00   14.25   13.85    1591    4437   10354   27795     162     434    0.47    0.67    0.01    4945    2578
  14.25   14.50   14.10    1881    5025   12235   32820     191     513    0.42    0.63    0.02    5845    3051
  14.50   14.75   14.35    2363    6083   14598   38903     228     608    0.36    0.59    0.02    7011    3715
  14.75   15.00   14.60    2729    6946   17327   45849     271     717    0.30    0.54    0.03    8332    4430

Campaign-7
Using V(J,K)
     v1      v2      Kp  n(v,c)    n(v) n(<v,c)   n(<v) n1d(<vc) n1d(<v)  gf(vc) gf(<vc) mf(<vc) ns(<vc) ncs(<vc)
   9.00    9.25    8.75     111     234     111     234       1       3    1.00    1.00    0.00      68      35
   9.25    9.50    9.00     156     331     267     565       4       8    0.99    0.99    0.00     149      74
   9.50    9.75    9.26     239     439     506    1004       7      15    0.99    0.99    0.00     256     137
   9.75   10.00    9.48     289     550     795    1554      12      24    0.98    0.99    0.00     395     222
  10.00   10.25    9.74     380     683    1175    2237      18      35    0.99    0.99    0.00     577     309
  10.25   10.50    9.97     557     967    1732    3204      27      50    0.99    0.99    0.00     859     448
  10.50   10.75   10.25     703    1277    2435    4481      38      70    0.99    0.99    0.00    1166     605
  10.75   11.00   10.48     840    1624    3275    6105      51      95    0.98    0.99    0.00    1560     820
  11.00   11.25   10.71    1175    2141    4450    8246      69     129    0.99    0.99    0.00    2104    1101
  11.25   11.50   10.98    1635    2897    6085   11143      95     174    0.98    0.99    0.00    2885    1529
  11.50   11.75   11.23    2210    3840    8295   14983     129     234    0.98    0.98    0.00    3980    2126
  11.75   12.00   11.48    2787    4859   11082   19842     173     310    0.97    0.98    0.00    5288    2825
  12.00   12.25   11.72    3568    6261   14650   26103     229     408    0.97    0.98    0.00    6944    3714
  12.25   12.50   11.97    4645    8047   19295   34150     301     534    0.97    0.98    0.00    9142    4937
  12.50   12.75   12.22    6023   10310   25318   44460     396     695    0.97    0.97    0.00   12015    6442
  12.75   13.00   12.47    7594   13178   32912   57638     515     902    0.96    0.97    0.00   15546    8365
  13.00   13.25   12.72    9630   16718   42542   74356     665    1163    0.96    0.97    0.00   20115   10806
  13.25   13.50   12.98   12136   21091   54678   95447     855    1493    0.95    0.97    0.00   25770   13909
  13.50   13.75   13.23   15334   26667   70012  122114    1095    1911    0.95    0.96    0.00   32940   17763
  13.75   14.00   13.49   19458   33792   89470  155906    1400    2439    0.94    0.96    0.00   41948   22623
  14.00   14.25   13.76   24727   42624  114197  198530    1787    3106    0.93    0.95    0.00   53248   28752
  14.25   14.50   14.02   31177   53128  145374  251658    2275    3938    0.92    0.95    0.00   67320   36391
  14.50   14.75   14.30   39263   66403  184637  318061    2889    4977    0.91    0.94    0.00   84856   45939
  14.75   15.00   14.57   49802   83519  234439  401580    3668    6284    0.90    0.93    0.00  106513   57634