tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 718710d1613308050-lookup-cell-value-based-on-other-cell-value-condition-book1
Sheet: Sheet1

 | Leave Calculator |  |  | Leave Entitlement per Year
 |  |  |  | 28 | 30 | 31 | 32 | 33
 | Leaving Date Window | 2020-04-01 00:00:00 | 2020-04-29 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0
 |  |  |  | 2.5 | 2.5 | 3 | 3 | 3 |  |  |  |  | 1
 |  |  |  | 5 | 5 | 5.5 | 5.5 | 5.5 |  |  |  |  | 2
 |  |  |  | 7 | 7.5 | 8 | 8 | 8.5 |  |  |  |  | 3
 |  |  |  | 9.5 | 10 | 10.5 | 11 | 11 |  |  |  |  | 4
 |  |  |  | 12 | 12.5 | 13 | 13.5 | 14 |  |  |  |  | 5 | <---- For INDEX/MATCH Formula
 |  |  |  | 14 | 15 | 15.5 | 16 | 16.5 |  |  |  |  | 6
 |  |  |  | 16.5 | 17.5 | 18.5 | 19 | 19.5 |  |  |  |  | 7
 |  |  |  | 19 | 20 | 20.5 | 21.5 | 22 |  |  |  |  | 8
 |  |  |  | 21 | 22.5 | 23.5 | 24 | 25 |  |  |  |  | 9
 |  |  |  | 23.5 | 25 | 26 | 27 | 27.5 |  |  |  |  | 10
 |  |  |  | 26 | 27.5 | 28.5 | 29.5 | 30.5 |  |  |  |  | 11
 |  |  | 2020-03-31 00:00:00 | 28 | 30 | 31 | 32 | 33
 |  |  | DOJ | Leaving Date | LOS months | Entitlement | [NAME] If more than 1 Year Service | [NAME] If less than 1 Year Service
 |  |  | 2020-07-25 00:00:00 | 2021-03-24 00:00:00 |  | 28
 |  |  |  |  | LOS years
 |  |  |  |  |  |  |  | <---- Combined Formula
 |  |  |  | For calculation  less or greater than 1 year
Spreadsheet: 788482d1658495534-max-value-in-a-row-max-value-for-five-extra-columns
Sheet: Blad1

ARTICLENR | NR of purchases A | Purhcaser B | Purchaser c | Purchaser d | Purchaser e |  | Article nr | Highest nr of purchases
E1 | 3 | 1 | 4 |  |  |  |  | 56 |  |  | 47 |  |  | 67 |  |  | 0 |  |  | 0
E2 | 5 | 4 | 35 |  |  |  | E8 | 27 |  | E7 | 45 |  | E5 | 58 |  | E2 | 0 |  | E2 | 0
E3 | 2 | 47 | 67 |  |  |  | E5 | 23 |  | E9 | 25 |  | E2 | 35 |  | E3 | 0 |  | E3 | 0
E4 | 56 | 6 | 23
E5 | 23 | 2 | 58
E6 | 12 | 7 | 2
E7 | 17 | 45 | 4
E8 | 27 | 14 | 1
E9 | 3 | 25 | 4
E10 | 6 | 3 | 6
Spreadsheet: 806178d1669144980-numbering-tasks-and-sub-tasks-task-numbering
Sheet: Sheet1

