tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 749722d1632984361-calculate-no-of-days-if-every-month-has-30-days-30092021-sample-file
Sheet: Sheet1

Interest Date 1 | Interest Date 2 |  | No of Days |  | Upto Date : >> | 2021-09-30 00:00:00
2021-03-25 00:00:00 | 2021-09-25 00:00:00
2021-03-25 00:00:00 | 2021-09-25 00:00:00
2021-03-25 00:00:00 | 2021-09-25 00:00:00
2021-04-09 00:00:00 | 2021-10-09 00:00:00 |  |  |  | 2021-04-01 00:00:00 | 22
2021-04-09 00:00:00 | 2021-10-09 00:00:00 |  |  |  | 2021-05-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-06-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-07-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  | 2021-09-01 00:00:00 | 30
2021-06-12 00:00:00 | 2021-12-12 00:00:00 |  |  |  |  |  | <<< Result must be this
2021-06-12 00:00:00 | 2021-12-12 00:00:00
2021-04-29 00:00:00 | 2021-10-29 00:00:00
2021-04-29 00:00:00 | 2021-10-29 00:00:00 |  |  |  | These are interest interval dates
2021-01-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  | Every month have only 30 days
2021-01-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  | If Upto date is > Interest date 2 then days must be calculate from Interest date 1
2021-01-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  | else interest date 2 has to be consider for no. of days calculation
2021-12-10 00:00:00 | 2021-06-10 00:00:00
2021-12-17 00:00:00 | 2021-06-17 00:00:00
2021-12-03 00:00:00 | 2021-06-03 00:00:00
2021-12-03 00:00:00 | 2021-06-03 00:00:00
2021-12-03 00:00:00 | 2021-06-03 00:00:00
2021-11-20 00:00:00 | 2021-05-20 00:00:00
2021-02-26 00:00:00 | 2021-08-26 00:00:00
2021-03-09 00:00:00 | 2021-09-09 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-03-23 00:00:00 | 2021-09-23 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-03-19 00:00:00 | 2021-09-19 00:00:00
2021-01-28 00:00:00 | 2021-07-28 00:00:00
2021-06-02 00:00:00 | 2021-12-02 00:00:00
2021-06-02 00:00:00 | 2021-12-02 00:00:00
2021-06-15 00:00:00 | 2021-12-15 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
2021-01-14 00:00:00 | 2021-07-14 00:00:00
2021-01-14 00:00:00 | 2021-07-14 00:00:00
2021-03-16 00:00:00 | 2021-09-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-11-27 00:00:00 | 2021-05-27 00:00:00
2021-11-27 00:00:00 | 2021-05-27 00:00:00
2021-11-27 00:00:00 | 2021-05-27 00:00:00
2021-12-10 00:00:00 | 2021-06-10 00:00:00
2021-12-24 00:00:00 | 2021-06-24 00:00:00
2021-12-24 00:00:00 | 2021-06-24 00:00:00
2021-06-16 00:00:00 | 2021-12-16 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
2021-05-25 00:00:00 | 2021-11-25 00:00:00
Spreadsheet: 793889d1661784009-extract-entire-row-based-on-one-or-more-value-to-create-a-list-in-a-new-sheet-report_1
Sheet: 26082022

Name | Availability User Requirement | Feasibility Delivery | Feasibility Approval | [NAME] | BBP delivery | [NAME] | Release to Final Acceptance | Intermediate  Go-Live  1 | Intermediate  Go-Live  2 | Intermediate  Go-Live  3 | Intermediate  Go-Live  4 | Intermediate  Go-Live  5 | Intermediate  Go-Live  6 | Final Go-Live | [NAME]
Project: A | 2020-10-13 00:00:00 | 2021-07-13 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-10-05 00:00:00 | 2021-11-17 00:00:00 | 2022-10-14 00:00:00 |  |  |  |  |  |  | 2022-12-07 00:00:00 | 2023-03-03 00:00:00
Project: B | 2021-01-12 00:00:00 | 2021-03-18 00:00:00 | 2021-03-25 00:00:00 | 2021-04-16 00:00:00 | 2021-06-14 00:00:00 | 2021-07-28 00:00:00 | 2021-10-08 00:00:00 |  |  |  |  |  |  | 2021-12-17 00:00:00 | 2022-02-28 00:00:00
Project: C | 2020-10-13 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-28 00:00:00 | 2021-07-16 00:00:00 | 2021-07-29 00:00:00 | 2021-10-19 00:00:00 |  |  |  |  |  |  | 2021-11-22 00:00:00 | 2022-04-18 00:00:00
Project: D | 2022-09-15 00:00:00
Project: E | 2021-10-11 00:00:00 | 2021-10-26 00:00:00 | 2021-11-03 00:00:00 | 2021-11-11 00:00:00 | 2022-03-21 00:00:00 | 2022-03-31 00:00:00 | 2022-07-04 00:00:00 | 2021-11-23 00:00:00 |  |  |  |  |  | 2022-07-11 00:00:00 | 2022-09-16 00:00:00
Project: F | 2021-12-10 00:00:00 | 2022-06-15 00:00:00 | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 | 2022-08-12 00:00:00 | 2022-09-09 00:00:00 | 2022-10-31 00:00:00 | 2022-10-14 00:00:00 | 2022-11-04 00:00:00 |  |  |  |  | 2022-12-16 00:00:00 | 2023-02-24 00:00:00
Project: G | 2021-12-10 00:00:00 | 2022-02-21 00:00:00 | 2022-02-22 00:00:00 | 2022-03-01 00:00:00 | 2022-03-31 00:00:00 | 2022-04-14 00:00:00 | 2022-07-04 00:00:00 |  |  |  |  |  |  | 2022-09-01 00:00:00 | 2022-10-03 00:00:00
Project: H | 2022-04-12 00:00:00 | 2022-06-15 00:00:00 | 2022-08-11 00:00:00 | 2022-09-03 00:00:00 | 2022-09-30 00:00:00 | 2022-10-14 00:00:00 | 2022-11-14 00:00:00 |  |  |  |  |  |  | 2022-12-01 00:00:00 | 2022-12-21 00:00:00
Project: I | 2022-04-12 00:00:00 | 2022-05-05 00:00:00 | 2022-05-18 00:00:00 | 2022-05-27 00:00:00 | 2022-06-21 00:00:00 | 2022-06-28 00:00:00 | 2022-09-12 00:00:00 |  |  |  |  |  |  | 2022-10-10 00:00:00 | 2022-11-30 00:00:00
Spreadsheet: 856739d1705936775-sorting-fishing-data-in-2-sectors-sorting-a-b
Sheet: Blad1

NAME | SECTOR | FISHING SPOT | WEIGHT (kg) |  |  |  | NAME | SECTOR | FISHING SPOT | WEIGHT (kg)
An | A | 2 | 36 |  |  |  | Nico | B | 50 | 51
Jef | A | 10 | 45 |  |  |  | Jef | A | 10 | 45
Mario | A | 18 | 12 |  |  |  | [NAME] | B | 35 | 44
[NAME] | A | 24 | 15 |  |  |  | An | A | 2 | 36
[NAME] | B | 25 | 19 |  |  |  | Sien | B | 30 | 25
Sien | B | 30 | 25 |  |  |  | [NAME] | A | 24 | 15
[NAME] | B | 35 | 44 |  |  |  | Jules | B | 45 | 24
[NAME] | B | 40 | 23 |  |  |  | Mario | A | 18 | 12
Jules | B | 45 | 24 |  |  |  | [NAME] | B | 40 | 23
Nico | B | 50 | 51 |  |  |  | [NAME] | B | 25 | 19
After the fishing competition, the data is entered as above.  Fishings spots 1 to 24 =  sector A. From 25 tot 50 = Sector B |  |  |  |  |  |  | Now we want to sort as follows. Highest sector on top. In this case this is sector B with 51 kg as highest weight. So the first in sector B, first in sector A, 2nd in sector B, 2nd in sector A, …
Spreadsheet: mary_fischer__25636__31S
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031S
COMPANY NAME   Limbach Company
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 109007d1305914759-how-do-i-create-work-day-only-calendar-dates-tape-return-tracker
Sheet: June

2011
2011-06-01 00:00:00
Day | Date | # of Tapes to be Returned (Report) | # of Tapes to be Returned | Date to be Returned
Monday
Tuesday
Wednesday | 2011-06-01 00:00:00 |  |  | 2011-06-02 00:00:00
Thursday | 2011-06-02 00:00:00 |  |  | 2011-06-03 00:00:00
Friday | 2011-06-03 00:00:00 |  |  | 2011-06-06 00:00:00
Monday | 2011-06-06 00:00:00 |  |  | 2011-06-07 00:00:00
Tuesday | 2011-06-07 00:00:00 |  |  | 2011-06-08 00:00:00
Wednesday | 2011-06-08 00:00:00 |  |  | 2011-06-09 00:00:00
Thursday | 2011-06-09 00:00:00 |  |  | 2011-06-10 00:00:00
Friday | 2011-06-10 00:00:00 |  |  | 2011-06-13 00:00:00
Monday | 2011-06-13 00:00:00 |  |  | 2011-06-14 00:00:00
Tuesday | 2011-06-14 00:00:00 |  |  | 2011-06-15 00:00:00
Wednesday | 2011-06-15 00:00:00 |  |  | 2011-06-16 00:00:00
Thursday | 2011-06-16 00:00:00 |  |  | 2011-06-17 00:00:00
Friday | 2011-06-17 00:00:00 |  |  | 2011-06-20 00:00:00
Monday | 2011-06-20 00:00:00 |  |  | 2011-06-21 00:00:00
Tuesday | 2011-06-21 00:00:00 |  |  | 2011-06-22 00:00:00
Wednesday | 2011-06-22 00:00:00 |  |  | 2011-06-23 00:00:00
Thursday | 2011-06-23 00:00:00 |  |  | 2011-06-24 00:00:00
Friday | 2011-06-24 00:00:00 |  |  | 2011-06-27 00:00:00
Monday | 2011-06-27 00:00:00 |  |  | 2011-06-28 00:00:00
Tuesday | 2011-06-28 00:00:00 |  |  | 2011-06-29 00:00:00
Wednesday | 2011-06-29 00:00:00 |  |  | 2011-06-30 00:00:00
Thursday | 2011-06-30 00:00:00 |  |  | 2011-07-01 00:00:00
Friday
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 13b

Product1 | HY6 | IG | Other | TOTAL
Index Tranche | 43559 | 412858 | 409004 | 865421
Europe | 0 | 0 | 403233 | 403233
North America/Asia | 43559 | 412858 | 5771 | 462188
Index | 626717 | 2580346 | 3753948 | 6961011
Asia | 0 | 0 | 111361 | 111361
Europe | 0 | 0 | 3311964 | 3311964
North America | 626717 | 2580346 | 99401 | 3306464
Other | 0 | 0 | 231222 | 231222
OTHER* | 0 | 0 | 797295 | 797295
TOTAL | 670276 | 2993204 | 4960247 | 8623727
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 805292d1668614654-a-woodworker-in-need-of-help-with-if-function-with-sum-as-a-condition-new-template-2022
Sheet: Test Template

Material Cost
 |  | Price per unit |  |  |  |  |  |  | Primary Wood | grapia
 |  |  |  |  |  |  |  |  | Secondary Wood | Lenga
 |  |  |  |  |  |  |  | Final Dimensions
Drawer runners | 3 | 18
Tooling | 1 | 35 |  |  |  |  |  | Wood | Element | Quantity | Length | [NAME] | Thickness | m2
 |  | Total |  |  |  |  |  | 1st | Top/Bottom | 2 | 3 | 0.8 | 0.045 |  |  | IF(K9>(J22*0.18),"K2",K2/2)
Labor Cost |  |  |  |  |  |  |  | 1st | Walls | 2 | 0.8 | 0.8 | 0.03
Time |  | Price per minute |  |  |  |  |  | 1st | Back | 1 | 3 | 0.8 | 0.01
Processing |  | 5 |  |  |  |  |  | 1st | Legs | 4 | 0.5 | 0.05 | 0.05
Cutting All pieces | 3 | 40 |  |  |  |  |  | 1st | Sttrecther | 2 | 2.8 | 0.1 | 0.05
Drawers | 6 | 40 |  |  |  |  |  | 1st | Rails | 2 | 0.8 | 0.05 | 0.05
Glue up | 6 | 30 |  |  |  |  |  | 1st | Seperations | 2 | 0.8 | 0.8 | 0.02
Sanding | 5 | 30 |  |  |  |  |  | 1st | Doors | 3 | 1 | 0.8 | 0.02
Finish | 10 | 20
Assemply and cutting joints | 4 | 40
Delivery | 0 | 350 |  |  | RAW LUMBER
Stacking | 0 | 100
 |  | Total |  |  |  |  |  |  | length | thickness | width | quantity | m2 | m3 | Price/m3 | Price | [NAME]
Shop Costs |  | 14 |  |  |  |  |  |  | 3.6 |  | 0.18 |  |  |  | 1780
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18 | 2 |  |  | 1780
 |  | Construction Total |  |  |  |  |  |  | 3.6 |  | 0.18 | 2 |  |  | 1780
 |  | Profit |  |  |  |  |  |  | 3.6 |  | 0.18 | 2 |  |  | 0
 |  | Total |  |  |  |  |  |  | 3.6 |  | 0.18 |  |  |  | 0
 |  | IVA |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
Spreadsheet: 816894d1675875994-formula-to-return-text-when-multiple-cells-containing-specific-words-meet-conditions-example
Sheet: Sheet1

What Form Was Submitted | In Database? | [NAME] | RETURN VALUE
Delete | Yes | Expire | Submit Deletion Request
Do Not Sell | No | N/A | No action required
Both | No | N/A | No action required
Delete | No | N/A | No action required
Do Not Sell | Yes | Cancelled | No action required
Both | Yes | Active | Inform customer of status
Delete | Yes | Credit Pending | Inform customer of status
Spreadsheet: 2d492183-e9ab-42ed-9a0e-6762aff26d50
Sheet: SEG1

 | ADVANCED MICRO DEVICES, INC.
 | SELECTED CORPORATE DATA
 | (Millions except headcount)
 |  |  | Quarter Ended
 |  |  |  | Apr. 2, |  |  | Dec. 25, |  |  | Mar. 27,
 | Segment and Category Information |  |  | 2011 |  |  | 2010 |  |  | 2010
 | [NAME] (1)
 |  | Net revenue |  | 1200 |  |  | 1219 |  |  | 1160
 |  | Operating income |  | 100 |  |  | 91 |  |  | 146
 | Graphics (2)
 |  | Net revenue |  | 413 |  |  | 424 |  |  | 409
 |  | Operating income |  | 19 |  |  | 68 |  |  | 47
 | All Other (3)
 |  | Net revenue |  | 0 |  |  | 6 |  |  | 5
 |  | Operating income (loss) |  | -65 |  |  | 254 |  |  | -11
 | Total
 |  | Net revenue |  | 1613 |  |  | 1649 |  |  | 1574
 |  | Operating income |  | 54 |  |  | 413 |  |  | 182
 | Other Data
 |  | Depreciation and amortization
 |  | (excluding amortization of acquired intangible assets) |  | 79 |  |  | 78 |  |  | 83
 |  | Capital additions |  | 38 |  |  | 38 |  |  | 48
 |  | Adjusted EBITDA (4) |  | 198 |  |  | 241 |  |  | 302
 |  | Cash, cash equivalents and marketable securities |  | 1745 |  |  | 1789 |  |  | 1932
 |  | Adjusted free cash flow (5) |  | 154 |  |  | 11 |  |  | 177
 |  | Total assets |  | 5209 |  |  | 4964 |  |  | 5232
 |  | Long-term debt and capital lease obligations, including the current portion |  | 2196 |  |  | 2192 |  |  | 2604
 |  | Headcount |  | 11256 |  |  | 11068 |  |  | 10365
 | See footnotes on the next page
