tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 860883d1708897639-bulk-combine-rows-using-lead-column-as-guide-ncaab-college-basketball-scores-and-game-results
Sheet: Rank

Team | Rank | Pts | W/L | Logo | News
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: SPED

Old course number | New course number
SPED-510 | SPED-4100
SPED-510 | SPED-6101
SPED-610 | SPED-6102
SPED-619 | SPED-8619
SPED-621 | SPED-6210
SPED-624 | SPED-6240
SPED-625 | SPED-6250
SPED-640 | SPED-6400
SPED-641 | SPED-6410
SPED-644 | [NAME]
SPED-645 | SPED-6450
SPED-650 | SPED-6500
SPED-699 | SPED-6999
SPED-805 | SPED-8805
SPED-820 | SPED-8200
SPED-831 | [NAME]
SPED-835 | SPED-8350
SPED-840 | SPED-8400
SPED-850 | SPED-8500
SPED-860 | SPED-8600
SPED-863 | SPED-8963
SPED-865 | SPED-8999
Spreadsheet: 739931d1626094062-automated-staining-of-cells-by-means-of-a-variable-comparison-value-cf-date-comparisons-aligw
Sheet: Tabelle1

heading | heading
text | text
2019-03-10 00:00:00 | 2020-04-23 00:00:00
2021-05-04 00:00:00 | 2020-09-08 00:00:00
2021-11-17 00:00:00 | 2018-09-02 00:00:00
2020-06-09 00:00:00 | 4032021
text | text
2017-07-08 00:00:00 | 2021-01-12 00:00:00
2021-10-09 00:00:00 | 2015-08-13 00:00:00
… | …
Spreadsheet: 742036d1627485683-how-to-add-a-mtd-graph-in-my-dashboard-that-is-made-up-of-daily-data-help-daily-dashboard-example-help
Sheet: Raw Data

Date | Calls Offered | Calls Handled | Answer Call Rate
2021-07-01 00:00:00 | 50 | 48
2021-07-02 00:00:00 | 52 | 50
2021-07-03 00:00:00 | 56 | 54
2021-07-04 00:00:00 | 57 | 56
2021-07-05 00:00:00 | 52 | 49
2021-07-06 00:00:00 | 51 | 49
2021-07-07 00:00:00 | 45 | 44
2021-07-08 00:00:00 | 62 | 59
2021-07-09 00:00:00 | 63 | 59
2021-07-10 00:00:00 | 64 | 58
2021-07-11 00:00:00 | 68 | 65
2021-07-12 00:00:00 | 69 | 67
2021-07-13 00:00:00 | 52 | 50
2021-07-14 00:00:00 | 56 | 52
2021-07-15 00:00:00 | 51 | 50
2021-07-16 00:00:00 | 54 | 52
2021-07-17 00:00:00 | 57 | 55
2021-07-18 00:00:00 | 50 | 48
2021-07-19 00:00:00 | 52 | 50
2021-07-20 00:00:00 | 56 | 54
2021-07-21 00:00:00 | 57 | 56
2021-07-22 00:00:00 | 52 | 49
2021-07-23 00:00:00 | 51 | 49
2021-07-24 00:00:00 | 45 | 49
2021-07-25 00:00:00 | 62 | 59
2021-07-26 00:00:00 | 63 | 59
2021-07-27 00:00:00 | 64 | 58
2021-07-28 00:00:00 | 68 | 65
2021-07-29 00:00:00 | 69 | 67
Spreadsheet: 219496d1362770066-linear-simulation-and-solver-many-problems-no-solutions-excel
Sheet: Sheet2

INPUT : | Beg. Workers | 60 | Regular Wage | 10 | Hiring Cost per Worker | 3000 | Inventory Cost per quarter | 0.25
 | Units / Worker/ hour |  | Overtime Wage | 25 | Firing Cost per Worker | 7000 | Backordering Cost per quarter | 2.4
 | Beg. Inventory | 0 | [NAME] per day | 4 | Normal Working Time | 8 | TOTAL COST
Week: | Reg | OT | Production:
1 | 40 | 0
2 | 40 | 0
3 | 40 | 0
4 | 40 | 0
5 | 40 | 0
6 | 40 | 0
7 | 40 | 0 |  |  | 1
8 | 40 | 0
9 | 40 | 0
10 | 40 | 0
11 | 40 | 0
12 | 40 | 0
13 | 40 | 0
Total: | 1860000
Total Labour Cost:
Week: | Reg | OT | Production:
1 | 40 | 0
2 | 40 | 0
3 | 40 | 0
4 | 40 | 0
5 | 40 | 0
6 | 40 | 0 |  |  | 2
7 | 40 | 0
8 | 40 | 0
9 | 40 | 0
10 | 40 | 0
11 | 40 | 0
12 | 40 | 0
13 | 40 | 0 |  | Total:
Total: | 2350000
Total Labour Cost:
Week: | Reg | OT | Production:
1 | 40 | 0
2 | 40 | 0
3 | 40 | 0
4 | 40 | 0
5 | 40 | 0
6 | 40 | 0
7 | 40 | 0
8 | 40 | 0 |  |  | 3
9 | 40 | 0
10 | 40 | 0
11 | 40 | 0
12 | 40 | 0
13 | 40 | 0 |  | Total:
Total: | 2040000
Total Labour Cost:
Week: | Reg | OT | Production:
1 | 40 | 0
2 | 40 | 0
3 | 40 | 0
4 | 40 | 0
5 | 40 | 0
6 | 40 | 0
7 | 40 | 0
8 | 40 | 0 |  |  | 4
9 | 40 | 0
10 | 40 | 0
11 | 40 | 0
12 | 40 | 0
13 | 40 | 0 |  | Total:
Total: | 4190000
Total labour cost:
Total labour hours of all quarters |  | 0
Quarters
 | Demand | No. Workers | No. Hired | No Fired | Inv/ Backorder | Production | stock cost | Labour Cost
1 | 1860000 |  | 0 | 0
2 | 2350000 |  | 0 | 0
3 | 2040000 |  | 0 | 0
4 | 4190000 |  | 0 | 0
Total |  |  | 0 | 0
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: DM

 | Janurary |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges
 |  |  |  |  |  |  |  |  |  | Total
 | Discover |  |  |  |  |  |  |  |  | Prior Year
 | Month | Day | Transaction | Category | Description | Subcategory | Amount | Paid
Spreadsheet: 720918d1614364132-resetting-a-rows-function-based-on-a-counta-function-rows-example1
Sheet: JOB TYPE

 | DETAIL | INSTALL | SIDE JOB | SIDE JOB ESTIMATE | PICKUP | WORK ORDER
Spreadsheet: 218044d1362318509-look-up-and-return-multiple-dates-from-a-list-candiecane_81
Sheet: Sheet1

ID Numbers | date of absence
1101 | 2013-03-01 00:00:00
1520 | 2013-01-27 00:00:00
1520 | 2013-01-19 00:00:00
1305 | 2013-01-07 00:00:00
1101 | 2013-02-21 00:00:00
1305 | 2013-01-15 00:00:00
1520 | 2013-02-07 00:00:00
1305 | 2013-02-23 00:00:00
1305 | 2013-01-10 00:00:00
Spreadsheet: 105046d1302528755-weighted-average-including-n-a-cc
Sheet: Call 5

 |  | Call ID: |  |  |  | Caller No.:
 |  | Date of Call: |  |  |  | Call Type:
 |  | Time of Call: |  |  |  | Duration:
 |  | Performance Area | Description | Performance |  |  |  |  |  |  |  | Performance Review Summary
 |  |  |  | Performance | Performance | Performance | Performance | Performance | Performance |  |  | Performance Area | Satisfactory Percentage | Weighting | Call 5 Weighted Score
 |  |  |  | Unacceptable | Below Satisfactory | Satisfactory | Good | Excellent | N/A
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  | 0.1
 |  | Opening | Welcome using company name |  | 1 |  |  |  |  |  |  |  |  | 0.25
 |  |  | Effective greeting |  |  | 1 |  |  |  |  |  |  |  | 0.15
 |  |  | Agent introduction including name |  |  | 1 |  |  |  |  |  |  |  | 0.15
 |  |  | Get customers name |  |  |  | 1 |  |  |  |  |  |  | 0.25
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  | 0.1
 |  | [NAME] | Every effort made towards first call resolution |  |  |  | 1 |  |  |  |  | Total Grade
 |  |  | Asked clarifying questions |  |  |  | 1
 |  |  | Demonstrated knowledge of products/services |  |  | 1
 |  |  | Showed clear understanding problems/issues |  |  | 1
 |  |  | Accurately diagnosed problems/issues |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | [NAME] | Volume & Clarity of agent |  |  |  |  | 1
 |  |  | Interruption of customer during call |  |  | 1
 |  |  | Demonstration of active listening |  |  |  | 1
 |  |  | Displayed a professional manner |  |  |  | 1
 |  |  | Polite, friendly & welcoming |  |  |  |  | 1
 |  |  | Avoided long silences / pauses |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | [NAME] | Requested permission to put on hold |  |  | 1
 |  |  | Used mute procedure effectively |  |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | Systems Skills | Used correct applications effectively |  |  |  | 1
 |  |  | Correctly escalated issues through [NAME] |  |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | Closing | Offer to assist with any other issue |  |  | 1
 |  |  | Close by thanking customer for contacting [NAME] |  |  | 1
