tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86e48449-31e7-4e18-b627-96ae231f9a2e
Sheet: Fields 1 - WC

Permit No.: |  |  | WQ0012948 |  |  | Facility Name: |  | [NAME] for Wildlife Education |  |  |  |  |  | County: | Transylvania |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | Wetland Cell
 |  |  |  |  |  | Area (acres): |  | 0.6 |  | Area (acres): |  | 0.6 |  | Area (acres): |  | 0.56 |  | Area (acres): |  | 0.17
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 62.4 |  | Annual Rate (in): |  | 62.4 |  | Annual Rate (in): |  | 62.4 |  | Annual Rate (in): |  | 62.4
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 152499d1335413678-how-can-i-average-24-cells-then-avg-the-next-24-cells-averages-on-24-and-next
Sheet: Sheet1

77
51
59
18
62
42
44
12
18
17
31
97
78
37
85
40
87
83
33
36
28
40
65
45
98
55
85
33
28
83
31
88
88
51
29
91
19
98
79
69
14
32
36
87
9
44
51
87
93
83
40
45
83
64
74
54
78
53
64
50
34
75
63
17
57
41
39
44
86
13
93
35
38
31
25
94
53
56
12
63
63
52
Spreadsheet: 120742d1315493839-can-this-be-done-with-lookup-test1
Sheet: Sheet1

File-1
Item Code | Qty Ordered
1001 | 50
1305 | 400
2300 | 25
4000 | 275
500 | 85
File-2
 | Code based on qty ordered
 | A1 | A2 | B2 | B3 | B5 | C1
Item Code
500 | 100 | 90 | 80 | 75 | 65 | 50
750 | 200 | 175 | 150 | 100 | 80 | 75
1001 | 40 | 50 | 90 | 100 | 150 | 200
1200 | 300 | 280 | 230 | 200 | 150 | 100
1305 | 400 | 350 | 300 | 200 | 220 | 200
2300 | 45 | 40 | 30 | 20 | 15 | 10
2500 | 90 | 75 | 65 | 45 | 35 | 25
4000 | 500 | 400 | 350 | 300 | 250 | 200
Output wanted (With third column automatically populated using formulae)
Item Code | Qty Ordered | Order Code (based on quantity ordered)
1001 | 50 | C1
1305 | 400 | A1
2300 | 25 | B2
4000 | 275 | B3
500 | 85 | A2
Spreadsheet: 53183d1253115932-cumulative-this-period-totals-cumulative-costs
Sheet: Period 4 cum

