tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877568d1724365848-merging-two-pivot-tables-book1-1-
Sheet: Sheet2

Industry | Name | Code | Total Loss | Total Premium | Total Amount
1 | FIRM1,1 | 1.1 | 6860.31962152714 | 145502.8734118643 | 54
1 | FIRM1,2 | 1.2 | 4379.53453625926 | 149405.349506942 | 42
1 | FIRM1,3 | 1.3 | 6425.791733565087 | 151546.7978484832 | 40
1 | FIRM1,4 | 1.4 | 4224.708606783076 | 100335.9561592719 | 38
1 | FIRM1,5 | 1.5 | 7750.600986655521 | 100999.436741841 | 48
2 | FIRM2,1 | 2.1 | 7687.233166047501 | 87589.76685336203 | 46
2 | FIRM2,2 | 2.2 | 3140.437670274143 | 123027.5494910058 | 40
2 | FIRM2,3 | 2.3 | 1936.168650138909 | 63959.65708642283 | 30
2 | [NAME] | 2.4 | 5064.015605324962 | 110078.0444362572 | 44
2 | FIRM2,5 | 2.5 | 7926.602084787402 | 108251.7209854458 | 42
3 | FIRM3,1 | 3.1 | 4976.060506180095 | 140499.5018240956 | 44
3 | FIRM3,2 | 3.2 | 8365.443439355968 | 81052.23801513555 | 38
3 | FIRM3,3 | 3.3 | 3285.306166089747 | 140193.2387656335 | 40
3 | FIRM3,4 | 3.4 | 9674.204311577712 | 150962.7642123388 | 46
3 | FIRM3,5 | 3.5 | 6350.608503212737 | 130313.5547532966 | 30
Spreadsheet: 728727d1618590263-how-to-calculate-company-dollar-with-a-cap-and-2-different-splits-example-spreadsheet
Sheet: Sheet1

Closed Sales Address | Area | Closed Agents Name | Closed Date | Sale Price | Concessions | Sale Price - Concesessions | Commission % | Referral Fee % | GCI | GCI - Referral Fee $ | GCI - Fran. Fee | Franchise Fee $ | Brokerage Fee | Company  Dollar | Count | Listing Count |  | Date Processed
January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January |  | SUM of "O"
7022 Marigold Court | Grand Blanc |  | 2021-01-05 00:00:00 | 249900 |  |  | 0.03 |  |  |  |  |  | 0 |  | 1 |  |  | 2021-01-13 00:00:00
Total
Closed Sales Address | Area | Closed Agents Name | Closed Date | Sale Price | Concessions | Sale Price - Concesessions | Commission % | Referral Fee % | GCI | GCI - Referral Fee $ | GCI - Fran. Fee | Franchise Fee $ | Brokerage Fee | Company  Dollar | Count | Listing Count |  | Date Processed
February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
Total
Closed Sales Address | Area | Closed Agents Name | Closed Date | Sale Price | Concessions | Sale Price - Concesessions | Commission % | Referral Fee % | GCI | GCI - Referral Fee $ | GCI - Fran. Fee | Franchise Fee $ | Brokerage Fee | Company  Dollar | Count | Listing Count |  | Date Processed
March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
16843 Kings [NAME] | Grand Blanc |  | 2021-03-26 00:00:00 | 588000 |  |  | 0.03 |  |  |  |  |  | 295 |  | 1 |  |  | 2021-03-29 00:00:00
0 VL Warwick Groves Court | Grand Blanc |  | 2021-03-27 00:00:00 | 240000 |  |  | 0.04 |  |  |  |  |  | 295 |  | 1 |  |  | 2021-03-29 00:00:00
35000 Mitchell Street | [NAME] |  | 2021-03-22 00:00:00 | 1600 |  |  |  |  | 1100 |  |  |  | 0 |  | 1 | 1 |  | 2021-03-29 00:00:00
35000 Mitchell Street | [NAME] |  | 2021-03-22 00:00:00 | 1600 |  |  |  |  | 500 |  |  |  | 0 |  | 1 |  |  | 2021-03-29 00:00:00
5322 E Atherton Road | [NAME] |  | 2021-03-31 00:00:00 | 155000 |  |  | 0.03 |  |  |  |  |  | 0 |  | 1 |  |  | 2021-04-07 00:00:00
Total
 |  |  |  | Year              Total | Total Concessions | Total Sale Price after Concessions | AVG Commission % |  | Total GCI | Total GCI - Referral Fee | Total GCI - Fran. Fee | Total Fran. Fee | Total Brokerage Fee | Total Company Dollar | Year               Count | Listing               Count
 |  |  |  |  |  |  |  |  |  |  |  |  | Annual [NAME]: | 10000
Spreadsheet: benjamin_rogers__1058__newco development cash flow
Sheet: New Unit Financial Profile

 | Financial Profile
 | 500 MW Combined Cycle Facility - Generic
 | Year | 1
 | Net Income
 | Aftertax Cash Flow
 | Equity
 | Beginning Balance
 | Add: Net Income
 | Less:  AT Cash Flow
 | Ending Balance
 | Debt
 | Beginning Balance
 | Less:  Principal
 | Ending Balance
 | Net Income - ROE % | 0.06 | 0.11 | 0.13 | 0.14 | 0.15 | 0.17 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
 | Cash Flow % | 0.04 | 0.14 | 0.14 | 0.14 | 0.14 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3
 | Debt Amort % | 0.02 | 0.06 | 0.06 | 0.06 | 0.06 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 | 0.08 | 0.09 | 0.1 | 0.05
 | Return Summary
 | NPV @ 14%
 | IRR
 | Implied Financials
 | Net Income
 | Add:  Taxes
 | Add: Interest Expense
 | Add:  Bk Depreciation
 | Implied EBITDA
 | Net Income per MW
 | EBITDA per MW
 | Net Income per MW Metrics
 | MSDW | 30
 | ABN-AMRO | 25
 | DLJ | 20
 | Assume Year 1 is half-year
Spreadsheet: 109849d1306657549-index-matching-multiple-reference-points-copy-pricerreturn
Sheet: Sheet1

Date | LAST_PRICE | Buy | Sell | Price Return results | Price Return results | Price Return results
2003-02-04 00:00:00 | 76.627 | B
2003-02-05 00:00:00 | 76.164
2003-02-06 00:00:00 | 75.701 | B
2003-02-07 00:00:00 | 75.932
2003-02-10 00:00:00 | 76.627
2003-02-11 00:00:00 | 76.164 |  | S
2003-02-12 00:00:00 | 76.627
2003-02-13 00:00:00 | 76.395 |  | S
2003-02-14 00:00:00 | 76.395
2003-02-15 00:00:00 | 76.3717 | B
2003-02-16 00:00:00 | 76.3484 |  | S
2003-02-17 00:00:00 | 77.3484
2003-02-18 00:00:00 | 78.3484
2003-02-19 00:00:00 | 79.3484
2003-02-20 00:00:00 | 80.3484
Spreadsheet: 30733d1226420665-use-if-to-avoid-getting-anything-written-after-loan-pmt
Sheet: Kalkyl 11

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 2 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20
 | 3 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30
 | 4 | 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40
 | 5 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50
 | 6 | 6 | 12 | 18 | 24 | 30 | 36 | 42 | 48 | 54 | 60
 | 7 | 7 | 14 | 21 | 28 | 35 | 42 | 49 | 56 | 63 | 70
 | 8 | 8 | 16 | 24 | 32 | 40 | 48 | 56 | 64 | 72 | 80
 | 9 | 9 | 18 | 27 | 36 | 45 | 54 | 63 | 72 | 81 | 90
 | 10 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  |  |  |  |  | 5 | X | 4
 |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  | 20
Spreadsheet: 812304d1673048313-sum-total-of-looked-up-values-in-column-s666-pq-sum-total-of-looked-up-values-in-column
Sheet: Sheet1

 |  |  |  |  | June 22. 2023
name | value | criteria
Arugula | 4 | Arugula |  |  | Result
Basil | 3 |  |  |  | 14
Beans | 5
Beetroot | 5 | Beetroot
Bok choy | 4
Bok choy -baby | 4
Broccoli | 6
Broccoli -asian | 5
Cabbage | 7.5
Cabbage - chinese | 7
Carrot | 5 | Carrot
Cauliflower | 6
Celeriac | 4
Celery | 5
Chives | 2
Cilantro | 3
Corn | 3
[NAME] | 5
Dill | 3
Fennel | 4
Fennel - leaf | 3
[NAME] | 4
[NAME] scapes | 2
[NAME] | 4
Kale - baby | 4
[NAME] | 3.5
[NAME] | 3
Lettuce - heads | 4
Lettuce - leaf | 4
Microgreens | 3.5
Onion - green | 3
Onions - shallots | 4
Onions - yellow | 3
Parsley | 3
Parsnips | 5
Peas | 5
Pepper | 7
[NAME] | 5
Potato | 5
Preserve misc | 4
Raddichio | 3.5
Radish | 3
Radish - daikon | 5
Ruhbarb | 2
Ruhtabaga | 3.5
[NAME] | 3
Spinach | 4
Squash | 6
Sunchokes | 7
Swiss chard | 4
Tatsoi | 4
Tomato | 5
Turnip - hakurei | 5
Turnip - regular | 5
[NAME] | 2
Spreadsheet: eaa7b573-56c9-475d-ba8d-9c33b957a68d
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
MGRP | Test | MGRP | Mycoplasma genitalium, Molecular Detection, PCR | Mycoplasma genitalium PCR | Real-Time Polymerase Chain Reaction (PCR) Using LightCycler and Fluorescent Resonance Energy Transfer (FRET) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  |  |  | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:   Specimen Type: Swab Sources: Cervix, urethra, urogenital, vaginal  Container/Tube:	 Preferred: Dacron or rayon swab with aluminum or plastic shaft (does not need to be in transport media) Acceptable: Swab in transport media: M5 (Supply T484), [NAME], or universal transport media [NAME]: Entire specimen Collection Instructions: Vaginal: Collect specimen by swabbing back and forth over mucosa surface to maximize recovery of cells. [NAME] or Cervical: Collect specimen by inserting swab 1 to 3 cm and rotating 360 degrees.   [NAME]: Fluid Sources: Amniotic, pelvic, prostatic secretion, reproductive drainage, semen Container/Tube:	 Preferred: Sterile container Acceptable: Container with 3 mL of transport media: M5 (Supply T484), [NAME], or universal transport media [NAME]: 1-2 mL   Specimen Type: [NAME] (kidney stones) Container/Tube: Sterile container [NAME]: 10 mL   Specimen Type: Tissue Sources: Placenta, products of conception, genitourinary Container/Tube: Sterile container [NAME]: 5 mm Collection Instructions: Submit only fresh tissue. | [NAME], [NAME], Pr | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Wooden shaft, cotton swab | Not applicable | Monday through Friday | 3 days | 4 days | 1 | 87798 |  |  |  |  | Rochester
MGRP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
MGRP | Order Question | [NAME] | [NAME] |  | Plain Text
MGRP | Result | [NAME] | Specimen source | Specimen source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
MGRP | Result | 32532 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 73ed4e95-66f4-4d52-b743-35b6dd4cc7aa
Sheet: Sheet1

HASIL PENILAIAN PLPG TAHAP 5-8 TAHUN 2011
NO | NOMOR PESERTA | NAMA PESERTA | ASAL SEKOLAH | KAB/KOTA | STATUS
1 | 11031722010537 | [NAME] | SMP MUHAMMADIYAH 2 LASEM | Kab. Rembang | TIDAK HADIR
2 | 11031721710540 | [NAME] | SMP NU PANCUR | Kab. Rembang | LULUS
3 | 11031722010192 | KARTINI | SD N BONANG | Kab. Rembang | MENGULANG UJIAN TULIS
4 | 11031722010649 | SUWITO | SMA N 2 REMBANG | Kab. Rembang | LULUS
5 | 11031722010216 | JAMIN | SD N SEDAN 1 | Kab. Rembang | MENGULANG UJIAN TULIS
6 | 11031722010658 | DODI DWI MARDIYANTO | SMA N 1 LASEM | Kab. Rembang | LULUS
7 | 11031722010621 | HERU CAHYONO | SMA N 1 REMBANG | Kab. Rembang | LULUS
8 | 11031722010267 | KUNCONO | SD N MANTINGAN | Kab. Rembang | LULUS
9 | 11031722010587 | IRWAN SETIYAWAN | SMP N 2 BULU | Kab. Rembang | LULUS
10 | 11031722010581 | [NAME] | SMP N 2 SUMBER | Kab. Rembang | LULUS
11 | 11031722010120 | EKO SYA''''RONI | SD N PUNJULHARJO | Kab. Rembang | MENGULANG UJIAN TULIS
12 | 11031722010511 | MARTONO | SMPN 1 PAMOTAN | Kab. Rembang | LULUS
13 | 11031722010578 | SUDARJO | SMP N 1 LASEM | Kab. Rembang | LULUS
14 | 11031722010614 | MAHSUDI | SMP N KATHOLIK ADI SUCIPTO | Kab. Rembang | LULUS
15 | 11031722010273 | MUNARKO | SD N SLUKE 1 | Kab. Rembang | MENGULANG UJIAN TULIS
16 | 11031722010274 | MUJIYONO | SD N SENDANGMULYO 1 | Kab. Rembang | MENGULANG UJIAN TULIS
17 | 11031722010663 | SAKRONI | SMK (STM) PP ZAKASYI AL MUBAROK | Kab. Rembang | LULUS
18 | 11031722010082 | MUAFIFAH | SD N TREMBES 1 | Kab. Rembang | LULUS
19 | 11031722010301 | LASWIJI | SD N GUNEM 1 | Kab. Rembang | MENGULANG UJIAN TULIS
20 | 11031722010469 | MASHADI | SD N LODAN KULON 2 | Kab. Rembang | MENGULANG UJIAN TULIS
21 | 11031722010669 | HERU WIDYATMOKO | SMK (STM) N 2 REMBANG | Kab. Rembang | LULUS
22 | 11031721710530 | HJ. SITI SETYO RINI | SMP 2 SULANG | Kab. Rembang | LULUS
23 | 11031721710609 | BIYANTI RUSTININGSIH | SMP N BULU | Kab. Rembang | LULUS
Spreadsheet: jeff_dasovich__14251__EBSBalSht123199
Sheet: Sheet1

ENRON BROADBAND SERVICES, INC.
Balance Sheet as of December 31, 1999
 |  | ASSETS
 |  |  | 1999-12-31 00:00:00
 | Current Assets
 | Cash |  |  | -28223398
 | Accounts Receivable
 | Accounts Receivable - Affiliates
 | Prepaid Expenses |  |  | 8795450
 | Total Current Assets
 | Property, Plant & Equipment
 | Property, Plant and Equipment |  | 7492844
 | Construction Work in Progress
 | Total plant in service
 | Less: Accumulated Depreciation |  | -1348855
 | Net plant in service
 | Other Assets
 | Investments |  |  | 80550116
 | Goodwill (net of amortization) |  |  | 23084823
 | Deposits and deferred charges |  |  | 1124713
 | Total Other Assets
 | Total Assets
 | LIABILITIES AND STOCKHOLDERS EQUITY
 | Current Liabilities
 | Accounts Payable - trade
 | Accounts Payable - Affiliate
 | Accrued liabilities
 | Customer deposits and unearned income |  |  | 12826457
 | Total Current Liabilities
 | Deferred taxes - federal and state |  |  | 161880381
 | Stockholders Equity
 | Common Stock |  |  | 14280366
 |  |  |  | 225000
 | [NAME]
 | Current Year Earnings |  |  | 232593486
 | Total Stockholders Equity
 | Total Liabilities and Stockholders Equity
ENRON COMMUNICATIONS GROUP
Balance Sheets as of March 31, 1998,  and December 31,1997
 | ASSETS
 |  | 1998-03-31 00:00:00
Investment in Rythms |  |  | 10000000
Total Assets
LIABILITIES AND STOCKHOLDERS EQUITY
Current Liabilities
Accounts Payable - affiliate |  |  | 10000000
Total Current Liabilities
Total Liabilities and Stockholders Equity
Spreadsheet: 188432d1350890533-search-products-short-name-and-destinations-from-list-and-have-the-pirce-showing-out-sample-data
Sheet: Sheet1

Full Product Name | Discount? | Shortcode | Price | Destinations
IPOD touch | Yes | IPOD | 15 | MTY
IPHONE 32GB | No |  |  | MEX
IPAD 16GB | Yes | IPAD | 14 | MEX
IPHONE 16GB | No |  |  | ATL
Shortcode | Destinations | Price
IPOD | MTY | 15
IPAD | MEX | 14
Spreadsheet: 673346d1587321081-discerning-patterns-in-a-survey-probl-me-fruits
Sheet: Feuil1

 | [NAME] | Kiwi | Apple | Pear | Grapes
Child 1 | 1 | 0 | 1 | 0 | 1
Child 2 | 0 | 1 | 0 | 1 | 0
Child 3 | 0 | 0 | 1 | 0 | 0
Child 4 | 0 | 1 | 0 | 1 | 0
Child 5 | 1 | 0 | 1 | 0 | 1
Child 6 | 0 | 1 | 0 | 1 | 0
Child 7 | 0 | 0 | 1 | 0 | 0
Child 8 | 0 | 1 | 0 | 1 | 0
Child 9 | 1 | 0 | 1 | 0 | 1
Child 10 | 0 | 1 | 0 | 1 | 0
Spreadsheet: 107638d1304768578-predictive-stock-predictive-20stock-1-
Sheet: Sheet2

 |  | 1 | 2 | 3 | 4 | 5 | 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
 | Actual | 10 | 20 | 2 | 4 | 4 | 10 | 2 | 3 | 34
Opening | 100
 | Trend
Spreadsheet: 871284d1717672086-0-and-empty-value-issue-planned-sp-calculation_review-aligw
Sheet: Sheet1

Campaign Details |  |  |  |  | [NAME] Details |  |  |  | Campaign Setup Details |  | Data Setup Details | New Request Planned SP |  |  | CR Planned SP |  |  | Total SP
User Story ID | Campaign ID | Items | State | Iteration Path / Sprint | Touchpoints | Segments/Varient | No. of dynamic Emails | No. of Non-dynamic emails | No. Workflow | No. Deliveries | No. PayloadID | Content SP | Campaign SP | Data SP | Content SP | Campaign SP | Data SP | New Total Planned SP | CR Total Planned SP
47311 | XXX12 | Sample Name_v1 | Submitted | FY24\May 24 - S2 | 2 | 1 | 2 | 8
47480 | XXX13 | Sample Name_v2 | Submitted | FY24\May 24 - S3 | 1 |  | 3 |  | 14.5
40654 | XXX14 | Sample Name_v3 | Planning | FY24\May 24 - S3 | 1 | 0 | 3 | 2 | 17
39797 | XXX87 | Sample Name_v4 | In Progress | FY24\June 24 - S1 | 2 | 0 | 3 | 3 | 39
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  | Re: 0 & Empty value issue
 |  |  |  | My [NAME] will be:
 |  |  |  | =(Touchpoints x Segments/Variant x No. of dynamic Emails x 4) + (Touchpoints x Segments/Variant x No. of non-dynamic Emails x 2.5)
 |  |  |  | Numeric value 4 and 2.5 will be static for calculation of effort for Dynamic and Non-dynamic email setup respectively
 |  |  |  | So if my value are
 |  |  |  | Touchpoint = 2
 |  |  |  | Segments/Variant = 1
 |  |  |  | No. of dynamic Emails = 2
 |  |  |  | No. of non-dynamic Emails = 8
 |  |  |  | =(Touchpoints x Segments/Variant x No. of dynamic Emails x 4) + (Touchpoints x Segments/Variant x No. of non-dynamic Emails x 2.5)
 |  |  |  | Formula(2 x 1 x 2 x 4) + (2 x 1 x 8 x 2.5)= (16 + 40) = 56
 |  |  |  | OR
 |  |  |  | Touchpoint = 2
 |  |  |  | Segments/Variant = 0/NA
 |  |  |  | No. of dynamic Emails = 1
 |  |  |  | No. of non-dynamic Emails = 0/NA
 |  |  |  | =(Touchpoints x Segments/Variant x No. of dynamic Emails x 4) + (Touchpoints x Segments/Variant x No. of non-dynamic Emails x 2.5)
 |  |  |  | Formula(2 x 0 x 1 x 4) + (2 x 0 x 0 x 2.5)= (8 + 0) = 8
 |  |  |  | If the value of non-dynamic emails is 0 then the 2nd calculation should return the result as 0
 |  |  |  | Let me know if it is possible to do it
Spreadsheet: 161171d1339435448-calculating-expansion-sales-gyro-check_2
Sheet: Franchise Model

FRANCHISED INCOME STATEMENT
ASSUMPTIONS BELOW |  |  |  |  |  |  | FY1 |  |  |  |  |  |  | Based on 100% Growth
 | January | February | March | April | May | June | July | August | September | October | November | December | FYE 1 | FYE 2 | FYE 3
Number of Stores | 1 | 1 | 2 |  |  |  |  |  |  |  |  |  | 41 | 82 | 164
Revenue
Franchise Fee
Management Services Fee
Marketing Services Fee
Renewal Fee?
Special Services Fee (bookkeeping, taxes, etc.)
Total Revenue
Store Sales
Sales
Sales - Food
Sales  - Other
Total Sales
Cost of Goods Sold
Total Cost of Goods Sold
Gross Profit
Operating Expenses
Labor
Rent Expense | 13595.13 | 10266.35 | 10571.67 | 10489.01 | 6984.27 | 9314.46 | 10488.99 | 10854.92 | 12061.5 | 13707.17 | 14549.76 | 15631.73
Advertising | 5011.25 | 312.7 | 63.14 | 1065.53 | 2632.77 | 314.69 | 1425.28 | 779.35 | 1470.78 | 1675.57 | 701.9499999999999 | 555.38
Credit Card Processing Fees | 8680.64 | 2229.21 | 2468.54 | 3246.91 | 3061.7 | 2906.17 | 3142.81 | 2999.26 | 3503.49 | 3609.45 | 3514.27 | 2880.24
Insurance | 7308.08 | 3977.89 | 0 | 0 | 3283.13 | 0 | 4064 | 0 | 1081 | 0 | 0 | 475.58
Legal & Accounting | 3368 | 400 | 400 | 400 | 400 | 2470 | 400 | 1248.9 | 1170 | 1430 | 800 | 800
Licensing Fees & Permits
Misc. Expense
Repairs & Maintenance | 46888.09 | 1601.11 | 240.09 | 2089.26 | 1411.78 | 3097.53 | 243.13 | 4970.969999999999 | 2904.93 | 4103.76 | 5270.41 | 2695.03
Supplies
Utilities & Telephone
Total Operating Expenses
Operating Income (Loss)
Operating Margin (EBITDA)
Other Income (Expense)
Other Income | 0 | 3981.38 | 3638.28 | 4075 | 4279 | 4425.5 | 4817.37 | 5145.610000000001 | 5484.92 | 6204.5 | 6083.909999999999 | 5862.22
Depreciation | -74645.52 | -5272.46 | -5272.46 | -5272.46 | -5272.46 | -5272.46 | -16791.01 | -16791.01 | -63929.57 | -64330.03 | -64330.03 | -64330.03
Amortization | -59.72 | -29.86 | -29.86 | -29.86 | -29.86 | -29.86 | -101.62 | -101.62 | -115.35 | -115.35 | -115.35 | -115.35
Total Other Income (Expense)
Net Income (Loss)
Less Noncash Charges
Net Cash Margin
Average Margin (less Dec.)
Logic | Store One's first month sales (B76) | Store One's second month sales (B77) | Store One's third month sales (B78) Plus Store Two's first month sales (B76) | Store One's fourth month sales, now growing at 6.5% (B75) Plus Store Two's second month sales (B77) Plus Store Three's first month sales (B76)
Cell | B19 | C19 | [NAME] | E19
Check | Cell [NAME] equal
 | Store One's Fourth Month Sales |  |  | (third month times 6.5%)
 | Store Two's second month sales |  |  | B77
 | Store Three's First Month Sales |  |  | B76             Instead equals
Assumptions
Franchise Growth (monthly) | 0.4
Franchise Fee | 35000
Management Services Fee | 0.07
Marketing Services Fee | 0.02
Special Services Fee (bookkeeping, taxes, etc.) | 0.01
Same Store Sales Growth
First Month's Sales
Second Month Sales
Third Month Sales | 43280
Average Annual Sales | 670000
 |  |  | 900-1500 sq ft
 |  |  | $620-720k annually
Spreadsheet: 126783d1319918620-pulling-specific-rows-from-a-data-set-exman999
Sheet: Data

A | notion | translation | 168 | Not wanting to make a big deal of yesterday, I wave the notion away | 1
 | radiant | translation | 169 | She looks radiant again today with her blond hair…. | 1
 | scent | translation | 170 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils. | 1
A | cologne | translation | 171 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils. | 2
A | crotch | translation | 172 | I bring my knee straight up into his crotch | 3
A | shaky | translation | 173 | He is shaky, still having trouble brathing | 4 |  |  |  | MAIN
 | nodge | translation | 174 | To nodge somebody | 4
 | cauldrons | translation | 175 | Inches below them are two cauldrons of fire… | 4
A | massacre | translation | 176 | It was a massacre | 5
 | hatred | translation | 177 | There was too much hatred for them to on;y be interested in our resources | 5
A | carnivores | translation | 178 | Then, the carnivores weren't far behind | 6
 | tenant | translation | 179 | a person who pays rent for the use of land or a building | 6
A | [NAME] | translation | 180 | a person, animal or object which is believed to bring good luck, or which represents an organization | 7
 | manure | translation | 181 | My locker was filled with manure | 7
 | nape | translation | 182 | the back of the neck | 7
 | vow | translation | 183 | She made a vow that she was going to be good | 7
A | notion | translation | 168 | Not wanting to make a big deal of yesterday, I wave the notion away
A | cologne | translation | 171 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils.
A | crotch | translation | 172 | I bring my knee straight up into his crotch |  |  |  |  |  | GOOD
A | shaky | translation | 173 | He is shaky, still having trouble brathing |  |  |  |  |  | Pasted those with A
A | massacre | translation | 176 | It was a massacre
A | carnivores | translation | 178 | Then, the carnivores weren't far behind
A | [NAME] | translation | 180 | a person, animal or object which is believed to bring good luck, or which represents an organization
A | notion | translation | 168 | Not wanting to make a big deal of yesterday, I wave the notion away
A | cologne | translation | 171 | Our chest nearly touch and the spicy scent of his cologne fills my nostrils.
A | crotch | translation | 172 | I bring my knee straight up into his crotch |  |  |  |  |  | Incorrect, BAD
A | shaky | translation | 173 | He is shaky, still having trouble brathing
A | massacre | translation | 176 | It was a massacre
A | carnivores | translation | 178 | Then, the carnivores weren't far behind
A | [NAME] | translation | 180 | a person, animal or object which is believed to bring good luck, or which represents an organization