tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 137965d1327446018-vlookup-or-hlookup-dummy-book1
Sheet: Sheet1

 | Date | Invoice Ref | Payment Method | Payment Details | Bank | Cash | Drawings | Entertainment | Office | Motor Expenses | Utilities
 | 2010-04-06 00:00:00 | gs001 | Debit card | Dell Boy Motors | 250 |  |  |  |  | 250
 | 2010-04-06 00:00:00 | gs003 | Cheq #0020 | N.Power Electric | 175 |  |  |  |  |  | 175
 | 2010-04-07 00:00:00 | gs005 | Credit card | Amazon | 50 |  |  |  | 50
 | 2010-04-08 00:00:00 | gs010 | Debit card | [NAME] shop | 10 |  |  | 10
 | 2010-04-09 00:00:00 | [NAME] | Cheq #0021 | Rolls Royce Ltd | 25000 |  | 25000
 | 2010-04-10 00:00:00 | gs020 | Cash | [NAME] shop |  | 7.5 |  | 7.5
 | 2010-04-10 00:00:00 | gs025 | Credit card | Rolls Royce Ltd | 150 |  |  |  |  | 150
 | 2010-04-12 00:00:00 | [NAME] | Cheq #0022 | Dell Boy Motors | 40 |  |  |  |  | 40
 | 2010-04-15 00:00:00 | gs035 | Cheq #0023 | Dell Boy Motors | 175 |  |  |  |  | 175
 | 2010-04-15 00:00:00 | gs033 | Cheq #0024 | N.Power Electric | 75 |  |  |  |  |  | 75
 |  |  |  | Totals |  |  |  |  |  |  |  |  | Totals by
 |  |  |  |  |  |  |  |  |  |  |  |  | Cash
 |  |  |  |  |  |  |  |  |  |  |  |  | Cheques
 |  |  |  |  |  |  |  |  |  |  |  |  | Credit Card
 |  |  |  |  |  |  |  |  |  |  |  |  | Debit Card
 |  | N.Power Electric | Dell Boy Motors | Rolls Royce Ltd | Amazon | [NAME] shop | Want to achieve this from data in G4:[NAME] While I would like to keep the condition formating the list of individual payments is whats important |  |  | N.Power Electric | Dell Boy Motors | Rolls Royce Ltd | Amazon | [NAME] shop
 |  |  |  |  |  |  |  |  |  | 175 | 250 | 25000 | 50 | 10
 |  |  |  |  |  |  |  |  |  | 75 | 40 | 150 |  | 7.5
 |  |  |  |  |  |  |  |  |  |  | 175
 |  |  |  |  |  | This is my attempt so far
Spreadsheet: 82741d1282761429-offset-not-working-offset-issue
Sheet: Front Sheet 

Sales
AHT
Column | 12 | FU 1
Row | 57 | FU 2
AHT |  | FU 3
ASA |  | FU 4
Utilisa |  | FU 5
Sales |  | FU 6
Calls |  | FU 7
 |  | FU 8
 |  | FU 9
 |  | FU 10
 |  | FU 11
 |  | FU 12
 |  | FU 13
 |  | FU 14
 |  | FU 15
 |  | FU 16
 |  | FU 17
 |  | FU 18
 |  | FU 19
 |  | FU 20
 |  | FU 21
 |  | FU 22
 |  | FU 23
 |  | FU 24
 |  | FU 25
 |  | FU 26
Spreadsheet: 815784d1675195107-looking-for-a-formula-that-sums-depending-on-specific-dates-problem-excel
Sheet: Sheet1

Starting | Ending |  | Customer | Item | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | ----> in weeks |  | Total
202301 | 202305 |  | Comp A | X | 2 | 6 | 9 | 1 | 0 | 2 | 8 | 1 | 2 |  |  | Sum of every row if Period is between 202301 and 202305
 |  |  | Comp B | Y | 4 | 7 | 5 | 0 | 3 | 0 | 9 | 7 | 2 |  |  | When changing the starting and ending period it should automatically
 |  |  | Comp C | X | 1 | 2 | 3 | 4 | 9 | 0 | 7 | 0 | 5 |  |  | update. Basically only the blue cells are input, yellow is data and the formula needed is the output for every single row
