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
2 registered members (Ballypete, 1 invisible), 94 guests, and 3 spiders.
Key: Admin, Global Mod, Mod
Forum Statistics
Forums67
Topics110,414
Posts1,310,553
Members2,172
Most Online731
Jan 14th, 2020
Top Posters(All Time)
barnacle 32,308
stan 32,098
Theresa 22,924
bockers 21,019
PeteP 19,356
JimO 17,908
Nigel 17,201
Jim_Clennell 16,346
nismo 15,137
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: 22,924
North Wales
Theresa Offline OP
Former Presidentessa
Theresa  Offline OP
Former Presidentessa
Forum Fossil

Joined: Jun 2006
Posts: 22,924
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,646
ation
S
szkom Offline
Forum is my job
szkom  Offline
Forum is my job
S

Joined: Sep 2009
Posts: 4,646
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,201
Staffordshire
Nigel Offline
Club Member 123
Nigel  Offline
Club Member 123
Forum veteran

Joined: Dec 2005
Posts: 17,201
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: 22,924
North Wales
Theresa Offline OP
Former Presidentessa
Theresa  Offline OP
Former Presidentessa
Forum Fossil

Joined: Jun 2006
Posts: 22,924
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: 11,094
Auld Reekie
Edinburgh Online content
Club Board member
Edinburgh  Online Content
Club Board member
I AM a Coop

Joined: Mar 2007
Posts: 11,094
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


Thanks again, Photobucket.
BumbleBee under restoration, in paintshop!...
Re: Experienced Spreadsheet Person Needed [Re: Theresa] #1637913
03/01/2020 23:00
03/01/2020 23:00
Joined: Jun 2006
Posts: 22,924
North Wales
Theresa Offline OP
Former Presidentessa
Theresa  Offline OP
Former Presidentessa
Forum Fossil

Joined: Jun 2006
Posts: 22,924
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,201
Staffordshire
Nigel Offline
Club Member 123
Nigel  Offline
Club Member 123
Forum veteran

Joined: Dec 2005
Posts: 17,201
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.12 Page Time: 0.014s Queries: 14 (0.007s) Memory: 0.7765 MB (Peak: 0.8604 MB) Data Comp: Off Server Time: 2020-01-19 18:44:00 UTC