tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 143940d1330632712-excel-2007-if-formula-help-ccl-expense-report-trial
Sheet: Expense Report

Employee Name |  |  |  |  | For the month ended: |  |  |  |  |  | Account Code: | Total:
 |  |  |  |  |  |  |  |  |  |  |  |  | Instructions on completing report:
Cost Center |  |  |  |  |  |  |  |  |  |  |  |  | A.)  Enter 'Employee Name'.  (A1)
 |  |  |  |  |  |  |  |  |  |  |  |  | B.)  Enter ending month of report.  (F1)
Description: | Cost Code: | Date: |  |  | Amount: |  |  | Account Code: |  | Total: |  |  | C.)  Enter respective Employee Cost Center Number in 'Cost Center'.  (A4)
 |  |  |  |  |  |  |  |  |  |  |  |  | D.)  Description:  Column 'A', enter expense description (Lunch, Gas, Supplies etc.).
 |  |  |  |  | 210 |  |  | 7501-Expense Report: Auto & Truck Expense-Mileage-SG&A Expense |  |  |  |  | E.)  Cost Code:  Column 'B', enter respective expense Cost Code.  [NAME] listing of codes is on a tab labeled 'Cost Codes' at the bottom of this worksheet.
 |  |  |  |  |  |  |  |  |  |  |  |  | F.) Date:  Column 'C', enter date of expense.
 |  |  |  |  |  |  |  |  |  |  |  |  | G.)  Amount:  Column 'F', enter amount of expense.  This amount will auto-fill Column 'K'.
 |  |  |  |  |  |  |  |  |  |  |  |  | H.)  Account Code:  Column 'I', use the drop-down at the right of the cell to locate the appropriate account code for the respective expense and select code.  A complete listing of all Company 'Account Codes'  are on a tab labeled 'Account Codes' at the bottom of this worksheet.
 |  |  |  |  |  |  |  |  |  |  |  |  | I.)  Sign Report Below. (N25)
 |  |  |  |  |  |  |  |  |  |  |  |  | J.)  [NAME] report to supervisor/management.
 |  |  |  |  |  |  |  |  |  |  |  |  | K.)  Attach all receipts with the submittal of this report.
 |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE SIGNATURE: | DATE:
 |  |  |  |  |  |  |  |  |  |  |  |  | MANAGER APPROVAL: | DATE:
 |  |  |  |  |  |  |  | PAGE TOTALS: |  |  | ACCOUNT CODE TOTALS:
Spreadsheet: 872695d1719056110-getting-data-from-one-workbook-to-another-croy79-ghm-team-v2-aligw
Sheet: Girls All

 | 2012 | Result |  | 2013 | Result |  | 2014 | Result |  | 2015 | Result
100 |  | 16.66
 | [NAME] | 17.32
 | Ella Spink | 18.4
 | Matilda Dawson | 18.54
200
800
1500
Shot
Discus
Long
High
Spreadsheet: 100286d1298664545-delete-n-a-row-sample1test111
Sheet: 1

Week | ID | Employee | Hour
1 |  | Adam | 45
1 |  | [NAME] | 40
1 |  | Chad | 20
1 |  | [NAME] | 35
1 |  | Fred | 40
Spreadsheet: a66f579e-3e0d-4360-9232-d2e6ee25fb76
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Atlantic-Elektra | 75678683510 | Switchfoot | Fading West Ep | 2013-10-22 | Compact Disc | Rock | 0.5 | N | To Be Retired
Merch | 679143052230 | Switchfoot | [NAME] Large | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052247 | Switchfoot | [NAME] [NAME]-West Ladies Medium | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052254 | Switchfoot | [NAME] [NAME]-West Ladies Large | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052261 | Switchfoot | [NAME] [NAME]-West Ladies Xlarge | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052179 | Switchfoot | [NAME] | 2014-01-14 | Misc | Na | 14.99 | N | Available
Merch | 679143052216 | Switchfoot | [NAME] Medium | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052186 | Switchfoot | [NAME] | 2014-01-14 | Misc | Na | 14.99 | N | Available
Merch | 679143052223 | Switchfoot | [NAME] | 2014-01-14 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143052193 | Switchfoot | [NAME] Poster | 2014-01-14 | Poster | Na | 4.99 | N | Available
Merch | 679143052162 | Switchfoot | [NAME] | 2014-01-14 | Misc | Na | 4.99 | N | Available
Merch | 679143052209 | Switchfoot | [NAME] 5 Button Pack | 2014-01-14 | Misc | Na | 4.99 | N | Available
Atlantic-Elektra | 75678683824 | Switchfoot | Fading West | 2014-01-14 | Compact Disc | Ac | 13.99 | Y | Available
Spreadsheet: 06edc1dd-d75a-4033-bd23-917bb109855c
Sheet: Mathematics Grade 7

