tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 836559d1689491220-data-table-selecting-wrong-criteria-cf-sharepoint-aligw
Sheet: query

ID | Date of Visit | Inspection Category | Finding Type | Finding Category | Finding Sub-Category | Risk Rating | Has a [NAME] been broken? | [NAME]
4 | 2023-03-07 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Excavation | Positive Observation | No | Breaking Ground & Excavations
5 | 2023-03-07 00:00:00 | Health_Safety | Negative | Health_Safety | Health_Safety-Welfare | High (Close in 24hours)
6 | 2023-03-07 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Excavation | Positive Observation | No | Breaking Ground & Excavations
10 | 2023-03-17 00:00:00 | Health_Safety | Negative | Health_Safety | Health_Safety-Fire/Emergency | High (Close in 24hours) | Yes | Fire Safety
11 | 2023-03-17 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Traffic Management | High (Close in 24hours) | Yes | Mobile Plant & Equipment
12 | 2023-03-17 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Lifting Operation | Positive Observation | No | Lifting
13 | 2023-03-07 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Welfare | Positive Observation | No
14 | 2023-03-07 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Excavation | Positive Observation | No | Breaking Ground & Excavations
15 | 2023-03-17 00:00:00 | Health_Safety | Positive | Health_Safety | Environment-Housekeeping | Positive Observation | Yes | Fire Safety
16 | 2023-03-07 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Training & Induction | Positive Observation | No
17 | 2023-03-07 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Excavation | Positive Observation | No | Breaking Ground & Excavations
18 | 2023-03-07 00:00:00 | Environment | Positive | Environment | Environment-Housekeeping | High (Close in 24hours) | No
19 | 2023-03-21 00:00:00 | Health_Safety | Negative | Health_Safety | Health_Safety-Work At Height | Critical (Stop Work) | Yes | Working at Height
20 | 2023-03-11 00:00:00 | Health_Safety | Negative | Environment | Environment-Spill Prevention & Response | High (Close in 24hours)
21 | 2023-03-11 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Welfare | Positive Observation | No
22 | 2023-03-11 00:00:00 | Health_Safety | Positive | Health_Safety | Health_Safety-Access & Egress | Positive Observation | No
24 | 2023-03-13 00:00:00 | Health_Safety | Negative | Health_Safety | Health_Safety-Fire/Emergency | Medium (Close in 1week)
25 | 2023-03-13 00:00:00 | Health_Safety | Negative | Health_Safety | Health_Safety-Hazard Identification | Medium (Close in 1week)
26 | 2023-03-13 00:00:00 | Environment | Negative | Environment | Environment-Spill Prevention & Response | Medium (Close in 1week)
Spreadsheet: 214829d1361144827-index-match-formula-doesnt-seem-to-be-working-indexmatch-problem
Sheet: Recipes

Name of Ingredient |  | Raw Materials Row No. |  | Note | Order Number | LBs | [NAME] | Cost Per LB | Batch/Unit Cost | Yield LBs | Shrinkage % | Raw Materials Per LB | Recipe Number |  | NUMBER OF INGREDIENTS
01 | Recipe |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 2
 |  |  | Ingredient |  |  | 220 |  |  |  |  |  |  |  |  | 1
 |  |  | Ingredient |  |  | 14.88
 |  |  | Ingredient |  |  | 14
 |  |  | Ingredient |  |  | 14
 | Recipe
 |  |  | Ingredient | 13" |  | 120 |  |  |  |  |  |  |  |  | 21
 |  |  | Ingredient |  |  | 81.38
 |  |  | Ingredient |  |  | 13.85
 |  |  | Ingredient |  |  | 12.7
 |  |  | Ingredient |  |  | 2.15
 |  |  | Ingredient |  |  | 1.6
 |  |  | Ingredient |  |  | 0.25
Spreadsheet: 18ad517d-4f3c-4796-9ca7-cb1e6ceab03a
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
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 16. PERIOD AVERAGE EXCHANGE RATES, Units of Foreign Currency per Australian Dollar
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Euro ; |  |  | Original | A2716728L | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | $ | INDEX | Month | 1
[NAME] ; |  |  | Original | A2716729R | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | $ | INDEX | Month | 1
United States Dollar ; |  |  | Original | A2716726J | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | $ | INDEX | Month | 1
United Kingdom Pound ; |  |  | Original | A2716727K | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | $ | INDEX | Month | 1
Special Drawing Right ; |  |  | Original | A2716730X | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | $ | INDEX | Month | 1
Trade Weighted Index ; |  |  | Original | A2716731A | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | Index Numbers | INDEX | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 863763d1711141302-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-dj
Sheet: Game 6

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00 |  |  |  |  | #[NAME]!
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1) |  |  | [NAME] | 44
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  | 6 | C (2) |  | Ty | Cobb | 2
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  | 6 | 1B (3) |  | [NAME] | Gehrig | 4
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  | 6 | 2B (4) |  | [NAME] | Henerson | 22
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  | 6 | 3B (5) |  | [NAME] | Mantle | 7
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  | 6 | SS (6) |  | Willie | Mays | 24
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  | 6 | LF (7) |  | [NAME] | Musial | 6
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  | 6 | CF (8) |  | [NAME] | [NAME] | 20
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  | 6 | RF (9) |  | Babe | [NAME] | 3
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  | 6 | SF (10) |  | [NAME] | [NAME] | 20
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  | 6 | EH () |  | [NAME] | [NAME] | 9
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 827444d1682696609-how-to-filter-a-spilling-range-filter-spilling-range
Sheet: Feuil1

ref | price |  |  |  | ref | price | position (expected_result)
A | 50 |  |  |  |  |  | 1
A | 300 |  |  |  | A | 300 | 3
A | 250 |  |  |  | A | 250 | 2
A | 500 |  |  |  | A | 500 | 4
A | 1000 |  |  |  | A | 1000 | 5
B | 250 |  |  |  | B | 250 | 3
B | 100 |  |  |  | B | 100 | 2
B | 25 |  |  |  | B | 25 | 1
Spreadsheet: benjamin_rogers__1041__Comps_DCF
Sheet: DCF Exit Year 1 - $6

DCF Analysis
Consolidated UFCF - $6/kW-month
 |  |  |  | CONTRACT PERIOD
 |  |  |  | 2001 | 2002 | 2003
EBITDA |  |  |  | 193.6809336759508 | 178.322664143352 | 177.8113210162394
 | % Annual Growth |  |  |  | -0.003263545051162664 | -0.002867516193575503
Depreciation |  |  |  | 44.22506419986609 | 44.22506419986609 | 44.22506419986609
EBIT |  |  |  | 149.4558694760847 | 134.0975999434859 | 133.5862568163733
Taxes on EBIT |  |  | 0.387 | -57.86635189958819 | -51.89522439440238 | -51.69733668921432
Unlevered Net Income |  |  |  | 91.58951757649652 | 82.20237554908351 | 81.888920127159
Plus:  Depreciation |  |  |  | 44.22506419986609 | 44.22506419986609 | 44.22506419986609
Plus:  Deferred Income Taxes |  |  |  | 28.93505545832036 | 41.52294025224838 | 41.73707264291678
Plus:  WC Adjustments (Property Taxes) |  |  |  | 0.1795618985999997 | 0.3466470000000004 | 0.1900860000000002
Unlevered Free Cash Flow |  |  |  | 164.929199133283 | 168.297027001198 | 168.0411429699419
 | % Annual Growth |  |  |  | 0.0819723273311499 | -0.001520431084348961
Valuation Matrix
 |  |  | $ CAPITAL COST / kW
 | DISCOUNT RATE |  | 400 |  | 410 |  | 420 |  | 430
 | 0.095 |  |  |  |  |  |  |  |  |  | PV of 2001 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  | PV of 2001 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  | PV of 2001 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  | PV of 2001 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
Spreadsheet: 22617d1211639981-grouping-data-filters-over-multiple-worksheets-cabs
Sheet: Comms

Period: | 1 | To be used as a guide only
 | Units |  |  | Payouts
Name: | Monthly | PrePaid | M.B/Band | Monthly | PrePaid | M.B/Band | Total
Person 01 |  | 1 |  | 0 | 2 | 0 | 2
Person 02 |  |  |  | 0 | 0 | 0 | 0
Person 03 |  | 2 |  | 0 | 4 | 0 | 4
Person 04 |  |  |  | 0 | 0 | 0 | 0
Person 05 |  | 4 |  | 0 | 8 | 0 | 8
Person 06 |  | 5 |  | 0 | 10 | 0 | 10
Spreadsheet: 739918d1626086302-combing-indirect-with-a-hlookup-and-with-a-calculation-combine
Sheet: Overview

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP DOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | forumla | ([NAME])
 | Ealing |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 | Fulham |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 | Harlesden |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 | Hounslow
 | Kingston
 | [NAME]
 | [NAME]
 | Uxbridge
 | WANDSWORTH
 | Wembley
January
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 220363d1363129524-formula-to-sum-all-unique-critera-and-find-highest-sum-jvbeats_test_ron_v1a
Sheet: Data

ID | Value
41-112242 | 12525.2
41-112246 | 25050.4
41-112246 | 25873.31
41-049800 | 38466.2
41-132963 | 51746.61
41-111446 | 77619.92
41-143869 | 102592.19
41-004579 | 102592.19
41-111312 | 127746.32
41-066299 | 192986.82
41-004822 | 205184.38
41-028273 | 214429.8
41-004822 | 214429.8
41-133711 | 278758.74
41-053706 | 332735.24
41-115595 | 337256.25
41-004579 | 416232.36
41-005166 | 416232.36
41-014186 | 536074.5
41-095783 | 600403.4400000001
41-005223 | 614723.9500000001
41-068994 | 674512.5
41-068994 | 763098.54
41-049684 | 767438.05
41-049675 | 819888.28
41-068994 | 898585.59
41-030653 | 1072149
41-087755 | 1132894.3
41-004954 | 1179363.9
41-072346 | 1479565.62
41-087755 | 1538882.85
41-004603 | 1602705.43
41-005091 | 1624480.92
41-016456 | 1638351.2
41-004802 | 1638351.2
41-044641 | 1639776.57
41-017657 | 1639776.57
41-049697 | 1639776.57
41-049677 | 1639776.57
41-004579 | 1811931.81
41-068994 | 2087443.58
41-026556 | 2439704
41-004822 | 2506021.6
41-113824 | 2601846.25
41-049677 | 2651397.4
41-118690 | 2968692.37
41-004604 | 3109232.1
41-060302 | 3248962
41-053706 | 4530489.21
41-093679 | 4687555.59
41-107347 | 6946454.5
41-049684 | 7036113.85
41-126640 | 48821604.23
41-005223 | 121835270.54
Spreadsheet: 98352d1297281808-multiply-countif-by-criteria-in-same-row-sample-book
Sheet: Sheet1

Customer | Code | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun |  | Code | Qty
cust 1 | Code 1 | Yes | No | Yes | No | Yes | No | No
cust 2 | Code 2 | No | Yes | No | Yes | No | Yes | Yes
cust 3 | Code 3 | Yes | No | Yes | No | Yes | No | Yes
cust 4 | Code 4 | Yes | No | Yes | No | Yes | No | No
cust 5 | Code 2 | Yes | No | Yes | No | No | Yes | No
cust 6 | Code 3 | No | Yes | No | Yes | Yes | Yes | No
cust 7 | Code 2 | No | Yes | No | Yes | Yes | No | Yes
cust 8 | Code 1 | Yes | No | Yes | No | No | Yes | No
cust 9 | Code 3 | No | Yes | No | Yes | Yes | Yes | No
cust 10 | Code 2 | Yes | No | Yes | No | No | No | Yes
cust 11 | Code 4 | Yes | No | Yes | No | No | No | Yes
Spreadsheet: 86045d1286018962-compare-column-a-between-2-worksheets-and-sum-respective-columns-inventory1-1-
Sheet: 200

INHI_ItemNbr | INHI_CurrQty_1 | INHI_CurrQty_2 | INHI_CurrQty_3 | INHI_CurrQty_4 | INHI_CurrQty_5 | INHI_CurrQty_6 | INHI_CurrQty_7 | INHI_CurrQty_8 | INHI_CurrQty_9
00100907 | 6 | 3 | 3 | 1.8 | 5 | 3 | 6 | 4 | 2
010110 | 2 | 2 | 2 | 3 | 2 | 2 | 3 | 3 | 2
010310 | 163 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
010380 | 10 | 10 | 7 | 0 | 0 | 8 | 10 | 8 | 9
015110 | 2 | 2 | 2 | 3 | 1 | 1 | 1 | 2 | 1
015130 | 2 | 1 | 0 | 3 | 2 | 2 | 3 | 1 | 1
015170 | 2 | 0 | 0 | 1 | 2 | 3 | 1 | 0 | 1
020100 | 8 | 4 | 16 | 12 | 3 | 15 | -1 | 20 | 4
020120 | 14 | 19 | 14 | 16 | 23 | 7 | 5 | 11 | 27
020140 | 41 | 35 | 69 | 47 | 47 | 48 | 24 | 33 | 38
020150 | 117 | 144 | 154 | 148 | 124 | 161 | 103 | 93 | 79
020160 | 64 | 28 | 42 | 96 | 27 | 43 | 28 | 25 | 48
020200 | 208 | 52 | 143 | 142 | 172 | 105 | 27 | 39 | 224
020210 | 84 | 50 | 83 | 63 | 50 | 97 | 62 | 78 | 63
020220 | 22 | 23 | 29 | 26 | 22 | 5 | 20 | 25 | 49
020280 | 62 | 15 | 51 | 29 | 36 | 24 | 32 | 30 | 22
020296 | 3 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 0
020300 | 62 | 58 | 81 | 55 | 80 | 78 | 72 | 70 | 53
020310 | 141 | 148 | 117 | 174 | 192 | 126 | 172 | 94 | 160
020320 | 321 | 269 | 236 | 350 | 342 | 330 | 229 | 188 | 415
020370 | 1 | 1 | 6 | 6 | 5 | 7 | 7 | 0 | 0
020375 | 3 | 5 | 1 | 1 | 0 | 3 | 7 | 0 | 3
020377 | 23 | 21 | 4 | 5 | 7 | 5 | 10 | 4 | 3
020380 | 22 | 19 | 23 | 26 | 3 | 11 | 16 | 15 | 35
020385 | 104 | 34 | 64 | 87 | 54 | 48 | 45 | 38 | 85
020440 | 26 | 14 | 139 | 28 | 82 | 48 | 57 | 44 | 71
020450 | 1 | 14 | 5 | 7 | 10 | 5 | 6 | 6 | 5
020630 | 3 | 11 | 0 | 4 | 2 | 12 | 6 | 2 | 4
020660 | 39 | 73 | 16 | 4 | 14 | 12 | 6 | 1 | 9
020695 | 7 | 3 | 13 | 10 | 3 | 6 | 5 | 6 | 4
Spreadsheet: 861734d1709575140-lookup-to-return-more-than-just-1-result-sample
Sheet: Stats

 |  |  |  | Sponsor Name | Column1
 |  |  |  | Doe, [NAME]
 |  |  |  | Doe, [NAME]
 |  |  |  | Doe, [NAME]
 |  |  |  | Doe, [NAME]
 |  |  |  | Doe, [NAME]
 |  |  |  | Doe, [NAME]
 |  |  |  | [NAME], [NAME]
 |  |  |  | [NAME], [NAME]
 |  |  |  | [NAME], [NAME]
 |  |  |  | [NAME], [NAME]
 |  |  |  | [NAME], [NAME]
 |  |  |  | [NAME], Micheal
 |  |  |  | [NAME], Micheal
 |  |  |  | [NAME], Micheal
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Vinton

School | Scholarship | Experation Date
Vinton County | The Eagle's Ladies' Auxiliary Scholarship | TBA
 | [NAME] | TBA
 | The Gill's Family Pharmacy Scholarships | TBA
 | The Harold V. Felton and [NAME] | TBA
 | The Ryan Seitz Memorial Scholarship | TBA
 | [NAME] | TBA
 | Fischer Family Scholarship | TBA
 | Ladies Auxiliary VFW Scholarship | TBA
 | [NAME] | TBA
 | SHEPPARD-DUNKLE TRUST FUND SCHOLARSHIP | TBA
 | [NAME] | TBA
 | Wampus Tribe Scholarship | TBA
 | [NAME] Memorial Scholarship | TBA
 | [NAME] | TBA
TBA: Check with Guidance Counselors for Updated Dates
Spreadsheet: 147941d1333041876-many-cells-data-into-one-cell-example-condense
Sheet: Sheet1

What I have |  |  |  |  |  |  |  | What I want
ABC 1226 | XY01224 | aaaaaaa | eeeeeee | [NAME] | sssssss |  |  | ABC 1226 | XY01224, XY01225, [NAME], XY01410, XY01411, [NAME], XY01469, XY01470 | aaaaaaa | eeeeeee | [NAME] | sssssss
ABC 1226 | XY01225 | aaaaaaa | eeeeeee | [NAME] | sssssss |  |  | ABC 1226 KIT | ZY00266 | [NAME] | tttt | dddd | vvvv
ABC 1226 | XY01226 | aaaaaaa | eeeeeee | [NAME] | sssssss |  |  | ABC 1229 | [NAME], [NAME], XY01156, XY01183, XY01184, XY01208, XY01229 | nnn | [NAME] | ggggg | bbbb
ABC 1226 | XY01410 | aaaaaaa | eeeeeee | [NAME] | sssssss
ABC 1226 | XY01411 | aaaaaaa | eeeeeee | [NAME] | sssssss
ABC 1226 | [NAME] | aaaaaaa | eeeeeee | [NAME] | sssssss
ABC 1226 | XY01469 | aaaaaaa | eeeeeee | [NAME] | sssssss
ABC 1226 | XY01470 | aaaaaaa | eeeeeee | [NAME] | sssssss
ABC 1226 KIT | ZY00266 | [NAME] | tttt | dddd | vvvv
ABC 1229 | [NAME] | nnn | [NAME] | ggggg | bbbb
ABC 1229 | XY01133 | nnn | [NAME] | ggggg | bbbb
ABC 1229 | XY01156 | nnn | [NAME] | ggggg | bbbb
ABC 1229 | XY01183 | nnn | [NAME] | ggggg | bbbb
ABC 1229 | XY01184 | nnn | [NAME] | ggggg | bbbb
ABC 1229 | XY01208 | nnn | [NAME] | ggggg | bbbb
ABC 1229 | XY01229 | nnn | [NAME] | ggggg | bbbb
ABC 1229 | XY01230 | nnn | [NAME] | ggggg | bbbb
ABC 1231 | XY01231 | s | d | g | f
ABC 1231 | XY01919 | s | d | g | f
ABC 1252 | XY01252 | m | y | i | z
ABC 1252 | XY01253 | m | y | i | z
ABC 1252 | XY01258 | m | y | i | z
ABC 1252 | XY01259 | m | y | i | z
ABC 1252 | XY01328 | m | y | i | z
ABC 1256 | XY01256 | g | h | l | p
ABC 1256 | XY01350 | g | h | l | p
ABC 1256 | XY01358 | g | h | l | p
ABC 1256 | XY01409 | g | h | l | p
ABC 1256 | XY01458 | g | h | l | p
ABC 1256 | XY01482 | g | h | l | p
ABC 1256 | XY01582 | g | h | l | p
ABC 1256 | XY01661 | g | h | l | p
ABC 1256 | XY01706 | g | h | l | p
ABC 1256 | XY01742 | g | h | l | p
ABC 1256 | XY01755 | g | h | l | p
ABC 1256 | XY01796 | g | h | l | p
ABC 1256 | XY01798 | g | h | l | p
ABC 1256 | XY01860 | g | h | l | p
ABC 1256 | XY01861 | g | h | l | p
ABC 1256 | XY01862 | g | h | l | p
ABC 1256 | XY01863 | g | h | l | p
ABC 1265 | XY01265 | r | y | i | j
ABC 1265 | XY01266 | r | y | i | j
ABC 1265 | XY01519 | r | y | i | j
ABC 1265 | XY01520 | r | y | i | j
ABC 1265 | XY01580 | r | y | i | j
ABC 1265 | XY01581 | r | y | i | j
ABC 1266 KIT | ZY00173 | u | a | r | n
ABC 1266 KIT | ZY00266 | u | a | r | n
Spreadsheet: 863592d1711017864-calculating-weighted-averages-slightly-differently-daily-completion2-1-
Sheet: Sheet2

 | Activity | % Complete | Weight | Normalized  Weight | Weighted Score
 | physical | 100 | -5
 | emotional | 0 | 0
 | financial | 50 | 0
 | professional | 0 | 3
 |  | Daily score
Spreadsheet: 70368d1271150884-lists-and-vlookup-cashbook-2010-2011
Sheet: Lists

Transaction Type | Allocation
CHQ | ADV1011p | budget header | bats | cats | rats
D/D | BE1011p | budget header | bats | cats | rats
BACS | BS1011p | Postage | Stock | Postal supplies
CC | CP1011p
S/O | CLP1011p
 | DBF10p
 | EBW0910p
 | FORD0910
 | FOX1011
 | [NAME] | Book sales | Launch event
 | MEN0910
 | NELH0910
 | NWA09
 | NWA10
 | OM0910
 | RR09
 | RR10 | Recruitment | Programme Manager | NWN Expenses | Farmers Markets | Readers Days | Read Regional Books | Author Tour | Civic Literature | Beach Reading | Airport Launch | Metro Launch | Reading Groups | Literary Salons | Reading Salons | Student Film/ Book project | Journal Supplement | Point of sale materials | NWN Management fee | Evaluation | Contingency
 | RG0910 | Berwick | Darlington | Hexham | Living Room | Middlesbrough | Poetry Room | Sunderland | [NAME] | Author events | Marketing | NWN expenses | Readers meeting
 | RHA0910
 | RUTH0910
 | SD1011
 | SE1011
 | TV0910
 | TC1011
 | [NAME]
 | [NAME] | Alnwick | [NAME] | Horsley | [NAME] | Marketing | Workshops | Author events | NWN Expenses
 | WM1011
 | YWP0910 | Workshops
 | OH1PC | Petty Cash
 | OH2SU | Volunteer expenses | Office expenses | Adjustments | Miscellaneous | Staff expenses
 | OH3TR | Director | Deputy Director | Finance & Administration Manager | Projects & Marketing Officer | IT Training | Disability Training
 | OH4IR | Director | Deputy Director | Finance & Administration Manager | Projects & Marketing Officer
 | OH5RE | Rent | Storage | Parking
 | OH6PO | Parcels | Franking machine credit | Franking machine rental | Licences/fees | Freepost | General | Franking machine misc
 | OH7HO | Director hospitality | Author hospitality | Deputy director hospitality | Refreshments
 | OH8AA | Audit and accounts | Payroll
 | OH9RR | Repairs & Renewals | Heath and Safety
 | OH10ST | General stationary | Consumables
 | OH11IT | Hardware | Software | Support & maintenance | Security
 | OH12TF | Broadband & call forwarding | Staff mobile expenses | Telephone & fax
 | OH13BC | Service charge | Credit card annual fee | Audit letter fee
 | [NAME] | Print | General marketing | Distribution | Database clean-up
 | OH15SAL | Director | Deputy Diector | Finance & Administration Manager | Projects & Marketing Office | Temporary staff
 | OH16TRS | Travel | Food | Director expenses | Per diem
 | OH17DC | Website hosting | Newsletters/e-flyers | Website updates
 | OH18PD | Project development | Research and development
 | OH19BOA | Trustee travel expenses | Room hire | Hospitalities | Miscellaneous
 | OH20INS | General office insurance | Professional indemnity insurance
Spreadsheet: 222535d1363877236-perhaps-conditional-formatting-tabs-sample-resourcing
Sheet: DES

MONTH | 2013 Actual - RFA | 2013 Actual - EHP | 2013 Actual - EHSQ | 2013 Actual - WHP | Total Days Available
December |  |  |  |  | 88
November |  |  |  |  | 84
October |  |  |  |  | 92
September |  |  |  |  | 84
August |  |  |  |  | 88
July |  |  |  |  | 92
June |  |  |  |  | 80
May |  |  |  |  | 92
April |  |  |  |  | 88
March |  |  |  |  | 84
February | 27 | 33.5 | 7 |  | 70
January | 46.5 | 34 | 4.5 |  | 91
MONTH | 2013 Forecast - RFA | 2013 Forecast - EHP | 2013 Forecast - EHSQ | 2013 Forecast - WHP | Total Days Available
December | 20 | 45 | 40 |  | 88
November | 10 | 40 | 40 |  | 84
October | 30 | 40 | 40 |  | 92
September | 50 | 45 | 40 |  | 84
August | 50 | 47 | 40 |  | 88
July | 75 | 17 | 40 |  | 92
June | 65 | 17 |  |  | 80
May | 87 | 13 |  |  | 92
April | 45 | 15 |  |  | 88
March | 48 | 18 | 6 |  | 84
February |  |  |  |  | 70
January |  |  |  |  | 91
MONTH | 2013 Combined - RFA | 2013 Combined - EHP | 2013 Combined - EHSQ | 2013 Combined - WHP | Total Days Available
December |  |  |  |  | 88
November |  |  |  |  | 84
October |  |  |  |  | 92
September |  |  |  |  | 84
August |  |  |  |  | 88
July |  |  |  |  | 92
June |  |  |  |  | 80
May |  |  |  |  | 92
April |  |  |  |  | 88
March |  |  |  |  | 84
February |  |  |  |  | 70
January |  |  |  |  | 91