tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0cbe2a13-4252-471a-ab62-0f67f1a156f2
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 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
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
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 674514d1587890997-format-problem-and-the-lookup-function-2020_04-26-oeldere-674513d1587890058-format-problem-and-the-lookup-function-format-problem-an
Sheet: Sheet-2

Account | Description |  | Account | Description
1011
1031
1060
1100
1101
1102
1150
1211
1214
1215
1230
1250
1251
1252
1280
1281
1299
1340
1341
1350
1351
1352
1353
1354
1380
1381
1382
1383
1385
1390
1460
1461
1462
1463
1465
1468
1469
1470
1471
1500
Spreadsheet: 467784d1466931290-need-an-if-formula-but-not-sure-where-it-goes-sample
Sheet: Sheet1

Day | Weather | Sales A | Sales B
 | 1 | 200 | 453
 | 2 | 60 | 234 |  | if WeatherColumn(B2:b29)= 3, then I need all mondays(a5,a12,a26) Sales A (c5,c12,c26) Averages which =
 | 2 | 400 | 123 |  | Day | Weather | Sales A Average
 | 3 | 654 | 234 |  | Monday | 3 | 477
 | 2 | 342 | 345
 | 1 | 45 | 234
 | 1 | 456 | 124 |  | if WeatherColumn(B2:b29)= 3, then I need all tuesdays(a6,a20) Sales A (c6,c20) Averages which =
 | 2 | 654 | 324
 | 3 | 345 | 321 |  | Day | Weather | Sales A Average
 | 2 | 453 | 423 |  | Tuesday | 2 | 288
 | 3 | 234 | 234
 | 1 | 234 | 423
 | 1 | 456 | 234
 | 2 | 321 | 453 |  | And So on…..
 | 3 | 235 | 764
 | 2 | 345 | 234
 | 1 | 654 | 224
 | 2 | 123 | 334 |  | Thanks
 | 2 | 234 | 444
 | 3 | 345 | 213
 | 4 | 432 | 132
 | 5 | 321 | 80
 | 5 | 234 | 653
 | 4 | 345 | 666
 | 3 | 543 | 654
 | 3 | 234 | 345
 | 2 | 234 | 654
 | 1 | 231 | 453
Spreadsheet: 176920d1346142447-nested-if-function-example-a
Sheet: Sheet2

 | Complaint | Start Time | Current Time | Status | Total Time | Escalated To |  |  | Hours | Escalate To
 | xxx | 04:21:00 | 09:53:00 | Open |  |  |  |  | 4 to 8 hrs | [NAME]
 | yyy | 01:17:00 | 09:53:00 | Open |  |  |  |  | 8 to 16 hrs | [NAME]
 | zzz | 17:00:00 | 09:53:00 | Open | 16:53:00 |  |  |  | 16 to 24 hrs | [NAME]
 | aaa | 09:52:00 | 09:53:00 | Open |  |  |  |  | More than 24 hrs | Louis
Spreadsheet: 764008d1642525651-cleaning-data-seperating-text-and-numbers-excel-help-15-2
Sheet: example

Over 20.5 Points1.840Under 20.5 Points1.900
Over 15.5 Points1.917Under 15.5 Points1.826
Column1 |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
Over 20.5 Points1.840Under 20.5 Points1.900 |  |  |  |  |  |  | Over | 20.5 | Points | 1.840 | Under | 20.5 | Points | 1.900
Over 15.5 Points1.917Under 15.5 Points1.826 |  |  |  |  |  |  | Over | 15.5 | Points | 1.917 | Under | 15.5 | Points | 1.826
Spreadsheet: 147867d1333016300-conditional-formatting-conditional-formatting
Sheet: Sheet1

0
10 |  |  |  |  |  |  |  | Less than zero = Red
20 |  |  |  |  |  |  |  | 0>20 = Brown
30 |  |  |  |  |  |  |  | 20>100 = Grey
40 |  |  |  |  |  |  |  | >100 = Gold
50
60
70
80
90
100
110
120
19
21
30
99
101
100
Spreadsheet: 02264d33-16fe-45b0-b283-3f14b369c4df
Sheet: Sheet1

WORLD SENIOR BADMINTON CHAMPIONSHIPS 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
09-14 SEPTEMBER 2013, ANKARA-TURKEY
PRACTICE PROGRAMME
 | 07.09.2013  SATURDAY
 |  | Practice Hall
 | Time | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Court 6 | Court 7
1 | 09.00-10.00
2 | 10.00-11.00
3 | 11.00-12.00
4 | 12.00-13.00
5 | 13.00-14.00
6 | 14.00-15.00
7 | 15.00-16.00
8 | 16.00-17.00
9 | 17.00-18.00
10 | 18.00-19.00
11 | 19.00-20.00
12 | 20.00-21.00
13 | 21.00-22.00
 | 08.09.2013  SUNDAY
 |  | Practice Hall
 | Time | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Court 6 | Court 7
1 | 09.00-10.00
2 | 10.00-11.00
3 | 11.00-12.00
4 | 12.00-13.00
5 | 13.00-14.00
6 | 14.00-15.00
7 | 15.00-16.00
8 | 16.00-17.00
9 | 17.00-18.00
10 | 18.00-19.00
11 | 19.00-20.00
12 | 20.00-21.00
13 | 21.00-22.00
Spreadsheet: 748725d1632316739-help-with-sumproduct-to-calculate-monthly-gross-profit-sumproduct-formula-for-gross-profit
Sheet: Sheet1

Kindly asking for help with sumproduct formula to calculate Gross Profit or any other formula which is not sumifs
 |  |  |  |  |  | Desired Outcome
Date | Details | Amount |  |  |  |  | Jan | feb | Mar
2021-01-01 00:00:00 | sales | 285 |  |  |  | Sales | 605 | 335 | 505
2021-01-10 00:00:00 | sales | 320 |  |  |  | Cost of Sales | 280 | 280 | 535
2021-01-30 00:00:00 | Cost of sales | 280 |  |  |  | Gross Profit
2021-02-10 00:00:00 | sales | 335
2021-02-15 00:00:00 | Cost of sales | 280
2021-03-13 00:00:00 | sales | 250
2021-03-10 00:00:00 | sales | 255
2021-03-01 00:00:00 | Cost of sales | 255
2021-03-02 00:00:00 | Cost of sales | 280
Spreadsheet: sally_beck__36249__East PG&E Deal Sum by Desk
Sheet: _tmp_9844_EPMI-LT-MGMT_deal_sum

 |  |  |  |  |  |  | ENRON POW | ER TRADING & | [NAME] |  |  |  |  |  | Run Date | :       04/06 | /01
Report Da | te:  04/06/01 |  |  |  |  |  |  | Deal [NAME] | y |  |  |  |  |  | Run Time | :       18:12 | :49
Post ID: | 9844
Desk: EPM | I-LT-MGMT
 |  | Trade | Start | End |  |  |  |  |  |  |  |  |  | Current |  |  |  | Prior Day | Prior
