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

Closed Posted 1 month ago Paid on delivery
Closed Paid on delivery

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 Data Processing Microsoft Access Visual Basic Excel VBA

Project ID: #38865693

About the project

34 proposals Remote project Active last week

34 freelancers are bidding on average $24 for this job

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 More

$80 USD in 2 days
(624 Reviews)
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 More

$30 USD in 2 days
(10 Reviews)
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 More

$20 USD in 1 day
(19 Reviews)
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 More

$20 USD in 1 day
(64 Reviews)
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 More

$50 USD in 2 days
(13 Reviews)
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 More

$30 USD in 7 days
(13 Reviews)
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 More

$30 USD in 2 days
(3 Reviews)
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 More

$20 USD in 7 days
(4 Reviews)
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 More

$10 USD in 1 day
(5 Reviews)
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 More

$15 USD in 1 day
(8 Reviews)
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 More

$29 USD in 7 days
(3 Reviews)
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 in 1 day
(2 Reviews)
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 More

$20 USD in 7 days
(0 Reviews)
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 More

$30 USD in 1 day
(0 Reviews)
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 More

$20 USD in 7 days
(0 Reviews)
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 More

$10 USD in 2 days
(0 Reviews)
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, More

$25 USD in 7 days
(0 Reviews)
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 More

$10 USD in 1 day
(0 Reviews)
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 More

$25 USD in 7 days
(0 Reviews)
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 More

$20 USD in 7 days
(0 Reviews)
0.0