tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 74136d1274727041-pivot-table-appointments
Sheet: Sheet1

Year | (All)
Completion | (All)
Week Ending | (All)
Count of Minutes
Employee | Total
0003 | 7
0007 | 10
0017 | 7
0050 | 9
0055 | 9
0056 | 6
0059 | 8
0062 | 7
0063 | 7
0067 | 6
0265 | 6
0331 | 1
0348 | 3
0354 | 6
0369 | 1
0379 | 6
0419 | 5
0470 | 1
0483 | 8
0508 | 10
0523 | 10
0525 | 2
0537 | 9
0547 | 6
0550 | 1
0569 | 4
0577 | 8
0579 | 3
0583 | 9
0595 | 8
0597 | 11
0612 | 10
0680 | 18
0682 | 10
0717 | 1
0722 | 8
0724 | 9
0725 | 15
0735 | 12
0973 | 6
1121 | 6
1134 | 6
1197 | 2
1213 | 3
1279 | 5
1283 | 1
1313 | 1
1329 | 3
1331 | 4
1343 | 2
1347 | 5
1481 | 2
1622 | 1
1660 | 2
1696 | 1
1823 | 12
2143 | 6
3007 | 4
3014 | 5
3067 | 4
3175 | 1
3221 | 3
3234 | 7
3235 | 8
3245 | 19
3250 | 19
3251 | 18
3275 | 5
3281 | 25
3311 | 12
3319 | 16
3320 | 5
5211 | 1
9203 | 1
9301 | 2
9539 | 16
Grand Total | 516
Spreadsheet: 805573d1668775239-cumulative-sum-with-condition-classeur
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | JAM54S30-405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | Bauer Solar Glas-Glas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | Bauer Solar Glas-Glas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | JAM54S30-405
Spreadsheet: 153715d1336027215-how-do-i-sumif-a-date-range-using-rows-not-columns-copy-of-cashflow-statement-1
Sheet: Sheet1

Column Labels
Advertising | Cash on Hand (Beginning of Day) | CASH PAID OUT | CASH RECEIPTS | Cash Sales | Chicken | Coca Cola Amatil | Decosti | Discount Packaging | EFTPOS Sales | Fresh Vegetables | Juice | [NAME]'s Withdrawal | Miscellaneous (Specify) | Other (Specify) | Rent | Repairs & maintenance | SUBTOTAL | Telephone | Tonkin | TOTAL CASH PAID OUT | TOTAL CASH RECEIPTS | Utilities (Electricity) | Utilities (Gas) | Utilities (Water/Waste) | Wages | (blank) | Grand Total
Spreadsheet: 749569d1632904241-sum-multiple-values-from-cells-beneath-a-certain-number-book1
Sheet: Sheet1

 | 2021-09-13 00:00:00 | Start | 08:00:00 | 10:00:00 | 10:30:00 | 13:00:00
 |  | Slut | 10:00:00 | 10:30:00 | 12:30:00 | 17:00:00
 |  | Aktivitet |  |  |  |  |  |  |  |  |  | 123
 |  | [NAME]. | 123 | 112576 | 123 | 123 |  |  |  |  | SUM:
 |  | Intervall
 |  | Total tid
 | 2021-09-14 00:00:00 | Start | 09:00:00 | 11:00:00 | 12:30:00 | 15:00:00 | 16:00:00
 |  | Slut | 11:00:00 | 12:00:00 | 15:00:00 | 16:00:00 | 17:30:00
 |  | Aktivitet
 |  | [NAME]. | 112576 | 123 | 123 | 112576 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-15 00:00:00 | Start | 08:00:00 | 13:00:00
 |  | Slut | 12:30:00 | 17:00:00
 |  | Aktivitet
 |  | [NAME]. | D0014827 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-16 00:00:00 | Start | 08:00:00 | 11:00:00 | 14:00:00
 |  | Slut | 11:00:00 | 13:00:00 | 17:30:00
 |  | Aktivitet
 |  | [NAME]. | D0014827 | 112576 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-17 00:00:00 | Start | 08:00:00 | 15:00:00 | 17:30:00
 |  | Slut | 13:00:00 | 16:30:00 | 20:00:00
 |  | Aktivitet
 |  | [NAME]. | 123 | 6096461 | D0014827
 |  | Intervall
 |  | Total tid
 | 2021-09-18 00:00:00 | Start
 |  | Slut
 |  | Aktivitet
 |  | [NAME].
 |  | Intervall
 |  | Total tid
 | 2021-09-19 00:00:00 | Start | 15:30:00
 |  | Slut | 17:30:00
 |  | Aktivitet
 |  | [NAME]. | D0014827
 |  | Intervall
 |  | Total tid
