tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 717280d1612551883-help-in-calculation-and-filter-help-in-calculation
Sheet: Data

Site | Date | Month | Year | Totalbatches | TotalRejection | Rejection Rate
Texas | 2019-12-01 00:00:00 | 12 | 2019 | 4 | 0
Boston | 2019-12-01 00:00:00 | 12 | 2019 | 5 | 4
Chicago | 2019-12-01 00:00:00 | 12 | 2019 | 6 | 0
New Jersey | 2019-12-01 00:00:00 | 12 | 2019 | 1 | 4
Chicago | 2020-01-01 00:00:00 | 1 | 2020 | 90 | 7
New Jersey | 2020-01-01 00:00:00 | 1 | 2020 | 6 | 5
New York | 2020-01-01 00:00:00 | 1 | 2020 | 0 | 3
Philadelphia | 2020-02-01 00:00:00 | 2 | 2020 | 10 | 0
Maryland | 2020-02-01 00:00:00 | 2 | 2020 | 15 | 2
Delawar | 2020-03-01 00:00:00 | 3 | 2020 | 30 | 0
Texas | 2020-03-01 00:00:00 | 3 | 2020 | 4 | 0
Boston | 2020-04-01 00:00:00 | 4 | 2020 | 3 | 0
Chicago | 2020-04-01 00:00:00 | 4 | 2020 | 7 | 2
New Jersey | 2020-05-01 00:00:00 | 5 | 2020 | 8 | 3
New York | 2020-05-01 00:00:00 | 5 | 2020 | 30 | 1
Philadelphia | 2020-06-01 00:00:00 | 6 | 2020 | 15 | 5
Ohio | 2020-06-01 00:00:00 | 6 | 2020 | 2 | 0
Maryland | 2020-06-01 00:00:00 | 6 | 2020 | 7 | 2
Delawar | 2020-07-01 00:00:00 | 7 | 2020 | 5 | 0
Texas | 2020-07-01 00:00:00 | 7 | 2020 | 4 | 0
Boston | 2020-08-01 00:00:00 | 8 | 2020 | 3 | 0
Chicago | 2020-08-01 00:00:00 | 8 | 2020 | 7 | 2
New Jersey | 2020-09-01 00:00:00 | 9 | 2020 | 8 | 3
New York | 2020-09-01 00:00:00 | 9 | 2020 | 2 | 1
Philadelphia | 2020-09-01 00:00:00 | 9 | 2020 | 5 | 5
Ohio | 2020-10-01 00:00:00 | 10 | 2020 | 10 | 0
Maryland | 2020-10-01 00:00:00 | 10 | 2020 | 15 | 2
Delawar | 2020-11-01 00:00:00 | 11 | 2020 | 5 | 0
Texas | 2020-11-01 00:00:00 | 11 | 2020 | 4 | 0
Boston | 2020-12-01 00:00:00 | 12 | 2020 | 3 | 0
Chicago | 2020-12-01 00:00:00 | 12 | 2020 | 7 | 2
New Jersey | 2020-12-01 00:00:00 | 12 | 2020 | 8 | 3
New York | 2020-12-01 00:00:00 | 12 | 2020 | 3 | 1
Philadelphia | 2020-12-01 00:00:00 | 12 | 2020 | 1 | 5
Spreadsheet: 23559d1213114185-filter-row-using-date-and-column-using-null-cells-filter-by-date-and-null-cell
Sheet: Sheet1

 |  |  | Drawing No.
 |  |  | 00001 | 00002 | 00003 | 00004 | 00005 | 00006 | 00007 | 00008 | 00009 | 00010 | 00011 | 00012 | 00013 | 00014 | 00015 | 00016 | 00017 | 00018
