tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 136129d1326418088-only-copy-cell-contents-with-a-date-format-dummy-file
Sheet: Quicken Data

Itemized Categories
1/1/2011 through 12/21/2011 (Cash Basis)
 | Date | Description | Memo | Tag | Amount
 | EXPENSES |  |  |  | -127.95
 | Business Reimbursables |  |  |  | -127.95
 | 2011-10-23 00:00:00 | Enterprise Car Tolls |  |  | -8
 | Business Reimbursables:Dining |  |  |  | -6.47
 | 2011-10-31 00:00:00 | Chipotle | Had dinner to discuss future employment | [NAME] | -6.47
 | Business Reimbursables:Entertainment |  |  |  | -9
 | 2011-11-14 00:00:00 | Grooveshark |  |  | -9
 | Business Reimbursables:Hotel |  |  |  | -28.98
 | 2011-10-14 00:00:00 | [NAME] Ambassador | Overnight stay in Puerto Rico |  | -28.98
 | Business Reimbursables:Insurance |  |  |  | -75.5
 | 2011-11-15 00:00:00 | Primerica Life Ins |  |  | -75.5
 | OVERALL TOTAL |  |  |  | -127.95
Spreadsheet: 839422d1691968140-full-month-tracking-book1
Sheet: Sheet1

 |  |  | BATCH | DUE | DELIVERY | DAY | STATUS | BOX-W | AGG BOXES | NAME
 |  |  | 1 | 2023-08-15 00:00:00 | 2023-08-15 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-08-15 00:00:00 | 2023-08-17 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-08-22 00:00:00 | 2023-08-22 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-08-22 00:00:00 | 2023-08-24 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-08-29 00:00:00 | 2023-08-29 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-08-29 00:00:00 | 2023-08-31 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-05 00:00:00 | 2023-09-05 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-05 00:00:00 | 2023-09-07 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-12 00:00:00 | 2023-09-12 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-12 00:00:00 | 2023-09-14 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-19 00:00:00 | 2023-09-19 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-19 00:00:00 | 2023-09-21 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-26 00:00:00 | 2023-09-26 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 10 | 2023-09-26 00:00:00 | 2023-09-28 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-03 00:00:00 | 2023-10-03 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-03 00:00:00 | 2023-10-05 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-10 00:00:00 | 2023-10-12 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-17 00:00:00 | 2023-10-17 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-17 00:00:00 | 2023-10-19 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-24 00:00:00 | 2023-10-24 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-24 00:00:00 | 2023-10-26 00:00:00 | Thursday |  | 7 |  | EUROPA1989
 |  |  | 1 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | Tuesday |  | 7 |  | EUROPA1989
Spreadsheet: 2128d001-83e4-4dcb-88d0-1a337a0ecf0c
Sheet: 5. Outdoor Water Supply

NON-POTABLE WATER CALCULATOR
Step 5 of 7: Calculate Outdoor Water Supply (Rainwater and Stormwater Harvesting)
 | Project Name: |  |  |  | LEGEND:
 |  |  |  |  | [NAME]
 |  |  |  |  | Linked from User Input
 | Instructions: |  |  |  | Default Value
 | Annual outdoor water supply is calculated based on the amount of [NAME] captured. User input is required in Sections A and B. |  |  |  | Autogenerated Value
 | A. RAINWATER SUPPLY (Runoff harvested above grade, e.g. rooftops)
 | User Input Instructions:
 | Default Rainwater Supply coefficients are entered below; refine default coefficients as appropriate
 |  |  | ft2
 | Roof Runoff Coefficient | 0.85 | [[NAME] as appropriate] Conventional roof runoff coefficient = 0.85
 |  |  | ft2
 | Runoff Coefficient | 0.7 | [[NAME] as appropriate]
 | Total Above Grade Capture Area |  | ft2
 | Average Runoff Coefficient
 | Rainfall Capture Factor | 0.8 | [[NAME] as appropriate]
 | Month | Ave. Monthly Rainfall | Days in Month | Total [NAME] (with Rainfall Capture Factor Applied)
 |  | in/mth |  | gal/month | gpd
 | January |  | 31
 | February |  | 28
 | March |  | 31
 | April |  | 30
 | May |  | 31
 | June |  | 30
 | July |  | 31
 | August |  | 31
 | September |  | 30
 | October |  | 31
 | November |  | 30
 | December |  | 31
 | TOTAL
 | TOTAL RAINWATER SUPPLY |  | [NAME]
 | B. STORMWATER SUPPLY (Runoff harvested at or below grade, e.g. paved plazas, sidewalks or roads)
 | User Input Instructions:
 | Default Stormwater Supply coefficients are entered below; refine default coefficients as appropriate
 |  |  | ft2
 | Runoff Coefficient | 0.9 | [[NAME] as appropriate] Typical impervious surface runoff coefficient = 0.90
 |  |  | ft2
 | Runoff Coefficient | 0.8 | [[NAME] as appropriate]
 |  |  | ft2
 | Runoff Coefficient | 0.7 | [[NAME] as appropriate]
 | Total At or Below Grade Capture Area |  | ft2
 | Average Runoff Coefficient
 | Rainfall Capture Factor | 0.8 | [[NAME] as appropriate]
 | Month | Ave. Monthly Rainfall | Days in Month | Total Stormwater Supply (with Rainfall Capture Factor Applied)
 |  | in/mth |  | gal/month | gpd
 | January |  | 31
 | February |  | 28
 | March |  | 31
 | April |  | 30
 | May |  | 31
 | June |  | 30
 | July |  | 31
 | August |  | 31
 | September |  | 30
 | October |  | 31
 | November |  | 30
 | December |  | 31
 | TOTAL
 | TOTAL STORMWATER SUPPLY |  | [NAME]
 | >>> Please proceed on to Step 6: Summary of Building Potential
