tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 137776d1327353397-formatting-test-2
Sheet: Sheet1

 |  | [NAME] OF QUANTITIES
 |  | Project:
 |  | Date:
 |  | Client:
No. | Item | Unit | Qty | Rate | Total
 | SECTIONS
 | CEILINGS - PARTITIONS - EXTERNAL WORKS - CARPENTRY - ADDENDUMS
 | *NOTE - Green star requirements for timber, adhesives and insulation. No
 | requirements for plasterboard.
 | CEILINGS
 | CLG1 - Exposed grid 1200 x 600 [NAME] SE tile with Peakform 24[NAME] exposed Tee grid
1 | Levels 1 - 11 height 2.7m | m2 | 16443.2
 | GLG2 - Suspended flush set 13mm pb ceiling
2 | GF height 8.0m | m2 | 43.1
3 | Levels 1 - 11 height 2.7m | m2 | 387.9
 | GLG3 - Suspended flush set 13mm water resistant pb ceiling
4 | B1 - L11 height 2.4m | m2 | 583.2
 | CLG5 - Ceiling recesses
5 | Excluded not on plans
 | [NAME] ceiling panels
6 | Excluded
 | TIM1 - Feature timber ceiling 68mm x 19[NAME] timber cladding expression burnt ash. Fixed to suspended grid/timber frame. Typical section D2/AC4652
7 | GF lobby height 8.0m | m2 | 26.1
 | Total Excluding GST:
Spreadsheet: chris_germany__1987__6-12-02 Gas Cash
Sheet: Log

5 Day Rolling Cash Forecast:  Payment Log as of Jun-12-02
Payment Date | Amount | Deal Name | Counterparty | Commercial Contact | Transaction Description
2002-06-18 00:00:00 | -2371234.02 | Citrus | Citrus | [NAME]/[NAME] | Phys | Payment related to gas purchases.  Payment day changed, and will keep being pushed back until further notice.
2002-06-17 00:00:00 | -14571 | Dominion | Dominion Energy | [NAME] | Phys | Payment for 4,793 dth received in Feb 02.  Deal #30468.  Payment day changed to Monday.
Spreadsheet: 95307d1294926295-problem-with-pivot-table-top-10-filter-pvtheaders-1-
Sheet: Commodity Analysis

 | Period | (Multiple Items) |  |  |  |  | Period | (Multiple Items)
 | Sum of Tons | Column Labels |  |  |  |  | Sum of Tons | Column Labels
 | Commodity | FY2011, YTD | FY2010, YTD | [NAME] | % Inc/Dec |  | Row Labels | 2011 | 2010 | Grand Total
 | PHOSPHATE | 593248.79 | 518889.95 | 74358.84000000003 | 0.1433036812526433 |  | PHOSPHATE | 593248.79 | 518889.95 | 1112138.74
 | SULFUR PRODUCTS | 69894.88 | 176839 | -106944.12 | -0.6047541549092678 |  | SULFUR PRODUCTS | 69894.88 | 176839 | 246733.88
 | RUBBER | 48307.54000000001 | 35424.58 | 12882.96000000001 | 0.3636729073428677 |  | RUBBER | 48307.54000000001 | 35424.58 | 83732.12000000001
 | SCRAP STEEL PRODUCTS | 38529.62 | 29248 | 9281.620000000003 | 0.3173420404814005 |  | SCRAP STEEL PRODUCTS | 38529.62 | 29248 | 67777.62
 | ORE, MICA, SCHIST | 23148.3 |  | 23148.3 | N/A |  | ORE, MICA, SCHIST | 23148.3 |  | 23148.3
 | METAL PRODUCTS (EXCL SCRAP) | 21924.01 | 12169.65 | 9754.359999999999 | 0.8015316792183833 |  | METAL PRODUCTS (EXCL SCRAP) | 21924.01 | 12169.65 | 34093.66
 | OTHER BULK | 15728.49 |  | 15728.49 | N/A |  | OTHER BULK | 15728.49 |  | 15728.49
 | MILITARY | 2939.14 | 612 | 2327.14 | 3.802516339869281 |  | MILITARY | 2939.14 | 612 | 3551.14
 | FOREST PRODUCTS | 1134.02 | 7518.530000000001 | -6384.51 | -0.8491699840261328 |  | FOREST PRODUCTS | 1134.02 | 7518.530000000001 | 8652.550000000001
 | OTHER BREAKBULK | 118.6 | 136.49 | -17.89000000000001 | -0.1310718733973186 |  | OTHER BREAKBULK | 118.6 | 136.49 | 255.09
 | URAN FERTILIZER |  |  | 0 | N/A |  | Grand Total | 814973.3900000001 | 780838.2 | 1595811.59
 | POTASH |  |  | 0 | N/A
 | Total YTD | 814973.3900000001 | 780838.2 | 34135.19000000003 | N/A
 |  |  |  |  |  |  | Hi [NAME]
 |  |  |  |  |  |  | I copied and pasted your data on MHC to Sheet2
 |  |  |  |  |  |  | and did the above pivot table again..
 |  |  |  |  |  |  | Bring up the Field list and click on both [NAME]
 |  |  |  |  |  |  | Why Values shows on mine and not on yours is a mystery to me.
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 41

