tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 267767d1380197211-highlighting-passed-dates-based-on-a-negative-figure-contraload-deliveries-into-purfleet
Sheet: Dispatches made

 | Unilever Purfleet Deliveries
 | Delivery Date | Order Reference | Tool | No. Pallets | Date Processed on website
 | 2013-08-13 00:00:00 | 13/0015/51 | 13985 | 22 | 2013-08-14 00:00:00
 | 2013-08-13 00:00:00 | 13/0707/17 | 14138 | 3 | 2013-08-14 00:00:00
 | 2013-08-13 00:00:00 | 13/0708/11 | 14139 | 1 | 2013-08-14 00:00:00 |  | Product Description
 | 2013-08-16 00:00:00 | 13/0707/18 | 14138 | 2 | 2013-08-16 00:00:00
 | 2013-08-16 00:00:00 | 13/0015/53 | 13985 | 23 | 2013-08-16 00:00:00 |  | Contact: [NAME]
 | 2013-08-16 00:00:00 | 13/0708/12 | 14139 | 1 | 2013-08-16 00:00:00 |  | [EMAIL]
 | 2013-08-23 00:00:00 | 13/0015/54 | 13985 | 22 | 2013-08-27 00:00:00
 | 2013-08-23 00:00:00 | 13/0707/19 | 14138 | 4 | 2013-08-27 00:00:00 |  | webiste: | http://www.pool-it.net/Logon.aspx?event=LogOff
 | 2013-08-27 00:00:00 | 13/0015/55 | 13985 | 26 | 2013-08-28 00:00:00
 | 2013-08-28 00:00:00 | 13/0015/56 | 13985 | 25 | 2013-08-28 00:00:00 |  | Username: | jakem
 | 2013-08-28 00:00:00 | 13/0707/20 | 14138 | 1 | 2013-08-28 00:00:00 |  | Password: | cld040613
 | 2013-09-04 00:00:00 | 13/0707/21 | 14138 | 3 | 2013-09-04 00:00:00
 | 2013-09-04 00:00:00 | 13/0015/57 | 13985 | 2 | 2013-09-04 00:00:00
 | 2013-09-04 00:00:00 | 13/0015/57 | 13985 | 21 | 2013-09-04 00:00:00 |  | Total into Unilever
 | 2013-09-06 00:00:00 | 13/0707/22 | 14138 | 5 | 2013-09-06 00:00:00
 | 2013-09-06 00:00:00 | 13/0015/58 | 13985 | 21 | 2013-09-06 00:00:00
 | 2013-09-11 00:00:00 | 13/0707/23 | 14138 | 3 | 2013-09-11 00:00:00 |  | To Declare Pallets
 | 2013-09-11 00:00:00 | 13/0015/59 | 13985 | 23 | 2013-09-11 00:00:00
 | 2013-09-20 00:00:00 | 13/0015/60 | 13985 | 23 | 2013-09-20 00:00:00 |  | Logon
 | 2013-09-20 00:00:00 | 13/0707/24 | 14138 | 3 | 2013-09-20 00:00:00 |  | Click 'Declare'
 | 2013-09-24 00:00:00 | 13/0707/25 | 14138 | 2 | 2013-09-24 00:00:00 |  | Click magnifying glass next to 'Location 2'
 | 2013-09-24 00:00:00 | 13/0015/61 | 13985 | 24 | 2013-09-24 00:00:00 |  | Press Select
 |  |  |  |  |  |  | In 'Reference' enter [NAME] Number from Delivery Note
 |  |  |  |  |  |  | In '[NAME]' enter number of pallets sent applicable to that DN number
 |  |  |  |  |  |  | In External Notes enter [NAME], Our Order Number, Order Reference and Part Number (all located on DN notes)
 |  |  |  |  |  |  | Save
 |  |  |  |  |  |  | Logoff when finished
Spreadsheet: 809442d1671094534-combining-if-and-vlookup-functions-scoring-sheet
Sheet: Scoring Standards

< 30 BMI |  |  | >= 30 BMI
Push Up # (2mins) | Score % |  | Push Up # (2mins) | Score %
>=30 | 1 |  | 13 | 1
29 | 0.96 |  | 12 | 0.95
28 | 0.92 |  | 11 | 0.9
27 | 0.88 |  | 10 | 0.85 |  |  |  |  | 12
26 | 0.84 |  | 9 | 0.8 |  |  |  |  | 11
25 | 0.8 |  | 8 | 0.75 |  |  |  |  | 10
24 | 0.76 |  | 7 | 0.7 |  |  |  |  | 9
23 | 0.72 |  | 6 | 0.65 |  |  |  |  | 8
22 | 0.68 |  | 5 | 0.6 |  |  |  |  | 7
21 | 0.64 |  | 4 | 0.5 |  |  |  |  | 6
20 | 0.6 |  | 3 | 0.4 |  |  |  |  | 5
19 | 0.56 |  | 2 | 0.3 |  |  |  |  | 4
18 | 0.52 |  | 1 | 0.2 |  |  |  |  | 3
17 | 0.48 |  | 0 | 0 |  |  |  |  | 2
16 | 0.44 |  |  |  |  |  |  |  | 1
15 | 0.4 |  |  |  |  |  |  |  | 0
14 | 0.36
13 | 0.32
12 | 0.28
11 | 0.24
10 | 0.2
9 | 0.18
8 | 0.16
7 | 0.14
6 | 0.12
5 | 0.1
4 | 0.08
3 | 0.06
2 | 0.04
1 | 0.02
0 | 0
Spreadsheet: 40094d1238429220-move-data-between-sheets-by-specifing-certain-criteria-order
Sheet: Sheet1

!15312! | WINSTON LT. BOX | 10 | PK | 1
!1525! | WINSTON SELECT BOX KS | 10 | PK | 1
!1257! | WINSTON SELECT LT BOX | 10 | PK | 1
!3827! | WINSTON SELECT SLIM LT 100 | 10 | PK | 1
!1522! | WINSTON ULTRA | 10 | PK | 1
!1529! | WINSTON ULTRA BOX KING | 10 | PK | 1
!2389! | WINSTON ULTRA 100 BOX | 10 | PK | 1
!3282! | WINSTON 100 | 10 | PK | 1
!144231! | WINSTON 100 BOX | 10 | PK | 1
!3832! | WINSTON 100 LIGHT | 10 | PK | 1
!385! | WINSTON 100 LT BOX | 10 | PK | 1
!3824! | WINSTON 100 ULTRA | 10 | PK | 1
!421! | BASIC FF BOX | 10 | PK | 2
!4217! | BASIC FF KING | 10 | PK | 2
!422! | BASIC FF MEN BOX | 10 | PK | 2
!104273! | BASIC FF MEN 100 | 10 | PK | 2
!416! | BASIC FF MENTHOL | 10 | PK | 2
!4721! | BASIC FF 100 | 10 | PK | 2
!472! | BASIC FF 100 BOX | 10 | PK | 2
!4125! | BASIC LT | 10 | PK | 2
!420! | BASIC LT BOX | 10 | PK | 2
!4218! | BASIC LT MENTHOL | 10 | PK | 2
!4924! | BASIC LT MENTHOL 100 | 10 | PK | 2
!4710! | BASIC LT 100 | 10 | PK | 2
!4713! | BASIC LT 100 BOX | 10 | PK | 2
!4295! | BASIC NON-FILTER | 10 | PK | 2
!1260! | CANNONBALL 12 PLUGS | 12 | PK | 4
!1261! | CUP PLUG  15 PLUGS | 15 | PK | 4
!1266! | DAYS WORK  15 PLUGS | 15 | PK | 4
!1275! | LEVI GARRETT 12 PLUGS | 12 | PK | 4
!1284! | NATURAL LEAF 15 PLUGS | 15 | PK | 4
Spreadsheet: 771322d1646626874-truncating-text-in-a-cell-but-only-whole-words-revised-truncating-names-within-excel-example-workbook
Sheet: Test

Number of Characters
Number of Characters
 |  | FULL NAME | NAME - Part 1 (35 Characters Limitation) | NAME - Part 2 (35 Characters Limitation) | NAME - Part 2 (35 Characters Limitation)
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 669535d1585437670-count-longest-unbeaten-run-unbeaten-run
Sheet: Sheet1

No | Outcome (W/D/L) | Outcome (Home/Away)
1 | W | H
2 | W | A |  |  |  |  |  |  | Key
3 | D | D |  |  |  |  |  |  | Letter | Outcome
4 | W | H |  |  |  |  |  |  | W | Win
5 | L | A |  | Longest Winning Run | Longest [NAME] |  |  |  | D | Draw
6 | D | D |  |  |  |  |  |  | L | Loss
7 | W | A |  |  |  |  |  |  | H | Home
8 | L | A |  | Longest Home Winning Run |  |  |  |  | A | Away
9 | W | H
10 | W | A
11 | W | H
12 | D | D
13 | W | H
14 | W | A
15 | W | H
16 | W | H
17
18
19
20
Spreadsheet: 342836d1409696050-event-calendar-with-recurring-event-140902_-calendar-of-events-2014-_-test
Sheet: Event Calendar - JAN 15

 |  |  |  | EVENT CALENDAR
 |  |  |  |  |  | ENTER MONTH: | January
 |  |  |  |  |  | ENTER YEAR: | 2015
 |  |  |  |  |  | ENTER START DAY: | Sunday
 | TO EVENT LIST >>
Spreadsheet: michelle_lokay__26642__RedRockNPVContracts
Sheet: NPV

Transwestern Pipeline Company
Red Rock Expanion
Contracts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
BP Energy
BP Energy
US Gypsum
Oneok
Annual Contracts
Discount Rate | 0 | 0.075 | 0.15
Shipper | NPV @ 0% | NPV @ 7.5% | NPV @ 15% | Per Unit (7.5% NPV) | Gross Value | Term (Yrs) | Term (Months) | Term (Days) | Volume | Rate -1Yr | Rate -2Yr | Rate -3Yr | Rate -4Yr | Rate -5Yr | 2002-06-01 00:00:00 | 2003-06-01 00:00:00 | 2004-06-01 00:00:00 | 2005-06-01 00:00:00 | 2006-06-01 00:00:00 | 2007-06-01 00:00:00 | 2008-06-01 00:00:00 | 2009-06-01 00:00:00 | 2010-06-01 00:00:00 | 2011-06-01 00:00:00 | 2012-06-01 00:00:00 | 2013-06-01 00:00:00 | 2014-06-01 00:00:00 | 2015-06-01 00:00:00 | 2016-06-01 00:00:00 | 2017-06-01 00:00:00 | 2018-06-01 00:00:00 | 2019-06-01 00:00:00 | 2020-06-01 00:00:00 | 2021-06-01 00:00:00 | 2022-06-01 00:00:00 | 2023-06-01 00:00:00 | 2024-06-01 00:00:00 | 2025-06-01 00:00:00 | 2026-06-01 00:00:00 | 2027-06-01 00:00:00 | 2028-06-01 00:00:00 | 2029-06-01 00:00:00 | 2030-06-01 00:00:00 | 2031-06-01 00:00:00 | 1931-07-01 00:00:00
PPL |  |  |  |  |  | 30Yrs, 1 Month | 361 |  | 8000 | 0.35
PPL |  |  |  |  |  | 30Yrs, 1 Month | 361 |  | 12000 | 0.4
Western |  |  |  |  |  | 15 |  |  | 5000 | 0.38
Western |  |  |  |  |  | 15 |  |  | 5000 | 0.39
Dyergy |  |  |  |  |  | 5 |  |  | 30000 | 0.55
[NAME] |  |  |  |  |  | 5 |  |  | 50000 | 0.63
AEP |  |  |  |  |  | 2 |  |  | 20000 | 0.63
AEP |  |  |  |  |  | 1 |  |  | 10000 | 0.63
Oneok |  |  |  |  |  | 1Yr, 10 Months | 22 |  | 50000 | 1.75 | 0.75
Calpine |  |  |  |  |  | 15 |  |  | 40000 | 0.38
US Gypsum |  |  |  |  |  | 12 Yrs, 3Months | 147 |  | 4500 | 0.42
Conoco |  |  |  |  |  | 2 |  |  | 50000 | 0.84
Conoco Canada |  |  |  |  |  | 2 |  |  | 50000 | 0.84
Conoco Lobo |  |  |  |  |  | 2 |  |  | 50000 | 0.84
Conoco Lobo |  |  |  |  |  | 2 |  |  | 50000 | 0.81
Conoco Raptor |  |  |  |  |  | 2 |  |  | 50000 | 0.81
Conoco Raptor |  |  |  |  |  | 2 |  |  | 50000 | 0.84
BP Energy |  |  |  |  |  | 5 |  |  | 15000 | 1.12 | 0.76 | 0.43 | 0.38 | 0.38
BP Energy |  |  |  |  |  | 1 |  |  | 50000 | 1.723 | 0.364 | 0.2045 | 0.2009 | 0.2012
[NAME] |  |  |  |  |  | 15 |  |  | 2700 | 0.38
[NAME] |  |  |  |  |  | 1 |  |  | 3300 | 2.2
[NAME] |  |  |  |  |  | 1 |  |  | 2000 | 2.2
Newark Group |  |  |  |  |  | 5 |  |  | 800 | 0.65
Newark Group |  |  |  |  |  | 5 |  |  | 1500 | 0.15
Total
Spreadsheet: judy_townsend__17724__Spinnake03-002 Revision_1
Sheet: VERM 84

 | SPINNAKER EXPLORATION COMPANY, L.L.C.
 | VERMILION 84
 | BASELOAD VOLUME:
 | EXCESS VOLUME ABOVE:
 | BASELOAD MINIMUM: |  |  |  | VOLUME | TRCO ZN 3 |  |  | BTU
 |  |  |  |  | BELOW | GAS DAILY |  |  | FACTOR
 |  |  | BASELOAD | EXCESS | BASELOAD | MID POINT $ |  | KEEP WHOLE | of
 |  | ACTUALS |  | VOLUME | MINIMUM | LESS T&E/FUEL |  | AMOUNT | 1.021
 | 2001-03-01 00:00:00 | 2287
 |  | 2931
 |  | 2940
 |  | 4125
 |  | 4125
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2791
 |  | 2729
 |  | 2712
 |  | 2791
 |  | 2805
 |  | 2805
 |  | 2805
 |  | 2805
 |  | 2805
 |  | 2454
 |  | 2805
 |  | 2555
 |  | 2222
 |  | 2471
 |  | 2471
 |  | 2471 |  |  | 0
 | avg | 2471
 |  |  | CHECK
 |  | BASELOAD  $ AMOUNT |  |  |  |  |  | TRANSPORT =
 |  | EXCESS $ AMOUNT |  |  |  |  |  | FUEL =
 |  | KEEP WHOLE AMOUNT
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: FEBMOSSBLUFF

 | ENRON NORTH AMERICA MOSS BLUFF STORAGE
[NAME] |  |  |  | NOTE:  1.5% FUEL CHARGED GOING INTO MOSS BLUFF
 | NGPL |  |  | CHANNEL (EL PASO) |  |  | HOUSTON PIPELINE (HPL) |  |  | [NAME] (UTTCO) |  |  | TEJAS GAS |  |  | TETCO
 | Inj net fuel | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl
2000-02-01 00:00:00 | 0 | -5000 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-02 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-03 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-04 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-05 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-06 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-07 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-08 00:00:00 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-09 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-10 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-11 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-12 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-13 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-14 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-15 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-16 00:00:00 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-17 00:00:00 | 0 | -19459 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-18 00:00:00 | 9748 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-19 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-20 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-21 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-22 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-23 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-24 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-25 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-26 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-27 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-28 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-02-29 00:00:00 | 0 | -20061 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Total Inj/Withdrawl
Net Inj/WithD per Pipe
Ending Balance
Spreadsheet: darrell_schoolcraft__7745__SUNFLOWER - NNG - HOURLY - 2002
Sheet: 15

WEEKENDS & AFTER 17:00 -
EMERGENCY CONTACTS: |  |  | [NAME] (PAGER)
 | S2 | [NAME] | S5 | HOLCOLM | S2 | [NAME] | S5 | S2, S4 & S5 | TOTAL
