tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715134d1611582302-count-of-last-number-from-an-array-between-two-values-counttest
Sheet: Sheet1 orig

 | Count of values between 0.5 and 2.5 among the last 3 instances of each | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00
Alpha |  | 4 |  |  | 3 |  | 4 | 2 |  | 3 |  |  | 2
Beta |  | 0 |  |  | 2 |  | 1 | 3 |  | 0
Gamma |  | 2 |  | 3 |  | 2 |  | 0 | 1 |  | 3 |  |  |  | 1
Delta |  | 1 |  | 1 |  | 2 |  | 3 | 3 |  | 4 |  |  |  | 3
Epsilon |  | 3 |  | 0 |  | 1 |  | 2 | 0 |  | 1 |  |  |  | 2
Zeta |  | 3 |  | 0 |  | 2 |  | 0 | 0 |  | 0 |  |  |  | 2
Eta |  | 0 |  | 3 |  | 7 |  |  | 2 |  | 1 |  | 1
Theta |  | 2 |  | 5 |  | 5 |  |  | 5 |  | 4 |  | 2
Iota |  | 1 |  | 1 |  | 0 |  |  | 1 |  | 0
Kappa |  | 3 |  | 2 |  | 2 |  |  | 3 |  | 1 |  | 2
Lamda |  | 1 |  | 1 |  | 1 |  |  | 3 |  |  |  | 2
Spreadsheet: 69553d1270081259-counting-text-pairs-in-a-string-of-text-ie-aa-gc-etc-dna
Sheet: Sheet1

 |  | Original String |  | Compacted String |  |  | Pairs: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | GTA AAA CGA |  | GTAAAACGA |  |  |  | GT | TA | AA | AA | AA | AC | CG | GA
Pair | # of Pairs
GT | 1
TA | 1
AA | 3
AC | 1
CG | 1
GA | 1
Spreadsheet: 75012d1275536458-naming-an-array-formula-scratch
Sheet: Sheet1

 |  |  | Data >>>>>>>>>>>>>>>>>
 | Formula>> | 2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Named [NAME]>> | 2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Formula>> | 1 | 1 | 2 | 3 | 1
 | Named [NAME]>> | 1 | 1 | 2 | 3 | 1
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0126

 | Date: | 2013-01-26 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 11 | 80.59
 | 11:00:00 | 56 | 389.24
 | 12:00:00 | 70 | 514.99
 | 13:00:00 | 66 | 520.19
 | 14:00:00 | 50 | 341.91
 | 15:00:00 | 56 | 309.07
 | 16:00:00 | 30 | 188.36
 | 17:00:00 | 40 | 265.99
 | 18:00:00 | 50 | 363.14
 | 19:00:00 | 42 | 348.16
 | 20:00:00 | 29 | 205.76
 | 21:00:00 | 40 | 240.51
 | 22:00:00 | 30 | 244.3
 | 23:00:00 | 27 | 175.3
 | 1900-01-01 00:00:00 | 14 | 132.14
 | 1900-01-01 01:00:00 | 21 | 160.16
 | 1900-01-01 02:00:00 | 15 | 105.54
 | 1900-01-01 03:00:00 | 5 | 57.15
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: eric_saibi__9721__010802R
Sheet: Hatch 02

Owner Name |  | Georgia Power Company.
Station Name |  | Edwin I Hatch Nuclear Power Station
Unit Name |  | Hatch 02
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Nuclear
Capacity |  | 865 MW
Start Date |  | 2001-12-25 00:00:00
End Date |  | 2002-01-09 00:00:00
Prv. Start Date |  | 2001-12-25 00:00:00
Prv. End Date |  | 2002-01-08 00:00:00
Comments |  | Steam bypass valve problem.
SIC |  | 4911
Plant ID |  | 1012040
Unit ID |  | 1004272
Outage ID |  | 19297
Spreadsheet: 822215d1679181641-distribute-quantity-according-to-order-price-example-almost-almost-done-
Sheet: Sheet1

 |  | Valor | Valor Filter | Qtds | [NAME] |  |  |  |  |  |  |  |  |  |  | 1.
 | Somatório:
 | 1. total
