tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859796d1708046504-count-of-items-sold-based-on-changing-date-range-countif-calculations-example-2-
Sheet: Sale Details

Transaction |  |  |  |  |  | Status |  |  | Product Name | Quantity
2023-09-05 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 20 Special Ed. [NAME] | 1
2023-09-05 00:00:00 |  |  |  |  |  | Completed |  |  | USB TYPE C TO USBC CABLE 3.1 5A M/M 6FT | 1
2023-09-06 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 20 Special Ed. [NAME] | 1
2023-09-06 00:00:00 |  |  |  |  |  | Completed |  |  | VOYAGER 8200 UC, B8200, BLACK | 1
2023-09-08 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
2023-09-09 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 75e Microsoft | 1
2023-09-10 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 20 Special Ed. [NAME] | 1
2023-09-13 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
2023-09-13 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 75 MS Stereo - headset | 1
2023-09-13 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 75e Microsoft | 1
2023-09-14 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 20 Special Ed. [NAME] | 1
2023-09-14 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
2023-09-14 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
2023-09-14 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
2023-09-14 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 75e Microsoft | 1
2023-09-14 00:00:00 |  |  |  |  |  | Completed |  |  | Kingston 128GB USB FLASH DataTraveler Exodia | 1
2023-09-14 00:00:00 |  |  |  |  |  | Completed |  |  | Kingston DataTraveler SE9 USB flash drive - 64 GB - USB 2.0 metal casing | 1
2023-09-15 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
2023-09-15 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
2023-09-15 00:00:00 |  |  |  |  |  | Completed |  |  | Logitech M510 [NAME] 910-001822 | 1
2023-09-17 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 20 Special Ed. [NAME] | 1
2023-09-17 00:00:00 |  |  |  |  |  | Completed |  |  | VOYAGER 8200 UC, B8200, BLACK | 1
2023-09-17 00:00:00 |  |  |  |  |  | Completed |  |  | VOYAGER 8200 UC, B8200, BLACK | 1
2023-09-18 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 20 Special Ed. [NAME] | 1
2023-09-18 00:00:00 |  |  |  |  |  | Completed |  |  | Jabra Evolve 40 MS Stereo  Headset On Ear | 1
Spreadsheet: 753468d1635454186-return-multiple-rows-based-on-multiple-critera-ship-log-test-new
Sheet: 11-17

 | GAR-2 | 1 | GA | US |  | BC
22805-2 | BOX-2 | 1 | GA | US |  | BC
22805-3 | BOX-2 | 1 | GA | US |  | BC
22805-4 | GAR-2 | 1 | GA | US |  | BC
30005 | W-BB-BL-2 | 1 | IA | US |  | BC
30006 | W-BB-BL-2 | 1 | IA | US |  | BC
30005-2 | W-BB-BL-2 | 1 | IA | US |  | BC
30005-3 | W-BB-BL-2 | 1 | IA | US |  | BC
30005-4 | W-BB-BL-2 | 1 | IA | US |  | BC
30005-5 | W-BB-BL-2 | 1 | IA | US |  | BC
30005-6 | W-BB-BL-2 | 1 | IA | US |  | BC
30005-7 | W-BB-BL-2 | 1 | IA | US |  | BC
30012 | W-BH-2 | 1 | GA | US |  | BC
30022-2 | BOX-2 | 1 | FL | US |  | BC
30022-3 | BOX-2 | 1 | FL | US |  | BC
30022-4 | BOX-2 | 1 | FL | US |  | BC
30022-5 | BOX-2 | 1 | FL | US |  | BC
Spreadsheet: chris_germany__2005__Letter Log 05-24
Sheet: Termination

 | Events of Default/Termination
 | 2002-05-24 00:00:00
Term | Counterparty | Global Counterparty ID # | Attorney Assigned | Enron Entity | Amount (if applicable) | Backup for Calculation | Enron Response | [NAME] | Early Termination Date | Nature of Default (if any) | Contract Type(s) | Comments | Margin (Posted by Enron)/Posted to Enron
 | CNG LDC Gas Supply Group, as agent on behalf of Hope Gas, Inc. |  |  | ENA | 66437878.57 | N |  |  | 2001-12-01 00:00:00 | mutual termination | Base Contract for the Sale and Purchase of Natural Gas Supply Area Gas Acquisition Contract (01/01/1999) | 05/21 ltr calculates amount due (after setoff) to Dominion entities
 | EnerVest Energy, L.P. |  |  | ENA |  |  |  |  | 2002-05-22 00:00:00 | bankruptcy | ISDA (08/03/1999) | EnerVest will not pay ENA's invoice dated 05/02 because of the right to setoff this amount against any settlement amount owed by ENA
 | Formosa Plastics Corporation, U.S.A. |  |  | EGP Fuels Company |  |  |  |  | 2002-02-11 00:00:00 | ? | Service Agreement (04/19/2001) | Since Formosa has received no reply to its earlier letter, it is terminating the agreement
 | Northwest Pipeline Corporation |  |  | ENA |  |  |  |  | 2000-05-31 00:00:00 | article IV | Transportation Agreement #125142 (04/03/2000)
 | Northwest Pipeline Corporation |  |  | ENA |  |  |  |  | 2002-05-31 00:00:00 | article IV | Transportation Agreement #125244 (04/28/2000)
 | Northwest Pipeline Corporation |  |  | ENA |  |  |  |  | 2002-05-31 00:00:00 | article IV | Transportation Agreement #125248 (05/03/2000)
 | Telge Kraft AB |  |  | Enron Nordic Energy (ECTRIC) |  |  |  |  | 2002-04-14 00:00:00 | bankruptcy | deal nos. N1189635, N3114613, N2753875, N2283528, EOL, N2793879, N54778, N2293529, N44649
Spreadsheet: 105737d1303006897-using-controls-or-index-i-think-help-please-testing
Sheet: SMALL

 | DH Small
Ticker | $ Holdings | Rank | % Growth | Sector
AGO | 30602752 | 800 | 0 | Financial Services
AIZ | 30086312 | 572 | 0 | Financial Services
XEC | 28021588 | 294 | 1 | Energy
FLO | 27196399 | 988 | 0.3788237093637217 | Consumer Staples
BRY | 26808384 | 816 | 0 | Energy
ENR | 26171965 | 508 | 0 | Consumer Staples
WLL | 24522102 | 340 | 0.05886982615468302 | Energy
STNR | 22479569 | 1646 | 1 | Consumer Discretionary
Spreadsheet: 123069d1317317116-date-based-accrual-formula-adding-time-vacation-sheet-draft
Sheet: TThuy (Intern)

EMPLOYEE NAME | [NAME]
START DATE | 2011-05-01 00:00:00
STATISTICS |  |  | DATE | # of DAYS | REASON | BALANCE
VACATION |  |  |  | 0 | Start Date
SICK |  |  | 2011-06-01 00:00:00 | 0 | [NAME]
PERSONAL |  |  | 2011-07-01 00:00:00 | 0 | [NAME]
DAYS SINCE LAST OUT |  |  | 2011-08-01 00:00:00 | 0 | [NAME]
 |  |  | 2011-09-01 00:00:00 | 0 | [NAME]
 |  |  | 2011-09-28 00:00:00 | 1 | [NAME]
Spreadsheet: 050927b8-d745-4f2d-88bc-f5adf758ae02
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
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 11. Labour force status by Sex - Australian Capital Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184182L | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184199J | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184216X | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184184T | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184201J | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | A184218C | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184187X | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184204R | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184221T | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184194W | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184211L | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184228J | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184193V | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184210K | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184227F | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163537W | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163554X | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163571A | 1978-02-01 00:00:00 | 2010-06-01 00:00:00 | 389 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 126345d1319644648-fluctuating-breakeven-analysis-manufacturing-absorption-values-forums-version
Sheet: Sheet1

 |  |  | Analysis of Actual CCR prices and CCBCC Costs for Q4 2011 & Q1 2012
 |  | Q4 2011 COGS |  |  |  |  | Q1 2012 COGS |  |  |  |  | Q2 2012 COGS
ccbcc-UNDELIVERED cogs | CLT | NAS | ROA | MOB | 2012 INCR | CLT | NAS | ROA | MOB | Q2 INCR | CLT | NAS | ROA | MOB
16oz PET Coca-Cola | 5.38 | 5.49 | 5.31 | 5.61 | 0.3 | 5.68 |  |  |  | 0 |  |  |  |  | Assume that CCBCC costs were calcuated
.5L-6pk [NAME] | 5.66 | 5.72 | 5.53 | 5.89 | 0.3 |  |  |  |  | 0 |  |  |  |  | for the entire year and not just Q1
20oz PET Coca-Cola | 5.98 | 6.01 | 6.03 | 6.12 | 0.37 |  |  |  |  | 0
2 Liter PET Coca-Cola | 5.49 | 5.53 | 5.37 | 5.61 | 0.35 |  |  |  |  | 0
12oz-12pk CAN Coca-Cola | 4.47 | 4.53 | 4.41 | 4.48 | 0.21 |  |  |  |  | 0
12oz-24pk CAN Coca-Cola | 4.5 | 4.53 | 4.45 | 4.51 | 0.21 |  |  |  |  | 0
 |  |  |  |  | Announced |  |  |  |  | Announced
ccr-DELIVERED national cogs |  |  |  |  | Increase |  |  |  |  | 6% pet incr
16oz PET Coca-Cola | 5.89 | 5.89 | 5.89 | 5.89 |  | 6.13 | 6.13 | 6.13 | 6.13 |  |  |  |  |  | CCR has announced Q4 2011 and Q1 2012
.5L-6pk [NAME] | 5.82 | 5.82 | 5.82 | 5.82 |  | 6.06 | 6.06 | 6.06 | 6.06 |  |  |  |  |  | pricing and has also announced a 6%
20oz PET Coca-Cola | 6.13 | 6.13 | 6.13 | 6.13 |  | 6.4 | 6.4 | 6.4 | 6.4 |  |  |  |  |  | increase in PET effective Q2 2012.
2 Liter PET Coca-Cola | 5.6 | 5.6 | 5.6 | 5.6 |  | 5.8 | 5.8 | 5.8 | 5.8
12oz-12pk CAN Coca-Cola | 4.44 | 4.44 | 4.44 | 4.44 |  | 4.44 | 4.44 | 4.44 | 4.44 | 0
12oz-24pk CAN Coca-Cola | 4.47 | 4.47 | 4.47 | 4.47 |  | 4.47 | 4.47 | 4.47 | 4.47 | 0
difference left for delivery
16oz PET Coca-Cola
.5L-6pk [NAME]
20oz PET Coca-Cola
2 Liter PET Coca-Cola
12oz-12pk CAN Coca-Cola
12oz-24pk CAN Coca-Cola
ccbcc wtd avg delivery chg
16oz PET Coca-Cola
.5L-6pk [NAME]
20oz PET Coca-Cola
2 Liter PET Coca-Cola
12oz-12pk CAN Coca-Cola
12oz-24pk CAN Coca-Cola
Margin after deliver TO MATCH
16oz PET Coca-Cola
.5L-6pk [NAME]
20oz PET Coca-Cola
2 Liter PET Coca-Cola
12oz-12pk CAN Coca-Cola
12oz-24pk CAN Coca-Cola
Margin if we match HALF | CLT | NAS | ROA | MOB | AVG | CLT | NAS | ROA | MOB | AVG | CLT | NAS | ROA | MOB | AVG
16oz PET Coca-Cola
.5L-6pk [NAME]
20oz PET Coca-Cola
2 Liter PET Coca-Cola
12oz-12pk CAN Coca-Cola
12oz-24pk CAN Coca-Cola
Volume by pkg
16oz PET Coca-Cola
.5L-6pk [NAME]
20oz PET Coca-Cola
2 Liter PET Coca-Cola
12oz-12pk CAN Coca-Cola
12oz-24pk CAN Coca-Cola
net negative margin
16oz PET Coca-Cola
.5L-6pk [NAME]
20oz PET Coca-Cola
2 Liter PET Coca-Cola
12oz-12pk CAN Coca-Cola
12oz-24pk CAN Coca-Cola
total negative margin of mainstream bottlers |  |  |  |  |  | P&L number |  |  |  |  | P&L number |  |  |  |  | P&L number
Absorption value of mainstream bottlers
difference
Other absorption |  | CCR | 8303000
(absorption rate of $.25/cs used |  | United | 1580000
based upon bottler sales cases) |  | SAC bottlers | 1969000
Net value with absorption
Note:  CCR has already advised that PET costs will increase by 6% in Q2 2012.
2012 CCBCC Cost per [NAME] on Oct 10.
Spreadsheet: 0f4ee878-880e-49e4-9e19-a77ee945db15
Sheet: Sheet1

