tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 672413d1586866132-vlookup-hlookup-for-question-3
Sheet: Store Inventory

Primary DC | Store | SKU > | 19750 | 68880 | 94530 | 122990 | 125040 | 125190 | 131790 | 132490 | 132690 | 132750 | 133760 | 134060 | 134070 | 134080 | 134450 | 134700 | 134770 | 134780 | 134800 | 134820 | 134850 | 134860 | 134950 | 134990 | 135080 | 135250 | 135580 | 135600 | 135620 | 135960 | 135970 | 135980 | 201350 | 204440 | 238420 | 238870 | 239500 | 243430 | 243900 | 244040 | 248870 | 248890 | 258080 | 305830 | 311540 | 333651 | 333950 | 335380 | 336540 | 336860 | 342380 | 342720 | 342970 | 343350 | 372280 | 459850 | 487500 | 548930 | 645350 | 645360 | 645550 | 645560 | 645670 | 645680 | 673490 | 755940 | 787640 | 808220
DC04 - DUNN, NC | 40 |  | 8 | 28 | 6 | 12 | 12 | 7 | 30 | 0 | 18 | 119 | 11 | 15 | 9 | 11 | 7 | 104 | 89 | 116 | 80 | 56 | 56 | 57 | 162 | 77 | 37 | 35 | 19 | 15.206 | 15 | 64 | 27 | 55 | 813 | 6 | 4 | 5 | 4 | 6 | 7 | 7 | 3 | 9 | 8 | 0 | 11 | 22 | 24 | 55 | 7 | 14 | 7 | 4 | 7 | 4 | 6 | 31 | 17 | 9 | 6 | 15 | 7 | 21 | 33 | 32 | 69 | 5 | 9 | 5
DC04 - DUNN, NC | 57 |  | 16 | 16 | 6 | 4 | 6 | 14 | 27 | 23 | 29 | 0 | 14 | 19 | 10 | 12 | 24 | 102 | 92 | 78 | 80 | 176 | 69 | 71 | 152 | 101 | 31 | 29 | 19 | 21.826 | 11 | 78 | 35 | 24 | 236 | 5 | 6 | 4 | 12 | 2 | 8 | 5 | -1 | 7 | 14 | 3 | 10 | 14 | 0 | 74 | 28 | 17 | 7 | 2 | 6 | 2 | 4 | 32 | 6 | 10 | 4 | 7 | 10 | 6 | 17 | 8 | 39 | 2 | 10 | 13
DC04 - DUNN, NC | 59 |  | 23 | 21 | 8 | 10 | 10 | 10 | 23 | 35 | 64 | 0 | 14 | 3 | 8 | 18 | 16 | 79 | 109 | 153 | 62 | 141 | 51 | 91 | 149 | 94 | 46 | 12 | 21 | 33.884 | 22 | 50 | 21 | 37 | 93 | 5 | 1 | 11 | 2 | 4 | 7 | 3 | 10 | 13 | 9 | 9 | 13 | 17 | 0 | 86 | 13 | 9 | 5 | 3 | 9 | 10 | 5 | 37 | 6 | 3 | 28 | 4 | 23 | 22 | 37 | 10 | 21 | 10 | 11 | 7
DC04 - DUNN, NC | 61 |  | 9 | 17 | 5 | 7 | 3 | 14 | 6 | 34 | 24 | 0 | 7 | 10 | 5 | 10 | 27 | 80 | 96 | 138 | 151 | 133 | 92 | 115 | 193 | 132 | 43 | 29 | 6 | 11.195 | 18 | 17 | 19 | 28 | 122 | 9 | 9 | 6 | 12 | 8 | 6 | 4 | 6 | 7 | 6 | 6 | 7 | 12 | 0 | 77 | 15 | 9 | 9 | 7 | 10 | 7 | 6 | 26 | 13 | 11 | 18 | 14 | 2 | 22 | 31 | 5 | 45 | 6 | 8 | 10
Spreadsheet: 773388d1647850307-if-a1-is-b1-mark-1-if-form
Sheet: Sheet1

A | B | C | D | E | F | G | H
AMANDLA | DLN | AAA | M |  | s | 25213 | AAADLMN | AMANDLA
MANDALA | DLN | AAA | M |  | s | 25214 | AAADLMN
CANALED | DLN | AAE | C |  |  | 8049 | AACDELN
CANDELA | DLN | AAE | C |  | s | 8050 | AACDELN
DECANAL | DLN | AAE | C |  |  | 8051 | AACDELN
LEADMAN | DLN | AAE | M |  |  | 8066 | AADELMN
ADRENAL | DLN | AAE | R |  | s | 1666 | AADELNR
LANATED | DLN | AAE | T |  |  | 1667 | AADELNT
DANELAW | DLN | AAE | W |  | s | 8068 | AADELNW
ADNEXAL | DLN | AAE | X |  |  | 12776 | AADELNX
Spreadsheet: 2a43301f-a8b0-4c15-be16-5939207c510d
Sheet: Sheet1

Widerøe's Flyveselskap AS | Unnamed: 1 | Unnamed: 2
Resultatregnskap
(Nok 1.000) | 30.09.11 | 30.09.10
Driftsinntekter
Salgsinntekter | 1887141 | 1567133
Andre inntekter | 538740 | 519431
[NAME] | 2425881 | 2086564
Driftskostnader
Lønnskostnader | 844712 | 752402
Ordinære avskrivninger | 91617 | 88644
Annen driftskostnad | 387415 | 404119
Driftskostnader fly og bygninger | 393780 | 298260
Avgifter og provisjoner | 262405 | 285584
[NAME] og leasingkostnader | 140619 | 129696
Sum driftskostnader | 2120548 | 1958705
[NAME] | 305333 | 127859
Finansinntekter(-)/kostnader
Investering i datterselskap | -4924 | -4659
Renteinntekter | -3661 | -1588
Andre finansinntekter | 0 | -9826
Rentekostnader | 9047 | 11890
Andre finanskostnader | 43803 | 32554
Netto finanskostnader | 44265 | 28371
[NAME] resultat før skattekostnad | 261068 | 99488
Widerøe's Flyveselskap AS
Balanse
(Nok 1.000) | 30.09.10 | 30.09.10
Eiendeler
Anleggsmidler
[NAME] driftsmidler
Bygninger | 84169 | 85609
Fly | 271552 | 203133
Motorer | 112170 | 132686
[NAME] | 326980 | 317917
[NAME], verktøy, inventar | 32104 | 27556
Sum varige driftsmidler | 826975 | 766901
Finansielle anleggsmidler
Investering i datterselskap | 9773 | 3028
Aksjer og andre verdipapirer | 40 | 40
Langsiktige fordringer | 2341 | 2545
[NAME] | 502976 | 502976
Sum finansielle anleggsmidler | 515130 | 508589
Sum anleggsmidler | 1342105 | 1275490
Omløpsmidler
Forbruksmateriell / varelager | 107832 | 105709
Fordringer
Kundefordringer | 117556 | 75343
Andre fordringer | 127096 | 135257
Sum fordringer | 244652 | 210600
Bankinnskudd, kontanter og lignende | 176884 | 46021
Sum omløpsmidler | 529368 | 362330
Sum eiendeler | 1871473 | 1637820
Widerøe's Flyveselskap AS
Egenkapital og gjeld
Egenkapital
Innskutt egenkapital
Aksjekapital | 36566 | 36566
Overkursfond | 211435 | 211435
Sum innskutt egenkapital | 248001 | 248001
Opptjent egenkapital
Fond for vurderingsforskjeller | 3436 | 3436
Annen egenkapital | 540027 | 277671
Sum egenkapital | 791464 | 529108
Gjeld
[NAME] for forpliktelser
Pensjonsforpliktelse | 40543 | 40543
[NAME] | 105151 | 104650
[NAME] avsetninger for forpliktelser | 85095 | 60515
Sum avsetning for forpliktelser | 230789 | 205708
Annen langsiktig gjeld
Gjeld til kredittinstitusjoner | 98138 | 180311
Sum langsiktig gjeld | 328927 | 386019
Kortsiktig gjeld
Gjeld til kredittinstitusjoner | 0 | 0
Leverandørgjeld | 260739 | 184891
Skyldig offentlige avgifter | 98034 | 134705
Annen kortsiktig gjeld | 392309 | 403097
Sum kortsiktig gjeld | 751082 | 722693
Sum gjeld | 1080009 | 1108712
Sum egenkapital og gjeld | 1871473 | 1637820
Spreadsheet: 748341d1632101414-irr-function-comming-out-as-number-irr-function-comming-out-as-number-
Sheet: Sheet1

 |  | Discount rate | 0.1
 | Year | Cash Flow | Time Value Factor | Discounted Cash Flow
 | 0 | 429
 | 1 | -1005
 | 2 | 599
 | Total
 |  |  | NPV
 |  |  | IRR
 | https://www.excelforum.com/excel-formulas-and-functions/1359527-irr-function-comming-out-as-number.html
