tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 67200d1267794289-vlookup-dates-vlookup-dates-v3
Sheet: Sheet1

 |  |  |  |  |  |  | Mob | Helper Col |  |  |  |  | DeMob | Helper Columns
BADGE# | CBS | Name | Position | MOB | DEMOB |  |  |  |  | Col Return | Row Return |  |  |  |  | Col Return | Row Return
VIS0424 | 088466CNGCPC01 |  | PROJECT MANAGER | 2010-04-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-04-15 00:00:00 | 0.5 | 2010-04-30 00:00:00 | 4 | 4 |  | 2011-07-15 00:00:00 | 0.5 | 2011-07-31 00:00:00 | 22 | 4
15918 | 088466CNGCPC01 |  | CONSTRUCTION MANAGER | 2010-05-01 00:00:00 | 2011-05-31 00:00:00 |  | 2010-05-01 00:00:00 | 1 | 2010-05-31 00:00:00 | 5 | 5 |  | 2011-05-31 00:00:00 | 1 | 2011-05-31 00:00:00 | 20 | 5
TBA 2A | 088466CNGCPC01 |  | DEPUTY CONSTRUCTION MGR. | 2010-03-01 00:00:00 | 2011-07-31 00:00:00 |  | 2010-03-01 00:00:00 | 1 | 2010-03-31 00:00:00 | 3 | 6 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 6
TBA 3 | 088466CNGCPC01 |  | H.S.E. MANAGER | 2010-06-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-06-15 00:00:00 | 0.5 | 2010-06-30 00:00:00 | 6 | 7 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 7
TBA 30 | 088466CNGCPC01 |  | PROJECT CONTROL MGR. | 2010-04-15 00:00:00 | 2011-06-30 00:00:00 |  | 2010-04-15 00:00:00 | 0.5 | 2010-04-30 00:00:00 | 4 | 8 |  | 2011-06-15 00:00:00 | 0.5 | 2011-06-30 00:00:00 | 21 | 8
TBA 8 | 088466CNGCPC01 | TBA | QUALITY MANAGER | 2010-05-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-05-15 00:00:00 | 0.5 | 2010-05-31 00:00:00 | 5 | 9 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 9
TBA 9 | 088466CNGCPC01 | TBA | FIELD ENGINEER | 2010-05-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-05-15 00:00:00 | 0.5 | 2010-05-31 00:00:00 | 5 | 10 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 10
TBA 10 | 088466CNGCPC01 | TBA | DOCTOR | 2010-06-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-06-15 00:00:00 | 0.5 | 2010-06-30 00:00:00 | 6 | 11 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 11
TBA 11 | 088466CNGCPC01 | TBA | SECURITY COORDINATOR | 2010-01-01 00:00:00 | 2011-07-31 00:00:00 |  | 2010-01-01 00:00:00 | 1 | 2010-01-31 00:00:00 | 1 | 12 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 12
TBA 13 | 088466CNGCPC01 | TBA | LOGISTIC MANAGER | 2010-03-01 00:00:00 | 2011-04-30 00:00:00 |  | 2010-03-01 00:00:00 | 1 | 2010-03-31 00:00:00 | 3 | 13 |  | 2011-04-30 00:00:00 | 1 | 2011-04-30 00:00:00 | 19 | 13
TBA 14 | 088466CNGCPC01 | TBA | PRECOMM/COMMISSIONING MGR. | 2011-01-15 00:00:00 | 2011-07-31 00:00:00 |  | 2011-01-15 00:00:00 | 0.5 | 2011-01-31 00:00:00 | 13 | 14 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 14
TBA 15 | 088466CNGCPC01 | TBA | SITE PREP SUPERINTENDENT | 2010-01-15 00:00:00 | 2010-04-30 00:00:00 |  | 2010-01-15 00:00:00 | 0.5 | 2010-01-31 00:00:00 | 1 | 15 |  | 2010-04-15 00:00:00 | 0.5 | 2010-04-30 00:00:00 | 7 | 15
TBA 16 | 088466CNGCPC01 | TBA | MECHANICAL SUPERINTENDENT | 2010-07-01 00:00:00 | 2011-03-31 00:00:00 |  | 2010-07-01 00:00:00 | 1 | 2010-07-31 00:00:00 | 7 | 16 |  | 2011-03-31 00:00:00 | 1 | 2011-03-31 00:00:00 | 18 | 16
Spreadsheet: 83f35b16-c974-4214-b254-5e1e0b4672f6
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120375 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Periodic update to Chapter 18, Code of Ordinances, Kansas City Building & Rehabilitation Code
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2011-12 |  |  | FY 2012-13
 | General Fund |  |  | $ |  |  | $
 | Special Revenue |  |  | $ |  |  | $
 | Enterprise |  |  | $ |  |  | $
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known or, if grant revenue, please identify source of funds (federal or state) and duration of grant support.)
 | Encroachment fees
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2011-12 |  |  | FY 2012-13
 | General Fund |  |  | $ |  |  | $
 | Special Revenue |  |  | $ |  |  | $
 | Enterprise/Other |  |  | $ |  |  | $
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimated number of people to be served, who is currently delivering services to that population, service
 | performance expectations and, if grant supported, provisions for support if grant support ends.)
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  |  | No |  | X | Yes
 | (If yes, please detail the purpose and source for that mandate).
 | A portion of this update deals with elevator codes and standards.  Missouri state law requires that when
 | municipal jurisdictions elect to adopt elevator codes and standards, they shall be at a minimum equivalent
 | to those adopted by the State.  This KCBRC update will make Kansas City consistent with the State
 | elevator code update currently underway.
Reviewed by:
0ffice of Management and Budget |  |  |  |  |  | OMB Approval Date
Spreadsheet: 228598d1366154448-time-sheet-calculator-seeking-developer-on-commercial-arrangement-timesheet
Sheet: Sheet1

 |  | rates: | 100 | 150
start | finish | time | cost | sell
1300 | 1350
220 | 415
921 | 1510
Spreadsheet: 541375d1507246839-make-a-list-from-a-data-base-example
Sheet: Prices

 |  | Product | Retailer | Brand | Price | date
 | Expected results
 | 1 | Product | Retailer | Brand | Price | date
 |  | [NAME] | walmart | Heinz | 3 | 2017-07-07 00:00:00
 |  |  | Costco | French's | 4 | 2017-10-02 00:00:00
 |  |  | Carrefour | Del Monte | 3.39 | 2017-06-12 00:00:00
 |  |  | walmart | Del Monte | 4.12 | 2017-02-04 00:00:00
 |  |  | walmart | Heinz | 2.56 | 2017-05-01 00:00:00
 | or
 | 2 | Product | Retailer | Brand | Price | date
 |  | Mayonnaise | Carrefour | Hellmann's | 4.67 | 2017-12-12 00:00:00
 |  |  | Costco | Kraft | 5.38 | 2017-01-11 00:00:00
 |  |  | Costco | Kraft | 5.59 | 2017-11-05 00:00:00
Spreadsheet: 888711d1739286973-lookup-a-value-within-a-table-vernong72-table
Sheet: Numbers

-10 | 8
 |  | -35
 | 5 | 0.3096599544072948 | 0.3143047112462006 | 0.3189494680851064 | 0.3204692249240121 | 0.3266337386018238 | 0.3312784954407295 | 0.3621010638297872 | 0.3852393617021276 | 0.4114171732522797 | 0.4222264437689969
 | 6 | 0.3974829027355623 | 0.4082921732522796 | 0.4129369300911854 | 0.4191014437689969 | 0.43 | 0.4360752279635258 | 0.4745820668693009 | 0.5038848784194528 | 0.5408719604863221 | 0.5624050151975684
 | 7 | 0.483786094224924 | 0.4945953647416413 | 0.4992401215805471 | 0.5054046352583587 | 0.52 | 0.5377469604863222 | 0.5870630699088145 | 0.6225303951367781 | 0.6748860182370822 | 0.7118731003039513
 | 8 | 0.56 | 0.5700892857142856 | 0.5762537993920972 | 0.5824183130699088 | 0.61 | 0.6425436930091185 | 0.6948993161094225 | 0.7473404255319149 | 0.8120250759878419 | 0.8675056990881458
 | 9 | 0.63 | 0.65 | 0.6517477203647417 | 0.6610372340425532 | 0.6887348024316109 | 0.7457351823708206 | 0.8073803191489362 | 0.8736702127659575 | 0.9538088905775075 | 1.024658054711246
 | 10 | 0.7 | 0.7195573708206686 | 0.7318863981762918 | 0.7380509118541033 | 0.77 | 0.84 | 0.91 | 1 | 1.093987462006079 | 1.186455167173252
 | 11 |  |  |  |  |  |  |  | 1.130974544072948 | 1.238810790273556 | 1.345127279635258
 | 12 |  |  |  |  |  |  |  | 1.263468844984802 | 1.386759118541034 | 1.50844414893617
Spreadsheet: 847559d1698419558-power-pivot-not-displaying-intended-result-efh2
Sheet: Pivot

 | Warehouse | e-Store | Catalogue | Stock (count)
 | HQ | 1 | 1 | 1
 | North | 3 | 4 | 5
 | East | 2 | 0 | 2
 | South | 3 | 4 | 5
 | West | 1 | 0 | 1
Spreadsheet: dfc275cf-8f7c-4adb-84e8-614d57c7f120
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FUIQL | Test | FUIQL | Indicans, [NAME] | Urine Indicans Qual | Qualitative Colorimetry |  |  |  |  |  | Two 4.5 mL aliquots from well-mixed random urine collection, no preservatives, shipped frozen. | 3 mL | Hemolysis:	NA Thawing:	Warm reject; Cold reject Lipemia:	NA Icterus:	NA Other:	NA | Negative  Test Performed by:	ARUP Laboratories 			500 [NAME], UT 84108 | Sunday through Saturday | 1 - 2 days | 3 - 6 days | 1 | 81005 |  |  |  |  | ARUP Laboratories
FUIQL | [NAME] | URINE | [NAME] |  |  |  | Frozen | 365 days
FUIQL | Result | [NAME] | Urine Indicans Qual | Urine Indicans Qual | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 478475d1472819968-colour-column-if-current-weeknumber-excel-question-weekcolumn-highlight
Sheet: Blad1

Week | 35 |  |  |  |  |  |  |  | 39 |  | 39
Step | 1 |  |  |  |  |  |  | So if it's week 39 I would like to see this column: | 5 | and not this -> | 5
1
Spreadsheet: 78200d1278599199-excel-2007-nested-vlookup-with-multiple-cells-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | D | I | L | O | S
02 | 1 | 10000 | PC | 1 | 5# | 3 | T | LB | 1 |  | PC | 1 | 1 | LB | 1 | 1 | T | LB |  |  | 10000 | PC | LB | PC | LB | LB
02 | 1 | 10010 | CS | 3 | 15# | 3 | T | LB | 1 |  | CS | 1 | 1 | LB | 1 | 1 | T | LB |  |  | 10010 | CS | LB | CS | LB | LB
02 | 1 | 10010 | PC | 1 | 15# | 3 | F |  |  |  | CS | 3 | 1 | LB | 1 | 15 | T | LB |  |  | 10010 | PC |  | CS | LB | LB
02 | 1 | 10020 | CS | 10 | 8# | 3 | T | LB | 1 |  | CS | 1 | 1 | LB | 1 | 1 | T | LB |  |  | 10020 | CS | LB | CS | LB | LB
02 | 1 | 10020 | PC | 1 | 8# | 3 | F |  |  |  | CS | 10 | 1 | LB | 1 | 8 | T | LB |  |  | 10020 | PC |  | CS | LB | LB
02 | 1 | 10022 | PC | 1 | 7# | 3 | T | LB | 1 |  | PC | 1 | 1 | LB | 1 | 1 | T | LB |  |  | 10022 | PC | LB | PC | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10024 | CS | LB | CS | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10030 | CS | LB | CS | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10038 | CS | LB | CS | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10038 | PC |  | CS | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10040 | PC | LB | PC | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10042 | PC | LB | PC | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10044 | CS | LB | CS | LB | LB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10044 | PC |  | CS | LB | LB
Spreadsheet: 71752d1272483971-query-a-table-and-sum-sheet
Sheet: Sheet1

 |  |  | week enquiry | 4
 | week | week | week | week | week | week | week | week | week | week | week | week | week
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Total at week enquiry
Item 1 | 4 | 3 | 7 | 28 | 8 | 0 | 1 | 9 | 5 | 5 | 5 | 3 | 1
Item 2 | 1 | 1 | 1 | 2 | 3 | 4 | 55 | 6 | 7 | 8 | 3 | 5 | 6
Item 3 | 7 | 8 | 999 | 0 | 8 | 6 | 4 | 2 | 35 | 7 | 8 | 9 | 0
Item 4 | 7 |  | 2 |  |  | 234 | 5 |  |  | 6 | 7 | 8 | 6
Item 5 | 5 |  |  | 6 |  |  | 6 |  | 6 | 6 |  |  | 6
Spreadsheet: 144631d1331065051-matching-row-of-source-table-against-target-table-array-book1-8-
Sheet: Sheet1

 |  |  |  | SOURCE |  |  | matching with :- | TARGET |  |  | matching with :-
 |  |  | formula | Amount | Account | Date |  | Amount | Account | Date
 |  |  |  | -3 | 37 | 2012-02-28 00:00:00 | #N/A | -5 | 42 | 2012-03-01 00:00:00 | row # 10 in Source Table
 |  |  |  | 2 | 18 | 2012-03-03 00:00:00 | row # 12 in Target Table | -4 | 54 | 2012-02-28 00:00:00 | #N/A
 |  |  |  | 4 | 37 | 2012-03-01 00:00:00 | row # 14 in Target Table | 7 | 37 | 2012-02-28 00:00:00 | #N/A
 |  |  |  | 1 | 95 | 2012-03-02 00:00:00 | #N/A | -2 | 42 | 2012-03-02 00:00:00 | row # 19 in Source Table
 |  |  |  | -5 | 42 | 2012-03-01 00:00:00 | row # 6 in Target Table | -1 | 18 | 2012-03-05 00:00:00 | row # 17 in Source Table
 |  |  |  | 9 | 42 | 2012-02-28 00:00:00 | row # 19 in Target Table | 1 | 18 | 2012-03-02 00:00:00 | #N/A
 |  |  |  | 7 | 18 | 2012-02-29 00:00:00 | row # 17 in Target Table | 2 | 18 | 2012-03-03 00:00:00 | row # 7 in Source Table
 |  |  |  | 3 | 42 | 2012-02-28 00:00:00 | row # 13 in Target Table | 3 | 42 | 2012-02-28 00:00:00 | row # 13 in Source Table
 |  |  |  | 6 | 37 | 2012-02-29 00:00:00 | row # 16 in Target Table | 4 | 37 | 2012-03-01 00:00:00 | row # 8 in Source Table
 |  |  |  | -4 | 54 | 2012-03-05 00:00:00 | #N/A | 5 | 37 | 2012-03-01 00:00:00 | #N/A
 |  |  |  | 8 | 18 | 2012-03-02 00:00:00 | #N/A | 6 | 37 | 2012-02-29 00:00:00 | row # 14 in Source Table
 |  |  |  | -1 | 18 | 2012-03-05 00:00:00 | row # 10 in Target Table | 7 | 18 | 2012-02-29 00:00:00 | row # 12 in Source Table
 |  |  |  | 5 | 54 | 2012-03-01 00:00:00 | #N/A | 13 | 18 | 2012-03-02 00:00:00 | #N/A
 |  |  |  | -2 | 42 | 2012-03-02 00:00:00 | row # 9 in Target Table | 9 | 42 | 2012-02-28 00:00:00 | row # 11 in Source Table
 |  |  |  |  |  |  |  | 10 | 42 | 2012-03-05 00:00:00 | #N/A
 |  |  |  |  |  |  |  | 11 | 18 | 2012-03-02 00:00:00 | #N/A
 |  |  |  |  |  |  |  | 12 | 54 | 2012-02-28 00:00:00 | #N/A
 |  |  |  |  |  |  |  | 13 | 95 | 2012-03-05 00:00:00 | #N/A
 |  |  |  |  |  |  |  | 14 | 54 | 2012-03-01 00:00:00 | #N/A
 |  |  |  |  |  |  |  | 15 | 42 | 2012-02-29 00:00:00 | #N/A
Spreadsheet: 109866d1306689502-index-matching-multiple-reference-points-index-matching
Sheet: Sheet1

0 | Date | LAST_PRICE | Buy | Sell | Price Return results | Price Return results | Price Return results
0-B | 2003-02-04 00:00:00 | 76.627
0-B | 2003-02-05 00:00:00 | 76.164
1-B | 2003-02-06 00:00:00 | 75.701 | B
1-B | 2003-02-07 00:00:00 | 75.932 |  | S | 0.003051478844401156
2-B | 2003-02-10 00:00:00 | 74 | B
2-B | 2003-02-11 00:00:00 | 76.164
2-B | 2003-02-12 00:00:00 | 76.627 |  | S | 0.01223233510785859 | 0.03549999999999986
3-B | 2003-02-13 00:00:00 | 76.395 | B
3-B | 2003-02-14 00:00:00 | 76.395
3-B | 2003-02-15 00:00:00 | 76.3717
3-B | 2003-02-16 00:00:00 | 75 |  | S | -0.009260115454221118 | 0.0135135135135136 | -0.01826035735322984
3-B | 2003-02-17 00:00:00 | 77.3484
3-B | 2003-02-18 00:00:00 | 78.3484
3-B | 2003-02-19 00:00:00 | 79.3484 |  | S | 0.04818166206523045 | 0.07227567567567572 | 0.03865959814123965
3-B | 2003-02-20 00:00:00 | 80.3484
Spreadsheet: 93590d1293152841-pulling-data-from-matrixes-on-other-sheets-using-a-drop-down-menu-model
Sheet: New York

 |  |  |  | New York
 |  |  |  |  | [NAME]
Age of Wine |  | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
1-3 years | 1 | 200 | 225 | 250 | 275 | 300 | 325 | 350 | 375
4-7 years | 4 | 250 | 275 | 300 | 325 | 350 | 375 | 400 | 425
8-10 years | 8 | 325 | 350 | 375 | 400 | 425 | 450 | 475 | 500
11-19 years | 11 | 400 | 425 | 450 | 475 | 500 | 525 | 550 | 575
20+ years | 20 | 450 | 475 | 500 | 550 | 575 | 600 | 625 | 650
Spreadsheet: 211144d1359663328-formula-for-calculating-accrual-vacation-time-vacation-tracker-2013-sample
Sheet: Sheet1

Employee Name | Hire Date |  | Vacation Time | Dates Used
[NAME] | 2013-01-09 00:00:00 |  | 0
[NAME] | 2009-12-01 00:00:00 |  | 0
[NAME] | 2013-01-17 00:00:00 |  | 0
[NAME] | 2012-08-01 00:00:00 |  | 0
[NAME] | 2012-07-16 00:00:00 |  | 0
[NAME] | 2012-11-12 00:00:00 |  | 0
[NAME] | 2011-08-17 00:00:00 |  | 7
Heather Lawrence | 2013-01-29 00:00:00 |  | 0
[NAME] | 2013-01-28 00:00:00 |  | 0
[NAME] | 2008-11-01 00:00:00 |  | 14
[NAME] | 2012-09-19 00:00:00 |  | 0
[NAME] | 2009-09-21 00:00:00 |  | 14
[NAME] | 2012-12-20 00:00:00 |  | 0
[NAME] | 2004-06-01 00:00:00 |  | 14
[NAME] | 2013-01-25 00:00:00 |  | 0
[NAME] | 2009-06-24 00:00:00 |  | 7
[NAME] | 2011-08-22 00:00:00 |  | 7
[NAME] | 2008-11-01 00:00:00 |  | 0
[NAME] | 2012-09-19 00:00:00 |  | 0
[NAME] | 2012-12-12 00:00:00 |  | 0
[NAME] | 2011-01-13 00:00:00 |  | 0
[NAME] | 2012-09-01 00:00:00 |  | 0
[NAME] | 2012-11-19 00:00:00 |  | 0
[NAME] | 2011-11-10 00:00:00 |  | 7
[NAME] | 2008-04-28 00:00:00 |  | 14
[NAME] | 2010-08-30 00:00:00 |  | 7
[NAME] | 2011-02-02 00:00:00 |  | 7
[NAME] | 2012-04-02 00:00:00 |  | 0
[NAME] | 2013-01-25 00:00:00 |  | 0
[NAME] | 2011-09-03 00:00:00 |  | 7
[NAME] | 2011-12-29 00:00:00 |  | 7
Heather Carper | 2012-03-13 00:00:00
[NAME] | 2011-05-09 00:00:00 |  | 7
[NAME] | 2006-01-01 00:00:00 |  | 14 | 1/4/2013 thru 1/4/13
Spreadsheet: 141880d1329494720-excel-2007-combinging-subtotal-with-countif-sample
Sheet: Overview

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008 |  |  |  | 2009 |  |  |  | 2010 |  |  |  | 2011
Category | Buyer | Supplier Code | To Be Reviewed | Suspended | [NAME] | Family Code | Sub-Family Code | Family  Description | Sub-Family Description | Tooling Present | Total Expenditure 2008 | Total Expenditure 2009 | Total Expenditure 2010 | Total Expenditure 2011 | Total Expenditure 2012 | % of Total Spend 2011 | 2008 Q1 | 2008 Q2 | 2008 Q3 | 2008 Q4 | 2009 Q1 | 2009 Q2 | 2009 Q3 | 2009 Q4 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 Q4 | 2011 Q1 | 2011 Q2 | 2011 Q3 | 2011 Q4 | 2012-01-01 00:00:00
Direct | A.Sample | 910273 |  | Open | Supplier A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 323107.0000000001
Direct | B.Sample | 911267 |  | Open | Supplier B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 166567.39
Other | C.Sample | 911829 |  | Open | Supplier C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140088.12
Direct | A.Sample | 9E0109 |  | Open | Supplier D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87418.35999999997
Direct | B.Sample | 914065 |  | Open | Supplier E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82830.88
Indirect | C.Sample | 914436 |  | Open | Supplier F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75913.95
Direct | C.Sample | 9E0106 |  | Open | Supplier G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67851.93000000002
Direct | B.Sample | 912833 |  | Open | Supplier H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66148.86
Indirect | A.Sample | 913424 |  | Open | Supplier I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63210.91999999998
Direct | B.Sample | 9E0069 |  | Open | Supplier J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62798.92
Direct | C.Sample | 9E0069 |  | Open | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Direct | A.Sample | 9E0069 |  | Open | Supplier L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Live Suppliers
Suppliers With Spend (Month End)
Filter sub-totals
Spreadsheet: 472264d1469522463-converting-data-between-tabs-department-performance-current
Sheet: Raw Data

 |  | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00 | 2016-07-03 00:00:00
EID | Name | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME | RCV QTY | RCV Time | FH QTY | FH TIME | RCH QTY | RCH TIME
149798 | [NAME] | 367 | 13.28 | 286 | 12.31 | 222 | 8.26 | 653 | 21.15 | 41 | 3.26 | 0 | 0 | 987 | 21.25 | 1065 | 21.05 | 230 | 12.36
334037 | [NAME] | 84 | 3.9 | 997 | 27.13 | 85 | 3.78 | 255 | 12.17 | 716 | 19.96 | 0 | 0 | 602 | 17.54 | 124 | 7.25 | 60 | 3
332082 | [NAME] | 220 | 6.55 | 393 | 15.1 | 0 | 0 | 21 | 1.44 | 53 | 3.77 | 298 | 10.83 | 0 | 0 | 24 | 0.98 | 685 | 29.76
WEEKLY TOTALS
Spreadsheet: 5b6986a8-b850-45fb-8d33-d46a0e62466f
Sheet: Table of B-Curve Values

(Acres) |  | [NAME]
Drainage Area |  | B-Curve Value | B curve check
10 |  | 4
20 |  | 6.1
30 |  | 8.1
40 |  | 10
50 |  | 12
60 |  | 14
70 |  | 15
80 |  | 17
90 |  | 18
100 |  | 19
125 |  | 22
150 |  | 25
175 |  | 28
200 |  | 31
225 |  | 33
250 |  | 35
275 |  | 39
300 |  | 41
325 |  | 42
350 |  | 45
375 |  | 49
400 |  | 50
425 |  | 51
450 |  | 55
475 |  | 59
500 |  | 60
525 |  | 62
550 |  | 64
575 |  | 65
600 |  | 68
625 |  | 69
650 |  | 70
675 |  | 72
700 |  | 74
725 |  | 76
750 |  | 78
775 |  | 80
800 |  | 81
825 |  | 82
850 |  | 85
875 |  | 87
900 |  | 89
925 |  | 90
950 |  | 91
975 |  | 93
1000 |  | 95
1100 |  | 100
1200 |  | 105
1300 |  | 110
1400 |  | 128
1500 |  | 138
1600 |  | 142
1700 |  | 146
1800 |  | 150
1900 |  | 155
2000 |  | 160
2100 |  | 164
2200 |  | 169
2300 |  | 173
2400 |  | 179
2500 |  | 185
2600 |  | 189
2700 |  | 193
2800 |  | 197
2900 |  | 203
3000 |  | 210
3500 |  | 229
4000 |  | 250
4500 |  | 280
5000 |  | 300
5500 |  | 315
6000 |  | 330
6500 |  | 350
7000 |  | 380
7500 |  | 400
8000 |  | 415
8500 |  | 430
9000 |  | 450
9500 |  | 470
10000 |  | 490
Spreadsheet: 827739d1683011925-deduction-and-refund-formula-deduction-calculator
Sheet: Sheet1

SHORTAGES
Exceeds | Does not exceed | Fixed Deduction | Rate on Excess | Rates
-500 | 0 | 0 | 1
0 | 150 | 0 | 1
0 | 150 | 0 | 1
 | 200 | 150 | 0.09
 | 250 |  | 0.08
 | 300 |  | 0.07
 | 350 |  | 0.06
 | 400 |  | 0.05
 | 450 |  | 0.04
 | 500 |  | 0.03
 |  |  | 0.02
Examples
Shortage | Deduction Calculator
 | Fixed Deduction per Table | Excess | Rate on excess |  | Expected Deduction | [NAME]
40 | 0 | 0 | 1 |  | 40
780 | 220 |  | 0.02
-200 |  |  |  |  | -200 | ?