tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 736794d1623865372-duplicate-match-question-match-and-sort
Sheet: Sheet1

Identifier 1 | ID1 | Identifier 2 | Name | Address
1 | 31 | 10 | name 10 | addy 1
2 | 32 | 9 | name 9 | addy 2
3 | 33 | 8 | name 8 | addy 3
4 | 34 | 7 | name 7 | addy 4
5 | 35 | 6 | name 6 | addy 5
6 | 36 | 5 | name 5 | addy 6
7 | 37 | 4 | name 4 | addy 7
8 | 38 | 3 | name 3 | addy 8
9 | 39 | 2 | name 2 | addy 9
10 | 40 | 1 | name 1 | addy 10
Spreadsheet: 854254d1704201313-adding-blank-columns-choose-cols-filter-data-added_glen-1-
Sheet: Sheet3

 | Your expected results:
 | 1 | 75 | The  American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd | 2 | 9 | 11
 | Glen formula:
 |  | 75 | The American Insurance Company Limited. |  |  |  | 41 |  | 52 | 30
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  |  |  | 25 |  | 30
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd |  |  |  | 3 |  | 0 | 0
 | 7 | 9 | [NAME] ([NAME] (Main)) |  |  |  | 40 |  | 45 | 60
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd |  |  |  | 11 |  | 9 | 2
 |  |  |  |  |  |  |  | < this is extracting/pulling which infact we don't require
 |  |  |  |  |  |  |  | < this is extracting/pulling which infact we don't require
 |  |  |  |  |  |  |  | < this is extracting/pulling which infact we don't require
Spreadsheet: eric_saibi__9954__110701R
Sheet: Stryker Creek 02

