tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: errol_mclaughlin_jr__10068__trading track book request
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request
 |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | Administrator* | MTM | Prud | Realized
 | Trade-Track-1 | Trading Track 1 | x |  |  | * | CENTRAL | X | X | X | X |  | NG/MMBTU/USD | See below
 | Trade-Track-2 | Trading Track 2 | x |  |  |  | CENTRAL | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-3 | Trading Track 3 | x |  |  |  | CENTRAL | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-4 | Trading Track 4 | x |  |  |  | WEST | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-5 | Trading Track 5 | x |  |  |  | WEST | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-6 | Trading Track 6 | x |  |  |  | WEST | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-7 | Trading Track 7 | x |  |  |  | EAST | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-8 | Trading Track 8 | x |  |  |  | EAST | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-9 | Trading Track 9 | x |  |  |  | EAST | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-10 | Trading Track 10 | x |  |  |  | TEXAS | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-11 | Trading Track 11 | x |  |  |  | TEXAS | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-12 | Trading Track 12 | x |  |  |  | TEXAS | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-13 | Trading Track 13 | x |  |  |  | PRICE | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-14 | Trading Track 14 | x |  |  |  | PRICE | X | X | X | X |  | NG/MMBTU/USD
 | Trade-Track-15 | Trading Track 15 | x |  |  |  | PRICE | X | X | X | X |  | NG/MMBTU/USD
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - |  | - | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - |  | - | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - |  | - | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - |  | - | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - |  | - | TN10/CNTR/USD
 |  |  |  |  |  | Set up as firm book with an original code
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List: | User Id | Regions Books
 | [NAME] | plove | Central
 | [NAME] | kkeiser | East
 | Anne Bike | abike | West
 | O'neal Winfree | owinfre | Texas
 | [NAME] | dbaumba | Texas
 | [NAME] | emclaug | Price
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Any questions, please contact me
 | (x31462)
Spreadsheet: 154804d1336571111-multiple-returns-in-line-hse-registeredited
Sheet: Report1

ID | Date | Person | Department | Item | Probability | Severity | Risk | Actions | Probability2 | Severity3 | Residual Risk | Status | Review Date
AUOP12001 | 2012-04-01 00:00:00 | [NAME] |  | Lifting Pumps could hurt backs | Medium | High |  |  | High | High |  | Open
AUOP12002 | 2012-06-01 00:00:00 | [NAME] |  | Bulk plant creating dust | Medium | Medium |  |  | Low | Low |  | Open
AUOP12003 | 2012-04-03 00:00:00 | [NAME] |  | hoists could injure someone | High | High |  |  | Medium | Medium |  | Open
AUOP12004 | 2012-08-06 00:00:00 | [NAME] |  | Backing up alarms should be fitted | Medium | High |  |  | High | Medium |  | Open
AUOP12005 | 2012-10-04 00:00:00 | [NAME] |  | Moving parts on cement pumper | Medium | High |  |  | Low | Low |  | Open
Spreadsheet: 1dab41f3-4ee3-4cea-a4e5-665b5b791aab
Sheet: Capital Equip

Service Center Calculations
Equipment > $5,000
The purpose of this sheet is to track depreciation costs of capitalized equipment used to provide the service(s)
If you have any questions about the accounting for equipment >$5,000 for this service center, please contact the Controller's Office
Sheet instructions
Fill in only yellow highlighted areas in both sections as applicable
Column J - Identify the % of use of the equipment for each service
Add additional lines as needed
SERVICE CENTER EQUIPMENT INFORMATION
 |  |  |  |  |  |  |  |  | SERVICE 1 |  | SERVICE 2
Depreciation Schedule - Allowable equipment only*
Desc/Type of Equipment | UI Property Tag# | Acquisition Budget No. | Acquistion Date | Depr Start Date | Depr End Date | Acquisition Cost | Useful Life (years) | Annual depreciation | % | Amount | % | Amount
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0
Totals
*Unallowable equipment replacements include equipment originally purchased on a grant or purchases of new equipment not previously in use by the service center.
 |  |  |  |  | Percentage of Use
 |  |  |  |  | SERVICE 1 | SERVICE 2
