tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: barry_tycholiz__870__EPNG BP Tariff Sheet
Sheet: Sheet1

 | Calendar Year | 2002 | 2003 | 2004 | 2005 | 2006
 | Volume / Day | 100000 | 100000 | 100000 | 100000 | 100000
 | Days/Year | 365 | 365 | 365 | 365 | 151
 | Demand Charge/MMbtu | 0.35648 | 0.35648 | 0.29908
 | Gas Research Institute (GRI) | 0.00197 | 0.00164 | 0 | 0 | 0
 | Total Calendar Demand Charge
 | ENA Payment Structure
 | (1) [NAME] or | 12000000
 | (2) Annuity Payment
 | Adjusted Calendar Year Demand Charge (1)
 | Adjusted Calendar Year Demand Charge (2)
Spreadsheet: 852720d1702659160-calculate-depreciation-between-two-assets-during-the-month-book70-megatronv-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dates | Asset A | Asset B |  | 1st day | 3rd Wed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 |  | 2023-10-01 00:00:00
As of today-1 business day
 |  | Asset A | Asset B | Asset C
1) | 0n the 3rd Wendsday of each month asset A resets to zero and B starts with 100%
2) | Each day asset B loses 5% from the above date and asset C gains 5% until the next month where the process repreats itself- these excludes weekends
3) | how can I automate the process to show me at any given day what is the split between A and B
4) Next reset is on 20/12/23
 |  |  |  |  | Jan reset | 2024-01-17 00:00:00
 |  |  |  |  | Next Reset | 2023-12-20 00:00:00
 |  |  |  |  | Previous Reset | 2023-11-15 00:00:00
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 5

 | January 3 | January 10 | January 17 | January 24 | January 31
Total Interest Rate* | 1104491 | 4806086 | 3871832 | 2900817 | 2277826.34963
Cleared** | 761398 | 3593783 | 2274152 | 1914985 | 1827220.0608
Uncleared | 343093 | 1212303 | 1597680 | 985832 | 450606.28883
Total Cross-Currency | 34943 | 172195 | 320231 | 119256 | 44559.888623
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 34943 | 172195 | 320231 | 119256 | 44559.888623
Total Credit | 146697 | 351972 | 325420 | 304715 | 430643.486824
Cleared | 61657 | 186083 | 199418 | 235880 | 353457.79515
Uncleared | 85040 | 165889 | 126003 | 68835 | 77185.691674
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 1286131 | 5330253 | 4517483 | 3324787 | 2753029.725077
Weekly total, swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects the notional value of the creation of only one of the two swaps that results from the clearing process. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 118677d1313875102-find-the-exact-p-n-in-a-multi-p-n-range-of-cells-messy
Sheet: Sheet1

