tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 237587d1369253253-automatic-color-based-on-color-in-other-cell-formatting-colors
Sheet: Solving

Name | Colour |  |  |  | Monday
[NAME] |  |  |  |  | 09:00:00 | [NAME]
Jordan |  |  |  |  | 10:00:00 | [NAME]
[NAME] |  |  |  |  | 11:00:00 | Jordan
[NAME] |  |  |  |  | 12:00:00 | [NAME]
 |  |  |  |  | 13:00:00 | [NAME]
 |  |  |  |  | 14:00:00 | [NAME]
 |  |  |  |  | 15:00:00 | Jordan
 |  |  |  |  | 16:00:00 | [NAME]
 |  |  |  |  | 17:00:00 | [NAME]
 |  |  |  |  | 18:00:00 | [NAME]
 |  |  |  |  | 19:00:00 | [NAME]
Spreadsheet: 42973d1241596906-how-to-check-whether-a-text-exists-in-a-group-of-cells-example
Sheet: Sheet1

WITH FORMULA:
ALL | People | Names |  | Names | People
[NAME] | NO | YES |  | [NAME] | [NAME]
[NAME] | YES | YES |  | Spongebob | George
George | YES | YES |  | [NAME]
Spongebob | NO | YES |  | George
SHOULD BE:
ALL | People | Names |  | Names | People
[NAME] | NO | YES |  | [NAME] | [NAME]
[NAME] | YES | YES |  | Spongebob | George
George | YES | YES |  | [NAME]
Spongebob | NO | YES |  | George
Spreadsheet: 45723d1244547534-how-do-i-use-two-fields-to-determine-lookup-value-example1
Sheet: Data

Name | Contract | Year | Visit Ref
 | 12 | 7 | 8754J
 | 15 | 7 | 7888W
 | 16 | 6 | 6950F
 | 20 | 9 | 7800Q
 | 13 | 7 | 6950F
 | 20 | 8 | 4528W
 | 12 | 8 | 40601M
 | 12 | 9 | 1254J
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: NFA

 | Janurary |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense
 | Navy Federal
 | Month | Day | Transactions | Category | Description | Subcategory | Amount
Spreadsheet: 794704d1662231165-find-cell-address-in-single-row-for-last-non-blank-value-not-the-highest-value-sample
Sheet: Sheet1

Doors | Refinish | Last value in row | 2011
 | Door |  | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 123 |  |  |  |  |  |  |  |  |  | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 123 |  |  |  |  |  |  |  |  |  |  | 125 |  |  |  |  | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  | 245 |  |  |  |  |  |  |  |  | 245
 |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  | 106 | 245 |  |  |  |  |  |  |  |  | 245
 |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104
 |  |  |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 172
Spreadsheet: 855058d1704781852-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker-aligw
Sheet: Nov

 |  |  |  |  |  | CALENDAR MONTH | NOVEMBER
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 179824d1347384168-reverse-time-calculation-timings
Sheet: Sheet1

PRODUCT | PRODUCT 2 |  |  |  | INPUT
No. OF BATCHES | 24
 |  |  |  |  |  |  |  |  |  |  | DATA
 | PRODUCTION |  |  | FINISHING |  |  | PACKING |  |  |  |  | [NAME] (1 BATCH) | FINISHING SPAN (1 BATCH)
 | DATE | TIME |  | DATE | TIME |  | DATE | TIME |  |  | PRODUCT 1 | 00:35:00 | 00:20:00
START TIME? |  |  |  |  |  |  | 2012-09-14 00:00:00 | 08:15:00 |  |  | PRODUCT 2 | 01:00:00 | 00:45:00
 |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | 00:10:00 | 00:20:00
 |  |  |  |  |  |  |  |  |  |  | PRODUCT 4 | 01:20:00 | 03:30:00
 |  |  |  |  |  |  |  |  |  |  | PRODUCT 5 | 00:50:00 | 00:50:00
 |  | RESULTS
