Skip to main content

Posts

Show HN: CL and FB reselling app with auto renew and auto price reduction https://ift.tt/RLUQ4gx

Show HN: CL and FB reselling app with auto renew and auto price reduction I recently moved apartments and had a lot of stuff I wanted to get rid of. I found the reselling process to be cumbersome – I needed to post the same info twice, to both Facebook and Craigslist. I had to renew the items so they don't expire. I also had to reduce the item prices if they didn't sell. So I decided to do what any right minded overzealous, "pragmatic" software engineer does – instead of spending 10 minutes every few days reducing the prices and renewing the items, why not spend 3 weeks to build out a fully decked out Electron app that does all of the above automatically for you? Why not indeed... In the end, it's been a fun ride and I learned a lot. And actually! now it's coming in handy as I'm finally starting to sell the backlog of items that I've accumulated. Once I built it, I figured I'd offer it on gumroad, make a buck, why not... btw, the link is for a disc...
Post a Comment
Read more https//reachsingh.blogspot.com»

Muni Customer Satisfaction Survey

Muni Customer Satisfaction Survey By Jeanne Brophy The results of the 2021 Muni Customer Satisfaction Survey reflect ridership impacts and concerns during the global pandemic and a local shelter-in-place order. As a result, Muni reduced service and experienced significantly lower ridership demand.  Muni was able to provide service to essential workers along with protecting its front-line workforce and the overall financial outlook for the agency. Survey respondents gave us a 57 percent overall positive satisfaction rating. Topping the customer list of most important attributes were accessibility, cleanliness, and operator helpfulness. Highlights of the 2021 Muni survey: 57 percent of Muni riders rate its overall service as “good” or “excellent” – a 2% decline from 2019 Low-income riders rate Muni service higher now than before the pandemic indicating our data-driven service delivery was aligned to the public need of focusing on essential workers and the transit dependent: ...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: RateYourRecruiter.dev https://ift.tt/qdjoAul

Show HN: RateYourRecruiter.dev Tech recruiting and interviewing sucks. So I created https://ift.tt/74Pot0c to hold recruiters to account. The elevator pitch reads: Interviewing for a role in a highly sought after tech company is broken. Recruiters have incentive to get as many people in for interviews, with little to none (or incorrect) information. Questions often have little to do with on-the-job responsibilities, and are rarely communicated to recruiting and back to the candidate. By having a more transparent process is not only more equitable, but will lead to greater success for candidates and recruiters. RateYourRecruiter.dev aims at demystifying the recruiting and tech interview process. March 4, 2022 at 10:34AM
Post a Comment
Read more https//reachsingh.blogspot.com»

More 20 MPH Streets Coming Soon Near You

More 20 MPH Streets Coming Soon Near You By Christine Osorio Last October when California Assembly Bill 43 (Friedman) was signed into law, we posted a blog about which gave cities new flexibility in setting speed limits—specifically reducing them. “Speed Management,” a reference that is still in development, focused on reducing speed limits in key business activity districts where at least 50% are dining or retail. Since the bill went into effect last month, we’ve already started lowering speed limits by 5 MPH (from 25 MPH to 20 MPH) in the first phase of approved corridors, four of which have been implemented:  San Bruno Avenue, from Silver to Paul avenues (Completed January 2022)  Polk Street, from Filbert to Sutter streets (Completed January 2022)  Haight Street, from Stanyan Street to Central Avenue and from Webster to Steiner streets (Completed February 2022)  24th Street, from Diamond to Chattanooga streets and from Valencia Street to San Bruno...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: WAPM – WebAssembly Package Manager https://ift.tt/N4LsAyU

Show HN: WAPM – WebAssembly Package Manager Hi HN! I’m Syrus, from the Wasmer team. We just released the new version of WAPM that is an order of magnitude better than the previous one (that we also announced here in HN two years ago! [0]), enabling an incredible experience for using and publishing WebAssembly packages. The tech stack that we are using includes: * Python and Django (for the backend) with Graphene (for the open GraphQL API [1]) and Django Channels with websockets over GraphQL [2] for subscriptions * Next.js [3] with React-Relay [4] and Tailwind.css [5] for the frontend * WebAssembly and Wasmer [6] (for the online shell) Vercel for serving the frontend and GCP for serving the backend. Please let me know if you have any questions, I’d be very happy to answer them! https://wapm.io/ March 3, 2022 at 01:22AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: I made a WebGL-based app that traces images using circles https://ift.tt/joJLwN7

Show HN: I made a WebGL-based app that traces images using circles I was fascinated by this [0] and this video [1]. After many struggles, I finally built this app that traces images using circles similar to what these videos had shown. The most challenging part (to me) is to find a way to convert images to vector lines. I had tried Potrace, but its output is not suitable for my use case: too many small elements share the same border. Potrace's goal is to represent the original image faithfully using vector lines. But I want to trace the image edges. After searching and trying some Potrace alternatives in vain, I finally found my keyword. Surprisingly (to me), it lies at the end of the wiki page of the very topic [2]. Then I found a paper [3] that has nice pseudocode and a C implementation. I rewrote the pseudocode in Rust because I wanted to experiment with rustwasm. Honestly, I didn't care much about the math behind it. From then, I could continue to finish the app and show it...
Post a Comment
Read more https//reachsingh.blogspot.com»

SFMTA Budget Priorities for FY 2023 to FY 2024

SFMTA Budget Priorities for FY 2023 to FY 2024 By Andrea Buffa It’s budget season!  Every two years, the SFMTA develops a consolidated budget to guide the agency’s decisions about where to focus our funding to best meet the transportation needs of all San Franciscans. We’re developing a budget that’s designed to support San Francisco’s economic recovery, increase transportation equity, protect the environment and keep the agency on sound financial footing.   We presented the base budget (projected revenues and expenditures for the next two years if we made no changes and continued our current policies) to our Board of Directors in early February to get their feedback and are now seeking input from the public. Your feedback will help us understand what to change in our base budget: which investments are most important to San Franciscans and which new revenue sources you think we should pursue. We’re considering both fare increases and decreases as well as changes to parkin...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Type2Learn – Learn by typing the webpage text in the browser itself https://ift.tt/9o4G5rE

Show HN: Type2Learn – Learn by typing the webpage text in the browser itself Ever happened that while reading a long article, you cannot concentrate and read the same line again and again? Try this extension now! Read the text by typing it on the webpage itself. Practice your touch typing by monitoring your speed, errors you make, and accuracy in real-time. Chrome store link: https://ift.tt/Saprkx9... https://ift.tt/af3lbT4 March 2, 2022 at 12:21AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: A more social, Amazon-free alternative to Goodreads https://ift.tt/hioe34J

Show HN: A more social, Amazon-free alternative to Goodreads Hey HN, I know reading books isn’t everyone’s thing, but it’s certainly been mine for as long as I can remember. Unfortunately, I felt like the online book space was missing a platform that does the book community justice. Goodreads is the go-to "social platform", but if you've been on Goodreads before, you'll probably agree that it's not all that social, and overall not all that exciting. So I set out to build what I personally was looking for (but could never find). The goal: to give the book community a more social and streamlined alternative to Goodreads or StoryGraph. We also felt like it was important for Booqsi to be independent of Amazon; we care about supporting local bookstores, so every book in Booqsi links you to Bookshop.org to purchase that book (not Amazon). Here are some of my favorite features launched as part of beta: - A book-focused social feed (finally!) - Beautifully-rendered custom...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Language aware diff on GitHub PRs https://ift.tt/cxijS6g

