tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_ring__31659__CR 458 Pricing
Sheet: Sheet1

POWER PRICING
BECO ACCOUNT PRICING
The Contract Rate, for BECO Accounts, under the GSA Contract are currently calculated based on the following:
Contract Rate = Actual Standard Offer Rate - (Contract Standard Offer Rate - (Contract Standard Offer Rate * Percentage of Standard Offer))
Actual Standard Offer Rate | -2000 | is $0.045/kwh
Contract Standard Offer Rate | -2000 | is $0.034/kwh
Percentage of Standard Offer | -2000 | is 97.30% (.9730)
Contract Rate = $0.045 - ($0.034 - ($0.034 * .9730))
Contract Rate = $0.044082/kwh
Attached is a spreadsheet that provides estimates and/or actuals for the (i) Actual Standard Offer Rate (ii) Contract Standard Offer Rate and (iii) Percentage of Standard Offer, for each calendar year 2000, 2001, 2002 and 2003.
RENEWABLE ENERGY PRICING
For 4th quarter 2000, the GSA Region 1 contract is committed to purchase at a minimum 960,000 kWh of green power with a pricing structure of 900,000 kWh at $0.055/kwh (Tier 1) and 60,000 kWh at $0.0525/kwh (Tier 2).    For 2001 calendar year, the GSA Region 1 contract is committed to purchase a minimum 4,800,00 kWh of green power at a pricing structure of 4,500,000 kWh at $0.055/kwh (Tier 1) and 300,000 kWh at $0.0525/kwh (Tier 2).    EESI will take the total volume for the period (i.e. quarterly or annual) and divide equally by the number of billing cycles (i.e. three billing cycles for the quarter and 12 billing cycles for the year).  The plan is to bill all of the renewable energy against one account that has monthly usage in excess of the flat renewable energy.  On October 1, 2000, there are two government agencies, which have officially ordered green power on their delivery orders: the GSA agency and Hanscom Air Force Base.  To allocate the distribution of kWh between Tier 1 and Tier 2 prices among any agency that currently or in the future orders green power, EESI will follow the following procedure:
For 4th quarter 2000, HAFB will be charged the Tier 1 price for 200,000 kWh each month (total volume 600,000 kWh) and Tier 2 price for 0 kWh.  The GSA agency will be charged Tier 1 price for 100,000 kWh each month (total volume 300,000 kWh) and Tier 2 price for 300,000 kWh per month (total volume 900,000 kWh).  For 2001 calendar year, HAFB will be charged the Tier 1 price for 200,000 kWh each month (total volume 2,400,000 kWh) and Tier 2 price for 0 kWh.  GSA will be charged Tier 1 price for 175,000 kWh each month (total volume 2,100,000 kWh) and [NAME] prices for 225,000 kWh per month (total volume 2,700,000 kWh).   Please Note: As Tier 1 volumes must be used before Tier 2 volumes can start, details regarding monthly usage charges can be found on the attachment (page 2). In addition, if a new agency requests renewable energy, EESO will submit a separate request to CSC indicating the appropriate rate(s) and volumes.
 | 2000 | 2001 | 2002 | 2003 | 2004
Actual Standard Offer Rate | 0.045 | 0.045 | 0.045 | 0.047 | 0.051
Contract Standard Offer Rate | 0.034 | 0.038 | 0.042 | 0.047 | 0.051
Percentage of Standard Offer | 0.973 | 0.973 | 0.965 | 0.965 | 0
Spreadsheet: 149587d1334036367-counting-dates-sample-pcr2
Sheet: Daily Summary (2)

 |  |  |  |  |  |  |  |  |  | Summary
 |  |  |  |  |  | Mar |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2012 | 一月 | 二月 | 三月 | 四月 | 五月 | 六月 | 次月 | 八月 | 九月 | 十月 | [NAME] | 十二月
Total Entries
Entries with [NAME]
 |  |  |  | Jan | Feb | Mar
 | Correct figures: | Total entries |  | 216 | 211 | 287
 |  | Entries with [NAME] |  | 193 | 203 | 281
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 15d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | - | - | - | - | - | -
Index | 4178 | 28561 | 6718 | 4537 | 8926 | 3153
Europe | - | - | 6473 | - | - | 2986
North America/Asia | 4178 | 28561 | 48 | 4537 | 8926 | 10
Other | - | - | 197 | - | - | 157
OTHER* | - | - | 18438 | - | - | 1638
TOTAL | 4178 | 28561 | 25156 | 4537 | 8926 | 4791
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 272822d1382525221-reference-the-number-of-changing-data-in-a-formula-from-pivot-table-example-workbook-v2
Sheet: Incidents_opened_this_month

Raised_To_ACN | Date_Closed | Ref | Category | Sev | Status | Description
X | X | X | SYS | X | X | X
X | X | X | CTP | X | X | X
X | X | X | EC | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | RLR | X | X | X
X | X | X | [NAME] | X | X | X
X | X | X | RLR | X | X | X
X | X | X | CTP | X | X | X
X | X | X | CTP | X | X | X
X | X | X | CTP | X | X | X
X | X | X | CTP | X | X | X
X | X | X | RLR | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | CTP | X | X | X
X | X | X | SYS | X | X | X
X | X | X | RLR | X | X | X
X | X | X | WF | X | X | X
X | X | X | WF | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | EC | X | X | X
X | X | X | CREG | X | X | X
X | X | X | WF | X | X | X
X | X | X | CTP | X | X | X
X | X | X | EC | X | X | X
X | X | X | EC | X | X | X
X | X | X | EC | X | X | X
X | X | X | RLR | X | X | X
X | X | X | WF | X | X | X
X | X | X | CTP | X | X | X
X | X | X | CTP | X | X | X
X | X | X | EC | X | X | X
X | X | X | CTP | X | X | X
X | X | X | EC | X | X | X
X | X | X | WF | X | X | X
X | X | X | EC | X | X | X
X | X | X | CTP | X | X | X
X | X | X | CTP | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | EC | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | RLR | X | X | X
X | X | X | CTP | X | X | X
X | X | X | EC | X | X | X
X | X | X | [NAME] | X | X | X
X | X | X | WF | X | X | X
X | X | X | CTP | X | X | X
X | X | X | EC | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | EC | X | X | X
X | X | X | CTP | X | X | X
X | X | X | WF | X | X | X
X | X | X | EC | X | X | X
X | X | X | SYS | X | X | X
X | X | X | CTP | X | X | X
X | X | X | CTP | X | X | X
X | X | X | EC | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | EC | X | X | X
X | X | X | CTP | X | X | X
X | X | X | CTP | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
X | X | X | [NAME] | X | X | X
X | X | X | CTP | X | X | X
X | X | X | RLR | X | X | X
X | X | X | _UNKNOWN_ | X | X | X
Spreadsheet: 102691d1300676916-index-match-fifthnpop
Sheet: Mar 10

 |  |  |  |  |  | [NAME] 10
 | Ordinary Income/Expense |  |  |  | [NAME] 10
 |  |  | Income |  | [NAME] 10
 |  |  |  | 4050 · Sales | [NAME] 10 | 42938
 |  |  | Total Income |  | [NAME] 10
 |  |  | Cost of Goods Sold |  | [NAME] 10
 |  |  |  | 5050 · Shop Supplies | [NAME] 10 | 2342
 |  |  |  | 5070 · Member Services | [NAME] 10
 |  |  |  | 5073 - Beer, Wine & Soda | [NAME] 10 | 1213
 |  |  |  | Total 5070 · Member Services | [NAME] 10
 |  |  | Total [NAME] |  | [NAME] 10
 |  | Gross Profit |  |  | [NAME] 10
 |  |  | Expense |  | [NAME] 10
 |  |  |  | 6120 · Bank Service Charges | [NAME] 10 | 234
 |  |  |  | 6135 · Credit Card Merchant Fees | [NAME] 10 | 324
 |  |  |  | 6180 · Insurance | [NAME] 10 | 56
 |  |  |  | 6240 · Miscellaneous | [NAME] 10 | 68
 |  |  |  | 6260 · Printing and Reproduction | [NAME] 10 | 234
 |  |  |  | 6290 · Rent | [NAME] 10 | 78
 |  |  |  | 6335 · Salon Supply Expenses | [NAME] 10 | 5
 |  |  |  | 6340 · Telephone | [NAME] 10 | 634
 |  |  |  | 6341 · Website Services | [NAME] 10 | 5
 |  |  |  | 6342 · Email & Internet Services | [NAME] 10 | 6
 |  |  |  | 6390 · Utilities | [NAME] 10
 |  |  |  | 6400 · Gas and Electric | [NAME] 10 | 324
 |  |  |  | 6410 · Water | [NAME] 10 | 435
 |  |  |  | 6415 · Cable | [NAME] 10 | 56
 |  |  |  | 6390 · Utilities - Other | [NAME] 10 | 21134
 |  |  |  | Total 6390 · Utilities | [NAME] 10
 |  |  |  | 6551 · Outsourced Services | [NAME] 10 | 34
 |  |  |  | 6560 · Payroll Expenses | [NAME] 10 | 67
 |  |  |  | 6685 · Security Systems | [NAME] 10 | 53245
 |  |  |  | 6820 · Taxes | [NAME] 10 | 2345
 |  |  | Total Expense |  | [NAME] 10
 | Net Ordinary Income |  |  |  | [NAME] 10
Net Income |  |  |  |  | [NAME] 10
Spreadsheet: 180755d1347737173-basic-time-card-timecardbasic
Sheet: Sheet1

Name:
Start Period: |  | 2012-09-01 00:00:00
End Period: |  | 2012-09-30 00:00:00
 |  |  | Breakfast/Lunch
Date | Day | Start | Out | In | Out | In | End | Normal | Overtime | Totals
Spreadsheet: 604929d1546859914-index-match-formula-for-duplicate-values-not-working-duplicate-index-matches
Sheet: Part Order

Part | Due
AG22155 | 2019-01-04 00:00:00
BK36701 | 2019-01-31 00:00:00
BX35640 | 2019-01-07 00:00:00
CC20434 | 2019-02-14 00:00:00
DT20254 | 2019-01-17 00:00:00
GD38853 | 2019-02-17 00:00:00
GQ18803 | 2019-02-15 00:00:00
JF34904 | 2019-01-31 00:00:00
[NAME] | 2019-02-04 00:00:00
JU13976 | 2019-02-17 00:00:00
LS18007 | 2019-01-13 00:00:00
LT21272 | 2019-01-22 00:00:00
MW33367 | 2019-02-16 00:00:00
NF34465 | 2019-02-16 00:00:00
NR26220 | 2019-02-17 00:00:00
OS14484 | 2019-02-27 00:00:00
OX17453 | 2019-02-24 00:00:00
QY34954 | 2019-02-27 00:00:00
RQ33652 | 2019-01-14 00:00:00
SE25509 | 2019-01-10 00:00:00
SG20341 | 2019-02-26 00:00:00
SI15345 | 2019-01-29 00:00:00
SP18475 | 2019-01-04 00:00:00
TB15510 | 2019-01-29 00:00:00
WA14608 | 2019-02-26 00:00:00
XA32691 | 2019-02-06 00:00:00
XJ28600 | 2019-01-17 00:00:00
XR24765 | 2019-01-28 00:00:00
YV31055 | 2019-01-23 00:00:00
ZS11542 | 2019-02-04 00:00:00
Spreadsheet: 889011d1739660360-dynamic-rows-and-columns-based-on-data-dynamic-rows-and-columns
Sheet: Lists

YEAR | DAY | FREQUENCY | Calculation
2025 | 1 | Weekly | 7
 |  | Bi-Weekly | 14
 |  | Semimonthly Day 1
 |  | Semimonthly Day 2
 |  | Monthly
Spreadsheet: 859180d1707652241-detect-repeat-multiple-values-in-a-row-and-highlight-them-based-on-number-of-repeats-review-of-incorrect-answers
Sheet: Sheet1

 | Method
 | Level
 | Paper Code
 |  | Question Number | Correct Answer | Candidates incorrect answer |  |  |  |  |  |  |  |  |  |  | Question Number | Correct Answer | Candidates incorrect answer
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | 1 | A | b | b | b | c | b | b | b | a | a | a |  | 21
 |  | 2 | B | a | a | a | a | a | a | a | a | a | a |  | 22
 |  | 3 | c | b | b | b | b | b | b | b | b | b | b |  | 23
 |  | 4 | D |  |  |  |  |  |  |  |  |  |  |  | 24
 |  | 5 | E |  |  |  |  |  |  |  |  |  |  |  | 25
 |  | 6 | A |  |  |  |  |  |  |  |  |  |  |  | 26
 |  | 7 | B |  |  |  |  |  |  |  |  |  |  |  | 27
 |  | 8 | c |  |  |  |  |  |  |  |  |  |  |  | 28
 |  | 9 | D |  |  |  |  |  |  |  |  |  |  |  | 29
 |  | 10 | E |  |  |  |  |  |  |  |  |  |  |  | 30
 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  | 40
Spreadsheet: 124225d1318259427-excel-2007-forumating-from-drop-down-boxes-domestic-quote-generator-master-rev-qq
Sheet: Elec-Mec Controls

ELECTRIAL CONTROLS |  |  |  |  |  |  |  |  | MECHANICAL CONTROLS
 | Price | SL No | Notes | Total | Value | Labour | Total Labour |  |  | Price | SL No | Notes | Total | Value | Labour | Total Labour
Programmer | 0 |  |  |  |  |  |  |  | Valve
Room Stat | 0
Y Plan Control Kit | 0
S Plan Control Kit | 0
 |  |  |  |  | Total |  |  |  |  |  |  |  | Total
Spreadsheet: 108927d1305843195-index-and-match-matching-with-one-more-item-item-a-and-b-account-manager-mutual-fund-sales
Sheet: Summary

 | Desired Result
Summary
 | [NAME] Mutual fund Others YTD ($) | Long term mutual fundMIP YTD (volume)
[NAME] | 10999 | 95
[NAME] | 9888 | 0
[NAME] | 14000 | 110
[NAME] | 0 | 0
[NAME] weatherhead | 11800 | 199
Calculation method:
As there is Long term mutual fund with MIP, Column C of this page is equal to Sheet"table" column K plus M
As there is Long term mutual fund with other, Column B of this page is equal to Sheet"table" column L plus N
For example, using [NAME]
 | [NAME] Mutual fund Others YTD ($) | Long term mutual fundMIP YTD (volume)
[NAME] | 10999 | 95
Spreadsheet: 158274d1338135985-combine-sum-sheets-and-make-a-summary-into-another-sheet-sumif-across-sheets
Sheet: c

Sheet C
March
name | desc | qty
cris | 2 a a | 5
cris | 2 a v | 6
cris | 3 a g | 4
cris | 3 a g | 2
cris | 5 h j | 4
cris | 2 y r | 5
 | Total
 | total Rows
Spreadsheet: 136650d1326758851-formulae-to-copy-horizontally-vertical-values-from-another-sheet-book1
Sheet: Sheet

Month | Date | Invoice # | % of Month | Labour | Materials | Services | ODC | Other Lines | Sales Price
October | 2011-10-14 00:00:00 | 10038 | 1
October | 2011-10-28 00:00:00 | 10039 | 1
November | 2011-11-11 00:00:00 | 10040 | 1
November | 2011-11-22 00:00:00 | 10041 | 1
December | 2011-12-09 00:00:00 | 10042 | 1
December | 2011-12-15 00:00:00 | 10043 | 1
October | 2011-10-14 00:00:00 | 38964 | 1
October | 2011-10-14 00:00:00 | 38965 | 1
October | 2011-10-28 00:00:00 | 38966 | 1
October | 2011-10-28 00:00:00 | 38967 | 1
November | 2011-11-11 00:00:00 | 38968 | 1
November | 2011-11-11 00:00:00 | 38969 | 1
November | 2011-11-22 00:00:00 | 38970 | 1
November | 2011-11-22 00:00:00 | 38971 | 1
November | 2011-11-24 00:00:00 | 38972 | 1
December | 2011-12-09 00:00:00 | 38973 | 1
December | 2011-12-09 00:00:00 | 38974 | 1
December | 2011-12-15 00:00:00 | 38975 | 1
December | 2011-12-15 00:00:00 | 38976 | 1
December | 2011-12-30 00:00:00 | 38977 | 1
Spreadsheet: 163964d1340576884-create-a-prizepool-counting-formula-mre000000-award-prizes-with-ties
Sheet: Sheet1

Name | Score | Place | Prize |  | Places | Prizes
[NAME] | 250 |  |  |  | 1 | 1000
Barb | 250 |  |  |  | 2 | 900
Cain | 250 |  |  |  | 3 | 800
[NAME] | 249 |  |  |  | 4 | 700
[NAME] | 249 |  |  |  | 5 | 600
Fran | 249 |  |  |  | 6 | 500
[NAME] | 249 |  |  |  | 7 | 400
Hana | 248 |  |  |  | 8 | 300
[NAME] | 248 |  |  |  | 9 | 200
[NAME] | 247 |  |  |  | 10 | 100
Kent | 247
Leah | 247
Mark | 247
Nina | 247
Spreadsheet: 152491d1335406763-organizing-excel-information-into-multiple-lines-ex1
Sheet: Sheet1

2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00 |  |  |  |  | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00
[NAME] smith | [NAME] | [NAME] |  |  |  |  | [NAME] smith |  | [NAME]
[NAME] | [NAME] | wane smith |  |  | Should turn into: |  | [NAME] | [NAME] | [NAME]
[NAME] | mr smith | [NAME] |  |  |  |  | [NAME] | [NAME]
[NAME] | something smith | [NAME] |  |  |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] |  |  |  |  |  | something smith | something smith
 |  | something smith |  |  |  |  |  | mr smith
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | wane smith
Spreadsheet: 864869d1711999774-weighted-average-formula-excluding-zeros-weighted-average-excluding-zeros
Sheet: Sheet1

10+ | 7 - 9 | 4 - 6 | 3 | 2 | 1 | Less than 1 | 10+ | 7 - 9 | 4 - 6 | 3 | 2 | 1 | Less than 1 | WEIGHTED AVERAGE BY ASSET
 |  |  |  |  |  |  | 0.6 | 0.6 | 1.8 | 0.6 | 1.4 | 2.8 | 1.6
0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0.6 | 1.4 | 1.4
 |  |  |  |  |  |  | 0.2 | 0.2 | 1.4 | 2.2 | 4 | 6.4 | 5.8
 |  |  |  |  |  |  | 1.4 | 0.8 | 5.6 | 3.6 | 5.6 | 15.8 | 11.2
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 2.4 | 1.8
 |  |  |  |  |  |  | 0.2 | 0.6 | 0.4 | 1.4 | 1 | 3 | 0.6
 |  |  |  |  |  |  | 1.4 | 1 | 6.4 | 3.2 | 3.6 | 10.6 | 9.8
Spreadsheet: 706859d1606926075-urgent-formula-to-get-cell-value-on-top-test1
Sheet: Sheet1

Name | Months | Div | Need it to be like this
[NAME] | 1 | N1
[NAME] | 2
[NAME] | 3 |  | Months 2, 3 need to be N1
[NAME] | 4 | N3
[NAME] | 5
[NAME] | 6
[NAME] | 7 |  | Months 5, 6, 7 need to be N3
[NAME] | 8 | M5
[NAME] | 9
[NAME] | 10
[NAME] | 11 | X1 | Months 10, 9 need to be M5
[NAME] | 12 |  | There is no record please leave it empty
Mark | 1
Mark | 2
Mark | 3
Mark | 4
Mark | 5
Mark | 6
Mark | 7 | V1 | Months 1-6 need to be V1
Mark | 8 |  | There is no record please leave it empty
Mark | 9 |  | There is no record please leave it empty
Mark | 10 |  | There is no record please leave it empty
Mark | 11 |  | There is no record please leave it empty
Mark | 12 |  | There is no record please leave it empty
Spreadsheet: 04a1db23-1dcd-458b-bd45-8d3f38bd5019
Sheet: Application

District/Charter | School | [NAME] (Small: 4-160 K-3 students; Medium: 161-549 K-3 students; Large: 550-1,000 K-3 students) | Program requested (Istation; Imagine Learning; Waterford ERP; i-Ready; SuccessMaker) | # [NAME] classrooms | # grade 1 classrooms | Applying for grades 2 and 3?                Y/N | # grade 2 classrooms | # of grade 3 classrooms | Principal supports program? Y/N | Teachers support program? Y/N | Technology available to implement? Y/N
Example: LDD District | Lion School | Medium | [NAME] | 6 | 6 | Y | 3 | 9 | Y | Y | Y
Spreadsheet: 833398d1686934002-sum-values-each-row-dynamic-arrays-return-spilling-column-sumrow-aligw
Sheet: Feuil1

IGNORE
A | B | C |  | A | B | C |  | total of row, spilling, expected result
0 | 1 | 0 |  |  | 1 | 0
0 | 1 | 0 |  | 0 | 1 | 0 |  | 1
0 | 1 | 1 |  | 0 | 1 | 1 |  | 2
1 | 0 | 0 |  | 1 | 0 | 0 |  | 1
0 | 1 | 0 |  | 0 | 1 | 0 |  | 1
0 | 0 | 0 |  | 0 | 0 | 0 |  | 0
1 | 0 | 0 |  | 1 | 0 | 0 |  | 1
1 | 0 | 0 |  | 1 | 0 | 0 |  | 1
0 | 0 | 1 |  | 0 | 0 | 1 |  | 1
1 | 0 | 1 |  | 1 | 0 | 1 |  | 2
Spreadsheet: 29454d1224494681-sumif-calculation-sample
Sheet: Sheet2

Pivot Table | 4 | 3 | 2 | 1
Humpty Dumpty | 1 | 2 | 3 | 4
Humpty Dumpty | 1 | 2 | 3 | 4
Humpty Dumpty | 1 | 2 | 3 | 4
Humpty Dumpty | 1 | 2 | 3 | 4
Humpty Dumpty | 1 | 2 | 3 | 4
[NAME] | 1 | 2 | 3 | 4
[NAME] | 1 | 2 | 3 | 4
[NAME] | 1 | 2 | 3 | 4
[NAME] | 1 | 2 | 3 | 4
[NAME] | 1 | 2 | 3 | 4
[NAME] | 1 | 2 | 3 | 4
[NAME] | 1 | 2 | 3 | 4
Spreadsheet: 38517d1236687293-choose-ytd-and-month-figures-test
Sheet: P&L 

Profit & Loss Account
 |  |  |  |  |  | Year to date |  |  | Full Year
 |  | Nominal lookup | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Budget | Forecast
Income
Sales
Parts
Labour
MOT
Sundries
Direct Costs
Parts
MOT
Consumables
Waste removal
Customer petrol
Carriage
Indirect Costs
Salaries
General Management
Finance
Depreciation
Profit/(Loss)
Notes & Commentary
Commentary based on budget version 19jan09
Spreadsheet: 732854d1621273396-compare-two-lists-and-generate-a-new-list-with-what-is-different-from-the-first-list-sample-file
Sheet: Sheet1

Bid History List |  |  |  |  | Pasted List from New Bid Tab |  |  |  | Names contained in Pasted List NOT on history list
LM NO. | EMPLOYEE | JOB HELD | DATE |  | LM NO. | EMPLOYEE | JOB HELD |  | LM NO. | EMPLOYEE | JOB HELD
154 | [NAME] | GW | 2020-08-16 00:00:00 |  | 154 | [NAME] | GW
410 | [NAME] | GW | 2021-03-28 00:00:00 |  | 154 | [NAME] | GW
565 | [NAME] 3 | GW | 2020-01-12 00:00:00 |  | 154 | [NAME] | GW
963 | [NAME] 4 | GW | 2020-01-12 00:00:00 |  | 980 | [NAME] 10 | GW
944 | [NAME] | GW | 2020-01-12 00:00:00 |  | 980 | [NAME] 10 | FR DMG RCP
542 | [NAME] 6 | GW | 2020-01-12 00:00:00 |  | 980 | [NAME] 10 | GW
247 | [NAME] 7 | GW | 2020-10-18 00:00:00 |  | 187 | [NAME] 11 | GW
422 | [NAME] 8 | JAN | 2020-01-12 00:00:00 |  | 187 | [NAME] 11 | DMG RCP
71 | [NAME] 9 | GW | 2021-02-14 00:00:00 |  | 336 | [NAME] 12 | GW
980 | [NAME] 10 | GW | 2020-01-12 00:00:00 |  | 336 | [NAME] 12 | FR DMG RCP
187 | [NAME] 11 | GW | 2020-10-04 00:00:00 |  | 337 | [NAME] 13 | GW
336 | [NAME] 12 | GW | 2020-01-12 00:00:00 |  | 337 | [NAME] 13 | DMG RCP
337 | [NAME] 13 | TRAINER | 2020-01-12 00:00:00 |  | 337 | [NAME] 13 | GW
337 | [NAME] 13 | GW | 2020-02-09 00:00:00 |  | 410 | [NAME] | GW
337 | [NAME] 13 | LIFT | 2021-01-10 00:00:00 |  | 565 | [NAME] 3 | JAN
415 | [NAME] 14 | LIFT | 2020-01-12 00:00:00 |  | 963 | [NAME] 4 | GW
312 | [NAME] 15 | GW | 2020-01-12 00:00:00 |  | 944 | [NAME] | GW
312 | [NAME] 15 | FR LIFT | 2020-05-10 00:00:00 |  | 542 | [NAME] 6 | GW
154 | [NAME] | GW | 2020-01-12 00:00:00 |  | 542 | [NAME] 6 | GW
410 | [NAME] | GW | 2020-01-12 00:00:00 |  | 542 | [NAME] 6 | JAN
565 | [NAME] 3 | GW | 2020-01-12 00:00:00 |  | 247 | [NAME] 7 | GW
963 | [NAME] 4 | GW | 2020-01-12 00:00:00 |  | 247 | [NAME] 7 | GW
944 | [NAME] | GW | 2020-01-12 00:00:00 |  | 422 | [NAME] 8 | GW
542 | [NAME] 6 | GW | 2020-01-12 00:00:00 |  | 422 | [NAME] 8 | GW
247 | [NAME] 7 | GW | 2020-01-12 00:00:00 |  | 422 | [NAME] 8 | GW
422 | [NAME] 8 | JAN | 2020-01-12 00:00:00 |  | 71 | [NAME] 9 | JAN
71 | [NAME] 9 | GW | 2020-01-12 00:00:00 |  | 71 | [NAME] 9 | GW
980 | [NAME] 10 | GW | 2020-01-12 00:00:00
187 | [NAME] 11 | GW | 2020-01-12 00:00:00
336 | [NAME] 12 | GW | 2020-01-12 00:00:00
337 | [NAME] 13 | TRAINER | 2020-01-12 00:00:00
337 | [NAME] 13 | GW | 2020-01-12 00:00:00
337 | [NAME] 13 | LIFT | 2020-01-12 00:00:00
415 | [NAME] 14 | LIFT | 2020-01-12 00:00:00
312 | [NAME] 15 | GW | 2020-01-12 00:00:00
312 | [NAME] 15 | FR LIFT | 2020-01-12 00:00:00
Spreadsheet: 74320d1274866409-count-data-entry-in-continuous-cells-black-example
Sheet: Sheet1

Count | 2010-05-17 00:00:00 | 10 May 2010 | 03 May 2010 | 26 Apr 2010 | 19 Apr 2010 | 12 Apr 2010 | 05 Apr 2010 | 29 Mar 2010 | 22 Mar 2010 | 15 Mar 2010 | 08 Mar 2010 | 01 Mar 2010 | 22 Feb 2010 | 15 Feb 2010 | 08 Feb 2010 | 01 Feb 2010 | 25 Jan 2010 | 18 Jan 2010 | 11 Jan 2010 | 04 Jan 2010 | 28 Dec 2009 | 07 Dec 2009
1 |  |  |  |  |  |  |  |  | Black | Black | Black
2 |  |  |  |  |  | Black | Black | Black |  |  |  |  |  |  |  |  |  |  | Black | Black | Black
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Black | Black | Black
3 |  |  |  | Black |  | Black | Black | Black | Black |  | Black |  | Black | Black | Black |  |  | Black | Black | Black
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Black | Black | Black
2 |  |  |  |  | Black | Black | Black | Black | Black | Black |  |  |  |  | Black | Black | Black
Spreadsheet: 823398d1679944706-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-sample
Sheet: Resources - YYYY

 | RESOURCES |  | MONTHLY ALLOCATION
 | Name | Unit Amount | 2023-01-01 00:00:00 |  | 2023-02-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2023-04-01 00:00:00 |  | 2023-05-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00
 |  |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS
 |  | 500 | 1 | 1.2
 |  | 0 | 1 | 1.3
 |  | 0 | 2 | 2.4
 |  | 500 | 1 | 1.3
 |  | 0 | 1 | 1.2
 |  | 500 | 1 | 1.3
 |  |  | 1 | 1.2
 |  |  | 1 | 1.3
 |  |  | 0.5 | 0.7
 |  |  | 1 | 1.3
 | TOTAL HEADCOUNT
 |  | Total x, UA