tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 183408d1348822446-pivot-table-w-multiple-duplicate-identiier-pivot-test
Sheet: Open Bal Data

PjM | Project Number | Project Name | [NAME] | Region | WA Amount (Pending or Approved) | Invoices (Pending or Approved) | WA CO Balance | [NAME] | ODD - ACTUAL START/FINISH
[NAME] | 10002694 | A | ADELHARDT CONSTRUCTION CORP | West | 10000 | 10000 |  | Zero Balance | 2012-08-28 00:00:00
[NAME] | 10002694 | A | ARCADIS US INC | West | 20000 | 20000 |  | Zero Balance | 2012-08-28 00:00:00
[NAME] | 10002694 | A | GENSLER | West | 30000 | 30000 |  | Zero Balance | 2012-08-28 00:00:00
[NAME] | 10002694 | A | GMR PROTECTION RESOURCES INC | West | 40000 | 40000 |  | Zero Balance | 2012-08-28 00:00:00
[NAME] | 10002694 | A | PROJECT EXPEDITERS INC | West | 50000 | 50000 |  | Zero Balance | 2012-08-28 00:00:00
[NAME] | 10002694 | B | RIKER DANZIG SCHERER [NAME] | West | 60000 | 58000 |  | >$0.00 < $1,000 | 2012-08-28 00:00:00
[NAME] | 10002694 | B | SECURITY VAULT WORKS INC | West | 70000 | 50000 |  | >$2,500 | 2012-08-28 00:00:00
[NAME] | 10003840 | C | GENSLER | West | 80000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
[NAME] | 10003840 | C | GMR PROTECTION RESOURCES INC | West | 90000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
[NAME] | 10003840 | C | ICON IDENTITY SOLUTIONS | West | 100000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
[NAME] | 10003840 | C | LECHASE CONSTRUCTION SERVICES | West | 110000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
[NAME] | 10003840 | C | PROJECT EXPEDITERS INC | West | 120000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
AL | 10003956 | D | BNF CONTRACTORS INC | West | 130000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | GENSLER | Central | 140000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | GMR PROTECTION RESOURCES INC | Central | 150000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | ICON IDENTITY SOLUTIONS | Central | 160000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | PROJECT EXPEDITERS INC | Central | 170000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
[NAME] | 10005325 | E | ADT SECURITY SVCS INC | Central | 180000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | GENSLER | Central | 190000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | GMR PROTECTION RESOURCES INC | Central | 200000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | GRACE CONSTRUCTION MANAGEMENT | Central | 210000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | ICON IDENTITY SOLUTIONS | Central | 220000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | IDX CORP | Central | 230000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | PROJECT EXPEDITERS INC | Central | 240000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5313

5313 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 30574d1226111862-irr-function-is-returning-the-wrong-value-case09_joshuakampschmidt_2
Sheet: Loan Analysis

NewLeaf Paper
[NAME] |  |  | Amortization Table
Loan (PV) | 750000 |  | Year | Period | Remaining Principal | Interest Payment | Principal Payment | Total Payment
Annual  Rate | 0.075 |  | 1 | 1 | 750000 | -14062.5 | -31253.60974195138 | -45316.10974195138
Years | 5 |  | 1 | 2 | 718746.3902580487 | -13476.49481733841 | -31839.61492461296 | -45316.10974195138
Periods per Year | 4 |  | 1 | 3 | 686906.7753334357 | -12879.50203750192 | -32436.60770444946 | -45316.10974195138
Rate per Period (RATE) | 0.01875 |  | 1 | 4 | 654470.1676289863 | -12271.31564304349 | -33044.79409890789 | -45316.10974195138
Number of Periods (NPER) | 20 |  | 2 | 5 | 621425.3735300784 | -11651.72575368897 | -33664.3839882624 | -45316.10974195137
Period Payment (PMT) | -45316.10974195138 |  | 2 | 6 | 587760.9895418161 | -11020.51855390905 | -34295.59118804232 | -45316.10974195138
 |  |  | 2 | 7 | 553465.3983537738 | -10377.47621913326 | -34938.63352281812 | -45316.10974195138
 |  |  | 2 | 8 | 518526.7648309557 | -9722.376840580415 | -35593.73290137096 | -45316.10974195138
 |  |  | 3 | 9 | 482933.0319295847 | -9054.994348679715 | -36261.11539327166 | -45316.10974195138
 |  |  | 3 | 10 | 446671.916536313 | -8375.09843505587 | -36941.0113068955 | -45316.10974195138
 |  |  | 3 | 11 | 409730.9052294175 | -7682.454473051577 | -37633.6552688998 | -45316.10974195138
 |  |  | 3 | 12 | 372097.2499605177 | -6976.823436759708 | -38339.28630519166 | -45316.10974195138
 |  |  | 4 | 13 | 333757.963655326 | -6257.961818537366 | -39058.14792341401 | -45316.10974195138
 |  |  | 4 | 14 | 294699.815731912 | -5525.621544973357 | -39790.48819697802 | -45316.10974195138
 |  |  | 4 | 15 | 254909.327534934 | -4779.549891280019 | -40536.55985067136 | -45316.10974195138
 |  |  | 4 | 16 | 214372.7676842627 | -4019.489394079926 | -41296.62034787145 | -45316.10974195138
 |  |  | 5 | 17 | 173076.1473363912 | -3245.177762557345 | -42070.93197939403 | -45316.10974195138
 |  |  | 5 | 18 | 131005.2153569972 | -2456.347787943706 | -42859.76195400767 | -45316.10974195138
 |  |  | 5 | 19 | 88145.45340298951 | -1652.727251306067 | -43663.38249064531 | -45316.10974195138
 |  |  | 5 | 20 | 44482.07091234421 | -834.0388296064658 | -44482.07091234491 | -45316.10974195138
 | Interest and Principle Payments per Year
 |  |  | 1 | 2 | 3 | 4 | 5 | Total
 | Interest |  | -52689.81249788382 | -42772.09736731169 | -32089.37069354687 | -20582.62264887067 | -8188.291631413585 | -156322.1948390266
 | Principal |  | -128574.6264699217 | -138492.3416004938 | -149175.0682742586 | -160681.8163189348 | -173076.1473363919 | -750000.0000000009
 | Total |  | -181264.4389678055 | -181264.4389678055 | -181264.4389678055 | -181264.4389678055 | -181264.4389678055 | -906322.1948390274
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E0v92q4rt399057s86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hmqfsy!iyknqafkgbr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: larry_campbell__21009__PCB Graphs
Sheet: 63.26B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-03-22 00:00:00 |  |  | 27 |  | Sherwood
63.26 B Side |  |  | 2000-04-05 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 9 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 7 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-12 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-26 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-11-08 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-12-13 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 9 |  | Sherwood
 |  |  | 2001-03-14 00:00:00 |  |  | 6 |  | Sherwood
 |  |  | 2001-04-18 00:00:00 |  |  | 3 |  | Sherwood
 |  |  | 2001-06-12 00:00:00 |  |  | 2 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 24222d1214371205-how-to-use-rank-with-2-condition-sample4
Sheet: Sheet1

Rank | Team | Points | Score | [NAME] | Rank Formula
 |  | 17.5 | 12080.66666666667
4 | Team 01 | 21 | 12238 | 147843566.1666667 | 3
2 | Team 02 | 24 | 12137 | 146623471.3333333 | 5
1 | Team 03 | 28 | 12578 | 151951115.3333333 | 1
9 | Team 04 | 14 | 12172 | 147046119.6666667 | 4
10 | Team 05 | 13 | 11971 | 144617888.1666667 | 9
8 | Team 06 | 15 | 12054 | 145620618.5 | 6
7 | Team 07 | 17 | 11845 | 143095794.1666667 | 11
11 | Team 08 | 10 | 11740 | 141827201.6666667 | 12
3 | Team 09 | 23 | 12345 | 149136232.5 | 2
5 | Team 10 | 18 | 11981 | 144738782.3333333 | 8
5 | Team 11 | 18 | 12010 | 145089121.6666667 | 7
12 | Team 12 | 9 | 11897 | 143723848.8333333 | 10
Spreadsheet: 41313d1239801231-working-with-lookups-lookup-macro-1
Sheet: Result day 3

