tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 146653d1332281679-help-with-chart-copy-of-profit-chart
Sheet: 2012

Profit Sharing % | 0.0363349323333517
Bonus % | 0.04458815267764159
Stockholders Investment | 50000
Adjusted Profits | 60247.61000000002 | 61866.17 | 39143.71000000002 | 108327.52 |  | 159435.81 |  | 49746.98999999999 |  | 26593.57000000001 |  | 105229.41 |  | 29050.35000000001 |  | 14602.51999999999 |  | 35460.25 |  | 129963.46 |  | -28223.14 |  | -124647.86
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sept |  | Oct |  | Nov |  | Dec
 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011 | 2012 | 2011
Profit Sharing | 2189.092832596164 | 2247.903100673633 | 1422.284054126343 | 3936.073109039804 | 0 | 5793.089367863118 | 0 | 1807.553515437923 | 0 | 966.2755664522521 | 0 | 3823.503491828522 | 0 | 1055.542501510184 | 0 | 530.5815760964146 | 0 | 1288.445784273735 | 0 | 4722.21352490826 | 0 | -1025.485882134712 | 0 | -4529.071558597097
Bonus | 2686.329633143007 | 2758.49823354093 | 1745.345717849327 | 4830.124000950274 | 0 | 7108.948238563456 | 0 | 2218.126385373109 | 0 | 1185.758159403549 | 0 | 4691.984999258144 | 0 | 1295.301441138926 | 0 | 651.0993912383144 | 0 | 1581.10704098734 | 0 | 5794.830596994565 | 0 | -1258.417675362453 | 0 | -5557.817812621294
TOTAL | 4875.422465739171 | 5006.401334214563 | 3167.62977197567 | 8766.197109990077 | 0 | 12902.03760642657 | 0 | 4025.679900811032 | 0 | 2152.033725855802 | 0 | 8515.488491086666 | 0 | 2350.84394264911 | 0 | 1181.680967334729 | 0 | 2869.552825261075 | 0 | 10517.04412190283 | 0 | -2283.903557497165 | 0 | -10086.88937121839
 | 2012 | 2011
 | Total (trend) | Total
Profit Sharing | 21668.26132033504 | 15000
Bonus | 26590.052105954 | 33663
Spreadsheet: 120063d1314962697-adding-values-based-on-both-month-and-text-criteria-saving-rev1
Sheet: Aug 

