tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 829777d1684437386-using-dates-s666-pq-using-dates
Sheet: Sheet1

Name | Start | End |  | Name | Start | End | Days-ThreeYearsBackFromToday
1 | 2014-03-12 00:00:00 | 2026-05-15 00:00:00 |  | 1 | 2014-03-12 00:00:00 | 2026-05-15 00:00:00 | 1095
2 | 2021-04-19 00:00:00 | 2022-05-05 00:00:00 |  | 2 | 2021-04-19 00:00:00 | 2022-05-05 00:00:00 | 381
3 | 2019-04-01 00:00:00 | 2021-09-05 00:00:00 |  | 3 | 2019-04-01 00:00:00 | 2021-09-05 00:00:00 | 888
Spreadsheet: 846126d1697439335-excel-formula-with-multiple-conditions-example_20231016
Sheet: Blad1

 |  |  |  |  |  |  |  |  | Column1 | Column2
 |  |  |  |  |  |  |  |  | 1.1 | PIPE BLK
 |  |  |  |  |  |  |  |  | 1.2 | PIPE GAL
 |  |  |  |  |  |  |  |  | 1.3 | RHS PTD
 |  |  |  |  |  |  |  |  | 1.3 | RHS BLK
 |  |  |  |  |  |  |  |  | 1.4 | RHS GAL
 |  |  |  |  |  |  |  |  | 1.5 | C/RAIL BLACK
 |  |  |  |  |  |  |  |  | 1.6 | C/RAIL GAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell you want to show result in:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Formulatext
 |  |  | D23 | E23 |  |  | H23
 |  |  | RHS PTD |  |  |  | 22.34
Spreadsheet: stacey_white__38954__13617_EPMI-LT-SW_deal_sum
Sheet: _tmp_13617_EPMI-LT-SW_deal_sum

 |  |  |  |  |  |  | ENRON POW | ER TRADING & | [NAME] |  |  |  |  |  | Run Date | :       10/16 | /01
Report Da | te:  10/15/01 |  |  |  |  |  |  | Deal [NAME] | y |  |  |  |  |  | Run Time | :       14:34 | :21
Post ID: | 13617
Desk: EPM | I-LT-SW
 |  | Trade | Start | End |  |  |  |  |  |  |  |  |  | Current |  |  |  | Prior Day | Prior
Deal | Counter | Date | Date | Date | Anty | Delivery | PV'd | Swap Vol | PV'd | Option Vol | Notional | Deal Vol |  | Deal | MTM P/L |  | LTD | Hedge | Day
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | Y/N | Point | Peak | [NAME] | Peak | [NAME] | Peak | [NAME] | Price Mid | Basis Mid | Total Mid | Prudent | Liquidations | Management | Liquidations
--------- | ------------------ | -------- | -------- | -------- | ---- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ---------------- | --------------- | -------------
663843 | NEWPOWCOM | 2001-06-26 00:00:00 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | No | SP-15 | 0 | 20523 | 0 | 0 | 0 | 20625 | -269499 | 0 | -269499 | -271551 |  | -8006 | 13016
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R11 |  |  |  |  |  | 0 | 20523 | 0 | 0 | 0 | 20625 | -269499 | 0 | -269499 | -271551 |  | -8006 | 13016
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Total Pow | er Price Book |  |  |  |  |  | 0 | 20523 | 0 | 0 | 0 | 20625 | -269499 | 0 | -269499 | -271551 |  | -8006 | 13016
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Spreadsheet: 118894d1314086703-pull-out-data-from-an-array-copy-of-book1-1-
Sheet: Sheet1

