tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106403d1303642789-time-calculations-testbook1
Sheet: Blad1

 |  | weekschedule group 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | week: | 18 | date: | 2011-05-02 00:00:00
 | Monday |  |  | absence |  | car 1 |  | car 2 |  | car 3 |  | car 4 |  | car 5 |  | car 6 |  | car 7 |  | worked time
 |  |  |  | sick? |  | start | stop | start | stop | start | stop | start | stop | start | stop | start | stop | start | stop | hh:[NAME] | deci
 | Groupleader 1 |  | am |  |  | 07:00:00 | 16:00:00 |  |  |  |  |  |  | 03:30:00 | 05:45:00
 |  |  | pm
 | Driver 2 |  | am |  |  |  |  | 11:00:00 | 20:00:00 |  |  |  |  | 06:15:00 | 08:00:00
 |  |  | pm
 | Driver 3 |  | am |  |  |  |  |  |  |  |  |  |  | 08:30:00 | 10:30:00
 |  |  | pm |  |  |  |  |  |  | 14:00:00 | 23:00:00
 | Driver 4 |  | am |  |  |  |  |  |  |  |  |  |  | 10:45:00 | 11:50:00
 |  |  | pm |  |  |  |  |  |  |  |  | 15:00:00 | 01:00:00
 | Driver 5 |  | am | 8:00:00
 |  |  | pm
 | Driver 6 |  | am
 |  |  | pm |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 17:30:00 | 21:00:00 | 07:00:00
 | Driver 7 |  | am
 |  |  | pm |  |  | 16:15:00 | 18:30:00 |  |  |  |  |  |  |  |  |  |  | 23:00:00 | 08:00:00
 | sum / car /day
 | Tuesday |  |  | absence |  | car 1 |  | car 2 |  | car 3 |  | car 4 |  | car 5 |  | car 6 |  | car 7 |  | worked time
 |  |  |  | sick? |  | start | stop | start | stop | start | stop | start | stop | start | stop | start | stop | start | stop | hh:[NAME] | deci
 | Groupleader 1 |  | am
 |  |  | pm
 | Driver 2 |  | am
 |  |  | pm
 | Driver 3 |  | am |  |  |  |  |  |  | 08:45:00 | 19:50:00
 |  |  | pm |  |  |  |  |  |  |  |  |  |  | 20:00:00 | 02:30:00
 | Driver 4 |  | am
 |  |  | pm
 | Driver 5 |  | am | 8:00:00
 |  |  | pm
 | Driver 6 |  | am
 |  |  | pm
 | Driver 7 |  | am
 |  |  | pm
 | sum / car /day
 | total sum
