tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_allen__28811__Westgate Proforma-Phillip Allen
Sheet: 1164SF 2Sty

TWO STORY DUPLEX PLAN A:  3 Bedroom, 2 1/2 Bath, 1164 SF
Descriptions | Qty. | Unit | Unit Cost | Unit Total | Per SF | Unit Total With Ovhd | Per SF
Area Calculations: |  |  | Masonry |  |  |  | S.F.
Heated Area: |  |  | Foundation |  |  |  | S.F.
Lower Level | 492 | S.F. | Flatwork
Upper Level | 672 | S.F. | Patio |  |  |  | S.F.
Total Heated |  | S.F. | Second patio |  |  | 0
 |  |  | Walk
Other Covered Areas: |  |  | Driveway
Garage | 386 | S.F. | Windows |  |  | 9
Entry/Covd Porch | 22 | S.F. | Ext. Doors |  |  | 1
Total Other Covered |  | S.F. | Interior Doors |  |  | 8
Total Covered SF |  | S.F. | Const.Time |  |  |  | Months
Professional Services
Architectural | 0 | L.S.
Structural Engineering |  | S.F. | 0.15
Construction Surveying | 0 | L.S. | 315
Interior Design | 1 | L.S. | 0
Permits & Fees
Building Permits | 1 | L.S. | 150
Building Inspections | 1 | L.S. | 100
Utility Connections | 1 | L.S. | 0
Insurance
Builder's Risk |  | Mos.
General Liability | 1 | L.S. | 500
Temporary Utilities
Electricity |  | Mos. | 30
Water |  | Mos. | 30
Sanitary Facilities |  | Mos.
Clean Up
Site Clean Up | 1 | L.S. | 750
Building Clean |  | S.F. | 0.1
Sitework
Environmental Controls | 0 | L.S. | 0
Lot Clear | 1 | Each | 150
Finish Grading | 1 | L.S. | 150
Sprinkler System | 1 | L.S. | 0
Landscaping | 1 | L.S. | 0 |  | x
Privacy Fencing | 100 | L.F. | 15
Fence Gate | 1 | L.S. | 100
Concrete Work
Foundation |  | S.F. | 5.75
Underpinning | 1 | L.S. | 100
Flatwork |  | S.F. | 2
Driveways |  | S.F. | 2.25
Carpentry
Framing Materials |  | S.F. | 2.5
[NAME] |  | S.F. | 1.9
[NAME] |  | S.F. | 1.2
Framing Labor |  | S.F. | 3.5
Entry Door | 1 | L.S. | 285
Exterior Doors |  | LS | 285
Trim Materials |  | S.F. | 0.6
Interior Doors |  | DRS | 85
Trim Labor |  | S.F. | 0.6
Base Cabinets | 33 | L.F. | 60
Upper Cabinets | 16 | L.F. | 30
Glass & Mirrors
Windows |  | Wdws. | 85
Shower Enclosures | 0 | L.S. | 0
Mirrors | 36 | S.F. | 5
Moisture Protectors
Roofing & Flashing |  | SQS. | 52
Gutters | 1 | L.S. | 200
Insulation |  | S.F. | 0.7
Drywall |  | S.F. | 3
Masonry
Stone Veneer |  | S.F. | 5.5
Painting (Heated) |  | S.F. | 2
Painting (Covered) |  | S.F. | 0.6
Flr Tile | 48 | S.F. | 5.5
Carpet & Vinyl |  | S.Y. | 14
Laminate Counters | 27 | L.F. | 24
Syn. Marble Counters | 9 | L.F. | 24
Syn. Marble Lavatories | 2 | Lavs | 40
Syn. Marble Tubs | 0 | Tub | 750
[NAME] | 1 | Tub | 300
Window Treatments |  | WDWS. | 35
F.P. Treatments | 0 | L.S. | 0
Specialties
Hardware | 1 | L.S. | 500
Metal Fireplaces | 0 | EA. | 650
Overhead Door & Openor | 1 | DRS. | 790
Electrical
Wiring & Panels |  | S.F. | 2.25
Fixtures | 1 | L.S. | 750
TV. Phone Prewire | 1 | L.S. | 200
Mechanical
Plumbing | 1 | L.S. | 4200
Laterals | 25 | L.F. | 15
Plumbing Fixtures | 1 | L.S. | 2000
Appliances | 1 | L.S. | 990
HVAC |  | L.S. | 2.85
Supervision |  | Mos.
TOTAL
Spreadsheet: 848153d1698932581-formula-to-adjust-daily-sales-target-required-sample2
Sheet: NOVEMBER 2023

