tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 463376d1464471151-conditional-formatting-duplicates-any-order-double-numbers-comparison
Sheet: Sheet1

x | count | y
001 |  | 204
002 |  | 402
003 |  | 606
004 |  | 661
005 |  | 765
006 |  | 930
007 |  | 841
008 |  | 785
009 |  | 931
011 |  | 883
022 |  | 148
033 |  | 391
044 |  | 971
055 |  | 008
066 |  | 961
077 |  | 254
088 |  | 546
099 |  | 686
112 |  | 673
113 |  | 101
114 |  | 534
115 |  | 921
116 |  | 810
117 |  | 918
118 |  | 298
119 |  | 280
122 |  | 181
133 |  | 880
144 |  | 253
155 |  | 729
166 |  | 461
177 |  | 892
188 |  | 029
199 |  | 731
223 |  | 236
224 |  | 002
225 |  | 000
226 |  | 409
227 |  | 073
228 |  | 473
229 |  | 256
233 |  | 381
244 |  | 552
255 |  | 799
266 |  | 706
277 |  | 174
288 |  | 926
299 |  | 413
334 |  | 985
335 |  | 606
336 |  | 454
337 |  | 610
338 |  | 355
339 |  | 918
344 |  | 911
355 |  | 009
366 |  | 263
377 |  | 001
388 |  | 684
399 |  | 822
445 |  | 679
446 |  | 450
447 |  | 170
448 |  | 694
449 |  | 242
455 |  | 072
466 |  | 480
477 |  | 839
488 |  | 724
499 |  | 316
556 |  | 503
557 |  | 307
558 |  | 230
559 |  | 621
566 |  | 042
577 |  | 123
588 |  | 386
599 |  | 879
667 |  | 440
668 |  | 857
669 |  | 798
677 |  | 795
688 |  | 732
699 |  | 075
778 |  | 412
779 |  | 065
788 |  | 684
799 |  | 915
889 |  | 183
899 |  | 688
 |  | 762
 |  | 148
 |  | 431
 |  | 133
 |  | 340
 |  | 787
 |  | 604
 |  | 139
 |  | 776
 |  | 895
 |  | 507
 |  | 587
 |  | 750
 |  | 652
 |  | 469
 |  | 596
 |  | 578
 |  | 895
 |  | 104
 |  | 303
 |  | 155
 |  | 304
 |  | 318
 |  | 013
Spreadsheet: 764304d1642684683-compare-two-tables-find-matches-and-extract-rows-based-on-matches-mwa-schools
Sheet: Blad1

TABLE 1 |  |  | TABLE 2
Skol-enhetskod | Skolkommun |  | Skol-enhetskod | Skolkommun
76026322 | Kiruna |  | 76026322 | Kiruna
44673074 | Stockholm |  | 44673074 | Stockholm
99648792 | Stockholm |  | 99648792 | Stockholm
22335099 | Knivsta |  | 22335099 | Knivsta
47684564 | Örebro |  | 47684564 | Örebro
15561397 | [NAME] |  | 15561397 | [NAME]
71387206 | Ale |  | 71387206 | Ale
41408780 | Nacka |  | 41408780 | Nacka
10715898 | Österåker |  | 37796564 | Stockholm
48184058 | Vallentuna |  | 10715898 | Österåker
28145722 | Vallentuna |  | 48184058 | Vallentuna
59092675 | Timrå |  | 28145722 | Vallentuna
90711097 | Stockholm |  | 59092675 | Timrå
84230115 | Hultsfred |  | 90711097 | Stockholm
27323097 | Solna |  | 84230115 | Hultsfred
85416841 | Jönköping |  | 27323097 | Solna
92304123 | Ovanåker |  | 85416841 | Jönköping
65024773 | Bollnäs |  | 92304123 | Ovanåker
82838118 | Stockholm |  | 65024773 | Bollnäs
60217642 | Skurup |  | 82838118 | Stockholm
45270097 | Vara |  | 60217642 | Skurup
56528690 | [NAME] |  | 45270097 | Vara
51403955 | Lerum |  | 56528690 | [NAME]
Spreadsheet: 774530d1648534742-power-query-question-data-for-powerquery
Sheet: AP

