tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 215086d1361261960-valuation-of-inventory-with-their-sale-value-datafile
Sheet: Summary with valuation

Date | Pur Site | From Site | To Site | Project | Name of [NAME] | Invoice Number | Item | Category | Qty Pur | Qty Issue | Rate | Amount | total | issue total | balance | compare | actual balance | Rate | Amount
2013-01-01 00:00:00 | Bharatpur |  |  |  | tata pvt. ltd | 567 | choclate | Edible | 800 |  | 34 | 27200 | 800 | 900 | -100 | -100 | 0 | 34 | 0
2013-01-01 00:00:00 | Bikaner |  |  |  | mahaveer printing & stationery store | 345 | choclate | Edible | 678 |  | 65 | 44070 | 678 | 0 | 678 | 678 | 678 | 65 | 44070
2013-01-02 00:00:00 | Bharatpur |  |  | [NAME] |  |  | choclate | Edible |  | 750 |  |  | 800 | 900 | -100 | -100 | 0 | 0 | 0
2013-01-02 00:00:00 | Bharatpur |  |  |  | tata pvt. ltd | 679 | buiscuit | Edible | 500 |  | 10 | 5000 | 500 | 150 | 350 | 350 | 350 | 10 | 3500
2013-01-03 00:00:00 | bikaner |  |  | tank |  |  | buiscuit | Edible |  | 200 |  |  | 0 | 200 | -200 | -200 | 0 | 0 | 0
2013-01-03 00:00:00 | Bharatpur |  |  |  | tata pvt. ltd | 545 | choclate | Edible | 400 |  | 20 | 8000 | 1200 | 900 | 300 | 300 | 300 | 20 | 6000
2013-01-04 00:00:00 | Bharatpur | Bharatpur | Bikaner |  |  |  | buiscuit | Edible |  | 150 |  |  | 500 | 150 | 350 | 0 | 0 | 0 | 0
2013-01-05 00:00:00 | Bharatpur | Bharatpur | Bikaner |  |  |  | choclate | Edible |  | 150 |  |  | 1200 | 900 | 300 | 0 | 0 | 0 | 0
2013-01-05 00:00:00 | Bikaner | Bharatpur | Bikaner |  |  |  | choclate | Edible | 150 |  |  |  | 828 | 0 | 828 | 150 | 150 | 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: 805094d1668527224-merging-different-data-sets-with-different-formatting-into-one-based-on-quantity-s666-pq-named-ranges-filter-different-data-sets-_-merge-into-one
Sheet: Data

Name | Quantity | mapping |  | Name | Sauce | Quantity | [NAME] | Cooked | mapping |  | Name | Quantity | mapping
Apple | 500 | red |  | Chicken | Sweet | 15 | 300 | Cooked | white |  | [NAME] | 700 | yellow
Orange | 400 | orange |  | Beef | Mushroom | 18 | 800 | Uncooked | [NAME] |  | [NAME] | 50 | white
[NAME] | 550 | yellow |  | Turkey | [NAME] | 19 | 600 | Cooked | white |  | Pasta | 6 | yellow
Spreadsheet: 806944d1669686885-if-formula-impacted-by-previously-entered-data-sample-2
Sheet: Calculation

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option 4 - Progressive
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Size | [NAME] Actual Hours | Applicable Rev %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tier 1 | 500 | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1000 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tier 3 |  | 0.05
 | HOURS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net RPH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculated PRR
 |  | Pre-FY23 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | Total | Check |  |  | Pre-FY23 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | Check |  |  | Pre-FY23 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | FY23 Total | Project Total
 | [PHONE] | 433.8 | 259.9 | 206.7 | 354.9 | 293.8 | 370.3 |  |  |  |  |  |  |  | 1919.4 | 0 |  | [PHONE] | 150.855163669894 | 170.5990765679107 | 201.0716497339139 | 78.44880247957173 | 117.8007147719537 | 170.2907102349446 |  |  |  |  |  |  |  | -5.820766091346741e-11 |  | [PHONE]
