Looking for an Excel wiz...
- or -
Post a project like this1778
£60(approx. $75)
- Posted:
- Proposals: 29
- Remote
- #2390110
- Awarded
Sr. Business Intelligence (BI) Consultant - Dashboard Reporting & Data Analysis - Power BI | Tableau | Advanced Excel
Indore
3615161984435920863270611027069062082709701171228050267276927177868107272616776
Description
Experience Level: Intermediate
Hi,
We're looking for a wiz to create an excel document with formulas to automatically bring in data for us.
We produce birth prints and want to automate the system a little more by letting excel do most of the research and auto input for us. ie so in column 1 if we manually input the date of birth the column for star sign, birthstone etc will be filled out automatically by excel. The reason we want to do this is that with only a small bit of excel manual work from us (ie inputting the date of birth manually and a few others we then have an excel document which we can feed automatically into Photoshop (which is a job for someone else!)
A breakdown of the columns:
Column A: Baby's Date of Birth in format 7/8/18 - MANUAL DATA ENTRY
Column B: Day Number (ie 7) - AUTOMATIC FORMULA driven by column A
Column C: Month of birth in Upper & Lower Case (ie August) - AUTOMATIC FORMULA driven by column A
Column D: Year of birth written in caps and spelt out but only the last number with an ampersand (eg & EIGHTEEN) - AUTOMATIC FORMULA driven by column A
Column E: The day of birth. Written as (On a Monday) - AUTOMATIC FORMULA driven by column A
Column F: Time of birth - AM or PM DROPDOWN SELECTION (with those 2 options only). No need to have the actual time.
Column G: Chinese Year - AUTOMATIC FORMULA driven by column A using a set of given date data we give you ie February 5th 2019 - January 24th 2020 = Pig).
Column H: Stamp Cost - AUTOMATIC FORMULA driven by column A using a set of given date data we give you ie 26 March 2018 - 24 March 2019 = 67p).
Column I: Star Sign - AUTOMATIC FORMULA driven by column A using a set of given date data we give you ie DEC 22nd - JAN 19th = Capricorn).
Column J: Birthstone - AUTOMATIC FORMULA driven by column C using a set of given date data we give you ie JANUARY = Garnet).
I hope this makes sense and is all doable! I've attached an image of the final product so that you can see why we've mentioned the specific formats in Columns B-E
Many thanks
Katy - The Whistling Wren Ltd. (Director)
We're looking for a wiz to create an excel document with formulas to automatically bring in data for us.
We produce birth prints and want to automate the system a little more by letting excel do most of the research and auto input for us. ie so in column 1 if we manually input the date of birth the column for star sign, birthstone etc will be filled out automatically by excel. The reason we want to do this is that with only a small bit of excel manual work from us (ie inputting the date of birth manually and a few others we then have an excel document which we can feed automatically into Photoshop (which is a job for someone else!)
A breakdown of the columns:
Column A: Baby's Date of Birth in format 7/8/18 - MANUAL DATA ENTRY
Column B: Day Number (ie 7) - AUTOMATIC FORMULA driven by column A
Column C: Month of birth in Upper & Lower Case (ie August) - AUTOMATIC FORMULA driven by column A
Column D: Year of birth written in caps and spelt out but only the last number with an ampersand (eg & EIGHTEEN) - AUTOMATIC FORMULA driven by column A
Column E: The day of birth. Written as (On a Monday) - AUTOMATIC FORMULA driven by column A
Column F: Time of birth - AM or PM DROPDOWN SELECTION (with those 2 options only). No need to have the actual time.
Column G: Chinese Year - AUTOMATIC FORMULA driven by column A using a set of given date data we give you ie February 5th 2019 - January 24th 2020 = Pig).
Column H: Stamp Cost - AUTOMATIC FORMULA driven by column A using a set of given date data we give you ie 26 March 2018 - 24 March 2019 = 67p).
Column I: Star Sign - AUTOMATIC FORMULA driven by column A using a set of given date data we give you ie DEC 22nd - JAN 19th = Capricorn).
Column J: Birthstone - AUTOMATIC FORMULA driven by column C using a set of given date data we give you ie JANUARY = Garnet).
I hope this makes sense and is all doable! I've attached an image of the final product so that you can see why we've mentioned the specific formats in Columns B-E
Many thanks
Katy - The Whistling Wren Ltd. (Director)
Katy P.
100% (12)Projects Completed
11
Freelancers worked with
9
Projects awarded
50%
Last project
19 Sep 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Katy
What is the status of the project?
Thanks -
Hi Katy, may ask what time frame you are looking at?
802660802316
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies