tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 048c1ef0-f0f7-4f38-9ecb-998a6c74647a
Sheet: Sheet1

STACKS MANAGEMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
DAILY DUTIES CHART
Use the erasable markers only!
DUTY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
[NAME]
1st Fl Pickup
2nd So Pickup
2nd No Pickup
3rd Fl Pickup
Mailed Papers
AM Currents
Cleanup * | A-E | F-H | J-PN | PQ-Q | R-Z
Special Coll
[NAME]
Search Box*
Microforms
PM Currents
Prev Sun Pap
[NAME]
Sun Currents
NOTES:
1.     An asterisk (*) indicates a task which, if not completed when scheduled, MUST be done at the start of the next day.
2.     Check the appropriate box BEFORE starting a task, NOT after it is completed, so other will know it is being worked on.
3.     If you don't finish a task, erase the checkmark and/or leave a note on the Activity Log telling others how far you got.
4.     The gray-shaded boxes indicate tasks that do not have to be done on that particular day.
Spreadsheet: 782017d1653690506-ongoing-custom-lookup-function-questions-daily-tickets-report-beta-
Sheet: Daily Tickets Report

 | FreshDesk | Open Tickets | Pending Tickets | Oldest Open Response
 | Total Open
 | CallTek | Open Tickets |  | Oldest Ticket Age
 | Tier - 1 (Calltek-Guest)
 | Tier - 2 (Calltek-NOC)
 | Tier - 3 (HIS-NOC)
 | BeyondTV Support
 | Total Open
 | Kentrone | Open Tickets |  | Oldest Ticket Age
 | Tier - 1
 | Tier - 2
 | Tier - 3
 | Total Open
 | CRM | Open Tickets |  | Oldest Ticket Age
 | [NAME] |  |  | 2020-07-16 00:00:00
 | [NAME] |  |  | 2021-08-07 00:00:00
 | [NAME] |  |  | 2022-02-03 00:00:00
 | [NAME] |  |  | 2022-03-03 00:00:00
 | [NAME] |  |  | 2022-03-31 00:00:00
 | [NAME] [NAME] |  |  | 2022-04-20 00:00:00
 | [NAME]
 | [NAME] |  |  | 2022-05-02 00:00:00
 | [NAME] |  |  | 2022-05-20 00:00:00
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Nate Thibault |  |  | 2022-05-24 00:00:00
 | Total Open
Spreadsheet: 3ddcdb7b-cead-4639-8067-f21e82c6f073
Sheet: Fields I-N

Permit No.: |  |  | WQ0029233 |  |  | Facility Name: |  | Bear Lake Reserve |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | I |  | Field Name: |  | K |  | Field Name: |  | M |  | Field Name: |  | N
 |  |  |  |  |  | Area (acres): |  | 0.85 |  | Area (acres): |  | 0.99 |  | Area (acres): |  | 0.52 |  | Area (acres): |  | 0.58
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05
 |  |  |  |  |  | Annual Rate (in): |  | 80.0 / 8.0 |  | Annual Rate (in): |  | 71.0 / 7.1 |  | Annual Rate (in): |  | 66.8 / 6.7 |  | Annual Rate (in): |  | 60.2 / 6.0
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 268191d1380487139-lookup-with-multiple-crieria-and-multiple-solutions-test-1_alkey
Sheet: Sheet1

Date | Player | Accomplishment
2013-09-15 00:00:00 | [NAME] | [NAME] |  |  |  | Player: | [NAME]
2013-09-15 00:00:00 | [NAME] | [NAME] |  |  |  | Date Range: | 2013-09-15 00:00:00 | - | 2013-09-22 00:00:00
2013-09-15 00:00:00 | [NAME] | Rush for 150 yds |  |  |  | Accomplishments:
2013-09-15 00:00:00 | [NAME] | 300 yds Passing |  |  | 1
2013-09-15 00:00:00 | [NAME] | Caught 3 touchdowns |  |  | 2
2013-09-22 00:00:00 | [NAME] | [NAME] |  |  | 3
2013-09-22 00:00:00 | [NAME] | [NAME] |  |  | 4
2013-09-22 00:00:00 | [NAME] | Rush for 150 yds |  |  | 5
2013-09-22 00:00:00 | [NAME] | 300 yds Passing |  |  | 6
2013-09-22 00:00:00 | [NAME] | Caught 3 touchdowns |  |  | 7
2013-09-22 00:00:00 | [NAME] | No Interceptions |  |  | 8
2013-09-22 00:00:00 | [NAME] | No Interceptions |  |  | 9
 |  |  |  |  | 10
