tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30150__9907_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | 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 | 15053190 | 34958248.75
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 44000 | 100260
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 15097190 | 35058508.75
 | Purchases:
6 |  | 3rd Party / Inter Enron | -13378691 | -30654838.48
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -377319 | -851928.06
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 18895 | 42826.08
 | Total Purchases: |  | -13737115 | -31463940.46
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 2943342 | 6673148.36
12 |  | Purchases | -2943342 | -6673148.36
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | -1360075 | -2471638.253864097
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -1360075 | -2471638.253864097
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | -36628.601
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -36628.601
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 768385.66
31 |  | Prior Month Book Balance | 0 | -722257
 |  | Total MTM Income | 0 | 46128.65999999968
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 568974.31
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -15891
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -134929
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 707231d1607107447-generate-random-values-that-are-a-function-of-calculations-random-data
Sheet: Sheet1

Raw Data
Raw Data | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
A | 25
B | 49
C | 21
D | 42
Raw Data
Percentage | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
A/B |  | 0.72 | 0.28 | 0.76 | 0.77 | 0.18 | 0.91 | 0.24 | 0.48 | 0.35 | 0.1 | 0.38 | 0.89 | 0.29 | 0.26 | 0.22
C/D |  | 0.69 | 0.24 | 0.76 | 0.8 | 0.15 | 1.32 | 0.23 | 0.55 | 0.36 | 0.11 | 0.3 | 0.79 | 0.27 | 0.26 | 0.22
A/D |  | 0.78 | 0.32 | 1.18 | 0.95 | 0.19 | 1.43 | 0.27 | 0.6 | 0.37 | 0.11 | 0.42 | 0.92 | 0.35 | 0.27 | 0.23
C/A |  | 0.88 | 0.75 | 0.64 | 0.84 | 0.8 | 0.92 | 0.87 | 0.91 | 0.96 | 1 | 0.71 | 0.86 | 0.77 | 0.97 | 0.96
Raw Data
Raw Data | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
A | 25
B | 49
C | 21
D | 42
Raw Data
Percentage | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
A/B
C/D
A/D
C/A
Spreadsheet: 807020d1669716588-how-to-combine-sumif-subtotal-commands-financial-statistics
Sheet: TEST

DATE | BANK | TYPE | [NAME] | Transaction amount | Positive prices |  | Numb. Of Credits | Credit Total
29/10/2022 | BANK NATIONAL | CHARGE | - | -150
28/10/2022 | BANK NATIONAL | CHARGE | - | -58.94 |  |  | Numb. Of Charges | Charges Total
28/10/2022 | BANK NATIONAL | CHARGE | - | -22.67
28/10/2022 | BANK NATIONAL | CHARGE | - | -59.92
28/10/2022 | BANK NATIONAL | CHARGE | - | -93.5 |  |  | SUMIF
26/10/2022 | BANK NATIONAL | CHARGE | - | -399
26/10/2022 | BANK NATIONAL | CHARGE | - | -458.01
25/10/2022 | BANK XYX | CHARGE | - | -83.23
24/10/2022 | BANK XYX | CHARGE | - | -0.3
24/10/2022 | BANK XYX | CHARGE | - | -220
24/10/2022 | BANK NATIONAL | CHARGE | - | -87.71
24/10/2022 | BANK NATIONAL | CREDIT | - | 500
20/10/2022 | BANK NATIONAL | CREDIT | - | 888
11/10/2022 | BANK XYX | CREDIT | - | 25
07/10/2022 | BANK BBBB | CHARGE | - | -13.5
03/10/2022 | BANK BBBB | CHARGE | - | -3999
03/10/2022 | BANK BBBB | CREDIT | - | 50
03/10/2022 | BANK NATIONAL | CREDIT | - | 150
03/10/2022 | BANK XYX | CREDIT | - | 350
03/10/2022 | BANK BBBB | CREDIT | - | 156
03/10/2022 | BANK BBBB | CREDIT | - | 190
2022-10-07 00:00:00 | BANK XYX | CHARGE | - | -1.5
2022-10-07 00:00:00 | BANK BBBB | CHARGE | - | -93.5
2022-10-07 00:00:00 | BANK BBBB | CHARGE | - | -1.5
2022-10-07 00:00:00 | BANK BBBB | CHARGE | - | -56.5
Spreadsheet: 125149d1318908485-this-sort-question-has-been-asked-before-most-likely-sortexample
Sheet: Sheet1

Data | Helper
R-1 |  |  | Sort by Helper Column
R-10
R-11
R-12
[NAME]
R-14
R-15
R-16
R-17
R-18
R-19
R-2
R-20
R-21
R-22
R-23
R-24
R-25
R-26
R-27
R-28
R-29
R-3
R-30
R-31
R-4
R-5
R-6
R-7
R-8
R-9
Spreadsheet: 692493d1598391516-extrapolate-roll-existing-data-in-same-format-extrap-dummy
Sheet: 28

Stat | Assignment | DocumentNo | Type | SG | DD | Clrng doc. | Text | CoCd | Doc. Date | Amount in local cur. | LCurr | Amount in doc. curr. | Curr. | Pmnt date | Day1
Bla | 123 | 12345 | RE |  |  | 12345 | [NAME] | 1 | 2020-07-08 00:00:00 | -40028.62 | EUR | -40028.62 | EUR | 2020-08-05 00:00:00 | 28
Spreadsheet: c5dcf340-e1a0-4282-a372-93f09c0d6b06
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
CRANU | Test | CRANU | Cortisol, Free, Random, Urine | Cortisol, Free, Random, U | [NAME]: Enzymatic Colorimetric Assay CRAN/10333: Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions: Collect a random urine specimen. | 3 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males 0-2 years: 3.0-120 mcg/g creatinine 3-8 years: 2.2-89 mcg/[NAME]9-12 years: 1.4-56 mcg/[NAME] 13-17 years: 1.0-42 mcg/g creatinine > or =18 years: 1.0-119 mcg/g creatinine  Females 0-2 years: 3.0-120 mcg/g creatinine 3-8 years: 2.2-89 mcg/[NAME]9-12 years: 1.4-56 mcg/[NAME] 13-17 years: 1.0-42 mcg/g creatinine > or =18 years: 0.7-85 mcg/g creatinine   Use the conversion factors below to convert each analyte from mcg/g creatinine to nmol/mol creatinine.   Conversion factor [NAME]: mcg/g creatinine x 413=nmol/mol creatinine   [NAME] molecular weight=362.5 Creatinine molecular weight=149.59 | Monday through Friday, Sunday; 1 p.m. | 2 days | 5 days | 1 | 82530 |  |  |  |  | Rochester
CRANU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 14 days
CRANU | Component | RCTU | Creatinine, Random, U | [NAME] | For further information see 8513 Creatinine, U. | [NAME], 24-hour graduated: 24Urine |  |  |  |  | Only orderable as part of a profile. For further  information, see #460104 "Creatinine, [NAME]." |  |  |  |  |  |  |  |  |  |  | Yes | No
RCTU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 30 days
RCTU | Result | RCTU | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2161-8
CRANU | Component | CRAN | Cortisol, Random, Urine | Cortisol, Random, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) Only orderable as part of a profile. For further information see CRANU/82920 Cortisol, Free, Random, [NAME]. | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions: Collect a random urine specimen. Only orderable as part of a profile. For further information see CRANU/82920 Cortisol, Free, Random, [NAME]. | 3 mL |  | Only orderable as part of a profile. For further information see CRANU/82920 Cortisol, Free, Random, [NAME]. |  |  |  |  |  |  |  | Yes | No
CRAN | [NAME] | URINE | [NAME] |  |  |  | Frozen | 14 days
CRAN | Result | 10328 | Cortisol/Creatinine Ratio | Cortisol/Creatinine Ratio | Numeric |  |  |  |  | mcg/g Cr |  |  |  |  |  |  |  |  |  | 11155-9
Spreadsheet: 808865d1670716492-filter-function-how-to-condense-the-include-argument-include-argument-of-the-filter-function
Sheet: Sheet1