BSL PROCESSED ORDER VALUE NOVEMBER 2023
DAY | VALUE | NO. OF ORDERS
1 | 6877.52 | 44
2
3
4
5
WK/TOTAL
Running Total
6
7
8
9
10
11
12
WK/TOTAL
Running Total
13
14
15
16
17
18
19
WK/TOTAL
Running Total
20
21
22
23
24
25
26
WK/TOTAL
Running Total
27
28
29
30
WK/TOTAL
Running Total
MONTH TOTAL
Grand Total
Spreadsheet: 761416d1640883471-monthly-percentage-of-job-volumes-by-area-tangible-dashboard
Sheet: Cadance

 | Sign up | Go Ahead | Completion | Cadance
Spreadsheet: 723008d1615477854-range-between-n-days-range-between-n-days
Sheet: Working

 | Date | PX_BID |  | Full range
 | 2021-02-18 00:00:00 | 102.661
 | 2021-02-17 00:00:00 | 102.68
 | 2021-02-16 00:00:00 | 102.626 |  | [NAME] range over n days |  | n
 | 2021-02-15 00:00:00 | 102.643 |  |  |  | 2
 | 2021-02-12 00:00:00 | 102.678
 | 2021-02-11 00:00:00 | 102.689
 | 2021-02-10 00:00:00 | 102.645
 | 2021-02-09 00:00:00 | 102.665
 | 2021-02-08 00:00:00 | 102.652
 | 2021-02-05 00:00:00 | 102.62
 | 2021-02-04 00:00:00 | 102.666
 | 2021-02-03 00:00:00 | 102.824
 | 2021-02-02 00:00:00 | 102.873
 | 2021-02-01 00:00:00 | 102.924
 | 2021-01-29 00:00:00 | 102.909
 | 2021-01-28 00:00:00 | 102.94
 | 2021-01-27 00:00:00 | 102.987
 | 2021-01-26 00:00:00 | 103.008
 | 2021-01-25 00:00:00 | 103.006
 | 2021-01-22 00:00:00 | 102.968
 | 2021-01-21 00:00:00 | 102.906
 | 2021-01-20 00:00:00 | 102.952
 | 2021-01-19 00:00:00 | 102.987
Spreadsheet: 853586d1703469614-if-a-cell-text-is-a-substring-contained-in-another-column-cell-range-get-other-column-val-test
Sheet: Sheet1

Number | Name
1 | Apples |  | Working cell: |  | Orange
2 | Oranges
3 | Bananas
4 | Mangos |  | Desired result: |  | 2
5 | Plums
 |  |  | "ORANGE" is SUBSTRING contained in ORANGES"
 |  |  | So The GREEN CELL should be 2
 |  |  | Check if Orange (F2 cell) is contained in range B2:B6
 |  |  | If yes, get the A cell *ROW OF the B cell that contains that string - really can't get that part
 |  |  | So if I typed Plums in the Orange cell, it should give A6  that is 5
 |  |  | I might replace the "Orange" with a wildcard like "*"&SUBSTITUTE(($F$2)," ","")&"*"  because I may use 2 names like "Or ange" and the spaces  will be removed
 |  |  | but to make it easier, now with a fixed string name
Spreadsheet: 873367d1719865876-logistics-time-on-the-road-per-day-logistics
Sheet: Sheet1

 | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Hour
 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 | 1 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8
 | 2 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0
 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0
 | 4 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0
 | 5 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0
 | 6 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0
 | 7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
 | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | 9 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0
 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0
 | 11 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0
 | 12 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0
 | 13 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0
 | 14 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0
 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | 16 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0
 | 18 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0
 | 19 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0
 | 20 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0
 | 21 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0
 | 22 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 | 23 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 830260d1684831773-how-to-make-excel-pivot-table-field-header-filters-dependent-to-each-other-test_1
Sheet: Data

Data-1 | Data-2 | Data-3 | Data-4
daf | a | a | aa
asdfd | ss | as | sd
[NAME] | d | s | dsa
das | d | s | dsa
d | ff | s | dsa
da | dd | fd | ff
d | ff | cx | ffads
das | ff | v | f
ads | ff | v | c
Spreadsheet: 847283d1698293415-how-to-assign-points-for-winner-athlete-points
Sheet: Sheet1

 | 100m
Tibro | Time | Points |  | I'd like the point column to populate as following
[NAME] | 0.1 |  |  | 4
[NAME] | 0.3 |  |  | 2
[NAME] | 0.2 |  |  | 3
[NAME] | 0.5 |  |  | 1
 | POINTS
 | 1ST - 4
 | 2ND - 3
 | 3RD - 2
 | REST - 1
Spreadsheet: 96411d1295823807-tracking-income-and-invoices-for-projects-multiple-search-results-test-project-tracking
Sheet: Oct 2010

 | Income and Expense Report
 |  | 2010-10-01 00:00:00
 |  | -71.64999999999999 | LOSS
 | Date | Payment Type | Reference / Debtor No. | Supplier Invoice Number | Income  ($) | Purchasing Property | Total Invoice Costs ($) | MAC | GN | HF | BM | Comments
 |  |  |  |  | 0 | -71.64999999999999 | 71.64999999999999 | 0 | 60.87 | 10.78 | 0
 | 2010-10-01 00:00:00 | Invoice Only | fA145176 | 40910 |  | [NAME] | 5.39 |  |  | 5.39
 | 2010-10-01 00:00:00 | Invoice Only | fA195491 | 40910 |  | Lowther | 5.39 |  |  | 5.39
 | 2010-10-30 00:00:00 | Invoice Only | fA20808 | MACQU000-139 |  | Westgarth | 60.87 |  | 60.87
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  | PIF-ROW
 |  | Initial Instal'
 |  | Instalment
 |  | Final Instal'
 |  | Invoice Only
 |  | Other
Spreadsheet: 818144d1676620620-formula-to-add-cells-based-on-values-in-other-cells-plan-values
Sheet: Sheet1

 |  |  | I am looking for a formula to automate this process
PLAN_ID | TOTAL_CASH_AMOUNT |  | Plan | Value
2001852 | 166972.5449413039
2001852 | 257844.3447303469
2007704 | 9538.602947803689
2007704 | 5289.273561956705
2007724 | 71220.66535744045
2012764 | 183707.993682552
2030946 | 31053.42053816088
2030946 | 29090.8446628716
2031523 | 43348.99485924698
2031523 | 40560.72372431596
2038205 | 42282.3520233981
2041582 | 24109.21816679459
2051841 | 29579.75730445551
2051841 | 27776.52725917674
2055261 | 117623.0375788152
2056938 | 53231.28356280616
2056938 | 49948.01668770569
2058332 | 92166.36997818795
2060335 | 51320.85148021929
2060335 | 48946.38229540809
2075416 | 90603.06801946952
2078114 | 67682.27770659367
2078114 | 76261.14470100388
2078114 | 8887.432631033065
2078114 | 10066.35973371509
Spreadsheet: 265393d1379241691-different-sets-of-dates-compared-to-a-static-number-lame-description-but-im-lost-sumproduct
Sheet: Sheet1

IN DATE | OUT DATE | MANAGER | CHECK DATE | RESULT | MANAGER NAMES
2013-09-14 00:00:00 | 2013-09-18 00:00:00 | [NAME] | 2013-09-17 00:00:00 |  | [NAME]
2013-09-16 00:00:00 | 2013-09-21 00:00:00 | [NAME] |  |  | [NAME]
2013-09-15 00:00:00 | 2013-09-20 00:00:00 | [NAME]
2013-09-16 00:00:00 | 2013-09-20 00:00:00 | [NAME]
2013-09-14 00:00:00 | 2013-09-15 00:00:00 | [NAME]
2013-09-16 00:00:00 | 2013-09-23 00:00:00 | [NAME]
2013-09-14 00:00:00 | 2013-09-17 00:00:00 | [NAME]
Spreadsheet: 182349d1348445257-returning-a-value-from-color-coding-and-totals-book1
Sheet: Sheet1