Day | Month | Year | General Arrangement | Reinforced Concrete Outlines | RC Details | Steelwork Details | Steelwork Details Sht 2 | Steelwork Details Sht 3 | Steelwork Details Sht 4 | Steelwork Details Sht 5 | Steelwork Details Sht 6 | Steelwork Details Sht 7 | Steelwork Details Sht 8 | Steelwork Details Sht 9 | Steelwork Details Sht 10 | Steelwork Details Sht 11 | Steelwork Details Sht 12 | Steelwork Details Sht 13 | Steelwork Details Sht 14 | Steelwork Details Sht 15
02 | 05 | 08 | C01 | C01
05 | 05 | 08 | C02 | C02 |  |  |  | C02 |  |  |  | C02 |  | C02 |  | C02 |  |  |  | C02
11 | 05 | 08 |  | C05 |  |  | C05 |  |  | C05 |  |  |  |  |  |  |  |  | C02
13 | 05 | 08 |  |  |  |  |  |  |  |  |  |  |  |  | C02 |  |  |  | C02
18 | 05 | 08 |  |  |  |  |  |  |  |  |  |  | C02 |  |  |  |  | C02
20 | 05 | 08 |  |  |  |  | C02 |  |  | C02 |  |  |  |  | C02 |  |  |  |  | C02
23 | 05 | 08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C02
24 | 05 | 08 |  |  |  |  |  |  |  |  |  | C02 |  |  |  | C02
25 | 05 | 08 |  |  | C02 |  |  | C02 |  | C02 |  | C02 |  |  | C02
27 | 05 | 08 |  |  |  |  |  | C02 |  |  |  |  |  |  |  |  |  |  | C02
28 | 05 | 08 |  |  | C02 |  |  |  |  |  | C02 |  |  |  |  | C02 |  | C02
Spreadsheet: debra_perlingiere__8440__list for Debra
Sheet: Sheet1

Entity | Holding Company
Interstate Power Company | Alliant Energy
Madison Gas & Electric Co. | Madison Gas & Electric Co.
Northern States Power Company | [NAME]
South Beloit Water | Alliant Energy
Superior Water, Light and Power | Allete
Wisconsin Electric Power Company
Wisconsin Fuel & Light Co. | WPS Resources Corp
Wisconsin Gas Company | Wisconsin Energy Corp
Wisconsin Power and Light Company | Alliant Energy
Wisconsin Public Service Corporation | WPS Resources Corp
WPS Energy Services Inc. | WPS Resources Corp
City Gas Co. | Master Gas Service
Midwest Natural Gas | Midwest Bottle Gas Co.
St. Croix Valley
Heartland Energy Group | Alliant Energy
GEN SYS Energy
Griffin Energy Marketing, L.L.C.
Kaztex Energy Management, Inc.
WICOR Energy Services
Wisconsin Public Power Inc.
American National Can Co. | Pechiney Corp
American Tissue Mills | American Tissue Mills
Appleton Papers Inc. | Appleton Papers Inc.
Associated Milk Producers | Associated Milk Producers
Badger Paper Mills Inc. | Badger Paper Mills Inc.
Ball-Foster Glass Container Co. | Pechiney Corp
Charter Manufacturing Co. | Charter Manufacturing Co.
Consolidated Papers Inc. | Consolidated Papers Inc.
Cudahy Partick Inc. | Smithfield Foods Inc
Falk Corp. | Sunstrand Corp
Fort James Corp. | Fort James Corp
General Motors Corp | General Motors Corp
Glatfelter P H Co. | Glatfelter P H Co.
Globe Building Materials Inc. | Globe Building Materials Inc.
Grede Foundries Inc. | Grede Foundries Inc.
[NAME] | [NAME]
Johnson S C & Sons Inc. | Johnson S C & Sons Inc.
Kerry Ingredients Inc. | Kerry Ingredients Inc.
Kimberly-Clark Corp. | Kimberly-Clark Corp.
Kohler Co. | Kohler Co.
Ladish Co. Inc. | Fulcrum II Limited Partnership
Land O'Lakes Inc. | Land O'Lakes Inc.
Little Rapids Corp. | Little Rapids Corp.
McCain Foods USA | HJ Heinz Corp
Mead Corp. | Mead Corp.
Modine Inc. | [NAME]
Navistar International Corp. | Navistar International Corp.
Noranda Inc. | Noranda Inc.
P&H Mining Equipment Division | Harnischfeger Industries
Rhinelander Paper Co. Inc. | Wausau Paper Mills Co.
Pope & Talbot Wis. Inc. | Pope & Talbot Wis. Inc.
Repap Wisconsin Inc. | Repap USA Inc
Riverside Paper Corp. | Riverside Paper Corp.
Stroh Brewing Co. | Heileman G Brewing Co
Swiss Colony Inc. | Swiss Colony Inc.
Swiss Miss | [NAME]
Tower Automotive Inc. | Tower Automotive Inc.
U.S. Paper Mills Corp. | U.S. Paper Mills Corp.
Watry Industries Inc. | Watry Industries Inc.
Wausau Paper Mills Co. | Wausau Paper Mills Co.
Western Industries Inc. | Exor America Inc
Weyerhaeuser Co. | Weyerhaeuser Co.
Wisconsin Paperboard Corp. | Wisconsin Paperboard Corp.
Wisconsin Tissue Mills Inc. | [NAME]
Spreadsheet: 834969d1688202232-parsing-table-from-web-removing-text-to-get-the-numbers-s666-pq-global-sqm-prices-by-country
Sheet: Sheet1

Country/City | Buying Price US $ per Sq. M. | Price/Rent Ratio (x) | Rent per Month ($ or €) | [NAME] Yield
Hong Kong | 23695 | 36 | $ 2,149 | 0.0278
Singapore | 16120 | 21 | $ 5,075 | 0.0474
United Kingdom | 15125 | 16 | € 1,999 | 0.0621
France | 14808 | 25 | € 1,441 | 0.0397
Israel | 13820 | 30 | $ 1,615 | 0.033
Taiwan | 10955 | 48 | $ 984 | 0.0209
Luxembourg | 9826 | 35 | € 2,550 | 0.0284
Switzerland | 9759 | 34 | € 1,714 | 0.0294
Australia, Sydney | 9700 | 19 | $ 2,436 | 0.0523
Netherlands | 9075 | 20 | € 1,530 | 0.049
Norway | 8648 | 28 | € 1,278 | 0.0362
Sweden | 8514 | 22 | € 1,518 | 0.0463
Japan | 8360 | 23 | $ 739 | 0.0438
Denmark | 8116 | 30 | € 1,516 | 0.0328
Italy | 8030 | 16 | € 1,237 | 0.0626
Ireland | 7312 | 14 | € 1,988 | 0.0738
New Zealand | 7180 | 27 | $ 1,250 | 0.0364
Austria | 6367 | 31 | € 1,161 | 0.0318
Finland | 5874 | 24 | n.a. | 0.0416
Germany | 5585 | 32 | € 1,145 | 0.0312
United States | 5530 | 16 | $ 2,775 | 0.0612
Portugal | 5280 | 19 | € 1,243 | 0.052
Czech Republic | 5227 | 26 | € 928 | 0.0388
Canada | 4632 | 18 | $ 1,706 | 0.0546
United Arab Emirates | 4320 | 18 | $ 2,209 | 0.0563
Russia | 3969 | 16 | € 602 | 0.0612
Belgium | 3825 | 24 | € 956 | 0.0409
Croatia | 3784 | 24 | € 540 | 0.0419
Hungary | 3766 | 20 | € 454 | 0.049
Slovakia | 3652 | 22 | € 816 | 0.0463
Philippines | 3604 | 18 | $ 664 | 0.0545
St. Kitts | 3496 | 0 | n.a. | 0
Estonia | 3478 | 22 | € 842 | 0.0465
Slovenia | 3410 | 24 | € 716 | 0.0417
Andorra | 3322 | 19 | € 1,200 | 0.0521
US Virgin Islands | 3235 | 0 | n.a. | 0
Spain | 3212 | 18 | € 1,229 | 0.0557
Thailand | 3057 | 0 | $ 936 | 0
Brazil | 3000 | 19 | $ 619 | 0.0535
Poland | 2827 | 15 | € 865 | 0.0688
Chile | 2813 | 20 | $ 550 | 0.0498
Lithuania | 2801 | 13 | € 878 | 0.0781
Puerto Rico | 2700 | 13 | n.a. | 0.0789
Malta | 2554 | 22 | € 1,358 | 0.0455
Mexico | 2458 | 18 | $ 916 | 0.0548
Greece | 2450 | 18 | € 735 | 0.0541
India | 2429 | 23 | $ 302 | 0.0444
Vietnam/HCMC | 2280 | 23 | $ 672 | 0.0431
Serbia | 2255 | 18 | € 525 | 0.0556
Uruguay | 2215 | 18 | $ 747 | 0.0567
Panama | 2200 | 15 | $ 2,090 | 0.0668
Costa Rica | 2147 | 16 | $ 1,033 | 0.0636
Romania | 2090 | 16 | € 617 | 0.0616
Cyprus | 2035 | 21 | € 1,090 | 0.047
Turkey | 1955 | 18 | € 418 | 0.0563
Malaysia | 1772 | 21 | $ 430 | 0.0482
Argentina | 1745 | 18 | $ 627 | 0.0571
Colombia | 1700 | 16 | $ 398 | 0.064
South Africa | 1700 | 11 | $ 512 | 0.0906
Peru | 1616 | 18 | $ 938 | 0.0549
Bulgaria | 1568 | 21 | € 450 | 0.0474
Ecuador | 1550 | 17 | $ 1,094 | 0.0589
Montenegro | 1540 | 17 | € 633 | 0.058
Georgia | 1464 | 9 | $ 648 | 0.1073
Macedonia | 1406 | 19 | € 230 | 0.0536
Morocco | 1219 | 14 | $ 705 | 0.0723
Ukraine | 1133 | 13 | € 415 | 0.0743
Latvia | 1064 | 15 | € 690 | 0.0664
Indonesia | 1006 | 17 | $ 382 | 0.0575
Egypt | 831 | 19 | $ 443 | 0.0538
Spreadsheet: 250261d1373885893-clean-up-of-a-column-cleanup-sample
Sheet: Sheet1

Type | Product | Group | Name | Product Code | Description | Imag
Gifting | Drinkware | Waterbottles - Plastic | 1 Litre Tritan Water Bottle | BW0020 | <ul>     <[NAME]: arial; font-size: 13px;">BPA Free Tritan Material</span></li>     <[NAME]: arial; font-size: [NAME] Capacity</span></li>     <[NAME]: arial; font-size: 13px;">Stainle | 15622_Thumb.png
Gifting | Drinkware | Flasks | 1.8l Plastic Vacuum Flask | BW0042 | <ul>     <[NAME] Steel</li>     <li>225ml Capacity</li>     <li>Twist Top</li>     <li>Hinged Metal Safety Lid Connector</li> </ul> | 38305_Thumb.png
Gifting | Tools | Multi-Tools | 10 Function Stainless Pocket Knife | BT0001 | <ul>     <li>Includes:</li>     <[NAME]Knife</li>     <[NAME]Scissors</li>     <li>Can Opener</li>     <li>Phillips Head Screwdriver</li>     <[NAME] File</li>     <li>Punch</li>     <li>Corkscrew</li>     <[NAME] Ring</li>     <li>Flathead Screwdriver</li> | 14659_Thumb.png
Gifting | Leisure and Outdoor | Golf | 100% Cotton Golf Towel | BH0070 | <ul>     <li>100% [NAME] Towel</li>     <li>Metal Clip</li> </ul> | 38420_Thumb.png
Gifting | Office Accessories | Photo Frames | 10cm x 13cm Rounded Edge Photo Frame | BD0027 | <ul>     <[NAME]Rounded Outer Edge</li>     <li>Polished Aluminium</li>     <[NAME] Horizontal Or Vertical Display</li>     <[NAME] 10cm x 13cm Photo</li> </ul> | 15727_Thumb.png
Gifting | Office Accessories | Photo Frames | 10cm x 15cm Aluminium Photo Frame | BD0064 | <ul>     <[NAME] Finish</li>     <[NAME] 10cm x 15cm Photo</li> </ul> | 36544_Thumb.png
Gifting | Leisure and Outdoor | Coolers | 12 Can Cooler with 2 Exterior Pockets - 70D - PEVA Lining | BC0006 | <ul>     <li>Fully Insulated Main Compartment Holds 12 Cans</li>     <[NAME] PEVA Lining</li>     <[NAME] Pocket</li>     <li>Side Mesh Pocket</li>     <li>Adjustable Strap</li> </ul> | 14456_Thumb.png
Gifting | Drinkware | Decanters | 1240ml [NAME] and [NAME] | BW0029 | <ul>     <[NAME]: arial; font-size: 13px;">1240ml Decanter</span></li>     <[NAME]: arial; font-size: 13px;">Drinking Glass</span></li>     <[NAME]: arial; font-size: 13px;">Glass Serves As De | 30907_Thumb.png
Gifting | Tools | Multi-Tools | 12-in-1 Anodized Knife | BT0004 | <ul>     <li>Includes</li>     <[NAME]Knife</li>     <[NAME]Scissors</li>     <[NAME] Opener</li>     <li>Can Opener</li>     <li>Phillips Head Screwdriver</li>     <li>Flathead Screwdriver</li>     <[NAME] File</li>     <li>Corkscrew</li>     <li>Punch</li | 14661_Thumb.png
Spreadsheet: 885256d1734702717-criteria-for-retrieving-historical-pricing-in-excel-retrieve-historical-price-based-on-the-date-of-transaction-dec-2024-v3-
Sheet: Tab A - Transaction Listing

 | S/N | Date of Final Settlement | Total Assayed Qty (Toz) |  |  |  | Historical Price | Historical Price | Historical Price
 |  |  | Pt | Pd | Rh |  | Pt | Pd | Rh
 | 1 | 2022-01-05 00:00:00 | 151.654 | 743.664 | 72.365
 | 2 | 2022-01-05 00:00:00 | 63.713 | 457.414 | 41.09
 | 3 | 2022-01-08 00:00:00 | 16.169 | 35.563 | 5.592
 | 13 | 2022-01-18 00:00:00 | 4.915 | 50.077 | 4.276
 | 14 | 2022-02-24 00:00:00 | 125.054 | 153.77 | 20.883
 | 16 | 2022-02-01 00:00:00 | 102.103 | 1047.497 | 104.621
 | 17 | 2022-02-17 00:00:00 | 108.124 | 850.487 | 89.982
 | 18 | 2022-02-24 00:00:00 | 108.438 | 225.042 | 33.197
 | 19 | 2022-02-22 00:00:00 | 138.484 | 790.149 | 92.855
 | 20 | 2022-03-25 00:00:00 | 148.61 | 231.425 | 39.512
 | 21 | 2022-02-17 00:00:00 | 130.676 | 873.87 | 103.816
 | 22 | 2022-03-08 00:00:00 | 92.46 | 803.309 | 86.043
 | 23 | 2022-03-05 00:00:00 | 97.481 | 750.276 | 74.431
 | 24 | 2022-03-08 00:00:00 | 152.933 | 814.141 | 104.452
 | 25 | 2022-03-18 00:00:00 | 59.722 | 633.106 | 60.878
 | 26 | 2022-06-15 00:00:00 | 129.821 | 680.702 | 83.441
