tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Feb17-Feb23m

Main Arena
 | 2013-02-17 00:00:00 |  |  | Thru | 2013-02-23 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  | [NAME] | [NAME] | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  | [NAME] | [NAME] |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  | [NAME] | [NAME] | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  | [NAME] | [NAME] |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  | [NAME] | [NAME] | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  | [NAME] | [NAME] |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  | [NAME] | [NAME] | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  | [NAME] | [NAME] |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  | [NAME] | [NAME] | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  | [NAME] | [NAME] |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  | [NAME] | [NAME] | 12:00PM
 |  |  |  |  |  | [NAME] | [NAME]
1:00PM |  |  |  |  |  | [NAME] | [NAME] | 1:00PM
 |  |  |  |  |  | [NAME] | [NAME]
2:00PM |  |  |  |  |  | [NAME] | [NAME] | 2:00PM
 |  |  |  |  |  | [NAME] | [NAME]
3:00PM |  |  |  |  |  | [NAME] | [NAME] | 3:00PM
 |  |  |  |  |  | [NAME] | [NAME]
4:00PM |  |  |  |  |  | [NAME] | [NAME] | 4:00PM
 |  |  |  |  |  | [NAME] | [NAME]
5:00PM |  |  |  |  |  | [NAME] | [NAME] | 5:00PM
 |  |  |  |  |  | [NAME] | [NAME]
6:00PM |  |  |  |  |  | [NAME] | [NAME] | 6:00PM
 |  |  |  |  |  | [NAME] | [NAME]
7:00PM |  |  |  |  |  | [NAME] | [NAME] | 7:00PM
 |  |  |  |  |  | [NAME] | [NAME]
8:00PM |  |  |  |  |  | [NAME] | [NAME] | 8:00PM
 |  |  |  |  |  | [NAME] | [NAME]
9:00PM |  |  |  |  |  | [NAME] | [NAME] | 9:00PM
 |  |  |  |  |  | [NAME] | [NAME]
10:00PM |  |  |  |  |  | [NAME] | [NAME] | 10:00PM
 |  |  |  |  |  | [NAME] | [NAME]
11:00PM |  |  |  |  |  | [NAME] | [NAME] | 11:00PM
 |  |  |  |  |  | [NAME] | [NAME]
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
 | 2/24 & 2/25 | All | PHMHA |  | Canceled all ice for teams for PHFSC
Spreadsheet: 96588d1295964724-post-code-conditional-formatting-postcodecond-1-
Sheet: Schedule

Customer | location | postcode
cust 1 |  | EC4A
cust 2 |  | FK17
cust 3 |  | ZE2
cust 4 |  | M16
Spreadsheet: 1bd2b0a6-64b2-45e1-89a9-adff3eada340
Sheet: Sheet1

Port | Mb/s    Through-put | Media Type | Non-recurring | Monthly Recurring | Annual Price
10Mb/s Port | 10 MG | Copper Ethernet | 1039 | 399.42 | 4793
100Mb/s Port | 51 MG | Copper Ethernet | 1039 | 694.17 | 8330
 | 100 | Copper Ethernet | 1039 | 964.25 | 11571
1000Mb/s Port | 155 MG | MM or SM Fiber Ethernet | 3022 | 1267.08 | 15205
 | 207 | MM or SM Fiber Ethernet | 3022 | 1553.67 | 18644
 | 259 | MM or SM Fiber Ethernet | 3022 | 1840.17 | 22082
 | 311 | MM or SM Fiber Ethernet | 3022 | 2126.75 | 25521
 | 362 | MM or SM Fiber Ethernet | 3022 | 2412.25 | 28947
 | 414 | MM or SM Fiber Ethernet | 3022 | 2698 | 32376
 | 466 | MM or SM Fiber Ethernet | 3022 | 2983.5 | 35802
 | 517 | MM or SM Fiber Ethernet | 3022 | 3274 | 39228
 | 569 | MM or SM Fiber Ethernet | 3022 | 3554.67 | 42656
 | 622 | MM or SM Fiber Ethernet | 3022 | 3840.17 | 46082
 | 933 | MM or SM Fiber Ethernet | 3022 | 5553.92 | 66647
TDM
OC-3 | 155 | SM Fiber | 2450 | 1407.92 | 16895
OC-12 | 622 | SM Fiber | 6600 | 1914.67 | 22976
OC-48 | 2488 | SM FIber
DS-1 | 1.544Mb/s | Copper T1 | 1500 | 103.5 | 1242
DS-3 | 45Mb/s | Copper T1 | 2300 | 619.92 | 7439
5 - year term pricing.
Pricing per each network location.
Services subject to availability.
Prices do not include Federal, State, or Local Telecommunications fees, taxes, or surcharges.
Pittock port charges may apply for copper and or fiber interfaces.
Prices effective 07-01-13 through 06-30-14
Spreadsheet: 4a766bf3-8937-44be-b716-c9385a11fb08
Sheet: RESOURCE CENTERS

Grant: |  | RESOURCE CENTERS
CFDA # |  | 84.002
GRANT NUMBER: |  | 5002
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez  [PHONE] or [EMAIL]
GBL/ORG: |  | 613D/7000
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - SEPTEMBER 30, 2013
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JUL 2012 | JUL 2012 | AUG 2012 | AUG 2012 | SEPT 2012 | SEPT 2012 | OCT 2012 | OCT 2012 | NOV 2012 | NOV 2012 | DEC 2012 | DEC 2012 | JAN 2013 | JAN 2013 | FEB 2013 | FEB 2013 | MAR 2013 | MAR 2013 | APR 2013 | APR 2013 | MAY 2013 | MAY 2013 | JUN 2013 | JUN 2013
0470 | St. Vrain Valley | 90504 |  |  |  |  |  |  |  |  |  |  |  | 30268 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31391
Y001 | Trinidad State Junior College | 33000 |  |  |  |  |  |  |  |  |  | 5495 |  |  |  |  |  |  | 13804 |  |  |  |  | 4413 |  |  |  | 9288
Y007 | Community Educational Outreach | 5529 |  |  |  |  |  |  |  |  |  |  |  | 1029 |  |  |  |  |  |  |  |  | 863 |  | 863 | 863
Y699 | Northeastern Junior College | 1135 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1135
Y703 | Morgan Community College | 1632 |  |  |  |  |  |  |  |  |  |  |  | 1592
Y705 | Durango [NAME] Center | 1318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1318
Spreadsheet: darrell_schoolcraft__7878__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 1st = 65000
 |  |  | SoCal Gas Price |  | 2.34
 |  |  | San Juan Gas Price |  | 2.12
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 475 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 490 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 490 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 490 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 490 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 490 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 490 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 490 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 490 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 490 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 490 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 490 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 490 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 490 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 490 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 490 | 7
he22 | 00:00:00 |  | 0 | 0 | 0 | 490 | 7
he23 | 01:00:00 |  | 0 | 0 | 0 | 475 | 7
he24 | 02:00:00 |  | 0 | 0 | 0 | 475 | 7
he1 | 03:00:00 |  | 0 | 0 | 0 | 475 | 7
he2 | 04:00:00 |  | 0 | 0 | 0 | 475 | 7
he3 | 05:00:00 |  | 0 | 0 | 0 | 475 | 7
he4 | 06:00:00 |  | 0 | 0 | 0 | 475 | 7
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 475 | 7
Spreadsheet: 0db37f84-a69a-45a6-b557-a8106d9c149e
Sheet: Sheet1

Category | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD
Vols add
[NAME]. | 38 | 54 | 56 | 53 |  |  |  |  |  |  |  |  | 201
binding | 166 | 392 | 131 | 264 |  |  |  |  |  |  |  |  | 953
firm ord | 233 | 318 | 201 | 299 |  |  |  |  |  |  |  |  | 1051
stand ord | 20 | 14 | 6 | 15 |  |  |  |  |  |  |  |  | 55
gifts | 222 | 317 | 316 | 124 |  |  |  |  |  |  |  |  | 979
approvals | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
total | 679 | 1095 | 710 | 755 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3239
withdraw | 25 | 2 | 5 | 2 |  |  |  |  |  |  |  |  | 34
Non-Book
mfilm | 32 | 11 | 11 | 30 |  |  |  |  |  |  |  |  | 84
media | 2 | 53 | 13 | 38 |  |  |  |  |  |  |  |  | 106
III activity
bib new | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
bib upd | 843 | 1109 | 893 | 617 |  |  |  |  |  |  |  |  | 3462
bib del | 7 | 6 | 9 | 17 |  |  |  |  |  |  |  |  | 39
item new | 499 | 433 | 353 | 361 |  |  |  |  |  |  |  |  | 1646
item upd | 393 | 676 | 264 | 610 |  |  |  |  |  |  |  |  | 1943
item del | 21 | 10 | 9 | 12 |  |  |  |  |  |  |  |  | 52
ord new | 219 | 400 | 368 | 264 |  |  |  |  |  |  |  |  | 1251
ord upd | 329 | 564 | 517 | 412 |  |  |  |  |  |  |  |  | 1822
[NAME] | 33 | 0 | 0 | 1 |  |  |  |  |  |  |  |  | 34
checkin | 1028 | 1043 | 880 | 1248 |  |  |  |  |  |  |  |  | 4199
Cataloging
LC | 236 | 366 | 445 | 269 |  |  |  |  |  |  |  |  | 1316
edit | 206 | 329 | 254 | 277 |  |  |  |  |  |  |  |  | 1066
original | 85 | 105 | 108 | 139 |  |  |  |  |  |  |  |  | 437
Inventory
bcod scan | 0 | 0 | 967 | 606 |  |  |  |  |  |  |  |  | 1573
corr. | 99 | 49 | 4 | 43 |  |  |  |  |  |  |  |  | 195
item find | 11 | 0 | 22 | 4 |  |  |  |  |  |  |  |  | 37
no bcod | 21 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 21
no item | 40 | 0 | 8 | 4 |  |  |  |  |  |  |  |  | 52
Processing
items proc | 795 | 1460 | 971 | 2657 |  |  |  |  |  |  |  |  | 5883
temp. bind | 92 | 98 | 40 | 19 |  |  |  |  |  |  |  |  | 249
mend | 6 | 83 | 4 | 17 |  |  |  |  |  |  |  |  | 110
Spreadsheet: 4a766bf3-8937-44be-b716-c9385a11fb08
Sheet: ISP

Grant: |  | Title 1A Improvement Support Partnership
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2013
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013
30 | Adams 14 |  | 192214 |  |  |  | 92543 | 22004 | 19800 | 1255 |  | 2277
123 | [NAME] | Sheridan Middle School | 188779 |  |  |  |  | 44187 |  |  |  | 70759
123 | [NAME] | Sheridan Elementary School | 161573 |  |  |  |  | 35191 |  |  |  | 70860
880 | Denver Public Schools | [NAME] | 57319 |  |  |  |  | 11967 | 9070 |  | 15746 |  | 20536
880 | Denver Public Schools | [NAME] | 198567 |  |  |  |  | 7303 | 247 |  | 11205 |  | 41151
880 | Denver Public Schools | College View Elementary | 100000
880 | Denver Public Schools | [NAME] | 88902 |  |  |  |  |  |  | 2693 |  | 10100 | 11165
880 | Denver Public Schools | Kaiser Elementary | 95517 |  |  |  |  | 37615 | 7975 |  | 14896 |  | 18395
880 | Denver Public Schools | [NAME] | 99975 |  |  |  |  |  |  |  | 70260 |  | 1609
880 | Denver Public Schools | [NAME] | 63672 |  |  |  |  |  | 5479 |  |  |  | 730
1050 | Ellicott SD |  | 140277 |  |  |  |  |  | 93229
1390 | Huerfano RE-1 - FDA ONLY |  | 35000 |  |  |  | 28248 |  |  |  | 4409 |  | 2343
2000 | Mesa County 51 | [NAME] | 76365 |  |  | 3300 | 9200 | 14000 | 2809 | 7108
2000 | Mesa County 51 | Fruitvale Elementary | 100000 |  |  | 27155 |  | 15000 | 9345 |  |  | 10599 |  | 10594
2690 | Pueblo City | Bessemer Academy | 30000 |  |  |  |  |  | 1218 |  |  |  | 199
2690 | Pueblo City | Heaton Elementary - FDA ONLY | 30000
Spreadsheet: 583223d1532330246-how-to-match-one-sheet-column-data-with-another-sheet-workbook-2
Sheet: MATCH 

NO | date | ID | item | A001 | A002 | A003 | A004 | A005 | A006
1 |  | 1001001
2 |  | 1001002 |  | X |  |  |  | X
3 |  | 1001003
4 |  | 1001004 |  |  | X
5 |  | 1001005 |  | X |  | X |  | X
6 |  | 1001006
7 |  | 1001007 |  |  |  | X
8 |  | 1001008 |  | X |  |  |  | X
9 |  | 1001009
10 |  | 1001010 |  | X |  |  | X | X
11 |  | 1001011
12 |  | 1001012 |  |  | X
13 |  | 1001013 |  |  |  |  | X
14 |  | 1001014 |  | X |  |  |  | X
15 |  | 1001015 |  |  |  |  |  |  | X
16 |  | 1001016
17 |  | 1001017 |  |  |  |  |  |  | X
18 |  | 1001018
19 |  | 1001019
20 |  | 1001020
Spreadsheet: 749500d1632843122-compare-missing-data-not-in-same-row-column-book-1-
Sheet: Sheet1

alpha | 1500 | Transfer
Bravo | 21 | Transfer
[NAME] | 600 | Transfer
design | 690 | Transfer
Echo | 206 | Transfer
Fox | 780 | Transfer
Gum | 64 | Transfer
Helex | 454 | Transfer
igloo | 65 | Transfer
jump | 34 | Transfer
Spreadsheet: 886838d1736944997-if-cell-value-is-equal-to-or-between-values-if-cell-value-is-equal-to-or-between-values
Sheet: Sheet1

 |  |  |  |  |  | minimum length | maximum length | maximum length
 |  |  |  |  |  | 805 |  |  | Result
 | required length |  |  |  |  | actual length
 | 800 |  |  |  |  | 805
 |  |  |  |  |  | Cell B7 = required length.
 |  |  |  |  |  | Cell G7 = actual length.
 |  |  |  |  |  | Cell G5 = minimum length.
 |  |  |  |  |  | Cell H5 = B7 + 10
 |  |  |  |  |  | Cell I5 = B7 + 1%
 |  |  |  |  |  | Cell J6 = Result
 |  |  |  |  |  | I would like J6 to display "PASS" if [NAME] is equal to G5 or Between G5 and H5 or I5
 |  |  |  |  |  | J6 would display "FAIL" if above is not met (or G7 is less than G5 or not Between H5 and I5)
 |  |  |  |  |  | [NAME] would be solid red for fail and solid green for pass.
Spreadsheet: fed480cd-f631-4e29-b573-b456ea223ca1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Total Gross Imports by Germany, TONNES
 |  | Belgium | Indonesia | Malaysia | Netherlands | Thailand | Total | Sub-total | % of World
 | 1996 |  | 13413 | 6605.101 | 17.5 | 25589.1 | 50463.88 | 45624.701 | 90.41060853822576
 | 1997 |  | 17050 | 3618 | 114 | 19514 | 43717.124 | 40296 | 92.17440744729686
 | 1998 |  | 25993 | 4975 | 246 | 18952 | 59225.312 | 50166 | 84.70364833198346
 | 1999 | 134.398 | 4677.699 | 3826.187 | 418.687 | 21118.7 | 36993.664 | 30175.671 | 81.56983585080948
 | 2000 | 185.9 | 9513.7 | 2928.9 | 51.2 | 21005.9 | 40515.039 | 33685.6 | 83.14344705431482
 | 2001 | 63.6 | 7554.5 | 2898.2 | 266.2 | 22111.5 | 37534.974 | 32894 | 87.63560086654117
 | 2002 | 143.2 | 217.6 | 2300.2 | 150.1 | 17947.7 | 34521.888 | 20758.8 | 60.13228476959313
 | 2003 | 165.7 | 4585.2 | 4089.8 | 351.7 | 17641.5 | 33687.069 | 26833.9 | 79.65638090983813
 | 2004 | 413.8 | 16397.9 | 15695.1 | 225.6 | 15185.2 | 60529.8 | 47917.6 | 79.16365162283702
 | 2005 | 565.8 | 6820.9 | 17956 | 349.1 | 10252.7 | 56744.308 | 35944.5 | 63.34467943463158
 | Total Gross Exports into Germany, TONNES - Mirror Image
 |  | Belgium | Indonesia | Malaysia | Netherlands | Thailand
 | 1996 |  | 1518.5 |  | 34.25
 | 1997 |  | 1906.437 | 3607.375 | 76
 | 1998 |  | 34.89 | 2627.375 | 105.871
 | 1999 | 466.062 | 450.937 | 2862.875 | 36.011 | 20957.386
 | 2000 | 134.351 | 1111.875 | 1837.125 | 274.812 | 19313.781
 | 2001 | 838.5 | 703.562 | 1512.5 | 494.812 | 19340.265
 | 2002 | 2532.138 | 1197.437 | 1333 | 1602.125 | 17777.624
 | 2003 | 4029.208 | 1299.937 | 1326 | 471.375 | 20738.71
 | 2004 | 4740.984 | 1160.937 | 1587 | 7 | 17029.164
 | 2005 | 6869.603 | 208.854 | 1591.07 | 100.979 | 9815.24
Spreadsheet: 166039d1341436644-excel-2007-something-like-concatenate-with-if-criteria-or-sthing-else-cms-reprot
Sheet: Sheet1

 | Avg ACD Time | Avg ACW Time | Staffed Time | ACD Time | ACW Time | AUX Time | Avail Time | Other
 | :02:38 | :00:07 | 1 day, 7:05:39 | 21:43:35 | 01:35:11 | 03:28:56 | 3:18:33 | :42:15
 | :02:22 | :00:14 | 1 day, 7:47:09 | 18:54:49 | 02:53:22 | 04:18:54 | 4:11:19 | 01:12:11
 | :02:21 | :00:27 | 1 day, 7:28:12 | 18:59:26 | 04:13:35 | 04:07:50 | 2:41:20 | :54:26
 | :02:08 | :00:13 | 1 day, 7:57:07 | 17:35:48 | 2:17:25 | 4:19:14 | 6:06:20 | 01:23:26
 | :02:20 | :00:06 | 1 day, 8:07:11 | 18:33:44 | 01:11:51 | 2:53:23 | 8:02:29 | 01:09:36
 | :02:10 | :00:09 | 1 day, 6:37:49 | 16:01:15 | 2:53:21 | 4:28:54 | 4:54:59 | 02:01:51
Spreadsheet: 751421d1634107601-compare-1-value-whether-it-is-either-1st-2nd-or-3rd-largest-with-multiple-criterias-compare-with-3-largest-values-with-multiple-criteria
Sheet: Main

