> 2021年08月03日信息消化 #### 32 incredibly useful things you didn’t know Google Sheets could do origin: [32 incredibly useful things you didn’t know Google Sheets could do](https://www.fastcompany.com/90334451/google-sheets-tips) - Ctrl-Shift-1: Format as decimal - Ctrl-Shift-2: Format as time - Ctrl-Shift-3: Format as date - Ctrl-Shift-4: Format as currency - Ctrl-Shift-5: Format as percentage - Ctrl-Shift-6: Format as exponent ##### GRAB SOME DATA ###### **pull in data from any publicly available web page**, ```formula =IMPORTRANGE ("https://docs.google.com/spreadsheets/d/1aBcDEfgHiJKLMnOPQRSTuVWXZ", "Sheet1!D1:D15") =IMPORTHTML("https://en.wikipedia.org/wiki/List_of_sandwiches","table",1) =IMPORTFEED("https://fastcompany.com/user/jrraphael/rss") =IMPORTFEED("https://fastcompany.com/user/jrraphael/rss","items URL",false,5) ``` ##### CLEAN IT UP If you want to perform the function for multiple cells at once, use this format for whatever range you need: ``` =ArrayFormula(TRIM(A2:A50)) ``` Looking at lots of data with RanDoM or ImPropeR CaPitaLiZaTion? Sheets can **standardize case formatting for you** with a few simple functions: =Upper(A1) will make all of the text uppercase for whatever cell you mention; =Lower(A1) will do the same with lowercase; and =Proper(A1) will capitalize the first letter of each word for a title-case effect. ##### **Create a tiny chart within a single cell** ``` =SPARKLINE(E12:E23,{"charttype","column"}) ```  ##### Explore Hover your mouse over the starburst-shaped icon in the lower-right corner of the screen, and you’ll see the word Explore appear. Click that button, and Sheets will pop up a panel of info related to your data. You can highlight specific rows in your spreadsheet to change its focus, and you can hover over any item it presents to find options for adjusting it or inserting it directly into your sheet.  **Add special characters into any spreadsheet** the easy way: Use the Char command and remember the numerical values of characters you frequently rely on. For instance, =CHAR(8594) will produce a right-facing arrow, =CHAR(169) will give you the copyright symbol, `=CHAR(8482)` will create the trademark symbol, and =CHAR(128077) will turn into the thumbs-up emoji. You can find a list of available codes [on this website](https://unicode-table.com/); just be sure to grab the numbers only (without any surrounding punctuation) from the HTML-code field. **give people a direct link to download your data as a PDF** ``` https://docs.google.com/spreadsheets/d/1aBcDEfgHiJKLMnOPQRSTuVWXZ/export?format=pdf ``` ##### **create QR codes** ``` =image("https://image-charts.com/chart?chs=150x150&cht=qr&choe=UTF-8&chl="&ENCODEURL(B4)) ```  \30. Here’s a handy little Sheets function for tracking trends across numerical data: **Create a heat map** to highlight highs and lows and make it easy to see things like sales or web-traffic success patterns. Select whatever range of data you want, then look for the Conditional formatting option within the Format menu. Click the Color scale tab at the top and assign a color to both Min value and Max value. The effect will work best if you use a light version of a color for the former and a dark version of the same color for the latter.  Ever find yourself scrolling through a list of responses in different languages? Sheets can **identify any language used in a spreadsheet and even translate it** into your own native tongue on the spot. To detect a language, use the following function (with the appropriate cell number in place of “A1”): ``` =DETECTLANGUAGE(A1) ``` You can also enter in a word in place of a cell number, if you want: ``` =DETECTLANGUAGE("queso") ``` Google will give you a two-letter code telling you the language that was used. To translate, meanwhile, use the following command—with your own word or cell number in place of “A1” and the code for whatever language you want to translate into (if it’s anything other than English, as referenced below): ``` =GOOGLETRANSLATE(A1,"auto","en") ``` ##### [How to Convert Currency in Google Sheets](https://www.howtogeek.com/449986/how-to-convert-currency-in-google-sheets/) ``` =GOOGLEFINANCE("Currency:USDGBP") ```   #### How to become an expert in iOS development origin: [How to become an expert in iOS development](https://medium.com/@yuraist/how-to-become-an-awesome-ios-developer-cda0206ef86f)  After weeks or months of studying, a newbie begins to understand that iOS development is more than just the Swift language and some UI frameworks. Even for junior positions companies require a good knowledge of some additional tools and technologies, like algorithms and data structures, design patterns, architectures (MVC, MVVM, MVP, VIPER, etc), networking, databases, animations, package managers, and so on.  In fact, iOS development includes even more tools, technologies, and practices. And a great developer should be familiar with most of it. But don’t be afraid — you don’t need to use everything at once. For building your first app you’ll be fine with basic knowledge of these technologies. But the studying process should be continuous, even after years of practice. ### Illustrations For Website Of Digital Security: Case Study origin: [Illustrations For Website Of Digital Security: Case Study](https://shakuro.com/blog/illustrations-for-website-of-digital-security-case-study?ref=sidebar) - #1 Websites with illustration create ambiance and mood - #2 Website illustrations help communicate your marketing message ##### case study    We created many illustrations without any sketches. We assembled them in 3Ds max right from the paper, client approved them, and then we made revision in Adobe Photoshop.   ##### **How illustrations for the website can help to make a bigger impact and stand out** Illustrations tell stories. With their help, you can tell not only the story of any function, service, section of the site. You also can tell a story about the brand uniquely. We can see the huge dominance of photographic content, both photo, and video nowadays. It originates from hundreds of social networks and ends up on Google. Therefore, app illustration or landing page graphics in a sense are salvation. They create a unique style while greatly differing from the content that already overloads the human brain. ### Why I had to break up with the famous F-pattern in UX and move on? origin: [Why I had to break up with the famous F-pattern in UX and move on?](https://uxdesign.cc/why-i-had-to-break-up-with-the-famous-f-pattern-in-ux-and-move-on-5d759387a977) We often miss the lessons from the visual hierarchy. Our customers are not consuming every pixel or reading every alphabet. And they are hunting like a hungry wolf. > They are just scanning. All they care about is — they find what they are looking for. And they stop only to focus on something that they find is worthy of attention. ##### The beauty of the Z-pattern Many popular products have realized the beauty of the Z-pattern and they have been in partnership with it for a long. They know that customers would start scanning from the top left and they would end at the bottom right after a quick scan.  ##### What’s the fuss about the F-pattern? [The credit goes to the founders of the Nielsen-Norman group](https://www.nngroup.com/articles/layer-cake-pattern-scanning/). These folks worked hard, observed the scanning pattern of hundreds of people, and published a breakthrough study. They leveraged eye-tracking research and came up with heat maps. It helped us understand how people read digital content and the world came to know about the famous F-pattern.  When people are scanning through the documents, they are trying to economize the number of fixations they have to do and learn the most they possibly can. In simple words, they start reading from the top left with the most attention and goes to the right. Then they again go back to the left side and this time read a little less to the right. As this continues, it forms an F-pattern of scanning and reading. 当人们在扫描文件时，他们试图节省他们必须做的固定的数量，并尽可能地学习。 简单地说，他们从左上角开始阅读，注意力最集中，然后向右走。然后他们再次回到左边，这次向右读得少一点。这样持续下去，就形成了一个扫描和阅读的F型模式。 ##### How to make scanning easier for people? - Chunking - Bullet Points - Heading and sub-headings ##### One more thing There are a lot of research studies going on and we should always strive to remain updated with the latest findings. Here are different kinds of patterns that one would come across. Let me know in the comments section if you would want to learn more.  ### The 2021 State of API Survey by Smartbear (stack ref.) #### Control management tools GitHub GitHub Enterprise GitLab GitLab Enterprise Cloud Bitbucket Server Bitbucket Data Center Azure DevOps Server (TFS) Azure DevOps Services (VSTS) #### API protocols REST GraphQL SOAP Apache Kafka Confluent Kafka gRPC FTP/SFTP Websockets SSE MQTT AMQP XML-RPC AMF JSON-RPC EDI RPA #### Model and document services OpenAPI (Swagger) AsyncAPI Apache Avro Protobuf Thrift JSON Schema SQL DDL API Blueprint RAML WSDL WADL RDF (e.g. Turtle, JSON-LD) #### API Tools CI/CD Tools API Functional Testing Tools API Performance/Load Testing Tools API Designers/Editors API Documentation Tools API Monitoring Tools API Management Tools (gateways) Source Control Tools (Git….) Service Virtualization (Mocking) Tools Security Testing Tools Style Guides API Developer Portal Unit Testing Tools Code Review Tools Project Mangement Tools (Jira, Trello, etc.) ### Little - [How to Negotiate Your Tech Salary Simulation ft. Levels.fyi](https://www.youtube.com/watch?v=fyn0CKPuPlA)