tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f4c6b38a-04bc-4ef1-9d10-94af2bcb930c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44356363 | 2014-12-08 11:53:20 | ALLIES | 0 | 5 | 6 | 55639 | Gigimat | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
44356451 | 2014-12-08 12:08:17 | AXIS | 1 | 6 | 3 | 55639 | Gigimat | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
44361197 | 2014-12-08 20:42:20 | ALLIES | 1 | 10 | 3 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44361755 | 2014-12-08 21:16:51 | AXIS | 1 | 10 | 6 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44452626 | 2014-12-15 09:36:09 | ALLIES | 1 | 6 | 3 | 1546936 | KATANA PAPA | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44452805 | 2014-12-15 10:03:18 | AXIS | 1 | 6 | 2 | 1546936 | KATANA PAPA | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44453290 | 2014-12-15 11:25:55 | ALLIES | 0 | 3 | 6 | 578329 | Valentin de Ramillies | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44453446 | 2014-12-15 12:03:54 | AXIS | 0 | 5 | 6 | 578329 | Valentin de Ramillies | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44458803 | 2014-12-15 21:00:34 | ALLIES | 1 | 5 | 3 | 580456 | JP [NAME] | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
44459209 | 2014-12-15 21:34:22 | AXIS | 0 | 3 | 5 | 580456 | JP [NAME] | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
Spreadsheet: 849173d1699692859-how-to-filter-list-of-timestamps-to-certain-time-periods-double-unury-usgae-aligw
Sheet: Sheet1

1
2 | 02 | 2 | 2
3 | 03 | 3 | 3
4 | 04 | 4 | 4
5 | 05 | 5 | 5
Spreadsheet: 68499d1269021411-excel-2007-removing-duplicates-with-a-condition-example-set
Sheet: Sheet1

Company | Phone | Fax | [NAME] | Name | Rating
Abgent | (858) 6220099 | (858) 622-0609
Abgent | (888) 7357227 | (858) 622-0609 | [EMAIL]
Abgent, Inc. | (858) 6220099 | (858) 622-0609
Abgent, Inc. | (888) 7357227 |  | [EMAIL]
Abhav | 12484700114
ABI/Precision Lighting | 7075856210
ABICOR Binzel Corp. | 3018464196 | [PHONE]
Abigraf Nacional |  | 55 11 3164-3184
Abilitations | 8008508602 | [PHONE] | [EMAIL]
Ability Commerce | 3207966245
Ability Commerce | 5613303151 | [PHONE]
Spreadsheet: 85047d1285116017-lookup-formula-to-find-first-time-a-value-is-less-than-corresponding-value-test
Sheet: Sheet1

Date | High | Sell
100701 | 2115 | 2191
100702 | 2139 | na
100705 | 2116 | 2190
100706 | 2141 | 2168
100707 | 2158 | 2237
100708 | 2202 | na
100709 | 2235 | 2301
100712 | 2234 | na
Spreadsheet: 484236d1476185149-updating-holiday-planner-for-this-year-proposed-holiday-planner-based-on-2015-16
Sheet: MAY

 |  | Days
1
 |  | Entitlement | Taken | Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 26
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
Entering '1' in the relevant row/column represents 0.5 of a day
Spreadsheet: susan_pereira__39458__ENRON
Sheet: ENRON

 | VARIBUS CORPORATION |  |  |  |  |  |  |  | MAY 31, 2000 |  |  |  |  |  |  | {SERVICES}PSNU~QAGQ
 | P.O. BOX 61000
 | NEW ORLEANS, LA 70161 |  |  |  |  |  | INVOICE NUMBER |  |  |  |  | 00-05-06
 | PH# (504)576-4152
 | IN ACCOUNT WITH
 | ENRON CAPITAL & TRADE RESOURCE CORP. |  |  |  |  |  |  |  | AMOUNT
 | Attn: [NAME]
 | 1400 SMITH, SUITE 3707
 | Houston, Texas 77002
 |  |  |  |  |  | PER
MMBTU'S |  |  | [NAME] |  |  | MMBTU |  |  |  |  |  | AMOUNT
285476 |  |  | Natural Gas Transported to |  |  | 0.03
 |  |  | GSU at [NAME] in
 |  |  | April 2000 (LRC)
 |  |  | FAO J.C. ENERGY
285475 |  |  | Natural Gas Transported to |  |  | 0.03
 |  |  | GSU at [NAME] in
 |  |  | April 2000 (LRC)
 |  |  | FAO PATTEN
 |  |  | Contact Person
 |  |  | Accounting Question
 |  |  | [NAME]Ph# (504)576-4152
 |  |  | Operational Questions
 |  |  | [NAME] Ph# (281)297-3596
 |  |  |  | TERMS 15 DAYS NET INVOICE AMOUNT
 |  |  |  | TOTAL AMOUNT DUE
 | PLEASE REMIT TO:
 | VARIBUS
 | P.O. BOX 61000
 | NEW  ORLEANS, LA.   70161
 | Attn: [NAME]
Spreadsheet: 820037d1677837618-a-way-to-calculate-daily-sales-targets-based-on-a-monthly-target-daily-deposit-tracker
Sheet: Sheet1

SAMS Apply Franchise Daily Deposit rate for Sep/Oct 23
Region | Current | Month
 |  | March
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Totals | Target
Bangladesh |  | 0 | 6 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150
UK |  | 2 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  | 150
Nigeria |  | 1 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  | 150
India |  | 0 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 58
Nepal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 17
 |  | April
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Bangladesh |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  | 150
UK |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  | 150
Nigeria |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  | 150
India |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  | 60
Nepal |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 30
 |  | May
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Bangladesh |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 100
UK |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 100
Nigeria |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 100
India |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 40
Nepal |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goal
I need the next day to update itself as I input the current day's actual deposits. The daily target is 5, so if I achieved 0 today, what should the target be for tmorrow and the rest of the month?
Spreadsheet: 166409d1341580707-formula-to-show-current-and-previous-months-data-vlookup-for-max-value
Sheet: Sheet1

 | 1 | 2001-01-01 00:00:00 | red
 | 2 | 2001-02-01 00:00:00 | yellow
 | 3 | 2001-03-01 00:00:00 | yellow
 | 4 | 2001-04-01 00:00:00 | green
 | 5 | 2001-05-01 00:00:00 | green
 | 6 | 2001-06-01 00:00:00 | green
 | 7 | 2001-07-01 00:00:00 | red
 | 8 | 2001-08-01 00:00:00 | yellow
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00
 |  | 2001-11-01 00:00:00
 |  | 2001-12-01 00:00:00
 |  | Current | yellow
 |  | Previous | red
Spreadsheet: 02fe0be7-b42d-4032-9a05-c68000232403
Sheet: June 2013

 |  | 2013 SMU-in-TAOS
 |  | How Much Does It Cost?
 | JUNE SUMMER TERM
 | June 4 - July 3  (approximately 28 days in length)
 |  |  |  | 6 Credit Hours |  | 7 Credit Hours
 |  |  |  | (2 Courses) |  | (2 Courses + Mountain Sports)
 | Academic Tuition |  |  | 4860 | (6 @ $810) | 5670 | (7 @ $810)
 | Academic Course Fees |  |  | 300 | (2 @ $150) | 300 | (2 @ $150)
 | [NAME] |  |  | 1180 |  | 1180
 | Board (Meal Plan) |  |  | 1280 |  | 1280
 | Mountain Sports Course Fee |  |  | 0 |  | 750
 | TOTAL *
 | * Add $135 for Semi-Private Room, depending upon availability.
 | COX SCHOOL OF BUSINESS (MARKETING)
 | June 4 - July 3  (approximately 28 days in length)
 |  |  |  | 4 Credit Hours
 |  |  |  | (1 Course + Internship)
 | Academic Tuition |  |  | 3240 | (4 @ $810)
 | Academic Course Fees |  |  | 300 | (2 @ $150)
 | [NAME] |  |  | 1180
 | Board (Meal Plan) |  |  | 1280
 | Mountain Sports Course Fee |  |  | 750
 | TOTAL *
 | * Add $135 for Semi-Private Room, depending upon availability.
 | ARCHAEOLOGY FIELD SCHOOL
 | June 4 - July 16  (approximately 42 days in length)
 |  |  |  | 6 Credit Hours
 | Academic Tuition |  |  | 4860 | (6 @ $810)
 | Academic Course Fees |  |  | 300 | (2 @ $150)
 | Board (Meal Plan) |  |  | 1300
 | Room * |  |  | 0
 | TOTAL |  |  | 6460
 | * No room charge, sleep in tents.
Spreadsheet: 106930d1304081466-need-a-formula-or-macro-to-count-pivot1000
Sheet: Sheet1

name | status
[NAME] | Closed
Billy | Closed
[NAME] | Closed
[NAME] | Closed
[NAME] | Open
Billy | Open
Billy | Open |  | Count of status | status
[NAME] | Pen |  | name | Closed | Open | Pen
 |  |  | Billy | 1 | 2
 |  |  | [NAME] | 2 | 1
 |  |  | [NAME] | 1 |  | 1
Spreadsheet: 275270d1383426460-problem-using-indirect-when-summing-multiple-sheets-moo_indirect_sum
Sheet: 9

 |  |  | Previous Week W/L
 |  |  | Cuml. [NAME].
Day | Spread | Scores | Teams | [NAME] | Doug | JJ | Duane | [NAME] | Dennis | [NAME] | [NAME] | [NAME] | Derek | WINNERS
T | 3 |  | Bengals | x | x | x | x | x | x | x | x | x | x | x
 |  |  | [NAME]
N | 6 |  | Chiefs | x |  | x | x |  | x | x | x |  | x | x
 |  |  | Bills |  | xh |  |  | xh |  |  |  | xh
N |  |  | Falcons |  |  | x |  | x |  |  |  |  |  | x
 | 3.5 |  | Panthers | xh | xh |  | xh |  | xh | xh | xh | xh | xh
N |  |  | Vikings | x |  | x |  |  | x | x
 | 4 |  | Cowboys |  | xh |  | xh | xh |  |  | xh | xh | xh | xh
N | 6.5 |  | Saints | x |  | x | x | x |  | x | x | x |  | x
 |  |  | Jets |  | xh |  |  |  | xh |  |  |  | xh
N | 3 |  | Titans | x | x |  | x | x | x | x |  | x | x | x
 |  |  | [NAME] |  |  | xh |  |  |  |  | xh
N |  |  | Chargers | x |  |  | x |  |  | x |  |  |  | x
 | 2 |  | Redskins |  | xh | xh |  | xh | xh |  | xh | xh | xh
3 | 2.5 |  | Eagles |  | x | x | x |  | x | x | x |  | x
 |  |  | Raiders | xh |  |  |  | xh |  |  |  | xh |  | xh
3 |  |  | Buccaneers |  | x | x | x |  |  | x
 | 7.5 |  | Seahawks | xh |  |  |  | xh | xh |  | xh | xh | xh | xh
3 |  |  | Ravens |  |  |  | x |  |  |  |  |  | x | x
 | 2.5 |  | [NAME] | xh | xh | xh |  | xh | xh | xh | xh | xh
3 |  |  | Steelers | x | x | x |  |  | x | x
 | 3.5 |  | Patriots |  |  |  | xh | xh |  |  | xh | xh | xh | xh
7 | 5.5 |  | Colts | x |  |  | x | x |  |  | x | x | x | x
 |  |  | Texans |  | xh | xh |  |  | xh | xh
M |  |  | Bears |  |  |  |  |  |  |  | x
 | 3.5 |  | Packers | xh | xh | xh | xh | xh | xh | xh |  | xh | xh | xh
 |  |  | Games
 |  |  | Wins
2013 | Season |  | Losses
 | Week |  | H-Wins
 | Played |  | U-Picks
 |  |  | U-Wins
 |  |  | L-Picks
 |  |  | L-Wins
=SUM('1:9'!F41)&" - "&TEXT(SUM('1:9'!F41)/$A40,"0.#")
Spreadsheet: 787444d1657802392-index-formula-to-pick-up-one-or-other-column-index-example
Sheet: Sheet1

Automation Reference | Ready | # | Owner | Reviewer | REVIEWER NAME | TEAM | ARCS Team
1 | Yes | 1 | [NAME] | [NAME] | None
2 | Yes | 2 | [NAME] | [NAME] | None
3 | Yes | 3 | [NAME] | [NAME] | None |  | Avengers
- | No | 4 | [NAME] | [NAME] | None |  | Avengers
4 | Yes | 5 | [NAME] | [NAME] | None
Spreadsheet: 470826d1468682924-sorting-two-different-values-book1-4-
Sheet: Pivot Table

Row Labels | Sum of a1 | Sum of a2 | Sum of a3 | Sum of a4 | Sum of a5 | Sum of a6 | Sum of a7 | Sum of a8 | Sum of a9
R | 28.37 | 141.46 | 444.08 | 20.87 | 3.46 | 110.69 | 1.98 | 1.43 | 34.26000000000001
R-01 | 10.47 | 45.04 | 182.76 | 7.16 | 1.24 | 37.54 | 0.65 | 0.28 | 4.36
R-08 | 7.84 | 45.85 | 146.36 | 3.98 | 1.29 | 44.29 | 0.73 | 0.41 | 20.69
R-07 | 10.06 | 50.57 | 114.96 | 9.73 | 0.93 | 28.86 | 0.6 | 0.74 | 9.21
RR | 33.09 | 142.45 | 355.46 | 18.8 | 3.38 | 111.48 | 2.09 | 1.06 | 35.23999999999999
RR-05 | 11.31 | 46.76 | 112.06 | 6.84 | 0.72 | 37.34 | 0.71 | 0.33 | 9.33
RR-09 | 10.95 | 47.59 | 113.88 | 4.93 | 1.27 | 38.29 | 0.71 | 0.39 | 14
RR-12 | 10.83 | 48.1 | 129.52 | 7.03 | 1.39 | 35.85 | 0.67 | 0.34 | 11.91
GR | 30.71 | 150.6 | 258.93 | 30.01 | 2.67 | 88.09 | 1.9 | 1.21 | 25.38
GR-01 | 11.22 | 47.61 | 80.64 | 8.68 | 0.96 | 32.48 | 0.62 | 0.4 | 7.96
GR-06 | 11.42 | 50.28 | 116.1 | 9.36 | 0.93 | 27.83 | 0.59 | 0.47 | 5.12
GR-11 | 8.07 | 52.71 | 62.19 | 11.97 | 0.78 | 27.78 | 0.69 | 0.34 | 12.3
Grand Total | 92.17 | 434.51 | 1058.47 | 69.67999999999999 | 9.51 | 310.26 | 5.97 | 3.7 | 94.88
Spreadsheet: 118984d1314121221-offset-function-and-blank-cells-offset-why
Sheet: Example

 | TABLE 1
 |  |  | Useful Life |  | 1 | 2 | 3 | 4 | 5
 | CAPEX |  | 3 |  | 3 | 3 | 3 | 3 | 4
 | Depreciation |  |  |  | 1 | 2 | 3 | 3 | 3.333333333333333
 | TABLE 2
 |  |  | Useful Life |  | 1 | 2 | 3 | 4 |  |  | 5
 | CAPEX |  | 3 |  | 3 | 3 | 3 | 3 |  |  | 4
 | Depreciation |  |  |  | 1 | 2 | 3 | 3 |  |  | 3.333333333333333
Spreadsheet: 791207d1660211713-help-with-a-lookup-with-two-conditions-dummy-lookup-file
Sheet: Dashboard

Project Group | PM | Function | Var 1 | Var 2 | Var 3 | Var 4 | Var 5 | Var 6 | Var 7 | Var 8 | Var 9 | Var 10
Project 1 |  | Department 1 | 1 | 0 | 1 | 0 |  | 0 | 1 |  | No | 1
Project 1 |  | Department 2 | 2291 | 220 | 2511 | 1737.25 |  | 1737.25 | 773.75 |  | No | 553.75
Project 1 |  | Department 3 | 512 | 40 | 552 | 1010.8 |  | 1010.8 | -458.8 |  | Yes | -498.8
Project 1 |  | Department 4 | 1751 | 0 | 1751 | 570.5 |  | 570.5 | 1180.5 |  | No | 1180.5
Project 1 |  | Department 5 | 1 | 0 | 1 | 0 |  | 0 | 1 |  | No | 1
Project 1 |  | Department 6 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 1 |  | Department 7 | 4412 | -371 | 4041 | 3787.49 |  | 3787.49 | 253.5100000000002 |  | No | 624.5100000000002
Project 1 |  | Department 8 | 2 | 40 | 42 | 4.25 |  | 4.25 | 37.75 |  | No | -2.25
Project 1 |  | Department 9 | 1532 | -164 | 1368 | 1532.21 |  | 1532.21 | -164.21 |  | Yes | -0.2100000000000364
Project 1 |  | Department 10 | 7908 | 925 | 8833 | 12919.38 |  | 12919.38 | -4086.379999999999 |  | Yes | -5011.379999999999
Project 1 |  | Department 11 | 1 | 0 | 1 | 13.5 |  | 13.5 | -12.5 |  | Yes | -12.5
Project 2 |  | Department 1 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 2 |  | Department 2 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 2 |  | Department 3 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 2 |  | Department 4 | 730.81 | 0 | 730.81 | 252.26 |  | 252.26 | 478.55 |  | No | 478.55
Project 2 |  | Department 5 | 381.13 | 0 | 381.13 | 259.26 |  | 259.26 | 121.87 |  | No | 121.87
Project 2 |  | Department 6 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 2 |  | Department 7 | 81.99 | 0 | 81.99 | 33.5 |  | 33.5 | 48.48999999999999 |  | No | 48.48999999999999
Project 2 |  | Department 8 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 2 |  | Department 9 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 2 |  | Department 10 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Project 2 |  | Department 11 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | No | 0
Spreadsheet: 06d9b519-b8ee-437c-90d4-c969de3e8939
Sheet: $ FY 2008-09

