tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 805724d1668863311-depreciation-and-re-investment-formulas-depreciation-and-reinvestment-ans2
Sheet: Sheet1

 |  |  |  |  | Initial investment |  |  |  |  | Re-investment 1 |  |  |  | Re-investment 2
Asset | Useful life (years) | Investment / Depreciation | Single Investment Total | Investment Total | Yr1 | Yr2 | Yr3 | Yr4 | Yr5 | Yr6 | Yr7 | Yr8 | Yr9 | Yr10 | Yr11 | Yr12 | Yr13 | Yr14 | Yr15
A |  | Investment Total | 7000 |  | 1000 | 1000 | 5000 |  |  | 3000 | 4000 |  |  | 2000 | 1000 | 1000 | 3000
A |  | Depreciation Investment Yr1
A |  | Depreciation Investment Yr2
A |  | Depreciation Investment Yr3
A |  | Depreciation Investment Yr4
A | 3 | Depreciation Total | -7000
 |  | Check |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automate these cells without having to have helper rows in rows (4-7)
 |  |  |  | FORMULA
Spreadsheet: joe_parks__14592__Wire Template
Sheet: Wire Transfer

 | FOR SAP COMPANIES ONLY
 | Wire Transfer Request
 |  |  |  |  |  | DATE FUNDS TO BE WIRED (MMDDYY)
COMPANY NAME PAYING (PAYOR) |  |  |  |  | COMPANY NO. |  | BANK ACCOUNT
ENRON NORTH AMERICA |  |  |  |  | 0364
Requestor | NAME |  |  |  |  | PHONE NO.
 | DEPARTMENT
In payment of
 |  |  |  | INVOICE NUMBER |  |  | INVOICE DATE
 | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T (ROUTING ORDER)
 | PAYEE NAME
Wire Funds To
 | PAYEE ADDRESS |  |  |  |  |  | Vendor Number
 | CITY |  |  |  | STATE |  | COUNTRY
 | BANK NAME
 | BANK ADDRESS
 | CITY |  |  |  | STATE |  | COUNTRY
 | REFERENCE MESSAGE ON WIRE (20 CHARACTERS)
Accounting Code | Amount |  | Co Number | Account | Posting Key | Special GL | XREF1
 |  |  | Due On | Allocation |  | XREF 2
 |  |  | Order | Description |  |  | XREF3
 |  |  |  | Cost Center | Profit Center
 |  |  | Total amount of wire.  Documentation supporting amount MUST be attached to form.
APPROVAL |  |  | DATE | APPROVAL |  |  | DATE
APPROVAL |  |  | DATE | APPROVAL |  |  | DATE
A/P MANAGER APPROVAL |  |  | DATE
Attach Supplemental Wire Transfer Request Form for further credit routing or additional account coding.
Spreadsheet: 855725d1705248285-index-a-result-which-is-the-value-above-a-threshold-in-a-time-range-on-a-date-excel-formula-help
Sheet: Sheet2

value | Time | Date | Start Time | End Time | Specific Date | Target Value | First value that breaks above the target value between the start and end times on the specific date
1 | 08:00:00 | 2023-09-18 | 09:00:00 | 10:00:00 | 2023-09-18 | 1.5
1 | 08:05:00 | 2023-09-18 |  |  |  |  | I would be looking for the above cell to display 09:20 as that is the first time the values go above 1.5
1 | 08:10:00 | 2023-09-18
1 | 08:15:00 | 2023-09-18
1 | 08:20:00 | 2023-09-18
1 | 08:25:00 | 2023-09-18
1 | 08:30:00 | 2023-09-18
1 | 08:35:00 | 2023-09-18
1 | 08:40:00 | 2023-09-18
1 | 08:45:00 | 2023-09-18
1 | 08:50:00 | 2023-09-18
1 | 08:55:00 | 2023-09-18
1 | 09:00:00 | 2023-09-18
1 | [NAME] | 2023-09-18
1 | 09:10:00 | 2023-09-18
1 | 09:15:00 | 2023-09-18
2 | 09:20:00 | 2023-09-18
2 | 09:25:00 | 2023-09-18
2 | 09:30:00 | 2023-09-18
2 | 09:35:00 | 2023-09-18
3 | 09:40:00 | 2023-09-18
3 | 09:45:00 | 2023-09-18
3 | 09:50:00 | 2023-09-18
3 | 09:55:00 | 2023-09-18
3 | 09:00:00 | 2023-09-18
3 | 10:05:00 | 2023-09-18
4 | 10:10:00 | 2023-09-18
Spreadsheet: 696543d1600877583-insert-duplecat-values-in-row-with-conditional-data-data
Sheet: Sheet1

Name | Sale | Result
A | 100 | 1 |  |  | I need this RESULT
A | 200 | 2
A | 200 | 2 |  |  | Please, wihout VB & helper column
A | 300 | 3
A | 400 | 4
A | 400 | 4
B | 200 | 5
B | 400 | 6
B | 400 | 6
B | 400 | 6
B | 300 | 7
Spreadsheet: 328020d1403770175-start-formula-minus-als-e1-is-equal-to-0-victor
Sheet: Blad1

2015 | 0 | 0 | 0 | 0 |  | [NAME] in F1 moet het volgende komen te staan ...Bereken {=Min(ALS(A1:D1>0;A1:14))} als E1 gelijk is aan 0
0 | 2016 | 2017 | 0 | 2018
0 | 0 | 2019 | 0 | 0
0 | 0 | 2018 | 2019 | 2020
2016 | 0 | 0 | 0 | 0
0 | 0 | 2015 | 0 | 0
0 | 0 | 2020 | 0 | 2015
2015 | 0 | 0 | 0 | 0
Spreadsheet: 718150d1613014504-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 28

 |  |  | Date | 2021-01-28 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine2 | 15:00:00 | 16:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 114970d1310630706-transferring-data-in-two-worksheets-using-identical-values-lookup
Sheet: Sheet3

A |  | 5
2 |  | 5
C |  | 5
D |  | 5
E |  | 5
F |  | 5
G |  | 5
H |  | 5
I |  | 5
A |  | 6
B |  | 6
C |  | 6
D |  | 6
E |  | 6
F |  | 6
3 |  | 6
H |  | 6
I |  | 6
Spreadsheet: 742725d1627995325-client-count-per-hour-with-rounding-rules-examplebilling
Sheet: Biling-Trinity

 | Code | Last Name | First Name | Date | Time In | Time Out | Total Time | Billable Hours | Program | Location | Activity | Diagnosis | Attendence | Meal- Brekfast | Meal- Lunch | Nap? | Room # | Full Name |  | Time | # Clients
 | KANR00 | Doe | [NAME] | 2021-01-01 00:00:00 | 07:58:00 | 13:00:00 |  |  |  |  |  | N/A | PRES |  |  |  |  |  |  | 06:00:00
 | OWEK00 | Smith | [NAME] | 2021-01-02 00:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  | N/A | PRES |  |  |  |  |  |  | 07:00:00
 | OWEK00 | Cameron | [NAME] | 2021-01-02 00:00:00 | 17:00:00 | 19:15:00 |  |  |  |  |  | N/A | PRES |  |  |  |  |  |  | 08:00:00
 | MARD06 | Holly | Buddy | 2021-01-03 00:00:00 |  |  |  |  |  |  |  | N/A | CN-CL |  |  |  |  |  |  | 09:00:00
 | MALI01 | [NAME] | Gavin | 2021-01-04 00:00:00 | 06:33:00 | 15:12:00 |  |  |  |  |  | N/A | PRES |  |  |  |  |  |  | 10:00:00
 | MALI01 | Phillips | [NAME] | 2021-01-05 00:00:00 | 07:01:00 | 15:20:00 |  |  |  |  |  | N/A | PRES |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
Spreadsheet: 108609d1305642495-fining-the-first-2-digits-of-a-6-digit-number-timesheet-1
Sheet: Department

Please Select | --
Development | 1
Engineering | 2
Production | 3
Fabrication | 4
Assembly | 5
Sales | 6
Service | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: b8ec19ae-8d16-44ac-9ae1-d9e1adbf5823
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Last name | First name | E-Mail | Study program | Remark study program | Degree | Current semester  ([NAME], ie. semesters in actucal study program) | Preference | University | City | Country | Term | Average grade so far  (at [NAME] or last degree) | Unnamed: 20 | ECTS so far | Unnamed: 22 | Date of bith | Nationality | Cell phone number  - optional  (in case we need to contact you in a timely issue)
 |  |  |  |  |  |  | Mustermann | [NAME] | [EMAIL] | Economics |  | Bachelor | 3 | 1 | Universiy of Ljubljana | Ljubljana | Slovenia | fall - WS | 1.9 |  | 60 |  | 1990-01-01 00:00:00 | German | 0123 45 67 89 10 11
 |  |  |  |  |  |  | Mustermann | [NAME] | [EMAIL] | Economics |  | Bachelor | 3 | 2 | Riga Technical University | Riga | Latvia | fall - WS | 1.9 |  | 60 |  | 1990-01-01 00:00:00 | German | 0123 45 67 89 10 11
 |  |  |  |  |  |  | Mustermann | [NAME] | [EMAIL] | Economics |  | Bachelor | 3 | 3 | Turku School of Economics | Turku | Finland | fall - WS | 1.9 |  | 60 |  | 1990-01-01 00:00:00 | German | 0123 45 67 89 10 11
 |  |  |  |  |  |  |  |  |  | Economics - VWL
 |  |  |  |  |  |  |  |  |  | Business - BWL
 |  |  |  |  |  |  |  |  |  | IT - Wirtschaftsinformatik
 |  |  |  |  |  |  |  |  |  | MEMS |  | Bachelor |  |  |  |  |  | fall - WS
 |  |  |  |  |  |  |  |  |  | Statistics |  | Master |  |  |  |  |  | spring - SoSe
 |  |  |  |  |  |  |  |  |  | other (please specify) |  | Diplom |  |  |  |  |  | full year - AJ
Spreadsheet: mary_fischer__25604__06 2001BROWNCOVER LE HESTEN LLC
Sheet: Formal BS

LE HESTEN ENERGY, LLC
Consolidated Balance Sheet
As of June 30, 2001
(In thousands of dollars)
([NAME])
 |  |  | 2001-06-30 00:00:00 |  | January 31,
 |  |  | 2001 |  | 2000 |  |  |  | 1997
 | ASSETS
 | Current assets:
 |  | Cash and Cash Equivalents |  |  |  |  |  |  | 1614
 |  | Accounts Receivable, net (a) |  |  |  |  |  | 90266 | 140774
 |  | Other Receivable
 |  |  |  |  |  |  |  |  | 140774
 | Total current assets
 | Investments and other assets:
 |  | Notes Receivable |  |  |  |  |  |  | 0
 |  | Notes Receivable - Affiliates | 0 |  | 0 |  |  |  | 0
 |  | Interest Receivable
 |  | Assets from Price Risk Management Activities, net of current
 |  | Intangibles, net |  |  |  |  |  |  | 5650
 |  | Goodwill, net
 |  | Other Non-Current Assets |  |  |  |  |  |  | 0
 | Total Investments and Other Assets
 | Investments
 | Total assets
 | LIABILITIES AND MEMBERS' EQUITY
 | Current liabilities:
 |  | Accounts Payable
 |  | Distributions Payable
 | Total current liabilities
 |  | Deferred Taxes
 |  | Liabilities from Price Risk Management Activities
 |  | Notes payable |  |  |  |  |  |  | 41474
 |  | Accrued Taxes |  |  |  |  |  |  | 62858
 |  | Other (b) |  |  | 0
 |  |  |  |  |  |  |  |  | 885
 | Total current liabilities
 |  | Liabilities from Price Risk Management Activities |  |  |  |  |  |  | 27732
 |  | Notes payable |  |  |  |  |  |  | 0
 |  | Accrued Taxes
 |  | Other (b)
 | Total current liabilities
 |  | Notes payable |  |  |  |  |  |  | 0
 |  | Deferred Taxes |  |  | 0 |  |  |  | 4618
 |  | Other |  |  | 0 |  |  |  | 522
 |  | Deferred income taxes |  |  | 88
 | Total non-current liabilities
 | Commitments and Contingencies (Note 9)
 | Minority Interest |  | 0 |  | 0
 | Members' equity:
 |  | Paid-in Capital  (Contribution)
 |  | Paid-in Capital
 |  | Dividends Declared
 |  | Distributions
 |  | [NAME]
 | Total members' equity |  |  |  |  |  |  |  | 82442
 | Total liabilities and members' equity
 | a | Accounts payable represents moblization costs incurred through
 |  | 6/30/2001 or $1,047 and $67 accrual relating to Employee Secondment
 |  | Agreement ($8,333) per month to both Lilly and EESO
 | b | Distributions payable - 4 month of accrual relating to Preferred Return
 |  | ($50,000*(9%/12*4))
Spreadsheet: 889076d1739786675-populating-data-in-one-sheet-example
Sheet: Sheet4

ID | Full Name | Department | Annual Salary
FH05 | France Hilton | Marketing
BS05 | [NAME] | Sales
[NAME] | [NAME] | Sales
TM19 | [NAME] | Sales
AB07 | Addison Bay | Finance
TB00 | [NAME] | Finance
US11 | [NAME] | Accounting
[NAME] | [NAME] | Human Resources
[NAME] | [NAME] | Finance
MB07 | [NAME] | Accounting
OC10 | [NAME] | Marketing
TS08 | A | Marketing
DL17 | B | Sales
SC19 | C | Sales
HB12 | D | Sales
DM15 | E | Finance
BF09 | F | Finance
CB16 | G | Accounting
BE13 | H | Human Resources
LP09 | I | Finance
GH13 | J | Accounting
AG04 | K | Marketing
FH05 | [NAME] | Marketing
BS05 | [NAME] | Finance
[NAME] | [NAME] | Finance
TM19 | Adele Menuggets | Sales
AB07 | [NAME] | Accounting
TB00 | [NAME] | Human Resources
US11 | [NAME] | Accounting
[NAME] | [NAME] | Finance
[NAME] | [NAME] | Accounting
MB07 | Post Melon | Marketing
OC10 | [NAME] | Marketing
Spreadsheet: 839656d1692135627-nested-if-statement-for-cell-containing-a-specific-word-nested-if-statement
Sheet: Sheet1

 | Job Name | Job Category (word to be looked for and returned from Column B if present).
 | Deputy Manager - Location 1 | Deputy
 | Registered Manager - Location 2 | Registered
 | Registered Manager - Location 3 | Registered
 | Registered Manager - Location 4 | Registered
 | Registered Manager - Location 7 | Registered
 | Service Manager - Location 8 | Service
 | Service Manager - Location 4 | Service
 | Registered Manager - Location 2 | Registered
 | Service Manager - Location 3 | Service
Spreadsheet: 599945d1543384263-need-a-formula-to-filter-data-sample
Sheet: Sheet1

Winner | [NAME] | Winner Score | [NAME] |  |  | Winner | [NAME] | Winner Score | [NAME] |  |  | Unique Winner | [NAME]
Emma | Jake | 3 | 2 |  |  | Emma | Jake
Jake | Sandra | 4 | 0
[NAME] | [NAME] | 2 | 1
Millie | Kait | 10 | 8
[NAME] | Emma | 1 | 0
Hamish | [NAME] | 9 | 8
Millie | [NAME] | 6 | 3
Emma | Kait | 5 | 2
Spreadsheet: 745594d1630036935-add-conditional-array-to-simple-if-formula-that-includes-blank-cells-rd-excel-forum-question
Sheet: 2010 Tax Brackets

 | Single | Married filing jointly
10% Bracket | $0 – $8,375 | $0 – $16,750
15% Bracket | $8,375 – $34,000 | $16,750 – $68,000
25% Bracket | $34,000 – $82,400 | $68,000 – $137,300
28% Bracket | $82,400 – $171,850 | $137,300 – $209,250
33% Bracket | $171,850 – $373,650 | $209,250 – $373,650
35% Bracket | $373,650+ | $373,650+
Spreadsheet: 94241d1294111583-min-max-timesheet-help-excel-example
Sheet: Sheet1

 | Min | [NAME] | Worksheet will generate --> | Doe, John40498 | <-- Criteria |  |  | Login | Logout | Login | Logout | Full Name | Login | Logout | Duration |  |  |  | Login |  | Logout
14:24:00 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/15/2010 7:45 AM | 11/15/2010 8:55 AM | 01:09:50 |  |  | 2010-11-15 00:00:00
0 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/15/2010 9:11 AM | 11/15/2010 11:49 PM | 14:38:07 |  | Doe, John40498 | 2010-11-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/16/2010 7:43 AM | 11/16/2010 7:59 AM | 00:15:42 |  |  | 2010-11-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/16/2010 8:01 AM | 11/16/2010 5:48 PM | 09:46:51 |  |  | 2010-11-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/17/2010 8:02 AM | 11/17/2010 4:30 PM | 08:28:29 |  |  | 2010-11-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/18/2010 7:47 AM | 11/18/2010 9:58 AM | 02:10:55 |  |  | 2010-11-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/18/2010 9:58 AM | 11/18/2010 12:06 PM | 02:07:31 |  |  | 2010-11-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/18/2010 12:06 PM | 11/18/2010 2:20 PM | 02:14:13 |  |  | 2010-11-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/18/2010 2:20 PM | 11/18/2010 2:24 PM | 00:03:38
 |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | 11/18/2010 2:24 PM | 11/18/2010 4:30 PM | 02:05:37 |  |  | Returning Data to this table.
 |  |  | Trying to find the min/[NAME] login/logout times as one day may have multiple entries.
Spreadsheet: 0212b7ac-f45f-4842-a6ce-d5746db5ede6
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
01/10/2014 | Gymnastics | at Kentucky | 12:00 AM | L, 195.0-193.7
01/10/2014 | Gymnastics | Penn State | 12:00 AM | L, 193.975-193.7
01/10/2014 | Gymnastics | [NAME] | 12:00 AM | W, 193.7-190.875
01/17/2014 | Gymnastics | at Maryland | 12:00 AM | L, 193.675-193.5
01/26/2014 | Gymnastics | NC State | 12:00 AM | W, 195.425-195.4
02/02/2014 | Gymnastics | [NAME] | 12:00 AM | W, 195.5-191.825
02/02/2014 | Gymnastics | Towson | 12:00 AM | W, 195.5-192.425
02/07/2014 | Gymnastics | at Iowa State* | 12:00 AM | L, 196.025-194.175
02/14/2014 | Gymnastics | Pitt (Beauty and the Beast) | 12:00 AM | W, 194.45-194.125
02/21/2014 | Gymnastics | vs. Oklahoma* (Perfect 10 Challenge at Oklahoma City) | 12:00 AM | L, 197.2-193.525
02/21/2014 | Gymnastics | vs. Alabama (Perfect 10 Challenge at Oklahoma City) | 12:00 AM | L, 197.1-193.525
02/21/2014 | Gymnastics | vs. Michigan (Perfect 10 Challenge at Oklahoma City) | 12:00 AM | L, 196.2-193.525
03/02/2014 | Gymnastics | Ohio State | 12:00 AM | W, 196.175-194.95
03/07/2014 | Gymnastics | at Florida | 07:00 PM | L, 198.325-194.925
03/16/2014 | Gymnastics | at Maryland | 02:00 PM | L, 195.525-194.975
[NAME] | Gymnastics | Big 12 Championship (Morgantown, W.Va.) | 04:00 PM | Third Place, 196.375
04/05/2014 | Gymnastics | NCAA Athens Regional Championships | 04:00 PM | Individual Results
04/18/2014 | Gymnastics | NCAA National Championships (Birmingham, Ala.) | 08:00 PM | Individual Results
Spreadsheet: 111934d1308163158-merging-two-worksheets-and-setting-a-migration-date-merge-excel-worksheets2
Sheet: Home Team Players

Name | Sport | stuff-c | stuff-d | stuff-e | stuff-f | Migration Date
[NAME] | Baseball | Baseball | Baseball | Baseball | Baseball | 2011-06-20 00:00:00
[NAME] | Hockey | Hockey | Hockey | Hockey | Hockey | 2011-06-21 00:00:00
[NAME] | Basketball | Basketball | Basketball | Basketball | Basketball | 2011-06-22 00:00:00
[NAME] | Football | Football | Football | Football | Football | 2011-06-21 00:00:00
[NAME] | Football | Football | Football | Football | Football | 2011-06-20 00:00:00
[NAME] | Football | Football | Football | Football | Football | 2011-06-22 00:00:00
[NAME] | Football | Football | Football | Football | Football | 2011-06-22 00:00:00
[NAME] | Baseball | Baseball | Baseball | Baseball | Baseball | 2011-06-20 00:00:00
Spreadsheet: 484282d1476201856-want-data-from-one-spreadsheet-to-auto-populate-to-another-elmer-fudd-realty-rents-2016
Sheet: Bldg 610

Building 610
Date | Building | Apt. # | Check # | Amount
 | 610
Spreadsheet: 691837d1597914821-looking-for-lookup-formula-that-will-copy-and-populate-another-sheet-propexample
Sheet: Sheet2

