tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 12b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending January 4, by product type and supermajor currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency 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: 870696d1717160906-i-have-a-problem-with-solving-a-matrix-matrix
Sheet: Sheet1

-1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | -2 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 1 | 0 | -4 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
1 | 0 | 1 | 0 | 1 | -4 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 1 | 0 | 1 | 1 | 0 | -4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | -4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | -4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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: 155815d1337063830-problem-with-vlookup-using-date-and-time-vlookupexample
Sheet: Sheet2

2002-08-28 00:00:00 | 18:59:00 |  |  | 110.73 | 110.65
2002-08-29 00:00:00 | 09:21:00 |  |  | 110.86 | 110.6
2002-08-29 00:00:00 | 10:18:00 |  |  | 110.98 | 110.78
2002-08-29 00:00:00 | 11:41:00 |  |  | 110.96 | 110.85
2002-08-29 00:00:00 | 14:12:00 |  |  | 110.93 | 110.8
2002-08-29 00:00:00 | 14:53:00 |  |  | 111.04 | 110.86
2002-08-29 00:00:00 | 15:39:00 |  |  | 111.03 | 110.94
2002-08-29 00:00:00 | 16:15:00 |  |  | 111.02 | 110.76
2002-08-29 00:00:00 | 16:52:00 |  |  | 110.86 | 110.72
2002-08-29 00:00:00 | 18:26:00 |  |  | 110.9 | 110.75
2002-08-29 00:00:00 | 18:59:00 |  |  | 110.78 | 110.63
2002-08-30 00:00:00 | 09:52:00 |  |  | 110.85 | 110.66
2002-08-30 00:00:00 | 11:16:00 |  |  | 111.01 | 110.82
2002-08-30 00:00:00 | 13:33:00 |  |  | 111.01 | 110.83
2002-08-30 00:00:00 | 14:58:00 |  |  | 111 | 110.84
2002-08-30 00:00:00 | 16:01:00 |  |  | 111.05 | 110.75
2002-08-30 00:00:00 | 16:24:00 |  |  | 110.88 | 110.65
2002-08-30 00:00:00 | 16:57:00 |  |  | 110.74 | 110.57
2002-08-30 00:00:00 | 18:40:00 |  |  | 110.86 | 110.61
2002-08-30 00:00:00 | 18:59:00 |  |  | 110.9 | 110.78
2002-09-02 00:00:00 | 10:00:31 |  |  | 111.13 | 110.89
2002-09-02 00:00:00 | 11:24:02 |  |  | 111.28 | 111.07
2002-09-02 00:00:00 | 14:16:21 |  |  | 111.31 | 111.17
2002-09-02 00:00:00 | 18:58:27 |  |  | 111.35 | 111.17
2002-09-02 00:00:00 | 18:59:59 |  |  | 111.31 | 111.29
2002-09-03 00:00:00 | 09:29:49 |  |  | 111.44 | 111.23
2002-09-03 00:00:00 | 11:01:39 |  |  | 111.42 | 111.28
2002-09-03 00:00:00 | 12:17:09 |  |  | 111.49 | 111.34
2002-09-03 00:00:00 | 13:44:32 |  |  | 111.51 | 111.29
2002-09-03 00:00:00 | 15:14:58 |  |  | 111.47 | 111.3
2002-09-03 00:00:00 | 16:06:12 |  |  | 111.68 | 111.31
2002-09-03 00:00:00 | 16:28:02 |  |  | 111.81 | 111.61
2002-09-03 00:00:00 | 16:54:22 |  |  | 111.91 | 111.73
2002-09-03 00:00:00 | 17:31:17 |  |  | 112 | 111.78
2002-09-03 00:00:00 | 18:39:49 |  |  | 112.07 | 111.82
2002-09-03 00:00:00 | 18:59:59 |  |  | 112.02 | 111.97
2002-09-04 00:00:00 | 09:15:55 |  |  | 112.2 | 112.05
2002-09-04 00:00:00 | 10:11:33 |  |  | 112.25 | 112.04
2002-09-04 00:00:00 | 10:56:31 |  |  | 112.13 | 111.83
2002-09-04 00:00:00 | 12:00:48 |  |  | 112 | 111.82
2002-09-04 00:00:00 | 14:23:18 |  |  | 112.01 | 111.85
2002-09-04 00:00:00 | 15:15:14 |  |  | 111.89 | 111.73
2002-09-04 00:00:00 | 16:02:19 |  |  | 111.95 | 111.73
2002-09-04 00:00:00 | 16:46:24 |  |  | 111.88 | 111.73
2002-09-04 00:00:00 | 18:08:23 |  |  | 111.95 | 111.78
2002-09-04 00:00:00 | 18:59:57 |  |  | 111.99 | 111.87
2002-09-05 00:00:00 | 09:31:14 |  |  | 111.84 | 111.58
2002-09-05 00:00:00 | 10:18:31 |  |  | 112.09 | 111.72
2002-09-05 00:00:00 | 11:25:16 |  |  | 112.15 | 111.94
2002-09-05 00:00:00 | 12:20:16 |  |  | 112.35 | 112.11
2002-09-05 00:00:00 | 14:09:22 |  |  | 112.45 | 112.3
Spreadsheet: 065d1db5-34ae-4dde-8e15-ba534759ab44
Sheet: Sheet1

 | QUALIFYING PRODUCTS
 | Reduced-Wattage T5HO [NAME]
 | Manufacturer | Product Name | Order Code | Model Number or Description | Shape/ Style | Watts | [NAME] (K) | Rated Life (hrs)1 | Initial Lumens | CRI
 | GE | T5HO [NAME] | 71627 | F54T5/830/WM/ECO | linear | 51 | 3000 | 25000 | 5000 | 85
 | GE | T5HO [NAME] | 71628 | F54T5/835/WM/ECO | linear | 51 | 3500 | 25000 | 5000 | 85
 | GE | T5HO [NAME] | 72629 | F54T5/841/WM/ECO | linear | 51 | 4100 | 25000 | 5000 | 85
 | GE | T5HO [NAME] | 71630 | F54T5/850/WM/ECO | linear | 51 | 5000 | 25000 | 4790 | 85
 | GE | T5HO [NAME] | 71631 | F54T5/865/WM/ECO | linear | 51 | 6500 | 25000 | 4790 | 85
 | GE | T5HO [NAME] | 62020 | F54T5/47W/830ECO | linear | 47 | 3000 | 30000 | 4800 | 84
 | GE | T5HO [NAME] | 62021 | F54T5/47W/835ECO | linear | 47 | 3500 | 30000 | 4800 | 84
 | GE | T5HO [NAME] | 62022 | F54T5/47W/841ECO | linear | 47 | 4100 | 30000 | 4800 | 84
 | GE | T5HO [NAME] | 62023 | F54T5/47W/850ECO | linear | 47 | 5000 | 30000 | 4600 | 84
 | GE | T5HO [NAME] | 62024 | F54T5/47W/865ECO | linear | 47 | 6500 | 30000 | 4550 | 84
 | Philips | Energy Advantage T5HO 49W | 220491 | F54T5/830/HO/EA/ALTO 49W | linear | 49 | 3000 | 25000 | 5000 | 85
 | Philips | Energy Advantage T5HO 49W | 220509 | F54T5/835/HO/EA/ALTO 49W | linear | 49 | 3500 | 25000 | 5000 | 85
 | Philips | Energy Advantage T5HO 49W | 220525 | F54T5/841/HO/EA/ALTO 49W | linear | 49 | 4100 | 25000 | 5000 | 85
 | Philips | Energy Advantage T5HO 49W | 220533 | F54T5/850/HO/EA/ALTO 49W | linear | 49 | 5000 | 25000 | 4850 | 82
 | Philips | Energy Advantage T5HO 49W [NAME] | 407296 | F54T5/835/HO/EA/ALTO 49W | linear | 49 | 3500 | 25000 | 5000 | 85
 | Philips | Energy Advantage T5HO 49W [NAME] | 407304 | F54T5/841/HO/EA/ALTO 49W | linear | 49 | 4100 | 25000 | 5000 | 85
 | Philips | Energy Advantage T5HO 49W [NAME] | 407528 | F54T5/850/HO/EA/ALTO 49W | linear | 49 | 5000 | 25000 | 4850 | 82
 | Sylvania | Pentron HO SS | 20434 | FP54/47W/830/HO/SS/ECO | linear | 47 | 3000 | 30000 | 4575 | 85
 | Sylvania | Pentron HO SS | 20435 | FP54/47W/835/HO/SS/ECO | linear | 47 | 3500 | 30000 | 4575 | 85
 | Sylvania | Pentron HO SS | 20447 | FP54/47W/841/HO/SS/ECO | linear | 47 | 4100 | 30000 | 4575 | 85
 | Sylvania | Pentron HO SS | 20448 | FP54/47W/850/HO/SS/ECO | linear | 47 | 5000 | 30000 | 4390 | 85
 | Sylvania | Pentron HO SS | 21070 | FP54/50W/835/HO/SS/ECO | linear | 50 | 3000 | 30000 | 5000 | 85
 | Sylvania | Pentron HO SS | 21071 | FP54/50W/830/HO/SS/ECO | linear | 50 | 3500 | 30000 | 5000 | 85
 | Sylvania | Pentron HO SS | 20964 | FP54/50W/830/HO/SS/ECO | linear | 50 | 4100 | 30000 | 5000 | 85
 | Sylvania | Pentron HO SS | 21072 | FP54/50W/830/HO/SS/ECO | linear | 50 | 5000 | 30000 | 4800 | 85