Other Equipment Used to Provide Service But Not Included in the Costs
Desc/Type of Equipment | U of I Tag Number | Acquisition Budget No. | Acquistion Date | Acquisition Cost | % | %
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
NEW EQUIPMENT PURCHASES FOR THIS NEXT FISCAL YEAR (PURCHASES OF EQUIPMENT TO REPLACE CURRENT ALLOWABLE EQUIPMENT)**
 |  | SERVICE 1 |  | SERVICE 2 |  |  | Indicate the budget that is used for equipment reserves for this service center***
Equipment purchases > $5,000
General description of equipment to be purchased in the coming fiscal year | Estimated cost | % | Amount | % | Amount
 |  | 0 |  | 0 |  |  | Equipment reserves |  | SERVICE 1 |  | SERVICE 2
 |  | 0 |  | 0 |  |  | (Can not exceed inventory total or carryover total)
 |  | 0 |  | 0 |  |  |  | Total | % | Amount | % | Amount
 |  | 0 |  | 0
Totals |  |  |  |  |  |  | Amount of carryover kept on reserve for >$5,000 equipment purchases
**The intent of the equipment purchase section is to record those pieces of equipment that will be purchased in the upcoming fiscal year that are replacements for existing service center equipment, that have allowable depreciation
***If a service center is building an equipment reserve, that reserve ideally should be in a separate budget within the same fund -- contact the Controller's Office for further help or information
Spreadsheet: 782717d1654197678-need-to-bring-in-max-amount-based-on-multiple-criteria-query-2
Sheet: Sheet1

Name | Data | ID | $
[NAME] | The Bird Perch - Ashville | 10001 | 2112
Charlotte | Brightmore | 10002 | 188
Charlotte | Brightmore | 10002 | 226
Charlotte | Brightmore | 10002 | 1263
Charlotte | Brightmore | 10002 | 479
WB | CP Grand | 10003 | 139
LD | [NAME] | 10004 | 605
LD | [NAME] | 10004 | 284
LD | [NAME] | 10004 | 402
GB | Warhorse | 10005 | 1680
GB | Warhorse | 10005 | 1480
GB | Warhorse | 10005 | 339
GB | Warhorse | 10005 | 2925
GB | 23782 - Warhorse - Colorado | 10006 | 665
GB | Warhorse - Omaha | 10007 | 420
GB | [NAME] | 10008 | 52
GB | [NAME] | 10008 | 121
GB | [NAME] | 10008 | 672
SHEP | [NAME] | 10009 | 1150
REX | Underground ATL Food Hall | 10010 | 1008
DUL | The Reston | 10011 | 2048
GB | Reston | 10012 | 2048
EE | KC Braces | 10013 | 0
Charlotte | The Bird Perch | 10014 | 545
Charlotte | The Bird Perch | 10014 | 2448
STEIN | Riverside Country Club | 10015 | 105
[NAME] | Riverside Golf Club | 10016 | 840
NCG | [NAME] | 10017 | 130
NCG | [NAME] | 10017 | 323
NCG | [NAME] | 10017 | 406
Crawfish | Sal's Pizza | 10018 | 435
REX | Children's Museum Bloom | 10019 | 336
LD | Alta Naco | 10020 | 944
LD | Alta Naco | 10020 | 548
LD | Alta Naco | 10020 | 408
LD | Alta Naco | 10020 | 952
TF | LD-1111 Alta Naco | 10021 | 945
TF | LD-1111 Alta Naco | 10021 | 634
KINGS | 1299 N. California - 61796 | 10022 | 162
KINGS | 1300 N. California - 61796 | 10022 | 145
KINGS | 1301 N. California - 61796 | 10022 | 135
Spreadsheet: 488359d1478625252-multiple-if-statements-on-range-sample_if-statement-issue
Sheet: Table

 |  | Classification | Revenue | Margin |  | Helper cell | Helper cell
 |  | A | >30000 | >=46.00% |  |  |  | High rev ; high margin
 |  | B | <=30000 | >=46.00% |  |  |  | Low rev; high margin
 |  | C | >30000 | <=45.99% |  |  |  | High rev ; low margin
 |  | D | <=30000 | <=45.99% |  |  |  | Low rev ; low margin