Susp | 2. total - artigos infarmed = susp
[NAME] | 2. total - artigos infarmed = notif
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p | q | r | s | t | u | v | w | x | y | z | aa | ab | ac | ad | ae | af | ag | ah | ai | aj | ak | al | am | an | ao | ap | aq | ar | as | at | au | av | aw | ax | ay | [NAME] | ba | bb | bc
Code | Product | Infarmed | Preço  Médio | Preço  Mín. | BP | # Initial Orders | # Final Orders | ∑ Initial Orders | ∑ Final Orders | € Total | Qtd Total | Stock Total | BP 1 | BP 2 | Quantity | Price | Aloca | Total
5665468 | A |  |  |  |  |  |  |  |  |  |  | 1234 |  |  | 1 | 32 |  |  | 2 | 3 |  |  | 40 | 21 |  |  | 20 | 54 |  |  | 12 | 5 |  |  | 1 | 9 |  |  | 3 | 4 |  |  | 1 | 5 |  |  | 12 | 23 |  |  | 1 | 67
5056387 | B
Spreadsheet: 301056d1393638817-massaging-text-to-columns-data-date-sample2
Sheet: Sheet1

Date | Buy | Sell | Security | Price | Cost | Proceeds | Commission
2014-10-20 00:00:00 | 100 |  | SANDISK CORP | 46 | 4607 |  | 7
2014-10-20 00:00:00 |  | 100 | SANDISK CORP | 46.07 |  | 4599.92 | 7
2014-10-24 00:00:00 | 100 |  | SANDISK CORP | 46.22 | 4629 |  | 7
2014-10-26 00:00:00 |  | 100 | SANDISK CORP | 48.08 |  | 4800.91 | 7
2014-11-02 00:00:00 | 100 |  | SANDISK CORP | 52.28 | 5235 |  | 7
2014-11-02 00:00:00 |  | 100 | SANDISK CORP | 53.24 |  | 5316.89 | 7
2014-11-02 00:00:00 | 100 |  | SANDISK CORP | 52.55 | 5262 |  | 7
2014-11-02 00:00:00 |  | 100 | SANDISK CORP | 53.1 |  | 5302.89 | 7
2014-11-03 00:00:00 | 200 |  | SANDISK CORP | 51.5 | 10307 |  | 7
2014-11-04 00:00:00 | 100 |  | SANDISK CORP | 49.05 | 4912 |  | 7
2014-11-04 00:00:00 |  | 100 | SANDISK CORP | 49.2 |  | 4912.9 | 7
Spreadsheet: 8c512095-6e90-4e03-b507-da5b52df7c9b
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
42192632 | 2014-07-07 01:30:28 | ALLIES | 1 | 4 | 1 | 385172 | Brode Warrior | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42192723 | 2014-07-07 01:39:47 | AXIS | 0 | 2 | 4 | 385172 | Brode Warrior | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42193393 | 2014-07-07 02:49:14 | ALLIES | 0 | 3 | 7 | 560655 | fellini33 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42193611 | 2014-07-07 03:12:53 | AXIS | 1 | 7 | 6 | 560655 | fellini33 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42222044 | 2014-07-09 02:44:53 | ALLIES | 1 | 5 | 2 | 1024315 | dangie | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42222163 | 2014-07-09 03:00:07 | AXIS | 0 | 2 | 5 | 1024315 | dangie | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42235264 | 2014-07-10 02:11:22 | ALLIES | 0 | 4 | 6 | 1024315 | dangie | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
42235505 | 2014-07-10 02:32:40 | AXIS | 1 | 6 | 2 | 1024315 | dangie | 12503 | eastern | 1941-07-22 | 1941-07-22 | Lipovec | Lipovec
42236126 | 2014-07-10 03:31:15 | ALLIES | 1 | 7 | 6 | 1024315 | dangie | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42236321 | 2014-07-10 03:43:18 | AXIS | 1 | 7 | 2 | 1024315 | dangie | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42236492 | 2014-07-10 04:07:32 | AXIS | 1 | 6 | 4 | 1007284 | Temple58 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42236675 | 2014-07-10 04:22:29 | ALLIES | 1 | 6 | 2 | 1007284 | Temple58 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42261987 | 2014-07-12 01:42:02 | ALLIES | 1 | 6 | 3 | 1024315 | dangie | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42262142 | 2014-07-12 02:02:45 | AXIS | 0 | 5 | 6 | 1024315 | dangie | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42269923 | 2014-07-12 16:20:25 | ALLIES | 0 | 5 | 6 | 1024315 | dangie | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
42270114 | 2014-07-12 16:37:15 | AXIS | 1 | 6 | 5 | 1024315 | dangie | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
42346676 | 2014-07-18 02:32:26 | ALLIES | 1 | 7 | 6 | 1024315 | dangie | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42346901 | 2014-07-18 02:55:16 | AXIS | 0 | 5 | 7 | 1024315 | dangie | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42388544 | 2014-07-21 03:19:54 | ALLIES | 1 | 6 | 4 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42388733 | 2014-07-21 03:39:25 | AXIS | 0 | 4 | 6 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 233461d1367821861-supplier-vendors-or-expense-invoice-tracking-copy-of-sales-invoice-tracker
Sheet: Invoices - Main

 | Invoices EUR
 | Invoice # | Company | Invoice Date | Project | Tax Rate | Other | Deposit | Detail Total | Invoice Total | Notes
 | 13-04-10-$008 | 1 - customer a | 2013-04-10 00:00:00 | project c
 | 13-04-01-$007 | 1 - customer a | 2013-04-01 00:00:00 | project c
 | 13-04-04-€006 | 99 - customer b | 2013-04-04 00:00:00 | project b |  |  |  |  |  | SENT
 | 13-03-27-$005 | 1 - customer a | 2012-03-27 00:00:00 | project c
 | 13-03-22-$004 | 1 - customer a | 2013-03-22 00:00:00 | project a
 | 13-03-21-$003 | 1 - customer a | 2013-03-21 00:00:00 | project y
 | Totals
Spreadsheet: 172909fb-bf08-42ea-9c8a-c275f0289967
Sheet: Ethnicity - Fall Native Hawn

Return to Contents
Ethnicity - Native Hawaiian or Part Hawaiian
 |  |  |  | UH | UH COMMUNITY COLLEGES
 |  | UH | UH | WEST
 | TOTAL | MĀNOA | HILO | O‘AHU | SUBTOTAL | Hawaii | Honolulu | Kapi‘olani | Kaua‘i | Leeward | Maui | [NAME]
1977 | 1596 | 333 | 84 | 14 | 1165 | 174 | 268 | 183 | 70 | 273 | 80 | 117
1978 | 1789 | 382 | 93 | 16 | 1298 | 206 | 300 | 201 | 74 | 276 | 124 | 117
1979 | 1896 | 414 | 78 | 10 | 1394 | 218 | 302 | 212 | 74 | 310 | 125 | 153
1980 | 2523 | 580 | 116 | 17 | 1810 | 286 | 370 | 281 | 90 | 414 | 173 | 196
1981 | 3462 | 817 | 135 | 34 | 2476 | 380 | 561 | 369 | 144 | 539 | 241 | 242
1982 | 3978 | 962 | 157 | 39 | 2820 | 454 | 576 | 443 | 142 | 633 | 328 | 244
1983 | 3881 | 991 | 180 | 39 | 2671 | 421 | 516 | 428 | 131 | 614 | 318 | 243
1984 | 3717 | 978 | 164 | 46 | 2529 | 348 | 478 | 435 | 138 | 593 | 314 | 223
1985 | 3694 | 986 | 193 | 48 | 2467 | 351 | 484 | 402 | 141 | 541 | 294 | 254
1986 | 3696 | 921 | 232 | 49 | 2494 | 343 | 439 | 395 | 157 | 536 | 337 | 287
1987 | 3889 | 931 | 258 | 52 | 2648 | 401 | 471 | 456 | 136 | 546 | 349 | 289
1988 | 3914 | 972 | 259 | 44 | 2639 | 386 | 467 | 489 | 159 | 517 | 350 | 271
1989 | 4158 | 1040 | 296 | 57 | 2765 | 424 | 562 | 501 | 179 | 560 | 338 | 201
1990 | 4517 | 1123 | 436 | 67 | 2891 | 402 | 532 | 530 | 184 | 616 | 342 | 285
1991 | 4989 | 1246 | 447 | 77 | 3219 | 490 | 493 | 568 | 206 | 722 | 453 | 287
1992 | 5511 | 1332 | 518 | 74 | 3587 | 560 | 549 | 595 | 233 | 777 | 489 | 384
1993 | 5879 | 1399 | 557 | 73 | 3850 | 656 | 560 | 671 | 268 | 857 | 443 | 395
1994 | 6437 | 1514 | 529 | 86 | 4308 | 824 | 625 | 728 | 268 | 878 | 526 | 459
1995 | 6386 | 1562 | 542 | 81 | 4201 | 824 | 587 | 711 | 265 | 812 | 543 | 459
Note: Data may not match [NAME] reports due to changes in enrollment counting methodology.
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.06.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-06 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 12 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 25 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 1 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 22 | 0 | 6 | 0 | 1 | 1 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 3 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 3 | 0 | 0 | 0 | 1 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-06 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 8 | 0 | 2 | 2 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 1 | 1 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 0 | 3 | 1 | 2 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 22 | 0 | 6 | 1 | 3 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 7 | 0 | 4 | 0 | 1 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 4 | 0 | 5 | 1 | 2 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 9 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 882430d1730814893-sorting-of-concatenated-cell-sortingbook
Sheet: Sheet1

