tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 685769d1594191253-combine-vlookup-hlookup-and-min-max-sample-file-h
Sheet: Sheet4

NO_AGGR | ANG_1 | ANG_2 | ANG_3 | ANG_4 | ANG_5 | ANG_6 | [NAME] | ANG_8 | ANG_9 | ANG_10 | ANG_11 | [NAME] | ANG_13 | ANG_14 | ANG_15 | ANG_16 | ANG_17 | ANG_18
Mike1 | 3 | 3 | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
Mike2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0
Mike3 | 0 | 0 | 0 | 0 | 7 | 0 | 4 | 19 | 0 | 3 | 20 | 21 | 23 | 31 | 145 | 116 | 85 | 55
[NAME] | 0 | 0 | 10 | 17 | 19 | 29 | 30 | 124 | 94 | 63 | 33 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Mike5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 17 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
Mike6 | 0 | 0 | 3 | 13 | 5 | 0 | 14 | 136 | 107 | 76 | 46 | 15 | 0 | 0 | 0 | 0 | 0 | 0
Mike7 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 2 | 3 | 4 | 1 | 3 | 5 | 3 | 2 | 7 | 2
Mike8 | 0 | 0 | 7 | 6 | 15 | 10 | 1 | 1 | 0 | 6 | 3 | 37 | 6 | 14 | 36 | 129 | 100 | 69
Mike9 | 2 | 5 | 28 | 28 | 25 | 28 | 27 | 27 | 28 | 7 | 2 | 25 | 27 | 23 | 27 | 28 | 27 | 28
Mike10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 0 | 0 | 0 | 4 | 5 | 2 | 0 | 6
Mike11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 0
Mike12 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 4 | 11 | 17 | 20 | 11 | 16 | 19 | 27 | 5 | 6 | 25
Mike13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2
Mike14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mike15 | 0 | 0 | 0 | 3 | 0 | 0 | 9 | 1 | 4 | 8 | 9 | 1 | 9 | 22 | 14 | 12 | 20 | 21
 | ANG_1 | ANG_2 | ANG_3 | ANG_4 | ANG_5 | ANG_6 | [NAME] | ANG_8 | ANG_9 | ANG_10 | ANG_11 | [NAME] | ANG_13 | ANG_14 | ANG_15 | ANG_16 | ANG_17 | ANG_18
Spreadsheet: 215605d1361426248-match-index-countif-functions-sample-excel-ans
Sheet: Main

 | Product # |  | Product #
 |  |  |  |  |  |  | I want to copy all the prodcut # from column C in Data worksheet that has "Car" in the same row in column E to the table on the left.
 |  |  |  |  |  |  | Below is the code I am using but it is giving me an error code.
 |  |  |  |  |  |  | Can anyone please help??
 |  |  |  |  |  |  | = Index(Indirect("'"&"Data"&"'!$C$2:$C$12"),MATCH(0,COUNTIF(B$2:$B2,INDIRECT("'"&"Data"&"'!$C$2:$C$12))+(INDIRECT("'"&"Data"&"'!$D$2:$D$12)="")+IF(INDIRECT("'"&"Data"&"'!$G$2:$G$12)="Car",1,0)),0)
Spreadsheet: 164053d1340632731-lookup-and-match-formula-from-seperate-spreadsheets-billing-per-client-2011
Sheet: Sheet1

Source spreadsheet |  |  |  |  |  | Cost |  |  | Effective |  | Target spreadsheet
Client | Work Activity | Hours | % | Amount | % | Rate | WriteUp/Dn | % | Rate |  | Client | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | activity | Activity
 |  |  |  |  |  |  |  |  |  |  | code | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 34
CASH | CASH  [NAME] (RUS003)        Partner: |  |  |  |  |  |  |  |  |  | cash |  |  |  | 0.25 |  |  |  |  | 1 |  | 0.33
CASH | 4 ANNUAL FINANCIAL STATEME | 0.25 | 15.82 | 42.5 | 9.17 | 170 | 0 | 0 | 170 |  | 2KT001 | 0.41 | 1.48 |  | 5.16 |  |  | 1.66 |  | 3 |  | 18.62 |  |  |  | 3.4 |  | 1
CASH | 9 INCOME TAX RETURNS | 1 | 63.29 | 330 | 71.24 | 330 | 0 | 0 | 330 |  | 3DC001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
CASH | 11 DATA CAPTURING | 0.33 | 20.89 | 90.75 | 19.59 | 275 | 0 | 0 | 275 |  | 56E001 | 1.55 |  |  | 7.08 |  | 0.25 |  |  | 1.5 |  | 12.5 |  |  |  | 1 |  |  | 10.5
2KT001 | 1 CLIENT ADMINISTRATION | 0.41 | 1.18 | 69.7 | 0.64 | 170 | 0 | 0 | 170
2KT001 | 2 TELEPHONE AND FAX | 1.48 | 4.26 | 407 | 3.75 | 275 | 0 | 0 | 275
2KT001 | 4 ANNUAL FINANCIAL STATEME | 5.16 | 14.86 | 2 035.30 | 18.74 | 394.44 | 0 | 0 | 394.44
2KT001 | 7 SALARY ADMINISTRATION | 1.66 | 4.78 | 547.8 | 5.04 | 330 | 0 | 0 | 330
2KT001 | 9 INCOME TAX RETURNS | 3 | 8.64 | 1 037.50 | 9.55 | 345.83 | 0 | 0 | 345.83
2KT001 | 11 DATA CAPTURING | 18.62 | 53.61 | 5 120.50 | 47.15 | 275 | 0 | 0 | 275
2KT001 | 15 MONTHLY RETURNS | 3.4 | 9.79 | 1 122.00 | 10.33 | 330 | 0 | 0 | 330
2KT001 | 17 VISIT CLIENT ON SITE | 1 | 2.88 | 520 | 4.79 | 520 | 0 | 0 | 520
3DC001 | 19 STATUTORY ADMINISTRATIO | 0.5 | 100 | 85 | 100 | 170 | 178.16 | 100 | 526.32
56E001 | 1 CLIENT ADMINISTRATION | 1.55 | 4.51 | 316 | 4.36 | 203.87 | -12.67 | 5.28 | 195.7
56E001 | 4 ANNUAL FINANCIAL STATEME | 7.08 | 20.59 | 2 426.40 | 33.45 | 342.71 | -122.92 | 51.18 | 325.35
56E001 | 6  CLIENT MEETING | 0.25 | 0.73 | 68.75 | 0.95 | 275 | -3.48 | 1.45 | 261.08
56E001 | 9 INCOME TAX RETURNS | 1.5 | 4.36 | 360 | 4.96 | 240 | -18.24 | 7.6 | 227.84
56E001 | 11 DATA CAPTURING | 12.5 | 36.36 | 2 727.50 | 37.6 | 218.2 | -14.19 | 5.91 | 217.06
56E001 | 15 MONTHLY RETURNS | 1 | 2.91 | 200 | 2.76 | 200 | -10.13 | 4.22 | 189.87
56E001 | 34 DATA CAPTURING VUMA | 10.5 | 30.54 | 1 155.00 | 15.92 | 110 | -58.52 | 24.37 | 104.43
Spreadsheet: 249609d1373561405-condense-information-book4
Sheet: Sheet1

 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00
5512 | 12 | 6 | 17 | 27 | 6
5512 | 6 | 19 | 2 | 7 | 14
5512 | 33 | 7 | 21 | 17 | 16
5512 | 5 | 3 | 2 | 1 | 0
5512 Total
5513 | 12 | 6 | 17 | 27 | 6
5513 | 6 | 19 | 2 | 7 | 14
5513 | 33 | 7 | 21 | 17 | 16
5513 Total
5544 | 5 | 3 | 2 | 1 | 0
5544 | 12 | 6 | 17 | 27 | 6
5544 | 6 | 19 | 2 | 7 | 14
5544 Total
5555 | 33 | 7 | 21 | 17 | 16
5555 | 5 | 3 | 2 | 1 | 0
5555 Total
5556 | 3 | 22 | 9 | 17 | 4
5556 Total
Grand Total
Spreadsheet: 720999d1614424535-need-help-to-remove-false-and-shorten-the-formula-sample-workbook
Sheet: Prototype

Care Setting: |  |  |  | Start Point: | Free text field |  | Total Manpower Cost:
Length of Inpatient Stay: |  |  |  | End Point: | Free text field |  | Total Non-Manpower Cost:
Date of Update: |  |  |  | Exclusions: | Free text field |  | Overall Cost per Carepath:
S/N | Type of Cost | Type of Care Setting | Activity/ Therapy/ Procedures | Profession | Seniority | Generic Cost from Finance (Manpower) | FTE required | Activity Duration (minutes) | Manpower Cost per Activity | Generic Cost from Finance (Non-Manpower) | Non-Manpower Cost based on LOS
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
Spreadsheet: 701043d1603478833-date-difference-in-days-with-conditions-sample3a
Sheet: sample3

Order Number |  |  | Shipment Type | Date1 | Date2 | Expected Value:
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1137372 |  |  | Interim | 2015-12-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Final | 2015-12-31 00:00:00 | 2020-01-16 00:00:00 | N/A
1137372 |  |  | Interim | 2015-12-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2016-04-30 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2016-04-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2016-08-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2016-08-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2016-12-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2016-12-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2017-04-30 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2017-04-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2017-08-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2017-08-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2017-12-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2017-12-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2018-04-30 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2018-04-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2018-08-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2018-08-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2019-09-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2019-09-30 00:00:00 | 2019-12-17 00:00:00
1130302 |  |  | Final |  | 2020-02-23 00:00:00 | -
1130302 |  |  | Final | 2020-02-23 00:00:00 |  | -
1130303 |  |  | Final | 2020-03-23 00:00:00 | 2020-03-23 00:00:00 | -
1130303 |  |  | Final |  |  | -
1130307 |  |  | Final | 2020-07-23 00:00:00 | 2020-07-23 00:00:00 | 0
1130307 |  |  | Final | 2020-07-23 00:00:00 | 2020-07-23 00:00:00 | 0
1130308 |  |  | Final | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 2
1130308 |  |  | Final | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 2
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 6
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 6
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 6
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-07 00:00:00 | 6
Spreadsheet: 79293d1279567667-acquisition-schedule-formula-acquisition-schedule
Sheet: Sheet1

 | Acquisition Value | 100
 | Acquisition Cycle | 8
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  | 100 | 0 | 0 | 0 | 100 | 0 | 0 | 100 | 0 | 100 | 0 | 0 | 0 | 0 | 100 | 100 | 0 | 0 | 0 | 100
Spreadsheet: daren_farmer__5639__HPLN1221
Sheet: Sheet1

HPLN1221.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 21, 2000
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-21 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 15 | 10
Enron (S) |  | LS HPL [NAME] |  | Enron | 5 | 30
Enron (S) |  | Oasis Sealy |  | Enron | 10 | 30
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 9fd8a751-7d26-4599-b444-e16b0e984205
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Cobb | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Holland | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | [NAME] | Angelia | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | McLean | [NAME] | [EMAIL] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Hilton | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Wicker-McCree | Ingrid | [EMAIL] | [PHONE] |  | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Yow | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Cone | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Cunningham | Bubba | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Rose | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Record | [NAME] | [EMAIL] | [PHONE] |  | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Christy | [NAME] | [EMAIL] | [PHONE] |  | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts |  |  |  |  |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Eaton | [NAME] | [EMAIL] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 16a

Product |  | TOTAL
Single - Name* | Corporate
 | Loans
 | Municipal
 | Recovery
 | Sovereign
Index Tranche | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A**
Estimated swap dollar volumes, week ending December 28, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 823304d1679890791-how-to-search-and-highlight-the-row-a-list
Sheet: Sheet1

Build/dispatch Date |  | Serial No.
From | To | From | To |  |  |  | Lookup Value | 89000
2001-09-21 00:00:00 | 2005-01-24 00:00:00 | 85091 | 99865
2005-04-15 00:00:00 | 2006-07-01 00:00:00 | 15001 | 165222
2006-07-01 00:00:00 | 2007-06-30 00:00:00 | 181013 | 165223
2007-07-01 00:00:00 | 2008-05-22 00:00:00 | 181205 | 200009
2008-05-23 00:00:00 | 2009-02-10 00:00:00 | 200010 | 224289
2009-02-10 00:00:00 | 2009-08-26 00:00:00 | 224290 | 244513
2010-10-29 00:00:00 | 2011-03-31 00:00:00 | 289105 | 308880
2009-08-27 00:00:00 | 2010-03-26 00:00:00 | 244514 | 263617
2010-03-29 00:00:00 | 2011-09-28 00:00:00 | 308881 | 331877
2001-09-28 00:00:00 | 2012-01-31 00:00:00 | 331878 | 348484
2012-01-31 00:00:00 | 2012-07-02 00:00:00 | 348485 | 368980
2012-07-02 00:00:00 | 2012-12-05 00:00:00 | 368981 | 386596
2012-12-05 00:00:00 | 2013-05-14 00:00:00 | 386597 | 409588
2013-05-14 00:00:00 | 2013-09-25 00:00:00 | 409589 | 432771
2013-09-25 00:00:00 | 2014-02-04 00:00:00 | 432772 | 453795
2014-03-04 00:00:00 | 2014-07-16 00:00:00 | 453796 | 475427
2014-07-16 00:00:00 | 2014-11-06 00:00:00 | 475428 | 485655
Spreadsheet: 869569d1716186970-how-to-merge-rows-by-the-value-of-the-cells-in-the-column-a-example_file
Sheet: Sheet1

ID | Row | Ref no. | Name | Desc. | Qty
DEL-GT-54 | 12 | 123A-ABC-30-99 | Example | Example example | 1.5
DEL-GT-54 | 13 | 163A-DBC-30-99 | Example 2 | Maplexaml | 3
DEL-GT-54 | 20 | 523A-ACC-30-99 | Example 3 | gldfhg | 6
DEL-GT-54 | 30 | 123A-ABC-100-100 | Exapmle 4 | fdfgfsgh | 1.7
DEL-GT-54 | 50 | 123A-567C-30-99 | Example % | dtyjju | 4
ALL-VX-108 | 100 | 123-123-123 | Lamexam | lwtfftw | 5
ALL-VX-108 | 99 | 321-321-312 | damn | please | 9
ALL-VX-108 | 88 | 221-221-221 | this | help | 8
ALL-VX-108 | 66 | 111-111-111 | is | me | 7
ALL-VX-108 | 55 | 555-555-555 | hard | sos | 6
WTF-NO-PLS | 11 | [NAME] | [NAME] | gyi | 9
WTF-NO-PLS | 22 | bbb-bbb-bbb | ghg | jul | 8
WTF-NO-PLS | 33 | [NAME] | f | hyff | 4
WTF-NO-PLS | 44 | ddd-ddd-ddd | y | gjjk | 6
WTF-NO-PLS | 55 | eee-ee-eeee | hard | hthf | 3
WTF-NO-PLS | 999 | uuu-uuu-uuu | tj | sdfd | 26
Spreadsheet: 871455d1717853322-create-dynamic-variance-table-create-dynamic-variance-table-excelforum-aligw
Sheet: Sheet1

 | Start Month | 2024-01-01 00:00:00
 | This Month | 2024-03-01 00:00:00
 | Plan
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00
 | ABC 100 | ABC 10 | ABC 120
 | DEF 50 | DEF 5 | DEF 10
 | CDE 20 | CDE 200
 | Actual
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00
 | ABC 10 | ABC 110 | ABC 10
 | DEF 500 | DEF 50 | CDE 100
 | CDE 200 | CDE 20
 | Required
 | Item | Plan This Month | Actual This Month | Variance this Month | Plan To Date | Actual To Date | Variance To Date
 | ABC | 120 | 10 |  | 230 | 130
 | CDE | 0 | 100 |  | 220 | 320
 | DEF | 10 | 0 |  | 65 | 550
 |  | 120 | 10 | -110 | 230 | 130 | -100
 | CDE | 0 | 100 | 100 | 220 | 320 | 100
 | DEF | 10 | 0 | -10 | 65 | 550 | 485
Spreadsheet: 880393d1728054112-adding-a-search-box-to-excel-example-for-forum
Sheet: Sheet1

 | Job No | Client | Address | Description
 | 1517 | TERRY K Mr | Chestnut Farm, [NAME] | [NAME] conversion
 | 15126 | [NAME] R | Port Pleasant, Aldeburgh | Alterations & extension
 | 1751 | JONES M Mr | Land adj 16 Fawcett Rd, Aldeburgh | New house
 | 1760 | QUEEN [NAME]’S SCHOOL | Barnet | New Music Department
 | 18200 | MAWSON, Mr & Mrs | Moat Farm, [NAME] | [NAME] conversion
 | 1918 | ROBSON, [NAME] | New House, Park Road, Aldeburgh | Alts & Ext
 | 1999 | DAVIS, [NAME] | Unit B, Willoughby Arms | Planning & B Regs
 | 19106 | HAYWARD, [NAME] | Ashmoor Hall, Campsea Ashe | Erection New Agricultural Bldgs
 | 19178 | DEBENHAM LEISURE CENTRE | [NAME], Debenham | New Car Park
 | 19187 | RACKHAM, Paul Ltd | [NAME] | [NAME] grain silos to residential unit
 | 19199 | WATSHAM, Mr & Mrs M | 3 [NAME], [NAME] | New Bungalow
 | 19200 | VINEGROW Ltd | 1 The Thoroughfare, Harleston | [NAME] – replacement  & extg barn with new dwlg
 | 19201 | RYDER-DAVIES & PARTNERS | [NAME] | Feasibility New Vet Surgery
 | 2060 | PAUL S Mr | Rookery Farm, Cratfield | Agric barn Prior Approval
 | 2068 | COOPER B Mr | Lodge Farm, [NAME] | Class Q Residential conversion
 | 2069 | [NAME], Mr | [NAME], Sotherton | Main barn extension
 | 2070 | LAWSON R Mr | Hill House Farm, Stradbroke | Annexe
 | 2097 | [NAME] | Carlton Green Farm, Carlton | [NAME] conversion
 | 20123 | ECKFORD P Mr & Mrs | The Mill House, Cransford | New annexe conversion
 | 20128 | PORTER E Mr | Grange Farm, Framlingham | Renovation of Listed Building
 | 20172 | HAYWARD, Paul | 243-246 Ashe Row, [NAME] | Possible Development
 | 20223 | ALBOROUGH, Mr & Mrs | The Willows, Framlingham | Extension
 | 20225 | FULLER, Mr [NAME] | Peace Haven, [NAME] | Extension
 | 20237 | BOOTY T Mr | 12 Cullingford Close, [NAME] | Variation of condition
 | 2101 | TANNER G (Shalford) Ltd Builders Yard | The St, Shalford | Resubmission Planning
Spreadsheet: 86043d1286011326-ignoring-blank-cells-in-a-chart-cash-deposits-and-orders-sample-4-
Sheet: 09-20-10

CASH ORDER
Denomination |  | 2010-09-20 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 4581200 |  | 1444600
20 |  | 5927320 |  | 1147000 |  |  |  | -2000000
10 |  | 255320 | 13410 | 0 |  |  |  | -150000
5 |  | 652645 |  | 286100
1 |  | 200507 |  | 52000 |  |  |  | -30000
0.25 |  | 18461 | 11195 | 0 |  |  | 5000
0.05 |  | 5991 | 897 | 0 |  |  | 1400
0.01 |  | 928 | 427 | 0 |  |  | 300
Total
Spreadsheet: 236213d1368725391-advice-please-need-to-track-devices-issue-and-dates-temp
Sheet: Sheet1

Device Number | Date | Issue | Action/Resolution
1217 | 2013-05-10 00:00:00 | Says "slow to scan" | Seems fine
1118 | 2013-05-10 00:00:00 | Says "laser stopped scanning" | Cold booted, seems fine
1194 | 2013-05-09 00:00:00 | Filling SSL error | Reloaded config-seems fines now
1032 | 2013-05-09 00:00:00 | Filling SSL error | cold booted-seems fine now
1168 | 2013-05-09 00:00:00 | Filling SSL error | Reloaded config-working now
Spreadsheet: 861824d1709652624-integer-number-formula-integer-number-formula-v1
Sheet: Formula Needed

 |  |  | RP1 | RP2 | RP3 | RP4 | RP5 | RP6 | RP7 | RP8 | RP9 | RP10 | RP11 | RP12 | RP13 | RP14
Percentage can be changed but total will be always 100% |  |  | 0.5 | 0.6 | 0.46 | 0 | 0.71 | 0.9 | 0 | 0 | 1 | 0.71 | 0.46 | 0.48 | 0.6 | 0.44
 |  |  | 0.5 | 0 | 0.07 | 0 | 0.29 | 0.1 | 0 | 0.41 | 0 | 0.29 | 0.37 | 0.46 | 0 | 0.42
 |  |  | 0 | 0.4 | 0.47 | 1 | 0 | 0 | 1 | 0.59 | 0 | 0 | 0.17 | 0.06 | 0.4 | 0.14
Ex.1 Select 6 Num |  | 6
 |  | Sum
For example In C11, I pick 6 numbers that I want to distribute accordingly D6:Q8 %, in the D11:Q13 as [NAME] I cannot get total 6 in row 14
Ex.1 Select 10 Num |  | 10
 |  | Sum
For example In C19, I pick 10 numbers that I want to distribute accordingly D6:Q8 %, in the [NAME]:Q22 as Integer Numbers I cannot get total 10 in row 22
 |  | I need a formula that distribute exact amount of picked numbers in the range also varying the % it should match the total of numbers between selected & picked.
Spreadsheet: 268253d1380532222-formula-to-extract-numbers-from-string-box_dimensions
Sheet: Importer

Product name | Product code | Category | Secondary categories | Description | Short description | Meta keywords | Meta description | Search words | Page title | Features | Price | Weight | Box size | Status | Quantity | Files | Detailed image
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 20 Jan 20 - 25 Jan 20 

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-01-20 00:00:00 | 2020-01-21 00:00:00 | 2020-01-22 00:00:00 | 2020-01-23 00:00:00 | 2020-01-24 00:00:00 | 2020-01-25 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 20/01/2020 - 25/01/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | AWAY | AWAY | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 |  |  |  |  | ✓ |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 | ✓ | ✓ | ✓ |  |  |  |  |  |  |  | ❌
Edge Protection [NAME] |  |  | 20/01/2020 - 25/01/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 20/01/2020 - 25/01/2020
Lilburn |  |  | ❌ |  |  |  |  |  |  | Dameon | ❌
Camden |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
63 [NAME] |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Canterbury Linen |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Northlink |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Blum |  |  | ❌ |  |  |  |  |  |  | Harley | ✓
85 Falsgrave |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