Spreadsheet: 82820d1282832825-random-pairs-book2
Sheet: Sheet1

Teams | Men |  | Women
Team 1 | [NAME] | 0.01023447702369507 | Kirsten | 0.4294827038174622
Team 2 | [NAME] | 0.4139716411053609 | Paige | 0.1683658160487544
Team 3 | Nate | 0.6823937172738481 | Heather | 0.3536021980792139
Team 4 | [NAME] | 0.2174881757587999 | Kelly | 0.540778353059147
Team 5 | Rory | 0.2363118807004003 | Britt | 0.8621085169801519
Spreadsheet: 734064d1621961468-data-validation-based-on-criteria-dependent-data-validation-drop-downs-tamarissa-
Sheet: Sheet1

Employee | Unit |  | Emp. List |  |  | Employee | Unit
[NAME] | WEL001 |  |  |  |  | [NAME] | WEL001
[NAME] | WEL002
[NAME] | SUP001
[NAME] | SUP002
[NAME] | SUP003
[NAME] | PFT001
[NAME] | drop-down list containing WEL001 & WEL002
[NAME] | drop-down list containing SUP001 & SUP002 & SUP003
[NAME] | drop-down list containing PFT001
Spreadsheet: 59289d1259778085-look-up-item-to-find-price-book1
Sheet: Sheet1

 | desc. | price
 | part 1 | 1
 | part 2 | 2
 | part 3 | 3
 | desc. | qty | price | total
 | part 1 | 2 |  | 0
 | part 3 | 5 |  | 0
 | part 2 | 10 |  | 0
 |  |  |  |  |  |  | I need formula to identify part desc., find it's price, and match it up with matching desc. Here.
