AutoSave
кабинка-b579092afc42381cbbacf401
Home

Clipboard

Paste
Font

Copy, cut, and paste visible cells from the current selection and active cell.

Clipboard
Главная

Шрифт

Абзац

Font, size, colour and borders apply to the current visible selection.

Шрифт
Главная

Выравнивание

Alignment applies to the current visible selection. Extended print layout and automatic row/column resizing remain separate tasks.

Выравнивание
Главная

Перенос и объединение

Wrap

Wrap, shrink to fit and merge apply to the current visible selection; extended print layout remains a separate task.

Перенос и объединение
Home

Number

Number

Basic number, percentage, currency, date, time, and text formats apply to the current visible selection.

Number
Главная

Стили

Conditional formatting applies visible styles to the selected numeric cells.

Стили
Главная

Ячейки

Ячейки

Insert, delete, hide, unhide and autofit work on the visible rows and columns of the current workbook.

Ячейки
Главная

Редактирование

Change Case: select a visible text cell.

Editing

Editing works on the visible cell, the formula bar, clear, cut, copy, paste and filling the selected range.

Редактирование
Paste
Clipboard
Font
Alignment
Paragraph
Cells
Number
Styles
Cells

Change Case: select a visible text cell.

Editing
A1

Choose data source

Choose a data source to connect through Power Query.

11 data sources

Рабочая область листа

Сетка, выделение и ввод работают в видимой области текущего листа.

kind=default-ltr-session-placeholder; workbook=ltr; active=ltr; writing=horizontal-tbНаправление листа применяется к текущему виду.

scope=active-sheet; families=comments-notes -> present -> legacy-vml-preserved-onlyОбъекты книги доступны только для просмотра.

count=6; objects=comments-notes -> placeholder | comments-notes -> placeholder | comments-notes -> placeholder | comments-notes -> placeholder | comments-notes -> placeholder | comments-notes -> placeholderlegacy note markers and read-only imported popup payloads claimed for preserved comments/notes anchors; other objects remain catalog only

Объекты книги6 visible object(s) on xl/worksheets/sheet1.xml; families=comments-notes=6; renderStates=marker=6; source=open_workbook_subset surfaceObjects for the current canvas path; safe=inspect metadata or return to cell; unavailable=object editing, resizing, moving, and chart editing

