tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 582307d1531828851-need-help-with-creating-database-sample-of-spreadsheet
Sheet: Sheet1

[NAME] | Visit Date | Customer | Check In | Check Out | Visit Name | Planned Start | Actual Start | Mileage | Start Variance (min) | Planned Duration (min) | Actual Duration (min) | Duration [NAME] (min / %)
Walter, [NAME] | 2018-07-05 00:00:00 | Mark | MANUAL | MANUAL | Morning Call | 07:00:00 | 07:31:44 |  | 31 | 60 | 55 | -5min -8.33%
Walter, [NAME] | 2018-07-05 00:00:00 | [NAME] | MANUAL | MANUAL | Morning Call: ([NAME], Wed, [NAME], Sat, Sun) | 08:00:00 | 09:22:49 | 2.1 | 82 | 30 | 0 | -30min -100.00%
Walter, [NAME] | 2018-07-05 00:00:00 | Taco | MANUAL | MANUAL | Morning Call: (Personal care, Meal preparation) | 10:00:00 | 09:46:35 | 1.8 | -13 | 60 | 44 | -16min -26.67%
Walter, [NAME] | 2018-07-05 00:00:00 | Barbra | MANUAL | MANUAL | Morning Call: | 11:30:00 | 11:11:08 | 0.6 | -18 | 45 | 38 | [NAME]
Walter, [NAME] | 2018-07-05 00:00:00 | Mark | MANUAL | MANUAL | [NAME] | 12:10:00 | 12:07:50 | 3.7 | -2 | 30 | 39 | 9min 30.00%
Walter, [NAME] | 2018-07-05 00:00:00 | [NAME] | MANUAL | MANUAL | [NAME]: | 12:30:00 | 12:51:32 | 2.1 | 21 | 30 | 28 | -2min -6.67%
Walter, [NAME] | 2018-07-05 00:00:00 | [NAME] | MANUAL | MANUAL | [NAME]: (Personal Care) | 13:30:00 | 13:05:17 | 1.8 | -24 | 30 | 7 | -23min -76.67%
Walter, [NAME] | 2018-07-05 00:00:00 | Taco | MANUAL | MANUAL | Bed call: | 18:00:00 | 19:37:11 | 2.2 | 97 | 30 | 12 | -18min -60.00%
Walter, [NAME] | 2018-07-05 00:00:00 | [NAME] | MANUAL | MANUAL | Bed call: (Personal care, Meal preparation) | 18:45:00 | 19:53:24 | 0.6 | 68 | 30 | 25 | -5min -16.67%
Walter, [NAME] | 2018-07-05 00:00:00 | [NAME] | MANUAL | MANUAL | Bed Call: | 19:00:00 | 19:53:35 | 3.3 | -76 | 30 | 17 | [NAME]
Walter, [NAME] | 2018-07-05 00:00:00 | [NAME] | MANUAL | MANUAL | Bed Call: | 19:00:00 | 20:22:55 | 0 | 32 | 30 | 20 | -10min -33.33%
Walter, [NAME] | 2018-07-05 00:00:00 | Barbra | MANUAL | MANUAL | Tea Call | 19:25:00 | 20:30:33 | 2.1 | 65 | 30 | 23 | -7min -23.33%
All names are fictional, created for learing purpuses
What I want to achieve is to mark all names in column C and get a mileage in right cells.
Spreadsheet: 165a978c-2d7c-4a3a-bffd-7ab8178ca5b0
Sheet: Sheet1

Haapsalu Linnamajanduse AS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
juhatuse [NAME] liikmete 2006.a. palgaandmed
Ametikoht | Ametiisiku | 1.Põhipalk | 2.Lisatasud | 3.Muud | [NAME] | Periood | Teenistus-
 | nimi |  | [NAME] | tasud | 1.+2.+3. |  | [NAME]
 |  |  |  |  |  |  | vorm
