tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43275d1241870638-changing-cell-values-on-specific-dates-dates
Sheet: Sheet1

2009-05-09 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00
may stuff 1 | may stuff 1 | june stuff 1 | july stuff 1 | aug stuff 1 | sep stuff 1 | oct stuff 1
may stuff 2 | may stuff 2 | june stuff 2 | july stuff 2 | aug stuff 2 | sep stuff 2 | oct stuff 2
may stuff 3 | may stuff 3 | june stuff 3 | july stuff 3 | aug stuff 3 | sep stuff 3 | oct stuff 3
may stuff 4 | may stuff 4 | june stuff 4 | july stuff 4 | aug stuff 4 | sep stuff 4 | oct stuff 4
may stuff 5 | may stuff 5 | june stuff 5 | july stuff 5 | aug stuff 5 | sep stuff 5 | oct stuff 5
may stuff 6 | may stuff 6 | june stuff 6 | july stuff 6 | aug stuff 6 | sep stuff 6 | oct stuff 6
may stuff 7 | may stuff 7 | june stuff 7 | july stuff 7 | aug stuff 7 | sep stuff 7 | oct stuff 7
may stuff 8 | may stuff 8 | june stuff 8 | july stuff 8 | aug stuff 8 | sep stuff 8 | oct stuff 8
may stuff 9 | may stuff 9 | june stuff 9 | july stuff 9 | aug stuff 9 | sep stuff 9 | oct stuff 9
Spreadsheet: 720048d1613996395-timesheet-help-timesheets-test
Sheet: 21-12-2020

 | Weekly Timesheet
 | Pay week ending
 | 2020-12-21 00:00:00 |  |  |  |  |  | 1.5 x Hourly Rate | 2 x Hourly Rate
 | Day of Week |  | Start Time | End Time | Total Hours
 | Tuesday |  |  | RDO
 | Wednesday |  |  | Annual Leave
 | Thursday |  |  | Public Holiday
 | Friday |  | 07:00:00 | 16:30:00
 | Saturday
 | Sunday
 | Monday |  | 06:30:00 | 18:00:00
 | Total Hours for the Week
Spreadsheet: 275805d1383653054-vlookup-based-on-multiple-criteria-problem-exampledoc
Sheet: Sheet1

Example
Name | Month | Wages
[NAME] | January | 2100
 | February | 2300
 | March | 2000
 | April | 2033
 | May | 1983
 | June | 1933
 | July | 1833
 | August | 1929
 | September | 1839
 | October | 1898
 | November | 1987
 | December | 1898
[NAME] | January | 1794.57692307692
 | February | 1770.15384615385
 | March | 1745.73076923077
 | April | 1721.30769230769
 | May | 1696.88461538461
 | June | 1672.46153846154
 | July | 1648.03846153846
 | August | 1623.61538461538
 | September | 1599.19230769231
 | October | 1574.76923076923
 | November | 1550.34615384615
 | December | 1525.92307692308
[NAME] | January | 1477.07692307692
 | February | 1452.65384615385
 | March | 1428.23076923077
 | April | 1403.80769230769
 | May | 1379.38461538461
 | June | 1354.96153846154
 | July | 1330.53846153846
 | August | 1306.11538461538
 | September | 1281.69230769231
 | October | 1257.26923076923
 | November | 1232.84615384615
 | December | 1208.42307692308
Name | Month
[NAME] | February
Wages | VALUE??
Spreadsheet: richard_shapiro__32601__Accomplishment-june5th2001-Masteredit
Sheet: Canada

Accomplishment for the Period November 2000 to April 2001
No. | Accomplishments | Customer | Value | Area |  |  |  |  | Methodology
 | (description) | (B. Unit) | ($) | Deal Support | Origination | Risk Management | [NAME] | Other
