tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 599875d1543343598-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Team 5

CLASS 19-005
Date | [NAME] |  |  |  | PI
 | Sickcall and Med Documentation |  |  |  | [NAME]
 | Infection, Asepsis, & Sterile Techniques |  |  |  | [NAME]
 | Medication Administration |  |  |  | [NAME]
 | Injections |  |  |  | [NAME]
 | Pharmacology |  |  |  | [NAME]
 | Venipuncture |  |  |  | [NAME]
 | Respiratory Primary Care |  |  |  | [NAME]
 | EENT Primary Care |  |  |  | [NAME]
 | Abdominal Primary Care |  |  |  | [NAME]
 | Orthopedic Primary Care |  |  |  | SSG H
 | Basic Wound Primary Care |  |  |  | [NAME]
 | Skin Disease Primary Care |  |  |  | [NAME]
 | Primary Care Pre-Examination Review |  |  |  | [NAME]
 | Primary Care Exam |  |  |  | [NAME]
 | Intro to Battlefield Medicine |  |  |  | [NAME]
 | Battlefield Communication/ Documentation |  |  |  | [NAME]
 | Casualty Movement |  |  |  | [NAME]
 | Combat Medical Aid Bag |  |  |  | SSG H
 | Combat Casualty Assessment |  |  |  | SSG H
 | Control Bleeding |  |  |  | [NAME]
 | Airway Management |  |  |  | [NAME]
 | [NAME] Trauma |  |  |  | [NAME]
 | Shock |  |  |  | [NAME]
 | Vascular Access |  |  |  | SSG H
 | Fieldcraft 1 Pre-Examination Review |  |  |  | [NAME]
 | Field Craft Exam |  |  |  | [NAME]
 | Head Injuries with Traumatic Brain Injuries |  |  |  | [NAME]
 | Ocular Injuries |  |  |  | SSG H
 | Burns |  |  |  | [NAME]
 | [NAME] |  |  |  | SSG H
 | Musculoskeletal Trauma |  |  |  | [NAME]
 | [NAME] |  |  |  | [NAME]
 | Field Craft 2 Exam |  |  |  | [NAME]
 | [NAME] Training |  |  |  | [NAME]
 | Casualty Triage |  |  |  | [NAME]
 | Suicide Prevention |  |  |  | [NAME]
 | [NAME] and Geneva Conv. |  |  |  | [NAME]
 | Environmental Threat |  |  |  | [NAME]
 | Fieldcraft 3 Pre-Examination Review |  |  |  | [NAME]
 | Field Craft Exam |  |  |  | [NAME]
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
Spreadsheet: 165183d1341076282-how-to-setup-summary-sheet-to-transfer-worksheet-data-chryspac-bse-invs
Sheet: Summary-Chy-Inv

CHRYS INVOICE CROSS CHECK WITH BSE INVOICES |  |  |  |  |  |  | Press Alt-F8 and select InvoiceToSummary
CHRYSPAC INVOICE # | CHRYSPAC INVOICE DATE | TOTAL CHRYSPAC INVOICE AMOUNT | CHRY CALCULATED TOTAL LABOR PRICE ONLY | CHRYS CALCULATED TOTAL COMPONENT PRICE ONLY |  |  | COMPONENT PRICE THAT BSE SHOULD HAVE CHARGED CHRYSPAC
14669 | 6.8.2010 | 15138.11 | 3253.89 | 11884.22 |  |  | 11884.22
KEY FOR CALCULATING THE LABOR ONLY ON EACH ASSEMBLY |  |  |  |  |  | KEY FOR CALCULATING BSE'S INVOICE
P/N | Item Name | CHRYSPAC Labor Price Only | # Made | Our Total Labor Price |  | BSE Component price for full Assembly Only | BSE Component Price only | # Made | What BSE should be charging CHRYSPAC
144-0001 | 3/8" [NAME] | 5.13 | 220 | 1128.6 | 1 | 14.36 | 9.23 | 220 | 2030.6
144-0005 | [NAME] | 7.63 |  | 0 |  | 18.83 | 11.2 | 0 | 0
144-0001 | REWORKED 3/8" [NAME] | 3.39 |  | 0 |  |  | -3.39 | 0 | 0
144-0005 | [NAME] | 4.1 |  | 0 |  |  | -4.1 | 0 | 0
144-0007 | 25kv 8' Cross Arm | 17.11 | 90 | 1539.9 |  | 68.81 | 51.7 | 90 | 4653 |  | 6192.900000000001
144-0008 | 27kv Cut Outs | 7.83 | 53 | 414.99 |  | 86.37 | 78.54 | 53 | 4162.62
144-0014 | 10' Xarm | 11.36 | 15 | 170.4 |  | 80.56 | 69.2 | 15 | 1038
144-0022 | Pedestal | 14.14 |  | 0 |  | 120.48 | 106.34 | 0 | 0
144-0028 | 3-6kv Arrester | 23.3 |  | 0 |  | 212.57 | 189.27 | 0 | 0
144-0030 | 3-10kv Arrester | 23.3 |  | 0 |  | 227.27 | 203.97 | 0 | 0
144-0034 | 3-18kv Arrester | 23.3 |  | 0 |  | 244.85 | 221.55 | 0 | 0
0135-9703WE | # 6 Wire Tie (37 pieces per bundle) | 3.5 |  | 0 |  | 5.07 | 1.57 | 0 | 0
0135-9657WE | # 8 Wire Tie (50 pcs per bundle) | 4.63 |  | 0 |  | 5.39 | 0.7599999999999998 | 0 | 0
180-4400 | Wood Stakes | 0.78 |  | 0 |  | 5.83 | 5.05 | 0 | 0
0136-9831 | [NAME] cover, Warning Label | 0.063 |  | 0 |  | 1.72 | 1.657 | 0 | 0
0136-9833 | [NAME] cover, Warning Label | 0.063 |  | 0 |  | 1.75 | 1.687 | 0 | 0
74-4000 | Gas [NAME] | 7.32 |  | 0 |  |  | -7.32 | 0 | 0
CHRYSTAG | 2x6 with [NAME] | 0.11 |  | 0 |  | 5.41 | 5.3 | 0 | 0
CHRYSWARNSGN | Hi Voltage Sign | 0.22 |  | 0 |  | 4.28 | 4.06 | 0 | 0
CHRYS4TRAY | Tray- 4 place | 0.11 |  | 0 |  | 4.03 | 3.92 | 0 | 0
CHRYSJUMPER | # 4, 7 strnd with lug | 0.47 |  | 0 |  | 4.54 | 4.07 | 0 | 0
 |  |  | SUM | 3253.89 |  |  |  | SUM | 11884.22
Spreadsheet: 56489a3c-f92f-406d-9109-8685c7ab5b05
Sheet: Sheet1

Name [NAME]: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Denominazione dell'Ente
[NAME]:  [NAME] gemäß L.G.  vom 5. März 2001, Nr. 7. -  Rechnungsaufstellung
[NAME]: rendicontazione contributo ai sensi della L.P. 5  marzo 2001, n. 7 - Elenco fatture
 |  | Initiative/Iniziativa Nr.
[NAME]. |  | vom |  | zugelassener Beitrag € |  |  |  | Vorschuss 50% €
[NAME] |  | del |  | somma ammessa € |  |  |  | Anticipo 50% €
[NAME] | [NAME]. Fattura n. | Datum Data | Steuer- grundlage | Mehrwerts- steuer | Gesamt- betrag | Zahlungsanordnung - Zahlungsnachweis
 |  |  | Imponibile | IVA | Totale fattura | [NAME] di pagamento
Gesamtbetrag / Totale fatture
Datum: |  |  |  | Der Vorsitzende /Präsident
Data: |  |  |  | [NAME]
Spreadsheet: 737369d1624374356-rotating-schedule-with-multiple-criteria-cps-2
Sheet: DaysOff

