Fiat Coupe Forum
- Founded by Kayjey & James Northam
- Funded by the Club for the benefit of all owners
Fiat Coupe Club UK
join the club
Fiat Coupe Forum
 
» Announced
    Posting images


» Related sites
    Main club site
    fiatcoupe.net


» External data
    owners listed
 
Who's Online Now
0 registered members (), 331 guests, and 4 spiders.
Key: Admin, Global Mod, Mod
Forum Statistics
Forums69
Topics113,543
Posts1,340,441
Members1,785
Most Online731
Jan 14th, 2020
Top Posters(All Time)
barnacle 33,522
stan 32,122
Theresa 23,296
PeteP 21,482
bockers 21,070
JimO 17,917
Nigel 17,366
Edinburgh 16,662
RSS Feeds
Club Events
Club Information
Track Events
Rolling Road/RWYB
Social Events
Non-UK Events
Coupé Related Chat
Coupé Spotting
Coupé News/Press
Buying/Selling Advice
Insuring a Coupé
Basic FAQ's
How to Guides
Forum Issues
Technical Problems
General Maintenance
Styling
Tuning
Handling
ICE and Alarm
Coupés for Sale
Coupés Wanted
Parts for Sale
Parts Wanted
Group Buys
Business Forum
Other Vehicles for Sale/Wanted
Other Items for Sale/Wanted
Haggling/Offers
Ebay links
Other Cars
Other Websites
General Chat
Previous Thread
Next Thread
Print Thread
Experienced Spreadsheet Person Needed #1637815
26/12/2019 23:51
26/12/2019 23:51
Joined: Jun 2006
Posts: 23,296
North Wales
Theresa Offline OP
Former Presidentessa Club member 58
Theresa  Offline OP
Former Presidentessa Club member 58
Forum Fossil

Joined: Jun 2006
Posts: 23,296
North Wales
Hi all smile

I've always hand written my timesheet out for work, but now I've changed departments, I have more varied hours, with varied overtime, etc and somebody in work said it was easier and neater to fill in the timesheet electronically, which it is, but there's a couple of things annoying me that I don't know how to change.

They have sent me the template, but there's a couple of columns the wrong way around compared to the original/standard timesheet and my printer is cutting off some of the left hand side, etc. Also, when I type in December 2019, it keeps changing it to 01/12/19, which is annoying.

I've had a mess around, but don't really know what I'm doing, so I was wondering if someone could sort it for me so I can just type in my details and worked hours and print it off each month

Not sure if it makes a difference, but Microsoft Office doesn't work on my laptop so I use Open Office.

Thanks.

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637816
27/12/2019 08:27
27/12/2019 08:27
Joined: Sep 2009
Posts: 4,994
ation
szkom Offline
Club member 2000
szkom  Offline
Club member 2000
Forum is my job

Joined: Sep 2009
Posts: 4,994
ation
Some easy fixes, hopefully smile

Select all the cells that have the wrong date formate in. Right click and select '"Format" from the list. Go to the numbers tab and select date in the category box. You can now choose the preferred format. Click okay when finished.

Fixing the columns is just as easy. Click on the column letter to the right of where you want the misplaced column to go (ie, if you want it between B an C click on C), right click and select insert columns. Click on the letter of the column you want to move (it should all highlight in blue), right click and select cut. Click back on the letter of the column you created and right click. Select paste.

Getting the print area set correctly should also be straightforward. However it's a while since I used OpenOffice so remembering where the correct options are. If you select all the cells you want to print, then go to the format tab and select page ranges, then select define from that list. Once you've done that you can go back to the format tab and select page from the menu. You'll be able to adjust for portrait/landscape, size, etc.

I'd save the file as a different name to allow you test what you've done is correct. Click file on the header and select Save as to do this and type your file name into the dialog box. The only problem you'll find is that you'll have to use an old excel file format to save the document. Generally this causes no problems unless you're sharing the document for edit with other people who use excel and the document has lots of formula and formating in it.

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637817
27/12/2019 08:59
27/12/2019 08:59
Joined: Dec 2005
Posts: 17,366
Staffordshire
Nigel Offline
Forum veteran
Nigel  Offline
Forum veteran

Joined: Dec 2005
Posts: 17,366
Staffordshire
Hi T

If it’s easier, send me a copy of the spreadsheet and I’ll fix it for you, but it won’t be for a few days


[Linked Image]
Re: Experienced Spreadsheet Person Needed [Re: Nigel] #1637819
27/12/2019 09:58
27/12/2019 09:58
Joined: Jun 2006
Posts: 23,296
North Wales
Theresa Offline OP
Former Presidentessa Club member 58
Theresa  Offline OP
Former Presidentessa Club member 58
Forum Fossil

Joined: Jun 2006
Posts: 23,296
North Wales
Thanks szkom. I managed to change the date format by following your instructions. I tried the columns, but nothing is happening when I right click on the column letter and when I tried a couple of other things, it says the cells are protected and can't be changed.
I'll wait until those are sorted and then play with the print options.

In the meantime, I've emailed you the file I was sent Nigel. I just need the date and day columns on the left side to be swapped around please.

If it can't be done, it's not massively important as the person who sent me the file obviously fills in their timesheet as it is and it gets accepted, but ideally, to stay in line with everyone else, the date and day should be swapped.

Thanks smile

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637820
27/12/2019 10:18
27/12/2019 10:18
Joined: Mar 2007
Posts: 16,662
Auld Reekie
Edinburgh Offline
Club President, member225
Edinburgh  Offline
Club President, member225
Forum veteran

Joined: Mar 2007
Posts: 16,662
Auld Reekie
I sympathise T, have to fill in more and more complicated pay claims at uni, it's a pain in the backside. First they "expire" any password you might have, then they change the system - and terminology - and the latest was when instructed to click on Internet Explorer there was suddenly no such thing in existence....I had to ask a passing student to show me the ropes!

I seem to remember in some of the old formats that there were "protected" areas and oddities like when filling in signature and date they couldn't be entered in boxes next to "date" and "signature".

In forty-odd years of filling in pay claims it's actually got harder and takes longer rolleyes laugh


BumbleBee carer smile
Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637913
03/01/2020 23:00
03/01/2020 23:00
Joined: Jun 2006
Posts: 23,296
North Wales
Theresa Offline OP
Former Presidentessa Club member 58
Theresa  Offline OP
Former Presidentessa Club member 58
Forum Fossil

Joined: Jun 2006
Posts: 23,296
North Wales
Nigel has very kindly helped me out with this - thank you Nigel smile

Thanks also szkom smile

Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637920
04/01/2020 07:33
04/01/2020 07:33
Joined: Dec 2005
Posts: 17,366
Staffordshire
Nigel Offline
Forum veteran
Nigel  Offline
Forum veteran

Joined: Dec 2005
Posts: 17,366
Staffordshire
No problem - the worksheet was password protected, so I had to use a password breaker to allow the swapping of the columns.

Microsoft spent a fortune adding a special new type of protection when they rolled out Office 2010 - it now takes at least 30 seconds to open a password-protected sheet, rather than the ten seconds it used to take..... rolleyes


[Linked Image]

Powered by UBB.threads™ PHP Forum Software 7.7.1
(Release build 20190129)
PHP: 7.3.33 Page Time: 0.012s Queries: 15 (0.005s) Memory: 0.7717 MB (Peak: 0.8598 MB) Data Comp: Off Server Time: 2024-03-29 09:21:00 UTC