Need to create an excel spreadsheet that will work in google spreadsheet.
Sheets Jan to Dec and columns
DATE DAY CONTENT BUYER PERSONA OWNER STATUS TIME BLOG POST FACEBOOK-1 FACEBOOK-2 TWITTER LINKEDIN GOOGLE PLUS PINTEREST E-NEWSLETTER WEBSITE UPDATE MEDIA RELEASE OTHER COMMENTS
Another sheets named Points Jan - Points Dec with columns mentioned in 1.
DATE, DAY, OWNER, POST TYPE, ORGANIC REACH, PAID REACH, TOTAL REACH, LIKES, COMMENTS, SHARES, VISIT TO WEBSITE, POINTS. TARGET ACHIEVED
POST TYPE: Image - 1 point, Video - 2 points, Link - 3 points.
ORGANIC REACH: Till 699 - 0.1 point, After 700 for every 100 - get 0.20 point.
LIKES: Upto 5 likes - 0.1 point, After 5 for every like 0.20 point.
COMMENTS: Upto 6 comments - 0.1 point, After 6 for every comment 0.20 point.
SHARES: Upto 3 shares - 1 point, each shares above 3 will get 0.20 point.
VISIT TO WEBSITE: Upto 5 visits - 1, after 5 for every visit - get 0.25 point.
POINTS: a total of all above.
TARGET ACHIEVED: % more/less of the target set in instructions sheet.
There may be a column in the instruction sheet where we can customize the points and it will dynamically update in the calculations.
We may be able to add columns in the instruction sheet with points that can be specified. It will automatically create the column in sheets named Points Jan - Points Dec.
We may be able to add columns in the main sheet Jan - Dec for more social media channels through the instructions sheet.
Every column we add in Jan or Points Jan may create that column in the rest sheets (Feb - Dec and Points Feb - Points Dec) respectively.
May be able to use it for coming years with date and day automatically updated.
Instead of Saturday and Sunday marked as grey for holidays can we customize weekends and holidays through the instruction sheet to dynamically update on all sheets, Jan - Dec and Points Jan - Points Dec.
Please chnge the design to look user friendly and beautiful. Please add logo use logo color to design.
Should be compatible with google drive spreadsheet as it will be uploaded into google drive to be shared with many. You can prepare in google spreadsheet itself and share it with me.
Any suggestions and new ideas are welcome.
27 freelancers are bidding on average $26 for this job
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
Hi, I will work as per your project description. I will start working right now. I want to show you sample. I am waiting for your response to show you sample and to discuss more about the project. Thanks
Hi my name is Tina. I strongly believe that I am the best freelancer to complete this project in no due time with the lowest possible rate you can offer. I can assure you of my quality of my [url removed, login to view]!
Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery Please inbox and we can discuss about project...