Oh yeah, I'm comfortable with it. Have modified and run many scripts (mostly Hydrology-related stuff). It's just been a while, and I do need to get better at writing my own stuff.
I can't even open that file with my copy of Office 2007 for some reason.
Wat? It´s created with 2007 I believe. We use it at work.unnamednewbie13 wrote:
I can't even open that file with my copy of Office 2007 for some reason.
Was your formula (A1:EC1) or did you have it (A1+B1+C1...)?Sisco wrote:
Nah, I need all 31 lines. I´m not sure I made the problem clear.
The formula in C1 needs the cells Y1, AA1 and EC1 added.
The formula in C2 needs Y2, AA2 and EC2.
this all the way down to C42 and the same for B1. That what you did?
I´m totally retarded for excel
(A1:EC1) would automatically calculate any inserted columns (as long as they weren't first or last)
"Ah, you miserable creatures! You who think that you are so great! You who judge humanity to be so small! You who wish to reform everything! Why don't you reform yourselves? That task would be sufficient enough."
-Frederick Bastiat
-Frederick Bastiat
Oh wow, holy shit. I downloaded that thing and it's a complete mess.
"Ah, you miserable creatures! You who think that you are so great! You who judge humanity to be so small! You who wish to reform everything! Why don't you reform yourselves? That task would be sufficient enough."
-Frederick Bastiat
-Frederick Bastiat
Here's what was in it when I hit the text editor:Sisco wrote:
Wat? It´s created with 2007 I believe. We use it at work.unnamednewbie13 wrote:
I can't even open that file with my copy of Office 2007 for some reason.
Code:
"<script type="text/javascript">location="/#!download|341|428920431|WTV_VORLAGE_erweitert_aktualisiert_am_28.10.2010.xls|51";</script>
Yeah, the files and formats we use are years old and were designed by a student who used to work here part-time a long time ago. We are also more or less the last hotel in the country who still uses a pen and paper system to organise and book the rooms (dunno the english word).
The chef is the embodyment of "Never change a running system"
I could try it myself, but I´m way too retarded with Excel to even get startet
As I said, there are quite some very effective and convenient all-in-one software suites available who could manage all this but they are rather expensive and why change a running system...
The chef is the embodyment of "Never change a running system"
I could try it myself, but I´m way too retarded with Excel to even get startet
As I said, there are quite some very effective and convenient all-in-one software suites available who could manage all this but they are rather expensive and why change a running system...
I've changed out document formats and scheduling/time sheets at least six times in the past three years. Helps if nobody starts complaining about it, though.
Well, I'm off from class today and I don't have any homework. If you could explain why you have it split into country of origin for guests, and why there are two inputs for each country of origin, I'd bang out a new spreadsheet for you in an hour or so.Sisco wrote:
Yeah, the files and formats we use are years old and were designed by a student who used to work here part-time a long time ago. We are also more or less the last hotel in the country who still uses a pen and paper system to organise and book the rooms (dunno the english word).
The chef is the embodyment of "Never change a running system"
I could try it myself, but I´m way too retarded with Excel to even get startet
As I said, there are quite some very effective and convenient all-in-one software suites available who could manage all this but they are rather expensive and why change a running system...
"Ah, you miserable creatures! You who think that you are so great! You who judge humanity to be so small! You who wish to reform everything! Why don't you reform yourselves? That task would be sufficient enough."
-Frederick Bastiat
-Frederick Bastiat
There are two formulae you can use (these are for the first row only):
=SUMPRODUCT(D12:EE12,MOD(COLUMN(D12:EE12)+1,2))
and
=SUMPRODUCT(D12:EE12,MOD(COLUMN(D12:EE12),2))
This is the corrected sheet, if I did what you needed.
Enjoy!
=SUMPRODUCT(D12:EE12,MOD(COLUMN(D12:EE12)+1,2))
and
=SUMPRODUCT(D12:EE12,MOD(COLUMN(D12:EE12),2))
This is the corrected sheet, if I did what you needed.
Enjoy!
Redesigning the spreadsheet to invert the axes would definitely make more sense...but I posted a solution that is just a modification to the existing spreadsheet. A less complicated sheet would be better in the end, especially if he's not an excel guru!JohnG@lt wrote:
Well, I'm off from class today and I don't have any homework. If you could explain why you have it split into country of origin for guests, and why there are two inputs for each country of origin, I'd bang out a new spreadsheet for you in an hour or so.Sisco wrote:
Yeah, the files and formats we use are years old and were designed by a student who used to work here part-time a long time ago. We are also more or less the last hotel in the country who still uses a pen and paper system to organise and book the rooms (dunno the english word).
The chef is the embodyment of "Never change a running system"
I could try it myself, but I´m way too retarded with Excel to even get startet
As I said, there are quite some very effective and convenient all-in-one software suites available who could manage all this but they are rather expensive and why change a running system...
I could bang it out in less than an hour easily, I just need to know why the current functions and layout exist. People are pretty conservative and don't feel comfortable with excessive changes so I'd try to stick close to the original intent.SenorToenails wrote:
Redesigning the spreadsheet to invert the axes would definitely make more sense...but I posted a solution that is just a modification to the existing spreadsheet. A less complicated sheet would be better in the end, especially if he's not an excel guru!JohnG@lt wrote:
Well, I'm off from class today and I don't have any homework. If you could explain why you have it split into country of origin for guests, and why there are two inputs for each country of origin, I'd bang out a new spreadsheet for you in an hour or so.Sisco wrote:
Yeah, the files and formats we use are years old and were designed by a student who used to work here part-time a long time ago. We are also more or less the last hotel in the country who still uses a pen and paper system to organise and book the rooms (dunno the english word).
The chef is the embodyment of "Never change a running system"
I could try it myself, but I´m way too retarded with Excel to even get startet
As I said, there are quite some very effective and convenient all-in-one software suites available who could manage all this but they are rather expensive and why change a running system...
Last edited by JohnG@lt (2010-11-05 08:04:29)
"Ah, you miserable creatures! You who think that you are so great! You who judge humanity to be so small! You who wish to reform everything! Why don't you reform yourselves? That task would be sufficient enough."
-Frederick Bastiat
-Frederick Bastiat
It took me ~5 minutes to modify the sheet to make use of sumproduct and mod...and making a new sheet would entail basically just copy-paste for the names, and then summing the columns...5-10 mins, maybe (I hate data entry, so I'm slow). I was bored so I decided to fix it while retaining their format, lol.JohnG@lt wrote:
I could bang it out in less than an hour easily, I just need to know why the current functions exist.SenorToenails wrote:
Redesigning the spreadsheet to invert the axes would definitely make more sense...but I posted a solution that is just a modification to the existing spreadsheet. A less complicated sheet would be better in the end, especially if he's not an excel guru!JohnG@lt wrote:
Well, I'm off from class today and I don't have any homework. If you could explain why you have it split into country of origin for guests, and why there are two inputs for each country of origin, I'd bang out a new spreadsheet for you in an hour or so.
Fantasy baseball taught me the intricacies of excel long before I ever took an engineering course Should see some of my masterpieces.SenorToenails wrote:
It took me ~5 minutes to modify the sheet to make use of sumproduct and mod...and making a new sheet would entail basically just copy-paste for the names, and then summing the columns...5-10 mins, maybe (I hate data entry, so I'm slow). I was bored so I decided to fix it while retaining their format, lol.JohnG@lt wrote:
I could bang it out in less than an hour easily, I just need to know why the current functions exist.SenorToenails wrote:
Redesigning the spreadsheet to invert the axes would definitely make more sense...but I posted a solution that is just a modification to the existing spreadsheet. A less complicated sheet would be better in the end, especially if he's not an excel guru!
Last edited by JohnG@lt (2010-11-05 08:09:51)
"Ah, you miserable creatures! You who think that you are so great! You who judge humanity to be so small! You who wish to reform everything! Why don't you reform yourselves? That task would be sufficient enough."
-Frederick Bastiat
-Frederick Bastiat
RPGs did that for me!JohnG@lt wrote:
Fantasy baseball taught me the intricacies of excel long before I ever took an engineering course Should see some of my masterpieces.SenorToenails wrote:
It took me ~5 minutes to modify the sheet to make use of sumproduct and mod...and making a new sheet would entail basically just copy-paste for the names, and then summing the columns...5-10 mins, maybe (I hate data entry, so I'm slow). I was bored so I decided to fix it while retaining their format, lol.JohnG@lt wrote:
I could bang it out in less than an hour easily, I just need to know why the current functions exist.
Guys, wow. Thanks, but I´m not sure we need a new one. Its not that important of a document to be honest.
The country of origins are a given from the vienna travel office, which now got extended/modified, hence why I needed the sheet.
The left cell per country is the number of arrivals on that specific day, the right one the total number of people from that country at that given day.
The most left cells sum up the total number of arrivals and people from all the countries on each day to a total for the whole month.
We have some daily calculating and some other minor things (including the monthly report) who are more or less bound to the format given, so a new layout would require us to redo everything.
I really appreciate the effort, but don´t bother. Use your free time better. At least I get paid thinking about this at work
Thanks for the offer though. The next upgrade step should be an integrated software suite, which would make all these things redundant and which the boss is debating whether to get for a year now. MIght pummel him a bit more to get one, making life easier for us.
Thanks again!
The country of origins are a given from the vienna travel office, which now got extended/modified, hence why I needed the sheet.
The left cell per country is the number of arrivals on that specific day, the right one the total number of people from that country at that given day.
The most left cells sum up the total number of arrivals and people from all the countries on each day to a total for the whole month.
We have some daily calculating and some other minor things (including the monthly report) who are more or less bound to the format given, so a new layout would require us to redo everything.
I really appreciate the effort, but don´t bother. Use your free time better. At least I get paid thinking about this at work
Thanks for the offer though. The next upgrade step should be an integrated software suite, which would make all these things redundant and which the boss is debating whether to get for a year now. MIght pummel him a bit more to get one, making life easier for us.
Thanks again!
Resolved. Will reopen if the OP (e: or anyone else, for that matter) has any further questions.