tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a4e82ce4-e5dd-40a1-ae7c-a1826ed38dc7
Sheet: Table 7.2

Monthly Statistical Bulletin
7.2 Components of population change
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Births – '000
September | 76.5 | 76.3 | 76.2 | 80.7 | 79.8
December | 75.5 | 72.5 | 74.2 | 73.3
March | 76 | 76 | 78.1 | 77.2
June | 76 | 76.3 | 77.5 | 80.2
Annual | 302.9 | 301.1 | 306 | 311.4
Deaths – '000
September | 38 | 38.5 | 39.6 | 43.1 | 40.5
December | 35 | 35.8 | 36.1 | 33.1
March | 32.7 | 33.8 | 34.1 | 35.9
June | 35.8 | 37.4 | 37.5 | 36.7
Annual | 141.5 | 145.5 | 147.3 | 148.8
Natural increase – '000
September | 38.5 | 37.8 | 36.6 | 37.5 | 39.3
December | 40.5 | 36.6 | 38.2 | 40.2
March | 43.2 | 42.3 | 44.1 | 41.4
June | 40.3 | 39 | 40 | 43.5
Annual | 162.5 | 155.7 | 158.9 | 162.6
Net overseas migration (a) – '000
September | 62.5 | 41.8 | 55.4 | 64.6 | 61.2
December | 41.7 | 38.4 | 50.1 | 54.2
March | 59.9 | 61 | 72.8 | 73.4
June | 32 | 39.2 | 51.2 | 52.2
Annual | 196.1 | 180.4 | 229.5 | 244.4
(a) From September 2006 the ABS introduced an improved methodology for estimating
net overseas migration. These data are not comparable with earlier data.
 |  |  |  |  |  |  |  | Update
Source: ABS, Australian demographic statistics, Cat. no. 3101.0 | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3101.0&viewtitle=Australian%20Demographic%20Statistics~Sep%202007~Latest~19/03/2008&&tabname=Past%20Future%20Issues&prodno=3101.0&issue=Sep%202007&num=&view=& |  |  |  | 2014-06-19 00:00:00
Spreadsheet: 01eaf3d6-c3cc-4e4c-9491-db85bb7c8e5e
Sheet: Sheet1

Contract Number | [NAME] | Project Name | Start Date | Exp. Date | Project Amount / Annual Amount
12-CV-47 | Daktronicks, Inc. | City Center/Event Center Electronic Marquee | 2012-08-20 00:00:00 | 2012-12-18 00:00:00 | 293632.94
12-PW-66 | RMCI, Inc. | Advanced Water Treatment Facility Phase I | 2012-07-09 00:00:00 | 2013-03-06 00:00:00 | 1857203.62
12-UT-70 | Narasimhan Consulting Services, Inc. | Capital Improvement Program for Wastewater | 2012-07-26 00:00:00 | 2012-07-25 00:00:00 | 48560
12-PW-72 | H.O. Construction, Inc. | [NAME] | 2012-08-13 00:00:00 | 2012-10-27 00:00:00 | 205218
13-PW-03 | G. Sandoval Construction, Inc. | [NAME] Sage Trail Improvements | 2012-08-06 00:00:00 | 2012-10-20 00:00:00 | 289465.99
13-FS-04 | Bureau of of Business and Economic Research (BBER) | FY 13 - Subscriber Agreement | 2012-07-13 00:00:00 | 2013-06-30 00:00:00 | 6000
13-PR-08 | Industrial and Commercial Security Systems, Inc. (ICSS) | Alarm System for Star Heights | 2012-07-01 00:00:00 | 2013-06-30 00:00:00 | $5,150.00 initial fee and $128 per month thereafter
13-PD-10 | Advanced Communications and Electronics, Inc. | Maintenance of Motorola Equipment for Dispatch Center | 2012-07-01 00:00:00 | 2013-06-30 00:00:00 | 33943.2
13-PD-11 | Goserco, Inc. | Extended Warranty Plan - Voice Logging Recorder | 2012-08-01 00:00:00 | 2013-07-31 00:00:00 | 6482.34
13-FS-18 | PFM Asset Management, LLC | Investment Advisor | 2012-10-11 00:00:00 | 2014-10-10 00:00:00 | 24000
13-PW-24 | PNM Public Service Company of New Mexico | Electric Line Extension Agreement | 2012-10-08 00:00:00 | 2013-10-07 00:00:00 | 113125.62
Spreadsheet: 79136d1279391402-dynamic-range-of-values-from-formula-example-paste
Sheet: Sheet2

