tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 711712d1609858775-pulling-one-of-multiple-headers-in-single-column-based-on-information-below-schedule-template-wip
Sheet: Master Schedule

 | 2021-01-17 00:00:00
 | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa
Department 1
Name 1
Name 2 |  |  |  |  |  |  |  |  | a
Name 3 |  |  |  |  |  |  |  |  | P
Name 4 |  |  |  |  |  |  |  |  | A
Name 5 |  |  |  |  |  |  |  |  | P
Name 6 |  |  |  |  |  |  |  |  | A
Name 7
Department 2
Name 8
Name 9
Name 10 |  |  |  |  |  |  |  |  | a
Name 11 |  |  |  |  |  |  |  |  | a
Name 12 |  |  |  |  |  |  |  |  | a
Name 13 |  |  |  |  |  |  |  |  | a
-5North-
Name 14
Name 15
Name 16
Name 17 |  |  |  |  |  |  |  |  | A
Name 18 |  |  |  |  |  |  |  |  | P
Name 19 |  |  |  |  |  |  |  |  | P
-ICU-
Name 20
Name 21
Name 22
Name 23
Name 24 |  |  |  |  |  |  |  |  | A
Name 25 |  |  |  |  |  |  |  |  | P
Name 26
 | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa
-PSU-
Name 27
Name 28
Name 29
Name 30 |  |  |  |  |  |  |  |  | P
Name 31 |  |  |  |  |  |  |  |  | P
Name 32 |  |  |  |  |  |  |  |  | A
Name 33 |  |  |  |  |  |  |  |  | A
Name 34
-FCMC-
Name 35 |  |  |  |  |  |  |  |  | A
Name 36 |  |  |  |  |  |  |  |  | A
Name 37 |  |  |  |  |  |  |  |  | P
Name 38 |  |  |  |  |  |  |  |  | P
Name 39 |  |  |  |  |  |  |  |  | P
Name 40
-NICU-
Name 41
Name 42 |  |  |  |  |  |  |  |  | P
Name 43 |  |  |  |  |  |  |  |  | A
Name 44 |  |  |  |  |  |  |  |  | A
Name 45 |  |  |  |  |  |  |  |  | P
Name 46
-ED-
Name 47 |  |  |  |  |  |  |  |  | A
Name 48
Name 49 |  |  |  |  |  |  |  |  | P
Name 50 |  |  |  |  |  |  |  |  | A
Name 51 |  |  |  |  |  |  |  |  | P
Name 52
Name 53 |  |  |  |  |  |  |  |  | A
-CATH LAB-
Name 54
Name 55
Name 56
AM
PM
Spreadsheet: 868373d1715102268-unique-or-maybe-not-lookup-and-sum-book1-2-
Sheet: Sheet3 (2)

Part# | Description | 2023-01 Net-Sales | 2023-02 Net-Sales | 2023-03 Net-Sales | 2023-04 Net-Sales | 2023-05 Net-Sales | 2023-06 Net-Sales | 2023-07 Net-Sales | 2023-08 Net-Sales | 2023-09 Net-Sales | 2023-10 Net-Sales | 2023-11 Net-Sales | 2023-12 Net-Sales
unit1 |  | 0 | 0 | 0 | 0 | 116.19 | 0 | 0 | -47.62 | 0 | 0 | 0 | 0
unit1a |  | 0 | 0 | 0 | 0 | 0 | 752.71 | 0 | -24.99 | 0 | -16.65 | 0 | 0
unit2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 194.11 | 0
unit2b |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 195.87 | 0
unit11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 201.07 | 0
unit1pn |  | 44.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8.97 | 0 | 0
unit110 |  |  |  |  | 82.52 |  |  |  |  | 3.45
unit220 |  |  | 2.6 |  |  | 1.25
unit11x |  | 23.78 |  |  |  |  |  |  |  |  | 1.01
unit1
unit11
unit2
unit220
Spreadsheet: 839477d1692017361-staff-leave-date-match-entitlement-period-staff-leave-calculation2
Sheet: 工作表1

Part 1 : Staff basic information and leave entitlement table |  |  |  |  |  |  |  | Part 2 : staff leave taking history
 |  |  |  |  |  |  | Question :　how to use formula to sum leave days leave days according to the leave start and end date to column G
Name | Employment Date | Paid Leave entitlement Period_start | [NAME] entitlement Period_End | seniority | Paid Leave Entitlement | Total leave taken |  | Leave taken from | Leave date_start | Leave date_end | Leave day(s)
[NAME] | 2020-04-05 00:00:00 | 2020-04-05 00:00:00 | 2021-04-03 00:00:00 | 1 | 10 |  |  | [NAME] | 2022-05-01 00:00:00 | 2022-05-01 00:00:00 | 1
 |  | 2021-04-05 00:00:00 | 2022-04-03 00:00:00 | 2 | 11 |  |  | [NAME] | 2022-08-06 00:00:00 | 2022-08-07 00:00:00 | 2
 |  | 2022-04-05 00:00:00 | 2023-04-03 00:00:00 | 3 | 12 | 3 |  | [NAME] | 2023-04-09 00:00:00 | 2023-04-11 00:00:00 | 3
 |  | 2023-04-05 00:00:00 | 2024-04-03 00:00:00 | 4 | 12 | 3 |  | Maria | 2021-08-08 00:00:00 | 2021-08-08 00:00:00 | 0.5
Maria | 2021-06-02 00:00:00 | 2021-06-02 00:00:00 | 2022-06-01 00:00:00 | 1 | 10 | 0.5 |  | Maria | 2022-06-02 00:00:00 | 2022-06-02 00:00:00 | 0.5
 |  | 2022-06-02 00:00:00 | 2023-06-01 00:00:00 | 2 | 11 | 1.5 |  | Maria | 2023-05-05 00:00:00 | 2023-05-05 00:00:00 | 1
 |  |  |  |  |  |  |  | [NAME] | 2023-09-09 00:00:00 | 2023-09-09 00:00:00 | 0.5
[NAME] | 2023-07-08 00:00:00 | 2023-07-08 00:00:00 | 2024-07-07 00:00:00 | 1 | 10 | 0.5 |  | [NAME] | 2024-07-10 00:00:00 | 2024-07-10 00:00:00 | 1
 |  | 2024-07-08 00:00:00 | 2025-07-07 00:00:00 | 2 | 11 | 1
Spreadsheet: 693737d1599124082-use-vlookup-to-search-for-multiple-variation-of-a-name-lookup
Sheet: Sheet1

Lookup list | Vlookup |  |  | Alternative Lookup names X | Alternative Lookup names C | Alternative Lookup names A | Alternative Lookup names B
16-X |  |  |  | 16X | C1 | A1 | 1B
A1 |  |  |  | X16 | 1C | 1A | B1
B1 |  |  |  | X-16
C1 |  |  |  | 16-X
List
A1 | 1
B1 | 10
16X | 15
1C | 2
 | 1
Spreadsheet: 764398d1642708816-formula-to-adjust-a-rate-based-on-lookup-of-dept-payroll-sample
Sheet: Tab 1

NO. | EMPLOYEE | Code | Job
100 | Smith, [NAME] | C61C | GW
101 | Smith, [NAME] | C61C | GW
102 | Smith, [NAME] | C65D | LIFT
103 | Smith, [NAME] | C61Q | GW
104 | Smith, [NAME] | C67GJ | Jan
105 | Smith, [NAME] | C65L | FR LIFT
106 | Smith, [NAME] | C65F | FR RCP
Spreadsheet: 880190d1727811313-looking-up-data-across-entire-workbook-sample-workbook1
Sheet: Store4

Store number | Store 4
Managers Name
Estimate Details
Activity |  |  | Role | Min Hours | [NAME]
Requirements |  |  | B/A | 10 | 15
Design |  |  | B/S | 20 | 35
Build |  |  | Developer | 30 | 50
Test |  |  | QA | 20 | 40
 |  |  | Totals
Spreadsheet: harry_arora__12154__Plan_IncomeSheets_Presto
Sheet: Northeast Power Trading

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 |  | $ |  | $ |  | $
 |  |  |  |  |  |  |  |  |  |  | 1000
Compensation/Taxes and Benefits
Employee Expense
Travel/Entertainment
Consulting |  |  | 4.998 |  |  |  |  |  |  |  | -1
Office
Controllable Infrastructure
System Development |  |  | 0 |  | 0
Insurance |  |  | 0 |  | 0
Analyst Associates (includes Comp, Taxes & Benefits and Allocation) |  |  | 355.2
Other Expense
Outside Legal |  |  | 71.051
Outside Tax |  |  | 0 |  | 0
Depreciation & Amortization |  |  | 0 |  | 0
Total Direct Expenses |  | $ |  | $ |  | $
Other Allocated Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive |  |  | 1 |  | 1
Director |  |  | 1 |  | 1
Manager |  |  | 3 |  | 6
Analyst and Associates |  |  | 3 |  | 11
Support Departments |  |  | 7 |  | 4
Total Headcount
2002 Plan (in thousands) |  |  | Team |  | ENA Total
Direct Expense Headcount Ratio |  | $ |  | $
Productivity [NAME] |  | $ |  | $
ROCE
Spreadsheet: 726560d1617292266-power-query-grouping-conditional-to-data-across-several-columns-filter-based-on-most-recent-date-sunnyspirit-
Sheet: Sheet2

Order.ItemID | DU | ETA | ETS | Vessel
Spreadsheet: 682245d1591974002-automatic-updating-of-overdue-tasks-sample
Sheet: Sheet1

TASK | Date raised | Details | responsible person | dept | Due date | status | days overdue
task1 | 2020-01-13 00:00:00 |  | [NAME] | Maint | 2019-12-16 00:00:00
[NAME] | 2020-02-18 00:00:00 |  | [NAME] | HR | 2020-04-26 00:00:00
task3 | 2020-01-09 00:00:00 |  | [NAME] | IT | 2020-05-20 00:00:00
task4 | 2020-01-15 00:00:00 |  | Veronica | HSE | 2020-06-30 00:00:00
task5 | 2020-02-18 00:00:00 |  | Veronica | HSE | 2020-07-19 00:00:00
task6 | 2020-01-14 00:00:00 |  | [NAME] | IT | 2020-09-05 00:00:00
[NAME] | 2019-07-05 00:00:00 |  | [NAME] | Offshore | 2021-01-01 00:00:00
Spreadsheet: 847519d1698404980-adding-up-weights-when-the-sku-name-changes-test-sheet
Sheet: Sheet1

