tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a8767e96-d357-40cd-bb26-200c72d717b7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFLRO | Test | FFLRO | Flunitrazepam Confirmation, Serum | Flunitrazepam (Rohypnol) | Gas Chromatography-Mass Spectrometry (GC/MS) | Plain, Red-Top Tube: Red |  |  | 10 |  | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 5 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 5 mL of serum refrigerated in a plastic vial. | 2 mL | Hemolysis:	NA Thawing:	Warm OK: Cold OK Lipemia:	NA Icterus:	NA Other	NA | Units:	Flunitrazepam		ng/mL 	7-Aminoflunitrazepam	ng/mL  Peak plasma Flunitrazepam concentrations in patients receiving chronic, recommended dosages: 10 - 20 ng/mL.  Note: Flunitrazepam is not legally marketed in the United States.   Test Performed by:	Medtox Laboratories, Inc.  			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 80154 |  |  |  |  | Medtox Laboratories, Inc.
FFLRO | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FFLRO | Result | Z1075 | Flunitrazepam | Flunitrazepam | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFLRO | Result | Z1074 | 7-Aminoflunitrazepam | 7-Aminoflunitrazepam | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: K

Kelly. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 90367d1290102348-excel-2007-conditional-formatting-time-excel
Sheet: 001

 |  |  | Scheduled | Actual
 |  |  | 18-NOV-2010 0930 | 18-NOV-2010 0800
 |  |  | 18-NOV-2010 0931 | 18-NOV-2010 0801
 |  |  | 18-NOV-2010 0932
 |  |  | 18-NOV-2010 0933 | 18-NOV-2010 0803
 |  |  | 18-NOV-2010 0934 | 18-NOV-2010 0804
 |  |  | 18-NOV-2010 0935
 |  |  | 18-NOV-2010 0936 | 18-NOV-2010 0806
 |  |  | 18-NOV-2010 0937
 |  |  | 18-NOV-2010 0938 | 18-NOV-2010 0808
 |  |  | 18-NOV-2010 0939 | 18-NOV-2010 0809
 |  |  | 18-NOV-2010 0940 | 18-NOV-2010 0811
 |  |  | 18-NOV-2010 0941 | 18-NOV-2010 0811
 |  |  | 18-NOV-2010 0942
 |  |  | 18-NOV-2010 0943 | 18-NOV-2010 0813
 |  |  | 18-NOV-2010 0944 | 18-NOV-2010 0814
 |  |  | 18-NOV-2010 0945 | 18-NOV-2010 0815
 |  |  | 18-NOV-2010 0946 | 18-NOV-2010 0816
 |  |  | 18-NOV-2010 0947
 |  |  | 18-NOV-2010 0948 | 18-NOV-2010 0818
 |  |  | 18-NOV-2010 0949 | 18-NOV-2010 0819
 |  |  | 18-NOV-2010 0950 | 18-NOV-2010 0820
 |  |  | 18-NOV-2010 0951 | 18-NOV-2010 0821
 |  |  | 18-NOV-2010 0952 | 18-NOV-2010 0822
 |  |  | 18-NOV-2010 0953
 |  |  | 18-NOV-2010 0954 | 18-NOV-2010 0824
 |  |  | 18-NOV-2010 0955 | 18-NOV-2010 0825
Spreadsheet: darrell_schoolcraft__7235__saledoc01_9TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power LLC
Deal Date: |  |  | 2002-01-09 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/11/02-01/31/02 |  |  | FAX Number:
Total Quantity |  |  | 158 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.08
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/11/02 | 2002-01-31 00:00:00 | 158 |  | 158 |  | 158
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 158 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 466022d1465986220-how-to-do-addtion-in-pivot-and-make-it-decnding-order-sort
Sheet: Sheet5

Count of REMARKS | Column Labels |  |  |  |  |  |  |  |  | solution should be likely this
Row Labels | BULLISH | BEARISH |  |  |  |  |  |  |  | INFY | 9
ACC |  | 1 |  |  |  |  |  |  |  | YESBANK | 8 | 1
ADANIENT | 4 |  |  |  |  |  |  |  |  | AXISBANK | 8
ADANIPORTS | 5 |  |  |  |  |  |  |  |  | RECLTD | 1 | 7
ADANIPOWER | 2 |  |  |  |  |  |  |  |  | SBIN |  | 8
AJANTPHARM | 2 | 1 |  |  |  |  |  |  |  | HDFC | 7
ALBK | 3 |  |  |  |  |  |  |  |  | HEROMOTOCO | 7
[NAME] | 1 |  |  |  |  |  |  |  |  | SYNDIBANK |  | 7
AMBUJACEM |  | 4 |  |  |  |  |  |  |  | ASHOKLEY | 6
ANDHRABANK | 3
APOLLOHOSP | 1
APOLLOTYRE | 4
ARVIND | 1 | 2
ASHOKLEY |  | 6
ASIANPAINT |  | 5
AUROPHARMA | 3 | 3
AXISBANK |  | 8
BAJAJ-AUTO |  | 2
BAJFINANCE |  | 2
BANKBARODA | 5 | 1
BANKINDIA | 3
BATAINDIA | 1
BEL | 1 | 1
BHARATFORG | 2 | 1
BHARTIARTL |  | 6
BHEL | 4
BIOCON |  | 3
BPCL |  | 5
[NAME] | 2 | 1
CAIRN |  | 6
CASTROLIND |  | 2
CEATLTD |  | 1
CENTURYTEX | 1
CIPLA | 3
COALINDIA |  | 6
COLPAL |  | 1
CROMPGREAV | 4
CUMMINSIND | 2
DABUR | 3
DHFL | 2
[NAME] | 4
DLF | 5
DRREDDY |  | 3
ENGINERSIN | 1
FEDERALBNK | 1
[NAME] | 5
GLENMARK |  | 2
GRANULES | 2 | 1
HAVELLS | 1 | 1
HCLTECH |  | 4
HDFC |  | 7
HDFCBANK | 1 | 2
HDIL | 3
HEROMOTOCO |  | 7
HEXAWARE |  | 2
HINDALCO |  | 2
HINDPETRO |  | 5
HINDUNILVR |  | 4
IBREALEST | 6
IBULHSGFIN | 1 | 2
ICICIBANK | 6
IDBI | 4
IDEA |  | 5
IDFC |  | 1
IFCI | 5
IGL | 4
INDUSINDBK |  | 4
INFRATEL | 2 | 2
INFY |  | 9
IOC |  | 1
IRB |  | 3
ITC | 6
JETAIRWAYS | 3
JINDALSTEL | 4
JISLJALEQS | 1 | 3
JPASSOCIAT | 1
JSWSTEEL |  | 3
JUBLFOOD | 4
JUSTDIAL | 5
KOTAKBANK |  | 4
KPIT |  | 6
KSCL |  | 3
KTKBANK | 1
L&TFH | 4
LICHSGFIN | 2 | 4
LT |  | 5
[NAME] |  | 2
M&M |  | 5
M&MFIN | 1 | 1
MARUTI |  | 6
[NAME] |  | 2
MOTHERSUMI |  | 1
NCC | 2
NHPC | 2
NMDC | 3 | 1
NTPC |  | 5
ONGC |  | 5
ORIENTBANK | 3
PCJEWELLER | 1
PETRONET | 5
PFC | 4 | 1
PIDILITIND |  | 1
PNB | 6
POWERGRID | 1 | 3
PTC | 1
RECLTD | 7 | 1
RELCAPITAL | 4
RELIANCE | 1 | 5
[NAME] | 6
RPOWER | 4
SAIL | 2
SBIN | 8
SIEMENS |  | 1
SKSMICRO |  | 3
SOUTHBANK | 1
SRF |  | 3
SRTRANSFIN | 1 | 2
STAR | 1
SUNPHARMA | 4
SUNTV | 3
SYNDIBANK | 7
TATACHEM |  | 1
TATAGLOBAL |  | 5
TATAMOTORS | 6
TATAMTRDVR | 3
TATAPOWER |  | 3
TATASTEEL | 4
TCS |  | 6
TECHM |  | 6
TITAN | 5
TV18BRDCST | 1
TVSMOTOR |  | 1
UCOBANK | 2
ULTRACEMCO |  | 3
UNIONBANK | 5
UNITECH | 3
UPL | 1 | 5
VEDL | 3
VOLTAS | 2 | 1
WIPRO | 2 | 3
WOCKPHARMA | 3 | 1
YESBANK | 1 | 8
ZEEL |  | 4
Spreadsheet: 92261d1291888527-dealing-with-single-and-multiple-responses-book2
Sheet: Sheet1

