tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 583227d1532331569-dependent-drop-down-or-vlook-ups-to-be-used-for-multiples-data-interconnected-rough-page-1
Sheet: BASED AT

INITIAL LIST | BRAND LOGO NEON FOR TERRACE |  | URINAL POTS |  | LAPTOP |  | FAKE NOTE DETECTOR MACHINE |  | Q MANAGERS |  | UPS 05KVA
BRAND LOGO NEON FOR TERRACE | KALARTHI ADVERTISING | UDAIPUR | R K ENTP | UDAIPUR | MAHAVIR ELECTRONICS LTD | DELHI | INFRES METHODEX SYSTEM | AHMEDABAD | VISION DISPLAY PVT LTD |  | SERVOKON SYSTEMS PVT LTD
URINAL POTS | FUNCTION NEON | MUMBAI | BLUESTAR POLYMERS | UDAIPUR | AEVA INFOSOLUTION LTD | DELHI | SHINE INTERNATIONAL | AHMEDABAD | ARHAM TRADER |  | OFFCON SYSTEMS PVT LTD
LAPTOP | BRILLIANT NEON | MUMBAI | THE BATH STUDIO LLP | UDAIPUR | ALPHA SHOPE | DELHI | IKON ELECTRONICS | AHMEDABAD | ZAF ENTP |  | UNITECH POWER SOLUTIONS
FAKE NOTE DETECTOR MACHINE | SIGMA ENTP | MUMBAI | BATH & CRAFTS | MUMBAI | SHYAM INFO SOLUTIONS | DELHI | KNIGHT SUN IMPEX PVT LTD | AHMEDABAD | SMARTECH SAFETY SOLUTION |  | SOCOMEC INNOVATIVE
Q MANAGERS | AKSHAR NEON SIGN | MUMBAI | WEST COAST ENTP | MUMBAI | EMERGING TECHNO KART | RAJKOT | [NAME] | UDAIPUR | ANMOL SALES CORP |  | QUANTAM POWER
UPS 05 KVA | ADGLO NEON SIGN | MUMBAI | NATURE CARE SOLUTIONS | MUMBAI | HINDUSTAN BUSINESS TECHNOLOGIES | RAJKOT | SU-TAX AUTOMATION | UDAIPUR | EURONICS IND LTD |  | ARZOO ENERGY
 | R F SIGNAGES | MUMBAI | IMPEX SANITATION | AHMEDABAD | CLODTECH COMPUTERS | RAJKOT | ORBIT ELECTRONICS | MUMBAI | SCOPE INDUSTRIAL PRODUCTS |  | TIRUPATHI AGENCIES
 | [NAME] | AHMEDABAD | JAI SABHAV IND | AHMEDABAD | ALICE COMPUTERS | AHMEDABAD | SHREE SWAMI SAMARTH ENTP | MUMBAI | SIGNTRADE |  | SARVOSTAR INDIA PVT LTD
 | ELITE SIGNS | AHMEDABAD | [NAME] | AHMEDABAD | PRATHAM INFOTECH | AHMEDABAD | [NAME] | MUMBAI | NEW KANWAL ENGG WORKS |  | SAIKRIPA SALES
 | PAYAL NEON SIGNS | AHMEDABAD | RUSHABH ENTP | SURAT | Z-TECH SOLUTIONS | AHMEDABAD | SYSTEMATIKS | DELHI | ORCHIDS ENTP |  | BVM TECHNOLOGIES PVT LTD
 | MIHIR NEON SIGNS | AHMEDABAD | DIVYANI ENTP | SURAT | NIKHIL COMPUTERS | UDAIPUR | PRIYA ELECTRICALS | DELHI | ORIENTAL ENTP |  | V TECH POWER SYSTEMS
 | [NAME] | AHMEDABAD | SENSOWARE PVT LTD | SURAT | GOMAX NETWORKS | MUMBAI | KRONE ENTP | DELHI | CHARU ENTP |  | POWER ONE MICRO SYSTEMS
 | BRIGHT NEON | AHMEDABAD | SHIVLAXMI ENTP | RAJKOT | SHREE COMPUTERS | MUMBAI | GANAK DIGITECH | DELHI | J.D ENG WORKS |  | SB POWER CONVERSION
 | NIKI SIGNAGES | SURAT | CHAKRA CERAMICS | RAJKOT | SVS TECHNOLOGIES | MUMBAI | MAYANK IMPACT | SURAT | H2 SAFTEY PVT LTD |  | R.D ELECTRIC WORKS
 | SAIFEE SIGNS | SURAT
 | GLOW SIGN | SURAT
 | PARTH NEON SIGN | RAJKOT
 | BASIC SIGN | RAJKOT
 | DIGITAL SIGNAGE | RAJKOT
 | S ART | RAJKOT
 | TAPAS SIGNAGE | DELHI
 | TULSI NEON SIGN | DELHI
 | SIGNAGE WORK SOLUTION | DELHI
 | PEARL SIGN BOARD | DELHI
 | [NAME] SIGNS | DELHI
 | ABSOLUTE NEON SIGNS | DELHI
Spreadsheet: 858602d1707230769-getting-price-using-multiple-reference-points-test-1
Sheet: Mon

Job No. | CreatedDate | Sender | Consignee | Consignee Post Code | Service | Pallets | Customer Reference | Zone | Eco Full Pallets | Eco Half Pallets | Full Pallets | Half Pallets | Quarter Pallets | Delivery Cost | Supplementary Charges | Total Delivery Charge | Difference | Total Delivey Cost Excluding Extras |  | Total Difference |  | Total Pallets |  | 60 | 1 | Local
83816956 | [NAME] | Polyseam Limited | Safestore | PL6 8LH | ND | 2 | SO/49912-DN60027 | 12 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  | ec | 2 |  | Local | 1 | 1
Spreadsheet: 22006d1210336519-pull-numbers-only-from-a-column-containing-both-numbers-and-text-number-pull-sample02
Sheet: CP HP

Service Order | Brand | Model | Department | Serial # | [NAME] | Class | Last Name | SubClass
00008-943208891 | HEWLETT-PACKARD | EZ580UA | COMPUTERS | CND62813S9 | 01320.WIP.328.5 | MOBILE COMPUTING | 8 | NOTEBOOKS
00265-943047897 | Hewlett-Packard | PX343UA#ABA | COMPUTERS | CND5190G5T |  | MOBILE COMPUTING | 265 | NOTEBOOKS
00429-943228928 | Compaq | EZ429UA | COMPUTERS | CND62818KQ |  | MOBILE COMPUTING | Aldrich | NOTEBOOKS
00158-943219073 | HEWLETT-PACKARD | GS803UA | COMPUTERS | CNF7394RQ9 |  | MOBILE COMPUTING | [NAME] | NOTEBOOKS
00284-943292235 | Compaq | PX333UA#ABA | COMPUTERS | CNF5161CP1 |  | MOBILE COMPUTING | Anglin | NOTEBOOKS
Spreadsheet: eric_saibi__9964__110901R
Sheet: Ormond Beach 02

Owner Name |  | Reliant Energy Ormond Beach LLC
Station Name |  | Ormond Beach Power Station
Unit Name |  | Ormond Beach 02
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 806 MW
Start Date |  | 2001-10-23 00:00:00
End Date |  | 2001-11-11 00:00:00
Prv. Start Date |  | 2001-10-23 00:00:00
Prv. End Date |  | 2001-11-09 00:00:00
Comments |  | They are hoping to have the unit by Sunday.
SIC |  | 4931
Plant ID |  | 1013123
Unit ID |  | 1006709
Outage ID |  | 18710
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 3 MONTHS ENDED 3-31-2000
PREPARED BY:  ROSALYN LUM |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
EXTENSION: [PHONE]
 |  | 12-31-99 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash (Pd) / Rec'd |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 780581d1652564729-calculate-hours-worked-at-day-rate-and-night-rate-minus-breaks-example-schedule
Sheet: Daily Rota

Name | Start | End | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours
Staff Member 1 | 20:00:00 | 07:00:00 |  | 5 | 6 | 1.5 |  |  | Break Rules 4 hours or more but <6 hours = 15 minutes 6 hours or more but <8 hours = 30 minutes 8 hours or more but <9 hours = 45 minutes 9 hours or more but <11 hours = 1 hour 11 hours or more = 90 minutes
Staff Member 2 | 1900-01-01 00:00:00 | 05:30:00 |  | 5 | 0.5 | 0.25
Staff Member 3 | 20:00:00 | 08:00:00 |  | 5 | 7 | 1.5
Staff Member 4 | 08:00:00 | 17:00:00 |  | 0 | 9 | 1
Total Hours
Spreadsheet: mary_fischer__25630__1581 - 2001
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 0d20c567-b7df-4333-b349-4839da5ef6a4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | STRUKTUR KOMISI KEPEMUDAAN KEUSKUPAN BANJARMASIN | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30
 |  |  |  |  |  | PERIODE 2010 - 2012
 |  |  |  |  |  |  |  |  |  |  |  |  | KETUA
 |  |  |  |  |  |  |  |  |  |  |  |  | Rm. Petrus Prillion, MSF
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BENDAHARA
 |  |  |  |  |  | Yulius Jumiko |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Pratama
 |  |  |  |  |  | Yohanes [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yohanes Rudini
 | DIVISI |  |  |  |  |  |  |  |  |  | DIVISI |  |  |  |  |  |  |  |  |  | DIVISI |  |  |  |  |  |  |  |  | DIVISI
 | LITBANG |  |  |  |  |  |  |  |  |  | HUMAS |  |  |  |  |  |  |  |  |  | PERAYAAN |  |  |  |  |  |  |  |  | PEMBERDAYAAN
 | Dionisius Agus Puguh Santosa |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Robertus Happy [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  | Yohanes Rudini / Yulius Dwi S. |  |  |  |  |  |  |  |  |  | Christina Retno Kusumaningrum |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Yosephine Laura |  |  |  |  |  |  |  |  | Albertus Siswadi Karta
 | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Meisinta Florentina |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Antonius Tulus Siagian
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meika |  |  |  |  |  |  |  |  | Marianus [NAME]
 | Albertus Bambang Utoyo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yohanes Purwadi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yustinus [NAME]
Spreadsheet: 789464d1659105551-formula-to-make-one-column-data-from-multi-columns-data-sample-file-5-1-
Sheet: Sheet2

Column1 | Column2 | Column3 | Column4 | Column5 |  |  | Value
1 | 11 | 21 | 31 | 41 |  |  | 1
2 | 12 | 22 | 32 | 42 |  |  | 2
3 | 13 | 23 | 33 | 43 |  |  | 3
4 | 14 | 24 | 34 | 44 |  |  | 4
5 | 15 | 25 | 35 | 45 |  |  | 5
6 | 16 | 26 | 36 | 46 |  |  | 6
7 | 17 | 27 | 37 | 47 |  |  | 7
8 | 18 | 28 | 38 | 48 |  |  | 8
9 | 19 | 29 | 39 | 49 |  |  | 9
10 | 20 | 30 | 40 | 50 |  |  | 10
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 13
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 16
 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 18
 |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 21
 |  |  |  |  |  |  | 22
 |  |  |  |  |  |  | 23
 |  |  |  |  |  |  | 24
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  | 26
 |  |  |  |  |  |  | 27
 |  |  |  |  |  |  | 28
 |  |  |  |  |  |  | 29
 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | 31
 |  |  |  |  |  |  | 32
 |  |  |  |  |  |  | 33
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 36
 |  |  |  |  |  |  | 37
 |  |  |  |  |  |  | 38
 |  |  |  |  |  |  | 39
 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  | 41
 |  |  |  |  |  |  | 42
 |  |  |  |  |  |  | 43
 |  |  |  |  |  |  | 44
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 46
 |  |  |  |  |  |  | 47
 |  |  |  |  |  |  | 48
 |  |  |  |  |  |  | 49
 |  |  |  |  |  |  | 50
Spreadsheet: 678319d1589818381-index-match-cos_excel-help-1-
Sheet: Order

 | Sales person fills these in |  |  | This needs to be pulled in based on column B from COS tab
 | NAAB | Units | Price | COS | All from the COS tab
 | 001JE00992 | 10 | 15 |  | This is from column F
 | 501JE00992 | 10 | 25 |  | This is from column G
 | 601JE00992 | 10 | 35 |  | This is from column H
 | 001HO13411 | 10 | 20 |  | This is from column F
 | 001HO14138 | 10 | 30 |  | This is from column F
 | 001HO11953 | 10 | 5 |  | This is from column F
 | 501HO13411 | 10 | 25 |  | This is from column G
 | 501HO14138 | 10 | 35 |  | This is from column G
 | 501HO11953 | 10 | 20 |  | This is from column G
 | 601HO13411 | 10 | 40 |  | This is from column F
 | 601HO14138 | 10 | 45 |  | This is from column F
 | 601HO11953 | 10 | 30 |  | This is from column F
Spreadsheet: 881806d1729993726-how-to-have-return-results-of-a-function-split-across-multiple-lines-testfile
Sheet: Single Job Lookup

Job #:
Date | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME]
2023-08-10 00:00:00 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL
Agent | Agent Total Chgs | Carrier | Ocean Freight (Collect) | VGM/Solas (weighing)Handling Fee | FOB | Liability | Wharfage Tax | Warehouse Charge | AMS Security Fee | ISF 10+2 | THC/ Handling @ Origin | Pick-up/ Trucking Charge | [NAME]
AGT-2 | 1016.48 | ZIM | 285.13 | 37.32 | 136.44 | 6.93 | 0 | 12.06 | 100.65 | 85.52 | 154.4 | 188.6 | 9.43
Co-Loader | Co-Loader Total Chgs: | THC/ Origin HC | Stripping | Stripping Charge | [NAME] | I.T. Prep | Chassis Usage/ Suchg (CUC) | Equip Schg | Low Sulfur or [NAME] | CFS Fuel Schg | CFS/Port Sec I.S.P.S. Fee
CoLoad-1 | 270 | 50 | 0 | 25 | 55 | 35 | 15 | 10 | 0 | 35 | 45
CFS Location | Total CFS Charges: | CFS Charge | Handling Fee | CUCC Collect
CFS-2 | 255 | 255 | 0 | 0
Spreadsheet: 266186d1379520530-copying-a-specific-row-from-another-sheet-depending-on-a-cell-value-week-dates
Sheet: Data

40 | 2013-09-30 00:00:00
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Spreadsheet: 201233d1355926851-use-time-data-from-an-exported-report-in-a-formula-not-working-forum-help
Sheet: Sheet1

StartTime | EndTime
13-12-2012 08:11:42 | 13-12-2012 08:12:46
13-12-2012 08:15:20 | 13-12-2012 08:16:12
13-12-2012 08:18:49 | 13-12-2012 08:19:42
13-12-2012 08:19:43 | 13-12-2012 08:19:48
13-12-2012 08:26:29 | 13-12-2012 08:27:40
13-12-2012 08:48:03 | 13-12-2012 08:50:05
13-12-2012 09:14:50 | 13-12-2012 09:17:15
13-12-2012 10:20:22 | 13-12-2012 10:22:14
13-12-2012 10:24:27 | 13-12-2012 10:25:36
13-12-2012 10:55:56 | 13-12-2012 10:57:42
13-12-2012 10:57:43 | 13-12-2012 10:58:31
13-12-2012 11:12:22 | 13-12-2012 11:13:32
13-12-2012 11:13:33 | 13-12-2012 11:14:55
13-12-2012 11:52:40 | 13-12-2012 11:58:44
 | 13-12-2012 11:58:44
13-12-2012 12:09:38 | 13-12-2012 12:10:47
13-12-2012 12:15:41 | 13-12-2012 12:21:26
 | 13-12-2012 12:21:26
13-12-2012 12:21:28 | 13-12-2012 12:27:16
 | 13-12-2012 12:27:16
13-12-2012 12:27:18 | 13-12-2012 12:33:10
 | 13-12-2012 12:33:10
13-12-2012 12:33:11 | 13-12-2012 12:39:23
 | 13-12-2012 12:39:23
13-12-2012 12:39:24 | 13-12-2012 12:45:34
 | 13-12-2012 12:45:34
13-12-2012 12:45:35 | 13-12-2012 12:52:07
 | 13-12-2012 12:52:07
13-12-2012 12:52:08 | 13-12-2012 12:58:01
 | 13-12-2012 12:58:01
13-12-2012 12:58:03 | 13-12-2012 13:04:00
 | 13-12-2012 13:04:00
13-12-2012 13:04:01
13-12-2012 13:15:40 | 13-12-2012 13:21:47
 | 13-12-2012 13:21:47
13-12-2012 13:21:48 | 13-12-2012 13:27:58
 | 13-12-2012 13:27:58
13-12-2012 13:27:59 | 13-12-2012 13:33:49
 | 13-12-2012 13:33:49
13-12-2012 13:33:50 | 13-12-2012 13:39:47
 | 13-12-2012 13:39:47
13-12-2012 [NAME] | 13-12-2012 13:46:23
 | 13-12-2012 13:46:23
13-12-2012 13:52:30 | 13-12-2012 13:53:23
13-12-2012 14:04:05 | 13-12-2012 14:05:34
13-12-2012 14:05:35 | 13-12-2012 14:06:57
13-12-2012 15:06:29 | 13-12-2012 15:08:51
13-12-2012 16:01:45 | 13-12-2012 16:04:00
Spreadsheet: 268479d1380651290-finding-total-for-individuals-by-monthly-tab-and-unit-counts-bsr-teams-2013
Sheet: Jun

Daily Locked & Funded Loans AS 06/28/2013
 | Wholesale |  |  |  | Correspondent
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded | Daily Locked | Active Locked | Daily Purchased | MTD Purchased
[NAME] | $450,500 (2) | $9,279,450 (27) | $481,000 (2) | $9,511,575 (26) | - | - | - | -
[NAME] | - | $4,552,200 (15) | - | $11,471,250 (36) | - | - | - | -
[NAME] | $1,008,000 (3) | $8,147,185 (26) | $348,750 (1) | $7,478,000 (23) | - | - | - | -
[NAME] | - | $6,035,350 (19) | $617,000 (2) | $5,602,200 (15) | - | - | - | -
[NAME] | $557,000 (2) | $13,736,667 (38) | $160,000 (1) | $13,467,750 (38) | - | - | - | -
[NAME] | $760,000 (2) | $10,458,000 (27) | - | $8,170,750 (22) | - | - | - | -
[NAME] | $473,000 (2) | $13,101,170 (51) | $1,185,950 (3) | $20,788,000 (67) | - | - | - | -
[NAME] | - | $2,056,500 (6) | $470,400 (1) | $6,949,397 (22) | - | - | - | -
[NAME] | $1,292,250 (4) | $35,903,413 (100) | $2,099,000 (6) | $41,371,060 (113) | - | $802,000 (2) | - | $625,500 (1)
[NAME] | $190,000 (1) | $7,841,750 (22) | $337,500 (1) | $12,733,950 (35) | - | - | - | -
Kathi Yelland | - | - | - | $417,500 (2) | - | - | - | -
Kris Varia | $262,500 (1) | $7,359,347 (27) | $367,500 (1) | $5,927,650 (18) | - | - | - | -
[NAME] | - | $4,283,100 (11) | $755,000 (3) | $8,537,475 (24) | - | - | - | -
[NAME] | $1,414,150 (6) | $9,892,650 (28) | $1,042,500 (2) | $16,490,650 (40) | - | - | - | -
[NAME] | - | $4,900,550 (14) | - | $6,850,950 (20) | - | - | - | -
[NAME] | $379,000 (1) | $10,247,200 (29) | $350,000 (1) | $10,536,721 (30) | - | - | - | -
Subtotal | $6,786,400 (24) | $147,794,532 (440) | $8,214,600 (24) | $186,304,878 (531) | - | $802,000 (2) | - | $625,500 (1)
Daily HomeLending / Alan Locked & Funded Loans AS 06/28/2013
 | Retail |  |  |  | -
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded | - | - | - | -
[NAME] | - | $1,016,200 (2) | - | $283,000 (1) | - | - | - | -
Subtotal | - | $1,016,200 (2) | - | $283,000 (1) | - | - | - | -
Daily Locked & Funded Loans AS 06/28/2013
 | Wholesale / Retail |  |  |  | Correspondent
 | Daily Locked | Active Locked | Daily Funded | MTD Funded | Daily Locked | Active Locked | Daily Purchased | MTD Purchased
Total | $6,786,400 (24) | $148,810,732 (442) | $8,214,600 (24) | $186,587,878 (532) | - | $802,000 (2) | - | $625,500 (1)
Spreadsheet: 27301d1220459665-cross-referencing-multiple-names-in-a-table-perm-access-list
Sheet: Daily Cross Referenced 

CR # | First name | Last Name | User Name
Spreadsheet: 802165d1666690508-sum-total-hours-worked-for-each-member-of-staff-based-on-the-period-selected-sumifs-example
Sheet: Data

Year | 22-23 | 22-23 | 22-23 | 22-23 | 22-23 | 22-23 | 22-23 | 22-23 | 22-23
Real Period | Aug-22 | Aug-22 | Aug-22 | Aug-22 | Sep-22 | Sep-22 | Sep-22 | Sep-22 | Sep-22
Week Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Employee
[NAME] | 10 | 15 | 0 | 20 | 38 | 40 | 5 | 10 | 12
[NAME] | 0 | 10 | 35 | 40 | 40 | 35 | 20 | 15 | 15
[NAME] | 40 | 40 | 40 | 40 | 0 | 0 | 40 | 40 | 40
[NAME] | 38.75 | 38.75 | 0 | 0 | 0 | 0 | 0 | 38.75 | 38.75
Jo | 0 | 0 | 20 | 20 | 20 | 20 | 20 | 10 | 10
Spreadsheet: 9f5d407c-35f1-4789-8cee-d5f90c159667
Sheet: SW772

SW | SUV | PS# | Ln | Item | Description | UOM | $ | Cat | Cat Desc
SW772 | OPC | 2969 | 1 |  |  |  | 11.95 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 2 |  |  |  | 11.95 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 3 |  |  |  | 11.95 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 4 |  |  |  | 11.95 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 5 |  |  |  | 11.95 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 9 |  |  |  | 47.01 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 10 |  |  |  | 47.62 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 11 |  |  |  | 49.74 |  | Domestic Disposable Stirrers
SW772 | OPC | 2969 | 12 |  |  |  | 42.81 |  | Domestic Disposable Dishes
SW772 | OPC | 2969 | 13 |  |  |  | 46.58 |  | Domestic Disposable Dishes
SW772 | OPC | 2969 | 14 |  |  |  | 44.39 |  | Domestic Disposable Dishes
SW772 | OPC | 2969 | 15 |  |  |  | 43.34 |  | Domestic Disposable Dishes
SW772 | OPC | 2969 | 16 |  |  |  | 25 |  | Freight Fee
SW772 | OPC | 2969 | 17 |  |  |  | 42.34 |  | Sweeteners
Spreadsheet: 743404d1628483542-how-to-assign-a-random-value-based-on-a-list-assignrandef
Sheet: Data

 |  |  | Employee | Monday | Tuesday | Wednesday | Thursday | Friday |  |  |  |  | Job #
 |  |  | 1 |  |  |  |  |  |  |  |  |  | 101
 |  |  | 2 |  |  |  |  |  |  |  |  |  | 102
 |  |  | 3 |  |  |  |  |  |  |  |  |  | 103
 |  |  | 4 |  |  |  |  |  |  |  |  |  | 201
 |  |  | 5 |  |  |  |  |  |  |  |  |  | 202
 |  |  | 6 |  |  |  |  |  |  |  |  |  | 203
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 204
 |  |  | 8 |  |  |  |  |  |  |  |  |  | 301
 |  |  | Total |  |  |  |  |  |  |  |  |  | 302
 |  |  |  |  |  |  |  |  |  |  |  |  | 303
 |  |  |  |  |  |  |  |  |  |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  |  |  | 305
Spreadsheet: 751705d1634265257-index-match-with-dates-less-than-or-equal-to-sample
Sheet: Sheet1

 | 2021-08-01 00:00:00 | 2021-06-01 00:00:00 | 2021-05-01 00:00:00 | 2021-01-01 00:00:00 | 2020-09-01 00:00:00 | 2020-08-01 00:00:00
Location | 297 | 297 | 297 | 297 | 297 | 297
Ahousat, BC | 3 | 3 | 3 | 3 | 3 | 3
Aklavik, NT | 4 | 4 | 4 | 4 | 4 | 4
Alert, NU | 5 | 5 | 5 | 5 | 5 | 5
[NAME], BC | 2 | 2 | 2 | 2 | 2 | 2
[NAME], BC (incl. [NAME] no 799) | 2 | 2 | 2 | 2 | 2 | 2
Arctic Bay/Ikpiarjuk, NU | 5 | 5 | 5 | 5 | 5 | 5
Arviat, NU | 4 | 4 | 4 | 4 | 4 | 4
Assumption, AB (see Hay Lake Reserve)
Atikameg, AB
[NAME], BC | 2 | 2 | 2 | 2 | 2 | 2
Attawapiskat, ON | 3 | 3 | 3 | 3 | 3 | 3
Baie Verte, NL | 2 | 2 | 2 | 2 | 2 | 2
[NAME], NU | 4 | 4 | 4 | 4 | 4 | 4
[NAME]'s Harbour, NL | 3 | 3 | 3 | 3 | 3 | 3
 | Exact Location match | Left n letters Location match
 |  | 1) First Location match | 2) Last Location match | 3) Sum all Location match
 |  | At | At | A
Date
Value
 | CASE 1 | CASE 2 | CASE 3 | CASE 4
Spreadsheet: 160728d1339175072-assigning-categories-based-on-a-time-stamp-timecategories
Sheet: Data

Time | Category | Data
00:00:01 |  | 86
 |  | 50
 |  | 67
 |  | 91
 |  | 62
 |  | 93
 |  | 19
 |  | 65
 |  | 76
 |  | 24
 |  | 24
 |  | 20
 |  | 98
 |  | 10
 |  | 60
 |  | 3
 |  | 33
 |  | 17
 |  | 16
 |  | 66
 |  | 89
 |  | 22
 |  | 65
 |  | 65
 |  | 71
 |  | 90
 |  | 28
 |  | 89
 |  | 51
 |  | 74
 |  | 89
 |  | 66
 |  | 54
 |  | 53
 |  | 52
 |  | 51
 |  | 50
 |  | 49
 |  | 48
 |  | 47
 |  | 46
 |  | 45
 |  | 44
 |  | 43
 |  | 42
 |  | 41
 |  | 40
 |  | 39
 |  | 38
 |  | 37
 |  | 36
 |  | 35
 |  | 34
 |  | 33
 |  | 32
 |  | 31
 |  | 30
 |  | 29
 |  | 28
 |  | 27
 |  | 26
 |  | 25
 |  | 24
 |  | 23
 |  | 22
 |  | 21
 |  | 20
 |  | 19
 |  | 18
 |  | 17
 |  | 16
 |  | 15
 |  | 14
 |  | 13
 |  | 12
 |  | 11