tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 681921d1591813178-help-with-formula-to-call-value-from-table-example
Sheet: Sheet1

 | Starting Value
Target | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
3 |  | 1.5 | 2 | 4 | 8 | 16 | 100 | 128
4 |  |  | 1.5 | 2.5 | 5 | 8 | 80 | 112
5 |  |  |  | 2 | 4 | 8 | 64 | 96
6 |  |  |  |  | 2 | 2.5 | 32 | 64
7 |  |  |  |  |  | 2 | 4 | 48
8 |  |  |  |  |  |  | 2 | 8
9 |  |  |  |  |  |  |  | 4
10
 | Target: |  | 4
 | Starting Value: |  | 10
 | Final Factor: |  | 112
Spreadsheet: 144493d1330995419-excel-2007-how-to-move-multiple-rows-to-columns-excel-test
Sheet: Sheet1

[NAME] |  | Hot Sta |  | Last Name |  |  |  |  |  |  | First Name |  | Department |  |  |  | [NAME] |  | Hot Sta |  | Last Name |  | First Name |  | Department |  | Access Group 1 |  | Access Group 2 |  | Access Group 3 |  | Position |  | Expiration Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123456 |  | 1234567 |  | Doe |  | [NAME] |  | Staff |  | Generic |  | Level 1 |  | NO ACCESS |  | Employee |  | 41456
123456 |  | 1234567 |  | Doe |  |  |  |  |  |  | [NAME] |  | Staff
Access Group 1 |  |  |  | Access Group 2 |  |  |  | Access Group 3
Generic |  |  |  | Level 1 |  |  |  | NO ACCESS
Position |  |  | Expiration Date
Employee |  |  | 2013-07-01 00:00:00
[NAME] |  | Hot Sta |  | Last Name |  |  |  |  |  |  | First Name |  | Department
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 987654 |  | 9876543 |  | Smith |  | Jon |  | Staff |  | Level 2 |  | Level 3 |  | NO ACCESS |  | Contractor |  | 41456
987654 |  | 9876543 |  | Smith |  |  |  |  |  |  | Jon |  | Staff
Access Group 1 |  |  |  | Access Group 2 |  |  |  | Access Group 3
Level 2 |  |  |  | Level 3 |  |  |  | NO ACCESS
Position |  |  | Expiration Date
Contractor |  |  | 2013-07-01 00:00:00
[NAME] |  | Hot Sta |  | Last Name |  |  |  |  |  |  | First Name |  | Department
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 654321 |  | 6543210 |  | Doe |  | [NAME] |  | Staff |  | Level 1 |  | NO ACCESS |  | NO ACCESS |  | Employee |  | 41089
654321 |  | 6543210 |  | Doe |  |  |  |  |  |  | [NAME] |  | Staff
Access Group 1 |  |  |  | Access Group 2 |  |  |  | Access Group 3
Level 1 |  |  |  | NO ACCESS |  |  |  | NO ACCESS
Position |  |  | Expiration Date
Employee |  |  | 2012-06-29 00:00:00
Spreadsheet: 330739d1404838716-formula-help-if-and-or-vlookup-effective-rate
Sheet: Effective Rate

Sales Range |  | Base | Effective | Incemental | Net
0 | 25000 | 0.6 | 0.6 |  | 15000
 | 50000 | 0.61
 | 75000 | 0.61
 | 100000 | 0.62
 | 150000 | 0.72
 | 200000 | 0.735
 | 250000 | 0.7425
 | 300000 | 0.7425
 | 400000 | 0.7475
 | 500000 | 0.7475
Sales | 166314.18
Effective
Spreadsheet: 41234d1239731817-how-to-match-data-patterns-across-multiple-columns-advanced-filter
Sheet: Sheet1

 | scores | highs | lows |  | 1 set up criteria like this with same headings
 | 50 | 70 | 80 |  | 2 put the values you want under each heading
