tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102772d1300728815-revision-of-index-match-example
Sheet: Corporate Actions

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Announced Dividends
List Name #1 | List Name #2 | List Name #3 | List Name #4 | List Name #5 | List Name #6 | List Name #7 | List Name #8 | List Name #9 | List Name #10 | Account Number | Symbol | Ex Date | Rec Date | Payable Date | Position | Rate | Base CCY Gross Amount | Payable CCY Code | Type | Dividend Description | L/S/E Indicator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPECTED_REPORT_DT | EQY_DVD_SPL_ANN_DT_NEXT | EQY_DVD_SPL_EX_DT_NEXT | EQY_DVD_SPL_SPLIT_RATIO_NEXT | EQY_SPLIT_ADJUSTMENT_FACTOR | EQY_DVD_SPL_ADJ_FCT_NEXT
 |  |  |  |  |  |  |  |  |  | 7Y4D1209 | EXPE | 2011-03-09 00:00:00 | 2011-03-11 00:00:00 | 2011-03-31 00:00:00 | 4651 | 0.07 | 325.57 | USD | Pending | CASH DIVIDEND | L
Spreadsheet: 195231d1353449525-searching-whether-a-cell-contains-one-or-more-keywords-from-a-dynamic-list-test
Sheet: Sheet1

 |  |  | list of keywords = {keyword1, keyword2,….}
 | this line contains keyword1 and some other text | 1 | 1 | //if B4 contains a word from the "list of keywords" D4=C4
 | this line contains keyword2 and some other text | 2 | 2 | //if [NAME] contains a word from the "list of keywords" D5=C5
 | this line does not contain a keyword | 3 |  | [NAME] contains a word from the "list of keywords" D6=C6
 | another line with no keyword | 4 |  | //if B7 contains a word from the "list of keywords" D7=C7
 | keyword1 appears here again | 5 | 5 | //if B8 contains a word from the "list of keywords" D8=C8
 | maybe keyword2 is here | 6 | 6 | //if B9 contains a word from the "list of keywords" D9=C9
Spreadsheet: 078d2250-c626-4566-a98e-387d79dc21c8
Sheet: Sheet1

Unnamed: 0 | [NAME] | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Stadt | Land | Fluss | Name | Tier | [NAME]
A | Aachen | Aserbaidschan | [NAME] | Annabell | Amsel | Arzt
B | Bamberg | Belgien | - | [NAME] | Bär | Bäcker
C | Celle | China | - | Christina | Chameleon | Chirurg
D | Dublin | [NAME] | Donau | Domenik | Dachs | Dompteur
E | Ebrach | England | Elbe | Elena | Ente | Elektriker
F | Frankfurt | Finnland | - | Felix | Fuchs | Fischer
G | Giesen | Griechenland | - | Grete | [NAME] | Gärtner
H | Hamburg | Holland | Hafel | Hannibal | Hund | Handwerker
I | Ingolstadt | Italien | Isar | Isabell | [NAME] | Imker
J | Jerusalem | Jordanien | Jordan | Johannes | Jaguar | Jäger
K | Karlsruhe | Kanada | - | [NAME] | [NAME] | Kammerjäger
L | Landshut | Lybien | Lech | [NAME] | Lama | [NAME]
M | München | Mexiko | Magdalena | Maria | Maus | Metzger
N | Nürnberg | Niederlande | [NAME] | Niklas | Natter | Nonne
O | Oslo | Österreich* | Orinoco | [NAME] | Otter | Organist
P | Paris | Portugal | Po | [NAME] | Pelikan | Polizist
Q | Quimper | Quebec | - | - | Qualle | -
R | [NAME] | Russland | Regen | Roland | [NAME] | Radrennfahrer
S | Stuttgart | [NAME] | Saale | [NAME] | Stier | Schlotfeger
T | Trier | Togo | Themse | [NAME] | Tiger | Töpfer
U | Ulm | Ungarn | - | Ulf | Uhu | Umweltschützer
V | [NAME] | Vietnam | - | Vera | Vogel | Verwaltungsangestellter
W | Warschau | Weißrussland | Weser | Walter | Wellensittich | Wächter
X | - | - | - | Xaver | - | [NAME]
Y | Yokohama | - | - | Yvonne | [NAME] | Yogameister
Z | - | Zypern | - | - | Zebra | Zoowärter
*) alternativ: Osttimor |  |  | Ergänzungen werden gerne angenommen
Spreadsheet: 66596d1267215847-combination-function-test1111
Sheet: Sheet1

Statements | Daily Cash
313.39 | 97.47
623.93 | 240
282.69 | 11.23
770 | 92.43
4.51 | 3.92
339.24 | 5.94
550.69 | 70
961.08 | 40
247.31 | 12.93
1853.76 | 690
1311.24 | 99
48.67 | 4.51
84.63 | 390
140.95 | 11.59
10 | 2.65
90.2 | 146
160.89 | 401.08
90 | 109
 | 80
 | 6.93
 | 4.76
 | 143.55
 | 240
 | 72
 | 248
 | 106
 | 92688
 | 11.11
 | 12.65
 | 4.51
 | 5.85
 | 208
 | 77.54
 | 3.5
 | 5.17
 | 80
 | 80
 | 2.32
 | 4.77
 | 1058.14
 | 17.36
 | 40
 | 77
 | 11.59
 | 5.49
 | 4.51
 | 60
 | 5.2
 | 45
 | 40
 | 120
 | 21.72
 | 1.17
 | 138
 | 40
 | 340.69
 | 304.89
 | 12.61
 | 50
 | 6.79
 | 295.69
 | 15.68
 | 9.25
 | 3.82
 | 1176.84
 | 360.69
 | 3.71
 | 11.85
 | 4.43
Spreadsheet: 39888d1238145688-help-with-an-odd-chart-677432
Sheet: Pivot

Keywords | Clicks | Month
basketball | 5 | November
soccer | 6 | November
football | 3 | November
baseball | 10 | November
[NAME] | 1 | November
soccer | 16 | December
[NAME] | 3 | December
baseball | 5 | December
basketball | 7 | December
[NAME] | 9 | January
football | 1 | January
basketball | 10 | January
baseball | 10 | January
soccer | 3 | January
soccer | 4 | February
[NAME] | 5 | February
 |  |  |  |  | Sum of Clicks | Keywords
 |  |  |  |  | Month | baseball | basketball | football | [NAME] | soccer | Grand Total
 |  |  |  |  | January | 10 | 10 | 1 | 9 | 3 | 33
 |  |  |  |  | February |  |  |  | 5 | 4 | 9
 |  |  |  |  | November | 10 | 5 | 3 | 1 | 6 | 25
 |  |  |  |  | December | 5 | 7 |  | 3 | 16 | 31
 |  |  |  |  | Grand Total | 25 | 22 | 4 | 18 | 29 | 98
Spreadsheet: 163e90e7-182a-4621-9c96-b3a79d642f6d
Sheet: Sheet1

2004-09-14 00:00:00 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Gallus, r | Sorlucco, d | [NAME] |  |  | Page 1 of 2
Albany | 33
Atkinson and [NAME]. Gt. | 0
[NAME] | 115 |  | 1
Bean's Grant | 0
Bean's Purchase | 0
[NAME] | 65
[NAME] | 75 |  | 1
[NAME] 3 | 130
[NAME] 4 | 28
Bethlehem | 100 | 1
Cambridge | 0
Carroll | 68
[NAME]'s Purchase | 0
[NAME] | 21
Colebrook | 111
Columbia | 43
Crawford's Purchase | 0
Cutt's Grant | 0
[NAME] | 65
Dix's Grant | 0
Dixville | 10
Dummer | 24
Errol | 24
Erving's Location | 0
Franconia | 68 |  | 1
[NAME] | 107
Green's Grant | 0
Hadley's Purchase | 0
Hale's Location | 7 |  | 1
Hart's Location | 7
[NAME] | 69
[NAME] | 136
Kilkenny | 0
Lancaster | 226
Lincoln | 77
Lisbon | 61
Littleton | 302 | 3 | 3
Livermore | 0
Low and Burbank's Grant | 0
[NAME] | 29 | 1
Martin's Location | 0
Milan | 64
[NAME] | 9
Northumberland | 53
[NAME] | 0
[NAME]'s Grant | 0
Pittsburg | 60
Randolph | 35 | 1
Sargent's Purchase | 0
Second College Grant | 0
Shelburne | 14
[NAME] | 26
Stewartstown | 40
[NAME] | 21
Success | 0
[NAME] | 35
Thompson & Meserve's Purchase | 0
Waterville Valley | 21
Wentworth's Location | 2
[NAME] | 120
Totals | 2501 | 6 | 7
Spreadsheet: 806415d1669286041-formula-to-sum-values-in-different-range-sizes-new-microsoft-excel-worksheet-7-1-
Sheet: Sheet1 (3)

 |  |  |  |  |  | Red > | 200
 |  |  |  |  |  | Green > | 150
