tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882242d1730519822-compare-2-different-lists-and-create-a-new-table-with-the-data-test
Sheet: Compair1

year | code | Size | Desc | Qty | Amt |  | year | code | Size | Desc | Qty | Amt |  | Unique | Desc | Code | 2023 | 2023 | 2024 | 2024
2023 | 1 | Pr1 | TSHIRT | 1 | 32.99 |  | 2024 | 4 | Pr4 | SOCKS | 3 | 103.2 |  |  |  | 6
2023 | 1 | Pr2 | DRESS | 1 | 31.63 |  | 2024 | 4 | Pr7 | SHOES | 3 | 102.33
2023 | 1 | Pr3 | [NAME] | 1 | 11.81 |  | 2024 | 5 | Pr1 | TSHIRT | 2 | 69.4
2023 | 1 | Pr4 | SOCKS | 2 | 3.13 |  | 2024 | 5 | Pr8 | DRESS | 7 | 325.59
2023 | 1 | Pr5 | SHOES | 2 | 1.73 |  | 2024 | 5 | Pr7 | [NAME] | 3 | 116.71
2023 | 2 | Pr6 | TSHIRT | 2 | 60.28 |  | 2024 | 6 | Pr2 | SOCKS | 1 | 51.47
2023 | 2 | Pr7 | SHOES | 1 | 26.84 |  | 2024 | 6 | Pr4 | TSHIRT | 1 | 60.12
2023 | 3 | Pr5 | SOCKS | 2 | 60.41 |  | 2024 | 6 | Pr7 | DRESS | 2 | 139.27
2023 | 4 | Pr4 | TSHIRT | 1 | 24.4 |  | 2024 | 6 | Pr6 | SOCKS | 1 | 52.21
2023 | 4 | Pr6 | [NAME] | 2 | 62.62 |  | 2024 | 7 | Pr5 | TSHIRT | 1 | 34.05
2023 | 5 | Pr3 | [NAME] | 6 | 205.67 |  | 2024 | 8 | Pr1 | DRESS | 2 | 27.89
2023 | 5 | Pr8 | SOCKS | 3 | 141.69
2023 | 5 | Pr7 | TSHIRT | 6 | 10.2
2023 | 5 | Pr1 | SHOES | 6 | 11.4
2023 | 6 | Pr2 | TSHIRT | 8 | 553.11
2023 | 6 | Pr10 | DRESS | 2 | 140.02
2023 | 6 | Pr4 | [NAME] | 4 | 189
2023 | 6 | Pr3 | SOCKS | 1 | 47.46
2023 | 6 | Pr5 | DRESS | 1 | 33.29
2023 | 6 | Pr2 | TSHIRT | 2 | 14.42
Spreadsheet: 84117b35-8016-4f48-b717-7e5cbbc29aa1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
265077 | 64072 | [NAME] | Parish | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:25:45 | Elite Men
265077 | 80001 | [NAME] | Mcguire | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:28:14 | Elite Men
265077 | 80002 | [NAME] | [NAME] | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:37:33 | Elite Men
265077 | 33977 | [NAME] | Sheeks | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:25:51 | Elite Men
265077 | 80003 | [NAME] | Bordine | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:27:24 | Elite Men
265078 | 39482 | Kathy | Rakel | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:41:02 | Elte women
265078 | 33598 | Rachel | Chambers | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:44:44 | Elte women
Spreadsheet: errol_mclaughlin_jr__10485__Gas_exceptions
Sheet: IN PRI_SEC NOT IN BENCHMARK