Cost Centre | Department | Emp.Ref. | Name | Tax Year/Period | PAY 2 | PAY 001 | C/Forward | Gross Pay | Income Tax | [NAME] | DED 1 | B/Forward | Total Deds | Net Pay | Ers NIC | Stat.Rebate
1 | 123 | 999999999 | MCTEST T | 2009/04 | 3400 | 2456 | 0 | 5000 | 41000 | 2363.24 | 500 | 0 | 43863.24 | 161136.76 | 26179.07 | 0
2 | 345 |  |  |  | 2356 | 32 |  | 5469
3 | 456 |  |  |  | 2347 | 56 |  | 2145
4 | 567 |  |  |  | 2356 | 45 |  | 3256
5 | 678 |  |  |  | 2147 | 78 |  | 6589
6 | 345 |  |  |  | 2145 | 96 |  | 3546
7 | 987 |  |  |  | 6589 | 35 |  | 2156
8 | 7645 |  |  |  | 3256 | 26 |  | 3698
9 | 457 |  |  |  | 2135 | 14 |  | 2541
10 | 879 |  |  |  | 2145 | 59 |  | 236
11 | 908 |  |  |  | 5789 | 57 |  | 2356
12 | 709 |  |  |  | 2365 | 58 |  | 9865
13 | 678 |  |  |  | 5698 | 53 |  | 6547
Spreadsheet: 15594136-efc3-4d8d-941f-c3d11b8b9bb0
Sheet: R

Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
Religious Studies
RELS 112 | Civilizations-Philosophy & Religious Studies
RELS 205 | Civilizations-Philosophy & Religious Studies
RELS 210 | Civilizations-Philosophy & Religious Studies
RELS 211 | Civilizations-Philosophy & Religious Studies
RELS 212 | Civilizations-Philosophy & Religious Studies
RELS 215 | Civilizations-Philosophy & Religious Studies
RELS 217 | Civilizations-Philosophy & Religious Studies
RELS 221 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 222 | Civilizations-Philosophy & Religious Studies
RELS 223 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 225 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 227 | Civilizations-Philosophy & Religious Studies
RELS 228 | Civilizations-Philosophy & Religious Studies
RELS 229 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 230 | Civilizations-Philosophy & Religious Studies
RELS 231 | Civilizations-Philosophy & Religious Studies
RELS 235 | Civilizations-Philosophy & Religious Studies
RELS 237 | Civilizations-Philosophy & Religious Studies
RELS 240 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 243 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 245 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 247 | Civilizations-Philosophy & Religious Studies | Experiential-Travel | J-Term 2012
RELS 248 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 251 | Civilizations-Philosophy & Religious Studies
RELS 260 | Civilizations-Philosophy & Religious Studies
RELS 262 | Civilizations-Philosophy & Religious Studies
RELS 271 | Civilizations-Philosophy & Religious Studies
RELS 273 | Civilizations-Philosophy & Religious Studies
RELS 274 | Civilizations-Philosophy & Religious Studies
RELS 275 | Civilizations-Philosophy & Religious Studies
RELS 311 | Civilizations-Philosophy & Religious Studies
RELS 312 | Civilizations-Philosophy & Religious Studies
RELS 323 | Civilizations-Philosophy & Religious Studies
RELS 335 | Civilizations-Philosophy & Religious Studies
RELS 336 | Civilizations-Philosophy & Religious Studies
RELS 343 | Civilizations-Philosophy & Religious Studies
RELS 352 | Civilizations-Philosophy & Religious Studies
RELS 375 | Civilizations-Philosophy & Religious Studies
RELS 384 | Civilizations-Philosophy & Religious Studies
RELS 401 |  | Capstone
RELS 487-488 |  | Experiential-Research
RELS 491-492 |  | Experiential-Research
RELS 496-498 |  | Experiential-Research
Spreadsheet: 648586d1573120067-dropdown-list-dependent-on-2-criterias-excel_dropdown-example_answer
Sheet: Entry Data

Region | Productcode | Category | Permittance | Comments | Color | helper
USA | 123 | Clothes
Spreadsheet: 152028d1335217644-query-a-separate-sheet-for-a-top-10-performance-dummy-performance
Sheet: Data_Table

Performer Data
2012-01-01 00:00:00
Agency Rating
123 | 0
3245 | 0
789 | 0
No Agency | 0
 |  |  |  |  | All data is rolling 12 months unless noted
 |  |  |  |  | Top 10 Criteria
 |  |  |  |  | 450 | 350 | 0.8948717948717949 | 0.838150289017341 | 0.95 | 268.73 | 45000 | 270.35 | 1125 | 97
 |  |  |  | Score | Highest 1 | Highest 2 | Highest 3 | Highest 4 | Highest 5 | Highest 6 | Highest 7 | Highest 8 | Highest 9 | Highest 10
 | Agent Name | Agent # | Agency Name |  | [Best Pipeline Volume] | [Best New Sales Volume] | [Best Conversation Ratio] | [Best Long Term  Retention Rate] | [Best Short Term Retention Rate] | [Best Growth in Membership] | [Largest Block] | [Best Up Seller] | [Best Long Term Performance] | [Best Short Term Performance]
 | Human | E106429 | 789 |  | 360 | 300 | 0.8333333333333334 | 0.78 | 0.95 | 234 | 25000 | 225 | 2000 | 675
 | Human | E163148 | 123 |  | 390 | 349 | 0.8948717948717949 | 0.77 | 0.86 | 268.73 | 40000 | 199.5 | 1800 | 772
 | Human | D041211 | 123 |  | 300 | 240 | 0.8 | 0.56 | 0.75 | 134.4 | 36000 | 216.25 | 2200 | 450
 | Human | [NAME] | 123 |  | 280 | 221 | 0.7892857142857143 | 0.42 | 0.77 | 92.82 | 2000 | 270.35 | 1750 | 312
 | Human | E162936 | 123 |  | 450 | 350 | 0.7777777777777778 | 0.76 | 0.82 | 266 | 16000 | 235.25 | 1125 | 495
 | Human | E168993 | 123 |  | 300 | 229 | 0.7633333333333333 | 0.72 | 0.81 | 164.88 | 21000 | 212.1 | 1685 | 97
 | Human | P204543 | 789 |  | 312 | 261 | 0.8365384615384616 | 0.83 | 0.92 | 216.63 | 32000 | 262.12 | 1298 | 900
 | Human | P148806 | 3245 |  | 346 | 290 | 0.838150289017341 | 0.838150289017341 | 0.88 | 243.0635838150289 | 45000 | 201.52 | 1877 | 111
 | Human | A167670 | 3245 |  | 402 | 322 | 0.8009950248756219 | 0.79 | 0.9 | 254.38 | 26000 | 239.5 | 1645 | 152
 | Human | A050588 | 3245 |  | 356 | 242 | 0.6797752808988764 | 0.6797752808988764 | 0.74 | 164.5056179775281 | 45000 | 245.49 | 1485 | 777
 | Human | A293807 | 3245
 | Human | E064388 | 3245
 | Human | [NAME] | 3245
 | Human | E012675 | 3245
 | Human | P179633 | 3245
 | Human | D059724 | 3245
 | Human | P224108 | 3245
 | Human | P060832 | 3245
 | Human | D041211 | 3245
 | Human | P139920 | 3245
 | Human | A047447 | 3245
 | Human | P236125 | 3245
 | Human | E106429 | 3245
 | Human | E163148 | 3245
 | Human | D041211 | 3245
 | Human | P003873 | 3245
 | Human | E091806 | 3245
 | Human | P204543 | 3245
 | Human | P148806 | 3245
 | Human | A167670 | 3245
 | Human | A050588 | 3245
 | Human | A293807 | 3245
 | Human | E064388 | 3245
 | Human | [NAME] | 3245
 | Human | E012675 | 3245
 | Human | P179633 | 3245
 | Human | D059724 | 789
 | Human | P224108 | 789
 | Human | P060832 | 789
 | Human | D041211 | 789
 | Human | P139920 | 789
 | Human | A293807 | No Agency
 | Human | E064388 | No Agency
 | Human | [NAME] | 789
 | Human
 | Human
 | Human
 | Human
 | Human
 | Human
Spreadsheet: 44688d1243452905-excel-2007-if-function-excel-forum-vlookup
Sheet: List2

[NAME] | Št. Prejema | Šifra | Poz. | Material | [NAME] | Kval. | Dimenzija (mm) | Kol. ([NAME]) | Kol. (m) | Kos. | [NAME] | Št. Plošče | A-TEST | [NAME] | Nalog
Exterfer | 000115 | 10292 | 1 | Pločevina |  | ST-37 | 10x2500x8000 | 1600 |  | 1 | 918168-911894-1-3 |  | [NAME] | Metalna IMPRO\Material\Dobavnice\2009\Exterfer\001.jpg
 |  | 10313 | 2 | Pločevina |  | ST-37 | 8x2500x6000 | 960 |  | 1 | 916336-29-01 |  | [NAME]
Exterfer | 000116 | 10299 | 1 | Pločevina |  | ST-37 | 25x1500x6000 | 1800 |  | 1 | 628968 |  | [NAME] | Metalna IMPRO\Material\Dobavnice\2009\Exterfer\002.jpg
Inox Center | 000114 | 10255 | 1 | Pločevina | Nr. | 1.4301 | 4x1000x2000 | 640 |  | 10 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Inox-Center\001.jpg
 |  | 10258 | 2 | Pločevina | Nr. | 1.4301 | 4x1500x3000 | 864 |  | 6
 |  | 10243 | 3 | Pločevina | Nr. | 1.4301 | 1.5x1500x3000 | 109.6 |  | 2
 |  | 10248 | 4 | Pločevina | Nr. | 1.4301 | 2x1500x3000 | 216 |  | 3
Al/Cu Domžale | 000117 | 10194 | 1 | Kotnik | Nr. enakokraki | Al | 8x80 | 41 | 12 | 2 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Al-Cu\0001.jpg
Pahor | 000118 |  | 1 | Jeklo | Nr. ploščato | 1.4301 | 3x25 | 47 | 12 | 4 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Pahor\0001.tif
 |  | 10018 | 2 | Cev | Nr. šivna okrogla | 1.4301 | 48.3x2 |  | 42 | 7
 |  | 10103 | 3 | [NAME] | Nr. | 1.4301 | 48.3x2 |  |  | 4
 |  |  | 4 | Pločevina | Nr. | 1.4301 | 3x1500x4000 | 283 |  | 2
 |  |  | 5 | Pločevina | Nr. | 1.4301 | 4x1000x4000 | 249 |  | 2
 |  |  | 6 | Pločevina | Nr. | 1.4301 | 4x1000x3000 | 93 |  | 1
 |  |  | 7 | Pločevina | Nr. | 1.4301 | 4x1000x2000 | 63 |  | 1
 |  | 10018
So what i want is:
IF D2,E2,F2,G2,H2 |  | Match with the values in Sheet1 then copy the value from row A on sheet 1 to C2 and so on
IF function - Excel Help Forum
Spreadsheet: 813399d1673719440-cond-formatting-formula-needed-to-color-a-cell-based-on-2-other-cells-data-conditional-format
Sheet: Sheet1

 | Date | ISO | ISR | CNV | Customer | Status | # | Status Date | DAYS | MAX | Address | City | ST | Zip
 | 2023-01-13 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | PEND Adj. Meeting | 3 | 2023-01-07 00:00:00 |  |  | 123 apple st | dallas | TX | 30012
Spreadsheet: 96050d1295528350-formula-for-interval-prices-760865_noviceswede
Sheet: Blad1

Length | [NAME] | Amount | Worktime h /pcs | Total Worktime (rules as below)
1000 | 500 | 10 | 10
1000 | 600 | 1 | 10
1000 | 700 | 50 | 10
Rules
Pcs 1-3, worktime 10 x 2 per piece |  |  |  | How do I make a formula for such rules?
Pcs 4-10, worktime 10 x 1.5 per piece
Pcs >10, worktime 10 x 1 per piece (standard rate)
Spreadsheet: 829883d1684508714-return-item-description-if-value-greater-than-zero-sample-data-set
Sheet: sheet1

[NAME] to only pull back items with value greater than zero and =C1 | Value Formula | 2023 | Enter year
SAUCE, SEAFOOD
BASE, GREEN CURRY
SHRIMP, 16/20 CB ROUND
SHRIMP, 16/20 CB FLAT
SHRIMP, 26/30 PRE-BRD CRISPY
SHRIMP, 21/23 PRE-BRD LRG
SHRIMP, 16/18 RANGOON
SHRIMP, 14/16 PRE-BRD CCNT
SHRIMP, 36/40 PD TAIL-OFF
SHRIMP, 26/30 WHT SKEWER
SHRIMP, 21/25 JMB COCKTAIL
SHRIMP, 16/20 RAW
SHRIMP, 31/35 RAW IQF
CRAB, OPILIO CLUSTERS
Spreadsheet: 124269d1318279215-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example3
Sheet: Hooker

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES
8964 |  |  | SSS Sig | 2011-09-01 00:00:00 |  | To NELSON 1st for SSS Sig 9/1 | Total # Yellow: | 0
57659 |  |  | D/C Sig | 2011-09-13 00:00:00 |  | ATT/sent to carmen | Total # Orange: | 2
64748 |  |  | D/C Sig | 2011-09-13 00:00:00 |  | DO, ATT  to [NAME] next | Total # Red: | 1
19183 |  |  | D/C  Dict |  |  | DO/ PN-Nelson pt needs chart | Complient: | 2
22801 |  |  | ATT |  |  | To [NAME] 1st | All Total: | 3
66323 |  |  | DO |  |  | ATT, checked out to [NAME]
73942 |  |  | DO |  |  | ATT, To [NAME] next
79968 |  |  | ATT |  |  | In [NAME]'s box
Spreadsheet: 700028d1602908632-formula-to-extract-data-based-on-month-and-year-extract-profits
Sheet: Source Data

 | 2019-10-01 00:00:00 | 2019-11-30 00:00:00 | 2019-12-31 00:00:00 | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00
Dept1 | 1372 | 24256 | -2214 | 16883 | 5766 | 72022 | 85015 | 60125 | -22145 | 45125 | 30185 | 90358
Dept2 | 20762.74933333333 | 25353.09333333333 | 29764.506 | 16542.99333333334 | 20720.564 | 1593.458 | 6826.338266666667 | 3313.036628571427 | -200.2650095238427 | -3713.56664761904 | -7226.868285714333 | -10740.16992380953
Dept3 | 15442.94033333333 | 17228.84733333333 | 16793.18266666667 | 21141.468 | 16698.47933333333 | 16818.52233333333 | 18317.4158 | 18592.70412380953 | 18867.99244761907 | 19143.2807714286 | 19418.56909523806 | 19693.8574190476
Dept4 | 24686.335 | 27093.99566666667 | 22422.78966666667 | 18538.71766666667 | 15402.05133333333 | 24938.53266666667 | 18410.512 | 17333.40009523813 | 16256.2881904762 | 15179.17628571433 | 14102.0643809524 | 13024.95247619053
Spreadsheet: 01b345e6-0223-4682-bef5-3a9f1ab8dd02
Sheet: Sheet1

2013-02-01 00:00:00 | Unnamed: 1 | Mental Holds (I.C. 66-326) by Ordering County | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  | 2013-02-01 00:00:00 |  |  |  |  |  | [NAME] -YTD
 |  | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total
Region 1 | Benewah |  |  |  |  | 0 | 51 |  | 3 |  |  | 3 | 392
 | [NAME] |  | 6 |  |  | 6 |  | 2 | 36 |  | 1 | 39
 | Boundary |  |  |  |  | 0 |  |  | 1 |  | 1 | 2
 | Kootenai | 3 | 32 |  | 9 | 44 |  | 65 | 207 | 1 | 63 | 336
 | Shoshone |  | 1 |  |  | 1 |  | 2 | 9 |  | 1 | 12
Region 2 | Clearwater | 1 | 1 |  |  | 2 | 16 | 3 | 2 | 2 | 2 | 9 | 136
 | Idaho |  |  |  |  | 0 |  |  |  | 6 |  | 6
 | Latah | 5 | 2 |  |  | 7 |  | 20 | 11 | 3 | 2 | 36
 | Lewis |  |  |  |  | 0 |  |  |  | 2 |  | 2
 | Nez Perce | 5 | 2 |  |  | 7 |  | 45 | 35 | 1 | 2 | 83
Region 3 | Adams |  |  |  |  | 0 | 80 | 2 | 4 |  | 3 | 9 | 701
 | Canyon | 42 | 31 |  |  | 73 |  | 282 | 308 |  | 11 | 601
 | Gem | 2 | 2 |  |  | 4 |  | 16 | 13 |  |  | 29
 | Owyhee |  |  |  |  | 0 |  | 9 | 7 |  | 1 | 17
 | Payette |  | 3 |  |  | 3 |  | 8 | 17 |  |  | 25
 | Washington |  |  |  |  | 0 |  | 11 | 9 |  |  | 20
Region 4 | [NAME] | 93 | 51 | 9 |  | 153 | 155 | 729 | 449 | 81 | 3 | 1262 | 1305
 | Boise |  |  |  |  | 0 |  |  | 5 |  |  | 5
 | Elmore |  | 2 |  |  | 2 |  | 10 | 20 | 3 |  | 33
 | Valley |  |  |  |  | 0 |  | 3 | 2 |  |  | 5
Region 5 | Blaine | 1 | 1 |  |  | 2 | 45 | 21 | 2 |  |  | 23 | 348
 | [NAME] | 1 |  |  |  | 1 |  | 2 | 1 |  |  | 3
 | Cassia |  | 1 |  |  | 1 |  | 14 | 7 |  | 1 | 22
 | Gooding | 1 | 1 |  |  | 2 |  | 11 | 7 |  |  | 18
 | [NAME] | 4 |  |  |  | 4 |  | 13 | 4 |  |  | 17
 | Lincoln | 1 | 2 |  |  | 3 |  | 9 | 5 |  |  | 14
 | Minidoka | 4 | 1 |  |  | 5 |  | 18 | 5 |  |  | 23
 | [NAME] | 20 | 6 |  | 1 | 27 |  | 180 | 46 |  | 2 | 228
Region 6 | Bannock | 8 |  |  | 2 | 10 | 10 | 122 | 10 |  | 14 | 146 | 165
 | Bear Lake |  |  |  |  | 0 |  | 2 |  |  |  | 2
 | [NAME] |  |  |  |  | 0 |  |  |  |  |  | 0
 | Franklin |  |  |  |  | 0 |  | 4 | 5 |  | 1 | 10
 | Oneida |  |  |  |  | 0 |  |  | 1 |  |  | 1
 | Power |  |  |  |  | 0 |  | 4 | 1 |  | 1 | 6
Region 7 | Bingham |  |  |  | 8 | 8 | 35 | 8 | 5 |  | 54 | 67 | 280
 | [NAME] |  | 4 |  | 15 | 19 |  | 8 | 24 |  | 112 | 144
 | [NAME] |  |  |  |  | 0 |  |  |  |  |  | 0
 | [NAME] |  |  |  |  | 0 |  |  |  |  |  | 0
 | Custer |  |  |  |  | 0 |  |  |  |  | 2 | 2
 | Fremont |  | 1 |  |  | 1 |  |  | 3 |  | 5 | 8
 | [NAME] |  |  |  | 2 | 2 |  | 3 | 1 |  | 15 | 19
 | Lemhi |  |  |  |  | 0 |  | 1 | 2 |  | 7 | 10
 | [NAME] |  | 1 |  | 2 | 3 |  | 3 | 1 |  | 18 | 22
 | Teton | 1 |  |  | 1 | 2 |  | 1 | 2 |  | 5 | 8
Out of State and Other |  |  |  |  |  | 0 | 0 | 5 |  |  |  | 5 | 5
Statewide |  | 192 | 151 | 9 | 40 | 392 | 392 | 1636 | 1270 | 99 | 327 | 3332 | 3332
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: Feb 2021

Subscriptions | [NAME] | [NAME] | Difference
Gas |  | 25
Gas
Net Flix |  | 12.99
Cox |  | 161.98
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Club carwash | 21.75
Discovery plus | 7.78
Chewy | 56.71
Sprint | 135.83
Total
one half | 144.99 | 99.98 | 45.01 | luci owes
Spreadsheet: phillip_m_love__30063__CentralFRED0600adj
Sheet: Summary

Financial Liquidation Variance Summary
PRODUCTION MONTH:  6/00
DESK: Central
 |  |  |  |  | To be updated by Economic & Gas Acctng:
 |  |  |  |  |  | Remaining
 | per OA reports |  | per [NAME] | var | Resolved Amt | To Be Resolved | expl
NGP&L LIQUIDATIONS | 7700994
Less (refer to [NAME]):
Discrepancies between Actuals & Flash | 1838613.027 |  |  |  | 0
Discrepancies between OA flash and details |  |  |  |  | 0
In Actuals, not [NAME] (unexplained) |  |  |  |  | 0
Not TAGG related:Reclass inv profits to storage reconciliation
Restated NGP&L
GL LIQUIDATIONS
Less (refer to [NAME]):
Direct offset in Central & Ontario FL & GL, need reclass of value | -3361859.5698 |  |  |  | 0
Direct offset in Central & People FL, need reclass of value | 925000 |  |  |  | 0
Direct offset in Central & Sithe FL, need reclass of value | -6299.95499999999 |  |  |  | 0
In Central FL, [NAME], change mapping | 72500 |  |  |  | 0
In FL not GL, Acct to look at |  |  |  |  | 0
In [NAME], Central GL, change mapping | -1226261.3599 |  |  |  | 0
In Sithe FL, Central GL, change mapping | -524584.428 |  |  |  | 0
Discrepancies between Actuals & Flash
[NAME]
GL Adjustments
In Actuals, not [NAME] (unexplained)
Not TAGG related:Unknown entry in OA report
Restated Actuals
[NAME]
unexplained
Spreadsheet: 860253d1708425883-conditional-formatting-turn-blank-cell-yellow-and-when-text-entered-blank-on-conditional-formatting-cells-turn-blank-when-text-entered-updated
Sheet: Sheet1

NAME | SURNAME | ADDRESS | CONTACT NO | YES/NO
PETER
PAUL |  | 2 SMITH STREET
JULIA | SMITH | 22 CHURCH STREET
ANDREW | MC [NAME] |  |  | Yes
With Conditional Formatting applied
Nico |  | 5 Kerkstraat
 | Smuts |  | 12345