82 | 131 | 137
130 | 201 | 238
96 | 122 | 176 |  |  |  | 96
108 | 146 | 234
102 | 224 | 174
112 | 109 | 189
141 | 131 | 174
135 | 121 | 169
89 | 115 | 176
74 | 153 | 155
109 | 141 | 135
94 | 78 | 59
122 | 157 | 143
92 | 22 | 73
116 | 115 | 132
83 | 241 | 199 |  |  |  | 616
104 | 183 | 149
125 | 160 | 164
103 | 143 | 132
99 | 167 | 139
164 | 176 | 138
103 | 191 | 131
76 | 2115 | 120 |  |  |  | 545
122 | 22 | 148
248 | 160 | 213
226 | 179 | 222
234 | 186 | 179
192 | 203 | 187 |  |  |  | 192
198 | 161 | 225
246 | 191 | 165
219 | 227 | 215 |  |  |  | 219
207 | 171 | 197 |  |  |  | 207
171 | 248 | 218 |  |  |  | 171
238 | 208 | 231
237 | 165 | 224
177 | 186 | 162
229 | 225 | 226 |  |  |  | 229
195 | 224 | 210
161 | 174 | 196
242 | 202 | 183 |  |  |  | 242
168 | 157 | 227
151 | 142 | 219
174 | 228 | 235
159 | 248 | 178 |  |  |  | 159
223 | 210 | 230
197 | 189 | 199 |  |  |  | 197
170 | 186 | 198
210 | 216 | 225
153 | 245 | 219
190 | 189 | 151
241 | 100 | 159
230 | 239 | 232
212 | 168 | 212
199 | 157 | 160
232 | 201 | 191
193 | 161 | 242
248 | 205 | 215
192 | 184 | 177
177 | 215 | 173
233 | 157 | 211
189 | 212 | 190
239 | 193 | 230
172 | 179 | 249
227 | 230 | 203
218 | 43 | 246
194 | 44 | 166
186 | 90 | 242
235 | 223 | 52
229 | 239 | 153
249 | 183 | 221
196 | 235 | 157
203 | 199 | 229
166 | 192 | 178
150 | 193 | 214
200 | 191 | 178
Spreadsheet: 850591d1700952151-transpose-rows-from-one-sheet-to-another-sheet-based-on-a-value-in-one-of-the-columns-transpose-worksheet-copy
Sheet: Sheet2

AREA ID | A | B | B | B | A | A | A | B
QUANTITY | 8 | 9 | 3 | 10 | 15 | 8 | 20 | 45
COST | 133 | 289 | 285 | 166.25 | 481.6666666666667 | 133 | 1142 | 636.75
DATE | 2016-03-31 00:00:00 | 2017-01-29 00:00:00 | 2017-11-13 00:00:00 | 2018-03-06 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00
SELLER | Seller 3 | Seller 4 | Seller 2 | Seller 1 | Seller 2 | Seller 3 | Seller 4 | Seller 1
BUYER | Buyer 5 | Buyer 3 | Buyer 3 | Buyer 6 | Buyer 5 | Buyer 5 | Buyer 5 | Buyer 3
ITEM | Item 1 | Item 6 | Item 4 | Item 1 | Item 6 | Item 1 | Item 2 | Item 3
AREA ID | A | B | B_1 | B_2 | A_3 | A_4 | A_5 | B_6
QUANTITY | 8 | 9 | 3 | 10 | 15 | 8 | 20 | 45
COST | 133 | 289 | 285 | 166.25 | 481.6667 | 133 | 1142 | 636.75
DATE | 2016-03-31 00:00:00 | 2017-01-29 00:00:00 | 2017-11-13 00:00:00 | 2018-03-06 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00
SELLER | Seller 3 | Seller 4 | Seller 2 | Seller 1 | Seller 2 | Seller 3 | Seller 4 | Seller 1
BUYER | Buyer 5 | Buyer 3 | Buyer 3 | Buyer 6 | Buyer 5 | Buyer 5 | Buyer 5 | Buyer 3
ITEM | Item 1 | Item 6 | Item 4 | Item 1 | Item 6 | Item 1 | Item 2 | Item 3
 | A | B | B | B | A | A | A | B
QUANTITY | 8 | 9 | 3 | 10 | 15 | 8 | 20 | 45
COST | 133 | 289 | 285 | 166.25 | 481.6666666666667 | 133 | 1142 | 636.75
DATE | 2016-03-31 00:00:00 | 2017-01-29 00:00:00 | 2017-11-13 00:00:00 | 2018-03-06 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00 | 2018-03-28 00:00:00
SELLER | Seller 3 | Seller 4 | Seller 2 | Seller 1 | Seller 2 | Seller 3 | Seller 4 | Seller 1
BUYER | Buyer 5 | Buyer 3 | Buyer 3 | Buyer 6 | Buyer 5 | Buyer 5 | Buyer 5 | Buyer 3
ITEM | Item 1 | Item 6 | Item 4 | Item 1 | Item 6 | Item 1 | Item 2 | Item 3
Spreadsheet: 174060d1344903494-b-possible-to-extract-this-complicated-partial-data-in-excel-b-parsing-a-string-special
Sheet: Sheet1

[PHONE] ,SANJAY Requested by BPL MAHAVIR SHOPE CENTRE ,[PHONE],
[PHONE] ,RAMA Requested by BPL MAHAVIR SHOPE CENTRE ,[PHONE],
[PHONE] ,[NAME] by BPL MAHAVIR SHOPE CENTRE ,[PHONE],
[PHONE] ,PANCHAM Requested by BPL MAHAVIR SHOPE CENTRE ,[PHONE],
[PHONE] ,RAJ Requested by BPL MAHAVIR SHOPE CENTRE ,[PHONE],
[PHONE] ,SUKHRAM Requested by BPL MAHAVIR SHOPE CENTRE ,[PHONE],
[PHONE] ,HARIRAM Requested by BPL POOJA PAN CENTRE(VIKASH NAGAR) ,[PHONE],
[PHONE] ,[NAME] by BPL SONI TELECOMS ,[PHONE],
[PHONE] ,[NAME] by BPL SONI TELECOMS ,[PHONE],
[PHONE] ,LILADHAR Requested by BPL VARANAYEM MOB.(BADORA) ,[PHONE],
[PHONE] ,LALIT Requested by BPL AMIN MOBILE ,[PHONE],
[PHONE] ,[NAME] by BPL PAPPU PAN ,[PHONE],
[PHONE] ,RAKESH Requested by BPL AAYESHA MOBILE ,[PHONE],
[PHONE] ,KAUSU Requested by BPL AMIN MOBILE ,[PHONE],
[PHONE] ,PRAVEEN Requested by BHPD Bothra Mobile ,[PHONE],RD=[PHONE] for activation.
Spreadsheet: 2ab35853-701c-4a83-be1e-4670ee92542c
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
43908732 | 2014-11-06 22:43:35 | AXIS | 1 | 6 | 5 | 780263 | Danjou | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
43909091 | 2014-11-06 22:55:12 | ALLIES | 0 | 3 | 6 | 780263 | Danjou | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
44039553 | 2014-11-15 23:32:19 | AXIS | 0 | 2 | 6 | 1503014 | Agent Avacado | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44039849 | 2014-11-15 23:49:58 | ALLIES | 1 | 6 | 1 | 1503014 | Agent Avacado | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 90113d1289875739-populating-a-list-of-every-entry-in-column-r-when-42111-is-made-in-column-f-dpr-2010-try-again
Sheet: Charts

 |  |  |  |  | Problem Scrap Dies
 | Oct |  | 57688-0C030 | 61343-0E040 | 61211/2-0E040 | 57663-0E040 | 55133/4-0C020 | 61413/4-0E030/40 | 61381-0E040 | 51145/6-04010/20 | 55712-08040
 | ER's | 7 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2
 | Hrs | 4 | 0.75 | 1.25 | 1.75 | 0.5 | 0.75 | 0.5 | 0.5 | 0.25 | 0.5
 |  |  |  |  | [NAME]
 |  |  | 48514-0C010 | 61323/4-0E040 | 57117/8-0E010 | 42111-08030 | 57162-0E010 | 48711/2-08010 | 48624-08030 | 42111-02070 | 55712-08040
 | ER's | 12 | 8 | 7 | 7 | 7 | 6 | 6 | 6 | 6 | 5
 | Hrs | 5.75 | 2.5 | 1.25 | 2 | 2.5 | 2 | 2.75 | 1.5 | 1.5 | 2
 |  | [NAME] | Fingers | Marks on part | Mis-stamp | Human error | Breakage | [NAME] | Breakage | Fingers | Splits
 |  | Scrap Issue | Mis-stamp | Marks on part | Fingers | Breakage | Press Set-up | Breakage | Fingers | Marks on part | Scrap Issue
 |  | Scrap Issue | Press Set-up | Fingers | Marks on part | Fingers | Die not written up | Breakage | Fingers | Die not written up | Press Issues
 |  | Human error | Human error | Press Issues | Scrap Issue | Fingers | O/L burr | Human error | Human error | Gauld | Scrap Issue
 |  | Scrap Issue | Gauld | Human error | Mis-stamp | Press Issues | O/L Burr | [NAME] | Mis-stamp | Out of Spec | Marks on part
 |  | Scrap Issue | Human error | Scrap Issue | [NAME] | Fingers | O/L Burr | Scrap Issue | Mis-stamp | O/L Burr
 |  | Scrap Issue | Human error | O/L Burr | [NAME] | Fingers
 |  | Gauld | [NAME]
 |  | Gauld
 |  | [NAME]
 |  | Scrap Issue
 |  | Scrap Issue