P/N | SHELF | QTY |  | CODE | SHELF | TOTAL  QTY |  |  |  |  | search terms
AA | 1 | 1 | 0 | A | 2 | 46 |  |  |  |  | A
AA | 2 | 2 | 0 |  |  |  |  |  |  |  | , A
AB | 3 | 3 | 0 |  |  |  |  |  |  |  | A,
AB | 2 | 4 | 0 | CODE | SHELF | TOTAL  QTY
BB | 1 | 5 | 0 | A | 2 | 52
BB | 2 | 6 | 0 |  |  | SHOULD BE 46
CC | 1 | 7 | 0 |  |  | cells: A9, A10, A14, A17 only
A, CA, D | 2 | 8 | 1
A, CA, DA | 2 | 9 | 1
EE | 2 | 10 | 0 | The P/N is a combination of the alphabeth letters
EE | 3 | 11 | 0 | They can in a length of 2-3-4 lettres
FF | 4 | 12 | 0 | Column A presents how the warehouse clerek build the list.
GG, A, BB | 2 | 13 | 1 | The table is only a short example of a very long list.
GG | 6 | 14 | 0 | Column A cannot be changed in order to present a single P/N per row.
HH | 7 | 15 | 0 | How can I fine the exact P/N A while skipping (leaving out) the AA, Ca and so on ?
JJ, KK, A | 2 | 16 | 1 | Obviously, FIND and SEARCH does not fit.
GG | 6 | 17 | 0
MM | 8 | 18 | 0
GG, NN, BB | 9 | 19 | 0
Spreadsheet: 65977d1266597306-waterfall-chart-waterfall
Sheet: Sheet1

 | Jan |  |  | Feb |  |  | Mar
 | [NAME] | 1109.7 |  | [NAME] | 1573.3132921875 |  | [NAME] | 1359.9739171875
 | [NAME] | 915.2 |  | [NAME] | 1146.98412 |  | [NAME] | 1146.98412
 | [NAME] | 2830.8 |  | [NAME] | 2361.83229375 |  | [NAME] | 2548.39229375
 | [NAME] | 11559.2 |  | [NAME] | 10945.162675 |  | [NAME] | 10945.162675
 | Nick | 2076 |  | Nick | 1451.39 |  | Nick | 1356.77
 | [NAME] | 1000 |  | [NAME] | 1000 |  | [NAME] | 1000
 | [NAME] | 4226.655076229677 |  | [NAME] | 4217.632383713608 |  | [NAME] | 4230.334291249826
 | TOTAL | 23717.55507622968 |  | TOTAL | 22696.31476465111 |  | TOTAL | 22587.61729718733
Spreadsheet: 875264d1721841054-extract-ordinal-numbers-of-the-same-number-723-metrostar-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extract ordinal numbers of the same number (excelforum.com)
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 |  |  |  | 1 | 2
 | 2 | 2 | 3 | 4 | 5 | 2 | 3 | 5 | 4 | 4
 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 6 | 2 | 4
 | 2 | 6
 | 4 | 7
 | 0 | 9
 | 2 | 7
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: SALARY-BENEFITS LOOKUP TABLE

Salary-Benefits Lookup Table
 |  | BASE SALARY |  |  |  | BENEFITS |  |  |  |  |  |  | TOTAL
 |  | MONTHLY | MONTHLY | MONTHLY | ANNUAL | REIMBURSABLE | NON-REIM | 20% ON BASE |  | 30% HOUSING | BENEFITS | TOTAL | SALARY &
 | GRADE | MIN | MAX | AVG | AVG | ALLOWANCES | ALLOWANCES | BONUS | [NAME] | ALLOWANCE | IN KIND | BENEFITS | BENEFITS
Vice President | 1 | 55000 | 80000 |  |  | 111250 | 762600 |  | 251100 |  | 669800
General Manager | 2 | 40000 | 50000 |  |  | 77500 | 417600 |  | 167100 |  | 491200
Sr. Mgr/Perf.Mgr/Purch.Mgr/Ctrl | 3 | 23000 | 31000 |  |  | 50500 | 226200 |  | 100440 |  | 346320
HR Manager/Shift Mgr. | 4 | 19000 | 22500 |  |  | 41125 | 190500 |  | 77190 |  | 190320
Asst. Mgr/Ctrl Rm Optr/Chemist | 5 | 14000 | 19500 |  |  | 35125 | 154500 |  | 62310 |  | 160180
Sr. Operator/Accountant | 6 | 8500 | 14350 |  |  | 21425 | 97530 |  | 42501 |  | 122328
Operator/Mechanic/Jr. Acct. | 7 | 8500 | 10900 |  |  | 19700 | 65280 |  | 36084 |  | 78052
Jr Operator/Jr. Mechanic/Secr. | 8 | 3800 | 5250 |  |  | 9050 | 32860 |  | 16833 |  | 7474
Assistant/Grounds Supvr. | 9 | 2500 | 5000 |  |  | 7500 | 24000 |  | 13950 |  | 3600
Jr. Asst./Driver/Janitor | 10 | 1500 | 3000 |  |  | 4500 | 6000 |  | 8370 |  | 3360
 | US DOLLAR: |  |  | 1
 | CUMULATIVE INFLATION MULTIPLIER:
 | YEAR THAT DATA IS BEING USED: |  |  | 2000 | Enter here the year that the above data is being used.
 | YEAR THAT DATA WAS SUPPLIED: |  |  | 2000
 | DIFFERENCE IN YEARS:
 | AVG ANNUAL US INFLATION RATE: |  |  | 0.09 | Enter here the desired annual Indian inflation rate used to convert 1999 Rupees to present terms.
 | Source: [NAME] and benefits information provided by HR ([NAME]) Sept. 1999.
 | 1/ Annual 30% Housing & Utilities allowance provided