Spreadsheet: kate_symes__18462__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-16 00:00:00 |  | 174.75 | 640 | 114.61 | 1264
 | 2001-01-15 00:00:00 |  | 174.29 | 560 | 114.61 | 1264 | 163.34 | 2155 | 121.91 | 913
 | 2001-01-14 00:00:00 |  | 135 | 160 | 102.1 | 496 | 151.06 | 2920 | 119.25 | 1375
 | 2001-01-13 00:00:00 |  | 170 | 160 | 116.65 | 1696 | 149.38 | 3307 | 112.78 | 1208
 | 2001-01-12 00:00:00 |  | 167.65 | 544 | 116 | 2136 | 146.77 | 361 | 110.31 | 1207
 | 2001-01-11 00:00:00 |  | 159.09 | 704 | 116 | 2136 | 147.18 | 1708 | 100.51 | 774
 | 2001-01-10 00:00:00 |  | 150 | 960 | 94.32 | 2280 | 140.57 | 584 | 101.31 | 555
 | 2001-01-09 00:00:00 |  | 127.81 | 1024 | 77.19 | 912 | 156.86 | 390 | 88.91 | 1464
 | 2001-01-08 00:00:00 |  | 132.55 | 1024 | 76.1 | 912 | 127.42 | 1330 | 71.95 | 583
 | 2001-01-07 00:00:00 |  | 115 | 0 | 62.5 | 0 | 63.78 | 2249 | 57.2 | 1278
 | 2001-01-06 00:00:00 |  | 124.17 | 384 | 93.8 | 432 | 102.76 | 521 | 66.24 | 647
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528 | 129.45 | 1527 | 123.46 | 455
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
Spreadsheet: 819522d1677563567-unique-filter-formula-automatically-getting-converted-into-an-array-formula-in-o365-test_file_forum_2-copy
Sheet: SUMMARY

Viewing Count By | Weekly Summary
 | Total user feedbacks received: |  |  | Pages with total feedbacks
 | Organizations:
 | [NAME]:
 | Rated Very Happy 😃:
 | Rated Happy 🙂:
 | Rated Neutral 😐:
 | Rated Sad 🙁:
 | Rated Very Sad 😫:
Please visit 2nd and 3rd tab for the feedback details.
Spreadsheet: 543993d1508715687-need-help-using-text-to-column-mybpreadings_22oct2017
Sheet: MyBPReadings_22Oct2017

Date Time | Systolic | Diastolic | Pulse
2017-10-22 16:38:00 | 120 | 80 | 78
2017-10-22 11:42:00 | 120 | 80 | 78
2017-10-21 11:51:00 | 120 | 80 | 78
2017-10-21 05:59:00 | 120 | 80 | 78
2017-10-20 20:05:00 | 120 | 80 | 78
2017-10-20 16:38:00 | 120 | 80 | 78
2017-10-20 06:02:00 | 120 | 80 | 78
2017-10-18 16:27:00 | 120 | 80 | 78
2017-10-18 12:01:00 | 120 | 80 | 78
2017-10-18 09:17:00 | 120 | 80 | 78
2017-10-18 02:05:00 | 120 | 80 | 78
Spreadsheet: 218097d1362343758-table-with-2-variables-problem
Sheet: Sheet1

 | p | N1 | N2
 | 1 | 18 | 12 | 16 | 22 | 24
 |  | 24 | 18 | 20 | 22 | 28 | 30
 |  | 30 | 18 | 22 | 24 | 34 | 36
 |  | 36 | 24 | 28 | 30 | 46
 |  | 42 | 24 | 30 | 34 | 36 | 48 | 52
 |  | 48 | 30 | 36 | 40 | 58 | 60
 |  | 54 | 30 | 36 | 46 | 48 | 60 | 64 | 66
 |  | 60 | 36 | 48 | 50 | 52 | 70 | 72
 |  | 72 | 48 | 52 | 54 | 60 | 66 | 76 | 82 | 90
 | 2 | 24 | 18 | 30
 |  | 36 | 24 | 30 | 42
 |  | 48 | 30 | 36 | 40 | 58 | 60
 |  | 60 | 36 | 42 | 48 | 50 | 70 | 72 | 74
 |  | 72 | 42 | 48 | 54 | 58 | 60 | 62 | 82 | 86 | 90
 | 3 | 36 | 20 | 22 | 26 | 28 | 44 | 46
 |  | 54 | 34 | 36 | 38 | 40 | 44 | 46 | 62 | 64 | 68
 |  | 72 | 44 | 46 | 50 | 52 | 54 | 56 | 58 | 62 | 82 | 86 | 88 | 90
 | 4 | 48 | 26 | 30 | 34 | 36 | 38 | 58 | 60
 |  | 72 | 42 | 46 | 48 | 50 | 52 | 54 | 58 | 60 | 62 | 82 | 84 | 86 | 90
 | 3 | 72
 | How can I filter the values of N2 for certain values of p and N1 ? Let's say p=3 and N1=72 ?