Fund/Bureau | Operating | Capital | Total | 50% Capital Discount | Passthrough Discount | Other Discounts | Overhead Bureau Discount | Revised Total | Allocation Percent | In Model?
100-AT | 7278731 | 0
100-AU | 5743961 | 0
100-CB | 1884157 | 0
100-EM | 1200075 | 0
100-FR | 81034766 | 15000 |  |  |  |  | -295492
100-GR | 1055827 | 0
100-HC | 14089454 | 0
100-HN | 373696 | 0
100-MF | 33122805 | 233920
100-MY | 1954746 | 0 |  |  |  |  | -1898765
100-NI | 5482681 | 0 |  |  |  |  | -362898
100-PA | 808689 | 0 |  |  |  |  | -689230
100-PK | 47835512 | 230952
100-PL | 124089859 | 0
100-PN | 8853802 | 0
100-PS | 566746 | 0
100-PU | 648573 | 14750
100-PW | 631654 | 0
100-SA | 11877579 | 0 |  |  |  |  | -295215
100-SD | 2559777 | 0
200-TR | 81652734 | 16758952
202-EC | 12826057 | 0
202-MF | 0 | 229413
203-DS | 31264883 | 0
204-MF | 4405507 | 0 |  |  |  | -4405507
206-CB | 3931842 | 0 |  |  |  | -3931842
207-MF | 27110 | 0
209-MF | 3111156 | 0 |  |  |  | -3111156
211-FM | 104679571 | 0
213-HC | 11544049 | 0
214-AU | 306661 | 0
215-PK | 2854853 | 0
216-PA | 9963872 | 0 |  |  |  | -9963872
217-EC | 1431 | 0
217-EM | 6141347 | 0
217-ES | 526973 | 793810
217-FR | 353248 | 0
217-HC | 3337612 | 0
217-MF | 117668 | 24572
217-PK | 302517 | 97591
217-PL | 1615208 | 0
217-PN | 89786 | 0
217-SD | 1389776 | 0
217-TR | 470314 | 12424399
217-WA | 241016 | 246412
218-HC | 9746889 | 0
219-HC | 4012865 | 0
220-PK | 630473 | 0
222-PL | 1505 | 0
301-FM | 55227 | 0
303-FM | 595518 | 0
400-MF | 24657 | 7493733
401-AU | 4544 | 0
402-PK | 1644636 | 19174531
500-PK | 1500 | 0
600-ES | 52029963 | 162718603
601-WA | 590447 | 118
602-WA | 49383315 | 57515189
603-PK | 6157005 | 200005
604-PK | 1283020 | 0
605-PN | 2291076 | 0
606-TR | 3850178 | 0
607-MF | 2102930 | 211894
608-ES | 4172976 | 0
614-ES | 7375 | 0
621-HC | 0 | 0
700-MF | 35716847 | 0 |  |  | -31782525
701-MF | 16403604 | 4035121
702-MF | 21995234 | 3425928
703-MF | 5935137 | 0
704-MF | 4471302 | 0
705-MF | 3213212 | 0
706-MF | 39643710 | 16617259
707-MF | 87361 | 0
708-MF | 503533 | 0
800-DR | 95952497 | 0
802-FM | 7940 | 0
Spreadsheet: 74e0766d-949a-44a6-9ad9-ababcb40906a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RCITR | Test | RCITR | Citrate Excretion, Pediatric, Random, [NAME] | Citrate Excretion, [NAME], Random, U | Enzymatic | Plastic, urine tube: PlUrTb |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. Additional Information: 1. A timed 24-hour collection is the preferred specimen for measuring and interpreting this urinary analyte. Random collections normalized to urinary creatinine may be of some clinical use in patients who cannot collect a 24-hour specimen, typically small children. Therefore, this random test is offered for children <16 years old. 2. Any drug that causes alkalemia or acidemia may be expected to alter citrate excretion and should be avoided, if possible. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | No established reference values | Monday through Saturday; 8 a.m.-4 p.m. | Same day/1 day | 3 days | 1 | 82507 |  |  |  |  | Rochester
RCITR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RCITR | Result | CITR1 | Citrate Concentration, [NAME], Random, U | Citrate Concentration, [NAME], Random, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2128-7
RCITR | Result | CREA9 | Creatinine Concentration | Creatinine Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2161-8
RCITR | Result | RATO8 | Citrate/Creatinine Ratio | Citrate/Creatinine Ratio | Numeric |  |  |  |  | mg/mg |  |  |  |  |  |  |  |  |  | 13722-4
Spreadsheet: 107327d1304519446-how-to-add-to-if-formula-dummy
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Name | DOB | State |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] | 1984-05-09 00:00:00 | FL
 |  |  |  |  |  |  |  |  | [NAME] | 1982-02-06 00:00:00 | TX
 |  |  |  |  |  |  |  |  | [NAME] | 2009-08-03 00:00:00 | TX
 |  |  |  |  |  |  |  |  | [NAME] | 2006-04-01 00:00:00 | CA
Spreadsheet: 842977d1694958304-cell-value-is-between-or-equal-to-range-return-header-value-header-based-lookup-between-values
Sheet: Sheet1

Name | Achieved Score | Expected Result |  |  | 5 | 4 | 3 | 2 | 1
Agent1 | 0.4 | 5 |  |  | 0.35 | 0.33 | 0.3 | 0.25
Agent2 | 0.35 | 5 | 5
Agent3 | 0.3475 | 4 | 4
Agent4 | 0.33 | 4 | 4
Agent5 | 0.3275 | 3 | 3
Agent6 | 0.3 | 3 | 3
Agent7 | 0.2875 | 2 | 2
Agent8 | 0.25 | 2 | 2
Agent9 | 0.17 | 1 | 1
Agent10 | 0.15 | 1 | 1
Spreadsheet: 156422d1337282677-can-i-use-sumproduct-with-if-and-and-formula-sumproduct-help
Sheet: Final

AA | Q1 2012 | Q2 2012 | Q3 2012 | Q4 2012
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
 | IF(MONTH="Actual 1/1/2012" and "Actual 2/1/2012" and "Actual 3/1/2012", SUMPRODUCT((Client=$A2)*(Advertiser=$A$1)*(Quarter=B$1)*Spend),(MONTH="Forecasted 1/1/2012" and "Forecasted 2/1/2012" and "Forecasted 3/1/2012", SUMPRODUCT((Client=$A2)*(Advertiser=$A$1)*(Quarter=B$1)*Spend)))
Spreadsheet: 49bd6035-d5f3-4eaf-a45d-1cee93a6229f
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
HSB- Undergraduate
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 161502d1339531500-excel-2007-ranking-based-on-more-factors-in-2-columns-problem-with-ranking
Sheet: Priser

Koder / Lokale | K1 | K2 | L2 | Hems tv | Hems tv |  | Forplejning | [NAME] med Berit
Minimum | 2500 | 1000 |  |  |  |  | 150 | Brød, frokost og eftermiddagskage
Standard | 250 | 150 | 150 | 150 | 150 |  | ?? | Kage
Inhouse
SpeIn | 50 | 50 | 50 | 50 | 50
Gratis aktivitet | 0 | 0 | 0 | 0 | 0
[NAME] ordner | 0 | 0 | 0 | 0 | 0
Spreadsheet: 834014d1687394696-looking-for-help-with-finding-amount-of-days-between-dates-test-sheet-for-days-calcs
Sheet: Data Entry

Date | Item 1 | Item 2 | Item 3 | Item 4
2021-09-19 00:00:00 | 0 | 1 | 0 | 1
2022-03-04 00:00:00 | 1 | 0 | 0 | 1
2023-05-12 00:00:00 | 0 | 1 | 0 | 1
2023-05-23 00:00:00 | 0 | 0 | 1 | 0
2023-06-11 00:00:00 | 1 | 0 | 1 | 0
2023-06-18 00:00:00 | 1 | 0 | 1 | 0