Spreadsheet: 519c430d-bd40-4a1e-bbff-63f7d8190a69
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8766 | 46068 | Carmela | Vergura | ITA | 128 | 00:18:54 | 00:00:35 | 00:36:35 | 00:01:46 | [NAME] | 1 | 01:19:27
8766 | 10324 | [NAME] | [NAME] | ITA | 127 | 00:21:48 | 00:00:36 | 00:37:51 | 00:02:07 | 00:23:06 | 2 | 01:25:30
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 12-Po   

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi lirimin nga pagesa e semestrit për [NAME] 2010/2011
 | [NAME] 2010/2011 lirohen nga pagesa e semestrit këta studentë nga
 | Fakulteti i Gjeoshkencave dhe Teknologjisë në [NAME]
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria
1 | [NAME] | [NAME] | 3 e më shumë studentë
2 | [NAME] | Vushtrri | 3 e më shumë studentë
3 | Agron Mehdi Abazi | [NAME] | 3 e më shumë studentë
4 | Armend Kadri Prekadini | Klinë | 3 e më shumë studentë
5 | Sadete Sheremet Aliu | [NAME] | 3 e më shumë studentë
6 | Floriana Bajram Oshlani | [NAME] | 3 e më shumë studentë
7 | [NAME] | [NAME] | 3 e më shumë studentë
8 | [NAME] | Skënderaj | 3 e më shumë studentë
9 | [NAME] | Malishevë | 3 e më shumë studentë
10 | [NAME] | [NAME] | 3 e më shumë studentë
11 | Bujar Xhevat Preteni | [NAME] | Asistencë sociale
12 | Imer Arif Latifi | Skënderaj | Asistencë sociale
13 | [NAME] | [NAME] | Asistencë sociale
14 | [NAME] | [NAME] | Asistencë sociale
15 | Burim [NAME] | Skënderaj | Asistencë sociale
16 | Belkize [NAME] | Skënderaj | Asistencë sociale
17 | [NAME] | Skënderaj | Asistencë sociale
18 | Adem Nazif Ibishi | [NAME] | Asistencë sociale
19 | [NAME] | Skënderaj | Invalid civil
20 | Artan Shaban Syla | Skënderaj | Invalid civil
21 | [NAME] | Prishtinë | Invalid i luftes
22 | Bajram Dibran Peci | [NAME] | Invalid i luftes
23 | Hamide Ramadan Istrefi | [NAME] | Prindi i vrarë
24 | [NAME] | Skënderaj | Prindi i vrarë
25 | [NAME] | Obiliq | Prindi i vrarë
VËREJTJE:
Studentët e liruar në bazë të këtij [NAME] të paraqiten në shërbimin financiar të fakultetit gjegjës për të bërë kërkesë për [NAME] e mjeteve të paguara për semester.
 |  | K O M I S I O N I:
 |  | Prof.Dr.[NAME],kryetar              ________________
 |  | [NAME], anëtar                           ________________
 |  | [NAME], anëtar                         ________________
 |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 109787d1306539593-dropdown-list-and-multiple-sheet-index-match-dropdown-list-and-multiple-sheet-index-match
Sheet: Tacos

 | AK | AZ | CA | ID | WV
Taco Bell | N | Y | Y | N | Y
Fillibertos | N | Y | Y | Y | N
[NAME] | Y | Y | Y | N | N
Taco Hut | N | N | N | Y | Y
Spreadsheet: 110802d1307397711-difference-between-two-dates-in-week-and-days-778774-date_difference
Sheet: Sheet1

 | Days | Weeks | Days | Weeks and Days
 |  |  |  |  |  | 2011-06-30 00:00:00
Spreadsheet: 877990d1724942241-formula-or-vba-code-to-change-format-of-a-text-box-book1
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014 | IR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024 | CLEAR
Spreadsheet: 844539d1696330106-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-fishing-competition-results-1-
Sheet: 2

Croft Fisheries | Huyton 1 | 18th September 2016
Name | lbs | oz | Oz (total) | Points
 | 6 | 13
 | 7 | 2
 | 4 | 9
 | 14 | 12
 | 11 | 5
 | 11 | 7
 | 32 | 11
 | 18 | 5
 | 10 | 5
 | 7 | 12
 | 3 | 1
 | 4 | 2
 | 7 | 10
