tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96960d1296180838-excel-2007-simple-conditional-format-but-format-highlight_daddy
Sheet: Sheet1

 |  | 9 |  |  |  |  | 9
 |  | 2 |  |  |  |  | 2
 |  | 4 |  | Column C is what I'm getting |  |  | 4
 |  | 6 |  |  |  |  | 6
 |  | 1 |  | Column H is what I want |  |  | 1
 |  | 3 |  |  |  |  | 3
 |  | 5 |  |  |  |  | 5
 |  | 7 |  |  |  |  | 7
 |  | 8 |  |  |  |  | 8
 |  | 10 |  |  |  |  | 10
 |  | 4 |  |  |  |  | 4
 |  | 1 |  |  |  |  | 1
 |  | 2 |  |  |  |  | 2
 |  | 3 |  |  |  |  | 3
 |  | 5 |  |  |  |  | 5
 |  | 6 |  |  |  |  | 6
 |  | 8 |  |  |  |  | 8
 |  | 7 |  |  |  |  | 7
 |  | 9 |  |  |  |  | 9
 |  | 10 |  |  |  |  | 10
 |  | 2 |  |  |  |  | 2
 |  | 1 |  |  |  |  | 1
 |  | 7 |  |  |  |  | 7
 |  | 4 |  |  |  |  | 4
 |  | 9 |  |  |  |  | 9
 |  | 3 |  |  |  |  | 3
 |  | 5 |  |  |  |  | 5
 |  | 6 |  |  |  |  | 6
 |  | 8 |  |  |  |  | 8
 |  | 10 |  |  |  |  | 10
 |  | 1 |  |  |  |  | 1
 |  | 4 |  |  |  |  | 4
 |  | 2 |  |  |  |  | 2
 |  | 3 |  |  |  |  | 3
 |  | 5 |  |  |  |  | 5
 |  | 6 |  |  |  |  | 6
 |  | 8 |  |  |  |  | 8
 |  | 5 |  |  |  |  | 5
 |  | 3 |  |  |  |  | 3
 |  | 2 |  |  |  |  | 2
 |  | 7 |  |  |  |  | 7
 |  | 1 |  |  |  |  | 1
 |  | 4 |  |  |  |  | 4
 |  | 3 |  |  |  |  | 3
 |  | 5 |  |  |  |  | 5
 |  | 6 |  |  |  |  | 6
 |  | 1 |  |  |  |  | 1
 |  | 2 |  |  |  |  | 2
 |  | 4 |  |  |  |  | 4
 |  | 5 |  |  |  |  | 5
 |  | 4 |  |  |  |  | 4
 |  | 3 |  |  |  |  | 3
 |  | 9 |  |  |  |  | 9
 |  | 1 |  |  |  |  | 1
 |  | 2 |  |  |  |  | 2
 |  | 8 |  |  |  |  | 8
 |  | 6 |  |  |  |  | 6
 |  | 7 |  |  |  |  | 7
 |  | 10 |  |  |  |  | 10
 |  | 1 |  |  |  |  | 1
 |  | 3 |  |  |  |  | 3
 |  | 5 |  |  |  |  | 5
 |  | 8 |  |  |  |  | 8
 |  | 4 |  |  |  |  | 4
 |  | 6 |  |  |  |  | 6
 |  | 9 |  |  |  |  | 9
 |  | 2 |  |  |  |  | 2
 |  | 7 |  |  |  |  | 7
 |  | 6 |  |  |  |  | 6
 |  | 4 |  |  |  |  | 4
 |  | 3 |  |  |  |  | 3
 |  | 10 |  |  |  |  | 10
 |  | 1 |  |  |  |  | 1
 |  | 5 |  |  |  |  | 5
 |  | 7 |  |  |  |  | 7
 |  | 9 |  |  |  |  | 9
 |  | 2 |  |  |  |  | 2
 |  | 8 |  |  |  |  | 8
 |  | 3 |  |  |  |  | 3
 |  | 8 |  |  |  |  | 8
 |  | 5 |  |  |  |  | 5
 |  | 1 |  |  |  |  | 1
 |  | 2 |  |  |  |  | 2
 |  | 4 |  |  |  |  | 4
 |  | 6 |  |  |  |  | 6
 |  | 7 |  |  |  |  | 7
 |  | 9 |  |  |  |  | 9
 |  | 5 |  |  |  |  | 5
 |  | 4 |  |  |  |  | 4
 |  | 1 |  |  |  |  | 1
 |  | 3 |  |  |  |  | 3
 |  | 6 |  |  |  |  | 6
 |  | 2 |  |  |  |  | 2
 |  | 5 |  |  |  |  | 5
 |  | 4 |  |  |  |  | 4
 |  | 6 |  |  |  |  | 6
 |  | 3 |  |  |  |  | 3
 |  | 2 |  |  |  |  | 2
 |  | 1 |  |  |  |  | 1
 |  | 7 |  |  |  |  | 7
Spreadsheet: 217552d1362100834-automatically-copying-info-from-one-sheet-to-another-excel-help
Sheet: June 25

10:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
11:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
11:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
12:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
12:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
05:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
06:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
06:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
07:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
07:30:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
08:00:00
 | Last | First | Age | Home Phone | Cell Phone | [NAME] | Parent's Name | Certificate | Time | Level Started | Ended | Private | Check # | Date | Amount | Notes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Spreadsheet: 775642d1649239549-excel-2016-sheet-to-sheet-automation-excel-functions-sample
Sheet: Original Data

Job # | Job Title | Job Priority | Customer | Materials | Tooling
1234 | [NAME] | 1
8765 | Partial Demo | 2
1256 | Site Cleanup | 1
1267 | [NAME] | 3
2314 | Material Support | 4
5621 | Full Demo | 2
Spreadsheet: 852875d1702871414-partial-text-lookup-search-with-partial-text-in-source-book1
Sheet: List

Receiver | LISTED
Carondelet Baptist |  |  | YELLOW HIGHLIGHT: ACTUALLY NOT ON SPECIALTY SHEET
[NAME] |  |  | GREEN HIGHLIGHT: SHORTENED NAME ON LOOKUP TABLE
Higher Heights |  |  | BLUE HIGHLIGHT: SHORTENED NAME ON SOURCE (SPECIALTY TAB)
First Christian Church of Florissant
Good Shepherd
Rooftop Church
Calvary Chapel
Upper Room
Lighthouse Ministries
Spreadsheet: 860801d1708799751-non-sequential-row-problem-ef1631_irregular_rows
Sheet: Sheet1

10 |  | Data ( = row number times 10)
20
30
40
50
60
70
80
90
100
110
120
130
140
150
160
170
180
190
200
210
220
230
240
250
260
270
280
290
300
310
320
330
340
350
360
370
380
390
400
410
420
430
440
450
460
470
480
490
500
510
520
530
540
550
560
570
580
590
600
Spreadsheet: 127803d1320586951-searching-for-a-word-mylist1
Sheet: Sayfa1

apple
appricot
banana
beer
bread
butter
cake
carror
cheese
cherry
chiken
chocolate
coffee
coke
cucumber
eggs
eight
eleven
fish
five
four
george
hamburger
honey
hotdog
ice-cream
jane
lemon
melon
[NAME]
milk
nine
olives
one
orange
orange-juice
salad
seven
six
steak
[NAME]
susan
tea
ten
thirteen
three
twelve
twenty
two
wine
Spreadsheet: 107967d1305094318-excel-2007-copy-data-from-one-sheet-to-another-by-condition-test
Sheet: SUM