Spreadsheet: 200832d1355776815-getting-data-in-adjacent-cell-to-calculate-data-example_001-ardais-oeldere-
Sheet: Sheet1

1 | 234
2 | 3267
3 | 346 |  |  | Divisor | 20
4 | 9345 |  |  | enter number (1-9) | 7
5 | 5345 |  |  | Result | B7 / F3
6 | 4456
7 | 7942
8 | 34537
9 | 348
Spreadsheet: 166045d1341437203-have-a-cell-display-a-value-based-on-the-value-of-a-cell-next-to-it-from-a-table-i-think-nutrition
Sheet: Ingredients

 | Per | Calories |  |  |  |  |  |  |  |  | calories/gram |  |  | 1 Cup | [NAME]
 |  | Carbs | Fat | Protein | Total |  |  |  |  | carb | 9
Sweet potato | 100 | 83.2 | 1.3 | 5.6 |  |  |  |  |  | fat | 4
Egg | 1 | 2.2 | 47.9 | 27.4 |  |  |  |  |  | protein | 4
Lettuce | 100 | 10.6 | 1.2 | 2.2 |  |  |  |  |  | alcohol | 7
Apple | 1 | 90.4 | 2.6 | 1.6
Clementine | 1 | 31.7 | 0.9 | 2.1
Lemon juice | 100
Tomato | 1
[NAME] | 100
Cottage Cheese | 100 | 12.7 | 37.8 | 47.5
[NAME] | 1 | 97.4 | 3.3 | 4.3
Porridge | 100
Milk semi-skimmed | 100
Snack a jack | 1
Bread (brown) | 1
Pasta (brown) | 100
Pasta (white) | 100
Tomato -Tinned | 1
Olive Oil | 100 | 0 |  | 0
Avocado | 100
Nectarine | 1 | 53.6 | 3.8 | 5.1
Oat Cakes
Cheddar Cheese
Syrup waffles
Activia (low fat)
Activia
Quark
Spreadsheet: 80980d1281250459-ranking-sorting-formula-rank-sorted_unsolved
Sheet: Sheet1