Question | Answer |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | < Answers
1 | 1 |  | Columns A & B are the raw data.  Column B represents both single and multiple responses to a question.    I am looking for a way to add up how many times people responded 1, 2, 3, 4, or 5, to each question, but it needs to take into account all possible multiple responses (e.g. 1,3 and 1,2,4,5 are both counted as 1s as well as other values) ... if that makes sense? The end result should be a total of how many times each answer was chosen (e.g. to the right)  This is doing my head in! |  |  |  |  | Q1
2 | 1,3 |  |  |  |  |  |  | Q2
3 | 0 |  |  |  |  |  |  | Q3
4 | 1 |  |  |  |  |  |  | Q4
5 | 1,2,4,5 |  |  |  |  |  |  | Q5
 |  |  |  |  |  |  |  | Q6
6 | 1,3,4 |  |  |  |  |  |  | Q7
7 | 1 |  |  |  |  |  |  | Q8
8 | 0 |  |  |  |  |  |  | Q9
 |  |  |  |  |  |  |  | Q10
9 | 1 |  |  |  |  |  |  | Q11
10 | 1 |  |  |  |  |  |  | Q12
11 | 1 |  |  |  |  |  |  | Q13
12 | 1 |  |  |  |  |  |  | Q14
13 | 2 |  |  |  |  |  |  | Q15
14 | 1 |  |  |  |  |  |  | Q16
15 | 2 |  |  |  |  |  |  | Q17
16 | 0 |  |  |  |  |  |  | Q18
17 | 3 |  |  |  |  |  |  | Q19
18 | 1
19 | 0
1 | 1
2 | 1,3
3 | 0
4 | 1
5 | 1,2,4,5
6 | 1,3,4
7 | 1
8 | 0
9 | 1
10 | 1
11 | 1,2
12 | 1
13 | 2
14 | 1
15 | 2
16 | 0
17 | 3
18 | 1
19 | 0
Spreadsheet: 547061d1510318915-dynamic-chart-size-and-coords-chart
Sheet: Initial

 | Data A | Data B
 | 14 | 25
 | 13 | 84
 | 31 | 41
 | 24 | 65
 | 47 | 68
 | 46 | 14
 | 32 | 14
 | 67 | 25
 | 89 | 84
 | 68 | 65
 | 45 | 78
 | 88 | 46 |  |  |  | Data A | B2 | B6
 |  |  |  |  |  | Data B | C2 | C10
 | - This is how the chart looks like when first created
 |  |  | dva | =ADR.POŚR("Initial!"&Initial!$H$14&":"&Initial!$I$14)
 |  |  | [NAME] | =ADR.POŚR("Initial!"&Initial!$H$13&":"&Initial!$I$13)
Spreadsheet: 795600d1662793905-how-to-return-value-from-another-sheet-based-on-x-y-and-z-2022-09-10-oeldere-hurts2brown-example-3-
Sheet: Eagles

Position | Game | Quarter | TD? | result
QB | 1 | 1 | 0
QB | 1 | 2 | 0
QB | 1 | 3 | 0
QB | 1 | 4 | 0
QB | 2 | 1 | 1
QB | 2 | 2 | 0
QB | 2 | 3 | 1
QB | 2 | 4 | 0
QB | 3 | 1 | 0
QB | 3 | 2 | 2
QB | 3 | 3 | 1
QB | 3 | 4 | 1
Spreadsheet: 814342d1674299056-returning-a-random-value-from-a-specific-list-without-immediate-duplicates-test
Sheet: Sheet1

 | A1 | A2 | B1 | B2 | C1 | C2 | D1 | D2 | E1 | E2 |  | Person | Option 1 | Option 2 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
1 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
2 |  |  |  |  |  |  | X | X | P |  |  |  |  |  |  |  | A2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
3 |  |  |  |  | P |  | X | X | X | X |  |  |  |  |  |  | B1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
4 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
5 |  |  |  |  |  |  | P |  | X | X |  |  |  |  |  |  | C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
6 |  |  |  |  |  |  | X | X |  | P |  |  |  |  |  |  | C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G
7 |  |  |  |  |  | P | X | X | X | X |  |  |  |  |  |  | D1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
8 |  |  |  |  |  |  | X | X | P |  |  |  |  |  |  |  | D2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
9 | P |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  | E1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J
10 |  | P |  |  |  |  | X | X | X | X |  |  |  |  |  |  | E2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
11 |  |  |  |  |  | P | X | X | X | X
12 |  |  |  | P |  |  | X | X | X | X
13 | P |  |  |  |  |  | X | X | X | X
14 |  | P |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  |  | A1 | A2 | B1 | B2 | C1 | C2 | D1 | D2 | E1 | E2
15 |  |  |  | P | X | X | X | X | X | X |  |  |  |  |  |  |  | A1
16 |  |  |  |  |  |  | P |  | X | X |  |  |  |  |  |  |  | A2
17 | P |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  | B1
18 |  |  |  |  |  |  | X | X |  | P |  |  |  |  |  |  |  | B2
19 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  |  | C1
20 |  |  |  |  | P |  | X | X | X | X |  |  |  |  |  |  |  | C2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E2
Spreadsheet: 828148d1683254045-how-do-i-filter-addresses-based-on-a-list-of-zip-codes-youreally-sample-mailing-list-and-zips
Sheet: Sheet1

 | Xxx | Xxx | Xxx | CO | 80229 | 80229 | US | 0 | 0 | 0 | 0 | 0 | 0 | [NAME] | CO | Limited Liability Company | Xxx | Xxx | Xxx | Jr.
Spreadsheet: 870037d1716545155-sumifs-criteria-not-working-v3
Sheet: WEEK3

 | DROP DOWN MENU ----> |  |  | 2024-05-01 00:00:00
 | 2024-05-20 00:00:00
 | SITE | Vacancies (P) | Interview Slots | Interviews Attended (s) | Attended  vs  Slots | Job Offers (z) | Offers  vs  Vacancies
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | District Office
 | [NAME]
 | Grand Total
Spreadsheet: louise_kitchen__22843__Hot List Update 06-25-01
Sheet: BHLP

Deal Description Sheet - 6/25/01
Bridgeline
YTD EBIT forecast | -10828000 |  | 2nd Qtr EBIT forecast | -5182000
YTD EBIT plan | -13490000 |  | 2nd Qtr EBIT plan | -3372000
[NAME] | 2662000 |  | [NAME] | -1810000
Project Name | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Compensation Plan | Incentive Plan for BHLP Employees and Upper Management.  Recommend Accrual Bonus Funding based on EBITDA performance targets.  Revision of Performance Review to incorporate new catergories. | 0 | 2001-05-31 00:00:00 | 1 | 2001-05-25 00:00:00 | Since [NAME] refuses to sing the proposed [NAME] compensation plan, the board has two alternatives : 1. Have another officer of [NAME] sign the plan, 2. Make all secunded employees from both parents Bridgeline employees.  Since our intent is to sell our equity interest and based on our experience with HPL, I think it would be best to make all individuals working or hired, [NAME] employees.
Blowfish | Sale of Napoleonville Land led by [NAME], Storage. | $5 MM | 2001-06-05 00:00:00 | 1 | 2001-09-01 00:00:00 | [NAME] and [NAME] had lunch with Texas Brine who operates and drills for salt on OXY's behalf.  OXY's preception of actual brine reserves is much greater than reality.  Informed Texas Brine of Dow's interest for the land.  Texas Brine is going to send a proposal for the land and is going to make and introduction to another OXY representative.
13 & 14 Workorder | Workorder drafted by Technical Services for infrastructure to get pad gas out of Wells 13 & 14 on Dow property. | $ -847 K | 2001-04-30 00:00:00 | 1 | 2001-05-01 00:00:00 | Received revised work order with new numbers for labor.  Accepted by [NAME].  Signed and approved.
Spreadsheet: 164651d1340827191-use-sumifs-only-when-first-character-in-cell-matches-criteria-excel-example2
Sheet: Sheet1

Customer | Currency | Amount | Date | Invoice
98012 | USD | 72662.5 | 2012-03-08 00:00:00 | T114555 |  | RESULTS
98012 | USD | 32539.52 | 2012-03-30 00:00:00 | O229580 |  | T Invoice | 118217.18
98012 | USD | 29635.77 | 2012-03-15 00:00:00 | O214262 |  | O Invoice | 62175.29
98012 | USD | 15018.24 | 2012-03-30 00:00:00 | [NAME]
98012 | USD | 7509.12 | 2012-03-23 00:00:00 | T122940
98012 | EUR | 6006 | 2012-03-13 00:00:00 | T116862
98012 | USD | 5006.08 | 2012-03-27 00:00:00 | T124332
98012 | USD | 2503.04 | 2012-03-16 00:00:00 | T119070
98012 | USD | 15518.2 | 2012-04-10 00:00:00 | T131756
98012 | EUR | 9702 | 2012-05-31 00:00:00 | O283985
94034 | USD | 8869.7 | 2012-03-28 00:00:00 | O214265
94034 | EUR | 162.83 | 2012-03-28 00:00:00 | B353149
94034 | CHF | 93.94 | 2012-03-28 00:00:00 | B353114
94034 | USD | 37411.49 | 2012-05-23 00:00:00 | T155800
94034 | USD | 32886.04 | 2012-05-30 00:00:00 | T158846
Spreadsheet: 806866d1669638968-lookup-with-many-colmns-lookup_version2
Sheet: Planilha1

 | Table 1
 | 1 | 1 | 1 | 1 | 1 | 1 |  | A
 | 2 | 2 | 2 | 2 | 2 | 2 |  | B
 | 3 | 3 | 3 | 3 | 3 | 3 |  | C
 | 4 | 4 | 4 | 4 | 4 | 4 |  | D
 | 5 | 5 | 5 | 5 | 5 | 5 |  | A | 1
 | 6 | 6 | 6 | 6 | 6 | 6 |  | B | 1
 | 7 | 7 | 7 | 7 | 7 | 7 |  | C | 1
 | 8 | 8 | 8 | 8 | 8 | 8 |  | D | 1
 | 9 | 9 | 9 | 9 | 9 | 9 |  | E
 | 10 | 10 | 10 | 10 | 10 | 10 |  | F
 | 11 | 11 | 11 | 11 | 11 | 11 |  | G
 | 12 | 12 | 12 | 12 | 12 | 12 |  | H
 | 13 | 13 | 13 | 13 | 13 | 13 |  | I | 1
 | 14 | 14 | 14 | 14 | 14 | 14 |  | J | 1
 | 15 | 15 | 15 | 15 | 15 | 15 |  | K | 1
 | 16 | 16 | 16 | 16 | 16 | 16 |  | L | 1
 | 17 | 17 | 17 | 17 | 17 | 17 |  | P | 65
 | 18 | 18 | 18 | 18 | 18 | 18 |  | Q
 | 19 | 19 | 19 | 19 | 19 | 19 |  | R
 | 20 | 20 | 20 | 20 | 20 | 20 |  | S | 2
 | 21 | 21 | 21 | 21 | 21 | 21 |  | T
 | Type the number below
 | 9 | 9 | 9 | 9 | 9 | 9 |  | E
 | When I type one of the sequences of numbers above, excel has to bring me the reference letter from Table 1. In this case, excel brought me letter E because I typed 9 9 9 9 9 9
 | For example, if I type, 7, 7, 7, 7, 7, 7 the reference letter is C 1. In this case, the letter C will appear on column I and the number 1 on column J
 | If I type 3, 3, 3, 3, 3, 3, only the Letter C should appear on Column I and nothing will appear on column J
 | If I type 12, 12, 12, 12, 12 the letter H will appear
Spreadsheet: 696902d1601031180-highlighting-a-cell-if-range-of-cells-have-the-same-value-test
Sheet: List1

TEST1 | TEST2
99 | 111 | + | -
99 | 111 | + | -
99 | 111 | + | +
99 | 111 | + | +
99 | 111 | + | +
99 | 111 | + | +
99 | 111 | + | +
99 | 111 | + | +
99 | 111 | + | +
Spreadsheet: 0df290f8-9aa0-43e3-a53e-a47950d9f639
Sheet: CIV Philosophy & Rel Studies

CIVILIZATIONS: PHILOSOPHY & RELIGIOUS STUDIES
Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | Comment
Philosophy
PHIL 211 | CIV-Philosophy & Religious Studies
PHIL 212 | CIV-Philosophy & Religious Studies
PHIL 213 | CIV-Philosophy & Religious Studies
PHIL 220 | CIV-Philosophy & Religious Studies
PHIL 225 | CIV-Philosophy & Religious Studies
PHIL 234 | CIV-Philosophy & Religious Studies
PHIL 251 | CIV-Philosophy & Religious Studies
PHIL 252 | CIV-Philosophy & Religious Studies
PHIL 260 | CIV-Philosophy & Religious Studies
PHIL 280 | CIV-Philosophy & Religious Studies
PHIL 308 | CIV-Philosophy & Religious Studies
PHIL 322 | CIV-Philosophy & Religious Studies
PHIL 328 | CIV-Philosophy & Religious Studies
PHIL 343 | CIV-Philosophy & Religious Studies
PHIL 363 | CIV-Philosophy & Religious Studies
PHIL 370 | CIV-Philosophy & Religious Studies
PHIL 381 | CIV-Philosophy & Religious Studies | Spring 2010 (Confucian Tradition)
Religious Studies
RELS 112 | CIV-Philosophy & Religious Studies
RELS 205 | CIV-Philosophy & Religious Studies
RELS 210 | CIV-Philosophy & Religious Studies
RELS 211 | CIV-Philosophy & Religious Studies
RELS 212 | CIV-Philosophy & Religious Studies
RELS 215 | CIV-Philosophy & Religious Studies
RELS 217 | CIV-Philosophy & Religious Studies
RELS 221 | CIV-Philosophy & Religious Studies
RELS 222 | CIV-Philosophy & Religious Studies
RELS 223 | CIV-Philosophy & Religious Studies
RELS 225 | CIV-Philosophy & Religious Studies
RELS 227 | CIV-Philosophy & Religious Studies
RELS 228 | CIV-Philosophy & Religious Studies
RELS 229 | CIV-Philosophy & Religious Studies
RELS 231 | CIV-Philosophy & Religious Studies
RELS 235 | CIV-Philosophy & Religious Studies
RELS 237 | CIV-Philosophy & Religious Studies
RELS 240 | CIV-Philosophy & Religious Studies
RELS 243 | CIV-Philosophy & Religious Studies
RELS 245 | CIV-Philosophy & Religious Studies
RELS 247 | CIV-Philosophy & Religious Studies
RELS 251 | CIV-Philosophy & Religious Studies
RELS 260 | CIV-Philosophy & Religious Studies
RELS 262 | CIV-Philosophy & Religious Studies
RELS 271 | CIV-Philosophy & Religious Studies
RELS 273 | CIV-Philosophy & Religious Studies
RELS 274 | CIV-Philosophy & Religious Studies
RELS 275 | CIV-Philosophy & Religious Studies
RELS 311 | CIV-Philosophy & Religious Studies
RELS 312 | CIV-Philosophy & Religious Studies
RELS 323 | CIV-Philosophy & Religious Studies
RELS 335 | CIV-Philosophy & Religious Studies
RELS 336 | CIV-Philosophy & Religious Studies
RELS 343 | CIV-Philosophy & Religious Studies
RELS 352 | CIV-Philosophy & Religious Studies
RELS 375 | CIV-Philosophy & Religious Studies
RELS 384 | CIV-Philosophy & Religious Studies
Honors Program
HONR 260 | CIV-Philosophy & Religious Studies
HONR 262 | CIV-Philosophy & Religious Studies
HONR 268 | CIV-Philosophy & Religious Studies
HONR 289 | CIV-Philosophy & Religious Studies
Spreadsheet: 386416d1427786139-sumifs-two-criterias-from-different-columns-book100-gk
Sheet: Monthly Summary

