tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 90082d1289837955-frequency-calculations-753269_lancasteruni
Sheet: Sheet1

student ID | MOD CODE
111 | A
111 | A |  | Count of MOD CODE | Column Labels
112 | A |  | Row Labels | A | B | C | Grand Total
112 | B |  | 111 | 2 |  |  | 2
113 | C |  | 112 | 1 | 1 |  | 2
114 | B |  | 113 |  |  | 1 | 1
 |  |  | 114 |  | 1 |  | 1
 |  |  | Grand Total | 3 | 2 | 1 | 6
Spreadsheet: 5dc174d9-8634-45d6-9c2e-238e179f8ae7
Sheet: 8-Annual Financial Report

Annual Financial Report
FY 2014-2015
District:
School:
 |  | Due September 30, 2015
 |  |  | FY 14-15
 |  | PROGRAM CATEGORIES | Budget | Actual Expenditures
 | Instructional Program
 | 1 | Salaries (0100)
 | 2 | Employee Benefits (0200)
 | 3 | Purchased Professional & Technical Services (0300)
 | 4 | Other Purchased Services (0500)
 | 5 | Travel, Registration, and Entrance (0580)
 | 6 | Supplies (0600)
 | 7 | Books and Periodicals (0640)
 | 8 | Other (0800)
 | 9 | Subtotal Instructional Program  (lines 1 through 8)
 | Support Program
 | 9 | Salaries (0100)
 | 10 | Employee Benefits (0200)
 | 11 | Purchased Professional & Technical Services (0300)
 | 12 | Other Purchased Services (0500)
 | 13 | Travel, Registration, and Entrance (0580)
 | 14 | Supplies (0600)
 | 15 | Books and Periodicals (0640)
 | 16 | Other Expenses (0800)
 | 17 | Subtotal Support Program (lines 9 through 17)
 | 18 | Indirect Costs
 | 19 | Non-Capitalized Equipment (0735)
 | 20 | Capitalized Equipment (0730)
 | 21 | Total Budget
 |  | Typed Name of Person Preparing Report                 Date |  |  | Signature of School District Authorized Representative*
 |  | *Check with your school district budget office for the signature of the school district authorized representative.
Spreadsheet: 767709d1644590097-comparing-cells-in-mail-merge-sample-sheet
Sheet: Sheet1

First Name | Last Name | Mailing Address
[NAME] | Hodges | 6 Main St
Sue | Hodges | 6 Main St
Betty | White | 231 Carpenter Rd
[NAME] | Truman | 13 Jones Ave
[NAME] | [NAME] | 13 Jones Ave
[NAME] | Edwards | 32 Lowell
[NAME] | Edwards | 32 Lowell
[NAME] | [NAME] | 62 Soloman
Spreadsheet: 170917d1343490194-route-planning-route_example_v2
Sheet: Ark1

 | MONDAY |  |  |  |  |  |  |  |  |  |  | ROUTES (these are the constant order of the route)
 | INPUT THE ACTUAL SHOPS GETTING DELIVERIES |  |  |  |  | NORTH | WEST | EAST | SOUTH | SOUTH #2 |  | NORTH | WEST | EAST | SOUTH | SOUTH #2
 | Shop 1 |  |  |  |  | Shop 5 | Shop 1 | Shop 3 | Shop 8 | n/a |  | Shop 5 | Shop 1 | Shop 3 | Shop 8 | Shop 13
 | Shop 2 |  |  |  |  | Shop 4 | Shop 9 | Shop 7 | Shop 10 |  |  | Shop 4 | Shop 9 | Shop 7 | Shop 10 | Shop 11
 | Shop 3 |  |  |  |  | Shop 6 | Shop 2 |  |  |  |  | Shop 6 | Shop 2 | Shop 15
 | Shop 4 |  |  |  |  |  |  |  |  |  |  | Shop 12 | Shop 16
 | Shop 5
 | Shop 6
 | Shop 7
 | Shop 8
 | Shop 9
 | Shop 10
 | TUESDAY
 | INPUT THE ACTUAL SHOPS GETTING DELIVERIES |  |  |  |  | NORTH | WEST | EAST | SOUTH | SOUTH #2
 | Shop 3 |  |  |  |  | Shop 5 | n/a | Shop 3 | Shop 8 | Shop 13
 | Shop 5 |  |  |  |  | Shop 6 |  | Shop 7 | Shop 10 | Shop 11
 | Shop 6 |  |  |  |  | Shop 12 |  | Shop 15
 | Shop 7
 | Shop 8
 | Shop 10
 | Shop 11
 | Shop 12
 | Shop 13
 | Shop 15
