tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 747161d1631265412-excel-math-problem-excel-math-problem
Sheet: Sheet1

 |  | Variable | Price | Total |  | x = adult price
 | No. of adults | 10 |  |  |  | y = child price = x*(1-20%) = x*80%
 | No. of of children | 20
 | Value for the group | 16650 |  |  |  | 10 adults + 20 children = 16650
 | Price difference per adult/child | 0.2 |  |  |  | => 10x + 20y = 16650
 |  |  |  |  |  | => 10x + 20x*80% = 16650
 |  |  |  |  |  | => x*(10+20*80%) = 16650
 |  |  |  |  |  | => x*26 = 16650
 |  |  |  |  |  | => x = 16650/26 = 640.38
 |  |  |  |  |  | => y = x*80% = 16650/26 * 80% = 512.31
 | https://www.excelforum.com/excel-formulas-and-functions/1358778-excel-math-problem.html#post5566069
Spreadsheet: 4d0a30e6-0498-4ff9-aa02-5817e0f1c279
Sheet: Table 3.3

Monthly Statistical Bulletin
3.3  Wages and profits share
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012-13 | 2013-14
Wages share (a) (b) – per cent
September | 53.1 | 52.2 | 52.1 | 54 | 53.7
December | 52.5 | 52.1 | 52.5 | 54.3 | 53.2
March | 52.5 | 52.9 | 53.7 | 53.9 | 53
June | 51.9 | 52.3 | 54 | 53.8
Annual average | 52.53097869302741 | 52.41680044613256 | 53.02474579615184 | 54.02708497418395
Profits share (a) (c) – per cent
September | 26.9 | 28.3 | 28.9 | 26.7 | 26.7
December | 27.5 | 28.6 | 28.4 | 26.3 | 27.4
March | 27.3 | 27.4 | 27.3 | 26.5 | 27.4
June | 28.8 | 28.3 | 26.8 | 26.7
Annual average | 27.57538070175288 | 28.15684800109488 | 27.84556629474666 | 26.52402205303229
(a) Quarterly figures are seasonally adjusted.
(b) Compensation of employees as a proportion of total factor income.
(c) Gross operating surplus of financial and non-financial corporations as a proportion of total factor income.
Source: ABS, Australian national accounts: national income, expenditure and product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
Cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-09-03 00:00:00
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Hyperion Line 0189 - Fair Value Investment (current)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 294163d1391210539-set-a-max-amount-in-a-cell-and-send-exrta-to-a-different-cell-book3-updated-
Sheet: Sheet1

 |  |  |  | I want cell C10 to show a max amount of 40 and have any over 40 to show in cell F10
 |  | Date | In | Out | Total
 | Sun | 2014-01-26 00:00:00
 | Mon |  | 09:00:00 | 17:00:00
 | Tue |  | 09:00:00 | 17:00:00
 | Wed |  | 09:00:00 | 17:30:00
 | Thu |  | 09:00:00 | 17:00:00
 | Fri |  | 09:00:00 | 17:15:00
 | Sat
 | Regular |  | Overtime |  | Totals
Spreadsheet: andy_zipper__246__DYNEGY-ICE VOL Jun5
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE: |  |  |  |  |  |  | Data
 |  |  | Data |  |  | Trader | Product | Qty Units | Transactions | Volume
Trader | Product | Qty Units | Transactions | Volume |  | Carson, M | Firm-LD Peak | MWhs | 3 | 5600
[NAME], G | NG Fin BS, LD1 for CGPR | MMBtus | 1 | 155000 |  |  | Firm-LD Peak Total |  | 3 | 5600
 | NG Fin BS, LD1 for GDM | MMBtus | 3 | 2155000 |  | Dorland, C | Firm-LD Peak | MWhs | 10 | 48800
 | NG [NAME], BS, LD1 | MMBtus | 1 | 615000 |  |  | Firm-LD Peak Total |  | 10 | 48800
