tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 833970d1687365008-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-revised-single-code
Sheet: AA

 | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | FORMULA | Calculation method used for reference | Remarks
 | AG | 2022-01-01 00:00:00 |  |  |  | 19 |  |  | (20*G2)*E2/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-03-28 00:00:00 |  |  |  | 40 |  |  | (20*G3)*E3/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 6 |  |  | (20*G4)*E4/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 60 |  |  | (20*G5)*E5/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-09-01 00:00:00 | 2022-11-02 00:00:00 | 62 |  | 75 |  |  | ((20*G6*28)+(5*G6*34))/30 | 20 and 5 is the rate for AG category for the from and to date time frame respectively, 28 days are at the rate 20 and 34 days are for rate 5. 30 is the days for one month
 | AG | 2022-12-01 00:00:00 |  |  |  | 100 |  |  | ((10*E7*7.5)+(5*E7*(G7-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
 | AG | 2022-12-01 00:00:00 |  |  |  | 22 |  |  | ((7.5*10*E8)+(5*E8*(G8-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
 | AG | 2023-02-01 00:00:00 |  |  |  | 35 |  |  | ((7.5*10*E9)+(5*E9*(G9-7.5)))/30 | Here same logic applied as per above but here we have to keep one thing in mind, when you see in sheet BB you will see that in this from date to date time frame period there is in to date cells – symbol available, means these rates are presently active and its end date not yet came.
 |  |  |  |  |  |  |  |  | Days difference we have to count by subtracting dates, for example from [NAME] to 02/11/2022 the days will be 63 but we have to count this days as per subtraction method i.e. 62 days.
Spreadsheet: 100854d1299079005-question-about-referencing-data-metals
Sheet: Metals

Gold | Last Trade: | 1430.7
 | Trade Time: | 3:13AM EST
 | Change: | 0.00 (0.00%)
 | Prev Settlement: | N/A
 | Open: | N/A
 | Bid: | N/A
 | Ask: | N/A
Silver | Last Trade: | 34.51
 | Trade Time: | 10:34PM EST
 | Change: | Up 0.09 (0.27%)
 | Prev Settlement: | N/A
 | Open: | 34.7
 | Bid: | 34.49
 | Ask: | 34.52
Palladium | Last Trade: | 814.35
 | Trade Time: | 10:00PM EST
 | Change: | Up 16.70 (2.09%)
 | Prev Settlement: | N/A
 | Open: | 798
 | Bid: | N/A
 | Ask: | N/A
Platinum | Last Trade: | 1845.1
 | Trade Time: | 10:00PM EST
 | Change: | Up 35.90 (1.98%)
 | Prev Settlement: | N/A
 | Open: | 1787
 | Bid: | N/A
 | Ask: | N/A
Spreadsheet: 749114d1632509949-formula-to-find-month-1-2-3-etc-of-sales-for-products-that-launched-at-different-times-example
Sheet: Summary

 | Months
Product | 1 | 2 | 3 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
A | 31 | 82 | 29 |  |  |  | A | 30.60464226630834 | 82.49750401985942 | 29.22116643881857 | 57.80420082026209 | 3.991131497098976 | 63.18705948427856 | 12.88919763824465 | 97.27497775832501 | 39.11570754141 | 15.99034507698742 | 23.0856705079433 | 59.27846822532792
B | 22 | 61 | 13 |  |  |  | B |  |  |  |  | 21.63510340339844 | 61.1739564403786 | 12.79396432487281 | 26.6061633818716 | 61.7770028271356 | 2.746246366891913 | 44.77237024673496 | 99.84885176564552
C | 90 | 12 | 54 |  |  |  | C |  |  | 89.52190592004116 | 11.83939488918158 | 54.34938154791167 | 90.21077934173637 | 17.61893192274994 | 34.33820916007191 | 99.42868788286631 | 67.69445181102178 | 48.94923982110534 | 36.92252297314842
D | 34.35985639004043 | 97.22051693686635 | 13.85132840844252 |  |  |  | D |  |  |  |  |  |  |  |  | 34.35985639004043 | 97.22051693686635 | 13.85132840844252 | 19.56321361052989
E | 99 | 96 |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  | 98.70093230217729 | 96.34073475063121
F | 52.60980912154015 | 7.412315135023084 | 14.95734381710245 |  |  |  | F |  |  |  |  |  |  |  | 52.60980912154015 | 7.412315135023084 | 14.95734381710245 | 42.41080997065693 | 11.62540323244563
G | 65 |  |  |  |  |  | G |  |  |  |  |  |  |  |  |  |  |  | 65.49661539379746
 | I need a formula that will produce this result ^
Spreadsheet: 674616d1587951616-list-multiple-pages-and-remove-duplicates-test123-xatomicx-
Sheet: Data

Team name | Hours
Beast | Off/Holiday
Fantomex | Absent
[NAME] | 0.5
[NAME] | 1
Neutron | 1.5
Northstar | 2
Rogue | 2.5
Nate Gray | 3
Banshee | 3.5
Bishop | 4
Cypher | 4.5
Cannonball | 5
Sunspot | 5.5
Blood Storm | 6
Cable | 6.5
Gambit | 7
[NAME] | 7.5
Forge | 8
Nightcrawler | 8.5
Colossus | 9
Maverick | 9.5
Iceman | 10
Archangel | 10.5
Havok | 11
 | 11.5
 | 12
 | 12.5
 | 13
 | 13.5
 | 14
 | 14.5
 | 15
 | 15.5
 | 16
Spreadsheet: 128759d1321263334-clear-of-cells-without-erased-the-formulas-contained-forum
Sheet: Arkusz1

0
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Spreadsheet: 785135d1656181677-closing-date-based-on-start-date-weight-and-other-criteria-closing-days
Sheet: Sheet1

Project | Phase weight in [NAME] (MT) | Start Date | To Close By |  |  |  | MT slabs | MT slabs (to link formula) | [NAME] of working days to close w.r.t.  MT | Holidays (Other than Sundays)
A | 8.777 | 2022-06-01 00:00:00 |  | Need formula ( in Col.D) by when each project is suppose to close by, considering the conditions of the Phase Weight (Col.B), Start Date (Col.C) (Check No. of working days against each slab and consider Sundays and Col.K are holidays, |  |  | <=50 | 0.001 | 6 | 2022-01-01 00:00:00
B | 72.306 | 2022-05-29 00:00:00 |  |  |  |  | 51-100 | 51 | 8 | 2022-01-15 00:00:00
C | 13.349 | 2022-06-01 00:00:00 |  |  |  |  | 101-150 | 101 | 8 | 2022-01-26 00:00:00
D | 129.222 | 2022-06-16 00:00:00 |  |  |  |  | 151-200 | 151 | 12 | 2022-04-02 00:00:00
E | 287.836 | 2022-06-15 00:00:00 |  |  |  |  | 201-250 | 201 | 12 | 2022-04-15 00:00:00
F | 23.42 | 2022-06-04 00:00:00 |  |  |  |  | 251-400 | 301 | 12 | 2022-05-03 00:00:00
G | 14.989 | 2022-06-18 00:00:00 |  |  |  |  | 401-500 | 401 | 15 | 2022-08-15 00:00:00
H | 6.954 | 2022-06-08 00:00:00 |  |  |  |  | 501-600 | 501 | 15 | 2022-08-31 00:00:00
I | 754.406 | 2022-06-03 00:00:00 |  |  |  |  | 601-700 | 601 | 15 | 2022-10-05 00:00:00
J | 109.76 | 2022-06-02 00:00:00 |  |  |  |  | >700 | 701 | 15 | 2022-10-25 00:00:00
K | 74.207 | 2022-06-20 00:00:00
L | 257.711 | 2022-05-26 00:00:00
Spreadsheet: 875332d1721917334-how-to-automatically-filter-multiple-arrays-of-data-by-their-relevant-headings-lookup-sheet-test
Sheet: HazardData

HazardID | HazardNumber | OriginatorName | PhaseName | HazardName | Description | OwnerName | InitialProbabilityName | HazardTypeName | UseName | PostProbabilityName | StatusName | Notes | CustomFieldValueName | LocationName | SystemName | Private
519525 | 0 |  |  | HN1 | HD1
519500 | 1 |  |  | HN2 | HD2
519501 | 2 |  |  | HN3 | HD3
519502 | 3 |  |  | HN4 | HD4
519503 | 4 |  |  | HN5 | HD5
519504 | 5 |  |  | HN6 | HD6
519505 | 6 |  |  | HN7 | HD7
519506 | 7 |  |  | HN8 | HD8
519492 | 8 |  |  | HN9 | HD9
519493 | 9 |  |  | HN10 | HD10
519494 | 10 |  |  | HN11 | HD11
519495 | 11 |  |  | HN12 | HD12
519496 | 12 |  |  | HN13 | HD13
519497 | 13 |  |  | HN14 | HD14
519499 | 14 |  |  | HN15 | HD15
519498 | 15 |  |  | HN16 | HD16
519486 | 16 |  |  | HN17 | HD17
519487 | 17 |  |  | HN18 | HD18
519488 | 18 |  |  | HN19 | HD19
519489 | 19 |  |  | HN20 | HD20
519490 | 20 |  |  | HN21 | HD21
519491 | 21 |  |  | HN22 | HD22
519507 | 22 |  |  | HN23 | HD23
519508 | 23 |  |  | HN24 | HD24
519509 | 24 |  |  | HN25 | HD25
519510 | 25 |  |  | HN26 | HD26
519511 | 26 |  |  | HN27 | [NAME]
519512 | 27 |  |  | HN28 | HD28
519513 | 28 |  |  | HN29 | HD29
519514 | 29 |  |  | HN30 | HD30
519515 | 30 |  |  | HN31 | HD31
519516 | 31 |  |  | HN32 | HD32
519517 | 32 |  |  | HN33 | HD33
519518 | 33 |  |  | HN34 | HD34
519519 | 34 |  |  | HN35 | HD35
519520 | 35 |  |  | [NAME] | HD36
519521 | 36 |  |  | HN37 | HD37
519522 | 37 |  |  | HN38 | HD38
519523 | 38 |  |  | HN39 | HD39
519524 | 39 |  |  | HN40 | HD40
Spreadsheet: 93774d1293553474-excel-2007-separate-data-from-a-list-problem-to-be-solved
Sheet: Fleet

(in $ millions unless otherwise stated)
 | Vessel Name | Vessel Type | [NAME] | Year Built | Acquisition Cost ($ [NAME]) | Charter-Free Value ($ [NAME]) | Charter Adjustment ($ [NAME]) | Charter-Adj. Value ($ [NAME]) | Time Charter Rate ($) | TC Expiration
 |  |  |  |  |  |  |  |  |  |  |  |  | The problem to be solved!
 |  |  |  |  |  |  |  |  |  |  |  |  | To include all vessels but not the ones with 1 in D column (fleet inputs tab)
 | Subtotal/Average
 | Subtotal/Average
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: CUL

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
CULTURE ORNG M 12/12Z CN | 10942
CULTURE WTRMLN 12/12Z CN | 10941
CULTURE STRWBR 12/12Z CN | 10943
CULTURE PNK GR 12/12Z CN | 10947
CULTURE LEM LI 12/12Z CN | 10946
CULTURE WLD BR 12/12Z CN | 10944
CULTURE GNGR L 12/12Z CN | 10945
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
CULTURE ORNG M 12/12Z CN | 10942
CULTURE WTRMLN 12/12Z CN | 10941
CULTURE STRWBR 12/12Z CN | 10943
CULTURE PNK GR 12/12Z CN | 10947
CULTURE LEM LI 12/12Z CN | 10946
CULTURE WLD BR 12/12Z CN | 10944
CULTURE GNGR L 12/12Z CN | 10945
Spreadsheet: 3293c68e-f304-4c32-8686-babdd9a8d6c6
Sheet: KooRaRoo

 | KooRaRoo
 | OS | Status | Detect | Plays
 | Windows XP
 | Windows 7/8 | T | D | NP
 | Linux
 | OS X
 | T= Test  NT=Not Tested
 | D=Detectable ND=Not Detectable (have not been able to get this working yet)
 | P=Plays Movies (refer to list below)  NP=Will not play any media
 | Container | Audio Codec | Video Codec | Plays | [NAME]? | Exceptions
 | .avi | [NAME] | ac3 | Y | Y
 | .avi | [NAME] | mp3 | Y | Y
 | .avi | msmpeg4v2 | mp3 | Y | Y
 | .avi | divx5 | mp3 | Y | Y
 | .avi | [NAME] | mp3 | Y | Y
 | .avi | [NAME] | divx audio v2 | Y | Y
 | .avi | divx4 | mp3 | Y | Y
 | .flv | h264 | aac | NT | NT
 | .m4v | h264 | aac | Y | Y
 | .mkv | h264 | ogg | Y | Y
 | .mkv | h264 | aac | Y | Y
 | .mp4 | h264 | aac | N | Y
 | .mpg | mpeg1 | mp2 | Y | Y
 | .mpg | mpeg2 | mp2 | Y | Y
 | Y=Plays in full  N1=Plays but doesn't recognize audio codec N2=Plays but doesn't recognize video codec NP=does not play
 | Exceptions refers to the ability to get that type of file to be played via a particular OS
 | WXP=not working in Windows XP  W78=not working in Windows 7/8  [NAME]=not working in Linux MAC=not working in MAC
 | Notes
 | You have to click on the Devices tab at the bottom of the screen in KooRaRoo and select the device with the same IP address as you TV.
 | In the device field you can then switch it to [NAME] TV.  The will make sure it transcodes in the proper format.  Without that, it will not even transcode.
 | Another streamer that has problems with MP4.
Spreadsheet: 76042d1276622354-remove-duplicate-rows-based-on-criteria-test-to-remove-duplicates
Sheet: Result

Shipments
Location | LotNo | ReceiptCode | ExpirationDate | ShipNo
3034 | R021979 | YGOACPAKA | 2007-09-30 00:00:00 | 1094
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1094
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1126
3034 | R021979 | YGOACPAVA | 2007-09-30 00:00:00 | 1141
3034 | R021979 | YGOACPAVA | 2007-09-30 00:00:00 | 1154
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1154
3034 | R021979 | YGOACPAVA | 2007-09-30 00:00:00 | 1197
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1197
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1243
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1258
3034 | S031976 | YGOACPAVA | 2008-05-30 00:00:00 | 1287
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1294
3034 | S031976 | YGOACPAVA | 2008-05-30 00:00:00 | 1300
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1336
3034 | 05F27LA | YGOACPALA | 2008-06-30 00:00:00 | 1354
3034 | 05K18NA | YGOACPALA | 2008-11-30 00:00:00 | 1384
3034 | S031976 | YGOACPAVA | 2008-05-30 00:00:00 | 1415
3034 | 05K18NA | YGOACPALA | 2008-11-30 00:00:00 | 1420
3034 | 05K18NA | YGOACPALA | 2008-11-30 00:00:00 | 1430
3034 | S031976 | YGOACPAVA | 2008-05-30 00:00:00 | 1475
3034 | 07B09NB | YGOACPALA | 2010-02-28 00:00:00 | 1480
3034 | 07B09NB | YGOACPALA | 2010-02-28 00:00:00 | 1494
3034 | T011976AA | YGOACPAKA | 2009-01-31 00:00:00 | 1521
3034 | 07B09NB | YGOACPALA | 2010-02-28 00:00:00 | 1589
3034 | 07B09NB | YGOACPALA | 2010-02-28 00:00:00 | 1624
3034 | 07B09NB | YGOACPALA | 2010-02-28 00:00:00 | 1697
3034 | U051976AA | YGOACPAKA | 2010-07-31 00:00:00 | 1697
3034 | 07F15MC | YGOACPALA | 2010-06-30 00:00:00 | 1805
3034 | U051976AA | YGOACPAKA | 2010-07-31 00:00:00 | 1805
3034 | 07F15MC | YGOACPALA | 2010-06-30 00:00:00 | 1909
3034 | U051976AA | YGOACPAKA | 2010-07-31 00:00:00 | 1941
Spreadsheet: 840182d1692538727-transforming-database-with-formulas-transforming-database-with-formula_1
Sheet: Transoformed Base

 | Date |  | Dr |  | Our ref. |  |  |  | Cr | Amount
Spreadsheet: 189814d1351367255-how-do-i-color-rows-alternately-not-1-row-after-the-other-but-depending-on-column-data-excel
Sheet: RAW DATA

Order # | Item # | Helper Column
 |  |  |  | http://chandoo.org/wp/2010/09/28/add-zebra-lines-when-value-changes/
MAC/ORD/001 | ITEM9000
MAC/ORD/001 | ITEM0010
MAC/ORD/001 | ITEM0293
MAC/ORD/002 | ITEM0444
MAC/ORD/003 | ITEM0444
MAC/ORD/003 | ITEM9000
C | ITEM4923
C | ITEM1220
C | ITEM9000
D | ITEM0011
E | ITEM2391
E | ITEM9000
F | ITEM9000
Spreadsheet: c1fd88c3-e7ed-409b-8658-a12d20f522cb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
Pondělí 9.7. | Hanka
[NAME]. | Hanka
Pondělí 16.7 | Růža
[NAME]. | Růža
Pondělí 23.7. | Růža
[NAME] 26.7. | [NAME]
Pondělí 30.7. | [NAME]
[NAME]. | [NAME]
cvičíme od 18.00 do 19.00 hodin
příspěvek na 1 cvičební hodinu je [NAME]
Spreadsheet: a28194a7-ec6a-442a-8ddc-147c09b22a4c
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ich bin bereit, länger zu arbeiten, damit meine [NAME] ist.
 | Zivilstand:
Antwort | Ledig | Verheiratet / Konkubinat / Eingetragene Partnerschaft | Geschieden | [NAME]
Ja | 0.4 | 0.36 | 0.31 | 0.28
Neutral / Weiss nicht | 0.17 | 0.24 | 0.23 | 0.42
[NAME] | 0.43 | 0.4 | 0.46 | 0.31
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 455078d1460091087-calculate-if-date-is-two-other-dates-calculatepay
Sheet: Sheet1

Employee | Rate | Hire Date | Term Date | January | February | March | April | May | June | July | August | September | October | November | December
1 | 18 | 2011-05-02 00:00:00 | 2016-12-31 00:00:00
2 | 21.34 | 2016-05-02 00:00:00 | 2016-11-15 00:00:00
3 | 10.57 | 2016-02-28 00:00:00 | 2016-07-30 00:00:00
Spreadsheet: 873271d1719753687-excel-formula-to-calculate-indemnity-days-gratuity-sample
Sheet: Sample Gratuity

E. | NAME OF | DATE OF | BASIC | ACRUED | ACRUED | ACRUED | ACRUED | LEAVE PAY | REMARKS
NO. | EMPLOYEE | JOINING | [NAME] | LEAVE DAYS | LEAVE PAY | INDEMNITY DAYS | INDEMNITY PAY | PAID UPTO
1 | SHETTY | 2008-08-01 00:00:00 | 6500 | 0 |  |  |  | 2023-12-31 00:00:00
2 | RAO | 2013-08-15 00:00:00 | 2147 | 0 |  |  |  | 2023-12-31 00:00:00
3 | MOHD | 2016-01-24 00:00:00 | 1210 | 0 |  |  |  | 2023-12-31 00:00:00
4 | SHAH | 2016-01-25 00:00:00 | 754 | 0 |  |  |  | 2023-12-31 00:00:00
5 | ALANA | 2017-07-16 00:00:00 | 930 | 0 |  |  |  | 2023-12-31 00:00:00
6 | DEXTER | 2019-12-15 00:00:00 | 915 | 0 |  |  |  | 2023-12-31 00:00:00
7 | KAVITHA | 2022-05-08 00:00:00 | 990 | 0 |  |  |  | 2023-12-31 00:00:00
8 | RAM | 2022-12-01 00:00:00 | 225 | 0 |  |  |  | 2023-12-31 00:00:00
9 | RAI | 2023-04-20 00:00:00 | 400 | 0 |  |  |  | 2023-12-31 00:00:00
 | TOTAL LEAVE PAY AND INDEMNITY
 | LESS: PREVIOUS YEAR BALANCE |  |  |  | 0 |  | 189611
 | LEAVE PAY AND INDEMNITY FOR THE YEAR ENDING 31.12.2023
Spreadsheet: sally_beck__33737__MgmtSum-Q3-0728
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-09-01 00:00:00 | 3RD QUARTER 2000 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
[NAME] | Gas Trading
ASST_TRD | Texas Desk
 | Gas Trading
trd_mkt | Canada Trading
E_PWR_TR_AND_GENCO | East Power Trading
W_PWR_TR | West Power Trading
IR_FX | Financial Drift
ECT_INV_IRFX | Financial Trading
COAL | Coal Trading
SO2 | Emissions (Coal)
WEATHER | Weather
CROSS_COMM | Cross Commodity Trading
 | Total Trading & Risk Management
E_ORG | East Midstream |  |  |  |  |  | Turbine interest accrual
W_ORIG | West Midstream |  |  |  |  |  | Turbine interest accrual
DWNSTRM_IND_ORIG | Industrial Downstream
N_BS_DEV | Generation Investments |  |  |  |  |  | Turbine interest accrual
 | Coal Origination & Finance
fin | Canada Origination & Finance
ASST_ORIG | Upstream Originations |  | 2733 |  |  |  | Additional teams added not in plan
HPL | HPL |  | 3041
LRC | LRC |  |  | 98
INSURANCE | GRM - New Products
MEXICO | Mexico
 | Total Origination
EQUITY | Principal Investing |  | 701
PROD_FIN | Energy Capital Resources |  | 1477 |  |  |  | Increase in headcount
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group |  | 6250 |  |  |  | Headcount is over by 31 FTE's
OF_CHAIR | Office of the Chairman
 | Total Commercial
GROUP | Group |  |  |  |  |  | Intercompany billings treated as allocations in SAP
TREASURY_INT | Other Interest Related Charges
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Genco |  |  | 12886
 | HPL |  | 34710 | 33458 |  |  | [NAME] write-off
 | ENA Upstream Assets |  | 6056 | 4878 |  |  | [NAME] write-off
Spreadsheet: 161590d1339572188-excel-2007-combine-several-ifs-statements-keywords-in-a-single-cell-if-test-sample
Sheet: Sheet1

Tier 1 | [NAME] | Tier 3 | Description | Detailed_Decription | Resolution
Legacy Printer | Break-Fix | Toner Replacement | HW [Printer] Waste toner replacement | Waster Toner required | Waste toner is replaced on 31 May 2012. Waste toner shows 100% remaining. Spare WTB delivered.
Operating System | Performance Issue | Re-Image | Unable to bootup Laptop. Stucked at DOS menu | Unable to bootup Laptop. Stucked at DOS menu | performed repair and restore.
Legacy Printer | Configuration | Mapping | SW <Windows> Unable to print | [NAME] and issue persist | delete and remap printer
Hardware | Break-Fix | Keyboard | HW <[NAME] Laptop Keys A and D dropped off | Laptop Keys A and D dropped off  21th CPD | Replaced the new keyboard for the notebook.
Spreadsheet: 36583d1234456201-excel-trunc-overflow-math-table
Sheet: Sheet2

 | n
x | 1
 | how many [NAME]
 | divisible?
Spreadsheet: 774777d1648653491-date-difference-if-cell-not-blank-date-difference
Sheet: Sheet1

2022-03-30 08:52:00
2022-03-30 05:00:55
2022-03-29 23:16:18 |  |  | Should show 1
2022-03-30 04:10:04
2022-03-30 05:34:10
2022-03-29 11:16:22
2022-03-30 08:58:34
2022-03-29 16:04:10
2022-03-29 16:30:15
2022-03-29 17:00:46
2022-03-30 04:08:14
2022-03-29 14:10:42
2022-03-28 11:20:55 |  |  | Should show 2
2022-03-28 18:46:53
2022-03-29 14:35:21
2022-03-30 04:13:55
2022-03-30 05:04:14
2022-03-28 14:24:28
2022-03-28 15:47:32
2022-03-29 09:56:04
2022-03-29 13:18:57
2022-03-29 20:52:59
2022-03-30 04:11:46
 |  |  | Should be blank
Spreadsheet: 045b87ce-aa63-44d5-a1f7-712f0098ee9f
Sheet: Sheet1

Field Request Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
First Name
Last Name
Phone Number
Address
City
State
Zip Code
[NAME]
Organization Name
League Name
Non Profit Number
Type of Use
Estimated Attendance
Facility | Day | Start Time | End Time | Start Date | End Date | Fee | XFee | Total
Spreadsheet: 851747d1701887395-drop-down-menu-data-query-drop-down-menu-help
Sheet: Sheet1

Reg Nursery |  |  |  |  |  |  |  | Reg Nursery | BF Nursery
Item Number | Quantity | Item Number | Description | Cost | Price | Margin | Extended Price | Discount per item | TotalExtended Price
1 | Growing System - Herb & Lettuce AT FRAME
2080 | 2880 |  | Reg Finishing | 1.71 | 3.99 |  |  | 0
2081 | 720 |  | Reg Nursery | 1.88 | 4.24 |  |  | 0
2158 | 0 |  | BF Nursery | 4.6 | 9.25 |  |  | 0
Spreadsheet: 02bb0d37-b44e-4e8c-a34f-ca357b354d18
Sheet: Due dates

QUIZ/EXAM SCHEDULE
Chapter 1 | Aug 31
Chapter 2 | Sept 12
Chapter 12 | Sept 19
Chapter 4 | Sept 21
EXAM 1 | Sept 26
Chapter 5 | Sept 28
Balance of Payments Note & Appendix A | Oct 5
Chapter 6 | Oct 12
Chapter 7 | Oct 19
EXAM 2 | Oct 26
Chapter 8 | Nov 2
Chapter 9 | Nov 14
Chapter 10 | Nov 21
EXAM 3 | Nov 28
Briefing Paper Schedule | Discuss | Submit
Chapter 4 | Sept 21 | Oct 3
Chapter 5 | Oct 3 | Oct 10
Balance of Payments | Oct 10 | Oct 17
Chapter 6 | Oct 17 | Oct 24
Chapter 7 | Oct 24 | Oct 31
Chapter 8 - EU & others (Except below) | Nov 7 | Nov 14
Chapter 8 - Latin America and Asia | Nov 9 | Nov 16
Chapter 9 | Nov 16 | Nov 23
Chapter 10 | Nov 23 | Nov 30
Spreadsheet: 214838d1361147298-vlookup-function-bsbitu402a-part-a-task-2
Sheet: Sheet1

Sales Range | Commission Rec'd
0 | 0
10000 | 0.01
20000 | 0.02
30000 | 0.03
40000 | 0.04
50000 | 0.05
Employee Name | Base Weekly Salary | [NAME]
Alman, D | 620 | 24000
Arnold, K | 544 | 5830
Childs, F | 820 | 53000
Craddock, L | 1577 | 22660
Dale, P | 1705 | 26700
[NAME], L | 561 | 26070
Debelak, G | 1739 | 26030
Dunston, C | 1409 | 19080
Fellows, M | 925 | 48530
Gates, J | 1359 | 48860
Heaney, B | 1599 | 41060
Lane, C | 677 | 37400
Linnis, P | 610 | 31000
Mackenzie, T | 319 | 34000
Mcguiness, A | 1413 | 28550
Mok, R | 585 | 19700
Palmer, K | 590 | 36500
[NAME], K | 1649 | 48790
Rugger, L | 420 | 8500
[NAME], J | 541 | 1040
Sargent, A | 469 | 43890
Scott, W | 681 | 27440
Simpson, M | 1779 | 36480
[NAME], P | 890 | 15000
Total