tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125559d1319101958-indoor-soccer-league-table-tiebreaker-help-standings
Sheet: Results

2011-09-13 00:00:00 | Timbers Indoor |  | 5 | 7 |  | FC United |  |  |  |  |  | Pts |  | W |  | L |  | D |  | GF |  | GA |  | DIFF |  |  | H2H
2011-09-13 00:00:00 | PVAMC |  | 4 | 4 |  | FC Lightning |  |  |  | Timbers Indoor
2011-09-13 00:00:00 | Blue Ballers |  | 3 | 8 |  | [NAME] |  |  |  | PVAMC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ties
2011-09-13 00:00:00 | Team America |  | 7 | 3 |  | Party Rockers |  |  |  | Blue Ballers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | Tot
2011-09-20 00:00:00 | FC Lightning |  | 10 | 8 |  | Timbers Indoor |  |  |  | Team America
2011-09-20 00:00:00 | FC United |  | 5 | 9 |  | [NAME] |  |  |  | FC United
2011-09-20 00:00:00 | PVAMC |  | 3 | 6 |  | Party Rockers |  |  |  | FC Lightning
2011-09-20 00:00:00 | Blue Ballers |  | 2 | 7 |  | Team America |  |  |  | [NAME]
2011-09-27 00:00:00 | Timbers Indoor |  | 6 | 7 |  | [NAME] |  |  |  | Party Rockers
2011-09-27 00:00:00 | FC Lightning |  | 6 | 9 |  | Party Rockers
2011-09-27 00:00:00 | FC United |  | 6 | 7 |  | Team America
2011-09-27 00:00:00 | PVAMC |  | 8 | 7 |  | Blue Ballers
2011-10-04 00:00:00 | Party Rockers |  | 3 | 4 |  | Timbers Indoor
2011-10-04 00:00:00 | [NAME] |  | 5 | 2 |  | Team America
2011-10-04 00:00:00 | FC Lightning |  | 2 | 6 |  | Blue Ballers
2011-10-04 00:00:00 | FC United |  | 4 | 7 |  | PVAMC
2011-10-11 00:00:00 | Timbers Indoor |  | 5 | 4 |  | Team America
2011-10-11 00:00:00 | Party Rockers |  | 7 | 4 |  | Blue Ballers
2011-10-11 00:00:00 | [NAME] |  | 7 | 4 |  | PVAMC
2011-10-11 00:00:00 | FC Lightning |  | 3 | 6 |  | FC United
2011-10-18 00:00:00 | Blue Ballers |  | 1 | 2 |  | Timbers Indoor
2011-10-18 00:00:00 | Team America |  |  |  |  | PVAMC
2011-10-18 00:00:00 | Party Rockers |  |  |  |  | FC United
2011-10-18 00:00:00 | [NAME] |  |  |  |  | FC Lightning
2011-10-25 00:00:00 | Timbers Indoor |  |  |  |  | PVAMC
2011-10-25 00:00:00 | Blue Ballers |  |  |  |  | FC United
2011-10-25 00:00:00 | Team America |  |  |  |  | FC Lightning
2011-10-25 00:00:00 | Party Rockers |  |  |  |  | [NAME]
2011-11-01 00:00:00 | FC United |  |  |  |  | Timbers Indoor
2011-11-01 00:00:00 | FC Lightning |  |  |  |  | PVAMC
2011-11-01 00:00:00 | [NAME] |  |  |  |  | Blue Ballers
2011-11-01 00:00:00 | Party Rockers |  |  |  |  | Team America
Spreadsheet: 853955d1703903439-calculate-consecutive-yes-between-no-consecutive-yes
Sheet: Sheet1

