tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 218220521 | 93151595 | 24631437 | 46506794
FRA | 87258626 | 13384450 | 5188990 | 2661337
OIS | 51735178 | 14334528 | 7673020 | 5948327
OTHER* | 11862129 | 66194534 | 828558 | 21451426
TOTAL | 369076454 | 187065107 | 38322005 | 76567884
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 03769650-6f55-4c8c-ad98-1e71041b81d7
Sheet: Sheet1

DEPARTMENT OF ACCOUNTING AND GENERAL SERVICES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
DIVISION OF PUBLIC WORKS
NOTE:  This report must be made in triplicate and signed by both parties immediately after the day's work
 |  | DAILY FORCE ACCOUNT REPORT
PROJECT: |  |  |  |  |  |  |  | DATE:
D.A.G.S. JOB NO. |  |  | CONTRACTOR:
PART A |  | CLASS OF EMPLOYEE        (2) | HOURS            (3 ) | WAGES HOUR RATE     (4) | FRINGE RATE          (5) | WAGES X HOURS                 (6) | FRINGE X HOURS             (7) | INS.*         RATE            (8) | INSURANCE               (9) | TOTAL FOR       LABOR                    (10)
(NAME OF EMPLOYEE)               (1)
 |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  | 0 | 0
*Workmen's Compensation, PL/PD, FICA, TDI |  |  |  |  |  | 0 | 0 |  | 0 | 0
Federal/State Unemployment Compensation |  |  |  | SUB-TOTAL
PART B |  | UNIT |  | UNIT PRICE |  | NO. OF UNITS |  |  |  | PART B TOTAL
MATERIALS
 |  |  |  | 0 |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
SUB-TOTAL (PART B) |  |  |  |  |  |  |  |  |  | 0
PART C | TOTAL (PART A + PART B) |  |  |  |  |  |  |  |  | 0
PART D | CONTRACTOR'S OPERATING COST, OVERHEAD AND PROFIT @ |  |  |  |  |  |  | 20 | % | 0
PART E | INSURANCE AMOUNT + 6% OVERHEAD |  |  |  |  |  |  |  |  | 0
PART F |  | TYPE OR            CLASS |  | RATE |  | HOURS |  |  |  | AMOUNT
EQUIPMENT
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
SUB-TOTAL (PART F) |  |  |  |  |  |  |  |  |  | 0
GROSS EARNED (PARTS C THROUGH F INCLUSIVE) |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | % Bond Fee | 0
 |  |  |  |  |  |  |  | 4.712% GET |  | 0
GRAND TOTAL THIS REPORT |  |  |  |  |  |  |  |  |  | 0
[NAME] OF WORK |  |  |  |  |  | The above is a true statement of all force account work for this date.
 |  |  |  |  |  | Project Inspector
 |  |  |  |  |  | Contractor or [NAME]'s Representative
Spreadsheet: 106286d1303470531-statement-of-account-cannot-get-formula-to-work-book1
Sheet: New 

Today | Today + 30 Days | Today + 60 Days | Today + 90 Days | Today + 120 Days
Date | Invoice Details | Your Ref | Debit | Date of Receipt | Credit | Balance
2010-12-01 00:00:00 | xyzxxx | abcdefg | 25 |  | 25
2011-01-01 00:00:00 | xyzxxx | abcdefg | 25
2011-02-01 00:00:00 | xyzxxx | abcdefg | 25
2011-03-01 00:00:00 | xyzxxx | abcdefg | 25 |  | 0
Total
Total Amount Due
Aging | 30 Days | 60 days | 90 days | 120+
Spreadsheet: 41e92dd1-d7c4-4577-9ee0-8657612a5146
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
FCHOP | Test | FCHOP | Myxoid/Round Cell Liposarcoma 12q13 (DDIT3 or CHOP) Rearrangement, FISH, Tissue | DDIT3 (CHOP), 12q13, FISH | Fluorescence In Situ Hybridization (FISH) | Formalin-fixed, paraffin-embedded tissue: FFPET |  |  |  |  | Provide a pathology report with each tissue specimen. The laboratory will not reject a specimen that arrives without this information but will hold the specimen until a pathology report is received.   [NAME]: Tissue block and slide Collection Instructions: Submit formalin-fixed, paraffin-embedded tumor tissue block and include 1 hematoxylin-and-eosin stained slide. Forms: If not ordering electronically, submit a Cytogenetics Hematologic Disorders Request Form (Supply T607) with the specimen. | Paraffin-embedded whole tissue o | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 7 days | 10 days |  | Profile |  |  |  |  | Rochester
FCHOP | [NAME] | TISSUE | Tissue |  |  |  | Ambient
FCHOP | Order Question | CG061 | Reason For Referral |  | Plain Text
FCHOP | Result | 27388 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
FCHOP | Result | 27389 | [NAME] | [NAME] | Alphanumeric
FCHOP | Result | 27390 | Source | Source | Alphanumeric
FCHOP | Result | 27391 | Order Date | Order Date | Alphanumeric
FCHOP | Result | CG061 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
FCHOP | Result | 27393 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCHOP | Result | 27394 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCHOP | Result | 27395 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2
FCHOP | Result | 27396 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCHOP | Result | 27397 | Consultant | Consultant | Alphanumeric
FCHOP | Result | 27398 | Released Date | Released Date | Alphanumeric
FCHOP | Billing Component | FCHOP |  | Cytogenetic Interp/Report |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88291
FCHOP | Billing Component | FCHOP |  | [NAME],each |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88271
FCHOP | Billing Component | FCHOP |  | In situ hybrid, 100-300 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88275
Spreadsheet: 01b3bf87-025c-4934-8acc-f731b482fcc8
Sheet: Corporate VC Sectors

Total Venture Capital and Corporate Venture Capital by Sector  - Last 7 Quarters
01/01/2011-09/30/2012
MoneyTree Sector | Total # Sector Deals | Average $M Per Deal | Total $M Invested in that Sector by All VC Types | # Deals with CVC Participation | Avg. CVC investment in Those Rounds Participated In | $ CVC Investment | % of CVC Investment $ | % of Deals with CVC Involvement | CVC % of $ In Sector
Biotechnology | 798 |  | 7786.71 | 149 |  | 633.24
Business Products and Services | 91 |  | 284.68 | 3 |  | 3.83
Computers and Peripherals | 98 |  | 853.6 | 18 |  | 43.12
Consumer Products and Services | 249 |  | 2059.01 | 16 |  | 72.64
Electronics/Instrumentation | 96 |  | 646.57 | 17 |  | 48.75
Financial Services | 97 |  | 644.78 | 9 |  | 31.22
Healthcare Services | 75 |  | 538.91 | 7 |  | 13.11
Industrial/Energy | 479 |  | 5758.03 | 92 |  | 656.13
IT Services | 618 |  | 3969.76 | 86 |  | 384.87
Media and Entertainment | 736 |  | 3856.63 | 93 |  | 214.94
Medical Devices and Equipment | 597 |  | 4652.91 | 85 |  | 348.19
Networking and Equipment | 82 |  | 589.82 | 14 |  | 29.15
Other* | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Retailing/Distribution | 103 |  | 878.56 | 12 |  | 50.07
Semiconductors | 213 |  | 2021.09 | 37 |  | 211.73
Software | 2013 |  | 13468.72 | 307 |  | 1130.82
Telecommunications | 200 |  | 1179.49 | 39 |  | 106.03
* - Note: Small differences in grand totals are due to disregarding the 3 deals in unknown sectors from this chart.
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 856622d1705828947-match-and-extract-lambda-map-filter-extract_3
Sheet: L3

 |  |  |  |  | Match |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<< Extract >> | <<< Extract >> |  |  | <<< Extract >>
 |  |  |  |  | B-1/2/3 | fsf | vfsdfs | gdsf | dfgsd | fas | sfasdf | afs | asdfeas | fasdf | asdf | asdf | dasf | asdf | asdf |  |  |  |  |  | Apple | x | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | Lon-2/5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apps,ND | Jasmine | x | x | 36.12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | Lon-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apps,ND | Lily | x | x | 44
 |  |  |  |  | S-4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME],Matrix | Rose | x | x | 101.36
 |  |  |  |  | x
 |  |  |  |  | S-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Hopkins |  |  | 416
 |  |  |  |  | ab
Spreadsheet: 823101d1679701350-power-query-custom-column-how-to-return-same-cell-ref-value-from-multiple-workbooks-pq-append
Sheet: Snook Ltd

