tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79541d1279786103-sumproduct-sumproduct_help
Sheet: Sheet1

 | Report Start | Report End
((D9:D27="C123")+(D9:D27="A554")>0) | 2010-01-01 00:00:00 | 2010-06-30 00:00:00
 | Total | Small
Volume of Jobs Received in Month
 |  |  | This part | of formula here |  | need to be selectable by user to allow other combinations
id | Input Date | Job Type | Job Code
300002 | 2010-01-11 00:00:00 | Medium | C113
300004 | 2010-01-11 00:00:00 | Medium | C113
300005 | 2010-01-11 00:00:00 | Medium | C113
300006 | 2010-01-18 00:00:00 | Medium | B567
300007 | 2010-01-11 00:00:00 | Medium | C113
300013 | 2010-01-11 00:00:00 | Small | Other
300014 | 2010-01-11 00:00:00 | Medium | C113
300015 | 2010-01-11 00:00:00 | Small | C113
300016 | 2010-01-11 00:00:00 | Small | A554
300017 | 2010-01-11 00:00:00 | Medium | C113
300018 | 2010-01-16 00:00:00 | Small | F123
300019 | 2010-01-11 00:00:00 | Small | Other
300021 | 2010-01-11 00:00:00 | Medium | C113
300022 | 2010-01-11 00:00:00 | Medium | C113
300023 | 2010-01-11 00:00:00 | Small | A554
300024 | 2010-01-11 00:00:00 | Small | B138
300025 | 2010-01-11 00:00:00 | Medium | C113
300027 | 2010-01-11 00:00:00 | Medium | C113
300028 | 2010-01-11 00:00:00 | Small | B138
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 10a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated net notional amount outstanding, December 28 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 844261d1695995351-arranging-table-using-pivot-function-testing
Sheet: Output required

Employee Name | Values | Amount
Employee A | Salary amount | 100000
 | Project-A | 75000
 | Project-D | 25000
 | [NAME] | 0
Employee B | Salary amount | 200000
 | Project-B | 100000
 | Project-C | 50000
 | Project-E | 50000
 | [NAME] | 0
Employee C | Salary amount | 300000
 | Project-D | 50000
 | Project-F | 100000
 | Project-G | 150000
 | [NAME] | 0
Employee D | Salary amount | 150000
 | Project-A | 50000
 | Project-C | 75000
 | [NAME] | 25000
Employee E | Salary amount | 175000
 | Project-B | 75000
 | Project-E | 25000
 | Project-F | 30000
 | Project-G | 20000
 | [NAME] | 25000
Spreadsheet: 113378d1309295616-auto-populate-a-cell-when-3-options-are-selected-all-skus
Sheet: Pillowcases - 1598

Product | P-Code | Size | S-Code | Color | C-Code |  | SKU
Pillowcases | 1598 | Travel | 12 | Ivory | 20 |  |  | 859110002424
Pillowcases | 1598 | Travel | 12 | White | 21 |  |  | 859110002431
Pillowcases | 1598 | Travel | 12 | Sage Green | 22 |  |  | 859110002448
Pillowcases | 1598 | Travel | 12 | Blue | 30
Pillowcases | 1598 | Travel | 12 | [NAME] | 31 |  |  | 859110002455
Pillowcases | 1598 | Travel | 12 | Plum | 32 |  |  | 859110002462
Pillowcases | 1598 | Twin | 13 | Ivory | 20
Pillowcases | 1598 | Twin | 13 | White | 21
Pillowcases | 1598 | Twin | 13 | Sage Green | 22
Pillowcases | 1598 | Twin | 13 | Blue | 30
Pillowcases | 1598 | Twin | 13 | [NAME] | 31
Pillowcases | 1598 | Twin | 13 | Plum | 32
Pillowcases | 1598 | Full | 15 | Ivory | 20 |  |  | 859110002479
Pillowcases | 1598 | Full | 15 | White | 21 |  |  | 859110002486
Pillowcases | 1598 | Full | 15 | Sage Green | 22 |  |  | 859110002493
Pillowcases | 1598 | Full | 15 | Blue | 30
Pillowcases | 1598 | Full | 15 | [NAME] | 31 |  |  | 859110002509
Pillowcases | 1598 | Full | 15 | Plum | 32 |  |  | 859110002516
Pillowcases | 1598 | Queen | 16 | Ivory | 20 |  |  | 859110002523
Pillowcases | 1598 | Queen | 16 | White | 21 |  |  | 859110002530
Pillowcases | 1598 | Queen | 16 | Sage Green | 22 |  |  | 859110002547
Pillowcases | 1598 | Queen | 16 | Blue | 30
Pillowcases | 1598 | Queen | 16 | [NAME] | 31 |  |  | 859110002554
Pillowcases | 1598 | Queen | 16 | Plum | 32 |  |  | 859110002820
Pillowcases | 1598 | King | 17 | Ivory | 20 |  |  | 859110002837
Pillowcases | 1598 | King | 17 | White | 21 |  |  | 859110002844
Pillowcases | 1598 | King | 17 | Sage Green | 22 |  |  | 859110002851
Pillowcases | 1598 | King | 17 | Blue | 30
Pillowcases | 1598 | King | 17 | [NAME] | 31 |  |  | 859110002868
Pillowcases | 1598 | King | 17 | Plum | 32 |  |  | 859110002875
Spreadsheet: rick_buy__32711__0806 summary of issues
Sheet: summary 0723

SUMMARY BY WEEK FOR  06/11-06/15
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture
B |  | Deal Valuation
C |  | Breakdown in Officializing Process- Human
D1 |  | Breakdown in Officializing Process- IT (UK)
D2 |  | Breakdown in Officializing Process- IT (US)
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change
G |  | Miscellaneous
H |  | Not identified
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM
EGM |  |  |  |  |  |  |  |  |  | Book was not officialized and UK Coal positions had to be corrected.
EEL |  |  |  |  |  |  |  |  |  | Eastern Spreadsheets were rolled and UK Power officialized late.
EA-CAN |  |  |  |  |  |  |  |  |  | Canadian $ book not officialized for IR/FX.
EA - GAS |  |  |  |  |  |  |  |  |  | Book was not officialized.
EA - POWER
EES
EBS
Other |  |  |  |  |  |  |  |  |  | Ennovate book not captured by RisktRAC due to mismatch
TOTAL ISSUES
Spreadsheet: 679512d1590468615-creating-a-dynamic-list-example-list-2-w-adj
Sheet: Sheet5

Supplier | Count |  |  |  |  | Count | Supplier
[NAME] | 7
Fred | 2
[NAME] | 4
[NAME] | 1
[NAME] | 3
Spreadsheet: 884982d1734377331-using-conditional-formatting-to-highlight-cells-example
Sheet: eg

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ITEMS THAT DO NOT DIVIDE EXACTLY BY THREE
-50
-4.3 |  |  |  |  |  |  |  |  |  | -18.1 |  | -18.1 |  | -18.1
-301.5
-4.3 |  |  |  |  |  |  |  |  |  | -101.8 |  | -102 |  | -102
-4.3 |  |  |  |  |  |  |  |  |  | -1.77 |  | -1.23 |  | -1.3
-24.69 |  |  |  |  |  |  | -24.69 |  |  | -8.23 |  | -8.23 |  | -8.23
-150 |  |  |  |  |  |  | -150 |  |  | -50 |  | -50 |  | -50
 | 8.88 |  |  |  |  |  |  |  |  | 2.96 |  | 2.96 |  | 2.96
-4075 |  |  |  |  |  |  |  |  |  | -1358.33 |  | -1358.33 |  | -1358.34
86623.93 |  | 0.1
 |  |  |  | 274.14
 |  |  |  | 434.2
 |  |  |  | 274.14
 |  |  |  |  |  | -2955.68
3
Spreadsheet: 142817d1330017921-how-sum-a-number-based-on-text-before-the-number-leave
Sheet: Annual Leave 2012 Calculations

 | Overtime (Hours)
 | Overtime Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overtime Acquired | 0
 | Overtime Taken | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Overtime Left | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 1f6ca65b-3ec9-4f4c-92c5-604f4a4cac3b
Sheet: Sheet1

Job Title | Pay Range | Step | 1/1/2004 | 7/1/2004 (4%) | 7/1/2005 (2.5%) | 1/1/2007 (2.5%)
Firefighter | FR010 | 1 | 4262 | 4432.48 | 4543.291999999999 | 4656.874299999999
 |  | 2 | 4475.1 | 4654.103999999999 | 4770.4566 | 4889.718014999999
 |  | 3 | 4698.855 | 4886.8092 | 5008.979429999999 | 5134.203915749999
 |  | 4 | 4933.797750000001 | 5131.14966 | 5259.428401499999 | 5390.9141115375
 |  | 5 | 5180.487637500001 | 5387.707143000001 | 5522.399821575 | 5660.459817114375
Firefighter Paramedic | FR020 | 1 | 4967 | 5165.68 | 5294.822 | 5427.19255
 |  | 2 | 5215 | 5423.964000000001 | 5559.5631 | 5698.5521775
 |  | 3 | 5476 | 5695.162200000002 | 5837.541255000001 | 5983.479786375
 |  | 4 | 5749 | 5979.920310000002 | 6129.418317750002 | 6282.653775693751
 |  | 5 | 6037 | 6278.916325500003 | 6435.889233637502 | 6596.786464478439
Fire Engineer | FR020 | 1 | 4967 | 5165.68 | 5294.822 | 5427.19255
 |  | 2 | 5215 | 5423.964000000001 | 5559.5631 | 5698.5521775
 |  | 3 | 5476 | 5695.162200000002 | 5837.541255000001 | 5983.479786375
 |  | 4 | 5749 | 5979.920310000002 | 6129.418317750002 | 6282.653775693751
 |  | 5 | 6037 | 6278.916325500003 | 6435.889233637502 | 6596.786464478439
Fire Captain | FR030 | 1 | 5808 | 6040.32 | 6191.328 | 6346.111199999999
 |  | 2 | 6099 | 6342.336 | 6500.8944 | 6663.41676
 |  | 3 | 6403 | 6659.452800000001 | 6825.93912 | 6996.587598
 |  | 4 | 6724 | 6992.425440000001 | 7167.236076 | 7346.4169779
 |  | 5 | 7060 | 7342.046712000001 | 7525.597879800001 | 7713.737826795001
Z: Fire Negotiations2004/MOU Drafts - Appendix A-2 Fire Salary Schedule - 2004-2007
Spreadsheet: 696268d1600736923-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 1

Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | [NAME] | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product A | 2000 | 1 | -3 |  |  | 30000
2021-02-01 00:00:00 | Product A |  | 2 | -3 |  |  | 40000
2021-03-01 00:00:00 | Product A |  | 3 | -3 |  |  | 50000
2021-04-01 00:00:00 | Product A |  | 4 | -3 |  |  | 10000
Spreadsheet: 747597d1631610536-index-match-in-that-same-tabe-copy-new-data
Sheet: export

 | these always remain intact |  |  | Paste data from other sheet in cel E2
 | Month | Column4 | Column3 | EXTRA COLUMN | Date Requested | Priority
The formula in column B should not change after pasting the new export |  |  | 85 | 39 | 2020-02-24 10:16:04 | Low |  | =[NAME]")
 |  |  | 72 | 40 | 2021-08-23 14:09:48 | Low
 |  |  | 14 | 37 | 2021-05-28 10:57:45.204000 | Low |  | INDEX(Dump;0;MATCH("Month finish";Dump[#Headers];0));M$1
 |  |  | 70 | 14 | 2021-05-28 10:52:57.139000 | Low
 |  |  | 63 | 23 | 2020-12-23 15:53:20 | Medium |  | INDEX(Dump;0;MATCH("Month finish";Dump[#Headers];0));M$1
 |  |  | 2 | 13 | 2020-03-24 11:58:36 | Low
 |  |  | 39 | 16 | 2020-03-24 10:03:54 | Low |  | =[NAME]")
 |  |  | 91 | 17 | 2021-03-03 15:20:35.801000 | None
 |  |  | 66 | 12 | 2021-03-25 08:27:17.054000 | Low
 |  |  | 50 | 7 | 2021-08-18 09:13:57 | Low
 |  |  | 63 | 39 | 2021-08-18 09:13:58 | Low
 |  |  | 66 | 12 | 2021-02-19 11:16:29 | Low
 |  |  | 94 | 32 | 2021-08-18 09:13:58 | Medium
 |  |  | 27 | 18 | 2021-07-03 21:58:17.311000 | None
 |  |  | 3 | 17 | 2021-08-18 09:13:57 | Low
 |  |  | 18 | 40 | 2021-08-18 09:13:04 | Low
 |  |  | 53 | 30 | 2021-08-18 09:13:55 | Low
 |  |  | 67 | 9 | 2020-08-17 10:40:02.859000 | Low
 |  |  | 36 | 37 | 2020-08-17 10:07:07.309000 | Low
 |  |  | 35 | 37 | 2021-08-18 09:13:54 | Low
 |  |  | 41 | 17 | 2021-08-18 09:13:54 | Low
 |  |  | 45 | 21 | 2021-08-18 09:13:53 | Medium
 |  |  | 60 | 14 | 2021-08-18 09:13:52 | Low
 |  |  | 4 | 36 | 2021-08-18 09:13:10 | Low
 |  |  | 31 | 29 | 2021-08-18 09:13:50 | Low
 |  |  | 69 | 14 | 2021-08-18 09:13:50 | Low
 |  |  | 21 | 34 | 2021-08-22 06:11:55.585000 | Medium
 |  |  | 72 | 24 | 2021-08-18 09:13:50 | Low
 |  |  | 53 | 25 | 2021-08-18 09:13:04 | Low
 |  |  | 28 | 39 | 2021-08-18 09:13:06 | Medium
 |  |  | 57 | 31 | 2021-08-18 09:13:06 | Low
 |  |  | 10 | 40 | 2021-08-18 09:13:06 | Low
 |  |  | 18 | 22 | 2021-08-18 09:13:06 | Low
Spreadsheet: c7cacd6b-4049-4c84-a383-6eda7bffc223
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
FRANC | Test | FRANC | Francisella Tularensis Antibody | Francisella tularensis [NAME] | Direct Aggulation (DA) |  |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL of serum, ambient.  NOTE:  Serum gel tube is acceptable, but must pour off into a plastic vial. | 0.5 mL; [NAME] 0.075 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reference Range:  <1:20    Interpretive Criteria: <1:20 Negative 1:20 - 1:80 Equivocal > or =1:160 Positive    In the presence of compatible symptoms, a Francisella tularensis antibody titer of 1:160 or greater in an acute specimen supports a presumptive diagnosis of tularemia. However, a titer > or =1:160 may also reflect past infection. An equivocal titer may be due to crossreactive antibodies (Brucella, Yersinia, or Proteus OX19), past infection, or very recent infection. A four-fold rise in titer between acute and convalescent sera is required for definitive serologic diagnosis of tularemia.   Test Performed By:  Focus Diagnostics, Inc.                                         5785 Corporate Avenue                                         Cypress, CA  90630-4750 | Monday through Friday | 1-4 days | 2-6 days | 1 | 86000 |  |  |  |  | Focus Diagnositics, Inc.
FRANC | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
FRANC | Result | Z0713 | Francisella tularensis [NAME] | Francisella tularensis [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 708353d1607755647-clustered-if-else-combination-sample
Sheet: Sheet1

A | B | C |  |  |  | 0 | 21 | 26 | 31
19 | 19 | 1 |  |  | 0 | 1 | 2 | 3 | 3
20 | 20 | 1 |  |  | 21 | 2 | 3 | 4 | 5
21 | 19 | 2 |  |  | 26 | 3 | 4 | 5 | 6
22 | 18 | 2 |  |  | 31 | 3 | 5 | 6 | 7
23 | 17 | 2
24 | 16 | 2
25 | 15 | 2
19 | 21 | 2
18 | 22 | 2
17 | 23 | 2
16 | 24 | 2
15 | 25 | 2
31 | 19 | 3
32 | 18 | 3
33 | 17 | 3
34 | 16 | 3
35 | 15 | 3
19 | 31 | 3
18 | 32 | 3
17 | 33 | 3
16 | 34 | 3
15 | 35 | 3
26 | 21 | 4
27 | 22 | 4
28 | 23 | 4
29 | 24 | 4
30 | 25 | 4
21 | 26 | 4
22 | 27 | 4
23 | 28 | 4
24 | 29 | 4
25 | 30 | 4
26 | 26 | 5
27 | 27 | 5
28 | 28 | 5
29 | 29 | 5
30 | 30 | 5
31 | 26 | 6
32 | 27 | 6
33 | 28 | 6
34 | 29 | 6
35 | 30 | 6
26 | 31 | 6
27 | 32 | 6
28 | 33 | 6
29 | 34 | 6
30 | 35 | 6
31 | 31 | 7
32 | 32 | 7
33 | 33 | 7
34 | 34 | 7
35 | 35 | 7
Spreadsheet: 768311d1644923989-how-to-automatically-duplicate-dates-with-different-timing-event-lunch
Sheet: Sheet1

Date and time of event (Start) | Date and time of event (End) | [NAME] (Start) | [NAME] (End)
2022-01-03 08:30:00 | 2022-01-03 18:00:00 | 2022-01-03 11:30:00 | 2022-01-03 12:30:00
2022-01-04 08:30:00 | 2022-01-04 18:00:00 | 2022-01-04 11:30:00 | 2022-01-04 12:30:00
2022-01-05 08:30:00 | 2022-01-05 18:00:00 | 2022-01-05 11:29:59.995000 | 2022-01-05 12:30:00
2022-01-06 08:30:00 | 2022-01-06 18:00:00
2022-01-07 08:30:00 | 2022-01-07 18:00:00
Spreadsheet: a9c9e1ce-96c1-47a1-8838-d49f2e56f07a
Sheet: Sheet1

Population Estimates by Age (5-Year Age Group) and Sex | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | June 1, 2012  (Provisional estimates) |  |  |  | Jan. 1, 2012  (Final estimates)
Age groups |  |  | Total  population |  |  |  | Total  population |  |  | Japanese  population
 |  |  | Both sexes | Male | Female |  | Both sexes | Male | Female | Both sexes | Male | Female
 |  |  | Population (Ten thousand persons) |  |  |  |  | Population   (Thousand persons)
Total |  |  | 12753 | 6203 | 6550 |  | 127662 | 62106 | 65556 | 126195 | 61453 | 64742
0 - 4 | years old |  | 529 | 271 | 258 |  | 5293 | 2710 | 2582 | 5248 | 2687 | 2561
5 - 9 |  |  | 543 | 278 | 265 |  | 5471 | 2801 | 2670 | 5431 | 2781 | 2651
10 - 14 |  |  | 589 | 302 | 287 |  | 5903 | 3023 | 2880 | 5860 | 3001 | 2859
15 - 19 |  |  | 606 | 311 | 295 |  | 6070 | 3114 | 2956 | 6008 | 3084 | 2924
20 - 24 |  |  | 631 | 323 | 308 |  | 6341 | 3241 | 3101 | 6158 | 3154 | 3004
25 - 29 |  |  | 712 | 363 | 350 |  | 7168 | 3647 | 3522 | 6980 | 3558 | 3422
30 - 34 |  |  | 791 | 401 | 390 |  | 8015 | 4065 | 3951 | 7844 | 3990 | 3853
35 - 39 |  |  | 951 | 482 | 469 |  | 9641 | 4888 | 4753 | 9495 | 4828 | 4668
40 - 44 |  |  | 939 | 475 | 465 |  | 9427 | 4758 | 4668 | 9284 | 4703 | 4581
45 - 49 |  |  | 809 | 407 | 402 |  | 7945 | 3997 | 3948 | 7830 | 3951 | 3879
50 - 54 |  |  | 765 | 382 | 382 |  | 7632 | 3815 | 3817 | 7547 | 3779 | 3768
55 - 59 |  |  | 806 | 400 | 406 |  | 8238 | 4088 | 4149 | 8168 | 4057 | 4111
60 - 64 |  |  | 1044 | 512 | 532 |  | 10596 | 5198 | 5398 | 10538 | 5170 | 5368
65 - 69 |  |  | 800 | 383 | 417 |  | 7871 | 3766 | 4105 | 7830 | 3747 | 4083
70 - 74 |  |  | 734 | 341 | 392 |  | 7268 | 3374 | 3894 | 7236 | 3360 | 3876
75 - 79 |  |  | 622 | 272 | 350 |  | 6160 | 2688 | 3472 | 6138 | 2679 | 3459
80 - 84 |  |  | 458 | 180 | 277 |  | 4502 | 1766 | 2736 | 4489 | 1761 | 2728
85 | and over |  | 426 | 122 | 304 |  | 4121 | 1167 | 2954 | 4110 | 1163 | 2946
Regrouped
0 - 14 | years old |  | 1661 | 850 | 810 |  | 16667 | 8535 | 8133 | 16539 | 8469 | 8070
15 - 64 |  |  | 8053 | 4054 | 3999 |  | 81073 | 40810 | 40263 | 79852 | 40273 | 39579
65 | and over |  | 3039 | 1298 | 1741 |  | 29922 | 12762 | 17160 | 29803 | 12711 | 17093
75 | and over |  | 1505 | 574 | 932 |  | 14783 | 5621 | 9162 | 14737 | 5604 | 9133
 |  |  |  |  | Percentage distribution  (%)
0 - 14 | years old |  | 13 | 13.7 | 12.4 |  | 13.1 | 13.7 | 12.4 | 13.1 | 13.8 | 12.5
15 - 64 |  |  | 63.1 | 65.4 | 61.1 |  | 63.5 | 65.7 | 61.4 | 63.3 | 65.5 | 61.1
65 | and over |  | 23.8 | 20.9 | 26.6 |  | 23.4 | 20.5 | 26.2 | 23.6 | 20.7 | 26.4
75 | and over |  | 11.8 | 9.3 | 14.2 |  | 11.6 | 9.1 | 14 | 11.7 | 9.1 | 14.1
Notes) | * | Figures may not add up to the totals because of rounding.
 | * | Based on the 2010 Population Census.
 | * | Final estimates for this month's population will be computed 5 months later using updated sources.
Spreadsheet: 538250d1505484623-need-a-formula-or-code-to-replace-dates-inventory-accuracy-template
Sheet: Shops

Cycle Count  - Period Ending August 31, 2017 - FY 18 - US Mechanical, Hose & Fluid Power Shops
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | US Shops TOTAL
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
Applied Central | C41 | 4010 | LONDON, ON | CA | 444949.02 | 558699.9 | 3784.43 | 0.00371719058360108 | 6694 | 1118 | 0.167015237526143 | 320302.241 | 319524.934 | 0.00242679226212497 | 0.024760988169296 | 7931 | Exempt | FP | 2017-08-01 00:00:00
 |  |  | CAN Shops TOTAL
Cycle Count  - Period Ending July 31, 2017 - FY 18 - Rubber Shops**
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | Rubber Shop TOTAL
**2310, 2359 & 2070 perform semi-annual full physical inventory counts.
Spreadsheet: scott_neal__38600__MgmtSum-Q2_2001_0518
Sheet: WeeklyExpChange

ENRON NORTH AMERICA
1st QUARTER 2001 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
ERCOT (Smith/Sukaly) |  | 0
Southeast (Herndon/Pagan) |  | 0
Midwest (Sturm/Baughman) |  | 0
Northeast (Davis/Ader) |  | 0
Management Book (Presto) |  | 0
New Albany (Presto) |  | 0
Development (Jacoby) |  | 0
Structuring (Aucoin) |  | 0
Fundamentals (Will) |  | 0
Total East Power
Originations (Calger) |  | 0
QF (Calger) |  | 0
Development ([NAME]) |  | 0
Trading (Belden) |  | 0
Middle Market/Services (Foster/Wolfe) |  | 0
Fundamentals ([NAME]) |  | 0
Total West Power
West (Allen/Tycholiz) |  | 0
Midwest (Shively/Luce) |  | 0
East (Neal/Vickers) |  | 0
Texas (Martin) |  | 0
Financial (Arnold) |  | 0
Derivatives (Lagrasta) |  | 0
NG Structuring (McMicheal) |  | 0
NG Fundamentals (Gaskill) |  | 0
Management
Total Natural Gas
Natural Gas (McKay/LeDain) |  | 0
Finance (Kitagawa) |  | 0
Alberta Power (Zufferli/Davies) |  | 0
Ontario Power (Devries) |  | 0
Retail (Pope) |  | 0
Executive (Milnthorp) |  | 0
Total Canada
Upstream Executive (Mrha) |  | 0
Compression Services ([NAME]) |  | 0
Offshore (Byargeon) |  | 0
Storage (Bieniawski) |  | 0
[NAME] (Grass) |  | 0
[NAME] (Mrha) |  | 0
Bridgeline (Mrha) |  | 0
HPL (Redmond) |  | 0
LT Fundamentals/Transport ([NAME]) |  | 0
Mexico (Yzaguirre) |  | 0
Generation Investments (Duran) |  | 0
Principal Investing ([NAME]) |  | 0
Energy Capital Svcs (Thompson/Josey) |  | 0
Corporate Development (Detmering) |  | 0
Restructuring (Redmond) |  | 0
[NAME] |  | 0
Cross Commodity (Lavorato) |  | 0
Office of the Chairman (Delainey/Lavorato) |  | 0
Overview |  | 0
Total Commercial
Business Analysis & Reptg (Colwell) |  | 0
Transaction Support (Colwell) |  | 0
Canada Support (Milnthorp) |  | 0
Energy Operations (Beck) |  | 0
Human Resources (Oxley) |  | 0
Legal (Haedicke) |  | 0
Public Relations (Thoede) |  | 0
Tax ([NAME]) |  | 0
Research (Kaminski) |  | 0
Competitive Analysis (Tholan) |  | 0
Treasury (Deffner) |  | 0
Technical Services (Redmond)) |  | 0
Information Technology (Bibi) |  | 0
Corp Charges and Non-Allocable |  | 0
Total Group
Other Interest Related |  | 0
Capital Charge Offset/Facility Costs |  | 0
ENA EBIT
Interest Expense/(Income) |  | 0
TOTAL
Spreadsheet: 23c6ca8d-c7a8-4c98-93c7-d6ab9371a31c
Sheet: VLookup 2

Name | Student ID |  | Student ID | Grade |  | Name | ID Lookup | [NAME]
[NAME], [NAME] | 398450917 |  | 129875649 | [NAME] |  | [NAME], [NAME]
Adams, [NAME] | 238746782 |  | 238746782 | B- |  | Adams, [NAME]
[NAME], [NAME] | 897834578 |  | 281764589 | A- |  | [NAME], [NAME]
[NAME], [NAME] | 129875649 |  | 298764367 | C+ |  | [NAME], [NAME]
Jones, [NAME] | 298764367 |  | 348908320 | C- |  | Jones, [NAME]
Matherson, [NAME] | 382900808 |  | 382900808 | A |  | Matherson, [NAME]
[NAME], [NAME] | 348908320 |  | 398450917 | D |  | [NAME], [NAME]
Smith, [NAME] | 281764589 |  | 897834578 | [NAME] |  | Smith, [NAME]
Spreadsheet: 817818d1676460486-filter-from-column-b-and-return-unique-values-eh_filter-columns-etaf
Sheet: I WANT THIS

I want this
Chilled- Ml Cntr Chicken | [NAME] Ckn- Bites -Brd/Btd | Chilled | Pieces - Chunks
Chilled- Ml Cntr Chicken | [NAME] Ckn- Bites -Unctd | Chilled | Pieces - Chunks
Chilled- Ml Cntr Chicken | [NAME] Ckn- Finger -Brd/Btd | Chilled | Not Applicable
Chilled- Ml Cntr Chicken | [NAME] Ckn- Pops | Chilled | Pieces - Chunks
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Not Applicable
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Pieces - Goujons
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Not Applicable
Chilled- Ml Cntr Chicken | [NAME] Ckn- Shapes | Chilled | Pieces - Strips