Deal | Counter | Date | Date | Date | Anty | Delivery | PV'd | Swap Vol | PV'd | Option Vol | Notional | Deal Vol |  | Deal | MTM P/L |  | LTD | Hedge | Day
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | Y/N | Point | Peak | [NAME] | Peak | [NAME] | Peak | [NAME] | Price Mid | Basis Mid | Total Mid | Prudent | Liquidations | Management | Liquidations
--------- | ------------------ | -------- | -------- | -------- | ---- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ---------------- | --------------- | -------------
342137 | PGEENEPOWLP | 2000-05-18 00:00:00 | 2001-04-01 00:00:00 | 2001-12-31 00:00:00 | No | PJM-Western Hub | 145683 | 0 | 0 | 0 | 148800 | 0 | 2696990 | 0 | 2696990 | 2690546 |  | 60493 | 360
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R1E |  |  |  |  |  | 145683 | 0 | 0 | 0 | 148800 | 0 | 2696990 | 0 | 2696990 | 2690546 |  | 60493 | 360
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Total Pow | er Price Book |  |  |  |  |  | 145683 | 0 | 0 | 0 | 148800 | 0 | 2696990 | 0 | 2696990 | 2690546 |  | 60493 | 360
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Spreadsheet: 725048d1616511000-date-wise-ticket-status-using-sumproduct-or-sumifs-sumproduct_sample
Sheet: ExpectedResult

 | Date | 2021-03-01 00:00:00 | To | 2021-03-31 00:00:00 |  | Based on Date Selection, the data need to be fetched from Data2 sheet
 |  | Assigned | Closed
 | Low | 2 | 0
 | Medium | 1 | 1
 | High | 1 | 1
 | Date | 2021-02-01 00:00:00 | To | 29-02-2021
 |  | Assigned | Closed
 | Low | 2 | 2
 | Medium | 2 | 0
 | High | 2 | 0
Spreadsheet: 834861d1688124301-multiple-doughnut-chart-with-fixed-sizes-belbin
Sheet: Belbin

 |  | Number of members | 6
 |  | Member  Belbin Role | 1 | 2 | 3 | 4 | 5 | 6 | Total |  |  |  |  |  |  | angle | radius
 |  | TeamWorker (TW) | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | TeamWorker (TW)
 |  | Co-ordinator (CO) | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | Co-ordinator (CO)
 |  | Sharper (SH) | 1 | 0 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | Sharper (SH)
 |  | [NAME]) | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | [NAME])
 |  | Implementer (IMP) | 0 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | Implementer (IMP)
 |  | Specialist (SP) | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | Specialist (SP)
 |  | Monitor Evaluator (ME) | 1 | 1 | 1 | 0 | 1 | 1 |  |  |  |  |  |  | Monitor Evaluator (ME)
 |  | Plant (PL) | 1 | 0 | 1.000001 | 1 | 1 | 1 |  |  |  |  |  |  | Plant (PL)
 |  | Resource Investigator (RI) | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | Resource Investigator (RI)
 |  |  |  |  |  |  |  |  |  |  |  | 100/6
Spreadsheet: 50535d1249994346-lookup-help-variations
Sheet: Data

Issue # | ID by | Date Raised | Requirements | Owner | Client authorization required by | Linke To | Action | Date Required | Complete | Variation #
1 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00 |  | 2
2 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00 |  | 1
3 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00
4 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00
5 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00 |  | 2
6 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00 |  | 1
7 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00
8 | DTM 001 | 2009-07-20 00:00:00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX | XX |  |  | XX | 2009-07-27 00:00:00 |  | 1
Spreadsheet: 63837d1264702078-seperate-a-huge-data-set-into-weeks-and-average-them-book2_jan27
Sheet: Sheet4

Average of Cell B
Cell A | Total
12/27/1976 - 1/2/1977 | 4.5
1/31/1977 - 2/6/1977 | 7.6
2/28/1977 - 3/6/1977 | 7.7
3/28/1977 - 4/3/1977 | 9
4/25/1977 - 5/1/1977 | 3.4
5/30/1977 - 6/5/1977 | 12
6/27/1977 - 7/3/1977 | 7.2
8/1/1977 - 8/7/1977 | 4.6
8/29/1977 - 9/4/1977 | 7.9
9/26/1977 - 10/2/1977 | 4.5
10/31/1977 - 11/6/1977 | 5.5
11/28/1977 - 12/2/1977 | 6.6
Grand Total | 6.708333333333333
Spreadsheet: 792574d1660987270-retrieving-data-from-a-table-based-on-two-drop-down-box-values-2022-08-20-oeldere-niknolte84-sample1
Sheet: Department Report