Pieter | [NAME] |  |  | Yes
CONDITIONAL FORMATTING   (1)  When information is typed in Column A -         - All the cells of the table have a border         - and turn yellow  (2)  When data is entered in the cells it turns blank  (3)  Empty cells in Column A remains blank until text are entered
Spreadsheet: andy_zipper__246__DYNEGY-ICE VOL Jun5
Sheet: E-Mail

 | 2001-06-05 00:00:00
 | Intercontinental Exchange |  |  |  | Enron's Activity on ICE
 | Commodity | ICE Volume | EOL US Volume (approx) |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  |  | ECC
 | TOTAL CRUDE PRODUCTS (BBL)
 |  |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  |  | EPM | POWER
 |  |  |  |  | ENA | POWER
 |  |  |  |  | ENA | US NATURAL GAS
 |  |  |  |  | ENA | COAL
 |  |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: 159146d1338515673-count-the-number-of-unique-values-given-certain-conditions-count-of-unique-phone-numbers
Sheet: Sheet1

Name | Month | direction of call | Number |  | REFFERENCES | how many unique calls were made by each person in August? | description of results
[NAME] | August | Outbound | 5551234567 |  | [NAME] | 6 | [NAME] made 7 total calls in august to 6 unique phone numbers ([NAME], August, outbound)
[NAME] | August | Outbound | 5551234567 |  | [NAME] | 3 | [NAME] made 3 total calls in august to 3 unique phone numbers ([NAME], August, outbound)
[NAME] | August | Outbound | 6661234567 |  | erin | 2 | erin made 5 total calls in august to 2 unique phone numbers (erin, August, outbound)
[NAME] | August | Outbound | 8881234567
[NAME] | August | Outbound | 9991234567 |  | Outbound
[NAME] | August | Outbound | 4441234567 |  | August
[NAME] | August | Outbound | 3331234567
[NAME] | August | Inbound | 2221234567
[NAME] | August | Inbound | 2221234567 |  |  |  | [NAME]
[NAME] | August | Inbound | 2221234567
[NAME] | August | Inbound | 8881234567
[NAME] | August | Inbound | 9991234567
[NAME] | August | Inbound | 4441234567
[NAME] | August | Inbound | 3331234567
[NAME] | August | Outbound | 8591234567
[NAME] | August | Outbound | 4041234567
[NAME] | August | Outbound | 2141234567
[NAME] | August | Inbound | 8591234567
[NAME] | August | Inbound | 8591234567
[NAME] | August | Inbound | 2141234567
erin | August | Outbound | 5131234567
erin | August | Outbound | 5131234567
erin | August | Outbound | 6141234567
erin | August | Outbound | 6141234567
erin | August | Outbound | 6141234567
erin | August | Inbound | 2221234567
erin | August | Inbound | 5131234567
erin | August | Inbound | 6141234567
erin | August | Inbound | 6141234567
erin | August | Inbound | 6141234567
[NAME] | September | Outbound | 5551234567
[NAME] | September | Outbound | 5551234567
[NAME] | September | Outbound | 6661234567
[NAME] | September | Outbound | 8881234567
[NAME] | September | Outbound | 9991234567
[NAME] | September | Outbound | 4441234567
[NAME] | September | Outbound | 3331234567
[NAME] | September | Inbound | 2221234567
[NAME] | September | Inbound | 2221234567
[NAME] | September | Inbound | 2221234567
[NAME] | September | Inbound | 8881234567
[NAME] | September | Inbound | 9991234567
[NAME] | September | Inbound | 4441234567
[NAME] | September | Inbound | 3331234567
[NAME] | September | Outbound | 8591234567
[NAME] | September | Outbound | 4041234567
[NAME] | September | Outbound | 2141234567
[NAME] | September | Inbound | 8591234567
[NAME] | September | Inbound | 8591234567
[NAME] | September | Inbound | 2141234567
erin | September | Outbound | 5131234567
erin | September | Outbound | 5131234567
erin | September | Outbound | 6141234567
erin | September | Outbound | 6141234567
erin | September | Outbound | 6141234567
erin | September | Inbound | 2221234567
erin | September | Inbound | 5131234567
erin | September | Inbound | 6141234567
erin | September | Inbound | 6141234567
erin | September | Inbound | 6141234567