tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 785005d1656075260-extracting-unique-values-from-2-spreadsheets-sample-9-r1
Sheet: Conditional formatting

 | Report B |  |  |  |  |  | Report B
Rpt | [NAME] | [NAME] | Amount | Unit Cost |  | Rpt | [NAME] | Unit Cost
Report A | OV | 158063 | 77 | 0 |  | Report B | 139318 | 295.4542
Report A | OV | 158064 | 1919.7 | 0 |  | Report B | 139318 | 90.9092
Report A | OV | 158145 | 49.54 | 0 |  | Report B | 139328 | 681.8183
Report A | OV | 158147 | 49.54 | 0 |  | Report B | 139329 | 154.5458
Report A | OV | 158144 | 49.54 | 0 |  | Report B | 149270 | 6462.0355
Report A | OV | 158148 | 49.54 | 0 |  | Report B | 154582 | 135108.7719
Report A | OV | 158288 | 5905.8 | 0 |  | Report B | 154582 | 28070.1754
Report A | OV | 158288 | 5905.8 | 0 |  | Report B | 156751 | 5000
Report A | OV | 139318 | 590.91 | 0 |  | Report B | 156751 | 6000
Report A | OV | 139318 | 181.82 | 0 |  | Report B | 156751 | 3500
Report A | OV | 139328 | 1363.64 | 0 |  | Report B | 156751 | 16800
Report A | OV | 139329 | 1545.46 | 0 |  | Report B | 158063 | 77
Report A | OV | 154582 | 4593.7 | 0 |  | Report B | 158064 | 40.5
Report A | OV | 154582 | 11733.33 | 0 |  | Report B | 158144 | 49.54
Report A | OV | 154582 | -4593.7 | 0 |  | Report B | 158145 | 49.54
Report A | OV | 154582 | -11733.33 | 0 |  | Report B | 158147 | 49.54
Report A | JE |  | 6500.6 | 0 |  | Report B | 158148 | 49.54
Report A | JE |  | 1587.9 | 0 |  | Report B | 158288 | 5905.8
Report A | JE |  | 360.3 | 0 |  | Report B | 158288 | 5905.8
Report A | JE |  | 187.6 | 0 |  | Report B | 158384 | 16242.1656
 |  |  |  |  |  | Report B | 158385 | 4333.9112
 |  |  |  |  |  | Report B | 158385 | 1266.8356
 |  |  |  |  |  | Report B | 158621 | 8.4
 |  |  |  |  |  | Report B | 158621 | 70
 |  |  |  |  |  | Report B | 158821 | 20627
 |  |  |  |  |  | Report B | 158863 | 38.63
Spreadsheet: 87708d1287582419-excel-2007-formatting-a-cell-to-match-other-cells-if-they-match-resourcing-tool-for-pam
Sheet: Sheet2 (2)

Ref | List of Priority Projects |  | 2010-10-25 00:00:00 |  |  |  | 2010-11-01 00:00:00 |  |  |  | 2010-11-08 00:00:00 |  |  |  | 2010-11-15 00:00:00 |  |  |  | 2010-11-22 00:00:00 |  |  |  | 2010-11-29 00:00:00 |  |  |  | 2010-12-06 00:00:00 |  |  |  | 2010-12-13 00:00:00 |  |  |  | 2010-12-20 00:00:00 |  |  |  | 2010-12-27 00:00:00 |  |  |  | 2011-01-03 00:00:00 |  |  |  | 2011-01-10 00:00:00 |  |  |  | 2011-01-17 00:00:00 |  |  |  | 2011-01-24 00:00:00 |  |  |  | 2011-01-31 00:00:00 |  |  |  | 2011-02-07 00:00:00 |  |  |  | 2011-02-14 00:00:00 |  |  |  | 2011-02-21 00:00:00 |  |  |  | 2011-02-28 00:00:00 |  |  |  | 2011-03-07 00:00:00 |  |  |  | 2011-03-14 00:00:00 |  |  |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-28 00:00:00
1 | 6193
2 | 6176
3 | 6387
4 | XXXX
5 | XXXX
6 | XXXX
7 | XXXX
8 | XXXX
 | Projects in Pipeline
 | XXXX
 | XXXX
 | XXXX
 | XXXX
 | Development Resource
 | Res 1 |  | 2 | 1
 | Res 2 |  | 2 | 2
 | Res 3 |  | 3 | 1 | 2 | 2
 | Res 4
 | Res 5
 | Res 6
 | Res 7
 | Res 8
 | Res 9
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -945 | -900
2 | -20011 | -20000
3 | -19998 | -20000
4 | -20411 | -20000
5 | -12817 | -9366
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
2001-12-31 00:00:00 |  |  | 186823
2002-01-05 00:00:00
CBS Dollars
 |  |  | 199813
Spreadsheet: 675923d1588563102-roster-pay-with-4-different-wages-based-on-time-period-roster-pay
Sheet: Sheet2

 |  |  |  | 1.75 |  | 1 |  | 1.25 |  | 1.75
 |  |  |  |  |  | 23.69
 |  |  |  | 00:00:00 | 06:59:00 | 07:00:00 | 17:59:00 | 18:00:00 | 22:59:00 | 23:00:00 | 23:59:00
 | Start | Finish |  |  |  |  |  |  |  |  |  | Total
2020-05-01 00:00:00 | 06:00:00 | 23:30:00
2020-05-02 00:00:00
2020-05-03 00:00:00
2020-05-04 00:00:00
2020-05-05 00:00:00
2020-05-06 00:00:00
2020-05-07 00:00:00
2020-05-08 00:00:00
2020-05-09 00:00:00
2020-05-10 00:00:00
2020-05-11 00:00:00
2020-05-12 00:00:00
2020-05-13 00:00:00
2020-05-14 00:00:00
2020-05-15 00:00:00
2020-05-16 00:00:00
2020-05-17 00:00:00
2020-05-18 00:00:00
2020-05-19 00:00:00
2020-05-20 00:00:00
2020-05-21 00:00:00
2020-05-22 00:00:00
2020-05-23 00:00:00
2020-05-24 00:00:00
2020-05-25 00:00:00
2020-05-26 00:00:00
2020-05-27 00:00:00
2020-05-28 00:00:00
2020-05-29 00:00:00
2020-05-30 00:00:00
2020-05-31 00:00:00
2020-06-01 00:00:00
2020-06-02 00:00:00
2020-06-03 00:00:00
2020-06-04 00:00:00
2020-06-05 00:00:00
2020-06-06 00:00:00
2020-06-07 00:00:00
2020-06-08 00:00:00
2020-06-09 00:00:00
2020-06-10 00:00:00
2020-06-11 00:00:00
2020-06-12 00:00:00
2020-06-13 00:00:00
2020-06-14 00:00:00
2020-06-15 00:00:00
2020-06-16 00:00:00
2020-06-17 00:00:00
2020-06-18 00:00:00
2020-06-19 00:00:00
2020-06-20 00:00:00
2020-06-21 00:00:00
2020-06-22 00:00:00
2020-06-23 00:00:00
2020-06-24 00:00:00
2020-06-25 00:00:00
2020-06-26 00:00:00
2020-06-27 00:00:00
2020-06-28 00:00:00
2020-06-29 00:00:00
2020-06-30 00:00:00
2020-07-01 00:00:00
2020-07-02 00:00:00
2020-07-03 00:00:00
2020-07-04 00:00:00
Spreadsheet: 38258d1236359436-pull-info-from-1-worksheet-into-another-not-a-one-to-one-relationship-index-match-info
Sheet: Sheet1

SPR | Hours | Description | Code | Category | OverallProj | New |  | 7 | New Items | SPR | Hours | Description | Code
7497 | 1 | Maint - Daily Maintenance | S | Rpt | SHOES |  |  |  |  | 16211 | 6 | Maint - Reporting & Support | S
7499 | 6 | Maint - IP Daily Maintenance | S | Maint | MAINT |  |  |  |  | 16467 | 0.5 | New Business  Impl | S
7777 | 132.25 | ADM | A | Adm | ADM |  |  |  |  | 16817 | 9 | Rads- to EDI | S
9999 | 48 | PTO | P | PTO | PTO |  |  |  |  | 16820 | 8.5 | [NAME] | S
11373 | 9 | CCM Coach Productivity Report | S | CCM | COACH |  |  |  |  | 16821 | 9.5 | Rads - Payment | S
12487 | 14 | Maint - Discoverer Datamart | S | Discoverer | GENERAL |  |  |  |  | 17005 | 2 | Rad Summary Report | S
13545 | 12 | CCM -  Reach and Engage Report | S | CCM | COACH |  |  |  |  | 17006 | 1.5 | [NAME] | S
13604 | 152.5 | RFP - BH Support-ASD | S | RFP | BH
14901 | 6.5 | Support of AE -- T S | S | Supt-ESG | BH
14905 | 3.75 | Support of AE -- NN | S | Supt-ESG | BH
14906 | 2 | Support of AE -- DR | S | Supt-ESG | BH
14909 | 34 | Support of AE - GB | S | Supt-ESG | BH
14913 | 2 | Support of AE -- SR | S | Supt-ESG | BH
16211 | 6 | Maint - Reporting & Support | S | #N/A | #N/A | 1
16402 | 48.5 | Application Development-Ver. 2.0 | S | Smart | SURVEY
16467 | 0.5 | New Business  Impl | S | #N/A | #N/A | 2
16817 | 9 | Rads- to EDI | S | #N/A | #N/A | 3
16820 | 8.5 | [NAME] | S | #N/A | #N/A | 4
16821 | 9.5 | Rads - Payment | S | #N/A | #N/A | 5
16883 | 1 | [NAME] | S | Rpt-BH | BH |  |  |  |  | Copy these "new" items as a group, use EDIT > PASTE SPECIAL > VALUES
16915 | 17.25 | Train - Technical Training | S | Training | GENERAL |  |  |  |  | to paste them at the bottom of MasterSPRList and give them the missing
17005 | 2 | Rad Summary Report | S | #N/A | #N/A | 6 |  |  |  | information. As soon as you do that, they will remove themselves from
17006 | 1.5 | [NAME] | S | #N/A | #N/A | 7 |  |  |  | this list.
Spreadsheet: 841668d1693842473-date-and-time-matching-between-2-sheets-match-date-and-time
Sheet: Sheet1

Date | Time | Value | Desired result
2023-08-02 00:00:00 | 20:15:00.000000 | 35412
2023-08-02 00:00:00 | 20:16:00.000000 | 35412
2023-08-02 00:00:00 | 20:17:00.000000 | 35410
2023-08-02 00:00:00 | 20:18:00.000000 | 35411
2023-08-02 00:00:00 | 20:19:00.000000 | 35411
2023-08-02 00:00:00 | 20:20:00.000000 | 35415
2023-08-02 00:00:00 | 20:21:00.000000 | 35417
2023-08-02 00:00:00 | 20:22:00.000000 | 35417
2023-08-02 00:00:00 | 20:23:00.000000 | 35417
2023-08-02 00:00:00 | 20:24:00.000000 | 35415
2023-08-02 00:00:00 | 20:25:00.000000 | 35417
2023-08-02 00:00:00 | 20:26:00.000000 | 35417
2023-08-02 00:00:00 | 20:27:00.000000 | 35417
2023-08-02 00:00:00 | 20:28:00.000000 | 35419
2023-08-02 00:00:00 | 20:29:00.000000 | 35420
2023-08-03 00:00:00 | 20:31:00.000000 | 35420
Spreadsheet: 579824d1530213808-excel-sheet-reference-book1-hwall85-
Sheet: Master

CH1 | CH2 | CH3 | Rec #
RH1 | D1 | DD1
RH2 | D2 | DD2
RH3 | D3 | DD3
RH4 | D4 | DD4
RH5 | D5 | DD5
RH6 |  | DD6
Spreadsheet: 121533d1316120812-pivot-table-excel-2007-normalizingdata2
Sheet: Updated List

Row | Day of Week | In/Out | Time |  | <-- Normalized List created after clicking on 42 on "From PT Wiz" tab
[NAME] | Sunday | In | 08:45:00
[NAME] | Sunday | Out | 17:00:00
[NAME] | Monday | In | 08:45:00
[NAME] | Monday | Out | 17:00:00
[NAME] | Tuesday | In | 08:45:00
[NAME] | Tuesday | Out | 17:00:00
[NAME] | Wednesday | In | 08:45:00
[NAME] | Wednesday | Out | 17:00:00
[NAME] | Thursday | In | 08:45:00
[NAME] | Thursday | Out | 17:00:00
[NAME] | Friday | In | 08:45:00
[NAME] | Friday | Out | 17:00:00
[NAME] | Saturday | In | 08:45:00
[NAME] | Saturday | Out | 17:00:00
[NAME] | Sunday | In | 08:46:00
[NAME] | Sunday | Out | 17:15:00
[NAME] | Monday | In | 08:46:00
[NAME] | Monday | Out | 17:15:00
[NAME] | Tuesday | In | 08:46:00
[NAME] | Tuesday | Out | 17:15:00
[NAME] | Wednesday | In | 08:46:00
[NAME] | Wednesday | Out | 17:15:00
[NAME] | Thursday | In | 08:46:00
[NAME] | Thursday | Out | 17:15:00
[NAME] | Friday | In | 08:46:00
[NAME] | Friday | Out | 17:15:00
[NAME] | Saturday | In | 08:46:00
[NAME] | Saturday | Out | 17:15:00
Biff | Sunday | In | 08:40:00
Biff | Sunday | Out | 18:00:00
Biff | Monday | In | 08:40:00
Biff | Monday | Out | 18:00:00
Biff | Tuesday | In | 08:40:00
Biff | Tuesday | Out | 18:00:00
Biff | Wednesday | In | 08:40:00
Biff | Wednesday | Out | 18:00:00
Biff | Thursday | In | 08:40:00
Biff | Thursday | Out | 18:00:00
Biff | Friday | In | 08:40:00
Biff | Friday | Out | 18:00:00
Biff | Saturday | In | 08:40:00
Biff | Saturday | Out | 18:00:00
Spreadsheet: 685705d1594148800-how-to-move-specific-content-between-columns-sampleset
Sheet: Sheet1

Last Name | First Name | MI | provider_address | city | state | zipcode | Mailing Address | Mailing City | Mailing State | [NAME] | Primary Language | pphone | pphoneext | pphonetype | last_updated | email | Monday Morning | Monday Afternoon | Monday Evening | Monday Overnight | Tuesday Morning | Tuesday Afternoon | Tuesday Evening | Tuesday Overnight | Wednesday Morning | Wednesday Afternoon | Wednesday Evening | Wednesday Overnight | Thursday Morning | Thursday Afternoon | Thursday Evening | Thursday Overnight | Friday Morning | Friday Afternoon | Friday Evening | Friday Overnight | Saturday Morning | Saturday Afternoon | Saturday Evening | Saturday Overnight | Sunday Morning | Sunday Afternoon | Sunday Evening | Sunday Overnight | Special Availability | Weekly Availability | Availability | BUAP Approved
[NAME] | armore | S |  |  |  |  | 555 5th st | SHERMAN OAKS | CA | 91423 |  |  |  | Home | 11/22/2018
sara | scandapy | E |  |  |  |  | 444 4th st. | SUN VALLEY | CA | 91352 | Spanish |  |  | Home | 05/01/2019
[NAME] | fordor | L |  |  |  |  | 333 3rd st. | INGLEWOOD | CA | 90302 | English |  |  | Home | 12/02/2019
[NAME] | [NAME] | H |  |  |  |  | 123 e st. | VAN NUYS | CA | 91405 | English |  |  | Home | 02/28/2019 | [EMAIL]
forrest | farther |  |  |  |  |  | 321 f st. | [NAME] | CA | 91767 | Spanish |  |  | Home | 11/23/2018
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -279274
3531 | -647769 | -287299
60667 | -70935 | -30939
60749 | 1064860 | 241403
61206
61334 | -169236
62960
INDEX
2001-08-31 00:00:00 |  |  | 400688.32
2001-09-22 00:00:00
CBS Volume
 |  |  | -29477
Spreadsheet: 839021d1691594727-find-location-of-specific-word-formula-solutions-
Sheet: Sheet1

or |  |  | Answer | [NAME] | Logan | Hans
Computer or Tablet |  |  | 2
Excel Word or PowerPoint |  |  | 3
Running Dancing Gym or Walking |  |  | 4
Spreadsheet: 782360d1654002171-convert-exchange-rate-formula-on-old-spreadsheet-to-work-on-new-new-front-cover-ans
Sheet: Data

CUSTOMER REF | B/L | DATE | Wk No. | Fat & FFA Sample to [NAME]: | FFA sample to Nagel: | FFA Sample to Vollers: | Extra Samples (1 x 2): | Joint Analysis: | Dry Bags List: | Others (specify): | Type of Charge | QTY | Currency | Exchange Rate | Rate | Total | GBP Conversion | Invoice Currency | Exchange Rate2 | Converted Rate | Converted Total | GBP Total | Total Invoiced | Invoice Currency2 | Converted Rate3 | Converted Total4 | GBP Total5
AGF659 | COSU6321884050 | 2022-05-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2 | EUR |  | 2.5 |  |  | USD
 |  | 2022-01-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2 | USD |  | 2.5 |  |  | EUR
 |  | 2022-01-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2 | EUR
 |  | 2022-01-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2 | USD
 |  |  |  |  |  | `
Spreadsheet: 547441d1510567560-dont-count-rows-with-data-in-d-test-holiday
Sheet: Sheet1

 |  |  |  |  | Dates | Dates | Dates | Dates | Dates | Dates | Dates | Dates
 |  | 2017-01-01 00:00:00 |  |  | Holiday | Holiday | Holiday
 |  | 2017-01-15 00:00:00 | 2017-07-25 00:00:00 |  |  |  | Holiday | Holiday | Holiday
 |  | 2017-08-15 00:00:00 |  |  |  |  |  |  | Holiday | Holiday | Holiday
 | Count Holiday
 | Exclude Holiday if date in column D | 6 | desired result
 | Note
 | empty cells may contain other data on actual sheet
Spreadsheet: 871985d1718359091-create-a-dependant-drop-down-list-buyin-list-template-aligw
Sheet: Sheet1

Catergory | Products | QTY | CUSTOMER |  |  | Cans | 500ml | Monster | Waters | PMP Cans | PMP 500ml | Crisps/Choc | PMP Energy
Waters | Coca Cola | 20 |  |  |  | Coca Cola | Coca Cola | Original Green | _VOLVIC 500ML | PMP Cans1 |  | SQUARES SALT & VINEGAR | RED BULL 250ML PMP
500ml | Diet Coke | 10 |  |  |  | Fanta Orange | Diet Coke | [NAME] | VOLVIC 1LTR | PMP Cans2 |  | SQUARES CHEESE & ONION PMP | RED BULL 355ML PMP
Monster | Original Green | 10 |  |  |  |  |  |  | VOLVIC 1.5LTR |  |  |  | RED BULL 473ML PMP
Waters | Americano | 20 |  |  |  |  |  |  | EVIAN 500ML |  |  |  | RED BULL SUGAR FREE 250ML PMP
PMP Energy | PMP Cans1 | 22 |  |  |  |  |  |  | EVIAN 750ML
 |  |  |  |  |  |  |  |  | EVIAN 1.5LTR
Spreadsheet: barry_tycholiz__889__June 1 P&L
Sheet: Sheet1

Deals done Since April 1, 2001
Counterparty | Date | Location | Term | Days | Volume/d | Phys/Fin | Trader | Trader Price | Counter Party Price | [NAME] | Total Orig
E-Prime | 2001-05-08 00:00:00 | CIG | Nov 01-Mar 02 | 151 | 700 | Fin | Ermis | 4.415 | 4.42
E-Prime | 2001-05-08 00:00:00 | CIG | 2001-10-01 00:00:00 | 31 | 300 | Fin | Ermis | 3.75 | 3.76
E-Prime | 2001-05-08 00:00:00 | CIG | 2001-04-02 00:00:00 | 30 | 300 | Fin | Ermis | 3.73 | 3.74
E-Prime | 2001-05-15 00:00:00 | NYMEX | Jul 02 - Jun 03 | 720 | 333 | Fin | Quigly | 5.535 | 5.535
Mega | 2001-05-16 00:00:00 | Sumas | Sep 01-Oct 01 | 61 | 6690 | Fin | Mc Kay | Monthly |  | 0.01234
OSM | 2001-05-17 00:00:00 | Sumas | Jun 01-Oct 02 | 491 | 4000 | Phys | Mc Kay | 5.917 | 5.94
E-Prime | 2001-05-08 00:00:00 | CIG | Nov 01 - Feb 02 | 120 | 1000 | Fin | Ermis | 3.285 | 3.34
Mega | 2001-05-21 00:00:00 | Sumas | Sep 01-Nov 01 | 91 | 6690 | Fin | Mc Kay | Monthly |  | 0.045
E-Prime | 2001-05-22 00:00:00 | CIG | Jun 01 - Sep 02 | 487 | 3200 | Fin | Ermis |  |  | 0.015
E-Prime | 2001-05-24 00:00:00 | CIG | Nov 01-Oct 02 | 365 | 5000 | Phys | Reitmeyer | 0.2 | 0.21
Kaiser | 2001-05-24 00:00:00 | NWR | 2001-06-01 00:00:00 | 30 | 2696 | Phys | South | 0 | 0.02
Kaiser | 2001-05-24 00:00:00 | AECO | 2001-06-01 00:00:00 | 15 | 2100 | Phys | McKay | 0 | 0.02
Kaiser | 2001-05-24 00:00:00 | AECO | 2001-06-01 00:00:00 | 15 | 1400 | Phys | McKay | 0 | 0.02
West Linn Paper | 2001-05-24 00:00:00 | Sumas | [NAME] 29 | 4 | 1000 | Phys | Chad | 0.01 | 0.01 | 0
E-Prime | 2001-05-25 00:00:00 | CIG | Nov 01-Feb 02 | 120 | 1800 | Fin | Ermis | 4.155 | 4.17
E-Prime | 2001-05-25 00:00:00 | CIG | 2002-03-01 00:00:00 | 31 | 1400 | Fin | Ermis | 3.995 | 4.01
West Linn Paper | 2001-05-29 00:00:00 | Sumas | [NAME] 31 | 2 | 2030 | Phys | Chad | 0.01 | 0.01 | 0
E-Prime | 2001-05-29 00:00:00 | CIG | Nov 01- Mar 02 | 151 | 850 | Fin | Ermis | 3.97 | 3.99
Spreadsheet: 230792d1366879387-drop-down-list-using-multiple-worksheets-0sor
Sheet: Data Output

Month | Inbound Calls | Viewings Booked | Clearances Booked | Clearances Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May 2013 | May 2013
May 2013 | 6 | 6 | 6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June 2013 | June 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July 2013 | July 2013
Total Call Centre Lead Generations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August 2013 | August 2013
Anne | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September 2013 | September 2013
Leanne | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October 2013 | October 2013
Christine | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November 2013 | November 2013
Helena | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December 2013 | December 2013
[NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R6

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
Plan Outline | Post-pilot Implementation planning meeting | Megan Parkhurst |  | 2022-11-29 00:00:00 | 2022-11-29 00:00:00
Planning & Scope | Check with Health Dept on Survey | [NAME] | 2022-11-29 00:00:00 | 2023-01-15 00:00:00 |  |  |  |  |  | This can be pushed if needed-adding so we don't lose it. We will use the OSDH form or create one and add the link to https://oklahoma.gov/okdhs/services/health/aids-coordination-and-information-services.html
Planning & Scope | Booking App Set-up  (with Digital Pathways) | Megan Parkhurst | 2022-11-29 00:00:00 | 2022-12-12 00:00:00 | 2022-12-07 00:00:00 |  |  |  |  | Meeting set by MP for Dec 7 at 11:30 AM
Planning & Scope | Set-up David's Access | [NAME] | 2022-11-29 00:00:00 | 2023-01-03 00:00:00 |  |  |  |  |  | Moved due date from 12/13 to as mtg moved for to 1/4 d/t schedule conflicts
Planning & Scope | Touchbase on the above items | Megan Parkhurst | 2022-11-29 00:00:00 | 2023-01-04 00:00:00 |  |  |  |  |  | Meeting set by MP for Dec 14 at 3:30 PM - moved to 1/4/23
Implementation | Implementation (hopefully with automation) | Project Team |  | 2022-12-25 00:00:00 |  |  |  |  |  | This due date was going to 12/31 but it's [NAME]'s Christmas present :)
Review & Refine | Check-back and fine-tune | Project Team |  | 2022-12-31 00:00:00
Review & Refine | Phase II - Soft line for a Teams conferencing bridge (calling in audio only - a free license) | [NAME] | 2022-11-29 00:00:00 | 2023-01-16 00:00:00 |  |  |  |  |  | The team is still exploring this.  An option for audio call on Teams may be beneficial to ACIS' project.
Review & Refine | [NAME] as needed | Project Team |  | 2023-01-23 00:00:00
[NAME] | Finalize reoccurance and update process plan | [NAME] |  | 2023-01-31 00:00:00
Spreadsheet: 597757d1542041987-using-or-and-applying-this-to-create-scoring-ranges-scoring-range-function
Sheet: Bodyweight

 | Date | Exercise | [NAME] | Score |  |  |  |  |  |  | Valid Data
 | 2018-10-18 00:00:00 | Press-Ups | 30 | 3 |  |  |  |  |  |  | Press-Ups
 | 2018-10-19 00:00:00 | Press-Ups | 37 | 3 |  |  |  |  |  |  | Sit-Ups
 | 2018-10-20 00:00:00 | Sit-Ups | 42 | 3 |  |  |  |  |  |  | Pull-Ups
 | 2018-10-21 00:00:00 | Pull-Ups | 7 | 3
 | 2018-10-22 00:00:00 | Sit-Ups | 50 | 3
 | 2018-10-23 00:00:00 | Press-Ups | 45 | 4
 | 2018-10-24 00:00:00 | Sit-Ups | 45 | 3
 | 2018-10-25 00:00:00 | Pull-Ups | 6 | 3
 | 2018-10-26 00:00:00 | Pull-Ups | 10 | 4
 | 2018-10-27 00:00:00 | Pull-Ups | 11 | 4
 | 2018-10-28 00:00:00 | Sit-Ups | 65 | 5
 | 2018-10-29 00:00:00 | Press-Ups | 52 | 5
 | 2018-10-30 00:00:00 | Sit-Ups | 50 | 3
 | 2018-10-31 00:00:00 | Sit-Ups | 65 | 5
Spreadsheet: 784437d1655734947-googlesheets-pulling-data-from-a-set-of-dynamic-data-sample
Sheet: Data Validation

Enquiries | Project Status | Conversion Rate | Status | Duration (months) | Status of campaign | Payment Type | Industry Type | Industry | Status of Renewal | Industry Type | Website Type | Yes / No | Rejection
eCommerce | Keywords Setting | No Data | Ad Paused | 12 | Running | Monthly | Manufacturing | Office Furniture & Equipment | New | B2C | E-comm | Yes | Change of PIC
SEO | Pending Info | 0.01 | [NAME] | 6 | Ended | Bi-Monthly | Distibutor & Wholesales | Home Furniture | Second Year | B2B | Corporate | No | Budget Concern
Pending Client | Ads Setting | 0.02 | Not Launched | 4 | Pause | Quarterly | Retail | Home & Decoration | Third Year | B2B & B2C | [NAME] | Upcoming | Business Close Down
Pending | Ad Paused | 0.03 | Ad Disapproved | 3 | Pending Setup | Semi Anual | Service Provider | Renovation & Construction | More than 3rd year |  | [NAME] |  | Not satisfy with result
New Project | Not Launched | 0.04 |  | 1 | Dropped | Paid Upfront | Construction & Developer | Apparel |  |  |  |  | Not Satisfy with Communication & Customer Service
Ads Relaunched | Not Approached | 0.05 |  |  |  | By [NAME] |  | Jewellery |  |  |  |  | Switch of vendor
Web Design Only | Pending | 0.06 |  |  |  |  |  | Baby Products |  |  |  |  | Not trackable
Backlink Only | Facebook Mgmt | 0.07 |  |  |  |  |  | Food & Beverage
Monthly Project | Completed | 0.08 |  |  |  |  |  | Supplements
Not Provided | Awaiting Live Launch | 0.09 |  |  |  |  |  | HealthCare
No Data | To Launch | 0.1 |  |  |  |  |  | PPE Products
 | Ended | 0.11 |  |  |  |  |  | Construction Equipment
 | Website Maintenance | 0.12 |  |  |  |  |  | Machine & Equipment
 |  | 0.13 |  |  |  |  |  | Agriculture
 |  | 0.14 |  |  |  |  |  | Construction & Developer
 |  | 0.15 |  |  |  |  |  | IT & Technology
 |  | 0.16 |  |  |  |  |  | Oil & Gas
 |  | 0.17 |  |  |  |  |  | Engineering
 |  | 0.18 |  |  |  |  |  | Personalise Services
 |  | 0.19 |  |  |  |  |  | Automotive
 |  | 0.2 |  |  |  |  |  | Chemical
 |  | 0.21 |  |  |  |  |  | Logistics
 |  | 0.22 |  |  |  |  |  | Packaging
 |  | 0.23 |  |  |  |  |  | Electrical
 |  | 0.24
 |  | 0.25
 |  | 0.26
 |  | 0.27
 |  | 0.28
 |  | 0.29
 |  | 0.3
 |  | 0.31
 |  | 0.32
 |  | 0.33
 |  | 0.34
 |  | 0.35
 |  | 0.36
 |  | 0.37
 |  | 0.38
 |  | 0.39
 |  | 0.4
 |  | 0.41
 |  | 0.42
 |  | 0.43
 |  | 0.44
 |  | 0.45
 |  | 0.46
 |  | 0.47
 |  | 0.48
 |  | 0.49
 |  | 0.5
Spreadsheet: 220362d1363129422-auto-populate-two-columns-based-on-data-entered-into-another-column-billing-template
Sheet: Sheet 1

Vessel | From Date / Time | To Date / Time |  |  |  | Billing hours | LOA | GRT
CHRISSY | 2013-02-28 10:12:00 | 2013-02-28 10:45:00 | 00:33:00 | 0.5499999998719431 | 0.5499999998719431 | 1
 | 2013-02-28 10:12:00 | 2013-02-28 10:45:00 | 00:33:00 | 0.5499999998719431 | 0.5499999998719431 | 1
 | 2013-02-28 10:12:00 | 2013-02-28 10:45:00 | 00:33:00 | 0.5499999998719431 | 0.5499999998719431 | 1
[NAME] | 2013-02-28 10:12:00 | 2013-02-28 10:45:00 | 00:33:00 | 0.5499999998719431 | 0.5499999998719431 | 1
 | 2013-02-28 10:12:00 | 2013-02-28 10:45:00 | 00:33:00 | 0.5499999998719431 | 0.5499999998719431 | 1
 | 2013-02-28 10:12:00 | 2013-02-28 10:45:00 | 00:33:00 | 0.5499999998719431 | 0.5499999998719431 | 1
YOUNG | 2013-02-28 10:12:00 | 2013-02-28 10:45:00 | 00:33:00 | 0.5499999998719431 | 0.5499999998719431 | 1