tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 754584d1636351548-countifs-and-indirect-formula-when-there-are-more-than-one-criteria-countifs-example
Sheet: Music

Name | Staff ID | Staff type | Employed as/student type | Job description
Name 1 | ID 1 | Non-academic | Honorary | Honorary Research Fellow
Name 2 | ID 2 | Non-academic | Honorary | Senior Honorary Research Fellow
Name 3 | ID 3 | Non-academic | Staff | Administrative Assistant
Name 4 | ID 4 | Academic | Teaching & Research | Associate Professor | 1
Name 5 | ID 5 | Non-academic | Staff | Venue Assistant
Name 6 | ID 6 | Academic | Teaching & Research | Lecturer | 0
Name 7 | ID 7 | Academic | Teaching & Research | Senior Lecturer | 0
Name 8 | ID 8 | Academic | Teaching | Lecturer | 3
Name 9 | ID 9 | Academic | Teaching & Research | Senior Lecturer | 0
Name 10 | ID 10 | Academic | Teaching & Research | Lecturer | 0
Name 11 | ID 11 | Non-academic | Honorary | Honorary Research Fellow
Name 12 | ID 12 | Academic | Teaching & Research | Academic Development Officer | 2
Name 13 | ID 13 | Academic | Teaching & Research | Senior Lecturer | 2
Spreadsheet: 723137d1615539385-count-cells-with-and-without-data-copy-of-brenda-new-moderation_ray
Sheet: Sheet1

 | Human | Machine
Reason 1
Reason 2
Reason 3
Reason 4
Reason 5
Reason 6
Reason 7
Reason 8
Reason 9
Reason 10
Reason 11
Reason 12
Reason 13
Reason 14
Reason 15
Reason 16
Reason 17
Reason 18
Reason 19
Spreadsheet: stacey_white__38881__2001 01 Upcoming PMAs Report
Sheet: 200101 Upcoming PMAs

UPCOMING PMAs (DPR Exposure Items)
 | 0101 PMAs >$15,000  (Adjustments Made During CheckOut After 1st Workday)
 | TYPE | INITIALS | CUSTOMER | DESK CODE | REGION | DEL PERIOD | VOLUME | $$ | EXPLANATION
 | (P,S,T |  |  | (EPMI- |  | (PROD MONTH) | [NAME] | [NAME]
 | DP, DR, etc) |  |  |  |  |  |  | (+ = income)
NOTES (I.e., Carryforward) |  |  |  |  |  |  |  | (- = expense)
 | T | KMD | Cinergy Services | EPMI-ST-ECAR | R4A | 2001-01-02 00:00:00 |  | -40302.61 | 523291.1- annuity added to adjust 1-01 transmission.
carryover | T | KMD | Entergy Power Marketing | EPMI-ST-HOURLY | R3B | 2000-11-01 00:00:00 | 157 | 46629 | 448927.1- BR deal was entered with incorrect price on 11/1 HE 21.  157mw was entered with a price of $300 changed to $3.
 | T | KMD | Entergy Power Marketing | EPMI-HOURLY-SE | R5 | 2001-01-02 00:00:00 |  | 49312.5 | BR deal #501485.1- entered with an incorrect price of 25mw @$1976.25 to $3.75 1/20 HE 1
 | PA | KMD | Florida Power & Light | EPMI-ST-SRC | R3A | 2001-01-02 00:00:00 |  | -50248.01 | 91395.33-  annuity added to adjust 1-01 est prices to actual invoice payable.
carryover | T | KMD | MAPPCOR | EPMI-ST-MAPP | R4A | 2000-12-01 00:00:00 |  | -63507.44 | Adjustments made to true up 12-00 transmission invoice for MAPPCOR
 | T | KMD | MAPPCOR | EPMI-ST-MAPP | R4A | 2001-01-02 00:00:00 |  | -135581.81 | True up of 1-01 transmission
 | S | JW | Reliant Energy Services | EPMI-ST-PJM | R1E | 2001-01-01 00:00:00 | 0 | 36770.45 | Mult deals - index price adjustment - PJM Western
 |  | EAST TOTAL (Regions 1-6)
 | S | AHC | Colorado Springs Utilities | EPMI-LT-SW | R7A | 2001-01-01 00:00:00 | 0 | 32000.02 | Multiple Deals - Price change from $20.08 to $28.08 on 4000 mws for days 1/4-1/10 & 1/19-1/23 - changes made on 2/9/01 DMS #6706
 | S | MC | Conoco Power Marketing Inc. | EPMI-LT-NW | R9 | 2001-01-01 00:00:00 | 0 | 26933.76 | Index price adjustment for DJ-MC-Sunday - Deals #347356.3 & 485393.3
 | P | JW | PGE Energy Trading POW | EPMI-LT-CA | R11 | 2001-01-01 00:00:00 | 364560 | 76510.62 | Mult deals - index price adjustment - PXSP15
 | P | AC | Tosco Refining Co | EPMI-ST-CA | R10 | 2001-01-01 00:00:00 | 153 | 42424.96 | Multiple Deals - Portland (K Nelson) Is Actualizing & PXNP15 Index Price Adjustment
 | PA | EL | TransAlta Energy Marketing (US) Inc. | EPMI-ST-CA | R10 | 2001-01-01 00:00:00 | 0 |  | 491782.1 SC trades Sept00-Dec00 $67,036.00 entered as PA but sb SA (H.Dutton)
 | P | AHC | WAPA - CRSP | EPMI-ST-SW | R7A | 2001-01-01 00:00:00 | 460 | -69146.28 | 420886.104 - Deal was zeroed out it was a duplicate of leg .103; it was not routed in scheduling so there is no offset; DMS #6591 change made on 2/9/01
 |  | WEST TOTAL (Regions 7-12)
 |  | GRAND TOTAL
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: Credit Card

Credit Card
MONTH | YEAR | APR | PAYMENT | BALANCE
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008 | 18
January | 2009 | 18
February | 2009
March | 2009
April | 2009
May | 2009
June | 2009
July | 2009
August | 2009
September | 2009
October | 2009 |  | 200
November | 2009 |  | 300
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 753608d1635558304-sum-values-non-contiguous-cells-if-date-for-the-corresponding-value-is-or-start-date-dy-calculation-xf
Sheet: Sheet1

 | Quarters | Percentage | O Qty | Date | DV | UV | Date | Qty | Date | Qty | Date | Qty
 | 1st Quarter: |  | 1000 | 1999-07-22 00:00:00 | 40 | 20 | 1999-07-12 00:00:00 | 100 | 1999-07-11 00:00:00 | 50 | 1999-07-10 00:00:00 | 25
 | 2nd Quarter:
 | 3rd Quarter:
 | 4th Quarter:
 | I am endeavouring to calculate a percentage for the following example:
 | Row 4: IF the Date in E4> Then any of the Dates H4,J4,L4 Then (F4/(G4*D4+any values in I4 & K4 where the date in H4 & J4 are less then E4
 | - value in M4 where the date in L4 is less then the date in E4) the answer will be in a cell C4 formatted for percentage.
 | Rows 5,6 & 7 will need the same calculation with the inclusion of any values from the previous row where values with dates > then the date in column E on the previous row.
 | I have tried numerous formulas, and have come to the realisation that I need represent dates in the formula
 | I have found a lot of information to do this referencing a range, but can't find anything using non contiguous cells.
 | Any assistance will be greatly appreciated.
 |  |  |  | 1999-07-22 00:00:00 |  |  | 1999-07-22 00:00:00
 |  |  |  | 1999-07-24 00:00:00 | 100 |  | 1999-07-24 00:00:00 | 100
 |  |  |  | 1999-07-11 00:00:00 | 50 |  | 1999-07-11 00:00:00 | 50
 |  |  |  | 1999-07-10 00:00:00 | 25 |  | 1999-07-10 00:00:00 | 25
Spreadsheet: a9549158-1d9b-44e1-8ed7-44ed1a531ecf
Sheet: Text View

Timetable Worksheet
Winter 2010
Day | Course | Start Time | End Time | Location
Monday | PED-1003-03 Physical Education and Rec.Al | 9:30am | 10:30am | A110
Monday | CPT-1073-02 Database | 10:30am | 11:30am | D101
Monday | JSS-1001-02 Job Search and Success | 2:30pm | 3:30pm | A223
Monday | ACC-1013-03 Small Office Accounting | 3:30pm | 4:30pm | M207
Tuesday | WPA-1204-02 Intermediate Word Processing | 8:30am | 10:30am | D101
Tuesday | ENG-2123-01 Business Correspondence I | 1:30pm | 2:30pm | B106
Tuesday | ACC-1013-03 Small Office Accounting | 2:30pm | 3:30pm | M211
Wednesday | PED-1003-03 Physical Education and Rec.Al | 9:30am | 10:30am | A110
Wednesday | OFP-1023-02 Office Management | 10:30am | 12:30pm | D101
Thursday | PED-1003-03 Physical Education and Rec.Al | 9:30am | 10:30am | K203
Thursday | ENG-2123-01 Business Correspondence I | 10:30am | 11:30am | N208
Thursday | CPT-1073-02 Database | 12:30pm | 2:30pm | D101
Friday | WPA-1204-02 Intermediate Word Processing | 8:30am | 10:30am | D101
Friday | ENG-2123-01 Business Correspondence I | 1:30pm | 2:30pm | A210
Friday | ACC-1013-03 Small Office Accounting | 2:30pm | 3:30pm | M207
Spreadsheet: 638993d1566906041-allocation-formula-to-allocate-excess-stocks-to-required-inter-trasnfer-file-test
Sheet: Shortage

Sku Code | To Store | Incoming Stock | Qty Needed | cumulative requested | From | Allocated | Balance | Action
1000058 | Opening | 6 | 0
1000060 | Opening | 9 | 0
1000061 | Opening | 0 | 0
1000058 | HKP06 |  | 3 |  | hpp28
1000058 | HHP20 |  | 4 |  | hpp28
1000058 | HHP30 |  | 4 |  | hpp28
1000058 | HHP28 |  | 5 |  | hpp28
1000060 | HHP27 |  | 2 |  | hpp28
1000060 | HKP22 |  | 5 |  | hpp28
1000061 | [NAME] |  | 1 |  | hpp28
1000061 | HKP25 |  | 1 |  | hpp28
1000061 | HKP06 |  | 2 |  | hpp28
Spreadsheet: 114370d1310117732-help-with-automatic-data-display-after-choice-from-drop-down-menu-copy-of-training_request_test
Sheet: Sheet2

COURSE | LENGTH | PO# | COST
1 | 5 | 2 | 100
2 | 3 | 3 | 200
3 | 2 | 4 | 300
4 | 1 | 5 | 400
Spreadsheet: 700144d1603001614-find-row-header-based-on-table-and-column-headers-reverse-lookup-index-and-match-excel-forum
Sheet: Sheet1

 | QUARTERS PTS |  |  |  |  | ACTUAL |  |  |  | DESIRED OUTPUT
PLAYERS | Q1 | Q2 | Q3 | Q4 |  | PLAYERS | QUARTER | POINTS |  | PLAYERS | QUARTER | POINTS
P1 | 10 | 25 | 33 | 40 |  |  | Q1 | 10 |  | P1 | Q1 | 10
P2 | 12 |  | 32 |  |  |  | Q1 | 11 |  | P3 | Q1 | 11
P3 | 11 | 22 | 34 |  |  |  | Q1 | 12 |  | P2 | Q1 | 12
P4 |  | 21 | 38 |  |  |  | Q1 | 14 |  | P7 | Q1 | 14
P5 |  |  | 31 |  |  |  | Q2 | 21 |  | P4 | Q2 | 21
P6 |  |  | 37 |  |  |  | Q2 | 22 |  | P3 | Q2 | 22
P7 | 14 |  |  |  |  |  | Q2 | 25 |  | P1 | Q2 | 25
P8 |  |  | 39 |  |  |  | Q2 | 26 |  | P9 | Q2 | 26
P9 |  | 26 |  |  |  |  | Q3 | 31 |  | P5 | Q3 | 31
 |  |  |  |  |  |  | Q3 | 32 |  | P2 | Q3 | 32
 |  |  |  |  |  |  | Q3 | 33 |  | P1 | Q3 | 33
 |  |  |  |  |  |  | Q3 | 33 |  | P3 | Q3 | 34
 |  | Q1 | 10 |  |  |  | Q3 | 34 |  | P6 | Q3 | 37
 |  |  |  |  |  |  | Q3 | 37 |  | P4 | Q3 | 38
 |  |  |  |  |  |  | Q3 | 39 |  | P8 | Q3 | 39
 |  |  |  |  |  |  | Q4 | 40 |  | P1 | Q4 | 40
Spreadsheet: 490440d1479853906-important-maintenance-check-list-that-must-be-done-micosmiling
Sheet: Battery topping up

Weekly Battery Topping Up Program
Index | model | model id | 2016-11-07 00:00:00 | 2016-11-14 00:00:00 | 2016-11-21 00:00:00 | 2016-11-28 00:00:00 | 2016-12-05 00:00:00 | 2016-12-12 00:00:00 | 2016-12-19 00:00:00 | 2016-12-26 00:00:00 | 2017-01-02 00:00:00 | 2017-01-09 00:00:00 | 2017-01-16 00:00:00 | 2017-01-23 00:00:00 | 2017-01-30 00:00:00 | 2017-02-06 00:00:00 | 2017-02-13 00:00:00
 |  |  | caz | [NAME] | caz | bob | shift b | shift b
1 | eje | 1 | yes | yes | yes | no | yes | yes
2 | eje | 2 | no | yes | yes | yes | yes | yes
3 | eje | 3 | yes | yes | yes | yes | yes | yes
4 | eje | 4 | no | yes | yes | yes | yes | yes
5 | ece | 1 | yes | yes | no | yes | yes | no
6 | ece | 2 | yes | yes | yes | yes | yes | yes
7 | ece | 3 | yes | no | no | yes | no | no
8 | JCB | 5 | yes | yes | yes | yes | yes | yes
9 | JCB | 6 | yes | yes | yes | yes | yes | yes
10 | JCB | 17 | yes | yes | yes | no | yes | yes
 | Print off check list |  |  |  |  | Engineers/shift |  |  | This is a weekly battery topping up program for vehicles. The real list is over a thousand vehicles across many sites. I need to flag up and print off the vehicles that for one week have not been topped up (highlighted in orange hopefully by conditional formatting )and then the red ones are very urgent and need to be done as well. Also i'd like to make the engineer accountable if he didn't manage to top it up. The print off check list is printed off and manually filled out each week and then handed to a manager who enters the completed ones in manually.
 | Date |  | Engineer/shift |  |  | [NAME]
 | model | model id | Completed |  |  | rico
 | eje | 1 |  |  |  | caz
 | eje | 2 |  |  |  | bob
 | eje | 3 |  |  |  | shift a
 | eje | 4 |  |  |  | shift b
 | ece | 1 |  |  |  | shift c
 | ece | 2
 | ece | 3
 | JCB | 5
 | JCB | 6
 | JCB | 17
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, November 16 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 850674d1701080688-week-numbers-with-reference-to-dates-week-numbers-1-
Sheet: Revised

 |  | ACTIVITY | START | END | [NAME] | [NAME] | Duration  (Weeks) |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays (Other than Saturdays and Sundays)
 | A) | Project Proposals and Budget Approvals | 2023-09-20 00:00:00 | 2023-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-26 00:00:00
 | A) | Govt.approvals for Expansion (PCB, Power, Water, factories dept.) | 2023-11-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00
 | B) | Main Factory & Aux Buildings, VDF Flooring | 2023-11-15 00:00:00 | 2024-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-15 00:00:00
 | 1 | Civil Design & Finalisation of Civil contractor | 2023-11-15 00:00:00 | 2023-12-31 00:00:00
 | 2 | Structure Construction (Footings, Beams Etc.) | 2024-01-01 00:00:00 | 2024-03-15 00:00:00
 | 3 | Flooring: RCC / PCC / VDF & Finishing works | 2024-03-15 00:00:00 | 2024-06-30 00:00:00
 | B)1 | RCC ROADS / STORM WATER DRAINAGES | 2024-03-15 00:00:00 | 2024-05-15 00:00:00
 | D) | Steel Building | 2023-11-01 00:00:00 | 2024-04-30 00:00:00
 | 1 | Design & Detailing | 2023-11-01 00:00:00 | 2023-12-31 00:00:00
 | 2 | Production / Shipment | 2024-02-01 00:00:00 | 2024-04-15 00:00:00
 | 3 | Building Erection | 2024-02-15 00:00:00 | 2024-04-30 00:00:00
 | Need formula for week numbers in highlighted cells with reference to Start and End dates.  No. of working days would be 5 day week working (Saturday and Sundays are holidays), excluding the holidays in Col.V
 | No. of weeks to continue even after the year changes (it should not start from 1 when the year changed to 2024)
Spreadsheet: 753641d1635602213-power-query-keep-rows-with-blanks-in-column2-only-if-value-in-column1-is-unique-keep-row-with-blanks-in-col2-only-if-unique-in-col1
Sheet: Sheet2

Batch | Batch2 | Power Query KEEP or DISCARD
14997224
14999910
15009090
15017621
15022494
15022494 | *
15022494 | 14910871
15022494 | 14910871
15022505
15022505 | 15022494
15022507
15022507 | 15022494
15039043
15039043 | 15083172
15039119
15039119 | 15075489
15039214
15039214 | 15083172
15040233
15040233 | 15022507
15040279
15040279 | 15022505
15063322
15063322 | 15093326
15070743
15070743 | 15093322
15075482
15075482 | *
15075482 | *
15075482 | *
15075482 | 14992453
15075482 | 14992453
15075486
15075486 | 15075482
15075489
15075489 | 15075482
15083126
15083126 | *
15083126 | 15019236
15083126 | 15019236
15083126 | 15019236
15083126 | 15019236
15083132
15083132 | *
15083132 | 14910871
15083132 | 14910871
15083140
15083140 | 15083132
15083146
15083146 | 15083132
15083150
15083150 | 15083126
15083167
15083167 | 15083126
15083172
15083172 | 15083126
15083180
15083180 | 15083126
15085286
15085286 | 15093322
15085302
15085302 | 15094377
15085313
15085313 | 15083172
15089224
15089224 | 15083132
15092717
15092717 | *
15092717 | *
15092717 | 14910871
15093130
15093130 | 14992453
15093130 | 14992453
15093130 | 14992453
15093130 | 15019237
15093130 | 15019237
15093193
15093193 | 15094363
15093203
15093203 | 15094363
15093322
15093322 | 15094363
15093326
15093326 | 15094363
15094363
15094363 | *
15094363 | *
15094363 | 14685026
15094363 | 14693401
15094363 | 14693401
15094376
15094376 | 15093130
15094377
15094377 | 15093130
15094380
15094380 | 15093130
15101258
15101258 | 14992306
15101258 | 15019242
15101258 | 15019242
15101258 | 15019242
15101258 | 15019242
15101315
15101315 | 15092717
15101328
15101328 | 15101258
15101356
15101356 | 15101258
15101358
15101358 | 15101258
15103236
15103236 | 15093130
15106182
15106182 | 15083140
15106183
15106183 | 15083146
15106184
15106184 | 15089224
15106679
15106679 | 15101315
15106789
15106789 | 15101258
15108227
15108227 | 15101258
15121893
15121893 | 15093322
15123726
15123726 | 15093322
15145152
15145152 | 15019236
15145152 | 15019236
15145152 | 15019237
15145152 | 15019237
15145152 | 15019237
Spreadsheet: 133020d1324090828-populating-a-table-from-a-dynamic-list-selection-populating-a-table-from-a-dynamic-list-selection
Sheet: Sheet1

 | Hook -001 |  |  |  |  |  | Hook -002 |  |  |  |  |  | Hook -003
 | 2011-04-11 00:00:00 |  |  | 2011-07-11 00:00:00 |  |  | 2011-04-11 00:00:00 |  |  | 2011-07-11 00:00:00 |  |  | 2011-04-11 00:00:00 |  |  | 2011-07-11 00:00:00
 | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms
b | 1 | 2 | 3 | 2 | 4 | 6 | 4 | 8 | 12 | 8 | 16 | 24 | 16 | 32 | 48 | 32 | 64 | 96
x | 2 | 4 | 6 | 4 | 8 | 12 | 8 | 16 | 24 | 16 | 32 | 48 | 32 | 64 | 96 | 64 | 128 | 192
x2 | 3 | 6 | 9 | 6 | 12 | 18 | 12 | 24 | 36 | 24 | 48 | 72 | 48 | 96 | 144 | 96 | 192 | 288
[NAME] | 4 | 8 | 12 | 8 | 16 | 24 | 16 | 32 | 48 | 32 | 64 | 96 | 64 | 128 | 192 | 128 | 256 | 384
y | 5 | 10 | 15 | 10 | 20 | 30 | 20 | 40 | 60 | 40 | 80 | 120 | 80 | 160 | 240 | 160 | 320 | 480
xy | 6 | 12 | 18 | 12 | 24 | 36 | 24 | 48 | 72 | 48 | 96 | 144 | 96 | 192 | 288 | 192 | 384 | 576
y2 | 7 | 14 | 21 | 14 | 28 | 42 | 28 | 56 | 84 | 56 | 112 | 168 | 112 | 224 | 336 | 224 | 448 | 672
y3 | 8 | 16 | 24 | 16 | 32 | 48 | 32 | 64 | 96 | 64 | 128 | 192 | 128 | 256 | 384 | 256 | 512 | 768
z | 9 | 18 | 27 | 18 | 36 | 54 | 36 | 72 | 108 | 72 | 144 | 216 | 144 | 288 | 432 | 288 | 576 | 864
xz | 10 | 20 | 30 | 20 | 40 | 60 | 40 | 80 | 120 | 80 | 160 | 240 | 160 | 320 | 480 | 320 | 640 | 960
yz | 11 | 22 | 33 | 22 | 44 | 66 | 44 | 88 | 132 | 88 | 176 | 264 | 176 | 352 | 528 | 352 | 704 | 1056
z2 | 12 | 24 | 36 | 24 | 48 | 72 | 48 | 96 | 144 | 96 | 192 | 288 | 192 | 384 | 576 | 384 | 768 | 1152
z3 | 13 | 26 | 39 | 26 | 52 | 78 | 52 | 104 | 156 | 104 | 208 | 312 | 208 | 416 | 624 | 416 | 832 | 1248
Spreadsheet: 804715d1668243214-extract-data-from-12-different-sheets-into-one-single-column-without-vba-and-powerquerry-test
Sheet: Style Detail

S.# | Style No. | Style No.
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 108183d1305235781-changing-conditional-formatting-based-on-a-reference-kessler-1
Sheet: Sheet1

Multiples Valuation
Ratio Calculations:
 |  | 2008 | 2009 | 2010 | 2011* | 2012
Item:
Total Shares Outstanding* |  | 54622 | 118422 | 119119 | 119200 | 120000
Stock Price |  |  |  |  | 70.43
Sales |  |  |  |  | 4851426.666666667 | 5763494.88
Net Income |  |  |  |  | 501228.5528704823 | 829110.5395276336
Depreciation |  |  |  |  | 158987.5428904013 | 219012.80544
Stockholder's Equity |  | 1799853 | 4939931 | 5326320 | 5994179.928334262 | 7121085.754861102
 |  |  |  |  |  |  |  | 5763.49488
Earnings Per share |  |  |  |  |  |  |  | 1127.339598528
Sales per share |  |  |  |  |  |  |  | 829.1105395276336
Cash flow per share |  |  |  |  |  |  |  | 219.01280544
Book Value per share
Price to Earnings Ratio
Price to Sale Ratio
Price to Cash Flow Ratio
Price to Book Ratio
2011 Forcasted Price
Item |  | Multiple |  | Price
Price to Earnings Ratio
Price to Sales Ratio
Price to cash [NAME]
Price to Book Ratio
 |  | Forcasted Price 2011
 |  | Discount Rate |  | 0.084
 |  | Discounted Price
* 2011-2012 Total Shares outstanding estimated by using an average percentage of Sales and Analysist Intuition
* 2011 Stock Price is a current price (3/21/2011)
Spreadsheet: 136868d1326855378-combine-multiple-rows-to-one-row-lotsofhelpercolumns
Sheet: Sheet1

Incident | ID | Charges | Helper1 | Helper2 | Helper3 | Helper4 | Help5 | Help6 |  |  | Incident | ID | Charges | Helper1 | Helper2 | Helper3 | Helper4 | Help5 | Help6 | <<Advanced Filter Criteria
1234 | 4321 | A |  |  |  |  |  |  |  |  |  |  |  |  | 1
1234 | 4321 | N
1234 | 4321 | S |  |  |  |  |  |  |  |  | Incident | ID | Charges | Helper1 | Helper2 | Helper3 | Helper4 | Help5 | Help6 | <Advanced Filter Copy To Area
1800 | 8548 | A |  |  |  |  |  |  |  |  | 1234 | 4321 | A | 12344321 | 1 | 123443211 | A | N | S
1900 | 5479 | S |  |  |  |  |  |  |  |  | 1800 | 8548 | A | 18008548 | 1 | 180085481 | A
 |  |  |  |  |  |  |  |  |  |  | 1900 | 5479 | S | 19005479 | 1 | 190054791 | S
Spreadsheet: 740123d1626191981-how-to-auto-populate-information-from-one-tab-to-the-other-moveuniquevalues-1-
Sheet: Sheet7

Result |  | Cl Seen | # of Self Pay | # of Units | Rate | Total | Need to Follow Up
Spreadsheet: 866403d1713322498-combine-2-data-sheets-based-on-target-colum-basedcolum
Sheet: RESULT (2)

NO | ID | NAMES | [NAME] | CLASS
1
Spreadsheet: 115160d1310751544-min-max-values-for-first-column-relative-to-second-columns-values-beforeafter
Sheet: Before

Zip code | Number | Same ZIP? | Same Number? | Duplicate
1 | 0.4354 |  |  | No
2 | 0.4354 |  |  | No
3 | 0.4354 |  |  | No
4 | 0.4354 |  |  | No
4 | 0.4827 |  |  | No
5 | 0.4354 |  |  | No
6 | 0.4354 |  |  | No
6 | 0.4354 |  |  | No
7 | 0.4354 |  |  | No
7 | 0.4827 |  |  | No
9 | 0.4354 |  |  | No
10 | 0.4354 |  |  | No
11 | 0.4354 |  |  | No
12 | 0.4354 |  |  | No
14 | 0.4354 |  |  | No
15 | 0.4354 |  |  | No
16 | 0.4354 |  |  | No
16 | -0.1991 |  |  | No
17 | 0.4354 |  |  | No
17 | 0.4354 |  |  | No
18 | 0.4354 |  |  | No
18 | -0.1991 |  |  | No
Spreadsheet: 061b9c9e-c4db-4cb9-b0e6-1e33f91679ec
Sheet: Corporate VC Sectors

Total Venture Capital and Corporate Venture Capital by Sector
01/01/2012-06/30/2013
MoneyTree Sector | Total # Sector Deals | Average $M Per Deal | Total $M Invested in that Sector by All VC Types | # Deals with CVC Participation | Avg. CVC investment in Those Rounds Participated In | $ CVC Investment | % of CVC Investment $ | % of Deals with CVC Involvement | CVC % of $ In Sector
Biotechnology | 681 |  | 6400.67 | 131 |  | 644.95
Business Products and Services | 54 |  | 145.54 | 2 | 0 | 3.8
Computers and Peripherals | 68 |  | 614.35 | 12 |  | 70.3
Consumer Products and Services | 273 |  | 1910.63 | 26 |  | 90.88
Electronics/Instrumentation | 68 |  | 403.5 | 10 |  | 33.92
Financial Services | 76 |  | 461.05 | 8 |  | 32.04
Healthcare Services | 58 |  | 344.73 | 10 |  | 44.85
Industrial/Energy | 361 |  | 3412.41 | 64 |  | 422.03
IT Services | 466 |  | 2838.57 | 66 |  | 299.81
Media and Entertainment | 598 |  | 3137.04 | 94 |  | 237.75
Medical Devices and Equipment | 461 |  | 3603.81 | 64 |  | 340.73
Networking and Equipment | 53 |  | 856.03 | 11 |  | 28.05
Other* | 29 | 0 | 43.88 | 2 |  | 5.63 | 0 |  | 0
Retailing/Distribution | 83 |  | 721.12 | 13 |  | 146.55
Semiconductors | 154 |  | 1165.27 | 27 |  | 137.55
Software | 2005 |  | 12768.01 | 323 |  | 1012.49
Telecommunications | 123 |  | 850.46 | 27 |  | 97.9
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 770106d1645810275-tracing-and-summing-from-numerous-sheet-sumifs-qs2-v2
Sheet: Reference - ID

ID | Channel | Sub-Channel
IO-[PHONE] | [NAME] | C22
IO-[PHONE] | B5 | C15
IO-[PHONE] | B8 | C19
IO-[PHONE] | B32 | C10
IO-[PHONE] | [NAME] | C22
IO-[PHONE] | B8 | C19
IO-[PHONE] | [NAME] | C22
IO-[PHONE] | [NAME] | C22
IO-[PHONE] | B5 | C15
IO-[PHONE] | B8 | C19
IO-[PHONE] | B6 | C11
IO-[PHONE] | B6 | C11
IO-[PHONE] | B6 | C11
IO-[PHONE] | B5 | C15