Show HN: Language aware diff on GitHub PRs Hi HN! We were frustrated with text diffs on GitHub PRs, so we made DiffLens ( https://ift.tt/3gSbFTR ). DiffLens constructs an Abstract Syntax Tree for each file, and uses that semantic information to intelligently diff changes. Checkout the demo on our website ( https://ift.tt/B1S4Lca ). Getting started with DiffLens is easy! Simply install the app on your repositories. The next time you open a PR, DiffLens will automatically create a diff for your changes. If you review code, especially TypeScript, JavaScript or CSS, give DiffLens a try! We're always looking for feedback. If you encounter bugs, or want to give us feedback, we'll be around. You can also reach us at support@difflens.com. https://ift.tt/3gSbFTR February 28, 2022 at 10:53PM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: I Created a Chrome Extension for PG: TRAB (Tweet Reporter and Blocker) https://ift.tt/GYf4nq3

Show HN: I Created a Chrome Extension for PG: TRAB (Tweet Reporter and Blocker) A few days ago I saw this tweet from PG: https://twitter.com/paulg/status/1496549841912094733 ...and guessed it shouldn't be too hard to make a chrome extension to do this (I had never made a chrome extension before) So I took a stab at it - took me a bit over a day to make it, and it was fun to put together. I responded to his tweet with the link to the extension but I'm not sure if he would've seen it. https://ift.tt/1gKswNC February 28, 2022 at 11:32PM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Rebluff Poker, no limit hold'em for loose-aggressive players https://ift.tt/altX3z8

Show HN: Rebluff Poker, no limit hold'em for loose-aggressive players Hello, I'm uberf1sh, software engineer (I've previously worked for Amazon and Fortnite, though obviously none of the following as to do with my previous employers). My cousin introduced me to online poker in 2008 and I loved it instantly, playing $2 cash games for fun and glory. Though I was initially pretty bad, I had a lot of fun playing. Indeed, in 2008 the game was really amazing because it was so chaotic and full of crazy plays, your blood was pumping before even sitting at the table. Fast forward I was able to make $1000 a day in Vegas, spending it all on sneakers, restaurants and some other unspeakable stuff (you know the drill, what happens in Vegas stays in Vegas). 5 years ago, things started to take a real bad turn for online poker. The game slowly but surely became incredibly boring. Most regular players started to all adopt a strategy called tight-passive . Tight means you play only the best s...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Datagridxl.js v2 – no-nonsense fast Excel-like data table lib https://ift.tt/XJx8wRa

Show HN: Datagridxl.js v2 – no-nonsense fast Excel-like data table lib Hello HN, I’m Robbert, the creator of DataGridXL.js. After 1,5 years of hard work I have just released version 2. DataGridXL is a free (and commercial) editable data table library written in ES6. My goal is to develop the most performant & user-friendly spreadsheet-like data table out there: - It has zero dependencies. You don’t need any framework to use DataGridXL. - It is lightweight (~250kb) and easy to use. It does not even require messing with CSS. - It has its own Virtual DOM implementation to prevent DOM errors. - Developer friendly. Supports all modern web browsers Please take a look at the performance demo ( https://ift.tt/BEM8Cft ) to see the difference with other data grids out there. And let us know if you have any suggestions. What's new in version 2: * Rapidly search cells via top bar, just like Google Sheets. * Freeze any amount of rows and/or columns. * Hide and unhide rows and/or columns, ju...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Create customizable, short URLs for Stack Overflow profiles https://ift.tt/517jotQ

Show HN: Create customizable, short URLs for Stack Overflow profiles When building my personal site, I realised that Stack Overflow seemed to be one of the (or rather, the only) platforms that didn’t allow users to create a short, username-based link. Enter: stk.so https://stk.so/ February 27, 2022 at 11:10PM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Asyncc Jobs: a job board to accelerate async work culture https://ift.tt/aeWD4T7

Show HN: Asyncc Jobs: a job board to accelerate async work culture 2 years of remote work has proved us that this isn't the utopia we imagined we will get. There is something more. And that is async work style. I believe async work is the future. That's why I built this job board to accelerate the async work style. Please give me some support and write feedback. Thank you. https://asynccjobs.com/ February 27, 2022 at 10:39AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Esolang Park, a visual debugger for esolangs https://ift.tt/XRygAOj

Show HN: Esolang Park, a visual debugger for esolangs Hey HN! Esolang Park is an online visual debugger interface for esoteric programming languages, that I've been working on for the past few months. For every supported language, Esolang Park provides the powerful Monaco code editor, syntax checking, debugging functionality and a visualisation of the runtime state. The core is language-agnostic - a "language provider" only needs to implement the esolang's parser, interpreter and visualisation UI (and some other little stuff). Apart from trying to boost DX for esolangs, the idea is for this to grow into a platform where people can discover and play around with a variety of esolangs without leaving the browser. That's quite far away though - the project is quite early in development and currently only has 5 languages (Befunge-93, Brainf*ck, Chef, Deadfish and Shakespeare). Some features like non-debugging execution mode (0ms interval) are missing too. Currently the...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Detect Russian visitors to block them and protest the war in Ukraine https://ift.tt/pMLjU9z

Show HN: Detect Russian visitors to block them and protest the war in Ukraine It runs on the frontend in vanilla JS, it should work 9 times out 10.(false negatives near the border) (Not that thoroughly tested but should be fine) https://ift.tt/HDysob8 February 26, 2022 at 12:43PM
Post a Comment
Read more https//reachsingh.blogspot.com»

Improved Muni Transit Information

Improved Muni Transit Information By Kharima Mohamed As part of the larger effort to provide improved transit information to Muni riders, we have significantly improved the SFMTA.com stop webpages with a focus on improved accessibility.  Each of the over six thousand stops throughout the Muni Service Network has a unique webpage that displays multiple features. These improved features on the stop webpage help to improve the customer experience for riders to easily get all the information they need to get where they need to be.   Features include:   A mobile-first designed web app view for succinct on-the-go real-time vehicle predictions at the top of the page.  Detailed route information served at each location.  Alerts specific to both that specific stop and all of the routes served.  A real-time vehicle-tracking map and a vicinity map for each stop.  Nearby stops to provide stop options if an alternative is needed.  ...
Post a Comment
Read more https//reachsingh.blogspot.com»

We Want To Hear From You

We Want To Hear From You By Andrea Buffa It’s budget season!  Every two years, the SFMTA develops a consolidated budget to guide the agency’s decisions about where to focus our funding to best meet the transportation needs of all San Franciscans. We’re developing a budget that’s designed to support San Francisco’s economic recovery, increase transportation equity, protect the environment and keep the agency on sound financial footing.   We presented the base budget (projected revenues and expenditures for the next two years if we made no changes and continued our current policies) to our Board of Directors in early February to get their feedback and are now seeking input from the public. Your feedback will help us understand what to change in our base budget: which investments are most important to San Franciscans and which new revenue sources you think we should pursue. We’re considering both fare increases and decreases as well as changes to parking fees.  The Cit...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: A Network of Knowledge Feeds https://ift.tt/gLBNh1m

Show HN: A Network of Knowledge Feeds Hi Everyone, I wanted to talk to this community about a particular story from my experience to see how the community feels. I have noticed that I have a lot of educated friends from top universities in my country who are having problems finding work due to a lack of experience, which has brought me to a conclusion that diplomas and CVs are not really good at conveying the knowledge someone has. A friend of mine who is already working on his own company told me that he had trouble finding people to work for him, so I thought about an idea that I am currently incorporating into my app. Perhaps we could make it much easier for you to show your knowledge to companies, as easy as show and tell. A network of live knowledge feeds that constantly keep updating over time showing how someone has evolved. If you know something, put it on full display for everyone to see, show something you have made and explain how you made something so that everyone can unde...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Programmable network proxy for the cloud, edge and IoT https://ift.tt/G7nC63L

Show HN: Programmable network proxy for the cloud, edge and IoT *Pipy* is an [open-source]( https://ift.tt/PbrMinA ), lightweight, high-performance, modular, programmable, cloud-native network stream processor that is ideal for a variety of use-cases like edge routers, load balancers & proxy solutions, API gateways, static HTTP servers, service mesh sidecars, policy agents, and other applications. https://ift.tt/PbrMinA February 24, 2022 at 08:26AM
Post a Comment
Read more https//reachsingh.blogspot.com»

MTA Board of Directors Welcomes Stephanie Cajina

MTA Board of Directors Welcomes Stephanie Cajina By Lori Phelan Stephanie Cajina, an advocate for equitable communities and a San Francisco native, joins the SFMTA's Board of Directors as the only Latina member. With her confirmation from the San Francisco Board of Supervisors and subsequent swearing in, she fills the seventh position on the board vacated by former board member Cheryl Brinkman.  Cajina currently serves as a Senior Economic Development Specialist for the City of Napa, a position she's held since 2019. There she shapes and implements economic development strategies and manages the Economic Development Division budget. Additionally, Cajina is the co-project lead for the City of Napa's National League of Cities Initiative together with the City of Napa's Housing and Planning Division.  Before that, she served as Executive Director for the nonprofit Excelsior Action Group during, which time, she also served as a member of the SFMTA Small Business Workin...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Flatsauce – Database with Decoupled Storage and Compute https://ift.tt/u53hOf9

Show HN: Flatsauce – Database with Decoupled Storage and Compute Hi HN, this is Soheil (https://flatsauce.com). Flatsauce is a cloud database service that separates storage from compute while horizontally scaling your database cluster. Think of it as a Postgres read/write cluster with several nodes except that all the nodes in Flatsauce share the same storage. Flatsauce intelligently routes data between the nodes and incorporates a file locking mechanism to ensure there is no data corruption. In traditional read/write replication scenarios usually a write instance is the source of truth. First data is written to the write server then the data is copied to all the read nodes. When more read nodes are needed to run long-running queries the storage needs to be copied for each node. Flatsauce reduces the cost to run a database cluster by eliminating the need to duplicate the data storage every time a new node is added to the cluster. February 24, 2022 at 01:16AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Bob Planthold Tribute

Bob Planthold Tribute By Stephen Chun San Francisco lost a dedicated advocate for pedestrian safety and accessible public transportation with the recent passing of Bob Planthold. Having contracted polio at an early age, Bob used bright yellow Canadian crutches to help him move around. Firsthand experience of the obstacles people with disabilities may face in getting from place to place and accessing services made Bob a tenacious and persistent champion for pedestrian safety and accessible transit.  Bob’s activism contributed to real change that benefited people with disabilities in San Francisco. He was a member of the steering committee for the San Francisco Accessible Parking Policy Advisory Committee, which was established by the Mayor’s Office on Disability and SFMTA in 2012 to look into ways that SFMTA blue zone policy and the State Department of Motor Vehicles’ disabled placard policies could be improved to ensure greater availability of accessible parking in the City. As...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Wachy – A UI for eBPF-based performance debugging https://ift.tt/ACd7aRk

Show HN: Wachy – A UI for eBPF-based performance debugging eBPF is an amazing technology that allows safely running user-supplied functions at pretty much arbitrary probe points in a kernel/user space context. Much has been written about how amazing this feature is for kernel observability. But as someone who writes user space code, what I find even more amazing is the support for tracing arbitrary user space programs, with no code changes and low overhead. However, doing in-depth analysis can get complicated and time-consuming. My goal with wachy was to make this debugging significantly easier/faster to use, by displaying traces in a TUI next to the source code and allowing for interactive drilldown analysis. If you get a chance, check out the start of the demo video since (AFAIK) it's quite unique and gives a much clearer idea than I can provide with just text. https://ift.tt/VF6iLes February 22, 2022 at 06:13AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Rebluff Poker, no limit hold'em for loose aggressive players https://ift.tt/PiSNjXB

Show HN: Rebluff Poker, no limit hold'em for loose aggressive players Hello, I'm uberf1sh, software engineer (I've previously worked for Amazon and Fortnite, though obviously none of the following as to do with my previous employers). My cousin introduced me to online poker in 2008 and I loved it instantly, playing $2 games for fun and glory (the same day my aunt also proceeded to warn me that "it all starts like that", oh boy if you knew Tata). I was initially pretty bad but I had fun. Indeed, in 2008 the game was really amazing because it was so chaotic and full of crazy plays, your blood was pumping before even sitting at the table. Fast forward I was able to make $1000 a day in vegas, spending everything on sneakers, restaurants and other unspeakable stuff (you know the drill, what happens in Vegas stays in Vegas). 5-8 years ago, things started to take a bad turn. The game slowly but surely became incredibly boring. Most regular players started to all adopt a ...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Test your shape rotation skills https://ift.tt/Yec8AEu

Show HN: Test your shape rotation skills Hi all, hope someone enjoys (or not) my weekend project. See how many matching pairs you can find in two minutes. This is written in C++ and built to WebAssembly with Emscripten. The code is at https://ift.tt/Y3yTbfC https://ift.tt/zH7edbY February 21, 2022 at 01:19AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Newser, utility written in go to generate a pdf with news content https://ift.tt/8xHweTj

Show HN: Newser, utility written in go to generate a pdf with news content I've gotten myself a Supernote A5X (awesome device btw) and since it doesn't have a web browser or anything I've wanted to have a way to read news on it. I've hacked together this utility in a couple of days and it works wonders for me personally so I thought it might be interesting to others. It can also be used as a noise free newspaper generator as it removes images/ads/links and other noisy stuff. https://ift.tt/Su7EifL (there is a screenshot of the first page of the generated pdf) It scrapes (news) websites for content and puts it into a pdf. For me the pdf location is my dropbox supernote directory so my setup is to run this thing daily and have a fresh pdf with news whenever I want it. It's rough around the edges probably (currently added crawl support for verge, ars, engadget) but I think it's a good base so if anyone wants to contribute feel free. Some of the stuff I want to add ...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: ICON-3D Avatar Creator from 2D Pixels https://ift.tt/OoxI09m

Show HN: ICON-3D Avatar Creator from 2D Pixels Realistic virtual humans will play a central role in mixed and augmented reality, forming a critical foundation for the Metaverse and supporting remote presence, collaboration, education, and entertainment. To enable this, new tools are needed to easily create large-scale 3D virtual humans that can be readily animated. However, current methods need either posed 3D scans captured by expensive scanning equipment or 2D images with carefully controlled user poses. Both of them can't scale up easily. ICON ("Implicit Clothed humans Obtained from Normals") takes a step towards robust 3D clothed human reconstruction from in-the-wild images. This also enables creating animatable avatars directly from video with personalized and natural pose-dependent cloth deformation. Homepage: https://ift.tt/95W3hrO Github: https://ift.tt/78HVTuL Google Colab: https://ift.tt/EkRoK2b... https://ift.tt/78HVTuL February 20, 2022 at 04:32AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Statusping.co – Website Monitoring Service https://ift.tt/Vmyj9eL

Show HN: Statusping.co – Website Monitoring Service Hi everyone Just launched a website monitoring service https://statusping.co . It constantly monitors your website and notifies you whenever it is unavailable or returns an unexpected response. If it seems like something useful to you please try it out https://statusping.co and let me know if you have any questions, feedback or anything else :) https://statusping.co February 20, 2022 at 12:23AM
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Trilby for Hacker News – An Elegant Way to Experience HN on Android https://ift.tt/gEmCKqu

Show HN: Trilby for Hacker News – An Elegant Way to Experience HN on Android Fellow HNers, I just published a brand new Hacker News client for Android. This is my first mobile app ever, and I worked on this for the last two months. It features / lets you: Browse and read Hacker News - view popular and latest articles. Beautiful design and typography. Login to Hacker News, post new stories, comment and interact with others. Powerful search powered by Algolia, filter to get your desired results. View yours and others' profiles: see bio and latest activities. In-app web view when you don't want to leave the app. Personalize the app the way you want - select your favorite fonts. Compact Mode when you don't want any distractions. Meticulously crafted skins and comment themes, auto dark mode. Open native HN links within the app - look for the Orange links. Keep track of your read articles. View single comment threads. Preview your comment before posting/ ...and countless more. Yo...
Post a Comment
Read more https//reachsingh.blogspot.com»

Show HN: Simple method to create complex Excel formulas https://ift.tt/47qv6CL

Show HN: Simple method to create complex Excel formulas If I have trouble visualizing an excel formula in one cell on the fly, I use a trick to make it easier. Let's say I have the following cells | A | B | C | 1|mary| |Jane| In D1 I want to concatenate the cell values if the cell contains text. First I make a formula to check if the cell contains text somewhere in a cell on the sheet. Let us go with A6. A6: =ISTEXT(A1) result=TRUE ; Hooray! Then, if A6 is true, I want to display the text from A1 because I cannot concatenate "true" as I will be doing later on: A7: =IF(A6=true,A1,"") result=mary ; Yippy! I do the same thing for each cell: A8: =ISTEXT(B1) result=FALSE ; Sweet! A9: =IF(A8=true,B1,"") result=blank ; Thank goodness! A10: =ISTEXT(C1) result=TRUE ; Sweet! A11: =IF(A10=true,C1,"") result=jane ; Thank goodness! I know I am going to ultimately combine them with concatenate like so: A12: =CONCATENATE(A7," ",A9," ",A1...
Post a Comment
Read more https//reachsingh.blogspot.com»

Free Muni and Cable Car Rides for the Lunar New Year Weekend

Free Muni and Cable Car Rides for the Lunar New Year Weekend By Stephen Chun In partnership with Supervisors Chan, Peskin and Preston, the SFMTA will be offering free Muni rides for the Lunar New Year weekend and festivities. Complimentary service begins Saturday, Feb. 19 at 5 a.m. to Monday, Feb. 21 at 5 a.m. This includes free rides on our historic cable cars, a beloved attraction for regional visitors providing them direct access to the Chinatown community and the weekend’s Lunar New Year festivities.   Additionally, for the remainder of February, thanks to the leadership of Supervisors Chan and Peskin and their generous funding allocation, the SFMTA, Rec/Park and the Portsmouth Square Garage Authority will be providing validation for two hours of free parking at the Portsmouth Square Garage.   The SFMTA is excited to be rolling out both programs to support the city’s economic recovery including for the Chinatown neighborhood and businesses’ vibrant culture and vitalit...
Post a Comment
Read more https//reachsingh.blogspot.com»