tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815191d1674802921-sumifs-with-multiple-criteria-sumifs-with-multiple-criteria-ans
Sheet: desired result by you

report
 | JAN |  |  | FEB |  |  | MAR |  |  | APR |  |  | MAY |  |  | JUN
ACCOUNT NAME | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT.
ALLAN | 5 | 4 | 250 | 0 | 8 | 80 | 0 | 0 | 0 | 0 | 8 | 80 | 0 | 0 | 0 | 0 | 12 | 120
[NAME] | 0 | 5 | 50 | 0 | 14 | 140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 12 | 10 | 0 | 6 | 60 | 34 | 13 | 170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 2 | 11 | 160 | 48 | 0 | 2400 | 2 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0
TAKESHI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Some of the results shown is not correct
 | Pl see E6.It should be 9.
Only "shipped" figure on the remarks will appear on the report
Spreadsheet: 97341d1296571167-removing-prefix-in-number-range-st-numbers
Sheet: Sheet1

S/N
DATE OF DISPATCH | ST NO. |  | VEHICLE NO. |  |  |  |  |  |  |  | CUSTOMERS' NAMES
15/1/2011 | 11000069 | 1231 | XA   877   GWK |  |  |  | 14 | 600 | 30 | 810000 | LOTANNA
15/1/2011 | 11000058 | 1229 | XA   886   GWK |  |  |  | 15 | 600 | 30 | 810000 | CHUKWUDI EZE | OK
20/1/2011 | 11000230 | 581 | XA   894   GWK |  |  |  | 31 | 600 | 30 | 810000 | IFEANYI EBO | OK
Spreadsheet: 0f846004-db9e-425d-aa1a-dbc788950213
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0035706 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Moyock Regional WWTP | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Currituck | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did infiltration occur at this facility? |  |  |  |  |  | Site Name: |  | 1-1 |  | Site Name: |  | 1-2 |  | Site Name: |  |  |  | Site Name:
 |  |  |  |  |  | Area (acres): |  | 0.287 |  | Area (acres): |  | 0.287 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Rate (GPD/ft2): |  | 3.997 |  | Rate (GPD/ft2): |  | 3.997 |  | Rate (GPD/ft2): |  |  |  | Rate (GPD/ft2):
Day | Weather |  |  | Freeboard |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated?
 | Weather Code | Temperature | Precipitation | Storage           (if applicable) | 5-Day Upset       (if applicable) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only)
 |  | ºF | in | ft | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft
1
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
Monthly Loading (GPD/ft2):
Year to Date Loading (GPD/ft2):
Spreadsheet: 873331d1719846097-sum-vlookup-combination-case-sum-vlookup
Sheet: SUM - VLOOKUP

 | Sales Revenue by Store
 | Store Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | North | 98 | 20 | 76 | 88 | 23 | 20 | 82 | 88 | 86 | 12 | 17 | 19
 | East | 40 | 51 | 90 | 33 | 50 | 68 | 80 | 73 | 8 | 108 | 110 | 93
 | South | 72 | 7 | 43 | 5 | 78 | 69 | 46 | 42 | 34 | 17 | 58 | 25
 | West | 4 | 57 | 63 | 100 | 8 | 86 | 95 | 14 | 69 | 96 | 92 | 2 |  | example 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store Name | Jan | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North | 118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | example 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store Name | Jan | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | East | 181
Spreadsheet: 872037d1718383261-countifs-issue-sample
Sheet: Players

 |  |  |  |  |  |  |  |  |  | Apperances |  |  |  |  |  |  |  | Bookings |  | Goals
 |  |  |  |  |  |  |  |  |  | U16 |  | U17 |  | U18 |  | U20
Name | Initals | DOB | Squad | Parent | [NAME] | Phone | Consent | Photo | Comet | Start | Sub | Start | Sub | Start | Sub | Start | Sub | Yellow | Red | U16 | U17 | U18 | U20
Test Player 1 | TP1 | 2013-08-13 00:00:00 | U17 | [NAME] | [EMAIL] | [PHONE] | Y | Y | Y
Spreadsheet: 749758d1632996151-sum-values-from-table-using-multiple-criteria-samplewb
Sheet: Sheet1

 | 2020 | 2019 | 2018 |  |  |  | 2020
A | 1 | 6 | 11 |  |  | A
B | 2 | 7 | 12
A | 3 | 8 | 13
D | 4 | 9 | 14
E | 5 | 10 | 15
Spreadsheet: elizabeth_sager__9646__cash
Sheet: Cash Teams

Teams responsible for getting cash
 | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8
 | Contract Assignments | Contract Sales | Inventory + business unit asset sales | Financings | EES Contract Sales, Receivables and Cash | Non-payments plus incremental margin | Large Asset Sales (>0.5bn) | Business Sales
Team Leader | Calger | Calger | Fallon | Kitchen | [NAME] | Kitchen | Muller | Muller
Team | Tycholiz | Tycholiz | [NAME] | [NAME] |  | Brackett
 | Milnthorp | Milnthorp | Colwell
 | Forster | Forster
Credit | Sacks | Sacks | Schneider |  |  | Brackett
 | [NAME] | [NAME] |  |  |  | Monica & Veronica
Legal | [NAME] | [NAME]
 | Sager | Sager
 |  |  | Projects in this area in the attached spreadsheet
Spreadsheet: 875762d1722362566-cagr-xirr-for-random-amount-of-investments-made-on-random-dates-cagr-xirr-for-random-amount-of-investments-made-on-random-dates
Sheet: Sheet1

ABC | Date | ABC | ABC | ABC | ABC | ABC | Invested Amt | ABC | ABC | ABC | ABC | Latest Value | ABC | ABC | ABC | ABC | ABC | ABC | CAGR or XIRR |  | StartDate | EndDate | Outflow | Inflow
ABC | 2017-03-25 00:00:00 | ABC | ABC | ABC | ABC | ABC | 50000 | ABC | ABC | ABC | ABC | 148200 | ABC | ABC | ABC | ABC | ABC | ABC |  |  |  |  |  |  | 4 helper columns: StartDate, EndDate, Outflow and Inflow
ABC | 2024-05-24 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5229.754266 | ABC | ABC | ABC | ABC | ABC | ABC |  |  |  |  |  |  | XIRR: =XIRR(Outflow:Inflow,StartDate:EndDate)
ABC | 2024-06-03 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5365.346917500001 | ABC | ABC | ABC | ABC | ABC | ABC
ABC | 2024-06-04 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5880.7046232 | ABC | ABC | ABC | ABC | ABC | ABC
ABC | 2024-06-14 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5248.4714964 | ABC | ABC | ABC | ABC | ABC | ABC
ABC | 2024-07-19 00:00:00 | ABC | ABC | ABC | ABC | ABC | 10000 | ABC | ABC | ABC | ABC | 10470.3636114 | ABC | ABC | ABC | ABC | ABC | ABC
ABC | 2024-07-23 00:00:00 | ABC | ABC | ABC | ABC | ABC | 10000 | ABC | ABC | ABC | ABC | 10157.4784514 | ABC | ABC | ABC | ABC | ABC | ABC
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net/Total Cash Flow
CAGR/XIRR for random amount of investments made on random dates
https://www.excelforum.com/excel-formulas-and-functions/1426801-cagr-xirr-for-random-amount-of-investments-made-on-random-dates.html
Spreadsheet: 816670d1675773871-sick-time-accrual-with-previous-year-carry-over-sick-time-calculator
Sheet: Esther Nicholson