Owner Name |  | TXU Electric
Station Name |  | Stryker Creek Power Station
Unit Name |  | Unit 02
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 527 MW
Start Date |  | 2001-10-19 00:00:00
End Date |  | 2001-11-06 00:00:00
Prv. Start Date |  | 2001-10-19 00:00:00
Prv. End Date |  | 2001-11-01 00:00:00
Comments |  | Boiler Inspection and Maintenance
SIC |  | 4911
Plant ID |  | 1000059
Unit ID |  | 1008592
Outage ID |  | 17977
Spreadsheet: 843785d1695635728-values-rank-occurrence-based-summarised-by-rank-v2-rank-summary
Sheet: Foglio1

 | Problem: Given a list of  valus and their rank based on their occurrences
 | show a TOP-DOWN summary of ranks and corresponding values
 |  |  |  |  |  |  |  |  |  |  |  | NOW I'm using the italian version of the newly bought OFFICE 2021 Prof. Plus
 | Values | [NAME] |  |  | Rank |  | Multiple (unwanted)  correspondents |  | Desired single corresp. Rank | Desired single corresp. Pair |  | Summary OK but NO TOP-DOWN !
 | 1417 |  |  |  |  |  |  |  | 4 | 1215 |  |  |  | M6 now amended to  -----> |  |  | =CONTA.SE($B$6:$B$15,N6#)
 | 1215 |  |  |  |  |  |  |  | 2 | 1417 |  | 4 | 1215 |  |  |  | Result: | still no TOP-DOWN!
 | 1523 |  |  |  |  |  |  |  | 1 | 1523 |  | 1 | 1523
 | 1215 |  |  |  |  |  |  |  | 1 | 3144 |  | 1 | 3144
 | 3144 |  |  |  |  |  |  |  | 1 | 7788 |  | 1 | 7788
 | 1417 |  |  |  |  |  |  |  | 1 | 3355 |  | 1 | 3355
 | 1215
 | 7788
 | 3355
 | 1215
Spreadsheet: 850826d1701175356-to-pull-out-data-in-excel-on-the-basis-of-conditions-sample-sheet-revised
Sheet: Result Sheet

 |  | 2023-04-25 00:00:00
Currency |  | A/C TITLE | A/C NUMBER | AMOUNT
USD | CREDIT | =IF($A5="USD",IFERROR(INDEX(Data!$C$4:$C$129,AGGREGATE(15,6,(ROW($A$4:$A$129)-ROW($A$4)+1)/(Data!$B$4:$B$129='Result Sheet'!$B$2),ROWS($1:1))),""),"")
 | CREDIT | =IF($A5=0," ",IFERROR(INDEX(Data!$C$4:$C$129,AGGREGATE(15,6,(ROW($A$4:$A$129)-ROW($A$4)+1)/(Data!$B$4:$B$129='Result Sheet'!$B$2),ROWS($1:1))),""))
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
 | CREDIT
Spreadsheet: 786338d1657119841-adding-leading-zero-leading-0
Sheet: Sheet1

SEC ID | Adding [NAME]
263494
265274
454492
560399
798059
2172286
2200154
2260824
2299453
2328595
2492519
2516022
2554475
2639349
2643674
2654416
2866857
3319521
4163437
4352097
4588364
5176177
5473124
5633616
5699373
5700350
5978953
5986622
6049632
6076425
6080396
6083704
6101156
6108179
6131261
6136233
6144690
6146500
6191997
6205122
6211204
6248990
6250508
6250542
6251448
6268976
6309820
6330080
6335171
6342836
6356525
6356945
6398787
6414401
6421553
6429104
6431897
6435145
6467803
6468204
6482668
6484277
6497907
6499260
6513126
6563024
6569464
6591014
6597045
6597302
6639550
6640682
6641373
6643108
6644060
6657068
6660107
6661144
6693233
6702634
6732200
6775380
6791591
6793423
6793520
6793821
6821506
6850856
6858849
6869302
6870100
6870445
6880507
6895761
7124958
7127979
7147892
7156036
7212477
7251470
7262610
7380482
7571305
23135106
25537101
36752103
53807103
60505104
67901108
146229109
458140100
464287234
518439104
532457108
552953101
594918104
824348106
835699307
842587107
872540109
874080104
892331307
902494103
949746101
969457100
12572Q105
20825C104
23703Q203
26614N102
26875P101
31620M106
40412C101
47215P106
55261F104
56585A102
62955J103
64110W102
65339F101
78442P106
82509L107
91324P102
92826C839
[NAME]
B01FLR7
B01JCK9
B01NPJ1
B02RK08
B031NN3
B037HR3
B03MS64
B03MV32
B03MYS8
B058TZ6
B05H328
B09M9L0
B0D0006
B0J7D91
B0R7JF1
B0XNCB0
B0Y91C1
B11Y3K8
B12LR51
B12LZT1
B132NM2
B19NLV4
B1DN3X6
B1V7L36
B1VJS64
B1VP0K0
B1WVF68
B1YBRG0
B2473N4
B24CGK7
B27WRM3
B29VFC4
B2B0DG9
B2NT8S1
B2QPJK5
B2RJYH8
B3NB1P2
B3QJ0H8
B44ZV94
B5VJH76
B61TVQ0
B627LW9
B63DLB5
B63QSB3
B64KR62
B679Q36
B7311V6
B80VKP3
B86S2N0
[NAME]
BD1RP61
BD4T6W7
BD5CG92
BD5CP62
BD6QWJ5
BF0WB74
BF13KN5
[NAME]
BFYQHF2
BFZ2PK0
BH0W286
BH3T8K8
BH4H6F2
BJ2ZH37
BJLWMG7
BJTM270
BKPQZT6
BKWGV13
BLGZ986
BM93SF4
BMCMVV5
BMMV2K8
BMTCVT6
BMVB566
BNG8PQ9
BP3R295
BP3R2F1
BP3R2T5
[NAME]
BP3R2Y0
BP3R4H7
BP3R4Q6
BP3R529
BP3R9B6
BP3RBG5
BP3RHC3
BP6MXD8
[NAME]
BQRRZ00
BSQCB24
BW9P816
BXRTT03
BYP9J68
BZ4F3Q2
G0250X107
G5494J103
Spreadsheet: 13812120-fff7-4242-8de7-d1f4de708941
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-29 09:17:18.520000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.379 | 102.254 | 102.129 | 101.754
4.5 | 101.452 | 101.327 | 101.202 | 100.827 |  | Note: | Refer To Price [NAME]
4.375 | 100.676 | 100.551 | 100.426 | 100.051 |  |  | For all Price Adjs
4.25 | 100.087 | 99.962 | 99.837 | 99.212
4.125 | 99.227 | 99.102 | 98.977 | 98.352
4 | 98.205 | 98.08 | 97.955 | 97.33
3.875 | 97.135 | 97.01 | 96.885 | 96.26
3.75 | 96.26 | 96.135 | 96.01 | 95.385
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.458 | 102.333 | 102.208 | 101.833
3.75 | 101.982 | 101.857 | 101.732 | 101.357
3.625 | 101.584 | 101.459 | 101.334 | 100.959
3.5 | 101.026 | 100.901 | 100.776 | 100.401
3.375 | 100.301 | 100.176 | 100.051 | 99.426
3.25 | 99.549 | 99.424 | 99.299 | 98.674
3.125 | 98.999 | 98.874 | 98.749 | 98.124 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-13 09:17:18.520000
30 DAY | 2014-05-28 09:17:18.520000
45 DAY | 2014-06-12 09:17:18.520000
60 DAY | 2014-06-27 09:17:18.520000
90 DAY | 2014-07-27 09:17:18.520000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 839246d1691766011-need-help-to-categorize-values-using-if-formula-depth
Sheet: Sheet1

 |  | Output
Length | Input | 0-1.5 | Qty | 1.5-3 | Qty | 3 & + | Qty
10 | 4.75
 |  | Condition for cell B3:
 |  | (1) If [NAME] is <1.5 then the formula may display the same value
 |  | (2) If [NAME] is >1.5 then the formula may display 1.5
 |  | Condition for cell [NAME]:
 |  | (1) If [NAME] is >1.5  or <3 then the formula may display [NAME]
 |  | (2) If [NAME] is >3 then the formula may display 1.5
 |  | Condition for cell D3:
 |  | (1) If [NAME] is >3  then the formula may display [NAME]
 |  | (2) If [NAME] is >3 then the formula may display 1.5
Spreadsheet: 105005d1302502718-populating-fields-by-using-only-the-month-name-number-dates
Sheet: Sheet1

 | 3 |  |  |  | 1 | JANUARY
 |  |  |  |  | 2 | FEBRUARY
 |  |  |  |  | 3 | [NAME]
 |  |  |  |  | 4 | APRIL
 |  |  |  |  | 5 | MAY
 |  |  |  |  | 6 | [NAME]
 |  |  |  |  | 7 | JULY
 |  |  |  |  | 8 | AUGUST
 |  |  |  |  | 9 | SEPTEMBER
 |  |  |  |  | 10 | OCTOBER
 |  |  |  |  | 11 | NOVEMBER
 |  |  |  |  | 12 | DECEMBER
Spreadsheet: 834515d1687880487-finding-the-closest-location-with-inventory-closest_location2-aligw
Sheet: Orders

 | destination
 | LocationID
 | 5268 | PartNumber | Closest Location with inventory | Quantity on Hand
 | 15124 | 6030632-00-A
 | 15124 | 6608642-96-F
 | 5268 | 6666498-00-C
 | 5268 | 6049890-00-B |  | Multiple matches
 | 5807 | 6509622-00-A
 | 5807 | 6495593-08-A
 | 5268 | 6060854-00-A
 | 5268 | 6628903-00-A
 | 5268 | 2007604-00-B
 | 5268 | 6009665-00-A
 | 11418 | 6008999-00-E |  | No match location
 | 11418 | 6027060-02-A |  | No match location
 | 11418 | 6046598-00-A |  | No match location
 | 11418 | 6530668-00-C |  | No match location
 | 11418 | 6009384-00-B |  | No match location
 | 5268 | 6006009-00-C
 | 5268 | 6066463-00-B
 | 5268 | 6006809-00-A
 | 5268 | 6008770-00-A
 | 5268 | 6450828-00-A |  | No other location with stock
Spreadsheet: 271025d1381785907-sum-adjacent-cell-to-a-reference-throughout-workbook-copy-of-xl0000040
Sheet: Output

Sheet | Item | Store | Artikel | Dept | Price
WE 5th Jan | Item 1 | Blackwoods | 1x ladder | 1C | 654.3
WE 5th Jan | Item 1 | Inverell Bearing Cente | 2x A84 v-belts | 1A | 19
WE 5th Jan | Item 1 | L&H | 1x box L36W/865 fluro tubes | 1B | 35.75
WE 5th Jan | Item 2 | Blackwoods | 1x box cutting discs | 1C | 49
WE 5th Jan | Item 2 | Inverell Bearing Cente | 2x 3525-4" t/lock | 1A | 38.99
WE 5th Jan | Item 2 | L&H | 1x box - phillips S10 starters | 1B | 13.7
WE 12th Jan | Item 1 | Blackwoods | 1x ladder | 1C | 654.3
WE 12th Jan | Item 1 | Inverell Bearing Cente | 2x A84 v-belts | 1A | 19
WE 12th Jan | Item 1 | L&H | 1x box L36W/865 fluro tubes | 1B | 35.75
WE 12th Jan | Item 2 | Blackwoods | 1x box cutting discs | 1C | 49
WE 12th Jan | Item 2 | Inverell Bearing Cente | 2x 3525-4" t/lock | 1A | 38.99
WE 12th Jan | Item 2 | L&H | 1x box - phillips S10 starters | 1B | 13.7
WE 12th Jan | Item 18 | Bindaree Stores | 15x racking shelves | 1B | 150000
WE 12th Jan | Item 19 | Bindaree Stores | test | 20H | 4260
WE 12th Jan | Freight (Price inc) | Inverell Bearing Cente |  | 21A | 8
WE 12th Jan | Freight (Price inc) | Bindaree Stores |  | 21A | 2500
Spreadsheet: 754434d1636173421-formulas-to-calculate-average-trips-per-month-log-book_gw
Sheet: Summary

 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00
Opening odometer
Closing odometer
Average trips per day
Average distance per day
Start date: | 2021-02-01 00:00:00 | <--- User entry
End date: | 2021-03-01 00:00:00 | <--- User entry
30 longest trips | Distance | Date/Time
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
Spreadsheet: 724990d1616490657-report-data-to-another-sheet-shifted-by-no-of-columns-copiare-altro-foglio
Sheet: Foglio2

 | 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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
AA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
BB |  |  |  |  |  |  |  | 95
Spreadsheet: 05a34cf0-2550-4907-a17b-afb215c996e9
Sheet: List

Agriculture & Forestry |  |  |  | Data Centers |  | [NAME] |  |  | Bath |  |  |  | Performance Based Electric
Commercial - Wholesale/Retail |  |  |  | Assembly |  | Con-Ed |  |  | Brooklyn Union Gas Co |  |  |  | Pre-Qualified
Education - Colleges & Universities |  |  |  | Grocery |  | LIPA |  |  | [NAME] |  |  |  | Energy Storage
Education - Elementary & Secondary Schools |  |  |  | Secondary School |  | NA |  |  | Con-Ed |  |  |  | Natural Gas
Energy Utilities & Producers |  |  |  | Auto |  | National Grid |  |  | Corning Natural Gas |  |  |  | Combined Heat and Power
Federal Government |  |  |  | Heavy Industrial |  | NYPA |  |  | Empire State Pipeline |  |  |  | Demand Response
Health Care |  |  |  | [NAME] |  | NYSEG |  |  | Filmore Gas |  |  |  | Industrial Process and Efficiency
Hospitality |  |  |  | Single Family Residential |  | Orange & Rockland |  |  | [NAME] |  |  |  | Monitoring-Based Commissioning (MBCx)
Industrial/Manufacturing |  |  |  | Big Box |  | Other |  |  | KEDNY
Local Government |  |  |  | Multifamily high-rise |  | RG&E |  |  | National Fuel
Mining - Oil, Gas, & Other |  |  |  | Community College |  | Village/Municipal |  |  | National Grid
Multifamily (over 4 units) |  |  |  | Industrial Refrigeration |  |  |  |  | NEA Cross of NY
Not For Profit |  |  |  | Multifamily low-rise |  |  |  |  | NYSEG
Office |  |  |  | Small Office |  |  |  |  | Orange & Rockland
Residential (1-4 family) & Private Individuals |  |  |  | Small Retail |  |  |  |  | Other
Services - Technical/Energy/Admin |  |  |  | Fast Food |  |  |  |  | Reserve
State Government |  |  |  | Large Office |  |  |  |  | RG&E
Undefined |  |  |  | Primary School |  |  |  |  | St. Lawrence Gas
 |  |  |  | University |  |  |  |  | Valley Energy
 |  |  |  | Full Service Restaurant |  |  |  |  | Woodhull Municipal
 |  |  |  | Light Industrial
 |  |  |  | Religious
 |  |  |  | Amusement, Social and Recreational Bldgs
 |  |  |  | 5+ Family Apartment Houses
 |  |  |  | 2-4 Family Houses
 |  |  |  | Capitols/Court Houses/City Halls
 |  |  |  | Dormitories
 |  |  |  | Gas Systems (Natural and Manufactured)
 |  |  |  | Hospitals and Other Health Treatment
 |  |  |  | Hotels and Motels
 |  |  |  | Houses of Worship
 |  |  |  | Laboratories (Manufacturer owned)
 |  |  |  | Libraries and [NAME]
 |  |  |  | Manufacturing and Processing Plants
 |  |  |  | Mixed Use
 |  |  |  | Miscellaneous Nonbuilding Construction
 |  |  |  | Miscellaneous Nonresidential Buildings
 |  |  |  | Office and Bank Buildings
 |  |  |  | One-family Houses
 |  |  |  | Other Government Service Buildings
 |  |  |  | Other Religious Buildings
 |  |  |  | [NAME] and Automotive Services
 |  |  |  | Schools and Colleges
 |  |  |  | Space Facilities
 |  |  |  | Stores and Restaurants
 |  |  |  | Warehouses (Excl. [NAME])
 |  |  |  | Water Supply Systems
Spreadsheet: 154006d1336147439-double-exponential-trendline-linestexample
Sheet: Sheet1

 | -1 | 1 | 10 |  |  |  | 10.04589547272721 | <-LINEST result.  Note that LINEST is an array function
 |  |  |  |  |  | LINEST inputs
Your equation |  |  | known_y's |  |  | ln(y) | ln(-EXP(-x)+1) |  |  | y's calculated using c from LINEST
0 | 0 |  | 0 |  |  |  |  |  |  | 0
1 | 0.01018589403201696 |  | 0.01 |  |  | -4.605170185988091 | -0.4586751453870819 |  |  | 0.00997371081166933 | -0.002628918833067102 | deviations from known_y's
2 | 0.2336024409784546 |  | 0.23 |  |  | -1.469675970058942 | -0.1454134578688591 |  |  | 0.2320486112351614 | 0.008907005370266698
3 | 0.6000802939755077 |  | 0.6 |  |  | -0.5108256237659907 | -0.0510691809427016 |  |  | 0.5986754462734546 | -0.002207589544242309
4 | 0.8312252447072269 |  | 0.83 |  |  | -0.1863295781914935 | -0.0184854468258866 |  |  | 0.830520333670489 | 0.0006269080367338466
5 | 0.9346272479320713 |  | 0.93 |  |  | -0.07257069283483537 | -0.006760749449488566 |  |  | 0.9343372894945993 | 0.004663752144730341
6 | 0.9754871480959169 |  | 0.98 |  |  | -0.02020270731751947 | -0.002481829368959546 |  |  | 0.9753760418215148 | -0.004718324671923627
7 | 0.9909185082911334 |  | 0.99 |  |  | -0.01005033585350145 | -0.0009122979828390252 |  |  | 0.9908770190577442 | 0.0008858778361052295
8 | 0.9966504332763343 |  | 1 |  |  | 0 | -0.0003355189080768247 |  |  | 0.9966350861749071 | -0.003364913825092852
9 | 0.9987665870827271 |  | 1 |  |  | 0 | -0.0001234174197030893 |  |  | 0.9987609297843514 | -0.001239070215648619
10 | 0.9995460934430596 |  | 1 |  |  | 0 | -4.54009603704951e-05 |  |  | 0.9995440106924958 | -0.0004559893075042343
 |  | known_y's are simply rounded values hand entered based on column 2
Spreadsheet: 59660d1260244105-league-spreadsheet-709588-league-spreadsheet-v2
Sheet: Setup

Setting up some parameters |  |  | data entry fields
Team List
1 | Blue |  | For each team name in this list, create a three line
2 | red_team |  | entry on the Teams Sheet
3 | yellow |  | When setting up team names, use _ instead of spaces.
4 | green |  | Team names will end up as range names and can not have blanks.
5 | purple
6 | orange
create new teams above this row. This will adjust the team list range name automatically.
check the correct range names. Hit F5 and select TeamList, then hit F5 and select Teams
Both names should light up the yellow rows and one below.
total number of teams |  | 6
total number of pairings per week |  | 3
Spot/handicap is |  | 0.8 | of the difference between two players' average score to date
Spreadsheet: 200748d1355753335-excel-route-planner-working-slooow-example
Sheet:      INPUT     

 | FISKCENTRALEN - XXXDAG XX/XX-XX
 | [NAME]!
 |  |  |  | [NAME]
 |  |  |  | TRYSIL | MANDAG/TORSDAG
 |  |  |  | FLISA | MANDAG/TORSDAG
 |  |  |  | GOL | MANDAG/ONSDAG/FREDAG
 |  |  |  | DOKKA | MANDAG/ONSDAG/FREDAG
 |  |  |  | LEIRA | MANDAG/ONSDAG/FREDAG
Spreadsheet: sara_shackleton__36634__ENA ECI ECTEF at 30 Nov 01
Sheet: ECI

Enron Credit Inc | company 1408 | at 30 Nov 01
Assets | $m |  | Liabilities |  | $m
ECT Investments (54A) - cash owed on trading losses | 5.3 |  | ECTRC (413) - non trade funding |  | -4.9
ECTEF Inc (1779) - cash owed on [NAME] transfer | 11.1 |  | Street - single name CDSs |  | -2.5
Street - single name & portfolio CDSs | 31.1 |  | ECL (1353) - margin cash lent | -41.7
ECL (1353) - cash owed on intercompany bond trading | 7.8 |  | ECL (1353) - trade funding | -7.9
Deutsche Bank - unpaid Triplets premium | 0.08 |  | ECL (1353) - single name & portfolio CDSs | -29.3
Cash at Bears | 10.5
Cash at Morgan Stanley | 0.165
Cash at Goldmans (estimated) | 2
Total |  |  | Total
 |  |  |  | $m
 |  |  | ECL is owed
Spreadsheet: 730172d1619588613-column-number-of-nth-text-book1-34-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | LEFT TO RIGHT | RIGHT TO LEFT |  |  | LEFT TO RIGHT | RIGHT TO LEFT
 | TEXT | TEXT | TEXT |  |  |  | TEXT |  | TEXT | TEXT | TEXT | 4 |  |  |  |  | 8 | 8
TEXT |  |  | TEXT |  |  |  |  |  |  |  | TEXT | 4 |  |  |  |  | NOT COUNT FOR | NOT COUNT FOR
 |  |  | TEXT | TEXT | TEXT | TEXT |  |  | TEXT | TEXT |  | 4 |  |  |  |  | 7 | 6
TEXT |  | TEXT |  |  |  |  | TEXT |  | TEXT | TEXT |  | 4 |  |  |  |  | 10 | 3
 |  | TEXT |  |  | TEXT | TEXT | TEXT | TEXT | TEXT | TEXT | TEXT | 4 |  |  |  |  | 8 | 9
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
WHAT FORMULA OF YELLOW RANGE, FROM [NAME] TO RIGHT/RIGHT TO LEFT, HOW MUCH TEXT DOES FOUR STORY NUMBER? IF COUNT SMALLER VALUE OF M COLUMN, "NOT COUNT FOR"
Spreadsheet: 876655d1723385126-replicate-data-from-one-file-to-another-jw-biometric-aug-2024
Sheet: Instructions

Attendnace Start Date | 2024-08-01 00:00:00
General Instructions
Keep this file as master file and create a file copy for each month
Change the date above in this sheet (Instructions) every month before updating the attendance
In Sheet, [NAME], do not delete any Columns. Instead enter attendance based on dates in that particular month
For New Joining, start attendance only from the date of joining
You can delete the names of those employees who are not employment
For New Joining, Collect EMP ID and Name from Admin-cum-HR and add it accordingly
Do not leave any gaps between Names
Always verify the summary sheet to make sure No of Days payable is right. Any Discrepency after data entry, please contact [NAME]-cum-HR. The Difference Column for each employee shall be 0
You can copy the Month and year in Column B, when a new employee has joined
How to Update Attendance
Instructions to Showrooms Only. AG,AS,AH
Full Day Present | P
Full Day Leave | LOP
Full Day Week Off | WO
Full DayPresent on Festival Holiday | PH
Half Day Present, Half Day Leave | 1/2P+1/2LOP
Half Day Present, Half Day Week Off | 1/2P+1/2WO
Half Day Present on Festival Holiday, Half Day Leave | 1/2PH+1/2LOP
Instructions to Offices Only, NOT APPLICABLE TO AH, AG AND AS
Full Day Present | P
Full Day Leave | LOP
Full Day Week Off | WO
Full DayPresent on Festival Holiday | PH
Half Day Present, Half Day Leave | 1/2P+1/2LOP
Half Day Present, Half Day Week Off | 1/2P+1/2WO
Half Day Present on Festival Holiday, Half Day Leave | 1/2PH+1/2GH
Office Closed on Festival Holiday | GH
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: cb

Curt. Sean |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 826711d1682186054-nested-if-to-pull-most-recent-dates-attendance-tracker-4-22-23-sample
Sheet: Occurrences

[NAME]
Associate: | [NAME], [NAME] |  | Date Prepared:
Total Points: |  | Level:
Last Accountability Issue Date: |  |  | Expiration Date:
 |  | 2023-08-03 00:00:00
Date | ID# | Employee ID | Associate Name | Occ. Type | WLB Hours | Age (Days old) | Points | Notes
2022-11-02 00:00:00 | 999999 |  |  | Absent - Failure to Report
2022-11-15 00:00:00 | 111115 |  |  | Absent - Failure to Report
2022-12-01 00:00:00 | 111111 |  |  | Absent - Failure to Report
2022-12-02 00:00:00 | 999999 |  |  | Absent - Failure to Report
2022-12-15 00:00:00 | 555555 |  |  | Early Quit - Worked LESS than 1/2 Scheduled Day
2022-12-15 00:00:00 | 111115 |  |  | Absent - Failure to Report
2023-01-01 00:00:00 | 111111 |  |  | Tardy
2023-01-15 00:00:00 | 777777 |  |  | WLBD | 2
2023-01-15 00:00:00 | 111115 |  |  | Absent
2023-01-17 00:00:00 | 777777 |  |  | WLBD2 | 2
2023-02-01 00:00:00 | 111111 |  |  | Tardy
2023-02-02 00:00:00 | 999999 |  |  | Absent
2023-02-03 00:00:00 | 111119 |  |  | Absent - Failure to Report
2023-02-04 00:00:00 | 111119 |  |  | Absent
2023-03-01 00:00:00 | 999999 |  |  | Absent
2023-03-01 00:00:00 | 777777 |  |  | Tardy
2023-03-20 00:00:00 | 111114 |  |  | WLBD | 6
2023-03-23 00:00:00 | 111111 |  |  | WLBD | 8
2023-03-29 00:00:00 | 111123 |  |  | WLBD | 8