tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103172d1300975301-excel-2008-calendar-popup-in-excel-2010-scrap-sales-2011-rev3-
Sheet: Sheet1

Vendor | Date | Weight | Unit | Unit * WT | Rate | Check Amount |  |  |  |  |  |  |  | Cycle Systems | Per GT
BRC | 2011-01-17 00:00:00 | 39080 | Per GT | 17.44642857142857 | 345 | 6019.017857142858 |  |  |  |  |  |  |  | BRC | Per 100# | GT = 2240#
BRC | 2011-02-01 00:00:00 | 30020 | Per GT | 13.40178571428571 | 325 | 4355.580357142857
Cycle Systems | 2011-02-02 00:00:00 | 33260 | Per GT | 14.84821428571429 | 285 | 4231.741071428572
Cycle Systems | 2011-02-07 00:00:00 | 2040 | Per 100# | 20.4 | 11.5 | 234.6
Cycle Systems | 2011-02-14 00:00:00 | 29880 | Per GT | 13.33928571428571 | 285 | 3801.696428571428 |  | Total Scrap Sales for 2011
Cycle Systems | 2011-02-21 00:00:00 | 29640 | Per GT | 13.23214285714286 | 285 | 3771.160714285714
BRC | 2011-02-12 00:00:00 | 51600 | Per GT | 23.03571428571428 | 325 | 7486.607142857142 |  | 33188.21607142857
Cycle Systems | 2011-03-14 00:00:00 | 30060 | Per GT | 13.41964285714286 | 245 | 3287.8125
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
Spreadsheet: 849467d1699937416-find-average-if-findaverageif
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Result
A | Test1 | 120 | 123 | 200 | 523 | 621 | 32
 | Test2 | 40 | 50 | 6 | 952 | 145
B | Test1 | 100 | 200 | 201 | 320 | 5 | 6 | 70 | 20
 | Test2 | 10 | 20 | 30 | 40 | 50 | 60 | 125 | 112 | 632 | 852
Spreadsheet: 383068d1426299220-paste-from-unlocked-cells-to-unlocked-cells-on-protected-worksheet-sample
Sheet: Sheet3 (3)

 |  | P | 05:00:00 | 08:30:00 | 09:30:00 | 13:00:00 |  | 7 | 07:00:00
 |  | Hol | 05:00:00 | 08:30:00 | 09:30:00 | 13:00:00 |  | 7 | 07:00:00 |  |  |  |  | 7 | 0
 |  | Reclaim Hol |  |  |  |  |  | 7 | 1900-01-01 00:00:00 |  |  |  |  | 0 | 7
 |  | P | 05:00:00 | 08:30:00 | 09:30:00 | 13:00:00 |  | 7 | 07:00:00
 |  | P | 05:00:00 | 08:30:00 | 09:30:00 | 13:00:00 |  | 7 | 07:00:00
 |  | P | 05:00:00 | 08:30:00 | 09:30:00 | 13:00:00 |  | 7 | 07:00:00
 |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00
 |  | P | 05:00:00 | 08:30:00 | 09:30:00 | 13:00:00 |  | 7 | 07:00:00
 |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00
 |  | P | 05:00:00 | 08:30:00 | 09:30:00 | 13:00:00 |  | 7 | 07:00:00
 |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-13 20:24:51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42076.822434375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.54950000601821
Spreadsheet: 1862354d-a0a7-46a6-8061-02009e64bd1b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259474 | 31936 | Rafael | Farnezi | BRA |  | 00:11:40 | 00:00:43 | 00:30:00 | 00:00:33 | 00:19:21 | 1 | 01:02:20
259474 | 73569 | [NAME] | Vasconcelos | BRA |  | 00:10:56 | 00:00:56 | 00:30:09 | 00:00:36 | 00:20:32 | 2 | 01:03:11
259474 | 73752 | Eduardo | Fragoso | BRA |  | 00:12:25 | 00:00:48 | 00:30:57 | 00:00:33 | 00:21:54 | 3 | 01:06:38
259474 | 73570 | Rafael | [NAME] | BRA |  | 00:13:58 | 00:00:56 | 00:31:25 | [NAME] | 00:25:53 | 4 | 01:12:55
259474 | 73850 | [NAME] | De Freitas | BRA |  | 00:23:58 | 00:01:56 | 00:36:14 | 00:01:30 | 00:24:38 | 5 | [NAME]
Spreadsheet: 869126d1715775124-sumif-_conditioned-of-performance-final_sumif_cond_values-_-with-matching-columns_glenn_15-mai
Sheet: Glenn_offered Solution

=[NAME] "F" | =[NAME] "G" | =[NAME]" | =[NAME] "BH"
Group | Members | # | Value, €
Group5 | Jan | yes | 2
Group2 | [NAME] | yes | 112
Group3 | Volker | 0 | 1
Group2 | Maria | 0 | 1
Group1 | [NAME] | 0 | 25
Group2 | [NAME] | yes | 50
Group3 | [NAME] | 0 | 60
Group4 | Katha | yes | 75
Group3 | [NAME] | yes | 15
Group4 | Holger | 0 | 12
Group1 | Anto | yes | 250
Group4 | Bernd | 0 | 4
Group3 | [NAME] | 0 | 85 |  | Amont of groups, in which specs "sent" are exceeding 50% with their value the total  specs value of the group
Group5 | Anna | yes | 60 |  | "3" | expected result
Group5 | Caroline | 0 | 20
Group1 | Alla | 0 | 75
Group2 | [NAME] | 0 | 38
Group3 | [NAME] | 0 | 42
Group3 | Tizian | yes | 120
Group4 | Vitus | 0 | 250
Group4 | Niklas | yes | 10
Group4 | [NAME] | yes | 100
Group1 | Xavier | 0 | 0 | Challenge:
Group1 | Oxana | 0 | 4 | -count amount of Groups (not members) which have SENT out a specification (column "C"=yes), however only THEN, when the total money value (within this particular group) of specificaitons [NAME] are equal or exceeding 50% of the total specification's VALUE (column "D") of this particular group.
Group5 | Cam | 0 | 90 | -Example on "Group 3": total specifications "sent" - 135€ out of 323€ of the whole group. Since it equals to LESS than 50% (135/323), => "Group 3" should not be counted for the final result.
Group5 | Uzay | 0 | 10 | - please in case if there are no entries in columns "Specification" and "Value, €", the result should be Zero , and not "1".
Group5 | Atakan | yes | 180
Group2 | [NAME] | yes | 300
Group6 | Vasja | 0 | 0 | PS  - Members are not important for this logic, names entries are just put for demo reasons
Group6 | Petja | 0 | 0
Group6 | Asja | 0 | 0
Spreadsheet: 679245d1590278292-randbetween-question-randbetween-updated
Sheet: Sheet1

Random numbers | Which row to remove
Spreadsheet: mary_hain__25837__1st qtr 2000 EPMI FERC Report
Sheet: Exchange

 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | Total
Exchange Receipt
Hinson Power Company | 0 | 43152 | 138384
Illinois Power Company | 0 | 0 | 0
[NAME] | 2976 | 2784 | 2976
Washington Water & Power | 0 | 0 | 0
Total
Exchange Delivery
Hinson Power Company | 0 | -43152 | -138384
Illinois Power Company | 0 | 0 | 0
[NAME] | -2976 | -2784 | -2976
Washington Water & Power | 0 | 0 | 0
Total
Spreadsheet: 153516d1335951081-auto-sort-values-drawn-from-a-vlookup-table-into-ascending-order-dsklein85
Sheet: Sort

 | X | Y
Spreadsheet: 855092d1704795141-change-formula-to-format-by-row-rather-than-column-book-1
Sheet: Sheet2

VESSEL |  | VESSEL + PLN |  | VESSEL TYPE |  | BOX TYPE |  | TRIP DATES |  | FISHING AREA |  | FSIHING TIME |  | HAULS TO ADD
[NAME] |  | [NAME] | BPS | TRAWL |  | BPS |  |  |  | FAO27-Sub / Area: IV |  | 1 day |  | 0
KEILA |  | [NAME] | BPS | SEINE |  | GKN |  |  |  | FAO27-Sub / Area: VI |  | 2 days |  | 1
CEOL NA MARA |  | [NAME] | BPS |  |  | LHD |  |  |  | FAO27-Sub / Area: IV  + VI |  | 3 days |  | 2
GENESIS |  | Genesis BF505 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: IV + VI |  | 4 days |  | 3
CALEDONIA |  | [NAME] | BPS |  |  |  |  |  |  | FAO27-Sub / Area: Vb |  | 5 days |  | 4
CARINA |  | [NAME] | BPS |  |  |  |  |  |  | FAO27-Sub / Area: VIb |  | 6 days |  | 5
[NAME] |  | Radiance INS240 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: VIa + VIb |  | 7 days |  | STILL FISHING
LOCH INCHARD |  | Loch Inchard III UL44 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: VIa + VIb + IVa |  | 8 days
RELIANCE |  | Reliance III BF800 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: IV + VI + Vb |  | 9 days
[NAME] |  | Transcend BF61 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: IV + Vb |  | 1.5 days
AQUARIUS |  | Aquarius BF89 | BPS
SP/ STAR |  | Sparkling Star UL290 | BPS
ADVENTURER |  | Adventurer INS8 | GKN
DEESIDE |  | Deeside BCK595 | BPS
FLADDA MAID |  | [NAME] | GKN
VISION |  | Vision BF191 | BPS
SHEKINAH |  | [NAME] | BPS
LOLA V |  | Lola V BF100 | BPS
JOLANNA M |  | [NAME] | BPS
GRIANAN OIR |  | [NAME] | GKN
OCEAN ROSE |  | Ocean Rose INS115 | BPS
CONSORTIUM |  | Consortium [NAME] | GKN
CONQUEST |  | Conquest BCK364 | BPS
OCEAN BOUNTY |  | Ocean Bounty PD182 | BPS
AVRELLA |  | [NAME] | LHD
SERENITY |  | Serenity BF24 | BPS
WESTRA FJORD |  | [NAME] K193 | BPS
LIBERTY |  | Liberty BF120 | BPS
APOLLO |  | Apollo INS179 | BPS
NORLAN |  | [NAME] | BPS
OPPORTUNE |  | Opportune LK209 | LHD
OSPREY |  | [NAME] | GKN
NJORD VENTURE |  | Njord Venture INS291 | GKN
LEAH FAYE |  | Leah Faye WK290 | BPS
FISHER BOYS |  | Fisher Boys FR54 | GKN
VENTURE |  | Venture BF326 | BPS
ENDEAVOUR |  | Endeavour V BF515 | BPS
ACCORD |  | Accord BCK262 | BPS
FAITHLIE |  | [NAME] | BPS
ELLORAH |  | [NAME] BF12 | BPS
MORAY END |  | Moray Endeavour BCK17 | GKN
COURAGE |  | Courage SH170 | GKN
REAPER |  | Reaper WK83 | BPS
Spreadsheet: 775712d1649263183-split-sheet-in-half-vertically-trailer-dots-due-1-
Sheet: Sheet2

TRAILER # | DOT expires | STATUS | TRAILER # | DOT expires | STATUS
DUE DATES GUIDE |  | NEXT MONTH | THIS MONTH | OVERDUE
3524 | 2022-06-13 00:00:00 |  | 135234 | 2022-05-01 00:00:00
5250 | 2022-03-10 00:00:00 |  | 135235 | 2021-11-25 00:00:00
5251 | 2022-04-01 00:00:00 |  | 135236 | 2022-04-29 00:00:00
5430 | 2022-01-13 00:00:00 |  | 135237 | 2022-04-28 00:00:00
5431 | 2021-12-29 00:00:00 |  | 135238 | 2021-10-30 00:00:00
5432 | 2022-03-26 00:00:00 |  | 135239 | 2021-11-13 00:00:00
5433 | 2022-06-25 00:00:00 |  | 195240 | 2022-05-31 00:00:00
5434 | 2021-11-24 00:00:00 |  | 195241 | 2022-01-29 00:00:00
5435 | 2021-12-19 00:00:00 |  | 195242 | 2022-07-19 00:00:00
6700 | 2022-01-12 00:00:00 |  | 195243 | 2022-06-27 00:00:00
6701 | 2021-10-03 00:00:00 |  | 195244 | 2021-10-23 00:00:00
6702 | 2021-12-07 00:00:00 |  | 195245 | 2022-05-15 00:00:00
6703 | 2022-06-26 00:00:00 |  | 195246 | 2022-01-15 00:00:00
6704 | 2021-10-09 00:00:00 |  | 195247 | 2022-05-25 00:00:00
6705 | 2021-10-26 00:00:00 |  | 195248 | 2021-08-30 00:00:00
9526 | 2022-06-01 00:00:00 |  | 195249 | 2021-12-06 00:00:00
9527 | 2022-06-01 00:00:00 |  | 195301 | 2021-11-28 00:00:00
9528 | 2022-06-01 00:00:00 |  | 195302 | 2021-08-11 00:00:00
9529 | 2022-06-01 00:00:00 |  | 195305 | 2022-05-31 00:00:00
9530 | 2022-07-01 00:00:00 |  | 195306 | 2022-01-29 00:00:00
9531 | 2021-09-05 00:00:00 |  | 195430 | 2021-09-10 00:00:00
9532 | 2022-01-09 00:00:00 |  | 195431 | 2021-11-11 00:00:00
9533 | 2022-02-24 00:00:00 |  | 195432 | 2021-09-13 00:00:00
9534 | 2022-01-06 00:00:00 |  | 195433 | 2022-05-07 00:00:00
9535 | 2022-03-28 00:00:00 |  | 195434 | 2022-05-09 00:00:00
9536 | 2022-07-01 00:00:00 |  | 195435 | 2022-06-22 00:00:00
9537 | 2022-08-01 00:00:00 |  | 195436 | 2021-07-31 00:00:00
9538 | 2022-08-01 00:00:00 |  | 195437 | 2022-02-25 00:00:00
9539 | 2021-07-30 00:00:00 |  | MSP 571 | 2022-07-23 00:00:00
9540 | 2022-07-17 00:00:00 |  | MSP 573 | 2022-05-22 00:00:00
9541 | 2022-07-11 00:00:00 |  | MSP569 | 2022-06-10 00:00:00
9542 | 2022-03-21 00:00:00 |  | MSP574 | 2021-07-31 00:00:00
9544 | 2022-05-19 00:00:00 |  |  | NA
9545 | 2021-12-09 00:00:00 |  |  | NA
9546 | 2022-01-24 00:00:00 |  |  | NA
9547 | 2021-11-27 00:00:00 |  |  | NA
9548 | 2021-09-16 00:00:00 |  |  | NA
9549 | 2022-03-05 00:00:00 |  |  | NA
9550 | 2022-02-22 00:00:00 |  |  | NA
9551 | 2022-03-28 00:00:00 |  |  | NA
9555 | 2022-05-28 00:00:00 |  |  | NA
9556 | 2021-08-20 00:00:00 |  |  | NA
9562 | 2022-02-06 00:00:00 |  |  | NA
9563 | 2022-06-01 00:00:00 |  |  | NA
9564 | 2022-01-04 00:00:00 |  |  | NA
9565 | 2022-04-27 00:00:00 |  |  | NA
9577 | 2022-06-07 00:00:00 |  |  | NA
9584 | 2021-08-08 00:00:00 |  |  | NA
9599 | 2022-01-16 00:00:00 |  |  | NA
135233 | 2022-04-30 00:00:00 |  |  | NA
Spreadsheet: 2dbf3201-cd12-4cbf-9a24-ba163dc93b33
Sheet: Sheet1

GENERAL HOUSING ACTIVITIES APPLICATION: ROUND 2.2 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
[NAME] Excel Project Budget Form
Region: DETCOG
Applicant: Deep East Texas Council of Governments
Required | Budget Breakout by LMI Population |  |  |  | Budget Breakout by Slum & Blight | Budget Total | Estimated Low/Mod Households Served |  |  |  | Estimated Slum & Blight HH (if applicable)
 | Required | Required | Required | Subtotal | Subtotal | Total | Required | Required | Required | Subtotal | Optional
Activity Type | Very Low HH (<30%) | Low HH  (31%-50%) | Moderate HH (51%-80%) | Budget for Combined HH | Budget for Slum & Blight (if applicable) |  | Very Low HH (<30%) | Low HH  (31%-50%) | Moderate HH (51%-80%) | Number of Combined LMI HH Served | Number of Slum & Blight HH
Project/ Construction* |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
HAP - LMI | 6550000 | 4550000 | 2000000 | 13100000 | 0 | 13100000 | 77 | 54 | 22 | 153 | 0
R – LMI - Single | 500000 | 350000 | 150000 | 1000000 | 0 | 1000000 | 7 | 5 | 2 | 14 | 0
HBA - LMI | 1250000 | 875000 | 375000 | 2500000 | 0 | 2500000 | 31 | 22 | 10 | 63 | 0
 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0
Acquisition |  |  |  | 1000000 | 0 | 1000000 |  |  |  |  | 0
Engineering |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
Project Delivery  1 |  |  |  | 2000000 | 0 | 2000000 |  |  |  |  | 0
Administration  2 |  |  |  | 400000 | 0 | 400000 |  |  |  |  | 0
TOTAL: | 8300000 | 5775000 | 2525000 | 20000000 | 0 | 20000000 | 115 | 81 | 34 | 230 | 0
"HH" equals Households.
*Eligible activities should be identified using the Project Overview Categories selected on Tab II of the application. Select from the drop-down list in Column A of this Excel sheet.
1 Project Delivery is capped at 10% of the grant amount.
2 Administration is capped at 2% of the grant amount.
Spreadsheet: 328484d1403908602-sumifs-with-multiple-criteria-and-sumranges-book2-solution-jacc
Sheet: Sheet1 (2)

YTD Spend
 |  |  | 3 | 3 | 3 | 4 | 4 | 4
Category | Department | Account | Jul | Aug | Sep | Oct | Nov | Dec |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
Consulting | 340 | 84100 | 3239.985872854265 | 3239.985872854265 | 3239.985872854265 | 3239.985872854265
[NAME] | 150 | 55000 | 1215 | 1215 | 1215 | 1215
Consulting | 250 | 89000 | 17500 | 0 | 0 | 0
Consulting | 150 | 83250 | 5953.06375 | 5953.06375 | 5953.06375 | 5953.06375
[NAME] | 150 | 51210 | 1286.8325 | 1286.8325 | 1286.8325 | 1286.8325
Consulting | 160 | 87000 | 144.80125 | 144.80125 | 144.80125 | 144.80125
[NAME] | 120 | 51410 | 280.89125 | 280.89125 | 280.89125 | 280.89125
Consulting | 150 | 88654 | 659.5775 | 659.5775 | 659.5775 | 659.5775
[NAME] | 150 | 51110 | 5953.06375 | 5953.06375 | 5953.06375 | 5953.06375
T&M | 180 | 61600 | 1286.8325 | 1286.8325 | 1286.8325 | 1286.8325
[NAME] | 150 | 51310 | 144.80125 | 144.80125 | 144.80125 | 144.80125
T&M | 280 | 61400 | 280.89125 | 280.89125 | 280.89125 | 280.89125
[NAME] | 150 | 51510 | 659.5775 | 659.5775 | 659.5775 | 659.5775
Current Period | 3
I want to know how muuch has been spent on [NAME] by dept 150 YTD which in this case would be for Jul-Sep
Is there a formula that would say look up everything through current period for [NAME] and dept 150, maybe a sumifs? I can do sumifs with offset but only for one period.
Spreadsheet: 118759d1313994753-if-statement-to-compare-times-copy-of-variation
Sheet: Raw Parts

Average Parts Per Shift |  |  |  |  |  |  |  |  |  | Average Parts Per Shift
 | (Monday) |  |  |  |  |  |  |  |  |  | (Monday)
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
1 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 1 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
2 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 2 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
3 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 3 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
 | Shifts: |  | #REF!
 | Time:
 | Current Time: |  |  |  | 109-1 | 109-2 | 109-3 | 109-4 |  |  |  |  |  |  | 110-1 | 110-2 | 110-3 | 110-4
 | End Time |  | 06:00:00
 | Difference:
 | Coefficient
Spreadsheet: 834970d1688202643-rank-function-streamline-process-rank-function
Sheet: Sheet1

 | Existing Data Set (Sample)
Column1 | Q1 | Q2 | Q3 | Q4
2020 | -7156 | 9419 | 6490 | 5116
2021 | 4216 | 2137 | -8701 | 5217
2022 | -4731 | -8062 | 9946 | 1421
2023 | 5158 | 1396
 | SIMPLE RANK Function (same structure)
 | What I would like instead is the following: |  |  |  |  |  | RanK | Value | Quarter
 |  |  |  |  |  |  | 1 | 9946 | 2022-Q3
 | RANK * | AMOUNT ** | QTR/YEAR *** |  |  |  | 2 | 9419 | 2020-Q2
 | 1 | 9946 | 2022 - Q3 |  |  |  | 3 | 6490 | 2020-Q3
 | 2 | 9419 | 2020 - Q2 |  |  |  | 4 | 5217 | 2021-Q4
 | 3 | 6490 | 2020 - Q3 |  |  |  | 5 | 5158 | 2023-Q1
 | 4 | 5217 | 2021 - Q4 |  |  |  | 6 | 5116 | 2020-Q4
 | 5 | 5158 | 2023 - Q1 |  |  |  | 7 | 4216 | 2021-Q1
 | 6 | 5116 | 2020 - Q4 |  |  |  | 8 | 2137 | 2021-Q2
 | 7 | 4216 | 2021 - Q1 |  |  |  | 9 | 1421 | 2022-Q4
 | 8 | 2137 | 2021 - Q2 |  | See comments in B38:B40 |  | 10 | 1396 | 2023-Q2
 | 9 | 1421 | 2022 - Q4 |  |  |  | 11 | -4731 | 2022-Q1
 | 10 | 1396 | 2023 - Q2 |  |  |  | 12 | -7156 | 2020-Q1
 | 11 | -4731 | 2022 - Q1 |  |  |  | 13 | -8062 | 2022-Q2
 | 12 | -7156 | 2020 - Q1 |  |  |  | 14 | -8701 | 2021-Q3
 | 13 | -8062 | 2022 - Q2
 | 14 | -8701 | 2021 - Q3
 | 15 | -- | --
 | 16 | -- | --
 | * Needs to be a formula
 | ** Needs to be the RANK formula (top-down across 16 rows vs. top-down for 4 rows COL B; & 4 rows COL C, etc.)
 | *** Needs to be a lookup formula based on the ranked value
Spreadsheet: 819801d1677694465-tasklist-showing-daily-complete-as-well-as-weekly-help-tasklist
Sheet: Sheet1

% Not Started
% Started
% Completed
 | Weight per Task | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6
Task 1 | 2 | 2 |  |  |  |  | [NAME] |  |  | Task 1 is assigned a weighting of 2 so whatever colour the cell is, 2 would add to that subtotal for that colour
Task 2 | 5 | 5 |  |  |  |  | [NAME]
Task 3 | 10 | 10 |  |  |  |  | [NAME]
Task 4 | 12 | 12 |  |  |  |  | [NAME]
Task 5 | 6 | 6 |  |  |  |  | [NAME]
Task 6 | 6 | 6 |  |  |  |  | [NAME]
Task 7 | 7 | 7 |  |  |  |  | [NAME]
Task 8 | 8 | 8 |  |  |  |  | [NAME]
Task 9 | 5 | 5 |  |  |  |  | [NAME]
Task 10 | 2 | 2 |  |  |  |  | [NAME]
Task 11 | 3 | 3 |  |  |  |  | [NAME]
Task 12 | 2 | 2 |  |  |  |  | [NAME]
Task 13 | 1 | 1 |  |  |  |  | [NAME]
Task 14 | 2 | 2 |  |  |  |  | [NAME]
Task 15 | 3 | 3 |  |  |  |  | [NAME]
Task 16 | 8 | 8 |  |  |  |  | [NAME]
Task 17 | 1 | 1 |  |  |  |  | [NAME]
Task 18 | 2 | 2 |  |  |  |  | [NAME]
Task 19 | 4 | 4 |  |  |  |  | [NAME]
Task 20 | 5 | 5 |  |  |  |  | [NAME]
Task 21 | 6 | 6 |  |  |  |  | [NAME]
 |  | 100
 | Notes: | Day 1 would not have numbers in the cell, it would look like day 6
[NAME] is to see at a snpshot how far along we are on daily basis % complete/started/not started and then a total week roll up
Spreadsheet: 472012d1469400460-converting-data-between-tabs-copy-of-department-performance
Sheet: Team

 |  |  | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week |  |  | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | -
2016-07-10 00:00:00 | -
2016-07-17 00:00:00 | -
2016-07-24 00:00:00 | -
2016-07-31 00:00:00 | -
2016-08-07 00:00:00 | -
2016-08-14 00:00:00 | -
2016-08-21 00:00:00 | -
2016-08-28 00:00:00 | -
2016-09-04 00:00:00 | -
2016-09-11 00:00:00 | -
2016-09-18 00:00:00 | -
2016-09-25 00:00:00 | -
2016-10-02 00:00:00 | -
2016-10-09 00:00:00 | -
2016-10-16 00:00:00 | -
2016-10-23 00:00:00 | -
2016-10-30 00:00:00 | -
2016-11-06 00:00:00 | -
2016-11-13 00:00:00 | -
2016-11-20 00:00:00 | -
2016-11-27 00:00:00 | -
2016-12-04 00:00:00 | -
2016-12-11 00:00:00 | -
2016-12-18 00:00:00 | -
2016-12-25 00:00:00 | -
 |  | TOTAL
Spreadsheet: drew_fossum__8690__Gallup Modification Exh N
Sheet: REVENUE SUMMARY

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exhibit N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOT TO BE FILED |  |  |  |  |  | Summary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORKPAPER
Transwestern Pipeline Company
Revenue Summary
(IN $000)
 |  |  |  |  | MONTHS OF |  | DAILY
 | LINE |  |  |  | REVENUE IN | RATE | [NAME]
 | NO. |  | [NAME] |  | YEAR 1 | SCHEDULE | [NAME] | RATE  1/ | YEAR 1 |  | YEAR 2 |  | YEAR 3 |  | YEAR 4 |  | YEAR 5 |  | YEAR 6 |  | YEAR 7 |  | YEAR 8 |  | YEAR 9 |  | YEAR 10
 | 1 |  | INCREMENTAL REVENUES
 | 2 |  | East of Thoreau to California |  | 12 | FTS-1 | 10000 | 0.3771
 | 3
 | 4 |  | Total Revenues
 |  |  | 1/   Includes Reservation and Commodity Base Rates and Applicable Surcharges.
Spreadsheet: 65428d1266148035-if-any-number-are-repeating-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 125468A-B | 125468 | 125468A
 |  |  |  |  |  |  |  |  |  |  |  | 125468A-B | 125468 | 125468B
 |  |  |  |  |  |  |  |  |  |  |  | 458962 | 458962 | 458962A
 |  |  |  |  |  |  |  |  |  |  |  | 256897 | 256897 | 256897A
 |  |  |  |  |  |  |  |  |  |  |  | 412589A-C | 412589 | 412589A
 |  |  |  |  |  |  |  |  |  |  |  | 412589A-C | 412589 | 412589B
 |  |  |  |  |  |  |  |  |  |  |  | 412589A-C | 412589 | 412589C
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Spreadsheet: 61485222-976d-47da-ba62-2e43845658f2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
3549 | 10229 | Ragnhild | Bolstad | NOR | 7 | 00:19:55 | [NAME] | 00:21:57 | 00:00:54 | 00:22:32 | 1 | 01:06:01
3549 | 21542 | Beate | Cekoni-Hutter | AUT | 6 | 00:20:31 | 00:00:34 | 00:24:19 | [NAME] | 00:25:41 | 2 | 01:11:59
3549 | 21543 | Anneliese | Autherit | AUT | 5 | 00:24:37 | 00:00:46 | 00:32:20 | 00:01:04 | 00:37:43 | 3 | 01:36:34
Spreadsheet: 29188d1224032407-how-can-i-get-a-sum-total-of-total-dulplicates-for-each-item-in-a-row-count-duplicate
Sheet: sglife

Item
9990053651 |  | Item | Count of Item
9990053651 |  | 9990053651 | 2
9990053654 |  | 9990053654 | 7
9990053654 |  | 9990053659 | 1
9990053654 |  | Grand Total | 10
9990053654
9990053654
9990053654
9990053654
9990053659