Spreadsheet: 69931d1270589134-subtraction-sample1
Sheet: Sheet1

Total Hours Week 1 |  |  |  |  |  |  | Hours Scheduled Week 1
Day | Date | In | Out | Total |  |  | In | Out | Late
Mon | 1900-01-01 00:00:00 | 12:00:00 | 21:00:00 | 09:00:00 |  |  | 12:15:00 | 21:00:00 | -0.01041666666666663
 |  | 07:00:00 | 09:00:00 | 02:00:00 |  |  |  |  | 0.2916666666666667
 |  |  |  | 11:00:00 |  |  |  |  | 07:00:00
Spreadsheet: 466182d1466047845-match-lines-with-multiple-specific-criteria-match-lines-with-multiple-specific-criteria
Sheet: GSIN6  1 hour (Basic) - Table V

-22 | -17 | -27 | -21 | -76 | -68
-29 | -27 | -42 | -40 | -44 | -41
-33 | -29 | -84 | -71 | -207 | -198
-35 | -32 | -38 | -35 | -65 | -62
-38 | -35 | -45 | -42 | -47 | -44
-45 | -42 | -90 | -86 | -192 | -189
-59 | -56 | -86 | -84 | -130 | -126
-60 | -58 | -92 | -90 | -105 | -100
-68 | -64 | -90 | -86 | -113 | -109
-76 | -68 | -100 | -96 | -118 | -115
-86 | -84 | -96 | -92 | -207 | -198
-96 | -92 | -100 | -96 | -132 | -128
-105 | -100 | -113 | -109 | -139 | -133
-111 | -108 | -118 | -115 | -121 | -116
-116 | -113 | -124 | -118 | -164 | -162
-124 | -118 | -139 | -133 | -159 | -154
-144 | -141 | -159 | -154 | -207 | -198
-167 | -164 | -170 | -168 | -173 | -170
row 6 matches row 3 because 1 number from column c-d (-42) and 1 number from column pair e-f (-44) match numbers from different column pairs in a row below it (row 6)
row 13 matches row 9 because 1 number from column c-d (-92) and 1 number from column pair e-f (-100) match numbers from different column pairs in a row below it (row 13)
note: no need to match numbers from column pair a-b, just c-d and e-f, but the matches for the numbers from column pair c-d & e-f can be from column pair a-b like solution 2 (red).
Spreadsheet: 839819d1692253627-excel-formula-to-best-match-product-based-on-4-criteria-required-quick-sales-calc-v1-demo-keebellah-
Sheet: Sensor Qty CALC test

Location | Indoor/Outdoor | Cable/Wifi/BT | Height Required | [NAME] | Height Recommended | Sensor Quantity/Width | Sensor MSRP (USD) | Sensor Recommended | -1 | Sensor Total Price | ColBC CONCAT
location 1 | Indoor | Cable | 3.5 | 2.37 |  |  |  |  |  |  |  |  | ColBC CONCAT Ref
location 2 | Indoor | Cable | 3.5 | 2.37 |  |  |  |  |  |  |  |  | IndoorCable
location 3 | Indoor | Cable | 3.35 | 3 |  |  |  |  |  |  |  |  | IndoorWifi/BT
location 4 | Indoor | Cable | 2.6 | 5.18 |  |  |  |  |  |  |  |  | OutdoorCable
location 5 | Indoor | Cable | 3.5 | 7.31 |  |  |  |  |  |  |  |  | OutdoorWifi/BT
Sensor | Indoor/Outdoor | Cable/Wifi/BT | Height | [NAME] | Length | Coverage of Height/Width | Sensor MSRP (USD) | ColBC CONCAT | Height AB Test | ColBC CONCAT Match
sensor 1 | Indoor | Cable | 2.5 | 1.88 | 1.06 |  | 500
sensor 1 | Indoor | Cable | 3 | 3.75 | 2.13 |  | 500
sensor 1 | Indoor | Cable | 3.5 | 5.63 | 3.19 |  | 500
sensor 1 | Indoor | Cable | 4 | 7 | 4.25 |  | 500
sensor 1 | Indoor | Cable | 4.5 | 7 | 5 |  | 500
sensor 1 | Indoor | Cable | 5 | 7 | 5 |  | 500
sensor 1 | Indoor | Cable | 5.5 | 7 | 5 |  | 500
sensor 1 | Indoor | Cable | 6 | 7 | 5 |  | 500
sensor 2 | Indoor | Wifi/BT | 2.5 | 1.88 | 1.06 |  | 1000
sensor 2 | Indoor | Wifi/BT | 3 | 3.75 | 2.13 |  | 1000
sensor 2 | Indoor | Wifi/BT | 3.5 | 5.63 | 3.19 |  | 1000
sensor 2 | Indoor | Wifi/BT | 4 | 7 | 4.25 |  | 1000
sensor 2 | Indoor | Wifi/BT | 4.5 | 7 | 5 |  | 1000
sensor 2 | Indoor | Wifi/BT | 5 | 7 | 5 |  | 1000
sensor 2 | Indoor | Wifi/BT | 5.5 | 7 | 5 |  | 1000
sensor 2 | Indoor | Wifi/BT | 6 | 7 | 5 |  | 1000
sensor 3 | Outdoor | Cable | 2.5 | 1.88 | 1.06 |  | 2000
sensor 3 | Outdoor | Cable | 3 | 3.75 | 2.13 |  | 2000
sensor 3 | Outdoor | Cable | 3.5 | 5.63 | 3.19 |  | 2000
sensor 3 | Outdoor | Cable | 4 | 7 | 4.25 |  | 2000
sensor 3 | Outdoor | Cable | 4.5 | 7 | 5 |  | 2000
sensor 3 | Outdoor | Cable | 5 | 7 | 5 |  | 2000
sensor 3 | Outdoor | Cable | 5.5 | 7 | 5 |  | 2000
sensor 3 | Outdoor | Cable | 6 | 7 | 5 |  | 2000
sensor 4 | Outdoor | Wifi/BT | 2.5 | 1.88 | 1.06 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 3 | 3.75 | 2.13 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 3.5 | 5.63 | 3.19 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 4 | 7 | 4.25 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 4.5 | 7 | 5 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 5 | 7 | 5 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 5.5 | 7 | 5 |  | 3000
sensor 4 | Outdoor | Wifi/BT | 6 | 7 | 5 |  | 3000
Spreadsheet: 51661d1251293467-protected-dynamic-range-interconnect-serial-number-log
Sheet: Serial Number Log

Date | TLA | TLA - S/N | Sub-Assy | Sub-Assy - S/N | Sub-Assy2 | Sub-Assy - S/N2 | Sub-Assy3 | Sub-Assy - S/N3 | Sub-Assy4 | Sub-Assy - S/N4 | Sub-Assy5 | Sub-Assy - S/N5 | Sub-Assy6 | Sub-Assy - S/N6 | Sub-Assy7 | Sub-Assy - S/N7 | Sub-Assy8 | Sub-Assy - S/N8 | Sub-Assy9 | Sub-Assy - S/N10 | Sub-Assy10 | Sub-Assy - S/N9 | Sub-Assy11 | Sub-Assy - S/N11 | Sub-Assy12 | Sub-Assy - S/N12
 | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N | P/N | S/N
