Numbers is frying my brain cells. What do I do now???

-

helpful hints have found thread...

data validation

alternative data validation in excel can use of pop menus described in video. add values of in menu under cell > data format > pop menu.

https://www.youtube.com/watch?v=yhibizt1j1o

personally, i'd see apple make more intuitive allowing select set of values can used in pop menu.

---------------------------------------------------------------------------------------------------------------------------

well, i'm in required freshman engineering class , we're learning "excel." first week of class practiced basic functions such as:

  • cell addressing
  • common math/trig/stat fcns.
  • errors
  • data lookup

fast forward today, , go class feeling confident, knowing can done in excel can somehow replicated in numbers.

until professor started talk data validation...

goes excel menu bar , used d.v. options distribute cell data or (i can't remember, because teaching busy searching apple discussion forum equivalent). sit there , remain confused, , it's not i'm going ask him how do when i'm

  1. using numbers
  2. confused heck anyway

did better before got worse however. used pre-made excel workbooks create scatter plots , bar graphs. the problem had there not being secondary axis option when had 2 series different scales.

gets bad. had sheet 2 tables, data create scatter plot single point. idea show projectile's trajectory using projectile equation (from physics). professor goes options menu of excel , enables "iterative calculations." class coming close , knew screwed. frantically searched , found thread on apple forums saying "a circular reference error," , numbers can't solve problem. that's when hit me if numbers can't substitute program may have ditch it...

bottom line is, see classic "simplify program @ expense of features" complaint showing in class. it's pretty inconvenient , embarrassing apple, company market cap of $1t have such stripped out program basic functions.

---------------------------------

have suggestions on how fix issues, if possible? recommend me buying excel?
 

libre office includes refs "iterative references in spreadsheets" , "validity of cell contents". might give app shot. i've never used either feature, guarantee nothing.
 


Forums Macs Mac Apps and Mac App Store


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

Comments

Post a Comment

Popular posts from this blog

Pasco WA. Cops Killing A Homeless Man while running away

-
Image
can't put video guess threw few rocks ran away shot him while running away , turning hands out beg mercy. http://www.foxnews.com/us/2015/02/1...s-with-rocks-before-police-used-deadly-force/ video footage of police gunning down 35-year-old homeless man on february 10, 2015 shows man hands in air, attempting surrender, moments before police fired multiple shots, ending life. fourth time in 6 months, police in pasco, washington used lethal force against citizen. latest shooting victim, antonio zambrano-montes leaves behind 2 teenage daughters, father suffering depression after being separated them unknown reasons. video, credited dario zuniga, uploaded youtube ceeloc187 on wednesday, february 11. shows zambrano-montes toss stone @ police officers, turn , begin run away. series of gun shots can heard man tries flee. police pursue him across street in front of crowd of witnesses, gunning him down on sidewalk, raises arms above head in obvious...
Read more

Gold Apple Watch Buyers to Get Special Purchasing Experience With 30 Minute Appointments

-
Image
of april 10, apple begin scheduling appointments in retail stores customers interested in trying on apple watch before deciding pre-order or make purchase. we've known try-on appointments scheduled in 15-minute intervals allow apple employees many customers possible, seems customers interested in purchasing gold apple watch edition time device. according international business times , 2 apple stores in manhattan have confirmed customers looking spend upwards of $10,000 on apple watch edition 30 minute appointments apple employees instead of 15 minute appointments. ​ given high price of apple watch edition, it's no surprise employees plan dedicate more time plan spend lot of money, it's bigger purchasing decision. in fact, purchasing experience gold apple watch may quite bit different experience purchasing standard apple watch or apple watch sport, apple said have dedicated group of employees have undergone special training ser...
Read more

Transferring URLS

-
i wondering peoples' method transferring link between iphone , computer , vice versa. say, example, you're using website on mac , you'd transfer iphone view. how it? copy paste url facebook thought surely else has devised quicker means...   i use app called pocket.. it's available ios , os x. i'm not sure if there native client pc can add url pocket within modern web browser. and, pocket lets keep url's in list until remove them. more information can found @ https://getpocket.com   Forums iPhone, iPad, and iPod Touch iOS iOS 8 iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes Apple ID iCloud Desktop Computers Apple Music Professional Applications iPod iWor...
Read more