tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726189d1617103101-combine-values-in-multiple-cells-by-commas-sample-excel-sheet
Sheet: Input

ctextid | vbillid | claimid | proccode | completed | codedby
1412 | 456 | 123 | 3074F | 2021-03-25 03:18:15 | bs12
1412 | 456 | 123 | 3725F | 2021-03-25 03:18:15 | bs12
1412 | 456 | 123 | 96127 | 2021-03-25 03:18:15 | bs12
1412 | 456 | 123 | 3008F | 2021-03-25 03:18:15 | bs12
1412 | 456 | 123 | 99214 | 2021-03-25 03:18:15 | bs12
1412 | 456 | 123 | 3078F | 2021-03-25 03:18:15 | bs12
1412 | 456 | 123 | 99443 | 2021-03-25 03:18:15 | bs12
2567 | 896 | 567 | 99214 | 2021-03-27 03:18:15 | adm12
2567 | 896 | 567 | 3008F | 2021-03-27 03:18:15 | adm12
2567 | 896 | 567 | 96127 | 2021-03-27 03:18:15 | adm12
2567 | 896 | 567 | 3725F | 2021-03-27 03:18:15 | adm12
2567 | 896 | 567 | 89023 | 2021-03-27 03:18:15 | adm12
Spreadsheet: 675038d1588111691-combined-vlookup-hlookup-hlookup-vlookup-example
Sheet: ACCOUNT

 |  | Store Counts
Stores
 |  |  | West | West | West | West
UPC | ARTICLE | PK | RTE_DESSERTS_04X72_EXTRAFOODS | RTE_DESSERTS_12X72_EXTRAFOODS | RTE_DESSERTS_16X72_EXTRAFOODS | RTE_DESSERTS_20X72_EXTRAFOODS
 | AA
 | AB
 | AC
 | AD
 | AE
 | AF
 | AG
 | AJ
 | AK
 | AL
Spreadsheet: 775737d1649280891-performing-count-of-the-following-formula-test16-copy
Sheet: Sheet1

ID | Subject | Originator | Request type | Date Submitted | Combined Formula | Looks for Surname Only | Looks for Surname OR First Name | Looks for 1st 3 letters in Col B | Combined Formula - 3 Conditions G,H,I | First Word in C9 | Second Word in C9 | First 3 Letters First Word in C9
22596835 | [NAME] | Carmody Warren Mr | Renew | 2021-04-01 12:54:38
22597342 | [NAME] | Carmody Warren Mr | Renew | 2022-04-01 12:56:10.453000
22992766 | [NAME] | [NAME] | Renew | 2022-04-01 15:05:36.333000
22993741 | [NAME] | [NAME] | Create User | 2022-04-01 15:06:20.617000
22993919 | Manuel | [NAME] | Renew | 2022-04-04 12:49:29.820000
23004490 | [NAME] | [NAME] Anita | Renew | 2022-04-05 12:57:24
23005821 | [NAME] | [NAME] | Renew | 2021-04-05 12:58:34
23010495 | [NAME] Delice Petch | [NAME] D | Renew | 2022-04-05 13:01:43.146000
23010496 | [NAME] | [NAME] | Renew | 2022-04-05 13:01:43.146000
Spreadsheet: 683223d1592566445-help-summarizing-averages-on-worksheet-travel-example
Sheet: Sheet1

[NAME] | Rental Car | USA | 90.96
[NAME] | Hotel | Canada | 41.52
[NAME] | Rental Car | Canada | 41.52
[NAME] | Rental Car | Canada | 229.31
STEVE | Hotel | USA | 200.53
DAN | Rental Car | England | 64.62
DAN | Rental Car | USA | 345.26
BOB | Rental Car | Canada | 191.96
RUDY | Rental Car | Canada | 131.45
[NAME] | Rental Car | USA | 178.33
Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: APRIL 2023

JOB NUMBER | CUSTOMER | Ship To State | SELL PRICE | DUE DATE | INVOICE Request DATE | ON Time | LABOR BUDGET $ | TOTAL LABOR $ | LABOR VARIANCE | MATERIAL BUDGET | TOTAL MATERIAL | MATERIAL [NAME] | TOTAL COST BUDGET | TOTAL ACTUAL COST | [NAME] | On Budget
23-3934 | Eriks North America | AL | 7856 | 2023-03-14 00:00:00 | 2023-04-03 00:00:00 |  | 0 | 0 |  | 3884 | 3684
23-3940 | [NAME] | AL | 6728 | 2023-05-12 00:00:00 | 2003-04-03 00:00:00 |  | 3344 | 2529.08 |  | 1220 | 940.72
23-3945 | DOMINION ENERGY | SC | 4880 | 2023-04-21 00:00:00 | 2023-04-10 00:00:00 |  | 825 | 638 |  | 867.31 | 680.55
23-3968 | Dixie Industrial, LLC | FL | 13060 | 2023-04-13 00:00:00 | 2023-04-07 00:00:00 |  | 1980 | 1134.83 |  | 4356 | 2154.37
23-3970 | Technos | TX | 650 | 2023-04-11 00:00:00 | 2023-04-10 00:00:00 |  | 110 | 31.17 |  | 241 | 239.02
23-3939 | Robinson Service | FL | 4168 | 2023-03-28 00:00:00 | 2023-04-11 00:00:00 |  | 110 | 19.25 |  | 1681.75 | 2117.28
23-3959 | [NAME] | TX | 24032 | 2023-04-03 00:00:00 | 2023-04-11 00:00:00 |  | 3470.5 | 6812.68 |  | 11145.2
23-3969 | Eriks North America | SC | 1450 | 2023-04-13 00:00:00 | 2023-04-12 00:00:00 |  | 687.5 | 968 |  | 141 | 116.97
23-3958 | Get Pro Industrial | LA | 5278 | 2023-04-11 00:00:00 | 2023-04-12 00:00:00 |  | 2475 | 3124.92 |  | 1114
23-3965 | Cleaver Brooks | Canada | 2270 | 2023-04-05 00:00:00 | 2023-04-18 00:00:00 |  | 1031.25 | 754.42 |  | 510 | 267.58
23-3936 | Airco | SC | 9670 | 2023-03-16 00:00:00 | 2023-04-18 00:00:00 |  | 2205.5 | 2005.67 |  | 4363 | 3359.55
23-3946 | Bachmann | ME | 43200 | 2023-04-10 00:00:00 | 2023-04-18 00:00:00 |  | 7150 | 6810.82 |  | 18038
23-3927 | Basin Electric Power Cooperative | ND | 105490 | 2023-04-10 00:00:00 | 2023-04-18 00:00:00 |  | 12740 | 6560.58 |  | 37462.69
23-3962 | AIRCO INDUSTRIAL | GA | 32167 | 2023-04-19 00:00:00 | 2023-04-24 00:00:00 |  | 7947.5 | 9403.17 |  | 13904 | 12845.26
23-3973 | BARTLETT EQUIPMENT CO | OK | 6680 | 2023-04-19 00:00:00 | 2023-04-24 00:00:00 |  |  | 448.25 |  | 2426 | 2166.55
23-3941 | [NAME] | AL | 17593 | 2023-04-13 00:00:00 | 2023-04-24 00:00:00 |  | 7925.5 | 8847.66 |  | 4013
23-3920 | Tennessee Valley Authority | TN | 17375 | 2023-04-17 00:00:00 | 2023-04-25 00:00:00 |  |  | 5818.07
23-3924 | PTS Power | IL | 11069 | 2023-04-26 00:00:00 | 2023-04-25 00:00:00 |  | 4499 | 4166.24 |  | 2678
23-3974 | Technos | TX | 500 | 2023-05-03 00:00:00 | 2023-04-28 00:00:00 |  | 60.5 | 0 |  | 249 | 168.72
23-3955 | Murphy Exploration | LA | 56380.53 |  |  |  |  |  |  |  |  |  | 19048 | 19048
22-3823 | Mitsubishi Power |  | 149830 |  |  |  |  |  |  |  |  |  | 101836 | 101836
 | April Revenue
 |  |  |  |  | # of Shipments
 |  |  |  |  | # of Shipments on Time and % |  |  |  |  |  |  |  | As Sold Margin | As Completed Margin
Spreadsheet: 583617d1532534754-fill-in-blank-cells-based-on-other-present-information-gibsojl1-excel-question
Sheet: Statement Received

Control Number | [NAME] | Supplier ID
503056 | [NAME]'s [NAME] | 100
503056 | [NAME]'s [NAME]
503058 | [NAME] Law Office
503058 | [NAME] Law Office | 200
503058 | [NAME] Law Office
503059 | Kelly's Auto Repair
503059 | Kelly's Auto Repair | 300
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: 3099 Services

 |  |  |  | 3099 |  |  |  |  |  |  | 3099 |  |  |  |  |  |  |  | 3099 |  |  |  |  |  |  |  |  |  | 3099
 |  |  |  | CAT Service - ENGINE No. 0N5F00586 |  |  |  |  |  |  | Fire Suppression |  |  |  |  |  |  |  | Core Service @ |  | 1000 |  |  |  |  |  |  |  | HF @ | 250
 |  |  |  | Frequency @ hr |  | 500 |  |  |  |  | Frequency @ 6 months
Date | @ 500hrs | Hrs when Serviced | Hrs between service dates | Current Hour | Hrs left to run before 500H | Comment |  | Completed by | Date | [NAME] | Next Service | Comment |  | Date | Completed by | @ 1000hrs | Hrs when Serviced | Hrs ran between service dates | Current Hour | Hrs left to run before 1000H | Comment | CAT Service |  | Date | Completed by | Hrs when HF | Hrs ran between HF dates | Next due @ 250hrs | Book when reached | Comment
2020-09-18 00:00:00 |  | 10619 |  |  |  |  |  | Amerex | 2020-09-22 00:00:00 | 10620 |  | Booked in for 22/03/2021 |  | 2020-04-16 00:00:00 | PK/CF |  | 10102 |  |  |  | 230121 - 11079 |  |  | 2020-04-17 00:00:00 | PK/CF | 9940
2021-01-29 00:00:00 |  | 11085 |  | 11101 |  | Fri 290121 - Completed @ Core |  | Amerex | 2021-03-22 00:00:00 | 11079 |  |  |  | 2021-02-04 00:00:00 | MD?? |  | 11079 |  | 11101 |  | Completed at Core |  |  | 2020-05-28 00:00:00 | AE | 10307 |  |  |  | HF between hire
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-17 00:00:00 | TW | 11079 |  |  |  | TW did themselves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-29 00:00:00 | AE | 11085 |  |  |  | AE whilst not on hire at Core
Spreadsheet: 58511d1258741269-if-function-to-find-no-close-to-nox_engine_sim-1-
Sheet: Sheet3

 | 1000rpm | 4000rpm
MFB | CA | CA
0 | 1 | -7
0.02 | 9.48 | -3.071
0.05 | 11 | -0.663
0.1 | 12.717 | 1.686
0.5 | 20.048 | 10.928
0.9 | 24.84 | 21.935
1 | 26 | 29
 | -8
 | -7 |  |  | 0
 | -6 |  |  | 0.00268233
 | -5 |  |  | 0.00676272
 | -4 |  |  | 0.0126241
 | -3 |  |  | 0.0206493
 | -2 |  |  | 0.0312212
 | -1 |  |  | 0.0447228
 | 0 | 0 |  | 0.0615717
 | 1 | 0.0007010000000000002 | -3.84856780580667e-05 | 0.0825959
 | 2 | -0.015092 | -0.000965576952197738 | 0.108881
 | 3 | -0.02627300000000001 | -0.00224005953889291 | 0.140824
 | 4 | -0.032836 | -0.00363535399143587 | 0.177693
 | 5 | -0.03477500000000001 | -0.004662078588844 | 0.21865
 | 6 | -0.03208400000000002 | -0.00453989668545932 | 0.26286
 | 7 | -0.02475700000000002 | -0.00224246932750808 | 0.309484
 | 8 | -0.012788 | 0.00337865423487694 | 0.357688
 | 9 | 0.003828999999999992 | 0.013417887740828 | 0.406633
 | 10 | 0.02509999999999998 | 0.0287412316627128 | 0.455483
 | 11 | 0.05103100000000001 | 0.049873931598716 | 0.503401
 | 12 | 0.08162799999999998 | 0.0769890837837053 | 0.549707
 | 13 | 0.116897 | 0.109995716265815 | 0.594221
 | 14 | 0.156844 | 0.148685086696419 | 0.636868
 | 15 | 0.201475 | 0.192874077656297 | 0.677569
 | 16 | 0.250796 | 0.242492484807171 | 0.716248
 | 17 | 0.3048129999999999 | 0.297589562527363 | 0.752828
 | 18 | 0.3635319999999999 | 0.358268197280059 | 0.787232
 | 19 | 0.426959 | 0.424577459570572 | 0.819383
 | 20 | 0.4950999999999999 | 0.496399656554145 | 0.849203
 | 21 | 0.5679609999999999 | 0.573359529981832 | 0.876615
 | 22 | 0.6455479999999999 | 0.654769104099633 | 0.901543
 | 23 | 0.7278669999999999 | 0.739609420642548 | 0.92391
 | 24 | 0.814924 | 0.826543615794337 | 0.943638
 | 25 | 0.906725 | 0.913954184131303 | 0.96065
 | 26 | 1.003276 | 0.999998518234071 | 0.974869
 | 27 |  |  | 0.986219
 | 28 |  |  | 0.994621
 | 29 |  |  | 1
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
Spreadsheet: 588177d1535532025-formula-for-vlookup-for-next-n-days-customised-data-query
Sheet: Sheet3

Input date |  | Desired results
2018-01-02 00:00:00 |  | Date | Info2
 |  |  |  |  |  | 1
 |  | Provided data in sheet2 is in chronological order
Spreadsheet: 168267d1342359608-countifs-array-results-not-as-expected-can-anyone-see-why-countifs-calamity-test
Sheet: Sheet1

A | 1 |  | A | 1 |  | A | 1 |  | A | 1
A | 1 |  | A | 2 |  | A | 1 |  | A | 2
B | 1 |  | B | 1 |  | B | 2 |  | B | 3
B | 3 |  | B | 3 |  | B | 3 |  | B | 3
result
expected | 1 |  |  | 2 |  |  | 1 |  |  | 2
Spreadsheet: 767299d1644400754-filtering-data-semi-monthly-home-budget1
Sheet: Data Lists

Enter Category data in this worksheet to populate the drop-down lists in the [NAME] table on Expenditures & Income worksheet. Modify category names or descriptions below each category to update the lists. Helpful instructions on how to use this worksheet are in cells in this column. Title of the workbook is in cell at right and worksheet title in cell M1. |  |  |  |  |  |  |  |  |  |  |  | DATA LISTS
Tip is in cell at right. | SETUP         The Category data below populates the drop down lists in the [NAME] table on the Expenditures & Income sheet. Modify the category names or the descriptions below each category to update the lists.
Enter or modify category names or descriptions below each category in the table starting in cell at right. | Household | Entertainment | Food | Gifts/Donations | Children | Investment Accounts | Medical | Other | Personal | Pets | Taxes/Legal | Transportation
 | Mortgage | Movies | Groceries | Charity 1 | Clothes | IRA | Doctor/Clinic | Other | Clothing | Food | Federal | Car 1 Payment
 | Electricity | Video/Movies | Dining out | Charity 2 | Toys/Games | Savings | Insurance | Organization Dues | Hair/Nails | Supplies | State | Car 2 Payment
 | Water/Sewer | Music |  | Charity 3 | Lunch money | Checking |  |  | Dry cleaning | Medical | Local | Car Insurance
 | Garbage | Concerts/Theater |  | [NAME] | Dues/Fees | Retirement |  |  | Health/Fitness club | Grooming | Other | Licensing/Registration
 | Cell phone | Sporting events |  |  | School supplies | Investment account |  |  | Shopping | Other | Attorney | Fuel
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: AMc

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 119344d1314336419-how-do-i-sort-this-data-accurately-without-having-to-change-any-values-sortingproblem-1-
Sheet: Sheet1

 | 2007-BIT-20 | 2007 | 20
 | 2007-BIT-44 | 2007 | 44
 | 2007-BIT-63 | 2007 | 63
 | 2008-BIT-1 | 2008 | 1
 | 2008-BIT-2 | 2008 | 2
 | 2008-BIT-11 | 2008 | 11
 | 2008-BIT-18 | 2008 | 18
 | 2008-BIT-25 | 2008 | 25
 | 2008-BIT-27 | 2008 | 27
 | 2008-BIT-42 | 2008 | 42
 | 2008-BIT-46 | 2008 | 46
 | 2008-BIT-55 | 2008 | 55
 | 2008-BIT-58 | 2008 | 58
 | 2008-BIT-61 | 2008 | 61
 | 2008-BIT-63 | 2008 | 63
 | 2008-BIT-64 | 2008 | 64
 | 2008-BIT-71 | 2008 | 71
 | 2008-BIT-76 | 2008 | 76
 | 2008-BIT-77 | 2008 | 77
 | 2008-BIT-92 | 2008 | 92
 | 2008-BIT-98 | 2008 | 98
 | 2008-BIT-98 | 2008 | 98
 | 2008-BIT-103 | 2008 | 103
 | 2008-BIT-110 | 2008 | 110
 | 2008-BIT-115 | 2008 | 115
 | 2008-BIT-117 | 2008 | 117
 | 2008-BIT-121 | 2008 | 121
 | 2008-BIT-125 | 2008 | 125
 | 2008-BIT-129 | 2008 | 129
 | 2008-BIT-134 | 2008 | 134
 | 2008-BIT-137 | 2008 | 137
 | 2008-BIT-141 | 2008 | 141
 | 2008-BIT-149 | 2008 | 149
 | 2008-BIT-155 | 2008 | 155
 | 2008-BIT-162 | 2008 | 162
Spreadsheet: 689625d1596559149-create-a-sequence-based-on-a-date-in-another-column-sequence_sample
Sheet: Sheet1

12 Days | Sequence |  |  |  |  |  | Unq Dates | Rank
2020-08-08 00:00:00
2020-08-06 00:00:00 |  |  |  |  |  |  | 2020-08-06 00:00:00
2020-08-06 00:00:00 |  |  |  |  |  |  | 2020-08-09 00:00:00
2020-08-09 00:00:00 |  |  |  |  |  |  | 2020-08-12 00:00:00
2020-08-12 00:00:00 |  |  |  |  |  |  | 2020-08-21 00:00:00
2020-08-12 00:00:00
2020-08-12 00:00:00
2020-08-21 00:00:00
2020-08-21 00:00:00
Spreadsheet: 721791d1614864626-count-violations-in-attendance-sheet-count-timing-violations
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result here
Emplyee Name | 2021-02-01 00:00:00 |  | 2021-02-02 00:00:00 |  | 2021-02-03 00:00:00 |  | 2021-02-04 00:00:00 |  | 2021-02-05 00:00:00 |  | 2021-02-06 00:00:00 |  | 2021-02-07 00:00:00 |  | 2021-02-08 00:00:00 |  | 2021-02-09 00:00:00 |  | 2021-02-10 00:00:00 |  | 2021-02-11 00:00:00 |  | 2021-02-12 00:00:00 |  | 2021-02-13 00:00:00 |  | 2021-02-14 00:00:00 |  | 2021-02-15 00:00:00 |  | 2021-02-16 00:00:00 |  | 2021-02-17 00:00:00 |  | 2021-02-18 00:00:00 |  | 2021-02-19 00:00:00 |  | 2021-02-20 00:00:00 |  | 2021-02-21 00:00:00 |  | 2021-02-22 00:00:00 |  | 2021-02-23 00:00:00 |  | 2021-02-24 00:00:00 |  | 2021-02-25 00:00:00 |  | 2021-02-26 00:00:00 |  | 2021-02-27 00:00:00 |  | 2021-02-28 00:00:00 |  | Violations
A | 07:54:20 | 16:20:31 | W | W | W | W | 07:49:41 | 16:31:05 | A | 16:22:26 | 07:53:34 | 16:18:28 | 08:01:11 | 16:18:26 | 07:53:25 | 16:27:56 | W | W | W | W | A | A | 07:54:02 | 16:24:50 | 07:46:35 | 18:36:06 | 07:47:11 | 16:23:52 | 07:45:58 | 16:27:21 | W | W | W | W | 07:46:36 | 16:20:55 | 07:50:50 | 16:24:33 | 07:51:03 | 16:23:00 | 07:49:22 | 16:25:46 | 07:51:20 | 16:11:55 | W | W | W | W | A | A | 07:54:41 | 16:20:32 | 07:43:49 | 16:24:38 | 07:47:46 | 16:04:57 | 1
B | W | W | 07:35:19 | 16:24:51 | 07:37:13 | 16:21:26 | A | A | 07:41:17 | A | 07:35:58 | 16:18:29 | W | W | W | W | 07:43:10 | 16:26:11 | 07:31:43 | 16:21:38 | 07:39:08 | 16:20:02 | 07:39:49 | 16:24:51 | 07:34:44 | 16:14:38 | W | W | W | W | 07:37:53 | 16:15:39 | 07:35:51 | 16:20:00 | 07:40:45 | 16:20:16 | 07:43:13 | 16:24:33 | 07:38:37 | 16:23:03 | W | W | W | W | 07:41:30 | 16:27:14 | 07:33:11 | 16:25:45 | 07:34:03 | 16:08:26 | 07:38:19 | 16:20:29 | 07:37:19 | 16:24:44 | W | W | 1
C | W | W | 04:33:25 | 12:16:40 | 07:41:24 | 16:12:49 | 07:40:13 | 16:10:48 | W | W | 07:40:51 | 16:04:28 | A | 16:16:53 | A | W | AV | AV | S | S | S | S | W | W | 07:40:39 | 16:10:28 | 07:40:00 | 16:17:31 | W | W | 07:39:33 | 16:12:12 | 07:39:33 | 16:09:42 | 07:40:41 | 16:08:47 | W | W | 07:40:41 | 16:06:16 | 07:40:04 | 16:03:00 | W | W | 07:42:23 | 16:14:26 | 07:40:26 | 16:14:24 | AV | AV | W+ | 08:29:00 | A | A | 07:40:24 | 16:21:09 | 2
D | A | 08:25:49 | W | W | W | W | 15:59:13 | 23:57:04 | 15:50:19 | 23:57:44 | 15:54:39 | 23:56:03 | 15:55:05 | 23:54:44 | 15:57:28 | 23:52:57 | W | W | 07:40:40 | 16:21:21 | 07:41:16 | 16:22:25 | 07:40:03 | 16:22:03 | 07:40:45 | 16:19:39 | 07:40:39 | 16:19:10 | W | W | 23:25:42 | 08:24:04 | 23:20:30 | 08:22:54 | 23:20:39 | 08:26:49 | 23:20:47 | 08:26:04 | 23:22:36 | 08:24:32 | W | W | W | W | 15:51:51 | 23:58:08 | 15:52:39 | 23:59:09 | AV | AV | 15:52:42 | 23:55:40 | 15:57:06 | 23:55:15 | W | W | 1
Spreadsheet: 678359d1589839007-if-formula-looking-at-another-tab-to-determine-results-eh_-project-planne
Sheet: Project planner snapshot

ID | Tasks | Owner | Start Date | Duration | Priority |  | Status |  |  | ID |  |  |  |  | Task owners (Adhoc tasks excluded)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task meter (Adhoc tasks excluded)
 | Adhoc Tasks | Owner |  |  |  |  | Status |  |  | Adhoc queries
 |  |  |  |  |  |  |  |  |  | Upcoming absences |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | Not started
 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | Total Tasks
 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority tracker
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tasks
Spreadsheet: daren_farmer__5711__Vegas
Sheet: Sheet2

Texas Desk
Las Vegas Trip
 | [NAME] has generously decided to thank his direct reports by taking the desk to Las Vegas!  In order to book things quickly and smoothly I
 | need your response today.  We plan on flying out on February 16, and returning on February 19.  I tentatively have us booked
 | at the Mirage.  We plan on putting two in each room; if you want your own room it can be arranged for $210 out of your pocket.
 | I need to know today if you will be attending and if you would like to pay for your own room.  Please keep this trip confidential for now.
 | The invite list is below:
 |  |  | Las Vegas
 |  |  | February 16-19
 |  |  |  | Daily Trading
 |  |  | 1 | [NAME]
 |  |  | 2 | [NAME]
 |  |  | 3 | [NAME]
 |  |  | 4 | [NAME]
 |  |  | 5 | [NAME]
 |  |  | 6 | [NAME]
 |  |  | 7 | [NAME]
 |  |  | 8 | [NAME]
 |  |  | 9 | [NAME]
 |  |  | 10 | [NAME]
 |  |  | 11 | [NAME]
 |  |  | 12 | [NAME]
 |  |  | 13 | [NAME]
 |  |  | 14 | [NAME]
 |  |  | 15 | [NAME]
 |  |  | 16 | [NAME]
 |  |  | 17 | [NAME]
 |  |  | 18 | [NAME]
Spreadsheet: 31199d1227005512-solved-problem-updating-lists-ranges-update
Sheet: Cost

 |  | Apple Mac | Desktop | Laptop | Remote | Roaming | Blackberry
 |  | 500 | 400 | 300 | 200 | 100 | 432
ID | Name | Apple Mac | Desktop | Laptop | Remote | Roaming | Blackberry | Printing Cost | Service Cost | Cost
11111111 | [NAME] | 0 | 400 | 0 | 0 | 0 | 0 | 5000 | 400 | 5400
22222222 | [NAME] | 0 | 0 | 0 | 0 | 200 | 0 | 300 | 200 | 500
11111111 | [NAME] | 0 | 0 | 900 | 0 | 0 | 0 | 543 | 900 | 1443
22222222 | [NAME] | 0 | 0 | 0 | 0 | 0 | 864 | 23252 | 864 | 24116
11111111 | [NAME] | 0 | 0 | 0 | 0 | 200 | 0 | 21023.5 | 200 | 21223.5
22222222 | Iain McNab | 0 | 400 | 0 | 200 | 0 | 0 | 26523.4 | 600 | 27123.4
11111111 | [NAME] | 0 | 0 | 300 | 200 | 100 | 0 | 32023.3 | 600 | 32623.3
22222222 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 37523.2 | 0 | 37523.2
11111111 | [NAME] | 0 | 0 | 0 | 0 | 300 | 0 | 43023.1 | 300 | 43323.1
22222222 | [NAME] | 0 | 0 | 900 | 0 | 0 | 0 | 48523 | 900 | 49423
11111111 | [NAME] | 0 | 0 | 300 | 200 | 100 | 432 | 54022.9 | 1032 | 55054.9
22222222 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 59522.8 | 0 | 59522.8
11111111 | [NAME] | 0 | 400 | 0 | 0 | 0 | 0 | 65022.7 | 400 | 65422.7
22222222 | [NAME] | 0 | 0 | 0 | 0 | 100 | 0 | 70522.6 | 100 | 70622.6
11111111 | [NAME] | 0 | 0 | 300 | 0 | 0 | 0 | 76022.5 | 300 | 76322.5
22222222 | [NAME] | 0 | 1200 | 0 | 0 | 0 | 0 | 81522.4 | 1200 | 82722.4
11111111 | [NAME] | 0 | 1600 | 0 | 0 | 400 | 0 | 87022.3 | 2000 | 89022.3
22222222 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 92522.2 | 0 | 92522.2
11111111 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 98022.1 | 0 | 98022.1
22222222 | [NAME] | 0 | 0 | 300 | 200 | 0 | 0 | 103522 | 500 | 104022
11111111 | Amanda Edwards | 0 | 800 | 0 | 0 | 0 | 0 | 109021.9 | 800 | 109821.9
22222222 | [NAME] | 0 | 0 | 0 | 0 | 100 | 432 | 114521.8 | 532 | 115053.8
11111111 | [NAME] | 0 | 0 | 300 | 0 | 0 | 0 | 120021.7 | 300 | 120321.7
22222222 | Callum Lafferty | 0 | 0 | 300 | 0 | 0 | 0 | 125521.6 | 300 | 125821.6
22222222 | [NAME] | 0 | 0 | 300 | 0 | 0 | 0 | 131021.5 | 300 | 131321.5
Spreadsheet: 751604d1634206622-looking-for-min-in-a-range-book2
Sheet: Sheet1

1.33 |  | 1 |  |  |  |  | 1.33
75 |  | 1 |  |  |  |  | 1.33
80 |  | 1 |  |  |  |  | 1.33
10.5 |  | 1 |  |  |  |  | 1.33
26 |  | 2 |  |  |  |  | 8.6 |  |  | I needed it to be shown like it is does in column H
300 |  | 2 |  |  |  |  | 8.6
25 |  | 2 |  |  |  |  | 8.6
27 |  | 2 |  |  |  |  | 8.6
990 |  | 2 |  |  |  |  | 8.6
9.2 |  | 2 |  |  |  |  | 8.6
9 |  | 2 |  |  |  |  | 8.6
8.6 |  | 2 |  |  |  |  | 8.6
13.5 |  | 2 |  |  |  |  | 8.6
4.7 |  | 3 |  |  |  |  | 4.7
11 |  | 3 |  |  |  |  | 4.7
14.5 |  | 3 |  |  |  |  | 4.7
22 |  | 4 |  |  |  |  | 3.3
5.8 |  | 4 |  |  |  |  | 3.3
22 |  | 4 |  |  |  |  | 3.3
28 |  | 4 |  |  |  |  | 3.3
4.1 |  | 4 |  |  |  |  | 3.3
4.6 |  | 4 |  |  |  |  | 3.3
3.3 |  | 4 |  |  |  |  | 3.3
8.2 |  | 4 |  |  |  |  | 3.3
23 |  | 4 |  |  |  |  | 3.3
3.7 |  | 4 |  |  |  |  | 3.3
3.9 |  | 4 |  |  |  |  | 3.3
4.9 |  | 4 |  |  |  |  | 3.3
9.2 |  | 4 |  |  |  |  | 3.3
16.5 |  | 5 |  |  |  |  | 6.6
18 |  | 5 |  |  |  |  | 6.6
75 |  | 5 |  |  |  |  | 6.6
27 |  | 5 |  |  |  |  | 6.6
6.6 |  | 5 |  |  |  |  | 6.6