Sick Time Calculated
Employee Name |  |  |  |  | Date of Hire | 2023 Used Sick Time | Previous Year Carry Over
[NAME] |  |  |  |  |  |  | 11.44
Payroll Week | Sunday-Saturday | Vacation | Holiday | Hours Worked | Weekly Total | [NAME] | Total Accrued Sick | Sick Used | Sick Available
Week Ending | 2023-01-07 00:00:00 |  |  | 32.26
Week Ending | 2023-01-14 00:00:00 |  |  | 23.43 |  |  |  | 8
Week Ending | 2023-01-21 00:00:00 |  |  | 40.02
Week Ending | 2023-01-28 00:00:00 |  |  | 30 |  |  |  | 7
Week Ending | 2023-02-04 00:00:00 |  |  | 39.57
Week Ending | 2023-02-11 00:00:00
Week Ending | 2023-02-18 00:00:00
Week Ending | 2023-02-25 00:00:00
Week Ending | 2023-03-04 00:00:00
Week Ending | 2023-03-11 00:00:00
Week Ending | 2023-03-18 00:00:00
Week Ending | 2023-03-25 00:00:00
Week Ending | 2023-04-01 00:00:00
Week Ending | 2023-04-08 00:00:00
Week Ending | 2023-04-15 00:00:00
Week Ending | 2023-04-22 00:00:00
Week Ending | 2023-04-29 00:00:00
Week Ending | 2023-05-06 00:00:00
Week Ending | 2023-05-13 00:00:00
Week Ending | 2023-05-20 00:00:00
Week Ending | 2023-05-27 00:00:00
Week Ending | 2023-06-03 00:00:00
Week Ending | 2023-06-10 00:00:00
Week Ending | 2023-06-17 00:00:00
Week Ending | 2023-06-24 00:00:00
Week Ending | 2023-07-01 00:00:00
Week Ending | 2023-07-08 00:00:00
Week Ending | 2023-07-15 00:00:00
Week Ending | 2023-07-22 00:00:00
Week Ending | 2023-07-29 00:00:00
Week Ending | 2023-08-05 00:00:00
Week Ending | 2023-08-12 00:00:00
Week Ending | 2023-08-19 00:00:00
Week Ending | 2023-08-26 00:00:00
Week Ending | 2023-09-02 00:00:00
Week Ending | 2023-09-09 00:00:00
Week Ending | 2023-09-16 00:00:00
Week Ending | 2023-09-23 00:00:00
Week Ending | 2023-09-30 00:00:00
Week Ending | 2023-10-07 00:00:00
Week Ending | 2023-10-14 00:00:00
Week Ending | 2023-10-21 00:00:00
Week Ending | 2023-10-28 00:00:00
Week Ending | 2023-11-04 00:00:00
Week Ending | 2023-11-11 00:00:00
Week Ending | 2023-11-18 00:00:00
Week Ending | 2023-11-25 00:00:00
Week Ending | 2023-12-02 00:00:00
Week Ending | 2023-12-09 00:00:00
Week Ending | 2023-12-16 00:00:00
Week Ending | 2023-12-23 00:00:00
Week Ending | 2023-12-30 00:00:00
Spreadsheet: 92907d1292430223-find-a-date-and-average-corresponding-data-copy-of-test
Sheet: Sheet1

2010-01-01 00:00:00 | #N/A |  |  |  | January | 111.75
2010-01-08 00:00:00 | 105 |  |  |  | February | #N/A
2010-01-15 00:00:00 | 116
2010-01-22 00:00:00 | 117
2010-01-29 00:00:00 | 109
2010-02-05 00:00:00 | #N/A
2010-02-12 00:00:00 | #N/A
2010-02-19 00:00:00 | #N/A
2010-02-26 00:00:00 | #N/A
2010-03-05 00:00:00 | 123
2010-03-12 00:00:00 | 125
2010-03-19 00:00:00 | 137
2010-03-26 00:00:00 | 129
2010-04-02 00:00:00 | 129
2010-04-09 00:00:00 | 127
2010-04-16 00:00:00 | 125
2010-04-23 00:00:00 | 127
2010-04-30 00:00:00 | 123
2010-05-07 00:00:00 | 131
2010-05-14 00:00:00 | 122
2010-05-21 00:00:00 | 123
2010-05-28 00:00:00 | 117
2010-06-04 00:00:00 | #N/A
2010-06-11 00:00:00 | 115
2010-06-18 00:00:00 | 131
2010-06-25 00:00:00 | 130
2010-07-02 00:00:00 | #N/A
2010-07-09 00:00:00 | 131
2010-07-16 00:00:00 | 127
2010-07-23 00:00:00 | 135
2010-07-30 00:00:00 | 135
2010-08-06 00:00:00 | #N/A
2010-08-13 00:00:00 | 147.5
2010-08-20 00:00:00 | 135
2010-08-27 00:00:00 | 127
2010-09-03 00:00:00 | 123
2010-09-10 00:00:00 | 135
2010-09-17 00:00:00 | 123
2010-09-24 00:00:00 | 131
2010-10-01 00:00:00 | #N/A
2010-10-08 00:00:00 | #N/A
2010-10-15 00:00:00 | #N/A
2010-10-22 00:00:00 | 117.5
2010-10-29 00:00:00 | 121
2010-11-05 00:00:00 | 130
2010-11-12 00:00:00 | 132.5
2010-11-19 00:00:00 | 133
2010-11-26 00:00:00 | #N/A
2010-12-03 00:00:00 | 150
2010-12-10 00:00:00 | 140
2010-12-17 00:00:00 | #N/A
2010-12-24 00:00:00 | #N/A
2010-12-31 00:00:00 | #N/A
Spreadsheet: 798660d1664622346-adding-sequence-date-every-11-rows-decapolis-1st-week-com-parison-sheet
Sheet: 21-9-2022

 |  | 2022-09-21 00:00:00 |  |  | Distrbuited by [NAME] |  |  | Difference |  |  | %
 | Date | Destination | #of Meal Deliveed  by [NAME] | Original Request by WFP | [NAME] | [NAME] | Apple | [NAME] | [NAME] | Apple | [NAME] | [NAME] | Apple
 | 2022-09-21 00:00:00 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2022-09-21 00:00:00 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2022-09-21 00:00:00 | [NAME] 1st Kitchen | 9226 | 10000 | 9520
 | 2022-09-21 00:00:00 | [NAME] 2nd Kitchen | 9558 | 8674 | 9720
 | 2022-09-21 00:00:00 | [NAME] | 9064 | 6897
 | 2022-09-21 00:00:00 | Bla'ama  Kitchen | 0 | 0 | 0 | 0 | 0
 | 2022-09-21 00:00:00 | [NAME] | 12963 | 13382
 | 2022-09-21 00:00:00 | South Shouneh Kitchen | 8606 | 8674
 | 2022-09-21 00:00:00 | Naqe’ -Karak Kitchen | 6377 | 6385
 | 2022-09-21 00:00:00 | [NAME] | 4800 | 7183
 | 2022-09-21 00:00:00 | Umm Jmmal Kitchen | 7369 | 4843
 |  | Total | 67963 | 303
Spreadsheet: 124627d1318516516-excel-2007-extracting-data-from-two-columns-and-only-using-info-from-one-book1
Sheet: Sheet1

18T | Nonlabor | ABP | Nonlabor
BM |  | 18T | Nonlabor
FL |  | AI | Labor
OPER |  | ASB | Labor
PF |  | ATN | Labor
BH |  | BC | Nonlabor
AI |  | BH | Nonlabor
ASB |  | BKMN | Labor
BKMN |  | BM | Labor
ASB |  | FL | Nonlabor
PF |  | PF | Labor
ABP |  | OPER | Labor
Spreadsheet: 101550d1299662202-table-sorting-when-multiple-columns-contain-the-same-type-of-data-researchsample1
Sheet: Sheet2