2013 Minnesota Comprehensive Assessments-Modified
Grade 7 Mathematics
Raw Score | Scale Score | Level
0 | 138 | D
1 | 152 | D
2 | 160 | D
3 | 165 | D
4 | 168 | D
5 | 171 | D
6 | 174 | D
7 | 176 | D
8 | 178 | D
9 | 180 | D
10 | 182 | D
11 | 183 | D
12 | 185 | D
13 | 186 | D
14 | 188 | D
15 | 190 | P
16 | 191 | P
17 | 192 | P
18 | 194 | P
19 | 195 | P
20 | 196 | P
21 | 198 | P
22 | 199 | P
23 | 200 | M
24 | 203 | E
25 | 204 | E
26 | 206 | E
27 | 208 | E
28 | 210 | E
29 | 212 | E
30 | 214 | E
31 | 217 | E
32 | 221 | E
33 | 226 | E
34 | 234 | E
35 | 248 | E
End of Worksheet
Spreadsheet: 59424d1259926291-vlookup-within-vlookups-new-copy
Sheet: Sheet1

Date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
Quote |  |  |  |  |  |  |  |  |  |  |  | 81105
AGL ref |  |  |  |  |  |  |  |  |  |  |  | 10/1105/09
Shipper ref
Shipper short code |  |  |  |  |  |  |  |  |  |  |  | Client 1
Shipper
Contact |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | This is where you choose the consignee
Consignee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | associated with the shipper
Notify
Loading cargo at
Collection date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
Collection time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 | hrs
Haulage by
Shipping line
Departure airport
[NAME] airport
Final destination
Flight number
ETS
Connecting airport
ETS
ETA
Time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 | hrs
Freight charges payable
Other charges payable
Declared value of goods
Amount of insurance
Shipping marks &/or case numbers
Number and kind of packages
Dimensions |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
Total number of items
Gross weight |  |  |  |  |  |  |  |  |  |  |  |  | kgs
Chargeable weight |  |  |  |  |  |  |  |  |  |  |  |  | kgs
Cube |  |  |  |  |  |  |  |  |  |  |  |  | m³
Booking ref
MAWB no
Booking confirmation date
Invoice date
Spreadsheet: 102224d1300212245-excel-2007-merging-sorting-and-conditional-formatting-testscores
Sheet: Sheet1

Name | ID | Score | Test
[NAME] | 1 |  | Pre1
Fred | 2 |  | Pre1
[NAME] | 3 |  | Pre1 |  |  |  | Sum of Score | Column Labels
[NAME] | 4 |  | Pre1 |  |  |  | Row Labels | Pre1 | Pre2 | Pre3 | Test1 | Grand Total
[NAME] | 5 |  | Pre1 |  |  |  | Betty | 98 | 56 | 81 | 82 | 317
Betty | 6 |  | Pre1 |  |  |  | [NAME] | 94 | 78 | 59 | 59 | 290
[NAME] | 7 |  | Pre1 |  |  |  | [NAME] | 66 | 51 | 41 | 77 | 235
[NAME] | 1 |  | Pre2 |  |  |  | Fred | 97 | 43 | 44 | 55 | 239
Fred | 2 |  | Pre2 |  |  |  | [NAME] | 66 | 79 | 80 | 84 | 309
[NAME] | 3 |  | Pre2 |  |  |  | [NAME] | 63 | 95 | 49 | 55 | 262
[NAME] | 4 |  | Pre2 |  |  |  | [NAME] | 96 | 88 | 91 | 42 | 317
[NAME] | 5 |  | Pre2 |  |  |  | Grand Total | 580 | 490 | 445 | 454 | 1969
Betty | 6 |  | Pre2
[NAME] | 7 |  | Pre2
[NAME] | 1 |  | Pre3
Fred | 2 |  | Pre3
[NAME] | 3 |  | Pre3
[NAME] | 4 |  | Pre3
[NAME] | 5 |  | Pre3
Betty | 6 |  | Pre3
[NAME] | 7 |  | Pre3
[NAME] | 1 |  | Test1
Fred | 2 |  | Test1
[NAME] | 3 |  | Test1
[NAME] | 4 |  | Test1
[NAME] | 5 |  | Test1
Betty | 6 |  | Test1
[NAME] | 7 |  | Test1
Spreadsheet: 271661d1382018233-sumif-dependant-upon-date-range-book3
Sheet: Sheet1

 |  | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-30 00:00:00 | 2013-12-31 00:00:00 | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 1 | 2013-09-30 00:00:00 | PTD
 |  |  |  |  |  |  |  |  | 2
ABC |  | 12987.4284 | 2530.014291967789 | 2143.792154616624 | 2205.162420335468 | 2770.11033056236 | 2321.828612703219 | 2354.294053817666 | 6 |  |  | The total here should be 12,987+2,530 =
Spreadsheet: 493217d1481595281-counting-number-of-people-in-a-queueing-system-workbook3
Sheet: Sheet1

 |  |  |  | Desk A (Triage)
 |  | Students |  | Inter-arrival time | Arrival time | Enquiry start | Enquiry resolved | Time at desk | Waiting time |  | Total busy time
 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 1
Spreadsheet: 167010d1341864625-excel-2007-converting-multiple-columns-to-multiple-rows-sample-sheet
Sheet: Sheet1

Customer | Address | City | State | Zip | Sales person | Manufacturer1 | Model1 | Serial1 | Purchase Date1 | Installation Date1 | Notes1 | Manufacturer2 | Model2 | Serial2 | Purchase Date2 | Installation Date 2 | Notes2
ABC Desktop Mailer | 5688 Wadsworth Road | Dayton | OH | 45414 | House Account | BUNN | BT-16 | 81481 | 2005-12-05 00:00:00 | 2005-12-05 00:00:00 |  | Dynaric | [NAME] | 234155 | 2006-07-13 00:00:00 | 2006-07-16 00:00:00 | 25x25
Advo Printing | 124 main st. | Cincinnati | OH | 45246 | [NAME] | BUNN | 1960 | 62723 | 6/15/2006 | 6/16/2006 |  | BUNN | 1960 | 16543 | 2007-05-12 00:00:00 | 2007-05-12 00:00:00 | 16"
Spreadsheet: 445c0e3f-f1c4-423a-9c25-0fe648b4482b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
265692 | 81048 | Francesca | [NAME] | ITA | 258 | 00:19:40 | 00:00:49 | 00:28:44 | 00:02:15 | 00:23:10 | 1 | 01:14:41
265692 | 26993 | Luisa | Caggiati | ITA | 257 | 00:21:00 | 00:01:10 | 00:30:12 | 00:01:56 | 00:27:42 | 2 | 01:22:02
265692 | 69042 | Moretti | Anna | ITA | 256 | 00:22:14 | 00:00:54 | 00:29:21 | 00:01:45 | 00:32:02 | 3 | 01:26:19
Spreadsheet: 4e79c43d-a0be-4599-8d6e-ffb93c4f8561
Sheet: Sheet1

INDEX
Non-Controlling Interests – Ownership
Summary financial information based on 100% ownership
Intangible assets
Carrying amounts of goodwill and publishing rights per global operating division
Assumptions WACC
Property, plant, and equipment
Investments in equity-accounted investees
Summary financial information on net equity-accounted investees (at 100%) and the Group's weighted proportionate share
Financial assets
Deferred tax assets and liabilities
Deferred tax assets – Movement in temporary differences, 2011
Deferred tax assets – Movement in temporary differences, 2010
Movements in overall tax position
Deferred tax on items recognized immediately in other comprehensive income and immediately in equity
Inventories
Trade and other receivables
Cash and cash equivalents
Other current liabilities
Long-term debt
Net debt
Gross debt
Approximate impact of 1% decline of the U.S. dollar against the euro
Aging analysis of trade receivables
Fair value of financial instruments
Financial instruments
Fair value hierarchy level 3
Sensitivity
Employee benefits
Provision for pensions – Assumptions
Provision for pensions – Plan liabilities and assets
Provision for pensions – Actuarial gains/(losses)
Provision for pensions – Funded status
Provision for pensions – Sensitivity
Provision for pensions – Proportion of plan assets
Provision for restructuring commitments
Number of shares
Spreadsheet: 823113d1679715637-summarizing-a-workbook-lego-replacement-parts
Sheet: Set # 7657

Checked | Qty | Part# | Colour | Description
 | 1 | 2877 | Light Grey | Modified 1 x 2 with Grille / Fluted Profile
 | 2 | 50947 | [NAME] | Vehicle, Mudguard 1 x 4 1/2
 | 1 | 4740 | Light Grey | Dish 2 x 2 Inverted (Radar)
 | 1 | 44302 | Light Grey | Hinge Plate 1 x 2 Locking with 2 Fingers on End (Undetermined Type)
 | 3 | 44301 | [NAME] | Hinge Plate 1 x 2 Locking with 1 Finger on End (Undetermined Type)
 | 1 | 3023 | Light Grey | 1 x 2 flat
 | 1 | 3022 | [NAME] | 2 x 2 flat
 | 1 | 3020 | Light Grey | 2 x 6 flat
 | 6 | 4073 | Light Grey | Plate, Round 1 x 1
 | 1 | 4211508 | Light Grey | Pneumatic T Piece Second Version (T Bar with Ball in Center)
Spreadsheet: 112098d1308248047-excel-2008-mixing-conditional-formatting-and-if-then-mattpalazola
Sheet: Sheet1

 | PART NUMBER | PART DESCRIPTION | QTY REQD | QTY ON HAND | STATUS | QTY SHORTAGE
 |  |  | 3 | 3 | Del | 0
 |  |  | 3 | 3 | Del | 0
 |  |  | 3 | 5 | Del | -2
 |  |  | 3 | 0 | [NAME] | 3
 |  |  | 3 | 0 | [NAME] | 3
 |  |  | 3 | 0
 |  |  | 3 | 0
 |  |  | 3 | 0 | [NAME] | 3
Spreadsheet: lindy_donoho__21969__TW2010ProjCap&Rev
Sheet: TW Capacity & Rev thru 2010

 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
SUBSCRIBED
WEST
System Capacity | 1160000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000
Subscribed Volume | 1126842 | 1083283 | 999783 | 846533 | 477033 | 262658 | 184117 | 101033 | 98700
Average Rate
Revenue | 131902435 | 140351887 | 125045943 | 109372433 | 53551877 | 27357003 | 18651674 | 13343910 | 13216230
EAST
System Capacity | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827
Subscribed Volume | 619809 | 220196 | 74363 | 72218 | 35500 | 667 | 0 | 0 | 0
Average Rate |  |  |  |  |  |  | 0 | 0 | 0
Revenue | 8066199 | 3764821 | 1853421 | 1802132 | 948480 | 12160 | 0 | 0 | 0
IGNACIO TO BLANCO
System Capacity
Subscribed Volume | 652000 | 555000 | 262917 | 252500 | 63542 | 55000 | 0 | 0 | 0
Average Rate |  |  |  |  |  |  | 0 | 0 | 0
Revenue | 10777651 | 7563885 | 2580960 | 2352960 | 59280 | 0 | 0 | 0 | 0
SAN JUAN (BL TO TH)
System Capacity | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000
Subscribed Volume | 841863 | 843929 | 807333 | 698000 | 433500 | 156000 | 93083 | 10000 | 10000
Average Rate
Revenue | 21688947 | 22489926 | 21748403 | 18943578 | 12409949 | 1745021 | 0 | 0 | 0
TOTAL SUBSCRIBED REVENUE
UNSUBSCRIBED (at Risk)
WEST
System Capacity | 1160000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000 | 1210000
ReSubscribed Volume | 33158 | 126717 | 210217 | 363467 | 732967 | 947342 | 1025883 | 1108967 | 1111300
Average Rate | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565 | 0.2565
Revenue
EAST
System Capacity | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827 | 688827
ReSubscribed Volume | 69018 | 468631 | 614464 | 616609 | 653327 | 688160 | 688827 | 688827 | 688827
Average Rate | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591 | 0.0591
Revenue
IGNACIO TO BLANCO
System Capacity | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000 | 681000
ReSubscribed Volume | 29000 | 126000 | 418083 | 428500 | 617458 | 626000 | 681000 | 681000 | 681000
Average Rate | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428 | 0.0428
Revenue
SAN JUAN (BL TO TH)
System Capacity | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000 | 850000
ReSubscribed Volume | 8137 | 6071 | 42667 | 152000 | 416500 | 694000 | 756917 | 840000 | 840000
Average Rate | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 0.1043
Revenue
TOTAL UNSUBSCRIBED REVENUE
TOTAL REVENUE
Spreadsheet: 27043d1219842891-sum-the-range-of-data-if-two-conditions-are-satisfied-651623-sum-the-range-of-data-if-two-conditions-are-satisfied
Sheet: SHEET1

Sr. No. | Date | Month | [NAME] | Amount | Location
1 | 2001-01-01 00:00:00 | January | 20 | 214 | [NAME]
8 | 2001-01-02 00:00:00 | January | 55 | 22 | [NAME] |  |  | Data | Location
9 | 2001-01-03 00:00:00 | January | 20 | 8 | [NAME] |  |  | Sum of Amount |  | Sum of Miles |  | Total Sum of Amount | Total Sum of Miles
10 | 2001-02-01 00:00:00 | February | 15 | 6 | [NAME] |  | Month | [NAME] | Loc2 | [NAME] | Loc2
11 | 2001-02-02 00:00:00 | February | 23 | 9.2 | [NAME] |  | January | 244 |  | 95 |  | 244 | 95
2 | 2001-02-03 00:00:00 | February | 38 | 15.2 | Loc2 |  | February | 15.2 | 15.2 | 38 | 38 | 30.4 | 76
12 |  | March | 10 | 4 | [NAME] |  | March | 5.6 | 15.2 | 14 | 38 | 20.8 | 52
3 |  | March | 38 | 15.2 | Loc2 |  | April | 3.6 | 15.2 | 9 | 38 | 18.8 | 47
13 |  | March | 4 | 1.6 | [NAME] |  | May | 8.4 |  | 21 |  | 8.4 | 21
14 |  | April | 4 | 1.6 | [NAME] |  | June | 12 |  | 30 |  | 12 | 30
4 |  | April | 38 | 15.2 | Loc2 |  | July | 10.8 | 4.8 | 27 | 12 | 15.6 | 39
15 |  | April | 5 | 2 | [NAME] |  | August | 13.2 | 6 | 33 | 15 | 19.2 | 48
16 |  | May | 6 | 2.4 | [NAME] |  | September | 14.8 | 8 | 37 | 20 | 22.8 | 57
17 |  | May | 7 | 2.8 | [NAME] |  | Grand Total | 327.6 | 64.4 | 304 | 161 | 392 | 465
18 |  | May | 8 | 3.2 | [NAME]
19 |  | June | 9 | 3.6 | [NAME]
20 |  | June | 10 | 4 | [NAME]
21 |  | June | 11 | 4.4 | [NAME]
5 |  | July | 12 | 4.8 | Loc2
22 |  | July | 13 | 5.2 | [NAME]
23 |  | July | 14 | 5.6 | [NAME]
6 |  | August | 15 | 6 | Loc2
24 |  | August | 16 | 6.4 | [NAME]
25 |  | August | 17 | 6.8 | [NAME]
26 |  | September | 18 | 7.2 | [NAME]
27 |  | September | 19 | 7.6 | [NAME]
7 |  | September | 20 | 8 | Loc2
Spreadsheet: 789284d1659023656-what-should-be-a-text-return-is-coming-up-a-date-pm-status-help-sgtkling
Sheet: PMStatus

Asset | Current Mileage | Date |  | Mileage last PM | Date last PM | PM Type | WHAT G2 SHOULD BE
132 |  |  |  |  |  |  | PM-A
133 |  |  |  |  |  |  | PM-B
134
Spreadsheet: 92518d1292078711-retrieve-non-unique-values-book22_b
Sheet: Sheet1

1 |  | 1
2 |  | 9
3 |  | 20
4
5
6 |  | Col. A is not sorted.
7 |  | Need to present only the repetitive values in adjacent cells as shown in col. C
8 |  | A sheet formula is preferable.
9
12
11
13
9
10
14
15
16
20
19
17
18
23
22
21
20
24
25
1
26
27
Spreadsheet: 83464d1283436468-rolling-average-formula-example
Sheet: Sheet1

 | Midnight | Day | Afternoon | Total
2010-08-01 00:00:00 | 5 | 5 | 8
2010-08-02 00:00:00 | 6 | 9 | 5
2010-08-03 00:00:00 | 1 | 64 | 6
2010-08-04 00:00:00 | 23 | 6 | 4
2010-08-05 00:00:00 | 5 | 5 | 4 |  |  | 30 shift average
2010-08-06 00:00:00 | 4 | 12 | 1
2010-08-07 00:00:00 | 6 | 3 | 6
2010-08-08 00:00:00 | 2 | 2 | 4
2010-08-09 00:00:00 | 3 | 31 | 5
2010-08-10 00:00:00 | 1 | 6 | 8
2010-08-11 00:00:00 | 9
2010-08-12 00:00:00
2010-08-13 00:00:00
2010-08-14 00:00:00
2010-08-15 00:00:00
2010-08-16 00:00:00
2010-08-17 00:00:00
2010-08-18 00:00:00
2010-08-19 00:00:00
2010-08-20 00:00:00
2010-08-21 00:00:00
2010-08-22 00:00:00
2010-08-23 00:00:00
2010-08-24 00:00:00
2010-08-25 00:00:00
2010-08-26 00:00:00
2010-08-27 00:00:00
2010-08-28 00:00:00
2010-08-29 00:00:00
2010-08-30 00:00:00
2010-08-31 00:00:00
Spreadsheet: 120695d1315464861-lookup-multiple-returns-lookup
Sheet: Saleman a

Forename | Surname | DOB | Gender | Attribute | Postcode
[NAME] | Smith | 1963-03-11 00:00:00 | f | B-S-11/03/1963-f | unknown
Beard | [NAME] | 1980-07-09 00:00:00 | f | B-D-09/07/1980-f | unknown
Bhudia | Dalel | 1989-08-01 00:00:00 | m | B-D-01/08/1989-m | unknown
Spreadsheet: 219017d1362647064-search-in-sheet-1-and-return-to-sheet-2-using-lookup-find-and-match-3
Sheet: Blad3

 |  |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/904811-search-in-sheet-1-and-return-to-sheet-2-using-lookup.html
 |  |  |  |  |  | Example: if SAN is typed in B3, it should return the values from the same row in column A (in sheet 1)
 | rrr |  |  |  |  | SAN
10 | Text 2 | - | - | - | 10 | Text 3
11 | Text 3 | Text 10 | - | - | 11 | Text 2
12 | - | - | - | - | 12 | Text 3
13 | Text 7 | Text 8 | Text 9 | - | 13 | Text 12
 |  |  |  |  |  |  |  | Note that AN will give hits for SAN since it's searching for a string within a string.
Spreadsheet: 216160d1361623962-workinghours-minus-3-breaks-ef365_uren2
Sheet: Uren overzicht lijst 2013

 | WEEK | BeginDag | 2013-02-04 00:00:00 |  | Week:
 |  | Weekdag | Datum | Start Werk | Begin pauze 1 | Einde pauze 1 | [NAME] | Einde Lunch | Begin pauze 2 | Einde pauze 2 | Einde Werk | Totaal Uren/Dag | Normale uren | Overuren | Totaal Uren/Week
 |  |  |  | 7:04:00 | 9:30:00 | 9:45:00 | 12:30:00 | 12:45:00 | 14:30:00 | 14:45:00 | 10:34:00
 |  |  |  | 8:04:00 | 9:30:00 | 9:45:00 | 12:30:00 | 12:45:00 | 14:30:00 | 14:45:00 | 11:34:00
 |  |  |  |  | 9:30:00 | 9:45:00 | 12:30:00 | 12:45:00 | 14:30:00 | 14:45:00
 |  |  |  |  | 9:30:00 | 9:45:00 | 12:30:00 | 12:45:00 | 14:30:00 | 14:45:00
 |  |  |  | 7:14:00 | 9:30:00 | 9:45:00 | 12:30:00 | 12:45:00 | 14:30:00 | 14:45:00 | 16:31:00
 |  |  |  |  |  |  |  |  |  |  | Week totaal |  |  |  |  |  | [NAME] | uitbetalen | verlofuren | subtotaal | opname | rest
 |  |  |  |  |  |  |  |  |  |  | Totaal aan Uren |  |  |  |  |  |  | 1 day, 0:00:00 |  |  | 00:00:00 | 3 days, 6:09:00
Spreadsheet: michelle_lokay__26566__imbalsumm0012
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | 6271 |  |  | 5000
2 | 12463 |  |  | 10000
3 | 10327 |  |  | 10000
4 | 9612 |  |  | 10000
5 | 5169 |  |  | 5000
6 |  |  |  | 5000
7 |  |  |  | 5000
8 |  |  | 5474 | 5000
9 |  |  | 6224 | 5000
10 |  |  | 5258 | 5000
11 | 15176 |  |  | 15000
12 | 27288 |  |  | 27053
13 | 16236 |  |  | 16666
14 |  |  |  | 5000
15 |  |  |  | 5000
16 |  |  |  | 5000
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | 28281
 | 2000-12-16 00:00:00
Spreadsheet: 721832d1614881582-formula-average-that-automatically-calculates-and-updates-example-3
Sheet: Sheet1

 |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00
Week Nbr | Date | Name | Shift |  | Employee Count
 | 2021-01-01 00:00:00 | Anna | Day
 | 2021-01-01 00:00:00 | Becky | Day
 | 2021-01-01 00:00:00 | Carie | Swing
 | 2021-01-01 00:00:00 | Eddie | Swing
 | 2021-01-01 00:00:00 | [NAME] | Night
 | 2021-01-01 00:00:00 | George | Night
 | 2021-01-02 00:00:00 | Anna | Day
 | 2021-01-02 00:00:00 | Joy | Day
 | 2021-01-02 00:00:00 | Carie | Swing
 | 2021-01-02 00:00:00 | Eddie | Swing
 | 2021-01-02 00:00:00 | [NAME] | Night
 | 2021-01-03 00:00:00 | George | Day
 | 2021-01-03 00:00:00 | Anna | Day
 | 2021-01-03 00:00:00 | Carie | Swing
 | 2021-01-03 00:00:00 | Eddie | Night
 | 2021-01-04 00:00:00 | [NAME] | Day
 | 2021-01-04 00:00:00 | George | Day
Spreadsheet: 814637d1674522064-transfer-selected-data-from-a-master-sheet-to-another-sheet-in-a-different-cell-address-player-test
Sheet: PORTLAND

 |  | PORTLAND
 | TEE | LAST NAME | FIRST NAME | ORDER
 |  |  | [NAME]
 |  | Canter | Cole
 |  | Chance | Bray
 |  | Faust | Hugh
 |  | Fraiser | [NAME]
 |  | Grainger | Gil
 |  | Jaimeson | [NAME]
 |  | [NAME] | Clay
 |  | Whitestone | Zach
 |  | Wilde | [NAME]
Spreadsheet: 52570d1252429219-delete-rows-with-multiple-criteria-delete-rows-many-criteria
Sheet: Sheet1

Student Id's | Score A | Score B | Difference
1 | 1
2 |  | 0.97
3 | 1 |  |  |  |  | Rules:
4 | 0.75 | 0.9147 |  |  |  | 1) Filter out purple ID's
5 | 1 | 0.9796 |  |  |  | 2) KEEP Rows if the following conditions ARE met (hide the rest)
6 | 0.9563 | 0.9389
7 | 0.983 | 0.9659 |  |  |  | 3) If a student in a purple row only has Score B but Score A is blank
8 | 1 | 1 |  |  |  | 4) Score A is 100% or less than 85%
9 | 0.975
10 | 1 | 0.9762 |  |  |  | INTENDED RESULTS
11 | 0.9199 | 0.9502 |  |  |  | Student Id's | Score A | Score B | Difference |  | all purple ID's only (see 1)
12 | 0.9474 | 0.9789 |  |  |  | 2 |  | 0.97 |  |  | is missing Score A (see 3)
13 | 0.9583 | 0.88 |  |  |  | 4 | 0.75 | 0.9147 | -0.1647 |  | Score A is less than 85% and difference is greater than -5% (see 2 & 4)
14 | 1 | 1 |  |  |  | 10 | 1 | 0.9762 | 0.02380000000000004 |  | Score A is 100% (see 4)
15 | 0.9299 | 0.9542 |  |  |  | 13 | 0.9583 | 0.88 | 0.07830000000000004 |  | Difference is greater than 5% (see 2)