tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 85427d1285529905-autofill-vlookup-function-stats-aggregate-example
Sheet: Aggregate

ACW (target = 20 seconds) | Week 09 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49 | Week 50 | Week 51 | Week 52 | Week 01 | Week 02 | Week 03 | Week 04 | Week 05 | Week 06 | Week 07 | Week 08
user 1
user 2
user 3
user 4
user 5
user 6
user 7
user 8
user 9
user 10
user 11
user 12
user 13
user 14
user 15
user 16
user 17
user 18
user 19
user 20
user 21
user 22
Not Ready (target = 15%) | Week 09 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49 | Week 50 | Week 51 | Week 52 | Week 01 | Week 02 | Week 03 | Week 04 | Week 05 | Week 06 | Week 07 | Week 08
user 1
user 2
user 3
user 4
user 5
user 6
user 7
user 8
user 9
user 10
user 11
user 12
user 13
user 14
user 15
user 16
user 17
user 18
user 19
user 20
user 21
user 22
Transfers (target = 15%)
user 1
user 2
user 3
user 4
user 5
user 6
user 7
user 8
user 9
user 10
user 11
user 12
user 13
user 14
user 15
user 16
user 17
user 18
user 19
user 20
user 21
user 22
Hold (target = 70 seconds)
user 1
user 2
user 3
user 4
user 5
user 6
user 7
user 8
user 9
user 10
user 11
user 12
user 13
user 14
user 15
user 16
user 17
user 18
user 19
user 20
user 21
user 22
[NAME] (target = 7.00%)
user 1
user 2
user 3
user 4
user 5
user 6
user 7
user 8
user 9
user 10
user 11
user 12
user 13
user 14
user 15
user 16
user 17
user 18
user 19
user 20
user 21
user 22
Unplanned Break (target = 0.50%)
user 1
user 2
user 3
user 4
user 5
user 6
user 7
user 8
user 9
user 10
user 11
user 12
user 13
user 14
user 15
user 16
user 17
user 18
user 19
user 20
user 21
user 22
Spreadsheet: 771875d1646904420-help-with-formula-on-calculating-months-remaining-book1
Sheet: Sheet2

Inv No | Inv Total | Prepaid Months | Start Mnth | End Mnth | TO POST
INV-0214 | 6050 |  | 2022-01-01 00:00:00 | 2022-03-31 00:00:00
INV-0210 | 579.8 |  | 2022-01-01 00:00:00 | 2022-06-30 00:00:00
INV-0221 | 516 |  | 2022-01-01 00:00:00 | 2022-06-30 00:00:00
 | 10000 |  | 2022-01-01 00:00:00 | 2022-03-31 00:00:00
Spreadsheet: 773817d1648054793-printing-multiple-payslips-from-pdf-payslip-updated
Sheet: 1006

 | Company Name
 | Address
 | Pay slip for the month of March 2022
 | Emp Code |  | Emp Name
 | Earnings |  | Deduction
 | Basic |  | NI
 | Medical |  | TAX
 | CONV Allowance
 | HRA
 | Total Addition |  | Total Deduction
 |  |  | Net Salary
 | Date
 | Signature of Employee |  | Director
Spreadsheet: 29088d1223840366-populate-checkboxes-in-one-sheet-based-on-another-sheet-tracking-ver-1
Sheet: Sheet1

Project | Name | Address | Phone # | email | Work performed in US? | Subcontracting?
101 | [NAME] | 56 oak st | [PHONE] | [EMAIL] | 1 | 0
102 | [NAME] | 56 oak st | [PHONE] | [EMAIL] | 0 | 1
Spreadsheet: 734438d1622158028-vlookup-sum-ifsum-im-in-too-deep-test-schedule
Sheet: Sheet1

Employee list | SUN |  | MON |  | TUE |  | WED |  | THURS |  | FRI |  | SAT |  | Total Hours | SUN |  | MON |  | TUE |  | WED |  | THURS |  | FRI |  | SAT |  | Total Hours
May | 30 | HIDE | 31 | HIDE | 1 | HIDE | 2 | HIDE | 3 | HIDE | 4 | HIDE | 5 | HIDE |  | 6 | HIDE | 7 | HIDE | 8 | HIDE | 9 | HIDE | 10 | HIDE | 11 | HIDE | 12 | HIDE
 | 12p-4p |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | 8a-8:30p |  | 3:30p-MN |  | 1:30p-10p |  | - |  | 3:30p-MN |  | 3:30p-MN |  | - |  |  | - |  | 3:30p-MN |  | 3:30p-MN |  | - |  | - |  | 1:30p-10p |  | 8a-8:30p
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Manhours
6a-8a
8a-10a
10a-12p
12p-4p
4p-8p
8p-10p
10p-12a
12a-4a
4a-6a
Spreadsheet: 158724d1338377047-look-for-data-in-one-column-and-then-return-mean-average-calculated-from-another-column-0average
Sheet: Φύλλο1

a | red | 3.5 |  | green
b | blue | 4.2 |  |  | Column A Column B Column C
c | green | 3.8 |  |  | Petra Red 3.5
d | blue | 2.7 |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] 2.7
 |  |  |  |  | I would like Excel to be able to look in Column B for "Blue", then look at the results in Column C for those 'Blues' and return the mean average of their results (in this example, the average of 4.2 + 2.7). Is there a way I can do this, preferably without having to resort to pivot tables?
 |  | 3.5
 |  | 3.45 |  | 3.8
 |  | 3.8
Spreadsheet: ryan_slinger__33678__6_9act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: john_griffith__15788__10_19_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | EXP |  |  | 63.1 | 74 | 0.95 | 2001-10-16 14:40:00
 | CL Z1 | 22 | 258 | 268 | 55.2 | 57.4 | 0.78 | 2001-10-19 12:38:00
 | CL F2 | 22 | 360 | 370 | 52.7 | 54.2 | 0.74 | 2001-10-19 12:38:00
 | CL G2 | 22 | 420 | 432 | 49 | 50.4 | 0.69 | 2001-10-19 12:38:00
 | CL H2 | 22 | 465 | 475 | 47.3 | 48.4 | 0.66 | 2001-10-19 12:38:00
 | CL J2 | 22 | 487 | 502 | 44.6 | 46 | 0.63 | 2001-10-19 12:38:00
 | CL K2 | 22 | 508 | 525 | 42.2 | 43.6 | 0.59 | 2001-10-19 12:38:00
 | CL M2 | 22 | 525 | 535 | 40.6 | 41.4 | 0.57 | 2001-10-19 12:38:00
 | CL N2 | 22 | 528 | 538 | 38.2 | 38.9 | 0.53 | 2001-10-19 12:38:00
 | CL Q2 | 22 | 525 | 540 | 36 | 37 | 0.5 | 2001-10-19 12:38:00
 | CL U2 | 22 | 525 | 540 | 34.3 | 35.3 | 0.48 | 2001-10-19 12:38:00
 | [NAME] | 22 | 530 | 545 | 33 | 34 | 0.46 | 2001-10-19 12:38:00
 | [NAME] | 21.5 | 535 | 550 | 31.7 | 32.6 | 0.43 | 2001-10-19 12:38:00
 | CL M3 | 21.5 | 535 | 555 | 27 | 28 | 0.37 | 2001-10-19 12:38:00
 | CL Z3 | 21.5 | 535 | 555 | 24.1 | 25 | 0.33 | 2001-10-19 12:38:00
Spreadsheet: 169106d1342703832-matching-prop-refs-to-addresses-example
Sheet: Prop Ref

Prop Ref | No | Road |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage heaters - old. | Other gas fire(s) | Anthracite nuts | Gas inst. single pt |  |  |  | Living Room
1335001100 | 11 | ALDER DRIVE
1335001500 | 15 | ALDER DRIVE
1335001700 | 17 | ALDER DRIVE
1335001900 | 19 | ALDER DRIVE
1335002500 | 25 | ALDER DRIVE
1335002600 | 26 | ALDER DRIVE
1335002700 | 27 | ALDER DRIVE
1335002800 | 28 | ALDER DRIVE
1335002900 | 29 | ALDER DRIVE
1335003200 | 32 | ALDER DRIVE
1335003400 | 34 | ALDER DRIVE
1335004200 | 42 | ALDER DRIVE
1335004400 | 44 | ALDER DRIVE
1335004600 | 46 | ALDER DRIVE
1335004700 | 47 | ALDER DRIVE
1335004800 | 48 | ALDER DRIVE
1335004900 | 49 | ALDER DRIVE
1335005000 | 50 | ALDER DRIVE
1335005100 | 51 | ALDER DRIVE
1335005200 | 52 | ALDER DRIVE
1335005400 | 54 | ALDER DRIVE
1335006000 | 60 | ALDER DRIVE
1335006400 | 64 | ALDER DRIVE
1335006600 | 66 | ALDER DRIVE
1335006800 | 68 | ALDER DRIVE
1335007100 | 71 | ALDER DRIVE
1335007300 | 73 | ALDER DRIVE
1335007500 | 75 | ALDER DRIVE
1335007600 | 76 | ALDER DRIVE
1335007700 | 77 | ALDER DRIVE
1335008400 | 84 | ALDER DRIVE
1335008600 | 86 | ALDER DRIVE
1335008800 | 88 | ALDER DRIVE
1335009000 | 90 | ALDER DRIVE
1335010000 | 100 | ALDER DRIVE
1335010400 | 104 | ALDER DRIVE
1335010600 | 106 | ALDER DRIVE
Spreadsheet: 740058d1626169025-assign-unique-project-code-project-id-challenge-ans
Sheet: Sheet1

Company Name | Original ID | ID
ABC
ABCD
ACBDE
ABCDE |  |  |  |  |  |  |  |  |  | Requirements
dfsdsdf
sdfsdf |  |  |  |  |  |  |  |  |  | ID should equal first 5 characters of company name | Represented by 'Original ID' which is the value it would be if no dupes
sdfsdf |  |  |  |  |  |  |  |  |  | Where Company name < 5 characters, add trailing zeros to make up to 5 characters
sdfsdf
sdfsdf |  |  |  |  |  |  |  |  |  | If that ID has been taken already, then;
sdfdfsf |  |  |  |  |  |  |  |  |  | if last digit is not a number then replace with a "0"
ddddd |  |  |  |  |  |  |  |  |  | If last 2 digits = 99 then replace with '000'
sss99 |  |  |  |  |  |  |  |  |  | IF last digits is a "9" replace with "00"
ddddd99 |  |  |  |  |  |  |  |  |  | If last digit is any other number add one (eg if 4 replace it with a 5)
sd99
sdfsdf
gg
gs
sdfdsfsfsdf
Spreadsheet: lisa_gang__22235__EPE_MARCH_2002
Sheet: MARCH(27)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-27 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | PALO VERDE | PALO VERDE |  | FOUR CORNERS
Pacific | Mountain | SALE | SALE | SALE |  | PURCHASE
Standard | Standard | EPMI | PNM | PNM |  | PNM
Time | Time | 22.25
 |  | CARRY OVER FROM 3/26 | CARRY OVER FROM 3/26 | CARRY OVER FROM 3/26 |  | CARRY OVER FROM 3/26
 |  | 3/1/02-3/31/02 | 2002-03-26 00:00:00 | 2002-03-26 00:00:00 |  | 2002-03-26 00:00:00
 |  | EPMI TAG#41704 | IDAC TAG#P958E00 | WESCO TAG#58181 |  | EPMI TAG#41681 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL | DIRECT BILL |  | DIRECT BILL
2400 | 0100 | 25 | 25 | 25 |  | -50
0100 | 0200 | 0 | 0 | 0 |  | 0
0200 | 0300 | 0 | 0 | 0 |  | 0
0300 | 0400 | 0 | 0 | 0 |  | 0
0400 | 0500 | 0 | 0 | 0 |  | 0
0500 | 0600 | 0 | 0 | 0 |  | 0
0600 | 0700 | 0 | 0 | 0 |  | 0
0700 | 0800 | 0 | 0 | 0 |  | 0
0800 | 0900 | 0 | 0 | 0 |  | 0
0900 | 1000 | 0 | 0 | 0 |  | 0
1000 | 1100 | 0 | 0 | 0 |  | 0
1100 | 1200 | 0 | 0 | 0 |  | 0
1200 | 1300 | 0 | 0 | 0 |  | 0
1300 | 1400 | 0 | 0 | 0 |  | 0
1400 | 1500 | 0 | 0 | 0 |  | 0
1500 | 1600 | 0 | 0 | 0 |  | 0
1600 | 1700 | 0 | 0 | 0 |  | 0
1700 | 1800 | 0 | 0 | 0 |  | 0
1800 | 1900 | 0 | 0 | 0 |  | 0
1900 | 2000 | 0 | 0 | 0 |  | 0
2000 | 2100 | 0 | 0 | 0 |  | 0
2100 | 2200 | 0 | 0 | 0 |  | 0
2200 | 2300 | 0 | 0 | 0 |  | 0
2300 | 2400 | 0 | 0 | 0 |  | 0
2400 | 0100 | 0 | 0 | 0 |  | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  |  | TOTAL SALES |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)PV | EPE(G)PV |  | PNM(G)4C345
 |  | EPMI | PNM | PNM |  | EPMI
 |  | AZPS(T)FC3/PPD2 | EPMI | EPMI |  | EPE
 |  | WALC(T)PPD2/COOLIDGE | NEVP | NEVP |  | EPE(T4C345/4C345
 |  | CRSP(L)COOLIDGE | PAC | PAC |  | EPE(L)4C345
 |  |  | MORGAN | MORGAN
 |  |  | WESCO | RELIANT
 |  |  | IPC | EPME
 |  |  | ISO(T)PVD/SP15 | WESCO
 |  |  | IPC(L)SP15 | ISO(T)PVD/SP15
 |  |  |  | WESCO(L)SP15
Spreadsheet: 24170d1214315071-keep-track-of-accounts-by-date-sample
Sheet: QUERY

Terr ID | Employee | Invoice | Ord Date | Order No | Line | Ship To | Long Descr | Qty
234 | A | 82361984 | 2008-06-03 | E002136447 | 33 | EX773901 | TEST DATA | 1
232 | B | 82361987 | 2008-06-04 | E002137819 | 33 | EX773908 | TEST DATA | 1
233 | C | 823619741 | 2008-06-04 | E002137835 | 33 | EX774063 | TEST DATA | 1
234 | A | 823619115 | 2008-06-04 | E002137838 | 33 | [NAME] | TEST DATA | 1
234 | A | 823619677 | 2008-06-04 | E002137845 | 33 | EX526001 | TEST DATA | 1
232 | C | 823657962 | 2008-06-10 | E002146985 | 33 | EX737301 | TEST DATA | 1
234 | A | 823619119 | 2008-06-04 | E002137842 | 33 | EX773896 | TEST DATA | 1
Spreadsheet: 136035d1326379581-how-to-automatically-refresh-filter-by-data-shange-translated-workbook
Sheet: 6 class

Table of 6th classe
Number | Name Surname | Class | lesson1 | lesson2 | [NAME] | lesson4 | lesson5 | lesson6 | lesson7 | lesson8 | lesson9 | lesson10 | [NAME] | lesson12 | [NAME] | [NAME] | [NAME] | lesson16 | lesson17 | lesson18 | lesson19 | lesson20 | lesson21 | lesson22 | lesson23 | lesson24 | Choose lesson 25 type | [NAME] 26
Spreadsheet: 714613d1611308611-multiple-matches-in-a-cell-separated-by-line-break-multiple-matches-with-line-break
Sheet: Sheet1

Input | Match |  |  | Source: | Country | ID
ChinaRussiaBrazil | 1234 5432 6789 |  |  |  | China
China Russia | 1234 5432 |  |  |  | Russia
Rusia,Brazil | 6789 |  |  |  | Brazil
Brazil,-Russia | 6789 5432
China | 1234
Spreadsheet: darrell_schoolcraft__7563__2002 BLANCO HUB BUDGET
Sheet: 2002 HUB COMB

[NAME] (COMBINED)
2002 O&M BUDGET
 |  |  |  |  |  |  |  | SALARIES AND WAGES - 000 |  |  |  |  | EMPLOYEE EXPENSES - 050
 |  |  |  |  |  | SALARIES | TAXES/BENEFITS | TOTAL | 2001 EMPL | STAFF ADDS | 2002 EMPL |  | SMNR/SCHL | DUES | BUSINESS | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 62376 | 16049 |  | 1 | 0 |  |  | 0 | 0 | 5691
 | GAS CONTROL - ATTACHMENT #2 |  |  |  |  | 88862 | 23993 |  | 1.6 | 0 |  |  | 0 | 0 | 1552
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 41060 | 11219 |  | 0.76 | 0 |  |  | 0 | 0 | 1863
 |  |  | TOTAL
 |  |  |  |  |  |  | COMPANY EQUIP USE - 100 |  |  |  | SUPPLIES AND EXPENSES - 150
 |  |  |  |  |  | NUMBER | EXPENSE | POOL CAR | TOTAL |  | CHEMICALS | ELECT POWER | OTHERS | ENVIRON | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 0 | 4590 | 0 |  |  | 0 | 28688 | 25556 | 0
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  |  | TOTAL
 |  |  |  |  |  | OUTSIDE SERVICES - 200 |  |  |  |  | RENTS - 250
 |  |  |  |  |  | CNTRCTS | TMPRR | OTHERS | TOTAL |  | EQP | WRHS | OTHERS | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 18670 | 0 | 0 |  |  | 1147 | 0 | 0
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  |  | TOTAL
 |  |  |  |  |  | COMPUTER SERVICES - 600 |  |  |  |  | TOTAL | TOTAL | BUDGET
 |  |  |  |  |  | PC'S | CMNCTN | TOTAL |  |  | P/R | NON P/R | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 1147 | 0
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 0 | 2070
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0 | 0 | 0
 |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | SUMMARY
 |  |  |  |  |  | NUMBER OF |  |  | SALARIES | EMPLOYEE | COMPANY | SUPPLIES | OUTSIDE |  | COMPUTER | TOTAL
 |  | GROSS |  |  |  | EMPLOYEES | TAXES/BENEFITS |  | & WAGES | EXPENSES | EQP USE | EXPENSES | SERVICES | RENTS | SERVICES | NON P/R | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 1
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 1.6 |  |  |  |  | 0 | 0 | 0 | 0
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0.76 |  |  |  |  | 0 | 0 | 0 | 0
 | TOTAL GROSS
 | TRANSWESTERN OPERATIONS/GAS CONTROL/MARKET SERVICES (36.19%) $ 121,068
 | PNM (27.62%) $ 92,398
 | (15%) OVHD:    $ 10,091 (Payroll Only)
 | TOTAL:           $102,489
 | NWPL (36.19%) $ 121,067
 | (15%) OVHD:     $   13,222 (Payroll Only)
 | TOTAL:              $ 134,289
Spreadsheet: 142224d1329744276-formula-error-vbax-state-updtd
Sheet: OR

 |  |  | ITEM | Average TAT for Supplier Dispatch (from PO release to order readiness at [NAME]'s location) | Average Transit Time (from [NAME]'s factory to Indian Port of Entry) | Average TAT for custom clearance (for Imported Items only) | Average Transit Time for Receipt at TWH (either from CHA or domestic supplier location to TWH) |  | STATE | Item Code | Description | UOM | Capex/Opex | Aging | QTY | Value | Material Type | Logic | Month
 |  |  |  |  |  |  |  |  | KOL | IF008446 | 2 CORE 16 SQ MM CU ARMOURD | EA | Capex | 23 | 5 | 606.55 | New Stock |  | 2012-01-01 00:00:00
 |  |  |  |  |  |  |  |  | KOL | MW021075 | Ceragon - 18 GHz Single Polarization Antenna - 1.2 m | EA | Capex | 45 |  |  | Used stock in repairable condition |  | 2012-01-01 00:00:00
 |  |  |  |  |  |  |  |  | KOL | AC002008 | AIR CONDITIONER 4T X 1 PH (ROTARY COMPRESSOR) | EA | Capex | 432 |  |  | New Stock |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2 |  | KOL | MW077010 | CERAGON IP-10 R1 | EA | Capex | 170 | 30 | 1750330.8 | Used stock in Non Working Condition/Non-repairable Condition |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3 |  | KOL | N/A | Second Supporting Road For 1.8 MW Antenna | PCS | Capex | 56 | 9 | 16886.52 | New Stock |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3 |  | KOL | N/A | Second Supporting Road For 1.2 MW Antenna | PCS | Capex | 67 | 35 | 65669.8 | Non- Working Stock |  | 2012-01-01 00:00:00
 |  | 2012-01-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0 |  | KOL | MW021077 | Ceragon - 18 GHz Single Polarization Antenna - 1.8 m | EA | Capex | 91 | 2 | 138892.83428 | Repaired stock |  | 2012-01-01 00:00:00
 |  | 2012-02-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2
 |  | 2012-02-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3
 |  | 2012-02-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3
 |  | 2012-02-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0
 |  | 2012-03-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2
 |  | 2012-03-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3
 |  | 2012-03-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3
 |  | 2012-03-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0
 |  | 2012-04-01 00:00:00 | PDH Antenna | 0 | 7 | 2 | 2
 |  | 2012-04-01 00:00:00 | Microwave Hop | 0 | 4 | 2 | 3
 |  | 2012-04-01 00:00:00 | Indoor BTS | 0 | 9 | 1 | 3
 |  | 2012-04-01 00:00:00 | Outdoor BTS | 0 | 0 | 0 | 0
Spreadsheet: 741464d1627048706-formula-needed-to-autofill-times-based-on-values-excelforum-friday-23-july-2021
Sheet: Sheet3 (2)

 |  |  |  |  |  |  |  |  |  |  | LOADING TIME |  |  |  | OFFLOADING TIME
 | DATE | Loaded / Unloaded | DESTINATION | INVOICE | DELIVERY NOTE | WEIGHBRIDGE |  | VEHICLE | Delivery Note: | Time Start / Finish | WHEN STARTING TO LOAD | AFTER LOADING, BEFORE LEAVING | ODOMETER |  | BEFORE OFFLOADING AT CUSTOMER | AFTER [NAME] AT CUSTOMER, BEFORE LEAVING | TIME - LOADING | TIME - OFFLOADING | Travel Time | TOTAL | Time Available for Month | Day Total Hours | This column must be ZERO / OVERTIME
 |  |  |  |  |  | [NAME] |  |  | KM's charged |  |  |  | Opening | Closing
 |  |  |  |  |  | [NAME] | Ton
 | 2021-07-08 00:00:00 | Loaded |  |  |  |  |  |  |  | 700 | 710 | 720 | 32987 | 32998 | 730 | 740
 | 2021-07-08 00:00:00 | Unloaded |  |  |  |  |  |  |  |  |  | 740 |  | 33009 | 750
 | 2021-07-08 00:00:00 | Loaded |  |  |  |  |  |  |  |  | 750 | 800 |  | 33021 | 810 | 820
 | 2021-07-08 00:00:00 | Unloaded |  |  |  |  |  |  |  |  |  | 820 |  | 33033 | 830
 | 2021-07-08 00:00:00 | Loaded |  |  |  |  |  |  |  |  | 830 | 930 |  | 33059 | 1000 | 1030
 | 2021-07-08 00:00:00 | Unloaded |  |  |  |  |  |  |  |  |  | 1030 |  | 33084 | 1100
 | 2021-07-08 00:00:00 | Loaded |  |  |  |  |  |  |  |  | 1130 | 1200 |  | 33091 | 1300 | 1400
 | 2021-07-08 00:00:00 | Unloaded |  |  |  |  |  |  |  | 1700 |  | 1400 |  | 33100 | 1500
 | Aim of this exercise is to calculate:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUM of all hours used (Loading, Offloading, Travel Time and Unused Time to ensure hours captured balance with Hours Available (to ensure all hours are accounted for)
 | Loading Time
 | Offloading Time
 | Travel Time
 | Unused Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours available in working day
 |  |  |  |  |  |  |  |  |  | FORMULAS NEEDED:
 | 1 | Cell K5 |  |  |  |  |  |  |  | If first line of new date, autofill 07:00
 | 2 | Cell K12 |  |  |  |  |  |  |  | Last line of same date (before next new date), autofill 17:00 (IF it's Monday, Tuesday, Wednesday, Thursday, Friday) and 12:00 (IF it's Saturday)
 | 3 | Cell V12 |  |  |  |  |  |  |  | Total hours available in working day - autofill sum (based on value in cell K12, if cell in column K is blank, ignore and leave blank) to calculate difference of starting and finishing hours
 |  |  |  |  |  |  |  |  |  | 1 | starting | (see cell B23, Number 1)
 |  |  |  |  |  |  |  |  |  | 2 | finishing | (see cellB24, Number 2)
 | 4 | Cell W12 |  |  |  |  |  |  |  | SUM all hours / times from cell R5 to cell U12
Spreadsheet: 829685d1684393400-creating-list-from-numeric-range-sample
Sheet: Sheet1

POINT RANGE |  |  | POINT LIST
Start | End |  | 4
4 | 7 |  | 5 |  | 5
12 |  |  | 6 |  | 6
15 | 17 |  | 7 |  | 7
21 |  |  | 12 |  | 12
25 | 26 |  | 15 |  | 15
 |  |  | 16 |  | 16
 |  |  | 17 |  | 17
 |  |  | 21 |  | 21
 |  |  | 25 |  | 25
 |  |  | 26 |  | 26