tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 55202e49-93c3-43ef-ae6c-fd4cdb144009
Sheet: Sheet1

1224 [NAME]–Tapolca–Veszprém–Budapest | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 420
 |  |  |  |  | _
0 | .. | .. | .. | [NAME], aut. áll. | 05:30:00
8.4 | .. | .. | .. | Uzsa, vá. [NAME]. út | 05:39:00
9.5 | .. | .. | .. | Uzsa, erdészeti telep | 05:41:00
11 | .. | .. | .. | Uzsai elág. | 05:43:00
15.6 | .. | .. | .. | [NAME], sz. [NAME] | [NAME]
16.7 | .. | 0 | .. | [NAME] elág.
S | .. | 0.2 | .. | Lesencetomaj, aut. vt. | 05:51:00
16.7 | .. | 0 | .. | [NAME] elág.
20.5 | .. | .. | .. | Tapolca, laktanya | [NAME]
21.9 | .. | .. | .. | Tapolca, Volán telep | [NAME]
22.9 | .. | .. | .. | Tapolca, aut. áll. | 06:00:00
22.9 | .. | .. | .. | Tapolca, aut. áll. | 06:01:00
24 | .. | .. | .. | Tapolca, Halápi u. | [NAME]
27.2 | .. | .. | .. | Zalahaláp, aut. vt. | 06:07:00
32.8 | .. | .. | .. | Zalahaláp, [NAME], sz. vend. | 06:13:00
38.9 | .. | .. | .. | Nyírád, ford. | 06:20:00
44.1 | .. | .. | .. | Szőc, bej. út | [NAME]
46.1 | .. | .. | .. | Halimba, [NAME] | 06:29:00
48.5 | .. | .. | .. | [NAME] (Padragkút), felső
50.3 | .. | .. | .. | [NAME] (Padragkút), posta | 06:34:00
56.8 | .. | .. | .. | [NAME], aut. áll. | 06:43:00
56.8 | .. | .. | .. | [NAME], aut. áll. | 06:45:00
57.7 | .. | .. | .. | [NAME], [NAME]. út
61.3 | .. | .. | .. | [NAME], noszlopi elág.
67.3 | .. | .. | .. | [NAME], bej. út
69.9 | .. | .. | .. | Városlőd, völgyhíd
77.8 | .. | 0 | .. | Herend, szentgáli elág.
S | .. | 0.2 | .. | Herend, aut. vt. | S
77.8 | .. | 0 | .. | Herend, szentgáli elág.
83.1 | .. | .. | .. | Márkó, szövetkezeti vendéglő
89.3 | .. | .. | .. | Veszprém, házgyár
94.2 | .. | .. | .. | Veszprém, aut. áll. | 07:29:00
94.2 | .. | .. | .. | Veszprém, aut. áll. | 07:45:00
95.4 | .. | .. | .. | Veszprém, Viola u.
99.1 | .. | .. | .. | Geleméri elág.
104.6 | .. | .. | .. | Hajmáskéri elág. | 07:57:00
109.9 | .. | .. | .. | Öskü, bej. út | 08:03:00
117.3 | .. | 0 | .. | Várpalota, aut. áll. [NAME]. út
S | .. | 0.4 | .. | Várpalota, aut. áll. | 08:11:00
S | .. | 0.4 | .. | Várpalota, aut. áll. | 08:14:00
117.3 | .. | 0 | .. | Várpalota, aut. áll. [NAME]. út
122.3 | .. | .. | .. | Várpalota, [NAME]. út
138.9 | .. | .. | .. | Székesfehérvár, aut. áll. | 08:40:00
138.9 | .. | .. | .. | Székesfehérvár, aut. áll. | 08:45:00
140.8 | .. | .. | .. | Székesfehérvár, Király sor
143 | .. | .. | .. | Székesfehérvár, [NAME] u.
198.7 | .. | .. | .. | Budapest, [NAME] út | L 09:44
201 | .. | .. | .. | Budapest, Bocskai út | L 09:47
202.6 | .. | .. | .. | Budapest, Petőfi híd, budai hídfő | L 09:51
207.3 | .. | .. | .. | Budapest, Népliget aut. pu. | 10:00:00
[NAME]:
A járatok az [NAME], de a mezőben
fel [NAME] megállóhelyeknél [NAME] állnak meg.
0 csomagkezelést nem igénylő utasok részére
_ | Minden nap
 | a járat érinti a megállóhelyet, de nem áll meg
