
Closed
Posted
Paid on delivery
Pozdrav, tražim iskusnog Excel stručnjaka za završetak, povezivanje i automatizaciju postojeće Excel datoteke za planiranje radnog rasporeda zaposlenih za cijelu 2027. godinu. Januar 2027. već je detaljno izrađen i treba poslužiti kao osnova za sve ostale mjesece. Datoteka sadrži formule, automatske obračune, uslovna formatiranja, boje, skraćenice i pravila za radne dane, vikende, nedjelje, praznike i odsustva. **1. Izrada svih 12 mjeseci:** Potrebno je na osnovu januara izraditi februar–decembar 2027. Svaki mjesec mora zadržati istu strukturu, izgled, formule i funkcionalnosti, uz prilagođavanje broja dana, datuma, kalendarskih sedmica, subota, nedjelja i praznika. **2. Međusobno povezivanje mjeseci:** Ovo je posebno važno. Svih 12 mjeseci mora biti međusobno povezano kako bi se relevantni podaci, pravila i obračuni automatski prenosili iz jednog mjeseca u sljedeći. Ako neki obračun zavisi od prethodnog mjeseca, Excel to mora automatski uzeti u obzir. Cijela godina mora funkcionisati kao jedan povezan sistem. **3. Formule i automatski obračuni:** Potrebno je analizirati sve postojeće formule u januaru, razumjeti njihovu logiku i pravilno ih prilagoditi ostalim mjesecima. Sve funkcionalnosti moraju ostati sačuvane, a promjene unesenih podataka moraju automatski ažurirati povezane obračune. **4. Uslovna formatiranja i boje:** Sva postojeća pravila uslovnog formatiranja potrebno je pravilno prenijeti na ostale mjesece. Boje se moraju automatski mijenjati prema unesenim podacima, kao u januaru. Ne želim samo vizuelno kopirane tabele. **5. Skraćenice, odsustva, nedjelje i praznici:** Potrebno je sačuvati postojeću legendu skraćenica i povezati je sa svim mjesecima. Pravila za odsustva, radne dane, nedjelje i praznike moraju pravilno funkcionisati tokom cijele godine. **6. Provjera i ispravljanje grešaka:** U datoteci već postoji februar, ali je potrebno provjeriti jesu li formule i formatiranja ispravno preneseni. Sve eventualne greške i nelogičnosti potrebno je ispraviti. Posebno je važno testirati funkcionalnost prilikom promjene podataka i prelaska iz jednog mjeseca u sljedeći. **7. Konačni rezultat:** Želim jednu profesionalno uređenu, pouzdanu i potpuno funkcionalnu Excel datoteku sa svih 12 mjeseci za 2027. godinu. Izgled i osnovna logika januara moraju ostati sačuvani. Ne tražim jednostavno kopiranje tabela, nego kvalitetno tehničko rješenje koje će se moći svakodnevno koristiti bez ručnog popravljanja formula i formatiranja. **8. Uslovi saradnje:** Prije početka rada potrebno je pregledati postojeću datoteku i razumjeti njenu logiku. Molim zainteresovane stručnjake da navedu imaju li iskustva sa složenim Excel formulama, automatizacijom i povezivanjem radnih listova, mogu li realizovati sve zahtjeve, koja je fiksna cijena kompletnog projekta i koliko vremena je potrebno za izradu. U cijenu treba biti uključeno testiranje i ispravljanje eventualnih grešaka prije konačne isporuke. **Prednost imaju stručnjaci iz Bosne i Hercegovine, Srbije, Hrvatske i ostalih zemalja Balkana**, zbog lakše komunikacije na našem jeziku. Postojeću Excel datoteku mogu dostaviti na pregled radi precizne procjene obima posla. Hvala unaprijed na ponudama!
Project ID: 40781281
89 proposals
Remote project
Active 17 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
89 freelancers are bidding on average €139 EUR for this job

Hello, I have thoroughly analyzed your project requirements for automating the Excel schedule for the year 2027, focusing on connecting the existing file and ensuring seamless functionality across all months. Let's chat and discuss it further. To handle your project, I will start with replicating the structure and formulas from January to create February-December 2027, ensuring interconnectivity between all months for automatic data transfer. I will analyze and adapt existing formulas, maintain conditional formatting, and synchronize abbreviations, absences, weekends, and holidays throughout the year. The deliverables of this project include a professionally organized, reliable Excel file for the entire year 2027, preserving the layout and logic of January. Before signing-off my bid, I would like to ask a question, i.e., how often do you anticipate the need for updates or modifications to the schedule template? Best Regards, Aneesa.
€250 EUR in 3 days
7.2
7.2

AVAILABLE TO START IMMEDIATELY. FREE SAMPLE PROVIDED.,,. I will build and interconnect all 12 monthly schedule sheets for 2027 in Excel, ensuring dynamic date handling, consistent conditional formatting, seamless cross-month carryover calculations, and error-free formulas. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
€51 EUR in 1 day
6.7
6.7

Hi, I got that you are looking for an experienced Excel expert to complete, connect, and automate an existing Excel file for scheduling employees throughout the entire year of 2027. I can help you with this, let's chat. My approach is to meticulously create all 12 months based on January, ensuring each month maintains the same structure, layout, formulas, and functionalities while adapting to varying days, dates, calendar weeks, Saturdays, Sundays, and holidays. The key focus will be on interconnecting all 12 months to seamlessly transfer relevant data, rules, and calculations automatically from one month to the next, creating a cohesive system. As final deliverables, you will receive a professionally organized, reliable, and fully functional Excel file with all 12 months for 2027, maintaining the layout and basic logic of January. The file will include interconnected months, accurate formulas, conditional formatting, color changes based on data input, abbreviation legends, absence rules, workdays, Sundays, and holidays functioning flawlessly throughout the year. One thing I'd like to confirm before we start: Are there any specific conditional formatting rules or data dependencies that need special attention during the interconnection of months? Looking forward to discussing this further. Let's connect. Regards, Imran
€90 EUR in 1 day
5.8
5.8

Hello, I’m experienced in advanced Excel formulas, automation, conditional formatting, and linking worksheets. I can complete and test your 2027 employee scheduling workbook, ensuring all 12 months work accurately as one connected system. Regards, Muhammad
€100 EUR in 1 day
5.9
5.9

Hi, I understand you need the existing January 2027 schedule used as the working model for all twelve months, while keeping the formulas, colors, abbreviations, holidays, absences, weekly rules, and automatic calculations working correctly. I will first inspect the workbook structure and test January and the existing February sheet. Then I will build and connect the remaining months, adjust dates and day counts, check conditional formatting, and make sure changes carry correctly from one month to the next. I will also test different employee data and month transitions, fix any errors, and return one clean file ready for daily use. My work will use Excel, Data Processing, Automation, and Excel VBA where needed for reliable links and repeatable calculations. Could you confirm whether the workbook uses Excel VBA macros already, and which holiday calendar should be applied for 2027? Please start the chat and send the workbook so I can review its logic and confirm the final scope. Let’s discuss.
€180 EUR in 7 days
5.5
5.5

Can start now.I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
€240 EUR in 2 days
5.9
5.9

Hi, I will complete, link, and automate your 2027 Excel schedule across all 12 months based on your January template, carrying over formulas, conditional formatting, and monthly carryovers. I can deliver this tested, error-free file within 3 days for 100 EUR. Send the file for a free review or quick sample.
€140 EUR in 3 days
5.3
5.3

Najveći rizik nije izrada novih listova, nego to da prenosi obračuna i uslovna formatiranja nastave ispravno raditi nakon promjene mjeseca. Prvo ću pregledati formule i pravila u januaru te provjeriti postojeći februar. Zatim ću izraditi preostale mjesece uz odgovarajuće datume, kalendarske sedmice i veze između listova. Sačuvat ću legendu i izgled, a testirati promjene unosa, odsustva, praznike i prenose između mjeseci. U isporuku ulaze provjera i ispravka pronađenih grešaka. Obuhvat mogu potvrditi, a fiksnu ponudu dati nakon pregleda datoteke. I have a few questions: Q1: Za koju državu, odnosno regiju, treba postaviti praznike? Q2: Koja se stanja ili obračuni moraju prenositi u sljedeći mjesec? Za početak mi pošaljite postojeću Excel datoteku.
€100 EUR in 4 days
5.7
5.7