2009-08-26 08:25:56 | 4022.630.57535 |  | 4022.472.26742 |  | 4022.472.29091 |  | 4022.472.26681 |  | 4022.472.56573
2009-08-26 08:27:06 | 4545 |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
2009-08-26 08:27:21 | pipo |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
2009-08-26 08:28:05 | 455 |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
2009-08-26 08:29:25 | 4656 |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
Spreadsheet: 883238d1731792920-most-found-criteria-sample-score-sheet-eba
Sheet: Sheet1

 | Winner | [NAME] |  | Winner | Most Likely to Lose
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | Cathy
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | Dwayne
 | [NAME] | Dwayne |  | Jasel
 | [NAME] | Jeremy |  | [NAME]
 | [NAME] | Nick |  | Jeremy
 | [NAME] | Nick |  | [NAME]
 | [NAME] | Nick |  | Julie
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | Magdelena
 | [NAME] | [NAME] |  | Nichelina
 | [NAME] | [NAME] |  | Nick
 | [NAME] | [NAME] |  | Pa
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME] |  | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Jasel
 | [NAME] | Jasel
 | [NAME] | [NAME]
 | [NAME] | Jayleen
 | [NAME] | Julie
 | [NAME] | Julie
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Cathy | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Julie
 | [NAME] | Julie
 | [NAME] | [NAME]
 | [NAME] | Julie
 | [NAME] | [NAME]
 | Dwayne | [NAME]
 | Dwayne | [NAME]
 | Dwayne | Nick
 | Dwayne | [NAME]
 | Jasel | [NAME]
 | Jasel | [NAME]
 | Jasel | Julie
 | Jasel | Julie
 | Jasel | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Dwayne
 | Jeremy | [NAME]
 | Jeremy | [NAME]
 | [NAME] | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | Dwayne
 | Julie | Gpa
 | Julie | Jasel
 | Julie | Jasel
 | Julie | Jeremy
 | Julie | Jeremy
 | Julie | Magdelena
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | Julie | [NAME]
 | [NAME] | [NAME]
 | Magdelena | [NAME]
 | Nichelina | [NAME]
 | Nichelina | [NAME]
 | Nichelina | [NAME]
 | Nichelina | [NAME]
 | Nichelina | Dwayne
 | Nichelina | [NAME]
 | Nick | [NAME]
 | Nick | Julie
 | Nick | Julie
 | Nick | Julie
 | Nick | [NAME]
 | Pa | [NAME]
 | [NAME] | Jasel
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Nichelina
Spreadsheet: 780382d1652431065-making-a-top-list-of-sortiment-in-ranking-between-groups-test-topplist-may
Sheet: Blad1

 | Numbers
 | ALFA | BETA | CICO | DELTA | KOLLO | TOTAL
Prod A | 3000 | 3500 |  | 1800
Prod B | 2400 | 1000 | 5600 | 3200
Prod C | 100 | 4500 | 8500 | 4580
Prod D | 5600 | 1005 | 4000 | 0
Prod E | 10000 | 900 | 3500 | 56
[NAME] | 7800 | 100 | 1000 | 6700
[NAME] | 3500 | 500 | 8000 | 6300
Prod H | 1500 | 6000 | 5500 | 1000
Prod J | 2500 | 3450 |  | 600
[NAME] | 8500 | 1300 | 8300 | 2800
[NAME] | 15000 | 5000 | 6500 | 2500
TOPP LIST
ALFA |  | BETA |  | KOLLO
PROD L | 15000 | PROD H | 6000 | 0 | 0
PROD E | 10000 | PROD L | 5000 | rank nr 2
PROD K | 8500 | rank nr 3
rank nr 4 |  | rank nr 4
rank nr 5 |  | rank nr 5
rank nr 6 |  | rank nr 6
rank nr 7 |  | rank nr 7
rank nr 8 |  | rank nr 8
rank nr 9 |  | rank nr 9
rank nr 10 |  | rank nr 10
rank nr 11 |  | rank nr 11
CICO |  | DELTA
PROD C | 8500 | PROD F | 6700
rank nr 2 |  | rank nr 2
rank nr 3 |  | rank nr 3
rank nr 4 |  | rank nr 4
rank nr 5 |  | rank nr 5
rank nr 6 |  | rank nr 6
rank nr 7 |  | rank nr 7
rank nr 8 |  | rank nr 8
rank nr 9 |  | rank nr 9
rank nr 10 |  | rank nr 10
rank nr 11 |  | rank nr 11
I want to see a ranking of product types for each group (ALFA - BETA - KOLLO - CICO - DELTA)
I give an idea how I want to have it presented in TOPP LIST
Spreadsheet: 838495d1691066330-formula-help-to-add-recurring-number-sequence-up-to-a-limit-and-age-formula-excel-query1
Sheet: Sheet1

DOB | Event Date | Age at event | Until age | Result date
1957-08-11 00:00:00 | 2012-03-16 00:00:00 |  | 66 | [NAME] result date would be 11/08/1969
 |  |  |  | ( formula to add every 3 years until reaching "until age" - (to include the last full 3 year period either before or after the until age date))
 |  | Looking for a formula which adds continuous 3 years increments up to the "Until Age" input number in column D
 | plus 3 years | 57 years 217 days
 | plus 3 years | 60 years 217 days
 | plus 3 years | 63 years 217 days |  | Then as per this example adds the 12 years to give the date at that age
 | plus 3 years | 66 years 217 days |  | Date at 66 years 217days = 11/08/1969
Spreadsheet: 774987d1648749005-comparing-data-book1
Sheet: Data

Facility | Name | Contact Date | Using/Not Using
HAR | Provider1 | 2022-01-24 00:00:00 | Using |  | Expected Results
HAR | Provider1 | 2022-02-14 00:00:00 | Not Using |  | HAR
HAR | Provider2 | 2021-12-31 00:00:00 | Using |  | Provider2
HAR | Provider3 | 2021-12-31 00:00:00 | Using |  | Provider4
LEX | Provider3 | 2022-01-07 00:00:00 | Not Using |  | Provider8
HAR | Provider4 | 2021-12-31 00:00:00 | Using |  | LEX
LOU | Provider4 | 2021-12-31 00:00:00 | Using |  | Provider6
HAR | Provider4 | 2022-03-15 00:00:00 | Using |  | LOU
LEX | Provider5 | 2022-01-10 00:00:00 | Not Using |  | Provider7
LEX | Provider6 | 2021-12-31 00:00:00 | Using |  | Provider10
LEX | Provider6 | 2022-01-28 00:00:00 | Using |  | PAD
LOU | Provider7 | 2021-12-31 00:00:00 | Using |  | Provider12
LOU | Provider7 | 2022-01-07 00:00:00 | Using
HAR | Provider8 | 2022-01-17 00:00:00 | Using
LEX | Provider9 | 2022-01-28 00:00:00 | Using
LEX | Provider9 | 2022-02-21 00:00:00 | Not Using
LOU | Provider10 | 2021-12-31 00:00:00 | Using
LEX | Provider11 | 2022-01-07 00:00:00 | Not Using
PAD | Provider12 | 2021-12-31 00:00:00 | Using
LEX | Provider13 | 2022-01-21 00:00:00 | Not Using
Spreadsheet: kevin_hyatt__19628__tw140exprevlost
Sheet: Sheet1

 |  | Assumption: |  | Reduced Flow | Based on Linepack
 |  |  | Sta. #1 | 75 MMcf/day | (+- 25 MMcf/day)
 |  |  | Sta. #2 | 120 MMcf/day | (+- 25 MMcf/day)
 |  |  | Sta. #3 | 125 MMcf/day | (+- 25 MMcf/day)
 |  |  | Sta. #4 | 225 MMcf/day | (+- 25 MMcf/day)
 |  |  | Note: If unit is down at Station #4 then a unit can be down at each of the Stations #1 through #3
 |  |  |  | Daily | Annual | Daily | Annual
 |  | Volume |  | 1700000
 |  | Fuel | 0.01788235294117647
 |  | Retainage | 0.03294117647058824
 |  | Mainline (west) |  | 965000 |  | 1090000
 |  | Reduced Flow |  |  |  | 250000
 |  | Mainline (90 Days) |  | 840000
 |  | Lost Retainage
 |  |  | HP
 |  | Fuel
 |  |  | [NAME].
 |  | Lost Commodity | 0.0206
 |  | Lost Fuel Retainage (90 Days)
 |  | Gas Price |  | 4.19
 |  | Total Lost Revenues (90 Days)
Spreadsheet: mary_fischer__25609__32C-2001
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032C
COMPANY NAME   Enron Building Services Inc. Hldg Co.
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION:[PHONE]
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36