Spreadsheet: 120615d1315408227-excel-2007-combining-vlookup-and-if-statements-to-return-multiple-criteria-examplesheet
Sheet: Sheet1

[NAME]: | name | Data sent? | HoursQ1 | Logins | Groups | Tasks | Status:
1 | [NAME] | Y | 1200 | 6 | 6 | 17
2 | Jones | N | 200 | 2 | 8 | 7
3 | Smith | N | 75 | 4 | 2 | 15
4 | [NAME] | Y | 40 | 2 | 6 | 6
5 | [NAME] | Y | 160 | 0 | 3 | 12
6 | Fine | Y | 245 | 9 | 4 | 14
RULES:
If Data sent is "N" then "Status" is always "BAD" regardless of the other conditions
Good: |  |  | >500 | =>5 | =>5 | =>3
OK: |  |  | =>100 | =>3 | =>3 | =>2
BAD: |  |  | =<99 | =<2 | =<2 | =<1
Spreadsheet: 809985d1671476179-discount-rates-formula-and-npv-investment-model_help_v2
Sheet: Goal Seek of sum

 |  |  |  |  |  | 2022-12-01 00:00:00
 | Rental Revenue Discount Rate |  |  | 0.0686
 | Residual Value Discount Rate |  |  | 0.08
 | Cash Flow
 | Rental Revenue |  |  |  |  | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86
 | Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17952165
 | Unlevered Cash Flow, PV
 | Residual, PV
 | Unlevered Present Value
 | Unlevered Cash Flow
 | Interest Expense |  |  |  |  | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667
 | [NAME]
 | Residual
 | Debt Payoff |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -15307908.73
 | Net Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME], PV
 | Net Residual, PV
 | Levered Present Value
 |  |  |  |  | Total NPV |  |  |  |  | exact NPV
 |  |  | [NAME] |  |  | 0.07869261201357977 |  |  |  | exact rate
 |  |  |  | Proof of Concept (common discount rate for sum of unlevered and levered CFs)
 |  |  |  | Unlevered CF PV
 |  |  |  | Residual CF PV
 |  |  |  | Unlevered NPV
 |  |  |  | [NAME]
 |  |  |  | Net Residual PV
 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Difference
 |  |  |  |  | Total NPV |  |  |  |  | exact NPV
 |  |  |  | [NAME] |  |  |  |  |  | exact NPV
Spreadsheet: dd9b57b9-7c24-429e-949f-ed8ce8286188
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6929 | 15682 | [NAME] | [NAME] | RUS | 159 | 00:11:56 | 00:00:00 | 00:24:29 | 00:01:18 | 00:18:03 | 1 | 00:55:48
6929 | 46691 | Pertti | Tuomainen | FIN | 158 | 00:12:42 | 00:00:00 | 00:25:27 | 00:01:33 | 00:20:27 | 2 | 01:00:10
6929 | 21752 | Kaarel | [NAME] | EST | 161 | 00:12:55 | 00:00:00 | [NAME] | 00:02:03 | 00:20:07 | 3 | 01:02:25
6929 | 39243 | [NAME] | Billingsley | USA | 160 | 00:14:02 | 00:00:00 | 00:28:57 | 00:03:59 | [NAME] | 4 | 01:20:19
6929 | 7910 | Antti | Mustonen | FIN | 0 | 00:12:52 | 00:00:00 | 00:45:38 | 00:02:46 | 00:20:59 | 5 | 01:22:16
6929 | 47074 | Matti | Makinen | FIN | 0 | 00:12:43 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 23ed63f2-56ad-4564-916e-b066e5d4cf56
Sheet: Sheet1

Constitutional Measure No. 1  Relates to the elec... (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/18/2013 10:05:25 AM
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
2002 Primary Election - OFFICIAL RESULTS
Precinct | Yes | No | TOTALS
Combined Precinct | 244 | 340 | 584
TOTAL | 244 | 340 | 584
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 27640d1221033969-can-row-number-in-index-forumla-be-referenced-to-several-rows-test
Sheet: Sheet1

IO | Org | 2001 | 2001 | 2001 | 2002
3311 | asp | 1 | 2 | 3 | 4
3311 | asp | 133.3333333333333 | 133.3333333333333 | 133.3333333333333 | 133.3333333333333
3311 | asp | 13.33336 | 13.33336 | 13.33336 | 13.33336
3311 | [NAME] | 10.9666886 | 10.9666886 | 10.9666886 | 10.9666886
3311 | [NAME] | 333.3339999999999 | 333.3339999999999 | 333.3339999999999 | 333.3339999999999
3311 | [NAME] | 11.11113333333333 | 11.11113333333333 | 11.11113333333333 | 11.11113333333333
3310 | gss | 166.1114433333333 | 166.1114433333333 | 166.1114433333333 | 166.1114433333333
3310 | gss | 5000 | 5000 | 5000 | 5000
3310 | gss | 1500 | 1500 | 1500 | 1500
3310 | asp | 8.333333333333334 | 8.333333333333334 | 8.333333333333334 | 8.333333333333334
3310 | [NAME] | 61.75 | 61.75 | 61.75 | 61.75
3310 | gss | 110 | 110 | 110 | 110
3310 | asp | 5808.22 | 5808.22 | 5808.22 | 5808.22
Spreadsheet: darrell_schoolcraft__7578__UnitOp84
Sheet: Sublette

Detailed compression analysis for pipeline hydraulic model: |  |  |  |  |  | HugHol84.wpf
 |  |  |  |  |  | 03/19/02 flows with Fin 2 & 4 routed south, Hugo 440 PSIG dis
Unit | Service | Suction |  | Discharge |  | Flow | HP | RPM | Step | Efficiency | Fuel
 |  | Temp | Press | Temp | Press
 |  | (F) | (PSIG) | (F) | (PSIG) | (MMSCF/D) | (HP) | (RPM) |  | (%) | (MMSCF/D)
14 | B to B | 70 | 379 | 159 | 702 | 50 | 1688 | 240 | 1 |  | 0.422
26 | B to B | 70 | 379 | 159 | 702 | 86 | 3085 | 11700 |  | 76
27 | B to B | 70 | 379 | 159 | 702 | 86 | 3085 | 11700 |  | 76
Subtotal
20 | A to A | 70 | 36 | 256 | 381 | 13 | 1916 | 310 | 2 |  | 0.479
21 | A to A | 70 | 36 | 256 | 381 | 13 | 1916 | 310 | 2 |  | 0.479
Subtotal
23 | Hsk to A | 48 | 122 | 201 | 381 | 13 | 986 | 750 | 1 |  | 0.2473
24 | Hsk to A | 48 | 122 | 201 | 381 | 13 | 986 | 750 | 1 |  | 0.2473
Subtotal
Spreadsheet: 814404d1674351532-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test-3-
Sheet: Formulas

 |  |  |  | APR | MAY | JUN
 |  |  | 2022FY Production Claims |  |  |  | <---------- | Expected results. These results shoulb be automatic, considering the months in Columns A
 |  |  |  | APR | MAY | JUN
 |  |  | 2023FY Production Claims |  |  |  | <---------- | Expected results. These results shoulb be automatic, considering the months in Columns A
 |  |  |  |  |  |  |  |  | Portuguese | SOMARPRODUTO((E4=PROC(LIN($5:$50);LIN($5:$50)/(INDIRETO(("'CLAIM MANAGEMENT "&ESQUERDA($D5;6)&"'!A5:A50")<>"");INDIRETO("'CLAIM MANAGEMENT "&ESQUERDA($D5;6)&"'!A5:A50")))*INDIRETO("'CLAIM MANAGEMENT "&ESQUERDA($D5;6)&"'!C5:C50"))
 |  |  |  |  |  |  |  |  | English | SUMPRODUCT((E4=LOOKUP(ROW($5:$50),ROW($5:$50)/(INDIRECT("'CLAIM MANAGEMENT "&LEFT($D5,6)&"'!A5:A50")<>""),INDIRECT("'CLAIM MANAGEMENT "&LEFT($D5,6)&"'!A5:A50")))*INDIRECT("'CLAIM MANAGEMENT "&LEFT($D5,6)&"'!C5:C50"))
Spreadsheet: kate_symes__18642__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-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200
 | 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
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593