In Progress

Excel work planning sheet

this project is a prototype for some softwaredevelopment for a planning software.

we need to create an excel where based on certain configuration;

- type of week (simple/iso), first day of week (monday/sunday)

- the work/weekend days specification

- a list of business closing dates

- a list of holidays

available days should be highlighted in a "calendar" showing quarter, months, weeks (type ISO starting monday), days

then based on another configuration (on top of previous calcualtions/values), we need to show available days to work based on an indication of

- workschedule on a period of 1 2 3 4 weeks (indicating days that can be worked)

i.e. week 1 : M W F

week 2: T T

available days should be highlighted in a "calendar" showing quarter, months, weeks (type ISO starting monday), days

time frame should be possible for 3 years so its easy to verify if week functions work correctly at begining and end of year, as well as for leap years.

also there will need to be a set of values to show on a separate sheet, to quickly see if calcualtions are made correctly (like a set for total workdays, total weekend days that add up to total days in year)

after this is accomplished, there is a follow up project, where workable days for days, weeks, months, year .. in combination with workschedule will have to drive some other calculation

Skills: Excel, Data Processing, Visual Basic, Data Entry, Microsoft Office

See more: excel work sheet design, excel vba lock sheet user script, excel financial planning surgery costs, excel work instruction template, excel vba access sheet data, department reports companies pakistan using excel work sheet, convert excel work label, tally bookkeeping excel work sheet daily, excel work sheet name using, excel work sheet web page, work planning excel samples, excel work company sheet pakistan, excel work budget sheet, excel part sheet calculation vba, excel work rest hour sheet, merge excel work sheet, excel work to enter the data into the sheet, i have about 225 emails from which i need to have certain information transferred to an excel sheet there are 4 fields that i ne

About the Employer:
( 8 reviews ) Brasov, Romania

Project ID: #20427552

Awarded to:

SShtv

Hello, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data More

€175 EUR in 4 days
(79 Reviews)
5.9

36 freelancers are bidding on average €121 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

€250 EUR in 3 days
(720 Reviews)
8.5
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

€220 EUR in 5 days
(341 Reviews)
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application with calendar functionality. I plan to use a combination of More

€250 EUR in 7 days
(222 Reviews)
7.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€150 EUR in 3 days
(316 Reviews)
7.3
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed More

€169 EUR in 3 days
(136 Reviews)
7.3
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje More

€200 EUR in 7 days
(230 Reviews)
6.9
antoinepal

Hello, I can build you the excel you want as i have advanced excel skills and over8 years in the field. Please check my portfolio to see my work. Thanks!

€170 EUR in 3 days
(36 Reviews)
6.1
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

€250 EUR in 5 days
(116 Reviews)
5.9
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer, currently at the post of Forum Expert at www.excelforum.com. I read the complete description you posted and would like to provid More

€139 EUR in 3 days
(117 Reviews)
5.7
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel

€88 EUR in 3 days
(103 Reviews)
6.2
daniyal3214

I am a professional Data analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform automation, develop highly dynamic and automated More

€100 EUR in 1 day
(51 Reviews)
5.4
gsanggara

Hi There, I am interested to your project. I am an Excel expert and have a great experiences in Excel automation with formula and vba since my first career 15 years ago. I assured that you will be get high quality / hi More

€200 EUR in 3 days
(28 Reviews)
4.2
belalihabibullah

Hi, I'm very much interested in this project. I have good experience in Excel work sheet. I ensure you, sir, I will provide you with better quality work than others. I'm able to send a sample please message me. I More

€30 EUR in 1 day
(20 Reviews)
3.6
sunshine7677

Dear Client, I can do this. I have 5+ Years of Experience in Data Entry, Web Scrapping, Web Research and MS Office. I will be there during your working hours to provide support whenever you need. Let’s have a quick ch More

€30 EUR in 1 day
(12 Reviews)
3.3
romanapanovich

Hi I can implement it all in Google Sheet + Google Script Its for me preferred then Excel So - if it is acceptable - lets discuss details)

€90 EUR in 2 days
(2 Reviews)
3.4
purplemaestro

Hello. My name is Muhammad Hassan. I have high level expertise in Excel VBA and have done too many on that. I can start right now and wont disappoint you. Please share other details with so that I can start working on More

€100 EUR in 5 days
(6 Reviews)
3.3
sagarbhalke888

hello I would like to complete your project I am experienced in data entry I am having some queries regarding the project, it would be great if we talk on chat

€50 EUR in 7 days
(3 Reviews)
3.1
kulwantrana7

I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. I am a hard worker, productive and worthy of yo More

€100 EUR in 7 days
(2 Reviews)
2.7
Josephhekal

Dear, I’m a Data Scientist and Excel Expert. Have a wide range of technical competencies including: statistics, databases also collect, analyze, and interpret large data sets. I have extensive knowledge and expertise More

€50 EUR in 1 day
(7 Reviews)
2.7
makelegend17

Hello, sir. How are you? I checked your all requirements and understood what you want. I have already similar experience with your Excel processing project before. I am an excellent C++/C#/Java and Python programmer, a More

€150 EUR in 5 days
(1 Review)
2.0