Spreadsheet: 74853d1275404899-how-to-do-sumif-over-multiple-sheets-blank-sheet-for-june
Sheet: 3 June

Account | Amount | Work done on account | Saved | Charge off
5039469305716608 | 8309.76 | NN |  | 8309.76
5039469306237406 | 5983.8 | NN |  | 5983.8
5039469322874901 | 5373.06 | BWR IS GOING TO TRY AND CLEAR OLDEST ARREARS 31/5 |  | 5373.06
5039469333025600 | 4882.24 | SAVED
5039469332351502 | 3271.86 | NN |  | 3271.86
5039469329913702 | 3011.84 | NN |  | 3011.84
5039469023850804 | 3011.68 | NN |  | 3011.68
5039469324901306 | 2219.02 | OVERSEAS AVOIDING CALLS |  | 2219.02
5039469326099406 | 2117.13 | NN |  | 2117.13
5039469323368903 | 2011.99 | NN |  | 2011.99
5039469336669008 | 1739.5 | NN |  | 1739.5
5039469336667705 | 1015.21 | [NAME] has not made any payments since opening a/c |  | 1015.21
5039469328522702 | 543.94 | NN |  | 543.94
5039469301791209 | 536.14 | bwr in australia keeps hanging up on us |  | 34.67
5039469321067101 | 34.67 | no contact since Sept/09
 | 44061.83999999999
 |  |  | Actual | 38643.46
 |  |  | Ce % | 0.1229721682072286
 | 33844.24 |  | Actual | 28962
 |  |  | Ce % | 0.1442561570299701
