tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 584003d1532913097-conditional-formatting-to-highlight-day-routine2
Sheet: Sheet1

S.N. | NAME | Off | LD |  | Vacation
 |  |  | 2018-08-01 00:00:00 |  | 2018-08-01 00:00:00
 |  |  | START | END | START | END
1 | ABC | TUESDAY | 2018-08-05 00:00:00 | 2018-08-13 00:00:00 | 2018-08-15 00:00:00 | 2018-08-17 00:00:00
2 | DEF | WEDNESDAY | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-02 00:00:00 | 2018-08-08 00:00:00
3 | GHI | THURSDAY | 2018-08-06 00:00:00 | 2018-08-06 00:00:00 | 2018-08-07 00:00:00 | 2018-08-15 00:00:00
4 | JKL | FRIDAY | 2018-08-15 00:00:00 | 2018-08-15 00:00:00 | 2018-08-01 00:00:00 | 2018-08-14 00:00:00
5 | MNO | SUNDAY | 2018-08-07 00:00:00 | 2018-08-07 00:00:00
Spreadsheet: 60183d1260734166-lookup-sample
Sheet: Sheet1

 | [NAME] | VINTAGE | NAME | TYPE | COST | VALUE | DRINK AFTER | DRINK BY
A1 | A1 | 1994 | MONDAVI OPUS ONE | [NAME] | 90 | 350 | 1996 | 2022
A2 | A2 | 2004 | SEQUUM | [NAME] | 0 | 60 | 2011 | 2025
A3 | B4 | 1992 | FERRARI CARANO | [NAME] | 49 | 135
A4 | C5 | 1992 | FERRARI CARANO | [NAME] | 49 | 135
A5 | C6 | 1994 | FERRARI CARANO | [NAME] | 49 | 125
A6 | C7 | 1994 | WHITEHALL LANE | [NAME] | 36 | 100
A7 | C8 | 1994 | WHITEHALL LANE | [NAME] | 36 | 100
A8 | D9 | 1997 | WHITEHALL LANE | [NAME] | 36 | 200
A9 | E10 | 1997 | CH. ST. JEAN | [NAME] | 90 | 150
A10 | A11 | 1997 | CH. ST. JEAN | [NAME] | 90 | 89
A11 | D10 | 2000 | CH. ST. JEAN | [NAME] | 80 | 89
A12 | D11 | 2000 | CAYMUS | [NAME] | 110 | 125
A13 | D12 | 2003 | CAYMUS | [NAME] | 90 | 125
A14 | D13 | 2003 | CASTELLO BANFI | BRUNELLO | 68 | 98
A15 | E1 | 2002 | CASTELLO BANFI | BRUNELLO | 0 | 98
A16 | F2 | 1998 | CH. ST. JEAN | [NAME] | 68 | 250
A17 | A3 | 1998 | CAYMUS | [NAME] | 78 | 300
Spreadsheet: 025259ac-98c7-479d-bd79-f85328d762fc
Sheet: Sheet1

M & Q REPORT - BWF WORLD SENIOR CHAMPIONSHIPS 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Player marked M play in the main draw
Start Date: 21-08-2011
Finish Date: 27-08-2011 |  |  | Version 5
Category: 60+ MEN'S SINGLES |  |  | 2011-08-05 00:00:00
Ranking Date:
S.No | PLAYER ID | PLAYER NAME | COUNTRY | RANK | M/Q
1 | V1441 | [NAME] | RUS | 1
2 | V2094 | BUZYNIN Alexander | RUS | 2
3 | [NAME] | Othassel Terje Dag | NOR | 1
4 | V1591 | [NAME] | SLO | 1
5 | V2078 | ONG Sin Oong | MAS | 1
6 | V2079 | [NAME] | MAS | 2
7 | V1744 | [NAME] | CAN | 1
8 | V1752 | CHRISTENSEN [NAME] | CAN | 2
9 | V1813 | PARSONS [NAME] | CAN | 3
10 | V1800 | MCMYNN Bob | CAN | 4
11 | V1696 | THONGDEJSRI Chaisak | THA | 1
12 | V 1624 | PATET Sushil Kumar | IND | 1
13 | V1966 | [NAME] Bharat [NAME] | IND | 2
14 | V1601 | [NAME] | IND | 3
15 | V1510 | [NAME] | DEN | 1
16 | V1451 | DABELSTEEN Per | DEN | 2
17 | V1501 | GJELSTRUP Arne | DEN | 3
18 | V1460 | DUBOIS Jean Paul | FRA | 1
19 | V1514 | HARDY Didier | FRA | 2
20 | V2067 | YAMAMOTO Seiji | JPN | 1
21 | V1722 | [NAME] | JPN | 2
22 | V1694 | TERASAKI Yoshio | JPN | 3
23 | [NAME] | TOSHIJIMA Hirohisa | JPN | 4
24 | V1523 | HÖIJ  Per-Arnold | SWE | 1
25 | V1682 | [NAME] | GER | 1
26 | V1939 | [NAME] | GER | 2
27 | V1238 | KIEFER Matthias | GER | 3
28 | V1920 | DEMGENSKY Jürgen | GER | 4
29 | [NAME] | NYBERGH [NAME] | FIN | 1
30 | V1524 | HOLT Graham | ENG | 1
31 | V1468 | EMPTAGE [NAME] | ENG | 2
32 | V1889 | SELLICK Steven | ENG | 3
33 | V1892 | [NAME] | ENG | 4
34 | [NAME] | DOMMEYER Curt | USA | 1
35 | V2133 | CARTON David | USA | 2
36 | V2016 | [NAME] | IRL | 1
Spreadsheet: darrell_schoolcraft__7568__Gas Sales Confirmation
Sheet: 030102

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | Lokay |  |  | Company: |  |  | Astra Power
Deal Date: |  |  | 2002-03-19 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 03/20/2002 |  |  | FAX Number:
Total Quantity |  |  | 30000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 3.15
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
03/20/2002 | 03/20/2002 |  | 30000 | 30000 |  | 30000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 30000 |  |  |  | 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 refaxing to:
[NAME], Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 164209d1340692529-calculate-standings-sports-wk-in-progress
Sheet: Deelnemers en stand

Naam | punten |  | Naam | Punten | Plaats | Prijs |  | Aantal deelnemers:
 |  |  |  |  |  |  |  | aantal prijzen:
 |  |  |  |  |  |  |  | Prijzenpot:
 |  |  |  |  |  |  |  | Plek | Prijzen
 |  |  |  |  |  |  |  | 1e
 |  |  |  |  |  |  |  | 2e
 |  |  |  |  |  |  |  | 3e
 |  |  |  |  |  |  |  | 4e
Spreadsheet: 881620d1729755029-pasted-html-needs-re-arranging-to-be-able-to-sort-test
Sheet: Sheet1

 | A
B | C | D | E | F | G
 | A
B | C | D | E | F | G
 | A
B | C | D | E | F | G
 | A
B | C | D | E | F | G
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: OCCT