Spreadsheet: john_hodge__16414__HOPEWELL Storage Impact
Sheet: Sheet2

Flow Month | Shipper | [NAME] | Agmt | Seq | Orig Storage Impact | Jan  Storage Impact | May  Storage Impact | Storage Agmt | *Difference
November | Enron NA | [NAME] | 69937 | 9 | 683 | 0 | 1042 | 67713
 |  | [NAME] |  | 10 | 6118 | 0 | 8790 | 67713
 |  | [NAME] |  | 11 | 15643 | 0 | 22551 | 67713
 |  | [NAME] |  | 12 | 2 | 0 | 384 | 67713
 |  | Total
December | VNG | [NAME] | 38088 | 149 | 794 | 0 | 1626 | 38079
 |  | [NAME] | 60536 | 14 | 1045 | 0 | 1634 | 67713
 |  | [NAME] | *65066 | 16 | 1046 | 0 | 0 | 67713
 |  |  | *This arrangement moved to 38088-149; 65066 cannot deliver to [NAME]
 |  | Total
 |  |  |  |  |  |  |  | 67713 | -457
 |  |  |  |  |  |  |  | 38079 | 832
Spreadsheet: 107539d1304682406-macro_transpose-macro2
Sheet: Data

Year | Rainfall | Year1 | Month1
199701 | 25.5
199702 | 5
199703 | 18.2
199704 | 12.8
199705 | 59.2
199706 | 33.4
199707 | 19.2
199708 | 29.7
199709 | 55.9
199710 | 28.6
199711 | 54.9
199712 | 5.7
199801 | 52.1
199802 | 72.4
199803 | 8.1
199804 | 55.7
199805 | 43.5
199806 | 57.6
199807 | 43.5
199808 | 21
199809 | 32.9
199810 | 87.7
199811 | 56.7
199812 | 62.7
199901 | 29.8
199902 | 35.6
199903 | 47.3
199904 | 25.2
199905 | 55.6
199906 | 47.1
199907 | 15.3
199908 | 76.2
199909 | 28.2
199910 | 59.3
199911 | 32.9
199912 | 101
200001 | 28.9
200002 | 38.5
200003 | 25.8
200004 | 42.2
200005 | 82.2
200006 | 40.4
200007 | 50
200008 | 44.4
200009 | 80.6
200010 | 108.2
200011 | 38
200012 | 34.4
200101 | 12.1
200102 | 8.9
200103 | 85.9
200104 | 114.6
200105 | 17.4
200106 | 59.8
200107 | 13.4
200108 | 51
200109 | 39.9
200110 | 76
200111 | 70.5
200112 | 59.5
200201 | 35.7
200202 | 76
200203 | 28.2
200204 | 42.6
200205 | 35.9
200206 | 28.6
200207 | 26.6
200208 | 40.7
200209 | 34
200210 | 27
200211 | 24.5
200212 | 11
200301 | 11.8
200302 | 19.2
200303 | 18.3
200304 | 67.3
200305 | 24.4
200306 | 34
200307 | 71.6
200308 | 53
200309 | 35.7
200310 | 67.5
200311 | 19.2
200312 | 62.6
200401 | 48
200402 | 14.1
200403 | 14.7
200404 | 48.2
200405 | 24.7
200406 | 43.2
200407 | 33.1
200408 | 67.1
200409 | 56.9
200410 | 65.5
200411 | 112.8
200412 | 44.7
200501 | 19.5
200502 | 157.3
200503 | 10.5
200504 | 28.2
200505 | 10.7
200506 | 40.4
200507 | 26.4
200508 | 60.2
200509 | 44.7
200510 | 42.1
200511 | 55.3
200512 | 61.6
200601 | 50.3
200602 | 54.5
200603 | 17.5
200604 | 47
200605 | 64.1
200606 | 11.7
200607 | 40.7
200608 | 31.8
200609 | 31.5
200610 | 8.5
200611 | 25
200612 | 15.4
200701 | 31.9
200702 | 17.6
200703 | 41.9
200704 | 22.4
200705 | 39.4
200706 | 40.4
200707 | 64.7
200708 | 15.9
200709 | 19.4
200710 | 20.5
200711 | 56.9
200712 | 75.7
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 105467 |  |  | 77908 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 131083 |  |  | 45263 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 134074 | 161714 |  | 31644 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 147980 | 162355 |  | 16460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 145971 | 164906 |  | 22551 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 127718 |  |  | 45207 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 172839 |  |  | 8766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 168553 |  |  | 21417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 147907 |  |  | 28501 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 156409 |  |  | 11318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 123568 | 164677 |  | 40741 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 166229 | 185212 |  | 22793 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 156491 |  |  | 25001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 140824 | 153538 |  | 15227
15 | 159652 | 176538 |  | 19424 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 154895 | 164011 |  | 11465 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 142559 | 163518 |  | 24182 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 182382 | 185948 |  | 7223
19 | 148178 | 156546 |  | 12871
20 | 153844 | 153538 |  | 2510
21 | 162746 | 167538 |  | 7650
22 | 166258 | 181221
23 | 164668 | 174965 |  | 8893
24 | 141426 | 169219 |  | 27435
25 | 136316 | 167125 |  | 28033
26 | 162082 | 184039 |  | 20072
27 | 169766 | 186230 |  | 18135
28 | 154080 | 162046 |  | 9519
29 | 210144 | 212091 |  | 4017
30 | 166998 | 172865 |  | 4123
31 | 174450 | 176865 |  | 4207
 | 2000-11-30 00:00:00 |  |  |  | -75432
 | 2000-12-31 00:00:00
Spreadsheet: 763854d1642432785-pick-a-grade-based-on-five-other-grades-sub-cats
Sheet: Sheet1

e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5
Ratings | Inadequate | RI | RI | RI | Inadequate |  |  |  | If all sub cats are "good" then the overall is "Good"
Overall Rating | Inadequate |  |  |  |  |  |  |  | If all sub cats are "RI" then the overall is "RI"
 |  |  |  |  |  |  |  |  | If all sub cats are "Inadequate" then the overall is "Inadequate"
e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5 |  |  |  | If 4 sub cats are "Good" and one is "RI" then the overall is "Good"
Ratings | Good | Good | Good | Good | inadequate |  |  |  | If any more than 1 sub cats are "RI" then the overall is "RI"
Overall Rating | Good |  |  |  |  |  |  |  | If more than 2 sub cats are "inadequate" then the it is "inadequate"
e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5
Ratings | Inadequate | RI | RI | RI | RI
Overall Rating | RI
e.g. | Sub cat 1 | Sub cat 2 | Sub cat 3 | Sub cat 4 | Sub cat 5
Ratings | Good | Good | RI | RI | RI
Overall Rating | RI
Spreadsheet: 78606d1278971458-copy-if-formula-if-formula-sheet
Sheet: Blank.

 |  |  |  |  |  |  |  | Date
 |  | BAN | Case | JEP | Open | Closed