Spreadsheet: 767223d1644342390-sorting-in-several-tables-book1123
Sheet: Sheet1

 |  | nr | score |  | nr | score |  | nr | score
 |  | 582 | 0
 |  | 576 | 2.4
 |  | 568 | 3
 |  | 538 | -0.2
 |  | 534 | 3
 |  | 508 | 4
 |  | 473 | 4
 |  | 453 | 0.8
 |  | 428 | 2.2
 |  | 406 | 2.6
 |  | 405 | -1
 |  | 404 | 1.2
 |  | 371 | -1.4
 |  | 354 | -0.8
 |  | 339 | 1.8
 |  | 326 | 0.2
 |  | 314 | -0.600000000000001
 |  | 288 | 0.6
 |  | 283 | -1.6
 |  | 214 | -1.2
 |  | 206 | 1
 |  | 183 | 1.4
 |  | 163 | 3
 |  | 142 | -1.8
 |  | 135 | 1.6
 |  | 124 | 2
 |  | 84 | 2.8
 |  | 75 | 0.4
 |  | 50 | -0.4
Spreadsheet: 126085d1319517457-showing-ratio-percentage-on-an-excel-chart-boys-versus-girls
Sheet: Sheet1

Item | Boys | Girls
[NAME] | 0.6666666666666666 | 0.3333333333333333
[NAME] | 1 | 1.4
Invisible Ink Pen | 1 | 1
Fake Nose | 0.9 | 0.1
[NAME] | 1 | 1
Squirting Flower | 0.75 | 0.25
Spreadsheet: andy_zipper__100__NGLPlayers
Sheet: Sheet1

Gas Liquids Companies | Group | Size ( A-Big Player…etc.)
BP Amoco | Producer/Trader | A
Coast Energy Group | Wholesale/Retail | A
Conoco, Inc. | Producer/Trader | A
Diamond - Koch | Trader | A
Dow Hydrocarbons & Resources | Consumer | A
Duke Energy NGL Services, Inc. | Producer/Trader | A
DuPont | Consumer | A
Dynegy | Producer/Trader/Wholesale/Retail | A
Enron Corporation | Trader | A
Enterprise Products Co. | Consumer | A
Exxon Mobil | Producer/Trader/Wholesale/Retail | A
Ferrell North America | Trader/Wholesale/Retail | A
Formosa Plastics | Consumer | A
[NAME] | Trader | A
Glencore | Trader | A
Gulfstream | Trader | A
[NAME] | Consumer | A
Kinder Morgan Energy Partners, LP | Producer/Trader | A
[NAME] | Trader | A
Louis Dreyfus Plastics Corp. | Trader | A
Lyondell Chemical/Equistar Chemical | Consumer | A
Marathon Ashland Petroleum | Consumer | A
Mitchell Gas Services LP | Producer/Wholesale | A
NGL Supply, Inc. | Trader/Wholesale/Retail | A
Novarco | Trader | A
PG&E NGL Marketing | Producer/Wholesale/retail | A
Phillips 66 Company | Producer/Wholesale/retail | A
Sea-3 | Trader | A
Shell Trading USA | Trader | A
[NAME] | Wholesale/Retail | A
Texaco Natural Gas Liquids | Producer/wholsale/Retail | A
Texas Petrochemicals Corp. | Consumer | A
Trafigura | Trader | A
Trammo Gas | Wholesale/Retail | A
[NAME] | Wholesale/Retail | A
Venture Oil Company of Texas | Wholesale/Retail | A
Vitol | Trader | A
Westlake Group | Consumer | A
Williams Energy Marketing & Trading | Trader/Wholesale/Retail | A
Spreadsheet: 715282d1611653218-how-to-add-additional-requirements-to-indirect-statements-obsolete-tooling-gk2
Sheet: 20200811 Dan