Spreadsheet: 875436d1722001253-sum-based-on-multiple-criteria-demo-260724-1-
Sheet: Vertical TB - Match index

G2 | G3 | G4 |  | F | Months
Main Vertical | PC Name | PC Code | FS Item/Acct/FA Long | GL Code | 2024-04-01 00:00:00 | 2024-05-01 00:00:00
Head Office | Head Office | 629050001 | Fully Paid Equity Sh MMC /10010000 | 10010000
Franchisee | [NAME] | 629060001 | Fully Paid Equity Sh MMC /10010000 | 10010000
Franchisee | Fran East | 629060002 | Fully Paid Equity Sh MMC /10010000 | 10010000
Franchisee | Fran South | 629060003 | Fully Paid Equity Sh MMC /10010000 | 10010000
Head Office | Head Office | 629050001 | Share Application Eq MMC /10050000 | 10050000
Franchisee | [NAME] | 629060001 | Share Application Eq MMC /10050000 | 10050000
Franchisee | Fran East | 629060002 | Share Application Eq MMC /10050000 | 10050000
Franchisee | Fran South | 629060003 | Share Application Eq MMC /10050000 | 10050000
 |  |  |  |  |  |  |  |  | Months
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
 |  |  |  |  |  |  |  |  |  |  | <------Result
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Project Priority Summary

 | Project Priority Summary (Total Project Costs)
 | Building | High Priority | Medium Priority | Low Priority | Projects Underway | Total | Comments
 | qetbetbdabnadfb | 0 | 0 | 0 | 0 | 0
 | Building2 | 0 | 0 | 0 | 0 | 0
 | Building3 | 0 | 0 | 0 | 0 | 0
 | Building4 | 0 | 0 | 0 | 0 | 0
 | Building5 | 0 | 0 | 0 | 0 | 0
 | Building6 | 0 | 0 | 0 | 0 | 0
 | Building7 | 0 | 0 | 0 | 0 | 0
 | Building8 | 0 | 0 | 0 | 0 | 0
 | Building9 | 0 | 0 | 0 | 0 | 0
 | Building10 | 0 | 0 | 0 | 0 | 0
 | Building11 | 0 | 0 | 0 | 0 | 0
 | Building12 | 0 | 0 | 0 | 0 | 0
 | Building13 | 0 | 0 | 0 | 0 | 0
 | Building14 | 0 | 0 | 0 | 0 | 0
 | Building15 | 0 | 0 | 0 | 0 | 0
 | Building16 | 0 | 0 | 0 | 0 | 0
 | Building17 | 0 | 0 | 0 | 0 | 0
 | Building18 | 0 | 0 | 0 | 0 | 0
 | Building19 | 0 | 0 | 0 | 0 | 0
 | Building20 | 0 | 0 | 0 | 0 | 0
 | Total: | 0 | 0 | 0 | 0 | 0
 | The above budgetary construction costs INCLUDE "soft" or incidental costs, which are described in detail below
 | TYPICAL ANTICIPATED SOFT COSTS FOR A CAPITAL PROJECT INCLUDE:
 | Design Contingency | 0.1
 | [NAME] | 0.1
 | Incidentals (Soft Costs) | 0.25
 | Architectural/ Engineering Professional Services
 | Construction Administration - Construction Manager, [NAME]-of-Works, etc..
 | Soils, Surveys, Testing and Monitoring
 | Furniture/ Fixtures/ Equipment (FF&E)
 | Legal Fees
 | Insurances
 | Bonding Costs
 | Printing and Reproduction Expenses
 | Other
 | Escalation Factor (Inflation) | 0.05
 | These estimates are general in nature and should be used for budget planning purposes only. They are based on anticipated 2010 unit prices and cost indices and should be adjusted for unusual inflation and other market-driven fluctuations.
Spreadsheet: 167109d1341904378-help-me-to-use-grouping-filters-sample
Sheet: Sheet1

Sales
 | Division 1
 |  | Product 1
 |  | Product 2
 |  | Product 3
 | Division 2
 |  | Product 4
 |  | Product 5
 |  | Product 6
 | Division 3
 |  | Product 7
 |  | Product 8
 |  | Product 9
 | Division 4
 |  | Product 10
 |  | Product 11
 |  | Product 12
Cost of Sales
 | Division 1
 |  | Cost 1
 |  | Freight 1
 |  | Others 1
 | Division 2
 |  | Cost 2
 |  | Freight 2
 |  | Others 2
 | Division 3
 |  | Cost 3
 |  | Freight 3
 |  | Others 3
 | Division 4
 |  | Cost 4
 |  | Freight 4
 |  | Others 4
Expenses
 | Division 1
 |  | Salaries
 |  |  | Staff 1
 |  |  | Staff 2
 |  |  | Staff 3
 |  |  | Staff 4
 |  |  | Staff 5
 |  | Rent
 |  |  | Office 1
 |  |  | Warehouse 1
 |  |  | Showroom 1
 |  | Telephone
 |  |  | [NAME]
 |  |  | tel 2
 |  |  | tel 3
 |  |  | tel 4
 | Division 2
 |  | Salaries
 |  |  | Staff 1
 |  |  | Staff 2
 |  |  | Staff 3
 |  |  | Staff 4
 |  |  | Staff 5
 |  | Rent
 |  |  | Office 2
 |  |  | Warehouse 2
 |  |  | Showroom 2
 |  | Telephone
 |  |  | [NAME]
 |  |  | tel 2
 |  |  | tel 3
 |  |  | tel 4
 | Division 3
 |  | Salaries
 |  |  | Staff 1
 |  |  | Staff 2
 |  |  | Staff 3
 |  |  | Staff 4
 |  |  | Staff 5
 |  | Rent
 |  |  | Office 3
 |  |  | Warehouse 3
 |  |  | Showroom 3
 |  | Telephone
 |  |  | [NAME]
 |  |  | tel 2
 |  |  | tel 3
 |  |  | tel 4
Spreadsheet: 72724a93-5b7b-4a51-91f1-afc752bfff72
Sheet: Budget Adjustment

BUDGET ADJUSTMENT
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
Authorizing the Director of Public Works to execute a cooperative agreement with the City of Gladstone
for federal Transportation Enhancement funds for the Shoal Creek Trail, estimating revenue and authorizing expenditure
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
 |  |  |  |  | Public Works
 |  |  |  |  | From/Transferor(s) or Fund Title(s)
 |  |  |  |  | 11-3090-890001-474630- 89020070
 |  |  |  |  | 411039.87
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | 11-3090-898101-B-89020070 Shoal Creek Valley
 |  |  |  |  | Trails
 |  |  |  |  | Policy / Program Impact
 |  |  |  |  | Policy or Program | No | Yes
 |  |  |  |  | Emphasis Change
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
 |  |  |  |  | Fact Sheet prepared by: |  | Date
 |  |  |  |  | [NAME] |  | 2010-11-16 00:00:00
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | Reference Numbers
Spreadsheet: 685329d1593927716-sum-the-deposit-as-well-deduct-withdrawal-from-opening-balance-and-return-blance-bank-1-
Sheet: Sheet1

 |  |  |  |  | OPENING BALANCE | 500
S.No | DATE | MODE | PARTICULARS | DEPOSITS | WITHDRAWLS | BALANCE | REMARKS
1 | 2020-01-01 00:00:00 | DEPOSIT | ACCOUNT DEPOSIT | 100
 | 2020-01-02 00:00:00 | WITHDRAWLS | DRIVER BETA |  | 200
 | 2020-01-03 00:00:00 | WITHDRAWLS | Service |  | 600 |  |  |  | over the balace withdrawl should not accept
 | 2020-01-04 00:00:00
 | 2020-01-05 00:00:00
 | 2020-01-06 00:00:00
 | 2020-01-07 00:00:00
Spreadsheet: 792905d1661215758-number-of-items-sold-out-of-total-number-of-items-ebay-items-example
Sheet: Sheet1

EBAY | Items Sold:
Items | Notes | Selling Price | Sold
Item 1 |  | 100
Item 2 |  | 50 | 50
Item 3 |  | 50
Item 4 |  | 110
Item 5 |  | 20 | 22
Item 6 |  | 200
Item 7 |  | 90
Item 8 |  | 60
Item 9 |  | 140
Item 10 |  | 140
Item 11 |  | 25
Item 12 |  | 170
Item 13 |  | 170
Item 14 |  | 90
Item 15 |  | 140
Item 16 |  | 20
Item 17 |  | 35
Item 18 |  | 140
Item 19 |  | 85
Item 20 |  | 150
Item 21 |  | 150
Item 22 |  | 125
Item 23 |  | 125
Item 24 |  | 20
Item 25 |  | 180
Item 26 |  | 75
Item 27 |  | 90
Item 28 |  | 140
Item 29 |  | 300
Item 30 |  | 300
 | Total:
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: Ta

Thompson. A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 791132d1660166787-sliding-scale-formula-correction-sample_v3
Sheet: Reformat

 | Commission Table
 | [NAME] | [NAME] | [NAME] | Base Fee | Adjust | #1 MAX
 | 0 | 5000000 | 0.01 |  |  | 0
 | 5000000.01 | 10000000 | 0.009
 | 10000000.01 | 20000000 | 0.008
 | 20000000.01 | 30000000 | 0.007
 | 30000000.01 | 40000000 | 0.006
 | 40000000.01 | 50000000 | 0.005
 | Sales Amount | 20000001
 | #2 BASE FEE
 | #3 MAX LOOKUP
 | #4 LARGER
 | Test
 | Amount | % | Base Fee
 | 20000000
 | 20000001
Spreadsheet: 774724d1648636067-split-cells-book1
Sheet: Sheet1

 | Cat | Dog | Chicken | Hamster | Rabbit
CAT; DOG; CHICKEN; HAMSTER; RABBIT
CHICKEN; RABBIT
DOG; HAMSTER; RABBIT
Spreadsheet: 133541d1324473678-excel-formula-search-for-colour-colourfunction2
Sheet: Sheet1

Test1 |  | OPTIONS | 1 | AVERAGE | 5
1 |  |  | 2 | SUM: | 10
2 |  |  | 3 | MIN: | 1
9 |  |  | 4 | MAX: | 10
 |  |  | 5 | DEV: | 5.656854249492381
 |  |  | 6 | Count | 2
Spreadsheet: 125141d1318895758-validation-list-date-based-formula-dan17602-pick-a-month
Sheet: Sheet1

Name | Start | End | List
January |  |  |  |  |  | Pick your month here->
February
March
April
May
June
July
August
September
October
November
December
 | Today's Date: | 2011-10-17 00:00:00 | Type in any date here to simulate today's date
 |  |  | Normally you would use =TODAY()