tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60524d1261055205-gathering-the-sum-of-negative-numbers-and-positive-numbers-in-a-column-variances-over-short-compare-test-1-
Sheet: Sheet1

Date | [NAME] |  | Total Overages | Total Shortages
2009-03-14 00:00:00 | 0.05
2009-03-28 00:00:00 | 50
2009-04-18 00:00:00 | 5
2009-05-15 00:00:00 | 1
2009-05-22 00:00:00 | -3
2009-05-24 00:00:00 | -0.25
2009-05-27 00:00:00 | 3
2009-06-06 00:00:00 | 0.3
2009-06-18 00:00:00 | 0.2
2009-06-22 00:00:00 | -0.05
2009-07-02 00:00:00 | 0.11
2009-07-16 00:00:00 | 0.1
2009-07-23 00:00:00 | 1
2009-08-02 00:00:00 | -0.1
2009-08-07 00:00:00 | 5.95
2009-08-23 00:00:00 | 0.05
2009-09-06 00:00:00 | -0.04
2009-09-18 00:00:00 | 0.01
2009-09-19 00:00:00 | -0.05
2009-10-03 00:00:00 | 49.6
2009-10-29 00:00:00 | 0.01
2009-11-21 00:00:00 | 0.01
Spreadsheet: 694040d1599313689-merge-cells-merge-cell-05_09
Sheet: Foglio1

 |  |  | new modified
 | 123456 |  | 12345612345678       ASD ASD ASD
 | AAAA-12345678     ASD ASD ASD
 | 123456 |  | 123456
 | 12345711 |  | 1234571112345678      ASDAS [NAME]
 | AAAA-12345678     ASDAS OEOE KKDK
 | 99978844 |  | 999788441237888      KAKA [NAME]
 | AAAA-1237888     KAKA [NAME]
 | 12347888 |  | 12347888
 | 9997888 |  | [PHONE]      KAKA DQQ ERR
 | AAAA-99888     KAKA DQQ ERR
Spreadsheet: 814814d1674613309-change-string-expression-into-datetime-serial-number-s666-pq-change-string-expression-into-datetime-serial-number
Sheet: Result

ID | Day Name | DT | DTSNumber | DSNumber | [NAME]
315 | Monday | November 14/11/2022 12:00:00 | 44879.5 | 44879 | 0.5
999 | Wednesday | October 05/10/2022 00:28:00 | 44839.01944444444 | 44839 | 0.01944444444444444
844 | Friday | October 14/10/2022 07:44:00 | 44848.32222222222 | 44848 | 0.3222222222222222
819 | Friday | October 14/10/2022 15:03:00 | 44848.62708333333 | 44848 | 0.6270833333333333
545 | Monday | October 31/10/2022 17:08:00 | 44865.71388888889 | 44865 | 0.7138888888888889
Spreadsheet: 859722d1708000196-two-upper-and-two-lower-numbers-average-cartel1
Sheet: Foglio1

 |  |  | 45
 |  |  | 60 |  |  |  |  | 6
 |  |  | 15 |  |  |  |  | 12
 |  |  | 92 |  |  |  |  | 15
 |  |  | 121 |  |  |  |  | 18
 |  |  | 12 |  |  |  |  | 19
 |  |  | 28 |  |  |  |  | 22
 |  |  | 87 |  |  |  |  | 28
 |  |  | 6 |  |  |  |  | 34
 |  |  | 56 |  |  |  |  | 41
 |  |  | 78 |  |  |  |  | 45
 |  |  | 19 |  |  |  |  | 56
 |  |  | 2 |  |  |  |  | 60
 |  |  | 41 |  |  |  |  | 66
 |  |  | 66 |  |  |  |  | 78
 |  |  | 94 |  |  |  |  | 87
 |  |  | 34 |  |  |  |  | 92
 |  |  | 22 |  |  |  |  | 94
 |  |  | 18 |  |  |  |  | 121
 |  |  |  |  | Average = 47.15
Spreadsheet: 275110d1383328974-correcting-pre-existing-numbers-when-excel-changes-the-last-digit-to-0-example
Sheet: Sheet1

Number | Last number was orginaly entered as:
5222200000132150 | 8
5222200000173770 | 2
5222200000065310 | 7
5222200000040420 | 7
5222200000050060 | 1
5222200000125990 | 6
5222200000169460 | 5
5222200000222210 | 5
5222200000070180 | 4
5222200000134070 | 1
5222200000018660 | 2
Spreadsheet: 807807d1670066831-calling-data-from-main-sheet-g6-ver-256
Sheet: MALE 5 BEST AND WEAK STUDENT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 3 | 4 | 5 | 1
G. FIVE BEST MALE STUDENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
H. FIVE WEAK MALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 854197d1704167476-closest-date-with-criteria-with-maxifs-formula-closestdate
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  |  | Date | Symbol | [NAME]
2023-12-04 00:00:00 | MULN |  |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2023-12-31 00:00:00 | MULN |  |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10
Spreadsheet: 874449d1721047058-return-value-from-a-cell-in-a-range-based-on-data-validation-book1
Sheet: Quote Template

 |  | Please answer the following questions to get to your Estimated Quotation |  |  |  |  |  |  |  |  |  |  |  | Estimated Quotation
 |  | Select Your Currency |  |  |  |  |  |  |  | USD |  |  |  | Items |  |  |  |  |  |  | Costs
 |  |  |  |  |  |  |  |  |  |  |  |  |  | On-Site
 |  | On-Site Local or All Inclusive |  |  |  |  |  |  |  | No Onsite Required |  |  |  | Site Survey
 |  | Local = Any cities where we have a local presence |  |  |  |  |  |  |  |  |  |  |  | Camera Cost
 |  | Site Survey required
 |  | City Location |  |  |  |  |  |  |  | Choose your City
 |  | How many Cameras
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ESTIMATED QUOTE TOTAL
Spreadsheet: 768445d1644964618-countifs-with-blank-cells-countifswithblank
Sheet: Sheet1

Year | Teacher | Subject | Result |  |  |  | Teacher | Subject | 2019 | 2020
2019 | Smith | Math | 2 |  |  |  | Smith | Math |  | 0
2019 | Smith | Math |  |  |  |  | Jones | Math | 1 | 0.5
2019 | Smith | Math |  |  |  |  | Reily | English | 0.5 | 0
2019 | Smith | Math | -1 |  |  |  | Lobo | English | 0.75 | 1
2019 | Smith | Math | -0.5
2019 | Smith | Math
2019 | Jones | Math
2019 | Jones | Math | 5
2019 | Jones | Math
2019 | Jones | Math
2020 | Smith | Math
2020 | Smith | Math | -2
2020 | Smith | Math
2020 | Smith | Math
2020 | Smith | Math
2020 | Smith | Math
2020 | Jones | Math
2020 | Jones | Math | 1
2020 | Jones | Math | -0.4
2020 | Jones | Math
2019 | Reily | English | 2
2019 | Reily | English
2019 | Reily | English
2019 | Reily | English | -1
2019 | Lobo | English
2019 | Lobo | English | 2
2019 | Lobo | English | 3
2019 | Lobo | English | 5
2019 | Lobo | English
2019 | Lobo | English | -2
2020 | Reily | English
2020 | Reily | English | -2
2020 | Reily | English
2020 | Reily | English
2020 | Lobo | English
2020 | Lobo | English
2020 | Lobo | English
2020 | Lobo | English | 1
2020 | Lobo | English | 1
2020 | Lobo | English
Spreadsheet: a66a5468-a491-4eb1-a69a-ec3f870d0bcb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-02-10 09:13:29.500000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.25 | 102.1 | 101.975 | 101.85 | 101.475 |  | and are added to price quote
4.125 | 101.7 | 101.575 | 101.45 | 101.075
4 | 101.254 | 101.129 | 101.004 | 100.629 |  | Note: | Refer To Price [NAME]
3.875 | 100.431 | 100.306 | 100.181 | 99.806 |  |  | For all Price Adjs
3.75 | 99.454 | 99.329 | 99.204 | 98.579
3.625 | 99 | 98.875 | 98.75 | 98.125
3.5 | 98.495 | 98.37 | 98.245 | 97.62
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 101.87 | 101.745 | 101.62 | 101.245
3.5 | 101.53 | 101.405 | 101.28 | 100.905
3.375 | 100.999 | 100.874 | 100.749 | 100.374
3.25 | 100.368 | 100.243 | 100.118 | 99.743
3.125 | 99.603 | 99.478 | 99.353 | 98.728
3 | 99.259 | 99.134 | 99.009 | 98.384
2.875 | 98.7 | 98.575 | 98.45 | 97.825 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-24 09:13:29.500000
30 DAY | 2012-03-10 09:13:29.500000
45 DAY | 2012-03-25 09:13:29.500000
60 DAY | 2012-04-09 09:13:29.500000
90 DAY | 2012-05-09 09:13:29.500000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 5