Material | Short Text | Profit Center | Valuation Class | MRP Controller | MRP | Valuation Type (Batch) | Valuation Type (Batch) | Location | Del. flag: stge type | DF at plant level | Plant-sp.matl status | Total Stock (Qty in Inventory) | Total Value (Value Unrestricted) | Number of Years | Days since consumption | Moving price | Price Unit | OBSOLETE? (Yes / No) | Comments
62-2010-1059-0-00 | PLATE,THRUST DIAL FIXTURE | 619029705 | 7070 | 3 |  | C1 |  | 94-10E3 |  |  |  | 90 | 15271.2 |  | 6307 | 169.68 | 1 | YES
78-5004-0493-0-00 | INSERT,CCC-13491-010 | 619029705 | 7070 | 4 |  | C1 |  | LIS58A2 |  |  |  | 728 | 12411.5 |  | 4236 | 17.05 | 1 | YES
Spreadsheet: tracy_geaccone__40629__ETS Capital
Sheet: Summary

ENRON PIPELINE SERVICES-CO.1195(EOTT)
CAPITAL PROJECTS -2001PLAN ($ in 000's)
 |  |  |  |  | West
 |  |  | Total (A) |  | Coast
Major [NAME]
 | North Area |  | 240
 | Southeast Area |  | 1185
 | Southwest Area |  | 2873 |  | 294 | (NGL Plant / Fractionator / Bakersfield)
 | Total
Liquids Compliance |  |  | 500
California Compliance |  |  | 410 |  | 410
Computers
 | EOTT Computer Refresh |  | 274
 | Windows 2000 & RAM Upgrade |  | 105
TOTAL 2001 CAPITAL OPERATIONS
2001 PIPELINE CONTROLS CAPITAL |  |  | 1600 |  | 481 | Leak Detection - Derby to Ten Station)
TOTAL CAPITAL REQUESTED (A) |  |  |  |  |  | (B)
MAXIMUM QUARTERLY EXPENDITURES  (B) |  |  | 1797 | (B)
NOTE A  All capital projects must be covered by an AFE and must be assigned an EOTT AFE number prior to any expenditures taking place.  Computers and computer software may be covered by a blanket AFE.  All projects which are within 5% or $5000 of budget (whichever is lower) and which are within the planned calendar quarter must be signed by the appropriate EOTT Business Unit Manager and forwarded to EOTT's Fixed Asset Accounting Group where the AFE number will be assigned.  Projects which do not meet the above criteria must be forwarded to EOTT's Treasury Group where they will be reviewed, routed for signature and forwarded to Fixed Asset Accounting.
[NAME] should occur ratably over the year with no more than 25% of total expenditures occuring in one calendar quarter. Expenditures related  to West Coast operations should be deferred until the third quarter of 2001.  Any exceptions must by approved by [NAME].
Spreadsheet: 867692d1714495028-trend-arrows-example-4-aligw
Sheet: Sheet1

Month | AVHT | Month Difference
Mar | 1329
Apr | 1133
May | 1369
Jun | 1092
Jul | 1090
Aug | 1252
Sep | 1203
Oct | 1152
Nov | 897
Dec | 1177
Jan | 1191
Mar | 1221
Apr | 1219
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Spreadsheet: 287887d1389025477-deleting-info-in-locked-cells-columns-test1
Sheet: Routes

Location | Location | [NAME] |  | Location | Location | [NAME] |  | Route | [NAME]
Location1 | Location2 | 19.08
Location1 | Location3 | 28.1
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] |  |  |  |  |  |  |  |  | 9.5
Location2 | Location1 | 19.08
Location2 | Location3 | 32
Loc2
Loc2
Loc2
Loc2
Loc2
Loc2
Loc2
Loc2
Location3 | Location1 | 28.1
Location3 | Location2 | 32
Loc3
 |  |  |  | None | None | 0
Spreadsheet: 274791d1383221197-top-ten-list-based-on-an-certain-criteria-bookx
Sheet: Sheet1

rank | mngr | amt |  |  | rank - top 10
 | bill | 1500 |  | 1
 | tom | 1400 |  | 2
 | fred | 1100 |  | 3
 | [NAME] | 1700 |  | 4
 | ray | 2100 |  | 5
 | [NAME] | 2200 |  | 6
 | susan | 1300 |  | 7
 | michelle | 1600 |  | 8
 | [NAME] | 1800 |  | 9
 | [NAME] | 1200 |  | 10
 | [NAME] | 900
 | arlette | 1870
 | cathy | 1450
 | joan | 2000
 | [NAME] | 1880
 | neil | 1880
Spreadsheet: 842438d1694519466-data-splitting-column-divider-automatization-sampeworksheet
Sheet: Munka1

Names | Team | Leader
Anna; [NAME] | [NAME] | Anna
[NAME]; [NAME] | [NAME] | [NAME]
[NAME]; [NAME]; [NAME] | [NAME], [NAME] | [NAME]
Rose; [NAME]; [NAME] | Rose, George | [NAME]
[NAME]; [NAME], [NAME] | Rose, George | [NAME]
Ashely; [NAME] | Ashely, [NAME]
[NAME] |  | [NAME]
Mariah, Sara | Mariah, Sara
New data | New team | New leader
Spreadsheet: 132048d1323451291-countifs-not-counting-returns-value-example-maintenance-log
Sheet: October

 |  | October | Hours: |  | Complete: | 4 | Incomplete: |  |  | Total: | 4
[NAME] Tracking |  |  |  |  |  |  |  |  |  |  | Status No | Status Yes | On Hold | Remarks | Personnel
Req Date | Bldg | Deficiencies | ISR | Parts Ordered | Parts Received | Comp. Date | Start | End | Hrs. | E/R/S |  |  |  |  | Frodo | [NAME] | Pippen | [NAME] | Bilbo
 |  |  |  |  |  | 2011-10-03 00:00:00 |  |  |  |  |  | x |  |  |  |  |  | 10 |  |  |  |  | 2011-10-01 00:00:00
 |  |  |  |  |  | 2011-10-04 00:00:00 |  |  |  |  |  | x |  |  |  | 2.5 | 0.5 | 12 |  |  |  | Frodo | 1
 |  |  |  |  |  | 2011-10-04 00:00:00 |  |  |  |  |  | x |  |  | 1 | 1 |  |  |  |  |  | [NAME] | 3
 |  |  |  |  |  | 2011-10-04 00:00:00 |  |  |  |  |  | x |  |  |  | 1 |  |  | 3 |  |  | Pippen | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bilbo | 1
Spreadsheet: 704096d1605357518-sumproduct-with-substraction-and-ifs-testt
Sheet: Portfolio

 | Currency | Token | Current price |  | Quantity |  | Ratio |  | Buying price | Paid | Ratio |  |  | Market value | ROI |  | Profit/Loss | Margin |  | Hold
 | Bitcoin | BTC | 50000 |  |  |  |  | 0.2 | 3000 |  |  | 0.2 |  |  |  |  |  |  |  | Few/Several years
 | Ripple | XRP | 4 |  |  |  |  | 0.3 | 0.08 |  |  | 0.3 |  |  |  |  |  |  |  | Long time. How long?
 | Ethereum | ETH | 2600 |  |  |  |  | 0.2 | 185 |  |  | 0.2 |  |  |  |  |  |  |  | Long time. How long?
 | Chainlink | LINK | 30 |  |  |  |  | 0.1 | 3 |  |  | 0.1 |  |  |  |  |  |  |  | ? |  |  | Based on Ethereum. Bridge between IoT devices and [NAME]. [NAME].
 | Cardano | ADA | 1.5 |  |  |  |  | 0.04 | 0.04 |  |  | 0.04 |  |  |  |  |  |  |  | ? |  |  | Co-fouder [NAME]. Evolved from scientific and research driven. Own blockchain. De nieuwe Etherium?
 | VeChain | VET | 0.03 |  |  |  |  | 0.04 | 0.007 |  |  | 0.04 |  |  |  |  |  |  |  | ? |  |  | Business focust. Bridge between real world and blockchain. Economy, Government model. IoT integration. Tracking products.
 | Reserve Rights | RSR | 0.035 |  |  |  |  | 0.03 | 0.002 |  |  | 0.03 |  |  |  |  |  |  |  | ? |  |  | Stablecoin. Cryptocurrency takover over fiat money. Immortality compared to alternatives.
 | Stellar | XLM | 0.6 |  |  |  |  | 0.03 | 0.007 |  |  | 0.03 |  |  |  |  |  |  |  | ? |  |  | Co-founder [NAME]. IBM partnership. Kind of a digital bank.
 | SingularityNET | AGI | 2 |  |  |  |  | 0.03 | 0.01 |  |  | 0.03 |  |  |  |  |  |  |  | Very long. How long?
 | Algorand | ALGO | 2.25 |  |  |  |  | 0.03 | 0.09 |  |  | 0.03 |  |  |  |  |  |  |  | Very long. How long?
 |  |  |  |  |  |  |  | *** |  |  |  | ***
 |  |  |  |  |  |  |  | 100% total |  |  |  | 100% total |  | Equity | ROI |  | Net Profit | Margin |  | Withdrawn |  | Margin
 | Profit chart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ROI chart
 | manipulatie? | DASH (Dash) |  | 71.08 |  | 1 |  |  | 90 |  |  |  |  | [NAME]. With Masternodes. Service provider over there network. Control? Zeggen in 2020 geen privacy coin te zijn
 | Zelfde als bitcoin gold | [NAME] ([NAME]) |  | 225.62 |  | 1 |  |  | -0.5945 |  |  |  |  | P2P money transfer without banks. Privacy.
 |  | ZEC (Zcash) |  | 56.84 |  | 1 |  |  | -0.9868 |  |  |  |  | Open-source. Privacy or Transparancy. Ledger.
 |  | ETC (Ethereum Classic) |  | 5.06 |  | 1 |  |  | 5.7353 |  |  |  |  | Open-source/Free blockchain platform for everyody to create applications. No owner.
 |  | LTC (Litecoin) |  | 47.07 |  | 1 |  |  | 995.57% |  |  |  |  | Ex-google employe. Bitcoin protocol based. Open-source. Silver version of [NAME]. (slower)
 |  | ZRX (0x) |  | 0.2588 |  | 100 |  |  | 260.47% |  |  |  |  | Free. Uses ethereum. P2P trading of everything. Liquidity
 | [NAME]? | XMR ([NAME]) |  | 93.8 |  | 1 |  |  | 3695.70% |  |  |  |  | Privacy/untracable currency. Open-source.
Spreadsheet: 922bdf0e-be15-4c27-b615-a8afe86ac840
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | Apolipoprotein A-I (APOA1) Gene, Known Mutation | APOA1 Gene, Known Mutation | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:	 1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Wednesday 10 am | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | Ambient
[NAME] | Result | 33393 | [NAME] | [NAME] | Alphanumeric
[NAME] | Result | 33394 | [NAME] | [NAME] | Alphanumeric
[NAME] | Result | 33395 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
[NAME] | Result | 33396 | Order Date | Order Date | Alphanumeric
[NAME] | Result | 33397 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
[NAME] | Result | 33398 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
[NAME] | Result | 33399 | Result | Result | Alphanumeric
[NAME] | Result | 33400 | Interpretation | Interpretation | Alphanumeric
[NAME] | Result | 33401 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 33402 | Reviewed By | Reviewed By | Alphanumeric
[NAME] | Result | 33403 | Release Date | Release Date | Alphanumeric
Spreadsheet: 119620d1314624379-call-in-multiple-entries-from-master-sheet-copy-of-example
Sheet: Output

 |  |  |  |  | B
 | UNITS | PACKAGING |  | PKG TYPE | BRAND | LOT | A | B | C | D | E | F | G
 | 30 |  | 30 |  |  | 1
 | 40 |  | 40 |  |  | 2
 | CUSTOMER | CON # |  |  |  |  |  |  |  | PLAIN BB |  | PLAIN PB |  | TRTD BB |  | TRTD PB |  | BOL
 |  |  |  |  |  |  |  |  | Total
ERROR
CHECKS |  |  |  |  |  |  |  | Balance | 70 | #N/A |  | #N/A |  | #N/A |  | #N/A
Spreadsheet: 736517d1623693373-sum-of-units-over-a-time-period-starting-with-initial-units-and-a-known-growth-rate-sum-of-units-over-years-1-
Sheet: Sheet1

First year units |  |  | Year | # at end of year n
1000 |  |  | 1
Number of years |  |  | 2
5 |  |  | 3
Growth rate per year |  |  | 4
0.15 |  |  | 5
Total number of units over five years
?
Spreadsheet: 168098d1342213735-excel-2007-cumulative-projectied-cash-flow-income-flow
Sheet: Summary

Column1 | Year 1 | Year 2 | Year 3 | SPACE | Year 4 | Year 5 | Year 6 | Year 7
Revenue |  |  |  |  | 432102 | 519204 | 606306 | 693408
Expenses |  |  |  |  | 693406.63 | 693406.63 | 693406.63 | 693406.63
Gross Profit
Total First 3 Years Revenue
Total First 3 Years Expense |  |  |  | Total Racked up Debt 7 years:
Total Gross Profit First 3 years
Team | If we go up $87 102 in profit per year after our 3rd year and our expenses stay the same
 | it looks like we wont break even for 7 years and start making profit in the 8th.
 | We will have only used up almost 3/4 of our loan by then. Which means technically we could get a smaller loan with less interest.
 | Which means more profit for us  and a sooner pay off of the loan.
 | I called a few gyms they said they have between 500 - 1000 active members so
 | so the expenses are real, but clearly my revenues are unrealistic wishful thinking …
 | All the pages are linked to the summary tab, so feel free to play around with some numbers.
 | if you add/remove rows from the tables, the formulas should stay the same.
 | *cash flow statements and will remain with the original numbers
Spreadsheet: 121228d1315934093-excel-2007-data-sort-with-two-row-grouping-pcb
Sheet: pcb

.HEADER
BOARD_FILE | 3 | Expedition PCB | 2011/09/09.11:21:28 | 1
xa.pcb | THOU
.END_HEADER
.BOARD_OUTLINE | [NAME]
93
0 | 9681.7098425 | 3621.7252756 | 0
0 | 9638 | 3650 | -114.2046164
0 | 9638 | 3775 | 0
0 | -300 | 3775 | 0
0 | -300 | -275 | 0
0 | 9638 | -275 | 0
0 | 9638 | -25 | 0
0 | 9700 | -25 | -180
0 | 9700 | -275 | 0
0 | 13200 | -275 | 0
0 | 13200 | 1645 | 0
0 | 12825 | 1645 | 0
0 | 12825 | 1707 | -180
0 | 13200 | 1707 | 0
0 | 13200 | 3627 | 0
0 | 12825 | 3627 | 0
0 | 12825 | 3689 | -180
0 | 13200 | 3689 | 0
0 | 13200 | 5609 | 0
0 | 9700 | 5609 | 0
0 | 9700 | 3689 | 0
0 | 9950 | 3689 | 0
0 | 9950 | 3627 | -180
0 | 9706.3095276 | 3627 | 0
0 | 9681.7098425 | 3621.7252756 | 24.2044886
1 | 12450 | 1644.9990157 | 0
1 | 11615 | 1644.9990157 | 0
1 | 11615 | 1707.0009843 | -180
1 | 12450 | 1707.0009843 | 0
1 | 12450 | 1644.9990157 | -180
2 | 11240 | 1644.9990157 | 0
2 | 10325 | 1644.9990157 | 0
2 | 10325 | 1707.0009843 | -180
2 | 11240 | 1707.0009843 | 0
2 | 11240 | 1644.9990157 | -180
3 | 9950 | 1644.9990157 | 0
3 | 9700.0009843 | 1644.9990157 | 0
3 | 9700.0009843 | 1475 | 0
3 | 9637.9990157 | 1475 | -180
3 | 9637.9990157 | 2275 | 0
3 | 9700.0009843 | 2275 | -180
3 | 9700.0009843 | 1707.0009843 | 0
3 | 9950 | 1707.0009843 | 0
3 | 9950 | 1644.9990157 | -180
4 | 12450 | 3626.9990157 | 0
4 | 11615 | 3626.9990157 | 0
4 | 11615 | 3689.0009843 | -180
4 | 12450 | 3689.0009843 | 0
4 | 12450 | 3626.9990157 | -180
5 | 11240 | 3626.9990157 | 0
5 | 10325 | 3626.9990157 | 0
5 | 10325 | 3689.0009843 | -180
5 | 11240 | 3689.0009843 | 0
5 | 11240 | 3626.9990157 | -180
6 | 9700.0009843 | 350 | 0
6 | 9637.9990157 | 350 | -180
6 | 9637.9990157 | 1100 | 0
6 | 9700.0009843 | 1100 | -180
6 | 9700.0009843 | 350 | 0
7 | 9700.0009843 | 2650 | 0
7 | 9637.9990157 | 2650 | -180
7 | 9637.9990157 | 3400 | 0
7 | 9700.0009843 | 3400 | -180
7 | 9700.0009843 | 2650 | 0
.END_BOARD_OUTLINE
.PLACEMENT
[NAME] | PART1 | R959
8945 | 805 | 0 | 0 | TOP | PLACED
RESC1809X55N_0603 | PART2 | R689
7885 | 2690 | 0 | 90 | TOP | PLACED
CAPC1005X56N_0402 | PART3 | C175
10760 | 2300 | 0 | 90 | TOP | PLACED
TP_025RD | PART4 | [NAME]
220.1298425 | 3709.9395669 | 0 | 90 | TOP | PLACED
CAPC1005X56N_0402 | PART5 | C396
2502.9875197 | 1433.7992126 | 0 | -180 | BOTTOM | PLACED
.END_PLACEMENT
Spreadsheet: 122260d1316700319-excel-2007-vlookup-question-examplespreadsheet
Sheet: ShortageAdj

Name | AcctNbr | ShortageAdj
Customer 1 | 123456 | 11.13
Customer 2 | 234567 | 25.89
Customer 2 | 234568 | 147.37
Customer 2 | 234569 | 153.16
Customer 3 | 987654 | 75.85
Customer 3 | 987653 | 118.03
Customer 3 | 987652 | 28.2
Customer 7 | 333333 | 102.95
Customer 16 | 111333 | 468.27
Customer 17 | 111444 | 0