tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d2229c45-2c66-4688-8e47-594858c8307e
Sheet: 2013 Sales

Vehicle Sales BMW of North America, LLC, December 2013
 | Dec. 2013 | Dec. 2012 | % | YTD Dec. 2013 | YTD Dec. 2012 | %
1 Series | 1039 | 757 |  | 7220 | 7689
3/4 Series | 16737 | 10745 |  | 119521 | 99602
Z4 | 191 | 324 |  | 2480 | 2751
5 Series | 8102 | 8385 |  | 56863 | 56798
6 Series | 1078 | 1037 |  | 9762 | 8208
7 Series | 1119 | 1422 |  | 10932 | 11098
X1 | 2741 | 2806 |  | 26512 | 8947
BMW passenger cars
X3 | 3707 | 5162 |  | 30623 | 35173
X5 | 1953 | 5722 |  | 39818 | 44445
X6 | 722 | 1039 |  | 5549 | 6749
BMW light trucks
BMW brand
Cooper /S Hardtop | 2995 | 3011 |  | 26954 | 29278
Cooper /S Convertible | 262 | 325 |  | 4460 | 4813
Cooper /S Clubman | 379 | 445 |  | 5155 | 5769
Coupe | 117 | 178 |  | 2540 | 2880
Roadster | 134 | 273 |  | 2806 | 2371
Countryman | 2055 | 2224 |  | 21325 | 21012
Paceman | 650 | 0 | 1 | 3262 | 0 | 1
MINI brand
TOTAL BMW of North America, LLC
Spreadsheet: 1ff7e134-f68c-4b02-8db9-aa1518392869
Sheet: Sheet1

ALCALDIA MUNICIPAL DE PASTO | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
SECRETARIA DE HACIENDA - SUBSECRETARIA DE INGRESOS
TABLA GENERAL DE ACTIVIDADES, TARIFAS Y BASES
IMPUESTO DE INDUSTRIA Y COMERCIO AÑO 2010
ACTIVIDAD INDUSTRIAL *  SI SE [NAME] FUERA DEL MUNICIPIO DE PASTO, NO DEBEN PRACTICARSE RETENCIONES DE ICA
CODIGO | ACTIVIDAD | TARIFA POR MIL | BASE
101 | Industria de alimentos | 2.5 | 663000
102 | Industria de bebidas y refrescos que no contienen alcohol | 6.0 | 663000
103 | [NAME], cuero, textiles, químicosPlásticos, caucho. | 3.0 | 663000
104 | Industria litográfica, tipográfica y conexa. Industrial, metal mecánica, maquinaria y equipos industriales, profesionales y científicos. | 4.0 | 663000
105 | [NAME] | 5.0 | 663000
106 | Actividades industriales y agrícolas | 3.5 | 663000
107 | Industria de bebidas que contienen alcohol | 7.0 | 663000
108 | Generación de energía eléctrica | S/n. Art.7 Ley 56/1981
109 | Demás actividades industriales no clasificadas en este artículo | 6.0 | 663000
ACTIVIDAD COMERCIAL
CODIGO | ACTIVIDAD | TARIFA POR MIL | BASE
201 | Ventas de alimentos y productos agrícolas; drogas y medicamentos, textos escolares y libros, (incluye cuadernos escolares), [NAME] y materiales [NAME] y ferreterías, cuyos ingresos brutos no excedan los 5.800 salarios mínimos mensuales legales vigentes. | 3.0 | 663000
202 | Ventas de alimentos y productos agrícolas; drogas y medicamentos; textos escolares y libros (incluye cuadernos escolares); [NAME] madera y materiales [NAME] y ferreterías, cuyos ingresos brutos excedan los 5.801 salarios mínimos mensuales legales vigentes. | 5.0 | 663000
203 | Cuero, prendas de vestir y artículos eléctricos | 4.0 | 663000
204 | [NAME], licores y joyas | 10.0 | 663000
205 | Relojería | 3.0 | 663000
206 | [NAME] y accesorios automotores | 4.0 | 663000
207 | Artículos electrodomésticos | 5.0 | 663000
208 | [NAME], accesorios y repuestos | 6.0 | 663000
209 | [NAME] | 10 | 663000
210 | Ventas de tenderos no exonerados | 6 | 663000
211 | Demás actividades comerciales no clasificadas en este artículo | 6 | 663000
ACTIVIDAD DE SERVICIOS
CODIGO | ACTIVIDAD | TARIFA POR MIL | BASE
301 | Servicios de notariado y registro | 10 | 98000
302 | [NAME] urbanas | 10.0 | 98000
303 | Servicios de consultoría, mantenimiento y reparación, Transmisión y conexión de energía eléctrica | 5 | 98000
304 | Sitios de diversión nocturna y moteles | 10.0 | 98000
305 | Servicios de educación en los niveles preescolares, primarios secundario básica y media; pre-grado en los niveles técnico, tecnológico y profesional; y postgrado en los niveles de especialización, masterado y doctorado, prestados en establecimientos de carácter privado, de organizaciones con o sin ánimo de lucro. | 5 | 98000
306 | Servicios de restaurante, expendio de comidas, y bebidas no alcohólicas y cafés | 6 | 98000
307 | Demás actividades de servicios no clasificadas en este artículo | 6 | 98000
MARIA ESPERANZA ESTRADA LOPEZ
SUBSECRETARIA DE INGRESOS
Spreadsheet: 759008d1639227905-data-split-blank-lines-issue-data-split-example
Sheet: NOT For Markout

 | LX | [NAME] | -43000 | 4500 | 1T | 280 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | -16500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | -4500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | -1500 | 1T | 630 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | 1500 | 1T | 630 | 0 | 18M | 25M
 | LX | [NAME] 1 | 9500 | 7500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] | 7750 | -16500 | 1T | 160 | 0 | 18M | 25M
 | LX | [NAME] | 7750 | -13500 | 1T | 160 | 0 | 18M | 25M
