tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 166837d1341831358-excel-2007-formula-need-few-tweaks-to-handle-blanks-properly-book1
Sheet: Example

 | Exanple : NO  BLANKS |  |  |  |  |  |  | Exanple : BLANKS |  |  |  |  | CORRECT EXPECTED RESULTS
 | Contruct Number | Results | Tot | P | L |  |  | Contruct Number | Results | Tot | P | L | P | L
 | 100 | 10000 | 1 |  |  |  |  | 100 |  | 1 |  |  | 0 | 0
 | 100 | -9000 | 1 |  |  |  |  | 100 | -9000 | 2 |  |  | 0 | 1
 | 100 | 10000 | 1 |  |  |  |  | 100 | 10000 | 3 |  |  | 1 | 1
 | 101 | -12000 | 2 |  |  |  |  | 101 | -12000 | 4 |  |  | 1 | 2
 | 102 | 12000 | 3 |  |  |  |  | 102 |  | 5 |  |  | 1 | 2
 | 103 | 11000 | 4 |  |  |  |  | 103 | 11000 | 6 |  |  | 2 | 2
 | 104 | -9000 | 5 |  |  |  |  | 104 | -9000 | 7 |  |  | 2 | 3
 | 105 | 10000 | 6 |  |  |  |  | 105 | 10000 | 8 |  |  | 3 | 3
 | 105 | 10000 | 6 |  |  |  |  | 105 | 10000 | 9 |  |  | 4 | 3
 | 106 | 12000 | 7 |  |  |  |  | 106 | 12000 | 10 |  |  | 5 | 3
 | 107 | -9000 | 8 |  |  |  |  | 107 | -9000 | 11 |  |  | 5 | 4
 | 108 | 10000 | 9 |  |  |  |  | 108 |  | 12 |  |  | 5 | 4
 | 109 | 10000 | 10 |  |  |  |  | 109 | 10000 | 13 |  |  | 6 | 4
 | 110 | 12000 | 11 |  |  |  |  | 110 | 12000 | 14 |  |  | 7 | 4
 | 111 | -12000 | 12 |  |  |  |  | 111 | -12000 | 15 |  |  | 7 | 5
 | 112 | 12000 | 13 |  |  |  |  | 112 | 12000 | 16 |  |  | 8 | 5
 | 113 | 11000 | 14 |  |  |  |  | 113 | 11000 | 17 |  |  | 9 | 5
 | 114 | -9000 | 15 |  |  |  |  | 114 | -9000 | 18 |  |  | 9 | 6
 | 115 | -12000 | 16 |  |  |  |  | 115 | -12000 | 19 |  |  | 9 | 7
 | 116 | 12000 | 17 |  |  |  |  | 116 | 12000 | 20 |  |  | 10 | 7
 | 117 | 11000 | 18 |  |  |  |  | 117 | 11000 | 21 |  |  | 11 | 7
 | 118 | -9000 | 19 |  |  |  |  | 118 | -9000 | 22 |  |  | 11 | 8
 | 119 | -9000 | 20 |  |  |  |  | 119 | -9000 | 23 |  |  | 11 | 9
 | 120 | -9000 | 21 |  |  |  |  | 120 | -9000 | 24 |  |  | 11 | 10
 | 121 | -12000 | 22 |  |  |  |  | 121 | -12000 | 25 |  |  | 11 | 11
 | 122 | 12000 | 23 |  |  |  |  | 122 | 12000 | 26 |  |  | 12 | 11
 | 123 | -12000 | 24 |  |  |  |  | 123 | -12000 | 27 |  |  | 12 | 12
 | 124 | 12000 | 25 |  |  |  |  | 124 | 12000 | 28 |  |  | 13 | 12
 | 125 | -12000 | 26 |  |  |  |  | 125 | -12000 | 29 |  |  | 13 | 13
 | 126 | 12000 | 27 |  |  |  |  | 126 | 12000 | 30 |  |  | 14 | 13
 | 127 | -12000 | 28 |  |  |  |  | 127 | -12000 | 31 |  |  | 14 | 14
 | 128 | 12000 | 29 |  |  |  |  | 128 | 12000 | 32 |  |  | 15 | 14
 | 129 | 12000 | 30 |  |  |  |  | 129 | 12000 | 33 |  |  | 16 | 14
