tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 191531d1352140611-auto-sorting-4181-4181uc-forum
Sheet: 4181-UC

 | [NAME] |  |  |  |  | UTILITY RELOCATION CLEARENCE REPORT
 |  |  |  |  |  | TYPE OF RELOCATION WORK (REF: DESIGN MANUAL PART 5)
 | County- |  |  |  |  | 1.     PRIOR: Anticipated completion of work before the highway contractor's Notice to Proceed is issued.  Use actual or anticipated completion date.
 | S.R.- |  | [NAME]
 | Utility- |  |  |  |  | 2.     RESTRICTIVE: To be completed by the UTILITY before highway contractor can operate without restriction.  Number of calander days required AFTER THE DATE OF NOTICE TO PROCEED.
 | Date-
 |  |  |  |  |  | 3.     CONCURRENT: To be accomplished simultaneously with but not restricting the contractors operation. Show number of calendar days.
 | Prepared By-
 | [NAME] |  |  |  |  | 4.     COORDINATED: Phasing with a special operation of the highway contractor is required. Indicate roadway or bridge work necessary before relocation; e.g.: clearing & grubbing,  rough grading, pipe hangers, etc. Show Number of calendar days.
 | Construction Contact-
 | [NAME] |  |  |  |  | 5.     NOT AFFECTED: Identify areas and any specific instructions for Construction Contract.
 |  |  |  |  |  | 6.     INCORPORATED: Utility relocation work to be incorporated into the prime highway construction contract.
 |  |  |  |  |  | CONDITIONAL RESTRICTIONS AND TIME REQUIREMENTS: Identify conditions affecting the utility’s ability to perform work, i.e.: certain times of the day, week or year that a facility can not shutdown, acquisition of R/W by the State, demolition of buildings, relocation of other utilities, etc. Show number of calendar days.
 | LIST EACH AREA IF INVOLVEMENT BELOW
 | ROUTE | STATION TO STATION OR SEG. & OFFSET TO SEG. & OFFSET |  |  | LT./RT. | BRIEF DESCRIPTION OF ADJUSTMENT |  |  |  | TYPE OF RELOCATE EACH AREA (SEE ABOVE) | DESCRIBE CONDITIONAL RESTRICTIONS OR TIME REQUIREMENTS SPECIFY CONTRACTOR'S OPERATION FOR COORDINATED WORK |  |  |  | CALANDER DAYS REQ'D/DATE OF COMPLETE
 | The proposed adjustments described above are the necessary relocation adjustments to be undertaken by the above named utility to accommodate the construction of the above listed highway project.  Contingent upon the approval of a necessary occupancy permit and/or execution of a reimbursement agreement and upon notice to proceed by the Department of Transportation, the above named utility agrees to proceed with these adjustments.
 |  |  |  |  |  |  |  |  |  |  |  |  | BY | X
 |  |  |  |  |  |  |  |  |  |  |  |  |  | (Signature)
 |  |  |  |  |  |  |  |  |  |  |  |  | TITLE | X
 | LIST EACH AREA IF INVOLVEMENT BELOW
 | ROUTE | STATION TO STATION OR SEG. & OFFSET TO SEG. & OFFSET |  |  | LT./RT. | BRIEF DESCRIPTION OF ADJUSTMENT |  |  |  | TYPE OF RELOCATE EACH AREA (SEE ABOVE) | DESCRIBE CONDITIONAL RESTRICTIONS OR TIME REQUIREMENTS SPECIFY CONTRACTOR'S OPERATION FOR COORDINATED WORK |  |  |  | CALANDER DAYS REQ'D/DATE OF COMPLETE
Spreadsheet: 584386d1533148734-pivot-table-issue-issue_pivotissue
Sheet: Pivot

 |  |  | Values |  |  | SHOULD SHOW
Matter | Matter Name | Pooling TK Name | Count of Client Mgt. % | Sum of Matter Mgt % |  | Client % | Matter %
50000328 | CA#5w USB Power Adapter Trade Dress - Ho | Aide, [NAME] | 6 | 6 |  | 1 | 1
 |  | Holloway, [NAME] |  | 3 |  | 0 | 0.5
Grand Total |  |  | 6 | 9
Spreadsheet: 287536d1388850729-copying-data-to-cells-timesheet
Sheet: Ryan

[NAME]
 |  | [NAME]
Name |  | 2013-12-12 00:00:00 | 2013-12-13 00:00:00 | 2013-12-14 00:00:00 | 2013-12-15 00:00:00 | 2013-12-16 00:00:00 | 2013-12-17 00:00:00 | 2013-12-18 00:00:00 | 2013-12-19 00:00:00 | 2013-12-20 00:00:00 | 2013-12-21 00:00:00 | 2013-12-22 00:00:00 | 2013-12-23 00:00:00
Spreadsheet: 870378d1716906386-create-table-from-rows-myrequest_1
Sheet: Sheet1

 | chair 1 |  |  |  |  | chair 2 |  |  |  |  | chair 3
 | choice 1 | choice 2 | choice 3 | choice 4 | choice 5 | choice 1 | choice 2 | choice 3 | choice 4 | choice 5 | choice 1 | choice 2 | choice 3 | choice 4 | choice 5
[NAME] | yellow | black | [NAME] | white | purple | [NAME] | orange | green | yellow | yellow | white |  | [NAME] | green
suzan | [NAME] | orange | green | yellow | yellow | orange | green | [NAME] | yellow | yellow |  | [NAME] | yellow | green | purple
 | chair 1 | chair 2 | chair 3 | chair 4 |  |  | chair 1 | chair 2 | chair 3
[NAME] | yellow | [NAME] | white |  |  | [NAME] | yellow | [NAME] | white
[NAME] | black | orange | [NAME] |  |  | [NAME] | black | orange
[NAME] | [NAME] | green | green |  |  | [NAME] | [NAME] | green | [NAME]
[NAME] | white | yellow |  |  |  | [NAME] | white | yellow | green
[NAME] | purple | yellow |  |  |  | [NAME] | purple | yellow
suzan | [NAME] | orange | [NAME] |  |  | suzan | [NAME] | orange
suzan | orange | green | yellow |  |  | suzan | orange | green | [NAME]
suzan | green | [NAME] | green |  |  | suzan | green | [NAME] | yellow
suzan | yellow | yellow | purple |  |  | suzan | yellow | yellow | green
suzan | yellow | yelloiw |  |  |  | suzan | yellow | yellow | purple
Spreadsheet: 4507d5df-cf0f-4c4c-abcc-79a3a81e7df6
Sheet: Sheet1

RENCANA JADWAL PELAKSANAAN PLPG TIPE BLOK
RAYON 112 UNIVERSITAS NEGERI SEMARANG
TAHUN 2012
[NAME] : 4 Juni 2012
NO | [NAME] | TAHAP | TEMPAT PELAKSANAAN |  |  |  |  |  |  |  |  | Fakultas | [NAME]
 |  |  | DIKLAT | PATEMON | BALATKOP | BALATRANS | DIKJUR | BLKLN | KUSUMA | MURIA | Bidang Studi
1 | 3-12 MEI | I | SD/3
2 | 11-20 MEI | II |  | SD/6
3 | 12-21 MEI |  |  |  |  |  |  |  | TK/4
4 | 13-22 MEI |  | IPS/2, IPA/2
5 | 14-23 MEI |  |  |  |  |  |  |  |  | SD/2
6 | 21-30 MEI | III |  | SD/6
7 | 22-31 MEI |  |  |  |  |  |  |  | SD/4
8 | 23 MEI-1 JUNI |  | SD/3 |  |  |  |  |  |  | SD/2
9 | 31 MEI-9 JUNI |  |  | SD/6
10 | 1-10 JUNI |  |  |  |  |  |  |  | TK/2, SD/2
11 | 2-11 JUNI |  | PJS/3 |  |  | SD/3
12 | 11-20 JUNI | IV |  |  |  |  |  |  | SD/4
13 | 12-21 JUNI |  | TK/3 |  |  | SD/3
14 | 17-26 JUNI |  |  | SD/6
15 | 21-30 JUNI |  | PJS/3 |  |  |  |  |  | TK/4 | SD/2
16 | 22 [NAME] |  |  |  |  | SD/3
17 | 27 [NAME] |  |  | SD/6
18 | 1 -10 JULI | V | SD/3 |  |  |  |  |  | TK/2, SD/2
19 | 2-11 JULI |  |  |  |  | SD/3
20 | 7-16 JULI |  |  | SD/6
21 | 9-17 JULI |  |  |  |  |  |  | SD/2
22 | 12-21 JULI |  | SD/8, TK/2 |  |  |  |  |  | SD/4
23 | 12-21 JULI |  |  |  |  | SD/3
24 | 16-25juli | VI |  |  |  |  | SD/4
25 | 17-26 JULI |  |  | SD/6
26 | 18 -27 JULI |  |  |  |  |  |  | SD/2
27 | 22-31 [NAME] |  | SD/10 |  |  |  |  |  | TK/2, SD/2 |  | TIK/3,OTO/1,PTM/1 | FT | 5
28 | 22-31 [NAME] |  |  |  | SD/5 | SD/3 |  |  |  |  | MTK(SMA) /2, KIM/1 | FMIPA | 3
29 | 27 JULI-5 AGST | VII |  | SD/6 |  |  | PJS/4 |  |  |  | S.BDY/2, | FIS | 2
30 | 28 JULI-6 AGST |  |  |  |  |  |  | SD/2 |  |  | [NAME] | FIP | 2
31 | 1-10 AGST |  | SD/7, TK/3 |  |  |  |  |  |  |  | BI(SMA)/1,JW/1 | FBS | 2
32 | 1-10 AGST |  |  |  | SD/5 | KET/2, MUL/1 |  |  | SD/4 |  | PJS/2 | FIK | 2
33 | 6-15 AGST | VIII |  | SD/6
34 | 7-16 AGSTS |  |  |  |  |  | SD/4 | SD/2 |  |  | S.BDY/3, PKn/1 | FIS | 4
35 | 11-31 AGST |  | SD/4,PJS/5,Aws/1
36 | 11-31 AGST |  |  |  | SD/5 | SD/3 |  |  | PJS/4 |  | PJS/3 | FIK | 3
 |  |  | 62 | 54 | 15 | 24 | 12 | 8 | 40 | 6 | 23
REKAP BIDANG STUDI PER GUGUS |  | SD | 40 | 54 | 15 | 21 | 8 | 8 | 20 | 6
 |  | TK | 6 |  |  |  |  |  | 16
 |  | PJS | 11 |  |  |  | 4 |  | 4 |  | 5
 |  | IPA | 2
 |  | IPS | 2
 |  | AWS | 1
 |  | Ket |  |  |  | 2
 |  | [NAME] |  |  |  | 1
 |  | TIK |  |  |  |  |  |  |  |  | 3
 |  | OTO |  |  |  |  |  |  |  |  | 1
 |  | PTM |  |  |  |  |  |  |  |  | 1
 |  | MAT |  |  |  |  |  |  |  |  | 2
 |  | [NAME] |  |  |  |  |  |  |  |  | 1
 |  | SBDY |  |  |  |  |  |  |  |  | 5
 |  | BK |  |  |  |  |  |  |  |  | 2
 |  | BI |  |  |  |  |  |  |  |  | 1
 |  | JW |  |  |  |  |  |  |  |  | 1
 |  | PKn |  |  |  |  |  |  |  |  | 1
 |  | [NAME]
 | CATATAN
 |  | = | KAB. CIREBON, KOTA CIREBON, KAB.KUNINGAN
 |  | = | TERJADI PERUBAHAN
 |  | = | SEDANG BERLANGSUNG
Spreadsheet: 30a7e8f3-d98f-4156-8e23-cc51714da02e
Sheet: Sheet1

PAY PERIOD ENDING DATE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | INDIANA UNIVERSITY OF PENNSYLVANIA | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27
IF ADJUSTMENT, PAY PERIOD ENDING DATE |  |  |  |  |  |  | TIME AND ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  | AFSCME, PDA, PNA, PSSU, & SPFPA
EMPLOYEE NAME |  |  |  |  |  |  |  |  | EMPLOYEE ID NUMBER |  |  |  |  | BU# |  | TIMEKEEPER'S # |  |  |  | STATUS: |  | PERM |  | TEMP |  | WAGE
 |  |  | LAST |  |  | FIRST |  | MI
 | REGULAR SCHEDULED WORK HOURS |  | O  V  E R  T  I  M  E |  |  |  |  |  |  |  | OVERTIME CALL |  | OT      STANDBY      .25 | OT HALFTIME |  |  | SHIFT DIFF.      1.0 | SHIFT DIFF.      1.5 | SHIFT DIFF.      2.0 | P    A    I    D        L    E   A    V    E    S |  |  |  |  |  |  | UNPAID    LEAVES
DATE | START | END | START | END | START | END | REG. [NAME] | OT      1.0 | OT      1.5 | OT      2.0 | OT      1.0 | OT      1.5 |  | OT          .5 | OT HOLIDAY .5 | OT      HOLIDAY 1.5 |  |  |  | A | S | SF                    SB | P | CL | H
REVISED 3/06 |  |  | TIME AND ATTENDANCE CODES |  |  |  | Reg Hours | 210 | 215 | 220 | 235 | 240 | 255 | 200 | 205 | 230 | 260     270     280 | 262     272     282 | 264     274     284 | 300 | 310 | 312 314 | 320 | 330 | 350
 |  |  |  |  | TOTALS
 |  |  |  |  |  | (Only if wage employee)
FOR PAYROLL USE ONLY
Input Date |  |  |  | Pay Date |  |  |  | Initials |  |  |  |  | Supervisor's Signature and Date |  |  |  |  |  |  | Employee Signature and Date
 |  |  |  |  |  |  |  |  |  |  |  |  | Pre-Authorized
Spreadsheet: darrell_schoolcraft__7240__saledoc01_12TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power LLC
Deal Date: |  |  | 2002-01-15 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/16/02 |  |  | FAX Number:
Total Quantity |  |  | 10133 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.13
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/16/02 | 2002-01-16 00:00:00 | 10133 |  | 10133 |  | 10133
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 10133 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 125289 | 125129
2 | 151397 | 150614
3 | 140641 | 140609
4 | 140746 | 140609
5 | 138812 | 138455
6 | 140914 | 140423
7 | 147299 | 147989
8 | 142094 | 142003
9 | 171123 | 172003
10 | 168833 | 172003
11 | 171481 | 172003
12 | 142852 | 142004
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2002-02-28 00:00:00 |  |  | -13944.79 |  |  |  | 530
2002-03-12 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -7030
Spreadsheet: 129004d1321396683-unable-to-make-lines-on-a-graph-move-through-an-arc-whilst-maintaining-y-intercept-suspension-analysis
Sheet: Dynamic analysis 1

Low speed turning (<20mph) |  |  |  |  |  | Turn radius
 |  |  |  |  |  | 20 | m
Radius of turn |  |  |  | m |  | Turn speed
Wheelbase |  |  |  | m |  | 60 | mph
Track |  |  |  | m
Outside wheel steer angle |  | rad |  | deg |  | Vehicle handling characteristic
Inside wheel steer angle |  | rad |  | deg
Ackerman angle |  | rad |  | deg
Rear wheel off-tracking |  |  |  | m
High speed turn
Radius of turn |  |  |  | m
Wheelbase |  |  |  | m
Distance to CoG from front axle |  |  |  | m
Distance to CoG from rear axle |  |  |  | m
Velocity of car |  |  |  | m/s
Lateral acceleration |  |  |  | m/s2
Front tyre cornering stiffness |  |  |  | N/deg
Rear tyre cornering stiffness |  |  |  | N/deg
Lateral force on front wheel |  |  |  | N
Lateral force on rear wheel |  |  |  | N
Front slip angle |  | rad |  | deg
Rear slip angle |  | rad |  | deg
Ackerman angle |  | rad |  | deg
Steer angle |  | rad |  | deg
Front cornering compliance |  |  |  | deg/g
Rear cornering compliance |  |  |  | deg/g
Characteristic speed |  | m/s |  | mph
Critical speed |  | m/s |  | mph
Lateral acceleration gain |  |  |  | deg/sec
[NAME] velocity |  |  |  | deg/sec
[NAME] velocity gain
Vehicle sideslip angle |  | rad |  | deg
mph | m/s | Steer angle | Charac. speed | Crit. speed | Lat. Accn | Lat. accn gain | [NAME] velocity | [NAME] velocity gain
30
40
50
60
70
80
90
100
110
120
130
140
150
160
170
Spreadsheet: 267398d1380064458-creating-randomized-lists-based-on-criteria-randomize-list
Sheet: Sheet1

Randomize | Name | Group
 | Person 23 | Marketing
 | Person 17 | Finance
 | Person 14 | Advertisting
 | Person 4 | Logistics
 | Person 1 | Marketing
 | Person 15 | Finance
 | Person 27 | Advertisting
 | Person 13 | Logistics
 | Person 11 | Marketing
 | Person 2 | Finance
 | Person 21 | Advertisting
 | Person 6 | Logistics
 | Person 5 | Marketing
 | Person 9 | Finance
 | Person 26 | Advertisting
 | Person 8 | Logistics
 | Person 12 | Marketing
 | Person 7 | Finance
 | Person 20 | Advertisting
 | Person 28 | Logistics
 | Person 19 | Marketing
 | Person 16 | Finance
 | Person 3 | Advertisting
 | Person 18 | Logistics
 | Person 25 | Marketing
 | Person 22 | Finance
 | Person 10 | Advertisting
 | Person 24 | Logistics
Spreadsheet: 108626d1305652875-yes-no-if-data-matches-in-a-worksheet-book1
Sheet: Data

Employee | A | B | C
Employee # | E02253 | E02054 | E02237
Date
2011-03-23 00:00:00 | Yes | Yes | Late
2011-03-24 00:00:00 | Yes | Yes | Late
2011-03-25 00:00:00 | Yes | Yes | Late
2011-03-26 00:00:00 | Yes | No | Late
2011-03-27 00:00:00 | Yes | No | Late
2011-03-28 00:00:00 | Yes | No | Late
2011-03-29 00:00:00 | Yes | Yes | Late
2011-03-30 00:00:00 | Yes | Yes | Late
2011-03-31 00:00:00 | Yes | No | Late
2011-04-01 00:00:00 | Yes | No | Yes
2011-04-02 00:00:00 | Yes | No | Yes
2011-04-03 00:00:00 | Yes | Yes | Yes
2011-04-04 00:00:00 | Yes | Yes | Yes
2011-04-05 00:00:00 | Yes | Yes | No
2011-04-06 00:00:00 | Yes | Yes | No
Spreadsheet: 754220d1636033821-retrieve-values-between-different-worksheets-with-conditions-fileb
Sheet: CLIENTS

CID | STATUS | COMPANY | PHONE | VAT | FIRST NAME | FAMILY NAME | ADDRESS | POST CODE | CITY | [NAME]
1 | BA | CA | DA | EA | FA | GA | HA | IA | JA | KA
2 | BB | CB | DB | EB | FB | GB | HB | IB | JB | KB
3 | BC | CC | DC | EC | FC | GC | HC | IC | [NAME] | KC
4 | BD | CD | DD | ED | FD | [NAME] | HD | ID | [NAME] | KD
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
Spreadsheet: 68143d1268691114-will-vlookup-work-for-this-worksheet-dandavis1-book1
Sheet: Exec Summary

 |  | Target | 2010-02-01 00:00:00 | Movement | Rolling | Trend
 | Box % | 0.03 | 0.042 | ↓ | #N/A
 | Satisfaction | 0.9 | 0.847 | ↑ | #N/A
 | Complaints | 0.01 | 0.0051 | ↑ | #N/A
 | PEOPLE ACTIVITY
 | OPERATIONAL
 | Fee Audit
 |  | Target | Mth | Movement | YTD | Trend
 | Due
 | Completed
Spreadsheet: 856154d1705508673-count-distinct-values-help2
Sheet: Sheet1

 | Name | Week 9 Regime |  |  | Name | Week 9 Regime
 |  |  |  |  | ACTON | 5
 |  |  |  |  | BRENT | 8
 |  |  |  |  | Ealing | 3
Spreadsheet: 129932d1321978653-how-do-i-get-a-cell-to-sum-based-on-two-criteria-copy-of-drainage-material-pipe
Sheet: Drain runs 

 | gully workings |  |  |  |  |  |  |  | rocker spigot details |  |  | order length calcs | junction details |  |  |  |  |  |  |  | junction details |  |  |  |  |  |  |  | junction details |  |  |  |  |  |  |  | junction details
 |  |  |  |  |  |  |  |  | Rocker and spigot lengths |  |  | effect pipe length lees rocker jct etc |  |  |  |  | [NAME] off main pipe | no of junction on this one pipe |  |  |  |  |  |  | [NAME] off main pipe | no of junction on this one pipe |  |  |  |  |  |  | [NAME] off main pipe | no of junction on this one pipe |  |  |  |  |  |  | [NAME] off main pipe | no of junction on this one pipe
 | Drain runs |  |  |  |  |  |  |  | 2no per run for each so below x 4 |  |  | less 600 for spig sock rocker jct etc |  |  |  |  |  | amount |  | [put type |  |  |  |  |  | amount |  | [put type |  |  |  |  |  | amount |  | [put type |  |  |  |  |  | amount |  | [put type
 |  |  |  |  |  |  |  |  | Effective length |  |  | less 5m & junctiosn |  |  |  | hide |  | 1 or 2 | hide | in validation |  |  |  | hide |  | 1 or 2 | hide | in validation |  |  |  | hide |  | 1 or 2 | hide | in validation |  |  |  | hide |  | 1 or 2 | hide | in validation
 | gully type | gully grating |  | From | dia | to | Material | length | 0.6 | 1 | 1.25 | no of pipes (=length less rocker, soc spig) | jcts |  |  |  |  | a |  | type | jcts |  |  |  |  | a |  | type | jcts |  |  |  |  | a |  | type | jcts |  |  |  |  | a |  | type
 | 450 x 750 | Double Tri D400 600 x 600 x 100mm |  | Gully | 0.15 | f12 | Plastic | 35 |  |  |  |  |  |  | x |  | 0.15 | 2 |  |  |  |  | x |  | 0.15 | 2 |  |  |  |  | x |  | 0.15 | 2 |  |  |  |  | x |  | 0.15 | 2
 | 300 x 600 | Hinged D400 380 x 310 x 150mm |  | [NAME]
 | 450 x 750 | Hinged C250 420 x 420 x 75mm |  | FWMH 17 |  |  |  |  |  |  |  |  |  |  |  |  | this calcs up to 4 junctions on a run
 | 450 x 900 | Double Tri D400 600 x 600 x 100mm |  | Gully
 | 450 x 900 |  |  | Gully
 |  |  |  | Gully
 |  |  |  | Gully
 |  |  |  | Gully
Spreadsheet: 141532d1329318950-issue-in-conditional-formating-conditional-foramting
Sheet: Sheet1

Name | Allocation
Test1 | 1
Test2 | 0
Test3 | 0
Test4 | 1
Test5 | 0
Test6 | 1
[NAME] | 0.5
Test8 | 1
Test9 | 0
Test10 | 0
Test11 | 0
Test12 | 1
 |  | I don’t want to appy the color in empty cells.
 |  | I don’t want to appy the color in empty cells.
Test14 | 0
Test15 | 1
Test16 | 0.5
Test17 | 1
Spreadsheet: 86620d1286555142-dependent-drop-down-list-using-numbers-book3
Sheet: Sheet1

Box length (in) |  |  | 16 | 18 | 20 | 24 | 30 | 32…(etc)
20 |  |  | 10 | 10 | 10 | 14 | 20
 |  |  | 11 | 11 | 11 | 16 | 21
Available width (in) |  |  | 13 | 13 | 13 | 19 | 23
 |  |  | 14 | 14 | 14 | 20 | 24
 |  |  |  |  | 16 | 21 | 26
 |  |  |  |  | 18
Spreadsheet: 78330d1278693240-vlookup-and-match-on-multiple-columns-rowmatch
Sheet: Sheet1

 | Product1 | Product2 | Product3
1 | 0-29 | 0-15 | 0-29 |  | Product | Age
2 | 30-39 | 16-30 | 30-39 |  | Product3 | 52 | <The formula references the values in F3 and G3
3 | 40-49 | 31-100 | 40-49
4 | 50-59 | 50-59 | 60-69 |  | Row | 7 | <Array formula confirmed with Ctrl+Shift+Enter
5 | 60-69
6 | 70-79 |  |  |  |  | If you want to match the actual row number and not the
7 | 80-89 |  | 50-59 |  |  | corresponding number in column A, replace $A$2:$A$11 with
8 | 90-99 |  |  |  |  | ROW($A$2:$A$11) in the formula in G5.
9
10
Spreadsheet: 799655d1665175656-index-and-match-product-with-highest-value-worst-case
Sheet: Sheet1

Product | Igredient | Value
A | 1 | 70
B | 2 | 60
B | 3 | 50
B | 4 | 47
C | 3 | 50
D | 1 | 70
E | 4 | 47
E | 5 | 45
Product | A | B | C | D | E
Worst-case Ingredient |  | 2 |  |  | 4
Spreadsheet: 880062d1727701271-byrow-lambda-to-retrieve-all-negative-amounts-from-a-3-column-list-cash-flow-forecast-1-
Sheet: Forecast 260924

 |  |  |  | 1 | 1 | 5 | 15
Bank's region | Bank | Statement accounts | Currency |  |  |  |  | Conversion | I/C + Deposits |  |  |  |  |  |  |  | From Entity | Bank Name | Bank account Number | Amount | Currency | To Entity | Bank | Account | Currency | Amount
IN | JPM | 50078 | USD
IN | JPM | 50078 | USD
IN | JPM | 50079 | EUR |  | 511740
IN | JPM | 50078 | GBP |  | 73709
IN | JPM | 50078 | AUD
GB | HSBC | 200987 | USD | 7120363
GB | HSBC | 200987 | USD
GB | HSBC | 200987 | GBP
GB | HSBC | 200987 | EUR
GB | HSBC | 200987 | AUD
US | CITIBANK | 7433 | USD
US | CITIBANK | 90807 | NIS
US | CITIBANK | 801.7683883749727 | USD |  | 7003766
US | CITIBANK | 278.3189847924104 | EUR
US | CITIBANK | 175.7076287609073 | GBP |  | 558
US | CITIBANK | 673.7614867316984 | AUD
UK | CITIBANK | 744.6707467759913 | USD
UK | CITIBANK | 726.3982087969856 | GBP
UK | CITIBANK | 675.4697063208389 | AUD
UK | CITIBANK | 829.4605501364579 | EUR
Spreadsheet: drew_fossum__8889__gallup up front pmt
Sheet: Sheet2

per | hp date | gas start | gas end | days | Year |  | disc gas val | disc net m-m | disc basis | [NAME]
0 | 2000-03-31 00:00:00
1 | 2000-05-01 00:00:00
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
 |  |  |  |  | NPV
Spreadsheet: 867769d1714566248-dynamic-drag-down-of-formula-based-on-other-cells-formula-drag-down-dynamically
Sheet: Sheet1

X Amount of Data Is Added Here Each Day | Data is Added Here Every Other Day | [NAME] Pulled Down Based On Cells in Some Row of Column A and B | My Attempt at a Formula That replicates the Formula in Column C but Without the Need to Drag it Down (Dynamic)
Power 5 | Granted Day 1
6x Experience
Running Slowed
12345 | Granted Day 3
Sometimes Words and 12345
Sometimes Just Words
1234
Item Count Increase +1
Fire Breathing Active | Granted Day 5
[NAME] = True
Up Exp
There is no set amount of rows added each day and the data will always be increasing (15 rows above is just an example)
I have thought about Dynamic Ranges and Tables but still can't get want I am looking to achieve
In a ideal world I would love a generic formula or method to create formulas X amount of times - This way it saves data by not having to pull down a formula indefinitely in case users ever get that far.
Spreadsheet: 681428d1591564231-finding-the-average-of-top-and-bottom-10-of-a-dataset-sample-dataset
Sheet: Sheet1

CITY | COST |  | City | Average | Average of Top 20% | Average of Bottom 20%
Atlanta | 368.75 |  | Atlanta
Atlanta | 354.75 |  | Rockford
Atlanta | 318.75 |  | Warner Robins
Rockford | 780
Rockford | 777.4
Rockford | 720
Rockford | 709.5
Rockford | 710.13
Rockford | 679.25
Rockford | 540
Warner Robins | 500
Warner Robins | 474.5
Warner Robins | 474.5
Warner Robins | 428.8
Warner Robins | 365
Spreadsheet: 33909d1230794474-ranking-spreadsheet-multi-variable-hlookup-copy-of-testing-fb-pool
Sheet: fixed rank

Name |  | Jules | Jeff | [NAME] | michael | [NAME] | Alex | [NAME] | Jennifer | [NAME] | Vaughn | [NAME] | Theresa | Kenny | JULIE | [NAME] | [NAME] | [NAME] | Jessica | Tory | Thomas
[NAME] |  | 9 | 15.5 | 11 | 11.5 | 9 | 11.5 | 13 | 10.5 | 14.5 | 15 | 15.5 | 11 | 14.5 | 16 | 15.5 | 16 | 16.5 | 16.5 | 16 | 8.5
Tie Breaker |  | 34 | 48 | 42 | 42 | 29 | 38 | 48 | 34 | 42 | 21 | 42 | 47 | 34 | 47 | 27 | 63 | 35 | 35 | 50 | 45
WTbRank |  | 18.34 | 6.48 | 15.42 | 13.42 | 18.29 | 13.38 | 12.48 | 17.34 | 10.42 | 9.21 | 6.42 | 15.47 | 10.34 | 3.47 | 6.27 | 3.63 | 1.35 | 1.35 | 3.5 | 20.45
RANK | NAME
1 | [NAME]
1 | Jessica
3 | JULIE
4 | Tory
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | Jeff
9 | Vaughn
10 | Kenny