Spreadsheet: 271984d1382123513-if-then-sales-specialist-weekly-tracking2
Sheet: WEEK 2

SALES SPECIALIST ACTIVITY TRACKING
Associate
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN | 09:30:00 | Competitor Brands
Time OUT | 10:25:00
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
SALES SPECIALIST ACTIVITY TRACKING
Associate
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN | 09:30:00 | Competitor Brands
Time OUT | 10:25:00
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Date |  | Overall Traffic |  | Wins | Misses | General Feedback
Store |  | Sales $
Location |  | Inventory
Time IN |  | Competitor Brands
Time OUT
Total Hours
Spreadsheet: 769091d1645285121-adding-extra-spaces-in-a-cell-separating-data-from-a-single-cell-aligw-xlsx-version-1-
Sheet: Sheet3

 | 73.29 BF2192 Brown-line Bright-eye [NAME] conigera
 | 73.291 BF2199 [NAME] Mythimna pallens
 | 73.292 BF2200 [NAME]'s Wainscot [NAME] favicolor
 | 73.293 BF2198 [NAME] [NAME] impura
 | 73.294 BF2197 Southern Wainscot [NAME] straminea
 | 73.295 BF2195 The Delicate [NAME] vitellina
 | 73.296 BF2203 White-speck [NAME] unipuncta
 | 73.297 BF2194 White-point [NAME] albipuncta
 | 73.298 BF2193 The Clay Mythimna ferrago
 | 73.299 BF2201 Shore Wainscot [NAME] litoralis
 | 73.3 BF2202 L-album Wainscot Mythimna l-album
 | [NAME] Shoulder-striped [NAME] Leucania comma
 | 73.302 BF2204 Obscure Wainscot Leucania obsoleta
 | 73.303 BF2206 [NAME] Leucania putrescens
 | 73.3031 BF2210 The Maori Graphania averilla [NAME]
Spreadsheet: 199020d1355037566-if-nested-function-or-any-other-function-which-can-repeat-process-again-and-again-assignment
Sheet: Sheet1

