tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__1826__EGAN_strg_NOV2000
Sheet: Act, Nov-Dec

 | Injections |  |  |  |  |  | Withdrawals
 | 473178 |  |  |  | Net |  | 473190 |  | Balance
Date | Texas Gas | CGLF | ANR |  | Injections |  | Texas Gas
2000-11-07 00:00:00 | 0 | 20000 | 0 |  |  |  | 0
2000-11-08 00:00:00 | 13025 | 10000
2000-11-09 00:00:00 |  | 0 | 10000
2000-11-10 00:00:00 | 0 | 0 | 0
2000-11-11 00:00:00 | 0 | 13334 | 13000
2000-11-12 00:00:00
2000-11-13 00:00:00
2000-11-14 00:00:00 | 0 | 0 | 0
2000-11-15 00:00:00
2000-11-16 00:00:00
2000-11-17 00:00:00
2000-11-18 00:00:00
2000-11-19 00:00:00
2000-11-20 00:00:00
2000-11-21 00:00:00
2000-11-22 00:00:00
2000-11-23 00:00:00
2000-11-24 00:00:00
2000-11-25 00:00:00
2000-11-26 00:00:00
2000-11-27 00:00:00
2000-11-28 00:00:00
2000-11-29 00:00:00
2000-11-30 00:00:00 | 0 |  | 0
 | 0 | 0 | 0 |  |  |  | 4682
 |  |  |  |  |  |  | 4679
2001-01-01 00:00:00 | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0
Spreadsheet: 694102d0-4fbf-4643-b736-9d340057ae4b
Sheet: Winter 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
[NAME] (including [NAME])
Winter 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 723644d1615818263-if-isnumber-formula-update-cells-with-character-depending-on-dates-holiday-forms-2021
Sheet: Colleague 3

HOLIDAY FORM 2021
NAME: |  |  |  | 2021 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday) | N
2021 ENTITLEMENT |  | 23 |  | 05/04/2021 (Easter Monday) | N
CARRIED OVER FROM 2020 |  | 0 |  | 03/05/2021 (May Bank Hol) | N
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol) | N
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2021 (Aug Bank Hol) | N
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2021 (Xmas Day) | N
Reason: |  |  |  | 28/12/2021 (Xmas BH Day) | N
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
Spreadsheet: 780728d1652715737-date-formula-issue-taking-diff-btw-two-date-ranges-date-issue-excel-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00
 |  |  |  |  |  |  | Company | Effective Date |  |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 |  |  |  |  |  |  | ABC1 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | [NAME] | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC3
 |  |  |  |  |  |  | [NAME] | 2022-09-01 00:00:00
 |  |  |  |  |  |  | ABC5 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC6 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC7 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC8 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC9
 |  |  |  |  |  |  | ABC10 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC11 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC12 | 2022-09-01 00:00:00
 |  |  |  |  |  |  | ABC13 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC14 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC15 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC16 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC17
 |  |  |  |  |  |  | ABC18 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC19 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC20 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC21 | 2022-07-01 00:00:00
 |  |  |  |  |  |  | ABC22
 |  |  |  |  |  |  | ABC23 | 2022-06-01 00:00:00
 |  |  |  |  |  |  | ABC24
 |  |  |  |  |  |  | ABC25
 |  |  |  |  |  |  | ABC26
 |  |  |  |  |  |  | ABC27 | 2022-04-01 00:00:00
 |  |  |  |  |  |  | ABC28 | 2022-07-01 00:00:00
Spreadsheet: 186586d1350091766-find-the-last-price-of-a-product-sold-book1_-jemamena
Sheet: Sheet1

Date sold | Item | Price |  | Item | Last Price | Date sold
2012-01-07 00:00:00 | A | 10 |  | A | 18 | 2012-03-10 00:00:00
2012-01-08 00:00:00 | B | 22 |  | B | 15 | 2012-02-09 00:00:00
2012-02-09 00:00:00 | B | 15 |  | C | 12 | 2012-03-10 00:00:00
2012-03-10 00:00:00 | C | 12
2012-03-10 00:00:00 | A | 18
Spreadsheet: darron_c_giron__8050__2000
Sheet: Oct 2000