Canada Region
Name: | [NAME] | Region/Country: | Canada Region |  | Primary Activity: | Electricity | Secondary Activity: | Gas
 | AEUB 2001 PPA Module - Coordinated a Coalition of 4 PPA Buyers and Balancing Pool | ENA/Enron Canada | $1.5 million Cdn | x |  |  |  |  | The present value of the actual prospective transmission charge to ECC that a favorable decision on this issue would allow ECC to avoid is estimated at $13 million Cdn over the 20 year life of the PPA, which includes approximately $1.5 million in 2001
 | Unsold PPA (Clover Bar) Dispatch convinced Alberta Energy Officials to recommend to Minister specific directions to Balancing Pool | ENA/Enron Canada | Quantifiable but dependent on actual natural gas spot price | x |  |  |  |  | The value of this to the ECC PPA is approximately $7000/each $1 the AECO C Natural Gas Price exceeds $8.50/GJ (it has a negative value if gas price is below $8.50)
 | 2001 IPPSA Conference Organizing Committee | ENA/Enron Canada | Unquantifiable |  |  |  | x
 | Appointed by Alberta Energy to 10 Member Retail Issues Subcommittee | EES/Enron Direct Canada | Unquantifiable |  |  |  | x
 | Appointed by Alberta Energy to 6 Member Industry Structure Review Consultant Selection Committee | ENA/Enron Canada | Unquantifiable |  |  |  | x
 | On key committees: Electricity Supply Task Force, Power Pool Operations Committee, IPPSA Board of Directors, etc. | ENA/Enron Canada/Enron Direct |  |  |  |  | x
Name: | [NAME] | Region/Country: |  | Canada | Primary Activity: | Electricity | Secondary Activity: | Gas
 | extensive work on regulatory and political fronts to achieve Ontario Market Opening in 2001 | ENA/Enron Canada | unquantifiable at this time | X |  | X | X
Spreadsheet: 93088d1292589641-i-broke-my-speedsheet-test-sheet
Sheet: Sheet1

Debit Date | Nippu | Description | Amount | Account Transfer | ATM | Interest | Misc. 1 | Misc. 2 | Balance
2010-05-05 00:00:00 | 1 | BALANCE |  |  |  |  |  |  | 500
2010-05-05 00:00:00 | 1 | Bus to city centre | 9.1 |  |  |  |  |  | #N/A
2010-05-05 00:00:00 | 1 | Dinner | 9.1 |  |  |  |  |  | #N/A
2010-05-06 00:00:00 | 1 | new tie | 0.8 |  |  |  |  |  | #N/A
2010-05-06 00:00:00 | 999 | GSM | 5 |  |  |  |  |  | #N/A
2010-05-06 00:00:00 |  | Coffee | 20 |  |  |  |  |  | #N/A
2010-05-08 00:00:00 |  | Flowers for Mom | 5 |  |  |  |  |  | #N/A
2010-05-08 00:00:00 |  | [NAME] | 0.8 |  |  |  |  |  | #N/A
2010-05-08 00:00:00 |  | Candy | 2.5 |  |  |  |  |  | #N/A
2010-12-17 00:00:00 | 25 | [NAME] | 10 |  |  |  |  |  | #N/A
2010-12-17 00:00:00 | 25 | [NAME] | 2 |  |  |  |  |  | #N/A
2010-12-18 00:00:00 | 25 | Bus to city centre | 2.9 |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 6b0e22eb-8973-4fe3-ba2d-41959c7bab0a
Sheet: Sheet1