Spreadsheet: 70706d1271414822-sumproduct-across-worksheets-cello-2-
Sheet: Sheet1

 | Date |  |  |  |  |  |  | Month to report |  |  | Inst | [NAME] | idl | TOTALS
 | 2010-01-06 00:00:00 |  |  |  |  |  |  | 2010-03-01 00:00:00 |  |  | 10 | 1 | 2 | 0 |  | 2010-01-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 | 2010-02-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
 | 2010-02-09 00:00:00
 | 2010-02-10 00:00:00
 | 2010-02-11 00:00:00
 | 2010-02-12 00:00:00
 | 2010-02-13 00:00:00
 | 2010-02-14 00:00:00
 | 2010-02-15 00:00:00
 | 2010-02-16 00:00:00
 | 2010-02-17 00:00:00
 | 2010-02-18 00:00:00
 | 2010-03-13 00:00:00
 | 2010-03-14 00:00:00
 | 2010-03-15 00:00:00
 | 2010-03-16 00:00:00
 | 2010-03-17 00:00:00
 | 2010-03-18 00:00:00
 | 2010-03-19 00:00:00
 | 2010-03-20 00:00:00
 | 2010-03-21 00:00:00
 | 2010-03-22 00:00:00
 | 2010-03-23 00:00:00
 | 2010-03-24 00:00:00
 | 2010-03-25 00:00:00
Spreadsheet: 836268d1689225740-parse-text-in-cells-for-a-column-into-a-new-column-excelforum
Sheet: Sheet1

 | phones |  |  | Value
 | 14042347745 |  |  | [PHONE]
 | [PHONE]|[PHONE] |  |  | [PHONE]
 | 7706348563 |  |  | [PHONE]
 | 6787541530 |  |  | [PHONE]
 | [PHONE]|[PHONE]|[PHONE] |  |  | [PHONE]
 | (404) 556-1409 |  |  | [PHONE]
 | (404) 914-3913|[PHONE] |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | (404) 556-1409
 |  |  |  | (404) 914-3913
 |  |  |  | [PHONE]
Spreadsheet: 762721d1641763728-summing-the-mutiple-ranges-where-the-same-header-are-there-tried-sumifs-index-xlookup-testing
Sheet: Summary

 |  |  | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | Required ans | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
6 | A |  |  |  | 112110
7 | A |  |  |  | 254795
8 | A |  |  |  | 331233
9 | A |  |  |  | 102780
10 | A |  |  |  | 101918
11 | A
12 | A
 | Total
6 | B
7 | B
8 | B
9 | B
10 | B
11 | B
12 | B
 | Total
6 | C
7 | C
8 | C
9 | C
10 | C
11 | C
12 | C
 | Total
Spreadsheet: eric_saibi__9696__010202
Sheet: Salem 01

Owner Name |  | PSEG Power LLC
Station Name |  | Salem Nuclear Power Station
Unit Name |  | Salem 01
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 1,170 MW
Start Date |  | 2001-12-31 00:00:00
End Date |  | 2002-01-06 00:00:00
Comments |  | Repairs
SIC |  | 4931
Plant ID |  | 1018459
Unit ID |  | 1004455
Outage ID |  | 19325
Spreadsheet: 94884d1294656730-help-needed-agent-stats-tracker-teamstats
Sheet: AH

 |  | [NAME] | Packs Out | Collections | Packs Back | Col % 2 PB | FMP Out | FMP In | Calls Taken | Calls Out | Attendence
 | 2011-01-17 00:00:00 |  |  |  |  | 1
 | 2011-01-18 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-19 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-20 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-01-21 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total | 37.5 | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 | 0 | 0
 | 2011-01-24 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-01-25 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-26 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-27 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-01-28 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-01-31 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-01 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-02 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-03 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-04 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-07 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-08 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-09 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-10 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-11 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-14 00:00:00 |  | 5 | 4 | 4 | 1
 | 2011-02-15 00:00:00 |  | 7 | 5 | 4 | 0.8
 | Weekly Total |  | 12 | 9 | 8 | 0.8888888888888888 | 0 | 0 | 0 |  | 0
 | Monthly Total |  | 144 | 93 | 84 | 0.9032258064516129 | 13564 | 0 | 0 |  | 0
Spreadsheet: 106204d1303388605-predicting-values-for-non-linear-set-of-data-excel_example
Sheet: Sheet1

Name | Column 1 | Column 2 |  | Using Forecast by including all values | Using Forecast with specific interval needed
Test 1 | 0 | 1133909
Test 2 |  | 1357848
Test 3 |  | 1426248
Test 4 |  | 1435511
Test 5 |  | 1735982
Test 6 |  | 2046423
Test 7 | 28.6 | 2599644
Test 8 | 28.6 | 2731462 |  |  | This column represents the values I need, but I do not want to set this up manually for every interval.
Test 9 |  | 2953229 |  |  | I need the formula to be able to find the correct interval.
Test 10 |  | 3538803
Test 11 |  | 4453796
Test 12 |  | 6054951
Test 13 |  | 6055103
Test 14 |  | 6055169
Test 15 |  | 6055192
Test 16 |  | 6328295
Test 17 |  | 6328606
Test 18 |  | 6328663
Test 19 | 33.5 | 6545742
Test 20 | 28 | 6700482
Test 21 | 35.4 | 7020916
Test 22 |  | 7027381
Test 23 |  | 7027686
Test 24 |  | 7157449
Test 25 |  | 7158485
Test 26 |  | 7321401
Test 27 | 37.4 | 7355582
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 14a

Product |  | TOTAL
Single - Name* | Corporate | 738909
 | Loans | 4846
 | Municipal | 1890
 | Recovery
 | Sovereign | 216429
Index Tranche | Asia | <1,000
 | Europe | 170641
 | North America | 156474
Index | Asia | 26481
 | Europe | 374671
 | North America | 537863
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 2228205
Estimated net notional amount outstanding, February 8 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 884587d1733823466-trying-to-combine-the-if-function-with-index-function-and-failing-project-dashboard-etaf
Sheet: Level 7

 | Project Name » | THERMAL OIL FOR THE COAL ELIMINATION-5 X12GCAL TOH |  |  |  | Overall  Progress » |  |  | Status Date » |  | 2024-12-09 00:00:00 | Total Tasks »
 | Project Manager » | Mr. [NAME] |  |  |  |  | pie chart |  | Duration » |  |  | Completed
 | [NAME] » | As part of their strategy to decarbonize the facility, achieve sustainable growth and satisfy the needs of customers in target export markets, Style Textile is replacing 3 Nos. of their existing Coal Based Thermal Oil Heaters (TOH) with 5 Nos. Multi-Fuel Biomass Fired TOH of 60GCal/hr, each with capacity of  12GCal/hr. |  |  |  |  |  |  | Project Start » |  | 2024-09-11 00:00:00 | In- Progress
 |  |  |  |  |  |  |  |  | Project End » |  | 2026-03-30 00:00:00 | Not Started
 |  |  |  |  |  |  |  |  | Man Days » |  | 404 | Due in Future
Task Manager
 | Task Title | AssignedTo | Start | End |  | Completed  Progress | Status | Planned Progress
Spreadsheet: 835297d1688486221-index-small-failed-to-replicate-example-index-small
Sheet: Sheet2

 | Movie | [NAME] | Actor | Release |  | INDEX-SMALL |  |  | INDEX-AGGREGATE |  |  | (From CARACALLA)
 | Prisoners | Thriller | [NAME] | 2013 |  | [NAME] | Action |  | [NAME] | Action |  | [NAME] | Action
 | The [NAME] | Mystery | Christian Bale | 2006 |  | Actor | [NAME] |  | Actor | [NAME] |  | Actor | [NAME]
 | Logan | Action | [NAME] | 2017 |  | Movie |  |  | Movie |  |  | Movie
 | The Dark Knight | Action | Christian Bale | 2008
 | Inception | Action | [NAME] | 2010
 | Public Enemies | Action | [NAME] | 2009
 | The Machinist | Thriller | Christian Bale | 2004
 | The Tourist | Action | [NAME] | 2010
 | Catch Me If You Can | Thriller | [NAME] | 2002
 | The Wolverine | Action | [NAME] | 2013
 | Shutter Island | Thriller | [NAME] | 2010
 | Secret Window | Thriller | [NAME] | 2004
 | Real Steel | Action | [NAME] | 2011
 | The Dark Knight Rises | Thriller | Christian Bale | 2012
 | The Ninth Gate | Thriller | [NAME] | 1999
 | The Departed | Thriller | [NAME] | 2006
 | Website: | https://www.exceldemy.com/excel-extract-data-from-table-based-on-multiple-criteria/#I_Using_INDEX-MATCH_Array_Formula