1 |  | 102978576 |  | x | x
2 |  | 106712498 | F47073432 |  |  | x
3 |  | 105715842 | F47081976 | x
4 |  | 106884800
5 |  | 104536113
6 |  | 103135016
7
7
 | Date
 | Total BANs received | 7
 | Closed | 1
 | Dispatch Canceled | 0
 | JEP | 2 | 102978576 |  |  |  |  | 102978576,106712498,105715842,106884800,104536113,103135016
 | OPEN | 1
 | Other Agent | 1 | F47081976
 |  |  |  | C25=IF(A5="X",A6,"")
 |  |  | 2
 |  |  | 250000
 |  |  | 125000
 |  |  | 35
 |  |  | 4375000
 |  |  | 75000 |  |  | 20
 |  |  | 2080 |  |  | 2080
 |  |  | 36.05769230769231 |  |  | 41600
 |  |  | 87.5 |  |  | 50
 |  |  | 10 |  |  | 2080
 |  |  | 875 |  |  | 104000
Spreadsheet: 703771d1605169612-blank-rows-being-returned-dates-being-returned-twice-helperdoc
Sheet: Sheet2

 |  | [NAME]
Date |  | Project
Spreadsheet: 92299d1291906964-formula-to-transfer-hours-to-timeline-workplan-example
Sheet: Workplan

 |  |  |  |  | ARBEJDSPLAN
Uge nr.
Dato
Afdeling | Medarbejder |  | Monday | Hours total | Tuesday | Timer  i alt | Onsdag | Timer  i alt | Torsdag | Timer  i alt | Fredag | Timer  i alt | Lørdag | Timer  i alt | Søndag | Timer  i alt | Total NT | Total OT
 | A | Meet | 07:00:00 |  | 08:15:00
 |  | End | 15:00:00 |  | 10:45:00
 | B | Meet
 |  | End
 | C | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
 |  | Mødetid
 |  | Sluttid
Spreadsheet: 888879d1739476309-formula-help-lookups
Sheet: Sheet1

99214 | $297.78 |  | 99214
99215 | $418.35
99215 | $418.35
99215 | $418.35
99214 | $297.78
OVNS | $100.00
99215 | $418.35
99215 | $422.98
93015 | $165.73
99215 | $418.35
Spreadsheet: 749736d1632988568-calculate-no-of-days-if-every-month-has-30-days-30092021-sample-file
Sheet: Sheet1

Interest Date 1 | Interest Date 2 |  | No of Days |  | Upto Date : >> | 2021-09-30 00:00:00
2021-03-25 00:00:00 | 2021-09-25 00:00:00
2021-03-25 00:00:00 | 2021-09-25 00:00:00
2021-03-25 00:00:00 | 2021-09-25 00:00:00
2021-04-09 00:00:00 | 2021-10-09 00:00:00 |  |  |  | 2021-04-01 00:00:00 | 22
2021-04-09 00:00:00 | 2021-10-09 00:00:00 |  |  |  | 2021-05-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-06-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-07-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-09-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  |  |  | <<< Result must be this
2021-06-12 00:00:00 | 2021-12-12 00:00:00
2021-04-29 00:00:00 | 2021-10-29 00:00:00
2021-04-29 00:00:00 | 2021-10-29 00:00:00 |  |  |  | These are interest interval dates
2021-01-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  | Every month have only 30 days
2021-01-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  | If Upto date is > Interest date 2 then days must be calculate from Interest date 1
2021-01-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  | else interest date 2 has to be consider for no. of days calculation
2021-12-10 00:00:00 | 2021-06-10 00:00:00
2021-12-17 00:00:00 | 2021-06-17 00:00:00
2021-12-03 00:00:00 | 2021-06-03 00:00:00
2021-12-03 00:00:00 | 2021-06-03 00:00:00
2021-12-03 00:00:00 | 2021-06-03 00:00:00
2021-11-20 00:00:00 | 2021-05-20 00:00:00
2021-02-26 00:00:00 | 2021-08-26 00:00:00
2021-03-09 00:00:00 | 2021-09-09 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-23 00:00:00 | 2021-09-23 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-01-28 00:00:00 | 2021-07-28 00:00:00
2021-06-02 00:00:00 | 2021-12-02 00:00:00
2021-06-02 00:00:00 | 2021-12-02 00:00:00
2021-06-15 00:00:00 | 2021-12-15 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
2021-01-14 00:00:00 | 2021-07-14 00:00:00
2021-01-14 00:00:00 | 2021-07-14 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-11-27 00:00:00 | 2021-05-27 00:00:00
2021-11-27 00:00:00 | 2021-05-27 00:00:00
2021-11-27 00:00:00 | 2021-05-27 00:00:00
2021-12-10 00:00:00 | 2021-06-10 00:00:00
2021-12-24 00:00:00 | 2021-06-24 00:00:00
2021-12-24 00:00:00 | 2021-06-24 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
Spreadsheet: 008cbe67-8c47-4337-87ab-c49bf8758aca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
สำนักงานสาธารณสุขอำเภอ/โรงพยาบาล  สังกัดสำนักงานสาธารณสุขจังหวัดศรีสะเกษ
******************************************
หน่วยงาน | เบอร์โทรศัพท์ | หน่วยงาน | เบอร์โทรศัพท์
สสอ.เมืองศรีสะเกษ | 045-612501 | โรงพยาบาลศรีสะเกษ | 045-611389,611503
สสอ.กันทรลักษ์ | 045-661451 | โรงพยาบาลกันทรลักษ์ | 045-635758-61
สสอ.ราษีไศล | 045-681167 | โรงพยาบาลราษีไศล | 045-681107,681235
สสอ.อุทุมพรพิสัย (FAX) | 045-691438 (691812) | โรงพยาบาลอุทุมพรพิสัย | 045-691516,691518
สสอ.ขุขันธ์ | 045-671228 | โรงพยาบาลขุขันธ์ | 045-671015,671253
สสอ.กันทรารมย์ | 045-651226 | โรงพยาบาลกันทรารมย์ | 045-651144,651019
สสอ.ขุนหาญ | 045-679179 | โรงพยาบาลขุนหาญ | 045-679026
สสอ.ยางชุมน้อย | 045-687050 | โรงพยาบาลยางชุมน้อย | 045-687262-3
สสอ.ไพรบึง | 045-675078 | โรงพยาบาลไพรบึง | 045-675131,675067
สสอ.ปรางค์กู่ | 045-697167 | โรงพยาบาลปรางค์กู่ | 045-697167,697050
สสอ.บึงบูรพ์ | 045-689292 | โรงพยาบาลบึงบูรพ์ | 045-689043,689317
[NAME] | 045-677078 | โรงพยาบาลศรีรัตนะ | 045-677014,677140
สสอ.โนนคูณ | 045-659048 | โรงพยาบาลโนนคูณ | 045-659044
สสอ.ห้วยทับทัน(FAX) | 045-699064(699124) | [NAME] | 045-699045,699128
สสอ.น้ำเกลี้ยง | 045-609034 | โรงพยาบาลน้ำเกลี้ยง | 045-609055-6
สสอ.วังหิน | 045-606093 | โรงพยาบาลวังหิน | 045-606088-9
สสอ.ภูสิงห์ | 045-608155 | โรงพยาบาลภูสิงห์ | 045-608158-9
สสอ.เบญจลักษ์ | 045-605150 | โรงพยาบาลเมืองจันทร์ | 045-603051
สสอ.เมืองจันทร์ | 045-603111 | สสจ.ศรีสะเกษ | 045-616040-6
สสอ.พยุห์ | 045-607121 | สวท.ศรีสะเกษ | 045-611989
สสอ.โพธิ์ศรีสุวรรณ | 045-604053 | สวท.ศรีสะเกษ  FAX | 045-612358
สสอ.ศิลาลาด | 045-668123 | FAX  สสจ.ศรีสะเกษ | 045-616042
FAX  โรงพยาบาลอุทุมพรพิสัย | 045-691518 | ศูนย์มะเร็งอุบลราชธานี | 045-285615
โรงพยาบาลพระศรีมหาโพธิ์ | 045-285673 | สสจ.ศรีสะเกษ (งานสร้าง) | 045-615974
ร้านรังสิต(น้ำทิพย์) | [PHONE] | สสจ.ศรีสะเกษ (งาน คร.) | 045-615972
ธกส.อุทุมพรพิสัย | 045-691162 | ส.โพธิ์ศรี วัสดุ | [PHONE]
ร้าน อินเตอร์ เวิล์ด | 045-604156 | FAX สหกรณ์ออมทรัพย์ | 045-613992
ร้านชัยชนะ | 045-612855 | ธ.กรุงไทย | 045-691200
ธ.กรุงศรีฯ(สาขาศรีสะเกษ) | 045-612293-4