Spreadsheet: 752692d1634905455-how-can-i-flag-all-concurrent-calls-based-on-cdr-export-crd-concurrency-check
Sheet: Sheet1

Call Start Date/Time | Call Finish Date/Time | Date | Start Time | Finish Time | Clash ?
01/22/2021 13:36:01 | 01/22/2021 14:46:01 | 22/01/2021 | 13:36:01 | 14:46:01
01/21/2021 13:29:41 | 01/21/2021 14:59:41 | 21/01/2021 | 13:29:41 | 14:59:41
01/15/2021 13:41:06 | 01/15/2021 15:00:06 | 15/01/2021 | 13:41:06 | 15:00:06
01/08/2021 13:45:52 | 01/08/2021 15:00:52 | 08/01/2021 | 13:45:52 | 15:00:52
01/13/2021 14:47:29 | 01/13/2021 14:49:29 | 13/01/2021 | 14:47:29 | 14:49:29
01/13/2021 14:49:01 | 01/13/2021 16:21:01 | 13/01/2021 | 14:49:01 | 16:21:01
01/29/2021 16:12:04 | 01/29/2021 17:01:04 | 29/01/2021 | 16:12:04 | 17:01:04
01/13/2021 16:14:58 | 01/13/2021 17:18:58 | 13/01/2021 | 16:14:58 | 17:18:58
01/28/2021 16:46:14 | 01/28/2021 18:00:14 | 28/01/2021 | 16:46:14 | 18:00:14
01/05/2021 08:19:15 | 01/05/2021 09:33:15 | 05/01/2021 | 08:19:15 | 09:33:15
01/18/2021 07:35:10 | 01/18/2021 08:38:10 | 18/01/2021 | 07:35:10 | 08:38:10
Spreadsheet: 882593d1730979236-select-location-to-buy-an-item-location-to-buy-test
Sheet: Sheet1

 |  |  | Available | Available | Available | Available | Available | Available | Available | Not available | Available | Available
Id Number | Location | Needed | Argentina | Chile | Colombia | Uruguai | Portugal | France | Japan | China | Australia | Brazil
5623 | Brazil | 2 | 0 | 1 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 297
2458 | Brazil | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
213335 | Chile | 2 | 0 | 7 | 2 | 0 | 0 | 0 | 0 | 254 | 0 | 0
598456 | Chile | 3 | 0 | 3 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
369546 | Chile | 2 | 0 | 5 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
365982 | Chile | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 0
123458 | Australia | 3 | 0 | 1 | 0 | 0 | 1 | 2 | 0 |  | 4 | 0
32156 | Brazil | 3 | 10 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 8
6712569 | Brazil | 1 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 1
364781 | Uruguai | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1
Spreadsheet: 206503d1358203009-breaking-out-numbers-out-of-text-pavpav1
Sheet: Sheet1

<td><span>20</span></td>			<td class="right_align"><span>8-2-0</span></td>			<td class="right_align"><span>768 500 | 20 | 768 500 | #N/A
<td><span>7</span></td> <td class="right_align"><span>1-0-0</span></td> <td class="right_align"><span>124 500 | 7 | 124 500 | 871500
<td><span>1</span></td> <td class="right_align"><span>0-0-0</span></td> <td class="right_align"><span>4 000 | 1 | 4 000 | 4000
<td><span>18</span></td> <td class="right_align"><span>0-3-4</span></td> <td class="right_align"><span>720 200 | 18 | 720 200 | 12963600
<td><span>21</span></td> <td class="right_align"><span>1-2-4</span></td> <td class="right_align"><span>173 300 | 21 | 173 300 | 3639300
Spreadsheet: kim_ward__20722__golf_list
Sheet: Sheet1

