tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842499d1694565811-get-all-id-values-for-looking-up-a-value-in-a-range-excel-2016-excelforum_vulturie
Sheet: Munka1

ID | Values | Looking for | Function | Expected
1 | 215-535-7, 287-477-0 | 287-477-0 |  | 1,8,10
2 | 64-17-5, 78-93-3, 67-63-0
3 | 64-17-5
4 | 1333-86-4
5 | 13463-67-7
6 | 13463-67-7
7 | 110-54-3, 108-88-3, 71-43-2
8 | 287-477-0, 200-857-2, 204-065-8, 200-827-9, 904-153-2
9 | 68478-92-2
10 | 691-647-3, 287-477-0, 204-065-8, 200-857-2, 200-827-9, 807-935-0
Spreadsheet: 89666d1289423472-vlookup-index-match-sample-1-
Sheet: Sheet2

RANK | 7 | 4 | 9 | 10 | 8 | 5 | 6 | 3 | 1 | 2
 | A | B | C | D | E | F | G | H | I | J
TOTAL | 100 | 150 | 50 | 25 | 80 | 120 | 115 | 160 | 500 | 260
Spreadsheet: 07d3d6b4-6183-4258-b32e-7f547a0b30ad
Sheet: Sheet1

System Support Planning Chart | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
List your responsibilities in this area that support your program | First Quarter | Second Quarter | Third Quarter | Fourth Quarter
Professional Development
In-service training (attending or facilitating
Memberships
Post-grad education
Consultation, Collaboration and Teaming
Consultation
Partnerships
Advisory council
Community outreach
Program Management and Operation
Management activities
Data analysis
Fair-share responsibilities
Spreadsheet: john_griffith__16162__1_28_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 170 | 185 | 49.4 | 53.8 | 0.65 | 2002-01-28 10:30:00
 | CL J2 | 20.5 | 270 | 285 | 46.7 | 49.4 | 0.62 | 2002-01-28 10:30:00
 | CL K2 | 20.5 | 348 | 360 | 46.2 | 47.8 | 0.61 | 2002-01-28 10:30:00
 | CL M2 | 20.5 | 395 | 410 | 45 | 46.7 | 0.59 | 2002-01-28 10:30:00
 | CL N2 | 20.5 | 435 | 450 | 43.7 | 45.2 | 0.57 | 2002-01-28 10:30:00
 | CL Q2 | 20.5 | 460 | 475 | 42.1 | 43.5 | 0.55 | 2002-01-28 10:30:00
 | CL U2 | 20.5 | 480 | 490 | 40.8 | 41.7 | 0.53 | 2002-01-28 10:30:00
 | [NAME] | 21 | 480 | 500 | 37 | 38.6 | 0.5 | 2002-01-28 10:30:00
 | CL X2 | 21 | 490 | 505 | 35.7 | 36.8 | 0.48 | 2002-01-28 10:30:00
 | [NAME] | 21 | 500 | 515 | 34.7 | 35.8 | 0.47 | 2002-01-28 10:30:00
 | CL F3 | 21 | 500 | 530 | 33.1 | 35.1 | 0.45 | 2002-01-28 10:30:00
 | CL G3 | 21 | 500 | 535 | 31.8 | 34.1 | 0.44 | 2002-01-28 10:30:00
 | CL M3 | 21 | 528 | 555 | 29.6 | 31.1 | 0.4 | 2002-01-28 10:30:00
 | CL Z3 | 21 | 530 | 560 | 25.9 | 27.3 | 0.35 | 2002-01-28 10:30:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 | 6315 | 6850 | 5183 | 4456
2 | 6177 | 6932 | 4957 | 4503
3 | 6080 | 6932 | 4785 | 4503
4 | 6061 | 6932 | 4586 | 4503
5 | 6044 | 6932 | 4752 | 4503
6 | 2913 | 6932 | 6134 | 4503
7 |  |  | 5239 | 4503
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  | -397510
2001-02-07 00:00:00
Spreadsheet: 144917d1331211603-if-search-text-average-value-product-book2
Sheet: Sheet1

Emerging Europe - A | AUD | 0.0001
Europe - C | CAD | 0.0002
Emerging Europe - B | AUD | 0
Europe (incl. ME) - C | AUD | 4.7e-05
Emering Asia - A | USD | 0
Emerging Asia -B | GBP | 0
Europe - A | DKK | 0
Europe - A | ZAR | 0.0001
Europe - A | AUD | 0.0001
Emerging Europe - C | CZK | 0.0002
Europe - B | CAD | 0
Emerging Europe (incl. ME) - C | USD | 4.7e-05
Asia - A | AUD | 0
Asia -B | ZAR | 0
Europe - A | CAD | 0
Europe - A | ZAR | 0.0001
Spreadsheet: 784742d1655929516-duplicates-in-rows-and-columns-duplicate-payments
Sheet: Sheet1

Issuer Subscriber Id |  | [NAME] | Exchange Subscriber Id | Received Date | Payment Date | Posting Date | Payment Mode | Reference # | Outlet [NAME] |  | Invoice # | Amount Paid | Posted By
[PHONE] |  | [NAME] | [PHONE] | 2022-05-18 00:00:00 | 2022-05-18 10:52:01.440000 | 2022-05-18 10:52:01.440000 | Credit Card | ************5574 | CGHC INDIVIDUAL MONTHLY PREMIUMS |  | 1411594 | 323.43
[PHONE] |  | [NAME] | [PHONE] | 2022-05-18 00:00:00 | 2022-05-18 10:52:20.333000 | 2022-05-18 10:52:20.333000 | Credit Card | ************5574 | CGHC INDIVIDUAL MONTHLY PREMIUMS |  |  | 323.43
[PHONE] |  | [NAME] | [PHONE] | 2022-05-02 00:00:00 | 2022-05-02 10:23:06.063000 | 2022-05-02 10:23:06.063000 | Credit Card | ************6429 | CGHC INDIVIDUAL MONTHLY PREMIUMS |  | 1303975, 1354783 | 130.22
[PHONE] |  | [NAME] | [PHONE] | 2022-05-25 00:00:00 | 2022-05-25 06:15:53.703000 | 2022-05-25 06:15:53.703000 | Credit Card | ************6429 | CGHC INDIVIDUAL MONTHLY PREMIUMS APC |  | 1404973 | 65.11
[PHONE] |  | [NAME] | [PHONE] | 2022-05-26 00:00:00 | 2022-05-26 11:48:11.047000 | 2022-05-26 11:48:11.047000 | Credit Card | ************1672 | CGHC INDIVIDUAL MONTHLY PREMIUMS |  | 1312704, 1363617, 1413914 | 405.48
[PHONE] |  | [NAME] | [PHONE] | 2022-05-26 00:00:00 | 2022-05-26 11:48:41.137000 | 2022-05-26 11:48:41.137000 | Credit Card | ************1672 | CGHC INDIVIDUAL MONTHLY PREMIUMS |  |  | 135.16
Spreadsheet: 585584d1533836198-median-if-with-subtotals-medianifsubtotal-bsb-
Sheet: Sheet1

 | Description | Classification | Season | Unit Sales |  |  | Spring
 | Necklace1 | Necklaces | Spring | 330
 | Necklace2 | Necklaces | Spring | 264 |  | Classification | Median Unit Sales (Unfiltered) | Median Unit Sales (Season Filtered to 'Spring')
 | Necklace3 | Necklaces | Spring | 259 |  | Necklaces
 | Necklace4 | Necklaces | Summer | 293 |  | Bracelets
 | Necklace5 | Necklaces | Summer | 354 |  | Rings
 | Necklace6 | Necklaces | Summer | 344
 | Necklace7 | Necklaces | Fall | 357 |  | formula in H3: =MEDIAN(IF($C$3:$C$32=$G3,$E$3:$E$32))
 | Necklace8 | Necklaces | Fall | 295
 | Necklace9 | Necklaces | Holiday | 391
 | Necklace10 | Necklaces | Holiday | 263
 | Bracelet1 | Bracelets | Spring | 270
 | Bracelet2 | Bracelets | Spring | 397
 | Bracelet3 | Bracelets | Spring | 393
 | Bracelet4 | Bracelets | Summer | 364
 | Bracelet5 | Bracelets | Summer | 273
 | Bracelet6 | Bracelets | Summer | 211
 | Bracelet7 | Bracelets | Fall | 344
 | Bracelet8 | Bracelets | Fall | 319
 | Bracelet9 | Bracelets | Holiday | 396
 | Bracelet10 | Bracelets | Holiday | 211
 | Ring1 | Rings | Spring | 249
 | Ring2 | Rings | Spring | 351
 | Ring3 | Rings | Spring | 228
 | Ring4 | Rings | Summer | 284
 | Ring5 | Rings | Summer | 211
 | Ring6 | Rings | Summer | 278
 | Ring7 | Rings | Fall | 248
 | Ring8 | Rings | Fall | 352
 | Ring9 | Rings | Holiday | 252
 | Ring10 | Rings | Holiday | 264
Spreadsheet: 849868d1700237612-finding-unique-data-unique-list-1-
Sheet: Sheet1

From the list below I want to be ablue to total value by client and by assignment, but then more specifically highlight the client where it only has one assignment associated to it, for example, PQR only has Education.
The idea is that I'm able to identify a client that is only engaged to complete one type of assignment and not a mixture of assignments.
Client | Assignment | Value |  | Client | Assignment | Count of Categories |  | Client | Sum
ABC | Crafting | 5 |  | PQR | Education | 1 |  | ABC | 75
ABC | Projects | 10 |  |  |  |  |  | DEF | 60
ABC | [NAME] | 15 |  |  |  |  |  | GHI | 75
ABC | Education | 20 |  |  |  |  |  | JKL | 50
ABC | Education | 25 |  |  |  |  |  | MNO | 55
DEF | Crafting | 30 |  |  |  |  |  | PQR | 110
DEF | Projects | 5 |  |  |  |  |  | STU | 45
DEF | [NAME] | 10 |  |  |  |  |  | VWX | 165
DEF | Education | 15
GHI | Education | 20
GHI | Crafting | 25
GHI | Projects | 30
JKL | [NAME] | 5
JKL | Education | 10
JKL | Education | 15
JKL | Crafting | 20
MNO | Projects | 25
MNO | [NAME] | 30
PQR | Education | 5
PQR | Education | 10
PQR | Education | 15
PQR | Education | 20
PQR | Education | 25
PQR | Education | 30
PQR | Education | 5
STU | Education | 10
STU | Crafting | 15
STU | Projects | 20
VWX | [NAME] | 25
VWX | Education | 30
VWX | Education | 5
VWX | Crafting | 10
VWX | Projects | 15
VWX | [NAME] | 20
VWX | Education | 25
VWX | Education | 30
VWX | Crafting | 5
Spreadsheet: kate_symes__18076__Deal Correction 11-17
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | 2000-11-16 00:00:00 | STCA | APB | Houston | APB | Added Missing Deal | No broker notification | 461029 | SP15 | 11/20-11/30 | OP | 25 | 115 | [NAME]
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | 2000-11-16 00:00:00 | STCA | APB | Houston | APB | Added Missing Deal | No broker notification | 461030 | SP15 | 11/20-11/30 | OP | 25 | 114.95 | EES
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | 2000-11-16 00:00:00 | STCA | APB | Houston | APB | Added Missing Deal | No broker notification | 461801 | SP15 | 11/20-11/30 | OP | 25 | 115 | Mieco
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | 2000-11-16 00:00:00 | STCA | APB | Houston | APB | Added Missing Deal | No broker notification | 461802 | SP15 | 11/20-11/30 | OP | 25 | 114.95 | EES
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | 2000-11-20 00:00:00 | STCA | JR | Houston | APB | Changed Delivery Point from NP15 to SP15 | Trader error | 461487 | SP15 | 2000-11-20 00:00:00 | P | 75 | 165 | PG&E
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | 2000-11-20 00:00:00 | STCA | JR | Houston | APB | Changed Delivery Point from NP15 to SP15 | Trader error | 461488 | SP15 | 2000-11-20 00:00:00 | P | 25 | 165 | PG&E
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | Z-00 | STSW | MF | Houston | APB | [NAME] from Prebon to APB | Trader error | 461972 | PV | Z-00 | P | 50 | 100 | [NAME]
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | BOM | STCA | KS | Houston | APB | Changed counterparty from TransCanada to TransAlta | KS | 462105 | Mid C | BOM | P | 25 | 190 | Transalta
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | F-01 | LTNW | MS | Houston | No Bro | From Peak to Off Peak | Trader error | 458642 | Mid C | F-01 | OP | 20 | 92.45 | Seattle City Light
 | 2000-11-17 00:00:00 | 2000-11-17 00:00:00 | Z-00 | LTNW | Natsour | Houston | Natsource | From 25 MW to 50 MW | Broker error | 461136 | Mid C | Z-00 | OP | 50 | 106 | BPA
Spreadsheet: 270622d1381556260-yet-another-text-to-value-issue-another-convert-number-in-text-to-value
Sheet: Sheet1

[PHONE]
16546
61074
18279
18270
17732
18073
12039
18444
21938220
60755
17887
18080
17275
61082
17381
17520
17385
9999999
61274
17982
[PHONE]
16628
18170
16584
5851
18180
16522
17997
17497
17513
17697
18489
16037
18586
18034
14450
61977
6493
17898
16964
61750
61131
18685
18276
17715
18196
61269
18461
61515
18302
18019
61505
61506
61340
60883
18353
18297
16586
032576753
310941646
18438
17603
61411
18309
61721
61711
18761
6088
61939
18687
12570
17063
11251
17126
17158
18466
18356
301353918
317844330
61923
18621
18620
61916
18661
18622
18634
18671
18662
18659
18655
18792
45
18768
17158
15778
61922
18612
70
18619
61945
18638
61931
18664
18676
18686
18711
Spreadsheet: 100659d1298965447-conditional-formatting-with-multiple-rows-dummy_breathtest-editted-
Sheet: Sheet1

Breath Test Register
DATE | NAME | GUARD | READING | COMMENT
2010-08-06 00:00:00 | A Person | Guard 12 | PASS
2010-08-06 00:00:00 | Someone Else | Guard 14 | FAIL
2010-08-06 00:00:00 | [NAME] | Guard 2 | PASS
2010-08-06 00:00:00 | Mr Man | Guard 7 | PASS
2010-08-06 00:00:00 | [NAME] | Guard 9 | FAIL
2010-08-06 00:00:00 | [NAME] | Guard 18 | PASS
2010-08-06 00:00:00 | T Ruckdriver | Guard 10 | PASS
2010-08-06 00:00:00 | Someone Else | Guard 14 | FAIL | More Than Once
Spreadsheet: 745661d1630082920-sumproduct-addition-using-wildcards-book2
Sheet: Sheet1

 |  |  |  | 2021-07-24 00:00:00
 |  |  |  | 5 | Data Acquisition - Steep
Data Acquisition - Steep Creek |  | <- wildcard doesn't work |  | 8 | Data Acquisition - Steep Creek | 5 | Data Acquisition - Steep Creek
 |  | <- no wildcard does work |  | 10 | Data Acquisition - Clearwater | 6 | Data Acquisition - Steep Creek
 |  |  |  | 5 | Data Acquisition - Clearwater | 7 | Data Acquisition - Clearwater
 |  |  |  | 6 | Data Acquisition - Steep Creek | 8 | Data Acquisition - Steep Creek
 |  |  |  |  |  | 9 | Data Acquisition - Steep Creek
Spreadsheet: 37129617-f9ea-4169-a9ca-769950a1a286
Sheet: Sheet1

Student Teaching Program
68 Student Teacher Candidates
8 Withdrew
1 Denied
59 Candidates Accepted
0 Post Bac ST
5 C & I Masters
54 Undergraduate
59 Student Teaching
30 [NAME] | 0.51
13 EC-6 w SPED
17 EC-6 GEN (1 is GRAD ST)
23 Secondary: | 0.39
1 8-12 MATH
12 8-12 HIST (2 are GRAD ST)
6  8-12 ENG (2 are GRAD ST)
1 8-12 BIO
1 8-12 CHEM
2 6-12 AG
2  4-8: | 0.03
2 GEN
4 ALL LEVEL: | 0.07
2 ART
2 THEATER
32 Placed in SAISD | 0.54
27 Placed Outside of SAISD | 0.46
17 Remote Placements with $600 Fee
59 Students: 89 Placements in 25 Districts on 41 Campuses
18 University Supervisors
Field Experience Program
248 Students: 497 Placements in 12 Districts on 30 Campuses
Spreadsheet: 865381d1712414320-scheduling-rules-help-excelforum-help-file
Sheet: APR

Month: | Year:
APR | 2024 | CALLS | Off Request | Employees
Day | Date
Monday | 2024-04-01 00:00:00 |  | CC, BB | AA |  |  |  | Conditions for Column C
Tuesday | 2024-04-02 00:00:00 |  | CC, BB | BB |  |  |  | 1. Employees to be allocated are in Column E
Wednesday | 2024-04-03 00:00:00 |  | CC, BB | CC |  |  |  | 2. All employees to be allocated equal number of shifts
Thursday | 2024-04-04 00:00:00 |  | CC | DD |  |  |  | 3. All employees to be allocated equal number of weekend shifts (Saturday and Sunday).
Friday | 2024-04-05 00:00:00 |  | CC | EE |  |  |  | 4. The shifts should be in blocks of upto 7 shifts, preferably 2 blocks every 4 months
Saturday | 2024-04-06 00:00:00 |  | CC | FF |  |  |  | 5. Avoid allocating employees on their requested days off (Column D)
Sunday | 2024-04-07 00:00:00 |  | CC | GG
Monday | 2024-04-08 00:00:00 |  |  | HH
Tuesday | 2024-04-09 00:00:00 |  |  | II
Wednesday | 2024-04-10 00:00:00 |  |  | JJ
Thursday | 2024-04-11 00:00:00
Friday | 2024-04-12 00:00:00
Saturday | 2024-04-13 00:00:00 |  | JJ
Sunday | 2024-04-14 00:00:00 |  | JJ
Monday | 2024-04-15 00:00:00 |  | JJ,FF, HH
Tuesday | 2024-04-16 00:00:00 |  | JJ,FF, HH
Wednesday | 2024-04-17 00:00:00 |  | JJ,FF, HH
Thursday | 2024-04-18 00:00:00 |  | JJ,EE
Friday | 2024-04-19 00:00:00 |  | JJ,EE
Saturday | 2024-04-20 00:00:00 |  | JJ,EE
Sunday | 2024-04-21 00:00:00 |  | JJ,EE
Monday | 2024-04-22 00:00:00
Tuesday | 2024-04-23 00:00:00
Wednesday | 2024-04-24 00:00:00
Thursday | 2024-04-25 00:00:00 |  | AA
Friday | 2024-04-26 00:00:00 |  | AA
Saturday | 2024-04-27 00:00:00 |  | AA
Sunday | 2024-04-28 00:00:00 |  | AA
Monday | 2024-04-29 00:00:00
Tuesday | 2024-04-30 00:00:00
Spreadsheet: 698357d1601944842-how-to-create-a-vlookup-from-different-sources-vlookup
Sheet: Mail Merge

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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65
BIL | Tingkatan | NAMA | NO MY KAD | NO SIJIL LAHIR | IMK |  |  |  |  |  | TIGA MATA HOLLAND | Index Perbezaan | KOD | VERBAL LINGUISTIK BM | VERBAL LINGUISTIK BI | LOGIK MATEMATIK | VISUAL RUANG | MUZIK | NATURALIS | INTRA PERSONAL | INTER PERSONAL | KINESTATIK | EKSISTENSIAL | ASNK |  | BA |  | BI |  | BM |  | BT |  | GEO |  | KAQ |  | M3 |  | PI |  | PJK |  | PM |  | PSV |  | RBT |  | SEJ |  | SN |  | x |  | x |  | JUM MARKAH | PERATUS | GPC | MENGUASAI / TIDAK MENGUASAI | KDK | KDT | PENCAPAIAN | ITP |  |  | MATAPELAJARAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 1 | 2 | 3 | 4 | 5 | 6
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
Spreadsheet: 716420d1612201031-do-sum-at-a-time-when-selecting-whole-column-name
Sheet: Before

 | NAME | VALUE | Total
 | FG | 45
 | BF | 12
 | VB | 89
 | RT | 23
 | FG | 89
 | RT | 54
 | [NAME] | 12
 | BN | 22
 | MK | 65
 | E | 89
 | RT | 54
 | YU | 12
 | VN | 45
Spreadsheet: 8ad872d9-52a8-4e34-bc01-503bedd0bd94
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-06-24 09:24:30.400000
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.836 | 102.711 | 102.586 | 102.211
4.5 | 102.803 | 102.678 | 102.553 | 102.178 |  | Note: | Refer To Price [NAME]
4.375 | 101.951 | 101.826 | 101.701 | 101.326 |  |  | For all Price Adjs
4.25 | 101.346 | 101.221 | 101.096 | 100.471
4.125 | 100.499 | 100.374 | 100.249 | 99.624
4 | 99.496 | 99.371 | 99.246 | 98.621
3.875 | 98.453 | 98.328 | 98.203 | 97.578
3.75 | 97.578 | 97.453 | 97.328 | 96.703
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.757 | 102.632 | 102.507 | 102.132
3.625 | 102.363 | 102.238 | 102.113 | 101.738
3.5 | 101.81 | 101.685 | 101.56 | 101.185
3.375 | 101.09 | 100.965 | 100.84 | 100.465
3.25 | 100.393 | 100.268 | 100.143 | 99.518
3.125 | 99.956 | 99.831 | 99.706 | 99.081
3 | 99.206 | 99.081 | 98.956 | 98.331 |  | 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-07-08 09:24:30.400000
30 DAY | 2014-07-23 09:24:30.400000
45 DAY | 2014-08-07 09:24:30.400000
60 DAY | 2014-08-22 09:24:30.400000
90 DAY | 2014-09-21 09:24:30.400000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 829429d1684225444-need-to-sum-next-non-zero-number-in-column-sampl-workbook
Sheet: Sheet1

2023-05-08 00:00:00
2023-05-05 00:00:00
2023-05-04 00:00:00
False
2023-05-01 00:00:00
False
2023-04-26 00:00:00
False
2023-04-24 00:00:00
2023-04-21 00:00:00
2023-04-20 00:00:00
Spreadsheet: 798862d1664791275-rank-with-multiple-criteria-for-equal-values-league-data-2-
Sheet: Sheet1

 |  | 2022-07-26 00:00:00
No. | Name | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W1P | W2P | W3P | W4P | W5P | W6P | W7P | W8P | W9P | W10P | W11P | W12P | W13P | Points | Helper | Rank | Weeks | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Player 1 | 10 |  | 10 | 7 | 6 | 1 | 4 | 3 | 7 | 3
 | Player 2 | 3 | 4 | 6 | 3 | 7 |  | 3 | 10 | 9 | 4
 | Player 3 | 1 | 1 | 8 | 3 | 8 |  |  | 9 | 4 | 6
 | Player 4
 | Player 5
 | Player 6
 | Player 7
 | Player 8
 | Player 9
 | Player 10
 | Player 11
 | Player 12
 | Player 13
Spreadsheet: 672435d1586870876-work-hours-calculation-with-break-deduction-hours-test
Sheet: Schedule

 | Shift | Shift | Actual | Paid |  |  | Shift | Shift | Actual | Paid
 | Start | Finish | Hours | Hours |  |  | Start | Finish | Hours | Hours
 | 07:30:00 | 16:00:00 |  |  |  |  | 08:00:00 | 13:00:00
Spreadsheet: 808917d1670763354-finding-average-for-last-5-10-games-closing-line-76ers
Sheet: Sheet1

Team = 76ers
Looking for formula to see when the 76ers are favorite or Underdog in the last 5 and 10 games, what the average closing line is
Favourite or Underdog | Closing Line
d | 2.5
d | 5
f | -13.5
f | -12.5
d | 1
d | 2.5
f | -2.5
f | -2.5
f | -5.5
f | -1
d | 1.5
d | 1
f | -2.5
f | -3.5
d | 1
d | 3.5
d | 7.5
d | 4
d | 1.5
f | -1
f | -2.5
d | 4
d | 4.5
f | -7.5
f | -5
#N/A | #N/A
Average Line Last 5 games 76ers were Favorites |  | <<<looking for formula
Average Line Last 5 games 76ers were Underdogs |  | <<<looking for formula
Average Line Last 5 games 76ers were Favorites |  | <<<looking for formula
Average Line Last 5 games 76ers were Underdogs |  | <<<looking for formula