Spreadsheet: 817254d1676079484-negative-amount-and-summation-issue-2023-commission-for-designers-sample
Sheet: Abby

ABBY | January | February | March | April | May | June | July | August | September | October | November | December |  | Sales | Bonus | Class
Sales Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Subtotal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Damage and Loss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
D&L Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Sub Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Open Inv - 120 D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Expectation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | ` |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | `
Spreadsheet: 211c2f10-5c77-44ef-964a-ea0bc361f970
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/06/2010 | Wrestling | at Liberty (College Park, MD) | 12:00 AM | W, 24-12
11/06/2010 | Wrestling | at Maryland (College Park, MD) | 12:00 AM | L, 13-27
11/06/2010 | Wrestling | at Johns Hopkins (College Park, MD) | 12:00 AM | W, 38-3
11/13/2010 | Wrestling | at Washington and Jefferson Open | 12:00 AM | Results
11/20/2010 | Wrestling | at Navy Classic (Annapolis, MD) | 12:00 AM | Results
11/21/2010 | Wrestling | at [NAME] (Vestal, NY) | 12:00 AM | W, 41-0
11/21/2010 | Wrestling | at No. 24 Rutgers (Vestal, NY) | 12:00 AM | L, 14-25
11/21/2010 | Wrestling | at No. 6 Penn State (Vestal, NY) | 12:00 AM | L, 3-40
12/03/2010 | Wrestling | at Cliff [NAME] Vegas Invitational (Las Vegas, NV) | 12:00 AM | Results
12/04/2010 | Wrestling | at Cliff [NAME] Vegas Invitational (Las Vegas, NV) | 12:00 AM | Results
12/19/2010 | Wrestling | at Reno Tournament of Champions (Reno, NV) | 12:00 AM | Results
01/07/2011 | Wrestling | at No. 8 Illinois | 12:00 AM | W, 18-15
01/14/2011 | Wrestling | MICHIGAN STATE | 12:00 AM | L, 18-21
01/21/2011 | Wrestling | at Bloomsburg | 12:00 AM | W, 19-12
01/22/2011 | Wrestling | at Clarion | 12:00 AM | W, 39-4
01/29/2011 | Wrestling | at Lock Haven | 12:00 AM | W, 33-5
02/04/2011 | Wrestling | at No. 20 Pittsburgh | 12:00 AM | L, 14-21
02/12/2011 | Wrestling | OHIO | 12:00 AM | W, 23-14
02/18/2011 | Wrestling | No. 20 EDINBORO | 12:00 AM | L, 15-22
02/19/2011 | Wrestling | CLEVELAND STATE | 12:00 AM | W, 46-0
03/06/2011 | Wrestling | EWL Championships (Bloomsburg, Pa.) | 12:00 AM | 2nd Place
03/15/2011 | Wrestling | [NAME] (Philadelphia) | 12:00 AM | All Day
03/16/2011 | Wrestling | [NAME] (Philadelphia) | 12:00 AM | All Day
03/17/2011 | Wrestling | [NAME] (Philadelphia) | 12:00 AM | All Day
Spreadsheet: john_lavorato__16546__pdxaa1
Sheet: Associates

 |  | Knowledge
 |  | High |  | Low
 | High | [NAME] | Gray Calvert | [NAME]
 |  |  | [NAME] | [NAME]
Aptitude
 |  |  | [NAME] |  | [NAME]
 | Low
1 |  | [NAME] | EES Volume Management
2 |  | Gray Calvert | Origination
 |  | [NAME] | Origination
 |  | [NAME] | Origination
3 |  | [NAME] | Origination
 |  | [NAME] | EES Project Phoenix
4 |  | [NAME] | Structuring
TBD |  | [NAME] | EES Utility Risk Management
Spreadsheet: sally_beck__33713__MgmtSum-Q2-0623 version a
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-06-01 00:00:00 | 2ND QUARTER 2000 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
[NAME] | Gas Trading |  |  |  |  |  | FTE's over by 20, Increased special pays, Franchise taxes paid in April
ASST_TRD | Texas Desk |  | 656
[NAME] | Power Trading |  |  |  |  |  | Headcount is over Plan by 28FTE's .  Outside services are also over plan
IR_FX | Financial Drift |  | 774 |  |  |  | London & Australia Expenses are running over plan
ECT_INV_IRFX | Financial Trading
trd_mkt | Canada Trading |  | 1147
COAL | Coal Trading |  | 1549 |  |  |  | London direct and allocated expenses are over plan
WEATHER | GRM -  Weather |  | 721
SO2 | Emissions (Coal) |  | 52
 | Total Trading & Risk Management
E_ORG | East Midstream |  |  |  |  |  | Turbines
W_ORIG | West Midstream |  |  |  |  |  | Turbines
DWNSTRM_IND_ORIG | Industrial Downstream |  | 4610 |  |  |  | Downstream is aprox. 22 FTE's Under plan
N_BS_DEV | Generation Investments |  | 2124 |  |  |  | Special Pay in April & May, & Turbines
 | Coal Origination & Finance |  | 1549 |  |  |  | London direct and allocated expenses are over plan
fin | Canada Origination & Finance
ASST_ORIG | Upstream Originations |  | 3746
HPL | HPL |  | 2275 | 2595
LRC | LRC |  | 65 | 96
INSURANCE | GRM - New Products |  | 1064
MEXICO | Mexico |  | 1616
 | Total Origination
EQUITY | Principal Investing |  | 459
PROD_FIN | Energy Capital Resources |  | 1486 |  |  |  | Special Pays in May
ASST_MGT_AND_RESTRCT | Special Assets |  | 502
CTG_ASSETS | CTG Assets |  | 10
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group |  | 6128 |  |  |  | Headcount is 31 FTE's over plan
OF_CHAIR | Office of the Chairman |  |  |  |  |  | Canada Severance & Ft James write off
 | Total Commercial
GROUP | Group |  |  |  |  |  | Offset in allocated expenses & Bonus Accrual
 | Enron Net Works |  | 13698 | 13698
TREASURY_INT | Other Interest Related Charges |  | 22625 |  |  |  | Did not execute a prepay
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Genco |  | 9900 | 8789 |  |  | More Accurate 2000 [NAME]'s numbers and Utilities & Labor over budgeted.
 | HPL |  | 34656 | 33926
 | ENA Upstream Assets |  | 6741 | 3072 |  |  | Increase due to $1MM unaccounted gas write-off from PY and add'l PY write-offs.
Spreadsheet: 30535d1226055078-removing-lost-figures-from-my-summary-seet-2009-pipeline-test
Sheet: Summary

Summary Of 2009 Events Key Opportunities by Area, Tier and Status
 |  | 1 |  |  | 0.95 |  |  | 0.75 |  |  | 0.5 |  |  | 0.25 |  | Grand Total
Sum of Total | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3
Area | € | € | € | € | € | € | € | € | € | € | € | € | € | € | €
Central | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31900 | 229680 | 32744.712 | 25535.312 | 0 | 0 | 0 | 0 | 319860.024
Scotland | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 683729.2880000001 | 37893.372 | 0 | 0 | 0 | 0 | 0 | 721622.66
South East | 6380 | 0 | 0 | 0 | 57420 | 0 | 0 | 38280 | 306240 | 51276.06 | 185743.492 | 255200 | 0 | 0 | 0 | 900539.552
South West | 0 | 0 | 0 | 0 | 0 | 0 | 19140 | 0 | 865772.38 | 21083.348 | 31193.096 | 68904 | 0 | 44660 | 0 | 1050752.824
Grand Total | 6380 | 0 | 0 | 0 | 57420 | 0 | 19140 | 70180 | 2085421.668 | 142997.492 | 242471.9 | 324104 | 0 | 44660 | 0 | 2992775.06
Totals | 6380 |  |  | 57420 |  |  | 2174741.668 |  |  | 709573.392 |  |  | 44660
 |  |  | Prospect Totals
Sum of Total | 2009 Budget | 2009 orders | [NAME] | [NAME] | [NAME] | Prospect Total | 2008 Gap |  |  |  | Sum of Total |  | Lost
Area | € | € | € | € | € | € | € |  |  |  | Area | Tier 1 | [NAME] | Tier 3
Central | 1476487 | 0 | 32744.712 | 57435.31200000001 | 229680 | 319860.024 |  |  |  |  | Central | € | € | €
Scotland | 308903 | 0 | 37893.372 | 0 | 683729.2880000001 | 721622.66 |  |  |  |  | Scotland
South East | 2194127 | 6380 | 51276.06 | 281443.492 | 561440 | 894159.5519999999 |  |  |  |  | South East
South West | 1584308 | 0 | 40223.348 | 75853.096 | 934676.38 | 1050752.824 |  |  |  |  | South West
Grand Total | 5563825 | 6380 | 162137.492 | 414731.9 | 2409525.668 | 2986395.06 |  |  |  |  | Grand Total | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  | 0.95 | 0.75 | 0.5 | 0.25
 | Orders |  |  | Prospects
 | Tier 1 | [NAME] | Tier 3 | Tier 1 | [NAME] | Tier 3
Power Logistics | 0 | 0 | 0 | #N/A
PGA European Tour
Spreadsheet: 89985d1289743763-conditional-format-0-1-and-0-1-cicihk_cf_quotation-1-
Sheet: Sheet1

PROPER RANGE | S1
< 0.1 mg/L | 0.05
< 0.2 mg/L | 0.3
< 0.1 mg/L | < 0.1
< 0.2 mg/L | < 0.2
< 0.2 mg/L | 0.2
Option 1
PROPER RANGE | S1
< 0.1 mg/L | 0.05
< 0.2 mg/L | 0.3
< 0.1 mg/L | < 0.1
< 0.2 mg/L | < 0.2
< 0.2 mg/L | 0.2
Option 2
PROPER RANGE | S1
< 0.1 mg/L | 0.05
< 0.2 mg/L | 0.3
< 0.1 mg/L | < 0.1
< 0.2 mg/L | < 0.2
< 0.2 mg/L | 0.2
Option 3
PROPER RANGE | S1
< 0.1 mg/L | 0.05
< 0.2 mg/L | 0.3
< 0.1 mg/L | < 0.1
< 0.2 mg/L | < 0.2
< 0.2 mg/L | 0.2
Spreadsheet: 80736d1280940326-formula-that-automatically-uses-the-last-cell-in-a-row-copy-of-golfpressespayment
Sheet: Sheet1

Downs
Score | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7 | Hole 8 | Hole 9
Player1 | 4 | 4 | 5 | 3 | 4 | 4 | 5 | 4 | 3
Player2 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 4 | 3
$5 2-Downs | -5 | -5 | -5 | 0 | -5 | -5 | -10 | -10 | -10
Player 1 | -1 | -1 | -2 | -1 | -2 | -2 | -3 | -3 | -3
 |  |  | 0 | 1 | 0 | 0 | -1 | -1 | -1
$5 1-Downs | -5 | -5 | -10 | 0 | -20 | -20 | -25 | -25 | -25
Player 1 | -1 | -1 | -2 | -1 | -2 | -2 | -3 | -3 | -3
 | 0 | 0 | -1 | 0 | -1 | -1 | -2 | -2 | -2
 |  |  | 0 | 1 | -1 | -1 | -2 | -2 | -2
 |  |  |  | 0 | -1 | -1 | -2 | -2 | -2
 |  |  |  |  | 0 | 0 | -1 | -1 | -1
 |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 761862d1641268240-resource-scheduler-help-formula-that-will-place-7-week-bar-on-dates-based-on-source-date-resource-map
Sheet: Sheet1

 |  |  |  |  |  | I need resources to arrives 7 weeks before this date | Resource arrival date
 | Site | stations | Location | material arrives | FR | FULL SHIP | onsite 7-Weeks before F/S | SAT x2 weeks | Resources Needed | man-hours | Weeks | Weeks rounded | Total   Resource weeks | Resource costs | 2022-01-24 00:00:00
example of what I need formula to do. I'd like to autopopulate the 7 week period and then the subsequest 2 week period with color coding. | Site | 26 |  |  |  | 2022-03-13 00:00:00 |  |  |  |  |  |  | 9
 | Site | 34 |  |  |  | 2022-03-27 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-04-27 00:00:00 |  |  |  |  |  |  | 9
 | Site | 24 |  |  |  | 2022-05-01 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-05-18 00:00:00 |  |  |  |  |  |  | 9
 | Site | 34 |  |  |  | 2022-05-22 00:00:00 |  |  |  |  |  |  | 9
 | Site | 24 |  |  |  | 2022-06-26 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-06-29 00:00:00 |  |  |  |  |  |  | 9
 | Site | 34 |  |  |  | 2022-07-10 00:00:00 |  |  |  |  |  |  | 9
 | Site | 24 |  |  |  | 2022-07-10 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-08-17 00:00:00 |  |  |  |  |  |  | 9
 | Site | 33 |  |  |  | 2022-08-21 00:00:00 |  |  |  |  |  |  | 9
 | Site | 40 |  |  |  | 2022-08-24 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-08-31 00:00:00 |  |  |  |  |  |  | 9
 | Site | 33 |  |  |  | 2022-09-04 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-09-14 00:00:00 |  |  |  |  |  |  | 9
 | Site | 33 |  |  |  | 2022-09-25 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-09-28 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-09-28 00:00:00 |  |  |  |  |  |  | 9
 | Site | 24 |  |  |  | 2022-10-02 00:00:00 |  |  |  |  |  |  | 9
 | Site | 20 |  |  |  | 2022-10-05 00:00:00 |  |  |  |  |  |  | 9
 | Site | 24 |  |  |  | 2022-10-09 00:00:00 |  |  |  |  |  |  | 9
 | Site | 28 |  |  |  | 2022-10-16 00:00:00 |  |  |  |  |  |  | 9
 | Site | 28 |  |  |  | 2022-10-23 00:00:00 |  |  |  |  |  |  | 9
 | Site | 24 |  |  |  | 2022-12-11 00:00:00 |  |  |  |  |  |  | 9
Spreadsheet: 677846d1589553616-group-and-transpose-data-ors-ancestor-id-with-rating-may-15-2020-1-
Sheet: ORS Ancestor ID with Rating

client_id | rev_timein | answer |  |  |  | 1040 | 1083 | 1089 | 1145 | 1170 | 1192 | 1235 | 1244 | 1267 | 1308 | 1311 | 1330 | 1339 | 1361 | 0
1040 | 2020-04-08 08:59:00 | 30
1083 | 2020-02-26 10:30:00 | 20 |  |  | 2020-02-21 15:00:00
1083 | 2020-03-04 10:30:00 | 20 |  |  | 2020-02-25 11:15:00
1083 | 2020-03-30 14:00:00 | 19 |  |  | 2020-02-26 10:30:00
1083 | 2020-04-27 14:00:00 | 21 |  |  | 2020-03-02 11:32:00
1083 | 2020-05-11 13:00:00 | 29 |  |  | 2020-03-04 10:30:00
1089 | 2020-03-30 15:00:00 | 28 |  |  | 2020-03-05 12:00:00
1089 | 2020-04-30 14:00:00 | 28 |  |  | 2020-03-06 12:00:00
1145 | 2020-03-11 14:35:00 | 14 |  |  | 2020-03-09 14:00:00
1145 | 2020-04-08 14:02:00 | 14 |  |  | 2020-03-11 14:35:00
1145 | 2020-04-24 13:05:00 | 15 |  |  | 2020-03-13 10:01:00
1170 | 2020-03-27 09:50:00 | 30 |  |  | 2020-03-13 12:26:00
1170 | 2020-04-22 13:12:00 | 32 |  |  | 2020-03-13 13:00:00
1192 | 2020-03-25 11:00:00 | 35 |  |  | 2020-03-20 15:04:00
1192 | 2020-03-06 12:00:00 | 31 |  |  | 2020-03-25 11:00:00
1192 | 2020-04-16 12:00:00 | 25 |  |  | 2020-03-27 09:50:00
1235 | 2020-03-13 10:01:00 | 20 |  |  | 2020-03-30 10:08:00
1244 | 2020-04-21 13:00:00 | 23 |  |  | 2020-03-30 14:00:00
1244 | 2020-05-08 08:30:00 | 17 |  |  | 2020-03-30 15:00:00
1267 | 2020-02-21 15:00:00 | 20 |  |  | 2020-03-31 14:00:00
1308 | 2020-03-20 15:04:00 | 33 |  |  | 2020-04-02 16:30:00
1311 | 2020-02-25 11:15:00 | 27 |  |  | 2020-04-08 08:59:00
1311 | 2020-03-05 12:00:00 | 30 |  |  | 2020-04-08 14:02:00
1311 | 2020-03-09 14:00:00 | 31 |  |  | 2020-04-14 09:30:00
1311 | 2020-03-13 13:00:00 | 32 |  |  | 2020-04-16 12:00:00
1311 | 2020-04-02 16:30:00 | 23 |  |  | 2020-04-21 13:00:00
1311 | 2020-04-22 14:30:00 | 22 |  |  | 2020-04-22 13:12:00
1311 | 2020-04-29 14:30:00 | 24 |  |  | 2020-04-22 14:30:00
1330 | 2020-02-21 11:48:00 | 34 |  |  | 2020-04-24 13:05:00
1330 | 2020-03-02 11:32:00 | 28 |  |  | 2020-04-27 09:30:00
1330 | 2020-03-13 12:26:00 | 30 |  |  | 2020-04-27 14:00:00
1339 | 2020-03-30 10:08:00 | 40 |  |  | 2020-04-29 14:30:00
1361 | 2020-03-31 14:00:00 | 25 |  |  | 2020-04-30 14:00:00
1361 | 2020-04-14 09:30:00 | 20 |  |  | 2020-05-08 08:30:00
1361 | 2020-04-27 09:30:00 | 15 |  |  | 2020-05-11 13:00:00
1361 | 2020-05-12 09:30:00 | 19 |  |  | 2020-05-12 09:30:00
Spreadsheet: 356949d1415256251-countifs-and-sumifs-not-grabbing-negative-values-help1
Sheet: Sheet1

[NAME]
Table 1
Year | Month | Day | High Temp | Low Temp | PCPN | Snow | SD
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913
1914
1915
1916
Table 2
Year | Month | Day | High Temp | Low Temp | PCPN | Snow | SD
1903 | M | M | M | M | M | M | M | M
1904 | M | M | M | M | M | M | M | M
1905 | M | M | M | M | M | M | M | M
1906 | M | M | M | M | M | M | M | M
1907 | M | M | M | M | M | M | M | M
1908 | M | M | M | M | M | M | M | M
1909 | M | M | M | M | M | M | M | M
1910 | 1 | 19 | 22 | 2 | 0 | 0 | 0 | [NAME]
1911 | 1 | 18 | 33 | 0 | 0 | 0 | 0 | [NAME]
1912 | 1 | 16 | 18 | -4 | 0 | 0 | 0 | [NAME]
1913 | 1 | 15 | 15 | 5 | T | 0 | 0 | [NAME]
1914 | 1 | 21 | 33 | 18 | 1.08 | 0 | 0 | [NAME]
1915 | 1 | 20 | 14 | 2 | 0 | 0 | 0 | [NAME]
1916 | 1 | 18 | 19 | -3 | 0 | 0 | 0 | [NAME]
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: CJUS

Old course number | New course number
CJUS-390 | CJUS-3090
CJUS-410 | CJUS-3100
CJUS-411 | CJUS-4411
CJUS-412 | CJUS-4120
CJUS-413 | CJUS-4130
CJUS-414 | CJUS-4140
CJUS-415 | CJUS-4415
CJUS-420 | CJUS-3200
CJUS-421 | [NAME]
CJUS-422 | CJUS-4220
CJUS-423 | CJUS-4230
CJUS-430 | CJUS-3300
CJUS-435 | CJUS-4350
CJUS-436 | CJUS-4360
CJUS-437 | CJUS-4361
CJUS-438 | CJUS-4380
CJUS-440 | CJUS-4400
CJUS-445 | CJUS-4545
CJUS-450 | CJUS-4500
CJUS-451 | CJUS-4610
CJUS-452 | CJUS-4620
CJUS-453 | CJUS-3530
CJUS-454 | CJUS-4640
CJUS-455 | CJUS-3550
CJUS-456 | CJUS-4660
CJUS-460 | CJUS-3600
CJUS-465 | CJUS-4565
CJUS-470 | CJUS-4700
CJUS-475 | CJUS-4750
CJUS-477 | CJUS-4770
CJUS-480 | CJUS-4800
CJUS-490 | CJUS-4990
CJUS-510 | CJUS-5500
CJUS-516 | CJUS-4616
CJUS-520 | CJUS-4520
CJUS-530 | CJUS-5300
CJUS-554 | CJUS-5540
CJUS-601 | [NAME]
CJUS-613 | CJUS-6130
CJUS-615 | CJUS-6150
CJUS-651 | CJUS-6510
CJUS-702 | CJUS-7020
CJUS-703 | CJUS-7030
CJUS-704 | CJUS-7040
CJUS-711 | CJUS-7110
CJUS-721 | CJUS-7210
CJUS-722 | CJUS-7220
CJUS-723 | CJUS-7230
CJUS-724 | CJUS-7240
CJUS-743 | CJUS-7430
CJUS-810 | CJUS-8100
CJUS-817 | CJUS-8170
CJUS-820 | CJUS-8200
CJUS-821 | CJUS-8210
CJUS-822 | CJUS-8220
CJUS-828 | CJUS-8280
CJUS-830 | CJUS-8300
CJUS-837 | [NAME]
CJUS-840 | [NAME]
CJUS-870 | CJUS-8700
CJUS-880 | CJUS-8800
CJUS-888 | [NAME]
CJUS-889 | CJUS-8891
CJUS-890 | CJUS-8990
Spreadsheet: 797709d1664083902-dynamic-sheet-references-and-aggregation-coop
Sheet: Maps-Coms