Title | Pages | Author | Author2 | Author3 | Author4 | Author5 | Year
Sample Title 1 | 10 | [NAME] |  |  |  |  | 2009
Sample Title 1 | 10 | [NAME] |  |  |  |  | 2009
Sample Title 2 | 7 | [NAME] |  |  |  |  | 2006
Sample Title 2 | 7 | [NAME] |  |  |  |  | 2006
Sample Title 2 | 7 | [NAME] |  |  |  |  | 2006
Sample Title 3 | 9 | [NAME] |  |  |  |  | 2008
Sample Title 3 | 9 | [NAME] |  |  |  |  | 2008
Sample Title 3 | 9 | [NAME] |  |  |  |  | 2008
Sample Title 4 | 9 | Will |  |  |  |  | 2010
Sample Title 5 | 7 | [NAME] |  |  |  |  | 2000
Sample Title 6 | 8 | [NAME] |  |  |  |  | 2004
Sample Title 6 | 8 | [NAME] |  |  |  |  | 2004
Sample Title 7 | 7 | [NAME] |  |  |  |  | 2008
Sample Title 7 | 7 | [NAME] |  |  |  |  | 2008
Sample Title 7 | 7 | [NAME] |  |  |  |  | 2008
Sample Title 7 | 7 | [NAME] |  |  |  |  | 2008
Sample Title 8 | 4 | [NAME] |  |  |  |  | 2008
Sample Title 8 | 4 | Will |  |  |  |  | 2008
Sample Title 9 | 6 | [NAME] |  |  |  |  | 2001
Sample Title 9 | 6 | [NAME] |  |  |  |  | 2001
Sample Title 10 | 5 | [NAME] |  |  |  |  | 2005
Sample Title 10 | 5 | [NAME] |  |  |  |  | 2005
Sample Title 10 | 5 | [NAME] |  |  |  |  | 2005
Sample Title 10 | 5 | [NAME] |  |  |  |  | 2005
Sample Title 10 | 5 | [NAME] |  |  |  |  | 2005
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Karen 

bc
[EMAIL] | Totaal aantal lessen
30 | 30 |  | maand
 |  | Januari
 |  | Februari
 |  | [NAME]
 |  | april
 |  | mei
 |  | juni
 |  | [NAME]
 |  | augustus
 |  | september
 |  | oktober
 |  | november
 |  | december
cash
Spreadsheet: 82005d1282077786-matching-rows-in-excel-and-finding-out-duplicate-rows-contacts_records-2-
Sheet: Sheet3

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
 |  |  |  |  |  |  | There is only 1 Big Design in sheet2 but this [NAME] is showin 3 Big Design ? Why ?
 |  |  |  |  |  |  | How these 3 records are coming ? As there are not present in sheet2:All-Records?
Desired Output
In sheet 3 i want those records (with complete row i.e. all fields) FROM sheet 2 that matches WITH records in sheet 1 (matching will be based on First Name, Last Name & CompanyName)
Second req: When we are matching rows of sheet2 with sheet 1,
if row from sheet2 matched with row from sheet 1, address, website and job title will be updated on bases of sheet1 with I think currently your formula is doing good
Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA1 | 123-456-567 | www.bigdesign.com
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
ABC LLC | [NAME] | Fard | Technician | 415 M Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 453-989-877 | www.abc.com
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000 | www.futureltd.com
Future Ltd | [NAME] | Farris | CFO | 34, New Zeland | 103-340-009 | www.futureltd.com
Spreadsheet: 809708d1671250084-index-and-match-with-multiple-results-copy-of-practice
Sheet: Jun

Title |  |  |  |  |  |  |  |  |  |  | Search | 9
Date | Name | Color | Details | Month Number |  |  |  |  |  |  | Date | Name | Color | Details | Month Number
2022-12-01 00:00:00 | [NAME] | Blue | Blue is a color
2022-11-01 00:00:00 | Curt | Red | This is just a line
2022-03-21 00:00:00 | [NAME] | Yellow | Not today
2022-04-15 00:00:00 | [NAME] | Green | Growing and slowing
2022-09-20 00:00:00 | [NAME] | White | Rows of the rows
2022-10-05 00:00:00 | Shell | Silver | Gones is the greatest | 12
2022-09-15 00:00:00 | [NAME] | gray | something
Spreadsheet: 827438d1682693983-how-to-check-if-a-date-falls-within-weeknum-in-excel-is-date-from-last-week-aligw
Sheet: Sheet1

2023-04-17 00:00:00
Spreadsheet: 833323d1686906716-formula-to-create-a-automating-a-template-from-a-data-set-in-a-second-sheet-sample-book-2
Sheet: Data Set 

 |  |  |  |  | Transaction date | Amount paid | Net Amount | VAT | Nominal Code
 |  |  |  |  | 2023-05-17 00:00:00 | 9.58 |  |  | 7500
 |  |  |  |  | 2023-05-17 00:00:00 | 48 |  |  | 7502
 |  |  |  |  | 2023-05-18 00:00:00 | 10 |  |  | 6900
 |  |  |  |  | 2023-05-18 00:00:00 | 69.4 | 69.4 |  | 7500
 |  |  |  |  | 2023-05-18 00:00:00 | 59.6 |  |  | 7403
 |  |  |  |  | 2023-05-18 00:00:00 | -120 | -100 | -20 | 7300
 |  |  |  |  | 2023-05-18 00:00:00 | 100 | 100 |  | 7401
 |  |  |  |  | 2023-05-18 00:00:00 | 59.6 | 49.67 |  | 7403
 |  |  |  |  | 2023-05-18 00:00:00 | 100 | 100 |  | 7200
 |  |  |  |  | 2023-05-18 00:00:00 | 59.6 | 49.67 |  | 7405
 |  |  |  |  | 2023-05-18 00:00:00 | 100 | 100 |  | 7200
 |  |  |  |  | 2023-05-18 00:00:00 | 50 |  |  | 7405
 |  |  |  |  |  |  |  |  | 2300 | VAT Code
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 11

TABLE 11
USE A SEPARATE SHEET FOR METRO & COUNTY
AVERAGE SALARY BY SELECTED OCCUPATION
Occupation | No. of Surveyed | No. of Covered | Average | Average | Weighted | Median | Average
 | Firms | Employees | Hire-In Rate | Minimum | Average Salary | Salary | Maximum Salary
Professional
Accountant
Engineer
Management Trainee
Programmer/Analyst
Website Designer ([NAME])
Retail
[NAME]
[NAME]
Stock Room Clerk
Clerical
Accounting Clerk
Customer Service Rep.
Data Entry Clerk
Executive Secretary
Receptionist
Telesales Rep.
Unskilled
General [NAME]
Hand Packer
Light Assembly
Material Handler
[NAME]
Semi-Skilled
Fork Lift Operator
Machine Operator
Skilled
Machine Maintenance
Machinist
Tool & Die
Welder
Technical
Electronics Technician
Medical/Laboratory Technician
Network Technician
Numerical Control Machine Programmer
 | Office | Manufacturing
Average Work Week in Hours
Annual Average Turnover %
Spreadsheet: 73175d1273820483-unique-values-unique_values
Sheet: Sheet2

Count of Range
Range | Total
170940 | 4
169938 | 1
170780 | 1
170779 | 2
169921 | 1
170100 | 1
170111 | 2
170111/1 | 1
170121 | 1
170122 | 1
170182 | 1
170643 | 5
170909 | 2
170507 | 6
Grand Total | 29
Spreadsheet: 105588d1302889394-excel-2007-formula-to-copy-a-cell-until-it-finds-a-blank-example-1-
Sheet: Data

part no. | product no. | Available Prod
Standard Time
xxxxx | 77903811A |  |  |  |  | Available Prod
 | 11001
 | 11022
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77908840A
 | 11001
 | 11020
 | 11022
 | 11033
 | 11034
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77921381A
 | 11001
 | 11022
 | 11033
 | 11051
 | 21005
 | 99001
Standard Time
xxxxx | 77903211E
 | 11001
 | 11022
 | 11023
 | 11034
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77903811A
 | 11001
 | 11022
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77908840A
 | 11001
 | 11020
 | 11022
 | 11033
 | 11034
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77921381A
 | 11001
 | 11022
 | 11033
 | 11051
 | 21005
 | 99001
Standard Time
xxxxx | 77903211E
 | 11001
 | 11022
 | 11023
 | 11034
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77903811A
 | 11001
 | 11022
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77908840A
 | 11001
 | 11020
 | 11022
 | 11033
 | 11034
 | 21005
 | 90001
 | 99001
Standard Time
xxxxx | 77921381A
 | 11001
 | 11022
 | 11033
 | 11051
 | 21005
 | 99001
Standard Time
xxxxx | 77903211E
 | 11001
 | 11022
 | 11023
 | 11034
 | 21005
 | 90001
 | 99001
Standard Time
Spreadsheet: 781554d1653412930-12-months-average-excel-example
Sheet: Sheet1

 | 2020
 | Month | Value |  | Month | Apr
 | Jan | 5
 | Feb | 3.2 |  | 12-month Average
 | Mar | 1
 | Apr | 5.6
 | May | 3
 | Jun | 7.5
 | Jul | 6.4
 | Aug | 3.1
 | Sep | 1.2
 | Oct | 5
 | Nov | 6
 | Dec | 9.1
 | 2021
 | Month | Value
 | Jan | 3.5
 | Feb | 6.8
 | Mar | 9.4
 | Apr | 7.2
 | May | 2.4
 | Jun | 5.6
 | Jul | 6.8
 | Aug | 6.2
 | Sep | 1
 | Oct | 4.9
 | Nov | 8.2
 | Dec | 6.5
Spreadsheet: 840443d1692738152-find-top-3-delays-from-production-data-top-3-delays-from-a-production-table-excelforum-3-
Sheet: Sheet1

 | Item | Measure | 2023-08-15 00:00:00 | 2023-08-16 00:00:00 | 2023-08-17 00:00:00 | 2023-08-18 00:00:00 | 2023-08-19 00:00:00 | 2023-08-20 00:00:00 | 2023-08-21 00:00:00 | 2023-08-22 00:00:00 |  |  | Top 3 Delayed Items as of | 2023-08-19 00:00:00
 | Mango | Target | 10 | 10 | 20 | 30 | 10 | 5 | 5 | 10
 | Mango | Actual | 5 | 10 | 10 | 5 | 20 |  |  |  |  |  | [NAME]
 | Apple | Target | 30 | 10 | 5 | 5 | 20 | 5 | 10 | 5 |  |  | Apple
 | Apple | Actual | 10 | 5 | 10 | 5 | 5
 | [NAME] | Target | 20 | 20 | 40 | 5 | 5 | 5 | 5 | 5
 | [NAME] | Actual | 10 | 10 | 15 | 5 | 5
 | Carrot | Target | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 | Carrot | Actual | 5 | 5 | 5 | 5 | 5
 | Cabbage | Target | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | Cabbage | Actual | 10 | 10 | 10 | 10 | 10
 |  | Target as of 19/8 | Actual | [NAME]
 | Mango | 80 | 50
 | Apple | 70 | 35
 | [NAME] | 90 | 45
 | Carrot | 50 | 25
 | Cabbage | 100 | 50
