tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0aa3fe2c-ea65-4693-8c18-1cdd1ff02db3
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
87310DO001_201311 Building Approvals, Australia, Nov 2013
Released at 11:30 am (Canberra time) Thurs 9 Jan 2014
 | Contents
 | Tables
 | 1 | ASGS Data Items, by Statistical Area 2 (SA2)
 | 2 | ASGS Data Items, by Local Government Area (LGA) (a)
 | 3 | ASGS Data Items, by Greater Capital City Statistical Area (GCCSA), State and Australia
 | More information available from the ABS website
 | Building Approvals, Australia, Nov 2013
 | Summary
 | Explanatory Notes
 | Inquiries
 | For further information about these and related statistics, contact the National Information and Referral Service on 1300 135 070.
 | © Commonwealth of Australia 2014
Spreadsheet: 266897d1379819002-unsolved-checkbox-problem-attendance
Sheet: Sheet1

 |  | Attendance of 2 Aman | 1 | 1 |  |  | Type 1 to check All
 | No | Name | sept.22 | sept.23
 | 1 | IRHAM HAZIM B RASHID
 | 2 | JEBAT ZULFAR MINKAIL B ABD GHAFAR
 | 3 | MUHAMMAD AKMAL DANIEL B RAFIDI
 | 4 | MUHAMMAD AMIR ASHRAFF B MOHD TARMIZI
 | 5 | MUHAMMAD ANIQ MUSYRIF B ABDUL WAHAB
 | 6 | MUHAMMAD DANIEL HAZIQUE B ABD MANAF
 | 7 | MUHAMMAD DANISH ALAL B RAHMAT
 | 8 | MUHAMMAD FIRDAUS ALTAF B OSMAN
 | 9 | MUHAMMAD HANIF AIMAN B MD RIZWAN
 | 10 | MUHAMMAD HAZIQ B ZAMZURI
 | 11 | MUHAMMAD IRFAN NABIL B AZNIZAN
 | 12 | MUHAMMAD NAZRUL NIZAM B HAMZAH
 | 13 | MUHAMMAD NORHELMIE B MOHD NOOR
 | 14 | MUHAMMAD NURHAFIZ B KHOLIB
 | 15 | MUHAMMAD SAHARULIZWAN B IBRAHIM
 | 16 | MUHAMMAD SHAHRUL IMAN B SHAHMIRU
 | 17 | MUHAMMAD SYAHMI MUNAJI B SIDI
 | 18 | MUHAMMAD YASIN IZZUDIN B FADLI
 | 19 | MUHAMMAD ZULKHAIRI B MOHD ZOLKEPLI
 | 20 | NAZROUL TAZREEQ B NAZERI
 | 21 | WAN AMSYAR B WAN ANUAR
 | 22 | WAN ZULHELMI B WAN ZAHRON
 | 23 | ANI DHIA SYARAFANA BT FAREID HAKIM
 | 24 | KU NURNAJIHA NABILA BT KU MOHD ZAHREN
 | 25 | MARSYA ADILAH BT MOHD ZULHILMI
 | 26 | MILA NUR EMILIYA KRISTANA BT MOHT NASIR
 | 27 | NOOR AISHAH BT NOOR AHMAD
 | 28 | NUR ADLINA AMIRAH BT MD ZAIDI
 | 29 | NUR ALYA HANIM BT MOHD NAAIM
 | 30 | NUR AUNI SYAMIMI BT AZMAN
 | 31 | NUR FARHANA NABILA BT SHUHAIMI
 | 32 | NUR KIASATINA BT NAIMI
 | 33 | NUR NAJWA ASYIQIN BT MOHD NIZA
 | 34 | NUR SHUHADA BT REJAB
 | 35 | NURIZAN BT MD SALLEH
 | 36 | NURUL FITRAH BT ABD  HAMID
 | 37 | PUTERI SYIFAA SYAHIRAH BT CHE MANSOR
 | 38 | RABIA'TUL UMMAIRAH BT HUSSAINY
 | 39 | SITI ZULAIKHA BT JULANI
Spreadsheet: 783862d1655212593-transform-data-in-columns-to-rows-sample_formulas
Sheet: Лист1

PACKAGE_CODE | Package Description | A | B | C | D | E | F | G | H | I
PK0004 | ABC | 1 | 210 | 210 | 0 | 0 | 105 | 105 | 105 | 420
PK0006 | CDE | 1 | 378 | 378 | 0 | 0 | 189 | 189 | 189 | 756
PK0007 | EFG | 1 | 315 | 315 | 0 | 0 | 157.5 | 157.5 | 157.5 | 630
Spreadsheet: 887086d1737208984-total-if-if-total-not-blank-in-other-cells-but-is-blank-is-other-cells-test-4
Sheet: Stock

Product No | Product Category | Product Description | Wholesaler | Product Code | Price at the Cowshed | Stock at Cowshed | QTY Sold at Cowshed | Stock at Home | Stock Ordered | Damaged | Date ordered | Due to Arrive at Wholesale Warehouse | QTY Arrived
1 | [NAME] | A |  | 1 | 7 |  |  | 2
 | [NAME] | B |  | 2 | 7
 | [NAME] | C |  | 3 | 7
 | [NAME] | D |  | 4 | 7
Spreadsheet: 775203d1648906480-need-each-companies-sale-for-specific-date-specific-week-specific-month-from-other-sheet-specific-date-wise-data-extract-from-other-sheet
Sheet: Entry Sheet

 | Date |  | Month |  |  | Week
 | 2022-03-31 00:00:00 |  | 2022-03-01 00:00:00 | 31 Mar 20222 |  | 2022-03-21 00:00:00 | 2022-03-27 00:00:00
Company | Sale |  | Highest Sale | Lowest Sale |  | Highest Sale | Lowest Sale |  |  | Data Source = | All companies day by day sale is in other sheet, "Source data Sheet"in this workbook only
DIVISLAB
HINDALCO |  |  |  |  |  |  |  |  |  | I need help for these querries | B Coloumn = I want Sale of each company for Specific date mentioned in B2, So that I can just input the date and sale for that day will come instantly
TATASTEEL
DRREDDY |  |  |  |  |  |  |  |  |  |  | D Coloumn = I want highest sale of each company in specific month mentioned in D2
 |  |  |  |  |  |  |  |  |  |  | E Coloumn = I want lowest sale of each company in specific month mentioned in D2
 |  |  |  |  |  |  |  |  |  |  | G Coloumn = I want [NAME] sale for each company in specific Week and week range is mentioned in G2:H2
 |  |  |  |  |  |  |  |  |  |  | H Coloumn = I want lowest sale for each company in specific Week and week range is mentioned in G2:H2
 |  |  |  |  |  |  |  |  |  |  | All companies day by day sale is in other sheet names "Source data Sheet"in this workbook only
 |  |  |  |  |  |  |  |  |  | I Don’t want to convert this data in Table format, So It will be request for help with Specific Cell Numbers in formula.
Spreadsheet: 2ee54941-5726-4f12-a910-062b13258209
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Bus Pass/Bus Card Application Form
School Data:
Charter School Name:
School County District Number (CDN):
Name of School Point of Contact:
Telephone Number of School Point of Contact:
Email Address of School Point of Contact:
Metropolitan Transit Authority Data:
Name of Metro Transit that passes will be purchased from:
Name of Point of Contact at the Metro Transit:
Telephone Number/Email address of Metro Point of Contact:
Data Regarding the Type of Pass for which [NAME] is Requested:
Place X in box by the applicable type pass:
 | Monthly/ 30-Day:
 | Full Price of pass:
 | School Discounted Cost of Pass:
 | Estimated Quantity per month:
 | Weekly/ 7-Day:
 | Full Price of pass:
 | School Discounted Cost of Pass:
 | Estimated Quantity per month:
 | Daily:
 | Full Price of pass:
 | School Discounted Cost of Pass:
 | Estimated Quantity per month:
 | Bus Card (Debit Card for Daily Rides):
 | Full Price of Daily Ride:
 | School Discounted Cost of Daily Ride:
 | Quantity of Rides Required Per Student Per Day:
 | Estimated Number of Eligible Students per Month:
 | Special Needs Transit:
 | Full Price of pass:
 | School Discounted Cost of Pass:
 | Estimated Quantity per month:
Spreadsheet: 810221d1671620816-how-to-delete-cells-with-text-and-keep-cell-that-has-numbers-test
Sheet: Sheet1

Main - 16
16-02 | 16-08 | 16-11 | 16-12 | 16-14
XYZ | XYZ | XYZ | XYZ | XYZ
A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx,
xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx
xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297
7207263403 | 92461 64011 / 65546450 | 98490 35111 / 65580029 | 92966 51780 /  24560775 | 93470 55211 / 66611680
16-51 | 16-53 | 16-55 | 16-59 | 16-66
XYZ | XYZ | XYZ | XYZ | XYZ
A311, xxxxxx, | xxxxx xxxxx xxxxxx | A311, xxxxxx, | A311, xxxxxx, | xxxxx xxxxx xxxxxx
xxxxx xxxxx xxxxxx | xxxxx xxxx - 297 | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxx - 297
xxxxx xxxx - 297 | 92461 80493 / 66901575 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | 93910 12959 / 66566542
99669 94499 / 66731204 |  | 98495 55159 / 24577243 | 99665 51066 / 65537578 / 9
16-67 | 16-68 | 16-69 | 16-71 | 16-74
XYZ | XYZ | XYZ | XYZ | XYZ
xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | A311, xxxxxx, | A311, xxxxxx, | xxxxx xxxxx xxxxxx
xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxx - 297
93910 22163 / 66566542 | 93475 22673 / 66566542 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | 93903 63349 / 66144727
 |  | 9246119600 | 93911 43879 / 66365645
Spreadsheet: 73571d1274213274-excel-2007-how-do-i-translate-column-including-duplicates-to-a-seperate-column-row-example
Sheet: Sheet1

102 | Value1 |  | 102 | Value1
103 | Value1 |  | 103 | Value1
202 | Value1 |  | 202 | Value1
203 | Value1 |  | 203 | Value1
302 | Value1 |  | 302 | Value1 | Value2 | Value3
302 | Value2 |  | 302 | Value2 | Value3
302 | Value3 |  | 302 | Value3
402 | Value1 |  | 402 | Value1
403 | Value1 |  | 403 | Value1 | Value2
403 | Value2 |  | 403 | Value2
501 | Value1 |  | 501 | Value1
502 | Value1 |  | 502 | Value1 | Value2
502 | Value2 |  | 502 | Value2
503 | Value1 |  | 503 | Value1
601 | Value1 |  | 601 | Value1 | Value2 | Value3 | Value4 | Value5
601 | Value2 |  | 601 | Value2 | Value3 | Value4 | Value5
601 | Value3 |  | 601 | Value3 | Value4 | Value5
601 | Value4 |  | 601 | Value4 | Value5
601 | Value5 |  | 601 | Value5
602 | Value1 |  | 602 | Value1
603 | Value1 |  | 603 | Value1 | Value2
603 | Value2 |  | 603 | Value2
701 | Value1 |  | 701 | Value1
703 | Value1 |  | 703 | Value1
Spreadsheet: paul_y'barbo__28514__Fuel Inventory Report
Sheet: Sheet1

EcoEléctrica, L.P.
Fuel Inventory Report
 | In accordance with Article 7.0, Section 7.7 of the PPOA
 |  |  |  |  |  | 05/04/01
 |  |  | LNG |  | LPG |  | Fuel Oil
Fuel (barrels) - Inventory |  |  | 427787 |  | 84988 |  | 68536
Fuel (MMBTU) - Inventory |  |  | 1537437 |  | 325896 |  | 378522
Fuel (barrels) in excess of XDL |  |  | 44524 |  | N/A |  | N/A
Fuel (MMBTU) in excess of XDL |  |  | 160000 |  | N/A |  | N/A
Projected Delivery date (s) |  |  | 2001-05-19 00:00:00
Projected Delivery quantities (MMBTU) |  |  | 2040000
Projected Delivery quantities (barrels) |  |  | 567666
Excess LNG spot fuel price ($/MMBTU HHV) |  |  | 5.8
Backup Fuel Spot fuel price ($/MMBTU HHV)
Date and time submitted by EcoEléctrica |  |  | 05/04/01 8:20 am
Submitted by (EcoEléctrica) |  |  | [NAME], Plant Manager
Received by (PREPA)
Distribution:
PREPA |  |  | EcoEléctrica
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
 |  |  | J. Sanabria
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | D. Master
Spreadsheet: 99558d1298172710-excel-2007-two-formula-in-pivot-table-column-test5
Sheet: Summary

 |  |  |  |  |  |  |  |  | Date | T# | Length of Outage | Issue | Site | Unit | Agents Impacted | Prod Hours
Date | (All) |  |  |  |  |  |  |  | 2011-01-07 00:00:00 | 19291386 | 00:40:00 | Power Outage | New York | Preassembly | 8 | 5.33336
Site | (All) |  |  |  |  |  |  |  | 2011-01-07 00:00:00 | 19291386 |  | Power Outage | New York | Assembly | 4 | 2.66668
Unit | (All) |  |  |  |  |  |  |  | 2011-01-07 00:00:00 | 19291386 |  | Power Outage | New York | Packaging | 11 | 7.33337
Issue | (All) |  |  |  |  |  |  |  | 2011-01-15 00:00:00 | 19354991 | 01:10:00 | [NAME] welder | New Mexico | Preassembly | 27 | 8.3750125
 |  |  |  |  |  |  |  |  | 2011-01-15 00:00:00 | 19354991 |  | [NAME] welder | New Mexico | Assembly | 10 | 6.52015
 | Values |  |  |  | Ticket # | Length of Outage |  |  | 2011-01-15 00:00:00 | 19354991 |  | [NAME] welder | New Mexico | Packaging | 13 | 8.7491
Ticket # | Total Agents Impacted | Total Prod Hours |  |  | 19291386 | 00:40:00 |  |  | 2011-01-21 00:00:00 | 19365847 | 00:30:00 | [NAME] pallet jack | New Mexico | Packaging | 10 | 5.25
19291386 | 23 | 15.33341 |  |  | 19354991 | 01:10:00 |  |  | 2011-01-30 00:00:00 | 19365928 | 02:10:00 | Defective bolts | Iowa | Assembly | 12 | 6.48
19354991 | 50 | 23.6442625 |  |  | 19365847 | 00:30:00 |  |  | 2011-01-30 00:00:00 | 19365928 |  | Defective bolts | New York | Assembly | 8 | 4.36
19365847 | 10 | 5.25 |  |  | 19365928 | 02:10:00 |  |  | 2011-01-30 00:00:00 | 19365928 |  | Defective bolts | New Mexico | Assembly | 20 | 10.48
19365928 | 40 | 21.32 |  |  | Grand Total | 04:30:00
Grand Total | 123 | 65.5476725
Spreadsheet: 480646d1474011596-comparing-2-workbooks-looking-for-differences-in-quatities-example2
Sheet: Sheet2

File Name | Quantity | Mass
Washer DIN  125A(    M5) | 100 | 0
Washer DIN  127B(    M5) | 36 | 0
[NAME]) | 36 | 0
Nut DIN  934(    M6 A2) | 32 | 0
[NAME](    M4x_8 ) | 26 | 0
Washer DIN  125A(    M8) | 16 | 0
Washer DIN  125A(    M6) | 16 | 0
[NAME](  M6x20) | 16 | 0.01
[NAME]912(M6x30 A2) | 16 | 0.01
[NAME](  [NAME]) | 16 | 0.01
[NAME](    M5x12) | 10 | 0
Nut DIN  934(    M8) | 8 | 0.01
[NAME]  912(M8x70 A2) | 8 | 0.03
[NAME]. 35(M10x80) | 8 | 0.06
Spreadsheet: 390806d1429770181-showing-unique-digits-only-formula
Sheet: Sheet1

 | Input |  | output should be like this
 | A_5 |  | A_5 |  |  |  |  |  | A_5 | A_5
 | A_2 |  | A_2 |  |  |  |  |  | A_2 | A_2
 | A_3 |  | A_3 |  |  |  |  |  | A_3 | A_3
 | A_2 |  | A_3 |  |  |  |  |  |  | A_2
 | A_2 |  |  |  |  |  |  |  |  | A_2
 | A_3 |  |  |  |  |  |  |  |  | A_3
 | A_3 |  |  |  |  |  |  |  |  | A_3
 | A_5 |  |  |  |  |  |  |  |  | A_5
 | A_6 |  |  |  |  |  |  |  | A_6 | A_6
 |  |  | Duplicates should be removed
Spreadsheet: 06983388-369a-4c45-8485-fcb99c0ed6a6
Sheet: 4ED OUT OF 56

ANON# | RANK
601327 | 6
605370 | 10
605381 | 11
605384 | 14
605388 | 3
605401 | 5
605422 | 12
605432 | 13
605445 | 4
605456 | 8
605458 | 7
605463 | 1
605538 | 2
605796 | 9
Spreadsheet: 869788d1716357748-average-skipping-every-other-column-averege-column-skip-help
Sheet: Sheet1

 |  |  |  |  | Current
 |  |  |  |  | Case Cost Average | Each Cost Average
Item Name | Product Number | Pack | Size | Unit |  |  |  | Item Name | Product Number | Pack | Size | Unit | Case Cost | Each Cost
Generic Item 1 | 123456 | 6 | 32 | oz |  |  |  | Generic Item 1 | 123456 | 6 | 32 | oz | 0 | 0
Generic Item 2 | 123457 | 4 | 1 | gal |  |  |  | Generic Item 2 | 123457 | 4 | 1 | gal | 14.75 | 3.69
Generic Item 3 | 123458 | 12 | 32 | oz |  |  |  | Generic Item 3 | 123458 | 12 | 32 | oz | 3.03 | 0.25
Generic Item 4 | 123459 | 12 | 32 | oz |  |  |  | Generic Item 4 | 123459 | 12 | 32 | oz | 6.26 | 0.52
Generic Item 5 | 123460 | 6 | 32 | oz |  |  |  | Generic Item 5 | 123460 | 6 | 32 | oz | 4.66 | 0.78
Generic Item 6 | 123461 | 6 | 2 | lbs |  |  |  | Generic Item 6 | 123461 | 6 | 2 | lbs | 13.58 | 2.26
Generic Item 7 | 123462 | 48 | 1 | ea |  |  |  | Generic Item 7 | 123462 | 48 | 1 | ea | 0 | 0
Generic Item 8 | 123463 | 12 | 1 | ea |  |  |  | Generic Item 8 | 123463 | 12 | 1 | ea | 6.93 | 0.58
Generic Item 9 | 123464 | 12 | 1 | ea |  |  |  | Generic Item 9 | 123464 | 12 | 1 | ea | 3.47 | 0.29
Generic Item 10 | 123465 | 12 | 1 | ea |  |  |  | Generic Item 10 | 123465 | 12 | 1 | ea | 0 | 0
Generic Item 11 | 123466 | 24 | 1 | ea |  |  |  | Generic Item 11 | 123466 | 24 | 1 | ea | 2.45 | 0.1
Generic Item 12 | 123467 | 1 | 1 | cs |  |  |  | Generic Item 12 | 123467 | 1 | 1 | cs | 32.13 | 32.13
Generic Item 13 | 123468 | 4 | 12 | pk |  |  |  | Generic Item 13 | 123468 | 4 | 12 | pk | 31.2 | 7.8
Generic Item 14 - manually calculated | 123469 | 7 | 1 | ea |  |  |  | Generic Item 14 - manually calculated | 123469 | 7 | 1 | ea | 11.65 | 1.66
Generic Item 15 - manually calculated | 123470 | 1 | 1 | cs |  |  |  | Generic Item 15 - manually calculated | 123470 | 1 | 1 | cs | 5.57 | 5.57
Spreadsheet: 108055d1305153817-excel-2007-if-formula-attendance-tracking-master
Sheet: Attendance Infraction Input

 |  | Manufacturing   Department # 00000
 |  | [NAME] |  |  |  |  |  |  |  |  |  | Current Status
 | Month | Date | Employee Name | Employee # | Infraction | Infraction Code | Severity | # of Infractions | # Days Since Last Infraction | Action Required? |  | Action to be Taken | Action taken on:
 |  |  | Employee Master List |  | Infraction List |  |  |  |  |  |  | Actions
 |  | 2011-04-01 00:00:00 | Test 1 |  | Early Departure
 |  | 2011-04-11 00:00:00 | Test 3 |  | No Show
 |  | 2011-06-05 00:00:00 | Test 1 |  | No Call/No Show |  |  | 1
 |  | 2011-06-09 00:00:00 | Test 3 |  | Late Arrival
 |  | 2011-06-12 00:00:00 | Test 2 |  | No Call/No Show
 |  | 2011-06-13 00:00:00 | Test 3 |  | Early Departure
 |  | 2011-06-14 00:00:00 | Test 8 |  | No Call/No Show
 |  | 2011-06-15 00:00:00 | Test 2 |  | No Call/No Show
 |  | 2011-06-16 00:00:00 | Test 3 |  | Late Arrival
 |  | 2011-06-17 00:00:00 | Test 4 |  | Early Departure
 |  | 2011-07-12 00:00:00 | Test 3 |  | No Call/No Show
 |  | 2011-08-02 00:00:00 | Test 1 |  | No Call/No Show
 |  | 2011-09-12 00:00:00 | Test 7 |  | Early Departure
 |  | 2011-10-02 00:00:00 | Test 1 |  | Late Arrival
 |  | 2011-10-04 00:00:00 | Test 3 |  | Late Arrival
 |  | 2011-10-09 00:00:00 | Test 3 |  | No Show
 |  | 2011-10-11 00:00:00 | Test 13 |  | No Call/No Show
 |  | 2011-10-12 00:00:00 | Test 5 |  | Late Arrival
 |  | 2011-10-16 00:00:00 | Test 13 |  | Early Departure
 |  | 2011-10-20 00:00:00 | Test 5 |  | No Call/No Show
 |  | 2011-10-22 00:00:00 | Test 4 |  | No Show
 |  | 2011-10-25 00:00:00 | Test 8 |  | Late Arrival
Spreadsheet: 376393d1423587786-project-time-log-dummy-template-ndmv2
Sheet: Résumé Annuel

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Liste des tâches R&D |  | Liste des projets R&D
 | Temps cumulé par projet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 1 |  | Project 1
 | Projet | [NAME] | [NAME] | Mars | Avril | Mai | [NAME] | Juillet | [NAME] | Septembre | Octobre | Novembre | Décembre | Total [NAME] |  |  | Task 2 |  | Project 2
 | Project 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | task 3 |  | Project 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 4 |  | Project 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 5 |  | Project 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 6 |  | Project 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 7 |  | Project 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 8 |  | Project 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 9 |  | Project 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 10 |  | Project 10
Spreadsheet: 330087d1404521443-comparing-cells-with-a-reference-source-and-skip-blanks-excelforummergedcellsformula-2014-07-04-20-28
Sheet: Sheet1

 |  |  | Problem |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Problem explanation
 |  |  | BATCH NO.: |  |  |  | 4021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case 1
 |  |  |  |  |  |  |  |  |  |  | REMARKS |  |  |  |  |  |  |  |  |  |  |  |  | Value |  |  |  | Value |  |  |  | Judge
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1234 |  |  |  | 5678 |  |  |  | Judge
 |  |  | 1234 |  |  |  | 5678 |  |  |  | Judge
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  | -
 |  |  | - |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  | 1234 |  |  |  | 5678 |  |  |  | OK
 |  | Case 1 | 1234 |  |  |  | 5678
 |  | Case 2 | 4021 |  | 4021 |  |  |  |  |  | NG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BATCH NO.: |  |  |  | 4021
 |  | Case 3 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4021 |  | 4021 |  |  |  |  |  | NG
 |  |  | Specification
 |  |  | 6 | to | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Case 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | 7 |  |  |  | OK
Spreadsheet: 721353d1614673677-how-to-import-particular-columns-from-different-workbook-source-2
Sheet: Data

 |  |  |  |  |  |  |  | Common across the workbook
 | Description | Product | Person | Result
 | 2020-01-20/AF/TES-[PHONE] ZYP0-Critical Instructions | Y | Mich
 | 2020-02-02/AF20/TES-[PHONE] ZYP0-Normal Query | U | Leya
 | 2021-01-20/BST2090/TES-[PHONE] ZYP0-Fiber Quotas | I | [NAME]
 | 2021-01-20/BST2090/AQX-CHK8385343 ZYPX-Olive Box | O | George
 | 2021-01-20/BST2090/BAS-CHK8395240 ZYPY-Levers | P | George
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: DEN-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM)
REGION: DENVER
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: jeffrey_a_shankman__13924__GLOBAL PRODUCTS CRUDE DEAL COUNT & VOL EM
Sheet: Sheet1

2000-01-01 00:00:00
2000-02-01 00:00:00
2000-03-01 00:00:00
2000-04-01 00:00:00
2000-05-01 00:00:00
2000-06-01 00:00:00
2000-07-01 00:00:00
2000-08-01 00:00:00
2000-09-01 00:00:00
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
Spreadsheet: 850934d1701242827-extracting-average-demand-periods-from-start-and-duration-data-example-1-1-ng-
Sheet: Sheet1

Ticket | Location | Day of the week | Date | Start time | End time | Duration
SCTASK0218061 - RITM0498239 - AV Event Support: Farewell event for CIO | Great Hall | Tue | 2023-01-24 00:00:00 | 15:30:00 | 19:00:00 | 3.5 hours
SCTASK0219095 - RITM0488477 - AV Event Support: TSS Launch | D18-03-321 | Mon | 2023-01-30 00:00:00 | 09:00:00 | 12:00:00 | 3 hours
SCTASK0219155 - Event functionality check | ABS B2010 | Mon | 2023-01-30 00:00:00 | 09:00:00 | 10:00:00 | 1 hour
SCTASK0219185 - RITM0496023 EVENT SUPPORT - Peer Mentoring Symposium | ABS B2010 | Tue | 2023-01-31 00:00:00 | 07:30:00 | 17:30:00 | 10 hours
SCTASK0219187 - RITM0496023 EVENT SUPPORT - Peer Mentoring Symposium | ABS B2010 | Tue | 2023-01-31 00:00:00 | 07:30:00 | 17:30:00 | 10 hours
SCTASK0219186 - RITM0496023 EVENT SUPPORT - Peer Mentoring Symposium | ABS B2010 | Tue | 2023-01-31 00:00:00 | 07:30:00 | 17:30:00 | 10 hours
SCTASK0219476 - RITM0504354 - AV Event Support: Reconciliation, Opportunities, Wellbeing of First Nations People Workshop | CPC Mckenzie room 6102 | Thu | 2023-02-02 00:00:00 | 08:00:00 | 17:00:00 | 9 hours
SCTASK0219149 - RITM0498139 - AV Event Support: Sydney Ideas: War in Ukraine | A02-02-200 - SSB Lecture Theatre 200 | Thu | 2023-02-02 00:00:00 | 12:00:00 | 21:00:00 | 9 hours
SCTASK0219147 - RITM0498139 - AV Event Support: Sydney Ideas: War in Ukraine | A02-02-200 - SSB Lecture Theatre 200 | Thu | 2023-02-02 00:00:00 | 12:00:00 | 21:00:00 | 9 hours
SCTASK0219153 - RITM0498139 - AV Event Support: Sydney Ideas: War in Ukraine | A02-02-200 - SSB Lecture Theatre 200 | Thu | 2023-02-02 00:00:00 | 12:00:00 | 21:00:00 | 9 hours
 |  |  | [NAME] | Hans
 |  |  |  | solution without LAMBDA |  |  |  | NOTES:
 |  |  |  |  |  |  |  | Table top left is a sample of the data.
24 Hr Time | Tally |  |  |  |  |  |  | A14 to A39 shows the information I need to derive. 24hr time with a tally of how many support shifts included that hour.
0 |  |  |  |  |  |  |  | The rows hightlighted in Yellow I have manually processed, applying a 1 value next to the corresponding 24hr time and a .5 for shifts that begin or end on the half hour.
1 |  |  | 0
2 |  |  | 0
3 |  |  | 0
4 |  |  | 0
5 |  |  | 0
6 |  |  | 0
7 | 0.5 |  | 1.499999999999999
8 | 1 |  | 4.000000000000002
9 | 3 |  | 6.000000000000003
10 | 2 |  | 4.999999999999996
11 | 2 |  | 5.000000000000002
12 | 1 |  | 6.999999999999994
13 | 1 |  | 7.000000000000012
14 | 1 |  | 6.999999999999994
15 | 1.5 |  | 7.499999999999992
16 | 2 |  | 8.000000000000014
17 | 1.5 |  | 5.499999999999991
18 | 1 |  | 3.999999999999996
19 |  |  | 3.000000000000005
20 |  |  | 2.999999999999997
21 |  |  | 0
22 |  |  | 0
23 |  |  | 0
24 |  |  | 0