tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219601d1362804983-formula-to-calculate-a-of-a-capped-value-frustrated-excelexample
Sheet: Sheet1

Personnel Costs | 175009.0777065 | 175009.0777065 | 175009.0777065 | 175009.0777065 | 700036.3108260001
Supplies | 0 | 0 | 0 | 0 | 0
Professional Services | 0 | 0 | 0 | 0 | 0
Study Fees | 555761.475 | 555761.475 | 400148.2619999999 | 355687.344 | 1867358.556
3rd Party Expenses | 0 | 0 | 0 | 0 | 0
3rd Party Expenses-SubContractor | 2000 | 10000 | 3000 | 20000
Capital Expenditures | 75000 | 22000 | 13000 | 7000 | 0
Laboratory Animal Services | 0 | 0 | 0 | 0 | 0
Regulatory Fees | 41000 | 41000 | 41000 | 41000 | 164000
Release Testing | 0 | 0 | 0 | 0 | 0
Direct Expense Total
Indirect Cost (28%)
Total  Direct & Indirect
Cumulative $25k CAP |  |  |  | 10000
Notes:
An Indirect cost factor of 28% is charged on all expenses except Capital. And only 28% can be charged against the FIRST $25K of 3rd Party Expenese from Subcontractors (highlighted in yellow)
The first $25,000 of 3rd Party Subcontractor expenses are charged overhead.
I'd like to write a formula that will apply 28% to first $25K; and ignore remaining Subcontractor expenses. I'm currently changing the formula each month; too much opportunity for human error to occur!
Below are the correct answers.
sumcheck
Spreadsheet: 794614d1662140127-how-to-use-vloop-up-formula-to-retrieve-the-values-from-different-work-sheet-test
Sheet: Salary

 |  |  | Sr. # | Name | No. of Days | Salary | Commission
 |  |  | 1 | [NAME]
 |  |  | 2 | [NAME]
 |  |  | 3 | Michelle
 |  |  | 4 | [NAME]
 |  |  | 5 | [NAME]
 |  |  | 6 | Asmos
 |  |  | 7 | Senti
 |  |  | 8 | [NAME]
 |  |  | 9 | [NAME]
 |  |  | On F2 to F9 I want "R2 to R10" value from Attendace sheet
 |  |  | On G2 to G9 I want "S2 to S10" value from Attendace sheet
 |  |  | On H2 to H9 I want "E2 to E7" value from Commission sheet
Spreadsheet: 51251d1250782742-deleting-a-column-in-which-a-formula-depends-on-it-book1
Sheet: Sheet1

Item No | Description | Qty | Unit Price $ | Total $ | Unit Price ZMK | Total ZMK |  | Conversion: | 5000
1234 | radio | 1 | 150
1364 | hat | 1 | 55
3243 | car | 2 | 256
Spreadsheet: 809555d1671148674-narrow-a-countif-range-to-a-single-row-book1-25-
Sheet: Sheet1

 | Employee 1
Table "January"
row 1 | Employee Name | jan-01 | jan-02 | jan-03 | jan-04
row 2 | Employee 1 |  | X | V | V
row 3 | Employee 2 | V | V | V | V
Spreadsheet: 57287d1257398314-help-on-formula-multiple-worksheets-706059-help-on-formula-multiple-worksheets
Sheet: 0420.02 Conc Substructure

Project: |  |  |  |  |  |  |  |  |  | Claim No.: | 1
Building: |  |  |  |  |  |  |  |  |  | Proj No.:
Trade No / Trade Name | TP 0420-1 | Concrete Substructure |  |  |  |  |  |  |  | Date Issued: | 2009-10-30 00:00:00
[NAME]
TP No:- | Subcontract / Supply No | Description |  | Subcontractor / Supplier | Original Contract Sum | Adjustment | Adjusted Contract Sum | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 5000 | 0 | 5000 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Contract Works Sub-Total | 5000 | 0 | 5000 | 0 | 0 | 0 | 0
Variation / Claims
SCVO | Status | Description | Notification / Instruction # | Subcontractor / Supplier | Budget | Adjustment | Adjusted Budget | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
TP 0420-1 | Concrete Substructure |  |  | NET TOTAL | 5000 | 0 | 5000 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | A | Approved
 |  |  |  |  |  |  | P | Submitted / Pending Approval
 |  |  |  |  |  |  | D | Disputed
 |  |  |  |  |  |  | R | Rejected
Spreadsheet: 71130d1271854697-preventing-duplicate-entries-using-a-data-validation-list-duplicate-wagon-numbers_ronc
Sheet: Sheet2

WAGON NUMBERS | AvailableNumbers |  |  | The range name wagonnumbers is now a dynamic range name
1 | 1 |  |  | that refers to the available numbers list.
2 | 2
3 | 3 |  |  | It is defined as: =OFFSET(Sheet2!$B$2,,,COUNT(Sheet2!$B$2:$B$21),1)
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
12 | 12
13 | 13
14 | 14
15 | 15
16 | 16
17 | 17
18 | 18
19 | 19
20 | 20
Spreadsheet: 820858d1678310262-complex-formulas-combining-sumif-and-ifs-table-3-
Sheet: Sheet1

Employee Name | Job Position | Department | Start Date | Salary | Benefits | Employer Taxes | Total Yearly Costs
 |  |  |  |  | 0.12 | 0.08
Hire 1 | Position 1 | Science | 2023-01-10 00:00:00 | 100000
Hire 2 | Position 2 | Product | 2023-06-01 00:00:00 | 200000
Hire 3 | Position 3 | Corporate | 2023-05-25 00:00:00 | 400000
Hire4 | Position 4 | Engineering | 2023-04-25 00:00:00 | 350000
Hire 5 | Position 5 | Product | 2023-10-05 00:00:00 | 200000
Hire 6 | Position 6 | Science | 2024-02-04 00:00:00 | 100000
 | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 | 2023-01-01 00:00:00 | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-10-01 00:00:00 | 2024-01-01 00:00:00 | 2024-04-01 00:00:00
 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Science
Product
Corporate
Engineering
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: MathSciNet

MathSciNet
2008-2009
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per search
MathSciNet
Sessions | 317 | 105 | 393 | 311 | 837 | 659 | 563 | 747 | 695 | 987 | 791 | 735
Searches | 380 | 204 | 609 | 532 | 968 | 868 | 731 | 1076 | 850 | 1226 | 920 | 952 |  | 7567.5
COUNTER-Compliant?: | No
Spreadsheet: 707723d1607432118-if-function-formula-returning-value-from-different-sheet-based-on-text-in-cell-risk-figures
Sheet: Sheet1

 | Q1 |  | Q2 |  | Q3 |  | Q4
 | At Risk | Amount at Risk | At Risk | Amount at Risk | At Risk | Amount at Risk | At Risk | Amount at Risk
Quarterly Sales Volume | At risk |  | At risk |  | At risk |  | At risk
Training | No Risk |  | No Risk |  | No Risk |  | No Risk
Mystery Shop | No Risk |  | No Risk |  | No Risk |  | No Risk
Monthly Target | No Risk |  | No Risk |  | No Risk |  | No Risk
[NAME] (GKL) - based on wholesales | No Risk |  | No Risk |  | No Risk |  | No Risk
Quality of Revenue | No Risk |  | No Risk |  | No Risk |  | No Risk
Voice of the customer | No Risk |  | At risk |  | At risk |  | At risk
[NAME] (PHEV) | No Risk |  | No Risk |  | No Risk |  | No Risk
Retailer KPI perfomance Management | No Risk |  | No Risk |  | No Risk |  | No Risk
Retail Marketing | No Risk |  | No Risk |  | No Risk |  | No Risk
Total
Spreadsheet: 67910d1268412500-condensing-data-automatically-teste
Sheet: Program Control

TABLE:  Program Control
ProgramName | Version | ProgLevel | LicenseNum | LicenseOS | LicenseSC | LicenseBR | LicenseHT | CurrUnits | SteelCode | ConcCode | AlumCode | ColdCode | BridgeCode | RegenHinge | BSchedGUID
Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text | Text
SAP2000 | 12.0.0 | Advanced |  | Yes | Yes | Yes | No | KN, m, C | AISC-LRFD93 | ACI 318-05/IBC2003 | AA-ASD 2000 | AISI-ASD96 | [NAME] 2007 | Yes
Spreadsheet: b837b5d5-a80f-45bb-8dd9-1b21013bfc39
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (1 Entry):
 | 4 Micronano-systems 4.2 MEMS 4.2.4 MEMS actuators 4.2.4.1 Micronozzles
