tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: afea9bf5-d380-4a7e-942a-ba1042e066bb
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TCD4 | Test | TCD4 | CD4 Count for Immune Monitoring, Blood | CD4 T-Cell Count | Flow Cytometry, Single Platform (CD3, CD4, CD8, CD45) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | [NAME] must arrive within 72 hours of draw. Draw and package specimen as close to shipping time as possible. Ship specimen overnight.   Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Do not aliquot. Additional Information: 1. Date of draw is required. 2. For serial monitoring, we recommend that specimen draws be performed at the same time of day. | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	Mild OK; Gross reject Icterus	NA Other	ACD or heparinized blood, specimen in aliquot tube | The appropriate age-related reference values will be provided on the report. | Monday through Sunday | Same day/1 day | 2 days |  | Profile |  |  |  |  | Rochester
TCD4 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 72 hours
TCD4 | Result | 3321 | CD45 [NAME], Flow | CD45 [NAME], Flow | Numeric |  |  |  |  | thou/mcL |  |  |  |  |  |  |  |  |  | 27071-0 | Cells.CD45:NCnc:Pt:[NAME]:Qn:
TCD4 | Result | 3316 | % CD3 (T Cells) | % CD3 (T Cells) | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 8124-0 | Cells.CD3/100 cells:NFr:Pt:[NAME]:Qn:
TCD4 | Result | 3319 | % CD4 (Helper Cells) | % CD4 (Helper Cells) | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 8123-2 | Cells.CD3+CD4+/100 cells:NFr:Pt:[NAME]:Qn:
TCD4 | Result | 3320 | % CD8 (Supp'r Cells) | % CD8 (Supp'r Cells) | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 8101-8 | Cells.CD3+CD8+/100 cells:NFr:Pt:[NAME]:Qn:
TCD4 | Result | 3322 | CD3 (T Cells) | CD3 (T Cells) | Numeric |  |  |  |  | cells/mcL |  |  |  |  |  |  |  |  |  | 8122-4 | Cells.CD3:NCnc:Pt:[NAME]:Qn:
TCD4 | Result | 3325 | CD4 (Helper Cells) | CD4 (Helper Cells) | Numeric |  |  |  |  | cells/mcL |  |  |  |  |  |  |  |  |  | 24467-3 | Cells.CD3+CD4+:NCnc:Pt:[NAME]:Qn:
TCD4 | Result | 3326 | CD8 (Supp'r Cells) | CD8 (Supp'r Cells) | Numeric |  |  |  |  | cells/mcL |  |  |  |  |  |  |  |  |  | 14135-8 | Cells.CD3+CD8+:NCnc:Pt:[NAME]:Qn:
TCD4 | Result | 3327 | H/S Ratio | H/S Ratio | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54218-3 | Cells.CD3+CD4+/Cells.CD3+CD8+:NRto:Pt:[NAME]:Qn:
TCD4 | Billing Component | TCD4 |  | Absolute CD4/CD8 Count |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86360
TCD4 | Billing Component | TCD4 |  | T-cells total count |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86359
Spreadsheet: 534582d1503338419-merge-multiple-lists-with-blank-rows-list-gk
Sheet: Data

[NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Name | Grade | Degree |  | Name | Grade | Degree |  | Name | Grade | Degree
A1 | A123 | 23 |  | B2 | B123 | 26 |  | [NAME] | d4 | 12
A2 | A456 | 34 |  | [NAME] | A345 | 45 |  | c5 | a34 | 10
A4 | A567 | 35 |  | b7 | B789 | 33
 |  |  |  |  |  |  |  | C4 | 45 | 23
 |  |  |  | b10 | N123 | 345
Spreadsheet: 864470d1711631337-help-with-num-error-to-excel-forum
Sheet: Dummy

 | date
 | extra payment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
1=LB, 2=HI | CC Name | Balance at c1 date | APR | min pay | min pay2 | min pay | months to po | last pay date | total int | balance | date | months to payoff |  |  | last date | total payment 1 | total payment 2 | total interest
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
1 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2
3
4
5
6
7
8
9
10
1 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2
3
4
5
6
7
8
9
10
Spreadsheet: 782294d1653962606-how-to-find-if-number-is-within-range-and-return-yes-or-no-value-aircraft-tasks-with-ranges-and-aircraft-serial-numbers
Sheet: Sheet1

Range | 397 | 441 | 789 | 841 | 893 | 1025 | 1106 | 1791 | 1800 | 1951 |  |  |  | 1 | 1 | 2 | 2 | 3 | 3
A33F  S/N 1791-1951=Y | No | No | No | No | Yes | No | No | Yes | Yes | Yes
A33F  S/N 0441-0789=Y S/N 0893=Y S/N 1025=Y | No | Yes | Yes | No | Yes | Yes | No | No | No | No
A33F  S/N 1791-1951=Y
A33F  S/N 0441-0789=Y S/N 0893=Y S/N 1025=Y
Spreadsheet: 694016d1599298990-consolidated-report-from-different-tables-tped
Sheet: Sheet1

color | m | l | xl | 2xl | 3xl | 4xl | 5xl |  | color | m | l | xl | 2xl | 3xl | 4xl | 5xl |  | color | m | l | xl | 2xl | 3xl | 4xl | 5xl
green | 1 | 2 |  |  |  |  |  |  | blue | 2 |  | 2 |  | 2 |  | 9 |  | orange | 1 | 2 | 2 |  |  | 6
red |  | 1 | 2 | 1 |  | 5 |  |  | orange |  |  | 2 |  | 2 |  | 8 |  | purple |  | 3 | 6 |  | 6 |  | 7
yellow |  |  |  |  | 2 |  | 3 |  | red |  | 5 | 2 | 2 |  |  | 2 |  | yellow | 6 | 4 | 3 |  |  | 5 | 5
 |  |  |  |  |  |  |  |  | yellow | 6 | 3 |  | 6 |  | 5
CONSOLIDATED RESULT
color | m | l | xl | 2xl | 3xl | 4xl | 5xl
green
orange
purple
red |  | 6 | 4 | 3 |  | 5 | 2 | expected output
yellow
Spreadsheet: 816469d1675648058-solved-using-a-sequence-that-restarts-n-times-and-spills-book2
Sheet: Sheet1

Sequence Repeated 3 Times |  | Rows | 87
RESULT | SPILL
 | 10003058
 | 10003059
 | 10003060
 | 10003061
 | 10003062
 | 10003063
 | 10003064
 | 10003065
 | 10003066
 | 10003067
 | 10003068
 | 10003069
 | 10003070
 | 10003071
 | 10003072
 | 10003073
 | 10003074
 | 10003075
 | 10003076
 | 10003077
 | 10003078
 | 10003079
 | 10003080
 | 10003081
 | 10003082
 | 10003083
 | 10003084
 | 10003085
 | 10003086
 | 10003087
 | 10003088
 | 10003089
 | 10003090
 | 10003091
 | 10003092
 | 10003093
 | 10003094
 | 10003095
 | 10003096
 | 10003097
 | 10003098
 | 10003099
 | 10003100
 | 10003101
 | 10003102
 | 10003103
 | 10003104
 | 10003105
 | 10003106
 | 10003107
 | 10003108
 | 10003109
 | 10003110
 | 10003111
 | 10003112
 | 10003113
 | 10003114
 | 10003115
 | 10003116
 | 10003117
 | 10003118
 | 10003119
 | 10003120
 | 10003121
 | 10003122
 | 10003123
 | 10003124
 | 10003125
 | 10003126
 | 10003127
 | 10003128
 | 10003129
 | 10003130
 | 10003131
 | 10003132
 | 10003133
 | 10003134
 | 10003135
 | 10003136
 | 10003137
 | 10003138
 | 10003139
 | 10003140
 | 10003141
 | 10003142
 | 10003143
Spreadsheet: 853878d1703838636-sorting-data-with-date-range-in-ascending-order-tc-sort-by-dates-testing-03
Sheet: Sheet1

 | From | 2026-01-20 00:00:00 |  | Till | 2027-06-27 00:00:00
S/N | Operator | Broker | Vessel | Delivery date | Date of declaration | Other remarks |  | Vessel AAD should not  appear on cell (F5) as the date range not matching.
S/N | Operator | Broker | Vessel | Delivery date | Date of declaration | Other remarks
 | EIG | IGK | ABC | 21/08/2021 | 2031-06-22 00:00:00 | 22 Jun 2031 is a Sunday
 | EIG | IGK | DEF | 14/11/2021 | 2031-09-15 00:00:00
 | EIG | IGK | GHI | 13/01/2022 | 2031-11-14 00:00:00
 | EIG | TLA | JKL | 17/03/2022 | 2025-11-17 00:00:00
 | EIG | TLA | MNO | 2022-10-05 00:00:00 | 2027-09-01 00:00:00 | 9 Jan 2027 is a Saturday
 | EIG | TLA | PQR | 30/08/2022 | 2027-04-30 00:00:00
 | EIG | KEO | STU | 2021-07-06 00:00:00 | 2026-08-04 00:00:00
 | EIG | KEO | VWX | 28/05/2021 | 2028-03-29 00:00:00
 | EIG | KEO | ZYA | 2021-07-06 00:00:00 | 2028-08-04 00:00:00 | 8 Apr is a Saturday
 | EIG | KEO | AAb | 24/10/2022 | 2027-07-26 00:00:00
 | EIG | KEO | AAC | 21/03/2023 | 2023-01-21 00:00:00
 | EIG | KEO | AAD | 15/05/2023 | 2023-03-15 00:00:00
 | EIG | KEO | AAE | 2023-04-09 00:00:00 | 2028-04-03 00:00:00
 | EIG | KEO | AAF | 27/11/2023 | 2028-05-27 00:00:00
 | EIG | YUT | AAG | 30/06/2022 | 2027-03-30 00:00:00
 | EIG | HMD | AAH | 30/10/2023 | 2026-07-30 00:00:00
 | EIG | HMD | AAI | 29/09/2023 | 2026-09-29 00:00:00
 | EIG | TLA | AAJ | 19/08/2023 | 2026-06-20 00:00:00
Spreadsheet: 721992d1614978874-sumifs-formula-msk8tlyn-example_1
Sheet: Sheet1

Day | Date | Shift | Delivery | Pickup | Return | Cancel
Monday | 2021-02-01 00:00:00 | Day | 1 | 1 | 0 | 0
Monday | 2021-02-01 00:00:00 | Day | 0 | 2 | 0 | 0
Monday | 2021-02-01 00:00:00 | Swing | 0 | 0 | 0 | 1
Tuesday | 2021-02-02 00:00:00 | Swing | 3 | 2 | 0 | 0
Tuesday | 2021-02-02 00:00:00 | Night | 0 | 2 | 1 | 0
Tuesday | 2021-02-02 00:00:00 | Night | 1 | 0 | 0 | 0
Wednesday | 2021-02-03 00:00:00 | Day | 0 | 1 | 0 | 0
Wednesday | 2021-02-03 00:00:00 | Day | 0 | 3 | 1 | 0
Wednesday | 2021-02-03 00:00:00 | Swing | 3 | 1 | 0 | 1
Thursday | 2021-02-04 00:00:00 | Swing | 0 | 3 | 0 | 0
Thursday | 2021-02-04 00:00:00 | Night | 0 | 4 | 1 | 0
Thursday | 2021-02-04 00:00:00 | Day | 2 | 2 | 0 | 0
Friday | 2021-02-05 00:00:00 | Day | 0 | 0 | 0 | 0
Friday | 2021-02-05 00:00:00 | Swing | 2 | 3 | 2 | 1
Friday | 2021-02-05 00:00:00 | Swing | 2 | 0 | 0 | 0
Saturday | 2021-02-06 00:00:00 | Night | 1 | 0 | 3 | 0
Saturday | 2021-02-06 00:00:00 | Day | 2 | 3 | 0 | 0
Saturday | 2021-02-06 00:00:00 | Day | 0 | 2 | 0 | 0
Sunday | 2021-02-07 00:00:00 | Swing | 1 | 2 | 1 | 0
Sunday | 2021-02-07 00:00:00 | Swing | 3 | 4 | 0 | 1
Sunday | 2021-02-07 00:00:00 | Night | 3 | 0 | 1 | 0
Monday | 2021-02-08 00:00:00 | Day | 5 | 1 | 2 | 0
Monday | 2021-02-08 00:00:00 | Day | 6 | 1 | 2 | 0
Monday | 2021-02-08 00:00:00 | Swing | 1 | 5 | 1 | 0
Tuesday | 2021-02-09 00:00:00 | Swing | 1 | 5 | 0 | 1
Tuesday | 2021-02-09 00:00:00 | Night | 0 | 0 | 0 | 0
Tuesday | 2021-02-09 00:00:00 | Night | 3 | 1 | 1 | 0
Wednesday | 2021-02-10 00:00:00 | Day | 1 | 0 | 1 | 1
Wednesday | 2021-02-10 00:00:00 | Day | 1 | 1 | 0 | 0
Wednesday | 2021-02-10 00:00:00 | Swing | 1 | 3 | 1 | 1
Thursday | 2021-02-11 00:00:00 | Swing | 1 | 2 | 2 | 1
Thursday | 2021-02-11 00:00:00 | Night | 2 | 1 | 0 | 0
Thursday | 2021-02-11 00:00:00 | Day | 4 | 1 | 0 | 0
Friday | 2021-02-12 00:00:00 | Day | 3 | 0 | 3 | 1
Friday | 2021-02-12 00:00:00 | Swing | 10 | 2 | 0 | 1
Friday | 2021-02-12 00:00:00 | Swing | 9 | 1 | 1 | 0
Saturday | 2021-02-13 00:00:00 | Night | 1 | 0 | 2 | 0
Saturday | 2021-02-13 00:00:00 | Day | 2 | 1 | 2 | 1
Saturday | 2021-02-13 00:00:00 | Day | 2 | 0 | 0 | 1
Sunday | 2021-02-14 00:00:00 | Swing | 7 | 3 | 1 | 0
Sunday | 2021-02-14 00:00:00 | Swing | 7 | 3 | 0 | 1
Sunday | 2021-02-14 00:00:00 | Night | 1 | 1 | 1 | 0
Spreadsheet: 162554d1339968776-count-doubles-demo
Sheet: גיליון1

2 | 10 | 16 | 20 | 22 | 36 | 37 | 42 | 43 | 50 | 51 | 53 | 54 | 56 | 60 | 66 | 67 |  | 36 | 37 |  | 42 | 43 |  | 50 | 51 |  | 53 | 54 |  | 66 | 67
5 | 13 | 15 | 26 | 27 | 29 | 32 | 33 | 38 | 42 | 43 | 45 | 47 | 48 | 59 | 62 | 70 |  | 26 | 27 |  | 32 | 33 |  | 42 | 43 |  | 47 | 48
18 | 19 | 22 | 26 | 31 | 39 | 41 | 43 | 45 | 47 | 48 | 53 | 58 | 60 | 61 | 66 | 67 |  | 18 | 19 |  | 47 | 48 |  | 60 | 61 |  | 66 | 67
2 | 3 | 5 | 9 | 11 | 12 | 16 | 17 | 26 | 29 | 45 | 47 | 53 | 57 | 58 | 64 | 68 |  | 2 | 3 |  | 11 | 12 |  | 16 | 17 |  | 57 | 58
6 | 17 | 23 | 28 | 32 | 35 | 38 | 39 | 40 | 49 | 53 | 54 | 55 | 56 | 58 | 60 | 68 |  | 38 | 39 |  | 39 | 40 |  | 53 | 54 |  | 54 | 55 |  | 55 | 56
1 | 7 | 8 | 11 | 17 | 22 | 25 | 26 | 32 | 33 | 49 | 50 | 59 | 63 | 65 | 66 | 67
6 | 10 | 17 | 22 | 23 | 25 | 27 | 29 | 31 | 35 | 36 | 39 | 40 | 46 | 53 | 62 | 69
10 | 13 | 15 | 16 | 21 | 23 | 29 | 30 | 31 | 38 | 41 | 49 | 55 | 57 | 64 | 66 | 69
8 | 13 | 18 | 22 | 23 | 28 | 32 | 33 | 37 | 40 | 52 | 53 | 56 | 57 | 60 | 63 | 67
4 | 9 | 11 | 14 | 17 | 18 | 21 | 22 | 27 | 32 | 38 | 43 | 44 | 46 | 49 | 57 | 70
Spreadsheet: 118538d1313752729-compare-and-split-duplicate-data-in-excell-new-microsoft-excel-worksheet-2-
Sheet: INT

 | Data 1 |  |  |  |  | Data 2
 | ACCOUNT NUM | AMOUNT MST | VOUCHER NO |  |  | VOUCHER NO. | AMOUNT MST | test
 | C00000089 | 326000000 | 50-BKB-10-002128 |  |  | 50-BKB-10-002128 | 326000000 |  |  | No Voucher
 | C00000093 | 100000000 | 50-BKB-10-002128 |  |  | 50-BKB-10-002128 | 100000000
 | C00000094 | 93000000 | 50-BKB-10-002128 |  |  | 50-BKB-10-002128 | 226000000
 | C00000095 | 226000000 | 50-BKB-10-002128 |  |  | 50-BKB-10-002128 | 100000000
 | C00000096 | 226000001 | 50-BKB-10-002129 |  |  | 50-BKB-10-002129 | 226000001
 | C00000097 | 226000002 | 50-BKB-10-002130
 | C00000098 | 226000003 | 50-BKB-10-002131
 | C00000099 | 226000004 | 50-BKB-10-002132
Spreadsheet: 0288e4a1-9715-4cc4-8c14-018bb9293c09
Sheet: Sheet1

FRS OnLine Data Entry Screen 010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  |  | The University of North Carolina General Administration
 |  |  |  |  |  |  | Original / Certified
TC = 020 |  |  |  |  |  |  | Budget Entry
 | Account Number |  |  | TC | Ref # 1 | Date | Description | Amount | D/C | Ref # 2 | DO NOT
 |  | 10 |  | 1 | 7 | 4 | 20 | 12 | 1 | 7 | KEY
 |  | N |  | N | A-N | N | A-N | N | A | A-N
1 |  |  |  | 0
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Prepared By |  |  | Approved By |  |  | Date | Comments:
 | mdf |  |  |  |  |  | Total | 0
Spreadsheet: thomas_martin__39855__2002 Plan Worksheet CC150297
Sheet: 2001 Headcount

Enron North America
Monthly  Headcount
As of July 31, 2001
 | Jan | Feb | Mar | 1st QTR | Apr | May | Jun | 2nd QTR | Jul | Aug | Sep | 3rd QTR | Oct | Nov | Dec | 4th QTR | 2001 YTD
 | Actual | Actual | Actual | Avg | Actual | Actual | Actual | Avg | Actual | Plan | Plan | Avg | Plan | Plan | Plan | Avg | Average
Team:
Cost Center:
Executive | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Director | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Manager | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Total Commercial
YTD Comm. average
Associates | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Analysts | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Other Non-Comm | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Technical | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Temp/Contract | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Admin Assistant | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Total Non-Comm
Total employees
YTD total average
Spreadsheet: 881966d1730211581-extracting-data-from-machine-generated-participants-list-extracting-data-from-machine-generated-participants-list
Sheet: Blad1 (2)

Participants | Name | Attribute | Value |  | Name | Age | Camp | Bed | [NAME] | Birthday
Name = "[NAME]" |  |  |  |  | [NAME]
Age = "36" |  |  |  |  | [NAME]
Birthday = "April 4" |  |  |  |  | [NAME]
Camp = "64" |  |  |  |  | [NAME]
Bed = "1a" |  |  |  |  | Eagle
Name = "Alice"
Age = "35" |  |  |  |  | 3 helper columns:
Camp = "Frisk"
Bed = "1g"
Name = "Brad"
Age = "26"
Linnen = "No" |  |  |  |  | In G2, copy across and down:
Camp = "14a"
Bed = "1b"
Name = "Mary"
Birthday  = "6th june"
Camp = "Eagle"
Age = "35"
Bed = "1v"
Name = "Eagle"
Age = "32"
Camp = "62"
Bed = "1c"
Spreadsheet: 539100d1505962845-how-to-plot-the-mean-value-into-a-graph-and-the-error-bars-representing-standard-deviation-field_measurements
Sheet: Sheet1

Field measurements |  |  | Mean | std
Location 1
23.3 | 23.4 | 23.1
23.4 | 23.1 | 23.3
23.9 | 23.3 | 23.4
23.6 | 23.1 | 23.4
23.6 | 23.4 | 23.4
23.6 | 23.6 | 23.7
23.7 | 23.1 | 23.1
23.3 | 23.1 | 23.3 |  |  |  |  |  |  |  |  | North | East | South | West
22.8 | 22.7 | 22.8 |  |  |  |  |  |  |  | 09:15:00 | 1.2 | 4.2 | 0.3 | 1.7
23 | 22.6 | 22.7 |  |  |  |  |  |  |  | 09:24:00 | -0.1 | 9.2 | 0 | -2.2
Location2 |  |  |  |  |  |  |  |  |  | 09:30:00 | -5.2 | 6.4 | -3.4 | -4.7
23.1 | 23 | 22.9 |  |  |  |  |  |  |  | 09:37:00 | -2 | 8.9 | 0 | 0
22.6 | 23.4 | 23.3 |  |  |  |  |  |  |  | 09:45:00 | -0.8 | 8.9 | -5.2 | -0.9
23.2 | 23.2 | 23.3 |  |  |  |  |  |  |  | 09:54:00 | 1.4 | 7.3 | -5.1 | 0
23.3 | 23.1 | 23 |  |  |  |  |  |  |  | 10:02:00 | -3.8 | 6.6 | 0 | 0.2
23.9 | 23.6 | 23.7
23.6 | 23.5 | 23.5
23.4 | 23.4 | 23.3
24.6 | 24.4 | 24.3
24.9 | 24.9 | 25
24.9 | 24.9 | 24.9
Location 3
26.6 | 27.1 | 27.1
26.8 | 26.8 | 26.8
26.5 | 26.4 | 26.4
26.3 | 26.3 | 26.2
25.2 | 25.2 | 25.2
25.2 | 25.2 | 25.2
25 | 25 | 25
24.7 | 24.7 | 24.7
24.3 | 24.3 | 24.3
24.3 | 24.3 | 24.3
Locarion 4
24.2 | 24.1 | 24.1
24.2 | 24.2 | 24.2
23.4 | 23.4 | 23.4
23.9 | 23.8 | 23.8
23.9 | 23.8 | 23.8
22.7 | 22.7 | 22.7
22.7 | 22.7 | 22.7
22.3 | 22.2 | 23.3
23.9 | 23.9 | 23.9
22.4 | 22.4 | 22.4
Location 5
24 | 24 | 24
23.4 | 23.5 | 23.5
23.1 | 23.6 | 23.6
22.8 | 23.1 | 23.3
21.7 | 21.7 | 21.7
21.8 | 22.1 | 22.2
23.1 | 23.3 | 23.5
22.4 | 22.4 | 22.6
22.5 | 22.4 | 22.4
22.4 | 22.3 | 22.3
Location 6
22.4 | 22.5 | 22.7
24.3 | 24 | 23.8
22.7 | 22.6 | 22.6
23 | 23.3 | 23.3
22.7 | 22.6 | 22.8
23.1 | 23.4 | 23.7
22.6 | 22.6 | 22.6
22.8 | 22.7 | 22.9
22.8 | 22.8 | 22.6
23.3 | 23.1 | 22.9
Spreadsheet: 0038235b-cdb3-4b5b-9ef2-f565a4d7f2e9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | International Instructors Course Belgium 2013
 |  |  |  | Applicationform
 |  |  |  |  | November 22nd-24th 2013
 |  |  |  |  | Ostend
 |  |  |  | Name school/club : |  |  |  | Contact person :
 |  |  |  | Association : |  |  |  | E-mail :
 |  |  |  |  |  |  |  | Phone :
Name | Surname | Degree | Degree number | Participant IIC | Banquet | Type hotel room | [NAME] date | Departure date | Parking space
 |  | 2°kup-IX°degree |  | Yes/No | Yes/No | Studio/apartment x persons |  |  | Yes/No
Spreadsheet: 120433d1315291683-compare-first-4-characters-question-example
Sheet: Sheet1

 |  |  | 4 | 3 | 2 | 1 | 1-4
Bohemian | Yes |  | Bohe | Boh | Bo | B | Bohe
Hadin | No |  | #N/A | #N/A | Ha | H | Ha
Beta | No |  | #N/A | #N/A | #N/A | B | B
 |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A
Note: array formula is used in column H and should be confirm though Ctrl+Shift+Enter
Note: index+match could also be used instead of vlookup
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -97412 | -69596
9238 | -13772 | -28000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2710134 | -2720701
58710 | -190943 | -196910
60921 | -1295068 | -1259734
78026
500084 | -66682 | -84000
500085 | -12987
500097 | -99017 | -112000
INDEX
2001-12-31 00:00:00 |  |  | 766914.32
2002-01-28 00:00:00
CBS Volume
 |  |  | 307322
Spreadsheet: daren_farmer__5273__BasketballScedule
Sheet: Sheet1

2001-06-06 00:00:00 | Bye
2001-06-13 00:00:00 | 06:00:00
2001-06-20 00:00:00 | 08:00:00
2001-06-27 00:00:00 | 09:00:00
2001-07-04 00:00:00 | off
2001-07-11 00:00:00 | 06:00:00
2001-07-18 00:00:00 | Bye
2001-07-25 00:00:00 | 06:00:00
2001-08-01 00:00:00 | 07:00:00
2001-08-08 00:00:00 | 06:00:00
Spreadsheet: harry_arora__12154__Plan_IncomeSheets_Presto
Sheet: TAC

Income Statement - ($000s)
 |  |  | 2001 Forecast |  | 2002 Plan |  | [NAME]
Originations |  | $ | 0 | $ | 0 | $
Trading |  |  | 0 |  | 0
FV-Investments |  |  | 0 |  | 0
Accrual |  |  | 0 |  | 0
Operating Expenses |  |  | 0 |  | 0
Other |  |  | 0 |  | 0
Total Margin |  | $ |  | $ |  | $
Capital Charge |  |  | 0 |  | 0
Total Margin Net of Capital Charge |  | $ |  | $ |  | $
Compensation/Taxes and Benefits |  |  |  |  |  |  |  |  |  | -1
Employee Expense
Travel/Entertainment
Consulting
Office
Controllable Infrastructure
System Development
Insurance
Analyst Associates (includes Comp, Taxes & Benefits and Allocation)
Other Expense
Outside Legal
Outside Tax
Depreciation & Amortization
Total Direct Expenses |  | $ |  | $ |  | $
Other Allocated Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive
Director
Manager
Analyst and Associates
Support Departments
Total Headcount
2002 Plan (in thousands) |  |  | Team |  | ENA Total
Direct Expense Headcount Ratio |  | $ |  | $
Productivity [NAME] |  | $ |  | $
ROCE
Spreadsheet: 45364d1244111574-job-hour-tracking-with-pivot-tables-weekly-timesheet-summary
Sheet: New Pivot

Sum of Hours | Date
JOB # | 2009-01-12 00:00:00 | 2009-01-13 00:00:00 | 2009-01-14 00:00:00 | Grand Total
870 | 1.5 | 11 |  | 12.5
896 |  | 3 |  | 3
1223-5561 | 8 |  |  | 8
1223-5565 | 9.5 |  |  | 9.5
1223-5567 | 32 | 16 | 50 | 98
2386-9045 |  | 3 |  | 3
3321-3456 |  | 3 |  | 3
3345-8676 |  | 2.5 |  | 2.5
3450-6743 | 4.5 | 5.5 | 2.5 | 12.5
3456-9876 | 5.5 | 9.5 | 5.5 | 20.5
4321-7797 |  | 7 |  | 7
4321-8877 |  | 2 |  | 2
4321-8888 |  | 6 |  | 6
4567-7543 | 6 | 10 | 5 | 21
4567-8210 | 2.5 | 2.5 | 2.5 | 7.5
4567-8211 |  | 3 | 1.5 | 4.5
4567-9089 |  | 4 | 4 | 8
4568-8467 | 3 | 3 | 3 | 9
4568-9832 | 2 | 3.5 | 3.5 | 9
5386-8649 | 3 |  |  | 3
5553-6781 | 3 |  |  | 3
5553-6785 | 4 |  |  | 4
5553-6788 |  | 1.5 | 1.5 | 3
5553-6789 | 18 | 6.5 | 6.5 | 31
5553-6790 | 8 |  |  | 8
5678-2345 | 1.5 | 4 | 1.5 | 7
5678-3832 | 7 | 11 | 7 | 25
6789-9432 |  | 6.5 |  | 6.5
6789-9433 | 1.5 | 1.5 | 10.5 | 13.5
7445-1234 |  | 3 | 3 | 6
7445-1235 |  | 2.5 | 5 | 7.5
7445-1236 |  | 1.5 |  | 1.5
7445-1237 |  | 1 |  | 1
7445-1435 | 5 |  |  | 5
7464-9474 |  | 2.5 |  | 2.5
870 |  | 2 | 2 | 4
design | 3 |  | 6.5 | 9.5
load trucks | 7.5 | 7.5 | 7.5 | 22.5
sales | 6.5 | 5 | 3 | 14.5
shipping office | 10.5 | 9.5 | 12 | 32
shop | 17 | 18 | 16.5 | 51.5
shop/tool manitenance | 3 | 2 | 3 | 8
Tarmac schematic |  |  | 2 | 2
yard | 9 | 2.5 | 8 | 19.5
Grand Total | 182 | 182.5 | 173 | 537.5
Spreadsheet: b7da9c6f-c648-4bd5-bffa-01030c71a142
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Public Works
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 3090 |  | 897228 |  | B |  | 89009996 |  | -151764 |  | Dec
 |  | 3090 |  | 897228 |  | B |  | 89004230 |  | 84266 |  | Inc
 |  | 3090 |  | 897228 |  | B |  | 89004224 |  | 67498 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 3090 |  | 897228 |  | 611060 |  | 89009996 |  | -151764 |  | Dec
 |  | 3090 |  | 897228 |  | 611060 |  | 89004230 |  | 84266 |  | Inc
 |  | 3090 |  | 897228 |  | 611060 |  | 89004224 |  | 67498 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 0
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 0
 |  | The expense accounts side of ordinance
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: c4aa1d8a-9b9a-4ca5-9ef7-b65cc91847b8
Sheet: Advance

 |  |  |  | Advance Pierre Fruit Items
CUPPED ITEMS
 |  |  |  |  |  | * = yield change
Item # | Description | CN Equivalant (oz.) | Case Count/ Serving Size |  |  | [NAME] (lbs.) | Servings Per Menu | Num. of Cases / Menu | Num of Menus / SY | Num. of Cases / SY | Lbs. DF Drawdown per case |  | Total DF LBS
10104 | [NAME] | 1/2 cup fruit | 96 | / | 4 | 24 |  |  |  |  | 19.92
10204 | [NAME] | 1/2 cup fruit | 96 | / | 4 | 24 |  |  |  |  | 19.92
11030 | Applesauce | 3/8 cup fruit | 120 | / | 3 | 22.5 |  |  |  |  | 19.11
11040 | Applesauce | 1/2 cup fruit | 96 | / | 4 | 24 |  |  |  |  | 20.39
 |  |  |  |  |  |  |  |  |  | uses 100208
80130 | Peach Fruit Cup | 3/8 cup fruit | 120 | / | 3 | 22.5 |  |  |  |  | 20.76
80140 | Peach Fruit Cup | 1/2 cup fruit | 96 | / | 4 | 24 |  |  |  |  | 22.14
 |  |  |  |  |  |  |  |  | uses 100219/100220
80230 | Pear Fruit Cup | 3/8 cup fruit | 120 | / | 3 | 22.5 |  |  |  |  | 21.31
80240 | Pear Fruit Cup | 1/2 cup fruit | 96 | / | 4 | 24 |  |  |  |  | 22.73
 |  |  |  |  |  |  |  |  | uses 100224/100225