ITEM # | NAME | TABLE 1 | TABLE 2
1 |  | 1 | 1
2 |  | 2 | 2
3 |  | 3 | 3
4 |  | 4 | 4
5 |  | 5 | 5
6 |  | 6 | 6
7 |  | 7 | 7
8 |  | 8 | 8
9 |  | 9 | 9
10 |  | 10 | 10
Spreadsheet: 756389d1637499850-calculating-xirr-on-non-contiguous-rows-and-columns-based-on-criteria-xirr-non-contigous-rows-and-cols
Sheet: XIRR -Non-Contigous Rows & Cols

Scheme Name | Last recorded NAV On | XIRR Amount | Latest Date | Total Value |  |  | Scheme Name | Last recorded NAV On | XIRR Amount | Latest Date | Total Value
Fund 1 | 2021-08-31 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  | Fund 1 | 2021-08-31 00:00:00 | -2000 | 2021-11-18 00:00:00 | 6279.581294
Fund 2 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  | Fund 1 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 3 | 2021-09-01 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  | Fund 1 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 4 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  | Fund 1 | 2021-11-18 00:00:00 | 6279.581294
Fund 5 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 6 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 7 | 2021-09-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 8 | 2021-09-01 00:00:00 | -1000 | 2021-11-18 00:00:00
Fund 5 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 6 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 7 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 8 | 2021-10-01 00:00:00 | -1000 | 2021-11-18 00:00:00
Fund 1 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 2 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 4 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 3 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 9 | 2021-10-04 00:00:00 | -5000 | 2021-11-18 00:00:00
Fund 10 | 2021-10-04 00:00:00 | -5000 | 2021-11-18 00:00:00
Fund 11 | 2021-10-18 00:00:00 | -1000 | 2021-11-18 00:00:00
Fund 11 | 2021-10-18 00:00:00 | -9000 | 2021-11-18 00:00:00
Fund 11 | 2021-10-27 00:00:00 | -1000 | 2021-11-18 00:00:00
Fund 12 | 2021-10-26 00:00:00 | -1000 | 2021-11-18 00:00:00
Fund 12 | 2021-10-26 00:00:00 | -9000 | 2021-11-18 00:00:00
Fund 11 | 2021-10-27 00:00:00 | -9000 | 2021-11-18 00:00:00
Fund 10 | 2021-11-01 00:00:00 | -2500 | 2021-11-18 00:00:00
Fund 1 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 7 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 6 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 5 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 4 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 3 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 2 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00
Fund 8 | 2021-11-01 00:00:00 | -1000 | 2021-11-18 00:00:00
Spreadsheet: 853879d1703843272-vba-code-to-make-my-classes-schedule-for-number-of-days-with-available-faculty-test-file
Sheet: Sheet1

faculty available NAME | No of days Program | Subjects | which faculty takes which class | each day classes | each session hr | Session start date | DATE ON WHICH SOME FACULTY IS NOT AVAIBALE | FACULTY NAME WHO IS NOT AVAILABLE
[NAME] | 21 | a1 | ANUJ | 4 | 1.3 | 2023-12-29 00:00:00 | 2023-12-30 00:00:00 | ANUJ |  |  |  |  |  | tab of vba to click
RAGHAV |  | a2 | RAGHAV |  |  |  | 2023-01-01 00:00:00 | GOKUL
NITIN |  | a3 | ANUJ |  |  |  |  |  |  |  |  |  |  | on clicking [NAME]
GOKUL |  | a4 | GOKUL |  |  |  |  |  |  |  |  |  |  | the result permutations and schedule will come at sHEET 2 of same workbook
 |  | a5 | NITIN
 |  | a6 | RAGHAV
 |  | a7 | ANUJ
 |  | [NAME] | GOKUL
 |  | a9 | RAGHAV
 |  | a10 | NITIN
 |  | a11 | ANUJ
 |  | a12 | GOKUL
 |  | a13 | RAGHAV
 |  | a14 | GOKUL
 |  | a15 | NITIN
 |  | a16 | ANUJ
 |  | a17 | GOKUL
 |  | a18 | NITIN
 |  | a19 | RAGHAV
 |  | a20 | GOKUL
 |  | a21 | NITIN
