[Excel Power Query Expert] Fix Administrative Costs and Fees data in New Bid Template

Suljettu Julkaistu kuukausi sitten Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

Deliverables

1. Both “Administrative Costs” (I83) and “Fees” (I84) pull into the table. I think this is adding columns to the table, but am not sure how to do it. Both are 7.5% fees

2. Rename “Fees” in the table as "Administrative Costs” and name the new “Fees” addition as the “Fees” selection in the table.

3. Reconcile newly added cost lines into "Change_Order_List" tab.

Additional Information

CHG Order Template (highlighted in yellow) -

The Fees were split into “Administrative Costs” (I83) and “Fees” (I84), but only “Administrative Costs” tracks to the data table (AN:AI)

The Data table on the RFC tabs (and the CHG Order Template where the tabs originate) populates the “Change_Order_List” tab (yellow). This includes fee percentages.

I think the fee percentages come from “Grn Sheet” tab (green), but am not sure.

We need the following:

Both “Administrative Costs” (I83) and “Fees” (I84) pull into the table. I think this is adding columns to the table, but am not sure how to do it. Both are 7.5% fees

Rename “Fees” in the table as "Administrative Costs” and name the new “Fees” addition as the “Fees” selection in the table.

Excel Tietojenkäsittely Microsoft Access Visual Basic Excel VBA

Projektin tunnus: #38865693

Tietoa projektista

34 ehdotusta Etäprojekti Aktiivinen viime viikolla

34 freelanceria on tarjonnut keskimäärin $24 tähän työhön

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Lisää

$80 USD 2 päivässä
(624 arvostelua)
8.6
carlitanjuguna05

Hi! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific Lisää

$30 USD 2 päivässä
(10 arvostelua)
5.0
saim2105

Based on your project's description, I'm confident that my expertise and skills as an Excel Power Query Expert can be of great value to your needs. My vast experience in complex data analysis, formula creation, and rep Lisää

$20 USD 1 päivässä
(19 arvostelua)
4.8
Orientwork

I am an independent business consultant and polyvalent professional with experience in innovation & product development, project management, consumer research, processes optimization and design, people management and d Lisää

$20 USD 1 päivässä
(64 arvostelua)
5.2
Legitvirtuals

With a wealth of experience in Excel and extensive knowledge of PowerQuery, I am the go-to professional to flawlessly execute this task. From pulling data and adding columns as required, to renaming the necessary eleme Lisää

$50 USD 2 päivässä
(13 arvostelua)
4.7
TDRWork

With the proficiency of over 7 years in Microsoft Excel, my name is Ihala, and I am an expert in Excel automation using VBA/Power Query who can go above and beyond to solve your administrative costs and fees data chall Lisää

$30 USD 7 päivässä
(13 arvostelua)
4.1
EmadOwaida

Greetings, I am excited to submit my proposal for your project, leveraging my extensive expertise in Excel Power Query to deliver exceptional results. With over 15 years of experience in data processing and Excel, I a Lisää

$30 USD 2 päivässä
(3 arvostelua)
3.7
Asif031984

Dear Client, I bring over 15 years of experience and have successfully delivered 80+ projects during the freelancer as well as other remote freelancers. Some of areas are mentioned below: • Bookkeeping, Accounting, Tax Lisää

$20 USD 7 päivässä
(4 arvostelua)
4.5
GraphicsHub2k24

Dedicated Freelancer Ready to Elevate Your Project for [Excel Power Query Expert] Fix Administrative Costs and Fees data in New Bid Template. I have a solid background in Microsoft Access, Excel, Visual Basic, Excel VB Lisää

$10 USD 1 päivässä
(5 arvostelua)
3.4
Osama102

Hi, I hope this message finds you well. I am writing to express my interest in working on your project and providing the required solution. My name is Osama, and I am an expert in Excel and VBA, with extensive experi Lisää

$15 USD 1 päivässä
(8 arvostelua)
2.9
ahsanrajpoot0

Hi I ve seen both provided files. To fix the administrative costs and fees data, I can add the necessary columns to the table and rename them as specified. After that, I’ll ensure that the new cost lines are accurate Lisää

$29 USD 7 päivässä
(3 arvostelua)
2.5
haseebulrehman25

Hello Serey, I’m ready to work with you and look forward to your response. Let’s discuss when you're free, and we can start ASAP. Warm Regards, Haseeb

$50 USD 1 päivässä
(2 arvostelua)
1.5
Abodunrinh4

As an accomplished Data Processing and Excel expert, I am confident in my ability to tackle the challenges outlined in your project with great precision and accuracy. Specifically, I have extensive experience with data Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
callumh2

Thanks for offering. what about me? I know you maybe doubt me. but I have a skillful experience with 8+ years in this field. And I am a creative and passionate person. Now, I am serious. you will see my ability directl Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
adorbee

As an Excel expert with extensive experience in data management and manipulation, I am confident that my skills will be a perfect fit for your project. My proficiency with complex formulas and functions, such as Power Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
Muhammadanas5469

With extensive experience in various fields, I am a highly skilled professional specializing in Data Entry, Data Scraping, Typing, Translation, Virtual Assistance, Data Annotation, and Quality Control Assurance. Over t Lisää

$10 USD 2 päivässä
(0 arvostelua)
0.0
NidhamHaris

As an ex-banker for over 4 years, I have a lot of experience using both Google Sheets and Excel for tasks like data entry, reporting, and analysis. I’m very comfortable with formulas like VLOOKUP, HLOOKUP, INDEX-MATCH, Lisää

$25 USD 7 päivässä
(0 arvostelua)
0.0
pijushpal780

I can efficiently assist with updating your project by ensuring both "Administrative Costs" (I83) and "Fees" (I84) are added to the table and accurately tracked at 7.5%. I will rename “Fees” in the table to "Administra Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
cardozoandreina

Soy un profesional administrativo con experiencia en la gestión eficiente de proyectos y equipos, destacándome por mi organización, atención al detalle y habilidades interpersonales. Graduado con honores de una univers Lisää

$25 USD 7 päivässä
(0 arvostelua)
0.0
anissyafika

I have a strong background in Microsoft Access, Excel, Visual Basic, Excel VBA, and Data Processing, offering valuable expertise for your project to fix Administrative Costs and Fees data in the New Bid Template. With Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0