Spreadsheet: 478496d1472825266-hide-rows-and-columns-with-simple-function-test
Sheet: Sheet1

 |  |  |  |  | Month |  |  |  |  |  | YTD
 |  |  | Account |  | Actual | Budget | [NAME] |  | Last Year |  | Actual | Budget | [NAME] |  | Last Year
Merging Cells | Refer | Note | Number | Name |  |  | [NAME] | % |  |  |  |  | [NAME] | %
 |  |  | 4-0000_x000D_ | Revenue
 | ad |  | 4-1001 | Inc1 | 250 | 300 |  |  | 100 |  | 750 | 800 |  |  | 300
 | as |  | 4-1002 | Inc2 | 240 | 280 |  |  | 120 |  | 740 | 750 |  |  | 350
 | a |  | 4-1003 | Inc3 | 230 | 260 |  |  | 140 |  | 730 | 700 |  |  | 400
 | s |  | 4-1004 | Inc4 | 220 | 240 |  |  | 160 |  | 720 | 650 |  |  | 450
 | s |  | 4-1005 | Inc5 | 210 | 220 |  |  | 180 |  | 710 | 600 |  |  | 500
 | s |  | 4-1006 | Inc6 | 200 | 200 |  |  | 200 |  | 700 | 550 |  |  | 550
 | s |  | 4-1007 | Inc7 | 0 | 0 |  |  | 220 |  | 0 | 0 |  |  | 600
 | s |  | 4-1008 | Inc8 | 180 | 160 |  |  | 240 |  | 680 | 450 |  |  | 650
 | f | f | 4-1009 | Inc9 | 170 | 140 |  |  | 260 |  | 670 | 400 |  |  | 700
 |  | f | 4-1010 | Inc10 | 160 | 120 |  |  | 280 |  | 660 | 350 |  |  | 750
 |  | f | 4-1011 | Inc11 | 0 | 0 |  |  | 0 |  | 0 | 0 |  |  | 0
 |  | f | 4-1012 | Inc12 | 140 | 80 |  |  | 320 |  | 640 | 250 |  |  | 850
 |  |  | 4-1013 | Inc13 | 0 | 0 |  |  | 0 |  | 0 | 0 |  |  | 0
 |  |  | 4-1014 | Inc14 | 120 | 40 |  |  | 360 |  | 620 | 150 |  |  | 950
 |  |  |  | Total Revenue
Spreadsheet: 747079d1631204181-competition-ratings-last-occurance-based-on-two-columns-jman0502-
Sheet: Matches

Game | Competitor | Original | Win | Points | New | Ga | me | Competitor | Original | Win | Points | New |  | Elo Score
 |  | Points | Expectancy |  | Points | Score |  |  | Points | Expectancy |  | Points |  | 1 | 2
1 | [NAME] |  |  |  |  | 2 | 1 | [NAME]
2 | [NAME] |  |  |  |  | 3 | 4 | [NAME]
3 | [NAME] |  |  |  |  | 5 | 2 | [NAME]
4 | Utut Adianto |  |  |  |  | 0 | 8 | [NAME]
5 | [NAME] |  |  |  |  | 5 | 6 | [NAME]
6 | [NAME] So |  |  |  |  | 2 | 5 | [NAME]
7 | Mandi |  |  |  |  | 2 | 8 | [NAME]
8 | Aleksandar Inđić |  |  |  |  | 2 | 3 | Artashes Minasian
9 | Sang Cao |  |  |  |  | 6 | 4 | [NAME] | 1552
10 | Darmen Sadvakasov |  |  |  |  | 8 | 5 | Ryusei Yasue
11 | Utut Adianto | 1269 |  |  |  | 10 | 9 | Sébastien Feller
12 | Alejandro [NAME] |  |  |  |  | 2 | 3 | [NAME]
13 | Enrico Marini |  |  |  |  | 7 | 5 | [NAME]
14 | [NAME] |  |  |  |  | 4 | 5 | [NAME]
15 | Alisher [NAME] |  |  |  |  | 2 | 10 | [NAME]
16 | [NAME] |  |  |  |  | 3 | 1 | [NAME]
17 | [NAME] |  |  |  |  | 6 | 3 | [NAME]
18 | [NAME] |  |  |  |  | 7 | 5 | [NAME]
19 | [NAME] |  |  |  |  | 7 | 6 | [NAME] | 2008
20 | Yuriy Kryvoruchko |  |  |  |  | 1 | 8 | Cal Connor
21 | [NAME] |  |  |  |  | 8 | 10 | [NAME] | 1289
22 | [NAME] | 1998 |  |  |  | 2 | 1 | [NAME] | 1878
23 | [NAME] | 1746 |  |  |  | 7 | 8 | [NAME] So | 1703
24 | Sébastien Feller | 1419 |  |  |  | 4 | 10 | Darmen Sadvakasov | 1339
25 | [NAME] |  |  |  |  | 1 | 5 | Aleksandar Inđić | 1465
26 | [NAME] | 2154 |  |  |  | 4 | 3 | Utut Adianto | 1269
27 | [NAME] | 1650 |  |  |  | 10 | 5 | Enrico Marini | 1173
28 | Sébastien Feller |  |  |  |  | 3 | 5 | [NAME] | 1126
29 | [NAME] | 1061 |  |  |  | 10 | 1 | Alejandro [NAME] | 1244
Spreadsheet: 30112d1225410247-data-matching-with-data-validation-testlog-2-
Sheet: NEEDING

 |  |  |  |  |  |  | OCR TEMPLATE ISSUES LOG (2008)
REQUESTED BY | Due Date | Priority | State | Form ID | Form Family | DATE SENT TO DEANNA FOR MODIFICATION | ISSUE | FORM TYPE | Status | DATE COMP. IN TEST ENVIRONMENT | COMMENTS | DATE OF END USER BUYOFF | Date Of User Production Buyoff | Template works Y/N
 | 2008-07-03 00:00:00 | LOW | AK | BSWOC14 |  | 2006-11-20 00:00:00 | BRAND NEW TEMPLATE TO BE DONE.
 | 2008-07-03 00:00:00 | LOW | AL | [NAME] |  | 2008-04-16 00:00:00 | GAVE DM2 ORIGINALS FOR HER TO TEMPLATE |  |  | 593113DM
 | 2008-07-03 00:00:00 | LOW | AK | BSVLA |  | 2008-06-04 00:00:00 | WHEN FORM IS SCANNED INTO THE SYSTEM, ITS SAYING THAT IS WRONG SIZE
 | 2008-07-03 00:00:00 | LOW | AL | [NAME] |  | 2008-04-22 00:00:00 | REVISED CLAIM FORM. ALL ZONES, REGISTRATION POINTS, & AUTO ID NEEDS TO BE REDONE. WILL FWD ORIGINAL CLAIMS TO TEMPLATE
 | 2008-07-03 00:00:00 | LOW | WV | BSVLB |  |  |  |  |  | 573201DM
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 726428d1617225601-employee-service-milestones-and-vacation-entitlement-datedif-and-index-and-match-vacation_entitlement_report_for-sharing
Sheet: Vacation Entitlement

Vacation Entitlement |  |  |  | Vacation Entitlement Upon Hire
Service Milesontes | Hours |  |  | Job Category | Hours
5 | 140 |  |  | All other employee groups | 105
10 | 175 |  |  | Management (level management-3 and above) | 140
20 | 210 |  |  | Director (level Exec-2) | 210
 |  |  |  | Admin - 1-Admin - 1 | 105
Vacation Entitlement - Management 3 and 4 |  |  |  | Admin - 2-Admin - 2 | 105
Service Milestones | Hours |  |  | Admin - 3-Admin - 3 | 105
5 | 175 |  |  | Admin - 4-Admin - 4 | 105
10 | 210 |  |  | Entry-Entry | 105
 |  |  |  | Exec - 1-Exec - 1 | 105
 |  |  |  | Exec - 2-Exec - 2 | 210
 |  |  |  | Mgt - 1-Mgt - 1 | 105
 |  |  |  | Mgt - 2-Mgt - 2 | 105
 |  |  |  | Mgt - 3-Mgt - 3 | 140
 |  |  |  | Mgt - 4-Mgt - 4 | 140
 |  |  |  | Other-Other | 105
 |  |  |  | Prof/Tech - 2-Prof/Tech - 2 | 105
 |  |  |  | Prof/Tech - 3-Prof/Tech - 3 | 105
 |  |  |  | Prof/Tech - 4-Prof/Tech - 4 | 105
example for proration | (140/12)*3.5+(105/12)*8.5 |  |  | Prof/Tech - 5-Prof/Tech - 5 | 105
 |  |  |  | Prof/Tech - 6-Prof/Tech - 6 | 105
Spreadsheet: 06b9fb9f-b9cf-4465-8529-78bd3b93aa0b
Sheet: Non-Western

NON-WESTERN CAR
Course color corresponds with term of offering. BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
[NAME] | ARTH 210 |  | cross-listed with CLAS 210
 | ARTH 211 |  | cross-listed with CLAS 211
 | ARTH 227
 | ARTH 228
 | ARTH 235
 | ARTH 381 |  | Fall 2012(Coptic Art in Egypt)
Asian Studies | ASTU 230 |  | cross-listed with FLET 230
 | ASTU 231 |  | cross-listed with FLET 231
 | ASTU 232 |  | cross-listed with FLET 232
 | ASTU 233 |  | cross-listed with FLET 233
 | ASTU 290 |  | cross-listed with HIST 290
 | ASTU 292 |  | cross-listed with FILM 292
 | ASTU 381 |  | Sp 2013-Japanese Literature: [NAME]
 | ASTU 390
Black Studies | BLST 160
Chinese | CHIN 221
Classical Studies | CLAS 210 |  | cross-listing with ARTH 210
 | CLAS 211 |  | cross-listed with ARTH 211
 | CLAS 482 |  | Sp 2013-Greek and Roman Egypt
