tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2296__DecCohCHOICE-ENA
Sheet: Dec 14

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-14 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1429 |  | 1298 |  | 67694 |  |  |  |  |  | 19 | 1 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 2 | 25
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 6433 |  | 5788 |  | 67694 |  |  |  |  |  | 20 | 3 | 24
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 20 | 4 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 5 | 27
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2521 |  | 2392 |  | 67694 |  |  |  |  |  | 21 | 6 | 25
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 20 | 7 | 23
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 23 | 8 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 9 | 29
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 17686 |  | 17033 |  | 67694 |  |  |  |  |  | 26 | 15 | 34
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 20 | 35 | 30
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68915 | 0 |  |  |  |  | 20 | 39 | 25
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1952 |  | 1751 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1373 |  | 1296 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.55
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 14143 |  | 14143 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2240 |  | 2240 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4264 |  | 4264 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5323 |  | 5179 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 820 |  | 664 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 47 |  | 46 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 30982091-aad7-4434-a930-f3939bc52800
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  |  | Ending
Aug. 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 |  |  |  | 1,000 short tons
2010/11 | 341.601 | 6098.1 | 0 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/121 | 617.563 | 5370 | 100 | 6087.563 |  | 2400 | 160 | 3097.563 | 5657.563 | 430
2012/132 | 430 | 5985 | 0 | 6415 |  | 2500 | 300 | 3115 | 5915 | 500
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-05-14 15:00:41.420000
Spreadsheet: 864657d1711735457-need-help-with-2-row-header-worksheet-monthly-asset-listing-excel-data-nxt2-1-
Sheet: Table2

Asset No. Asset ID | Description Class | Location Department | Depr. basis In Service Date | Disposal Price Disposal Date | Accum. Depr.  Last Depr. Date | Column7
2021 | Athletic Field Turf | Athletics | 1220790.2 | 0 | 966458.9 | 254331.3
 | Athletic Fields | Athletics | 42430 |  | 45322
2022 | Athletic Field Lighting | Athletics | 344183.75 | 0 | 108991.53 | 235192.22
 | Athletic Fields | Athletics | 42430 |  | 45322
2023 | Athletic Field Fence | Athletics | 15829.95 | 0 | 6134.14 | 9695.81
 | Athletic Fields | Athletics | 42491 |  | 45322
1559 | Large Conference Room Ceiling |  | 49048.5 | 0 | 18393.2 | 30655.3
 | Building Improvements |  | 41214 |  | 45322
1560 | Roll-Up Doors / Ceramics & IT |  | 10975.28 | 0 | 4115.72 | 6859.56
 | Building Improvements |  | 41214 |  | 45322
1738 | Air Conditioning Units - Faculty |  | 78171 | 0 | 27142.7 | 51028.3
 | Building Improvements |  | 41518 |  | 45322
1750 | Generator |  | 80766.77 | 0 | 40046.88 | 40719.89
 | Building Improvements | Operations | 41699 |  | 45322
1860 | LED Outdoor Parking Fixtures | Parking Lot | 9300 | 0 | 2919.16 | 6380.84
 | Building Improvements | Operations | 41883 |  | 45322
1871 | Admin Office Remodel | [NAME] | 4292 | 0 | 1311.47 | 2980.53
 | Building Improvements | Administrative | 41974 |  | 45322
1872 | Drinking Fountain | Athletics | 5951 | 0 | 3636.7 | 2314.3
 | Building Improvements | Athletics | 41974 |  | 45322
1873 | Amphitheater | Amphitheater | 133729.96 | 0 | 40490.46 | 93239.5
 | Building Improvements | Administrative | 42005 |  | 45322
2017 | [NAME] | [NAME] | 10321.3 | 0 | 2809.66 | 7511.64
 | Building Improvements | Athletics | 42339 |  | 45322
2086 | [NAME] | Adirondack | 14864 | 0 | 10033.21 | 4830.79
 | Building Improvements | Operations | 42856 |  | 45322
2087 | ATS Switch for Generator | Parking Lot | 34342.47 | 0 | 7822.47 | 26520
 | Building Improvements | Facilities | 42826 |  | 45322
2141 | Gate - Main Entrance | Parking Lot | 65148 | 0 | 41803.3 | 23344.7
 | Building Improvements | Facilities | 42979 |  | 45322
2146 | Gym Lights | Gym | 44660 | 0 | 9428.25 | 35231.75
 | Building Improvements | Operations | 43009 |  | 45322
