tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28edd9bb-ba73-4940-8e20-af1b7e7cbb1e
Sheet: Detention Vault

[NAME]
These calculators size a detention vault to treat the Water Quality Volume (WQv), or calculate the volume of water treated given user entered available dimensions.
CALCULATOR
Detention Vault Calculator - by Water Quality Volume
1 | Water Quality Volume - WQv |  |  | [NAME]
2 | Available Live Storage Depth |  |  | feet (typically between 3 and 7 ft)
3 | Length to [NAME] (L/W) |  |  | typically between 2 and 4
4 | Length |  |  | feet
 | [NAME] |  |  | feet
5 | Drain Time | 48 |  | hrs (recommend 48 hrs)
6 | Ave. [NAME] for Drain Time |  |  | gpm
 | Estimated Imp. Drainage Area |  |  | ft2
 | Sizing Ratio (BMP/DMA)
Detention Vault Calculator - by Available Area
7 | Available Base Area |  |  | square feet
8 | Design Live Storage Depth |  |  | feet
9 | Treated Volume |  |  | [NAME]
INSTRUCTIONS
Use either steps 1 through 6 to determine the required dimensions of the vault. Or use steps 7 through 9 to check what volume of water is treated given the available area for a vault.
Step
To Determine The Required Dimensions for the Vault
1 | Enter the Water Quality Volume (WQv) for the drainage management area (DMA). The WQv is calculated in Step 14 of the Water Quality Volume and Water Quality Flow Rate Calculator.
2 | Enter the proposed live storage depth of the vault. This is typically between 3 to 7 feet not including freeboard. This depth also does not include the depth of the permanent wet pool. It is recommended that the wet pool depth be greater than 3 feet.
3 | Enter the proposed length to width ratio of the vault.  A ratio > 2:1 is preferred.  A 2:1 ratio should be entered as "2", a 3:1 as "3", etc.
4 | The length and width of the vault are calculated.
5 | Enter the drawdown time for the vault (48 hrs is recommended).
6 | The average discharge rate from the vault to obtain the desired drain time is calculated. During design, outlet controls must be sized accordingly to achieve the desired WQv drain time.
To Determine the Volume of Water Treated by an Available Area
7 | Enter the available area to install the vault (base area).
8 | Enter the proposed live storage depth of the vault. Generally 5 feet not including freeboard.
9 | The volume of water treated by the proposed detention vault is shown here. If this volume is less than the required WQv then additional treatments will likely be required.
DEFINITIONS
 | Water Quality Volume (WQv) | The runoff volume to be managed by the stormwater BMP such that treatment requirements are met. The WQv is calculated by the Water Quality Volume and Water Quality Flow Rate Calculator.
 | Live Storage Depth | The depth of water storage in the vault.  Does not include freeboard or depth of permanent pool.
 | Length | The longitudinal length of the vault
 | [NAME] | The width of the vault
 | Base Area | The area of the base of the vault
 | Drain Time (t) | The time for the storage area to drain the water quality volume.
Spreadsheet: 868297d1715017778-time-punch-record-reformatting-vertical-into-horizontal-bonus-weeks-worked-nam-machine-sample-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Emp Name | Date | Hours Worked | Type |  |  |  |  |  | Name | Date | 1st Hours Amt | 2nd Hours Amt | 3rd Clock In
[NAME] | 2018-02-01 00:00:00 | 5 | Regular |  |  |  |  |  | [NAME] | 2018-02-01 00:00:00 | 5 | 3
[NAME] | 2018-02-01 00:00:00 | 3 | Regular |  |  |  |  |  | [NAME] | 2018-02-02 00:00:00 | 5 | 3
[NAME] | 2018-02-02 00:00:00 | 5 | Regular |  |  |  |  |  | [NAME] | 2018-02-05 00:00:00 | 5 | 3
[NAME] | 2018-02-02 00:00:00 | 3 | Regular |  |  |  |  |  | [NAME] | 2018-02-06 00:00:00 | 5 | 3
[NAME] | 2018-02-05 00:00:00 | 5 | Regular |  |  |  |  |  | [NAME] | 2018-02-07 00:00:00 | 5 | 3
[NAME] | 2018-02-05 00:00:00 | 3 | Regular |  |  |  |  |  | [NAME] | 2018-02-08 00:00:00 | 5 | 3
[NAME] | 2018-02-06 00:00:00 | 5 | Regular |  |  |  |  |  | [NAME] | 2018-02-09 00:00:00 | 5 | 3
[NAME] | 2018-02-06 00:00:00 | 3 | Regular |  |  |  |  |  | [NAME] | 2018-02-12 00:00:00 | 5 | 3 | 1
[NAME] | 2018-02-07 00:00:00 | 5 | Regular |  |  |  |  |  | [NAME] | 2018-02-13 00:00:00 | 5 | 3 | 1
[NAME] | 2018-02-07 00:00:00 | 3 | Regular |  |  |  |  |  | [NAME] | 2018-02-14 00:00:00 | 5 | 3
[NAME] | 2018-02-08 00:00:00 | 5 | Regular
[NAME] | 2018-02-08 00:00:00 | 3 | Regular
[NAME] | 2018-02-09 00:00:00 | 5 | Regular
[NAME] | 2018-02-09 00:00:00 | 3 | Regular
[NAME] | 2018-02-12 00:00:00 | 5 | Regular
[NAME] | 2018-02-12 00:00:00 | 3 | Regular
[NAME] | 2018-02-12 00:00:00 | 1 | OT 1.5
[NAME] | 2018-02-13 00:00:00 | 5 | Regular
[NAME] | 2018-02-13 00:00:00 | 3 | Regular
[NAME] | 2018-02-13 00:00:00 | 1 | OT 1.5
[NAME] | 2018-02-14 00:00:00 | 5 | Regular
[NAME] | 2018-02-14 00:00:00 | 3 | Regular
[NAME] | 2018-02-14 00:00:00 | 1 | OT 1.5
[NAME] | 2018-02-15 00:00:00 | 5 | Regular
[NAME] | 2018-02-15 00:00:00 | 3 | Regular
[NAME] | 2018-02-15 00:00:00 | 1 | OT 1.5
[NAME] | 2018-02-16 00:00:00 | 4 | Regular
[NAME] | 2018-02-20 00:00:00 | 3 | Regular
[NAME] | 2018-02-20 00:00:00 | 5 | Regular
[NAME] | 2018-02-21 00:00:00 | 5 | Regular
[NAME] | 2018-02-21 00:00:00 | 3 | Regular
[NAME] | 2018-02-22 00:00:00 | 5 | Regular
[NAME] | 2018-02-22 00:00:00 | 3 | Regular
[NAME] | 2018-02-23 00:00:00 | 5 | Regular
[NAME] | 2018-02-23 00:00:00 | 2 | Regular
[NAME] | 2018-02-26 00:00:00 | 5 | Regular
[NAME] | 2018-02-26 00:00:00 | 3 | Regular
[NAME] | 2018-02-27 00:00:00 | 3 | Regular
[NAME] | 2018-02-27 00:00:00 | 5 | Regular
[NAME] | 2018-02-28 00:00:00 | 5 | Regular
[NAME] | 2018-02-28 00:00:00 | 3 | Regular
[NAME] | 2018-02-28 00:00:00 | 1 | OT 1.5
[NAME] | 2018-03-01 00:00:00 | 3 | Regular
[NAME] | 2018-03-01 00:00:00 | 5 | Regular
[NAME] | 2018-03-02 00:00:00 | 5 | Regular
[NAME] | 2018-03-02 00:00:00 | 3 | Regular
Spreadsheet: 220867d1363285734-making-fully-automated-spreadsheet-big-excel-for-forum-help-updated
Sheet: Site Expenses

Site ID |  | CV305 | CV309 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PO # |  | 22 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Description |  | Civil | Tower | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PO Amount |  | 200 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sub Accepted Price |  | 20 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Materials
Home Depot CC
Hotels
Crane
[NAME].
Transportation
Expense Report
Petty Cash
Labor Cost
Change Orders
Gross Profit With 5% Material Mark Up
% Profit
Spreadsheet: 790739d1659968772-formula-for-totals-across-multiple-tabs-game-scores
Sheet: Totals

Name | Total Games Played | Total Full Time Different to Half Time
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: e5533742-5f43-481e-8b32-68ceab193052
Sheet: Standard Health Coverage Plans

Standard Health Coverage Plans
 | 1
Plan Code or Name | Plan Type (HMO,POS, PPO, Indemnity) | PCP Office Visit Copay1 | Specialist Office Visit Copay1 | [NAME] | Outpatient Surgery Copay1 | Inpatient Copay1 | In-Network Single Deductible | In-Network Coinsurance2 | In-Network Single OOP Max3 | Does  Deductible apply to all Medical Services?  (Y/N) | Note Services that Deductible does not apply to. | Does  Deductible apply to Pharmacy Services? (Y/N) | Are Preventive Services Covered 100%? (Y/N) | Does this plan provide for coverage for MH/SA? (Y/N) | Does this plan have a Tiered Network component? (Y/N) | Retail Pharmacy Single Deductible Generic | Retail Pharmacy Single Deductible Brand Formulary | Retail Pharmacy Single Deductible Brand Non-Formulary | [NAME] [NAME] | Retail Pharmacy Copay Brand Formulary | Retail Pharmacy Copay Brand Non-Formulary
Standard Health Coverage Plan- 1 | Indemnity | subject to ded & coin | subject to ded & coin | subject to ded & coin | subject to ded & coin | subject to ded & coin | 250 | 0.2 | 650 | Y | N/A | N | N | Y | N | N/A | N/A | N/A | 5 | 10 | 25
Standard Health Coverage Plan- 2 | PPO | 10 | 10 | 50 | 0 | 0 | N/A | N/A | N/A | N | N/A | N/A | Y | Y | N | N/A | N/A | N/A | 5 | 10 | 25
Standard Health Coverage Plan- 3 | POS | 10 | 10 | 50 | 0 | 0 | N/A | N/A | N/A | N | N/A | N/A | Y | Y | N | N/A | N/A | N/A | 5 | 10 | 25
Standard Health Coverage Plan- 4 | HMO | 10 | 10 | 50 | 0 | 0 | N/A | N/A | N/A | N | N/A | N/A | Y | Y | N | N/A | N/A | N/A | 5 | 10 | 25
Spreadsheet: 9e58d402-f7ba-4200-b3a0-ac397146c679
Sheet: FinReview

 | CDN: |  |  |  | Charter Name:
 | Category 1. Student-to-Staff Ratio Outside Norm or Declining |  | 2011-2012 Estimate | 2010-2011 Actual |  |  |  |  | Comments
 | Enrollment
 | WADA
 | All Staff FTE
 |  |  | 2011-2012 Estimate | 2010-2011 Actual | Average per Group |  | Indicator Description | Indicator
 | a. WADA-to-All-Staff-FTE Ratio |  |  |  |  |  | < 70% of group avg
 | [NAME]-to-All-Staff-FTE Ratio |  |  |  |  |  | < group avg and decline of more than 10% from prior year
 | Category 2. General Fund Expenditures Exceeding Revenues |  | 2011-2012 Amount | 2010-2011 Actual Amount | 2010-2011 Budget Amount | Suggested Difference | 2009-2010 Actual Amount | 2009-2010 Budget Amount | Comments
 | Payroll
 | Object codes 6110-6149
 | Contract Costs
 | Object code series 6200
 | Supplies and Materials
 | Object code series 6300
 | Other Operating
 | Object code series 6400
 | Debt Service
 | Object code series 6500
 | Capital Outlay
 | Object code series 1500
 | Total Expenditures
 | a. Expenditures** exceed revenues by more than 8%.
 | [NAME] exceed revenues by more than 6% and exceeded revenues by more than 4% in the prior year.
 | [NAME] exceed revenues by more than 5%, and the charter school has a prior year end-of-year net working capital balance* that has declined from the year before by more than 20% and that is less than 4% of general fund expenditures for the school.
 | Category 3. Declining or Low Net Working Capital Balance*
 | Total Revenues
 | Net Working Capital Balance
 |  |  |  |  |  |  |  |  | Additional Questions
 | a. Prior year end-of-year net working capital balance declined from the year before by more than 50%, and the net working capital balance is less than 6% of the general fund expenditures for the charter school. |  |  |  |  |  |  |  | Did your charter school borrow funds to pay for operating expenses and not repay the funds within 12 months from the time they were borrowed within the last two years?
 | b. Prior year end-of-year net working capital balance is less than 1% of the general fund expenditures for the charter school. |  |  |  |  |  |  |  | Has your charter school declared bankruptcy within the past two years?
 |  |  |  |  |  |  |  |  | How many executive directors/superintendents has your charter school had in the last three years?
 | At least one "Declining or Low Net Working Capital Balance" "Yes" indicator and one other "Yes" indicator: |  |  |  |  |  |  |  | How many business managers has your charter school had in the last three years?
 | Net working capital balance less than 1% of general fund expenditures: |  |  |  |  |  |  |  | Eligible to be considered for additional review?
 | * The net working capital balance (equivalent to a school district's general fund assigned and unassigned fund balance) is defined as current assets minus current liabilities.
 | ** For charter schools, general fund expenditures do not include depreciation expenses.
Spreadsheet: 241574d1370639703-totals-help-core
Sheet: Orders-Income

Order Date | Reference | Customer Name | [NAME] | Address | Telephone | Item | [NAME] | Size | Print | Print Colour | Print Position | Price | Fees | Stock Order Date | Stock Received | Design Cut | Printed | Dispatch Date | Dispatch Reference | Postage Paid
2013-06-07 00:00:00 | ASP0001 | [NAME] | [EMAIL] |  |  | Tshirt | Black | M | Cross | Red | Left Chest | 18.99 |  | 2013-06-07 00:00:00
 |  |  |  |  |  | Tshirt | Black | M | Cross | Purple | Left Chest | 18.99 |  | 2013-06-07 00:00:00
 |  |  |  |  |  | Tshirt | Black | M | Cross | Blue | Left Chest | 18.99 |  | 2013-06-07 00:00:00
 |  |  |  |  |  | Postage |  |  |  |  |  | 5.87 |  | 2013-06-07 00:00:00
 |  |  |  |  |  | Fees |  |  |  |  |  |  | -2.69
2013-06-07 00:00:00 | [NAME] | [NAME] | [EMAIL] |  |  | Shirt | Red | L | Custom | Black | Centre Chest | 21.99
 |  |  |  |  |  | Postage |  |  |  |  |  | 3.65
 |  |  |  |  |  | Fees |  |  |  |  |  |  | -0.75
Spreadsheet: sally_beck__33985__Weekly Operating Report 4-4 - Revised
Sheet: template from individuals

 | JANUARY
 | week ending 4 |  | week ending 11 |  | week ending 18 |  | week ending 25
New Deals for | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
Financial
ENA
Gas (Calgary) | 184 | 20 | 204 | 25 | 159 | 27 | 227 | 43
Gas (Houston)
Power (Houston) | 24 | 38 | 57 | 114 | 68 | 79 | 1463 | 2294
Power (Calgary) |  |  | 6 | 5 | 34 | 10 | 51 | 16
EIM
Lumber | 0 | 23 | 0 | 7 | 0 | 10 | 0 | 19
Newsprint | 0 | 2 | 2 | 0 | 0 | 2 | 0 | 2
Pulp (recycled paper) | 0 | 1 | 0 | 4 | 0 | 12 | 0 | 10
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EGM
IR/FX
Weather
Liquids | 818 | 98 | 1525 | 230 | 1025 | 134 | 1525 | 158
Emissions
Physical
ENA
Gas (Houston) | 5224 | 1151
Gas (Calgary) | 573 | 388 | 778 | 473 | 778 | 304 | 1013 | 436
Power (Houston) | 633 | 1263 | 1573 | 2577 | 1657 | 2093 | 83 | 139
Power (Calgary) |  | 9 |  | 23 |  | 22 |  | 10
EIM
Lumber | 1 | 62 | 12 | 107 | 10 | 83 | 2 | 103
Newsprint | 0 | 3 | 0 | 15 | 1 | 6 | 0 | 22
Pulp (recycled paper) | 4 | 1 | 3 | 10 | 0 | 12 | 0 | 9
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EGM
Liquids | 22 | 93 | 55 | 226 | 26 | 115 | 19 | 141
Coal
 | week ending 4 |  | week ending 11 |  | week ending 18 |  | week ending 25
Total EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
ENA
Gas | 8160 | 1993 | 12264 | 3200 | 10083 | 2671 | 13198 | 3425
Power | 657 | 1073 | 1630 | 1806 | 1725 | 2056 | 1546 | 2149
EIM |  | 29 |  | 33 |  | 31 |  | 53
Lumber | 4 |  | 9 |  | 4 |  | 2
Newsprint
Pulp (recycled paper) |  | 0 | 4 | 0 | 1 | 0 |  | 0
Steel
EGM
IR/FX | 0 | 91 |  | 130 |  | 103 |  | 169
Weather | 9 | 4 | 8 | 19 | 26 | 11 | 13 | 23
Liquids | 840 | 995 | 1580 | 1678 | 1052 | 1147 | 1552 | 1511
Emissions | 2 | 0 | 2 | 0 | 10 | 4 | 4 | 9
Coal | 29 | 23 | 36 | 47 | 32 | 52 | 17 | 58
Total Manual
ENA
Gas
Power
EIM
Lumber
Newsprint
Pulp (recycled paper)
Steel
EGM
IR/FX
Weather
Liquids
Emissions
Coal
EOL Manual compare | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
ENA
Gas
Power
EIM
Lumber
Newsprint
Pulp (recycled paper)
Steel
EGM
IR/FX
Weather
Liquids
Emissions
Coal
Spreadsheet: 135598d1326133923-excel-2007-conditional-formatting-doesnt-print-in-color-which-is-what-i-want-shows-up-in-b-and-w-sample-workbook
Sheet: 2 FSE - CHART INFO

CHART 1 INFO
Task Orders | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
Awarded | 6 | 2 | 3
Completed | 3 | 3 | 6
In Construction | 18 | 17 | 14
In Design & Solicitation | 18 | 19 | 15
Pending | 18 | 18 | 18
CHART 2 (In Construction) TOTALS
Task Orders | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
Service
Program Dev
FRS
Other
NEW CONTRACT
AMICO - TASK ORDERS IN CONSTRUCTION & COMPLETED TASK ORDERS
Task Orders | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
Service | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Program Dev | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FRS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AMBERT - TASK ORDERS IN CONSTRUCTION & COMPLETED TASK ORDERS
Task Orders | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
Service | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Program Dev | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FRS | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other | 2 | 3 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JANLI - TASK ORDERS IN CONSTRUCTION & COMPLETED TASK ORDERS
Task Orders | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
Service | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Program Dev | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FRS | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FUTURA - TASK ORDERS IN CONSTRUCTION & COMPLETED TASK ORDERS
Task Orders | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
Service | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Program Dev | 5 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FRS | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CHART 3   (TO's AWARDED)
 | Rotational | Competed | Total
AMICO | 0 | 0
[NAME] | 0 | 3
JANLI | 0 | 0
FUTURA | 0 | 0
Total
Spreadsheet: 297360d1392366974-list-of-top-five-gross-profits-top-5
Sheet: Sheet1

 | Company | Gross Profit
 | Barclays | 16000000 |  | TOP 5 | Name | GP
 | Centrica | 14000000 |  | 1
 | BT | 14000000 |  | 2
 | Santander | 12000000 |  | 3
 | Sky | 10000000 |  | 4
 | McDonalds | 10000000 |  | 5
 | Burger King | 2000000
 | HSBC | -400000
 | Northern Rock | -4000000
Spreadsheet: a8d7ba55-ca42-4caa-ab1f-4ae3b090c169
Sheet: Sheet1

GENERAL | 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
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | CMAQ-3301(469) Agreement |  |  |  | To authorize execution of  a CMAQ agreement for
 |  |  |  |  | CNG Heavy Duty Trucks
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | General Services, Central Fleet
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | _________ Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department |  | General Services Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  |  | _________ Department | General Services Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation |  | 1151-075200-E
 |  |  |  |  | Account Codes
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Name |  | Date
 | Title
Reviewed by:
 | Name |  | Date
 | Title
Reference Numbers
Spreadsheet: 883802d1732530950-returning-1-when-it-should-be-0-rows-unique-filter-function-returning-1-when-it-should-be-0-rows-unique-filter-function-v2
Sheet: PivotTable

Duplicates | No | <- select "No" to remove double-counting
No. of Participant | Category
Month | BOD | Senior Manager | Manager | Staff | Grand Total
January | 4 | 9 | 27 | 84 | 124
February | 0 | 0 | 7 | 15 | 22
April | 0 | 1 | 3 | 16 | 20
June | 0 | 0 | 2 | 2 | 4
July | 3 | 4 | 13 | 29 | 49
August | 0 | 1 | 7 | 11 | 19
September | 0 | 7 | 12 | 48 | 67
October | 1 | 1 | 2 | 13 | 17
Grand Total | 8 | 23 | 73 | 218 | 322
Spreadsheet: 771040d1646394940-conditional-formatting-and-multiple-formulas-testing
Sheet: Sheet2

DATE REQUESTED | STATUS | Should be True
2022-02-19 00:00:00 | Other | N
2022-02-20 00:00:00 | Data Requested | Y
2022-02-21 00:00:00 | Data Requested | Y
2022-02-22 00:00:00 | Other | N
2022-02-23 00:00:00 | Data Requested | Y
2022-02-24 00:00:00 | Partial Data Received | Y
2022-02-25 00:00:00 | Data Requested | N
2022-02-26 00:00:00 | Data Requested | N
2022-02-27 00:00:00 | Other | N
2022-02-28 00:00:00 | Data Requested | N
2022-03-01 00:00:00 | Data Requested | N
2022-03-02 00:00:00 | Other | N
2022-03-03 00:00:00 | Data Requested | N
2022-03-04 00:00:00 | Data Requested | N
Spreadsheet: 115473d1311083523-using-vlookup-and-choose-functions-together-copy-of-vlookup-and-choose
Sheet: Week1

 | City | Mon | Tue | Wed | Thu | Fri
 | Cardiff | 0.7428062208594792 | 0.3112220609454885 | 0.7231875456429846 | 0.6362127597517286 | 0.4568405217269769
 | Dublin | 0.8420908806398106 | 0.385865763580246 | 0.7989911215964194 | 0.1031321984347766 | 0.07264782794110508
 | Edinburgh | 0.119641674269199 | 0.2122099978031049 | 0.3257154242932176 | 0.06250898369052105 | 0.1120558246072045
 | [NAME] | 0.0344059934838441 | 0.1125890048329012 | 0.9479434639225379 | 0.9640861832449232 | 0.5017326483910791
 | London | 0.3695428849440279 | 0.466577299164221 | 0.4669820918141565 | 0.4424507068310652 | 0.5197187878917569
 | [NAME] | 0.6856452095929996 | 0.9329304128487923 | 0.520911587989187 | 0.08403264180571668 | 0.4959021739435052
 | [NAME] | 0.7115804673551929 | 0.6430968953491703 | 0.06593622420102507 | 0.7709848782672439 | 0.05381646260267381
 | Swansea | 0.7276668487880062 | 0.6274489470093672 | 0.3874355789948076 | 0.2161483080057132 | 0.003859924108977619
Spreadsheet: 726378d1617201907-excel-match-capture-partial-text-string-partialstring-internet
Sheet: Calc

ID | Effectiveness | Utilization | User Satisfaction | Desired Output
 |  |  |  | High
 |  |  |  | Medium
 |  |  |  | Low