Academic / Staff Personnel Action Authorization | 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 | Unnamed: 24 | Unnamed: 25
To:    Civil & Environmental Engineering Personnel Office
Please process personnel action papers as follows:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
Name: |  |  |  |  |  |  |  |  |  |  |  |  |  | UID:
Position (title): |  |  |  |  |  |  |  |  |  |  |  | STEP: |  |  |  | TITLE CODE: |  |  |  |  |  | % OF TIME
(For STUDENT employees, if  more than 50% employment is requested, a letter of justification must accompany this authorization.) Student may work  full-time during inter-quarter periods and during summer: ______  Yes   _____ No   (Inter-quarter periods are from the last day of the quarter to the first day of registration)
Beginning Date of Action Requested: |  |  |  |  |  |  |  |  |  |  |  | Rate of Pay: |  |  |  |  |  | Month/ Per hour |  |  |  |  | Annual $
Ending Date of Action Requested:
Accounts to be charged
Account Number (s) |  |  |  |  |  |  |  |  | Account Name |  |  |  |  |  |  | % of Time on Acct |  |  | Start date on acct |  |  | End date on acct |  |  | Accountant Approval
4- | - |  |  |  | - |  |  | -2
4- | - |  |  |  | - |  |  | -2
4- | - |  |  |  | - |  |  | -2
4- | - |  |  |  | - |  |  | -2
This action Represents:
 | Request for Recruitment* |  |  |  |  |  |  |  | Rehire |  |  |  |  |  |  | Units Enrolled |  |  |  |  |  |  | Other
 | New Hire |  |  |  |  |  |  |  | Decrease % of Time |  |  |  |  |  |  | GPA
 | Promotion* |  |  |  |  |  |  |  | Increase % of Time |  |  |  |  |  |  | Non Resident
 | Reclassification* |  |  |  |  |  |  |  | Extend end date |  |  |  |  |  |  | Resident
 | Change in funding |  |  |  |  |  |  |  | Termination* |  |  |  |  |  |  | On Filing Fees
 | Deletion of Account |  |  |  |  |  |  |  | Not on Above Account# |  |  |  |  |  |  | Advanced to Candidacy
*NRT will apply for appointments  45% >
If action represents request for recruitment, new hire, promotion or termination, please complete the following:
 |  | New Position |  |  |  |  |  | Career |  |  |  |  | Replacement for
Reason for termination:
Forwarding Address:
Note: 100% CASUAL employees in all titles are elibible for medical benefits paid by the contract or grant the employee is hired on unless a "By Agreement" situation is arranged.  In By-Agreement, the employee chooses not to appply for medical benefits
By Agreement reason:
P.I. Signature: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Employee signature: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Spreadsheet: 814194d1674224068-somme-si-ens-between-two-dates-based-on-year-criteria-somme-si-ens-based-on-year-criteria-salimus16-
Sheet: Revue

Service | Employés | Date de départ | Date de retour | Type de congés | durée | Total genéral | Depuis Recrutement | Reliquat | 2022 | 2023
 |  |  |  |  | 0 | 0 | 0 | 0
Ressource Humaines | [NAME] | 2023-01-11 00:00:00 | 2023-01-23 00:00:00 | CA | 12 | 33 | 162.0833333333333
Ressource Humaines | Bekka Souad | 2022-12-20 00:00:00 | 2023-01-10 00:00:00 | CA | 21 | 21 | 162.1666666666667
Ressource Humaines | [NAME] sabria | 2023-02-12 00:00:00 | 2023-03-02 00:00:00 | CA | 18 | 18 | 238.8333333333333
Ressource Humaines | [NAME] | 2022-12-20 00:00:00 | 2023-01-10 00:00:00 | CA | 21 | 33
 |  | 2022 | 2023 | 2024 | 2025
 | CA
 | CM
 | CMM
Spreadsheet: 843818d1695657731-if-formula-with-multiple-conditions-test-to-check-if-migrated
Sheet: Sheet1

Status (formula to get outcome in column H) | Subject | Has subject? | Has English bundle? | Has MFL bundle | Has maths bundle? | Has newer version? | Outcome should be | [NAME]?
 | English | True | False | False | False | True | Migrated
 | English | True | True | False | False | False | Migrated
 | French | True | False | False | False | False | Partially migrated
 | German | False | False | False | False | False | Not migrated
 | Maths | True | False | False | True | False | Migrated
 | Maths | True | True | False | False | False | Partially migrated