Table 3--Cash feed grain prices, 11/13/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn, No. 2 yellow,  Central IL (dollars per bushel) |  |  | Corn, No. 2 yellow,  Gulf ports, LA  (dollars per bushel) |  |  | Sorghum, No. 2 yellow,  Plainview to [NAME], TX  (dollars per cwt) | Sorghum, No. 2 yellow,  Gulf ports, LA  (dollars per cwt)
 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2011/12 | 2012/13 | 2013/14
Sep | 6.77 | 7.7 | 4.78 | 7.5 | 8.145 | 5.27 | 11.48 | 12.88 | 12.965 | 9.84
Oct | 6.23 | 7.48 | 4.2 | 6.975 | 8.155000000000001 | 5.125 | 10.73 | 12.08 | 13.2 | 9.31
Nov | 6.26 | 7.39 |  | 6.97 | 8.175 |  | 10.96 | 12.44 | 13.095
Dec | 5.96 | 7.23 |  | 6.57 | 7.845 |  | 10.5 | 11.82 | 13.14
Jan | 6.25 | 7.17 |  | 6.935 | 7.699999999999999 |  |  | 12.2 | 13.13
Feb | 6.41 | 7.15 |  | 7.1 | 7.695 |  |  | 12.09 | 13.115
Mar | 6.46 | 7.33 |  | 7.13 | 7.85 |  |  | 12.035 | 13.32
Apr | 6.34 | 6.57 |  | 6.96 | 7.11 |  |  | 11.94 | 12.175
May | 6.27 | 6.83 |  | 6.84 | 7.5025 |  |  |  | 12.415
Jun | 6.3 | 6.94 |  | 6.785 | 7.58
Jul | 7.85 | 6.61 |  | 8.455 | 7.1
Aug | 8.15 | 5.98 |  | 8.435 | 6.065 |  |  | 13.47 | 10.01
Mkt year | 6.604166666666665 | 7.031666666666666 |  | 7.22125 | 7.576874999999998 |  | 10.9175 | 12.32833333333333 | 12.6565
 | Barley, No. 2 feed,  Minneapolis, MN  (dollars per bushel) |  |  | Barley, No. 3 malting,  Minneapolis, MN  (dollars per bushel) |  |  | Oats, No. 2 white heavy,  Minneapolis, MN  (dollars per bushel)
 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2012/13 | 2013/14 | 2011/12 | 2012/13 | 2013/14
Jun | 5.06 | 5.15 | 5.01 | 7.395 | 7.03 | 6.88 | 3.675 | 3.365 | 4.21
Jul | 5.18 | 5.52 | 4.66 | 7.72 | 6.89 | 6.79 | 3.68 | 3.95 | 3.835
Aug | 5.25 | 5.78 | 4.03 | 7.83 | 6.95 | 5.88 | 3.69 | 3.985 | 3.775
Sep | 5.14 | 5.58 | 3.48 | 7.76 | 6.99 | 5.41 | 3.72 | 3.885 | 3.4
Oct | 5.16 | 5.51 | 3.39 | 7.64 | 7.11 | 5.5 | 3.51 | 3.98 | 3.57
Nov | 5.29 | 5.49 |  | 7.6 | 7.23 |  | 3.36 | 3.85
Dec | 5.17 | 5.29 |  | 7.32 | 7.22 |  | 3.3 | 3.94
Jan | 5.24 | 5.08 |  | 7.2 | 7.09 |  | 3.16 | 3.79
Feb | 5.26 | 5.16 |  | 7.07 | 7.04 |  | 3.455 | 4.07
Mar | 5.37 | 5.22 |  | 7.05 | 6.87 |  | 3.475 | 4.26
Apr | 5.18 | 5 |  | 7.03 | 6.51 |  | 3.55 | 4.125
May | 5.21 | 5.04 |  | 7 | 6.7 |  | 3.475 | 3.99
Mkt year | 5.209166666666667 | 5.318333333333333 |  | 7.384583333333333 | 6.969166666666667 |  | 3.504166666666666 | 3.9325
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Simple average of monthly prices for the marketing year. Source: USDA, Agricultural Marketing Service, http://marketnews.usda.gov/portal/lg.
Data run: 11/12/2013
Spreadsheet: 158446d1338246708-is-this-possible-reading-data-exception-tracking-2012
Sheet: Oct by Shift

AUDIT DESCREPANCIES BY SHIFT OCTOBER
 | OCTOBER
AUDIT DESCREPANCIES / EXCEPTIONS | DAY | SWING | GRAVE
Illegible or missing signature/ badge number
Any void not completed properly
Improper Error Corrections
Inconsistent Key Return
Incorrect/ Missing Information/ Totals
Missing Time Stamp/ Manual Date
Paperwork not received in Audit
Compliance Exceptions
Totals
Total Audit Exceptions
Total Compliance Exceptions
THESE ARE THE AUDIT DISCREPANCIES RECEIVED IN OCTOBER!
THE GOAL FOR NOVEMBER IS A 10% REDUCTION. |  |  |  | NOVEMBER GOAL
Spreadsheet: 752280d1634681439-how-to-change-change-formulas-such-that-formula-is-based-on-work-days-rather-than-days-samplesheet1-pcb-
Sheet: Sample

TASK | START | END | DAYS | WORK DAYS | WORK DAYS |  | TASK | START | W.DAYS | END
Main Level |  |  |  | 5 |  |  | Main Level
Task 1 | 2021-10-20 00:00:00 |  | 7 |  |  |  | Task 1 | 2021-10-20 00:00:00 | 5
Task 2 | 2021-10-20 00:00:00 |  | 7 |  |  |  | Task 2 | 2021-10-20 00:00:00 | 5
Sub-Level |  |  |  |  |  |  | Sub-Level
Task 3 |  |  | 2 |  |  |  | Task 3 |  | 2
Task 4 |  |  | 4 |  |  |  | Task 4 |  | 2
Task 5 |  |  | 1 |  |  |  | Task 5 |  | 1
Task 6 |  |  | 2 |  |  |  | Task 6 |  | 2
Task 7 |  |  | 3 |  |  |  | Task 7 |  | 1
Task 8 |  |  | 2 |  |  |  | Task 8 |  | 2
Task 9 |  |  | 1 |  |  |  | Task 9 |  | 1
Task 10 |  |  | 1 |  |  |  | Task 10 |  | 1
Task 11 |  |  | 1 |  |  |  | Task 11 |  | 1
Sub-Level 2 |  |  |  |  |  |  | Sub-Level 2
Task 13 |  |  | 2 |  |  |  | Task 13 |  | 2
Task 14 |  |  | 2 |  |  |  | Task 14 |  | 2
Task 15 |  |  | 4 |  |  |  | Task 15 |  | 2
Sub-Level 3 |  |  |  |  |  |  | Sub-Level 3
Task 16 | 2021-10-18 00:00:00 |  | 19 |  |  |  | Task 16 |  | 15
Task 17 |  |  | 8 |  |  |  | Task 17 |  | 6
Task 18 |  |  | 9 |  |  |  | Task 18 |  | 7
Sub-Level 4 |  |  |  |  |  |  | Sub-Level 4
Task 19 |  |  | 14 |  |  |  | Task 19 |  | 10
Task 20 |  |  | 14 |  |  |  | Task 20 |  | 10
Task 21 |  |  | 14 |  |  |  | Task 21 |  | 10
Sub-Level 5 |  |  |  |  |  |  | Sub-Level 5
Task 22 |  |  | 5 |  |  |  | Task 22 |  | 4
Task 23 |  |  | 1 |  |  |  | Task 23 |  | 1
Task 24 |  |  | 22 |  |  |  | Task 24 |  | 16
Spreadsheet: 784714d1655917212-count-cells-with-text-it-needs-data-test
Sheet: Breakdown by Weeks

