tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0104

01/04/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 2 | 15 |  |  |  |  | 126 | 1.5 | board work | 5.75 | 21.91304347826087
 | Dustin | 1 | 12 | 3 |  |  |  |  | 62 | 2.5 | trending/cap/2pgr | 3.5 | 17.71428571428572
 | Sharron | 21 | 5 | 15 |  |  |  |  | 177 |  |  | 9.5 | 18.63157894736842
 | Roxy | 9 | 6 | 9 |  |  |  |  | 108 |  |  | 8.25 | 13.09090909090909
 | [NAME] |  |  |  |  | 3 | 14 | 2 | 134 |  |  | 8 | 16.75
 | Ana |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] | 7 | 8 | 15 |  |  |  |  | 158 | 0.5 | CISS | 8.25 | 19.15151515151515
 | Petra |  |  |  |  |  | 8 | 3 | 88 | 4.5 | [NAME] | 6.25 | 14.08
 | Regina |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Noy | 3 |  | 3 |  | 1 | 7 | 7 | 144 |  |  | 7.5 | 19.2
 | [NAME] |  |  |  |  | 15 | 13 |  | 134 | 1 | 2pgr/KO | 8.5 | 15.76470588235294
 | [NAME] | 28 | 9 |  |  |  |  |  | 83 |  | SME | 4.75 | 17.47368421052632
 | Michelle | 18 |  |  |  |  |  |  | 36 |  | SME | 2 | 18
 | Keisha |  | 8 | 3 |  |  |  |  | 48 |  |  | 7.75 | 6.193548387096774
 | [NAME] |  | 17 |  |  |  |  |  | 51 |  |  | 5.25 | 9.714285714285714
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 199.9632708623153
 | TASK VOLUME: | 87 | 67 | 63 | 0 | 19 | 42 | 12 | 1349 | 10 |  | 85.27 | 15.82033540518353
 | Pts Earned: | 174 | 201 | 504 | 0 | 38 | 336 | 96
 |  |  |  |  |  |  |  | Average PTS | 89.93466666666667 |  | Total Task Volume |  | 290
 | MID-DAY PPH  16.26
Spreadsheet: 756828d1637820415-formula-based-from-table-matrix-reference-9
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Low | Medium | High | Critical
 |  |  |  |  |  |  |  |  |  | Critical | Medium | High | Critical | Critical
 |  |  |  |  |  |  |  |  |  | High | Low | Medium | High | Critical
 |  |  |  |  |  |  |  |  |  | Medium | Low | Medium | Medium | High
 |  |  |  |  |  |  |  |  |  | Low | Low | Low | Low | Medium
