tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329329d1404273368-dynamic-top-5-customer-per-month-dynamic-top-5-customer-per-month-ans1
Sheet: Pivot

Row Labels | Jan | Feb | Mar | Apr | Grand Total |  | Row Labels | Jan | Feb | Mar | Apr
Customer A | 43408 | 39947 | 46707 | 17213 | 147275 |  | Customer A | 162 | 201 | 144 | 89
#N/A | 2813 | 3483 | 3577 | 2742 | 12615 |  | #N/A | 68 | 55 | 44 | 46
Customer B | 1812 | 1822 | 2038 | 1055 | 6727 |  | Customer B | 25 | 16 | 8 | 7
Customer C | 537 | 508 | 563 | 536 | 2144 |  | Customer C | 9 | 14 | 10 | 13
Customer D | 551 | 480 | 483 | 478 | 1992 |  | Customer D | 5 | 5 | 4 | 4
Customer E | 991 | 899 | 1425 | 470 | 3785 |  | Customer E | 3 |  | 1 | 7
Customer F | 490 | 435 | 440 | 444 | 1809 |  | Customer F | 3 | 3 |  | 2
Customer G | 580 | 501 | 481 | 368 | 1930 |  | Customer G | 3
Customer H | 236 | 231 | 279 | 284 | 1030 |  | Customer H | 2 | 2 | 6 | 3
Customer I | 482 | 380 | 396 | 276 | 1534 |  | Customer I | 2 | 4 | 3 | 7
Customer J | 424 | 345 | 423 | 262 | 1454 |  | Customer J | 2 |  | 3 | 6
Customer K | 368 | 309 | 412 | 250 | 1339 |  | Customer K | 2 | 4 | 3 | 4
Customer L | 418 | 393 | 433 | 247 | 1491 |  | Customer L | 1 | 4 | 2 | 4
Customer M | 454 | 359 | 327 | 238 | 1378 |  | Customer M | 1 | 1
Customer N | 260 | 219 | 243 | 187 | 909 |  | Customer N |  |  |  | 2
Customer O | 571 | 621 | 717 | 170 | 2079 |  | Customer O |  | 2 | 2 | 1
Customer P | 170 | 167 | 224 | 157 | 718 |  | Customer P |  |  |  | 1
Customer Q | 248 | 227 | 228 | 141 | 844 |  | Customer Q |  | 1
Customer R | 276 | 209 | 201 | 135 | 821 |  | Customer R |  |  | 1 | 1
Customer S | 645 | 572 | 603 | 133 | 1953 |  | Customer S |  | 3 | 7
Customer T | 327 | 304 | 326 | 132 | 1089 |  | Customer T |  |  |  | 1
[NAME] | 127 | 144 | 180 | 129 | 580 |  | [NAME] |  | 1 | 1
Customer V | 139 | 123 | 111 | 126 | 499 |  | Customer V |  |  |  | 1
Customer W | 262 | 188 | 159 | 113 | 722 |  | Customer W |  | 3 |  | 3
Customer X | 277 | 159 | 184 | 96 | 716 |  | Customer X |  | 2 | 7 | 4
Customer Y | 141 | 124 | 121 | 91 | 477
OLD DATA |  |  |  |  |  |  | NEW DATA
Spreadsheet: 3bd73dfc-1a61-446f-8c55-57a0760fb530
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2009-04-15 | 1 | Portland | 3 | Providence | 0 | Final | Dunkin' Donuts Center Providence, RI
2009-04-17 | 2 | Portland | 1 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2009-04-19 | 3 | Providence | 5 | Portland | 1 | Final | Cumberland County Civic Center Portland, ME
2009-04-23 | 4 | Providence | 2 | Portland | 1 | Final | Cumberland County Civic Center Portland, ME
2009-04-24 | 5 | Portland | 1 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2009-04-28 | 1 | Worcester | 2 | Providence | 3 | Final OT | Dunkin' Donuts Center Providence, RI
2009-05-06 | 2 | Providence | 4 | Worcester | 2 | Final | DCU Center Worcester, [NAME]
2009-05-08 | 3 | Worcester | 5 | Providence | 3 | Final | Dunkin' Donuts Center Providence, RI
2009-05-09 | 4 | Providence | 0 | Worcester | 1 | Final | DCU Center Worcester, [NAME]
2009-05-11 | 5 | Worcester | 3 | Providence | 4 | Final | Dunkin' Donuts Center Providence, RI
2009-05-13 | 6 | Providence | 5 | Worcester | 1 | Final | DCU Center Worcester, [NAME]
2009-05-16 | 1 | Providence | 3 | Hershey | 2 | Final | Giant Center Hershey, PA
2009-05-17 | 2 | Providence | 1 | Hershey | 2 | Final | Giant Center Hershey, PA
2009-05-22 | 3 | Hershey | 6 | Providence | 4 | Final | Dunkin' Donuts Center Providence, RI
2009-05-24 | 4 | Hershey | 3 | Providence | 2 | Final OT | Dunkin' Donuts Center Providence, RI
2009-05-25 | 5 | Hershey | 5 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
Spreadsheet: 720915d1614359496-resetting-a-rows-function-based-on-a-counta-function-rows-example
Sheet: FRI

