tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101460d1299590862-filter-filtering
Sheet: Sheet1

Functions | CC |  |  |  | Function | CC
A | 695.4652311293908 |  |  |  | A | 5420.022086554354
A | 9440.451186746244 |  |  |  |  | 1045.191950825313
A | 5033.817016175266 |  |  |  |  | 3839.269438860651
B | 1166.502349789047
B | 1641.762091909182
B | 9961.714175013025 |  |  |  | *
B | 5606.031552085034 |  |  |  | B | 4705.209762616028
B | 1365.28763656484 |  |  |  |  | 9565.585960204608
B | 6247.628693302198 |  |  |  |  | 2862.49759595468
B | 4772.887412300762 |  |  |  |  | 1051.568722576892
C | 7619.203960381597 |  |  |  |  | 9231.840765960183
D | 7666.848654566758 |  |  |  |  | 3610.807843802064
D | 6581.901781349941 |  |  |  |  | 6992.793207946599
E | 5652.199933916746
E | 4091.544875283848
E | 5736.2700322268
E | 6290.116183871073
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 10c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60+ | TOTAL
Cross-Currency Basis | 1631337 | 800397 | 2525030 | 2281863 | 3625571 | 3689633 | 14553831
Cross-Currency Fixed-Fixed | 26675 | 15959 | 22462 | 45668 | 118997 | 196138 | 425899
Cross-Currency Fixed-Float | 149501 | 100541 | 172289 | 248933 | 379123 | 234948 | 1285335
TOTAL
Spreadsheet: 37810d1235840276-how-do-i-link-cell-contents-across-worksheets-example-1-
Sheet: Lookup

SUPPLIER | SKU | Composite | COST
A | 1234 | A 1234 | 1
B | 514 | B 514 | 2
X | 561651 | X 561651 | 4
B | 51 | B 51 | 5
B | 51 | B 51 | 6
A | 5185 | A 5185 | 7
X | 1851 | X 1851 | 8
X | 651 | X 651 | 9
X | 891 | X 891 | 10
A | 65 | A 65 | 11
A | 89 | A 89 | 12
A | 156 | A 156 | 13
 | 418 | 418 | 14
X | 18 | X 18 | 15
B | 16518 | B 16518 | 16
X | 5165 | X 5165 | 17
X | 185 | X 185 | 18
X | X | X X | 19
IM | 1234 | IM 1234 | 1
IM | 514 | IM 514 | 2
EN | 51 | EN 51 | 5
EN | 51 | EN 51 | 6
IM | 5185 | IM 5185 | 7
IM | 65 | IM 65 | 11
EN | 89 | EN 89 | 12
IM | 156 | IM 156 | 13
EN | 16518 | EN 16518 | 16
X | 1 | X 1 | 17
Spreadsheet: 715036d1611517136-count-of-users-based-on-start-and-end-dates-sample
Sheet: Sheet1

