tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678263d1589801972-replace-id-with-name-in-column-name-change
Sheet: ProjectPlan

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
 |  |  |  | Project Start: | 2020-01-01 00:00:00
 |  |  |  | Display: | Monthly
 |  |  |  | Display Period: | 1
 | TASK DESCRIPTION | [NAME] TO | [NAME] | STATUS | INITIATE START | INITIATE END | DEFINE & DESIGN START | DEFINE & DESIGN END | BUILD & DELIVER START | BUILD & DELIVER END | CLOSURE START | CLOSURE END | ACTUAL START | ACTUAL END | ACTUAL DAYS
 | Contract Management Platform
 | Contract Management Platform
Spreadsheet: 146039d1331868623-index-match-query-to-include-blank-entries-from-source-so-week-number-obvious-at-a-glance-roomrent2012
Sheet: FEB

DATES: | DAY: | BOARD  £: | PAID (Y or N) | REASON FOR UNPAID? | DATE of UNPAID to be PAID? | NOW PAID  (Y or N) | UNPAID totals
1st | WED | 20 | N | UNKNOWN |  |  | 1
2nd | THU |  |  |  |  |  | 1
3rd | FRI |  |  |  |  |  | 1
4th | SAT |  |  |  |  |  | 1
5th | SUN |  |  |  |  |  | 1
6th | MON | 20 | Y |  |  |  | 1
7th | TUE |  |  |  |  |  | 1
8th | WED |  |  |  |  |  | 1
9th | THU |  |  |  |  |  | 1
10th | FRI |  |  |  |  |  | 1
11th | SAT |  |  |  |  |  | 1
12th | SUN |  |  |  |  |  | 1
13th | MON |  |  |  |  |  | 1
14th | TUE |  |  |  |  |  | 1
15th | WED |  |  |  |  |  | 1
16th | THU |  |  |  |  |  | 1
17th | FRI |  |  |  |  |  | 1
18th | SAT |  |  |  |  |  | 1
19th | SUN |  |  |  |  |  | 1
20th | MON |  |  |  |  |  | 1
21st | TUE |  |  |  |  |  | 1
22nd | WED |  |  |  |  |  | 1
23rd | THU |  |  |  |  |  | 1
24th | FRI |  |  |  |  |  | 1
25th | SAT |  |  |  |  |  | 1
26th | SUN |  |  |  |  |  | 1
27th | MON | 20 |  | Wk finishs start of next month | 2012-03-04 00:00:00 |  | 1
28th | TUE |  |  |  |  |  | 1
29th | WED |  |  |  |  |  | 1
TOTAL of PAID |  | 20
TOTAL of UNPAID |  | 20
 |  |  |  | UNKNOWN
Spreadsheet: 818427d1676823203-or-function-in-table-format-doesnt-work-example-with-scenario3
Sheet: Sheet1

 | (Worked) Scenario1: Indicator =1
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
 | (Worked) Scenario2: Indicator =1 or Indicator [NAME]
 |  |  |  |  |  | Expected: |  |  |  | [NAME] (Worked and THANK YOU!)
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 | -1 |  | 11111 | 123456 | -1 |  |  | 123456 | -1
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
 | (Doesn't work) Scenario3:
 |  |  |  |  |  | Expected all rows when Indicator is all blank |  |  |  | [NAME] (Worked)
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 |  |  | 11111 | 123456 |  |  |  | 123456 | 0
 |  | 22222 | 2222214 |  |  | 22222 | 2222214 |  |  | 22222 | 2222214 | 0
 |  | 33333 | 12123123 |  |  | 33333 | 12123123 |  |  | 33333 | 12123123 | 0
 |  | 44444 | 16822598 |  |  | 44444 | 16822598 |  |  | 44444 | 16822598 | 0
 |  |  |  |  |  | Expected not to show when Indicator is 2 |  |  |  | [NAME] (Worked)
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 |  |  | 11111 | 123456 |  |  |  | 123456 | 0
 |  | 22222 | 2222214 | 2
 |  | 33333 | 12123123 |  |  | 33333 | 12123123 |  |  | 33333 | 12123123 | 0
 |  | 44444 | 16822598 |  |  | 44444 | 16822598 |  |  | 44444 | 16822598 | 0
 |  |  |  |  |  | Expected to show when Indicator is 1 or -1 |  |  |  | [NAME] (Doesn't work)
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 | 1 |  | 11111 | 123456 | 1 |  |  | 123456 | 1
 |  | 22222 | 2222214 |  |  | 22222 | 2222214 |  |  | 22222 | 2222214 | 0
 |  | 33333 | 12123123 | -1 |  | 33333 | 12123123 | -1 |  | 33333 | 12123123 | -1
 |  | 44444 | 16822598 |  |  | 44444 | 16822598 |  |  | 44444 | 16822598 | 0
Spreadsheet: 757219d1638125796-calculations-vlookup-social-fuel-excel-test-for-sem-
Sheet: Ad Upload

 | Ad Template
 | Example before uploading to engine
 | Ad type | Headline 1 | Headline 2 | Headline 3 | [NAME] | [NAME] | Path 1 | Path 2 | Final URL
 | Expanded Text | Your Favorite Business In NY | Official Site |  | Find The Best Products & Make Life Easier. Shop Today |  | Business | NY | https://www.example.com/localagent
 | Expanded Text | Your Favorite Business in Minnesota | Official Site |  | Find The Best Products & Make Life Easier. Shop Today |  | Business | MN | https://www.example.com/localagent
 | Expanded Text | Your Favorite Business In NY | Official Site |  | Selling Everything From Coffee To Cupcakes, You'll Find It Here. [NAME] With Us Today! |  | Business | NY | https://www.example.com/localagent
 | Expanded Text | Your Favorite Business in MN | Official Site |  | Selling Everything From Boats To Lures, You'll Find It Here. [NAME] With Us Today! |  | Business | MN | https://www.example.com/localagent
Spreadsheet: 752736d1634916125-count-range-if-specific-cell-contains-specific-text-example-spreadsheet
Sheet: Sheet1

Date | long string of text [Company1] | long string of text [Company2] | long string of text [Company1]
1st May | Completed | Completed | Completed
2nd May | Completed with a problem | Not completed | Completed with a problem
3rd May | Completed | Not completed | Not completed
4th May | Compleetd | Compleetd | Not completed
5th May | Not completed | Not completed | Completed
6th May | Not completed | Not completed | Completed with a problem
7th May | Not completed | Not completed | Not completed
8th May | Not completed | Not completed | Not completed
9th May | Completed with a problem | Completed with a problem | Not completed
10th May | Completed with a problem | Completed with a problem | Completed with a problem
 | 6 | 4 | 5
 | The total is six because cell B1 contains the text "[company 1]" and then the word [completed] appears five times in the range B2 - B11 | The total is four because cell B1 contains the text "[company 2]" and then the word [completed] appears four times in the range B2 - B11 | The total is five because cell B1 contains the text "[company 1]" and then the word [completed] appears five times in the range B2 - B11
Spreadsheet: 694913d1599891226-count-number-of-x-if-it-appears-in-y-importances-on-rlms-etaf
Sheet: Sheet1

List Appearance | Importance | Count
HMNS30280: Children's &amp;Young Peoples MH Full Year | Core Text |  |  |  |  |  |  |  | So Ideally I want to know for example how many Core items are on LAW_22355: Client Finance Half Year 2 for example. It might be 0 to many.
MCLT20312: The City and Popular Culture Half Year 1 | Independent Research
LAW_22355: Client Finance Half Year 2 | Core Text
LAW_22348: Public International Law Full Year | Recommended Reading
BIOL33171: Immunology and Virology Full Year | Core Text
LAW_40460: Public Int & Humanitarian Law Flex Prog 1 | Core Text
ARES40150: Equine Health Half Year 1 | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
ULPI10402/10904: ULP Italian stage 4 Full Year | Recommended Reading
CARG30160: Law,Sentencing& the Courts Full Year | Recommended Reading
ULPI10502/602/10905/6: ULP Italian stage 5/6 FullYear | Core Text
MAND10112: Mandarin Grammar Full Year | Core Text
MAND10112: Mandarin Grammar Full Year | Core Text
LAW_40370: Sport Law & Reg: UK & Int Pers Flex Prog 1 | Recommended Reading
HIST20417: The Eagle &amp; the Snake Half Year 2 | Core Text
CHEM10181\10203: [NAME] to Physical Chemistry | Recommended Reading
THTR10057: Introduction to Theatre Design Full Year | Core Text
RSCH ARES Postgraduate Research Full Year | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
CARG30160: Law,Sentencing& the Courts Full Year | Core Text
CIVE20001: Construction Pract &amp; the Env | Core Text
FREN32005: Contemporary France Full Year | Core Text
LAW_40486: Sport, IP Law and Commerce Full Year | Core Text
MAND10112: Mandarin Grammar Full Year | Core Text
PRPG30221: L&amp;T:Curriculum&amp;PedagogyL6 Full Year | Core Text
CORP11173: Contemp Organisat'l Design Flex Prog | Core Text
PSYC30835: Psychology of the Paranormal Full Year | Core Text
INTR40145 Gender and Security | Core Text
HIST20517: Age of Reformations Half Year 1 | Core Text
BUSI11020: Fundamentals of Marketing Full Year | Core Text
LAW_40573: Int'l Comm Transactions (Jan) Flex Prog 1 | Core Text
GEOG20041: Principles/Prac in Geography Half Year 1 | Core Text
LAW_40394: World Trade Organisation Flex Prog 1 | Core Text
LAW_36596: International Trade Law (HY2) Half Year 2 | Core Text |  |  | <<--- Add more data to your table to the left if/when you want to
Spreadsheet: 839123d1691678557-create-schedule-from-calendar-data-excel-calendar-help
Sheet: Sheet4

Class Schedule
Professor | Description | Class Start Time | Duration
Smith | Math | 2023-07-30 08:30:00 | 120
Jones | Science | 2023-07-31 07:30:00 | 90
Prince | History | 2023-07-30 11:30:00 | 90
Smith | Math | 2023-08-01 08:30:00 | 90
Jones | Science | 2023-08-01 14:30:00 | 120
Spreadsheet: 30956c99-4cbb-4fff-b0ee-14749fb378fc
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
C8FX | Test | C8FX | C8 Complement, Functional, Serum | C8 Complement, Functional, S | Turbidimetry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Immediately after drawing the specimen, place the tube on wet ice. 2. Spin down and separate serum from clot. 3. Immediately freeze specimen. Additional Information: Fasting preferred. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | 33-58 U/mL | Monday through Saturday; [NAME] with a 3 p.m. cutoff | Same day/1 day | 3 days | 1 | 86161 |  |  |  |  | Rochester
C8FX | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
C8FX | Result | C8FX | C8 Complement, Functional, S | C8 Complement, Functional, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 50997-6 | Complement C8.functional:ACnc:Pt:Ser/Plas:Qn:
Spreadsheet: 883872d1732627750-xlookup-to-find-more-than-one-value-xlookup
Sheet: Sheet1

 |  |  |  |  |  |  | Lookup D column 81
 |  |  | code
 |  |  | 55 | dog |  |  | result
 |  |  | 61 | cat |  |  | 81 | [NAME]
 |  |  | 81 | [NAME] |  |  |  | cat
 |  |  | 55 | dog |  |  |  | duck
 |  |  | 81 | cat
 |  |  | 81 | duck
 |  |  | 22
Spreadsheet: 107d791c-9e62-443c-9a98-980264b7f160
Sheet: Common Expenses

Account Number | Description
7500 | Supplies
8005 | Awards
8010 | Telephone
8015 | Promotions
8023 | Player/Staff Gear
8024 | Equipment Purchase (<$500)
8040 | Travel (Air, Mileage, Parking)
8042 | Ground Transportation (Rental cars, vans, rental fuel, etc.)
8044 | Meals & Entertainment
8045 | Lodging
8050 | [NAME]
8065 | Contract Labor - General
8066 | Contract Labor - Coaches
8067 | Contract Labor - Trainers
8068 | Contract Labor - Referees
8069 | Contract Labor - Site Coordinators
8100 | Event Fees
8105 | Field Expenses
* | If not shown above, please just provide a detailed description of the charge incurred and we will code accordingly
Spreadsheet: louise_kitchen__24070__CashPlan_11
Sheet: TOTAL_Companies

ENRON CORP - ALL Groups
Sources & Uses of Cash - Dec 2001 thru Dec 2002
 |  | Week Ended |  |  |  |  |  |  |  |  |  | 2001 |  | 2002
 |  | 2001-12-08 00:00:00 |  | 2001-12-15 00:00:00 |  | 2001-12-22 00:00:00 |  | 2001-12-29 00:00:00 |  | 2001-12-31 00:00:00 |  | Dec |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | TOTAL
Revenues (Cash)
PRMA - Liquidations
Customer Deposits/Broker Settlements
Cost of Goods Sold
"Gross Margin"
Other Operating Expenses
Severance
Interest Expense
Current Taxes
Dividend/Interest Income
Other Operating Income
Equity Distributions
Other Funds Flow
Merchant - Proceeds
Merchant - Additions
Other Working Capital
Other
Other Operating cash
Proceeds on Sale of Assets
Capital Expenditures
Other Investing
Net Investing
PRMA - Prepay Settlements
Repayment of Long-term Debt (@BU)
Dividends - Preferred Stock / Min Int
Dividends - Common Stock
[NAME] to Corp
Treasury Stock Activity
Off-Balance Sheet Refinancings
Financing Outflows
Sub-Total
PRMA - Prepay Inflows
New Long-Term Debt
Short-term Debt (net)
Issuance of Stock
Financing Inflows
Cash To / (From) Corp
Memo:
Operating Expenses (Cash)
Employee Related Expenses
Other Operating Expenses
Adjustments
Chapter 11 Reductions
Transfers to NETCo.
Net
Spreadsheet: 170745d1343390688-conditional-formatting-column-of-data-demo
Sheet: Sheet1

Postcode Issues | Sector | Date start | Date End |  | ID number | Postcode |  | ID Number | Date Start | Date End
AB1 | 2,3 | 2012-08-02 00:00:00 | 2012-09-04 00:00:00 |  | 12345 | AB1 5HZ |  | 23456 | 2012-08-17 00:00:00 | 2012-08-30 00:00:00
AB2 | All | 2012-08-17 00:00:00 | 2012-08-30 00:00:00 |  | 23456 | AB2 7BT |  | 56789 | 2012-08-02 00:00:00 | 2012-09-04 00:00:00 |  | I now think I understand what you are looking for.
DY4 | 7,8 | 2012-08-02 00:00:00 | 2012-08-30 00:00:00 |  | 34567 | DY4 5DG |  |  |  |  |  | I have set the CF to be
 |  |  |  |  | 45678 | FH6 8GP
 |  |  |  |  | 56789 | AB1 2GT
 |  |  |  |  |  |  |  |  |  |  |  | I selected both columns F and G and then applied the formula
 |  |  |  |  |  |  |  |  |  |  |  | The formula is checking whether there are ANY entries in column I
 |  |  |  |  |  |  |  |  |  |  |  | that match match the value in column F
 |  |  |  |  |  |  |  |  |  |  |  | Because the heading ID number will match, the additional test is that
 |  |  |  |  |  |  |  |  |  |  |  | the row number is not equal to 1, so the heading doesn't get shaded.
Spreadsheet: daren_farmer__5355__hpl0711
Sheet: Sheet1

HPLN0711.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective July 11, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-07-11 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 60  0900hrs
 |  |  |  |  | 60  to 0 2100hrs | 60  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 8 | 0
Enron (S) |  | Texoma |  | ENA | 40 | 40
Enron (S) |  | Oasis Sealy |  | ENA | 40 | 60
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 3.6 | 3.6
Empire (Enron) |  | Sterling Plant |  | Empire | 5 | 5
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 92154d1291815844-average-value-on-conditions-example
Sheet: Sheet1

Year | trade | Number of transactions | SUM BY YEAR
2004 | 0.1176470588235294 | 1 | 0
2004 | 0.2481204873086371 | 2 | 0
2004 | 0.2 | 3
2005 | 0.3333333333333333 | 1 | 0
2005 | 0.09090909090909091 | 2
2007 | 1.825000825000825 | 1 | 0
2007 | 0.1538461538461539 | 2 | 0
2007 | 0.1428571428571428 | 3 | 0
2007 | 0.125 | 4
2009 | 0.07142857142857142 | 1
2010 | 0.0007779657266842244 | 1 | 0
2010 | 0.4074149521287431 | 2
Spreadsheet: 77148d1277652321-differentiate-alphabets-to-numbers-book1
Sheet: Sheet1

1bcd | 10 | 1
4723 | 16 | 7
4C0B | 9 | 9
19C1 | 14 | 5
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
 | #N/A | #N/A
Spreadsheet: 151531d1334952780-leaderboard-sorting-copy-of-grampian-20eye-20spreadsheet-20revised-1-
Sheet: Leader Board

 |  | Grampian Eye 2012
 |  | Results Table
 | Rank | Club | Session 1 | Session 2 | Session 3 | Total
 | 1 | Aberdeen | 0 | 0 | 0 | 0
 | 1 | [NAME] | 0 | 0 | 0 | 0
 | 1 | Deeside | 0 | 0 | 0 | 0
 | 1 | Deveron | 0 | 0 | 0 | 0
 | 1 | Donside | 0 | 0 | 0 | 0
 | 1 | Ellon | 0 | 0 | 0 | 0
 | 1 | Forres | 0 | 0 | 0 | 0
 | 1 | Fraserburgh | 0 | 0 | 0 | 0
 | 1 | Mearns | 0 | 0 | 0 | 0
 | 1 | Moray | 0 | 0 | 0 | 0
 | 1 | Peterhead | 0 | 0 | 0 | 0
Spreadsheet: 112790d1308780396-moving-rows-from-one-sheet-to-another-sheet-based-on-row-content-test-book
Sheet: Master List

Local Government | Population Range | Action Type | Action Category | Action
A | 50,000-100,000 | Supportive | Fleet | "Bike to Work" campaign
B | 10,000-50,000 | Supportive | Planning | "Cool Tool" developed to track GHG emissions
C | 10,000-50,000 | Supportive | Lighting | "Turn it off" program initiated at administrative building
D | 100,000+ | Direct | Other Energy | 10 energy conservation projects implemented
E | 5,000-10,000 | Direct | Fleet | 2 new fleet vehicles right‐sized for efficiency
F | 50,000-100,000 | Supportive | Water | [NAME] energy study completed and recommendations have been implemented
G | 50,000-100,000 | Direct | Fleet | 27 of 40 small transportation vehicles are hybrid
H | 100,000+ | Direct | Heating | 3 high efficient furnaces installed at Rutland Fire Hall
I | 10,000-50,000 | Direct | Generation | 3 solar powered pedestrian signs installed
J | 50,000-100,000 | Direct | Heating | 4th avenue [NAME] unit replaced
K | 100,000+ | Direct | Fleet | 50% of the pool vehicle fleet is now hybrid
L | 50,000-100,000 | Direct | Other Energy | 60% of pc's to change to thin clients (using less energy and average a 48% decrease in overall cost over a traditional workstation)
M | 10,000-50,000 | Direct | Lighting | 70% of main lighting at City Hall is motion -sensored
Spreadsheet: 743794d1628728019-help-pls-hard-excel-countif-for-multiple-criteria-rollbook-20example-20final
Sheet: PERS STAT

PERSTAT | DATE | 2021-08-10 00:00:00 |  |  |  |  | MARKINGS | 10/08 | 11/08 | 12/08 | 13/08 | 14/08 | 15/08 | 16/08 | 17/08 | 18/08 | 19/08 | 20/08 | 21/08 | 22/08 | 23/08 | 24/08 | 25/08 | 26/08 | 27/08 | 28/08 | 29/08 | 30/08 | 31/08
 | HOTEL |  | REST |  |  |  | AM-GOLD-LI
PERS | REGULAR | RESERVE | REGULAR | RESERVE |  |  | AM-GOLD-LO
[NAME] |  |  |  |  |  |  | PM-GOLD-LI
[NAME] |  |  |  |  |  |  | PM-GOLD-LO
 |  |  |  |  |  |  | R-GOLD-LI
 |  |  |  |  |  |  | R-GOLD-LO
 |  |  |  |  |  |  | AM-BRIS-LI
 |  |  |  |  |  |  | AM-BRIS-LO
 |  |  |  |  |  |  | PM-BRIS-LI
 |  |  |  |  |  |  | PM-BRIS-LO
 |  |  |  |  |  |  | R-BRIS-LI
 |  |  |  |  |  |  | R-BRIS-LO
 |  |  |  |  |  |  | AM-BRISA-LI
 |  |  |  |  |  |  | AM-BRISA-LO
 |  |  |  |  |  |  | PM-BRISA-LI
 |  |  |  |  |  |  | PM-BRISA-LO
 |  |  |  |  |  |  | R-BRISA-LI
 |  |  |  |  |  |  | R-BRISA-LO
 |  |  |  |  |  |  | ENOG-LI
 |  |  |  |  |  |  | ENOG-LO
 |  |  |  |  |  |  | R-ENOG-LI
 |  |  |  |  |  |  | R-ENOG-LO
 |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  | COUNTIFS(ROLLBOOK!$D:$D,$A$4,ROLLBOOK!$E:$E,$A5,ROLLBOOK!$F:$F,B$3,INDEX(ROLLBOOK!$G:$XFD,0,MATCH($C$1,ROLLBOOK!$G$3:$XFD$3,0)),"*M-*")
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -38378 | -22056
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2000777 | -2124357
58710 | -21848 | -792
60921 | 1732677 | 1737095
78026 |  | 43500
500084 | -14521 | -18000
500085
500097 | -11
INDEX
2001-07-31 00:00:00 |  |  | 296780.47
2001-08-18 00:00:00
CBS Volume
 |  |  | 67620
2001-08-11 00:00:00
Spreadsheet: andy_zipper__139__ICE - Mar12 Power & Gas VOL
Sheet: E-Mail

 | 2001-03-12 00:00:00
 | POWER
 | PHYSICAL GAS
 | FINANCIAL GAS
 | TOTAL GAS
 |  |  |  |  |  |  | DEALS | VOLUME
 |  |  |  |  |  | POWER
 |  |  |  |  |  | PHYSICAL GAS
 |  |  |  |  |  | FINANCIAL GAS
Spreadsheet: 725024d1616504427-autosum-drag-down-column-at-fixed-intervals-in-data-example
Sheet: SUMMARY

S.NO. | TOWER/SHOP/FLAT | MONTHLY RENT | TOTAL RENT RECEIVABLE | RENT PAID | LAST MONTH |  | MONTH DUE | AMOUNT
1 | Tenant 1 | 40000
2 | [NAME] | 35000
3 | Tenant 3
4 | [NAME]
5 | Tenant 5
6 | Tenant 6
Spreadsheet: kate_symes__18684__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097