Spreadsheet: 151148d1334803961-excel-2007-cell-designation-in-formula-changes-after-sort-is-there-a-better-way-hrderby2012-picksheet
Sheet: PickSheet

 | [NAME] | Curtis [NAME] | [NAME] | [NAME] | Prince Fielder | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Adrian nBeltre | [NAME] | Jacoby Ellsbury | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Justin Upton | [NAME] | JJ Hardy | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Asdrubal Cabrera | [NAME] | [NAME] | [NAME] | [NAME] | JP Arencibia | Pablo Sandoval | [NAME] | [NAME] | [NAME] | [NAME] | Tori [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Hunter Pence | [NAME] | [NAME] | [NAME] | Dustin Pedroia | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Group 1 Total | Group 2 Total | Group 3 Total | Group 4 Total | Combined Total
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G2 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G3 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | G4 | [NAME] | G2 | G3 | G4 | All
Home Runs | 1 | 2 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 3 | 0 | 4 | 0 | 0 | 1 | 0 | 0 | 1 | 2 | 0 | 3 | 1 | 4 | 0 | 1 | 1 | 0 | 3 | 1 | 2 | 0 | 4 | 0 | 0 | 0 | 2 | 2 | 1 | 2 | 0 | 1 | 2 | 0 | 2 | 0 | 1 | 0 | 0 | 3 | 2 | 2 | 1 | 1 | 0 | 2 | 1 | 0 | 2 | 3 | 1 | 0 | 1 | 1 | 0
Woj
[NAME]
[NAME]
[NAME]
NickAraujo
[NAME]
Slater54
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Nooch-1
[NAME]
Heavy D
[NAME]
[NAME]
Ricky-1
Ricky-2
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Dom Burandt
[NAME]
[NAME]
[NAME]
Papa Woody
[NAME]
[NAME]
[NAME]
[NAME]
Bob P
Floods
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
J-Mac& Keith
Spreadsheet: 173771d1344725325-conditional-format-or-advance-filter-pt-for-allide
Sheet: Sheet1

Date | Client | DOB | [NAME] |  |  | [NAME] | [NAME]
 | [NAME] | 1980-11-08 00:00:00 | [NAME]
 | [NAME] | 1979-02-11 00:00:00 | [NAME] |  |  | Client
 | [NAME] | 1980-03-20 00:00:00 | [NAME] |  |  | [NAME]
 | Kathy | 1978-04-04 00:00:00 | [NAME] |  |  | 2012-08-11 00:00:00
 | [NAME] | 1985-01-19 00:00:00 | [NAME] |  |  | [NAME]
 |  |  |  |  |  | 2012-08-11 00:00:00
 |  |  |  |  |  | Grand Total
Spreadsheet: 187956d1350641196-lookup-function-for-many-cells-dummy
Sheet: Samenvatting

Category | Item | Priority | Occurrences | Soort melding | Translation | Comments | Probleem | okt 09 | nov 09 | dec 09 | jan 10 | feb 10 | mrt 10 | apr, 10 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00
Interface | 1 |  | 153 | Interface niet of niet op tijd gelopen | Interface did not run or was not on time | Has to be solved in the xxxxx system, being handled by a separate project / move to PMD in the future. | zie overzicht [NAME] | 1,2,3,4,5 | 26,27,28,29,30,34,40 | 46,48,50,53 | 54,56,57,59,62,63,64,67 | 84 | 98,100,101,102,104,105,106,107,108,114,115,116,117,118 | 121,122,124,129,130,131,136,139 | 144,145,147 | 151,155,158,159,161,162,164,165,166,167,168,169,170 | 172,174,176,178,180,181,182,183,184 | 186,191,197,198 | 199, 200, | 233,234,235,236,237,238 | 240,241,242,245,246 | 256258 |  | 270 | 276,277,278 | 284286 | 293,294,295,298,302 | 303,304,305,306 | 307308 | 309,310,311,312 | 320 | 323,324,325 | 327,328,329 | 330335 | 336337 | 343 | 351353 | 354,355,357,358 | 369,370,373 | 375,380,381,382,383,384 | 385,386,387,388,389,390,391,392 | 393,394,395,397,398,399
 | 2 |  | 1 | IOP volgnummer bestand incidentele looncomponenten hoogt niet op. |  |  | IOP |  |  |  |  |  |  |  |  |  |  |  | 211
 | 3 |  | 2 | Studieuren worden niet vanuit GT&E in EMIS aangeleverd. |  |  | Interface vanuit GT&E |  |  |  |  |  |  |  |  |  |  |  |  |  | 247249
 | 4 |  | 1 | Nieuw looncomponent wordt niet naar EMIS gestuurd |  |  | LHRS |  |  |  |  |  |  |  |  |  |  |  |  | 227
Spreadsheet: 836120d1689102258-shortened-days-of-the-week-formula-to-follow-days-on-rota-template
Sheet: Rota

 | Care at Home Services - Timesheets by Service User
 | Start | End | Duration |  | Service Type |  | Employee
 | Mon - | 2023-07-10 00:00:00
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 19:00:00 | 19:15:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 19:00:00 | 19:15:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 19:15:00 | 19:30:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 19:00:00 | 19:15:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 19:15:00 | 19:30:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 19:00:00 | 19:15:00 |  |  | EC Personal Care - Evening Visit
 | 21:45:00 | 22:00:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 18:45:00 | 19:00:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 18:45:00 | 19:00:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
 | 07:15:00 | 07:30:00 |  |  | EC Personal Care - AM Visit
 | 18:45:00 | 19:00:00 |  |  | EC Personal Care - Evening Visit
 | 22:15:00 | 22:30:00 |  |  | EC Personal Care - Night Visit
Spreadsheet: 845966d1697249293-split-alphanumeric-data-into-individual-cells-copy-of-excel-2010-transpose-letter-or-numbers
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | helper cell below
[NAME] The 2nd
Spreadsheet: 273151d1382624979-range-of-cells-defined-by-other-cells-for-maximum-minimum-average-and-standard-deviation-rangeofcells20131024
Sheet: Sheet1

Distance Start | Distance End | Height |  | Section Start | SectionEnd
0 | 0.001 | 40.1 |  | 0 | 0.02
0.001 | 0.002 | 28.5 |  | 0.02 | 0.04
0.002 | 0.003 | 21.2 |  | 0.04 | 0.06
0.003 | 0.004 | 12.2
0.004 | 0.005 | 9.2
0.005 | 0.006 | 10 |  |  |  |  |  | I would like to find the minimum, maximum, average and standard deviation for a range of cells, however the range of cells in the formula would be defined by other cells. If you look at the attached spreadsheet, I would like to find the maximum height that lies between each Section Start and Section End. I would like to formula to look at the cell E2 (0.000) and cell F2 (0.020) . The formula would then look at all the  Heights (column C) which lie between the corresponding Distance Start and Distance End, ie: in this case the formula would find the maximum value for C2:C21, because these heights lie between the Section Start and Section End defined in E2 and F2. I would like to do the same thing with minimum, average and standard deviation.
0.006 | 0.007 | 11.1
0.007 | 0.008 | 9.6
0.008 | 0.009 | 4.6
0.009 | 0.01 | 1.8
0.01 | 0.011 | 2.2
0.011 | 0.012 | 3.1
0.012 | 0.013 | 2.7
0.013 | 0.014 | 3.2
0.014 | 0.015 | 2.6
0.015 | 0.016 | 2.4
0.016 | 0.017 | 3.1
0.017 | 0.018 | 30.6
0.018 | 0.019 | 40
0.019 | 0.02 | 37.8
0.02 | 0.021 | 17.2
0.021 | 0.022 | 3.2
0.022 | 0.023 | 4.5
0.023 | 0.024 | 3.5
0.024 | 0.025 | 2.7
0.025 | 0.026 | 1.7
0.026 | 0.027 | 2.7
0.027 | 0.028 | 2.3
0.028 | 0.029 | 2
0.029 | 0.03 | 1.4
0.03 | 0.031 | 1.3
0.031 | 0.032 | 2
0.032 | 0.033 | 3.3
0.033 | 0.034 | 1.8
0.034 | 0.035 | 2
0.035 | 0.036 | 2.5
0.036 | 0.037 | 3
0.037 | 0.038 | 3.2
0.038 | 0.039 | 2.2
0.039 | 0.04 | 1.2
0.04 | 0.041 | 1.5
0.041 | 0.042 | 1.3
0.042 | 0.043 | 1.4
0.043 | 0.044 | 2.4
0.044 | 0.045 | 2.1
0.045 | 0.046 | 2.9
0.046 | 0.047 | 2.5
0.047 | 0.048 | 1.3
0.048 | 0.049 | 1.5
0.049 | 0.05 | 1.7
0.051 | 0.051 | 2.2
0.052 | 0.052 | 2.1
0.053 | 0.053 | 1.6
0.054 | 0.054 | 1.7
0.055 | 0.056 | 2
0.056 | 0.057 | 2.1
0.057 | 0.058 | 1.6
0.058 | 0.059 | 1.8
0.059 | 0.06 | 1.6
0.06 | 0.061 | 2.3
Spreadsheet: 859842d1708081267-convert-irregular-data-to-monthly-power_consumption
Sheet: Analysis

Cost/Month~Quarter |  |  |  |  |  | Cost/kWh
2022-07-01 00:00:00 |  | Q3 |  |  |  | 2022-07-01 00:00:00
2022-08-01 00:00:00 |  |  |  |  |  | 2022-08-01 00:00:00
2022-09-01 00:00:00 |  |  |  |  |  | 2022-09-01 00:00:00
2022-10-01 00:00:00 |  | Q4 |  |  |  | 2022-10-01 00:00:00
2022-11-01 00:00:00 |  |  |  |  |  | 2022-11-01 00:00:00
2022-12-01 00:00:00 |  |  |  |  |  | 2022-12-01 00:00:00
2023-01-01 00:00:00 |  | Q1 |  |  |  | 2023-01-01 00:00:00
2023-02-01 00:00:00 |  |  |  |  |  | 2023-02-01 00:00:00
2023-03-01 00:00:00 |  |  |  |  |  | 2023-03-01 00:00:00
2023-04-01 00:00:00 |  | Q2 |  |  |  | 2023-04-01 00:00:00
2023-05-01 00:00:00 |  |  |  |  |  | 2023-05-01 00:00:00
2023-06-01 00:00:00 |  |  |  |  |  | 2023-06-01 00:00:00
2023-07-01 00:00:00 |  | Q3 |  |  |  | 2023-07-01 00:00:00
2023-08-01 00:00:00 |  |  |  |  |  | 2023-08-01 00:00:00
2023-09-01 00:00:00 |  |  |  |  |  | 2023-09-01 00:00:00
2023-10-01 00:00:00 |  | Q4 |  |  |  | 2023-10-01 00:00:00
2023-11-01 00:00:00 |  |  |  |  |  | 2023-11-01 00:00:00
2023-12-01 00:00:00 |  |  |  |  |  | 2023-12-01 00:00:00
2024-01-01 00:00:00 |  | Q1 |  |  |  | 2024-01-01 00:00:00
2024-02-01 00:00:00 |  |  |  |  |  | 2024-02-01 00:00:00
2024-03-01 00:00:00 |  |  |  |  |  | 2024-03-01 00:00:00
2024-04-01 00:00:00 |  | Q2 |  |  |  | 2024-04-01 00:00:00
2024-05-01 00:00:00 |  |  |  |  |  | 2024-05-01 00:00:00
2024-06-01 00:00:00 |  |  |  |  |  | 2024-06-01 00:00:00
2024-07-01 00:00:00 |  | Q3 |  |  |  | 2024-07-01 00:00:00
2024-08-01 00:00:00 |  |  |  |  |  | 2024-08-01 00:00:00
2024-09-01 00:00:00 |  |  |  |  |  | 2024-09-01 00:00:00
2024-10-01 00:00:00 |  | Q4 |  |  |  | 2024-10-01 00:00:00
2024-11-01 00:00:00 |  |  |  |  |  | 2024-11-01 00:00:00
2024-12-01 00:00:00 |  |  |  |  |  | 2024-12-01 00:00:00
Spreadsheet: 136588d1326733046-excel-2007-sum-excluding-highlighted-red-book1
Sheet: Sheet1

 | Date | Day | Time In | Time Out | Work Duration | Status
 | 2012-01-14 00:00:00 | Sat |  |  |  | Weekend
 | 2012-01-13 00:00:00 | Fri | 13:59:06 | 22:59:59 | 09:00:53 | Present | 09:00:53
 | 2012-01-12 00:00:00 | Thu | 14:49:36 | 23:07:09 | 08:17:33 | Present
 | 2012-01-11 00:00:00 | Wed |  |  | 09:00:00 | Regularized | 09:00:00
 | 2012-01-10 00:00:00 | Tue | 13:56:00 | 23:03:00 | 09:07:00 | Present | 09:07:00
 | 2012-01-09 00:00:00 | Mon | 14:12:54 | 23:03:06 | 08:50:12 | Present
 | 2012-01-06 00:00:00 | Fri | 14:02:06 | 23:02:42 | 09:00:36 | Present | 09:00:36
 | 2012-01-05 00:00:00 | Thu | 14:00:41 | 23:00:59 | 09:00:18 | Present | 09:00:18
 | 2012-01-04 00:00:00 | Wed | 13:58:39 | 23:01:23 | 09:02:44 | Present | 09:02:44
 | 2012-01-03 00:00:00 | Tue | 14:35:53 | 23:01:21 | 08:25:28 | Present
 | 2012-01-02 00:00:00 | Mon |  |  | 09:00:00 | Regularized | 09:00:00
 | 2011-12-30 00:00:00 | Fri | 13:10:57 | 22:21:39 | 09:10:42 | Present | 09:10:42
 | 2011-12-29 00:00:00 | Thu | 13:23:33 | 22:59:59 | 09:36:26 | Present | 09:36:26
 | 2011-12-28 00:00:00 | Wed | 13:55:54 | 23:00:59 | 09:05:05 | Present | 09:05:05
 | 2011-12-27 00:00:00 | Tue |  |  | 09:00:00 | Regularized | 09:00:00
 | 2011-12-26 00:00:00 | Mon |  |  | 09:00:00 | Regularized | 09:00:00
 | 2011-12-23 00:00:00 | Fri | 13:58:48 | 23:00:01 | 09:01:13 | Present | 09:01:13
 | 2011-12-22 00:00:00 | Thu | 13:59:12 | 23:00:43 | 09:01:31 | Present | 09:01:31
 | 2011-12-21 00:00:00 | Wed | 13:55:32 | 23:02:10 | 09:06:38 | Present | 09:06:38
 | 2011-12-20 00:00:00 | Tue | 13:49:43 | 23:00:59 | 09:11:16 | Present | 09:11:16
 | 2011-12-19 00:00:00 | Mon | 13:59:46 | 23:01:13 | 09:01:27 | Present | 09:01:27
 | 2011-12-16 00:00:00 | Fri | 13:50:46 | 23:01:19 | 09:10:33 | Present | 09:10:33
 | 2011-12-15 00:00:00 | Thu | 13:35:07 | 23:01:02 | 09:25:55 | Present | 09:25:55
 | 2011-12-14 00:00:00 | Wed | 13:56:02 | 23:01:50 | 09:05:48 | Present | 09:05:48
Spreadsheet: 68450d1268985583-data-selection-issues-fa-test-1
Sheet: Input- 2010

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Line Item
 | Line Item |  |  |  | Opening | Closing
 | Inventory
 | Total assets
 | Owners' equity
 | Number of common shares
 | Line Item |  |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Annual 10 | Q1 2009 | Q2 2009 | Q3 2009 | Q4 2009 |  | Sel 1
 | Current assets |  |  |  | 911000 | 752715.3772899999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 452887.0576266666 | 0 | 0 | 0
 | Fixed assets |  |  |  | 211110 | 565641.3465500001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 378053.6608700001 | 0 | 0 | 0
 | Total assets |  |  |  | 1174465.43165 | 1318356.72384 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 830940.7184966668 | 0 | 0 | 0
 | Average total assets
 | Current Liabilities |  |  |  | 608755.859160001 | 595161.3744199999
Spreadsheet: 845375d1696913942-drop-down-lists-connected-to-a-table-risk-assessment-test
Sheet: RISK MATRIX

 |  |  | RISK MATRIX
 |  |  | CONSEQUENCE
LIKELIHOOD |  |  | 1 | 2 | 3 | 4 | 5
 |  | Choose an Item | INSIGNIFICANT | MINOR | MODERATE | MAJOR | CATASTROPHIC
 | Choose an Item
5 | ALMOST CERTAIN |  | LOW | LOW | MODERATE | EXTREME | EXTREME
4 | LIKELY |  | LOW | LOW | MODERATE | HIGH | EXTREME
3 | POSSIBLE |  | LOW | LOW | MODERATE | HIGH | HIGH
2 | UNLIKELY |  | LOW | LOW | LOW | MODERATE | HIGH
1 | RARE |  | LOW | LOW | LOW | MODERATE | HIGH
Spreadsheet: 37611d1235658912-create-list-w-2-or-more-same-subject-header-for-sort-matchlist
Sheet: Sheet1

Column1 | ITEMS | Column2 | Column3 | Column4 | REDS | Column5 | Column6 | Column7 | [NAME] | Column8 | Column9 | WHITE | Column10 | WHITE11 | Column12 | Column13 | Column14 | FLAG | Column15 | BLUES | Column16 | Column17 | BLUES18 |  |  |  | FLAG |  |  | GREENS |  |  | GREENS |  |  |  | FLAG |  | YELLOW |  |  | YELLOW |  |  |  | FLAG |  |  |  |  | ORANGES |  |  |  | FLAG
balloons | HeliumFilled |  |  |  | 50 |  |  |  | 1 |  |  | flowers |  | 80 |  |  |  | 6 | ice cream | RockRoad |  |  | 22 |  |  |  | 3 | plates |  | dinner plates |  |  | 32 |  |  |  | 2 | Cookies | Chocolate cookies |  |  | 5 |  |  |  | 4 |  |  |  |  | music |  |  |  | 7
plates | BirthdayPlates |  |  |  | 20 |  |  |  | 2 |  |  | music |  | 155 |  |  |  | 7 | cookies | peanutbutter |  |  | 10 |  |  |  | 4 | music |  | Country music |  |  | 275 |  |  |  | 7 | Balloons | Latex balloons |  |  | 25 |  |  |  | 1 |  |  |  |  | ice cream |  |  |  | 3
ice cream | CookiesNCream |  |  |  | 15 |  |  |  | 3 |  |  | balloons |  | 45 |  |  |  | 1 | balloons | LargeRED |  |  | 60 |  |  |  | 1 | flowers |  | [NAME]'s flowers |  |  | 125 |  |  |  | 6 | Plates | Plastic plates |  |  | 21 |  |  |  | 2 |  |  |  |  | balloons |  |  |  | 1
cookies | Chewy |  |  |  | 8 |  |  |  | 4 |  |  | plates |  | 25 |  |  |  | 2 | drinks | beer |  |  | 15 |  |  |  | 5 | drinks |  | Soda |  |  | 12 |  |  |  | 5 | IceCream | Vanilla ice cream |  |  | 8 |  |  |  | 3 |  |  |  |  | flowers |  |  |  | 6
Drinks | Gateraide |  |  |  | 8 |  |  |  | 5 |  |  | ice cream |  | 18 |  |  |  | 3 | plates | paper plates |  |  | 45 |  |  |  | 2 | cookies |  | OREOS |  |  | 8 |  |  |  | 4 | Drinks | punch |  |  | 6 |  |  |  | 5 |  |  |  |  | punch |  |  |  | 5
flowers | Carnation |  |  |  | 75 |  |  |  | 6 |  |  | cookies |  | 5 |  |  |  | 4 | flowers | sunflowers |  |  | 200 |  |  |  | 6 | ice cream |  | [NAME] |  |  | 16 |  |  |  | 3 | Flowers | Roses flowers |  |  | 30 |  |  |  | 6 |  |  |  |  | cookies |  |  |  | 4
music | Hard Rock |  |  |  | 200 |  |  |  | 7 |  |  | punch |  | 10 |  |  |  | 5 | music | Easy Listening music |  |  | 450 |  |  |  | 7 | balloons |  | Party balloons |  |  | 45 |  |  |  | 1 | Music | Rock music |  |  | 65 |  |  |  | 7 |  |  |  |  | plates |  |  |  | 2
Spreadsheet: 858669d1707279393-wta-how-to-only-capture-date-within-month-only-testing-date
Sheet: Summary

Period | 2024-01-01 00:00:00
Date | Day | AAs received | AAs cleared | AAs carried forward | Workforce | Average productivity | Daily Utilization |  |  | public holiday
 |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | New Year
 |  | 2024-01-03 00:00:00 |  |  |  |  |  |  |  | 2024-01-25 00:00:00 | [NAME]
 |  | 2024-01-04 00:00:00 |  |  |  |  |  |  |  | 2024-02-01 00:00:00 | Feb
 |  | 2024-01-05 00:00:00 |  |  |  |  |  |  |  | 2024-02-12 00:00:00 | Feb
 |  | 2024-01-08 00:00:00 |  |  |  |  |  |  |  | 2024-03-28 00:00:00 | Feb
 |  | 2024-01-09 00:00:00
 |  | 2024-01-10 00:00:00
 |  | 2024-01-11 00:00:00
 |  | 2024-01-12 00:00:00
 |  | 2024-01-15 00:00:00
 |  | 2024-01-16 00:00:00
 |  | 2024-01-17 00:00:00
 |  | 2024-01-18 00:00:00
 |  | 2024-01-19 00:00:00
 |  | 2024-01-22 00:00:00
 |  | 2024-01-23 00:00:00
 |  | 2024-01-24 00:00:00
 |  | 2024-01-26 00:00:00
 |  | 2024-01-29 00:00:00
 |  | 2024-01-30 00:00:00
 |  | 2024-01-31 00:00:00