Spreadsheet: kam_keiser__17938__SitaraBookRequestForm
Sheet: Portfolio Req

 |  |  |  |  |  |  | EXHIBIT A
 |  | To: | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Desk Validation Contact
 |  |  | Logistics Contact
 |  |  | Risk Management Contact
 |  |  | Settlements Contact
 |  |  | [NAME] (SITARA Manager)
 |  | From: | Information Risk Management |  |  |  | Department: Information Risk Management
 |  | Subject: | New Portfolio Request
 |  |  | This is to notify you that a new [NAME] needs to be set up:
 | Portfolio | CPR | COUNTERPARTY | Associated Entity |  | GLOBAL COMMON CODES |  |  | Region | Reporting -Subledger
 | Cpid |  | COUNTERPARTY LEGAL NM | COUNTERPARTY LEGAL NM | MSA CO NO | DATA CD | DATA DESC | SHORTNAME | SECURITY Access | MTM | Prud
Spreadsheet: 864636d1711726092-if-isnumber-search-to-exclude-similar-values-areas
Sheet: Sheet1

Sub org | Vertical | Vertical 2
Private Bank | Private Bank / Funds | CB&D
Ukraine Funds | IC Branch | CB&D
Corporate Banking | Corporate Banking | Corp
Boston IC Branch | IC Branch | ICB
Chicago  IC Branch | IC Branch | ICB
New York  IC Branch | IC Branch | ICB
Seattle IC Branch | IC Branch | ICB
Markets | Markets | ICB
UK IC Branch | IC Branch | ICB
Banking | Banking | ICB
Treasury Markets | International Markets | IM
Capital Markets | International Markets | IM
Customer | Customer | KUK
Business Fund Banking | Business Fund Banking | KUK
Business Banking | Business Banking | KUK
UK | National | National
Ukraine | National | National
Private Bank & Wealth Group | Wealth | Wealth
Spreadsheet: 69322d1269870923-vlookup-with-multiple-criteria-test
Sheet: Report

DATE | ON/OFF | PBZPER
2010-03-15 00:00:00 | ON | 32993319.13
2010-03-15 00:00:00 | OFF | 395727.21
2010-03-16 00:00:00 | ON | 2593023.23
2010-03-16 00:00:00 | OFF | 938358.27
2010-03-17 00:00:00 | OFF | 41600821.92
2010-03-18 00:00:00 | OFF | 763676.41
2010-03-19 00:00:00 | OFF | 226682.38
2010-03-22 00:00:00 | OFF | 308626.23
2010-03-22 00:00:00 | ON | 1138940.47
2010-03-23 00:00:00 | OFF | 34010643.63
2010-03-24 00:00:00 | OFF | 47486611.85
2010-03-24 00:00:00 | OFF | 299808.59
2010-03-25 00:00:00 | OFF | 529088.77
Spreadsheet: 46119d1245003818-want-to-automate-the-recording-of-data-from-one-worksheet-to-another-fruitexample
Sheet: Oranges

Date | Fruit | Units | Cost
2009-02-15 00:00:00 | Oranges | 4 | 32
2009-02-16 00:00:00 | Oranges | 7 | 56
2009-02-16 00:00:00 | Oranges | 7 | 56
2009-02-19 00:00:00 | Oranges | 3 | 24
2009-02-20 00:00:00 | Oranges | 1 | 8
Spreadsheet: 744861d1629494420-averaging-rents-based-on-two-criteria-excelforumsample
Sheet: Sheet1

Name | 5X10 | 10X10 | 10X15 | 10X20 | 10X30 | 5X5 CC | 5X10 CC | 10X10 CC | 10X15 CC | 10X20 CC | 10X30 CC | Impr. Rating |  |  | sq ft | market rent |  | subject impr. rating
Sq ft | 50 | 100 | 150 | 200 | 300 | 25 | 50 | 100 | 150 | 200 | 300 |  |  |  | 25 |  |  | B
 | 69 | 99 | 119 | 159 |  |  | 84 | 119 | 169 | 204 |  | A |  |  | 50
 |  |  | 117 |  |  |  | 82 |  |  |  |  | B |  |  | 100
 | 62 | 90 | 119 | 144 | 194 |  | 81 | 126 | 152 | 189 |  | A |  |  | 120
 |  |  |  |  |  |  | 84 | 125 | 158 | 215 |  | A |  |  | 150
 | 55 | 79 | 99 | 114 | 145 | 50 | 70 | 109 | 139 | 164 | 211 | A
 |  | 79 |  | 139 |  |  |  |  |  |  |  | C