SO | PO | Qty | Item Description | Promise Date | PALLETS
1654897 | 12345 | 200 | Model #1 | 2012-09-18 00:00:00 | 34
1342687 | 23456 | 25 | Model #2 | 2012-07-01 00:00:00 | 5
2945387 | 34567 | 100 | Model #2 | 2012-09-20 00:00:00 | 17
6249751 | 45678 | 165 | Model #3 | 2012-07-14 00:00:00 | 28
2345622 | 56789 | 23 | Model #1 | 2012-09-22 00:00:00 | 4
9552156 | 67890 | 108 | Model #3 | 2012-08-16 00:00:00 | 18
8421679 | 78901 | 100 | Model #1 | 2012-09-24 00:00:00 | 17
3259487 | 89012 | 84 | Model #4 | 2012-09-25 00:00:00 | 14
Spreadsheet: 215216d1361308473-array-function-for-date-month-range-date-month-book8
Sheet: Sheet1

 | Start date | 2010-01-01 00:00:00
 | End Date | 2012-04-30 00:00:00
Spreadsheet: 141445d1329265119-sumif-unique_sum
Sheet: Sheet2

Unique | SUM
Spreadsheet: 852017d1702115920-need-formula-to-automatically-sum-all-values-within-a-year-excel-workbook-aligw
Sheet: Ark

0.2 | 2018-10-19 00:00:00
0.2 | 2018-12-27 00:00:00
0.2 | 2019-03-28 00:00:00
0.2 | 2019-06-19 00:00:00
0.21 | 2019-09-20 00:00:00
0.21 | 2020-01-01 00:00:00
0.22 | 2020-03-23 00:00:00
0.22 | 2020-06-17 00:00:00
0.22 | 2020-09-22 00:00:00
0.07 | 2020-10-22 00:00:00
0.07 | 2020-11-20 00:00:00
0.08 | 2020-12-18 00:00:00
0.07 | 2021-01-21 00:00:00
0.08 | 2021-02-18 00:00:00
0.08 | 2021-03-23 00:00:00
0.07 | 2021-04-22 00:00:00
0.08 | 2021-05-24 00:00:00
0.08 | 2021-06-22 00:00:00
0.07 | 2021-07-22 00:00:00
0.08 | 2021-08-23 00:00:00
0.08 | 2021-09-22 00:00:00
0.08 | 2021-10-21 00:00:00
0.08 | 2021-11-22 00:00:00
0.08 | 2021-12-21 00:00:00
0.08 | 2022-01-21 00:00:00
0.08 | 2022-02-18 00:00:00
0.08 | 2022-03-23 00:00:00
0.06 | 2022-04-21 00:00:00
0.04 | 2022-04-21 00:00:00
0.04 | 2022-05-12 00:00:00
0.06 | 2022-05-12 00:00:00
0.06 | 2022-06-21 00:00:00
0.02 | 2022-06-21 00:00:00
0.02 | 2022-07-21 00:00:00
0.06 | 2022-07-21 00:00:00
0.06 | 2022-08-23 00:00:00
0.02 | 2022-08-23 00:00:00
0.02 | 2022-09-22 00:00:00
0.07 | 2022-09-22 00:00:00
0.06 | 2022-10-21 00:00:00
0.02 | 2022-10-21 00:00:00
0.02 | 2022-11-22 00:00:00
0.06 | 2022-11-22 00:00:00
0.07 | 2022-12-21 00:00:00
0.02 | 2022-12-21 00:00:00
0.02 | 2023-01-23 00:00:00
0.06 | 2023-01-23 00:00:00
0.06 | 2023-02-20 00:00:00
0.02 | 2023-02-20 00:00:00
0.02 | 2023-03-23 00:00:00
0.07 | 2023-03-23 00:00:00
0.07 | 2023-04-21 00:00:00
0.07 | 2023-05-23 00:00:00
0.08 | 2023-06-21 00:00:00
0.07 | 2023-07-21 00:00:00
0.07 | 2023-08-23 00:00:00
0.08 | 2023-09-29 00:00:00
0.07 | 2023-10-23 00:00:00
0.08 | 2023-11-22 00:00:00
0.08 | 2023-12-29 00:00:00
0.07 | 2024-01-23 00:00:00
0.08 | 2024-02-21 00:00:00
0.08 | 2024-03-20 00:00:00
 | 2018
 | 2019
 | 2020
 | 2021
 | 2022
 | 2023
 | 2024
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C18

Local 18
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-15 00:00:00
[NAME]: | 31
Réservé:
Prix: | 75
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 10b274fa-ef0d-4a08-8d61-c66365af73f8
Sheet: Sheet1

SEATTLE UNIVERSITY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number:
PE: |  | 2014-01-01 00:00:00 | TO | 2014-01-31 00:00:00 |  | MO. NO.: |  | 12
Holiday Pay |  |  |  | HP | 8
Community Service Leave |  |  |  | CSL |  | (3 days per FY)
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP | 84
SUB-TOTAL |  |  |  |  | 92 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 340 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL |  |  |  |  | 92
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  | HP | 4 |  | 4 |  | 4
 |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 12 |  | 13 |  | 14 |  | 15 |  | 16 | Time sheets due | 17 |  | 18
 |  | HP | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 26 |  | 27 |  | 28 |  | 29 |  | 30 | Pay day | 31
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: errol_mclaughlin_jr__10106__Financial Scripts
Sheet: Fin Option

Test Type: Estate Integration Test
Script Name:  Gas Financial Option - TDS
Product Line: | Financial
Description:  Verify that deal entry data can be entered, processed internally, and exported to downstream.
Prepared by:  [NAME] |  | Date:  1/8/2002
Executed by: |  | Date: | Application Version:
Prerequisites: Global Data
Test Scenario:  Deal traded, invoice created in Unify, booked in SAP and paid by Treasury WS
Step # | Required Action | Data Parameters | Expected Results | Actual Results | Comments | Pass/Fail
1 | TDS - Deal Entry - Errol McLaughlin | Deal Type: Fixed Price Option
 |  | Put/Call : Call
 |  | Type : European
 |  | Purchaser: ENA
 |  | [NAME]: [NAME]
 |  | Begin Date: 12/1/2001
 |  | End Date: 3/31/2002
 |  | Volume: 10000/Day
 |  | Price: 3.00
 |  | Premium : 0.0
 |  | Price Ref: NX1
 |  | Price: FT-EAST
 |  | Premium Book : FT-EAST
2 | Validate Bridge TDS - TAGG
3 - 14 | Refer to Gas Financial Master Worksheet
Spreadsheet: f56b746f-4d70-4ba1-84d0-1806dc93b9de
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7555 | 11086 | Marko | Törmänen | FIN | 122 | 00:16:25 | 00:00:41 | 00:18:31 | 00:01:04 | 00:16:07 | 1 | 00:52:52
7555 | 25301 | [NAME] | [NAME] | RUS | 123 | 00:15:35 | 00:00:36 | 00:18:27 | 00:00:49 | [NAME] | 2 | 00:53:08
7555 | 47067 | Marko | Myllymaki | FIN | 119 | [NAME] | [NAME] | 00:22:40 | 00:01:16 | 00:17:50 | 3 | 00:59:45
7555 | 13266 | [NAME] | Savolainen | FIN | 121 | 00:16:43 | 00:00:36 | 00:23:04 | 00:01:25 | [NAME] | 4 | 01:00:27
7555 | 56047 | Toni | Niiranen | FIN | 120 | 00:17:22 | 00:01:31 | 00:25:11 | 00:02:20 | [NAME] | 5 | 01:06:21
Spreadsheet: 119996d1314905879-how-can-i-find-a-in-a-range-and-return-the-row-column-titles-associated-with-that-topcorrelations1
Sheet: Sheet1

 | BB | CC | DD | EE | FF | GG
22 | 0.1859441683346652 | 0.1176453644325651 | 0.04057868811092035 | -0.06101131861233999 | 0.4207649092317566 | 0.3363076035588696
33 | 0.1818050645659255 | 0.111130517068045 | 0.1640731115104797 | 0.05770022075225317 | 0.3432092269003832 | 0.2559376880892822
44 | 0.1804807346692124 | 0.2220100350864315 | 0.2151431316256998 | 0.04642841825221018 | 0.3627349395827884 | 0.265858156327763
55 | 0.1765901152292108 | 0.1189862061530581 | 0.186405 | 0.4500688597108465 | -0.0156773638774708 | 0.07993088329915866
66 | 0.1762247733355 | 0.167971876192922 | 0.06618210146468542 | -0.01980909878856313 | 0.3809698115465956 | 0.2580828501905469
77 | 0.162321805723305 | 0.04142451570158816 | 0.05364334219864314 | 0.06586491047998007 | 0.08011584878168888 | 0.05927500135793256
88 | 0.152860293390355 | 0.06446406727428634 | 0.02014001871356531 | 0.00811786722248526 | 0.3072976754470227 | 0.3730877059464663
99 | 0.1522720623088386 | 0.265450845405 | 0.04151060845659354 | -0.05601369029001119 | 0.4731945310404174 | 0.4069718463846324
 |  |  | Output
 | Top 10 |  | Row | Column
 | 1
Spreadsheet: andy_zipper__138__ICE - Mar09 Power & Gas VOL
Sheet: E-Mail

 | 2001-03-09 00:00:00
 | POWER
 | PHYSICAL GAS
 | FINANCIAL GAS
 | TOTAL GAS
 |  |  |  |  |  |  | DEALS | VOLUME
 |  |  |  |  |  | POWER
 |  |  |  |  |  | PHYSICAL GAS
 |  |  |  |  |  | FINANCIAL GAS
Spreadsheet: 830444d1684922207-formula-to-allocate-numbers-in-excel-example1
Sheet: Sheet1

SKU | Location | Stock | Allocate | Result |  | SKU | Allocate
A | B01 | 10 |  | 10 |  | A | 11
B | B01 | 5 |  | 5 |  | B | 6
A | B03 | 2 |  | 1 |  | C | 10
C | B02 | 3 |  | 3 |  | D | 6
C | B03 | 6 |  | 6
D | B04 | 3 |  | 3
D | B01 | 4 |  | 3
D | B02 | 1 |  | 0
Spreadsheet: 733776d1621803002-index-formula-search-in-different-sheet-testalles
Sheet: Hours

Project | Datum | Firma | Nummer | Vertrek | Tijd | Aankomst | Naam | Telefoon | Tropco's | Aantal | [NAME] | Wie D | Inkoop NL | Inkoop D | [NAME] | Verkoop D
5235 |  |  |  |  |  |  |  |  | 2 | 1 |  | nl |  |  |  |  |  | Uren inkoop |  |  | Km inkoop
5258 |  |  |  |  |  |  |  |  | 1 | 2 | [NAME] | nl |  |  |  |  |  | Uren verkoop |  |  | Km verkoop
5259 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | Verschil uren |  |  | [NAME] km
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL | 42.5 |  | Inkoop D | 1.15
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5259 |  |  |  |  |  |  |  |  | 1 | 2 |  | nl |  |  |  |  |  | [NAME] |  |  | Verkoop D
5260 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | [NAME] |  |  | Verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 |  | Verkoop D | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj NL ink |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj KM ink |  |  | Totaal verschil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project verschil NL |  |  |  | Project verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal uren NL |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal Verkoop NL |  |  | Totaal verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zoek project | Aantal beg | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Klant | aantal beg
Spreadsheet: 270175d1381409627-taking-remaining-value-and-sharing-across-remaining-months-book2
Sheet: Sheet5

IGNORE THIS.
 | Year Total to budget |  |  | Extra | Total | P1 | P1 Actual | P2 | P2 Actual | P3 | P4 | P5 | P6 | P7 | P8 | EnvelopeTotal
250000 | 239700 |  | 17% of Envelope | 35700
How to resolve this problem?
 | Year Total |  |  |  | Total | P1 | P1 Actual | P2 | P2 Actual | P3 | P4 | P5 | P6 | P7 | P8 | Total
250000 |  |  |  |  |  |  | 55 |  | 56
 |  |  |  |  |  |  |  |  | Addition
 |  |  |  |  |  |  |  |  | Difference
 |  |  |  |  |  |  |  |  | Total
Spreadsheet: 605807d1547292790-match-item-with-invoice-and-replace-any-missing-item-auto-masterfile18-19-11
Sheet: Sheet1

Invoice DATA |  |  |  |  | Main DATA
Item + Invoice | Item | Inv# | Qty |  | Item + Invoice | Item | Inv# | Qty | Match-1 | Match-2
0010055MD-500DM27 | MD-500DM27 | 0010055 | 1 |  | 0010055MD-500DM27 | 0010055 | MD-500DM2700 | 1
0010055MD-505DA18 | MD-505DA18 | 0010055 | 1 |  | 0010055MD-505DA18 | 0010055 | MD-505DA1800 | 1
0010055MD-505DA22 | MD-505DA22 | 0010055 | 1 |  | 0010055MD-505DA22 | 0010055 | MD-505DA2200 | 1
0010055MD-ENSP27518 | MD-ENSP27518 | 0010055 | 1 |  | 0010055MD-ENSP27518 | 0010055 | MD-ENSP27518 | 1
0010055MD-ONYX25015 | MD-ONYX25015 | 0010055 | 1 |  | 0010055MD-IHP055150 | 0010055 | MD-IHP055150 | 1
0010055MD-ONYX25026 | MD-ONYX25026 | 0010055 | 1 |  | 0010055MD-ONYX25015 | 0010055 | MD-ONYX25015 | 1
0010055MD-ONYX27518 | MD-ONYX27518 | 0010055 | 1 |  | 0010055MD-ONYX25026 | 0010055 | MD-ONYX25026 | 1
0010055MD-ONYX30012 | MD-ONYX30012 | 0010055 | 1 |  | 0010055MD-ONYX27518 | 0010055 | MD-ONYX27518 | 1
0010055MD-ONYX30022 | MD-ONYX30022 | 0010055 | 1 |  | 0010055MD-ONYX30012 | 0010055 | MD-ONYX30012 | 1
0010055MD-ONYX30026 | MD-ONYX30026 | 0010055 | 1 |  | 0010055MD-ONYX30022 | 0010055 | MD-ONYX30022 | 1
0010055MD-ONYX30030 | MD-ONYX30030 | 0010055 | 1 |  | 0010055MD-ONYX30026 | 0010055 | MD-ONYX30026 | 1
0010055MD-ONYX35026 | MD-ONYX35026 | 0010055 | 1 |  | 0010055MD-ONYX30030 | 0010055 | MD-ONYX30030 | 1
0010055MD-ONYX35030 | MD-ONYX35030 | 0010055 | 1 |  | 0010055MD-ONYX35026 | 0010055 | MD-ONYX35026 | 1
0010055MD-ONYX35038 | MD-ONYX35038 | 0010055 | 1 |  | 0010055MD-ONYX35030 | 0010055 | MD-ONYX35030 | 1
0010055MD-RINT30030 | MD-RINT30030 | 0010055 | 1 |  | 0010055MD-ONYX35038 | 0010055 | MD-ONYX35038 | 1
0010055MD-RINT30038 | MD-RINT30038 | 0010055 | 1 |  | 0010055MD-RINT30030 | 0010055 | MD-RINT30030 | 1
0010055MD-SESRO1 | MD-SESRO1 | 0010055 | 1 |  | 0010055MD-RINT30038 | 0010055 | MD-RINT30038 | 1
0010055MD-SPL15015X | MD-SPL15015X | 0010055 | 1 |  | 0010055MD-SPL15015X | 0010055 | MD-SPL15015X | 1
0010055MD-SPL20020X | MD-SPL20020X | 0010055 | 1 |  | 0010055MD-SPL20020X | 0010055 | MD-SPL20020X | 1
Spreadsheet: 47342d1246377139-mode-for-text-value-mock-up
Sheet: Sheet1

Client | Staffer | Officer |  | Desired Results
Dell | [NAME] | [NAME] |  | Staffer | Most Common Officer
Dell | [NAME] | [NAME] |  | [NAME] | [NAME]
Dell | [NAME] | Shannon |  | [NAME] | Shannon
Microsoft | [NAME] | Shannon |  | [NAME] | Shannon
Google | [NAME] | [NAME] |  | [NAME] | [NAME]
Google | [NAME] | [NAME] |  | [NAME] | Shannon
Google | [NAME] | [NAME] |  | [NAME] | [NAME]
Google | [NAME] | Shannon
IBM | [NAME] | [NAME]
IBM | [NAME] | [NAME]
IBM | [NAME] | [NAME]