tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 98988d1297785992-creating-a-calendar-with-auto-update-functions-personnel-example
Sheet: Joe Bloggs

 | RETURN TO INDEX |  | DATE:
 |  |  | Job Currently On: | Link to current date cell in page calendar
 |  |  | Job Tomorrow: | Link to next day cell in page calendar
 |  |  |  | 2011
GENERAL |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Name: | [NAME] |  |  | 1
Employee ID: | e.g. BT01 |  |  | 2
Job Description: | Level 3/Supervisor |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10 | Stewarton
 |  |  |  | 11 | Stewarton
 |  |  |  | 12 | Stewarton
 |  |  |  | 13 | Day off
 |  |  |  | 14 | [NAME]
 |  |  |  | 15 | [NAME]
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
 |  |  |  | 28
 |  |  |  | 29
 |  |  |  | 30
 |  |  |  | 31
Spreadsheet: 63420d1264346081-results-from-multiple-sheets-to-table-example
Sheet: Payments

Blue cells are to be invoiced |  | Highlight in green when invoiced |  | Highlight cell in red once paid |  |  |  | Blue cells are to be invoiced |  | Highlight in green when invoiced |  | Highlight cell in red once paid
Plot no. | Fix | Date | Name | Price | Paid | Balance |  | Plot no. | Fix | Invoice No. | Date | Price | Paid | Balance
 |  |  |  |  | 7
Spreadsheet: 710473d1609003293-match-index-help-excel-help-match-index-2
Sheet: Sheet1

-1 | 14
 |  |  |  |  |  | -2 | -1.5 | -1 | -0.5
 |  |  |  | 13 |  | 0.0325 | 0.065 | 0.0975 | 0.13
 |  |  |  | 13.5 |  | 0.03225 | 0.0645 | 0.09675 | 0.129
 |  |  |  | 14 |  | 0.032 | 0.064 | 0.096 | 0.128
 |  |  |  | 14.5 |  | 0.03175 | 0.0635 | 0.09525 | 0.127
 |  |  |  | 15 |  | 0.0315 | 0.063 | 0.0945 | 0.126
 |  |  |  | 15.5 |  | 0.03125 | 0.0625 | 0.09375 | 0.125
 |  |  |  | 16 |  | 0.031 | 0.062 | 0.093 | 0.124
 |  |  |  | 16.5 |  | 0.03075 | 0.0615 | 0.09225 | 0.123
 |  |  |  | 17 |  | 0.0305 | 0.061 | 0.0915 | 0.122
 |  |  |  | 17.5 |  | 0.03025 | 0.0605 | 0.09075 | 0.121
 |  |  |  | 18 |  | 0.03 | 0.06 | 0.09 | 0.12
 |  |  |  | 18.5 |  | 0.02975 | 0.0595 | 0.08925 | 0.119
 |  |  |  | 19 |  | 0.0295 | 0.059 | 0.0885 | 0.118
 |  |  |  | 19.5
 |  |  |  | 20
 |  |  |  | 20.5
 |  |  |  | 21
 |  |  |  | 21.5
 |  |  |  | 22
 |  |  |  | 22.5
 |  |  |  | 23
 |  |  |  | 23.5
 |  |  |  | 24
 |  |  |  | 24.5
 |  |  |  | 25
 |  |  |  | 25.5
 |  |  |  | 26
 |  |  |  | 26.5
Spreadsheet: 877870d1724818810-need-a-formula-for-counting-each-state-worked-in-then-for-each-state-i-need-a-tally-excel-example-formula-need
Sheet: Sheet1

GRAINGER INVOICES |  |  |  |  |  |  |  |  | State Totals
Invoice No. | HMT | Date | Purchased | Amount Spent | State
9208420589 | [NAME] | 2024-08-07 00:00:00 | 20 | 136.6 | CA |  |  |  | CA
9034589543 | Bud | 2024-08-06 00:00:00 | 125 | 1255 | TX |  |  |  | TX
9846573203 | [NAME] |  | 25 | 175 | CO |  |  |  | MT
7895643213 | [NAME] |  | 222 | 2975 | CA |  |  |  | AL
9875432103 | [NAME] | 2024-08-24 00:00:00 | 117 | 1775 | WA |  |  |  | ME
8765904932 | Bud | 2024-08-12 00:00:00 | 20 | 136.6 | TX |  |  |  | WA
 |  |  |  |  |  |  |  |  | AZ
 |  |  |  |  |  |  |  |  | NV
 |  |  |  |  |  |  |  |  | MI
 |  |  |  |  |  |  |  |  | CO
Spreadsheet: 586028d1534170508-sum-of-even-digits-sum-even-odd-digit-positions
Sheet: Sheet1

 | Phuocam | [NAME] | GK (even positions from LEFT) | GK (odd positions from LEFT)
1
12
123
1234
12345
123456
1234567
12345678
123456789
1234567890
Spreadsheet: 38595d1236760535-combine-data-sheet-sample
Sheet: Editor

Article ID | Editor
5929149 | N/A,
5929149 | [NAME]
5929172 | [NAME]
5929172 | [NAME]
Article ID | Message Description
5929149 | COMMITMENT TO MAKING POSTAL SERVICES ACCESSIBLE TO ALL AUSTRALIANS QUESTIONED
5929149 | COMMITTED TO MAKING POSTAL SERVICES ACCESSIBLE TO ALL AUSTRALIANS
5929149 | DOES NOT CONNECT PEOPLE EVERYDAY
5929172 | IS NOT PART OF THE FABRIC OF AUSTRALIAN LIFE
5929172 | COMMITMENT TO REGIONAL & REMOTE AREAS QUESTIONED
5929172 | DISRESPECTS/DOES NOT CARE ABOUT ITS CUSTOMERS
5929172 | IS COMMITTED TO REGIONAL & REMOTE AREAS
Output
Article ID | Message Description | Editor
5929149 | COMMITMENT TO MAKING POSTAL SERVICES ACCESSIBLE TO ALL AUSTRALIANS QUESTIONED | N/A,
5929149 | COMMITMENT TO MAKING POSTAL SERVICES ACCESSIBLE TO ALL AUSTRALIANS QUESTIONED | [NAME]
5929149 | COMMITTED TO MAKING POSTAL SERVICES ACCESSIBLE TO ALL AUSTRALIANS | N/A,
5929149 | COMMITTED TO MAKING POSTAL SERVICES ACCESSIBLE TO ALL AUSTRALIANS | [NAME]
5929149 | DOES NOT CONNECT PEOPLE EVERYDAY | N/A,
5929149 | DOES NOT CONNECT PEOPLE EVERYDAY | [NAME]
5929172 | IS NOT PART OF THE FABRIC OF AUSTRALIAN LIFE | [NAME]
5929172 | IS NOT PART OF THE FABRIC OF AUSTRALIAN LIFE | [NAME]
5929172 | COMMITMENT TO REGIONAL & REMOTE AREAS QUESTIONED | [NAME]
5929172 | COMMITMENT TO REGIONAL & REMOTE AREAS QUESTIONED | [NAME]
5929172 | DISRESPECTS/DOES NOT CARE ABOUT ITS CUSTOMERS | [NAME]
5929172 | DISRESPECTS/DOES NOT CARE ABOUT ITS CUSTOMERS | [NAME]
5929172 | IS COMMITTED TO REGIONAL & REMOTE AREAS | [NAME]
5929172 | IS COMMITTED TO REGIONAL & REMOTE AREAS | [NAME]
Spreadsheet: 164402d1340746395-add-rows-if-referenced-cells-in-another-sheet-contain-data-excel-help
Sheet: Sheet36

Estimate
Job: | #N/A |  | Description: |  |  |  |  |  |  |  |  |  | Reference
Phase: |  |  | Comment: |  |  |  |  |  |  |  |  |  |  | Type: | Drawing number:
Date: | 2012-06-26 17:24:24 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Exclusions and Qualifications: |  |  |  |  |  |  |  |  |  | 2
Drawing Reference |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LF/SF: | Quantities: | Connections: | Material: | Finish:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Other
Spreadsheet: 80247d1280430872-return-first-occurrence-returnfirstoccurrence_formulas
Sheet: Sheet1