All Items | Tree | All Items | <- Drop-Down Box
[NAME] | Plant
Bowl | Tree | Plant
Bus | Cat | Tree
Cat | Plant | Cat
Chair | Rabbit | Plant
Honey | Jacket | Rabbit
Jacket | Bus | Jacket
Key | Plant | Bus
Orange | Orange | Plant
Pants | Rabbit | Orange
Plant | Cat | Rabbit
Rabbit | Chair | Cat
Table | Orange | Chair
Tree | Orange | Orange
 | Key | Orange
 | Orange | Key
 | Pants | Orange
 | Chair | Pants
 | Rabbit | Chair
 | Rabbit | Rabbit
 | Cat | Rabbit
 | Rabbit | Cat
 | Table | Rabbit
 | Key | Table
 |  | Key
Spreadsheet: 211566d1359816768-sorting-based-on-matching-characteristics-binsort2_nonunique_sorted
Sheet: Sheet1

Object | [NAME] | Color | Shape |  | [NAME]
1 | 1 | blue | circle |  | 1
3 | 1 | blue | circle |  | 1
5 | 2 | blue | circle |  | 1
9 | 3 | blue | circle |  | 1
2 | 1 | red | square |  | 1
4 | 2 | green | triangle |  | 2
8 | 3 | green | triangle |  | 2
6 | 2 | red | triangle |  | 2
7 | 3 | yellow | circle |  | 3
Spreadsheet: 857277d1706287569-unique-formula-exceptions-book1
Sheet: Sheet1

Category
Transfer
aaa
Credit Card Payments
Checks |  | Post#5 ([NAME]) | Post#7 (Fluff) | Post #10 ([NAME])
[NAME]
ddd |  | [NAME] | [NAME] | [NAME]
aaa |  | ddd | ddd | ddd
[NAME]
Post#7 (Fluff)
Post #10 ([NAME])
Spreadsheet: 793022d1661266701-formula-to-count-non-blank-columns-within-a-range-count-columns-with-no-data
Sheet: Sheet1

 | item | Type | Sup1 | Sup2 | Sup3 | Sup4 | Sup5 | Sup6 | Sup7 | Sup8 | Sup9 | Sup10 | Sup11 | Sup12 | 8
 |  |  | [NAME] | Loc2 | Loc3 | Loc4 | Loc5 | Loc6 | Loc7 | Loc8 | Loc9 | Loc10 | Loc11 | Loc12
 | Item 1 | Type1 |  |  |  |  |  |  | 34
 | Item 2 | Type2 |  | 1 |  | 6.5 |  |  |  |  |  | 7.65
 | Item 3 | [NAME] |  |  |  | 2 |  |  |  |  |  | 7.61
 | Item 4 | Type4 |  |  |  | 5 | 1 | 4 | 12 |  |  | 7.61
 | Item 5 | Type5 |  | 2.25 |  | 9 |  |  | 9.35 |  | 8.5 | 7.61
 | Item 6 | Type6 |  |  |  |  |  |  |  |  |  | 7.61
 | Item 7 | Type7 |  | 4.95
 | Item 8 | Type8 |  |  |  | 12.45
 | Item 9 | Type9 |  | 8.15 |  |  |  |  | 12 |  |  | 8.66
 | Item 10 | Type10 |  |  |  |  | 5 |  | 13 |  |  | 8.66
 | Item 11 | Type11
 | Item 12 | Type12 |  |  |  |  |  |  | 7
 | Item 13 | Type13
 | Item 14 | Type14 |  |  |  |  |  |  |  |  | 9.25
 | Item 15 | Type15 |  |  |  |  |  |  |  |  | 8.5
 | Item 16 | Type16
 | Item 17 | Type17
 | Item 18 | Type18 |  |  |  |  |  |  |  |  | 8.5 | 8.66
 | Item 19 | Type19
 | Item 20 | Type20
 | Item 21 | Type21 |  | 8.5 |  |  |  |  |  |  | 7.5
 | Item 22 | Type22 |  | 7.95 |  | 9.95 |  |  | 9.4 |  |  | 7.61
 | Item 23 | Type23 |  |  |  |  | 12.25 |  |  | 12.25
 | Item 24 | Type24
 | Item 25 | Type25 |  | 9.5 |  |  |  |  | 10 | 7.75