Supplier | REGION | COUNTY | Column4
Snook Ltd | 1. Scotland | All of Scotland | YES
Snook Ltd | 4. Northern Ireland | All of Northern Ireland | YES
Snook Ltd | 5. Wales | All of Wales | YES
Snook Ltd | 2. North West | Merseyside | YES
Snook Ltd | 3. North East and [NAME] | [NAME] | YES
Snook Ltd | 6. Midlands | Lincolnshire | YES
Snook Ltd | 7. East of England | Bedfordshire | NO
Snook Ltd | 10. London | Greater London | YES
Snook Ltd | 8. South West | Cornwall | NO
Snook Ltd | 9. South East | Hampshire | YES
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: Oasis

POI  8516
 | Scheduled | Measured | Imbal
1 | 13767 | 15609
2 | 14914 | 20338
3
4
5
6 | 50000 | 45920
7
8
9 | 15000 | 15372
10
11
12
13
14 | 3591 | 3796
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-01-31 00:00:00 |  | 24533
 | 2001-02-14 00:00:00
Spreadsheet: darrell_schoolcraft__7326__imball0202
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 |  | 150
2 | 309 | 150
3 | 285 | 150
4 | 252 | 150
5 | 300 | 150
6 | 31 | 150
7 | 4 | 150
8 | 303 | 150
9 | 289 | 150
10 | 146 | 150
11 | 52 | 150
12 | 315 | 150
13 | 201 | 150
14 | 186 | 150
15 | 164 | 150
16 | 142 | 150
17 | 227 | 150
18 | 197 | 150
19 | 226 | 150
20 | 242 | 150
21 | 264 | 150
22 | 25 | 150
23 | 180 | 150
24 | 258 | 71
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 174593.14
2002-02-24 00:00:00
CBS Volume
 |  |  | 76390
Spreadsheet: 64273d1265141248-search-tabs-and-return-results-kc_environmental_aspects-1-
Sheet: Process - Activity 4

Operating Condition | Process Evaluated | VFL | Date |  |  | Enter Date |  | Team | 0
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0 | 6 | Yes
 |  |  |  |  | 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
 |  |  |  |  | 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
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
Spreadsheet: 755643d1637003899-offset-function-for-another-sheet-reference-point-error-allocation3-copy
Sheet: Allocation

PL | Status | Project name | Start date | End date | Project Manager | Innovation Engineer | Product owner | Design Lead | Design Engineer | System Engineering | MT Lead | MT Engineer | Procurement
1 | NN | Project 1 | 2022-01-01 00:00:00 | 2022-06-30 00:00:00 | 0.3 | 0.3
1 | NN | Project 2 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 0.3 | 0.3
1 | NN | Project 3 | 2022-07-01 00:00:00 | 2023-01-15 00:00:00 | 0.3 | 0.3
1 | NN | Project 4 | 2021-10-01 00:00:00 | 2022-03-31 00:00:00 | 0.3 | 0.3
 |  | Project 5
 |  | Project 6
 |  | Project 7
 |  | Project 8
 |  | Project 9
 |  | Project 10
Spreadsheet: 812532d1673216972-analyzing-a-specific-cell-book-4
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | End
 |  | Select Period |  | This Year |  |  |  |  |  |  |  |  | Use | 2023-01-01 00:00:00 | 2023-01-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Period | Start | End
 |  |  |  |  |  |  |  |  |  |  |  |  | This Year | 2023-01-01 00:00:00 | 2023-01-08 00:00:00
 |  | Date | Time | Open | High | Low | Close |  |  |  |  |  | Last Year | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 |  | 2023-01-02 00:00:00 | 18:30:00 | 80.57 | 80.78 | 80.2 | 80.29 |  |  |  |  |  | This Month | 2023-01-01 00:00:00 | 2023-01-08 00:00:00
 |  | 2023-01-02 00:00:00 | 19:00:00 | 80.29 | 80.5 | 80.17 | 80.44 |  |  |  |  |  | Last Month | 2022-12-01 00:00:00 | 2022-12-31 00:00:00
 |  | 2023-01-02 00:00:00 | 19:30:00 | 80.45 | 80.54 | 80.41 | 80.45 |  |  |  |  |  | This Week | 2023-01-08 00:00:00 | 2023-01-08 00:00:00
 |  | 2023-01-02 00:00:00 | 20:00:00 | 80.44 | 80.47 | 80.21 | 80.25 |  |  |  |  |  | Last Week | 2023-01-01 00:00:00 | 2023-01-07 00:00:00
 |  | 2023-01-02 00:00:00 | 20:30:00 | 80.25 | 80.38 | 79.38 | 79.49
 |  | 2023-01-02 00:00:00 | 21:00:00 | 79.48 | 79.7 | 79.44 | 79.59
 |  | 2023-01-02 00:00:00 | 21:30:00 | 79.6 | 79.65 | 79.32 | 79.61
 |  | 2023-01-02 00:00:00 | 22:00:00 | 79.61 | 79.95 | 79.61 | 79.95
 |  | 2023-01-02 00:00:00 | 22:30:00 | 79.95 | 80.12 | 79.8 | 80.04
