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.
24 freelance font une offre moyenne de $27 pour ce travail
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Plus
I have the expertise in Excel & Google Sheets and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
Hi There, I'm a Mechanical Engineer familiar with Microsoft Word, Microsoft Excel, PowerPoint Google docs Spreadsheet, WordPress, Magneto I Provide certain services : 1. MS Office 2. Web Research 3. Soci Plus
Dear I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose. I will design your spreadsheet in Google spreadsheet so you can easily download it and use it in version of E Plus
Hello Greetings!! I have read your requirement and very much confident that I can do this work for you. I assure you 100% quality work and quick TAT. Please give me an opportunity to work with you and grow. I am ne Plus
Hello, I am Giorgi from Georgia. I would like to work with you. I have a big experience working in MS Office, PDF and Data Entry. I know how to use excel formulas that will be used for this task. I will send an example Plus
Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it. I read through the job details extremely careful and I'm absolutely confident that I can d Plus
I have good experience in photoshop, data entry, web research, Google documents and MS Office. My typing speed is more than 50 words per minute. I believe my skills would be ideal for your project. I can complete this Plus
Hello, I am Raqiya Over the last 7 years, I have worked for several clients. Joined Freelancer with over 7 years of experience I am Excel, Data Entry/Data Processing Expert who knows the value of time, very hard wor Plus
HELLO DEAR ! If you are reading my proposal then I'm assuming you are considering me for your next project so this is my one chance to impress you and tell you why you should pick me over anyone else. I specialize in Plus
i have recently completed the same project. i can provide you with a sample. need a chance with you to express myself further.
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 [login to view URL]!
With quick and 100% accurate work results provided. Good in Excel analysis and spreading analysis sheet with desired results.
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...
Hi sir, My name is Omar. I'm expert in Microsoft Office. I do a little writing. I'm a very hard working man. I can do work very fast. It's my pleasure to work here