tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270452d1381491657-sum-for-multiple-criteria-test-help
Sheet: Sheet1

 |  |  | Month
User | Leader | Measure | Jan | Feb | Mar
User 1 | Leader 1 | Measure1 | 50 | 60 | 70
User 1 | Leader 1 | Measure2 | 1 | 2 | 3
User 1 | Leader 1 | Measure3 | 10 | 12 | 14
User 2 | Leader 1 | Measure1 | 50 | 60 | 70
User 2 | Leader 1 | Measure2 | 1 | 2 | 3
User 2 | Leader 1 | Measure3 | 10 | 12 | 14
User 3 | Leader 1 | Measure1 | 50 | 60 | 70
User 3 | Leader 1 | Measure2 | 1 | 2 | 3
User 3 | Leader 1 | Measure3 | 10 | 12 | 14
User 4 | Leader 2 | Measure1 | 50 | 60 | 70
User 4 | Leader 2 | Measure2 | 1 | 2 | 3
User 4 | Leader 2 | Measure3 | 10 | 12 | 14
User 5 | Leader 2 | Measure1 | 50 | 60 | 70
User 5 | Leader 2 | Measure2 | 1 | 2 | 3
User 5 | Leader 2 | Measure3 | 10 | 12 | 14
User 6 | Leader 3 | Measure1 | 50 | 60 | 70
User 6 | Leader 3 | Measure2 | 1 | 2 | 3
User 6 | Leader 3 | Measure3 | 10 | 12 | 14
SUMMARY
Leader | Measure | Month | Answer
Leader 1 | Measure1 | Jan
 |  |  |  | Need red to populate based on Leader, measure and Month
 | Answer based on above should be 150
Spreadsheet: cara_semperger__1451__ENA_PGE_DEC08_2001
Sheet: SYS-JD OR GRIZZ BR

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING |  |  |  | SINK | SINK | SINK | SINK | SINK
Pacific Prevailing
Time | SYS/SYS OUT AT GRIZZLY | SYS | PGE LOSSES | EPMI COB S/N | PGE LOSSES | TO GRIZZLY | TO SYS | TO [NAME] | BUY/RESALE
(PPT) |  |  |  | LOSS RETURN |  |  |  |  | [NAME]
0100 |  |  | 1 |  | -1
0200 |  |  | 1 |  | -1
0300 |  |  | 1 |  | -1
0400 |  |  | 1 |  | -1
0500 |  |  | 1 |  | -1
0600 |  |  | 1 |  | -1
0700 |  |  | 4 |  | -4
0800 |  |  | 4 |  | -4
0900 |  |  | 4 |  | -4
1000 |  |  | 4 |  | -4
1100 |  |  | 4 |  | -4
1200 |  |  | 4 |  | -4
1300 |  |  | 4 |  | -4
1400 |  |  | 4 |  | -4
1500 |  |  | 4 |  | -4
1600 |  |  | 4 |  | -4
1700 |  |  | 4 |  | -4
1800 |  |  | 4 |  | -4
1900 |  |  | 4 |  | -4
2000 |  |  | 4 |  | -4
2100 |  |  | 4 |  | -4
2200 |  |  | 4 |  | -4
2300 |  |  | 1 |  | -1
2400 |  |  | 1 |  | -1
 |  |  | BPA(G)SYS |  |  |  |  |  | SHOULD BE ZERO
 |  |  | CLSK(PSE) | EPMI COB S/N | PGE LOSSES | TO COB' | TO COB' | TO COB'
 |  |  | BPA(T)BPAP/PGE | LOSS RETURN |  | SEE COB SHEET | SEE COB SHEET | SEE COB SHEET
 |  |  | CLSK(PSE)
 |  |  | EPMI(PSE)
 | PGE(L,R)SYS/SYS OUT AT GRIZZLY | PGE(L,R)SYS   SYSTEM SALE | PGE@SYS   LOSSES
 |  | NOT A BUY/RESALE
Spreadsheet: 93437d1293021029-formula-needed-to-fetch-data-from-different-worksheets-and-include-adjacent-cells-copy-of-core-staff-leave-2010
Sheet: GD

[NAME]
HOLIDAYS TAKEN
2010
Tuesday | 1900-04-13 00:00:00 | [NAME]
Thursday | 1900-04-15 00:00:00 | [NAME]
Wednesday | 1900-06-30 00:00:00 | [NAME]
Thursday | 1900-07-01 00:00:00 | [NAME]
Friday | 1900-07-02 00:00:00 | [NAME]
Friday | 1900-08-13 00:00:00 | [NAME]
Monday | 1900-08-16 00:00:00 | [NAME]
Tuesday | 1900-08-17 00:00:00 | [NAME]
Monday | 1900-08-23 00:00:00 | [NAME]
Tuesday | 1900-08-24 00:00:00 | [NAME]
Wednesday | 1900-08-25 00:00:00 | [NAME]
Thursday | 1900-08-26 00:00:00 | [NAME]
Friday | 1900-08-27 00:00:00 | [NAME]
STATUTORY |  | 8
SEE E-MAIL 02/12/2010 |  | 4
Spreadsheet: 270001d1381343575-transposing-and-consolidating-a-1d-to-a-2d-table-transpose
Sheet: Before

[NAME] | Color | Blue
[NAME] | Gender | Male
[NAME] | Age | 29
[NAME] | Color | [NAME]
[NAME] | Gender | Male
[NAME] | Age | 22
Elle | Color | [NAME]
Elle | Gender | Female
Elle | Age | 31
[NAME] | Color | [NAME]
[NAME] | Gender | Female
[NAME] | Age | 28
[NAME] | Color | Green
[NAME] | Gender | Male
[NAME] | Age | 19
Spreadsheet: 77213d1277735588-excel-2007-finding-the-latest-data-based-on-2-variables-date-calculator
Sheet: Sheet2

Item-ID | Item | Cost | [NAME]
ST-340 | Stroller | $145.67 | 0.3
BI-567 | Bib | $3.56 | 0.4
DI-328 | Diapers | $21.45 | 0.35
WI-989 | Wipes | $5.12 | 0.4
AS-469 | Aspirator | $2.56 | 0.45
[NAME] | Description |  | Result
 | Calculates the retail price of diapers by adding the markup percentage to the cost. | $28.96
 | Calculates the sale price of wipes by subtracting a specified discount from the retail price. | $5.73
 | If the cost of an item is greater than or equal to $20.00, displays the string "[NAME] is nn%"; otherwise, displays the string "Cost is under $20.00". | [NAME] is 30%
 | If the cost of an item is greater than or equal to $20.00, displays the string [NAME] is nn%"; otherwise, displays the string "Cost is $n.nn". | Cost is $3.56
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 812
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 57421.18
2002-03-12 00:00:00
CBS Volume
 |  |  | 7844
Spreadsheet: 704200d1605435492-returning-a-non-numerical-value-that-matches-another-list-excel-forum-question-
Sheet: Sheet1

 |  | Company | A | B | C | D | E | F | G |  |  |  |  | Company
 |  | Industry | [NAME] | Oil & Gas | [NAME] | Motor vehicles | [NAME] | Software | Marketing services |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  | G
Spreadsheet: 168628d1342529282-conditional-formatting-problem-cond-format-problem
Sheet: Sheet1

