tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 71551d1272335021-excel-2007-finding-and-listing-valid-cells-randomly-fails-takesheet_roster_re_done
Sheet: Sheet1

Monday |  | WEATHER/TEMPERATURE:
Day Staff | Time Late | Start | Break | Finish |  |  |  | Day Hours | Night Hours | Past Midnight
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 1
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 2
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 3
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 4
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 5
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 6
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 7
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 8
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 9
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 10
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 11
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 12
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 13
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 14
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 15
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 16
 |  |  | 0 | 17:00:00 |  |  |  |  |  |  | 17
Night Staff | Time Late | Start | Break | Finish |  |  |  | Day Hours | Night Hours | Past Midnight
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 1
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 2
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 3
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 4
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 5 |  |  | [NAME] should be listed for this position
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 6 |  |  | Can not figure out why…
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 7
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 8
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 9
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 10
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 11
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 12
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 13
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 14
 |  | 17:00:00 | 0 | 17:00:00 |  |  |  |  |  |  | 15
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  |  |  |  |  | Bar Staff Day Hrs
 |  |  |  |  |  | Bar Staff Night Hrs
 |  |  |  |  |  | Hrs After Midnight
Casual Manager |  | Start | Break | Finish |  |  |  | Day Hours | Night Hours | Past Midnight
Nicole |  | 07:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
 |  | 17:00:00 | 0 | 17:00:00
Salary Manager | Day | Night |  |  |  | Manager [NAME]
Enter Number --> |  |  |  |  |  | Manager [NAME]
 |  |  |  |  |  | Manager M/D Hrs
Bar Staff rates slightly adjusted for differnce between glassy, bartender, supervisor
Rates | Daily | Saturday | Sunday
Bar Staff | 19 | 23 | 26.5
Casual Manager | 22.34 | 26.81 | 31.27
Day Staff Costs | Bar Wages | Bev Sales | %
Night Staff Cost | Bar Wages | Bev Sales | %
Spreadsheet: 298370d1392771287-index-and-match-formula-monthsie-totals
Sheet: A

Sr | Category | Description | Pack size | Unit | January | February | March | April | May | June | July | August | September | October | November | December | Grand Total
1 |  | Delico | 0.4 | [NAME] | 0 | 750 | 650 | 300 | 100 | 400 | 300 | 600 | 0 | 0 | 400 | 200
2 |  | Parco | 10 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  | Doce | 0.25 | [NAME] | 0 | 100 | 150 | 100 | 0 | 600 | 1600 | 1050 | 100 | 0 | 0 | 0
4 |  | Fast | 0.35 | [NAME] | 0 | 200 | 200 | 100 | 0 | 100 | 100 | 0 | 0 | 200 | 200 | 200
5 |  | Sider | 1 | [NAME] | 0 | 50 | 150 | 50 | 0 | 50 | 50 | 0 | 0 | 100 | 100 | 100
6 |  | Glaxo | 10 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  | Sweets | 0.25 | [NAME] | 0 | 2050 | 5050 | 50 | 0 | 50 | 50 | 0 | 0 | 0 | 0 | 0
8 |  | Parden | 0.5 | [NAME] | 0 | 650 | 750 | 50 | 0 | 50 | 250 | 200 | 0 | 100 | 100 | 100
9 |  | Romeo | 0.25 | [NAME] | 0 | 200 | 300 | 100 | 0 | 100 | 100 | 0 | 0 | 100 | 200 | 100
10 |  | Clutch | 1 | [NAME] | 0 | 100 | 100 | 100 | 0 | 100 | 100 | 0 | 0 | 100 | 200 | 200
11 |  | [NAME] | 10 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  | Rifit | 0.5 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  | Ganzo | 0.5 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 721009d1614426139-need-help-to-remove-false-and-shorten-the-formula-sample-workbook-2-
Sheet: Non-Manpower Cost

Supplies CostsSpecialist Outpatient Clinic | Supplies Costs | Specialist Outpatient Clinic | Standard subsidised clinic (per attendance)
Supplies CostsSpecialist Outpatient Clinic | Supplies Costs | Specialist Outpatient Clinic | High volume subsidised clinic (per attendance)
Supplies CostsSpecialist Outpatient Clinic | Supplies Costs | Specialist Outpatient Clinic | Private clinic (per attendance)
Supplies CostsInpatient Ward | Supplies Costs | Inpatient Ward | Acute ward (per patient day)
Supplies CostsInpatient Ward | Supplies Costs | Inpatient Ward | Subacute ward (per patient day)
Supplies CostsInpatient Ward | Supplies Costs | Inpatient Ward | ICU/HD ward (per patient day)
Supplies CostsOperating Theatre | Supplies Costs | Operating Theatre | excluding implants (per procedure)
Supplies CostsEndoscopy Room | Supplies Costs | Endoscopy Room | per procedure
Facility CostsSpecialist Outpatient Clinic | Facility Costs | Specialist Outpatient Clinic | Standard subsidised clinic (per attendance)
Facility CostsSpecialist Outpatient Clinic | Facility Costs | Specialist Outpatient Clinic | High volume subsidised clinic (per attendance)
Facility CostsSpecialist Outpatient Clinic | Facility Costs | Specialist Outpatient Clinic | Private clinic (per attendance)
Facility CostsInpatient Ward | Facility Costs | Inpatient Ward | Acute ward (per patient day)
Facility CostsInpatient Ward | Facility Costs | Inpatient Ward | Subacute ward (per patient day)
Facility CostsInpatient Ward | Facility Costs | Inpatient Ward | ICU/HD ward (per patient day)
Facility CostsOperating Theatre | Facility Costs | Operating Theatre | per procedure
Facility CostsOperating Theatre | Facility Costs | Operating Theatre | per session (4 hours)
Facility CostsEndoscopy Room | Facility Costs | Endoscopy Room | per procedure
Facility CostsEndoscopy Room | Facility Costs | Endoscopy Room | per session (4 hours)
Other CostsSpecialist Outpatient Clinic | Other Costs | Specialist Outpatient Clinic | Standard subsidised clinic (per attendance)
Other CostsSpecialist Outpatient Clinic | Other Costs | Specialist Outpatient Clinic | High volume subsidised clinic (per attendance)
Other CostsSpecialist Outpatient Clinic | Other Costs | Specialist Outpatient Clinic | Private clinic (per attendance)
Other CostsInpatient Ward | Other Costs | Inpatient Ward | Acute ward (per patient day)
Other CostsInpatient Ward | Other Costs | Inpatient Ward | Subacute ward (per patient day)
Other CostsInpatient Ward | Other Costs | Inpatient Ward | ICU/HD ward (per patient day)
Other CostsOperating Theatre | Other Costs | Operating Theatre | per procedure
Other CostsOperating Theatre | Other Costs | Operating Theatre | per session (4 hours)
Other CostsEndoscopy Room | Other Costs | Endoscopy Room | per procedure
Other CostsEndoscopy Room | Other Costs | Endoscopy Room | per session (4 hours)
Spreadsheet: jonathan_mckay__16900__Area Managers
Sheet: Fairview

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | The Fairview Community Association |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 672.96
 | February | 703.25
 | March | 500.59
 | April | 520.39
 | May | 200.2
 | June | 120.43
 | July | 134.28
 | August | 126.71
 | September | 242.78
 | October | 320.25
 | November | 510.17
 | December | 525.98
 | TOTAL:
Spreadsheet: 133786d1324612721-doesnt-seem-right-from-previous-year-p-and-l2010help
Sheet: June

Profit and Loss Statement |  | Tax Year: |  | June
 |  | Monthly Summary | Total Income
 |  |  | Total Expense
Gross margin  [L/J]
Return on sales  [T/J] |  |  | Profit / (Loss)
Net Profit % Change from Prior Period
 | Prior Period | Current Period | Current Period as    % of Sales | % Change from Prior Period
Sales Revenue
Health Insurance
Medicare Advantage
Medicare Supplement
Life Insurance |  | 2700
Investment (Annuity)
Other
Total Sales Revenue  [J]
Cost of Sales
Specify
Total Cost of Sales  [K]
Gross Profit  [L=J-K]
Operating Expenses
Sales and Marketing
Advertising (Radio, TV, Print Media, etc) |  | 175
Printing
Direct marketing
Seminar
Meals and Entertainment
Total Sales and Marketing Expenses  [M]
Research & Development
Licenses
Education
Total Research & Development Expenses  [N]
General and Adminstrative
Rent
Payroll
Utilities
Telephone
Health Insurance
E&O Insurance
Software
Web Hosting and domains
Postage
Office Supplies
Equipment
Repairs and maintenance
Other expenses (specify)
Auto (Tires, Fuel, Oil, Tolls, [NAME], etc)
Auto Mileage (IRS standard deduction; averaged) |  | 234
Total General & Adminstrative Expenses  [O]
Total Operating Expenses  [P=M+N+O]
Income from Operations  [Q=L-P]
Other Income (Bonuses) [R]
Taxes
Payroll Taxes
Property Taxes
Total Taxes  [S] |  |  |  |  | Return on sales does not include bonuses
Net Profit  [T=Q+R-S]
Spreadsheet: 884782d1734041871-best-way-to-conditional-sum-across-sheets-conditional-sums-across-sheets
Sheet: Sheet A

Criteria 1 | [NAME] | Criteria 3 | Sales
Global | Client A | EU | 22685
Global | Client A | NA | 28915
Global | Client A | ROW | 35626
Global | Client B | EU | 19815
Global | Client B | NA | 49972
Global | Client B | ROW | 31676
Spreadsheet: 232ddfad-e9a9-4f31-a5df-9ec72c5351aa
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 7 Biotechnology 7.8 Biocomputing 7.8.1 Laboratory data systems and documentation
No. | Company | Country | City | [NAME] | Hall/Booth
1 | AAC Infotray AG | Switzerland | [NAME] | 8400 | B2.228
2 | [NAME] GmbH | Germany | [NAME] | 31542 | B1.401
3 | t&p Triestram & Partner GmbH | Germany | Bochum | 44795 | B2.327/426
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 | -399
2001-12-31 00:00:00 |  |  | 67745
2002-01-03 00:00:00
CBS Volume
 |  |  | 36152
Spreadsheet: 168950d1342637683-spreadsheet-with-unknown-columns-cash-report-july-2012-v1
Sheet: 06-06-12

 | Bank Balance | 2012-06-06 00:00:00 |  | 5257.88
 |  | Due Date | Amount
Add | Deposits
 | Visa/Mastercard/Amex Deposits |  | 215
 | Daily Deposits |  | 670.73
 | Health Care Authority (Actual) | 2012-06-06 00:00:00
 | Health Care Authority (Estimate)
 |  |  | DEPOSITS=
Less | Outstanding Checks
4930 | [NAME] | 2012-05-23 00:00:00 | -1993.46
4938 | Smart Image Systems | 2012-06-04 00:00:00 | -405.74
4940 | [NAME] Ivy | 2012-06-06 00:00:00 | -2902.28
4941 | [NAME] | 2012-06-06 00:00:00 | -1792.88
4942 | [NAME] | 2012-06-06 00:00:00 | -1022.2
4943 | [NAME] | 2012-06-06 00:00:00 | -1716.03
4944 | Debbie R Baker | 2012-06-06 00:00:00 | -1176.34
4945 | [NAME] | 2012-06-06 00:00:00 | -1495.31
4947 | [NAME] | 2012-06-06 00:00:00 | -753.8
4948 | Heather P Bowles | 2012-06-06 00:00:00 | -1162.83
4949 | [NAME] | 2012-06-06 00:00:00 | -1852.15
4952 | [NAME] | 2012-06-06 00:00:00 | -70.11
4954 | [NAME] | 2012-06-06 00:00:00 | -819.24
4955 | [NAME] | 2012-06-06 00:00:00 | -2256.64
4959 | [NAME] | 2012-06-06 00:00:00 | -246.77
4946 | [NAME] | 2012-06-06 00:00:00 | -613.19
4957 | Madison A [NAME] | 2012-06-06 00:00:00 | -1164.09
 |  |  | O/S CHECKS=
Less | Online [NAME]Other
 | IRS FED W/H PPE 05-23-12 | 2012-05-30 00:00:00 | -5445.33
 | Cash Transfer - Dr. [NAME] | 2012-06-04 00:00:00 | -500
 | Citi Bank | 2012-06-05 00:00:00 | -800
 | Cox | 2012-06-08 00:00:00 | -328.87
 | Haliburton 5.1 | 2012-06-08 00:00:00 | -403.91
 | Haliburton 5.4 | 2012-06-08 00:00:00 | -212.64
 | Riveroaks | 2012-06-08 00:00:00 | -3678.5
 | IRS FED W/H PPE 06-06-12 | 2012-06-13 00:00:00 | -5106.09
 | IRS - Payment Plan | 2012-06-13 00:00:00 | -3000
 | OESC Payment Plan | 2012-06-15 00:00:00 | -2839.58
 |  |  | O/S BILL PAY =
 |  |  | Ending Cash Balance
 | DAILY CASH RECONCILIATION - not used for forecast
 | Ending Cash Balance G/L | Quickbooks |  | -946.81
 | O/S Checks | Add from above
 | Total
 | Bank Balance | Bank Bal plus todays deposit
 | Difference | Quickbooks vs Arvest
