tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 835481d1688623090-unable-to-display-only-filtered-data-in-dropdown-book1
Sheet: data

Date | price | TYPE
2001-02-20 00:00:00 | 12.7197371294304 | BOOKS
2001-02-21 00:00:00 | 17.65128295690005 | PENS
2001-02-22 00:00:00 | 21.74976554111727 | PENCILS
2001-02-23 00:00:00 | 24.8355119353847 | BOOKS
2001-02-26 00:00:00 | 26.75562556893002 | PENS
2001-02-27 00:00:00 | 27.41106221222262 | PENCILS
2001-02-28 00:00:00 | 26.78138581358647 | BOOKS
2001-03-01 00:00:00 | 24.9319414859501 | PENS
2001-03-02 00:00:00 | 21.99783289816391 | PENCILS
2001-03-05 00:00:00 | 18.1537060960849 | BOOKS
2001-03-07 00:00:00 | 13.58460565817101 | PENS
2001-03-08 00:00:00 | 8.46831664071707 | PENCILS
2001-03-09 00:00:00 | 2.971729444525442 | BOOKS
2001-03-12 00:00:00 | -2.740641599356869 | PENS
2001-03-13 00:00:00 | -8.488587023080509 | PENCILS
2001-03-14 00:00:00 | -14.05089908756841 | BOOKS
2001-03-15 00:00:00 | -19.1369777418023 | PENS
2001-03-16 00:00:00 | -23.36707795783305 | PENCILS
2001-03-19 00:00:00 | -26.28763416240778 | BOOKS
2001-03-20 00:00:00 | -27.45644092327569 | PENS
2001-03-21 00:00:00 | -26.59713021749511 | PENCILS
2001-03-22 00:00:00 | -23.73586734360164 | BOOKS
2001-03-23 00:00:00 | -19.20468302209753 | PENS
2001-03-26 00:00:00 | -13.51089851656583 | PENCILS
2001-03-27 00:00:00 | -7.183120660785874 | BOOKS
2001-03-28 00:00:00 | -0.6777758728468887 | PENS
2001-03-29 00:00:00 | 5.646848973665005 | PENCILS
2001-03-30 00:00:00 | 11.51684081811553 | BOOKS
2001-03-31 00:00:00 | 16.71556872194258 | PENS
2001-04-01 00:00:00 | 21.05974496003522 | PENCILS
2001-04-02 00:00:00 | 24.38741210906182 | PENS
Spreadsheet: benjamin_rogers__926__PJMupdate1
Sheet: eMarket Calc

Western Hub
16.36 | 15.71 | 15.43 | 15.35 | 15.96 | 18.99 | 29 | 32.93 | 33.52 | 32.01 | 32.01 | 26.9
25.84 | 25.83 | 24.91 | 22.69 | 26.03 | 45.63 | 40 | 33.15 | 27.55 | 22.3 | 20.49 | 17.16
NYPP_W
13.91 | 13.76 | 13.66 | 13 | 13.84 | 17.63 | 24.15 | 25.05 | 22.95 | 23.47 | 23.59 | 23.41
23.32 | 23.27 | 22.97 | 23.01 | 24.97 | 45.15 | 39.95 | 35.75 | 29.9 | 25.02 | 22.88 | 18.37
Hour Ending | NYPPE | Zone P | Delta | MW | P/L | West Hub
1 |  | 22.85 |  | 200 |  |  |  |  |  |  |  |  |  |  | 38000
2 |  | 19.8 |  | 200 |  |  |  |  |  |  |  |  |  |  | 36000
3 |  | 18 |  | 200 |  |  |  |  |  |  |  |  |  |  | 34000
4 |  | 18 |  | 200
5 |  | 17.77 |  | 200
6 |  | 22.88 |  | 200
7 |  | 25.79 |  | 200
8 |  | 26.69 |  | 200
9 |  | 24.79
10 |  | 24.81 |  | 153
11 |  | 25.05 |  | 200
12 |  | 24.78 |  | 200
13 |  | 24.94 |  | 200
14 |  | 24.69 |  | 197
15 |  | 24.45 |  | 78
16 |  | 24.4 |  | 66
17 |  | 26.89 |  | 200
18 |  | 34.93
19 |  | 31.93
20 |  | 30
21 |  | 26.45 |  | 200
22 |  | 25.94 |  | 200
23 |  | 22.2 |  | 200
24 |  | 23 |  | 200
On |  |  |  | Sum
Off
Spreadsheet: 768642d1645058207-stacking-multiple-ranges-to-one-combined-range-pq-append-week
Sheet: Thursday

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
Run | Run | Start_Time | End_Time | Day of Week | Route | Block | EE ID
FT_1 | 300 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 300 | 300 | 1050295
FT_3 | 301 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 301 | 301 | 1050311
FT_4 | 302 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 302 | 302 | 1050800
FT_5 | 839 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 839 | 839 | 1050308
FT_6 | 840 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 840 | 840 | 1050292
FT_7 | 850 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 850 | 850 | 1050288
FT_8 | 851 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 851 | 851 | 1050290
FT_9 | 852 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 852 | 852 | 1050285
FT_10 | 853 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 853 | 853 | 1050331
FT_11 | 854 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 854 | 854 | 1050387
FT_12 | 855 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 855 | 855 | 1050334
FT_13 | 856 | 0.2604166666666667 | 0.5833333333333334 | Thursday | 856 | 856 | 1050414
FT_14 | 303 | 0.2708333333333333 | 0.6041666666666666 | Thursday | 303 | 303 | 1050383
[NAME] | 304 | 0.2708333333333333 | 0.6041666666666666 | Thursday | 304 | 304 | 1050284
Spreadsheet: 490478d1479879967-if-a-b-c-d-2-3-4-5-in-any-order-then-e-50-gear-bonus-1-it
Sheet: Sheet1

cat | dog | [NAME] | rat | 50 | 20
pig | cat | dog | [NAME] | 75 | 15
[NAME] | rat | dog | cat | 50 | 20
dog | [NAME] | pig | cat | 75 | 15
dog | [NAME] | rat | cow | 0 | 0
 |  |  |  | 250 | 70
if a,b,c,d are cat, dog, mouse, rat, in any order then e=50 red and 20 blue
if a,b,c,d are pig, cat, dog, mouse in any order then e=75 red and 15 blue
I'm looking for total E6=250 red and f6=70 blue
Spreadsheet: 294641d1391456892-would-like-to-reveal-rows-depending-on-input-example-3-
Sheet: Request Form

Item | Quantity |  |  |  |  |  | Item | Quantity | Request
Spreadsheet: 140240d1328655429-excel-2007-hex-to-binary-hex-two-bin-asydl-1
Sheet: Sheet1

ff
 |  |  |  | ASYDL | 1026 |  |  | ASYDL | 1027
 |  |  |  | HEX: | ff |  |  | HEX: | 83
 |  |  |  | BINARY: |  |  |  | BINARY:
 |  |  |  |  | IMG0 |  | IMG1 |  | [NAME] |  | IMG3
 |  |  |  | 1026 b3 |  | 1026 b7 |  | 1027 b3 |  | 1027 b7
 |  |  |  | MG1-2 | MG1-3 | MG3-2 | MG3-3 | MG5-2 | MG5-3 | MG7-2 | MG7-3
 |  |  |  | 1026b2 |  | 1026 b6 |  | 1027 b2 |  | 1027 b6
 |  |  |  | MG1-0 | MG1-1 | MG3-0 | MG3-1 | MG5-0 | MG5-1 | MG7-0 | MG7-1
 |  |  |  | 1026 b1 |  | 1026 b5 |  | 1027 b1 |  | 1027 b5
 |  |  |  | MG0-2 | MG0-3 | MG2-2 | MG2-3 | [NAME] | [NAME] | MG6-2 | MG6-3
 |  |  |  | 1026 b0 |  | 1026 b4 |  | 1027 b0 |  | 1027 b4
 |  |  |  | MG0-0 | MG0-1 | MG2-0 | MG2-1 | [NAME] | MG4-1 | MG6-0 | MG6-1
Spreadsheet: 548454d1511154574-include-dates-excluding-weekdays-friday-and-saturday-excelforum-eg-alipezu
Sheet: Sheet1

Dates |  | Exclude Fri & Sat
2017-05-10 00:00:00
2017-03-16 00:00:00
2017-04-04 00:00:00
2017-05-01 00:00:00
2017-03-23 00:00:00
2017-02-24 00:00:00
2017-02-19 00:00:00
2017-02-25 00:00:00
2017-05-20 00:00:00
2017-03-02 00:00:00
2017-03-20 00:00:00
2017-02-26 00:00:00
2017-04-16 00:00:00
2017-04-10 00:00:00
2017-03-01 00:00:00
2017-04-22 00:00:00
2017-03-26 00:00:00
2017-05-10 00:00:00
2017-04-30 00:00:00
2017-05-20 00:00:00
2017-04-04 00:00:00
Spreadsheet: 768365d1644937603-generate-a-list-of-tasks-from-dropdown-options-and-yes-no-answers-attachment_vulp
Sheet: Sheet1

Continent | Country | Car Color | Car Price | Contact | [NAME]
The US | Ohio | Green | 10000 | Cleveland | 1123456
 | Nebraska | Blue Green | 9000 | Nebraska city | 11234765
 | Massachusetts | Red Green | 11000 | Boston | 5432665
 | Maryland | Blue Red | 10500 | [NAME] | 23425422
 | Virginia | Grey | 11500 | Virginia Beach | 34234342
 | New York | Blue Grey Red | 9700 | NYC | 765444
 | California | Red Blue Green Grey Black | 9500 | San Francisco | 543344
 | New Mexico | Black | 10300 | Santa Fe | 86046
Europe | England | Blue Red Green Black | 8000 | London | 986794
 | Germany | Red | 8700 | Berlin | 4545454
 | France | Green Blue | 8500 | Paris | 878787
 | Italy | Red Blue Grey | 8200 | Rome | 9898989
 | Spain | Grey | 9000 | Madrid | 121212121
 | Greece | Blue Grey Red | 8700 | Athens | 34434343
 | Portugal | Red Blue Green Grey Black | 7900 | Lisbon | 45656546
1st Question: "do you need a car?" possible answers "yes/no"
if yes is selected by the user there is a follow up question:
"what color?" "black/green/blue/red/grey"
the user can choose one of the colors. Once the color is selected (grey), there is a sentence imported in the final section:
"your favorite car is available"
2nd question: "where do you live"? possible answer "Europe/US"
if Europe is selected a follow up answer appears: "England/Spain/Germany/Italy/etc.."
Once the country is also selected (England) another sentence is added to the final section:
"call London car company- number 986794"
More questions will be asked and finally the user will end up with several sentences in the final section
"-price for a car of grey color is 10000
-call London car company- number xxxxx
- etc,..."
Spreadsheet: 808483d1670492340-combine-2-sheets-grade-6
Sheet: UFAULU KIMASOMO

B. MPANGILIO WA UFAULU WA WANAFUNZI KIMASOMO
SHULE |  |  | KALOLENI |  |  |  |  |  | DARASA |  |  |  |  | VI
NA | SOMO | USAJILI |  |  |  | IDADI [NAME] KWA MADARAJA YA UFAULU |  |  |  |  |  |  | WASIOFAULU |  |  |  | % WASIOFAULU
 |  | WALIOFANYA |  | WALIOFAULU |  | A |  | B |  | C |  | %[NAME] | D |  | E
 |  | WV | WS | WV | WS | WV | WS | WV | WS | WV | WS |  | WV | WS | WV | WS
1 | HISABATI
2 | KISWAHILI
3 | KIINGEREZA
4 | SAYANSI & TEKNOLOJIA
5 | [NAME]
8 | URAIA NA MAADILI
7 | S/KAZI
Spreadsheet: 754957d1636592213-need-help-with-nested-if-and-max-statement-gems
Sheet: Gem Pricing

 | [NAME] 2021-11-10
 | Gem | Mote Type | Brillaint Uncut Quantity | Price | Total [NAME] | Cut Price | Essence Price | Profit if Cut Per Gem | Total Brilliant Cut | Pristine Quantity Dropped | Pristine Quantity Fused | Price | Total [NAME] | Cut Price | Quintessence  Price | Profit if Cut Per Gem | Total If Pristine Cut | Upgrade or [NAME]
 | Jasper | air | 15 | 3.6 |  | 24.99 | 20 |  |  | 0 |  | 15 |  | 69.5 | 47 |  |  | =IF(MAX(F6,J6,N6,R6)=F6,"BRILLIANT UNCUT",IF(MAX(F6,J6,N6,R6)=J6),"BRILLIANT CUT", IF(MAX(F6,J6,N6,R6)=N6), "PRISTINE UNCUT", "PRISTINE CUT")
 | Topaz | air | 8 | 1.95 |  | 24 | 20 |  |  | 0 |  | 9 |  | 78 | 47
 | Moonstone | death | 2 | 3.47 |  | 20 | 10 |  |  | 3 |  | 11.99 |  | 160 | 45
 | Sapphire | death | 5 | 3.4 |  | 22 | 10 |  |  | 3 |  | 14.28 |  | 167 | 45
 | Amber | earth | 0 | 17.99 |  | 30 | 16 |  |  | 1 |  | 38 |  | 74 | 9
 | Emerald | earth | 2 | 9.38 |  | 31 | 16 |  |  | 0 |  | 65.86 |  | 72.5 | 9
 | Carnelian | fire | 5 | 4.48 |  | 29.55 | 15 |  |  | 3 |  | 17.5 |  | 110 | 47
 | Ruby | fire | 2 | 4.99 |  | 21.93 | 15 |  |  | 0 |  | 14 |  | 88 | 47
 | Diamond | life | 5 | 30 |  | 50 | 4 |  |  | 1 |  | 238 |  | 255 | 0
 | Onyx | life | 14 | 58 |  | 45 | 4 |  |  | 0 |  | 278 |  | 299 | 0
 | Amethyst | soul | 0 | 3.4 |  | 25 | 18 |  |  | 0 |  | 6 |  | 94 | 40
 | Malachite | soul | 4 | 5 |  | 26 | 18 |  |  | 0 |  | 50 |  | 149 | 40
 | Opal | soul | 0 | 12 |  | 36 | 18 |  |  | 0 |  | 60 |  | 296 | 40
 | Aquamarine | water | 5 | 4.99 |  | 20.98 | 16 |  |  | 0 |  | 20 |  | 72 | 20
 | [NAME] |  | 0
 | ** Use whatever number you like for "Price", "Cut Price", "Esseence Price", "Quintessence Price".  I used the lowest number on all trading posts.
 | ** Always upgrade flawed and normal gems
Spreadsheet: 89112d1288878073-averages-across-multiple-sheets-with-non-numerical-names-averages
Sheet: Team Overview

 | Monday | Tuesday | Wednesday | Thursday | Friday |  | Weekly Average | Weekly Total
PNC | 10 | 20 | 0 | 40 | 50 |  | 30 | 120
Daily Average | #N/A
CONFLICTS | 10 | 20 | 30 | 40 | 50 |  | 30 | 150
Daily Average
ID'S | 0 | 0 | 1000 | 0 | 0 |  | 1000 | 1000
Daily Average
ISA | 0 | 0 | 0 | 0 | 0 |  | #N/A | 0
Daily Average
 | PNC | CONFLICTS | ID'S | ISA
Monday | 1 | 1
Tuesday | 2 | #N/A
Wednesday | 0
Thursday | 4
Friday | 5
Spreadsheet: 755271d1636745193-can-you-use-vlookup-to-return-value-if-conditions-are-met-timeline-2021_test-copy-tms-v3
Sheet: Sample Sheet

 |  |  | 1
COMMUNICATION |  | 1 |  |  | 1
Spreadsheet: 749053d1632486599-display-list-of-new-or-updated-rows-in-a-list-update
Sheet: Paste

Title | PartID | Location | Price | Image [image] | Image2 [image2] | Image3 [image3] | Description | Quantity | Category
SamplePart1 | 1 | [NAME] | 0.04 |  |  |  | SampleDes1 | 500 | 0
SamplePart2 | 2 | LOC2 | 0.01 |  |  |  | SampleDes2 | 1280 | 0
SamplePart3 | 3 | [NAME] | 0.08 |  |  |  | SampleDes3 | 1260 | 0
SamplePart4 | 4 | LOC4 | 0.11 |  |  |  | SampleDes4 | 1021 | 0
SamplePart5 | 5 | LOC5 | 0.08 |  |  |  | SampleDes5 | 1000 | 0
SamplePart6 | 6 | LOC6 | 0.28 |  |  |  | SampleDes6 | 900 | 0
SamplePart7 | 7 | [NAME] | 0.14 |  |  |  | SampleDes7 | 733 | 0
SamplePart8 | 8 | LOC8 | 0.43 |  |  |  | SampleDes8 | 688 | 0
SamplePart9 | 9 | [NAME] | 3.83 |  |  |  | SampleDes9 | 540 | 0
SamplePart10 | 10 | LOC10 | 0.09 |  |  |  | SampleDes10 | 500 | 0
SamplePart11 | 11 | LOC11 | 0.08 |  |  |  | SampleDes11 | 500 | 0
[NAME] | 12 | LOC12 | 0.14 |  |  |  | SampleDes12 | 497 | 0
SamplePart13 | 13 | [NAME] | 3.34 |  |  |  | SampleDes13 | 410 | 0
SamplePart14 | 14 | LOC14 | 0.09 |  |  |  | SampleDes14 | 400 | 0
SamplePart15 | 15 | LOC15 | 0.06 |  |  |  | SampleDes15 | 396 | 0
SamplePart16 | 16 | LOC16 | 5.63 |  |  |  | SampleDes16 | 370 | 0
SamplePart17 | 17 | LOC17 | 1.59 |  |  |  | SampleDes17 | 350 | 0
SamplePart18 | 18 | LOC18 | 2.91 |  |  |  | SampleDes18 | 325 | 0
SamplePart19 | 19 | LOC19 | 0.44 |  |  |  | SampleDes19 | 314 | 0
SamplePart20 | 20 | LOC20 | 1.25 |  |  |  | SampleDes20 | 999
SamplePart21 | 21 | LOC21 | 5.21 |  |  |  | SampleDes21 | 888
Spreadsheet: 794481d1662065274-help-calculating-total-hrs-worked-when-meal-out-in-fields-are-left-blank-timesheet-help-august-timesheet4
Sheet: Edward

Month/Year: | August, 2022
Name: | [NAME]
 | Date | Account | Time In | Meal Out | Meal In | Time Out | Total Hrs | Overtime | Notes
 | 2022-08-02 00:00:00 | Theragent | 09:00:00 |  |  | 13:30:00 | 4.5 |  | Clean outside labs
 | 2022-08-03 00:00:00 | Theragent | 16:00:00 | 20:00:00 | 21:00:00 | 23:00:00 | 6 |  | Sporklenz CPR 4
 | 2022-08-04 00:00:00 | Theragent | 09:00:00 | 13:00:00 | 14:00:00 | 17:30:00 | 7.5 |  | Clean outside labs, [NAME], Clean windows
 | 2022-08-07 00:00:00 | Theragent | 14:00:00 | 18:00:00 | 19:00:00 | 04:30:00 | 8 | 5.5 | Water clean CPR1-4, all supporting areas
 | 2022-08-08 00:00:00 | Theragent | 16:30:00 | 20:00:00 | 21:00:00 | 03:30:00 | 8 | 1 | [NAME] clean CPR 1-4
 | 2022-08-09 00:00:00 | Theragent | 16:00:00 | 20:00:00 | 21:00:00 | 03:00:00 | 8 | 2 | [NAME] clean supporting areas
 | 2022-08-10 00:00:00 | Theragent | 16:00:00 | 20:00:00 | 21:00:00 | 09:00:00 | 8 | 8 | Sporklenz CPR 2-3, all supporting areas, thorough clean glass
 | 2022-08-11 00:00:00 | Theragent | 19:00:00 | 21:00:00 | 22:00:00 | 10:00:00 | 8 | 6 | Sporklenz CPR 2-3, all supporting areas, thorough clean glass
 | 2022-08-13 00:00:00 | Theragent | 11:00:00 | 15:00:00 | 17:00:00 | 21:00:00 | 8 |  | Clean floors [NAME] CPR 1-4 all supporting areas
 | 2022-08-15 00:00:00 | Theragent | 11am |  |  | 03:30:00 | 4.5 |  | Standby
 |  |  |  |  |  | Total Reg Hrs | 70.5
 |  |  |  |  |  | Total Overtime Hrs | 22.5
Spreadsheet: 81487d1281640110-return-event-based-on-date-example-file
Sheet: Sheet1

Enter Date Here |  |  | 2010-08-11 00:00:00
Part 1 |  | Work-up |  |  | WHS |  | Work-up |  |  | WHS |  | Work-up |  |  | WHS |  | Work-up |  |  | WHS
 |  |  |  |  |  |  |  |  |  |  |  | Test |  |  | RTR |  | Test |  |  | RTR
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
 |  | South | Hampton | LR2 |  |  | South | Hampton | LR2 |  |  | South | Hampton | LR2 |  |  | South | Hampton | LR2
 |  | North | Break | [NAME] |  |  | North | Break | [NAME] |  |  | North | Break | [NAME] |  |  | North | Break | [NAME]
 |  | East | Link |  |  |  | East | Link |  |  |  | East | Link | LR1 |  |  | East | Link | LR1
 |  |  | Heights |  |  |  |  | Heights |  |  |  | West | Heights |  |  |  |  | Heights
Part 2
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 3
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 4
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 5
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 6
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 7
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 8
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 9
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 10
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Part 11
 |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3 |  |  | Location 1 | Location 2 | Location 3
Spreadsheet: 829491d1684253571-help-with-nested-ifs-commission-plan
Sheet: Sheet1

Sales Commission Plan |  | Annual Revenue ð | 2000000
From | To | Commission Rate | Commission
0 | 1000000 | 0.05
 | 2500000 | 0.08
 | 99999999 | 0.1
 |  | Commission
 |  | Base | 125000
 |  | Total Comp
Spreadsheet: 91213d1290970239-excel-2007-identify-unique-employees-and-employees-with-a-change-in-hours-updated-mcmugs-sample-data
Sheet: CARLA MCIVOR_CM - General Assig

Month 1
Employee | HRS
Employee XYZ(10114) | 16.75
Employee XYZ(10114) | 16.75
Employee ABC (20457) | 40
Employee ABC (20457) | 40
Employee BCD (31358) | 0
Employee BCD (31358) | 17.5
Employee RST(31284) | 22
Employee RST(31284) | 32.5
Employee BXX (41823) | 26.5
Employee BXX (41823) | 10
Employee BMD (41231) | 24.5
Employee EJE (41281) | 20
Employee FDE (20282) | 40
Employee FEJ (20200) | 40
Employee FEJ (20200) | 40
Spreadsheet: 583429d1532434888-how-to-find-appropriate-prices-for-items-including-discount-price-example
Sheet: Sheet1

NAME | Q-TY | PRICE | SUM |  |  | NAME | Q-TY | PRICE | SUM
Item1 | 2300 | 1.68 |  |  |  | Item1 | 2300
Item2 | 4500 | 1.72 |  |  |  | Item2 | 4500
Item3 | 1234 | 1.86 |  |  |  | Item3 | 1234
Item4 | 787 | 0.78 |  |  |  | Item4 | 787
 |  |  | 1000 | Discount |  |  |  |  |  | Total
 |  |  |  | Total
Spreadsheet: 732712d1621179586-conditioning-formatting-failing-chemistry_v2-etaf
Sheet: data

 |  |  |  |  |  |  |  |  |  |  |  |  | Ideal Range |  |  | OFFSET
 |  |  | 2021-05-10 00:00:00 | Lower | Mid | Upper | Low Test | High test |  | 2021-05-15 00:00:00 |  |  | Lower | Upper |  | Low | MID | High
 |  | Free Chlorine | 0.5 | 1 | 2 | 3 | 0.5 | 4.1 |  | 2 |  |  | 1 | 3
 |  | Combined chlorine (calculated from FC and TC) | 0.2 | 0.2 | 0.35 | 0.5 | 0.1 | 1 |  | 0.3 |  |  | 0.2 | 0.5
 |  | Total Chlorine | 0.53 | 1 | 2 | 3 | 0.5 | 4.1 |  | 2 |  |  | 1 | 3
 |  | pH | 7.3 | 7.6 | 7.7 | 7.8 | 0.5 | 9 |  | 7.7 |  |  | 7.6 | 7.8
 |  | Total Alkalinity | 58 | 60 | 70 | 80 | 0.5 | 100 |  | 70 |  |  | 60 | 80
 |  | Calcium Hardness | 124 | 200 | 300 | 400 | 0.5 | 500 |  | 225 |  |  | 200 | 400
 |  | Cyanuric Acid | 5 | 40 | 45 | 50 | 0.5 | 100 |  | 44 |  |  | 40 | 50
 |  | Iron | 0.1 | 0 | 0.15 | 0.3 | 0.5 | 4.1 |  | 0.2 |  |  | 0 | 0.3
 |  | Copper | 0.3 | 0 | 0 | 0 | 0.5 | 4.1 |  | 0 |  |  | 0 | 0
 |  | Phosphates | 75 | 0 | 50 | 100 | -0.1 | 110 |  | 80 |  |  | 0 | 100
 |  | TDS (total dissolved solids) | 1250 | 0 | 1250 | 2500 | -0.1 | 3000 |  | 100 |  |  | 0 | 2500
 |  | actual values:
 |  | Free Chlorine | 0.5 |  | This is to track swimming pool chemistry values. The cell color will change based on the Ideal range values for each in column N and O. The low test and high test rules work fine but when the three-color rule is applied, it falls apart because Excel wants to use absolute values and not relative ones. If you look at the formula for the three-color in row three: the Midpoint formula is: =$N$3+(($O$3-$N$3)*0.5) For row 4, it should be =$N$4+(($O$4-$N$4)*0.5) Now, Excel uses that same formula for row 4 but since the Ideal Range values are different for row 4 than row 3, it shows a wrong color range for row 4. If I try to change the setting to only apply to the cell in row 4, and correct the formula to represent row 4, it removes the formula for the other rows. How can each row have the Three-color rule work without the same formula applied to each row? The sample sheet (now v2), has sample values for May 10 and May 15. The blue background columns headers show that the Conditional Formatting rules work for row 3 but not the other rows. In use, these blue columns will not be there, these are there for diagnostic purposes.
 |  | Combined chlorine (calculated from FC and TC) | 0.2
 |  | Total Chlorine | 0.53
 |  | pH | 7.3
 |  | Total Alkalinity | 58
 |  | Calcium Hardness | 124
 |  | Cyanuric Acid | 5
 |  | Iron | 0.1
 |  | Copper | 0.3
 |  | Phosphates | 75
 |  | TDS (total dissolved solids) | 1250
Spreadsheet: 675643d1588397273-retrieving-data-from-one-table-to-place-in-another-column-samplepage
Sheet: INCLUDE Lists

Mid North Coast | [NAME] | [NAME]
Spreadsheet: 221429d1363550027-beerfest-bracket-creation-brewfest
Sheet: Tracker

Game# | Winner | [NAME]
1
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
Spreadsheet: 106473d1303757574-text-to-columns-service-line-breakout
Sheet: Sheet1

TURN THIS:
Job # | Service Date | Location | Service Line
12345 | 2011-04-01 00:00:00 | Office 1 | SUPP,EXT,EE
56789 | 2011-04-15 00:00:00 | Office 2 | SP, BF
13579 | 2011-04-20 00:00:00 | Office 3 | EE
INTO THIS:
Job # | Service Date | Location | Service Line
12345 | 2011-04-01 00:00:00 | Office 1 | SUPP
12345 | 2011-04-01 00:00:00 | Office 1 | EXT
12345 | 2011-04-01 00:00:00 | Office 1 | EE
56789 | 2011-04-15 00:00:00 | Office 2 | SP
56789 | 2011-04-15 00:00:00 | Office 2 | BF
13579 | 2011-04-20 00:00:00 | Office 3 | EE
Spreadsheet: 168154d1342266730-help-with-data-validation-using-indirect-function-forum_indirectdropdownor_reply
Sheet: Sheet1

Account | Account | Type | Classification | Description |  | COLUMN A |  | COLUMN B |  |  | Coluumn C
Area | Column1 | Column2 | Column3 | Column4 |  | Account |  | Bank | Bookmaker
Bookmaker | Boylesports | Bet |  |  |  | Area |  | Accounts | Accounts |  | BankingType | BookmakerType
Banking | Barclays_Bank | Charge |  |  |  | Banking |  | Barclays_Bank | 188bet |  | Debit | Transfer
Bookmaker | 188bet | [NAME]. |  |  |  | Bookmaker |  | Halifax_Bank | 10Bet |  | Credit | Charge
Banking | Halifax_Bank | Charge |  |  |  |  |  | Lloyds_TSB | 12bet.com |  | Charge | Correction
Bookmaker | Betfair | Bet |  |  |  |  |  | Nationwide_Bank | 32 Red |  | Correction | [NAME].
Banking | Nationwide_Bank | Charge |  |  |  |  |  | Natwest_Bank | 5 Dimes |  | StartBal. | Win
Banking | Natwest_Bank | Charge |  |  |  |  |  |  | 888Sport |  |  | Lose
 |  |  |  |  |  |  |  |  | All You Bet |  |  | Confiscation
 |  |  |  |  |  |  |  |  | Bet 365 |  |  | Bet
 |  |  |  |  |  |  |  |  | Bet Red Kings
 |  |  |  |  |  |  |  |  | Bet3000
 |  |  |  |  |  |  |  |  | Bet-At-Home
 |  |  |  |  |  |  |  |  | BETDAQ
 |  |  |  |  |  |  |  |  | Betfair
 |  |  |  |  |  |  |  |  | Betfred
 |  |  |  |  |  |  |  |  | BetOnline
 |  |  |  |  |  |  |  |  | Betsonic
 |  |  |  |  |  |  |  |  | Betsson Sportsbook
 |  |  |  |  |  |  |  |  | Blue Square
 |  |  |  |  |  |  |  |  | Bodog
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Boylesports
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | comeon!
 |  |  |  |  |  |  |  |  | Coral
 |  |  |  |  |  |  |  |  | Dobet
 |  |  |  |  |  |  |  |  | Eurobet
 |  |  |  |  |  |  |  |  | Expekt
 |  |  |  |  |  |  |  |  | gamebookers