Spreadsheet: 2119837a-3c79-4b6a-969b-8909a0f048d2
Sheet: Sheet1

Clerkship Sessions Schedule - Block 1 | Unnamed: 1 | Unnamed: 2
Week 1 | Orientation | Monday, 7/7/2014 - Burnette Womack Clinical Skills Lab
Check "Orientation" on Clerkship website for times | Orientation to the logistics of the clerkship and preparation for the CARE assignment (TBL session).
 | Lunch
 | MSK and Procedures workshop. (wear or bring clothes to allow you to practice musculoskeletal exams on each other:  shorts and T shirts).
 | Adjourn
Week 2 |  | WEDNESDAY, 7/16/2014
 |  | Fam Med Building Room 244
10:30:00 | Pharmacy Talk | [NAME], PharmD
11:30:00 | Lunch
 |  | Fam Med Building Room 238/239
01:15:00 | Guideline Discussions | [NAME], MD
03:00:00 | Break
03:15:00 | Video Review | [NAME], MD
04:45:00 | Adjourn
Week 3 |  | WEDNESDAY, 7/23/2014
08:45:00 | Pause for Procedures ([NAME]) | Fam Med Building Auditorium
09:45:00 | EBM (Mounsey) | Fam Med Building Auditorium
10:50:00 | Care Transitions | Fam Med Building Auditorium
11:45:00 | Break, Lunch
12:00:00 | Grand Rounds: Opiod Perscribing ([NAME]) | Fam Med Building Auditorium
 | Clerkship Session | Fam Med Building Room 238/239