TABLE 5
USE A SEPARATE SHEET FOR METRO & COUNTY
MILITARY BASE & INSTALLATIONS
Base/Installation | Branch | Description | Location | County | Total | Total | Average No. of |  | Status:
 | of | of | City |  | Civilian | Military | Retiring/Separating |  | on
 | Service | Operations |  |  | Personnel | Personal | Military Personnel |  | Official
 |  |  |  |  |  |  | Per Year1 |  | Closing
 |  |  |  |  |  |  | Occupation | Number | List
 |  |  |  |  |  |  | Category |  | ( Yes or No )
1 You may want to include other government facilities, announced closures and DOE facilities.  Include the employment size of the facility.
Spreadsheet: d7867f4c-9488-473f-8c6b-c2fedc953139
Sheet: Denials 2007

MULTNOMAH COUNTY LOAN DENIAL RATES BY INCOME-RACE GROUPINGS : 2007
Home Purchase & Occupation
I.  Total Applications
Race/Ethnicity | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 1 | 1 | 5 | 7 | 14
Asian | 0 | 1 | 4 | 5 | 12 | 22
Blacks | 0 | 2 | 6 | 5 | 18 | 31
White | 3 | 9 | 106 | 87 | 228 | 437
Hispanic | 0 | 4 | 15 | 12 | 17 | 49
Overall Total | 3 | 11 | 124 | 106 | 277 | 551
II.  Total Denials
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0 | 1 | 0 | 0 | 1 | 2
Asian | 0 | 0 | 0 | 0 | 1 | 1
Blacks | 0 | 2 | 1 | 2 | 9 | 14
White | 0 | 4 | 22 | 15 | 22 | 63
Hispanic | 0 | 3 | 3 | 1 | 5 | 12
Overall Total | 0 | 5 | 25 | 18 | 35 | 83
III. Denial Rates (II/I) * 100
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 0
Asian | 0
Blacks | 0
White
Hispanic | 0
Overall Total
Source: HMDA (LAR) 2007
Note: Data reported here is for Multnomah County. These are loans for the purpose of purchasing a home. The loans are for homes that are meant for a primary occupancy of the owner. These are all represented for conventional loans. For ethnic and racial breakout, these are loans originated by households where either the applicant or co-applicant are representative of that group.
Spreadsheet: 97961b8f-2ad1-48b7-a001-778c1165f790
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4704 | 12147 | Giuseppina | Capra | ITA | 0 | 00:54:20 | 00:02:13 | 01:44:05 | 00:03:28 | 01:25:11 | 1 | 04:09:17
Spreadsheet: 120425d1315285571-adjustment-of-uneven-cell-widths-in-excel-test-calcul-doubt
Sheet: Sheet1

1
(a) | Name:
(b) | Appointment held:
(c) | Office from which retired
(d) | Date of Birth
(e) | Date of Appointment
(f) | Date of Retirement
(g) | Class of Pension
(h) | Pension Rules by which governed
2
[NAME] |  |  |  |  | From | To | Years | Months | Days
(a) | Regular/Permanent service |  |  |  | 1981-01-01 00:00:00 | 1981-01-01 00:00:00 | 10 | 10 | 10
(b) | Other Service |  |  |  | 1981-01-01 00:00:00 | 1981-01-01 00:00:00 | 10 | 10 | 10
Total Qualifying Service |  |  |  |  | 1981-01-01 00:00:00 | 1981-01-01 00:00:00 | 10 | 10 | 10
3
Less Non-Qualifying Service |  |  |  |  | From | To | Years | Months | Days
EOL without MC |  |  |  |  | 1981-01-01 00:00:00 | 1981-01-01 00:00:00 | 10 | 10 | 10
Total Non-Qualifying Service |  |  |  |  | 1981-01-01 00:00:00 | 1981-01-01 00:00:00 | 10 | 10 | 10
4
Net Qualifying Service with weightage if any |  |  |  |  | 10 | yrs | 10 | mths | 10 | days
5 | Emoluments
(a)
Rates of pay and allowance drawn during last 10 months of qualifying service viz from |  |  |  |  |  |  |  |  |  |  |  | 1980-01-01 00:00:00 | to
32874
Spreadsheet: 765174d1643203204-working-time-with-varied-day-lengths-excluding-weekends-and-holidays-elapsed-day-and-time-v2-
Sheet: Sheet1

Start Date | Start Time | End Date | End Time | Elapsed time (days) | hours | minutes |  | Mon-Fri | SAT |  | Mon-Thu | Fri
2021-01-04 00:00:00 | 06:00:00 | 2021-01-31 00:00:00 | 06:00:00 |  |  |  |  | 06:00:00 | 06:00:00 |  | 06:00:00 | 06:00:00
2021-01-04 00:00:00 | 07:00:00 | 2021-01-31 00:00:00 | 07:00:00 |  |  |  |  | 22:00:00 | 16:00:00 |  | 22:00:00 | 16:00:00
2021-01-04 00:00:00 | 08:00:00 | 2021-01-31 00:00:00 | 15:00:00
Holidays |  | It is assumed that Start day and end days are working days and Timings are within working hours always.
Christmas day | 2021-12-25 00:00:00
Boxing day | 2021-12-26 00:00:00
New years day | 2022-01-01 00:00:00
 |  | DATE | HOURS | MINUTES
 | MONDAY | 4 | 16
 | TUESDAY | 5 | 16
 | WEDNESDAY | 6 | 16
 | THURSDAY | 7 | 16
 | FRIDAY | 8 | 10
 | SATURDAY | 9
 | SUNDAY | 10
 | MONDAY | 11 | 16
 | TUESDAY | 12 | 16
 | WEDNESDAY | 13 | 16
 | THURSDAY | 14 | 16
 | FRIDAY | 15 | 10
 | SATURDAY | 16
 | SUNDAY | 17
 | MONDAY | 18 | 16
 | TUESDAY | 19 | 16
 | WEDNESDAY | 20 | 16
 | THURSDAY | 21 | 16
 | FRIDAY | 22 | 10
 | SATURDAY | 23
 | SUNDAY | 24
 | MONDAY | 25 | 16
 | TUESDAY | 26 | 16
 | WEDNESDAY | 27 | 16
 | THURSDAY | 28 | 16
 | FRIDAY | 29 | 10
 | SATURDAY | 30
 | SUNDAY | 31
Spreadsheet: 866750d1713647434-if-cell-contains-specific-text-from-one-of-multiple-lists-return-list-header-sample-lists-solution-
Sheet: Sheet6