Name | Assignment
A | 50 | A | For example I want to Assign name "A" in cloumn "C" in front of value sum equal to 89 and once name "A" is assigned then it repeats the action again and then Name "B" assign and continues till the process assigned all the Names of the Column A in Column C
B | 20 | A
C | 30 | A
D | 40 | B
E | 60 | B
F | 70 | C
G | 300 | C
H | 460 | D
I | 240 | E
J | 200 | F
K | 2 | G
 | 3 | G
 | 4 | G
 | 5 | G
 | 6 | G
 | 7 | G
 | 87 | G
 | 8 | H
 | 9 | H
 | 50 | H
 | 20 | H
Spreadsheet: 85029d1285099134-lookup-function-in-row-not-functioning-college-application-summ-09-21-10-fs
Sheet: Sheet1

University of California, Berkeley | Student | Wave | ID | Program Option Name 1 | Program Option Status 1 | Program Option Name 2 | Program Option Status 2 | Program Option Name 3 | Program Option Status 3 | Program Option Name 4 | Program Option Status 4 | Program Option Name 5 | Program Option Status 5 | Program Option Name 6 | Program Option Status 6 | Program Option Name 7 | Program Option Status 7 | Program Option Name 8 | Program Option Status 8 | Program Option Name 9 | Program Option Status 9 | Program Option Name 10 | Program Option Status 10 | Program Option Name 11 | Program Option Status 11
 | Aa, Testing AA | X | 999976 |  |  | University of California, Berkeley |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | University of the Pacific
 | Aa, Testing AB | 7 | 10701 | University of California, Berkeley | Denied | University of California, Los Angeles | Accepted - No Scholarship | University of California, [NAME] | Accepted - No Scholarship | University of California, Riverside | Accepted - No Scholarship | University of California, Santa Barbara | Accepted - No Scholarship | Occidental College | 1 Please Select | University of Puget Sound | Accepted - No Scholarship | Santa Clara University | 1 Please Select | Whittier College | Accepted - No Scholarship | University of the Pacific | Accepted - No Scholarship | 1 Please Select | 1 Please Select |  |  |  |  |  |  |  |  |  | University of California, Berkeley
 | Aa, Testing AC | 5 | 10501 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | University of California, Riverside
 | Aa, Testing AD | 5 | 10502 |  |  | University of California, Berkeley |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | University of California, [NAME]
 | Aa, Testing AE | 5 | 10503 |  |  |  |  |  | University of California, Berkeley
 | Aa, Testing AF | 6 | 10601
Spreadsheet: 848262d1699015121-formula-to-capture-attendance-login-shift-adherence-1-
Sheet: Attendance (Shift Adherence)

 |  |  |  | Expected Results
Date | Agent Name | Agent ID | Shift Start Time | [NAME] | Last Logout Time | Attendance | Delayed By | Total [NAME] | Off Login Hrs
2023-09-27 00:00:00 | A | 1234 | 10:00:00
2023-09-28 00:00:00 | A | 1234 | 10:00:00
2023-09-27 00:00:00 | C | 2345 | 17:30:00
2023-09-27 00:00:00 | D | 6789 | 10:30:00
2023-09-27 00:00:00 | E | 1000 | 11:00:00
Spreadsheet: 525459d1498740822-return-single-value-by-searching-multiple-criteria-in-multiple-column-ramesh
Sheet: INWARD