Pozdrav, Detaljno sam pregledao opis projekta i razumijem da vam je potreban potpuno funkcionalan i međusobno povezan Excel raspored za svih 12 mjeseci 2027. godine. Imam iskustva s naprednim Excel formulama, automatizacijom, uslovnim formatiranjem i povezivanjem radnih listova. Mogu početi odmah nakon pregleda postojeće datoteke. Najvažniji izazov je pravilno prenošenje obračuna između mjeseci, uz očuvanje svih pravila i izgleda januara. Prvo ću analizirati formule i provjeriti postojeći februar. Zatim ću izraditi preostale mjesece, povezati obračune, prilagoditi datume, sedmice, praznike i odsustva te provjeriti uslovna formatiranja. Posebno ću testirati promjene podataka, prelaze između mjeseci i automatsko ažuriranje rezultata. Okvirna fiksna cijena je 180 EUR, a rok izrade 4–6 radnih dana, uz testiranje i ispravke. Konačnu procjenu potvrdit ću nakon pregleda datoteke. Imam jedno pitanje: Možete li mi poslati postojeći Excel kako bih provjerio logiku formula i međumjesečne zavisnosti? Radujem se saradnji. Srdačan pozdrav, Carlos.
€50 EUR in 6 days
5.5
5.5

Automatizacija i povezivanje Excel radnih listova spadaju u moje ključne vještine, uz iskustvo u tehničkom rješavanju problema, obradi podataka i optimizaciji poslovnih procesa. Vaš raspored za 2027. zahtijeva više od kopiranja tabela, a moja kombinacija Excel rada, automatizacije i pažljivog testiranja odgovara upravo takvom zadatku. Mogu analizirati logiku januarskog lista, provjeriti postojeći februar i prenijeti strukturu, formule, automatske obračune, uslovno formatiranje, boje, skraćenice i pravila za sve ostale mjesece. Posebnu pažnju posvećujem povezivanju podataka između listova, pravilnom obračunu datuma, radnih dana, vikenda, nedjelja, praznika i odsustava, kao i provjeri da izmjene u jednom mjesecu ažuriraju zavisne obračune. Iskustvo u data processingu i automatizaciji omogućava mi da završnu datoteku provjerim kao cjelovit sistem, a ne samo kao vizuelno uređene kopije. Radim organizovano, detaljno i uz jasnu komunikaciju. Spreman sam preuzeti kompletan Excel projekat, uključujući testiranje i ispravljanje grešaka, te izraditi pouzdanu datoteku za svakodnevno korištenje.
€140 EUR in 2 days
5.4
5.4

Složeni Excel rasporedi sa formulama, VBA makroima i automatizacijom spadaju direktno u moje područje rada. Kao napredni Excel stručnjak, radim sa Excelom, Excel VBA, makroima, obradom podataka i automatizacijom, što je posebno važno za povezivanje svih 12 mjeseci u jedinstven i pouzdan sistem za 2027. godinu. Mogu analizirati logiku januarskog lista, provjeriti postojeći februar i pravilno prenijeti strukturu, formule, uslovna formatiranja, boje, skraćenice, odsustva, vikende, nedjelje i praznike na ostale mjesece. Posebnu pažnju posvećujem međumjesečnim obračunima, automatskom ažuriranju nakon promjene podataka i testiranju prelaza iz jednog mjeseca u drugi, kako bi konačna datoteka bila praktična za svakodnevnu upotrebu bez ručnih ispravki. Excel automatizacija, VBA i izrada izvještaja dio su mojih glavnih usluga, a zadovoljstvo klijenta mi je prioritet. Spreman sam preuzeti kompletan projekat, uključujući provjeru i ispravljanje grešaka prije konačne isporuke. Vega izaberite mene za pouzdanu i profesionalno završenu Excel datoteku.
€140 EUR in 7 days
5.1
5.1

Pozdrav, Nisam s Balkana, ali svu komunikaciju vodim pismeno, pa možemo raditi na vašem jeziku. Kako bih to uradio: prvo do kraja analiziram januar, svaku formulu, uslovno formatiranje i legendu skraćenica, jer od toga zavisi sve ostalo. Zatim gradim ostale mjesece tako da se datumi, dani u sedmici, subote, nedjelje i praznici generišu automatski iz godine i mjeseca, a praznici dolaze iz jedne tabele praznika za 2027. Tako se broj dana i kalendarske sedmice prilagođavaju sami, bez ručnog kopiranja tabela. Povezivanje mjeseci: sve što zavisi od prethodnog mjeseca, na primjer saldo sati ili preostali godišnji odmor, uzima se direktno iz završnog stanja prethodnog lista, pa cijela godina radi kao jedan sistem. Postojeći februar provjeravam i ispravljam po istim pravilima, a uslovna formatiranja prenosim kao pravila, ne kao kopirane boje. Na kraju testiram datoteku: mijenjam unose u januaru i provjeravam da se promjene ispravno prenose sve do decembra. Koji obračuni u januaru zavise od prethodnog mjeseca?
€120 EUR in 4 days
4.3
4.3

Mogu pregledati postojeću Excel datoteku, analizirati formule i logiku januara te izraditi i povezati svih 12 mjeseci za 2027. godinu. Posebnu pažnju posvetit ću automatskim obračunima, prenosu podataka između mjeseci, uslovnom formatiranju, bojama, odsustvima, nedjeljama i praznicima. Provjerit ću i postojeći februar, ispraviti uočene greške te testirati promjene podataka i prelazak iz jednog mjeseca u sljedeći. Cilj je pouzdana i profesionalno uređena Excel datoteka spremna za svakodnevnu upotrebu, uz očuvanje izgleda i osnovne logike januara. Nakon pregleda datoteke mogu potvrditi fiksnu cijenu i rok isporuke.
€500 EUR in 7 days
3.8
3.8

⚠️ If you're not happy, you don’t pay. ⚠️ Hi Client, Thank you for checking my proposal and sharing the detailed project brief. I can build your comprehensive Excel scheduling tool using advanced Excel features with a professional and user-friendly design. I will deliver: • Creation of all 12 months, maintaining January's structure and formulas • Interlinked months for seamless data transfer and calculations • Thorough analysis and adaptation of existing formulas • Accurate conditional formatting and color coding for dynamic updates • Retention of abbreviations and rules for absences, weekends, and holidays • Error checking and corrections to ensure flawless functionality • A fully functional Excel file ready for daily use You will also receive: comprehensive documentation and support for any future adjustments. I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag Pipal
€150 EUR in 14 days
3.8
3.8

Hi, Pure Code here, from Saudi Arabia. What matters most in fixing your desktop app is a stable app your users can rely on, without breaking what already works. I'm a senior software developer with 8+ years of experience working with Data Processing, Data Entry and Data Analysis. The real challenge is working safely inside existing code: each form, event and dependency can hide side effects. A common issue: changing shared code without a way to compare behavior, so a fix breaks other screens. My plan: first, build the project in the original IDE and reproduce each issue. Then, fix the forms and events one at a time with small commits. Finally, test on common Windows setups and display scales before handover. I'd start with the most visible fixes as phase one. I've done desktop app work before. A few questions to better understand the scope: 1. Is the current code under version control? Version control makes every change reversible. 2. Keep each fix in its own commit? I'd recommend it, each change stays reversible. 3. Do users install it themselves, or does IT? That shapes how updates and settings work. I can start right away. I'm on CET, so our working hours overlap. Happy to go over the details here in chat and suggest the best approach. Looking forward to hearing from you, Pure Code
€140 EUR in 7 days
3.9
3.9

Pozdrav, Mogu pregledati vašu postojeću Excel datoteku i dovršiti raspored za svih 12 mjeseci 2027. godine, uz očuvanje strukture i logike januara. Prilagodit ću formule, povezati mjesece, prenijeti uslovno formatiranje i boje te provjeriti pravila za smjene, vikende, nedjelje, praznike i odsustva. Posebnu pažnju posvetit ću postojećem februaru, testiranju prelaza između mjeseci i ispravljanju eventualnih grešaka. Prije potvrde konačne cijene pregledao bih datoteku kako bih razumio postojeće formule i obim automatizacije. Okvirna cijena: 140 EUR Procijenjeni rok: 5–8 dana, nakon pregleda datoteke. Možete li mi poslati postojeću Excel datoteku na pregled kako bih potvrdio da se svi zahtjevi mogu realizovati u dogovorenom budžetu i roku? Hvala!
€140 EUR in 5 days
3.9
3.9

Hi — I can take your January sheet as the “master” and turn the file into a single, connected 2027 system (not just copy‑paste tables). **How I’ll handle it** - **Build Feb–Dec 2027 from January**: same layout, formulas, validations, legend, and conditional formats, but with correct **day count, dates, week numbers, weekends, Sundays and Swiss holidays**. - **Link the months**: wherever totals/balances/limits depend on the previous month (overtime, remaining vacation, rolling sums, etc.), I’ll connect them so values **flow automatically month to month**. - **Fix February**: audit what’s already there and correct any broken references, shifted ranges, or formatting rules. - **Preserve logic & automation**: I’ll use proper structured references / named ranges where needed so formulas don’t break when months change. - **Testing**: I’ll change sample inputs (absences, shifts, holidays) and verify that calculations + conditional colors update correctly across month boundaries. **Quick questions (so I set it up right)** 1) Is it **one workbook with 12 sheets (Jan–Dec)** or a different structure? 2) Do you already have a defined list of **2027 holidays for Oensingen (SO)** inside the file, or should I add a small holiday table for Switzerland/Solothurn? **Timeline** - First review + plan: same day after receiving the file - Full build + linking + testing: **2–4 days** depending on complexity of the formulas and cross‑month rules
€120 EUR in 2 days
3.7
3.7

I opened your 2027i.xlsx. February, March and April already exist, but they only carry the daily "Summe anwesend" counts. The per-employee columns AK to AO (Sunday/holiday work, target days, worked days, balance; about 165 formulas per column in January) and all of January's conditional-formatting rules are missing there, so the colours and totals stop after January. Two more things in the file matter for the other 11 months: - In January's AK formula the holidays are typed in as day 1 and day 2. In the other months it has to read your "Feiertage 2027" sheet (Karfreitag, Ostermontag, Auffahrt, Pfingstmontag, 1 August, Christmas), otherwise those days are not counted. - The rule that highlights 6 worked days in a row is tied to January's week columns (G:L, N:S, U:Z, AB:AG). Each month starts on a different weekday, so it has to be rebuilt per month, or written so it finds the week by itself. What I will deliver: 1. All 12 months of 2027 with January's layout, formulas, colours and legend codes, adjusted for the number of days, weekdays, calendar weeks and holidays of each month. The existing February to April sheets get rebuilt from January so they match it. 2. Links between months: where a figure carries over (for example the balance in column AO feeding the next month), it is linked by formula, so the whole year works as one file. 3. Holidays read from the "Feiertage 2027" sheet instead of being typed into formulas, so next year you only change that one sheet. 4. A test pass: I enter sample codes (F, K, KH, H, X and others) in every month, check that colours and totals react correctly, and clear the test data before delivery. Native .xlsx, no macros needed unless you want them. Before I start I need two answers from you (no extra cost): - Which figures should carry over from one month to the next: only the balance in AO, or also vacation and compensation days? - Does the employee list stay the same all year, or do people join or leave between months? Language: I write in English. Your German workbook and your brief are no problem for me, but I do not write Bosnian, Serbian or Croatian fluently, so our messages would be in English. Price: EUR 120 fixed, including testing and fixing errors before final delivery. Time: 4 days after your answers. Suggested milestones (total EUR 120, 4 days): - M1 EUR 24 (20%): January corrected and February rebuilt, sent for your check - M2 EUR 48 (40%): March to August - M3 EUR 48 (40%): September to December, links between months, final test Fund M1 to start, release it when you are happy, then fund the next. Standard Freelancer escrow, it protects both of us. Why me: I am an engineer and I build calculation workbooks. I opened your file before writing this offer, and every point above comes from your own sheets, so you can check it yourself. Ready to begin the moment you award and fund M1. Amr
€120 EUR in 4 days
3.8
3.8

Hi, Sara here, from Serbia. What matters most in fixing your desktop app is a stable app your users can rely on, without breaking what already works. I'm a senior software developer with 6+ years of experience working with projects like this. The real challenge is working safely inside existing code: each form, event and dependency can hide side effects. A common issue: changing shared code without a way to compare behavior, so a fix breaks other screens. My plan: first, build the project in the original IDE and reproduce each issue. Then, fix the forms and events one at a time with small commits. Finally, test on common Windows setups and display scales before handover. I'd start with the most visible fixes as phase one. I've done desktop app work before. A few questions to better understand the scope: 1. Is the current code under version control? If not, I'd add it first, so every change can be rolled back. 2. Keep each fix in its own commit? I'd recommend it, you can review and revert any single change. 3. Do users install it themselves, or does IT? That decides how updates and settings files are handled. I can start right away. I'm on CET, so our working hours overlap. Happy to go over the details here in chat and suggest the best approach. Looking forward to hearing from you, Sara
€215 EUR in 2 days
3.4
3.4

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
€250 EUR in 63 days
3.6
3.6

Oensingen, Switzerland
Payment method verified
Member since Oct 22, 2026
$250-750 USD
₹600-1500 INR
$2-8 USD / hour
₹600-1500 INR
$15-25 USD / hour
€30-250 EUR
$2-8 USD / hour
₹750-1250 INR / hour
₹1500-12500 INR
$15-25 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
$30-250 USD
$30-60 USD
$250-750 USD
€18-36 EUR / hour
$50-100 USD
£20-250 GBP
$10-30 USD
₹37500-75000 INR