Days Off: Vacation, Sick, Personal, Bereavement, Compensation
Date | Employee | Type | Lookup Value |  | V = Vacation
 |  |  |  |  | S = Sick Leave
 |  |  |  |  | B = Bereavement
 |  |  |  |  | C = Compensation
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 11a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 466 |  | 466
 | FRA | 9504 |  | 9504
 | Exotic
 | Inflation
 | IRS- [NAME] | 28816 |  | 28816
 | OIS | 1712 |  | 1712
 | VNS | <100 |  | <100
 | Zero Coupon | 138 |  | 138
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 40636 | N/A*** | 40636
Estimated swap transaction volumes, week ending August 16, by product type and tenor (number of trades), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: daren_farmer__6575__Cilco
Sheet: dec for cilco

 |  |  |  | CILCO CONTACTS:
 |  |  |  | [NAME]
CILCO STORAGE |  |  |  | PH: (309) 677-5166
 |  |  |  | VONDA SECKLER
BEG. BALANCE |  | 2000000 |  | PH:  (309) 677-5164
 |  |  |  | FAX: (309) 677-5506
NOM. | REC | DEL.
EFF. DATE | VOLUME | VOLUME | STORAGE BAL.
1997-12-01 00:00:00 | 14845 | 14400
1997-12-02 00:00:00 | 14845 | 14400
1997-12-03 00:00:00 | 14845 | 14400
1997-12-04 00:00:00 | 14845 | 14400
1997-12-05 00:00:00 | 14845 | 14400
1997-12-06 00:00:00 | 14845 | 14400
1997-12-07 00:00:00 | 14845 | 14400
1997-12-08 00:00:00 | 14845 | 14400
1997-12-09 00:00:00 | 14845 | 14400
1997-12-10 00:00:00 | 28866 | 28000
1997-12-11 00:00:00 | 28866 | 28000
1997-12-12 00:00:00 | 11340 | 11000
1997-12-13 00:00:00 | 11340 | 11000
1997-12-14 00:00:00 | 11340 | 11000
1997-12-15 00:00:00 | 11340 | 11000
1997-12-16 00:00:00 | 11340 | 11000
1997-12-17 00:00:00 | 11340 | 11000
1997-12-18 00:00:00 | 11340 | 11000
1997-12-19 00:00:00 | 11340 | 11000
1997-12-20 00:00:00 | 11340 | 11000
1997-12-21 00:00:00 | 15155 | 14700
1997-12-22 00:00:00 | 15155 | 14700
1997-12-23 00:00:00 | 15155 | 14700
1997-12-24 00:00:00 | 15155 | 14700
1997-12-25 00:00:00 | 15155 | 14700
1997-12-26 00:00:00 | 15155 | 14700
1997-12-27 00:00:00 | 15155 | 14700
1997-12-28 00:00:00 | 15155 | 14700
1997-12-29 00:00:00 | 15155 | 14700
1997-12-30 00:00:00 | 17010 | 16500
1997-12-31 00:00:00 | 17010 | 16500
Spreadsheet: mark_taylor__25000__FLag Football  Roster
Sheet: DEF (2)

DEFENSE
 |  |  | R |  | R
 |  |  | Huy |  | Eddie/Bao
 |  |  |  |  |  |  |  |  | 25
OLB-L |  |  | MLB-L |  | MLB-R |  |  | OLB-R
[NAME] |  |  | [NAME] |  | [NAME] |  |  | Scott
 |  |  |  |  |  |  |  |  | 20
 |  |  | S-L |  | S-R
 |  |  | [NAME] |  | Long
 |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 5
Spreadsheet: 109149d1306082577-if-contains-mx-basic-example
Sheet: DATA

