Formula result showing 0 in excel jobs

...primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. If you're a Power BI expert with a sol...

I need assistance with a data typing project. The job entails: - Entering data from various sources into a spreadsheet - Ensuring accuracy in the data entry - Organizing the data in a single consolidated file While the project doesn't require specific styling or formatting currently, it might at a later point. Therefore, experience with Excel and basic data entry is crucial. Please reach out if you think you're qualified for the task.

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a proj...

I'm looking for a...Google, for my website. The ideal candidate should have: - Strong expertise in SEO, particularly Google optimization - Experience in identifying and resolving technical SEO issues - Ability to work with minimal analytics and previous SEO reports Key objectives for this project: - Identify technical SEO issues: My website has been live for a while but is not getting any search traffic. I need a thorough review to pinpoint any underlying technical issues that may be hindering its search visibility. - Recommendations for improvement: Based on the findings, I would like actionable recommendations on how to improve the technical SEO of my website. If you have a strong track record of delivering SEO audits that result in improved search vi...

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data im...

I need a skilled developer to create custom functionality for my WordPress site using JavaScript. This new feature will be integrated into a specific existing page on my website. I need a site, showing the villas and providing the same experience for visitors. This site has many villas and features, including filters, maps, and search functions. It has 120 villas. I need the search filters and map filter search the same as reference site. The site has a big map showing areas like North, West, etc. When you click on an area, it should display the villas in that region. If you can make a similar map feature, that would be great. Let me know if you can do this.

Project Description: We seek a highly skilled software developer to compile the ARM64 code from GitHub, based on Golang 'go'. Your role is crucial in ensuring the Velociraptor server operates flawlessly on the Odroid N2+ platform (4GB RAM) by creating an installer or Debian package (.deb) that functions flawlessly on Debian Ubuntu 20.04 (MATE Desktop). The ARM64 code is available online, and we wish to have it as a package so the user can run it and go through the setup of the velociraptor server seamlessly on the N2+, use the local webserver to create agents (sensors as MSI or exes) and analyse/collect remote endpoints using the open source tool on the box. This project involves adapting the Velociraptor software, an open-source security tool , to work seamlessly

...forward from the shipping options, after selecting one option, and placing the order I get a message: "Sorry, this order requires a shipping option." When the shipping option was already selected. Another issue is related to the language, it should be in Spanish, but wocoomerce is showing in English instead If the developer can fix this, there are a few small changes required to the implementation. You can check this on Key requirements: - Expertise in WordPress and WooCommerce: The ideal candidate should have a strong background in dealing with these platforms and resolving related issues. - Theme compatibility resolution: The theme I'm using isn't displaying correctly on every device and poses a challenge for me. Therefore, I ne...

...accommodate both indoor and outdoor arrangements for the little adventurers, aged between 0-8 years. We are looking at creating an engaging, fun, and safe environment for toddlers and pre-schoolers. Ideal Skills And Experience: - Proven experience in designing and implementing child-friendly facilities - Understanding of safety regulations and standards pertaining to kids' play areas and swimming pools - Expertise in utilising space effectively to cater to both indoor and outdoor activities Your Role: - Come up with creative ideas for the play area and swimming pool layout - Ensure safety standards are met at every step - Help design areas that are fun, engaging and suitable for the age group - Assist in selecting the right equipment fo...

I ll upload various images under specific keywords. I want members to receive 1 image after texting that keyword in their personal channel. Also i want that image to be deleted in storage so that it will not be forwarded to other member. I also want a channel for my accountant, where he ll be uploading bill in pdf. And i ll get all data in excel sheet.

We are looking for a talented designer to create a series of abstract illustrations for our upcoming print materials. ...talented designer to create a series of abstract illustrations for our upcoming print materials. The ideal candidate for this role will have experience in designing abstract illustrations and a strong portfolio from previous assignments. Key Project Requirements: - Create 2 abstract illustrations suitable for print materials - The designs should be as close to the two uploaded images as possible - Vector graphic - pdf - The image should be a square Please note that we are looking for a long term partner, making our future ai-designs to a printable versions. We are looking forward partering up with the person that can deiliver the best result based on our...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of...