Spreadsheet: 288645d1389266646-formula-correction-sales-2013-2014-kym-edit
Sheet: Master Copy

 | Date | Clients Name | Code | Invoice No | Net | VAT | Gross | Date Paid | Total Paid | MOP
 |  |  |  |  |  |  |  |  |  |  |  | Total Net
 |  |  |  |  |  |  |  |  |  |  |  | Total VAT
 |  |  |  |  |  |  |  |  |  |  |  | Total Gross
 |  |  |  |  |  |  |  |  |  |  |  | Total Paid
 |  |  |  |  |  |  |  |  |  |  |  | Company Totals (Net)
 |  |  |  |  |  |  |  |  |  |  |  | D E & J Levy
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Arriva PLC
 |  |  |  |  |  |  |  |  |  |  |  | Atomico
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Dragon Properties
 |  |  |  |  |  |  |  |  |  |  |  | Gio-Goi
 |  |  |  |  |  |  |  |  |  |  |  | Jones [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | KCEC
 |  |  |  |  |  |  |  |  |  |  |  | P&O Estates Ltd
 |  |  |  |  |  |  |  |  |  |  |  | YRM Uk Ltd
 |  |  |  |  |  |  |  |  |  |  |  | Wonderland WPA
 |  |  |  |  |  |  |  |  |  |  |  | Euro Commercial
 |  |  |  |  |  |  |  |  |  |  |  | Nadfas
 |  |  |  |  |  |  |  |  |  |  |  | Skillset
 |  |  |  |  |  |  |  |  |  |  |  | Drivebusiness
 |  |  |  |  |  |  |  |  |  |  |  | Cleanse
 |  |  |  |  |  |  |  |  |  |  |  | 9 Albion Archway
 |  |  |  |  |  |  |  |  |  |  |  | Thornesett Development
 |  |  |  |  |  |  |  |  |  |  |  | Arthurell & Kirkland LLP
 |  |  |  |  |  |  |  |  |  |  |  | Cleanmail Solutions
 |  |  |  |  |  |  |  |  |  |  |  | Inis Developments
 |  |  |  |  |  |  |  |  |  |  |  | Camino
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | First Asset Management
 |  |  |  |  |  |  |  |  |  |  |  | Urban Kings
 |  |  |  |  |  |  |  |  |  |  |  | Mr [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 583682d1532588242-vlookup-using-2-columns-stocktake
Sheet: Data Entry

UniqueItemCode | EAN | ItemDescription |  | Qty
IS106 |  | LAVISH TOILET BOWL CLEANER 5 LITRE |  |  |  |  |  |  |  | UniqueItemCode |  | Input Data
[NAME] | 5707283538538 | HANDI WIPES |  |  |  |  |  |  |  | EAN | 8805806400786 | Input Data
IS108 | 79814382802127 | DUST PAN
IS109 |  | STEEL WOOL
IS216 | 8805806400786 | PRINTEC BARCODE LABELS 30UPS 150448
IS217 | 6935834003948 | NAME STAND 150 x 80mm
IS218 |  | PO170 POST FIJI SUMMARY PAD
IS219 |  | PF DELIVERY BOOK
IS220 |  | RUBBISH BIN C-706
IS222 |  | TAG RED - AV 8
IS223 |  | CLEAR PLASTIC BAGS - REGISTERED ARTICLES LG-48.5x54x250PCS
IS224 |  | CLEAR PLASTIC BAGS- REGISTERED ARTICLES M-25.5x43x500PCS
IS225 |  | SS26 KWNEW STAPLER
IS226 | 7899050528786 | SCISSORS CHN 8 INCH JNTY
Spreadsheet: d5f0894a-1f10-4dce-9840-450a20d9de41
Sheet: Sheet1

Point Count | FPS VB | FPS SciChart Line | FPS SciChart Line Opt | SciChart Perf Improvement (%)
50 | 44.83 | 39.57 | 61.05
 | 46.87 | 39.94 | 61.19
 | 54.09 | 39.51 | 62.54
 | 52.76 | 37.21 | 62.24
 | 52.02 | 28.78 | 62.08
 | 47.22 | 27.25 | 60.78
 | 39.57 | 17.65 | 61.19
 | 30.67 | 11.17 | 55.02
 | 19.92 | 6.28 | 41.22
20000 | 13.52 |  | 31.19
 | 10.66 | 2.9 | 26.65
40000 | 7.33 |  | 18.85
80000 | 3.53 |  | 12.24
160000 | 1.68 |  | 5.83
Point Count | [NAME] | SciChart Scatter
50 | 39.94 | 54.1
100 | 43.17 | 55.49
 | 50.67 | 46.29
 | 52.98 | 51.89
 | 45.46 | 42.18
 | 36.84 | 37.16
 | 27.34 | 28.3
 | 17.76 | 15.67
Spreadsheet: 122230d1316684241-re-extracting-data-from-multiple-sheets-rows-example
Sheet: Sheet1

Number | Date | Name | Random | Job | Business | Unit | Service | FT? | Random2 | Random3 | Location | Random4
1 | 2011-09-20 00:00:00 | [NAME] | 1 | Job 1 | D | A | A | FT | 1 | 1 | London | 1
2 | 2011-09-12 00:00:00 | [NAME] | 2 | Job 2 | F | B | A | FT | 2 | 2 | Rome | 2
3 | 2011-04-07 00:00:00 | [NAME] | 3 | Job 3 | E | C | B | FT | 3 | 3 | Paris | 3
4 | 2011-03-02 00:00:00 | [NAME] | 4 | Job 4 | D | A | C | FT | 4 | 4 | New York | 4
5 | 2011-03-01 00:00:00 | [NAME] | 5 | Job 5 | E | B | B | PT | 5 | 5 | Sydney | 5
6 | 2010-11-10 00:00:00 | [NAME] | 6 | Job 6 | D | C | A | FT | 6 | 6 | Beijing | 6
7 | 2009-07-07 00:00:00 | [NAME] | 7 | Job 7 | F | A | A | PT | 7 | 7 | Madrid | 7
Spreadsheet: 105818d1303117294-display-data-from-1-sheet-to-another-sheet-automatically-sample-1000-
Sheet: Cork

cork
4:25  Cork | Cork | Hurdle | 0 | 0
4:55  Cork | Cork | Hurdle | 0 | 0
5:25  Cork | Cork | Hurdle | 0 | 0
5:55  Cork | Cork | Hurdle | 0 | 0
6:25  Cork | Cork | Hurdle | 0 | 0
6:55  [NAME] | Cork | Flat | 0 | 0
Spreadsheet: b29641ab-2be7-406e-96c7-c166d062f293
Sheet: Reserve Zone

Reserve Market Zonal Summary Report
[NAME]
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  |  |  | Forward Reserve |  |  |  |  | RT Reserve | Forward Reserve Dollars |  |  |  |  | RT Reserve Dollars
Trading Interval | Reserve Zone ID | Reserve Zone Name | Product Type | Forward Reserve Market Monthly Clearing Price | Monthly Capacity Price | Delivery Hours in Month | Forward Reserve Payment Rate | Forward Reserve Obligation | Real-Time Reserve Market Clearing Price | Forward Reserve Credit | Forward Reserve Failure-to-Reserve Penalty | Forward Reserve Failure-to-Activate Penalty | Forward Reserve Obligation Charge | Net Forward Reserve Credit | Real-Time Reserve Credit | Final Forward Reserve Obligation Charge | Net Real-Time Reserve Credit | Final Forward Reserve Failure-to-Reserve Penalty Exempt MWs
Hour End | Number | String | String | $/MW-Month | $/MW-Month | Number | $/MWh | MWh | $/MWh | $ | $ | $ | $ | $ | $ | $ | $ | MWh
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE]
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 767398d1644441757-calculating-time-difference-of-warehouse-picking-rate-using-line-data-sample-data
Sheet: Data

Csgno | Pick Start Date | Start Pick Time | Pack End Date | Pack End Time | Packer
4071990 | 2022-02-08 00:00:00 | 06:47:21 | 2022-02-08 00:00:00 | 08:04:35 | BBE
4071995 | 2022-02-08 00:00:00 | 06:47:23 | 2022-02-08 00:00:00 | 07:29:45 | BBE
4072040 | 2022-02-08 00:00:00 | 06:47:22 | 2022-02-08 00:00:00 | 07:40:25 | BBE
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-08 00:00:00 | 09:00:24 | 2022-02-08 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-09 00:00:00 | 09:00:24 | 2022-02-09 00:00:00 | 10:45:12 | ACU
4072177 | 2022-02-09 00:00:00 | 09:00:24 | 2022-02-09 00:00:00 | 10:45:12 | ACU
4072224 | 2022-02-08 00:00:00 | 19:47:30 | 2022-02-08 00:00:00 | 19:55:31 | CGR
4072224 | 2022-02-08 00:00:00 | 19:47:30 | 2022-02-08 00:00:00 | 19:55:31 | CGR
4072470 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:11:05 | CGR
4072478 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:20:34 | CGR
4072478 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:20:34 | CGR
4072487 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:27:39 | CGR
4072499 | 2022-02-08 00:00:00 | 11:10:29 | 2022-02-08 00:00:00 | 11:29:02 | CGR
 |  | NOTE: For starting time and end time, ignore number of seconds in formulations and please just consider hours and minutes
 |  | BBE has packed 3 lines. He started packing at 6.47 and finished the last line at 8.04. Therefore he took 1 hour and 17 mins to complete all those lines
 |  | ACU packed 3 lines, started at 9 and finished at 10.45, so took 1 hr 45 minutes to pack all 3 lines, but he did this over 2 different days, so each day requires it’s own separate data
 |  | CGR packed 5 lines, but the first 2 were started at 19.47 and finished at 19.55, so took 8 minutes, but the other 5 started at 11.10 and finished at 11.29 and so took 19 minutes. Therefore he packed a total of 7 lines and took a total 27 minutes to pack them
 | Table Required to show answers, ideally placed into a separate tab. Could this be done in a Pivot table so it was automated??
 | Packer | Date | Number of Lines Picked | Total Time Taken
 | BBE | 2022-02-08 00:00:00 | 3 | 1:17:00
 | ACU | 2022-02-08 00:00:00 | 2 | 1:45:00
 | ACU | 2022-02-09 00:00:00 | 2 | 1:45:00
 | CGR | 2022-02-08 00:00:00 | 7 | 0:27:00
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: Assembly

Detail No. | Quantity | [NAME] | Fitting Components Together | Adhesives | Painting | Marking Up | Boxing | Calibrating | Labelling | Wrapping & Packing | Lifting | Quality Review Assessment | Other | Total Time (hours) | NOTES
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
. |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0
Spreadsheet: 150841d1334690889-rounded-off-results-sample-1
Sheet: Price

Product | Leather | Paper | Laminated | Format | SpreadsNumber | Cost | Column1
CL1 | a | SILK | 0 | 6X8 | 20 | 33.45
CL1 | b | SILK | 0 | 6X8 | 25 | 65.25
CL1 | c | SILK | 0 | 6X8 | 30 | 20.1
CL1 | d | SILK | 0 | 6X8 | 35 | 20.1
CL1 | e | SILK | 0 | 6X8 | 40 | 20.1
CL1 | f | SILK | 0 | 6X6 | 20 | 33
CL1 | g | SILK | 0 | 6X6 | 25 | 20.1
CL1 | h | SILK | 0 | 6X6 | 30 | 5
CL1 | I | SILK | 0 | 6X6 | 35 | 20.1
CL1 | l | SILK | 0 | 6X6 | 40 | 20.1
CL1 | l | SILK | 0 | 8X6 | 20 | 444.22
CL1 | m | SILK | 0 | 8X6 | 25 | 20.1
CL1 | n | SILK | 0 | 8X6 | 30 | 20.1
CL1 | o | SILK | 0 | 8X6 | 35 | 7
CL1 | p | SILK | 0 | 8X6 | 40 | 20.1
Spreadsheet: 8f389f25-9acc-4154-af62-429c0bcc6555
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (6 [NAME]):
 | 2 Analytik 2.8 Mikroskope und optische Bildverarbeitung 2.8.10 Rasterelektronenmikroskope (REM)
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | EDAX - Ametek GmbH | Deutschland | Wiesbaden | 65205 | A2.201/302
2 | EO Elektronen-Optik- Service GmbH | Deutschland | Dortmund | 44319 | A2.522
3 | RJL Micro & Analytic GmbH | Deutschland | Karlsdorf-Neuthard | 76689 | A1.531B
4 | TESCAN, a.s. | Tschechien | Brno | 623 00 | A2.522
5 | Uwe Binninger Analytik | Deutschland | Schwäbisch Gmünd | 73527 | A2.426
6 | [NAME] MicroImaging GmbH | Deutschland | Jena | 07745 | A2.111/210
Spreadsheet: 83570d1283530043-would-like-help-setting-up-this-quotation-to-invoicing-conversion-quotation1
Sheet: Mr & Mrs McA

 |  |  | QUOTE
TO | Customer Name |  | FROM | Our Company Name
 | Address Line 1 |  |  | Address Line 1
 | Address Line 2 |  |  | Address Line 2
 | Address Line 3 |  |  | Telephone & Fax
 | Postal code |  |  | Our Email
Invoice No: | -
Date: | 2010-09-03 00:00:00
Acc Ref: | -
REFERENCE |  |  |  | DATE | DUE DATE
Quote for Rewire
JOB ADDRESS
Street:
Town:
City:
Postcode:
[NAME]
To rewire lights and sockets excluding kitchen.
Replace switches and sockets with standard.
Replace pendents & batons where required.
Replace distribution board with 17th edition board.
Ensure protective bonded is complying with BS 7671
Test and certified in accordance with BS 7671
 |  |  |  | TOTAL | 2200
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: EOL Support

 | EOL Support
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  |  | Per HC | New HC | Adj Comp | 2002
 |  | YTD Actual |  | Forecast |  | Forecast |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Analyst & Associate | 0 |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  | 28060.2 |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  | 374136
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Admins | 48000 | 2
ENATECH | Technology |  |  |  |  |  |  |  |  | Staff | 49200 | 7
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Analysts | 57600 | 3
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  |  | Specialist | 62400 | 8
ENATAXES | Taxes Other than Income |  |  |  |  | 0 |  |  |  | Sr Specialist | 74400 | 7
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Managers | 96000 | 8
 |  |  |  |  |  |  |  |  |  | Directors | 120000 | 3
 | Headcount |  |  | 114 |  |  |  |  |  | Sr Director | 156000 | 0
 |  |  |  |  |  |  |  |  |  | Vice President | 204000 | 1
 | A&A Headcount |  |  | 4 |  |  |  |  |  | [NAME] | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 179185d1347050017-move-data-form-row-to-column-tonnage
Sheet: SHEET 1

DATE | SHIFT | HOURS | DOWN TIME | RUNNING TIME |  | T/P/H |  |  |  |  | DATES 1/8/12 - 4-8/12
 |  | 12:00:00 |  |  | 100
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 |  | 12:00:00
 | TOTAL HOURS TIME |  | TOTAL RUNNING TIME |  | TOTAL TONNES | T/P/H
A
B
C
D
E
I WANT TO BE ABLE TO FILL OUT THE TOP SECTION, AND THEN GET THE DATA IN THE ROW, TO AUTO MOVE  TO THE CORRECT COLUMN, IN THE BOTTOM SECTION, DEPENDING ON WHAT LETTER I PUT IN THE SHIFT COLUMN, THERE MAY BE MORE THAN ONE ROW PER SHIFT, SO THE BOTTOM SECTION, NEEDS TO ADD UPTO 4 ROWS, HOPE THIS MAKES SENSE
Spreadsheet: 63993d1264847549-excel-2007-calculating-number-of-units-without-vlookup-comp-sci-good
Sheet: Sheet3

Math 1f03 | 3 units
What | My grade | Scheme 1 | Scheme 2 | Earned
Final Exam |  | 25 | 40 | 0
Test 1 | 0.65 | 25 | 20 | 16.25
Test 2 | 1 | 25 | 20 | 25
Test 3 | 1 | 25 | 20 | 25
Subtotal | 66.25 | 53
Test | 66.25 | out of | 75 | 0.8833333333333333
Exam | 0 | out of | 0 | 0
 |  | 0.8833333333333333
Spreadsheet: 158490d1338281472-reverse-horizontal-lookup-from-a-vertical-code-ys0fbqoh7iqdmnj-copy
Sheet: Sheet1

Code | Assets |  |  |  |  |  | Liabilities |  |  | Other |  |  | Transactions
Code | Product1 | Product2 | Product3 | Product4 | Product5 | Product6 | Product7 | Product8 | Product9 | Product10 | Product11 | Product12 | Product13 | Product14
123 | 19768.32 | 623635.6036335983 |  | 89912.242022 | 2320 |  | 40408.74021732264 | 2712.085821008514 | 4026.272246311245 |  |  | 48922.16474468567 | 7899.74 | 17426.831622997
345 | 23552.64 | 150901.3121486976 | 224964.2984347449 | 122280.833132 | 960 |  | 86202.99064172842 | 19119.26626846797 | 3797.995496426 |  |  | 30003.13852394901 | 19956.02 | 33340.16549879903
789 | 25850.88 | 594848.1678111497 | 272426.2247639535 | 63945.08658800001 | 3360 |  | 129587.0325181295 | -620.1170811373916 | 45138.83790826312 |  |  | 63798.41834619919 | 24589.74 | 149742.3556213533
1011 | 4872.959999999999 | 59835.83350716323 |  | 79018.35302 | 960 |  | 50229.57649032576 | -1150.0609635847 | 19554.08834650903 |  |  | 7188.295880108656 | 24083.03 | 23028.72962532401
1213 | 26732.16 | 237585.2559051067 | 69437.95702589634 | 91640.200404 | 3200 |  | 31947.27161257337 | 1187.366244389833 | 10142.18312515496 |  |  | 45741.03871704078 | 7599.11 | 16460.01462476458
1415 | 55157.76 | 448909.534932224 | 28514.11898944738 | 145469.967391 | 3760 |  | 119679.8755129859 | 25231.63498874196 | 11040.37039951114 |  |  | 47122.25911444653 | 11615.92 | 221921.9347543528
1617 | 44271.36 | 403649.9536848106 | 165490.6230938634 | 78297.08837499999 | 6800 |  | 69505.85749185053 | 5337.444969282263 | 10439.91002909717 |  |  | 104557.4538916645 | 17953.89 | 16635.622326886
1819 | 27613.44 | 181195.9353921357 |  | 39240.74111800001 | 3360 |  | 42291.844160188 | -199.0238897882485 | 2809.140368973916 |  |  | 42223.6654877874 | 20399.61 | 39150.66913610792
2021 | 18869.76 | 190188.7649311953 | 130237.6782138035 | 121089.857692 | 1440 |  | 68325.0161642254 | -646.7378238154757 |  |  |  | 55632.4985575797 | 16646.88 | 79602.5876288823
code
123 | name | value |  |  |  |  |  |  |  |  |  |  |  |  |  | For each code, I need to find Top 5 products
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | And return their names and values
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So output would look something like this
3
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Value
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | top1 name | top 1 value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | top2 name | top2 value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | etc.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 884453d1733618118-adding-additional-sort-in-filter-sortby-adding-additional-sort-in-filter-sortby
Sheet: Sheet2

Answer:
City | Sales | Classification | Grade
NY | 7 | VS | A+ |  |  | 5 | VS | A+ |  |  | 7 | VS | A+ |  |  | 7 | VS | A+ |  |  | 7 | VS | A+ |  |  | 7 | VS | A+
NY | 5 | VS | A+ |  | NY | 7 | VS | A+ |  | NY | 5 | VS | A+ |  | NY | 5 | VS | A+ |  | NY | 5 | VS | A+ |  | NY | 5 | VS | A+
London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+
Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A
Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C
Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A
LA | 3 | VB | A- |  | LA | 3 | VB | A- |  | LA | 3 | VB | A- |  | LA | 3 | VB | A- |  | LA | 3 | VB | A- |  | LA | 3 | VB | A-
Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B
Milan | 1 | VB | B |  | Milan | 1 | VB | B |  | Milan | 1 | VB | B |  | Milan | 1 | VB | B |  | Milan | 1 | VB | B |  | Milan | 1 | VB | B
Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B-
Madrid | 2 | VB | C |  | Madrid | 2 | VB | C |  | Madrid | 2 | VB | C |  | Madrid | 2 | VB | C |  | Madrid | 2 | VB | C |  | Madrid | 2 | VB | C