Section Type | [NAME] | MarketPair | Market Pair Name | Total Flights | % of Flights | X Flights | X MS | Total Rev | X Rev | X Rev % | MX
Carrier | [NAME] | DTW-RDU | Detroit, MI-Raleigh/Durham, NC | 300 | 0.0604351329572925 | 250 | 0.8333333333333334 | 100000 | 50000 | 0.05883294268259392 | 0
Carrier | [NAME] | BJX-RDU | Guanajuato, MX-Raleigh/Durham, NC | 299 | 0.06023368251410153 | 249 | 0.8327759197324415 | 99999 | 49999 | 0.05883176602374027 | 1
Carrier | North America-North America | DFW-STL | Dallas-DFW, TX-St. Louis, MO | 298 | 0.06003223207091055 | 248 | 0.8322147651006712 | 99998 | 49998 | 0.05883058936488662 | 0
Carrier | North America-North America | DTW-FRA | Detroit, MI-Frankfurt Main, DE | 297 | 0.05983078162771958 | 247 | 0.8316498316498316 | 99997 | 49997 | 0.05882941270603297 | 0
Carrier | North America-North America | DTW-LHR | Detroit, MI-London Heathrow, UK | 296 | 0.05962933118452861 | 246 | 0.831081081081081 | 99996 | 49996 | 0.05882823604717932 | 0
Carrier | North America-North America | DTW-PHL | Detroit, MI-Philadelphia, PA | 295 | 0.05942788074133763 | 245 | 0.8305084745762712 | 99995 | 49995 | 0.05882705938832566 | 0
Carrier | North America-North America | BJX-DTW | Guanajuato, MX-Detroit, MI | 294 | 0.05922643029814666 | 244 | 0.8299319727891157 | 99994 | 49994 | 0.05882588272947201 | 1
Carrier | North America-North America | DTW-ORD | Detroit, MI-Chicago-O'Hare, IL | 293 | 0.05902497985495568 | 243 | 0.8293515358361775 | 99993 | 49993 | 0.05882470607061836 | 0
Carrier | North America-North America | DTW-SDF | Detroit, MI-Louisville, KY | 292 | 0.05882352941176471 | 242 | 0.8287671232876712 | 99992 | 49992 | 0.05882352941176471 | 0
Carrier | North America-North America | LHR-SAN | [NAME], UK-San Diego, CA | 291 | 0.05862207896857373 | 241 | 0.8281786941580757 | 99991 | 49991 | 0.05882235275291105 | 0
Carrier | HUB | BDL-MGM | Hartford, CT-Montgomery, AL | 290 | 0.05842062852538275 | 240 | 0.8275862068965517 | 99990 | 49990 | 0.0588211760940574 | 0
Carrier | HUB | BNA-DTW | Nashville, TN-Detroit, MI | 289 | 0.05821917808219178 | 239 | 0.8269896193771626 | 99989 | 49989 | 0.05881999943520375 | 0
Carrier | HUB | CLT-DTW | Charlotte, NC-Detroit, MI | 288 | 0.05801772763900081 | 238 | 0.8263888888888888 | 99988 | 49988 | 0.0588188227763501 | 0
Carrier | Latin America-North America | DFW-MGM | Dallas-DFW, TX-Montgomery, AL | 287 | 0.05781627719580983 | 237 | 0.8257839721254355 | 99987 | 49987 | 0.05881764611749644 | 0
Carrier | Detroit | BDL-CVG | Hartford, CT-Cincinnati, OH | 286 | 0.05761482675261886 | 236 | 0.8251748251748252 | 99986 | 49986 | 0.05881646945864279 | 0
Carrier | Detroit | POA-RDU | [NAME], BR-Raleigh/Durham, NC | 285 | 0.05741337630942788 | 235 | 0.8245614035087719 | 99985 | 49985 | 0.05881529279978914 | 0
Carrier | Detroit | FNT-RDU | Flint, MI-Raleigh/Durham, NC | 284 | 0.05721192586623691 | 234 | 0.823943661971831 | 99984 | 49984 | 0.05881411614093549 | 0
 |  |  | Totals | 4964 |  | 4114 | 0.8287671232876712 | 1699864 | 849864
Spreadsheet: 010bd8ca-67ab-4c8b-bc56-89a2c05b28c4
Sheet: Sheet1

2012-01-10 00:00:00 | Unnamed: 1 | PRESIDENT OF THE UNITED STATES - DEMOCRATIC | 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 |  | Unnamed: 17
 |  |  |  | Center       Harbor |  |  | [NAME] | [NAME] | [NAME] 3 | [NAME] | [NAME] | [NAME] 6