Propref | Title | First Name | Surname
59050002 | Mr | A | anyone
12130003 | Mrs | B | anyperson
12400003 | Miss | C | [NAME]
40100001 | Mr | D | testname
40100002 | Mrs | E | surnametest
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5305

5305 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 5ab03d6d-8341-4d1f-ada7-e6c36d6cbe72
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6850 | 41634 | [NAME] | Stockwell | USA | 68 | 00:12:39 | 00:02:09 | 00:58:31 | 00:01:46 | 00:26:26 | 1 | 01:41:31
6850 | 32629 | [NAME] | Reinertsen | USA | 67 | 00:16:25 | 00:02:38 | 00:55:29 | 00:01:12 | [NAME] | 2 | 01:42:29
6850 | 25150 | Scout | Bassett | USA | 65 | 00:21:59 | 00:03:15 | 01:01:21 | 00:02:01 | 00:31:50 | 3 | 02:00:26
6850 | 25135 | Kimberly | Fawcett | CAN | 66 | [NAME] | 00:03:29 | 01:07:03 | 00:02:49 | 00:47:45 | 4 | 02:20:39
Spreadsheet: 155996d1337130616-finding-the-row-name-for-a-value-in-an-array-mbender
Sheet: Sheet1

Name | Low Score |  |  | Min | Name
 |  |  |  |  | [NAME] | 10 | 11 | 6
 |  |  |  |  | fred | 8 | 2 | 7
 |  |  |  |  | [NAME] | 13 | 2 | 4
Spreadsheet: 67223d1267805220-excel-2007-help-required-in-function-multiple-conditions-to-be-fulfilled-hiiii
Sheet: Sheet1

 | 2010-03-05 00:00:00
Name | DOB | AGE
a | 1975-01-01 00:00:00 | 35.1972602739726
b | 1974-02-01 00:00:00 | 36.11232876712329
c | 1991-08-08 00:00:00 | 18.58630136986301
d | 1996-05-04 00:00:00 | 13.84383561643836
 | [NAME] | 300000 |  |  | 300000
 | Maximum Age | 36.11232876712329 |  |  | 400000
 | No of Persons | 4 |  |  | 500000
 | conditions
 | if c10 is 300000 & c11 is less than 36 & if c12 is 4 the Figure in c13 should come 6482 (this amount is mention in Sheet 2)
 | if c10 is 400000 & c11 is between 36-45 & if c12 is 3 then figure in c13 should come 7814( referance form sheet 2)
 | If there are only 3 persons in group & if we put age as 0 then how can it can be ignored in count ??????
Spreadsheet: larry_campbell__21591__December_1999_SA2_Version_Mapping
Sheet: Version

1999-12-01 00:00:00 |  |  | SA 2
Date | Current Invoice |  | Previous Rebill + True-Up
1999-12-01 00:00:00 | V-09 | minus | (V-08 + T-02)
1999-12-02 00:00:00 | V-08 | minus | (V-07 + T-02)
1999-12-03 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-04 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-05 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-06 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-07 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-08 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-09 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-10 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-11 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-12 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-13 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-14 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-15 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-16 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-17 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-18 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-19 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-20 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-21 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-22 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-23 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-24 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-25 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-26 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-27 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-28 00:00:00 | V-07 | minus | (V-06 + T-02)
1999-12-29 00:00:00 | V-08 | minus | (V-07 + T-02)
1999-12-30 00:00:00 | V-06 | minus | (V-05 + T-02)
1999-12-31 00:00:00 | V-07 | minus | (V-06 + T-02)
Spreadsheet: 87588d1287480985-merge-equal-cells-in-one-cell-merge
Sheet: Sheet1

1 | Red |  |  | 1
1 | Yellow |  |  | 2
1 | Green |  |  | 3
2 | Blue
2 | Black
3 | [NAME]
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Mkt Risk 

 | Market Risk
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total |  |  |  |  | 1699109
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 1
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 0
 |  |  |  |  |  |  |  | Managers | 90000 | 0
 | Headcount |  |  | 44 |  |  |  | Directors | 120000 | 4
 |  |  |  |  |  |  |  | Sr Director | 178800 | 1
 | Analysts & Associate Headcount |  |  | 5 | 0 |  |  | Vice President | 216000 | 1
 |  |  |  |  |  |  |  | [NAME] | 312000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC