tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35979d1233710756-how-can-i-auto-sort-book1
Sheet: Sheet4

 |  | [NAME]
 |  | Hours to Date
Date |  | Hours |  | Total
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 538908d1505876134-adding-row-content-from-sheet-to-sheet-example-didierkassas-
Sheet: Volunteer

 |  |  |  |  | [NAME]
 |  |  |  |  | 2017-09-19 00:00:00
 | Session # | 8
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 9
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 10
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 11
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 12
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 13
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 14
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 15
 | 1 | [NAME] |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
Spreadsheet: 225346d1364972128-really-complex-problem-remaining-value-check-help-example-fixed
Sheet: Export

Redni br. | C. broj | Datum | Količina(TN) | Vrijednost | Quantity taken from each export | Value of export | C-Number of exact export used |  |  |  |  |  | Loss during the process
1 | C-2333 | 2013-03-03 00:00:00 | 15 | 12000 |  |  |  |  |  |  |  |  | 1.01522
 |  |  |  |  |  |  |  |  |  |  |  |  | ton of export= ton of imoport*1,01522
2 | C-2444 | 2013-03-04 00:00:00 | 37 | 29600
Spreadsheet: theresa_staab__39641__Enron Statement_1101
Sheet: Enron Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Verification Date:
 |  | Enron North America Corp. |  |  | Crestone Gathering Services, L.L.C. | 2001-12-06 00:00:00
 |  |  |  |  | Citibank, New York
 |  |  |  |  | Account # 3047 9083 | Due Date:
 |  |  |  |  | ABA #  021 000 089 | 2001-12-31 00:00:00
 |  |  |  |  | Contact: [NAME]
 |  |  |  |  | Tel: (720) 946-3692 | Payment Method:
 |  | Contact:  [NAME] |  |  | Fax: (720) 946-3640 | Wire
 |  | Tel:  (303) 575-6485 |  |  |  | Terms:
 |  | Fax: (303) 534-0552 |  |  |  | Last Day of Month
2001-12-06 09:36:24.370000
Delivery Period: | Contract #
2001-11-01 00:00:00 | PR-G-999
Producer | [NAME] | Mmbtu | Mcf | $/Mmbtu | $/Mcf | Total Charge
[NAME] | Box Draw #1,#2,#3,#4 | 377502 | 395006 | 0.47 |  | 177425.94
[NAME] | S. Kitty #1,#2,#4,#5 | 824879 | 747804 | 0.61 |  | 503176.19
MTG | MTG | 11904 | 12828 | 0 | 0.445 | 5708.46
MTG | Hannover Compression Charge Adjustment |  |  |  |  | 0
Independent | Independent | 386901 | 412916 | 0 | 0.35 | 144520.6
Independent | Hannover Compression Charge |  |  |  |  | 0
Independent | Facility Fee |  |  |  |  | 0
Independent | Field Services Fee |  |  |  |  | 15000
Phillips | Palamino, Clydesdale | 317408 | 336308 | 0 | 0.45 | 151338.6
Quantum | Mustang | 23870 | 24685 | 0 | 0.565 | 13947.025
Wellstar | [NAME] | 52859 | 56949 | 0 | 0.39 | 22210.11
NorthFinn | Palamino | 22348 | 23824 | 0 | 0.485 | 11554.64
Westport | Bear Paw | 0 | 0 | 0.11 | 0 | 0
Citation | Ft. Union | 20020 | 20280 | 0 | 0.14 | 2839.2
Citation | Bear Paw | 21866 | 22404 |  | 0.455 | 10193.82
Citation | Electric Power Compressor Fee |  | 0.98718 |  |  | 1010.68
 |  |  | TOTAL PAYMENT |  |  | 1058925.265
Spreadsheet: 0d9367c8-52c7-4523-af51-41cd5f5fa026
Sheet: DDR

DDR
 |  |  | # of |  | % hit