Spreadsheet: 484989d1476636565-fill-the-form-in-sheet3-using-data-from-sheet1-school-report
Sheet: عالية

 |  | School Reports |  |  |  | Month: | 2016
 |  | [NAME] : | العين |  |  | School Number: | 1390
 |  | المحطـة : | [NAME] |  |  | Cycle:
 |  | School: | عالية
 | # | Bus Number | Bus Seats | Total Students in the bus | Driver Name |  | عدد أيام الغياب (بدون توفير بديل)
 | 1 | [NAME] | 61 | 44 | جيهان درويز سيد اعظم خان
 | 2 | B0013130 | 61 | 36 | [NAME]
 | 3 | B0026850 | 60 | 46 | عبدالرحمن مولي بالي شريف
 | 4 | B0026573 | 26 | 25 | [NAME]
 | 5 | B0011464 | 60 | 44 | عيسى شامبي توربات
 | 6 | B0004551 | 60 | 52 | رشيد نيديوداث اباموتي نيدبوداث
 | 7 | B0005236 | 60 | 44 | [NAME] نورالدين
 | 8 | B0015499 | 61 | 55 | أختر حسين ميرزا
 | 9 | B0006406 | 60 | 50 | تاجبر خان رحمة الله
 | 10 | B0005004 | 60 | 53 | [NAME] النهدي
 | 11 | B0026850 | 60 | 42 | عبدالرحمن مولي بالي شريف
 | 12 | B0005835 | 60 | 43 | عبدالسلام فالينجال
 | 13 | B0007042 | 60 | 53 | محمد عالم مسافر
 | 14 | B0015482 | 61 | 52 | محمد فيصل البارامبيل محمد
 | 15 | B0005611 | 60 | 52 | محمد قاسم محسن
 | 16 | B0005010 | 60 | 42 | محمد كريم فاضل كريم
 | 17 | B0005236 | 60 | 49 | [NAME] نورالدين
 | 18 | B0006910 | 60 | 48 | محمد جمال الدين
 | 19 | B0015499 | 61 | 55 | أختر حسين ميرزا
 | 20 | B0006406 | 60 | 53 | تاجبر خان رحمة الله
 | 21 | B0005004 | 60 | 37 | [NAME] النهدي
 | 22 | B0007057 | 60 | 51 | صلاح الدين فيرومال
 | 23 | [NAME] | 60 | 50 | [NAME] افران
 | 24 | B0005835 | 60 | 56 | عبدالسلام فالينجال
 | 25 | B0015512 | 61 | 45 | علي اصغر خان
 | 26 | B0007042 | 60 | 28 | محمد عالم مسافر
 | 27 | B0005611 | 60 | 38 | محمد قاسم محسن
 | 28 | B0005010 | 60 | 51 | محمد كريم فاضل كريم
 | الاجمالي
 | [NAME] المحطة |  |  |  |  |  | [NAME]
 | ملخص شهادات انجاز خدمة النقل المدرسي ( للمدرسة )
 |  | [NAME] : |  |  |  | School Number:
 |  | المحطـــة : |  |  |  | Cycle:
 |  | School:
 | أولا:- الحافلات المدرسية
 | بيانات الحافلات المدرسية
 | م | البند |  |  | خط فردي | خط زوجي | الاجمالي
 | 1 | حافلة كبيرة
 | 2 | حافلة صغيرة
 | الاجمالي
 | [NAME] خدمة النقل المدرسي (من قبل المدرسة)
 | [NAME] خدمة النقل المدرسي
 | م
 | 1
 | 2
 | 3
 | 4
 | ثالثا:-  معالجة  الملاحظات  ( من قبل المحطة )
 | معالجة الملاحظات من قبل المحطة [NAME] خدمة النقل المدرسي
 | م
 | 1
 | 2
 | 3
 | 4
 | [NAME] المحطة |  |  |  |  | [NAME]
 | ............................. |  |  |  |  | .................................
Spreadsheet: 845930d1697217842-table-lookup-name-skill-and-skill-level-example
Sheet: Sheet1

 | [NAME] |  | [NAME] |  | [NAME]
 | Skill Level | Interest | Skill Level | Interest | Skill Level | Interest
Baseball | 3 | 4 | 5 | 5 | 2 | 5
Football | 5 | 5 | 2 | 1 | 4 | 4
Soccer | 4 | 2 | 3 | 4 | 5 | 3
Spreadsheet: theresa_staab__39625__September noms for Quest
Sheet: Sept

 |  |  | DAILY SCHEDULED VOLUME
PURCHASER: |  |  |  | SELLER:
Enron North America Corp. |  |  |  | Quantum Energy, L.L.C. | Quest Operating, LLC
1200 17th Street, [NAME] 2750 |  |  |  | [NAME]
Denver, Colorado  80202 |  |  |  | Sheridan, Wyoming  82801
Attention:  [NAME] |  |  |  | Attention:   [NAME]
Phone:  (303) 575-6485 |  |  |  | Phone:  (307) 673-1500
Fax:  (303) 534-0552 |  |  |  | Fax:  (307) 673-1400
E-mail Address:  [EMAIL] |  |  |  | E-mail Address: [EMAIL]
Flow Month: | 2001-09-01 00:00:00 |  |  |  | Effective Date: | 2001-09-01 00:00:00
 |  |  |  |  | (start date for flow)
Contract #: | 96040979
 |  | Btu factor: | 0.971 | Effective 6/1/01
DELIVERY POINTS:
 | Date | Pricing (less gathering) | Purchase Volume Mcf/d | Purchase Volume MMBtu/d | # of Days | Total MMBtu/for Month
 | Day1 - 30 | Original Purchase Price | 1250 |  | 30
 | Total Purchase:
** Purchase Price is CIG Gas Daily - $.35 less gathering and transportation
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 21

 |  | Gross Notional Outstanding
Product Type |  | Cleared* | Uncleared
Total Metals | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A*** | N/A
Estimated gross notional amount outstanding, week ending August 16 , by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 112372d1308535142-index-match-function-sample
Sheet: Sheet1

State | Year | Unemployment
Alabama | 2009
Alabama | 2008
Alabama | 2007
Alaska | 2009
Alaska | 2008
Alaska | 2007
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
STATES
Spreadsheet: 747839d1631722832-1900-system-negative-time-workaround-example
Sheet: Sheet1

 | Scheduled Arrival | 23:00:00
 | Actual [NAME] | 00:15:00
 |  | 23:50:00
 |  | 23:10:00
 |  | 23:30:00
 |  | 23:50:00
 |  | 00:10:00
 |  | 23:50:00
 |  | 23:50:00
 |  | 00:10:00
Spreadsheet: 91436d1291166884-excel-2007-solver-does-not-change-values-inar2
Sheet: Sheet1

rho=0.5 |  | rho | lambda |  | min=0 | min=1 | min=2 | min=3 | min=4 | min=5 | min=6 | min=7 | min=8 | min=9 | min=10 | min=11 | min=12 | min=13 | min=14
0 |  | 0.5 | 1
1
1
3
3
1
1
0
1
0
1
2
3
6
7
4
3
6
2
1
1
1
2
4
5
2
3
2
2
1
4
2
1
2
1
2
2
1
2
3
1
3
4
3
4
5
3
1
0
1
1
1
2
2
3
1
1
1
1
3
2
1
2
2
2
3
2
1
0
1
3
2
0
2
2
2
1
2
3
3
5
4
4
5
6
6
2
5
4
2
2
2
2
3
2
1
2
4
1
2
Spreadsheet: 23396d1212786155-variable-hyperlinking-between-sheets-hyperlink1
Sheet: Results

Name | Results
Test 1 | 0.04746914661793067 | Test 1
Test 2 | 0.4058159346970973 | Test 2
Test 3 | 0.7296216601921717 | Test 3
Test 4 | 0.8256517473179974 | Test 4
Test 5 | 0.9371374100524417 | Test 5
Test 6 | 0.8378311250296031 | Test 6
Test 7 | 0.5508059157321199 | Test 7
Test 8 | 0.6762254051495331 | Test 8
Test 9 | 0.4210309735646707 | Test 9
Test 10 | 0.1565183786306905 | Test 10
Test 11 | 0.3783235320115319 | Test 11
Test 12 | 0.7267348852548339 | Test 12
Test 13 | 0.47463508772347 | Test 13
Test 14 | 0.6025235321984934 | Test 14
Test 15 | 0.5949367214038452 | Test 15
Spreadsheet: 113433d1309348907-help-with-line-chart-copy-of-daily-speed-test
Sheet: Sheet1

Daily Speed Test
Site: www.speedtest.net |  |  |  | Server: Coventry
Date | day | Time | [NAME] (ms) | DL Speed ([NAME]) | UL Speed ([NAME]) |  | columns
June 15th |  | 08:47:00 | 11 | 2.82 | 3.62 |  | 1
 |  | 11:10:00 | 10 | 3.63 | 3.6 |  | 1
 |  | 14:00:00 | 11 | 1.72 | 2.97 |  | 1
 |  | 16:15:00 | 26 | 3.63 | 3.46 |  | 1
June 16th |  | 08:46:00 | 10 | 3.71 | 3.61 |  | 0
 |  | 13:03:00 | 10 | 3.8 | 3.06 |  | 0
 |  | 14:54:00 | 26 | 3.41 | 1.79 |  | 0
 |  | 16:20:00 | 10 | 2.92 | 3.57 |  | 0