Pimenov, V | NG [NAME], ID, GDD | MMBtus | 3 | 30000 |  | [NAME], R | Firm-LD Peak | MWhs | 3 | 371200
 | NG [NAME], FP | MMBtus | 4 | 40000 |  |  | Firm-LD Peak Total |  | 3 | 371200
Goodell, S | NG [NAME], FP | MMBtus | 1 | 5000 |  | Motley, M | Firm-LD Off-Peak | MWhs | 2 | 17000
Grand Total |  |  | 13 | 3000000 |  |  | Firm-LD Off-Peak Total |  | 2 | 17000
 |  |  |  |  |  | Grand Total |  |  | 18 | 442600
Spreadsheet: bb5e304d-2041-4d3d-b66f-705a86dfae06
Sheet: Sheet1

2014 Primary Election - OFFICIAL RESULTS | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 427/427 - Total Ballots Cast: 93324
Downloaded at 9/22/2014 1:11:47 AM
 | [NAME] | write-in  - REP
Representative in Congress - REP | 50039 | 151
 | [NAME] | write-in  - DEM
Representative in Congress - DEM | 30014 | 52
 | [NAME] | write-in  - LIB
Representative in Congress - LIB | 1538 | 7
 | [NAME] (Al) Jaeger  - REP | write-in  - REP
Secretary of State - REP | 49495 | 57
 | April  Fairfield  - DEM | write-in  - DEM
Secretary of State - DEM | 28031 | 23
 | Roland  Riemers  - LIB | write-in  - LIB
Secretary of State - LIB | 1460 | 11
 | [NAME] | write-in  - REP
Attorney General - REP | 50236 | 61
 | [NAME]  - DEM | write-in  - DEM
Attorney General - DEM | 27292 | 33
 | [NAME] | write-in  - REP
Agriculture Commissioner - REP | 49130 | 89
 | [NAME] | write-in  - DEM
Agriculture Commissioner - DEM | 29607 | 25
 | [NAME] | write-in  - REP
Public Service Commissioner - REP | 48658 | 30
 | [NAME] | write-in  - REP
Public Service Commissioner [NAME] | 47941 | 45
 | Tyler  Axness  - DEM | write-in  - DEM
Public Service Commissioner [NAME] | 27589 | 31
 | [NAME] | write-in  - DEM
Public Service Commissioner - DEM | 27649 | 29
 | [NAME] | write-in  - REP
Tax Commissioner - REP | 48061 | 65
 | [NAME] | write-in  - DEM
Tax Commissioner - DEM | 27572 | 37
 | [NAME] | write-in  - LIB
Tax Commissioner - LIB | 1464 | 9
 | [NAME] | write-in  - NON
Justice of the Supreme Court - NON | 72345 | 228
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 5d5356e1-43ef-46bf-bed9-e0299cbf563b
Sheet: IDEA Overview

