tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142596d1329924606-vlookup-and-col_index_num-issue-financial-statements_vlookup_question
Sheet: Budget Data Raw

 | A | B | C | D | E | F | G
1
2 | 102500000 | 61499.99999999999 | 3075 | 20500 | 0 | 0 | 0
3 | 105062500 | 63037.49999999999 | 3151.874999999999 | 21012.5 | 0 | 0 | 0
4 | 107689062.5 | 64613.43749999998 | 3230.671874999999 | 21537.81249999999 | 0 | 0 | 0
5 | 110381289.0624999 | 66228.77343749997 | 3311.438671874998 | 22076.25781249999 | 0 | 0 | 0
6 | 113140821.2890624 | 67884.49277343747 | 3394.224638671873 | 22628.16425781249 | 0 | 0 | 0
7 | 115969341.821289 | 69581.60509277339 | 3479.080254638669 | 23193.8683642578 | 0 | 0 | 0
8 | 118868575.3668212 | 71321.14522009272 | 3566.057261004636 | 23773.71507336424 | 0 | 0 | 0
9 | 121840289.7509917 | 73104.17385059503 | 3655.208692529752 | 24368.05795019834 | 0 | 0 | 0
10 | 124886296.9947665 | 74931.7781968599 | 3746.588909842995 | 24977.2593989533 | 0 | 0 | 0
11 | 128008454.4196356 | 76805.07265178139 | 3840.25363258907 | 25601.69088392713 | 0 | 0 | 0
12 | 131208665.7801265 | 78725.19946807592 | 3936.259973403796 | 26241.73315602531 | 0 | 0 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 418221f1-1af6-4f1c-aac0-7548d157908d
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
VS | Test | VS | Vanadium, Serum | Vanadium, S | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1.6 | mL | Collection Container/Tube: Plain, royal-blue top Monoject trace element blood collection tube, product #8881-307006 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 1.6 mL Collection Instructions: 1. Allow the specimen to clot for 30 minutes; then centrifuge the specimen to separate serum from the cellular fraction. 2. Remove the stopper. Carefully pour specimen into Mayo metal-free, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipette into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.4 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | Normal: <1.0 ng/mL | Tuesday, Thursday; 3 p.m. | 1 day | 5 days | 1 | 83789 |  |  |  |  | Rochester
VS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
VS | Result | 83396 | Vanadium, S | Vanadium, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5756-2
Spreadsheet: 479792d1473592461-round-robin-team-generation-ef972_teams
Sheet: Sheet1

1 | 4 | 9 |  | <-- Initial
1 | 8 | 11 |  | <-- Initial
Spreadsheet: matt_motley__26422__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-30 00:00:00 | 18.9 | 19.5 | 17 | 19
Mid-Columbia | 2002-01-30 00:00:00 | 18.9 | 19.5 | 17 | 19
COB | 2002-01-30 00:00:00 | 21 | 22 | 17.75 | 18.75
N. California | 2002-01-30 00:00:00 | 23.5 | 24.25 | 18.25 | 19.75
Midway/Sylmar | 2002-01-30 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-30 00:00:00 | 23 | 25 | 17.75 | 20.5
Mead | 2002-01-30 00:00:00 | 24.5 | 26.5 | 17 | 19
Palo Verde | 2002-01-30 00:00:00 | 23.5 | 25.5 | 14.75 | 16.5
Inland SW | 2002-01-30 00:00:00 | 23.5 | 26.5 | 14.75 | 19
4-Corners | 2002-01-30 00:00:00 | 23 | 25.25 | 15 | 16
Central Rockies | 2002-01-30 00:00:00 | 20.5 | 23 | 12 | 13.75
Spreadsheet: 100486d1298851748-sumifs-alternative-for-excel-2003-sumproduct-not-working-newkvs
Sheet: Sunday