[NAME]
2 | Test 1 | 2 | 2Test 1
4 | Test 2 | 3 | 4Test 2
1 | Test 3 | 1 | 1Test 3
2 | Test 4 | 2 | 2Test 4
5 | Test 5 | 4 | 5Test 5
SORTED
1 | Test 3 | 1
2 | Test 1 | 2
2 | Test 1 | 2
4 | Test 2 | 3
5 | Test 5 | 4
Spreadsheet: 22cf5b11-d586-4ce4-968f-68523761b991
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Finance: Banking and Related Services
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Banking and Related Services Pathway of the Finance [NAME]) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Banking and Related Services Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Abstractor ►Accountant ►Acquisitions Specialist ►Bill and Account Collector ►Branch Manager ►Compliance Officer ►Credit Analyst ►Credit Report Provider ►Customer Service Representative ►Data Processor ►Debt Counselor ►Financial Manager ►Financial Planner ►Internal Auditor ►Loan Officer ►Loan Processor ►Mortgage Broker ►Network Services Technician ►Operations Manager ►Relationship Manager ►Repossession Agent ►Teller ►Title Researcher and Examiner ►Trust Officer
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 793720d1661674683-populate-cells-with-filtered-data-from-2-cells-quote-sheet
Sheet: Sheet3

QUOTE SHEET
Customer |  |  |  | Price Level
Items | Price Each | Quantity | Total Price Panel Type
Spreadsheet: 781009d1652942470-shortout-results-by-subject-wise-and-satisfactory-wise-sample-shortout
Sheet: Results

 | Date of Test | Domain | Name | Location | Side | Subject | Item | Activity | Defects | Required | Test Status | Comments / Corrective Measures required | incharge | Remarks |  |  | Document |  | Subject | Total Tests | Satisfactory | UnSatisfactory
 | 2022-05-02 00:00:00 |  | NA |  | LHS | English | 1 semister | Chapters 1 to 5 | Avg. 35.48 Mpa |  | Satisfactory |  |  |  |  |  |  |  | English | 3 | 2 | 1
 | 2022-05-02 00:00:00 |  |  |  |  | Maths | 1 semister | Chapters 1 to 5 | MDD = 1.955 g/cc, OMC =10.25% |  | Satisfactory |  |  |  |  |  |  |  | Maths | 4 | 2 | 2
 | 2022-05-04 00:00:00 |  |  |  |  | English | 1 semister | Chapters 1 to 5 | 0.048 |  | Satisfactory |  |  |  |  |  |  |  | Science | 2 | 1 | 1
 | 2022-05-04 00:00:00 |  |  |  |  | Maths | 1 semister | Chapters 1 to 5 | Avg. 36.05 Mpa |  | Unsatisfactory |  |  |  |  |  |  |  | Social | 1 | 1 | 0
 | 2022-05-05 00:00:00 |  |  |  |  | English | 1 semister | Chapters 1 to 5 | Witnessing of Extraction test for DBM -2 mix (VG-40). |  | Unsatisfactory
 | 2022-05-05 00:00:00 |  |  |  |  | Science | 2 semister | Chapters 5 to 8 | Avg. 36.05 Mpa |  | Satisfactory
 | 2022-05-05 00:00:00 |  |  |  |  | Maths | 2 semister | Chapters 5 to 8 | Avg. 2.774 |  | Satisfactory
 | 2022-05-06 00:00:00 |  |  |  |  | Maths | 2 semister | Chapters 5 to 8 | [NAME]. 36.44 Mpa |  | Unsatisfactory
 | 2022-05-06 00:00:00 |  |  |  |  | Science | 3 semister | Chapters 5 to 9 | [NAME]. 4.59 Mpa |  | Unsatisfactory
 | 2022-05-06 00:00:00 |  |  |  |  | Social | 1 semister | Chapters 1 to 5 | MDD = 2.011 g/cc, OMC = 10.22% |  | Satisfactory
 | 2022-05-07 00:00:00 |  |  |  |  |  |  |  | [NAME]. 9.04 Mpa
 | INPUT DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OUTPUT DATA- REQUIRED FORMULAS