Spreadsheet: 173334d1344518393-sumproduct-formula-only-counting-dates-in-column-copy-of-sumproduct-sample
Sheet: Export

 |  |  |  |  |  |  |  |  |  |  |  | LastReported
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-21 02:14:09
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:47:44
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:52:05
 |  |  |  |  |  |  |  |  |  |  |  | 2012-04-07 07:41:42
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:48:59
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:48:29
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-27 01:50:09
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:46:03
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-31 10:21:11
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:48:51
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-16 11:55:07
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-16 11:26:15
 |  |  |  |  |  |  |  |  |  |  |  | 2012-01-08 13:36:53
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 12:53:01
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-22 01:59:09
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-05 11:01:45
 |  |  |  |  |  |  |  |  |  |  |  | 2012-01-08 18:56:42
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-23 11:11:46
 |  |  |  |  |  |  |  |  |  |  |  | 2012-05-29 08:42:05
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-23 10:40:40
 |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 08:19:52
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-23 10:25:30
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-23 10:50:21
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-03 15:15:01
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-01 20:12:31
 |  |  |  |  |  |  |  |  |  |  |  | 2012-10-02 10:33:42
 |  |  |  |  |  |  |  |  |  |  |  | 2012-01-31 12:56:32
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:32:25
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:50:57
 |  |  |  |  |  |  |  |  |  |  |  | 2012-02-22 03:51:06
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-03 12:24:10
 |  |  |  |  |  |  |  |  |  |  |  | 2012-07-03 15:07:48
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:32:55
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:21:43
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 10:29:18
 |  |  |  |  |  |  |  |  |  |  |  | 2012-03-27 04:04:50
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-19 02:55:57
 |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 12:47:11
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-03 09:55:19
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-21 03:34:52
 |  |  |  |  |  |  |  |  |  |  |  | 2012-04-18 09:08:10
Spreadsheet: 575529d1527579127-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-1-ans1_v3
Sheet: Rent Roll

 |  |  | CPI regulation | CPI
 |  | Tenant 1 | 1 | 1
 |  | [NAME] | 2 | 0.5
 |  | Tenant 3 | 3 | 0.75
 |  | Inflation
 |  | Year | 2018
 |  |  | 0.01 | 0.02 | 0.03 | 0.02 | 0.05
 |  | Correct answer annually
 |  | Tenant 1
 |  | Accummulated
 |  | [NAME]
 |  | Accummulated | 1 |  |  |  | 1.0405785075
 |  | Tenant 3
 |  | Accummulated | 1 |  |  | 1.04562128125 | 1.04562128125
 |  | Comments: Some tenants only get the CPI indexed 50 % or 75% or whatever below 100% depending on lease contract. I would like to capture this on a quarterly basis, I.e how you did it on the tab "income calc", but reflecting the CPI (between 0 and 100%)
Spreadsheet: 750738d1633614667-how-to-add-new-column-with-vlookup-formula-in-powerquery-connection-pq-vlookup-aligw
Sheet: Supporting

Town | Postcode
Town 1 | Post code 1
Town 2 | Post code 2
Town 3 | Post code 3
Town 4 | Post code 4
Town 5 | Post code 5
Town 6 | Post code 6
Town 7 | Post code 7
Town 8 | Post code 8
Town 9 | Post code 9
Town 10 | Post code 10
Town 11 | Post code 11
Spreadsheet: 373110d1422328032-remove-blanks-from-a-list-and-sort-automatically-tlist
Sheet: Raw

Associate | Title | Supervisor | Helper
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
Britney Chitwood | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
Terrence Reese | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] May | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Technician | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Assistant Manager | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Manager | [NAME]
[NAME] | Assistant Manager | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Market Supervisor | [NAME]
[NAME] | Market Supervisor | [NAME]
Kermit Frog | Manager | [NAME]
Spreadsheet: 35825464-5fed-4738-8ee9-b8d11ef37ef5
Sheet: DiplodocusUSNM2673

 | L1 | L2 | Ratio | Area | Scratch Length | Scratch Breadth
SCRATCHES | 865.294025700249 | 2.76708752967307
 | 887.0351194161256 | 6.456537569237164
 | 235.23137510544 | 1.844725019782047
 | 687.2219706048959 | 5.534175059346141
 | 344.6230736783081 | 2.916766359605219
 | 305.6194973545452 | 2.76708752967307
 | 341.6341587044868 | 3.325625323977746
 | 272.6607171435419 | 2.76708752967307
 | 285.2621358623654 | 2.916766359605219
 | 349.8867628707769 | 4.124930544027301
 | 200.9480564471942 | 2.76708752967307
 | 189.9462213329381 | 2.76708752967307
 | 236.0563360133283 | 3.689450039564094
 | 193.0582072608534 | 3.325625323977746
 | 319.1587540105854 | 5.534175059346141
 | 158.0930418221821 | 2.76708752967307
 | 143.8323710635025 | 2.76708752967307
 | 253.3929758319498 | 4.96707412768539
 | 137.3669998955053 | 2.76708752967307
 | 215.108305610216 | 4.611812549455117
 | 198.4130182128137 | 4.611812549455117
 | 285.7270042677978 | 7.378900079128188
 | 158.8633874393042 | 4.124930544027301
 | 196.4264032645274 | 5.534175059346141
 | 89.85344829611118 | 2.76708752967307
 | 132.7208822145346 | 4.611812549455117
 | 165.9765643979492 | 6.456537569237164
 | 95.75260187825003 | 3.91325271273712
 | 70.60743752582631 | 2.916766359605219
 | 100.4020296273043 | 4.611812549455117
 | 93.93618026934779 | 4.611812549455117
 | 86.29390189786331 | 4.611812549455117
 | 59.29722164118359 | 3.689450039564094
 | 180.2198157721073 | 12.40911844318914
 | 61.07822975067364 | 4.611812549455117
 | 72.73224638796087 | 5.610512114516938
 | 68.559522409946 | 6.456537569237164
PITS/GOUGES | 15.01497382308421 | 33.25625323977746
 | 7.02450359668519 | 12.91307513847433
 | 7.934462324208406 | 5.217670283649494
 | 6.456537569237164 | 9.223625098910235
 | 53.56854038171822 | 71.45184637582477
 | 5.534175059346141 | 7.378900079128188
 | 3.689450039564094 | 4.611812549455117
 | 12.94597474628837 | 15.6801626681474
 | 7.378900079128188 | 6.456537569237164
 | 9.269628501989672 | 8.352347764042301
 | 44.61794575265401 | 49.17152517679633
 | 10.14598760880126 | 9.223625098910235
 | 28.09801438674076 | 30.15716380942493
 | 3.689450039564094 | 3.689450039564094
 | 5.534175059346141 | 5.534175059346141