RRR | PRP | Result
Low | Critical
Medium | Critical
High | Critical
Critical | Critical
Low | High
Medium | High
High | High
Critical | High
Low | Medium
Medium | Medium
High | Medium
Critical | Medium
Low | Low
Medium | Low
High | Low
Critical | Low
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: IT All

 | Information Technology
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 49200
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 57600 | 2
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 2
ENATRANS | Transportation |  |  |  |  |  |  |  | Specialist | 78000 | 29
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 60
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Tech | 192000 | 7
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | IT Consultants | 192000
 |  |  |  |  |  |  |  |  | Manager | 144000 | 16
 | Headcount |  |  | 111 | 40 | 199 |  |  | Director | 168000 | 11
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 8
 | A&A Headcount |  |  |  |  |  |  |  | VP | 222000 | 1
 |  |  |  |  |  |  |  |  | MD | 300000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  | 0 |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  |  | Consultants | 160000 | 0
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure |  |  | 0
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 0 |  |  |  | Based on information from ENW accounting.
 | `
Spreadsheet: 178981d1346972592-sum-cells-for-different-customers-different-spreadsheets-example
Sheet: Sheet2

OVERDUE | 10 days | 20 days | 30 days | 40 days
Customer22 | 124
Customer23 | 6346 | 436
Customer5 |  |  | 436
Customer10 | 346 | 346
Customer45 |  |  | 5676
Customer7 |  | 76575
Customer13 |  |  | 658
Customer11 |  | 568 | 1123
Spreadsheet: 816422d1675615025-find-values-in-each-year-s666-pq-find-values-in-each-year
Sheet: Blad1

Date | type | qty | value |  |  |  | Result |  | 2022 | value | 2023 | value | 2024 | value
2022-04-02 00:00:00 | [NAME] | 1 | 10 |  |  |  | to be shown | [NAME] | 1 | 10 | 4 | 40 | 0 | 0
2022-04-12 00:00:00 | beta | 2 | 20 |  |  |  |  | beta | 2 | 20 | 3 | 30 | 0 | 0
2023-02-01 00:00:00 | beta | 3 | 30 |  |  |  |  | delta | 0 | 0 | 5 | 50 | 0 | 0
2023-02-04 00:00:00 | alfa | 4 | 40 |  |  |  |  | Total
2023-02-05 00:00:00 | delta | 5 | 50
 |  |  |  |  |  |  |  | type | 2022.1 | 2022.2 | 2023.1 | 2023.2
 |  |  |  |  |  |  |  | [NAME] | 1 | 10 | 4 | 40
 |  |  |  |  |  |  |  | Beta | 2 | 20 | 3 | 30
 |  |  |  |  |  |  |  | Delta |  |  | 5 | 50
 |  |  |  |  |  |  |  | Total
Spreadsheet: 880702d1728554967-pensions-with-different-scenarios-what-if-super-calculator
Sheet: Sheet1

Balance | 500000
 | Return rate | 0.04
 | Years
 | 5
 | 10
 | 15
 | 20
 | 25
 | 30
 | Return rate | 0.06 |  | Year | 15
 | Year | Balance b/f | Interest | Pension | Balance c/f
 | 1
 | Total
Spreadsheet: 848833d1699460991-generating-excel-rows-based-on-a-selected-value-data
Sheet: data

Data | Field 1 | Field 2 | Field 3
2023-02-01 00:00:00 | A | Lamp | 1002
2023-05-10 00:00:00 | C | Lamp2 | 1005
2023-05-10 00:00:00 | D | Lamp3 | 1006
2023-05-12 00:00:00 | S | Lamp10 | 1009
2023-06-06 00:00:00 | H | Lamp3 | 1010
2023-07-07 00:00:00 | Y | Lamp10 | 1010
2023-08-15 00:00:00 | G | Lamp5 | 1008
2023-09-16 00:00:00 | D | Lamp6 | 1007
2023-09-16 00:00:00 | C | Lamp8 | 1006
2023-10-12 00:00:00 | V | Lamp20 | 1005
2023-10-15 00:00:00 | N | Lamp0 | 1004
Select data:
Data | Field 1 | Field 2 | Field 3
Spreadsheet: 84331d1284390510-text-to-dates-sample
Sheet: Sheet1

Company 6-Digit CUSIP | Round Dates
587587 | 1989-01-06 00:00:00
587587 | 1991-01-04 00:00:00
587587 | 1992-01-01 00:00:00
587587 | 1992-01-06 00:00:00
587587 | 1993-01-07 00:00:00
587587 | 15/05/1997
556466 | 1987-01-04 00:00:00
556466 | 1990-01-01 00:00:00
556466 | 1991-01-04 00:00:00
556466 | 1993-01-01 00:00:00
556466 | 1993-01-04 00:00:00
556466 | 1994-01-01 00:00:00
556466 | 31/12/1998
556466 | 2003-08-08 00:00:00
556466 | 25/12/2005
556466 | 15/02/2006
556466 | 2006-02-08 00:00:00
556466 | 14/03/2007
556466 | 28/03/2008
556466 | 23/06/2009
556466 | 16/06/2010
847246 | 1986-01-08 00:00:00
847246 | 1989-01-06 00:00:00
847246 | 1991-01-04 00:00:00
847246 | 1992-01-04 00:00:00
847246 | 1993-01-04 00:00:00
847246 | 18/02/2000
46117A | 1989-01-10 00:00:00
46117A | 30/01/1990
46117A | 1990-05-10 00:00:00
46117A | 22/02/1991
46117A | 20/02/1992
46117A | 1993-01-04 00:00:00
46117A | 25/01/1995
46117A | 1996-05-03 00:00:00
46117A | 1997-01-10 00:00:00
46117A | 2005-01-05 00:00:00
Spreadsheet: 830741d1685067486-create-countifs-on-filtered-data-using-data-validation-staff-work-allocations-2023-for-forum-copy
Sheet: Sheet1

AUTOCLAVE | A
BOOKING ON | B
PORTERING | P
Supps | S |  | Month | January |  |  |  |  |  |  | January | 31
WASH | W |  | Technician | Cee |  |  |  |  |  |  | February | 28
WASH EMPTY | E |  | Code | R |  |  |  |  |  |  | March | 31
WRAPPING | R |  |  |  |  |  |  |  |  |  | April | 30
 |  |  |  |  |  |  |  |  |  |  | May | 31
 |  |  |  |  |  |  |  |  |  |  | June | 30
 |  |  |  |  |  |  |  |  |  |  | July | 31
 |  |  |  |  |  |  |  |  |  |  | August | 31
 |  |  |  |  |  |  |  |  |  |  | September | 30
 |  |  |  |  |  |  |  |  |  |  | October | 31
 |  |  |  |  |  |  |  |  |  |  | November | 30
 |  |  |  |  |  |  |  |  |  |  | December | 31
Spreadsheet: 752486d1634802579-cant-post-even-though-my-message-contains-only-a-message-no-links-images-or-video-example-a-1-
Sheet: Sheet1

PURCHASE DATE | PRODUCT CODE | PRICE in £ | QUANTITY | GROSS PROFIT | TAX @ 20% | NET PROFIT |  | PRODUCT CODE | ALL TIME NET PROFIT TOTALS |  | MONTH | MONTHLY NET  PROFIT TOTAL |  | MONTH | PRODUCT | MONTHLY NET PROFIT
2021-01-03 00:00:00 | A1 | 10 | 1 |  |  |  |  | A1 |  |  | 2021-01-01 00:00:00 |  |  | 2021-01-01 00:00:00 | A1
2021-01-04 00:00:00 | B1 | 15 | 3 |  |  |  |  | B1 |  |  | 2021-02-01 00:00:00 |  |  |  | B1
2021-01-05 00:00:00 | C1 | 17 | 4 |  |  |  |  | C1 |  |  | 2021-03-01 00:00:00 |  |  |  | C1
2021-01-06 00:00:00 | C1 | 17 | 2 |  |  |  |  | D1 |  |  |  |  |  |  | D1
2021-01-07 00:00:00 | D1 | 21 | 1
2021-01-08 00:00:00 | A1 | 10 | 1 |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | A1
2021-01-09 00:00:00 | B1 | 15 | 3 |  |  |  |  |  |  |  |  |  |  |  | B1
2021-01-10 00:00:00 | A1 | 10 | 2 |  |  |  |  |  |  |  |  |  |  |  | C1
2021-01-11 00:00:00 | A1 | 10 | 1 |  |  |  |  |  |  |  |  |  |  |  | D1
2021-02-03 00:00:00 | B1 | 15 | 5 |  |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00 | A1
2021-02-04 00:00:00 | A1 | 10 | 1 |  |  |  |  |  |  |  |  |  |  |  | B1
2021-02-05 00:00:00 | B1 | 15 | 1 |  |  |  |  |  |  |  |  |  |  |  | C1
2021-02-06 00:00:00 | A1 | 10 | 1 |  |  |  |  |  |  |  |  |  |  |  | D1
2021-02-07 00:00:00 | C1 | 17 | 3
2021-02-08 00:00:00 | D1 | 21 | 1
2021-02-09 00:00:00 | A1 | 10 | 2
2021-02-10 00:00:00 | D1 | 21 | 2
2021-02-11 00:00:00 | A1 | 10 | 3
2021-03-03 00:00:00 | C1 | 17 | 1
2021-03-04 00:00:00 | C1 | 17 | 1
2021-03-05 00:00:00 | B1 | 15 | 1
2021-03-06 00:00:00 | A1 | 10 | 1
2021-03-07 00:00:00 | A1 | 10 | 1
2021-03-08 00:00:00 | B1 | 15 | 5
2021-03-09 00:00:00 | A1 | 10 | 5
2021-03-10 00:00:00 | B1 | 15 | 3
2021-03-11 00:00:00 | A1 | 10 | 1
Spreadsheet: 100286d1298664545-delete-n-a-row-sample1test111
Sheet: 3

Week | ID | Employee | Hour
3 |  | Adam | 20
3 |  | [NAME] | 40
3 |  | [NAME] | 60
3 |  | Fred | 25
Spreadsheet: 92549950-c611-43dd-9a37-9bdee798dbca
Sheet: qryBio

Basin | 8 Digit HUC Name | Level IV Ecoregion | Waterbody | Station | County | Latitude | Longitude | Date | DWQ Collection No. | NCIBI Score | NCIBI Rating
SAV | Seneca River | Southern Crystalline Ridges & Mtns. | Big Cr | off SR 1608 | Macon | 35.00824 | -83.15964 | 2012-10-10 00:00:00 | 2012-98 | --- | Not Rated
SAV | Seneca River | Southern Crystalline Ridges & Mtns. | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | 46 | Good-Fair
SAV | Tugaloo River | Southern Crystalline Ridges & Mtns. | [NAME] | SR 1107 | [NAME] | 35.0591666666667 | -83.1327777777778 | 1995-05-02 00:00:00 | 95-35 | 38 | Fair
Spreadsheet: 118496d1313733308-fram-conditional-formating-conditional-f
Sheet: Sheet1

 |  |  | RangeStart | comp | Default | comp | RangeEnd
 |  |  | 1 | <= | x | <= | 5
 |  |  | 4 | < | x | < | 13
 |  |  | 13 | < | x | < | 22
 |  |  | 23 | <= | x | <= | 30
 |  |  | 30 | < | x | <= | 40
 |  |  | RangeStart | comp | Default | comp | RangeEnd
 |  |  | 10 | <= | x | <= | 5
 |  |  | 5 | <= | x | < | 13
Spreadsheet: 58872d1259158418-daily-repetitive-import-and-sort-macro-lookup-or-am-i-totally-on-the-wrong-track-book1
Sheet: ingredients

 | SKU NUMBER | SKU NAME | [NAME] | BATCH WEIGHT KG | INGRED1 | INGRED2 | INGRED3 | INGRED4
 | 100 | A | 1 | 10 | 1 | 2 | 3 | 3
 |  | B |  | 10 | 1 | 2 | 3 | 3
 |  | C |  | 10 | 1 | 2 | 3 | 3
 |  | D |  | 10 | 1 | 2 | 3 | 3
 |  | E |  | 10 | 1 | 2 | 3 | 3
 |  | F |  | 10 | 1 | 2 | 3 | 3
 |  | G |  | 10 | 1 | 2 | 3 | 3
 |  | H |  | 10 | 1 | 2 | 3 | 3
 |  | I |  | 20
 |  | J |  | 30
Spreadsheet: 39217d1237404634-list-data-validation-order
Sheet: Sheet1

Type | Sub Liquor | Sub Beer | Sub Wine
Liquor | Scotch | Domestic | White
Beer | Gin | Import | Blush
Wine | Rye | [NAME] | Red
 | Irish | Ciders | Sparkling
 | American | Coolers
 | [NAME]
 | Vodka
 | [NAME]
 | [NAME]
 | Liqueurs
 | [NAME]
Spreadsheet: 126481d1319719099-copy-information-from-cell-in-below-cell-s-book1
Sheet: Sheet1

11Q1185946-A |  | What my problem is: I'd like to copy the information in the yellow cell to the cell(s) below. Is there a formula I can execute this?
10 |  | Examples: a) Value in A1 must be copied in cell A2 b)Value in A5 must be copied in the cells A6-A12.
11Q1185946-B |  | Thanks for helping!
10
11Q1271002-C
30
60
40
70
10
20
50
11Q1274777-1
10
11Q1281469-B
70
60
40
80
50
20
90
30
100
110
10
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 22691
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 2466
Index Tranche | Asia | <100
 | Europe | 181
 | North America | 145
Index | Asia | 228
 | Europe | 4149
 | North America | 3756
TOTAL |  | 33616
Estimated swap transaction volumes, week ending January 11, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 217670-count-instances-of-text-in-a-comma-delimited-column-count
Sheet: Sheet1

RESULTS | first option | second option | third option | fourth option | fifth option | sixth option | seventh option
first option, third option, fourth option, seventh option
first option, second option, seventh option
first option, third option, fourth option, seventh option
first option, third option, fourth option, seventh option
first option, third option, fourth option, seventh option
first option, second option, seventh option
first option, second option, seventh option
first option, third option, fourth option, seventh option
first option, second option, seventh option
first option, second option, seventh option
Spreadsheet: 117055d1312412982-auto-populate-a-sheet-based-on-criteria-in-another-sheet-example
Sheet: Data

Employee Name | Total Meetings | Arrived at | Percentage | Address | Phone
[NAME] | 10 | 7 |  | 123 Baker St | [PHONE]
[NAME] | 10 | 5 |  | 124 [NAME] | [PHONE]
[NAME] | 10 | 4 |  | 125 [NAME] | [PHONE]
[NAME] | 10 | 9 |  | 126 [NAME] | [PHONE]
[NAME] | 10 | 3 |  | 127 [NAME] | [PHONE]
Maria | 10 | 10 |  | 128 [NAME] | [PHONE]
[NAME] | 10 | 8 |  | 129 [NAME] | [PHONE]
[NAME] | 10 | 8 |  | 130 [NAME] | [PHONE]
Spreadsheet: 118069d1313421349-best-way-to-represent-this-data-move-stats-by-shift
Sheet: data formated for by date

Date | Shift | Tool | Moves
2011-08-07 00:00:00 | A | T1 | 10
2011-08-07 00:00:00 | B | T1 | 1
2011-08-07 00:00:00 | C | T1 | 1
2011-08-07 00:00:00 | D | T1 | 1
2011-08-07 00:00:00 | A | T2 | 2
2011-08-07 00:00:00 | B | T2 | 2
2011-08-07 00:00:00 | C | T2 | 2
2011-08-07 00:00:00 | D | T2 | 2
2011-08-07 00:00:00 | A | T3 | 3
2011-08-07 00:00:00 | B | T3 | 3
2011-08-07 00:00:00 | C | T3 | 3
2011-08-07 00:00:00 | D | T3 | 3
2011-08-08 00:00:00 | A | T1 | 20
2011-08-08 00:00:00 | B | T1 | 1
2011-08-08 00:00:00 | C | T1 | 1
2011-08-08 00:00:00 | D | T1 | 1
2011-08-08 00:00:00 | A | T2 | 2
2011-08-08 00:00:00 | B | T2 | 2
2011-08-08 00:00:00 | C | T2 | 2
2011-08-08 00:00:00 | D | T2 | 2
2011-08-08 00:00:00 | A | T3 | 3
2011-08-08 00:00:00 | B | T3 | 3
2011-08-08 00:00:00 | C | T3 | 3
2011-08-08 00:00:00 | D | T3 | 3
2011-08-09 00:00:00 | A | T1 | 1
2011-08-09 00:00:00 | B | T1 | 1
2011-08-09 00:00:00 | C | T1 | 1
2011-08-09 00:00:00 | D | T1 | 1
2011-08-09 00:00:00 | A | T2 | 2
2011-08-09 00:00:00 | B | T2 | 2
2011-08-09 00:00:00 | C | T2 | 2
2011-08-09 00:00:00 | D | T2 | 2
2011-08-09 00:00:00 | A | T3 | 3
2011-08-09 00:00:00 | B | T3 | 3
2011-08-09 00:00:00 | C | T3 | 3
2011-08-09 00:00:00 | D | T3 | 3
2011-08-10 00:00:00 | A | T1 | 1
2011-08-10 00:00:00 | B | T1 | 1
2011-08-10 00:00:00 | C | T1 | 1
2011-08-10 00:00:00 | D | T1 | 1
2011-08-10 00:00:00 | A | T2 | 2
2011-08-10 00:00:00 | B | T2 | 2
2011-08-10 00:00:00 | C | T2 | 2
2011-08-10 00:00:00 | D | T2 | 2
2011-08-10 00:00:00 | A | T3 | 3
2011-08-10 00:00:00 | B | T3 | 3
2011-08-10 00:00:00 | C | T3 | 3
2011-08-10 00:00:00 | D | T3 | 3
2011-08-11 00:00:00 | A | T1 | 1
2011-08-11 00:00:00 | B | T1 | 1
2011-08-11 00:00:00 | C | T1 | 1
2011-08-11 00:00:00 | D | T1 | 1
2011-08-11 00:00:00 | A | T2 | 2
2011-08-11 00:00:00 | B | T2 | 2
2011-08-11 00:00:00 | C | T2 | 2
2011-08-11 00:00:00 | D | T2 | 2
2011-08-11 00:00:00 | A | T3 | 3
2011-08-11 00:00:00 | B | T3 | 3
2011-08-11 00:00:00 | C | T3 | 3
2011-08-11 00:00:00 | D | T3 | 3
2011-08-12 00:00:00 | A | T1 | 1
2011-08-12 00:00:00 | B | T1 | 1
2011-08-12 00:00:00 | C | T1 | 1
2011-08-12 00:00:00 | D | T1 | 1
2011-08-12 00:00:00 | A | T2 | 2
2011-08-12 00:00:00 | B | T2 | 2
2011-08-12 00:00:00 | C | T2 | 2
2011-08-12 00:00:00 | D | T2 | 2
2011-08-12 00:00:00 | A | T3 | 3
2011-08-12 00:00:00 | B | T3 | 3
2011-08-12 00:00:00 | C | T3 | 3
2011-08-12 00:00:00 | D | T3 | 3
2011-08-13 00:00:00 | A | T1 | 1
2011-08-13 00:00:00 | B | T1 | 1
2011-08-13 00:00:00 | C | T1 | 1
2011-08-13 00:00:00 | D | T1 | 1
2011-08-13 00:00:00 | A | T2 | 2
2011-08-13 00:00:00 | B | T2 | 2
2011-08-13 00:00:00 | C | T2 | 2
2011-08-13 00:00:00 | D | T2 | 2
2011-08-13 00:00:00 | A | T3 | 3
2011-08-13 00:00:00 | B | T3 | 3
2011-08-13 00:00:00 | C | T3 | 3
2011-08-13 00:00:00 | D | T3 | 3
Spreadsheet: 269238d1381072760-complete-sheet-shows-formulas-useage-spread-sheet-treecko-oeldere-
Sheet: Sheet3

[NAME] | Length | Height | [NAME] | 4 Air Exchange | Negative Air Machine
60 | 60 | 60 |  |  | PAS600  600 WTRNAFAN
 |  |  |  |  |  |  |  |  |  |  |  | Air Exchange | Safety air loss | Negative Air Unit (Average CFM)
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.25 | Phoenix 1400
 |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 0.5 | [NAME] 415 24000 CFH
 |  |  |  |  |  |  |  |  |  |  |  | 9 | 0.75 | Phoenix GuadianR Pro 30000 CFH
 |  |  |  |  |  |  |  |  |  |  |  | 12 | 0.99 | Predator PRED600 -  360000 CFH
 |  |  |  |  |  |  |  |  |  |  |  | 15 |  | Pred PRED1200 - 540000 CFH
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | Pred PRED1200UV - 540000 CFH
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  | HEPA-AIRE PAS600 - 360000 CFH
 |  |  |  |  |  |  |  |  |  |  |  | 30 |  | HEPA- PAS12000 - 540000 CFH
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HEPA- PAS1600 - 114000 CFH
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HEPA- PAS2400 - 126000 CFH
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HEPA- PAS5000 -240000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Defendair - air scrubber
Spreadsheet: 99278d1297962414-turn-start-end-dates-into-individual-days-764796_ker9
Sheet: Sheet1

emp_lastName | sch_fromDateTime | sch_toDateTime | sch_hours |  | MnthEND
ALPHA | 2011-01-31 00:00:00 | 2011-02-04 00:00:00 | 40 |  | 2011-01-01 00:00:00 | 63.8
BRAVO | 2011-03-28 00:00:00 | 2011-04-01 00:00:00 | 55 |  | 2011-02-01 00:00:00 | 79.2
CHARLIE | 2011-01-26 00:00:00 | 2011-01-26 00:00:00 | 8 |  | 2011-03-01 00:00:00 | 123
CHARLIE | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 16 |  | 2011-04-01 00:00:00 | 22
CHARLIE | 2011-02-23 00:00:00 | 2011-02-25 00:00:00 | 24 |  | 2011-05-01 00:00:00 | 0
CHARLIE | 2011-02-28 00:00:00 | 2011-03-04 00:00:00 | 20 |  | 2011-06-01 00:00:00 | 0
DELTA | 2011-03-28 00:00:00 | 2011-04-01 00:00:00 | 55 |  | 2011-07-01 00:00:00 | 0
ECHO | 2011-01-28 00:00:00 | 2011-01-28 00:00:00 | 8 |  | 2011-08-01 00:00:00 | 0
FOXTROT | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-09-01 00:00:00 | 0
GOLF | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-10-01 00:00:00 | 0
HOTEL | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-11-01 00:00:00 | 0
INDIA | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-12-01 00:00:00 | 0
[NAME] | 2011-01-31 00:00:00 | 2011-02-04 00:00:00 | 19 |  | 2012-01-01 00:00:00 | 0
[NAME] | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2012-02-01 00:00:00 | 0
KILO | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2012-03-01 00:00:00 | 0
LIMA | 2011-01-28 00:00:00 | 2011-01-28 00:00:00 | 8 |  | 2012-04-01 00:00:00 | 0
LIMA | 2011-02-28 00:00:00 | 2011-03-04 00:00:00 | 20 |  | 2012-05-01 00:00:00 | 0
LIMA | 2011-03-25 00:00:00 | 2011-03-25 00:00:00 | 3 |  | 2012-06-01 00:00:00 | 0
Spreadsheet: 215640d1361442608-random-numbers-generation-random
Sheet: Sheet1

Mean | 2 |  |  |  | Mean
SD | 3.5 |  |  |  | SD
Lower | -1.65 |  |  |  | Lower
Upper | 2.2 |  |  |  | Upper
Prob(L)
Prob(U)
Given Values
Generated Numbers
Calculated Values
Spreadsheet: 851880d1702000043-need-a-value-of-a-cell-to-read-zero-if-another-cell-is-zero-send
Sheet: BLOTTER

DATE | DAY | INSTRUMENT | PRICE | TIME | POSITION | E/X | QTY | DURATION | TIME BTW | POINTS | W/N | GROSS | FEES | NET |  |  | STOP | RISK | MAE | MFE
2024-01-02 00:00:00 | TUE |  |  |  |  | ENTRY | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | EXIT | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | ENTRY | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | EXIT | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | ENTRY | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | EXIT | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | ENTRY | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | EXIT | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | ENTRY | 1
2024-01-02 00:00:00 | TUE |  |  |  |  | EXIT | 1
Spreadsheet: 158786d1338393223-using-index-match-to-search-multiple-columns-copy-of-quoteproductioncapacity2-2
Sheet: Quote Book

 | OPERATION 010 |  |  | OPERATION 020 |  |  | OPERATION 030 |  |  | OPERATION 040
PART NUMBER | MACHINE | SETUP TIME | RUN TIME | MACHINE | SETUP TIME | RUN TIME | MACHINE | SETUP TIME | RUN TIME | MACHINE | SETUP TIME | RUN TIME
000-001 | SAW | 0.19 | 0.16 | LATHE | 1 | 0.5 | MILL | 2 | 2 | EDM | 0.25 | 0.25
000-002 | LATHE |  | 6 | EDM | 0.5 | 0.5 | MILL | 0.5 | 0.5
000-003 | MILL | 1 | 1
000-004 | SAW | 0.19 | 0.16 | LATHE | 1 | 1 | MILL | 1 | 1 | EDM | 0.25 | 0.5
123-001 | LATHE | 2 | 5 | MILL | 2 | 2
123-002 | MILL | 2 | 3
XYZ-001 | LATHE |  | 1 | SAW | 0.25 | 0.25 | LATHE | 1 | 0.5
XYZ-002 | MILL | 1 | 1
XYZ-003 | SAW | 0.19 | 0.16 | LATHE | 1 | 1 | MILL | 1 | 1 | EDM | 0.25 | 0.5
XYZ-004 | LATHE | 2 | 5 | MILL | 2 | 2
XYZ-005 | MILL | 2 | 3
XYZ-006 | LATHE |  | 1 | SAW | 0.25 | 0.25 | LATHE | 1 | 0.5
[NAME] | SAW | 0.19 | 0.25 | LATHE | 1 | 0.5 | MILL | 2 | 2 | EDM | 0.25 | 0.25
XYZ-008 | SAW | 0.19 | 0.16 | LATHE | 1 | 1 | MILL | 1 | 1
XYZ-009 | MILL | 2 | 5
XYZ-010 | LATHE |  | 1 | SAW | 0.25 | 0.25 | LATHE | 1 | 0.5
XYZ-011 | SAW | 0.19 | 0.25 | LATHE | 1 | 0.5 | MILL | 2 | 2 | EDM | 0.25 | 0.25
XYZ-012 | MILL | 1 | 1
XYZ-013 | SAW | 0.19 | 0.16 | LATHE | 1 | 1 | MILL | 1 | 1 | EDM | 0.25 | 0.5
XYZ-014 | LATHE | 2 | 5 | MILL | 2 | 2
XYZ-015 | MILL | 2 | 3
[NAME] | LATHE |  | 1 | SAW | 0.25 | 0.25 | LATHE | 1 | 0.5
XYZ-017 | SAW | 0.19 | 0.25 | LATHE | 1 | 0.5 | MILL | 2 | 2 | EDM | 0.25 | 0.25
XYZ-018 | SAW | 0.19 | 0.16 | LATHE | 1 | 1 | MILL | 1 | 1
XYZ-019 | MILL | 2 | 5
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Margetts, Dean

Margetts, [NAME]
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT