Customized Data Visualization
Objective
Our team members across different countries update each project's status into a single smartsheet (like google sheet) cell like the image shown below. This project aims to transform team collaboration messages from Smartsheet into a clear and concise timeline.
This is convenient for team collaboration, but as the number of project increases, it became very hard to read and to get the latest status. So my goal is to visualize the text based status column and make it easier to read and understand the current status.
Implementation
I setup a system-d Python program on Linux server that will access and extract the data from smartsheet through API on a daily basis, the program will automatically clean the data and separate the date from the status message using regex, and then store all the cleaned and processed date into a database.
I developed a web page that will convert the data of each project to a horizontal timeline, the web page will update everyday, with newly updated projects on top, and will also differentiate the completed projects. The result is as below. The source code is in my Github.
Project Schedule Web Integration
Total 18 projects
Updated
Company B - BAG46565
Last update: 5/04/2025 17:49
MZ PO sent to BCD
1/08
Jack():Products shipped. Thanks.
3/03
Updated
Company D - SIGNED434343
Last update: 5/04/2025 17:49
MZ : Sample approved
2/28
Jack():waiting for approval on Sample.Thanks.
3/03
MZ : ABC will have MP done 3/25
3/04
Updated
Company G - PO-1939264
Last update: 5/04/2025 17:49
MZ : PO sent to ABC
2/07
Linda: The drawing was approved on 2/22. The …
2/24
Linda: The Prototype sample shipped to custom…
3/03
Updated
Company H - 10044574A
Last update: 5/04/2025 17:49
MZ : PO sent to ABC, customer like ETA 4/4
3/14
Linda: MP completion date is 3/29. In the pro…
3/17
Updated
Company K - 34347663B
Last update: 5/04/2025 17:49
MZ : PO sent to ABC
1/13
Linda: completion date is 2/26. Will produce …
1/20
Linda: Finished. Provided photos. Customer ne…
2/24
Linda: Attached QC report. Waiting for custom…
3/03
Linda: Both air shipped & ocean shipped.
3/10
Loaded on
3/08
ETA to Harbor:
3/31
Company A - HP343432
Last update: 4/28/2025 1:08
MZ : PO sent to ABC, customer FedEX# provided.
2/11
MZ : Samples will be ready on 3/1/25
2/19
Cheryl : prototype will be delay to 3/4
3/01
Cheryl : Tracking number is 7777777779(FedEx)
3/06
Company C - PO8347364
Last update: 4/28/2025 1:08
MZ : Customer approved sample
2/28
MZ : MP ready 4/10
3/03
Company E - PO3436
Last update: 4/28/2025 1:08
MZ 25: PO sent to ABC
2/27
Jack():waiting for product.
3/03
MZ : Products ready 3/15
3/12
Company F - F0011600
Last update: 4/28/2025 1:08
MZ :PO sent to BCD
1/14
MZ: Shipment loaded
2/21
Company G - T192732
Last update: 4/28/2025 1:08
MZ : PO sent to CDE
1/08
Linda: Products tooling PO received.
2/24
Linda: Pending sample approval to proceed wit…
3/17
Company L - 53430
Last update: 4/28/2025 1:08
Company H - 645422330
Last update: 4/28/2025 1:08
Mark : PO sent to CDE confirm complete 2/18
1/16
Linda: Shipped and attached QC report.
2/24
Loaded on
2/21
ETA to Harbor is around
3/17
Company H - 10044560
Last update: 4/28/2025 1:08
MZ : PO sent to ABC
2/03
Linda: Completed. Plan to load this week.
2/24
Linda: Attached QC report. No container last …
3/03
Linda: Ocean shipped.
3/10
Loaded on
3/08
ETA to Harbor:
3/31
Company H - 10055670
Last update: 4/28/2025 1:08
MZ : PO sent to BCD, customer asking ETA earl…
3/17
Company I - PO-834634
Last update: 4/28/2025 1:08
MZ : PO sent to DEF
1/13
Linda: completion date is . Will produce afte…
2/16
Loaded on
2/21
ETA to Harbor is around
3/17
Company J - PO-3434F
Last update: 4/28/2025 1:08
MZ : PO sent to BCD
3/05
MZ: Sample will be ready on
3/22
Company K - 34934734PO
Last update: 4/28/2025 1:08
MZ : PO sent to CDE
1/30
Linda: MP completion date is . In the process…
2/24
Linda: Finished. Attached QC report.
3/03
Linda:
3/10
800-0000 - Air shipment via Fedex#777777 on .
3/03
Loaded on
3/08
ETA to Harbor:
3/31
Company G - NONE
Last update: 4/28/2025 0:09
Linda: Waiting for new PO.
3/17
Company K - NONE
Last update: 4/28/2025 0:09