Category | Date | Description | Credit | Debit | Running Balance
Social | 2011-08-31 00:00:00 | CARD PAYMENT TO HOEBRIDGE GOLF & SNOOK,38.45 GBP ON 29-08-2011 |  | -38.45 | 7162.46
Salary | 2011-08-31 00:00:00 | BANK GIRO CREDIT REF ICEGRADE LTD, ICEGRADE | 2217.38 |  | 7200.91
social | 2011-08-30 00:00:00 | CARD PAYMENT TO HOEBRIDGE GOLF & SNOOK,22.19 GBP ON 27-08-2011 |  | -22.19 | 4983.53
social | 2011-08-30 00:00:00 | CARD PAYMENT TO WINE RACK,44.52 GBP ON 27-08-2011 |  | -44.52 | 5005.72
clothes | 2011-08-30 00:00:00 | CARD PAYMENT TO RIVER ISLAND 107,24.99 GBP ON 27-08-2011 |  | -24.99 | 5050.24
clothes | 2011-08-30 00:00:00 | CARD PAYMENT TO TOP SHOP/TOPMAN,16.00 GBP ON 27-08-2011 |  | -16 | 5075.23
clothes | 2011-08-30 00:00:00 | CARD PAYMENT TO DEBENHAMS,13.00 GBP ON 27-08-2011 |  | -13 | 5091.23
[NAME] | 2011-08-30 00:00:00 | CARD PAYMENT TO BOOTS,WOKING,10.10 GBP ON 27-08-2011 |  | -10.1 | 5104.23
Phone | 2011-08-30 00:00:00 | DIRECT DEBIT PAYMENT TO VODAFONE LIMITED REF 25984152M416311, MANDATE NO 0004 |  | -35.89 | 5114.33
Petrol | 2011-08-29 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,54.55 GBP ON 26-08-2011 |  | -54.55 | 5150.22
social | 2011-08-27 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 401542BURPHAM E, BURPHAM E1 B, 100.00 GBP, ON 27-08-2 |  | -100 | 5204.77
Food | 2011-08-26 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,2.50 GBP ON 24-08-2011 |  | -2.5 | 5304.77
Food | 2011-08-24 00:00:00 | CARD PAYMENT TO SAINSBURYS S/MKTS,5.35 GBP ON 22-08-2011 |  | -5.35 | 5307.27
Petrol | 2011-08-20 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,50.00 GBP ON 18-08-2011 |  | -50 | 5312.62
Misc | 2011-08-19 00:00:00 | CARD PAYMENT TO APEX DENTAL CARE LTD,40.00 GBP ON 17-08-2011 |  | -40 | 5362.62
Social | 2011-08-16 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 402612KINGSTON, KINGSTON CL E B, 10.00 GBP, ON 16-08- |  | -10 | 5402.62
Social | 2011-08-16 00:00:00 | CARD PAYMENT TO BED,9.00 GBP ON 14-08-2011 |  | -9 | 5412.62
Food | 2011-08-16 00:00:00 | CARD PAYMENT TO MCDONALDS REST,3.99 GBP ON 13-08-2011 |  | -3.99 | 5421.62
Petrol | 2011-08-16 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,42.98 GBP ON 14-08-2011 |  | -42.98 | 5425.61
Social | 2011-08-16 00:00:00 | CARD PAYMENT TO HERBERT WELLS,10.00 GBP ON 13-08-2011 |  | -10 | 5468.59
Misc | 2011-08-16 00:00:00 | CARD PAYMENT TO FORBUOYS,2.19 GBP ON 13-08-2011 |  | -2.19 | 5478.59
Misc | 2011-08-16 00:00:00 | CARD PAYMENT TO FORBUOYS LTD ON 2011-08-13 |  | -32.99 | 5480.78
Spreadsheet: 132147d1323531216-macro-for-mapping-book1
Sheet: Sheet1

prd
101 |  | a | b | c | d
102 |  | a | b | c | d
103 |  | a | b | c | d
101 | a
101 | b
101 | c
101 | d
102 | a
102 | b
102 | c
102 | d
103 | a
103 | b
103 | c
103 | d
Spreadsheet: mary_hain__25906__ENE Analysis of PGE Financials
Sheet: debt information

 | (In Millions) |  |  |  |  |  | (In thousands)
 |  |  | 2000-06-30 00:00:00 | 1999-12-31 00:00:00 | 1998-12-31 00:00:00 |  |  | 2000-06-30 00:00:00 | 1999-12-31 00:00:00 | 1998-12-31 00:00:00
 |  |  |  |  |  |  | Generation-related transition costs | 4400 | 3996 | 5335
 | Regulatory Assets (non-current asset) |  | 5273 | 4895 | 6288 |  | (includes uncollected electric procurement costs)
 | Increase/decrease |  |  |  |  |  | Unamortized loos, net gain, |  | 288 | 289
 | Regulatory balancing accounts (accounts payable) |  | 574 | 384 | 79 |  | on reacquired debt
 | Increase/decrease |  |  |  |  |  | Regulatory assets for deferred income tax |  | 295 | 293
 |  |  |  |  |  |  | Other, net |  | 316 | 351
 |  |  |  |  |  |  | TOTAL UTILITY | 5273 | 4895 | 6288
 |  |  |  |  |  |  | National Energy Group |  | 62 | 59
 |  |  |  |  |  |  | Regulatory assets for deferred income tax |  | 4957 | 6347
 | CFLOWS FROM FINANCING ACTIVITIES
 | Net borrowing (repayments) under credit facilities |  | 31 | -688 |  |  | Regulatory liabilities |  | 771 | 526
 | L-T debt matured, redeemed or repurchased |  | -216 | -369
 | Common stock repurchased |  | -275 | -725
 | Dividends paid |  | -250 | -208
 | Other net |  | 4 | 1
 | Net cash used by financing activities
 | Revolver* |  | 480 | 449 |  | (1998 consisted of $567 million commercial paper and
 | Increase/decrease |  |  |  |  | $101 million of bank notes)
 |  |  |  |  |  |  |  |  | (millions)
 | Notes: |  |  |  |  |  |  |  |  | Debt balance:
1 | *The utility maintains a $1 billion revolving credit facility, which expires in 2002.  The Utility may extend the facility annually for additional one-year
 | periods upon agreement with the banks.  Total amount outsanding at June 30, 2000 was $480 million.  Note the the utliity would be required to further |  |  |  |  |  |  |  | ?? | 1000
 | draw on this facility during the transition period to meet its liquidity requirments. |  |  |  |  |  |  |  | current 6-30-00
2 | The utility has fully utilized its existng CPUC short-term debt authorization by issuing $1.7 billion in commercial paper and drawings under its existing |  |  |  |  |  |  |  |  | 1700
 | revolving credit facilities to support higher power costs (12-18-00, 8K report)
3 | On Nov 1, 2000, the utility issued $1 billion of short-term floating rate notes and $680 million of five-year notes. |  |  |  |  |  |  |  |  | 1680
4 | On Nov 22, 2000, the utility issued an additional $240 million of short-term floating rate notes. |  |  |  |  |  |  |  |  | 240
5 | The utility is requesting an additioal $2 billion in long-term debt instruments (pending) |  |  |  |  |  |  |  | ?? | 2000 | pending
 | Utility currently has $1.2 billion (12-18-00, 8K report)
6
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -1880 | -3499
2 | -2029 | -3500
3 | -2037 | -3500
4 | -2033
5 | -2050 | -2818
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -304459
2001-06-05 00:00:00
Spreadsheet: 886614d1736683708-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-jetemc
Sheet: Data

 | Direction | Leader | Team | Closed Stops | No Stops Pub Only | No Stops Closed |  |  |  |  |  |  |  |  |  |  | Bus Stop | Closure |  |  | Pub Only |  |  |  | Pub & Hood
 |  |  |  |  |  |  | Date | Leader | Board |  | Boards | Dynamic | Duration (Days) |  |  |  | list | Type | [NAME] |  | Stop Numb | Road Name | Type |  | Stop Numb | Road Name | Type
 |  |  | Select Your Team |  |  |  |  | Select The Leader |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | STATION ROAD | Publicity Only |  |  | GLOUCESTER PLACE | Publicity & Hood
 | AH | L | 04 | Publicity Only |  |  |  |  | All Buses | Publicity Only |  |  | Start date |  |  |  | Pub Only | Weekdays Only | Weekdays |  | 15760 | EDGWAREBURY LANE (N AND S OF A41) | Publicity Only |  | 16105 | EDGWARE WAY | Publicity & Hood
 | L |  | 06 | Publicity & Hood |  |  |  |  | To Place | [NAME] |  |  | Finish Date |  |  |  | Pub & Hood | Weekends Only |  |  | 15758 | EDGWARE WAY | Publicity Only |  | 12027 | FINCHLEY ROAD | Publicity & Hood
 | L-AH |  | 07 |  |  |  |  |  | To Route | [NAME] |  |  |  |  |  |  | Removed | Saturdays Only | Weekends |  | 14702 | EDGWARE WAY | Publicity Only |  | 116 | FINCHLEY ROAD | Publicity & Hood
 | R |  | 08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sundays Only |  |  | bp4548 | FINCHLEY ROAD | Publicity Only |  | 136 | FINCHLEY ROAD | Publicity & Hood
 | R-AH |  | 09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturdays Only |  | 16153 | FINCHLEY ROAD | Publicity Only |  | 1464 | FINCHLEY ROAD | Publicity & Hood
 | C-Nav |  | Edgware |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1218 | FINCHLEY ROAD | Publicity Only
 | EXT 1 |  | Eltham |  |  |  |  | Weekdays Only |  |  |  |  |  |  |  |  |  |  | Sundays Only
 | EXT 2 |  | Events |  |  |  |  | Weekends Only
 | EXT 3 |  | Morden
 | EXT 4 |  | [NAME]
 | EXT 5 |  | Turnpike Lane |  |  |  |  | When Instructed
 | EXT 6 |  | Uxbridge
Spreadsheet: 883764d1732457754-round-function-round-function
Sheet: Sheet2 (2)

Total | Rounded Total
23.7825 | 23.78
23.7835 | 23.78
23.785 | 23.785
23.786 | 23.79
23.787 | 23.79
23.788 | 23.79
23.789 | 23.79
23.79 | 23.79
23.715 | 23.715
1
1.125
1.126
100.514
100.515
100.516
Spreadsheet: 708521d1607904155-converting-numbers-to-dd-hh-mm-hunter-tactics-cheat-sheet
Sheet: Sheet2

15000000 | Build | Research | Training
Points Per Min | 15 | 15 | 15
Needed
60 Min Speeds Needed
60 Min Speeds per Category
Total Time in Days:Hour:Min
# Of Members | 71
Spreadsheet: 69440d1269963151-excel-2007-concatenate-next-non-empty-cell-in-a-column-example4
Sheet: Sheet1

 | Revenue Streams Hierarchy
 | Detail Level 1 of 4 |  | [NAME] of 4 | [NAME] 3 of 4 | Detail Level 4 of 4
 |  | Athletics Club |  |  |  |  | Athletics Club
 |  |  | Membership |  |  |  | Athletics Club - Membership
 |  |  | Training Fees |  |  |  | Athletics Club - Training Fees
 |  |  | Competition |  |  |  | Athletics Club - Competition
 |  |  |  | Entries |  |  | Athletics Club - Competition - Entries
 |  |  |  | Affiliations |  |  | Athletics Club - Competition - Affiliations
 |  |  |  | Transport |  |  | Athletics Club - Competition - Transport
 |  |  |  | Accommodation |  |  | Athletics Club - Competition - Accommodation
 |  |  |  | Physiotherapy |  |  | Athletics Club - Competition - Physiotherapy
 |  |  |  | Bonus Points Scheme |  |  | Athletics Club - Competition - Bonus Points Scheme
 |  |  |  | Officials Expenses |  |  | Athletics Club - Competition - Officials Expenses
 |  |  |  | Management |  |  | Athletics Club - Competition - Management
 |  |  |  |  | Honorarium Payments |  | Athletics Club - Competition - Management - Honorarium Payments
 |  |  |  |  | Expenses |  | Athletics Club - Competition - Management - Expenses
 |  |  | Home Promotions |  |  |  | Athletics Club - Home Promotions - Management
 |  |  |  | [NAME] |  |  | Athletics Club - Home Promotions - Grandprixs
 |  |  |  | Medal Meetings |  |  | Athletics Club - Home Promotions - Medal Meetings
 |  |  |  | League Matches |  |  | Athletics Club - Home Promotions - League Matches
 |  |  |  | Schools Park Races |  |  | Athletics Club - Home Promotions - Schools Park Races
 |  |  | Other |  |  |  | Athletics Club - Other - Schools Park Races
 |  |  |  | Website |  |  | Athletics Club - Other - Website
 |  |  |  | [NAME] |  |  | Athletics Club - Other - Club Kit
 |  |  |  | Coach Development |  |  | Athletics Club - Other - Coach Development
 |  |  |  | Startrack |  |  | Athletics Club - Other - Startrack
 |  |  |  | Social Events |  |  | Athletics Club - Other - Social Events
 |  |  |  | Honorarium Payments |  |  | Athletics Club - Other - Honorarium Payments
 |  |  |  |  | Treasurer |  | Athletics Club - Other - Honorarium Payments - Treasurer
 |  | Stadium |  |  |  |  | Stadium
 |  |  | [NAME] |  |  |  | Stadium - Stadium Hire - Honorarium Payments
 |  |  | Gym Franchise |  |  |  | Stadium - Gym Franchise - Honorarium Payments
 |  |  |  | Gym Franchise Fee |  |  | Stadium - Gym Franchise - Gym Franchise Fee
Spreadsheet: 843506d1695307151-copying-over-date-in-separate-sheet-with-new-rows-book1-2-
Sheet: Sheet1

 | 2023-09-20 00:00:00 | 2023-09-21 00:00:00 | 2023-09-22 00:00:00
D | QQ | WWW | RRRR
P | WW | EEE | FFFF
I | EE | RRR | DDDD
N | 1 | 11 | 66
D | AA
P | SS
I | DD
N | 2
D |  | SSS
P |  | DDD
I |  | FFF
N |  | 55
D | ZZ | GGG
P | XX | HHH
I | CC | KKK
N | 3 | 77
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
D
P
I
N
Spreadsheet: 718927d1613414199-need-help-removing-non-duplicates-remove-nd
Sheet: Sheet1

 | SellerID | GrossSales | NetSales |  |  | SellerID | GrossSales | NetSales
 | 1 | 335 | 335
 | 1 | 336 | 336
 | 2 | 337 | 337
 | 2 | 338 | 338
 | 2 | 339 | 340
 | 2 | 340 | 342
 | 1 | 341
 | 1 | 342
Spreadsheet: 740052d1626164902-how-to-return-the-value-of-the-last-item-in-a-list-find-last-item-in-a-list
Sheet: Sheet1

Latest Statistics
I want a formula to return the last item in each list below, with the reult displayed in the yellow highlight.
Economic Statistics
Date | Inflation rate | Money Supply $trillions | Gold Price
2020-12-31 00:00:00 | 0.011 | 20.1 | 1608.2
2021-04-30 00:00:00 | 0.028 | 21.9 | 1992.3
2021-05-31 00:00:00 | 0.047 |  | 1798.2
2021-06-30 00:00:00 |  |  | 1738.5
Spreadsheet: 291835-automatically-copy-a-row-of-data-from-one-sheet-to-another-routsheet
Sheet: 1201

RO# | OWNERS NAME | TAG | ADVISOR | [NAME] OF WORK | PROMISE TIME | 10 | 12 | 2 | 4 | DISPATCH TIME
26919 | SHORT | 437 | 1044 | RECALL | EOD
26925 | GMC | 984 | 984 | RUST INHIBATOR | 3
75011 | TERWAL | 237 | 1013 | SES/LOF | WEEK VACATION
75056 | MURRAY | 199 | 129 | [NAME] | EOD
75060 | KRUEGER | 880 | 1044 | DIFF TUBE | WAIT
Spreadsheet: 703348d1604952653-possible-vlookup-badge2-etaf
Sheet: Sheet1

Name | Primary|Labor Acct | Sch|Hours | Proj|Hours | ACA Status | Phone 2 | Phone 3 | Row Type | Day | Primary Job | Shift Start Date | Shift Start Time | Shift End Time | Shift End Date | Segment Start Date | Type | Segment Start Time | Segment End Time | Segment End Date | Sch Hrs.
Doe, [NAME] | 1001100 | 8 | 0 |  | (789) 854-7514 |  | Shift | Mon |  | 2020-11-09 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-09 00:00:00 | 2020-10-30 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-10-30 00:00:00 | 4
Doe, [NAME] | 1001100 | 8 | 0 |  | (789) 854-7515 |  | Shift | Tue |  | 2020-11-09 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-09 00:00:00 | 2020-10-30 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-10-30 00:00:00 | 1
Doe, [NAME] | 1001100 | 8 | 0 |  | (789) 854-7516 |  | Shift | Wed |  | 2020-11-09 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-09 00:00:00 | 2020-10-30 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-10-30 00:00:00 | 4
Spreadsheet: 273351d1382688208-dynamic-matching-cell-in-table-and-returning-column-example
Sheet: Table

 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | BIG | LARGE | TINY | CLOTHES | FROGS | BEAR | ICE | CREAM | TIE | ST | LT | HH | OP
A
B
C
E
D
F
H
G
Spreadsheet: 167616d1342039439-matching-certain-index-values-to-dates-in-a-separate-table-test
Sheet: Table 1

20120709
20120709
20120709
20120709
20120709
20120709
20120709
20120709
20120709
20120709
20120710
20120710
20120710
20120710
20120710
20120710
20120710
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
20120711
Spreadsheet: 201c1a6e-2c59-4ef4-9994-ab4240b7809f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Full Year 2010 - Largest U.S. Venture Capital Investments
Qtr | Company | City | State | Industry | Stage of Development | Investment Sequence | Amount | Business Description | Investors
2 | Better Place, Inc. | Palo Alto | CA | Industrial/Energy | Expansion | 2 | 350000300 | Develops transportation systems that support electric vehicles. | Morgan Stanley Private Equity,Undisclosed Firm,Undisclosed Firm,VantagePoint Venture Partners
4 | Twitter, Inc. | San Francisco | CA | Media and Entertainment | Expansion | 9 | 200000000 | Provides online social networking and microblogging services. | Kleiner Perkins Caufield & Byers,Undisclosed Firm
2 | BrightSource Energy, Inc. | Oakland | CA | Industrial/Energy | Later Stage | 6 | 150000000 | Develops utility-scale solar power plants. | Draper Fisher Jurvetson,Morgan Stanley Private Equity,Undisclosed Firm,Undisclosed Firm,VantagePoint Venture Partners
4 | Abound Solar, Inc. | Loveland | CO | Industrial/Energy | Expansion | 4 | 111000000 | Manufactures thin-film photovoltaic (PV) modules. | DCM,Invus Group Ltd., The,Technology Partners,Undisclosed Firm
3 | Trilliant, Inc. | Redwood City | CA | Telecommunications | Later Stage | 2 | 105999800 | Provides wireless network solutions for grid management applications. | Investor Growth Capital AB,Investor Growth Capital, Inc.,MissionPoint Capital Partners,UMC Capital,Undisclosed Firm,Undisclosed Firm,VantagePoint Venture Partners,Zouk Ventures, Ltd.
4 | Elevance Renewable Sciences, Inc. | Bolingbrook | IL | Industrial/Energy | Expansion | 3 | 100000000 | Produces specialty chemicals from natural oils. | TPG Capital,TPG Growth,Undisclosed Firm
1 | HighTower Holding, LLC | Chicago | IL | Business Products and Services | Expansion | 2 | 99999900 | Provides investment management services. | DLB Capital LLC,[NAME],M.D. Sass Investors Services, Inc.,Undisclosed Firm,Undisclosed Firm,Undisclosed Firm
2 | Casa Systems, Inc. | Andover | MA | Networking and Equipment | Later Stage | 1 | 96460000 | Develops network edge devices for IP video and broadband IP services. | Summit Partners
1 | Pierpont Securities LLC | Stamford | CT | Financial Services | Expansion | 1 | 84999900 | Operates as a broker-dealer of government securities. | General Atlantic LLC,Stone Point Capital LLC,Undisclosed Firm
4 | Fisker Automotive, Inc. | [NAME] | CA | Industrial/Energy | Later Stage | 7 | 78078900 | Manufactures electric vehicles. | Advanced Equities Capital Partners LLC,Kleiner Perkins Caufield & Byers,Palo Alto Investors
 | Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 879694d1727265067-need-help-with-if-function-where-one-of-the-condition-is-related-to-blank-cells-sample-data
Sheet: Sheet1

Plan cancelled | member cancelled | Transaction cancelled (YES?NO) | NOTES |  |  |  |  | Tried Formula 1 | Tried [NAME]
False | 2020-11-25 15:03:00 | YES | YES because column B is not blank
False |  | NO | NO because column A is [NAME] and B is blank
True | 2021-02-12 16:16:00 | YES | YES bcause column A is TRUE
True |  | YES | YES bcause column A is TRUE and B is blank
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Replace Costs - Results 1-5

Table 5.2.3.  Replacement Costs (Years 1 to 5)
Current Inflation Rate based on Construction Cost Index: |  |  |  | EPA Discount Rate: | 0.04875
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 1 | 2 | 3 | 4 | 5
 |  |  | Total Present Value of Replacement Costs (Years 1 to 5):
Spreadsheet: 91004d1290686027-finalize-to-my-stock-report-stock-balance-record
Sheet: INDEX

Stock summary Report
Total Stock Value (Rs) :- |  | 45500
Item # | Item Name | Current Balance | Unit Price (Rs) | Item Value (Rs)
01 | Table lamp | 350 | 50 | 17500
02 | Tube lights | 355 | 25 | 8875
03 | CFL bulbs | 425 | 45 | 19125
Spreadsheet: 5645d9f7-4ac4-44ac-802b-80c3a368200a
Sheet: New Table 9

Weekly Barge Rates for Major Grain Shipping Points on the Mississippi, Ohio, and Arkansas Rivers
Table 9
Weekly Barge Freight Rates:  Southbound Only
 |  | Twin         Cities | Mid-Mississippi | Lower Illinois         River | St. Louis | Cincinnati | Lower         Ohio | Cairo-Memphis
Rate1 | 2013-05-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  | -
$[NAME]
 |  |  |  | n/a
Current week % change from the same week:
 | Last year
 | 3-year avg. 2
Rate1 | June
 | August
1Rate = percent of 1976 tariff benchmark index (1976 = 100 percent); 24-week moving average; ton = 2,000 pounds
Source:  Transportation & Marketing Programs/AMS/USDA
 |  | TWC | MM | ILL | ST LOUIS |  | LOH | CAR-MEM
[NAME] |  | 6.19 | 5.32 | 4.64 | 3.99 | 4.69 | 4.04 | 3.14
Spreadsheet: 0f469014-59fc-4fd6-89e1-7cb4bac0480a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Amount
610 | [NAME] |  |  | 700 | 700
 | Laminating supplies for 2nd grade book project |  |  | 200
 | Printer cartridges for writing center |  |  | 300
 | General supplies (transparency film, pens, library supplies) |  |  | 200
643 | Books |  |  | 8750 | 8750
 | Support for new science curriculum: weather, geology, astronomy titles |  |  | 900
 | Collection development schedule (900s); support of social studies units: American history, countries, geography |  |  | 2000
 | Books for circulating classroom collections for emergent readers |  |  | 3500
 | Professional books: Brain research faculty study group |  |  | 200
 | Software/Non Print |  |  | 1750 | 1750
 | Iowa Children's Choice titles |  |  | 400
644 | Periodicals |  |  | 400 | 400
 | Paper and online subscriptions |  |  | 400
650 | Computer Software |  |  | 500 | 500
 | Assistive technology requested by SCI classes |  |  | 300
 | Additional Kidspiration licenses |  |  | 200
660 | Audiovisual/Non-Print |  |  | 528 | 528
 | DVDs General Music |  |  | 148
 | Audio Book downloads 3rd Grade |  |  | 380
 |  |  | TOTAL |  | 12628
A separate sheet including a brief, written rationale for each line item and ties to building goals should be included with the spreadsheet.
An Excel template to help you keep track of budget expenditures is available at
http://www.iccsd.k12.ia.us/library/LibAdmin.htm (Budget Template)