tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: Lisas mobile

Orange | Lisas Mobile
MONTH | Year | Paymet
2008-01-01 00:00:00 | 2008
2008-02-01 00:00:00 | 2008
2008-03-01 00:00:00 | 2008
2008-04-01 00:00:00 | 2008
2008-05-01 00:00:00 | 2008
2008-06-01 00:00:00 | 2008
2008-07-01 00:00:00 | 2008
2008-08-01 00:00:00 | 2008
2008-09-01 00:00:00 | 2008
2008-10-01 00:00:00 | 2008
2008-11-01 00:00:00 | 2008
2008-12-01 00:00:00 | 2008
2009-01-01 00:00:00 | 2009
2009-02-01 00:00:00 | 2009
2009-03-01 00:00:00 | 2009
2009-04-01 00:00:00 | 2009 | 80.76
2009-05-01 00:00:00 | 2009 | 30.15
2009-06-01 00:00:00 | 2009 | 35.43
2009-07-01 00:00:00 | 2009 | 90.71
2009-08-01 00:00:00 | 2009 | 14.93 | 62.93
2009-09-01 00:00:00 | 2009 | 15 | 30
2009-10-01 00:00:00 | 2009
2009-11-01 00:00:00 | 2009
2009-12-01 00:00:00 | 2009
2010-01-01 00:00:00 | 2010
2010-02-01 00:00:00 | 2010
2010-03-01 00:00:00 | 2010
2010-04-01 00:00:00 | 2010
2010-05-01 00:00:00 | 2010
2010-06-01 00:00:00 | 2010
2010-07-01 00:00:00 | 2010
2010-08-01 00:00:00 | 2010
2010-09-01 00:00:00 | 2010
2010-10-01 00:00:00 | 2010
2010-11-01 00:00:00 | 2010
2010-12-01 00:00:00 | 2010
Spreadsheet: 485419d1476877808-i-need-to-find-a-formula-that-calculates-how-much-time-falls-into-a-certain-criteria-sampel-work-cal-_-as-_-different-options-available
Sheet: AS1

 | Hours of work |  |  | Total | M-F eve | Sat eve | Night | Sunday | Base | M-F eve | Sat eve | Night | Sunday | Total
 | Day | Start time | end time | hours | hours | hours | hours | hours | pay | pay | pay | pay | pay | pay
 |  | 2016-10-15 20:30:00 | 2016-10-16 07:15:00
 |  | 2016-10-16 22:30:00 | 2016-10-17 07:15:00
 |  | 2016-10-17 22:30:00 | 2016-10-18 07:15:00
 |  | 2016-10-18 22:30:00 | 2016-10-19 06:15:00
 |  | 2016-10-20 07:30:00 | 2016-10-20 18:15:00
Spreadsheet: 767618d1644554354-return-numbers-from-a-key-book5
Sheet: Sheet1

 |  |  | Key |  |  |  |  |  |  |  | DATA
 |  | Last Week | 3
 |  |  |  |  |  |  |  | Key | 1 | 2 | 3 | 4 | 5 | 6
 |  | This Week | Last Week |  |  |  |  |  | Week1 | Week2 | Week3 | Week4 | Week5 | Week6
 | Country1 | 100 |  |  |  |  |  | Country1 | 70 | 75 | 77 | 80 | 85 | 90
 | Country2 | 25 |  |  |  |  |  | Country2 | 17.5 | 18.75 | 19.25 | 20 | 21.25 | 22.5
 | Country3 | 34 |  |  |  |  |  | Country3 | 23.8 | 25.5 | 26.18 | 27.2 | 28.9 | 30.6
 | Country4 | 67 |  |  |  |  |  | Country4 | 46.9 | 50.25 | 51.59 | 53.6 | 56.95 | 60.3
 | Country5 | 150 |  |  |  |  |  | Country5 | 105 | 112.5 | 115.5 | 120 | 127.5 | 135
Spreadsheet: 841041d1693299500-how-to-create-vlookup-lists-condition-survey-draft-template
Sheet: Data

Discipline | Series | Description | RSL |  |  |  |  |  |  | Condition
Mechanical | 50 - General Mechanical Services | General Mechanical |  |  |  |  |  |  |  | 1 | Very Good
 |  |  |  |  |  |  |  |  |  | 2 | Good
 |  |  |  |  |  |  |  |  |  | 3 | Acceptable
 |  |  |  |  |  |  |  |  |  | 4 | Poor
 | 52 - Above Ground Drainage Services | Pipework (UPVC) | 30 |  |  |  |  |  |  | 5 | Unserviceable
 |  | Pipework (Cast Iron) | 40
 |  | Drainage Macerator | 10
 |  | Condensate Pipework | 25
 | 53 - Domestic Water Services | Water Meter | 30
 |  | Pipework (Copper) | 25
 |  | Pipework (PVC) | 15
 |  | Cold Water Storage Tank | 25
 |  | [NAME] | 15
 |  | Water Softener | 10
 |  | UV Filter | 10
 |  | Hot Water Storage Calorifier | 15
 |  | [NAME] | 10
 |  | Expansion Vessel | 20
 |  | Valves | 15
 |  | Control Valves | 10
 |  | TMV | 10
 |  | HIU | 15
 |  | [NAME] | 15
 | 54 - Gas Services | Gas Meter | 30
 |  | Pipework | 25
 |  | Gas Booster | 20
 | 55 - Refrigerant Services | Split Outdoor Unit
 |  | VRF Outdoor Unit
 |  | Refrigerant Pipework
 |  | Master BC Controller
 |  | Sub BC Controller
 |  | Wall Mounted Controller
 | 56 - LTHW Services | Air Source Heat Pump | 15
 |  | [NAME] | 20
 |  | Circulation Pump | 15
 |  | Pipework | 25
 |  | Valves | 20
 |  | Control Valves | 15
 |  | Sensors | 10
 |  | Pressurisation Unit | 15
 |  | Dosing Pot | 15
 |  | Air Dirt Separator | 20
 |  | Expansion Vessel | 20
 |  | Low Loss Header | 25
 |  | Plate Heat Exchanger | 15
 |  | Heating Coil | 25
 |  | Radiators | 20
 |  | Fan Convector | 15
 |  | Fan Coil Units | 15
 |  | Radiant Panels | 15
 |  | Trench Heating | 20
 |  | Underfloor Heating Manifold | 20
 | 57 - Ventilation Services | Air Handling Unit | 20
 |  | Extract Fan | 15
 |  | Heat Recovery Unit | 15
 |  | Supply/Extract Grilles | 15
 |  | Filters | 10
 |  | Ductwork (Galvanised) | 25
 |  | Ductwork (Plastic) | 15
 |  | External Louvres | 25
 |  | Attenuators | 20
E | 60 - General Electrical Services
 | 61 - Primary Distribution
 | 62 - Small Power Services
 | 63 - Lighting Services
 | 65 - Telecommunication Services
 | 67 - Security Services
 | 68 - Fire Alarm Services
 | 69 - Lighting Protection Services
 | 90 - External Services
Spreadsheet: 866861d1713786906-displaying-the-true-text-of-indirect-formula-indirect-example2
Sheet: FrontEndCalc

Section | Period | Amount | Amount_2ndExample | Ideal Result from new formula | Ideal Result from 2nd example | OR
Period 1 | JanToMar |  |  |  | if(B2="","",JanToMar_LS*JanToMar_Fac) | JanToMar_LS*JanToMar_Fac
Period 2 | AprToJun |  |  |  | if(B2="","",AprToJun_LS*AprToJun_Fac) | AprToJun_LS*AprToJun_Fac
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 63

कार्यक्रम PROGRAM |  |  | [NAME] में सिंर्ृखि – उच्च सिंर्ेदीकरण कार्यक्रम HI-SENSITIZATION PROGRAM ON AUGMENTING CASA | PROG CODE
 |  |  |  | IT 2305
तर्षर् समूह/SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | CUSTOMER    CENTRICITY,    CUSTOMER    ENGAGEMENT    & ENHANCING CROSS SELLING OPPORTUNITIES
लतक्षि समूह/TARGET GROUP |  |  | MIXED
अर्तध/DURATION |  |  | 1 DAY
DAY | SESSION | CONTENTS
Day 1 | I | Ice  Breaking,  Corporate  Message  &  Expectation  (Pre  Recorded message from Top Management)
 | II | Product Delivery- CASA & Comparison with Peer Banks
 | III | Customer Service Excellence, Sales skills, Cross Selling & Upselling Techniques
 | IV | Ethical Conduct & Negotiation Skills
Spreadsheet: 38416d1236603432-how-do-i-ignore-day-and-only-refer-to-the-the-month-copy-of-monthlysummary
Sheet: Summary

Month | Department A - 1 | Department b - 1 | Department C - 1
2008-01-01 00:00:00 | 7000 | 0 | 0
2008-02-01 00:00:00 | 2000 | 8000 | 0
2008-03-01 00:00:00 | 0 | 0 | 0
2008-04-01 00:00:00 | 6000 | 0 | 4000
2008-05-01 00:00:00 | 0 | 0 | 91000
2008-06-01 00:00:00 | 0 | 0 | 0
2008-07-01 00:00:00 | 2400 | 0 | 0
2008-08-01 00:00:00 | 0 | 0 | 0
2008-09-01 00:00:00 | 50500 | 0 | 0
2008-10-01 00:00:00 | 0 | 600 | 0
2008-11-01 00:00:00 | 0 | 0 | 0
2008-12-01 00:00:00 | 0 | 0 | 0
2009-01-01 00:00:00 | 0 | 0 | 0
 | 67900 | 8600 | 95000
Spreadsheet: 125121d1318883905-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example3
Sheet: Hooker

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES
8964 |  |  | SSS Sig | 2011-10-10 00:00:00 |  | To NELSON 1st for SSS Sig 9/1 | Total # Yellow: | 0
57659 |  |  | D/C Sig | 2011-09-13 00:00:00 |  | ATT/sent to carmen | Total # Orange: | 0
64748 |  |  | D/C Sig | 2011-09-13 00:00:00 |  | DO, ATT  to [NAME] next | Total # Red: | 2
19183 |  |  | DO |  |  | holding chart, need d/c dict | Complient: | 3
22801 |  |  | ATT |  |  | To [NAME] 1st | All Total: | 5
66323 |  |  | DO |  |  | ATT, checked out to [NAME]
73942 |  |  | DO |  |  | ATT, To [NAME] next
79968 |  |  | ATT | 2011-10-11 00:00:00
80303 |  |  | SSS Sig | 2011-10-11 00:00:00 |  | must sign off behind [NAME]
Spreadsheet: 129945d1321982815-excel-2007-conditional-formatting-highligh-based-on-contents-of-multiple-cells-highlighting-problem
Sheet: Sheet1

 | Attr. 1 | Attr. 2 | Attr. 3 | Attr. 4 | Attr. 5
Item 1 | C | V | A | R
Item 2 | C | A | B
Item 3 | B | K | R
Item 4 | K | I
Item 5 | I | V
Item 6 | R | C | B | I | K
Spreadsheet: 132542d1323808780-date-time-function-in-excel-day-month-year-and-time-test
Sheet: Sheet1

Project | Key | Summary | Issue Type | Status | Priority | Resolution | Assignee | Reporter | Created | Updated | Resolved | Total Time (h:[NAME]) | Votes | Images | Original Estimate | Remaining Estimate | Time Spent | Work Ratio | Sub-Tasks | Issue Links | Environment | Description | Security Level | Progress | Σ Progress | Σ Time Spent | Σ Remaining Estimate | Σ Original Estimate | [NAME] | Business Requirement | Proposed Solution | Access by | APAC Country | Keep in SLA ? | Priority Order | Number of comments | Number of attachments | User picker | Solution | Environment | Estimated time | Co-Assignee3 | Co-Assignee4 | Actual Time spent | PlannedEnd | PlannedStart | T.I. Development ? | Gantt | Page | Solution | Justification of priority | Phone Number | Outstanding | Window Login Name | Title | [NAME] | Last Name | [NAME] | Business Impact | Country | Environment | Partner Impacted | Sales Origin | Modified Items | [NAME] Number | Support Tool Bar | First answer date | Last Update by | Request Type | First Name | Channel | Flagged | Effective Date | Epic/Theme | Power User Access? | Rank | Desired date | B2C Group Field | Participants | Reason of Reopening | Days since last comment | Web Site URL | Client Severity
XX | XX | XX | XX | Closed | Minor | XX | XX | XX | 2011-09-12 11:48:00 | 2011-09-12 13:25:00 | 2011-09-12 13:25:00 | 01:37:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  | 1 | 0 |  |  |  |  |  |  |  |  |  | NOT APPLICABLE |  |  | B2C |  |  | NO
Spreadsheet: 81459d1281625604-to-assign-macro-to-the-button-to-insert-rows-shift-cells-down-insert-row
Sheet: Sheet1

 |  |  | BEFORE CLICK
 | Items to Stock form
 | Product code | Colour | No. of batches | Quantity packed | Product date | Batch code | Serial number | Finished?
 |  |  | AFTER CLICK
 | Product code | Colour | No. of batches | Quantity packed | Product date | Batch code | Serial number | Finished?
 | So, with every click of "ADD LINE" button I need a row to appear. NOTE: "ADD LINE" button assigned to one product only. There are going to be up to 20 products (see Sheet3)
Spreadsheet: 762932d1641910845-cond-formatting-first-monday-on-the-month-sddo-vacation-tracker-2023
Sheet: Jan

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative | T
Compressed Day / Journée comprimée
Assignment / Left
Half Day / Demie Journée
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
January | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 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 |  | Replaced by:
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
(Vacant CS-03)
[NAME]
[NAME]
[NAME]
(Vacant team lead)
(Vacant CS-03)
Sameer [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
January Total
Spreadsheet: 84988d1285075376-if-function-cross-workbooks-record-update-21-sep
Sheet: Sheet1

Name | ID | [NAME] | Address | Start Date
Name1 | ID1 | Tel1 | Address1 | 2010-09-04 00:00:00
[NAME] | ID2 | Tel2 | Address2
Name3 | ID3 | Tel3 | Address3
Name4 | ID4 | Tel4 | Address4
Name5 | ID5 | Tel5 | Address5
Name6 | ID6 | Tel6 | Address6
Name7 | ID7 | Tel7 | Address7 | 2010-08-07 00:00:00
Name8 | ID8 | Tel8 | Address8
Name9 | ID9 | Tel9 | Address9
Name10 | ID10 | Tel10 | Address10 | 2010-08-06 00:00:00
Name11 | ID11 | Tel11 | Address11
Name12 | ID12 | Tel12 | Address12 | 2010-09-08 00:00:00
Name13 | ID13 | Tel13 | Address13
Spreadsheet: f39d6837-e0dc-4e81-8b51-a58efb6773d3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Lower Western Shore (MD) for 2010
Indicator | 2010
Chlorophyll a | 1.514
Aquatic Grasses | 9.75
[NAME] | 56.057
[NAME] | 0
Water Clarity | 0
Phytoplankton Index | 13.13
Water Quality Index | 19.19033333
Biotic Index | 7.626666667
Bay Health Index | 13.4085
Spreadsheet: 51318d1250863807-comparing-dates-in-cells-using-if-function-dates
Sheet: Sheet1

Date 1 | Date 2 | Result
[NAME] | [NAME] | 1
[NAME] | [NAME] | 1
01/07/2009 | 26/06/2009
06/04/2009 | 06/04/2009 | 1
08/05/2009 | 08/05/2009 | 1
2009-05-22 00:00:00 | 22/05/2009
10/06/2009 | 30/06/2009
19/06/2009 | 19/06/2009 | 1
11/05/2009 | 27/04/2009
05/06/2009 | 28/05/2009
15/06/2009 | 12/06/2009 | 1
03/06/2009 | 01/06/2009 | 1
03/06/2009 | 28/05/2009
2009-05-12 00:00:00 | 12/05/2009
20/05/2009 | 20/05/2009 | 1
17/06/2009 | 29/05/2009
29/06/2009 | 29/06/2009 | 1
18/06/2009 | 09/06/2009 | 1
23/06/2009 | 16/06/2009 | 1
19/06/2009 | 19/06/2009 | 1
Spreadsheet: 127513d1320385043-conditional-formatting-time-values-si902-2011-11-04
Sheet: Sheet1

Start | Finish | Duration
19:30:00 | 19:34:00
19:44:00 | 19:51:00
20:15:00 | 20:22:00
19:52:00 | 20:07:00
20:05:00 | 20:09:00
22:08:00 | 22:24:00
n/a | n/a
23:58:00 | 00:20:00
00:06:00 | 00:16:00
N/A | Self Deployed
n/a | Self Deployed
04:31:00 | 04:40:00
n/a | Self Deployed
N/A | Self Deployed
n/a | Self Deployed
19:03:00 | 19:18:00
03:14:00 | 03:02:00
Spreadsheet: 761716d1641174055-dynamic-dropdown-in-excel-dnamic-dropdown-1-1-
Sheet: JE

 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | ERP
 |  |  |  |  |  |  |  |  |  | DS
 |  |  |  |  |  | 4 |  |  | 2 |  | 3
Line Items: | Code | key | Account | Currency | Amount | SrcAcct | CC | PC | CoCode | Text | [NAME]
 |  |  |  |  |  | [PHONE] |  |  | 6211
 |  |  |  |  |  | 600515000-11112 |  |  | 5500
 |  |  |  |  |  | [PHONE] |  |  | 3000
Spreadsheet: 153683d1336005325-vlook-up-efficiency-rocket324suggestedsolution
Sheet: DATA_Filter

C# | DRILL | RIG | ALPHA | BETA | GEARS | Cost | MONTH
151320 | 1 | 1 | 38500 | 11550 | 4427.5 | 35420 | JAN
151320 | 1 | 2 | 77000 | 11550 | 4427.5 | 35420 | FEB
151330 | 2 | 2 | 8000 | 56000 | 4427.5 | 35420 | JAN
151330 | 3 | 1 | 72331 | 56000 | 4427.5 | 35420 | FEB
151330 | 3 | 1 | 44345 | 56000 | 4427.5 | 35420 | MAR
151560 | 4 | 1 | 4875 | 11550 | 4427.5 | 35420 | JAN
151560 | 4 | 1 | 4875 | 11550 | 4427.5 | 35420 | FEB
151560 | 4 | 1 | 4875 | 11550 | 4427.5 | 35420 | MAR
151560 | 4 | 1 | 4875 | 11550 | 4427.5 | 35420 | APR
151560 | 4 | 1 | 4875 | 11550 | 4427.5 | 35420 | MAY
151560 | 4 | 1 | 4875 | 11550 | 4427.5 | 35420 | JUN
Spreadsheet: 81284d1281527469-adding-a-computed-column-at-end-for-a-growing-list-using-fn-no-macros-report101
Sheet: Sheet1

StudentName | Marks1 | Marks2 | Marks3 | Marks4 | Marks5 | Marks6
Roshan | 10 | 10 | 10 | 10 | 10 | 10
mark | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  | 517 | 526
[NAME] | 10 | 10 | 10 | 10 | 10 | 10
pete | 20 | 20 | 20 | 20 | 20 | 20
Spreadsheet: 539864d1506412103-sum-using-multipul-vookup-mz-sales-budget-plan-2018-working
Sheet: 62957

SO K. Pacca | Plan FY | Actual YTD | [NAME] | 4Q OL | [NAME] | [NAME]
[PHONE] REPRODUCTION CHG | 2000 | 0
[PHONE] POSTAGE CHG | 0 | 4989
[PHONE] TELEPHONES CHG | 23000 | 25392
[PHONE] INTERNET USAG CHG | 14000 | 11220
[PHONE] RECOV FOR PVT.TEL | -1000 | -4187
[PHONE] LOCAL-BUSS TRAVEL | 13000 | 14125
[PHONE] REGIS & TAXES | 2000 | 1500
[PHONE] POL & SERVICES | 138000 | 87808.51
[PHONE] REP  PARTS & ACCESS | 20000 | 14460
[PHONE] PRIVATR MILEAGE | -55000 | -35665
[PHONE] BUS. MEETING & ENT. | 11000 | 6080
Spreadsheet: 866660d1713551279-continue-to-my-last-thread-discussion-sample-2
Sheet: Sheet1

 |  |  |  |  |  |  | Q1. How I Know this A1 which pay is cover the Project 1, project 2 & project3
 |  |  |  |  |  |  | Solution required by formula
 | Name | Project1 | Project2 | Project3 | Total Salary |  | Project1 | Project2 | Project3
 | A1 | 13000 | 9008.718232988998 | 9008.718232988998 |  |  |  | Pay 3&4 |  | =LET(   s,0,   a,SCAN(,C13:I13,LAMBDA(x,y,x+y)),   b,IF(C4=0,s,IFERROR(XLOOKUP(C4,a,SEQUENCe(,7),,1),7))
 | B1 | 0 | 0 | 0 |  |  |  |  |  | SEQUENCe(,7),,1),7)
 | A2 | 5000 | 7000 | 8000 |  |  |  | Pay 2&3 | Pay 4&5
 | A3 | 0 | 0 | 0
 | A4 | 3000 | 4000 | 5000 |  |  |  | Pay 2 | Pay 3&4
 | B2 | 2020.126928551948 | 12000 | 11003 |  |  |  | Pay 2&3&4 | Pay 5&6&7
 | B3 | 0 | 7865 | 6534 |  |  |  | Pay 1&2&3&4 | Pay 5&6&7 | =LET(   s,0,   a,SCAN(,C13:I13,LAMBDA(x,y,x+y)),   b,IF(C4=0,s,IFERROR(XLOOKUP(C4,a,SEQUENCE(,7),,1),7)),   c,SCAN(,CHOOSECOLS(C13:I13,SEQUENCE(7-b,,b+1)),LAMBDA(x,y,x+y)),   d,IF(D4=0,b,IFERROR(XLOOKUP(D4,c,SEQUENCE(,7-b,b+1),,1),7)),   e,SCAN(,CHOOSECOLS(C13:I13,SEQUENCE(7-d,,d+1)),LAMBDA(x,y,x+y)),   f,IF(E4=0,d,IFERROR(XLOOKUP(E4,e,SEQUENCE(,7-d,d+1),,1),7)),   HSTACK(IF(b=0,"","Pay "&TEXTJOIN("&",1,SEQUENCE(b))),IF(d=0,"","Pay "&TEXTJOIN("&",1,SEQUENCE(d-b,,b+1))),IF(d=0,"","Pay "&TEXTJOIN("&",1,SEQUENCE(f-d,,d+1)))) )
 | Name | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 | Total
 | A1 | 6000 | 7000 | 8000 | 4000 | 8000 | 8000 | 6000
 | B1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A2 | 5000 | 6000 | 6000 | 4000 | 6000 | 6000 | 3000
 | A3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A4 | 3000 | 4000 | 4074.44 | 4000 | 3000 | 3000 | 3000
 | B2 | 4000 | 4000 | 4000 | 4000 | 3000 | 3000 | 3000
 | B3 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B4 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B5 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B6 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B7 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B8 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B9 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B10 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B11 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
Spreadsheet: 152389d1335369867-calculating-of-patients-in-process-by-hour-of-day-sampe-in-process-file
Sheet: Sheet1

Patient ID | Start Hour | [NAME]
1 | 1 | 5
2 | 12 | 16
3 | 5 | 7
4 | 0 | 4
5 | 10 | 14
6 | 8 | 13
7 | 3 | 5
8 | 17 | 20
9 | 13 | 16
10 | 21 | 23
 |  | Hour of Day
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
# of Patient in Process |  | 1 | 2 | 2 | 3 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 106453d1303745665-sumifs-across-sheets-copy-of-central-office-2010-2011-w-formulas
Sheet: Sups Training

 |  |  |  |  |  |  | Same as Sups A | Same as Sups B |  |  | Same as Sups C |  |  | (Optional)
Facility | First Name | Class | Emp # | Sups A | Sups B | Sups C | Transition to Supervision | Labor Relations | Time & Attendance /SPF | Performace Mangement | Health and Safety | BEO | Interview & Personnel Selection | Abuse Investigation | Extended Leave | Total
Alfriend | Jeanette |  | 424683 |  |  |  |  |  |  |  |  |  |  |  |  |  | 424683
 | Antania |  | 646058 |  |  |  |  |  |  |  |  |  |  |  |  |  | 646058
 | [NAME] |  | 495042 |  |  |  |  |  |  |  |  |  |  |  |  |  | 495042
 | [NAME] |  | 71949 |  |  |  |  |  |  |  |  |  |  |  |  |  | 71949
 | [NAME] |  | 439185 |  |  |  |  |  |  |  |  |  |  |  |  |  | 439185
 | [NAME] |  | 608039 |  |  |  |  |  |  |  |  |  |  |  |  |  | 608039
 | [NAME] |  | 462816 |  |  |  |  |  |  |  |  |  |  |  |  |  | 462816
 | Arleathia |  | 25374 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25374
 | [NAME] |  | 72385 |  |  |  |  |  |  |  |  |  |  |  |  |  | 72385
 | Meri |  | 544272 |  |  |  |  |  |  |  |  |  |  |  |  |  | 544272
 | [NAME] |  | 647210 |  |  |  |  |  |  |  |  |  |  |  |  |  | 647210
 | [NAME] |  | 608513 |  |  |  |  |  |  |  |  |  |  |  |  |  | 608513
 | [NAME] |  | 438766 |  |  |  |  |  |  |  |  |  |  |  |  |  | 438766
 | [NAME] |  | 494815 |  |  |  |  |  |  |  |  |  |  |  |  |  | 494815
 | [NAME] |  | 71810 |  |  |  |  |  |  |  |  |  |  |  |  |  | 71810
 | [NAME] |  | 525136 |  |  |  |  |  |  |  |  |  |  |  |  |  | 525136
 | [NAME] |  | 45967 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45967
 | [NAME] |  | 56717 |  |  |  |  |  |  |  |  |  |  |  |  |  | 56717
 | Daryl |  | 515249 |  |  |  |  |  |  |  |  |  |  |  |  |  | 515249
 | Michelle |  | 49776 |  |  |  |  |  |  |  |  |  |  |  |  |  | 49776
 | George |  | 489089 |  |  |  |  |  |  |  |  |  |  |  |  |  | 489089
 | Avery |  | 628970 |  |  |  |  |  |  |  |  |  |  |  |  |  | 628970
 | [NAME] |  | 432011 |  |  |  |  |  |  |  |  |  |  |  |  |  | 432011
 | [NAME] |  | 392020 |  |  |  |  |  |  |  |  |  |  |  |  |  | 392020
 | Becky |  | 620673 |  |  |  |  |  |  |  |  |  |  |  |  |  | 620673
 | [NAME] |  | 87575 |  |  |  |  |  |  |  |  |  |  |  |  |  | 87575
 | [NAME] |  | 194488 |  |  |  |  |  |  |  |  |  |  |  |  |  | 194488
 | [NAME] |  | 35716 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35716
 | [NAME] |  | 679339 |  |  |  |  |  |  |  |  |  |  |  |  |  | 679339
 | [NAME] |  | 515575 |  |  |  |  |  |  |  |  |  |  |  |  |  | 515575
 | [NAME] |  | 455242 |  |  |  |  |  |  |  |  |  |  |  |  |  | 455242
Spreadsheet: john_griffith__16061__EOL_Product_Listen
Sheet: cash

NYMEX PROMT |  |  |  | HeHub
 |  |  |  |  |  |  | transport
 |  | HeHub | Supply | Supply | Supply | + / - | Gain to | Rates | fuel | Comm
 | PRICE | Spread | spread | point | price | variable | trade out | total
TRCO Z 6 |  |  |  | [NAME] 65 |  |  |  |  | 0.0462 | 0.0525
TRCO Z 6 NNY |  |  |  | [NAME] 65 |  |  |  |  | 0.0462 | 0.0525
TETCO M3 |  |  |  | TETCO WLA |  |  |  |  | 0.0823
 |  |  |  | TETCO ELA |  |  |  |  | 0.0796
Spreadsheet: 682843d1592357742-sumifs-this-or-that-commission-calendar-01
Sheet: Calendar

 | Name | Status | Funded Date | Amount | % | HEYA
 | [NAME] | Funded | 2020-04-11 00:00:00 | 846222
 | [NAME] | Funded | 2020-05-16 00:00:00 | 464132
 | [NAME] | Funded | 2020-05-19 00:00:00 | 654632 | 0.021 |  |  | Start Date | 2020-06-01 00:00:00
 | [NAME] | Funded | 2020-05-21 00:00:00 | 679741 |  |  |  | End Date | 2020-06-30 00:00:00
 | [NAME] | Funded | 2020-05-23 00:00:00 | 500500 | 0.03 |  |  | TOTAL
 | [NAME] | Funded | 2020-06-01 00:00:00 | 653256 | 0.007 |  |  | TARGET OUTCOME
 | [NAME] | Funded | 2020-06-05 00:00:00 | 275000
 | [NAME] | Funded | 2020-06-09 00:00:00 | 461015
 | [NAME] | Funded | 2020-06-10 00:00:00 | 350000 | 0.02
 | [NAME] | Funded | 2020-06-10 00:00:00 | 231465 | 0.073
 | [NAME] | Funded | 2020-06-12 00:00:00 | 1976432 | 0.0155
 | Anna Winter | In process |  | 1645432
 | [NAME] | In process |  | 2324641
 | [NAME] | In process |  | 544136
 | [NAME] | In process |  | 654778
Spreadsheet: 220554d1363192168-trying-to-retrieve-information-from-worksheet-to-a-form-workbook2
Sheet: Form

 |  | Design Inflow Information Report (Integra US) |  |  |  |  |  | Ref. No.: Date      :
Job No. | 672
Job In Date | 12./18/12
Author | Carroll/Buchholtz
Title | Business and Society, 9e
Publisher | Cengage Learning
Division | Mason
Sub-Division
Country | US
Currency | USD |  | (USD/GBP)
Project Manager | Emily Friel
Estimted Completion | 2013-12-02 00:00:00
Estimated Value | 1500 |  | Interior Design, Adaptation PAL stylesheet
Estimated Value | 300 |  | Interior Design Management Adaptation PAL
Estimated Value | 1500 |  | Cover Design Moderate
Estimated Value | 300 |  | Cover Design Management Moderate Core Book
Estimated Value | 200 |  | 20. Mechanical - Core Book
Estimated Value | 100 |  | Cover Design ISE
Estimated Value | 120 |  | Cover Management-Templated Series ISE
Estimated Value | 100 |  | 21. Mechanical (IE, ISE, AISE, ADV, Splits)
Notes: | combined interior and cover design inflow
Spreadsheet: 703622d1605088152-vlookup-from-dropdown-tab-references-test1
Sheet: Master

a | 1a | 2a | =VLOOKUP(A1,Sheet1!A1:C1,3,FALSE)
b | 1b | ab |  |  |  |  |  | Sheet1
c | 1c | 2c |  |  |  | Sheet2 |  | Sheet2
d | 1d | 2d |  |  |  |  |  | Sheet3
e | 1e | 2e |  |  |  |  |  | Sheet4
 |  |  |  |  |  |  |  | Sheet5