How to calculate z score in excel jobber

I require an expert in Excel to assist with the reformatting of dates in one specific column of my spreadsheet. The current date format is MM/DD/YYYY, and I need to modify this to DD/MM/YYYY (01/05/2024). The project involves approximately 150 records. The ideal candidate for this task would possess strong Excel skills and attention to detail. No additional modifications are required. Some 150 records.

...around 70-80 tabs in excel that have projects and some other tabs that it’s not projects and I don’t need them . If I can give you list of tabs that I need to combine they all have same format but first 3-4 rows there is miscellaneous things that I don’t need to combine I’ll combine starting row 5 as example , is there a way to do that and if so what’s the best way ? Knowing that I might add new tabs in future or if a project is done , the person who maintain the excel will replace tab name and put new information . In combined sheet it will give a column at end or beginning of the information I’m combining . What’s the best way to do that ? The main tasks required are: - Merge the...

As the client, I'm seeking a talented developer to code the script for a web-based betting application. Special emphasis is required on the following functionalities: - Live Score and Odds Display: Real-time updates must be reflected on the platform to ensure users are getting accurate and the latest information. - Bet Placing and Tracking: Users should be able to place bets smoothly and also monitor their progress on the application. Please note, there's no need to integrate any specific APIs for live scores and odds as of now. Ideal freelancers for this project would have a proven track record in web development, preferably with previous experience in creating similar scripts for betting applications. Strong knowledge...

I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understandin...

...data analyst to delve into 10,000 Blackjack hands for comprehensive statistical analysis. Key Requirements: - Analyze win rate and dealer's advantage: I require in-depth insights into the win rate and dealer's advantage across these hands. - Excel expertise: The data is in Excel format, therefore proficiency in this tool is essential. Desired Experience: - Statistical analysis: Extensive knowledge and experience in statistical analysis is crucial to provide accurate insights. - Gambling or gaming industry: Background in the gambling or gaming industry would be advantageous to understand the context of the data. The goal is to extract valuable statistical insights to further understand the dy...

Will develop tool in Python (with GUI), to extract images from excel file, based on user input. Will feature log system as well. More details as discussed. Expect quality work as always. Thanks for choosing me once again!

...require a proficient Excel expert to develop a comprehensive yet easily understood dashboard. The dashboard should encompass data on Order Intake, Sales, Revenue Forecast, and Customer Information. - Key Details: - Data Source: The relevant information is already available via APO SAP and BW. You will only handle the design aspect. - Frequency: The dashboard needs to be configured in a way that it's updated every month. - Detail Level: Preference for an Overview Summary level that will make it easy for my boss to grasp the key trends and metrics at a glance and for each BU Manager. - Skills Required: - Strong knowledge and experience with Excel dashboard design is essential. - Familiarity with handling APO SAP and BW would ...

I'm seeking an advanced Excel professional to create a dynamic Excel tool that possesses several automatic functionalities. The Excel should be capable of: - Creating ledgers automatically based on the input of transactions and account types - Generating separate sheets for final accounts immediately after creation of ledgers. - Computing balances and totals automatically, providing real-time financial tracking and analysis. In terms of data input, the Excel should comfortably accommodate both manual input by the user and importing data from external sources. Finally, the dynamic tool should be capable of creating financial statements, including a Balance Sheet, Profit and Loss Statement, and Cash Flow Statement. Ratio analysis etc. Relates...

I'm in need of a professional in data visualization specific to Excel. Tasks include: - Translating complex data into easy to understand, static visualizations It's imperative that you have extensive knowledge of and experience with MS Excel. A background in statistical modeling will be beneficial, ensuring the ability to embrace and effectively illustrate our data.

