Archive for the ‘Office’ Category
Posted by jpluimers on 2024/06/12
Posted in AI and ML; Artificial Intelligence & Machine Learning, Development, Excel, LLM, Office, Power User, Software Development | Comments Off on GitHub – dabochen/spreadsheet-is-all-you-need: A nanoGPT pipeline packed in a spreadsheet
Posted by jpluimers on 2024/05/13
I tried archiving the page 210mm x 99mm Blank Label Template – Microsoft Word – EU30032 and the template http://templates.uk.onlinelabels.com/TemplateFile/eu30032-template/EU30032.doc, but that fails because that site refuses to be archived in the WayBack machine and Archive.is.
So here is a local copy of [WayBack] eu30032.doc.
Related (not tried yet):
- [WayBack] Labels A4, 210 x 99 mm, white, permanent adhesion
| Ref. no. |
4664 |
| Format |
210 x 99 mm |
| Content |
300 labels / 100 sheets |
| Colour |
white |
| Printer type |
Laser, Copy, Ink |
| Adhesive characteristics |
permanent |
| Shape of corners |
square |
| Material |
paper, matt |
| Environment |
PEFC-certified |
| EAN |
4008705046640 |
| PEFC certificate |
[WayBack] Download now |
| Printing template / Processing information |
[WayBack] Download now |
- [WayBack] Printing Template for Labels – 210 mm x 99 mm – 3 Rectangle Labels per A4 Sheet (Word/PDF) | Template For Labels
|
|
There are 3 Rectangle Labels per page with each label being 210 mm wide and 99 mm high.There is a 0 mm gap between the label rows and 0 mm gap between the label columns to determine whether you can create your design with bleed or not. Whilst producing the design, due to printing restrictions on digital presses, you must consider that there is a 0 mm margin on both top and bottom of the sheet, and 0 mm margin on left and right hand side of the sheet.
Please read your printer manual carefully as each printer has a printing tolerance of up to 2 mm. You must accommodate this tolerance by producing your design with enough bleed and/or leave enough gap between the label contents and the label cut line. |
–jeroen
Posted in LifeHacker, Office, Power User, Word | Leave a Comment »
Posted by jpluimers on 2024/04/22
Needed these (in retrospect) simple steps because someone made a form with so much whitespace under the fields on a document that had to be printed for a physical signatures that otherwise too many trees would die.
[Wayback/Archive] Unprotect a Word Doc on Mac – YouTube.
Via [Wayback/Archive] word 2011 macos unprotect document – Recherche Google.
- In the menu, choose “File” -> “Save As…”
- Click “Options…”
- Click “Show All”
- Click “Security”
- Click “Unprotect Document…”
- Click “OK”
- Click “Save”
–jeroen
Read the rest of this entry »
Posted in Apple, Mac OS X / OS X / MacOS, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2024/02/20
Great for converting tab separated data (for instance when copied from Excel) into HTML:
[Wayback/Archive] Convert TSV to HTML Table Online | WTOOLS
–jeroen
Posted in Development, Excel, HTML, Office, Power User, Software Development, Web Development | Leave a Comment »
Posted by jpluimers on 2024/02/14
Calculating an ISO-8601 based WEEKNUM
From [Wayback/Archive] ISOWEEKNUM Function – How to Get the Week Number in Excel:
- If we are using an older version of MS Excel, we can use the function
WEEKNUM. By default, the WEEKNUM function uses an arrangement where Week 1 begins on January 1, and Week 2 begins on the next Sunday (when the return_type argument is omitted, or supplied as 1).
However, with MS Excel 2010 for Windows and MS Excel 2011 for Mac, we can generate an ISO week number using 21 as the return_type: =WEEKNUM(date,21).
- There is no built-in worksheet function for ISO weeks before MS Excel 2010.
I tested that ISO-8601 week number calculation in with Excel 2011 on MacOS and Excel 2010 on Windows: the workaround works well for the dates mentioned in ISO week date – Wikipedia.
Read the rest of this entry »
Posted in Excel, Office, Office 2010, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2023/10/23
Remember [Wayback/Archive] Guidelines for human gene nomenclature | Nature Genetics?**
You might not, but this was what pointed me to it back in 2020: [Wayback/Archive] Scientists rename human genes to stop Microsoft Excel from misreading them as dates – The Verge.
The article was a result of Excel mangling import data for decades. Somehow finally it did get Microsoft’s attention and more than 3 years later, they issued options (with mangling still being the default) to help workaround the problems.
The 2004 article [Wayback/Archive] Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics | BMC Bioinformatics | Full Text demonstrated this import problem which had been present for quite a while already (it even has a csh Script to scan for SymbolMutation error).
The gene nomenclature people by now have moved to a different naming scheme, but maybe other people can benefit from the Excel updates of which you can find more through these links:
Read the rest of this entry »
Posted in CSV, Development, Excel, Office, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2023/09/23
Posted in AI and ML; Artificial Intelligence & Machine Learning, Bookmarklet, ChatGPT, Development, GPT-3, GPT-4, JavaScript/ECMAScript, Office, Power User, Scripting, Software Development, Web Browsers | Leave a Comment »
Posted by jpluimers on 2023/09/19
Boy, two extra modifier keys: [Wayback/Archive] How to Strip Formatting When You Copy and Paste Text: 5 Ways
To paste as plain text on a Mac, you can use the somewhat cumbersome shortcut Option+Cmd+Shift+V to paste without formatting. This is a system-wide shortcut, so unlike Windows, it should work everywhere. Technically, the shortcuts pastes and matches the formatting, but this has the same effect of removing the original formatting.
Via [Wayback/Archive] macos word microsoft office paste without formatting – Google Search.
Paste without formatting is an issue on Windows as well. The default should be “paste without formatting” instead of the current “paste with source formatting”. See for instance these tweets:
Read the rest of this entry »
Posted in Apple, Classic editor, Development, Gutenberg editor, Mac OS X / OS X / MacOS, Office, Office 2011 for Mac, Power User, Software Development, Web Development, WordPress | Leave a Comment »
Word Template
PDF Template
The Wiert Corner - irregular stream of stuff 