S NO | DATE | SELLER NAME | BRAND NAME | PRODUCT NAME | [NAME] | SIZE | COLOUR | PAGES | QUANITY | UNIT | Product Code
1 | 2017-06-01 00:00:00 | PANDIYAN | TNPL | A4 SHEET | GSM | 70 | NA | 500 | 5 | BUNDLE
2 | 2017-06-01 00:00:00 | PANDIYAN | TNPL | A4 SHEET | GSM | 75 | NA | 500 | 6 | BUNDLE
3 | 2017-06-01 00:00:00 | KAND | CAMLIN | PEN | GH | NA | YH | NA | 500 | NOS
4 | 2017-06-01 00:00:00 | PANDIYAN | CLASSMATE | NOTE | SPIRAL | 12X14 | GREEN | 80 | 200 | NOS
5 | 2017-06-05 00:00:00 | KAND | TNPL | A4 SHEET | GSM | 75 | NA | 500 | 2 | BUNDLE
6 | 2017-06-05 00:00:00 | ESWAR | CAMLIN | PEN | GH | NA | YH | NA | 400 | NOS
7 | 2017-06-08 00:00:00 | ESWAR | CASIO | CALC | MJ3 | NA | NA | NA | 5 | NOS
8 | 2017-06-08 00:00:00 | ESWAR | CAMLIN | PEN | GH | NA | YH | NA | 200 | NOS
9
10
11
12
13
14
15
Spreadsheet: 870526d1717023590-arrange-values-associated-with-xy-coordinates-in-a-serpentine-fashion-ex
Sheet: Sheet1

Value | Y coordinate | X coordinate
1 | 1 | 31
10 | 2 | 31
11 | 3 | 31
20 | 4 | 31
21 | 5 | 31
30 | 6 | 31
31 | 7 | 31
40 | 8 | 31
41 | 9 | 31
30 | 10 | 31
31 | 10 | 32
2 | 1 | 33
9 | 2 | 33
12 | 3 | 33
19 | 4 | 33
22 | 5 | 33
29 | 6 | 33
32 | 7 | 33
39 | 8 | 33
42 | 9 | 33
49 | 10 | 33
3 | 1 | 35
8 | 2 | 35
13 | 3 | 35
18 | 4 | 35
23 | 5 | 35
28 | 6 | 35
33 | 7 | 35
38 | 8 | 35
43 | 9 | 35
48 | 10 | 35
4 | 1 | 37
7 | 2 | 37
14 | 3 | 37
17 | 4 | 37
24 | 5 | 37
27 | 6 | 37
34 | 7 | 37
37 | 8 | 37
44 | 9 | 37
47 | 10 | 37
5 | 1 | 39
6 | 2 | 39
15 | 3 | 39
16 | 4 | 39
25 | 5 | 39
26 | 6 | 39
35 | 7 | 39
36 | 8 | 39
45 | 9 | 39
46 | 10 | 39
Spreadsheet: 182685d1348579758-three-month-average-calculation-in-pivot-table-testfile
Sheet: Summary

Sum of Amount | Column Labels
Row Labels | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00
Depreciation | 28649.11419903181 | 4604.437991019538 | 73077.59585125318 | 6670.602029425266 | 30649.45279439872
Rental | 94127.47905982613 | 47268.0918445499 | 9150.394137334672 | 5359.684492823857 | 28222.2693371893
Salaries | 94112.1872282393 | 96678.2671702977 | 37649.4889863662 | 95303.15753487001 | 63208.80905888854
Travel | 14263.16814068018 | 38348.16393004462 | 37074.24215773532 | 53099.78452326256 | 27488.01349157175
Wages | 90407.2559910037 | 63353.37118809511 | 55956.51860803832 | 63463.49635836927 | 76682.89024105854
Grand Total | 321559.2046187811 | 250252.3321240068 | 212908.2397407277 | 223896.724938751 | 226251.4349231069
Spreadsheet: 720381d1614128476-filter-formula-to-pull-data-from-matching-range-group-filter-group-example
Sheet: DATA TEST

 | CLASS 1 |  |  | CLASS B |  |  | CLASS 4 |  |  | CLASS G
 | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA
 | [NAME] | 50 | PASS | SAM | 550 | PASS | [NAME] | 51 | PASS | JAKE | 551 | FAIL
 | TOM | 300 | FAIL | WILL | 270 | PASS | FRANK | 301 | FAIL | JENNY | 271 | FAIL
 | BILL | 25 | FAIL | BOB | 15 | PASS | [NAME] | 26 | FAIL | WILMA | 16 | PASS
 | FRED | 250 | FAIL | TOM | 275 | PASS | PAT | 251 | PASS | OLGA | 276 | FAIL
 | SUE | 5 | PASS | [NAME] | 25 | FAIL | [NAME] | 6 | PASS | EUGENE | 26 | PASS
 | [NAME] | 250 | FAIL | HARRY | 50 | PASS | FRED | 251 | PASS | HARRY | 51 | PASS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CLASS: | CLASS 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME: | TOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORE:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRITERIA:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CLASS: | CLASS 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME: | TOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORE: | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRITERIA: | FAIL
