Vlookup Tables Projects
Looking for freelance Vlookup Tables jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Vlookup-tables" Projects
opportunity
Creative Video Editor for Short Form Content (Reels, TikToks...)
I am seeking a highly skilled and talented freelance video editor to join me. As a video editor, you will be responsible for creating captivating and engaging short form videos, specifically targeting platforms like Reels, TikTok, and other social media platforms. I am looking for someone who can bring their creativity and technical expertise to the table, with a specific focus on delivering videos in the popular "Alex Hormozi style". Responsibilities: Edit and enhance short form videos, including Reels, TikToks, and other similar content. Add eye-catching captions, b-roll footage, emojis, animations, sound effects, and zoom in/out effects to create visually appealing videos. Understand and adapt to the "Alex Hormozi style" to deliver videos that align with my brand image. Collaborate with me to ensure that the videos effectively communicate the intended message and engage the target audience. Keep up-to-date with the latest trends and techniques in video editing to bring fresh ideas and innovative approaches to our content. Requirements: Proven experience in video editing, with a strong portfolio showcasing your skills in editing short form videos. Proficiency in using video editing software such as Adobe Premiere Pro, Final Cut Pro, or similar tools. Strong understanding of storytelling, pacing, and visual aesthetics to create engaging videos. Knowledge of social media platforms and their specific video requirements, particularly Reels and TikTok. -Ability to work independently, meet deadlines, and effectively manage multiple projects simultaneously. -Attention to detail, with the ability to maintain consistency in video quality and style. -Excellent communication skills and the ability to collaborate effectively with a remote client. Additional Skills (preferred but not required): Experience in creating video content for brands or businesses. Basic knowledge of graphic design and motion graphics. Familiarity with copyright and fair use guidelines related to video editing and music selection. Experience in optimizing videos for different platforms and understanding their algorithms. To apply for this position, please provide: A link to your portfolio or samples of your previous work, showcasing your expertise in editing short form videos. A brief description of your experience with Reels, TikToks, and other similar platforms. Any additional skills or qualifications that you believe would be relevant to this role. The amount you charge for each edited reels
urgent
Data extraction and analysis from twitter using R software
I am looking for a data analyst who has an excellent master of R studio and programming. and At the first stage, a list of keywords and searches terms related to election, violence or electoral process in the context of Congo DRC ( presidential elections) will be set and provided to be used to retrieve tweets from twitters platform and this is using R twitter Package. Based on the data set retrieved from Twitter, it must be analyzed using the machine learning method hard (clustering ) and using the Latent Dirichlet Allocation (LDR) and Non-negative Matrix Factorization (NMF) for topic modeling to analyze the patterns of the data. the outcomes needed for the analyses are: codes and algorithms detailed by steps. the table of tweets in CSV format. the results and word cloud graphs per clusters.
Maths Blog Post Required with a bit of research 3 POST REQUIRED
I require a blog post to be written about times tables. I want a post that details in a fun way how to learn the times tables. I have a document you can use as a template, but mine must be original content. Length 700 words, must have bullet points. FOR PARENTS. I also require a blog post on how to be confident helping your child with learning the times tables. Length 400 words, must have bullet points I also require a post on the best way to improve your / CHILD memory for learning maths. Length 400 words, must have bullet points All work must be proof read and ready to send out. Thanks
urgent
EPQ Proofreading
I am a sixth-form student and I am competing my studies in the UK. I am doing an EPQ in sociology. Since English is not my first language, I was advised to find someone who could read through and correct my spelling and grammar mistakes. It is an 14 pages long document, which includes several tables. If you think you can help me, please contact me! Thank you very much, Elizabeth Brentik
Web application using data collected from facebook
Tie strength Project: This is about predicting the bond level between two users on social media (Need to use the Facebook API). What I am actually trying to achieve: •A Facebook user must be able to login in with their Facebook profile. Any Facebook profile can be read in real time and information collected using the Facebook API •It must collect the following 7 variables: number of photos tagged, mutual groups, common friends, words exchanged in wall postings, comments, number of like on participant posts and number of love on participants posts. •Store them in a database and use them as variables in an algorithm (I will provide the formula). Relevant information is summarised and stored in a database and calculations are done. If one adds a new post, a rerun of the application must now add that bit of info. •Outputs the results to the user in a table, graph way, gives the user options to choose how to display the results etc. (any sort of interaction) the user can also be able to share the link on Facebook so that another user clicks on it. When the user logins in again, be able to pick up latest information of posts and update the database and calculates again. Technical Requirements: • Need to use PHP • Need to use a Database • Then can use anything else as long as the above two are used
pre-fundedurgent
I need python code fixed
I am currently using python and tweepy to access a MySQL db and pull down screen_names in the store, I then request the tweets associated with the specific screen name and save them to MySQL for processing. I have a central table where I store if an account has been pulled from Twitter, when I get the repose I update the central table to indicate that the screen_name has been processed. The problem is that the central table is not being updated to indicate that the screen_name has been processed. Not being effective with Python I am not sure the syntax to use (I have tried strings and %s but that does not work). I need someone to urgently help and assist in fixing the below code so that I am able to execute the program. The line of code below I am having problems with is: cursor.execute("UPDATE `xxxxxxxx.xxxxxxxxx` SET submitted = 'yes' WHERE screen_name=%s;", (screen_name,)) I need to finish this within the next two hours. ============================================================================================= #!/usr/bin/env python import tweepy import MySQLdb import sys # Keys consumer_key = 'xxxxxxxxxxxxxxx' consumer_secret = 'xxxxxxxxxx' access_token = 'xxxxxxxxxx' access_token_secret = 'xxxxxxxxxxx' host = "xxxxxxxxxx" user = "xxxxxxxx" passwd = "xxxxxxxxxxxx" database = "xxxxxxxxx" # Twitter initialization auth = tweepy.OAuthHandler(consumer_key, consumer_secret) auth.set_access_token(access_token, access_token_secret) api = tweepy.API(auth) # MySQL initialization connection = MySQLdb.connect(host=host, user=user, passwd=passwd, db=database, charset="latin1") cursor = connection.cursor() # The table schema: CREATE TABLE tweets # tweet_id BIGINT NOT NULL, # tweet_text VARCHAR(160) NOT NULL, # screen_name VARCHAR(160) NOT NULL, cursor.execute("SELECT screen_name FROM xxxxxx.xxxxxxxx WHERE platform = 'tw' and submitted = 'no' LIMIT 1") screen_name = cursor.fetchone()[0] print(screen_name) cursor.execute("UPDATE `xxxxxxxx.xxxxxxxxx` SET submitted = 'yes' WHERE screen_name=%s;", (screen_name,)) print(screen_name) print("submitting to twitter") try: statuses = api.user_timeline(screen_name=screen_name, count=200) for user in statuses: print(user.id, user.text.encode('UTF-8'), user.author.screen_name.encode('UTF-8'), user.author.id, user.created_at) # load to MySQL server cursor.execute("INSERT INTO tweets (tweet_id, tweet_text, screen_name, author_id, created_at, inserted_at) VALUES (%s, %s, %s, %s, %s, NOW());", (user.id, user.text.encode('UTF-8'), user.author.screen_name.encode('UTF-8'), user.author.id, user.created_at)) connection.commit() if not cursor.rowcount: print("no values found") except tweepy.error.TweepError: print("Tweepy error, could not fetch data!") except UnicodeEncodeError: print('Unicode error') else: print("Unexpected error: ", sys.exc_info()[0]) finally: cursor.close() connection.close()
Instagram videos
I need three videos produced for instagram. The posting company is an interior design company in london so the execution needs to be stylish and sophisticated. The two examples below are from another company and I am not happy they represent the sophistication we are looking for. The company in The three videos are:- 1) A stop motion video. I have all the photos and the order, these need to be put together. This should be approx 15 seconds in length. The subject is the creation of a dining table using flowers. Below is a link to the longer version of this. https://video214.com/play/8ZaVburZRH5go9P0oHmneA/s/dark 2) A 'how to' video with instructions. I have an example for how this should look using stills, I need this to be made into video with the clips I have. This should be approx 20 seconds in length. Below is the link with the instructions. https://video214.com/play/KhF1yVR3UI410NqjV4NIfQ/s/dark 3) A behind the scenes montage, I have a series of video clips from behind the scenes at he shoot and these need to be put together. All of these need a music overlays - the talking will need to be edited out. I need these down within 24 hours. Please send links of other videos you have done so I can be comfortable with the style. I will provide font guides etc with all files - suggested music would be appreciated, I do not like what is on the current clips - I can provide if needed.
I require a social media professional to increase my follower base on business pages
I'm in the process of setting up a life coaching company and have set up all the social media pages to gather momentum, ahead of the official launch in the coming months. I require a professional to daily post on Insta, FB initially leading into Twitter and U-Tube once more content has been produced. Please provide a response how you would handle this brief and what expertise and success stories you bring to the table sort of speak. Thanks
Quality Social Media for our Marketing Agency (Must be UK based)
Hello, We're a small marketing agency based here in London. We're looking for someone to bring some real personality and drive to our social media channels on a daily basis. That would be (i) Twitter (ii) Facebook and (iii) LinkedIn. You'll need to be happy creating bespoke imagery and being able to deliver engaging and genuinely interesting posts. Ideally, what we're looking for is someone that is very creative / arty, that understands marketing and is happy to bring ideas to the table about how they think it should be done. Please only respond if you are UK based. Thanks