tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 54116d1254146208-multiple-outcomes-from-a-logical-formula-multiple-outcomes-from-a-logical-formula
Sheet: Sheet1

 |  |  |  |  |  |  | GRADES
 | Student1 | 236 | C |  |  |  | 50 | A
 | Student2 | 145 | B |  |  |  | 100 | B
 | Student3 | 236 | C |  |  |  | 200 | C
 | Student4 | 145 | B |  |  |  | 300 | D
 | Student5 | 236 | C |  |  |  | 400 | E
 | Student6 | 145 | B |  |  |  | 500 | F
 | Student7 | 236 | C
 | Student8 | 145 | B
 | Student9 | 236 | C
 | Student10 | 145 | B
 | Student11 | 236 | C
 | Student12 | 145 | B
 | Student13 | 236 | C
 | Student14 | 145 | B
 | Student15 | 236 | C
 | Student16 | 145 | B
 | Student17 | 236 | C
 | Student18 | 145 | B
 | Student19 | 236 | C
 | Student20 | 145 | B
 | Student21 | 236 | C
 | Student22 | 145 | B
 | Student23 | 236 | C
 | Student24 | 145 | B
Spreadsheet: 96236d1295633160-discounted-cash-flow-book1
Sheet: Sheet1

Instructions
Find the shareholder value per share using a discounted cash flow analysis.
Calculate the stock's margin of safety.
Be sure that the formulas behind all calculations are provided in your model.
Note: Use the CAPM to find the cost of equity.
 |  |  |  | Capital Use | 100 | 110 | 121 | 133.1000000000001 | 146.4100000000001 | 161.0510000000001
Assumptions |  |  |  |  | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | DCF
NOPAT in current year 0 | 1100 |  |  | [NAME] Use | 100 | 101.7778071508823 | 103.5872202844219 | 105.4288012940386 | 107.3031220625335 | 109.2107646396812 | 527.3077154315574
NOPAT growth | 0.1 |  |  | NOPAT | 1100 | 1210 | 1331 | 1464.1 | 1610.51 | 1771.561
Capital use in current year 0 | 100 |  |  |  | 1000 | 1108.222192849118 | 1227.412779715578 | 1358.671198705962 | 1503.206877937467 | 1662.350235360319
Growth in capital use | 0.1 |  |  | VPS | 1 | 1.108222192849118 | 1.227412779715578 | 1.358671198705962 | 1.503206877937467 | 1.662350235360319
Forecast period (in years) | 5
NOPAT growth in perpetuity | 0
Risk-Free Rate | 0.035
Beta | 1.2
Expected return on the market | 0.08
Credit Spread | 0.01
Market value of equity | 15000
Market value of debt | 2500
Marginal Tax Rate | 0.3
Shares outstanding | 1000
17500 | 0.04500000000000001
[NAME]: Req Ret=Risk free+ Beta(Market Risk Premium)
0.089
WACC=E/V*Re+D/V*Rd*(1-T)
0.08078571428571428
EVPS=EV/# shares outstanding
15
428.5714285714286
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: Apr - Inv

 | Month | 4
 | Year | 2020
Child's Name | Parent's Name | Address
 |  |  | 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
Spreadsheet: 885768d1735607918-get-a-new-list-from-one-column-to-a-new-column-treasurer-report-redacted
Sheet: Check Register

[NAME] |  |  |  |  | Current Balance |  |  |  |  | Column1 | Total | Column2
Date | Check # | Description | Split Amounts | Withdrawal | Deposit | Balance | Reconciled | Category |  | NonReconcilled Checks | Outstanding | Balance Balance
2024-09-04 00:00:00 |  | Beginning Balance Deposit |  |  |  | 0
9/4/20224 |  | Deposit - Dues and Lifeflight |  |  | 630 |  | R | Dues & Lifeflight
2024-09-06 00:00:00 |  | Deposit - Dues,Lifeflight, Philanthropic, 50/50 Drawing |  |  | 1800.5 |  | R | Dues & Lifeflight
2024-09-24 00:00:00 |  | Deposit - Bonnie Alumnae Log |  |  | 10 |  | R | [NAME] (2x10) Income
2024-09-25 00:00:00 | 101 | Lifeflight |  | 1275 |  |  | R | Lifeflight
2024-09-25 00:00:00 | 102 | [NAME] |  | 27.82 |  |  | R | Miscellaneous Expense
2024-10-02 00:00:00 |  | Deposit - Dues and Lifeflight |  |  | 300 |  | R | Dues & Lifeflight
2024-10-08 00:00:00 |  | Deposit - Sales of Badges |  |  | 6 |  | R | Miscellaneous Income
2024-10-08 00:00:00 |  | Transfer original savings deposit back to checking |  |  | 35 |  | R | Transfer From Savings
2024-10-16 00:00:00 | 103 | District 6 Counselor - Travel Fund |  | 95 |  |  |  | DC Travel Fund
2024-10-16 00:00:00 | 104 | [NAME] Voided Used to [NAME]'s [NAME] |  |  |  |  | R | Dues
2024-10-16 00:00:00 | 105 | Meals on Wheels |  | 346 |  |  | R | [NAME]
 |  | 50/50 Drawing | 155
 |  | Meals on Wheels | 3
2024-10-17 00:00:00 |  | Deposit - 50/50 Drawing and Meals on Wheels |  |  |  |  | R | [NAME]
2024-10-18 00:00:00 | 106 | Alpha Sorority |  |  |  |  |  | Dues - International
 |  | International Dues | 770
 |  | Convention Assessment | 15
2024-11-20 00:00:00 | 107 | District 6 Counselor - Travel Fund |  | 10 |  |  |  | DC Travel Fund
2024-11-20 00:00:00 | 108 | Patsy - Efficiency Award |  | 20 |  |  |  | Awards
 |  | Philanthropic - Honor Flight | 201
 |  | 50/50 Drawing | 4.3
2024-11-25 00:00:00 |  | Deposit - Honor Flight and 50/50 Drawing |  |  |  |  | R | [NAME]
2024-12-11 00:00:00 | 109 | Church |  | 35 |  |  |  | Room Rent
2024-12-10 00:00:00 | 110 | Honor Flight |  | 422 |  |  |  | [NAME]
 |  | Honor Flight | 221
 |  | 50/50 Drawing | 4.5
2024-12-10 00:00:00 |  | Deposit - Honor Flight and 50/50 Drawing |  |  |  |  |  | [NAME]
Spreadsheet: 750983d1633763181-help-recalculating-a-group-of-numbers-to-equal-a-specific-number-pct-shots-hit
Sheet: Sheet1

Name |  | %hit | total shots | shots hits | additional shots | new shots hit | new %hit
Player A |  | 0.95 | 70
Player B |  | 0.84 | 70
Player C |  | 0.58 | 70
Player D |  | 0.16 | 70
Total
Required |  | 0.71 | 280
Each Player cant have more than 70 shots that stays the same
Spreadsheet: 393e50c6-7eba-488b-8120-aa18f6fe2825
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
State Representatives - CARROLL County - Republican
District No. 1 (1) | [NAME], r | [NAME], d | [NAME]
[NAME] | 292
Hart's Location | 4
[NAME] | 115 |  | 1
Totals | 411 |  | 1
District No. 2 (3) | Umberger, r | [NAME], r | McClure, r | Steiner, r | Bridgham, d | Buco, d | Pollock, d | White, d | [NAME]
Chatham | 34 | 25 | 25 | 20
Conway | 527 | 556 | 383 | 313 |  | 2 | 4 | 1 | 5
Eaton | 41 | 52 | 18 | 44
Hale's Location | 62 | 68 | 81 | 15
Totals | 664 | 701 | 507 | 392 |  | 2 | 4 | 1 | 5
District No. 3 (2) | Thomson, r | McConkey, r | Ticehurst, d | [NAME]
Albany | 37 | 37
Freedom | 158 | 165 |  | 1
[NAME] | 159 | 161 | 1 | 1
Tamworth | 151 | 194 |  | 3
Totals | 505 | 557 | 1 | 5
District No. 4 (2) | Lyon, r | Askew, r | [NAME], r | Crawford, r | Albee, d | [NAME]
Moultonborough | 164 | 187 | 306 | 449 | 1 | 1
Sandwich | 37 | 29 | 115 | 88
Tuftonboro | 164 | 187 | 220 | 88 | 4
Totals | 365 | 403 | 641 | 625 | 5 | 1
District No. 5 (3) | Merrow, r | [NAME], r | Olimpio, r | Lavender, d | [NAME]
[NAME] | 50 | 94 | 45 | 2 | 3
[NAME] | 123 | 87 | 67 |  | 4
Ossipee | 408 | 240 | 176 |  | 4
Wakefield | 291 | 284 | 226 |  | 8
Totals | 872 | 705 | 514 | 2 | 19
District No. 6 (2) | Ahlgren, r | [NAME], r | White, d | Woods, d | [NAME]
Wolfeboro | 682 | 605
District No. 7 (1) F | Callis, r | Tregenza, r | Butler, d | [NAME]
Albany | 29 | 38
[NAME] | 108 | 164 | 1
Chatham | 8 | 28
Conway | 250 | 418 | 3 | 1
Eaton | 16 | 62
Freedom | 70 | 142 |  | 1
Hale's Location | 21 | 44
Hart's Location | 2 | 1
[NAME] | 32 | 66
[NAME] | 64 | 208 | 2
Tamworth | 85 | 139 |  | 1
Totals | 685 | 1310 | 6 | 3
District No. 8 (1) F | [NAME], r | Wiley, d | [NAME]
[NAME] | 90
[NAME] | 137
Moultonborough | 575 |  | 4
Ossipee | 373 | 2
Sandwich | 157
Tuftonboro | 350 |  | 2
Wakefield | 377 | 8 | 2
Totals | 2059 | 10 | 8
Spreadsheet: 69221d1269739840-conditional-if-book1
Sheet: Sheet1

2010-03-01 00:00:00 | 111 | 142 | 600 | 786 | 986 | 1034 | 1109 |  |  | 7
Date | Duplicates |  |  |  |  |  |  |  |  | Totals
2010-03-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-10 00:00:00 | 111 | 142 | 600 | 786 | 986 | 1034 | 1109 | 0 | 0 | 7
 | Row 3 updates from another sheet and changes fairly often. The comparison I need to make is against anoth worksheet. In this example if the date in column A = the date in sheet 2 A2 then copy the numbers from row 3 into the relevant row. As you can see when I do it and drag the formula down of course the date is only valid on one line so it defaults everything else back to 0.
Spreadsheet: 767880d1644691158-sumif-range-len-split-range-test_rev01-jtm2019hyo-
Sheet: Sheet1

 |  |  |  |  |  | SUM(RESULT*COUNT) |  |  |  | SumIf(range) * LEN(Split(range)) (excelforum.com)
 |  | string1
 |  | STRINGS TO MATCH | RESULT | COUNT | RESULT*COUNT
 |  | string0,STRING2;string0,STRING3;string0,STRING4;string0,STRING5; | 10
 |  | string1,STRING2;string0,STRING3;string0,STRING4;string0,STRING5; | 20
 |  | string1,STRING2;string1,STRING3;string0,STRING4;string0,STRING5; | 30
 |  | string1,STRING2;string1,STRING3;string1,STRING4;string0,STRING5; | 40
 |  | string1,STRING2;string1,STRING3;string1,STRING4;string1,STRING5; | 50
Spreadsheet: tracy_geaccone__40387__IPR_JAmbler 2002 budget
Sheet: Allocations

Distribution of Service Costs to Business Units
[NAME]:
Based on Historical usage and anticipated activity
 |  |  | 2001 | 2001 |  | 2002 |  | 2002
 |  |  | PLAN | ESTIMATE |  | PLAN |  | Monthly Alloc
Total O&M Expenses
Enter positive amounts for distributions in the 2002 Plan column.
Distribution : |  |  |  |  |  |  |  |  |  | Co #
 | Transwestern |  | 0 | 0 |  | 0 |  |  |  | 60
 | Florida Gas Transmission |  | 0 | 0 |  | 0 |  |  |  | 62
 | Citrus Corp |  | 0 | 0 |  | 0 |  |  |  | 85
 | Northern Plains |  | 0 | 0 |  | 0 |  |  |  | 172
 | Northern Natural Gas |  | 0 | 0 |  | 0 |  |  |  | 179
 | ETS - Headquarters |  | 0 | 0 |  | 0 |  |  |  | 366
 | EOTT Energy |  | 0 | 0 |  | 0 |  |  |  | 105
 | EEOS |  | 0 | 0 |  | 0 |  |  |  | 82
 | NEPCO |  | 0 | 0 |  | 0 |  |  |  | 974
 | Enron North America |  | 0 | 0 |  | 0 |  |  |  | 413
 | Enron Europe |  | 0 | 0 |  | 0 |  |  |  | 912
 | Enron Global Markets |  | 0 | 30 |  | 600000 |  |  |  | 1105
 | Enron Industrial Markets |  | 0 | 0 |  | 0 |  |  |  | 1206
 | Enron Energy Services |  | 0 | 0 |  | 0 |  |  |  | 985
 | Enron Broadband Services |  | 0 | 0 |  | 0 |  |  |  | 017H
 | Enron Networks |  | 0 | 0 |  | 0 |  |  |  | 083E
 | EGAS |  | 0 | 30 |  | 600000
 | India |  | 0 | 35 |  | 550000 |  |  |  | 061P
 | Enron Global Finance |  | 0 | 0 |  | 0 |  |  |  | 969
 | Enron Principal Initiatives |  | 0 | 0 |  | 0 |  |  |  | 419
 | PGG |  | 0 | 0 |  | 0 |  |  |  | 016R
 | AZURIX |  | 0 | 5 |  | 80000 |  |  |  | 040Y
 |  |  | 0 | 0 |  | 0
Total Distributions
NET EXPENSES (will remain at cost center)
Spreadsheet: 489712d1479398592-pivot-table-dynamically-calculating-range-columns-pivot-table
Sheet: activity

Count of range | Column Labels
Row Labels | 14-15 | 15-16 | Grand Total | Variant | Percentage variant
ABC Limited | 216 | 209 | 425
[NAME] | 111 | 106 | 217
BEST Limited2 | 102 | 117 | 219
Grand Total | 429 | 432 | 861
Spreadsheet: 800317d1665595095-enter-unique-id-and-see-only-row-level-data-related-to-that-unique-secret-key-pin-test
Sheet: Sheet1

Security PIN 1 | Security PIN 2 | Sensitive Information
[NAME] | Unique Individual | Name | Dollar
33333 | 111202 | [NAME] | 100000
33333 | 11111 | Stacy | 50000
33333 | 111202 | [NAME] | 110000
44444 | 111222 | [NAME] | 75000
44444 | 33333 | [NAME] | 350000
Spreadsheet: 541296d1507211946-need-something-to-find-duplicates-across-sheets-inventory-accuracy-template
Sheet: Shops

Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | US Shops TOTAL
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
Applied Central | C41 | 4010 | LONDON, ON | CA | 444949.02 | 558699.9 | 3784.43 | 0.00371719058360108 | 6694 | 1118 | 0.167015237526143 | 320302.241 | 319524.934 | 0.00242679226212497 | 0.024760988169296 | 7931 | Exempt | FP | 2017-08-01 00:00:00
 |  |  | CAN Shops TOTAL
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | Rubber Shop TOTAL
**2310, 2359 & 2070 perform semi-annual full physical inventory counts.
Spreadsheet: 698598d1602074226-dependent-drop-down-list-why-is-indirect-formula-not-working-excel-assistance
Sheet: Page 2

Fruit | Veg | Meat | Drinks | Sweets
[NAME] | Potato | Beef | Cola | crisps
Apple | Carrot | Chicken | Lemonade | chocolate
Pear | Pea | Pork | squash | Biscuits
Grape | Spinach | Lamb | juice | Cake
Spreadsheet: 819752d1677679687-averaging-non-contigious-ranges-in-excel-excluding-zeros-maverickjc-averageifs-proforma
Sheet: Sheet1

 |  | Sunday, January 08, 2023 | Sunday, January 15, 2023 | Sunday, January 22, 2023 | Sunday, January 29, 2023 | Jan MTD Average | Jan Trailing 3-Month | Sunday, February 05, 2023 | Sunday, February 12, 2023 | Sunday, February 19, 2023 | Sunday, February 26, 2023 | Feb MTD Average | Feb Trailing 3-Month | Sunday, March 05, 2023 | Sunday, March 12, 2023 | Sunday, March 19, 2023 | Sunday, March 26, 2023 | [NAME] Average | [NAME] 3-Month | Sunday, April 02, 2023 | Sunday, April 09, 2023 | Sunday, April 16, 2023 | Sunday, April 23, 2023 | Sunday, April 30, 2023 | Apr MTD Average | Apr Trailing 3-Month | Sunday, May 07, 2023 | Sunday, May 14, 2023 | Sunday, May 21, 2023 | Sunday, May 28, 2023 | May MTD Average | May Trailing 3-Month | Sunday, June 04, 2023 | Sunday, June 11, 2023 | Sunday, June 18, 2023 | Sunday, June 25, 2023 | [NAME] Average | Jun Trailing 3-Month | Sunday, July 02, 2023 | Sunday, July 09, 2023 | Sunday, July 16, 2023 | Sunday, July 23, 2023 | Sunday, July 30, 2023 | Jul MTD Average | Jul Trailing 3-Month | Sunday, August 06, 2023 | Sunday, August 13, 2023 | Sunday, August 20, 2023 | Sunday, August 27, 2023 | Aug MTD Average | Aug Trailing 3-Month | Sunday, September 03, 2023 | Sunday, September 10, 2023 | Sunday, September 17, 2023 | Sunday, September 24, 2023 | Sep MTD Average | Sep Trailing 3-Month | Sunday, October 01, 2023 | Sunday, October 08, 2023 | Sunday, October 15, 2023 | Sunday, October 22, 2023 | Sunday, October 29, 2023 | Oct MTD Average | Oct Trailing 3-Month | Sunday, November 05, 2023 | Sunday, November 12, 2023 | Sunday, November 19, 2023 | Sunday, November 26, 2023 | Nov MTD Average | Nov Trailing 3-Month | Sunday, December 03, 2023 | Sunday, December 10, 2023 | Sunday, December 17, 2023 | Sunday, December 24, 2023 | Sunday, December 31, 2023 | Dec MTD Average | Dec Trailing 3-Month |  | YTD CUMULATIVE
 |  | 0.75 | 0.78 | 0.85 | 0.75 |  | N/A | 0.85 | 0.83 | 0.71 | 0.65 |  | N/A | 0.65 | 0.72 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 |  | N/A | 0 | 0 | 0 | 0 | 0 |  | N/A
Spreadsheet: 493847d1481907963-sum-of-independent-arrays-independent-arrays
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
1 | 1 | 1 | 1
Spreadsheet: 07385571-d0e8-40fd-8187-22bc798610a3
Sheet: Income Statement

(Currency - in Thousands of New Turkish Lira ("TL") unless otherwise indicated)
 |  | Current Period |  | Prior Period
 | Notes | (Reviewed) | (Not reviewed) | (Reviewed) | (Not reviewed)
 |  | 1 January 2011 - | 1 April 2011 - | 1 January 2010 - | 1 April 2010 -
 |  | 30 June 2011 | 30 June 2011 | 30 June 2010 | 30 June 2010
Revenue | 5 | 5855038 | 2968141 | 5249939 | 2666430
Cost of sales (-) | 5 | -2501890 | -1301623 | -2379447 | -1149480
Gross profit |  | 3353148 | 1666518 | 2870492 | 1516950
Marketing, sales and distribution expenses (-) | 5 | -964562 | -496094 | -748390 | -399681
General administrative expenses (-) | 5 | -767456 | -364683 | -748358 | -380290
Research and development expenses (-) | 5 | -11971 | -3055 | -16919 | -7664
Other operating income |  | 173856 | 82457 | 203772 | 114690
Other operating expense (-) |  | -43171 | -18807 | -62827 | -35403
Operating profit |  | 1739844 | 866336 | 1497770 | 808602
Financial income |  | 311920 | 143869 | 315758 | 177447
Financial expense (-) |  | -666956 | -377562 | -323021 | -193261
Profit before tax |  | 1384808 | 632643 | 1490507 | 792788
Tax expense
Tax expense for the period |  | -379659 | -169409 | -446858 | -234480
Deferred tax income |  | 27306 | -2068 | 23332 | 4985
Net profit |  | 1032455 | 461166 | 1066981 | 563293
Attribution of net profit
Attributable to equity holders of the parent |  | 1114567 | 505727 | 1147276 | 601021
Minority interest |  | -82112 | -44561 | -80295 | -37728
Earnings per shares attributable to equity holders of the parent from (in full Kuruş) | 4 | 0.3184 | 0.1445 | 0.3278 | 0.1717
Earnings per diluted shares attributable to equity holders of the parent from (in full Kuruş) | 4 | 0.3184 | 0.1445 | 0.3278 | 0.1717
Spreadsheet: 0148412c-2073-4c68-b42e-f10203225ece
Sheet: Sheet1

IMPERIAL VALLEY COLLEGE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]
BUDGET PERIOD:
TRANSACTION DATE: |  |  | JV NUMBER
PREPARED BY:
DEPARTMENT:
[NAME]:
only one debit or credit per row
NAME  OF  ACCOUNT | FUND | ORG | ACCT | PROG | DEBIT |  | CREDIT
APPROVAL  (PRINT NAME IN BOX) |  |  |  | TOTALS | 0 |  | 0
HASH TOTAL |  |  |  |  |  | 0
SIGNATURE |  | DATE
Spreadsheet: 874629d1721192840-constructing-cell-references-to-another-sheet-without-indirect-or-any-volatile-function-schnide-constructed-references-without-indirect-aligw
Sheet: Summary Sheet

 | SUMMARY SHEET
 |  | Name | Measure 1 | Measure 2 | Measure 3
 |  |  | 50 | 1005 | 7256
 |  | Idaho | 33 | 5926 | 2323
 |  | Kansas | 9 | 1111 | 953
 |  | Wichita | 2 | 156 | 52
Spreadsheet: d404b65a-3fce-43cc-b95c-b0563e643039
Sheet: Sheet1

BADMINTON England JUNIOR TOURNAMENT REFEREE'S REPORT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Tournament Title |  |  |  |  |  |  |  |  |  |  |  | Age Group |  |  | U
Day & Dates of Play:
Venue:
Secretary: |  |  |  |  |  |  |  |  | Referee:
Deputy Referee:
Signature of Secretary |  |  |  |  |  |  | Signature of Referee |  |  |  |  |  | Date
Please list names and e-mail contact of other helpers. Only include e-mail addresses if the person concerned is happy to receive  information from BADMINTON England about its events and other promotions.
Name |  |  |  |  |  |  | E:mail
Name |  |  |  |  |  |  | E:mail
Name |  |  |  |  |  |  | E:mail
Name |  |  |  |  |  |  | E:mail
Name |  |  |  |  |  |  | E:mail
 |  | Please state the actual number of players competing in the above tournament.
 | BOYS SINGLES |  |  |  | BOYS DOUBLES |  |  |  | [NAME]
 | GIRLS SINGLES |  |  |  | GIRLS DOUBLES |  |  |  | NO. BOYS  REJECTED |  |  |  | NO. GIRLS REJECTED
 |  |  | Please state the number of unused medals returned.
 | Gold |  | Silver |  | [NAME] |  | How were the medals returned :-
 |  | Number of Matches Scheduled: |  |  |  |  |  |  | Total Number of Matches Played:
 |  | WITHDRAWALS: |  |  |  |  |  |  |  |  |  |  |  |  | For BE Gold only
 | Players name(s) |  |  |  | On Date | Event(s) |  | Reason (in brief) |  |  |  |  |  | Value of C.Note
1 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
2 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
3 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
4 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
5 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
7 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
10 |  |  |  |  |  |  |  |  |  |  |  |  |  | £
Spreadsheet: 1f7ec7b3-555e-4428-a8e0-c193aba2ba77
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30
ETHNIC GROUP DETAILS OF JOB APPLICANTS FOR 1/04/07 - 31/03/08
ALL INSTITUTES*
TOTAL NUMBER OF APPLICANTS |  |  |  | 1055
TOTAL POSTS APPOINTED |  |  |  | 115
TOTAL OF UNFILLED POSTS |  |  |  | 5
TOTAL OF UNACCEPTED POSTS
* Figures for Swindon Office not yet available (will be included at a later date.)
ETHNIC GROUP |  |  | APPLICANTS |  |  | SHORTLISTED |  |  | POSTS OFFERED |  |  | POSTS APPOINTED |  |  |  | ETHNIC GROUP |  |  | APPLICANTS |  |  | SHORTLISTED |  |  | POSTS OFFERED |  |  | POSTS APPOINTED
 |  |  | M | F | BLANK | M | F | BLANK | M | F | BLANK | M | F | BLANK |  |  |  |  | M | F | BLANK | M | F | BLANK | M | F | BLANK | M | F | BLANK
Asian or Asian British: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | White:
Indian |  |  | 106(10.05%) | 56(5.31%) |  | 9 | 7 |  | 4 | 3 |  | 4(3.48%) | 3(2.61%) |  |  | British |  |  | 235(22.27%) | 171(16.21%) | 1(0.09%) | 55 | 66 | 0 | 26 | 33 | 0 | 26(22.61%) | 31(26.96%) | 0
Pakistani |  |  | 20(1.9%) | 7(0.66%) |  | 1 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | Irish |  |  | 6(0.57%) | 5(0.47%) | 0 | 2 | 1 | 0 | 1 | 1 | 0 | 1(0.87%) | 1(0.87%)
[NAME] |  |  | 14(1.33%) | 5(0.47%) |  | 3 | 2 |  | 1 | 1 |  | 1(0.87%) | 1(0.87%) |  |  | Other |  |  | 68(6.44%) | 119(11.28%) | 1(0.09%) | 20 | 35 | 0 | 7 | 22 | 0 | 7(6.09%) | 21(18.26%)
Other |  |  | 16(1.52%) | 12(1.14%) |  | 1 | 4 |  | 0 | 0 |  | 0 | 0
Black & Black British: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | F | BLANK | M | F | BLANK | M | F | BLANK | M | F | BLANK
Caribbean |  |  | 3(0.28%) | 1(0.09%) |  | 0 | 1 |  | 0 | 1 |  | 0 | 1(0.87%) |  |  | Unknown Ethnic Group |  |  | 24(2.27%) | 11(1.04%) | 5(0.47%) | 7 | 6 |  | 6 | 6 |  | 6(5.22%) | 6(5.22%)
African |  |  | 22(2.09%) | 7(0.66%) |  | 4 | 1 |  | 0 | 1 |  | 0 | 1(0.87%)
Other |  |  | 1(0.09%) | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Chinese |  |  | 52(4.93%) | 31(2.94%) |  | 10 | 6 |  | 2 | 3 |  | 2(1.74%) | 3(2.61%)
Mixed:
White & Black Caribbean |  |  | 3(0.28%) | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
White & Black African |  |  | 2(0.19%) | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
White & Asian |  |  | 2(0.19%) | 4(0.38%) |  | 0 | 1 |  | 0 | 0 |  | 0 | 0
Other |  |  | 4(0.38%) | 3(0.28%) |  | 0 | 2 |  | 0 | 0 |  | 0 | 0
Other Ethnic Group: |  |  | 16(1.52%) | 22(2.09%) |  | 2 | 5 |  | 0 | 0 |  | 0 | 0
TABLE OF NOT ACCEPTED/NOT FILLED POSTS
ETHNIC GROUP |  |  | POSTS NOT ACCEPTED |  |  | POSTS NOT FILLED
 |  |  | M | F | BLANK | M | F | BLANK
Other ethnic group |  |  | 0 | 0 | 0 | 1 | 0 | 0
White/British |  |  | 0 | 0 | 0 | 1 | 2 | 0
White/Irish |  |  | 0 | 0 | 0 | 1 | 0 | 0
Unknown |  |  | 0 | 0 | 1 | 0 | 0 | 0