Spreadsheet: cb24622c-fe9f-40c2-b8c7-4823fb210a4d
Sheet: Sheet1

ADVANCED MICRO DEVICES, INC. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
CONSOLIDATED STATEMENTS OF OPERATIONS
([NAME])
(Millions except per share amounts and percentages)
 |  | Quarter Ended |  |  |  | Nine Months Ended
 |  | Sept. 26, | June 27, | Sept. 27, |  | Sept. 26, | Sept. 27,
 |  | 2009 | 2009 | 2008(1) |  | 2009 | 2008(1)
Net revenue |  | 1396 | 1184 | 1797 |  | 3757 | 4646
Cost of sales |  | 811 | 743 | 881 |  | 2220 | 2598
Gross margin |  | 585 | 441 | 916 |  | 1537 | 2048
Gross margin % |  | 0.419054441260745 | 0.3724662162162162 | 0.5097384529771842 |  | 0.4091030077189247 | 0.4408092983211365
Research and development |  | 420 | 425 | 438 |  | 1289 | 1383
Marketing, general and administrative |  | 221 | 247 | 315 |  | 755 | 987
Amortization of acquired intangible assets |  | 17 | 17 | 30 |  | 52 | 107
Impairment of goodwill and acquired intangible assets |  | 0 | 0 | 2 |  | 0 | 405
Restructuring charges |  | 4 | 1 | 9 |  | 65 | 40
Gain on sale of 200 millimeter equipment |  | 0 | 0 | 0 |  | 0 | -193
Operating income (loss) |  | -77 | -249 | 122 |  | -624 | -681
Interest income |  | 4 | 6 | 7 |  | 13 | 32
Interest expense |  | -114 | -108 | -94 |  | -319 | -296
Other income (expense), net |  | 47 | 6 | -13 |  | 147 | -48
Income (loss) before income taxes |  | -140 | -345 | 22 |  | -783 | -993
Provision (benefit) for income taxes |  | -5 | -10 | -1 |  | 101 | -1
Income (loss) from continuing operations |  | -135 | -335 | 23 |  | -884 | -992
Income (loss) from discontinued operations, net of tax |  | 0 | 0 | -150 |  | 0 | -674
Net income (loss) |  | -135 | -335 | -127 |  | -884 | -1666
Net (income) loss attributable to noncontrolling interest |  | 29 | 25 | -7 |  | 60 | -27
Class B preferred accretion |  | -22 | -20 | 0 |  | -50 | 0
Net Income (loss) attributable to AMD common stockholders |  | -128 | -330 | -134 |  | -874 | -1693
Net income (loss) attributable to AMD common stockholders per common share
Basic and diluted
 | Continuing operations | -0.1844380403458213 | -0.4947526236881559 | 0.02631578947368421 |  | -1.3202416918429 | -1.678747940691927
 | Discontinued operations | 0 | 0 | -0.2467105263157895 |  | 0 | -1.110378912685338
Basic and diluted net income (loss) attributable to AMD common stockholders per common share |  | -0.1844380403458213 | -0.4947526236881559 | -0.2203947368421053 |  | -1.3202416918429 | -2.789126853377265
Shares used in per share calculation
Basic and diluted |  | 694 | 667 | 608 |  | 662 | 607
(1) | Includes retrospective adoption of FASB Staff Position Accounting Principles Board No. 14-1, Accounting for Convertible Debt Instruments That May Be Settled in Cash upon Conversion (Including Partial Cash Settlement) (FSP APB 14-1) codified principally in Accounting Standards Codification (ASC) Topic 470, Debt (ASC 470) and FASB Statement No. 160, [NAME] in Consolidated  Financial Statements - An Amendment of ARB No. 51 (SFAS 160) now codified in ASC Topic 810, Consolidation (ASC 810)  in the first quarter of 2009.
Spreadsheet: 180201e8-1762-4245-8f06-460b301088c3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 82. Value of Building Approved, Chain Volume Measures, Original - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total houses ;  New ; |  |  | Original | A590547W | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total other residential building ;  New ; |  |  | Original | A590548X | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A590549A | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590550K | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590551L | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590552R | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590553T | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 49156d1248394254-help-on-pivottable-hamburglar
Sheet: PivotTable