Macro produces this from vlookup
Day 3
Date | Ref | Mem No. | Name | Amount to  Release |  | Amount Received
2009-04-15 00:00:00 | TW000927 |  |  |  |  | 96.8
2009-04-15 00:00:00 | N0000031 |  |  |  |  | 82.48
2009-04-15 00:00:00 | JS000014 |  |  |  |  | 71.74
Spreadsheet: 270337d1381440760-percentage-formulas-percent-calculation-for-accrued-time
Sheet: Sheet1

 | % Time | Monthly | Yearly | [NAME]
 | 100 | 1.7 | 20 | 35
 | 80 | 1.36 | 16 | 28
 | 60 | 1.02 | 12 | 21
 | 50 | 0.85 | 10 | 17.5
 | 40 | 0.68 | 8 | 14
 | 30 | 0.51 | 6 | 10.5
 | 20 | 0.34 | 4 | 7
 | 10 | 0.17 | 2 | 3.5
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: BUG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  BUG
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -445551 | 13613205 |  |  |  | -182019
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5863953 | -11874313
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  | 1112 |  | 37 |  | -984
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  | -6440 | -16358
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  | 6440 | 15173 |  |  | 6309504 | 14865191
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87197
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  | 28287
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 204273ee-ccac-4339-afd9-b273d132c95b
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
 | 6345.0 Labour Price Index, Australia
 | Table 4a. Total Hourly Rates of Pay Excluding Bonuses: Public Sector by State, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Public ;  All industries ; |  |  | Original | A2704472W | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  Public ;  All industries ; |  |  | Original | A2706334K | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  Public ;  All industries ; |  |  | Original | A2704738V | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  Public ;  All industries ; |  |  | Original | A2706600R | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  Public ;  All industries ; |  |  | Original | A2706068F | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  Public ;  All industries ; |  |  | Original | A2705004A | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  Public ;  All industries ; |  |  | Original | A2705802V | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Public ;  All industries ; |  |  | Original | A2705536R | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Public ;  All industries ; |  |  | Original | A2705270T | 1998-06-01 00:00:00 | 2011-06-01 00:00:00 | 14 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2012
Spreadsheet: 36132d1233888095-only-count-a-cell-filled-in-with-color-colorsum
Sheet: Sheet1

FRIDAY |  |  | `
[NAME] | 43205
NUTTAL | 78429
MONDAY
COX | 88468
SMITH | 29995
TUESDAY |  |  | Added a function called SUMCOLOR. Simply point to a cell with the color you want
PAYNE | 28815 |  | to sum by, then the range of cells to sum. You had multiple colors here, so I used the
WEDNESDAY |  |  | function on B21 instead and subtracted THAT from the sum of the whole colum in B20.
SEATH | 13950
GEDDES | 145564 |  | MAIN PROBLEM: Excel deeems color cell changes to be insignificant and does not
THURSDAY |  |  | recalculate the sheet based on changes made to background colors. Further, pressing
BILLIMOORE | 117000 |  | F9 to force a recalc on the sheet STILL won't get your SUMCOLOR function cells to update.
HOBAN | 87000 |  | Therefore, they will usually be wrong after you've activated them.
VINNICOMBE | 109150
FRIDAY |  |  | You will have to edit the SUMCOLOR cell and press ENTER to get the cells to update. On this sheet, the only
HAMBLIN | 78097 |  | cell using the SUMCOLOR is B21, so you'll need to force that cell to update regularly.
ENGLEFIELD | 80760
Shaded Total | 369579
Unshaded Total | 530854
Total | 900433
Spreadsheet: 118865d1314060822-changing-colors-on-columns-and-showing-expired-when-0-is-reached-ddc4exm
Sheet: Sheet1

LAST NAME | FIRST NAME | WEST COAST | MWS | EAST COAST | INSTRUCTOR | DATE COMPLETED | EXPIRES | DAYS TO RENEW
RAMIREZ | SAM | X |  |  | ORR | 2010-12-02 00:00:00
NEAL | BOB |  | X |  | JR | 2008-08-23 00:00:00
BLOW | JOE | X |  |  | ORR | 2010-01-23 00:00:00
Spreadsheet: 168905d1342627771-pivot-table-excel-2003-suppress-zero-values-testpivot
Sheet: Sheet1

DateRange | DataRange
2000-01-31 00:00:00 | 10
2001-01-31 00:00:00 | 100
2001-01-31 00:00:00 | -100
2002-01-31 00:00:00 | 2000
2002-01-31 00:00:00 | 2000
2002-01-31 00:00:00 | -2000
2003-01-31 00:00:00 | 30000
2003-01-31 00:00:00 | -30000 |  | CURRENT PIVOT TABLE |  |  |  | DESIRED DISPLAY:
 |  |  | Sum of Field1 |  |  |  | Sum of Field1
 |  |  | DateRange | Total |  |  | DateRange | Total
 |  |  | 2000-01-31 00:00:00 | 10 |  |  | 2000-01-31 00:00:00 | 10
 |  |  | 2001-01-31 00:00:00 | 0 |  |  | 2002-01-31 00:00:00 | 2000
 |  |  | 2002-01-31 00:00:00 | 2000 |  |  | Grand Total | 2010
 |  |  | 2003-01-31 00:00:00 | 0
 |  |  | Grand Total | 2010
Spreadsheet: 468009d1467099837-combining-data-from-one-table-into-a-new-table-example-ic52-form-i-may-2016-new
Sheet: FORM I

 |  |  |  |  | TIMETABLE TRIPS
Route | BU | From | To | Route
no. |  |  |  | length
1 |  | 2 | 3 | 4 | MON | TUE | WED | THU | FRI | SAT | SUN
410020 | 41 | VALSCHFONTEIN "C". | MARABASTAD. | 130 | 1 | 1 | 1 | 1 | 1 | 0 | 0
410023 | 41 | MARABASTAD. | RAMOKGELETSANE. | 138 | 4 | 4 | 4 | 4 | 4 | 4 | 4
410025 | 41 | MARABASTAD. | WATERVAL NEW STANDS. | 134 | 6 | 6 | 6 | 6 | 6 | 2 | 0
410026 | 41 | WOLWEKRAAL. | BIG TREE. | 59 | 1 | 0 | 0 | 0 | 0 | 0 | 0
410027 | 41 | MARABASTAD. | RAMOKGELETSANE. | 139 | 1 | 1 | 1 | 1 | 1 | 1 | 0
410031 | 41 | WELTEVREDE. | MARABASTAD. | 136 | 1 | 0 | 0 | 0 | 0 | 0 | 0
410032 | 41 | MARABASTAD. | VAALBANK. | 128 | 0 | 0 | 0 | 0 | 1 | 0 | 0
410033 | 41 | RAMOKGELETSANE. | MARABASTAD. | 146 | 5 | 5 | 5 | 5 | 5 | 0 | 0
410034 | 41 | PIETERSKRAAL "A". | MARABASTAD. | 141.3 | 1 | 1 | 1 | 1 | 1 | 0 | 0
410037 | 41 | WATERVAL. | BIG TREE. | 72 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 769e8da1-1a7a-4d11-b116-f804c1f2b081
Sheet: Sheet1

Unnamed: 0 | LUTHERAN THEOLOGICAL SEMINARY AT GETTYSBURG | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  | JAN  2014  REGISTRATION
 |  |  |  | [NAME]: Jan 3-28 |  |  |  | REGISTRATION
 |  |  |  |  |  |  |  | OPENS SEPT 30
 | [NAME]: |  |  |  |  |  |  | $50 late fee
 |  |  |  |  |  |  |  | after Nov. 15
DEGREE PROGRAM: |  |  |  |  |  |  |  | for continuing students
[NAME] (if not @ltsg.edu): |  |  |  |  |  |  | DATE:
 |  |  | JANUARY 2014 TOTAL CREDITS REGISTERED
 |  |  | (PLEASE ENTER TOTAL)
 |  |  |  |  |  |  | Office Use Only:
 |  |  |  |  |  |  | Received:
ADVISOR'S SIGNATURE: |  |  |  |  |  |  | Blackbaud:
 |  |  |  |  |  |  | Business:
More than 3 credits, DEAN'S SIGNATURE: |  |  |  |  |  |  | Tech:
NOTE: All bills (Business Office and Bookstore) must be paid before students are allowed to register.
 |  |  |  | See course descriptions and class grid at www.ltsg.edu/departments/registrar.aspx
 | Please indicate grade choice for each course with LTR or PF; default is PF
REGISTER | GRADE |  |  |  |  |  |  | See class grid for times
WITH X | CHOICE | # [NAME] |  |  |  | PROFESSOR | DATES
 |  | 3 | 2.310 | Theology of [NAME], Jr |  | [NAME] |  | 21-25
 |  | 1.5 | 3.700 | Introduction to Preaching |  | [NAME] |  | 3,6-8
FULL |  | 3 | 3.722 | Preaching and Pastoral Care: |  | [NAME] |  | 13-17
 |  |  |  | Weddings, Funerals, and Baptisms
 |  | 3 | 4.204 | Diaconal Ministry |  | Oldenburg |  | 5-16
 |  |  |  | Formation Event
 | PF | 1.5 | 4.301- | Multicultural |  | Largen
 |  |  |  | Write in appropriate course number from multicultural brochure
 |  | 1.5 | 4.314 | Middle East Trip |  | Hoffman/ |  | 6-21
 |  |  |  |  |  | [NAME]
 |  | 3 | 4.400 | MAR Keynote |  | Largen/ |  | 5-11
 |  |  |  |  |  | [NAME]
 |  | 3 | 4.401 | Religion and 21st c. Media |  | Tombers/Shafer |  | 13-17
 | LTR | 3 | 6.217 | Conservative Reaction in Churches |  | Erling |  | 13-17
 |  |  | STM | MDiv, MAMS, MAR students need instructor's permission
 | PF | 0 | J-Term HR | Anti-Racism (Human Relations) |  | tba |  | 28-29
 |  |  |  | Workshop
 | NO | 0 | J-Term SR | Senior Seminar: Setting up House |  | tba |  | 28-29
 | GRADE |  |  | in Ministry
 |  |  |  |  |  |  |  | Use space on the back for a course at WTC or other ELCA seminary (send electronic version of  cross-registration form)
 |  |  |  | or Independent Study (requires ROSA)
RETURN TO REGISTRAR'S OFFICE
QUESTIONS? ASK JULIE RITTER AT [EMAIL] or [PHONE]
 |  | OR DR. [NAME] AT [EMAIL] or [PHONE]
Spreadsheet: 704383d1605528671-formula-to-find-the-non-zero-values-with-conditions-example1-ans
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3
X | PL | 20
X | PL | 0
X | MT | 20
X | MT | 30
Y | PL | 0
Y | MT | 0
Z | PL | 5 |  | 1
Z | MT | 5
B | PL | 2 |  | 1
B | MT | 2
A | PL | 20 |  | 1
A | MT | 20
Z | PL | 0
Z | MT | 0
Z | PL | 2
Z | MT | 2
D | PL | 0
D | MT | 0
D | PL | 30 |  | 1
D | MT | 30
 | Result | 5 | it should give me the count
Requirement is |  | [NAME] which is not equal to zero
 |  | [NAME] which is equal to PL
 |  | Criteria eliminate the duplicaes if the above two coniditions matched
 | [NAME] result
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 5

 | October 25 | November 1 | November 8 | 2013-11-22 00:00:00 | November 22
Total Interest Rate* | 1141660 | 1484497 | 1819403 | 1507268 | 1466600
Cleared** | 911102 | 989537 | 1253147 | 766977 | 900163
Uncleared | 230559 | 494960 | 566256 | 740291 | 566437
Total Cross-Currency | 36196 | 50573 | 80810 | 50439 | 84095
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 36196 | 50573 | 80810 | 50439 | 84095
Total Credit | 328601 | 365723 | 382244 | 304204 | 446519
Cleared | 204681 | 180847 | 197091 | 168358 | 233694
Uncleared | 123921 | 184877 | 185153 | 135846 | 212825
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 1506458 | 1900794 | 2282457 | 1861911 | 1997214
Weekly total, swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects the notional value of the creation of only one of the two swaps that results from the clearing process. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 78439d1278787756-reorganize-a-data-set-map01
Sheet: Blad1

This is the dataset I currently have
 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993
Company A | 3.5452 | 4.101 | 5.3319 | 5.8764 | 6.058000000000001 | 8.4857 | 10.9815
Company B | 16.0985 | 14.0862 | 16.501 | 12.8057 | 15.0375 | 16.19 | 19.6658
Company C | 82.3191 | 90.74260000000001 | 96.65520000000001 | 80.3191 | 65.9342 | 50.1427 | 48.4637
Company D | 2.6339 | 3.0475 | 4.1407 | 5.105 | 5.604200000000001 | 5.8719 | 7.9865
This is how I need the data to be organized (without the colours)
1987 | 3.5452
1987 | 16.0985
1987 | 82.3191
1987 | 2.6339
1988 | 4.101
1988 | 14.0862
1988 | 90.74260000000001
1988 | 3.0475
1989 | 5.3319
1989 | 16.501
1989 | 96.65520000000001
1989 | 4.1407
 | etc…
Spreadsheet: 821047d1678409096-job-task-rotation-formula-possibilities-book1-swit-
Sheet: Sheet1

Person | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Person1 |  |  |  |  |  |  | 0 | Two person task
Person2 |  |  |  |  |  |  | 1 | One person task #1
Person3 |  |  |  |  |  |  | 2 | One person task #2
Person4 |  |  |  |  |  |  | 3 | One person task #3
Person5 |  |  |  |  |  |  | 4 | One person task #4
Person6 |  |  |  |  |  |  | 7 | One person task #5
Person7