Spreadsheet: 766618d1643968063-pulling-dates-automatically-if-criteria-matches-numbers-ans
Sheet: cross check

 |  |  |  |  |  |  |  | Numbers drawn |  |  |  |  |  |  | Ive input dates manually to get required result
 | Num 1 | Num 2 | Num 3 | Num 4 | Num 5 | Num 6 |  | 1 | 2 | 3 | 4 | 5 | 6
 | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  |  |  |  |  | 2020-12-16 00:00:00
 | 1 | 2 | 3 | 4 | 5 | 13 |  |  |  |  |  |  |  |  | 2020-12-18 00:00:00 | Q3 is fine please don’t do anything to this
 | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00
 | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  | 2020-12-22 00:00:00
 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-24 00:00:00
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do I get dates to populate automatcially between p3:p8?
Spreadsheet: 107422d1304598342-double-lookups-book1
Sheet: Sheet1

 | A | B | C | D | E | F | G | H | I | J
1 | Years | 1 | 2 | 3 | 4 | Years | 1 | 2 | 3 | 4
2 |  |  |  |  |  | 1
3 |  |  |  |  |  | 2
4 |  |  |  |  |  | 3
Spreadsheet: 56303988-b96b-416b-838c-7c7639ec930b
Sheet: Page 9

Permit No.: |  |  | WQ0028552 |  |  | Facility Name: |  | Briar Chapel Development |  |  |  |  |  | County: | Chatham |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | C-12B |  | Field Name: |  | C-12C |  | Field Name: |  | C-12D |  | Field Name: |  | C-13A
 |  |  |  |  |  | Area (acres): |  | 2.6 |  | Area (acres): |  | 3.4 |  | Area (acres): |  | 0.4 |  | Area (acres): |  | 0.4
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 19.95 |  | Annual Rate (in): |  | 37.31 |  | Annual Rate (in): |  | 37.31 |  | Annual Rate (in): |  | 19.95
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 122418d1316790236-range-of-cells-question-summary-0911b
Sheet: LA

September 2011
Home Facility | Employee | Shared Facility | Job Code | Rate of Pay | Hours Shared | OT Hours Shared | Wages | OT Wages
Claiborne |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Gonzales |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Iberia North |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Iberia South |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
[NAME] |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Lafayette |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Many North |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Marrero |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Meadowview |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
[NAME] |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Pierremont |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
[NAME] |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Vivian |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Spreadsheet: 779455d1651785447-dividing-cell-into-equal-amounts-in-multiple-cells-22-pallet-log-pallet-sample
Sheet: Pallet Log

Font - Wingdings 2 |  |  |  |  |  | Print: |  |  | #1 | #2 | #2 |  |  |  | #3 | #4+ (if needed)
Shift & P in Columns F, G & H to get Checkmark
Shift & O in Columns T, U, V, & W to get X
Shift & U in Columns T, U, V, & W to get X in circle
Shift & T in Columns T, U, V, & W to get X in square
Enter |  |  |  |  |  | Enter |  |  | White Sheets | Envelopes | Pull for Didde & for EPS | Enter |  | Web Shts x2 | Total Sheets (with extras) | Color Sheets               (multiple EPS)
Date | Job # |  | Customer Name | Job Name |  | P.B. | S.S. | O.S. |  |  |  | # of Pallets |  |  |  | 1 EPS | 2 EPS | 3 EPS | 4 EPS | 5 EPS
 |  |  |  |  |  | Pink | Blue | White |  |  |  | Didde | Web
xxxxx | # | xxxxx | xxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxx |  | P |  |  |  |  |  | 5 | 512
xxxxx | # | xxxxx | xxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxx |  |  | P |  |  |  |  | 0 | 12
xxxxx | # | xxxxx | xxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxx |  |  | P |  |  |  |  | 22 | 400
xxxxx | # | xxxxx | xxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxx |  | P |  |  |  |  |  | 0 | 24