tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f55df3b3-f396-45a8-8039-d53fcd796fc2
Sheet: EZ1

DIVPLACE | NO. | PRIJMENI | JMENO | [NAME] | DIV | [NAME] | finish
1 | 184 | Válková | Kateřina | 1995 | EZ1 | PIAS | 1:29:25
2 | 100 | Přibíková | Pavlína | 1983 | EZ1 | [NAME] | 1:29:28
3 | 157 | Smíšková | [NAME] | 1979 | EZ1 | [NAME] | 1:31:00
4 | 106 | Slavíková | [NAME] | 1967 | EZ1 | Kladno-Švermov | 1:34:10
5 | 93 | Pazderová | Renata | 1971 | EZ1 | skuhr-bike | 1:34:41
6 | 149 | Zimmerhaklov | [NAME] | 1984 | EZ1 | [NAME] | 1:36:30
7 | 170 | [NAME] | Irena | 1977 | EZ1 |  | 1:39:44
8 | 154 | ženíšková | [NAME] | 1975 | EZ1 | [NAME] | 1:39:47
9 | 65 | Koubková | Lenka | 1972 | EZ1 | [NAME] | 1:40:35
10 | 67 | Krausová | Yvona | 1974 | EZ1 |  | 1:41:08
11 | 63 | Košnářová | Lenka | 1979 | EZ1 | KS Force | 1:42:50
12 | 51 | [NAME] | Sinika | 1990 | EZ1 | [NAME] | 1:49:50
13 | 9 | Bokrová | Iva | 1968 | EZ1 | [NAME] | 1:50:39
14 | 84 | Melicharová | Ivana | 1986 | EZ1 | [NAME] | 1:58:16
15 | 79 | [NAME] | Lenka | 1995 | EZ1 | [NAME] | 2:05:21
16 | 7 | [NAME] | Lucie | 1995 | EZ1 | [NAME] 7 | 2:05:21
17 | 48 | [NAME] | [NAME] | 1967 | EZ1 | [NAME] | 2:42:15
Spreadsheet: 136036d1326379723-excel-2007-monthly-profit-loss-test
Sheet: Sheet1

Date | Entry | Exit | Profit/Loss | Monthly Profit Loss
2011-03-01 00:00:00 | 296.5 | 292.8
2011-03-01 00:00:00 | 296.5 | 293.4
2011-04-01 00:00:00 | 269.85 | 293.4
19/1/2011 | 269.85 | 278.75
25/1/2011 | 253.5 | 278.75 |  | Jan Total Profit/Loss?
2011-02-02 00:00:00 | 253.5 | 249.8
2011-02-02 00:00:00 | 256 | 249.8
2011-03-02 00:00:00 | 256 | 259.25
2011-08-02 00:00:00 | 245.85 | 259.25
14/2/2011 | 245.85 | 242.7
15/2/2011 | 247.8 | 242.7
15/2/2011 | 247.8 | 241.5
15/2/2011 | 249.1 | 241.5
17/2/2011 | 249.1 | 241
18/2/2011 | 234.2 | 241
25/2/2011 | 234.2 | 240.65 |  | Feb Total Profit/Loss?
2011-08-03 00:00:00 | 232.2 | 240.65
16/3/2011 | 232.2 | 228.65
16/3/2011 | 228.2 | 228.65
22/3/2011 | 228.2 | 260.2 |  | March Total Profit/Loss?
2011-08-04 00:00:00 | 252.25 | 260.2
18/4/2011 | 252.25 | 248
18/4/2011 | 240.5 | 248
27/4/2011 | 240.5 | 237.5
29/4/2011 | 225.3 | 237.5 |  | April Total Profit/Loss?
13/5/2011 | 225.3 | 222.2
16/5/2011 | 203.5 | 222.2
27/5/2011 | 203.5 | 212.9 |  | May Total Profit/Loss?
2011-08-06 00:00:00 | 188.15 | 212.9
Spreadsheet: 217651d1362141855-rollup-data-from-multiple-excel-sheets-kpi-worksheet_test
Sheet: Q1 Analysis

 |  | Performance Indicators
 |  | Quarterly Q1
Department | Exceeds Target | On Target | Slightly less than Target | Less than Target | Total KPIs
 | 1 | 2 | 1 | -1
D5
D2
D1
D3
D4
D6
D8
D7
D9
D10
Overall Performance
 |  |  |  |  | 1