MONTH |  | Trade Debtors Summary |  |  |  |  | Revenue |  |  |  | Trade Debtors Summary - BUDGET
2014-10-01 00:00:00
Sector |  | 0 to 30 Days | 31 to 60 Days | 61 Days + | Total |  |  |  |  |  | Total | Description
[NAME]
TOLL
Tox Free
VIP Packaging
Toyota
Viva
Yates
[NAME]
Westcon
VIP Drum
Transpacific
TradeCom
GRAND TOTAL
Spreadsheet: 57139d1257291078-how-to-find-at-what-attempt-completed-course-table-file
Sheet: Raw Data

Login | Student | Course | Date | Result | Pass
M003753 | AKAMO | AML Client Identification & Verification | 2009-02-16 16:19:00 | 67 | Fail Course
M003753 | AKAMO | AML Client Identification & Verification | 2009-02-16 16:21:00 | 100 | Pass Course
M003753 | AKAMO | Client Profile Book | 2008-12-11 18:59:00 | 100 | Pass Course
M003753 | AKAMO | Financial Planning FSG | 2009-06-10 12:12:00 | 100 | Pass Course
M003753 | AKAMO | Financial Planning FSG | 2009-06-10 12:10:00 | 50 | Fail Course
M003753 | AKAMO | Handling Objections | 2009-06-10 12:33:00 | 100 | Pass Course
M003753 | AKAMO | Reasonable Basis of Advice | 2009-06-10 11:30:00 | 100 | Pass Course
M003753 | AKAMO | Risk - Ownership & Payment | 2009-06-10 19:19:00 | 100 | Pass Course
M003753 | AKAMO | Risk Profile Tool | 2009-06-10 11:53:00 | 100 | Pass Course
M003753 | AKAMO | Risk Profile Tool | 2009-06-10 11:51:00 | 67 | Fail Course
M003753 | AKAMO | Welcome to Advice Academy | 2009-06-12 17:58:00 | 100 | Pass Course
M003753 | AKAMO | Welcome to Advice Academy | 2009-06-12 17:57:00 | 50 | Fail Course
M003753 | AKAMO | Welcome to Advice Academy | 2009-06-12 17:55:00 | 75 | Fail Course
Spreadsheet: 2a774c25-2726-4696-a00c-acb6accf18fa
Sheet: Dropdown Menu

January | Alamance | 2011 | C
February | Alexander |  | CL
March | Alleghany |  | PC
April | [NAME] |  | R
May | [NAME] |  | SN
June | Avery |  | SL
July | Beaufort
August | Bertie
September | Bladen
October | Brunswick
November | Buncombe
December | Burke
 | Cabarrus
 | Caldwell
 | Camden
 | [NAME]
 | Caswell
 | Catawba
 | Chatham
 | Cherokee
 | [NAME]
 | Clay
 | Cleveland
 | Columbus
 | [NAME]
 | Cumberland
 | Currituck
 | Dare
 | [NAME]
 | Davie
 | Duplin
 | Durham
 | Edgecombe
 | [NAME]
 | Franklin
 | [NAME]
 | Gates
 | [NAME]
 | Granville
 | Greene
 | Guilford
 | Halifax
 | Harnett
 | Haywood
 | Henderson
 | Hertford
 | Hoke
 | Hyde
 | Iredell
 | [NAME]
 | [NAME]
 | Jones
 | [NAME]
 | Lenoir
 | Lincoln
 | Macon
 | Madison
 | [NAME]
 | McDowell
 | [NAME]
 | Mitchell
 | Montgomery
 | Moore
 | Nash
 | New Hanover
 | Northampton
 | Onslow
 | Orange
 | [NAME]
 | Pasquotank
 | Pender
 | Perquimans
 | Person
 | Pitt
 | Polk
 | Randolph
 | Richmond
 | Robeson
 | Rockingham
 | [NAME]
 | Rutherford
 | Sampson
 | Scotland
 | Stanly
 | Stokes
 | [NAME]
 | Swain
 | Transylvania
 | Tyrrell
 | Union
 | Vance
 | Wake
 | [NAME]
 | Washington
 | [NAME]
 | [NAME]
 | Wilkes
 | Wilson
 | Yadkin
 | [NAME]