Spreadsheet: 85573d1285667184-vlookup-formatting-error-book1
Sheet: Sheet2

1998 | 5 | 5
1999 | 6 | 3
2000 | 8 | 5
2001 | 9 | 9
2002 | 2 | 8
2003 | 3 | 4
2004 | 6 | 6
2005 | 4 | 3
2006 | 7 | 2
2007 | 1 | 4
2008 | 2 | 7 | 2 | 1
2009 | 3 | 8 | 3 | 3
2010 | 5 | 9 | 4 | 1
2011 | 8 | 2 | 7 | 7
2012 | 6 | 4 | 9 | 6
2013 | 3 | 5 | 5 | 2
2014 | 5 | 6 | 2 | 4
2015 | 4 | 3 | 3 | 6
2016 | 8 | 1 | 0 | 2
2017 | 9 | 7 | 2 | 7
2018 | 6 | 8 | 1 | 8
2019 | 2 | 9 | 5 | 7
2020 | 1 | 5 | 6 | 8
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  | 1110 | 1243 | 1812 | 1669
2 |  |  |  |  | 1157 | 1277 | 1766 | 1699
3 |  |  |  |  | 1153 | 1277 | 1747 | 1699
4 |  |  |  |  | 1126 | 1277 | 1721 | 1699
5 |  |  |  |  | 1128 | 1277 | 1625 | 1699
6 |  |  |  |  | 1125 | 1277 | 1686 | 1699
7 |  |  |  |  | 1117 | 1277 | 1597 | 1699
8 |  |  |  |  | 1105 | 1277 | 1660 | 1699
9 |  |  |  |  | 1078 | 1081 | 1649 | 1699
10 |  |  |  |  | 1079 | 1277 | 1620 | 1699
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  |  |  |  |  | 348785.29
2001-07-10 00:00:00
Spreadsheet: de395395-d92d-4515-ac45-3c88c013d04b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8041 | 25139 | [NAME] | Ouellet | CAN | 5503 | 00:00:00 | 00:00:00 | [NAME] | 00:02:29 | [NAME] | 1 | 00:25:41
Spreadsheet: 780261d1652365585-advance-lookup-multiple-conditons-date-and-time-between-sample_swipe
Sheet: Pivot Table

