tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5925a415-9065-446d-89d2-dad38df3804b
Sheet: EPR IS

CONSOLIDATED STATEMENTS OF INCOME ([NAME] and Condensed)
 | Periods Ended June 30,
 | Quarters |  |  | Nine Months
 | 2012 | 2011 |  | 2012 | 2011
(In millions, except per share amounts)
Revenues
Gaming operations | 301.2 | 267.4 |  | 866.2 | 790.1
Product sales | 231.6 | 221.6 |  | 653.4 | 627.1
Total revenues | 532.8 | 489 |  | 1519.6 | 1417.2
Costs and operating expenses
Cost of gaming operations | 123 | 102.8 |  | 346 | 299.2
Cost of product sales | 107.2 | 97.6 |  | 305.4 | 277.4
Selling, general and administrative | 104.9 | 82.49999999999999 |  | 303.8 | 253.8
Research and development | 55.1 | 48.5 |  | 157.3 | 146.1
Depreciation and amortization | 21.1 | 16.8 |  | 55.8 | 51.6
Contingent acquisition related costs | 26 | 0 |  | 37.8 | 0
Total costs and operating expenses | 437.3000000000001 | 348.2 |  | 1206.1 | 1028.1
Operating income | 95.49999999999989 | 140.8 |  | 313.5 | 389.1000000000001
Other income (expense)
Interest income | 11 | 13.3 |  | 33.9 | 40
Interest expense | -30.8 | -30.5 |  | -90.89999999999999 | -101.5
Other | -1.6 | -1.899999999999999 |  | -6.399999999999999 | 1.4
Total other income (expense) | -21.4 | -19.1 |  | -63.39999999999999 | -60.1
Income from continuing operations before tax | 74.09999999999988 | 121.7 |  | 250.1 | 329.0000000000001
Income tax provision | 27.2 | 29.9 |  | 90.5 | 96.7
Income from continuing operations | 46.89999999999988 | 91.80000000000001 |  | 159.6 | 232.3000000000001
Loss from discontinued operations, net of tax | -0.3 | -4.9 |  | -1.8 | -2.1
Net income | 46.59999999999988 | 86.9 |  | 157.8 | 230.2000000000001
Basic earnings (loss) per share
Continuing operations | 0.16 | 0.31 |  | 0.54 | 0.78
Discontinued operations | 0 | -0.02 |  | -0.01000000000000001 | -0.01
Net income | 0.16 | 0.29 | 0 | 0.53 | 0.77
Diluted earnings (loss) per share
Continuing operations | 0.16 | 0.3 |  | 0.54 | 0.77
Discontinued operations | 0 | -0.01 |  | -0.01000000000000001 | 0
Net income | 0.16 | 0.29 | 0 | 0.53 | 0.77
Weighted average shares outstanding
Basic | 292.7 | 299.2 |  | 295.6 | 298.4
Diluted | 294.3 | 300.7 |  | 297.2 | 299.9
Spreadsheet: 154066d1336171298-return-yes-no-late-from-multiple-tick-or-cross-sample2
Sheet: overview

 | Extract from Rental Manager
 | Rent amount |  | 850 |  |  | in a hidden data sheet |  |  |  | Arrears options
 |  |  |  |  |  |  | data |  |  | YES
 | Payment History |  | Amount | Paid |  |  | a |  |  | NO
 | 2011-09-01 00:00:00 |  |  | a |  |  | r |  |  | LATE
 | 2011-10-01 00:00:00 |  |  | a |  |  | s
 | 2011-11-01 00:00:00 |  |  | s
 | 2011-12-01 00:00:00 |  |  | a
 | 2012-01-01 00:00:00 |  |  | a
 | 2012-02-01 00:00:00 |  |  | a
 | 2012-03-01 00:00:00 |  |  | r
 | 2012-04-01 00:00:00 |  |  | r
 | 2012-05-01 00:00:00
 | 2012-06-01 00:00:00
 | 2012-07-01 00:00:00
 | 2012-08-01 00:00:00
 | 2012-09-01 00:00:00
 | I need the formula to auto fill the boxes I have highlighted red, from the fact that the 2 'x' have been applied to the paid column
 | if only 1 'x' then it returns late and does not fill red
 | is this possible
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Harrisburg F.E.

 |  |  | 2014 Harrisburg F.E. Delivery Calendar =  Antioch, St. Francis, [NAME]
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | Every Tuesday.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: 544992d1509132806-arrange-the-data-data_arrange_example
Sheet: Sheet1