No. | Company | Country | City | [NAME] | Hall/Booth
1 | DALSA Semiconductor | Canada | Bromont | Quebec | A2.418
Spreadsheet: 871395d1717771827-trying-to-populate-a-row-from-merged-cells-with-a-helper-column-testing-heirarchy
Sheet: HRBP Proposed Org Structure - H

Tier 1 | [NAME] | Tier 3 | [NAME] | Tier 5 | Tier 6 | Lowest Tiers
R&D
 | Engineering
 |  | Software Development
 |  |  | Payroll Engineering
 |  |  |  | US Payroll
 |  |  |  | PEO Engineering
 |  |  |  | Global Payroll Engineering
 |  |  |  | Payroll Core
 |  |  |  | EOR Engineering
 |  |  |  | Payroll Engines
 |  |  |  |  | Payspace
 |  |  |  | Contracts & ICs
 |  |  |  | Benefits
 |  |  | Mobility Engineering
 |  |  | Time & Attendance
 |  |  | HRIS Engineering
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  | Platform
 |  |  |  | Integrations
 |  |  |  | Onboarding
 |  |  | Finance & Payments
 |  |  | Knowledge & Growth
 |  |  | UI
 |  |  | Tech Excellence
 |  | Infra | Infra Engineering
 |  |  | DevOps
 |  |  | Database
 |  | IT
 |  | InfoSec
 | Product | Product Management | Product, EOR & Payroll
 |  |  | Product, Payments & Integrations
 |  |  | Product, HRIS
 |  |  | Product, Engage
 |  | Data | Data Science
 |  |  | Data & Analytics
 |  |  | Product Analytics
 |  |  | Platform Operations
 |  |  | Integrations
Spreadsheet: 08feaff5-7cbc-4557-8932-212b20121bb0
Sheet: RefWorks Usage 10-11

RefWorks
2010-2011
Metric | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Cost per unit
New Users | 17 | 7 | 71 | 112 | 18 | 8 | 8 | 139 | 63 | 28 | 12 | 8 |  | 14030
Repeat Users | 31 | 20 | 39 | 96 | 120 | 86 | 35 | 66 | 131 | 135 | 76 | 37 |  | 14030
Total Monthly Users | 48 | 27 | 110 | 208 | 138 | 94 | 43 | 205 | 194 | 163 | 88 | 45 |  | 14030
Total Sessions per month | 243 | 109 | 337 | 698 | 570 | 378 | 160 | 793 | 1161 | 763 | 335 | 227 |  | 14030
Average Sessions Per User | 5.06 | 4.04 | 3.06 | 3.36 | 4.13 | 4.02 | 3.72 | 3.87 | 5.98 | 4.68 | 3.81 | 5.04 |  | 14030
Total Subscriber References added | 2225 | 7 | 3382 | 4553 | 2949 | 1009 | 1610 | 1669 | 4615 | 2762 | 767 | 1473 |  | 14030
Average References added per user | 46.35 | 24.19 | 30.75 | 21.89 | 21.37 | 10.73 | 37.44 | 8.14 | 23.79 | 16.94 | 8.72 | 32.73 |  | 14030
TOTAL USERS = 2,145
TOTAL REFERENCES = 86,379
Spreadsheet: 840734d1692946321-formula-to-create-list-based-on-filter-test
Sheet: Participant Costing

 | 1 | 2 | 3
Client | [NAME]
 | Programs | Times |  | Hours | Apportion | Transport | [NAME]
Program
Total
 |  |  | Group Activities - Standard - Weekday Daytime
 |  |  | Centre Capital Cost
 |  |  | Transport
 |  |  | Transport kms
 |  |  | [NAME]
 |  |  | Weekly Cost of Programs
Spreadsheet: 56232d1256313876-excel-2007-inventory-chart-704415-inventory-chart
Sheet: Database

Part Number | Connector | Connector Qty | Terminal | Terminal Qty
123xyz | connector x | 1 | terminal 1 | 4
456abc | connector y | 2 | terminal 2 | 2
789wsz | connector z | 3 | terminal 3 | 6
Spreadsheet: 739753d1625916193-applying-conditional-formatting-with-3-criterias-cf
Sheet: Sheet1

2021-07-01 00:00:00
Spreadsheet: 156362d1337269557-how-to-calculate-bi-hourly-sales-without-a-rolling-total-hourly-sales
Sheet: Sheet1

 | Agents |  | 8
 |  |  | Apps | Approved | Increase in sales | Average Per agent |  |  | Helper 1 Apps | Helper 2 Approved
 | 1 | 10:00:00 | 10 | 10
 |  | 12:00:00
 |  | 14:00:00
 |  | 16:00:00 | 60 |  | 0
 | Total
 | Agents |  | 4
 |  |  | Apps | Approved | Increase in sales | Average Per agent |  |  | Helper 1 Apps | Helper 2 Approved
 | 2 | 10:00:00 | 10
 |  | 12:00:00
 |  | 14:00:00 | 0
 |  | 16:00:00 | 20 |  | 0
 | Total
 | Agents |  | 8
 |  |  | Apps | Approved | Increase in sales | Average Per agent |  |  | Helper 1 Apps | Helper 2 Approved
 | 3 | 10:00:00
 |  | 12:00:00
 |  | 14:00:00
 |  | 16:00:00 |  |  | 0
 | Total
 | Agents |  | 8
 |  |  | Apps | Approved | Increase in sales | Average Per agent |  |  | Helper 1 Apps | Helper 2 Approved
 | 4 | 10:00:00
 |  | 12:00:00
 |  | 14:00:00
 |  | 16:00:00 |  |  | 0
 | Total
 | Agents |  | 8
 |  |  | Apps | Approved | Increase in sales | Average Per agent |  |  | Helper 1 Apps | Helper 2 Approved
 | 5 | 10:00:00
 |  | 12:00:00
 |  | 14:00:00
 |  | 16:00:00 |  |  | 0
 | Total
 | Total Applications
 | Total Approved
 | Average Per Agent
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100166

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
SECURITY CHARGES - Dept. 100166
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-06-21 00:00:00 | BSC100166-2001-06-0366-112458 |  | Building Security | Sq. Ft. Occupied | 165 | 0.07 | /EACH | 11.55
 |  |  |  |  |  |  | Ticket Total |  | 11.55
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 11.55
 |  |  |  |  |  |  | Total for Dept_100166 |  | 11.55
Spreadsheet: 541647d1507463197-problem-with-sum-function-sum-function
Sheet: Sheet1

Sale price | my shipping price | Refferal Charges | closing fee | shipping charges | Actual Profit
555 | 99 |  |  | 130
222 | 99 |  |  | 182
333 | 99 |  |  | 77
111 | 99 |  |  | 94
Spreadsheet: 162676d1340030839-complex-if-and-logic-help-needed-commscalc-example-test
Sheet: Example

User defined Values |  |  | User Defined Ramps:
Quota | 1000 |  | Ramps / Accelerators | Low Value | High Value | Multiplier
Commission | 100 |  | Ramp 1 | 0 | 100 | 1
Base Amount | 100 |  | Ramp 2 | 101 | 150 | 2.4
 |  |  | Ramp 3 | 151 | 9999 | 2.7
Calculator | Sales $ | Achievement % | Commission $ | Answer should be
Q1 | 200 |  |  | 20
Q2 | 200 |  |  | 40
Q3 | 300 |  |  | 70
Q4 | 300 |  |  | 100
Total |  |  |  | 100
EXAMPLE:
In this example the sales person has a quota of 1000 and manually inputs their quarterly achievement / Forecast (in GREEN). The Quarterly achievement is automatically calculated and the commission dollar value is calculated based on the Ramp Multipliers.
Commission Calculations based on example ramps
Nought to 100% | if achievement is between 0 and 100 then multiply achievement by commision multiplied by the ramp.
101% -150% | IF achievement is greater than 151% of quota then multiply 50 by ramp by commission value ELSE if achievement is greater than 100% of quota then subtract 100 from the  total achievment then multiply commission by ramp else 0
150%-9999% | IF achievement is greater than 151% of quota then multiply subtract 150 from the  total achievment then multiply commission by ramp 3 else 0
Spreadsheet: 703056d1604699804-nesting-multiple-if-and-functions-book2
Sheet: Manual Inputs

Blue- Input
Black- [NAME]
Green- Linked to another Sheet
What Fiscal Year Is It? | 2022
Outlook End Dates For Forecasted Year |  |  | SMA Inputs |  |  | Yields
Q1 | 2021-04-30 00:00:00 |  | Holdings as of: | 2020-11-02 00:00:00 |  | Reinvested Corporate Yield | 0.002
Q2 | 2021-07-31 00:00:00 |  | Market Value + Accrued | 2471500000 |  | Reinvested Treasury Yield | 0.001
Q3 | 2021-10-31 00:00:00 |  |  |  |  | MMF | 0.0001
Q4 | 2022-01-31 00:00:00
Beginning of Forecasted Year
Q1 Start Date | 2021-02-01 00:00:00
Spreadsheet: 186242d1349966517-trying-to-split-a-price-across-a-date-to-work-out-weekly-income-examplebook
Sheet: Sheet1

 |  |  |  |  |  |  | Sept |  |  |  | Oct |  |  |  | Nov |  |  |  | Dec |  |  |  | Jan |  |  |  | Feb
Start Date | Price | Duration (weeks) | Price/w |  |  |  | 2012-09-30 00:00:00 |  |  |  | 2012-10-01 00:00:00
2012-11-11 00:00:00 | 50000 | 50
2012-11-12 00:00:00 | 25000 | 9
2012-11-13 00:00:00 | 19456 | 6
2012-11-14 00:00:00 | 273895 | 34
Spreadsheet: 537848d1505299873-how-to-split-rows-by-date-and-time-s666-1200664-how-to-split-rows-by-date-and-time
Sheet: Sheet1

Start Date | Start Time | End Date | End Time
2016-10-07 00:00:00 | 17:45:00 | 2016-10-08 00:00:00 | 11:20:00 |  | Date | Time
2016-10-08 00:00:00 | 13:05:00 | 2016-10-09 00:00:00 | 11:10:00 |  | 2016-10-07 00:00:00 | 17:45:00
2016-10-09 00:00:00 | 11:10:00 | 2016-10-10 00:00:00 | 11:15:00 |  | 2016-10-08 00:00:00 | 11:20:00
2016-10-10 00:00:00 | 11:45:00 | 2016-10-10 00:00:00 | 14:45:00 |  | 2016-10-08 00:00:00 | 13:05:00
2016-10-10 00:00:00 | 15:35:00 | 2016-10-10 00:00:00 | 17:30:00 |  | 2016-10-09 00:00:00 | 11:10:00
2016-10-10 00:00:00 | 18:10:00 | 2016-10-11 00:00:00 | 08:15:00 |  | 2016-10-09 00:00:00 | 11:10:00
2016-10-11 00:00:00 | 08:15:00 | 2016-10-11 00:00:00 | 09:40:00 |  | 2016-10-10 00:00:00 | 11:15:00
2016-10-11 00:00:00 | 10:35:00 | 2016-10-11 00:00:00 | 12:50:00 |  | 2016-10-10 00:00:00 | 11:45:00
2016-10-11 00:00:00 | 13:50:00 | 2016-10-11 00:00:00 | 14:45:00 |  | 2016-10-10 00:00:00 | 14:45:00
2016-12-15 00:00:00 | 19:50:00 | 2016-12-15 00:00:00 | 19:50:00 |  | 2016-10-10 00:00:00 | 15:35:00
2016-12-15 00:00:00 | 21:05:00 | 2016-12-16 00:00:00 | 11:15:00 |  | 2016-10-10 00:00:00 | 17:30:00
2016-12-16 00:00:00 | 14:05:00 | 2016-12-17 00:00:00 | 09:50:00 |  | 2016-10-10 00:00:00 | 18:10:00
2016-12-17 00:00:00 | 11:05:00 | 2016-12-17 00:00:00 | 11:35:00 |  | 2016-10-11 00:00:00 | 08:15:00
2016-12-17 00:00:00 | 16:25:00 | 2016-12-18 00:00:00 | 10:10:00 |  | 2016-10-11 00:00:00 | 08:15:00
2016-12-18 00:00:00 | 12:15:00 | 2016-12-20 00:00:00 | 11:30:00 |  | 2016-10-11 00:00:00 | 09:40:00
 |  |  |  |  | 2016-10-11 00:00:00 | 10:35:00
 |  |  |  |  | 2016-10-11 00:00:00 | 12:50:00
 |  |  |  |  | 2016-10-11 00:00:00 | 13:50:00
 |  |  |  |  | 2016-10-11 00:00:00 | 14:45:00
 |  |  |  |  | 2016-12-15 00:00:00 | 19:50:00
 |  |  |  |  | 2016-12-15 00:00:00 | 19:50:00
 |  |  |  |  | 2016-12-15 00:00:00 | 21:05:00
 |  |  |  |  | 2016-12-16 00:00:00 | 11:15:00
 |  |  |  |  | 2016-12-16 00:00:00 | 14:05:00
 |  |  |  |  | 2016-12-17 00:00:00 | 09:50:00
 |  |  |  |  | 2016-12-17 00:00:00 | 11:05:00
 |  |  |  |  | 2016-12-17 00:00:00 | 11:35:00
 |  |  |  |  | 2016-12-17 00:00:00 | 16:25:00
 |  |  |  |  | 2016-12-18 00:00:00 | 10:10:00
 |  |  |  |  | 2016-12-18 00:00:00 | 12:15:00
 |  |  |  |  | 2016-12-20 00:00:00 | 11:30:00
