tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 779722d1652048697-excel-365-dropdown-list-that-will-not-allow-user-to-use-the-same-name-twice-000-combo-template
Sheet: Source

Column1 | Column2 | Namecheck | Column4 | Column5 | Column6
HELP |  |  |  |  | HELP
NO DRIVER |  |  |  |  | NO DRIVER
NOT NEEDED |  |  |  |  | NOT NEEDED
SEE COMMENT |  |  |  |  | SEE COMMENT
[NAME]  [PHONE] |  |  |  |  | [NAME]  [PHONE]
ALEJANDRO VALDEZ  [PHONE] |  |  |  |  | ALEJANDRO VALDEZ  [PHONE]
ALLAN RIALS  [PHONE] |  |  |  |  | ALLAN RIALS  [PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME]  [PHONE] |  |  |  |  | [NAME]  [PHONE]
COURTNEY CLEVELAND  [PHONE] |  |  |  |  | COURTNEY CLEVELAND  [PHONE]
[NAME]  520.-553-9083 |  |  |  |  | [NAME]  520.-553-9083
DARYL MOORE  [PHONE] |  |  |  |  | DARYL MOORE  [PHONE]
DEMETRIUS NEWTON  [PHONE] |  |  |  |  | DEMETRIUS NEWTON  [PHONE]
DESI LITTLEMAN  [PHONE] |  |  |  |  | DESI LITTLEMAN  [PHONE]
DILLON SESLAR  [PHONE] |  |  |  |  | DILLON SESLAR  [PHONE]
DWIGHT [NAME]  [PHONE] |  |  |  |  | DWIGHT [NAME]  [PHONE]
FERNANDO HINOJOS  [PHONE] |  |  |  |  | FERNANDO HINOJOS  [PHONE]
GABE CORRAL  [PHONE] |  |  |  |  | GABE CORRAL  [PHONE]
GUADALUPE GALLEGOS  [PHONE] |  |  |  |  | GUADALUPE GALLEGOS  [PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME] VALENCIA   [PHONE] |  |  |  |  | [NAME] VALENCIA   [PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
JAYSON GARDNER  [PHONE] |  |  |  |  | JAYSON GARDNER  [PHONE]
[NAME]  [PHONE] |  |  |  |  | [NAME]  [PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME] POTHEN  [PHONE] |  |  |  |  | [NAME] POTHEN  [PHONE]
JOHNNY FAULKNER  [PHONE] |  |  |  |  | JOHNNY FAULKNER  [PHONE]
[NAME]  [PHONE] |  |  |  |  | [NAME]  [PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME]  [PHONE] |  |  |  |  | [NAME]  [PHONE]
[NAME] RUIZ  [PHONE] |  |  |  |  | [NAME] RUIZ  [PHONE]
PHILLIP MCGULLOUGH  [PHONE] |  |  |  |  | PHILLIP MCGULLOUGH  [PHONE]
RISA OLIVAS   [PHONE] |  |  |  |  | RISA OLIVAS   [PHONE]
[NAME][PHONE] |  |  |  |  | [NAME][PHONE]
[NAME](NE)  [PHONE] |  |  |  |  | [NAME](NE)  [PHONE]
[NAME] (AXIOM)  [PHONE] |  |  |  |  | [NAME] (AXIOM)  [PHONE]
[NAME]   [PHONE] |  |  |  |  | [NAME]   [PHONE]
SHAWN WATSON  [PHONE] |  |  |  |  | SHAWN WATSON  [PHONE]
STACY OKULY  [PHONE] |  |  |  |  | STACY OKULY  [PHONE]
TANYA TONIAN-THOMPSON  [PHONE] |  |  |  |  | TANYA TONIAN-THOMPSON  [PHONE]
[NAME]  [PHONE] |  |  |  |  | [NAME]  [PHONE]
THOMAS SHEAR P/T  [PHONE] |  |  |  |  | THOMAS SHEAR P/T  [PHONE]
[NAME]  [PHONE] |  |  |  |  | [NAME]  [PHONE]
WARREN FOREMAN  [PHONE] |  |  |  |  | WARREN FOREMAN  [PHONE]
Spreadsheet: 183187d1348740354-body-of-text-to-individual-cells-so-that-each-letter-in-text-gets-its-own-cell-book1
Sheet: Sheet1

Paste data here!
 | 1
Spreadsheet: 710339d1608854404-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: December

Employee Absence Schedule
December | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 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 | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: sara_shackleton__36364__PHONE_LIST
Sheet: EISC

Enron International Southern Cone
COMPANY´S NAME | ADDRESS | PHONE | FAX
Enron International Argentina Buenos Aires, Argentina | [NAME] 900, [NAME] Buenos Aires, Argentina | (5411) 4891-3600 | (5411) 4313-2916 (5411) 4315-2514
Trans Rede, [NAME], Bolivia | [NAME] B           Avenida Arce                                    Esqina [NAME]               Piso 10-Oficina 1001 | (591) 243-0199 | (591) 243-3461 (591) 811-3041
Trans Rede, S.A. | Km.7 1/2 Ant. [NAME], | (591) 352-4477 | (591) 352-4374
[NAME] do [NAME]. São Paulo, [NAME] | Av.das [NAME],                        Nº 11.541 [NAME]5º/6º/7ºandares                                       Cep.: 04578-000 | (011) 5503-1399 | (011) 5507-3090
Enron  Serviços do [NAME]. Salvador, [NAME] | Av. [NAME], 450                  19º andar, cj. 1901                    Salvador, [NAME]CEP: 41820-020 | (071) 341-7310 | (071) 341-7315
Enron  Serviços do [NAME]. Rio de Janeiro, [NAME] | Av. [NAME], nº 1                                9º andar/Setor A                              Centro-Rio de Janeiro                           Cep.: 20090-003 | (021) 550-8870 | (021) 550-8888
Enron  Power Construction Ltda. Cuiabá, [NAME] | Rodovia dos Imigrantes, 3770         Novo Distrito Industrial              Cuiabá -CEP: 78098-840 | (065) 612-2102 | (065) 668-4001
[NAME], [NAME] | Rodovia dos Imigrantes, 3770         Novo Distrito Industrial                   Cuiabá - CEP:78098-840 | (065) 668-4000 | (065) 668-4002 (065) 668-4081
Enron International, Houston | 333 Clay Street, Suite 1800                               Houston,  TX 77002-7361 | (713) 646-7423
COMPANY´S NAME | TIE LINE
Enron International Argentina                        Buenos Aires, Argentina | 8900
Enron  Serviços do [NAME].                      Rio de Janeiro, [NAME] | 8920
[NAME] do [NAME].       [NAME], [NAME] | 8910
Enron International, Houston | (646 numbers)  8206             (345 numbers)  8205            (853 numbers)  8203
Spreadsheet: richard_ring__31583__Wind Meter for 12 01
Sheet: Wind Unit 2

[NAME] | TA_START | SumOfINTERVAL
GARNET1UNIT2 | 2001-12-01 00:01:00 | 0.3860000000000002
GARNET1UNIT2 | 2001-12-02 00:01:00 | 26.18400000000001
GARNET1UNIT2 | 2001-12-03 00:01:00 | 0
GARNET1UNIT2 | 2001-12-04 00:01:00 | 121.718
GARNET1UNIT2 | 2001-12-05 00:01:00 | 27.244
GARNET1UNIT2 | 2001-12-07 00:01:00 | 34.95900000000002
GARNET1UNIT2 | 2001-12-08 00:01:00 | 16.918
GARNET1UNIT2 | 2001-12-09 00:01:00 | 45.455
GARNET1UNIT2 | 2001-12-10 00:01:00 | 128.388
GARNET1UNIT2 | 2001-12-11 00:01:00 | 41.499
GARNET1UNIT2 | 2001-12-12 00:01:00 | 0
GARNET1UNIT2 | 2001-12-13 00:01:00 | 0
GARNET1UNIT2 | 2001-12-14 00:01:00 | 0
GARNET1UNIT2 | 2001-12-15 00:01:00 | 0
GARNET1UNIT2 | 2001-12-16 00:01:00 | 0
GARNET1UNIT2 | 2001-12-17 00:01:00 | 0
GARNET1UNIT2 | 2001-12-18 00:01:00 | 0
GARNET1UNIT2 | 2001-12-19 00:01:00 | 0
GARNET1UNIT2 | 2001-12-20 00:01:00 | 0
GARNET1UNIT2 | 2001-12-21 00:01:00 | 0
GARNET1UNIT2 | 2001-12-22 00:01:00 | 0
GARNET1UNIT2 | 2001-12-23 00:01:00 | 0
GARNET1UNIT2 | 2001-12-24 00:01:00 | 0
GARNET1UNIT2 | 2001-12-25 00:01:00 | 0
GARNET1UNIT2 | 2001-12-26 00:01:00 | 0
Total
Spreadsheet: 7e9adf2a-71db-4ae2-acd1-67a83f5189af
Sheet: Track Maint.

Contract/ Type | Description | Numbers | Original Numbers | 1960s [NAME] | Builder | Notes | Status
Ballast Handlers
R-105 | Ballast Distributor
 | Ballast Tampers | TP221-TP223 | 1001-1003 | 20163-20165
 | Ballast Tampers | TP224-TP225 | 3255-3256 | 20625-20626
[NAME] | Ballast Tampers | TP231-TP234 ??
R-148 | Ballast Tampers | TP236-239 |  |  | Plasser
R-125 | Ballast Regulator | BR002-BR003 |  |  | Plasser | Model PBR-550
[NAME] | Ballast Regulators (2)
Rail Grinders
R-78 | 1 Rail Grinding Car
R-89 | Rail Grinding Unit | RG24 |  |  | 1985 Fairmount | crew car, 3 "buggies", propulsion car; R&NRCD 253
[NAME])
 | Rail Grinder | G231-G234 | [NAME] | 20171-20174 | 1959 Speno | Speno grinding units | Scrapped