Order No. | Address Name | Address 1 | City | Province | Country | PostCode | Telephone | [NAME] | Address2 | District | Product Name | Product SKU | Product Number | Weight | 0 |  |  | 0
Test 1 | Test 1 | Test 1 | Test 1 | Test 1 | Test 1 |  |  |  |  |  |  | Unit01 | 1 | 0.1 |  | 0.1
Test 2 | Test 2 | Test 2 | Test 2 | Test 2 | Test 2 |  |  |  |  |  |  | Unit02 | 1 | 0.2 |  | 0.2
Test 3 | Test 3 | Test 3 | Test 3 | Test 3 | Test 3 |  |  |  |  |  |  | Unit03 | 1 | 0.5 |  | 0.5
Test 4 | Test 4 | Test 4 | Test 4 | Test 4 | Test 4 |  |  |  |  |  |  | Unit04 | 1 | 0.6 |  | 0.6
Test 5 | Test 5 | Test 5 | Test 5 | Test 5 | Test 5 |  |  |  |  |  |  | Unit05 | 1 | 0.8 |  | 0.8
Test 6 | Test 6 | Test 6 | Test 6 | Test 6 | Test 6 |  |  |  |  |  |  | Unit01 + Unit02 | 2 | 0.3 |  | 0.3
Test 7 | Test 7 | Test 7 | Test 7 | Test 7 | Test 7 |  |  |  |  |  |  | Unit03 + Unit04 | 2 | 1.1 |  | 1.1
Test 8 | Test 8 | Test 8 | Test 8 | Test 8 | Test 8 |  |  |  |  |  |  | 2xUnit01 | 2 | 0.1 |  | 0.2
Test 9 | Test 9 | Test 9 | Test 9 | Test 9 | Test 9 |  |  |  |  |  |  | 2xUnit02 + Unit05 | 3 | 1 |  | 1.2
Test 10 | Test 10 | Test 10 | Test 10 | Test 10 | Test 10 |  |  |  |  |  |  | Unit03 + 3xUnit02 | 4 | 0.7 |  | 1.1
Test 11 | Test 11 | Test 11 | Test 11 | Test 11 | Test 11 |  |  |  |  |  |  | 4xUnit01 | 4 | 0.1 |  | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULT ABOVE
Spreadsheet: 602195d1544815448-simple-conditional-formatting-wont-highlight-all-cells-conditional-formatting
Sheet: Sheet1

With Conditional Formatting |  |  |  | My Goal |  |  | Test Example
FILE #1 | SERIAL #1 |  |  | FILE #1 | SERIAL #1 |  | FILE #1 | SERIAL #1
[NAME] |  |  |  | [NAME] |  |  | [NAME]
0.05 |  |  |  | 0 |  |  | 0.323 | x
 |  |  |  |  |  |  | x | x
FILE #2 | SERIAL #2 |  |  | FILE #2 | SERIAL #2 |  | x | x
TITLE2 |  |  |  | TITLE2
0 |  |  |  | 0.9990257480862909
FILE #3 | SERIAL #3 |  |  | FILE #3 | SERIAL #3
TITLE3 |  |  |  | TITLE3
0 |  |  |  | 0.05
FILE #4 | SERIAL #4 |  |  | FILE #4 | SERIAL #4
TITLE4 |  |  |  | TITLE4
0.9240655121072017 | X |  |  | 0.9240655121072017
FILE #5 | SERIAL #5 |  |  | FILE #5 | SERIAL #5
TITLE5 |  |  |  | TITLE5
0 | X |  |  | 0
Spreadsheet: 121558d1316149818-finding-the-lowest-value-based-on-multiple-text-criteria-book2
Sheet: Imported Data 2

Data | ID
10 | xxxx P01 xx Name1 xxx 2000 x |  | x
12 | xxx [NAME] xxxxx 2002 xx |  | xx
3 | xxx P02 xx Name2 xxxx 2000 xxxxx |  | xxx
27 | [NAME] xxx Name1 xxxx 2001 x |  | xxxx
51 | xxxx [NAME] xx 2002 xxx |  | xxxxx
9 | x P04 xx Name1 xxx 2001 |  | x
16 | xxx P04 xx Name2 2000 x |  | xx
24 | P02 xxxx [NAME] xxx 2000 x |  | xxx
18 | xxx P03 xx Name1 x 2000 xxxx |  | xxxx
5 | [NAME] xxx Name2 x 2000 xxxxx |  | xxxxx
33 | x P01 xxx Name1 xx 2002 xxxx
1 | xxx P02 xx Name1 xxxx 2000 x
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: QTD Recon Q3FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended December 31, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 1053 |  | 0 |  | 357 |  | 0 |  | 0 |  | 0 |  | 1410
Cost of revenue | 586 |  | -3 |  | 0 |  | 0 |  | -1 |  | 0 |  | 582
Gross profit | 467 |  | 3 |  | 357 |  | 0 |  | 1 |  | 0 |  | 828
Operating expenses:
Marketing and sales | 253 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 247
General and administrative | 75 |  | 0 |  | 0 |  | 0 |  | -10 |  | 0 |  | 65
Research and development | 273 |  | 0 |  | 0 |  | 0 |  | -29 |  | 0 |  | 244
Acquisition-related contingent consideration | 1 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 14 |  | -14 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 154 |  | 0 |  | 0 |  | -154 |  | 0 |  | 0 |  | 0
Total operating expenses | 770 |  | -15 |  | 0 |  | -154 |  | -45 |  | 0 |  | 556
Operating income (loss) | -303 |  | 18 |  | 357 |  | 154 |  | 46 |  | 0 |  | 272
Interest and other income (expense), net | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for income taxes | -303 |  | 18 |  | 357 |  | 154 |  | 46 |  | 0 |  | 272
Provision for income taxes | 19 |  |  |  |  |  |  |  |  |  | 57 |  | 76
Net income (loss) | -322 |  | 18 |  | 357 |  | 154 |  | 46 |  | -57 |  | 196
Loss per share |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.97 |  |  |  |  |  |  |  | Basic |  |  |  | 0.59
 |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.59
Number of shares used in computation |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 332 |  |  |  |  |  |  |  | Basic |  |  |  | 332
 |  |  |  |  |  |  |  |  | Diluted |  |  |  | 335
Spreadsheet: 701472d1603788755-subtract-1-from-last-5-records-manualexample
Sheet: Manual -what i would like

A | B |  | B
0 |  |  | 0
0 |  |  | -1
0 |  |  | -1
0 |  |  | -1
0 |  |  | -2
-1 |  |  | -2
0 |  |  | -1
0 |  |  | -1
-1 |  |  | -1
0 |  |  | 0
0 |  |  | 0
Spreadsheet: 71413d1272101627-linking-data-to-multiple-sheets-book1
Sheet: Master

Name | Location
A | WEST
B | WASH
C | INFAN
D | WASH
E | WEST
F | INFAN
G | BLUFF
H | INFAN
I | APG
J | BLUFF
K | APG
L | WASH
M | BLUFF
N | BLUFF
O | WEST
P | BLUFF
Q | WASH
R | INFAN
S | BLUFF
T | WASH
U | INFAN
V | BLUFF
W | WEST
X | INFAN
Y | WASH
Z | INFAN
Spreadsheet: 818959d1677145728-index-lookup-but-need-the-column-lookup-to-change-example
Sheet: Sheet3

name | AB | AC | AD | AE
Achiever |  |  |  | 5
[NAME] |  |  | 5
Belief
Consistency |  |  |  | 4
Deliberative
Discipline
Focus
Responsibility
Restorative
Activator
Command | 3
Communication
Competition
Maximizer |  |  |  | 3
Self-Assurance
Significance | 4
Woo
Adaptability
Connectedness
Developer
Empathy
Harmony |  |  |  | 2
Includer |  | 4
Individualization | 5
Positivity |  | 3 | 4
Relator | 1
Analytical |  |  |  | 1
Context
Futuristic |  | 5 | 1
Ideation |  | 2 | 2
Input
Intellection
[NAME] |  |  | 3
Strategic | 2 | 1
Spreadsheet: d5716c48-0bfb-44fc-a594-e201cf4bc9b6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6145 | 15861 | [NAME] | Naude | RSA | 93 | 00:20:58 | 00:00:43 | 01:02:23 | 00:00:49 | [NAME] | 1 | 02:14:47
6145 | 40178 | Grant | Edmiston | RSA | 90 | 00:26:46 | 00:00:32 | 01:04:33 | 00:00:49 | 00:42:33 | 2 | 02:15:13
6145 | 40186 | Riaan | Schoeman | RSA | 94 | 00:15:54 | 00:00:31 | 01:11:52 | 00:00:35 | 00:51:26 | 3 | [NAME]
6145 | 40243 | [NAME] | Makhanya | RSA | 0 | 00:21:11 | 00:00:46 | 01:13:37 | 00:01:05 | 00:46:17 | 4 | 02:22:56
Spreadsheet: 689437d1596404660-find-first-and-last-row-number-that-contains-specific-text-with-additional-criteria-sample
Sheet: Sheet2