User UD | Status | Start Date | End Date
1001 | Existing | 2020-10-12 00:00:00 | 2023-12-12 00:00:00
1002 | Existing | 2020-02-10 00:00:00 | 2023-06-30 00:00:00
1003 | Existing | 2019-04-25 00:00:00 | 2022-03-31 00:00:00
1004 | Existing | 2018-05-15 00:00:00 | 2021-12-31 00:00:00
1005 | Existing | 2018-08-27 00:00:00 | 2022-02-28 00:00:00
1006 | Existing | 2020-02-14 00:00:00 | 2023-09-30 00:00:00
1007 | Existing | 2019-08-13 00:00:00 | 2025-05-31 00:00:00
1008 | Existing | 2019-11-01 00:00:00 | 2020-12-31 00:00:00
1009 | Existing | 2020-01-01 00:00:00 | 2021-12-31 00:00:00
1010 | Existing | 2019-11-01 00:00:00 | 2021-10-31 00:00:00
1011 | Existing | 2019-11-01 00:00:00 | 2023-05-31 00:00:00
1012 | Existing | 2019-10-07 00:00:00 | 2021-01-29 00:00:00
1013 | Existing | 2020-01-01 00:00:00 | 2020-12-31 00:00:00
1014 | Existing | 2020-01-01 00:00:00 | 2020-12-31 00:00:00
1015 | Existing | 2018-02-06 00:00:00 | 2022-12-31 00:00:00
1016 | Existing | 2019-11-01 00:00:00 | 2020-12-31 00:00:00
1017 | Existing | 2021-01-01 00:00:00 | 2023-12-31 00:00:00
1018 | Existing | 2019-08-19 00:00:00 | 2022-12-31 00:00:00
1019 | Existing | 2019-07-01 00:00:00 | 2021-05-14 00:00:00
1020 | Existing | 2020-01-01 00:00:00 | 2021-03-31 00:00:00
1021 | Existing | 2020-03-01 00:00:00 | 2021-08-31 00:00:00
1022 | Existing | 2020-01-01 00:00:00 | 2023-03-31 00:00:00
1023 | Existing | 2017-09-24 00:00:00 | 2021-07-31 00:00:00
1024 | Lost | 2019-04-01 00:00:00 | 2020-03-05 00:00:00
1025 | Existing | 2020-01-01 00:00:00 | 2021-06-30 00:00:00
1026 | Existing | 2020-01-01 00:00:00 | 2021-12-31 00:00:00
1027 | Existing | 2020-01-01 00:00:00 | 2021-12-31 00:00:00
1028 | Existing | 2020-01-01 00:00:00 | 2021-12-31 00:00:00
1029 | Existing | 2020-01-01 00:00:00 | 2021-12-31 00:00:00
1030 | Existing | 2020-01-01 00:00:00 | 2021-12-31 00:00:00
1031 | Existing | 2020-01-01 00:00:00 | 2021-12-31 00:00:00
1032 | Existing | 2021-01-01 00:00:00 | 2021-12-31 00:00:00
1033 | Existing | 2021-01-01 00:00:00 | 2021-12-31 00:00:00
1034 | Planned | 2021-02-01 00:00:00 | 2021-12-31 00:00:00
1035 | Planned | 2021-09-01 00:00:00 | 2021-12-31 00:00:00
1036 | Planned | 2021-09-01 00:00:00 | 2021-12-31 00:00:00
1037 | Planned | 2021-10-01 00:00:00 | 2021-12-31 00:00:00
1038 | Planned | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
1039 | Planned | 2021-07-01 00:00:00 | 2021-12-31 00:00:00
1040 | Prospect
1041 | Prospect
1042 | Prospect
1043 | Prospect
1044 | Prospect
1045 | Prospect
1046 | Prospect
1047 | Prospect
1048 | Prospect
1049 | Prospect
1050 | Prospect
1051 | Prospect
1052 | Prospect
1053 | Prospect
1054 | Prospect
1055 | Prospect
1056 | Prospect
1057 | Prospect
1058 | Prospect
1059 | Prospect
1060 | Prospect
1061 | Prospect
1062 | Prospect
1063 | Prospect
1064 | Prospect
1065 | Prospect
1066 | Prospect
1067 | Prospect
1068 | Prospect
1069 | Prospect
1070 | Prospect
1071 | Prospect
1072 | Prospect
1073 | Prospect
Spreadsheet: louise_kitchen__22638__Third Qtr Compare 00 - 01
Sheet: Sheet1

 | MTD - June 1 - July 14, 2000 |  |  | MTD - June 1 - July 13, 2001