BELKNAP COUNTY | Alton | Barnstead | Belmont |  | Gilford | Gilmanton |  |  |  |  |  |  | Meredith | New Hampton | Sanbornton | [NAME] | TOTALS
[NAME], d | 1 | 4 | 3 | 1 | 3 | 0 | 1 | 2 | 0 | 1 | 1 | 1 | 4 | 1 | 2 | 0 | 25
Tyler, d | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 5
Wolfe, Jr., d | 3 | 1 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 11
Cowan, d | 4 | 9 | 6 | 1 | 4 | 1 | 3 | 4 | 2 | 0 | 2 | 1 | 2 | 4 | 2 | 6 | 51
[NAME], d | 2 | 0 | 2 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 12
Freis, d | 3 | 2 | 3 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 23
Greene, d | 1 | 1 | 1 | 0 | 2 | 0 | 3 | 0 | 1 | 0 | 1 | 2 | 2 | 0 | 1 | 0 | 15
Haywood, d | 0 | 0 | 2 | 0 | 3 | 1 | 1 | 0 | 0 | 2 | 2 | 1 | 2 | 1 | 0 | 5 | 20
Jordan, d | 0 | 0 | 3 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 2 | 11
Obama, d | 126 | 132 | 192 | 49 | 281 | 166 | 113 | 103 | 116 | 107 | 97 | 112 | 319 | 123 | 157 | 153 | 2346
O'Connor, d | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 1 | 2 | 9
O'Donnell, Jr., d | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 1 | 0 | 2 | 0 | 2 | 0 | 0 | 3 | 1 | 15
[NAME], d | 1 | 3 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 2 | 3 | 0 | 2 | 0 | 1 | 3 | 18
Supreme, d | 3 | 3 | 3 | 1 | 1 | 2 | 0 | 2 | 1 | 0 | 2 | 2 | 2 | 1 | 3 | 4 | 30
Spreadsheet: 863711d1711110775-count-no-of-persons-with-multiple-conditions-count-with-multiple-conditions
Sheet: Summary

 | Date: | 1
S. No. | Department | A | B | C | G | (blank)
1 | SHEAR
2 | BEAMWELDING
3 | DETAILS
4 | FABRICATION
5 | STRUCTURAL
6 | WELDING
7 | CLEARING
8 | BLASTING
9 | PAINTING
10 | COLDFORM
11 | PACKING
13 | SHEETING
14 | RACKING
15 | MAINTENANCE
16 | ELECTRICAL
17 | Q.C
18 | STORES
19 | WAREHOUSE
20 | SHIPPING
21 | CIVIL
23 | IR
24 | PLANT OFFICE
28 | KSS MACHINE OPERATOR
 |  | 422 | 344 | 236 | 17 | 199
Need formula in C3 to F25, to count No. of persons based on Date, Shift and Dept. from Sheet1.
Spreadsheet: 0398cca4-38d4-4394-97bb-62f8b60aeaa2
Sheet: Sheet1

store | websites | attribute_set | type | category_ids | [NAME] | has_options | name | meta_title | meta_description | image | small_image | thumbnail | url_key | url_path | custom_design | page_layout | options_container | country_of_manufacture | msrp_enabled | msrp_display_actual_price_type | gift_message_available | weight | price | special_price | msrp | status | is_recurring | visibility | enable_googlecheckout | tax_class_id | description | short_description | meta_keyword | custom_layout_update | special_from_date | special_to_date | news_from_date | news_to_date | custom_design_from | custom_design_to | qty | min_qty | use_config_min_qty | is_qty_decimal | backorders | use_config_backorders | min_sale_qty | use_config_min_sale_qty | max_sale_qty | use_config_max_sale_qty | is_in_stock | low_stock_date | notify_stock_qty | use_config_notify_stock_qty | manage_stock | use_config_manage_stock | stock_status_changed_auto | use_config_qty_increments | qty_increments | use_config_enable_qty_inc | enable_qty_increments | is_decimal_divided | stock_status_changed_automatically | use_config_enable_qty_increments | product_name | [NAME] | product_type_id | product_status_changed | product_changed_websites
admin | base | Default | simple | 3,4 | SKU899 | 0 | TEST1 |  |  |  |  |  | test1 | test1.html |  | No layout updates | Block after [NAME] |  | Use config | Use config | No | 72 | 799 |  |  | Enabled | No | Catalog, Search | Yes |  | this is test prod | this is test prod |  |  |  |  |  |  |  |  | 100 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 |  |  | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | TEST1 | 0 | simple
admin | base | Default | simple | 3,4 | SKU78999 | 0 | TEST2 |  |  |  |  |  | test2 | [NAME] |  | No layout updates | Block after [NAME] |  | Use config | Use config | No | 89 | 896 |  |  | Enabled | No | Catalog, Search | No |  | TEST2 | TEST2 |  |  |  |  |  |  |  |  | 100 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 |  |  | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | TEST2 | 0 | simple
Spreadsheet: 46460d1245321128-check-duplicate-missing-number-missing-numbers
Sheet: Sheet1

 | Range |  |  |  | Orders | Result |  | Missing
Start | 100 |  |  |  | 100 | Invoiced |  | 101
Finish | 110 |  |  |  | 104 | duplicate |  | 108
 |  |  |  |  | 103 | Invoiced
 |  |  |  |  | 102 | Invoiced
 |  |  |  |  | 104 | duplicate
 |  |  |  |  | 105 | Invoiced
 |  |  |  |  | 106 | Invoiced
 |  |  |  |  | 107 | Invoiced
 |  |  |  |  | 109 | Invoiced
 |  |  |  |  | 110 | Invoiced
Spreadsheet: 166715d1341752030-extracting-group-headings-book1
Sheet: Sheet1

Before:
Birthdays
1944-12-06 00:00:00
1923-07-05 00:00:00
1994-09-08 00:00:00
Anniversaries
1984-12-01 00:00:00
1999-07-07 00:00:00
04/03/20004
2012-05-06 00:00:00
Red-letter days
1988-05-04 00:00:00
After
1944-12-06 00:00:00 | Birthdays
1923-07-05 00:00:00 | Birthdays
1994-09-08 00:00:00 | Birthdays
1984-12-01 00:00:00 | Anniversaries
1999-07-07 00:00:00 | Anniversaries
04/03/20004 | Anniversaries
2012-05-06 00:00:00 | Anniversaries
1988-05-04 00:00:00 | Red-letter days
Spreadsheet: 156500d1337324571-golf-handicap-handicapps
Sheet: Sheet1

36
Social Golf Club
Handicapp Deductions |  |  |  |  | Handicapps Updated |  |  |  |  |  | 2009-05-25 00:00:00
36 to 27 -.5      26 to 20 -.4 |  |  |  |  | 2009-02-28 00:00:00
19 to 13 -.3      12 to 5  -.2 |  |  | Rating |  | Last Game | Round | 2
4 to 0 -.1 |  |  | 36 |  | Stableford
Name | H,Capp | Actual |  |  | Name | H,Capp | Actual
R MORGAN | 23 | 23 | 58 |  | Player 31 | 18 | 18 |  |  |  |  |  | Single Stroke
 |  |  |  |  |  |  |  |  |  |  |  |  | 1st Round Championships
S STRATTON | 18 | 17.5 | 47 |  | Player 32 | 18 | 18 |  |  |  |  |  | 2nd Round championships
 |  |  |  |  |  |  |  |  |  |  |  |  | 3rd Round Championships
C GARCIA | 17 | 17.4 | 45 |  | Player 33 | 18 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | Stableford
R PEARSON | 19 | 19 | 50 |  | Player 34 | 18 | 18 |  |  |  |  |  | Stroke
J GOTTAS HEALEY | 15 | 15 | 41 |  | Player 35 | 18 | 18
D CARNEY | 22 | 22 | 30 |  | Player 36 | 18 | 18
G CARNEY | 11 | 11.1 | 22 |  | Player 37 | 18 | 18
R NABBE | 10 | 9.599999904632568 | 44 |  | Player 38 | 18 | 18
G CAMPION | 9 | 9.2 | 88 |  | Player 39 | 18 | 18
C DAVIS | 13 | 13 |  |  | Player 40 | 18 | 18
G EDWARDS | 17 | 17 |  |  | Player 41 | 18 | 18
T HEALEY | 16 | 16 |  |  | Player 42 | 18 | 18
E O'DONNELL | 12 | 12 |  |  | Player 43 | 18 | 18
M BRACKENBRIDGE | 9 | 9 |  |  | Player 44 | 18 | 18
S WESTAWAY | 13 | 13 |  |  | Player 45 | 18 | 18
D FRITH | 26 | 26 |  |  | Player 46 | 18 | 18
B BRUCE | 22 | 22 |  |  | Player 47 | 18 | 18
A LEWIS | 27 | 27 |  |  | Player 48 | 18 | 18
J CHARLESWORTH | 14 | 14 |  |  | Player 49 | 18 | 18
P RYAN | 24 | 24 |  |  | Player 50 | 18 | 18
J BURSTON | 15 | 15 |  |  | Player 51 | 18 | 18
Player 22 | 18 | 18 |  |  | Player 52 | 18 | 18
Player 23 | 18 | 18 |  |  | Player 53 | 18 | 18
Player 24 | 18 | 18 |  |  | Player 54 | 18 | 18
Player 25 | 18 | 18 |  |  | Player 55 | 18 | 18
Player 26 | 18 | 18 |  |  | Player 56 | 18 | 18
Player 27 | 18 | 18 |  |  | Player 57 | 18 | 18
Player 28 | 18 | 18 |  |  | Player 58 | 18 | 18
Player 29 | 18 | 18 |  |  | Player 59 | 18 | 18
Player 30 | 18 | 18 |  |  | Player 60 | 18 | 18
Spreadsheet: 182347d1348443621-date-counting-items-sumifs-by-date-and-name
Sheet: example.csv

Description | Sales Tax | Date Sold | Sum by Date | Sum by Date and Name | Count by Date | Count by Date and Name
jumper | 0.25 | 2012-06-18 00:00:00
jumper | 1.3333 | 2012-06-18 00:00:00
socks | 1.6583 | 2012-06-18 00:00:00 |  |  |  |  | <----Name has no space at the end
socks | 1.3333 | 2012-06-18 00:00:00 |  |  |  |  | <----Name has space at the end
tee | 5.8333 | 2012-06-18 00:00:00
hood | 2 | 2012-06-18 00:00:00
jumper | 3.325 | 2012-06-19 00:00:00
jumper | -3.325 | 2012-06-19 00:00:00
socks | 3.325 | 2012-06-19 00:00:00 |  |  |  |  | <----Name has no space at the end
socks | 3.325 | 2012-06-19 00:00:00 |  |  |  |  | <----Name has space at the end
tee | 2 | 2012-06-19 00:00:00
hood | 3.3333 | 2012-06-19 00:00:00
jumper | -10.8333 | 2012-06-19 00:00:00
jumper | 10.8333 | 2012-06-19 00:00:00
socks | 0 | 2012-06-19 00:00:00
Spreadsheet: 034af40e-e6d4-464e-bff2-7b09b12e5c9d
Sheet: Capital Equip Depreciation

Service Center Calculations
DEPRECIATION OF EQUIPMENT > $5,000
The purpose of this sheet is to track depreciation costs of capitalized equipment used to provide the service(s)
If you have any questions about the accounting for equipment >$5,000 for this service center, please contact the Controller's Office
Sheet instructions
Fill in only yellow highlighted areas in both sections as applicable
Column J - Identify the % of use of the equipment for each service
Add additional lines as needed
SERVICE CENTER EQUIPMENT INFORMATION
 |  |  |  |  |  |  |  |  | SERVICE 1 |  | SERVICE 2