S | a járat nem érinti a megállóhelyet, [NAME]
L | megállás csak leszálló utasok részére
Spreadsheet: 65623d1266336666-index-and-match-formulas-sample
Sheet: VLook Up Scales

Sample# | Die# | [NAME] | Board | Estimate Number |  | Additional Plates (each) | Additional M/R (each item after 1st) | Source Tags (per each)
 |  |  |  | 5/c + Coat | 6/c + Coat
060987 | 060987-O-4 | 5.3281 x 1.9531 x 5.2968 | .016 SBS | 028574 | 028534 | 95 | 462 | 0.05
060955 | 060955-O-8 | 2.375 x 1.75 x 5.2968 | .016 SBS | 028575 | 028535 | 95 | 462 | 0.05
060900 | 060900-O-4 | 5.3281 x 2.5 x 4.625 | .016 SBS | 028576 | 028536 | 95 | 462 | 0.05
060996 | 060996-O-4 | 5.3281 x 1.625 x 4.625 | .016 SBS | 028577 | 028540 | 95 | 462 | 0.05
061151 | 061151-O-8 | 2.375 x .75 x 5.2968 | .016 SBS | 028579 | 028541 | 95 | 462 | 0.05
060995 | 060995-O-3 | 5.3281 x 2.875 x 4.625 | .016 SBS | 028580 | 028542 | 95 | 462 | 0.05
060995 | 060995-O-3 | 5.3281 x 2.875 x 4.625 | .020 SBS | 028623 | 028622 | 95 | 462 | 0.05
070913 | 070913-O-6 | 5.1093 x 1.1093 x 6.2031 | .016 SBS | 028581 | 028543 | 95 | 462 | 0.05
081275 | 081275-O-4 | 5.3281 x 1.9531 x 4.625 | .016 SBS | 028582 | 028545 | 95 | 462 | 0.05
080757 | 080757-O-2 | 4.75 x 1.7812 x 10.7187 | .016 SBS | 028583 | 028547 | 95 | 462 | 0.05
090060 | 090060-O-8 | 2.375 x .95 x 5.2968 | .016 SBS | 028584 | 028548 | 95 | 462 | 0.05
Spreadsheet: 715860d1611891023-sum-multiple-categories-in-the-same-formula-for-each-month-forum-excel-28-jan-2021
Sheet: Archive

 | Revenus et dépenses mensuelles par Mois / Année / Catégorie |  |  |  |  |  |  | Revenu individuel par [NAME] |  |  |  | Dépense individuelle par [NAME]
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée:
 | Année financière |  | 2020
 |  |  |  |  |  |  |  | Aimerais-tu voir les revenus globaux? |  |  |  | Aimerais-tu voir les dépenses globales?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Moy. Mois
 | Soldes des comptes par mois, année et compte |  |  |  |  |  |  | Solde comptes individuel
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée: |  |  |  |  | Argent métal |  | FTQ (REER)
 | Année financière |  | 2020 |  |  |  |  |  |  | [NAME] (CÉLI) |  | Urgence
Spreadsheet: 698408d1601976420-generating-unique-strings-from-duplicates-sample
Sheet: Sheet1

[NAME] | Column2
[89-78-1] | [89-78-1]_1
[89-78-1] | [89-78-1]_2
[89-78-1] | [89-78-1]_3
[89-78-1] | [89-78-1]_4
[92665-29-7] | [92665-29-7]_1
[92665-29-7] | [92665-29-7]_2
[93908-02-2] | [93908-02-2]_1
[93908-02-2] | [93908-02-2]_2
[949-67-7] | [949-67-7]
[951-78-0] | [951-78-0]_1
[951-78-0] | [951-78-0]_2
[958-09-8] | [958-09-8]
[958-74-7] | [958-74-7]_1
[958-74-7] | [958-74-7]_2
[965-90-2] | [965-90-2]
Spreadsheet: 799411d1665069684-get-values-from-multiple-tabs-with-multi-selection-private-letters-admin
Sheet: Summary

 |  |  | [NAME] | Total Patient | Total Income (paid)
 |  |  | Dr [NAME]
 |  |  | Dr [NAME]
 |  |  | Dr [NAME]
 |  |  | Dr Araf
 |  |  | Dr [NAME]
 |  |  | Dr [NAME]
 |  |  | [NAME]
 |  |  | M Syeda
 |  |  | Payment Received | Totals
 |  |  | Yes
 |  |  | NO
Spreadsheet: 111017d1307539376-how-to-key-off-data-from-two-tables-to-make-a-third-table-showing_data_different_way_date_study_milestone
Sheet: Sheet1

Table 1 |  |  |  |  |  |  | Table 2
Study | Date | Milestone |  |  |  |  | Lotid | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
A | 2011-01-01 00:00:00 | [NAME] |  |  |  |  | Z1 | x1 | x2 | [NAME] | x4 | x5 | x6 | x7 | [NAME] | x9 | x10 | x11 | x12
A | 2011-02-01 00:00:00 | [NAME] |  |  |  |  | [NAME] | y1 | y2 | y3 | y4 | y5 | y6 | y7 | y8 | y9 | y10 | y11 | y12
A | 2011-12-01 00:00:00 | Juncccc |  |  |  |  | Z3 | j1 | j2 | j3 | j4 | j5 | [NAME] | j7 | [NAME] | j9 | j10 | j11 | j12
B | 2011-02-01 00:00:00 | JUNK2
C | 2011-03-01 00:00:00 | JUNK3
D | 2011-04-01 00:00:00 | JUNK4
E | 2011-05-01 00:00:00 | JUNK5
E | 2011-06-01 00:00:00 | JunkBB
E | 2011-11-01 00:00:00 | Junkcc
F | 2011-06-01 00:00:00 | JUNK6
D | 2011-07-01 00:00:00 | [NAME]
E | 2011-08-01 00:00:00 | JUNK8
F | 2011-09-01 00:00:00 | JUNK9
D | 2011-10-01 00:00:00 | [NAME] |  |  |  |  |  | Table 3
E | 2011-11-01 00:00:00 | JUNK11
F | 2011-12-01 00:00:00 | JUNK12
F | 2011-01-01 00:00:00 | Junk13 |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  | Study | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F |  |  |  |  |  | Junk6
 |  |  |  |  |  |  |  | D |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  | Junk8
 |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  | Junk10
 |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  | Junk11
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | Study | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  | F
Spreadsheet: 555145d1515456696-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 4

 |  |  | Tournament 4
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  |  |  | 56
 |  |  |  | 48
 |  |  |  | 31
 |  |  |  | 30
 |  |  |  | 46
 |  |  |  | 61
 |  |  |  | 68
 |  |  |  | 50
 |  |  |  | 66
 |  |  |  | 62
 |  |  |  | 51
 |  |  |  | 38
 |  |  |  | 29
 |  |  |  | 65
 |  |  |  | 51
 |  |  |  | 27
 |  |  |  | 44
 |  |  |  | 41
 |  |  |  | 44
 |  |  |  | 44
 |  |  |  | 67
 |  |  |  | 35
 |  |  |  | 45
 |  |  |  | 43
 |  |  |  | 28
 |  |  |  | 56
 |  |  |  | 57
 |  |  |  | 51
 |  |  |  | 48
 |  |  |  | 48
 |  |  |  | 34
 |  |  |  | 71
 |  |  |  | 59
 |  |  |  | 25
 |  |  |  | 72
 |  |  |  | 37
 |  |  |  | 46
 |  |  |  | 54
 |  |  |  | 75
 |  |  |  | 36
 |  |  |  | 56
 |  |  |  | 42
 |  |  |  | 73
 |  |  |  | 69
 |  |  |  | 34
 |  |  |  | 54
 |  |  |  | 75
 |  |  |  | 52
 |  |  |  | 49
 |  |  |  | 74
 |  | x | x | x