Commodity | Deal Count | Volume |  | Deal Count | Volume
US Gas | 51627 | 9967600456.82 |  | 102046 | 15914132683.64
Canadian Gas | 7855 | 686666079.75 |  | 10106 | 436424739.4
Continental Gas | 114 | 14537500 |  | 405 | 33661711
UK Gas | 1642 | 202497500 |  | 2245 | 294253157
US Power | 3201 | 27867912 |  | 27915 | 249982276
Continental Power | 989 | 11044330 |  | 3521 | 45161414
Nordic Power | 318 | 4201471 |  | 470 | 9256655
UK Power | 354 | 7421328 |  | 543 | 26060880
Crude & Products | 1938 | 62239599.95 |  | 9822 | 458124270.95
LPG | 264 | 3905000 |  | 409 | 8055000
Petrochemicals | 24 | 241000 |  | 54 | 543000
Coal | 67 | 3757500 |  | 16 | 286505
Emissions | 41 | 102500 |  | 20 | 50000
Paper and Pulp | 1 | 1250 |  | 100 | 409444
Weather | 280 | 4224 |  | 115 | 37700
Metals | 3 | 50 |  | 13715 | 4592772
Spreadsheet: 36640d1234512080-excel-2007-summation-of-a-concatenate-result-samplebook
Sheet: LatestTemplate

tester | Connectivity | west1 | west2 | west3 | [NAME] | west5 | west6 | west7 | west8 | west9 | west10 | west11 | west12 | west13 | west14 | west15 | west16 | west17 | west18 | west19 | west20 | west21 | west22 | west23 | west24 | west25 | west26 | west27 | west28 | west29 | [NAME] | Display Quality n readability | Touchscreen related | Information grouping | Responsiveness/ Anticipation Commands | Workflow |  | 1st [ | 1st ] | 2nd[ | 2nd] | 1st Code | 2nd code | tester1 | tester2 | tester3 | tester4 | tester5 | [NAME]
+3
+2
+1
-1
-2
-3
Code |  | wi | us |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wi
[NAME] is a great guy. :D [+3,wi] he likes to sleep.
Spreadsheet: 703278fd-c8c1-457a-b085-fce944757455
Sheet: Sheet1

WELCH INVITATIONAL 2012 TEAM RESULTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
SQUAD 1 Boys/Girls Team
School Name | [NAME] | Boys | Girls | Total
LaCrosse Logan/Central Blue | LLA | 374 | 254 | 628
East Ridge High School | ERH | 261 | 349 | 610
Rochester Varsity | RCV | 272 | 335 | 607
Woodbury Senior High | WOO | 295 | 262 | 557
Northfield High School | NOR | 240 | 302 | 542
Hastings High School | HAS | 293 | 241 | 534
Eagan-Eastview | EAE | 277 | 256 | 533
Brainerd High School | BRA | 214 | 309 | 523
Mahtomedi High School | MAH | 259 | 214 | 473
Aquinas/Onalaska/W Salem A | AQA | 228 | 242 | 470
Park High School | PAR | 143 | 297 | 440
Wayzata High School | WAY | 181 | 259 | 440
[NAME] | HIM | 275 | 146 | 421
Lakes Area Alpine | LAA | 278 | 124 | 402
Cretin-Derham Hall | CRD | 145 | 225 | 370
[NAME] | STC | 211 | 110 | 321
La Crossroads | LAC | 246 | 0 | 246
Rochester Jr Varsity | RCJ | 226 | 0 | 226
[NAME] | CFM | 0 | 216 | 216
Richfield High School | RIC | 127 | 50 | 177
LaCrosse Logan/Central Red | LLB | 100 | 0 | 100
SQUAD 2 Boys/Girls Team
School Name | [NAME] | Boys | Girls | Total
Eagan-Eastview | EAE | 359 | 326 | 685
Mahtomedi High School | MAH | 305 | 355 | 660
[NAME] | STC | 355 | 302 | 657
Hastings High School | HAS | 319 | 316 | 635
East Ridge High School | ERH | 269 | 360 | 629
Woodbury Senior High | WOO | 305 | 278 | 583
Wayzata High School | WAY | 271 | 294 | 565
Brainerd High School | BRA | 196 | 330 | 526
Northfield High School | NOR | 241 | 281 | 522
Park High School | PAR | 170 | 337 | 507
Rochester Varsity | RCV | 288 | 128 | 416
LaCrosse Logan/Central Blue | LLA | 151 | 221 | 372
[NAME] | HIM | 159 | 158 | 317
Lakes Area Alpine | LAA | 282 | 0 | 282
Aquinas/Onalaska/W Salem A | AQA | 87 | 188 | 275
Cretin-Derham Hall | CRD | 229 | 0 | 229
Rochester Jr Varsity | RCJ | 220 | 0 | 220
Richfield High School | RIC | 178 | 0 | 178
Spreadsheet: 160445d1339086779-sumproduct-month-ignore-text-tigeravatar-example-for-jennyaccord
Sheet: Hours

Provided Sample Data
From | To | Locker |  |  |  | Hours |  | Marcol's [NAME]
Back Locker |  |  |  |  |  |  |  | 6.875
2012-01-03 00:00:00 | 2012-01-05 00:00:00 | BL |  |  |  | 22.5 |  | 6.875
Front Locker
2012-01-01 00:00:00 | 2012-02-01 00:00:00 | FL |  |  |  | 15
2012-04-10 00:00:00 | 2012-04-10 00:00:00 | FL |  |  |  | 7.5
2012-04-20 00:00:00 | 2012-04-22 00:00:00 | FL |  |  |  | 22.5
[NAME]
2012-04-12 00:00:00 | 2012-04-13 00:00:00 | TL |  |  |  | 15
Spreadsheet: 70017d1270668422-looking-up-positive-values-again-stock-3-1
Sheet: Sheet1

 |  |  |  |  |  | SMITH | GARDNER | BRAIN | DUBOIS | CODEL | BRAND | SPOONS | JONES
 | PRODUCT
 | Apples 12.5Kg x 13 Country of Origin  Chile
 | [NAME] 12 x 250g Country of Origin UK |  |  |  |  | 23 |  |  |  |  | 64
 | Blackberries 8 x 200g Country of Origin UK
 | Blueberries 16 x 150g Country of Origin  Poland |  |  |  |  |  |  | 45
 | Broccoli (Bulk) Country of Origin UK |  |  |  |  |  |  | 22
 | [NAME] 9kg - 22 x 30
 | Carrots 12 x 1kg Country of Origin UK |  |  |  |  |  |  |  |  |  |  | 12
 | Cauliflower  (Bulk) Country of Origin Germany
 |  |  |  |  | 0 | 1 |  | 3 |  |  | 4 | 5 |  | 5
 | Reported as:
 | Producer | Product | Quantity
 | SMITH | [NAME] 12 x 250g Country of Origin UK | 23
 | BRAIN | Blueberries 16 x 150g Country of Origin  Poland | 45
 | BRAIN | Broccoli (Bulk) Country of Origin UK | 22
 | BRAND | [NAME] 12 x 250g Country of Origin UK | 64
 | SPOONS | Carrots 12 x 1kg Country of Origin UK | 12
Spreadsheet: 215654d1361447060-automated-classification-classification-file
Sheet: Sheet1

Classification | units |  |  | units | classification | (correct classification what it should be, is already filled in column F).
A | 250000 |  | part 1 | 100000 | A
B | 100000 |  | part 2 | 90000 | A
C | 50000 |  | part 3 | 45000 | A
 |  |  | part 4 | 35000 | B
 |  |  | part 5 | 32000 | B
 |  |  | part 6 | 28000 | B
 |  |  | part 7 | 25000 | C
 |  |  | part 8 | 20000 | C
 |  |  | part 9 | 15000 | C
 |  |  | part 10 | 10000 | C
Spreadsheet: 75f29d09-a5a8-4af1-814f-6366852dc113
Sheet: Data for graph

Region | Country | ECWP (€ PPS/m3)_Potatoes
Eastern | LV | 36.93170465602844
 | EE | 27.66315227438897
 | [NAME] | 25.11107110870313
 | RO | 11.944686016422
 | SK | 8.339516657849979
 | PL | 7.91405024170878
 | CZ | 6.473807574166426
 | BG | 3.061940823251922
 | LT | 2.972913711492857
 | SI | 1.913902687448441
 | HR | 1.871451279533122
Western | NL | 13.23002929354367
 | FI | 8.620131209696094
 | DE | 6.067205879212533
 | NO | 5.818336033173449
 | UK | 5.045328530484606
 | SE | 4.365537912758051
 | AT | 4.235905096654606
 | DK | 2.973101904899359
 | CH | 0.354487840354544