[NAME] | Date | Time | Action
user1 | 2021-09-19 00:27:23 | 2021-09-19 00:27:23 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-19 00:39:05 | 2021-09-19 00:39:05 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-19 01:17:46 | 2021-09-19 01:17:46 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-19 01:21:37 | 2021-09-19 01:21:37 | EXT Main Gate Out (14) (In)
user1 | 2021-09-19 01:43:34 | 2021-09-19 01:43:34 | EXT Main Gate In (13) (In)
user1 | 2021-09-19 01:44:14 | 2021-09-19 01:44:14 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-19 04:20:23 | 2021-09-19 04:20:23 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-19 04:21:39 | 2021-09-19 04:21:39 | EXT Main Gate Out (14) (In)
user1 | 2021-09-19 04:25:44 | 2021-09-19 04:25:44 | EXT Main Gate In (13) (In)
user1 | 2021-09-19 04:26:23 | 2021-09-19 04:26:23 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-19 05:57:48 | 2021-09-19 05:57:48 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-19 06:00:02 | 2021-09-19 06:00:02 | EXT Main Gate Out (14) (In)
user1 | 2021-09-19 17:40:20 | 2021-09-19 17:40:20 | EXT Main Gate In (13) (In) | IN
user1 | 2021-09-19 20:33:38 | 2021-09-19 20:33:38 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-19 20:34:52 | 2021-09-19 20:34:52 | EXT Main Gate Out (14) (In)
user1 | 2021-09-19 20:35:36 | 2021-09-19 20:35:36 | EXT Main Gate In (13) (In)
user1 | 2021-09-19 20:39:12 | 2021-09-19 20:39:12 | EXT Main Gate Out (14) (In)
user1 | 2021-09-19 20:54:49 | 2021-09-19 20:54:49 | EXT Main Gate In (13) (In)
user1 | 2021-09-19 20:55:32 | 2021-09-19 20:55:32 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-19 21:55:42 | 2021-09-19 21:55:42 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-19 22:04:14 | 2021-09-19 22:04:14 | EXT Main Gate Out (14) (In)
user1 | 2021-09-19 22:07:39 | 2021-09-19 22:07:39 | EXT Main Gate In (13) (In)
user1 | 2021-09-19 22:08:16 | 2021-09-19 22:08:16 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-20 00:55:21 | 2021-09-20 00:55:21 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-20 01:01:23 | 2021-09-20 01:01:23 | EXT Main Gate Out (14) (In)
user1 | 2021-09-20 01:20:25 | 2021-09-20 01:20:25 | EXT Main Gate In (13) (In)
user1 | 2021-09-20 01:21:18 | 2021-09-20 01:21:18 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-20 04:22:46 | 2021-09-20 04:22:46 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-20 04:23:56 | 2021-09-20 04:23:56 | EXT Main Gate Out (14) (In)
user1 | 2021-09-20 04:28:24 | 2021-09-20 04:28:24 | EXT Main Gate In (13) (In)
user1 | 2021-09-20 04:29:00 | 2021-09-20 04:29:00 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-20 05:57:32 | 2021-09-20 05:57:32 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-20 05:59:13 | 2021-09-20 05:59:13 | EXT Main Gate Out (14) (In)
user1 | 2021-09-20 05:59:24 | 2021-09-20 05:59:24 | EXT Main Gate In (13) (In)
user1 | 2021-09-20 06:00:01 | 2021-09-20 06:00:01 | GF WHS In Turnstile (09) (In)
user1 | 2021-09-20 06:02:13 | 2021-09-20 06:02:13 | GF WHS Out Turnstile (10) (In)
user1 | 2021-09-20 06:04:33 | 2021-09-20 06:04:33 | EXT Main Gate Out (14) (In) | OUT
Spreadsheet: 0285f1ca-f7c4-4fe5-87ad-1a51e43f0881
Sheet: Sheet1

