tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716442d1612208616-personal-budget-tracker-help-needed-sumif-budget-tracker-2021-sumproductv2
Sheet: PERSONAL BUDGET

Create a Simple Personal Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.
Title of this worksheet is in cell at right. Enter year in cell Q2. Next instruction is in cell A4. | PERSONAL BUDGET
[NAME] are in cells C4 through P4. |  | REVENUE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR
Enter details in Income table starting in cell C5. Next instruction is in cell A11. |  | INCOME | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Wages | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500
 |  | Interest/Dividends | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Miscellaneous | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total
 |  | Total Expenses
 |  | [NAME]
[NAME] are in cells C11 through P11. |  | EXPENSES | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR
Enter Home expenses in table starting in cell C12. Next instruction is in cell A20. |  | HOME | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Electric
 |  | Internet
 |  | Cable
 |  | Water
 |  | Planet Fitness
 |  | Car Payment
 |  | Car Insurance
 |  | Groceries
 |  | Optavia
 |  | Dining out
Enter Daily expenses in table starting in cell C20. Next instruction is in cell A29. |  | Total
 |  | DEBT | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | WGU - Tuition
 |  | 401K Loan
 |  | Student Loans
Enter Transportation expenses in table starting in cell C29. Next instruction is in cell A38. |  | Total
 |  | WEDDING | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline
 |  | Flights
 |  | VRBO
 |  | Cake
 |  | Flowers
 |  | Suit
 |  | Dress
Enter Entertainment expenses in table starting in cell C38. Next instruction is in cell A45. |  | Reception Dinner
 |  | Photographer
 |  | Transporation to airport
 |  | Car rental
 |  | Officiant
 |  | Hair/Makeup
 |  | Nails
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total
Enter Health expenses in table starting in cell C45. Next instruction is in cell A55.
 |  | TOTALS | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | SPARKLINE
 |  | Total expenses
 |  | Cash short/extra
Spreadsheet: john_lavorato__16553__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 192200d1352336230-need-help-using-and-understanding-if-function-testing
Sheet: Team Change Report (Step 2)

 |  | PROGRESSION JOURNAL |  |  |  |  | REGRESSION JOURNAL |  |  |  |  | PLAYER OF THE WEEK JOURNAL |  |  |  |  | INJURED PLAYERS
WEEK | POS | NAME | OVR |  | WEEK | POS | NAME | OVR |  | WEEK | POS | NAME | OVR |  | WEEK | POS | NAME | OVR
1 | QB | [NAME] | 1 |  | 1 | RB | [NAME] |  |  | 1 | WR | [NAME] |  |  | 1 | QB | [NAME] | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FB
 |  |  |  |  |  |  |  |  |  | CURRENT POINT CAP LIMIT |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  | # OF OFFENSIVE PLAYERS |  |  |  |  | OFFENSE TOTAL
 |  |  |  |  |  |  |  |  |  | # OF DEFENSIVE PLAYERS |  |  |  |  | DEFENSE TOTAL
 |  |  |  |  |  |  |  |  |  | # OF SPEACIAL TEAMS PLAYERS |  |  |  |  | SPC TEAM TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  | Points over/under [NAME]
 |  |  |  |  |  |  |  |  |  | ROSTER SPOTS LEFT
Spreadsheet: 80361d1280520323-minimum-positive-only-multiple-cells-not-a1-a10-dummybook1
Sheet: Sheet1

1 | 5 | 5 | 14
2 |  | 0
3 |  | 0
4 |  | 0
5 |  | 0
6 |  | 0
1 |  | 0
7 |  | 0
8 |  | 0
9 |  | 0
10 |  | 0
11 |  | 0
1 |  | 0
12 | -12 | 0
13 |  | 0
14 |  | 0
15 |  | 0
16 |  | 0
1 |  | 0
17 |  | 0
18 |  | 0
19 |  | 0
20 |  | 0
21 |  | 0
1 |  | 0
22 |  | 0
23 | 9 | 9
Spreadsheet: 744344d1629194343-extract-fields-based-on-current-date-and-month-sample-workbook-with-expected-output
Sheet: Details

 | Preparer | Backup | [NAME] | Activity Name | Frequency | Rotation Cycle Time Frame | Due Date
 | Smith | Arav | Keshav | AFBCDD | As Needed | 2021-07-01 00:00:00 | As Needed
 | Aiden | Jameson | [NAME] | KLMKJLJ | Monthly - Day 2 | 2021-07-01 00:00:00 | 02.08.2021
 | Cole | Dion | Shane | SDFADF | Monthly - Day 3 | 2021-07-01 00:00:00 | 03.08.2021
 | Shaw | Irwin | [NAME] | EPROIIR | Monthly - Day 20 | 2021-07-01 00:00:00 | 20.08.2021
 | Harold | [NAME] | [NAME] | ZMCNXX | Every Tuesday | 2021-07-01 00:00:00 | Every Tuesday
 | Alvin | Hayden | Hugo | ADFJDFV | Daily | 2021-07-01 00:00:00 | Daily
 | Lowell | Xavier | Misha | WOUREU | As Received | 2021-07-01 00:00:00 | As Received
 | Nicol | [NAME] | Sultan | GHKFDD | Monthly - Day 5 | 2021-07-01 00:00:00 | 05.09.2021
 | Aiden | Jameson | [NAME] | AFBCDD | As Needed | 2021-08-01 00:00:00 | As Needed
 | Shaw | Irwin | [NAME] | KLMKJLJ | Monthly - Day 2 | 2021-08-01 00:00:00 | 02.09.2021
 | Lowell | Xavier | Misha | SDFADF | Monthly - Day 3 | 2021-08-01 00:00:00 | 03.09.2021
 | Harold | [NAME] | [NAME] | EPROIIR | Monthly - Day 20 | 2021-08-01 00:00:00 | 20.09.2021
 | Alvin | Hayden | Hugo | ZMCNXX | Every Tuesday | 2021-08-01 00:00:00 | Every Tuesday
 | Cole | Dion | Shane | ADFJDFV | Daily | 2021-08-01 00:00:00 | Daily
 | Smith | Arav | Keshav | WOUREU | As Received | 2021-08-01 00:00:00 | As Received
 | Nicol | [NAME] | Sultan | GHKFDD | Monthly - Day 5 | 2021-08-01 00:00:00 | 05.09.2021
 | Lowell | Xavier | Misha | AFBCDD | As Needed | 2021-09-01 00:00:00 | As Needed
 | Shaw | Irwin | [NAME] | KLMKJLJ | Monthly - Day 2 | 2021-09-01 00:00:00 | 02.10.2021
 | Alvin | Hayden | Hugo | SDFADF | Monthly - Day 3 | 2021-09-01 00:00:00 | 03.10.2021
 | Cole | Dion | Shane | EPROIIR | Monthly - Day 20 | 2021-09-01 00:00:00 | 20.10.2021
 | Smith | Arav | Keshav | ZMCNXX | Every Tuesday | 2021-09-01 00:00:00 | Every Tuesday
 | Harold | [NAME] | [NAME] | ADFJDFV | Daily | 2021-09-01 00:00:00 | Daily
 | Aiden | Jameson | [NAME] | WOUREU | As Received | 2021-09-01 00:00:00 | As Received
 | Nicol | [NAME] | Sultan | GHKFDD | Monthly - Day 5 | 2021-09-01 00:00:00 | 05.10.2021
Spreadsheet: 41097d1239608180-autofilling-the-fields-when-typing-just-one-info-records-1
Sheet: records

2009-04-13 00:35:33
[NAME] No. | B12345683 | Select from this drop box
SSN | 123-45-6794
First Name | FirstN6
Middle name | Middle6
Last Name | LastN6
Date of Birth | 23017
City of Birth | New York
Country of Birth | USA
Address | 1237 Main St #2
City | New York
State | CA
Zip Code | 12345
Sex | F
Hair | Blond
Eyes | [NAME]
HT | 5' 11"
WT | 175 lbs
Spreadsheet: 72030d1272715675-rank-with-2-critieria-with-alphabetical-order-as-one-criteria-rank-using-names-as-tie-break
Sheet: Sheet1

Name | Points | name rank | ranked using name rank as tie break
[NAME] | 1 | 1 | 4
[NAME] | 6 | 2 | 1
Adam | 4 | 3 | 3
[NAME] | 4 | 4 | 2
Spreadsheet: 844586d1696352347-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-master-copy
Sheet: 16

Name | lbs | oz | Oz (total) | Points
Spreadsheet: 78829d1279129212-sum-several-worksheets-in-same-workbook-tech-attendance
Sheet: ATTENDACE Feb thru April

Last Name | First Name | Tech ID | Vacation | Personal | Sick | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 | 2010-02-20 00:00:00 | 2010-02-21 00:00:00 | 2010-02-22 00:00:00 | 2010-02-23 00:00:00 | 2010-02-24 00:00:00 | 2010-02-25 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-02-28 00:00:00 | 2010-03-01 00:00:00 | 2010-03-02 00:00:00 | 2010-03-03 00:00:00 | 2010-03-04 00:00:00 | 2010-03-05 00:00:00 | 2010-03-06 00:00:00 | 2010-03-07 00:00:00 | 2010-03-08 00:00:00 | 2010-03-09 00:00:00 | 2010-03-10 00:00:00 | 2010-03-11 00:00:00 | 2010-03-12 00:00:00 | 2010-03-13 00:00:00 | 2010-03-14 00:00:00 | 2010-03-15 00:00:00 | 2010-03-16 00:00:00 | 2010-03-17 00:00:00 | 2010-03-18 00:00:00 | 2010-03-19 00:00:00 | 2010-03-20 00:00:00 | 2010-03-21 00:00:00 | 2010-03-22 00:00:00 | 2010-03-23 00:00:00 | 2010-03-24 00:00:00 | 2010-03-25 00:00:00 | 2010-03-26 00:00:00 | 2010-03-27 00:00:00 | 2010-03-28 00:00:00 | 2010-03-29 00:00:00 | 2010-03-30 00:00:00 | 2010-03-31 00:00:00 | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-04 00:00:00 | 2010-04-05 00:00:00 | 2010-04-06 00:00:00 | 2010-04-07 00:00:00 | 2010-04-08 00:00:00 | 2010-04-09 00:00:00 | 2010-04-10 00:00:00 | 2010-04-11 00:00:00 | 2010-04-12 00:00:00 | 2010-04-13 00:00:00 | 2010-04-14 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | 2010-04-18 00:00:00 | 2010-04-19 00:00:00 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 2010-04-22 00:00:00 | 2010-04-23 00:00:00 | 2010-04-24 00:00:00 | 2010-04-25 00:00:00 | 2010-04-26 00:00:00 | 2010-04-27 00:00:00 | 2010-04-28 00:00:00 | 2010-04-29 00:00:00 | 2010-04-30 00:00:00
Badreddine | Yabi | 897884 | 0 | 0 | 0
Berrospe | [NAME] | 717553 | 0 | 0 | 0
[NAME] | [NAME] | 670844 | 0 | 0 | 0
Ciran | [NAME] | 897124 | 0 | 0 | 0
Cory | [NAME] | 574517 | 0 | 0 | 0
Ditore | [NAME] | 823088 | 0 | 0 | 0
Garvey | [NAME] | 3897 | 0 | 0 | 0
Guzman | Saul | 918615 | 0 | 0 | 0
Heineman | Russ | 737502 | 0 | 0 | 0
Holland | Scott | 801597 | 0 | 0 | 0
Lopez | Javier | 498139 | 0 | 0 | 0
Mendez | Hector | 10538 | 0 | 0 | 0
Mendez | Hector | 10538 | 0 | 0 | 0
Pula | Elvis | 684779 | 0 | 0 | 0
[NAME] | [NAME] | 449397 | 0 | 0 | 0
Valle | [NAME] | 706481 | 0 | 0 | 0
[NAME] | [NAME] | 506097 | 0 | 0 | 0
Waitekus | [NAME] | 613091 | 0 | 0 | 0
Spreadsheet: 63943d1264791933-employees-project-report-summary-explain-new
Sheet: Summary Total

IN THE PROJECT COLUMN WILL BE ALL THE POSSIBLE VALUES THAT COULD BE FOUND ON ALL WORKBOOKS AND SPREADSHEETS BETWEEN A13:A18 | IN THE TOTAL COLUMN WILL CALCULATE THE AMOUNT OF HOURS THAT EVERY EMPLOYEE HAS SPENT THROUGHOUT THE YEAR
PROJECTS | ALL EMPLOYEES TOTAL | IMPORTANT
CR001 |  | In Cell B9 is where we want the hours to be displayed. So for example we need to look in the john worksheet,tony worksheet,[NAME],[NAME] and susan worksheet [NAME] cells A13:A18 and find the project CR001 and add the total amount of the hours(which could be between G13:G18) and display it to me.
CR002
CR003
CR004
CR005 |  | IF THE FORMULA IS CORRECT THE WE WILL SEE IN CELL B9  42.5. AND HERE HOW THIS AMOUNT CAME FROM ( In [NAME]'s worksheet found out than CR001 total is 5hours, in tony's worsheet found out that CR001 totals to 6.5hours, in Dany's worksheet found out that CR001 totals to  14hours, in [NAME]'s worksheet found out that CR001 totals to 8hours and in [NAME]'s worksheet found out CR001 totals 9hours. Now we add the hours= 5+6.5+14+8+9 which gives us 42.5 .
CR006 |  | IN CELL B10 WILL SEE THE AMOUNT OF 28.5
CR007 |  | IN CELL B11 WILL SEE THE AMOUNT OF 18
CR008
CR009 |  | IF WE MANAGE TO GET THIS FORMULAS TO WORK WILL WE BE ABLE TO CONNECT 400 DIFFERENT WORKSHEETS TOGETHER AS THEY WILL BE IN DIFFENERNT PLACE AND IF YES HOW?
CR010
CR011
CR012
[NAME]
CR014
CR015
CR016
CR017
CR018
CR019
CR020
CR021
[NAME]
CR023
CR024
CR025
CR026
CR027
CR028
CR029
[NAME]
Spreadsheet: 274723d1383206663-mapping-data-to-different-spreadsheets-amanda_reply-2
Sheet: Sent for Full

Sent For Full
Current Status | Date | Last Name | Lender Name | Type of Loan | [NAME] | Purpose | Prop Type | Title Company | Loan Officer | Loan Amount | Processor | Notes |  | Match (All data Row)
Spreadsheet: 198853d1354910969-multiple-data-validation-in-one-cell-levels-and-numbers-forum
Sheet: Levels

Level | Multiplier
5+ | 0.98
5 | 0.95
5- | 0.91
4+ | 0.88
4 | 0.85
4- | 0.81
3+ | 0.78
3 | 0.75
3- | 0.71
2+ | 0.68
2 | 0.65
2- | 0.61
1+ | 0.58
1 | 0.55
1- | 0.51
R | 0.45
Spreadsheet: 764164d1642615740-i-need-help-making-my-randomiser-rng-serve-its-purpose-randomiser
Sheet: Roster

 | Table 1 |  |  |  | Randomiser |  |  |  | Table 2
 | Number | Item | Present | Comp | RNG | Rank | Present | Comp | Location | RNG | Item
 | 1 | 1 |  |  |  |  | True | True | 1
 | 2 | 2 |  |  |  |  | True | True | 2
 | 3 | 3 |  |  |  |  | True | True | 3
 | 4 | 4 |  |  |  |  | True | True | 4
 | 5 | 5 |  |  |  |  | True | True | 5
 | 6 | 6 |  |  |  |  | True | True | 6
 | 7 | 7 |  |  |  |  | True | True | 7
 | 8 | 8 |  |  |  |  | True | True | 8
 | 9 | 9 |  |  |  |  | True | True | 9
 | 10 | 10 |  |  |  |  | True | True | 10
 | 11 | 11 |  |  |  |  | True | True | 11
 | 12 | 12 |  |  |  |  | True | True | 12
 | 13 | 13 |  |  |  |  | True | True | 13
 | 14 | 14 |  |  |  |  | True | True | 14
 | 15 | 15 |  |  |  |  | True | True | Float 1
 | 16 | 16 |  |  |  |  | True | True | Float 2
 | 17 | 17 |  |  |  |  | True | True | Float 3
 | 18 | 18 |  |  |  |  | True | True | Float 4
 | 19 | 19 |  |  |  |  | True | True | Float 5
 | 20 | 20 |  |  |  |  | True | True | Float 6
 | 21 | 21 |  |  |  |  | True | True | Float 7
 | 22 | 22 |  |  |  |  | True | True | Float 8
 | 23 | 23 |  |  |  |  | True | True | Float 9
 | 24 | 24 |  |  |  |  | True | True | Float 10
 | 25 | 25 |  |  |  |  | True | True | Float 11
 | 26 | 26 |  |  |  |  | True | True | Float 12
 | 27 | 27 |  |  |  |  | True | True | Float 13
 | 28 | 28 |  |  |  |  | True | True | Float 14
Spreadsheet: 767189d1644331387-countifs-skip-a-range-and-criteria-set-if-condition-is-blank-book1-87-ans
Sheet: Sheet2

User | Status 1 | Status 2 | Status 3 | Sum | Count | Average
250001 | 1 | 21 | 41 | 53.64000000000001 | 5 | 8.940000000000001
250020 | 2 | 22 | 42 | 9.2 | 2 | 4.6 |  |  | [NAME]
250308 | 3 | 23 | 43 | 1.5 | 1 | 1.5
250743 | 4 | 24 | 44 | 1.32 | 3 | 0.4399999999999999
250484 | 5 | 25 | 45 | 1.1 | 5 | 0.22 |  |  | Status 1
258168 | 6 | 26 | 46 | 290.575 | 43 | 6.457222222222222 |  |  | Status 2 | >=21
251875 | 7 | 27 | 47 | 5.200000000000002 | 1 | 5.200000000000002 |  |  | Status 3 | >=22
225188 | 8 | 28 | 48 | 0.22 | 1 | 0.22 |  |  | Sum | >=1
352413 | 9 | 29 | 49 | 36.84 | 19 | 1.938947368421053 |  |  | Count | >=1
125273 | 10 | 30 | 50 | 9.68 | 2 | 4.84 |  |  | Average | >=1
Spreadsheet: 688287d1595685373-find-value-according-to-multiple-criteria-warp-planning-sheet
Sheet: desired result

WARP PLANING
 |  | 2020-07-13 00:00:00 | DAY | NIGHT
 |  |  | WARP CUT | WARP CUT
LOOM NO | CURRENT WARP | PENDING MTRS | ON | ON | MATERIAL TO BE IN HOUSE BY -7 DAYS | MATERIAL TO BE PURCHASED ON -3 DAYS | NEXT WARP ORDERED
3
4
5
6 |  |  | 2020-07-20 00:00:00
7
8
9 |  |  | 2020-07-18 00:00:00
10
13 |  |  | 2020-07-18 00:00:00
14
15
16 |  |  |  | 2020-07-20 00:00:00
Spreadsheet: 48705d1247956359-linking-a-row-to-a-cell-that-gets-sorted-by-autofilter-south-test
Sheet: ACTIVITIES 1

 | Date | Location | Type of Event
COL | 2009-05-03 00:00:00 | COL | MARTIAL ARTS
COL | 2009-05-08 00:00:00 | COL | CIV ASST
COL | 2009-02-09 00:00:00 | COL | RESCUE
COL | 2009-03-06 00:00:00 | COL | FLIGHT
PER | 2009-02-04 00:00:00 | PER | MARTIAL ARTS
PER | 2009-07-06 00:00:00 | PER | CIV ASST
PER | 2009-08-06 00:00:00 | PER | RESCUE
PER | 2009-09-08 00:00:00 | PER | FLIGHT
ECU | 2009-10-01 00:00:00 | ECU | MARTIAL ARTS
ECU | 2009-11-01 00:00:00 | ECU | CIV ASST
ECU | 2009-11-02 00:00:00 | ECU | RESCUE
HAITI | 2009-11-08 00:00:00 | DOM | FLIGHT
HAITI | 2009-12-01 00:00:00 | DOM | SWIM
Spreadsheet: 681511d1591615377-count-max-consecutive-zeros-consecutive-zeros
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANSWER
 |  | 2008 | 2985 | 0 | 0 | 2870 | 0 | 2819 | 2490 | 2465 | 2400 | 2375 | 2350 | 2325 | 2300 | 2275 | 2250 | 2225
 |  | 2008 | 2985 | 2375 | 2350 | 2325 | 0 | 2819 | 2490 | 2465 | 2400 | 0 | 0 | 0 | 2300 | 2275 | 2250 | 2225
 |  | 2008 | 2985 | 2465 | 0 | 0 | 0 | 0 | 0 | 0 | 2400 | 2375 | 2350 | 2325 | 2300 | 0 | 0 | 2225
Spreadsheet: 688065d1595551248-link-cells-using-data-validation-excel-help
Sheet: Sheet1

Financing Structure
 | Structure
 | Structure 1 | Structure 2 | Structure 3 | Structure 4 | Status Quo
Revolving Credit Facility Size | 250 | 250 | 250 | 250 | 250
Term Loan A |  | 500
Term Loan B | 2150 | 1650 | 2100 | 1750
Term Loan C | 500 |  |  |  | 30
Existing Term Loan |  | 50
2nd [NAME] |  |  | 400
Senior Notes | 1500 | 1500 | 700 | 1000
Senior Suboridinate Notes |  |  | 700 | 1000
Senior Bridge Facility
Senior Subordinate Bridge Facility |  |  | 1000
Financing Fees
 |  | Fees
 | Structure 1 | Size | (%) | ($)
Revolving Credit Facility Size |  |  | 0.01
Term Loan A |  |  | 0.02
Term Loan B |  |  | 0.03
Term Loan C |  |  | 0.04
Existing Term Loan |  |  | 0.05
2nd [NAME] |  |  | 0.06
Senior Notes |  |  | 0.07
Senior Suboridinate Notes |  |  | 0.08
Senior Bridge Facility |  |  | 0.09
Senior Subordinate Bridge Facility |  |  | 0.1
Other Financing Fees & Expense |  |  |  | 5
Total Financing Fees
Amortization of Financing Fees
 | Term | Year 1 2013 | Year 2 2014 | Year 3 2015 | Year 4  2016 | Year 5 2017 | Year 6  2018 | Year 7  2019 | Year 8 2020 | Year 9  2021 | Year 10 2022
Revolving Credit Facility Size | 4
Term Loan A | 5
Term Loan B | 5
Term Loan C | 6
Existing Term Loan | 7
2nd [NAME] | 7
Senior Notes | 7
Senior Suboridinate Notes | 8
Senior Bridge Facility | 8
Senior Subordinate Bridge Facility | 9
Other Financing Fees & Expense | 10
Annual Amortization
Spreadsheet: 113362d1309287352-excel-2007-vlookup-skip-rows-with-empty-cells-health-database-2
Sheet: Entry Sheet

Name (Last, First) | Date (mm/dd/yyyy) | Weight | Systolic BP (#/#) | Diastolic BP (#/#)
h | 2010-09-10 00:00:00 | 130
i | 2010-04-03 00:00:00 | 131 | 121 | 81
j | 2009-10-25 00:00:00 | 132
k | 2009-05-18 00:00:00 |  | 125 | 85
l | 2008-12-09 00:00:00 | 134 | 127 | 87
m | 2008-07-02 00:00:00 |  | 129 | 89
n | 2008-01-24 00:00:00 | 136 | 131 | 91
o | 2007-08-17 00:00:00 | 137 | 133 | 93
p | 2007-03-10 00:00:00 | 138 | 135 | 95
q | 2006-10-01 00:00:00 | 139 | 137 | 97
r | 2006-04-24 00:00:00 | 140 | 139 | 99
s | 2005-11-15 00:00:00 | 141 | 141 | 101
t | 2005-06-08 00:00:00 | 142 | 143 | 103
u | 2004-12-30 00:00:00 | 143 | 145 | 105
v | 2004-07-23 00:00:00 | 144 | 147 | 107
h | 2004-02-14 00:00:00 |  | 100 | 70
i | 2003-09-07 00:00:00 | 100
j | 2003-03-31 00:00:00 |  | 120 | 80
o | 2002-10-22 00:00:00
q | 2002-05-15 00:00:00
u | 2001-12-06 00:00:00
w | 2001-06-29 00:00:00
y | 2001-01-20 00:00:00
Spreadsheet: 177406d1346304592-vlookup-conditional-formatting-conditional-test
Sheet: Sheet2

Grades | Ranking #'s
VBB | 0
5.5 | 1
5.6 | 2
5.7 | 3
5.8 | 4
5.9 | 5
5.10a | 6
VB | 7
5.10b | 8
V0 | 9
5.10c | 10
5.10d | 11
V1 | 12
5.11a | 13
V2 | 14
5.11b | 15
V3 | 16
5.11c | 17
V4 | 18
5.11d | 19
V5 | 20
5.12a | 21
V6 | 22
5.12b | 23
V7 | 24
5.12c | 25
5.12d | 26
V8 | 27
5.13a | 28
V9 | 29
5.13b | 30
V10 | 31
5.13c | 32
V11 | 33
5.13d | 34
V12 | 35
5.14a | 36
V13 | 37
5.14c | 38
V14 | 39
5.14d | 40
V15 | 41
5.15a | 42
5.15b | 43
Spreadsheet: 6f49cada-9241-41c4-89ec-63c851062f00
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CDTA | Test | CDTA | Carbohydrate Deficient Transferrin, Adult, Serum | [NAME], Adult, S | Affinity Chromatography/Mass Spectrometry (MS) | Plastic vial: PlV |  |  | 0.1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.1 mL Additional Information:  1. Patient's age is required. Reason for referral is required if patient is <21 years old. 2. This test is for evaluation of alcohol abuse. If the ordering physician is looking for congenital disorders of glycosylation, order CDG / Carbohydrate Deficient Transferrin for Congenital Disorders of Glycosylation, Serum. | 0.05 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm <7 days OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | < or =0.10 0.11-0.12 (indeterminate) | Wednesday; 8 a.m. | 5 days (Not reported Saturday or Sunday) | 10 days | 1 | 82373 |  |  |  |  | Rochester
CDTA | [NAME] | SERUM | Serum |  |  |  | Frozen | 45 days
CDTA | Result | 31714 | Mono-oligo/Di-oligo [NAME] | Mono-oligo/Di-oligo [NAME] | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35469-6 | Mono-oligosaccharide/Di-oligosaccharide:MRto:Pt:Ser/Plas:Qn:
CDTA | Result | 31715 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 827284d1682588876-how-do-i-make-a-table-where-the-number-of-rows-adjusts-automatically-dynamic-table-compound-growth
Sheet: Sheet1

What is the Future Value of Your Retirement Fund?
What is your Age? | 55
At what age will you retire? | 65
What is your annual contribution? | 20000 | (First payment immediately)
What is the expected interest rate? | 0.04
What is your starting capital? | 250000
Expected Final Fund Value
Desired output is below
Based on the above, here is how your fund will grow:
Age | Start Value | Funds added | Interest earned | New Value
 |  |  |  |  |  |  | 250000 | 20000 | 10000 | 280800
 |  |  |  |  |  | 57 | 280800 | 20000 | 11232 | 312832.0000000001
 |  |  |  |  |  | 58 | 312832.0000000001 | 20000 | 12513.28 | 346145.28
 |  |  |  |  |  | 59 | 346145.28 | 20000 | 13845.8112 | 380791.0912000002
 |  |  |  |  |  | 60 | 380791.0912000002 | 20000 | 15231.64364800001 | 416822.7348480002
 |  |  |  |  |  | 61 | 416822.7348480002 | 20000 | 16672.90939392001 | 454295.6442419203
 |  |  |  |  |  | 62 | 454295.6442419203 | 20000 | 18171.82576967681 | 493267.470011597
 |  |  |  |  |  | 63 | 493267.470011597 | 20000 | 19730.69880046388 | 533798.1688120611
 |  |  |  |  |  | 64 | 533798.1688120611 | 20000 | 21351.92675248244 | 575950.0955645435
 |  |  |  |  |  | 65 | 575950.0955645435 | 20000 | 23038.00382258174 | 619788.0993871253
Spreadsheet: 119473d1314430340-using-if-with-multiple-criteria-book1-12-
Sheet: Sheet1

Customer Name | Ageing days | Amount |  | 30 | 60 | 90 | 180 | e307
A | 365 | 5000 |  |  |  |  |  | 5000
B | 190 | 20000 |  |  |  |  |  | 20000
C | 25 | 12000 |  | 12000 | 0 | 0 | 0 | 0
D | 61 | 44000 |  |  |  | 44000 | 0 | 0
E | 125 | 10000 |  |  |  |  | 10000 | 0