tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 13458a78-e0ee-4d9f-bc82-6f0528b100a9
Sheet: Sheet1

Oligonucleotides used in this study
Name | Sequence (5' - 3') | Function
yefCFw | CAACTGCACTTTCTCCCTGGCCTA | RT-PCR: TID_200308
yefCRv | ATGGCCTTGGCCTTGGTCTT | RT-PCR: TID_200308
xynAFw | ACTCGCAGCTCCCCTCCTGG | RT-PCR: xynA
[NAME] | GCCCGAGCAGTCTCGAAGGC | RT-PCR: xynA
xynBFw | CACGACTCTGTCGCCCAGCG | RT-PCR: xynB
xynBRv | GGGGGTCAGTGGTCCAGCCA | RT-PCR: xynB
Gh61AFw | TGGCTCGAGCTGCGAGACTG | RT-PCR: GH61A
GH61ARv | CTCACTGCTGGCCCCATGCA | RT-PCR: GH61A
hsbAFw | GGGGCTGCTTCCGCATTCAC | RT-PCR: hsbA
HsbARv | AATGGTTGCCGCATCCGTCGT | RT-PCR: hsbA
coh1Fw | GGTCTTGCCAGTGCTGCACCA | RT-PCR: coh1
coh1Rv | TAGTCTCGCAGCAAGCGGCCT | RT-PCR: coh1
hyp1Fw | AGCAGGCCGAAGACAAGTGCG | RT-PCR: hyp1
hyp1Rv | GGGAGACGACTGGCAGCAAGC | RT-PCR: hyp1
GH5Fw | CAGCGACTTTGCAGCCTTC | RT-PCR: TID_205580
GH5Rv | GCGCCGGTGTAGGAATTGC | RT-PCR: TID_205580
abfBFw | ATCATCCTGGGTATCGGCGG | RT-PCR: abfB
abfBRv | TAACCGGGCGTAGTGACACG | RT-PCR: abfB
cbhBFw | CCAGCGATGGCAGCTGCAC | RT-PCR: cbhB
cbhBRv | CTGCCGGACGTGGTCACACC | RT-PCR: cbhB
cbhAFw | CCAGCAAGCCGGAACGCTCA | RT-PCR: cbhA
cbhARv | AACGCGCCGTTTAGCCCACA | RT-PCR: cbhA
eglAFw | CCTGGAGCGGTGGTGAGGGA | RT-PCR: eglA
eglARv | GCTGGCGGGAAAGCCTTGGT | RT-PCR: eglA
tflIFw | TGACTTGCGCTTCACGGTGC | RT-PCR: TID_173684
tflIRv | TGCCAGTGCCCCAGACTTGA | RT-PCR: TID_173684
cepHFw | TTCAATTATCGTGTTGGAGCCC | RT-PCR: TID_50877
[NAME] | AAGACGACTCGACGATGGCA | RT-PCR: TID_50877
pth11Fw | TACATTTGTCGCTGTCCTAGCATG | RT-PCR: TID_54125
pth11Rv | GACGACTGCATACCGGTTCACA | RT-PCR: TID_54125
[NAME] | CCTCTGGGTCTCTGCGCTTTCG | RT-PCR: TID_53176
[NAME] | GGCGACAGTGGACCTCAAGGT | RT-PCR: TID_53176
[NAME] | TTAAGTTGGGTAACGCCAGGGCCTCTGGGTCTCTGCGCTTTCG | Strand specfic RT-PCR: TID_53176
[NAME] | TTAAGTTGGGTAACGCCAGGGGGCGACAGTGGACCTCAAGGT | Strand specific RT-PCR: TID_53176
Tag primer | TTAAGTTGGGTAACGCCAGGG | Strand Specific RT-PCR: TID_53176
Spreadsheet: 805923d1669015060-copy-from-sheet-to-sheet-based-on-rows-and-columns-excel-help-example-ans
Sheet: October 2022

Sales | Location 1 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Location 8 | Location 9 | Location 10
2022-10-01 00:00:00
October 2022 Sales | 111111 | 333333 | 444444 | 555555 | 666666 | 777777 | 888888 | 1111110
October 2021 Sales
% Change | % | % | % | % | % | % | % | %
October 2020 Sales
% Change from 2022 | % | % | % | % | % | % | % | %
2019-11-01 00:00:00
Spreadsheet: 794320d1661976802-extract-text-from-cell-forum-sample
Sheet: MAR-2022

DEPOSIT AND OTHER ADDITION DETAILS
3/02/22   Direct Deposit    Square Inc 1111111                                            734.11   +
3/03/22   Direct Deposit    Square Inc 1111111                                            891.63   +
3/04/22   Direct Deposit    Square Inc 1111111                                            981.51   +
3/04/22   Regular Deposit                                                                  725.00   +
3/07/22   Direct Deposit    Square   Inc   1111111                                      1,209.88   +
3/07/22   Direct Deposit    Square   Inc   1111111                                      1,128.64   +
3/07/22   Direct Deposit    Square   Inc   1111111                                      1,012.20   +
3/07/22   Direct Deposit    Square   Inc   1111111                                        982.09   +
3/09/22   Direct Deposit    Square   Inc   1111111                                        812.05   +
Spreadsheet: 53038d1252954629-conditional-formating-highlight-cells-based-on-multiple-stipulations-test1
Sheet: Sheet1

Type: | Loan 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Loan 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loan 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loan 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loan 4
Variable 1 | yes |  |  |  |  |  |  |  |  |  |  |  |  |  | Loan 5
Variable 2 | yes
Variable 3 | yes |  |  |  |  |  |  |  |  |  |  |  |  |  | yes
Variable 4 | yes |  |  |  |  |  |  |  |  |  |  |  |  |  | no
Variable 5 | yes
Variable 6 | yes
Spreadsheet: 0bcd2184-6308-42f9-ac49-9a581d157b52
Sheet: Sheet1

Material | $ [NAME] | $ cm3 | Volume | Cost | [NAME] | Sale-Cost
Alumide | 1.5 | 1.99 | 1 |  | 0
Antique Bronze Glossy | 7.5 | 8 | 1 |  | 0
Antique [NAME] | 7.5 | 8 | 1 |  | 0
Frosted Detail | 5 | 2.39 | 1 |  | 0
Frosted Ultra Detail | 5 | 3.49 | 1 |  | 0
Full Color Sandstone | 3 | 0.75 | 1 |  | 0
Gold Plated Glossy | 9 | 8 | 1 |  | 0
Gold Plated Matte | 9 | 8 | 1 |  | 0
Grey Robust | 2 | 2 | 1 |  | 0
High Gloss Black Glass | 9 | 7 | 1 |  | 0
High Gloss White Glass | 9 | 7 | 1 |  | 0
Milky White Matte [NAME] | 9 | 6 | 1 |  | 0
Sandstone | 3 | 0.75 | 1 |  | 0
Silver | 30 | 20 | 1 |  | 0
Silver Glossy | 35 | 20 | 1 |  | 0
Stainless Steel | 6 | 8 | 3 |  | 0
Transparent [NAME] | 2.5 | 2.99 | 1 |  | 0
White Detail | 2.5 | 2.99 | 1 |  | 0
Black Detail | 2.5 | 2.99 | 1 |  | 0
White Strong & Flexible | 1.5 | 1.4 | 1 |  | 0
WSF Polished | 1.5 | 1.75 | 1 |  | 0
Black Strong & Flexible | 1.75 | 1.75 | 1 |  | 0
[NAME] and Flexible | 1.75 | 1.75 | 1 |  | 0
[NAME] and Flexible | 1.75 | 1.75 | 1 |  | 0
Red Strong and Flexible | 1.75 | 1.75 | 1 |  | 0
Spreadsheet: 884411d1733540092-formula-to-report-of-data-points-positive-or-negative-based-on-a-condition-golfshots-jt-
Sheet: Report

5% Test Combine (105 to 200 yards)
Iron | [NAME] | [NAME] | % of Shots -Lft | % of Shots +Rgt | Avg -Sht / +Lng | % of Shots -Short | % of Shots +Long | [NAME] From Pin | [NAME] from Pin | % of Shots  <2.5% | % of Shots <=5%
4i
5i
6i
7i
8i
9i
PW
50*
54*
58*
Spreadsheet: 678625d1589986770-lookup-function-fix-test-book
Sheet: Sheet2

First name | surname | Postcode | Postcode identifier | Region code
[NAME] | Simpson | BH243FD
[NAME] | Bloggs | [NAME]
[NAME] | [NAME] | SP61JM
[NAME] | Thomspon | SP62IK
[NAME] | Wilks | SP63WQ
[NAME] | [NAME] | BH255WE
[NAME] | Bloggs | BH256DF
[NAME] | Test | BH257SM
[NAME] | Simpson | BL00YN
[NAME] | Bloggs | BL09QD
[NAME] | [NAME] | BL11YX
[NAME] | Thomspon | BL12EF
[NAME] | Wilks | BL13AK
[NAME] | [NAME] | NP444YS
[NAME] | Bloggs | NP445SB
[NAME] | Test | NP446WF
[NAME] | Simpson | NP447AI
[NAME] | Bloggs | NP448QR
[NAME] | [NAME] | NR11AX
[NAME] | Thomspon | NR12AO
[NAME] | Wilks | NR13AT
[NAME] | [NAME] | NR14RZ
[NAME] | Bloggs | NR21HA
Spreadsheet: 155802d1337057548-creating-individual-student-reports-book3-1-
Sheet: Pivot

ESIS / School  Number | (All)
Class Ref | (All)
Row Labels | Sum of Number of P | Sum of Number of A | Sum of Number of AA | Sum of Number of U | Sum of Average Grade
ABDULLA | 24 | 2 | 1 | 0 | 49.33333333333334
Grand Total | 24 | 2 | 1 | 0 | 49.33333333333334
Spreadsheet: 36866d1234841307-extract-data-from-column-to-new-spreadsheet-sample
Sheet: Sheet1

 | Item | Description | Due Date | Date | Remark
 | 132005 | INSTRUMENT LIST WITH BILL OF MATERIAL (BUYER'S FORMAT 'S4I') | 2008-12-18 00:00:00 | 2009-02-05 00:00:00 | Submitted
 | 132007 | INSTRUMENT CABLE SCHEDULE | 2008-12-18 00:00:00 | 2009-02-07 00:00:00 | Submitted
 | 132002 | GENERAL ARRANGEMENT DRAWING | 2008-10-23 00:00:00 | 2009-02-10 00:00:00 | Submitted
 | 132007 | INSTRUMENT CABLE SCHEDULE | 2008-12-18 00:00:00 | 2009-02-15 00:00:00 | Revised
 | 132002 | GENERAL ARRANGEMENT DRAWING | 2008-10-23 00:00:00 | 2009-02-19 00:00:00 | Rejected
Spreadsheet: 112992d1308939747-matching-two-columns-and-finding-the-minimum-value-in-a-third-column-dummydata
Sheet: Sheet1

Report Date | Project Code | Project Status
2010-08-19 00:00:00 | C8 | Execute
2010-07-15 00:00:00 | C8 | Execute
2010-06-17 00:00:00 | C8 | Execute
2010-05-20 00:00:00 | C8 | Execute
2010-04-15 00:00:00 | C8 | Execute
2010-03-18 00:00:00 | C8 | Execute
2010-01-21 00:00:00 | C8 | Execute
2010-02-18 00:00:00 | C8 | Execute
Analysis
Project | Status | When Executed?
C8 | Execute | 2010-08-19 00:00:00
Spreadsheet: 143998d1330661068-need-to-eliminate-blank-lines-in-vlookup-results-card
Sheet: Cards Sold

Date Listed | Date Sold | Control # | Card Type | Card Number | Balance | Paid | Sold | Profit $$ | Profit % | Plastic Jungle | [NAME] | other | Date paid
2012-02-15 00:00:00 |  | 2 |  |  |  |  | 88
2012-02-15 00:00:00 |  | 4 |  |  |  |  | 60
2012-02-15 00:00:00 |  | 3 |  |  |  |  | 72
2012-02-14 00:00:00 |  | 1 |  |  |  |  | 35
2012-02-16 00:00:00 |  | 5
Spreadsheet: a26d2511-ba7a-4b67-a7b5-547240011360
Sheet: Sheet1

2013 - 2014 Direct Certification/Verification Tracking Form
Please complete and submit this form to the CDE OSN (to: [EMAIL]) between 10/2/13 and 10/21/13 to help ensure increased Direct Certification matching and accuracy in Verification reporting.
1. Number of students enrolled in the SFA (in schools participating in the NSLP) as of 10/1/2013
2. Number of unduplicated students uploaded for Direct Certification (include all uploads to date)
3. Difference between students enrolled (#1) and students uploaded (#2) (should be 0)
4. If not 0, please explain the difference.
5. Number of unduplicated students on Match Reports (include all match reports to date)
6. Number of students with Direct Cert status entered onto the SFA's meal benefit issuance document
7. Difference between students on Match Reports (#5) and students with Direct Cert status (#6) (should be 0)
8. If not 0, please explain the difference.
9. Number of extended eligible students identified and updated with free benefits
10. Has the October upload been completed? (if no, this form cannot be submitted)
1. Enter the number of students enrolled in the School Food Authority in schools participating in the National School Lunch Program, as of close of business 10/1/2013.
2. Enter the number of unduplicated students who were uploaded in any Direct Cert upload for the 13-14 school year (these uploads must have occurred between 7/1/2013 and 10/21/2013).
3. Perform the following calculation: #1 - #2 (students enrolled - students uploaded). The difference should 0, as all enrolled students must be uploaded for Direct Cert.
4. If #3 is not 0, please explain why.
5. Enter the number of unduplicated students on all Match Reports for the 13-14 school year (these uploads must have occurred between 7/1/2013 and 10/21/2013).
6. Enter the number of students with a free-Direct Cert status on the SFA's meal benefit issuance document.
7. Perform the following calculation: #5 - #6 (students on [NAME] - students with Direct Cert status). The difference should be 0, as meal benefit issuance documents must be updated with a Direct Cert status, unless potential matches were not able to be confirmed, students transferred out of district, etc.
8. If #7 is not 0, please explain the difference.
9. Enter the number of students who were updated with free eligibility based on extended eligibility.
10. Indicate whether the October upload (which must occur between 10/2/2013 - 10/21/2013) has been completed. If not, please complete this upload, update this form, and then submit the form.
Spreadsheet: louise_kitchen__24045__West Power Consolidation
Sheet: Fundamentals

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | % of
 |  | YTD Actual |  | Annualized |  | Total Exp
ENACOMP | Compensation
 | Special Pays | 117500
 | Analysts & Associates | 15600
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 5
 | Analyst & Associate Headcount |  |  | 1
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: 107617d1304726333-lookup-values-dummy-files
Sheet: Data

 |  | 2011-04-01 00:00:00 | 2011-03-01 00:00:00 | 2011-02-01 00:00:00 | 2011-01-01 00:00:00
El Paso - ACS, ELP | Spanish Technical Support | 10.28% | 0.2 | 0.05 | 0.05
El Paso - ACS, ELP | TS - UBP Advanced Tech Support | 9.27% | 0.095 | 0.05 | 0.04
El Paso - ACS, ELP | TS - UBP Technical Support Svcs | 16.74% | 0.1 | 0.05 | 0.03
El Paso - ACS, ELP | iDEN Tech Tier 1 | 13.58% | 0.1 | 0.05 | 0.02
Spreadsheet: 701999d1604039419-summing-values-from-another-excel-tab-based-on-multiple-criteria-book2
Sheet: Summary

ProjectID | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
PROJ1
PROJ2
PROJ3
PROJ4
PROJ5
Spreadsheet: 0264f5fb-97e9-4dda-9c03-3a8b23d8e377
Sheet: TOT Report Page 1

 | ***AMENDED***                                               ***AMENDED***                                              ***AMENDED***
 | County of Placer
 | Transient Occupancy Tax
 | PROPERTY MANAGEMENT SPREADSHEET FOR AMENDING PREVIOUS REPORTING
 | Property Management Information: |  |  |  |  |  |  | Authorization
 | Company Name |  |  |  |  |  |  | By signing this form under the penalty of perjury, I certify that I am authorized to complete this information.  This information reported is accurate based on the Transient Occupancy Tax collected by the Property Management Company named on the certificates listed below.
 | Address
 | City, State, Zip
 | Phone |  |  |  |  |  |  | Signature: |  | Date __________
 | Fax |  |  |  |  |  |  | Print Name:
 | Contact |  |  |  |  |  |  | Title:
 |  |  |  |  |  |  |  |  |  |  |  | Amount
 |  |  |  | **AMENDED** |  |  |  |  |  |  | Page 1
 | Reporting Period: |  |  |  | to |  |  |  |  |  | Page 2
 |  |  |  | [NAME] |  | [NAME] |  |  |  |  | Page 3
 | REASON FOR AMENDMENT: (Please provide supporting documentation.) |  |  |  |  |  |  |  |  |  | Page 4
 |  |  |  |  |  |  |  |  |  |  | Page 5
 |  |  |  |  |  |  |  |  | Total Due
 | If amended processing results in a credit balance, a refund will be processed.
 | Remit check payable to Placer County Revenue Services and send with this report to:
 | Placer County Administrative Services Department - Revenue Services Division, 10810 Justice [NAME]. 100, Roseville, CA 95678
 | CERT # | ACCOUNT# | REPORTINGS | GROSS RENTAL INCOME | EXEMPT AMOUNT | TAXABLE RECEIPTS | TAX RATE (%) | AMOUNT OF TAX DUE | PENALTY | INTEREST | TOTAL AMOUNT DUE | DAYS AVAILABLE | DAYS OCCUPIED
1 |  |  | AMENDED |  |  |  | 0.1
2 |  |  | PREVIOUS |  |  |  | 0.1
3 |  |  | DIFFERENCE |  |  |  | 0.1
4 |  |  | AMENDED |  |  |  | 0.1
5 |  |  | PREVIOUS |  |  |  | 0.1
6 |  |  | DIFFERENCE |  |  |  | 0.1
7 |  |  | AMENDED |  |  |  | 0.1
8 |  |  | PREVIOUS |  |  |  | 0.1
9 |  |  | DIFFERENCE |  |  |  | 0.1
10 |  |  | AMENDED |  |  |  | 0.1
11 |  |  | PREVIOUS |  |  |  | 0.1
12 |  |  | DIFFERENCE |  |  |  | 0.1
 |  | AMENDED TOTALS page 1
Spreadsheet: 105613d1302903975-excel-2007-convert-from-mm-to-cm-book2
Sheet: Sheet1

Sectiune
700 x 700mm |  | 70x70
700 x 700mm |  | 70x70
700 x 700mm |  | 70x70
750 x 750mm |  | 75x75
650 x 650mm |  | 65x65
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
650 x 650mm
Spreadsheet: 159500d1338710516-formula-to-count-word-occurrence-for-every-nth-cell-book1_jckmd
Sheet: Sheet1

With Text > | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Saturdays
worker 1 | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 2
worker 2 | x | x |  | x | x |  | x | x |  | x | x |  | x | x | 1
worker 3 | x | x | x |  | x | x | x |  | x | x | x |  | x | x | 2
worker 4 |  | x | x |  | x | x |  | x | x |  | x | x |  | x | 1
worker 5 |  |  | x | x | x |  | x | x | x |  | x | x | x |  | 1
worker 6 | x |  | x | x |  | x | x |  | x | x |  | x | x |  | 2
worker 7 | x |  | x |  | x |  | x |  | x |  | x |  | x |  | 1
worker 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
worker 9 | x | x | x | x | x |  |  | x | x | x | x | x |  |  | 0
worker 10 |  |  |  |  |  | x | x |  |  |  |  |  | x | x | 2
Or
With Dates > | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | Saturdays
worker 1 | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 2
worker 2 | x | x |  | x | x |  | x | x |  | x | x |  | x | x | 1
worker 3 | x | x | x |  | x | x | x |  | x | x | x |  | x | x | 2
worker 4 |  | x | x |  | x | x |  | x | x |  | x | x |  | x | 1
worker 5 |  |  | x | x | x |  | x | x | x |  | x | x | x |  | 1
worker 6 | x |  | x | x |  | x | x |  | x | x |  | x | x |  | 2
worker 7 | x |  | x |  | x |  | x |  | x |  | x |  | x |  | 1
worker 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
worker 9 | x | x | x | x | x |  |  | x | x | x | x | x |  |  | 0
worker 10 |  |  |  |  |  | x | x |  |  |  |  |  | x | x | 2
Spreadsheet: 722132d1615054521-formula-to-split-text-at-a-space-and-insert-line-breaks-split-text-example
Sheet: Sheet1

 | customer | bill to | ship to | work order | item # | po date | po | due | description | notes | packaging | qty | uom | part # | whse | po # | d/s # | PO COMMENTS | RESULT
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | needs a delivery appointment must email [EMAIL] for appointment BOL:PO#12345678910PO yadda yadda yadda yadda yadda yadda yadda yadda yaddadda
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Now is the time for all good men to come to the aid of the party
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Now is the time for all good men to come to the aid of the party
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Now is the time for all good men to come to the aid of the
6
7
8
9
10
Spreadsheet: 14fb8abb-22c2-4cec-b77c-32847a8e2522
Sheet: Sheet 1

Scenario 1:
Item # | Position /Description |  | Total Cost
1 | #139330 - Dean of Instruction |  | 131407
2 | #136050 - Sr Desktop Support Tech, IT |  | 101663
3 | #122550 - Sr Office Coordinator |  | 81073
4 | #122330 - Student Services Technician |  | 80839
Scenario 2:
Item # | Position / Description |  | Total Cost
1 | Salary Saving # 122330 from RT supported by Grants
2 | [NAME] from RT supported by Grants | 59849
3 | [NAME] from RT supported by Grants | 16455
4 | [NAME] from RT supported by Grants | 2463
5 | Interest Income from various Funds |  | 25217
6 | Budget cut from Graphics / Printing |  | 10000
7 | Budget cut from Community Education Department |  | 10000
8 | Budget cut from Research & Planning |  | 5000
9 | Budget cut from Lottery Supplies |  | 10000
10 | Budget cut from Evening Administration |  | 8000
11 | Support by LandCorp |  | 219154
Spreadsheet: jeff_dasovich__14203__E204_Airline_Overbooking_sim-2
Sheet: Overbooking

CB Example 3:  Airline Overbooking
GIVEN DATA
115 | Plane Capacity
400 | Ticket Price (Assume this is fully refundable to those who "no-show".)
700 | Cost per "Bumped" Passenger
 | Assume that the variable cost per passenger is 0.
 | Assume no "stand-bys".
0.1 | Probabilty That a Passenger with a Confirmed Reservation is a "No-Show"
 | Probability Distribution for the Demand for Confirmed Reservations ----------------> |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | PROB.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-109 | 0.01 each
DECISION |  |  |  |  |  |  |  |  |  |  |  |  |  | 110-119 | 0.02 each
120 | Maximum Allowable Number of Confirmed Reservations |  |  |  |  |  |  |  |  |  |  |  |  | 120-129 | 0.04 each
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 130-139 | 0.02 each
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 140-149 | 0.01 each
RESULTS OF DECISION |  |  |  |  |  |  |  |  |  | ANNOTATIONS FOR COLUMN A
123 | Demand for Confirmed Reservations |  |  |  |  |  |  |  |  | <--- | Assumption Cell:  Custom with above data
 | Actual Number of Confirmed Reservations |  |  |  |  |  |  |  |  | <--- | =MIN(A13,A18)
13 | Number With Reservations Who "No-Show" |  |  |  |  |  |  |  |  | <--- | Assumption Cell:  [NAME] with n=A19 and p=A9
 | Number With Reservations Who  "Show" |  |  |  |  |  |  |  |  | <--- | =A19-A20
 | Number With Reservations Who Board Plane |  |  |  |  |  |  |  |  | <--- | =MIN(A4,A21)
 | Number With Reservations Who Are "Bumped" |  |  |  |  |  |  |  |  | <--- | =A21-A22
 | Total Revenue from Tickets |  |  |  |  |  |  |  |  | <--- | =A5*A22
 | Total Cost of "Bumping" |  |  |  |  |  |  |  |  | <--- | =A6*A23
 | TOTAL CONTRIBUTION |  |  |  |  |  |  |  |  | <--- | Forecast Cell:  =A25-A26
Spreadsheet: 714167d1611128392-formula-to-fill-cells-based-on-date-and-drop-down-status-copy-of-gantt-2021-template-1-
Sheet: Together Detailed Roadmap

Details |  |  | Timeline |  |  |  |  | 2021-01-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-03-01 00:00:00 |  |  |  |  | 2021-04-01 00:00:00 |  |  |  | 2021-05-01 00:00:00 |  |  |  | 2021-06-01 00:00:00 |  |  |  |  | 2021-07-01 00:00:00 |  |  |  | 2021-08-01 00:00:00 |  |  |  | 2021-09-01 00:00:00 |  |  |  |  | 2021-10-01 00:00:00 |  |  |  | 2021-11-01 00:00:00 |  |  |  |  | 2021-12-01 00:00:00
 |  |  |  |  |  |  |  | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00 | 2021-04-05 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00 | 2021-07-26 00:00:00 | 2021-08-02 00:00:00 | 2021-08-09 00:00:00 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00 | 2021-08-30 00:00:00 | 2021-09-06 00:00:00 | 2021-09-13 00:00:00 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 2021-10-04 00:00:00 | 2021-10-11 00:00:00 | 2021-10-18 00:00:00 | 2021-10-25 00:00:00 | 2021-11-01 00:00:00 | 2021-11-08 00:00:00 | 2021-11-15 00:00:00 | 2021-11-22 00:00:00 | 2021-11-29 00:00:00 | 2021-12-06 00:00:00 | 2021-12-13 00:00:00 | 2021-12-20 00:00:00 | 2021-12-27 00:00:00 | 2022-01-03 00:00:00
ID | Product | Main Tabs | Start Date | End Date | W. Days | Weeks | Status | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53
1 | Product | Product 1 | 2021-02-15 00:00:00 | 2021-03-13 00:00:00 |  | 3 | False
1 | Product | Product 1 | 2021-02-08 00:00:00 | 2021-03-01 00:00:00 |  | 3 | NOT STARTED
1.01 | Product | Sub-Product 1 | 2021-03-11 00:00:00 | 2021-06-10 00:00:00 |  | 13 | DELAYED
1.02 | Product | Sub-Product 2 | 2021-03-05 00:00:00 | 2021-03-10 00:00:00 |  | 0 | [NAME]
2 | Product | Product 2 | 2021-03-10 00:00:00 | 2021-03-15 00:00:00 |  | 0 | DELAYED