tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1e4245a3-c2da-45e0-9ba5-1c99921baa99
Sheet: Corp Life Science Investing

Life Science (LS) Investing by Corporate Venture Capital Groups 1995 Through Q3 2013
Year | Count of All LS Venture Capital Deals | Number of LS Deals with CVC Involvement | Calculated Percentage of LS Deals with Corporate VC Involvement | $M Average Amount of All LS Deals | $M Average Amount of CVC Participation in LS Deals | Total LS VC Investment $M | Total CVC LS Investment $M | Calculated Percentage of Dollars Coming from CVCs | # Disclosed CVC Firms Investing in LS During Period
1995 | 355 | 29 |  |  |  | 1499.43 | 70.66 |  | 24
1996 | 448 | 42 |  |  |  | 1811.1 | 129.55 |  | 27
1997 | 515 | 73 |  |  |  | 2394.34 | 130.99 |  | 33
1998 | 570 | 75 |  |  |  | 2801.21 | 136.81 |  | 23
1999 | 552 | 86 |  |  |  | 3684.03 | 288.8 |  | 32
2000 | 653 | 108 |  |  |  | 6687.67 | 394.19 |  | 39
2001 | 600 | 124 |  |  |  | 5583.82 | 383.58 |  | 50
2002 | 564 | 111 |  |  |  | 5212.14 | 499.12 |  | 49
2003 | 609 | 124 |  |  |  | 5375.87 | 426.13 |  | 53
2004 | 687 | 155 |  |  |  | 6313.23 | 505.49 |  | 62
2005 | 691 | 155 |  |  |  | 6128.75 | 501.51 |  | 64
2006 | 844 | 196 |  |  |  | 7654.54 | 735.44 |  | 62
2007 | 932 | 223 |  |  |  | 9529.82 | 878.11 |  | 67
2008 | 943 | 250 |  |  |  | 8782.62 | 709.33 |  | 71
2009 | 806 | 130 |  |  |  | 6494.43 | 556.21 |  | 48
2010 | 850 | 126 |  |  |  | 6337.59 | 518.79 |  | 55
2011 | 839 | 141 |  |  |  | 7713.77 | 531.6 |  | 53
2012 | 801 | 131 |  |  |  | 6700.81 | 646.16 |  | 53
9M 2013 | 544 | 90 |  |  |  | 4865.92 | 527.08 |  | 44
Note: Life Science investing consists of the MoneyTree Biotech/Pharma and Med Devices categories. It does not include Healthcare Services.
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 71539d1272323758-excel-2007-two-pivot-table-queries-how-to-add-a-cumulative-column-and-a-data-sort-query-cum-column-and-data-sort-query
Sheet: Data

Yr/Pd | £ | Yr/Pd2
2009/1
2009/1
2009/1
2009/10
2009/10
2009/10
2009/11
2009/11
2009/11
2009/12
2009/12
2009/12
2009/2
2009/2
2009/2
2009/3
2009/3
2009/3
2009/4
2009/4
2009/4
2009/5
2009/5
2009/5
2009/6
2009/6
2009/6
2009/7
2009/7
2009/7
2009/8
2009/8
2009/8
2009/9
2009/9
2009/9
Spreadsheet: 575539d1527584233-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-1-ans2
Sheet: Rent Roll

 |  |  |  | Inflation | Year | 2018
 |  |  | CPI regulation | CPI |  | 0.01 | 0.02 | 0.03 | 0.02 | 0.05
 |  | Tenant 1 | 1 | 1
 |  | [NAME] | 2 | 0.5
 |  | Tenant 3 | 3 | 0.75
 |  |  |  |  | NOTE: Changes are done in formula in G3:K5
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Correct answer annually
 |  | Tenant 1
 |  | Accummulated
 |  | [NAME]
 |  | Accummulated | 1 |  |  |  | 1.0405785075
 |  | Tenant 3
 |  | Accummulated | 1 |  |  | 1.04562128125 | 1.04562128125
 |  | Comments: Some tenants only get the CPI indexed 50 % or 75% or whatever below 100% depending on lease contract. I would like to capture this on a quarterly basis, I.e how you did it on the tab "income calc", but reflecting the CPI (between 0 and 100%)
Spreadsheet: gerald_nemec__11353__Reliant Master Physical
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ECT Entity: | ECT | ATTORNEY:
DATE: | 2001-03-19 00:00:00 | ECT CONTACT:
COUNTERPARTY: | Reliant Energy Services, Inc. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P Rating
STRUCTURE | COUNTERPARTY | ECT ENTITY
COLLATERAL
THRESHOLD  in US$ | 5000000 | 5000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | n/a | n/a
COLLATERAL REQUIRED FOR:
ALL TRADES | x | x
OTHER | x | x
COLLATERAL TYPE
Letter of Credit | x | x
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | Reliant Energy Resources Corp. (BBB) | Bridgeline Holdings, LP
LIMIT in $[NAME] | 5 | 5
Incorporation State: | ? | Deleware
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | x | x
Debt Ratings Change | x
-Below = S&P | BBB-
Financial Covenants |  | x
-Funded Debt/Equity |  | (to be determined)
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 50.8% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | x | x
-Counterparty
-Guarantor ($[NAME]) | 25000000 | 15000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | B. Reves | x-9897
Spreadsheet: john_griffith__15907__11_13_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 280 | 36.5 | 38.5 | 83.6 | 88.2 | 15.12 | 2001-11-13 13:19:00
 | NG F2 | 300 | 65.5 | 66.5 | 80.3 | 81.6 | 15.27 | 2001-11-13 13:19:00
 | NG G2 | 300 | 80 | 81 | 74.2 | 75.1 | 14.08 | 2001-11-13 13:19:00
 | NG H2 | 295 | 81 | 82 | 65.5 | 66.4 | 12.23 | 2001-11-13 13:19:00
 | NG J2 | 295 | 75.5 | 77.5 | 54.4 | 55.8 | 10.22 | 2001-11-13 13:19:00
 | NG K2 | 300 | 78 | 80 | 49.9 | 51.2 | 9.53 | 2001-11-13 13:19:00
 | NG M2 | 305 | 84 | 87 | 48.4 | 50.2 | 9.45 | 2001-11-13 13:19:00
 | NG N2 | 305 | 92 | 95 | 49.8 | 51.5 | 9.71 | 2001-11-13 13:19:00
 | NG Q2 | 310 | 100 | 102 | 50.2 | 51.2 | 9.88 | 2001-11-13 13:19:00
 | NG U2 | 310 | 104 | 109 | 49.5 | 51.9 | 9.88 | 2001-11-13 13:19:00
 | NG V2 | 315 | 108 | 114 | 48.4 | 51.1 | 9.85 | 2001-11-13 13:19:00
 | NG X2 | 335 | 123 | 126 | 49.6 | 50.8 | 10.57 | 2001-11-13 13:19:00
 | [NAME] |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 270447d1381488403-sumif-problem-sumifsforum
Sheet: VAT

 | Input VAT |  |  |  | Output VAT (Sales) |  |  |  | VAT
 | Overheads | Sub-contractors | Suppliers | TOTAL | Net | [NAME] | Gross | TOTAL | Liability
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Quarterly  return Period | Input VAT | Output VAT | VAT Liability | NET Input | NET Output |  |  | Return Sent | Return Paid
Aug, Sep, Oct |  |  |  |  |  |  |  | No | Unpaid | DUE END OF NOV
Nov, Dec, Jan |  |  |  |  |  |  |  | No | Unpaid | DUE END OF FEB
Feb, [NAME], Apr |  |  |  |  |  |  |  | Yes | Paid | DUE END OF MAY
May, Jun, Jul |  |  |  |  |  |  |  | Yes | Paid | DUE END OF AUG
Spreadsheet: 285090d1387454983-should-be-easy-date-and-group-referencing-clusters-test-data-v2
Sheet: Sheet3

Area | Group | Date | Event | Cluster
01112 | A | 41094 | 41094 A 01112
01369 | B | 41022 | 41022 B 01369
01159 | B | 41215 | 41215 B 01159
01166 | B | 41236 | 41236 B 01166
01351 | B | 41272 | 41272 B 01351
01353 | B | 41273 | 41273 B 01353
01166 | B | 41328 | 41328 B 01166
01166 | B | 41359 | 41359 B 01166
01319 | D | 41114 | 41114 D 01319
01487 | D | 41224 | 41224 D 01487
01727 | F | 41001 | 41001 F 01727
01511 | F | 41053 | 41053 F 01511
01518 | F | 41073 | 41073 F 01518
01519 | F | 41073 | 41073 F 01519
01519 | F | 41084 | 41084 F 01519
01721 | F | 41093 | 41093 F 01721
01726 | F | 41116 | 41116 F 01726
01524 | F | 41138 | 41138 F 01524
01727 | F | 41145 | 41145 F 01727
01511 | F | 41175 | 41175 F 01511
01518 | F | 41189 | 41189 F 01518
01726 | F | 41207 | 41207 F 01726
02720 | F | 41213 | 41213 F 02720
01523 | F | 41243 | 41243 F 01523
01517 | F | 41254 | 41254 F 01517
01513 | F | 41305 | 41305 F 01513
01511 | F | 41329 | 41329 F 01511
01519 | F | 41330 | 41330 F 01519
01721 | F | 41363 | 41363 F 01721
02104 | G | 41013 | 41013 G 02104
02117 | G | 41193 | 41193 G 02117
02104 | G | 41267 | 41267 G 02104
02117 | G | 41280 | 41280 G 02117
02109 | G | 41304 | 41304 G 02109
02115 | G | 41313 | 41313 G 02115
02106 | G | 41317 | 41317 G 02106
02117 | G | 41355 | 41355 G 02117
02208 | H | 41009 | 41009 H 02208
02213 | H | 41055 | 41055 H 02213
02210 | H | 41075 | 41075 H 02210
02404 | H | 41131 | 41131 H 02404
02208 | H | 41134 | 41134 H 02208
02210 | H | 41171 | 41171 H 02210
02208 | H | 41235 | 41235 H 02208
02210 | H | 41242 | 41242 H 02210
02210 | H | 41247 | 41247 H 02210
02210 | H | 41250 | 41250 H 02210
02210 | H | 41324 | 41324 H 02210
02421 | H | 41347 | 41347 H 02421
02365 | I | 41040 | 41040 I 02365
02241 | I | 41109 | 41109 I 02241
02243 | I | 41109 | 41109 I 02243
02240 | I | 41163 | 41163 I 02240
02233 | I | 41236 | 41236 I 02233
02365 | I | 41247 | 41247 I 02365
02364 | I | 41323 | 41323 I 02364
02243 | I | 41324 | 41324 I 02243
02852 | N | 41089 | 41089 N 02852
02817 | N | 41200 | 41200 N 02817
02960 | O | 41002 | 41002 O 02960
02857 | O | 41232 | 41232 O 02857
Spreadsheet: 860360d1708489782-looking-for-the-exact-value-of-sales-handling-customers-simulation-3
Sheet: Sheet9

customer name | sales name | sales name 1st try |  |  | Sales Data
A |  |  |  |  | Number | Sales name | portion customers
B |  |  |  |  | 1 | aa | 1
C |  |  |  |  | 2 | ab | 3
D |  |  |  |  | 3 | ac | 10
E
F |  |  |  |  | CHECK
G |  |  |  |  | Sales name | portion customers
H |  |  |  |  | aa
I |  |  |  |  | ab
J |  |  |  |  | ac
K
L
M
N
*fill sales name based handling portion
*sales are free to handle any customer
Spreadsheet: 767419d1644463526-populate-an-excel-calendar-with-tasks-from-existing-spreadsheet-test-39-
Sheet: data to polulate calendar

Date | Activity | Owner [NAME] | next steps | Site on sharepoint for plan
2022-01-01 00:00:00 | Activity 1 | Condie | comments 1 | link 1
2022-01-01 00:00:00 | Activity 2 | Rusnak | comments 2 | link 2
2022-01-01 00:00:00 | Activity 3 | Snively | comments 3 | link 3
2022-01-01 00:00:00 | Activity 4 | Snively | comments 4 | link 4
2022-01-02 00:00:00 | Activity 5 | Hewitt | comments 5 | link 5
2022-01-03 00:00:00 | Activity 6 | [NAME] | comments 6 | link 6
2022-01-03 00:00:00 | Activity 7 | Rusnak | comments 7 | link 7
2022-01-03 00:00:00 | Activity 8 | Rusnak | comments 1 | link 8
2022-01-03 00:00:00 | Activity 1 | [NAME] | comments 2 | link 9
2022-01-03 00:00:00 | Activity 2 | Condie | comments 3 | link 10
2022-01-05 00:00:00 | Activity 3 | Rusnak | comments 4 | link 11
2022-01-05 00:00:00 | Activity 4 | Hewitt | comments 5 | link 12
2022-01-06 00:00:00 | Activity 5 | Hewitt | comments 6 | link 13
2022-01-07 00:00:00 | Activity 6 | Snively | comments 7 | link 14
2022-01-08 00:00:00 | Activity 7 | [NAME] | comments 1 | link 15
2022-01-09 00:00:00 | Activity 8 | Condie | comments 2 | link 16
2022-01-09 00:00:00 | Activity 1 | Condie | comments 3 | link 17
2022-01-09 00:00:00 | Activity 2 | Hewitt | comments 4 | link 18
2022-01-09 00:00:00 | Activity 3 | Snively | comments 5 | link 19
2022-01-09 00:00:00 | Activity 4 | Snively | comments 6 | link 20
2022-01-09 00:00:00 | Activity 5 | Snively | comments 7 | link 21
2022-01-10 00:00:00 | Activity 6 | Condie | comments 1 | link 22
2022-01-11 00:00:00 | Activity 7 | Condie | comments 2 | link 23
2022-01-12 00:00:00 | Activity 8 | [NAME] | comments 3 | link 24
2022-01-13 00:00:00 | Activity 1 | [NAME] | comments 4 | link 25
2022-01-14 00:00:00 | Activity 2 | Snively | comments 5 | link 26
2022-01-15 00:00:00 | Activity 3 | [NAME] | comments 6 | link 27
2022-01-16 00:00:00 | Activity 4 | Hewitt | comments 7 | link 28
2022-01-16 00:00:00 | Activity 5 | Condie | comments 1 | link 29
2022-01-16 00:00:00 | Activity 6 | Condie | comments 2 | link 30
2022-01-16 00:00:00 | Activity 7 | Condie | comments 3 | link 31
2022-01-16 00:00:00 | Activity 8 | Hewitt | comments 4 | link 32
2022-01-17 00:00:00 | Activity 1 | Hewitt | comments 5 | link 33
2022-01-17 00:00:00 | Activity 2 | Rusnak | comments 6 | link 34
2022-01-18 00:00:00 | Activity 3 | Hewitt | comments 7 | link 35
2022-01-19 00:00:00 | Activity 4 | Rusnak | comment 1 | link 36
Spreadsheet: 462940d1464253666-lookup-formula-with-more-than-2-criteria-lookup-with-more-than-2-criteria
Sheet: Balance Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  | Actual
 | Category |  | Full Year 2015 |  | 2016-03-15 00:00:00 |  | [NAME] |  | 2016-01-15 00:00:00 |  |  |  | Q1 2016
 | Current Assets
 | Cash |  | 0 |  | 0 |  |  |  | 500 | 400 | 250 |  |  |  |  | 2016-01-15 00:00:00
 | Bank of America Checking |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Bank of America Payroll |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | [NAME] |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | Q1 2016
 | Petty Cash |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank- Operations |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank- Payroll |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | Q2 2016
 | Union Bank- Recurring Payments |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Bank of the West- Operations |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
Spreadsheet: joe_parks__14714__POSTION05_02
Sheet: JUN_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  | 98 | 3.598 |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 | 47 | 3.57 |  |  |  |  |  |  |  |  | NEW DEALS
 | 15 | 3.56
 | 7 | 3.55 |  |  |  |  |  |  |  |  | TOTAL  P&L
 | 15 | 3.575
 | 15 | 3.525
 |  |  |  |  | 15 | 3.5 |  |  |  |  | POSTION
 |  |  |  |  | 15 | 3.485 |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  | Position |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 31 | 3.15
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.115
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 180143d1347487986-create-an-automatically-sorting-ranking-list-rank-dip11-oeldere-
Sheet: Sheet1

 |  |  |  | score 2
 |  |  |  |  |  |  |  |  |  |  | Label | Score2 | helpcel |  |  | DESIRED OUTPUT
 |  |  |  | Holly | 15.000008 |  |  |  |  |  | [NAME] | 20 | 20.000003 |  |  | Holly | 6 | 15
 |  |  |  | [NAME] | 20.000003 |  |  |  |  |  | [NAME] | 35 | 35.000004 |  |  | [NAME] | 10 | 20
 |  |  |  | [NAME] | 27.500006 |  |  |  |  |  | Lina | 35 | 35.000005 |  |  | Lina | 10 | 35
 |  |  |  | [NAME] | 35.000004 |  |  |  |  |  | [NAME] | 27.5 | 27.500006 |  |  | [NAME] | 17.5 | 27.5
 |  |  |  | Lina | 35.000005 |  |  |  |  |  | [NAME] | 55 | 55.000007 |  |  | [NAME] | 17.5 | 39
 |  |  |  | [NAME] | 39.00001 |  |  |  |  |  | Holly | 15 | 15.000008 |  |  | [NAME] | 20 | 45
 |  |  |  | [NAME] | 45.000009 |  |  |  |  |  | [NAME] | 45 | 45.000009 |  |  | [NAME] | 24 | 35
 |  |  |  | [NAME] | 55.000007 |  |  |  |  |  | [NAME] | 39 | 39.00001 |  |  | [NAME] | 45 | 55
 |  |  |  |  |  |  |  |  |  |  |  | Score1
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 10
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 24
 |  |  |  |  |  |  |  |  |  |  | Lina | 10
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 17.5
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 45
 |  |  |  |  |  |  |  |  |  |  | Holly | 6
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 20
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 17.5
Spreadsheet: 101889d1299943457-and-or-vlookup-formula-if-or-and-problem
Sheet: List

LM Coordinated Audiences | GMU-ASEAN
Workload Optimized Infrastructure | GMU-CEE
Workload Optimized Systems | GMU-GCG
STG - Competitive & Install | GMU-India-South Asia
LM Targeted Need-States | GMU-Korea
Business Agility | GMU-LA-Brazil
Business Analytics Optimization | GMU-LA-Mexico
GBS - Core and Invest | GMU-LA-SSA
Integrated Service Management & Security | GMU-MEA
Leveraging IT Services | NEE-Alps
Leveraging Middleware Investments | NEE-Nordic
Master Program Plan is not selected. | SWE-Benelux
Social Business | SWE-France
Software & Product Innovation
Spreadsheet: 151590d1334996875-another-vlookup-question-multiple-criteria-workbook1
Sheet: Sheet1

 | ACCT_PERIOD_MO_YR_DT | PC_CD | DICISION_CD | MAIN_ACCOUNT | SUB_ACCOUNT | TRANSACTION_CD | TIE_CODE | DIRECTORY_CD | Sum(AMT) |  | ACCT_PERIOD_MO_YR_DT | PC_CD | DICISION_CD | MAIN_ACCOUNT | SUB_ACCOUNT | TRANSACTION_CD | TIE_CODE | DIRECTORY_CD | Sum(AMT)
 | 201203 | D | H | 8767 | 465 | 077 | DF33 | C0G002002 | -239.33 |  | 201203 | D | H | 8767 | 465 | 077 | DF33 | C0G002002 | -239.33
 | 201203 | D | S | 8767 | 465 | 077 | DF33 | C0G002002 | -7373.94 |  | 201203 | D | H | 8767 | 465 | 77 | DF33 | C08LHDF332 | -4456.34
 |  |  |  |  |  |  |  | Total C0G002002 |  |  | 201203 | D | H | 8767 | 465 | 078 | DF33 | C08FF0020 | -4234.243
 | 201203 | D | H | 8767 | 465 | 077 | DF33 | C0GQ00200 | -134.423 |  | 201203 | D | H | 8767 | 465 | 78 | DF33 | C0GQ00200 | -134.423
 | 201203 | D | S | 8767 | 465 | 077 | DF33 | C0GQ00200 | -2344.23 |  | 201203 | D | S | 8767 | 465 | 079 | DF33 | C08LHDF332 | -4352.123
 |  |  |  |  |  |  |  | Total C0GQ00200 |  |  | 201203 | D | S | 8767 | 465 | 79 | DF33 | C0G002002 | -7373.94
 | 201203 | D | H | 8767 | 465 | 077 | DF33 | C08FF0020 | -4234.243 |  | 201203 | D | S | 8767 | 465 | 080 | DF33 | C08FF0020 | -2134.12
 | 201203 | D | S | 8767 | 465 | 077 | DF33 | C08FF0020 | -2134.12 |  | 201203 | D | S | 8767 | 465 | 80 | DF33 | C0GQ00200 | -2344.23
 |  |  |  |  |  |  | Total C08FF0020
 | 201203 | D | H | 8767 | 465 | 077 | DF33 | C08LHDF332 | -4456.34
 | 201203 | D | S | 8767 | 465 | 077 | DF33 | C08LHDF332 | -4352.123
 |  |  |  |  |  |  |  | Total C08LHDF332
 | 201203 | S | H | 8767 | 465 | 077 | DF33 | [NAME] | 0 |  | TO THIS COLUMN |  |  | AND THIS COLUMN |  |  | AND THIS COLUMN
 | 201203 | S | S | 8767 | 465 | 077 | DF33 | [NAME] | 0
 |  |  |  |  |  |  |  | Total C08LWDF332
 | 201203 | S | H | 8767 | 465 | 077 | DF33 | C08LYDF332 | 0
 | 201203 | S | S | 8767 | 465 | 077 | DF33 | C08LYDF332 | 0
 |  |  |  |  |  |  |  | Total C08LYDF332
 | 201203 | S | H | 8767 | 465 | 077 | DF33 | C0J002002 | 0
 | 201203 | S | S | 8767 | 465 | 077 | DF33 | C0J002002 | 0
 |  |  |  |  |  |  |  | Total C0J002002
 | 201203 | S | H | 8767 | 465 | 077 | DF33 | C0JN00200 | 0
 | 201203 | S | S | 8767 | 465 | 077 | DF33 | C0JN00200 | 0
 |  |  |  |  |  |  |  | Total C0JN00200
 |  |  |  |  |  |  |  | Total TIE 077
 | Match this column |  |  | This column |  |  | This column
 |  |  |  |  |  |  |  |  | Need to populate this column with [NAME] (AMT) values to the right
Spreadsheet: 194959d1353369701-how-to-stop-a-cummulative-calculation-ef270_cummulative-calculation-result
Sheet: Size of follow-on orders NONCUM

End Users | Years | Total |  | Cummulative $
A | Sum of 1st Year | 512821.5
 | Sum of 2nd Year | 0
 | Sum of 3rd Year | 62406
 | Sum of 4th Year | 1265650.92
 | Sum of 5th Year | 402628.13
 | Sum of 6th Year | 384754.01
 | Sum of 7th Year | 830437.0700000001
 | Sum of 8th Year | 1898804.92
 | Sum of 9th Year | 1295681.1
B | Sum of 1st Year | 811953.78
 | Sum of 2nd Year | 817747.5
 | Sum of 3rd Year | 588335
 | Sum of 4th Year | 1606300
 | Sum of 5th Year | 455935.58
 | Sum of 6th Year | 68500
 | Sum of 7th Year | 0
 | Sum of 8th Year | 0
 | Sum of 9th Year | 0
C | Sum of 1st Year | 286554.6800000001
 | Sum of 2nd Year | 82498.41
 | Sum of 3rd Year | 424458.62
 | Sum of 4th Year | 1491293.03
 | Sum of 5th Year | 427030
 | Sum of 6th Year | 162933.01
 | Sum of 7th Year | 55135
 | Sum of 8th Year | 0
 | Sum of 9th Year | 0
D | Sum of 1st Year | 1888532.17
 | Sum of 2nd Year | 226906.98
 | Sum of 3rd Year | 70945.75
 | Sum of 4th Year | 124226.5
 | Sum of 5th Year | 0
 | Sum of 6th Year | 0
 | Sum of 7th Year | 0
 | Sum of 8th Year | 0
 | Sum of 9th Year | 0
Spreadsheet: 805074d1668522276-getting-formula-to-work-when-data-is-replaced-test-deleting-values
Sheet: Data Copy

Column A | Column B | [NAME]
2 | 3
4 | 6
6 | 9
8 | 12
10 | 15
12 | 18
14 | 21
16 | 24
18 | 27
20 | 30
22 | 33
24 | 36
26 | 39
28 | 42
30 | 45
32 | 48
34 | 51
36 | 54
38 | 57
Spreadsheet: 110dde6a-ab0b-4292-818c-d3b3e35f3de8
Sheet: Program data

Program of Study | Degree code | Credits hours required prior to PACE | Credit hours required after PACE redesign | [NAME] Developmental Math  Requirement Rate: F08 to S10 | [NAME] Developmental English  Requirement Rate: F08 to S10 | [NAME] Reading  Requirement Rate: F08 to S10 | [NAME] Developmental Math  Requirement Rate: F09 to S11 | [NAME] Developmental English  Requirement Rate: F09 to S11 | [NAME] Reading  Requirement Rate: F09 to S11 | [NAME] Developmental Math  Requirement Rate: F10 to S12 | [NAME] Developmental English  Requirement Rate: F10 to S12 | [NAME] Reading  Requirement Rate: F10 to S12 | Historic Completed College-level Math Requirement Rate: F08 to S10 | Historic Completed College-level English Requirement Rate: F08 to S10 | Historic Completed College-level Reading Requirement Rate: F08 to S10 | Historic Completed College-level Math Requirement Rate: F09 to S11 | Historic Completed College-level English Requirement Rate: F09 to S11 | Historic Completed College-level Reading Requirement Rate: F09 to S11 | Historic Completed College-level Math Requirement Rate: F10 to S12 | Historic Completed College-level English Requirement Rate: F10 to S12 | Historic Completed College-level Reading Requirement Rate: F10 to S12
Spreadsheet: 722063d1615026890-truncating-an-array-in-a-countifs-truncating-an-array-in-a-countifs
Sheet: Sheet1

NUM | ALFA |  | 2 | q |  | [NAME] | 1
1.487 | w |  |  |  |  | [NAME] | w
1.83 | q |  |  |  |  | Count results
2.269 | w
1.715 | q
2.155 | w
2.313 | q
3.586 | w
1.82 | w
3.185 | w
3.849 | q
3.105 | w
3.392 | q
2.251 | w
3.543 | q
2.611 | w
2.493 | q
3.673 | w
Spreadsheet: 113627d1309460420-need-help-with-if-then-formula-dummy-data
Sheet: Dummy Data

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | 2011-06-20 00:00:00 | 2011-06-21 00:00:00 | 2011-06-22 00:00:00 | 2011-06-23 00:00:00 | 2011-06-24 00:00:00 | 2011-06-25 00:00:00 | 2011-06-26 00:00:00
Custom HBC PEG Employees | Mon | TUE | WED | THU | FRI | SAT | SUN | Hours | Rate | Total
Person A | 8 | 8 | 8 | 8 | 8 | 0 | 2 | 42 | 11.88 | 510.84
Person B | 8 | 8 | 8 | 8 | 8 | 4 | 0 | 44 | 11.88 | 546.48
Person C | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 40 | 11.88 | 475.2
Person D | 8 | 8 | 8 | 8 | 8 | 7 | 0 | 47 | 11.88 | 599.94
 |  |  |  |  |  |  |  |  | 11.88
 |  |  |  |  |  |  |  |  | 11.88
Daily Hours | 32 | 32 | 32 | 32 | 32 | 11 | 2 | 173 | TOTAL
Daily Dollars | 380.16 | 326.7 | 59.40000000000001 | 2055.24 | 564.5376000000001 | 25333.62480000001 | 0 |  |  | 2132.46
Person A | 0 | 0 | 0 | 0 | 0 | 0 | 2
Person B | 0 | 0 | 0 | 0 | 0 | 4 | 0
Person C | 0 | 0 | 0 | 0 | 0 | 0 | 0
Person D | 0 | 0 | 0 | 0 | 0 | 7 | 0
Spreadsheet: 27127d1219996535-page-numbering-in-page-titles-title
Sheet: SUMMARY

 |  |  | #N/A
 |  |  | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A
 |  | #N/A | #N/A