CURVES IN PRIMARY/SECONDARY MAPPING BUT NOT IN BENCHMARK MAPPING
2001-04-17 00:00:00 | CHI./N/BORDER
2001-04-17 00:00:00 | NGI-MOJAVE
2001-04-17 00:00:00 | AECO-CDN/IM
2001-04-17 00:00:00 | DAWN/IM
2001-04-17 00:00:00 | EMERSON-USA
2001-04-17 00:00:00 | EMPRESS-CDN/IM
2001-04-17 00:00:00 | EMPRESS-US/IM
2001-04-17 00:00:00 | GD-CAL BORDER
2001-04-17 00:00:00 | GD-MICHCON
2001-04-17 00:00:00 | GD-TRCOZ6/NY
2001-04-17 00:00:00 | GD-TW/THOREAU
2001-04-17 00:00:00 | GDC-EMERSON/USA
2001-04-17 00:00:00 | GDP-ANR/OK
2001-04-17 00:00:00 | GDP-CHI. GATE
2001-04-17 00:00:00 | GDP-DAWN
2001-04-17 00:00:00 | GDP-ELPO/SJBOND
2001-04-17 00:00:00 | GDP-MICHCON
2001-04-17 00:00:00 | GDP-NGPL/(IA-IL
2001-04-17 00:00:00 | GDP-NW STANFIEL
2001-04-17 00:00:00 | GDP-PG&E/CITIGA
2001-04-17 00:00:00 | GDP-SONAT/LA
2001-04-17 00:00:00 | GDP-TENN/800
2001-04-17 00:00:00 | GDP-TENN/CORPUS
2001-04-17 00:00:00 | GDP-TETCO/ELA
2001-04-17 00:00:00 | GDP-TETCO/M3
2001-04-17 00:00:00 | GDP-TGT/ZSL
2001-04-17 00:00:00 | GDP-TRUNKL/ELA
2001-04-17 00:00:00 | GDP-TRUNKL/NO
2001-04-17 00:00:00 | GDP-TW/SJ
2001-04-17 00:00:00 | GDP-TXINT/KATYT
2001-04-17 00:00:00 | GDP-WYOMING
2001-04-17 00:00:00 | IF-DISCOVER-WH
2001-04-17 00:00:00 | IF-KOCH Z3 CITY
2001-04-17 00:00:00 | IF-STINGWH
2001-04-17 00:00:00 | IF-TGTZ0MRK
2001-04-17 00:00:00 | IF-TRCO/Z1WH
2001-04-17 00:00:00 | IF-TRCO/Z2WH
2001-04-17 00:00:00 | IF-TRCO/Z3WH
2001-04-17 00:00:00 | IF-WILLIAMS
2001-04-17 00:00:00 | IM-CIG/SOUTHERN
2001-04-17 00:00:00 | IM-TW/SJ
2001-04-17 00:00:00 | IM_FTULESSGATH
2001-04-17 00:00:00 | IM_WINDRIVER
2001-04-17 00:00:00 | NNG/MID1-6
2001-04-17 00:00:00 | NNG/MID13
2001-04-17 00:00:00 | NNG/MID15
2001-04-17 00:00:00 | PARK-CDN/IM
2001-04-17 00:00:00 | PARKWAY/IM
2001-04-17 00:00:00 | SONAT/Z2
2001-04-17 00:00:00 | SONAT/Z3
2001-04-17 00:00:00 | ST.CLAIR/IM
2001-04-17 00:00:00 | SUMAS-US/IM
2001-04-17 00:00:00 | TENN-Z1/CITY
2001-04-17 00:00:00 | TRANS-OK
2001-04-17 00:00:00 | TRUNKL/NTX
2001-04-17 00:00:00 | TRUNKL/STX
2001-04-17 00:00:00 | WADDINGTON/IM
Spreadsheet: 155514d1336913478-calculating-3-from-5-cells-overall-points-from-15-races
Sheet: Sheet1

Please Note: It's hard to show the current leader in the Grand Prix results because runners need to complete in 3 from 5 races in the Road, Fell & Trail races. The best 3 results from each category will go towards the final results where runners need to complete the 9 races to count, this will become alot clearer when the runners  have completed alot more races. The winner will be the runner with the lowest points from the 9 races. This system works with all other Grand Prix series around the North-west including the mid-Lancs. and Red rose cross country.
 |  |  |  |  | Hameldon (fell) | Pinhaw ( Trail) | [NAME]( Trail) | Burnley Lions 10K(road) | Kelbrook(fell) | Barley Classic(fell) | Burnley Boys Club 10K(Road) | Hendon Brook(Road) | Trawden(Trail) | Towneley 5K(road) | [NAME]) | Hurst Green(Trail) | Cliviger 6 mile( Road) | Worsthorne Moor (fell) | Buulsworth Fell( fell) | Total Road Points ( 3from 5) | Total Trail points ( 3from 5) | Total Fell points ( 3 from 5) | Overall points best 3 from 5 road,Trail & Fell
