tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 476972d1472085740-resource-allocation-problem-resource-allocations-distribution-per-day
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ALLOCATION CHART
Task Name | Start | Finish |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task A | Task B | Task C | Task D | Task E
Task A | 2016-08-16 00:00:00 | 2016-08-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday |  |  |  | Res A | 34 | 21 | 14 | 32 | 33
Task B | 2016-08-16 00:00:00 | 2016-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Work |  |  |  | Res B | 32 | 22 | 41 | 23 | 0
Task C | 2016-08-15 00:00:00 | 2016-08-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Res C | 16 | 21 | 0 | 14 | 32
Task D | 2016-08-14 00:00:00 | 2016-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Res D | 21 | 34 | 43 | 0 | 31
Task E | 2016-08-16 00:00:00 | 2016-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Res E | 12 | 0 | 45 | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | RESOURCE ALLOCATIONS
 |  | Res A
 |  | Res B
 |  | Res C
 |  | Res D
 |  | Res E
 | Task A | Res A
 | Task A | Res B
 | Task A | Res C
 | Task A | Res D
 | Task A | Res E
 | Task B | Res A
 | Task B | Res B
 | Task B | Res C
 | Task B | Res D
 | Task B | Res E
 | Task C | Res A
 | Task C | Res B
 | Task C | Res C
 | Task C | Res D
 | Task C | Res E
 | Task D | Res A
 | Task D | Res B
 | Task D | Res C
 | Task D | Res D
 | Task D | Res E
 | Task E | Res A
 | Task E | Res B
 | Task E | Res C
 | Task E | Res D
 | Task E | Res E
 |  | Res A
 |  | Res B
 |  | Res C
 |  | Res D
 |  | Res E
Spreadsheet: kimberly_watson__20545__sharris0901wk3
Sheet: Current Est Vs. Forecast

Transwestern Pipeline Company
($[NAME])
Current Estimate vs. Forecast
 |  | 3rd Current | Weekly
 |  | Estimate | Forecast | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | USGT $0K,  Astra $0K Negotiated Rate
West Commodity Revenues |  |  |  |  |  | West IT deals $130K
East Demand Revenues
East Commodity Revenues
[NAME] |  |  |  |  |  | Reliant $2K
[NAME] Revenues
PNR Revenues |  | 0
Revenue Variance
Fuel Price [NAME] |  |  |  |  |  | MTD index price of $2.04 vs. 3nd CE index price of $1.95
Fuel Volume Variance-Unhedged |  |  |  |  |  | Lower retained volumes
Sales Margin Variance on Unhedged |  |  |  |  |  | No over-retained fuel sales for September
Hedging Adjustment
Other Adjustment |  | 0.001
Fuel Variance (Excludes UAF)
Current Month Variance
Reserve |  | 0 | 0
Adjusted Current Month Variance
September Weekly
August 31, Weekly |  | 16.284 | 17.085
July 31, 2001 Actuals |  | 17.126 | 17.011
June 30, 2001 Actuals |  | 17.127 | 17.127
May 31, 2001 Actuals |  | 19.008 | 19.008
April 30, 2001 Actuals |  | 17.829 | 17.829
March 31, 2001(Q 1) Y T D |  | 53.403 | 53.403
September 30,2001 YTD
Spreadsheet: 220454d1363173182-help-with-if-function-where-a-number-of-possible-criteria-are-looked-up-in-a-cell-test_workbook_multiple_if_criteria
Sheet: Sheet1

TYPE | NET_AMOUNT | NET_ACTUAL | Expected
BP | -39090.6 |  | 39090.6 |  | cell C2 should show B2 as a positive value if cell A2 is "BP", "PI" or "CP".  Otherwise it should show B2 as a negative value
BR | 10000 |  | -10000 |  | cell [NAME] should show B3 as a positive value if cell [NAME] is "BP", "PI" or "CP".  Otherwise it should show B3 as a negative value
CP | -6.67 |  | 6.67 |  | etc
CR | 7.57 |  | -7.57
[NAME] | -366.16 |  | -366.16
[NAME] | 3746 |  | -3746
PA | 6700.81 |  | -6700.81
PC | 170.31 |  | -170.31
PI | -10.55 |  | 10.55
PP | 357.39 |  | -357.39
PR | -10303 |  | -10303
SA | -31.18 |  | -31.18
SC | -0.13 |  | -0.13
SI | 3.69 |  | -3.69
SP | 38.54 |  | -38.54
SR | -3.34 |  | -3.34
VP | -3.99 |  | -3.99
VR | 16.67 |  | -16.67
Spreadsheet: 838035d1690635526-combining-rows-by-keyword-sample-spill-aligw
Sheet: sample AliGW

A-1 Pallets Inc. | Amrik | Randhawa | Chief Executive Officer |  |  |  | Randhawa | Chief Executive Officer | Jasmin | Randhawa | Office Manager
A-1 Pallets Inc. | Jasmin | Randhawa | Office Manager |  | Accounting Services |  | Patridge | Office Manager
Accounting Services | [NAME] | Patridge | Office Manager |  | Adelphi Technology Inc. |  | [NAME] | CEO | [EMAIL]
Adelphi Technology Inc. | [NAME] | [NAME] | CEO | [EMAIL] | Aerostar Global Logistics |  | Fiacchino | CEO
Aerostar Global Logistics | [NAME] | Fiacchino | CEO |  | Afton Incorporated |  | Haughton | Senior Office Manager | [NAME] | Crain | Chief Executive Officer
Afton Incorporated | [NAME] | Haughton | Senior Office Manager |  | Air Balancing Company |  | Privitt | CEO
Afton Incorporated | [NAME] | Crain | Chief Executive Officer |  | All Accounting Services Inc. |  | Conway | Controller
Air Balancing Company | [NAME] | Privitt | CEO |  | Allegiance Title |  | Moore | CEO | [NAME] | [NAME] | Office manager
All Accounting Services Inc. | [NAME] | Conway | Controller |  | American Door Products Inc. |  | King | [NAME] | [NAME] | [NAME] | CEO
Allegiance Title | Dawn | Moore | CEO |  | Anne McGilvray & Company |  | [NAME] | Chief Executive Officer
Allegiance Title | [NAME] | [NAME] | Office manager |  | [NAME] |  | Pope | CEO
American Door Products Inc. | Chelsea | King | [NAME]
American Door Products Inc. | [NAME] | [NAME] | CEO
Anne McGilvray & Company | [NAME] | [NAME] | Chief Executive Officer
[NAME] | [NAME] | Pope | CEO
Spreadsheet: 718535d1613170250-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 31

 |  |  | Date | 2021-01-31 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  | 1900-01-20 00:00:00 |  |  |  | 1001 | Stoppage 3 | Category 3
Machine2 | 15:00:00 | 16:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 5cab6471-e4d0-408c-b785-0d309f185e5c
Sheet: Sheet1

Time | Event | Location
2:00 - 2:30PM | Check-In | Administration Bldg
2:30-  5:30PM | Medical Re-Checks | [NAME]
 | Camp Tour | Camp
6:00 - 7:00PM | Dinner | Flagpoles
7:00 - 8:00PM | Leaders Introductory Meeting | [NAME]
8:30PM | Flags (Bring your Troop flag) | Flagpoles
10:30PM | Quiet Time in Camp | All Scouts in Sites
Time | Event | Location
7:00AM - 7:30AM | Food & Staples Pick-up for Patrol Cooking | Commissary
7:30AM - 8:00AM | Food & Staples Pick-up for [NAME] | Commissary
9:00 - 11:45AM | Swim Checks, as scheduled | Aquatics
 | Aquatics Merit Badge Sign-Ups | Aquatics
9:00 - 11:45AM | All other Merit Badge Sign-Ups | Handicraft
12:00PM | Catholic Mass | Chapel
12:30PM | Food Pick-up (Normally 12:00PM, moved for mass) | Commissary
2:00PM | Merit Badge Classes Begin | Program Areas
5:00 - 5:30PM | Food & Staples, Patrol Cooking | Commissary
5:30 - 6:00PM | Food & Staples, [NAME] | Commissary
7:00PM | Safe Swim Defense & Safety Afloat for Leaders (dry) | Aquatics
8:30PM | Flags | Flagpoles
9:00PM | Opening Campfire | [NAME]
10:30PM | Lights Out in Camp | All Scouts in Sites
Saturday Morning Schedule
Time | Event | Location
5:30AM | Staff [NAME] | Staff Site
5:45-6:15AM | Staff arrives in Site for final check out and to assist Troop in leaving | Troop Site
6-6:30AM | Continental Breakfast | Commissary
6:30-7:00AM | Troops depart Camp.  All Troops are to depart by 7:00AM | Parking Lot
Friday [NAME]
Time | Event | Location
2:00PM | Water Carnival | Aquatics
4:00PM | Scoutmaster/SPL Shoot | Rifle Range
5:30-6:30PM | Dinner | In Sites
7:00PM | Final Merit Badge Walkthrough | Administration Bldg
7:30PM | Interfaith Service | Chapel
8:30PM | Flags | Flagpoles
9:00PM | Closing Campfire | [NAME]
10:30PM | Lights Out | In Sites
Spreadsheet: 768498f9-7290-44c9-bfe1-52476432682d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4190 | 25762 | [NAME] | Wai | SIN | 0 | [NAME] | 00:00:00 | 05:26:37 | 00:00:00 | 03:38:10 | 1 | 11:04:31
Spreadsheet: 869119d1715771007-average-pass-rates-for-multiple-users-and-questions-example-1
Sheet: Output

Question number | (All) |  | ←Able to select any question number
ID number | % pass rate
1 | 0.75
2 | 0.5
3 | 0.6666666666666666
4 | 0.5
5 | 0
6 | 0
7 | 1
8 | 0
Grand Total | 0.4736842105263158
Spreadsheet: 70119d1270781685-workbook-to-workbook-data-entry-needed-test2
Sheet: Invoice 1

My Invoice # | 1
Date | 2010-04-08 00:00:00
Name | [NAME]
Address | Brooklyn, NY
Phone | [PHONE]
 | Item Description | Serial # | Size | Color | Price | Quantity | Total
1 | Candle | 23 | Large | Blue | 12 | 2 | 24
2 | Soap | na | na | white | 4 | 12 | 48
3 |  |  |  |  |  |  | 0
4 |  |  |  |  |  |  | 0
5 |  |  |  |  |  |  | 0
 |  |  |  |  |  | Sub Total | 72
 |  |  |  |  |  | Tax | 4.86
 |  |  |  |  |  | Total | 76.86
Spreadsheet: b2c10102-590d-4638-af70-8fd692e1904f
Sheet: Sheet1

[NAME] | Units are no longer allowed to bring their own firewood to camp. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716) 891-4073 OR E-MAIL [EMAIL] |  |  |  |  |  |  |  | 2013-11-27 00:00:00
SCHOELLKOPF |  | SCHOELLKOPF |  | 2014 | 2014 | 2014 | 2014 | 2014
 | Capacity | Code | FEE | FEB 28 - MAR 2 | [NAME] 7 - 9 | [NAME] 14 - 16 | [NAME] 21 - 23 | MARCH 28 - 30
District/Council Events
**Phillip (Lower) | 8 | S,W,E | 48
**Schoellkopf (Upper) | 12 | S,W,E | 72
Schwartz | 14 | S,W | 70
Score | 18 | S,W,E | 108 |  | T583 W | T268 W
**Self | 12 | S,W,E | 72
Sikes | 16 | S,W,E,C | 96
**Toulmin | 18 | S,W,E | 108
Lean-To's
**Art Wood (Flats) | 12 | W | 48
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48
**Faso (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
Troop 7 Shelter | 20 | S,W,E | 96
**Szymkowiak lean-to | 12 | W, E | 72
Tenting   $2 per person,per night |  | [NAME]
Tenting   $2 per person,per night
Tenting   $2 per person,per night
Day Hike $2 per person
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  | SCOUTHAVEN |  | 2014 | 2014 | 2014 | 2014 | 2014
 | Capacity | CODE | FEE | FEB 28 - MAR 2 | [NAME] 7 - 9 | [NAME] 14 - 16 | [NAME] 21 - 23 | MARCH 28 - 30
District/Council Events |  |  |  |  |  |  | MAPLE SUGAR DAY
[NAME] | 20 | S,W,E | 120
Loegler 1 | 20 | C,S,W,E | 120 |  |  |  | [NAME]
Loegler 2 | 20 | C,S,W,E | 120 | T735 W |  |  | T184 1/4W
[NAME] | 30 | C,S,W,E | 180 | [NAME] |  |  | P57 W
Lean-To's
#1 Eagle | 12 | W | 48 |  |  |  | T1776 W
#2 Whitetail | 12 | W | 48 |  |  |  | T1776
#3 Dziedzic | 12 | W | 48 |  |  |  | [NAME]
Moose | 10 | W | 40 |  |  | T431 1/4W | P336 W
Boss | 12 | W | 48 |  |  |  | T173
Tenting   $2 per person,per night
Tenting   $2 per person,per night
Day Hike $2 per person
[NAME] |  | [NAME] |  | 2014 | 2014 | 2014 | 2014 | 2014
 | Capacity | CODE | FEE | FEB 28 - MAR 2 | [NAME] 7 - 9 | [NAME] 14 - 16 | [NAME] 21 - 23 | MARCH 28 - 30
District/Council Events |  |  |  |  |  |  |  | IOLST       BALOO
Cabin #1 | 24 | S,W,E | 144
Cabin #2 | 24 | S,W,E | 144 |  |  |  |  | IOLST
Leader's Lodge | 28 | S,W,E | 168 |  |  |  | P58 W
[NAME] | 30 | C,S,W,E | 180 |  |  |  | T58 W | BALOO
Stone Lean-To | 6 | [NAME] | 24
Troop 107 lean-to | 8 | W | 30
*New  Ganosote Lean-To | 12 | W | 48
*New Tuscarora Lean-To | 12 | W | 48
Tenting   $2 per person,per night
Tenting   $2 per person,per night
Day Hike $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face.
Spreadsheet: 697603d1601439356-row-counting-based-on-several-cells-hypothetical-1-slicers-aligw
Sheet: Sheet1

House | Floors | Color | Material | Rooms
1 | 1 | Red | Brick | 3
2 | 2 | Red | Wood | 3
3 | 2 | Yellow | Brick | 4
4 | 1 | Red | Brick | 4
5 | 2 | Blue | Brick | 4
6 | 2 | Blue | Wood | 3
7 | 1 | Blue | Wood | 3
8 | 1 | Red | Wood | 4
9 | 1 | Red | Brick | 3
10 | 2 | Red | Brick | 3
11 | 1 | Yellow | Wood | 4
12 | 1 | Red | Brick | 3
Count
Spreadsheet: 175941d1345672840-average-calls-per-hour-per-day-calls
Sheet: Sheet2

Call type | Date | Time | Hour | Source | Duration
ans | 2012-07-31 00:00:00 | 17:14:55 |  | Line 9.1 | 00:00:40 |  |  |  | Hour | (All)
out | 2012-07-31 00:00:00 | 17:07:12 |  | [NAME] | 00:00:28
internal | 2012-07-31 00:00:00 | 17:02:39 |  | [NAME] | 00:00:10 |  |  |  | Row Labels | Source | Time | Average of Duration
ans | 2012-07-31 00:00:00 | 16:53:26 |  | Line 9.2 | 00:00:45 |  |  |  | ans | Line 9.1 | 17:14:55 | 00:00:40
out | 2012-07-31 00:00:00 | 16:53:04 |  | [NAME] | 00:00:07 |  |  |  |  | Line 9.2 | 16:53:26 | 00:00:45
out | 2012-07-31 00:00:00 | 16:52:41 |  | [NAME] | 00:00:08 |  |  |  | internal | [NAME] | 17:02:39 | 00:00:10
 |  |  |  |  |  |  |  |  | out | [NAME] | 17:07:12 | 00:00:28
 |  |  |  |  |  |  |  |  |  | [NAME] | 16:52:41 | 00:00:08
 |  |  |  |  |  |  |  |  |  |  | 16:53:04 | 00:00:07
 |  |  |  |  |  |  |  |  | Grand Total |  |  | 00:00:23
Spreadsheet: 1b034fd2-d9fc-4cb7-9741-69283eabe873
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
 | 5676.0 Business Indicators, Australia
 | TABLE 23. INVENTORIES/SALES RATIO, Current prices, Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Inventories to sales ratio ;  Total (State) ;  Accommodation and food services ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531409K | 1999-03-01 00:00:00 | 2010-06-01 00:00:00 | 46 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Electricity, gas, water and waste services ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531308X | 2001-03-01 00:00:00 | 2010-06-01 00:00:00 | 38 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Manufacturing ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531281K | 1984-06-01 00:00:00 | 2010-06-01 00:00:00 | 105 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  [NAME] ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531254C | 2001-03-01 00:00:00 | 2010-06-01 00:00:00 | 38 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Retail trade ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531382W | 1999-03-01 00:00:00 | 2010-06-01 00:00:00 | 46 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Wholesale trade ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531355R | 1989-06-01 00:00:00 | 2010-06-01 00:00:00 | 85 | Quotient | RATIO | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 798480d1664495837-how-to-populate-other-cells-based-on-drop-down-value-plus-a-couple-other-questions-sample-pd-sheet
Sheet: Shift

PSID | Rcd | Name | Earn ID | PP | Fund | Dept | S/C | Acct | Hours | Rate | Amount Due
110350077 | 0 | Smith, VALERIE | SHN08 | 2022-09-01 00:00:00 | 496E5 | 63491 | 00000 | 601935 | 1 | 2.2
105089348 | 0 | Jones, [NAME] | SHE08 | 2022-09-01 00:00:00 | 46715 | 63491 | 42504 | 601935 | 176 | 0.23
101016366 | 0 | Test, RICHARD | SHSWG | 2022-09-01 00:00:00 | 46715 | 43425 | 42503 | 601935 | 20 | 1.35
14816 | 0 | Doe, MAYRA | SHGRV | 2022-09-01 00:00:00 | 496F6 | 35309 | 42513 | 601935 | 85 | 2.3
Spreadsheet: 9dda47e0-74d2-483c-8f38-eb9791a43ff8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
ECOS Project Partner [NAME]
Name of Organization: |  |  |  | Instruction:  Assess each criteria by putting the number matching the evaluation in each box. For example, if you feel there is a strong match with ECOS objectives, put "4" in the box in that row.  Do not enter a number into the row titled "Average Score".  The Average Score will calculate itself as you will in each row.  The closer the score is to 9, the stronger the project match.
Project Objectives
1
2
3
4
5
Project Match Assessment
Instructions:  put the number corresponding with your choice in the box next to each statement.
 |  | Very Strong | Strong | Moderate | Weak | Very Weak | Not applicable | Average Score
 |  | 5 | 4 | 3 | 2 | 1 | 0
The project matches ECOS objectives
The organization's mission/vision align with ECOS
The objectives of the project will help the organization achieve its mission
We are able to provide the required number of volunteers
The project will be complete by January 31, 2010
The project is sustainable (long-term change)
The project is environmentally friendly
The partner is able to provide additional tools and resources
Our members can identify emotionally with this project
 |  | 0 | 0 | 0 | 0 | 0 |  | 0
Spreadsheet: 118371d1313630342-charting-specific-cell-values-from-multiple-sheets-server-data
Sheet: Summary

 | Select a Server |  | Server A
 | Select a Drive |  | C |  |  | Current Year |  | 2011
Row # | Drive | Format | Total | Used | Free | % Free | % Used | Month |  |  | Server Names | Months | Drive
 |  |  |  |  |  |  |  |  |  |  | Server A | January | A
 |  |  |  |  |  |  |  |  |  |  | Server B | February | B
 |  |  |  |  |  |  |  |  |  |  | Server C | March | C
 |  |  |  |  |  |  |  |  |  |  | Server D | April | D
 |  |  |  |  |  |  |  |  |  |  | Server E | May | E
 |  |  |  |  |  |  |  |  |  |  | Server F | June | F
 |  |  |  |  |  |  |  |  |  |  | Server G | July | G
 |  |  |  |  |  |  |  |  |  |  | Server H | August | H
 |  |  |  |  |  |  |  |  |  |  |  | September | I
 |  |  |  |  |  |  |  |  |  |  |  | October | J
 |  |  |  |  |  |  |  |  |  |  |  | November | K
 |  |  |  |  |  |  |  |  |  |  |  | December | L
 |  |  |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  |  |  |  |  |  | P
 | Row # column is just helper to get the relevent Row numbers. You can hide this column |  |  |  |  |  |  |  |  |  |  |  | Q
 | Assume no duplicate [NAME] names in each tab. |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  | U
 |  |  |  |  |  |  |  |  |  |  |  |  | V
 |  |  |  |  |  |  |  |  |  |  |  |  | W
 |  |  |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  |  |  | Z
Spreadsheet: 692343d1598284873-bonus-calculations-example-lookup
Sheet: Sheet1

 | bonus |  | Lookup | Bonus
0 | 0 |  | 35
20 | 250 |  | 89
30 | 500 |  | 10
40 | 750 |  | 110
50 | 1250
60 | 1500
70 | 1750
80 | 2250
90 | 2500
100 | 3000
20 is 250 bonus
30 is 500
40 is 750
50 is 1250
60 is 1500
70 is 1750
80 is 2250
90 is 2500
100 is 3000
Spreadsheet: 844729d1696427390-reporting-data-from-a-table-query-helpme
Sheet: raw

ShopOrder | Emp | Sample | SampleSize | 1.1 | 1.2 | 2.1 | 2.2 | 3 | 4 | 5.1 | 5.2 | 5.3 | 5.4
1 | 321 | 1 | 13 | 0.1189 | 0.1178 | 0.04726 | 0.04877 | 0.19464 | 0.09422 | 0.12358 | 0.12362 | 0.12209 | 0.12177 |  | This Sheet is how I currently have it - note General format
1 | 321 | 2 | 13 | 0.1191 | 0.1176 | 0.0471 | 0.04913 | 0.19465 | 0.0948 | 0.12377 | 0.12381 | 0.12192 | 0.12159
1 | 321 | 3 | 13 | 0.11863 | 0.11799 | 0.0461 | 0.04919 | 0.19463 | 0.09477 | 0.12336 | 0.12337 | 0.12227 | 0.12195
1 | 321 | 4 | 13 | 0.11921 | 0.11742 | 0.04678 | 0.05063 | 0.19457 | 0.0946 | 0.12389 | 0.1239 | 0.12173 | 0.12141
2 | 123 | 1 | 4 | 0.11889 | 0.1177 | 0.05544 | 0.05064 | 0.19461 | 0.09605 | 0.12358 | 0.12361 | 0.12199 | 0.12167
2 | 123 | 2 | 4 | 0.11856 | 0.11797 | 0.04673 | 0.05064 | 0.19458 | 0.0946 | 0.12327 | 0.1233 | 0.12225 | 0.12192
2 | 123 | 3 | 4 | 0.11875 | 0.11782 | 0.04776 | 0.04961 | 0.19455 | 0.09498 | 0.12345 | 0.12347 | 0.1221 | 0.12178
2 | 123 | 4 | 4 | 0.11901 | 0.11762 | 0.0476 | 0.05041 | 0.19457 | 0.09526 | 0.12372 | 0.12373 | 0.12191 | 0.12158
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: Top 10 Overall

Originator | Commodity | Team | Total
Zufferli | Power | Canada
[NAME] | Power | West
Tycholiz | Gas | West | 19943780
Thome | Power | West | 16000000
[NAME] | Power | West
[NAME] | Power | West
Whitt | Gas | West | 10556290
Wehn | Power | West | 10000000
Calger | Power | West
Luce | Gas | Central
Total
Spreadsheet: d5d52d22-7333-448c-a193-6b4aaa96f22e
Sheet: General

GENERAL |  |  |  |  |  |  | 120206
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Amending Chapter 78 of the |  | 2012-05-01 00:00:00 |  | Amending Chapter 78 of the Codes of Ordinances
 | Codes of Ordinances
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Water Services Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Water Services Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | Water 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
 |  |  |  |  |  |  |  |  |  |  |  |  | $12,500,000
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
 | Billings for usage prior to 5/1/12, FY11-12 rates shall apply.
 | Billings for usage on or after 5/1/12, the new rates shall apply.
Fact Sheet Prepared by:
 | [NAME]
 | Contract Administration Section
Reviewed by:
 | [NAME]
 | Director of Water Services
Reference Numbers |  | Chapter 78 Code of Ordinances