X-LAB 2013  Applicant Questionnaire
Business Name
First Name
Last Name
E-mail
Phone
Address
Address 2
City
State
Zip
Date submitted
1 | Describe your business idea in one sentence
2 | Who are your targeted customers - Identify the top 5 most significant things you know about them?
3 | What problem does your business idea solve for your targeted customers? Why is this the right time for your idea?
4 | What is the root cause to the problem your business idea solves for your targeted customers? Explain how you know for sure this is the root cause to the problem your business idea solves for your targeted customers?
5 | Where do you see your business in 3 - 5 years?
6 | If you were to launch this business venture, or if you have already, who might be / are your top three competitors?
7 | What makes your business venture unique vs. your top three potential / current competitors? Note: if the top three competitors you identified are truly your competitors their business idea solves the same problem your business idea solves for the same targeted customers - Why should your targeted customers choose your business vs. the other three to solve their problem?
8 | Now that you've identified what makes your business unique - tell us what your business must be able to do exceedingly well in order to deliver on what differentiates your company from your competitors.
9 | If your business is a non-profit venture what are your thoughts about how you will secure funding (both startup and operational funding) for your venture?
10 | If your business is a for-profit business what are your primary sources of revenue? Products, services, other - and what percent of your total revenue are each?
11 | How much cash has been invested in your business to date?
12 | What are the three most significant business challenges you must overecome and what are you doing to address them?
13 | Tell us about your team. Who is on it? What is their direct and relevant experience, and has anyone on your team successfully launched a new business venture? If so, which one? When?
14 | Do you have any advisors? If so, please, include a list of their names and their relevant capabilities.
15 | What is the key achievement in the next six months that will significantly impact the success of your business (other than funding)? This can be a new customer, a critical hire, or a new product or service launch, etc.
16 | Are you willing to make yourself available in the Cincinnati area?
17 | What specifically do you want X-LAB to help you with, and why?
18 | List three reason why we should choose you to be one of the 2013 X-LAB finalists.
19 | How did you learn about [NAME]?
Spreadsheet: 863876d1711271055-google-sheet-function-to-excel-2016-function-stock-portfolio-tracking-spreadsheet-11
Sheet: Stock_Ref

Symbol | Name | % Change Realtime | Last Price | 52 Wk Low | 52 Wk High | Position in 52wk
AAPL
BAC
GRVY
GS
IBM
MMM
MSFT
MU
NFLX
ORCL
Stock Ticker
UHAL
WDC
WNC
YHOO
Spreadsheet: 719828d1613840539-replace-if-specific-position-matches-index-test
Sheet: Sheet1

 |  |  |  |  |  | Sample Test of current formula |  |  |  |  |  |  |  |  |  |  |  | Old text | Replace | <Sample Index
Old Text | Desired output |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 30
20AC326 | 2010326 |  |  |  |  | 20AC326 |  |  |  |  |  |  |  |  |  |  |  | D | 40
25Bs99999 | 252099999 |  |  |  |  | 25Bs99999 |  |  |  |  |  |  |  |  |  |  |  | E | 50
21OL34gh7 | 21OL34gh7 |  |  |  |  | 21OL34gh7 |  |  |  |  |  |  |  |  |  |  |  | F | 60
56GG99234 | 567099234 |  |  |  |  | 56GG99234 |  |  |  |  |  |  |  |  |  |  |  | G | 70
53gG10001 | 537010001 |  |  |  |  | 53gG10001 |  |  |  |  |  |  |  |  |  |  |  | H | 80
53AD10001 | 531010001 |  |  |  |  | 53AD10001 |  |  |  |  |  |  |  |  |  |  |  | J | 90
53AD10002 | 531010002 |  |  |  |  | 53AD10002
53AD10003 | 531010003 |  |  |  |  | 53AD10003
53AD10004 | 531010004 |  |  |  |  | 53AD10004
53DG10005 | 534010005 |  |  |  |  | 53DG10005 | <Want this to cell be highlighted)
53AD10006 | 531010006 |  |  |  |  | 53AD10006
53AD10007 | 531010007 |  |  |  |  | 53AD10007
Spreadsheet: 42479d1241034602-excel-2007-excel-2007-to-excel-2003-conversion-forum1-2
Sheet: Summary

Spirit Airlines Airports Conditions
Airport | Currently | Will soon be |  | Airport | Currently | Will soon be
ACY |  |  |  | MCO
ATL |  |  |  | MDE
AUA |  |  |  | MGA
BOG |  |  |  | MYR
BOS |  |  |  | NAS
BQN |  |  |  | ORD
CTG |  |  |  | PAP
CUN |  |  |  | PBI
DCA |  |  |  | PTY
DTW |  |  |  | PUJ
FLL |  |  |  | RSW
FPO |  |  |  | SAP
GUA |  |  |  | SDQ
KIN |  |  |  | SJO
LAS |  |  |  | SJU
LAX |  |  |  | STI
LGA |  |  |  | STT
LIM |  |  |  | SXM
MBJ |  |  |  | TPA
 | 0SM
 | M1/4SM
 | 1/16SM
 | 1/8SM
 | 3/16SM
 | 1/4SM
 | 5/16SM
 | 3/8SM
 | 1/2SM
 | 5/8SM
 | 3/4SM
 | 7/8SM
 | 1SM
 | 1 1/8SM
 | 1 1/4SM
 | 1 3/8SM
 | 1 1/2SM
 | 1 5/8SM
 | 1 3/4SM
 | 1 7/8SM
 | 2SM
 | 2 1/4SM
 | 2 1/2SM
 | 2 3/4SM
 | OVC001
 | OVC002
 | OVC003
 | OVC004
 | OVC005
 | OVC006
 | OVC007
 | OVC008
 | OVC009
 | BKN001
 | BKN002
 | BKN003
 | BKN004
 | BKN005
 | BKN006
 | BKN007
 | BKN008
 | BKN009
 | VV
 | 0100
 | 0200
 | 0300
 | 0400
 | 0500
 | 0600
 | 0700
 | 0800
 | 0900
 | 1000
 | 1100
 | 1200
 | 1300
 | 1400
 | 1500
 | 1600
 | 1700
 | 1800
 | 1900
 | 2000
 | 2100
 | 2200
 | 2300
 | 2400
 | 2500
 | 2600
 | 2700
 | 2800
 | 2900
 | 3000
 | 3100
 | 3200
 | 3300
 | 3400
 | 3500
 | 3600
 | 3700
 | 3800
 | 3900
 | 4000
 | 4100
 | 4200
 | 4300
 | 4400
 | 4500
 | 4600
 | 4700
 | 4800
Spreadsheet: 757263d1638171776-filter-the-top-12-highest-number-with-duplicates-then-lookup-to-its-reference-criteria-sample
Sheet: sample file

 | No. | Qty |  | No. | Qty |  |  | TOP 12
 | 1 | 4 |  | 20 | 7 |  |  |  |  |  |  |  |  | =IFERROR(LARGE(($C$4:$C$22,$F$4:$F$22),{7;8;9;10;11;12}),"")
 | 2 | 2 |  | 21 | 5 |  |  | No. | Qty |  | No. | Qty
 | 3 | 10 |  | 22 | 5 |  |  | 3 |  |  | 32 |  |  | Expected Result
 | 4 | 6 |  | 23 | 8 |  |  | 6 | 9 |  | 34 | 7
 | 5 | 6 |  | 24 | 5 |  |  | 23 | 8 |  | 4 | 6
 | 6 | 9 |  | 25 | 3 |  |  | 8 | 7 |  | 5 | 6
 | 7 | 3 |  | 26 | 4 |  |  | 11 | 7 |  | 12 | 6
 | 8 | 7 |  | 27 | 5 |  |  | 20 | 7 |  | 13 | 5
 | 9 | 4 |  | 28 | 2
 | 10 | 3 |  | 29 | 4
 | 11 | 7 |  | 30 | 3
 | 12 | 6 |  | 31 | 3
 | 13 | 5 |  | 32 | 7
 | 14 | 3 |  | 33 | 4
 | 15 | 5 |  | 34 | 7
 | 16 | 5 |  | 35 | 5
 | 17 | 3 |  | 36 | 4
 | 18 | 5 |  | 37 | 4
 | 19 | 4 |  | 38 | 4
Spreadsheet: mary_fischer__25631__30R
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 2000 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -1000
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -67902281
RE - Beg Bal |  | 0920 |  | -27394230 |  | -18424036
RE - Net Income |  | 0930 |  | -18424036 |  | 18424036 |  | -135521
RE - Net Income (Fair Value Adjustment) |  | 0931 |  |  |  |  |  |  |  |  |  |  |  | 372000 |  | Goodwill amort
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  | -1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO # |  | 11
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215 |  | 67831000
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217 |  | 45890548
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 113182d1309172649-formula-required-which-meets-12-conditions-formula-required
Sheet: Sheet1

 | 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
 | A | A | O | M | M | N | N | O | A | A | O | M | M | N | N | O | A | A | O | M | M | N | N | O | A | A | O | M | M | N | N
 | A | M | D | E | N | A | A | A | M | M | C | D | D | M | M | M | N | N | N | A | A | A | D | D | D | E | E | E | A | A | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF D3= "O", IF D4=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | D= | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | E= | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | C= | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | A= | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | M= | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | N= | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if D3= ("A","M","N"), IF D4=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | D= | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | E= | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | C= | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | A= | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | M= | 0
 | What is required a Formula in D5 where all these ~ 12 conditions are met |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | N= | 0
 | Explanation
 | We have two major conditions and each major condition have 6 sub conditions
 | 1) | IF D3="O"then in D4 if one of the six conditions true like "D,E,C,A,M,N" then answer is either 12, 16, or 8 and IF false answer is 0
 | 2) | IF D3="A,M,N"then in D4 if one of the six conditions true like "D,E,C,A,M,N" then answer is either 4, 8, or 0 and IF false answer is 0
Spreadsheet: 237945d1369335643-colored-cells-based-on-drop-down-selection-antibiogram
Sheet: Sheet1

 |  |  | Gentamicin
Gram-Positive | Strep (Grp A,B,C, G)
 | S. pneumonia
 | Viridans Strep
 | [NAME]
 | E. faecalis
 | E. faecium
 | S. aureus (MSSA)
 | S. aureus (MRSA)
 | S. aureus (CA-MRSA)
 | C. epidermidis
 | C. jeikeium
 | L. monocytogenes
Gram-Negative | N. gonorrhea
 | N.meningitidis
 | M. catarrhalis
 | H. influenza
 | E. coli
 | Klebsiella sp.
 | E. coli/ESBL+
 | E. coli/Kleb KPC+
 | Enterobacter sp.
 | Serratia sp.
 | Salmonella sp.
 | Shigella sp.
 | Proteus mirabilis
 | Proteus vulgaris
 | [NAME] sp.
 | Morganella sp.
 | Citrobacter sp.
 | Aeromonas sp.
 | Acinetobacter sp.
 | P. aeruginosa
 | B. (P.) cepacia
 | S. (X.) maltophilia
 | Y. enterocolitica
 | [NAME]
 | F. tularensis
 | [NAME] sp.
 | P. multicida
 | H. ducreyi
 | V. vulnificus
Atypical | [NAME] sp.
 | M. pneumoniae
 | Rickettsia sp.
 | Mycobacterium avium
[NAME] | Actinomyces
 | Bacteroides fragilis
 | P. melaninogenica
 | C. difficile
 | Clostrida (not difficile)
 | Peptostreptococcus
Spreadsheet: 098444c3-46d0-473e-a53f-19d911421d25
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
Release | Release | Distributor | Music | Country of | Format | Catalogue | Bar Code/APN | Original | Release Date | Track | Represent rights | Track Primary | Track Original | Track Country | Track Country | ISRC | Track Other
Artist | Title | (if not self) | Style | Origin | (eg CD, DVD, Digital/On-Line)) | Number | (if known) | Release Label |  | Title | Licensed to PPCA (Y/N) | Artist (and Nationality)* | Release Date * | Recorded | of Origin * | (if known) | Performers (and Nationality)
* If Different to Release information
Notes:
Fields highlighted are mandatory
Music Style
The style of music on the recording. Current categories are: Ambient/Inspirational/Gospel, Childrens, Classical/Operatic, Comedy/Spoken Word, Country/Folk, Easy Listening/MOR/Nostalgic, Jazz/Big Band/Swing
 |  |  |  |  | Rock/Pop/Dance, Soul/Rhythm & Blues, Traditional/Ethnic/World Music.
Country of Origin
Refers to the country of origin of the original maker of the recording. For example, a recording by a US artist signed to a UK label would be considered to have a UK country of origin.
Original Release Label
Label under which the recording was originally issued. Usually denoted by the (P) credit.
ISRC
The ISRC (International Standard Recording Code) is the international identification system for sound recordings and music video recordings.
Each ISRC is a unique and permanent identifier for a specific recording which can be permanently encoded into a product as its digital fingerprint.
Spreadsheet: 693666d1599078192-if-cells-have-a-date-number-of-months-and-warranty-return-yes-no-unknown-warranty
Sheet: Sheet1

Warranty | Complaint Date | Date of install | Product Age In Months | True Warranty
Yes | 2013-01-03 10:54:00 | Not Known | Not Known
Yes | 2013-01-18 09:33:00 | 18/01/2011 | 24
No | 2020-06-20 00:00:00 | 2020-05-20 00:00:00 | 1
Spreadsheet: 93175d1292780090-automatically-picking-up-number-and-color-sample-workbook
Sheet: FINAL

026
242
323
072
126
028
721
226
092
218
272
326
291
282
273
642
229
382
239
428
266
249
267
268
277
926
728
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 328957d1404147649-sumif-s-with-date-criteria-testdates
Sheet: Sheet1

 |  |  |  |  |  | January | February | March
Date | Amount | Category |  |  | Category | Amount | Amount | Amount
2014-01-01 00:00:00 | 5 | A |  |  | A | 5 | 0 | 0
2014-01-15 00:00:00 | 8 | B |  |  | B | 8 | 0 | 0
2014-02-06 00:00:00 | 7 | C |  |  | C | 0 | 7 | 7
2014-03-09 00:00:00 | 7 | C |  |  | D | 0 | 0 | 3
2014-03-25 00:00:00 | 3 | D |  |  | Totals
Spreadsheet: 758931d1639157797-lookup-to-match-2-criteria-example
Sheet: Latest

Learner ID | [NAME] | D.O.B | Status | Region | [NAME] Type | Document Received | Lead | Trainer | Course | Course Code | Date Claimed? | Cert Emailed?
20098 | [NAME] | 1973-02-24 00:00:00 |  | Man | U | Complete | N/A | [NAME] | C&G - Certificate for Introduction to Customer Service Level 1 | 50118377 | 2021-12-10 00:00:00 | N
19964 | [NAME] | 1988-12-05 00:00:00 |  | Man | U | Complete | N/A | [NAME] | NCFE - Award in Health and Safety Awareness Level 1 | 60052077 | 2021-11-15 00:00:00 | Y
20077 | [NAME] | 1980-08-24 00:00:00 |  | Man | U | Complete | N/A | [NAME] | C&G - Certificate in Employability Skills Level 1 | 60136431 | November | Y
20268 | [NAME] | 1962-03-16 00:00:00 |  | Lon | U | Complete | N/A | Ilona | C&G - Certificate for Introduction to Customer Service Level 1 | 50118377 | 2021-12-10 00:00:00 | N
20098 | [NAME] | 1973-02-24 00:00:00 |  | Man | U | Complete | N/A | [NAME] | NCFE - Award in Health and Safety Awareness Level 1 | 60052077 | November | Y
Spreadsheet: 330644d1404822819-summing-across-multiple-sheets-by-specific-name-vlookup-template-trivia-scorecard
Sheet: Week4

TEAM NAME: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL
[NAME] | 0 | 9 | 9 | 9 | 0 | 10.5 | 10.5
Danites | 5 | 2 | 3 | 4 | 5 | 6 | 9
[NAME] | 6 | 6 | 6 | 5
Stepdads | 1 | 1 | 2 | 2 | 2 | 2 | 2
[NAME] | 2