Spreadsheet: 739360d1625662111-pull-cell-and-comment-data-to-report-downtime-example
Sheet: Sheet1

 | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00 | 2021-05-19 00:00:00 | 2021-05-20 00:00:00 | 2021-05-21 00:00:00 | 2021-05-22 00:00:00 | 2021-05-23 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 | 2021-05-27 00:00:00 | 2021-05-28 00:00:00 | 2021-05-29 00:00:00 | 2021-05-30 00:00:00 | 2021-05-31 00:00:00
Line 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 11.5 | 0 | 0 | 0
Line 2 | 0 | 0 | 0 | 0 | 1.25 | 0 | 0 | 0 | 0 | 6.75 | 10 | 0 | 0 | 1 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Line 3 | 0 | 0 | 0 | 0.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.5 | 0 | 0 | 0 | 0 | 0.75 | 0 | 0.25 | 0 | 5.25 | 0 | 0 | 0
Line 4 | 0 | 0 | 0 | 0 | 0 | 0.5 | 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
Line 5 | 0 | 0 | 0 | 6 | 2 | 3.25 | 2.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8.5 | 2 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 0
Line 6 | 0 | 0 | 0 | 3.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Line 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Line 8 | 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
Line 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Line 10 | 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
Line 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5 | 0 | 0 | 0 | 1.5 | 2 | 0.75 | 1.25 | 0 | 0 | 0 | 0
Line 12 | 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
Line 13 | 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
Line 14 | 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
Spreadsheet: 820848d1678307152-matching-two-columns-and-returning-the-third-example
Sheet: Lists

Regular Outgoings List
Description | Amount | Category
UKI T/A DIRECTLINE | -10 | wife
UKI T/A DIRECTLINE | -20 | me
UKI T/A DIRECTLINE | -30 | dog
Savings Account | -50 | To Savings
SAVINGS ACCOUNT | 60 | From Savings
BRITISH GAS | -20 | Energy
WATER | -150 | Energy
EE LIMITED | -10 | Mobile
INSURANCE | -20 | Car Insurance
Spreadsheet: 68175d1268736644-automatically-change-a-column-chart-based-upon-2-data-ranges-example_no-info
Sheet: Sheet1

Y
 |  | Urban |  | Semi Rural |  | Rural
 | Total Roadway Cost | 100 |  | 90 |  | 70
 | Total Footway Cost | 50 |  | 40 |  | 20
 | Total Roadway 1 Cost |  | 15 |  | 12 |  | 10
 | Total Footway 1 Cost |  | 10 |  | 8 |  | 6
 |  | Urban |  | Semi Rural |  | Rural
 | Total Roadway Cost | 50 |  | 45 |  | 35
 | Total Footway Cost | 25 |  | 20 |  | 10
 | Total Roadway 2 Cost |  | 7.5 |  | 6 |  | 5
 | Total Footway 2 Cost |  | 5 |  | 4 |  | 3
Spreadsheet: 75124d1275651287-how-to-refresh-data-for-advanced-filter-and-associated-problems-example_advanced_filter_rev1
Sheet: Q1305

