tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 056794ea-d070-49f0-8a3a-09e7b3c098a7
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
 | 6345.0 Labour Price Index, Australia
 | Total Hourly Rates of Pay Excluding Bonuses: All Sectors by State, Original (Quarterly 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
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ; |  |  | Original | A2599619A | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  Private and Public ;  All industries ; |  |  | Original | A2608929K | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  Private and Public ;  All industries ; |  |  | Original | A2600949X | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  Private and Public ;  All industries ; |  |  | Original | A2610259A | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  Private and Public ;  All industries ; |  |  | Original | A2607599L | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  Private and Public ;  All industries ; |  |  | Original | A2602279K | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  Private and Public ;  All industries ; |  |  | Original | A2606269C | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private and Public ;  All industries ; |  |  | Original | [NAME]T | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2603609J | 1997-09-01 00:00:00 | 2010-03-01 00:00:00 | 51 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 850935d1701245375-data-printing-by-following-specific-formula-in-specific-cell-0_excel_test-excel-2019-onwards-aligw
Sheet: Sheet1

% Release of Dissolution |  |  |  |  |  |  |  |  |  | Limit
Vessel No. |  | Sample Absorbance |  |  | Average Standard Absorbance |  | Calculation Factor |  | Result (%) |  |  | HELPER |  | RESULT
1 |  | 0.578
2 |  | 0.578
3 |  | 0.3
4 |  | 0.575
5 |  | 0.578 |  |  |  |  |  |  |  | Not less
6 |  | 0.577 |  |  |  |  |  |  |  | than
7 |  | 0.578 |  |  |  |  |  |  |  | 75
8 |  | 0.2 |  |  |  |  |  |  |  | %
9 |  | 0.576 |  |  |  |  |  |  |  | to
10 |  | 0.578 |  |  |  |  |  |  |  | Not more
11 |  | 0.579 |  |  |  |  |  |  |  | than
12 |  | 0.45 |  |  |  |  |  |  |  | 115
Average |  |  |  |  |  |  |  |  |  | %
Minimum
 |  |  |  |  |  |  |  |  |  | Number of units which is Q-15% :
Maximum
SD
%RSD
Spreadsheet: 751613d1634208409-forecast-formula-test-file1
Sheet: Sheet2

Trainees | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Trainee 1 | 7 | 10 | -1 | 3 | 4 | 25 | ? | ? | ? | ? | ? | ?
Trainee 2
Trainee 3
Trainee 4
Spreadsheet: 161856d1339661168-excel-2007-formula-counting-double-data-entries-as-one-count
Sheet: Countif

 |  |  |  | Data | Counting |  | Expected Result
 |  |  |  | 1 |  |  | 1
 |  |  |  | 1 |  |  | 1
 |  |  |  | 2 |  |  | 2
 |  |  |  | 2 |  |  | 2
 |  |  |  | 3 |  |  | 3
 |  |  |  | 4 |  |  | 4
 |  |  |  | 5 |  |  | 5
 |  |  |  | 5 |  |  | 5
 |  |  |  | 6 |  |  | 6
 |  |  |  | 7 |  |  | 7
 |  |  |  | 8 |  |  | 8
 |  |  |  | 9 |  |  | 9
 |  |  |  | 10 |  |  | 10
 |  |  |  | 11 |  |  | 11
 |  |  |  | 11 |  |  | 11
 |  |  |  | 12 |  |  | 12
 |  |  |  | 12 |  |  | 12
 |  |  |  | 13 |  |  | 13
 |  |  |  | 14 |  |  | 14
 |  |  |  | 14 |  |  | 14
Spreadsheet: 810380d1671725481-extract-all-cell-data-before-the-last-number-digit-extractexample
Sheet: Sheet1

INPUT | REQUIRED OUTPUT
NM030RDL | NMO30
NM019LNL | NMO19 | NM019
NM042BLALNL | NMO42 | NM042
NM035BLAL | NMO35 | NM035
NM036BLAL | NMO36 | NM036
NM035GLDL | NMO35 | NM035
Spreadsheet: john_zufferli__16692__LavoSummary
Sheet: New Curve

Alberta Power PPA Position Deal Value
Year | AECO Curve (12/29/00) | PPA Cost | 7*24 Power Curve | 5*16 Power Curve | 7*8 Power Curve | PPA Cost HR | 7*24 HR | 5*16 HR | 7*8 HR | New Generation
2001 | 8.822466795768447 | 40.822748035272 | 145.76 | 195.95 | 85.58 |  |  |  |  | Q401 300 MW Transmission Must Run
2002 | 5.561012730862121 | 32.86092221232097 | 79.22 | 102.15 | 51.36 |  |  |  |  | 200 MW Simple Cycle
2003 | 5.16437628835978 | 31.47773337221519 | 62.1 | 77.73 | 43.76 |  |  |  |  | 200 MW Simple Cycle + 825 MW Combined Cycle
2004 | 4.857496295945285 | 31.19157975956836 | 43.17 | 49.36 | 39.34
2005 | 4.698074280787314 | 31.40291524539878 | 42.56 | 47.74 | 37.84 |  |  |  |  | 400 MW Coal
2006 | 4.634287584445855 | 30.11856989923704 | 34.76 | 35.22 | 34.42
2007 | 4.623745549340338 | 30.29923465101226 | 32.46 | 32.55 | 32.43
2008 | 4.633799305075677 | 31.27552445099281 | 32.83 | 32.84 | 32.83
2009 | 4.65785751094162 | 31.7141505396783 | 33.05 | 33.09 | 33.01
2010 | 4.717608447458311 | 32.90078197053858 | 33.7 | 33.9 | 33.51
2011 | 4.737152794529186 | 34.19387946530488 | 33.69 | 33.93 | 33.51
2012 | 4.758222906233954 | 34.60505007940065 | 33.69 | 33.93 | 33.51
2013 | 4.783401730435136 | 34.91266355632158 | 33.69 | 33.93 | 33.51
2014 | 4.795755007161651 | 35.12962928561096 | 33.69 | 33.93 | 33.51
2015 | 4.81575500716165 | 35.27216206604402 | 33.69 | 33.93 | 33.51
2016 | 4.83575500716165 | 34.94142228492394 | 33.69 | 33.93 | 33.51
2017 | 4.855755007161649 | 35.23107126125728 | 33.69 | 33.93 | 33.51
2018 | 4.875755007161649 | 35.89693042900667 | 33.69 | 33.93 | 33.51
2019 | 4.895755007161648 | 36.44232657993698 | 33.69 | 33.93 | 33.51
2020 | 4.915755007161648 | 37.95735403594387 | 33.69 | 33.93 | 33.51
NPV Deal Value over Term |  | $ 600,000,000 CDN
2001 Liquidated Value |  | $ 400,000,000 CDN
Spreadsheet: 32f70d8d-27ec-4002-931e-e65e9c0bdcfc
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
CARN | Test | CARN | Carnitine, Plasma | Carnitine, P | Flow Injection Analysis-Tandem Mass Spectrometry (FIA-MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: EDTA, lithium heparin Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK <3 days-refreeze and note to lab; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Plasma gel tube | Total Carnitine (TC)	Free Carnitine (FC)	Acylcarnitine (AC)	AC/FC Ratio Age Group	Range*	Range*	Range*	Range 1 day	23-68	12-36	7-37	0.4-1.7 2-7 days	17-41	10-21	3-24	0.2-1.4 8-31 days	19-59	12-46	4-15	0.1-0.7 32 days-12 months	38-68	27-49	7-19	0.2-0.5 13 months-6 years	35-84	24-63	4-28	0.1-0.8 7-10 years	28-83	22-66	3-32	0.1-0.9 11-17 years	34-77	22-65	4-29	0.1-0.9 > or =18 years	34-78	25-54	5-30	0.1-0.8 *Values expressed as nmol/mL Schmidt-Sommerfeld E, [NAME] E, [NAME] D: Carnitine plasma concentrations in 353 metabolically healthy children. Eur J Pediatr 1988;147:356-360 Used with permission of European Journal of Pediatrics, Springer-Verlag, New York, Inc., Secaucus, NJ | Monday through Friday; 8 a.m. | 2 days (not reported on Saturday or Sunday) | 5 days | 1 | 82379 |  |  |  |  | Rochester
CARN | [NAME] | PLASMA | Plasma |  |  |  | Frozen | 60 days
CARN | Result | 32050 | Total | Total | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 14288-5 | Carnitine (C0):SCnc:Pt:Ser/Plas:Qn:
CARN | Result | 32051 | Free (FC) | Free (FC) | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 14286-9 | Carnitine.free (C0):SCnc:Pt:Ser/Plas:Qn:
CARN | Result | 32052 | Acylcarnitine (AC) | Acylcarnitine (AC) | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 14282-8 | Acylcarnitine:SCnc:Pt:Ser/Plas:Qn:
CARN | Result | 21032 | AC/FC Ratio | AC/FC Ratio | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30193-7 | Acylcarnitine/Carnitine.free ([NAME]:Pt:Ser/Plas:Qn:
CARN | Result | 21549 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 685731d1594159619-return-row-number-findmatchsample-1-
Sheet: 777

1 | 4 | 13 | 14 | 26 |  | 7 |  | 4 | 13 | 22 | 31 | 29 | 33 | 36
2 |  |  |  |  |  |  |  | 15 | 17 | 19 | 21 | 24 | 32 | 36
3 |  |  |  |  |  |  |  | 13 | 18 | 24 | 27 | 33 | 36 | 41
4 |  |  |  |  |  |  |  | 4 | 7 | 8 | 10 | 14 | 20 | 27
5 |  |  |  |  |  |  |  | 5 | 8 | 10 | 13 | 15 | 17 | 22
6 |  |  |  |  |  |  |  | 4 | 5 | 14 | 20 | 24 | 32 | 33
7 |  |  |  |  |  |  |  | 4 | 13 | 29 | 33 | 26 | 36 | 14
8 |  |  |  |  |  |  |  | 6 | 8 | 11 | 14 | 15 | 16 | 20
9 |  |  |  |  |  |  |  | 7 | 9 | 14 | 23 | 24 | 25 | 31
10 |  |  |  |  |  |  |  | 13 | 20 | 22 | 23 | 25 | 28 | 29
Spreadsheet: 688480d1595814170-multiple-functions-in-one-cell-markbook-practice-ii-autosaved-
Sheet: 9A

 |  |  | Learning Outcomes Summary |  |  |  | Reading & Viewing |  |  |  |  |  |  |  |  |  | Writing |  |  |  |  |  |  |  |  |  | Speaking & Listening |  |  |  |  |  |  |  |  |  | Course Work
Name | Surname | Overall | Reading & Viewing | Writing | Speaking & Listening | Course Work
[NAME] | [NAME] |  |  |  |  |  | 4 | 8 | 7 | 1 | 4 | 6 | 5.5 | 9 | 3 | 2 | n | 6 | 5 | 8 | 7 | 6.5 |  |  |  |  | 6 | 5 | 6
[NAME] | BOWEN
[NAME] | CHOU
[NAME] | CLYDE
[NAME] | EL HABTI
[NAME] | GANINO
Alicia | GEROGE - PHELAN
Ebony | GRECH
[NAME] | HAM
Muhaimin | KABIR
Yoshini | [NAME]
Imran | [NAME]
[NAME] | MAKAROW
[NAME] | MADDEN
Giselle | [NAME]
[NAME] | [NAME]
Dario | MUNOZ JOFRE
Bailey | POTTS
Zakary | RANTINO
[NAME] | RIGATO
Taia | SEAR
Kaylin | STANTON
Kalam | SUPRIATNA
Halle | TOWERZY
Kelly | TOWERZY
Spreadsheet: 1cb2bf8b-59e7-4c42-aacf-01cc04d77574
Sheet: L Leadership

Leadership | is the ability to bring out the best in those around you through vision and initiative. Leadership is the cornerstone of a strong Chapter, encourages effective collaboration, and drives the Fraternity toward a common goal. ~Doctrine of Excellence
 |  | Tier 1 | Tier 2 Points | Tier 3 Points | Documentation Requirements |  |  |  |  |  | Points
Item No. | Performance Area | Foundational Elements |  |  | CA Verif. | GA/UO Verif. | IFC [NAME]. | Written Descript. | HQ [NAME]. | Other | [NAME]. | Bonus | Reporting Time(s) | Tools | Remarks
L1 | Chapter Organization | Chapter conducts weekly Chapter meetings during the academic year (based on an academic year calendar). | Chapter Executive Committee conducts weekly meetings during the academic year. | Chapter has at least 80% attendance at all meetings. |  |  |  | X |  | Tier 1: Meeting Minutes Tier 2: Exec. Comm Meeting Minutes Tier 3: Attendence Sheet showing attendance record | 1 | 1 | Fall/Spring | Officer Guide
L2 | Strategic Planning | Chapter conducts at least one (1) planning retreat each year. | Chapter conducts at least one (1) planning retreat each academic term. |  |  |  |  | X | X | Retreat materials, output materials, retreat agenda | 1 |  | Fall/Spring | Officer Guide | Develop and update a strategic plan including SWOT analysis, mission statement and SMART goals.
L3 | Continuity | Officers maintain officer notebooks addressing roles/responsibilities, action plans and notes on lessons learned. | Chapter conducts an Officer Training and Transition Retreat after officer elections. | Chapter uses committee structure for recruitment, finance and philanthropy/community service as a minimum. Committee participation is mandatory under bylaws for 1st year after initiation. |  |  |  | X | X | Officer transition forms, meeting notes;bylaws | 1 | 1 | Fall/Spring | Sample retreat agendas/transition forms
[NAME] | Advising Structure | Chapter has a Chapter Advisor approved by HQ. [NAME] communicates with the Chapter Advisor at least once per month. | Chapter has an active Faculty Advisor appointed by the college/university. Either the Chapter Advisor or [NAME] attends at least one (1) meeting per month. | Chapter has an Advisory board with at least 3 alumni/faculty/university staff members (members must be approved by the Exec. Committee of International Fraternity) | X | X |  | X |  | Contact information, letter from Faculty Advisor | 1 | 1 | Spring
L5 | Written Plans | Chapter has current chapter-approved bylaws which have been distributed to the entire membership within the past year. | Officers prepare written goals based on Doctrine Of Excellence. | Chapter prepares and submits a written strategic plan addressing (minimum) recruitment, financial management, philanthropy/community service and membership development. Plan shall be prepared using template available from HQ. |  |  |  | X | X | Copies of bylaws/goals/plans | 1 | 1 | Fall | Officer Guide
Notes:
1. | All Foundational Elements in all Categories must be met to be eligible for points (in all Categories.)
Spreadsheet: 64783d1265630755-lookup-tracker
Sheet: Main Page

 | Recall 6 / Recall January
 | Product | Total In | Outstanding | A Grades | 2nd's | FLT's | Missing | Sold | Total Left |  |  | Pallet Check
 | Nokia N97 Black
 | Nokia E71 Grey Steel
 | LG CHOC BL40 Black
 | Samsung Omnia Black
 | BlackBerry 8900 Black
 | BlackBerry 9000 Black
 | Sony Ericsson W595 [NAME]
 | HTC Hero [NAME]
Spreadsheet: 690574d1597169781-using-isna-function-in-conditional-formatting-to-find-n-a-values-not-working-isna_not_working_conditional
Sheet: Sheet1

Hdr3 | Hdr1 | Hdr2
2
3
4
5
6
7
8
9
10
11
12
13
Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Expense Detail (3)

 | 2001 Budget Template - $US
 | Government Affairs - [NAME]
 |  |  |  |  | 2000 |  | 2001 |  | 2002
 | Average Headcount ( 2001 = Year End) |  |  |  |  |  |  |  |  | Comments
 |  |  |  |  |  |  | Aug Ytd Annualised
 | Statutory Reporting
 | Enron Assurance Services
 | Regulatory |  |  |  |  |  |  |  |  | See Consultancy /Legal & Subscriptions summary (page 4)
 | Company Secretariate
 | Compliance
 | Total Audit & Legal |  |  |  |  |  | 383565
 | Occupancy
 | Lease Rent Expense |  |  |  |  |  |  |  |  | Brussels office rental ( $8,000 per month including services)
 | Sub Let Income
 | Rates / Local Tax
 | Utilities
 | Service Charge
 | Other
 | Total Occupancy |  |  |  |  |  | 162519
 | General & Admin
 | Annual Subscriptions |  |  |  |  |  |  |  |  | See Consultancy /Legal & Subscriptions summary (page 4)
 | Publications
 | Training |  |  |  |  |  |  |  |  | Reduction on 2001 spend (less people who will not require any of standard starters training courses)
 | Insurance
 | Recruitment Advertising
 | Other Advertising
 | Other Business Expenses |  |  |  |  |  |  |  | 0
 | Total G&A |  |  |  | 0 |  | 195750
 | Communications
 | Communications Costs |  |  |  |  |  |  |  |  | Average of $2,000 per person for mobile and land lines
 | Total Communication |  |  |  |  |  | 40275
 | Other Taxes & Income
 | Total G&A Excluding Salary Costs
 | Total Costs
Spreadsheet: 189252d1351132423-nested-match-function-within-the-index-function-e08m2june_calovidoveann
Sheet: Lawton

Lawton - June Temperatures
In °F
[NAME]
Date | High | Low
 | 88 | 69
 | 82 | 64
 | 71 | 62
 | 79 | 55
 | 84 | 59
 | 93 | 65
 | 92 | 74
 | 90 | 68
 | 93 | 70
 | 79 | 63
 | 84 | 63
 | 91 | 70
 | 90 | 71
 | 90 | 69
 | 93 | 68
 | 93 | 74
 | 93 | 73
 | 94 | 73
 | 90 | 74
 | 91 | 72
 | 95 | 76
 | 98 | 73
 | 98 | 70
 | 98 | 74
 | 99 | 72
 | 99 | 69
 | 102 | 74
 | 90 | 73
 | 87 | 71
 | 96 | 68
Monthly Records
High/Low
Date
Spreadsheet: d9707596-a159-4768-8f1f-501ba9e7d6fb
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35915482 | 2013-05-12 23:28:51 | AXIS | 1 | 6 | 2 | 849210 | Missinluck | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
35915797 | 2013-05-12 23:38:38 | ALLIES | 1 | 6 | 0 | 849210 | Missinluck | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
35915991 | 2013-05-12 23:52:59 | ALLIES | 0 | 2 | 6 | 1306850 | djohnson1984 | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
35916156 | 2013-05-13 00:05:56 | AXIS | 1 | 6 | 0 | 1306850 | djohnson1984 | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
35944589 | 2013-05-14 22:39:28 | ALLIES | 1 | 5 | 4 | 757054 | Bulldoz44 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
35944879 | 2013-05-14 22:57:17 | AXIS | 1 | 5 | 2 | 757054 | Bulldoz44 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
36002086 | 2013-05-18 22:57:35 | AXIS | 0 | 4 | 6 | 1329716 | Espartano | 12508 | pacific | 1942-08-20 | 1942-08-21 | Tenaru | Tenaru
36002524 | 2013-05-18 23:15:51 | ALLIES | 0 | 1 | 5 | 717031 | Zivago | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
36002682 | 2013-05-18 23:34:25 | AXIS | 0 | 4 | 5 | 717031 | Zivago | 7366 | mediterranean | 1942-05-27 | 1942-05-27 | Panzers [NAME] | Panzer contre [NAME]
36035500 | 2013-05-21 00:08:47 | AXIS | 1 | 5 | 3 | 1328232 | Appyo | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
36060362 | 2013-05-22 19:06:43 | AXIS | 1 | 6 | 4 | 574643 | ExpressTicket | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
36063925 | 2013-05-22 22:55:17 | AXIS | 1 | 6 | 5 | 776309 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
36064286 | 2013-05-22 23:13:20 | ALLIES | 1 | 6 | 4 | 776309 | [NAME] | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
36064588 | 2013-05-22 23:33:40 | AXIS | 1 | 7 | 3 | 776309 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
36064861 | 2013-05-22 23:53:27 | ALLIES | 1 | 7 | 4 | 776309 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
Spreadsheet: 27721e80-02bd-4faf-9916-87943832d36f
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688421021 | Imperials | Best Of Imperials | 1981-09-01 | Compact Disc | Ac | 9.99 | Y | Available
Word Distribution Rec | 80688445522 | Imperials | Imperials Legacy-Boxed St | 1996-04-23 | Compact Disc | Ac | 19.99 | Y | While Supplies Last
Daywind Rec | 614187141922 | Stamps Quartet & Imperials | Gospel Side Of Elvis, The | 2004-10-26 | Compact Disc | [NAME] | 16.99 | N | To Be Retired
Special Markets Product Rec | 80688889029 | Imperials | Ultimate Collection, The | 2014-06-03 | Compact Disc | Ac | 9.99 | Y | NYP
Spreadsheet: 672703d1586966196-how-to-cobmine-if-function-with-rank-eq-example-ranking-with-if-statement
Sheet: Sheet1

Client | Location | Priority | Meeting time 1 | Meeting time 2 | Meeting time 3 | Meeting time 4 | Average time spent with client | Overall Rank | Rank if High priorty | Rank if Medium priorty | Rank if Low priorty |  |  | Overall rank position
[NAME] | London | High | 40 | 20 | 50 | 12 |  |  | 2 |  |  |  |  | Average time | Member | Location
[NAME] | London | Medium | 40 | 10 |  |  |  |  |  | 1 |  |  | 1
[NAME] | London | Low | 56 | 50 |  |  |  |  |  |  | 4 |  | 2
[NAME] | Bristol | Low | 69 | 60 |  |  |  |  |  |  | 5 |  | 3
[NAME] | Swansea | Low | 70 | 80 | 60 | 60 |  |  |  |  | 6 |  | 4
[NAME] | York | medium | 23 | 90 |  |  |  |  |  | 6 |  |  | 5
Eve | Bristol | High | 10 | 40 |  |  |  |  | 1 |  |  |  | 6
Sandra | [NAME] | High | 25 | 50 | 40 | 40 |  |  | 4 |  |  |  | 7
[NAME] | [NAME] | High | 10 | 60 |  |  |  |  | 3 |  |  |  | 8
[NAME] | Leeds | Medium | 80 | 30 |  |  |  |  |  | 5 |  |  | 9
Emma | [NAME] | Medium | 90 | 12 |  |  |  |  |  | 4 |  |  | 10
[NAME] | Leeds | Low | 30 | 24 | 21 | 70 |  |  |  |  | 1
[NAME] | [NAME] | Low | 100 | 26 |  |  |  |  |  |  | 5 |  |  | High rank position
[NAME] | Bath | Low | 25 | 80 |  |  |  |  |  |  | 3 |  |  | Average time | Member | Location
[NAME] | Oxford | High | 40 | 90 | 22 | 80 |  |  | 6 |  |  |  | 1 | 25 | Eve | Bristol
Adam | London | High | 30 | 60 |  |  |  |  | 5 |  |  |  | 2 | 30.5 | [NAME] | London
[NAME] | London | Medium | 15 | 30 | 23 | 90 |  |  |  | 2 |  |  | 3 | 35 | [NAME] | [NAME]
Harriet | Leeds | Medium | 20 | 70 |  |  |  |  |  | 3 |  |  | 4 | 38.75 | Sandra | [NAME]
[NAME] | Cardiff | Low | 80 | 84 |  |  |  |  |  |  | 7 |  | 5 | 45 | Adam | London
[NAME] | Newport | Low | 76 | 54 | 24 | 50 |  |  |  |  | 2 |  | 6 | 58 | [NAME] | Oxford
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium rank position
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Average time | Member | Location
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Low rank position
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Average time | Member | Location
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10