June 17th |  | 08:56:00 | 26 | 2.33 | 2.44 |  | 1
 |  | 12:31:00 | 10 | 3.71 | 3.63 |  | 1
 |  | 14:17:00 | 10 | 3.79 | 3.66 |  | 1
 |  | 15:20:00 | 10 | 2.15 | 3.49 |  | 1
June 20th |  | 09:05:00 | 11 | 1.57 | 3.2 |  | 0
 |  | 13:40:00 | 10 | 2.1 | 3.23 |  | 0
 |  | 15:54:00 | 10 | 3.81 | 3.73 |  | 0
June 21st |  | 12:00:00 | 11 | 3.43 | 2.89 |  | 1
 |  | 13:29:00 | 10 | 1.27 | 2.76 |  | 1
 |  | 14:31:00 | 73 | 1.22 | 2.67 |  | 1
 |  | 15:29:00 | 26 | 2.85 | 3.64 |  | 1
June 22st |  | 09:00:00 | 10 | 0.75 | 2.18 |  | 0
 |  | 12:02:00 | 10 | 2.36 | 3.49 |  | 0
 |  | 13:00:00 | 10 | 1.64 | 2 |  | 0
 |  | 15:33:00 | 10 | 1.34 | 3.34 |  | 0
June 23rd |  | 08:57:00 | 10 | 2.97 | 3.6 |  | 1
 |  | 10:12:00 | 10 | 1.59 | 3.46 |  | 1
June 24th |  | 10:18:00 | 10 | 2.58 | 3.51 |  | 0
 |  | 11:37:00 | 10 | 3.25 | 3.41 |  | 0
 |  | 13:05:00 | 11 | 0.64 | 2.76 |  | 0
 |  | 15:02:00 | 10 | 2.56 | 3.29 |  | 0
June 27th |  | 09:03:00 | 41 | 0.35 | 2.34 |  | 1
 |  | 12:54:00 | 10 | 2.45 | 3.41 |  | 1
 |  | 14:17:00 | 10 | 2.95 | 2.97 |  | 1
June 28th |  | 08:44:00 | 26 | 3.4 | 3.61 |  | 0
 |  | 11:15:00 | 10 | 3.76 | 3.58 |  | 0
 |  | 12:27:00 | 10 | 3.67 | 3.67 |  | 0
 |  | 15:32:00 | 10 | 2.94 | 3.74 |  | 0
June 29th |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
Spreadsheet: 817829d1676463892-calculating-working-hours-is-there-a-shorter-function-zeitrechnung
Sheet: Tabelle1

KW/CW | Datum / Date | Tag / Weekday | Start | Ende / End | Arbeitsstunden / Working Hours
KW/CW 1 | 2023-01-02 00:00:00 | Mo | 9:00:00 | 17:00:00
 | 2023-01-03 00:00:00 | Di | 8:00:00 | 17:00:00 | 9:00:00
 | 2023-01-04 00:00:00 | Mi | 9:00:00 | 17:30:00 | 8:30:00
 | 2023-01-05 00:00:00 | Do | 8:30:00 | 17:30:00 | 9:00:00
 | 2023-01-06 00:00:00 | Fr | 8:45:00 | 17:00:00 | 8:15:00
 |  |  | (E2-D2)+(E3-D3)+(E4-D4)+(E5-D5)+(E6-D6)…...... |  | SUMME(F2:F6)
[NAME] ist ein kürzere [NAME] zu finden
Wish is to find a shorter function
Spreadsheet: 266530d1379647468-finding-the-date-doing-my-head-in-book1
Sheet: Info page

Machine | Sensor  Tag # | Point Description | Description | Last  date
 |  |  |  |  |  | Forumla will be required to pull dates from each "point" on data tab,  and place the date in the last date section
[NAME] And [NAME] | VT6101 | M1H | Acceleration Loaded 153
 |  | M1V | Acceleration Loaded 153
 |  | M1A | Acceleration Loaded 153
 |  |  | PeakVue Loaded 150
 | VT6102 | M2H | Acceleration Loaded 153
 |  | M2V | Acceleration Loaded 153
 |  | M2A | Acceleration Loaded 153
 |  |  | PeakVue Loaded 150
 | VT6103 | L1A | Acceleration Loaded 153
 |  |  | PeakVue Loaded 150
 | VT6104 | R1A | Acceleration Loaded 153
 |  |  | PeakVue Loaded 150
 | VT6105 | L2A | Acceleration Loaded 153
 |  |  | PeakVue Loaded 150
 | VT6106 | R2A | Acceleration Loaded 153
 |  |  | PeakVue Loaded 150
CV101 Conveyor & Pulleys | VT6115 | L4A | Acceleration Loaded 152
 |  |  | PeakVue Loaded 150
 | VT6116 | R4A | Acceleration Loaded 152
 |  |  | PeakVue Loaded 150
 | VT6138 | L1A | Acceleration Loaded 152
 |  |  | PeakVue Loaded 150
 | VT6139 | R1A | Acceleration Loaded 152
 |  |  | PeakVue Loaded 150
 | VT6140 | M2H | Acceleration Loaded 152
 |  | M2V | Acceleration Loaded 152
 |  | M2A | Acceleration Loaded 152
 |  |  | PeakVue Loaded 150
 | VT6141 | G1H | [NAME]
 |  |  | Gbox 1st Int Loaded Acc
 |  | [NAME] | [NAME]
 |  |  | Gbox 1st Int Loaded Acc
 |  | G1A | [NAME]
 |  |  | [NAME]
 |  |  | Gbox 1st Int Loaded Acc
 |  |  | Gbox 1st Int Loaded Pk
 | VT6142 | G2H | Gbox 2nd Int Loaded Acc
 |  |  | Gbox Output Loaded Acc
 |  | G2V | Gbox 2nd Int Loaded Acc
 |  |  | Gbox Output Loaded Acc
 |  | G2A | Gbox 2nd Int Loaded Acc
 |  |  | Gbox 2nd Int Loaded Pk
 |  |  | Gbox Output Loaded Acc
 |  |  | Gbox Output Loaded Pk
 | VT6143 | M1H | Motor Loaded Acc
 |  |  | Motor Loaded Pk
 | VT6178 | [NAME] | Acceleration
 |  | L3P | PeakVue
 | VT6179 | R3A | Acceleration
 |  | R3P | PeakVue
 | VT6180 | L2A | Acceleration
 |  | L2P | PeakVue
 | VT6181 | R2A | Acceleration
 |  | R2P | PeakVue
Spreadsheet: 874677d1721224418-auto-produce-trial-balance-tb
Sheet: Sheet1

 | I'm requesting for  a formula to auto produce a trial balance as shown on the desired solution
 | Please kindly note that P_L table can expand if more income and expenses accounts are added.
 |  |  |  |  |  |  | Desired Solution
 | Details | Amount | Trial Balance |  |  |  | Details | Debit | Credit
 | Income |  |  |  |  |  | Profit/(Loss) | 822330.6350326786
 | Bus Fares | 8312.298610000002 | Credit |  |  |  | Bus Fares |  | 8312.298610000002
 | Collegiate projects | 1975.18244 | Credit |  |  |  | Collegiate projects |  | 1975.18244
 | Exam Fees | 37906.02816 | Credit |  |  |  | Exam Fees |  | 37906.02816
 | School Fees | 1619149.312 | Credit |  |  |  | School Fees |  | 1619149.312
 | Sundry Income | 79004.33167000001 | Credit |  |  |  | Sundry Income |  | 79004.33167000001
 | Total Income | 1746347.15288 |  |  |  |  | Accounting fees | 8876.428
 | Expenses |  |  |  |  |  | Bank Charges | 2000
 | Accounting fees | 8876.428 | Debit |  |  |  | Cleaning | 2210.279642500001
 | Bank Charges | 2000 | Debit |  |  |  | Collegiate projects Expenses | 89.50656000000001
 | Cleaning | 2210.279642500001 | Debit |  |  |  | Electricity | 11119.85887877052
 | Collegiate projects Expenses | 89.50656000000001 | Debit |  |  |  | Feeding Programme | 10508.88986500001
 | Electricity | 11119.85887877052 | Debit |  |  |  | Fuel & Oil | 98319.48319676745
 | Feeding Programme | 10508.88986500001 | Debit |  |  |  | NEC | 1490
 | Fuel & Oil | 98319.48319676745 | Debit |  |  |  | NSSA | 9486.62246441442
 | NEC | 1490 | Debit |  |  |  | PAYE | 6700
 | NSSA | 9486.62246441442 | Debit |  |  |  | Payroll Expenses | 7416.138400000001
 | PAYE | 6700 | Debit |  |  |  | Pension & Life Cover | 3000
 | Payroll Expenses | 7416.138400000001 | Debit |  |  |  | Printing & Stationery | 6157.92653124785
 | Pension & Life Cover | 3000 | Debit |  |  |  | Property Maintenance | 26541.82456055448
 | Printing & Stationery | 6157.92653124785 | Debit |  |  |  | Salaries & Wages | 18600
 | Property Maintenance | 26541.82456055448 | Debit |  |  |  | Subscriptions | 14980.45758
 | Salaries & Wages | 18600 | Debit |  |  |  | Sundry Expenses | 31110.82285949977
 | Subscriptions | 14980.45758 | Debit |  |  |  | Telephone & Internet | 400
 | Sundry Expenses | 31110.82285949977 | Debit |  |  |  | Trade union | 567900
 | Telephone & Internet | 400 | Debit |  |  |  | Vehicle hire | 2396.67219
 | Trade union | 567900 | Debit |  |  |  | Vehicle insurance & License | 12522.94786931605
 | Vehicle hire | 2396.67219 | Debit |  |  |  | Vehicle Maintenance | 24223.58117925089
 | Vehicle insurance & License | 12522.94786931605 | Debit |  |  |  | Water | 2000
 | Vehicle Maintenance | 24223.58117925089 | Debit |  |  |  | Workshop & Conference | 22027.17407
 | Water | 2000 | Debit |  |  |  | ZIMSEC fees paid | 33937.904
 | Workshop & Conference | 22027.17407 | Debit |  |  |  | Check
 | ZIMSEC fees paid | 33937.904 | Debit
 | Total Expenses
 | Profit/(Loss) |  | Debit
Spreadsheet: 494851d1482816093-pull-id-and-school-name-from-sheet2-from-multi-columns-book1
Sheet: Sheet4

 |  |  | Name | ID | School Name
 |  |  | Garret | 39379 | AGRIGAON
 |  |  | [NAME] | 72317 | AHO-KISHAN
 |  |  | Kendall | 54309 | AHO-SHANTI
 |  |  | Wade | 78937 | AHO-YANGTAM
 |  |  | [NAME] | 38055 | AMBA
 |  |  | Lenard | 97190 | ANKUCHEN
 |  |  | Cameron | 46050 | ARITAR
 |  |  | Ervin | 39724 | ASSAM
 |  |  | Parker | 96422 | BADONG
 |  |  | Percy | 44786 | BARAPATHING
 |  |  | Billie | 93165 | BARBING
 |  |  | Billy | 27355 | BASILAKHA
 |  |  | King | 11222 | BENG
 |  |  | Thaddeus | 22221 | BENGTHANGSING
 |  |  | Clayton | 11113 | BERING
 |  |  | [NAME] | 88857 | BHASMEY
 |  |  | [NAME] | 66624 | BHIRKUNA
 |  |  | Archie | 22443 | BHUSUK
 |  |  | Wilbert | 78945 | BIRASPATI
 |  |  | [NAME] | 45671 | BOJOGHARI