tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: fa7543b5-69a2-48e4-a7ff-463ca2611eeb
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Buchungsauftrag/Modification d'imputation |  |  |  |  |  |  |  |  |  |  |  |  | Contruction des routes nationales
 |  |  |  |  |  |  |  |  | *Zutreffendes ankreuzen/Cocher ce q. conv.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anweisungsnummer                 No d'ordonnance |  |  | Belegnummer                        Pièce justif. no |  | [NAME]
 |  | [NAME]: | …..
[NAME] früheren Buchung / Annulation de l'imputation antérieure |  |  |  |  |  |  |  |  |  |  |  |  |  | Neue Buchung / Nouvelle imputation
[NAME]             Canton | N-Strasse               Route Nat. | Klasse Classe | (U-Nr.) |  |  |  | (PLB-Code) | Abschnitt            Section | [NAME] No. compte pri. | Unterkonto No. sous-compte | Betrag / Montant (Fr. / Rp.) |  |  | [NAME]             Canton | N-Strasse               Route Nat. | Klasse Classe | (U-Nr.) |  |  |  | (PLB-Code) | Abschnitt            Section | [NAME] No. compte pri. | Unterkonto No. sous-compte | Betrag / Montant (Fr. / Rp.)
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Verteiler / Distribution: |  |  |  | Begründung / Motif du transfert: |  |  |  |  |  |  |  |  |  |  |  | Datum / Date: |  |  |  |  |  | Stempel und Unterschrift Kanton / Timbre et signature du canton:
1 Ex. ASTRA
1 Ex. Kt./Ct.
 |  |  |  | [NAME] des der [NAME] ist beizufügen!
 |  |  |  | [NAME] une [NAME] pièce justificative ayant fait l'objet d'une modification d'imputation!
Spreadsheet: 75902d1276518567-consolidate-multiple-sheets-testing2
Sheet: ME

 | Country | State | Company | SP | Pilot | Probability | Value | Month | J | K | L | M | N | O | P | Q | Comments
 | Abu Dhabi |  |  |  |  | 0.9 | 10
 | Jordan
 | Dhubi
 | Oman
 |  |  |  |  | Total |  | 10
Spreadsheet: 227845d1365849007-best-least-sqaures-fit-bds
Sheet: Phase-Plots

degrees | [NAME] | cos
0
1
2
3
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
32
33
34
35
36
37
38
Spreadsheet: 332777e1-bb19-4181-a206-fa716c785402
Sheet: Purchase of Equipment

[NAME]
Item # | Item | Year | Purchase Price
 | 2500 Set | 1 | 28.62
 |  | 2 | 29.19
 |  | 3 | 29.78
 |  | 4 | 30.37
 |  | 5 | 30.98
 | 14 ft [NAME] | 1 | 4.27
 |  | 2 | 4.4
 |  | 3 | 4.53
 |  | 4 | 4.67
 |  | 5 | 4.81
 | 25 ft Line Cord | 1 | 7.24
 |  | 2 | 7.46
 |  | 3 | 7.68
 |  | 4 | 7.91
 |  | 5 | 8.15
 | 48 Port Cat 6 Panel | 1 | 259.83
 |  | 2 | 267.62
 |  | 3 | 275.65
 |  | 4 | 283.92
 |  | 5 | 292.44
 | Cat 6 [NAME] | 1 | 5.03
 | 3 ft | 2 | 5.18
 |  | 3 | 5.34
 |  | 4 | 5.5
 |  | 5 | 5.66
Spreadsheet: 101538d1299642276-excel-2007-formula-to-organize-data-ngu-criss-cross-references
Sheet: Sheet1

START:
ABC Co. |  |  |  |  | DEF Co.
sequence | item | cost | profit |  | sequence | item | cost | profit
1 | apple | 0 | 0 |  | 1 | pear | 2 | 2
2 | pear | 0 | 0 |  | 2 | orange | 3 | 3
3 | orange | 2 | 2 |  | 3 | apple | 0 | 0
4 | banana | 3 | 3 |  | 4 | banana | 0 | 0
5 | grape | 2 | 2 |  | 5 | blueberry | 0 | 0
FINISH:
ABC Co. | DEF Co. | Item |  | ABC |  | DEF
Sequence |  |  |  | cost | profit | cost | profit
 |  | apple
 |  | pear
 |  | orange
 |  | banana
 |  | grape
 |  | blueberry
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: pe

Power. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 298308d1392755557-find-a-value-in-a-table-with-multiple-values-test-excel-data-search-sheet
Sheet: ON-8

Date | PO # | Buyer | Division Line | Model | Trailer Description | Serial # | Build Location | Line # | Est. Delivery Date | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Spreadsheet: 49741d1249056276-listing-transactions-by-purchase-date-projected-car-purchases
Sheet: Export

Date | Type | Model | Make | Colour | Value
2009-01-01 00:00:00 | Purchase | 2008 | Ford | White | -5000
2009-02-12 00:00:00 | Purchase | 2008 | Ford | Blue | -10000
2009-02-15 00:00:00 | Purchase | 2008 | Ford | Blue | -12000
2009-03-04 00:00:00 | Purchase | 2008 | Ford | Green | -11000
2009-04-24 00:00:00 | Purchase | 2008 | Ford | Green | -4000
2009-06-03 00:00:00 | Purchase | 2008 | Ford | Green | -7000
2009-04-30 00:00:00 | Sale | 2008 | Ford | Green | 15000
2009-04-30 00:00:00 | Sale | 2008 | Ford | Blue | 12000
2009-04-30 00:00:00 | Sale | 2008 | Ford | White | 11000
2009-01-01 00:00:00 | Purchase | 2008 | Ford | White | -10000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -5000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -6000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -3000
2009-05-13 00:00:00 | Purchase | 2008 | Ford | White | -8000
2009-03-13 00:00:00 | Purchase | 2009 | Dodge | Red | -2
2009-05-23 00:00:00 | Purchase | 2009 | Chrysler | White | -1
Spreadsheet: 119971d1314894335-help-with-a-pivottable-calculation-pt-clac-field-data-mining
Sheet: pivot

Keyword | (All)
Row Labels | Average of CTR | Sum of Clicks | Sum of Impressions | Sum of Avg. CPC | Sum of Cost | Sum of Conv. (1-per-click) | Sum of Cost / conv. (1-per-click)
-- | 0.0018 | 1683 | 1614592 | 2.06 | 893.34 | 164 | 24.46
Consulting Jobs | 0 | 0 | 39 | 0 | 0 | 0 | 0
Government Jobs | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job Finding Service | 0 | 0 | 24 | 0 | 0 | 0 | 0
Job Interview | 0.0018765 | 4 | 782 | 2.41 | 2.41 | 0 | 0
Job Search Engines | 0.0004222222222222222 | 58 | 11281 | 4.41 | 34.61 | 5 | 7.970000000000001
Jobs | 0.0006539226519337016 | 132 | 72678 | 25.91 | 69.98000000000002 | 14 | 32.5
Jobs - US City and State | 0.001237623762376238 | 1 | 678 | 0.5 | 0.5 | 0 | 0
Looking for a job | 0.002771590909090909 | 65 | 15197 | 9.530000000000001 | 35.58999999999999 | 7 | 16.02
Resume | 0.001880490956072351 | 50 | 12953 | 32.77999999999999 | 44.49999999999998 | 1 | 0.95
Grand Total | 0.001385492577597841 | 1993 | 1728224 | 77.6 | 1080.930000000001 | 191 | 81.89999999999999
Sum of Clicks | Sum of Impressions | Sum of Field1
50 | 12953 | 0.00386010962711341 | << This is from a Calculated Field - Also make rows 1 to 775 of PT data
Spreadsheet: 275682d1383604099-distribute-the-production-per-minute-to-time-table-distribution-of-prodpermin
Sheet: Sheet1

Trying to find  the distribution of Production per Minute Value in Time Table
I can find in 1.Condition what I want, but if I delete emty column I get problem.
1. Condition ( There is a empty column between table and formulas) |  |  |  |  |  |  |  | Time TABLE
Dep. | Unit | Starting | End | Time | Prod.Per Minute | Production |  | 02:00:00 | 02:01:00 | 02:02:00 | 02:03:00 | 02:04:00 | 02:05:00 | TOTAL
A | U1 | 02:00:00 | 02:05:29 |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  | Last column find remaining of G5 - Sum(I5:M5)
2. Condition ( There is a NOT empty column between table and formulas) |  |  |  |  |  |  | Time TABLE
Dep. | Unit | Starting | End | Time | Prod.Per Minute | Production | 02:00:00 | 02:01:00 | 02:02:00 | 02:03:00 | 02:04:00 | 02:05:00 | TOTAL
A | U1 | 02:00:00 | 02:05:29 |  |  | 68
in second condition circular References appear
I want to implement same formula logic to second condition
Is there any solution for 2.condition, or any other suggestion by formula.
Spreadsheet: 264964d1379024099-looping-through-data-and-finding-cells-that-meet-criteria-test
Sheet: Winnie the Pooh

Supplier # | Supplier | SSR | Discrepancy Type | PO # | PO Date | Stuff | P/n | P/n | Total Order Qty | Received | Total Due | Cost | Balance | Now | Here | When | Ack Qty 1 | Country | Mexico | Canada | Taiwan | Part | Cuba
m | Metrodome | [NAME] the [NAME] | Past Due Ack | y | ? |  | 59891 | 59891 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Past Due Ack | y | ? |  | 59892 | 59892 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Past Due Ack | y | ? |  | 59893 | 59893 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Past Due Ack | y | ? |  | 59894 | 59894 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Past Due Ack | y | ? |  | 59895 | 59895 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Blank Ack Date | y | ? |  | 59967 | 59967 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Blank Ack Date | y | ? |  | 59968 | 59968 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Blank Ack Date | y | ? |  | 59969 | 59969 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Blank Ack Date | y | ? |  | 59970 | 59970 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
m | Metrodome | [NAME] the [NAME] | Blank Ack Date | y | ? |  | 59971 | 59971 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
Spreadsheet: stacey_white__38955__13617_EPMI-ST-CA_deal_sum
Sheet: _tmp_13617_EPMI-ST-CA_deal_sum

 |  |  |  |  |  |  | ENRON POW | ER TRADING & | [NAME] |  |  |  |  |  | Run Date | :       10/16 | /01
Report Da | te:  10/15/01 |  |  |  |  |  |  | Deal [NAME] | y |  |  |  |  |  | Run Time | :       14:34 | :22
Post ID: | 13617
Desk: EPM | I-ST-CA
 |  | Trade | Start | End |  |  |  |  |  |  |  |  |  | Current |  |  |  | Prior Day | Prior
Deal | Counter | Date | Date | Date | Anty | Delivery | PV'd | Swap Vol | PV'd | Option Vol | Notional | Deal Vol |  | Deal | MTM P/L |  | LTD | Hedge | Day
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | Y/N | Point | Peak | [NAME] | Peak | [NAME] | Peak | [NAME] | Price Mid | Basis Mid | Total Mid | Prudent | Liquidations | Management | Liquidations
--------- | ------------------ | -------- | -------- | -------- | ---- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ---------------- | --------------- | -------------
798418 | NEWPOWCOM | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | No | NP-15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R10 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
798421 | NEWPOWCOM | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | No | SP-15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R11 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Total Pow | er Price Book |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Spreadsheet: 475268d1471249259-count-cost-from-one-tab-into-a-table-in-another-tab-test-2
Sheet: Lists

Month |  | Day |  | Staff
April |  | Monday - Breakfast |  | [NAME]
May |  | Monday - Lunch |  | [NAME]
June |  | Monday - Dinner |  | [NAME]
July |  | Tuesday - Breakfast |  | [NAME]
August |  | Tuesday - Lunch |  | [NAME]
September |  | Tuesday - Dinner
October |  | Wednesday - Breakfast
November |  | Wednesday - Lunch
December |  | Wednesday- Dinner
January |  | Thursday - Breakfast
February |  | Thursday - Lunch
March |  | Thursday - Dinner
 |  | Friday - Breakfast
 |  | [NAME]
 |  | Friday- Dinner
Type |  | Saturday - Breakfast
 |  | Saturday - Lunch
 |  | Saturday - Dinner
 |  | Sunday - Breakfast
 |  | Sunday- Lunch
 |  | [NAME]
Spreadsheet: 708964d1608113823-auto-allocation-of-yearly-value-in-months-book1-7-ans
Sheet: Sheet1

Start Date | End Date | Value | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00
2007-11-15 00:00:00 | 2008-11-14 00:00:00 | 1802700
2008-11-15 00:00:00 | 2009-11-14 00:00:00 | 1802700
2009-11-15 00:00:00 | 2010-11-14 00:00:00 | 1802700
2010-11-15 00:00:00 | 2011-11-14 00:00:00 | 1802700
2011-11-15 00:00:00 | 2012-11-14 00:00:00 | 1802700
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | E.g. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Row Header dates are changed and formatted to show year also. 1 header dates modified
Spreadsheet: 769899d1645720703-sum-up-in-one-colomn-from-2-different-colomn-sumifs-qs
Sheet: GA

Channel | Channel | Sub-Channel | Sessions | Transactions | Revenue
A1 | B7 | C16 | 95 | 55 | 55
A2 | A1 | C10 | 14 | 550 | 550
A1 | A2 | C10 | 1 | 88 | 8888
A2 | b8 | C16 | 95 | 55 | 55
Spreadsheet: 13635da0-f88f-4520-8220-6808040d5f39
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
 | 5671.0 Lending Finance, Australia
 | TABLE 2. HOUSING AND PERSONAL FINANCE COMMITMENTS By Lender: Australia, Original ($000)
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
Housing Finance - Banks ; |  |  | Original | A2437051V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Housing Finance - Permanent building societies ; |  |  | Original | A2437052W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Housing Finance - Wholesale lenders n.e.c. ; |  |  | Original | A2437053X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Housing Finance - Other lenders ; |  |  | Original | A2437054A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Housing Finance - Total ; |  |  | Original | A2437055C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Banks ; |  |  | Original | A2437046A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Credit co-operatives ; |  |  | Original | A2437047C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Finance companies ; |  |  | Original | A2437048F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Other lenders ; |  |  | Original | A2437049J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2437050T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 767266d1644386658-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation6
Sheet: Yearly

Allocation
Click Consulting
Purpose | To allocate the amount of each item based on a daily amount and the number of dates in each column.
Allocation
 | Amount | Alloc Start | Alloc End |  | Days | DailyAmt |  |  |  |  |  |  | Total | Diff
 | 1000 | 2014-01-01 00:00:00
 | 600 | 2014-01-12 00:00:00
 | 900 | 2014-02-01 00:00:00
 | 800 | 2015-01-01 00:00:00
 | 650 | 2015-01-22 00:00:00
 | 850 | 2015-02-10 00:00:00
Spreadsheet: 143134d1330216652-sorting-multiple-columns-with-lookup-values-example
Sheet: Sheet1

RANKINGS |  |  |  |  | Results | Points | Correct Picks
[NAME] | 3 | 1 |  |  | [NAME] | 3 | 1
[NAME] | 4 | 2 |  |  | [NAME] | 4 | 2
[NAME] | 3 | 3 |  |  | [NAME] | 3 | 3
[NAME] | 3 | 1 |  |  | [NAME] | 3 | 1
 | ^ SORT THESE ^ |  |  |  | ^These are updated and I want the RANKINGS to change
 |  |  |  | 1. Sort by Column B
 |  |  |  | 2. A and C just go along with it
Spreadsheet: jonathan_mckay__17188__OSM Restructure
Sheet: Sheet1

 | Price | Daily Vol | Days | Monthly Vol | Value | Price | Daily Vol | Monthly Vol | Value | Total Value | Total MMBtu | Discount Rate | PV Value | [NAME]
2001-06-01 00:00:00 | 4.58 | 2000 |  |  |  | 7.76 | 2000 |  |  |  |  | 0.991806129885448
2001-07-01 00:00:00 | 4.49 | 2000 |  |  |  | 7.76 | 2000 |  |  |  |  | 0.988425501911956
2001-08-01 00:00:00 | 4.55 | 2000 |  |  |  | 7.76 | 2000 |  |  |  |  | 0.985041529245318
2001-09-01 00:00:00 | 4.565 | 2000 |  |  |  | 7.76 | 2000 |  |  |  |  | 0.981797146231561
2001-10-01 00:00:00 | 5.15 | 2000 |  |  |  | 7.76 | 2000 |  |  |  |  | 0.978457466242464
2001-11-01 00:00:00 | 6.97 | 2000 |  |  |  | 7.76 | 2000 |  |  |  |  | 0.975208084202024
2001-12-01 00:00:00 | 9.43 | 2000 |  |  |  | 7.76 | 2000 |  |  |  |  | 0.971870021412949
2002-01-01 00:00:00 | 9.63 | 4000 |  |  |  |  |  |  |  |  |  | 0.968445213723415
2002-02-01 00:00:00 | 6.9 | 4000 |  |  |  |  |  |  |  |  |  | 0.96517745150813
2002-03-01 00:00:00 | 5.51 | 4000 |  |  |  |  |  |  |  |  |  | 0.961576203349088
2002-04-01 00:00:00 | 4.48 | 4000 |  |  |  |  |  |  |  |  |  | 0.958018576301804
2002-05-01 00:00:00 | 4.39 | 4000 |  |  |  |  |  |  |  |  |  | 0.954320895959274
2002-06-01 00:00:00 | 4.43 | 4000 |  |  |  |  |  |  |  |  |  | 0.950690157497859
2002-07-01 00:00:00 | 4.47 | 4000 |  |  |  |  |  |  |  |  |  | 0.946883712246014
2002-08-01 00:00:00 | 4.49 | 4000 |  |  |  |  |  |  |  |  |  | 0.94294983239808
2002-09-01 00:00:00 | 4.5 | 4000 |  |  |  |  |  |  |  |  |  | 0.939081140826155
2002-10-01 00:00:00 | 4.51 | 4000 |  |  |  |  |  |  |  |  |  | 0.935050185417688
 |  |  |  |  |  |  |  |  |  | 1-Year Swap
 |  |  |  |  |  |  |  |  |  | 17-Mon Swap
 |  |  |  |  |  |  |  |  |  | I sold him 5.94
Spreadsheet: eric_saibi__9859__101101R
Sheet: Palo Verde 02 R7

Owner Name |  | Arizona Public Service Company
Station Name |  | Palo Verde Nuclear Power Station
Unit Name |  | Palo Verde 02 R7
NERC Region |  | WSCC
State |  | AZ
Fuel Type |  | Nuclear
Capacity |  | 1403 MW
Start Date |  | 2001-10-11 00:00:00
End Date |  | 2001-11-09 00:00:00
Prv. Start Date |  | 2001-10-11 00:00:00
Prv. End Date |  | 2001-10-14 00:00:00
Comments |  | Replacement of control element asseblies.
SIC |  | 4911
Plant ID |  | 1015283
Unit ID |  | 10078741
Outage ID |  | 18635
Spreadsheet: larry_campbell__21020__TWBillingSummary2001
Sheet: Transwestern Billing Summary

Job | Labor | Material | Contracts | Employee Related | Other |  | Total
Order 8021737 - Transwestern Account Reconciliation | 155000 | 30242 | 37181 | 3980 | -285835
Order 7027046 - Transwestern/PG&E Filter Separator Installation | 2501.32 | -821.49 | 39918.87 | 1457.31 | -1058729.1
Order 7032225 - Project Management (L300 A&B Liquids Project) | 127049 | 3909 | 35660 | 355 | 7516
Order 7032265 - Line 300A Install Taps | 351.26 | 1662.09 | 19.83 | -1313.28
Order 7032266 - Line 300B Install Taps
Order 7032267 - Install Filter Sep. Rabbit Springs | 286.01 |  |  |  | 1140.17
Order 7032268 - Install Filter Sep. Big Bear B Tap | 5972.8 | 24932.37 |  |  | 1368.63
Order 7032285 - Install Filter Sep. Oro Grande M&R | 6419.75 | 214.32 |  |  | 922.39
Order 7032286 - Install Filter Sep. [NAME] B | 65429.91 | 16505 | 3582.38 |  | 9819.5
Order 7032287 - Install Filter Sep. [NAME] C
Order 7032288 - Install Filter Sep. [NAME] | 117.54 | 673.4 |  |  | 564.06
Order 7032289 - Install Filter Sep. Barstow A Tap MS | 69.08 | 1267.04 |  |  | 41.39
Order 7032290 - Install Filter Sep. [NAME]
Order 7032291 - Install Filter Sep. [NAME] | 84.13 | -8.82 |  |  | 2.91
Order 7032292 - Install Filter Sep. [NAME] | 3252.7 | 222.98 | 18391.28 | 630.81 | 1539.07
Order 7032293 - Install Filter Sep. [NAME] | 42707 | 1510 |  | 32 | 2176
Order 7032294 - Install Filter Sep. [NAME]
Order 7032295 - Install Filter Sep. [NAME] Outlets | 52629 | 1694 |  | 495 | 4927
Order 7032296 - Install Filter Sep. [NAME]
Order 7032297 - Install Filter Sep. [NAME] | 4280.9 | 142.43 |  |  | 167.31
Order 7032298 - Install Filter Sep. [NAME] M&R | 2045.4 | 1992.11 |  |  | 142.42
Order 7032426 - Install Filter Sep. Black Mountain Cement | 57756.2 | 72627.26 |  |  | 4551.11
Order 7032427 - Install Filter Sep. Cal Portland Cement Reg. | 62888.07 | 6163.99 | 5958 |  | 8427.57
Order 7034075 - Install Filter Sep.[NAME] |  |  |  |  | 4
Order 7034076 - Install Filter Sep. [NAME] Compressor | 361 | 110952 | 144039 |  | 9069
Order 7034466 - Install Filter Sep. L311/MP 54.44 (Westend) | 62656.03 | 12184.04 | 2321.03 |  | 3877.94
PLS 2X Relocation Project |  |  | 141262