Num | Forename | Surname | Cat | Club |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Road | Trail | Fell | Overall
34 | [NAME] | Green | F | Keighley + Craven AC | 1 | 1 | 3 | 5 | 2 | 6 | 4 | 8 | 1 | 2 | 6 | 8 | 4 | 7 | 3
107 | Beckie | [NAME] | FJ | [NAME] | 2 | 3 | 1 | 2 | 5 | 3 | 2 | 9 | 3 | 1 | 4 | 12 | 3 | 4 | 2
Spreadsheet: 729745d1619301165-help-with-countif-formula-for-calendar-countif-any-date-in-table-present-schedule-workbook-stat-holiday-help
Sheet: Schedule

Schedule
 |  |  |  |  |  |  |  | January |  |  |  |  | 2021
Employee
Employee 1 | 2 | 1 | 1 | 2 |  |  |  |  |  |  |  | 1 | 2 | 1 | 2 |  |  |  |  |  |  | 2 | 1 | 2 | 1
Employee 2 | 1 | 2 | 1 | 2 | 1 |  |  |  | 2 | 1 | 2 | 1 | 2 | 1 |  |  |  | 2 | 1 | 2 | 1 | 2 | 1 |  |  |  | 2 | 1 | 2 | 1
Employee 3 |  |  |  |  | 1 | 2 | 1 |  |  |  |  |  |  |  | 2 | 1 | 2 |  |  |  |  |  |  | 2 | 1 | 2 |  |  |  | 1
Employee 4 |  |  | 2 | 1 | 2 | 1 | 2 | 1 |  |  |  | 2 | 1 |  | 1 | 2 | 1 |  |  |  | 2 | 1 | 2 | 1 | 2 | 1 |  |  |  | 2
Employee 5 | 1 | 2 |  |  |  | 1 | 2 | 1 | 2 | 1 | 2 |  |  |  | 1 | 2 | 1 | 2 | 1 | 2 |  |  |  | 1 | 2 | 1 | 2 | 1 | 2
Employee 6 |  | 1 | 2 | 1 | 2 |  |  |  | 1 | 2 | 1 | 2 | 1 |  |  |  |  | 1 | 2 | 1 | 2 | 1 | 2 |  |  |  | 1 | 2 | 1 | 2
Employee 7 | 2 |  |  |  |  |  | 1 | 2 | 1 | 2 | 1 |  |  |  |  | 1 | 2 | 1 | 2 | 1 |  |  |  |  |  | 2 | 1 | 2 | 1
Employee 8 |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  |  |  | 1
Employee 9 |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2
Spreadsheet: 119a687b-fa50-41db-90a4-3cf7306184d8
Sheet: Sheet1

Sample - external code | SX1 | SX2 | SX3 | SX4 | SX5 | SX6 | SX7 | SX8 | SX9 | SX10 | SX11 | SX12 | SX13 | SX14 | SX15 | SX16 | SX17 | SX18 | SX19 | SX20 | SX21 | SX22 | SX23 | SX24 | SX25 | SX26 | SX27 | SX28 | SX29 | SX30 | SX31 | SX32 | SX33 | SX34 | SX35 | SX36 | SX37 | SX38 | SX39 | SX40 | SX41 | SX42 | SX43 | SX44
1 | GG | - | TT | AA | GG | AA | AA | CC | GG | AA | AA | GG | CC | AA | GG | AA | CC | AA | AA | CC | AA | ZZ | GG | AA | TT | TT | AA | AA | AA | AA | GG | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | AA | GG | CC
2 | GG | - | TT | AA | GG | AA | AA | CC | GG | AA | AA | GG | CC | AA | GG | AA | CC | AA | AA | CC | AA | ZZ | GG | AA | TT | TT | AA | AA | AA | AA | GG | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | AA | GG | CC
3 | GG | - | TT | AA | GG | AA | AA | CC | GG | AA | AA | GG | CC | AA | GG | AA | CC | AA | AA | CC | AA | ZZ | GG | AA | TT | TT | AA | AA | AA | AA | GG | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | AA | GG | -
4 | GG | - | TT | AA | GG | AA | AA | CC | GG | AA | AA | GG | CC | AA | GG | AA | CC | AA | AA | CC | AA | ZZ | GG | AA | TT | TT | AA | AA | AA | AA | GG | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | AA | GG | CC
5 | GG | - | TT | AA | GG | AA | AA | CC | GG | AA | AA | GG | CC | AA | GG | AA | CC | AA | AA | CC | AA | GG | GG | AA | TT | TT | AA | AA | AA | AA | GG | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | AA | GG | CC
6 | GG | ZZ | - | AA | - | AA | AA | CC | GG | AA | AA | GG | CC | AA | GG | AA | CC | AA | AA | CC | AA | GG | GG | AA | - | TT | - | AA | AA | AA | GG | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | AA | GG | CC
7 | GG | - | - | AA | GG | AA | AA | - | GG | AA | AA | GG | CC | AA | - | AA | CC | AA | AA | CC | AA | GG | - | AA | TT | TT | AA | AA | AA | AA | - | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | - | GG | CC
8 | GG | - | TT | AA | GG | AA | AA | CC | GG | AA | AA | GG | CC | AA | GG | AA | CC | AA | AA | CC | AA | GG | GG | AA | TT | TT | AA | AA | AA | AA | GG | GG | CC | GG | GG | AA | GG | GG | CC | TT | CC | AA | GG | CC
Spreadsheet: 153051d1335729706-deleting-duplicate-entries-book1
Sheet: Sheet1

sort these - A/Z | Copy/paste values to column C | highlight and sort addresses you just pasted here
IP Address NetBios Name | logic | List
192.168.203.227 STG-CXPKAPP02
192.168.203.229 STG-CXPKAPP02
192.168.203.230 STG-CXPKAPP02
192.168.203.231 STG-CXPKAPP02
192.168.204.111
192.168.205.112 |  | 192.168.203.227 STG-CXPKAPP02
192.168.206.113 |  | 192.168.204.111
192.168.207.114 |  | 192.168.205.112
192.168.207.115 |  | 192.168.206.113
192.168.208.116 |  | 192.168.207.114
192.168.209.117 |  | 192.168.208.116
192.168.209.118 |  | 192.168.209.117
192.168.210.119 |  | 192.168.210.119
Spreadsheet: 889648d1740552091-formula-to-spill-data-from-a-table-based-on-multiple-condtions-ck458-table-data-extraction-spill-365-aligw
Sheet: Output

 |  |  |  |  |  |  |  |  | Enter Start Date |  | 2025-01-10 00:00:00
 |  |  |  |  |  |  |  |  | Enter End Date |  | 2025-01-26 00:00:00
Displays work that is ready waiting for delviery (> 2 days) |  |  |  |  |  |  |  |  |  |  |  | Displays work that has taken longer than 2 days to deliver (using date range in L2 & L3)
# | Date | Type | Tm# | Inv# | Pw | Name | Co | Status |  |  |  | # | Date | Type | Tm# | Inv# | Pw | Name | Co | Status | date2 | Com | Name (c) | Name (d) | PW2 | Status (d)
10 | 2025-01-22 00:00:00 | C | 24424 | 55485 | y | [NAME] | TMX | Ready |  |  |  | 6 | 2025-01-10 00:00:00 | C | 44548 | 55485 | y | [NAME] | TMX | Ready | 2025-01-13 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
12 | 2025-01-24 00:00:00 | B | 44548 | 55485 | y | [NAME] | MBC | Ready |  |  |  | 9 | 2025-01-14 00:00:00 | A | 44225 | 55485 | y | [NAME] | TMX | Ready | 2025-01-25 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
13 | 2025-01-25 00:00:00 | C | 44548 | 55485 | y | [NAME] | MBC | Ready
14 | 2025-01-26 00:00:00 | A | 44548 | 55485 | y | [NAME] | MBC | Ready |  |  |  |  | 2025-01-10 00:00:00 | C | 44548 | 55485 | y | [NAME] | TMX | Ready | 2025-01-13 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
15 | 2025-01-27 00:00:00 | A | 22585 | 55485 | y | Janice | MBC | Ready |  |  |  | 9 | 2025-01-14 00:00:00 | A | 44225 | 55485 | y | [NAME] | TMX | Ready | 2025-01-25 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
 | 2025-01-22 00:00:00 | C | 24424 | 55485 | y | [NAME] | TMX | Ready
12 | 2025-01-24 00:00:00 | B | 44548 | 55485 | y | [NAME] | MBC | Ready
13 | 2025-01-25 00:00:00 | C | 44548 | 55485 | y | [NAME] | MBC | Ready
14 | 2025-01-26 00:00:00 | A | 44548 | 55485 | y | [NAME] | MBC | Ready
15 | 2025-01-27 00:00:00 | A | 22585 | 55485 | y | Janice | MBC | Ready
16 | 2025-02-24 00:00:00 | B | 44548 | 55485 | y | [NAME] | MBC | Ready
17 | 2025-02-24 00:00:00 | B | 44548 | 55485 | y | [NAME] | MBC | Ready
18 | 2025-02-24 00:00:00 | C | 44548 | 55485 | y | [NAME] | EW | Ready
Spreadsheet: 167158d1341918371-excel-2007-a-list-that-populates-based-on-the-values-in-another-cell-book1
Sheet: Sheet1

[NAME] | Yes
[NAME] | No
[NAME] | No
Stuart | no
aa | yes
bb | yes
cc | no
dd | yes
ee | no
ff | yes
Spreadsheet: 835451d1688586388-formula-to-sum-values-until-level-is-or-lower-bom-sample-bom
Sheet: Planilha1

 | Lvl | Pn | Value |  | Pn | Total
 | 1 | 123456 | 0 |  | 45678
 | 2 | xxxx | 100 |  | 6868
 | 2 | 6868 | 100
 | 3 | xxxx | 100
 | 4 | xxxx | 100
 | 5 | xxxx | 100
 | 1 | 45678 | 0
 | 2 | xxxx | 100
 | 3 | xxxx | 200
 | 3 | xxxx | 300
Spreadsheet: 837280d1689989310-v-xlookup-to-identify-date-range-overlaps-between-2-sheets-test_call_data
Sheet: Clockings

code | InClock | OutClock | Overlap/No Overlap
12244 | 2023-07-16 19:05:00 | 2023-07-16 20:35:00
125405 | 2023-07-17 16:53:00 | 2023-07-18 06:54:00 | No Overlap
123982 | 2023-07-17 22:09:00 | 2023-07-17 23:52:00 | No Overlap
148457 | 2023-07-17 22:20:00 | 2023-07-18 00:18:00 | Overlap
124058 | 2023-07-18 15:30:00 | 2023-07-18 18:49:00 | No Overlap
107348 | 2023-07-18 22:00:00 | 2023-07-19 07:00:00 | Overlap
155702 | 2023-07-18 22:52:00 | 2023-07-19 02:22:00 | Overlap
107348 | 2023-07-22 08:00:00 | 2023-07-22 20:00:00 | Overlap
 |  |  | Overlap
 |  |  | 107348
 |  |  | 155702
 |  |  | 107348
Spreadsheet: chris_germany__2056__MCV Invoice Analysis 4-29-02
Sheet: Historical Calcs

 |  |  | MCV II |  |  |  |  | MCV II
 |  |  |  |  |  |  |  |  | IF-HEHUB |  | IF-PAN/TX/OK |  |  |  |  | IF-ANR/LA |  |  |  |  | IF-TRUNKL/LA |  |  |  |  | IF-TRUNKL/TX |  |  |  |  | TOTAL MCV II |  |  | TOTAL INVOICE I AND II
Del Month | Days |  | Monthly Volume | Monthly Volume | Fixed Price | Monthly Revenue |  | Fixed Price | Price |  | Monthly Volume | IF-FOM | Sale Price | Monthly Revenue |  | Monthly Volume | IF-FOM | Sale Price | Monthly Revenue |  | Monthly Volume | IF-FOM | Sale Price | Monthly Revenue |  | Monthly Volume | IF-FOM | Sale Price | Monthly Revenue |  | Monthly Volume | Revenue |  | Monthly Volume | Revenue
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
Spreadsheet: 824901d1680947860-how-to-calculate-a-trend-and-use-up-and-down-arrows-example
Sheet: Sheet1

 |  |  | 2022 |  |  |  |  |  |  |  |  |  |  | 2023 | Last 12 Months | Performance Trend
 |  |  | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEPT | OCT | NOV | DEC | JAN
 |  |  | 0.556 | 1 | 0.625 | 0.5 | 0.75 | 0.667 | 0.4 | 0.714 | 0.857 | 0.235 | 0.615 | 0.417 | 0.597
 |  |  | 1 | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5315

5315 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 208004d1358648070-subdata-sheet-problem-works-hours-employers
Sheet: Daily hours Employer 1

 |  | Daily hours Employer 1
 |  | 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 | 26 | 27 | 28 | 29 | 30 | 31
 | 07:00:00
 | 08:00:00 | location A
 | 09:00:00 | location A
 | 10:00:00 | location A | locationC
 | 11:00:00 | location A | locationC
 | 12:00:00 |  | locationC
 | 13:00:00 |  | locationC
 | 14:00:00 |  | locationC
 | 15:00:00 |  | locationC
 | 16:00:00 | location B | locationC
 | 17:00:00 | location B | locationC
 | 18:00:00 | location B
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 22:00:00
 | Hours | 7 | 7
Spreadsheet: 294559d1391435594-vlookup-with-wildcards-but-the-wrong-way-around-vlookup
Sheet: Sheet1

Search term | Category Name |  | Bank Statement Item Name | Result | Expected result
MTN | MTN |  | WOOLWORTHS NORTHCLIFF J CRESTA |  | Woolworths
Vodacom | Vodacom |  | WOOLWORTHS VICTORY PARK JOHANNESBURG |  | Woolworths
Cormanco | Coronation |  | WOOLWORTHS CLEAR WATER  WEST RAND |  | Woolworths
Woolworths | Woolworths |  | I1954491 [PHONE] VODACOM SP |  | Vodacom
Liberty | Retirement Anuity |  | I2974535 [PHONE] VODACOM SP |  | Vodacom
 |  |  | MTN SP    A4763615  [PHONE] |  | MTN
 |  |  | CORMANCO  Y00424119C0006029169 |  | Coronation
 |  |  | CORMANCO  Y00424119C0006044114 |  | Coronation
 |  |  | CORMANCO  Y00424119C0006044118 |  | Coronation
 |  |  | CORMANCO  Y00424119C0006044119 |  | Coronation
 |  |  | LIBERTY050 [PHONE]    51366 |  | Liberty
Spreadsheet: 720123d1614022237-i-have-a-formula-in-excel-and-want-it-to-return-blank-if-ref-cell-is-blank-and-not-0-sku-holo-autofill-test
Sheet: Holograms

Hologram # | SKU | Player Signed | Inscription | [NAME] (holo#/players) | Item | Date
ABC1234 | REIBSK202
ABC1235 | SIKBSK201
[NAME] | SIKBSK201
ABC1237
ABC1238 | SIKBSK201
[NAME] | SIKBSK201
ABC1240
ABC1241 | SIKBSK201
ABC1242 | SIKBSK203
Spreadsheet: 79277d1279560863-writing-a-recursive-function-example
Sheet: Equipment List