Block of data
Approved |  | 2011-08-19 00:00:00 | A
Approved |  | 2011-08-19 00:00:00 | B
Rejected |  | 2011-08-19 00:00:00 | C
Approved |  | 2011-08-19 00:00:00 | D
Approved |  | 2011-08-19 00:00:00 | E
Approved |  | 2011-08-19 00:00:00 | F
Rejected |  | 2011-08-19 00:00:00 | G
Approved |  | 2011-08-19 00:00:00 | S
Approved |  | 2011-08-19 00:00:00 | T
Rejected |  | 2011-08-19 00:00:00 | U
Approved |  | 2011-08-19 00:00:00 | V
Approved |  | 2011-08-19 00:00:00 | W
Approved |  | 2011-08-19 00:00:00 | X
Rejected |  | 2011-08-19 00:00:00 | Y
Result I want
Approved |  | 2011-08-19 00:00:00 | A |  |  |  |  | Note: array formual is used and should be confirmed though Ctrl+Shift+Enter
Approved |  | 2011-08-19 00:00:00 | B
Approved |  | 2011-08-19 00:00:00 | D
Approved |  | 2011-08-19 00:00:00 | E
Approved |  | 2011-08-19 00:00:00 | F
Spreadsheet: 270607d1381543892-sum-of-alphanumeric-and-absolute-values-scsolution
Sheet: Variance Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MB
 |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x
 | DM: |  |  |  |  | MPV |  |  |  |  |  | MQV
 |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x
 | DL: |  |  |  |  | LRV |  |  |  |  |  | LEV
 |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x
 | VOH: |  |  |  |  | VOHSV |  |  |  |  |  | VOHEV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | FOH: |  |  |  |  | FOHSV |  |  |  |  |  |  |  |  |  |  | VV
 | TOH:
 | TMC:
Spreadsheet: 695086d1600040164-need-help-creating-po-with-existing-information-sample-pricing
Sheet: PO Creation

 |  |  | Doors
 |  | Description | Type | Height | [NAME] | Lock Body | Barrell Type | Multi Lock | [NAME] | Pet Flap | Total
 |  | Front Door | BELLA HD | 2100 | 720 | Austral Elegance | Austral Elegance | Austral | [NAME] | N/A | 358.53
 |  | Back | BELLA HD | 2100 | 720 | Austral Elegance | Austral Elegance | Austral | [NAME] | N/A | 358.53
 |  | Guest | Secure View SD | 2100 | 1200 | Lockwood 8654 | N/A | Lockwood Triple | JPHDD21 | N/A | 572
 |  |  | Windows
 |  | Description | Type | Height | [NAME] | Quantity |  |  |  |  | Total
 |  | Bed 1 | BELLA | 1800 | 900 | 1 |  |  |  |  | 193.8
 |  | Bed 2 | BELLA | 1900 | 1200 | 4 |  |  |  |  | 972.8
 |  | Guest | Secure View SD | 2100 | 1200 |  |  |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  | JPHDD21 |  | N/A
Spreadsheet: 764604d1642814261-summary-tab-from-inconsistent-data-structure-and-location-sample
Sheet: Compact Cars

Compact Cars
[NAME] |  |  |  | Toyota |  |  | Honda |  |  | Lexus
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Car Price |  |  |  | 30000 |  |  | 32500 |  |  | 33000
Price with Tax
Spreadsheet: 786162d1657019297-ranking-based-on-multiple-criteria-temp111
Sheet: Sheet3