Southern | FR | 5.459236110034196
 | IT | 4.882527284223566
 | EL | 4.404180039940534
 | CY | 3.253956435787353
 | ES | 2.092978007736771
 | PT | 1.206994480832809
 | MT | 0.9658271782415851
Spreadsheet: e651a405-209b-4ad6-a789-1d9314d41941
Sheet: Sheet1

SAISD 2007 BOYS VARSITY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
BASKETBALL TOURNAMENT
TEAM ROSTER
Please return this roster no later than Nov. 9, 2007.
Fax to the Athletic Dept @ (210) 735-0250 or email to [EMAIL]
PLAYERS NAME | NUMBER |  | HEIGHT | POSITION | GRADE | EXP.
 | DARK | LIGHT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
HEAD COACH: _______________________ |  |  |  | MASCOT: ______________________
ASSISTANT COACH:__________________ |  |  |  | SCHOOL COLORS: _____________
ASSISTANT COACH:__________________ |  |  |  | TRAINERS: _________________
 |  |  |  | ________________________________
MANAGERS: _________________________
_____________________________________
Spreadsheet: 874451d1721050956-how-to-extract-the-year-and-month-month
Sheet: ag-grid

Number | Name | Description | Project Manager | Site Manager | Client | Order Number | Order Value | Status | Created On | Created By | Month | year
PR-00023 | [NAME] | refit | [NAME] | [NAME] | [NAME] | hello | 1081405.29 | Open | 05/07/2024 | [NAME] | July | 2024
PR-00014 | Players bar - AVFC | ac units |  |  | [NAME] |  | 4531.3 | Open | 03/07/2024 | [NAME] | July | 2024
PR-00008 | Solihull arts centre | set AC unites and Add pipe work | [NAME]  Hancock | [NAME] | [NAME] | SOLArtix | 3585.71 | Open | 2024-04-02 00:00:00 | [NAME] | april | 2024
PR-00006 | Testco | testing |  |  | [NAME] |  | 3585.71 | Open | 02/07/2024 | [NAME] | July | 2024
PR-00001 | Redditch Police station | refit AC units | [NAME] | [NAME] | [NAME] | [NAME] | 1305031.19 | Open | 02/07/2024 | [NAME] | July | 2024
Spreadsheet: 81504d1281645152-excel-2007-calculations-using-if-statement-excel2007if
Sheet: Sheet1

1001141 | -21.2 | -3234.074
1001141 | -3212.874 | 0
1001730 | -1527.372 | -109884.408
1001730 | -108357.036 | 0
1002189 | -54.122 | -339.411
1002189 | -285.289 | 0
1002312 | -7370 | 0
1002317 | 575.22 | 12980.059
1002317 | 12404.839 | 0
What I want it to look like:
1001141 | -21.2 | -3234.074
1001141 | -3212.874 | 0
1001730 | -1527.372 | -109884.408
1001730 | -108357.036 | 0
1002189 | -54.122 | -339.411
1002189 | -285.289 | 0
1002312 | -7370 | -7370
1002317 | 575.22 | 12980.059
1002317 | 12404.839 | 0
Spreadsheet: 473198d1470102692-pulling-data-from-another-workbook-book2
Sheet: manual_link

 | ID | Name | Grade
Spreadsheet: daren_farmer__5655__HPLN1230
Sheet: Sheet1

HPLN1230.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 30-31, 2000
 |  |  |  |  |  | **Sat. & Sn.
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 12/ 30 & 31
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 0 | *
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 0 | 0
Enron (S) |  | LS HPL EXXON KATY T.G. |  | Enron | 0 | 0
Enron (S) |  | LS HPL [NAME] |  | Enron | 0 | 0
Enron (S) |  | Texoma |  | Enron | 0 | 0
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 107462d1304621072-team-rank-without-skipping-numbers-mock-rank-by-team
Sheet: Sheet1

Team Scores
Name | Team # | Score | Team Score | Team Rank | Number of teams >
Player A | 1 | 55
Player B | 2 | 48
Player C | 1 | 18
Player D |  | 25
Player E | 2 | 44
Player F | 1 | 38
Player G |  | 60
Player H | 2 | 49
Player I |  | 41
Player J | 3 | 29
Player K | 3 | 33
Player L |  | 34
Player M | 3 | 50
 |  |  |  | ^desired output result typed in
 |  |  |  | ^Need equations to automatically calculate team scores
 |  |  |  | ^Ties are ranked as same number
 |  |  |  | ^No rank numbers are skipped
Spreadsheet: 58a2a864-2ddd-4b45-8881-5e63e3597421
Sheet: Sheet1

CHRONOLOGICA | CHRONICA | 10 | Unnamed: 3
CHRONOLOGICA | VARIA | 20
CHRONOLOGICA | [NAME] | 30
CHRONOLOGICA | PASCHALIVM | 40
CHRONOLOGICA | DE CHRISTI NATIVITATIS ET PASSIONIS ANNIS | 50 | 7962
CHRONOLOGICA | CHRONICON PASCHALE | 6 | 7960
Spreadsheet: 799025d1664883931-find-match-and-count-test-1-
Sheet: Sheet1

Phone Number | Duration | Desired Result |  | P.Number | # Calls
12345 | 1 | 6 |  | 12345 | 3
2345324 | 2 | 2 |  | 54678 | 2
23145 | 3 | 2 |  | 5432 | 2
1234 |  | SKIP |  | 56432 | 2
56432 | 4 | 2 |  | 234567 | 2
5432 | 5 | etc |  | 2345324 | 2
12345 | 7 | etc |  | 23145 | 2
12345 |  | etc |  | 786543 | 1
786543 |  | etc |  | 1234 | 1
54678 | 1 | etc |  | 23456 | 1
234567 | 2 | etc |  | Grand Total | 18
23456 | 3 | etc
12345 |  | etc
2345324 | 4 | etc
23145 | 5 | etc
1234 | 7 | etc
56432 | 1 | etc
5432 | 2 | etc
12345 | 3 | etc
12345 |  | etc
786543 | 4 | etc
54678 | 5 | etc
234567 | 7 | etc
23456 |  | etc
Spreadsheet: 456349d1460756007-formula-for-generating-multiple-returns-productivity-tracker-responses-
Sheet: Productivity Macro

Sales per labor hour |  |  |  |  |  |  |  |  | Store | Date | Time of Day | Royalty Sales | Total Man Hours | Load Time | Wait Time | <1 Minute Loads | Over used Insider Hours | cDOT | Name
weekly sales | 3 star | 4 star | 5 star |  | Hourly$ | 4 star | Labor hours
0-500 |  | 21.07 |  |  | 1000 | 21.56 | 46.38
501-1000 |  | 21.56 |  |  | 750 | 21.32 | 35.19
1001-1500 |  | 22.05 |  |  | 500 | 21.07 | 23.73
1501-2000 |  | 22.54 |  |  | 250 | 20.83 | 12
2001-2500 |  | 23.03 |  |  | 125 | 20.58 | 6.07
2501-3000 |  | 23.52 |  |  | 62.5 | 20.34 | 3.08
3001-3500 |  | 24.01 |  |  | 31.25 | 20.09 | 1.56
3501-4000 |  | 24.5 |  |  | 15.63 | 19.85 | 0.79
4001-4500 |  | 24.99
4501-5000 |  | 25.48
5001-5500 |  | 25.97
5501-6000 |  | 26.46
6001-6500 |  | 26.95
6501-7000 |  | 27.44 |  |  | 4 star | Labor hours
7001-7500 | 26.5 | 27.93 | 29.36 |  | 27.93 | 259.6
7501-8000 | 26.99 | 28.42 | 29.85 |  | 28.42 | 272.7
8001-8500 | 27.48 | 28.91 | 30.34 |  | 28.91 | 285.4
8501-9000 | 28.06 | 29.45 | 30.83 |  | 29.45 | 297.16
9001-9500 | 28.64 | 29.98 | 31.32 |  | 29.98 | 308.5
9501-10000 | 29.22 | 30.52 | 31.81 |  | 30.52 | 319.5
10001-10500 | 29.8 | 31.05 | 32.3 |  | 31.05 | 330.1
10501-11000 | 30.25 | 31.56 | 32.87 |  | 31.56 | 340.6
11001-11500 | 30.7 | 32.06 | 33.43 |  | 32.06 | 350.95
11501-12000 | 31.14 | 32.57 | 34 |  | 32.57 | 360.8
12001-12500 | 31.59 | 33.08 | 34.56 |  | 33.08 | 370.3
12501-13000 | 32.1 | 33.6 | 35.1 |  | 33.56 | 379.9
13001-13500 | 32.6 | 34.12 | 35.64 |  | 34.12 | 388.3
13501-14000 | 33.11 | 34.64 | 36.17 |  | 34.64 | 396.9
14001-14500 | 33.61 | 35.16 | 36.71 |  | 35.16 | 405.24
14501-15000 | 33.9 | 35.47 | 37.04 |  | 35.47 | 415.8
15001-15500 | 34.2 | 35.78 | 37.37 |  | 35.78 | 426.2
15501-16000 | 34.49 | 36.09 | 37.7 |  | 36.09 | 436.4
16001-16500 | 34.78 | 36.41 | 38.03 |  | 36.41 | 446.3
16501-17000 | 35.12 | 36.77 | 38.41 |  | 36.77 | 455.5
17001-17500 | 35.47 | 37.13 | 38.79 |  | 37.13 | 464.58
17501-18000 | 35.96 | 37.62 | 39.28 |  | 37.62 | 471.8
18001-18500 | 36.45 | 38.11 | 39.77 |  | 38.11 | 478.85
18501-19000 | 36.94 | 38.6 | 40.26 |  | 38.6 | 485.7
19001-19500 | 37.43 | 39.09 | 40.75 |  | 39.09 | 492.4
19500-20000 | 37.92 | 39.58 | 41.24 |  | 39.58 | 498.95
Spreadsheet: 374474d1422883084-data-capture-to-master-workbook-from-multiple-workbooks-booker1
Sheet: TC workings

UK Team Stats |  |  | Week Totals |  |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday
Member | Week No | Week | Calls | Emails | Contacts | SVs | Absence | Calls | Emails | Contacts | SVs | Calls | Emails | Contacts | SVs | Calls | Emails | Contacts | SVs | Calls | Emails | Contacts | SVs | Calls | Emails | Contacts | SVs
LG | 1 | 2015-02-02 00:00:00 | 117 | 1 | 0 | 0 |  | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 112 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 42702d1241257628-updating-a-formula-based-on-multiple-sheets-demo1
Sheet: 2

 | Estimated | No.Sold | Diff | Remarks
Apple | 26 | 24 | 2
Mango | 26 | 30 | 3
[NAME] |  | 19 |  | Free
Pine Apple | 28 | 20 | 8
Kiwi | 30 | 17 | 13
Spreadsheet: 462327d1464009252-selecting-data-according-to-text-and-placing-in-graph-capital-expense-2016-2017
Sheet: Hull

Hulls Capital Expense 2016-2017
Improment/Equipment | In-house/ Subcontract | Time Scxale | Expense | possible Savings
Rear yard grading work |  |  | 1500
painting works | inhouse |  | 500 |  |  | HULL
replacing extractor cowls | inhouse |  | 1000 |  |  | expense | Potential Saving
extractor hoses etc | subcontract |  | 2025
Emergency light defect repairs | inhouse |  | 1000
Totals
Spreadsheet: 116898d1312279420-array-formula-or-possible-macro-to-match-and-calculate-between-multiple-sheets-testbook
Sheet: Dish Databse

Ingredient | Amount | Unit | Falafel Wrap | [NAME] | Shrimp Wrap | Salmon Wrap
Chickpeas | 1 | oz | ? | ? | ? | ?
Carrots | 1 | oz | ? | ? | ? | ?
Butter | 1 | oz | ? | ? | ? | ?
Salt | 1 | oz | ? | ? | ? | ?
Sugar | 1 | oz | ? | ? | ? | ?
Spreadsheet: 761046d1640612841-data-extraction-from-range-or-table-if-criteria-are-met-sample
Sheet: OFFICE EXPENSES

Supply |  |  |  |  | Ikken
 |  |  |  |  | Kitchen
Date | Particulars | Debit |  |  | Office
 |  |  |  |  | Raj
 |  |  |  |  | Supply
Spreadsheet: 648077d1572872410-sorting-hierarchical-excel-table-keeping-certain-rows-groups-intact-hierarchical-sort-example
Sheet: Sheet1

[NAME] | Zone | Sub Zone | Consumption |  | Results:: | [NAME] | Zone | Sub Zone | Consumption
Cluster A |  |  | 10 |  |  | Cluster B |  |  | 14
 | Zone A1 |  | 10.5 |  |  |  | Zone B3 |  | 16
 |  | SubZone A1.1 | 7 |  |  |  | Zone B2 |  | 15
 |  | SubZone A1.1 | 12 |  |  |  | Zone B1 |  | 11.5
 | [NAME] |  | 9 |  |  |  |  | SubZone B1.1 | 14
 | [NAME] |  | 9.5 |  |  |  |  | SubZone B1.1 | 10
Cluster B |  |  | 14 |  |  | Cluster C |  |  | 12
 | Zone B1 |  | 11.5 |  |  |  | Zone C2 |  | 15
 |  | SubZone B1.1 | 10 |  |  |  | [NAME] |  | 13
 |  | SubZone B1.1 | 14 |  |  |  | Zone C1 |  | 11
 | Zone B2 |  | 15 |  |  |  |  | SubZone c1.1 | 11.5
 | Zone B3 |  | 16 |  |  |  |  | SubZone C1.1 | 8
Cluster C |  |  | 12 |  |  | Cluster A |  |  | 10
 | Zone C1 |  | 11 |  |  |  | Zone A1 |  | 10.5
 |  | SubZone c1.1 | 11.5 |  |  |  |  | SubZone A1.1 | 12
 |  | SubZone C1.1 | 8 |  |  |  |  | SubZone A1.1 | 7
 | Zone C2 |  | 15 |  |  |  | [NAME] |  | 9.5
 | [NAME] |  | 13 |  |  |  | [NAME] |  | 9
Spreadsheet: 77891d1278397137-copy-selective-data-book2-1-
Sheet: Sheet2

Choose device | computer
 | Consumers | Date | products ordered | cost per unit | Units ordered | TAX | Total Cost
 | Consumer 1 | 40180 | computer | 300 | 5 | 0.1 | 150
 | Consumer 5 | 40300 | computer | 300 | 5 | 0.1 | 150
 | Consumer 9 | 40423 | computer | 300 | 5 | 0.1 | 150
 | Consumer 6 | 40212 | computer | 300 | 5 | 0.1 | 150
 | Consumer 10 | 40332 | computer | 300 | 5 | 0.1 | 150
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 196990d1354180674-min-max-axis-options-issue-songlengthsvsweekscharted
Sheet: 2002

Artist | [NAME] | [NAME] | Weeks Charted
[NAME] | Gimme the Light | 03:46:00 | 35
[NAME] | Complicated | 04:05:00 | 31 |  | 4 | 5
Creed | One Last Breath | 03:59:00 | 30 |  | 3 | 59
Nelly (feat. [NAME]) | Dilemma | 04:50:00 | 25 |  | 4 | 50
Nivea (feat. Brian & Brandon Casey) | Don't [NAME] with My Man | 03:33:00 | 21 |  | 3 | 33
Keith Urban | Somebody Like You | 05:23:00 | 20 |  | 5 | 23
System of a Down | Aerials | 03:55:00 | 20 |  | 3 | 55
LL Cool J | [NAME] | 04:47:00 | 19 |  | 4 | 47
Aaliyah | I Care 4 U | 04:08:00 | 19 |  | 4 | 8
Our Lady Peace | Somewhere Out There | 04:12:00 | 19 |  | 4 | 12