Uke: | 41 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 780575d1652554933-reference-value-in-another-cell-as-part-of-an-array-kimmorgan-bvj-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Quantity Sum:
Activity Date | Transaction Date | Activity | Description | Symbol/Cusip | Memo | Tags | Quantity | Price($) | Amount($)
 |  | Bought |  |  |  |  | 5 | 2.42 | 10
 |  | Dividend Reinvestment |  |  |  |  | 2 | 2.45 | 10
 |  | Bought |  |  |  |  | 10 | 2.56 | 10
 |  | Dividend Reinvestment |  |  |  |  | 2 | 2.57 | 10
 |  | Bought |  |  |  |  | 15 | 2.52 | 10
 |  | Dividend Reinvestment |  |  |  |  | 2 | 2.51 | 10
Spreadsheet: 876007d1722637588-sorting-between-brackets-detect-characters-in-name
Sheet: Test 1

 |  | in this column it would only show the zone once for the corresponding cluster of zones
 | BB OT - [DA.1] - Nurse - Wing | DA.1 shows up here
DA.1 | C OT - [DA.1] - Nurse | nothing to show here
DA.1 | CB OT - [DA.1] - Nurse - Core | nothing to show here
DA.1 | CZ OT - [DA.1] - Nurse | nothing to show here
DA.1 | Z OT - [DA.1] - Nurse | nothing to show here
FA.11 | B Partial - [FA.11] - Nurse | FA.11 then shows up here as it is the next group from column A
FA.11 | C Partial - [FA.11]  Nurse - Core | nothing to show here
QA.21 | A PM - [QA.21] - Nurse | QA.21 then shows up here as it is the next group from column A
RA.1 | A Full - [RA.1] - Nurse | RA.1 then shows up here as it is the next group from column A
ZA.1 | A DTM - [ZA.1] - Nurse | ZA.1 then shows up here as it is the next group from column A
ZA.1 | B DTM - [ZA.1] - Nurse | nothing to show here
ZA.1 | DTM - [ZA.1] - Nurse | nothing to show here
Spreadsheet: 780629d1652625195-vlookup-numbers-vlookup-not-vlookup-aligw
Sheet: Sheet1