Low V | Fan & Blower Car | G235 | 4532 | 20616 |  | Speno train fan car | Scrapped
Low-V | Fan & Blower Car | G236 | 4954 | 20175 |  | Speno train fan car | Scrapped
R-20 | Flat Car ([NAME]) | F122 | X122 | 20059 | 1957 Magor | Speno train generator | Scrapped
R-20 | Flat Car (Tank & Weed Spray) | F111 | X111 | 20048 | 1957 Magor | Speno train spark suppression; R&NRCD 129; NYD 6/66 | Scrapped
Spreadsheet: 0b7db62b-ca15-4015-9ee2-14af79b49feb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4320 | 16158 | [NAME] | [NAME] | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
Spreadsheet: 23628d1213198651-formatting-permanent-closing-report-sample
Sheet: Validation Tables

Community | Contingent | Closed | Months
ABL | HTS | Yes | 2008-01-01 00:00:00
ALD | COC | Cancelled | 2008-02-01 00:00:00
BOB | No |  | 2008-03-01 00:00:00
ELG |  |  | 2008-04-01 00:00:00
EMP |  |  | 2008-05-01 00:00:00
HSS |  |  | 2008-06-01 00:00:00
JAM |  |  | 2008-07-01 00:00:00
MER |  |  | 2008-08-01 00:00:00
PNP |  |  | 2008-09-01 00:00:00
SOD |  |  | 2008-10-01 00:00:00
TBR |  |  | 2008-11-01 00:00:00
VAH |  |  | 2008-12-01 00:00:00
WBX |  |  | 2009-01-01 00:00:00
-
Spreadsheet: dana_davis__4471__sapfastentry
Sheet: Sheet1

ENRON CORP.  Journal Entry Form for SAP. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page |  |  | 1 |  |  |  | of |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Debits
Doc. Dt. |  |  |  |  |  |  | Doc type |  |  |  |  |  | Co. Cd |  |  |  |  | Post Dt. |  |  |  |  |  |  | Curr Type/Rate |  |  |  |  |  |  |  |  |  | Document Number |  |  |  |  |  |  |  |  |  |  | [NAME]. |  |  |  |  |  |  | Reference |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Credits
Posting Key |  |  |  |  |  |  |  | 2
Acct No. |  |  |  |  |  |  |  | 8
New Co. Cd |  |  |  |  |  |  |  | 4
Amount |  |  |  |  |  |  |  | 18
Tax Code |  |  |  |  |  |  |  | 2
Jurisd Code |  |  |  |  |  |  |  | 10
Trading Partnr |  |  |  |  |  |  |  | 3
Cost/Profit Ctr |  |  |  |  |  |  |  | 10
Order / |  |  |  |  |  |  |  | 9
WBS Element |  |  |  |  |  |  |  | 18
Network |  |  |  |  |  |  |  | 7
Material No. |  |  |  |  |  |  |  | 7
Allo No. |  |  |  |  |  |  |  | 18
Text |  |  |  |  |  |  |  | 25
Value Date |  |  |  |  |  |  |  | 7
Setlmnt Pd |  |  |  |  |  |  |  | 6
Commit Item |  |  |  |  |  |  |  | 10
Trans Type |  |  |  |  |  |  |  | 3
Funct area |  |  |  |  |  |  |  | 4
Ext GA amt in LC |  |  |  |  |  |  |  | 18
Entry Description
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepared By: |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorized By:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorized By:
Spreadsheet: 86701d1286661289-stop-cell-from-calculating-and-save-value-october-2010-2-1-
Sheet: ORIGINAL

 |  | DAILY ACCOUNT BALANCES
 |  | For The Month Of: OCTOBER 2010
