tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 784882d1655990958-moving-a-series-of-numbers-period-series
Sheet: Sheet1

Example 1
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
A | 0 | 0 | 0.1 | 0.15 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 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 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.15 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.15 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Example 2
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.05 | 0.1 | 0.15 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 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 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.1 | 0.15 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.1 | 0.15 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5
Spreadsheet: 103952d1301588038-create-macro-reimbursements-village
Sheet: Sheet1

Name: | Location | cost for reimbursement | Total(mostly for village) | Town(put $ amount in category they are) | suburb | rural | town - verify and show balance for max $1500 | suburb verfiy n show balance for  50% of amount | rural verify and show balance for [NAME] of $1000
[NAME] legend | Village | 500 | 500
Pam helgard | City | 1000 | 0 | 1000$ |  |  | show balance of $500 in this eg.
[NAME] carteier | Village | 300 | 300
Spreadsheet: 191f8fad-06ac-4754-8814-4073c076c2d7
Sheet: 2011

MATTEL, INC. AND SUBSIDIARIES
RECONCILIATION OF GAAP TO NON-GAAP FINANCIAL MEASURE
 |  |  |  |  | Three Months Ended March 31,
(In millions, except percentage information) |  |  |  |  |  | 2011 |  |  | 2010
Gross Sales |  |  |  |  | $ | 1041.1 |  | $ | 960.3
[NAME] |  |  |  |  |  | -89.2 |  |  | -80.2
Net Sales |  |  |  |  | $ | 951.9 |  | $ | 880.1
% Change |  |  |  |  |  | 0.08 |  |  | 0.12
Pos./(Neg.) Impact of Currency (in % pts) |  |  |  |  |  | 1 |  |  | 3
The financial information included herein should be read in conjunction with Mattel's consolidated financial
Reports statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form
10-Q, as applicable.
Spreadsheet: 365673d1418917055-formula-to-show-number-of-months-1st-and-last-month-inclusive-between-2-dates-example-sheet-dates
Sheet: Sheet1

SDate | Supplier | SLocation | SProduct | STonnageM | STonnage | SPrice | PeriodFrom | PeriodTo | Months | CDate | Customer | CLocation | CProduct | CTonnageM | CTonnage | CPrice | CHaul | Turnover | Profit | Status
 |  |  |  |  |  | EXAMPLE | 2014-11-01 00:00:00 | 2015-05-01 00:00:00 | 7
 |  |  |  |  |  | EXAMPLE | 2014-12-01 00:00:00 | 2014-12-01 00:00:00 | 1
 |  |  |  |  |  | EXAMPLE | 2015-05-01 00:00:00 | 2015-09-01 00:00:00 | 5
 |  |  |  |  |  | EXAMPLE | 2014-10-01 00:00:00 | 2016-02-01 00:00:00 | 17
Spreadsheet: 93200d1292801240-how-do-i-sum-up-all-cells-in-different-sheets-to-a-cell-in-sheet1-timesheet
Sheet: Sheet3

COMPANY NAME |  |  |  |  |  |  |  | EMPLOYEE TIME SHEET |  |  |  |  |  |  |  | Year 2010
DEPT.: |  | ENGINEERING |  |  |  |  |  |  | EMPLOYEE: |  |  | Employee Name |  |  |  |  | WEEK ENDING: |  |  |  | March 2 2010
 | WED |  | THUR |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | TOTAL |  |  |  | JOB
 | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. |  |  | NUMBER |  | PHASE |  | TYPE |  | JOB NAME
1 |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00Gen |  | 100 |  | OTH
 |  |  | 2 | 1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9038
 | 5 |  |  |  | 4 |  |  |  |  |  | 4 |  | 4 |  |  |  |  |  | 9046
 |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  |  |  |  |  | 10010
 | 3 | 1 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10033
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00Sick
TOT
In |  | am |  | am |  | am |  | am |  | am |  | am |  | am
Out |  | pm |  | pm |  | am |  | am |  | am |  | pm |  | am
Hrs
EMPLOYEE SIGNATURE:____________________________
SUPERVISOR SIGNATURE:__________________________
Spreadsheet: 676022d1588609860-if-form-help-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | What I want
 | Volume in Forecast | Volume in stock at factory a |  | Volume from factory a | Volume from Factory b |  |  |  | Volume from factory a | Volume from Factory b