Spreadsheet: 886976d1737052026-formula-for-sorting-data-example-updated
Sheet: Sheet1

Export from company inventory |  |  |  |  | Export from catalog |  | End Result
Item | UOM | List Price | Wholesale Price |  | Item |  | Item | UOM | List Price | Wholesale Price
01899 | 100PK | 11.67 | 10 |  | 0281972 |  | 0281972 | EA | 108 | 108
01899 |  | 0.1331 | 0.11 |  | 02820-TIM |  | 02820-TIM | EA | 13.75 | 11.5
0272484 |  | 3.39 | 3.05 |  | 0285684 |  | 0285684 |  | 20.69 | 19.29
0279091 |  | 3.9 | 3.73 |  | 02876-TIM |  | 02876-TIM | EA | 51 | 42.25
0280123 | BX | 5.69 | 5.12 |  | 02900 |  | 02900 | FT | 0.77 | 0.59
0280826 | PK12 | 14.6 | 13.14 |  | 01899 |  | 02900 | ROLL | 58.82 | 48.5
0281972 | EA | 108 | 108 |  | HC51213512 |  | 01899 | 100PK | 11.67 | 10
02820-TIM | EA | 13.75 | 11.5 |  | AD6600-04-04-04 |  | 01899 |  | 0.1331 | 0.11
0285684 |  | 20.69 | 19.29 |  | AD6600-05-05-05 |  | HC51213512 | BULK-100 | 84.34 | 64.88
02876-TIM | EA | 51 | 42.25 |  | AD6600-06-06-06 |  | HC51213512 | EA | 1.41 | 1.05
02900 | FT | 0.77 | 0.59 |  | 0272484 |  | HC51213512 | LB | 3.99 | 2.99
02900 | ROLL | 58.82 | 48.5 |  | 0279091 |  | HC51213512 | PKG-25 | 26.36 | 21.09
AD6600-04-04-04 | EA | 3.51 | 2.97 |  |  |  | AD6600-04-04-04 | EA | 3.51 | 2.97
AD6600-05-05-05 | EA | 5.02 | 4.25 |  |  |  | AD6600-05-05-05 | EA | 5.02 | 4.25
AD6600-06-06-06 | EA | 4.02 | 3.4 |  |  |  | AD6600-06-06-06 | EA | 4.02 | 3.4
HC51213512 | BULK-100 | 84.34 | 64.88 |  |  |  | 0272484 |  | 3.39 | 3.05
HC51213512 | EA | 1.41 | 1.05 |  |  |  | 0279091 |  | 3.9 | 3.73
HC51213512 | LB | 3.99 | 2.99
HC51213512 | PKG-25 | 26.36 | 21.09
Spreadsheet: 155950d1337112779-count-multiple-column-data-by-date-criteria-and-display-the-value-sampledata
Sheet: Sheet1