Product name | Result | Result formula |  | Duo-caps |  | Trio-caps |  | Power-mix caps |  | Discs
Bright Yellow 3+1PowerCaps | Trio-caps |  |  | Duo |  | 3+1 |  | Power Mix |  | Disc
Bright [NAME] | Trio-caps | Trio-caps |  | 2in1 |  | 3In1 |  | Power-Mix
RED CAPS 3IN1 ALPINE CONC 1 X | Trio-caps | Trio-caps |  |  |  | 3+1
Green DUO CAPS Bright CONC | Duo-caps | Duo-caps
[NAME] | Discs | Discs
Yellow Power Mix Extreme Power Capsul | Power-mix caps | Power-mix caps
Le Blue DuoBullesLexpert | Duo-caps | Duo-caps
Le Blue Sensitive Capsul Conctrd Uni
[NAME] | Duo-caps | Duo-caps
Green Power-Mix Caps Universal Capsul | Power-mix caps | Power-mix caps
Spreadsheet: 800410d1665658652-substitute-values-within-cells-substitute_values_cells
Sheet: substitue_values_cells

 | SUBSTITUTE VALUES WITHIN CELLS
 | VIA 3-ARRAYS TABLE
 | table1 | =B9:C16
 | table2 | =B19:D23
 | type | value |  |  | expected_result |  |  | formula
 | color | yellow |  |  | yellow |  |  | …
 | color | pale yellow |  |  | light,yellow |  |  | …
 | crystal | alpha-gamma |  |  | alpha-gamma,alpha,gamma |  |  | …
 | color | light yellow |  |  | light,yellow |  |  | …
 | color | grey |  |  | gray |  |  | …
 | crystal | beta theta |  |  | beta,theta |  |  | …
 | color | translucent white |  |  | translucent,transparent,white |  |  | …
 | color | off white yellow |  |  | white,yellow |  |  | …
 | type | value | substitute
 | color | pale | light
 | color | translucent | translucent,transparent
 | crystal | alpha-gamma | alpha-gamma,alpha,gamma
 | color | off
 | color | grey | gray
Spreadsheet: 0740d492-f1a9-4d2c-a121-af0400eea3ab
Sheet: Sheet1

I Observe - I Know - I Infer | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Name:  ________________________________ |  |  | Date:  ______________________________
Title:  _________________________________ |  |  | Author:  ____________________________
I Observe what it says |  | I Know |  | I Infer
It says that Papa did not say and word and that he stared at the dirt road.  The narrator's older brother was also quiet. |  | I know that people get quiet and avoid eye contact when they are upset or have a big decision to make. |  | Papa probably is upset about something and has a big decision to make.
It says the narrator saw that everything was in boxes when he opened the door and that he felt the weight of hours, days, weeks, and months of work. This brought tears to his eyes. |  | I know the idiom "I feel the weight of the world on me" means that I have much to do or a hard task in front of me that I dread. |  | The narrator must know that there is much work ahead of him when they move to Fresno and that is what is making him sad.
It says the pot was the only thing not packed and that it was filled with dents and nicks. |  | I know that things that are frequently used are packed last.  I also know that frequently used things are often dented. |  | The narrator's mom must use that pot frequently.
It said that there is a white gate and a row of rosebushes outside of the house.  The house has a doorbell and a porch with a light.  It said the garage is worn out, has no windows, a dirt floor and a roof with holes. |  | I know that a white gate and a row of bushes need constant upkeep. I know that most people want to be treated fairly. |  | The house where the owner lived must be well cared for and nice.  The narrator must feel that it is very unfair for the owner's family to live in a nice house when his family has to live in a dilapidated garage.
Spreadsheet: 03cb2698-6a19-4281-8ad5-09f5a200fc1b
Sheet: Sheet1

Table 9--U.S. cotton textile exports, by destination | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Mar. | Apr. | May | May
Region/country | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
North America | 123245.058 | 101248.096 | 122877.292 | 151374.169
Bahamas | 139.014 | 281.214 | 92.1 | 100.312
Canada | 10062.489 | 8996.319 | 10411.483 | 9242.945
Costa Rica | 296.291 | 199.209 | 232.533 | 269.816
Dominican Republic | 19724.505 | 17927.3 | 20721.056 | 33804.155
El Salvador | 11561.98 | 9246.243 | 10249.724 | 13005.175
Guatemala | 2835.287 | 2850 | 1929.061 | 3236.559
Haiti | 467.157 | 629.717 | 757.265 | 889.752
Honduras | 50842.394 | 37073.223 | 50709.221 | 61273.755
Jamaica | 119.616 | 91.947 | 80.089 | 52.479
Mexico | 24381.064 | 21961.391 | 25545.613 | 27395.252
Nicaragua | 2079.125 | 1364.042 | 1320.92 | 1586.261
Panama | 332.376 | 335.137 | 394.63 | 254.101
South America | 2298.667 | 2417.648 | 2717.123 | 2506.04
Brazil | 505.814 | 379.817 | 429.855 | 794.467
Chile | 170.938 | 451.813 | 186.506 | 179.443
Colombia | 505.679 | 532.394 | 961.146 | 505.728
Peru | 344.709 | 325.808 | 147.997 | 265.798
Venezuela | 398.755 | 526.986 | 681.714 | 562.93
Europe | 3591.554 | 2756.668 | 2912.668 | 3332.897
Belgium | 404.594 | 240.639 | 218.767 | 343.389
France | 135.191 | 122.224 | 128.391 | 138.633
Germany | 527.654 | 444.172 | 443.286 | 635.25
Italy | 236.61 | 116.963 | 134.25 | 176.476
Netherlands | 487.222 | 339.737 | 390.914 | 274.811
Russia | 116.38 | 54.471 | 98.863 | 177.646
Turkey | 23 | 38.075 | 66.078 | 78.094
United Kingdom | 1001.688 | 973.847 | 874.633 | 1010.526
Asia | 7547.642 | 7910.147 | 9398.757 | 7789.925
Bangladesh | 4 | 7 | 31.268 | 6
China | 3210.334 | 4075.864 | 5116.788 | 4161.616
Hong Kong | 908.01 | 573.708 | 712.584 | 453.297
India | 335.896 | 148.595 | 336.96 | 362.936
Israel | 239.226 | 261.95 | 180.614 | 243.122
Japan | 881.107 | 854.931 | 877.917 | 688.17
Pakistan | 77.759 | 28.32 | 31.233 | 93.015
Saudi Arabia | 124.083 | 124.62 | 128.955 | 118.677
Singapore | 140.174 | 233.022 | 319.614 | 160.677
South Korea | 546.514 | 626.873 | 526.779 | 479.399
Taiwan | 128.551 | 119.811 | 94.855 | 97.631
United Arab Emirates | 396.447 | 284.401 | 274.3 | 282.216
Oceania | 671.481 | 586.049 | 747.83 | 691.906
Australia | 516.052 | 467.765 | 571.671 | 563.953
Africa | 276.1 | 253.156 | 261.836 | 1333.848
South Africa | 67.576 | 59.382 | 58.409 | 68.292
World 2/ | 137630.502 | 115171.764 | 138915.158 | 167051.619
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update: 08/13/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: phillip_m_love__30648__9908_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  | -157499.97
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 41486d1239961204-cell-value-based-on-three-references-cells-test
Sheet: Process Sheet

 | 101 |  |  |  |  |  | 102
 | 201 | 202 | 203 | 204 | 205 |  | 201 | 202 | 203 | 204 | 205
Year
1990-2006
2006-2015
2015-2020
2020-2025
2025-2030
Spreadsheet: 779458d1651789759-sumproduct-with-named-ranges-indirect-and-multiple-criteria-sales-2022-phone-stats-to-get-formula
Sheet: YTD

2022 | Inbound Sales
 | Handled ACD Calls | [NAME] | Total Calls Rcd | IVR Handled Calls | [NAME] (w/Conf) | [NAME] | [NAME] (sec) | [NAME] (sec) | Max Wait Time (sec) | Avg Wrap Time (sec) | Avg Call Time (sec) | Outbound Calls
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
Year TTL
Spreadsheet: 87989d1287879948-help-with-running-7-day-count-goals
Sheet: Fuel

fuel | wednesday | thursday | friday | saturday | sunday | monday | tuesday | total | wkly variance
week 1 | 4788 | 6105 | 6658 | 5875 | 6608 | 8985 | 5445 | 44464 | -1806
week 2 | 6802 | 6608 | 6698 | 8502 | 6610 | 7524 | 4878 | 47622 | 1352
week 3 | 5895 | 5847 | 6608 | 6608 | 6610 | 5586 | 6689 | 43843 | -2427
week 4 | 6745 | 6955 | 6612 |  |  |  |  | 20312 | 482
week 5 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  | daily goal | 6610 | month total | 156241
 |  |  |  |  | weekly goal | 46270 | actual mth goal | 158640
 |  |  |  |  | monthly goal | 185080 | month variance | -2399
 |  |  |  |  |  |  | 7 day total
 |  |  |  |  |  |  | 7 day variance