Item a | 15000 | 12000 |  |  |  |  |  |  | 12000 | 3000
Item b | 20000 | 25000 |  |  |  |  |  |  | 20000 | 0
item c | 30000 | 23000 |  |  |  |  |  |  | 23000 | 7000
 | Should use stock in a first, then use b (b will never run out)
Spreadsheet: 15e11aaf-5b28-4536-9ab4-69fdcc040d14
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Agency Name:
Project :
Budget Line: UA | UAxx-xxxx
Date | Employee Name | Hours | [NAME] | [NAME] for Benefits (Exclude Trimet Tax & Trip) | Gross Pay | Description of Work Performed
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Total |  | 0 |  |  | 0
I hereby certify these hours to be accurate for the project noted above.
Sinature
Title
Date
Spreadsheet: mary_fischer__25410__Global Operation perf summary rpt Mar 02
Sheet: Europe

 |  |  |  |  | Draft >>>> All numbers, amounts, issues are not correct
 | EWC Fleet Operations Report – March 2002
 | Europe
 |  |  | YTD |  |  |  |  |  | Month |  |  |  |  |  |  |  |  | YTD Calculation
 | Fleet Statistics
 | Type |  | New Turbines Installed | Avg # of Turbines | Average Availability | GWh Projected | GWh Actual |  | New Turbines Installed | Avg # of Turbines | Average Availability | GWh Projected | GWh Actual |  |  |  |  |  | Jan 02 | Feb 02 | Mar 02 | Apr 02 | May 02 | Jun 02 | Jul 02 | Aug 02 | Sep 02 | Oct 02 | Nov 02 | Dec 02
 | EW 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EW 1.5 | 0.946 | 0.937 | 0.948
 | EW 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # 1.5s | 440 | 490 | 495
 | EW 600e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EW 600 | 0.991 | 0.983 | 0.993
 | EW 600a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # EW 600 | 280 | 280 | 280
 | Z 750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EW 600e | 0.981 | 0.982 | 0.972
 | Z 550 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # EW 600e | 124 | 124 | 124
 | EW 900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EW 600a | 0.951 | 0.956 | 0.98
 | Fleet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # EW 600a | 68 | 68 | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z 750
 | Warranty - Financial Measures ($ in thousands) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # Z 750
 | Type |  | Warranty Fees and Reserves Ulitized | Warranty Cost [1] | Net Warranty Expense | Cost Under (Over) Reserve Level [2] |  |  |  |  |  |  |  |  |  |  |  | Z 550 | 0.92 | 0.873 | 0.926
 | EW 1.5 |  | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | # Z 550 | 37 | 37 | 37
12 | EW 600 |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | EW 900 | 0.916 | 0.93 | 0.761
 | EW 600e |  | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | # [NAME] | 1 | 1 | 1
 | EW 600a |  | 0 | 0 |  | 0
 | Z 750 |  | 0 | 0 | 0 | 0
 | Z 550 |  |  | 0 |  | 0
 | TW 500 |  | 0 | 0 | 0 | 0
 | TW 300 |  |  | 0 |  | 0
 | TW 80 |  | 0 | 0 | 0 | 0
 | Other |  | 0 | 0 | 0 | 0
 | Totals
 | Operations - Financial Measures ($ in thousands)
 | Type |  | Gross Revenue | Expense [3] | Net Revenue | G&A &   Constr OH | EBIT
 | EW 1.5 |  | 0 | 0 |  | 0
 | EW 600 |  | 0 | 0 |  | 0
 | EW 600e |  | 0 | 0 |  | 0
 | EW 600a |  | 0 | 0 |  | 0
 | Z 750 |  | 0 | 0 | 0 | 0
 | Z 550 |  | 0 | 0 |  | 0
 | TW 500 |  | 0 | 0 | 0 | 0
 | TW 300 |  | 0 | 0 |  | 0
 | TW 80 |  | 0 | 0 | 0 | 0
 | Other |  | 0 | 0 |  | 0
 | Totals
 | Notes: | [1]  Warranty cost includes both mechanical and non-mechanical costs.
 |  | [2] The under (over) reserve is calculated based on …..
 | Key Fleet Issues - top three performance/failure issues and update on retrofit efforts
 | EW 1.5 | 1.
 |  | 2.
 |  | 3.
 | EW 600/e/a | 1.
 |  | 2.
 |  | 3.
 | Z 750 | 1.
 |  | 2.
 |  | 3.
 | Z 550 | 1.
 |  | 2.
 |  | 3.
 | TW 500 | 1.
 |  | 2.
 |  | 3.
 | TW 300 | 1.
 |  | 2.
 |  | 3.
 | TW 80 | 1.
 |  | 2.
 |  | 3.
Spreadsheet: 717541d1612726158-vlookup-filter-by-date-input-book1
Sheet: Tracker

 | Date |  | 2020-02-02 00:00:00
 | Product |  |  |  | Ref |  | A |  | B |  | C
 | Description | Key 1 | Key 2 |  | 2021-02-02 00:00:00 |  | Price | Delta | Price | Delta | Price | Delta
 | B1 | A1 |  |  | 299.99 |  |  |  |  | -0.4285238095238096 |  | -0.034448275862069
 | B2 | A2 | C2 |  | 329.99 |  |  |  |  |  |  | -0.137896551724138
 | B3 | A3 | [NAME] |  | 339.99
 | B4 | A4 |  |  | 369.99
 | B5 | A5 |  |  | 389.99 |  |  |  |  |  |  | -0.05688346883468837
 | B6 | A6 |  |  | 379.99
 | B7 | A7 |  |  | 399.99 |  |  |  |  |  |  | 0.0719489559164733
 | B8 | A8 |  |  | 409.99
 | B9 | A9 |  |  | 379.99
 | B10 | A10 |  |  | 409.99
 | B11 | A11 |  |  | 369.99 |  |  |  |  |  |  | 0.193921568627451
 | B12 | A12 |  |  | 389.99
 | B13 | A13 |  |  | 419.99 |  |  |  |  |  |  | -1.09995
 | B14 | A14 |  |  | 419.99 |  |  |  |  |  |  | 0.3805457227138643
 | B15 | A15 |  |  | 439.99 |  |  |  |  |  |  | -0.9999545454545455
 | B16 | A16 |  |  | 449.99 |  |  |  |  |  |  | -0.0440603248259861
 | B17 | A17 |  |  | 459.99 |  |  |  |  |  |  | -0.9999565217391305
 | B18 | A18 |  |  | 469.99
Spreadsheet: 803098d1667251188-combine-rows-by-fill-color-sample
Sheet: Sheet2

Row Labels | Data
[NAME] 2462 | Emtek 2462DB,, Emtek 2462FB,, Emtek 2462US7,, Emtek 2462PVD,, [NAME] 2462MB,, [NAME] 2462US10B,, [NAME] 2462US15A,, [NAME] 2462US26,, [NAME] 2462US15,, Emtek 2462SS,
Emtek 29213 | [NAME],, [NAME] 29213US10B,, [NAME] 29213US15,
[NAME] 29241 | Emtek 29241PVD,, [NAME] 29241US10B,, [NAME] 29241US15,
Emtek 29313 | Emtek 29313DB,, [NAME] 29313FB,, Emtek 29313MB,
[NAME] 76026 | Emtek 76026FBS,, [NAME] 76026SWS,
Emtek 76030 | [NAME],, Emtek 76030SS,
Emtek 76043 | [NAME] 76043FBS,, [NAME],
Emtek 8363 | Emtek 8363FBS,, [NAME] 8363SWS,
Emtek 8372 | Emtek 8372DB,, Emtek 8372FB,, Emtek 8372MB,
Emtek 86069 | Emtek 86069DB,, [NAME],
[NAME] 86088 | Emtek 86088DB,, [NAME],, [NAME] 86088MB,
Emtek 86098 | [NAME] 86098DB,, [NAME] 86098FB,, Emtek 86098MB,
Emtek 86131 | Emtek 86131US7,, [NAME] 86131US10B,, [NAME] 86131US15A,, Emtek 86131US3,, [NAME] 86131US26,, [NAME] 86131US15,, [NAME] 86131US19,
Emtek 86204 | Emtek 86204US7,, [NAME] 86204US10B,, [NAME] 86204US15A,, Emtek 86204US3,, [NAME] 86204US26,, [NAME] 86204US15,
Emtek 86210 | Emtek 86210
[NAME] EMPVL234 | [NAME],, Emtek EMPVL234S19,, Emtek EMPVL234S7,, Emtek EMPVL234S10B,, [NAME],, [NAME] EMPVL234SUS26,, [NAME],
[NAME] S86525 | Emtek S86525BLKST,, Emtek S86525BRNST,
Spreadsheet: 43323d1241975722-split-numbers-and-split-words-another-stab
Sheet: Sheet2

FN | MN | EN
333 | 222 | 222
FN |  | MN |  | EN
333 | + | 222 | + | 222 | = | 777
7 | + | 7 | + | 7 | = | 21
2 | + | 1 | = | 3
 |  |  |  | Total
Spreadsheet: 86622d1286556269-conditional-formatting-english-premier-league-2010-2011
Sheet: League Table

 | BARCLAYS  PREMIER LEAGUE TABLE 2010/2011
 | Position | Team | P | W | D | L | F | A | [NAME] | Pts | HOME GAME |  |  |  |  |  |  |  | AWAY GAME
 |  |  |  |  |  |  |  |  |  |  | P | W | D | L | F | A | [NAME] | Pts | P | W | D | L | F | A | [NAME] | Pts
 | 1 | Chelsea | 7 | 6 | 0 | 1 | 23 | 2 | 21 | 18 | 4 | 4 | 0 | 0 | 14 | 0 | 14 | 12 | 3 | 2 | 0 | 1 | 9 | 2 | 7 | 6
 | 2 | Manchester City | 7 | 4 | 2 | 1 | 9 | 3 | 6 | 14 | 4 | 3 | 1 | 0 | 7 | 2 | 5 | 10 | 3 | 1 | 1 | 1 | 2 | 1 | 1 | 4
 | 3 | [NAME] | 7 | 3 | 4 | 0 | 16 | 9 | 7 | 13 | 3 | 3 | 0 | 0 | 9 | 2 | 7 | 9 | 4 | 0 | 4 | 0 | 7 | 7 | 0 | 4
 | 4 | Arsenal | 7 | 3 | 2 | 2 | 16 | 9 | 7 | 11 | 3 | 2 | 0 | 1 | 12 | 4 | 8 | 6 | 4 | 1 | 2 | 1 | 4 | 5 | -1 | 5
 | 5 | [NAME] | 7 | 3 | 2 | 2 | 8 | 6 | 2 | 11 | 4 | 2 | 1 | 1 | 5 | 3 | 2 | 7 | 3 | 1 | 1 | 1 | 3 | 3 | 0 | 4
 | 6 | West Bromwich Albion | 7 | 3 | 2 | 2 | 9 | 12 | -3 | 11 | 4 | 2 | 2 | 0 | 6 | 3 | 3 | 8 | 3 | 1 | 0 | 2 | 3 | 9 | -6 | 3
 | 7 | Stoke City | 7 | 3 | 1 | 3 | 8 | 9 | -1 | 10 | 4 | 2 | 1 | 1 | 5 | 4 | 1 | 7 | 3 | 1 | 0 | 2 | 3 | 5 | -2 | 3
 | 8 | [NAME] | 7 | 3 | 1 | 3 | 9 | 12 | -3 | 10 | 3 | 2 | 1 | 0 | 5 | 1 | 4 | 7 | 4 | 1 | 0 | 3 | 4 | 11 | -7 | 3
 | 9 | Blackpool | 7 | 3 | 1 | 3 | 11 | 15 | -4 | 10 | 2 | 0 | 1 | 1 | 3 | 4 | -1 | 1 | 5 | 3 | 0 | 2 | 8 | 11 | -3 | 9
 | 10 | Fulham | 7 | 1 | 6 | 0 | 8 | 7 | 1 | 9 | 3 | 1 | 2 | 0 | 4 | 3 | 1 | 5 | 4 | 0 | 4 | 0 | 4 | 4 | 0 | 4
 | 11 | Sunderland | 7 | 1 | 5 | 1 | 7 | 7 | 0 | 8 | 4 | 1 | 3 | 0 | 4 | 3 | 1 | 6 | 3 | 0 | 2 | 1 | 3 | 4 | -1 | 2
 | 12 | [NAME] | 7 | 1 | 5 | 1 | 10 | 11 | -1 | 8 | 3 | 0 | 3 | 0 | 4 | 4 | 0 | 3 | 4 | 1 | 2 | 1 | 6 | 7 | -1 | 5
 | 13 | [NAME] | 7 | 2 | 2 | 3 | 7 | 8 | -1 | 8 | 3 | 1 | 1 | 1 | 3 | 3 | 0 | 4 | 4 | 1 | 1 | 2 | 4 | 5 | -1 | 4
 | 14 | Wigan Athletic | 7 | 2 | 2 | 3 | 4 | 13 | -9 | 8 | 5 | 1 | 1 | 3 | 3 | 13 | -10 | 4 | 2 | 1 | 1 | 0 | 1 | 0 | 1 | 4
 | 15 | Newcastle United | 7 | 2 | 1 | 4 | 10 | 10 | 0 | 7 | 3 | 1 | 0 | 2 | 7 | 4 | 3 | 3 | 4 | 1 | 1 | 2 | 3 | 6 | -3 | 4
 | 16 | Birmingham City | 7 | 1 | 4 | 2 | 7 | 10 | -3 | 7 | 4 | 1 | 2 | 1 | 2 | 3 | -1 | 5 | 3 | 0 | 2 | 1 | 5 | 7 | -2 | 2
 | 17 | Everton | 7 | 1 | 3 | 3 | 6 | 7 | -1 | 6 | 3 | 0 | 2 | 1 | 4 | 5 | -1 | 2 | 4 | 1 | 1 | 2 | 2 | 2 | 0 | 4
 | 18 | Liverpool | 7 | 1 | 3 | 3 | 7 | 11 | -4 | 6 | 4 | 1 | 2 | 1 | 5 | 5 | 0 | 5 | 3 | 0 | 1 | 2 | 2 | 6 | -4 | 1
 | 19 | [NAME] | 7 | 1 | 2 | 4 | 7 | 12 | -5 | 5 | 3 | 1 | 1 | 1 | 4 | 4 | 0 | 4 | 4 | 0 | 1 | 3 | 3 | 8 | -5 | 1
 | 20 | West Ham United | 7 | 1 | 2 | 4 | 5 | 14 | -9 | 5 | 4 | 1 | 1 | 2 | 4 | 7 | -3 | 4 | 3 | 0 | 1 | 2 | 1 | 7 | -6 | 1
 |  | UEFA Champions League
 |  | UEFA Champions League Qualifiers
 |  | UEFA Europa League
 |  | Relegation
Spreadsheet: 880968d1728867506-conditional-formatting-cf
Sheet: Sheet1

A | B | C
Week-1 | UNIT-1.1 | MLU-1.1.1
Week-1 | UNIT-1.1 | [NAME]
Week-1 | UNIT-1.1 | MLU-1.1.3
Week-1 | UNIT-1.2 | MLU-1.2.1
Week-1 | UNIT-1.2 | MLU-1.2.2
Week-1 | UNIT-1.2 | MLU-1.2.3
Week-1 | UNIT-1.2 | MLU-1.2.4
Week-1 | UNIT-1.2 | MLU-1.2.5
Week-1 | UNIT-1.2 | MLU-1.2.6
Week-1 | UNIT-1.3 | MLU-1.3.1
Week-1 | UNIT-1.3 | MLU-1.3.2
Week-1 | UNIT-1.3 | MLU-1.3.3
Week-1 | UNIT-1.3 | MLU-1.3.4
Week-1 | UNIT-1.3 | MLU-1.3.5
Week-2 | UNIT-2.1 | MLU-2.1.1
Week-2 | UNIT-2.1 | MLU-2.1.2
Week-2 | UNIT-2.1 | MLU-2.1.3
Week-2 | UNIT-2.1 | MLU-2.1.4
Week-2 | UNIT-2.1 | MLU-2.1.5
Week-2 | UNIT-2.2 | MLU-2.2.1
Week-2 | UNIT-2.2 | MLU-2.2.2
Week-2 | UNIT-2.2 | MLU-2.2.3
Week-2 | UNIT-2.2 | MLU-2.2.4
Week-2 | UNIT-2.2 | MLU-2.2.5
Week-2 | UNIT-2.2 | MLU-2.2.6
Week-2 | UNIT-2.3 | MLU-2.3.1
Week-2 | UNIT-2.3 | MLU-2.3.2
Week-2 | UNIT-2.3 | MLU-2.3.3
Week-3 | UNIT-3.1 | MLU-3.1.1
Week-3 | UNIT-3.1 | MLU-3.1.2
Spreadsheet: 674025d1587638127-issue-with-excel-solver-for-optimizing-smoothning-constant-in-winthers-forecasting-model-forecasting-case-thomas
Sheet: Moving Average

 |  |  |  | Level (BP) | Level (CP) | Forcast (BP) | Forcast (CP) | Error (BP) | Error (CP) | Absolute Error (BP) | Absolute Error (CP) | MSE (BP) | MSE (CP) | MAD (BP) | MAD (CP) | % Error (BP) | % Error (CP) | MAPE (BP) | MAPE (CP) | TS (BP) | TS (CP)
Spreadsheet: 454865d1460011641-formula-to-match-and-populate-sample-13-
Sheet: Sheet2

Full Name | SSN | Department
a,MATTHEW K | 555555555 | ENGINEERING
a,WANDA J | 111111111 | COUNT ROOMS
a,SERIAH | 222222222 | ROOM SERVICE
a,CARLOS E | 666666666 | IT OPERATIONS
a,NANCY L | 777777777 | ACCOUNTING
a,LILIA | 888888888 | STEWARDING
a,MARIA L | 999999999 | GOLDFIELDS
Spreadsheet: 287931d1389038013-time-problem-in-general-format-time-1-
Sheet: Sheet1

209 | 1
210 | 1
215 | 2
218 | 2
219 | 2
226 | 2
230 | 1
231 | 2
234 | 1
238 | 1
239 | 2
243 | 2
244 | 1
246 | 1
260 | 1
261 | 1
262 | 1
272 | 1
273 | 2
274 | 1
276 | 2
279 | 2
281 | 1
282 | 1
283 | 1
285 | 1
287 | 2
288 | 1
289 | 1
291 | 2
294 | 2
295 | 2
312 | 2
316 | 1
318 | 1
320 | 2
321 | 2
325 | 2
328 | 1
331 | 1
332 | 1
336 | 2
339 | 1
346 | 1
349 | 1
352 | 2
353 | 2
354 | 2
356 | 1
360 | 1
362 | 1
Spreadsheet: 63501d1264432577-calculating-percent-in-excel-2003-sample
Sheet: Sheet1

Overall Satisfaction | Overall Value
4 | 1
2 | 3
4 | 1
2 | 2
2 | 2
1 | 1
4 | 2
2 | 2
3 | 2
3 | 1
2 | 1
3 | 2
2 | 1
2 | 3
3 | 2
3
2 | 2
3
3 | 1
1 | 1
4
4 | 4
3 | 2
 | 2
3 | 4
4 | 1
2 | 2
2 | 2
2 | 3
2 | 3
2 | 1
3 | 2
3 | 2
1 | 1
4 | 2
2 | 2
1 | 1
2 | 1
4 | 2
2 | 1
2 | 2
3 | 3
1 | 2
3 | 2
4 | 1
2 | 1
3 | 1
1 | 1
2 | 2
3 | 2
2 | 2
1 | 1
Spreadsheet: 685788d1594198978-split-5-parameters-separated-by-and-into-series-of-columns-pq-5-parameter-test-aligw
Sheet: Result

Product | 1.1 | 1.2 | 1.3 | 2.1 | 2.2 | 2.3 | 3.1 | 3.2 | 3.3 | 4.1 | 4.2 | 4.3 | 5.1 | 5.2 | 5.3
101 | 0219A | 0219B | 0219C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
102 | 0220A | 0220B | 0220C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
103 | 0221A | 0221B | 0221C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
Product | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | 1.6 | 2.1 | 2.2 | 2.3 | 2.4 | 2.5 | 2.6 | 3.1 | 3.2 | 3.3 | 3.4 | 3.5 | 3.6 | 4.1 | 4.2 | 4.3 | 4.4 | 4.5 | 4.6 | 5.1 | 5.2 | 5.3 | 5.4 | 5.5 | 5.6
101 | 0219A | 0219B | 0219C | 0219C | 0219C | 0219A | 1 | 3 | 2 | 2 | 2 | 1 | January | February | March | March | March | January | PC | PC | PM | PM | PM | PC | 4 | 2 | 2 | 2 | 2 | 4
102 | 0220A | 0220B | 0220C | 0220C | 0220C | 0220A | 1 | 3 | 2 | 2 | 2 | 1 | January | February | March | March | March | January | PC | PC | PM | PM | PM | PC | 4 | 2 | 2 | 2 | 2 | 4
103 | 0221A | 0221B | 0221C | 0221C | 0221C | 0221A | 1 | 3 | 2 | 2 | 2 | 1 | January | February | March | March | March | January | PC | PC | PM | PM | PM | PC | 4 | 2 | 2 | 2 | 2 | 4
Spreadsheet: 740290d1626270311-trying-to-interpolate-a-table-help-please-js-edit
Sheet: Sheet1