1969
 |  |  | Department Costing Report
 |  | Supplier | Marketing |  | Month 1 | June
 |  |  |  |  | Month 2 | July
 |  | Total Spent inc. VAT
 |  | Total Spent ex. VAT
 |  | Total VAT
 |  |  |  |  | Difference +/-
 |  | Supplier Expenditure With Chosen Department
 |  |  | Total Inc. VAT |  |  | Difference +/-
 |  | All Suppliers
 |  | [NAME]
 |  | AJet
 |  | Amazon
 |  | Arboritom
 |  | Arleigh
 |  | Asgard
 |  | AvantiGas
 |  | Buildbase
 |  | Calor
 |  | [NAME]
 |  | Coast & County Ltd
 |  | Creative Play
 |  | DeeBee
 |  | Eden Farm Hulleys
 |  | EuroCell
 |  | Firestop Services
 |  | Foundations and Buildings
 |  | [NAME]
 |  | [NAME]'s Homeware
 |  | Keycraft
 |  | [NAME]
 |  | [NAME]
 |  | LincsPest Ltd
 |  | Miscellaneous Vendor
 |  | Office Stationary
 |  | S and A Colclough
 |  | Screwfix
 |  | SGS
 |  | Smart Spanner
 |  | SSE
 |  | Tesco
 |  | Veolia
 |  | Victorian Plumbing
 |  | Weldricks Pharmacy
 |  | Welton Aggregate
 |  | Windhager
 |  | Y Pellets
 | ------------------------------------------------------------------------------------------------------------------------------------------------------------
 |  | All Purchase Orders for selected "Month 1"
 |  | PO Number | Date of Purchase | Costing Code | Cost inc. VAT | Total VAT
 |  | All of the above figures are correct as of todays date, providing all Purchase Orders have been input into the [NAME] form.
Spreadsheet: 859803d1708051425-remove-range-limitation-of-formula-and-extend-to-whole-column-and-possibly-execute-in-vba-booj1
Sheet: Sheet1

Some | Orange | Some | Some | 1
Some | Orange | Some | Some | 1
Some | Orange | Some | Some | 1 | M
Some | Apple | Some | Some | 2
Some | Apple | Some | Some | 2
Some | Apple | Some | Some | 2
Some | Apple | Some | Some | 2 | S
Some | Grape | Some | Some | 1
Some | Grape | Some | Some | 2
Some | Grape | Some | Some | 1
Some | Grape | Some | Some | 1
Some | Grape | Some | Some | 2 | M+S
Spreadsheet: b807251d-acdd-4f9e-83ba-66a6bdbbedd2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Index
 |  | 2013 | Direct Care Assistance Application
 |  | Due: | 2013-04-01 00:00:00
 |  |  | © 2012 National Religious Retirement Office
 |  | National Religious Retirement Office
 |  | 3211 4th Street, NE
 |  | Washington, DC 20017-1194
 |  | Phone:  [PHONE]
 |  | Fax: [PHONE]
 |  | www.usccb.org/nrro
 |  | For assistance with this application, please contact:
 |  |  |  | Br. [NAME], FMS, JCL
 |  |  |  | Phone:  [PHONE]
 |  | Executive Director
 |  |  | Sister Janice Bader, CPPS
 |  |  | [EMAIL]
 |  | Associate Director
 |  |  | Br. [NAME], FMS, JCL
 |  |  | [EMAIL]
 |  | Associate Director
 |  |  | Brother [NAME]
 |  |  | [EMAIL]
 |  | Program Specialist
 |  |  | [NAME]
 |  |  | [EMAIL]
 |  | Administrative Assistant
 |  |  | Tiffany Lezama
 |  |  | [EMAIL]
 |  | Direct Care Assistance Application Software designed and developed by:
 |  |  | Eleanor LeClair
 |  |  | Eleanor LeClair Consulting Services, Inc.
 |  |  | 10415 [NAME]
 |  |  | Fairfax, VA  22032
 |  |  | Phone:  [PHONE]
 |  |  | [EMAIL]
 |  |  | www.eleclair.com
Spreadsheet: 869975d1716492239-how-i-can-generate-a-table-with-mean-time-to-resolve-hours-minutes-seconds-in-totals-esaji-count-custom-hours
Sheet: desired outcome totals

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTTR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  | the output needed to be like in picutre
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTTR | P3 | P1 | P2 | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
 |  |  |  |  |  |  |  | For the month of April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This output what I am able to generated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTTR | Average of MTTD hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 0
Spreadsheet: 731026d1620130724-highlight-date-range-on-calendar-ef1523a_test-2-copy
Sheet: Hire

 |  |  |  |  |  |  |  |  | HIRE RECORD
Hire_start |  |  |  |  | Hire_end |  |  |  |  |  | Cumulative Days
Hire Start Date | M/C No. | Customer | Site | Machine Hours | Hire End Date | Machine Hours | Hire Period Weeks | Total Hire Hours | Comments | Days | 0 |  | Hire_row | Hire_dates
2020-02-17 00:00:00 | 39 | S-LL | LL |  | 2020-02-19 00:00:00
2020-05-08 00:00:00 | 39 | S-LL | LL |  | 2020-05-28 00:00:00
2020-05-01 00:00:00 | 39 | L - Lanark | Lanark
2020-06-10 00:00:00 | 39 | L - Lanark | Lanark |  | 2020-06-17 00:00:00
2020-07-06 00:00:00 | 39 | L - Lanark | Lanark |  | 2020-07-10 00:00:00
2020-07-13 00:00:00 | 39 | S - Bredbury | [NAME] |  | 2020-08-07 00:00:00
2020-09-21 00:00:00 | 39 | HH | Bury |  | 2020-09-23 00:00:00
2020-09-30 00:00:00 | 39 | CS | WS |  | 2020-11-17 00:00:00
2020-10-22 00:00:00 | 33 | LE | London |  | 2020-11-17 00:00:00
2020-11-17 00:00:00 | 33 | CS | WS
2020-11-24 00:00:00 | 39 | RL | Preston |  | 2020-11-24 00:00:00
2020-11-24 00:00:00 | 39 | RL | Preston |  | 2020-12-04 00:00:00
2020-11-25 00:00:00 | 33 | DS | [NAME] |  | 2020-11-25 00:00:00
2020-11-25 00:00:00 | 33 | DS | [NAME]
2020-12-08 00:00:00 | 39 | DS | [NAME] |  | 2021-01-28 00:00:00
2021-03-22 00:00:00 | 38 | Met | Country |  | 2021-03-24 00:00:00
2021-03-25 00:00:00 | 38 | Met | London
2021-03-25 00:00:00 | 39 | Trans | Hull
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: netLibrary

NetLibrary
2010-2011
COUNTER-Compliant?: | No
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 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 | Total | 2010-2011 Price | Price per unit
NetLibrary
Total Accesses | 31 | 6 | 36 | 77 | 67 | 21 | 21 | 33 | 26 | 32 | 24 | 48 |  | 0 | N/A
Turnaways | 37 | 0 | 12 | 3 | 7 | 0 | 5 | 1 | 0 | 17 | 10 | 22
Note: We have 4,478 shared titles
Spreadsheet: 684021d1593100475-automated-creation-of-a-two-unique-lists-from-a-source-sheet-companyandworker
Sheet: Company 

WEEK | COMPANY | Invoice Total
25 | Company 1 | 200
25 | Company 2 | 100
25 | Company 3 | 200
26 | Company 1 | 50
26 | Company 4 | 100
26 | Company 2 | 100
27 | Company 2 | 200
Spreadsheet: 199548d1355248200-finding-row-on-matrix-matching-3-criteria-and-get-a-result-hour-tigeravatar-example-for-moonalert
Sheet: Lists

Event List | Hour List
Check-In | 00:00:00
Check-Out | 01:00:00
 | 02:00:00
 | 03:00:00
 | 04:00:00
 | 05:00:00
 | 06:00:00
 | 07:00:00
 | 08:00:00
 | 09:00:00
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 | 16:00:00
 | 17:00:00
 | 18:00:00
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 22:00:00
 | 23:00:00
Spreadsheet: 50124d1249513157-pull-data-from-one-sheet-to-pop-another-need-new-eyes-please-last-reply-for-info-footballbetting
Sheet: Sheet2

 |  | Stage 1 | Stage 2 | Stage 3 | Stage 4 |  | Max Total Games |  | Units |  | Risk Amount
1 |  | 3 | 0 | 0 | 0 |  | 3 |  | 3 |  | 1155
2 |  | 2 | 1 | 0 | 0 |  | 3 |  | 4 |  | 1963.5
3 |  | 1 | 3 | 1 | 0 |  | 5 |  | 10 |  | 6856.85
4 |  | 0 | 1 | 3 | 1 |  | 5 |  | 15 |  | 15939.385
5 |  | 0 | 0 | 0 | 1 |  | 1 |  | 4 |  | 6071.835
6 |  | 0 | 1 | 1 | 0 |  | 2 |  | 5 |  | 4084.85
7 |  | 0 | 0 | 0 | 1 |  | 1 |  | 4 |  | 6071.835
8 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
9 |  | 0 | 0 | 1 | 0 |  | 1 |  | 3 |  | 2891.35
10 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
11 |  | 0 | 0 | 0 | 3 |  | 3 |  | 12 |  | 18215.505
12 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
13 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
14 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
15 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
16 |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
Total Bets | 6
[NAME] | 2
[NAME] | 4200
 |  |  | Bet Unit | 350
 |  |  | [NAME] | -110
 |  | Gm 1 | Gm 2 | Gm 3 | [NAME] 4 | Total | Avg Unit
 |  | 385 | 1193.5 | 2891.35 | 6071.835 | 10541.685 | 31 | 30.1191
Spreadsheet: 842295d1694424376-how-to-return-a-value-based-on-2-criteria-a3-problem-solving-log
Sheet: Presentation Format

A3 Number |  | Operations Lead |  | Operator |  | Quality Lead |  | Manuf Engineer |  | Supply Chain |  | Design Engineer |  |  | Area |  |  |  | Date Opened
1. DEFINE THE PROBLEM |  |  |  |  |  | 2. PROTECT THE CUSTOMER |  |  |  |  |  | 3. ROOT CAUSE ANALYSIS
 |  |  |  |  |  |  |  |  |  |  |  | Material |  |  | Method |  |  | Machine
 |  |  |  |  |  |  |  |  |  |  |  | Measurement |  |  | Man |  |  | Environment
Good Scenario |  |  | Bad Scenario
 |  |  |  |  |  |  |  |  |  |  |  | Root Cause Summary
4. Corrective Action: |  |  |  |  |  |  |  |  |  |  | 5. Verification of Action:
Spreadsheet: 716792d1612366712-sumif-across-multiple-sheets-test
Sheet: Annual Sales

 |  |  |  |  |  |  |  |  |  | 2021-MOC-WL
 |  | Sales | Gross | Net |  |  |  |  |  | 2021-MOC-Bend
 | Apple Butter Spread |  |  |  |  |  |  |  |  | 2021-MOC-Bend 24 Jan
 | BlackCap Jam |  |  |  |  |  |  |  |  | 2021-MOC-CM 2 Feb
 | BlackCap Seedless Jam
 | BlackCap Sugarless Spread
 | BlackCap Seedless Sugarless Spread
 | BlackCap Naturally Sweetened Syrup
 | BlackCap [NAME]
 | BlackCap [NAME]
 | BlackCap [NAME]
 | BlackCap [NAME] Sweetened Syrup
 | BlackCap Blueberry Seedless Spread
 | BlackCap Blueberry Naturally Sweetened Syrup
 | [NAME]
 | [NAME]