Date | Desc | Code | ID
2020-04-02 00:00:00 | CHECK METER | GAS | XP
2020-04-05 00:00:00 | READ=2114.525 | GAS | SD
2019-05-04 00:00:00 | [NAME] | ELE | XP
2019-07-22 00:00:00 | READ=44283 | ELE | SD
2019-08-15 00:00:00 | READ=7252.328 | GAS | XP
2019-09-18 00:00:00 | NEW CONTRACT | ELE | SD
2019-10-11 00:00:00 | APPOINTMENT | MTC | XP
2019-12-12 00:00:00 | EXCEL | ELE | SD
2020-02-02 00:00:00 | WORD | GAS | XP
2020-04-08 00:00:00 | POWERPOINT | ELE | XP
2020-05-03 00:00:00 | READ=332 | H2O | SD
2020-05-12 00:00:00 | READ=49783 | ELE | SD
2020-06-30 00:00:00 | READ=8825.789 | GAS | XP
2020-07-01 00:00:00 | READ=2325.323 | GAS | SD
Spreadsheet: 100221d1298628212-calculate-running-total-in-pivottable-stock-monitoring
Sheet: Sheet1

Date | Part Number | Supplier PO | Received Quantity | Customer PO | Outgoing Quantity
2011-01-01 00:00:00 | AAA | 10000 | 10 | 20000 | 6
2011-02-02 00:00:00 | AAA | 10001 | 10
2011-03-03 00:00:00 | AAA |  |  | 20001 | 6
2011-04-04 00:00:00 | AAA |  |  | 20002 | 4
Spreadsheet: 821045d1678406896-complex-conditional-formatting-for-visual-automatic-calendar-event-dashboard-2023
Sheet: Sheet1

MIGW 2023 AT A GLANCE
MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY |  | Month: | Year:
 |  |  |  |  |  |  |  | October | 2023
 |  |  |  |  |  |  |  | January | 2022
 |  |  |  |  |  |  |  | February | 2023
 |  |  |  |  |  |  |  | March | 2024
 |  |  |  |  |  |  |  | April | 2025
 |  |  |  |  |  |  |  | May | 2026
 |  |  |  |  |  |  |  | June | 2027
 |  |  |  |  |  |  |  | July | 2028
 |  |  |  |  | Event 1 | Event 2 |  | August | 2029
 |  |  |  |  |  | Another Event |  | September | 2030
 |  |  |  |  |  | Event 1 |  | October | 2031
 |  |  |  |  |  |  |  | November | 2032
 |  |  |  |  |  |  |  |  | 2033
Event 4 | Event 4 | Event 3 | Event 5 | Event 6 | Event 6 | Event 6
One night event | Day event 1
Spreadsheet: 70041d1270702089-pulling-info-out-of-an-old-layout-oct-08-example
Sheet: 10-8-08 2nd

Daily Problem Report |  |  |  |  |  | 2nd shift |  | Date |  | 2008-10-08 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 3 |  | 8.5 |  | 4.6
PR |  | 2 |  |  |  | 2.3
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 5-2 | 57147-0E010 |  | Problem: STAMPED MIS STRIP |  |  | Station:PROG |  | Ran: | 0
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | MIS STRIP SENSOR ROD WAS NOT SET RIGHT. |  |  | C.E.
 |  |  |  |  | Explain: | CLEANED OUT AND INSTALLED NEW SENSOR. BENT THE NEW ROD SO IT SHOULD NOT HIT AGAIN. |  |  |  |  | 9:22-10:00
 |  |  |  |  | THIS DIE HAS HAD QUITE A FEW ISSUES WITH SENSOR ROD. MAYBE OK, NOW |  |  |  |  |  | .5 support