Number  of Transaction | Sales from Employees | Profit |  | Workers | Total Profit  for each worker |  | Workers (array) | Total profit for each worker (array) |  | postprocess |  |  | Workers | Total Profits |  | Workers  (values) | Total Profit (values)
 | waldo | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 17
 | emily | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | emily | 115
 | [NAME] | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12
 | howard | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 53
 | waldo | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | henry | 12
 | [NAME] | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | howard | 28
 | mary | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12
 | [NAME] | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | mark | 44
 | howard | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | mary | 7
 | emily | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 87
 | [NAME] | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | susan | 55
 | tom | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 48
 | tom | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | tom | 29
 | [NAME] | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | waldo | 24
 | [NAME] | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 135
 | mark | 23
 | mark | 21
 | henry | 12
 | [NAME] | 12
 | [NAME] | 36
 | [NAME] | 12
 | [NAME] | 99
 | emily | 99
 | susan | 34
 | [NAME] | 87
 | [NAME] | 53
 | susan | 21
Spreadsheet: 751231d1633984113-averageifs-filtering-first-occurrence-of-a-number-in-another-column-averageifs_criteria_filtering
Sheet: Sheet1

 |  |  |  | TYPE | MAR
 |  |  |  | year | 2020
 |  | job # | task | hrs | date completed | type
This to be considered only | --> | 121 | advance | 12 | 2020-11-05 00:00:00 | MAR | <== MAR type data completed in 2020.
 |  | 121 | drawing | 12 | 2020-11-05 00:00:00 | MAR
 |  | 121 | manufacture | 12 | 2020-11-05 00:00:00 | MAR
This to be considered only | --> | 122 | advance | 7 | 2019-11-05 00:00:00 | LSP
 |  | 122 | drawing | 7 | 2019-11-05 00:00:00 | LSP
 |  | 122 | manufacture | 7 | 2019-11-05 00:00:00 | LSP
This to be considered only | --> | 123 | proposal | 14 | 2019-11-05 00:00:00 | HSP
 |  | 123 | drawing | 14 | 2019-11-05 00:00:00 | HSP
This to be considered only | --> | 124 | proposal | 19 | 2018-11-05 00:00:00 | LSP
 |  | 124 | drawing | 19 | 2018-11-05 00:00:00 | LSP
This to be considered only | --> | 125 | advance | 25 | 2020-11-05 00:00:00 | HSP
 |  | 125 | drawing | 25 | 2020-11-05 00:00:00 | HSP
 |  | 125 | manufacture | 25 | 2020-11-05 00:00:00 | HSP
This to be considered only | --> | 126 | proposal | 14 | 2020-11-05 00:00:00 | MAR | <== MAR type data completed in 2020.
 |  | 126 | advance | 14 | 2020-11-05 00:00:00 | MAR
 |  | 126 | drawing | 14 | 2020-11-05 00:00:00 | MAR
 |  | 126 | manufacture | 14 | 2020-11-06 00:00:00 | MAR
 |  |  | AVERAGE = | 13 | <== This would be the correct output data.
 |  |  |  |  | <== This is the best I can achieve.
Spreadsheet: 5ec6751e-bdc6-44a4-9d84-91f6132a3dd7
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ausländer und Ausländerinnen, welche länger als 2 Jahre in der [NAME] bleiben möchten, werden verpflichtet, die Sprache des jeweiligen Landesteils zu lernen.
 | Welche Staatsbürgerschaft haben [NAME]?
Antwort | Schweizer/Schweizerin
[NAME] | 0.89
Neutral / Weiss nicht | 0.06
[NAME] | 0.05
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 135028d1325765764-excel-lookup-emp0501
Sheet: Team

Sr. No. | Group | Skill Expertise | ABC | BCD | EFG | HIJ | KLM | NOP
1 | Development Tools | [NAME] | 5 | 5 | 4 | 4 | 5 | 4
2 |  | Abaqus | 3 | 5 | 3 |  |  | 2
3 | QA Tools | LMS Test Lab |  | 5 | 4 | 2
4 | New Added By Team Leader | CATIA V5 |  | 3 |  |  | 4
5 |  | LMS Virtual Lab |  | 5
6 | Added Skills by Team Members | Windows | 4 |  | 4 | 4 |  | 4
7 |  | Linux/Unix | 1 |  | 2 |  |  | 3
8 |  | HTML/XHTML 1.1/CSS 2.0 |  |  | 2 |  |  | 1
9 |  | C/C++ |  |  | 2 |  | 2 | 1
10 |  | Visual Basic |  |  | 2
11 |  | Adobe Photoshop CS4 |  |  |  |  | 2 | 2
 | EMP Name | EFG
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
Spreadsheet: 808598d1670528762-need-2-formulas-where-they-lookup-values-from-a-different-spreadsheet-book1
Sheet: Sheet1

Bank Transactions
Date | Description | Category | Amount | TX ID
2022-06-12 00:00:00 | Walmart groceries | Food | 102.13 | va25dx
2022-06-19 00:00:00 | Car payment xxxx091 | Car Note | 450.68 | am918
2022-06-29 00:00:00 | Amazon shopping xUS | Shopping | 213.23 | 0sl81a
2022-07-02 00:00:00 | Fry's groceries | Food | 109.33 | x8ajm2u
2022-07-18 00:00:00 | Car payment xxx091 | Car Note | 447.26 | suyth8d
2022-07-12 00:00:00 | [NAME]'s club TX | Shopping | 176.85 | msh71ah
2022-08-05 00:00:00 | Bashas groceries | Food | 99.39 | s83kx7
2022-08-19 00:00:00 | Car payment xxxx83 | Car Note | 445.1 | ls01nsh
2022-08-21 00:00:00 | American Airlines | Travel | 985.63 | sk83mpa
2022-08-24 00:00:00 | Suite hotels | Hotel | 438.74 | x7hhyr
2022-08-30 00:00:00 | Burger king NY | Food | 38.11 | js81in
2022-09-04 00:00:00 | Walmart groceries | Food | 85.49 | d6sha
2022-09-05 00:00:00 | Apple US | New Phone | 1258.76 | 28janx
2022-09-20 00:00:00 | Car payment xxxx83 | Car Note | 479.88 | s7h5oq
2022-09-29 00:00:00 | Amazon shopping xUS | Shopping | 78.08 | 1ksuu8
Spreadsheet: 209388d1359088313-split-the-column-to-many-split
Sheet: Sheet1

Actual | Result
01-610-23456-01 | 01 | 610 | 23456 | 01
01-610-23457-02 | 01 | 610 | 23457 | 02
01-610-23458-03 | 01 | 610 | 23458 | 03
01-610-23459-04 | 01 | 610 | 23459 | 04
Spreadsheet: 286522d1388336913-excel-multiple-search-criteria-and-display-results-vehicle-spec-search-1b
Sheet: Sheet1

[NAME] | [NAME] | Year
audi | a3 | 2010
[NAME] | [NAME] | Year | Live | Live Wire Location | Ignition | Ignition Wire Location | 12v Immobilisation (CAT5) | Special Notes
Audi | A3 | 2004 | Thick Red cable | Fusebox located in the end of the dashboard - Drivers side | Black cable | Fusebox located in the end of the dashboard - Drivers side | Red/Black cable | 0
Spreadsheet: 131279d1322842188-if-equal-to-then-insert-entire-row-ttttexfor
Sheet: Sheet1