Spreadsheet: 785483d1656439264-excel-skills-for-business-advanced-week-2-problem-wssa
Sheet: Distances

 | Section 3 - Transpose and more arrays
 | Towns
 | Alphaville
 | [NAME]
 | Charliefield
 | Deltatown
 | Echopolis
 | These have the name "Towns"
 | Distance table (miles)
 | Town 1 | Town 2 | Distance |  |  |  | [NAME]
 |  |  | 0 |  |  | Question 9
 |  | [NAME] | 140 |  |  | Question 10
 |  | Charliefield | 300 |  |  | Question 11
 |  | Deltatown | 214
 |  | Echopolis | 78
 |  |  |  |  |  | Row / Column counter |  | 1 | 2 | 3 | 4 | 5
 |  |  | 0
 |  |  | 365 |  |  | 1
 |  |  | 320 |  |  | 2
 |  |  | 205 |  |  | 3
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  | 0
 |  |  | 217
 |  |  | 348
 |  |  | 0
 |  |  | 191
 |  |  | 0
 | End of section
Spreadsheet: 97323d1296539095-joining-columns-of-different-lengths-from-different-sheets-array3dvlookup
Sheet: Sheet5

40 | code40 | Name40 | Addr40 | City40 | Zip40 | Phone40
41 | code41 | Name41 | Addr41 | City41 | [NAME] | Phone41
42 | code42 | Name42 | Addr42 | City42 | Zip42 | Phone42
43 | code43 | Name43 | Addr43 | City43 | Zip43 | Phone43
44 | code44 | Name44 | Addr44 | City44 | Zip44 | Phone44
45 | code45 | Name45 | Addr45 | City45 | Zip45 | Phone45
46 | code46 | Name46 | Addr46 | [NAME] | Zip46 | Phone46
Spreadsheet: 176018d1345708638-help-creating-form-to-save-data-into-new-sheets-day-end-and-waste1
Sheet: WASTE

W/E | Dart | Trib | 4.9 | 5.0 + | Carls | Vier | Korev | Copper | Gold & Dry | Heritage | 1/2 P.Mix | [NAME]
Mon
Tue
Wed
Thurs
Fri
Sat
Sun
Sub Total
Pipes
Total
Spreadsheet: 721970d1614968168-google-sheets-need-to-find-the-match-number-then-enter-the-text-find-the-match-number-etaf
Sheet: Sheet2

MATCHING NUMBER |  |  | Column D | Column E
15 |  |  | TEXT1 |  | < if column E2 = BLANK then do nothing
2 |  |  | [NAME] | TEXT6 | < if column D3 & E3 = NOT BLANK then do nothing
4 |  |  |  | TEXT7 | < if column D4 = BLANK & E4 = NOT BLANK then find the MATCHING number in column A (2); FIND THE NUMBER 2 IN COLUMN A SHEET 1 > ENTER TEXT "FOUND" IN COLUMN K:K
6 |  |  | TEXT3 |  | < if column E5 = BLANK then do nothing
1 |  |  | TEXT4 | [NAME] | < if column D6 & E6 = NOT BLANK then do nothing
12 |  |  | TEXT5 | TEXT9
6 |  |  |  | TEXT10 | < if column D8 = BLANK & E8 = NOT BLANK then find the MATCHING number in column A (6); FIND THE NUMBER 6 IN COLUMN A SHEET 1 > ENTER TEXT "FOUND" IN COLUMN K:K
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: 1Plan-2Opt

 | Insured HRA Quote for:
 |  |  |  | 2500dd/10K
 | Census | Status | Medical |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 |  |  |  | 2500dd/10K
 | Census | Status | Medical |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 |  |  |  | 2500dd/10K
 | Census | Status | Medical | Insured HRA | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 |  |  |  | 2500dd/10K
 | Census | Status | Medical | Insured HRA | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 |  |  |  | 2500dd/10K
 | Census | Status | Medical | Insured HRA | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Proposed Plan 1: Annual Savings Versus Renewal Plan
 | Proposed Plan 2: Annual Savings Versus Renewal Plan
 | Proposed Plan 3: Annual Savings Versus Renewal Plan
