tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: AUS

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 58 | 00:01:29.844000 | 1 |  | 1 |  | 00:01:23.529000
2 | [NAME] |  |  | 18 | 58 | 00:01:30.314000 | 2 |  | 2 |  | 00:01:24.307000
3 | [NAME] |  |  | 15 | 58 | 00:01:30.064000 | 6 |  | 3 |  | 00:01:25.247000
4 | [NAME] |  |  | 12 | 58 | 00:01:29.487000 | 5 |  | 4 |  | 00:01:24.974000
5 | [NAME] |  |  | 10 | 58 | 00:01:29.600000 | 3 |  | 5 |  | 00:01:24.395000
6 | [NAME] |  |  | 8 | 58 | 00:01:29.883000 | 4 |  | 6 |  | 00:01:24.779000
7 | [NAME] |  |  | 6 | 58 | 00:01:28.947000 | 8 |  | 7 |  | 00:01:25.599000
8 | Sebastien Buemi |  |  | 4 | 57 | 00:01:30.836000 | 10 |  | 8 |  | 00:01:27.066000
9 | [NAME] |  |  | 2 | 57 | 00:01:31.526000 | 16 |  | 9 |  | 00:01:31.407000
10 | [NAME] |  |  | 1 | 57 | 00:01:31.941000 | 14 |  | 10 |  | 00:01:26.739000
11 | [NAME] |  |  | 0 | 57 | 00:01:30.467000 | 12 |  | 11 |  | 00:01:26.103000
12 | [NAME] |  |  | 0 | 57 | 00:01:32.377000 | 18 |  | 12 |  | 00:01:27.239000
13 | Jarno [NAME] |  |  | 0 | 56 | 00:01:32.550000 | 20 |  | 13 |  | 00:01:29.342000
14 | [NAME] |  |  | 0 | 54 | 00:01:34.523000 | 22 |  | 14 |  | 00:01:30.822000
15 | [NAME] |  |  | 0 | 49 | 00:01:35.789000 | 21 |  | NC |  | 00:01:29.858000
16 | [NAME] |  |  | - | 48 | 00:01:31.404000 | 17 |  | RET |  | 00:01:26.270000
17 | [NAME] |  |  | - | 22 | 00:01:33.503000 | 7 |  | RET |  | 00:01:25.421000
18 | [NAME] |  |  | - | 19 | 00:01:35.319000 | 19 |  | RET |  | 00:01:29.254000
19 | [NAME] |  |  | - | 19 | 00:01:34.918000 | 11 |  | RET |  | 00:01:25.971000
20 | Pastor Maldonado |  |  | - | 9 | 00:01:34.102000 | 15 |  | RET |  | 00:01:26.769000
21 | [NAME] |  |  | - | 58 | 00:01:29.962000 | 13 |  | DSQ |  | 00:01:26.108000
22 | [NAME] |  |  | - | 58 | 00:01:30.384000 | 9 |  | DSQ |  | 00:01:25.626000
23 | [NAME] |  |  | - | 0 |  | DNQ |  | DNQ |  | 00:01:32.978000
24 | Narain Karthikeyan |  |  | - | 0 |  | DNQ |  | DNQ |  | 00:01:34.293000
Spreadsheet: 474627d1470837898-update-quantity-in-a-cell-after-recording-a-sale-sales
Sheet: Orders

Orders
 |  |  |  |  | Item No | Design No | Description | Price | Qty | Qty in ST | Qty aft Sale
Item No |  |  |  |  | 12 | Tulip BLK | Toursers | 18 | 2 | 5 | 3
 |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  | Date | Design No | Description | P Price | S Price | Qty | Total | Postage | Packaging | Paypal Fee | [NAME] | Profit
 |  |  |  |  | 2016-08-10 00:00:00 | Tulip BLK | Toursers | 9 | 18 | 2 | 36 | 4.4 | 0.12 | 0.8300000000000001 | 1.8 | 1.849999999999999
Spreadsheet: 217962d1362269197-name-mgr-charting-formula-time-waster-timewaster
Sheet: Sheet1

 |  |  | [NAME] in Cell
 | 9876 |  |  | Test |  | 4 | Value 1
 | 10 |  |  |  |  | 3 | Value 2
 | 20 |  |  | Xvalue |  |  | Total | Taking this number and adding 3 to it
 | 30 |  |  |  |  |  |  | Then using it to find that cell number in col B
 | 40
 | 50
 | 60 |  | Using named [NAME]
 | 70
 | 80
 | 90 |  |  | Test
 | 100
 | 110 |  |  | XValue
 | 120
 | 130
 | 140
 | 150
 | 160
 | 170
 | 180
 | 190
 | 200
 | 210
 | 220
 | 230