Spreadsheet: 774083d1648205586-formula-to-change-the-score-according-to-multiple-variants-if-formula
Sheet: Sheet1

 |  | Situation | sub score |  |  | Score
 |  | a | 0.02 |  |  |  |  |  |  |  | Score | Classification | [NAME]
 |  | b | 0.04 |  |  |  |  |  |  |  | 15 | Prohibited
 |  |  |  |  |  |  |  |  |  |  | 12 | Prohibited
 |  |  |  |  |  |  |  |  |  |  | 5 | Medium
 |  |  |  |  |  |  |  |  |  |  | 13 | Low
 |  |  |  |  |  |  |  |  |  |  | 9 | High
 |  |  |  |  |  |  |  |  |  |  | 19 | Medium
 |  | Classification | score adjustment | revised score |  |  |  |  |  |  | 13 | Low
 |  | Prohibited | 2 | 8 |  |  |  |  |  |  | 9 | High
 |  | Very High | 2 | 8 |  |  |  |  |  |  | 10 | Very High
 |  | High | 1 | 7 |  |  |  |  |  |  | 20 | Very High
 |  | Medium | 0 | 6 |  |  |  |  |  |  | 18 | Very High
 |  | Low | -2 | 4 |  |  |  |  |  |  | 7 | Prohibited
 |  |  |  |  |  |  |  |  |  |  | 11 | Medium
 |  | Condition: based on the different classification (prohibited, Very high,high,medium and low) the Score of 6  will change according to the score adjustment e.g if high, the score will be 7 (6+1), if low the score will be 4 (6-2) etc.
Spreadsheet: 54308d1254317825-sorting-column-problem-sorting-
Sheet: El Arroyo

Quarter | QtrStarts | QtrClosings | AnnStarts | AnnClosings | AnnDeliv | FVMos | HousMos | VDLMos | Occupied | Models (Mod) | FinVacant (FV) | UnderConst (UC) | VDLInv (VDL) | FutureUnits (Fut) | TotalUnits (Tot)
1Q06 | 39 | 50 | 236 | 177 | 128 | 1.8 | 5.8 | 5.1 | 180 | 4 | 27 | 54 | 100 | 0 | 365
1Q07 | 12 | 25 | 76 | 144 | 0 | 0.6 | 1.4 | 3.8 | 324 | 2 | 7 | 8 | 24 | 0 | 365
1Q08 | 4 | 5 | 23 | 37 | 0 | 0 | 1 | 0.5 | 361 | 0 | 0 | 3 | 1 | 0 | 365
1Q09 | 0 | 1 | 1 | 4 | 0 | 0 | 0 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 365
2Q05 | 59 | 11 | 88 | 14 | 365 | 6.9 | 63.4 | 37.8 | 14 | 4 | 8 | 62 | 277 | 0 | 365
2Q06 | 37 | 66 | 214 | 232 | 0 | 1.3 | 2.9 | 3.5 | 246 | 4 | 26 | 26 | 63 | 0 | 365
2Q07 | 7 | 10 | 46 | 88 | 0 | 0.8 | 1.9 | 4.4 | 334 | 2 | 6 | 6 | 17 | 0 | 365
2Q08 | 0 | 1 | 16 | 28 | 0 | 0 | 0.9 | 0.8 | 362 | 0 | 0 | 2 | 1 | 0 | 365
2Q09 | 0 | 0 | 1 | 3 | 0 | 0 | 0 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 365
3Q05 | 80 | 53 | 166 | 67 | 209 | 5.2 | 18.1 | 14.2 | 67 | 4 | 29 | 68 | 197 | 0 | 365
3Q06 | 1 | 22 | 135 | 201 | 0 | 1.5 | 2.1 | 5.5 | 268 | 2 | 25 | 8 | 62 | 0 | 365
3Q07 | 12 | 10 | 57 | 76 | 0 | 0.9 | 2.5 | 1.1 | 344 | 2 | 6 | 8 | 5 | 0 | 365
3Q08 | 1 | 1 | 5 | 19 | 0 | 1.3 | 1.3 | 0 | 363 | 0 | 2 | 0 | 0 | 0 | 365
4Q05 | 58 | 63 | 219 | 130 | 128 | 2.2 | 8.9 | 7.6 | 130 | 4 | 24 | 68 | 139 | 0 | 365
4Q06 | 26 | 31 | 103 | 169 | 0 | 1.3 | 2.1 | 4.2 | 299 | 2 | 18 | 10 | 36 | 0 | 365
4Q07 | 0 | 12 | 31 | 57 | 0 | 0.8 | 0.8 | 1.9 | 356 | 0 | 4 | 0 | 5 | 0 | 365
4Q08 | 0 | 1 | 5 | 8 | 0 | 1.5 | 1.5 | 0 | 364 | 0 | 1 | 0 | 0 | 0 | 365
 |  | Builtout?
 |  | Yes 2q09
Spreadsheet: 61295d1262119509-contents-of-a-cell-s-from-one-worksheet-into-a-cell-in-another-worksheet-lookup1
Sheet: Sheet2

Requirements ID | Test Case ID
1000 | 47
1009 | 48
1001 | 33
1003 | 39
1002 | 41
1008 | 32
1007 | 34
1009 | 48
1000 | 47
1003 | 39
Spreadsheet: d383a3e5-00c5-45ba-b73e-10bb4f74a652
Sheet: Spring 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.
Master of Arts in Teaching (including [NAME])
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 1f45a310-ef69-4979-91a7-3c752fa187cd
Sheet: Sheet1

2000-11-07 00:00:00 | 2000 GENERAL ELECTION | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Summary By | [NAME] |  |  |  | Names on Checklist |  |  |  |  |  | Election-Day
Counties | Regular | Absentee | Total |  | Republicans |  | Democrats | Undeclared | Total |  | Registrations**
Belknap | 24712 | 2735 | 27447 |  | 16748 |  | 8418 | 13962 | 39128 |  | 2565
Carroll | 21807 | 3153 | 24960 |  | 14662 |  | 5800 | 15312 | 35774 |  | 2116
Cheshire | 31460 | 2391 | 33851 |  | 16201 |  | 14577 | 21336 | 52114 |  | 3941
Coos | 13684 | 1382 | 15066 |  | 6865 |  | 6429 | 8473 | 21767 |  | 1086
[NAME] | 35480 | 3808 | 39288 |  | 20168 |  | 13622 | 24539 | 58329 |  | 5227
Hillsborough | 157058 | 11940 | 168998 |  | 89572 |  | 70618 | 84839 | 245029 |  | 19432
Merrimack | 60268 | 4770 | 65038 |  | 34608 |  | 22979 | 34613 | 92200 |  | 8689
Rockingham | 124543 | 10160 | 134703 |  | 71050 |  | 51121 | 85683 | 207854 |  | 12935
[NAME] | 47231 | 3348 | 50579 |  | 22718 |  | 23587 | 29156 | 75461 |  | 7724
[NAME] | 17188 | 1538 | 18726 |  | 9252 |  | 7144 | 10643 | 27039 |  | 1713
TOTALS | 533431 | 45225 | 578656 |  | 301844 |  | 224295 | 328556 | 854695 |  | 65428
**These number are included in the total number of names on checklist.