I'm looking for a JavaScript developer to add the interactions to an offline web page. I have 1 image. I need in several places on it to put buttons that start the "data flow" - dashed lines (they are supposed to be pseudo animated). E.g. I press button 1 - blue data flows from source to destination, I press button 2 - red data flows from source to destination, etc. There are to be ~20 buttons and the same number of "flows" in several colors. The buttons will have to have their own names, e.g. Windows, Linux, Syslog. The whole thing is supposed to work offline, that is, as an end result I am supposed to get a zip with a directory where is, and that's all I need to run.

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

...not further specified issues. I couldn't get any help from their support teams. - Lastly, always fails (). I tried to assess if there is an issue with the code at , but they didn't response. The name servers are , , and (ns-2 not yet added in the .net zone). Server locations are AWS Oregon, Germany, and Germany, respectively, all on different AS. DNS services run on TCP and UDP ports of IPv4 and IPv6. The name servers are their own authoritative servers, so there are glue records in the .net zone, see attachment. I can send you the bind configuration files. Unfortunately, I cannot give you SSH access to the servers. If you need to

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I am looking for a PHP Prestashop developer expert. Ideal skills and experience for this job include: - Strong proficiency in PHP and Prestashop - Experience with PayPal module customization and integration - Knowledge of Prestashop Multishop feature - Familiarity with coding for extra security measures and user interface improvements TASK 1 Reset Prestashop database. Setup on new. (Google cloud server) 1. Clean the prestashop directory, CMS pages and empty links. 2. Make a backup of the current Prestashop database including clients, orders, products, pictures, CMS pages all other information needed for a full reset. 3. Upload backup. 4. Setup all modules setting as was before the reset. Movic theme, Onepagecheckout, Crypto payments, PrettyURL, and Google reviews, rich ...

THIS IS NOT A LOGO DESIGN PROJECT. It is a shop front design Photo of building attached (middle alarm will be going out) I need you to illustrate the new sign with the two logos one on each side showing how it will look on the building Black background Sketch and Logos attached Things to try CD Asthetics (Logo) x The Hair Boutique (Logo) CD Asthetics (Logo) X The Hair Boutique (Logo) CD Asthetics (Logo) With The Hair Boutique (Logo) CD Asthetics (Logo) & The Hair Boutique (Logo)

ONLY 1 COMPONENT IS NEEDED I'm in need of a skilled developer to help me design the layout of my office room using Nuxt & Vue. Key Requirements: - Implement a visual room skretch using Nuxt & Vue. This feature will help us in our daily work by quickly identifying which meeting rooms & places(tables) are occupied and which are available. Ideal Skills & Experience: - Strong experience in Nuxt & Vue is essential. - Experience with creating interactive and user-friendly features in web applications. This project requires creativity and an understanding of office space optimization. A successful implementation will result in a more efficient and productive workspace.

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data int...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due ...

...api response as integer in the Pojo Class: @JsonProperty("intensity") private Integer intensity; public Integer getColor() { return color; } public void setColor(Integer color) { = color; } and in parser class (INTENSITY, ((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), )); how i can solve this issue so in case checkVariant is true

I'm looking for someone who can transform my sketch into a modern and intelligent interior design for small bathroom with walk-in shower, washbasin, toilet, and space for a washing machine. The result should be a 2D plan and a 3D rendering.

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issu...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will in...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting...

I'm in need of an experienced Shopify designer to create a robust e-commerce portal for my business. The website's primary purpose will be to facilitate online sales for various types of gadgets. Key responsibilities include: - Design an intuitive, user-friendly Shopify store. - Input and organise 50-100 product listings. - Optimisation for conversions. The ideal candidate will have: - Solid experience in Shopify store design and setup. - A good understanding of e-commerce best practices. - Familiarity with gadgets and similar niche products. The end result should be a seamless shopping experience that encourages sales and user return.

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to ...

Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must ...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

We are in need of an experienced civil engineer to reinforce a 5-10 feet high block wall currently showing moderate wear and tear. The purpose of the engineering is to strengthen the wall, with potential for future slab works on top. Must-haves: - Proven experience in structural engineering, specifically related to block wall reinforcement. - Ability to assess wall condition and provide optimal reinforcement solutions. - Ability to manage project requirements according to safety regulations and standards. -Capability to work within potential further development plans. The ideal candidate will need to provide professional assessment and reinforcement design to ensure the wall's stability and potential for further enhancements.

I have 29 SCADAVIS panels on Grafana that are not displaying properly, they're not showing data as they should. Key Requirements: - Fix the problem with the panels not displaying data correctly. Ideal Skills and Experience: - Proficient in Grafana and SCADAVIS. - Experience in troubleshooting and fixing SCADAVIS panels on Grafana. - Strong data visualization capabilities. Please note that I'll provide the necessary data source for these panels.

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...

...poster for "Stepbrothers." I'm looking to replace the faces of Brennan Huff and Dale Doback in the poster with my friends' faces. The date should be June 8th 2024 and change Will Ferris name to Brent Svendsen and Jim O’riley to Russ Schulhauser. Must be able to have this sized up enough to print as a poster. For this project, I will provide high-quality photos of my friends that will need to be edited to match the tone and style of the poster to ensure the final product looks as realistic as possible. Ideal Skills: - Proficiency in Adobe Photoshop or similar photo editing software - Previous experience in editing photos into movie posters or similar projects - Attention to detail to ensure the end result looks authentic - Quick t...

...strategies and indicators You have to use candlestick then overlay Renko And then use the indicator. Renko chat don't work, you know that Becareful don’t use Renko Renk is how I trade, but we are trying to autmate this So you are going to have to use Candlestick with Renko overlays and the indicator on the renko, overlays and trade off the Candlesticks with the signals. The renko is to show you the end result, how it is going to look So you have to compare your Candlesticks signals with how the renko signals with what I showed you work They have to match...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

I need an experienced NextJs (ShadCn) + Prisma (Postgres) developer to build an E-commerce application within a week. Key Requirements: - I alrea...Users can create online test, generate links and take test using the application - The whole app will be less than 10 pages - The App will have a lot of funtionality like generating common test link, session specific test link, generating test scores/result, question bank support, dynamic questions... The ideal candidate should have: - Solid experience in NextJs, ShadCn, and Prisma. - Proven track record in E-commerce application development. - Ability to deliver high-quality work under tight deadlines. Please only apply if you are confident in your ability to meet these requirements and can deliver the proj...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals...

Quiero pasar estas dos funciones de C++ a C template<class T> int EEPROM_put(int ee, const T& value) { const byte* p = (const byte*)(const void*)&value; unsigned int i; for (i = 0; i < sizeof(value); i++) foo(ee++, *p++); return i; } template<class T> int EEPROM_get(int ee, T& value) { byte* p = (byte*)(void*)&value; unsigned int i; for (i = 0; i < sizeof(value); i++) *p++ = foo(ee++); return i; }

Fix subscription product page - price not showing when there are no variations

The task to be solved is about triangular distribution using R. It has 8 points. Only the point e)...theoretical task, about writing the equation of density function of a triangular distribution. So I propose to you to solve the points a to d, and f and h by using R and the required packages. I believe that by using the package "stats" and the package "EnvStats" will be enough to solve the tasks. The .R file with the solutions will be delivered as result. Each solution will be explained by comments in the code, so they can be easily understood. In this quote is included 1 meeting to share and explain the R code, and to answer any doubt that can arise from the code. Of course, if any bug or problem appears while we are discussing the code, I will...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be workin...

I'm seeking a skilled video editor capable of basic editing tasks such as cutting and merging video parts, along with adding text graphics. The task is to edit a single video that will run between 1-25 minutes. The final result will primarily be used for social media and YouTube content. You should ideally have: - Proficiency in basic editing and motion graphics editing - A keen understanding of social media and YouTube trends - Previous experience editing for social media platforms Let's turn my raw footage into an engaging piece of content that captivates viewers!

I need a full stack developer to help with the creation of my website. While the project specifics may vary, my main requirements are as follows...**Disclaimer Agreement:** Implementing a mechanism where users have to agree to certain terms before accessing the site. - **linkage to twitter & telegram. While there will not be a contract address in two of the boxes, we would like there to be a "test" of some sort to copy the info. I currently have a figma design made. We are currently working out kinks for future projects and this is a test for future work. I'm open to discussing design elements. Your expertise in these areas will be highly appreciated.

As a client, I'm in need of a gifted freelancer who will design an AI chatbot that works hand-in-hand with Google Assistant. This chatbot will be programmed to carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety ...

I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround