tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35053__Attendance Reports for Week of May 15 - 19
Sheet: May 15 - 19

[NAME] for 7/1/00
DATE | CURRICULUM ID NUMBER | CURRICULUM NAME | DURATION | [NAME] | CAPACITY | BU Name | # REGISTERED/ PROJECTED | ACTUAL ATTENDANCE | # [NAME] | ATTENDED BUT NOT ENROLLED | INSTRUCTOR
May 15 | 16115 | General Ledger Accounting  (Day 1) | 8:00am - 5:00pm | 12C1 | 14 | ENA | 13 | 11 | 2 | 1 | [NAME]
 | 1435 | Controlling  (Day 1) | 8:00am - 5:00pm | 1492 | 12 | EES | 12 | 7 | 0 | 1 | [NAME]
May 16 | 16115 | General Ledger Accounting  (Day 2) | 8:00am - 5:00pm | 12C1 | 14 | ENA | 12 | 10 | 1 | 1 | [NAME]
 | 1435 | Controlling  (Day 2) | 8:00am - 5:00pm | 1492 | 12 | EES | 12 | 9 | 0 | 2 | [NAME]
 | 1439 | Controlling  (Day 1) | 8:00am - 5:00pm | 1446 | 16 | ENA | 17 | 16 | 1 | 0 | [NAME]
May 17 | 1435 | Controlling  (Day 3) | 8:00am - 12:00pm | 1492 | 12 | EES | 15 | 5 | 0 | 2 | [NAME]
 | 1439 | Controlling  (Day 2) | 8:00am - 5:00pm | 1446 | 16 | ENA | 16 | 16 | 0 | 0 | [NAME]
 | 19917 | Local Timekeeping | 8:00am - 5:00pm | 568 | 12 | GPG | 13 | 10 | 1 | 0 | [NAME]
 | 3131 | PS Workshop (Day 1) | 8:00am - 5:00pm | 12C1 | 12 | GPG | 8 | 7 | 1 | 0 | [NAME]
May 18 | 1439 | Controlling  (Day 3) | 8:00am - 12:00pm | 1446 | 16 | ENA | 16 | 16 | 0 | 0 | [NAME]
 | 3131 | PS Workshop (Day 2) | 8:00am - 5:00pm | 12C1 | 12 | GPG | 7 | 7 | 0 | 0 | [NAME]
 | 19918 | Local Timekeeping | 8:00am - 5:00pm | 568 | 12 | GPG | 9 | 9 | 0 | 0 | [NAME]
 | 16112 | General [NAME] (Day 1) | 8:00am - 5:00pm | 1492 | 14 | GPG | 12 | 12 | 0 | 0 | [NAME]
May 19 | 3131 | PS Workshop (Day 3) | 8:00am - 5:00pm | 12C1 | 12 | GPG | 7 | 7 | 0 | 0 | [NAME]
 | 16112 | General [NAME] (Day 2) | 8:00am - 5:00pm | 1492 | 14 | GPG | 12 | 12 | 0 | 0 | [NAME]
 | 1625 | General [NAME] | 8:00am - 5:00pm | 1446 | 16 | ENA | 8 | 7 | 0 | 0 | [NAME]
 | 19932 | Local Timpekeeping | 8:00am - 5:00pm | 568 | 12 | CORP | 8 | 4 | 0 | 0 | [NAME]
 | same | same | same | same | same | ENA | 1 | 0 | 0 | 0 | [NAME]
BU Attendance Totals for Week of May 15-19: |  |  |  | % Attendance for each BU for Week of May 15-19:
[NAME]: |  |  |  | ENA
ENA Actual: |  |  |  | EES
 |  |  |  | CORP | 0
EES Projected: |  |  |  | EECC | 0
EES Actual: |  |  |  | EG&P | 0
 |  |  |  | EGF | 0
CORP Projected: |  |  |  | INT'L | 0
CORP Actual: |  |  |  | GAO | 0
 |  |  |  | GP | 0
EECC Projected: |  | 0 |  | GPG
EECC Actual: |  | 0
EG&P Projected: |  | 0
EG&P Actual: |  | 0
EGF Projected: |  | 0
EGF Actual: |  | 0
INT'L Projected: |  | 0
INT'L Actual: |  | 0
[NAME]: |  | 0
GAO Actual: |  | 0
GP Projected: |  | 0
GP Actual: |  | 0
GPG Projected:
GPG Actual:
Spreadsheet: 851719d1701878384-work-out-age-from-specific-date-excel-example
Sheet: Sheet1

DOB | Age | Registered
1961-11-27 00:00:00 |  | 2023-07-14 00:00:00
2009-11-04 00:00:00 | 13 | 2023-06-07 00:00:00
2008-10-31 00:00:00 | 14 | 2023-05-25 00:00:00
1944-02-06 00:00:00 | 78 | 2023-01-25 00:00:00
1985-07-09 00:00:00 | 38 | 2023-08-04 00:00:00
2008-08-26 00:00:00 | 15 | 2023-10-26 00:00:00
1983-09-28 00:00:00 | 39 | 2023-03-21 00:00:00
2011-11-27 00:00:00 | 11 | 2023-11-09 00:00:00
Spreadsheet: 765861d1643643503-how-to-find-who-provides-the-most-of-a-product-max-supplier-question-example
Sheet: Papa Johns

 |  | [NAME]
 | Hot4Shop | Hot4Supplier | On Hand | On Order | Supplier A | Supplier B | Supplier C
 |  |  |  |  | 0.481 | 0.354 | 0.165
Tomato | 5 | 4 | 16 | 14
Cheese | 4 | 4 | 25
Dough | 2 | 5 | 12 | 18
Green Peppers | 3 | 2 | 37
Spreadsheet: 250280d1373893903-removing-spaces-in-column-space-remove
Sheet: Sheet1

Type | Product | Group | Name | Product Code | Description | Image
Gifting | Drinkware | Waterbottles - Plastic | 1 Litre Tritan Water Bottle | BW0020 | BPA Free Tritan Material 1 Litre Capacity Stainless Steel Band Screw-Off Lid | 15622_Thumb.png
Gifting | Drinkware | Flasks | 1.8l Plastic Vacuum Flask | BW0042 | 18/8 Stainless Steel     225ml Capacity     Twist Top     Hinged Metal Safety Lid Connector | 38305_Thumb.png
Gifting | Tools | Multi-Tools | 10 Function Stainless Pocket Knife | BT0001 | Includes:     Knife     Scissors     Can Opener     Phillips Head Screwdriver     Nail File     Punch     Corkscrew     [NAME]     Bottle Opener     Stainless Steel Construction | 14659_Thumb.png
Gifting | Leisure and Outdoor | Golf | 100% Cotton Golf Towel | BH0070 | 100% Cotton Golf Towel     Metal Clip | 38420_Thumb.png
Gifting | Office Accessories | Photo Frames | 10cm x 13cm Rounded Edge Photo Frame | BD0027 | Rounded Outer Edge     Polished Aluminium     Easel Back For Horizontal Or Vertical Display     Holds 10cm x 13cm Photo | 15727_Thumb.png
Spreadsheet: 725757d1616841118-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-2021-jt
Sheet: Opening Balance

WATERFORD PRIMARY SCHOOL
Date | Student Number | Student Name | Invoice | Amount
2020-01-01 00:00:00 | ST 001 |  | C001 | 400
2020-01-01 00:00:00 | ST 003 | [NAME] | C003 | 1000
2020-01-01 00:00:00 | ST 004 | O'Neil James | C004 | -500
2020-01-01 00:00:00 | ST 002 |  | C001 | 2000
2020-01-01 00:00:00 | ST 003 |  | C001 | 1750
2020-01-01 00:00:00 | ST 004 |  | C001 | 1500
Spreadsheet: 9028bf84-c1e1-4ef5-9aca-753cb7379afd
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 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Wholesale Trade: Sales and Inventories
 |  | 42: Total [NAME], Except Manufacturers' Sales Branches and Offices: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: March 11, 2014 (3:53 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 138830 | 132921 | 150672 | 146927 | 141749 | 150869 | 150768 | 147079 | 152030 | 158307 | 145676 | 151302
1993 | 140824 | 138267 | 159749 | 154677 | 153693 | 158043 | 152798 | 159014 | 158768 | 160576 | 156357 | 155449
1994 | 143826 | 143069 | 171413 | 157193 | 163090 | 168454 | 157254 | 177898 | 172066 | 176341 | 171870 | 172425
1995 | 165397 | 161211 | 186778 | 170025 | 185818 | 186564 | 172384 | 191076 | 181621 | 193246 | 184672 | 180188
1996 | 178477 | 176150 | 189303 | 189906 | 195454 | 185356 | 193212 | 196149 | 190873 | 209454 | 189016 | 190993
1997 | 186983 | 181571 | 200205 | 198723 | 200357 | 199810 | 200632 | 195457 | 206341 | 215636 | 188397 | 203733
1998 | 187750 | 183337 | 211184 | 204583 | 198874 | 210701 | 204982 | 199128 | 207425 | 212915 | 196656 | 209585
1999 | 184434 | 188602 | 225471 | 212372 | 211738 | 226910 | 215120 | 223078 | 226580 | 226868 | 225903 | 232083
2000 | 208053 | 218632 | 248659 | 222637 | 243460 | 247509 | 226260 | 246918 | 236862 | 248451 | 236370 | 230743
2001 | 229917 | 217231 | 245078 | 229085 | 244303 | 234330 | 228826 | 242911 | 223722 | 243615 | 227250 | 218884
2002 | 220173 | 210596 | 234089 | 237757 | 244150 | 234015 | 241943 | 245497 | 237792 | 255957 | 235200 | 238359
2003 | 235174 | 223885 | 251546 | 246386 | 244130 | 248362 | 252090 | 245444 | 255103 | 270656 | 240271 | 263198
2004 | 242352 | 244228 | 293553 | 277602 | 268938 | 286906 | 272669 | 285219 | 285668 | 286559 | 286381 | 295045
2005 | 266359 | 267299 | 315635 | 295367 | 299864 | 311151 | 289152 | 321789 | 319033 | 320282 | 310566 | 312826
2006 | 298102 | 289656 | 343521 | 311503 | 341292 | 346421 | 319057 | 353369 | 329286 | 342856 | 327941 | 323500
2007 | 319799 | 303872 | 355022 | 342331 | 364874 | 358504 | 345511 | 370222 | 343925 | 384891 | 364601 | 348237
2008 | 359515 | 347020 | 377426 | 389109 | 395499 | 405983 | 403310 | 385984 | 385870 | 382213 | 307241 | 320578
2009 | 286965 | 277083 | 310080 | 304921 | 299644 | 322612 | 315333 | 310779 | 321656 | 329795 | 314202 | 332953
2010 | 301654 | 299905 | 363792 | 352350 | 341324 | 361275 | 345270 | 358057 | 357794 | 363074 | 363972 | 372988
2011 | 350190 | 339512 | 417668 | 391446 | 398281 | 409712 | 379345 | 417407 | 403021 | 402033 | 394328 | 399033
2012 | 381593 | 381742 | 429221 | 413660 | 430742 | 409907 | 397833 | 423533 | 396139 | 434531 | 415466 | 403232
Spreadsheet: 118641d1313819097-checking-data-from-2-worksheets-emailresponded
Sheet: Sheet1

Names | Responded?
Name1 |  | <<All the N/A have not responded
[NAME] |  | << Non N/A are on the other sheet.
Name3
Name4 |  |  | There are other formulas that give this but this is the basic idea.
Name5
Name6
Name7
Name8
Name9
Name10
Name11
Name12
Name13
Name14
Name15
[NAME]
Name17
Name18
Name19
[NAME]
Name21
Name22
Name23
Name24
Name25
Name26
Name27
Name28
Spreadsheet: 840623d1692870451-matrix-lookup-probably-as-simple-as-my-previous-question-test-example2
Sheet: Riskregister

Threat | Lowest probability | Highest probability | Most likely probabilty | Calculated probability | Probabilty level | Lowest consequense | Highest consequense | Most likely consequense | Calculated consequense | Consequense level | Risk level
Something goes wrong | 0.5 | 3 | 1 |  |  | 500 | 1500 | 1100 |  |  | 5
Spreadsheet: 882989d1731476338-need-formula-that-automatically-adjusts-to-rows-and-columns-fransha-spreadsheet-spill-365-aligw
Sheet: DDD Lines

Women's POWER Pickleball League -  Fall 2024 - Team 1
 | 2024-10-08 00:00:00
 | 3
 | 2 | 3 | 3 | 3 | 2
 |  | 1 | 1 | 1 | 1
 |  |  | 4 |  | 5
 | 5 | 5 |  |  | 5
 | 3 | 2 | 2 | 2 | 2
 | 5 |  |  | 5
 | 1 | 1 | 1 | 1 | 1
 | 1 | 2 | 2 | 2
 |  |  |  | 5 | 4
 | 4 | 4 | 5 | 4 | 3
 |  | 5 | 4
 | 4 | 4 | 5 | 4 | 3
 | 2 | 3 | 3 | 3 | 4
 |  |  |  |  | assumed
Spreadsheet: 3f179d46-84d1-4fb0-b982-6c69c7f6f94e
Sheet: Retta

Università | Retta | [NAME] | Punteggio
[NAME] | 49 | Pubblica
[NAME] | 342 | Pubblica
Calabria | 414 | Pubblica
Foggia | 453 | Pubblica
Potenza | 462 | Pubblica
Lecce | 491 | Pubblica
Palermo | 501 | Pubblica
Reggio Calabria | 511 | Pubblica
Catanzaro | 514 | Pubblica
[NAME] | 528 | Pubblica
Sassari | 554 | Pubblica
Macerata | 560 | Pubblica
Valle d’Aosta | 564 | Privata
Cagliari | 565 | Pubblica
Salerno | 586 | Pubblica
Teramo | 599 | Pubblica
[NAME] | 609 | Pubblica
[NAME] | 635 | Pubblica
Ancona Politecnica | 750 | Pubblica
Bolzano | 782 | Privata
Roma Tre | 799 | Pubblica
[NAME] | 799 | Pubblica
Trento | 805 | Pubblica
Viterbo | 816 | Pubblica
[NAME] | 826 | Pubblica
[NAME] | 844 | Pubblica
[NAME] | 865 | Pubblica
Bergamo | 883 | Pubblica
[NAME] | 896 | Pubblica
Camerino | 901 | Pubblica
[NAME] | 937 | Pubblica
Pisa | 940 | Pubblica
Perugia | 945 | Pubblica
Parma | 957 | Pubblica
[NAME] | 987 | Pubblica
[NAME] | 1019 | Pubblica
Roma Foro Italico | 1028 | Pubblica
Milano Bicocca | 1088 | Pubblica
Udine | 1102 | Pubblica
Ferrara | 1113 | Pubblica
Torino | 1119 | Pubblica
Genova | 1125 | Pubblica
Urbino | 1133 | Pubblica
[NAME] | 1172 | Pubblica
Padova | 1207 | Pubblica
Trieste | 1227 | Pubblica
[NAME] | 1252 | Pubblica
[NAME] | 1254 | Pubblica
Siena | 1261 | Pubblica
Pavia | 1327 | Pubblica
[NAME] | 1329 | Pubblica
[NAME] | 1411 | Pubblica
[NAME] | 1426 | Pubblica
Napoli S.Orsola | 1437 | Privata
Milano Statale | 1499 | Pubblica
[NAME] | 1726 | Pubblica
Enna Kore | 1852 | Privata
[NAME] | 2840 | Privata
Milano Cattolica | 4072 | Privata
[NAME] | 4093 | Privata
Milano Iulm | 4481 | Privata
Roma Europea | 5255 | Privata
[NAME] | 5507 | Privata
[NAME] | 5556 | Privata
Castellanza Liuc | 5565 | Privata
Milano San Raffaele | 6190 | Privata
Roma Luiss | 6861 | Privata
[NAME] | 8258 | Privata
Bra Scienze Gastronomiche | 11873 | Privata
Cassino | 0 | Pubblica
[NAME] | 0 | Pubblica
Roma La Sapienza | 0 | Pubblica
[NAME] | 0 | Pubblica
Benevento | 0 | Pubblica
Catania | 0 | Pubblica
Roma Tor Vergata | 0 | Pubblica
Spreadsheet: 451999d1458512518-ifs-and-sums-and-nests-or-something-more-simple-book1example
Sheet: Purchases

 |  | Rolls - 25kg
 |  | Cost | Total Qty
 | Opening Stock | 1.12 | 40
 |  | 1 | 1000
 |  | 2 | 1000
 |  | 2.2 | 1000
 |  | 1 | 2000
 | Purchased
 | Sold
 | Balance
 |  | Date | Quantity Bought | Price Paid
 |  | 2016-04-01 00:00:00 | 1000 | 1
 |  | 2016-04-23 00:00:00 | 1000 | 2
 |  | 2016-04-15 00:00:00 | 1000 | 2.2
 |  | 2016-05-02 00:00:00 | 2000 | 1
Spreadsheet: 122531d1316912138-how-to-interweave-data-in-2-columns-totestformulas
Sheet: Sheet1

2011-01-02 00:00:00 | 65.1 | 2011-01-02 00:00:00 | 65.1
2011-01-03 00:00:00 | 65.3 | 2011-01-03 00:00:00 | 65.3
2011-01-04 00:00:00 | 64.9 | 2011-01-04 00:00:00 | 64.9
2011-01-05 00:00:00 | 65.25 | 2011-01-05 00:00:00 | 65.25
2011-01-06 00:00:00 | 0 | 2011-01-08 00:00:00 | 65.1
2011-01-07 00:00:00 | 0 | 2011-01-09 00:00:00 | 65.15
2011-01-08 00:00:00 | 0 | 2011-01-10 00:00:00 | 65
2011-01-09 00:00:00 | 0 | 2011-01-11 00:00:00 | 65.25
2011-01-10 00:00:00 |  | 2011-01-12 00:00:00 | 65.15
2011-01-11 00:00:00 |  | 2011-01-15 00:00:00 | 65.1
2011-01-12 00:00:00 |  | 2011-01-16 00:00:00 | 65.1
2011-01-13 00:00:00 |  | 2011-01-17 00:00:00 | 64.65
2011-01-14 00:00:00 |  | 2011-01-18 00:00:00 | 63.9
2011-01-15 00:00:00 |  | 2011-01-19 00:00:00 | 64.5
2011-01-16 00:00:00 |  | 2011-01-22 00:00:00 | 65.2
2011-01-17 00:00:00 |  | 2011-01-23 00:00:00 | 65.2
2011-01-18 00:00:00 |  | 2011-01-24 00:00:00 | 64.95
2011-01-19 00:00:00 |  | 2011-01-26 00:00:00 | 65.5
2011-01-20 00:00:00 |  | 2011-01-29 00:00:00 | 65.3
2011-01-21 00:00:00 |  | 2011-01-30 00:00:00 | 66.75
2011-01-22 00:00:00 |  | 2011-01-31 00:00:00 | 66
2011-01-23 00:00:00 |  | 2011-02-02 00:00:00 | 66.9
2011-01-24 00:00:00 |  | 2011-02-05 00:00:00 | 67.6
2011-01-25 00:00:00 |  | 2011-02-06 00:00:00 | 68.8
2011-01-26 00:00:00 |  | 2011-02-07 00:00:00 | 68.65
2011-01-27 00:00:00 |  | 2011-02-08 00:00:00 | 69
2011-01-28 00:00:00 |  | 2011-02-13 00:00:00 | 68.55
2011-01-29 00:00:00 |  | 2011-02-14 00:00:00 | 72.3
2011-01-30 00:00:00 |  | 2011-02-16 00:00:00 | 73.65
2011-01-31 00:00:00 |  | 2011-02-19 00:00:00 | 74.9
2011-02-01 00:00:00 |  | 2011-02-20 00:00:00 | 76.5
2011-02-02 00:00:00 |  | 2011-02-21 00:00:00 | 79.3
2011-02-03 00:00:00 |  | 2011-02-22 00:00:00 | 86.5
2011-02-04 00:00:00 |  | 2011-02-23 00:00:00 | 85
2011-02-05 00:00:00 |  | 2011-02-26 00:00:00 | 80.7
2011-02-06 00:00:00 |  | 2011-02-27 00:00:00 | 83.7
2011-02-07 00:00:00 |  | 2011-02-28 00:00:00 | 85
2011-02-08 00:00:00 |  | 2011-03-01 00:00:00 | 85.7
2011-02-09 00:00:00 |  | 2011-03-02 00:00:00 | 86.3
2011-02-10 00:00:00 |  | 2011-03-05 00:00:00 | 84
2011-02-11 00:00:00 |  | 2011-03-06 00:00:00 | 83
2011-02-12 00:00:00 |  | 2011-03-07 00:00:00 | 82.5
2011-02-13 00:00:00 |  | 2011-03-08 00:00:00 | 83.75
2011-02-14 00:00:00 |  | 2011-03-09 00:00:00 | 82.75
2011-02-15 00:00:00 |  | 2011-03-12 00:00:00 | 82.5
2011-02-16 00:00:00 |  | 2011-03-13 00:00:00 | 80
2011-02-17 00:00:00 |  | 2011-03-14 00:00:00 | 80
2011-02-18 00:00:00 |  | 2011-03-15 00:00:00 | 82.75
2011-02-19 00:00:00 |  | 2011-03-16 00:00:00 | 82.75
2011-02-20 00:00:00 |  | 2011-03-19 00:00:00 | 82.25
2011-02-21 00:00:00 |  | 2011-03-20 00:00:00 | 82.5
2011-02-22 00:00:00 |  | 2011-03-21 00:00:00 | 81.6
2011-02-23 00:00:00 |  | 2011-03-22 00:00:00 | 81.7
2011-02-24 00:00:00 |  | 2011-03-23 00:00:00 | 84.5
2011-02-25 00:00:00 |  | 2011-03-26 00:00:00 | 90
2011-02-26 00:00:00 |  | 2011-03-27 00:00:00 | 90
2011-02-27 00:00:00 |  | 2011-03-28 00:00:00 | 88.5
2011-02-28 00:00:00 |  | 2011-03-29 00:00:00 | 89.25
2011-03-01 00:00:00 |  | 2011-04-01 00:00:00 | 90
Spreadsheet: 156230d1337235155-looking-for-a-solution-automatic-pick-up-from-input-data-xplained-in-exce-excel-forum-help
Sheet: INPUT SHEET

Input Table |  |  |  |  |  |  |  | Required
 |  |  |  |  |  |  |  | Probability
 |  |  |  |  |  | Warranty | 0 | 0
 | Item X |  |  |  |  |  | 5000 | 0
 | 10% Failure | 100% Failure | 110% Failure | 200% Failure |  |  | 10000 | 0
Life | 50000 | 65000 | 115000 | 130000 |  |  | 15000 | 0
 |  |  |  |  |  |  | 20000 | 0
 |  |  |  |  |  |  | 25000 | 0
Warranty 30000km |  | Cost=0 |  |  |  |  | 30000 | 0
 |  |  |  |  |  |  | 35000 | 0.025 | (Automatic O/P from Input table based on the kms) |  |  |  |  |  |  | Step-1
 |  |  |  |  |  |  | 40000 | 0.05 |  |  |  |  |  |  |  | Step-2
 |  |  |  |  |  |  | 45000 | 0.07500000000000001 | Cumulative addition |  |  |  |  |  |  | Step-3
 |  |  |  |  |  |  | 50000 | 0.1 | (Automatic O/P from Input table based on the kms)
 |  |  |  |  |  |  | 55000
 |  |  |  |  |  |  | 60000
 |  |  |  |  |  |  | 65000 | 1 | (Automatic O/P from Input table based on the kms) |  |  |  |  |  |  | Step-1
 |  |  |  |  |  |  | 70000 | 1.01 |  |  |  |  |  |  |  | Step-2
 |  |  |  |  |  |  | 75000 | 1.02 | Cumulative addition |  |  |  |  |  |  | Step-3
 |  |  |  |  |  |  | 80000 | 1.03
 |  |  |  |  |  |  | 85000 | 1.04
 |  |  |  |  |  |  | 90000 | 1.05
 |  |  |  |  |  |  | 95000 | 1.06
 |  |  |  |  |  |  | 100000 | 1.07
 |  |  |  |  |  |  | 105000 | 1.08
 |  |  |  |  |  |  | 110000 | 1.09
 |  |  |  |  |  |  | 115000 | 1.1 | (Automatic O/P from Input table based on the kms)
 |  |  |  |  |  |  | 120000
 |  |  |  |  |  |  | 125000
 |  |  |  |  |  |  | 130000 | 2 | (Automatic O/P from Input table based on the kms)
 |  |  |  |  |  |  | 135000
 |  |  |  |  |  |  | 140000
 |  |  |  |  |  |  | 145000
 |  |  |  |  |  |  | 150000
 |  |  |  |  |  |  | 155000
 |  |  |  |  |  |  | 160000
 |  |  |  |  |  |  | 165000
 |  |  |  |  |  |  | 170000
 |  |  |  |  |  |  | 175000
 |  |  |  |  |  |  | 180000
 |  |  |  |  |  |  | 185000
 |  |  |  |  |  |  | 190000
 |  |  |  |  |  |  | 195000
Spreadsheet: 211481d1359757760-leaving-a-cell-blank-unless-referenced-cells-contain-a-value-time-card-ref
Sheet: Sheet1

 | Day | Date | Start | End | Lunch | Vacation | Personal | Total
 | Sunday
 | Monday |  | 800 | 1200 | 0 | 0 | 0 |  | THIS SHOULD BE 4 HOURS, NOT 16.
 | Tuesday |  | 800 | 1630 | 30 | 0 | 0
 | Wednesday |  | 800 | 1630 | 30 | 0 | 0
 | Thursday |  | 800 | 1630 | 30 | 0 | 0
 | Friday |  | 800 | 1630 | 30 | 0 | 0
 | Saturday
 | Total hours |  |  |  |  |  |  |  | THIS SHOULD TOTAL 36, NOT 56 HOURS
Spreadsheet: 103382d1301106401-help-with-index-match-and-offset-forumla-copy-of-pipeline-report
Sheet: Data

Company | Status | Sector | Sub-Sector | Client | Target
Company A | Active | Sector 1 | Sub-Sector A | [NAME] | 15
Company A | Active | Sector 1 | Sub-Sector A | Sue | 12
Company A | Active | Sector 1 | Sub-Sector A | [NAME] | 5
Company A | Prospect | Sector 1 | Sub-Sector A | [NAME] | 8
Company A | Prospect | Sector 1 | Sub-Sector A | [NAME]
Company B | Active | Sector 2 | Sub-Sector C | [NAME]
Company B | Active | Sector 2 | Sub-Sector C | Sue
Company B | Active | Sector 2 | Sub-Sector C | [NAME]
Company B | Active | Sector 2 | Sub-Sector C | [NAME] | 6
Company B | Active | Sector 2 | Sub-Sector C | [NAME] | 3
Company C | Closed | Sector 1 | Sub-Sector B | [NAME] | 80
Company C | Closed | Sector 1 | Sub-Sector B | [NAME] | 38
Company C | Active | Sector 1 | Sub-Sector B | [NAME] | 55
Company C | Prospect | Sector 1 | Sub-Sector B | [NAME] | 33
Company C | Closed | Sector 1 | Sub-Sector B | Sue
Company D | Active | Sector 2 | Sub-Sector D | Sue | 87
Company D | Active | Sector 2 | Sub-Sector D | [NAME] | 655
Company D | Active | Sector 2 | Sub-Sector D | [NAME] | 45
Company D | Prospect | Sector 2 | Sub-Sector D | [NAME]
Company D | Prospect | Sector 2 | Sub-Sector D | [NAME] | 12
Company E | Prospect | Sector 1 | Sub-Sector B | [NAME]
Company E | Prospect | Sector 1 | Sub-Sector B | [NAME] | 155
Company E | Prospect | Sector 1 | Sub-Sector B | [NAME] | 65
Company E | Prospect | Sector 1 | Sub-Sector B | Sue | 23
Company E | Prospect | Sector 1 | Sub-Sector B | [NAME]
Company F | Active | Sector 1 | Sub-Sector A | [NAME]
Company F | Active | Sector 1 | Sub-Sector A | [NAME] | 75
Company F | Prospect | Sector 1 | Sub-Sector A | [NAME] | 45
Company F | Prospect | Sector 1 | Sub-Sector A | [NAME] | 33
Company F | Prospect | Sector 1 | Sub-Sector A | Sue | 1
Company G | Prospect | Sector 2 | Sub-Sector D | Sue
Company G | Prospect | Sector 2 | Sub-Sector D | [NAME] | 14
Company G | Closed | Sector 2 | Sub-Sector D | [NAME] | 18
Company G | Closed | Sector 2 | Sub-Sector D | [NAME] | 98
Company G | Closed | Sector 2 | Sub-Sector D | [NAME] | 62
Spreadsheet: 702585d1604421565-index-match-multiple-criteria-sorting-issue-wip1
Sheet: Tables

Service | Term | Carrier | Units
A | 1 | 1 | 1
B | 1 | 1 | 1
B | 1 | 2 | 1.5
B | 1 | 3 | 2
B | 1 | 5 | 3
B | 6 | 1 | 5
B | 6 | 2 | 6
B | 6 | 3 | 8
B | 6 | 5 | 10
C | 1 | 2 | 1
C | 1 | 3 | 1.5
C | 1 | 4 | 2
C | 1 | 5 | 2.7
C | 3 | 2 | 3.6
C | 3 | 3 | 5.1
C | 3 | 4 | 6.6
C | 3 | 5 | 8.1
C | 6 | 2 | 7.2
C | 6 | 3 | 10.2
C | 6 | 4 | 13.2
C | 6 | 5 | 16.2
C | 12 | 2 | 14.4
C | 12 | 3 | 20.4
C | 12 | 4 | 26.4
C | 12 | 5 | 30
Spreadsheet: 111605d1307974928-excel-2007-partial-cell-match-test
Sheet: Sheet1

