tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: paul_y'barbo__28534__ernesto-2000
Sheet: Sheet1

EcoElectrica, LP
Capacity and Energy per kWh
Year 2000
 |  | Mar '00 | Apr '00 | May '00 | Jun '00 | Jul '00 | Aug '00 | Sep '00 | Oct '00 | Nov '00 | Dec '00 | Total
Dispatch Factor %
Capacity Factor %
Capacity Payment |  | 3497927 | 10689790.96 | 11252411.54 | 7077766.86 | 7764163.96 | 11016110.9 | 7573498.1 | 0 | 7926698.8 | 7448370.46
Energy Payment |  | 2144743 |  | 7454220.61 | 5576876.28 | 6005990.22 | 7168002.86 | 5820245.94 | 5147523.63 | 5402695.68 | 6038655.2
Total
kWhs Generated |  | 81664440 | 235785640 | 289133440 | 210116800 | 235814760 | 286373000 | 229503840 | 179752560 | 208990000 | 225919459
Monthly:
Capacity Payment per kWh
Energy Payment per kWh
Capacity & Energy per kWh
Rolling Average:
Capacity Payment per kWh
Energy Payment per kWh
Capacity & Energy per kWh
Spreadsheet: 868792d1715488251-from-dropdown-list-match-across-multiple-sheets-dropdown-match-across-multiple-sheets
Sheet: Vendor

 |  | Month |  |  |  |  |  |  |  |  |  | 1 to 11 |  |  | 11 to 20 |  |  | 21 to EOM
Contact No. | Sr. No | [NAME] |  | Category | 1 to 11 | 11 to 20 | 21 to EOM | Purchase | Per Day | Balance | Total Paid | Cheque | Online | Cash | Cheque | Online | Cash | Cheque | Online | Cash
 | 1 |  | Resto | Milk | 5725 | 5550 | 4200 |  |  |  |  | 5725 |  |  | 5550 |  |  |  | 4200
 | 2 |  | Resto | Dairy Product | 9445 | 10120 | 11120 |  |  |  |  | 9445 |  |  | 10120 |  |  |  | 10765
 | 3 |  | Resto | [NAME] | 21041 | 26818 | 22016 |  |  |  |  | 21041 |  |  | 26818 |  |  | 22016
 | 4 |  | Resto | Vegetable | 19707 | 16938 | 20611 |  |  |  |  | 19707 |  |  | 16938 |  |  | 20611
Spreadsheet: 143131d1330214272-sorting-multiple-columns-with-lookup-values-sorting
Sheet: Sheet1

Rank | RANKINGS |  |  |  | Rank | Results | Points | Correct Picks | Rank Score
1 | [NAME] | 4 | 2 |  | 3 | [NAME] | 3 | 1 | 3.001009309202299
2 | [NAME] | 3 | 3 |  | 1 | [NAME] | 4 | 2 | 4.002007176993952
3 | [NAME] | 3 | 1 |  | 2 | [NAME] | 3 | 3 | 3.003000212998023
4 | [NAME] | 3 | 1 |  | 4 | [NAME] | 3 | 1 | 3.001007345549333
 |  | ^ SORT THESE ^ |  |  |  | ^These are updated and I want the RANKINGS to change
 |  |  |  |  | 1. Sort by Column B
 |  |  |  |  | 2. A and C just go along with it
Spreadsheet: c149a662-0ccf-4ab5-9e72-2c5084ee063e
Sheet: SJ Caltrain

