tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 762494d1641577433-dynamic-sort-function-for-data-entries-eh-ss-db_v3
Sheet: Team_Dashboard

 | 1. Filter by manager
 |  |  |  |  |  |  | Number of Client Projects by month |  |  |  | Holidays this month
 |  |  | Total Client Projects |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Projects completed |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Projects 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Client Calls |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Calls completed |  | COUNT TOTAL CLIENT CALLS (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Calls 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Training Days |  | COUNT TOTAL holiday (column b)
 |  |  | Total Holidays |  | COUNT TOTAL training (column b)
 | 2. Filter by month
 | 3. Filter by Client
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Team Information
 |  |  | Client Name
 |  |  | Total number of Client Calls |  | Total number of Client Proects
 |  |  | Average number of Client Calls |  | Total number of Client Projects
 |  |  | Not started |  | Average number of Client Projects
 |  |  | On hold |  | Not started
 |  |  | In progress |  | On hold
 |  |  | Completed |  | In progress
 |  |  | Time spent on Client Calls |  | Completed
 |  |  |  |  | Time spent on Client Projects
Spreadsheet: 676133d1588673364-how-to-move-few-columns-below-another-set-of-columns-query
Sheet: Sheet1

col1 | [NAME] | col3 | col4 | col5 | col6
1 | 2 | 3 | 4 | 5 | 6
11 | 12 | 13 | 14 | 15 | 16
21 | 22 | 23 | 24 | 25 | 26
31 | 32 | 33 | 34 | 35 | 36
col7 | [NAME] | col9 | col10 | colx | coly
7 | 8 | 9 | 10 | x1 | y1
17 | 18 | 19 | 20 | x2 | y2
27 | 28 | 29 | 30 | [NAME] | y3 |  |  |  |  | Result
37 | 38 | 39 | 40 | x4 | y4
 |  |  |  |  |  |  |  |  |  | col1 | [NAME] | col3
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3
 |  |  |  |  |  |  |  |  |  | 11 | 12 | 13
 |  |  |  |  |  |  |  |  |  | 21 | 22 | 23
 |  |  |  |  |  |  |  |  |  | 31 | 32 | 33
 |  |  |  |  |  |  |  |  |  | col4 | col5 | col6
 |  |  |  |  |  |  |  |  |  | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  | 14 | 15 | 16
 |  |  |  |  |  |  |  |  |  | 24 | 25 | 26
 |  |  |  |  |  |  |  |  |  | 34 | 35 | 36
 |  |  |  |  |  |  |  |  |  | col7 | [NAME] | col9
 |  |  |  |  |  |  |  |  |  | 7 | 8 | 9
 |  |  |  |  |  |  |  |  |  | 17 | 18 | 19
 |  |  |  |  |  |  |  |  |  | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  | 37 | 38 | 39
 |  |  |  |  |  |  |  |  |  | col10 | colx | coly
 |  |  |  |  |  |  |  |  |  | 10 | x1 | y1
 |  |  |  |  |  |  |  |  |  | 20 | x2 | y2
 |  |  |  |  |  |  |  |  |  | 30 | [NAME] | y3
 |  |  |  |  |  |  |  |  |  | 40 | x4 | y4
Spreadsheet: 64907d1265729620-look-up-and-match-several-values-to-include-entry-sample_worksheet
Sheet: Sheet1

Company | Quarter | Year | Industry | Lookup
Company B | Q1 | 2009 | Administration
Company D | Q2 | 2009 | Transportation and logistics
Company C | Q3 | 2009 | Production
Company A | Q1 | 2009 | Administration
Company A | Q2 | 2009 | Administration
Company A | Q3 | 2009 | Administration
Company A | Q4 | 2009 | Administration
Company B | Q2 | 2010 | Construction
Company C | Q4 | 2010 | Health
Only valid entries in the above list are:
Company A | Q1 | 2009 | Administration | OK
Company A | Q2 | 2009 | Administration | OK
Company A | Q3 | 2009 | Administration | OK
Company A | Q4 | 2009 | Administration | OK
Spreadsheet: 136638d1326752663-auto-populate-work-order-forms-from-different-sheet-example
Sheet: Existing Work order

Date Called: |  |  |  |  |  |  | Time: |  |  |  |  | Designated Employee: |  |  |  |  | Report Provided: (circle one)                                       YES - Attach Copy           NO - Fill In Scope of Work |  |  |  |  |  | Date Called | Time | Employee | Report Provided
. |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  | . | . | . | .
Return Call By (circle one): |  |  |  |  |  |  |  |  |  |  |  | Appt. [NAME]?:           YES    NO |  |  | Service Date: |  |  |  |  | Time: |  |  | Service Date | Time | Return Call by
. |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | . |  |  |  |  | . |  |  | . | . | .
Company: |  |  |  |  |  |  |  |  |  |  |  | Hours of Operation: |  |  |  |  |  | Days of Operation: |  |  |  |  | Lookup Number
#N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  | #N/A |  |  |  |  | AUG002
Contact: |  |  |  |  |  |  |  |  |  |  |  | Acct# |  |  |  |  | Acct. Status: CHARGE     COD |  |  | PO# [NAME]?           YES - Fill In PO#   NO
#N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  | #N/A |  |  | #N/A
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | PO# |  |  |  |  |  |  | Payment Type:                                           VISA   M/C   CASH   CHEQ
#N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  | #N/A
City: |  |  |  |  |  | Province: |  |  | Postal: |  |  | Card Number: |  |  |  |  |  |  |  | EXP:
#N/A |  |  |  |  |  | #N/A |  |  | #N/A |  |  | #N/A |  |  |  |  |  |  |  | #N/A
Phone: |  |  |  |  |  | Cell: |  |  |  |  |  | Job Number (If [NAME]):
#N/A |  |  |  |  |  | #N/A |  |  |  |  |  | #N/A
Fax: |  |  |  |  |  | E-Mail: |  |  |  |  |  | Jobsite Address (if different from billing address):
#N/A |  |  |  |  |  | #N/A |  |  |  |  |  | #N/A
Alternate Contact: |  |  |  |  |  | Phone: |  |  |  |  |  | City Section
#N/A |  |  |  |  |  | #N/A |  |  |  |  |  | #N/A
Information/Message/Scope of Work:
#N/A
Spreadsheet: 96362d1295779478-excel-2007-pivot-group-dates-groupdates
Sheet: report

 | Asset No. | Description | type | Purchase cost | 2010 | 2011 | 2012 | 2013 | 2014 | 2015
 | 100001 | CONX SAFE | Machines | 1315
 | 100002 | HEDGE TRIMMER | Machines
 | 100003 | SOUND LEVEL METER | Machines
 | 100004 | TORO RECYCLER MOWER | Machines
 | 100005 | TORO RECYCLER MOWER | Machines
 | 100006 | TORO RECYCLER MOWER | Machines
 | 100007 | SINGLE HEDGE TRIMMER | Machines
 | 100008 | SINGLE HEDGE TRIMMER | Machines
 | 100009 | SINGLE HEDGE TRIMMER | Machines
 | 100010 | HEAVY STRING TRIMMER | Machines
 | 100011 | HEAVY STRING TRIMMER | Machines
 | 100012 | HEAVY STRING TRIMMER | Machines
 | 100013 | STICK EDGER | Machines
 | 100014 | TORO RECYCLER MOWER | Machines
 | 100015 | TORO RECYCLER MOWER | Machines
 | 100016 | BACK PACK BLOWER | Machines
 | 100017 | BACK PACK BLOWER | Machines
 | 100018 | BACK PACK BLOWER | Machines
 | 100019 | GARDEN MID MOUNTED | Machines
 | 100020 | PORTABLE APPLIANCE | Machines
 | 100021 | STHIL EDGE TRIMMER | Machines
 | 100022 | STICK EDGER | Machines
 | 100023 | STICK EDGER | Machines
 | 200001 | BLINDS & CURTAINS | Furniture
 | 200002 | BOOKCASE CREATIVE SP | Furniture
 | 200003 | MANSION 6 [NAME] | Furniture
 | 200004 | CHAIR FOR RE OFFICE | Furniture
 | 200005 | CARPET-200 X 290 CM | Furniture
 | 200006 | FILING CABENETS | Furniture
 | 300002 | CLUB CAR VILLAGER 6 | Cars | 42264
 | 300003 | CLUB CAR-CARRYALL 2 | Cars | 35287.50000000002
 | 300004 | CLUB CAR-CARRYALL2 | Cars | 35287.50000000002
 | 300005 | CLUB CAR-CARRYALL 2 | Cars | 35287.50000000002
 | 600001 | PRINTER LASER JET | Computers | 4999.58333333333
 | 600002 | SCANNER - FUJITSU | Computers | 1895.000000000001
 | 600003 | PRINTER COLOUR LASER | Computers | 7500.000000000007
 | 600004 | CHEQUE PRITNER-EPSON | Computers | 1308.888888888888
 | 600005 | OPERA EXPRESS | Computers | 46558.66666666668
 | 600006 | LAPTOP RE OFFICE | Computers | 6620.833333333328
 | 600007 | SAGE SOFTWARE - CS3 | Computers | 9036.444444444434
Spreadsheet: 851990d1702093556-critical-items-transfer-critical-item-transfer-bvj-
Sheet: Feuil1

 |  |  | Item
 |  | Critical Items List
 |  | Normal List | Oranges
 |  |  | apples
 |  |  | shoes | Yes
 |  |  | tables
 |  |  | desks
 |  |  | chairs
 |  |  | radios | Yes
 |  |  | hearphones
 |  |  | phones
 |  |  | dronees
 |  |  | cameras
 |  |  | mice
 |  |  | pens
 |  |  | mugs
 |  |  | spoons
 |  |  | forks
 |  |  | tissues
 |  |  | notebooks
 |  |  | computers
 |  |  | bottles
Spreadsheet: df8c58c5-c523-4b62-b516-0e5bcdd6f259
Sheet: divisions

Voter | AFC East | AFC North | AFC South | AFC West | NFC East | NFC North | NFC South | NFC West | Average (should equal 16.5)
[NAME] | 18.25 | 16 | 21.5 | 19.5 | 13.25 | 14.5 | 16.75 | 12.25 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 17.25 | 15.75 | 21.5 | 19.75 | 13.25 | 13.5 | 16.5 | 14.5 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 17.75 | 16.5 | 23 | 18.75 | 10.5 | 13.75 | 16.75 | 15 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 18.5 | 15.5 | 22 | 20.25 | 12 | 14.25 | 16.75 | 12.75 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 17 | 17 | 22.25 | 17.75 | 12 | 15.75 | 16.75 | 13.5 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Average | 17.75 | 16.15 | 22.05 | 19.2 | 12.2 | 14.35 | 16.7 | 13.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rank | 6 | 4 | 8 | 7 | 1 | 3 | 5 | 2
Spreadsheet: 138436d1327660029-stock-list-calculation-problem-a2701
Sheet: Quick View

 |  | Used | Delivered
Salt's | AS140 (25kg bags) | 150 | 0
 | GS430 (25kg bags)
 | [NAME] (25kg bags)
 | NS450 (50kg drums)
 | [NAME] (Sulf S) (25kg bags)
 | Cecontrol (Black Tablets) (50kg drums)
 | C80B (Salt) (25kg bags)
 | Economiser (25kg bags)
 | Regenerator (25kg bags)
 | Pyruma (25kg bags)
Bag's | Plain polythene bags
T/C's | [NAME] bath
 | GHT2 AL, AC & TH
 | GHT4 S N/R
 | [NAME]/SAT
 | [NAME] tank T/Cs
Wire | 1.2 mm (25kg Bales)
 | 2.0 mm (Formers)
 | 3.2 mm (Formers)
Pot's | [NAME] pot
 | 48x24x24 pot
 | Large QS pot
Oil's, Detergent's, etc, etc | [NAME] (quench oil) (205ltr Drum)
 | Dascosol 102 (suds oil) (205ltr Drum)
 | Vapor-tek Steelguard (PX24) (210ltr Drum)
 | Detergent (205ltr Drum)
 | Inhib, Hydrochloric Acid (25ltr Drum)
Spreadsheet: 875115d1721677392-9-box-help-speedking57-9-box-talent-assessment-corporate
Sheet: Assessment

Talent Profile
Team Member Name | [NAME] | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10 | Name 10
Current Location | Home Office - STL
Current Role
Time In Role | 3-5 years
Possible Next Role
Readiness for Next Role | Now
Geographic Mobility | Remote Corp Role
Risk of Leaving | High
Impact of Loss | Low
Possible Successor | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name | Input Name
Evaluation of Performance
Most Recent Performance Rating | Exceeds
Performance
Evaluation of Potential
Achievement Oriented - invested in the success of the themselves, others, and the business
Shows resilience when overcoming challenges and roadblocks | Always
Sets high standards for self and others | Always
Keeps business priorities and success top of mind | Always
Team Oriented - Invested in the growth and development of others
Provides engaging and empowering development opportunities and feedback | Always
Shares business knowledge and best practices to support the team's success | Always
Invests their time and energy into the growth and development of others | Always
Self-Oriented - Invested in the growth and development of themselves
Seeks feedback and input from others and takes action to improve | Always
Uses challenges and risk taking as learning opportunities for improving work strategies | Rarely
Demonstrates career ambition by seeking learning opportunities and developmental moves | Sometimes
Influencing Others - natural ability to inspire and motivate others toward action
Is unafraid to communicate and address issues openly and honestly | Often
Communicates and drives vision by creating a shared mindset | Often
Builds commitment around vision and inspires and energizes the team around it | Always
Agility - acts quickly when solving problems and adapts easily in the moment
Demonstrates flexibility when dealing with complex challenges or new problems | Sometimes
Solves problems quickly using business knowledge and past experiences | Never
Quickly corrects course and recognizes best path forward, even under pressure | Sometimes
Potential
Overall Comments
Spreadsheet: 784960d1656038734-if-than-statement-with-2-criteria-car3
Sheet: Sheet3

Name | Ford | Chevy | Honda | Nissan | Kia |  | Return Value
[NAME] | 1 |  |  |  |  |  |  | If B2 is equal to 1 AND C2, D2,E2, or F2 have values of 1, then return A2. Otherwise leave blank
Fred | 1 | 1 | 1 | 1 | 1 |  | Fred | If [NAME] is equal to 1 AND C3, D3,E3, or F3 have values of 1, then return A3. Otherwise leave blank
[NAME] | 1 |  | 1 |  | 1 |  | [NAME] | If B4 is equal to 1 AND C4, D4,E4, or F4 have values of 1, then return A4. Otherwise leave blank
[NAME] | 1 | 1 |  |  |  |  | [NAME] | If [NAME] is equal to 1 AND C5, D5,E5, or F5 have values of 1, then return A5. Otherwise leave blank
Kelly |  |  | 1 |  |  |  |  | If [NAME] is equal to 1 AND C6, D6,E6, or F6 have values of 1, then return A6. Otherwise leave blank
Candace | 1 |  |  | 1 |  |  | Candace | If [NAME] is equal to 1 AND C7, D7,E7, or F7 have values of 1, then return A7. Otherwise leave blank
Spreadsheet: 847859d1698692741-formula-to-capture-attendance-login-shift-adherence
Sheet: Attendance (Shift Adherence)

 |  |  |  | Expected Results
Date | Agent Name | Agent ID | Shift Start Time | [NAME] | Last Logout Time | Attendance | Delayed By | Total [NAME]
2023-09-27 00:00:00 | A | 1234 | 10:00:00 | 10:20:00 | 20:32:00 | Delayed Login
2023-09-27 00:00:00 | B | 4567 | 12:00:00 | 12:07:00 | 19:11:00 | Delayed Login
2023-09-27 00:00:00 | C | 2345 | 17:30:00 | 17:41:00 | 19:15:00 | Delayed Login
2023-09-27 00:00:00 | D | 6789 | 10:30:00 | 10:24:00 | 20:42:00 | On Time Login | -
2023-09-27 00:00:00 | E | 1000 | 11:00:00 | 10:28:00 | 22:44:00 | On Time Login | -
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 10b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, July 26 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 02873dc7-2039-44b4-b698-cdcbbf1334db
Sheet: Sheet1

West Virginia State University
STUDENT EMPLOYEES
PAYROLL TIME AND ATTENDANCE SHEET
DEPARTMENT NAME: |  |  |  |  |  |  |  |  |  | BANNER NUMBER: |  |  | ____________ - ____________ - ____________
NAME: |  |  |  |  |  |  |  |  |  | SOCIAL SECURITY NUMBER:    ________ -________ - ________
WORK PERIOD: |  |  |  |  |  |  |  |  |  | EMPLOYEE NUMBER:
PLEASE REPORT TIME TO THE NEAREST QUARTER HOUR |  |  |  |  |  |  |  |  |  |  |  | THIS FORM MUST BE COMPLETED IN INK
 | START | TIME | TIME | TIME | TIME | TIME | TOTAL |  |  |  | START | TIME | TIME | TIME | TIME | TIME | TOTAL
DAY | TIME | OUT | IN | OUT | IN | QUIT | HOURS | COMMENTS |  | DAY | TIME | OUT | IN | OUT | IN | QUIT | HOURS
11 |  |  |  |  |  |  |  |  |  | 26
12 |  |  |  |  |  |  |  |  |  | 27
13 |  |  |  |  |  |  |  |  |  | 28
14 |  |  |  |  |  |  |  |  |  | 29
15 |  |  |  |  |  |  |  |  |  | 30
16 |  |  |  |  |  |  |  |  |  | 31
17 |  |  |  |  |  |  |  |  |  | 1
18 |  |  |  |  |  |  |  |  |  | 2
19 |  |  |  |  |  |  |  |  |  | 3
20 |  |  |  |  |  |  |  |  |  | 4
21 |  |  |  |  |  |  |  |  |  | 5
22 |  |  |  |  |  |  |  |  |  | 6
23 |  |  |  |  |  |  |  |  |  | 7
24 |  |  |  |  |  |  |  |  |  | 8
25 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  | 10
EMPLOYEE SIGNATURE: |  |  |  |  |  |  | DATE: |  |  | OTHER APPROVAL:
SUPERVISOR SIGNATURE: |  |  |  |  |  |  | DATE:
TOTAL HOURS TO BE PAID:  _______________ @ _____________/HR  =  _______________ |  |  |  |  |  |  |  |  |  | STUDENTS ARE ALLOWED TO WORK A MAXIMUM OF 20 HOUR/WEEK.
NOTE:  This time sheet must be signed by the supervisor and employee and HAND DELIVERED to the Payroll Office (A-130) by the 28th or 13th of each month.  All new employees must complete and submit all necessary
 | payroll forms to  the Payroll Office prior to submission of this time sheet.  The employee and supervisor signature certifies that information is correct .
PADDING OF TIME SHEETS IS A FEDERAL OFFENSE PUNISHABLE BY LAW.
Spreadsheet: 62777d1263775534-cant-download-from-web-race1
Sheet: Sheet1

 | Racing And Sports   Stawell Raceguide - 18 January 2010    Track: DEAD   Wind easing. ([NAME]: 22)
 | 1 |  | X X X X Gold Boat Regatta Mdn $12,000 | 2000m
 |  |  | 3yo+ Maiden API:0.48 | 1:05 pm
 | TAB | HORSE BP | WT |  | DLW | Car | RLW
 | 1 | [NAME] 2 | 58.0 |  | 0 | 0 | 0 | 7 | 7
 | 2 | Giant Victory 8 | 58.0 |  | 0 | 0 | 0.56 | 9 | 9
 | 3 | [NAME] 9 | 58.0 |  | 0 | 0 | 0.2 | 5 | 5
 | 4 | Orpenetto 5 | 58.0 |  | 843 | 0.04 | 0.14 | 28 | 7
 | 5 | Peace An Quiet 7 | 58.0 |  | 0 | 0 | 0.16 | 19 | 19
 | 6 | Rockinconi 10 | 58.0 |  | 0 | 0 | 0.13 | 8 | 8
 | 7 | Wyndam Fashion 3 | 58.0 |  | 0 | 0 | 0.13 | 31 | 31
 | 8 | Abysm 6 | 56.0 |  | 0 | 0 | 0.3 | 10 | 10
 | 9 | Mars Attacks 1 | 56.0 |  | 0 | 0 | 0.15 | 13 | 13
 | 10 | Wenita Joy 4 | 56.0 |  | 0 | 0 | 0 | 2 | 2
Spreadsheet: 268736d1380758195-equation-which-searches-a-cell-for-pm-or-p-and-replaces-number-after-with-an-x-pmx
Sheet: Sheet2

[NAME] | A
jill | C
bill | N
amy | O
rose | P
bob | E
[NAME] | Z
[NAME] | M
kristen | R
happy | Q
Spreadsheet: 709137d1608184217-array-formula-to-combine-2-numbers-into-a-matrix-voils-combinations
Sheet: Sheet1

 | Voils
 | 17 | 21 | 29 | Total
0
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
Spreadsheet: 813218d1673618398-allocation-table-formula-has-a-limitation-getting-error-due-to-lookback-sample-cost-allocation_v3
Sheet: Sheet1

 | Project Cost | 950000 |  |  | Result
 |  |  |  |  | Desired | Calc'd. |  |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00
 | Allocation Table
 | Month | MF |  |  |  |  |  | Example #1
 | 1 | 0.05 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 4
 | 2 | 0.05 |  |  | 15200000 |  |  | Problem Current formula ->
 | 3 | 0.05 |  |  |  |  |  | Note: this example provides the correct output because the projects start date (2/2024) is more than 12 months after the evaluation date (1/2023)
 | 4 | 0.05
 | 5 | 0.1 |  |  |  |  |  | Example #2
 | 6 | 0.2 |  |  |  |  |  | [NAME] |  |  |  | 12 | 4
 | 7 | 0.2 |  |  | 15200000 |  |  | Problem Current formula ->
 | 8 | 0.1 |  |  |  |  |  | Note: this example DOES NOT provide the correct output because the projects start date (4/2023) is less than 12 months after the evaluation date (1/2023)
 | 9 | 0.05
 | 10 | 0.05
 | 11 | 0.05 |  |  |  |  |  | Problem with current formula
 | 12 | 0.05 |  |  |  |  |  | The current formula works perfectly, as long as there are at least 12 months between the first available date and the first project start date (Jan 2023 start date / Feb 2024 first project start, in this example)
 | Total |  |  |  |  |  |  | The lookback (COUNT) months are looking for at least as much data as the allocation table provies. In this case, the allocation table has 12 entries.
 |  |  |  |  |  |  |  | Therefore I'm getting #[NAME]! errors for the first 11 months of the formula
 |  |  |  |  |  |  |  | Desired result
 |  |  |  |  |  |  |  | I'd like for the formula to find the project start date and start allocating costs from that point forward, based on the allocation table percentages.