Excel Formula and VBA Expert with Budget/Financial expertise

Imefungwa Ilichapishwa Miaka 7 iliyopita Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

Preferred Formulas over VBA (only use VBA when necessary)

- Sheet 1: List of resources and expenditures. if no cost, do not show.

- Dashboard: I would like to provide/show the itemized roll up of the expense from another tab.

example:

Hardware: $1,000 (total cost of the expense rolled up, Excel Group function)

Server: $500

Memory: $250

Co-Location: $250

Each roll up should have the itemized cost below it.

- Sheet 3: Parameters

example:

Column 1 Column 2 Column 3 Column 4

Dashboard Hardware Resource [login to view URL]

Column 1 = Dashboard sheet

Column 2 = where to itemize on Dashboard sheet

Column 3 = which sheet to look for allocations

Column 4 = what to look for

probably need another column or two to identify which columns to index.

example:

Dashboard | Column G

Resource | Column C

Or if you have a better idea.

Please provide the cost/time and availability.

Note:
Roll ups are added together for budget purposes within the table.
The itemized resources should not be added.

Excel Visual Basic

Kitambulisho cha Mradi: #11270176

Kuhusu mradi

43 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

43 wafanyakazi huru wanazabuni wastani wa $137 kwa kazi hii

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Zaidi

$200 USD kwa siku 2
(Maoni 914)
9.4
cgullapalli

Hi, I am good at Excel formulas and vba. Plz provide me the excel file to work on. Looking forward to discuss in the chat.

$60 USD kwa siku 0
(Maoni 1230)
8.5
schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had Zaidi

$30 USD kwa siku 2
(Maoni 554)
8.4
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.

$100 USD kwa siku 2
(Maoni 500)
8.1
KulfiSoftwares

ZERO ERROR GUARANTEED!! Please read my reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied wit Zaidi

$100 USD kwa siku 3
(Maoni 315)
7.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Zaidi

$150 USD kwa siku 3
(Maoni 334)
7.5
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Zaidi

$778 USD kwa siku 25
(Maoni 32)
7.2
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, and presentation in Excel using custom macros (VBA scripts), Zaidi

$100 USD kwa siku 1
(Maoni 194)
7.2
shikhamehta

Hey, I am an expert in Excel based templates and have done several financial spreadsheets like you have mentioned. I can certainly create the spreadsheet based on your requirements. If you could drop a message to me Zaidi

$200 USD kwa siku 5
(Maoni 100)
6.6
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Wai Zaidi

$100 USD kwa siku 3
(Maoni 124)
6.4
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. I am ready to start working immediately. Please contact me for more information.

$86 USD kwa siku 3
(Maoni 145)
5.9
sajibdigital

Hello dear client, I am interested to work with you. Please contact with me on PM for more discuss about this project. I am waiting for you. You may check my profile for more details about my past experience at Zaidi

$100 USD kwa siku 3
(Maoni 81)
5.8
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Zaidi

$155 USD kwa siku 3
(Maoni 42)
6.0
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliv Zaidi

$222 USD kwa siku 5
(Maoni 86)
6.1
satishtl

Resource wise summary of expenditure would be calcluted. Dashboard to represent the summary for the resource expenditure- on click of button Have good expertise in Excel automation Can complete in couple of days. Zaidi

$50 USD kwa siku 2
(Maoni 51)
6.1
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I am very muc Zaidi

$98 USD kwa siku 3
(Maoni 45)
5.6
psprongs

I have worked for over 4 years on creating macros and add-ins using vba for excel. I'm good at creating expense and balance sheets. I have worked with charts, dashboards, userforms. I can start immediately

$111 USD kwa siku 3
(Maoni 14)
4.6
ashitjha7

20+ years industry work experience in the area of IT, Finance & Banking. Also, I have 4+ years of experience in Economics, Business Analytics and Advanced statistics projects using software such as Python, R, SPSS, Min Zaidi

$250 USD kwa siku 14
(Maoni 1)
3.4
TulyakovN

Understand, how to do this job. Skills in VBA, experiance of working in word, excel, access. No problem with this job and those tasks from discription.

$50 USD kwa siku 3
(Maoni 5)
3.2
mstbilkisakter

Dear hiring manager I have read your job post carefully and understood clearly about your need. I am really interested to work for you. According to your job description you need a fast worker for your work. For you Zaidi

$155 USD kwa siku 3
(Maoni 6)
2.7