Spreadsheet: 44546d1243331020-automatic-week-commence-date-needed-weekly-business-master-main
Sheet: Head Office Use

 | OCTOBER [NAME]
 | [NAME] |  |  |  |  | Week Commencing |  | 1900-01-01 00:00:00
TAKINGS | MON | TUES | WED | THU | FRI | SAT | SUN | TOTAL
WET BAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL WET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TOTAL A
OTHER SALES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
OTHER TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TOTAL B
DEPOSITS |  |  |  |  |  |  |  | 0
GAME MACHINE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DOOR INCOME | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
C/ROOM INCOME | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OTHER |  |  |  |  |  |  |  | 0 | TOTAL C
TOTAL TAKINGS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TOTAL D
EXPENDITURE |  |  | TOTAL |  | BANKING
 |  |  |  |  | DAY | DATE | SLIP NO | CASH | PDQ
 |  |  |  |  | MON |  | 0 | 0 | 0
 |  |  |  |  | TUES |  | 0 | 0 | 0
 |  |  |  |  | WED |  | 0 | 0 | 0
 |  |  |  |  | THUR |  | 0 | 0 | 0
 |  |  |  |  | FRI |  | 0 | 0 | 0
 |  |  |  |  | SAT |  | 0 | 0 | 0
TOTAL EXPENDITURE - TOTAL E |  |  | 0 |  | SUN |  | 0 | 0 | 0
METER  READINGS
 |  | READING | COSTS
METER  READ | PRESENT |  | 0.1131
2009-03-10 00:00:00 | PREVIOUS | 905147
 | USED | -905147 | -102372.1257 |  | TOTAL |  |  | 0 | 0 | 0
CHARGES | CHARGE P/D | 31.955 | 0.31955 |  | TOTAL F |  |  | 0
 | DAYS | -39882 | -12744.2931
 | TOTAL |  | -115116.4188 |  | RECONCILIATION
METER 3 | PRESENT |  |  |  | TOTAL D | 0 |  | TOTAL E | 0
 | PREVIOUS
 | USED
 |  |  |  |  |  |  |  | TOTAL F | 0
OPENING FLOAT |  |  |  |  | TOTAL | 0 |  | TOTAL | 0
CLOSING FLOAT |  |  |  |  | THESE TWO AMOUNTS SHOULD BALANCE
MANAGERS NAME |  |  |  | MANAGERS SIGNATURE |  |  |  |  | DATE
Spreadsheet: 86268d1286290091-multiple-sheets-with-same-data-arranged-differently-2010-2012-roster-copy
Sheet: By Birthday