Factuur | Datum | Boeking | Dagboek | Notities | Omschrijving | Ouderdom: [NAME] | Vervaldatum | Valuta | Te betalen (V.V.) | Te betalen
97 - Family guy
22700004 | 2022-02-27 00:00:00 | 22600216 | 60 - Inkoopboek |  | text | 28 | 2022-03-13 00:00:00 | EUR | 1759.55 | 1759.55
22700001 | 2022-01-31 00:00:00 | 22600141 | 60 - Inkoopboek |  | text | 55 | 2022-02-14 00:00:00 | EUR | 2127.75 | 2127.75
21700020 | 2021-12-30 00:00:00 | 21601520 | 60 - Inkoopboek |  | text | 87 | 2022-01-13 00:00:00 | EUR | 3921.25 | 3921.25
21700017 | 2021-11-30 00:00:00 | 21601428 | 60 - Inkoopboek |  | text | 117 | 2021-12-14 00:00:00 | EUR | 3999.05 | 3999.05
Subtotaal |  |  |  |  |  |  |  |  |  | 11807.6
98 - Simpsons
202200628 | 2022-02-28 00:00:00 | 22600218 | 60 - Inkoopboek |  | text | 27 | 2022-03-14 00:00:00 | EUR | 302.5 | 302.5
202200263 | 2022-01-31 00:00:00 | 22600119 | 60 - Inkoopboek |  | text | 55 | 2022-02-14 00:00:00 | EUR | 302.5 | 302.5
202104265 | 2021-12-31 00:00:00 | 21601527 | 60 - Inkoopboek |  | text | 86 | 2022-01-14 00:00:00 | EUR | 302.5 | 302.5
Subtotaal |  |  |  |  |  |  |  |  |  | 907.5
106 - Southpark
[PHONE] | 2022-03-08 00:00:00 | 22600248 | 60 - Inkoopboek |  | text | 19 | 2022-03-15 00:00:00 | EUR | 35.62 | 35.62
[PHONE] | 2022-02-08 00:00:00 | 22600166 | 60 - Inkoopboek |  | text | 47 | 2022-02-15 00:00:00 | EUR | -131.99 | -131.99
 | 2022-03-23 00:00:00 | 22210058 | 21 - ABN AMRO Bank 977556999 (incasso) |  | text | 4 | 2022-03-23 00:00:00 | EUR | -83.93 | -83.93
 | 2022-01-25 00:00:00 | 22210017 | 21 - ABN AMRO Bank 977556999 (incasso) |  | text | 61 | 2022-01-25 00:00:00 | EUR | -82.28 | -82.28
Subtotaal |  |  |  |  |  |  |  |  |  | -262.58
00019 - Tom & Jerry
2021/450 | 2021-12-07 00:00:00 | 21601452 | 60 - Inkoopboek |  | text | 110 | 2021-12-28 00:00:00 | EUR | 408.83 | 408.83
2021/432 | 2021-11-19 00:00:00 | 21601371 | 60 - Inkoopboek |  | text | 128 | 2021-12-10 00:00:00 | EUR | 205.72 | 205.72
2021/399 | 2021-11-15 00:00:00 | 21601355 | 60 - Inkoopboek |  | text | 132 | 2021-12-06 00:00:00 | EUR | 2260.58 | 2260.58
Subtotaal |  |  |  |  |  |  |  |  |  | 2875.13
00020 - Snowwhite
795811 | 2022-03-22 00:00:00 | 22600304 | 60 - Inkoopboek |  | text | 5 | 2022-04-05 00:00:00 | EUR | 878.71 | 878.71
Subtotaal |  |  |  |  |  |  |  |  |  | 878.71
Spreadsheet: 694892d1599857920-sumif-not-working-properly-productn-materials-planning-template
Sheet: Eco 3mm

 |  |  |  | Total for 75 batches
100000024101 | 40
100000025436 | 3.94
100000023979 | 36
100000025444 | 8.1
100000025391 | 0.5
200000009402 | 133
100000002979 | 38
100000024051 | 40
100000025228 | 120
100000025380 | 0.5
100000025401 | 1.6
100000025424 | 3
100000025425 | 3
100000025873 | 205.49
100000029113 | 100
100000032512 | 999.52
100000040473 | 269
100000040932 | 31.34
100000045271 | 100
Spreadsheet: 1b99bc71-417b-4938-87bd-040e5b97a906
Sheet: Customers

Acct | Department | Cage | PO | Contact | Dr.
1 | Physiology | RES |  | [NAME]
2 | Physiology | RES |  | [NAME]
3 | Physiology | RES |  | [NAME]
4 | Physiology | RES |  | [NAME] | Ma
5 | Physiology | RES |  | [NAME] | Caffrey
6 | Physiology | RES |  | [NAME] | Downey
7 | Lab Animal Med |  |  | C, [NAME]
8 | Pharmacology |  |  | [NAME]
9 | Pharmacology |  |  | [NAME]
10 | Pharmacology | RES/CBH |  | [NAME] | Singh
11 | Physiology | RES |  | [NAME] | Dimitrjevich
12 | [NAME]
13 | Pharmacology | CBH |  | [NAME] | Sumien
14 | Pharmacology |  |  | [NAME] | Ma
15 | Pharmacology |  |  | [NAME] | [NAME]
16 | Pharmacology |  |  | [NAME] | [NAME]
17 | Pharmacology |  |  | [NAME] | Luedke
18 | Physiology | RES |  | [NAME]
19 | Pharmacology |  |  | [NAME] | [NAME]
20 | Pharmacology |  |  | [NAME] | Simpkins
21 | Pharmacology |  |  | [NAME] | Singh
22 | Pharmacology |  |  | [NAME] | Gonzales
23 | Pharmacology |  |  | [NAME] | Dillon
24 | Pharmacology |  |  | [NAME]
25 | Physiology | RES |  | [NAME] | [NAME]
26 | Molecular Biology |  |  | [NAME] | Semecka
27 | Molecular Biology |  |  | [NAME] | [NAME]
28 | Physiology | RES |  | [NAME] | Potts
29 | Pharmacology | CBH |  | [NAME] | Sokely
30 | Physiology |  |  | [NAME]
31 | Physiology |  |  | [NAME]
32 | Cellular Biology | RES/CBH |  | [NAME]
33 | Physiology | RES |  | [NAME]
34 | Physiology | RES |  | [NAME]
35 | Physiology | RES |  | [NAME]
36 | Physiology | RES |  | [NAME]
37 | Pharmacology |  |  | [NAME]
38 | Molecular Biology | RES |  | [NAME]
39 | Physiology | RES |  | [NAME]
40 | Molecular Biology | RES |  | [NAME] | Vishwanaatha
41
42
43
44 | Molecular Biology | RES |  | [NAME] | [NAME]
45
46
47 | Pharmacology | CBH |  | [NAME] | Uht
48 | Physiology | RES |  | A [NAME] | Cunninghm
49 | Physiology | RES |  |  | Cunninham
50 |  |  |  |  | Lacko
51 | Psychiatry | RES |  | [NAME]
52
Spreadsheet: richard_ring__31589__Renewable_Positions_2001_2013
Sheet: Sheet1

 | Cal_2001 | Cal_2002 | Cal_2003 | Cal_2004 | Cal_2005 | Cal_2006 | Cal_2007 | Cal_2008 | Cal_2009 | Cal_2010 | Cal_2011 | Cal_2012 | Cal_2013 | Cal_2014
 | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's | MWh's
Arizona | 0 | 0 | 0 | 0 | -166226.6275982227 | -134729.9559916566 | -121588.9893685961 | -114694.517933037 | -103553.8450370569 | -45669.71960392079 | -3157.199677212338 | 0 | 0 | 0
Connecticut | 0 | 0 | 0 | -50155.72142846596 | -47360.61629726477 | -44670.49213754745 | -42190.43915098302 | -39817.3835799917 | -35487.09146154969 | -8669.132218613275 | 1178.83169845645 | 0 | 0 | 0
Massachusetts | -137319.1894193623 | -737770.164126182 | -754667.3806392646 | -627480.6956465826 | -642651.1008972266 | -249563.7454641479 | -70744.82000480368 | -66756.4873723019 | -59515.3753630694 | -15230.38557981171 | -3488.782983158893 | 0 | 0 | 0
Maine | -397403.4048181125 | -1361312.553299634 | -926169.6854437896 | -600315.3230666022 | -393748.6910687109 | -67252.57656254288 | -2977.929838781889 | -2801.188343490885 | -2527.212197463853 | 0 | 0 | 0 | 0 | 0
New Jersey | -662588.255973344 | -1519697.719609273 | -1342725.64251805 | -732471.1522558382 | -474457.1584570033 | -336320.1118713905 | -254580.5558797808 | -67791.34381421066 | -13746.62554208125 | 0 | 0 | 0 | 0 | 0
Nevada | 0 | 0 | -14441.63687110981 | -18673.64788099312 | -17617.7807510402 | -16626.81165284608 | -299945.3029770677 | -123328.0864904576 | -16504.73466017683 | -3750.203189648988 | 482.8306596673126 | 0 | 0 | 0
Texas | 0 | -811686.4034935718 | -783638.1102133049 | -711010.3996656899 | -503418.2963840723 | -273375.4646123759 | -542676.4235372355 | -478463.6221581163 | -302017.2272644754 | -62159.09984269926 | -14305.09059338301 | -14067.68150235429 | -13167.38176177713 | -12340.48972881895
Arizona_Renewable
Connecticut_Renewable
Massachusetts_Renewable
Maine_Renewable
New Jersey_Renewable
Nevada_Renewable
Renewable_Energy_ Capacity_ [NAME]'s | 0 | 400 | 400 | 850 | 850 | 1400 | 1400 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Number_of_Hours_Per_Year | 0 | 8760 | 8760 | 8784 | 8760 | 8760 | 8760 | 8784 | 8760 | 8760 | 8760 | 8784 | 8760 | 8760
Capacity_Conversion_Factor | 0 | 0.35 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.4 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46
Renewable_Energy_Credits_Total_Alloc_(MWh's) | 0
EESI_Estimated_Percentage_of_Retail_Load | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
Texas_Renewable_Energy_Credits_Reqmt_(MWh's) | 0
Spreadsheet: c938d3e5-00c0-42bc-8936-540388f0ca7f
Sheet: GrayScale

RGB_Triplet | X | Y | Z | [NAME]
0, 0, 0 | 99.3356681931446 | 100.430801260879 | 113.011354387491 | 100.352366132179
13, 13, 13 | 0.885685537409317 | 0.541878973158158 | 1.06328387026931 | 15.4994610913787
26, 26, 26 | 0.245169301164787 | 0.261321175063452 | 0.327800579337583 | 2.22857525976055
38, 38, 38 | 0.711782345774923 | 0.73180920567094 | 0.740967410324138 | 4.02620404940679
51, 51, 51 | 1.64705565369498 | 1.71682500461997 | 1.81860988061437 | 3.92214438268609
64, 64, 64 | 3.22818569391053 | 3.34872676329949 | 3.53253208896983 | 3.65764766027287
76, 76, 76 | 4.09627169002401 | 4.27656435874734 | 4.49740217217961 | 5.57112000922031
89, 89, 89 | 6.47443607358876 | 6.73816247347186 | 7.18639817398595 | 5.41500997591539
102, 102, 102 | 9.87334059479645 | 10.2761810962771 | 11.2372791929117 | 4.60055228868126
115, 115, 115 | 13.3962677571526 | 13.6385962976538 | 15.2099044488079 | 6.27331852523032
128, 128, 128 | 18.0268727533034 | 18.3123912984262 | 20.2225692350666 | 6.13541770362008
140, 140, 140 | 23.0520488625638 | 23.3848928108631 | 25.8025320170384 | 5.89898217590489
153, 153, 153 | 24.3698563300792 | 24.8303875794038 | 27.4227292730288 | 7.61239121495366
166, 166, 166 | 30.6646488522497 | 31.3639792035607 | 34.6000839316511 | 6.54265230275458
178, 178, 178 | 39.7826823650707 | 40.4734215004377 | 44.8732246960041 | 6.10465967870034
191, 191, 191 | 45.9559894172727 | 46.621759119472 | 52.2419036712651 | 6.87703033422927
204, 204, 204 | 53.6510852193226 | 54.3624632731595 | 60.0991025183886 | 7.14233425614169
217, 217, 217 | 61.5223441816822 | 62.4673001598481 | 69.232936234162 | 7.07668269724653
230, 230, 230 | 70.2604635449509 | 71.0251164317557 | 78.5366780254756 | 7.9421289313943
242, 242, 242 | 81.092965110497 | 81.7011489278844 | 90.552248622889 | 8.56484109521073
255, 255, 255 | 0.143051117759012 | 0.173963656077959 | 0.278707303329604 | 98.252706979969
Spreadsheet: 163779d1340457628-arrggh-dependent-drop-down-lists-dynamicdependentlists
Sheet: Sheet1

Hospital List |  | Hospital | Ward |  | Hospital | Ward |  | Hospital | Ward
[NAME] |  | [NAME] | Single Rooms Ward |  | [NAME] | Deerleap Ward |  | [NAME] | Longbeech Ward
Alton |  | Alton | [NAME] |  |  | [NAME]
[NAME] |  | Alton | Inwood Ward |  |  | Longbeech Ward
Chase |  | [NAME] | Dame [NAME] |  |  | MAU Ward
Fleet |  | Chase | Macilwain Ward |  |  | [NAME]
Fordingbridge |  | Fleet | Calthorpe Ward
Gosport |  | Fordingbridge | [NAME]
Havant |  | Gosport | Sultan Ward
Hythe |  | Havant | Havant Ward
[NAME] |  | Hythe | Hythe Ward
[NAME] |  | [NAME] | Deerleap Ward
Petersfield |  | [NAME] | [NAME]
[NAME] |  | [NAME] | Longbeech Ward
 |  | [NAME] | MAU Ward
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | Petersfield | [NAME]
 |  | [NAME] | [NAME]
Spreadsheet: phillip_m_love__31312__Gas Three RM PMA Log 0901
Sheet: -W pricing

Deal | Acctg | DPR | Difference | [NAME] | Book Name
V39732.1 Total | -75500.5 | -84400 | 8899.5 | -W | ENA-FT-WT ROX
V49298.1 Total | -320602 | -356200 | 35598 | -W | ENA-FT-WT ROX
VH4725.1 Total | 16600.5 | 25500 | -8899.5 | -W | ENA-FT-WT ROX
VK4469.1 Total | -20390.23 | -21549.99 | 1159.76 | -W | ENA-FT-WT ROX
VK4469.2 Total | 0 | 1162.51 | -1162.51 | -W | ENA-FT-WT ROX
VK4639.1 Total | -20777.73 | -21549.99 | 772.260000000002 | -W | ENA-FT-WT ROX
VK4639.2 Total | 0 | 775.01 | -775.01 | -W | ENA-FT-WT ROX
VL3038.1 Total | 72152 | 81050 | -8898 | -W | ENA-FT-WT ROX
VN2080.1 Total | -116770 | -122450 | 5680 | -W | ENA-FT-WT ROX
 |  |  |  | -W
Spreadsheet: 719710d1613760437-reverse-index-match-min-max-multiple-criteria-plus-dates-book1
Sheet: Sheet1

 | Data
 | Category | Item | Price | Date buy price
 | Fruit | Apple | 40 | 2015-07-01 00:00:00
 | Fruit | Orange | 40 | 2015-07-01 00:00:00
 | Fruit | [NAME] | 40 | 2015-07-01 00:00:00
 | Vegatable | Carrot | 45 | 2015-07-01 00:00:00
 | Vegatable | Onion | 45 | 2015-07-01 00:00:00
 | Vegatable | Potatoe | 45 | 2015-07-01 00:00:00
 | Fruit | Apple | 80 | 2016-07-01 00:00:00
 | Fruit | Orange | 80 | 2016-07-01 00:00:00
 | Fruit | [NAME] | 80 | 2016-07-01 00:00:00 |  |  | Expected
 | Vegatable | Carrot | 55 | 2016-07-01 00:00:00 |  |  | Category | Item | Price low | Price high | Date Sell Price
 | Vegatable | Onion | 55 | 2016-07-01 00:00:00 |  |  | Fruit | Apple | 20 | 80 | 2014-09-01 00:00:00
 | Vegatable | Potatoe | 55 | 2016-07-01 00:00:00 |  |  | Fruit | Orange | 20 | 70 | 2017-02-01 00:00:00
 | Fruit | Apple | 20 | 2017-07-01 00:00:00 |  |  | Fruit | [NAME] | 70 | 70 | 2018-04-01 00:00:00
 | Fruit | Orange | 20 | 2017-07-01 00:00:00 |  |  | Vegatable | Carrot | 25 | 60 | 2014-09-01 00:00:00
 | Fruit | [NAME] | 20 | 2017-07-01 00:00:00 |  |  | Vegatable | Onion | 25 | 60 | 2017-02-01 00:00:00
 | Vegatable | Carrot | 25 | 2017-07-01 00:00:00 |  |  | Vegatable | Potatoe | 60 | 60 | 2018-04-01 00:00:00
 | Vegatable | Onion | 25 | 2017-07-01 00:00:00
 | Vegatable | Potatoe | 25 | 2017-07-01 00:00:00
 | Fruit | Apple | 70 | 2018-07-01 00:00:00
 | Fruit | Orange | 70 | 2018-07-01 00:00:00
 | Fruit | [NAME] | 70 | 2018-07-01 00:00:00
 | Vegatable | Carrot | 60 | 2018-07-01 00:00:00
 | Vegatable | Onion | 60 | 2018-07-01 00:00:00
 | Vegatable | Potatoe | 60 | 2018-07-01 00:00:00
Spreadsheet: 215167d1361292667-help-multiple-nested-formula-info-book1
Sheet: Descending Times

Time | Items | Amount |  | Start Time | Difference |  | Maximum (700) |  | Time falls between 13:00-13:05 | Last Entry |  | Zero in B
2013-02-14 13:56:10 | 5 | 200 |  | 2013-02-14 13:00:00 | 400 |  | 2013-02-14 13:22:08 |  | 600 | 200 |  | 2013-02-14 13:01:53
2013-02-14 13:53:48 | 5 | 150 |  |  |  |  | 2013-02-14 12:56:48 |  |  |  |  | 2013-02-14 12:56:48
2013-02-14 13:37:09 | 5 | 100
2013-02-14 13:32:09 | 4 | 90
2013-02-14 13:27:08 | 4 | 50
2013-02-14 13:22:08 | 3 | 700
2013-02-14 13:17:04 | 2 | 200
2013-02-14 13:11:59 | 2 | 200
2013-02-14 13:06:56 | 1 | 50
2013-02-14 13:01:53 | 0 | 600
2013-02-14 12:56:48 | 0 | 700
Spreadsheet: 788966d1658825555-collate-data-from-other-sheets-by-list-selection-sample
Sheet: Store 1

 |  |  |  | Back To Main Page
 |  |  | Hours |  | Contract |  | Out's
 |  | Week | Actual | Target | Actual | Target | Training | Other | Total
 |  | Week 49 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | Week 50
 |  | Week 51
 |  | Week 52
 |  | Week 1
 |  | Week 2
 |  | Week 3
 |  | Week 4
 |  | Week 5
 |  | Week 6
 |  | Week 7
 |  | Week 8
 |  | Week 9
 |  | Week 10
 |  | Week 11
 |  | Week 12
 |  | Week 13
 |  | Week 14
 |  | Week 15
 |  | Week 16
 |  | Week 17
 |  | Week 18
 |  | Week 19
 |  | Week 20
 |  | Week 21
 |  | Week 22
 |  | Week 23
 |  | Week 24
 |  | Week 25
 |  | Week 26
 |  | Week 27
 |  | Week 28
 |  | Week 29
 |  | Week 30
 |  | Week 31
 |  | Week 32
 |  | Week 33
 |  | Week 34
 |  | Week 35
 |  | Week 36
 |  | Week 37
 |  | Week 38
 |  | Week 39
 |  | Week 40
 |  | Week 41
 |  | Week 42
 |  | Week 43
 |  | Week 44
 |  | Week 45
 |  | Week 46
 |  | Week 47
 |  | Week 48
Spreadsheet: paul_lucci__28376__Enron Daily Email Nov '01
Sheet: Nominations

CRESTONE GATHERING SERVICES, LLC
NOMINATION SUMMARY
Fort Union Gas Gathering
Contract #34003000
RECEIPTS:
 |  |  |  | 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 | TOTAL
Shipper | U/S Contract | D/S Point | D/S Contract
[NAME]EBC (Maverick)
Enron | PR-G-999 | MBW | 52700000
Enron | PR-G-999 | FTK | ENRON
Enron | PR-G-999 | FTK | 518867
Enron | PR-G-999 | MBW | 41064000
 |  |  | Total Noms
 |  |  | Ft. Union Fuel 0.1%
[NAME]BLS (Clydesdale)
Enron | PR-G-999 | MBW | 52700000
Enron | PR-G-999 | MBW | 41099000
Enron | PR-G-999 | FTK | 519773
Enron | PR-G-999 | FTK | 98
Enron | PR-G-999 | NPT | 51711000
 |  |  | Total Noms
 |  |  | Ft. Union Fuel 0.1%
[NAME]ECT (Caballo)
Enron | PR-G-999 | MBW | 52700000
Enron | PR-G-999 | NPT | 57020000
Enron | PR-G-999 | FTK | ENRON
Enron | PR-G-999 | MBW | 41064000
Enron | PR-G-999 | NPT | 51711000
 |  |  | Total Noms
 |  |  | Ft. Union Fuel 0.1%
[NAME]BPE (Bear Paw)
Enron | Citation | MBW | 52700000
Enron | Westport | MBW | 52700000
 |  |  | Total Noms
 |  |  | Ft. Union Fuel 0.1%
[NAME][NAME] (Pay Back Receipt)
Enron | PR-G-999 | MBW | fuel to 52700000 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Enron | PR-G-999 | MBW | 52700000 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Enron | PR-G-999 | FTK | KN GAS SRVC | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Enron | PR-G-999 | MBW | 41023000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0
 |  |  | Total Noms | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -34
Spreadsheet: 690498d1597146626-semi-automated-height-x-width-pricing-matrix-hxw-price-matrix
Sheet: case1

H\W | 450 | 600 | 750 | 900 | 1050 | 1200 | 1350 | 1500 | 1650 | 1800 | 1950 | 2100
600 | 40 | 46 | 52 | 58 | 64 | 70 | 76 | 82 | 88 | 94 | 100 | 106
750 | 45 | 53 | 60 | 67 | 75 | 82 | 89 | 97 | 104 | 112 | 119 | 126
900 | 50 | 59 | 68 | 77 | 85 | 94 | 103 | 112 | 121 | 129 | 138 | 147
1050 | 55 | 66 | 76 | 86 | 96 | 106 | 116 | 127 | 137 | 147 | 157 | 167
1200 | 61 | 72 | 83 | 95 | 107 | 119 | 130 | 141 | 153 | 165 | 176 | 188
1350 | 66 | 79 | 91 | 104 | 118 | 131 | 143 | 156 | 169 | 183 | 195 | 208
1500 | 71 | 85 | 99 | 114 | 128 | 143 | 157 | 171 | 186 | 200 | 214 | 229
1650 | 76 | 92 | 107 | 123 | 139 | 155 | 170 | 186 | 202 | 218 | 233 | 249
Spreadsheet: 161162d1339433935-finding-uniques-sample-vlee-oeldere-
Sheet: Sheet1

Date | Merchant
2012-01-01 00:00:00 | A
2012-01-01 00:00:00 | A
2012-01-01 00:00:00 | B |  | Merchant | A
2012-01-01 00:00:00 | C
2012-01-01 00:00:00 | A |  | Rijlabels | Aantal [NAME]
2012-01-01 00:00:00 | C |  | 2012-01-01 00:00:00 | 4
2012-01-01 00:00:00 | C |  | 2012-01-02 00:00:00 | 3
2012-01-01 00:00:00 | A |  | 2012-01-03 00:00:00 | 1
2012-01-01 00:00:00 | C |  | 2012-01-04 00:00:00 | 2
2012-01-02 00:00:00 | B |  | 2012-01-05 00:00:00 | 2
2012-01-02 00:00:00 | C |  | Eindtotaal | 12
2012-01-02 00:00:00 | A
2012-01-02 00:00:00 | A
2012-01-02 00:00:00 | B
2012-01-02 00:00:00 | C
2012-01-02 00:00:00 | A
2012-01-03 00:00:00 | C
2012-01-03 00:00:00 | C
2012-01-03 00:00:00 | A
2012-01-03 00:00:00 | C
2012-01-03 00:00:00 | B
2012-01-03 00:00:00 | C
2012-01-04 00:00:00 | A
2012-01-04 00:00:00 | A
2012-01-05 00:00:00 | B
2012-01-05 00:00:00 | C
2012-01-05 00:00:00 | A
2012-01-05 00:00:00 | C
2012-01-05 00:00:00 | C
2012-01-05 00:00:00 | A
Spreadsheet: 102839d1300783557-move-a-specific-text-from-on-column-and-append-to-another-book1_helloworld2012-
Sheet: Sheet1

Col1 | Col2 | Col3 | Select from Drop-Down > | CD12
1 | AB | AB12 |  | AB | AB12
2 | HD | CD12 |  | HD,CD12
3 | AN | CD12 |  | AN,CD12
4 | XB | CD12 |  | XB,CD12
5 | HD | YS22 |  | HD | YS22
Spreadsheet: 194498d1353209254-making-drop-down-box-with-formula-example-drop-down
Sheet: Mal 

Variable, Drop-Down | Count | Hours | Minutes | Seconds |  | ANSWER
3 | 6 | 2 | 2 | 28 |  |  | 1 | count*hours
3 |  | 3 | 5 | 34 |  |  | 2 | hours*seconds
3 | 1 | 2 | 3 | 12 |  |  | 3 | minutes*seconds
Spreadsheet: 585996d1534149331-creating-a-bar-graph-with-colors-zeszyt2
Sheet: Sheet2

[NAME]
 | empathy | 7
 | funiness | 6
 | power | 7
 | flying | 6
dw
 | empathy | 3
 | funiness | 7
 | power | 7
 | flying | 8
bsj
 | empathy | 5
 | funiness | 9
 | power | 6
 | flying | 7
Spreadsheet: 5f7c6411-0cc8-4e3a-8316-235759e31057
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0004988 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Chatham | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit: |  |  | 5000
Daily Limit:
Sample Frequency: |  |  | Monthly
Spreadsheet: 116234d1311692946-macro-to-change-sheet-name-within-a-formula-project-hours_name2_example
Sheet: 08.12.11

Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
2011-08-08 00:00:00 |  |  | 2011-08-09 00:00:00 |  |  | 2011-08-10 00:00:00 |  |  | 2011-08-11 00:00:00 |  |  | 2011-08-12 00:00:00
Project Details | Hours |  | Project Details | Hours |  | Project Details | Hours |  | Project Details | Hours |  | Project Details | Hours
Test | 5 |  | Test | 3 |  | Test | 1 |  | Test | 1 |  | Test
Total | 5 |  | Total | 3 |  | Total | 1 |  | Total | 1 |  | Total | 0
Weekly Total | 10
Spreadsheet: 761757d1641206530-problem-with-text-and-weekday-function-text-function_sample-aligw
Sheet: Sheet1

Date | =TEXT(A1,"yyyymmdd") | =Weekday(B1)
29-12-2021
29-12-2021
05-10-2021
28-07-2021
28-06-2021
28-06-2021
28-06-2021
28-06-2021
28-06-2021
28-06-2021
07-05-2021
07-05-2021
07-05-2021
11-03-2021
03-03-2021
24-02-2021
24-02-2021
23-02-2021
23-02-2021
19-02-2021
19-02-2021
19-02-2021
18-02-2021
10-02-2021
Spreadsheet: 703380d1604961397-looping-through-data-outputting-a-specific-value-sampg-1-
Sheet: Sheet1

ID | JOB | FLOW | EXPECTED CALC:
1180634 | Job-172416 | NO | NO
1180634 | [NAME] | Final -> | Final ->
1180634 | [NAME] | Final -> | Final ->
1180634 | [NAME] | Final -> | Final ->
1180634 | [NAME] | Final -> | Final ->
1181121 | [NAME] | NO | NO
1181121 | [NAME] | NO | NO
1181121 | [NAME] | Final -> | Final ->
1181121 | [NAME] | Final -> | Final ->
1180803 | Job-174173 | 100 | 100
1180803 | Job-174173 | 100 | 100
1180803 | Job-174173 | 100 | 100
1180803 | Job-174173 | 100 | 100