tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883742d1732429418-filtering-a-list-down-to-display-only-items-with-annual-due-dates-matching-current-month-bigpapamurf-sampleannual-1-spill-365-aligw
Sheet: Items

 | [NAME]
 | Item | ItemType | Due Date | Column1 | Column2 | Column3 | Balance
 | [NAME] | Expense1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | All Fixed Expenses | Due Date | Type of Expense
 | item2 | AnnualExpense | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense1
 | item3 | AnnualExpense | 1 |  |  |  |  |  | Expense1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense2
 | item4 | Expense2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense3
 | [NAME] | Expense1 | 3 |  |  |  |  |  | Expense2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense4
 | item6 | Expense2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense5
 | [NAME] | Expense4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense6
 | item8 | Expense1 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AnnualExpense
 | item9 | Expense1 | 6 |  |  |  |  |  | Expense4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense8
 | item10 | Expense2 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense9
 | item11 | Expense2 | 6 |  |  |  |  |  | Expense5
 | item12 | Expense2 | 7
 | item13 | Expense2 | 7 |  |  |  |  |  | Expense6
 | item14 | Expense8 | 7
 | item15 | AnnualExpense | 8 |  |  |  |  |  | Expense7
 | item16 | Expense1 | 10
 | item17 | Expense1 | 10 |  |  |  |  |  | Expense8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense1 | Due Date
 | item18 | Expense8 | 11
 | item19 | Expense4 | 11
 | item20 | Expense4 | 11
 | item21 | AnnualExpense | 11
 | item22 | AnnualExpense | 12
 | item23 | Expense1 | 12
 | item24 | Expense2 | 14
 | item25 | AnnualExpense | 15
 | item26 | Expense2 | 16
 | item27 | Expense1 | 18
 | item28 | Expense8 | 18
 | item29 | Expense8 | 19
 | item30 | Expense2 | 20
 | item31 | AnnualExpense | 21
 | item32 | Expense2 | 24
 | item33 | AnnualExpense | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense2 | Due Date
 | [NAME] | Expense2 | 26
 | item35 | AnnualExpense | 26
 | item36 | AnnualExpense | 28
 | item37 | Expense4 | 29
 | item38 | Expense9 | Paycheck
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense4 | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | AnnualExpense | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expenses124 | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense6 | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense7 | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense8 | Due Date
Spreadsheet: 117780d1313012880-macro-button-to-pull-and-dump-data-help-master-file
Sheet: Master

 |  | Voter data selection
 |  |  |  | Get data: |  | When completed:
 |  | Name | [NAME] | Response | Party ID | Voting Likelihood | Sign (Y/N) | [NAME] | Other | Other (2)
 |  | Address | 5711 Wells Place | [NAME] | Select Party ID | Select Voting Likelihood | [NAME] (Y/N) | Select Sign Size | Select Other | Select Other (2)
 |  | Phone | [PHONE]
 |  |  |  | vlookup address from raw data |  |  |  | dumps [NAME] allan and his info into "results" worksheet
 |  |  |  |  |  |  |  | and gets the next person's (below [NAME] allen) to show up
 |  |  |  |  |  |  |  | in the "name, address and phone" field ion C8-C11)
 |  |  |  | vlookup phone # from raw data
 |  |  |  |  |  | get name from raw data list starting from C2 (first and last name)
Spreadsheet: 8153d795-7def-4e2f-b90f-e42009d743b2
Sheet: Summary (2)

 | Summary of All University Institutions |  |  |  |  |  |  |  |  |  |  |  | Return to Index |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | Zoom % should be at 75%.
 | Summary of R & D Expenditures |  |  |  |  |  |  |  |  | Overall Total | Defined For Survey
 | R & D Expenses as defined for the Research Expenditure Survey
 | R & D Expenses not meeting the narrow definition of R & D used in the Research Expenditures Survey
 | Total Expenses for R & D as reported on the Statement of Revenues, Expenses and Changes in Net Assets
 | Other Research-related Equipment Expenditures (noncurrent fund expenditures, etc. - do not include R & D plant expenses or construction)
 | Indirect Costs associated with Expenses for R & D as defined for this survey
 | Capital Outlay for research equipment (do not include R & D plant expenses or construction)
 | Expenditures for conduct of R & D made by institution's research foundation or 501© corporation on behalf of the institution and not report in institution AFR, including indirect costs not reported above
 | Pass-throughs from Texas Engineering Experiment Station not reported in R & D Expenditures as defined for the Research Expenditure Survey
 | Total R & D Expenditures |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | R & D Expenditures By Funding Source |  |  |  | Federal | State Appropriations | State Contracts/Grants | Institution Resources | Private                  For-Profit | Private                     Non-Profit | Total
 | Agricultural Sciences
 | Biological and Other Life Sciences
 | Computer Science
 | Engineering
 | Environmental Sciences
 | Mathematical Sciences |  |  |  |  |  |  |  |  |  |  |  |  | Difference
 | Medical Sciences
 | Physical Sciences
 | Psychology
 | Social Sciences
 | Other Sciences not classified above
 | Arts and Humanities
 | Business Administration
 | Education
 | Law
 | Field of Study - Future Use 1
 | Field of Study - Future Use 2
 | Field of Study - Future Use 3
 | Field of Study - Future Use 4
 | Field of Study - Future Use 5
 | Other Non-Science Activities |  |  |  |  |  |  |  |  |  |  |  |  | To Accountability | Sources & Uses
 | Total R & D Expenditures By Funding Source |  |  |  |  |  |  |  |  |  |  |  |  | ResPercGenRev | State Appropriations
 |  |  |  |  |  | State Total |  |  | Pvt. Total |  | Federal & Private
 | R & D Expenditures - Select Areas of Special Interest |  |  |  |  |  |  |  |  |  |  |  |  | ExpendPerFTE
 | Aging
 | Cancer Research |  |  |  |  |  |  |  |  |  |  |  |  | T/TT Fall Fac FTE
 | Cardiovascular Research
 | Child Health and Human Development |  |  |  |  |  |  |  |  |  |  |  |  | As of Fall xxxxx
 | Mental Health
 | HRI Special Interest - Future Use 1
 | HRI Special Interest - Future Use 2
 | HRI Special Interest - Future Use 3
 | HRI Special Interest - Future Use 4
 | HRI Special Interest - Future Use 5
 | Total R & D Expenditures - Select Areas of Special Interest
Spreadsheet: 234477d1368112274-finding-last-instance-in-a-list-example
Sheet: Sheet1

Username1 | StartDate1 |  |  |  |  | Start | End
Client 1 | 2013-05-08 12:59:16 |  |  |  | Client 1
Client 1 | 2013-05-08 13:43:28 |  |  |  | Client 2
Client 1 | 2013-05-08 14:55:42 |  |  |  | Client 3
Client 1 | 2013-05-08 15:30:42 |  |  |  | Client 4
Client 1 | 2013-05-08 15:58:23 |  |  |  | Client 5
Client 1 | 2013-05-08 16:14:11
Client 1 | 2013-05-08 17:35:58
Client 1 | 2013-05-08 18:23:02
Client 1 | 2013-05-08 19:30:39
Client 2 | 2013-05-08 08:00:04
Client 2 | 2013-05-08 13:24:00
Client 2 | 2013-05-08 15:37:39
Client 3 | 2013-05-07 23:37:28
Client 3 | 2013-05-08 02:00:19
Client 3 | 2013-05-08 04:32:13
Client 3 | 2013-05-08 04:50:56
Client 3 | 2013-05-08 21:00:40
Client 3 | 2013-05-08 22:58:05
Client 4 | 2013-05-08 07:59:48
Client 4 | 2013-05-08 13:17:15
Client 4 | 2013-05-08 14:00:42
Client 4 | 2013-05-08 14:41:02
Client 5 | 2013-05-08 12:59:18
Client 5 | 2013-05-08 13:45:21
Client 5 | 2013-05-08 14:36:00
Client 5 | 2013-05-08 15:35:58
Client 5 | 2013-05-08 16:55:03
Client 5 | 2013-05-08 18:28:39
Client 5 | 2013-05-08 19:23:18
Client 5 | 2013-05-08 20:21:17
Spreadsheet: 153767d1336050459-how-to-populate-the-cells-in-one-sheet-with-data-taken-from-a-user-selected-second-sheet-book1
Sheet: Sheet1

SELECT sheet | Sheet2
 |  |  |  | This is just a list of possible sheet selections
Sheet2-1 |  |  |  | Sheet2
Sheet2-1 |  |  |  | Sheet3
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Sheet2-1
Spreadsheet: 215893d1361532141-vlookup-based-on-more-than-one-criteria-todaysample
Sheet: Sheet2

ORIGINAL ORDER ID | ISBN13
99858802 | 9780307886279
[PHONE]-6202708 | 9781934170113
[PHONE]-9380354 | 9781592407330
[PHONE]-3041966 | 9780061670121
[PHONE]-7904312 | 9780785160090
[PHONE]-6594713 | 9781421550619
[PHONE]-4106718 | 9781592407330
[PHONE]-7537932 | 9781592407330
[PHONE]-3959558 | 9781592407330
[PHONE]-3110712 | 9780688109905
[PHONE]-8278745 | 9781421520025
[PHONE]-7914724 | 9780807068793
[PHONE]-9231554 | 9781891369902
[PHONE]-1246769 | 9780307595836
[PHONE]-1307512 | 9780785162926
BDA-076-[PHONE] | 9781592407330
BDA-107-[PHONE] | 9781416509769
BDA-272-[PHONE] | 9780316085298
BDA-298-[PHONE] | 9780778313908
[NAME] | 9781849703475
BDA-461-[PHONE] | 9781416577607
BDA-504-[PHONE] | 9780762445264
BDA-527-[PHONE] | 9780307886279
BDA-551-[PHONE] | 9780316043472
BDA-577-[PHONE] | 9781442444058
BDA-627-[PHONE] | 9780545348416
BDA-639-[PHONE] | 9780307279187
BDA-644-[PHONE] | 9781616383701
BDA-694-[PHONE] | 9781585421466
BDA-732-[PHONE] | 9781554512119
BDA-970-[PHONE] | 9781592407330
BDG-022-[PHONE] | 9780316068987
BDG-024-[PHONE] | 9780316043472
BDG-137-[PHONE] | 9780763615031
BDG-173-[PHONE] | 9780374533403
BDG-194-[PHONE] | 9780553289435
BDG-231-[PHONE] | 9780553277401
BDG-255-[PHONE] | 9780758290427
BDG-281-[PHONE] | 9780736421867
BDG-332-[PHONE] | 9780307931801
BDG-445-[PHONE] | 9780763615031
BDG-511-[PHONE] | 9781250008510
BDG-534-[PHONE] | 9780547408569
BDG-591-[PHONE] | 9780307378163
BDG-600-[PHONE] | 9780345485809
BDG-621-[PHONE] | 9780307886279
BDG-623-[PHONE] | 9781608860487
BDG-675-[PHONE] | 9780553268881
BDG-747-[PHONE] | 9780762445264
BDG-771-[PHONE] | 9781592407330
BDG-775-[PHONE] | 9780451219947
BDG-817-[PHONE] | 9780553277401
BDG-834-[PHONE] | 9780316068703
BDG-876-[PHONE] | 9780765342300
BDG-908-[PHONE] | 9780786956210
Spreadsheet: benjamin_rogers__1223__UAE's Cost Model with debt structure 04-20-00
Sheet: Performance

UAE Lowell Power Expansion |  | Single LM6000 Unit
Equipment Performance |  | Ambient vs. Front End Simple Cycle Technology
5 - GE/S&S LM6000 Units
 |  | 0 oF |  |  |  | 60 oF |  |  |  | 90 oF
 |  | DLE | Spr. w/ WI | Spr. w/ SI |  | DLE | Spr. w/ WI | Spr. w/ SI |  | DLE | Spr. w/ WI | Spr. w/ SI
 |  | General Plant Performance Data
Generator Power, MW |  | S | 48.76 | 48.76 |  | 44.28 | 46.13 | 47.35 |  | 44.32 | 46.04 | 47.25
[NAME], Btu/kWh (LHV) |  | & | 8338 | 8338 |  | 8261 | 8557 | 7934 |  | 8260 | 8555 | 7938
[NAME], Btu/kWh (HHV) (3) |  | S | 9264.435179999999 | 9264.435179999999 |  | 9178.87971 | 9507.768269999999 | 8815.54674 |  | 9177.7686 | 9505.54605 | 8819.991179999999
[NAME] Adjusted for Steam Use, Btu/kWh (HHV) |  |  | na | 10132.16487647252 |  | na | na | 9665.98452247096 |  | na | na | 9664.076132380951
[NAME], mmBtu/hr (LHV) |  |  | 406.56088 | 406.56088 |  | 365.79708 | 394.73441 | 375.6749 |  | 366.0832 | 393.8722 | 375.0705
[NAME], mmBtu/hr (HHV) |  |  | 451.2825768 | 451.2825768 |  | 406.0347588 | 438.1551951000001 | 416.9991390000001 |  | 406.3523520000001 | 437.1981420000001 | 416.328255
[NAME], tons |  | R | 0 | 0 |  | 210 | 208 | 212 |  | 1892 | 1590 | 1905
Water Injection Flow, pph |  | u | 20548 | 0 |  | 0 | 20835 | 0 |  | 0 | 20593 | 0
Steam Injection Flow, pph |  | n | 0 | 33500 |  | 0 | 0 | 31883 |  | 0 | 0 | 31578
Sprint Water Injection Flow, pph |  | s | 0 | 0 |  | 0 | 2445 | 2445 |  | 0 | 2445 | 2445
Aux Load (kW) (2) |  |  | 1200 | 1200 |  | 1200 | 1200 | 1200 |  | 1200 | 1200 | 1200
[NAME]. Load (kW) |  |  | 0 | 0 |  | 272 | 270.6 | 273.4 |  | 1449.4 | 1238 | 1458.5
Net Power Output, MW |  | @ | 47.56 | 47.56 |  | 42.808 | 44.65940000000001 | 45.8766 |  | 41.6706 | 43.602 | 44.5915
NOx, ppm |  | 2 | 25 | 25 |  | 25 | 25 | 25 |  | 25 | 25 | 25
NOx, pph |  | 0 | 41 | 41 |  | 37 | 40 | 38 |  | 37 | 40 | 38
CO, ppm |  | oF | 80 | 80 |  | 25 | 29 | 23 |  | 25 | 28 | 23
CO, pph |  |  | 80 | 80 |  | 22 | 28 | 22 |  | 22 | 27 | 21
Expected DEP NOx Emission Rate, ppm |  |  | 2 | 2 |  | 2 | 2 | 2 |  | 2 | 2 | 2
Reduction Required |  |  | 0.92 | 0.92 |  | 0.92 | 0.92 | 0.92 |  | 0.92 | 0.92 | 0.92
Expected DEP NOx Emission Rate, lb/mmBtu |  |  | 0.007372920096852302 | 0.007372920096852302 |  | 0.007372920096852302 | 0.007372920096852302 | 0.007372920096852302 |  | 0.007372920096852302 | 0.007372920096852302 | 0.007372920096852302
Expected DEP NOx Emission Rate, lb/hr |  |  | 2.993661833177097 | 2.996003422464001 |  | 3.327270379848013 | 3.230483243493032 | 3.223426967458287 |  | 3.327270379848013 | 3.074501332303207 | 3.06955495817695
Expected DEP CO Reduction Rate, % |  |  | 0.9 | 0.9 |  | 0.9 | 0.9 | 0.9 |  | 0.9 | 0.9 | 0.9
Expected DEP CO Emission Rate, ppm |  |  | 8 | 8 |  | 2.5 | 2.9 | 2.3 |  | 2.5 | 2.8 | 2.3
Notes:
1 | [NAME] (Sprint) is not currently available with DLE combustors.
2 | Auxiliary load includes fuel compression, [NAME]. GT auxiliaries, and transformer losses
3 | Gross heat rate as a function of the HHV of the fuel plus degradation
Spreadsheet: 826901d1682361857-index-match-multiple-criteria-multiple-results-index-match-multiple-criteria-multiple-results
Sheet: Sheet1

 | EXAMPLE DATA SET |  |  |  |  | EXPECTED RESULT
 |  | Exam 1 | Exam 2 | Exam 3 |  | Exam 1 | Exam 2 | Exam 3
 | Task 1 | x |  |  |  | Task 1 | task 4 | Task 3
 | Task 2 |  |  |  |  | Task 3 | Task 7 | Task 6
 | Task 3 | x |  | x |  | Task 6 | Task 10 | Task 8
 | Task 4 |  | x |  |  | Task 8
 | Task 5 |  |  |  |  | Task 9
 | Task 6 | x |  | x |  | Task 10
 | Task 7 |  | x
 | Task 8 | x |  | x
 | Task 9 | x
 | Task 10 | x | x
 | Here is an example data set that is formatted as a task list matrix by exam type. Each "x" suggests the task is relevant to that exam |  |  |  |  | Here is the expected result, whereby each task relevant to the given exam is listed in alphabetical order
Spreadsheet: 64952d1265748040-if-or-formula-book2
Sheet: Sheet1

Name | StartDate | EndDate | 2010-01-10 00:00:00 | 2010-02-10 00:00:00 | 2010-03-10 00:00:00
[NAME] | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 | 1 | 1 | 1
**** | 2010-02-02 00:00:00 | 2010-10-31 00:00:00 | 0 | 1 | 1
[NAME] | 2010-03-15 00:00:00 | 2010-12-01 00:00:00 | 0 | 0 | 0
Spreadsheet: 88976d1288785019-2nd-instance-of-vlookup-book84
Sheet: Sheet2

 |  | USX | 0.4696320155459051 | 0.09623523734334638 | 0.08337836806681187 | 0.1563734699086441 | 0.1407093733760911 | 0.4810512268634164 | 0.876009142842274 | 0.365152885577716 | 0.7167439121143395
 |  | USX | 0.4315554741395764 | 0.5022673066199488 | 0.05820651383575681 | 0.4033255759798737 | 0.2641785424572061 | 0.04327503045400327 | 0.4016472421540516 | 0.6936832964243156 | 0.3185846642662276
 |  | USX | 0.1956449047154782 | 0.3558504153780764 | 0.8363740393310568 | 0.298577100260057 | 0.8256825203420242 | 0.3032591123228006 | 0.9435540836935326 | 0.5350602478846653 | 0.209193118384758
 |  | USX | 0.889182496177713 | 0.5791357881955623 | 0.2802955371715337 | 0.2937310768936063 | 0.4243859524140845 | 0.9843812981158155 | 0.5814299499744902 | 0.7570672163957937 | 0.3974375204340659
 |  | USX | 0.7231443444548284 | 0.2301605942482956 | 0.2306161854116264 | 0.1164590800170293 | 0.1215491178646073 | 0.463544911996923 | 0.3843096486683504 | 0.1038687066378035 | 0.7959334275110612
 |  | USX | 0.2805011398281652 | 0.3686280829162936 | 0.006744022006338835 | 0.7508315093414337 | 0.4620269918611435 | 0.9233729759743563 | 0.2411317274406131 | 0.3326176376873136
 |  | USX | TYPE | 0.5186295824501634 | 0.9045029591647422 | 0.01787877038429286 | 0.5277165607861993 | LEVEL
 |  | USX | ALPHA | 0.02398346565417642 | 0.1106956408331057 | 0.9547915082802767 |  | 0.14788
 |  | USX | BRAVO | 0.9420461068223596 | 0.8655229718794035 | 0.4734006955967021 |  | 0
 |  | USX | ALPHA | 0.4514914057219039 | 0.8818662852340244 | 0.1285912006088756 |  | 100.70198
 |  | USX | BRAVO | 0.2892500333607182 | 0.8956254058556348 | 0.01576022203396921 |  | -98.86047
 |  | What [NAME] gives me |  | 0
 |  | What I want back: |  | -98.86047
 |  | Range name:  USXDEETS
 |  | Folks a little help please.  See the attached .xls.
 |  | I'm trying to figure out how to vlookup the 2nd instance of something. (BRAVO in my .xls)
 |  | There's a defined range, but no real way to use "C20" or "C30" since there's a variable (500-700) number of rows above each day.
 |  | I THINK there's a way to use MATCH, OFFSETS, INDEX… but I'm stuck.
 |  | Any help would be greatly appreciated!!!
Spreadsheet: 167790d1342104749-cut-and-paste-calculation-example-excel-file
Sheet: Ingredient

compoundID | Ingredient name | amount | Required (y)
1 | Ingredient #1 | 25gm
1 | Ingredient #2 | 10gm | y
1 | Ingredient #3 | 30gm
2 | Ingredient #4 | 50gm | y
2 | Ingredient #5 | 100gm
3 | Ingredient #6 | 20gm
3 | Ingredient #7 | 35gm
3 | Ingredient #8 | 40gm
3 | Ingredient #9 | 70gm | y
Spreadsheet: 86324d1286332297-excel-2007-working-with-charts-and-missing-data-example1
Sheet: Chart

PPC
VentingDirect | Aug 2010 | Sep 2010 | Oct 2010 | Nov 2010 | Dec 2010 | Jan 2011 | Feb 2011 | Mar 2011 | Apr 2011 | May 2011 | Jun 2011 | Jul 2011 | Totals
F11 PPC Rev |  |  |  |  |  |  |  |  |  |  |  |  | 14.53697112246901
 | =SUMPRODUCT(--(Table1[Site]=Chart!$A$2),--(Table1[Date]=Chart!B$2),--(Table1[Channel]=Chart!$A$1),Table1[Revenue])
Example
Spreadsheet: 61639d1262589539-combined-and-summary-712593-combined-and-summary
Sheet: Sales Details

Company Sales Details |  |  |  |  | Sum of Amount | Delivery Date
 |  |  |  |  | Customer Name | 1/01/2010 - 7/01/2010 | 8/01/2010 - 14/01/2010 | 15/01/2010 - 21/01/2010 | 22/01/2010 - 28/01/2010 | 29/01/2010 - 1/02/2010 | Grand Total
Customer Name | Delivery Number | Delivery Date | Amount |  | LKT Co., Ltd | 250 | 630 |  |  |  | 880
WZT Technology | AVT-S0001 | 2010-01-01 00:00:00 | 500 |  | Titanic Trading |  |  | 100 | 500 | 1410 | 2010
LKT Co., Ltd | AVT-S0002 | 2010-01-07 00:00:00 | 250 |  | WZT Technology | 500 |  | 200 | 400 |  | 1100
LKT Co., Ltd | AVT-S0003 | 2010-01-08 00:00:00 | 300 |  | Grand Total | 750 | 630 | 300 | 900 | 1410 | 3990
LKT Co., Ltd | AVT-S0004 | 2010-01-09 00:00:00 | 330
WZT Technology | AVT-S0005 | 2010-01-18 00:00:00 | 200
Titanic Trading | AVT-S0006 | 2010-01-18 00:00:00 | 100
WZT Technology | AVT-S0007 | 2010-01-22 00:00:00 | 400
Titanic Trading | AVT-S0008 | 2010-01-23 00:00:00 | 500
Titanic Trading | AVT-S0009 | 2010-01-30 00:00:00 | 700
Titanic Trading | AVT-S0010 | 2010-01-31 00:00:00 | 710
Spreadsheet: 801706d1666332082-formula-to-calculate-leave-as-per-custom-start-and-end-date-of-the-month-network
Sheet: Network

Name | Start Date | End Date | Days | Paid | NETWORKDAYS.INTL | Expected Excluding Saturdays and Sundays
Employee1 | 2022-07-05 00:00:00 | 2022-07-05 00:00:00 | 1 | 0.5
Employee2 | 2022-06-24 00:00:00 | 2022-06-24 00:00:00 | 1 | 0.5 |  |  |  | Start Date | 21st of Month
Employee3 | 2022-07-08 00:00:00 | 2022-07-22 00:00:00 | 15 | 11 |  | 9 |  | End Date | 20th of Month
Employee3 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | 1 | 0.5
Employee3 | 2022-06-24 00:00:00 | 2022-06-24 00:00:00 | 1 | 1
Employee4 | 2022-06-29 00:00:00 | 2022-06-29 00:00:00 | 1 | 1
Employee4 | 2022-06-30 00:00:00 | 2022-06-30 00:00:00 | 1 | 0.5
Employee5 | 2022-06-20 00:00:00 | 2022-06-23 00:00:00 | 4 | 4
Employee5 | 2022-06-24 00:00:00 | 2022-06-27 00:00:00 | 4 | 2
Employee5 | 2022-06-28 00:00:00 | 2022-06-30 00:00:00 | 3 | 3
Employee5 | 2022-07-01 00:00:00 | 2022-07-05 00:00:00 | 5 | 3
Employee6 | 2022-06-30 00:00:00 | 2022-06-30 00:00:00 | 1 | 0.5
Employee7 | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 | 5 | 5
Employee7 | 2022-07-11 00:00:00 | 2022-07-15 00:00:00 | 5 | 5
Employee7 | 2022-07-18 00:00:00 | 2022-07-22 00:00:00 | 5 | 5 |  | 3
Employee7 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | 1 | 0.5
Employee7 | 2022-06-24 00:00:00 | 2022-06-24 00:00:00 | 1 | 1
Employee7 | 2022-06-27 00:00:00 | 2022-07-01 00:00:00 | 5 | 5
Employee8 | 2022-07-07 00:00:00 | 2022-07-08 00:00:00 | 2 | 2
Employee8 | 2022-07-13 00:00:00 | 2022-07-15 00:00:00 | 3 | 3
Employee8 | 2022-07-18 00:00:00 | 2022-07-18 00:00:00 | 1 | 0.5
Employee8 | 2022-07-19 00:00:00 | 2022-07-28 00:00:00 | 10 | 8 |  | 2
Employee8 | 2022-07-18 00:00:00 | 2022-07-18 00:00:00 | 1 | 0.5
Employee9 | 2022-06-29 00:00:00 | 2022-06-29 00:00:00 | 1 | 0.5
Employee10 | 2022-05-30 00:00:00 | 2022-07-20 00:00:00 | 52 | 52
Employee11 | 2022-06-20 00:00:00 | 2022-06-23 00:00:00 | 4 | 4
Employee11 | 2022-06-24 00:00:00 | 2022-07-01 00:00:00 | 8 | 6
Employee12 | 2022-06-20 00:00:00 | 2022-06-24 00:00:00 | 5 | 5 |  | 1
Employee13 | 2022-06-27 00:00:00 | 2022-07-01 00:00:00 | 5 | 5
Employee14 | 2022-06-27 00:00:00 | 2022-06-27 00:00:00 | 1 | 1
Employee15 | 2022-06-16 00:00:00 | 2022-07-01 00:00:00 | 16 | 12
Employee16 | 2022-07-01 00:00:00 | 2022-07-12 00:00:00 | 12 | 8
Employee17 | 2022-07-11 00:00:00 | 2022-07-22 00:00:00 | 12 | 10 |  | 8
Employee18 | 2022-06-20 00:00:00 | 2022-06-21 00:00:00 | 2 | 2
Employee18 | 2022-06-27 00:00:00 | 2022-06-28 00:00:00 | 2 | 2
Employee18 | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 | 2 | 2
Employee19 | 2022-06-20 00:00:00 | 2022-06-23 00:00:00 | 4 | 4 |  | 1
Employee19 | 2022-07-18 00:00:00 | 2022-07-22 00:00:00 | 5 | 5 |  | 2
Employee20 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 1 | 1
Spreadsheet: 272157d1382239323-need-to-extrapolate-data-in-column-b-if-cells-column-a-contains-same-string-web-address-markadoi84-201013
Sheet: Sheet1

Urls |  | search 1st "/" | formula | array formula without column help
www.excelforum.com/excel-formulas-and-functions/1.html
www.excelforum.com/excel-formulas-and-functions/
www.google.com
www.yahoo.com
www.mrexcel.com
www.office.microsoft.com/en-001/excel‎
Spreadsheet: 216820d1361899884-help-with-nested-vlookup-function-to-calculate-estimated-annual-insurance-premium-ckg-operating-costs
Sheet: Estimate Form

Car Operating Cost Estimate Form
Data Inputs
Expected number of drving miles per year: |  |  |  |  |  |  | 25000
Type of driving: |  |  |  |  |  |  | Mixed
Purchaser's state: |  |  |  |  |  |  | IL
Purchaser's residential status: |  |  |  |  |  |  | Suburban
Purchaser's driving safety record: |  |  |  |  |  |  | Average
Gas price adjustment percentage" |  |  |  |  |  |  | 1.13
Model # | Make | Description | # [NAME] | Gas $/yr | Insurance $/yr | Avg. Maint. $/yr | Annual Operating Costs
1 |  |  | 4
4 |  |  | 6
5 |  |  | 8
7 |  |  | Turbo