I'm looking for a skilled Perl expert to help me remove duplicates in an Excel dataset. The removal process should be based on multiple columns, ensuring a thorough cleanup. Ideal Skills & Experience: - Strong proficiency in Perl programming - Proficiency in data analysis - Expertise in Excel and handling large datasets - Prior experience in removing duplicates from Excel based on multiple columns Communication: I prefer to have project updates through video calls, so please be comfortable with this form of communication. Your ability to walk me through the process will be highly appreciated.

Vennligst Registrer deg eller Logg inn for å se detaljer.

As discuss in chat '

1. Set a timer to trigger at the specified time X minutes after the start of the trading session. 2. When the timer triggers, capture the closing price of the most recent 1-minute candle. 3. Calculate the buy and sell entry prices as (+X) pips and (-X) pips from the captured initial price, respectively. 4. Place two entry orders (one buy and one sell) with the calculated entry prices. Configure these orders as "one cancels the other" so that only one of them will be executed. 5. When an entry order is executed, cancel the other entry order. 6. Place a stop-loss order for the opened position at (-X) pips from the opening price and a take-profit order at (+X) pips from the opening price. 7. If the optional "Second Leg" layer is activated, open another X lots...

...Rebuild and layout the site in accordance with the 'Golden Ratio' and as per the wireframe I've built in Figma. 2. Compress and add all the images including their SEO and keywords alt tags etc to each of the images. 3. Build the page to ensure it has a 90 to 100 Page speed score. 4. Test it on all devices. Other basic Interactive elements: - "call' from the device - "direction' to provide a popup dropdown for google maps or apple maps - 'links to social in footer' - 'link to open email address to contact in the footer" - 'anchor text on the page to direct from the Price section in the header to the Price area furt...

...are seeking a freelancer to undertake a project involving a database of 3,905 online games, primarily available on Steam. The task involves researching and providing valid EAN numbers for each downloadable game version listed in our Excel file. The current file includes titles and other relevant details, but lacks the EANs, which are crucial for our inventory management and logistics processes. Your task will be to fill this gap by identifying the correct EANs for these digital products. This project has the potential to expand in the future to include more games and other platforms. Therefore, we are looking for someone who can perform this work efficiently and accurately. If you have experience in retrieving specific data for ...

I am looking for an expert in Excel spreadsheet design to create a comprehensive and user-friendly accounts receivables sheet for my business. Key Features: - Calculation of total receivables - Aging analysis of receivables - Customer-wise summary of receivables - Report by department - Aging report - Total Sales - VAT report - Report by month Specific Formulas and Calculations: - Sum - Average - Count - Xlookup Data Organization: - By customer name - By invoice date - By payment due date - By month - By department Ideal Skills: - Proficiency in Excel and experience in creating complex spreadsheets - Strong understanding of accounting principles and reporting - Attention to detail to ensure accuracy in formulae and data or...

Urgently require a proficient Excel whizz who can efficiently perform financial calculations and analysis, especially pertaining to crypto sales and purchases. Aside from these, I require assistance in creating bespoke reports and summaries that will aid in decision-making among other business aspects. - **Financial Analysis**: Ability to perform rigorous financial analysis is crucial for this project. This includes but not restricted to calculations of various crypto sales and purchases. - **Report Generation**: Need customized, detail-oriented reports and summaries of all crypto activities in a coherent, easy-to-understand manner. Ideal candidates should have: - Extensive experience and knowledge in managing and analyzin...

I have a project where I need someone to extract data from PDF files and input it into an Excel spreadsheet. Key Requirements: - Extracting data from PDF files - Inputting the extracted data into an Excel spreadsheet Ideal Skills and Experience: - Proficiency in data entry - Experience with data extraction from PDF files - Advanced Excel skills - Attention to detail and accuracy

I am in crucial need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale for completing...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process autom...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process autom...

I need to scrape base salary information from Glassdoor for about 2000 companies. Key project requirements: - Scraping Glassdoor for base salary and range info only for every job function/title. - Compiling this data into an Excel spreadsheet Ideal skills include: - Proficient in web scraping techniques - Experience with data analysis Website: (it is free but need to register and complete the profile to see the information)

...experienced 3D modeler to design a medium length, straight hair wig. This project involves creating a 3D model that looks natural and realistic, ensuring the wig's texture and color offers a sense of genuineness. Objectives: Model Design: Design a 3D model of a wig that looks natural and realistic. The wig should have a natural hair texture, color, and style that can be adjusted if necessary. Format: The model should be exported in .obj format, which is compatible with our existing ARCore-based application, aslo the z-axis protrusion must be hollow, to enable a see through view when looked from +z-axis Optimization: The model must be optimized for real-time performance on mobile devices. This includes a low polygon count while maintaining a hi...

...guys, we have an excel contact list. In that list we have persons & companies with their contact details. We coded an script wich monitors an gmail inbox. When emails are sent from specific mails to this inbox the python script should read the body and depending on the request in mail syript should send requested Excel back. There are 8 different excel saved locally wich the script can take and send back. So depending on the contect of the mail script should choose the right excel file and send this with an text like "here your requested Contact List Periskop in attachment. kind regards" If its help. in attachmend an little python script we wrote to send back an mail

I have a simple site wide overlay image that floats on the right hand side of the website. Currently it hides behind certain site sections. I need it to float above all elements. Simple wordpress site built on breakdance.

As an entrepreneur, I'm swamped with a ton of tasks and need a hand to get things done efficiently. I'm on the lookout for a professional virtual assistant who is not only fluent in English but also skilled in email management, appointment scheduling, light accounting, and spreadsheet tasks. Here's what the job entails: - Managing my emails and scheduling appointments - Helping with light accounting and maintaining spreadsheets - Entrusted with some data entry duties The ideal candidate would have: - Proven experience in similar roles - Exceptional command over English - Strong skills in using spreadsheet and email tools You should expect to work around 10-20 hours a week. This job requires professional-level English fluency ...

I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experi...

...experience score of 1/10. I'm looking for a talented web developer to help me optimize my landing page to achieve a 10/10 score while also ensuring that it is mobile-friendly. Key Areas for Improvement: - Speed and Loading Times: My current landing page is not as fast as it should be. I need you to optimize it for speed and ensure that it loads quickly on all devices. - Content Relevance and Quality: The content on my landing page is relevant, but it needs to be enhanced in terms of quality and appeal to my target audience. - User Navigation and Call-to-Action Buttons: The overall user experience on my landing page needs improvement. The navigation should be seamless, and the call-to-action buttons must be strat...

i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.

Add macros in existing Excel file

I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you'd be interested in.

I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and attentive to detail to...

I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability ...

I need an expert game developer to create a web-based game similar to the one found on , but with a few unique twists. Key Features Required: - Customizable Characters: Users must be able to tailor their in-game avatars. - A Point System: A score hierarchy based on achievements, with high score leaderboards for players to compare. Ideal Skills: - Experience in frontend game development is essential - Familiarity with level-editor implementations - Proficient in Multiplayer functionality - A strong background in implementing scoring systems for games Can't wait to see your creative interpretations for this fun project!

I need to have a python script prepare for Zerodha's Kite API platform to broadcast same orders from one account to mutiple accounts. The final work would looks like this See the video and let me know if you can create this ? I have python codes for login, Orders and etc. Products Requirement. – Copy Trade (decoded) Overview : Copy trades from one account to another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and M...

I'm in need of a skilled programmer who can work with Amazon Lambda and (probably) Python, to parse a single webURL (example further in this introduction of the job), parse its HTML/DOM and calculate statistics. The final output should be valid JSON. Key Tasks: - Parse the given webURL ( example ) - Calculate various statistics from the parsed data. - Perform data manipulation as required. *** MUST HAVE SKILLS - Very good understanding of HTML and CSS, to determine which images are used. - Strong experience with Amazon Lambda, and Python. The lambda uses a single webURL AND a minimum browser width to parse. *** What has to be done: the lambda must detemine which images are loaded and it must calculate the differenc...

I have a challenging case study that requires a thorough analysis of sales data and survey data. I'm looking for an expert who is well-versed in Excel to help me with this task. Key tasks and requirements: - You'll need to perform trend analysis on the sales data. - You'll also be required to visualize the sales and survey data. This will include a detailed geographical analysis. - The data visualization should be able to provide clear insights and comparisons between different variables. Ideal Skills & Experience: - Proficiency in Excel, including advanced data analysis features. - Experience with trend analysis and data visualization. - Previous experience with geographical analysis is a plus.

I ha...tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability to accurat...

The developer must be able to create an app that can ... 1. open a video of a wrestling match. 2. app will be able to "mark" various spots within the wrestling match that will interest an evaluator. 3. the marks are created by clicking on a button where the evaluator must go to review. 4. The app will create a score using Google Sheets. We are seeking a skilled video editor to mark several training videos using a custom screen. The marked areas will not only serve copyright protection interests but also provide necessary instructions to aid in understanding video content. Key tasks include: An ideal candidate would have noteworthy experience editing training videos and a solid understanding of copyright protection. A flair fo...

'm seeking a professional in machine learning to help with an automated image classification project. Key requirements: - Experience in machine learning, specifically image classification - Strong understanding of Logistic Regression and Neural Networks - Strong understanding of key concepts within Machine Learning IMPORTANT: MUST BE ABLE TO POST REGULAR UPDATES AND PROJECT MUST BE FINISHED WITHIN 2-3 DAYS Your responsibilities if you take on this project would include: - Developing and training a machine learning model on images of objects - Training and testing of new model based on ResNet-18 - Testing and optimizing the model for accuracy - Outputting metrics such as accuracy, F1 score, precision recall curves etc - Visualise model performan...

I'm seeking an artist experienced in creating traditional art using Dragon Ball Z's iconic style. Your task will be to create impactful art pieces focusing on the main characters, such as Goku and Vegeta. - The artwork should be in the traditional medium, and capture the vibrancy and energy of Dragon Ball Z's unique style. - I am interested in pieces focusing on single characters rather than group scenes or action sequences. - An understanding and appreciation of the Dragon Ball Z universe, its characters, and its artistic style will be advantageous. - Prior experience or a portfolio of anime style artwork is preferable. Captivate me with your artistic imagination and we can bring the amazing world of Dragon Ball Z onto canvas.

I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with setting up conditional ...

I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating striking visuals, this project is for you.

Se trata de generar informes de ventas en Excel desde un archivo madre, también en Excel

I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previ...

Hi everybody, We need a full time data organizer who will be putting out bank statements into a proper excel format (which we will give). Please note that you will 70-90% of monthly work and you can keep taking other projects as well but we will give you full time pay of USD 500 and you have to remain available to us We have access to Able2Extract and can provide you a proper converted excel statement. However, in some cases, bank statements could be a scanned copy and hence you may need to manually enter data. This is a full time job and budget is reasonably fixed. Require an excel expert pro as there has to be a lot of data shuffling and data organizing into different folders. Need someone who can start immediately Thak yo...

I'm in need of an expert who can significantly improve the speed of my prestashop website, enhancing its Google PageSpeed Insights score to over 70 for mobile and desktop.

I am looking for someone to assist me with data entry and related tasks in Excel and Word. I need some typing, copy and paste type of data, that needs to be entered in systematic way. Skills and Experience: - working in Excel/Word - Attention to detail - Experience with data entry or typing - Ability to follow instructions and work independently Preferred Format or Template: While I don't have a specific format or template in mind, I have a rough idea of how I would like the data to be arranged. I am open to suggestions and willing to collaborate on finding the most useful format for the data. If you have experience in data entry and are comfortable working with Excel an...

More details: Is this project for business or personal use? This question was skipped by the user What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" s...