Number of departments measured |  |  |  | 6
Number of target departments to measure |  |  |  | 6
% of departments measured
Spreadsheet: tracy_geaccone__40239__enron corp infomation request-cons
Sheet: Non Employees

Enron Corp.
Forecast of Non-Employee Related Monthly Cash Expenses
($ in millions) |  |  |  | YTD
 |  |  |  |  |  | Forecast Cash Expenditures
 |  | Headcount Actual (9/30) |  | Cash Expenditures |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
ENA |  |  |  | 732.2 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 | 0 | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1 |  | 8.1
EGM |  |  |  |  |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 | 0 | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3 |  | 2.3
EIM |  |  |  | 65 |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 | 0 | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
EGAS |  |  |  | 43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EEOS |  |  |  | 0 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 | 0 | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1 |  | 4.1
EPI |  |  |  | 5 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 | 0 | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2 |  | 0.2
ENW |  |  |  | 202 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Europe |  |  |  | 431 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
EES |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ETS |  |  |  |  |  | 3.5 |  | 3.5 |  | 3.6 |  | 3.6 |  | 4 |  | 3.7 |  | 3.6 |  | 3.6 | 0 | 3.6 |  | 3.6 |  | 3.7 |  | 3.6 |  | 3.7 |  | 3.6 |  | 3.6
EREC |  |  |  | 904.8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
EBS |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EGF |  |  |  | 0 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3
Analysts & Assoc |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Corp Enron-wide Exp |  |  |  |  |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8 |  | 16.8
Corporate Staff Groups |  |  |  |  |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12
Total
Spreadsheet: 555145d1515456696-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 6

 |  |  | Tournament 6
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  |  |  | 68
 |  |  |  | 75
 |  |  |  | 56
 |  |  |  | 64
 |  |  |  | 46
 |  |  |  | 27
 |  |  |  | 40
 |  |  |  | 65
 |  |  |  | 76
 |  |  |  | 44
 |  |  |  | 53
 |  |  |  | 75
 |  |  |  | 49
 |  |  |  | 37
 |  |  |  | 53
 |  |  |  | 42
 |  |  |  | 29
 |  |  |  | 47
 |  |  |  | 24
 |  |  |  | 30
 |  |  |  | 32
 |  |  |  | 59
 |  |  |  | 63
 |  |  |  | 24
 |  |  |  | 54
 |  |  |  | 48
 |  |  |  | 66
 |  |  |  | 70
 |  |  |  | 71
 |  |  |  | 63
 |  |  |  | 73
 |  |  |  | 38
 |  |  |  | 41
 |  |  |  | 67
 |  |  |  | 66
 |  |  |  | 51
 |  |  |  | 42
 |  |  |  | 55
 |  |  |  | 52
 |  |  |  | 48
 |  |  |  | 52
 |  |  |  | 57
 |  |  |  | 76
 |  |  |  | 69
 |  |  |  | 32
 |  |  |  | 76
 |  |  |  | 54
 |  |  |  | 75
 |  |  |  | 78
 |  |  |  | 48
 |  | x | x | x
Spreadsheet: 138345d1327614915-excel-pricing-model-monte-carlo-excel-pricing-model
Sheet: Sheet1

 |  | Product Pricing Model
 |  |  |  |  |  |  |  |  |  | +10% | +/- 0 | -10%
 |  |  |  |  |  |  |  | % |  | Best | Expected | Worst
 |  | Annealed/Toughened % |  |  |  |  |  | 78
 |  | Textured % |  |  |  |  |  | 62
 |  | Georgian % |  |  |  |  |  | 50
 |  | Product Price Data
 |  | Product Base Price | 10
 |  | [NAME]:
 |  | Annealed/Toughened | 10
 |  | Textured | 5
 |  | Georgian | 10
 |  | Number of Units Sold | 100
 |  | Revenue £
 |  | Base Price
 |  | Annealed/Toughened
 |  | Textured
 |  | Georgian
 |  | Total Sales
 |  | Costs £ |  |  |  |  |  |  |  | Best | Expected | Worst
 |  | Base Cost Per Unit (£5)
 |  | Annealed/Toughened (£4)
 |  | Textured (£6)
 |  | Georgian (£10)
 |  | Fixed Costs Per Unit (£2)
 |  | Total Costs
 |  | Total Profit
 |  | ROS
 |  | Target ROS | 0.2
Spreadsheet: 48349d1247576950-finding-a-text-in-a-list-against-a-specific-item-and-returning-the-text-in-new-sheet-data-file
Sheet: Sheet2

 | WEEK ENDING:
 | WEEK:
Ranking | Group | Store | AM | Designer |  |  | Super Prestige |  |  | [NAME] |  |  | Sun |  |  | Celebrity |  |  | Grand Total |  |  | Total Months Target | Sales Month To Date | % Achieved | AM notes/comments
 |  |  |  | 2009 | 2008 | % vs. [NAME]/- | 2009 | 2008 | % vs. [NAME]/- | 2009 | 2008 | % vs. [NAME]/- | 2009 | 2008 | % vs. [NAME]/- | 2009 | 2008 | % vs. [NAME]/- | 2009 | 2008 | % vs. [NAME]/-
1 | A | Store 1 | CM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | A | Store 2 | CM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | A | Store 3 | CM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | B | Store 4 | CM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | B | Store 5 | CM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Grand Total |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 674588d1587931343-comparing-two-sheets-and-displaying-differences-example1
Sheet: Existing Database

Entry | Name | Fruit | Cost
1 | [NAME] | Apple | 1.2
2 | [NAME] | Orange | 4.3
3 | [NAME] | Pear | 1.99
4 | Olivia | [NAME] | 0.99
5 | [NAME] | Peach | 0.5
Spreadsheet: 98992d1297790147-creating-a-calendar-with-auto-update-functions-cdyason-personnel-example
Sheet: Joe Bloggs

 | RETURN TO INDEX |  | DATE:
 |  |  | Job Currently On:
 |  |  | Job Tomorrow:
 |  |  |  | 2011
GENERAL |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Name: | [NAME] |  |  | 1
Employee ID: | e.g. BT01 |  |  | 2
Job Description: | Level 3/Supervisor |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10 | Stewarton
 |  |  |  | 11 | Stewarton
 |  |  |  | 12 | Stewarton
 |  |  |  | 13 | Day off
 |  |  |  | 14 | [NAME]
 |  |  |  | 15 | [NAME] | test1
 |  |  |  | 16 |  | test2
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
 |  |  |  | 28
 |  |  |  | 29
 |  |  |  | 30
 |  |  |  | 31
Spreadsheet: 167986d1342179576-create-different-formulas-based-off-of-yes-or-no-this-should-do-it
Sheet: Sheet1

Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | >35
Amount | 1 | 2 | 4 | 8 | 16 | 32 | 64 | 128 | 256
Multiplier | 2
 | Season 1 |  | Winnings |  | 1 | Odds | Win | 2 | Odds | Win | 3 | Odds | Win
 | Team 1 |  | 44 |  | 1 | 8 | No | 2 | 7 | No | 5.5 | 8 | Yes
 | Team 2 |  | 14 |  | 1 | 8 | No | 2 | 7 | Yes
 |  |  |  | Cost | 2 |  |  | 4 |  |  | 5.5
 |  |  |  | Winning
 |  |  |  | Balance
 |  |  |  | So for example in the yellow box I want it to search for a Yes so week 3 will mean cell L12*M12 and would stop searching as there would only be one Yes,
 |  |  |  | and team 2 has a yes in its second week so  I want D13 to times I13*J13.
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: CC 103833 - G&A Assumption

 |  |  |  | Enron Net Works
 |  |  |  | 2002 Plan
SAP PROFIT CENTER: |  |  | 11105
PROFIT CENTER OWNER: |  |  | [NAME]
SAP COST CENTER/PROJECT: |  |  | 103833
 |  |  |  |  | AVERAGE
 |  |  |  |  | MONTHLY |  | TOTAL
 |  |  |  |  | AMOUNT |  | 2002 |  | ASSUMPTIONS
52001500 | Club Dues |  |  |  | 0
52002000 | Tuition Reimbursement |  |  |  | 0
52002500 | Other Employee Expenses |  |  |  | 0
52003000 | Overtime/Working Meals |  |  |  | 0
52003500 | Client Meals & entertainment |  |  |  | 0
52004000 | Employee Memberships & Dues |  |  |  | 0
52004500 | Travel & Lodging |  |  |  | 0
 | Subtotal Employee Expenses
52503500 | Communication Expenses |  |  |  | 0
 | Subtotal Communication Expense
52502000 | EIS Controllable |  |  |  | 0
 | Infrastructure
52507400 | Outside Services - IT |  |  |  | 0
 | Subtotal Outside Services - IT