Tim & Margaret Balin |  | 11744 Taylorcrest | Houston | TX | 77024
[NAME] |  |  | Kingwood | TX
[NAME] |  |  | Houston | TX
[NAME] |  |  | Houston | TX
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
susan & [NAME]
[NAME]
[NAME]
Theresa Mandola
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ginger & Micheal Brown
[NAME]
[NAME]
[NAME]
[NAME]
Troy Lawrence
[NAME]
Spreadsheet: 66879d1267559434-excel-2007-formulae-to-count-matching-adjacent-cells-example-1-
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 |  |  |  | name | number
A | 1 | 1 | 1 | 1 | 1 |  |  |  | A | 1
B | 1 | 1 | 2 | 1 | 0 |  |  |  | A | 2
C | 2 | 0 | 0 | 1 | 2 |  |  |  | B | 3
D | 0 | 2 | 2 | 1 | 0 |  |  |  | B | 4
E | 1 | 1 | 0 | 1 | 1 |  |  |  | C | 5
 |  |  |  |  |  |  |  |  | C | 1
 |  |  |  |  |  |  |  |  | D | 2
 |  |  |  |  |  |  |  |  | D | 3
 |  |  |  |  |  |  |  |  | E | 4
 |  |  |  |  |  |  |  |  | E | 5
 |  |  |  |  |  |  |  |  | E | 1
 |  |  |  |  |  |  |  |  | E | 2
 |  |  |  |  |  |  |  |  | A | 3
 |  |  |  |  |  |  |  |  | A | 4
 |  |  |  |  |  |  |  |  | A | 5
 |  |  |  |  |  |  |  |  | B | 1
 |  |  |  |  |  |  |  |  | B | 2
 |  |  |  |  |  |  |  |  | B | 3
 |  |  |  |  |  |  |  |  | C | 4
 |  |  |  |  |  |  |  |  | C | 5
 |  |  |  |  |  |  |  |  | C | 1
 |  |  |  |  |  |  |  |  | D | 2
 |  |  |  |  |  |  |  |  | D | 3
 |  |  |  |  |  |  |  |  | D | 4
Spreadsheet: 770736d1646237717-index-list-values-that-meet-criteria-list-with-array
Sheet: Company 2

 |  | Company 2
Date | Hours | Contract
Spreadsheet: kevin_hyatt__19631__TW MAOP Upgrade-Cost Estimate
Sheet: Sheet1

TW 30" Main/Loop Lines
Station 5 to Needles California
MAOP Upgrade Evaluation
Possible Risk Factors |  | Possible Actions To Address |  | Unit Cost |  | Units |  | Total Cost
Metal Loss (Corrosion) |  | Hi-Res Mag Flux In-line Inspection |  | $2,000/mile |  | 625 miles
Longitudinal Seam Defects |  | Trans Flux In-line Inspection |  | $5,000/mile |  | 755 miles
 |  | Pipeline Pre-Cleaning For In-line Inspections |  | $50,000/section |  | 7 sections
 |  | Potential Excavations and Repairs |  | $10,000/excavation |  | 150 excavations
Mechanical Damage, Ground Movement, External Stress |  | Geopig Geometry In-line Inspection |  | $1,000/mile |  | 755 miles
External Coating Condition |  | CI Survey + DCVG |  | $500/mile |  | 755 miles
 |  | [NAME] |  | $50/foot |  | 5000 feet
Stress Corrosion Cracking |  | Model+ Excavation Digs |  | $10,000/dig |  | 10 digs
Metallurgy (Toughness, etc.) |  | Cut Out Rings + Stopple |  | will be done as part of valve replacements |  |  |  | 0
Depth of Cover in HCA's |  | Depth of Cover Survey |  |  |  |  |  | 50000
High Consequence Areas (HCA) |  | Replace Pipe |  | $2,000,000/mile |  | 8 miles
Equipment With Inadequate Pressure Rating |  | Replace Mainline Valves + Stopple |  | $400,000/ valve |  | 21 valves
 |  | (Possible salavage value of 30" valves
Other: |  | replaced??)
Install launcher/receivers on Sta1 to [NAME] (Colo River) |  |  |  |  |  |  |  | 1000000
Third Party Consultant |  |  |  |  |  |  |  | 250000
[NAME] |  |  |  |  |  |  |  | 50000
Note: No risk measures included for 3 miles of Class 2 lines
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 34725 | 33702 | 34933 | 32000
2 | 34843 | 33589 | 35369 | 32000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 34085 | 33702 | 37069 | 32000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 36422 | 35544 | 34771 | 29872 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 36277 | 33702 | 30329 | 32000 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 40078 | 36144 | 21788 | 34000 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 34452 | 35502 | 34276 | 33385
8 | 34452 | 36050 | 34276 | 32613
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 377740.81
2001-12-08 00:00:00
CBS Volume
 |  |  | -18782