Current Scenario |  |  |  | Desired/Expected Result
Quality | 4 |  |  | Quality | Delivery
Delivery | 1 |  |  | 4 | 1
Quality | 5 |  |  | 5 | 5
Delivery | 5
 |  |  |  | 3 | 3
Quality | 3
Delivery | 3 |  |  | 1 | 3
Quality | 1
Delivery | 3
Spreadsheet: 675423d1588275814-if-formula-to-gather-data-from-different-sheets-in-a-worksheet-demo
Sheet: 1 students

1 |  |  |  |  |  |  |  | lsantiago
 |  |  |  |  |  |  |  | Dfster
 |  |  |  |  |  |  |  | Apersaud
Spreadsheet: 849607d1700042133-formula-help-with-multiple-criteria-and-two-data-sets-sample
Sheet: Sheet2

 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
EARSN | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5
JUPSN | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5
MARSN | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 19 - table 2

Ambev shareholding structure
 | ON | %Outs | PN | %Outs | Total | %Outs
Anheuser-Busch InBev | 1296288468 | 0.7404718415489402 | 633262210 | 0.463397312783099 | 1929550678 | 0.6190033882967364
FAHZ | 299077066 | 0.1708401727647506 | 0 | 0 | 299077066 | 0.0959444700399036
Market | 155259399 | 0.0886879856863092 | 733302059 | 0.5366026872169011 | 888561458 | 0.28505214166336
Outstanding | 1750624933 | 1 | 1366564269 | 1 | 3117189202 | 1
Treasury | 510398 |  | 98085 |  | 608483
TOTAL | 1751135331 |  | 1366662354 |  | 3117797685
Free float BM&FBovespa | 150867162 | 0.08617903193087906 | 436831268 | 0.3196565854305971 | 587698430 | 0.1885347317458082
Free float NYSE | 4392237 | 0.002508953755430147 | 296470791 | 0.2169461017863039 | 300863028 | 0.09651740991755174
Spreadsheet: 222710d1363909913-how-to-link-2-worksbook-together-to-get-all-info-master-list-example-1
Sheet: Master list with contact name

 | Company name | Address | City | State | contact person
 | depot 2 | 123 fake stree | Burlington | VT | Adam
 | mission | 45454 f street | Oakland | CA | [NAME]
 | [NAME] | bld c | Tempe | AZ | [NAME]
 | beer vendor | 4350 cedar road | St. Louis Park | MN | Pops
 | computer vendor | 8525463 topper | North Hollywood | CA | troy
 | table person | 589585 eight street | Castle Afb | CA | Adam
 | clothes person | 10 street street | New Britain | CT | [NAME]
 | lights person | 777 casper | Orlando | FL | [NAME]
 | lamp depot | 458336 crenshaw | Singapore | TI | troy
 | door and garage | 452 polk | Singapore | TI | Pops
 | paint and body | 34344 pike ave | Lowry Afb | CO | Pops
 | ruffels | 80220 washinhton | Washington | DC | troy
 | chicken house | 67 watson | Griffies | NY | [NAME]
 | cords and lighting | 458226 appelton | Keesler Afb | MS | [NAME]
 | computer vendor | 758226 whites street | [NAME] | WA | [NAME]
 | ruffels | 258354 fourth street | [NAME] | WA | troy
 | lights person | 1202251 blank | Hollywood | FL | bob
 | beer vendor | 58526 ryan | Alameda | CA | blake
Spreadsheet: 462431d1464039874-need-excel-to-automatically-send-an-email-to-assigned-employee-when-due-date-is-past-due-cassie-need-excel-to-automatically-send-an-email-to-assigned-employee-when-due-date-is-past-due
Sheet: Sheet1

Corrective Actions
Project | Category | Employee | Date Assigned | Date Due | Status | Completion Date | Days Past Due | Notes
 |  |  |  | 2016-03-12 00:00:00
 |  |  |  | 2016-03-11 00:00:00 |  | 2016-03-12 00:00:00
 |  |  |  | 2016-03-10 00:00:00 |  | 2016-03-09 00:00:00