01:00:00 | Working With Registries | [NAME], MD
03:00:00 | Review CARE Assignment | [NAME], MD
03:30:00 | Individual Feedback | [NAME], MD (Kelly's office, Room 218)
 |  | 3:30-5:00
Week 4 |  | WEDNESDAY, 7/30/2014 - Fam Med Building, Room 238/239
02:00:00 | [NAME] (OPE) | [NAME], MD, MPH
 |  | Students 1-3
05:00:00 | Adjourn
Week 4 |  | FRIDAY, 8/1/2014 - Fam Med Building, Room 238/239
08:00:00 | [NAME] (OPE) | [NAME], MD, MPH
 |  | Students 4-6
12:00:00 | Adjourn
Week 5 | OR | FRIDAY, 8/8/2014 - Fam Med Building Room 238/239
08:00:00 | Group Discussion-Share key components and reflections from Consultation notes | [NAME], MD
11:00:00 | Adjourn
Spreadsheet: 6166da5a-5cdd-47f7-b720-94e0522d6545
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 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c | c
 | [NAME] GRAN CANARIA
 | Por mes y nacionalidad. 2000-2014.
 |  | [NAME] |  |  |  | Países Estudiados
 |  | 2000 |  |  |  | Alemania |  | Irlanda
 |  | 2001 |  |  |  | Austria |  | Italia
 |  | 2002 |  |  |  | Bélgica |  | [NAME]
 |  | 2003 |  |  |  | Dinamarca |  | [NAME]
 |  | 2004 |  |  |  | Polonia |  | [NAME]
 |  | 2005 |  |  |  | Finlandia |  | [NAME]
 |  | 2006 |  |  |  | Francia |  | Suiza
 |  | 2007 |  |  |  | Gran Bretaña |  | Otros países
 |  | 2008 |  |  |  | Holanda
 |  | 2009
 |  | 2010
 |  | 2011
 |  | 2012
 |  | 2013
 |  | 2014
Spreadsheet: 677891d1589567482-replace-zero-value-to-a-replaced-number-refernce-3-
Sheet: Blad1

 |  |  |  |  |  | Want this
1 | BRAVO |  |  | IF ZERO IN B2 THEN A2 |  | BRAVO
2 | BRAVO |  |  | IF ZERO IN B3 THEN A3 |  | BRAVO
4 | 0 |  |  | IF ZERO IN B4 THEN A4 |  | 4
5 | 0 |  |  | IF ZERO IN B5 THEN A5 |  | 5
6 | CESAR |  |  | IF ZERO IN B6 THEN A6 |  | CESAR
7 | GLOB0 |  |  | IF ZERO IN B7 THEN A7 |  | GLOBO
8 | 0 |  |  | IF ZERO IN B8 THEN A8 |  | 8
Spreadsheet: 31115d1226878017-date-reset-gives-jumbled-result-aus-to-us-test-17nov08
Sheet: Sheet1

Dates 12 Aug 2006 - 19 Sep 2006 (T2)
 | Original |  |  | Altered
 | 2006-12-08 00:00:00 | US |  | 2006-12-08 00:00:00 | Aus
 | 2006-12-08 00:00:00 | US |  | 2006-12-08 00:00:00 | Aus
 | 2006-12-08 00:00:00 | US |  | 2006-12-08 00:00:00 | Aus
 | 2006-12-08 00:00:00 | US |  | 2006-12-08 00:00:00 | Aus
 | 8/13/2006 | US |  | 8/13/2006 | US
 | 8/13/2006 | US |  | 8/13/2006 | US
 | 8/13/2006 | US |  | 8/13/2006 | US
 | 8/13/2006 | US |  | 8/13/2006 | US
 | 8/14/2006 | US |  | 8/14/2006 | US
 | 8/14/2006 | US |  | 8/14/2006 | US
 | 8/14/2006 | US |  | 8/14/2006 | US
 | 8/14/2006 | US |  | 8/14/2006 | US
 | 8/31/2006 | US |  | 8/31/2006 | US
 | 8/31/2006 | US |  | 8/31/2006 | US
 | 8/31/2006 | US |  | 8/31/2006 | US
 | 8/31/2006 | US |  | 8/31/2006 | US
 | 8/31/2006 | US |  | 8/31/2006 | US
 | 8/31/2006 | US |  | 8/31/2006 | US
 | 2006-01-09 00:00:00 | US |  | 2006-01-09 00:00:00 | Aus
 | 2006-01-09 00:00:00 | US |  | 2006-01-09 00:00:00 | Aus
 | 2006-01-09 00:00:00 | US |  | 2006-01-09 00:00:00 | Aus
 | 2006-01-09 00:00:00 | US |  | 2006-01-09 00:00:00 | Aus
 | 2006-02-09 00:00:00 | US |  | 2006-02-09 00:00:00 | Aus
 | 2006-02-09 00:00:00 | US |  | 2006-02-09 00:00:00 | Aus
 | 2006-02-09 00:00:00 | US |  | 2006-02-09 00:00:00 | Aus
 | 2006-02-09 00:00:00 | US |  | 2006-02-09 00:00:00 | Aus
 | 2006-03-09 00:00:00 | US |  | 2006-03-09 00:00:00 | Aus
 | 2006-03-09 00:00:00 | US |  | 2006-03-09 00:00:00 | Aus
 | 2006-03-09 00:00:00 | US |  | 2006-03-09 00:00:00 | Aus
 | 2006-03-09 00:00:00 | US |  | 2006-03-09 00:00:00 | Aus
 | 9/18/2006 | US |  | 9/18/2006 | US
 | 9/18/2006 | US |  | 9/18/2006 | US
 | 9/18/2006 | US |  | 9/18/2006 | US
 | 9/18/2006 | US |  | 9/18/2006 | US
 | 9/18/2006 | US |  | 9/18/2006 | US
 | 9/19/2006 | US |  | 9/19/2006 | US
 | 9/19/2006 | US |  | 9/19/2006 | US
 | 9/19/2006 | US |  | 9/19/2006 | US
Spreadsheet: 132954d1324055624-excel-2007-using-index-and-match-or-other-to-return-cell-based-on-largest-associated-value-daddy_scoresv2
Sheet: Output

ActorCode | PMonth |  |  |  |  |  |  |  | ActorNum
Actor3 | 27 |  |  |  |  |  |  |  | 11
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
CODE | CODE
Procedure | AvgScore | Count
Outcome4 | 10
Outcome404 | 10
Outcome117 | 8
Outcome369 | 8
Outcome405 | 8
Spreadsheet: 851882d1702007532-inserting-an-image-in-a-small-single-cell-that-expands-when-clicked-on-invoice-file
Sheet: Expenses

Expenses |  |  |  | Hoover over cells with comment (red corner) to see invoice. |  |  |  |  |  | Select cell and add Comment
 |  |  |  |  |  |  |  |  |  | Open comment and resize, remove name/text
Date | Item | Amount | Comments | Invoice |  |  |  |  |  | Click border of comment box
2023-11-23 00:00:00 | Petrol | 34.21 |  | Shell |  |  |  |  |  | Right-click and select; Format Comments
2023-11-25 00:00:00 | Lunch | 23.99 | Meeting with [NAME]. |  |  |  |  |  |  | Select Color and Lines tab
2023-11-25 00:00:00 | Stationary | 5.68 | Notebook | Paper & Co |  |  |  |  |  | Click drop-down options under [NAME] (down arrow)
2023-11-28 00:00:00 | Petrol | 41.5 |  | Exxon |  |  |  |  |  | Select 'Fill Options' at bottom of options
 |  |  |  |  |  |  |  |  |  | Then under 'Fill Effects' go to 'Picture'
 |  |  |  |  |  |  |  |  |  | Click 'Select Picture' and navigate to your invoice jpg file
 |  |  |  |  |  |  |  |  |  | Click 'Lock picture aspect ration, click OK
 |  |  |  |  |  |  |  |  |  | Re-size comment to fit your invoice
 |  |  |  |  |  |  |  |  |  | The invoice is now stored in the excel file as a comment.
 |  |  |  |  |  |  |  |  |  | Hoover over the cell to see the invoice.
Spreadsheet: 157544d1337786358-issue-with-formulating-percentages-to-use-in-pie-chart-test-sheet-copy
Sheet: Data Check

WorkFlow Data
# of tickets | Cost of Tickets | PM Fee | SPO |  |  |  | Category | Totals | Data
18 | 5705.5 |  |  |  |  |  | Total:
9 | 6550.75 |  |  |  |  |  | PM Fees: |  | AS OF 4-20-12
14 | 8247 | 5000 |  |  |  |  | Total Expenses:
15 | 9251.9 |  |  |  |  |  | WorkFlow Amount Approved:
18 | 11463 | 5000 |  |  |  |  | Over or Under:
8 |  | 5000
15 | 3865
14 | 6167 | 5000
16 | 4365
12 | 12889 | 5000
Total:
Spreadsheet: 790771d1659984540-totalling-columns-dependent-upon-text-day-team-flexi-sheet
Sheet: March 2023

'[NAME] |  |  |  |  |  |  |  |  | Name
FLEXIBLE WORKING HOURS RECORD |  |  |  |  |  |  |  |  | Month | March | 2023
 |  |  |  |  |  | Hours brought forward
 | MORNING |  | AFTERNOON |  | Credit | Debit | Excess | Excess |  | Totals
 | Start | Finish | Start | Finish | Hours | Hours | or [NAME] | > 10 hrs | Comments | Daily | Toil
2023-03-01 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-02 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-03 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-06 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-07 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-08 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-09 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-10 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-13 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-14 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-15 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-16 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-17 00:00:00 |  |  |  |  | 07:00:00 | 0:00:00 |  |  | Public Holiday
2023-03-20 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-21 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-22 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-23 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-24 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-27 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-28 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-29 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-30 00:00:00 |  |  |  |  |  | 0:00:00
2023-03-31 00:00:00 |  |  |  |  |  | 0:00:00
Signed |  |  |  |  |  | Date |  |  | Net Hours Worked this period
Approved |  |  |  |  |  | Date |  |  | Flexitime credit/debit carried forward
 |  |  |  |  |  |  |  |  | Toil this month
 |  | Annual Leave remaining from previous month |  |  |  |  |  |  | Toil from previous month
 |  | Annual Leave taken this month |  |  |  |  |  |  | Toil taken |  | 00:00:00
 |  | Total Annual Leave remaining |  |  |  |  |  |  | Total toil
Spreadsheet: 64638d1265421045-populating-multiple-cells-by-entering-in-criteria-graphtest-1-
Sheet: Sheet1

Activity Analysis
Location B
 |  |  | Day of Week |  |  |  |  | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00
 |  |  | Sunday
 |  |  | Monday
 |  |  | Tuesday
 |  |  | Wednesday
 |  |  | Thursday
 |  |  | Friday
 |  |  | Saturday
 |  |  |  |  |  |  |  | Specific Activity |  |  | Risk Ranking |  | Red, [NAME] or Green |  | Red, [NAME] or Green |  | Red, [NAME] or Green |  | Red, [NAME] or Green |  | Red, [NAME] or Green
 |  |  |  |  |  |  |  |  |  |  |  |  | Criteria 1 |  | [NAME] |  | Criteria 3 |  | [NAME] |  | Criteria 5
 |  |  |  |  |  |  |  |  |  |  | Specific Activity: |  | Incident 1, Incident 2, Incident 3
Spreadsheet: d233960d-8d81-4df9-91ec-88fbc2efec6d
Sheet: non-GAAP Net Inc & Op Inc

The NASDAQ OMX Group, Inc.
Reconciliation of GAAP Net Income, Diluted Earnings Per Share, Operating Income and Operating Expenses
to Non-GAAP Net Income, Diluted Earnings Per Share, Operating Income and Operating Expenses
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | March 31, |  | December 31, |  | March 31,
 |  | 2012 |  | 2011 |  | 2011
GAAP net income attributable to NASDAQ OMX: |  |  | 43
Non-GAAP adjustments:
Merger and strategic initiatives |  | 2 |  | 1 |  | 5
Extinguishment of debt |  | 0 |  | 25 |  | 0
Asset impairment charges |  | 12 |  | 18 |  | 0
Restructuring and other charges |  | 9 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 4
Total non-GAAP adjustments
Adjustment to the income tax provision to reflect non-GAAP adjustments(1) |  | -3 |  | -13 |  | -3
Significant tax adjustments, net |  | 3 |  | 0 |  | 0
Total non-GAAP adjustments, net of tax
Non-GAAP net income attributable to NASDAQ OMX:
GAAP diluted earnings per common share:
Total adjustments from non-GAAP net income above |  | 0.13 |  | 0.18 |  | 0.04
Non-GAAP diluted earnings per common share:
 |  | Three Months Ended
 |  | March 31, |  | December 31, |  | March 31,
 |  | 2012 |  | 2011 |  | 2011
GAAP operating income:
Non-GAAP adjustments:
Merger and strategic initiatives |  | 2 |  | 1 |  | 5
Extinguishment of debt |  | 0 |  | 25 |  | 0
Restructuring and other charges |  | 9 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 4
Total non-GAAP adjustments
Non-GAAP operating income:
Total revenues less transaction rebates, brokerage,
clearance and exchange fees
Non-GAAP operating margin (2)
(1) We determine the tax effect of each item based on the tax rules in the respective jurisdiction where the transaction
occurred.
(2) Non-GAAP operating margin equals non-GAAP operating income divided by total revenues less transaction rebates,
brokerage, clearance and exchange fees.
Spreadsheet: 158395d1338217559-summation-of-values-based-on-2-criteria-excel-problem
Sheet: Summary Sheet

 |  |  |  |  |  |  |  | D | W
 | A | 0 |  |  |  |  |  | 1 |  |  | x | 1 | 2 | 3 | 4 |  | 5
 | A | 50 |  |  |  |  |  | 4 |  |  | x | 6 | 7 | 8 | 9 |  | 10
 | A | 100 |  |  |  |  |  |  |  |  | x | 1 | 2 | 3 | 4 |  | 5
 | A | A |  |  |  |  |  |  |  |  | x | 6 | 7 | 8 | 9 |  | 6
 | B | 0 | B0 |  |  |  |  |  |  |  | x | 1 | 2 | 3 | 4 |  | 5
 | B | 50 |  |  |  |  |  |  |  |  | x | 6 | 7 | 8 | 9 |  | 6
 | B | 100 |  |  |  |  |  |  |  |  | x | 1 | 2 | 3 | 4 |  | 8
 | B | A |  |  |  |  |  |  |  |  | x | 6 | 7 | 8 | 9 |  | 7
 | C | 0 |  |  |  |  |  |  |  |  | x | 1 | 2 | 3 | 4 |  | 6
 | C | 50 |  |  |  |  |  |  |  |  | x | 6 | 7 | 8 | 9 |  | 8
 | C | 100 |  |  |  |  |  |  |  |  | x | 1 | 2 | 3 | 4 |  | 7
 | C | A |  |  |  |  |  |  |  |  | x | 6 | 7 | 8 | 9 |  | 8
 |  |  |  |  |  |  |  |  |  |  | x | 1 | 2 | 3 | 4 |  | 8
 | D | 0 |  |  |  |  |  |  |  |  | x | 1 | 8 | 1 | 5 |  | 5
 | D | 50 |  |  |  |  |  |  |  |  | x | 2 | 7 | 2 | 6 |  | 6
 | D | 100 |  |  |  |  |  |  |  |  | x | 3 | 6 | 3 | 7 |  | 4
 | D | A |  |  |  |  |  |  |  |  | x | 4 | 5 | 4 | 5 |  | 7
 | E | 0 |  |  |  |  |  |  |  |  | x | 7 | 0.000942234952595658 | 5 | 77 |  | 6
 | E | 50 |  |  |  |  |  |  |  |  | x | 4 | 0.000942234952595658 | 4 | 6 |  | 6
 | E | 100 |  |  |  |  |  |  |  |  | x | 3 | 0.000942234952595658 | 6 | 5 |  | 5
 | E | A |  |  |  |  |  |  |  |  | x | 8 | 0.000942234952595658 | 7 | 2 |  | 4
 |  |  |  |  |  |  |  |  |  |  | x | 54 | 5 | 6 | 6 |  | 5
 |  |  |  |  |  |  |  |  |  |  | x | 5 | 2 | 1 | 3 |  | 3
 | F | A |  |  |  |  |  |  |  |  | x | 2 | 4 | 4 | 1 |  | 3
 | G | A |  |  |  |  |  |  |  |  | x | 3 | 5 | 3 | 5 |  | 3
 | H | A |  |  |  |  |  |  |  |  | x | 0 | 6 | 5 | 6 |  | 3
 | I | A |  |  |  |  |  |  |  |  | x | 9 | 4 | 2 | 7 |  | 0.04126
 | J | A |  |  |  |  |  |  |  |  | x | 8 | 3 | 8 | 54 |  | 3
 | K | A |  |  |  |  |  |  |  |  | x | 7 | 6 | 7 | 4 |  | 23
 | L | A |  |  |  |  |  |  |  |  | x | 6 | 7 | 4 | 6 |  | 2
 | M | A |  |  |  |  |  |  |  |  | x | 5 | 4 | 2 | 7 |  | 2
 | N | A |  |  |  |  |  |  |  |  | x | 4 | 2 | 4 | 5 |  | 2
 | O | A |  |  |  |  |  |  |  |  | x | 3 | 5 | 6 | 6 |  | 2
 | P | A |  |  |  |  |  |  |  |  | x | 2 | 6 | 7 | 1 |  | 1
 |  |  |  |  |  | d | A | 1 | 100
 |  |  |  |  |  | w | A | 20 | 100
 |  |  |  |  |  | w | A | 100 | a
 |  |  |  |  |  | w | B | 3 | 50
 |  |  |  |  |  | d | D | 7 | A
Spreadsheet: 211445d1359747451-leaving-a-cell-blank-unless-referenced-cells-contain-a-value-time-card-ref
Sheet: Sheet1

 | Day | Date | Start | End | Lunch | Vacation | Personal | Total
 | Sunday
 | Monday |  | 8 | 12 | 0 | 0 | 0 |  | THIS SHOULD BE 4 HOURS, NOT 16.
 | Tuesday |  | 8 | 4.5 | 0.5 | 0 | 0
 | Wednesday |  | 8 | 4.5 | 0.5 | 0 | 0
 | Thursday |  | 8 | 4.5 | 0.5 | 0 | 0
 | Friday |  | 8 | 4.5 | 0.5 | 0 | 0
 | Saturday
 | Total hours |  |  |  |  |  |  |  | THIS SHOULD TOTAL 36, NOT 56 HOURS
Spreadsheet: 775630d1649236173-i-need-a-countifs-formula-to-count-based-on-multiple-values-daf-not-countifs-aligw
Sheet: Countifs Example

[NAME] | Name |  | Name | Email address appears 3+ times | AliGW
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | Tia Davies | 1 | Tia Davies | 3
[EMAIL] | Tia Davies | 2 | [NAME] | 2
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME] |  | I would like to count how many times a name has an email address that appears 3 or more times in the 1st 2 columns. The result would look like the column above.
[EMAIL] | Tia Davies | 3
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | Tia Davies | 4
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
Spreadsheet: 100982d1299173380-if-and-vlook-up-formula-example
Sheet: Pricing

 |  |  |  |  | P.O. # | 4500
 |  |  |  |  | Date: | 2011-03-03 00:00:00
