tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 01b51d9f-dd39-4ba0-8004-a624752f6cb0
Sheet: +40 WS 

BWF World Senior Championships 2013
WS 40 |  |  |  |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Quarterfinals | Semifinals | Final | Winner
1 | 2761 |  | DEN |  | [NAME] [1]
2 |  |  |  |  | Bye 1
3 | 71747 |  | SWE |  | Ulla Jark
4 | 64638 |  | ENG |  | [NAME]
5 | 7457 |  | TUR |  | Elif Yoruker
6 | 66958 |  | FRA |  | [NAME]
7 | 91937 |  | IND |  | [NAME]
8 | 84884 |  | JPN |  | [NAME]
9 | 98602 |  | FRA |  | [NAME] Pimpec [3/4]
10 |  |  |  |  | Bye 3
11 | 7627 |  | GER |  | [NAME]
12 | 85973 |  | NOR |  | Kristin Thomt
13 | 75661 |  | IND |  | [NAME]
14 | 74771 |  | TUR |  | Serpil Sarper
15 | 381 |  | ENG |  | [NAME] ~
16 | 78380 |  | JPN |  | [NAME]
17 | 83863 |  | SWE |  | Marina Karstrom
18 | 94752 |  | RUS |  | [NAME]
19 | 794 |  | HUN |  | Csilla Gondane Forian
20 | 81718 |  | FRA |  | [NAME]
21 | 7456 |  | TUR |  | [NAME]
22 | 89522 |  | GER |  | [NAME]
23 | 90784 |  | ENG |  | [NAME]
24 | 92818 |  | IND |  | Poonam Tatwawadi [3/4]
25 | 69326 |  | TUR |  | [NAME]
26 | 98416 |  | ENG |  | Caroline Hale
27 | 52794 |  | BUL |  | [NAME]
28 | 6889 |  | GER |  | Heike Voigt
29 | 68725 |  | IND |  | Ulka Sangore
30 | 94221 |  | FRA |  | [NAME]
31 |  |  |  |  | Bye 2
32 | 63956 |  | JPN |  | [NAME] [2]
Spreadsheet: 44872d1243603627-sorting-help-the-excel-way-example-data
Sheet: Sheet1

Colorado
Example Company
631 Weld County Road, Unit 2
Erie, Colorado 80516
USA
telephone: [PHONE] or [PHONE]
fax: [PHONE]
email: [EMAIL]
web: http://www.example-co.com
Conneticut
Example Company
PO Box 1100
[NAME], CT 06074
USA
telephone: [PHONE] or [PHONE]
fax: [PHONE]
email: [EMAIL]
web: http://www.example-co.com
Florida
Example Company
99999 Cross Street Suite 213
[NAME], FL 33950
USA
telephone: [PHONE] or [PHONE]
fax: [PHONE]
email: [EMAIL]
web: http://www.example-co.com
Example Company
12345 N US HWY 1 STE 4
Ormond Beach, FL 32174
USA
telephone: [PHONE] or [PHONE]
fax: [PHONE]
email: [EMAIL]
web: http://www.example-co.com
Example Company
18026 Bulls Bay Hwy Unit 2A
Jacksonville, FL 32219
USA
telephone: [PHONE] or [PHONE]
fax: [PHONE]
email: [EMAIL]
web: http://www.example-co.com
Example Company
123 SW [NAME]
Lake City, FL 32024
USA
telephone: [PHONE] or [PHONE]
web: http://www.example-co.com
Spreadsheet: 776128d1649512783-look-up-ids-that-meet-condition-on-sheet2-and-output-details-for-the-id-and-more-to-sheet1-test22
Sheet: Sheet2

 |  |  | ID | Family Name | First Name |  | Position Name
 |  |  | 8450089035 | Smith | [NAME] |  | Reporting
 |  |  | 8450089035 | Smith | [NAME] |  | Reporting
 |  |  | 8450089035 | Smith | [NAME] |  | Reporting
 |  |  | 309535517036 | Doe | [NAME] |  | Normal
 |  |  | 309535517036 | Doe | [NAME] |  | Normal
 |  |  | 480673804039 | [NAME] | Julie |  | Reporting
 |  |  | 480673804039 | [NAME] | Julie |  | Reporting
 |  |  | 579059252100 | [NAME] | Gillian |  | Reporting
 |  |  | 579115681109 | [NAME] | Suzanne |  | Normal
Spreadsheet: 162390d1339846785-inserting-data-from-a-table-to-another-sheet-multiple-entries-via-drop-down-menu-ef111_example_excelforum
Sheet: Database_old

Type | Name | Age | Weight
Dog
 | [NAME] | 3 | 50
 | Rex | 5 | 12
 | Tramp | 1 | 4
Cat
 | Whiskers | 11 | 2
 | [NAME] | 5 | 1
 | [NAME] | 7 | 3
Horse
 | Jolly Jumper | 5 | 450
 | Silver | 7 | 700
 | ShadowFax | 6 | 500
 |  |  |  |  | <- I would like to be able to add more entries here, without reprogramming the calculation sheet
Spreadsheet: 216416d1361768613-count-only-unique-values-in-pivot-table-count-unique-values
Sheet: Master

Position | Transition | Reference | START/EFFECTIVE DATE | TO BE POS # | TO BE POSITION TITLE
902088 | [NAME] | TBAF
52224G | [NAME] | TBAJ
55139G | Mapped | TBDB
G00379 | Transfer | TBPC
G00412 | Transfer | [NAME]
G00377 | Mapped | TBAF
G00493 | [NAME] | TBAJ
52224G | [NAME] | TBDB
902774 | [NAME] | TBPC
32238G | [NAME] | [NAME]
48209G | Transfer | TBAF
903392 | Transfer | TBAJ
32228G | Transfer | TBDB
32209G | Transfer | TBPC
G00796 | Transfer | [NAME]
32228G | Transfer | TBAF
32219G | Transfer | TBAJ
903344 | Transfer | TBDB
G01072 | Mapped | TBPC |  | G01072 | Associate Librarian
32230G | Transfer | [NAME]
32206G | Transfer | TBAF
G00673 | Transfer | TBAJ
903307 | Transfer | TBDB
48249G | Transfer | TBPC
G00627 | Transfer | [NAME] |  | G00627 | Finance Team Leader
903572 | Transfer | TBAF
32213G | Transfer | TBAJ |  |  | Receivables Officer
G00104 | Transfer | TBDB |  | G00104 | Finance Coordinator
G00104 | Transfer | TBDB |  |  | Manager [NAME]
32215G | Transfer | [NAME]
32234G | Transfer | TBAF
903563 | Transfer | TBAJ
32226G | Transfer | TBDB
G00479 | Transfer | TBPC
25104G | New | [NAME] |  | 25104G | Manager, Finance And Administration
32234G | Transfer | TBAF
G00673 | Transfer | TBAJ
901946 | New | TBDB |  |  | Director, Finance Systems and Processing
32243G | New | TBPC
Spreadsheet: 74111d1274715810-vlookup-with-nested-if-statements-excel_help
Sheet: Sheet1