Spreadsheet: 695125d1600069698-return-a-quarter-wise-best-poor-performed-vehicles-name-and-values-quarter-wise-best-poor-performed-vehicles
Sheet: Sheet1

 | Quarter-1 |  |  | Quarter-2 |  |  | Quarter-3
 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00
Vehicles | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount
Bus | 1235 | 3745 | -11720 | -27185 | -4650 | 7350 | 17350 | -17350 | 8850
Car | -11503 | 3962 | 0 | -26968 | 12433 |  | 17567 | 0 | 9067
Pick up | -13450 |  | 1495 | -13970 | -9435 | 20565 | -7056 | 11056 | -22065
Truck |  | -11001 | 3520 | 6466 | 11931 | -26466 | -8069 | 18069 | 9569
Crane | 1546 | 4056 | -11409 | 8174 | 22339 | -26874 | -7661 | -1661 | -9161
 | Quarter-1 | Name | Amount | Quarter-2 | Name | Amount | Quarter-3 | Name | Amount
 | Best Performed Vehicle |  |  | Best Performed Vehicle |  |  | Best Performed Vehicle
 | Poor Performed Vehicle |  | -13450 | Poor Performed Vehicle |  | -27185 | Poor Performed Vehicle |  | -22065
 |  |  |  | Name | Amount
 | Overall Best performed Vehicle
 | Overall Poor Performed Vehicle |  |  |  | -27185
Spreadsheet: 21012cfe-4e21-4a3f-b52d-72656e30530a
Sheet: Sheet1

Building Inspector / Reviewer | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Certificate
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Course |  |  |  | Credits | Semester Taken
230 ADFT  Construction Techniques |  |  |  | 4
101 BCO  Introduction to Code Enforcement |  |  |  | 3
102 BCO  Enforcement and Administration |  |  |  | 3
103 BCO  Building Trades Overview |  |  |  | 3
220 BRX  Blueprint Reading for Construction |  |  |  | 3
299 CAR  Cooperative Educational Program OR |  |  |  | 2
298 CAR  Practicum |  |  |  | (2)
150 CPU  Computer Fundamentals OR |  |  |  | 3
100 CIS  Introduction to Computers |  |  |  | (3)
Electives |  |  |  | 6
Commercial Building Inspector Option:
202 BCO  Commercial Code Enforcement |  |  |  | 3
Plan Specification Reviewer Option:
203 BCO  Performing a Plan Review |  |  |  | 3
Residential Building Inspector Option:
201 BCO  Residential Code Enforcement |  |  |  | 3
Total hours for Diploma |  |  |  | 33
Spreadsheet: 011bde9b-ea3a-4bd0-9e94-2d590e0d1a03
Sheet: Year End Totals

Year End: | October 1 - September 30
Year:
Annual CACFP Reimbursement:
Total Annual Food Program Expenses:
Amount Needed from Other Funding Sources:
Totals | Administrative Salaries and Benefits | Travel Expenses (include monitoring staff) | Printing, Office Supplies, Communications | Staff Training | Food Service Salaries and Benefits | Food (include delivery charges) | Purchased Vended Meals | Food Service Equipment | Allowable Nonfood Supplies | Occupancy/ Utilities | [NAME]. | Specify Misc.
Total Annual Food Program Expenses:
End of worksheet
Spreadsheet: 08334af4-cc62-4427-8cee-d43c104e0bb5
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
 | 8731.0 Building Approvals, Australia
 | TABLE 76. Value of Building Approved, Chain Volume Measures, Original - Victoria
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total houses ;  New ; |  |  | Original | A590487F | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total other residential building ;  New ; |  |  | Original | A590488J | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total residential building ;  New ; |  |  | Original | A590489K | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590490V | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590491W | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590492X | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590493A | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: eric_saibi__9712__10702
Sheet: Craig 03

Owner Name |  | Tri-State Generation
Station Name |  | Craig Power Station
Unit Name |  | [NAME] 03
NERC Region |  | WSCC
State |  | CO
Fuel Type |  | Coal
Capacity |  | 446MW
Start Date |  | 2002-01-05 00:00:00
End Date |  | 2002-01-13 00:00:00
Comments |  | [NAME]
SIC |  | 4911
Plant ID |  | 1015365
Unit ID |  | 1007179
Outage ID |  | 19386
Spreadsheet: 764923d1643075212-countifs-within-a-numerical-range-book1a
Sheet: Sheet1

 | Moneylines
Game #1 | -200 | w |  | <=-200
Game #2 | -160 | l |  | >=-199 & <=-150
Game #3 | -120 | w |  | >=-149 & <=-100 |  | <<<<< what like to know how to put the numerical range in cells E3 & E4
Game #4 | -250 | l |  | >=100
Game #5 | 120 | w
Game #6 | 140 | w
Game #7 | -175 | l
Spreadsheet: 275194d1383387020-vlookup-help-roster-query2-
Sheet: Wednesday

Wednesday
 |  |  |  | Date | 2013-10-30 00:00:00 |  |  |  | CS 5/13
Staff | Name | Key | Rostered Shift | Overtime | Remarks - Reason For Overtime
Number
Uncovered |  | CS2 | 0430-1230
516643 | R Carr | A | 0345-1345 | 1345-1400
u | Uncovered | P7 | 0445-0900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
169565 | S Amadio | P2 | 0445-1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169565 | 169565
741078 | A Dray | 1 | 0430-1230
826406 | A Hatch | F1 | 0445-1245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406
885369 | R Price | 18 | 0845-1415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 885369 | 885369
134948 | R Gillis | CP1 | 0930-1445
128557 | M Bindoraho | F3 | 0945-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 128557
169566 | N Wilson | P3 | 1400-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169566 | 169566
154218 | L Rosier | P5 | 1415-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154218 | 154218
142354 | R Murray | P6 | 1500-2215 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142354 | 142354
528648 | M Keast | B | 1415-2215 | 1245-1415
812409 | S Barber | CP2 | 1430-2000
104159 | A [NAME] | AB | 0800-1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104159
Rostered Off
 |  |  |  | O/T Avail ?
533497 | R Miller | CS1 | OFF |  |  |  |  |  |  | 969
530504 | M Limon | C | OFF |  |  |  |  |  |  | 967
115862 | C Canhan | F2 | OFF |  |  |  |  |  |  | TL / 971 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115862
u | Uncovered | P1 | OFF |  |  |  |  |  |  | Qlink at 1430 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
206953 | K Phelan | P4 | OFF |  |  |  |  |  |  | 975 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206953
u | Uncovered | 20 | OFF |  |  |  |  |  |  | 977 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
771140 | C Smith | 19 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 771140
 |  | QC1 | OFF
 |  | QC2 | OFF
Wooksheets Required
Week Commencing |  |  | 2013-10-30 00:00:00
812409 | S Barber |  | CP2
533497 | R Miller |  | CS1
226967 | D MacQueen |  | CS2
134948 | R Gillis |  | CP1
516643 | R Carr |  | A
528648 | M Keast |  | B
530504 | M Limon |  | C
741078 | A Dray |  | 1
826406 | A Hatch |  | F1
317947 | J [NAME] |  | L
539671 | A.Saunders |  | L
206953 | K Phelan |  | P4
115862 | C Canhan |  | F2
104159 | A [NAME] |  | AB
128557 | M Bindoraho |  | F3
771140 | C Smith |  | 19
885369 | R Price |  | 18
154218 | L Rosier |  | P5
142354 | R Murray |  | P6
169566 | N Wilson |  | P3
169565 | S Amadio |  | P2
318474 | P Thomson |  | SL
101770 | J [NAME] |  | -
 |  |  | -
u | Uncovered |  | P1
u | Uncovered |  | P7
u | Uncovered |  | 20
u | Uncovered |  | -
u | Uncovered |  | -
u | Uncovered |  | -
Spreadsheet: 839401d1691938066-filter-formula-to-lookup-and-return-data-with-2-critiera-sample50
Sheet: Data

Date | Employee | Pay
2023-04-01 00:00:00 | 1A | 50
2023-04-05 00:00:00 | 1B | 45
2023-04-09 00:00:00 | 1C | 47
2023-04-22 00:00:00 | 2A | 51
2023-05-01 00:00:00 | 2B | 60
2023-05-06 00:00:00 | 1C | 70
2023-05-18 00:00:00 | 1B | 80
2023-05-27 00:00:00 | 2A | 90
2023-06-09 00:00:00 | 1C | 99
2023-06-10 00:00:00 | 1A | 100
2023-06-11 00:00:00 | 2B | 110
2023-06-19 00:00:00 | 2B | 60
2023-06-29 00:00:00 | 1B | 75
2023-07-05 00:00:00 | 2A | 81
2023-07-09 00:00:00 | 1C | 94
2023-07-11 00:00:00 | 1A | 95
2023-07-22 00:00:00 | 1B | 65
Spreadsheet: 223451d1364217458-creating-an-automatic-students-report-marks-and-reports
Sheet: Marks

College: | Technology
Level | Two
Group | Four
SN | Student's Name | Student No. | Mark | Grade
1 | Student 1 | 13144 | 65
2 | Student 2 | 13145 | 80
3 | Student 3 | 13146 | 77
4 | Student 4 | 13147 | 72
5 | Student 5 | 13148 | 68
6 | Student 6 | 13149 | 63
7 | Student 7 | 13150 | 67
8 | Student 8 | 13151 | 60
9 | Student 9 | 13152 | 72
10 | Student 10 | 13153 | 65
11 | Student 11 | 13154 | 77
12 | Student 12 | 13155 | 63
13 | Student 13 | 13156 | 76
14 | Student 14 | 13157 | 55
15 | Student 15 | 13158 | 0
16 | Student 16 | 13159 | 45
17 | Student 17 | 13160 | 87
18 | Student 18 | 13161 | 71
19 | Student 19 | 13162 | 61
20 | Student 20 | 13163 | 53
21 | Student 21 | 13164 | 60
22 | Student 22 | 13165 | 0
23 | Student 23 | 13166 | 63
24 | Student 24 | 13167 | 50
25 | Student 25 | 13168 | 65
26 | Student 26 | 13169 | 58
27 | Student 27 | 13170 | 91
28 | Student 28 | 13171 | 70
29 | Student 29 | 13172 | 73
30 | Student 30 | 13173 | 67
31 | Student 31 | 13174 | 60
32 | Student 32 | 13175 | 63
33 | Student 33 | 13176 | 58
34 | Student 34 | 13177 | 55
35 | Student 35 | 13178 | 78
36 | Student 36 | 13179 | 53
37 | Student 37 | 13180 | 79
38 | Student 38 | 13181 | 63
39 | Student 39 | 13182 | 73
40 | Student 40 | 13183 | 33
41 | Student 41 | 13184 | 67
42 | Student 42 | 13185 | 76
43 | Student 43 | 13186 | 88
44 | Student 44 | 13187 | 69
45 | Student 45 | 13188 | 70
46 | Student 46 | 13189 | 80
47 | Student 47 | 13190 | 62
48 | Student 48 | 13191 | 63
49 | Student 49 | 13192 | 95
Spreadsheet: 494071d1482162828-compare-parts-by-whole-units-sales-order-example
Sheet: Entry

 |  |  | Unit | Part No |  | Counts number of unique parts |  | Adds Part value to create Model Value | Identifies unique base models |  | 1000
 |  | First of multiple units | 1 | Ford Body
 |  |  | 1 | [NAME]
 |  |  | 1 | Trailer Hitch
 |  |  | 1 | [NAME]
 |  |  | 1 | Off Road Tires
 |  | Duplicate Unit of Unit 1 | 2 | Ford Body
 |  |  | 2 | [NAME]
 |  |  | 2 | Trailer Hitch
 |  |  | 2 | [NAME]
 |  |  | 2 | Off Road Tires
 |  | [NAME] (fewer parts) | 3 | Ford Body
 |  |  | 3 | [NAME]
 |  |  | 3 | Trailer Hitch
 |  | First of multiple units | 4 | Jeep Body
 |  |  | 4 | Hard Top
 |  |  | 4 | Wench
 |  |  | 4 | Roll Bar
 |  | Duplicate Unit of Unit 1 | 5 | Ford Body
 |  |  | 5 | [NAME]
 |  |  | 5 | Trailer Hitch
 |  |  | 5 | [NAME]
 |  |  | 5 | Off Road Tires
 |  | Duplicate Unit of unit 4 - in different [NAME] should still count as duplicate | 6 | Jeep Body
 |  |  | 6 | Hard Top
 |  |  | 6 | Roll Bar
 |  |  | 6 | Wench
 |  | Unique | 7 | Ford Body
 |  |  | 7 | [NAME]
 |  |  | 7 | Trailer Hitch
 |  |  | 7 | [NAME]
 |  |  | 7 | All Weather Tires
