|
jay bee (m)
|
I see some people are intellects here. Although I did not study engineering though, but I believe someone can assist me with an Excel project, kinda like a simulation. I lost my drive that contained all my model templates and now I have this minor project and have to start a new one. The project is one where we have to calculate financials of an air taxi with one equipment. Financial include Pro-forma Income statement, Balance sheet, Ratio analysis, Sales forecast (up to 60 months), Payroll analysis and deductions, Break-even chart, Loan Amortization Schedule, Depreciation (SLN) and several others . I have up to a week to do this project and I already started on some of the worksheets, (three days for a rough sketch with consistent formulas, 2 days with adding and adding number and connecting them to other workbooks, and one day left for reviewing). When I get a reply, I will post the spreadsheet sample details, and each person can pick a particular financial and sketch out with a formula . You need a good background in Excel at least intermediate, although everyone is welcome.
I know it is not what people are expecting, but please contribute before criticizing.
Do you need help or just wanna showcase your skills? I also do a lot of excel manipulation to provide statistical analysis on a monthly basis. |
|
|
|
|
|
manny4life (m)
|
Do you need help or just wanna showcase your skills?
I also do a lot of excel manipulation to provide statistical analysis on a monthly basis.
Showcase? I wish. I just need help cos I am caught up. |
|
|
|
|
|
jay bee (m)
|
Help with the equations?
What part of the model are you struggling with?
I have an advanced excel function list i can send to you. Hit me up 2morrow via my YIM so i can email it to you.
|
|
|
|
|
|
manny4life (m)
|
The most part is the forecasting, I mean actualizing with it almost real time data with unforeseen scenarios. Although I've done a few research here and there, but I guess I will work with the numbers I have and assume everything being equal. Thanks again and I will contact you tomorrow for the templates.
|
|
|
|
|
|
manny4life (m)
|
Thanks. Another problem I have is the WHAT-IF Analysis (scenario manager and goal seek) trying to simulate worst to good scenarios, I have few problems. When I select a range of data , it alters the formulas within that array of data, also I did successfully record a Macro, create the buttons and everything, but when I open it a second time and try to run the Macro, it comes up with a error. Plz what is the cause of all this errors, I know there is something I'm not doing right, plz what is it. I really appreciate your help.
Another one plz, in the IF function, I have always used the normal ><= and so on, but in the first block "LOGICAL TEST", I am trying to combine = and > in that field, but it says its invalid.
|
|
|
|
|
|
jay bee (m)
|
I think it will be best if you email me a copy of your template.
Macros are known to be error prone so you might need to edit it in the visual basics editor to correct the error.
|
|
|
|
|
|
manny4life (m)
|
Regarding that IF function, here is a sample data.
Deprture Destination Trip/NM Nau.Miles Cost/NM Total Cost/NM Monthly Cost Annual Cost
DC Richmond 1 190 1.8 342 8,892 106,704
DC Newyork 1 190 3.5 665 17,290 207,480
DC Florida 1 190 3.5 665 17,290 207,480
DC Georgia 1 190 3.5 665 17,290 207,480
DC Pennsylvania 1 190 3.5 665 17,290 207,480
In the sixth column (Total Cost/NM), I want to use the IF funtion as IF "LOGICAL TEST" field column 3(Trip/NM) is >or =1, it will return true, because if its either 0 nor anything greater than 2, it will return false which I don't want. What should I do in this case?, also, if I put >0, it will return true, but the chances of errors are certain because it would return true for decimal numbers also and I want a whole numbers or do I set a validation rule or what. Plz I need help
|
|
|
|
|
|
jay bee (m)
|
=IF(column3>=1,("true"),("false"))
You can set a validation rule for the column so tha it treats the decima as whole number
|
|
|
|
|
|
manny4life (m)
|
I think it will be best if you email me a copy of your template.
Macros are known to be error prone so you might need to edit it in the visual basics editor to correct the error.
That is what I was saying, I lost my drive and I did not back up my stuff, so I don't have my previous templates to do this new project so I have to start from scratch. Yeah, I definitely will holla when I have to do that Macro stuff again. Thanks again for all your assistance and I will email you for the templates so I can get this stuff rolling . |
|
|
|
|
|
biolabee (m)
|
for this i think using data validation will be better since you only want whole numbers 0 or 1
Go to Data, Validation, Choose List and type between 0,1
see pix below
formulas will be too complex for this purpose
|
|
|
|
|
|
dober
|
Dober.The answer is branching
|
|
|
|
|
|
mufuteeeee (m)
|
This is a mathematics question. Prove that -2cr=(-1)^r(r+1) i.e -2 combination r= -1 raised to power r multiplied by r+1  |
|
|
|
|
|
RichyBlacK (m)
|
This is a mathematics question. Prove that -2cr=(-1)^r(r+1) i.e -2 combination r= -1 raised to power r multiplied by r+1 The equation does not hold for r=1. There is something wrong with that equation. |
|
|
|
|
|
mufuteeeee (m)
|
It works. -2C1=-2*-3!/(-3!*1)=-2 . -1^1*(1+1)=-2 So It works  |
|
|
|
|
|
mufuteeeee (m)
|
Why has no one posted since. Well, I want to start a new thread that deals only with mathematics. I need your patronage. Piss |
|
|
|
|
|
server34 (m)
|
Why has no one posted since. Well, I want to start a new thread that deals only with mathematics. I need your patronage. Piss because u guys have spoilt the thread with your complex mathematics, computers and electronics questions. Una too sabi. What happened to the time when we asked questions that most people can answer, requiring no specialization? Which of the following countries has the largest population of English speakers? India United Kingdom Canada United States Nigeria |
|
|
|
|
|
Dr Tomgirl (f)
|
United States.
|
|
|
|
|
|
RichyBlacK (m)
|
because u guys have spoilt the thread with your complex mathematics, computers and electronics questions. Una too sabi. What happened to the time when we asked questions that most people can answer, requiring no specialization?
Which of the following countries has the largest population of English speakers?
India
United Kingdom
Canada
United States
Nigeria
India, by at least 2 to 1, compared to any other nation. |
|
|
|
|
|
Phemour (m)
|
RichyBlacK in Education  |
|
|
|
|
|
RichyBlacK (m)
|
RichyBlacK in Education  I love education! |
|
|
|
|
|
|
|
ladysex (f)
|
1 How many faces does a cuboid have?
2 Why do you want to work outside of your country?
3 What is the chemical formula for potassium nitrate?
4 Should teachers wear school uniform?
5 Who was known as the silent president?
6 When will world war 3 start?
Goodluck.
|
|
|
|
|
|
server34 (m)
|
1 How many faces does a cuboid have?
2 Why do you want to work outside of your country?
3 What is the chemical formula for potassium nitrate?
4 Should teachers wear school uniform?
5 Who was known as the silent president?
6 When will world war 3 start?
Goodluck.
1. 6 2. Because your country does not work. 3. KNO 34. No. They would look like senior students. 5. Yar'adua??? 6. If I never see work by the end of this year. |
|
|
|
|
|
muyeskin (m)
|
Assistant Moderator
Hello Fellow Nairalanders,
Please vote for muyeskin as your assistant moderator in the education sector for continuity and progress.
Thanks.
Muyeskin
|
|
|
|
|
|
|
|
Phemour (m)
|
The Educative Game
|
|
|
|
|
|
Gabry (f)
|
Assistant Moderator
Hello Fellow Nairalanders,
Please vote for muyeskin as your assistant moderator in the education sector for continuity and progress.
Thanks.
Muyeskin
LOL!!! And yet u say u aint campaigning |
|
|
|
|
|
laqui
|
phemour are u still nairaland moderator? i have fit in u
|
|
|
|
|
|
Phemour (m)
|
TONDO? |
|
|
|
|
|
3spade3 (m)
|
mess a education. All you need is that protection, substance and some ground.
|
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
Presentation1.jpg (52.03 KB, 960x720 )
