tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75250d1275835945-excel-2007-circular-reference-develop-a-tournament-revisionjune2010
Sheet: Matches

Winner | Winner As | Winner Points | [NAME] | Loser As | [NAME] | Tournament Name | Date | Match ID | Win Rank | [NAME] | [NAME] | Win Floor | Win Value | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Match Value | Track ID
Spreadsheet: 51817d1251409111-convert-table-into-three-columns-forum-example
Sheet: Sheet1

Input:
Vendor [NAME] (stock/product #) | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5 | 9 | 9.5 | 10 | 10.5
Blue | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | N
Green | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | N
Red | N | Y | N | Y | Y | Y | Y | Y | Y | N | Y | N
Yellow | N | Y | Y | Y | Y | Y | Y | Y | Y | N | N | N
White | N | Y | Y | Y | Y | Y | N | Y | Y | N | Y | N
[NAME] | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | N
Orange | N | Y | Y | N | Y | Y | Y | Y | Y | N | Y | N
Purple | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | N
Pink | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | N
Desired output:
Blue | 5 | N
Blue | 5.5 | Y
Blue | 6 | Y
Blue | 6.5 | Y
Blue | 7 | Y
Blue | 7.5 | Y
Blue | 8 | Y
Blue | 8.5 | Y
Blue | 9 | Y
Blue | 9.5 | N
Blue | 10 | Y
Blue | 10.5 | N
Green | 5 | N
Green | 5.5 | Y
Green | 6 | Y
Green | 6.5 | Y
Green | 7 | Y
Green | 7.5 | Y
Green | 8 | Y
Green | 8.5 | Y
Green | 9 | Y
Green | 9.5 | N
Green | 10 | Y
Green | 10.5 | N
Red | 5 | N
Red | 5.5 | Y
Red | 6 | N
Red | 6.5 | Y
Red | 7 | Y
Red | 7.5 | Y
Red | 8 | Y
Red | 8.5 | Y
Red | 9 | Y
Red | 9.5 | N
Red | 10 | Y
Red | 10.5 | N
Spreadsheet: 329018d1404161920-look-for-the-content-of-last-non-empty-cell-in-a-range-and-provide-a-specific-value-example2
Sheet: Sheet1

 |  | abc |  |  |  |  | Step #1
 |  | abc | abc |  |  |  | Step #2
 |  | abc | acb | abc |  |  | Step #3
 |  | abc | abc | abc | abc |  | Step #4
 |  | abc | abc | abc | abc |  | Step #4
 |  | abc | acb | abc |  |  | Step #3
 |  | abc | abc |  |  |  | Step #2
 |  | abc |  |  |  |  | Step #1
 |  | ↑ data |  |  |  | ↑Formula results | ↑Expected result
Spreadsheet: 768785d1645118840-automatically-import-from-large-data-to-another-tab-based-on-dropdown-menu-material-comparison
Sheet: Sheet2

 | ASA | Nylon 12 | PC | Ultem 1010 | Ultem 9085 | Nylon 12 CF | ABS CF10 | ABS M30 | ASA | [NAME] | PC-ABS | PLA | TPU | Loctite 3172 | Loctite 3843 | [NAME] 500 | Loctite MED412 | Loctite MED413 | Loctite 3955 | Loctite IND402 | Loctite IND403 | Loctite IND405 | [NAME] 56 | BASF EL150 | BASF ST45
Tensile Yield (MPa) | 32.8 | 49.3 | 57.9 | 80 | 69.2 | 83.5 | 37.7 | 30.8 | 32.8 | 45 | 36.5 | 45 | 15.6 | 34 | 53 | 12 | 33 | 46 | 66.7 | 5.5 | 72 | 43 | 44.1
Tensile Ultimate (MPa) | 31.9 | 33.4 | 57.3 | 79.2 | 68.1 | 83.5 | 37.7 | 28.1 | 31.9 | 40 | 34.7 | 48 | 16.8 | 39 | 51 | 20.4 | 37 | 44 | 65.5 | 5.5 | 32 | 42 | 42.2 | 6 | 62
[NAME] (MPa) | 2140 | 1510 | 2250 | 3040 | 2520 | 9460 | 3.342 | 2400 | 2140 | 1690 | 1990 | 3039 | 15.3 | 1494 | 1806 | 465 | 1305 | 1673 | 3556 | 42 | 2572 | 1500 | 1595 | 25 | 2300
Elongation @Break (%) | 5.9 | 30 | 5.2 | 4 | 5.4 | 2.4 | 2.7 | 8.1 | 5.9 | 12 | 4.7 | 2.5 | 552 | 105 | 43 | 42 | 110 | 51 | 2.1 | 230 | 10 | 120 | 78 | 150 | 25
Elongation @Yield (%) | 2.5 | 6.1 | 4.9 | 3.8 | 5.4 | 2.4 | 2.7 | 1.8 | 2.5 | 4.26 | 3 | 1.5 | 466 |  |  | 5
Flexural Strength (MPa) | 61.5 | 56.5 | 90 | 128 | 104 | 153 | 69 | 58.7 | 61.5 | 60 | 61.9 | 84 | 1.8 |  |  | 15.9 |  |  |  |  |  |  |  |  | 109
Flexural Modulus (MPa) | 1980 | 1260 | 2150 | 2910 | 2400 | 11100 | 3760 | 2220 | 1980 | 1850 | 1860 | 2930 | 25.6 |  | 1783 | 408 | 869 | 1598 | 4643 |  | 2654 |  |  |  | 2430
Compression Yield (MPa) | 75.4 | 327 | 244 | 248 | 139 | 110 | 73.2 | 88.3 | 75.4 | 75 | 96.5 |  | 2.6
Compression Modulus (MPa) | 2050 | 1480 | 1950 | 2930 | 2220 | 6780 | 2129 | 2200 | 2050 | 1540 | 2140
Izod Impact - Notched (J/m) | 43.1 | 138 | 76.8 | 26.6 | 88.5 | 106 | 51.4 | 101 | 43.1 | 380 | 241 | 27 |  | 73 | 53 | 70 | 50 | 59 | 23 |  | 27 | 50 | 55 |  | 20.2
Izod Impact - Unnotched (J/m) | 285 | 1800 | 761 | 260 | 647 | 346 | 212 | 291 | 285 | 1415 | 655 | 192 |  |  |  |  |  |  |  |  |  | 1500
Spreadsheet: 183312d1348774249-transpose-a-negative-number-to-positive-book3
Sheet: Sheet1

October
 | St | [NAME] | lb's | Kg
2012-10-01 00:00:00
2012-10-07 00:00:00
2012-10-13 00:00:00
2012-10-19 00:00:00
2012-10-25 00:00:00
LOST
Spreadsheet: 709898d1608620638-fill-in-attendance-sheet-automatically-from-list-demo-file
Sheet: Master Table

 | Date | Special Number | FIRSTNAME | LASTNAME | Grade | Attended | Licence Class | ID Shown | Remarks
 | 2020-03-02 00:00:00 | 10113809 | A | B | C | D | E | F
 | 2020-03-02 00:00:00 | 10112578
 | 2020-03-02 00:00:00 | 10113981
 | 2020-03-02 00:00:00 | 10114515
 | 2020-03-02 00:00:00 | 10117107
 | 2020-03-02 00:00:00 | 10117653
 | 2020-03-02 00:00:00 | 10550087
 | 2020-03-02 00:00:00 | 10116445
 | 2020-03-02 00:00:00 | 10112675
 | 2020-03-02 00:00:00 | 10114374
 | 2020-03-02 00:00:00 | 10609754
 | 2020-03-02 00:00:00 | 10112700
 | 2020-03-04 00:00:00 | 10117653
 | 2020-03-04 00:00:00 | 10118374
 | 2020-03-04 00:00:00 | 10117034
 | 2020-03-04 00:00:00 | 10503439
 | 2020-03-04 00:00:00 | 10113621
 | 2020-03-04 00:00:00 | 10113921
 | 2020-03-04 00:00:00 | 10115944
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2021-01-18 00:00:00 | 10113809
 | 2021-01-18 00:00:00 | 10112578
 | 2021-01-18 00:00:00 | 10113981
 | 2021-01-18 00:00:00 | 10114515
 | 2021-01-18 00:00:00 | 10117107
 | 2021-01-18 00:00:00 | 10117653
 | 2021-01-18 00:00:00 | 10550087
 | 2021-01-18 00:00:00 | 10116445
 | 2021-01-18 00:00:00 | 10112675
 | 2021-01-18 00:00:00 | 10114374
 | 2021-01-18 00:00:00 | 10609754
 | 2021-01-18 00:00:00 | 10112700
Spreadsheet: 124490d1318442377-autofilter-test-1
Sheet: P1 - Jan 1 - Jan 10

 |  | Pay Period 1 - January 1, 2012 to January 10, 2012
SENIORITY | EMPLOYEE | STAT +  Over Time  @  ½ Time ACCT# | Over Time  @  Straight Time -  ACCT# | Over Time  @  1½ Time ACCT# | Over Time + Acting Time @  1½ + $Acting Pay ACCT# | Acting Time @  $ Acting Pay ACCT# | STAT +  Acting Time @  $ Acting Pay ACCT# | Tech Pay  @  1.5 -  ACCT# | Acting Tech Pay  @  $ -  ACCT#
111 | Employee 1 |  |  |  |  |  |  | 10 | 0
112 | Employee 2 |  | 10 |  |  |  |  | 0 | 0
113 | Employee 3 |  |  | 10 |  |  |  | 0 | 0
114 | Employee 4 | 10 |  |  | 10 |  |  | 0 | 0
115 | Employee 5 | 10 |  |  |  |  |  | 0 | 0
116 | Employee 6 |  |  |  |  |  |  | 0 | 0
117 | Employee 7 |  | 10 |  |  | 10 |  | 0 | 0
118 | Employee 8 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0
119 | Employee 9 | 10 | 0 | 0 | 0 | 0 | 10 | 0 | 0
120 | Employee 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121 | Employee 11 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
122 | Employee 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
123 | Employee 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
124 | Employee 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
125 | Employee 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
126 | Employee 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 650 | 589
2 | 625 | 589
3 | 616 | 589
4 | 599 | 589
5 | 595 | 589
6 | 616 | 589
7 | 629 | 589
8 | 662 | 589
9 | 681 | 589
10 | 701 | 589
11 | 641 | 589
12 | 646 | 589
13 | 533 | 589
14 | 549 | 589
15 | 693 | 589
16 | 586 | 589
17 | 47 | 589
18 |  | 589
19 | 1 | 589
20 | 8 | 589
21 | 505 | 589
22 | 555 | 589
23 | 503 | 589
24 | 378 | 589
25 | 88 | 589
26 | 163 | 589
27 | 218 | 589
28 | 67 | 589
29 | 36 | 589
30 | 95 | 589
31 | 98 | 589
2001-11-30 00:00:00 |  |  | 148916.73
2001-12-31 00:00:00
CBS Volume
 |  |  | 28495
Spreadsheet: 754871d1636550603-counting-rows-based-on-a-value-counting-rows
Sheet: Sheet1

Temperature | Target
15.1 | 0
22.5 | 0
29.9 | 0
37.3 | 0
44.7 | 65.1
52.1 | 65.1
59.5 | 65.1
66.9 | 65.1
74.3 | 65.1
Spreadsheet: 67301d1267904545-sumproduct-salary-calculator
Sheet: Sheet1

 | Location | Total
 | Illinois | 161.85 |  | The formula in C2 needs to reflect what is typed in cell B2, and then goes to the table below in rows 8-14, and sums up all the hours/hourly rate
Location | Name | [NAME] | Hours
Illinois | [NAME] | 10.5 | 4
Illinois | [NAME] | 10.95 | 3
Ohio | [NAME] | 11.5 | 5
Florida | [NAME] | 12.43 | 4
Illinois | [NAME] | 14.5 | 6
Ohio | [NAME] | 12.87 | 5
Spreadsheet: 148395d1333386876-file-to-automatically-update-payments-on-a-loan-book4
Sheet: Sheet1

Balance Due: |  |  | Cost:
Payment# | Date | Amount
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
Spreadsheet: 325723d1402944995-conditional-formatting-across-multiple-spreadsheets-test
Sheet: 06-14

 |  | 2014-06-14 00:00:00
 | Name: | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | Tot Hrs
1 | Emp 1 |  |  |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 11:00:00 | 16:30:00
 | Emp 2 | 08:00:00 | 15:00:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  |  |  |  | 08:00:00 | 16:30:00
 | Emp 3 |  |  |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00
 | Emp 4 |  |  |  | 08:00:00 | 18:30:00 |  | 09:00:00 | 15:30:00 |  | 09:00:00 | 17:00:00 |  | 09:00:00 | 17:00:00 |  | 09:00:00 | 13:00:00
 | Emp 5 |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00
 | Emp 6 | 08:00:00 | 15:00:00 |  | 09:00:00 | 17:30:00 |  | 09:00:00 | 17:30:00 |  | 09:00:00 | 17:30:00 |  |  |  |  | 09:00:00 | 17:30:00
 | Emp 7 |  |  |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00 |  | 08:00:00 | 16:30:00
Spreadsheet: 839017d1691593804-how-can-i-not-display-some-information-when-a-cell-is-blank-file-numbers
Sheet: Sheet1

AQU |  |  | AD | 01 | Ad | Facebook Ad Block | Hiring Lifeguards, Ft. Gatlin & Kelly Park
AQU |  |  | BN | 01 | [NAME] | Lifeguard Job Fair | [NAME]
AQU |  |  | BN | 01 | [NAME] | Lifeguards Wanted | [NAME]
ATH | ABB |  | FL | 01 | [NAME] | Adult Basketball League | [NAME]
ATH | ABB |  | TS | 01 | T-shirt | Adult Basketball Champion
ATH | JRM | 23 | BK | 02 | Cover | Rule book cover art
ATH | JRM | 23 | BN | 01 | [NAME] | Now [NAME] | South Econ Recreation Center
ATH | JRM | 23 | FL | 01 | [NAME] | Leagues | Output pages to pdfs for individual parks
ATH | JRM | 23 | FL | 01 | [NAME] | Clinics | Based on FL01, pages to pdfs for individual parks
Spreadsheet: 598506d1542553852-inventory-aging-fifo-inventory-age
Sheet: Sheet2

 |  |  |  |  |  | [NAME]
 |  | Buffer In | Buffer Out | Daily Buffer Amount |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-3 Days | 4 - 11 Days | 12 - 17 Days | 18+ Days
 | 2017-10-15 00:00:00 | 0 | 0
 | 2017-10-16 00:00:00 | 414 | -22
 | 2017-10-17 00:00:00 | 270 | -100 |  |  |  | 392
 | 2017-10-18 00:00:00 | 395 | -33
 | 2017-10-19 00:00:00 | 191 | -191
 | 2017-10-20 00:00:00 | 0 | 0
 | 2017-10-21 00:00:00 | 0 | 0 |  |  |  | 0
Spreadsheet: 721298d1614631358-index-match-increase-column-reference-by-1-as-formula-extended-index-match-example
Sheet: Sheet1

NAME | transport | weight | location | food | height
[NAME]
[NAME]
Todd
[NAME]
[NAME]
[NAME]
NOTES
I have locked column A for match, but not the number, this will work for producing values in column B when draggging down
However, I need the formula to work ACROSS columns C to G as well, and the formula is not flexible for giving column updates (i.e increase by 1) - I have ordered the columns to line up to allow for something as easy as this
Spreadsheet: 268248d1380531209-moving-sum-when-inserting-rows-skate1991
Sheet: Sheet1

2013-09-21 00:00:00 | 81
2013-09-22 00:00:00 | 94
2013-09-23 00:00:00 | 70
2013-09-24 00:00:00 | 49
2013-09-25 00:00:00 | 62
2013-09-26 00:00:00 | 14
2013-09-27 00:00:00 | 15
2013-09-28 00:00:00 | 71
2013-09-29 00:00:00 | 96
2013-09-30 00:00:00 | 47
Spreadsheet: 135372d1325979926-help-autofilling-on-amazing-spreadsheet-i-have-created-boostrosterprojectionv6
Sheet: STAFF NAMES

NAME | HOURLY RATE
MARY
DINA |  |  |  | WEEKLY SALES (NOT INC GST)
BROOKE |  |  |  | 5000
KAT
JELA |  |  |  | YOUR S.P.L.H |  | #N/A
THERESA |  |  |  | WAGES %
SARAH
BRADEN
JACK
MELINDA
Hughie
nat
dome
isla
Spreadsheet: 546412d1510043129-fixing-into-a-preferred-format-getting-the-correct-format
Sheet: Sheet2

 |  |  |  |  |  | PREFERRED [NAME]
 |  | Name | Amount of Revenue | Comission |  | Name | Records | Amount of Revenue | Comission
 |  | SALES: Full Name: [NAME] (2 records) | 2040 | 10.2 |  | [NAME] | 2 | 2040 | 10.2
 |  | SALES: Full Name: [NAME] (11 records) | 15480 | 77.4 |  | [NAME] | 11 | 15480 | 77.4
 |  | SALES: Full Name: [NAME] (6 records) | 6878.79 | 34.39 |  | [NAME] | 6 | 6878.79 | 34.39
 |  | SALES: Full Name: [NAME] (21 records) | 50880 | 254.4 |  | [NAME] | 21 | 50880 | 254.4
Spreadsheet: 148907d1333612539-formula-need-to-convert-a-cell-with-character-and-number-book1_kw42chan
Sheet: Sheet1

 |  |  | Result 1 |  | Result 2
Abc2.0 | Abc.0 | Abc. | Abc |  | Abc |  |  | C
1.5DD2 | DD2 | DD | DD |  | DD |  |  | D
4C | C | C | C |  | C |  |  | C
Spreadsheet: 477901d1472564358-tough-problem-how-can-i-average-different-columns-based-on-student-names-monthly-mastery-tracker
Sheet: Growth and Analysis NHM

Class 1 | Oneonta |  | Class 2 | [NAME] |  | Class 3 | York |  | Class 4 | [NAME] |  | Class 5 | Cortland |  | Class 6 | [NAME]
Name | Average Grade |  | Name | Average Grade |  | Name | Average Grade |  | Name | Average Grade |  | Name | Average Grade |  | Name | Average Grade
Student x |  |  | Student y |  |  | Student z
Spreadsheet: 248535b5-a29e-4128-a473-f96aac37e4a3
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: |  |  | 2011-09-22 09:48:24.510000
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.375 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.694 | 101.569 | 101.444 | 101.069
4.125 | 101.408 | 101.283 | 101.158 | 100.783 |  | Note: | Refer To Price [NAME]
4 | 101.047 | 100.922 | 100.797 | 100.422 |  |  | For all Price Adjs
3.875 | 100.528 | 100.403 | 100.278
3.75 | 99.634 | 99.509 | 99.384
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 101.875 | 101.75 | 101.625 | 101.25
3.5 | 101.654 | 101.529 | 101.404 | 101.029
3.375 | 101.548 | 101.423 | 101.298 | 100.923
3.25 | 100.993 | 100.868 | 100.743 | 100.368
 |  |  |  |  |  | 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 | 2011-10-06 09:48:24.510000
30 DAY | 2011-10-21 09:48:24.510000
45 DAY | 2011-11-05 09:48:24.510000
60 DAY | 2011-11-20 09:48:24.510000
90 DAY | 2011-12-20 09:48:24.510000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 106146d1303350554-excel-2007-workday-formula-with-workhours-sample
Sheet: Overview

 | Timeline |  | characters
 | Assets & Finalized CSD sent to [NAME] | 2011-04-20 15:00:00 | (please fill this in)
 | Yesmail Web Production
 | Yesmail QA
 | Testers sent to AVON
 | 1st Deployment Date
 | Dynamic Campaign Overview |  | characters
 | [NAME]
 | Garrett
 | [NAME]
 | Kassity
 | Mario
 | [NAME]
 | Noelle
 | [NAME]
 | PJ
 | Select
 | Yes
 | No
 | Select
 | Ad-hoc
 | [NAME]
Spreadsheet: 842246d1694364079-random-pick-a-cell-content-in-a-range-ignoring-all-blank-empty-cells-in-that-range-random-202309_wvw
Sheet: Blad3

 |  | 52
 |  | 51
 |  | 50
 |  | 49
 |  | 48
 |  | 47
 |  | 46
 |  | 45
 |  | 44
 |  | 43
 |  | 42
 |  | 41
 |  | 40
 |  | 39
 |  | 38
 |  | 37
 |  | 36
 |  | 35
 |  | 34
 |  | 33
 |  | 32
 |  | 31
 |  | 30
 |  | 29
 |  | 28
 |  | 27
 |  | 26
 |  | 25
 |  | 24
 |  | 23
 |  | 22
 |  | 21
 |  | 20
 |  | 19
 |  | 18
 |  | 17
 |  | 16
 |  | 15
 |  | 14
 |  | 13
 |  | 12
 |  | 11
 |  | 10
 |  | 9
 |  | 8
 |  | 7
 |  | 6
 |  | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1 |  |  |  | =index(filter(c2:c,c2:c<>""),randbetween(1,counta(c2:c))
 |  | index(c:c,index(mode.mult(if(c2:h52<>"","",row (c2:[NAME]:c52>0))))
 |  |  |  |  |  | index(c:c,index(mode.mult(if(c2:h52<>"","",row (c2:[NAME]:c52>0))))
Spreadsheet: 585552d1533821474-pairing-deposits-with-corresponding-combined-deposit-on-bank-statement-rec-gr-7-18
Sheet: 1040  7-18

COMPANY: |  |  |  |  |  |  | BANK | LEDGER
DATE: |  | 2018-07-18 00:00:00 |  |  |  | END BAL | 10119.61 | 9559.47
ACCOUNT: |  |  |  |  |  | CHANGE
CODE: |  | 1040 |  |  |  | REC
BANK
TRANS. | AMT. | CODE | STATUS |  |  | AMEX |  |  |  |  | *I would like to have indicated that there are corresponding deposit amounts,
 |  |  |  |  |  |  |  |  |  |  | even though on the ledger in these instances (2) ledger deposits equal (1) bank deposit
 | -649.67 |  |  |  |  | BANK
 | -776.18 |  |  |  |  | AMX | -26.51 |  |  | <----------
 | -940.14 |  |  |  |  | AMX | -11.89
 | -736.7 |  |  |  |  | AMX | -41.57 |  |  | <----------
 | -581.17 |  |  |  |  | AMX | -15.49 |  |  | <----------
 | -705.49 |  |  |  |  | AMX | -16.17
 | -564.65 |  |  |  |  | AMX | -13.54
 | -668.03 |  |  |  |  | AMX | -28.21
 | -765.1
 | -768.64 |  |  |  |  | LEDGER
 | -590.42 |  |  |  |  | AMX | 12.57 |  |  | <---------- | 12.57 + 13.94 = 26.51
 | -642.58 |  |  |  |  | AMX | 13.94 |  |  | <----------
 | -636.23 |  |  |  |  | AMX | 11.89
 | -849.19 |  |  |  |  | AMX | 31.15 |  |  | <---------- | 31.15 + 10.42 = 41.47
 | -767.3 |  |  |  |  | AMX | 10.42 |  |  | <----------
 | -887.01 |  |  |  |  | AMX | 10.12 |  |  | <---------- | 10.12 + 5.37 = 15.49
 | -956.7 |  |  |  |  | AMX | 5.37 |  |  | <----------
 | -708.35 |  |  |  |  | AMX | 16.17
 | -634.03 |  |  |  |  | AMX | 13.54
 | -589.2 |  |  |  |  | AMX | 15.18
 | -635.41
 | -659.37
 | -669.53
 | -860.27
 | -486.73
 | -526.8
 | -524.83
 | -630.65
 | -607.94
 | -685.13
 | -746.15
 | -595.68
 | 5000
 | 43.3
 | 85.48
 | 529.88
 | 9000
 | 34
AMX | 26.51
AMX | 11.89
AMX | 41.57
AMX | 15.49
AMX | 16.17
AMX | 13.54
AMX | 28.21
LEDGER
TRANS. | AMT. | CODE | STATUS
CC | 736.7 |  |  | <-- START
CC | 705.49
CC | 581.17
CC | 564.65
CC | 668.03
CC | 768.64
CC | 765.1
CC | 590.42
CC | 642.58
CC | 636.23
CC | 849.19
CC | 767.3
CC | 956.7
CC | 887.01
CC | 708.35
CC | 634.03
CC | 589.2
CC | 635.41
CC | 669.53
CC | 860.27
CC | 659.37
CC | 486.73
CC | 526.8
CC | 524.83
CC | 630.65
CC | 685.13
CC | 607.94
CC | 746.15
cc | 649.67
cc | 776.18
cc | 940.14
CC Fees | -22.51
cc fees | -43.3
cc fees | -85.48
cc fees | -529.88
Service fees | -34
transfer cash disb | -5000
transfer cash disb | -9000
AMX | 12.57
AMX | 13.94
AMX | 11.89
AMX | 31.15
AMX | 10.42
AMX | 10.12
AMX | 5.37
AMX | 16.17
AMX | 13.54
AMX | 15.18
Spreadsheet: 33d21e17-6d9d-427a-82d7-0edb9e1c4070
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38792924 | 2013-12-01 22:50:44 | AXIS | 1 | 6 | 3 | 509176 | arsenal94 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38793641 | 2013-12-01 23:22:22 | ALLIES | 0 | 2 | 6 | 509176 | arsenal94 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38804194 | 2013-12-02 19:03:01 | AXIS | 1 | 6 | 4 | 1021156 | uliej | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38804600 | 2013-12-02 19:32:51 | ALLIES | 1 | 6 | 4 | 1021156 | uliej | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 861200d1709142370-rollings-sumifs-with-multiple-criteria-rolling-total-balance-index-match-issue
Sheet: Recon

 |  |  |  |  |  |  | D | W
 |  | Acct | B1 | B1 | Balance |  |  |  |  |  | Outstanding Items On Recon |  | Statement
 |  | Reconciliation Date | 2023-02-28 00:00:00 | 2021-02-28 00:00:00 | Day | Opening | Deposits | Withdrawals | Closing |  | Deposits | Withdrawals | Balance
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 135376.095 |  |  | #n/a should show a value
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134464.095
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134464.095
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134464.095
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134076.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134019.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134019.495
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 134019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 134019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 134019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 121019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 121019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 121019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 121019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 121019.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 117219.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 111199.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | 0 | 111199.495
 |  |  |  |  |  |  |  |  |  |  | 19365.18 | -351.1199999999999 | 111199.495