tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854928d1704691923-extract-total-of-a-column-from-specified-period-data
Sheet: PT Date

Date | ([NAME])
Coluna2 | Coluna3 | Coluna4 | Number
apr rent | SBI | Global1 | 6534
dec22 rent | SBI | Global GF | 11000
feb rent | idbi | Capital Mall | 16415
feb rent | Maintenanace | Capital Mall | 2000
feb rent | Tax | Capital Mall | 1000
JAN23 RENT | SBI | Global GF | 11000
jul rent | Capital Mall | Rental Income | 18863
jul rent | Global 2 | Rental Income | 5400
jul rent | Global 3 | Rental Income | 6500
jul rent | Global GF | Rental Income | 11000
jul rent | Global1 | Rental Income | 6534
jul rent | Major | Rental Income | 8124
jul rent | Selfi | Rental Income | 16500
jul rent | Tax | Major | 624
jul rent | Thanal | Rental Income | 1800
jun rent | Capital Mall | Rental Income | 19690
jun rent | Global 2 | Rental Income | 5400
jun rent | Global 3 | Rental Income | 6500
jun rent | Global GF | Rental Income | 11000
jun rent | Global1 | Rental Income | 6534
jun rent | Major | Rental Income | 8124
jun rent | Selfi | Rental Income | 16500
jun rent | Tax | Major | 624
jun rent | Thanal | Rental Income | 1800
[NAME] rent | idbi | Capital Mall | 15058
[NAME] rent | Maintenanace | Capital Mall | 2000
[NAME] rent | Tax | Capital Mall | 2547
may rent | idbi | Thanal | 1800
may rent | SBI | Global 2 | 5400
may rent | SBI | Global 3 | 6500
may rent | SBI | Global1 | 6534
may rent | SBI | Selfi | 16500
nov 22 rent | SBI | Global GF | 11000
Spreadsheet: 760236d1640095374-vlookup-returning-n-a-solutions-online-not-working-vlookupfail
Sheet: Sheet1

Name | Session | Result |  | Passes (Hidden) | Passes
[NAME] | 12345 | Pass
Paulie | 45678 | Pass |  |  |  | 45678
Freddo | 99999 | Fail |  |  |  | 15667
Sandy | 15667 | Pass |  |  |  | 11111
[NAME] | 33333 | Fail
Stevey | 11111 | Pass
Djorno | 98765 | Fail
Spreadsheet: 791533d1660416467-sum-two-cells-one-has-text-one-has-a-number-returns-vaule-teest
Sheet: Sheet1

Solve #Value! In column E when on of the items being added is text
X | Result 1 | x2 | Result 2 | Sum of results
1 |  | 3
No R |  | 3
3 |  | 1
1 |  | No R
Expected result
X | Result 1 | x2 | Result 2 | Sum of results
1 |  | 3
No R |  | 3 |  | 0.3
3 |  | 1
1 |  | No R |  | 0.5
Spreadsheet: 718119d1612991007-drop-down-lists-and-choosing-from-a-table-sample-project
Sheet: ROM Tool

BDA VENDOR: |  | [NAME]
BDA WATTAGE: |  | .5 W |  |  |  |  | 20 |  |  |  | MARGIN: | 0
TYPE OF VENUE: |  | Other |  |  |  |  | 19 |  |  |  | Additional: | 1000
SYSTEM TYPE: |  | 700 |  |  |  |  | 18
FIBER NEEDED: |  | Choose One |  |  |  |  | 17
# OF BUILDINGS: |  | 0 |  |  |  |  | 16
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 13
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 4 | 25000
 |  |  |  |  |  |  | 3 | 20000
 |  |  |  |  |  |  | 2 | 20000
 |  |  |  |  |  |  | 1 | 20000
TOTAL PRICE: |  |  | 0 |  | TOTAL SQ. FOOTAGE:
TOTAL PRICE (w/ Margin) |  |  | 0
Spreadsheet: 700901d1603392641-researching-formula-value-copy
Sheet: z

 | 3rd | < 10000€ Month | B2
 |  |  | -0.2 | -0.15 | -0.1 | -0.05 | 0 | 0.05 | 0.1 | 0.15 | 0.2
 | C2 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150
 |  | -0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 150
 |  | -0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 150 | 750
 |  | -0.05 | 0 | 0 | 0 | 150 | 150 | 150 | 750 | 1500 | 1500
 |  | 0 | 0 | 0 | 150 | 150 | 150 | 750 | 1500 | 1500 | 7500
 |  | 0.05 | 0 | 150 | 150 | 150 | 750 | 1500 | 1500 | 7500 | 7500
 |  | 0.1 | 150 | 150 | 150 | 750 | 1500 | 1500 | 7500 | 7500 | 7500
 |  | 0.15 | 150 | 150 | 750 | 1500 | 1500 | 7500 | 7500 | 7500 | 7500
 |  | 0.2 | 150 | 750 | 1500 | 1500 | 7500 | 7500 | 7500 | 7500 | 7500
 | 2nd |  | B2
 |  |  | -0.2 | -0.15 | -0.1 | -0.05 | 0 | 0.05 | 0.1 | 0.15 | 0.2
 | C2 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | -0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 425 | 425
 |  | -0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 425 | 425 | 2125
 |  | -0.05 | 0 | 0 | 0 | 425 | 425 | 425 | 2125 | 4250 | 4250
 |  | 0 | 0 | 0 | 425 | 425 | 425 | 2125 | 4250 | 4250 | 21250
 |  | 0.05 | 0 | 425 | 425 | 425 | 2125 | 4250 | 4250 | 21250 | 21250
 |  | 0.1 | 425 | 425 | 425 | 2125 | 4250 | 4250 | 21250 | 21250 | 21250
 |  | 0.15 | 425 | 425 | 2125 | 4250 | 4250 | 21250 | 21250 | 21250 | 21250
 |  | 0.2 | 425 | 2125 | 4250 | 4250 | 21250 | 21250 | 21250 | 21250 | 21250
 | 1st |  | B2
 |  |  | -0.2 | -0.15 | -0.1 | -0.05 | 0 | 0.05 | 0.1 | 0.15 | 0.2
 | C2 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1140
 |  | -0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1140 | 1140
 |  | -0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 1140 | 1140 | 5700
 |  | -0.05 | 0 | 0 | 0 | 1140 | 1140 | 1140 | 5700 | 11400 | 11400
 |  | 0 | 0 | 0 | 1140 | 1140 | 1140 | 5700 | 11400 | 11400 | 57000
 |  | 0.05 | 0 | 1140 | 1140 | 1140 | 5700 | 11400 | 11400 | 57000 | 57000
 |  | 0.1 | 1140 | 1140 | 1140 | 5700 | 11400 | 11400 | 57000 | 57000 | 57000
 |  | 0.15 | 1140 | 1140 | 5700 | 11400 | 11400 | 57000 | 57000 | 57000 | 57000
 |  | 0.2 | 1140 | 5700 | 11400 | 11400 | 57000 | 57000 | 57000 | 57000 | 57000
Spreadsheet: 701522d1603801193-index-match-giving-n-a-test_index_match
Sheet: test

ID | Week | Query
2012 | 2 | 500
2013 | 1 | 5
2014 | 2 | 2
2015 | 2 | 4
2016 | 2 | 8
2017 | 2 | 5
2012 | 4 | 600
2019 | 2 | 7
2020 | 2 | 3
2021 | 2 | 0
2022 | 2 | 3
Spreadsheet: jeffrey_a_shankman__13918__Pick Sheet - Week 17
Sheet: Sample week

NFL PICKS OF THE WEEK - 2001
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO:   E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
SAMPLE WEEK 1 - First Game is Sunday @ 10 a.m.
Sunday, September 9
 |  | Visitor |  |  |  | Home
 | 8 | New Orleans Saints |  |  |  | Buffalo Bills
 |  | New England Patriots |  |  | 13 | Cincinnati Bengals
 | 2 | [NAME] |  |  |  | [NAME]
 |  | Tampa Bay Buccaneers |  |  | 7 | Dallas Cowboys
 |  | Detroit Lions |  |  | 5 | Green Bay Packers
 |  | Oakland Raiders |  |  | 15 | Kansas City Chiefs
 | 6 | Carolina Panthers |  |  |  | Minnesota Vikings
 | 14 | Indianapolis Colts |  |  |  | New York Jets
 |  | Pittsburgh Steelers |  |  | 9 | [NAME]
 |  | Chicago Bears |  |  | 3 | Baltimore Ravens
 | 4 | St. Louis Rams |  |  |  | Philadelphia Eagles
 | 11 | Washington Redskins |  |  |  | San Diego Chargers
 |  | Atlanta Falcons |  |  | 10 | San Francisco 49er's
 | 1 | [NAME] |  |  |  | Tennesee Titans
Monday, September 4
 | 12 | New York Giants |  |  |  | Denver Broncos
Tiebreaker |  | 43 |  | Total |  |  | Total should = 120
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | Arizona Cardinals
Spreadsheet: 868658d1715335362-work-time-difference-between-two-dates-with-conditions-work-time
Sheet: Folha1

Process | Cliente | Ref | Start date | Origin | End Date | Destination | Vehicle | Pax | Driver | Contract | Price | Corrected Start Hour | Corrected End Hour | Time work | Daily Hours
 |  |  | 09/05/2024 03:30:00 |  | 09/05/2024 04:30:00 |  |  | 2 | [NAME] |  |  | 03:30:00 | 04:30:00
 |  |  | 09/05/2024 05:00:00 |  | 09/05/2024 06:00:00 |  |  | 2 | Sonia Amaral
 |  |  | 09/05/2024 06:15:00 |  | 09/05/2024 07:30:00 |  |  | 4 | [NAME] |  |  | 06:15:00 | 07:30:00
 |  |  | 09/05/2024 [NAME] |  | 09/05/2024 07:30:00 |  |  | 2 | Sonia Amaral
 |  |  | 09/05/2024 08:50:00 |  | 09/05/2024 10:30:00 |  |  | 6 | [NAME] |  |  | 08:50:00 | 11:00:00
 |  |  | 09/05/2024 09:45:00 |  | 09/05/2024 16:30:00 |  |  | 4 | Sonia Amaral
 |  |  | 10/05/2024 10:45:00 |  | 10/05/2024 11:45:00 |  |  | 6 | [NAME] |  |  | 10:45:00 | 13:00:00
Total
Spreadsheet: 798917d1664811941-what-formula-to-use-for-summary-data-ot-2-
Sheet: 95A

 |  | SEPTEMBER |  |  | North OT:
 | CALENDAR YEAR | CALENDAR MONTH
 |  |  |  |  |  |  |  |  | Monday
 |  |  |  |  | [NAME] |  |  | a/b
 |  | Noel/Dave |  |  |  | [NAME] |  | a/b
 |  |  |  |  | fred | gfds |  | a/b
 |  |  |  |  |  |  |  | a/b
 |  |  |  |  |  |  |  | a/b
 |  |  |  |  |  |  |  | a/b
Spreadsheet: 695283d1600129531-vlookup-based-on-the-results-exam-vlookup-formula
Sheet: Sheet1

STUDENT RESULT EXAM 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRITERIA CLASS 2021
NO | NAME | MATH |  | SCIENCE |  | ART |  | ECONOMIC |  | COMPUTER |  | BIOLOGY |  | PHYSIC |  | CHEMISTRY |  | CLASS 2021 |  |  | CLASS |  | SUBJECT |  | MINIMUM GRED
 |  | SCORE | GRED | SCORE | GRED | SCORE | GRED | SCORE | GRED | SCORE | GRED | SCORE | GRED | SCORE | GRED | SCORE | GRED |  |  |  | SCIENCE STREAM |  | MATH |  | A
1 | CALVIN | 100 | A | 80 | A | 70 | B | 40 | D | 65 | C | 95 | A | 83 | A | 67 | A | SCIENCE STREAM |  |  |  |  | PHYSIC |  | B
2 | [NAME] | 63 | C | 60 | C | 85 | A | 60 | C | 85 | A | 87 | A | 85 | A | 68 | C |  |  |  |  |  | BIOLOGY |  | B
3 | [NAME] | 54 | D | 75 | B | 80 | B | 69 | C | 83 | B | 88 | A | 85 | A | 80 | B |  |  |  |  |  | CHEMISTRY |  | A
4 | ANTHONY | 77 | B | 65 | C | 85 | A | 70 | B | 76 | B | 85 | A | 86 | A | 72 | B |  |  |  |  |  | COMPUTER |  | C
5 | [NAME] | 80 | B | 85 | A | 90 | A | 91 | A | 62 | C | 76 | B | 72 | B | 57 | D |  |  |  | ECONOMY |  | MATH |  | B
6 | WILLIAM | 65 | C | 91 | A | 81 | B | 79 | B | 57 | D | 71 | B | 85 | A | 67 | C |  |  |  |  |  | SCIENCE |  | C
7 | BENJAMIN | 70 | B | 87 | A | 83 | B | 85 | A | 65 | C | 63 | C | 77 | B | 57 | D |  |  |  |  |  | ECONOMIC |  | A
8 | ISABELLA | 65 | C | 87 | A | 78 | B | 85 | A | 62 | C | 62 | C | 75 | B | 67 | C |  |  |  |  |  | ART |  | C
9 | AMELIA | 85 | A | 92 | A | 82 | B | 80 | B | 65 | C | 66 | C | 80 | B | 55 | D |  |  |  |  |  | COMPUTER |  | B
10 | MIA | 88 | A | 97 | A | 80 | B | 90 | A | 60 | C | 65 | C | 75 | B | 60 | C |  |  |  | LITERATURE |  | ART |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCIENCE |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPUTER |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATH |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHYSIC |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ART |  | ART |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCIENCE |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATH |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMPUTER |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ECONOMIC |  | B
Spreadsheet: 79e44ba7-3313-4307-9610-710e23889160
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6772 | 50276 | [NAME] | [NAME] | PAN | 0 | 00:33:04 | 00:01:46 | 04:10:07 | 00:00:44 | 02:14:36 | 1 | 07:00:20
Spreadsheet: 682162d1591941159-strange-hyperlink-behaviour-test
Sheet: Sheet1

File name 1
File name 2
File name 3
File name 4
File name 5
File name 6
File name 7
File name 8
File name 9
File name 10
File name 11
temp_pdf_file | C:\Documents and Settings\Administrator\My Documents\My Pictures\
Spreadsheet: 698274d1601899957-how-to-compute-yes-or-no-variance-per-line-item-variance-per-line-item
Sheet: Per line item variance (3)

 | Expected results | QA Benchmark | [NAME] | [NAME] | QA4 | QA5 | [NAME]
Question 1 | 5 | 5 | 0 | 5 | 0 | 5
Question 2 | 5 | 5 | 5 | 5 | 0 | 5
Question 3 | 5 | 5 | 5 | 5 | 0 | 5
Question 4 | 5 | 5 | 5 | 5 | 0 | 5
Question 5 | 5 | 5 | 5 | 5 | 0 | 5
Question 6 | 5 | 5 | 5 | 5 | 0 | 5
Question 7 | 5 | 5 | 5 | 5 | 0 | 5
Question 8 | 5 | 5 | 5 | 5 | 0 | 5
Question 9 | 5 | 5 | 5 | 0 | 0 | 5
Question 10 | 2 | 2 | 2 | 2 | 2 | 2
Question 11 | 2 | 2 | 2 | 0 | 2 | 2
Question 12 | 2 | 2 | 2 | 2 | 2 | 2
Question 13 | 2 | 2 | 2 | 2 | 2 | 2
Question 14 | 2 | 2 | 2 | 2 | 2 | 2
Question 15 | 2 | 2 | 2 | 2 | 2 | 2
Question 16 | 2 | 2 | 2 | 2 | 2 | 2
Question 17 | 2 | 2 | 2 | 2 | 2 | 2
Question 18 | 2 | 2 | 2 | 2 | 2 | 2
Question 19 | 2 | 2 | 2 | 2 | 2 | 2
Question 20 | 2 | 2 | 2 | 0 | 2 | 2
Question 21 | 5 | 5 | 5 | 5 | 5 | 5
Question 22 | 10 | 10 | 10 | 10 | 10 | 10
Question 23 | 5 | 5 | 5 | 5 | 5 | 5
Question 24 | 5 | 5 | 5 | 5 | 5 | 5
Question 25 | 5 | 5 | 5 | 5 | 5 | 5
Question 26 | 5 | 5 | 5 | 5 | 5 | 5
Question 27 | 2 | 2 | 0 | 2 | 2 | 0
Spreadsheet: 136372d1326581395-vlookup-multiple-criteria-samplecalldata
Sheet: CallData

ID | PhoneNumber | ConnectedDateTime
1 | 1231231234 | 2012-12-01 09:08:00
2 | 9879879876 | 2012-12-01 00:00:00
3 | 1211211234 | 2012-01-01 08:04:00
4 | 1231232345 | 2012-01-05 21:00:00
5 | 9879878765 | 2012-01-03 21:09:00
6 | 1211212345 | 2011-12-11 21:00:00
7 | 1231233456 | 2012-01-01 09:04:00
8 | 1231233456 | 2011-12-03 21:19:00
 | 1231233456 | 2012-01-03 09:02:00
Spreadsheet: 525773d1498895468-drop-down-list-based-on-the-given-file-how-to-create-such-helpful-and-neat-list-excel_forum_qus
Sheet: YearlyReport

Yearly Income & Expense Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructions
 |  |  |  |  |  |  | For Year Beginning |  |  |  |  |  |  |  |  | ◄ Update the Start Date if desired
Starting Balance | 2964 |  |  |  |  |  |  |  |  |  |  | [42] | Total | Avg |  | ◄ Update the Starting Balance
Total Income
Total Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This worksheet creates an income and expense
NET (Income - Expenses) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | report from the data in the Transactions worksheet.
End Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | If customizing budget categories, you will need to
 |  |  |  |  |  |  |  |  |  |  |  |  | Total | Average |  | make the categories match the other worksheets.
Date Begin
Date End
INCOME
Wages & Tips
Interest Income
Dividends
[NAME]
Refunds/Reimbursements
Financial Aid
Rental Income
INCOME-Other
TO SAVINGS
Emergency Fund
Retirement Fund
College Fund
Investments
Taxes
Vacation Fund
SAVINGS -Other
% of Income
CHARITY/GIFTS
Tithing
Charitable Donations
Religious Donations
Gifts
Christmas
CHARITY - Other
% of Income
HOUSING
Mortgage/Rent
Home/Rental Insurance
Real Estate Taxes
Furnishings/Appliances
Lawn/Garden
Maintenance/Supplies
Improvements
HOUSING - Other
% of Income
UTILITIES
Electricity
Gas/Oil
Water/Sewer/Trash
Phone
Cable/Satellite
Internet
UTILITIES - Other
% of Income
FOOD
Groceries
Dining/Eating Out
Pet Food
FOOD - Other
% of Income
TRANSPORTATION
Vehicle Payments
Auto Insurance
Fuel
Bus/Taxi/Train Fare
Repairs/Tires
Registration/License
TRANSPORTATION - Other
% of Income
HEALTH
Health Insurance
Disability Insurance
Doctor/Dentist/Optometrist
Medicine/Drugs
Health Club Dues
Life Insurance
Veterinarian/Pet Care
HEALTH - Other
% of Income
DAILY LIVING
Education
Clothing
Personal Supplies
Cleaning Services
Laundry / Dry Cleaning
Salon/Barber
DAILY LIVING - Other
% of Income
CHILDREN
Children:Clothing
Medical
Music Lessons
School Tuition
School Lunch
School Supplies
Babysitting/Child Care
Toys/Games
CHILDREN - Other
% of Income
OBLIGATIONS
Student Loan
Other Loan
Credit Card #1
Credit Card #2
Credit Card #3
Alimony/Child Support
Federal Taxes
State/Local Taxes
Legal Fees
OBLIGATIONS - Other
% of Income
BUSINESS EXPENSE
Deductible Expenses
Non-Deductible Expenses
BUSINESS - Other
% of Income
ENTERTAINMENT
Vacation/Travel
Videos/DVDs
Music
Games
Rentals
Movies/Theater
Concerts/Plays
Books
Hobbies
Film/Photos
Sports
Outdoor Recreation
Toys/Gadgets
ENTERTAINMENT - Other
% of Income
SUBSCRIPTIONS
Newspaper
Magazines
Dues/Memberships
SUBSCRIPTIONS - Other
% of Income
[NAME]
Bank Fees
Postage
MISC - Other
% of Income
Spreadsheet: 149457d1333980328-need-function-to-compare-cells-ranges-arun22_need-function-to-compare-cellsranges_08apr12_02
Sheet: Sheet1

name | joining date 1 | birthdate 1 | joiningdate 2 | birthdate 2 | date1 | date2 | Result
arun | 2005-06-09 00:00:00 | 1985-05-10 00:00:00 | 2003-04-09 00:00:00 | 1984-04-10 00:00:00
rajesh | 2003-04-09 00:00:00 | 1984-04-10 00:00:00 | 2005-06-09 00:00:00 | 1985-05-10 00:00:00
tweedledee | 2012-04-08 00:00:00 | 2012-04-08 00:00:00 | 1947-08-15 00:00:00 | 1950-01-26 00:00:00
tweedledum | 1947-08-15 00:00:00 | 1950-01-26 00:00:00 | 1964-10-15 00:00:00 | 1998-05-11 00:00:00
humptydumpty | 1964-10-15 00:00:00 | 1998-05-11 00:00:00 | 2012-04-08 00:00:00 | 2012-04-08 00:00:00
[NAME] | 2012-04-09 00:00:00 | 2012-04-09 00:00:00 | 2012-04-23 00:00:00 | 2012-06-03 00:00:00
bat man | 2012-04-23 00:00:00 | 2012-06-03 00:00:00 | 2012-04-09 00:00:00 | 2012-04-09 00:00:00
Spreadsheet: 804911d1668434255-normalizing-dates-sample_date_file_111422-hd
Sheet: Sample

Account Number | Account Description | Payee | Transaction Description | Cost Center | Date | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Date | Desired Outcome
1 | Some Account | Unassigned | Sample 1 | Some Cost 1 | 31 |  |  | 1620734
1 | Some Account | Unassigned | Sample 2 | Some Cost 2 | 1 |  |  |  | -1620734 |  |  |  |  |  |  | 2022-04-01 00:00:00
1 | Some Account | Unassigned | Sample 3 | Some Cost 3 | 30 |  |  |  |  |  | 3516783 |  |  |  |  | 2022-06-30 00:00:00
1 | Some Account | Unassigned | Sample 4 | Some Cost 4 | 1 |  |  |  |  |  |  | -3516783 |  |  |  | 2022-07-01 00:00:00
1 | Some Account | Unassigned | Sample 5 | Some Cost 5 | 30 |  |  |  |  |  |  |  |  | 4697089 |  | 2022-09-30 00:00:00
1 | Some Account | Unassigned | Sample 6 | Some Cost 6 | 30 |  |  |  |  |  |  |  |  | 233275 |  | 2022-09-30 00:00:00
1 | Some Account | Unassigned | Sample 7 | Some Cost 7 | 8 |  | -500 |  |  |  |  |  |  |  |  | 2022-02-08 00:00:00
Spreadsheet: john_griffith__15593__New Preston VPP Calculation 11-30
Sheet: Sheet1

 |  | Month Lag |  |  |  | Pricing Date | 2000-11-30 00:00:00 | Mid-day for oil and gas
 |  | 1
PRESTON EXPLORATION |  |  |  |  |  | Price Adjustments |  |  |  | Gas Swap Price | 4.7
VPP Evaluation |  |  |  |  |  |  | Gas | Oil |  |  |  |  |  | Libor | Plus | Total
 |  |  |  |  |  | Basis | -0.035 | -1.25 |  |  |  |  | Pre-synd. Disc. Rate | 670 | 380
 |  |  |  |  |  | Premium | 0.0025 | 0 |  |  |  |  | Post-synd. Disc. Rate |  | 135
 |  |  |  |  |  | Total |  |  |  |  |  |  | Preston's Disc Rate |  | 480
 |  |  |  |  |  |  |  |  |  |  |  |  | Structuring Fee |  |  | 0.0125
 | Production Month | Month Production Received | Oil (Bbls) | Gas (MMBtu) |  | Bid Oil Price ($/Bbl) | Bid Gas Price ($/MMBtu) |  | Oil Cash Flows ($) | Gas Cash Flows ($) | Total Cash Flows ($)
Funding Date | 2000-12-08 00:00:00 |  |  | 0 |  |  |  |  |  |  |  |  | XNPV |  | at Preston's Discount Rate
 | 2000-12-25 00:00:00 |  | 16740 | 300700 |  | 33.42 | 6.016
 |  |  | 17050 | 322710 |  | 32.48 |  |  |  |  |  |  | XNPV |  | at Pre-syndication Discount Rate
 |  |  | 16800 | 321440 |  | 31.55 |  |  |  |  |  |  | Structuring Fee
 |  |  | 16430 | 320385 |  | 30.64 |  |  |  |  |  |  | Interest Rate Spread
 |  |  | 16200 | 319200 |  | 29.92 |  |  |  |  |  |  | Total Profit
 |  |  | 15975.95519264817 | 318060 |  | 29.26
 |  |  | 15750 | 316950 |  | 28.62 |  |  |  |  |  |  | XNPV |  | at Post-syndication Discount Rate
 |  |  | 15500 | 313100 |  | 28.11 |  |  |  |  |  |  | Structuring Fee
 |  |  | 15035 | 306900 |  | 27.63 |  |  |  |  |  |  | Interest Rate Spread
 |  |  | 14700 | 301350 |  | 27.23 |  |  |  |  |  |  | Total Profit
 |  |  | 14415 | 296205 |  | 26.83
 |  |  | 14100 | 291300 |  | 26.39
 |  |  | 13950 | 286905 |  | 26.03
 |  |  | 13485 | 282875 |  | 25.7
 |  |  | 13300 | 279160 |  | 25.39
 |  |  | 13020 | 275745 |  | 25.12
 |  |  | 12900 | 272550 |  | 24.92
 |  |  | 12710 | 269545 |  | 24.75
 |  |  | 12450 | 266850 |  | 24.61
 |  |  | 12400 | 263500 |  | 24.45
 |  |  | 12090 | 252650 |  | 24.3
 |  |  | 13350 | 267300 |  | 24.17
 |  |  | 13175 | 264895 |  | 24.03
 |  |  | 12900 | 262500 |  | 23.88
 |  |  | 12710 | 260400 |  | 23.75
 |  |  | 11935 | 254355 |  | 23.59
 |  |  | 11200 | 236180 |  | 23.47
 |  |  | 10075 | 227230 |  | 23.34
 |  |  | 9000 | 218400 |  | 23.21
 |  |  | 8370 | 210490 |  | 23.1
 |  |  | 7500 | 203250 |  | 23.01
 | Total
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Funeral Services

FUNERAL SERVICES
Associate in Applied Science
Student Name:
ID #
General Education and Support Courses | Semester | Grade
___ ENG 101 (3) Writing I
___ CIT 105 (3) Introduction to Computers OR IC3 Computer Literacy Exam
___ MAT 110 (3) Applied Mathematics OR ___ MAT 146 Contemporary College Mathematics
OR ___ Higher level mathematics course
___ Oral Communications (3)
___ Heritage/Humanities Course (3)
___ PSY 110 (3) General Psychology OR ___ SOC 101 (3) Intorduction to Sociology
___ BIO 135 (4) Basic Anatomy & Physiology with Lab
___ BIO 225 (4) Medical Microbiology
___ ACT 101 (3) Fundamentals of Accounting I OR ___ ACC 201 Financial Accounting
Program Requirements
Fall I
___ FNS 101 (2) Introduction to Funeral Service
___ FNS 130 (2) Business and Mortuary Law
Spring I
___ FNS 110 (2) Funeral Service Management and Merchandising
___ FNS 115 (3) Funeral Service Directing
___ FNS 165 (2) Sociology of Funeral Service
___ FNS 170 (4) Thanatochemistry
Fall II
___ FNS 131 (3) Funeral Service Ethics, Regulations, and [NAME]
___ FNS 150 (3) Pathology for Funeral Service
___ FNS 120 (4) Funeral Counseling
Spring II
___ FNS 240 (4) Restorative Arts
___ FNS 250 (4) Embalming
___ FNS 255 (1) Embalming Practicum
___ FNS 275 (2) Funeral Service Projects
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 694234d1599469799-extract-every-2nd-row-data-based-value-not-blank-and-criteria-in-column-headers-sample-_1-1-
Sheet: Desired results

 | Date | Time | W's | Data
 | 2020-09-09 00:00:00 |  |  |  |  | From Data sheet extract the values as per this table, under the following rules: Time should be extracted based on the left side and to be returned in increasing order and then the W above and the matching row header. Time will always be the second row for each row header and W will always be the first row. There may be blanks in time rows, and these should be excluded even if the W's are not blank
 |  |  |  |  |  | 9:00 - 11:00 | w4 | e2
 |  |  |  |  |  | 11:30 - 12:00 | w1 | a1
 |  |  |  |  |  | 12:00-12:30 | w1 | a2
 |  |  |  |  |  | 14:15 - 15:00 | w2 | b2
 |  |  |  |  |  | 16:30-17:30 | w1 | b1
Spreadsheet: 822796d1679534185-counting-duplicates-as-unique-based-on-multiple-criteria-uniquecount
Sheet: Sheet1

 |  |  |  | Run 1 | Run 2 | Run 3 | Run 4
Run | Load ID |  | # of loads
1 | SAC70060357
1 | SAC70060357
1 | SAC70060357
1 | SAC70060357
1 | SAC70060357
1 | SAC70060357
1 | SAC70060357
1 | SAC70060357
Run | Load ID
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
1 | SAC70060358
Run | Load ID
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
2 | SAC70060359
Run | Load ID
2 | SAC70060361
2 | SAC70060361
2 | SAC70060361
2 | SAC70060361
2 | SAC70060361
2 | SAC70060361
2 | SAC70060361
2 | SAC70060361
2 | SAC70060361
Run | Load ID
3 | SAC70060362
3 | SAC70060362
3 | SAC70060362
3 | SAC70060362
3 | SAC70060362
3 | SAC70060362
3 | SAC70060362
3 | SAC70060362
3 | SAC70060362
Run | Load ID
3 | SAC70060363
3 | SAC70060363
3 | SAC70060363
3 | SAC70060363
3 | SAC70060363
3 | SAC70060363
3 | SAC70060363
3 | SAC70060363
3 | SAC70060363
Run | Load ID
4 | SAC70060364
4 | SAC70060364
4 | SAC70060364
4 | SAC70060364
4 | SAC70060364
4 | SAC70060364
4 | SAC70060364
4 | SAC70060364
4 | SAC70060364
Run | Load ID
4 | SAC70060365
4 | SAC70060365
4 | SAC70060365
4 | SAC70060365
4 | SAC70060365
4 | SAC70060365
4 | SAC70060365
4 | SAC70060365
4 | SAC70060365
Load type | Load ID
4 | SAC70060366
4 | SAC70060366
4 | SAC70060366
4 | SAC70060366
4 | SAC70060366
4 | SAC70060366
4 | SAC70060366
4 | SAC70060366
4 | SAC70060366
Run | Load ID
4 | SAC70060367
4 | SAC70060367
4 | SAC70060367
4 | SAC70060367
4 | SAC70060367
4 | SAC70060367
4 | SAC70060367
4 | SAC70060367
4 | SAC70060367