Cost Centre
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 501 | 5004 | [NAME] | 2010-01-03 00:00:00 | 2010-05-03 00:00:00 | 1 | 75 | Staff | B
[NAME] | 501 | 5004 | [NAME] | 2010-01-02 00:00:00 | 2010-06-03 00:00:00 | 1 | 75 | Staff | A
Spreadsheet: 819520d1677562348-vlookup-specific-description-from-multiple-tabs-under-specific-header-name-in-one-column-s666-pq-prices-samples
Sheet: Master_Copy

Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3 |  |  | https://www.excelforum.com/excel-formulas-and-functions/1400654-vlookup-or-matched-formulas.html
ABC | 2023-01-26 00:00:00 |  |  | 69.876 | 68.34 | 67.879
DEF | 2023-01-26 00:00:00 |  |  | 1.989
GHI | 2023-01-26 00:00:00 |  |  | 87.212
JKL | 2023-01-26 00:00:00 |  |  | 3.4234
MNO | 2023-01-26 00:00:00 |  |  | 1.044
PQR | 2023-01-26 00:00:00 |  |  | 1.232
STU | 2023-01-26 00:00:00 |  |  | 2.43
VWX | 2023-01-26 00:00:00 |  |  | 1.876
YZA | 2023-01-26 00:00:00 |  |  | 0.08997
AAA | 2023-01-26 00:00:00 |  |  | 0.1231
BBB | 2023-01-26 00:00:00 |  |  | 1.312
CCC | 2023-01-26 00:00:00 |  |  | 4.2342
Spreadsheet: john_zufferli__16753__Can Gas Stack  Website for New Version 121901
Sheet: CAN Gas - Stack

STACK MANAGER ACCESS |  |  | Read
Canada Gas |  |  | Execute
 |  |  | None
Name | Position | Tenor  (1-120 Months) | CAN Gas Fin BasSwap (1062) | CAN Gas Fin BasSwap East (1280) | CAN Gas Fin Option (1992) | CAN Gas Fin Swap (1063) | CAN Gas Fin Swap (Internal Only) (1984) | CAN Gas Fin Swap East (1278) | CAN Gas Straddle Option (2021) | CAN Gas Phy Basis East Spd <or= 1Mo (2131) | CAN Gas Phy Basis East Spd >1Mo<1Yr (2132) | CAN Gas Phy Basis Firm East <or= 1Mo (1184) | CAN Gas Phy Basis Firm East >1Mo<1Yr (1185) | CAN Gas Phy Basis Firm West <or= 1Mo (2128) | CAN Gas Phy Basis Firm West >1Mo<1Yr (2129) | CAN Gas Phy Fwd Firm East <or= 1Mo (1179) | CAN Gas Phy Fwd Firm East Spd <or= 1Mo (2193) | CAN Gas Phy Fwd Firm West <or= 1Mo (1182) | CAN Gas Phy Fwd Firm West >1Mo<1Yr (1183) | CAN Gas Phy Index Firm East <or= 1Mo (2114) | CAN Gas Phy Index Firm East >1Mo<1Yr (2115) | CAN Gas Phy Index Firm West <or= 1Mo (1186) | CAN Gas Phy Index Firm West >1Mo<1Yr (1187)
[NAME] | AECO Cash Trader | 1 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Execute | Read | Read | Read | Execute | Read | Read | Read | Execute | Read
[NAME] | AECO Cash Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
[NAME] | AECO Term Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
Stephane Brodeur | BC Cash Trader | 1 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Execute | Read | Read | Read | Execute | Read | Read | Read | Execute | Read
[NAME] | BC Cash Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
[NAME] | BC Term Trader | 36 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Execute | Execute | Read | Read | Execute | Execute | Read | Read | Execute | Execute
Lon Draper | Options Trader | 24 | Read | Read | Execute | Read | Read | Read | Execute | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
Cooper Richey | Power Trader | 24 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
[NAME] | VP-Canada Trading | [NAME] | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
Spreadsheet: 033d305d-cff9-418e-ab1e-33c6d7c1f9be
Sheet: 7. Termination_of_Exps