Spreadsheet: 374474d1422883084-data-capture-to-master-workbook-from-multiple-workbooks-booker1
Sheet: Wednesday

Meeting Name | Contact Name | Notes | Call | [NAME] | Call Contact | [NAME] | SV
 |  |  | 111
 |  |  | 1 |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Calls | 112
 |  |  |  |  |  |  |  |  | Contacts | 0
 |  |  |  |  |  |  |  |  | Emails | 0
 |  |  |  |  |  |  |  |  | Sales Visits | 0
 |  |  |  |  |  |  |  |  | Call Contact | 0
 |  |  |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  |  |  | Daily Totals | 112
Spreadsheet: 851984d1702091210-critical-items-transfer-critical-item-transfer
Sheet: Feuil1

 |  |  | Item | Critical?
 |  | Critical Items List
 |  | Normal List | Oranges
 |  |  | apples
 |  |  | shoes
 |  |  | tables
 |  |  | desks
 |  |  | chairs
 |  |  | radios
 |  |  | hearphones
 |  |  | phones
 |  |  | dronees
 |  |  | cameras
 |  |  | mice
 |  |  | pens
 |  |  | mugs
 |  |  | spoons
 |  |  | forks
 |  |  | tissues
 |  |  | notebooks
 |  |  | computers
 |  |  | bottles
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 13 March 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-03-13 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Sick leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 109852 | 88421
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 80940 | 79375 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 103563 | 94939
500293 | 61127 | 73455
500302 |  | 954
500303 | 38016 | 29797
500305 | 151353 | 159991
500307 | 4842 | 6633
500313 |  | 379
500314
500655 | 18984
500657 | 24745 | 9811
INDEX
2000-11-30 00:00:00 |  |  | -119720.43
2000-12-03 00:00:00
Spreadsheet: 72223d1272923192-dynamic-graph-dynamic-graph
Sheet: Sheet1

Day | No. of Occurances | Time Elapsed | Description |  |  |  |  | Day
1 | 25 | 345 | A |  |  |  |  | 1 | 1
1 | 15 | 5 | B |  |  |  |  |  | 2
1 | 65 | 435 | G |  |  |  |  |  | 3
1 | 67 | 36 | F |  |  |  |  |  | 4
1 | 2 | 36 | E |  |  |  |  |  | 5
1 | 16 | 3 | R |  |  |  |  |  | 6
1 | 17 | 5 | W |  |  |  |  |  | 7
1 | 2 | 35 | Q |  |  |  |  |  | 8
2 | 3 | 3 | A |  |  |  |  |  | 9
2 | 1 | 5 | B |  |  |  |  |  | 10
2 | 24 | 3 | T |  |  |  |  |  | 11
2 | 1 | 63 | Y
2 | 1 | 6 | U
3 | 24 | 436 | B
3 | 1 | 3 | A
3 | 9 | 46 | L
3 | 4 | 4 | K
3 | 25 | 64 | J
3 | 15 | 36 | H
3 | 65 | 45 | G
3 | 7 | 6 | F
3 | 3 | 47 | D
3 | 8 | 4 | S
3 | 7 | 74 | Q
3 | 64 | 6 | W
4 | 3 | 3 | A
4 | 4 | 532 | B
4 | 2 | 876 | D
4 | 16 | 236 | R
5 | 170 | 437 | T
5 | 16 | 4 | Y
5 | 1 | 643 | U
5 | 2 | 6 | I
5 | 1 | 36 | O
5 | 2 | 4 | P
5 | 1 | 74 | Q
Spreadsheet: kate_symes__18336__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-19 00:00:00 |  | 238.07 | 27808 | 156.7 | 11200
 | 2001-04-18 00:00:00 |  | 238.07 | 27808 | 156.7 | 11200
 | 2001-04-17 00:00:00 |  | 238.07 | 27808 | 156.7 | 11200
 | 2001-04-16 00:00:00 |  | 286.52 | 25008 | 213.36 | 10232
 | 2001-04-15 00:00:00 |  |  |  |  |  | 213.36 | 30696
 | 2001-04-14 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-13 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-12 00:00:00 |  | 341.1 | 29680 | 318.17 | 10400
 | 2001-04-11 00:00:00 |  | 348.15 | 35136 | 310.12 | 10400
 | 2001-04-10 00:00:00 |  | 326.44 | 32608 | 301.85 | 13000
 | 2001-04-09 00:00:00 |  | 268.28 | 26320 | 225.55 | 9800
 | 2001-04-08 00:00:00 |  |  |  |  |  | 225.55 | 29400
 | 2001-04-07 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-06 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-05 00:00:00 |  | 301.84 | 30864 | 235.95 | 8200
 | 2001-04-04 00:00:00 |  | 278.15 | 35376 | 204.75 | 9232
 | 2001-04-03 00:00:00 |  | 245.99 | 21936 | 136.34 | 7512
 | 2001-04-02 00:00:00 |  | 228.71 | 17360 | 140.68 | 5000
 | 2001-04-01 00:00:00 |  |  |  |  |  | 142.24 | 15000
 | 2001-03-31 00:00:00 |  | 181.02 | 24000 | 93.46 | 3640
 | 2001-03-30 00:00:00 |  | 181.94 | 20800 | 93.46 | 3640
 | 2001-03-29 00:00:00 |  | 178.38 | 28864 | 87.16 | 10496
 | 2001-03-28 00:00:00 |  | 142.39 | 35120 | 78.18 | 4400
 | 2001-03-27 00:00:00 |  | 140.58 | 29520 | 76.2 | 4000
 | 2001-03-26 00:00:00 |  | 266.09 | 24560 | 155.06 | 6160
 | 2001-03-25 00:00:00 |  |  |  |  |  | 153.65 | 16680
 | 2001-03-24 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-23 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-22 00:00:00 |  | 294.15 | 12720 | 177.94 | 7200
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
Spreadsheet: 755944d1637191812-excel-formula-with-criteria-sample-prob
Sheet: Sheet5

Month | Date | Week# | Manager | Analyst | EID | Criticality | Response | QID | Penalty | Score
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 15544 | Critical | Fail | 96
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 15544 | Non-Critical | Fail | 97
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 12311 | Non-Critical | Fail | 143
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 12311 | Non-Critical | Fail | 95
November | 2021-11-04 00:00:00 | 1 | Iron Man | Black Widow | 12311 | Non-Critical | Fail | 100
November | 2021-11-01 00:00:00 | 1 | Captain America | Spider-Man | 15548 | Non-Critical | Fail | 97
November | 2021-11-01 00:00:00 | 1 | Captain America | Antman | 19340 | Non-Critical | Fail | 95
November | 2021-11-03 00:00:00 | 1 | Iron Man | War Machine | 19340 | Critical | Fail | 143
November | 2021-11-04 00:00:00 | 1 | Iron Man | War Machine | 17302 | Non-Critical | Fail | 97
November | 2021-11-04 00:00:00 | 1 | Captain America | [NAME] | 10143 | Non-Critical | Fail | 97
November | 2021-11-04 00:00:00 | 1 | Captain America | [NAME] | 17302 | Non-Critical | Fail | 95
November | 2021-11-10 00:00:00 | 2 | Captain America | Antman | 15548 | Non-Critical | Fail | 115
November | 2021-11-10 00:00:00 | 2 | Captain America | [NAME] | 17302 | Non-Critical | Fail | 97
November | 2021-11-10 00:00:00 | 2 | Captain America | [NAME] | 17302 | Non-Critical | Fail | 96
Spreadsheet: 96795d1296071433-building-a-pricing-model-price-modeling
Sheet: Sheet1

Helper Column | Min | [NAME] | Per Person | Base |  |  |  | Enter number of people: | 50
2 | 1 | 50 | 50 | 0
 | 51 | 100 | 40 | 2500 |  |  |  | Price: | 2500
 | 101 | 150 | 30 | 4500
 | 151 | 200 | 20 | 6000
 | 201 | 250 | 10 | 7000
 | 251 | 300 | 5 | 7500
 | 301 | 9999 | 2.5 | 7750
Spreadsheet: 479287d1473298850-time-overlapping-in-excel-version-2016-admin-exp-v2
Sheet: Sheet1

Solids |  |  |  |  |  |  |  |  |  | Total hours Worked
Name | T.S | T.E | Hours |  |  |  |  |  |  | Name | Hours
[NAME] | 09:00:00 | 09:20:00 |  |  |  |  |  |  |  | [NAME]
[NAME] | 13:00:00 | 13:45:00 |  |  |  |  |  |  |  | Power
[NAME] | 14:10:00 | 14:45:00 |  |  |  |  |  |  |  | Percy
[NAME] | 14:30:00 | 15:05:00 |  |  |  |  |  |  |  | Mark
[NAME] | 15:00:00 | 15:40:00 |  |  |  |  |  |  |  | Fred
[NAME] | 15:50:00 | 16:20:00 |  |  |  |  |  |  |  | [NAME]
Luyanda | 10:00:00 | 10:05:00
Luyanda | 10:09:00 | 12:45:00
[NAME] | 08:20:00 | 08:50:00
[NAME] | 09:31:00 | 10:30:00
[NAME] | 11:01:00 | 11:30:00
[NAME] | 11:30:00 | 12:15:00
[NAME] | 11:45:00 | 12:30:00
[NAME] | 15:30:00 | 16:00:00
Mark | 09:51:00 | 10:25:00
Mark | 10:00:00 | 11:00:00
Mark | 10:10:00 | 11:10:00
Mark | 11:00:00 | 11:25:00
Mark | 10:52:00 | 11:40:00
Mark | 11:30:00 | 12:15:00
Mark | 12:25:00 | 13:30:00
Mark | 12:30:00 | 13:25:00
Mark | 13:25:00 | 14:10:00
Power | 08:10:00 | 08:25:00
Power | 09:10:00 | 11:00:00 |  |  |  | Overlap |  | 1.83 should be counted once
Power | 09:10:00 | 11:00:00
Power | 11:00:00 | 12:00:00 |  |  |  | Overlap |  | He was working from 11am to 1pm = 2 hours not 3
Power | 11:00:00 | 13:00:00
Power | 15:00:00 | 15:30:00 |  |  |  | Overlap |  | He was working from 3pm to 3:30 pm , 3pm to 3:20 should not be recorded
Power | 15:00:00 | 15:20:00
Power | 15:00:00 | 16:00:00 |  |  |  | Overlap |  | 30 minutes should be added here because he ended at 3:30 as above ^
Power | 14:00:00 | 14:45:00
Power | 15:00:00 | 16:00:00 |  |  |  | Overlap |  | This mixture was done at the same time as another, it should not be recorded.
 |  |  |  |  |  |  |  |  |  | Power
Spreadsheet: 115479d1311085131-compiling-complex-text-data-in-a-table-test
Sheet: SUMMARY

 | Counselling | Resources | Childcare | Activity
AB10 | 1 | 1 | 2 | 0
AB11 | 0 | 0 | 0 | 1
AB2 | 3 | 2 | 0 | 0
AB3 | 0 | 0 | 0 | 0
Data that should be in here, from the TEST2 spreadsheet:
 | Counselling | Resources | Childcare | Activity