Old course number | New course number
OCCT-400 | OCCT-4400
OCCT-410 | OCCT-4000
OCCT-440 | OCCT-4500
OCCT-510 | OCCT-5510
OCCT-520 | OCCT-5520
OCCT-530 | OCCT-5530
OCCT-550 | OCCT-5500
OCCT-560 | OCCT-5560
OCCT-570 | OCCT-5570
OCCT-580 | OCCT-5580
OCCT-610 | OCCT-6100
OCCT-680 | OCCT-6800
OCCT-701 | OCCT-6710
OCCT-706 | OCCT-7705
OCCT-710 | OCCT-6000
OCCT-716 | OCCT-7706
OCCT-720 | OCCT-6730
OCCT-725 | OCCT-7000
OCCT-730 | OCCT-6740
OCCT-740 | OCCT-7740
OCCT-741 | OCCT-7742
OCCT-742 | OCCT-7210
OCCT-750 | OCCT-6720
OCCT-760 | OCCT-7750
OCCT-770 | OCCT-7760
OCCT-780 | OCCT-7790
OCCT-790 | OCCT-8310
OCCT-792 | OCCT-8320
OCCT-794 | OCCT-8330
OCCT-796 | OCCT-8350
OCCT-797 | OCCT-8370
OCCT-798 | OCCT-8340
OCCT-800 | OCCT-7810
OCCT-801 | OCCT-7811
OCCT-802 | OCCT-7220
OCCT-805 | OCCT-8430
OCCT-806 | OCCT-8440
OCCT-810 | OCCT-7820
OCCT-811 | OCCT-7821
OCCT-812 | OCCT-7230
OCCT-820 | OCCT-7830
OCCT-830 | OCCT-7780
OCCT-840 | OCCT-7840
OCCT-852 | OCCT-8520
OCCT-860 | OCCT-7835
OCCT-862 | OCCT-7836
OCCT-864 | OCCT-7850
OCCT-865 | OCCT-8910
OCCT-868 | OCCT-8920
OCCT-869 | [NAME]
OCCT-870 | OCCT-8900
OCCT-892 | OCCT-8410
OCCT-894 | OCCT-8420
OCCT-896 | OCCT-8360
OCCT-899 | OCCT-8510
OCCT-899 | OCCT-8520
OCCT-899 | OCCT-8530
OCCT-992 | OCCT-9900
OCCT-994 | OCCT-9920
OCCT-999 | OCCT-9910
Spreadsheet: 672400d1586862519-conditional-formatting-with-dates-conditional-formatting
Sheet: Sheet1

What I have |  |  |  | What I need to have |  |  |  | The rationale behind conditional formating
Letter date | Last chase date | Signed letter received |  | Letter date | Last chase date | Signed letter received
2020-04-01 00:00:00 | 2020-04-01 00:00:00 | 2020-04-05 00:00:00 |  | 2020-04-01 00:00:00 | 2020-04-01 00:00:00 | 2020-04-05 00:00:00 |  | Nothing happens since the letter was signed soon after being issued without additional chasing
2020-03-01 00:00:00 | 2020-03-01 00:00:00 |  |  | 2020-03-01 00:00:00 | 2020-03-01 00:00:00 |  |  | If Today() is over 30 days past "Last Chase Date", then it should be highlighted yellow
2020-02-01 00:00:00 | 2020-04-01 00:00:00 |  |  | 2020-02-01 00:00:00 | 2020-04-01 00:00:00 |  |  | Nothing happens since the last chase was less than a month ago, even though the letter date is over two months old
2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-02-15 00:00:00 |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-02-15 00:00:00 |  | F6 is no longer highlighted if "Signed Letter Received" has a date in it (i.e. no need to indicate further chasing), even though Last Chase Date is over a month from Today()
2019-12-01 00:00:00 | 2020-04-01 00:00:00 |  |  | 2019-12-01 00:00:00 | 2020-04-01 00:00:00 |  |  | The entire row needs to be red if "Signed Letter Received" is empty and Letter Date is over 5 months from Today()
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: Apr00

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
2000-04-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.8 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 2.82
IFGMR (PEPL/TX/OK) |  |  | 2.79
IFGMR (ANR/LA) |  |  | 2.82
IFGMR (HENRY HUB) |  |  | 2.88
NX3 |  |  | 2.92567
Sitara 10227
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
Sitara 10226
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5 |  | BASIS DIFFERENTIAL
TRIGGER* (LA) |  | 2.5 |  | IFGMR (HENRY HUB)
DIFFERENTIAL (TX) |  |  |  | LESS AVG IFGMR (TRKL/LA)
DIFFERENTIAL (LA) |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D | BASIS DIFFERENTIAL
 |  |  |  | IFGMR (HENRY HUB)
*Customer prefers rounding to nearest penny. |  |  |  | LESS AVG IFGMR(TRKL/TX)
 |  |  |  | BASIS DIFFERENTIAL
Spreadsheet: 845504d1697008231-show-working-instructions-depending-on-ghs-hazard-pictograms-sample-book-v2
Sheet: Search

 | Organische Peroxide CD
 | Possible Rooms: |  |  |  |  |  |  |  |  |  | Possible Rooms | Should be:
 | Room 1, depending, if possible in room 6 Room 2, [NAME] 10 g, if possible in room 6 Room 3, if possible in room 6 Room 4, if possible in room 6 |  |  |  |  |  |  |  |  |  |  | Room 2 , not allowed to be warmed , need to be in room 9
 |  |  |  |  |  |  |  |  |  |  | Room 3 | Room 3 , not allowed to be warmed , need to be in room 9
 |  |  |  |  |  |  |  |  |  |  | Room 4 | Room 4 , not allowed to be warmed , need to be in room 9
 |  |  |  |  |  |  |  |  |  |  | Room 6 , not allowed to be warmed | Room 6 , not allowed to be warmed
 |  |  |  |  |  |  |  |  |  |  | Room 7 , not allowed to be warmed | Room 7 , not allowed to be warmed
 |  |  |  |  |  |  |  |  |  |  | Room 9 , not allowed to be warmed | Room 9 , not allowed to be warmed
 | Chemical is a |  | Powder
 | Special Requirements: |  |  |  |  |  |  |  |  |  | Special Requirements
 | B12: be aware of B15: if, then do [NAME]: Need xy B59: not allowed to
Spreadsheet: 110818d1307413793-search-and-match-database
Sheet: Database 3

TAG_NUMBER | ASSET_NUMBER | CATEGORY | [NAME] | MANU_SERIAL_NO | MONITOR_SERIAL_NO | NAME | LOC_BUILDING | AK_COM_ASSET | LOC_FACING | REMARKS | PURCHASE_COST
00-RPO-OA-1 | 00-RPO-OA-1 | OE.SHR | IDEAL SHREDDER | 2074654 |  | choo ene | 001 | Y | BW | [TG]Common Asset | 1648.00
110030 | 110030 | EE.LAB | [NAME], -20 DEG C MODEL: BFS345 | [PHONE] |  | ene tan | 022 | N | 00 |  | 1000.00
110223 | 110223 | EE.GEN | ITEM CODE: SAR#BP1200 PRECISION BALANCE MODEL BP1200, CAPACITY: 1200G, READABILI | 13003500 |  | tin lay | 022 | N | 00 |  | 1668.00
111440 | 111440 | CP.PCO | HP 15" LCD MONITOR | TW11222910BH |  | tin lay | 000 | N | 00 |  | 1636.6
Spreadsheet: 849298d1699821877-how-do-i-sum-the-quantity-of-a-column-from-another-sheet-using-1-criteria-excel19
Sheet: Sheet1

 |  | Data set A |  |  | Data set B
 |  |  |  |  | ISIN | Price
 | Blue |  |  |  | Blue | 10
 | Red |  |  |  | Blue | 8
 | Yellow |  |  |  | Blue | 1
 | Black |  |  |  | Red | 1
 |  |  |  |  | Red | 2
 |  |  |  |  | Yellow | 5
 |  |  |  |  | Black | 9
Spreadsheet: 841882d1694010905-bisectional-method-using-recursive-lambda-recursive-bisection-method-lambda-1-
Sheet: Sheet 1

 |  |  |  |  |  |  |  | Min | [NAME] | X | Calculation | Goal | Diff | Termination
 |  |  |  |  |  |  |  | 11 | 500 | 200 |  | 555
Spreadsheet: 173158d1344452621-create-numerous-dynamic-range-listexample
Sheet: Sheet1

List 1 | List 2 | List 3 | List 4 | List 5 | List 6
Item 1 | Item 1 | Item 1 | Item 1 | Item 1 | Item 1
Item 2 | Item 2 | Item 2 | Item 2 | Item 2 | Item 2
Item 3 | Item 3 | Item 3 | Item 3 |  | Item 3
Item 4 | Item 4 | Item 4 | Item 4 |  | Item 4
Item 5 | Item 5 | Item 5 | Item 5 |  | Item 5
Item 6 | Item 6 | Item 6 | Item 6 |  | Item 6
Item 7 | Item 7 | Item 7 | Item 7 |  | Item 7
Item 8 | Item 8 | Item 8 | Item 8 |  | Item 8
Item 9 | Item 9 | Item 9 | Item 9 |  | Item 9
Item 10 | Item 10 |  | Item 10 |  | Item 10
Item 11 | Item 11 |  | Item 11 |  | Item 11
Item 12 | Item 12 |  | Item 12 |  | Item 12
Item 13 |  |  | Item 13 |  | Item 13
Item 14 |  |  | Item 14 |  | Item 14
Item 15 |  |  |  |  | Item 15
Item 16 |  |  |  |  | Item 16
Item 17 |  |  |  |  | Item 17
Spreadsheet: 213990d1360720437-summing-value-on-a-column-in-multiple-criterias-in-multiple-sheet-poc-sample-data
Sheet: Data

0 |  |  |  |  |  |  |  |  |  | 2013 | 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 |  |  |  |  |  |  |  |  |  | 12 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4
 |  |  |  |  |  |  |  |  |  | 2012-12-28 00:00:00 | 2013-01-04 00:00:00 | 2013-01-11 00:00:00 | 2013-01-18 00:00:00 | 2013-01-25 00:00:00 | 2013-02-01 00:00:00 | 2013-02-08 00:00:00 | 2013-02-15 00:00:00 | 2013-02-22 00:00:00 | 2013-03-01 00:00:00 | 2013-03-08 00:00:00 | 2013-03-15 00:00:00 | 2013-03-22 00:00:00 | 2013-03-29 00:00:00 | 2013-04-05 00:00:00
Current / Future / Unconfirmed | Type | Department | Program | Ship Hull | Design Process | Budgetted Manhours | Manhours Incurred (January '13) | Type | Total | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic | 17500 | 6401.050000000063 | Drawings (P) |  | 9 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | Drawings (A) |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | Man-Count (P)
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | Man-Count (A)
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | Manhours (P)
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | Manhours (A) | 331.3 | 113 | 128.3 | 90
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | POC
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | EAC
Ongoing | Military | Hull | RNO PV | RNO / Main | Basic |  |  | Productivity
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
Spreadsheet: 777227d1650268138-date-formatting-issue-errors-again
Sheet: Sheet1

Open Time | formated formula 1 | Formula 2
2022-04-01 00:05:15
2022-04-01 00:13:04
2022-04-03 11:10:20
2022-04-03 12:42:30
2022-04-04 10:05:39
2022-04-04 11:44:49
2022-04-05 09:52:46
2022-04-05 16:08:44
2022-04-05 16:13:51
2022-04-06 10:53:09
2022-04-06 12:02:40
2022-04-06 14:58:21
2022-04-07 13:02:21
2022-04-07 15:13:20
2022-10-04 11:26:00
2022-10-04 12:47:20
2022-10-04 14:32:51
2022-10-04 14:39:00
2022-11-04 10:51:27
2022-11-04 11:12:46
2022-11-04 11:22:21
2022-11-04 13:08:34
2022-11-04 13:34:07
2022-11-04 14:05:34
2022-12-04 11:33:25
2022-12-04 13:26:49
2022-12-04 14:22:19
14/04/2022 10:56:41
14/04/2022 13:11:50
14/04/2022 13:23:45
14/04/2022 13:43:08
14/04/2022 14:41:06
Spreadsheet: 872395d1718794880-sort-and-transpose-e-column
Sheet: Sheet1

 |  |  |  | A-1
 |  |  |  | A-7
 |  |  |  | A-8
 |  |  |  | [NAME]
 |  |  |  | A-10
 |  |  |  | A-11
 |  |  |  | A-12
 |  |  |  | A-13
 |  |  |  | A-14
 |  |  |  | A-15
 |  |  |  | A-17
 |  |  |  | A-18
 |  |  |  | A-19
 |  |  |  | A-20
 |  |  |  | A-21
 |  |  |  | A-24
 |  |  |  | A-25
 |  |  |  | A-26
 |  |  |  | A-27
 |  |  |  | A-29
 |  |  |  | A-30
 |  |  |  | A-31
 |  |  |  | A-32
 |  |  |  | A-33
 |  |  |  | [NAME]
 |  |  |  | A-28
 |  |  |  | A-35
 |  |  |  | A-37
 |  |  |  | A-40
 |  |  |  | A-39
 |  |  |  | A-41
 |  |  |  | A-90
 |  |  |  | A-43
 |  |  |  | A-44
 |  |  |  | A-45
 |  |  |  | A-100
 |  |  |  | A-46
 |  |  |  | A-143
 |  |  |  | A-50
 |  |  |  | A-48
 |  |  |  | A-47
 |  |  |  | A-52
 |  |  |  | A-53
 |  |  |  | A-49
 |  |  |  | A-55
 |  |  |  | A-59
 |  |  |  | A-60
 |  |  |  | A-56
 |  |  |  | A-61
 |  |  |  | A-206
 |  |  |  | A-64
 |  |  |  | A-66
 |  |  |  | A-67
 |  |  |  | A-68
 |  |  |  | A-69
 |  |  |  | A-70
 |  |  |  | A-71
 |  |  |  | A-72
 |  |  |  | A-73
 |  |  |  | A-74
 |  |  |  | A-75
 |  |  |  | A-76
 |  |  |  | A-77
 |  |  |  | A-78
 |  |  |  | A-79
 |  |  |  | A-80
 |  |  |  | A-81
 |  |  |  | A-82
 |  |  |  | A-83
 |  |  |  | A-84
 |  |  |  | A-85
 |  |  |  | A-86
 |  |  |  | A-87
 |  |  |  | A-42
 |  |  |  | A-63
 |  |  |  | A-91
 |  |  |  | A-92
 |  |  |  | A-93
 |  |  |  | A-94
 |  |  |  | A-95
 |  |  |  | A-96
 |  |  |  | A-65
 |  |  |  | A-99
 |  |  |  | A-51
 |  |  |  | A-132
 |  |  |  | A-101
 |  |  |  | A-102
 |  |  |  | A-103
 |  |  |  | A-104
 |  |  |  | A-105
 |  |  |  | A-106
 |  |  |  | A-111
 |  |  |  | A-98
 |  |  |  | A-107
 |  |  |  | A-108
 |  |  |  | A-208
 |  |  |  | A-97
 |  |  |  | A-112
 |  |  |  | A-114
 |  |  |  | A-122
 |  |  |  | A-136
 |  |  |  | A-130
 |  |  |  | A-119
 |  |  |  | A-124
 |  |  |  | A-127
 |  |  |  | A-128
 |  |  |  | A-129
 |  |  |  | A-144
 |  |  |  | A-109
 |  |  |  | A-131
 |  |  |  | A-148
 |  |  |  | A-134
 |  |  |  | A-123
 |  |  |  | A-125
 |  |  |  | A-137
 |  |  |  | A-133
 |  |  |  | A-135
 |  |  |  | A-54
 |  |  |  | [NAME]
 |  |  |  | A-139
 |  |  |  | A-145
 |  |  |  | A-146
 |  |  |  | A-147
 |  |  |  | A-155
 |  |  |  | A-140
 |  |  |  | A-149
 |  |  |  | A-151
 |  |  |  | A-152
 |  |  |  | A-150
 |  |  |  | A-154
 |  |  |  | A-153
 |  |  |  | A-156
 |  |  |  | A-210
 |  |  |  | A-158
 |  |  |  | [NAME]
 |  |  |  | A-211
 |  |  |  | A-170
 |  |  |  | A-160
 |  |  |  | [NAME]
 |  |  |  | A-173
 |  |  |  | [NAME]
 |  |  |  | A-176
 |  |  |  | A-171
 |  |  |  | A-178
 |  |  |  | A-179
 |  |  |  | A-205
 |  |  |  | A-181
 |  |  |  | A-182
 |  |  |  | A-183
 |  |  |  | A-174
 |  |  |  | A-177
 |  |  |  | [NAME]
 |  |  |  | A-187
 |  |  |  | A-184
 |  |  |  | A-191
 |  |  |  | A-192
 |  |  |  | A-193
 |  |  |  | A-180
 |  |  |  | A-195
 |  |  |  | A-196
 |  |  |  | A-197
 |  |  |  | A-198
 |  |  |  | A-199
 |  |  |  | A-200
 |  |  |  | A-201
 |  |  |  | A-202
 |  |  |  | A-203
 |  |  |  | A-204
 |  |  |  | [NAME]
 |  |  |  | A-126
 |  |  |  | A-207
 |  |  |  | A-186
 |  |  |  | A-209
 |  |  |  | A-190
Spreadsheet: 49135d1248384783-copy-row-from-multiple-worksheets-based-on-column-value-in-to-summary-tab-sales-unpaid-solver
Sheet: Invoice

 |  |  |  |  |  | Company Details
 | Company Logo
 |  |  |  |  |  | 1 | Unpaid Item #
 |  |  | Invoice Number: | 2 |  | 9 | # [NAME]
 | Client Name: |  | KPMG
 | Address: |  | 1 Habour Master Place
 |  |  | IFSC   Dublin  Ireland |  |  |  | Date
 |  |  |  |  |  |  | 2009-07-23 20:31:51
 | ITEM |  |  |  |  |  | €
 | Accounting Work |  |  |  |  |  | 50
 |  |  |  |  |  | Sub Total | 50
 |  |  |  |  |  | VAT | 10.75
 |  |  |  |  |  | Total | 60.75
Spreadsheet: 787023d1657608682-formula-to-find-the-multiple-values-and-consolidate-in-new-row-consolidatemultiplelines3
Sheet: Expected Result

 |  |  |  | Formula 1 | Formula 2 | Expected Result
Chars. | Task | Value | NewCol.
SKA1 | AA | TK01
SKA1 | BB | TE22
SKA1 | CC | VK10
SKA1 | DD | AS11 | AS11, AS26
SKA1 | DD | AS26 | AS11, AS26
SKA1 | EE | BA01
SKA1 | FF | BA02
SKA1 | HH
SKA1 | II
SKA1 | JJ
SKA1 | KK
SKA1 | LL
SKA1 | MM
SKA1 | NN
SKA1 | OO
SKA1 | PP
SKA1 | QQ
SKA1 | RR
SKA1 | SS
SKA1 | TT
SKA1 | UU
[NAME] | EE
[NAME] | FF
[NAME] | GG | 220 | 220, 260
[NAME] | GG | 260 | 220, 260
[NAME] | HH
[NAME] | II
[NAME] | JJ
[NAME] | KK
[NAME] | LL
SKT2 | AA
SKT2 | BB
SKT2 | CC
SKT2 | DD | BT20
SKT2 | DD | BA21
SKT2 | EE
SKT2 | FF
SKT2 | HH
SKT2
SKT2
Spreadsheet: 230b0f6b-a352-4170-ac71-b8394c47ab7b
Sheet: Sheet1

EVALIA Tech Data <EURO5 Step3) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Model
Drive |  |  | RHD/LHD
Body |  |  | LUDO
Length
Height
Engine |  |  | [NAME] |  |  |  | S2
 |  |  | 1,5dCi |  |  |  | 1.6
Grade |  |  | [NAME] | [NAME] | Upper | Upper | [NAME] | [NAME] | Upper | Upper
Payload
Detailed spec
Seats |  |  | 5 | 7 | 5 | 7 | 5 | 7 | 5 | 7
Applied Model RHD/LHD (Only For Reference) |  |  | 253/257 | 253/257 | 254/258 | 254/258 | 251/255 | 251/255 | 252/256 | 252/256
ENGINE
 | No. of Cylinders |  | 4 |  |  |  | 4
 | Valves per Cylinder |  | 2 |  |  |  | 4
 | Engine Capacity | cm3 | 1461 |  |  |  | 1597
 | Bore x Stroke | [NAME] | 76.0X80.5 |  |  |  | 78.0×83.6
 | Maximum Engine Power | hp | 89 (66kW) |  |  |  | 109(81kW)
 |  | rpm | 4000 |  |  |  | 6000
 | [NAME] | Nm | 200 |  |  |  | 153
 |  | rpm | 1750 |  |  |  | 4400
 | Compression Ratio |  | 18.8 |  |  |  | 9.8
 | Fuel Type |  | Diesel |  |  |  | Petrol
 | Fuel Supply
 | Battery 12v | Ah | 62 |  |  |  | 45
 | Alternator | Amps | 110/150* |  |  |  | 110
DRIVE TRAIN
 | Clutch type
 | Gearbox | Type
 | [NAME] |  | 5 |  |  |  | 5
 | Gearbox performances | 1st* | 3727 |  |  |  | 3727
 |  | 2nd* | 2048 |  |  |  | 2048
 |  | 3rd* | 1321 |  |  |  | 1393
 |  | 4th* | 0.971 |  |  |  | 1097
 |  | 5th* | 0.738 |  |  |  | 0.892
 |  | 6th*
 |  | Rev
 | Final drive ratio |  | 3.867 |  |  |  | 4.067
 | Driven Wheels
 | * Speed (Km/h) per 1000 rpm
CHASSIS
 | Suspension
 | Steering
 | Breaking System (option)
 | [NAME]
 | [NAME] | [NAME]
 |  | Optional
FUEL CONSUMPTION & EMISSIONS
 | Fuel Consumption | [NAME] | 5.8 |  |  |  | 9.1
 | EEC 00/100 | [NAME] | 4.9 |  |  |  | 6.3
 |  | [NAME] | 5.3 |  |  |  | 7.3
 | CO2   mas Emission (Combined) | g/Km. | 138 |  |  |  | 169
 | According Directive 80/1268/CEE CEE; Last amendment 2004/3/CE
PERFORMANCE
 | Maximum Speed | Km/h | 158 |  |  |  | 165
 | Min. Turning Circle (Wall to Wall) | m
 | Min. Turning [NAME] ([NAME] to Kerb) | m
WEIGHTS
 | Gross Vehicle Weight | Kg | 2030 |  |  |  | 1980
 | Curb Weight | Kg | 1368 | 1411 | 1368 | 1411 | 1325 | 1369 | 1325 | 1369
 | Maximum Payload | Kg | 662 | 619 | 662 | 619 | 655 | 611 | 655 | 611
 | [NAME] Weight | Kg | 960 | 967 | 960 | 967 | 897 | 900 | 897 | 900
 |  | Kg | 1070 | 1063 | 1070 | 1063 | 1083 | 1080 | 1083 | 1080
 | [NAME]. [NAME]. | Kg | 1100 |  |  |  | 1100
 |  | Kg | 640 |  |  |  | 640
OVERALL DIMENSIONS
 | Length | [NAME]
 | [NAME] with mirrors | [NAME]
 | [NAME] w/o mirrors | [NAME]
 | Height       (Unladen) | [NAME]
 | Wheelbase | [NAME]
 | Overhang | [NAME]
 |  | [NAME]
 | Track | [NAME]
 |  | [NAME]
 | [NAME] (unladen) | [NAME]
LUGGAGE / CARGO AREA DIMENSIONS
 | Maximum Length | [NAME] | -
 | [NAME] | [NAME] | 1495
 | [NAME] | [NAME] | 1305
 | Minimum Width between the Wheelarches | [NAME] | -
 | [NAME](Unladen) | [NAME] | 524
 | Cargo Volume(Max Cube) | m3 | -
 |  | m3 | 2
 |  | m3 | 3,0/2,9
 | Slide Door | [NAME] | 693
 |  | [NAME] | 1171
 | Back Door | [NAME] | 1262
 |  | [NAME] | 1228
FUEL TANK
 | Fuel tank capacity | l.