Weekly [NAME] |  |  |  |  | Sunday
Hour | T/C | TTL | TTTL | Name | Shift Manager
0000 - 0100 | 0 | 0 | #N/A
0100 - 0200 | 0 | 0 | #N/A
0200 - 0300 | 0 | 0 | #N/A
0300 - 0400 | 0 | 0 | #N/A
0400 - 0500 | 0 | 0 | #N/A
0500 - 0600 | 0 | 0 | #N/A
0600 - 0700 | 0 | 0 | #N/A |  | [NAME]
0700 - 0800 | 0 | 0 | #N/A |  | [NAME]
0800 - 0900 | 0 | 0 | #N/A |  | [NAME]
0900 - 1000 | 0 | 0 | #N/A |  | [NAME]
1000 - 1100 | 0 | 0 | #N/A |  | [NAME]
1100 - 1200 | 0 | 0 | #N/A |  | [NAME]
1200 - 1300 | 0 | 0 | #N/A |  | [NAME]
1300 - 1400 | 0 | 0 | #N/A |  | [NAME]
1400 - 1500 | 0 | 0 | #N/A |  | [NAME]
1500 - 1600 | 0 | 0 | #N/A |  | [NAME]
1600 - 1700 | 0 | 0 | #N/A |  | [NAME]
1700 - 1800 | 0 | 0 | #N/A |  | [NAME]
1800 - 1900 | 0 | 0 | #N/A |  | [NAME]
1900 - 2000 | 0 | 0 | #N/A |  | [NAME]
2000 - 2100 | 0 | 0 | #N/A |  | [NAME]
2100 - 2200 | 0 | 0 | #N/A |  | [NAME]
2200 - 2300 | 0 | 0 | #N/A |  | [NAME]
2300 - 0000 | 0 | 0 | #N/A
Spreadsheet: 467129d1466591606-create-table-of-data-from-original-list-and-results
Sheet: Desired Results

Dept | Range Name | UPC | Stroke No | Colour Code | Colour | 1st size | B/H ind | Qty |  |  |  |  | Row Labels | Stroke No | Colour | B/H ind | Sum of Qty
G5-T58 | JERSEY TOPS | 06417147 | 3019 | H0 | TURQUOISE | 10 | H | 475 |  |  |  |  | G5-T58 | 3019 | GOLD | H | 1113
G5-T58 | JERSEY TOPS | 06565398 | 3019 | S0 | GOLD | 10 | H | 1113 |  |  |  |  |  |  | TURQUOISE | H | 475
G5-T58 | JERSEY TOPS | 06431389 | 3019 | Z0 | WHITE | 10 | H | 6829 |  |  |  |  |  |  | WHITE | H | 6829
G5-T58 | JERSEY TOPS | 03163672 | 3030 | E4 | BLUE MIX | 16 | H | 179 |  |  |  |  |  | 3030 | BLUE MIX | H | 179
G5-T58 | JERSEY TOPS | 01450323 | 3031 | K0 | CREAM | 10 | H | 4425 |  |  |  |  |  | 3031 | CREAM | H | 4425
G5-T58 | JERSEY TOPS | 21927904 | 3039 | A4 | PINK MIX | 10 | H | 366 |  |  |  |  |  | 3039 | PINK MIX | H | 366
G5-T58 | JERSEY TOPS | 02936888 | 3043 | Y4 | BLACK MIX | 16 | H | 5 |  |  |  |  |  | 3043 | BLACK MIX | H | 5
G5-T58 | JERSEY TOPS | 09360532 | 3045 | F4 | NAVY MIX | 14 | H | 1150 |  |  |  |  |  | 3045 | MINT MIX | H | 143
G5-T58 | JERSEY TOPS | 09366978 | 3045 | KQ | MINT MIX | 16 | H | 143 |  |  |  |  |  |  | NAVY MIX | H | 1150
G5-T58 | JERSEY TOPS | 22060570 | 3046 | NU | NEUTRAL | 10 | H | 3661 |  |  |  |  |  | 3046 | NEUTRAL | H | 3661
G5-T58 | JERSEY TOPS | 06444204 | 3046 | QA | PALE PINK | 10 | H | 1190 |  |  |  |  |  |  | PALE PINK | H | 1190
G5-T58 | JERSEY TOPS | 09381797 | 3047 | KQ | MINT MIX | 10 | H | 2584 |  |  |  |  |  | 3047 | MINT MIX | H | 2584
G5-T58 | JERSEY TOPS | 21602788 | 3048 | KY | IVORY | 10 | H | 1157 |  |  |  |  |  | 3048 | IVORY | H | 1157
G5-T58 | JERSEY TOPS | 21602870 | 3048 | WU | MINT | 10 | H | 810 |  |  |  |  |  |  | MINT | H | 810
G5-T58 | JERSEY TOPS | 21942655 | 3049 | Y4 | BLACK MIX | 10 | H | 8798 |  |  |  |  |  | 3049 | BLACK MIX | H | 8798
G5-T58 | JERSEY TOPS | 02937960 | 3050 | [NAME] | GOLD MIX | 10 | H | 2323 |  |  |  |  |  | 3050 | GOLD MIX | H | 2323
 |  |  |  |  |  |  |  |  |  |  |  |  | G5-T58 Total |  |  |  | 35208
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  |  | 35208
Spreadsheet: 819911d1677762613-count-range-with-dates-not-working-copy-1-
Sheet: DROP DOWN

 |  |  |  | All
 |  |  |  | 2023-02-28 00:00:00
 |  |  |  |  |  | Overrides
 |  |  |  |  |  | Suspended /RRT
 |  |  |  |  |  | Claim closed
Spreadsheet: 322a8ba5-d2dd-4b18-a619-d2f284ea1d4b
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
42196498 | 2014-07-07 09:40:42 | AXIS | 0 | 2 | 5 | 1137331 | [NAME] | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
42196702 | 2014-07-07 09:58:23 | ALLIES | 1 | 5 | 2 | 1137331 | [NAME] | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
Spreadsheet: bffa070d-d1bd-4a55-ac6b-ee56e477ae2f
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
EUCL | Test | EUCL | Eucalyptus, IgE | Eucalyptus, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EUCL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EUCL | Result | EUCL | Eucalyptus, IgE | Eucalyptus, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6113-5 | Eucalyptus spp [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 884641d1733873771-remove-a-second-digit-from-a-number-book2
Sheet: Sheet1

 | I kindly for excel formula to remove the second digit from the number
 |  | Desired solution
 | 172301 | 17301
 | 172303 | 17303
 | 172304 | 17304
 | 172305 | 17305
 | 172308 | 17308
 | 172309 | 17309
 | 172310 | 17310
 | 172311 | 17311
 | 172317 | 17317
 | 172318 | 17318
 | 172319 | 17319
 | 172320 | 17320
 | 172321 | 17321
 | 172322 | 17322
 | 172325 | 17325
 | 172326 | 17326
 | 172327 | 17327
 | 172332 | 17332
 | 172333 | 17333
Spreadsheet: 823209d1679813135-make-a-cell-with-many-lines-into-order-example1
Sheet: Scratchpad

Name	Buy-in	Plrs	Prize Pool	Status 8-Max Turbo:{#P}$750 Gtd{#M}	$16.50	34	$750	Late Reg ends: 10 mins Bounty Battle 6-Max Hyper:{#P}$500 Gtd{#M}	$11	23	$500	Late Reg ends: 20 mins Daily Legends{#P}6-Max Turbo:{#M}$1.5K Gtd{#S}	$33	19	$1,500	Late Reg ends: 25 mins The Super $5.50:{#P}$2,000 Gtd{#M}[Grand Prix Edition]{#S}	$5.50	249	$2,000	Late Reg ends: 46 mins The Super $22:{#P}$6,000 Gtd{#M}[Grand Prix Edition]{#S}	$22	184	$6,000	Late Reg ends: 46 mins The Super $109:{#P}$5,000 Gtd{#M}	$109	24	$5,000	Late Reg ends: 1 hr  10 mins 8-Max Deepstack:{#P}$300 Gtd{#M}	$7.50	13	$300	Late Reg ends: 1 hr  11 mins |  |  | Buy In | Plrs | Prize pool | Status
 |  | 8-[NAME]: | 750 Gtd | 16.50	34 | 750 | Late Reg ends: 10 mins
 |  | Bounty Battle 6-[NAME]: | 500 Gtd | 11	23 | 500 | Late Reg ends: 20 mins
 |  | Daily Legends6-[NAME]: | 1.5K Gtd | 33	19 | 1,500 | Late Reg ends: 25 mins
 |  | The Super $5.50: | 2,000 Gtd[Grand Prix Edition] | 5.50	249 | 2,000 | Late [NAME] ends: 46 mins
 |  | The Super $22: | 6,000 Gtd[Grand Prix Edition] | 22	184 | 6,000 | Late [NAME] ends: 46 mins
 |  | The Super $109: | 5,000 Gtd | 109	24 | 5,000 | Late Reg ends: 1 hr  10 mins
 |  | 8-Max Deepstack: | 300 Gtd | 7.50	13 | 300 | Late Reg ends: 1 hr  11 mins
Spreadsheet: 750066d1633207500-files-status-based-on-dates-indexing-data-based-on-dates-and-status-nico_lino-
Sheet: Entry

File # | Reception date | Analyze |  | Approve |  | Submit date
 |  | start date | end date | start date | end date
123 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-25 00:00:00 | 2021-09-30 00:00:00
456 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-25 00:00:00 | 2021-09-28 00:00:00
124 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-24 00:00:00 | 2021-09-27 00:00:00
462 | 2021-09-23 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-26 00:00:00
856 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-25 00:00:00
879 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00
931 | 2021-10-01 00:00:00
932 | 2021-10-02 00:00:00 | 2021-10-02 00:00:00
Spreadsheet: 5de1a1ed-b30b-437f-80b7-a47c4bd7241c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: December 21, 2014 (12:25 pm)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229646
Q2-2004 | 233241
Q3-2004 | 235336
Q4-2004 | 237875
Q1-2005 | 242085
Q2-2005 | 244136
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276019
Q2-2008 | 278206
Q3-2008 | 280691
Q4-2008 | 273572
Q1-2009 | 267266
Q2-2009 | 267665
Q3-2009 | 268736
Q4-2009 | 271174
Q1-2010 | 273058
Q2-2010 | 275612
Q3-2010 | 279685
Q4-2010 | 281383
Q1-2011 | 283078
Q2-2011 | 290271
Q3-2011 | 293177
Q4-2011 | 293795
Q1-2012 | 297910
Q2-2012 | 301286
Q3-2012 | 303811
Q4-2012 | 309614
Q1-2013 | 311650
Q2-2013 | 314808
Q3-2013 | 320413
Q4-2013 | 326348
Q1-2014 | 330450
Q2-2014 | 333078
Q3-2014 | 336540
Q4-2014 | X
Spreadsheet: 851991d1702096622-return-name-from-a-list-by-certain-country-and-number-of-employees-book1
Sheet: Sheet1

 | Factory | Country | City | Employees |  |  | THAILAND | INDONESIA | VIETNAM | LAOS | INDIA
 | Fac01 | India | Vita | 38 |  |  |  |  |  |  |  | << [NAME] return only factory from that country sorted by smallest to highest employees
 | Fac02 | India | Vadodara | 44 |  |  | Fac12 | Fac05 |  |  | Fac03
 | Fac03 | India | Karjat | 42 |  |  | Fac17 |  |  |  | Fac02
 | Fac04 | Indonesia | Bali | 120 |  |  | Fac13
 | Fac05 | Indonesia | Bali | 175 |  |  | Fac22
 | Fac06 | Laos | Vientiane | 94 |  |  | Fac15
 | Fac07 | Thailand | Bangkok | 390 |  |  | Fac14
 | Fac08 | Thailand | [NAME] | 128 |  |  | Fac24
 | Fac09 | Thailand | Bangkok | 194 |  |  | Fac18
 | Fac10 | Thailand | Pattaya | 164 |  |  | Fac08
 | Fac11 | Thailand | Bangkok | 224 |  |  | Fac16
 | Fac12 | Thailand | [NAME] | 41 |  |  | Fac10
 | Fac13 | Thailand | Kanchanaburi | 50 |  |  | Fac21
 | Fac14 | Thailand | Pattaya | 64 |  |  | Fac09
 | Fac15 | Thailand | [NAME] | 63 |  |  | Fac11
 | Fac16 | Thailand | [NAME] | 147 |  |  | Fac07
 | Fac17 | Thailand | Pattaya | 44 |  |  | Fac20
 | Fac18 | Thailand | Bangkok | 86 |  |  | Fac19
 | Fac19 | Thailand | Bangkok | 494
 | Fac20 | Thailand | [NAME] | 413
 | Fac21 | Thailand | Phuket | 180
 | Fac22 | Thailand | Samui | 51
 | Fac23 | Thailand | [NAME] | 25
 | Fac24 | Thailand | [NAME] | 69
 | Fac25 | Vietnam | [NAME] | 268
Spreadsheet: 50804d1250280089-excel-dates-book1
Sheet: Sheet1

Date Admitted |  | day | month | year | day2 | month2 | year2
2009-03-30 00:00:00 | 30/03/09 | 30 | 3 | 2009 | #N/A | #N/A | #N/A
2009-03-31 00:00:00 | 31/03/2009 | 31 | 3 | 2009 | #N/A | #N/A | #N/A
2009-04-14 00:00:00 | 14/04/09 | 14 | 4 | 2009 | #N/A | #N/A | #N/A
2009-04-16 00:00:00 | 16/04/09 | 16 | 4 | 2009 | #N/A | #N/A | #N/A
2009-04-20 00:00:00 | 20/04/09 | 20 | 4 | 2009 | #N/A | #N/A | #N/A
2009-04-22 00:00:00 | 22/04/09 | 22 | 4 | 2009 | #N/A | #N/A | #N/A
2009-04-21 00:00:00 | 21/04/09 | 21 | 4 | 2009 | #N/A | #N/A | #N/A
 | 2009-06-04 00:00:00 | 0 | 1 | 1900 | 4 | 6 | 2009
2009-04-21 00:00:00 | 21/04/09 | 21 | 4 | 2009 | #N/A | #N/A | #N/A
2009-04-30 00:00:00 | 30/04/09 | 30 | 4 | 2009 | #N/A | #N/A | #N/A
 | 2009-03-04 00:00:00 | 0 | 1 | 1900 | 4 | 3 | 2009
 | 2009-07-04 00:00:00 | 0 | 1 | 1900 | 4 | 7 | 2009
 | 2009-08-04 00:00:00 | 0 | 1 | 1900 | 4 | 8 | 2009
 | 2009-01-04 00:00:00 | 0 | 1 | 1900 | 4 | 1 | 2009
 | 2009-07-04 00:00:00 | 0 | 1 | 1900 | 4 | 7 | 2009
 | 2009-06-03 00:00:00 | 0 | 1 | 1900 | 3 | 6 | 2009
 | 2009-12-03 00:00:00 | 0 | 1 | 1900 | 3 | 12 | 2009
 | 2009-10-03 00:00:00 | 0 | 1 | 1900 | 3 | 10 | 2009
2009-03-19 00:00:00 | 19/03/09 | 19 | 3 | 2009 | #N/A | #N/A | #N/A
2009-03-23 00:00:00 | 23/03/09 | 23 | 3 | 2009 | #N/A | #N/A | #N/A
2009-03-23 00:00:00 | 23/03/09 | 23 | 3 | 2009 | #N/A | #N/A | #N/A
2009-03-23 00:00:00 | 23/03/09 | 23 | 3 | 2009 | #N/A | #N/A | #N/A
Spreadsheet: 0672d5a7-d51b-4a4b-b9a1-f767bb76a220
Sheet: Sheet1

#2  Course Completion | ONLINE UG SUCCESS RATE (BASIC SKILLS LEVEL)
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12
Gender | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates
Female | 296 | 0.5675675675675675 | 505 | 0.5603960396039604 | 381 | 0.6036745406824147 | 238 | 0.5294117647058824 | 180 | 0.5944444444444444
Male | 93 | 0.4516129032258064 | 190 | 0.4526315789473684 | 147 | 0.5918367346938775 | 86 | 0.5232558139534884 | 92 | 0.5217391304347826
Unknown | 1 | 0 | 8 | 0.5 | 7 | 0.5714285714285714 | 1 | 1
AY Average | 390 | 0.5384615384615384 | 703 | 0.5305832147937412 | 535 | 0.6 | 325 | 0.5292307692307693 | 272 | 0.5698529411764706
Ethnicity | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates
White | 165 | 0.5757575757575758 | 289 | 0.5813148788927336 | 246 | 0.6382113821138211 | 134 | 0.5746268656716418 | 103 | 0.6310679611650486
Hispanic | 96 | 0.5208333333333334 | 192 | 0.4895833333333333 | 138 | 0.6014492753623188 | 110 | 0.4090909090909091 | 98 | 0.5612244897959183
African American | 56 | 0.4285714285714285 | 91 | 0.4175824175824176 | 66 | 0.5151515151515151 | 36 | 0.4166666666666667 | 29 | 0.3793103448275862
Asian | 12 | 0.5833333333333334 | 19 | 0.6842105263157895 | 15 | 0.4666666666666667 | 5 | 1 | 6 | 0.5
Native American | 5 | 1 | 13 | 0.5384615384615384 | 3 | 1 | 3 | 1 | 3 | 1
Filipino | 16 | 0.4375 | 27 | 0.4444444444444444 | 15 | 0.7333333333333333 | 10 | 0.8 | 7 | 0.7142857142857143
Pacific Islander | 2 | 0.5 | 9 | 0.4444444444444444 | 6 | 0.8333333333333334 | 4 | 0.75 | 2 | 1
Multi-Race | 10 | 0.4 | 16 | 0.4375 | 14 | 0.4285714285714285 | 10 | 0.5 | 14 | 0.4285714285714285
Unknown | 28 | 0.6071428571428571 | 47 | 0.6595744680851063 | 32 | 0.46875 | 13 | 0.8461538461538461 | 10 | 0.5
Age | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates | Graded Seats | Success Rates
<18 | 5 | 0.8 | 6 | 0.8333333333333334 | 2 | 0.5 | 3 | 0.6666666666666666 | 1 | 0
18 & 19 | 107 | 0.514018691588785 | 202 | 0.4801980198019802 | 137 | 0.5036496350364964 | 76 | 0.4342105263157895 | 47 | 0.4893617021276596
20 to 24 | 114 | 0.5701754385964912 | 218 | 0.481651376146789 | 160 | 0.5875 | 105 | 0.5047619047619047 | 106 | 0.5283018867924528
25 to 29 | 54 | 0.4814814814814815 | 93 | 0.5698924731182796 | 78 | 0.6666666666666666 | 49 | 0.6530612244897959 | 44 | 0.5909090909090909
30 to 34 | 35 | 0.6 | 57 | 0.5614035087719298 | 54 | 0.6111111111111112 | 33 | 0.4848484848484849 | 32 | 0.625
35 to 39 | 32 | 0.40625 | 51 | 0.5490196078431373 | 29 | 0.6551724137931034 | 25 | 0.76 | 17 | 0.7647058823529411
40 to 49 | 25 | 0.6 | 47 | 0.7659574468085106 | 48 | 0.7291666666666666 | 25 | 0.48 | 18 | 0.6666666666666666
50 + | 18 | 0.6111111111111112 | 29 | 0.5862068965517241 | 26 | 0.6538461538461539 | 8 | 0.5 | 7 | 0.7142857142857143
Unknown |  |  |  |  | 1 | 1 | 1 | 1
Spreadsheet: 726643d1617348403-populate-text-from-other-sheet-based-on-number-or-word-entered-reminders-1-
Sheet: TOPICS

 | Weekly [NAME] |  |  |  |  | Safety Minder Schedule |  |  |  |  |  |  | Managers [NAME] |  |  |  |  |  |  | Monthly [NAME]
Week 1 | Cleaning |  |  |  | Week 1 | Observe |  |  |  |  |  | Week 1 | Sign in |  |  |  |  |  | January | Be kind
 | Safety |  |  |  |  | Don't rush |  |  |  |  |  |  | Sign out |  |  |  |  |  |  | Golden rule
Week 2 | Wall Washing |  |  |  | Week 2 | Teamwork |  |  |  |  |  | Week 2 | Requests |  |  |  |  |  | February | Polite
 | Lifting |  |  |  |  | Ask questions |  |  |  |  |  |  | Onboarding |  |  |  |  |  |  | Compassion
Week 3 | Dusting |  |  |  | Week 3 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | March | Attentive
 | Fire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Punctual
Week 4 | Storage |  |  |  | Week 4 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  | April
 | Equipment
Week 5 | [NAME] |  |  |  | Week 5 |  |  |  |  |  |  | Week 5
 | Falling Objects
CustomerServiceMinders
1. Interactive |  |  |  |  |  |  |  | Re: Populate text from other sheet based on number or word entered
2. [NAME] |  |  |  |  |  |  |  | Sorry about that! In the example 1 tab I've attached, you'll see in cells B8, B13, B18 and B23 have the number 1. There is also a number 1 in cell [NAME]. I want the cells in B8, B13, B18 and B23 to automatically populate the text associate with the number 1 from the TOPICS tab. I want the month associate with the monthly chat to update based on the text that goes with the month typed in B28. Everything should be based on the number in cell [NAME]. In the example 2 tab, I did the same thing and put the number 2 in cells C3, B8, B13, B18 and B23. The month January is in B28. Let me know if there are any more questions.
3. Communication
4. Telephone Etiquette
5. Communicating with Unhappy Customers
Spreadsheet: 330067d1404503183-index-match-and-return-all-matching-values-index-match-and-return-all-matching-values
Sheet: Sheet2

crate number
3
Qty  of product | Product Reference | Product Description
Spreadsheet: 884492d1733710165-calculating-wage-salary-increase-efsalary
Sheet: Sheet1

 |  |  |  |  |  | 0.025 |  | 17.85
 |  |  |  |  |  | 0.025 |  | 18.3
 |  |  |  |  |  | 0.025 |  | 18.76
 |  |  |  |  |  | 0.025 |  | 19.23
 |  |  |  |  |  | 0.025 |  | 19.72
 |  |  |  |  |  | 0.03 |  | 20.32
 |  |  |  |  |  | 0.03 |  | 20.93
 |  |  |  |  |  | 0.035 |  | 21.67
 |  |  |  |  |  | 0.02 |  | 22.11
 |  |  |  |  |  | 0.01 |  | 22.34
 |  |  |  |  |  | 0.035 |  | 23.14
 |  |  |  |  |  | 0.015 |  | 23.49
 |  |  |  |  |  | 0.015 |  | 23.84
 |  |  |  |  |  | 0.015 |  | 24.2
 |  |  |  |  |  | 0.02 |  | 24.69
 |  |  |  |  |  | 0.03 |  | 25.45
 |  |  |  |  |  | 0.03 |  | 26.21
 |  |  |  |  |  | 0.03 |  | 27
 |  |  |  |  |  | 0.05 |  | 28.35
 |  |  |  |  |  | 0 |  | 28.35
 |  |  |  |  |  | 0.06 |  | 30.05
 |  |  |  |  |  | 0.0325 |  | 31.03
 |  |  |  |  |  | 0.03 |  | 31.96
 |  |  |  |  |  | 0.03 |  | 32.92
Spreadsheet: 489031d1479022690-function-help-categorizing-monthly-budget-expense-tracker
Sheet: YEAR TO-DATE

 | YEAR TO-DATE | 2017
 |  |  |  |  |  | ACCOUNTS
 | Budget Total: |  |  |  |  | CASH | Expenditure Total:
 | Remaining: |  | % Remaining: |  |  | VISA | Expenditure Total:
 |  | EXPENSE: | Gas | Clothing | Entertainment | Groceries | Restaurant | Alcohol | other | Toiletries | BCHydro | Internet | Cellphone | Rent
 | YEAR TO-DATE | Budgeted:
 | Running Total: | YEAR T0-DATE
 | Budget Remaining: | YEAR T0-DATE
 | [NAME]: | YEAR T0-DATE