52507000 | Outside Services - Legal |  |  |  | 0
52507100 | Outside Services - Audit |  |  |  | 0
52507200 | Outside Services - Contract for OH Allocation |  |  |  | 0
52507300 | Outside Services - Tax |  |  |  | 0
52507500 | Outside Services - Other |  |  |  | 0
52507600 | Outside Services - Engineering |  |  |  | 0
52507700 | Outside Services - Accounting |  |  |  | 0
52508000 | Outside Services - Professional |  |  |  | 0
 | Subtotal Outside Services
52508100 | Postage & Freight Expense |  |  |  | 0
52508500 | Subscriptions & Periodicals |  |  |  | 0
53500000 | Materials and Supplies - Stock |  |  |  | 0
53500500 | Materials and Supplies - Non Stock |  |  |  | 0
53600000 | Office Supplies |  |  |  | 0
 | Subtotal Office Supplies
52500500 | Advertising Expenses |  |  |  | 0
52504100 | Charitable Contributions |  |  |  | 0
53800000 | Equipment Rental - Personal |  |  |  | 0
53801000 | Rent - Office, Warehouse, & Tower - Real |  |  |  | 0
 | Subtotal Rent (3rd Party)
52504500 | Technology - Computer Exp |  |  |  | 0
54000000 | Transportation |  |  |  | 0
52502500 | EPSC Allocation |  |  |  | 0 |  |  |  | $700 a month an employee
 | A&A Allocation |  |  |  | 0
52505500 | Fees & Permits |  |  |  | 0
54005000 | General Business & Admin Expenses |  |  |  | 0
52504200 | Political Contributions |  |  |  | 0
52506500 | Insurance |  |  |  | 0
52506000 | Fines & Penalties |  |  |  | 0
52503000 | Allocations - Other |  |  |  | 0
52504000 | Company Membership & Dues |  |  |  | 0
 | Subtotal Other
57200000 | Depreciation |  |  |  | 0
57000000 | Amortization |  |  |  | 0
 | Subtotal Noncash Expenses
59099900 | Taxes Other than Income |  |  |  | 0
 | TOTAL DIRECT EXPENSES
Allocated Expenses:
 | ENA E-Source |  |  |  | 0
 | ENA HR |  |  |  | 0
 | ENA Internal Support |  |  |  | 0
 | ENA Legal |  |  |  | 0
 | ENA PR |  |  |  | 0
 | ENA Tax |  |  |  | 0
 | ENA Transaction Support |  |  |  | 0
 | Energy Ops |  |  |  | 0
 | ENW Accounting |  |  |  | 0
 | ENW Corporate |  |  |  | 0
 | ENW Graphics Productions |  |  |  | 0
 | ENW HR |  |  |  | 0
 | GTT Allocation |  |  |  | 0
 | IT e-Commerce |  |  |  | 0
 | IT Infrastructure - Passthrough |  |  |  | 0
 | Other Allocations |  |  |  | 0
 | TOTAL ALLOCATED EXPENSES
Spreadsheet: 808672d1670583249-sumifs-formula-to-calculate-the-total-number-of-days-duda
Sheet: Data

Employee | Role | Date | Logical check | Days
Juan | Sales | 2022-01-17 00:00:00 |  | 1
Juan | Sales | 2022-03-15 00:00:00 |  | 1
Juan | Sales | 2022-03-16 00:00:00 |  | 1
Juan | Sales | 2022-03-17 00:00:00 |  | 1
Juan | Sales | 2022-03-22 00:00:00 |  | 1
Juan | Sales | 2022-03-23 00:00:00 |  | 1
Juan | Sales | 2022-03-24 00:00:00 |  | 1
Juan | Sales | 2021-12-02 00:00:00 |  | 1
Spreadsheet: 02389d1c-d165-4da5-984a-8783b32e48cb
Sheet: Certificates

C& I meeting Date | New Certificates | Certificate Modification | Modification Details | Delete from Catalog | Delete Curriculum Inventory | Effective Date | Approved by AA | Date BOT approved | CO's Approval Date
2012-11-14 00:00:00 | NA | Music | Add MUSIC 122, 150, 153, 154, 155, 171, 185, and 186 to the certificate as electives |  |  | Spring 2013 | Sep. 2012
2012-11-28 00:00:00 | NA | NA | NA | Computer Engineering Technician | NA | Spring 2013
2012-11-28 00:00:00 | NA | NA | NA | Computer Repair Technician | NA | Spring 2013
2012-11-28 00:00:00 |  | Minor revision: Title Change | From Electronics Engineering Technician to Electronic Technology Technician | NA | NA | Spring 2013 | 2012-12-12 00:00:00
Spreadsheet: 168443d1342458155-need-help-on-calculating-the-percent-ulilization-percentutilization
Sheet: data

Store | Visit  Start | Visit  End | Visit Start | End
Store 1 | 2012-01-01 08:10:00 | 2012-01-02 01:00:00
Store 2 | 2012-01-08 17:45:00 | 2012-01-09 11:05:00
Store 4 | 2012-01-10 19:37:00 | 2012-01-11 11:35:00
Store 1 | 2012-01-02 20:40:00 | 2012-01-02 14:35:00
Store 2 | 2012-01-14 06:10:00 | 2012-01-15 00:50:00
Store 4 | 2012-01-16 03:25:00 | 2012-01-16 22:25:00
Store 1 | 2012-01-29 20:45:00 | 2012-01-30 12:15:00
Store 8 | 2012-01-25 12:05:00 | 2012-01-26 16:00:00
Store 9 | 2012-01-19 23:25:00 | 2012-01-20 15:40:00
Store 10 | 2012-01-27 13:20:00 | 2012-01-27 22:30:00
Store 2 | 2012-01-27 16:48:00 | 2012-02-02 10:40:00
Store 5 | 2012-02-02 19:20:00 | 2012-02-03 08:00:00
Store 8 | 2012-02-02 14:40:00 | 2012-02-03 03:50:00
Store 3 | 2012-02-02 18:40:00 | 2012-02-03 05:37:00
Store 2 | 2012-02-02 06:06:00 | 2012-02-03 10:50:00
Store 5 | 2012-02-03 16:00:00 | 2012-02-04 12:03:00
Store 7 | 2012-02-03 18:10:00 | 2012-02-05 00:40:00
Store 4 | 2012-02-05 01:00:00 | 2012-02-06 02:00:00
Store 5 | 2012-02-06 16:55:00 | 2012-02-07 01:00:00
Store 7 | 2012-02-07 08:40:00 | 2012-02-07 20:20:00
Store 4 | 2012-02-06 18:00:00 | 2012-02-07 10:05:00
Store 5 | 2012-02-06 10:50:00 | 2012-02-06 23:35:00
Store 7 | 2012-02-07 14:30:00 | 2012-02-08 06:20:00
Store 1 | 2012-02-08 17:55:00 | 2012-02-09 09:20:00
Store 4 | 2012-02-09 23:10:00 | 2012-02-10 13:20:00
Store 8 | 2012-02-09 18:05:00 | 2012-02-10 07:25:00
Store 10 | 2012-02-11 00:45:00 | 2012-02-11 14:05:00
Store 1 | 2012-02-12 10:05:00 | 2012-02-12 20:30:00 |  |  |  |  |  |  | z
Store 4 | 2012-02-11 18:15:00 | 2012-02-12 10:30:00
Store 8 | 2012-02-23 23:15:00 | 2012-02-24 11:50:00
Store 10 | 2012-02-23 12:05:00 | 2012-02-25 03:10:00
Store 2 | 2012-02-24 23:15:00 | 2012-02-25 10:05:00
Store 3 | 2012-02-25 21:30:00 | 2012-02-26 08:55:00
Store 4 | 2012-02-26 11:50:00 | 2012-02-26 18:00:00
Store 4 | 2012-02-26 23:30:00 | 2012-02-27 14:30:00
Store 5 | 2012-02-27 13:00:00 | 2012-02-28 14:20:00
Store 4 | 2012-02-27 21:50:00 | 2012-03-01 18:50:00
Store 4 | 2012-03-01 20:30:00 | 2012-03-02 02:50:00
Store 4 | 2012-03-02 20:50:00 | 2012-03-07 03:30:00
Spreadsheet: 768798d1645123683-multiple-date-ranges-and-sum-calculations-help-testbook
Sheet: Sheet1

 |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
 |  |  | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Name: | Start date: | End date: | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
ME | 2022-01-01 00:00:00 | 2022-04-04 00:00:00 | 30 | 28 | 31 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
YOU | 2022-03-01 00:00:00 | 2022-07-02 00:00:00 | 0 | 0 | 31 | 30 | 31 | 30 | 2 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 826582d1682090974-how-can-i-change-the-format-of-the-column-a-into-column-b-excel-time-format-change-2-
Sheet: Sheet1

A |  |  |  |  |  |  |  |  | 1
00:00:00
00:05:33
00:10:33
00:14:47
00:18:27
00:21:45
00:24:38
00:28:45
00:30:45
00:34:11
00:37:02
00:39:53
00:41:27
00:46:09
00:49:15
00:53:00
00:55:59
00:57:42
01:00:45
01:01:39
01:02:25
01:03:47
Spreadsheet: 93577d1293141887-after-evaluate-code-jumps-to-end-sub-evaluate-for-lat
Sheet: Sheet1

LEVEL | SW | Length | SW or BL? | row# if Col-D=2 | LBL | LSW/LBL(%) | [NAME] | BLShears cleared | V, # | Height | [NAME] | WShears cleared | W, #
1 | 1-1 | 8 | 1 | 0 |  | 0.3333333333333333 |  |  | 818.2627090917 | 8 |  |  | 2298.1875
1 | 1-2 | 8 | 1 | 0 |  | 0.3333333333333333 |  |  | 818.2627090917 | 8 |  |  | 2298.1875
1 | 1-3 | 8 | 1 | 0 |  | 0.3333333333333333 |  |  | 818.2627090917 | 8 |  |  | 2298.1875
1 | 1 | 24 | 2 | 6 | 24 | 1 | 2454.788127275101 | 2454.788127275101 | 2454.7881272751 | 8 | 6894.562500000001 | 6894.562500000001 | 6894.5625
1 | 2-1 | 8 | 1 | 0 |  | 0.5 |  |  | 583.61207710742 | 8
1 | 2-2 | 8 | 1 | 0 |  | 0.5 |  |  | 583.61207710742 | 8
1 | 2 | 16 | 2 | 9 | 16 | 1 | 1167.224154214838 | 1167.224154214838 | 1167.22415421484 | 8
1 | 3-1 | 4 | 1 | 0 |  | 1 |  |  | 649.642003763808 | 8
1 | 3 | 4 | 2 | 11 | 4 | 1 | 649.6420037638076 | 649.6420037638076 | 649.642003763808 | 8
1 | 4-1 | 8 | 1 | 0 |  | 1 |  |  | 1086.82240561233 | 8
1 | 4 | 8 | 2 | 13 | 8 | 1 | 1086.822405612326 | 1086.822405612326 | 1086.82240561233 | 8
1 | 5-1 | 4 | 1 | 0 |  | 1 |  |  | 2140.33489976381 | 8
1 | 5 | 4 | 2 | 15 | 4 | 1 | 2140.334899763808 | 2140.334899763808 | 2140.33489976381 | 8
1 | 6-1 | 8 | 1 | 0 |  | 0.5 |  |  | 1109.116289452415 | 8
1 | 6-2 | 8 | 1 | 0 |  | 0.5 |  |  | 1109.116289452415 | 8
1 | 6 | 16 | 2 | 18 | 16 | 1 | 2218.232578904826 | 2218.232578904826 | 2218.23257890483 | 8
1 | 7-1 | 8 | 1 | 0 |  | 1 |  |  | 779.250924612326 | 8
1 | 7 | 8 | 2 | 20 | 8 | 1 | 779.2509246123261 | 779.2509246123261 | 779.250924612326 | 8
1 | 8-1 | 2 | 1 | 0 |  | 0.3333333333333333 |  |  | 292.5951617043043 | 8
1 | 8-2 | 2 | 1 | 0 |  | 0.3333333333333333 |  |  | 292.5951617043043 | 8
1 | 8-3 | 2 | 1 | 0 |  | 0.3333333333333333 |  |  | 292.5951617043043 | 8
1 | 8 | 6 | 2 | 24 | 6 | 1 | 877.7854851129127 | 877.7854851129127 | 877.785485112913 | 8
1 | 9-1 | 8 | 1 | 0 |  | 0.5 |  |  | 280.1644335 | 8 |  |  | 3447.28125
1 | 9-2 | 8 | 1 | 0 |  | 0.5 |  |  | 280.1644335 | 8 |  |  | 3447.28125
1 | 9 | 16 | 2 | 27 | 16 | 1 | 560.3288670000001 | 560.3288670000001 | 560.328867 | 8 | 6894.562500000001 | 6894.562500000001 | 6894.5625
Spreadsheet: 111260d1307664150-sum-with-multiple-criteria-sum-with-multiple-criteria
Sheet: CRITERIA

 | DATE | 2011-03-19 00:00:00
 | ENV | Started Date Delivered | Number of hours/week Support | Number of Release Week | [NAME] hours for System Availability | Total Hours Duration | Total Outage Percentage
 | IDE2 Only | 2010-11-22 00:00:00 | 125
 | UTE2 Only | 2010-12-06 00:00:00 | 125
 | Environment
 | IDE2 Only
 | UTE2 Only
 | IDE2 and UTE2
 | Environment Platform | Start Date | Start Time (PT) | End Date | End Time (PT) | Duration | Duration Percentage |  | EXPECTED
 | IDE2 Only | 2010-12-16 00:00:00 | 09:09:00 | 2010-12-17 00:00:00 | 02:08:00 |  |  | =>
 | IDE2 Only | 2010-12-29 00:00:00 | 23:33:00 | 2010-12-30 00:00:00 | 04:08:00 |  |  | =>
 | UTE2 Only | 2011-01-05 00:00:00 | 20:14:00 | 2011-01-05 00:00:00 | 22:03:00 |  |  | =>
 | IDE2 Only | 2011-01-10 00:00:00 | 10:00:00 | 2011-01-10 00:00:00 | 10:30:00 |  |  | =>
 | IDE2 and UTE2 | 2011-01-12 00:00:00 | 22:59:00 | 2011-01-13 00:00:00 | 20:36:00 |  |  | =>
 | IDE2 and UTE2 | 2011-01-17 00:00:00 | 21:18:00 | 2011-01-17 00:00:00 | 22:00:00 |  |  | =>
 | IDE2 and UTE2 | 2011-02-01 00:00:00 | 02:19:00 | 2011-02-01 00:00:00 | 03:35:00 |  |  | =>
 | IDE2 and UTE2 | 2011-02-04 00:00:00 | 03:58:00 | 2011-02-04 00:00:00 | 05:03:00 |  |  | =>
Spreadsheet: 789662d1659281760-populate-shift-count-master-file-based-on-weekly-roster-duty-planning-eg
Sheet: Ideal Output

Name | Total | AM | PM | NIGHT | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-05 00:00:00 | 2022-08-06 00:00:00 | 2022-08-07 00:00:00 | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | 2022-08-12 00:00:00 | 2022-08-13 00:00:00 | 2022-08-14 00:00:00 | 2022-08-15 00:00:00 | 2022-08-16 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00 | 2022-08-28 00:00:00 | 2022-08-29 00:00:00 | 2022-08-30 00:00:00
 |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
Alvin |  |  |  |  | AM
[NAME] |  |  |  |  |  |  |  | AM
Calvin |  |  |  |  | AM
[NAME] |  |  |  |  |  |  |  | AM
[NAME] |  |  |  |  |  |  |  |  |  | NIGHT
Francine |  |  |  |  |  | PM
[NAME] |  |  |  |  |  |  | PM
Harold |  |  |  |  |  |  |  |  |  | NIGHT
Ingrid |  |  |  |  |  |  |  | AM
[NAME] |  |  |  |  |  | PM
Karol |  |  |  |  |  | PM
[NAME] |  |  |  |  |  |  | PM
Spreadsheet: 785276d1656321744-data-validation-list-based-on-another-dv-list-datavalidation-1
Sheet: Stock

Product Type | Decription Product |  | Software | Hardware | Accessories | Laptop
Software | Office 2013
Hardware | Printer Canon 3060
Software | Office 2016
Accessories | USB key 64Gb
Laptop | [NAME]
Laptop | Acer 2040s
Accessories | Micro SD 4Gb
Hardware | Router [NAME]
Hardware | Router Cisco ABC1
Hardware | Router [NAME]
Hardware | Router Cisco ABC3
Hardware | Router [NAME]
Accessories | Micro SD 4Gb1
Accessories | Micro SD 4Gb2
Accessories | Micro SD 4Gb3
Accessories | Micro SD 4Gb4
Accessories | Micro SD 4Gb5
Accessories | Micro SD 4Gb6
Laptop | Asus X51R1
Laptop | Acer 2040s1
Laptop | Asus X51R2
Laptop | Acer 2040s2
Laptop | Acer 2040s3
Software | Office 2013-1
Software | Office 2013-2
Software | Office 2013-3
Software | Office 2013-4