tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220045d1363040021-prices-do-not-load-properly-into-the-pricelist-for-our-website-cactus-shop-mar11-test
Sheet: Sheet1

 | latin name | .25 .35 .45 01 02 03 | cactus shop wholesale price | plus % | profit | minimum quantity | profit for minimum quantity | our website price
c | PACHYVERIA GLAUCA LITTLE JEWEL | .25 | 1.5 |  |  | 10
c | PORTULACARIA [NAME] (ELEPHANT [NAME]) | .25 | 1.5 |  |  | 10
c | SEDUM HERNANDEZII | .25 | 1.5 |  |  | 10
c | [NAME] (HEN'S N'CHICKS) | .25 | 1.5 |  |  | 10
c | ECHEVERIA DERENBERGII (PAINTED LADY) | .25 | 1.68 |  |  | 10
c | [NAME] (STONE FACES) | .25 | 1.75 |  |  | 10
c | [NAME] (THIMBLE CACTUS) | .25 | 1.75 |  |  | 10
c | OPUNTIA [NAME] (BUNNY EARS) | .25 | 1.75 |  |  | 10
c | [NAME] | .25 | 1.75 |  |  | 10
c | PLEIOSPILOS NELII (SPLIT ROCK) | .25 | 1.75 |  |  | 10
c | [NAME] (SUNRISE) | .25 | 1.88 |  |  | 10
c | ALOE CILIARIS (CLIMBING ALOE) | .35 | 2 |  |  | 10
c | ALOE VERA (BARBADENSIS) | .35 | 2 |  |  | 10
c | [NAME] | .35 | 2 |  |  | 10
Spreadsheet: 9233112a-ebc9-4f14-99a1-377927bedb54
Sheet: Sheet1

Release: Construction Spending | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=229
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-30 7:35 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Construction Spending | 2011-07-01 00:00:00 | Current
Link:
http://www.census.gov/construction/c30/c30index.html | 2011-07-01 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2011-07-01 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-03 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-03 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-02 00:00:00
2012-08-01 00:00:00
2012-09-04 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-22 00:00:00
2013-12-02 00:00:00
2014-01-02 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
2014-04-01 00:00:00
2014-05-01 00:00:00
2014-06-02 00:00:00
2014-07-01 00:00:00
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: October

Name | Site |  |  | 2021-10-01 00:00:00 | 2021-10-02 00:00:00 | 2021-10-03 00:00:00 | 2021-10-04 00:00:00 | 2021-10-05 00:00:00 | 2021-10-06 00:00:00 | 2021-10-07 00:00:00 | 2021-10-08 00:00:00 | 2021-10-09 00:00:00 | 2021-10-10 00:00:00 | 2021-10-11 00:00:00 | 2021-10-12 00:00:00 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 2021-10-16 00:00:00 | 2021-10-17 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 2021-10-22 00:00:00 | 2021-10-23 00:00:00 | 2021-10-24 00:00:00 | 2021-10-25 00:00:00 | 2021-10-26 00:00:00 | 2021-10-27 00:00:00 | 2021-10-28 00:00:00 | 2021-10-29 00:00:00 | 2021-10-30 00:00:00 | 2021-10-31 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: 807224d1669810067-transfer-of-data-from-a-master-sheet-to-other-sheets-major-last
Sheet: Co-Operative Bank

Helper |  | Date | Description | Debit | Credit
 |  |  |  |  |  | Co-Operative Bank
Spreadsheet: 77339d1277834962-macro-or-formula-to-total-sum-example-of-sum-data
Sheet: Sheet2

REG HOURLY | 72 |  | 070 | HUMAN RESOURCES | HR RECEPTIONIST/CLERK
REG HOURLY | 80 |  | 070 | HUMAN RESOURCES | HR RECEPTIONIST/CLERK
PTO HOURLY | 8 |  | 070 | HUMAN RESOURCES | HR RECEPTIONIST/CLERK
OVERTIME | 0.75 |  | 070 | HUMAN RESOURCES | HR RECEPTIONIST/CLERK
OVERTIME | 7 |  | 070 | HUMAN RESOURCES | HR RECEPTIONIST/CLERK
FTE
REG HOURLY | 77.5 |  | 070 | HUMAN RESOURCES | HR REPRESENTATIVE
REG HOURLY | 80 |  | 070 | HUMAN RESOURCES | HR REPRESENTATIVE
PTO HOURLY | 2 |  | 070 | HUMAN RESOURCES | HR REPRESENTATIVE
OVERTIME | 0.75 |  | 070 | HUMAN RESOURCES | HR REPRESENTATIVE
OVERTIME | 1.25 |  | 070 | HUMAN RESOURCES | HR REPRESENTATIVE
FTE
REG - SALARY | 0 |  | 070 | HUMAN RESOURCES | HRIS SPECIALIST
REG - SALARY | 0 |  | 70 | HUMAN RESOURCES | HRIS SPECIALIST
FTE
Spreadsheet: 34653f7c-4535-42a0-b233-8081f802b610
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40287028 | 2014-02-28 22:29:15 | AXIS | 0 | 4 | 7 | 1500421 | Italiangambit | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40287422 | 2014-02-28 23:04:10 | ALLIES | 0 | 6 | 7 | 1500421 | Italiangambit | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40288023 | 2014-02-28 23:26:55 | AXIS | 0 | 2 | 5 | 27494 | pegase61 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40288361 | 2014-02-28 23:47:29 | ALLIES | 0 | 3 | 5 | 27494 | pegase61 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
40372037 | 2014-03-05 21:21:28 | ALLIES | 1 | 6 | 4 | 361532 | LB_soldier | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
Spreadsheet: 285500d1387661347-sumproduct-formula-gives-ref-error-formula-help-required
Sheet: Sheet1

 | [NAME] | London |  | Filter |  |  |  |  |  |  | Warsaw
 |  |  |  |  |  |  |  |  |  |  | London
Spreadsheet: 120d0a82-8bde-425e-ac24-06dcdd877a53
Sheet: Sheet1

מס"ד | [NAME] | המחבר | קורס | מחיר (בש"ח) | הערות
1 | פונקציות מרוכבות | בן ציון קון | פונקציות מרוכבות | 30
2 | חדו"א 1 | בן ציון קון | חדו"א 1 | 35
3 | חשבון דיפרנציאלי ואינטגרלי ב' - כרך א' | הווארד אנטון | חדו"א 2 | 64 | מומלץ
4 | חשבון דיפרנציאלי ואינטגרלי ב' - כרך ב' | הווארד אנטון | חדו"א 2 | 44 | מומלץ
5 | חדו"א 2 - תרגילים ופתרונות | אלכס קופמן | חדו"א 2 | 13
6 | אלגברה ליניארית | [NAME] | אלגברה ליניארית | 55
7 | טורי פורייה | [NAME] | אנליזה | 15
8 | מבוא [NAME] | תלמה לויתן | הסתברות | 35
9 | מבוא לפיסיקה מודרנית | [NAME] פרר ושלום ניר | פיסיקה 3 | 50
10 | מכניקה לתיכון ולאוניברסיטה | יורם [NAME] | פיסיקה 1 | 50
11 | [NAME] ספר התשובות | יורם [NAME] | פיסיקה 1 | 45
12 | [NAME] תרגילים | [NAME] | [NAME] | 50 | מומלץ
13 | [NAME], 6, 7 (ספר אחד) | [NAME] הפתוחה | שיטות חישוביות | 52
14 | מוליכים למחצה ושימושיהם | זאב בורשטיין | מבוא למל"מ | 10
Spreadsheet: geir_solberg__11258__5_30act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 784871d1655985696-find-the-sum-of-duplicate-consecutive-zeros-month
Sheet: Sheet1

Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Day | 30 | 30 | 29 | 0 | 0 | 0 | 31 | 31 | 0 | 30 | 0 | 0
expcetd result
 |  |  |  | =SUM(E2:G2) |  |  |  |  | =J2 |  | =SUM(L2:[NAME])
Spreadsheet: 182841d1348632091-compare-sheet1columns-a-with-sheet2-column-a-and-output-the-difference-to-sheet3-column-a-compare-sheets-and-output-difference
Sheet: Sheet3

Name
Spreadsheet: 847355d1698325571-how-to-calculate-penalty-time-if-work-finishes-after-midnight-late-early-penalty-calculator_hans-formula-mike-geraghty-
Sheet: Penalty Rate Calculator

CALCULATOR # 1.
 |  |  | EARLY/LATE PENALTY RATE HOURS |  |  |  |  |  |  | PENALTY HOURS  CALCULATED FOR THE SHIFT |  | WHAT THE PENALTY HOURS  SHOULD BE
 |  |  | 2nd. HALF
 |  |  | Start | End | Total | Normal | Penalty | ROUNDED
WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  | 6.5
 |  |  |  |  |  |  |  |  |  |  |  | 4.5
 |  |  |  |  |  |  |  |  |  |  |  | 2.5
 |  |  |  |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 8.5
 |  |  |  |  |  | Week 2 - 2nd. Half Total :
Spreadsheet: 87665d1287557763-time-calcs-wtih-decimal-results-time-logs_example
Sheet: Conversions

5 | 0.08
10 | 0.17
15 | 0.25
20 | 0.33
25 | 0.42
30 | 0.5
35 | 0.58
40 | 0.67
45 | 0.75
50 | 0.83
55 | 0.92
60 | 1
Spreadsheet: benjamin_rogers__942__NY Calcs010201
Sheet: Zone G

 | ZONE G |  |  |  |  |  | CALENDER 2001 |  |  | G/A | J/G |  |  | CALENDER 2002
 |  |  |  |  |  | TERM | BID | OFFER | DAYS |  |  | TERM | BID | OFFER | DAYS | "02/01"
 |  |  |  |  |  | JAN | 70 | 70 | 22 |  |  | JAN | 60 | 65 | 22
 |  |  |  |  |  | FEB | 70 | 70 | 20 |  |  | FEB | 60 | 65 | 20
 | Q4 | CALC |  | Days | J/G | JAN-FEB |  |  |  |  |  | JAN-FEB
 | Oct |  |  | 22 |  | MAR | 58 | 60 | 22 |  |  | MAR | 52 | 55 | 21 |  |  |  |  |  |  | 77.5
 | Nov |  |  | 21 |  | Q-1 |  |  |  |  |  | Q-1 |  |  |  |  |  |  |  |  |  | 77.5
 | Dec | 61.5 | 61.5 | 20 |  | APR | 53 | 57 | 21 |  |  | APR | 49.5 | 51.5 | 22 |  |  |  |  |  |  | 58.5
 | Q4 |  |  |  |  | MAY | 61 | 63 | 22 |  |  | MAY | 55.5 | 57.5 | 22 |  |  |  |  |  |  | 52
 |  |  |  |  | 5@7.5 | [NAME] | 75 | 77 | 21 |  |  | [NAME] | 67.5 | 70.5 | 20 |  |  |  |  |  |  | 59
NOTES | BIDS | OFFERS |  |  |  | Q-2 |  |  |  |  |  | Q-2 |  |  |  |  |  |  |  |  |  | 70.5
Cal 01 | 70 | 74 | 2000-12-20 00:00:00 |  |  | JUL | 105 | 110 | 21 |  |  | JUL | 90 | 96 | 22 |  |  |  |  |  |  | 95
CAL O2 |  |  |  |  |  | AUG | 105 | 110 | 23 |  |  | AUG | 90 | 96 | 22 |  |  |  |  |  |  | 95
CAL 03 |  |  |  |  |  | JUL-AUG |  |  |  |  |  | JUL-AUG |  |  |  |  |  |  |  |  |  | 53
CAL 04 |  |  |  |  |  | SEPT | 54 | 55 | 19 |  |  | SEPT | 49 | 51 | 20 |  |  |  |  |  |  | 49.5
[NAME] |  |  |  |  |  | Q3 |  |  |  |  |  | Q3 |  |  |  |  |  |  |  |  |  | 51.5
NYJ/PJM |  |  |  |  |  | Oct | 52 | 55 | 23 |  |  | Oct | 47 | 49 | 23 |  |  |  |  |  |  | 53.5
 |  |  |  |  |  | Nov | 53 | 56 | 21 |  |  | Nov | 48 | 50 | 20
 |  |  |  |  |  | Dec | 54 | 57 | 20 |  |  | Dec | 50 | 52 | 21
 |  |  |  |  |  | Q4 |  |  |  |  |  | Q4
 |  |  |  |  |  | CAL 01 |  |  |  |  |  | cal 02
 |  |  |  |  |  |  |  |  |  |  |  | cal01/02
 |  |  |  |  |  |  |  |  |  |  | 7@9.5 |  | -10.5 | -6
 |  |  |  |  |  |  |  | 16 | 8
 |  |  |  |  |  |  |  | 58 | 44
 |  | POS | SUM
MONTH | DEC | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUG | SEP | OCT | NOV | DEC
SETTLE
POSITION
Nepool
Spreadsheet: 275208d1383393597-n-a-error-ef514a_lean-to-roofs
Sheet: Grid_2

Grid 2 |  | LEAN TO ROOF - STANDARD OR LOW PITCH
 | Increments: | Across: | 600
 |  | Down: | 500
conservatory size |  | width | 3.1 | depth | 2.5 | valid: | Yes | Price:
WIDTH | 3000 | 3600 | 4200 | 4800 | 5400 | 6000 | 6600
DEPTH
2500 | 3416 | 3597 | 3778 | 4032 | 4232 | 4299 | 4466
3000 | 3756 | 4003 | 4180 | 4426 | 4732 | 4946 | 5199
3500 | 4034 | 4267 | 4448 | 4813 | 4993 | 5332 | 5473
4000 | 4209 | 4519 | 4732 | 4948 | 5277 | 5596 | 5707
Spreadsheet: 26696d1219085275-what-function-to-use-to-populate-data-from-other-worksheet-autopopulatedatainfohelp-2-
Sheet: w.e. 29th june

 |  |  | 2008-06-23 00:00:00 | 2008-06-24 00:00:00 | 2008-06-25 00:00:00 | 2008-06-26 00:00:00 | 2008-06-27 00:00:00 | 2008-06-28 00:00:00 | 2008-06-29 00:00:00
 |  | st albans | 18 | 15 | 15 | 21 | 10 | 0 | 0
 |  | sunbury | 9 | 6 | 5 | 6 | 10 | 0 | 0
 |  | peterborough | 7 | 14 | 7 | 13 | 6 | 0 | 0
Spreadsheet: 798370d1664449055-using-xlookup-while-avoiding-blanks-to-instead-return-adjacent-column-xlookup-with-or
Sheet: Sheet2

 | ID | Date1 | Date 2
 | 1000 | 2023-05-10 00:00:00
 | 1001 | 2023-05-11 00:00:00
 | 1002 | 2023-05-12 00:00:00
 | 1003 | 2023-05-13 00:00:00
 | 1004 |  | 2023-05-10 00:00:00
 | 1005 |  | 2023-05-11 00:00:00
 | 1006 |  | 2023-05-12 00:00:00
 | 1007 |  | 2023-05-13 00:00:00
 | 1008 |  | 2023-05-14 00:00:00
 | 1009 |  | 2023-05-15 00:00:00
 | 1010 | 2023-05-10 00:00:00
 | 1011 | 2023-05-11 00:00:00
 | 1012 | 2023-05-12 00:00:00
 | 1013 | 2023-05-13 00:00:00
 | 1014 |  | 2023-05-12 00:00:00
 | 1015 |  | 2023-05-13 00:00:00
 | 1016 | 2023-05-10 00:00:00
 | 1017 | 2023-05-11 00:00:00
 | 1018 | 2023-05-12 00:00:00
 | 1019 | 2023-05-13 00:00:00
 | 1020 |  | 2023-05-12 00:00:00
Spreadsheet: 816918d1675891162-xlookup-and-if-formula-roadblock-for-commissions-sample_2023_commission
Sheet: Data and Calcs

Sales Total | January | February | March | April | May | June | July | August | September | October | November | December |  | Sales | Bonus | Class |  | Sales | Bonus | Class |  | Sales | Bonus | Class
[NAME] | 42705.97 |  |  |  |  |  |  |  |  |  |  |  |  | 20000 | 200 | Quick |  | 40000 | 500 | Custom |  | 70000 | 1500 | National
Emily | 43117.15 |  |  |  |  |  |  |  |  |  |  |  |  | 25000 | 350 | Quick |  | 50000 | 750 | Custom |  | 80000 | 2000 | National
[NAME] | 41086.74 |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 500 | Quick |  | 60000 | 1000 | Custom |  | 90000 | 2500 | National
[NAME] | 42705.97 |  |  |  |  |  |  |  |  |  |  |  |  | 35000 | 650 | Quick |  | 70000 | 1500 | Custom |  | 100000 | 3000 | National
JJ | 25668.03 |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 800 | Quick |  | 80000 | 2000 | Custom |  | 110000 | 3500 | National
Shawnee | 23658.52 |  |  |  |  |  |  |  |  |  |  |  |  | 45000 | 1000 | Quick |  | 90000 | 2500 | Custom |  | 120000 | 4000 | National
Travis | 25735.94 |  |  |  |  |  |  |  |  |  |  |  |  | 50000 | 1250 | Quick |  | 100000 | 3000 | Custom |  | 130000 | 4500 | National
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55000 | 1500 | Quick |  | 110000 | 3500 | Custom |  | 140000 | 5000 | National
D&L Total | January | February | March | April | May | June | July | August | September | October | November | December |  | 60000 | 1750 | Quick |  | 120000 | 4000 | Custom |  | 150000 | 5500 | National
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 65000 | 2000 | Quick |  | 130000 | 4500 | Custom |  | 160000 | 6000 | National
Emily | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 70000 | 2250 | Quick |  | 140000 | 5000 | Custom |  | 170000 | 6500 | National
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 75000 | 2500 | Quick |  | 150000 | 5500 | Custom |  | 180000 | 7000 | National
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 80000 | 2750 | Quick |  | 160000 | 6000 | Custom |  | 190000 | 8000 | National
JJ | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 85000 | 3000 | Quick |  | 170000 | 6500 | Custom |  | 200000 | 8500 | National
Shawnee | 0
Travis | 0
Open Invoice | January | February | March | April | May | June | July | August | September | October | November | December
[NAME]
Emily
[NAME]
[NAME]
JJ
Shawnee
Travis
Spreadsheet: 112368d1308531770-summarizing-data-by-month-and-year-w-o-regard-to-day-copy-of-sumif-sample
Sheet: Sheet1

 | Year | 2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum of Count | Column Labels
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |  |  |  | <1/01/2011 | 2011 |  |  | Grand Total
 | Type 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | (blank) | Jan | Feb | Mar
 | Type 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type 1 |  | 13 |  | 10 | 23
 | Type 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type 2 |  | 9 | 5 |  | 14
 | Type 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type 3 |  | 10 | 4 |  | 14
 | Type 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type 4 |  | 8 |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type 5 |  | 7 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 47 | 9 | 10 | 66
 | Date | Type | Count
 | 2011-01-01 00:00:00 | Type 1 | 5
 | 2011-01-03 00:00:00 | Type 1 | 8
 | 2011-01-05 00:00:00 | Type 2 | 9
 | 2011-01-06 00:00:00 | Type 3 | 10
 | 2011-01-07 00:00:00 | Type 4 | 8
 | 2011-01-08 00:00:00 | Type 5 | 7
 | 2011-02-01 00:00:00 | Type 2 | 5
 | 2011-02-03 00:00:00 | Type 3 | 4
 | 2011-03-05 00:00:00 | Type 1 | 10
Spreadsheet: 86991d1286913037-looking-for-a-sum-or-count-formula-job-group-analysis
Sheet: Workforce Analysis

DEPARTMENT/WORK UNIT: Administration |  |  |  |  | MALE |  |  |  |  |  |  |  | FEMALE
Job Title | [NAME] | EEO- 1 Cat. | Job Group | Total Employees | Total | WHT | BLK | ASN | AIAN | NHOPI | TWO+ | HISP | Total | WHT | BLK | ASN | AIAN | NHOPI | TWO+ | HISP
HR/Recruiting Manager |  | 1.2 | 2 | 1 | 0 |  |  |  |  |  |  |  | 1 | 1
Office Services Manager |  | 1.2 | 2 | 1 | 0 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
Finance Staff 1 |  | 2 | 1 | 2 | 0 |  |  |  |  |  |  |  | 2 | 1 |  |  |  |  |  | 1
HR/Recruiting Staff |  | 2 | 1 | 1 | 0 |  |  |  |  |  |  |  | 1 | 1
IT Staff |  | 2 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 0
Administrative Assistant |  | 3 | 1 | 5 | 0 |  |  |  |  |  |  |  | 5 | 2 |  |  |  |  |  | 3
Marketing/Sales Staff 2 |  | 3 | 1 | 1 | 0 |  |  |  |  |  |  |  | 1 | 1
Receptionist |  | 3 | 1 | 3 | 1 |  |  |  |  |  |  | 1 | 2 | 1 |  |  |  |  |  | 1
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
DEPARTMENT TOTAL |  |  |  | 15 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 13 | 7 | 0 | 0 | 0 | 0 | 0 | 6
DEPARTMENT/WORK UNIT: Client Service |  |  |  |  | MALE |  |  |  |  |  |  |  | FEMALE
Job Title | [NAME] | EEO- 1 Cat. | Job Group | Total Employees | Total | WHT | BLK | ASN | AIAN | NHOPI | TWO+ | HISP | Total | WHT | BLK | ASN | AIAN | NHOPI | TWO+ | HISP
Client Service Senior Manager |  | 2 | 8 | 12 | 7 | 5 |  |  |  |  |  | 2 | 5 | 4 |  |  |  |  | 1
Client Service Manager |  | 2 | 7 | 12 | 5 | 3 |  | 1 |  |  |  | 1 | 7 | 3 |  | 1 |  |  |  | 3
Client Service Senior |  | 2 | 6 | 21 | 6 | 4 |  |  |  |  | 1 | 1 | 15 | 7 |  | 1 | 1 |  | 2 | 4
Client Service Staff |  | 2 | 5 | 22 | 8 | 5 |  |  |  |  |  | 3 | 14 | 8 |  |  |  |  | 1 | 5
Client Service Intern |  | 2 | 4 | 3 | 1 | 1 |  |  |  |  |  |  | 2 | 1 |  |  |  |  |  | 1
DEPARTMENT TOTAL |  |  |  | 70 | 27 | 18 | 0 | 1 | 0 | 0 | 1 | 7 | 43 | 23 | 0 | 2 | 1 | 0 | 4 | 13
Spreadsheet: 698437d1601983633-dependent-dropdown-list-problem-book1
Sheet: Event

No | Admin1 [NAME] | Admin2 NAME | Admin3 NAME | Admin4 NAME | Admin1 CODE | Admin2 CODE | Admin3 CODE | Admin4 CODE
1 | [NAME] | Asahan | Meranti
2 | [NAME] | [NAME] | Meranti
3
4
5
6
7
8
9
Spreadsheet: 61570d1262473009-water-tank-level-formula-last-3-days-water-tank-level
Sheet: Numbers

Date | Top Water Level | Lower Water Level |  | Most recent 3 Days
2010-01-01 00:00:00 | 50 | 100 |  |  | Top | Middle
2010-01-02 00:00:00 | 45 | 90 |  | Date | Water Level | Water Level
2010-01-03 00:00:00 | 50 | 100 |  | 2010-01-01 00:00:00 | 50 | 100
2010-01-04 00:00:00 | 45 | 90 |  | 2010-01-02 00:00:00 | 45 | 90
2010-01-05 00:00:00 | 40 | 80 |  | 2010-01-03 00:00:00 | 50 | 100
 |  |  |  | 2010-01-04 00:00:00 | 45 | 90
 |  |  |  | 2010-01-05 00:00:00 | 40 | 80
 |  |  |  | Average Change Per Day | 2.5 | 5
 |  |  |  | Days Remaining | Surplus | Surplus
Spreadsheet: 826743d1682237619-the-number-of-auto-filtering-and-minimum-value-bigger-than-0-formula-help
Sheet: Sheet1

Name | Value1 | Value2 | Value3 |  | Min
A | 5 | 6 | 8
B | 6 | 4 | 9
A | 8 | 3 | 5
B | 4 | 9 | 6
A | 5 | 6 | 8
B | 4 | 3 | 5
B | 2 | 3 | 1
B | 0 | 5 | 6
A | 7 | 0 | 5
B | 5 | 8 | 4
Expect the following results
 | 3 | 4 | 3 | The result that appears when it is not filter (Before Filter)
Result A | 2 | 1 | 1 | The result of the occurrence of A
Result B | 1 | 3 | 2 | The result of the occurrence of B
 |  | 4 | 3
 | 3 | 4 | 3
A | 2 | 1 | 1
B | 1 | 3 | 2
Spreadsheet: 215086d1361261960-valuation-of-inventory-with-their-sale-value-datafile
Sheet: Item Transfer to Project

 | [NAME] | Date | From Site | Project | Item | Category | Qty | Amount | Despech By |  | Item\Project | Category | [NAME] |  | Tank
 | 1 | 2013-01-02 00:00:00 | Bharatpur | [NAME] | choclate | Edible | 750 | ? | Bus |  |  |  | Qty | Amount | Qty | Amount
 | 2 | 2013-01-03 00:00:00 | bikaner | tank | choclate | Edible | 200 | ? | Bus |  | choclate | Edible | 750 | ? | 200 | ?
 |  |  |  |  |  |  |  |  |  |  | buiscuit | Edible | 0 | ? | 0 | ?
 |  |  |  |  |  |  |  |  |  |  | Pepsi | Drink | 0 | ? | 0 | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | here======>>>>>>>>
 |  |  |  |  |  |  |  | here======>>>>>>>>
 |  |  |  |  |  |  |  |  |  |  | On each Project how much qty spend and find out Their Value?
 |  |  |  |  |  | Problem========>>>>>>>>>>>>>>>>
Spreadsheet: 158dcaf3-d4a8-4c40-944d-f2083a2c8688
Sheet: Sheet1

CITY OF PORTLAND
FY 13/14 GENERAL FUND OVERHEAD
BASED ON TARGET AMOUNTS
USING FY 11/12 DATA
 | FINAL | RATE |  | FINAL | RATE
 | OVERHEAD | OF |  | OVERHEAD | OF
OVERHEAD BUREAUS | RECOVERY | RECOVERY |  | RECOVERY | RECOVERY
City Attorney
Office of the Auditor
Audit Services
Records Management
City Council
Planning Bureau
Information & Referral/ONI
Public Involvement Best Practices
Purchasing
OMF Administration/Financial Management
Financial Planning
[NAME]
Accounting Admin/Technical Accounting
Accounting/Accounts Payable
Accounting/Payroll
HR ORG 41..49
HR ORG 50
HR ORG 51
HR ORG 52
Office of Emergency Management
Office of Equity
PDX Office of Emergency Management
SUBTOTAL:
Special Appropriations:
Memberships & Dues
Leaders Roundtable
Council Emergency Funds
TOTAL SPECIAL APPROPRIATIONS
GRAND TOTAL
CITY COUNCIL COST CENTERS
AU 190 Comm. Public Works
AU 191 Comm. Public Safety
AU 192 Comm. Public Affairs
AU 193 Comm. Public Utilities
AU 195 Office of the Mayor
AU 303 Governmental Relations
Subtotals