Stamping T/L: ADAM D
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 75111d1275640657-list-row-numbers-where-cell-values-exist-excel-example-11111111
Sheet: Sheet1

 | My List | What I want | Rows |  | =IF(A1<>"",ROW(),"") |  |  | What I want | Rows
 | [NAME] | [NAME] | 3 |  | 3 |  |  | [NAME] | 3
 | [NAME] | [NAME] | 4 |  | 4 |  |  | [NAME] | 4
 |  | [NAME] | 6 |  |  | <--- |  | [NAME] | 6
 | [NAME] | [NAME] | 9 |  | 6 |  |  | [NAME] | 9
 |  | Trevor | 10 |  |  | <--- |  | Trevor | 10
 |  |  |  |  |  | <--- |  | ... | 11
 | [NAME] |  |  |  | 9
 | Trevor |  |  |  | 10
 | ... |  |  |  | 11
Spreadsheet: 117625d1312915976-looking-for-a-formula-for-a-template-to-pull-data-under-specific-criteria-copy-of-example-1
Sheet: Sheet1

Number that needs to be pulled | Estimate Date | Actual Date | Difference in days
100 | 2011-05-01 00:00:00 | 2011-05-07 00:00:00
200 | 2011-06-21 00:00:00 | 2011-06-30 00:00:00
150 | 2011-06-30 00:00:00 | 2011-07-03 00:00:00
120 | 2011-07-01 00:00:00 | 2011-07-03 00:00:00
Spreadsheet: 798600d1664570908-dates-not-calculating-correctly-understanding-dates-miscalculated
Sheet: Practice

Practice - Understanding Dates
Goal
 | Fill in the functions to answer the questions
Practice Questions
Practice Question 1
 | What is todays date?
Practice Question 2
 | What day will it be in one week from today?
Practice Question 3
 | What year was it 15 years ago from today?
Practice Question 4
 | What month will it be 4 months from today?
Practice Question 5
 | What day number is it today?
Practice Question 6
 | Use a formula to create a date using the answers to questions 4-6.
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 10b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A | N/A | N/A | N/A*** | N/A
Estimated net notional amount outstanding, December 14 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors.
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.
**See Explanatory Notes for currency 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: 806664d1669467945-power-query-adding-rows-s666-pq-brandedadnan-sample
Sheet: Sheet1

 | Year | 21 | 20 | 19 |  | Year | 21 | 20 | 19
 | Net Sales | 1000 | 800 | 700 |  | Net Sales | 1000 | 800 | 700
 | Cost | 500 | 400 | 300 |  | Cost | 500 | 400 | 300
 | general exp | 50 | 40 | 35 |  | Gross Profit | 500 | 400 | 400
 | Marketing | 50 | 40 | 35 |  | general exp | 50 | 40 | 35
 | others | 50 | 40 | 35 |  | Marketing | 50 | 40 | 35
 |  |  |  |  |  | others | 50 | 40 | 35
 |  |  |  |  |  | Net profit | 350 | 280 | 295
Spreadsheet: cfe50542-ad70-4778-aae5-a042dde28029
Sheet: Temp Help (IH)

University of Idaho Time Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAY#
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORG# |  | 0
Last Name, First Name |  |  |  |  |  |  |  | V00000000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Irregular Help |  | X
Pay Period Beginning |  | 2013-12-08 00:00:00 |  |  |  |  | Ending
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERSI
Work Time | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Week 1 Total | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Week 2 Total | Pay Period Total
Start
Stop
Start
Stop
Start
Stop
Start
Stop
[NAME] (IHR)
Overtime Earned
DEDUCTIONS
Annual Leave (IHA/MAL)
[NAME] (IHS/MSL)
Holiday (IHH)
[NAME] (IPL)
TOTAL HOURS
Special Instructions
Employee's Signature |  |  |  |  |  |  |  |  |  |  |  |  | Date
Employer's Signature |  |  |  |  |  |  |  |  |  |  |  |  | Date
2013-12-08 00:00:00 | 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
 | 1
 | 27
 | 1