Justin | Exp. Level 1 | Perfects |  | Right
[NAME]: | Daft Punk | Excellents |  | Left
Score: |  | Goods |  | Up
Letter Grade: |  | Misses |  | Down
Hard Song Played: | Feel Good Inc
Score: | 16422735
Letter Grade: | C
 |  |  | # of |  | % hit
[NAME] | Exp. Level 3 | Perfects |  | Right
[NAME]: | Moby South Side | Excellents |  | Left
Score: | 9836160 | Goods |  | Up
Letter Grade: | A | Misses |  | Down
Hard Song Played: | Lets Get it [NAME]
Score: | 22336220
Letter Grade: | A
 |  |  | # of |  | % hit
[NAME] | Exp. Level 1 | Perfects |  | Right
[NAME]: | Dynamite Rare | Excellents |  | Left
Score: | 8877540 | Goods |  | Up
Letter Grade: | B | Misses |  | Down
Hard Song Played: | Good Times
Score: | 20541590
Letter Grade: | B
 |  |  | # of |  | % hit
[NAME] | Exp. Level 1 | Perfects |  | Right
[NAME]: | Ice Ice Baby | Excellents |  | Left
Score: | 6999000 | Goods |  | Up
Letter Grade: | D | Misses |  | Down
Hard Song Played: | Coldplay
Score: | 5245690
Letter Grade: | D
 |  |  | # of |  | % hit
Jon | Exp. Level 4 | Perfects |  | Right
[NAME]: | A Brighter Day | Excellents |  | Left
Score: | 7040335 | Goods |  | Up
Letter Grade: | C | Misses |  | Down
Hard Song Played: | [NAME]
Score: | 19231590
Letter Grade: | C
 |  |  | # of |  | % hit
[NAME] | Exp. Level 4 | Perfects |  | Right
[NAME]: | [NAME] | Excellents |  | Left
Score: | 9115320 | Goods |  | Up
Letter Grade: | C | Misses |  | Down
Hard Song Played: | I Know You Want Me
Score: | 21417925
Letter Grade: | A
 |  |  | # of |  | % hit
[NAME] | Exp. Level 5 | Perfects |  | Right
[NAME]: | Ice Ice Baby | Excellents |  | Left
Score: | 10838940 | Goods |  | Up
Letter Grade: | AA | Misses |  | Down
Hard Song Played: | Bonified Lovin
Score: | 23399250
Letter Grade: | A
 |  |  | # of |  | % hit
[NAME] | Exp. Level 2 | Perfects |  | Right
[NAME]: | Viva La Vida | Excellents |  | Left
Score: | 7954050 | Goods |  | Up
Letter Grade: | C | Misses |  | Down
Hard Song Played: | Pink So What
Score: | 20630825
Letter Grade: | C
Spreadsheet: 92251d1291873599-automatically-adjusting-a-formula-for-new-data-dashboard12810
Sheet: FCR Trend