Done after bid-week:
Telerate/Price Basis/Quotes/Deals/OTC/Pub Posting
Pull up Crude Merc value & update cell E9 |  |  |  |  | Date,F5,%Nxavcprompt,F3
Update following cells from Gas Market Report
 |  | Note: Insert the #'s in blue to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 |  | 32.932 | 5.15 | 5.29 | 4.53 | 5.17
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 | 27258 | E21728 | 2,500/day | 506767 | 7/95-12/2001
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | 106622 | E11400 | 2,500/day | 506767 | 1/92-12/2003
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | 106624 | E22656 | 7,000/day | 506767 | 1/95-12/2001
CPR# | Sitara # | TAGG # | Vastar | Facility | Term | Calculated Price
394674 | 27253 | E21977 | 10,000/day | 506766 | 6/96-4/2002
CPR# | Sitara # | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | 27245 | E20337 | 10,000/day | 58649 | 1/93-12/2002 |  | * moved to Central desk for March
 |  | Last Update:
Spreadsheet: 93618d1293214782-inverse-maximum-minimum-function-zealot_minmax-1-
Sheet: Sheet1

 |  |  | MAX BEFORE |  |  | MAX AFTER |  |  | MIN BEFORE |  |  | MIN AFTER
13 |  | 0 | 0 |  | 3 | 3 |  |  | 0 |  |  | 0
6 |  | 0 | 0 |  | 0 | 0 |  |  | 1 |  |  | 1
7 |  | 1 | 1 |  | 1 | 1 |  |  | 0 |  |  | 0
2 |  | 0 | 0 |  | 0 | 0 |  |  | 3 |  |  | 8
15 |  | 4 | 4 |  | 10 | 10 |  |  | 0 |  |  | 0
10 |  | 0 | 0 |  | 3 | 3 |  |  | 0 |  |  | 0
9 |  | 0 | 0 |  | 2 | 2 |  |  | 2 |  |  | 0
8 |  | 0 | 0 |  | 1 | 1 |  |  | 3 |  |  | 0
4 |  | 0 | 0 |  | 0 | 0 |  |  | 4 |  |  | 3
11 |  | 4 | 4 |  | 0 | 0 |  |  | 0 |  |  | 1
12 |  | 5 |  |  | 4
5 |  | 0 |  |  | 1
1 |  | 0 |  |  | 0
11 |  | 2 |  |  | 1
3 |  | 0 |  |  | 0
19 |  | 15 |  |  | 0
20 |  | 16 |  |  | 24
2 |  | 0 |  |  | 0
13 |  | 1 |  |  | 0
17 |  | 2 |  |  | 11
12 |  | 0 |  |  | 1
6 |  | 0 |  |  | 0
14 |  | 2 |  |  | 4
7 |  | 0 |  |  | 0
7 |  | 0 |  |  | 0
9 |  | 2 |  |  | 0
10 |  | 3 |  |  | 0
14 |  | 4 |  |  | 1
3 |  | 0 |  |  | 0
15 |  | 9 |  |  | 1
14 |  | 0 |  |  | 0
19 |  | 14 |  |  | 9
15 |  | 0 |  |  | 0
16 |  | 1 |  |  | 0
17 |  | 2 |  |  | 6
11 |  | 0 |  |  | 1
8 |  | 0 |  |  | 0
12 |  | 2 |  |  | 0
16 |  | 3 |  |  | 2
11 |  | 0 |  |  | 1
7 |  | 0 |  |  | 0
20 |  | 24 |  |  | 6
3 |  | 0 |  |  | 0
10 |  | 1 |  |  | 1
4 |  | 0 |  |  | 0
17 |  | 3 |  |  | 2
5 |  | 0 |  |  | 0
11 |  | 1 |  |  | 0
20 |  | 6 |  |  | 19
13 |  | 0 |  |  | 2
8 |  | 0 |  |  | 1
4 |  | 0 |  |  | 0
17 |  | 3 |  |  | 3
10 |  | 0 |  |  | 1
8 |  | 0 |  |  | 0
16 |  | 2 |  |  | 0
18 |  | 7 |  |  | 2
12 |  | 0 |  |  | 0
14 |  | 1 |  |  | 0
19 |  | 10 |  |  | 8
18 |  | 0 |  |  | 7
7 |  | 0 |  |  | 1
5 |  | 0 |  |  | 0
12 |  | 2 |  |  | 2
1 |  | 0 |  |  | 0
8 |  | 1 |  |  | 0
14 |  | 5 |  |  | 1
7 |  | 0 |  |  | 0
20 |  | 19 |  |  | 1
14 |  | 0 |  |  | 0
Spreadsheet: 149521d1334000112-identifying-first-occurrence-of-various-options-search-for-first
Sheet: Sheet1