ID |  |  | Type1_ID | [NAME] | Unit | D&E | Unique D&E |  | Type1_ID | [NAME] | Min_Unit
1 |  |  | 1 | A | 1 | 1-A | 1-A |  | 1 | A | 1
2 |  |  | 1 | B | 2 | 1-B | 1-B |  | 1 | B | 2
3 |  |  | 1 | A | 4 | 1-A | 1-C |  | 1 | C | 4
4 |  |  | 1 | A | 5 | 1-A | 2-A |  | 2 | A | 1
5 |  |  | 1 | B | 3 | 1-B | 2-B |  | 2 | B | 2
6 |  |  | 1 | C | 4 | 1-C | 3-A |  | 3 | A | 5
7 |  |  | 1 | C | 5 | 1-C | 3-B |  | 3 | B | 1
8 |  |  | 2 | A | 1 | 2-A | 3-C |  | 3 | C | 2
9 |  |  | 2 | B | 2 | 2-B | 4-A |  | 4 | A | 3
10 |  |  | 2 | A | 4 | 2-A | 4-B |  | 4 | B | 4
 |  |  | 3 | A | 5 | 3-A | 4-C |  | 4 | C | 5
 |  |  | 3 | B | 3 | 3-B | 5-C |  | 5 | C | 1
 |  |  | 3 | C | 4 | 3-C | 5-B |  | 5 | B | 2
 |  |  | 3 | C | 5 | 3-C | 5-A |  | 5 | A | 5
 |  |  | 3 | B | 1 | 3-B | 6-B |  | 6 | B | 2
 |  |  | 3 | C | 2 | 3-C | 6-A |  | 6 | A | 4
 |  |  | 3 | C | 4 | 3-C | 6-C |  | 6 | C | 5
 |  |  | 3 | A | 5 | 3-A | 7-C |  | 7 | C | 1
 |  |  | 4 | A | 3 | 4-A | 7-A |  | 7 | A | 4
 |  |  | 4 | B | 4 | 4-B | 7-B |  | 7 | B | 2
 |  |  | 4 | C | 5 | 4-C | 8-A |  | 8 | A | 4
 |  |  | 5 | C | 1 | 5-C | 8-C |  | 8 | C | 1
 |  |  | 5 | B | 2 | 5-B | 8-B |  | 8 | B | 2
 |  |  | 5 | C | 4 | 5-C | 9-C |  | 9 | C | 3
 |  |  | 5 | C | 5 | 5-C | 9-B |  | 9 | B | 1
 |  |  | 5 | B | 3 | 5-B | 9-A |  | 9 | A | 2
 |  |  | 5 | C | 4 | 5-C | 10-C |  | 10 | C | 2
 |  |  | 5 | A | 5 | 5-A | 10-A |  | 10 | A | 3
 |  |  | 5 | C | 1 | 5-C
 |  |  | 6 | B | 2 | 6-B
 |  |  | 6 | A | 4 | 6-A
 |  |  | 6 | C | 5 | 6-C
 |  |  | 6 | B | 3 | 6-B
 |  |  | 7 | C | 4 | 7-C
 |  |  | 7 | A | 5 | 7-A
 |  |  | 7 | C | 1 | 7-C
 |  |  | 7 | B | 2 | 7-B
 |  |  | 7 | A | 4 | 7-A
 |  |  | 7 | C | 5 | 7-C
 |  |  | 7 | B | 3 | 7-B
 |  |  | 7 | C | 4 | 7-C
 |  |  | 7 | A | 5 | 7-A
 |  |  | 7 | C | 1 | 7-C
 |  |  | 7 | B | 2 | 7-B
 |  |  | 7 | A | 4 | 7-A
 |  |  | 7 | C | 5 | 7-C
 |  |  | 7 | B | 3 | 7-B
 |  |  | 7 | C | 4 | 7-C
 |  |  | 8 | A | 5 | 8-A
 |  |  | 8 | C | 1 | 8-C
 |  |  | 8 | B | 2 | 8-B
 |  |  | 8 | C | 4 | 8-C
 |  |  | 8 | B | 5 | 8-B
 |  |  | 8 | C | 3 | 8-C
 |  |  | 8 | A | 4 | 8-A
 |  |  | 9 | C | 5 | 9-C
 |  |  | 9 | B | 1 | 9-B
 |  |  | 9 | A | 2 | 9-A
 |  |  | 9 | C | 4 | 9-C
 |  |  | 9 | B | 5 | 9-B
 |  |  | 9 | C | 3 | 9-C
 |  |  | 9 | A | 4 | 9-A
 |  |  | 9 | B | 5 | 9-B
 |  |  | 10 | C | 2 | 10-C
 |  |  | 10 | A | 3 | 10-A
 |  |  | 10 | A | 4 | 10-A
Spreadsheet: 809738d1671273035-add-serial-every-number-of-repeat-adding-serial-number-for-5-repeat-automatic
Sheet: Sheet1

Head | Example | count | Serial Num | Starting NO.
7003-STUR 1-D | 2304 |  |  | 2034
7002-STUR 1-G | 2306
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7003-STUR 1-D | 2304
7003-STUR 1-D | 2304
7003-STUR 1-D | 2304
7003-STUR 1-D | 2304
7003-STUR 1-D | 2305
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2310
7002-STUR 1-G | 2306
7002-STUR 1-G | 2306
7002-STUR 1-G | 2306
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003-INAh-T
7003-INAh-T
7003-AEF-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7002-RID-E
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-RAN-D
7003-ZAN-D
7003-KAH-D
7003-AEF-D
7003-AEF-D
7003-AEF-D
7003-AEF-D
7003-AEF-D
7002-AEF-F
7002-KAH-F
7002-DAH-F
7003-SSA-D
7003-SSA-D
7003-AHA-D
7003-KAH-D
7003-KAH-D
7003-AEF-D
7003-AEF-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-AHA-D
7003-AEL-D
7003-AEL-D
7003-AHA-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7002-RID-E
7002-RID-E
7002-RID-E
7002-RID-F
7002-RID-F
7003-MAM-D
7002-MAM-F
7003-YAT-D
7003-YAT-D
7003-AFR-D
7002-OAFF-F
7003-OAFF-D
7003-AEL-D
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-OUK-T
7003-SSA-D
7003-SIM-D
7003-SIM-D
7003-SIM-D
7002-SSA-F
7002-SSA-F
7002-ORTH-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-ZAN-F
7003-ZAN-D
7003-AHA-D
7003-AHA-D
7003-AHA-D
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7003-ORTH-T
7002-EER-F
7002-EER-F
7002-EER-F
7002-EER-F
7002-EER-F
7003-INAh-D
7002-EER-F
7002-EER-F
7002-AHA-F
7002-AHA-F
7002-SHAh-F
7002-ZAN-F
7002-ZAN-F
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-ONF-G
7002-ONF-G
7002-ORTH-G
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-DAH-G
7002-DAH-G
7003-DAH-D
7003-DAH-D
7003-SMC-D
7003-SMC-D
7003-SMC-D
7003-SMC-D
7003-MAM-D
7003-MAM-D
7003-MAM-D
7003-MAM-D
7003-AEL-D
7003-AEF-D
7003-MAM-D
7003-MAM-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-SMC-D
7003-OUK-D
7003-INAh-D
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
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
index
2002-02-28 00:00:00 |  |  |  |  | -121179.26 |  | 713.49
2002-02-28 00:00:00
CBS Volume |  |  |  |  |  |  | 2808
 |  |  | -35044
Spreadsheet: 712167d1610095181-dynamic-calendar-that-predicts-when-something-will-need-to-be-ordered-again-pulling-dates-gk
Sheet: Predictor for future

Item | extra information | Last time Purchased | Date for next purchase | Cycle (days) | Estimated time | 2020-01-01 00:00:00 |  | 2020-02-01 00:00:00 |  | 2020-03-01 00:00:00 |  | 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 |  | 2021-04-01 00:00:00 |  | 2021-05-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-07-01 00:00:00 |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00 |  | 2021-11-01 00:00:00 |  | 2021-12-01 00:00:00
 |  |  |  |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec
 |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  | Items used
Spreadsheet: 6208b413-9631-4eb2-9219-bd0cecb58ae6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | If you wish to print out only one set of all table i.e. for only the lead organisation/single applicants, please use CTRL + m to invoke the print macro.
 | The numbers inserted in the various sheets are fictive numbers given as examples. They should be deleted before initialising your own budget
 | Summary Forward Budget for the project
 | Expenditure |  | Total Eligible costs | Total Action Costs |  |  |  | Form B/1 - Summary
 | Summary sheet by beneficiary |  | Total Eligible costs
 | Co-ordinator/Lead organisation - Beneficiary 1 |  | 157901.6781464703 | 1157901.67814647
 | [NAME] |  | 0 | 0
 | Beneficiary 3 |  | 0 | 0
 | [NAME] |  | 0 | 0
 | Beneficiary 5 |  | 0 | 0
 | Beneficiary 6 |  | 0 | 0
 | Beneficiary 7 |  | 0 | 0
 | Beneficiary 8 |  | 0 | 0
 | Beneficiary 9 |  | 0 | 0
 | Beneficiary 10 |  | 0 | 0
 | Beneficiary 11 |  | 0 | 0
 | Beneficiary 12 |  | 0 | 0
 | Beneficiary 13 |  | 0 | 0
 | Beneficiary 14 |  | 0 | 0
 | Beneficiary 15 |  | 0 | 0
 | Beneficiary 16 |  | 0 | 0
 | Beneficiary 17 |  | 0 | 0
 | Beneficiary 18 |  | 0 | 0
 | Beneficiary 19 |  | 0 | 0
 | Beneficiary 20 |  | 0 | 0
 | TOTAL COSTS |  |  | 1157901.67814647
 | TOTAL ELIGIBLE COSTS |  | 0
 |  |  |  |  |  |  |  | Form B/2 - Summary
 | Financing plan |  |  | Revenues |  |  | Amount EUR | Percentage of eligible costs %
 | Co-financing by the applicant (1)+(2) |  |  |  |  | total | 0
 | Monetary contribution (1)
 | Own resources (2)
 | Other third party co-financers* (please specify below) |  |  |  |  | total | 0
 | Name
 | 1.
 | 2.
 | 3.
 | …
 | Contribution requested from the Commission |  |  |  |  | total | 0
 | DG Enterprise
 | Direct revenues expected from the operation (please specify below) |  |  |  |  | total | 0
 | Participants
 | Estimated bank interest generated by the grant requested over the period of implementation of the action |  |  |  |  | total
 | SUBTOTAL ELIGIBLE REVENUES |  |  |  |  |  | 0
 | Value of contributions in kind |  |  |  |  | total |  | Balance check
 | Contribution allocated to the other non-eligible costs |  |  |  |  | total
 | OVERALL TOTAL |  |  |  |  |  | 0
 | * A co-financing statement form ("C") must be filled in for each contributor.
Spreadsheet: 475810d1471465868-fil-an-excel-sheet-automatically-test
Sheet: Program 3

FULL Program | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | total 2016/2019 | VAR 2016/2019 | VAR 2015/2019 | CAGR 2016/2019
Program 3 - Projet AAA | 0 | 0 | 0 | 2.86 | 5.72 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78
Program 3 - Projet BBB | 0 | 0 | 0 | 0 | 0.5
Program 3 - Projet CCC | 0 | 0 | 0 | 1.1 | 2.2
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 5.35 | 5.51 | 5.68 | 5.85 | 6.025 | 6.2
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 11.44
 | 0 | 0 | 0 | 0 | 0 | 1
 | 0 | 0 | 0 | 0 | 0
Total New Products
Spreadsheet: b6962866-9888-44f5-a507-8ed843dc92b3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
264162 | 74986 | Valentina | Zapatrina | RUS |  | 00:23:01 | 00:01:03 | 02:50:09 | 00:01:29 | 01:29:07 | 1 | 04:44:49
264162 | 5486 | Anastasiya | Polyanskaya | RUS |  | 00:24:48 | 00:01:09 | 02:40:09 | 00:01:05 | 01:45:48 | 2 | 04:52:59
264162 | 44627 | Zoya | Kasheeva | RUS |  | 00:27:57 | 00:02:49 | 03:27:48 | 00:03:47 | 02:41:57 | 3 | 06:44:18
264162 | 50782 | Maria | Lemeseva | RUS |  | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
264162 | 27597 | Alena | Adanichkina | RUS |  | 00:25:26 | 00:01:12 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 720288d1614095600-large-array-for-top-5-completes-test-book
Sheet: Sheet1

Array to pull top 5 contracts by Company Number that are over $1M in Revenue (Column E), Greater than or equal 80% complete (H), but less than 100% complete (column H)
Company 10 |  |  |  | Company 13
# | Contract | [NAME] | % Complete | # | Contract | [NAME] | % Complete
1 |  |  |  | 1 |  |  |  |  | Only looks at projects >= $1,000,000
2 | 1000004 | Contract 4 | 0.81 | 2 | 1300002 | Contract 9 | 1 |  | Only projects with greater than or equal to 80%
3 | 1000005 | Contract 5 | 0.845 | 3 | 1300007 | Contract 14 | 0.86
4 | 1000007 | Contract 7 | 0.95 | 4
5 |  |  |  | 5
Company | Contract | [NAME] | Job Cost Department | Estimated Revenue  at Completion | Estimated Cost  at Completion | Estimated Gross Profit  at Completion | % Complete
10 | 1000001 | Contract 1 | Plan | 500000 | 450000 |  | 0.835
10 | 1000002 | Contract 2 | Plan | 1350000 | 1215000 |  | 0.923
10 | 1000003 | Contract 3 | Plan | 435000 | 391500 |  | 0.99
10 | 1000004 | Contract 4 | Plan | 8951000 | 8055900 |  | 0.81
10 | 1000005 | Contract 5 | Plan | 4152321 | 3737088.9 |  | 0.845
10 | 1000006 | Contract 6 | Plan | 850219 | 765197.1 |  | 0.12
10 | 1000007 | Contract 7 | Plan | 2253221 | 2027898.9 |  | 0.95
13 | 1300001 | Contract 8 | Plan | 6950000 | 6255000 |  | 0.99
13 | 1300002 | Contract 9 | Plan | 2035000 | 1831500 |  | 1
13 | 1300003 | Contract 10 | Plan | 450690 | 405621 |  | 0.05
13 | 1300004 | Contract 11 | Plan | 470555 | 423499.5 |  | 0.1
13 | 1300005 | Contract 12 | Plan | 1780500 | 1602450 |  | 0.75
13 | 1300006 | Contract 13 | Plan | 675221 | 607698.9 |  | 0.3
13 | 1300007 | Contract 14 | Plan | 1350000 | 1215000 |  | 0.86
13 | 1300008 | Contract 15 | Plan | 435000 | 391500 |  | 1
15 | 1500001 | Contract 16 | Plan | 8951000 | 8055900 |  | 1
15 | 1500002 | Contract 17 | Plan | 4152321 | 3737088.9 |  | 0.89
15 | 1500003 | Contract 18 | Plan | 358100 | 322290 |  | 0.559
15 | 1500004 | Contract 19 | Plan | 396000 | 356400 |  | 0.45
15 | 1500005 | Contract 20 | Plan | 4800000 | 4320000 |  | 0.9
15 | 1500006 | Contract 21 | Plan | 61000000 | 54900000 |  | 0.81
15 | 1500007 | Contract 22 | Plan | 2035000 | 1831500 |  | 0.8269
15 | 1500008 | Contract 23 | Plan | 450690 | 405621 |  | 0.02
15 | 1500009 | Contract 24 | Plan | 470555 | 423499.5 |  | 0.68
15 | 1500010 | Contract 25 | Plan | 1780500 | 1602450 |  | 0.45
15 | 1500011 | Contract 26 | Plan | 675221 | 607698.9 |  | 0.9
15 | 1500012 | Contract 27 | Plan | 965000 | 868500 |  | 0.368
15 | 1500013 | Contract 28 | Plan | 10000000 | 9000000 |  | 1
Spreadsheet: 83691d1283710539-vlookup-with-a-number-range-book1_bluseals
Sheet: A

System | Rate
32471 | 79 |  | 32 |  | If the associate has worked 1 to 19 hours then the rate should be 34
32471 | 88 |  | 32 |  | If the associate has worked 20 to 29 hours then the rate should be 69
32471 | 96 |  | 32 |  | If the associate has worked 30 to 39 hours then the rate should be 79
32471 | 106 |  | 32 |  | If the associate has worked 40 to 49 hours then the rate should be 88
32471 | 125 |  | 32 |  | If the associate has worked 50 to 59 hours then the rate should be 96
32471 | 125 |  | 32 |  | If the associate has worked 60 to 69 hours then the rate should be 106
32471 | 125 |  | 32 |  | If the associate has worked 70 to 79 hours then the rate should be 115
32471 | 125 |  | 32 |  | If the associate has worked 80 or over then the rate should be 125
32471 | 125 |  | 32
32471 | 125 |  | 32
Spreadsheet: 751657d1634228336-index-match-with-dates-less-than-or-equal-to-sample
Sheet: Sheet1

 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2021-01-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-08-01 00:00:00
Location | 297 | 297 | 297 | 297 | 297 | 297
Ahousat, BC | 3 | 3 | 3 | 3 | 3 | 3
Aklavik, NT | 4 | 4 | 4 | 4 | 4 | 4
Alert, NU | 5 | 5 | 5 | 5 | 5 | 5
[NAME], BC | 2 | 2 | 2 | 2 | 2 | 2
[NAME], BC (incl. [NAME] no 799) | 2 | 2 | 2 | 2 | 2 | 2
Arctic Bay/Ikpiarjuk, NU | 5 | 5 | 5 | 5 | 5 | 5
Arviat, NU | 4 | 4 | 4 | 4 | 4 | 4
Assumption, AB (see Hay Lake Reserve)
Atikameg, AB
[NAME], BC | 2 | 2 | 2 | 2 | 2 | 2
Attawapiskat, ON | 3 | 3 | 3 | 3 | 3 | 3
Baie Verte, NL | 2 | 2 | 2 | 2 | 2 | 2
[NAME], NU | 4 | 4 | 4 | 4 | 4 | 4
[NAME]'s Harbour, NL | 3 | 3 | 3 | 3 | 3 | 3
Alert, NU | Example
2020-12-05 00:00:00
Spreadsheet: 9a579e23-0235-4f7a-ae9c-591af85c2682
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
CDU | Test | CDU | Cadmium, 24 Hour, [NAME] | Cadmium, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 0.0-1.3 mcg/specimen | Monday through Friday; 3 p.m. - 9 p.m.; Saturday, 8 a.m. - 3 p.m./Continuously | 1 day | 3 days | 1 | 82300 |  |  |  |  | Rochester
CDU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CDU | Order Question | TIME7 | Collection Duration |  | Plain Text
CDU | Order Question | VL83 | Total Volume |  | Plain Text
CDU | Result | 31106 | Cadmium, 24 Hr, U | Cadmium, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 5612-7
CDU | Result | TIME7 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9
CDU | Result | VL83 | Total Volume | Total Volume | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4
CDU | Result | 31075 | Cd Concentration | Cd Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 21130-0