tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_shapiro__32163__CE2 Pack Template 2506 (FINAL VERSION)
Sheet: Allocations

 | Q1 Restated Allocations | Q1 Restated Allocations | Q1 Restated Allocations |  |  | Q2 Allocations | Q2 Allocations | Q2 Allocations
 | Government Affairs Total | % of Total Support | Headcount |  |  | Government Affairs Total | % of Total Support | Headcount
Government Affairs Total Direct Cost | 1375365 |  | 19 | 1.000001884577186 |  |  |  | 19 |  | 1
Commercial Allocations
UK region |  |  |  | 0.2030000584218928 |  |  |  |  |  | 0.1920001017321913
Continental region |  |  |  | 0.5730009818647137 |  |  |  |  |  | 0.6950001974407661
Scandinavia |  |  |  | 0.01600006030646994 |  |  |  |  |  | 0.00999987283476082
EnCom / Epower |  |  |  | 0.1000003769154371 |  |  | 0 |  |  | 0
EES @ 50% |  |  |  | 0.005999551470629806 |  |  |  |  |  | 0.005000271062746676
Non-Allocated Executive |  |  |  | 0.04000015076617486 |  |  |  |  |  | 0.03599980992143196
Enron Europe Total |  |  |  | 0.9380011797453183 |  |  |  |  |  | 0.9380002529918969
Recharge (Other) |  |  |  |  |  |  |  |  |  | 0.02300017602346266
EES @ 50% |  |  |  | 0.005999080326333385 |  |  |  |  |  | 0.00499993641738041
EBS |  |  |  | 0.05599973992834838 |  |  |  |  |  | 0.03399963456726004
Non-Enron Europe Total |  |  |  | 0.06199882025468176 |  |  |  |  |  | 0.0619997470081031
TOTAL ALL REGIONS |  |  |  | 1 |  |  |  |  |  | 1
 | 1375365 |  | 19 |  |  | 2125862 |  | 19
Non-Allocated Executive
This is running at around 4% each month. These includes approx 8 hours per month management time for each of the 4 cost centres heads (ie 32 hours per month total).
This also includes some continuing costs for [NAME] (rental Q2), which will cease in Q3.
Timesheeting has improved significantly over the first two quarters.
Spreadsheet: 699070d1602379012-lookup-data-from-separate-sheet-based-on-rpt-number-and-ignore-blanks-excel-help-file
Sheet: time dist

REPORT # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
CEMENTING |  | 2
CHANGE OUT BHA | 1 |  | 1
CIRCULATING
[NAME] |  |  |  | 4
DRILLING | 6 | 4 | 16 | 12
FISHING
FIT TEST
OTHER
RIG DOWN | 0
RIG SERVICE |  |  | 1
RIG UP | 16
RIG UP BOP |  | 6
RUNNING CASING |  | 6 |  | 8
SAFETY MEETING
STUCK PIPE
TEST BOP |  | 6
TRIPPING IN | 1 |  | 3
TRIPPING OUT |  |  | 3
WAIT ON CEMENT
WAITING ON ORDERS
WIRELINE
TOTAL DAILY
Spreadsheet: sally_beck__36248__West PG&E Deal Sum by Desk
Sheet: _tmp_9845_EPMI-ST-NW_deal_sum

 |  |  |  |  |  |  | ENRON POW | ER TRADING & | [NAME] |  |  |  |  |  | Run Date | :       04/06 | /01
Report Da | te:  04/06/01 |  |  |  |  |  |  | Deal [NAME] | y |  |  |  |  |  | Run Time | :       18:45 | :03
Post ID: | 9845
Desk: EPM | I-ST-NW
 |  | Trade | Start | End |  |  |  |  |  |  |  |  |  | Current |  |  |  | Prior Day | Prior
Deal | Counter | Date | Date | Date | Anty | Delivery | PV'd | Swap Vol | PV'd | Option Vol | Notional | Deal Vol |  | Deal | MTM P/L |  | LTD | Hedge | Day
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | Y/N | Point | Peak | [NAME] | Peak | [NAME] | Peak | [NAME] | Price Mid | Basis Mid | Total Mid | Prudent | Liquidations | Management | Liquidations
--------- | ------------------ | -------- | -------- | -------- | ---- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ---------------- | --------------- | -------------
554081 | PGEENEPOWLP | 2001-03-19 00:00:00 | 2001-05-01 00:00:00 | 2001-05-31 00:00:00 | No | NP-15 | 10295 | 0 | 0 | 0 | 10400 | 0 | 175015 | 0 | 175015 | 173985 |  | -51447 | 0
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R10 |  |  |  |  |  | 10295 | 0 | 0 | 0 | 10400 | 0 | 175015 | 0 | 175015 | 173985 |  | -51447 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
551200 | PGEENEPOWLP | 2001-03-15 00:00:00 | 2001-06-01 00:00:00 | 2001-06-30 00:00:00 | No | MID COLUMBIA | -10257 | 0 | 0 | 0 | -10400 | 0 | -994905 | 0 | -994905 | -994905 |  | 102416 | 0
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R9 |  |  |  |  |  | -10257 | 0 | 0 | 0 | -10400 | 0 | -994905 | 0 | -994905 | -994905 |  | 102416 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Total Pow | er Price Book |  |  |  |  |  | 38 | 0 | 0 | 0 | 0 | 0 | -819890 | 0 | -819890 | -820920 |  | 50969 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Spreadsheet: 788074d1658248957-count-of-cell-highlighting-over-multiple-columns-per-name-count-of-red-highlights-per-name-alligw
Sheet: Result

Name | Count of Red Highlighted Cells
Emma
Anna
Nina
Sara
[NAME]
Elena
[NAME]
Giulia
Stella
Anouk
[NAME]
[NAME]
Elin
Elina
Emily
[NAME]
[NAME]
Sofia
Chiara
[NAME]
Liv
[NAME]
Valentina
Yara
Alessia
Alexandra
Alina
Charlotte
Emilie
Eva
[NAME]
Isabelle
Lilly
Luisa
Mara
[NAME]
Selina
Tamara
Zoé
Setareh
[NAME]
Shangavi
Shanila
Shaniqua
[NAME]
Shannon
Shashvina
Shaymaa
[NAME]
Shaynah
[NAME]
Shejla
Shenuki
[NAME]
Shiloh
Amina
Andrina
Annabelle
Annika
Bracha
Aurelia
Ava
Carlotta
Céline
Chloé
[NAME]
Liya
Lorena
Luciana
[NAME]
[NAME]
Marina
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Meret
Naila
Noa
[NAME]
Paulina
Rahel
[NAME]
[NAME]
Salomé
Sofía
Sofija
Valeria
Yasmin
Zoe
[NAME]
[NAME]
[NAME]
[NAME]
Alena
[NAME]
[NAME]
Amalia
[NAME]
Anika
Anisa
Anissa
[NAME]
Antonia
Ariane
[NAME]
Aura
[NAME]
Ayla
Belma
[NAME]
Catarina
Cecilia
Chaya
Chayenne
Colette
Defne
Dunja
Eileen
Eléni
[NAME]
Estelle
Esther
Fabienne
Fay
Irina
Jaël
Jelena
[NAME]
Line
[NAME]
Rebekka
Rhea
Riona
Rita
Vanja
Victoria
Viktoria
[NAME]
[NAME]
Yasmine
[NAME]
Aakavi
Aaliyah
Aileen
[NAME]
[NAME]
Aimy
Aisha
Aita
Aiyana
Alyssia
Amalia-Rose
Amanda
Amandine
Amane
Amani
Amaya
Amber
Ambra
Amelia
Amila
Artina
[NAME]
[NAME]
Ashmitha
Asude
[NAME]
Aulona
Aurélie
Avigail
Aviya
[NAME]
Axelin
Ayana
Ayleen
[NAME]
Aysu
Azel
Azra
Bavidha
[NAME]
Bejda
[NAME]
[NAME]
Berfin
Beverly
Beyzanur
Bianca
Blinera
[NAME]
Brittany
Bruna
Buna
Buratha
[NAME]
Camilla
Carina
Carlina
Carmel
Carmela
Caroline
[NAME]
Cassie
Caterina
Catharina
Cécile
Celeste
Cheimaa
Chloe
Chloë
Christina
[NAME]
Clare
Diola
Diona
[NAME]
Dominika
Dorela
Elda
Eldina
Elfie
Elida
Elif
Eline
Elischewa
Elise
Elisena
Elle
Elle-Morgane
Elli
Ellie
Ellis
Élodie
Eloisa
Estere
[NAME]
Eugenia
Eva-Luna
Evangeline
Eve
[NAME]
Evelyne
Evin
[NAME]
Eidi
Elá
Elainne
[NAME]
Haticenur
Haxhere
Helen
Helene
[NAME]
Hina
Hind
[NAME]
Iiris
Ilarja
Ilayla
Ivy
Jadanan
Jade
[NAME]
Jamelia
Jamelle
Jamila
[NAME]
Jornelly
Josefa
[NAME]
Josephina
[NAME]
Joséphine
Josra
Keira
[NAME]
Kemelin
[NAME]
Kerschma
Keysha
[NAME]
Kiana
[NAME]
Kishajini
Leena
[NAME]
[NAME]
[NAME]
Liina
Liis
Lilia
Liliana
Lilja
[NAME]
Lilo
[NAME]
[NAME]
[NAME]
Linnea
Linoa
Lira
Lirinesa
[NAME]
[NAME]
Loan
[NAME]
[NAME]
Lorin
[NAME]
Lorinda
[NAME]
Lorisa
Lotta
Louine
Lova
Luanda
Lucía
[NAME]
Luzia
Luzie
[NAME]
[NAME]
Lydia
Lyn
[NAME]
[NAME]
[NAME]
[NAME]
Magalie
Magdalena
Mahault
Mahima
Mahisa
Mahlet
Maibert
Maïmouna
Maira
[NAME]
Elvira
[NAME]
Emel
Emilija
Endry
Enea
Enni
Enya
Eriona
Eslem
Masa
Mathilde
Matilde
Nadja
Naemi
Naida
Naira
Naja
Nashota
Nastasia
Nastasja
Natalia
Nathalie
Naya
Nila
Niobe
Nirina
Nithusa
[NAME]
Nivetha
Noée
[NAME]
Noëlle
Perel
Perl
Semina
Senay
Senia
Serena
[NAME]
Shkurte
Shukri
Sidra
Spreadsheet: rick_buy__32727__0820_Violation
Sheet: Sheet1

 | To: |  | [NAME], [NAME] and [NAME]
 | Copy to: |  | Distribution
 | From: |  | Global Risk Management Operations
 | Date: |  | 2001-08-21 00:00:00
 | Re: |  | Limit Violations and Notifications for August 20, 2001
 |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  | Violation/
 |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  | ($MMs) |  |  |  |  |  | ($MMs) |  | ($MMs)