4/5-4/11 | 4/12-4/18 | 4/13-4/25 | 4/26-5/2 | 5/3-5/9 | 5/10-5/16 | 5/17-5/23 | 5/24-5/30 | 5/31-6/6 | 6/7-6/13 | 6/14-6/20 | 6/21-6/27 | 6/28-7/4* | 7/5-7/11 | 7/12-7/18 | 7/19-7/25 | 7/26-8/1 | 8/2-8/8 | 8/9-8/15 | 8/16-8/22 | 8/23-8/29 | 8/30-9/5 | 9/6-9/12 | 9/13-9/19 | 9/20-9/26 | 9/27-10/3 | 10/4-10/10 | 10/11-10/17 | 10/18-10/24 | 10/25-10/31 | 11/1-11/07 | 11/08-11/14 | 11/15-11/21 | 11/22-11/28* | 11/29-12/5 | 12/06-12/12 | 12/13-12/19 | 12/20-12/26* | 12/27-01/02* | 01/03-01/09 | 01/10-01/16 | 01/17-01/23 | 01/24-01/30 | 01/31-02/06 | 02/07-02/13** | 02/14-02/20* | 02/21-02/27 | 02/28-03/06 | 03/07-03-13 | 03/14-03/20 | 03/21-03-27 | 03/28-04/03 | 04/04-04/10 | 04/11-04/17 | 04/18-04/24 | 04/25-05/01 | 05/02-05/08 | 05/09-05/15 | 05/16-05/22 | 05/23-05/29 | 05/30-06/05* | 06/06-06/12 | 06/13-06/19 | 06/20-06/26 | 06/27-07/03 | 07/04-07/10* | 07/11-07/17 | 07/18-07/24 | 07/25-07/31 | 08/01-08/07 | 08/08-08/14 | 08/15-08/21 | 08/22-08/28 | 08/29-09/04 | 09/05-09/11* | 09/12-09/18 | 09/19-09/25 | 09/26-10/02 | 10/03-10/09 | 10/10-10/16* | 10/17-10/23 | 10/24-10/30 | 10/31-11/06 | 11/07-11/13* | 11/14-11/20 | 11/21-11/27* | 11/28-12-04
0.148 | 0.201 | 0.153 | 0.2121 | 0.2033 | 0.1532 | 0.1526 | 0.2098 | 0.1989 | 0.2268 | 0.2063 | 0.2242 | 0.1633 | 0.3102 | 0.1739 | 0.1742 | 0.2 | 0.1804 | 0.2022 | 0.1766 | 0.3073 | 0.209 | 0.2535 | 0.2552 | 0.2092 | 0.2243 | 0.1896 | 0.2832 | 0.245 | 0.2762 | 0.232 | 0.2095 | 0.1647 | 0.2374 | 0.1635 | 0.2161 | 0.2077 | 0.1894 | 0.2212 | 0.2352 | 0.2416 | 0.1491 | 0.2162 | 0.2448 | 0.271 | 0.2119 | 0.2434 | 0.262 | 0.2737 | 0.2653 | 0.254 | 0.2766 | 0.3067 | 0.2714 | 0.2706 | 0.2043 | 0.2436 | 0.1898 | 0.2036 | 0.2139 | 0.2211 | 0.2309 | 0.2542 | 0.2806 | 0.2661 | 0.2183 | 0.2906 | 0.2689 | 0.2468 | 0.1883 | 0.1543 | 0.2243 | 0.205 | 0.2236 | 0.2556 | 0.2426 | 0.2841 | 0.2331 | 0.2646 | 0.3277 | 0.3368 | 0.3062 | 0.2789 | 0.1767 | 0.3217 | 0.3858 | 0.2445
Spreadsheet: 134544d1325428668-trying-to-track-names-with-days-months-and-year-s-member-aging
Sheet: Sheet1

Name | [NAME] | Days Total | Months Total |  | Years Total
a | 2011-01-01 00:00:00 | 366 | 12 | 12 | 1 | 1
b | 2009-01-02 00:00:00 | 1095 | 36 | 36 | 2.997260273972603 | 3
c | 2011-11-15 00:00:00 | 48 | 2 | 2 | 0.1287671232876712 | 1
d | 2010-01-19 00:00:00 | 713 | 24 | 24 | 1.950684931506849 | 2
 |  |  | - Two calculations for calculating Months and year have been provided above, choose whichever suits you.
Spreadsheet: larry_campbell__21018__PCB Graphs
Sheet: 63.26A

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-06-21 00:00:00 |  |  | 27 |  | Sherwood
63.26 A Side |  |  | 2000-06-27 00:00:00 |  |  | 24 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-07-26 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-11-08 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2001-03-14 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2001-04-18 00:00:00 |  |  | 6 |  | Sherwood
 |  |  | 2001-05-08 00:00:00 |  |  | 4 |  | Sherwood
 |  |  | 2001-06-12 00:00:00 |  |  | 3 |  | Sherwood
 |  |  | 2001-07-11 00:00:00 |  |  | 2 |  | Sherwood
 |  |  | 2001-08-09 00:00:00 |  |  | 2 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 875100d1721669758-trying-to-combine-data-fields-if-certain-conditions-exist-example-of-what-i-am-trying-to-do
Sheet: Sheet1

Original data is formatted like this:
AB | Monday1, Monday2,Monday3
AB | Tuesday1, Tuesday2
AC | Wed1, Wed2, Wed3, Wed4
AC | Thur1, Thur2, Thur3
AD | Fri1, Fri2
AD | [NAME]
AD | Sun3, Sun4, Sun5
I want to transform it to this:
AB | Monday1, Monday2, Monday3, Tuesday1, Tuesday2
AC | Wed1, Wed2, Wed3, Wed4, Thur1, Thur2, Thur3
AD | Fri1, Fri2, [NAME], Sun3, Sun4, Sun5
For any fields in column A that are duplicate, combine the data in Column E, but separate the data with a comma and a space.
Spreadsheet: 883303d1731896597-count-and-category-book2
Sheet: Configuration

Job Grade |  |  |  |  |  | Hired
Designation | Job level |  |  |  | TA Specialist | Junior Management Position | Analyst / Team Lead | Senior Position | Junior Position | Intern | Total
 |  |  |  |  | TA1 | 0 | 0 | 0 | 0 | 0
Executive Management |  |  |  |  | TA2 | 0 | 0 | 0 | 0 | 0
Chief Executive Officer | Executive Management |  |  |  | TA3 | 0 | 0 | 0 | 0 | 0
Executive Vice President | Executive Management |  |  |  | Total
Senior Management | Executive Management
Senior Vice President | Executive Management
Vice President | Executive Management
Associate Vice President | Executive Management
Managers | Junior Management
Technical Consultant | Junior Management
Software Development Lead | Junior Management
Associate Manager | Junior Management
Principal Software Engineer II | Analyst / Team Lead
Principal Software Engineer I | Analyst / Team Lead
Senior Software Engineer II | Senior
Senior Business Analyst II | Senior
Senior Data Engineer II | Senior
Senior Software Engineer I | Senior
Senior Business Analyst I | Senior
Senior Data Engineer I | Senior
Senior IT Executive | Senior
Senior Finance Executive | Senior
Talent Acquisition Specialist | Senior
Senior HR Executive | Senior
Personal Assistant | Senior
[NAME] | Senior
Office Adminstrator | Senior
Software Engineer II | Junior
Business Analyst II | Junior
Data Engineer II | Junior
UI/UX Engineer | Junior
UX Designer | Junior
Software Engineer I | Junior
Business Analyst I | Junior
Data Engineer I | Junior
IT Executive | Junior
Finance Executive | Junior
HR Executive | Junior
Account Executive | Junior
Administration Executive | Junior
Associate Software Engineer | Entry
Junior Business Analyst | Entry
Associate Data Engineer | Entry
IT Assistant | Entry
Finance Assistant | Entry
HR Assistant | Entry
Account Assistant | Entry
Administration Assistant | Entry
Driver | Entry
Spreadsheet: louise_kitchen__23884__ERCOT Hot List 04-13-01
Sheet: Done Deals

