tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 789120d4-78ac-4636-a4a0-75f734b59887
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
43482977 | 2014-10-07 22:16:28 | ALLIES | 1 | 6 | 5 | 1651051 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43483290 | 2014-10-07 22:33:40 | AXIS | 1 | 6 | 5 | 1651051 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43497178 | 2014-10-08 22:26:10 | AXIS | 1 | 4 | 1 | 550759 | Dunkel_ | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
43639261 | 2014-10-19 00:18:12 | ALLIES | 1 | 6 | 1 | 1652741 | sabina.piotr.wojtowicz | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43639819 | 2014-10-19 00:56:50 | AXIS | 0 | 3 | 6 | 959603 | TommyGuts | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
43640002 | 2014-10-19 01:19:13 | ALLIES | 0 | 2 | 6 | 959603 | TommyGuts | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
43654313 | 2014-10-19 23:44:36 | ALLIES | 1 | 6 | 3 | 144495 | camwhit | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
Spreadsheet: 116344d1311770175-lesson-reservation-calendar-frungy-sample-lesson-record-20110727
Sheet: Lesson Record

ELT | Departs | Where | Length | Start Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total Lessons? |  | FIRST CHECK | MID-CHECK | FINAL CHECK | Month
NAME | Departs | Where | Length | Start Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total Lessons? |  | FIRST CHECK | MID-CHECK | FINAL CHECK | Month
SAKAMOTO, RYUICHI | 2011-11-03 00:00:00 | Phili | 3m | 2011-07-11 00:00:00 | 2011-07-11 00:00:00 |  | 2011-05-05 00:00:00 |  |  | 2011-07-23 00:00:00 |  |  |  |  |  |  | 12 |  | 2011-04-26 00:00:00
SASAKI, LISA | 2012-01-04 00:00:00 | USA | 2w | 2011-05-25 00:00:00 | 2011-05-25 00:00:00 | 2011-06-03 00:00:00 | 2011-06-10 00:00:00 |  |  | 2011-07-23 00:00:00 |  | 2011-06-08 00:00:00 |  |  |  |  | 6 |  | 2011-05-02 00:00:00 |  | -
YAMAMOTO, TARO | 2011-10-01 00:00:00 | CND | 1yWH | 2011-07-20 00:00:00 | 2011-07-20 00:00:00 |  | 2011-07-27 00:00:00 |  |  |  |  |  |  |  |  |  | 12 |  | 2011-02-15 00:00:00
Spreadsheet: 786789d1657444549-conditional-date-formula-test
Sheet: Sheet1

Number | Task type | Priority | Created | Location | Opened by | Assigned to | State | Short description | Updated | Needs attention | Due date | Closed | Closed by | SLA due | Tags | Resolved / Closed | Created Month | Closed Month | Created Week | Closed Week |  | IF |  | THEN, Column Q=
 | Request | 4 - Low | 2022-07-08 15:30:53 |  |  |  | Closed [NAME] |  | 2022-07-08 19:04:32 | False |  | 2022-07-08 19:04:32 |  |  |  |  |  |  |  |  |  | H2= | Closed [NAME] | M2
 | Request | 4 - Low | 2022-07-08 12:58:59 |  |  |  | Work in Progress |  | 2022-07-08 14:04:28 | False |  |  |  |  |  |  |  |  |  |  |  |  | Closed Incomplete | M2
 | Incident | 2 - High | 2022-07-08 12:44:45 |  |  |  | Resolved |  | 2022-07-08 20:03:14 | False |  |  |  |  |  |  |  |  |  |  |  |  | Closed Skipped | M2
 | Incident | 2 - High | 2022-07-08 10:15:18 |  |  |  | On Hold |  | 2022-07-08 17:12:21 | False |  |  |  |  |  |  |  |  |  |  |  |  | Resolved | J2
 | Incident | 2 - High | 2022-07-01 22:29:50 |  |  |  | Closed |  | 2022-07-08 23:00:20 | False |  | 2022-07-08 23:00:20 |  |  |  |  |  |  |  |  |  |  | Closed | M2-7
 | Problem | 3 - Moderate | 2022-06-29 09:57:50 |  |  |  | Root Cause Analysis |  | 2022-06-29 09:59:21 | False |  |  |  |  |  |  |  |  |  |  |  |  | Work in Progress | Blank
 | Request | 4 - Low | 2021-10-11 07:21:30 |  |  |  | Closed Incomplete |  | 2021-10-11 08:00:06 | False |  | 2021-10-11 08:00:06 |  |  |  |  |  |  |  |  |  |  | On Hold | Blank
 | Incident Task | 4 - Low | 2021-09-27 10:39:33 |  |  |  | Closed Skipped |  | 2021-10-01 07:13:17 | False |  | 2021-10-01 07:13:17 |  |  |  |  |  |  |  |  |  |  | Root Cause Analysis | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Although reference fileds are blank, yet date appears. Date should appear only if data is entered in reference cells, if not it should be a blank cell.
Spreadsheet: 837320d1690041126-excel-exercises-excel-exercise-1
Sheet: Part 1

Part 1 - site performance
 |  |  |  |  |  |  | Question 1
 | This table contains trading information for a group of 21 restaurants.
 |  |  |  |  |  |  |  | Please can you find the total revenue for each location, using a formula:
 |  |  | Data table
 |  |  |  |  |  |  |  | Location | Revenue
 | Site Code | Location | Revenue (£) | Opening date |  |  |  | London
 | 1 | London | 836113 | 2022-01-22 00:00:00 |  |  |  | South East
 | 2 | London | 184567 | 2020-11-02 00:00:00 |  |  |  | Midlands
 | 3 | Midlands | 48781 | 2022-10-21 00:00:00 |  |  |  | North East
 | 4 | South East | 177616 | 2020-07-05 00:00:00 |  |  |  | South West
 | 5 | South West | 771892 | 2021-05-03 00:00:00 |  |  |  | Total
 | 6 | London | 769732 | 2020-11-12 00:00:00
 | 7 | South East | 648258 | 2021-03-15 00:00:00 |  |  | Question 2
 | 8 | London | 689268 | 2020-08-20 00:00:00
 | 9 | Midlands | 139906 | 2020-02-21 00:00:00 |  |  |  | Please can you find out the Revenue for each location & opening year using the SUMIFS formula.
 | 10 | South East | 85454 | 2021-03-22 00:00:00
 | 11 | London | 378899 | 2020-12-13 00:00:00 |  |  |  | Gross Profit:
 | 12 | South East | 990738 | 2021-09-17 00:00:00
 | 13 | South East | 546533 | 2021-10-27 00:00:00 |  |  |  |  | Year of opening
 | 14 | London | 405026 | 2020-12-20 00:00:00 |  |  |  | Location | 2020 | 2021 | 2022
 | 15 | Midlands | 442637 | 2020-09-11 00:00:00 |  |  |  | London
 | 16 | London | 505163 | 2021-11-21 00:00:00 |  |  |  | South East
 | 17 | North East | 428145 | 2020-05-27 00:00:00 |  |  |  | Midlands
 | 18 | North East | 596014 | 2021-10-16 00:00:00 |  |  |  | North East
 | 19 | South West | 966837 | 2020-12-18 00:00:00 |  |  |  | South West
 | 20 | Midlands | 628770 | 2020-08-27 00:00:00 |  |  |  | Total
 | 21 | South West | 35213 | 2022-04-15 00:00:00
 | Total
 |  |  |  |  |  |  | Question 3
 |  |  |  |  |  |  |  | Can you please create a pivot table to display the information requested in Question 2.
 |  |  |  |  |  |  |  | Row Labels | Sum of 2020 | Sum of 2021 | Sum of 2022
 |  |  |  |  |  |  |  | London | 2427492 | 505163 | 836113
 |  |  |  |  |  |  |  | Midlands | 1211313 | 0 | 48781
 |  |  |  |  |  |  |  | North East | 428145 | 596014 | 0
 |  |  |  |  |  |  |  | South East | 177616 | 2270983 | 0
 |  |  |  |  |  |  |  | South West | 966837 | 771892 | 35213
 |  |  |  |  |  |  |  | Total | 5211403 | 4144052 | 920107
 |  |  |  |  |  |  |  | Grand Total | 10422806 | 8288104 | 1840214
Spreadsheet: ea9ccc84-d303-47ae-9f77-e98fd1f88530
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3222 | 13298 | [NAME] | [NAME] | GBR | 701 | [NAME] | 00:01:26 | 01:14:28 | 00:00:52 | 00:40:59 | 1 | 02:18:10
Spreadsheet: 807374d1669875480-workday-intl-formula-not-excluding-sundays-projected-completion-time
Sheet: Sayfa1

 | Product Name | Start Time |  | Estimated Completion Time | Finish Time |  | [NAME] |  | Production Per Hour |  | Shift Time
 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 08:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:30:00 | 11:30:00 | 19:00:00
 |  |  |  |  |  |  |  |  |  |  | 08:00:00 | 16:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00 | 12:30:00 | 20:00:00
 | Product A | 2022-11-27 00:00:00 |  |  |  |  | 1000000 |  | 15000
Spreadsheet: 292584d1390673271-recalculate-using-two-different-formulas-in-same-cell-sample
Sheet: Explanation

Example | Conversion Table
 | Length = | 2.3 |  |  | [NAME] | 56 |  |  | Time= | 5
 | Cms-> | Inches |  |  | Kg-> | [NAME] |  |  | Hour-> | Minutes
 | Cms-> | Millimeters |  |  | Kg-> | Pounds |  |  | Minutes-> | Seconds
 | Cms-> | Meters |  |  | Grams-> | Kgs |  |  | Seconds-> | Minutes
 |  |  |  |  | Grams-> | Pounds |  |  | Hours-> | Seconds
 |  |  |  |  | Pounds-> | [NAME] |  |  | Minutes-> | Hours
 |  |  |  |  | Pounds-> | Kgs |  |  | Seconds-> | Hours
 | This being the a sample conversion table, where all conversions (will be included shortly) for a unit quantity are housed, taking these values as reference, the final values in Sheet1 have to change as explained in sheet 1 (Also See Sheet 1)
Spreadsheet: john_lavorato__16496__OGC Cheques - 2000
Sheet: Penney Gaul

Order of [NAME]
Donations for deputy | [NAME]
CompanyName | FirstName | Initial | LastName | As it appears in the Brochure… | Address 1 | Address2 | City | Province | PostalCode | Donation | Category | Tax Receipt to Individual? | notes | Deputy | website address
 | H. Penney |  | Gaul | [NAME] | 418 12 St NW |  | Calgary | AB | T2N 148 | 500 | < 1000 | Y |  | [NAME]
 | [NAME] |  | Emms | [NAME], Financial Concept Group | c/o Financial Concept Group | 230, 1414 8 St SW | Calgary | AB | T2R 1J6 | 250 | < 1000 | Y |  | [NAME]
Spreadsheet: 133500d1324424418-excel-2007-menu-greyed-out-productdb
Sheet: 04 Bulbs

EAD SKU # | [NAME], V AC | Power, Watts | [NAME] | Items/cs | Weight, kg/Case | Cost Price, $ | Sell Price, Case | Image | Source
EA0401 | 95 - 295 | 3 | 330 | 30 | 5.2 | 5.6 |  |  | 3
EA0402 | 95 - 295 | 4.5 | 420 | 30 | 5.3 | 8 |  |  | 3
EA0403 | 95 - 295 | 5 | 550 | 30 | 5.3 | 8.7 |  |  | 3
EA0404 | 95 - 295 | 9 | 850 | 30 | 5.5 | 19 |  |  | 3
EA0405 | 95 - 295 | 12 | 1150 | 30 | 5.7 | 21 |  |  | 3
EA0406 | 95 - 295 | 15 | 1450 | 30 | 5.8 | 25 |  |  | 3
EA0407 | 95 - 295 | 20 | 2070 | 30 | 6 | 30 |  |  | 3
Spreadsheet: 689575d1596526294-is-countif-the-correct-function-to-match-a-substring-in-a-range-to-a-selected-value-excelforum
Sheet: OrderConf

 |  | ORDER CONFIRMATION
 | Attn:    Mr. |  |  |  | OC #: | 0685-2021-CF-034-A
 | Customer: |  |  |  | OC Date:
 | Address: |  |  |  | Your PO:
 | City: |  |  |  | Offer #:
 | Delivery: | Within May 2020 |  |  | YYY:
 | Dear Sirs
 | We refer to your mail dated XXX, for your requirement of XXX Fans. We are pleased to confirm your order as under. ……….
 | Itemcode | [NAME] | Description | Qty | Unit Price | Total | Column1
 |  |  |  |  |  |  | MODIFIED FORMULA 1 IN COLUMN D
 |  |  |  |  |  |  | MODIFIED FORMULA 2 IN COLUMN D
 |  |  |  |  |  |  | ORIGINAL FORMULA IN COLUMN D
 |  |  |  |  | OC Total
Spreadsheet: 76031d1276618096-calculate-an-average-using-multiple-criteria-on-2-worksheets-avg-ppl
Sheet: Sheet1

Average of PPL | Period
Vendor | Sept 2009 | Oct 2009 | Nov 2010 | Mar 2010 | July 2010 | Jan 2011 | Grand Total
Vendor A | 0.8765 |  |  |  | 0.8767 |  | 0.8765999999999999
Vendor B |  | 0.7867 |  | 0.7689 |  |  | 0.7777999999999999
Vendor C |  |  | 0.7889 |  |  | 0.7867 | 0.7878000000000001
Grand Total | 0.8765 | 0.7867 | 0.7889 | 0.7689 | 0.8767 | 0.7867 | 0.8140666666666666
Spreadsheet: 837452d1690192617-can-you-do-a-sum-and-vlookup-or-index-match-across-multiple-rows-columns-example-46-
Sheet: P1

 | Act |  |  |  |  |  |  | Actual
Resources | 2023-01-07 00:00:00
Smith, Richie | 0.5 | 0 | 5 | 1.5
Tachett, [NAME] | 0 | 0 | 0.5 | 0.5
Wamby, Bradley | 0 | 0 | 3 | 12
Weekly Adjustments (+/-)
AEW
Spreadsheet: 136916d1326887206-graph-data-updates-graph-last-13
Sheet: Sheet1

23
27
1
23
23
12
18
8
26
16
22
3
17
23
23
9
20
23
2
22
17
1
28
19
1
30
2
5
22
22
13
26
13
30
13
25
Spreadsheet: cara_semperger__1456__ENA_PGE_DEC20_2001
Sheet: JD-MAL TRANS

From: | EPMI
To: | PGE System Transactions
Date:
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  | Total In To PGE Trans
0100 |  |  | 24 | 25
0200 |  |  | 24 | 25
0300 |  |  | 24 | 25
0400 |  |  | 24 | 25
0500 |  |  | 24 | 25
0600 |  |  | 24 | 25
0700 | 25 | 46
0800 | 25 | 46
0900 | 25 | 46
1000 | 25 | 46
1100 | 25 | 46
1200 | 25 | 46
1300 | 25 | 46
1400 | 25 | 46
1500 | 25 | 46
1600 | 25 | 46
1700 | 25 | 46
1800 | 25 | 46
1900 | 25 | 46
2000 | 25 | 46
2100 | 25 | 46
2200 | 25 | 46
2300 |  |  | 24 | 25
2400 |  |  | 24 | 25
 | BPA(G) FS | [NAME]) FS | BPA(G) C#23617 & 23622 | BPA(G) [NAME]
 | EPMI(PSE) | BCH(T) BCH/BCUS | EPMI (PSE) | EPMI (PSE)
 | SNPD(PSE) | PWX(PSE) | SNPD(PSE) | SNPD(PSE)
 | BPA(T)BPAP/JD | ALCOA(PSE) | BPA(T)BPAP/JD | BPA(T)BPAP/JD
 | SNPD(PSE) | BPA(T) BPAP/JD | SNPD(PSE) | SNPD(PSE)
 | EPMI(PSE) | ALCOA(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PWX(PSE) | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | DYPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | SPP(PSE) | EPMI(PSE) | CISO(T)MAL5/NP15 | BPA(PSE)
 | PPW(T) MAL5/MAL 2 | PGE(T)JD/MAL5 | EPMI(PSE) | AEP(PSE)
 | BPA(T)MAL2/HILLTOP | EPMI(PSE) | EPMI (L, FS) CISO(CA) | SMUD (PSE)
 | SPP(L, FS) CISO (CA) | CISO(T)MAL5/NP15 |  | SMUD(T) MAL5/NP15
 |  | EPMI(PSE) |  | SMUD (L, FS) CISO (CA)
 |  | EPMI (L, FS) CISO(CA)
Spreadsheet: 858760d1707325552-help-sumif-multiple-tabs-example1
Sheet: February Group

 | Name | Reference | Recall 1 | Recall 2 | Recall 3 | Successful Recall Date |  |  |  | Month Summary
 | Individual 15 | 04321 |  |  |  | 2024-05-01 00:00:00 |  |  |  |  |  | ( what results should show)
 | Individual 16 | 04322 |  |  |  | 2024-02-01 00:00:00 |  |  |  | Done Totals |  | 4 | (colum G, cells with a date)
 | Individual 17 | 04323
 | Individual 18 | 04324 |  |  |  |  |  |  |  | Outstanding Totals |  | 9 | (colum G, cells without a date)
 | Individual 19 | 04325
 | Individual 20 | 04326 |  |  |  | 2024-03-05 00:00:00
 | Individual 21 | 04327 |  |  |  | 2024-01-05 00:00:00
 | Individual 22 | 04328
 | Individual 23 | 04329
 | Individual 24 | 04330
 | Individual 25 | 04331
 | Individual 26 | 04332
 | Individual 27 | 04333
Spreadsheet: 270514d1381510395-create-list-based-on-criteria-and-is-unique-joannelittell
Sheet: Sheet1

 | Data |  |  |  |  |  |  |  |  |  |  |  | create the following list
 | CP | type | size | color | name | details | test | ConCat | Qualifier | Rank |  |  | CP | type | size | color | name | details
1 | CP1 | car | small | red | [NAME] | liked it | no |  |  |  |  | 1
2 | CP1 | car | small | red | [NAME] | liked it | no |  |  |  |  | 2
3 | CP1 | car | small | red | [NAME] | liked it | no |  |  |  |  | 3
4 | CP1 | car | small | blue | [NAME] | liked it | no |  |  |  |  | 4
5 | CP1 | van | large | red | [NAME] | accident | yes |  |  |  |  | 5
6 | CP1 | van | large | red | [NAME] | accident | yes |  |  |  |  | 6
7 | CP1 | car | small | blue | [NAME] | liked it | no |  |  |  |  | 7
8 | CP1 | van | large | purple | [NAME] | liked it | no |  |  |  |  | 8
9 | CP1 | van | large | purple | [NAME] | liked it | no |  |  |  |  | 9
10 | CP2 | truck | midsize | black | [NAME] | bumpy | yes |  |  |  |  | 10
11 | CP2 | truck | midsize | black | [NAME] | bumpy | yes |  |  |  |  | 11
12 | CP2 | truck | midsize | black | [NAME] | bumpy | yes |  |  |  |  | 12
13 | CP2 | truck | large | black | [NAME] | bumpy | no |  |  |  |  | 13
14 | CP2 | truck | large | black | [NAME] | bumpy | no |  |  |  |  | 14
15 | CP2 | truck | large | black | [NAME] | bumpy | no
16 | CP3 | van | small | grey | [NAME] | confortable | yes
17 | CP3 | van | small | grey | [NAME] | confortable | yes
18 | CP3 | van | small | grey | [NAME] | confortable | yes
19 | CP3 | van | small | grey | [NAME] | confortable | yes
Spreadsheet: 34658d1231967945-sumif-or-an-array-formula-matching-multiple-conditions-sums-sumif
Sheet: Sheet1

Details | 2007 | 2008
Ant. Oak - Flooring - Barnboard - Standard | 5612 | 3966
Ant. Oak - Flooring - Barnboard - Worn Edge | 9348 | 11133
Ant. Oak - Flooring - Beam-sawn Cabin - Standard | 10456 | 10921
Ant. Oak - Flooring - Cabin - Standard | 7955 | 5393
Ant. Oak - Flooring - Cabin - Worn Edge | 4308 | 8925
Ant. Oak - Flooring - Thresher - Standard | 10646 | 11067
[NAME] | 606 | 6946
[NAME] | 6331 | 6237
[NAME] | 2741 | 3123
Heart Pine - Flooring - Cabin - Standard | 1724 | 9404
Heart Pine - Flooring - Country - Standard | 752 | 9261
Heart Pine - Flooring - Naily - Standard | 11105 | 11074
Heart Pine - Flooring - Oily / Cabin - Standard | 890 | 11415
Heart Pine - Flooring - Premium - Standard | 7660 | 8750
Heart Pine - Flooring - Select - Standard | 7208 | 2209
Hickory - Flooring - Rustic - Standard | 2463 | 6988
[NAME] | 7294 | 4239
White Oak - Flooring - Rustic - Standard | 7331 | 7975
White Oak - Flooring - Wormy - Standard | 2958 | 6840
Ant. Oak - Lumber - Barnboard - | 5908 | 5516
Ant. Oak - Lumber - Beam-sawn - | 5238 | 8305
Chestnut - Lumber - Barnboard - | 9870 | 2307
Chestnut - Lumber - Thin B-B - | 1932 | 6295
Heart Pine - Lumber - Cabin - | 6016 | 63
Heart Pine - Lumber - Country - | 3084 | 11569
Heart Pine - Lumber - Country/Cabin - | 6096 | 2163
Heart Pine - Lumber - Mixed - | 2194 | 1072
Heart Pine - Lumber - Naily - | 7676 | 7540
Heart Pine - Lumber - Oily / Cabin - | 11012 | 3948
Heart Pine - Lumber - Oily/Naily - | 8751 | 10892
Heart Pine - Lumber - Prem/Select - | 9175 | 8427
Heart Pine - Lumber - Premium - | 9433 | 3027
Heart Pine - Lumber - Select - | 10327 | 2552
Heart Pine - Lumber - Select/Country - | 2665 | 7826
Hickory - Lumber - Rustic - | 443 | 3981
[NAME] | 9507 | 9770
Poplar - Lumber - 1 com - | 6264 | 7010
Poplar - Lumber - 2 com - | 4622 | 7771
[NAME] | 388 | 5067
[NAME] | 3084 | 11175
White Oak - Lumber - Rustic - | 9469 | 1001
White Oak - Lumber - Wormy - | 198 | 3851
Spreadsheet: 108763d1305744148-help-with-hiding-and-unhiding-a-chart-based-on-data-book1
Sheet: DATA

 | Customer | JAN | FEB | MAR | Total |  |  |  | Current selection
retail | A | 10 | 15 | 20 | 45 |  |  |  | 1 | A
 | B | 20 | 25 | 30 | 75
 | C | 30 | 35 | 40 | 105
commercial | A | 11 | 22 | 64 | 97
 | B | 58 | 11 | 13 | 82
 | C | 19 | 54 | 69 | 142
retail | A | 58 | 12 | 61 | 131
 | B | 41 | 88 | 45 | 174
 | C | 18 | 44 | 95 | 157
retail | A | 46 | 15 | 75 | 136
 | B | 49 | 35 | 15 | 99
 | C | 73 | 56 | 82 | 211
 | 1 | 125 | 64 | 220
Spreadsheet: 117691d1312968765-advanced-formula-for-linking-values-in-two-sheets-differ-under-conditions-help_request
Sheet: planning_days

LOB | 2011 | Person | Role
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 8v | 9 | 9v | 10 | 10v | 11 | 11v | 12 | 12v
 | Project 1 | [NAME] | Tester
 | Project 2 | [NAME] | Tester
 | Project 3 | [NAME]
 |  | [NAME]
 | Project 4 | [NAME]
 |  | [NAME]
 | Project 5 | [NAME] | Dev
 |  | [NAME] | Dev
 |  | [NAME] | Dev
 |  | [NAME] | Dev
 |  | [NAME] | Tester
 |  | Eva Poland | Tester
 |  | [NAME] | Tester
 |  | [NAME] | Analyst
Spreadsheet: 713129d1610562470-need-help-reformatting-data-possibly-expand-and-rotate-tablehelp
Sheet: Sheet1

Player | Team | Pos | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
[NAME] | TEN | WR | 0.81 |  |  |  | 0.71 | 0.84 | 0.93 | 0.95 | 0.82 | 0.75 | 0.81 | 0.81 | 0.86 | 0.56 | 0.84 | 0.76 | 0.9
A.J. Dillon | GB | RB | 0.06 | 0.1 |  | 0.05 |  | 0.16 | 0.23 | 0.13 |  |  |  |  |  |  | 0.08 | 0.58 | 0.11
A.J. Green | CIN | WR | 0.66 | 0.62 | 0.76 | 0.71 | 0.42 | 0.79 | 0.87 | 0.85 |  | 0.83 | 0.79 | 0.82 | 0.87 | 0.88 | 0.91 | 0.74 | 0.79
Player | Team | Pos | Index | Value
[NAME] | TEN | WR | 1 | 0.81
[NAME] | TEN | WR | 2
[NAME] | TEN | WR | 3
[NAME] | TEN | WR | 4
[NAME] | TEN | WR | 5 | 0.71
[NAME] | TEN | WR | 6 | 0.84
[NAME] | TEN | WR | 7 | 0.93
[NAME] | TEN | WR | 8 | 0.95
[NAME] | TEN | WR | 9 | 0.82
[NAME] | TEN | WR | 10 | 0.75
[NAME] | TEN | WR | 11 | 0.81
[NAME] | TEN | WR | 12 | 0.81
[NAME] | TEN | WR | 13 | 0.86
[NAME] | TEN | WR | 14 | 0.56
[NAME] | TEN | WR | 15 | 0.84
[NAME] | TEN | WR | 16 | 0.76
[NAME] | TEN | WR | 17 | 0.9
A.J. Dillon | GB | RB | 1 | 0.06
A.J. Dillon | GB | RB | 2 | 0.1
A.J. Dillon | GB | RB | 3
A.J. Dillon | GB | RB | 4 | 0.05
A.J. Dillon | GB | RB | 5
A.J. Dillon | GB | RB | 6 | 0.16
A.J. Dillon | GB | RB | 7 | 0.23
A.J. Dillon | GB | RB | 8 | 0.13
A.J. Dillon | GB | RB | 9
A.J. Dillon | GB | RB | 10
A.J. Dillon | GB | RB | 11
A.J. Dillon | GB | RB | 12
A.J. Dillon | GB | RB | 13
A.J. Dillon | GB | RB | 14
A.J. Dillon | GB | RB | 15 | 0.08
A.J. Dillon | GB | RB | 16 | 0.58
A.J. Dillon | GB | RB | 17 | 0.11
A.J. Green | CIN | WR | 1 | 0.66
A.J. Green | CIN | WR | 2 | 0.62
A.J. Green | CIN | WR | 3 | 0.76
A.J. Green | CIN | WR | 4 | 0.71
A.J. Green | CIN | WR | 5 | 0.42
A.J. Green | CIN | WR | 6 | 0.79
A.J. Green | CIN | WR | 7 | 0.87
A.J. Green | CIN | WR | 8 | 0.85
A.J. Green | CIN | WR | 9
A.J. Green | CIN | WR | 10 | 0.83
A.J. Green | CIN | WR | 11 | 0.79
A.J. Green | CIN | WR | 12 | 0.82
A.J. Green | CIN | WR | 13 | 0.87
A.J. Green | CIN | WR | 14 | 0.88
A.J. Green | CIN | WR | 15 | 0.91
A.J. Green | CIN | WR | 16 | 0.74
A.J. Green | CIN | WR | 17 | 0.79
Spreadsheet: 885924d1735843919-returning-date-with-date-sequence-01-02-2025-date-sequence-count
Sheet: Sheet1

Dates | [NAME] | Desired Results
2025-01-06 00:00:00 |  | 2025-01-06 00:00:00
2025-01-06 00:00:00 |  | 1/6/2025-2
2025-01-07 00:00:00 |  | 2025-01-07 00:00:00
2025-01-07 00:00:00 |  | 1/7/2025-2
2025-01-07 00:00:00 |  | 1/7/2025-3
2025-01-07 00:00:00 |  | 1/7/2025-4
2025-01-07 00:00:00 |  | 1/7/2025-8
2025-01-08 00:00:00 |  | 2025-01-08 00:00:00
2025-01-10 00:00:00 |  | 2025-01-10 00:00:00
Spreadsheet: 538523d1505682498-how-to-auto-add-students-grade-and-remarks-to-a-worksheet-score-to-grade-and-comment
Sheet: Grade Table

score to grades and comments
 |  | A1 | Excellent
 |  | B2 | Very Good
 |  | B3 | Good
 |  | C4 | Credit
 |  | C5 | Credit
 |  | C6 | Credit
 |  | D7 | Pass
 |  | D8 | Pass
 |  | F9 | Failed
Spreadsheet: 49610d1248966626-average-formula-for-a-specific-condition-averages-1-
Sheet: Sheet2

Name | Average Weekly Hours | Total Hours | Average Payrate |  | 2008-01-01 00:00:00
[NAME],[NAME] | 31.05666666666667 | 93.17 | 8 |  | 93.17 | 3 | 31.05666666666667 | 31.05666666666667
Doe,[NAME] | 28.50666666666667 | 85.52000000000001 | 8 |  | 85.52000000000001 | 3 | 28.50666666666667 | 28.50666666666667
Schmo,[NAME] | 20.88714285714286 | 146.21 | 8 |  | 146.21 | 7 | 20.88714285714286 | 20.88714285714286
 |  |  |  |  | total | count | average=total/count | or as one formula
Spreadsheet: 713208d1610596279-extract-the-number-from-the-left-cell-to-matching-word-sample1-ans-2
Sheet: Test

 | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name
 | 100000 | BAT-Bulk | 100 | ABC | 120000 | CAT | 400 | ABC | 103000 | BAT-Bulk | 50 | ABC | 100400 | BAT-Bulk | 200 | ABC | 100600 | RAT-Bulk | 100 | ABC
Question | Extract the number from the left cell to matching word '[NAME]'
CAT | 100000 | 103000 | 100400
[NAME]
 | Since column A is free,hence search range is A5:A6. it can be changed.
Spreadsheet: 766114d1643754124-bonus-structure-based-on-a-flat-rate-sales-over-a-certain-amount-quarterly-bonus-spreadsheet
Sheet: Sheet1

 | Sales | % | Commission
January 1 - 31st | 100000 | 0.01
Februrary 1-28th | 100000 | 0.01
 |  |  |  |  |  | Sales
March 1 - 31st | 102000 | 0.01
 |  |  |  |  |  | 275000 | Tier 1
Quarterly Sales/Bonus |  | If b12>=275000,VLOOKUP(Sales,$G$11:$H$13,2,1),0) |  |  |  | 300000 | [NAME]
 |  |  |  |  |  | 325000 | Tier 3
April 1- 30th | 0 | 0.01 | 0
 |  |  |  |  |  | Bonus Formula
May 1-31st | 0 | 0.01 | 0 | Sales>>>> | 325000 | 500 | Tier 1
 |  |  |  |  |  | 1000 | [NAME]
June 1- 30th | 0 | 0.01 | 0 |  |  | 1500 | Tier 3
Quarterly Sales/Bonus |  | If b12>=275000,VLOOKUP(Sales,$G$11:$H$13,2,1),0) |  | Amount of bonus
Spreadsheet: tracy_geaccone__40331__Lay Attendees at Nov 8 budget review for 2002 plan
Sheet: Sheet1

[NAME] LAY 2002 PLAN REVIEWS
November 8, 1:00-5:00
50M Executive Dining Room
[NAME]
[NAME]
[NAME]
EGAS
[NAME]
[NAME]
[NAME]
[NAME]
Wade Cline
Mariella Mahan
Azurix
[NAME]
[NAME]
ETS
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Portland
[NAME]
[NAME]
EREC
[NAME]
[NAME]