1 | Enron Americas |  | Gas Trading | B |  | 200 Bcf | Maturity Gap Risk | (370) Bcf | 50 |  | -58666 |  | 624524 |  |  | The Maturity Gap Risk violation is driven by short fixed price positions in the three month period between March 2002 and May 2002. The Financial Desk is carrying the majority of those positions, (344) Bcf, between March 2002 and May 2002.
2 | Enron Global Markets |  | EOL 24/7 Crude Trading | B |  | 2 Mil Bbl WTI | Net Open Position | (2.99) Mil Bbl WTI | 26 |  | -2313 |  | -30754 |  |  | Due to the $3 September 2001 price increase since July 19, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
3 | Enron Global Markets |  | EOL 24/7 Crude Trading | B | $3 MM |  | Daily Loss | ($3.3) MM | 11 |  | -2313 |  | -30754 |  |  | The Crude EOL one day loss limit resulted from a 3.4 million bbl short position on 8/17 and the front month WTI contract was up $.50/bbl on 8/20 and counterparties buying as the market was rising, leaving the portfolio with at $1.4 million new deal loss.
 | B= Business Unit Violation |  | C= Concentration Violation
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 287680d1388939840-locking-2-rows-then-sorting-by-column-2011-sales
Sheet: Pivot

 |  | Rank All | Customer | Year | Sum of Sales
 |  | 1 | BBB | 2011 | 9200
 |  | 1 | BBB | 2010 | 9000
 |  | 2 | CCC | 2011 | 9100
 |  | 2 | CCC | 2010 | 3200
 |  | 3 | EEE | 2011 | 6700
 |  | 3 | EEE | 2010 | 4800
 |  | 4 | AAA | 2011 | 4500
 |  | 4 | AAA | 2010 | 4000
 |  | 5 | DDD | 2011 | 2600
 |  | 5 | DDD | 2010 | 8400
 |  | Grand Total |  |  | 61500
Spreadsheet: c6d57b3d-f65a-4110-a0de-a729c8690f54
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Ellis | Marjorie | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Thompson | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Vacant |  | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | Cameron | Helene | [EMAIL] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Edwards | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Hembrick | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Bullock | Marcy | [EMAIL] | [PHONE] |  | Patterson Hall 111 | Box 7642 | Raleigh | NC | 27695-7642
UNC Asheville | Vacant |  |  | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Payne | [NAME] | [EMAIL] | [PHONE] |  | 211 Carr Building | CB #5000 | Chapel Hill | NC | 27599-5000
UNC Charlotte |  |  |  |  |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | [NAME] 26170 |  | Greensboro | NC | 27402-6170
UNC Pembroke | Pruett | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Rakes | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts |  |  |  |  |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | [NAME] | [NAME] | [EMAIL] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Sloan | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 675412d1588273052-mutiple-dependent-drop-down-menus-example_dependent_dropdowns
Sheet: Lists

Name |  | Quantity
Spreadsheet: 022e4759-a666-407d-8de0-74b32c4c5ea3
Sheet: tblTask

SiteID | ClaimID | ApplID | TaskID | ReqAmttsk | AppdAmttsk | RedNote
 |  |  | -1
 |  |  | 0
Spreadsheet: 49749d1249061705-vlookup-functions-example
Sheet: Main Pricing Sheet

Part Name | Part Number | Package Type | Supplier A | Supplier B
101 | AB | Bag
101 | AB | Box
102 | AC | Bag
102 | AC | Box
103 | AD | Bag
103 | AD | Box
104 | AE | Bag
104 | AE | Box
Spreadsheet: 108904d1305834131-to-find-the-latest-date-example002
Sheet: List

Magazine ID | DateTime | Registered by: | Clean | Cleaning Date | Balance day(s) before next cleaning | Cleaned by: |  | If not using 2003 put this formula in Column F |  |  | (Not required) The latest date/time
AAA | 2011-05-19 08:49:38 | 15894 | a | 2011-05-11 08:50:12 | -1 | 12345 |  | -1 |  |  | 2011-05-11 08:50:12
BBB | 2011-05-19 08:49:39 | 15894
CCC | 2011-05-19 08:49:40 | 15894
GGG | 2011-05-19 08:49:57 | 15888
AAA | 2011-05-19 08:50:22 | 14777
Spreadsheet: 848695d1699364875-end-date-and-time-calculaton-end-date-and-time-calculation
Sheet: Process

 | End Date and time calculation
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Start date time | 2023-11-03 11:22:36 |  |  | Input cells
 | Hour from start time |  |  |  | Result
 | Work day start | 08:00:00
 | Work day end | 17:00:00
 | Work hours per day
 | Work duration [hours] | 15
 | Work duration
 | Work duration in days
 | Residual hours
 | Ending hour excede 17:00?
 | Work duration in days corrected
 | Resigual hours corrected
 | Hour from start time corrected
 | End date time
Spreadsheet: 020ef2c5-127c-4310-ac07-02503e18f2f5
Sheet: Sheet1

Library web server <http://www.library.uri.edu/> | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Statistics
1998-1999
DIRECTORY | 1998-07-01 00:00:00 | 1998-08-01 00:00:00 | 1998-09-01 00:00:00 | 1998-10-01 00:00:00 | 1998-11-01 00:00:00 | 1998-12-01 00:00:00 | 1999-01-01 00:00:00 | 1999-02-01 00:00:00 | 1999-03-01 00:00:00 | 1999-04-01 00:00:00 | 1999-05-01 00:00:00 | 1999-06-01 00:00:00 | ANNUAL TOTAL
Total requests* | 26461 | 17029 | 45669 | 67898 | 71607 | 51684 | 36281 | 65222 | 75782 | 68567 | 42573 | 39004 | 607777
Total page requests* | 24175 | 15907 | 43265 | 66364 | 69427 | 50183 | 35118 | 64045 | 85672 | 67152 | 41070 | 37031 | 599409
Total visits* | 10780 | 7313 | 18105 | 27416 | 28350 | 22591 | 16849 | 27834 | 26070 | 25548 | 17132 | 16127 | 244115
Total visitors* | 2894 | 2244 | 3193 | 5247 | 5699 | 4867 | 4344 | 5570 | 6425 | 4967 | 4559 | 3863 | 53872
Average time per visit (seconds) | 132.79 | 127.33 | 169.51 | 158.17 | 157.52 | 151.49 | 133.3 | 149.11 | 131.81 | 349.26 | 346.19 | 310.9 | 193.115
Busiest day of week | Wed | Mon | Wed | Thur | Mon | [NAME] | [NAME] | [NAME] | Wed | [NAME] | Mon | Wed | Tues/Wed
Peak hours | 3pm - 10pm | 1pm - 4pm | 10am - 4pm | 10am - 3pm | 10am - 5pm | 10am - 4pm | 10am - 4pm | 10am - 5pm | 10am - 5pm | 10am - 5pm | 9am - 5 pm | 10am - 5pm
Average response delay | 41.77 | 42.5 | 46.05 | 41.9 | 42.22 | 33.03 | 36.05 | 36.28 | 60.7 | 28.73 | 26.47 | 30.95 | 38.8875
Most popular URL | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage | Homepage
Second most popular URL | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu | Database Menu
Third most popular URL | Internet Search Tools | Internet Search Tools | Gen/Ref Menu | Gen/Ref Menu | Gen/Ref Menu | Internet Search Tools | Internet Search Tools | Gen/Ref per index menu | Gen/Ref per index menu | Gen/Ref per index menu | Internet Search Tools | Internet Search Tools | Internet Search Tools
* March and April files may contain inaccuracies. Log files were deleted in March 1999, possibly by a hacker. April statistics began on the 6th of the month.
Spreadsheet: 749071d1632493516-sort-by-column-in-one-sheet-and-maintain-row-formula-references-in-another-sheet-test-metrics
Sheet: Feb