Spreadsheet: 696116d1600637215-dynamic-named-range-not-working-quite-right-demo-file
Sheet: Worksheet

Date | Start Date
 |  |  |  | [NAME]: "$B$2:INDEX(Worksheet[Start Date],COUNT(Worksheet[Start Date]))"
 |  |  |  | Should return all 4 Dates in column B, but only returns the first date.
 |  |  | 2020-09-20 00:00:00 |  | 2020-09-20 00:00:00
 |  |  | 2020-09-27 00:00:00 |  | 2020-09-27 00:00:00
 |  |  | 2020-10-04 00:00:00 |  | 2020-10-04 00:00:00
Spreadsheet: 790902d1660055822-return-date-in-cell-based-columns-a-c-find-the-date
Sheet: Start Stop

EOS Report |  |  |  |  | Search Information
Build Date | Start # | Stop # |  |  | Shipping Date | Number |  | Return Date
2022-08-01 00:00:00 | 291 | 621
2022-08-01 00:00:00 | 622 | 853
2022-08-02 00:00:00 | 854 | 7
2022-08-02 00:00:00 | 8 | 353
2022-08-03 00:00:00 | 354 | 701
2022-08-03 00:00:00 | 702 | 100
2022-08-04 00:00:00 | 101 | 369
2022-08-04 00:00:00 | 370 | 748
2022-08-05 00:00:00 | 749 | 10
2022-08-05 00:00:00 | 11 | 301
2022-08-08 00:00:00 | 302 | 599
2022-08-08 00:00:00 | 600 | 999
Spreadsheet: 686035d1594318744-copy-cells-based-of-certain-text-or-blanks-spaces-excel-help-sample-file
Sheet: Sheet1

 | Current
Workflow # | Outline # | Phase | Milestones | Tasks | Events
Phase 2 | 2 | Phase 2 |  |  | Planning
2.01 | 2.1 |  |  |  | PIR Adoption
 | 2.1.1 |  |  |  | Submit PIR to FRC
Goal- Copy F3 to D2 and F3 to D3 (typical for a table containing 150 rows)
All F3 types cells are different because they have 6 blank spaces before the text, and outline numbers are x.x (2 digits)
All F4 types cells are different because they have 9 blank spaces before the text, and outline numbers are x.x.x (3 digits)
 | Goal
Workflow # | Outline # | Phase | Milestones | Tasks | Events
Phase 2 | 2 | Planning |  |  | Planning
2.01 | 2.1 |  | PIR Adoption |  | PIR Adoption
 | 2.1.1 |  |  | Submit PIR to FRC | Submit PIR to FRC
Spreadsheet: 327706d1403648572-sum-with-multiple-date-criteria-sample-loan-exposure
Sheet: Sheet2

 | Issue Date | [NAME] | Amount
 | 2014-05-22 00:00:00 | 2014-06-08 00:00:00 | 1500000
 | 2014-05-29 00:00:00 | 2014-06-15 00:00:00 | 2500000
 | 2014-06-03 00:00:00 | 2014-07-04 00:00:00 | 6750000
 | 2014-06-09 00:00:00 | 2014-06-15 00:00:00 | 5000000
 | 2014-06-15 00:00:00 | 2014-06-22 00:00:00 | 3500000
 | 2014-06-15 00:00:00 | 2014-07-15 00:00:00 | 1750000
 | 2014-06-22 00:00:00 | 2014-07-25 00:00:00 | 8000000
 |  | Measure Date | Total
 |  | 2014-06-01 00:00:00 |  | <<
 |  |  |  |  | etc
 |  |  |  |  | etc
 |  |  |  |  | etc