Number | Date Originated | Date Completed | Needs to be Completed by: | Time Status | # Workdays Open | Status
SCAR00002 | 2009-11-03 16:36:37 | 2009-12-09 13:45:24 | 2010-01-08 00:00:00 | On Time | 26 | Closed
SCAR00003 | 2009-11-04 13:11:21 | 2010-01-05 14:59:46 | 2010-01-11 00:00:00 | On Time | 42 | Closed
SCAR00004 | 2009-12-10 16:17:55 | 2010-04-15 12:36:00 | 2010-02-16 00:00:00 | Overdue | 88 | Closed
SCAR00005 | 2009-12-16 13:43:53 | 2010-01-14 15:28:50 | 2010-02-22 00:00:00 | On Time | 20 | Closed
SCAR00006 | 2009-12-16 13:57:48 | 2010-04-19 12:55:41 | 2010-02-22 00:00:00 | Overdue | 86 | Closed
SCAR00007 | 2009-12-17 10:49:56 | 2010-02-22 08:02:03 | 2010-02-23 00:00:00 | On Time | 45 | Closed
SCAR00008 | 2009-12-22 09:20:45 | 2010-01-14 14:51:43 | 2010-02-26 00:00:00 | On Time | 16 | Closed
SCAR00009 | 2010-01-18 12:56:14 | 2010-02-11 10:24:58 | 2010-03-23 00:00:00 | On Time | 19 | Closed
SCAR00010 | 2010-01-18 16:24:01 | 2010-04-27 10:15:43 | 2010-03-23 00:00:00 | Overdue | 71 | Closed
SCAR00011 | 2010-01-18 16:39:29 | 2010-04-27 10:14:25 | 2010-03-23 00:00:00 | Overdue | 71 | Closed
SCAR00013 | 2010-01-20 10:08:28 | 2010-02-09 08:57:44 | 2010-03-25 00:00:00 | On Time | 15 | Closed
SCAR00015 | 2010-02-03 13:20:52 | 2010-02-08 16:40:02 | 2010-04-08 00:00:00 | On Time | 4 | Closed
SCAR00016 | 2010-02-09 11:32:46 | 2010-02-23 10:58:55 | 2010-04-14 00:00:00 | On Time | 10 | Closed
SCAR00018 | 2010-03-02 13:59:24 | 2010-04-07 09:02:36 | 2010-05-04 00:00:00 | On Time | 27 | Closed
SCAR00019 | 2010-03-02 14:31:18 | 2010-04-07 08:59:49 | 2010-05-04 00:00:00 | On Time | 27 | Closed
SCAR00020 | 2010-03-02 16:11:24 | 2010-03-11 12:56:00 | 2010-05-04 00:00:00 | On Time | 8 | Closed
SCAR00021 | 2010-03-08 09:47:20 | 2010-04-12 10:41:41 | 2010-05-10 00:00:00 | On Time | 26 | Closed
SCAR00022 | 2010-03-09 10:18:21 | 2010-04-07 08:51:01 | 2010-05-11 00:00:00 | On Time | 22 | Closed
SCAR00023 | 2010-03-09 10:55:03 | 2010-04-07 08:53:27 | 2010-05-11 00:00:00 | On Time | 22 | Closed
SCAR00024 | 2010-03-11 15:24:44 | 2010-03-16 17:27:57 | 2010-05-13 00:00:00 | On Time | 4 | Closed
SCAR00025 | 2010-03-16 16:56:48 | 2010-03-19 07:28:48 | 2010-05-18 00:00:00 | On Time | 4 | Closed
SCAR00027 | 2010-04-01 13:50:49 | 2010-05-19 11:47:40 | 2010-06-04 00:00:00 | On Time | 35 | Closed
SCAR00028 | 2010-04-15 11:16:38 | 2010-05-19 15:45:18 | 2010-06-18 00:00:00 | On Time | 25 | Closed
SCAR00029 | 2010-04-22 10:56:53 | 2010-04-28 10:44:25 | 2010-06-25 00:00:00 | On Time | 5 | Closed
SCAR00030 | 2010-04-22 11:19:20 | 2010-04-28 10:39:20 | 2010-06-25 00:00:00 | On Time | 5 | Closed
SCAR00031 | 2010-05-04 11:24:59 |  | 2010-07-07 00:00:00 | Not yet completed | 15 | Acknowledged
SCAR00032 | 2010-05-17 14:18:35 |  | 2010-07-20 00:00:00 | Not yet completed | 6 | Acknowledged
Spreadsheet: 7b1e1e09-e503-4951-8b2e-3001393759cf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6548 | 32709 | [NAME] | Mcginty | GBR | 220 | 01:28:21 | 00:00:00 | 03:43:31 | 00:01:34 | 02:34:15 | 1 | 07:47:43
6548 | 8792 | Imke | Hofling | FIN | 217 | 01:12:22 | 00:00:00 | 04:00:25 | [NAME] | 02:43:28 | 2 | 07:57:59
6548 | 7869 | Katja | [NAME] | FIN | 219 | 01:36:46 | 00:00:00 | 03:54:14 | 00:01:27 | 03:05:31 | 3 | 08:38:01
Spreadsheet: fbd58c68-fc5f-46f4-8645-d2ca1db6cad3
Sheet: Sheet1

Listi | Unnamed: 1
V-1 | Tekjur, gjöld og jöfnuður hins opinbera
V-2 | Tekjur, gjöld og jöfnuður ríkissjóðs
V-3 | Tekjur, gjöld og [NAME]
V-4 | Tekjur og gjöld sveitarfélaga
V-5 | Skuldir ríkisssjóðs og sveitarfélaga við lánakerfið
V-6 | Tekjuafgangur og hreinn lánsfjárafgangur ríkissjóðs
V-7 | Reglulegar tekjur ríkissjóðs án eignasölu og gjöld án vaxta
V-8 | Þróun skatttekna ríkissjóðs
V-9 | Ríkisútjöld eftir tegundum
V-10 | Þróun ríkisútgjalda, [NAME]
Spreadsheet: 133479d1324414487-excel-2007-sorting-my-estimate-log-for-follow-up-estimate-log-follow-up
Sheet: Sheet2

Status Codes: 1= we have job; 2= cust. has job; 3= unquoted cust has job; 4=low bidder; 5= lost job, 6= n/a
Quote | Fax List |  | Bid Date | Log In By | Log In Date | Hrs | Ductwork | Est | REP | Rect | Spiral | Customer | Phone Call
 |  | YTD  Totals
 |  | IF(ISERROR(FIND("Cam-ful",'2011'!M803,1)),"No","Yes")
Spreadsheet: 51558d1251209265-prevent-advanced-filter-matching-partial-string-697006_mdw
Sheet: Sheet1

ip address |  | ip address
5.0.19.224
5.0.21.96
5.0.21.104
5.2.12.48
5.2.14.162
5.2.12.80
5.2.13.64
5.2.14.161
5.2.13.96
5.2.13.240
5.2.14.0
5.2.14.16
5.2.14.32
5.2.14.64
5.2.14.96
5.2.14.112
5.2.14.128
5.2.14.160
5.2.14.176
5.2.14.208
Spreadsheet: 768918d1645200692-extract-values-using-if-condition-depened-on-numbers-in-another-columns-book2
Sheet: Sheet1

 | -- | RESULT
 | 1.6873298 | 0.607597 |  |  | 0.1 | 0
 | 1.7 | 0.456948 |  |  | 0.2 | 0
 | 1.776747 | 0.456948 |  |  | 0.3 | 0.393548
 | 1.7469783 | 0.456948 |  |  | 0.4 | 2.71474
 | 1.7621841 | 0.456948 |  |  | 0.5 | 1.06199
 | 1.7233404 | 0.456948 |  |  | 0.6 | 0.000349998
 | 1.6855197 | 0.607597 |  |  | 0.7 | 0.213649
 | 1.5980523 | 0.607597 |  |  | 0.8 | 0.289149
 | 1.5732062 | 0.741196 |  |  | 0.9 | 0.265949
 | 1.5705619 | 0.741196 |  |  | 1 | 0.349198
 | 1.6415219 | 0.607597 |  |  | 1.1 | 0.318198
 |  |  |  |  | 1.2 | 0.473598
 |  |  |  |  | 1.3 | 0.481748
 |  |  |  |  | 1.4 | 0.563347
 |  |  |  |  | 1.5 | 0.741196
 |  |  |  |  | 1.6 | 0.607597
 |  |  |  |  | 1.7 | 0.456948
 |  |  |  |  | 1.8 | 0.261099
 |  |  |  |  | 1.9 | 0.207449
 |  |  |  |  | 2 | 0.177799
 |  |  |  |  | 2.1 | 0.163249
 |  |  |  |  | 2.2 | 0.118999
 |  |  |  |  | 2.3 | 0.0680997
 |  |  |  |  | 2.4 | 0.0319498
 |  |  |  |  | 2.5 | 0.0179499
 |  |  |  |  | 2.6 | 0.0119999
 |  |  |  |  | 2.7 | 0.00669997
 |  |  |  |  | 2.8 | 0.00299999
 |  |  |  |  | 2.9 | 0.000499998
 |  |  |  |  | 3 | 0
 |  |  |  |  | 3.1 | 0
Spreadsheet: 132110d1323499282-countif-countif
Sheet: Sheet2

 | cust_custnmbr | loc_adrscode | cust_custname | customer_id | site_id
 | WYNDHA | AFS | WYNDHAM JADE | 1025368 | 2155143
 | WYNDHA | [NAME] | WYNDHAM JADE | 1025368 | 2155144
 | WYNDHA | [NAME] | WYNDHAM JADE | 1025368 | 2155145
 | WYNDHA | PRIMARY | WYNDHAM JADE | 1025368 | 2155142
 | XANGO | 2889 WEST ASHTO | XANGO LLC | 1025405 | 2155724
 | XANGO | 3098 MARK | XANGO LLC | 1025405 | 2155726
 | XANGO | CRAIG YATES | XANGO LLC | 1025405 | 2155720
 | XANGO | JOSH SMITH | XANGO LLC | 1025405 | 2155725
 | XANGO | [NAME] | XANGO LLC | 1025405 | 2155727
 | XANGO | PRIMARY | XANGO LLC | 1025405 | 2155721
 | XANGO | SOUTH JORDAN | XANGO LLC | 1025405 | 2155723
 | XANGO | XANGO2 | XANGO LLC | 1025405 | 2155722
 | XELA-WHOLESALE | MATAWAN | LEGAL-XELA, LLC | 1025802 | 2159827
 | XELA-WHOLESALE | PHILADELPHIA | LEGAL-XELA, LLC | 1025802 | 2159826
 | XPS | GILBERT ROAD | XPS | 1026024 | 2161474
 | XPS | PRIMARY | XPS | 1026024 | 2161473
 | YAKIMA PRODUCTS | BEAVERTON | YAKIMA PRODUCTS, INC. | 1025632 | 2158697
 | YAKIMA PRODUCTS | MEXICO | YAKIMA PRODUCTS, INC. | 1025632 | 2158695
 | YAKIMA PRODUCTS | [NAME] | YAKIMA PRODUCTS, INC. | 1025632 | 2158696
 | YOUNG AMERICA | BILL TO | YOUNG AMERICA | 1025791 | 2159800
 | YOUNG AMERICA | EDINA | YOUNG AMERICA | 1025791 | 2159801
 | YOUNG AMERICA | YOUNG AMERICA | YOUNG AMERICA | 1025791 | 2159802
 | YOUNG LIVING | ACCOUNTS PAYABL | YOUNG LIVING ESSENTIAL OILS | 1025539 | 2157953
 | YOUNG LIVING | CROSS TELECOM | YOUNG LIVING ESSENTIAL OILS | 1025539 | 2157951
 | YOUNG LIVING | LEHI | YOUNG LIVING ESSENTIAL OILS | 1025539 | 2157954
 | YOUNG LIVING | SPANISH FORK | YOUNG LIVING ESSENTIAL OILS | 1025539 | 2157952
 | ZACHRY | 12650 N FEATHER | ZACHRY HOLDINGS INC | 1025394 | 2155594
 | ZACHRY | 310 ST MARY'S | ZACHRY HOLDINGS INC | 1025394 | 2155591
 | ZACHRY | 6100 BANDERA | ZACHRY HOLDINGS INC | 1025394 | 2155592
 | ZACHRY | ACS/DALLAS | ZACHRY HOLDINGS INC | 1025394 | 2155584
 | ZACHRY | EASTOVER | ZACHRY HOLDINGS INC | 1025394 | 2155583
 | ZACHRY | EL PASO | ZACHRY HOLDINGS INC | 1025394 | 2155589
 | ZACHRY | FREEPORT | ZACHRY HOLDINGS INC | 1025394 | 2155588
 | ZACHRY | HOUSTON | ZACHRY HOLDINGS INC | 1025394 | 2155587
 | ZACHRY | MCCLELLAN | ZACHRY HOLDINGS INC | 1025394 | 2155581
 | ZACHRY | NEBRASKA CITY | ZACHRY HOLDINGS INC | 1025394 | 2155585
 | ZACHRY | OSCEOLA | ZACHRY HOLDINGS INC | 1025394 | 2155586
 | ZACHRY | PO BOX 240130 | ZACHRY HOLDINGS INC | 1025394 | 2155593
 | ZACHRY | PRIMARY | ZACHRY HOLDINGS INC | 1025394 | 2155580
 | ZACHRY | SAN ANTONIO | ZACHRY HOLDINGS INC | 1025394 | 2155582
 | ZACHRY | ZACH BILL TO | ZACHRY HOLDINGS INC | 1025394 | 2155590
Spreadsheet: 571746d1525083804-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-ans
Sheet: Sheet1

 |  |  | Inflation
 |  |  | Year | 2018
 |  |  |  | 0.01 | 0.02 | 0.03 | 0.02 | 0.05
 |  |  | Tenant | Annual rent | Indexation
 |  |  | 1 | 1000 | annual | 1
 |  |  | 2 | 1000 | Every 2nd year | 2
 |  |  | 3 | 1500 | every third year | 3
 |  |  |  |  |  |  |  |  |  | Rent income exc. Indexation
 |  |  |  |  |  |  |  |  |  | Year | 2018
 |  |  |  |  |  |  |  |  |  | Tenant 1
 |  |  |  |  |  |  |  |  |  | [NAME] | 1000
 |  |  |  |  |  |  |  |  |  | Tenant 3 | 1500
 |  |  |  |  |  |  |  |  |  | End result
 |  |  |  |  |  |  |  |  |  | Rent income inc. Indexation
 |  |  |  |  |  |  |  |  | Year | Annual rent | 2018 | 2019 | 2020 | 2021 | 2022
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | End result
 |  |  |  |  |  |  |  |  |  | Rent income inc. Indexation
 |  |  |  |  |  |  |  |  |  | Year | 2018 | 2019 | 2020 | 2021 | 2022
 |  |  |  |  |  |  |  |  |  | Tenant 1 | 1010 | 1030.2 | 1061.106 | 1082.32812 | 1136.444526
 |  |  |  |  |  |  |  |  |  | [NAME] | 1000 | 1030.2 | 1030.2 | 1082.32812 | 1082.32812
 |  |  |  |  |  |  |  |  |  | Tenant 3 | 1500 | 1500 | 1591.659 | 1591.659 | 1591.659
Spreadsheet: 726408d1617213275-power-pivot-measure-to-sum-unpivoted-values-inquiry1
Sheet: Data 4

ID | Employee |  |  |  |  | Month
1 | Alp |  |  | Account | Name | January | February | March | 1. How to display month-over-month?
 | Bet |  |  | 3000 | Earnings
 | Cio |  |  | 3200 | Bonus |  |  |  | 2. [NAME] to show earnings total month/month?
 | Del |  |  | 3300 | Tax
 | Eps |  |  | Grand Total
 | Fal
 | Guy
 | Hyz
 | Isa
 | [NAME] |  |  | Total Earning |  | Month
 |  |  |  | Account | Name | February | January | March | Grand Total
 |  |  |  | 3000 | Earnings | 6349.2 | 5291 | 4761.9 | 16402.1
 |  |  |  | 3200 | Bonus | 1587.3 | 1322.75 | 1190.475 | 4100.525000000001
 |  |  |  | 3300 | Tax | 1984.125 | 1653.4375 | 1488.09375 | 5125.65625
 |  |  |  | Grand Total |  | 9920.625 | 8267.1875 | 7440.46875 | 25628.28125
Name | Account
Earnings | 3000
Bonus | 3200
Tax | 3300
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: CANADA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19997 | -19960
2 | -20003 | -19960
3 | -19992 | -19793
4 | -20005 | -19793
5 | -20009 | -19960
6 | -19990 | -19960
7 | -20005 | -19960
8 | -19998 | -19960
9 | -19952 | -19960
10 | -19866 | -19688
11 | -20118 | -19960
12 | -20505 | -19960
13 | -34856 | -34960
14 | -34868 | -34960
15 | -18657 | -18478
16 | -19098 | -18953
17 | -18990 | -18596
18 | -19004 | -18596
19 | -8320 | -14485
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 0
2002-03-19 00:00:00
CBS Dollars
 |  |  | 0
Spreadsheet: 674546d1587904822-conditional-formatting-based-on-cell-values-condformtest
Sheet: Sheet1

Approved Overdraft | 2000 | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period |  |  | Forecast for time period
 |  | 2019-12-30 00:00:00
 |  | 1
 |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual |  | Planned | Actual
 | OPENING CASH BALANCE | 500 | 500 |  | -8575 | -500 |  | 2000 |  |  | -1000
So, in the above example I wold like the cells to be coloured as follows:
F5 - because the value is <B1 it should be Red
I5 - because the value is >0 it should be normal
L5 - because the value is between -0.01 and -(B1) is should be Amber
The formula looks at the value in each cell on row5 ans applies the corret colour based on the value in that cell
Spreadsheet: 482987d1475408029-calculate-the-growth-book3
Sheet: Sheet1

Coy ID | Auction  ID | Item ID | Member ID | Bid Value | Created On | Product Cost | Type of Product | Same Member | Growth
HSG | auc_olympus | [PHONE] | 110586 | 65 | 2016-08-12 12:08:49 | 600 | D
HSG | auc_samsung | [PHONE] | 110586 | 86 | 2016-08-12 12:07:56 | 800 | B
HSG | auc_notepink | [PHONE] | 110586 | 72 | 2016-09-07 09:09:11 | 400 | D
HSG | auc_xbox1 | [PHONE] | 547610 | 55 | 2016-09-09 23:04:31 | 500 | C
HSG | auc_notepink | [PHONE] | 3693915 | 150 | 2016-09-04 23:36:34 | 400 | D
HSG | auc_dellmtr | [PHONE] | 3693915 | 200 | 2016-09-24 10:09:19 | 1000 | A
HSG | auc_notepink | [PHONE] | 19920329 | 150 | 2016-08-31 14:43:51 | 400 | D
HSG | auc_samgear | [PHONE] | 19920329 | 30 | 2016-08-29 10:52:06 | 700 | B
HSG | auc_jbl | [PHONE] | 19920329 | 30 | 2016-08-20 18:03:50 | 245 | A
HSG | auc_jbl | [PHONE] | 25850459 | 14 | 2016-08-18 21:47:43 | 245 | A
HSG | auc_samsung | [PHONE] | 25850459 | 55 | 2016-08-13 12:50:18 | 800 | B
HSG | auc_olympus | [PHONE] | 25850459 | 13 | 2016-08-13 12:52:45 | 600 | D
HSG | auc_xbox1 | [PHONE] | 30540211 | 2 | 2016-09-09 14:10:47 | 500 | C
HSG | [NAME] | [PHONE] | 30540211 | 5 | 2016-09-09 14:11:36 | 1345 | B
HSG | auc_dellaw | [PHONE] | 51110917 | 300 | 2016-09-24 20:48:48 | 500 | A
HSG | auc_samsung3 | [PHONE] | 51110917 | 20 | 2016-09-24 20:50:12 | 100 | B
Spreadsheet: 105912d1303193127-how-to-do-sumif-if-the-range-of-cells-are-formulated-for-ageing-days-excel-help
Sheet: A

Inv Ref | Invoice date | Invoice due date | Invoice amount | Currency | USD | Ageing
ABC | 2010-12-01 00:00:00 | 2011-02-02 00:00:00 | 50000 | USD | 50000 | OVER 120
DEF | 2011-01-01 00:00:00 | 2011-03-02 00:00:00 | 55000 | USD | 55000 | >90
GHI | 2011-02-01 00:00:00 | 2011-04-02 00:00:00 | 150000 | USD | 150000 | >60
JKL | 2011-03-01 00:00:00 | 2011-05-02 00:00:00 | 150000 | USD | 150000 | >30
MNO | 2011-04-01 00:00:00 | 2011-06-02 00:00:00 | 150000 | USD | 150000 | <30
 |  |  | 555000 |  | 555000
Spreadsheet: 729056d1618889273-need-a-formula-for-profit-loss-that-can-reference-different-rows-of-data-example
Sheet: New Template

Open Positions |  |  |  |  |  |  |  |  |  | Closing Data
Opened On | Symbol | Action | Instrument | Exp. | Strike | Qty. | Price | Total | DTE | Closed On | Symbol | Action | Instrument | Exp. | Strike | Qty. | Price | Total | P/L
2021-04-13 00:00:00 | ABC | BTO | Call | 2021-04-23 00:00:00 | 50 | 5 | 1 |  |  | 2021-04-13 00:00:00 | ABC | STC | Call | 2021-04-23 00:00:00 | 50 | -5 | 0.75 |  |  |  | Closing quantity matched opening quantity so only 1 line needed | =P3+(I3*ABS(N3)/G3)
2021-03-26 00:00:00 | XYZ | BTO | Call | 2022-01-20 00:00:00 | 30 | 1 | 2.5 |  |  |  | XYZ |  | Call | 2022-01-20 00:00:00 | 30 |  |  |  |  |  | Waiting for closing data but can only take up 1 line | =P4+(I4*ABS(N4)/G4)
2021-03-01 00:00:00 | ABC | BTO | Call | 2021-06-18 00:00:00 | 32 | 2 | 0.3 |  |  | 2021-03-08 00:00:00 | ABC | STC | Call | 2021-06-18 00:00:00 | 32 | -1 | 0.7 |  |  |  | Opening quantity=2, only 1 transaction in this group closed on 08-Mar-21 | =P5+(I5*ABS(N5)/G5)
 |  |  |  |  |  |  |  |  |  |  | ABC |  | Call | 2021-06-18 00:00:00 | 32 |  |  |  |  |  | 2nd closing transaction will go on this line, but if drag down the formula from the upper cell there will be no data on the left side to reference
2021-03-01 00:00:00 | XYZ | BTO | Call | 2021-04-09 00:00:00 | 31 | 4 | 0.5 |  |  | 2021-03-24 00:00:00 | XYZ | STC | Call | 2021-04-09 00:00:00 | 31 | -4 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | can | drag | down | that | specifies | which | row | to | look | in.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | stock/options | trading | spreadsheet. | I | have | a | profit/loss | column | that | references | transaction | data | in | adjacent | rows. | I | would | like | a | formula | I | can | drag | down | that | specifies | which | row | to | look | in.