Spreadsheet: eric_saibi__9729__011002
Sheet: Keystone 01

Owner Name |  | Reliant Energy
Station Name |  | Keystone Power Station
Unit Name |  | Keystone 01
NERC Region |  | MAAC
State |  | PA
Fuel Type |  | Coal
Capacity |  | 936 MW
Start Date |  | 2002-01-10 00:00:00
End Date |  | 2002-01-16 00:00:00
Comments |  | Unplanned Repairs
SIC |  | 4931
Plant ID |  | 1016346
Unit ID |  | 1004381
Outage ID |  | 19436
Spreadsheet: 120001d1314907595-is-there-a-way-to-merge-information-automatically-from-dissimilar-tabs-sample
Sheet: Items

Serial# | Item Name 1 | Item Name 2
 | Desk | Small
 | Keyboard
 | Monitor
 | [NAME]
Spreadsheet: shelley_corman__38736__CashBal_proposalhandout
Sheet: 13 mos ended 3-31-01 Settlement

Northern Natural Gas Company
Settlement Offer
July 17, 2001
In Docket Nos. RP01-76-000, RP01-382-000
and RP01-396-000
 | SLA - Adjusted Average Cash Balance
 | Month-end Balance @ |  | Balance
 | March 31, 2000 |  | 5052748
 | April 30, 2000 |  | -3550968
 | May 31, 2000 |  | -7800148
 | June 30, 2000 |  | -9587057
 | July 31, 2000 |  | 7033222
 | August 31, 2000 |  | -6081372
 | September 30, 2000 |  | -14365398
 | October 31, 2000 |  | 5832256
 | November 30, 2000 |  | -5095168
 | December 31, 2000 |  | -87992
 | January 31, 2001 |  | 52370716
 | February 28, 2001 |  | 59478600
 | March 31, 2001 |  | 58394896
 | 13-Month Average Cash Balance
 | Adjustment for Return & Tax Calculation |  | -2500000
 | 13-Month Adjusted Average Cash Balance
 | Calculation of Return & Tax and SLA Credit |  | Total |  | Return & Tax |  | [NAME]
 |  |  | @ 15% |  | @ 12% |  | @ 3%
Spreadsheet: lynn_blair__24477__packstat01
Sheet: Sheet1

COMMENTS | Plan Status Code | packet # | CUST | REGION | POI | CONTRACT # | TRANS TYPE | DEAL TYPE | ACCT MGR | DEAL MONTH | DEAL DATE | INJ/WD | PROD MTH | PROJ MTH TOTAL | ACTUAL | [NAME] | START DAY | END DAY | DAILY MIN | DAILY MAX | TOTAL RATE | INJ RATE | WD RATE | MIC RATE | PROJ TOTAL STORAGE REVENUE | ACTUAL TOTAL STORAGE REVENUE | ACT INJ FEE | ACT WD FEE | ACT MIC FEE | Month Ending | ADJUSTED FEE | [NAME]
Spreadsheet: 879433d1726936727-whats-wrong-with-the-formula-shanis-exf
Sheet: Sheet1

 |  |  |  |  |  | Sr# | D. Month | Start | End |  | Current Date
 |  |  |  |  |  | 1 | چیت | 2024-03-14 00:00:00 | 2024-04-13 00:00:00
 |  |  |  |  |  | 2 | ویساکھی | 2024-04-14 00:00:00 | 2024-05-14 00:00:00
 |  |  |  |  |  | 3 | جیٹھ | 2024-05-15 00:00:00 | 2024-06-14 00:00:00
 |  |  |  |  |  | 4 | ہاڑ | 2024-06-15 00:00:00 | 2024-07-15 00:00:00
 |  |  |  |  |  | 5 | ساون | 2024-07-16 00:00:00 | 2024-08-15 00:00:00
 |  |  |  |  |  | 6 | بھادوں | 2024-08-16 00:00:00 | 2024-09-14 00:00:00
 |  |  |  |  |  | 7 | اسو | 2024-09-15 00:00:00 | 2024-10-14 00:00:00 | Should be the right answer #7 اسو in L6
 |  |  |  |  |  | 8 | کاتک | 2024-10-15 00:00:00 | 2024-11-13 00:00:00
 |  |  |  |  |  | 9 | مگھڑ | 2024-11-14 00:00:00 | 2024-12-13 00:00:00
 |  |  |  |  |  | 10 | پوہ | 2024-12-14 00:00:00 | 2024-01-12 00:00:00 | Showing this answer which is wrong in L6
 |  |  |  |  |  | 11 | مگہ | 2024-01-13 00:00:00 | 2024-02-11 00:00:00
 |  |  |  |  |  | 12 | پھاگن | 2024-02-12 00:00:00 | 2024-03-13 00:00:00