account development | .totaljobs.co.uk
accounting manager | @saints-personnel.co.uk | 12 | 9301
actuary | 100849.029.525523 | 85 | 1459, 7101, 7739, 9390, 9391, 9392
administration officer | 2touch | 12
adr driver | 3rtelecomltd | 12
advertising account | 4degreesc | 12
air export | 612/6145/mkm | 21
air import | 9654/534/rmâ€ | 12 | 9684
air quality | a | 12 | 9687
analysis engineer | a1recruitmentsolutions.com | 105
analyst insurance | a4e | 12
analyst manager | aa/14596 | 12
analytical | ab10 | 33 | 1634, 1635, 1636, 1637, 1638, 1639, 9853, 9854, 9855, 9856, 9857, 9858
application consultant | abbatt | 12 | 1670, 9286, 9952
application specialist | access | 12 | 9968, 9969, 9970
architectural technologist | accountancyjobs | 32
asbestos analyst | accounting | 12
assembly technician | accountingtrainee | 36
assistant administrator | accounts | 12 | 1886
Spreadsheet: 839392d1691925099-sales-tracker-with-percentages-and-zeros-sample-2
Sheet: Sheet1

Employee | [NAME] |  |  |  |  | Employee | [NAME]
Week | Target | Actual | Week % | Month % |  | Week | Target | Actual | Week % | Month %
1 | 2 | 1 |  |  |  | 1 | 2 | 1 | 0.5
2 | 4 | 3 |  |  |  | 2 | 4 | 3 | 0.75
3 | 10 | 8 |  |  |  | 3 | 10 | 8 | 0.8
4 | 0 | 0 |  |  |  | 4 | 22 | 11 | 0.5 | 0.6052631578947368
5 | 3 | 4 |  |  |  | 5
6 | 3 | 2 |  |  |  | 6
7 | 3 | 1 |  |  |  | 7
8 | 3 | 2 |  |  |  | 8
9 |  |  |  |  |  | 9
10 |  |  |  |  |  | 10
11 |  |  |  |  |  | 11
12 |  |  |  |  |  | 12
13 |  |  |  |  |  | 13
14 |  |  |  |  |  | 14
15 |  |  |  |  |  | 15
16 |  |  |  |  |  | 16
17 |  |  |  |  |  | 17
18 |  |  |  |  |  | 18
19 |  |  |  |  |  | 19
20 |  |  |  |  |  | 20
21 |  |  |  |  |  | 21
22 |  |  |  |  |  | 22
23 |  |  |  |  |  | 23
24 |  |  |  |  |  | 24
25 |  |  |  |  |  | 25
26 |  |  |  |  |  | 26
27 |  |  |  |  |  | 27
28 |  |  |  |  |  | 28
29 |  |  |  |  |  | 29
30 |  |  |  |  |  | 30
31 |  |  |  |  |  | 31
32 |  |  |  |  |  | 32
33 |  |  |  |  |  | 33
34 |  |  |  |  |  | 34
35 |  |  |  |  |  | 35
36 |  |  |  |  |  | 36
37 |  |  |  |  |  | 37
38 |  |  |  |  |  | 38
39 |  |  |  |  |  | 39
40 |  |  |  |  |  | 40
41 |  |  |  |  |  | 41
42 |  |  |  |  |  | 42
43 |  |  |  |  |  | 43
44 |  |  |  |  |  | 44
45 |  |  |  |  |  | 45
46 |  |  |  |  |  | 46
47 |  |  |  |  |  | 47
48 |  |  |  |  |  | 48
49 |  |  |  |  |  | 49
50 |  |  |  |  |  | 50
51 |  |  |  |  |  | 51
52 |  |  |  |  |  | 52
Spreadsheet: 206245d1358117664-deduct-partial-vacation-hours-taken-from-a-date-or-date-range-accrual-balance-and-vacation-records-ver1
Sheet: Accrual_Balance

Emp No | Status | EmpName | SeniorityDate | YearsofService | AccrualedVacationDays | VacationHours | HoursAccrued | DaysTaken | HoursTaken | VacationDaysRemaining | HoursRamining |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-13 16:51:13
56656 | Active | [NAME], [NAME] | 1/26/2006 | 6.96986301369863 | 15 | 120 | 1.25 | 10 | 80 | 5 | 40
56654 | Active | Smith, [NAME] | 10/3/2005 | 7.284931506849315 | 15 | 120 | 1.25 | 11 | 88 | 4 | 32
58624 | Active | [NAME], [NAME] | 2/3/2011 | 1.945205479452055 | 10 | 80 | 0.83 | 6 | 48 | 4 | 32