Spreadsheet: 789240d1659011300-calculate-currency-and-in-a-range-of-cells-based-on-a-match-mismatch-sum_match_mismatch-solution
Sheet: Sheet4

Payment 1 | Payment 2 | Difference
100 | 100 | Match |  | 300 | Total Match Positive Numbers
200 | 200 | Match |  | 698 | Total Mismatch Positive Numbers
300 | 299 | Mismatch
400 | 399 | Mismatch
Payment 1 | Payment 2 | Difference
-100 | -100 | Match |  | -300 | Total Match Negative Numbers
-200 | -200 | Match |  | -698 | Total [NAME] Numbers
-300 | -299 | Mismatch
-400 | -399 | Mismatch
 |  | SOLUTION
 |  | Add the = sign to the front of the formula below
 |  | [NAME]:D199,E4:E199,"Match",D4:D199,"<"&0) | Counts a match less than zero
 |  | [NAME]:D199,E4:E199,"Match",D4:D199,">"&0) | Counts a match greater than zero
 |  | [NAME]:D199,E4:E199,"Mismatch",D4:D199,"<"&0) | Counts a Mismatch less than zero
 |  | [NAME]:D199,E4:E199,"Mismatch",D4:D199,">"&0) | Counts a Mismatch greater than zero
Spreadsheet: 178811d1346927218-coditional-format-for-multiple-options-test-2
Sheet: Resource

Engineer 1 | Engineer 2 |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
AT | AW |  |  |  |  | AT | TB | PC | PW | KM
 |  |  |  |  |  | MG | MG | MG | MG | MG
 |  |  |  |  |  | BC | BC | BC | BC | BC
 |  |  |  |  |  | SD | SD | SD | SD | SD
 |  |  |  |  |  | SP | SP | SP | SP | SP
 |  |  |  |  |  | AW | AW | AW | AW | AW
 |  |  |  |  |  | KJ | KJ | KJ | KJ | KJ
 |  |  |  |  |  | OM | OM | OM | OM | OM
 |  |  |  |  |  | JG | JG | JG | JG | JG
 |  |  |  |  |  | TM | TM | TM | TM | TM
 |  |  |  |  |  | CM/CG | CM/CG | CM/CG | CM/CG | CM/CG
 |  |  |  |  |  | HW/SR | HW/SR | HW/SR | HW/SR | HW/SR
 |  |  |  |  |  | NJ/TA | NJ/TA | NJ/TA | NJ/TA | NJ/TA
 |  |  |  |  |  | DP/KB | DP/KB | DP/KB | DP/KB | DP/KB
 |  |  |  |  |  | WD | WD | WD | WD | WD
 |  |  |  |  |  | AP | AP | AP | AP | AP
 |  |  |  |  |  | BCoop | BCoop | BCoop | BCoop | BCoop
 |  |  |  |  |  | MT | MT | MT | MT | MT
 |  |  | ISNUMBER(MATCH(G2,A:A,0))
Spreadsheet: 8b296648-646c-4adf-8885-e7b9dd61450b
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
History
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 185544d1349761573-how-to-combine-data-categories-when-making-a-pie-chart-monthly-expense
Sheet: Sheet1