ISP | Hours Worked | Avg. ACD Talk Time | Auto-In Calls | Top Line Calls | Outbound Calls | Total Calls | Avg. Calls/Hour | ISP Emails | Clearslide Email Campaigns | Avg. Emails/Hour | Webinars Conducted | SF Leads Created | Avg. Hourly Work Volume | SF Tasks w/out Clearslide | SF Opp. | Total SF | Avg. SF/Hour | Clearslide Emails Sent | Total Contacts | Avg. Contacts/Hour
a | 152.25 | 04:16:00 | 91 | 60 | 103 |  |  |  | 0 |  | 0 | 9 |  | 334 | 57 |  |  | 0
b | 160 | 04:42:00 | 105 | 126 | 119 |  |  |  | 2 |  | 0 | 2 |  | 370 | 51 |  |  | 128
c | 160.5 | 06:08:00 | 88 | 151 | 144 |  |  |  | 0 |  | 3 | 15 |  | 502 | 36 |  |  | 0
Spreadsheet: 681595d1591653165-vlookup-with-wildcards-vlookup
Sheet: My Question

VIP Personnel | Job Title
 | West Africa Regional Director
 | Vice President
 | UHC2030 |  |  | SEARCH: | RETURN:
 | Tutor |  |  | CEO | True
 | Technical Officer, Country Strategy & Support |  |  | Chief Executive Officer | True |  | What forumal can I put in A2:25 that will search for values E5:18 in B2:25?
 | Technical Officer |  |  | Founder | True
 | Technical Advisor on Global Health |  |  | Director | True
 | Team Leader |  |  | Fellow | True
 | Teacher |  |  | President | True
 | Summer Research Student |  |  | Vice President | True
 | Student |  |  | Owner | True
 | Student |  |  | MD | True
 | Student |  |  | Managing Director | True
 | Student |  |  | Executive | True
 | Student |  |  | ED | True
 | Student |  |  | Chief | True
 | student |  |  | Board | True
 | Student
 | Sr. Director
 | Specialist Schistosomiasis Elimination Program
 | Senior Writer
 | Senior Vice President, Global Health & Corporate Responsibility
 | Senior Technical Advisor
 | Senior public health and pharmaceutical expert
Spreadsheet: 641c78b7-bf05-4b08-8381-3e415c6ac774
Sheet: J-Term 2013

Enrolled | Course | Professor | Title | Author | Price |  | O/H
6 | 1.277 Women in the N.T. | [NAME] | The Women's Bible Commentary | [NAME] | 42.5 | 9780664237073 | 1
 |  |  | Back to the Well | [NAME] | 16.95 | 9780664227159 | 1
 |  |  | A Feminist Intro to [NAME] | [NAME] | 16.95 | 9780827210370 | 0
 | 3.177  Biblical Economics & Stewardship | [NAME] | CANCELLED
3 | 2.409  World Christianity | [NAME] | Whos Religion is Christianity | [NAME] | 9.6 | 9780802821645 | 4
 |  |  | [NAME] | [NAME] | 22.05 | 9780631236207 | 0
31 | 3.700  Introduction to Preaching | [NAME] | The Four Pages of the Sermon |  | 22.95 | 9780687023950 | 2
 |  |  | Preaching Law & Gospel |  | 12.75 | 9780962364228 | 8
20 | 3.722  Preaching & Pastoral Care | [NAME] | The Christian Life | [NAME] | 33.25 | 9780806670140 | 2
 |  |  | What Makes this Day Different | [NAME] | 12.75 | 9781561011568 | 1
 |  |  | Accompany Them with Singing | [NAME] | 21.2 | 9780664233198 | 0
 |  |  | Preaching the Wedding Sermon | [NAME] | 13.6 | 9780827229600 | 2
 |  | Recommended | ELW - Leader's Edition |  | 42.75 | 9780806656205 | 3
 |  |  | ELW - Pastoral Care Vol. 1 |  | 39 | 9780806653921 | 4
17 | 4.204 Diaconal Ministry Formation Event | [NAME] | Life Together | [NAME] | 11.75 | 9780060608521 | 11
 |  |  | From Word to Sacrament | [NAME] | 19.4 | 9786000111137 | 3
 |  |  | [NAME] | [NAME] | 12.75 | 9780664229474 | 8
6 | 4.312 Central American Study Tour | Cooper-White/Erling | No Books
12 | 4.301 Multicultural Unit | [NAME] | The Wolf Shall Dwell with the Lamb | [NAME] | 17.25 | 9780827242319 | 0
12 | 4.301-06    The Socio-Cultural Roots | [NAME] | The Wolf Shall Dwell with the Lamb | [NAME] | 17.25 | 9780827242319 | 0
 | of [NAME] |  | There is a [NAME] in Gilead | [NAME] | 21.25 | 9780800624576 | 2
 |  |  | I Have a Dream: MLK | [NAME], [NAME]. | 12.95 | 9780800636852 | 1
8 | 4.401  Religion and 21st Century Media | [NAME] Staff | The Platform | [NAME] | 24.99 | 9781595555038 | 0
 |  |  | Tweet if You Heart Jesus | [NAME] | 20 | 9780819224231 | 0
 |  |  | Click 2 Save | [NAME] | 20 | 9780819227744 | 0
 |  |  | When Religion Meets New Media | [NAME] | 39.95 | 9780415349574 | 0 | Recommended
 |  |  | Viral | [NAME] | 14.95 | 9780307459152 | 0 | Recommended
 | 12.600  Theological Ethics | [NAME] | No Books
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 5Inter O&M Entry

Intermittent O&M Costs Input
Alternative:
For each component, enter "Y" in the gray area in the year in which replacement, if any, will occur.
 |  |  |  |  |  |  |  | Year O&M Needed?  (Insert Y in year where O&M is needed.)
Component | Unit Cost | Unit | Quantity | Replacement Needed? (Years 1-5) | Replacement Needed? (Years 6-10) | Replacement Needed (Years 11-15) | Replacement Needed? (Years 16-20) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Spreadsheet: 684796d1593538470-indirect-function-looking-for-worksheet-named-after-current-year-newsample
Sheet: Summary

 |  |  |  |  |  |  | Trying to eliminate sheet1 by referencing the worksheet with the matching year. For this formula, I'm wanting to reference the current year.
 |  |  |  |  |  |  | I've edited the $ amounts on the newer table to reflect different amounts…
 | [NAME] |  | column2 | column3
 | sheet2 |  |  | 2020-07-01 00:00:00 |  | <--- original formula works when pointing to old worksheet
 | sheet2 |  |  | 2020-06-28 00:00:00 |  | <--- proposed formula works because the due date is today
 | sheet2 |  |  | 2020-07-01 00:00:00 |  | <--- proposed formula still works because the due date is next month
 | sheet2 |  |  | 2020-06-29 00:00:00 |  | <--- proposed formula does not work when due date is in the current month.
 |  |  |  |  |  | past date used to illustrate issue.
 |  |  |  |  |  | cell [NAME] should be displaying $7 because that is the amount due on the next due date.
 |  |  |  | Working samples of my indirect usage are in cells B14 and I14:[NAME]
 |  | <---SUM(INDIRECT(YEAR(TODAY())&"!text")) |  |  |  |  | 2019 |  | <----INDIRECT("'"&H14&"'!Total")
 |  |  |  |  |  |  |  |  | <----INDIRECT("'"&H15&"'!Total")
 |  |  |  |  |  | [NAME] in column 2 references sheet1 currently
 |  |  |  |  |  | cell [NAME])
 |  |  |  |  |  | I want it to dynamically reference the table on the worksheet that = the current year, using the INDIRECT function
 |  |  |  |  |  | Note: the table location is different than it was on sheet1. it is now [NAME]:AD18