25
85
15
14
78
12
65
95
216
26
62
26
26
89
87
26
45
26
215
52
5
41
56
5
52
52
45
54
45
Spreadsheet: 219860d1362993799-have-list-of-dates-need-how-many-of-those-dates-fall-between-two-other-dates-monthly-rpt-stats-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Referred | Install Date | Removal Date | Total # of Days Sentenced | Offender | Agency | Number of Days Served at time of report | Offence that put Offender on Program | Violations Yes/No | Was it a Misd. or Felony | What is Violation | Date of Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-07 00:00:00 | 2013-01-27 00:00:00 | 2013-05-12 00:00:00 | 105 | Doe, [NAME] | [NAME] | 63 | DUI | Yes |  |  | 2013-03-31 00:00:00
 |  |  | REPORT PREPARED FOR: |  |  |  |  |  |  |  |  |  |  |  | 2013-01-15 00:00:00 | 2013-02-15 00:00:00 | 2013-03-11 00:00:00 | 24 | Doe, [NAME] | [NAME] | 24 | DUI |  |  |  | 2013-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00 | 2013-03-16 00:00:00 | 2013-04-25 00:00:00 | 40 | Doe, [NAME] | [NAME] | 15 | DUI |  |  |  | 2013-03-31 00:00:00
 |  |  | DATE OF REPORT: |  |  |  |  |  |  |  |  |  |  |  | 2013-02-21 00:00:00 | 2013-03-17 00:00:00 | 2013-04-01 00:00:00 | 15 | Doe, [NAME] | [NAME] | 14 | DUI |  |  |  | 2013-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-21 00:00:00 | 2013-03-28 00:00:00 | 2013-04-13 00:00:00 | 16 | Doe, [NAME] | [NAME] | 3 | DUI |  |  |  | 2013-03-31 00:00:00
 | Reporting Period |  |  |  |  | I need cell B12 to reflect the total number of people referred (Column P") |  |  |  |  |  |  |  |  | 2013-02-06 00:00:00 | 2013-04-10 00:00:00 | 2013-04-17 00:00:00 | 7 | Doe, [NAME] | [NAME] | 0 | DUI |  |  |  | 2013-03-31 00:00:00
 |  |  |  |  |  | between the dates in B10 and C10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 | From | To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 | 2013-03-01 00:00:00 | 2013-03-31 00:00:00 |  |  |  |  | I know what I need but I have no clue!  I appreciate your help! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 |  | Total # of Participants Refered during reporting period |  |  |  |  |  | Thank you! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 |  | Total # of Participants in Program during reporting period
 |  | Total # of Participants Completing Program during reporting period
 |  | Total # of Participants that were violated from Program during reporting period
 |  | Total # of Participants that have used alcohol and/or drugs while on program
 |  | and/or refused an alcohol or drug test during the reporting period
 |  | Number of DUI offenders that have used alcohol and/or drugs while on the
 |  | program and/or refused an alcohol or drug test during the reporting period
 |  | Number of program participants that committed a new misd. [NAME] while
 |  | on program during the reporting period (See Offender info for individual accounts)
Spreadsheet: 847589d1698440793-athletics-spread-sheet-find-winner-athletics-spreadsheet-attempt-1-ans-2
Sheet: Overall

 |  |  |  |  | OVERALL POINTS
TIBROGARGAN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL |  | HOUSE | TOTAL
 |  |  |  |  |  |  |  |  | TIBROGARGAN
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL |  | COOCHIN
 |  |  |  |  |  |  |  |  | COONOWRIN
COOCHIN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
COONOWRIN | BOYS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
 | GIRLS | [NAME] | 9YRS | 10YRS | 11YRS | 12YRS | TOTAL
Spreadsheet: 864957d1712074736-index-based-on-more-than-2-collumns-exercitiu
Sheet: Sheet1

2024-01-07 00:00:00 | 2024-01-01 00:00:00 | 11 | 11 | 1 | 1 | 123 |  | TBI | Outbound | 0 | AHT | 5 | 0.001555802642530172
2024-01-07 00:00:00 | 2024-01-01 00:00:00 | 11 | 11 | 1 | 1 | 123 |  | TBI | Outbound | 0 | AHT | 5 | FORMULA
Spreadsheet: 182784d1348601053-consolidation-and-pivot-tables-template
Sheet: PLANNING

PLANNING
 |  |  |  |  |  |  | WORK ORDER |  | START DATE |  | COMPLETION DATE
Identifier | School | Boro | FY | Requestor | Manager | Contractor or Consultant | Request Submission Date | Date Assigned | Original Forecast Date | Actual Date | Original Forecast Date | Actual Date | STATUS & REMARKS | WIP
78962 | Project 1 | X | 2013 | [NAME] | [NAME] | 123 Corp | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 |  |  |  |  |  | Yes
55789 | Project 35 | K | 2013 | [NAME] | [NAME] | 321 Inc. | 2012-08-17 00:00:00 | 2012-08-22 00:00:00 |  | 2012-08-23 00:00:00 |  | 2012-08-23 00:00:00 |  | No
Spreadsheet: 870097d1716620583-i-need-help-on-multiple-vlookup-example-215-aligw
Sheet: Example #3

[NAME] | Product | Sales | [NAME]
[NAME] | Quiktrip | 120 | Commision
[NAME] | Hobo_Pantry | 30
[NAME] | Whole_Foods | 50
Raitha | Superamerica | 78
Alax | Burger_King | 89
[NAME] | Roche_Bros | 150
Cris | Aldi | 398
Luther | McDonalds | 199
Sebria | Subway | 45
[NAME] | Giant | 125
Flinto | Chickfila | 1.2
George | Tesoro_2go | 25.5
Hostil | Vons | 715
[NAME] | Sally_Beauty_Supply | 100
 |  | 120
 |  | 30
 |  | 50
 |  | 78
 |  | 89
 |  | 150
 |  | 398
 |  | 199
 |  | 45
 |  | 125
 |  | 1.2
 |  | 25.5
 |  | 715
 |  | 100
Spreadsheet: 205990d1357970504-selecting-multiple-items-in-a-list-danh-sach-nhap-lieu-
Sheet: Hotel

 |  |  | Sao | 1 | 2 | 3 | 4 | 5
 |  |  | Conditions | Internet | [NAME] | Swimming pool | Car park | Gym | Restaurant
 |  |  | Style | Thư giãn / Design / Shopping / Backpacker / City Trip / Công việc / Gia đình / Đồng quê / Sang trọng / [NAME] mạn / Thiên nhiên
 |  |  | [NAME] | Khách sạn | Nhà nghỉ | Resort
 |  |  | Payment | Tiền mặt | Thẻ visa | Thẻ master
STT | Hotel Name | Add | [NAME] | Website | [NAME] | Sao (1,2,3,4,5) | Price |  | Conditions | Style | [NAME] | Thanh toán | Description
 |  |  |  |  |  |  | High | Low
 |  |  |  |  |  |  |  |  |  |  |  |  | Hanoi Calypso Hotel cung cấp chỗ ở sang trọng tại khu mua sắm của [NAME]. Tại đây có Wi-Fi miễn [NAME] được trang bị [NAME]. Từ khách sạn đến Hồ Hoàn [NAME] chỉ mất 5 phút tản bộ. Được trang trí với các gam màu trung tính dễ chịu, các phòng máy lạnh đầy phong cách của Calypso [NAME] có đồ nội thất bằng gỗ cổ điển [NAME]. Ấm đun nước điện và tủ lạnh cũng được cung cấp ngay trong phòng. Hanoi Calypso Hotel cách Sân bay Quốc tế [NAME] phút lái xe và từ khách sạn đến Ga Hà Nội mất 10 phút lái xe. Khách có thể đi tham quan quanh Hà Nội một cách dễ [NAME] dịch vụ tour và đặt vé có tại đây. [NAME] ra, xe đạp [NAME] cũng được cho thuê tại Calypso. Sau 1 ngày hoạt động, khách có thể thư giãn với dịch vụ [NAME] nhẹ nhàng. Vô tuyến [NAME], vệ tinh, [NAME] trang điểm, Điều hòa, Tủ lạnh, [NAME] thoại liên lạc trực tiếp quốc tế, [NAME] tính truy cập Internet, điều hòa, [NAME] tắm, Bồn tắm và [NAME] sen riêng trong phòng, [NAME] sấy tóc trong phòng, Tường cách âm, [NAME] pha, Bàn ghế, Đầy đủ các đồ phục vụ vệ sinh cá nhân, [NAME] mới, Ăn sáng,hoa quả.
Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: Icon Water Spec

 |  |  | 2019-11-24 00:00:00
 |  | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 |  | 1 | Trench Backfill | 4928 |  |  |  | 4928
 |  | 2 | Embedment | 7392
 |  |  | Project Total
 |  |  |  | Subtotal of This Invoice
 |  |  |  | GST
 |  |  |  | Invoice Total (Including GST)
 |  | Revised Fee | 2019-12-18 00:00:00
 |  | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 |  | 1 | Trench Backfill | 4928 |  |  | 4928 | 0
 |  | 2 | Embedment | 12152 |  |  |  | 12152
 |  | 3 | Update of relevant MITS documents | 5620 |  |  |  | 4496
 |  |  | Project Total
 |  |  |  | Subtotal of This Invoice
 |  |  |  | GST
 |  |  |  | Invoice Total (Including GST)
 |  |  | 2020-06-29 00:00:00
 |  | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 |  | 1 | Trench Backfill | 4928 |  |  | 4928 | 0
 |  | 2 | Embedment | 12152 |  |  | 12152 | 0
 |  | 3 | Update of relevant MITS documents | 5620 |  |  | 4496 | 1124
 |  |  | Project Total
 |  |  |  | Subtotal of This Invoice
 |  |  |  | GST
 |  |  |  | Invoice Total (Including GST)
Spreadsheet: monique_sanchez__28297__2002HM
Sheet: Sheet1

Date | Week | Sun | Mon | Tue | Wed | Thur | Fri | Sat |  | Total
2001-05-13 00:00:00 |  | OFF | cross | 3 | cross | 3 | cross | 3
2001-05-20 00:00:00 |  | cross |  | 3 |  | 3 | cross | 3
2001-05-27 00:00:00 |  | cross |  | 3 |  | 3 | cross | 4
2001-06-03 00:00:00 |  | cross | 1 | 3 | 1 | 3 | cross | 4
2001-06-10 00:00:00 |  | cross | 1 | 3 | 1 | 3 | cross | 4
2001-06-17 00:00:00 |  | cross | 1 | 3 | 1 | 3 | cross | 5
2001-06-24 00:00:00 |  | cross | 1 | 3 | 1 | 3 | cross | 5
2001-07-01 00:00:00 |  | cross | 1 | 3 | 1 | 4 | cross | 5
2001-07-08 00:00:00 |  | cross | 1 | 3 | 1 | 4 | cross | 6
2001-07-15 00:00:00 |  | cross | 1 | 3 | 1 | 4 | cross | 6
2001-07-22 00:00:00 |  | cross | 1 | 3 | 1 | 4 | cross | 6
2001-07-29 00:00:00 |  | cross | 2 | 4 | 2 | 5 | cross | 7
2001-08-05 00:00:00 |  | cross | 2 | 4 | 2 | 5 | cross | 7
2001-08-12 00:00:00 |  | cross | 2 | 4 | 2 | 5 | cross | 7
2001-08-19 00:00:00 |  | cross | 2 | 4 | 2 | 5 | cross | 8
2001-08-26 00:00:00 |  | cross | 2 | 5 | 2 | 6 | cross | 8
2001-09-02 00:00:00 |  | cross | 2 | 5 | 2 | 6 | cross | 8
2001-09-09 00:00:00 |  | cross | 2 | 5 | 2 | 6 | cross | 9
2001-09-16 00:00:00 | 19 | cross | 2 | 5 | 2 | 6 | cross | 9
2001-09-23 00:00:00 | 18 | cross | 3 m run | 5 m run | 3 m run | 5 m pace | cross | 10
2001-09-30 00:00:00 | 17 | cross | 3 m run | 5 m run | 3 m run | 5 m run | cross | 11
2001-10-07 00:00:00 | 16 | cross | 3 m run | 6 m run | 3 m run | 6 m pace | cross | 8
2001-10-14 00:00:00 | 15 | cross | 3 m run | 6 m run | 3 m run | 6 m pace | cross | 13
2001-10-21 00:00:00 | 14 | cross | 3 m run | 7 m run | 3 m run | 7 m run | cross | 14
2001-10-28 00:00:00 | 13 | cross | 3 m run | 7 m run | 3 m run | 7 m pace | cross | 10
2001-11-04 00:00:00 | 12 | cross | 4 m run | 8 m run | 4 m run | 8 m pace | cross | 16
2001-11-11 00:00:00 | 11 | cross | 4 m run | 8 m run | 4 m run | 8 m run | cross | 17
2001-11-18 00:00:00 | 10 | cross | 4 m run | 9 m run | 4 m run | 9 m pace | cross | 12
2001-11-25 00:00:00 | 9 | cross | 4 m run | 9 m run | 4 m run | 9 m pace | cross | 19
2001-12-02 00:00:00 | 8 | cross | 5 m run | 10 m run | 5 m run | 10 m run | cross | 20
2001-12-09 00:00:00 | 7 | cross | 5 m run | 6 m run | 5 m run | 6 m pace | cross | 12
2001-12-16 00:00:00 | 6 | cross | 5 m run | 10 m run | 5 m run | 10 m pace | cross | 20
2001-12-23 00:00:00 | 5 | cross | 5 m run | 6 m run | 5 m run | 6 m run | cross | 12
2001-12-30 00:00:00 | 4 | cross | 5 m run | 8 m run | 5 m run | 10 m pace | cross | 20
2002-01-06 00:00:00 | 3 | cross | 5 m run | 5 m run | 5 m run | 4 m pace | cross | 12
2002-01-13 00:00:00 | 2 | cross | 4 m run | 6 m run | 4 m run | 4 m run | cross | 8
2002-01-20 00:00:00 | 1 | cross | 3 m run | 4 m run | rest | 2 m run | cross | race
Spreadsheet: 826299d1681918616-need-help-with-multiple-formulas-on-a-single-column-sample-1-3-aligw
Sheet: Sheet1

Age | Favorite # | Eligible | Reasoning
18 | 7
17 | 10
21 | 1
23 | 3
24 | 7
19 | 8
15
Spreadsheet: 808855d1670708612-summary-pivot-table-from-more-extensive-data-sample
Sheet: Sheet1

Date | Action | Name1 | [NAME]
2023-01-02 00:00:00 | Booked | [NAME] | [NAME] |  |  | Date | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2023-01-03 00:00:00 | Booked | [NAME] | [NAME] |  |  | 2023-01-02 00:00:00 | Booked |  |  | Booked
2023-01-03 00:00:00 | None | [NAME] | [NAME] |  |  | 2023-01-03 00:00:00 | None | Booked | None | None | Booked | None
2023-01-03 00:00:00 | None | [NAME] | [NAME] |  |  | 2023-01-04 00:00:00 | Booked | Booked |  | Booked |  | Booked
2023-01-04 00:00:00 | Booked | [NAME] | [NAME] |  |  | 2023-01-05 00:00:00 | Maybe | None | Maybe | Maybe | None | Maybe
2023-01-04 00:00:00 | Booked | [NAME] | [NAME] |  |  | 2023-01-06 00:00:00 | Booked | Maybe | Booked | Maybe | Booked | Booked
2023-01-05 00:00:00 | None | [NAME] | [NAME]
2023-01-05 00:00:00 | Maybe | [NAME] | [NAME]
2023-01-05 00:00:00 | Maybe | [NAME] | [NAME]
2023-01-06 00:00:00 | Booked | [NAME] | [NAME]
2023-01-06 00:00:00 | Maybe | [NAME] | [NAME]
2023-01-06 00:00:00 | Booked | [NAME] | [NAME]
Spreadsheet: 792421d1660895828-multiple-key-word-match-book4
Sheet: Sheet1

DESC | RESULT |  |  | KEY 1 | KEY 2 | RESULT
BEARING, BALL, SINGLE ROW 6311-Z | BEARING,BALL |  |  | BEARING | BALL | BEARING,BALL
BEARING, BALL, SKF 6004-2Z | BEARING,BALL |  |  | BEARING | ROLLER | BEARING,ROLLER
BEARING, BALL, SKF 6201 | BEARING,BALL |  |  | BEARING | THRUST | BEARING,THRUST
BEARING, BALL, SKF 6202-2Z | BEARING,BALL
BEARING,ROLLER,SPL 22217 KBX | BEARING,ROLLER
Thrust jdfjfjf 37373 bearing fkjfk
Spreadsheet: 153798d1336057961-change-information-in-one-sheet-and-automtically-also-in-other-sheets-keis386
Sheet: Sheet2

 | Sheet1
Spreadsheet: 127447d1320349179-pivot-table-report-help-test-7-ccm-reporting-sumproduct
Sheet: A data entry

ID | Reporting Quarter | Reporting Period | Target | Site |  |  |  | P 1
984 | Q 1 | P 1 | Yes | A |  |  |  | P 2
654 | Q 1 | P 1 | Yes | A |  |  |  | P 3
7546 | Q 1 | P 1 | NO | A |  |  |  | P 4
5324 | Q 2 | P 1 | Yes | A |  |  |  | P 5
35234 | Q 2 | P 2 | Yes | A |  |  |  | P 6
523423 | Q 2 | P 3 | Yes | A |  |  |  | P 7
235 | Q 3 | P 1 | Yes | A |  |  |  | P 8
3424 | Q 3 | P 1 | Yes | A |  |  |  | P 9
343 | Q 1 | P 4 | Yes | A |  |  |  | P 10
23534 | Q 1 | P 5 | Yes | A |  |  |  | P 11
 |  |  |  |  |  |  |  | P 12
 |  |  |  |  |  |  |  | P 13
Spreadsheet: 730384d1619684484-extracting-and-arranging-data-salary-1-ans-4
Sheet: Expected Result

 |  | JVN0711 | JVN0711 | JVN0711 | JVN0084 | JVN0084 | JVN0084
 |  | Salary | PF | GT | Salary | PF | GT
Spreadsheet: 89280d1289039639-excel-2007-creating-a-formula-for-lookup-example-1-_naifu
Sheet: Sheet1

Value1 | Value2 | Value3 | Value4 | Value5 | Person
16 | 44 | 34 | 3 | 36 | [NAME]
33 | 24 | 44 | 27 | 3 | [NAME]
8 | 40 | 8 | 48 | 38 | [NAME]
21 | 32 | 12 | 19 | 7 | [NAME]
20 | 1 | 42 | 26 | 12 | [NAME]
13 | 16 | 34 | 9 | 35 | [NAME]
6 | 20 | 25 | 48 | 33 | [NAME]
20 | 4 | 32 | 32 | 10 | [NAME]
44 | 32 | 34 | 42 | 25 | [NAME]
15 | 4 | 49 | 16 | 6 | L. Platter
33 | 43 | 9 | 1 | 36 | T. Douglas
31 | 1 | 2 | 48 | 40 | O. Pondexter
39 | 30 | 11 | 26 | 43 | [NAME]
3 | 26 | 26 | 36 | 46 | [NAME]
5 | 37 | 50 | 22 | 33 | [NAME]
8 | 39 | 40 | 43 | 1 | E. House
5 | 10 | 10 | 45 | 25 | T. Boon
Spreadsheet: 37504d1235538416-summarise-data-after-applying-allocation-split-book8
Sheet: Summary

 | Task: to summarise the GLData data into the Plant codes by month applying the allocations from the AllocationsMatrix. Example: the data in GLData!I7 has to be allocated across the Processes as per the AllocationsMatrix split for GL Code 76400 (GLData!C7) down through all 500 lines for January, and across all the Plants.
 |  |  |  | 2008-07-31 00:00:00 | 2008-08-31 00:00:00 | 2008-09-30 00:00:00 | 2008-10-31 00:00:00 | 2008-11-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00
 | Process | Plant | Trans
 | Advanced Oxidation | 120 | 0000
 | Microfiltration | 120 | 0000
 | Post Treatment & Stabilisation | 120 | 0000
 | Pre-Treatment | 120 | 0000
 | Raw Water Storage | 120 | 0000
 | ROC Treatment & Disposal | 120 | 0000
 | Sludge Treatment & Disposal | 120 | 0000
 | Reverse Osmosis | 120 | 0000
 | Advanced Oxidation | 121 | 0000
 | Microfiltration | 121 | 0000
 | Post Treatment & Stabilisation | 121 | 0000
 | Pre-Treatment | 121 | 0000
 | Raw Water Storage | 121 | 0000
 | ROC Treatment & Disposal | 121 | 0000
 | Sludge Treatment & Disposal | 121 | 0000
 | Reverse Osmosis | 121 | 0000
 | Advanced Oxidation | 122 | 0000
 | Microfiltration | 122 | 0000
 | Post Treatment & Stabilisation | 122 | 0000
 | Pre-Treatment | 122 | 0000
 | Raw Water Storage | 122 | 0000
 | ROC Treatment & Disposal | 122 | 0000
 | Sludge Treatment & Disposal | 122 | 0000
 | Reverse Osmosis | 122 | 0000
Spreadsheet: 3695fb07-1c77-4d57-958c-e00d5c2d9f33
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43483712 | 2014-10-07 23:16:57 | AXIS | 1 | 6 | 5 | 959603 | TommyGuts | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43510557 | 2014-10-09 22:28:44 | ALLIES | 0 | 1 | 6 | 701256 | player701256 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43510912 | 2014-10-09 22:57:44 | AXIS | 1 | 6 | 4 | 946197 | Groka | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
43511270 | 2014-10-09 23:16:05 | ALLIES | 1 | 6 | 2 | 668571 | Jf Orion | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
43536260 | 2014-10-11 18:33:38 | AXIS | 0 | 5 | 6 | 1576877 | Tjk33 | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
43579327 | 2014-10-14 16:44:23 | ALLIES | 1 | 6 | 5 | 845465 | player845465 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43654115 | 2014-10-19 23:33:23 | ALLIES | 0 | 5 | 7 | 1609999 | ArchNME | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 66111d1266825806-multi-level-bill-of-material-717631_neorez-3-
Sheet: formulas

Products | Ingredients | %
Yellow 13 ink | Yellow 13 Base | 0.55
Yellow 13 ink | Varnish 4347 | 0.32
Yellow 13 ink | IA 10 | 0.02
Yellow 13 ink | [NAME] | 0
Yellow 13 ink | Acetate | 0.09
Yellow 13 ink | Ethanol
Yellow 13 Base | Pigment Yellow 13 | 0.2
Yellow 13 Base | [NAME] | 0.3
Yellow 13 Base | DBP | 0.02
Yellow 13 Base | S 22000 | 0.002
Yellow 13 Base | S 54000 | 0.012
Yellow 13 Base | [NAME] | 0.048
Yellow 13 Base | Acetate | 0.06
Yellow 13 Base | Ethanol
Varnish 4347 | [NAME] | 0.6
Varnish 4347 | U-347 | 0.25
Varnish 4347 | Ethanol
Varnish 4347 | Acetate | 0.11667
[NAME] | NC dry | 0.3
[NAME] | Ethanol
Spreadsheet: 741724d1627300847-need-help-with-inventory-of-raw-material-items-example-sheet-mod1
Sheet: MFG

MFG Date | Product Batch No | Product | RM Batch No | Ingredients | RM Qnty Used | RM Remain | Exceed
2021-04-11 00:00:00 | PB1101 | Pistachio Biscuit |  | Sugar | 100
2021-04-11 00:00:00 | AB102 | Almond Biscuit |  | Sugar | 202
2021-04-12 00:00:00 | BM103 | Black Magic Cake | ? | Sugar | 50