Commanders | Own | % | Part | % | Maps | # | % |  | Total games
Raynor |  |  |  |  | Chain of Ascension
Kerrigan |  |  |  |  | Cradle of Death
Artanis |  |  |  |  | Dead of Night
Swann |  |  |  |  | Lock & Load
Zagara |  |  |  |  | Malwarfare
Vorazun |  |  |  |  | Miner Evacuation
Karax |  |  |  |  | Mist Opportunities
[NAME] |  |  |  |  | Oblivion Express
Alarak |  |  |  |  | Part and Parcel
Nova |  |  |  |  | Rifts to Korhal
Stukov |  |  |  |  | Scythe of Amon
Fenix |  |  |  |  | Temple of the Past
Dehaka |  |  |  |  | The Vermillion Problem
Horner |  |  |  |  | Void Launch
Tychus |  |  |  |  | [NAME]
Zeratul
Stetmann
Mengsk
Spreadsheet: 878716d1725975579-how-many-times-the-brand-is-contained-and-how-many-units-rosenirs-car-test-pivot-table-2007-aligw
Sheet: Лист1

 | Car | Number
 | BMW | 1 |  |  |  |  |  |  | Row Labels | Sum of general for  the brand
 | Audi | 3 |  |  |  |  |  |  | Audi | 5
 | BMW | 1 |  |  |  |  |  |  | BMW | 1
 | Ford | 2 |  |  |  |  |  |  | Ford | 2
 | Audi | 2 |  |  |  |  |  |  | Opel | 0
 |  |  |  |  |  |  |  |  | Peogeot | 0
 |  |  |  |  |  |  |  |  | Grand Total | 8
 | Car | how many  times the brand  is there | general for  the brand |  | Car | how many  times the brand  is there
Total | Audi |  | 5 |  | Audi | 5
 | BMW |  | 1 |  | BMW | 1
 | Opel |  | 0 |  | Ford | 2
 | Ford |  | 2
 | Peogeot |  | 0
Spreadsheet: 711541d1609776014-data-matching-formula-how-many-data-are-matched-matching-count
Sheet: Sheet1

Name | Data 1 | Data 2 | Data 3 | Data 4 | Matching Count | Answer
1 | [PHONE] |  |  |  |  | 0
 | 277? | 3 |  |  |  | 0
 | DN |  |  | DN |  | 2
 | 100 BROWN ST | 100 BROWN ST | ?ENTER CHEST | 100 BROWN ST |  | 3
 | CHESTERTOWN | CHESTERTOWN | CALLAHAN MD CHESTERTOWN | CHESTERTOWN |  | 3
 | ????? | 100 BROWN ST | 100 BROWN ST | 100 BROWN ST |  | 3
 | 44400062600 | 44400062600 |  | 44400062600 |  | 3
 | 44400062600 | 44400062600 | 44400062600 | 44400062600 |  | 4
 | ELLIOTT TERESA C | ELLIOTT TERESA C | ELLIOTT TERESA C | ELLIOTT TERESA C |  | 4
Spreadsheet: 136081d1326397388-large-drop-down-list-validation
Sheet: ME List

ME Number | ItemNumber | Properties complete | Description | Description2 | PrimaryVendorNumber
ME5400 | RLN-100500 |  | Amlock - 2150 lb hold force | RLN-100500 Amlock - 2150 lb hold force | AME
ME5401 | RLN-100325 |  | Amlock - 950 lb hold force | RLN-100325 Amlock - 950 lb hold force | AME
ME2006 | IIS205 |  | 22[NAME] range unshielded prox 30mm dia | IIS205 22[NAME] range unshielded prox 30mm dia | EFECTOR
ME2007 | E20870 |  | Swivel Bracket - Standard prox | E20870 [NAME] prox | EFECTOR
ME3000 | F3SJ-A0620P30 | X | F3SJ-A Safety Light Curtain- 30mm Resolution-620 mm Protected Height | F3SJ-A0620P30 F3SJ-A Safety Light Curtain, 30mm Resolution; 620 mm Protected Height | EMPIRE
ME3001 | F3SJ-A0770P30 | X | F3SJ-A Safety Light Curtain- 30mm Resolution- 770 mm Protected Height | F3SJ-A0770P30 F3SJ-A Safety Light Curtain, 30mm Resolution; 770 mm Protected Height | EMPIRE
This is normally a much larger list, so a drop-down box would be far too cumbersome.
Spreadsheet: 377008d1423767597-lookup-multiple-items-examplefinished
Sheet: Score Card

 |  |  |  |  |  |  |  |  |  |  | ASHDEN THOMSON
 |  |  |  |  |  |  |  |  |  |  | MANAGER: |  | [NAME] |  |  |  |  | MONTH: |  | 2014-10-01 00:00:00
CALL QUALITY AUDIT RAG SCORES |  |  |  |  |  |  |  |  |  |  | CALL 1 |  |  | CALL 2 |  |  | CALL 3 |  |  | FINAL SCORE
DEMONSTRATES HIGH ENERGY AND POSITIVE TONE THROUGHOUT THE CALL
REFRAINS FROM USE OF JARGON, SLANG AND TECHNICAL TERMINOLOGY
[NAME] AND DEMONSTRATES EMPATHY
PROFESSIONAL AND DEMONSTRATES A PASSION FOR HELPING THE CUSTOMER
 |  |  |  |  |  |  |  |  |  |  | AHT |  |  | ACW % |  |  | ADHERENCE % |  |  | SALES LEADS
APPROPRIATELY QUESTIONS, WHAT, WHERE, HOW, WHEN, WHO?
RECAPS ALL RELEVANT INFORMATION TO CONFIRM UNDERSTANDING
DEMONSTRATES THE APPROPRIATE LEVEL OF TECHNICAL KNOWLEDGE
ALLOWS THE CUSTOMER TO SPEAK AND DOESN’T MAKE ASSUMPTIONS |  |  |  |  |  |  |  |  |  |  | PREV: |  |  | PREV: |  |  | PREV: |  |  | PREV:
[NAME] TO THE CUSTOMER
 |  |  |  |  |  |  |  |  |  |  | (IF APPLICABLE) |  | LIVE CHAT SCORING & FEEDBACK |  |  |  | SURVEYS: |  |  | EMAILER
DISCUSS OPTIONS AVAILABLE AND AGREE BEST WAY FORWARD |  |  |  |  |  |  |  |  |  |  | RESOLVED |  | KNOWLEDGE |  | ATTITUDE |  | OVERALL
INSPIRES CUSTOMER CONFIDENCE AND DEMONSTRATES FLEXIBILITY
DEMONSTRATES FORWARD THINKING
TAKES OWNERSHIP AND MAKES IT EASY FOR CUSTOMER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PREV:
SET AND AGREE TIMESCALES FOR FUTURE CONTACT
RESOLVED THE ISSUE IN AN EFFICIENT MANNER |  |  |  |  |  |  |  |  |  |  | COMMENTS FROM LIVE CHAT AND/OR CUSTOMERS |  |  |  |  |  |  |  |  | PUNCTUALITY
COACHES THE CUSTOMER USING BEST PRACTICE AND POLICY
ALL INFORMATION CAPTURED INCLUDING INSTANCE CONTACT
ACTIVITY LOGGED UNDER CORRECT FMS CODE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADD'L BREAKS
DPA COMPLETED
ALL NOTES ARE CLEAR, CONCISE AND REFLECTIVE OF THE CONVERSATION HELD
 |  |  |  |  |  |  |  |  |  |  | WEAKEST AREA
OVERALL RAG SCORE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQUIVALENT CALLS
ANALYST SIGNATURE: |  |  |  |  |  |  |  |  |  |  | COMMENTS
MANAGER SIGNATURE: