tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 464711d1465288510-returning-value-from-date-witin-give-period-of-time-example
Sheet: Sheet2

FROM | TO | BOXNUMBER | COMMENT
2007-03-01 00:00:00 | 2007-03-05 00:00:00 | RBITE01-000001 | SIM
2007-03-06 00:00:00 | 2007-03-09 00:00:00 | RBITE01-000002 | SIM
2007-03-10 00:00:00 | 2007-03-13 00:00:00 | RBITE01-000003 | SIM
2007-03-14 00:00:00 | 2007-03-17 00:00:00 | RBITE01-000004 | SIM
2007-03-18 00:00:00 | 2007-03-23 00:00:00 | RBITE01-000005 | SIM
2007-03-23 00:00:00 | 2007-03-27 00:00:00 | RBITE01-000006 | SIM
2007-03-28 00:00:00 | 2007-03-31 00:00:00 | RBITE01-000007 | REG
2007-04-01 00:00:00 | 2007-04-06 00:00:00 | RBITE01-000008 | REG
2007-04-07 00:00:00 | 2007-04-14 00:00:00 | RBITE01-000009 | REG
2007-04-15 00:00:00 | 2007-04-21 00:00:00 | RBITE01-000010 | REG
2007-04-22 00:00:00 | 2007-04-28 00:00:00 | RBITE01-000011 | REG
Spreadsheet: 180113d1347479897-delete-duplicates-and-adjacent-two-cells-book7
Sheet: Sheet1

2412712 | 25 | 13754 | 19030
2412912 | 31 | 13754 | 24624
2412913 | 32 | 13754 | 5678
2412912 | 33 | 13754 | 4525
2412912 | 22 | 13754 | 25215
2412912 | 25 | 13754 | 5423
2412912 | 31 | 13754 | 2512
2412912 | 32 | 13754 | 21513
2412912 | 33 | 13754 | 51523
2412912 | 22 | 13754 | 1264
Spreadsheet: 83602d1283559729-formula-or-macro-to-format-a-report-formatreport
Sheet: Sheet1

[NAME] | Date and Time Entered | OrderCode | Telephone | RID | Priority | Delivery Date | Cust Ref | Job No | Order Type | [NAME] | Action Status | Entered By | Reject Code and Reason |  | Postcode | CSS Project No | Appointment Date/Time
1 | 2010-09-03 16:40:32 | THU42457 | N/A | N/A | 1 | 2010-09-06 00:00:00 | 1234 | N/A | Common Low Volume Requests | In Progress | N/A | dattanibth | N/A |  | N/A | N/A | N/A
2 | 2010-09-03 15:30:49 | THU42456 | 12345678901 | CCZ | 1 | 2010-09-13 00:00:00 | 4567 | CBJWERJH | Wholesale Access Business Single Line New Provision | Approved | N/A | gajjarmat | N/A |  | ABCDEF | DSFDSJH | 13/09/2010 pm
3 | 2010-09-03 15:03:30 | [NAME] | 13240932434 | CCZ | 1 | 2010-09-14 00:00:00 | 177627 | N/A | Wholesale Access Multiline Aux Conversion | In Progress | N/A | th_y126488 | N/A |  | BCDEFG | N/A | N/A
4 | 2010-09-03 14:43:55 | THU42454 | 89343432432 | N/A | N/A | 2010-09-03 00:00:00 | 23433 | WERWERE | Digital System Change | Closed | N/A | dattanibth | N/A |  | CDEFGH | N/A | N/A
5 | 2010-09-03 14:00:39 | THU42453 | 23423432423 | N/A | 1 | 2010-09-27 00:00:00 | 43433 | N/A | Common Low Volume Requests | In Progress | N/A | punjakt | N/A |  | DEFGHI | N/A | N/A
6 | 2010-09-03 13:14:11 | THU42452 | 32423434324 | N/A | 1 | 2010-09-06 00:00:00 | 34434 | N/A | Common Low Volume Requests | In Progress | N/A | punjakt | N/A |  | EFGHIJ | N/A | N/A
7 | 2010-09-03 12:15:58 | THU42451 | N/A | CCZ | 1 | 2010-09-08 00:00:00 | 344343 | N/A | Wholesale Access Business Single Line New Provision | In Progress | N/A | dattanibth | N/A |  | FGHIJK | N/A | N/A
8 | 2010-09-03 11:15:12 | THU42450 | 55554353454 | N/A | 1 | 2010-09-27 00:00:00 | 324343 | N/A | Common Low Volume Requests | Rejected | N/A | punjakt | 48 | ISDN30 | GHIJKL | N/A | N/A
9 | 2010-09-03 10:36:10 | THU42449 | 6666666666 | CCZ | 1 | 2010-09-17 00:00:00 | 34343 | WERWERI | Wholesale Access Business Single Line New Provision | In Progress | N/A | gajjarmat | N/A |  | HIJKLM | DFDSFDF | [NAME] am
10 | 2010-09-03 10:21:43 | THU42448 | 8989898399 | N/A | 1 | 2010-09-06 00:00:00 | N/A | KOKWERWE | Wholesale ISDN30e Change | Approved | N/A | punjakt | N/A |  | IJKLMN | N/A | N/A
11 | 2010-09-03 09:31:20 | THU42447 | 7634673432 | N/A | 1 | 2010-09-03 00:00:00 | N/A | OIWERWWE | [NAME] | Effective | N/A | gajjarmat | N/A |  | JKLMNO | N/A | N/A
Total Number of Orders | Total Number of Pages |  | Orders to | Orders Displayed per Page
11 | 1 |  | 11 | 25
Page 1 of 1
Spreadsheet: 696847d1601005558-distinct-list-of-dates-from-the-large-list-based-on-criteria-uniquedate_chris
Sheet: Sheet1