Unique ID | Activity | A Identifier | B Identifier | C Identifier | D Idenfitier | E Identifier | F Identifier
1 | A | 1
1 | A
1 | A
1 | B |  | 1
1 | C |  |  | 1
1 | D |  |  |  | 1
1 | E |  |  |  |  | 1
1 | E
22 | C |  |  | 1
22 | A | 1
333 | E |  |  |  |  | 1
333 | F |  |  |  |  |  | 1
 | First Occurance of:
Unique ID | Activity
1 | A
1 | B
1 | C
22 | A
22 | B
22 | C
333 | A
333 | B
333 | C
Spreadsheet: 135951d1326320860-returning-nonsequential-dates-from-weekdays-warbler-returning-nonsequential-dates-from-weekdays
Sheet: Sheet2

Weekday | Date
 | 2012-01-01 00:00:00
Monday
Wednesday
Thursday
Saturday
Sunday
Tuesday
Wednesday
Saturday
Sunday
Monday
Tuesday
Thursday
Saturday
Sunday
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: QTD Recon Q1FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended June 30, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 999 |  | 0 |  | -475 |  | 0 |  | 0 |  | 0 |  | 524
Cost of revenue | 240 |  | -3 |  | 0 |  | 0 |  | -1 |  | 0 |  | 236
Gross profit | 759 |  | 3 |  | -475 |  | 0 |  | 1 |  | 0 |  | 288
Operating expenses:
Marketing and sales | 140 |  | 0 |  | 0 |  | 0 |  | -5 |  | 0 |  | 135
General and administrative | 74 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 65
Research and development | 285 |  | 0 |  | 0 |  | 0 |  | -23 |  | 0 |  | 262
Acquisition-related contingent consideration | 2 |  | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 13 |  | -13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 18 |  | 0 |  | 0 |  | -18 |  | 0 |  | 0 |  | -
Total operating expenses | 532 |  | -15 |  | 0 |  | -18 |  | -37 |  | 0 |  | 462
Operating income (loss) | 227 |  | 18 |  | -475 |  | 18 |  | 38 |  | 0 |  | -174
Interest and other income, net | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3
Income (loss) before provision for (benefit from) income taxes | 230 |  | 18 |  | -475 |  | 18 |  | 38 |  | 0 |  | -171
Provision for (benefit from) income taxes | 9 |  | 0 |  | 0 |  | 0 |  | 0 |  | -57 |  | -48
Net income (loss) | 221 |  | 18 |  | -475 |  | 18 |  | 38 |  | 57 |  | -123
Earnings per share |  |  |  |  |  |  |  |  | Loss per share
Basic | 0.67 |  |  |  |  |  |  |  | Basic and diluted |  |  |  | -0.37
Diluted | 0.66
Number of shares used in computation |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic | 331 |  |  |  |  |  |  |  | Basic and diluted |  |  |  | 331
Diluted | 337
Spreadsheet: 4d503220-dfd8-40f6-a1e8-b1c88d6ce00f
Sheet: Spring 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
MA-NSEE
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 57978d1258246413-median-nhl
Sheet: Sheet3

Away |  |  |  |  | Home
Median |  |  |  |  | Median
Goals For |  | Goals Against |  |  | Goals For |  | Goals Against
A | H | A | H |  | A | H | A | H
2 | 3 | 4 | 5 |  | 2 | 3 | 4 | 5
Total Goals For |  |  |  |  | Total Goals For
Total Goals Against |  |  |  |  | Total Goals Against
Total Goals Away
Total Goals Home
NOW CHECK THE STARTING GOALIE
Spreadsheet: 328243d1403835608-index-match-retrieve-data-across-unique-sheets-with-unique-column-identifiers-budget-example-3-
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  |  |  | TITLE
 |  |  |  |  |  | Reconciliation Output
 | Row 29 | Row 39 | Row 59 |  |  | By Project