Node | Node | Length | Diameter |  | Node | Node | Length | Diameter
1 | 2 | 29 | 90 |  | 1 | 2
2 | 3 | 10 | 90 |  | 3 | 4
3 | 4 | 15 | 63 |  | 3 | 5
3 | 5 | 20 | 63
5 | 6 | 15 | 63
Spreadsheet: 720412d1614149949-need-guidance-as-to-how-to-look-up-values-with-multiple-qualifiers-desertmj-example-for-conditional-formating-re-written
Sheet: Sales by store

 | store | address | city | state | RED | BLUE | ORANGE | PURPLE
 | 1 | 123 Main Drive | [NAME] | NC | A | A | A | A
 | 2 | 345 Town Square | [NAME] | NC | A | O | U | A |  | These would be the results needed,
 | 3 | 678 Cobble Street | [NAME] | NC | A | A | U | U |  | but I don't know how to write the formulas to populate them.
 | 4 | 910 [NAME] | [NAME] | NC | A | A | A | A
 | 5 | 111 Old Pond Road | [NAME] | NC | O | A | O | A
 |  |  |  | Need the cells in the box to show to results of the look ups:
 |  |  |  | "A" authorized
 |  |  |  | "U" unauthorized
 |  |  |  | "O" optional
 |  |  |  | Status is on next page.
Spreadsheet: 221480d1363572819-count-without-repeting-with-condition-countif-without-repeting
Sheet: Sheet1

Item | Qty
apple | 1
mango | 1
apple | 1
cherry | 1
mango | 2
cherry | 2
mango | 2
cherry | 2
mango | 2
cherry | 3
apple | 3
mango | 3
cherry | 3
apple | 3
cherry | 3
 | ??? |  | If I want to count the item without repeting if QTY is 2
count without repeting |  |  | The result should be 2 (Mango and [NAME])
Spreadsheet: kate_symes__18219__EESSales_dailymarch
Sheet: 3-2

NP15 | 2001-03-02 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 267.78 | Fixed Off Peak | 181.22 |  |  |  | Fixed Peak | 251.64 |  | Fixed Off Peak | 172.14 |  |  | Fixed Peak | 251.64 |  | Fixed Off Peak | 172.14
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | -5.52 | 0 | 0 | -5.52 |  |  | 1 | -39.08 | 0 | -14 | -38.08 |  |  | 1 | -2.01 | 0 | 0 | -2.01
2 | -4.55 | 0 | 0 | -4.55 |  |  | 2 | -49.91 | 0 | -14 | -32.91 |  |  | 2 | -1.96 | 0 | 0 | -1.96
3 | -4.2 | 0 | 0 | -4.2 | 0 |  | 3 | -59.16999999999994 | 0 | -14 | -31.17 |  |  | 3 | -1.94 | 0 | 0 | -1.94
4 | -4.14 | 0 | 0 | -4.14 |  |  | 4 | -58.47000000000006 | 0 | -14 | -30.47 |  |  | 4 | -1.94 | 0 | 0 | -1.94
5 | -4.39 | 0 | 0 | -4.39 |  |  | 5 | -49.32 | 0 | -14 | -35.32 |  |  | 5 | -1.95 | 0 | 0 | -1.95
6 | -6.72 | 0 | 0 | -6.72 |  |  | 6 | -27.95999999999994 | 0 | -14 | -31.96 |  |  | 6 | -2.05 | 0 | 0 | -2.05
7 | -10.6 | 0 | 0 | -10.6 |  |  | 7 | -70.93 | 0 | -29 | -60.93 |  |  | 7 | -2.21 | 0 | 0 | -2.21
8 | -12.98 | 0 | 0 | -12.98 |  |  | 8 | -71.72 | 0 | -29 | -72.72 |  |  | 8 | -2.32 | 0 | 0 | -2.32
9 | -13.27 | 0 | 0 | -13.27 |  |  | 9 | -71.36999999999995 | 0 | -29 | -83.37 |  |  | 9 | -2.32 | 0 | 0 | -2.32
10 | -12.17 | 0 | 0 | -12.17 |  |  | 10 | -62.28 | 0 | -29 | -89.28 |  |  | 10 | -2.28 | 0 | 0 | -2.28
11 | -12.17 | 0 | 0 | -12.17 |  |  | 11 | -61.74 | 0 | -29 | -93.74 |  |  | 11 | -2.28 | 0 | 0 | -2.28
12 | -13.21 | 0 | 0 | -13.21 |  |  | 12 | -64.77 | 0 | -29 | -94.77 |  |  | 12 | -2.32 | 0 | 0 | -2.32
13 | -13.08 | 0 | 0 | -13.08 |  |  | 13 | -70.5 | 0 | -29 | -94.5 |  |  | 13 | -2.32 | 0 | 0 | -2.32
14 | -12.72 | 0 | 0 | -12.72 |  |  | 14 | -71.38 | 0 | -29 | -94.38 |  |  | 14 | -2.3 | 0 | 0 | -2.3
15 | -12.33 | 0 | 0 | -12.33 |  |  | 15 | -83.23 | 0 | -29 | -92.23 |  |  | 15 | -2.28 | 0 | 0 | -2.28
16 | -12.23 | 0 | 0 | -12.23 |  |  | 16 | -66.79 | 0 | -29 | -88.79 |  |  | 16 | -2.28 | 0 | 0 | -2.28
17 | -12.35 | 0 | 0 | -12.35 |  |  | 17 | -70.57 | 0 | -29 | -81.57 |  |  | 17 | -2.29 | 0 | 0 | -2.29
18 | -13.8 | 0 | 0 | -13.8 |  |  | 18 | -65.84 | 0 | -29 | -80.84 |  |  | 18 | -2.35 | 0 | 0 | -2.35
19 | -15.87 | 0 | 0 | -15.87 |  |  | 19 | -44.03 | 0 | -29 | -79.03 |  |  | 19 | -2.43 | 0 | 0 | -2.43
20 | -14.01 | 0 | 0 | -14.01 |  |  | 20 | -52.3 | 0 | -29 | -74.3 |  |  | 20 | -2.37 | 0 | 0 | -2.37
21 | -12.48 | 0 | 0 | -12.48 |  |  | 21 | -63.56 | 0 | -29 | -70.56 |  |  | 21 | -2.3 | 0 | 0 | -2.3
22 | -11.23 | 0 | 0 | -11.23 |  |  | 22 | -79.74 | 0 | -29 | -63.74 |  |  | 22 | -2.24 | 0 | 0 | -2.24
23 | -9.48 | 0 | 0 | -9.48 |  |  | 23 | -29.96 | 0 | -14 | -40.96 |  |  | 23 | -2.16 | 0 | 0 | -2.16
24 | -7.51 | 0 | 0 | -7.51 |  |  | 24 | -32.03 | 0 | -14 | -32.03 |  |  | 24 | -2.08 | 0 | 0 | -2.08
Spreadsheet: 774234d1648320800-need-sum-based-on-duplicate-ids-sample-data-gk-v2
Sheet: Required

Year | 2022
Week | 10 |  | Change Week number
Agent | Total Missed | Completed by other | Actual Missed | Declined
AG
AC
BC
B
DY
D
E
G
J
M
O
R
RM
RF
T
TW
Total
Spreadsheet: 798839d1664779944-search-and-count-data-from-different-column-address-checking
Sheet: address

Original Data |  |  | Split data by comma into different columns |  |  |  |  |  |  | Question :How to list Staff ID who address include cell [NAME] and Field B3
Staff ID | Address |  | Address | Address | Address | Address | Address |  |  | Pittsburgh | Teatown Road
A1 | 3211 Temple Ave, Pomoma, CA 12345, US |  | 3211 Temple Ave | Pomoma | CA 12345 | US |  |  |  | A2 | A3
A2 | 48 Fifth Ave, Pittsburgh, PA 999, US |  | 48 Fifth Ave | Pittsburgh | PA 999 | US |  |  |  | A4 | A5
A3 | 159 Teatown Road, Croton-on-Hudson, NY 1111 |  | 159 Teatown Road | Croton-on-Hudson | NY 1111 |  |  |  |  |  | A6
A4 | 46, Fifth Ave, Pittsburgh, PA 999, US |  | 46 | Fifth Ave | Pittsburgh | PA 999 | US |  |  |  | A7
A5 | 888,  Teatown Road, Croton-on-Hudson, NY 1111 |  | 888 | Teatown Road | Croton-on-Hudson | NY 1111
A6 | 999 Teatown Road, Croton-on-Hudson, NY 1111 |  | 999 Teatown Road | Croton-on-Hudson | NY 1111
A7 | 333,  Teatown Road, Croton-on-Hudson, NY 1111 |  | 333 | Teatown Road | Croton-on-Hudson | NY 1111
Spreadsheet: 130184d1322115561-how-to-use-if-formula-for-change-price-copy-of-december
Sheet: 2

 |  |  |  | 2011-12-02 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 842295d1694424376-how-to-return-a-value-based-on-2-criteria-a3-problem-solving-log
Sheet: A3 Presentation

A3 # |  | 23-001 |  |  | Operations Lead |  |  |  |  | Operator |  |  |  |  | Quality Lead |  |  |  |  | Manuf Engineer |  |  |  |  | Supply Chain |  |  |  |  | Design Engineer |  |  |  |  | Area |  |  |  |  | Date Opened
1: DEFINE THE PROBLEM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2: PROTECT THE CUSTOMER
WHAT |  |  |  |  |  |  |  |  |  |  |  |  |  | [INSERT SUPPORTING IMAGES HERE]
WHERE
WHY
WHEN
HOW MANY
3: ROOT CAUSE ANALYSIS
Material |  |  |  |  |  |  |  | Method |  |  |  |  |  |  |  | Machine
A1 |  |  |  |  |  |  |  | B1 |  |  |  |  |  |  |  | C1
A2 |  |  |  |  |  |  |  | B2 |  |  |  |  |  |  |  | C2 |  |  |  |  |  |  |  | 4: CORRECTIVE ACTION
A3 |  |  |  |  |  |  |  | B3 |  |  |  |  |  |  |  | [NAME]
A4 |  |  |  |  |  |  |  | B4 |  |  |  |  |  |  |  | C4
A5 |  |  |  |  |  |  |  | B5 |  |  |  |  |  |  |  | C5
Measurement |  |  |  |  |  |  |  | Man |  |  |  |  |  |  |  | Environment
D1 |  |  |  |  |  |  |  | E1 |  |  |  |  |  |  |  | F1
D2 |  |  |  |  |  |  |  | E2 |  |  |  |  |  |  |  | F2
D3 |  |  |  |  |  |  |  | E3 |  |  |  |  |  |  |  | F3
D4 |  |  |  |  |  |  |  | E4 |  |  |  |  |  |  |  | F4 |  |  |  |  |  |  |  | 5: VERIFICATION OF CORRECTIVE ACTION
D5 |  |  |  |  |  |  |  | E5 |  |  |  |  |  |  |  | F5
Root Cause Summary
Spreadsheet: 838079d1690695555-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample
Sheet: T4

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
4 | Can Do | Player10 |  |  |  |  |  | Week 1
 |  | Player11 |  |  |  |  |  | Week 2
 |  | Player12 |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  | Week 9
 | [NAME] |  | Average |  |  |  |  | Week 10
 |  | Player10 | 99 |  |  |  |  | Week 11
 |  | Player11 | 78 |  |  |  |  | Week 12
 |  | Player12 | 120 |  |  |  |  | Week 13
 |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  | Week 20
 |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  | Week 45
Spreadsheet: larry_campbell__21036__2001 O&M Sched for ETS Sites
Sheet: 2001  O&M Sch (rev 5-14-01)

 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | Totals-thru 1999 |  | 2000 | 2001 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