Spreadsheet: 868739d1715412048-data-matrix-joining-simplifying-variants-variants
Sheet: Sheet1

 | Variant version key
 | engine
 | a | 120HP
 | b | 150HP
 | colour
 | s | black
 | g | grey
 | lenght
 | 5 | 5m
 | 6 | 6m
 | Possible combinations
 | Variants
 | as5 | 120HP | black | 5m
 | [NAME] | 120HP | black | 6m
 | ag5 | 120HP | grey | 5m
 | ag6 | 120HP | grey | 6m
 | bs5 | 150HP | black | 5m
 | bs6 | 150HP | black | 6m
 | bg5 | 150HP | grey | 5m
 | bg6 | 150HP | grey | 6m
How to achieve excel determines which points in variant version key are replacable and mark them with "?" ?
 | lenght | 5m
 | Variants | ??5
 | lenght | 5m | engine | 120HP
 | Variants | [NAME]
 | lenght | 5m or 6m
 | Variants | ??5
 |  | ??6
Spreadsheet: 860876d1708894787-help-with-a-formula-to-copy-information-from-input-table-sheet-to-output-sheet-barcode-example
Sheet: Input Table

DATA INPUT
Type/Date | Tracking ID | Name | Status | Product Type | Start | Cust # | Weight | Size
AAA | L-226578 | AAA | AAA | AAA | 246 | 8879 | 89 | 20
BBB | L-6688541 | BBB | BBB | BBB | 398 | 4448 | 76 | 25
CCC | L-7879844 | CCC | CCC | CCC | 448 | 7852 | 44 | 26
DDD | M-4848448 | DDD | DDD | DDD | 215 | 6998 | 22 | 47
EEE | K-4894844 | EEE | EEE | EEE | 658 | 9654 | 35 | 55
Spreadsheet: 807887d1670134777-transpose-a-table-into-column-sample-36-ans
Sheet: sample1

 | [NAME] |  |  |  |  | [NAME] | Ibrahim | [NAME] | [NAME] | Isobelle
 | [NAME] |  |  |  |  | [NAME] | Kirsten | Edna | [NAME] | Lina
 | Alistair |  |  |  |  | Callum | Agnes | Maksymilian | Shannon | [NAME]
 | Barney |  |  |  |  | Hiba | Barney | Alistair | [NAME] | [NAME]
 | Hiba
 | [NAME]
 | Shannon
 | Maksymilian
 | Agnes
 | Callum
 | Lina
 | [NAME]
 | Edna
 | Kirsten
 | [NAME]
 | Isobelle
 | [NAME]
 | [NAME]
 | Ibrahim
 | [NAME]