Label Pricing
Single Item Pricing
Product # | Quantity | Price/M | Print Type | Size | Die | Material | Colors
JL51245 | 200000 | 6 | Flexo | .5625 x 1.5 | 1365-L-2 | 74554 | Digital
Spreadsheet: 489063d1479051445-help-with-combining-index-match-and-vlookup-copy-of-h
Sheet: Sheet1

Transaction # | Date | Particulars | Amount |  |  |  |  | Need to find value based on name transaction number and date
12 | 2016-01-20 00:00:00 | Rohan | 58280 |  |  |  |  | Rohan | Rikki | Ramu | Raghav | Rexton | Ashok
13 | 2016-01-20 00:00:00 | Rikki | 277416.75 |  |  | 12 | 2016-01-20 00:00:00
15 | 2016-01-25 00:00:00 | Rikki | 427266.75 |  |  | 13 | 2016-01-20 00:00:00
4 | 2016-01-05 00:00:00 | Ramu | 179490 |  |  | 15 | 2016-01-25 00:00:00
5 | 2016-01-06 00:00:00 | Raghav | 143250 |  |  | 4 | 2016-01-05 00:00:00
6 | 2016-01-06 00:00:00 | Rexton | 97500 |  |  | 5 | 2016-01-06 00:00:00
7 | 2016-01-10 00:00:00 | Ashok | 398925 |  |  | 6 | 2016-01-06 00:00:00
8 | 2016-01-15 00:00:00 | Ramu | 198400 |  |  | 7 | 2016-01-10 00:00:00
9 | 2016-01-15 00:00:00 | Raghav | 165000 |  |  | 8 | 2016-01-15 00:00:00
10 | 2016-01-15 00:00:00 | Rexton | 98500 |  |  | 9 | 2016-01-15 00:00:00
11 | 2016-01-15 00:00:00 | Ashok | 337500 |  |  | 10 | 2016-01-15 00:00:00
14 | 2016-01-25 00:00:00 | Ramu | 316200 |  |  | 11 | 2016-01-15 00:00:00
 |  |  |  |  |  | 14 | 2016-01-25 00:00:00
 |  |  |  |  |  |  |  | Need to find value based on name transaction number and date
 |  |  |  |  |  |  |  | Rohan | Rikki | Ramu | Raghav | Rexton | Ashok
 |  |  |  |  |  | 12 | 2016-01-20 00:00:00
 |  |  |  |  |  | 13 | 2016-01-20 00:00:00
 |  |  |  |  |  | 15 | 2016-01-25 00:00:00
 |  |  |  |  |  | 4 | 2016-01-05 00:00:00
 |  |  |  |  |  | 5 | 2016-01-06 00:00:00
 |  |  |  |  |  | 6 | 2016-01-06 00:00:00
 |  |  |  |  |  | 7 | 2016-01-10 00:00:00
 |  |  |  |  |  | 8 | 2016-01-15 00:00:00
 |  |  |  |  |  | 9 | 2016-01-15 00:00:00
 |  |  |  |  |  | 10 | 2016-01-15 00:00:00
 |  |  |  |  |  | 11 | 2016-01-15 00:00:00
 |  |  |  |  |  | 14 | 2016-01-25 00:00:00
 |  |  |  |  |  | Sum of Amount |  | Column Labels
 |  |  |  |  |  | Row Labels | Date | Ashok | Raghav | Ramu | Rexton | Rikki | Rohan | Grand Total
 |  |  |  |  |  | 4 | 2016-01-05 00:00:00 |  |  | 179490 |  |  |  | 179490
 |  |  |  |  |  | 5 | 2016-01-06 00:00:00 |  | 143250 |  |  |  |  | 143250
 |  |  |  |  |  | 6 | 2016-01-06 00:00:00 |  |  |  | 97500 |  |  | 97500
 |  |  |  |  |  | 7 | 2016-01-10 00:00:00 | 398925 |  |  |  |  |  | 398925
 |  |  |  |  |  | 8 | 2016-01-15 00:00:00 |  |  | 198400 |  |  |  | 198400
 |  |  |  |  |  | 9 | 2016-01-15 00:00:00 |  | 165000 |  |  |  |  | 165000
 |  |  |  |  |  | 10 | 2016-01-15 00:00:00 |  |  |  | 98500 |  |  | 98500
 |  |  |  |  |  | 11 | 2016-01-15 00:00:00 | 337500 |  |  |  |  |  | 337500
 |  |  |  |  |  | 12 | 2016-01-20 00:00:00 |  |  |  |  |  | 58280 | 58280
 |  |  |  |  |  | 13 | 2016-01-20 00:00:00 |  |  |  |  | 277416.75 |  | 277416.75
 |  |  |  |  |  | 14 | 2016-01-25 00:00:00 |  |  | 316200 |  |  |  | 316200
 |  |  |  |  |  | 15 | 2016-01-25 00:00:00 |  |  |  |  | 427266.75 |  | 427266.75
 |  |  |  |  |  | Grand Total |  | 736425 | 308250 | 694090 | 196000 | 704683.5 | 58280 | 2697728.5
Spreadsheet: 118943d1314107769-conditional-statement-krish
Sheet: Sheet2

 | 1ST LINKAGE
 |  | SHG SCORE
 | SHPI SCORE | 75 | 90 | 95
 | 70 | 4000 | 4500 | 5000
 | 81 | 4500 | 5000 | 5500
 | 91 | 4500 | 5500 | 6000
 | 2ND LINKAGE
2 TIMES THE 1ST WITH PRIVATE OR 3 TIMES THE FIRST LNKAGE PSU LIMIT OR 125000 | 70 | 30000 | 150000 | 180000
 | 81 | 150000 | 180000 | 225000
 | 91 | 180000 | 225000 | 250000
 | 3RD LINKAGE
 | 70 | 30000 | 225000 | 250000
 | 81 | 225000 | 250000 | 275000
 | 91 | 250000 | 300000 | 350000
FRESH | [NAME]
Credit Linked 1 | link2
CREDIT LINKED 2 and more | link3
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 10d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 26252958 | 0 | 2309107
Cross-Currency Fixed-Fixed | 0 | 474828 | 0 | 369083
Cross-Currency Fixed-Float | 0 | 1969266 | 0 | 694961
TOTAL | 0 | 28697052 | 0 | 3373151