Status | Assigned To Name? | Project | Count of Tickets | Top Z | FORMULA
Open | Name-1 (P1) | Project-1 | 2 | 4
Open | Name-1 (P1) | Project-1 | 2 | 4 |  |  | QNS?
Open | [NAME] (P1) | Project-1 | 3 | 3
Open | [NAME] (P1) | Project-1 | 3 | 3 |  |  | Rank in Column E should be based on the combination of values in Column A, Column B, Columns C and the absolute value in Column D.  E.g. Row 1 to 17, Column-D had a value of 7 (Row 7 - 13) which is the highest for the Project-1 (Column C)  Similarly Row 18 - 32, Column-D had a value of 8 (Row 20 - 27)) which is the highest for the Project-2 (Column C)
Open | [NAME] (P1) | Project-1 | 3 | 3
Open | Name-3 (P1) | Project-1 | 7 | 1
Open | Name-3 (P1) | Project-1 | 7 | 1
Open | Name-3 (P1) | Project-1 | 7 | 1
Open | Name-3 (P1) | Project-1 | 7 | 1
Open | Name-3 (P1) | Project-1 | 7 | 1
Open | Name-3 (P1) | Project-1 | 7 | 1
Open | Name-3 (P1) | Project-1 | 7 | 1
Open | Name-4 (P1) | Project-1 | 2 | 4
Open | Name-4 (P1) | Project-1 | 2 | 4
Open | Name-5 (P1) | Project-1 | 4 | 2
Open | Name-5 (P1) | Project-1 | 4 | 2
Open | Name-6 (P1) | Project-2 | 3 | 3
Open | Name-6 (P1) | Project-2 | 3 | 3
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-7 (P1) | Project-2 | 8 | 1
Open | Name-8 (P1) | Project-2 | 5 | 2
Open | Name-8 (P1) | Project-2 | 5 | 2
Open | Name-8 (P1) | Project-2 | 5 | 2
Open | Name-8 (P1) | Project-2 | 5 | 2
Open | Name-8 (P1) | Project-2 | 5 | 2
Spreadsheet: 474340d1470736727-return-max-and-min-values-from-data-between-two-dates-times-max-and-min-between-times
Sheet: Sheet1

 | Time From | value
 | 2016-08-09 15:00:00 | 20 |  | min
 | 2016-08-09 15:05:00 | 120 |  | [NAME]
 | 2016-08-09 15:30:00 | 245
 | 2016-08-09 15:37:00 | 280
 | 2016-08-09 15:52:00 | 280
 | 2016-08-09 16:00:00 | 376
 | 2016-08-09 16:07:00 | 460
 | 2016-08-09 16:30:00 | 460
Spreadsheet: 755045d1636644086-lookup-multiple-columns-to-return-value-example-list2
Sheet: Sheet1

Acct # | [NAME] # | Dep - example of what I want it to say | Amt
TS067908 | 1
TS067566 | 1
GW088036 | 1
GW088244 | 1
MW166153 | 1
MW179521 | 1
MW179529 | 1
MW180044 | 1
MW177508 | 1
CC167234 | 1
CC169916 | 1
CC172877 | 1
CD325354 | 1
CD317969 | 1
CD325808 | 1
CD321383 | 1
CD325896 | 1
CD325537 | 1
BS302805 | 1
OL553783 | 1
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -248536 | -247815
2 | -256988 | -257667
3 | -177704 | -177700
4 | -184043 | -182700
5 | -102760 | -120064
6 | -159504 | -157450
7 | -146645 | -155851
8 | -147570 | -155884
9 | -67555 | -76928
10 | -98016 | -106532
11 | -99217 | -97700
12 | -157690 | -156351
13 | -159519 | -157722
14 | -161298 | -157663
15 | -199783 | -198440
16 | -183992 | -183889
17 | -190001 | -177700
18 | -175992 | -180170
19 | -205510 | -207782
20 | -208295 | -208000
21 | -205676 | -208000
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 59071
2002-01-21 00:00:00
CBS Dollars
 |  |  | -80543.15
Spreadsheet: 31227d1227024843-finding-values-in-rows-column-and-liner-interpolation-between-them-example
Sheet: Sheet1

A | 1.61
B | 1.75
 | 1 | 1.5 | 2
1 | 0.2342 | 0.2786 | 0.3078
1.5 | 0.1438 | 0.183 | 0.2098
2 | 0.0939 | 0.1279 | 0.1457
3 | 0.0473 | 0.0672 | 0.0823
Spreadsheet: 68210d1268756104-scatter-chart-labelling-721952
Sheet: Sheet1

labels | ValueX | ValueY | Legend |  | Traditional Bermudian | Lloyds - Onshore | New Bermudian
Ace | 17.4 | 0.89 | Traditional Bermudian | 17.4 | 0.89 | #N/A | #N/A
Allied World | 2.3 | 0.71 | New Bermudian | 2.3 | #N/A | #N/A | 0.71
Amlin | 3.2 | 1.31 | Lloyds - Onshore | 3.2 | #N/A | 1.31 | #N/A
Arch | 4.1 | 1.05 | New Bermudian | 4.1 | #N/A | #N/A | 1.05
Argo | 0.9 | 0.57 | New Bermudian | 0.9 | #N/A | #N/A | 0.57
Aspen | 2.2 | 0.83 | New Bermudian | 2.2 | #N/A | #N/A | 0.83
Spreadsheet: 77931d1278423747-excel-2007-excel-formulae-wbds-new
Sheet: CC Chqs

Hart Hotels |  |  |  |  |  |  |  |  | Week Ending:
Credit cards receipts and cheques banked |  |  |  |  |  |  |  |  | Period:
Fife Arms Hotel |  |  |  |  |  |  |  |  | Week:
Trans. | Switch / Mastercard / Visa |  |  |  | BACS |  |  |  | Cheques
Number | Date | Card Type | Amount |  | Name | Date | Amount |  | Name | Date | Amount
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
Totals: |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 793780d1661710087-would-appreciate-help-creating-a-worksheet-for-income-expense-simple-budget-personal-finance-template
Sheet: Feb

 |  | 2022-02-01 00:00:00
 |  |  |  |  |  |  | Credit Card #2 |  |  |  |  | Credit Card #2
 | Cheque |  | Debit | Credit
Date | Number | Description | Amount | Amount |  |  | Date | Description | Amount |  |  | Date | Description | Amount
 |  | Brought forward |  | 0 | >> from previous month
 |  | Monthly Income |  |  | >> Monthly income
 |  | Monthly Expenses |  |  | >> Regular Montlhly payments
 |  | Debit Card Transactions |  |  | >> Montlhly Credit card [NAME]
 |  | Credit card #1 |  |  | >> Montlhly Debit card [NAME]
 |  | Credit card #2 |  |  | >> Montlhly Debit card [NAME]
 |  | Total Debits |  |  | .>> Total Monthly Outgoings
 |  | Total Credits |  |  | >> Total income inc Brought Forard
 |  | Total Balance |  |  | >> Balance (dynamic) for this month
 |  | Regular Income
 |  | Salary |  | 2000
 |  | Interest Income |  | 77
 |  | Dividends |  | 142 |  |  |  | TOTAL
 |  | Rent Iincome
 |  | Regular Outgoings |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | Standing Orders/Direct Debits
 |  | Utilities | 252
 |  | Food | 350
 |  | Internet | 39
 |  | Cell Phone | 25
 |  | Cable Tv | 50
 |  | Home Insurance | 20
 |  | Health Insurance | 129
 |  | Car insurance | 97
 |  | Mortgage Payment | 300
 |  | Clothing | 200
 |  | Fuel | 150
 |  | Investing | 300
 |  | Debit Card Transactions
Spreadsheet: 684138d1593171171-formula-to-expand-retract-table-b-according-to-entry-actions-on-table-a-logged
Sheet: TimeOut

TO # | Weekday | Date | Present | Dur1 | Dur2 | Dur3 | Dur4 | Dur5 | Dur6 | Dur7 | Dur8 | Dur9 | Dur10 |  |  | Date | Time Outs | Average
 |  | 2017-01-01 00:00:00 | No
 |  | 2017-01-02 00:00:00 | Yes | 34 | 47 | 56 | 22 | 11 | 6 | 33 | 53
 |  | 2017-01-03 00:00:00 | Yes | 26
 |  | 2017-01-04 00:00:00 | Yes | 34
 |  | 2017-01-05 00:00:00 | Yes | 22 | 25 | 27
 |  | 2017-01-06 00:00:00 | Yes | 15 | 21 | 31
 |  | 2017-01-07 00:00:00 | No
 |  | 2017-01-08 00:00:00 | No
 |  | 2017-01-09 00:00:00 | Yes | 32 | 23 | 10 | 24 | 23 | 34
 |  | 2017-01-10 00:00:00 | Yes | 23 | 25
 |  | 2017-01-11 00:00:00 | Yes | 34 | 56 | 34 | 21 | 24 | 36
 |  | 2017-01-12 00:00:00 | Yes | 22
 |  | 2017-01-13 00:00:00 | Yes | 24 | 30 | 26 | 14
 |  | 2017-01-14 00:00:00 | No
 |  | 2017-01-15 00:00:00 | No
 |  | 2017-01-16 00:00:00 | No
 |  | 2017-01-17 00:00:00 | Yes | 24 | 14 | 28 | 34 | 16 | 18 | 13 | 13
 |  | 2017-01-18 00:00:00 | Yes | 24
 |  | 2017-01-19 00:00:00 | Yes | 16
 |  | 2017-01-20 00:00:00 | Yes | 28 | 34 | 16 | 18
 |  | 2017-01-21 00:00:00 | No
 |  | 2017-01-22 00:00:00 | No
 |  | 2017-01-23 00:00:00 | Yes | 10 | 24 | 23 | 34
 |  | 2017-01-24 00:00:00 | Yes | 10 | 24 | 23
 |  | 2017-01-25 00:00:00 | No
 |  | 2017-01-26 00:00:00 | Yes | 22 | 12 | 14
 |  | 2017-01-27 00:00:00 | Yes | 22 | 12
 |  | 2017-01-28 00:00:00 | No
 |  | 2017-01-29 00:00:00 | No
 |  | 2017-01-30 00:00:00 | Yes | 12 | 14 | 17
 |  | 2017-01-31 00:00:00 | Yes | 13 | 14 | 15
 |  | 2017-02-01 00:00:00 | Yes | 16 | 17
 |  | 2017-02-02 00:00:00 | Yes | 18 | 19
 |  | 2017-02-03 00:00:00 | Yes | 20 | 21
 |  | 2017-02-04 00:00:00 | No
 |  | 2017-02-05 00:00:00 | No
 |  | 2017-02-06 00:00:00 | Yes | 22 | 23
 |  | 2017-02-07 00:00:00 | Yes | 24
 |  | 2017-02-08 00:00:00 | Yes | 25 | 26 | 27
 |  | 2017-02-09 00:00:00 | Yes | 28
 |  | 2017-02-10 00:00:00 | Yes | 29 | 30 | 31
 |  | 2017-02-11 00:00:00 | No
 |  | 2017-02-12 00:00:00 | No
 |  | 2017-02-13 00:00:00 | Yes | 19 | 23
 |  | 2017-02-14 00:00:00 | Yes | 29 | 65
 |  | 2017-02-15 00:00:00 | Yes | 66
 |  | 2017-02-16 00:00:00 | Yes | 52
 |  | 2017-02-17 00:00:00
 |  | 2017-02-18 00:00:00
 |  | 2017-02-19 00:00:00
 |  | 2017-02-20 00:00:00 | Yes
Spreadsheet: 159715d1338824952-add-new-raws-without-changing-column-numbering-and-referenced-cells-sample1
Sheet: break Down

OPERATION BULLETIN
BUYER |  | ITEM
STYLE |  | NO OF WORKERS
 |  | TARGET
 |  | S/N
 |  | O/L
 |  | 3T O/L
 |  | 4T O/L
 |  | 5T O/L
 |  | F/L
 |  | PICOT
 |  | HEL
 |  | D/N
NO | OPERATION | M/C | S.M.V | [NAME] | MAN | [NAME]
 |  |  |  | Hr | LVL | 8 Hr
1 | SDSDSDSA | 380 | 0.45
2
3
4 | dfdfdfdsfds | S/N | 0.25
5
6
7
8
9
10
11
12 |  |  |  |  |  |  |  |  | I NEED TO INSERT NEW RAWS WITHOUT ANY EFFECT ON A1 COLUMN NUMBERING ORDER…THAT MEANS IT HAS TO BE AUTOMATICALY ADJEST..
13 |  |  |  |  |  |  |  |  | BUT IT SHOULD NOT EFFECT ON LAST NUMBER OF THE SET  THAT MEANS LAST NUBER HAS TO BE INCREASED ACCORDINGLY…
14
15
 |  |  |  |  |  |  |  |  | PLZZZ…PLZZ HELP ME….
16 |  |  |  |  |  |  |  |  | AND ALSO IM VERY GLAD IF IT IS POSSIBLE TO MOVE REFERECED CELLS OF LAYOUT WORKSHEET  IN THE CASE OF RELEVENT NUMBER OF A1 COLUMN OF THE  BREAKDOWN WORKSEET
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
 | hfghfgh |  | 0.253
I | IRON
F | FOLDING
P | POLY BAGGING
C | CHECKING
S | SPC
 | TOTAL
 | ________________________ |  | ________________________
 | WORK STUDY EXECUTIVE |  | WORK STUDY MANAGER
NO | MACHINE TYPE | FEEDING TIME
1 | S/N | 3
2 | 522 | 4
3 | 380 | 4
4 | O/L | 3
5 | 3T O/L | 5
6 | 4T O/L | 5
7 | F/L HEM | 6
8 | F/L CY | 6
9 | F/L COV | 6
10 | F/L BIN | 6
11 | F/L FLAT | 6
12 | D/N | 6
13 | B/ATT | 5
14 | B/HOLE | 5
15 | B/TACK | 5
16 | SNAP
17 | IRON
18 | HEL | 3
Spreadsheet: 718161d1613028319-required-formula-to-monitor-expenses-sampledata_expenses
Sheet: Data

 | Expenses Register
 | Name | Month | Week | Papers | [NAME] | Tea | Meals
 | [NAME] | Jan-21 | 24-Jan-21 To 30-Jan-21 | 20 | 5 | 5 | 50
 | [NAME] | Jan-21 | 27-Dec-20 To 02-Jan-21 |  | 4 | 10 | 25
 | Vincy | Jan-21 | 24-Jan-21 To 30-Jan-21 | 3 | 2 | 3 | 5
 | Glady | Jan-21 | 24-Jan-21 To 30-Jan-21 | 2 | 4 | 6 | 10
 | Glady | Feb-21 | 07-Feb-21 To 13-Feb-21 | 5 | 5 | 2 | 4
 | [NAME] | Feb-21 | 14-Feb-21 To 20-Feb-21 | 3 | 2 | 7 | 3
 | Meryl | Feb-21 | 07-Feb-21 To 13-Feb-21 | 3 | 7 | 4 | 4
 | [NAME] | Feb-21 | 07-Feb-21 To 13-Feb-21 | 10 |  | 3 | 10
 | Vincy | Feb-21 | 07-Feb-21 To 13-Feb-21 |  |  | 5 | 5
 | Meryl | Feb-21 | 14-Feb-21 To 20-Feb-21 | 2 | 7 | 6 | 7
Spreadsheet: 540832d1507003695-check-count-between-two-cells-off-days-check
Sheet: Check

 |  |  |  |  |  |  |  | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur
STAFF NO. | NAME | NORMAL DAYS | SL(Full) | SL(Half) | SL(Nill) | OVERTIME (Off Days) | OVERTIME (Hours) | 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 | INTERVAL |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | A | B | C | D | E | F | G | H | I | J | K
1 | [NAME] | 31 | 0 | 0 | 0 | 0 | 15 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
2 | Cameroon | 31 | 0 | 0 | 0 | 1 | 38 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
3 | Sachin | 31 | 0 | 0 | 0 | 1 | 11.5 | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | -
4 | Tendulkar | 27 | 0 | 0 | 0 | 0 |  | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | -
5 | Rahul | 30 | 1 | 0 | 0 | 0 |  | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | - | - | - | - | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
6 | [NAME] | 31 | 0 | 0 | 0 | 0 |  | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | -
7 | Narain | 20 | 0 | 0 | 0 | 0 |  | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | -
8 | Karthik | 31 | 0 | 0 | 0 | 0 |  | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | -
9 | Dhoni | 31 | 0 | 0 | 0 | 0 |  | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | OFF | OFF | -
10 | Singh | 12 | 0 | 0 | 0 | 0 | 8.75 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 712631d1610355618-weighted-average-through-sumproduct-weighted-average
Sheet: Sheet1

Cost | Labour |  | Cost | Mats |  | Cost | Sub-Con |  | Cost | Weighted Average | Average | Should be
509.98 | 7 |  | 0 | 0 |  | 0 | 0 |  | 509.98 |  |  | 7
220.05 | 9 |  | 0 | 0 |  | 0 | 0 |  | 220.05 |  |  | 9
454.22 | 9 |  | 0 | 0 |  | 30 | 7 |  | 484.22 |  |  | 8.8ish
Spreadsheet: 155622d1336993330-subtotal-of-sumproducts-sumproduct-filtering-helpsheet
Sheet: Sheet1

 |  |  | Unfactored
 |  |  | Factored
 | Region | Country | Probaility | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Total
 | a | x | 0.25 | 100
 | b | y | 1 |  | 200
 | b | z | 0.75 |  |  |  | 100
 | c | z | 0.5 | 500
 | d | x | 0.5 |  |  | 200
 | a | y | 1 |  |  | 100
 | c | y | 0.25 | 50
 | c | y | 1 |  |  | 200
 | d | z | 1 |  |  |  | 300
 | b | x | 1 |  |  |  |  | 500
Spreadsheet: 792408d1660890260-subtracting-and-adding-automatically-stock-spreadsheet-autorecovered-
Sheet: TEL_DURBANVILLE FSOD-ME

DURBANVILLE FSOD-ME | Date
PO: | 2022-08-16 00:00:00
Telkom  - BLT, MACH, 12MM, 1.75MM, 165MM, 60MM, GS, HEX | -200
Telkom - BRKT - VERT E OPTCL CABL, 25x442x6mm | -500
Telkom - BRKT - VERT U, OPTCL CABL, 25x200x5mm | 100
Telkom - BX, DISTRN, BUDI-2S 2-36 SPLIC
Telkom - BX, DISTRN, RHI-NODE 300STD OPN-PAL
Telkom - CB;. FP. S,-BI-G657A2 1LT PC, 12, 2.1MM
Telkom - CBL, FO - AERL, 12, 1310/1550NM, SM
Telkom - CBL, FO - MCR UG 12G.652D BLOWN, 12, HDPE
Telkom - CBL, FO - MCR UG G.652D BLOWN, 24, HDPE, 1.7MM
Telkom - CBL, FO - MCR UG G652D BLOWN, 48 HDPE, 1.7MM
Telkom - CBL, FO - SM-BI-G657A2 1LT PC, 12, 2.1mm
Telkom - CBL, FO - SM-BI-G657A2 1LT PC, 6, 2.1mm
Telkom - CBL, FO - SM-BI-G657D, 96 HDPE, 1.4MM
Telkom - CBL, FO - SM-BI-G657D1, 144, HDPE, 1.4mm
Telkom - CBL, FO, AERL, 24 1310/1150NM, SM
Telkom - CBL, FO, MCR UG G652D BLOWN, 72, HDPE, 1.7MM
Telkom - CBL, FO, MCR UG, BLOWN, 36, PE, ORNG
Telkom - CBL, FO, SHRT SPAN AERL, 36, PE BLK
Telkom - CBL, FO, SM, 48, PE, 1.9MM
Telkom - CBL, FO, SM, 72, PE, 1.9MM
Telkom - CLSUR - B8G Splic 72F, EMTY, ADPTR PNL
Telkom - CLSUR - SPLIC, PLP STR-JR, 12F
Telkom - CLSUR, TENIO-B6 48F SEAL BRKT
Telkom - CLSUR, TENIO-B6 96F SEAL BRKT
Telkom - CLSUR- TENIO-B6 144F SEAL BRKT
Telkom - DBL HOOKS
Telkom - DEDND, PRFRMD THMBL, FDES 366/374, GS
Telkom - DUCT - 2 WAY FLAT, 16-13MM, HDPE BLK
Telkom - HOOK, TRMN, DIA 10MM, GS
Telkom - Kit - Gel Seal RND 4 Way Gen2
Telkom - KIT, CUST - BUDI-1S SPLC 36-96 FB
Telkom - KIT, FOSC-A-SEAL-INT, 12-48 FBR CNT
Telkom - KIT, JOINTING PIT RHI-NODE 600 SPLT BSE
Telkom - KIT, LCKBL SQ 600MM FRM & CVR JNT PIT 9B
Telkom - MCRDCT - BUNDLED, GRN, 2 WAY, 8/5MM
Telkom - MCRDCT - BUNDLED, GRN, 4 WAY, 8/5MM
Telkom - MCRDCT - NON RODNT PFR, 1 WAY, ORNG, 12/10MM
Telkom - MCRDCT - SNGL, DARK BLUE, 8/5MM
Telkom - MICRODUCT - 2, 10/12MM HDPE
Telkom - MICRODUCT - 4, 10/12MM HDPE
Telkom - PIPE, NON METLC, POLYETHEL, 32MM, RED
Telkom - PIPE, NON METLC, POLYETHYLN GRN, 95MM, 6M
Telkom - PNL - 19IN, FOWB
Telkom - PNL, Patch - FOWB-T-NNNNN - EMPTY
Telkom - PNL, PATCH - MFPS-JED-P-SKL1-144, LC/PC LH
Telkom - POLE, PWR, MED DUTY, 7M, WOD, RNDED, CCA TRTD
Telkom - SEAL - TENIO-SKG3 5-8MM CABL DIA, 3 PORT
Telkom - SEAL, TENIO-SKG2 11-14MM CABL DIA, 2 PORT
Telkom - SEAL, TENIO-SKG3 5-8MM CBL DIA, 3 PORT
Telkom - SEAL, TENIO-SKG3 7-10MM CABL DIA, 3 PORT
Telkom - SEAL, TENIO-SKG4 3-6MM CABL DIA, 4 PORT
Telkom - SLV, FBR SPLIC PRTCTR, 45MM
Telkom - SPLTR, FO - 1;32 WITH HLDR
Telkom - SPLTR, FO - 1;32 WITH HLDR+ SPLIC TRAY
Telkom - SPRT, TANGENT, 11.1-12MM, GS
Telkom - SPRT, TANGENT, 13.1-14.1MM, GS
Telkom - SPRT, TANGENT, GS
Telkom - SPRT, THMBL, 10.55-11.66MM, GS
Telkom - SPRT, THMBL, 12.8-14.1MM, GS
Telkom - Tray - HRZNTL SLCK STRG SPRTNG 100 FBR, 2U
Telkom - TRENCH TAPE / DANGER TAPE
Telkom - UNIT - CABL TRMN TENIO LRG
Telkom - UNIT - CABL TRMN, TENIO SML
Spreadsheet: 108502d1305565657-excel-2007-determine-prior-months-book10
Sheet: Sheet1

 | PROJECT START DATE
 | USER INPUT
 | 2008-05-12 00:00:00
 | 2008-05-13 00:00:00
 | 2008-07-14 00:00:00
 | 2008-06-15 00:00:00
 | 2008-05-16 00:00:00 |  |  | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | JANUARY | FEBRUARY | [NAME]
 | 2008-05-17 00:00:00 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 2008-09-18 00:00:00
 | 2008-05-19 00:00:00
 | 2008-05-20 00:00:00
 | 2008-05-21 00:00:00
 | 2008-05-22 00:00:00
 | 2008-12-23 00:00:00 |  |  | NOW START MONTH IS 5 IN COL B5 THERE FORE UNTIL AUGUST THE MONTHS NEEDS TO GET ACTUAL DATA AND THEMONTHS FROM AUGUST MUST HAVE PLAN DATA
 | 2008-05-24 00:00:00
 | 2008-05-25 00:00:00
 | 2008-10-26 00:00:00
 | 2008-03-27 00:00:00
 | 2008-04-28 00:00:00
 | 2008-01-29 00:00:00
 | 2008-05-30 00:00:00
 | 2/31/2008
 | 2008-06-01 00:00:00