Dates |  | Unique distinct list |  | Start date: |  | =MIN(C:C)
2009-01-04 00:00:00 |  |  |  | End date: |  | =MAX(C:C)
2009-01-05 00:00:00
2009-01-08 00:00:00
2009-01-10 00:00:00
2009-01-12 00:00:00
2009-01-16 00:00:00
2009-01-17 00:00:00
2009-01-18 00:00:00
2009-01-19 00:00:00
2009-01-19 00:00:00
2009-01-23 00:00:00
2009-01-23 00:00:00
2009-01-27 00:00:00 |  |  | Array | =IFERROR(INDEX($A$2:$A$18, MATCH(0, COUNTIF(C$1:$C1,$A$2:$A$18) + (COUNTIF($A$2:$A$18, $A$2:$A$18)<>1), 0)), "")
2009-01-27 00:00:00 |  |  | Non-Array | =IFERROR(INDEX($A$2:$A$18, MATCH(0,INDEX(COUNTIF($D$1:D1, $A$2:$A$18)+(COUNTIF($A$2:$A$108, $A$2:$A$18)<>1),0,0), 0)), "")
2009-01-27 00:00:00
2009-01-27 00:00:00
2009-01-28 00:00:00
Spreadsheet: 41313d1239801231-working-with-lookups-lookup-macro-1
Sheet: Bank Statement day 2

Day 2
Date | Ref |  | Amount  Received
2009-04-15 00:00:00 | TW000927 |  | 96.8
2009-04-15 00:00:00 | N0000031 |  | 82.48
2009-04-15 00:00:00 | JS000014 |  | 71.74
2009-04-15 00:00:00 | PW00005 |  | 46.64
2009-04-15 00:00:00 | Y1111119 |  | 31.05
2009-04-15 00:00:00 | Y1111118 |  | 29.02
Spreadsheet: 126322d1319635943-formula-for-inserting-number-into-spreadsheet-example
Sheet: Sheet1