Spreadsheet: 57691d1257906006-excel-2007-insert-shapes-based-on-values-symbols-using-fonts
Sheet: Sheet3

Incell Bar Charts
Created by Pointy Haired Dilbert - Chandoo.org, Feel free to change, copy, share or save
 | Change from previous year
 | Category | Jan | Feb | Mar | Apr | May | Jun | Chart |  |  |  |  |  |  |  | Chart character
 | Excel | -10 | 10 | 15 | -8 | 6 | 4 |  |  |  |  |  |  |  |  | _
Created by Pointy Haired Dilbert - Chandoo.org, Feel free to change, copy, share or save
Spreadsheet: darrell_schoolcraft__7726__2002 SJ Outages2
Sheet: April - May

SAN JUAN AREA ANNUAL OUTAGE MEETING SUMMARY
MARCH 7, 2002
April, 2002 |  |  |  |  | May, 2002
 |  |  | Affected Vol. |  |  |  | Affected Vol.
 | Date | Location | (MMcf/d) |  | Date | Location | (MMcf/d)
TW | 2 - 5 | LaPlata | 500 |  | 15 | San Juan outage  D/R | 625
 | 8 - 11 | Bloomfield | 225 |  | 2 - 6 | Sta. 8 - 7 Excavations | ?
 | 11 - 12 | Bisti | 150 |  | 8 - 18 | Sta. 5-4 Excavations | ?
 | 11 - 13 | Gallup | 150 |  | 19 - 24 | Sta. 7-6 Excavations | ?
El Paso | 15 - 19 | Seligman ESD | 100 |  | 1 | [NAME] | 200
 | 17 - 19 | L1300 Dummy BWA-LAG | 500 |  | 14 | L1208 [NAME] | 360
 | 22 | [NAME] | 150 |  | 14 | Bondad | 585
 | 23 | L1300 Vcity - BW | 500 |  | 14 | Gallup | 250
 | 30 | [NAME] | 200 |  | 16 - 17 | L1208 | 150
 |  |  |  |  | 21 | L1208 | 150
WFS | 8 - 9 | [NAME] | 55 |  | 7 - 8 | Milagro | 420
 |  |  |  |  | 14 - 15 | [NAME] | 450
PNM | None Scheduled |  |  |  | 5 | Rio Puerco | 40
 |  |  |  |  | 21 | Rio Puerco | 40
 |  |  |  |  | 29 | Rio Puerco | 40
EPFS | 17 -19 | Chaco   (Delete) | 450-500
Burlington | None Scheduled
Spreadsheet: 716915d1612421977-count-the-ordered-frequency-sequence-of-0-and-1-test
Sheet: Tabelle1

 |  |  |  |  |  | January | Februari | Mars | April | Maj | Juni | [NAME] | Augusti | September | Oktober | November | December |  | Preffered Output
 |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 2 | 3 | 6 | 1
 |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  | 1 | 6 | 5
 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 12
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |  | 4 | 5 | 3
Spreadsheet: 001811a1-f6f9-4fa4-bc7a-4b6c4ad2b476
Sheet: Sheet1