FRIDAY |  |  | CREW1 |  |  |  |  |  |  | "my solution:"
09:30:00 | - |  | PICKUP AT LOCATION
 |  |  | LOCATION ADDRESS
 |  |  | PICKUP FOR:
 |  |  | [NAME], PHONE
 |  |  | ITEMS TO PICK UP
 | - |  | CUSTOMER1
 |  |  | CUSTOMER1 ADDRESS
 |  |  | CUSTOMER1 PHONE1
 |  |  | [NAME]
 |  |  | CUSTOMER1 NOTES
 |  |  | CUSTOMER1 JOB
 | - |  | CUSTOMER2
 |  |  | CUSTOMER2 ADDRESS
 |  |  | CUSTOMER2 PHONE1
 |  |  | [NAME]
 |  |  | CUSTOMER2 NOTES
 |  |  | CUSTOMER2 JOB
Spreadsheet: 67248d1267819683-excel-2007-dependent-drop-down-box-products
Sheet: List

Select Filling | Seat | Back
Hollow Fibre (Corovin) 2” | 1.54 | 1.23
Hollow Fibre (Corovin) 3” | 1.38 | 1.11
Hollow Fibre (Corovin) 4” | 1.21 | 0.97
Hollow Fibre (Corovin) 5” | 1.05 | 0.84
------------------------------
Hollow Fibre (Calico) 2” | 1.63 | 1.3
Hollow Fibre (Calico) 3” | 1.46 | 1.17
Hollow Fibre (Calico) 4” | 1.28 | 1.02
Hollow Fibre (Calico) 5” | 1.11 | 0.89
------------------------------
Curled Duck (2” Border) | 1.92 | 1.54
Curled Duck (3” Border) | 1.72 | 1.38
Curled Duck (4” Border) | 1.51 | 1.21
Curled Duck (5” Border) | 1.31 | 1.05
------------------------------
[NAME] (2” Border) | 1.98 | 1.58
[NAME] (3” Border) | 1.78 | 1.42
[NAME] (4” Border) | 1.56 | 1.24
[NAME] (5” Border) | 1.35 | 1.08
------------------------------
White Duck (2” Border) | 2.35 | 1.88
White Duck (3” Border) | 2.1 | 1.68
White Duck (4” Border) | 1.84 | 1.48
White Duck (5” Border) | 1.6 | 1.28
------------------------------
Feather Wrap (2” Border) | 2.68 | 2.28
Feather Wrap (3” Border) | 2.29 | 1.95
Feather Wrap (4” Border) | 2 | 1.7
Feather Wrap (5” Border) | 1.7 | 1.45
Spreadsheet: 727070d1617703104-text-to-columns-change-general-to-numbers-not-working-test-text-to-columns
Sheet: Sheet2

 | Symbol | Trade Date | Trade Type | Quantity
 | GODREJCP | 2020-03-06 | sell | 20
 | PIDILITIND | 2020-03-06 | sell | 20 |  |  |  |  |  | 1.the figures shown in col E .
 | SRF | 2020-03-06 | buy | 5 |  |  |  |  |  | 2.they are shown as general. Left aligned. Assumes it is text.
 | INFY | 2020-03-06 | buy | 10 |  |  |  |  |  | 3. I selected all the contents in col E. pressed data-text to columns. But nothing has happened.
 | JUBLFOOD | 2020-03-06 | buy | 5 |  |  |  |  |  | [NAME] want to format all the contents in col E as numbers. What to do?
 | NIITTECH | 2020-03-06 | buy | 5
 | GENUSPAPER | 2020-03-06 | buy | 200
 | GENUSPAPER | 2020-03-06 | buy | 200
 | BAJFINANCE | 2020-03-06 | buy | 2
 | BATAINDIA | 2020-03-06 | buy | 5
 | ASTRAL | 2020-03-06 | buy | 1
 | ASTRAL | 2020-03-06 | buy | 3
 | GENUSPAPER | 2020-03-13 | buy | 200
 | NLCINDIA | 2020-03-13 | buy | 10
 | JKPAPER | 2020-03-13 | buy | 3
 | JAGRAN | 2020-03-13 | buy | 20
 | GENUSPAPER | 2020-03-13 | buy | 9