ID | Scheduled Start Date | Scheduled End Date | Team Names
CRQ000000025334 | 2012-01-03 17:00:00 | 2012-01-27 23:59:00 | Team - A
[NAME] | 2012-01-09 17:00:00 | 2012-01-19 20:00:00 | Team - B
CRQ000000025457 | 2012-01-12 17:00:00 | 2012-01-19 18:00:00 | Team - C
CRQ000000025448 | 2012-01-16 00:00:00 | 2012-01-16 23:00:00 | Team - D
[NAME] | 2012-01-16 09:00:00 | 2012-01-16 10:00:00 | Team - E
[NAME] | 2012-01-16 09:00:00 | 2012-01-16 16:00:00 | Team - F
CRQ000000025538 | 2012-01-16 13:00:00 | 2012-01-18 17:00:00 | Team - G
CRQ000000025547 | 2012-01-16 14:00:00 | 2012-01-16 15:00:00 | Team - H
 |  |  |  | [NAME] in this CELL
Spreadsheet: 711723d1609864289-daily-sales-spreadsheet-month-target
Sheet: Sheet1

JANUARY 2021
Day | DATE | Daily Target | Daily Sales | Month To Date
MON | 4TH | 3125 | 2491
TUES | 5TH | 3125 | 2274
WED | 6TH | 3125
THUR | 7TH | 3125
FRI | 8TH | 3125
MON | 11TH | 3125
TUES | 12TH | 3125
WED | 13TH | 3125
THUR | 14TH | 3125
FRI | 15TH | 3125
MON | 18TH | 3125
TUES | 19TH | 3125
WED | 20TH | 3125
THUR | 21ST | 3125
FRI | 22ND | 3125
MON | 25TH | 3125
TUES | 26TH | 3125
WED | 27TH | 3125
THUR | 28TH | 3125
FRI | 29TH | 3125
TOTAL
Spreadsheet: 880188d1727808404-dynamic-calendar-with-autofilling-entries-dynamic-calendar-with-autofill
Sheet: Table

[NAME] | Customer | Planning Customer # | Key | Brand | PG3 | Pack Group | Material Code | Material Code Format Fix | Item | Review Date | Update Date | Total Fees | Volume | [NAME] |  |  | Pack Group 3
Sales Lead 1 | Customer 1 |  |  | Brand 1 |  | Pack Group 1 |  |  | Item 1 | 00:00:00 | 2025-04-01 00:00:00 | 0 | 0
Sales Lead 1 | Customer 1 |  |  | Brand 1 | 80013333 | Pack Group 1 |  |  | Item 2 | 2024-09-23 00:00:00 | 2025-03-24 00:00:00 | 14600 | 1123.076923076923
[NAME] | Customer 2 |  |  | Brand 2 | 80014444 | Pack Group 2 |  |  | Item 3 | 2024-09-23 00:00:00 | 2025-03-24 00:00:00 | 14600 | 1123.076923076923
[NAME] | Customer 3 |  |  | Brand 2 | 80011216 | Pack Group 2 |  |  | Item 4 | 2025-03-01 00:00:00 | 2025-05-01 00:00:00 | 2380 | 183.0769230769231
[NAME] | Customer 4 |  |  | Brand 3 | 80014020 | Pack Group 2 |  |  | Item 5 | 2025-03-01 00:00:00 | 2025-05-01 00:00:00 | 3400 | 261.5384615384615
[NAME] 3 | Customer 5 |  |  | Brand 3 | 80014020 | Pack Group 2 |  |  | Item 6 | 2025-03-01 00:00:00 | 2025-05-01 00:00:00 | 3400 | 261.5384615384615
[NAME] 3 | Customer 6 |  |  | Brand 4 | 80014001 | Pack Group 3 |  |  | Item 7 | 2025-09-05 00:00:00 | 2025-10-20 00:00:00 | 4080 | 313.8461538461539
[NAME] 3 | Customer 6 |  |  | Brand 4 | 80013333 | Pack Group 3 |  |  | Item 8 | 2025-09-05 00:00:00 | 2025-10-20 00:00:00 | 1700 | 130.7692307692308
[NAME] | Customer 6 |  |  | Brand 1 | 80014444 | Pack Group 2 |  |  | Item 1 | 2025-03-01 00:00:00 | 2025-05-01 00:00:00 | 1700 | 130.7692307692308
Sales Lead 5 | Customer 6 |  |  | Brand 5 | 80021111 | Pack Group 3 |  |  | Item 10 | 2025-03-01 00:00:00 | 2025-05-01 00:00:00 | 1530 | 117.6923076923077
Sales Lead 6 | Customer 1 |  |  | Brand 1 | 80022222 | Pack Group 1 |  |  | Item 2 | 2025-03-01 00:00:00 | 2025-05-01 00:00:00 | 1530 | 117.6923076923077
Spreadsheet: 46438d1245308459-using-rows-of-mismatched-values-across-sheets-bb-20stats-20sample-1-_revised
Sheet: 2008 Actual Stats