Majority (Repub) | Minority (Dem)
Chairman [NAME] (KY-05) | Ranking Member [NAME] (NY-18)
[NAME] (FL-13) | [NAME] (OH-09)
[NAME] (VA-10) | [NAME] (IN-01)
[NAME] (GA-01) | [NAME] (NY-15)José Serrano (NY-15)
[NAME] (NJ-11) | [NAME] (CT-03)
[NAME] (IA-03) | [NAME] (VA-01)
[NAME] (AL-04) | Ed Pastor (AZ-07)
[NAME] (MO-08) | [NAME] ([NAME])
[NAME]) | Lucille Roybal-Allard (CA-40)
[NAME] (ID-02) | [NAME] (CA-20)
[NAME] (TX-07) | [NAME] (PA-02)
[NAME] (FL-04) | [NAME], Jr. (GA-02)
[NAME] (TX-31) | [NAME] (CA-09)
[NAME] (LA-05) | [NAME] (CA-28)
[NAME] (CA-42) | [NAME] (CA-17)
[NAME] (AL-01) | [NAME] (MN-04)
[NAME] ([NAME]) | [NAME] (NY-03)
[NAME] (FL-25) | [NAME] (OH-13)
[NAME] (PA-15) | C.A. Dutch Ruppersberger (MD-02)
[NAME] (GA-14) | Debbie [NAME] (FL-23)
[NAME] ([NAME]) | [NAME] (TX-28)
[NAME] (AR-03) | [NAME] (ME-01)
[NAME] (MS-06) | [NAME] (IL-05)
[NAME] (NE-01) | [NAME] ([NAME])
[NAME] (FL-17)
[NAME] (TN-03)
[NAME] (WA-03)
[NAME] (OH-14)
[NAME] (21-CA)
Spreadsheet: 221105d1363367716-participant-data-calculations-and-logic-formula-help-needed-sample-excel-report
Sheet: Sheet1

Pass Member | Swipe-In | Hour | Visit Date | M/F | U'Code | Pass Types | Count | Year | Month | Week of Year | Day of Week | FY | Semester
SHIZUKA, DAIZABURO | 17:35:00 |  | 2012-10-25 00:00:00 | M |  | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
FUNK, [NAME]** | 17:48:00 |  | 2012-10-25 00:00:00 | M | GR | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
GARAI, MATTHEW** | 18:28:00 |  | 2012-10-25 00:00:00 | M | GR | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
[NAME], PATRICK** | 18:30:00 |  | 2012-10-25 00:00:00 | M | SO | 42000 (FALL WALKUP) | 1 |  |  |  |  | 2013 | Fall
SOLEM-PFEIFER, GRACE** | 18:30:00 |  | 2012-10-25 00:00:00 | F | SO | 42000 (FALL WALKUP) | 1 |  |  |  |  | 2013 | Fall
Smith, [NAME] | 21:28:00 |  | 2012-10-30 00:00:00 | M |  | 45200 (LEAD CLIMBING) | 1 |  |  |  |  | 2013 | Fall
Smith, ALEX** | 21:29:00 |  | 2012-10-30 00:00:00 | M | SR | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
[NAME], [NAME]** | 21:55:00 |  | 2012-10-30 00:00:00 | M | FR | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
OLSON, KEATON** | 14:00:00 |  | 2012-10-31 00:00:00 | M | JR | 45200 (LEAD CLIMBING) | 1 |  |  |  |  | 2013 | Fall
Hardin, CALEB** | 14:01:00 |  | 2012-10-31 00:00:00 | M | SR | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
ALLEN, [NAME]** | 14:01:00 |  | 2012-10-31 00:00:00 | M | JR | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
Meiser, [NAME]** | 16:22:00 |  | 2012-10-31 00:00:00 | M | CBA | 45100 (TOP ROPE CLIMB) | 1 |  |  |  |  | 2013 | Fall
 |  |  | Calculate |  | if participant utilized '4200 (fall walkup)' and within same semester purchased '45100 top rope climb' or greater pass
 |  |  |  |  |  | don't want to rely on pivot table since swipe data is added weekly
 |  |  |  |  |  | data runs back to 2007
 |  |  |  |  |  | end goal is to count total unique users who are 'converted' in to pass purchasers
Spreadsheet: 860788d1708781718-how-can-we-bring-max-and-second-max-values-to-mixed-table-on-different-sheet-mixed-product-list-dj
Sheet: mixed product list

 | Product Code | maximum order receiving quantity value | second maximum order receiving quantity value
 | a126
 | a128
 | a129
 | a124
 | a125
 | a123
 | a127
 | a130
 | a123
 | a124
 | a125
 | a123
 | a127
