%3CLINGO-SUB%20id%3D%22lingo-sub-1273277%22%20slang%3D%22en-US%22%3EExcel%20for%20good%3A%20Working%20together%20to%20find%20increased%20efficiencies%20in%20the%20fight%20against%20the%20coronavirus%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1273277%22%20slang%3D%22en-US%22%3E%3CP%3EToday%20we%20share%20another%20story%20of%20our%20global%20community%20coming%20together.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EA%20collaboration%20between%20our%20MVPs%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4025317%3FfullName%3DJane%2520%2528JieYing%2529%2520Fang%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EJane%20(JieYing)%20Fang%3C%2FA%3E%26nbsp%3Band%20Zhaoxiong%20Shi%20working%20together%20to%20help%20communities%20across%20China%20find%20increased%20efficiencies%20in%20their%20on-going%20effort%20to%20fight%20the%20spread%20of%20the%20coronavirus.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20understand%20the%20spread%20of%20the%20virus%2C%20communities%20started%20logging%20travel%20patterns%2C%20using%20pen%20and%20paper.%20They%20needed%20a%20more%20efficient%20way.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EJane%20suggested%20using%20Forms%20and%20Excel%20to%20collect%20data%2C%20and%20with%20help%20from%20Zhaoxiong%2C%20they%20wrote%20Visual%20Basic%20for%20Applications%20code%20to%20process%20the%20data.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.cnblogs.com%2Fofficeplayer%2Fp%2F12614344.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERead%20more%20%26gt%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-center%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.cnblogs.com%2Fofficeplayer%2Fp%2F12614344.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ecnblogs.com%2Fofficeplayer%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShare%20your%20stories%20with%20us%20%E2%80%93%20add%20them%20in%20the%20comments%20below.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3CBR%20%2F%3EMicrosoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1273277%22%20slang%3D%22en-US%22%3E%3CP%3EMVPs%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4025317%3FfullName%3DJane%2520%2528JieYing%2529%2520Fang%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EJane%20(JieYing)%20Fang%3C%2FA%3E%26nbsp%3Band%20Zhaoxiong%20Shi%20working%20together%20to%20help%20communities%20across%20China%20find%20increased%20efficiencies%20in%20their%20on-going%20effort%20to%20fight%20the%20spread%20of%20the%20coronavirus%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1273277%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20good%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1394651%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Working%20together%20to%20find%20increased%20efficiencies%20in%20the%20fight%20against%20the%20coronav%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1394651%22%20slang%3D%22en-US%22%3E%3CP%3ETechnology%20plays%20great%20role%2C%2C%2C%20during%20corona%20pendemic%20every%20one%20has%20to%20come%20forward%20to%20extend%20their%20services.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Today we share another story of our global community coming together.


A collaboration between our MVPs Jane (JieYing) Fang and Zhaoxiong Shi working together to help communities across China find increased efficiencies in their on-going effort to fight the spread of the coronavirus.

 

To understand the spread of the virus, communities started logging travel patterns, using pen and paper. They needed a more efficient way.


Jane suggested using Forms and Excel to collect data, and with help from Zhaoxiong, they wrote Visual Basic for Applications code to process the data.  Read more >

 

cnblogs.com/officeplayer

 

Share your stories with us – add them in the comments below.

 

Cuong
Microsoft

1 Comment
Occasional Visitor

Technology plays great role,,, during corona pendemic every one has to come forward to extend their services.