BD | Last Name | First Name | Street Address | City | State | ZIP | Home Phone | Work Phone | Cell Phone | eMail Address | Alternate eMail Address
2010-01-06 00:00:00
2010-01-08 00:00:00
2010-01-08 00:00:00
2010-01-10 00:00:00
2010-01-14 00:00:00
2010-01-21 00:00:00
2010-01-21 00:00:00
2010-01-23 00:00:00
2010-01-26 00:00:00
2010-01-27 00:00:00
2010-02-02 00:00:00
2010-02-08 00:00:00
2010-02-09 00:00:00
2010-02-12 00:00:00
2010-02-16 00:00:00
2010-02-21 00:00:00
2010-02-23 00:00:00
2010-02-24 00:00:00
2010-02-27 00:00:00
2010-02-27 00:00:00
2010-03-04 00:00:00
2010-03-08 00:00:00
2010-03-09 00:00:00
2010-03-10 00:00:00
2010-03-14 00:00:00
2010-03-22 00:00:00
2010-03-25 00:00:00
2010-03-27 00:00:00
2010-04-11 00:00:00
2010-04-12 00:00:00
2010-04-13 00:00:00
2010-04-14 00:00:00
2010-04-17 00:00:00
2010-04-22 00:00:00
2010-04-23 00:00:00
2010-04-25 00:00:00
2010-04-26 00:00:00
2010-05-08 00:00:00
2010-05-13 00:00:00
2010-05-23 00:00:00
2010-05-27 00:00:00
2010-06-07 00:00:00
2010-06-14 00:00:00
2010-06-14 00:00:00
2010-06-14 00:00:00
2010-06-26 00:00:00
2010-07-01 00:00:00
2010-07-02 00:00:00
2010-07-03 00:00:00
2010-07-07 00:00:00
2010-07-11 00:00:00
2010-08-02 00:00:00
2010-08-03 00:00:00
2010-08-03 00:00:00
2010-08-05 00:00:00
2010-08-08 00:00:00
2010-08-09 00:00:00
2010-08-11 00:00:00
2010-08-24 00:00:00
2010-08-27 00:00:00
2010-08-28 00:00:00
2010-09-01 00:00:00
2010-09-05 00:00:00
2010-09-05 00:00:00
2010-09-13 00:00:00
2010-09-13 00:00:00
2010-09-19 00:00:00
2010-09-20 00:00:00
2010-09-20 00:00:00
2010-09-22 00:00:00
2010-09-23 00:00:00
2010-09-24 00:00:00
2010-09-29 00:00:00
2010-09-29 00:00:00
2010-10-01 00:00:00
2010-10-04 00:00:00
2010-10-13 00:00:00
2010-10-28 00:00:00
2010-10-30 00:00:00
2010-10-30 00:00:00
2010-11-04 00:00:00
2010-11-05 00:00:00
2010-11-07 00:00:00
2010-11-07 00:00:00
2010-11-10 00:00:00
2010-11-15 00:00:00
2010-11-23 00:00:00
2010-12-01 00:00:00
2010-12-07 00:00:00
2010-12-08 00:00:00
2010-12-08 00:00:00
2010-12-09 00:00:00
2010-12-11 00:00:00
2010-12-12 00:00:00
2010-12-17 00:00:00
2010-12-20 00:00:00
2010-12-20 00:00:00
2010-12-27 00:00:00
2010-12-27 00:00:00
2010-12-29 00:00:00
2010-12-31 00:00:00
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: Oasis

POI  8516
 | Scheduled | Measured | Imbal
1 | 5594 | 5629
2 | 1579 | 0
3 | 1579
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  | 67259
 | 2000-12-03 00:00:00
Spreadsheet: 851553d1701770693-how-to-write-a-macro-excel-2010-example
Sheet: SHORT EXAMPLE for 1 line

EXAMPLE
INPUT Datas FOR 1 LINE |  |  |  | LEFT |  | RIGHT
 |  |  | N number of terms [NAME] | 1st | 2nd | 1st | 2nd
1.LINE |  | N | 2 | 7 | 25 | 9 | 22
 |  |  |  |  | number of terms [NAME] is always the same for both integers |  |  | number of terms RIGHT is also (2+2)=4
 |  |  |  |  | (in the example 2 for both) |  |  | BUT for 1st integer NUMBER OF TERMS is N-1 (in example 2-1=1)
 |  |  |  |  |  |  |  | AND for second integer NUMBER OF TERMS is N+1 (in example 2+1=3)
 |  | RESULT HAS TO BE:
 |  |  |  | LEFT |  | RIGHT
 |  |  | 2 terms | 7 |  | 9 | 1 term
 |  |  |  | 8 |  | 22
 |  |  | 2 terms | 25 |  | 23 | 3 terms
 |  |  |  | 26 |  | 24
 |  |  |  | and then continue for next lines
Spreadsheet: 542065d1507704157-filter-based-on-multiple-rows-for-the-same-data-jobs
Sheet: Report

 | Importance | Person
 | Job | [NAME] | [NAME] | [NAME] | [NAME]
 | Job 1 | 1 | 2 | 3 | 4
 | Job 2 | 1 |  | 2
 | Job 3 |  |  | 1 | 2
 | Job 4 |  |  |  | 1
 | Job 5 | 2 | 1