Branchwise Business Summary
Branch | Location Head | [NAME] | Amt
Mumbai | Mumbai Total | M1
[NAME] | P-1 | M1 | 20
[NAME] | P-2 | M1 | 80 |  | T1
Vishwas [NAME] | P-3 | M1 | 40
Mumbai Unaccounted | Mumbai Unaccounted | M1 | 10
M1 Total
Bangalore | Bangalore Total | M2
Pradesh [NAME] | P-4 | M2 | 35
D [NAME] | P-5 | M2 | 60 |  | T3
Bangalore Unaccounted | P-6 | M2 | 70 |  | T2
M2 Total
PAN INDIA
Spreadsheet: 181453d1348049691-multisheet-formula-while-skipping-rows-and-autofill-trial-sheet
Sheet: Gas-Electric

Date |  | Gas (Therms) | Electric (kwh) | Total
2012-11-18 00:00:00 | Qty | 45 | 475
 | Cost | 35.25 | 71.68
2012-12-18 00:00:00 | Qty | 36 | 536
 | Cost | 25.25 | 83.68
2013-01-18 00:00:00 | Qty | 14 | 397
 | Cost | 14.85 | 56.45
Spreadsheet: 228423d1366115445-using-excel-to-generate-a-letter-sample
Sheet: Sheet2

this is paragraph 1 owls | 1
this is paragraph 2
this is paragraph 3 owls | 2
this is paragraph 4 owls | 3
this is paragraph 5 owls | 4
this is paragraph 6 owls | 5
this is paragraph 7 owls | 6
this is paragraph 8
this is paragraph 9
this is paragraph 10
this is paragraph 11
this is paragraph 12
this is paragraph 13 owls | 7
this is paragraph 14
this is paragraph 15
this is paragraph 16 owls | 8
this is the end bye by | 1000
Spreadsheet: 779353d1651737433-building-a-dynamic-formula-to-simplify-relations-substitute-len-may-5-excel-simplify-relations_substitute_len_countif_search
Sheet: Sheet1

 |  | Can someone guide me in the right direction… to go from yellow to green, with a dynamic (in-between) formula in blue
 |  |  |  | Helper Cells |  | (LEN($B6)-LEN(SUBSTITUTE($B6;E$5;"")))/LEN(E$5)
 | Relations between people | [NAME] |  | Anna | [NAME] | Casper | Dirk | Eva | [NAME] | Gerard | Hilde | Isabel |  | Group of relations |  | Wrong1 | Wrong2
 | Anna-Dirk, [NAME], Casper-Fiona |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Casper-Fiona
 | [NAME], Isabel-Boris, Eva-Isabel, [NAME], Dirk-Boris, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Boris-Dirk, Fiona-Eva, [NAME], Dirk-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Boris-Dirk-Hilde, [NAME]
 | Isabel-Anna, Eva-Boris, Hilde-Casper, Isabel-Gerard, Fiona-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Isabel-Anna-Gerard, Eva-Boris, Hilde-Casper, Fiona-Dirk
 | Dirk-Casper, Fiona-Eva, [NAME], Dirk-Hilde, [NAME], Fiona-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Dirk-Casper-Hilde-Fiona-Isabel-Gerard-Eva
 | [NAME], Isabel-Anna, Eva-Hilde, Dirk-Casper |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Eva-Hilde, Dirk-Casper
 | Eva-Isabel, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Eva-Isabel-Dirk
 | …
 | [NAME], [NAME], Casper-Eva, Isabel-Fiona |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 | Sample DATA in [B6:B14] |  |  | List of 9 People: |  |  |  |  |  |  |  |  |  | I Hardcoded the preferred FORMAT in [O6:O14]
 |  | I've been stuck on this (seemingly simple) dynamic formula-problem, for over 2 years now (since 2019)…
 | Dirk-Anna, [NAME], Casper-Fiona
 | Dirk-Anna, Dirk-Boris, Casper-Anna, Fiona-Casper
 |  |  |  |  |  |  |  |  |  |  |  |  | Fiona-Eva
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Dirk-Hilde
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Fiona-Hilde
Spreadsheet: kate_symes__18434__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | 2000-12-19 00:00:00 |  | 450 | 2400 | 346.89 | 1608 | 477.03 | 1720 | 210 | 697
 | 2000-12-18 00:00:00 |  | 377 | 2000 | 325 | 400 | 593.64 | 3048 | 423.21 | 1126
 | 2000-12-17 00:00:00 |  |  |  |  |  |  |  | 551.77 | 2065 |  | 325 | 600
 | 2000-12-16 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 587.5 | 1400 | 537.5 | 1200
 | 2000-12-15 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 571.38 | 3975 | 517.59 | 3375
 | 2000-12-14 00:00:00 |  | 484.61 | 5200 | 256.22 | 1608 | 654.11 | 730 | 437.04 | 1340
 | 2000-12-13 00:00:00 |  | 688.24 | 6800 | 500 | 200 | 454.83 | 6475 | 350 | 100
 | 2000-12-12 00:00:00 |  | 818.75 | 3200 | 300 | 200 | 800 | 0 | 600 | 0
 | 2000-12-11 00:00:00 |  | 3200 | 2800 | 1187.5 | 400 | 597.15 | 1192 | 561.22 | 245
 | 2000-12-10 00:00:00 |  |  |  |  |  |  |  | 740.4 | 5823 |  | 1187.5 | 1200
 | 2000-12-09 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 450 | 450 | 487.5 | 0
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 143835d1330592353-automatic-entry-into-summary-table-when-matching-various-criteria-blank-sui-form-test-2
Sheet: Lists

Month |  | Type of Notification |  | Completed By |  | Accident / Incident Happened To:
January |  | Death |  |  |  | Staff
February |  | Infectious disease |  |  |  | S U
March |  | Injury |  |  |  | Other
April |  | Illness
May |  | Event that adversely affects the person’s safety & welfare
June |  | Theft, burglary or accident
July |  | The termination of accommodation without notice
August |  | Physical Intervention
September |  | Temporary Change in Provider's Approval
October |  | Safeguarding
November |  | Aggression / Violence
December |  | Medication Error
 |  | Seizures
 |  | Self Injuries Behaviour
 |  | Manual Handling
 |  | Slips / Trips / Falls
 |  | Injury Found cause unknown
 |  | Unwitnessed Event
 |  | Security
 |  | Equipment
 |  | Other *
 |  | Hints
 |  | Allegations
Aggression / Violence
Medication Error
Seizures
Self Injuries Behaviour
Manual Handling
Slips / Trips / Falls
Injury Found cause unknown
Unwitnessed Event
Spreadsheet: 28861d1223411643-percentage-calculation-sample
Sheet: Sheet1

MONTH | Company Vehicles |  |  |  | Personal Vehicles |  |  |  | % Wearing
 | Wearing |  | Not Wearing |  | Wearing |  | Not Wearing
 | Drivers | Passengers | Drivers | Passengers | Drivers | Passengers | Drivers | Passengers
Oct 08 | 10 | 0 | 1 | 0 | 10 | 0 | 1 |  | 0.09090909090909091
Spreadsheet: a70ca3ff-074f-4820-a8c9-0594b01e8419
Sheet: Special School Classroom

[NAME]: |  | High Cost Risk Pool Data Collection 2012-2013
Student SSID | Average Cost of Special Education Special School Classroom  Per Student for Your District | Description of Unique Special Education Services as per Student IEP | Extraordinary Costs of Services Provided to Each Student (Prorate if services were for less than a full year) | Total Costs of Special Education Services  Average Classroom costs + Extraordinary Costs | Subtract $19,152  (3X the 2011-12 Average Per Pupil Expenditure for Utah) ($6384) | Medicaid  Reimbursement Received       (Subtracted from Total Costs) | Eligible Amount of Risk Pool Money
123456789 | 6000 | Physical Therapy, SLP, therapy swing, 2:1 aide | 22000 |  |  | 600
 |  |  |  |  |  | Subtotal