Spreadsheet: benjamin_rogers__1252__merchant peaker plants
Sheet: ENA Comps

 | [NAME]
 | Company | Location | Source | Article Date | Operation Date | MW's | Cost ($ 000) | Cost/kW ($ 000)
 | Indeck | Illinois | Co. Press Release | 2000-05-24 00:00:00 | 2001-06-01 00:00:00 | 700 | 250000
 | Indeck | Illinois | Co. Press Release | 2000-03-01 00:00:00 | N/A | 300 | 100000
 | Dynergy | Florida | Co. Press Release | 1999-12-06 00:00:00 | 2002-06-01 00:00:00 | 500 | N/A | N/A
 | Dynergy | Illinois | Co. Press Release | 1999-08-06 00:00:00 | 2000-07-01 00:00:00 | 310 | N/A | N/A
 | Dynergy | Lake Charles | Co. Press Release | 1999-07-23 00:00:00 | 2000-06-01 00:00:00 | 155 | 50000
 | Dynergy | North Carolina | Co. Press Release | 1999-06-08 00:00:00 | 2001-06-01 00:00:00 | 600 | N/A | N/A
 | Dynergy | Georgia | Co. Press Release | 1999-10-25 00:00:00 | 2001-07-01 00:00:00 | 500 | N/A | N/A
 | DPL | Ohio | Co. Press Release | 2000-01-31 00:00:00 | 2001-06-01 00:00:00 | 200 | 80000
 | DPL | Ohio | Co. Press Release | 2000-01-10 00:00:00 | 2001-06-01 00:00:00 | 160 | 50000
 | Entergy | Miss. | Co. Press Release | 2000-02-24 00:00:00 | 2001-06-01 00:00:00 | 300 | 140000
 | Entergy | Miss. | Co. Press Release | 1999-10-07 00:00:00 | 2002-06-01 00:00:00 | 500 | 190000
 | Standard Power & Light | Illinois | Generation Week | 2000-03-01 00:00:00 | N/A | 800 | 380000
 | Southwestern Elec. Coop. | Illinois | Megawatt Daily | 1999-12-06 00:00:00 | 2001-06-01 00:00:00 | 45 | 25000
 | Tenaska | Georgia | Co. Press Release | 1999-11-11 00:00:00 | 2001-06-01 00:00:00 | 936 | 410000
 | Reliant Energy | Virginia | Co. Press Release | 2000-03-03 00:00:00 | 2002-06-01 00:00:00 | 300 | N/A | N/A
 | Reliant Energy | Illinois | Co. Press Release | 2000-03-16 00:00:00 | 2000-06-01 00:00:00 | 340 | N/A | N/A
 | PPL Global | Pennsylvania | Electric Power Daily | 2000-05-26 00:00:00 | 2002-06-01 00:00:00 | 900 | 425000
 | Hoosier Energy/Williams | Indiana | N/A | N/A | N/A | 170 | 94000
 | [NAME] | Texas | Co. Press Release | N/A | 2001-06-01 00:00:00 | 178 | 93200
 | Average
Spreadsheet: d368afd3-18a5-4b93-8a7f-d5e9ea1db286
Sheet: Sheet1

2000 official [NAME] | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 693/693 - Total Ballots Cast: 94306
Downloaded at 5/18/2013 10:22:21 PM
 | Yes - | No -
Constitutional Measure No. 1: Relates to the membership of the State Board of Higher Education - | 46226 | 33385
TOTAL | 46226 | 33385
 | Yes - | No -
Constitutional Measure No. 2: Relates to the election of statewide executive officers. - | 49391 | 30431
TOTAL | 49391 | 30431
 | Yes - | No -
Constitutional Measure No. 3: Relates to the elimination of the State Treasurers Office. - | 38715 | 42734
TOTAL | 38715 | 42734
 | Yes - | No -
Constitutional Measure No. 4: Relates to the filling of legislative vacancies. - | 41058 | 38648
TOTAL | 41058 | 38648
Results provided by the Office of North Dakota Secretary of State