[NAME] | Doe | abc | 100 | en-US | USA | yes
[NAME] | Doe | abc | 80.3 | en-US | USA | yes
[NAME] | Doe | abc | 28.7 | en-US | USA | yes
Kathy | Doe | abc | 1.8 | en-US | USA | yes
[NAME] | Doe | abc | 87.935 | en-US | USA | yes
[NAME] | Doe | abc | 0.6 | en-US | USA | yes
[NAME] | Doe | abc | 100 | en-US | USA | yes
MaryJane | Doe | abc | 0.2 | en | USA | yes
Donn | Doe | abc | 0.1 | en-US | USA | yes
[NAME] | Doe | abc | 0.1 | en-US | USA | yes
[NAME] | Doe | abc | 80.735 | en | USA | yes
[NAME] | Doe | abc | 0 | en-US | USA | yes
[NAME] | Doe | abc | 100 | en | USA | yes
Vincent | Doe | abc | 0 | en | USA | yes
Spreadsheet: 684679d1593498409-printing-based-on-a-text-in-next-cell-availabled
Sheet: data

 | product | status | count | cost/item
 | name1 | available | 30 | 1
 | [NAME] | not available | 0 | 5
 | name3 | available | 10 | 3
 | name4 | blocked | 10 | 5
 | name5 | available | 3 | 2
 | name6 | not available | 10 | 6
Spreadsheet: 3fdeccfb-5a30-44d8-b77f-36dc3f813b7f
Sheet: Sheet1

2013-2014 Payment Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
New College Financial Aid
2013-2014 Costs Estimated for Financial Aid Purposes
Tuition
 |  | Fall* | Spring
Resident |  | 3768.4 | 3014.72
Non-Resident |  | 16562.2 | 13249.76
 |  | * Fall term includes ISP.
Housing |  |  | Fall | Spring |  | Food | Fall | Spring
[NAME] |  | Double | 3364 | 2714 |  | First Year/Pei | 1515 | 1263
 |  | Single | 5058 | 4050 |  | B Dorm | 1121 | 919
 |  | Triple | 2557 | 2062 |  | Apartment | 487 | 396
B Dorm |  | Single | 3234 | 2597 |  | Commuter | 221 | 219
 |  | Single Pref. | 3444 | 2800
Dort/Goldstein |  | Suite | 4423 | 3523
New Halls |  | Suite | 4423 | 3523
(V,W,X,Y,Z) |  | Studio Single | 5083 | 4069
Total Fees
 |  | Fall | Spring
Tuition |  |  |  |  |  | Total Aid
Housing |  |  |  |  |  |  | Estimate
Food |  |  |  |  |  | [NAME] | Fall | Spring
Other
Total |  | 0 | 0
Payment Calculation
 |  | Fall | Spring
Fee Total |  | 0 | 0
-Aid Total | - | 0 | 0 |  |  | Total | 0 | 0
-Deposit and    payments | -
 | = | 0 | 0
Spreadsheet: 761722d1641185768-dynamic-dropdown-in-excel-copy-of-dnamic-dropdown-1
Sheet: CoCo

YEAR | MONTH | PARTNAME | SRCCoCo | TARGCoCo | ERP |  |  |  |  | Must be sorted by column F
2021 | Oct | IF1222_FM | 620662_2025 | LB_017F | BH
2021 | Oct | IF1222_FM | 370251_9001 | LB_9008 | BH
2021 | Oct | IF1222_FM | CHIADJ_9001 | LB_9008 | BH
2021 | Oct | [NAME] | CL044 | [NAME] | [NAME]
2021 | Oct | [NAME] | HSR02 | LB_T005 | [NAME]
2021 | Oct | 1C_LB_U005_FM | PR_OG00000153 | LB_U654 | 1C
2021 | Oct | 1C_LB_U125_FM | T810 | LB_T810 | 1C
2021 | Oct | 1C_LB_U005_FM | FSB_1 | LB_U317 | 1C
2021 | Oct | MC_SAP_FM | 6211 | LB_6210 | DS
2021 | Oct | [NAME] | 5500 | LB_5500 | DS
2021 | Oct | MC_SAP_FM | 6210 | LB_6210 | DS
2021 | Oct | [NAME] | 3000 | LB_3000 | DS
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: pairs workings

hole | [NAME] | [NAME] | TOTAL | [NAME] | [NAME] | TOTAL | D. Addison | [NAME] | TOTAL | [NAME] | [NAME] | TOTAL | D. Clarke | [NAME] | TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
hole | [NAME] | [NAME] | TOTAL | J. Dooley | [NAME] | TOTAL | [NAME] | [NAME] | TOTAL | M. Haines | [NAME] | TOTAL | P. Huband | [NAME] | TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
hole | D. Kolek | [NAME] | TOTAL | [NAME] | [NAME] | TOTAL | [NAME] | A. Moriarty | TOTAL | [NAME] | [NAME] | TOTAL | [NAME] | [NAME] | TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
hole | [NAME] | [NAME] | TOTAL | [NAME] | [NAME] | TOTAL | K. Pym | [NAME] | TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 69663d1270215642-drop-down-lists-to-populate-an-order-form-getlist
Sheet: CONSIGNMENT STOCK

supplier | [NAME] | STOCK CODE | RE-ORDER QTY
plumb centre | pipes 1 | 123456 | 1
plumb base | pipes 2 | 123457 | 2
wickes | pipes 3 | 123458 | 10
screwfix | pipes 4 | 123459 | 20
plumb centre | pipes 5 | 123460 | 13
plumb base | pipes 6 | 123461 | 1
wickes | pipes 7 | 123462 | 2
screwfix | pipes 8 | 123463 | 10
plumb centre | pipes 9 | 123464 | 20
plumb base | pipes 10 | 123465 | 13
wickes | pipes 11 | 123466 | 1
screwfix | pipes 12 | 123467 | 2
plumb centre | pipes 13 | 123468 | 10
plumb base | pipes 14 | 123469 | 20
wickes | pipes 15 | 123470 | 13
screwfix | pipes 16 | 123471 | 1
plumb centre | pipes 17 | 123472 | 2
plumb base | pipes 18 | 123473 | 10
wickes | pipes 19 | 123474 | 20
screwfix | pipes 20 | 123475 | 13
Spreadsheet: 831336d1685553834-combine-2-formulas-and-get-result-with-one-formula-combine-formula
Sheet: Data

A | B | C | D | E
12081 | SRS | 3739-23-00042 | DL |  |  |  | =LEFT(C2,4)
12082 | SRS | 3739-23-00042 | DL |  |  |  | =MID(C9,10,1)
12083 | SRS | 3739-23-00042 | DL
12084 | SRS | 3739-23-00042 | DL
12085 | SRS | 3739-23-00042 | DL
12086 | SRS | 3739-23-00042 | DL
12087 | SRS | 3739-23-00042 | DL
5432 | RS | 23-37391-R000060 | DL
6792 | RS | 23-37391-R000061 | DL
6793 | RS | 23-37391-R000062 | DL
4139 | RS | 23-37391-R000063 | DL
5360 | RS | 23-36201-R000005 | GJ
7086 | RS | 23-36201-R000005 | GJ
607 | RS | 23-36201-R000006 | GJ
9489 | RS | 23-36201-R000006 | GJ
3858 | RS | 23-36201-S000142 | GJ
6986 | RS | 23-36201-S000143 | GJ
8796 | RS | 23-36201-S000144 | GJ
11746 | RS | 23-36201-S000145 | GJ
4527 | RS | 23-38341-R000165 | HR
6108 | RS | 23-38341-R000165 | HR
2153 | RS | 23-38341-R000166 | HR
6436 | RS | 23-38151-R000074 | TN
9783 | RS | 23-38151-R000075 | TN
9784 | RS | 23-38151-R000076 | TN
4998 | RS | 23-38311-S001631 | TN
6364 | RS | 23-38311-S001632 | TN
1519 | RS | 23-38311-S001633 | TN
13589 | SRS | 3838-23-00079 | WB
13590 | SRS | 3838-23-00079 | WB
13662 | SRS | 3838-23-00082 | WB
13663 | SRS | 3838-23-00082 | WB
13664 | SRS | 3838-23-00082 | WB
13665 | SRS | 3838-23-00082 | WB
5007 | RS | 23-38381-S001244 | WB
1820 | RS | 23-38381-S001245 | WB
8434 | RS | 23-38381-S001245 | WB
Spreadsheet: 861739d1709577406-excel-doesnt-recognize-data-as-number-book1
Sheet: Sheet1

Base | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
BER | CP | 1.00 | 0:00 | 0:00 | 0:00 | 0:00 |  |  |  | 0.00 | 0.00
BLL | CP | 6.20 | 756:57 | 122:07 | 100:30 | 16:13 | 13.28 | 6:49 | 0:54 | 1.00 | 114.00
CPH | CP | 2.54 | 252:00 | 99:13 | 14:51 | 5:51 | 5.89 | 6:09 | 0:22 | 0.00 | 41.00
KUN | CP | 5.00 | 482:47 | 96:33 | 8:15 | 1:39 | 1.71 | 7:55 | 0:08 | 0.00 | 62.00
Spreadsheet: 682735d1592306360-displaying-group-type-in-cell-based-on-range-group
Sheet: Lookup

Staff | Group
AW | Manager
TM | Manager
BJ | Manager
BR | Developer
TE | Developer
FF | Developer
MJ | Developer
TS | Staff
KK | Staff
LI | Staff
Spreadsheet: 349478d1412345282-formula-to-refer-to-array-in-another-sheet-that-shifts-based-on-date-vertex34
Sheet: Sheet1

 |  |  |  | 2011-04-01 00:00:00
 |  |  | Start in Q ?
 |  |  | End in Q ?
 |  |  | Days in Q
 |  |  | Price / unit
Start date | Quarterly kWh | Cost to Date ($) | end date |  | Q3-11 | Q4-11 | Q1-12 | Q2-12 | Q3-12 | Q4-12 | Q1-13 | Q2-13 | Q3-13 | Q4-13 | Q1-14 | Q2-14 | Q3-14 | Q4-14
2011-09-21 00:00:00 | 1424 |  | 2011-10-03 00:00:00
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-99 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 102388d1300326536-indirect-new-artist-calendar-2011
Sheet: CALENDAR

 | Mar | 2011-03-04 00:00:00 | 2011-03-05 00:00:00 | 2011-03-11 00:00:00 | 2011-03-12 00:00:00 | 2011-03-18 00:00:00 | 2011-03-19 00:00:00 | 2011-03-25 00:00:00 | 2011-03-26 00:00:00
 | Apr
 | May
 | Jun
 | Jul
 | Aug
 | Sep
LET'S TALK ENTERTAINMENT
Ph: 4950 2828  |  Fx: 49 50 2228  | Mob: [PHONE] |  www.lte.com.au  [NAME][EMAIL]
SOLOISTS
 | GIAN |  |  |  |  |  |  |  |  |  |  |  |  | BERNIE AYRTON
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | VICTORIA MCGEE
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 | GREG MCKEW |  |  |  |  |  |  |  |  |  |  |  |  | MICK FREEMAN
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 | JOEY PETERS
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
 |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat |  |  |  | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat | Fri | Sat
 |  |  | 34
Spreadsheet: 726595d1617308274-applying-a-calc-to-a-surplus-surplus-distribution
Sheet: Sheet1

 | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6
Current | 5 | 7 | 10 | 8 | 6 | 7
 | 5 | 8 | 7 | 6 | 6 | 9
 | 5 | 9 | 5 | 8 | 8 | 5
 | 5 | 5 | 10 | 8 | 6 | 8
Surplus | 45
Day reduction
 | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6
Adjusted
Spreadsheet: 860016d1708250405-to-generate-random-list-of-number-but-not-to-get-itself-random-but-not-get-itself-hd
Sheet: Sheet1

Person | To get [NAME]
#1
#2
#3
#4
#5
#6
#7
#8
#9
#10
#11
#12
#13
#14
#15
#16
#17
#18
#19
#20
Spreadsheet: 756809d1637793836-index-match-with-multiple-criteria-to-match-on-vl-table-sample-sheet
Sheet: Data Table

 |  |  |  |  |  | Desired Result in VL Table | Desired Result in VL Table
[NAME] | Tire Code | Axle Code | Coupler Code | Tires | Qty | Tires | Qty
A6X8024 | T12 | A19 | C10 |  |  | 22032 | 4
A6X8020 | T12 | A19 | C10 |  |  | 22032 | 4
A6X8024 | T83 | A19 | C10 |  |  | 22009 | 4
A6X8024 | T12 | A19 | C10 |  |  | 22032 | 4
T8X10224 | T29 | A29 | C10 |  |  | 22006 | 4
YHX10234 | T30 | A46 | C32 |  |  | 22007 | 9
DDX9620 | T26 | A33 | C17 |  |  | 22018 | 5
T8X10224 | T29 | A29 | C10
T8X10224 | T29 | A29 | C10
DTX8316 | T29 | A74 | C10
H8X10232G | T18 | A25 | C17
H6X10222G | T71 | A24 | C17
DTX8316G | T29 | A74 | C17
TDX10226 | T28 | A33 | C17
A6X8024 | T12 | A19 | C10
G6X8322 | T18 | A24 | C10
C6X8322 | T18 | A24 | C10
D6X6010 | T83 | A12 | C10
DHX8316 | T18 | A25 | C13
DJX8314 | T29 | A74 | C10
DJX8314 | T29 | A74 | C10
C6X8324G | T71 | A24 | C17
H8X10232G | T29 | A74 | C17
T6X10224 | T18 | A24 | C10
T6X10224 | T18 | A24 | C10
T8X10222G | T29 | A74 | C17
G6X10222 | T18 | A24 | C10
H6X10220 | T18 | A24 | C10
H6X10222 | T18 | A24 | C10
LDX10240 | T26 | A39 | C17
DJX8316G | T29 | A74 | C17
TDX10232 | T26 | A33 | C17
LDX10224 | T26 | A33 | C17
LDX10224 | T26 | A33 | C17
H8X10226 | T29 | A74 | C10
A6X8024 | T83 | A19 | C10
[NAME] | T29 | A74 | C17
A6X8024 | T12 | A19 | C10
DTX8314G | T71 | A24 | C17
DTX8314G | T71 | A24 | C17
C3M8320 | T05 | A12 | C02
C3M8316 | T05 | A12 | C02
YDX10234 | T80 | A39 | C17
YDX10234 | T26 | A33 | C17
TDX10228 | T87 | A39 | C17
T8X10222 | T71 | A24 | C10
GOX10224 | T18 | A24 | C10
T6X10224 | T60 | A24 | C10
G6X8320 | T18 | A24 | C10
G6X10222 | T18 | A24 | C10
C6X8320 | T18 | A24 | C10
 |  |  |  | #[NAME]?
 |  |  |  | #[NAME]?
Spreadsheet: 804665d1668204474-stock-allocation-value-book1
Sheet: Backorder

Order Date | SKU | Quantity | Stock Value | Reasoning
2022-08-12 00:00:00 | PROD1234 | 17 |  | 13@1.79 + 4 @ 3.33
2022-08-18 00:00:00 | PROD1234 | 12 |  | 9 @ 3.33 = 3 @ 8.58
2022-09-01 00:00:00 | PROD1234 | 9
2022-09-17 00:00:00 | PROD1234 | 13
2022-10-01 00:00:00 | PROD1234 | 5
2022-10-21 00:00:00 | PROD1234 | 15