Account | Mapping | Mapping | Mapping | Sheet | Unique identifier | General Operating Costs | Branch | Business | Project | Project | Fund Source |  | Budgeted Effective FTE |  | Total Approved Budget
6572 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | [Project Name?] | 733C | 7553 | 23829 / 001
6573 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | [Project Name?] | 733C | 7553 | 23943 / 222
6574 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary:
6575 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary:
6576 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | Discretionary Costs
6577 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | [Project Name?] | 733C | 7553 | 23829 / 001
6578 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | [Project Name?] | 733C | 7553 | 23943 / 222
6579 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary:
6580 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | Total Project Cost
6581 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | [Project Name?] | 733C | 7553 | 23829 / 001
6582 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  | [Project Name?] | 733C | 7553 | 23943 / 222
6583 | TOTAL FTE: | TOTAL  Basic: | TOTAL  Discretionary: |  |  |  |  | 23829 / 001
 |  |  |  |  |  |  |  | 23943 / 222
 |  |  |  |  |  |  |  | 23829 / 001
 |  |  |  |  |  |  |  | 23943 / 222
 |  |  |  |  |  |  |  | Updates
 |  |  |  |  |  |  | 1 | Consider using dynamic references for rows 29, 39 & 59 (FTE, basic $, discretionary $)
Spreadsheet: 127814d1320590241-merging-data-from-different-worksheets-into-a-master-sheet-fruts-countries
Sheet: Master

[NAME] | Apple | blackberry | [NAME] | Grape | peach | mango | Rockmelon | [NAME] | watermelon
China | 4 | #N/A | #N/A | #N/A | 5 | #N/A | #N/A | #N/A | 12
America | 3 | 4 | #N/A | 53 | #N/A | 23 | #N/A | 1 | 123
Japan | #N/A | #N/A | 43 | #N/A | #N/A | 23 | 545 | #N/A | 12333
Spreadsheet: 56528153-d31c-48da-b104-176ff8fafdc7
Sheet: Sheet1

Table S1. Manually selected putative TFs | Unnamed: 1 | Unnamed: 2
Locus ID | Gene name | Description
FGSG_13746 | GzNot002 | CCR4-Not complex component (IPR007207)
FGSG_05073 | GzGATA008 | GATA type zinc finger transcription factor [NAME]
FGSG_08981 | [NAME] | Transcription factor Opi1 homolog (IPR013927)
FGSG_11627 | GzCCAAT008 | CCAAT-binding factor (IPR003958)
[NAME] | GzCCCH001 | CCCH-type zinc finger protein (IPR000571)
FGSG_06860 | GzCCCH002 | CCCH-type zinc finger protein (IPR000571)
[NAME] | GzCCCH003 | CCCH-type zinc finger protein  (IPR000571)
FGSG_11696 | GzCCCH004 | CCCH-type zinc finger protein  (IPR000571)
FGSG_01665 | FgFSR1 | putative transcription factor [NAME]
FGSG_06948 | Gzscp | triple-helical DNA-binding protein CDP1 homolog
FGSG_08722 | Gzsnd | SND1 transcription factor homolog
FGSG_00930 | GzSsu72 | transcription factor SSU72 homolog
FGSG_00420 | GzFET5 | transcription factor [NAME] homolog
FGSG_09992 | GzNH001 | [NAME] TF homologs (NCU01154.4)
FGSG_01040 | GzNH002 | [NAME] TF homologs (NCU03320.4)
FGSG_05588 | GzNH003 | [NAME] TF homologs (NCU00289.4)
Spreadsheet: 826982d1682418371-compliance-check-using-two-columns-test-data-5-aligw
Sheet: Sheet1