Name | G | W | L | SV | IP | H | BB | K | ERA | WHIP
Aardsma, [NAME] | 47 | 4 | 2 | 0 | 48.666667 | 49 | 35 | 49 | 5.55 | 1.72602738543817
Accardo, Jeremy | 16 | 0 | 3 | 4 | 12.333333 | 15 | 4 | 5 | 6.57 | 1.54054058217677
Aceves, Alfredo | 6 | 1 | 0 | 0 | 30 | 25 | 10 | 16 | 2.4 | 1.16666666666667
Acosta, [NAME] | 46 | 3 | 5 | 3 | 53 | 48 | 26 | 31 | 3.57 | 1.39622641509434
Adams, [NAME] | 54 | 2 | 3 | 0 | 65.333333 | 49 | 19 | 74 | 2.48 | 1.0408163318409
Adenhart, Nick | 3 | 1 | 0 | 0 | 12 | 18 | 13 | 4 | 9 | 2.58333333333333
Adkins, [NAME] | 4 | 1 | 0 | 0 | 3.666667 | 4 | 3 | 3 | 2.45 | 1.90909073553721
Affeldt, Jeremy | 74 | 1 | 1 | 0 | 78.333333 | 78 | 25 | 80 | 3.33 | 1.31489362261657
[NAME], [NAME] | 7 | 0 | 1 | 0 | 13.666667 | 15 | 6 | 13 | 3.95 | 1.53658532837597
[NAME], [NAME] | 28 | 3 | 3 | 0 | 49 | 43 | 22 | 26 | 3.49 | 1.3265306122449
Aquino, Greg | 9 | 0 | 0 | 0 | 9.333333 | 17 | 9 | 9 | 12.54 | 2.78571438520409
[NAME], [NAME] | 15 | 1 | 1 | 0 | 21.666667 | 23 | 10 | 13 | 4.15 | 1.52307689964497
Armas Jr., [NAME] | 3 | 1 | 0 | 0 | 8.333333 | 11 | 1 | 6 | 7.56 | 1.4400000576
[NAME], [NAME] | 52 | 10 | 2 | 0 | 61 | 42 | 22 | 55 | 1.62 | 1.04918032786885
Arroyo, [NAME] | 34 | 15 | 11 | 0 | 200 | 219 | 68 | 163 | 4.77 | 1.435
Spreadsheet: 757199d1638112892-income-tax-calculation-formula-turkey-income-tax-rates-2021-tms-v2
Sheet: Combo

Income Tax Calculator (2021)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income | 24000
24000 | 15 | 0 | 0 |  |  |  |  |  | TMS correction
53000 | 20 | 3600 | 24000 |  |  |  |  |  | Income Tax
190000 | 27 | 9400 | 53000 |  |  |  |  |  | =INDEX($G$3:$G$7,IFERROR(MATCH($K$2-0.1,$A$3:$A$7,1)+1,1))
650000 | 35 | 30190 | 130000 |  |  |  |  |  | adjusted version of formula
more than 650000 | 40 | 212190 | 65000
Income Tax Calculator (2021)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income
0 | 0.15 | 0 | 0 |  |  |  |  |  | [NAME] correction
24001 | 0.2 | 3600 | 24000 |  |  |  |  |  | Income Tax
53001 | 0.27 | 9400 | 53000 |  |  |  |  |  | =@INDEX($G$11:$G$15,IFERROR(MATCH($K$10,$A$12:$A$15,1)+1,1))
190001 | 0.35 | 30190 | 190000
650001 | 0.4 | 212190 | 650000
Tax Calculation Breakdown by Bracket
Taxable Income Over... | ...And Up To… | Tax Rate | Tax |  |  |  |  |  | Taxable Income
0 |  | 0.15
24000 |  | 0.2 |  |  |  |  |  |  | Tax Total
53000 |  | 0.27
190000 |  | 0.35
650000 |  | 0.4
 |  |  |  | Total
Spreadsheet: 866260d1713220093-importing-data-from-another-worksheet-when-you-type-a-name-test-blank-grade-form
Sheet: Data (2)

 |  | ATTCL | ALPHA |  | 360 | 440 | 360 - 440 | 14.85 | 18.15 | 14.85 - 18.15 | 9.45 | 11.55 | 9.45 - 11.55 | 9.45 | 11.55 | 9.45 - 11.55 |  |  |  | Products to be used | Screen size to be used
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEST, LUCPE, SYBP, DREP, SYPR, MYCD, BUAO, FRUI | 0.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEST, LUCPE,LAMM, SYBP, DREP, SYPR, MYCD, BUAO, FRUI | 0.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LUCPE, SAME, SYBP, DREP, SYPR, MYCD, BUAO, FRUI, PEST | 0.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEST, LUCPE, SYPR, SYBP, GLUC, MYCD, DREP, BUAO, FRUI | 0.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEST, LUCPE, SYBP, DREP, SYPR, MYCD, BUAO, FRUI | 0.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, BEGM, MEBM, APPE, SUADP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, APPE, SUADP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, [NAME], APPE, SUMP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, APPE, SUPP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, LAMM, WHLI, DRCA, WWADP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, PRME, LAMM, WHLI, DRCA, [NAME] | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, TUME, WHLI, DRCA, [NAME] | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, SMNA, WHLI, DRCA, WWLP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, TUME, WHLI, DRCA, WWLP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, SMNA, WHLI, DRCA, WWADP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, PRME, LAMM, WHLI, DRCA, WWADP | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBP, LAMM, WHLI, DRCA, WWADP | 1.25
 |  | =INPUT('Data'!C255
Spreadsheet: rick_buy__32729__Daily Treas By BU Q3
Sheet: Sept

 | Net Cash Source / (Use)
 | Current Day and Month to Date
 | Sept 2001
 |  |  |  |  | Total
 |  |  |  |  | Month to Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00
 | Enron Transportation Services
 | Portland General Electric
 | Total Distribution
 | Enron North America
 | Enron South America
 | Total Americas
 | Europe
 | Global Markets
 | Industrial Markets
 | Networks
 | Other
 | Total Traditional Wholesale
 | Global Assets
 | EGEP
 | Other Wholesale (EE&CC)
 | Total Wholesale
 | Enron Energy Services
 | Enron Broadband Services
 | Corp
 | Other
 | Total Enron
 | ONLY includes cash movement monitored from Houston.
 | Does NOT include Canada, London or any other banking center.
 | Certain items such as payroll that is paid by Corp on behalf of a business unit has NOT been allocated to the business units
Spreadsheet: 9047d336-fc44-4356-889c-06f9bbe895b9
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2005/06 | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12
 |  |  |  |  |  |  | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 3.384 | 2.838 | 2.761 | 2.995 | 3.135 | 3.636 | 2.689
Harvested | 3.364 | 2.821 | 2.748 | 2.976 | 3.103 | 3.615 | 2.618
 |  |  |  | Pounds per harvested acre
Yield | 6624 | 6898 | 7219 | 6846 | 7085 | 6725 | 7067
 |  |  |  | Million cwt
Beginning stocks | 37.71 | 42.992 | 39.315 | 29.492 | 30.419 | 36.499 | 48.467
Production | 222.833 | 194.585 | 198.388 | 203.733 | 219.85 | 243.104 | 185.009
Imports | 17.134 | 20.581 | 23.9 | 19.218 | 19.019 | 18.336 | 19
Total supply | 277.677 | 258.158 | 261.603 | 252.443 | 269.288 | 297.939 | 252.476
Food, industrial,
& residual 3/ | 116.329 | 124.671 | 123.152 | 123.77 | 120.012 | 134.502
Seed | 3.503 | 3.408 | 3.697 | 3.87 | 4.488 | 3.324
Total domestic use | 119.832 | 128.079 | 126.849 | 127.64 | 124.5 | 137.826 | 124
Exports | 114.853 | 90.764 | 105.262 | 94.384 | 108.341 | 111.646 | 89
Rough | 33.449 | 32.112 | 37.663 | 31.633 | 40.351 | 34.896 | 32
Milled 4/ | 81.404 | 58.652 | 67.599 | 62.751 | 67.953 | 76.75 | 57
Total use | 234.685 | 218.843 | 232.111 | 222.024 | 232.841 | 249.472 | 215
Ending stocks | 42.992 | 39.315 | 29.492 | 30.419 | 36.499 | 48.46700000000004 | 39.5
 |  |  |  | Percent
Stocks-to-use ratio | 18.31902337175363 | 17.96493376530206 | 12.70598980660115 | 13.70077108781033 | 15.67550388462513 | 19.42783158029761 | 18
 |  |  |  | $/cwt
Average farm |  |  |  |  |  |  | 13.9
price 5/ | 7.65 | 9.96 | 12.8 | 16.8 | 14.4 | 12.7 | 14.5
 |  |  |  | Percent
Average
milling rate | 70.25 | 71 | 69.88 | 70.83 | 71.53 | 68.86 | 70
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated February 9, 2012.
Spreadsheet: 320246d1400816241-same-name-in-cells-is-formatted-differently-how-can-i-replace-with-a-consistent-format-5-22-14-deep-macro-with-ryan-chad-update
Sheet: Standings

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
FRANCHISE | VP | W-L-T | W-L-T | PCT | PF | PA | BBID $ BAL
MR. [NAME] | 46 | 2000-12-01 00:00:00 | 12-1 | 0.923 | 2365.8 | 1682.8 | 300
DONKS - KEVIN | 36 | 2000-08-05 00:00:00 | 8-5 | 0.615 | 2381 | 1756.2 | 1000
TEAM GT - RANDY WICKENHAUSER | 31 | 2000-07-06 00:00:00 | 7-6 | 0.538 | 2232.1 | 1753.5 | 626
HARBOR RATS - ROB | 31 | 2000-06-07 00:00:00 | 6-7 | 0.462 | 2192.2 | 1797.5 | 0
THE MFCEO - [NAME] | 25 | 2000-07-06 00:00:00 | 7-6 | 0.538 | 1968.7 | 1676.9 | 1
[NAME] STRAIN | 12 | 2000-03-10 00:00:00 | 3-10 | 0.231 | 1673.2 | 1837.8 | 0
ATOWN - MCCOY | 11 | 2000-03-10 00:00:00 | 3-10 | 0.231 | 1802.5 | 1806.6 | 350
Division 2
FRANCHISE | VP | W-L-T |  | PCT | PF | PA | BBID $ BAL
HIPPIES HITTERS - MAX | 50 | 2000-11-02 00:00:00 | 11-2 | 0.846 | 2931.6 | 1786.9 | 0
NINJA TURTLES - JOY WILGUS | 41 | 2000-09-04 00:00:00 | 9-4 | 0.692 | 2419.8 | 1751.2 | 807
RATHBONE PIRATES - TOMMY GRAVES | 39 | 2000-09-04 00:00:00 | 9-4 | 0.692 | 2450.6 | 1680.2 | 550
BARKING SPIDERS - PAUL MAILE | 33 | 2000-06-07 00:00:00 | 6-7 | 0.462 | 2408 | 1881 | 87
NEW YORK DORKS - RICHARD VALLEJO | 25 | 2000-04-09 00:00:00 | 4-9 | 0.308 | 2200.3 | 1826.2 | 299
BRAWLIN' BEARDS - PAUL ROBERTS | 22 | 2000-05-08 00:00:00 | 5-8 | 0.385 | 1963.8 | 1755.2 | 1000
SHINE ON YOU CRAZY DIAMOND - FRANK HORTON | 4 | 2000-01-12 00:00:00 | 1-12 | 0.077 | 1460.9 | 1832.3 | 742
Spreadsheet: 465351d1465578611-autosort-lists-sdld-review-tool
Sheet: Lists

Municipalities |  | SD/LD Types
[NAME] |  | Single Lot Subd
Bastress |  | Add-Lot/Lot-Consolidation Subd
[NAME] |  | Multi-Lot Subd
Cogan House |  | Commercial LD
Cummings |  | Agricultural LD
Gamble |  | Industrial LD
Hughesville |  | Institutional LD
[NAME] |  | Residential LD
Jordan |  | Natural Gas LD
Limestone |  | Recreational LD
McHenry
[NAME]
[NAME]
Mifflin
[NAME]
Moreland
[NAME]
[NAME]
[NAME]
Picture Rocks
Pine
Porter
Salladasburg
Shrewsbury
Watson
[NAME]
[NAME]
Cascade
[NAME]
Duboistown
Eldred
Fairfield
Franklin
[NAME]
Jersey Shore
Lewis
Loyalsock
Lycoming
Montgomery
Montoursville
[NAME]
[NAME]
Nippenose
Old Lycoming
Plunketts Creek
South Williamsport
Susquehanna
Upper Fairfield
Washington
Williamsport
[NAME]
Woodward
Spreadsheet: 782828d1654298498-put-call-log-in-date-order-based-on-a-details-call-log-sheet-telephone-tracker-biggsy2020-
Sheet: Call Log

 |  |  |  |  |  | For Office Use Only
Telephone Conversation Tracker for Incoming Calls
Date | Time | Name | Phone Number | Notes | Action Required | Follow-up Needed? Y/N
Spreadsheet: 720745d1614274619-formula-to-alter-calculation-dependant-on-drop-down-list-value-peters-version-of-tim-recording-sheet-modbyjt
Sheet: Calculations

 |  |  |  |  |  |  |  |  |  | WEEK 1 | <=== Selected Week
 |  |  |  |  |  |  |  |  |  | WORK AREA
 | Monday | Minute |  |  |  |  |  |  |  | WorkArea | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  | Strip out Spaces | [NAME] to Uppercase | Count the No: of Code you're interested in | Strip out the numbers | Count the number of total codes
 | 6 |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  | 19
 | Tuesday | Minute |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Total
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7 |  |  |  |  |  |  |  |  |  | Day you're Interested in |  |  | Monday
 | 8
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | Description
 | 10 |  |  |  |  |  |  |  |  |  | Code you're interested in: |  |  | C25
 | 11 |  |  |  |  |  |  |  |  |  | Time you're interested in: |  |  | 11:00 - 11:59
 | 12
 | 13 |  |  |  |  |  |  |  |  |  | Number of Instances for the Hour |  |  |  |  | Daily Total of all Codes
 | 14 |  |  |  |  |  |  |  |  |  | Number of Instances for the Day
 | 15 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :00
 | 16 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :10
 | 17 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :20
 | 18 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :30
 | 19 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :40
 | Wednesday | Minute |  |  |  |  |  |  |  |  | Number of Instances during: |  | :50
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Thursday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Friday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
Spreadsheet: 112345d1308505745-simplify-if-function-small-excel-question19-06
Sheet: ALL GOOD

Helper Column | Form | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 1 | 1
 | 1 | 1 | 1
7 | 1 | 1 | 1 | 0
8 | 0 | 1 | 1 | 0 | 1
 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | 1 | 1 | 1 | 1 | 1 | 1 | 1
11 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1
12 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
 |  |  |  | I want to  simplify the formula in column E, for small samples it is easy but I need to use it for a really large sample.
 |  |  |  | The formula is a if function
 |  |  |  | The formula: look first if the formula above the cell is a zero if this is not the case, look if the cell above that cell is a zero, if that is not the case look if the cell above that cell is a zero and so on. If it is a one you have the answer is the cell right of it.