Select System | All Equipment
Site |  | 2021-11-29 00:00:00 | 2021-12-13 00:00:00
PBS-C
PBS-K
SO
Spreadsheet: 845460d1696965926-calculating-total-sum-of-item-within-a-date-range-gites
Sheet: Reservations

Client | Reservation ID | Direct ou Booking | Date d'arriver | Date de départ | Gite No. | Duration | Prix par jour | Prix de Séjour | No. Adultes | No. D'enfants | Ménage | Serviettes | Taux de Taxe | Totale Tax | Total Prix | Acompte 1 | Méthod | Acompte 2 | Méthod | [NAME] | A Payé | Payé? |  |  |  |  |  |  |  |  | SPILL Zone for available rooms
1 [NAME] | 1 | Direct | 2024-01-01 00:00:00 | 2024-03-30 00:00:00 | 10 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 11
2 Bruce Springsteen | 1 | Direct | 2024-01-01 00:00:00 | 2024-03-30 00:00:00 | 12 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 11
3 Mick Jagger | 1 | Direct | 2024-04-26 00:00:00 | 2024-05-02 00:00:00 | 10 |  |  |  | 2 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
3 Mick Jagger | 2 | Direct | 2024-04-26 00:00:00 | 2024-05-02 00:00:00 | 11 |  |  |  | 2 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
3 Mick Jagger | 3 | Direct | 2024-04-26 00:00:00 | 2024-05-02 00:00:00 | 12 |  |  |  | 2 | 1 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
4 Régis Legoff | 1 | Direct | 2024-05-16 00:00:00 | 2024-05-20 00:00:00 | 12 |  |  |  | 2 |  | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
5 [NAME] | 1 | Direct | 2024-05-03 00:00:00 | 2024-05-11 00:00:00 | 2 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
7 [NAME] | 1 | Direct | 2024-05-03 00:00:00 | 2024-05-11 00:00:00 | 12 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Spreadsheet: 766895d1644153472-drag-a-formula-across-365-columns-skipping-1-row-every-3-columns-dragged-test10-3-
Sheet: TAB1

Hour | Day | Night | Hour | Day | Night | Hour | Day | Night | Hour | Day | Night | Hour | Day | Night | Hour | Day | Night | Hour | Day | Night | Hour | Day | Night | Hour | Day | Night
07:00:00 | S8 | 2 | 07:00:00 | 3 | 4 | 07:00:00 | 5 | 6 | 07:00:00 | S11 | 2 | 07:00:00 | 3 | 4 | 07:00:00 | 5 | 6 | 07:00:00 | C | 2 | 07:00:00 | 3 | 4 | 07:00:00 | 5 | 6
08:00:00 | 1 | 3 | 08:00:00 | 3 | 4 | 08:00:00 | 5 | 6 | 08:00:00 | 2 | 3 | 08:00:00 | 3 | 4 | 08:00:00 | 5 | 6 | 08:00:00 | C | 3 | 08:00:00 | 3 | 4 | 08:00:00 | 5 | 6
09:00:00 | 2 | 1 | 09:00:00 | 3 | 4 | 09:00:00 | 5 | 6 | 09:00:00 | 3 | 4 | 09:00:00 | 3 | 4 | 09:00:00 | 5 | 6 | 09:00:00 | C | 4 | 09:00:00 | 3 | 4 | 09:00:00 | 5 | 6
10:00:00 | 3 | 5 | 10:00:00 | 3 | 4 | 10:00:00 | 5 | 6 | 10:00:00 | 4 | 5 | 10:00:00 | 3 | 4 | 10:00:00 | 5 | 6 | 10:00:00 | C | 5 | 10:00:00 | 3 | 4 | 10:00:00 | 5 | 6
11:00:00 | 4 | 6 | 11:00:00 | 3 | 4 | 11:00:00 | 5 | 6 | 11:00:00 | 5 | 6 | 11:00:00 | 3 | 4 | 11:00:00 | 5 | 6 | 11:00:00 | C | 6 | 11:00:00 | 3 | 4 | 11:00:00 | 5 | 6
12:00:00 | 5 | 7 | 12:00:00 | 3 | 4 | 12:00:00 | 5 | 6 | 12:00:00 | 6 | 7 | 12:00:00 | 3 | 4 | 12:00:00 | 5 | 6 | 12:00:00 | C | 7 | 12:00:00 | 3 | 4 | 12:00:00 | 5 | 6
13:00:00 | 6 | 8 | 13:00:00 | 3 | 4 | 13:00:00 | 5 | 6 | 13:00:00 | 7 | 8 | 13:00:00 | 3 | 4 | 13:00:00 | 5 | 6 | 13:00:00 | C | 8 | 13:00:00 | 3 | 4 | 13:00:00 | 5 | 6
Spreadsheet: 187855d1350597818-formatting-formula-task-list
Sheet: Settings & Calculations

 | Highlight Settings
 | The tables below store settings and calculations for the Highlight Activities drop down list. Any changes could result in errors or loss of functionality.
 | No Highlight
 | Interval: | Start: | End: | Due:
 | This Week
 | This Month
 | This Quarter
 | This Year
 | Interval:
 | Last Week
 | Last Month
 | Last Quarter
 | Last Year
 | Selected Highlight:
 | Highlight Start
 | Highlight End
 | Status List | Priority List
 | Not Started | Low
 | In Progress | Medium
 | On Track | High
 | At Risk
 | Complete
Spreadsheet: phillip_allen__29968__pallen_1023
Sheet: PGE TP

 | Notional Positions |  |  | Delta Positions
 | Topock | Citygate |  | Topock | Citygate |  | 0.0137 | Topock | Citygate
2001-11-01 00:00:00 |  |  |  |  |  |  |  | 0 | 0
2001-12-01 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-01-01 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-02-01 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-03-01 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
2002-11-01 00:00:00
2002-12-01 00:00:00
Spreadsheet: 8a7d1bfc-3e66-432b-b178-f93309f63264
Sheet: Sheet1

Table S1. Appendix One: Characteristics of the sample | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Age | Number | %
18-44 | 557 | 13
45-54 | 676 | 15.78
55-64 | 1165 | 27.19
65-74 | 1212 | 28.29
75+ | 674 | 15.73
Gender
Male | 2227 | 51.98
Female | 2057 | 48.02
Ethnicity |  |  | Mean Age (years)
White British | 1360 | 38.59 | 62.05809
Black Caribbean | 813 | 23.07 | 64.78229
Black African | 365 | 10.36 | 56.22466
Indian | 464 | 13.17 | 59.44181
Pakistani | 296 | 8.4 | 58.12162
[NAME] | 60 | 1.7 | 56.7
White Irish | 166 | 4.71 | 59.04342