Spreadsheet: 197202d1354242723-turning-4c-to-something-that-is-smaller-than-4a-sortingexample
Sheet: Backup

Student ID | Student Name | Progress Code
1106 | [NAME] | 5a
1234 | [NAME] | 1a
1512 | [NAME] | 2a
1531 | [NAME] | 5c
1773 | [NAME] | 3b
1839 | Chelsie | 5a
1907 | [NAME] | 2a
1919 | [NAME] | 1b
1955 | [NAME] | 2c
2020 | Willis | 5a
2030 | [NAME] | 5c
2106 | [NAME] | 5a
2115 | Chester | 5b
2121 | Mark | 1c
2413 | Emily | 2b
2906 | Betty | 1c
2927 | Lily | 3b
3155 | [NAME] | 5b
3333 | Sue | 1b
3397 | Fred | 4c
4002 | [NAME] | 2c
4231 | [NAME] | 4a
4655 | [NAME] | 3c
5583 | [NAME] | 3c
5618 | [NAME] | 4a
5688 | Willie | 4b
7377 | [NAME] | 4b
8080 | Millie | 4b
8311 | Chip | 3a
8500 | [NAME] | 1b
Spreadsheet: daren_farmer__6600__egmnom-Mar
Sheet: DELV SUMMARY

 |  | ECT DELIVERED
 |  | MARCH 2000
 | #1338 | #1373 | #1511 | #1195 | #1258
 |  |  |  | TIER 1 | TIER 1
 | UNIT | LYONDELL | CLARK | HUNTSMAN | DONAHUE
DAYS | Aristech | CHANNELVIEW | REFINERY | EAST PLANT | LUFKIN | TOTAL
1 | 0 | 5000 | 10000 | 4000 | 2000
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
TOTAL
Spreadsheet: 113838d1309729334-help-with-lookup-functions-please-data
Sheet: Summary

 | Jan | Feb | Mar | Q1 | Apr | May | Jun | Q2 | Jul | Aug | Sep | Q3 | Oct | Nov | Dec | Q4 | TOTAL
Shop E
Shop P
Shop R
Shop F |  |  |  |  |  |  |  |  | 6
Shop X
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: DWARAKA SEC20

DWARAKA SEC20 |  |  |  |  |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE |  |  |  | DELHI GATE
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 10 KVA PP (3+1)x100-10 |  | 1
 | 100 A modules |  | 4
 | 1000 AH Battery |  | 2
Spreadsheet: 546572d1510097563-pivot-table-with-blanket-rows-pivot-table2
Sheet: Sheet2

Row Labels | Customer | Product | Description | Sum of Sales
1 | Amazon | Result |  | 6010.87
2 | Ebay | 122 | Fitting B | 122.94
3 | Walmart | Result |  | 1965.28
 |  | 0 | No Code
 |  | 121 | Fitting A | 65.7
 |  | 122 | Fitting B | 6412.74
 |  | 123 | Fitting C | 26.44
 |  | 129 | Fitting D | 313.36
 |  | 133 | Fitting E | 78.84
 |  | 134 | Fitting F | 30.7
 |  | 135 | Fitting G | 58.6
 |  | 138 | Fitting H | 989.77
Grand Total |  |  |  | 16075.24
Spreadsheet: 1ebae642-7618-44d9-8046-beeaf7f75a5e
Sheet: Current CCP Resource Allotment

Forward Capacity Market Annual Equivalent Planned Outage Hours Allotment Report
SR_FCMANNUALEPOH_<customer id>_<CP begin Date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Resource ID | Resource Name | [NAME] | Maximum Major Maintenance Period Allotment Hours | Major [NAME] | Maximum Capacity Commitment Period Allotment Hours | Major [NAME] EPOH Exemption | Available Capacity Commitment Period Allotment Hours
Number | String | String | Hours | Years | Hours | Hours | Hours
Spreadsheet: 861350d1709227974-looking-to-count-a-number-of-cells-with-changing-rows-and-column-availabilty-monitoring-demo
Sheet: Availability Report