Altitude (1,000ft) | Weight (tonnes)
 | 85 | 80 | 75 | 70 | 65 | 60 | 55 | 50 | 45 | 40
41 |  |  |  |  | 30 | 7 | 0 | 4 | 16 | 33
 |  |  |  | 22 | 4 | 0 | 4 | 15 | 30 | 45
 |  | 37 | 14 | 2 | 0 | 5 | 15 | 28 | 43 | 56
 | 23 | 7 | 0 | 0 | 6 | 16 | 28 | 41 | 54 | 64
 | 2 | 0 | 2 | 8 | 18 | 29 | 41 | 53 | 62 | 68
 | 0 | 4 | 11 | 21 | 31 | 42 | 52 | 61 | 67 | 70
 | 7 | 15 | 24 | 34 | 43 | 53 | 61 | 67 | 70 | 70
 | 19 | 27 | 36 | 45 | 54 | 61 | 66 | 70 | 70 | 68
 | 31 | 40 | 48 | 55 | 62 | 67 | 70 | 70 | 69 | 64
 | Question
 | What value is obtained from the table for a aircraft weight of 58 tonnes at a altitude of 32,000ft?
 | Manual caluclation
 | - Interpolate between 60 & 55 tonnes for both 33,000 and 31,000ft.
 | - copying data from the table and interpolating for 58 tonnes on the x axis
 |  | 60 | 55 | 58
 | 33 | 29 | 41
 | 31 | 42 | 52
 | - now interpolating the 58 tonne data in the Y axis
 |  | 58
 | 33
 | 32
 | 31
 | - Answer is 41.1
 | Now how do I build a workbook such that I can have input fields for weight and altitude and a forumla calculates the correct output
Spreadsheet: 870252d1716799419-sumproduct-formula-not-giving-any-results-excel-help-with-formulas-2-aligw
Sheet: List

Contracts |  | Reason for Days Lost
 |  | Down time reasons
Contract B |  | X
Contract C |  | WEATHER
Contract D |  | TRUCK BREAK DOWN
Contract E |  | AGENCY CREW ISSUE
Contract F |  | CONTRACT
Contract G |  | WORKSHOP
Contract H |  | UNIT BREAKDOWN
Contract I |  | AVALIBLE FOR CONTRACT
Contract j |  | VELOCITY CREW ISSUE
Contract K |  | SPARE ON CONTRACT
Contract L |  | CREW TRAVEL
Contract M |  | MATERIAL ISSUE
Contract N
Contract O
Contract P
Contract Q
0
Spreadsheet: 78817d1279124115-excel-create-custom-formula-within-pivot-table-average-example-pivot-table
Sheet: Raw - Data

 |  | Scores given from Customer on Tech (1-10 Scale)
Work Order # | Tech # | Statusing | Appearance | Clean Up | Verify System | Explain Basic
24175643600002001 | 010434315 | 10 | 10 | 10 | 10 | 10
24558261600083001 | 010439230 | 10 | 10 | 10 | 10 | 10
24426165200063010 | 010439857 | 10 | 10 | 10 | 7 | 10
24426622000007011 | 010436895 | 10 | 10 |  |  | 5
24426220700008013 | 010434011 | 10 | 10 | 10 | 10 | 10
24416420000077001 | 010439857 | 10 | 10 | 10 | 10 | 10
24572613900000013 | 010439889 | 10 | 8 | 10 | 10 | 10
24055600200006001 | 010436895 | 8 | 8 | 8 | 9 | 8
24151374105032017 | 010438940 | 10 | 10 |  |  | 10
24112763400004024 | 010438940 | 10 | 10 | 10 | 10 | 10
24426540300018021 | 010434011 | 1 | 10 | 8 | 10 | 10
24501551100018001 | 010436687 | 10 | 10 | 10 | 10 | 10
24065352600014001 | 010432971 | 10 | 10 | 10 | 10 | 10
24153544400012001 | 010439568 | 10 | 10 | 10 | 10 | 10
24153161000038001 | 010434315 | 10 | 10 | 10 | 10 | 10
24577304000010007 | 010439230 | 10 | 10 | 10 | 10 | 10
24416454400029004 | 010439568 | 10 | 10 | 10 | 10 | 10
24572262700040004 | 010432971 | 10 | 8 |  |  | 8
24055305900017002 | 010430500 | 10 | 10 |  |  | 10
24055600200014001 | 010430500 | 10 | 10 | 10 | 10 | 10
24104354400014006 | 010439829 | 10 | 10 | 10 | 10 | 10
24065351400002001 | 010439568 | 10 | 10 | 10 | 10 | 10
24121522200019001 | 010439829 | 10 | 10 | 10 | 10 | 10
23934241000010001 | 010439230 | 10 | 10 | 10 | 10 | 10
24416200400067001 | 010434011 | 10 | 10 | 10 | 10 | 10
24450713100005007 | 010434011 | 10 | 8 |  |  | 1
24426751900001039 | 010436687 | 10 | 8 | 10 | 10 | 10
24563213805160001 | 010439889 | 7 | 10 | 10 | 10 | 10
24502130100008001 | 010436895 | 10 | 10 | 10 | 10 | 10
24141808600005003 | 010436835 | 10 | 10 | 10 | 10 | 10
23947504500005004 | 010439230 | 10 | 10 |  |  | 10
24416120705066005 | 010434011 | 10 | 10 | 10 | 10 | 10
24502281000072001 | 010431849 | 10 | 10 | 9 | 10 | 10
24502220000027002 | 010434315 | 10 | 10 | 10 | 10 | 10
24502163700039004 | 010436524 | 10 | 10 |  |  | 10
24517103600024003 | 010436524 | 10 | 10 |  |  | 10
24092372400001012 | 010436895 | 10 | 10 |  |  | 10
24092393500003001 | 010436895 | 10 | 10 | 10 | 10 | 10
24018373300007046 | 010436895 | 10 | 10 | 10 | 10 | 10
24067570800012012 | 010434315 | 10 | 10 |  |  | 10
24175626500005030 | 010432971 | 10 | 10 | 10 | 10 | 10
24426751900001040 | 010434011 | 10 | 10 |  |  | 10
Spreadsheet: 723088d1615503601-annual-pay-raise-formula-to-add-to-personnel-budget-costs-payroll-annual-raises-formula
Sheet: Personnel

 | Job Title | Employee Name | Status | Hire Date | Term Date | Annual Pay | FT or PT | [NAME] or Hourly | [NAME] |  | 2019-01-01 00:00:00
 | Art Director |  | Filled | 2018-07-15 00:00:00 | 2020-01-31 00:00:00 | 150000 | FT | Salary
 | Senior Marketing Manager |  | Filled | 2019-03-20 00:00:00 |  | 150000 | FT | Salary
 | VP Product |  | Filled | 2021-02-01 00:00:00 |  | 150000 | FT | Salary
 | Annual raises on anniversary date of hire: |  | 0.03
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Central Gas

Central Gas
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Luce* |  | Gas |  | Central
Pollan |  | Gas |  | Central Gas |  | 1019012
Frinhart |  | Gas |  | Central Gas |  | 273427
Carrabine |  | Gas |  | Central Gas
[NAME] |  | Gas |  | Central Gas |  | 69232.21
Penman |  | Gas |  | Central Gas |  | 32100
Thurston |  | Gas |  | Central Gas |  | 21455
Otto |  | Gas |  | Central Gas |  | 10775
[NAME] |  | Gas |  | Central Gas |  | 9125
Giron |  | Gas |  | Central Gas |  | 1405
Total
*$6,419,391 of total is Ennovate and runs through the trading line of the DPR.