Days | Columns | Consecutive Yes | True Yes
1 | N
2 | N
3 | Y | 1
4 | Y
5 | Y
6 | Y
7 | Y
8 | N
9 | N
10 | N
11 | N
12 | Y | 1
13 | Y
14
15
16 | Y
17 | Y
18 | N
19 | N
20 | N
21 | Y
22 | Y
23 | Y
24 | N
25 | N
26 | N
27 | N
28 | N
29 | N
30 | N
31 | N
32 | N
33 | N
34 | N
35 | N
36 | N
37 | N
38 | N
39 | N
40 | N
41 | N
42 | N
43 | N
44 | N
45 | N
46 | Y | 1 | 1
47 | Y
48 | Y
49 | Y
50 | N
51 | N
52 | N
53 | N
54 | N
55 | N
56 | N
57 | N
58 | N
59 | N
60 | N
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -98383 | -75000
2 | -98232 | -95000
3 | -47152 | -38250
4 | -4 | -5000
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
2001-08-31 00:00:00 |  |  | -173605
2001-09-04 00:00:00
CBS Volume
 |  |  | -86184
Spreadsheet: 472745d1469725906-employee-attendance-tracker-viewing-all-together-on-a-year-calendar-welse
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | Employee 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2017
 |  |  |  |  |  |  | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W | T | F | S
 |  | KEY STATISTICS
 |  |  | Days on Leave |  |  |  |  |  |  |  | Working Days |  |  |  |  |  |  |  | # of Days Sick |  |  |  |  |  |  | on Annual |  |  |  |  |  |  |  | on Bereavement |  |  |  |  |  |  |  | on Compassionate |  |  |  |  |  |  |  | on Study/Workshop
Spreadsheet: 189262d1351135834-how-to-lock-protect-some-cell-in-worksheet-120224_how-to-lock-cell_eng
Sheet: ENG

 |  |  |  |  |  |  |  |  | Code |  | L1 |  | = Late after 8.00 AM =  1 day |  |  |  |  |  |  | 1 | = Working Full day
 |  |  |  |  |  |  |  |  |  |  | L2 |  | = Late after 8.15 AM = 1 day |  |  |  |  |  |  | 0.5 | = Working half day
 |  |  |  |  |  |  |  |  |  |  | Sf |  | =  Sick Full day = 1 day |  |  |  |  |  |  | Sh | = Sick Half day = 0.5 day
 |  |  |  |  |  |  |  |  |  |  | Ef |  | = Errand Leave Full day =1 day |  |  |  |  |  |  | Eh | = Errand Leave half day = 0.5 day
 |  |  |  |  |  |  |  |  |  |  | A |  | = Absent without telling admin
 |  |  | 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
Summary Statistic Working days
 |  |  |  |  |  |  |  |  | Code |  | L1 |  | = Late after 8.00 AM =  1 day |  |  |  |  |  |  | 1 | = Working Full day
 |  |  |  |  |  |  |  |  |  |  | L2 |  | = Late after 8.15 AM = 1 day |  |  |  |  |  |  | 0.5 | = Working half day
 |  |  |  |  |  |  |  |  |  |  | Sf |  | =  Sick Full day = 1 day |  |  |  |  |  |  | Sh | = Sick Half day = 0.5 day
 |  |  |  |  |  |  |  |  |  |  | Ef |  | = Errand Leave Full day =1 day |  |  |  |  |  |  | Eh | = Errand Leave half day = 0.5 day
 |  |  |  |  |  |  |  |  |  |  | A |  | = Absent without telling admin
 |  |  |  |  |  |  |  |  |  |  | Month |  |  | September |  |  |  |  |  |  |  |  | 1-30 | Sep | 2012
NO. | NAME |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | Total | Sum Total (Days)
 |  |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Work day | Late 8.00 | Late 8.15 | Sick | Errand | Absent | TOTAL
1 | Mr. [NAME] | Day 1-15 | 1 |  | 1 | 1 | 1 | Sf | 1 | 1 | Sf | 1 | 1 | 1 | 1 | 1 | Ef
 |  | Day 16-31 |  | 1 | 1 | 1 | 1 | 1 | 1 | L1 | 1 | 1 | Eh | 1 | L2 | 1 |  | L1 |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME]
 | 400602 | OT/EX.Day |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 401219
2 | Miss B | Day 1-15 | 1 | L1 | L1 | 1 | 1 | L1 | 1 | L1 | L1 | L1 | L1 | 1 | 1 | 1 | 1
 |  | Day 16-31 | L1 | 1 | 1 | 1 | 1 | 1 | 1 | L1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 400630 | OT/EX.Day |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 749786d1633007912-auto-populate-a-duplicate-cell-duplicate-cell-updated-2
Sheet: Sheet1

ISSUE: |  | SEAT NUMBER | RESERVE_NUMBER | BOOKING_ID
 |  | 56001 |  | 122
 |  | 56001 |  | 122
 |  | 56001 |  | 122
 |  | 56001 |  | 122
 |  | 12432 |  | 568
 |  | 12432 |  | 568
 |  | 12432 |  | 568
 |  | 12432 |  | 568
 |  | 89922 |  | 621
 |  | 89922 |  | 621
 |  | 12310 |  | 866
 |  | 12310 |  | 866
 |  | 12310 |  | 866
 |  | 77744 |  | 411
 |  | 77744 |  | 411
HOPEFUL OUTCOME: |  | SEAT NUMBER | RESERVE_NUMBER | BOOKING_ID
 | 56001-1 | 56001 | V2 | 122
 | 56001-2 | 56001 | V3 | 122
 | 56001-3 | 56001 | V4 | 122
 | 56001-4 | 56001 | M3 | 122
 | 12432-1 | 12432 | J1 | 568
 | 12432-2 | 12432 | J2 | 568
 | 12432-3 | 12432 | J1 | 568
 | 12432-4 | 12432 | J2 | 568
 | 89922-1 | 89922 | L34 | 621
 | 89922-2 | 89922 | L34 | 621
 | 12310-1 | 12310 | M55 | 866
 | 12310-2 | 12310 | M56 | 866
 | 12310-3 | 12310 | M56 | 866
 | 77744-1 | 77744 | F2 | 411
 | 77744-2 | 77744 | F2 | 411
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 165610 | 167344
2 | 166480 | 167796
3 | 137938 | 137645
4 | 125026 | 124963
5 | 146499 | 137011
6 | 145028 | 145160
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
 |  |  |  |  |  |  | 20
2001-12-31 00:00:00 |  |  | 47283 |  |  |  | 530
2002-01-06 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | 20412
Spreadsheet: 13798a7d-9ca2-4d28-987f-ea09105df8ec
Sheet: RESULTADOS

TABLA DE POSICIONES FINAL
SUB 14 MIXTO
PRIMER PUESTO
SEGUNDO PUESTO
TERCER PUESTO
CUARTO PUESTO
[NAME] PUESTO
SEXTO PUESTO
SEPTIMO PUESTO
GOLEADOR
VALLA MENOS VENCIDA
SUB 19 VARONES
PRIMER PUESTO
SEGUNDO PUESTO
TERCER PUESTO
CUARTO PUESTO
[NAME] PUESTO
SEXTO PUESTO
SEPTIMO PUESTO
OCTAVO PUESTO
NOVENO PUESTO
DECIMO PUESTO
GOLEADOR
VALLA MENOS VENCIDA
Spreadsheet: 127001d1320098563-extracting-wanted-data-from-execl-file-example-file
Sheet: גיליון2

eeee | rrrr | mmm
Trial 1 | 2.58 | sdsde44
Trial 2 (Last) | 2.96 | df4dx
eeee | rrrr | mmm
Trial 1 | 118.700mUI | Swing 2
Trial 2 | 116.000mUI | Swing 1
Trial 3 | 124.300mUI | Swing 0
Trial 4 (Last) | 113.900mUI | Swing 3
Spreadsheet: 755666d1637020348-how-to-count-the-occurrences-of-the-largest-number-1744-count-maxima
Sheet: Sheet1

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | OCCURANCES
 |  |  | Player 1 | 455 | 458 | 464 | 510 | 351 | 538 | 383 | 352 | 355 | 351
 |  |  | Player 2 | 636 | 555 | 607 | 588 | 558 | 665 | 496 | 658 | 455 | 498
 |  |  | Player 3 | 439 | 427 | 308 | 449 | 365 | 427 | 260 | 235 | 221 | 363
 |  |  | Player 4 | 540 | 709 | 738 | 335 | 568 | 667 | 668 | 628 | 496 | 460
 |  |  | Player 5 | 468 | 425 | 504 | 578 | 388 | 421 | 456 | 531 | 369 | 296
 |  |  | Player 6 | 644 | 620 | 601 | 145 | 95 | 535 | 400 | 484 | 423 | 441
 |  |  | Player 7 | 634 | 502 | 0 | 515 | 566 | 530 | 384 | 480 | 447 | 404
 |  |  | Player 8 | 613 | 611 | 459 | 414 | 482 | 529 | 422 | 534 | 453 | 393
 |  |  | Player 9 | 382 | 421 | 571 | 474 | 367 | 353 | 565 | 505 | 409 | 432
 |  |  | Player 10 | 608 | 704 | 622 | 553 | 404 | 668 | 332 | 570 | 502 | 589
 |  |  | Player 11 | 444 | 416 | 654 | 203 | 452 | 558 | 424 | 561 | 558 | 550
 |  |  | Player 12 | 590 | 365 | 427 | 314 | 254 | 382 | 332 | 542 | 447 | 428
 |  |  | Player 13 | 667 | 510 | 680 | 626 | 603 | 590 | 498 | 555 | 458 | 499
Spreadsheet: 90212d1289962590-2-way-lookup-from-a-basic-table-in-excel-draft_costs_v2-2-
Sheet: Sheet1

PRODUCT | SIZE | COST |  |  |  | PRODUCT
A | 5 | 57 |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
B | 7 | 86 |  | SIZE | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 21 | 23 | 24 | 25 | 26
M | 5 | 69 |  |  | 2 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 21 | 23 | 24 | 25 | 26 | 27 | 28 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 24 | 25 | 26
Z | 10 | 54 |  |  | 3 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 38 | 39 | 40
 |  |  |  |  | 4 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 52 | 53 | 54
 |  |  |  |  | 5 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 66 | 67 | 68
 |  |  |  |  | 6 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 80 | 81 | 82
 |  |  |  |  | 7 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 94 | 95 | 96
 |  |  |  |  | 8 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 86 | 87 | 88 | 89 | 90
 |  |  |  |  | 9 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 52 | 53 | 54
 |  |  |  |  | 10 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 52 | 53 | 54
 |  | 1) Locked the cells associated with the matrix 2) Change the order of the Index function so you look down before you look to the right
 |  |  |  |  |  | The Idea: The product and size are entered into cells in columns A and B, then the formula in C will look in the table and return the correct value…
Spreadsheet: 765694d1643503626-product-function-that-applies-to-a-variable-number-of-cells-excel-variable-n-product
Sheet: Sheet1

5
 | Product of the last five numbers in B | Product of the last n numbers in B, where n is a variable in A1
1.036914045423472
1.016488787039866
1.04764119012382
1.111505268410407
0.9547683399269247
1.019077832368715
0.9880452520988878
1.038302761895952
1.073109116720374
1.086698399432288
1.05650127017701
1.074638566688328
1.077271820806726
0.9791504881404909
1.026551368520157
0.9998063456963888
1.1291598239807
1.060913076080365
1.013257433337223
1.002806694487844
0.9607881677896379
1.116773064617033
1.126411390900495
1.086247068223809
1.111529797518197
0.9729853171751798
1.017468059280222
1.045493819768369
1.062408875203532
0.9641915943760297
Spreadsheet: 24e6000a-5b7c-4f5c-9d0b-37b837823c81
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8233 | 47130 | [NAME] | Wall | USA | 413 | [NAME] | 00:02:09 | 01:37:44 | 00:01:30 | 01:05:46 | 1 | 03:21:54
8233 | 47131 | [NAME] | [NAME] | USA | 411 | 00:37:29 | 00:02:24 | 01:43:51 | 00:01:49 | 01:14:26 | 2 | 03:40:01
8233 | 47132 | [NAME] | Scranton | USA | 412 | 00:33:59 | 00:02:05 | [NAME] | [NAME] | 01:22:16 | 3 | 03:57:07
8233 | 58350 | G L | [NAME] | USA | 410 | 00:40:04 | 00:03:34 | 01:59:37 | 00:03:00 | 01:31:39 | 4 | 04:17:57
Spreadsheet: 32714d1228897867-index-small-row-formula-ref-error-index-small-row-example
Sheet: RecapWk12

 |  | Account |  | Name | Column1 | Column2
 |  | 1 | 5 | [NAME] | 11625 | 151
 |  | 1 | 5 | [NAME] | 21526 | 53
 |  | 1 | 5 | [NAME] | 11476 | 37
 |  | 1 | 5 | [NAME] | 10495 | 384
 |  | 1 | 5 | [NAME] | 21147 | -291
 |  | 1 | 5 | [NAME] | 22801 | 525
 |  | 1 | 5 | [NAME] | 87874 | 1675
 |  | 1 | 5 | [NAME] | 87709 | -154
 |  | 2 | 5 | [NAME] | 244322 | -16269
 |  | 2 | 5 | [NAME] | 239611 | -26549
 |  | 2 | 5 | [NAME] | 235472 | -31363
 |  | 2 | 5 | [NAME] | 223269 | -34636
 |  | 2 | 5 | [NAME] | 180816 | -20463
 |  | 2 | 5 | [NAME] | 166863 | -22227
 |  | 2 | 5 | [NAME] | 238002 | -18451
 |  | 2 | 5 | [NAME] | 245001 | -11112
Spreadsheet: 683970d1593084599-count-with-two-conditions-excel-problem
Sheet: Summ

ANM Audits - FY 2020-21
S.No. | Audit done by | Quarter-1 |  |  | Quarter-2 |  |  | Quarter-3 |  |  | Quarter-4 |  |  | Grand Total | %  to total
 |  | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | Grand Total | %  to total
1 | S M Basha | 0 | 0
 | Prakash Naidu | 0 | 0
 | Bharat Kumar C | 0 | 0
 | Grand total
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Nov4-Nov10p

Pavilion
 | 2012-11-04 00:00:00 |  |  | Thru | 2012-11-10 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 58235d1258527455-making-months-books-template2
Sheet: OTHER EXPENDITURES

DAY | TO WHOM PAID | FORM OF PAYMENT | ACCOUNT | AMOUNT
 |  |  | ADVERTISING | 250 |  |  |  | MDSE AND MAT PD
 |  |  |  |  |  |  |  | ACCOUNTING
 |  |  |  |  |  |  |  | ADVERTISING
 |  |  |  |  |  |  |  | AUTO EXPENSE
 |  |  |  |  |  |  |  | ELECRTICITY
 |  |  |  |  |  |  |  | HEAT
 |  |  |  |  |  |  |  | INSURANCE
 |  |  |  |  |  |  |  | INTEREST(AFC)
 |  |  |  |  |  |  |  | HEALTH INS. PREMIUM
 |  |  |  |  |  |  |  | LEGAL EXPENSE
 |  |  |  |  |  |  |  | LICENSES
 |  |  |  |  |  |  |  | MISC. EXP.
 |  |  |  |  |  |  |  | OFFICE EXP.
 |  |  |  |  |  |  |  | POSTAGE
 |  |  |  |  |  |  |  | RENT
 |  |  |  |  |  |  |  | REPAIRS
 |  |  |  |  |  |  |  | TRASH
 |  |  |  |  |  |  |  | TAX/PROP.
 |  |  |  |  |  |  |  | SELLING EXP.
 |  |  |  |  |  |  |  | SUPPLIES
 |  |  |  |  |  |  |  | TELEPHONE
 |  |  |  |  |  |  |  | TRAVELING EXP. HOTEL
 |  |  |  |  |  |  |  | TRUCK FUEL
 |  |  |  |  |  |  |  | TOLLS
 |  |  |  |  |  |  |  | AUCTION FEES
 |  |  |  |  |  |  |  | TOOLS
 |  |  |  |  |  |  |  | CHG. CARD INT.