Crew list Tug and [NAME]
Month / (W.E.) | Sunday January 2 2011 | Monday January 3, 2011 | Tuesday January 4,  2011 | Wed  January 5, 2011 | Thursday January 6, 2010 | Friday January 7, 2010 | Saturday January 8, 2011
Position on board
Captain | [NAME] | [NAME] | [NAME]
Captain
Mate
Chief Engineer
Assistant Engineer
Assistant Engineer
Deckhand
Deckhand
Tug training Deckhand
Captain
Mate
Mate
Barge training Mate
DAILY FUEL USAGE
TUG Fuel Usage
Light/Loaded/Standby
[NAME]
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 8b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 244 | 7 | 11 | 33 | 15 | 2 | 2 | 314
Cap/Floor | 146 | 7 | 2 | 2 | 0 | 7 | 5 | 169
Debt Option | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Exotic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed-Fixed | 2 | 2 | 0 | 3 | 0 | 0 | 1 | 8
Fixed-Float | 18666 | 8069 | 2453 | 1581 | 622 | 394 | 2299 | 34082
FRA | 950 | 1019 | 441 | 0 | 61 | 0 | 142 | 2613
Inflation | 60 | 60 | 16 | 0 | 1 | 0 | 1 | 138
OIS | 123 | 284 | 34 | 4 | 40 | 13 | 235 | 733
Swaption | 770 | 278 | 67 | 69 | 33 | 21 | 58 | 1296
TOTAL
Spreadsheet: 181000d1347894761-help-correcting-a-formula-that-pulls-data-from-a-separate-sheet-cage-act-tracking-sample-02-
Sheet: Search

CAGE ACT TRACKING:
Employee Name: | ALL
Observed By: | ALL
ACT: | ALL
Appearance: | ALL
Pass All: | ALL
Comments:
Custom Start Date:
Custom End Date:
Track Back Days:
Entries:
Employee Name: | Observed By: | Date | A | C | T | ACT | APP. | Pass All | Comments |  |  |  |  |  |  | Days | Frequency Report |  |  |  | ACT Pass Percentage |  |  |  | Appearance & Pass All Percentage |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday |  |  |  | A | C | T | ACT | Appearance | Pass All | A | C | T | ACT | APP | Pass All
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday |  |  | Sum
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday
Spreadsheet: 155464d1336859254-two-related-tables-billing-resources-help-1-for-gerainta
Sheet: People

Select Person: | Adam
 |  | 2012-06-04 00:00:00 | 2012-06-11 00:00:00 | 2012-06-18 00:00:00 | 2012-06-25 00:00:00 | 2012-07-02 00:00:00 | 2012-07-09 00:00:00 | 2012-07-16 00:00:00 | 2012-07-23 00:00:00 | 2012-07-30 00:00:00 | 2012-08-06 00:00:00 | 2012-08-13 00:00:00 | 2012-08-20 00:00:00 | 2012-08-27 00:00:00
 | Project A
 | Project B
 | Project C
 | Total
Spreadsheet: 766305d1643834238-help-with-a-formula-to-take-date-information-and-present-summarise-in-a-table-by-month-excel-help
Sheet: Sheet1

ID | Name | Start Date | End Date | Duration |  | ID | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
123 | [NAME] | 2022-01-31 00:00:00 | 2022-02-03 00:00:00 |  |  | 123
123 | [NAME] | 2022-01-20 00:00:00 | 2022-01-25 00:00:00 |  |  | 456
456 | [NAME] | 2022-02-05 00:00:00 | 2022-02-22 00:00:00
456 | [NAME] | 2022-02-25 00:00:00 | 2022-03-10 00:00:00
 |  |  |  |  |  | Once Formula Correct Above Should Read
 |  |  |  |  |  | ID | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
 |  |  |  |  |  | 123 | 1 | 3 | 0
 |  |  |  |  |  | 456 | 0 | 14 | 8
Spreadsheet: 40176d1238506933-mass-editing-formulas-grades-2009-spring
Sheet: Sheet1

Points possible | 10 |  | Overall Score
Maple | 5
Jasmine | 5
[NAME] | 10
[NAME] | 10
Carol/Karen | 10
Lily | 10
[NAME] | 10
Sabrine | 10
[NAME] | 10
Juice | 10
[NAME] | 10
Melody | 10
Michelle | 10
[NAME] | 10
[NAME] | 10
Anne | 10
Betty | 10
[NAME] | 10
Sailor | 10
Rhea | 10
[NAME] | 10
Kelly | 10
[NAME] | 10
Maria | 10
Elaine | 10
[NAME] | 10
Joleen | 10
Anna | 10
[NAME] | 10
Charity | 10
[NAME] | 10
[NAME] | 5
Angelica | 10
[NAME] | 10
[NAME] | 10
Candy | 10
Sunshine | 10
Emily | 10
[NAME] | 10
Emma | 10
Spreadsheet: 471561d1469085309-addtional-condition-in-array-formula-grid2-new
Sheet: GRID (2)

 |  | Q1 /Q2
DIV | ACH | AA | A | B | C
ZZ | 100 | 18376 | 16876 | 14376 | 11876
ZZ | 101 | 19696 | 17976 | 15256 | 12591
ZZ | 102 | 21016 | 19076 | 16136 | 13306
ZZ | 103 | 22336 | 20176 | 17016 | 14021
ZZ | 104 | 23656 | 21276 | 17896 | 14736
ZZ | 105 | 24976 | 22376 | 18776 | 15451
ZZ | 106 | 29356 | 25996 | 21636 | 17666
ZZ | 107 | 31186 | 27516 | 22846 | 18631
ZZ | 108 | 33016 | 29036 | 24056 | 19596
ZZ | 109 | 34846 | 30556 | 25266 | 20561
ZZ | 110 | 36676 | 32076 | 26476 | 21526
ZZ | 111 | 39881 | 34861 | 28566 | 23151
ZZ | 112 | 41836 | 36496 | 29856 | 24176
ZZ | 113 | 43791 | 38131 | 31146 | 25201
ZZ | 114 | 45746 | 39766 | 32436 | 26226
ZZ | 115 | 47701 | 41401 | 33726 | 27251
ZZ | 116 | 52056 | 44716 | 36456 | 29156
ZZ | 117 | 54161 | 46456 | 37836 | 30236
ZZ | 118 | 56266 | 48196 | 39216 | 31316
ZZ | 119 | 58371 | 49936 | 40596 | 32396
ZZ | 120 | 60476 | 51676 | 41976 | 33476
Spreadsheet: 145924d1331817368-counting-occurances-by-month-counts-per-month
Sheet: Sheet4

Count of dateOfBirth | Column Labels
Row Labels | sij | vlj | ožu | tra | svi | lip | srp | kol | ruj | lis | [NAME] | pro | Grand Total
1 |  |  | 1 | 1 |  |  |  |  |  |  |  | 1 | 3
2 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
3 |  | 1 |  |  | 1 |  | 2 |  | 1 |  |  |  | 5
4 | 3 | 1 | 3 |  |  | 2 |  | 1 | 1 | 1 |  |  | 12
5 | 3 | 2 | 3 | 2 | 2 |  | 1 | 2 |  | 2 | 1 | 1 | 19
6 |  | 1 | 4 |  | 1 | 1 | 1 | 1 | 2 | 3 | 1 |  | 15
7 |  | 1 |  |  | 1 |  |  | 1 |  | 1 |  | 2 | 6
8 | 1 |  |  |  |  | 1 | 1 |  |  |  |  |  | 3
9 | 1 |  |  |  |  |  |  |  |  | 1 |  |  | 2
10 |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 2
(blank) | 5 | 3 | 4 | 3 | 2 |  | 2 | 4 |  | 4 |  | 4 | 31
Grand Total | 13 | 9 | 15 | 6 | 8 | 5 | 7 | 9 | 5 | 12 | 2 | 9 | 100
Spreadsheet: larry_campbell__21006__Topock Pigging Program
Sheet: Page 5 

Revised |  | 07/018/2001 |  |  |  |  |  | Liquid
Date |  | Location | Type of Pig | Solvent | Solvent | Lateral | Sample I.D. | Volume | Analytical | Units | Comments
 |  | of Sample |  | Injected | Volume | Volume |  | Collected | Result
2000-10-30 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 295 mmcf |  | 0 |  |  | No liquid received with pig 97
2000-11-14 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 217 mmcf |  | 0 |  |  | No liquid received with pig 98
2000-11-27 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 261 mmcf |  | 0 |  |  | No liquid received with pig 99
2000-12-11 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 278 mmcf |  | 0 |  |  | No liquid received with pig 100
2001-01-02 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 292 mmcf |  | 0 |  |  | No liquid received with pig 101
2001-01-18 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 278 mmcf |  | 0 |  |  | No liquid received with pig 102
2001-01-29 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 312 mmcf |  | 0 |  |  | No liquid received with pig 103
2001-02-12 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 290 mmcf |  | 0 |  |  | No liquid received with pig 104
2001-02-26 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 253 mmcf |  | 0 |  |  | No liquid received with pig 105
2001-03-12 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 300 mmcf |  | 0 |  |  | No liquid received with pig 106
2001-03-26 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 303 mmcf |  | 0 |  |  | No liquid received with pig 107
2001-04-09 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 72 mmcf |  | 0 |  |  | No liquid received with pig 108
2001-04-23 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 70 mmcf |  | 0 |  |  | No liquid received with pig 109
2001-05-07 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 161 mmcf |  | 0 |  |  | No liquid received with pig 110
2001-05-25 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 220 mmcf |  | 0 |  |  | No liquid received with pig 111
2001-06-04 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 190 mmcf |  | 0 |  |  | No liquid received with pig 112
2001-06-18 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 140 mmcf |  | 0 |  |  | No liquid received with pig 113
2001-07-13 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 172 mmcf |  | 0 |  |  | No liquid received with pig 114
Spreadsheet: 272640d1382451800-formula-that-will-return-the-adjacent-cell-excel-example
Sheet: Sheet1

labor | 100
labor | 100
labor | 100
bank | 190.46
gas | 5.97
Home Depot | 40.95
labor | 100
Lowes | 212.62
Lowes | 7.88
Lowes | 17
Lowes | 69.16
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: LAMPS

S.No | [NAME] | MODEL  NO | QTY
1 | NEC Lamp | VT 75LP | 1
2 | Hitachi (CPX 440) | C11XM | 6
3 | Hitachi  Lamp | C11 | 2
4 | Hitachi  Lamp( CPX-210) | C10 | 4
5 | Hitachi ( CP320/370) | C4-A | 1
6 | Hitachi CPX 955 Lamp (150W) |  | 1
7 | Hitachi 940/840(160W) | C2S3 | 2
8 | Hitachi 225/275 | [NAME] | 2
9 | Eiki(400 W) | X1 | 1
10 | NEC Lamp | VT60LP | 2
11 | NEC Lamp | LT60LP | 1
12 | NEC 820/1020 |  | 1
13 | [NAME] | P5 | 1
14 | Infocus LP4252/4352) | LP4Z | 1
15 | Epson(81C) (200w) | ELPLP30 | 1
16 | Epson(132W) | ELPLP25 | 2
17 | [NAME] (150W) lamp | ELPLP04 | 1
18 | Toshibha lamp( s-40) | TLPL V2 | 1
19 | Panasonic Lamp | ET-LAM1-C | 3
20 | Panasonic Lamp | ET-LAB30/LAB98C/ETLAB25 | 1
21 | Panasonic Lamp | ET-LAB10 | 1
22 | Sanyo | PLC X18 | 1
23 | Sanyo | PLC Sw20 | 2
24 | Sanyo | XU48 | 2
25 | Sanyo 150W |  | 1
26 | Sanyo  SU-20 |  | 1
27 | Sony FX-40 Lamp |  | 1
28 | Compaq (120W) | DLP BV16 | 1
29 | APO  (200W) | DL17( 89906) | 5
30 | APO  (89910) | DK30 (200W) | 1
31 | UHA (120W) |  | 1
32 | SIM2 |  | 1
33 | OHP Projector [NAME] |  | 59
 | BACK
Spreadsheet: 698880d1602221507-concatenate-several-rows-with-duplicate-sample
Sheet: Sheet1

 | User Experience | BU1 | ProductA
 | User Experience | [NAME] | ProductB
 | User Experience | BU3 | ProductB
 | User Experience | BU4 | ProductC
 | User Experience | BU4 | ProductC
 | User Experience | BU4 | ProductC
Result: | User Experience
Spreadsheet: 850952d1701254888-extracting-data-onto-new-sheet-test1-17-aligw
Sheet: Group 1

 | Name | Capacity | Total No. | [NAME].
AA | AA's | 10 | 2 | 20
AC | AC's | 12 | 3 | 36
BA | BA's | 13 | 2 | 26
BC | BC'S | 15 | 1 | 15
 |  | Totals | 8 | 97
Spreadsheet: 0d6692b3-1075-403f-9e34-e6337714f9f1
Sheet: Sheet1

Unnamed: 0 | ULKOASIAINMINISTERIÖ | Unnamed: 2 | Unnamed: 3 | Tilinpäätös 2008 | Unnamed: 5 | Unnamed: 6 | Liite 6
 | Suunnitelman mukaisten poistojen perusteet ja niiden muutokset
 | Suunnitelman mukaiset poistot on laskettu tilivirastossa yhdenmukaisin periaattein
 | [NAME] pitoajan mukaisina [NAME]
 | hankintamenosta.
 | Omaisuusryhmä | Poisto- menetelmä | Poistoaika vuotta | Vuotuinen poisto % 1) | Jäännösarvo %
 | 112-119 Aineettomat hyödykkeet | Tasapoisto | 5 | 20 | 0
 | 122 [NAME] | Tasapoisto | 20-40 | 1.875-3.75 | 0.25
 | 125-126 Koneet ja laitteet, | Tasapoisto | 5 | 20 | 0
 | [NAME], 1255 | Tasapoisto | 3 | 33.33 | 0
 | 127 Kalusteet | Tasapoisto | 5 | 20 | 0
 | 1289 [NAME] aineelliset hyödykkeet | Tasapoisto | 5 | 20 | 0
 | Ulkoasiainhallinnossa on taseen ulkopuolista kansallisomaisuutta. Siitä, kuten ei myöskään lkp-tilille 1280
 | [NAME],  [NAME] [NAME].
Spreadsheet: 85976d1285953186-creating-a-formula-that-uses-text-in-another-cell-cash-deposits-and-orders-sample-2-
Sheet: 09-13-10

CASH ORDER
Denomination |  | 2010-09-13 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 3541700 |  | 2084600
20 |  | 4948880 |  | 1147000
10 |  | 141850 | 37890 | 0
5 |  | 677855 |  | 286100
1 |  | 192585 |  | 52000
0.25 |  | 18114 | 11401 | 0 |  |  | 5000
0.05 |  | 7865 | 1237 | 0
0.01 |  | 1296 | 413 | 0
Total
Spreadsheet: 169232d1342734248-counting-dates-date-eomonth-calculation
Sheet: Data

Expiration Date | Expiration Month
2012-07-20 00:00:00
2012-07-21 00:00:00
2012-07-22 00:00:00
2012-07-23 00:00:00
2012-07-24 00:00:00
2012-07-25 00:00:00
2012-07-26 00:00:00
2012-07-27 00:00:00
2012-07-28 00:00:00
2012-07-29 00:00:00
2012-07-30 00:00:00
2012-07-31 00:00:00
2012-08-01 00:00:00
2012-08-02 00:00:00
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5209