[NAME] for: |  |  |  | 2024-02-29 00:00:00
 | Full Practice | Modified Practice | Medically Unavailable | Rehab |  |  |  |  |  |  | CB | S | LB | LEO | DL | WR | RB | TE | QB | OL | K, LS, P
 |  |  |  |  |  |  |  |  |  | Full Practice
 |  |  |  |  |  | Name |  |  |  | Modified Practice
 |  |  |  |  |  |  |  |  |  | Medically Unavailable
 |  |  |  | Athlete 28 |  | Athlete 72 |  |  |  | Rehab
 |  |  |  | Athlete 63 |  | Athlete 93
 |  |  |  | Athlete 66
 |  |  |  | Athlete 75
 |  |  |  | Athlete 77 |  |  |  |  |  |  | EXPECT RESULTS
 |  |  |  | Athlete 103 |  |  |  |  |  |  | CB | S | LB | LEO | DL | WR | RB | TE | QB | OL | K, LS, P
 |  |  |  | Athlete 104 |  |  |  |  |  | Full Practice | 9 | 8 | 8 | 5 | 16 | 12 | 6 | 7 | 5 | 12 | 5
 |  |  |  | Athlete 105 |  |  |  |  |  | Modified Practice | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1
 |  |  |  | Athlete 110 |  |  |  |  |  | Medically Unavailable | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  | Athlete 113 |  |  |  |  |  | Rehab | 0 | 1 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 7 | 0
 |  |  |  | Athlete 115
 |  |  |  | Athlete 117
Spreadsheet: 677341d1589310505-formula-to-duplicate-row-references-test
Sheet: Sheet1

Column1 | Attribute | Value
Cat | 170040 | 10
Cat | 544110 | -10
Dog | 170040 | 15
Dog | 544110 | -15
Cow | 170040 | 12
Cow | 544110 | -12
Spreadsheet: 111093d1307565924-if-sumproduct-combo-sample-budget
Sheet: Membership

 |  |  | Budgeted
 |  |  | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | Fiscal year 2012
Membership
 |  |  | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54
 |  |  | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059
 |  |  | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405
 |  |  | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total
Assumptions
% of Membership lost | 0.1 |  | Yes |  |  | Yes | Yes | Yes
Spreadsheet: 488954d1478913126-function-help-categorizing-copy-of-budgets
Sheet: Sheet2

Years | Months | Date: | Category: | Item: | Budget | Sum of Expenditure | Running Total of Buget Item | Running Total Budget Balance
2017 | Jan | 01-Jan | A3 | Transportation/Gas | 100 |  |  | 100
 |  |  | A4 | Clothing | 50 |  |  | 150
 |  |  | A5 | Entertainment | 50 |  |  | 200
 |  |  | A6 | Groceries | 125 |  |  | 325
 |  |  | A7 | Restaurant/Bars | 200 |  |  | 525
 |  |  | A8 | Alcohol | 45 |  |  | 570
 |  | 02-Jan | A3 | Gas |  | 45 | 55 | 501.45
 |  |  | A6 | Safeway |  | 23.55 | 101.45 | 546.45
 |  | 03-Jan | A8 | Beer |  | 18.36 | 26.64 | 483.09
 |  | 04-Jan | A3 | Gas |  | 18.5 | 36.5 | 966.04
 | Jan Total |  |  |  | 570 | 105.41 | 219.59
 | Feb | 01-Feb | A3 | Transportation/Gas | 100 |  | 136.5 | 564.59
 |  |  | A4 | Clothing | 50 |  | 100 | 614.59
 |  |  | A5 | Entertainment | 50 |  | 100 | 664.59
 |  |  | A6 | Groceries | 125 |  | 226.45 | 789.59
 |  |  | A7 | Restaurant/Bars | 200 |  | 400 | 989.59
 |  |  | A8 | Alcohol | 45 |  | 71.64 | 1034.59
 |  | 06-Feb | A3 | Gas |  | 55 | 81.5 | 979.59
 | Feb Total |  |  |  | 570 | 55 | 1116.09
Grand Total |  |  |  |  | 1140 | 160.41 | 1335.68
Spreadsheet: 40666d1239057452-how-to-do-multiple-if-and-or-statments-boston
Sheet: Overview

East | W | L | PCT | vs E | vs C | vs W | INT | HOME | ROAD | Total
Boston | 0 | 0 | #N/A | 0-0 | 0-0 | 0-0 | 0-0 | 0-0 | 0-0 | 0-0
Spreadsheet: 682105d1591903414-progress-status-formula-dude6571_formula2
Sheet: Sheet1

 |  | Clients | Type | Sn | Status |  |  | % of Completion of T | 0.5
 |  | A | T | Prod | Completed |  |  | % of Completion of P | 0
 |  | B | T | Prod | Completed |  |  | % of Completion of Prod | 0.5
 |  | C | T | Stag | Planned |  |  | % of Completion of Stag | 0
 |  | D | T | Stag | Not Started
 |  | E | P | Stag | Not Started
 |  | F | P | Stag | Not Started
 |  | D | P | Stag | Not Started
Spreadsheet: 875870d1722502819-quote-template-help-hole-template-9_57am
Sheet: Sheet1

(COMPLEXITY LEVEL →) |  | LEVEL 1 | LEVEL 2 | LEVEL 3
(BAND DESCRIPTION) | BAND | HOURS | HOURS | HOURS
1 TO 6 HOLES | A | 2.75 | 3 | 3.25
6 TO 12 HOLES | B | 2.25 | 2.5 | 2.75
12 TO 20 HOLES | C | 1.75 | 2 | 2.25
20 TO 30 HOLES | D | 1.25 | 1.5 | 1.75
30 TO 50 HOLES | E | 1 | 1.25 | 1.5
50 TO 100 HOLES | F | 0.75 | 1 | 1.25
HOURLY RATE | £20 PER HOUR
 |  |  |  |  | TOOL NUMBER | NUMBER OF HOLES | COMPLEXITY | TOTAL COST
 |  |  |  |  | ABC1234 | 27 | LEVEL 2 |  | SHOULD BE 27(NO OF HOLES)  x 1.5 (LEVEL FACTOR) x 20 (HOURLY RATE)
 |  |  |  |  | DEF5678 | 5 | LEVEL 3
 |  |  |  |  | HIJ91011 | 72 | LEVEL 1
Spreadsheet: 1902dbe6-20f5-4fb5-9eb6-0022b36fa214
Sheet: Sheet1

First Name | Last Name | Title | Organization | [NAME] | Phone
Willie | Amison | Advisor | Educational Opportunity Center, KU | [EMAIL]
Jan | [NAME] |  | Kansas Leadership Center, Wichita | [EMAIL]
[NAME] | [NAME] | Commissioner | KSDE | [EMAIL]
[NAME] | Doll | Superintendent | USD 497 - Lawrence
Mildred | Edwards | Executive Director | Kansas African American Affairs Commission | [EMAIL]
Adrienne | [NAME] | Executive Director | Kansas Hispanic & Latino American Affairs Commission | [EMAIL]
[NAME] | Henderson | President | Kansas Association of School Boards | [EMAIL]
Scott | Smith | Director | KSDE, [NAME], Standards and Assessments | [EMAIL]
[NAME] | Neuenswander | Deputy Commissioner | KSDE,  Learning Services Division | [EMAIL]
[NAME] | Rankin | Executive Director | Midwest Equity Assistance Center, KSU | [EMAIL]
[NAME] | Schodorf | Member | Kansas Senate | [EMAIL]
Idalia | [NAME] | Director, Teaching & Learning | Kansas National Education Association | [EMAIL]
Spreadsheet: 838930d1691522391-how-to-create-a-dynamic-date-dynamic-date
Sheet: Sheet1

 | The date is automatically update based on the Data in "Table B"
 |  | Table A |  |  |  | Table B
 |  |  |  |  |  | The data in this  table will be copied manually
 |  | Date | Sales |  |  | Date | Receipt | Product | Sales
 |  | 2023-01-01 00:00:00 |  |  |  | 2023-01-01 00:00:00 | 1 | iPhone | 980
 |  |  |  |  |  | 2023-01-01 00:00:00 | 1 | Apple Watch | 320
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2 | MacBook | 2200
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | iPad | 950
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Earpod | 40
 | The date is automatically update based on the date in "Table B"
 |  | Table A |  |  |  | Table B
 |  |  |  |  |  | Now update the sale data in 2-Jan-2023
 |  | Date | Sales |  |  | Date | Receipt | Product | Sales
 |  | 2023-01-01 00:00:00 |  |  |  | 2023-01-01 00:00:00 | 1 | iPhone | 980
 |  | 2023-01-02 00:00:00 |  |  |  | 2023-01-01 00:00:00 | 1 | Apple Watch | 320
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2 | MacBook | 2200
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | iPad | 950
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Earpod | 40
 |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Nokia | 150
 | The date in "2-Jan-2023" is automatically updated base on the Table B |  |  |  |  | 2023-01-02 00:00:00 | 4 | Earpod | 30
 |  |  |  |  |  | 2023-01-02 00:00:00 | 5 | iPhone | 850
 |  |  |  |  |  | 2023-01-02 00:00:00 | 6 | iPad | 750
 |  | Solution in Excel 2013/2017/2019/2021/365 (with Windows)
 |  |  | 4490
 |  | 2023-01-02 00:00:00 | 1780
 |  | Solution in Excel 365
 |  |  | 4490
 |  | 2023-01-02 00:00:00 | 1780