NNG
NNG Gomez Plant | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41000 | 154000 | 195000 |  | 115000 | 150000 |  | 0 | 0 | 30000 | 10000 | 10000 | 10000 | 40000 | 30000 | 5000 | 5000 | 5000 | 5000
NNG Eunice Station | 0 | 20000 | 0 | 15000 | 95000 | 11000 | 19000 | 12000 | 5000 | 3000 | 180000 |  | 10000 | 5000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0 | 0 | 0
Other NNG Sites-Ama. [NAME]. | 0 | 0 | 0 | 0 | 0 | 0 | 28000 | 24000 | 57000 | 389000 |  |  | 282000 | 80000 |  | 0 | 0 | 0 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 0
Other NNG Sites-Lib. [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 50000 |  | 0 | 0 | 0 | 10000 | 10000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 0
Other NNG Sites-Hol. [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 50000 |  | 0 | 0 | 0 | 10000 | 10000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 0
Other NNG Sites |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 65000 |  | 0 | 0 | 0 | 0 | 0 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 5000
NNG Expense
TW
TW WT-1 Sta. Pit Area | 0 | 0 | 0 | 20000 | 52000 | 34000 | 14000 | 34000 | 32000 | 15000 | 201000 |  | 90000 | 45000 |  | 0 | 0 | 0 | 10000 | 3000 | 3000 | 3000 | 3000 | 3000 | 10000 | 5000 | 5000
TW WT-1 Pit Removal | 0 | 0 | 0 | 20000 | 52000 | 34000 | 14000 | 34000 | 32000 | 15000 | 201000 |  | 0 | 195000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20000 | 100000 | 75000
TW WT-1 Sta. Dehy Area | 0 | 0 | 0 | 25000 | 77000 | 54000 | 68000 | 44000 | 34000 | 61000 | 363000 |  | 40000 | 20000 |  | 0 | 0 | 0 | 4000 | 1000 | 1000 | 1000 | 1000 | 4000 | 1000 | 4000 | 3000
[NAME] | 0 | 30000 | 0 | 80000 | 127000 | 217000 | 308000 | 198000 | 172000 | 97000 | 1229000 |  | 100000 | 80000 |  | 0 | 0 | 0 | 15000 | 5000 | 5000 | 5000 | 20000 | 5000 | 5000 | 10000 | 10000
[NAME] | 0 | 30000 | 0 | 80000 | 127000 | 217000 | 308000 | 198000 | 172000 | 97000 | 1229000 |  | 0 | 510000 |  | 0 | 0 | 0 | 0 | 0 | 10000 | 10000 | 100000 | 300000 | 60000 | 20000 | 10000
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TW Ivanhoe Station | 0 | 0 | 20000 | 45000 | 30000 | 0 | 106000 | 35000 | 52000 | 213000 |  |  | 105000 | 50000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30000 | 20000
TW Expense
Annual ETS Expense
Spreadsheet: 119675d1314647658-vlookup-multiple-2012
Sheet: Routing Guide

20' DV
40' DV
 |  | Origin | Destination | Priority | Carrier 20' | Inland 20' | Ocean 20' | Other | Total 20' | [NAME] | Inland 40' | Ocean 40' | Other | Total 40'
 |  | Chicago | Adelaide | First choice | [NAME] |  | 2730 |  |  | [NAME] |  | 4190
 |  | Chicago | Antwerp | First choice | COSCO | 625 | 1250 |  |  | COSCO | 750 | 1825
 |  | Chicago | Antwerp | Second choice | NYK |  | 1485 |  |  | NYK |  | 1970
 |  | Chicago | Antwerp | Third choice | evergreen | 0 | 2650 |  |  | evergreen | 0 | 3250
 |  | Chicago | Auckland | First choice | Hapag Lloyd | 0 | 1900 |  |  | Hapag Lloyd | 0 | 2925
 |  | Chicago | Auckland | Second choice | [NAME] |  | 2730 |  |  | [NAME] |  | 4190
 |  | Chicago | Bangkok | First choice | COSCO |  | 1695 |  |  | COSCO |  | 2110
 |  | Chicago | Bangkok | Second choice | evergreen | 0 | 1660 |  |  | evergreen | 0 | 2025
 |  | Chicago | Barcelona | First choice | Hapag Lloyd |  | 1810 |  |  | Hapag Lloyd |  | 2400
 |  | Chicago | Bremerhaven | First choice | COSCO | 625 | 1250 |  |  | COSCO | 750 | 1825
 |  | Chicago | Bremerhaven | Second choice | NYK |  | 1485 |  |  | NYK |  | 1970
 |  | Chicago | Bremerhaven | Third choice | evergreen |  | 2650 |  |  | evergreen |  | 3250
 |  | Chicago | Brisbane | First choice | Hapag Lloyd |  | 200 |  |  | Hapag Lloyd |  | 400
 |  | Chicago | Buenaventura | First choice | evergreen |  | 2550 |  |  | evergreen |  | 4000
 |  | Chicago | [NAME] | First choice | [NAME] |  | 1800 |  |  | [NAME] |  | 2925
 |  | Chicago | [NAME] | Second choice | Hapag Lloyd |  | 2400 |  |  | Hapag Lloyd |  | 2500
 |  | Chicago | Busan | First choice | COSCO |  | 1635 |  |  | COSCO |  | 1885
 |  | Chicago | Busan | Second choice | evergreen | 0 | 1540 |  |  | evergreen | 0 | 1875
 |  | Chicago | Busan | Third choice | NYK |  | 1680 |  |  | NYK |  | 2000
 |  | Chicago | Busan | Fourth choice | Hapag Lloyd |  | 2100 |  |  | Hapag Lloyd |  | 2500
 |  | Chicago | Callao | First choice | CCNI |  | 2014 |  |  | CCNI |  | 3128
 |  | Chicago | Callao | Second choice | [NAME] |  | 2150 |  |  | [NAME] |  | 3100
 |  | Chicago | Callao | Third choice | evergreen |  | 2550 |  |  | evergreen |  | 4000
 |  | Chicago | [NAME] | First choice | evergreen |  | 1800 |  |  | evergreen |  | 2550
 |  | Chicago | [NAME] | Second choice | CCNI |  | 1875 |  |  | CCNI |  | 3450
Spreadsheet: 111093b5-8c6f-4afd-bf6d-db6c33421413
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
 | 8731.0 Building Approvals, Australia
 | TABLE 85. Value of Building Approved, Chain Volume Measures, Original - Northern Territory
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
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  Houses ;  New ; |  |  | Original | A590537T | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  Total Other Residential ;  New ; |  |  | Original | A590538V | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME] ;  New ; |  |  | Original | A590539W | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME] ;  Alterations and additions including conversions ; |  |  | Original | A590540F | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME] ;  Total Work ; |  |  | Original | A590541J | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME]-residential ;  Total Work ; |  |  | Original | A590542K | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  Total (Type of Building) ;  Total Work ; |  |  | Original | A590543L | 1985-09-01 00:00:00 | 2013-09-01 00:00:00 | 113 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: b1ca5c51-11bb-4483-a40e-32bc887aaf05
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42879575 | 2014-08-25 21:22:39 | ALLIES | 1 | 5 | 3 | 509176 | arsenal94 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42879937 | 2014-08-25 21:47:05 | AXIS | 0 | 1 | 5 | 509176 | arsenal94 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42935275 | 2014-08-29 22:01:43 | AXIS | 0 | 5 | 7 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42935523 | 2014-08-29 22:12:22 | ALLIES | 0 | 3 | 7 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 714673d1611325907-calculating-number-totals-by-week-with-split-of-days-example-help
Sheet: Table1

Column1 | Week4 | Week5 | Week6
1 | 8 | 10 | 6
2 | 12 | 15 | 12
3 | 4 | 5 | 6
4 |  | 5
5 | 16 | 10