Spreadsheet: 822472d1679367334-when-column-a-unicode-a2-19968-corresponding-to-column-b-continuous-from-top-to-bottom-help21
Sheet: Sheet1

 |  |  |  | NO HELPER COLUMN
一 | 陈老师 | 陈老师
1 | 31231212 | 陈老师 |  |  | 陈老师
2 | 123114 | 陈老师 |  |  | 陈老师
二 | [NAME] | [NAME] |  |  | [NAME]
1 | 43534 | [NAME] |  |  | [NAME]
2 | 1312312312 | [NAME] |  |  | [NAME]
3 | GF665 | [NAME] |  |  | [NAME]
4 | [NAME] | [NAME] |  |  | [NAME]
三 | ABC | ABC |  |  | ABC
1 | 554 | ABC |  |  | ABC
2 | 88888 | ABC |  |  | ABC
3 | WODE | ABC |  |  | ABC
Spreadsheet: 28593d1222909270-vlookup-information-in-a-table-and-round-up-file-attached-exampleproblem
Sheet: Tables

Table 450.3(A) Maximum Rating or Setting of Overcurrent Protection for Transformers Over 600V (as a percentage of Transformer-Rated Current)
Location Limitations | Transormer Rated Impedance | Primary Protection over 600 Volts |  | Secondary Protection (See Note 2)
 |  | Circuit Breaker (See Note 4) | [NAME] | Over 600V |  | 600 Volts or Less
 |  |  |  | Circuit Breaker (See Note 4) | [NAME] | [NAME] Or Fuse Rating
Any Location | Not More than 6% | 6 | 3 | 3 | 2.5 | 1.25
 |  | (See Note 1) | (See Note 1) | (See Note 1) | (See Note 1) | (See Note 1)
 | More than 6% and not more than 10% | 4 | 3 | 2.5 | 2.25 | 1.25
 |  | (See Note 1) | (See Note 1) | (See Note 1) | (See Note 1) | (See Note 1)
Supervised Locations Only (See Note 3) | Any | 3 | 2.5 | Not Required | Not Required | Not Required
 |  | (See Note 1) | (See Note 1)
 | Not More than 6% | 6 | 3 | 3 | 2.5 | 2.5
 |  |  |  | (See Note 5) | (See Note 5) | (See Note 5)
 | More than 6% and not more than 10% | 4 | 3 | 2.5 | 2.25 | 2.5
 |  |  |  | (See Note 5) | (See Note 5) | (See Note 5)
Table 450.3(B) Maximum Rating or Setting of Overcurrent Protection for Transformers 600 Volts  and Less (As a Percentage of Transformer-Rated Current)
Protection Method | Primary Protection |  |  | Secondary Protection(See Note 2.)
 | Currents of 9 Amperes or More | Currents Less Than 9 Amperes | Currents Less Than 2 Amperes | Currents of 9 Amperes or More | Currents Less Than 9 Amperes
Primary only protection | 1.25 | 1.67 | 3 | Not Required | Not Required
 | (See Note 1)
Primary and Secondary Protection | 2.5 | 2.5 | 2.5 | 1.25 | 1.67
 | (See Note 3) | (See Note 3) | (See Note 3) | (See Note 1) | (See Note 1)
Standard Amper Ratings for Fuses and Invers Time Circuit Breakers Found at 240.6 (A)
15
20
25
30
35
40
45
50
60
70
80
90
100
110
125
150
175
200
225
250
300
350
400
450
500
600
700
800
1000
1200
1600
2000
2500
3000
4000
5000
6000
Spreadsheet: 781738d1653505711-request-formula-guidance-to-ensure-all-table-values-have-been-incorporated-to-a-range-test-roster
Sheet: Sheet1