5209 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 713095d1610553694-data-transfer-from-one-worksheet-to-others-golf-group-composite-spreadsheet2
Sheet: Score Sheet

Name | AVERAGE | OLDEST | MID | MOST RECENT |  | Note:  Cells with no values must be left blank and not contain zeroes
Al |  | 99 | 101 | 98
Billy |  |  | 93 | 93
[NAME] |  |  | 89 | 88
[NAME] |  |  | 78 | 79
Byron |  |  | 87 | 90
[NAME] |  | 84 | 82 | 82
[NAME] |  | 90 | 95 | 102
[NAME] |  |  | 91 | 100
[NAME] |  |  | 88 | 100
Gene |  |  |  | 88
[NAME] |  |  | 87 | 91
[NAME] |  | 85 | 86 | 89
[NAME] |  |  | 77 | 83
[NAME] |  | 79 | 81 | 79
JV |  | 84 | 81 | 90
[NAME] |  |  | 76 | 86
[NAME] |  |  | 88 | 81
Mitch |  | 79 | 75 | 72
[NAME] |  |  |  | 104
Rich |  | 91 | 84 | 94
[NAME] |  | 98 | 96 | 106
[NAME] |  |  | 88 | 98
[NAME] |  |  |  | 89
[NAME] |  | 80 | 82 | 77
Spreadsheet: 274369d1383092154-running-total-of-unique-values-running-total
Sheet: Sheet1

 | Values | running total of unique values
 | FCS x01 | 1
 | FCS x02 | 2
 | FCS x03 | 3
 | FCS x03 | 3
 | FCS x03 | 3
 | FCS x03 | 3
 | FCS x04 | 4
 | FCS x04 | 4
 | FCS x04 | 4
 | FCS x05 | 5
 | FCS x05 | 5
 | FCS x05 | 5
 | FCS x06 | 6
 | FCS x01 | 6
 | FCS x02 | 6
 | FCS x02 | 6
 | FCS x03 | 6 |  | these are duplicates from above
 | FCS x04 | 6
 | FCS x05 | 6
 | FCS x06 | 6
 | AM x01 | 7
 | AM x02 | 8
 | AM x03 | 9
 | AM x04 | 10
 | AM x05 | 11
 | AM x06 | 12
 | AM x01 | 12
 | AM x02 | 12
 | AM x03 | 12
 | AM x04 | 12
 | AM x04 | 12 |  | these are duplicates from above
 | AM x04 | 12
 | AM x05 | 12
 | AM x05 | 12
 | AM x05 | 12
 | AM x06 | 12
Spreadsheet: 19d0988e-d75b-44f9-b8f6-098edde55aef
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2011-10-13 00:00:00 | Professional Fees | ScM Major projects | Universal Design Studio Limited | 146359 | 72000
DCMS | NMSI | 2011-10-13 00:00:00 | Build Construction | National MPG | MB Construction Services Ltd | 146604 | 36784.14
DCMS | NMSI | 2011-10-27 00:00:00 | Reactive Maintenance | NRM Estates | Honeywell Controls Ltd | 146717 | 27898
DCMS | NMSI | 2011-10-27 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 146738 | 28744.89
DCMS | NMSI | 2011-10-27 00:00:00 | Build Construction | ScM Brand | [NAME] | 146740 | 47400
DCMS | NMSI | 2011-10-13 00:00:00 | Photocopier Rental & Materials | ICT | CF Asset Finance Limited | 146744 | 28305.75
DCMS | NMSI | 2011-10-13 00:00:00 | External Audit | Finance | National Audit Office | 146784 | 55000
DCMS | NMSI | 2011-10-27 00:00:00 | Maintenance | NRM Estates | Honeywell Controls Ltd | 146812 | 124645.99
DCMS | NMSI | 2011-10-13 00:00:00 | Build Construction | ScM Major projects | Parkeray Ltd | 147249 | 25800.62
DCMS | NMSI | 2011-10-27 00:00:00 | Build Construction | ScM Brand | TMP | 147328 | 38770
DCMS | NMSI | 2011-10-27 00:00:00 | Consultancy | National Estates | Natural History Museum | 147374 | 27562.5
DCMS | NMSI | 2011-10-27 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 147436 | 35226.09
DCMS | NMSI | 2011-10-27 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 147437 | 36546.2
DCMS | NMSI | 2011-10-27 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 147438 | 31002.08
DCMS | NMSI | 2011-10-27 00:00:00 | Security | ScM Security | [NAME] | 147462 | 155065.75
DCMS | NMSI | 2011-10-27 00:00:00 | Stock Purchases | NRM RETAIL | Hornby Hobbies Ltd | 105732 | 58331
Spreadsheet: 889445d1740236183-creating-a-dynamic-table-from-a-pivot-from-google-sheets-pgt-aol-dashboard-burnsie-
Sheet: Data sheet 

 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1B37SHd5uy7eYHqXEHv3kxP8myBMIRjrUoVjCTTeupIk/edit?gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1FXsN_7aoJSGmPbWQQdbewT3C1B363aEvsqFW3FHzfkw/edit?gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1iqMT1dKx7uSeLlgxSw7pDceBJQj4e5sJCVQF99t2bbg/edit?gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1y-8o4-wwDYYici3J6gqU4wjyJA6lsGI2D5P_tWE1za4/edit?gid=54982496
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1iOlGUIa-e2Tg07ADHZQ6MMl2T6OIwi4vzB3z3KT2x_U/edit?gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1ukZclxqiR6uX4vazxSnpFULwsDYn4J8di_sPrc9Cfgg/edit?gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/18Sv2gzrD6Fv-UHzTUl6v3eBD_9aQRyN08LbbXl1ym9Q/edit?gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/10GRe5pK0ZAHEZizBYF9mrCHigkHTffayXLvevYTvbtA/edit?gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1tyb3DwUQHetdEqoMy3k-IaC5Ilgb7iK6kHCAk4SDTdM/edit?gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1Gpr8vJyQevkQt9LlizZGd7T4fDLTc5r9861E47_gFr8/edit?gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1DwMWkGhyQmM-GodUpcBEBID5-4kEFTw5Rf1a9Jaqbko/edit?gid=[PHONE]
 |  |  |  |  |  | https://docs.google.com/spreadsheets/d/1763ZpmQJWat7lFqVFE0ZvDQp8ST9gmzBjhFhoAUr6s0/edit?gid=[PHONE]
Spreadsheet: 49d33406-ff30-4b0c-8862-d7f4124822f2
Sheet: Sheet1

2014 General Election - OFFICIAL RESULTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
State of North Dakota Results
Precincts Reporting: 427/427 - Total Ballots Cast: 255128
Downloaded at 12/18/2014 2:13:12 PM
 | [NAME] | [NAME] | [NAME] | write-in  - NON
Representative in Congress | 138100 | 95678 | 14531 | 361
 | [NAME] (Al) Jaeger  - REP | Roland  Riemers  - LIB | April  Fairfield  - DEM | write-in  - NON
Secretary of State | 152085 | 12920 | 78474 | 278
 | [NAME] | [NAME]  - DEM | write-in  - NON
Attorney General | 181678 | 63255 | 395
 | [NAME] | [NAME] | write-in  - NON
Agriculture Commissioner | 139597 | 105094 | 377
 | [NAME] | [NAME] | write-in  - NON
Public Service Commissioner | 154409 | 83557 | 370
 | Tyler  Axness  - DEM | [NAME] | write-in  - NON
Public Service Commissioner [NAME] | 80319 | 156596 | 401
 | [NAME] | [NAME] | [NAME] | write-in  - NON
Tax Commissioner | 15238 | 87516 | 135329 | 344
 | [NAME] | write-in  - NON
Justice of the Supreme Court | 198046 | 1551
Results provided by the Office of North Dakota Secretary of State