Spreadsheet: 866868d1713791668-false-result-from-deeply-nested-if-formula-financial-chart-example-v1
Sheet: Consolidated_Contracts

Project | SUBPROJECT/TO/FMS
Project | SUBPROJECT/TO/FMS | Contract Date End of Month | Contract Date (if no contract date then used [NAME] start date and if FMS used PoP start since APPR year is no year) | Amount
Proj A |  |  | 2022-08-10 00:00:00 | 1519980
Proj A |  |  | 2022-12-12 00:00:00 | 2274902.51
Proj A |  |  | 2023-05-19 00:00:00 | 2108287.5
Proj A |  |  | 2023-06-05 00:00:00 | 0
Proj A |  |  | 2023-07-12 00:00:00 | 5000
Proj A |  |  | 2023-08-14 00:00:00 | 1086087.5
Proj A |  |  | 2023-09-12 00:00:00 | 2560784
Proj A |  |  | 2023-11-13 00:00:00 | 2434478.94
Proj A |  |  | 2023-12-18 00:00:00 | 100000
Spreadsheet: 877106d1723788721-popultate-cells-based-on-cell-value-of-a-different-sheet-meerabell-del-sched-to-po-help-2-365-aligw
Sheet: PO

PURCHASE ORDER
PO REFERENCE |  |  |  |  | SUPPLIER | xx
MYOB # |  |  |  |  |  | xx
DATE |  |  |  |  |  | xx
Line | AMG CODE | VAN BEEST CODE | [NAME] |  |  |  | QTY | COST | EXT COST
 | SSB047GP |  |  |  |  |  | 25 | 25
2 | SSB065GP |  | Shackle Bow Gr Pin 6.5tn |  |  |  | 16 | 16
3 | SSB095GP |  | Shackle Bow Gr Pin 9.5tn |  |  |  | 18 | 18
4 | SSB135GP |  | Shackle Bow Gr Pin 13.5tn |  |  |  | 29 | 29
5 | SSSB015GP |  | Shackle Safety Bow Gr Pin 1.5t |  |  |  | 30 | 30
6 | SSSB020GP |  | Shackle Safety Bow Gr Pin 2tn |  |  |  | 62 | 62
7 | SSSB032GP |  | Shackle Safety Bow Gr Pin3.2tn |  |  |  | 19 | 19
8 | SSSB095GP |  | Shackle Safety Bow Gr Pin9.5tn |  |  |  | 2 | 2
9 | SSSB120GP |  | Shackle Safety Bow Gr Pin 12tn |  |  |  | 5 | 5
10 | SSSB135GP |  | Shackle Safety Bow GrPin13.5tn |  |  |  | 8 | 8
11 | SSSB350GP |  | Shackle Safety Bow Gr Pin 35tn |  |  |  | 5 | 5
12 | SSSBMGP-4.75T |  | GP Big Mouth Shackle 4.75t |  |  |  | 1 | 1
13 | SSSBMGP-8.5T |  | GP Big Mouth Shackle 8.5t |  |  |  | 99 | 99
14 | SSSBMGP-12T |  | GP Big Mouth Shackle 12t |  |  |  | 120 | 120
15 | SSSBMGP-55T |  | GP Big Mouth Shackle 55t |  |  |  | 2 | 2
16 | SSSBMGP-75T |  | GP Big Mouth Shackle 75t |  |  |  | 6 | 6
17 | SSSB018GP6033 |  | Green Pin Safety Shackles Sling P-6033 18tn |  |  |  | 17 | 17
18 | SSSB030GP6033 |  | Green Pin Safety Shackles Sling P-6033 30tn |  |  |  | 8 | 8
Spreadsheet: 157969d1337941222-multiple-lookups-from-another-tab-y_not_multiple-lookups-from-another-tab_25may12_01
Sheet: emp1

 |  | Payroll number |  | ABC123
 | Previous Record:
 | Any previous disciplinary records are shown below:
 | ABC123 | [NAME] | 2012-05-20 00:00:00 | 2012-11-23 00:00:00 | 2nd Written warning | 6 months | Issue 2
 | ABC123 | [NAME] | 2012-05-24 00:00:00 | 2012-08-23 00:00:00 | 1st Written warning | 3 months | Issue 2
 | Using this number as the criteria
 | Find all occurances on the "Home Page" tab
 | Copy the results to here
Spreadsheet: sally_beck__33836__Risk Controls book breakdown
Sheet: To do

To dos |  |  | For which book | Person/group responsible | Date to start | Date to complete
1 |  | All books have been sorted to determine which have had activity in the recent past.  The ones that had not were sent to the individual commodity groups and they determined which books should be deleted, archived, or marked as inactive. | Dormant | Risk Controls
 | a | We have received all of these back from the commodity groups with the exception of east power.
 | b | We need to confirm that the list we used is a complete list and there are no hidden books that should have been on the list
2 |  | Procedures and processes need to be developed to ensure that ERMS books established flow properly into RiskTrac.  This does not address any clean-up that needs to take place, but what we should do going forward, once clean-up has occurred | Open | Risk Controls
 | a | What rules need to be made?  One commodity per book?  Should ERMS to RiskTrac books be one-to-one?
 | b | Further establish set-up procedures for new books in ERMS & RiskTrac
3 |  | We need to get the system to archive/delete closed books | Dormant | IT
4 |  | We need to get the system to mark books as active or inactive | Open | IT
5 |  | Risk controls needs to have an up-to-date list of all ERMS and RiskTrac Books |  | Risk Controls
 | a | Monitor the differences in books between the two systems
6 |  | Clean-up - The existing portfolio structure needs to be reviewed by going through all books to ensure that all ERMS books are mapped to RiskTrac. | Open | Risk Controls
 | a | Currently, for books with more than one commodity, only the last added commodity flows to RiskTrac
7 |  | A further understanding between the information going from RiskTrac to Credit and Market Risk (V@R engine) needs to be obtained | Open | Risk Controls
 | a | If a book is not officialized, credit takes the last officialized info.  If there are no more positions in that book, they could be picking up incorrect information.
8 |  | We need a system to deal with vacations and holidays. | Open | IT
9 |  | Risk leads should maintain a list of all books and how they are allocated to each book administrator. | Open | Commodity groups
10 |  | Book administrators should have a list of all books they are required to officialize each night. | Open | Commodity groups
11 |  | Commodity groups should reconcile ERMS output to RiskTrac each night before leaving. | Open | Commodity groups
 | a | Global liquids is putting this in place.
 | b | Gas should have this in place.
12 |  | Risk contols needs to be able to tell if books had positions or not | Open | IT
11 |  | The process for uploading spreadsheets needs to be documented and standardized. | Open | Risk Controls
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Sheet17

Module | MGT61100 | Tutor | All |  |  |  |  |  |  |  | List of Modules | List of tutors
 |  |  |  |  |  |  |  |  |  |  | MGT61102 | Tutor 1
 |  |  |  |  |  |  |  |  |  |  | MGT61100 | Tutor 2
 | 2023-09-11 00:00:00 | MGT61100 | [NAME] | (tutor to complete) |  |  |  |  |  |  | MGT61104 | [NAME]
Learner5 | 2023-09-11 00:00:00 | MGT61100 | Tutor 3 | (tutor to complete) |  |  |  |  |  |  |  | Tutor 4
Learner8 | 2023-09-11 00:00:00 | MGT61100 | Tutor 3 | (tutor to complete) |  |  |  |  |  |  |  | Tutor 3
Learner9 | 2023-09-11 00:00:00 | MGT61100 | Tutor 3 | (tutor to complete)
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -623008 | -616826 | -25138 | -25000
2 | -610523 | -585078 | -25001 | -25000
3 | -663655 | -658037 | -25919 | -25000
4 | -684927 | -709416 | -23707 | -25000
5 | -709597 | -718815 | -25000 | -25000
6 | -713428 | -714110 | -25002 | -25000
7 | -720273 | -719066 | -25488 | -25000
8 | -709442 | -697388 | -24057 | -25000
9 | -702534 | -702433 | -24999 | -25000
10 | -673048 | -701948 | -43196 | -25000
11 | -717759 | -710462 | -25501 | -25000
12 | -695728 | -695888 | -62
13 | -711977 | -720128 | -31257 | -25000
14 | -667051 | -645610 | -441
15 | -620405 | -615674
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  | 151133
2001-09-15 00:00:00
CBS Dollars
 |  |  | 465120
Spreadsheet: 711332d1609616824-column-a-vlookup-error-book4
Sheet: Sheet2

Updated 01/02
Customer Reference Number | [NAME]# | Description | Size | Type | Date Orderd | Released  Date | Supply Turn Over | Supply  Time | Ship Date | Status | Shortage | Comments | sales rep
121xzdsf12456 | 123456789 | shirt | Large | [NAME] | 2020-12-20 00:00:00 | 2020-12-31 00:00:00 | yes | 30 days | 2021-02-01 00:00:00 | pending | yes | [NAME] delays | [NAME]
Spreadsheet: 788728d1658671733-copy-2-different-tables-form-one-file-to-different-sheets-in-a-new-file-for-forum
Sheet: Sheet1

 | 213 |  |  | P1 | 12 |  |  | BATCH NOS |  | 7 |  |  | 25 TO 31 July  22 |  |  | SCHEDULE
 |  |  |  | M | T | W | TR | F | ST | SN |  |  | [NAME] |  |  | 2022-07-25 00:00:00 | 2022-07-26 00:00:00 | 2022-07-27 00:00:00 | 2022-07-28 00:00:00 | 2022-07-29 00:00:00 | 2022-07-30 00:00:00 | 2022-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | 09:00:00 | 10:30:00 | 1 |  |  | RM01 |  |  |  |  |  |  | 09:00:00 | 10:30:00 | 1
 | 10:45:00 | 12:15:00 | 2 |  |  | MR08 | MR02 | MR05 |  |  |  |  | 10:45:00 | 12:15:00 | 2 | MR03 | SBP 11 |  |  | MR03 |  | MR08
 | 12:30:00 | 14:00:00 | 3 |  |  | MR08 | MR05 | MR02 |  |  |  |  | 12:30:00 | 14:00:00 | 3 | 02M1 | SBP 11 |  | 02M1 | 02M1 | MR08
 | 14:30:00 | 16:00:00 | 4 |  |  | RM01 |  |  |  |  |  |  | 14:30:00 | 16:00:00 | 4
 | 16:15:00 | 17:45:00 | 5 |  |  |  | MR07 | 02M8 |  |  |  |  | 16:15:00 | 17:45:00 | 5 |  | 02M6 |  | 02M8 |  | 02M6
 | 18:00:00 | 19:30:00 | 6 |  |  |  | 02M8 | 02M8 |  |  |  |  | 18:00:00 | 19:30:00 | 6 | 02M8 | 02M8
 |  |  |  | 0 | 0 | 4 | 4 | 4 | 0 | 0
 | 325 |  |  | P2 | 19 |  |  | BATCH NOS |  | 8
 |  |  |  | M | T | W | TR | F | ST | SN
 | 09:00:00 | 10:30:00 | 1
 | 10:45:00 | 12:15:00 | 2 | SBP 12 | 02M1 |  | 02M1 | 02M1
 | 12:30:00 | 14:00:00 | 3 | SBP 12 | 02M1 |  | MR03 | MR03 | MR06
 | 14:30:00 | 16:00:00 | 4
 | 16:15:00 | 17:45:00 | 5 | 02M7 | 02M7 |  | 02M7 | 02M5 | 02M5
 | 18:00:00 | 19:30:00 | 6 | 02M6 | 02M5 |  | 02M6 | 02M6 | 02M6
 |  |  |  | 4 | 4 | 0 | 4 | 4 | 3 | 0
 | 450 |  |  | P3 | 13 |  |  | BATCH NOS |  | 6
 |  |  |  | M | T | W | TR | F | ST | SN
 | 09:00:00 | 10:30:00 | 1
 | 10:45:00 | 12:15:00 | 2 | 02M4 | 02M2 |  | 02M2 | MR01
 | 12:30:00 | 14:00:00 | 3 | MR01 | 02M4 |  | 02M4 | 02M2 |  | 02M3
 | 14:30:00 | 16:00:00 | 4
 | 16:15:00 | 17:45:00 | 5
 | 18:00:00 | 19:30:00 | 6 | 02M3 | MR04 |  | 02M3 | MR04
 |  |  |  | 3 | 3 | 0 | 3 | 3 | 0 | 1
Spreadsheet: 865132d1712193345-conditional-formatting-of-partial-rows-emmett-001-formatting
Sheet: Solution

 | gang 1 |  |  |  |  |  |  | gang 2
 | name | date | start | finish | rate | total |  | name | date | start | finish | rate | total
 | bob | 2024-03-31 00:00:00 |  |  | sick |  |  | gary | 2024-03-31 00:00:00
 | [NAME] | 2024-03-31 00:00:00 |  |  |  |  |  | [NAME] | 2024-03-31 00:00:00
 | [NAME] | 2024-03-31 00:00:00 |  |  |  |  |  | grant | 2024-03-31 00:00:00
 | gang 1 |  |  |  |  |  |  | gang 2
 | name | date | start | finish | rate | total |  | name | date | start | finish | rate | total
 | bob | 2024-03-31 00:00:00 |  |  | sick |  |  | gary | 2024-03-31 00:00:00
 | [NAME] | 2024-03-31 00:00:00 |  |  |  |  |  | [NAME] | 2024-03-31 00:00:00
 | [NAME] | 2024-03-31 00:00:00 |  |  |  |  |  | grant | 2024-03-31 00:00:00
Spreadsheet: 132912d1324030491-need-help-with-an-if-forumula-bonuscalcrough
Sheet: Sheet1

Supervisor RBC Bonus Calculator
Agent Name | ABS% | Transfer % | IR% | Amount
 | 10% goal | 13%goal | 92.1% goal
emp 1 | 8.6 | 9 | 100 | 100
emp 2 | 6 | 15 | 95 | 40
emp 3 | 11 | 15 | 95 | 0
emp 4 | 15 | 20 | 88 | -40
Spreadsheet: darrell_schoolcraft__7882__SUNFLOWER - NNG1
Sheet: JUN

NORTHERN NATURAL GAS NOMINATION FORM
FOR SUNFLOWER ELECTRIC (S4 & S5)
ON BEHALF OF WEST PLAINS ENERGY
FOR MONTH OF: |  |  | [NAME]
TO: | JENNIFER MOSSER |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FROM: | [NAME]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FAX: | [PHONE]
 | [NAME] |  | [PHONE]
FAX: | [PHONE]
 |  |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL
 | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME
GAS | 1ST |  |  | CON | GAS | 2ND |  |  | CON | GAS | 3RD |  |  | CON | GAS | 4TH |  |  | CON | GAS
DAY | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE
1 | 150 | 2001-05-31 00:00:00 | 08:03:00
2 | 150 | 2001-06-01 00:00:00 | 07:24:00
3 | 150 | 2001-06-01 00:00:00 | 07:24:00
4 | 150 | 2001-06-01 00:00:00 | 07:24:00 |  |  | 14010 | 2001-06-04 00:00:00 | 10:34:00
5 | 150 | 2001-06-04 00:00:00 | 08:07:00 |  |  | 37110 | 2001-06-04 00:00:00 | 10:34:00
6 | 6310 | 2001-06-04 00:00:00 | 10:34:00 |  |  | 6285 | 2001-06-05 00:00:00 | 07:26:00
7 | 150 | 2001-06-06 00:00:00 | 07:23:00
8 | 150 | 2001-06-07 00:00:00 | 07:20:00
9 | 150 | 2001-06-08 00:00:00 | 07:42:00
10 | 150 | 2001-06-08 00:00:00 | 07:42:00
11 | 150 | 2001-06-08 00:00:00 | 07:42:00 |  |  | 12200 | 2001-06-11 00:00:00 | 10:47:00
12 | 5750 | 2001-06-11 00:00:00 | 10:05:00
13 | 11000 | 2001-06-12 00:00:00 | 07:33:00
14 | 12500 | 2001-06-13 00:00:00 | 07:38:00
15 | 150 | 2001-06-14 00:00:00 | 07:28:00
16 | 150 | 2001-06-15 00:00:00 | 07:48:00
17 | 150 | 2001-06-15 00:00:00 | 07:48:00
18 | 9500 | 2001-06-15 00:00:00 | 07:48:00
19 | 2850 | 2001-06-18 00:00:00 | 08:01:00 |  |  | 4200 | 2001-06-19 00:00:00 | 13:38:00
20 | 0 | 2001-06-19 00:00:00 | 07:34:00 |  |  | 9450 | 2001-06-19 00:00:00 | 13:38:00
21 | 0 | 2001-06-20 00:00:00 | 07:30:00
22 | 150 | 2001-06-21 00:00:00 | 07:27:00
23 | 150 | 2001-06-22 00:00:00 | 07:38:00
24 | 150 | 2001-06-22 00:00:00 | 07:38:00
25 | 6300 | 2001-06-22 00:00:00 | 08:38:00
26 | 9600 | 2001-06-25 00:00:00 | 07:29:00
27 | 10125 | 2001-06-26 00:00:00 | 07:42:00
28 | 13662 | 2001-06-27 00:00:00 | 08:11:00
29 | 12825 | 2001-06-28 00:00:00 | 08:05:00 |  |  | 16200 | 2001-06-28 00:00:00 | 10:04:00 |  |  | 18575 | 2001-06-29 00:00:00 | 13:25:00
30 | 12073 | 2001-06-29 00:00:00 | 08:19:00 |  |  | 23420 | 2001-06-29 00:00:00 | 13:24:00
31
Spreadsheet: 128305d1320908416-sum-alternate-columns-based-on-preceding-columns-gallinski-2011-11-09
Sheet: Sheet1

 | Employee Name | +/-         No of Hrs - A/L | +/-         No of Hrs - S/L | +/-         No of Hrs - Other | Mon               2-May |  | Tue                3-May |  | Wed               4-May |  | Thur               5-May |  | Fri                   6-May
MELB | a
MELB | b |  |  |  | A | 7.6 | R | 7.6 | A | 7.6 | A | 7.6 | h | 7.6
MELB | c |  |  |  |  |  |  |  |  |  |  |  | h | 7.6
MELB | d |  |  |  |  |  |  |  |  |  |  |  | h | 7.6
MELB | e |  |  |  |  |  |  |  |  |  |  |  | h | 7.6
MELB | f |  |  |  |  |  |  |  |  |  |  |  | h | 7.6
MELB | g |  |  |  |  |  |  |  |  |  |  |  | h | 7.6
MELB | h |  |  |  |  |  |  |  |  |  |  |  | h | 7.6
MELB | i |  |  |  |  |  |  |  | S | 3.8 |  |  | h | 7.6
MELB | j |  |  |  |  |  |  |  |  |  |  |  | h | 7.6
SYD | k
SYD | l |  |  |  |  |  | P | 7.6 |  |  | R | 7.6
SYD | m
SYD | n
SYD | o
SYD | p |  |  |  |  |  | s | 3.8 | s | 7.6
SYD | q
 | Weekends
H | Public Holiday
A | Annual Leave
S | [NAME]
R | RDO
P | Personal Leave