Spreadsheet: 696958d1601050654-if-vlookup-with-clusters-if-vlookup
Sheet: Sheet1

Alphabet id | Alphabet | Desired Output
445593 | TEST_102559 | Y
445430 | TEST_102559 | Y
278544 | TEST_104994 | Y
278472 | TEST_104994 | Y
258939 | TEST_108069 | Y
258941 | TEST_108069 | Y
444942 | TEST_11417 | Y
444950 | TEST_11417 | Y
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
513548 | TEST_11679 | X
449558 | TEST_11779 | Y
449449 | TEST_11779 | Y
283163 | TEST_118461 | Y
281913 | TEST_118860 | Y
281866 | TEST_118860 | Y
290367 | TEST_123155 | Y
513545 | TEST_125471 | Y
513559 | TEST_125471 | Y
513626 | TEST_125471 | Y
Spreadsheet: a7c0d422-fa17-426d-a7cb-11dd794ae4d3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6848 | 40954 | Faye | Mcclelland | GBR | 28 | [NAME] | 00:01:13 | 00:43:08 | 00:00:47 | 00:18:23 | 1 | 01:16:21
6848 | 30601 | Clare | Cunningham | GBR | 26 | [NAME] | 00:01:19 | 00:48:00 | 00:00:48 | 00:20:57 | 2 | [NAME]
6848 | 23650 | [NAME] | Dasse | FRA | 27 | 00:18:22 | 00:01:02 | 00:47:10 | 00:00:41 | 00:28:01 | 3 | 01:35:15
6848 | 43223 | [NAME] | [NAME] | USA | 29 | 00:18:20 | 00:02:06 | 00:48:18 | 00:01:29 | 00:25:41 | 4 | 01:35:51
6848 | 51205 | Anna | Bychkova | RUS | 25 | 00:17:19 | 00:02:15 | 00:57:42 | 00:00:47 | 00:28:51 | 5 | 01:46:53
Spreadsheet: 122779d1317143959-excel-2007-summing-a-column-based-on-multiple-criteria-in-2-other-columns-example
Sheet: Data

Expense Type | Amount | Owner
Hardware | 1 | BB
Software | 2 | CC
Lease | 3 | DD
Hardware | 4 | CC
Software | 5 | DD
Lease | 6 | AA
Hardware | 8 | BB
Software | 8 | BB
Lease | 9 | AA
Hardware | 10 | CC
Software | 11 | DD
Lease | 12 | AA
Hardware | 13 | BB
Software | 14 | CC
Lease | 15 | CC
Hardware | 16 | AA
Software | 17 | AA
Lease | 18 | AA
Total
Spreadsheet: 44206d1242841167-excel-2007-help-tying-cells-together-excel-sample
Sheet: Sheet1

0901432400C1 | 2009-02-26 00:00:00 |  |  | 46530 | USA | -315.75 | 98SPK | -1 |  | 6.95 | C10-7 | 269270-100
 |  |  |  |  |  |  | 99SW | -1 |  |  | C10-7 | 337763-388
 |  |  |  |  |  |  | 98HK | -1 |  |  | C10-B | 274947-695
 |  |  |  |  |  |  | 99SW | -1 |  |  | C9-31 | 327010-100
 |  |  |  |  |  |  | 98HK | -1 |  |  | C9-20 | 269272-594
 |  |  |  |  |  |  | 98SPK | -1 |  |  | C9-18 | 243976-100
 |  |  |  |  |  |  | 99SK | -1 |  |  | C8-31 | 323808-610
 |  |  |  |  |  |  | 98SPM | -1 |  |  | C7-77 | 269610-451
 |  |  |  |  |  |  | 98SPM | -1 |  |  | C7-42 | 255501-010
 |  |  |  |  |  |  | 99SW | -1 |  |  | C4-32 | E15835.2
 |  |  |  |  |  |  | 99SW | -1 |  |  | C3-03 | E87143.2
0901432401C1 | 2009-02-26 00:00:00 |  |  | 46530 | USA | -55 | 99SW | -1 |  | 0 | C10-3 | 327025-388
Spreadsheet: 871005d1717479927-extract-unique-activities-based-on-sequential-activity-logs-user-activity-log
Sheet: User activity

Date | User | Action
2024-05-01 09:45:00 | User 1 | Logged in
2024-05-01 09:47:00 | User 1 | Edited content
2024-05-01 09:48:00 | User 1 | Approved content
2024-05-01 09:50:00 | User 1 | Uploaded file
2024-05-01 09:52:00 | User 1 | Logged out
2024-05-01 10:45:00 | User 2 | Logged in
2024-05-01 10:47:00 | User 2 | Edited content
2024-05-01 10:48:00 | User 2 | Approved content
2024-05-01 10:50:00 | User 2 | Uploaded file
2024-05-01 10:55:00 | User 2 | Logged out
2024-05-01 11:45:00 | User 3 | Logged in
2024-05-01 11:47:00 | User 3 | Edited content
2024-05-01 11:51:00 | User 3 | Approved content
2024-05-01 11:56:00 | User 3 | Uploaded file
2024-05-01 11:58:00 | User 3 | Logged out
2024-05-01 12:45:00 | User 1 | Logged in
2024-05-01 12:47:00 | User 1 | Edited content
2024-05-01 12:48:00 | User 1 | Approved content
2024-05-01 12:50:00 | User 1 | Uploaded file
2024-05-01 12:59:00 | User 1 | Logged out
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 31

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 22 Dec Glucose mmol/L
 |  |  |  |  | 6.3
Sat 23 Dec Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 24 Dec Glucose mmol/L
Mon 25 Dec Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  |  | 6.1
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 26 Dec Glucose mmol/L
Wed 27 Dec Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 28 Dec Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Fri 29 Dec Glucose mmol/L
Spreadsheet: 356234d1415033291-unlocking-a-cell-in-a-table-service-now-stage-flow
Sheet: Stages and States

Step 1:  Stage = Manager [NAME]
State | Stage | Comments | IMPORTANT | Picture
Open | Manager [NAME] (in progress) | No tasks are assigned.  [NAME] is requested. | Cannot procede to Business Approval or Fulfillment until Manager [NAME] is complete
Work in Progress | Manager [NAME] ([NAME]) | Once manager approval has been completed,  stage is changed  to "Business Approval" or "Fulfillment (in progress)" | RITM can not procede to Business Approval or Fulfillment until Manager [NAME] is complete.
Step 2: Stage = Business Approval  (If necessary)
Open | Business Approval (In Progress) | One or more of the Approvers has been requested for approval, but  has not approved yet.  Tasks are not assigned yet in this stage/state | Approval is requested, but not Approved yet.  Tasks are not created until approval has been approved. RITM can not move from this stage until Business Approval is given.
Work In Progress | Business Approval (Completed) | Business Approval has been approved, and tasks can now be assigned. | Once Business approval has been completed, RITM can move to Fulfillment stage.
Open | Business Approval (Completed) | This is common when the [NAME] is software.  This means that Manager [NAME] and Business Approval has been completed, but "Approvers" has State(s) which are "No Longer Required.  Tasks sometimes are assigned. | Fulfillment can not start until "Waiting for Approval" is complete
Step 3: Stage = Fulfillment
Open | Fulfillment (In Progress) | Fulfillment is still in progress. This is only seen when [NAME] is "Other Online Service Desk / ServiceNow change" | Tasks are still work in Progress.   Waiting for tasks to be closed to be completed.
Work In Progress | Fulfillment (In Progress) | One or more tasks are still in progress or Open.  Once all tasks are closed complete, Fulfillment can move to completed | Waiting for tasks to be closed to be completed.
Work In Progress | Fulfillment (Completed) | All tasks are complete.  Once it is completed, the RITM is no longer active. | Active no longer true when completed.
Spreadsheet: 45252d1244036162-counting-by-2-or-more-criteria-example
Sheet: Summary

Date | Cathy |  |  |  | [NAME] |  |  |  | Dawn |  |  |  | [NAME] |  |  |  | [NAME]
 | S Jobs Opened | W Jobs Opened | s Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed
2009-05-01 00:00:00
2009-05-02 00:00:00
2009-05-03 00:00:00
2009-05-04 00:00:00
2009-05-05 00:00:00
2009-06-01 00:00:00
2009-06-02 00:00:00
2009-06-03 00:00:00
2009-06-04 00:00:00
2009-06-05 00:00:00