tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40495__OM Schedule - IT 2
Sheet: Variance to Plan

DIRECT O&M VARIANCE
2001 PLAN vs. 2002 PLAN
 |  |  | 2001 RESTATED PLAN | 2001 ADJUSTED FOR 2002 BUDGET CHANGES (1)
2001 PLAN -  NET |  |  | 28.2 | 25.7
Variances:
SAN Monthly Fee |  |  | 1.8 | 2.8
Salaries to Workorders |  |  |  | 0.3
O&E Support - Transfer of Funds (1) |  |  | 0.7 | 0.9
EPSC |  |  | 0.9 | 0.5
New License Fees |  |  | 0.5
NBP - IMP, EDS FMA, etc. Moving  to Corp. |  |  | -0.8
NBP - Business Necessitated Increase (2) |  |  | 0.3
Software [NAME] (3) |  |  | 0.1 | 0.1
2002  PLAN - NET
(1) $.4 O&E Support Offset Should be Reflected in Operations 2002 Plan.
(2) Hottap license, Crestone Staff Add, Gregg Modeling System - MGT, etc.
(3) Offset in Operations
Spreadsheet: 809645d1671196686-ranking-formular-rank333-ans
Sheet: WAVULANA 5 BORA NA 5 DUNI

MTIHANI WA MUHULA WA KWANZA DARSA LA III JULAI, 2022
[NAME] BORA
NA | JINA | JINSI 1=MV 2=MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
[NAME] DUNI
NA | JINA | JINSI 1=MV 2=MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: 25578d1216935092-excel-2007-alpha-sort-columns-when-linked-cells-are-sorted-client-review-chart
Sheet: Client Review Chart_Intake Date

Client  Review Chart By Intake Date |  |  |  |  |  |  |  |  |  |  |  |  | % < 30 | % >30 | % > 60 | % > 90 | % Full
 |  | Updated
 |  |  |  |  |  |  |  |  |  |  |  |  | <30 | >30<=60 | >60<=90 | >90
 | Client Name |  | Intake Data | 30 Days | 60 Days | 90 Days | 120 Days
1 | Winther, | Svein | 2007-09-13 00:00:00
2 | STAFF | BED | 2008-02-14 00:00:00
3 | Strickland, | [NAME] | 2008-02-29 00:00:00
4 | Gohde, | Ryon | 2008-03-17 00:00:00
5 | Reese, | Clarence | 2008-04-02 00:00:00
6 | Callahan, | [NAME] | 2008-05-05 00:00:00
7 | Ward, | Cedric | 2008-05-20 00:00:00
8 | Newton, | Mark | 2008-05-23 00:00:00
9 | Brown, | [NAME] | 2008-05-27 00:00:00
10 | Waldrop, | Adam | 2008-05-27 00:00:00
11 | Mathews, | [NAME] | 2008-06-02 00:00:00
12 | Parmer, | [NAME] | 2008-06-06 00:00:00
13 | Barger, | Greg | 2008-06-06 00:00:00
14 | [NAME], | [NAME] | 2008-06-09 00:00:00
15 | Childree, | [NAME] | 2008-06-19 00:00:00
16 | Hadley, | [NAME] | 2008-06-27 00:00:00
17 | Hansel, | [NAME] | 2008-07-09 00:00:00
18 | [NAME], | [NAME] | 2008-07-09 00:00:00
19 | King, | Jeremy | 2008-07-16 00:00:00
20 | [NAME], | [NAME] | 2008-07-17 00:00:00
21 | Harris, | Julius | 2008-07-17 00:00:00
22 | Law, | Marcus | 2008-07-21 00:00:00
23 | Zack, | [NAME] | 2008-07-22 00:00:00
24
25
26
Spreadsheet: 6751a27e-df30-4b04-8131-ff059f0f92ee
Sheet: Sheet1

A [NAME]. ([NAME].) Korm. rendelete a köztulajdonban álló gazdasági [NAME] [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  | [NAME] tisztségviselő |  |  | Felügyelőbizottsági tag |  |  | [NAME] állású munkavállaló | Elkülönült szervezeti egységet vezető munkavállaló | Tartósan egyes munkavállalók tevékenységét irányító munkavállaló
 | Név |  | ifj.dr [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | M.Román Béla | [NAME]
 | Tisztség v. munkakör |  | [NAME] | igazgatósági tag | igazgatósági  tag | [NAME] | felügyelőbizottsági tag | felügyelőbizottsági tag | cégvezető
[NAME]-szony esetén | Munkaviszony alapján [NAME] [NAME] juttatások | [NAME] alapbér |  |  |  |  |  |  | 450.000 Ft/hó
 |  | [NAME] |  |  |  |  |  |  | 150.000 Ft/hó
 |  | időbért megalapozó időtartam
 |  | teljesítménybér
 |  | teljesítménybért megalapozó [NAME]
 | [NAME] ill felmondási idő időtartama |  |  |  |  |  |  |  | Mt.szerint
 | Mt. 3.§ (6) bek. alapján kikötött időtartam és a kötelezettség vállalásának ellenértéke |  |  |  |  |  |  |  | nincs [NAME]
A Gt. 22.§ (2) a) pont szerinti [NAME], valamint FB tagok esetén | Megbízási díj |  | bruttó 40.000Ft/hó | bruttó 30.000Ft/hó | bruttó 30.000Ft/hó | bruttó    40.000Ft/hó | bruttó   30.000Ft/hó | bruttó    30.000Ft/hó
 | Megbízási díjon felüli egyéb járandóságok |  | - | - | - | - | - | -
 | Jogviszony megszűnése esetén járó pénzbeli juttatások |  | - | - | - | - | - | -
Spreadsheet: sally_beck__33824__global standards daily reporting
Sheet: C 03

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards C
Note: | If all the current standard does not meet the global standard (for example trade confirmations are executed with 14 days, please list exceptions to that standard too).  Also, if not all trades are confirmed (ie spot) please note that)
Report C 03:
Purpose: | To capture what confirmations have not been executed with 7 days.
Trade Date | Deal # | Commodity | Transaction | Counterparty | Reason confirmation not executed | Key contact
2000-10-25 00:00:00 | Sample | Power West | Sale of 10K MWH | EES | Continual problems receiving signed confirmations from counterparty | [NAME]
Question:  Should we also track when a discrepancy occurred?
Spreadsheet: 95428d1295019466-3-tiered-matrix-lookup-formula-updated-example
Sheet: Sheet1

Category 1 | 6.1.1 |  |  | Category | Question | Answer | Text |  |  | Category 1 | Category 2
Answer 1 | Yes | 1 |  | 6.1.1 | 1 | No | Text 1 |  |  |  |  | #N/A
Answer 2 | No | 2 |  | 6.1.1 | 1 | Yes | Text 2 |  |  |  |  | #N/A
Answer 3 | South | 3 |  | 6.1.1 | 2 | No | Text 3 |  |  |  |  | #N/A
Answer 4 |  | 4 |  | 6.1.1 | 2 | Yes | Text 4
Answer 5 |  | 5 |  | 6.1.1 | 3 | East | Text 5
Answer 6 |  | 6 |  | 6.1.1 | 3 | North | Text 6
Answer 7 |  | 7 |  | 6.1.1 | 3 | South | Text 7
Answer 8 |  | 8 |  | 6.1.1 | 3 | West | Text 8
Answer 9 |  | 9 |  | 6.2.4 | 1 | East | Text 9
Answer 10 |  | 10 |  | 6.2.4 | 1 | North | Text 10
 |  |  |  | 6.2.4 | 1 | South | Text 11
Category 2 | 6.2.4 |  |  | 6.2.4 | 1 | West | Text 12
Answer 1 | North | 1 |  | 6.2.4 | 2 | No | Text 13
Answer 2 | Unsure | 2 |  | 6.2.4 | 2 | Unsure | Text 14
Answer 3 | Yes | 3 |  | 6.2.4 | 2 | Yes | Text 15
Answer 4 |  | 4 |  | 6.2.4 | 3 | No | Text 16
Answer 5 |  | 5 |  | 6.2.4 | 3 | Yes | Text 17
Answer 6 |  | 6
Answer 7 |  | 7
Answer 8 |  | 8
Answer 9 |  | 9
Answer 10 |  | 10
Category 3 etc. up to 10
Example:
Category 1 - Dog | Answer | Question No. |  | Category | Question | Answer | Text |  |  | Category 1 - Dog | Category 2 - Cat
Answer 1 | No | 1 |  | Category 1 - Dog | 1 | No | A few small dog breeds include [NAME] Daschund… |  |  | A few small dog breeds include [NAME] Daschund… | A few breeds which are suited to the outside include…
Answer 2 | No | 2 |  | Category 1 - Dog | 1 | Yes | A few big dog breeds include German [NAME], [NAME]…. |  |  | It is recommended that you look for a small dog breed… | ??
 |  |  |  | Category 1 - Dog | 2 | No | It is recommended that you look for a small dog breed…
Category 2 - Cat |  |  |  | Category 1 - Dog | 2 | Yes | Your yard should be sufficient for larger breeeds…
Answer 1 | No | 1 |  | Category 2 - Cat | 1 | No | A few breeds which are suited to the outside include…
Answer 2 | Yes | 2 |  | Category 2 - Cat | 1 | Yes | A few breeds which are suited to the inside include…
 |  |  |  | Category 2 - Cat | 2 | No | ??
 |  |  |  | Category 2 - Cat | 2 | Yes | ??
Spreadsheet: 476314d1471793017-power-pivot-help-on-creating-calculated-columns-powerpivot
Sheet: Sheet2

 |  |  |  |  |  | Can this be part of pivot? How to create calculated field?
Customer NO | Customer Name | PO Number | Sum of Order Qty | Sum of Delivered | Sum of Open Qty | [NAME] | No of Orders | No of Invoices | Order to invoice Min | Order to invoice [NAME] | invoice to delivery Min | invoice to delivery [NAME]
1 | Pavan | PO 1 | 276 | 222 | 52 |  | 2 | 3
1 | Pavan | PO 3 | 177 | 90 | 46 |  | 3 | 1
 |  |  |  |  |  |  | Can this be part of pivot? How to create calculated field?
 |  |  |  |  |  |  | if not part of pivot how can I achieve this trough formula
 |  |  |  |  |  |  |  |  | No of days (calendar days) inclusive of both start day and end day
 |  |  |  |  |  |  |  |  | days between order date and invoice date
 |  |  |  |  |  |  |  |  | Min if and [NAME] if would work I guess but data is really huge how would I achieve this?
Spreadsheet: john_lavorato__16475__alberta40117
Sheet: OtherPosn

Other Portfolio Positions |  |  |  | Peak Price |  |  | OffPeak Price |  |  | Sunday Price
Region | Name | Term | RefDt | Prior | Current | Change | Prior | Current | Change | Prior | Current | Change | Peak | OffPeak | Sunday | CrvShift | PriorDt | CurrDt | CurrUpdateTm | mtmTm | mtmDt
Spreadsheet: 761577d1641059067-formula-for-multiple-conditions-test-file-etaf-
Sheet: Sheet2

Name | Availability | [NAME]
A |  | Do Not Disturb | [NAME]", countifs(Sheet1!$A$2:$A$6,Sheet2!$A2,Sheet1!$B$2:$B$6,"pending")>0,countifs(Sheet1!$A$2:$A$6,Sheet2!$A2,Sheet1!$B$2:$B$6,"completed")>1)),"not Available","X")
B
C |  |  |  |  |  |  | The person A should not be available if:    1. The DND status (Sheet2) of person A is Do Not Disturb.  2. The status of person A is pending (Sheet 1).  3. Person A has 2 or more status as Completed.
D
 |  |  | [NAME]
 |  |  | Pending
 |  |  | Completed
 |  |  | OR
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 136208 | 142148
2 | 91841 | 120259
3 | 95240 | 97445
4 | 116769 | 114074
5 | 108530 | 114453
6 | 119572 | 113703
7 | 112545 | 111866
8 | 112164 | 113431
9 | 113044 | 111560
10 | 116403 | 112898
11 | 103748 | 104833
12 | 107912 | 106898
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 54883
2001-08-12 00:00:00
CBS Dollars
 |  |  | 411751.53
Spreadsheet: 752522d1634815882-year-to-date-calculation-formula-ytd-calculation
Sheet: Sheet1

Date | Value | YTD
2020-01-31 00:00:00 | 1046.10447761194
2020-02-28 00:00:00 | 1063.477611940298
2020-03-31 00:00:00 | 1055.955223880597
2020-04-30 00:00:00 | 1018.582089552239
2020-05-31 00:00:00 | 1057.089552238806
2020-06-30 00:00:00 | 1240.671641791045
2020-07-31 00:00:00 | 1209.149253731343
2020-08-31 00:00:00 | 1209.268656716418
2020-09-30 00:00:00 | 1227.238805970149
2020-10-31 00:00:00 | 1174.10447761194
2020-11-30 00:00:00 | 1217.268656716418
2020-12-31 00:00:00 | 1168.194029850746
2021-01-31 00:00:00 | 1200.970149253731
2021-02-28 00:00:00 | 1212.910447761194
2021-03-31 00:00:00 | 1187.417910447761
2021-04-30 00:00:00 | 1302.582089552239
2021-05-31 00:00:00 | 1290.940298507463
2021-06-30 00:00:00 | 1299.477611940298
2021-07-31 00:00:00 | 1223.895522388059
2021-08-31 00:00:00 | 1276.910447761194
2021-09-30 00:00:00 | 1292.074626865671
2021-10-31 00:00:00 | 1393.895522388059
2021-11-30 00:00:00 | 1626.910447761194
2021-12-31 00:00:00 | 1692.074626865671
Spreadsheet: 874640d1721208029-im-struggling-with-a-conditional-formatting-formula-excelformumexample
Sheet: Sheet1

Client Parent Name | Client Code | Client Name | Client Dept | Client Partner | Manager | Personal Tax Manager | TIS Service | Treat as a Group | Director of | Partner of | Spouse is | Company Sec of | Assignments | 2023 | Type | Trading Status | Deceased ? | Live client / No longer acting ? | Pensions Received | Employment Payments from P60 | Business Tax Turnover | Land & Property Rental | Total Self Employed | Company Turnover | Insurance Cover If Required
Parent Test 1 | TEST1 | Test Company Ltd | Small Business Team | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | Ltd Co/LLP/PS up to £250k
Parent Test 1 | TEST2 | [NAME] | Small Business Team | [NAME] | [NAME] | [NAME] |  |  | TEST1 |  |  |  |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | DNI
Spreadsheet: 815214d1674819607-advance-filter-from-master-sheet-to-another-sheet-kitap1
Sheet: Sayfa2

 | ADMİN | NAME | PERFORMANS PUANI
 | BÜNYAMİN YAVUZ | Ayülker İhsanoğlu | 2
 | BÜNYAMİN YAVUZ | [NAME] Sakarya Bilge | 4
 | BÜNYAMİN YAVUZ | Arcan Ülker | 3
 | BÜNYAMİN YAVUZ | [NAME] | 5
 | BÜNYAMİN YAVUZ | [NAME] | 3
 | BÜNYAMİN YAVUZ | [NAME] | 4
 | BÜNYAMİN YAVUZ | [NAME] Yorulmaz | 2
 | BÜNYAMİN YAVUZ | [NAME] | 5
 | BÜNYAMİN YAVUZ | [NAME] | 4
 | BÜNYAMİN YAVUZ | [NAME] | 3
 | BÜNYAMİN YAVUZ | Bayan Nürice Nuriyet Aksu Mansız | 4
 | [NAME] | [NAME] | 5
 | [NAME] | Dr. [NAME] İnönü | 3
 | [NAME] | Dr. [NAME] Çetin Ülker | 4
 | [NAME] | [NAME] | 2
 | [NAME] | [NAME] | 5
 | [NAME] | Görklü [NAME] | 4
 | [NAME] | Dr. Uğur Semine Öcalan Şama | 3
 | [NAME] | [NAME] | 5
 | [NAME] | [NAME] | 2
 | [NAME] | Dr. [NAME] Öcalan | 2
 | [NAME] | [NAME] | 4
 | [NAME] | [NAME] | 3
 | [NAME] | Bayan Mübetcel Nilcan Tevetoğlu | 5
 | [NAME] | [NAME] Sezgin | 3
 | [NAME] | Dr. [NAME] | 4
 | [NAME] | Dr. [NAME] | 2
 | [NAME] | Bayan Aral [NAME] | 5
 | [NAME] | [NAME] | 4
 | [NAME] | Aslanhan Ulutay Sezgin | 3
 | BÜNYAMİN YAVUZ | Dr. [NAME] | 3
 | [NAME] | Tanses Semat Akçay Sezgin | 4
 | [NAME] | [NAME] | 3
 | [NAME] | [NAME] | 3
 | [NAME] | Faize Nurveren Zengin | 3
 | [NAME] | [NAME] | 2
 | [NAME] | Görklü [NAME] | 5
 | [NAME] | Ozansü Ferihan Sezgin | 2
 | [NAME] | [NAME] | 4
 | [NAME] | [NAME] | 3
 | [NAME] | [NAME] | 5
 | [NAME] | Ginyas Erdoğan | 3
Spreadsheet: 190403d1351632659-auto-populate-the-word-closed-in-once-cell-once-a-date-is-entered-in-another-cell-my-problem
Sheet: Sheet1

AREA OFFICE | M&C YEAR | M&C # | DATE OF NOTICE | DEPT | ISSUE | BU (s) | STAFF ASSIGNED | DATE LETTER SENT | RESOLVED/CLOSED DATE | TOTAL DAYS CASE HAS BEEN OPEN TO DATE SINCE LETTER WAS [NAME] AND ASSIGNED TO A REP | Working days it took to close | MEET & CONFER TEAM APPOINTED | NOTES | DATE- Notified Rep when case reached 20 days
 |  | 1-C |  |  |  |  |  | 2012-10-01 00:00:00 | 2012-10-30 00:00:00 |  |  |  | Ten employees relocating from San Francisco to Oakland, no issues as all are accepting the change.
Spreadsheet: benjamin_rogers__1308__site_visit_schedule for Dave Kristich
Sheet: Schedule

As of…
E2 Site Visit Schedule
 |  |  | [NAME] ([NAME]) | Lincoln (Fred/Ross) | Wheatland (Jeff/Chris) | [NAME] | Pastoria
Week 1 | 2000-10-12 00:00:00 | Thur
 | 2000-10-13 00:00:00 | Fri
Week 2 | 2000-10-16 00:00:00 | Mon
 | 2000-10-17 00:00:00 | Tue | Duke (morning)
 |  |  | confirm sent
 | 2000-10-18 00:00:00 | Wed | NRG (morning)
 |  |  | [NAME]
 | 2000-10-19 00:00:00 | Thur | Allegheny (morning)
 |  |  | confirm sent
 | 2000-10-20 00:00:00 | Fri
Week 3 | 2000-10-23 00:00:00 | Mon | Peco
 |  |  | [NAME]
 | 2000-10-24 00:00:00 | Tue | Cinergy (morning)
 |  |  | confirm sent
 | 2000-10-25 00:00:00 | Wed | [NAME] (morning)
 |  |  | [NAME]
 | 2000-10-26 00:00:00 | Thur | LG&E (late morning)
 |  |  | confirm sent
 | 2000-10-27 00:00:00 | Fri | Calpine (morning)
 |  |  | Confirm sent
Spreadsheet: 00cf0db3-7d73-492d-82cd-05031621185d
Sheet: Sheet1

Follow-up Survey - College | Unnamed: 1 | Unnamed: 2
 | Fall 2012 | Sp. 2013
[NAME] | Ave. score | Ave. score
PLANNING
Plan objectives and select supporting activities. | 4.4 | 4.4
Plan for individual differences, including cultural diversity and children with exceptionalities. | 4.3 | 4.6
Plan for short-term and long-term evaluation of student teaching (daily, weekly, yearly). | 4.4 | 4.4
Understand developmental characteristics of students a guide for planning. | 4.5 | 4.5
MANAGEMENT
Organize and maintain an effective classroom environment (space, materials, equipment, learning climate). | 4.4 | 4.2
Management of student behavior for effective learning. | 4.2 | 4.4
INSTRUCTION
Understand and convey knowledge of subject matter. | 4.4 | 4.5
Employ a variety of teaching strategies. | 4.3 | 4.3
Provide opportunities for student involvement in learning. | 4.4 | 4.5
Stimulate high-order thinking. | 4.5 | 4.4
Use materials, resources, and activities that are developmentally appropriate. | 4.4 | 4.5
Use technology to enhance learning. | 4.3 | 4.6
Provide effective on-going assessment, including performance-based assessment. | 4.2 | 4.2
TEACHER EDUCATION TRAINING
Rate the extent to which field experiences contributed to your teacher education training. | 4.4 | 4.3
Rate the extent to which student teaching contributed to your teacher education training. | 4.5 | 4.4
Spreadsheet: 841772d1693932113-hint-how-to-compare-two-tables-with-different-number-of-rows-example_comparedb
Sheet: Sheet30

Report of the primary values between a MASTER list and SLAVE list, based on the 'Servise name' key field in the MASTER list and the 'Servise name' in the SLAVE list.
The MASTER list is in worksheet 'Plan_Jan23', range '$B$3:$F$9', and the value for comparison in column 'Departament 3 Plan'.
The SLAVE list is in worksheet 'Plan_Feb23', range '$[NAME]', and the value for comparison in column 'Departament 3 Plan'.
Of the '6' records in the MASTER list there were '6' matching records in the SLAVE list.
The following '4' Key Records have different primary values.
Key Record | Master Value | Slave Value
Cleaning supplies | 658 | 680
Cloths expenses | 157 | 180
Electicity delivered | 547 | 550
Food expenses | 327 | 330
Spreadsheet: 197026d1354193629-2007-ranking-over-multiple-columns-sample
Sheet: Sheet1

 |  |  |  |  | item | value | rank? |  |  | item | value |  |  |  | item | value
 |  |  |  |  | a | 4 |  |  |  | e | 6 |  |  |  | i | 2
 |  |  |  |  | b | 3 |  |  |  | f | 0 |  |  |  | j | 1
 |  |  |  |  | c | 5 |  |  |  | g | 0 |  |  |  | k | 2
 |  |  |  |  | d | 1 |  |  |  | h | 3 |  |  |  | l | 3
 |  |  |  |  | I need to rank g2 across the multiple criteria of g:g, l:l, q:q. in this case, 3 should be returned.
Spreadsheet: 791995d1660686049-data-separation-issue-dataexample_08162022
Sheet: Sheet1

Charge-1 Description
1-10yd Front Load - 1x/Week
1-8yd Front Load - 5x/Week
1-8yd Recycling - 5x/Week
1-6yd Recycling - 1x/Week
1-8yd Front Load - 3x/Week
Scrap Metal Service
Scrap Metal Service
1-10yd Scrap Metal - On Call
Scrap Metal Service
Scrap Metal Service
Scrap Metal Service
Fork Lift Rental
Scrap Metal Service
Empty & Return
Scrap Metal Service
Scrap Metal Service
Scrap Metal Service
Empty & Return
1-6yd Rear Load - 2x/Week
1-4yd Front Load - 1x/Week
1-4yd Recycling - 1x/Week
1-6yd Recycling - 1x/Week
10yd Open Top Rental
Empty & Return
(1) 8yd Front Load - 2x/wk
(1) 4yd Front Load - 1x/wk
30 Yard Empty & Return
20 Yard Final Pickup
(1) 8yd Front Load - 1x/wk
40 Yard Empty & Return
(1) 8yd Front Load - 1x/wk
(1) 8yd Front Load - 2x/wk
20 Yard Empty & Return
(1) 6yd Front Load - 3x/wk
20 Yard Empty & Return
10 Yard Empty & Return
30 Yard Empty & Return
20 Yard Final Pickup
30 Yard Final Pickup
(7) Cart Service
Spreadsheet: 854866d1704619716-formula-or-function-to-compare-dates-and-calculate-relevant-cells-matchday
Sheet: RatingGroups

 | Rating Groups
 | from | to | Group
 | -33000 | -200 | Gr03-
 | -199.999999 | -7 | Gr02-
 | -6.999999 | 0 | Gr01-
 | 1e-06 | 0.0010999 | Gr01
 | 0.0011 | 0.002999 | Gr02
 | 0.003 | 0.0069999 | Gr03
 | 0.007 | 0.0179999 | Gr04
 | 0.018 | 0.069999 | Gr05
 | 0.07 | 0.379999 | Gr06
 | 0.38 | 0.999999 | Gr07
 | 1 | 1.899999 | Gr08
 | 1.9 | 3.49999999 | Gr09
 | 3.5 | 6.499999 | Gr10
 | 6.5 | 9.999999 | Gr11
 | 10 | 18.999999 | Gr12
 | 19 | 34.999999 | Gr13
 | 35 | 99.999999 | Gr14
 | 100 | 1000000 | Gr15
Spreadsheet: 841909d1694030215-birthday-acknowledgement-yg_birthdays
Sheet: Sheet2

Name | Birthdate | Age | Current Year DOB | Nearest Wednesday to Birthday | Acknowledge | Rank |  |  |  |  |  |  |  | 2023-09-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-04 00:00:00
Avah Prahn | 2019-09-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-11 00:00:00
Asher Wombat | 2018-09-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-18 00:00:00
[NAME] | 2014-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-01 00:00:00
[NAME] | 2015-10-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-08 00:00:00
[NAME] | 2015-10-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-22 00:00:00
[NAME] | 2013-11-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-29 00:00:00
[NAME] | 2020-01-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-06 00:00:00
[NAME] | 2020-07-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-20 00:00:00
[NAME] | 2016-08-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-03 00:00:00
Zoe Stork | 2014-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-10 00:00:00
Moriah Weeble | 2016-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-17 00:00:00
[NAME] | 2019-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-24 00:00:00
[NAME] | 2019-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-31 00:00:00
Brighton Speaker | 2020-07-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-28 00:00:00
Name | Birthdate | Age | Current Year DOB | Nearest Wednesday to Birthday | Acknowledge | Rank |  |  |  |  |  |  |  | 2024-03-06 00:00:00
[NAME] | 2019-09-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-03-20 00:00:00
[NAME] | 2018-09-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-03-27 00:00:00
[NAME] | 2014-10-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-03 00:00:00
Elijah Pals | 2015-10-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-10 00:00:00
Ariah Pals | 2015-10-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-17 00:00:00
[NAME] | 2013-11-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-24 00:00:00
[NAME] | 2019-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-01 00:00:00
[NAME] | 2019-06-21 00:00:00
[NAME] | 2020-01-20 00:00:00
[NAME] | 2020-07-26 00:00:00
Briggs Shivers | 2020-07-26 00:00:00
[NAME] | 2016-08-12 00:00:00
Zoe Shivers | 2014-03-16 00:00:00
Moriah Willis | 2016-03-29 00:00:00
Spreadsheet: 768406d1644949344-add-minutes-to-time-but-make-it-random-sample
Sheet: Sheet1

1900-01-12 00:07:00
Spreadsheet: 684301d1593275594-accumulate-amount-according-to-dates-and-sort-them-by-date-sample
Sheet: TRADE

 | Counter | Date | Cost | Date | Revenue
 | JCY | 2017-03-14 00:00:00 | 700.89306 | 2017-03-29 00:00:00 | 569.1292
 | PWORTH | 2017-03-14 00:00:00 | 530.8389999999999 | 2017-04-12 00:00:00 | 569.1292
 | DUFU | 2017-03-16 00:00:00 | 605.86285 | 2017-06-01 00:00:00 | 726.5991086399978
 | MKLAND | 2017-03-17 00:00:00 | 1005.99005 | 2017-03-31 00:00:00 | 929.01472
 | HALEX | 2017-03-21 00:00:00 | 1322.09022 | 2017-03-23 00:00:00 | 1437.85254
 | WILLOW | 2017-04-03 00:00:00 | 2408.43525 | 2017-04-10 00:00:00 | 2641.46935
 | BTM | 2017-04-18 00:00:00 | 3274.71032 | 2017-04-28 00:00:00 | 2801.41847
 | DNEX | 2017-04-26 00:00:00 | 974.980192 | 2017-10-04 00:00:00 | 553.134288
 | KRONO | 2017-04-29 00:00:00 | 2701.028265 | 2017-07-05 00:00:00 | 3072.831815
 | GADANG-WB | 2017-06-01 00:00:00 | 1059.506745 | 2017-11-14 00:00:00 | 621.612505
 | HIBISCUS | 2017-09-20 00:00:00 | 1042.00118 | 2017-09-21 00:00:00 | 1267.9066
 | HIBISCUS | 2017-09-20 00:00:00 | 1042.00118 | 2017-09-25 00:00:00 | 1267.9066
 | VS-WA | 2017-09-25 00:00:00 | 1220.057784 | 2017-10-05 00:00:00 | 1347.88116
 | ICON | 2017-09-26 00:00:00 | 990.98528 | 2017-11-14 00:00:00 | 794.0576500000001
 | GBGAQRS-WA | 2017-10-06 00:00:00 | 1427.12361 | 2017-10-26 00:00:00 | 1512.82869
 | KEYASIC | 2017-10-11 00:00:00 | 1257.06955 | 2017-10-11 00:00:00 | 1612.79689
 | AEGB | 2017-10-17 00:00:00 | 1010.99164 | 2017-11-14 00:00:00 | 749.07196
 | PUC | 2017-11-10 00:00:00 | 1057.00595 | 2017-12-22 00:00:00 | 1017.9861
 | AEMULUS | 2017-11-10 00:00:00 | 1052.00436 | 2017-12-22 00:00:00 | 906.521875
 | BSLCORP | 2017-11-20 00:00:00 | 1187.04729 | 2017-12-22 00:00:00 | 26685.44426