Communication Studies | COMM 332
Economics | ECON 481 |  | Fall 2009 (Contemporary China's Economy)
English | ENGL 272
 | ENGL 369
 | ENGL 370
Environmental Studies | EVST 245 |  | cross-listed with INST 245
Film Studies | FILM 292 |  | cross-listed with ASTU 292
Foreign Literature in English Translation | FLET 230 |  | cross-listed with ASTU 230
 | FLET 231 |  | cross-listed with ASTU 231
 | FLET 232 |  | cross-listed with ASTU 232
 | FLET 233 |  | cross-listed with ASTU 233
 | FLET 248
 | FLET 249
History | HIST 100 |  | Modern Iraq only
 | HIST 100 |  | Intro to Southeast Asian History
 | HIST 100 |  | History of Ancient Egypt
 | HIST 221 |  | cross-listed with JAPN 221
 | HIST 251
 | HIST 252
 | HIST 281
 | HIST 282
 | HIST 290
 | HIST 320
 | HIST 332
 | HIST 347
 | HIST 348
 | HIST 361
 | HIST 365
 | HIST 367
 | HIST 391
 | HIST 392
 | HIST 393 |  | Spring 2013(Modern Indonesian History)
 | HIST 394
 | HIST 395
 | HIST 396
 | HIST 397
Honors Program | HONR 215
 | HONR 259
 | HONR 290
International Studies | INST 245 |  | cross-listed with EVST 245
Japanese | JAPN 220
 | JAPN 221 |  | cross-listed with HIST 221
 | JAPN 381 & 382
Mathematics | MATH 270
Music | MUSC 240
 | MUSC 381 |  | J-term 2013(Music of Brazil)
Philosophy | PHIL 220
 | PHIL 343
 | PHIL 381 |  | Spring 2010 (Confucian Tradition)
Political Science | PSCI 328
 | PSCI 333
 | PSCI 334
 | PSCI 335
 | PSCI 336
 | PSCI 337
 | PSCI 338
 | PSCI 381 |  | Spring 2011 (Political Islam in the Middle East)
Psychology | PSYC 160
 | PSYC 162
 | PSYC 175
 | PSYC 180
 | PSYC 186
Religious Studies | RELS 221
 | RELS 223
 | RELS 225
 | RELS 229
 | RELS 245
 | RELS 248
Sociology | SOCI 210
 | SOCI 215
 | SOCI 230
 | SOCI 260
 | SOCI 265
 | SOCI 273
 | SOCI 383 |  | J-Term 2009, 2011 (Global, Env, Social Dynamics Brazil)
 | SOCI 383 |  | J-Term 2008, 2010 (Globalization & Social Change Ghana)
Spreadsheet: 117657d1312942015-excel-2007-dates-if-then-formula-date-range
Sheet: Sheet1

Start Date | End Date | Text | Specific Date | Returned value
2010-01-11 00:00:00 | 2010-08-15 00:00:00 | rug | 2010-02-07 00:00:00
2010-08-16 00:00:00 | 2010-11-02 00:00:00 | [NAME] | 2010-02-15 00:00:00
2010-11-03 00:00:00 | 2010-12-15 00:00:00 | rtp | 2010-03-01 00:00:00
2010-12-16 00:00:00 | 2011-01-25 00:00:00 | [NAME] | 2010-03-15 00:00:00
2011-01-26 00:00:00 | 2011-02-08 00:00:00 | slt | 2010-03-17 00:00:00
2011-02-09 00:00:00 | 2011-03-15 00:00:00 | ups | 2010-04-15 00:00:00
 |  |  | 2010-12-16 00:00:00
 |  |  | 2011-01-01 00:00:00
 |  |  | 2011-02-26 00:00:00
 |  |  | 2011-03-09 00:00:00
Spreadsheet: 161874d1339665632-excel-2007-formula-counting-double-data-entries-as-one-copy-of-copy-of-count1
Sheet: Countif

 |  |  |  | Data | Counting |  |  |  |  |  |  |  |  | Expected Result
 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 30 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 30 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 60 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  | 110 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | 125 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | 125 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | 31 |  |  |  |  |  |  |  |  |  | 6
 |  |  |  | 75 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  | 76 |  |  |  |  |  |  |  |  |  | 8
 |  |  |  | 80 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  | 90 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  | 95 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  | 95 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  | 65 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  | 65 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  | 102 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  | 111 |  |  |  |  |  |  |  |  |  | 14
 |  |  |  | 111 |  |  |  |  |  |  |  |  |  | 14
Spreadsheet: 93274d1292876462-updating-data-on-a-worksheet-from-another-excel-2007-forum-excel-example
Sheet: Training Matrix

 |  |  |  | PROMISE DATE / FECHA PROMESA
 |  |  |  | DATE OF TRAINING / FECHA DEL ENTRENAMIENTO
 |  |  |  | TRAINER / ENTRENADOR
 | EMPLOYEE NUMBER / NUMERO DE EMPLEADO | SHIFT / TURNO | POSITION / PUESTO | NAME / NOMBRE | Características de los instrumentos lineales 115 | Compensaciones (offsets) de CNC 210 | [NAME] básicos de CMM 120 | [NAME] básicos del comparador óptico 130 | Coordenadas de CNC 140 | Estadística 220
1 | 22222 | 1 |  | [NAME] | N/A | 2.88 | N/A | N/A | 1.48 | 1.47