AS OF | 2010-10-09 00:00:00
 | CHECKS HELD |  | 43201.39
Work Day # | Date | CASH Balance | AVAIL CASH       = Col C + D5
 |  | 66696 | 109897.39
1 | 2010-10-01 00:00:00 | 420102 | 463303.39
2 | 2010-10-04 00:00:00 | 497666 | 540867.39
3 | 2010-10-05 00:00:00 | 77754 | 120955.39
4 | 2010-10-06 00:00:00 | 231078 | 274279.39
5 | 2010-10-07 00:00:00 | 120003 | 163204.39
6 | 2010-10-08 00:00:00 | 564333 | 607534.39
7 | 2010-10-09 00:00:00 | 232098 | 276149 | 275299.39
8 | 2010-10-10 00:00:00 | 0
9 | 2010-10-11 00:00:00 | 0
10 | 2010-10-12 00:00:00 | 0
11 | 2010-10-13 00:00:00 | 0
12 | 2010-10-14 00:00:00 | 0 |  |  |  |  | Data Validation
13 | 2010-10-15 00:00:00 | 0
14 | 2010-10-16 00:00:00 | 0 |  |  |  |  | By choosing The data in the drop down , it stays as you want.
15 | 2010-10-17 00:00:00 | 0
16 | 2010-10-18 00:00:00 | 0
17 | 2010-10-19 00:00:00 | 0
18 | 2010-10-20 00:00:00 | 0
19 | 2010-10-21 00:00:00 | 0
20 | 2010-10-22 00:00:00 | 0
21 | 2010-10-23 00:00:00 | 0
Spreadsheet: 725310d1616612722-formula-on-worksheet-that-changes-column-if-copied-on-new-worksheet-cocktail-box-stock-sheet
Sheet: March Stock

 | Wet Product |  |  |  |  |  | Dry Product
 | Product | QTY initial | QTY in | QTY out | QTY holding |  | Product | QTY initial | QTY in | QTY out | QTY holding
 | [NAME] (50ml) | 314 |  |  |  |  | Feather
 | [NAME] (50ml) | 336 |  |  |  |  | Lime dehydrated
 | [NAME] (50ml) | 170 |  |  |  |  | Pineapple freeze dried
 | [NAME] (50ml) | 34 |  |  |  |  | Plum freeze dried
 | [NAME] (50ml) | 84 |  |  |  |  | [NAME] cake
 | Chivas Regal 12yrs (700ml) |  |  |  |  |  | Rose buds
 | Olmeca Blanco Tequila (700ml) |  |  |  |  |  | White tea (100g)
 | Campari (700ml) |  |  |  |  |  | Mini pegs | 250
 | Cointreau (700ml) | 1 |  |  |  |  | Maple leaf
 | El Bandarra Rose (1000ml) |  |  |  |  |  | Grapefruit dehydrated
 | [NAME] (330ml) |  |  |  |  |  | Plastic bottle & cap
 | Miraculous foamer (118ml) |  |  |  |  |  | Blueberries freeze dried
 | Fever tree soda (200ml) |  |  |  |  |  | Raspberries freeze dried
 | Prosecco & pineapple cordial (700ml) |  |  |  |  |  | Orange dehydrated
 | [NAME] (700ml) |  |  |  |  |  | Lemon dehydrated
 | Peach & honey shrub (700ml) |  |  |  |  |  | [NAME] bottle (200ml)
 | Plum & sage cordial (700ml) |  |  |  |  |  | Garnish bag | 50
 | Sherry & vanilla reduction (700ml) |  |  |  |  |  | Envelopes | 43
 | Passion fruit puree (1000ml) |  |  |  |  |  | Droplet bottles
 | Grepefruit & vanilla falernum (700ml) |  |  |  |  |  | Paper bags
 | Chamomile & thyme cordial (700ml) |  |  |  |  |  | Straw
 | Maple and citrus syrup (700ml) |  |  |  |  |  | [NAME]
 | Clementine shrub (700ml) |  |  |  |  |  | Spoon
 | Apple Juice (1000ml) |  |  |  |  |  | [NAME]
 | Fever tree lemonade (200ml)
 | El Bandarra Red (1000ml) | 1
 | Angostura bitters (200ml)
 | Sugar (1000g) | 0.5
 | Elderflower cordial (500ml)
 | Prosecco (200ml)
 | Orgeat (1000ml)
 | Maraschino liqueur (700ml)
 | [NAME] (50 per jar)
 | Chocolate bitters (200ml)
 | Lime Cordial (700ml)