AB10 | 1 | 1 | 2 | 0
AB11 | 0 | 0 | 0 | 1
AB2 | 3 | 2 | 0 | 0
AB3 | 0 | 0 | 0 | 0
Spreadsheet: 453976d1459547304-slicer-sample-sheet
Sheet: Sheet6

 | Row Labels | Voice | Ticket | Overall |  | Row Labels | Sum of WK2 | Sum of WK3 | Sum of WK4
 | ALEXANDER | 0.9550000000000001 | 0.995 | 0.9749999999999998 |  | ACTIVE LISTENING & RESPONSIVENESS | 0 | 0 | 0.01886792452830189
 | ALFIE | 0.8514285714285715 | 0.9671428571428571 | 0.9092857142857144 |  | CALL CONTROL | 0.03846153846153846 | 0 | 0
 | CHARLIE | 0.898 | 0.966 | 0.932 |  | Categorization | 0.03846153846153846 | 0.03750000000000001 | 0
 | DANIEL | 0.9716666666666667 | 0.98 | 0.9758333333333334 |  | CLOSING SCRIPT | 0 | 0.0625 | 0.1132075471698113
 | HARRY | 0.94 | 0.9725 | 0.95625 |  | Customer Education/Setting Expect. | 0 | 0.0125 | 0.03773584905660377
 | JACK | 0.9371428571428572 | 0.8928571428571429 | 0.915 |  | DEAD AIR MANAGEMENT | 0.07692307692307693 | 0.025 | 0.05660377358490566
 | JACOB | 0.96 | 0.9899999999999999 | 0.975 |  | Documentation accuracy | 0.03846153846153846 | 0.0125 | 0
 | [NAME] | 0.955 | 0.98 | 0.9675 |  | Effective usage of resources | 0.03846153846153846 | 0 | 0
 | NOAH | 0.765 | 0.695 | 0.73 |  | EMPATHY/ASSURANCE/OWNERSHIP | 0.03846153846153846 | 0 | 0.01886792452830189
 | [NAME] | 0.965 | 0.9466666666666667 | 0.9558333333333334 |  | Follow up on the tickets | 0.03846153846153846 | 0 | 0
 | THOMAS | 0.9219999999999999 | 0.942 | 0.932 |  | FURTHER ASSISTANCE | 0 | 0 | 0.03773584905660377
 | Grand Total | 0.9155932203389827 | 0.9328813559322033 | 0.924237288135593 |  | HOLD PROCEDURE - Reason for hold | 0 | 0 | 0.01886792452830189
 |  |  |  |  |  | HOLD PROCEDURE - Seeking permission | 0 | 0 | 0.01886792452830189
 |  |  |  |  |  | HOLD PROCEDURE - Thanking the user | 0 | 0 | 0.01886792452830189
 |  |  |  |  |  | INTONATION AND TONE | 0.03846153846153846 | 0 | 0
 |  |  |  |  |  | Linear Logical steps | 0 | 0 | 0.01886792452830189
 |  |  |  |  |  | PARAPHRASING | 0 | 0 | 0.01886792452830189
 |  |  |  |  |  | Pitch in for CSAT | 0 | 0.075 | 0.1320754716981132
 |  |  |  |  |  | Prioritization | 0.03846153846153846 | 0 | 0
 |  |  |  |  |  | Probing | 0.03846153846153846 | 0 | 0.01886792452830189
 |  |  |  |  |  | RAPPORT BUILDING | 0.03846153846153846 | 0.025 | 0.01886792452830189
 |  |  |  |  |  | Select approp. Status | 0.03846153846153846 | 0 | 0
 |  |  |  |  |  | Ticket no provided | 0.03846153846153846 | 0.075 | 0.07547169811320754
 |  |  |  |  |  | TRANSFER PROCEDURE | 0 | 0.0125 | 0
 |  |  |  |  |  | Verified resolution & Recapped | 0 | 0.0125 | 0
 |  |  |  |  |  | Verify/Update User's A/c details | 0 | 0.0125 | 0
 |  |  |  |  |  | VIP process followed | 0 | 0 | 0.01886792452830189
 |  |  |  |  |  | VOLUME/RATE OF SPEECH | 0 | 0 | 0.03773584905660377
Spreadsheet: 16a9deaf-0b83-4678-b408-3bf65639642d
Sheet: Sheet1

Unnamed: 0 | Ohio Department of Alcohol & Drug Addiction Services | Unnamed: 2 | Unnamed: 3
 | SFY 2010 Capital Grant Expenditure/DrawDown Form
Agency:
Report through (month):
State Grant #:
For ODADAS Internal Use Only
Approved By |  | Date
A. Budget Categories | B. ODADAS Funds | C. Local Match Funds | D. Total Funds
A1. Design/Planning |  |  | 0
A2. Permits |  |  | 0
A3. Renovation/Repair |  |  | 0
A4. Other |  |  | 0
E. Totals | 0 | 0 | 0
Expenditures | B. ODADAS Funds | C. Local Match Funds | D. Total Funds
Budget Totals | 0 | 0 | 0
Paid to Date |  |  | 0
Project Balance | 0 | 0 | 0
Project Remaining %
Draw Down Request | B. ODADAS Funds
[NAME] | 0
Received to Date
Requested this month
Balance Available | 0
The person submitting this form must print or type their name and sign and date the form
Prepared by:
Fiscal Signature:
Date:
Submit this report on a monthly basis, by the 20th of each month, until the project is complete, to:
 | ODADAS
 | Division of Fiscal Services
 | Att: Nikki Bahan
 | 280 [NAME], 12th [NAME]
 | Columbus, OH 43215
NOTE: The first drawdown request should be submitted as soon as possible to ensure
the disburement of grant funds in early July, 2009.