Forcible Sex Offense Victims | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Type of Injury
by Type of Weapon/Force Involved, 20111,  2
Type of Weapon/ Force Involved | Type of Injury
 |  | Murder and Nonnegligent Manslaughter | Apparent Broken Bones | Possible Internal Injury | Severe Laceration | Apparent Minor Injury | Other Major Injury | Loss of Teeth | Unconsciousness
Firearms | 432 | 1 | 4 | 41 | 7 | 199 | 15 | 0 | 6
Firearm | 73 | 1 | 0 | 8 | 0 | 34 | 6 | 0 | 0
Automatic Firearm | 14 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 0
Handgun | 297 | 0 | 4 | 28 | 6 | 130 | 8 | 0 | 5
Automatic Handgun | 27 | 0 | 0 | 2 | 0 | 18 | 0 | 0 | 1
Rifle | 4 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0
Automatic Rifle | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Shotgun | 9 | 0 | 0 | 1 | 0 | 6 | 1 | 0 | 0
Automatic Shotgun | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Firearm | 6 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0
Automatic Other Firearm | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Knife/Cutting Instrument | 384 | 0 | 1 | 42 | 22 | 254 | 19 | 0 | 7
Personal Weapons | 34289 | 5 | 68 | 1210 | 98 | 7018 | 566 | 14 | 136
All Other | 4849 | 1 | 11 | 345 | 21 | 1048 | 101 | 5 | 80
Blunt Object | 83 | 0 | 3 | 34 | 10 | 75 | 12 | 1 | 9
Motor Vehicle | 10 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0
Poison | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Explosives | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Fire/Incendiary Device | 2 | 0 | 0 | 1 | 0 | 2 | 1 | 0 | 1
Drugs/Narcotics/Sleeping Pills | 141 | 0 | 1 | 16 | 0 | 48 | 3 | 1 | 18
Asphyxiation | 15 | 0 | 0 | 10 | 2 | 30 | 1 | 0 | 3
Other Weapon | 1698 | 0 | 4 | 104 | 7 | 373 | 39 | 2 | 14
Unknown Weapons | 2895 | 1 | 3 | 180 | 2 | 515 | 45 | 1 | 35
No Weapon/Force Involved | 17080 | 0 | 6 | 339 | 12 | 1322 | 103 | 3 | 34
1This table does not include totals because in the table a victim can be counted more than once since he/she can be connected to up to ten offense types per incident, up to five types of injury, and up to three weapons per offense type.
2Type Weapon/Force Involved is collected for 13 NIBRS offense types and Type of Injury is collected for 9 offense types.  This table only includes information for the Forcible Sex Offense types.  Although Murder and Nonnegligent Manslaughter is not typically included as a type of injury, it is included in this table for informational purposes as it relates to the type of weapon/force used to commit the offense against the victim.  See Methodology for more information.
Spreadsheet: 787689d1657965608-track-spending-of-individual-from-source-data-live-test-uniform-cost-sheet-for-edit-
Sheet: Summary

Individual Uniform/PPE Spend |  |  |  |  |  |  | OP2114 Total Spend |  |  |  | OP2114 Total Margin
Name | Position | Cost Centre | Allowance | Spend | Margain
Name 1 | Position 1 | OP2114 | 450 | 120
Name 2 | Position 2 | OP2114 | 450 | 240
Name 3 | Position 2 | OP2114 | 450
Name 4 | Position 3 | OP2114 | 450
Name 5 | Position 3 | OP2114 | 450
Name 6 | Position 3 | OP2114 | 450 |  |  |  | OP2117 Total Spend |  |  |  | OP2117 Total Margin
Name 7 | Position 3 | OP2114 | 450
Name 8 | Position 3 | OP2117 | 450
Name 9 | Position 3 | OP2117 | 450
Name 10 | Position 3 | OP2117 | 450
Name 11 | Position 3 | OP2117 | 450 | 300
Name 12 | Position 3 | OP2117 | 450
 |  |  |  |  |  | Notes:   [NAME]/results is needed for the Table within the Summary Tab, within the 'Spend' column.   Current 'Spend' results have been pulled from the [NAME] table from column 'GROSS Cost' based on column 'Name', as you can see Name 2 has multiple inputs on [NAME], so would needed these inputs calculated to gain input for 'Spend' on [NAME].  (Please see both tabs/tables for examples)
Spreadsheet: 691676d1597828544-matrix-formula-for-frequency-with-two-criteria-frequency
Sheet: Sheet1

Rohdaten:
 | Kriterium 1 | Kriterium 2
Person 1 | 5 | A
Person 2 | 7 | A
Person 3 | 11 | B
Person 4 | 6 | C
Person 5 | 3 | D
Person 6 | 8 | B
Person 7 | 6 | A
Person 8 | 14 | A
Person 9 | 12 | C
Person 10 | 7 | C
Person 11 | 6 | D
[NAME]
Kategorie | Häufigkeit
2
4 | 1
6 | 4
8 | 3
10 | 0
12 | 2
14 | 1
16 | 0
 | Kategorien für Kriterium 2
Kategorien für Kriterium 1 | A | B | C | D
2
4
6
8
10
12
14
16
Spreadsheet: 8edd6bc5-2ffb-4213-85ce-72b07d5503cd
Sheet: Sheet1

Securities | % of Assets
Dollarama Inc. | 4.09%
Alimentatn Couche-Tard B | 4.02%
Metro Inc. | 3.90%
Fairfax Financial Holding | 3.80%
BCE Inc. | 3.65%
Empire Company Cl A NVS | 3.45%
Keyera Corp | 3.30%
Rogers Communications Inc | 2.92%
Pembina Pipeline Inc | 2.90%
TransCanada Corp. | 2.85%
TELUS Corp. | 2.84%
RioCan REIT | 2.82%
Canadian REIT | 2.77%
Intact Financial Corp | 2.65%
Weston(George) Ltd. | 2.61%
Enbridge Inc. | 2.55%
Cdn Utilities Cl A NVS | 2.50%
Inter Pipeline Ltd. | 2.49%
Loblaw Companies Ltd. | 2.47%
Emera Inc. | 2.45%
Tim Hortons Inc. | 2.40%
Shaw Communicatn Cl B Nvs | 2.34%
AltaGas Ltd | 2.29%
Open Text Corp. | 2.22%
Catamaran Corporation | 2.17%
Franco-Nevada Corp | 2.07%
Thomson Reuters Corp | 2.00%
Canadian Tire Corp Cl A | 1.99%
Fortis Inc. | 1.99%
ATCO Ltd Class I | 1.97%
CGI Group Inc Cl A | 1.93%
Saputo Inc. | 1.89%
West Fraser Timber Co Ltd | 1.88%
CI Financial Corp | 1.81%
H&R REIT | 1.80%
Valeant Pharmaceuticals | 1.77%
National Bank of Canada | 1.67%
TransAlta Corp. | 1.57%
IGM Financial Inc. | 1.51%
CAE Inc. | 1.34%
Cash | 0.35%
Total Holdings in Portfolio | 41