Spreadsheet: 175734d1345633262-auto-populate-data-from-another-table-data
Sheet: 1

HOTEL 1
[NAME]
PERIOD |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
30-DAY | RMN | 0.02 | 0.05179458862506902 | 0.05651636812847437 | 0.08 | 0.09 | 0.1 | 0.11 | 0.15 | 0.85 | 0.02 | 0.02 | 0.02
 | REV | 0.0110726462142513 | 0.05 | 0.02 | 0.03 | 0.08 | 0.02 | 0.05 | 0.08 | 0.02 | 0.25 | 0.28 | 0.32
60-DAY | RMN |  | 0.05179458862506902 | 0.02 | 0.05 | 0.02283679027865074 | 0.02283679027865074 | 0.1547500277131139 | 0.1374137015400956 | 0.2309158032630702 | 0.007897334649555774 | 0.03210702341137123 | 0.2737003058103976
 | REV |  | 0.06165025493415584 | 0.02466248731863653 | 0.1240742466018256 | 0.07984329957375609 | 0.07615865874582362 | 0.1613147492664621 | 0.1778096424287691 | 0.2749164685308508 | 0.04 | 0.05 | 0.3619714150484594
90-DAY | RMN |  |  | 0.01 | 0.1278820375335121 | 0.09044531831225422 | 0.08134725231435887 | 0.2979068028906055 | 0.1374137015400956 | 0.3269996148414431 | 0.05967825635703165 | 0.08 | 0.01641708264004437
 | REV |  |  | 0.02 | 0.03 | 0.05 | 0.06 | 0.05 | 0.08 | 0.09 | 0.04 | 0.06 | 0.05025856278482622
Spreadsheet: 18d087f4-ac10-4a0b-b4f3-dcf443afa102
Sheet: Sheet1

ASSIGNMENT OF BUDGET ADMINISTRATORS: | Unnamed: 1 | Unnamed: 2
Blanket Authorization for all Cost Centres
Budget Administrator        Name | Cost Centre | Requires BEARS Access             (Please check)
1
2 | ALL Cost Centres
3 | listed below
OR
Individual Cost Centre Authorization
Budget Administrator        Name | Cost Centre | Requires BEARS Access             (Please check)
1
2
3
1
2
3
1
2
3
1
2
3
Authorization Signature:
 | Budget Developer
Date:
Please return to Vicky Blakely, Financial Services
Spreadsheet: 812037d1672922405-cannot-find-max-min-average-based-on-multiple-criteria-forum-workbook
Sheet: Sheet1

 | 2 Queries |  |  | 1 Query
 | MIN |  |  | MIN
 | MAX |  |  | MAX
 | AVERAGE |  |  | AVERAGE
Sample ID | Pond 1 | Pond 1 | Pond 1 | Duplicate 1 | Pond 2 | Pond 2 | Pond 2 | Pond 2 | Pond 2 | Duplicate pond 2 | Pond 3 | Pond 3 | Duplicate pond 3
Sample ID2 | Pond 1 | Pond 1 | Pond 1 | Duplicate 1 | Pond 2 | Pond 2 | Pond 2 | Pond 2 | Pond 2 | Duplicate pond 2 | Pond 3 | Pond 3 | Duplicate pond 3
Alkalinity (CaCO3) | 92 | 100 | 181 | 98 | 71 | 53 | 66 | 78 | 132 | 59 | 74 | 87 | 56
Aluminum | 0.3 | 0.142 | 1 | 0.171 | 0.14 | 0.0782 |  | 0.16 | 0.0122 |  | 0.13 | 0.0434
NH4 | 0.18 | 0.24 | 0.99 | 0.25 | 0.04 | <0.03 | 0.05 | 0.08 | 0.13 | 0.04 | 0.1 | <0.03 | <0.03
Spreadsheet: 822065d1679072355-count-the-number-of-instances-of-a-value-in-one-column-based-on-a-value-in-another-sample
Sheet: Data

Type | Points |  | Min | [NAME] | Resulting Discipline
 |  |  | 0 | 2.99 | [NAME]
Absent | 1 |  | 2 | 2.99 | Documented Verbal Warning - CFG
Absent - Combined (Days 2-3) | 0 |  | 3 | 5.99 | Written Warning - 1st PV
Absent - Failure to Report | 2 |  | 5 | 5.99 | Final Written Warning - Final PV
Absent - Sick | 1 |  | 6 | 100 | Termination
Bereavement | 0
Early Quit - Worked LESS than 1/2 Scheduled Day | 0.5
Early Quit - Worked MORE than 1/2 Scheduled Day | 0.5
Funeral | 0
Late - Worked MORE than 1/2 Scheduled Day | 0.5
Late - Worked LESS than 1/2 Scheduled Day | 0.5
LOA | 0
MTO/PTO | 0
WLBD | 0
WLBD2 | 0
WLBD4 | 0
WLBD6 | 0
[NAME] | 0
WLBD10 | 0
[NAME] | 0
WDU4 | 0
WDU6 | 0
WDU8 | 0
WDU10 | 0
Tardy | 0
Spreadsheet: 330480d1404759155-complex-comparison-of-columns-help-example-of-missing-data-on-table-4
Sheet: Tab4

Incident nr | Incident nr2
Spreadsheet: 76450d1276981400-incorporate-vacation-days-in-forumala-example
Sheet: Sheet1

DAY | DATE | PRODUCTIVITY | PRODUCTIVITY [NAME] | REPAIR TIME | REPAIR TIME VARIANCE | LAST NAME | FIRST NAME | TECH ID
Sunday | 2010-05-30 00:00:00 |  | D2 |  | F2 | HOLLAND | SCOTT | 801597
Monday | 2010-05-31 00:00:00 |  | D2 |  | F2 | HOLLAND | SCOTT | 801597
Tuesday | 2010-06-01 00:00:00 | 35.6 | 17.6 | 0.23 | 0.17 | HOLLAND | SCOTT | 801597
Wednesday | 2010-06-02 00:00:00 | 25.8 | 7.800000000000001 | 0.24 | 0.16 | HOLLAND | SCOTT | 801597
Thursday | 2010-06-03 00:00:00 | 22.9 | 4.899999999999999 | 0.24 | 0.16 | HOLLAND | SCOTT | 801597
Friday | 2010-06-04 00:00:00 | Sick | #N/A | Sick | #N/A | HOLLAND | SCOTT | 801597
Saturday | 2010-06-05 00:00:00 |  | D2 |  | F2 | HOLLAND | SCOTT | 801597
Sunday | 2010-06-06 00:00:00 |  | D2 |  | F2 | HOLLAND | SCOTT | 801597
Monday | 2010-06-07 00:00:00 | 20.4 | 2.399999999999999 | 0.25 | 0.15 | HOLLAND | SCOTT | 801597
Tuesday | 2010-06-08 00:00:00 | 20.4 | 2.399999999999999 | 0.25 | 0.15 | HOLLAND | SCOTT | 801597
Wednesday | 2010-06-09 00:00:00 | Vacation | #N/A | Vacation | #N/A | HOLLAND | SCOTT | 801598
Spreadsheet: 330353d1404727511-lookup-query-sample-raci
Sheet: Sheet1

Activity | Job Title 1 | Job Title 2 | Job Title 3 | Job Title 4 | Job Title 5 | Job Title 6 |  | Responsible | Accountable | Consulted | Informed
Activity 1 | R | R | A | C | I | I |  | Job Title 1, Job Title 2 | Job Title 3 | Job Title 4 | Job Title 5, Job Title 6
Activity 2 | A | R | R | C | C | C |  | Job Title 2, Job Title 3 | Job Title 1 | Job Title 4, Job Title 5, Job Title 6
Activity 3 | A | R | I | I | I | I |  | Job Title 2 | Job Title 1 |  | Job Title 3, Job Title 4, Job Title 5, Job Title 6
This is the format I already have the data in |  |  |  |  |  |  |  | This is the format I want to output into from the data to the left (obviously I've just generated this manually
Activity | Job Title 1 | Job Title 2 | Job Title 3 | Job Title 4 | Job Title 5 | Job Title 6 |  | Responsible | Accountable | Consulted | Informed
Activity 1 | R | R | A | C | I | I
Activity 2 | A | R | R | C | C | C
Activity 3 | A | R | I | I | I | I
 | Job Title 1 | R | A | A
 | Job Title 2 | R | R | R
 | Job Title 3 | A | R | I
 | Job Title 4 | C | C | I
 | Job Title 5 | I | C | I
 | Job Title 6 | I | C | I
Spreadsheet: 04b5abfa-6102-4654-9acb-15eac8019ff1
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 84. Value of Building Approved, Chain Volume Measures, Original - Tasmania
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 ;  Tasmania ;  Total houses ;  New ; |  |  | Original | A590527L | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total other residential building ;  New ; |  |  | Original | A590528R | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A590529T | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590530A | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590531C | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590532F | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590533J | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 68414d1268941121-summarize-data-from-multiple-worksheets-onto-one-master-equip-list
Sheet: V_Mori

Mach# | Make | Model | Description | Install_Date | Today | Age |  | Age
1 | [NAME] | GBR100 |  | 2005-01-01 00:00:00 | 2010-03-18 00:00:00 | 5 | years | 5 years
2 | [NAME] | GBR101 |  | 2005-01-01 00:00:00 | 2010-03-18 00:00:00 | 5 | years | 5 years
3 | [NAME] | GBR102 |  | 2008-01-01 00:00:00 | 2010-03-18 00:00:00 | 2 | years | 2 years
4 | [NAME] | GBR103 |  | 2007-01-01 00:00:00 | 2010-03-18 00:00:00 | 3 | years | 3 years
5 | [NAME] | GBR104 |  | 2009-01-01 00:00:00 | 2010-03-18 00:00:00 | 1 | years | 1 years
6 | [NAME] | GBR105 |  | 2010-01-01 00:00:00 | 2010-03-18 00:00:00 | 2 | months | 2 months
7 | [NAME] | GBR106 |  | 1998-01-01 00:00:00 | 2010-03-18 00:00:00 | 12 | years | 12 years
8 | [NAME] | GBR107 |  | 1977-01-01 00:00:00 | 2010-03-18 00:00:00 | 33 | years | 33 years
9 | [NAME] | GBR108 |  | 1989-01-01 00:00:00 | 2010-03-18 00:00:00 | 21 | years | 21 years