Spreadsheet: 881533d1729610192-help-needed-with-filter-function-for-dynamic-status-report-in-excel-project-status-report_test
Sheet: Project Timeline

 |  |  |  |  |  | Baseline
 | ID | Type | Task Name | Owner | Resources | Planned Start Date | Planned End Date | Actual Start Date | Forecast End Date | Progress (%) | Status | Comments | 2024-09-23 00:00:00
 | 1 | Milestone | Milestone 1 |  |  | 2024-09-23 00:00:00 | 2024-09-23 00:00:00 | 2024-09-23 00:00:00 | 2024-09-23 00:00:00 | 1 | Complete | Task Complete
 | 2 | Task | Task 1 |  |  | 2024-09-16 00:00:00 | 2024-10-11 00:00:00 | 2024-09-16 00:00:00 | 2024-10-11 00:00:00 | 1 | Complete
 | 3 | Task | Task 2 |  |  | 2024-09-16 00:00:00 | 2024-10-11 00:00:00 | 2024-09-16 00:00:00 | 2024-10-11 00:00:00 | 1 | Complete
 | 4 | Milestone | Milestone 2 |  |  | 2024-10-14 00:00:00 | 2024-10-15 00:00:00 | 2024-10-14 00:00:00 | 2024-10-15 00:00:00 | 0.5 | Delayed | Milestone is Delayed
 | 5 | Task | Task 3 |  |  | 2024-10-14 00:00:00 | 2024-10-15 00:00:00 | 2024-10-14 00:00:00 | 2024-10-15 00:00:00 | 1 | Complete
 | 6 | Task | Task 4 |  |  | 2024-10-14 00:00:00 | 2024-10-18 00:00:00 | 2024-10-14 00:00:00 | 2024-10-18 00:00:00 | 0.5 | At Risk | Task at Risk
 | 7 | Task | Task 5 |  |  | 2024-10-14 00:00:00 | 2024-11-08 00:00:00 | 2024-10-14 00:00:00 | 2024-11-08 00:00:00 | 0 | At Risk | Task at Risk
 | 8 | Task | Task 6 |  |  | 2024-10-14 00:00:00 | 2024-11-08 00:00:00 | 2024-10-14 00:00:00 | 2024-11-08 00:00:00 | 0 | At Risk | Task at Risk
 | 9 | Task | Task 7 |  |  | 2024-09-16 00:00:00 | 2024-10-11 00:00:00 | 2024-09-16 00:00:00 | 2024-10-11 00:00:00 | 1 | Complete
 | 10 | Task | Task 8 |  |  | 2024-10-21 00:00:00 | 2024-11-08 00:00:00 | 2024-10-21 00:00:00 | 2024-11-08 00:00:00 | 0 | Not Started
 | 11 | Task | Task 9 |  |  | 2024-10-08 00:00:00 | 2024-11-01 00:00:00 | 2024-10-08 00:00:00 | 2024-11-01 00:00:00 | 0 | Not Started
 | 12 | Task | Task 10 |  |  | 2024-10-28 00:00:00 | 2024-11-22 00:00:00 | 2024-10-28 00:00:00 | 2024-11-22 00:00:00 | 0 | Not Started
 | 13 | Task | Task 11 |  |  | 2024-10-21 00:00:00 | 2024-12-06 00:00:00 | 2024-10-21 00:00:00 | 2024-12-06 00:00:00 | 0 | Not Started
 | 14 | Task | Task 12 |  |  | 2024-11-18 00:00:00 | 2024-12-06 00:00:00 | 2024-11-18 00:00:00 | 2024-12-06 00:00:00 | 0 | Not Started
 | 15 | Milestone | Milestone 3 |  |  | 2024-12-06 00:00:00 | 2024-12-06 00:00:00 | 2024-12-06 00:00:00 | 2024-12-06 00:00:00 | 0 | Not Started | Milestone not started
 | 16 | Task | Task 13 |  |  | 2024-10-30 00:00:00 | 2024-12-13 00:00:00 | 2024-10-30 00:00:00 | 2024-12-13 00:00:00 | 0 | Not Started
 | 17 | Milestone | Milestone 4 |  |  | 2024-12-13 00:00:00 | 2024-12-13 00:00:00 | 2024-12-13 00:00:00 | 2024-12-13 00:00:00 | 0 | Not Started | Milestone not started