Spreadsheet: dan_hyvl__4800__Engage Energy Contract Relationship
Sheet: Sheet1

Engage Energy Contract Relationship
 | Contract Type:
 | Master Firm Purchase Sale Agreement
 | 1) U.S.
 |  | Counterparty's |  |  | ENA |  | Engage Energy US
 |  | [NAME] |  |  | $10MM |  | $10MM
 |  | Outgoing Guaranty Amount |  |  | $25MM (a) |  | $25MM (b)
 |  | Guarantor |  |  | Enron Corp. |  | Coastal Corp.
 |  | Contacts: | Legal | [NAME] ([PHONE]) |  |  | [NAME] ([PHONE])
 |  |  | Credit | [NAME] ([PHONE]) |  |  | [NAME] ([PHONE])
 |  | (a)  Outgoing guaranty should cover ENA, EPMI, ECC, & Clinton Energy Management Services, Inc.
 |  | Also, the guaranty should reference this Master Firm Purchase Sale Agreement and the
 |  | existing Master Enegy Agreemen with EPMI
 |  | (b)  Incoming guaranty should cover ENA and HPLC.
 | 2) Canada
 |  | Counterparty's |  |  | ECC |  | Engage Energy Canada
 |  | [NAME] |  |  | $25MM |  | $15MM
 |  | Outgoing Guaranty Amount |  |  | $25MM |  | $15MM
 |  | Guarantor |  |  | Enron Corp. |  | Westcoast Gas Inc.
 |  | Contacts: | Legal | [NAME] ([PHONE]) |  |  | Suzzi Sethi ([PHONE])
 |  |  | Credit | [NAME] ([PHONE]) |  |  | [NAME] ([PHONE])
 | ISDA Agreements
 | 1) U.S.
 |  | Counterparty's |  |  | ENA |  | Engage Energy US
 |  | [NAME] |  |  | $25MM |  | $25MM
 |  | Outgoing Guaranty Amount |  |  | $25MM |  | $25MM
 |  | Guarantor |  |  | Enron Corp. |  | Coastal Corp.
 |  | Contacts: | Legal | [NAME] ([PHONE]) |  |  | [NAME] ([PHONE])
 |  |  | Credit | [NAME] ([PHONE]) |  |  | [NAME] ([PHONE])
 | 2) Canada
 |  | Counterparty's |  |  | ECC |  | Engage Energy Canada
 |  | [NAME] |  |  | $10MM |  | $10MM
 |  | Outgoing Guaranty Amount |  |  | $10MM |  | $10MM
 |  | Guarantor |  |  | Enron Corp. |  | Westcoast Gas Inc.
 |  | Contacts: | Legal | [NAME] ([PHONE]) |  |  | Suzzi Sethi ([PHONE])
 |  |  | Credit | [NAME] ([PHONE]) |  |  | [NAME] ([PHONE])
Spreadsheet: 789432d1659100264-usage-tier-formula-tier-example-1-
Sheet: Sheet1

June Usage | 4236000
 |  |  | Per unit Cost |  | Range Amount
Tier 1 | 2000000 | 2999999 | 0.00734
[NAME] | 3000000 | 3999999 | 0.00667
Tier 3 | 4000000 | 4999999 | 0.00638
Tier 1
Additional 999,999 | 999999
Additional 999,999
Spreadsheet: darrell_schoolcraft__7774__imbalsumm0106
Sheet: SoCal

 | 10487 |  | 56697
Day | Scheduled | Measured | Scheduled | Measured
1 | 782950 | 779895 | 30000 | 29986
2 | 812800 | 819915 | 30000 | 30022
3 | 804876 | 803751 |  | 698
4 | 812800 | 808945
5 | 810400 | 807889
6 | 813600 | 791590 | 20000 | 21853
7 | 813594 | 805336 |  | 388
8 | 767678 | 779447 | 20000 | 20777
9 | 591120 | 619044 | 50000 | 48771
10 | 591120 | 599411 | 20000 | 20881
11 | 803925 | 778362 | 20000 | 19954
12 | 811200 | 803990 | 4700 | 4657
13 | 810400 | 791338 |  | 19406
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  | -21565
2001-06-13 00:00:00
Spreadsheet: 728461d1618478097-formula-for-match-report-02
Sheet: WK02

Week 02
KPI |  |  | Delivery Performance
Service Type |  |  | TA |  |  | AM |  |  | A |  |  | True A (A - TA & AM) |  |  | B-D |  |  | Total Performance
Depot Number | Region | On [NAME] | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | %
Overall | N/A | N
001 - Depot 01 | H | Y
002 - Depot 02 | H | Y
003 - Depot 03 | M | Y
004 - Depot 04 | P | Y
005 - Depot 05 | H | Y
006 - Depot 06 | P | N
007 - Depot 07 | H | Y
008 - Depot 08 | M | Y
009 - Depot 09 | M | N
010 - Depot 10 | M | N
Spreadsheet: 153969d1336135795-conditional-formatting-help-needed-250-cells-with-one-cf-formula-cf-excelforum
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 7 | 8 | 9 | 10 | 11 | 14 | 15 | 16 | 17 | 18 | 21 | 22 | 23 | 24 | 25 | 28 | 29 | 30 | 31 | 32
Spreadsheet: 877977d1724923062-need-help-to-create-a-excel-sheet-for-calculating-average-annual-mileage-ptls-kilometers-2-365-aligw
Sheet: Sheet1

 | Car 1 | km | total distance | avarage per month | avarage yearly
 | 2022-06-07 00:00:00 | 104687
 | 29.08.2024 | 204561 |  | =D7/F6 | =G6*12months
 | = number of months between 07.06.2022 and 29.08.2024 around 24,8months?
 | Car 2
 | 2022-06-07 00:00:00 | 104687 km
 | 29.08.2024 | 204561 km
 | Number of months |  | (26,8 or something?)
 | total distance
 | avarage per month |  | (=totaldistance/26,8months)
 | avarage yearly |  | (=avarage month*12?)
 | 2022-06-07 00:00:00 | 29.08.2024 | = (number of months) Around 26,8months?
 | 104687 km | 204561 km | =(total distance)
Spreadsheet: 34238d1231393389-hlookup-vlookup-togethor-multiplelookupquery
Sheet: Sheet1

Name | 2008-01-08 00:00:00 | 2008-01-09 00:00:00 | 2008-01-10 00:00:00 | 2008-01-11 00:00:00 | 2008-01-12 00:00:00 | 2008-01-13 00:00:00 | 2008-01-14 00:00:00 | 2008-01-15 00:00:00
[NAME]
Smith
Leanne
[NAME]
 |  | 2008-01-08 00:00:00 | 2008-01-09 00:00:00 | 2008-01-10 00:00:00 | 2008-01-11 00:00:00 | 2008-01-12 00:00:00 | 2008-01-13 00:00:00 | 2008-01-14 00:00:00 | 2008-01-15 00:00:00
 | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Smith | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Leanne | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Spreadsheet: 99191d1297904320-weekly-and-monthly-reporting-test
Sheet: GROUP1

DATE | NAME | INVESTMENT | RETURN | ROI | +/- | TOTAL
2011-01-01 00:00:00 | A | 10 | 15 | 0.5 | 5 | 5
2011-01-02 00:00:00 | B | 20 | 10 | -0.5 | -10 | -5
2011-01-05 00:00:00 | C | 50 | 75 | 0.5 | 25 | 20
2011-01-08 00:00:00 | D | 20 | 35 | 0.75 | 15 | 35
2011-01-15 00:00:00 | E | 40 | 10 | -0.75 | -30 | 5
Spreadsheet: 48799d1248106655-sort-numbers-sorting-numbers
Sheet: Sheet1

 | 42 | 12 | 3 | 21 | 14
 | 2 | 21 | 33 | 19 | 24
 | 31 | 16 | 41 | 7 | 39
 | First option
 | 2 | 33 | 19 | 24 | #N/A
 | 31 | 41 | 7 | 39 | #N/A
 | 42 | 3 | 21 | 14 | #N/A
 | Second option
 | 12 | 14 | 21 | 42 | #N/A
 | 19 | 21 | 24 | 33 | #N/A
 | 16 | 31 | 39 | 41 | #N/A
Spreadsheet: 685121d1593747031-difficulties-using-solver-for-staff-schedule-complicated-criteria-set-schedule2
Sheet: Sheet1

Day | 1
 | Shift
Employee | A | B | C | D | E | Total
1 | 1 |  |  |  |  | <=1
2 |  | 1 |  |  |  | <=1
3 |  |  | 1 |  |  | <=1
4 |  |  |  | 1 |  | <=1
5 |  |  |  |  | 1 | <=1
6 |  |  |  |  |  | <=1
7 |  |  |  |  |  | <=1
 | =1 | =1 | =1 | =1 | =1
 | Day
Shift | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00
A | 1 | 2 | 2 | 2 | 1 |  | [NAME] consecutive X days | [NAME] consecutive nights | gap between day/night
B | 2 | 3 | 1 | 3 | 4
C | 3 | 4 | 5 | 5 | 3
D | 4 | 5 | 4 | 6 | 7
E | 5 | 6 | 6 | 7 | 6
Spreadsheet: 103536d1301311558-highlighting-cells-when-stock-is-low-stock-check-3-autosaved-
Sheet: CONSUMABLES

SUPPLIER | PRICE | TRADELINE | MATERIAL | STOCK AMOUNT | TARGET AMOUNT | ORDER AMOUNT | COST
 |  |  | CONSUMABLES
[NAME]
CBCTL-00160L | 1.45 |  | Masking Tape
[NAME] | 2.25 |  | Black Gaffa Tape
GLOVES N STUFF
GDVP | 3.4 | 2.80/ 10 Boxes | Large Latex Gloves
RBH | 16.49 |  | Black Bags (200) | 1
PBECF | 10.4 |  | Blue Roll (6 pack)
 | 21 | 15.75/10 | 3M 4279 Mask
G20823 | 3.5 | 2.59/10 | Red Welding Gloves
SBBGPG | 0.8 | .70/10 | Basic Goggles
SBBED | 2.2 | 1.87/10 | Basic Ear Defenders
TPW20 | 4.9 |  | Pallet Wrap
WURTH
89390010 | 33.18 |  | Super Clean 10L
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: AMX 

S.No | DESCRIPTION | MODEL | SERIAL NO | QTY
1 | AMX Touch Panel ([NAME]) | EXP-5231i | FG423-45, FG2255-50, FG5966-01, FG2105-05 | 1
2 | AMX remote kit | MIO Modero R-4 |  | 1
 | Charging cradle |  | FG147-02
 | R Series remotes |  | FG148-04
 | [NAME] |  | FG5391-01
3 | FG2105-08(NI-3101-SIG) |  |  | 6
4 | FG1350-20K( Exp-Total-aVX400-DC-UK, AVX-TO) |  |  | 3
7 | FG1103-04(DAS-TIO808-SIG) |  |  | 1
8 | FG423-45(PSNG-4, Power supply, 4.4 amp) |  |  | 5
9 | FG038-10(CB-TP5, [NAME] 5" wall conduct) |  |  | 2
10 | FG2605-81-Bl( ALD-CW-1-Bl-Claro wall plate |  |  | 6
11 | FG037-10(CB-MVPWDS |  |  | 1
12 | FG037-11(CB-MVP-WCS52) |  |  | 1
13 | FG1120-05(DAS-KPD-LCD-GW) |  |  | 3
 | BACK
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Oct

 | TLR Max Level | Number of Incidents
 | 1 | 5
 | 2a | 1
 | 2b | 1
 | 2c | 23
 | 3 | 7
 | 4 | 1
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-10-02 00:00:00 | 2c | 629 | MAIN | 15:34:00 | 00:17:00 | 08:43:00
1 | 1999-10-03 00:00:00 | 3 | 60 | SPP | 15:20:00 | 18:50:00
1 | 1999-10-07 00:00:00 | 3 | 75 | MAPP | 14:15:00 | 19:56:00
1 | 1999-10-07 00:00:00 | 3 | 126 | MAIN | 06:05:00 | 12:25:00
1 | 1999-10-08 00:00:00 | 4 | 103 | EES | 11:50:00 | 14:42:00
1 | 1999-10-11 00:00:00 | 2c | 270 | MAIN | 16:45:00 | 22:37:00
1 | 1999-10-11 00:00:00 | 3 | 30 | AEP | 13:00:00 | 22:30:00
1 | 1999-10-15 00:00:00 | 3 | 818 | MAPP | 13:00:00 | 22:26:00
1 | 1999-10-15 00:00:00 | 3 | 80 | MAPP | 09:00:00 | 22:26:00
Spreadsheet: 390665d1429719870-conditional-highlighting-based-on-comparison-to-business-targets-book2
Sheet: Sheet1

 | Ops Metrics | March
 | Call Center Metrics | Current Month | YTD | PY | Target | Q1 | Q2 | Q3 | Q4 |  | January | February | March | April | May | June | July | August | September | October | November | December
 |  |  |  |  | 0.6 |  |  |  |  | Target | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6
 |  |  |  |  |  |  |  |  |  | ACT
 |  |  |  |  |  |  |  |  |  | PY
 |  |  |  |  |  |  |  |  |  | Target | 7 | 6 | 5.5 | 5.2 | 4.9 | 4.7 | 4.4 | 4.1 | 3.9 | 3.6 | 3.6 | 3.6
 |  |  |  |  |  |  |  |  |  | ACT
 |  |  |  |  |  |  |  |  |  | PY
 |  |  |  |  | 0.05 |  |  |  |  | Target | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
 |  |  |  |  |  |  |  |  |  | ACT
 |  |  |  |  |  |  |  |  |  | PY
Spreadsheet: 38124d1236251550-excel-2007-significant-loss-of-functionality-error-forex-journal-live
Sheet: AUGTOTALS

DATE | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | Gross P/L | PIPS | DEPOSITS & WITHDRAWALS
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
 | WINS | LOSSES | WIN $ | LOSS $ | WIN % | LOSS % | ACCOUNT $ TOTAL | TOTAL PIPS | TOTAL $ IN/OUT
TOTALS
 | ACTUAL WIN/LOSS $ |  |  |  |  |  | AV. $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)