blub | scores | highs | lows |  | 3 select the data you want to filter
aaa | 50 | 70 | 80 |  | leave it selected and go to data filter advanced filter
bbb | 123 | 456 | 123 |  | in this case you should see list range as $A$3:$D$16
aaa | 123 | 456 | 123 |  | 4 set the criteria range as $B$1:$D$2
bbb | 50 | 70 | 80 |  | by clicking in the box then highlighting  b1 down to d2
aaa | 123 | 456 | 123
bbb | 123 | 456 | 123
aaa | 50 | 70 | 80 |  | leave filter list in place checked
bbb | 123 | 456 | 123
aaa | 123 | 456 | 123
bbb | 50 | 70 | 80 |  | click ok
aaa | 123 | 456 | 123
bbb | 123 | 456 | 123
aaa | 50 | 70 | 80
Spreadsheet: 4318e3cd-c7f9-4edb-b602-d85a4dc6ece2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7850 | 61520 | [NAME] | Wychera | AUT | 179 | 00:23:11 | 00:02:24 | 01:44:05 | 00:02:23 | 01:05:46 | 1 | 03:17:49
Spreadsheet: 842584d1694615166-rolling-calculation-example-162-aligw
Sheet: Sheet1

Region | Jul 2022 | Aug 2022 | Sep 2022 | Oct 2022 | Nov 2022 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | June 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | VS Prior Month | VS PY | VS Prior 6 Months | VS Prior 12 Months
Territory 1 | 86118.63 | 126859.59 | 76883.35 | 90932.71 | 90466.84 | 69726.27 | 76280.31 | 61440.82 | 87304.35 | 108757.95 | 53716.34 | 79644.16 | 64184.87
Territory 2 | 101492.71 | 124631.16 | 146052.37 | 89587.98 | 186526.83 | 137164.76 | 122946.73 | 99532.94 | 114672.84 | 96769.05 | 136331.73 | 153595.93 | 96365.53
Territory 3 | 269984.87 | 321286.66 | 421870.74 | 269539.67 | 364012.47 | 357367.37 | 331032.84 | 325889.65 | 438793.77 | 285095.09 | 321867.97 | 402809.87 | 317118.7
Territory 4 | 25944.51 | 18335.23 | 21297.26 | 13362.16 | 26404.7 | 16105.44 | 30692.75 | 13624.44 | 35108.39 | 26654.19 | 24124.69 | 20571.13 | 40951.22
Territory 5 | 6348.53 | 2224.72 | 3927.29 | 2750.53 | 3906.02 | 5804.93 | 1670.85 | 13139.35 | 4992.88 | 6723.41 | 3932.21 | 6002.36 | 11275.43
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: SITHE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 5642583 | 25632151
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 5640045 | 28305855
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 11282628 | 53938006
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -889950 | -4261570 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -10093592 | -48851980
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 802 | 3977
 | Total Purchases: |  | -10982740 | -53109573
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | -82809 | 4
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -82809 | 4
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 39213 | 186379
18 |  | W/D (Purchase from Stg) | -227035 | -1082957
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -227035 | -1082957
 | Total Storage: |  | -187822 | -896578
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -29257 | -132853.1113
 |  |  | 0 | 0
23 | Fuel: |  | -802 | -3977
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -7738
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -7738
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 57177.99929999997
31 |  | Prior Month Book Balance | 0 | -33816.24779999998
 |  | Total MTM Income | 0 | 23361.75149999998
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 872032
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -849784
 |  | TOTAL INTRA-MTH
Spreadsheet: 761915d1641298680-multiple-dynamic-rows-to-be-filter-based-criteria-on-another-sheet-demo_v01
Sheet: summary

Summary
From | 2021-12-01 00:00:00 |  | Task Count | 2
To | 2021-12-31 00:00:00 |  | Hours Worked | 16
Name | Naren |  | Leave Count | 0
DATE | NAME | SITE | PROJECT | TASK | HOURS WORKED | NOTES
2021-12-04 00:00:00 | Naren | India | Top_h_456 | 4998 | 8 | Good
2021-12-06 00:00:00 | Naren | India | Qalityfood | 4545 | 8 | Good
Spreadsheet: 3aa74990-0574-45c1-affb-22f6a38dee80
Sheet: Appendix B