[NAME] | Call Number | User Status | Compliant
2 | 1 | FNSH | Compliant |  |  |  |  |  | I need a formula which can find the highest call number (column B) associated with the plan (in column A) and then return the value in Column D when found....
2 | 2 | FNSH | Compliant
2 | 3 | CANC | Non-Compliant |  |  |  |  |  | So Plan 2, I would want to return the value in D5. For plan 3, I want to pull out D9 etc.
2 | 4 | FNSH | Compliant
3 | 1 | FNSH | Non-Compliant
3 | 2 | FNSH | Compliant
3 | 3 | FNSH | Compliant |  |  |  |  | 4 | FNSH | Compliant
3 | 4 | FNSH | Non-Compliant |  |  |  | 3 | 4 | FNSH | Non-Compliant
5 | 1 | CANC | Non-Compliant |  |  |  | 5 | 3 | FNSH | Compliant
5 | 2 | CANC | Non-Compliant |  |  |  | 6 | 3 | FNSH | Non-Compliant
5 | 3 | FNSH | Compliant |  |  |  | 9 | 3 | FNSH | Compliant
6 | 1 | CANC | Non-Compliant |  |  |  | 10 | 4 | FNSH | Compliant
6 | 2 | CANC | Non-Compliant |  |  |  | 11 | 4 | FNSH | Non-Compliant
6 | 3 | FNSH | Non-Compliant |  |  |  | 12 | 4 | FNSH | Compliant
9 | 1 | FNSH | Non-Compliant
9 | 2 | FNSH | Non-Compliant
9 | 3 | FNSH | Compliant
10 | 1 | FNSH | Non-Compliant
10 | 2 | CANC | Non-Compliant
10 | 3 | CANC | Non-Compliant
10 | 4 | FNSH | Compliant
11 | 1 | FNSH | Non-Compliant
11 | 2 | FNSH | Compliant
11 | 3 | FNSH | Compliant
11 | 4 | FNSH | Non-Compliant
12 | 1 | FNSH | Non-Compliant
12 | 2 | FNSH | Compliant
12 | 3 | CANC | Non-Compliant
12 | 4 | FNSH | Compliant
Spreadsheet: 64753d1265607887-cut-and-paste-macro-categories
Sheet: Sample Data

1 | Beginners / Kids Mag
2 | Broadcast Special
3 | [NAME] | Press F8 and run the macro.
4 | Card Magic
5 | Close-Up Magic
6 | Collectible/Historic
7 | [NAME]
8 | [NAME] (Shop)
9 | Exclusive
10 | Fire Magic
11 | Gambling Magic
12 | Gospel Magic
13 | Magic Set
14 | Magic Staples / Cons
15 | Mentalism
16 | Magic For Kids
17 | Money Magic
18 | Seasonal - Christmas
19 | Seasonal - Halloween
20 | Stage Magic
21 | Street Magic
22 | Recommended
23 | Beginners / Kids Mag
24 | Broadcast Special
25 | [NAME]
26 | Card Magic
27 | Close-Up Magic
28 | Collectible/Historic
29 | [NAME]
30 | [NAME] (Shop)
31 | Exclusive
32 | Fire Magic
33 | Gambling Magic
34 | Gospel Magic
35 | Magic Set
36 | Magic Staples / Cons
37 | Mentalism
38 | Magic For Kids
39 | Money Magic
40 | Seasonal - Christmas
41 | Seasonal - Halloween
42 | Stage Magic
43 | Street Magic
44 | Recommended
45 | Beginners / Kids Mag
46 | Broadcast Special
47 | [NAME]
48 | Card Magic
49 | Close-Up Magic
50 | Collectible/Historic
51 | [NAME]
52 | [NAME] (Shop)
53 | Exclusive
54 | Fire Magic
55 | Gambling Magic
56 | Gospel Magic
57 | Magic Set
58 | Magic Staples / Cons
59 | Mentalism
60 | Magic For Kids
61 | Money Magic
62 | Seasonal - Christmas
63 | Seasonal - Halloween
64 | Stage Magic
65 | Street Magic
66 | Recommended
67 | Beginners / Kids Mag
68 | Broadcast Special
69 | [NAME]
70 | Card Magic
71 | Close-Up Magic
72 | Collectible/Historic
73 | [NAME]
74 | [NAME] (Shop)
75 | Exclusive
76 | Fire Magic
77 | Gambling Magic
78 | Gospel Magic
79 | Magic Set
80 | Magic Staples / Cons
81 | Mentalism
82 | Magic For Kids
83 | Money Magic
84 | Seasonal - Christmas
85 | Seasonal - Halloween
86 | Stage Magic
87 | Street Magic
88 | Recommended
Spreadsheet: 07b2fe31-0e87-4d6e-ad11-a90abf4f7abd
Sheet: D

Course color corresponds with term of offering.  Blue for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
Drama
DRAM 111 | Arts & Literature-Arts
DRAM 211 | Arts & Literature-Arts
DRAM 212 | Arts & Literature-Arts
DRAM 215 | Arts & Literature-Arts
DRAM 310 | Arts & Literature-Arts (3 times at 1 hour)
DRAM 320 | Arts & Literature-Arts
 | OR Arts & Literature-Literature
DRAM 330 | Arts & Literature-Arts
DRAM 331 | Arts & Literature-Arts | Computing
DRAM 332 | Arts & Literature-Arts
DRAM 333 | Arts & Literature-Arts
DRAM 334 | Arts & Literature-Arts
DRAM 341 | Arts & Literature-Arts
DRAM 342 | Arts & Literature-Arts
DRAM 381 |  | Experiential-Research
DRAM 381 | Arts & Literature-Arts |  | J-term 2012 (Black American Theater)
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Playmaking: The Playwright's Process)
DRAM 382 |  | Experiential-Research
DRAM 422 |  | Experiential-Research; Capstone
Spreadsheet: 14f29e72-a921-4bca-ad66-805c16a55dd3
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 25. Output of the Administrative and support services industries, group and class index numbers
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
Index Numbers ;  721 Employment services ; |  |  | Original | A3343924F | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7211  Employment placement and recruitment service ; |  |  | Original | A2314247W | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7212 Labour supply services ; |  |  | Original | A2314250K | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  729 Other administrative services ; |  |  | Original | A3343926K | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7292 Document preparation services ; |  |  | Original | A3343928R | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7293 Credit reporting and debt collection services ; |  |  | Original | A3343930A | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7294 Call centre operation ; |  |  | Original | A3343932F | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7299 Other administrative services n.e.c ; |  |  | Original | A3343934K | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  731 Building cleaning, pest control and gardening services ; |  |  | Original | A3343936R | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7311 Building and other industrial cleaning services ; |  |  | Original | A2314262V | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7312 Building pest control services ; |  |  | Original | A2314259F | 1998-03-01 00:00:00 | 2012-09-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 121787d1316416077-working-with-many-sheets-in-a-single-excel-file-sheetsgrouped
Sheet: Sheet4

Data | Data | Data | Data
Data | Data | Data | Data
Data | Data | Data | Data
Data | Data | Data | Data
Data | Data | Data | Data
Data | Data | Data | Data
Data | Data | Data | Data
Data | Data | Data | Data
Data | Data | Data | Data
Spreadsheet: 156206d1337223193-how-to-copy-data-from-master-list-sheet-to-another-sheet-based-on-category-ifjsss-round-2-data
Sheet: Data-LadiesOpen

THE LANGKAWI INTERNATIONAL
FORMULA JET SKI SUPER SERIES 2012
ROUND 2, PUTRAJAYA
 | MOTO :
 | CATEGORY   :  4 Stroke Ladies Open
 | LAPS :  12
 | RACE TIME :
No | RIDER | TEAM | CRAFT | CRAFT TYPE | POINT FROM PREVIOUS ROUND | ROUND 2 |  |  |  | OVERALL POINTS | RANK
 |  |  |  |  |  | MOTO 1 | MOTO 2 | MOTO 3 | MOTO 4
Spreadsheet: 37740d1235754811-complicated-sumif-formula-accounts
Sheet: Sheet2

Date | Account Type | Account No. | Currency | Amount
2007-01-01 00:00:00 | CURRENT NON INT BEAR | 123456 | GBP | 10000
2007-01-01 00:00:00 | CURRENT NON INT BEAR | 345231 | USD | 425
2007-03-01 00:00:00 | CURRENT NON INT BEAR | 425232 | EUR | 57224
2007-03-01 00:00:00 | CURRENT NON INT BEAR | 677432 | USD | 1212
2007-03-01 00:00:00 | CURRENT NON INT BEAR | 525233 | USD | 45612
2007-04-01 00:00:00 | CURRENT NON INT BEAR | 442156 | GBP | 23527
2007-05-01 00:00:00 | CURRENT NON INT BEAR | 234562 | EUR | 4572
2007-01-01 00:00:00 | CURRENT INT.BEARING | 745758 | SAR | 363645
2007-01-01 00:00:00 | CURRENT INT.BEARING | 465478 | SAR | 5344
2007-03-01 00:00:00 | CURRENT INT.BEARING | 256237 | GBP | 3652
2007-06-01 00:00:00 | CURRENT INT.BEARING | 568485 | USD | 7783
2007-06-01 00:00:00 | CALL/NOTICE DEPOSITS | 478458 | EUR | 25235
2007-08-01 00:00:00 | CALL/NOTICE DEPOSITS | 489774 | USD | 457734