Выбранный объектowner=cell; selected=none; activeCell=xl/worksheets/sheet1.xml!R0C0; source=xl/worksheets/sheet1.xml; safe=select visible object to inspect or continue cell work; unavailable=object editing, resizing, moving, and chart editing; return=cell ownership active; no selected-object state retained

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
1DoneDue DateTaskNotes
2xJanuaryInvestigate venue costs. Talk with Ray about setting up registration Nov. 9th (the night before DUC). Check with Monica Dorme or Clark McLean about computer lab in ZimmermanContinue with CNM-WTC talk to Ray Garcia 224-5251; Start MOU
3XFebruaryTalk with Census about this years Data Users Conference. Start requesting speakers for topicsBarb said she would call the last week of Feb.
4MayFinalize MOU w/ CNM WTC
5XMayPreliminary Price Quote from Catering2750.71
6Summer 2016Work on Updates to the mailing list. Keep the Affiliates list up-to-date
7Summer 2016Book Denver Regional Office staff and talk to Tom Edwards at CLMSO/check in with Monica Dorme or Clark McLean about computer lab in ZimmermanCheck for conflicting meetings: NM Assoc of Cos, SBDC annual and quarterly meetings, NMLA, Local govt infrastructure (NM Muni League)
8June-JulyContact potential presenters - start presenters spreadsheetFinalize presenters end of July
9July 31Start this years Conference WebpagePost an update to the facebook page
10Aug 8Finalize agendasThis isn't realistically done until about the beginning of Septembertheir presentation, time slot, locations of both meetings,
11Aug 15-19Create BrochureConsider catering costs before setting conf registration costparking, hotels, registration counts, etc.
12Aug 15Finalize Credit Card App with titles for presentationsHave Patrick Patten move the app into production and add a link from the BBER webpage.
13Aug 15Check on catering costs before setting conf registration cost$55 early reg. 65 week prior, 75 day of…
14Aug 15Set next year's date (tentative)Consider August next year?
15Aug 22Order parking passes for affiliates workshop Get ASAP to mail to affiliates in time. See inserted comment on this cell. Send tickets to Census speakers home address as all mail gets radiated.
16Aug 29Reserve Student Union Buildingsub.unm.edu/event-planning/unm-departments.html list of SUB food options, restaurants in walking distance
17Aug 29Send brochure original to CG Printers in PDFSteven Garcia 883-8164 and cgprintersinc@aol.com Sent on 9-10-15
18Aug 29Call printer for quote (for mailing list of 800)
19Sept or OctGet extra copies for the FOR-UNM Meeting, extra copies of text for the bulletinMo sent out an e-mail marketing the conference to FOR-UNM subscribers.
20Sept or OctOrder sign for BBER to put on tableStarting price is 200 up to 600.
21Sept 5Post finalized DUC agenda and registration on the BBER web site. Census hasn't Confirmed all speakers. 9-10-15Send to affiliates by e-mail first
22Sept 9Send e-mail to affiliates w/link to Conference page
23Sept 12Start compiling packets for affiliates
24Sept 12Finalize mailing list for brochure mailing
25Sept 19Snail-mail affiliates agendas and registration formIncluded 10 brochures in each packet - Completed Oct 9th. When mailing packet (manilla envelopes) make sure to tape over metal tab
26Sept 26Send brochure and mailing list to Campus mailing
27Sept 27Press release to Steve Carr at UNM and UNM Today calendarDo press release first & then use a version of this as a narrative for the e-list contacts (below), enter our event on the UNM Today calendar
28Sept 28E-lists, Calendar postings, web postings, & broadcast e-mail contactsContacts include David Espey (health professionals), Dawn Kenney (X) (higher ed. Institutional researchers), Larry Compton (X) for NMLA/SLA, MFA, NM Dept. of Workforce Solutions (X)(Rachel Moskowitz for web posting and/or LMR ad), NM Econ. Devel. Dept.(X) (Beth Davis for broadcast e-mail), Main Street program (Jeff Mitchell)(X), SBDC network, Dely(X) (Asian org. network), Mike Ingles(X) (GAC/NMGIC)Move this up next year.
29Sept 29Place preliminary catering orderPlaced preliminary order for 165 on 10/4/12
30Sept 29Registration check 6 weeks out
31Sept 30Distribute 6 plackards on campusEcon Dept (front office ask Tami), Law Library (Ask reception), Health Sciences Library (pin in foyer), Zim Circulation (table by ATM), Parish (ask front desk), BBER main office (easier done with two people in one car)
32Sept 30Remind affiliates to register if they plan to attend. Send SDC/BIDC Affliiates list for correctionsAffiliates list will go in folders so should be updated beforehand.
33Sept 30Send Reminders to all speakersRequest PowerPoint and other matierials.
34Octoberwork on Data Bank PowerPoints, handouts and presentations.workup and place PowerPoints, evaluations, handouts, affiliates list, FOR-UNM marketing, NMB marketing, BBER marketing, etc.
35Oct 1Buy any supplies needed: colored paper, folders, business cards, extra ink for the color printer, nametagsWork with Debbie G. on this - for 2012 needed folders (7 boxes of 25), name badges (1 box of 100) and 2"x4" labels for folders. DO NOT WAIT ON THIS
36
37Oct 12e-mail parking instructions & maps to out-of-town presentersWhen mailing packet (manilla envelopes) make sure to tape over metal tab
38Oct 6Registration check 5 weeks outNote that as of 10/9/15 had 23 paying and 48 including speakers, comps, staff. For comparison, 10/10/14 the Conference had 25 registrations, 17 registered on 10/14/13, 21 registered on 10-11-12, had 14 in 2011 and 27 in 2010.
39Oct 7Print name tags for week 5 registrants
40Oct 13Remind Steve Carr about 2nd press release
41Oct 13Email BBER notification for conference
42Oct 13Registration check 4 weeks outNote that as of 10/23/15 had 40 paying and 52 including speakers. Comps, staff. For comparison , the Conference had 38 registered on 10/17/14, 36 registered 10/18/13, 37 registered on 10-17-12, had 43 this time in 2011
43Oct 14Print name tags for week 4 registrants
44Oct 20Registration check 3 weeks out - send counts to presentersHad 54 on 10/24/14, 54 on 10/25/13, 64 on 10-25-12, had 72 3 this time last year. Give attendance count update to presenters.
45Oct 22Print name tags for week 3 registrants
46Oct 22Review folder contents/materials/handoutsevaluation forms, Send to Elizabeth Davis?
47Oct 24Email BBER reminder notification for conference
48Oct 27Registration check 2 weeks outHad 71 on 10/31/14, 70 on 11/1/13, 93 on 11/1/12, 98 on 11/1/11
49Oct 28Melt Down DayCall informing that the Census Bureau Director would be attending.
50Oct 31Finalize catering order
51Oct 31Finalize conference set-up with number of registerations with Ray Garcia at CNM-WTC
52Nov 1Update and distribute emergency contact informationGive copy to Suzan, Guy, any others in key positions.
53Nov 1Call caterer for preliminary head count
54Nov 2-6Make and print attendance certificates for Workshop, include blanksPrint in color
55Nov 3Registration check 1 week out114 on 11-8-12 (had 126 this time last year) Give attendance count update to presenters
56Nov 6Stuff folders: business cards (Suzan/Jeff), agenda, flier for economic outlook conference, eval forms, save the date, NMB, FOR UNM, data bank informational flier, census fact sheet, NM data census profile sheet, bios160 folders: Agenda(), Bios(), Eval Forms(), FOR UNM (), DB info flyer(), Census quiz(), NMB(), Economic outlook conference(), save the date(make one), business cards ()
57Nov 6Send out a reminder e-mail to all attendees!
58Nov 6VISIT CONFERENCE CENTERRay Garcia
59Nov 6Print name tags for week 2 registrantsAfter this week, start printing as they are received
60Nov 7Library room check
61Nov 7Print our registration list for tablesDo
62Nov 8Buy workshop snacksmuffins, bottled water, chips, sodas, cookies
63Nov 8Pack boxes in car
64Nov 9AFFILIATES WORKSHOPTake handouts, name tags, certificates, snacks, lunch forms
65Nov 9Visit Conference Center after workshop; setup registration night before DUC(?).Check on table set up, talk to staff, check bathroom for paper towels
66Nov 9Suzan presentations copied
67Nov 9Conference staff meetingDistribute notes, roles, responsibilities, emergency numbers
68Nov 9Name tag quality checkShould have ALL affiliates, ALL presenters for both days, ALL BBER staff who plan to attend, and ALL registrants to date
69Nov 10DATA USERS CONFERENCETake supplies, tape signs, check set up, Stat Abstracts, folders, name tags, presentations, box with cords/tape/scissors/pens, coordinate help
70Nov 14Post presentations to BBER web site
71Nov 14th weekPick up plackards from campus locationsEcon Department, Anderson lobby, Zimmerman South entrance, Parish Librar, Law Library, Health and Science Library, Planning Department (Probably not here next year)
72Nov 14th weekThank you notes, certificatesSee thank you notes page in this file
73Nov 14th weekReconcile registrations with billing
74Nov 30Evaluate conference successes and difficulties
75Nov 30Check next year's date (tentative)Check for conflicting meetings: NM Assoc of Cos, SBDC annual and quarterly meetings, NMLA, Local govt infrastructure (NM Muni League),
76Dec 1Do next years schedule
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

Canvas grid keeps keyboard focus on the visible cell selection. Arrow keys move the active cell inside the visible window. Alt+Up/Down and bottom-bar buttons move through visible read-only surface objects. Escape returns from object selection to cells.

Sheets 12 листов | видимые вкладки
Task Sched Calendar -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified updated_truthfully
Task Sched Calendar -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified values_only_same_workbook_sheet no no no no no no live_verified unreferenced_bounded_sheet_only live_verified last_unreferenced_bounded_sheet_current_session save_reopen_after_restore_live blocked_truthful_boundary no live_verified same_workbook_sheet_order_only true no true live_verified same_workbook_visible_hidden_very_hidden live_verified blocked_truthful_boundary live_verified same_workbook_worksheet_sheetPr_tabColor_rgb live_verified same_workbook_worksheet_sheetPr_codeName live_verified same_workbook_unpassworded_sheetProtection_metadata no live_verified active_worksheet_cells_only_preserve_sheet_metadata no

Нижний shell показывает видимые вкладки книги. Переключение листов live только при host bridge; вставка листа остаётся non-live.

ReadyInsertingDeletingFittingOpeningSortingFiltering Cell mode
100 %