Deal Type | Commercial Lead | Customer | Region | Prob.(%) | Deal Description | Term | Size | Price | Status | Date of Last Contact | Expected Completion Date | Expected Value
Origination | Curry | TECO Fronterra | ERCOT | 1 | Asset Management | 3/16/01-12/31/02 | 514MW | $50,000/year with upside sharing | Done | 2001-04-06 00:00:00 | Q2 | 0
Midmarket | Ahn | [NAME] | ERCOT | 1 | UD Delivered TC Sale | May '01 | 20 | 59 | Done |  |  | 3482
Midmarket | Ahn | [NAME] | ERCOT | 1 | UD Delivered TC Sale | May '01 | 50 | 60.25 | Done |  |  | 8699
Origination | Curry | Enron Wind | ERCOT | 1 | Purchase of Renewable energy and credits | 20 years | 135 MW | $26.53 MWh | Done
Midmarketing | Curry | TNMP | ERCOT | 1 | UB Undelivered Power Sale | 2001-06-01 00:00:00 | 50 MW | 65.25 | Done |  |  | 8195
Midmarketing | Curry | TNMP | ERCOT | 1 | UB Undelivered Power Sale | 2001-06-01 00:00:00 | 50 MW | 66 | Done |  |  | 8195
Midmarketing | Curry | Fronterra | ERCOT | 1 | UD Purchase | Feb 16-March 15 | 100 MW | $1.50 kw-month | Done |  | 2001-02-09 00:00:00 | 2500
Midmarketing | Curry | [NAME] | ERCOT | 1 | UG Delivered TC Sale | 2001-03-01 00:00:00 | 50 MW | 50.5 | Done |  | 2001-02-14 00:00:00 | 8712
Midmarketing | Curry | TXU | ERCOT | 1 | Sold UB Power | July-Aug '03 | 50 MW | 56 | Done |  | 2001-02-23 00:00:00 | 0
Midmarketing | Curry | San Antonio | ERCOT | 1 | UG Purchase | 6/1/2001-10/31/01 | 50 MW | $4.02 kw-month | Done | 2001-03-06 00:00:00 | 2001-03-06 00:00:00 | 175000
Total
Utility
TNMP | 2
TXU | 1
Fronterra (AEP) | 1
Marketer
Coop/Muni
[NAME] | 3
San Antonio | 1
Spreadsheet: 837137d1689873880-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: MAPPING

Path: |  |  |  | A | B | C | D | E | F | G | H
Last Raw |  |  |  |  |  |  |  |  |  |  |  | Path2Price | REAL |  |  |  |  |  | So in the column N, I have the formula I want but its not dynamic. I wish to make it spill depending on the column size like the rest of the functions.
Size
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So in the column O and P, I also have the formula I want but its not dynamic. The same way, I wish to make it spill depending on the column size like the rest of the functions.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In R I have the formula I thought would work for column N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If You put London in Analysis, it adds [NAME] but if u put Paris, there is only [NAME] and [NAME], that why I want it to be dynamic.
Spreadsheet: 67137d1267731866-displaying-differences-between-two-columns-sample
Sheet: Sheet1

Col A | Col B | ID#
xxx | [NAME] | a23 | 1 | 4
bbb | bbb | a42 | 1
BBB | [NAME] | c32 | 2
Bvb | bbb | x89 | 3
FDFD | fdfd | y75 | 4
AAA | AAA | z109 | 4
Spreadsheet: c1cdfff5-9bf8-4ca8-a0e2-4b1c713ecca0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Table S12:  Lung cancer incidence rates (per 100,000) among Asian and African American male lifelong
never smokers in individual cohort studies
 |  | Asian |  |  |  | African American
 |  | MEC |  |  |  | CPS-II Nutrition |  |  |  | MEC
Follow-up |  | 1993-2002 |  |  |  | 1992-2003 |  |  |  | 1993-2002
 |  | Cases | PY | Rate (95% CI)† |  | Cases | PY | Rate (95% CI)† |  | Cases | PY | Rate (95% CI)†
Age
25-29 |  | 0 | 0 | - |  | 0 | 0 | - |  | 0 | 0 | -
30-34 |  | 0 | 0 | - |  | 0 | 0 | - |  | 0 | 0 | -
35-39 |  | 0 | 0 | - |  | 0 | 0 | - |  | 0 | 0 | -
40-44 |  | 0 | 0 | - |  | 0 | 0 | - |  | 0 | 0 | -
45-49 |  | 0 | 4304 | 0.0 ( 0.0, 0.0) |  | 0 | 0 | - |  | 0 | 1280 | 0.0 ( 0.0, 0.0)
50-54 |  | 1 | 10372 | 9.6 (0.2, 53.7) |  | 0 | 27.71 | 0.0 ( 0.0, 0.0) |  | 0 | 3104 | 0.0 ( 0.0, 0.0)
55-59 |  | 2 | 9892 | 20.2 (2.4, 73.0) |  | 0 | 209.59 | 0.0 ( 0.0, 0.0) |  | 1 | 3927 | 25.5 (0.6, 141.9)
60-64 |  | 0 | 8864 | 0.0 ( 0.0, 0.0) |  | 0 | 602.4 | 0.0 ( 0.0, 0.0) |  | 0 | 3975 | 0.0 ( 0.0, 0.0)
65-69 |  | 1 | 10219 | 9.8 (0.2, 54.5) |  | 0 | 827.92 | 0.0 ( 0.0, 0.0) |  | 2 | 4364 | 45.8 (5.5, 165.6)
70-74 |  | 6 | 11827 | 50.7 (18.6, 110.4) |  | 0 | 646.87 | 0.0 ( 0.0, 0.0) |  | 2 | 5321 | 37.6 (4.6, 135.8)
75-79 |  | 7 | 9986 | 70.1 (28.1, 144.4) |  | 0 | 350.42 | 0.0 ( 0.0, 0.0) |  | 3 | 3974 | 75.5 (15.6, 220.6)
80-84 |  | 5 | 3298 | 151.6 (49.2, 353.8) |  | 0 | 115.05 | 0.0 ( 0.0, 0.0) |  | 1 | 1187 | 84.2 (2.1, 469.4)
85+ |  | 0 | 0 | - |  | 0 | 12.83 | 0.0 ( 0.0, 0.0) |  | 0 | 0 | -
 |  | 22 |  |  |  | 0 |  |  |  | 9
Age-standardized rate*
40-69 |  |  |  | - |  |  |  | - |  |  |  | -
40-79 |  |  |  | 10.6 (4.7, 16.6) |  |  |  | - |  |  |  | -
40+ |  |  |  | 12.7 (6.5, 18.8) |  |  |  | - |  |  |  | -
*Age-standardized to the 2000 IARC World population, ages 40-79, only presented if 10 or more events occurred within specified age-range
†  For strata with less than 10 events, the confidence intervals were calculated using Fisher's exact test
Abbreviations as follows:
CPS-II Nutrition = Cancer Prevention Study II Nutrition Cohort [28]
MEC = [NAME] [22]
Spreadsheet: 63544d1264444250-using-two-indexing-match-fields-excelexample
Sheet: Sheet1

NUM | NAME | CITY |  | NAME | CITY
2 | JOE | NY | 54 | JOE | NY
76 | [NAME] | CT | 0 | JESSICA | NJ
54 | JOE | PA | 0 | [NAME] | NJ
34 | JESSICA | NJ | 5 | [NAME] | CT
5 | [NAME] | NY
6 | [NAME] | NJ
Spreadsheet: 219871d1363000045-formula-for-selecting-value-in-cell-using-multiple-criteria-example-20-
Sheet: Raw Data

Day | Time | Duration | Location
Mon | 13:00:00 | 3 | Room 001
Thu | 10:00:00 | 2 | Room 001
Mon | 09:00:00 | 4 | Room 001
Wed | 09:00:00 | 2 | Room 001
Fri | 11:00:00 | 2 | Room 001
Fri | 15:00:00 | 2 | Room 001
Wed | 11:00:00 | 2 | Room 001
Mon | 13:00:00 | 1 | Room 002
Fri | 12:00:00 | 2 | Room 002
Thu | 16:00:00 | 2 | Room 002
Spreadsheet: 757932d1638540294-calculating-4-threads-issue-with-tracker-pla-learning-journey-example-
Sheet: Stage 2 & QAF (Michelle)

Michelle |  |  |  |  |  |  |  |  |  |  | Openings Learning | Openings Learning | Openings Learning | Openings Learning | Openings Learning | Openings Sign Off | Openings Sign Off | Middles Learning | Middles Learning | Middles Learning | Middles Learning | Middles Learning | Middles Learning | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Closures Sign Off | Closures Sign Off |  | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF
[NAME] | [NAME] | Front-Line Manager Name | Grade | Location | Tax Regime | Project | Date TPP Commenced | TUD Date | Cohort | Expected TPP Week | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | [NAME] | Expected QAF Milestone 1 (Week 10) | Actual Milestone 1 Completion | Formula 2 | Expected QAF Milestone 2 (Week 22) | Actual [NAME] | Formula 5 | Expected QAF Milestone 3 (Week 38) | Actual [NAME] | [NAME] | Expected QAF Milestone 4 (Week 52) | Actual [NAME] | Forumula 9 | Expected QAF Milestone 5 (Week 69) | Actual [NAME] | [NAME] 10 | Expected QAF Milestone 6 (Week 78) | Actual [NAME] | [NAME] | Expected QAF Completion (18 months) | Actual QAF Completion | [NAME] 12 | Exceptions
Spreadsheet: 376594d1423658340-calculating-file-intervals-from-300-to-300-volumes
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of files | Interval | Folder's number | yivu
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | ppp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | bamfe
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 |  |  | ppp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  | ppp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 101 |  |  | ret
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | bamfe
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  | ret
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | yutr
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 269 |  |  | ppp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  | bamfe
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | yutr
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 |  |  | ret
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  | bamfe
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  | ppp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  | bamfe
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 78 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | ppp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | yutr
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | yutr
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | bamfe
Spreadsheet: 330924d1404905451-using-is-number-and-search-function-sample
Sheet: sample

Statement details | Cost | Category- entered manually |  | Formulae |  | Example Table
Aldi | 50 | Food |  |  |  | Column1 | Column2
[NAME] | 20 | school |  |  |  | Aldi | Food
Direct Debit 147014 Rea Transactions Rentpayment6018590 | 30 | house |  |  |  | woolworths | Food
Tmsgs                Netbank Bpay  Lotto | 30 | Birthday presents, charitable donations, other gifts,lotto,mass |  |  |  | Coles | Food
Just [NAME]   Nswau | 80 | Medicines, toiletries, hairdressing, personal items |  |  |  | [NAME] | School
Direct Debit 119218 Vodafone | 36 | telephone |  |  |  | lotto | Birthday presents, charitable donations, other gifts,lotto,mass
Blooms The Chemist P | 13 | Medicines, toiletries, hairdressing, personal items |  |  |  | Blooms | Medicines, toiletries, hairdressing, personal items
Woolworths W1087 | 64 | Food |  |  |  | vodafone | telephone
Coles | 25 | Food |  |  |  | rent | house
 | 50
Income
Expenditure
Rent
Childcare
public transport
Heating
Telephone
Electricity
TV
Household
Food and non-alcoholic drinks
Special gluten free food
Alcohol
Clothing and footwear
Medicines, toiletries, hairdressing, personal items
Car (tax, insurance, fuel etc), fares, other travel
Going out, Entertainment
Holidays
Birthday presents, charitable donations, other gifts,lotto,mass
Life insurance, medical insurance, other insurance
Gardening / Outdoor items
Other expenditure
Christmas
Kitty
Savings ( + from, - to )
School
xtra activities girls
Loan
Camping
Total income / expenditure
Spreadsheet: 694185d1599415368-struggling-to-calculate-for-multiple-numbers-for-forum
Sheet: Sheet 1 Formula

Name | Score (Last)
[NAME]
 |  |  | Name | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
JJ Cool | 5 |  | JJ Cool | 1 | 3 | 3 | 4 | 1
Cats Dogs | 4 |  | Cats Dogs | 4 | 5 | 9 | 5 | 2
[NAME] | 7 |  | [NAME] | 4 | 4 | 8 | 6 | 5
[NAME] | 12 |  | [NAME] | 1 | 2 | 5 | 6 | 4
[NAME] | 2 |  | [NAME] | 7 | 3 | 2 | 6 | 5
Spreadsheet: 871159d1717574679-check-dup-or-new-input
Sheet: Worksheet

ID | First NameEN | Last NameEN | Now_output | Expect_output
1445 | Ja | [NAME] |  | New
1446 | Ja | La |  | Dup
1447 | at | Th |  | New
1448 | Si | [NAME] |  | New
1449 | Ja | La |  | Dup
1450 | Ja | La |  | Last
1451 | MM | yu |  | New