serialnum | manufacturer | model | clli | asset tag | purchase year | pid |  | status | mic | cost | notes |  | DO NOT EDIT | DS0 | DS1 | DS3 / E3 | T1 / E1 | IMA | Service Type 6 | Service Type 7 | OC1 / STS-1 | [NAME] | OC12 | Ethernet Electrical 10/100 | Ethernet Optical 1000 | Interface Type 6 | Interface Type 7
1 | Electrodata | model a | NYC | To be assigned | 2012 | N/A |  | Available | N/A | 1 | can be left at customer |  |  | True | True | True |  |  |  |  | True | True | True
2 | Electrodata | model b | NYC | To be assigned | 2012 | N/A |  | Decommissioned | N/A | 1 | remote security |  |  | True | True |  |  |  |  |  |  |  |  | True | True | True | True
3 | Electrodata | model c | NYC | To be assigned | 2012 | N/A |  | On Loan | N/A | 1 | remote dial in |  |  | True |  |  |  |  |  |  |  |  |  | True | True
4 | Electrodata | model d | NYC | To be assigned | 2012 | N/A |  | Lost/Stolen | N/A | 1 | 56k dial in |  |  |  |  |  | True |  |  |  |  |  |  | True | True
5 | Electrodata | model e | NYC | To be assigned | 2012 | N/A |  | Out for Repair | N/A | 1 | remote security |  |  |  |  |  | True | True |  |  | True | True | True
6 | Electrodata | model f | NYC | To be assigned | 2012 | N/A |  | Out for Upgrade | N/A | 1 | can be left at customer |  |  |  |  |  |  |  | True |  |  |  |  | True | True | True | True
7 | Electrodata | model g | NYC | To be assigned | 2012 | N/A |  | In Use | N/A | 1 | remote dial in |  |  |  |  |  |  |  |  | True | True | True | True
8 | Electrodata | model h | NYC | To be assigned | 2012 | N/A |  | Decommissioned | N/A | 1 | can be left at customer |  |  |  |  |  | True | True | True |  |  |  |  | True | True | True | True
9 | Electrodata | model i | NYC | To be assigned | 2012 | N/A |  | Out for Upgrade | N/A | 1 | can be left at customer |  |  |  |  |  | True | True |  |  |  |  |  | True | True | True | True
10 | Electrodata | model j | NYC | To be assigned | 2012 | N/A |  | In Use | N/A | 1 | can be left at customer |  |  |  |  |  | True | True |  |  |  |  |  | True | True | True | True
Spreadsheet: 117193d1312493759-nested-sumifs-sample
Sheet: Model

 | Cases
 | Revenue |  |  |  | US$, k
 | Expenses
 |  | Compensation |  |  | US$, k
 |  | Due Diligence |  |  | US$, k | 40
 |  | Marketing |  |  | US$, k | 10 | 10
 |  | Other |  |  | US$, k | 25
 |  | Shared Expense Alloc'n |  |  | US$, k
 | Total Expenses |  |  |  | US$, k
 | EBITDA |  |  |  | US$, k
 | Impairment Charges |  |  |  | US$, k
 | Due Diligence
 |  | DD costs include professional fees and technical analysis associated with the review of potential investment opportunities. The model assumes a 4% quarterly growth rate.
 | Marketing
 |  | Marketing expenses includes industry trade shows (estimated to be 3-4 per year), printed marketing collateral, and general "client acquisition" costs
 | Other
 |  | Other costs is a "catch-all" category to cover travel, trade shows, marketing
 | Shared Expense Allocation
 |  | This expense category captures any expenses covered by WiLAN (overhead, occupancy, etc.) allocated to the DRIP
 | Compensation
 |  | Compensation Growth Rate
 |  |  | Annual |  |  | 0.04
 |  |  | Quarterly
 |  | Executives
 |  |  | Divisor (on Cases) |  |  | 10
 |  |  | All-in Compensation |  | US$, k | 50
 |  |  | Headcount |  |  | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  | US$, k
 |  | Attorneys
 |  |  | Divisor (on Cases) |  |  | 8
 |  |  | All-in Compensation |  | US$, k | 55
 |  |  | Headcount
 |  |  |  |  | US$, k
 |  | Patent Specialists, Other
 |  |  | Divisor (on Cases) |  |  | 6
 |  |  | All-in Compensation |  | US$, k | 37.5
 |  |  | Headcount
 |  |  |  |  | US$, k
 |  | Support Staff
 |  |  | Divisor (on Prof. Headcount) |  |  | 5
 |  |  | All-in Compensation |  | US$, k | 15
 |  |  | Headcount
 |  |  |  |  | US$, k
 |  |  |  | Total Headcount
 |  |  |  | Total Compensation | US$, k
Spreadsheet: 220794d1363267951-adding-rows-with-data-tandridge-test
Sheet: Ark2

 |  |  |  |  |  |  |  |  |  | Antal stjärnor: | [NAME]: | [NAME]: | Antal stjärnor:
 |  |  | KLAR! | Lagskillnad i antal stjärnor: |  |  |  |  |  | 2 | 3 | 0 | 5
 |  |  | KLAR! | Målskillnad:
 |  |  | KLAR! | [NAME]: | 20
 |  |  | KLAR! | Målskillnad-beräkning:
 |  |  | KLAR! | Resultat:
 |  |  | KLAR! | Skillnad i Ranking Poäng:
 |  |  | KLAR! | Förväntat resultat:
 |  |  |  | Skillnad i Poäng:
 |  | Haydn1732 | 1000
 |  | Mallorca | 1600