HOUR | MWH | MWH | MWH | MMBTU | MMBTU | MMBTU | MMBTU | MMBTU SUBTOTAL | MMBTU
09:00:00 |  | 0 | 0 | 6.75 | 265.188
10:00:00 |  | 0 | 0 | 6.75 | 266.952
11:00:00 |  | 0 | 0 | 6.75 | 264.306
12:00:00 |  | 0 | 0 | 6.75 | 258.916
13:00:00 |  | 0 | 0 | 6.75 | 259.308
14:00:00 |  | 0 | 0 | 6.75 | 264.6
15:00:00 |  | 0 | 0 | 6.75 | 260.582
16:00:00 |  | 0 | 0 | 6.75 | 263.032
17:00:00 |  | 0 | 0 | 6.75 | 272.146
18:00:00 |  | 0 | 0 | 6.75 | 277.732
19:00:00 |  | 0 | 0 | 6.75 | 272.244
20:00:00 |  | 0 | 0 | 6.75 | 277.634
21:00:00 |  | 0 | 0 | 6.75 | 279.496
22:00:00 |  | 0 | 0 | 6.75 | 281.75
23:00:00 |  | 0 | 0 | 6.75 | 261.464
1900-01-01 00:00:00 |  | 0 | 0 | 6.75 | 157.584
1900-01-01 01:00:00 |  | 0 | 0 | 6.75 | 67.914
1900-01-01 02:00:00 |  | 0 | 0 | 6.75 | 22.834
1900-01-01 03:00:00 |  | 0 | 0 | 6.75 | 23.03
1900-01-01 04:00:00 |  | 0 | 0 | 6.75 | 20.482
1900-01-01 05:00:00 |  | 0 | 0 | 6.75 | 135.044
1900-01-01 06:00:00 |  | 0 | 0 | 6.75 | 241.178
1900-01-01 07:00:00 |  | 0 | 0 | 6.75 | 256.858
1900-01-01 08:00:00 |  | 0 | 0 | 6.75 | 262.15
DAILY
TOTAL
Spreadsheet: 855638d1705147335-error-hendler-error-01
Sheet: summery

 | ref | header | fig | 1
 |  | a | 18
 |  | a | 20
 |  | a | 13
 |  | a | 15
 |  | a | 8
 |  | a | 14
 |  | a | 24
 |  | a | 22
 |  | b | 1
 |  | b | 2
 |  | b | 7
 |  | c | 2
 |  | c | 0
 |  | d | 3
 |  | d | 2
 |  | d | 222
 |  | d | 22
 |  | d | 0
 |  | e | 0
 |  | f | 2
 |  | f | 0
 |  | f | 22
 |  | g | 1
 |  | g | 0
 |  | g | 2
 |  | h | 2
 |  | h | 0
 |  | h | 3
 |  | i | 1
 |  | i | 2
 |  | j | 3
 |  | j | 4
 |  | j | 2
 |  | j | 5
 |  | k | 1
 |  | k | 0
 |  | k | 2
 |  | l | 2
 |  | l | 0
 |  | l | 3
 |  | m | 1
 |  | m | 2
 |  | n | 3
 |  | n | 4
 |  | n | 2
 |  | n | 5
 |  | o | 26
 |  | o | 24
 |  | o | 21
 |  | o | 20
 |  | o | 12
 |  | o | 28
 |  | o | 25
 |  | o | 15
 |  | o | 22
 |  | o | 16
 |  | p | 2
 |  | p | 0
 |  | q | 0
 |  | q | 2
 |  | r | 22
 |  | r | 2
 |  | r | 0
 |  | s | 0
 |  | t | 22
 |  | t | 2
 |  | t | 0
 |  | u | 2
 |  | u | 1
 |  | u | 0
 |  | v | 32
 |  | v | 3
 |  | v | 22
 |  | v | 2
 |  | w | 2
 |  | w | 1
 |  | w | 3
 |  | x | 4
 |  | x | 5
 |  | x | 3
 |  | y | 2
 |  | y | 0
 |  | z | 2
 |  | z | 0
 |  | z | 22
Spreadsheet: 05aef7e3-1fec-444a-857f-dfb38019290c
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 81. 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
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total houses ;  New ; |  |  | Original | A590537T | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total other residential building ;  New ; |  |  | Original | A590538V | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A590539W | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590540F | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590541J | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590542K | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590543L | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 683149d1592512460-round-numbers-round_ups
Sheet: Rounding

 |  | Round up to the next
 | Range of estimate | Strategic | Concept | Detailed | Post Tender
 | 0 | 10000 | 10000 | 10000 | 10000
 | 1000001 | 100000 | 100000 | 100000 | 100000
 | 5000001 | 1000000 | 500000 | 500000 | 500000
 | 20000001 | 1000000 | 1000000 | 1000000 | 1000000
 | 100000001 | 2000000 | 2000000 | 2000000 | 1000000
 | 200000001 | 5000000 | 2000000 | 2000000 | 2000000
 | 500000001 | 10000000 | 5000000 | 5000000 | 2000000
 | 1000000001 | 10000000 | 10000000 | 5000000 | 5000000
 | 5000000001 | 25000000 | 10000000 | 10000000 | 5000000
 |  | Strategic | Concept
 |  | 201727910.482632 | 201727910.482632
 | Result | 205000000 | 202000000
Spreadsheet: 772344d1647226250-conditional-formatting-problem-example-85-
Sheet: Sheet2

# When I give an input of actual value, any cell in the same row that
# abs(its_value - actual_value) < 2
# will be automatically formatted in some way
# like this↓
(before)
 | Normal |  | Amplified |  |  | ↓input
 | not crit | crit | not crit | crit |  | Actual
skill1 | 10.001 | 15.001 | 20.002 | 30.002 |  | 15
skill2 | 20 | 35 | 40 | 70 |  | 69
(after)
 | Normal |  | Amplified |  |  | ↓input
 | not crit | crit | not crit | crit |  | Actual
skill1 | 10.001 | 15.001 | 20.002 | 30.002 |  | 15
skill2 | 20 | 35 | 40 | 70 |  | 41
Spreadsheet: 719c17b5-4499-4fe7-b046-4df74c942c4d
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
 | SERVICES | SINGLES ON-LINE DATING | #1 VALUE | COUPLES CONNECTION SERVICES | SINGLES LOVE SPA | #2 VALUE | COUPLES LOVE SPA | SINGLES EMPOWERED RELATIONSHIPS TV | COUPLES EMPOWERED RELATIONSHIPS TV | ULTIMATE PLAN (SINGLES) INCLUDES LS AND ERTV ONLY | ULTIMATE PLAN (COUPLES) INCLUDES CC, LS AND ERTV
 | Love Spa | ✘ |  | ✘ | ✔ |  | ✔ | ✘ | ✘ | ✔ | ✔
 | Empowered Relationships TV | ✘ |  | ✘ | ✘ |  | ✘ | ✔ | ✔ | ✔ | ✔
 | [NAME] | ✔ |  | ✘ | ✘ |  | ✘ | ✘ | ✘ | ✔ + $29.95 a month | ✘
 | [NAME] | ✘ |  | ✔ | ✘ |  | ✘ | ✘ | ✘ | ✘ | ✔
 | FEES
 | Monthly Fee | 29.95 |  | FREE | 49.99 |  | 49.99 | 10 | 10 | 60 | 60
 | Three Month Fee | 59.95 |  | FREE | 140 |  | 140 | 27 | 27 | 150 | 150
 | Six Month Fee | 99.95 |  | FREE | 250 |  | 250 | 42 | 42 | 270 | 270
 | Twelve Month Fee | 139.95 |  | FREE | 400 |  | 400 | 60 | 60 | 440 | 440
Spreadsheet: 155174d1336694792-index-match-or-do-i-need-a-macro-supplierrequirements
Sheet: Sheet1

 | Supplier 3
Helper | Dwg Code | Description |  | Dwg Code | Description | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4
 | [NAME] | CALCULATIONS(ancillary equipment, lift studies, etc) (weeks prior to manufacture/implementation) |  | G01 | VDS - DRAWING & DOCUMENT SUBMISSION REGISTER c/w SCHEDULE OF SUBMISSIONS | Y
 | G07 | PERFORMANCE CURVES AND DATA |  | G02 | EQUIPMENT LISTS, BILL OF MATERIALS | Y
 | [NAME] | SPECIAL TOOLS RECOMMENDED FOR ERECTION, TESTING, AND [NAME] |  | G03 | DESIGN CRITERIA & GENERAL SPECIFICATION DOCUMENTATION, CALCULATIONS | Y
 | [NAME] | LIST OF RECOMMENDED SPARE PARTS (as called for in specification) |  | G04 | RESULTS OF STUDIES | Y |  |  | Y
 |  |  |  | G05 | TRAINING PROGRAM (weeks prior to training commencement) | Y | Y |  | Y
6 |  |  |  | [NAME] | CALCULATIONS(ancillary equipment, lift studies, etc) (weeks prior to manufacture/implementation) | Y | Y | Y
7 |  |  |  | G07 | PERFORMANCE CURVES AND DATA | Y | Y | Y
 |  |  |  | G08 | CLEARANCES FOR EQUIPMENT OPERATION AND MAINTENANCE | Y | Y |  | Y
 |  |  |  | [NAME] | NOISE CONTROL DATA | Y |  |  | Y
 |  |  |  | G10 | GENERAL ARRANGEMENT DRAWINGS | Y |  |  | Y
 |  |  |  | G11 | DRAWINGS OF EQUIPMENT BREAKDOWN FOR FIELD ASSEMBLY | Y |  |  | Y
 |  |  |  | G12 | PACKING LIST C/W SIZES, WEIGHTS AND SPECIAL HANDLING INSTRUCTIONS | Y |  |  | Y
 |  |  |  | G13 | INSTALLATION AND ERECTION SEQUENCE C/W SCHEDULE | Y | Y |  | Y
 |  |  |  | G14 | LUBRICATION SCHEDULE (includes chemicals and additives) | Y | Y
15 |  |  |  | [NAME] | SPECIAL TOOLS RECOMMENDED FOR ERECTION, TESTING, AND [NAME] | Y |  | Y
16 |  |  |  | [NAME] | LIST OF RECOMMENDED SPARE PARTS (as called for in specification) | Y |  | Y | Y
 |  |  |  | G17 | LIST OF CONSUMABLES AND CHEMICALS (to be brought to site) | Y |  |  | Y
 |  |  |  | R01 | OPERATIONS AND [NAME] (Before commissioning) | Y
 |  |  |  | R02 | [NAME] | Y | Y
 |  |  |  | R03 | TRAINING MANUALS (weeks prior to training commencement) | Y | Y |  | Y
 |  |  |  | [NAME] | PRE-COMMISSIONING PLAN (weeks prior to related work) | Y |  |  | Y
 |  |  |  | R05 | COMMISSIONING PROCEDURES | Y
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, December 14 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket 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: 90986d1290667942-how-to-insert-a-drop-down-country-list-autocomplete_validationlist
Sheet: Sheet1

SCOTLAND
Aberdeenshire
Angus
Argyllshire
Ayrshire
Banffshire
Berwickshire
Buteshire
Cromartyshire
Caithness
Clackmannanshire
[NAME]
Dunbartonshire
East Lothian
Fife
Inverness-shire
Kincardineshire
Kinross-shire
Kirkcudbrightshire
Lanarkshire
Midlothian
Morayshire
Nairnshire
[NAME]
Peeblesshire
Perthshire
Renfrewshire
[NAME]-shire
Roxburghshire
Selkirkshire
Shetland
Stirlingshire
Sutherland
West Lothian
Wigtownshire
Spreadsheet: 57729d1257950304-indexing-and-vlookup-multiple-information-book2
Sheet: Sheet1

NAME | NUMBER | BUILDINGS |  |  |  |  | TOP BUILDING OWNERS
JON SMITH | 10 | HOUSE |  |  |  |  | NAME | NUMBER | BUILDINGS
JON SMITH | 20 | APARTMENT |  |  |  |  | TOM THOMSON | 80 | BARN
JON SMITH | 30 | SHED |  |  |  |  | [NAME] | 40 | CONDO
[NAME] | 40 | CONDO |  |  |  |  | JON SMITH | 10 | HOUSE
TOM THOMSON | 80 | BARN
 |  |  | Is there a way to make excel show all buildings
 |  |  | associated with JON SMITH instead of just
 |  |  | the first one, which is the house/
 |  |  | And to add the total number for JON SMITH
 |  |  | which would be 60 instead of just looking at
 |  |  | the fist number which is 10?
 |  |  | The index formula should also rank JON
 |  |  | SMITH as the second because he has
 |  |  | 60 total buildings.