Spreadsheet: 95038d1294750250-vlookup-and-return-value-from-a-range-of-results-excel-example
Sheet: REFERENCE

CUSTOMER ID | MEMBERSHIP LEVEL | MEMBERSHIP EXPIRY
3000296335 | EVI_BUS24 | 2008-12-11 00:00:00
3000296335 | EVI_BUSTR | 2010-12-31 00:00:00
3000296335 | EVI_09_E_P | 9999-12-31 00:00:00
3000521376 | EVIOB10DAY | 9999-12-31 00:00:00
3000790344 | GVI_10DAY | 2008-08-17 00:00:00
3000790344 | GVI_08_DOM | 2009-02-19 00:00:00
3000790344 | GVI_09_DOM | 2009-06-27 00:00:00
3000790344 | GVI_GDOM | 9999-12-31 00:00:00
3001143986 | EVI_HOME | 2009-02-19 00:00:00
3001143986 | EVI_09_HOM | 9999-12-31 00:00:00
3001416764 | [NAME] | 2009-04-30 00:00:00
3001416764 | EVI_09_DHP | 9999-12-31 00:00:00
Spreadsheet: 792688d1661079965-need-to-flatten-many-column-ranges-into-one-row-easily-2022-08-21-oeldere-codyg-excel_forum_flatten_problem_sample
Sheet: Tabel1

Name | Value
[NAME] | Pancakes
[NAME] | Eggs
[NAME] | Cereal
[NAME] | Sandwich
[NAME] | Hamburger
[NAME] | Sandwich
[NAME] | Porkchops
[NAME] | Pasta
[NAME] | Chicken
Spreadsheet: tracy_geaccone__40277__Non recurring Q3 2001-asset sales
Sheet: IASA

[NAME] (IASA)
Pro Forma Loss Calculation
(In millions of US$)
Cash Consideration Received |  |  |  |  |  | 10 |  | 141.5
Less Transaction Costs (estimated) |  |  |  |  |  | -0.5 |  | -3
Outcome of Consideration placed in Escrow |  |  |  |  |  | 0 |  | -10
Net Consideration Received
Cost Basis:
 | Azurix's Equity Investment at 7/31/01 |  |  | 6.6
 | Loans to [NAME] to be contributed at closing |  |  | 20.6
 | Additional funds to be invested or loaned to Azurix
 | Mexico 8/1/01 - closing date |  |  | 0
 | Intercompany net receivables from Azurix Mexico to be
 | contributed at closing |  |  | 2.3 |  | (a)
 | Equity earnings/(loss) from 8/1/01 - closing date |  |  | 0
Total Cost Basis
Working Capital Adjustment |  |  |  |  |  | 0 |  | 0
Debt Adjustment |  |  |  |  |  | 0
Pre-Tax Loss
Tax Loss on 338H-10 Election (estimated) |  |  |  |  |  | 0 |  | 28.2
Pro Forma Azurix Loss on Sale
(a) - Assumes that $0.4mm A/R from [NAME] is paid prior to closing.
Spreadsheet: 92374d1291935594-is-it-possible-to-add-cells-summing-from-the-bottom-upwards-in-a-column-reverse-and-sum
Sheet: Sheet1

 | RESULT | LIMIT | reverse column | sum
4 | 24 | 29 | 7 | 7
5 |  |  | 6 | 13
6 |  |  | 5 | 18
7 |  |  | 4 | 22
8 |  |  | 2 | 24
9 |  |  | 9
2 |  |  | 8
4 |  |  | 7
5 |  |  | 6
6 |  |  | 5
7 |  |  | 4
Spreadsheet: 9c6d2960-3a72-4dde-90c0-978afff660aa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3801 | 16940 | Annamaria | Halasz | HUN | 155 | 00:38:44 | 00:00:32 | 01:09:14 | 00:00:36 | [NAME] | 1 | 02:08:46
3801 | 12425 | [NAME] | Kelly | GBR | 154 | 00:37:59 | 00:00:32 | 01:12:10 | 00:00:43 | 00:20:01 | 2 | 02:11:24
3801 | 17208 | Keira-Eva | Mooney | IRL | 156 | 00:39:18 | 00:00:35 | 01:10:59 | 00:00:31 | 00:20:38 | 3 | 02:12:01
3801 | 23142 | [NAME] | Bent | GBR | 153 | 00:48:57 | 00:01:20 | 01:18:29 | [NAME] | 00:26:48 | 4 | 02:36:27
Spreadsheet: 188442d1350893962-sum-a-range-based-on-criteria-sum
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Revenue Actual | 10000
Sum to | Oct
Revenue |  | This needs to be arrived at using formula based on the month entered in B4.
Spreadsheet: 17a1f341-6960-446f-a90b-36b5d1e03efe
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688663520 | Worship Tracks | Wonderful, Merciful Savior ([NAME]:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688662721 | Worship Tracks | Worthy Is The Lamb (Ampb:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688662325 | Worship Tracks | How Great Is Our God ([NAME]:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688664725 | Worship Tracks | In Christ Alone (My Hope Is Found)(Ampb:  [NAME]/[NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688664428 | Worship Tracks | How Deep The Father'S Love | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688684624 | Worship Tracks | Days Of Elijah (Ampb:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688674229 | Worship Tracks | Breathe ([NAME]:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688674922 | Worship Tracks | Open The Eyes Of My Heart ([NAME]:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688674823 | Worship Tracks | Here I Am To Worship (Ampb:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688674724 | Worship Tracks | Heart Of Worship, The  (Ampb:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688675127 | Worship Tracks | Shout To The Lord (Ampb:  [NAME]) | 2006-07-11 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80688712921 | Worship Tracks | At The Cross ([NAME]:  [NAME]) | 2007-02-06 | Worship Trax | Na | 8.99 | Y | Available
Word Records | 80689084829 | Worship Tracks | You Are My King (Amazing Love) (Ampb:  Newsboys/Newsong) | 2003-12-06 | Worship Trax | Na | 8.99 | Y | Available
Spreadsheet: mary_fischer__25603__34ftax_info
Sheet: Sheet1

 | Total GSA Revenue - July 2001 |  |  | Allocation |  | Total GSA Revenue - Year 2000 |  | Allocation
Massachusetts | -334861.4
Rhode Island | -96024.19
Totals |  |  |  |  |  | -16263807.21
 | -18798962.61 |  | Total revenue for 2000
 |  |  | Ft. [NAME]/Long Island, NY - (-211262x12 mths)
 |  |  | Total GSA revenue for 2000
** July GSA invoices were used to determine the allocation in order to apportion year 2000 by state **
Spreadsheet: 765879d1643648405-help-with-allocation-formula-excel-formula-help-1-31-22
Sheet: Sheet1

Customer | Item 1 2020 Units | Item 1 2021 Units | Item 1 Unit [NAME] | Current Allocation | [NAME] every 45 Days | Round to Carton | Addt. 45 Day Allocated | Item 1 Preliminary Allocation Bucket (every 45 days) | Allocation Recommendation | Final Allocation
Customer 1 | 300000 | 148000 | -152000 | 4800 |  | -18800 | 18800 |  | 14400 | 14400
Customer 2 |  | 600 |  | 4800 |  | 0 | 0 | 4800 |  | 1200
Customer 3 | 49000 |  | -49000 | 4800 |  | -6100 | 6100 |  | NO SALES 2021 | 1200
Customer 4 |  |  |  | 4800
Customer 5 | 18000 | 51500 |  | 4800 |  | 4100 |  |  |  | 1200 | 1200
I need to calculate a Final Allocation number for approximately 300 different items.
Customer can only order every 45 calendar days
Each item has a different allocation.  Clients can currently order 4800 pieces of Item 1 every 45 calendar days
I need help with a formula for figuring a FINAL ALLOCATION number based on the following rules:
ALLOCATION RULES:
I NEED TO CAP THE FINAL ALLOCATION (Customer 1 example) | Allocation cap per item no more than 3 times Current Allocation for that item.  Any number in the PRELIMINARY ALLOCATION BUCKET that is higher than 3 times the Current Allocation defaults to that number.  In this case, (4800 * 3) is 14,400.  If the prelininary allocation bucket is over 14,400, this would be the final allocation number.
ALLOCATE 25% (Customer 2 example) | If no item was purchased in 2020 but was purchased in 2021, allocated amount for that item is 25% of Current allocation (4,800/4)
ALLOCATE 25% (Customer 3 example) | If no item was purchased in 2021 but was purchased in 2020, allocated amount for that item is 25% of Current Allocation (4,800/4)
ALLOCATE 25% (Customer 4 example) | If no item was purchased in 2020 or 2021, allocated amount for that item is 25% of Current Allocation (NO 2020 or 2021 sales = 25% of Current Allocation)
ALLOCATE 25% (Customer 5 example) | Any item that is at or below 25% in the PRELIMINARY ALLOCATION BUCKET defaults FINAL ALLOCATION to 25% of published allocation
Spreadsheet: 775029d1648779356-comparing-data-an-alternative
Sheet: Data

Facility | Name | Contact Date | Using/Not Using |  |  |  |  | Not Using | HAR |  | LEX |  | LOU |  | PAD
HAR | Provider1 | 2022-01-24 00:00:00 | Using |  | Expected Results
HAR | Provider1 | 2022-02-14 00:00:00 | Not Using |  | HAR
HAR | Provider2 | 2021-12-31 00:00:00 | Using |  | Provider2
HAR | Provider3 | 2021-12-31 00:00:00 | Using |  | Provider4
LEX | Provider3 | 2022-01-07 00:00:00 | Not Using |  | Provider8
HAR | Provider4 | 2021-12-31 00:00:00 | Using |  | LEX
LOU | Provider4 | 2021-12-31 00:00:00 | Using |  | Provider6
HAR | Provider4 | 2022-03-15 00:00:00 | Using |  | LOU
LEX | Provider5 | 2022-01-10 00:00:00 | Not Using |  | Provider7
LEX | Provider6 | 2021-12-31 00:00:00 | Using |  | Provider10
LEX | Provider6 | 2022-01-28 00:00:00 | Using |  | PAD
LOU | Provider7 | 2021-12-31 00:00:00 | Using |  | Provider12
LOU | Provider7 | 2022-01-07 00:00:00 | Using
HAR | Provider8 | 2022-01-17 00:00:00 | Using
LEX | Provider9 | 2022-01-28 00:00:00 | Using
LEX | Provider9 | 2022-02-21 00:00:00 | Not Using
LOU | Provider10 | 2021-12-31 00:00:00 | Using
LEX | Provider11 | 2022-01-07 00:00:00 | Not Using
PAD | Provider12 | 2021-12-31 00:00:00 | Using
LEX | Provider13 | 2022-01-21 00:00:00 | Not Using
HAR | [NAME] | 2022-03-31 00:00:00 | Not Using
Spreadsheet: 771746d1646829415-what-function-to-use-to-show-a-value-based-on-drop-down-list-test
Sheet: Sheet1

USD Rate: | 22.02
Hour Rate: | 22
ManDay Rate
CAPEX category | Item | Unit type | no. of units | Price per unint | Pcs Price | Cost
 |  | Hrs | 10
 |  | MD | 10
 |  | Pcs | 10 |  | 5
Spreadsheet: 705581d1606205665-employee-monthly-salary-increased-on-their-anniversary-date-accounting
Sheet: Tech Stack Contracts >$5k

 | Budget Template
 | Department:
 | Software Contracts > $5,000
 | Instructions - Please update this tab for software and tools contracts over $5,000. This will help provide a consolidated list of material tools and software the company utilizes to help better forecast for the year.
 | # | Tool/Software Name | [NAME] | Contract Renewal Date | Contract Duration | Cost Structure (i.e. How is Pricing Determined)
 | 1 | Tool 1
 | 2 | Tool 2
 | 3 | Tool 3
 | 4 | Tool 4
 | 5 | Tool 5
 | 6 | Tool 6
 | 7 | Tool 7
 | 8 | Tool 8
 | 9 | Tool 9
 | 10 | Tool 10
 | 11 | Tool 11
 | 12 | Tool 12
 | 13 | Tool 13
 | 14 | Tool 14
 | 15 | Tool 15
Spreadsheet: 2225e541-4ba0-4578-9e59-32f7ac445a11
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
09/03/2011 | Women's Cross Country | at Maryland Eastern Shore Lid-Lifter Invitational | 12:00 AM | 2nd Place
09/23/2011 | Women's Cross Country | at Inter-Regional Bubble Buster | 12:00 AM | 2nd Place
10/01/2011 | Women's Cross Country | at Greater Louisville Cross Country Classic | 12:00 AM | 8th Place
10/14/2011 | Women's Cross Country | at Penn State National | 12:00 AM | 1st Place
10/29/2011 | Women's Cross Country | BIG EAST Championship (Louisville, Ky.) | 12:00 AM | 4th Place
11/12/2011 | Women's Cross Country | NCAA Mid-Atlantic Regional (Princess Anne, Md.) | 12:00 AM | 3rd Place
11/21/2011 | Women's Cross Country | NCAA Championship (Terre Haute, Ind.) | 12:00 AM | 8th Place
Spreadsheet: 286100d1388067372-allocation-of-data-to-staff-with-certain-criteria-test-file
Sheet: Staff and Criteria of allocatio

Name | Collection Dept. | Product | Bucket | Accounts to be assigned | Product
[NAME] | In House | STL | 1 – 29 DPD | 166 | STL
[NAME] | In House | STL | 1 – 29 DPD | 165 | STL
[NAME] [NAME] | In House | STL | 30 - 239 DPD | 110 | STL
[NAME] [NAME] | In House | STL | 30 - 239 DPD | 111 | STL
Hamod Fahad Aldosari | Field | STL W/O | 270 + | 68 | STL
[NAME] [NAME] | Field | STL W/O | 270 + | 68 | STL
[NAME] | Field | STL W/O | 270 + | 68 | STL
[NAME] | In House | NSTL | 1 - 29 DPD | 145 | NSTL
[NAME] | In House | NSTL | 1 - 29 DPD | 146 | NSTL
[NAME] | In House | NSTL | 1 - 29 DPD | 146 | NSTL
[NAME] | In House | NSTL | 30 – 89 DPD | 140 | NSTL
[NAME] | In House | NSTL | 30 – 89 DPD | 140 | NSTL
[NAME] | In House | NSTL | 90 – 269 DPD | 75 | NSTL
[NAME] | In House | NSTL | 90 – 269 DPD | 76 | NSTL
[NAME] | In House | NSTL | 90 – 269 DPD | 76 | NSTL
[NAME] A Sliman | Field | NSTL W/O | 270 + | 71 | NSTL
[NAME] | Field | NSTL W/O | 270 + | 71 | NSTL
[NAME] Alotaibi | Field | NSTL W/O | 270 + | 72 | NSTL
Fahad Easa Khamis Alanazi | Field | Self Employed | g_150 - 179 | 81 | Self Employed
[NAME] | Field | Self Employed | f_120 - 149 | 81 | Self Employed
[NAME] | Field | Self Employed | h_180 - 209 | 82 | Self Employed
Abdulaziz Al Amary | In House | Self Employed | 1 - 59 DPD | 87 | Self Employed
[NAME] | In House | Self Employed | 1 - 59 DPD | 87 | Self Employed
[NAME] | In House | Vehicle | 1 - 29 DPD | 167 | Auto
[NAME] | In House | Vehicle | 1 - 29 DPD | 168 | Auto
[NAME] | In House | Vehicle | 30 - 239 DPD | 104 | Auto
Spreadsheet: 49725d1249046134-vlookup-401-ded-worksheet-upload
Sheet: Export

1 | Doe, [NAME] | 231548649 | R-F | 1000
2 | [NAME], [NAME] | Fixed | GA-F | 2000
4 | [NAME], [NAME] | Percent | NASH-F | 2000
6 | Thompson, Jake | Percent | NASH-O | 1000
7 | Garner, [NAME] | Fixed | M-F | 800
8 | Holland, Maria | Fixed | M-F | 800
9 | Graft, Scott | Fixed | M-F | 600
10 | Topper, [NAME] | No Contribution | SD-F | 0
11 | [NAME], [NAME] | Percent | LOUIS-F | 200
12 | Trully, [NAME] | Fixed | CORP | 800
13 | Fanta, [NAME] | Percent | D-O | 600
14 | Shelton, [NAME] | Percent | UDS | 1000
15 | Edwards, [NAME] | Percent | R-O | 800
16 | Earhardt, Dale | Fixed | M-F | 800
17 | [NAME], [NAME] | Fixed | M-F | 800
18 | Frontal, [NAME] | Percent | M-F | 480
19 | Edon, [NAME] | Fixed | AL-O | 320
20 | [NAME], [NAME] | Fixed | CORP | 1200
21 | Bing, [NAME] | Fixed | CORP | 1280
22 | [NAME], [NAME] | Percent | CORP | 1923.2
23 | [NAME], [NAME] | Percent | CORP | 600
24
25
26
27
28
29
30
Spreadsheet: 355694d1414761963-copy-pivot-table-to-another-sheet-copy-pivot-to-sheet
Sheet: Sheet1

Site Code | Address | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00
827 | Location1 |  | 2 | 2 |  |  | 1
1041 | Location2 |  |  | 1 |  | 1
1118 | Location3 | 3 |  | 2 | 1 | 1 | 2
2002 | Location4 |  |  |  | 2 | 1 | 1
2003 | Location5 |  | 3 | 2 | 4 | 4 | 5
2004 | Location6 | 2 | 3 | 1 |  | 1 | 1
2005 | [NAME] | 2 | 2 | 3 | 1 | 1 | 3 | 1
2013 | Location8 | 2 | 5 |  | 2 | 2 | 7 | 1
2014 | Location9 | 2 | 1
2015 | Location10 |  |  | 2 |  |  |  | 1
2017 | Location11 | 1
2031 | Location12 |  |  | 1
2043 | Location13 | 1 | 1 | 2 |  | 1 | 1 | 2
2054 | Location14 | 2 | 1 | 2 | 3 |  | 1 | 1
2056 | Location15 | 3 | 3 | 5 | 2 | 2 |  | 1
2066 | Location16 |  |  |  | 2 | 1
2068 | Location17 |  | 1
2069 | Location18 | 2 | 1 |  | 1 |  | 2 | 1
2070 | Location19 |  |  | 1
2071 | Location20 |  |  | 2 | 1 |  | 1
2072 | Location21 | 1 |  |  |  |  | 1
2074 | [NAME] | 1 | 1 | 3 | 2 |  | 1
2078 | Location23 | 3 | 1 | 1 | 3 | 1 | 2 | 1
2080 | Location24 |  | 1
2084 | Location25 |  |  |  | 1
2085 | Location26 | 3 | 4 | 3 | 3 | 2 | 3 | 1
Spreadsheet: 847571d1698423801-help-with-adding-an-additional-criteria-to-filter-filter
Sheet: Sheet1

Date | 2023-10-26 00:00:00
 |  |  |  | Colour | Date | Cost
 | Number Plate |  |  | Blue | 2023-10-20 00:00:00 | 101
Filter |  |  |  | Red | 2023-10-20 00:00:00 | 24
 | 45 |  |  | Red | 2023-10-19 00:00:00 | 63
 |  |  |  | Blue | 2023-10-20 00:00:00 | 152.9
 |  |  |  | Blue | 2023-10-18 00:00:00 | -40.93
 |  |  |  | Blue | 2023-10-19 00:00:00 | -408.69
 |  |  |  | Blue | 2023-10-26 00:00:00 | 1200
 |  |  |  | Blue | 2023-10-20 00:00:00 | -86.14
 |  |  |  | Blue | 2023-10-23 00:00:00 | -129.77
 |  |  |  | Red | 2023-10-31 00:00:00 | -423.8
 |  |  |  | Blue | 2023-11-02 00:00:00 | 158
 |  |  |  | Blue | 2023-09-20 00:00:00 | 53.21
 |  |  |  | Red | 2023-11-04 00:00:00 | 100
 |  |  |  | Blue | 2023-10-26 00:00:00 | 45