2158 | Ubterface Carpet Tile | A231 | 6000 | 0 | 4687.5 | 1312.5
 | Building Improvements | Facilities | 43040 |  | 45322
2239 | Monument Sign 7'-6" x 4'-7" | Parking Lot | 27546.12 | 0 | 8149.08 | 19397.04
 | Building Improvements | Facilities | 43160 |  | 45322
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -1960 | -1613 | -1385 | -2000
2 | -2106 | -1613 | -811 | -2000
3 | -2069 | -1613 | -2341 | -2000
4 | -2166 | -1613 | -2354 | -2000
5 | -2259 | -1613 | -2518 | -2000
6 | -2152 | -1613 | -2440 | -2000
7 | -2005 | -1613 | -2470 | -2000
8 | -933 | -1613 | -2314 | -2000
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-11-30 00:00:00 |  | -23543.73 |  | -127403.13 | -127925.46
2001-12-08 00:00:00
CBS Volume
 |  |  | -38489
Spreadsheet: 76014d1276611942-how-to-make-use-of-functions-like-sumif-countif-averageif-book1
Sheet: Sheet1

 | Store | Location | Sales |  |  | Location | Sum | Count | Average
 | Store1 | Overseas | 1000 |  |  | Overseas
 | [NAME] | Overseas | 5000 |  |  | Local
 | Store3 | Overseas | 10000
 | Store4 | Local | 2000
 | Store5 | Local | 3600
 | Store6 | Local | 3800
 | Store7 | Local | 3900
 | Store8 | Local | 4000
Spreadsheet: daren_farmer__5042__HPLN0417
Sheet: Sheet1

HPLN0417.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - April 17, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-04-17 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | 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: drew_fossum__8672__assumptions
Sheet: TW

[NAME]
2001 - 2003 OPERATING & STRATEGIC PLAN
MAJOR ASSUMPTIONS
 |  |  |  |  |  |  |  |  |  |  |  |  | DRAFT
* | Regulatory
 | - | Tariff rates (including surcharges) remain in effect throughout the 3 year plan period, adjusted by Global/Mini
 |  | Settlements as follows:
 |  | - | Cost escalation based on GDP for Current Customers assumed at 2%
 |  |  | reduced by $0.003 per MMBtu/day for years 2001-2002.
 |  | - | TCR II Reservation surcharge - $1.4MM filed for collection during 1996 and collected over 10 years;
 |  | - | Shared cost surcharge in effect 1/1/97 through 10/31/01.
* | Mini Settlement Amortization
 | - | Annual amortization expense of $2.8MM based upon Regulatory Assets per (*Mini Settlement $32MM) plus
 |  | ($600 New Mexico Royalties) amortized over remaining life of settlement (10/31/06).
* | Marketing
 | - | Phase out of shared costs surcharges during the Plan period.
 |  |  |  |  |  |  |  |  | 2000 |  | 2001 |  | 2002 |  | 2003
 |  | [NAME] revenue turnback |  |  |  |  |  |  | -56.4 |  | -56.4 |  | -56.4 |  | -56.4
 |  | Shared cost surcharges |  |  |  |  |  |  | 11.8 |  | 9.8 |  | 0 |  | 0
 |  | Revenue Shortfall
 | - | San Juan Lateral and West capacity is assumed to be _______  subscribed.
 | - | East capacity is assumed to be ____% subscribed.
 | - | Maximize utilization of West capacity to increase net fuel retainage.
 | - | Hook up with 2 new power plant loads - early 2001.
 | - | Southwest Gas interconnect to rapidly growing Nevada market.
* | Major Expansion Projects
* | Asset Rationalization
 | - | Aggressively pursue asset rationalizations and monetizations.
* | Work towards reducing overhead rate on capital construction projects to 10%.
* | O&M is essentially flat throughout the plan adjusted for asset sales, new facilities, power costs (electric compression),
 | capital projects designed to reduce O&M and subject to structural changes in compensation plan.
* | All capital projects divided between Non-Discretionary & Discretionary.  All Discretionary projects are ranked.
* | Navajo ROW issue:
 | - | negotiate extension of existing ROW through 2009 to synchronize all expirations
 | - | financial impacts (cash, amortization expense) ?
* | UAF improved from ___% to ___ %.
* | Continuous improvement objectives are incorporated in O&M and Capital Plan.
Spreadsheet: andy_zipper__112__mODEL 3 7 01 Base
Sheet: Description

 | TDF
 | Source of  Value | Revenue Type | Revenue Source | Revenue Capturer | Estimated Amount | Notes
 | Lowering of Counterparties' Transaction Costs through diminution of manual entry tasks and errors | Per transaction fee | SPV counterparties | SPV counterparties | Total of $4.6 per transaction                                                                              $2.5 per transaction for diminution of manual entry ($25 per hour fully loaded, 10 deal entries per hour), similar to marginal cost for the same task in back office.  Estimate of the cost of bad quality is $ 60 to fix a mistake, 2-5 % errors, equivalent to $2.1 per transaction | Value comes from integration of the data stream into the counterparties back office system
 | Diminution of risk of decisions based on wrong data | Avoided  per transaction Cost | SPV counterparties | SPV counterparties | Risk is proportional to number of transactions with errors divided by the probability of the error being costly. Assume 1 % of transactions lead to mistakes of an average of $10'000. Estimated Cost is $3.5
 | Option to integrate the platform to other systems, further downsizing the capture module | Avoided Cost | SPV counterparties | SPV counterparties | Not considered initially in the model
 | Diminution of liability of person managing the back office function |  | SPV Counterparties | SPV Counterparties | A solution within the spending limits of the decision maker could be made in some of the counterparties. A solution worth $ 100,000 could be easily justified in the IT budget. | This subjective factor my allow the sale of the solution without it making sense for the counterparty
 | Cost of the platform | TBD | Third parties | Enron | 1/2 of the cost of the platform | If the platform can be used for different purposes its cost can be split among the different applications
 | Additional revenues from  IT or process improvements |  | SPV Counterparties | Consulting partner | Cost of creating a relationship with a potential customer. $ 50,000 per partner company based on the salary of a sales rep for 6 months
 | Transfer of value | Revenue Type | Revenue Source | Revenue Capturer | Estimated Amount | Notes
 | Consulting partner fee | One time fee | Consulting Partner | Enron | Consulting partner may pay up to 20% of the revenue it receives for the opportunity
 | Revenues from integration | One time fee | SPV Counterparties | Consulting Partner | $ 200 *  1 week * 50 hours per week * 2 consultants = $ 40,000
 | Subscription fee | Monthly fee or per transaction fee | SPV Counterparties | SPV | TBD
 | Note:     this spreadsheet intends to describe the value drivers rather than allocate them to a specific party. Value can be allocated to the parties once the deal is structured
 |  |  | 0.106
Spreadsheet: 202313d1356501964-email-to-multiple-people-in-a-sheet-email8
Sheet: Eager, Mr. George

Authoriser | Invoice entry date | Inv Type code | Supplier name | Supplier site | invoice Date | Invoice number | invoice tax ant | invoice net amount | Invoice gross amount | Voucher number | invoice status | Pay group | Terms | Created By | Created by employee
Eager, Mr. [NAME] | 2008-06-04 00:00:00 | STANDARD | GPT Plant & Tool Hire | CO SLIGO | 2007-12-21 00:00:00 | 114061 | 37.8 | 180 | 217.8 | 341460 | Needs Revalidation | EUR AP | Tesco Terms | UY71 | Ryan, Mr. [NAME]
Eager, Mr. [NAME] | 2008-06-04 00:00:00 | STANDARD | Cannon Hygienic Products Ire Ltd | FACTOR-CANNON H | 2008-05-26 00:00:00 | OPI038109 | 14.7 | 70 | 84.7 | 341563 | Needs Revalidation | EUR AP | 30 Days | UF93 | Talbot, Ms. [NAME]
Eager, Mr. [NAME] | 2008-05-23 00:00:00 | STANDARD | McConnells Advertising | DUBLIN 4 | 2008-04-28 00:00:00 | 292824 | 190.24 | 905.91 | 1096.15 | 340162 | Needs Revalidation | EUR AP | 30 Days | OX34
Eager, Mr. [NAME] | 2008-05-29 00:00:00 | STANDARD | Spectre Electronics Ltd | DUBLIN 14 | 2008-05-25 00:00:00 | 1655 | 52.11 | 386 | 438.11 | 341132 | Needs Revalidation | EUR AP | 30 Days | OX34
Eager, Mr. [NAME] | 2008-05-29 00:00:00 | STANDARD | Cobra Couriers | DUBLIN 7 | 2008-04-30 00:00:00 | 33069 | 27.21 | 129.6 | 156.81 | 341102 | Needs Revalidation | EUR AP | 30 Days | OX34
Spreadsheet: 793657d1661615776-formula-to-find-starting-and-ending-row-numbers-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Expected Results
 |  |  |  |  |  |  |  | Starting Row Number | Ending Ro Number
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  | 4 | 7 | 2022-08-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  | 8 | 9 | 2022-08-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  | 10 | 12 | 2022-08-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  | 13 | 13 | 2022-08-02 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | -1 |  |  | 14 | 18 | 2022-08-02 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | -1 |  |  | 19 | 22 | 2022-08-02 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  | 23 | 23 | 2022-08-03 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  | 24 | 27 | 2022-08-03 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | 1
 |  |  |  | 2022-08-03 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | -1
Spreadsheet: 132028d1323446040-get-name-from-other-sheet-examples
Sheet: Name list

Names
Name 1
Name 2
Name 3
Name 4
Name 5
Name 6
Name 7
Name 8
Name 9
Name 10
Name 11
Name 12
Name 13
Name 14
Name 15
Name 16 |  |  | Name
Name 17
Name 18
Name 19
Name 20
Spreadsheet: 880179d1727796974-rolling-count-of-all-the-overlapping-days-for-multiple-date-ranges-example-1-4
Sheet: Sheet1

Range# (A) | Start Date (B) | End Date (C) | Expected count (D) | Current Duration (F) |  | Windknife |  | Dynamic range
1 | 2024-06-01 00:00:00 | 2024-06-03 00:00:00 | 2
2 | 2024-06-04 00:00:00 | 2024-06-10 00:00:00 | 8 |  |  | 8
3 | 2024-06-22 00:00:00 | 2024-06-29 00:00:00 | 15 |  |  | 15
4 | 2024-07-05 00:00:00 | 2024-07-15 00:00:00 | 17 |  |  | 19
5 | 2024-07-16 00:00:00 | 2024-07-25 00:00:00 | 23 |  |  | 25
6 | 2024-07-28 00:00:00 | 2024-08-05 00:00:00 | 26 |  |  | 26
7 | 2024-08-20 00:00:00 | 2024-08-23 00:00:00 |  |  |  | 13
8 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 |  |  |  | 13
9 | 2024-08-23 00:00:00 | 2024-08-28 00:00:00 |  |  |  | 16
10 | 2024-09-20 00:00:00 | 2024-09-23 00:00:00 |  |  |  | 8
11 | 2024-09-22 00:00:00 | 2024-09-24 00:00:00 |  |  |  | 8
12 | 2024-07-01 00:00:00 | 2024-07-03 00:00:00 |  |  |  | 15
Spreadsheet: 807003d1669711378-googlesheets-schedule-checker-sample-workbook-1-1-
Sheet: Sheet1

 | [NAME] | Erin 05 | Ivy 10 | [NAME] | Kristie 02 | Leo 13
 | _ | _ | _ | _ | _ | _ |  |  |  |  |  |  | _1M_M | _1M_P | _1S_M | _1S_P | _1S_O
 | ADMIN | ADMIN | ADMIN | ADMIN | ADMIN | ADMIN |  |  |  |  |  | 1Textbook! | [NAME] |  |  | Ivy 10
 |  |  |  |  |  |  |  |  |  |  |  | 1Vocab! | [NAME] |  |  | Ivy 10
☼ 02:30 03:15 | _2MI | _2S_M | _1S_P | _1M_M | _2I_M | _1I_M |  |  |  |  |  | 1Science!
 | 2GrammarRACHEL | 2Grammar! | 1Textbook! | 1Textbook! | 2Grammar! | 1Textbooky! |  |  |  |  |  | 1Writing!
 |  |  |  |  |  |  |  |  |  |  |  | 1Grammar!
5m | _ | _ | _ | _ | _ | _ |  |  |  |  |  | 1Novel!
☼ 03:20 04:05 | _2MI | _2S_M | _1S_P | _1M_M | _2I_M | _1I_M
 | 2WritingRACHEL | 2Writing! | 1Vocab! | 1Vocab! | 2Writing! | 1Vocaby!
10m | _ | _ | _ | _ | _ | _
04:15 05:00 | _3M_P | _3S_M | _4S_M | _3I_P | _2I_P | _3S_P
 | 3Textbook! | 3TEDTalksRACHEL | 4TEDTalks! | 3Novely! | 2Grammar! | 3Grammar!
5m | _ | _ | _ | _ | _ | _
05:05 05:50 | _3M_P | _4S_P | _3S_O | _3I_P | _2I_P | _2M_P
 | 3Speech! | 4Textbook! | 3Textbook! | 3Writing! | 2Writing! | 2GrammarRACHEL
5m | _ | _ | _ | _ | _ | _
Spreadsheet: 37366d1235360827-excel-macro-group-by-then-sum-example
Sheet: Sheet1

ID | Date | Price
1456 | 2008-03-01 00:00:00 | 651.47
1456 | 2008-03-01 00:00:00 | 731.46
1457 | 2008-03-01 00:00:00 | 55
1457 | 2008-03-01 00:00:00 | 6
1458 | 2008-03-01 00:00:00 | 43.92
1458 | 2008-03-01 00:00:00 | 1892.45
1458 | 2008-03-01 00:00:00 | 6852.33
1459 | 2008-03-01 00:00:00 | 7098
1459 | 2008-03-01 00:00:00 | 8408.1
14510 | 2008-04-01 00:00:00 | 9766.1
14511 | 2008-04-01 00:00:00 | 780.64
14511 | 2008-04-01 00:00:00 | 7251.62
Spreadsheet: 39021d1237236481-copy-results-from-adjacent-cells-from-one-workbook-to-another-book1
Sheet: Sheet1

Product-1 | 2.33 | Product-41 | 4.77 | Product-81 | 4.77
Product-2 | 4.55 | Product-42 | 8.66 | Product-82 | 8.66
Product-3 | 4.77 | Product-43 | 12.55 | Product-83 | 12.55
Product-4 | 8.66 | Product-44 | 16.44 | Product-84 | 16.44
Product-5 | 4.66 | [NAME] | 20.33 | Product-85 | 20.33
Product-6 | 9.88 | Product-46 | 24.22 | Product-86 | 24.22
Product-7 | 5.12 | Product-47 | 28.11 | Product-87 | 28.11
Product-8 | 6.9 | Product-48 | 32 | Product-88 | 32
Product-9 | 4.22 | Product-49 | 35.89 | Product-89 | 35.89
Product-10 | 4.66 | Product-50 | 39.78 | Product-90 | 39.78
Product-11 | 7.23 | Product-51 | 43.67 | Product-91 | 9.88
Product-12 | 3.64 | [NAME] | 47.56 | Product-92 | 5.12
Product-13 | 4.78 | [NAME] | 51.45 | Product-93 | 6.9
Product-14 | 8.66 | Product-54 | 55.34 | Product-94 | 8.68
Product-15 | 8.09 | Product-55 | 16.44 | Product-95 | 10.46
Product-16 | 7.52 | Product-56 | 35.89 | Product-96 | 12.24
Product-17 | 6.95 | Product-57 | 55.34 | Product-97 | 14.02
Product-18 | 6.38 | Product-58 | 74.79 | Product-98 | 15.8
Product-19 | 5.81 | Product-59 | 94.24 | Product-99 | 17.58
Product-20 | 5.24 | Product-60 | 113.69 | Product-100 | 19.36
Product-21 | 4.67 | Product-61 | 133.14 | Product-101 | 21.14
Product-22 | 4.1 | Product-62 | 152.59 | Product-102 | 22.92
[NAME] | 3.53 | Product-63 | 172.04 | Product-103 | 24.7
Product-24 | 2.96 | Product-64 | 191.49 | Product-104 | 26.48
Product-25 | 2.39 | Product-65 | 210.94 | Product-105 | 28.26
Product-26 | 1.82 | Product-66 | 230.39 | Product-106 | 30.04
Product-27 | 1.25 | Product-67 | 249.84 | Product-107 | 31.82
Product-28 | 3.05 | Product-68 | 269.29 | Product-108 | 33.6
Product-29 | 5.12 | Product-69 | 39.78 | Product-109 | 35.38
Product-30 | 9.88 | Product-70 | 43.67 | Product-110 | 37.16
Product-31 | 14.64 | [NAME] | 47.56 | Product-111 | 38.94
Product-32 | 19.4 | Product-72 | 51.45 | Product-112 | 40.72
Product-33 | 24.16 | Product-73 | 55.34 | Product-113 | 42.5
Product-34 | 28.92 | Product-74 | 59.23 | Product-114 | 44.28
Product-35 | 33.68 | Product-75 | 63.12 | Product-115 | 46.06
Product-36 | 38.44 | Product-76 | 67.01 | Product-116 | 47.84
Product-37 | 43.2 | Product-77 | 70.9 | Product-117 | 49.62
Product-38 | 47.96 | Product-78 | 74.79 | Product-118 | 51.4
Product-39 | 52.72 | Product-79 | 78.68 | Product-119 | 53.18
Product-40 | 57.48 | [NAME] | 82.57 | Product-120 | 54.96
Spreadsheet: 782122d1653812825-aged-debtor-report-formatting-question-aged-debtor-formatting
Sheet: Aim

Aged Debtor Report
 | Debtor | Invoice No | Date | Total | Period 1 | Period 2 | Period 3
 | Debtor ABC1 | Inv-001 | 2022-05-24 00:00:00 |  | 35 | 41 | 1
 | Debtor ABC1 | Inv-002 | 2022-05-26 00:00:00 |  | 21 | 37 | 28
 | Debtor ABC1 | Inv-003 | 2022-05-29 00:00:00 |  | 27 | 3 | 22
 | [NAME] | Inv-001 | 2022-05-22 00:00:00 |  | 44 | 17 | 50
 | [NAME] | Inv-002 | 2022-05-27 00:00:00 |  | 3 | 15 | 15
 | Debtor ABC3 | Inv-001 | 2022-05-27 00:00:00 |  | 12 | 36 | 8
 | [NAME] | Inv-001 | 2022-05-27 00:00:00 |  | 40 | 41 | 29
 | [NAME] | Inv-002 | 2022-05-24 00:00:00 |  | 31 | 27 | 50
 | Debtor ABC5 | Inv-001 | 2022-05-22 00:00:00 |  | 15 | 23 | 16
 | Debtor ABC5 | Inv-002 | 2022-05-29 00:00:00 |  | 43 | 48 | 9
 | Debtor ABC5 | Inv-003 | 2022-05-23 00:00:00 |  | 23 | 20 | 18
 | Debtor ABC6 | Inv-001 | 2022-05-26 00:00:00 |  | 45 | 50 | 43
 | Debtor ABC6 | Inv-002 | 2022-05-23 00:00:00 |  | 1 | 47 | 24
 | [NAME] | Inv-001 | 2022-05-22 00:00:00 |  | 19 | 35 | 32
 | [NAME] | Inv-002 | 2022-05-28 00:00:00 |  | 46 | 20 | 42
 | [NAME] | Inv-003 | 2022-05-29 00:00:00 |  | 3 | 45 | 4
 | Debtor ABC8 | Inv-001 | 2022-05-27 00:00:00 |  | 19 | 32 | 49
 | Debtor ABC9 | Inv-001 | 2022-05-23 00:00:00 |  | 10 | 39 | 3
 | Debtor ABC9 | Inv-002 | 2022-05-25 00:00:00 |  | 24 | 39 | 34
 | Debtor ABC9 | Inv-003 | 2022-05-26 00:00:00 |  | 41 | 15 | 21
 | [NAME] | Inv-001 | 2022-05-25 00:00:00 |  | 4 | 4 | 42
 | [NAME] | Inv-002 | 2022-05-27 00:00:00 |  | 35 | 28 | 23
 | [NAME] | Inv-003 | 2022-05-27 00:00:00 |  | 13 | 44 | 34
 | [NAME] | Inv-004 | 2022-05-25 00:00:00 |  | 10 | 39 | 3
 | [NAME] | Inv-005 | 2022-05-27 00:00:00 |  | 24 | 39 | 34
 | [NAME] | Inv-006 | 2022-05-27 00:00:00 |  | 41 | 15 | 21
 | [NAME] | Inv-007 | 2022-05-25 00:00:00 |  | 75 | 93 | 58
 | [NAME] | Inv-008 | 2022-05-27 00:00:00 |  | 45 | 50 | 43
 | [NAME] | Inv-009 | 2022-05-27 00:00:00 |  | 1 | 47 | 24
 | [NAME] | Inv-010 | 2022-05-25 00:00:00 |  | 46 | 97 | 67
 | [NAME] | Inv-011 | 2022-05-27 00:00:00 |  | 41 | 15 | 21
 | [NAME] | Inv-012 | 2022-05-27 00:00:00 |  | 75 | 93 | 58