Product | Product # | Section | Section # | Sub-Section | Sub-Section # |  | Task ID Example | Task ID Goal
Print | 1 | Introduction | .00 | Purpose | .01 |  | Print; Introduction; Purpose; Sub Task | 1.00.01.01
Online | 2 |  |  | Background | .02 |  | Print; Introduction; Purpose; Sub Task | 1.00.01.02
App | 3 |  |  | Street Design Policy | .03 |  | Online; Geometry; Roadways/Lanes | 2.02.02
Plant Finder | 4 |  |  | Using This Manual | .04 |  | Online; Geometry; Roadways/Lanes; Sub Task | 2.02.02.01
 |  | Process | .01 | Introduction | .01 |  | Online; Geometry; Roadways/Lanes; Sub Task | 2.02.02.02
 |  |  |  | Operational Projects | .02
 |  |  |  | Capital Projects | .03
 |  |  |  | Case Studies | .04
 |  | Geometry | .02 | Introduction | .01
 |  |  |  | Roadways/Lanes | .02
 |  |  |  | Sidewalks/Raised Medians | .03
 |  |  |  | Traffic Calming | .04
 |  | Materials | .03 | Introduction | .01
 |  |  |  | Sidewalks | .02
 |  |  |  | Curbs | .03
 |  |  |  | Crosswalks | .04
 |  |  |  | Roadways | .05
 |  | Lighting | .04 | Introduction | .01
 |  |  |  | Standard Poles | .02
 |  |  |  | Distinctive/Historic Poles | .03
 |  |  |  | Signal Poles | .04
 |  | Furniture | .05 | Introduction | .01
 |  |  |  | Seating | .02
 |  |  |  | Bikes | .03
 |  |  |  | Information/Services | .04
 |  |  |  | Other Elements | .05
 |  | Landscape | .06 | Introduction | .01
 |  |  |  | Tree Beds | .02
 |  |  |  | Roadway Plantings | .03
 |  |  |  | Sidewalk Plantings | .04
 |  |  |  | Plaza Plantings | .05
 |  |  |  | Limited Access Arterial Plantings | .06
 |  |  |  | Stormwater Management Practices | .07
 |  | Programming | .07 | Introduction | .01
 |  |  |  | Community Initiated/Community Funded | .02
 |  |  |  | Community Initiated/DOT Funded | .03
 |  |  |  | DOT Initiated/DOT Funded | .04
 |  | Appendix | .08 | Glossary | .01
 |  |  |  | Appendix | .02
 |  |  |  | Index | .03
 |  | Preface | .09 | Commissioner Letter | .01
 |  |  |  | Preface | .02
 |  |  |  | Acknowledgments | .03
 |  |  |  | Acronyms | .04
Spreadsheet: 127403d1320338115-help-when-vlookups-just-arent-enough-data-test-sheet
Sheet: Project X

Project X ID Number | Activity Description | Master List ID Number
00LCC/02[A] | Activity A | 1300-305A
00LCC/03[C] | Activity B | 1300-395A
00LCC/23[A] | Activity C | 5000-234A
00LCC/23[B] | Activity D | 0100-100B
00LCC/24[A] | Activity E | 0600105A, 0200-074A, 0200-075A
0500/002[A] | Activity F | 1112-102D
0500/002[B] | Activity G | 5100105C, 0200-075A
1100/010[C] | Activity H | None
1100/010[D] | Activity I | 1112-102B, 1112-102C
1100/010[E] | Activity J | 1100-392D
2900/077[A] | Activity K | 1100-395C
2900/078[A] | Activity L | 0100-100B
2900/079[A] | Activity M | 1112-102A
5000/052[C] | Activity N | 1112-102C
Spreadsheet: 125248d1318946289-excel-2007-moving-values-between-sheets-by-using-number-commands-copy-of-afhendingase-lar-and-loadinfo
Sheet: Load Information

Date | Flight Number | A/C Registration |  | Departure Time |  | Routing
2011-10-13 00:00:00 | BBD 6809 | TF-BBH |  | 19:55z |  | KEF-CGN
# | ULD Number | ULD WT | Payload | Total Wt. | Dest | Contents | Remarks
 |  | (KG) | (KG) | (KG)
1 | PAJ 0063 BF | 120 | 755 | 875
2 | PAJ 0076 BF | 120 | 1089 | 1209
3 |  |  | 130 | 130
4 |  |  | 0 | 0
5 |  |  | 0 | 0
6 |  |  | 0 | 0
7 |  |  | 0 | 0
8 |  |  | 0 | 0
9 |  |  | 0 | 0
10 |  |  | 0 | 0
Hold 1 |  |  | 0 | 0
Hold 2 |  |  | 0 | 0
Hold 3 |  |  | 0 | 0
Hold 4 |  |  | 0 | 0
 | Total Weight : |  | 1974 | 2214
 | POS | [NAME] |  | [NAME]
 | 1 | 2540 |  | 2540
 | Hold 1 | 1150 |  | 1245
 | 2 | 2540 |  | 2540
 | Hold 2 | 1118 |  | 2540
 | 3 | 2540 |  | 2059
 | 4 | 4082 |  | 2540
 | 5 | 3288 |  | 4082
 | 6 | 2268 |  | 3310
 | 7 | 2268 |  | 2268
 | Hold 3 | 2336 |  | 3062
 | 8 | 2132 |  | 2268
 | Hold 4 | 1132 |  | 1125
 | 9 | 907 |  | 2132
 | 10 | N/A |  | 1360
Spreadsheet: 96281d1295688437-excel-2007-trying-to-use-data-validation-example-spreadsheet
Sheet: Cost Calculator

BEFORE |  |  |  |  |  |  | AFTER
 | Part# | Style | Size | Color | Price |  |  | Part# | Style | Size | Color | Price
Base cost of shirt | 1001 |  |  |  |  |  | Base cost of shirt | 1001 | Shirt | Size | Red | 3
Labor |  |  |  |  |  |  | Labor |  |  |  |  | 20
Materials |  |  |  |  |  |  | Materials |  |  |  |  | 15
Setup |  |  |  |  |  |  | Setup |  |  |  |  | 25
Quantity |  |  |  |  |  |  | Quantity |  |  |  |  | 20
 |  |  |  | Total |  |  |  |  |  |  | Total
Spreadsheet: 138475d1327678844-conditional-formating-testexcel
Sheet: Sheet1

2 | 1
5 | 2
3 | 5
8 | 3
9 | 54
10 | 34
11 | 2
12 | 1
5 | 6
2 | 53
4 | 156
8 | 4
6 | 12
4 | 1
13 | 54
32 | 35
2 | 1
45 | 38
231 | 3
1534 | 1
Spreadsheet: 110871d1307452928-hlookup-to-another-workbook-lam-monitor-template
Sheet: Sheet1

Deva Hawarden Laminator Summary
 | Job Information |  |  | Breakdown Event Log |  |  |  | SA [NAME] |  |  |  | Downtime Events Summary |  |  | SA Downtime Summary |  |  | Total Downtime (mins)
 | Job Number |  |  | Date/Time | Reason | Duration |  | Date/Time | Reason | Duration |  | Reason | Duration |  | Reason | Duartion
 | Start Time
 | End Time
 | Production Time (mins)
Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 5-26

ES3/C&S WHOLESALE LOAD TRACKING
STOP 1 WILL ALWAYS BE ORIGIN - LEAVE SECTION BLANK FOR ANY NON-APPLICALBE STOP, ON ANY GIVE LOAD
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | L111 | 42601 | Hammond |  |  |  | 461 |  |  |  |  |  | 525
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21858 | 42602 | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21709 | 42603 | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 32804 | 42604 | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21329 | 42605 | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 32537 | 42606 | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
Spreadsheet: 118523d1313746389-date-caluclator-to-exclude-weekends-interview-dates
Sheet: Sheet1

Start date | No of Weeks to book Interview | Intweview date
2011-01-01 00:00:00 | 14 | 2011-04-11 00:00:00
2011-01-02 00:00:00 | 14 | 2011-04-11 00:00:00
2011-01-03 00:00:00 | 14 | 2011-04-11 00:00:00
2011-01-04 00:00:00 | 14 | 2011-04-12 00:00:00
2011-01-05 00:00:00 | 14 | 2011-04-13 00:00:00
2011-01-06 00:00:00 | 14 | 2011-04-14 00:00:00
2011-01-07 00:00:00 | 14 | 2011-04-15 00:00:00
2011-01-08 00:00:00 | 14 | 2011-04-18 00:00:00
2011-01-09 00:00:00 | 14 | 2011-04-18 00:00:00
2011-01-10 00:00:00 | 14 | 2011-04-18 00:00:00
2011-01-11 00:00:00 | 14 | 2011-04-19 00:00:00
2011-01-12 00:00:00 | 14 | 2011-04-20 00:00:00
Spreadsheet: 110747d1307373870-concatenate-a-big-range-of-cells-udf-concatenate-range-concrange-
Sheet: Sheet1

 |  |  |  |  |  |  | No separator
Can | you | put | this | into | one | cell? | Canyouputthisintoonecell?
Can
you
put
this
into
one |  |  |  |  |  |  | " " separator (space)
cell? |  |  |  |  |  | - Yes! | Can you put this into one cell? - Yes! | Can you put this into one cell?
Can
 | you
 |  | put
 |  |  | this
 |  |  |  | into
 |  |  |  |  | one
cell? |  |  |  |  |  | - Yes! | Can you put this into one cell? - Yes!
How to use
If you don't need separators use like this
otherwise
The separator can be any string you might need.
The range can be any size or shape, the function will concatenate by Columns left to right, then by Rows, omitting any blank cells
 |  |  |  |  |  |  | Can you put this into one cell? - Yes!  The separator can be any string you might need.  The range can be any size or shape, the function will concatenate by Columns left to right, then by Rows, omitting any blank cells | By using builtin CONCATENATE and [NAME] together Use Char(10) to start a new line. Use Char(10)&Char(10) to separate with a blank line. Then apply Wrap Text
Spreadsheet: 125084d1318871896-adding-a-column-without-damage-to-sheet-copy-of-box-inventory1
Sheet: Crane Dust

 |  | Crane Dust Vacuum Box Inventory
Box # | Start Date | 50 Day | 70 Day | Box Location | Box Weight Empty | Material Weight | Delivered to Staging | Issues
2 | 2011-09-10 00:00:00 |  |  | Baghouse | 8890 | 16040 |  | utilizing
15 | 2011-08-22 00:00:00 |  |  |  | 9080 | 29420 | 2011-10-01 00:00:00 | ready to ship
16 | 2011-08-17 00:00:00 |  |  | Baghouse | 9440 |  |  | remove 8,000lbs
18 | empty |  |  | Baghouse | 9290 |  |  | empty
 | Baghouse
 | Transfer Tower
 | Dedust
 | Fans
Spreadsheet: 789572d1659189767-separate-h-m-s-in-a-non-time-formatted-cell-sample
Sheet: Sheet3

Vehicle | Idle Event Start | Idle Event End | Idle Event Duration | Fuel Used
101-Stakebed-1649 | 2022-06-01 08:34:00 | 2022-06-01 08:40:00 | 6m 12s | 0.11
101-Stakebed-1649 | 2022-06-01 15:06:00 | 2022-06-01 15:09:00 | 2m 43s | 0.02
101-Stakebed-1649 | 2022-06-08 07:45:00 | 2022-06-08 07:56:00 | 11m 41s | 0.16
101-Stakebed-1649 | 2022-06-08 10:32:00 | 2022-06-08 10:41:00 | 9m 9s | 0.18
101-Stakebed-1649 | 2022-06-08 15:25:00 | 2022-06-08 15:29:00 | 4m 22s | 0.03
101-Stakebed-1649 | 2022-06-08 15:31:00 | 2022-06-08 15:33:00 | 2m 39s | 0.02
101-Stakebed-1649 | 2022-06-09 07:33:00 | 2022-06-09 07:55:00 | 22m 48s | 0.23
101-Stakebed-1649 | 2022-06-09 08:45:00 | 2022-06-09 08:58:00 | 12m 57s | 0.12
101-Stakebed-1649 | 2022-06-09 14:58:00 | 2022-06-09 15:00:00 | 2m 28s | 0.02
101-Pickup-6314 | 2022-06-14 15:07:00 | 2022-06-14 15:58:00 | 51m 9s | 0.15
101-CDL-7391 | 2022-06-30 16:42:00 | 2022-06-30 17:00:00 | 18m 12s | 0.36
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: QTD Recon Q1FY13

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended June 30, 2012
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Certain non-recurring litigation expenses | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Lease Obligation (G&A) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 955 |  | 0 |  | 0 |  | 0 | -464 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 491
Cost of revenue | 205 |  | -15 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -1 |  | 0 |  | 189
Gross profit | 750 |  | 15 |  | 0 |  | 0 | -464 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 302
Operating expenses:
Marketing and sales | 145 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -7 |  | 0 |  | 138
General and administrative | 86 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 77
Research and development | 290 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | -22 |  | 0 |  | 268
Acquisition-related contingent consideration | -20 |  | 20 |  | 0 |  | 0 | 0 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 7 |  | -7 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 27 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | -27 |  | 0 |  | 0 |  | -
Total operating expenses | 535 |  | 13 |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | -27 |  | -38 |  | 0 |  | 483
Operating income (loss) | 215 |  | 2 |  | 0 |  | 0 | -464 |  | 0 |  | 0 |  | 27 |  | 39 |  | 0 |  | -181
Interest and other income (expense), net | -5 |  | 0 |  | 5 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for (benefit from) income taxes | 210 |  | 2 |  | 5 |  | 0 | -464 |  | 0 |  | 0 |  | 27 |  | 39 |  | 0 |  | -181
Provision for (benefit from) income taxes | 9 |  | 0 |  | 0 |  | 0 | 0 |  |  |  |  |  | 0 |  | 0 |  | -60 |  | -51
Net income (loss) | 201 |  | 2 |  | 5 |  | 0 | -464 |  | 0 |  | 0 |  | 27 |  | 39 |  | 60 |  | -130
Earnings per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loss per share
Basic | 0.63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic and diluted |  |  |  | -0.41
Diluted | 0.63
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic | 317 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basic and diluted |  |  |  | 317
Diluted | 320
Spreadsheet: 116705d1312032214-masterfile-to-subfile-updating-transaction
Sheet: 0002

Contact Person | Com Code | Company | Truck ID | Make | Model | Date | Job Description | Parts | Hours | Call No | Inv Amt | Paid | 2nd Pay | 3rd Pay | Balance |  | Total O/S
Mr [NAME] | 0002 | ABD Wholesalers | FL1234 | Nissan | PL02A26 | 25.06.11 | brake service |  | 8 | 1409 | 500 | 100 | 100 |  | 300
Mr [NAME] | 0002 | ABD Wholesalers | FL1233 | Toyota | AGE25D | 28.07.11 | lube service |  | 4 | 1412 | 250 |  |  |  | 250
Spreadsheet: 63023d1263995263-linking-sheets-and-cells-test1
Sheet: B2B_SCPO

Sender
 | NameSpace | DataTypes | MessageTypes | MM | IM | [NAME] | Re-Usable Objects | Confguration Scenario
 |  |  |  |  |  |  |  | x
Receiver
 | NameSpace | DataTypes | MessageTypes | MM | IM | [NAME] | Re-Usable Objects | Confguration Scenario
 |  |  |  |  |  |  |  | y
 |  |  |  |  |  |  |  | z
Spreadsheet: 00eff674-be24-453c-b7f0-5c3c0d5fd27b
Sheet: UNSOM New Hire

Salary Reduction Worksheet
Before Cuts:
Base Salary  (A) | [NAME]   (A)
Stipend
Contract |  |  | (B) |  |  |  |  | (C) |  | (D)
 |  |  | Annual | Annual |  | Annual |  |  | Annual | Monthly
Base Source: |  |  | 2.5% Reduction | Adjusted Base | FTE | Adjusted Base |  | Monthly Base | 2.3 % Unpaid Leave | 2.3 % Unpaid Leave | Annual Adjusted | Monthly Adjusted Pay
 | State |  | 0 |  | 1
 | Practice Plan |  | 0
 | Hospital |  | 0
 | Grants
Total
 |  |  |  |  |  |  |  |  | Stipend
 |  |  |  |  |  |  |  |  | (E) Annualized
 |  |  |  |  |  |  |  |  | Adjusted Pay
 | Salary Reduction Worksheet - Employer Paid PERS
WITH EPA ADJUSTMENT OF .88594
Before Cuts:
Base Salary  (A)
Stipend
Contract |  |  | (B) |  |  |  |  | (C) |  | (D)
 |  |  | Annual | Annual |  | Annual | 0.88594 |  | Annual | Monthly
Base Source: |  |  | 2.5% Reduction | Adjusted Base | FTE | Adjusted Base | EPA Adj | Monthly Base | 2.3 % Unpaid Leave | 2.3 % Unpaid Leave | Annual Adjusted | Monthly Adjusted Pay
 | State w/EPA |  | 0 |  | 1
 | Soft w/EPA |  | 0
 | Other w/EPA |  | 0
 | Grants w/EPA
Total
 |  |  |  |  |  |  |  |  | Stipend
 |  |  |  |  |  |  |  |  | (E) Annualized
 |  |  |  |  |  |  |  |  | Adjusted Pay
Spreadsheet: 688649d1595888916-using-data-validation-to-link-data-to-different-locations-excel-help-2
Sheet: Pro-Forma Balance sheet Final

 | Opening 2012 | Adjustments  + | Adjustments - | ProForma  2012
Cash and Cash Equivalents | 250 |  | -250
Accounts Receivables | 450
Inventories | 600
Prepaids and Other Current Assets | 175
Total Current Assets
Property, Plant and Equipment, Net | 2500
Goodwill | 1000
Intangible Assets | 875
Other Assets | 150
Deferred Financing Fees |  | 90
Total Assets
Accounts Payable | 215
Accrued Liabilities | 275
Other Current Liabilities | 100
Total Current Liabilities
Revolving Credit Facility
Term Loan A
Term Loan B |  | 2150
Term Loan C
2nd [NAME]
Existing Bank Debt | 1000 |  | -1000
Senior Notes
Senior Suboridinate Notes
Senior Suboridinate Notes
Senior Bridge Facility
Senior Subordinate Bridge Facility
Existing Bond Debt | 500 |  | -500
Mezzanine Debt
Existing Mezzanine Debt
Deferred Income Taxes | 300
Other-Long Term Liabilities | 110
Total Liabilities
[NAME] | 0
Shareholders Equity | 3500
Existing Shareholders Equity
Total Shareholders Equity
Total Liabilities and Equity
Spreadsheet: thomas_martin__39855__2002 Plan Worksheet CC150297
Sheet: Income Statement

Income Statement - ($000s)
Texas Gas Trading (150297)
 |  |  | 2001 Forecast |  | 2002 Plan |  | [NAME]
Originations |  | $ | 0 | $ |  | $
Trading |  |  | 151909
FV-Investments |  |  | 0
Accrual |  |  | 0
Operating Expenses |  |  | 0
Other |  |  | 0
Total Margin |  | $ |  | $ |  | $
Capital Charge |  |  | 0 |  | 0
Total Margin Net of Capital Charge |  | $ |  | $ |  | $
Compensation/Taxes and Benefits
Employee Expense
Travel/Entertainment
Consulting
Office
Controllable Infrastructure
System Development
Insurance
Analyst Associates (includes Comp, Taxes & Benefits and Allocation)
Other Expense
Outside Legal
Outside Tax
Depreciation & Amortization
Total Direct Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive |  |  | 2 |  | 2
Director |  |  | 0 |  | 0
Manager |  |  | 1 |  | 4
Analyst and Associates
Support Departments |  |  | 1 |  | 1
Total Headcount
2002 Plan (in thousands) |  |  | Team |  | ENA Total
Direct Expense Ratio |  | $ |  | $
Productivity [NAME] |  | $ |  | $
ROCE
Spreadsheet: 117193d1312493759-nested-sumifs-sample
Sheet: Case Scenarios

 |  |  |  |  |  |  | Cumm. |  | Cumm | Qtrly
 |  | Randomness |  | No |  |  | Qtr | Qtr | 0
 |  | End of first operating quarter |  |  |  |  | 1 | 4Q11
 |  |  |  |  |  |  |  | 1Q12
 |  | Model Variable #1 |  |  |  |  |  | 2Q12
 |  | Success Rate (out of 10) |  | Return Low | Return High |  |  | 3Q12
 |  | Strong | 3 | 2 | 3.5 |  |  | 4Q12
 |  | Moderate | 3 | 1.2 | 2 |  |  | 1Q13
 |  | Poor | 1 | 0.8 | 1.2 |  |  | 2Q13
 |  | Fail | 3 | 0 |  |  |  | 3Q13
 |  |  |  |  |  |  |  | 4Q13
 |  |  |  |  |  |  |  | 1Q14
 |  | Model Variable #2 |  |  |  |  |  | 2Q14
 |  | Target Investment Commitment (US$, 000s) |  |  |  |  |  | 3Q14
 |  |  | Annual | Per Qtr |  |  |  | 4Q14
 |  | 2011 | 25000 |  |  |  |  | 1Q15
 |  |  | 30000 |  |  |  |  | 2Q15
 |  |  | 35000 |  |  |  |  | 3Q15
 |  |  | 40000 |  |  |  |  | 4Q15
 |  |  | 45000 |  |  |  |  | 1Q16
 |  | 2016 | 50000 |  |  |  |  | 2Q16
 |  |  |  |  |  |  |  | 3Q16
 |  | Model Variable #3 |  |  |  |  |  | 4Q16
 |  | Per Investment Commitment Limitations (US$, 000s) |  |  |  |  |  | 1Q17
 |  | Min | [NAME] |  |  |  |  | 2Q17
 |  | 1000 | 5000 |  |  |  |  | 3Q17
 |  |  |  |  |  |  |  | 4Q17
 |  | Model Variable #4 |  |  |  |  |  | 1Q18
 |  | Length of Case (Quarters) |  |  |  |  |  | 2Q18
 |  | Min | [NAME] |  |  |  |  | 3Q18
 |  | 4 | 12 |  |  |  |  | 4Q18
 |  |  |  |  |  |  | Potential | Actual | 1
 |  | Case | Commencement | Investment | Length ([NAME]) | Success | Payout | Payout | IRR | 4Q11 | 1Q12 | 2Q12 | 3Q12 | 4Q12 | 1Q13 | 2Q13 | 3Q13 | 4Q13 | 1Q14 | 2Q14 | 3Q14 | 4Q14 | 1Q15 | 2Q15 | 3Q15 | 4Q15 | 1Q16 | 2Q16 | 3Q16 | 4Q16 | 1Q17 | 2Q17 | 3Q17 | 4Q17 | 1Q18 | 2Q18 | 3Q18 | 4Q18
 |  | 1
 |  |  |  |  | Strong |  | Total Disbursements
 |  |  |  |  | Moderate |  | Total Receipts
 |  |  |  |  | Poor |  | Net Cash Flows
 |  |  |  |  | Fail |  | Cumulative Cash Flows
 |  |  |  |  |  |  | Committed Capital
 |  |  |  |  |  |  | Disbursed Capital
 |  |  |  |  |  |  | Open Cases
 |  |  |  |  |  |  | Disbursed/Committed Capital
 |  |  |  |  |  |  | Impairment
 |  |  | Expense Allocation
 |  |  | Quarters | 1
 |  |  | 4 | 0.2 | 0.2 | 0.2 | 0.4
 |  |  |  | 0.08 | 0.12 | 0.18 | 0.23 | 0.39
 |  |  |  | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.35
 |  |  |  | 0.03 | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.32
 |  |  |  | 0.025 | 0.055 | 0.08 | 0.09 | 0.14 | 0.14 | 0.19 | 0.28
 |  |  |  | 0.021 | 0.039 | 0.06 | 0.09 | 0.1 | 0.12 | 0.15 | 0.17 | 0.25
 |  |  |  | 0.02 | 0.04 | 0.05 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.16 | 0.23
 |  |  |  | 0.015 | 0.02 | 0.03 | 0.045 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.18 | 0.21
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.05 | 0.065 | 0.08 | 0.105 | 0.12 | 0.15 | 0.16 | 0.19
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.045 | 0.055 | 0.07 | 0.08 | 0.1 | 0.12 | 0.13 | 0.15 | 0.17
 |  |  |  | 0.005 | 0.015 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.085 | 0.105 | 0.11 | 0.13 | 0.13 | 0.15