4 ms·

You could bisect the sheet. Bisection would be fastest algorithm to identify the "bug". Bisection would be to split the sheet into half and half into new files

You could bisect the sheet. Bisection would be fastest algorithm to identify the "bug". Bisection would be to split the sheet into half and half into new files. Split the offending sheet further and so no on until you identify the offending entry. This method should work even if more than one vendor/ row has a problem - you bisect the parts which are bad and keep doing it until there is only one record. Note: This assumes that Google scans consistently and immediately the same way immediately each file -- Important Note: Your ToS violation notice may become a suspension if more than one violation is tagged to your account. Knowing Google's support quality I wouldn't personally risk my Google account and would move the entire file contents to say Notion which perhaps is more suited tool for this kind of planning .

ryandrake 4y ago
> Important Note: Your ToS violation notice may become a suspension if more than one violation is tagged to your account. Given the near weekly “My account was suspended without recourse and I lost everything” HN articles, surely OP is not using their main, personal Google account that they are dependent on for things like E-mail, right? Right?? Be careful and have a backup plan.
- deathanatos 4y ago
  > Given the near weekly “My account was suspended without recourse and I lost everything” HN articles, surely OP is not using their main, personal Google account that they are dependent on for things like E-mail, right? Right?? "They say most wrecks happen within a mile of home, so we moved." … whatever account I use for email is the account I use for email. Perhaps, yes, I could abandon Google. It's just like, I'd like to spend my life living. Sadly my personal server is down due to parts failure at the moment.
- throwaway290 4y ago
  > surely OP is not using their main, personal Google account that they are dependent on for things like E-mail If you can accidentally have a file that violates TOS, surely you can also accidentally send an email that violates TOS.
Animats 4y ago
We've reached the point that being a Google user is like hiding from the secret police. (I was never into Google services that required a login, and that turns out to have been a good decision.)

ryandrake 4y ago

> Important Note: Your ToS violation notice may become a suspension if more than one violation is tagged to your account. Given the near weekly “My account was suspended without recourse and I lost everything” HN articles, surely OP is not using their main, personal Google account that they are dependent on for things like E-mail, right? Right?? Be careful and have a backup plan.

deathanatos 4y ago
> Given the near weekly “My account was suspended without recourse and I lost everything” HN articles, surely OP is not using their main, personal Google account that they are dependent on for things like E-mail, right? Right?? "They say most wrecks happen within a mile of home, so we moved." … whatever account I use for email is the account I use for email. Perhaps, yes, I could abandon Google. It's just like, I'd like to spend my life living. Sadly my personal server is down due to parts failure at the moment.
throwaway290 4y ago
> surely OP is not using their main, personal Google account that they are dependent on for things like E-mail If you can accidentally have a file that violates TOS, surely you can also accidentally send an email that violates TOS.

Animats 4y ago

We've reached the point that being a Google user is like hiding from the secret police. (I was never into Google services that required a login, and that turns out to have been a good decision.)