XXX Community College
Reconciliation of Revenues, Expenses and Fund Balance as Reflected in the Annual Report to the Audited Financial Statements
For the Year Ended August 31, 200X
 |  |  |  |  | Revenues |  |  | Expenses
 | Totals by fund:
 |  | Unrestricted current funds (per annual report) |  | $
 |  | Restricted current funds (per annual report)
 |  | Plant funds
 |  | Endowment and similar funds
 |  | Blended component unit(s)
 | Totals (all funds)
 | Adjustments to reconcile to financial statements:
 |  | Scholarship allowances
 |  | Expended for plant facilities
 |  | Retirement of indebtedness
 |  | Depreciation
 |  | GASB 45 OPEB costs not
 |  | recognized in annual report
 |  | Miscellaneous adjustments
 |  | Adjusted totals |  | $ |  |  |  |  | (1)
 | Per audited financial statements:
 |  | Operating revenue / expenses
 |  | Nonoperating revenue / expenses
 |  | Other revenue / expenses
 |  | Totals per financial statements |  | $ |  |  |  |  | (1)
 |  |  |  |  |  |  |  | Unrestricted    Current Funds (2) |  |  | Reconciled Difference
 |  |  |  |  | Annual Report
200X Total unrestricted expenses
200X Total revenues - offset to expense plus costs not allowable for state-aid.
200X Net operating costs |  |  |  | $
Description of reconciled difference(s)
1.
2.
 |  |  | Total reconciled difference(s) |  |  |  |  |  |  | $
 | (1) | Adjusted totals should agree to totals per financial statements
 | (2) | Unrestricted Current Funds as contained in the Audited Financial Statements
 |  |  |  |  | Reported
Net Asset / Fund Balance Reconciliation: |  |  |  |  | Amounts
Current Unrestricted Fund Balance * |  |  |  | $
GASB 45 Liability (per financial statements)
Other (explain):
Other (explain):
Unrestricted Net Assets (per financial statements) |  |  |  | $
* Line 113 (column C) of annual report
Spreadsheet: 147884d1333026691-conditional-formatting-in-excel-2010-example
Sheet: Sheet 1

Sheet 1 Important Dates |  | Meeting | Call | Review Q1 | Review Q2
Initial Start | 2012-03-15 00:00:00
Year 1 Renewal
Year 2 Renewal
Year 3 Renewal
As one of the dates on this sheet is within 30 days of todays date, I need to cell [NAME] on the "Home Page" tab to be highlighted Orange as well
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 8697 | 6399 | 114 | 179 | 1543 | 1323 | 322 | 298
2 | 8008 | 6399 | 120 | 179 | 1630 | 1323 | 176 | 298
3 | 7274 | 6399 | 177 | 179 | 1555 | 1323 | 41 | 298
4 | 6935 | 6399 | 213 | 179 | 1427 | 1323 | 0 | 298
5 | 6927 | 6399 | 188 | 179 | 1521 | 1323 | 5 | 298
6 | 2953 | 6399 | 167 | 179 | 1484 | 1323 | 318 | 298
7 | 6098 | 6399 | 170 | 179 | 442 | 1323 | 408 | 298
8 | 8005 | 6399 | 97 | 179 | 276 | 1323 | 308 | 298
9 | 7359 | 6878 | 112 | 179 | 346 | 1323 | 242 | 298
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | 509472.93
2000-12-09 00:00:00
Spreadsheet: 713679d1610878994-translating-multiple-column-index-to-other-work-sheets-film-tester-tidied-up-
Sheet: Genre

[NAME] | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
Gangster
Comedy
Rom-Com
Western
Romance
Sci-Fi
Historical
Action
Horror
Drama
Animated
Superhero
Thriller
Musical
Fantasy
Heist
[NAME]
Spreadsheet: 709047d1608139372-progress-bar-in-each-cell-based-on-values-progress-bar-v1
Sheet: codes

Status | Column1
Returned to client | 0.1
At Service for repair | 0.2
At Company for repair | 0.15
In Company Pool | 0.05
In Quarantine | 0.08
Returned to the lab | 0.11
In transit to service | 0.33
In stock | 0.45
In transit to Company | 0.5
Wait for Dispatch to Client | 0.17
Wait for Dispatch to Service | 0.88
Spreadsheet: 473133d1470062337-target-distribution-target-distribution
Sheet: Foglio1

I have a list of data:
lines | a | b
1 | 1 | 5
2 | 1 | 6 |  | and this is the current distribution:
3 | 1 | 2 |  |  |  |  |  |  |  |  | I've found how many lines that I have to remove, but i dont know which are
4 | 0 | 23 |  |  | range
5 | 2 | 13 |  |  | from | to | n | current distribution |  |  | target distribution |  | difference list / target | usable |  | new distribution | targat | lines to remove
6 | 0 | 21 |  | a
7 | 0 | 1
8 | 2 | 15
9 | 1 | 9
10 | 0 | 7
11 | 0 | 23 |  |  | range
12 | 3 | 27 |  |  | from | to | n | current distribution |  |  | target distribution |  | difference list / target | usable |  | new distribution | targat | lines to remove
13 | 1 | 14 |  | b
14 | 2 | 8
15 | 4 | 16 |  |  |  | 30
16 | 0 | 4
17 | 2 | 17
18 | 1 | 19
19 | 3 | 15 |  | using the data of the first list, I would like to create a list (obviously) smaller, that has this distribution:
20 | 0 | 24
21 | 0 | 3
22 | 3 | 2 |  |  | range
23 | 3 | 18 |  |  | from | to |  | target distribution
24 | 2 | 8 |  | a |  |  |  | 0.3
25 | 2 | 3 |  |  |  |  |  | 0.4
26 | 0 | 12 |  |  |  |  |  | 0.3
27 | 3 | 28
28 | 3 | 20 |  |  | range
29 | 3 | 21 |  |  | from | to |  | target distribution
30 | 2 | 0 |  | b |  |  |  | 0.4
31 | 2 | 0 |  |  |  |  |  | 0.4
32 | 0 | 19 |  |  |  | 30 |  | 0.2
33 | 0 | 0
34 | 0 | 22
35 | 3 | 11 |  | possible or impossible?
36 | 1 | 25
37 | 2 | 18 |  | i would like to find what lines should i remove (from the start list) to be able to have the target distribution
38 | 2 | 19
39 | 2 | 0
40 | 0 | 0
41 | 1 | 22
42 | 2 | 13
43 | 3 | 19
44 | 0 | 4
45 | 3 | 27
46 | 2 | 28
47 | 3 | 19
48 | 0 | 3
49 | 1 | 28
50 | 3 | 2
51 | 1 | 8
52 | 0 | 16
53 | 3 | 30
54 | 0 | 29
55 | 1 | 24
56 | 2 | 12
57 | 3 | 13
58 | 2 | 23
59 | 1 | 2
60 | 1 | 24
Spreadsheet: 814006d1674107060-every-nth-row-with-offset-excel-example
Sheet: Sheet1

This | That
ym
tn
sn
vn
qn
pn
ln
vm
tm
qm
zm
lp
Spreadsheet: 874013d1720583936-how-to-drag-down-the-date-in-dd-mm-yy-format-how-to-drag-the-date-down_100724
Sheet: loan 130821-1L

loan amount & date | pay date | amt to sala | amt to interest | balance |  | Phuocam | [NAME]
 | 110921 | 3000 | 1000
 | 91021 | 3000 | 970
 | 131121 | 3000 | 940
 | 111221 | 3000 | 910
 | 150122 | 3000 | 880
 | 120222 | 3000 | 850
 | 120322 | 3000 | 820 |  |  |  |  |  |  |  | result
 | 60422 | 3000 | 190
 | 210522 | 3000 | 760 |  |  |  |  |  |  |  | 13-21
 | 130622 | 3000 | 730
 | 160722 | 3000 | 700
 | 200822 | 3000 | 670
 | 170922 | 3000 | 640
 | 221022 | 3000 | 610
 | 191122 | 3000 | 580
 | 171222 | 3000 | 550 |  |  |  |  |  |  |  | if I drag down
 | 210123 | 3000 | 520 |  |  |  |  |  |  |  | if I drag down
 | 180223 | 3000 | 490 |  |  |  |  |  |  |  | if I drag down
 | 180323 | 3000 | 460 |  |  |  |  |  |  |  | if I drag down
 | 180423 | 3000 | 430 |  |  |  |  |  |  |  | if I drag down
 | 200523 | 3000 | 400
 | 170623 | 3000 | 370
 | 150723 | 3000 | 340
 | 180823 | 3000 | 310
 | 160923 | 3000 | 280
 | 211023 | 3000 | 250
 | 181123 | 3000 | 220
 | 161223 | 3000 | 190
 | 200124 | 3000 | 160
 | 180224 | 3000 | 130
 | 160324 | 3000 | 100
 | 200424 | 3000 | 70 |  |  |  |  |  |  |  |  |  |  | l
 | 250524 | 4000 | 40
 | to get row 1 as freezed click on row 2 cell a2 and go to tools view freeze panes. Done.   100724
Spreadsheet: 881904d1730129094-formula-for-cell-each-cell-2hrs-highlight-by-color-based-on-total-hour-new-example-file
Sheet: Sheet1

SHUTDOWN | Activity Name | Duration
EPOXY REACTORS WITH ANY PLANNED MAINTENANCE
level-1 |  |  | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52 | 54 | 56 | 58 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 74 | 76 | 78 | 80 | 82 | 84 | 86 | 88 | 90 | 92 | 94 | 96
Tower |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
1 | Drain Purging | 12
2 | N2+Steam Purge | 24
3 | Ready For Maintenance Hand Over | 48
level-2
Tower
1 | Drain Purging | 24
2 | N2+Steam Purge | 48
3 | Ready For Maintenance Hand Over | 54
 | Want to write formula to create cell highlight till many rows like shown here and dynamic one
Spreadsheet: 785823d1656716850-if-statements-for-multiple-dates-and-date-ranges-that-correspond-to-different-formulas-excel-example-etaf-
Sheet: Detail by Workstream

 |  |  | Dates
 |  |  |  |  |  |  |  | Seniority | [NAME] | Monthly Cost | Start 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 | 2022 Fcst | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2023 Fcst |  | Notes:
 |  | Position | Phase 1 | Phase 2 | Phase 3 | Phase 4 | Phase 5
 |  | Senior Employee Lead |  |  |  |  |  | Director |  |  | 2022-08-01 00:00:00
 |  | Senior Employee |  |  |  |  |  | Director |  |  | 2022-03-01 00:00:00
Spreadsheet: cd41f668-b40f-432a-97fb-c2e24f531fa5
Sheet: Sheet1

Libri i Shitjeve | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Shoqeria |  | Emri i Shoqerise
Nipti |  | Nipti i Shoqerise
Viti |  | Viti per te cilin [NAME]  (yyyy)
[NAME] |  | [NAME] per te cilin plotesohet libri - muaji nga 01 deri 12
Pa veprimtari |  | Ploteso PO nese gjate muajit [NAME] transaksion.
Fatura |  |  | Bleresi |  |  | Totali Shitjeve | Shitjet e perjashtuara | Eksporte /Furnizime me 0% | Shitje me shkalle 20% |  | Shitje me shkalle 10%
Nr Fatures | Numri Serial | Data (dd/mm/yyyy) | Emri tregtar /personi | Rrethi | NIPT |  |  |  | Vlera e Tatueshme | Tvsh | Vlera e Tatueshme | Tvsh
a | b | c | d | e | f | g= (h+i+j+k+l+m) | h | i | j | k | l | m
Shuma totale
Kutia sipas Formularit te [NAME] dhe Pageses se TVSH-se |  |  |  |  |  |  | kutia (9) | kutia (10) | kutia (11) | kutia (12) | kutia (13) | kutia (14)
 |  |  |  |  |  |  |  |  | Emri           Mbiemri
Shpjegim:
Ne rastin kur ky liber do te printohet, per qellime te ruajtjes/ mbajtjes se dokumentacionit, cdo faqe e printuar duhet te kete ne krye permbajtjen / rreshtat nga 1 ne 12.
Nr i rreshtave mund te shtohet ne perputhje me nr e transaksioneve
Spreadsheet: 94705d1294432884-date-and-venue-wise-meeting-schedule-leo73pk-meeting-schedule
Sheet: Schedule 

 |  |  |  |  | Meeting Venues
 |  |  |  |  | Conf Hall A | Conf Hall B | Conf Hall C | Conf Hall D | Conf Hall E | Conf Hall F
 | Date | Day | Time | Group
Spreadsheet: 696201d1600698373-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 2

Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product B | 2000 | 1 | -3 |  | 10000
2021-03-01 00:00:00 | Product B | 2000 | 1 | -3 |  | 20000
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 |  | 50000
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 |  | 40000
Spreadsheet: 726597d1617308499-formula-which-adjusts-current-cell-to-catchup-for-shortfall-in-rows-cells-above-filling-backorders-altwood-
Sheet: Sheet1

Month | Expected Stock | Forecast | Expected Sales | Forecast-Sales (Shortfall) | Forecast - Sales (Cumulative) | Stock-Sales ([NAME]) | Correct Results for sales | Correct Cumulative Forecast-Sales Shortfall | Shortfall used in month for Sales "Catchup" |  | Helper 1 | Helper 2
Jan | 14 | 8 |  |  |  |  | 8 | 0 | 0
Feb | 8 | 8 |  |  |  |  | 8 | 0 | 0 |  |  |  |  |  | [NAME] which adjusts current cell to "catchup' for shortfall in rows/cells above. (excelforum.com)
Mar | 30 | 20 |  |  |  |  | 20 | 0 | 0
Apr | 20 | 18 |  |  |  |  | 18 | 0 | 0
May | 4 | 10 |  |  |  |  | 4 | 6 | 0
Jun | 0 | 17 |  |  |  |  | 0 | 23 | 0
Jul | 0 | 18 |  |  |  |  | 0 | 41 | 0
Aug | 20 | 9 |  |  |  |  | 20 | 30 | -11
Sep | 45 | 9 |  |  |  |  | 39 | 0 | -30
Oct | 13 | 13 |  |  |  |  | 13 | 0 | 0
Nov | 10 | 10 |  |  |  |  | 10 | 0 | 0
Dec | 17 | 9 |  |  |  |  | 9 | 0 | 0
Totals
Spreadsheet: 808196d1670344273-need-formula-to-calculate-sum-of-times-early-and-late-attendance-akshaya
Sheet: Timekeeping

 | Monthly Attendance Sheet
 | Name  : - |  |  |  |  |  |  |  | Month : - | December
 | Duty Timing : - |  |  |  |  | Hrs. |  |  | Year : - | 2022
 | Date | Day | Entry Time | Exit Time | [NAME]. | Duty | Late Entry | Early Exit | Overtime | Remarks
 | 1 | Thu | 10:20:00 | 18:40:00 |  | Duty
 | 2 | Fri | 10:00:00 | 17:45:00 |  | Duty
 | 3 | Sat |  |  |  | Duty
 | 4 | Sun
 | 5 | Mon |  |  |  | Duty
 | 6 | Tue | 10:00:00 | 17:50:00 |  | Absent
 | 7 | Wed
 | 8 | Thu
 | 9 | Fri
 | 10 | Sat
 | 11 | Sun
 | 12 | Mon
 | 13 | Tue
 | 14 | Wed
 | 15 | Thu
 | 16 | Fri
 | 17 | Sat
 | 18 | Sun
 | 19 | Mon
 | 20 | Tue
 | 21 | Wed
 | 22 | Thu
 | 23 | Fri
 | 24 | Sat
 | 25 | Sun
 | 26 | Mon
 | 27 | Tue
 | 28 | Wed
 | 29 | Thu
 | 30 | Fri
 | 31 | Sat
 |  |  |  |  |  | Early Exit
 |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Need formula  ?
 |  | Total Days
Spreadsheet: 744411d1629224254-how-to-calculate-double-time-hours-between-12-am-and-6-am-test-hours
Sheet: 1

 | [NAME] (Last, First) | Social Security # | Department | Rate | In | Out | In | Out | In | Out | In | Out | Hours Worked | ST | OT | DT | 2.25 | 3x | 4x | Day / Show Rate |  | SubTotal | 0.02 | Gross Wages | Parking | COMMENTS
1 |  |  |  |  | 06:00:00 | 10:00:00 | 11:00:00 | 15:00:00 | 17:00:00 | 22:00:00 | 23:00:00 | 01:00:00
2 |  |  |  |  | 22:00:00 | 03:00:00
3
4
5
6
7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Shell

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-04-16 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-04-16 00:00:00