POSITION | 1ST | 2ND | 3RD | 4th | 5th | 6th | 7th
PITCHER
CATCHER
FIRST
SECOND
SHORT
THIRD
RIGHT
RIGHT C
LEFT C
LEFT
BENCH
BENCH
 | EQUAL A TRUE / FALSE STATEMENT VERIFYING IF ALL VALUES IN THE TABLE BELOW HAVE BEEN USED
Table
ABE
[NAME]
[NAME]
BILL
[NAME]
CLAY
FRANK
JOEY
DANNY
[NAME]
RANDY
MATEO
Spreadsheet: 482337d1475016783-find-number-of-days-without-inventory-copy-of-test-file
Sheet: Sheet1

Product | Ship Date | Sold Date | Column1 | Column2 |  |  |  | Desired Values |  |  | Date Range
A | 2016-03-28 00:00:00 | 2016-05-15 00:00:00 |  |  |  |  |  | Product A |  |  | Start | 2016-04-01 00:00:00
A | 2016-03-28 00:00:00 | 2016-06-03 00:00:00 |  |  |  |  |  | Product B |  |  | End | 2016-09-01 00:00:00
A | 2016-03-28 00:00:00 | 2016-07-15 00:00:00 |  |  |  |  |  | Product C
A | 2016-04-15 00:00:00 | 2016-07-15 00:00:00
A | 2016-07-27 00:00:00 | 2016-08-18 00:00:00
A | 2016-07-27 00:00:00 | 2016-08-26 00:00:00
B | 2016-03-29 00:00:00 | 2016-07-18 00:00:00
B | 2016-06-30 00:00:00 | 2016-08-25 00:00:00
C | 2016-04-30 00:00:00 | 2016-05-05 00:00:00
C | 2016-08-11 00:00:00 | 2016-09-25 00:00:00
Spreadsheet: 84462d1284512950-transpose-columns-of-data-in-rows-copy-of-excelhelptranspose-1-
Sheet: Expected Format

[NAME]
Store | Week | Amount
[NAME] | Week 1 | 49457
[NAME] | Week 2 | 50278
[NAME] | Week 3 | 48173
[NAME] | Week 4 | 54061
Eglinton | Week 1 | 212394
Eglinton | Week 2 | 206661
Eglinton | Week 3 | 213128
Eglinton | Week 4 | 197135
Eglinton8 | Week 1 | 310964
Eglinton8 | Week 2 | 302570
Eglinton8 | Week 3 | 312039
Eglinton8 | Week 4 | 288623
Spreadsheet: 0b73d5d9-2991-4ccb-841a-1dbea0222a5b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-05-19 09:40:17.930000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.704 | 102.579 | 102.454 | 102.079
4.5 | 102.617 | 102.492 | 102.367 | 101.992 |  | Note: | Refer To Price [NAME]
4.375 | 102.08 | 101.955 | 101.83 | 101.455 |  |  | For all Price Adjs
4.25 | 101.473 | 101.348 | 101.223 | 100.598
4.125 | 100.619 | 100.494 | 100.369 | 99.744
4 | 99.605 | 99.48 | 99.355 | 98.73
3.875 | 98.552 | 98.427 | 98.302 | 97.677
3.75 | 97.677 | 97.552 | 97.427 | 96.802
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.574 | 102.449 | 102.324 | 101.949
3.625 | 102.426 | 102.301 | 102.176 | 101.801
3.5 | 101.868 | 101.743 | 101.618 | 101.243
3.375 | 101.143 | 101.018 | 100.893 | 100.268
3.25 | 100.391 | 100.266 | 100.141 | 99.516
3.125 | 99.889 | 99.764 | 99.639 | 99.014 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-02 09:40:17.930000
30 DAY | 2014-06-17 09:40:17.930000
45 DAY | 2014-07-02 09:40:17.930000
60 DAY | 2014-07-17 09:40:17.930000
90 DAY | 2014-08-16 09:40:17.930000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.