Site ID | Priority Ranking1 | Readiness | Street Name | Side of Street | Nearest Cross-street | Closest Property | Station Length2 | Sidewalk | Parking Lane | Private Property | Historical Site | Environmental Issues | Construction Needed | Comments (If applicable, explain construction/ environmental issues)
CSJ001 | 1 | 1 | [NAME] | S | [NAME] (at southwest parking lot) | Caltrain Station | 30 docks | Y | N | N | Y | Y | N | On historical site (environmental issues)
CSJ002 | 2 | 2 | [NAME] | E | [NAME] (across from transit loading) | Caltrain Station | 30 docks | Y | N | N | Y | Y | Y | May need electrical connection On historical site (environmental issues)
CSJ003 | 2 | 2 | Caltrain Station | SE | Cahill St (adjacent to special parking) | Caltrain Station | 10 docks | Y | N | N | Y | Y | Y | Remove lawn, paving On historical site (environmental issues)
CSJ004 | 2 | 2 | Caltrain Station | SE | Cahill St (adjacent to special parking, just south of SJ003) | Caltrain Station | 10 docks | Y | N | N | Y | Y | Y | Remove lawn, paving On historical site (environmental issues)
CSJ005 | 3 | 2 | [NAME] | W | [NAME] | Caltrain Station | 12 docks | Y | N | N | Y | Y | Y | Remove lawn, paving On historical site (environmental issues)
1. Only priority ranking 1 sites are being considered for the pilot program.
2. Assumes a kiosk at the station
Spreadsheet: 235535d1368533143-pull-data-using-drop-down-list-urgent-attached-sample-2-
Sheet: Works in your area

 | Please use the drop-down box below to select your Parish
 | LITTLEHAMPTON
 | Job Ref. | Work Type | Timing | Traffic Management | Location | Duration | Start date | Finish date
Spreadsheet: 69612d1270146721-poker-points-standings-poker-results
Sheet: Sheet1

 |  | Results |  |  |  |  |  |  |  |  |  |  | Player | Tot Season Pts
Week | Player Ct | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | [NAME] |  | This should equal 83
1 | 7 | [NAME] | Wayne | Eddie | [NAME] | [NAME] | Heath | J |  |  |  |  | Wayne
2 | 8 | [NAME] | J | Heath | Wayne | [NAME] | Eddie | [NAME] | [NAME] |  |  |  | Eddie
3 | 5 | [NAME] | [NAME] | Heath | Eddie | Wayne |  |  |  |  |  |  | [NAME]
4 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
5 | 6 | Eddie | J | [NAME] | Heath | [NAME] | [NAME] |  |  |  |  |  | Heath
6 | 4 | Heath | Wayne | Eddie | [NAME] |  |  |  |  |  |  |  | J
7 | 4 | Heath | [NAME] | [NAME] | Eddie |  |  |  |  |  |  |  | [NAME]
8 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
9 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
10 | 8 | J | Wayne | [NAME] | [NAME] | Heath | Eddie | [NAME] | [NAME]
11 | 4 | Wayne | Eddie | [NAME] | J
12 | 4 | J | Heath | Wayne | [NAME]
13 | 6 | [NAME] | Wayne | Eddie | [NAME] | Heath | J
14 | 6 | J | Wayne | Eddie | [NAME] | [NAME] | Heath
15 | 4 | [NAME] | [NAME] | Eddie | [NAME]
16 | 5 | Wayne | Eddie | Heath | [NAME] | J
17 | 6 | [NAME] | [NAME] | Eddie | Heath | Wayne | [NAME]
18 | 6 | [NAME] | Heath | [NAME] | Wayne | J | [NAME]
19 | 8 | J | [NAME] | [NAME] | [NAME] | [NAME] | Eddie | Wayne | Heath
20 | 6 | [NAME] | Wayne | [NAME] | Heath | J | [NAME]
21 | 6 | [NAME] | Eddie | [NAME] | J | Heath | [NAME]
22 | 6 | [NAME] | [NAME] | Wayne | J | Heath | Eddie
Spreadsheet: 35385d1232992489-excel-2007-dropdown-different-sums-possible-p47-2009
Sheet: aprēķini

Vārds : | [NAME]
Iedzīvotāju skaits | 3 |  | [NAME] aprēķins
Īres aprēķins sākot ar 2008. g. 01. [NAME] un komunālo [NAME] aprēķins. |  |  | Datums | Īres maksa | Ūdens un kanalizācija | Īpašuma nodoklis | [NAME] elektrība | Patērētā elektrība | CAS izvešana | [NAME] | Dzīvnieku [NAME] | ASU | ŪTA | Šķūnis/ pieliekamais | Garāža | Jāmaksā
[NAME] | 0.45 |  | [NAME]
[NAME] par 1 m2 |  | Ls | [NAME]
Apmaksājamā kopējā platība | 56.7 | m2 | Marts
[NAME] par 1 m2 | 1.2 | Ls | Aprīlis
Elektrība par 1 kw | 0.051 | 0.071 | Maijs
 |  |  | Jūnijs
CAS izvešana |  |  | [NAME]
[NAME] |  |  | Augusts
 |  |  | [NAME]
Suņu skaits | 0 |  | [NAME]
Šķūņu skaits | 1 |  | Novembris
Pieliekamo skaits | 0 |  | Decembris
Garāžu skaits | 0
Vārds : | Viktors Kļementjevs
Iedzīvotāju skaits | 1 |  | [NAME] aprēķins
Īres aprēķins sākot ar 2008. g. 01. [NAME] un komunālo [NAME] aprēķins. |  |  | Datums | Īres maksa | Ūdens un kanalizācija | Īpašuma nodoklis | [NAME] elektrība | Patērētā elektrība | CAS izvešana | [NAME] | Dzīvnieku [NAME] | ASU | ŪTA | Šķūnis/ pieliekamais | Garāža | Jāmaksā
[NAME] | 0.45 |  | [NAME]
[NAME] par 1 m2 |  | Ls | [NAME]
Apmaksājamā kopējā platība | 30 | m2 | Marts
[NAME] par 1 m2 | 1.2 | Ls | Aprīlis
Elektrība par 1 kw | 0.051 | 0.071 | Maijs
 |  |  | Jūnijs
CAS izvešana |  |  | [NAME]
[NAME] |  |  | Augusts
 |  |  | [NAME]
Suņu skaits | 0 |  | [NAME]
Šķūņu skaits | 1 |  | Novembris
Pieliekamo skaits | 1 |  | Decembris
Garāžu skaits | 0
Viktors [NAME]
Spreadsheet: 844492d1696266514-unique-vstack-subtotal-on-two-filtered-tables-subtotal-tabel-row
Sheet: Sheet1

 |  | Animal list 1 | Category | IsVisible
 |  | Cat | 1
 |  | Dog | 1
 |  | Frog | 2
 |  | Chicken | 2
 |  | Animal list 2 | Category | IsVisible
 |  | Horse | 1
 |  | Eagle | 2
 |  | Cat | 1
 |  | Frog | 2
 |  | The below list in C21 but with subtotal function so if I filter one table the spilled array will adjust
 |  | Eagle | Eagle
 |  | Cat | Cat
 |  | Frog | Frog
 |  | Dog | Dog
 |  | Chicken | Chicken
Spreadsheet: 491029d1480271215-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-1-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Stenographer | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1 | Stacy |  | 09:00:00 | 10:00:00 | 11:00:00 | 14:00:00 |  |  |  |  |  |  | Pretend Employee
2 | [NAME] |  | 09:00:00 | 11:00:00 | 11:30:00 | 15:30:00
3 | [NAME] |  | 14:00:00 | 16:00:00 | 16:30:00 | 17:00:00 |  |  |  |  |  |  | Pretend Employee
4 | [NAME] |  | 14:40:00 | 16:00:00 | 16:30:00 | 17:00:00
5 | [NAME] |  | 13:00:00 | 16:00:00 | 16:30:00 | 17:00:00
6 | [NAME] |  | 13:00:00 | 16:00:00 | 16:30:00 | 17:00:00 |  |  |  |  |  |  | Pretend Employee
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS (Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | Hearings (Week End Total):
Spreadsheet: 775883d1649361686-using-a-location-reference-combine-information-from-two-tabs-into-a-consolidated-list-test-worksheet
Sheet: FGE Store List

VP | VPEmail | Region | RDO | RM | DM | GM | Location Code | State Abbr
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | 15 Manager | 000015 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | DE-0019 Manager | 000019 | DE
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | VA-20 Manager | 000020 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | DE-31 Manager | 000031 | DE
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | SC | 000034 | SC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-38 Manager | 000038 | NC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-49 Manager | 000049 | NC
[NAME] | [EMAIL] | Region 4 | Alc | Will | Scott | NY | 000052 | NY
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-53 Manager | 000053 | MD
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | NC | 000057 | NC
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-60 Manager | 000060 | MD
[NAME] | [EMAIL] | Region 4 | Alc | Will | Kurt | PA | 000061 | PA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-63 Manager | 000063 | SC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | 64 Manager | 000064 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-68 Manager | 000068 | MD
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-72 Manager | 000072 | SC
[NAME] | [EMAIL] | Region 4 | Alc | Will | Kurt | PA | 000076 | PA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-77 Manager | 000077 | SC
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-80 Manager | 000080 | MD
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | VA-88 Manager | 000088 | VA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-89 Manager | 000089 | NC
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | SC | 000091 | SC
[NAME] | [EMAIL] | Region 6 | Todd | Jeremy | Mistry | nc | 002021 | ND
[NAME] | [EMAIL] | Region 6 | Todd | Jeremy | Mistry | MN-2030 Manager | 002030 | MN
Spreadsheet: 884554d1733793107-roi-formula-2024-tos-trades-test
Sheet: Sheet1

DATE | [NAME] | ACTION | SIZE | EQ | SERIES | INSTRUMENT | Near | Mid | Far | STOP | SPREAD | POINTS | COST/CREDIT | NET P/L | ROI | Notes
2024.12.04 | ~12:15 | STO | 3 | ROKU | 2024.12.06 | PUT Vertical | 81 |  | 78 | 79 | .46/.13 | 0.33 | 0.99 | 95.03 |  | $10 gap up, 1D5M above 8 & 21, 81 is SD less than [NAME], Prob ITM <18%
2024.12.06 | 11:45:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical | 990 |  | 985 | 991 | 1.01/.31 | 0.69 | 1.38 | 137.34 |  | 1D5M above 8 & 21, good 5M support @991, Prob ITM <26%
2024.12.06 | 11:45:00 | STC | 2 | COST | 2024.12.06 | PUT Vertical | 990 |  | 985 |  | 1.05/.295 | -0.75 | -1.5 | -153.65 |  | wrong conditional entry
2024.12.06 | 12:32:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical | 990 |  | 985 | 991 | 1.20/.32 | 0.88 | 1.76 | 173.34 |  | 1D5M above 8 & 21, good 5M support @991, Prob ITM <25%
2024.12.06 | 15:51:00 | STC | 2 | COST | 2024.12.06 | PUT | 990 |  |  |  | 0.17 | 0.17 | -3.5 | -35.32
Old layout but with extra columns inserted:
DATE | [NAME] | ACTION | SIZE | EQ | SERIES | INSTRUMENT |  |  |  | STOP | SPREAD | POINTS | COST/CREDIT | NET P/L | ROI
2024.12.04 | ~12:15 | STO | 3 | ROKU | 2024.12.06 | PUT Vertical 81/78 |  |  |  | 79 | .46/.13 | 0.33 | 0.99 | 95.03
2024.12.06 | 11:45:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical 990/985 |  |  |  | 991 | 1.01/.31 | 0.69 | 1.38 | 137.34
2024.12.06 | 11:45:00 | STC | 2 | COST | 2024.12.06 | PUT Vertical 990/985 |  |  |  |  | 1.05/.295 | -0.75 | -1.5 | -153.65
2024.12.06 | 12:32:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical 990/985 |  |  |  | 991 | 1.20/.32 | 0.88 | 1.76 | 173.34
2024.12.06 | 15:51:00 | STC | 2 | COST | 2024.12.06 | PUT  990 |  |  |  |  | 0.17 | 0.17 | -3.5 | -35.32
Spreadsheet: 45093d1243871873-pivot-table-pivot-table
Sheet: Sheet10

Column Labels
0 | 0 Total | 20 |  |  | 20 Total | 30 |  |  | 30 Total | 40 |  |  | 40 Total | (blank) | (blank) Total | Grand Total
0 |  | 1 | 4 | 7 |  | 2 | 5 | 8 |  | 3 | 6 | 9 |  | (blank)
Spreadsheet: richard_ring__31522__GreenPowerSept01
Sheet: Sheet1

RATE_SCHEDULE_TYPE | CREDIT_MONTH | COUNT | CREDIT_USAGE | CREDIT_AMOUNT
O | 2001-09-01 00:00:00 | 1270 | 12245488 | 122454.88
R | 2001-09-01 00:00:00 | 26 | 15866 | 158.66
RC | 2001-09-01 00:00:00 | 359 | 227167 | 2271.67
S | 2001-09-01 00:00:00 | 4008 | 5613553 | 56135.53
Spreadsheet: 438306d1451922048-find-and-report-the-first-value-over-6000-in-a-row-excell-example-1-
Sheet: Sheet1

Acc Name | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | Amount when sales target reached | Month sales target reached
C I S INDUSTRIAL LTD |  |  |  |  |  |  | 7690 | 10940 | 14399 | 16425 | 23242 | 22524 | 26158 | 26190 | 32949 | 29816 | 30870 | 31094
ITV PLC T/A ITV YORKSHIRE
JMS OF DONCASTER LTD
POTTER LOGISTICS LTD |  |  |  |  | 2449 | 7967 | 8241 | 5556 | 6716 | 4346 | 2906 | 1651 | 2488 | 4483 | 4236 | 4096
SIMON WIDDOWSON LTD | 3285 | 2449 | 2078
WILFREDA BEEHIVE | 737
#A HINGLEY TRANSPORT (BRIERLEY | 592
#B & M RETAIL |  |  |  |  | 132 | 1711 | 2808 | 554 | 159 | 705 | 303 | 728 | 738 | 681 | 940 | 0
#FLIGHTS HALLMARK LTD (ROTOLA | 120 | 62 | 0 | 26 | 22
#HUGHES BROS (LLANRWST & | 40
A F BLAKEMORE & SON LTD
AIR PRODUCTS PLC |  |  |  |  |  |  |  |  |  | 80 | 0 | 19 | 142 | 239 | 525 | 1864 | 1147 | 840 | 0 | 0 | 0
ATS REF PJH GROUP |  |  |  |  |  |  |  |  | 66 | 239 | 434 | 0 | 0 | 1934 | 728 | 226 | 544 | 2334 | 0 | 0
ATS REF VPS (UK) LTD |  |  |  |  | 2143 | 0 | 520 | 0 | 620 | 0 | 0 | 2568 | 0 | 248 | 0 | 0
BENTONS HAULAGE LTD | -334 | 0 | 0 | 0 | 0 | 0 | 0
CAR & COMMERCIAL/STVA LTD | 2155 | 2578 | 2792
CARLTON HIRE LTD T/A CARLTON | 456
D J B HAULAGE LTD | 7124
DIGNITY FUNERALS LTD |  |  |  |  |  |  | 5857 | 2895 | 7980 | 7296 | 4438 | 4594 | 6761 | 4237 | 4571 | 3212 | 5695 | 5582
ENGLISH LANDSCAPES LTD |  |  |  |  |  |  | 506 | 403 | 299 | 592 | 154 | 301 | 287 | 324 | 126 | 105 | 183 | 132
EURO CAR PARTS LTD (SMR)
FLIGHTS HALLMARK LTD |  |  |  |  | 197 | 2213 | 4100 | 3920 | 5249 | 5088 | 3434 | 1599 | 6808 | 4281 | 2873 | 4652
GILDERS TRANSPORT LTD |  |  | 284 | 517 | 697 | 667 | 1011 | 931 | 884 | 725 | 613 | 490 | 207 | 185
GMG ASSET MANAGEMENT UK LTD
 |  |  |  |  | 921 | 1652 | 1006 | 4281 | 4443 | 3812 | 1310 | 5555 | 2094 | 773 | 310 | -1323
 | 0 | 766 | 393 | 2547 | 591 | 0 | 0 | 0 | 334 | 1495 | 0
 |  |  |  |  |  |  | 73 | 67 | 165 | 62 | 67 | 0 | 175 | 215 | 88 | 132 | 134 | 73
 |  |  |  |  |  |  |  |  |  |  |  | 132 | 0 | -14 | 0 | 0 | 0 | 0 | 97 | 0 | -208 | 0 | 0
 | 35 | 702 | 853 | 735 | 773 | 841 | 882
 | 0 | 0 | 0 | 0 | 0 | 0
 | 251 | 349
Spreadsheet: 875524d1722102897-extract-values-from-table-based-on-outside-the-table-slicer
Sheet: Filters

 | Departments | Filter
 | All
 | [NAME]
 | IT
 | Networking
 | Campus
 | MGT
 | Departments | SubDepartment
 | All | All
 | [NAME] | Sub Division-1
 | [NAME] | Sub Division-2
 | [NAME] | Sub Division-3
 | [NAME] | Sub Division-4
 | [NAME] | Sub Division-5
 | [NAME] | Sub Division-6
 | [NAME] | Sub Division-7
 | [NAME] | Sub Division-8
 | [NAME] | Sub Division-9
 | IT | All
 | IT | Sub Division-10
 | IT | Sub Division-11
 | Campus | All
 | Campus | Sub Division-12
 | MGT | All
 | MGT | Sub Division-13
 | MGT | Sub Division-14
 | Networking | All
 | Networking | Sub Division-15
 | Networking | Sub Division-16
 | Networking | Sub Division-17
 | Networking | Sub Division-18
Spreadsheet: 837800d1690446544-highest-most-frequent-value-in-a-column-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | However, if we add a higher (less frequent) value into the mix the result is different.
 |  |  |  |  |  |  |  |  |  |  | It depends if the frequency overrides the [NAME] part
 |  |  | Low/ Medium/ High | Low/ Medium/ High | Low/ Medium/ High | Low/ Medium/ High |  |  |  |  | Low/ Medium/ High | Low/ Medium/ High | Low/ Medium/ High | Low/ Medium/ High
 |  |  | 4 | 7 | 0 | 1 |  |  |  |  | 4 | 7 | 0 | 1
 |  |  | 4 | 8 | 6 | 2 |  |  |  |  | 4 | 8 | 6 | 2
 |  |  | 0 | 0 | 0 | 3 |  |  |  |  | 5 | 0 | 0 | 3
 |  |  | 0 | 0 | 0 | 4 |  |  |  |  | 5 | 0 | 0 | 4
 |  |  | 4 | 2 | 0 | 5 |  |  |  |  | 4 | 2 | 0 | 5
 |  |  | 4 | 4 | 0 | 6 |  |  |  |  | 4 | 4 | 0 | 6
 |  |  | 4 | 7 | 2 | 7 |  |  |  |  | 4 | 7 | 2 | 7
 |  |  | 4 | 8 | 0 | 8 |  |  |  |  | 4 | 8 | 0 | 8
 |  | Answer to be | 4 | 8 | 0 | 8
 |  |  |  |  |  |  |  |  |  | windknife |  | 8 | 0 | 8
 |  | windknife |  | 8 | 0 | 8 |  |  |  | CheeseSandwich
 |  | CheeseSandwich
Spreadsheet: 2e2dbc5a-50c2-459f-b4a2-51b4e32bb402
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Conmec AS | [NAME] 80 | 0582 | Oslo | 21 08 80 00
Intelligent Telecom Services AS | [NAME] 80 | 0582 | Oslo | 810 12 200 | 810 12 210
[NAME] | Åkerøveien 12 | 0586 | Oslo | 22 22 10 10
MicroLink AS | Rådyrveien 13 | 0595 | Oslo | 22 59 98 80 | 22 25 98 89
[NAME] Consult | [NAME] 221B | 0584 | Oslo | 22 64 92 07
Nordisk Mobiltelefon Norge AS | Østre Aker Vei 19 | 0581 | Oslo | 965 01 500 | 73 90 50 00
Telerra AS Konkursbo | Østre Aker Vei 101 | 0596 | Oslo | 23 32 64 80 | 23 32 64 81
Nordisk Mobiltelefon Norge AS Konkursbo | Østre Aker Vei 19 | 0581 | Oslo | 23 11 11 11 | 23 11 10 10
[NAME] | [NAME] | 0583 | Oslo | 22 63 13 61
Telerra AS | Østre Aker Vei 101 | 0596 | Oslo
Total Telekom Holding AS | Økern [NAME] 1 | 0580 | Oslo | 09061
Grønland Data [NAME] | Sletteløkka 39B | 0597 | Oslo | 22 25 38 77
Telezone AS | Sven Oftedals Vei 5 | 0950 | Oslo
Tele Store AS | Erich Mogensøns Vei 38 | 0594 | Oslo | 22 65 22 23
Obleon | Selvbyggerveien 50 | 0591 | Oslo
Norges Televisjon AS | [NAME] 145 | 0580 | Oslo | 67 12 42 00 | 67 12 42 01
G Internett Cafe AS | Sinsenveien 74B | 0586 | Oslo
[NAME] | Ulvenveien 75B | 0581 | Oslo
Call4all AS | [NAME] 80 | 0582 | Oslo | 815 66 055 | 815 66 056
Total Telekom AS | Økern [NAME] 1 | 0580 | Oslo | 09061
Adi-Alarmsystem Norge AS | Østre Aker Vei 24 | 0581 | Oslo
Sro AS | Ulvenveien 75B | 0581 | Oslo
CenCom AS | Spireaveien 18 | 0580 | Oslo | 22 07 13 70 | 22 63 19 50
Media [NAME] | Økern [NAME] 13 | 0580 | Oslo | 23 68 80 00 | 22 02 53 10
Ascom (Norway) AS | [NAME] 80 | 0582 | Oslo | 23 24 77 00
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 690578d1597172528-textjoin-or-match-index-roster-test
Sheet: Day

 | Today
E | names | names | names | names
L | names | names | names | names
Skills
Data | names | names | names
Excel | names | names | names
Staffing | Names | Names | Names
Spreadsheet: 851193d1701415415-counting-number-of-months-with-multiple-criteria-year-end-bonus
Sheet: Sheet1

From Hans: |  |  | correct # of mons
DOH | DOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bonus at Separation
2023-10-15 00:00:00 | 2023-11-15 00:00:00 |  | 2 |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | # of mons
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | Prorata Bonus
2023-01-16 00:00:00 | 2023-12-16 00:00:00 |  | 11 | <--<<< | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | # of mons
 |  |  |  |  | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2023-02-15 00:00:00 | 2023-12-14 00:00:00 |  | 10 |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | # of mons | Prorata Bonus
 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
2022-04-01 00:00:00 | 2023-12-15 00:00:00 |  | 13 |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | # of mons
 |  |  |  | 2022 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | Year End Bonus (12 mons from 1 dec 22 to 30 nov 23) plus
 |  |  |  | 2023 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 month Prorata because date of separation in more than 15 days
2022-07-27 00:00:00 | 2023-09-18 00:00:00 |  | 10 |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | # of mons
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 10 | Prorata Bonus
2023-09-14 00:00:00 | 2024-11-30 00:00:00 |  | 12 |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | # of mons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
From Phuocam: |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | Year End Bonus (12 mons from 1 dec 23 to 30 nov 24)
 |  |  | 2
 |  |  | 11
 |  |  | 10
 |  |  | 13
 |  |  | 10
 |  |  | 12
 |  |  |  |  |  |  |  |  |  |  | Yes | No
If [NAME] is equal to or less than 15 days, count this as 1 month, if not do not count this month |  |  |  |  |  |  |  |  |  |  | 1 | 0
If DoS is equal to or more than 15 days, count this as 1 month, if not do not count this month |  |  |  |  |  |  |  |  |  |  | 1 | 0
Year End Bonus = 12 months