Depreciation Schedule - List existing allowable equipment only*
Desc/Type of Equipment | UI Property Tag# | Acquisition Budget No. | Acquistion Date | Depr Start Date | Depr End Date | Acquisition Cost | Useful Life (years) | Annual depreciation | % | Amount | % | Amount
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0
TOTAL ALLOWED DEPRECIATION
SUBSIDY - AMOUNT THAT WILL NOT BE INCLUDED IN RATE CALCULATIONS |  |  |  |  |  |  |  | 0 | 0 |  | 0
TOTAL DEPRECIATION TO BE INCLUDED IN SERVICE CENTER COSTS
*Unallowable equipment replacements include equipment originally purchased on a grant or purchases of new equipment not previously in use by the service center.
 |  |  |  |  | Percentage of Use
 |  |  |  |  | SERVICE 1 | SERVICE 2
Other Equipment Used to Provide Service But Not Included in the Costs
Desc/Type of Equipment | U of I Tag Number | Acquisition Budget No. | Acquistion Date | Acquisition Cost | % | %
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
Spreadsheet: 158008d1337952781-finding-out-the-pair-of-points-location-with-minimum-distances-closest-2-points
Sheet: Sheet1

 |  |  |  | Pt# | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  | X | 4 | 5 | 7 | 2 | 5 | 1 | 7
Pt# | X | y |  | y | 1 | 3 | 8 | 4 | 1 | 6 | 4
1 | 4 | 1
2 | 5 | 3
3 | 7 | 8
4 | 2 | 4
5 | 5 | 1
6 | 1 | 6
7 | 7 | 4
 |  | Example Problem Above
 |  | Point 5 and 8 are closest to each other.
Spreadsheet: 77805d1278316030-summing-several-amounts-of-worksheets-in-one-workbook-and-in-multiple-workbooks-sumsheets
Sheet: Table3

14 | 42 | 40 | 21 | 39 | 10 | 50 | 50 |  | Total | 7287
43 | 46 | 16 | 46 | 49 | 40 | 40 | 49
28 | 33 | 46 | 15 | 20 | 42 | 26 | 34
10 | 13 | 30 | 46 | 28 | 40 | 11 | 10
24 | 19 | 29 | 41 | 42 | 40 | 36 | 48
20 | 44 | 30 | 44 | 29 | 31 | 25 | 19
32 | 15 | 38 | 47 | 48 | 49 | 10 | 48
50 | 15 | 27 | 10 | 28 | 36 | 16 | 45
21 | 11 | 10 | 40 | 12 | 45 | 12 | 31
37 | 31 | 11 | 37 | 14 | 43 | 27 | 14
44 | 28 | 15 | 41 | 33 | 44 | 36 | 11
14 | 31 | 23 | 41 | 45 | 13 | 10 | 21
17 | 24 | 45 | 29 | 35 | 19 | 13 | 25
56 | 14 | 19 | 15 | 41 | 40 | 30 | 29
26 | 25 | 19 | 11 | 33 | 49 | 26 | 47
26 | 29 | 21 | 46 | 32 | 41 | 16 | 17
25 | 12 | 16 | 37 | 15 | 41 | 25 | 48
47 | 19 | 23 | 46 | 28 | 25 | 18 | 34
42 | 48 | 48 | 26 | 27 | 36 | 18 | 10
22 | 50 | 39 | 25 | 11 | 46 | 48 | 40
37 | 45 | 47 | 16 | 42 | 46 | 19 | 50
13 | 31 | 42 | 39 | 37 | 32 | 37 | 28
27 | 23 | 35 | 39 | 16 | 30 | 32 | 24
24 | 27 | 41 | 49 | 25 | 18 | 38 | 32
48 | 26 | 42 | 30 | 21 | 17 | 21 | 25
50 | 24 | 44 | 23 | 46 | 41 | 45 | 13
45 | 25 | 43 | 11 | 37 | 42 | 43 | 20
10 | 13 | 20 | 28 | 29 | 46 | 12 | 14
14 | 43 | 24 | 16 | 40 | 41 | 46 | 49
34 | 24 | 30 | 13 | 12 | 42 | 36 | 10