Colorado Department of Education
Maintenance of Effort Workbook
34 CFR §300.204(d)
Worksheet for the Termination of Costly Expenditures for Long Term (Multi-Year) Purchases
Instructions:  For each expenditure start by answering the first 2 questions about fiscal year expenditures.  These questions will determine if the expenditure is an allowable exception.  To be allowable, the answer to the question in column B must be Yes and the answer to the question in column C must be No.   If the expense is allowable, enter the requested information in the appropriate column.  Under type of expenditure enter a brief description such as capital outlay equipment, or bus fleet refurbishing, etc., enter the amount expensed in FY 2010/11, this is the amount of your allowable exception.  See the Instructions tab under Termination of Expenditures for more detailed instructions and information on allowable exceptions for the termination of costly long term expenditures.  For monitoring purposes, maintain contract documentation and expenditure back up, but do not submit to CDE with this document, unless requested.
 | Are there
 | Expenditures | Are there
 | for this | Expenditures |  |  |  | Amount
 | Contract in | for this |  |  |  | Expensed in FY
 | at least FY | Contract in |  |  | Contract Start | 2011-12
 | 10/11 & FY | FY 2012/13? |  |  | and End | (Allowable
No. | 11/12? (Y/N) | (Y/N) | Type of Expenditure | Contract # | Dates | Exception)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 |  |  |  |  | Total:
Spreadsheet: 489426d1479241784-is-there-a-way-of-combining-dates-in-various-ranges-like-concatenate-concatenate-dates-auto
Sheet: Sheet1

Name | 81877 | type | 1 | $$ | 2016-07-13 00:00:00
Name | 81877 | type | 1 | $$ | 2016-11-15 00:00:00
Name | 81877 | type | 1 | $$ | 2016-04-16 00:00:00
Name | 81877 Total | type |  | $$
Name | 82694 | type | 1 | $$ | 2016-04-04 00:00:00
Name | 82694 | type | 1 | $$ | 2016-08-09 00:00:00
Name | 82694 | type | 2 | $$ | 2016-09-06 00:00:00
Name | 82694 | type | 1 | $$ | 2016-10-12 00:00:00
Name | 82694 | type | 1 | $$ | 2016-10-30 00:00:00
Name | 82694 | type | 1 | $$ | 2016-12-31 00:00:00
Name | 82694 Total | type |  | $$
Name | 82695 | type | 2 | $$ | 2016-07-13 00:00:00
Name | 82695 | type | 2 | $$ | 2016-11-15 00:00:00
Name | 82695 | type | 2 | $$ | 2016-04-16 00:00:00
Name | 82695 | type | 2 | $$ | 2016-08-09 00:00:00
Name | 82695 | type | 2 | $$ | 2016-09-06 00:00:00
Name | 82695 Total | type |  | $$
Spreadsheet: 60175d1260728380-comparing-columns-on-2-different-workbooks-example
Sheet: Sheet1

Tags | FIWP
250-C-4002-01-HT01 |  |  | 25B-F138-28-01
250-C-4002-01-HT02A
250-C-4002-01-HT02B |  |  | I want to lookup these tags in sheet2.  If they are in sheet2 then I want to return the value in d2 in column b
250-C-4002-01-HT03
250-C-4003-01-HT01
250-C-4003-01HT02
250-C-4005-01-HT01
250-C-4005-01-HT02
250-C-4007-01-HT01A
250-C-4007-01-HT01B
250-C-4007-01-HT01C
250-C-4007-01-HT02A
250-C-4007-01-HT02B
250-C-4007-01-HT02C
250-C-4007-01-HT03A
250-C-4007-01-HT03B
250-C-4007-01-HT03C
250-C-4007-01-HT04A
250-C-4007-01-HT04B
250-C-4007-01-HT04C
250-C-4007-01-HT05A
250-C-4007-01-HT05B
250-C-4007-01-HT05C
250-C-4007-02-HT01
250-C-4007-02-HT02A
250-C-4007-02-HT02B
250-C-4007-06-HT01
250-C-4007-13-HT01
Spreadsheet: 79488d1279738987-multiple-sheet-sorts-with-links-between-sheets-sort-problem-example
Sheet: Links

Ln. |  | Links | Data Before Sort:
1 |  |  | 184
2 |  |  | 155
3 |  |  | 166
4 |  |  | 200
5 |  |  | 177
6 |  |  | 188
7 |  |  | 145
8 |  |  | 199
9 |  |  | 210
10 |  |  | 45
Sort the data on the other sheet.  On this sheet, I need column C to equal
column D even after the data on the other sheet has been sorted.
Spreadsheet: 163257d1340248534-arrange-complex-excel-data-from-different-worksheet-and-sort-into-one-database-book1
Sheet: Sheet2

Position /Competency Mapping
Proficiency Level Table  : IT Department
 |  | Core Competency |  |  |  |  | Managerial Competency |  |  |  |  | Functional Competency
 | Proficiency Level Guide | Quality Awareness | Customer Oriented | Continual Improvement | Safety Awareness | Innovation | Leadership | Problem Solving & Decision Making | Coaching and Developing Others | Accountability | Risk Management | BBBBBBBBBBBBBB | [NAME] | EEEEEEEEEEEE
Competency Level: |  | CC 001 | CC 002 | CC 003 | CC 004 | CC 005 | MC 001 | MC 002 | MC 003 | MC 004 | MC 005 | FC002 | FC004 | FC005
Position Title:
Senior IT Manager | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5
Application Section Manager | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  | 5
Infrastructure Section Manger | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 |  | 5
Senior.PC-LAN Analyst | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 |  | 5
IT Application Analyst & System Admin | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 |  | 4
Program and System Analyst | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 4
IT Application Support & System Support | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 |  | 3
Programmer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 3
Spreadsheet: 8cc60300-852d-4f16-bcc1-beb439081483
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 3/12/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14
 | Area: Planted | Million acres | 60.46 | 63.193 | 59.168 | 53.593 | 54.409 | 55.666 | 56.156
 | Harvested | Million acres | 50.999 | 55.699 | 49.893 | 47.619 | 45.705 | 48.921 | 45.157
 | Yield | Bushels per acre | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.3 | 47.2
 | Supply: Beginning stocks | Million bushels | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 717.889
 | Production | Million bushels | 2051.088 | 2499.164 | 2218.061 | 2206.916 | 1999.347 | 2266.027 | 2129.695
 | Imports 1/ | Million bushels | 112.631 | 126.971 | 118.59 | 96.92 | 112.069 | 122.756 | 170
 | Total supply | Million bushels | 2619.872 | 2931.953 | 2993.156 | 3279.473 | 2973.662 | 3131.403 | 3017.584
 | Disappearance: Food use | Million bushels | 947.865 | 926.769 | 918.92 | 925.641 | 941.387 | 944.723 | 960
 | Seed use | Million bushels | 87.615 | 78.045 | 69.471 | 70.889 | 76.199 | 73.014 | 74.493
 | Feed and residual use | Million bushels | 15.962 | 255.219 | 149.831 | 129.251 | 162.372 | 388.415 | 250
 | Total domestic use | Million bushels | 1051.442 | 1260.033 | 1138.222 | 1125.781 | 1179.958 | 1406.152 | 1284.493
 | Exports 1/ | Million bushels | 1262.612 | 1015.415 | 879.297 | 1291.446 | 1051.084 | 1007.362 | 1175
 | Total disappearance | Million bushels | 2314.054 | 2275.448 | 2017.519 | 2417.227 | 2231.042 | 2413.514 | 2459.493
 | Ending stocks | Million bushels | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 717.889 | 558.091
 | Stocks-to-use ratio |  | 13.2157 | 28.8517 | 48.3583 | 35.6709 | 33.2858 | 29.7446 | 22.6913
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 6.48 | 6.78 | 4.87 | 5.7 | 7.24 | 7.77 | 6.75-6.95
 | Government payments | Million dollars | 1118
 | Market value of production | Million dollars | 13289.326 | 16625.759 | 10654.115 | 12827.254 | 14322.909 | 17491.304 | 14588.4108
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 3/11/2014
Spreadsheet: 90691d1290464825-if-formula-not-working-powder-20logs-20workbook-1-
Sheet: Big MASTER

Big Magazine
Invoice # | [NAME] | Date | Amount In | Amount Trans. To SM. [NAME]. | Amount on hand | Remarks
 |  |  |  |  | 0
 |  |  | 27 |  | 27
 |  |  |  | 6 | 21
 |  |  | 2 | 0 | 23
 |  |  | 14 |  | 37
 |  |  |  | 4 | 33
 |  |  | 5 |  | 38