2012-10-01 00:00:00
Date | Item | Category | Amount | *Note |  |  |  |  |  |  | Row Labels | Sum of Amount
2012-10-01 00:00:00 | Grocery | Food | 46.02 |  |  |  |  |  |  |  | Food | 107.02
2012-10-02 00:00:00 | Lunch | Food | 7.9 |  |  |  |  |  |  |  | Gas / Fuel | 62.5
2012-10-05 00:00:00 | 15 gallons | Gas / Fuel | 62.5 |  |  |  |  |  |  |  | Shopping | 95.47999999999999
2012-10-05 00:00:00 | Bath accessories | Shopping | 41.27 |  |  |  |  |  |  |  | Grand Total | 265
2012-10-06 00:00:00 | Binders, supplies | Shopping | 35.8
2012-10-06 00:00:00 | [NAME] | Food | 13.52
2012-10-07 00:00:00 | B Buy - lens filter | Shopping | 18.41
2012-10-08 00:00:00 | Grocery | Food | 39.58
 |  |  |  |  |  | Total Food Expenses: |  |  | $
 |  |  |  |  |  | Total Gas / Fuel expenses: |  |  | $
 |  |  |  |  |  | Total Shopping expenses: |  |  | $
 |  |  |  |  |  | Total Housing expenses: |  |  | $
Spreadsheet: 34102d1231236412-complicated-ques-cross-referencing-data-in-sheets-test
Sheet: DETAILS

 | Date | Prod Code | Part Number | Qty inspected | Barcodes | Result
 | 2009-01-01 00:00:00 | LIONXX | 11111 | 5 | LIONXX12345 | P
 |  |  |  |  | LIONXX23456 | P
 |  |  |  |  | LIONXX34567 | P
 |  |  |  |  | LIONXX45678 | F
 |  |  |  |  | LIONXX56789 | P
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | 7 | TIGERYY78990 | F
 |  |  |  |  | TIGERYY89012 | F
 |  |  |  |  | TIGERYY45632 | P
 |  |  |  |  | TIGERYY15461 | P
 |  |  |  |  | TIGERYY56564 | P
 |  |  |  |  | TIGERYY67894 | P
 |  |  |  |  | TIGERYY45612 | P
 | 2009-03-01 00:00:00 | PANTHERZZ | 33333 | 2 | PANTHERZZ12346 | P
 |  |  |  |  | PANTHERZZ56784 | P
Spreadsheet: 146952d1332435928-nested-if-function-or-something-else-if_mk2012
Sheet: Sheet1

Client | [NAME] (proj over 12 months) | 3Yrs claims ratio | [NAME] | [NAME] | Profit Cat | [NAME] | 2yr ave growth % | 2yr ave Churn % | Growth Cat | Growth Quartile | QuartileSegment | Churn Cat | [NAME] | P score | S score | G score | C score | PC Score | Total | Rank | Q
Client 1 | 28074492.01199999 | 0.4350698389434863 | Size 1 | SizeQHigher | Profit 1 | 1423 | 0.08308095719738695 | 0.0964794219193987 | Growth 2 | GrowthQHigher |  | Churn 1 | [NAME] | 35 | 15 | 15 | 20 | 10 | 95 | 1 | Q1
Client 2 | 10806980.28 | 0.4387452588524053 | [NAME] | SizeQHigher | Profit 1 | 490 | 0.7903066684204342 | 0.09644372600525358 | Growth 1 | GrowthQHigher |  | Churn 1 | [NAME] | 35 | 11.25 | 20 | 20 | 7.5 | 93.75 | 2 | Q1
Client 3 | 6567134.543999998 | 0.4191397259422948 | [NAME] | SizeQHigher | Profit 1 | 324 | 0.6575002665387376 | 0.09420048791306276 | Growth 1 | GrowthQHigher |  | Churn 1 | [NAME] | 35 | 11.25 | 20 | 20 | 7.5 | 93.75 | 3 | Q1
Client 4 | 68749687.38000001 | 0.4611428203921145 | Size 1 | SizeQHigher | Profit 2 | 5543 | 2.539851301165962 | 0.09620857846014239 | Growth 1 | GrowthQHigher |  | Churn 1 | [NAME] | 26.25 | 15 | 20 | 20 | 10 | 91.25 | 4 | Q1