Spreadsheet: 22202d1210823348-why-do-i-get-inconsistent-results-from-vlookup-with-text-test-validation
Sheet: Sheet1

Treated
2x12x18cca | 1 |  |  | 2 x 12 x 12cca | 5.5
2x12x16cca | 1.5
2x12x14cca | 2
2 x 12 x 12cca | 2.5
2 x 12 x 10cca | 3
2 x 10 x 18cca | 3.5
2 x 10 x 16 cca | 4
2 x 10 x 14 cca | 4.5
2 x 10 x 12 cca | 5
2 x 10 x 10 cca | 5.5
2 x 8 x 18 cca | 6
2 x 8 x 16 cca | 6.5
2 x 8 x 14 cca | 7
2 x 8 x 12 cca | 7.5
2 x 8 x 10 cca | 8
2 x 6 x 18 cca | 8.5
2 x 6 x 16 cca | 9
2 x 6 x 14 cca | 9.5
2 x 6 x 12 cca | 10
2 x 6 x 10 cca | 10.5
2 x 6 x 8 cca | 11
2 x 4 x 18 cca | 11.5
2 x 4 x 16 cca | 12
2 x 4 x 14 cca | 12.5
2 x 4 x 12 cca | 13
2 x 4 x 10 cca | 13.5
2 x 4 x 8 cca | 14
1 x 4 x 10 cca | 14.5
1 x 4 x 8 cca | 15
Spreadsheet: 118543d1313753977-help-with-moving-data-on-criteria-tlgltest
Sheet: BPD

Last Name | First Name | Occp | Dept | Team | Shift | BPD | [NAME] | Interview | Math | Written
Arriaga | [NAME] | T103 | 1102 | 1302 | 2 |  | 0.7619047619047619 | 75 | 90 | 70
Babler | [NAME] | T203 | 5001 | 1201 | 1 |  | 1 | 80 | 100 | 100
Barger | [NAME] | T703 | 8302 | 2002 | 2 |  | 0.9230769230769231 | 80 | 100 | 90
 |  |  |  |  |  |  |  |  |  |  |  |  | failed math twice
 |  |  |  |  |  |  |  |  |  |  |  |  | failed math twice
 |  |  |  |  |  |  |  |  |  |  |  |  | failed math twice
 |  |  |  |  |  |  |  |  |  |  |  |  | Retest taken on 2/7/11
 |  |  |  |  |  |  |  |  |  |  |  |  | 6/16/11 30%
Spreadsheet: 822442d1679351434-sumproduct-of-every-nth-column-changing-every-9-columns-example-file-selecting-every-9th-column-tms
Sheet: Sheet1

Test Data copied from Row 1 to Row 8
Values to be included (every 9th, 6th and 3rd)
 |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  | 36 |  |  |  |  |  |  |  |  | 45
 |  |  |  |  | 6 |  |  |  |  |  | 12 |  |  |  |  |  | 18 |  |  |  |  |  | 24 |  |  |  |  |  | 30 |  |  |  |  |  | 36 |  |  |  |  |  | 42 |  |  |  |  |  | 48
 |  | 3 |  |  | 6 |  |  | 9 |  |  | 12 |  |  | 15 |  |  | 18 |  |  | 21 |  |  | 24 |  |  | 27 |  |  | 30 |  |  | 33 |  |  | 36 |  |  | 39 |  |  | 42 |  |  | 45 |  |  | 48 |  |  | 51
Sum |  | Values included
 |  |  | 18 | 27 | 36 | 45
 |  |  | 12 | 18 | 24 | 30 | 36 | 42 | 48
 |  |  | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 | 39 | 42 | 45 | 48 | 51
Sum |  | Values included from column AD
 |  |  | 45
 |  |  | 36 | 42 | 48
 |  |  | 33 | 36 | 39 | 42 | 45 | 48 | 51
Sum |  | Ranges adjusted to start from column AD
[NAME] (referring to data in row 1)
=SUMPRODUCT(     --(MOD(COLUMN($AD8:LM8)-COLUMN($AD8)+1,9)=0),     --($AD8:LM8>0),    -(ISFORMULA($AD8:LM8)),    $AD8:LM8)
Spreadsheet: andy_zipper__484__11_26_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 53 | 140 | 230 | 63.2 | 103.9 | 2.78 | 2001-11-26 13:50:00
 | HO F2 | 54 | 680 | 770 | 55.2 | 62.6 | 2 | 2001-11-26 13:50:00
 | HO G2 | 54 | 970 | 1060 | 54.7 | 59.8 | 1.94 | 2001-11-26 13:50:00
 | [NAME] | 54 | 1150 | 1250 | 54.1 | 58.9 | 1.92 | 2001-11-26 13:50:00
 | HO J2 | 53 | 1250 | 1400 | 52.6 | 59 | 1.86 | 2001-11-26 13:50:00
 | HO K2 | 53 | 1310 | 1450 | 49.3 | 54.7 | 1.73 | 2001-11-26 13:50:00
 | HO M2 | 53 | 1350 | 1500 | 46.3 | 51.5 | 1.63 | 2001-11-26 13:50:00
 | HO N2 | 54 | 1360 | 1500 | 42.7 | 47.2 | 1.53 | 2001-11-26 13:50:00
 | HO Q2 | 54 | 1370 | 1550 | 40.3 | 45.7 | 1.46 | 2001-11-26 13:50:00
 | HO U2 | 55 | 1370 | 1550 | 37.4 | 42.4 | 1.38 | 2001-11-26 13:50:00
 | [NAME] |  |  |  | 38.4 | 42.2 | 1.42 | 2001-11-15 14:53:00
 | HO X2 |  |  |  | 37.9 | 40.3 | 1.38 | 2001-11-15 14:53:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: michelle_lokay__26803__jul00pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary
Billing Month | Buyer | Purchase Order # | Contract | POI | Volume | Rate | Imputed Rate | Rate_Type Daily/Total | Invoice Amount
2000-07-01 00:00:00 | Reliant | 27060 | 26188 | 500621 | 1514 | 0.03 |  | D | 1362.6 | (Carryover April eom bal. of 1,514)
 | Duke Energy Trading | 27191 | 27108 | 500616 | 52136 | 0.03 |  | D | 2342.82
 | Duke Energy Trading | 27266 | 27108 | 500616 | 2755 | 0.03 |  | D | 165.3
 | PNM Gas Services | 27267 | 26572 | 500617 | 15000 | 0.03 |  | D | 1050
 | USGT | 27268 | 25556 | 500617 | 12218 | 0.03 |  | D | 733.08
 | USGT | 27268 | 25556 | 500622 | 30892 | 0.03 |  | D | 1541.94
 | Sempra Energy Trading | 27255 | 26221 | 500615 | 6000 | 0.03 |  | D | 3780 | (Carryover June bal of 6,000)
 |  |  |  | TOTAL
Spreadsheet: 741079d1626799138-need-help-calculating-averages-based-on-specific-text-and-partial-text-example-3-
Sheet: Pivot Table

Department | Termination Reason | Count of Termination Reason
Customer Solutions | Involuntary - Performance | 0.1333333333333333
 | Voluntary - Grad school | 0.2
 | Voluntary - Higher Compensation | 0.1333333333333333
 | Voluntary - Increase in responsibility/title | 0.06666666666666667
 | Voluntary - Other | 0.4666666666666667
Customer Solutions Total |  | 0.6818181818181818
Engineering | Voluntary - Higher Compensation | 0.25
 | Voluntary - Increase in responsibility/title | 0.5
 | Voluntary - Other | 0.25
Engineering Total |  | 0.1818181818181818
Marketing | Voluntary - Grad school | 0.3333333333333333
 | Voluntary - Higher Compensation | 0.3333333333333333
 | Voluntary - Other | 0.3333333333333333
Marketing Total |  | 0.1363636363636364
Grand Total |  | 1
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Ahmed Al Rumaih

Contract Terms (*)
 |  | Description |  |  |  |  | Commission
 |  | Procedures (after deducting consumables) |  |  |  |  | 0.5
 |  | Consumables
 |  | Consumables capped at 15%, anything above will be deducted fully
Doctor Calculation
 |  |  | 2023-12-01 00:00:00 | 2024-01-24 00:00:00 | 2024-02-24 00:00:00 | 2024-03-24 00:00:00 | Dec 23 to April 24
 |  | Doctor Revenue | 6500 | 3000 | 2400 | 16300 | 52499.7
 |  | Consumables |  |  |  | 7874.954999999999 | 7874.954999999999 |  |  |  | 0.15
 |  | Net Doctor Revenue
 |  | Amount to be Paid
 |  | Less consumables above 15% | 0 | 0 | 0
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  |  |  |  | CFO: | .......................
Spreadsheet: 871277d1717667091-returning-a-value-where-a-condition-ends-get-last-header-in-block-1-rs-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected values:
 | Header | Input | Block # |  | End of Block |  | Block # | [NAME] | [NAME] | Col. Start | Col. End | No. Cols.
 | Image |  |  |  |  |  | 2 | P&D status |  | 7
 | Team Freeze | Y | 1 |  |  |  | 3 | Class |  | 20
 | [NAME] | Y |  |  |  |  | 4 | Code Sub-class |  | 22
 | Hits released | Y
 | Total Hits
 | P&D status | Y | 2
 | Sourcing status | Y
 | Merchant status | Y
 | Planning status | Y
 | General comments | Y
 | P&D comments | Y
 | Sourcing comments | Y
 | Merchant comments | Y
 | Planning comments | Y
 | Alloc. comments | Y
 | USIM | Y
 | Style | Y
 | Colour
 | Class | Y | 3
 | Class helper
 | Code Sub-class | Y | 4
 | Code
 | Class code
Spreadsheet: 680001d1590736859-count-second-number-after-punctuation-full-stop-comma-book2
Sheet: Sheet1

3
2.45
2.9
4
3.8
3.1
5.01
1.12
0.88
1.43
1.56
3.81
9.35
2.54
3.9
2.61
4.27
4.12
5.11
0.93
2.4
1.26
3.26
4.61
1.67
1.75
4.21
4.4
1.63
5.86
5.75
4.36
2.026
4.09
1.68
1.3
4.93
6.53
2.08
1.31
2.27
1.6
3.05
2.76
2.65
2.66
2.99
2.99
2.61
6.91
5.4
2.36
5.65
1.7
3.59
4.21
1.97
4.35
1.12
2.558
6.02
1.11
1.045
2.11
1.77
5
8.74
11.3
4.77
1.68
4.6
1.39
1.28
7.15
7.01
2.65
1.101
1.62
2.72
1.65
1.93
0.5595
2.23
4.37
3.63
8.33
2.5
1.75
2.52
2.19
2.2
2.33
4
4.87
2.76
12.1
1.57
1.5
8.62
2.77
1.62
0.99
4.06
0.98
1.19
2.5
1.8
1.87
1.6
1.3
1.6
2.05
2
5.64
8.2
4.06
2.48
2.83
2.76
4.19
1.63
4.29
3.52
2.39
1.63
1.82
1.59
1.63
0.886
1.95
2.16
5.61
2.8
1.25
1.63
0.98
4.68
4.9
5.16
7.83
2.32
1.05
5.46
9.85
3.56
2.57
7.38
1.52
2.11
2
2.21
2.05
3.57
2.7
1.61
6.76
3.72
4.41
13.18
1.79
1.43
0.99
2.38
2.93
9.96
8.6
0.921
1.35
2.01
0.85
1.15
2.5
2.91
1.1
4.01
4.02
2.87
2.4
2.23
6.78
5.61
2.62
2.69
1.86
3.92
6.51
2.93
2.53
4.633
1.65
1.77
1.56
0.74
4
5.2
2.22
3.5
3.25
2.97
1.63
10.4
4.51
6.08
6.51
2.72
3.49
4.22
3.5
0.861
3.58
1.58
0.9661
2.76
4.2
2.26
2.05
1.54
1.97
1.29
1.19
3.36
2.78
3.06
6.56
11.43
1.42