Spreadsheet: 708442d1607840823-extract-file-names-with-zip-from-a-file-path-example1996
Sheet: Sheet1

filePath | expected output
c:\user\saviors\downloads\testfiles\abc.zip\xyz.tar\file.gz\ | abc.zip
c:\user\saviors\downloads\testfiles\abcfile.tar\files\aaa.zip\xxx.docx\ | abcfile.tar
c:\user\saviors\downloads\testfiles_12.12.2020\xyzfile.jar\aa.zip\cc.zip\ | xyzfile.jar
c:\user\saviors\downloads\1. [NAME] | bbb.zip
c:\user\saviors\downloads\testfiles\testtest.7z\xyx.zip\test.xlsx\ | testtest.7z
c:\user\saviors\downloads\testfiles\testtest.gz\xyx.tar\test.xlsx\ | testtest.gz
Spreadsheet: 798734d1664697921-assigning-round-robin-based-on-criteria-assigning
Sheet: Sheet1 (excel 365 date sort (2)

Date | Case Number | Patient Name |  | Case Worker Pool |  | sorted temporarily on
2022-09-28 00:00:00 | LA1457 | [NAME] |  | [NAME]
2022-09-28 00:00:00 | LA1458 | [NAME] |  | [NAME]
2022-09-29 00:00:00 | LA1459 | [NAME] |  | [NAME]
2022-09-29 00:00:00 | LA1463 | [NAME] Hool |  | Reena
2022-09-29 00:00:00 | LA1465 | Ashely Huth |  | [NAME]
2022-09-30 00:00:00 | LA1460 | Hailey Amber
2022-09-30 00:00:00 | LA1461 | Hailey Amber |  |  | <-delete down to this row (date still in the past, and the last assignment of [NAME]
2022-09-30 00:00:00 | LA1464 | Oolea Romeo
2022-09-30 00:00:00 | LA1466 | Boneer Vice
2022-10-02 00:00:00 | LA1462 | [NAME]
Spreadsheet: 675516d1588339195-formula-name-management-inserisci-si_no
Sheet: Foglio1

 |  |  |  |  |  |  | [NAME]
DATA | PRODOTTO 1 |  | 403 10 |  |  |  | 403
DATA | PRODOTTO 2 |  | 404 10 |  |  |  | 404
DATA | PRODOTTO 3 |  | 405 10 |  |  |  | 171
DATA | PRODOTTO 4 |  | 406 10 |  |  |  | 405
DATA | PRODOTTO 5 |  | 423 10 |  |  |  | 200
DATA | PRODOTTO 6 |  | 408 10
DATA | PRODOTTO 7 |  | 172 10
DATA | PRODOTTO 8 |  | 410 10
DATA | PRODOTTO 9 |  | 800 10
DATA | PRODOTTO 10 |  | 421 10
DATA | PRODOTTO 11 |  | 422 10
DATA | PRODOTTO 12 |  | 171 10
DATA | PRODOTTO 13 |  | 407 10
DATA | PRODOTTO 14 |  | 408 10
DATA | PRODOTTO 15 |  | 417 10
DATA | PRODOTTO 16 |  | 418 10
DATA | PRODOTTO 17 |  | 200 10
DATA | PRODOTTO 18 |  | 420 10
DATA | PRODOTTO 19 |  | 421 10
DATA | PRODOTTO 20 |  | 422 10
DATA | PRODOTTO 21 |  | 423 10
Spreadsheet: 195722d1353616475-want-to-get-last-5-cell-values-laatste_5_horzoeken
Sheet: NRC

 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 |  | 1
M/C | New Rubber Cots |  | New Rubber Cots |  | New Rubber Cots |  | New Rubber Cots |  | New Rubber Cots |  |  | Third Last |  | Second Last |  | Last
 | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] |  | Date | [NAME] | Date | [NAME] | Date | [NAME]
1 | 2009-02-16 00:00:00 | 38 [NAME] | 2011-09-26 00:00:00 | 37 [NAME] | 2012-01-28 00:00:00 | 36 [NAME] | 2012-10-24 00:00:00 | 40 mm |  |  |  | 2011-09-26 00:00:00 | 37 [NAME] | 2012-01-28 00:00:01 | 36 [NAME] | 2012-10-24 00:00:01 | 40 mm
2 | 2012-03-15 00:00:00 | 38 [NAME] | 2012-04-01 00:00:00 | 37 [NAME] | 2012-03-01 00:00:00 | 36 [NAME] | 2012-02-01 00:00:00 | 40 mm |  |  |  | 2012-03-01 00:00:01 | 36 [NAME] | 2012-03-15 00:00:00 | 38 [NAME] | 2012-04-01 00:00:00 | 37 [NAME]
3 | 2012-05-15 00:00:00 | 38 [NAME] | 2012-05-01 00:00:00 | 37 [NAME] | 2012-06-15 00:00:00 | 36 [NAME] | 2012-06-15 00:00:00 | 40 mm |  |  |  | 2012-05-15 00:00:00 | 38 [NAME] | 2012-06-15 00:00:01 | 36 [NAME] | 2012-06-15 00:00:01 | 40 mm
4 | 2009-02-16 00:00:00 | 38 [NAME] |  |  |  |  |  |  |  |  |  | - | - | - | - | 2009-02-16 00:00:00 | 38 [NAME]
5 | 2009-02-16 00:00:00 | 38 [NAME] | 2011-09-26 00:00:00 | 37 [NAME] | 2012-01-28 00:00:00 | 36 [NAME] | 2012-10-24 00:00:00 | 40 mm |  |  |  | 2011-09-26 00:00:00 | 37 [NAME] | 2012-01-28 00:00:01 | 36 [NAME] | 2012-10-24 00:00:01 | 40 mm
Spreadsheet: 851197d1701421254-how-to-count-the-number-of-times-each-weekday-occurs-in-a-given-month-sample-file-how-many-weekdays-1-
Sheet: Sheet1

 |  |  |  | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Jul-26 | Aug-26 | Sep-26 | Oct-26 | Nov-26 | Dec-26 | [NAME] | Feb-27 | Mar-27
 |  | 6 | Monday
 |  | 5 | Tuesday
 |  | 4 | Wednesday
 |  | 3 | Thursday
 |  | 2 | Friday
 |  | 1 | Saturday
 |  | 0 | Sunday
 |  |  | Monday
 |  |  | Tuesday
 |  |  | Wednesday
 |  |  | Thursday
 |  |  | Friday
 |  |  | Saturday
 |  |  | Sunday
Spreadsheet: 26d39cfb-7b56-4801-9aea-4b74483e02e8
Sheet: Metadata

 | September 2012
 | [NAME] checklist for authors delivering metadata for graphs
 | Please deliver one checklist for each graph
 |  |  |  |  |  |  |  | * | = required
 | Owner of the produced graph
 |  | * | Organisation name: |  |  | Copenhagen Resource Institute
 |  | * | Contact person: |  |  | Christian Fischer
 |  | * | Address (email): |  |  | [EMAIL]
 |  | * | Address (web site): |  |  | http://www.cri.dk
 |  |  | Address (delivery point): |  |  | Børsgade 4 1215 Copenhagen K
 | Graph
 |  | * | Title: |  |  | Hazardous waste generation in the EU
 |  | * | Geographical coverage: |  |  | EU27 member states
 |  | * | Description: |  |  | The amount of hazardous waste generation in the EU-27, EU-15 and EU-12
 |  | * | Temporal coverage: |  |  | 1997,2000, 2004,2006-2009
 |  |  | Additional information:
 |  |  | Unit: |  |  | Million tonnes
 |  |  | Methodology: |  |  | The data is collected by ETC/SCP for the EEA. The amounts have been divided by 1000 to convert the values from tonnes to 1000 tonnes
 | To be filled in by the EEA responsible
 |  | * | Tags / keywords: |  |  | Shipment of waste, hazardous waste generation
 |  | * | Theme (EEA): |  |  | Waste and Material resources
 |  | * | EEA management plan year and code: |  |  | 2.5.1 (2011)
 |  |  | Link to the original delivery (e.g. on CIRCA): |  |  | n.a.
 | Persons involved
 |  | * | Contact person for EEA: |  |  | [NAME]
 |  |  | Processor:
 | Copyrights
 | Does your organisation have a documented License / Terms of use / Copyright policy for this dataset?
 |  | If yes; please provide the URL: |  |  |  | www.
 |  | If no; please answer the followin three questions: |  |  |  |  |  |  |  |  |  | Yes / No
 |  | * | Does EEA have the rights to publish the graph in paper-reports? |  |  |  |  |  |  |  |  | Yes
 |  | * | Does EEA have the rights to publish the graph in PDF-documents on the web? |  |  |  |  |  |  |  |  | Yes
 |  | * | Does EEA have the rights to publish the underpinning data on the EEA Data Service? |  |  |  |  |  |  |  |  | Yes
 | Datasets retrieved from
 | (Please copy-and-paste this section to match the number of datasets used to create the graph)
 |  | * | Dataset name: |  |  | Member states' reporting to the EU Commission  on transboundary shipments of waste
 |  | * | Dataset owner: |  |  | EUROSTAT (the data is stored at CRI)
 |  | * | Address (web site): |  |  | http://epp.eurostat.ec.europa.eu/portal/page/portal/waste/transboundary_waste_shipments
 |  | * | Publication year: |  |  | 2012
 |  | * | URL:
 | ( | * | )Path:
 | ( | * | )Dataset usage: #)
 |  |  | Contact person:
 |  |  | #)  Indicator data set: |  |  | A dataset built from other sets for the indicator only.
 |  |  | Main data set: |  |  | Data retrieved directly from some source, with no manipulation
Spreadsheet: 133340d1324338963-help-with-a-savings-budget-spreadsheet-savingsbudget
Sheet: Sheet1

SubTotal - Filtered items
Date | Amount | Category
2011-12-01 00:00:00 | 10 | Saving1
2011-12-02 00:00:00 | 16.5 | Saving2
2011-12-03 00:00:00 | 19.33 | Saving2
2011-12-04 00:00:00 | 23.56 | Saving3
2011-12-05 00:00:00 | 18.72 | Saving1
Spreadsheet: 740182d1626213536-countif-not-working-with-true-criterion-functional-detailed-cs-schedule-sample
Sheet: Wednesday

 | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00 |  |  |  |  | Attendance
 | 7:00a | 7:15a | 7:30a | 7:45a | 8:00a | 8:15a | 8:30a | 8:45a | 9:00a | 9:15a | 9:30a | 9:45a | 10:00a | 10:15a | 10:30a | 10:45a | 11:00a | 11:15a | 11:30a | 11:45a | 12:00p | 12:15p | 12:30p | 12:45p | 1:00p | 1:15p | 1:30p | 1:45p | 2:00p | 2:15p | 2:30p | 2:45p | 3:00p | 3:15p | 3:30p | 3:45p | 4:00p | 4:15p | 4:30p | 4:45p | 5:00p | 5:15p | 5:30p | 5:45p | 6:00p | 6:15p | 6:30p | 6:45p | NA | A | UA | T
Talk Agents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | True
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | True
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
Total staffed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Staff needed
Number of Calls
Spreadsheet: 44858d1243591352-shorten-nested-formula-36ifs
Sheet: 36 IFS & 37 Conditions

36 IF's & 37 Conditions
Letter/Numeric | Number in the Alphabet / Numeric
0 | Zero
1 | N1 | The [NAME] is just to show that how we can use more then 7 IF's.  In this sheet we are using 36 IF's which is fulfilling  37 conditions.    I know there are many ways to do this but I am only focusing to use of IF’s as in many cases we don’t have any choice except to use IF’s.
2 | N2
3 | N3
4 | N4
5 | N5
6 | [NAME]
7 | N7
8 | N8
9 | N9
A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
G | 7
H | 8
I | 9
J | 10
K | 11
L | 12
M | 13
N | 14
O | 15
P | 16
Q | 17
R | 18
S | 19
T | 20
U | 21
V | 22
W | 23
X | 24
Y | 25
Z | 26
( | Non of Alphabet / Numerics
Spreadsheet: 755a2fd5-0739-411a-90c0-385606f19760
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF NOVEMBER 24, 2014 THROUGH NOVEMBER 28, 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, November 24, 2014
09:15:00 | CA#10077-VCL | Vice Chancellor [NAME] | Trial | Wynnchurch Capital, Ltd. | [NAME]
09:30:00 | CA#5009-VCG | Vice Chancellor Glasscock | Trial | State v. [NAME] | Georgetown
02:00:00 | CA#9980-VCN | Vice Chancellor [NAME] | PI Hearing | City of Miami Gen. [NAME]' & Sanitation Empls' Ret. Trust | Dover
Tuesday, November 25, 2014
09:00:00 | CA#9843-VCN | Vice Chancellor [NAME] | Hearing | In re [NAME] of Delaware, Inc. | Dover
09:15:00 | CA#10077-VCL | Vice Chancellor [NAME] | Trial | Wynnchurch Capital, Ltd. | [NAME]
10:00:00 | CA#10164-VCN | Vice Chancellor [NAME] | Hearing | TCV VI, L.P. v. TradingScreen Inc. | Dover
02:00:00 | CA#Various-VCN | Vice Chancellor [NAME] | Oral Argument | CareFusion Corporation Actions | Dover
Wednesday, November 26, 2014
 | NO COURT PROCEDURES SCHEDULED
Thursday, November 27, 2014
 |  | HAPPY THANKSGIVING
Friday, November 28, 2014
 | NO COURT PROCEDURES SCHEDULED
Spreadsheet: 0c4f7d3b-ea24-4b3a-b0be-3c635702aa73
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
 |  |  |  |  |  |  |  |  |  | Rev. 10/11
Center for Student Support and Education Options
Office of Quality School Choice and Funding
SF-6 DD
 |  |  |  |  | FY-20
School-Age Attachment
To be filed by educating Board of Developmental Disabilities
A.
 | Educating Board of Developmental Disabilities |  |  |  |  |  | County |  |  | IRN
B.
 | Resident District - City, Exempted Village or Local |  |  |  |  |  | County |  |  | IRN
 |  |  |  |  | Disability |  | EMIS Status
SSID |  |  |  |  | Condition |  | Code |  | Dates of |  | Total
Number |  |  |  |  | From |  | From |  | Enrollment |  | Days
 |  |  |  |  | Section I C |  | Section I D |  | From | To | Enrolled
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 144101d1330708625-solved-help-with-plotting-km-on-graph-enzyme-graph
Sheet: Sheet1

Substrate Concentration |  |  |  |  | 0.002 | 0.005 | 0.01 | 0.02 | 0.04 | 0.08
Reaction rate |  |  |  |  | 0.00034 | 0.00065 | 0.00088 | 0.00111 | 0.00125 | 0.00129 | 0.00129
Substrate Concentration |  |  |  |  | 0.002 | 0.005 | 0.01 | 0.02 | 0.04 | 0.08
Vmax |  |  |  | 0.0013 | 0.0013 | 0.0013 | 0.0013 | 0.0013 | 0.0013 | 0.0013 | 0.0013
Spreadsheet: b1b210b4-636a-487e-8d36-4eff79507d5a
Sheet: Assignments 2013

Regatta 2013
[NAME]
Event |  | Chief Judge | Asst Judge | Special / Equipment
 | Required
MP-1 | [NAME] | [NAME]
MP-2 | [NAME] | [NAME] | [NAME]
MP-3 | Knot Tying | [NAME] page | [NAME]
MP-4 | Quiz | [NAME] |  | Not Allyse
MP-5 | Uniform Insp.
MP-6 | Conduct & Dis
 | Optional
O-1 | [NAME] | [NAME]
O-2 | Blinker | [NAME]
O-3 | Bos'n chair
O-4 | [NAME] | [NAME] | [NAME]
O-5 | Compass Cards
O-6
O-7 | [NAME]
O-8 | Piloting | [NAME]
[NAME] | Heaving Line | [NAME] | [NAME]
O-10 | Engines | [NAME]
O-11
O-12 | Sailmaking | [NAME]
O-13 | [NAME] | [NAME] | [NAME]
O-14 | Semaphore | [NAME]
O-15 | Splicing, Whip | [NAME]
O-16 | Swimming | [NAME] | [NAME]
O-17 | Taking out line | [NAME] | [NAME]
O-18 | Tug O War | Bos'n
O-19
O-20 | Safety Event
 | Service Events
R-1 | Barracks Insp
R-2 | [NAME] | Bos'n
R-3 | Service Watch
R-4 | Adult Judging
 | Galley
 | Central Accting
 | Splice Sail evaluation team
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Weather

Weather |  |  | ok
[NAME] |  | Weather | Vice President | 1
[NAME] |  | Weather | Manager
[NAME] | Manager | Weather | Manager
[NAME] |  | Weather | Manager | 3
[NAME] |  | Weather | Sr. Spec | 1
 |  |  | TOTAL | 5
Spreadsheet: 693911d1599211579-formula-to-get-data-with-dates-in-columns-and-multiple-criteria-data-lookup-etaf
Sheet: Sheet1

Branch | Product | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-04 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 |  |  | Branch | Product | Date |  | Result
NP000018 | A | 3 | 26 | 18 | 24 |  |  | 22 | 15 |  |  | NP000001 | C | 2020-01-06 00:00:00
NP000018 | B | 2 | 12 | 16 | 14 |  |  | 12 | 13
NP000018 | C |  |  |  |  |  | 11
NP000018 | D |  |  |  |  | 13
NP000018 | E
NP000018 | F |  |  |  |  |  | 1
NP000018 | G |  |  |  |  | 12
NP000001 | A | 1 | 56 | 53 | 62 | 2 |  | 68 | 60
NP000001 | B |  | 13 | 16 | 11 |  |  | 6 | 8
NP000001 | C |  |  |  |  |  | 16
NP000001 | D |  |  |  |  | 13
NP000001 | E
NP000001 | F |  |  |  |  | 56 | 1
NP000019 | A |  | 9 | 3 | 8 |  |  | 5 | 2
NP000019 | B |  | 10 | 13 | 9 |  |  | 7 | 11
NP000019 | C |  |  |  |  |  | 30
NP000019 | D |  |  |  |  | 17
NP000019 | E
NP000019 | F
NP000019 | G |  |  |  |  | 3
Spreadsheet: 852180d1702286221-any-idea-for-data-arrangement-dataarrange
Sheet: output

 | BIT_Count | Address | MAX_BIT | MIN_BIT | Address | MAX_BIT | MIN_BIT
XYZ | 10 | 0x00 | 7 | 6 | 0x01 | 7 | 0
PQ | 6 | 0x00 | 5 | 4 | 0x02 | 7 | 4
ABC | 4 | 0x00 | 3 | 0
Spreadsheet: 386243d1427708146-index-and-match-formula-not-function-testing-5
Sheet: unrecon

Reconciliation details
GLA
Company | [NAME] | [NAME] | GL | Amount
 |  |  |  |  | this should auto update if click the column B3 in Summary, but it not show unreconcile items as per column F in Report A
Spreadsheet: 26689d1219075020-what-function-to-use-to-populate-data-from-other-worksheet-autopopulatedatainfohelp
Sheet: w.e. 13th july

 |  |  | 2008-07-07 00:00:00 | 2008-07-08 00:00:00 | 2008-07-09 00:00:00 | 2008-07-10 00:00:00 | 2008-07-11 00:00:00 | 2008-07-12 00:00:00 | 2008-07-13 00:00:00
 |  | st albans | 11 | 18 | 14 | 8 | 8 | 0 | 0
 |  | sunbury | 6 | 4 | 0 | 4 | 8 | 0 | 0
 |  | peterborough | 8 | 10 | 6 | 5 | 11 | 0 | 0