a | 10:00:00
[NAME] | 02:00:00
frefe | 05:00:00
sadas | 17:00:00
qweqwe | 01:00:00
asdasd | 00:00:00
yxcyxc | 23:00:00
frwef | 14:00:00
jztjtz | 15:00:00
qweqwe | 07:00:00
asdasd | 06:00:00
qweqwe | 02:00:00
Spreadsheet: 469866d1468227156-conditional-color-of-bubbles-in-bubble-chart-bubble-chart
Sheet: Sheet1

 |  | Supplier | % of total spend | Hourly rate | Evaluation Score (1-5) | Financial risk (red circle if = 1)
 |  | Apple | 0.5 | 800 | 3 | 1
 |  | Pear | 0.18 | 900 | 4 | 0
 |  | Orange | 0.32 | 1000 | 5 | 0
Spreadsheet: 767848d1644674408-creating-multiple-dependent-dropdown-lists-from-the-same-target-cell-example-70-ans
Sheet: Sheet2

 |  |  | Model
 |  |  | [NAME]
 |  |  | iPhone_SE
 |  |  | iPhone_13
 |  |  |  |  |  | =IF($D2="iPhone_12","Sheet2!$F$16:$F$18",IF($D2="iPhone_SE","Sheet2!$F$24:$F$27",IF($D2="iPhone_13","Sheet2!$F$33:$F$37","")))
 |  |  |  | [NAME] |  | =IF($D2="iPhone_12","Sheet2!$E$16:$E$18",IF($D2="iPhone_SE","Sheet2!$E$24:$E$26",IF($D2="iPhone_13","Sheet2!$E$33:$E$36","")))
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 64GB | Black
 |  |  |  | 128GB | White
 |  |  |  | iPhone_SE
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 64GB | Black
 |  |  |  | 128GB | White
 |  |  |  |  | Red
 |  |  |  | iPhone_13
 |  |  |  | Storage | Colour
 |  |  |  | Any | Any
 |  |  |  | 128GB | Starlight
 |  |  |  | 256GB | Midnight
 |  |  |  | 512GB | Red
 |  |  |  |  | Pink
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -20864 | -19960
2 | -20875 | -19960
3 | -20001 | -19960
4 | -19998 | -19960
5 | -20583 | -19738
6 | -20425 | -19793
7 | -20729 | -19793
8 | -19999 | -19960
9 | -20900 | -19960
10 | -19998 | -19960
11 | -19998 | -19960
12 | -13793 | -19793
13 | -26751 | -19960
14 | -20012 | -19960
15 | -20003 | -19960
16 | -19996 | -19960
17 | -10606 | -19960
18 | -19912 | -19960
19 | -18547 | -19960
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 177959
2002-02-19 00:00:00
CBS Dollars
 |  |  | 181376
Spreadsheet: 120232d1315110134-excel-2007-removing-duplicates-between-two-text-in-a-column-yesnoyesno
Sheet: Sheet1

Data | Helper | Answer
yes | yes | yes
 | yes
yes | yes
 | yes
no | no | no
no | no
 | no
yes | yes | yes
 | yes
no | no | no
yes | yes | yes
yes | yes
no | no | no
Spreadsheet: marie_heard__24508__Peoples Energy Production
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: | 2001-08-13 00:00:00 | DEAL MAKER:
COUNTERPARTY: | Peoples Energy Production | CONTACT: | [NAME]
ADDRESS: | 205 N Michigan | TITLE: | Credit Manager
 | Ste 4216 | PHONE: | [PHONE]
 | Chicago IL, 60601 | FAX: | [PHONE]
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) | Peoples Energy Corporation (A+) | Enron Corp. (BBB+)
LIMIT $ MILLIONS | $4MM | $10MM
Incorporation State |  | Oregon
ELEGIBLE SWAP PARTICIPANT
Counterparty | YES | YES
Guarantor
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | $4MM | $10MM
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = S&P/Moody's | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | $30MM | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-3596
Spreadsheet: 215665d1361450263-extracting-rows-from-a-spreadsheet-based-on-a-unique-code-that-may-appear-in-two-columns-example
Sheet: Sheet2

2626/05 |  | Rows Match
Spreadsheet: 266834d1379778081-intercompany-consolidation-model-consolidation-example
Sheet: Company Consolidation

 |  |  |  | 2014
Contract | Waste Type | Source | Destination | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
A | Black bag | households | transfer depot 123 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 120
A | Plastic | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
A | Paper and Card | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
B | Black bag | transfer depot 123 | landfill | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 120
B | Plastic | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
B | Paper and Card | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | subtotal | 480
Above, the subtotal of 480 is wrong as 120 black bag is counted twice when there is only 120 tonnes of black - each contract just deals with a different Part of its journey
Below is what I need to get to - It needs to be as automated as possible from the individual contract sheets
 |  |  |  | 2014
Contract | Waste Type | Source | Destination | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
A | Plastic | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
A | Paper and Card | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
B | Black bag | transfer depot 123 | landfill | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 120
B | Plastic | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
B | Paper and Card | households | sold | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | subtotal | 360
It’s the end destination that is important for the company consolidation, not the transfer depot record so I want to remove the first black bag record without having to look through all the double counts manually as there will be a lot of them!
Spreadsheet: 215071d1361255849-if-statement-to-evaluate-the-next-record-get-data-with-index2
Sheet: Sheet1

 | Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7
Spreadsheet: 88846d1288689988-index-and-match-multiple-values-hotel-report
Sheet: Hotel Rooms

 | 2010-11-01 00:00:00 | 2010-11-02 00:00:00 | 2010-11-03 00:00:00 | 2010-11-04 00:00:00 | 2010-11-05 00:00:00 | 2010-11-06 00:00:00 | 2010-11-07 00:00:00 | 2010-11-08 00:00:00 | 2010-11-09 00:00:00 | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | 2010-11-12 00:00:00 | 2010-11-13 00:00:00 | 2010-11-14 00:00:00 | 2010-11-15 00:00:00 | 2010-11-16 00:00:00 | 2010-11-17 00:00:00 | 2010-11-18 00:00:00 | 2010-11-19 00:00:00 | 2010-11-20 00:00:00 | 2010-11-21 00:00:00 | 2010-11-22 00:00:00 | 2010-11-23 00:00:00 | 2010-11-24 00:00:00 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2010-11-27 00:00:00 | 2010-11-28 00:00:00 | 2010-11-29 00:00:00
902
903
904
905
906
909
1110
1110a
1113
1113a
1201
1202
1203
1204
1205
1206
1209
1210
1211
1309
1310
2602
2702
2703
2704
2705
2709
2710
2711
2712
2713
2714
2715
2802
2805
2809
2810
2811
2812
2813
2814
2815
2816
2903
2904
2905
2909
2910
2911
2912
2913
2914
2915
2916
3003
3004
3005
3009
3010
3011
3012
3013
3014
3015
Spreadsheet: 3183af85-71b3-42ff-bd7c-76931c47827f
Sheet: Sheet1

Select Any Combination of Series With Checkboxes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  |  |  |  | Checkbox Cell Links
 | True | False | True |  |  | Chart Source Data
 | Y1 | Y2 | Y3 | Y1 |  | Y3
1 | 3 | 9 | 5 | 3 |  | 5
2 | 3 | 4 | 7 | 3 |  | 7
3 | 4 | 5 | 9 | 4 |  | 9
4 | 5 | 5 | 6 | 5 |  | 6
Spreadsheet: 36527d1234387005-conditional-formatting-golf-league
Sheet: Sheet1

Player | Quota | Week 1 | Quota | Week 2 | Quota | Week 3 | Quota | Week 4 | Quota | Week 5 | Quota | Week 6 | Quota | Week 7 | Quota | Week 8 | Quota | Week 9 | Quota | Week 10 | Quota | Week 11 | Quota | Week 12 | Quota | Week 13 | Quota | Week 14 | Quota | Week 15 | Quota | Week 16 | Quota
Kremel | 23 | 26 | 24 | 28 | 26
Crank | 22
Sweet | 22
[NAME] | 20
T. Hennecke | 19
Scherbarth | 19
Jambois | 19
March | 18
Shaw | 17
Ga. Schroeder | 17
Gr. Schroeder | 17
Kinney | 17
[NAME] | 16
Wilson | 15
Stelter | 15
Kral | 15
Boney | 13
[NAME] | 13
Langley | 11
Hepner | 8
 |  |  | Calculated |  |  | =IF(C2>0,B2+IF(C2>0,CHOOSE(C2-B2,1,1,1,2,2,3),CHOOSE((C2-B2)*-1,-1,-1,-10,-2,-2,-3)),"")
 |  |  |  |  |  | if change is 1 it chooses      if 2 it chooses Etc.  If -1 it chooses    If -2 it chooses…
Spreadsheet: 15a4c88f-c78a-49c1-b1c2-4842411e2e71
Sheet: Sheet1

SCHOOL YEAR: ______________ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
DISTRICT NUMBER-TYPE: ______________
DISTRICT NAME: __________________________
Folder Number | Social Security Number | Staff Name (last name, first, middle initial) | Sex | [NAME] (Year, Month, Day) | Ethnic Code | New Staff Code | Inact/ Transf | Contract Salary | Ed Level | Contract Days | Years of Experience       Supt/ Princ/ Teach/ Other            --    --    --    -- | Out of Dist (Y, N) | Full/ Part Time (F, P) | Hispanic Y/N | American Indian or Alaskan Native    Y/N | Asian    Y/N | Native Hawaiian or Pacific Islander   Y/N | Black or African Anerican Y/N | White      Y/N
Spreadsheet: 699812d1602775185-convert-vertical-values-to-horizontal-with-formula-in-excel-salesid_okaynow_5
Sheet: Sheet1

Data Year (Fiscal) | Sales ID | Sales Count |  | Sales Count
2012 | 1 | 6 |  | 2012 | 6 | 7 | 17 | 7 | 11 | 5
2012 | 1 | 7 |  | 2011 | 7 | 23 | 29 | 92 | 7 | 18 | 78 | 19 | 59 | 73 | 32 | 57 | 89 | 23 | 28 | 96
2012 | 1 | 17
2012 | 1 | 7
2012 | 1 | 11
2012 | 1 | 5
2011 | 1 | 7
2011 | 1 | 23
2011 | 1 | 29
2011 | 1 | 92
2011 | 1 | 7
2011 | 1 | 18
2011 | 1 | 78
2011 | 1 | 19
2011 | 1 | 59
2011 | 1 | 73
2011 | 1 | 32
2011 | 1 | 57
2011 | 1 | 89
2011 | 1 | 23
2011 | 1 | 28
2011 | 1 | 96
Spreadsheet: 220812d1363272258-formatting-display-problem-wip-sales-order-form
Sheet: PINK

PINK
 |  |  |  |  |  |  | Electropatent Order Number
Invoice Address |  |  |  |  | Delivery Address
Customer  Order No. |  |  |  | Date  Received |  | Salesman |  | Customer  A/CNo.
Date Order Required & Special Delivery Instructions
Special Delivery Instructions.
Product Code |  | Description / Information |  |  |  | Qty | Unit Price | Discount | Total
 |  | Carriage |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total