Juhatuse | [NAME] | 16579 | 105000 |  | 121579 | 01.01.- | leping
[NAME] | Tamm |  |  |  |  | 2006-02-02 00:00:00
Juhatuse | Aleksander | 23763 | 11400 |  | 35163 | 03.02.- | leping
[NAME] | Alaküla |  |  |  |  | 2006-04-10 00:00:00
Juhatuse | Koit | 175216 | 22744 |  | 197960 | 10.04.- | leping
[NAME] | Vare |  |  |  |  | 2006-12-31 00:00:00
[NAME] | Märt |  |  | 18000 | 18000 | aasta | üldkoosoleku
esimees | Maiste |  |  |  |  |  | otsus
[NAME] | Tiit |  |  | 18000 | 18000 | aasta | üldkoosoleku
[NAME] | Moor |  |  |  |  |  | otsus
[NAME] | [NAME] |  |  | 18000 | 18000 | aasta | üldkoosoleku
[NAME] | [NAME] |  |  |  |  |  | otsus
Spreadsheet: 807121d1669752743-calculating-of-days-between-events-in-non-sequential-table-max-days-without-profit
Sheet: Sheet1

 | Open | Close | Profit | Days w/o Profit | Answer should be:
 | 2021-08-31 00:00:00 | 2021-08-31 00:00:00 | 80.22007588836506
 | 2021-09-01 00:00:00 | 2021-09-04 00:00:00 | 0
 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 0
 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 0
 | 2021-09-07 00:00:00 | 2021-09-07 00:00:00 | 0
 | 2021-09-10 00:00:00 | 2021-09-10 00:00:00 | 0
 | 2021-09-14 00:00:00 | 2021-09-14 00:00:00 | 0
 | 2021-09-15 00:00:00 | 2021-09-15 00:00:00 | 0
 | 2021-09-16 00:00:00 | 2021-09-18 00:00:00 | 21416.51493560476 |  | 0 | (Not sure about this. Although a trade which opened on the 17th closed on the 18th at 0 profit, so the correct answer could be 1)
 | 2021-09-17 00:00:00 | 2021-09-17 00:00:00 | 0
 | 2021-09-20 00:00:00 | 2021-09-20 00:00:00 | 100.4660950411429 |  | 0
 | 2021-09-21 00:00:00 | 2021-10-01 00:00:00 | 0
 | 2021-09-22 00:00:00 | 2021-10-02 00:00:00 | 0
Spreadsheet: 803149d1667292123-how-to-find-and-locate-results-with-id-via-hyperlink-sample-hyperlink
Sheet: Index

ID | Task | Status
04.1 - 00 | Task 1 | Done
04.3 - 00 | Task 2 | Open
04.4 - 00 | Task 3 | Open
04.5 - 01 | Task 4 | Done
04.6 - 00 | Task 5 | Done
04.6 - 01 | Task 6 | Open
04.7 - 01 | Task 7 | Open
05.2 - 00 | Task 8 | Open
05.3 - 00 | Task 9 | Open
05.5 - 00 | Task 10 | Open
05.6 - 00 | Task 11 | Open
05.7 - 00 | Task 12 | Done
05.8 - 00 | Task 13 | Done
05.9 - 00 | Task 14 | Open
05.10 - 01 | Task 15 | Open
05.24 - 00 | Task 16 | Open
05.25 - 00 | Task 17 | Done
05.26 - 00 | Task 18 | Done
05.28 - 00 | Task 19 | Open
05.29 - 00 | Task 20 | Open
05.30 - 01 | Task 21 | Done
05.32 - 00 | Task 22 | Open
05.33 - 00 | Task 23 | Done
Spreadsheet: 95072d1294768083-display-value-if-conditions-meet-sample
Sheet: Sheet1

Serial Number | Order Number | Shipping Date | Extended USD Price
3040 | 301343 | 2009-09-14 00:00:00 | 4179.98
 | 305342 | 2010-04-01 00:00:00 | 4034.15
 | 305343 | 2010-04-14 00:00:00 | 4034.15
4159 | 304159 | 2009-10-21 00:00:00 | 2994.18
 | 305239 | 2010-03-01 00:00:00 | 2873.64
 | 305240 | 2010-03-26 00:00:00 | 2873.64
4198 | 304198 | 2009-11-13 00:00:00 | 4847.72
 | 304779 | 2010-01-01 00:00:00 | 4966.04
4202 | 304202 | 2009-11-06 00:00:00 | 4080
 | 304464 | 2009-11-06 00:00:00 | 4080
 | 304465 | 2009-11-06 00:00:00 | 4080
4285 | 304285 | 2010-05-01 00:00:00 | 6000
 | 305651 | 2010-05-17 00:00:00 | 6000
4341 | 304341 | 2009-12-22 00:00:00 | 5035.4
 | 304728 | 2009-12-22 00:00:00 | 5064.64
 | 304729 | 2009-12-22 00:00:00 | 5064.64
4347 | 304347 | 2010-01-01 00:00:00 | 4080
 | 304826 | 2010-01-14 00:00:00 | 4080
4368 | 304368 | 2010-05-01 00:00:00 | 6000
 | 305701 | 2010-05-25 00:00:00 | 6000
 | 305702 | 2010-09-22 00:00:00 | 6000
 | 306591 | 2010-09-29 00:00:00 | 4920
 | 306592 | 2010-09-29 00:00:00 | 6000
4444 | 304444 | 2009-12-28 00:00:00 | 2970
 | 304746 | 2009-12-28 00:00:00 | 2970
 | 304748 | 2009-12-28 00:00:00 | 4424.11
4446 | 304446 | 2009-12-28 00:00:00 | 2970
 | 304745 | 2009-12-28 00:00:00 | 2970
 | 304747 | 2009-12-28 00:00:00 | 4424.11
4496 | 304496 | 2009-12-30 00:00:00 | 4900
 | 305152 | 2010-03-01 00:00:00 | 4900
4510 | 304510 | 2009-12-28 00:00:00 | 4398.57
 | 307476 | 2010-12-01 00:00:00 | 4068.6
4514 | 304865 | 2010-03-23 00:00:00 | 5576
 | 305633 | 2010-05-01 00:00:00 | 5576
 | 305635 | 2010-05-14 00:00:00 | 6800
4549 | 304549 | 2010-02-01 00:00:00 | 6000
 | 305086 | 2010-02-23 00:00:00 | 6000
 | 305087 | 2010-03-01 00:00:00 | 5300
4561 | 304561 | 2010-09-13 00:00:00 | 6800
 | 700008 | 2010-10-13 00:00:00 | 6800
 | 700011 | 2010-10-27 00:00:00 | 0
Spreadsheet: 96088d1295542736-data-manipulation-and-presentation-help-sampleforforum
Sheet: Sheet2

Requester | ID | Checkout Date | [NAME] | Number of days
Bobo 1 | KKK_CRAERFI1 | 2010-10-14 00:00:00 | 2010-10-18 00:00:00
Bobo 1 | KKK_CRAERFI1 | 2010-10-18 00:00:00 | 2010-10-18 00:00:00
Bobo 1 | KKK_CRAERFI1 | 2010-12-29 00:00:00 | 2011-01-05 00:00:00
Bobo 1 | KKK_CRAERFI1 | 2010-12-30 00:00:00 | 2011-01-05 00:00:00
[NAME] | KKK_JAHNSJO1 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00
[NAME] | KKK_JAHNSJO1 | 2009-12-02 00:00:00 | 2009-12-02 00:00:00
[NAME] | KKK_JAHNSJO1 | 2009-12-03 00:00:00 | 2009-12-07 00:00:00
[NAME] | KKK_JAHNSJO1 | 2009-12-08 00:00:00 | 2009-12-14 00:00:00
[NAME] | KKK_JAHNSJO1 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00
[NAME] | KKK_JAHNSJO1 | 2009-12-15 00:00:00 | 2009-12-21 00:00:00
Spreadsheet: 8c7a19ff-e47f-4335-a9e1-c06fd33349bb
Sheet: Cover Sheet

 |  |  | Integration Revenue Budget Worksheet
 |  |  |  |  | FY14
Use this worksheet to provide budget data needed to calculate FY14 integration revenue.
Address general questions on Integration Revenue budget submission to the Office of Equity and Innovation,
[PHONE]. Return the completed worksheet by March 15, 2013 to [EMAIL].
Electronic submission is required. Delete additional pages or those that do not pertain to your budget.
District Name:
District Number:
Superintendent:
Collaborative:
District Contact:
Phone:
E-mail:
Partner Districts:
List all Racially Identifiable school sites in your district:
Integration Revenue
TOTAL REVENUE
Integration Revenue Contributed to Collaborative
Notes or Comments:
 |  |  |  | [NAME]
We certify that the budget information submitted for our school district to the Minnesota Department of Education (MDE)
is an accurate and complete representation of the fiscal year 2014 Integration Revenue budget that was approved by the
school board.
 |  | Board Approval Date ____________________
School Board Chair |  |  |  |  |  | Date
Superintendent |  |  |  |  |  | Date
MDE Approval:____________________ Amount:_______________Date:______________
Spreadsheet: 101454d1299585511-assining-individual-values-to-multiple-identical-strings-book1_vivavilla
Sheet: Sheet1

Apple |  | 1 Apple
[NAME] |  | 1 Apricot
[NAME] |  | 1 [NAME]
Greengage |  | 1 Greengage
Hawthorn |  | 1 Hawthorn
Peach |  | 1 Peach
Pear |  | 1 Pear
Plum |  | 1 Plum
[NAME] |  | 1 Quince
Rose |  | 1 Rose
[NAME] |  | 1 [NAME]
Service |  | 1 Service
Apple |  | 2 Apple
Hawthorn |  | 2 Hawthorn
Pear |  | 2 Pear
[NAME] |  | 2 Quince
Rose |  | 2 Rose
[NAME] |  | 2 [NAME]
Service |  | 2 Service
Serviceberry |  | 1 Serviceberry
Apple |  | 3 Apple
[NAME] |  | 1 Chokeberry
Hawthorn |  | 3 Hawthorn
[NAME] |  | 1 Medlar
Pear |  | 3 Pear
[NAME] |  | 3 Quince
Rose |  | 3 Rose
[NAME] |  | 3 [NAME]
Service |  | 3 Service
Apple |  | 4 Apple
Hawthorn |  | 4 Hawthorn
Spreadsheet: 843081d1695048065-use-drop-down-list-value-to-change-row-values-else-where-on-sheet-jr_sr_excel_forum_question
Sheet: JR

Info
Name | Hauser Inc
Group | JR
Date | 2023-08-10 00:00:00
Time | 16:00 PM
JR Team | [NAME], [NAME]
JR Attendees | [NAME], [NAME], [NAME]
Comment
Project Timelines
Timelines | Date | Comments
ABCD | 2018-01-01 00:00:00
GRE | 2024-04-15 00:00:00
FPU | 2024-07-15 00:00:00
GHY | 2024-09-15 00:00:00
JR Information:
JR Balance
JR Collection
ID | Number
ID123456 | 123456
Spreadsheet: 172635d1344278614-populating-a-list-based-on-two-variables-excluding-entries-which-are-blank-ncl-example
Sheet: Application Data

 | Name |  | Standard |  | Standard + |  | Art / Music |  | Gaming |  | Complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice
 | Abode |  | Yes |  | Yes |  | Yes |  | Yes |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 | Aunty |  |  |  | Yes |  | Yes |  |  |  | Yes
 | Avastule |  | Yes |  | Yes |  | Yes |  | Yes |  | Yes
 | BB's |  |  |  |  |  |  |  |  |  | Yes
 | Dmon |  |  |  | Yes |  |  |  | Yes |  | Yes
 | Dropp'n |  |  |  | Yes |  | Yes |  |  |  | Yes
 | Gallops |  |  |  | Yes |  | Yes |  |  |  | Yes
 | Handbrake Turns |  |  |  | Yes |  | Yes |  |  |  | Yes
 | iSoft |  |  |  | Yes |  | Yes |  |  |  | Yes
 | [NAME] |  | Yes |  | Yes |  | Yes |  | Yes |  | Yes
 | KeTV |  |  |  | Yes |  |  |  |  |  | Yes
 | K-L |  | Yes |  | Yes |  | Yes |  | Yes |  | Yes
 | Mr B |  | Yes |  | Yes |  | Yes |  | Yes |  | Yes
 | [NAME] |  |  |  | Yes |  | Yes |  |  |  | Yes
 | Oh Schadenfreude |  |  |  |  |  |  |  |  |  | Yes
 | [NAME] |  |  |  |  |  | Yes |  |  |  | Yes
 | Skippy |  | Yes |  | Yes |  | Yes |  | Yes |  | Yes
 | Steaming Hot |  |  |  |  |  |  |  | Yes |  | Yes
 | Torrannysaurus |  |  |  | Yes |  |  |  |  |  | Yes
 | Truckin' |  |  |  | Yes |  | Yes |  |  |  | Yes
 | uTorment |  |  |  | Yes |  |  |  | Yes |  | Yes
 | VBoxing |  |  |  | Yes |  |  |  |  |  | Yes
 | VPlayer |  |  |  | Yes |  | Yes |  | Yes |  | Yes
 | We Learn Evereything |  |  |  |  |  |  |  |  |  | Yes
 | Window Washing |  | Yes |  | Yes |  | Yes |  | Yes |  | Yes
Spreadsheet: 790791d1659994217-drawing-correct-number-from-drop-down-box-excel-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Goal- I am aiming to get row 9 to desplay data from row 20. however, 9b must be the first number larger than 0. this will change as the date (in gray) is changed.
 |  | 1 |  | 2020 | AS YOU CHANGE THIS NUMBER BELOW (drop down list))
 |  |  |  | 2025
 |  |  | sheet 1
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | e.g- if gray box = 2020 then 9b= 3, 9c= 40, 9d= 64
 | 3 | 40 | 64 | 88
 | 0.2 | 0.8 | 1 | 3 |  |  |  |  |  |  |  |  |  | e.g- if gray box = 2025 then 9b= 0.2, 9c= 0.8, 9d= 1
 |  |  | sheet 2
Age |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] this- just formulas working in the background
Age | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 0 | 0.2 | 1 | 2 | 5 | 15 | 31 | 53 | 76 | 101 | 125 | 139 | 150
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum Dec 27-Jan 2

 | Week summary (Dec 27- Jan 2)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized | 2
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other | 1
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other | 0
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds | 0
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized in ERMS, but not RiskTrac
 |  |  |  | Application down alternate system used | 0
 |  |  |  | Other | 0
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 118771d1314007691-function-to-get-multiple-values-tigeravatar-example-for-thnaksforhelp
Sheet: Sheet1

Store | Item | Amt |  | Store | Item |  |  | HeaderA
Store1 | Item1 | Amt |  | Store3 | Item1 |  |  | Store1
Store1 | Item2 | Amt |  |  | Item2 |  |  | [NAME]
Store1 | Item3 | Amt |  |  | Item3 |  |  | Store3
Store1 | Item4 | amt |  |  | Item4
[NAME] | Item2 | Amt
[NAME] | Item3 | Amt
[NAME] | Item4 | amt
Store3 | Item1 | Amt
Store3 | Item2 | Amt
Store3 | Item3 | Amt
Store3 | Item4 | amt
Spreadsheet: 193337d1352806379-trying-to-apply-multiple-entries-with-vlookup-and-use-two-if-statements-adv-comp-project2
Sheet: Crew Rate

 | Crew Productivity Rate for Activities
 |  |  | Concrete Formwork Productivity |  |  | Concrete Placement Productivity |  |  | Concrete Finishing Productivity
 |  | Description | Crew | Rate | Units | Crew | Rate | Units | Crew | Rate | Units
 | [NAME] | Wall Grade <=8' H | [NAME] | 0.13 | wkhrs/SFCA | Conc2 | 0.55 | wkhrs/CY | Finshr1 | 0.03 | wkhrs/SF
 | WG16 | Wall Grade <=16' H | [NAME] | 0.17 | wkhrs/SFCA | Conc2 | 0.65 | wkhrs/CY | Finshr1 | 0.045 | wkhrs/SF
 | FD8 | Foundation Wall Grade <=8' Below | [NAME] | 0.12 | wkhrs/SFCA | Conc1 | 0.45 | wkhrs/CY | Finshr1 | 0.03 | wkhrs/SF
 | FD16 | Foundation Wall Grade <=16' Below | [NAME] | 0.14 | wkhrs/SFCA | Conc1 | 0.55 | wkhrs/CY | Finshr1 | 0.045 | wkhrs/SF
 | CNTFT | [NAME] | Form1 | 0.085 | wkhrs/SFCA | Conc1 | 0.343 | wkhrs/CY | N/A | N/A | N/A
 | SPRDFT | Spread Footing | Form1 | 0.105 | wkhrs/SFCA | Conc1 | 0.6 | wkhrs/CY | N/A | N/A | N/A
 | GB | [NAME] | [NAME] | 0.17 | wkhrs/SFCA | Conc1 | 0.32 | wkhrs/CY | N/A | N/A | N/A
 | [NAME] | Columns 8" DIA | Form1 | 0.021 | wkhrs/LF | Conc2 | 2 | wkhrs/CY | Finshr1 | 0.06 | wkhrs/SF
 | COL12 | columns 12" DIA | Form1 | 0.024 | wkhrs/LF | Conc2 | 1.8 | wkhrs/CY | Finshr1 | 0.05 | wkhrs/SF
 | COL16 | Columns 16" DIA | Form1 | 0.028 | wkhrs/LF | Conc2 | 1.5 | wkhrs/CY | Finshr1 | 0.045 | wkhrs/SF
 | COL20 | Columns 20" DIA | Form1 | 0.032 | wkhrs/LF | Conc2 | 1.3 | wkhrs/CY | Finshr1 | 0.04 | wkhrs/SF
 | COL24 | Columns 24" DIA | Form1 | 0.036 | wkhrs/LF | Conc2 | 0.8 | wkhrs/CY | Finshr1 | 0.035 | wkhrs/SF
 | COL30 | Columns 30" DIA | Form1 | 0.04 | wkhrs/LF | Conc2 | 0.6 | wkhrs/CY | Finshr1 | 0.03 | wkhrs/SF
 | KW | Keyway | Carptr1 | 0.015 | wkhrs/LF | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Columns, Rect 0"<12" Thick | Form1 | 0.18 | wkhrs/SFCA | Conc2 | 1.067 | wkhrs/CY | Finshr1 | 0.05 | wkhrs/SF
 | RCOL16 | Columns, Rect 12"<18" Thick | Form1 | 0.16 | wkhrs/SFCA | Conc2 | 0.711 | wkhrs/CY | Finshr1 | 0.043 | wkhrs/SF
 | RCOL18 | Columns, Rect 18"<24" Thick | Form1 | 0.14 | wkhrs/SFCA | Conc2 | 0.696 | wkhrs/CY | Finshr1 | 0.035 | wkhrs/SF
 | PRS | Piers | Form1 | 0.15 | wkhrs/SFCA | Conc1 | 0.45 | wkhrs/CY | Finshr1 | 0.04 | wkhrs/SF
 | SOG | Slab on Grade (edge Forms) | Form1 | 0.08 | wkhrs/LF | Conc1 | 0.65 | wkhrs/CY | Finshr1 | 0.015 | wkhrs/SF
 | SOMD | Slab on Metal Deck | N/A | N/A | N/A | Conc2 | 0.45 | wkhrs/CY | Finshr1 | 0.018 | wkhrs/SF
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -20818 | -20000
2 | -19999 | -20000
3 | -21734 | -20609
4 | -20009 | -20000
5 | -20393 | -20000
6 | -20508 | -20000
7 | -20768 | -20000
8 | -21004 | -19966
9 | -20992 | -20000
10 | -21007 | -20702
11 | -20996 | -19967
12 | -20140 | -19726
13 | -19791 | -20000
14 | -20311 | -20000
15 | -26129 | -25702
16 | -20992 | -20000
17 | -20037 | -20000
18 | -24168 | -23202
19 | -23086 | -23202
20 | -23625 | -23202
21 | -21002 | -20468
22 | -20992 | -20468
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 135803
2001-08-22 00:00:00
CBS Dollars
 |  |  | 82140
Spreadsheet: 700892d1603387555-bring-unique-data-with-data-validation-list-red
Sheet: Sheet1

Title | Colar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
A | Red |  |  | Red | Blue | Yellow | Green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
B | Red |  | A
B | blue
A | Red
B | blue |  | Result A | Red | Blue | Yellow | Green
A | blue |  | Result B | Red | Blue | Green
B | Green
A | Yellow
A | Green |  |  | I need to change D3 ,then change the Results
 |  |  |  | Please help ,wihout vb & helper column
Spreadsheet: 169418d1342814846-how-to-compare-and-highlight-a-column-based-other-columns-matching-without-replacement-chrismarince_846572-how-to-compare-and-highlight-a-column_19jul12_02
Sheet: Sheet1

Value1 | Value2 | Value3 |  | Value3 | Value2 | Value1
54 | 08:45:00 | [NAME] |  | [NAME] | 08:45:00 | 37
37 | 01:12:00 | [NAME] |  | [NAME] | 05:35:00 | -1
78 | 05:35:00 | [NAME] |  | [NAME] | 06:40:00 | 901
90 | 06:40:00 | [NAME] |  | [NAME] | 02:05:00 | 14
37 | 08:45:00 | [NAME] |  | [NAME] | 19:30:00 | 54
82 | 03:14:00 | [NAME] |  | [NAME] | 08:45:00 | 54
14 | 02:05:00 | [NAME] |  | [NAME] | 01:12:00 | 37
54 | 07:30:00 | [NAME] |  | [NAME] | 09:00:00 | 14
14 | 09:00:00 | [NAME] |  | [NAME] | 03:14:00 | -1
Spreadsheet: 138217d1327574070-formula-with-sheet-name-variable-toys
Sheet: Item 001

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Price Check | 2012-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Sellers | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highest Price | 19.22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Price | 27.83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From | joshduanemaria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | US
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lowest Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Total Value
Item | Mattel Hot Wheels Super Transporter with 7 Cars
Year | 2006
Condition | Factory Sealed | This has never been opened, however the box has a little bit of wear and remnants of a price tag in the upper right corner.
Description | Mattel Hot Wheels Super Transporter with 7 Cars
Spreadsheet: 782813d1654283234-need-help-with-mult-ifs-statement-with-indexing-2022-06-03-oeldere-punksterz626-sample-data
Sheet: Sheet1

Source_Num | Code_Num | Type | Value | Kolom1 |  |  | Code_Num | A | B
412358 | 147 | A | 6 |  |  |  | 147 | 6
56425 | 152 | A | 15 |  |  |  | 152 | 15
64323 | 321 | B | 15 |  |  |  | 321 | 11 | 15
59988 | 321 | A | 11 |  |  |  | 474 |  | 30
74613 | 321 | A | 11 |  |  |  | 852 | 14 | 18
52625 | 474 | B | 30 |  |  |  | 985 | 12 | 20
61932 | 852 | A | 14
23164 | 852 | B | 18
78456 | 985 | A | 12
525252 | 985 | B | 20
14785 | 985
13698 |  | A
Hello all Gurus,
I hope everyone is having a great day. I'm hoping someone can help me create a formula that solves this scenario.
I have a table that I want to add a column that captures the value from another source table.
If you look at the provided data sample provided, column D's value is based on two criteria, columns B & C. With those two criteria, I want to index the value from the source table. I have included the expected result in red fonts to show what i want to achieve. There are also times when column B or C is missing data. When that error occurs, just leave it cell blank. The layout of the source table can be adjusted if there is a more simplified way of listing them to achieve the same result. I'm open to any modification that you see fit.
Thank you for taking the time out of your day to assist.
Spreadsheet: 267139d1379966542-need-help-with-dashboard-formulas-conditional-averaging-and-division-sample
Sheet: Sheet1

ID # | Created Date | Inquiry Type | Status | Resolution Category |  | Inquiry Daily Average by Month
1 | 2013-08-01 00:00:00 | [NAME] | Resolved | Same day |  | Inquiry Type | 2013-08-13 00:00:00 | 2013-09-13 00:00:00 | Grand Total
2 | 2013-08-02 00:00:00 | Phone | Resolved | Within 5 days |  | [NAME]
3 | 2013-08-03 00:00:00 | [NAME] | Resolved | Same day |  | Phone
4 | 2013-08-03 00:00:00 | Phone | Resolved | Over 5 days |  | Grand Total
5 | 2013-08-03 00:00:00 | [NAME] | Resolved | Same day
6 | 2013-08-03 00:00:00 | Phone | Resolved | Within 5 days |  | Same-day Response Rate by Month
7 | 2013-08-05 00:00:00 | [NAME] | Resolved | Same day |  | Inquiry Type | 2013-08-13 00:00:00 | 2013-09-13 00:00:00 | Grand Total
8 | 2013-08-15 00:00:00 | Phone | Resolved | Same day |  | [NAME]
9 | 2013-08-20 00:00:00 | [NAME] | Resolved | Within 5 days |  | Phone
10 | 2013-08-20 00:00:00 | [NAME] | Resolved | Same day |  | Grand Total
11 | 2013-08-20 00:00:00 | [NAME] | Resolved | Same day
12 | 2013-08-20 00:00:00 | [NAME] | Resolved | Within 5 days
13 | 2013-08-20 00:00:00 | [NAME] | Resolved | Same day
14 | 2013-08-30 00:00:00 | [NAME] | Resolved | Same day
15 | 2013-09-01 00:00:00 | Phone | Resolved | Within 5 days
16 | 2013-09-04 00:00:00 | [NAME] | Resolved | Same day
17 | 2013-09-15 00:00:00 | Phone | Resolved | Same day
18 | 2013-09-15 00:00:00 | [NAME] | Resolved | Within 5 days
19 | 2013-09-15 00:00:00 | Phone | Resolved | Same day
20 | 2013-09-18 00:00:00 | [NAME] | Resolved | Over 5 days
21 | 2013-09-18 00:00:00 | Phone | Resolved | Same day
22 | 2013-09-18 00:00:00 | [NAME] | Resolved | Same Day
23 | 2013-09-19 00:00:00 | Phone | Resolved | Same day
24 | 2013-09-23 00:00:00 | [NAME] | Open | Same day
25 | 2013-09-23 00:00:00 | Phone | Open | Same day
Spreadsheet: 797889d1664203471-if-returning-multiple-values-s666-pq-search
Sheet: Sheet1

Item # | Category |  | Search |  | Item # | Category
95200-020-01 | Car |  | 2555-044-85 |  | 44568-052-03 | Bike
95200-040-02 | Car |  | 44568-052-03 |  | 2555-044-85 | Toy
45887-011-08 | Toy
44568-052-03 | Bike
2555-044-85 | Toy
99557-845-25 | Bike
33894-516-87 | Car
Spreadsheet: 746652d1630937233-use-a-formula-if-a-list-of-cells-contain-an-item-cell-contains
Sheet: Plot Output

 |  |  |  |  |  |  |  |  | Top of Vibro pile Mat
 |  |  |  |  |  |  |  |  | Types of Foundation used |  | Driven
 |  |  |  |  |  |  |  |  | Types of Foundation used |  | Vibro
 |  |  |  |  |  |  |  |  | Types of Foundation used |  | Trench
 |  |  |  |  |  |  |  |  | Types of Foundation used |  | Raft
Spreadsheet: 468076d1467125005-copying-row-formula-from-one-sheet-to-another-sheet-template
Sheet: Sheet4

Dissolution Sampling Time | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Amount Released