Opportunity Name | Stage | Competitor 1 | Competitor 2 | Competitor 3
Hamburglar | Won | Arby's | Burger King | White Castle
[NAME] | Lost | McDonald's | [NAME]'s Jr. | (blank)
Mustard | Won | Burger King | (blank) | (blank)
Pickles | Won | [NAME]'s Jr. | Arby's | (blank)
Grand Total
Spreadsheet: 707726d1607432521-multiples-if-functions-complete-report
Sheet: Sheet1

History Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from start till now will get 90 days excemption
Name: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sell | 2.01 | all positions opened on 1st october willl get 15 days excemptioin
Account: |  |  | 1204 |  |  |  |  |  |  |  |  |  |  |  |  | buy | -4.11
Period: |  |  | 2019.08.12-2020.12.02 |  |  |  |  |  |  |  |  |  |  |  |  | excemption | 90 | upto | 2020-09-30 00:00:00 | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | excemption | 15 | after | 2020-10-15 00:00:00
Date: |  |  | 2020-11-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | start | 2020-10-16 00:00:00
Closed Accounts
Opening Date |  |  | Type | Volume |  |  |  | Closing Date |  |  | Previous Charges |  |  |  | no of days | Charged days | Profit
2019.08.12 16:11:15 |  |  | buy | 2 |  |  |  | 2020.02.01 16:11:15 |  |  | 0
2020-01-31 00:00:00 |  |  | sell | 4 |  |  |  | 2020-02-03 00:00:00 |  |  | 23.01
2020-09-29 00:00:00 |  |  | buy | 6 |  |  |  | 2020-11-02 00:00:00 |  |  | 0
2020-09-30 00:00:00 |  |  | buy | 6 |  |  |  | 2020-10-01 00:00:00 |  |  | 0
2020-10-15 00:00:00 |  |  | sell | 2 |  |  |  | 2020-10-15 00:00:00 |  |  | 0
2020-10-15 00:00:00 |  |  | sell | 2 |  |  |  | 2020-10-20 00:00:00 |  |  | 0
2020-11-20 00:00:00 |  |  | sell | 12 |  |  |  | 2020-11-23 00:00:00 |  |  | 0
2020-11-23 00:00:00 |  |  | buy | 12 |  |  |  | 2020-11-23 00:00:00 |  |  | 0
Open Accounts
Opening Date |  |  | Type | Volume |  |  |  | as per invoce print date |  |  |  |  |  |  | no of days | Charged days | Profit
2019-08-12 00:00:00 |  |  | sell | 2
2020-06-05 00:00:00 |  |  | sell | 2
2020-09-28 00:00:00 |  |  | sell | 6
2020-10-07 00:00:00 |  |  | buy | 6
2020-10-12 00:00:00 |  |  | buy | 6
2020-10-14 00:00:00 |  |  | sell | 6
2020-10-28 00:00:00 |  |  | buy | 6
2020-11-23 00:00:00 |  |  | sell | 10
test
assesment
2020.11.02 16:11:15
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: TX-HPLR-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPLR
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 129167 | 332493.7939999998
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | 0.08600000012665987
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 129167 | 332493.88
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | 7125923 | 18581006
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | 0
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 2.229999999999563
 | Total Purchases: |  | 7125923 | 18581008.23
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 2.889999985694885
12 |  | Purchases | -7255090 | -18914264.77000001
 | Total Intra CTS Sales / Purchases |  | -7255090 | -18914261.88000003
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0.3299999982118607
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0.3299999982118607
 | Total Storage: |  | 0 | 0.3299999982118607
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 0 | 0
 |  |  | 0 | 0
23 | Fuel: |  | 11 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 672831d1587035945-indirect-formula-with-text-containing-another-formula-indirect_function_error
Sheet: Sheet1

 | [NAME] | Rate
 | 600 | 0.06
 | 700 | 0.06*2
Example 1 | Input_Value | 650
 | Rate
 | Output
Example 2 | Input_Value | 750
 | Rate
 | Output