tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 84429d1284482992-excel-2007-vlookup-for-additional-factor-in-the-table-andy9988
Sheet: Sheet1

PARENTS |  | 100000 |  | #N/A
SELF | 26 | 150000
SPOUSE | 24 | 200000
CHILDREN |  | 250000
CHILD 1 | 1 | 300000
CHILD 2 | 1 | 350000
CHILD 3 | 0 | 400000
CHILD 4 | 0 | 450000
 |  | 500000
Adult | 2
Child | 2 |  | Problem
[NAME] | 26 |  | I had used the Above formula for finding the premium, but I am not being able to develop a formula when I have more than 2 child in calucation.
Total | 4
 |  |  | Calculation Method
 |  |  | Step 1 | Find the Max Age from the family
 |  |  | Step 2 | Find how many Adults (Parents In Our Case) is there ?
 |  |  | Step 3 | Calculate Premium
 | Preblem 1 | If [NAME] from a family is 37 and there are 2 adults and 2 child are there then premium for 100000, will be 2430
 | Preblem 2 | If [NAME] from a family is 37 & there are 3 childred then the premium for 100000 will be 2430 + 235
 |  | if we add one more child in the above case to the family the premium will be 2430 + 235 + 235
 |  | Premium for additional will have to be looked up from same table
 | Note : | Even if child attains the age of 19 still he will be considered as child
 | Prbblem 3 | Is there any way that if the [NAME] age of family member goes above 45 then the referred cell starts blinking. Cell E2 in our case
 |  | So if B14 is greater than or equal to 46 then E2 will start blinking
 |  | I know the conditional formating but it will only change the colour of the cell.
Spreadsheet: 1a9f92c8-fdcc-4e41-9fb3-a0503dc52914
Sheet: StateAgenciesTitle I-Delinquent

Grant: |  | Title I-D Delinquent |  |  |  |  |  |  |  |  |  |  |  |  | Grant: | Title I-D Delinquent |  |  |  |  |  |  | Grant:
CFDA # |  | 84.031A |  |  |  |  | FISCAL YEAR: |  |  |  |  |  |  |  | FISCAL YEAR: |  |  |  |  |  |  |  | FISCAL YEAR:
GRANT NUMBER: |  | 4013
FISCAL YEAR:
Questions regarding payments: |  | [NAME]6724 or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez  [PHONE] or [EMAIL]
GBL/ORG |  | 723D-7000
PAYMENTS PROCESSED: |  | 1ST OF EACH MONTH
GRANT PERIOD: |  | 7/1/12 THROUGH 9/30/14-This grant does have carryover restrictions
Code | District | Allocation | Payments to Date | Balance of Grant | July 2012 | August 2012 | September 2012 | October 2012 | November 2012 | December 2012 | January 2013 | February 2013 | March 2013 | April 2013 | May 2013 | June 2013 | July 2013 | August 2013 | September 2013 | October 2013 | November 2013 | December 2013 | January 2014 | February 2014 | March 2014 | April 2014 | May 2014 | June 2014 | July 2014 | August 2014 | September 2014
X010 | Division of Youth Corrections | 483160 |  |  |  |  |  |  |  | 19674 |  |  |  | 32409 |  |  |  |  |  | 99204 |  |  |  |  | 9514
X020 | Department of Corrections | 80046 |  |  |  |  |  |  |  |  |  |  |  | 16196 |  |  |  | 20415 |  | 29893.66
Spreadsheet: 5c14eb4d-12ba-42e1-b41d-0e34c77c9116
Sheet: Sheet1

High Cholesterol, Adults Ages 18 Years and Over, by Race, Ethnicity and Sexual Orientation, Maine, 2007, 2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Unweighted Number | Weighted Number |  | % | LCL | UCL
Race and Ethnicity
American Indian or Alaskan Native only, non-Hispanic | DNR | DNR |  | DNR | DNR | DNR
Black only, non-Hispanic | DNR | DNR |  | DNR | DNR | DNR
Hispanic | DNR | DNR |  | DNR | DNR | DNR
Multiracial, non-Hispanic | 78 | 9540.020997695387 |  | 44.79952359404466 | 34.84554011524138 | 54.75350707284794
Other | DNR | DNR |  | DNR | DNR | DNR
White only, non-Hispanic | 5734 | 663825.5278721993 |  | 39.69245476744508 | 38.62767465959386 | 40.75723487529629
Sexual Orientation
Heterosexual or straight | 5702 | 662681.7883317167 |  | 39.51622666764253 | 38.45274963564774 | 40.57970369963733
Homosexual or gay or lesbian | 91 | 10010.42165375837 |  | 38.46997350930361 | 30.2695593169859 | 46.67038770162132
Bisexual | 46 | 7099.584221353232 |  | 38.24444790644785 | 24.34672283282138 | 52.14217298007432
Other | 32 | 4682.633439847262 |  | 56.37251227188261 | 40.21536444265371 | 72.52966010111152
Data Source: Behavioral Risk Factor Surveillance System Data is based on the percent of adults who were told by a doctor or other health care professional that they had high cholesterol. % = Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage
All percentages are weighted to be more representative of the population of Maine and to adjust for non-response.
DNR = data not reliable.  Data is suppressed if confidence intervals are greater that 20 percentage points.
Spreadsheet: sally_beck__33962__linkage
Sheet: Objectives

Enron Wholesale Services
Project Linkage
by
Risk Objective
 |  | Unauthorized |  | Inaccurate | Inadequacy |  |  | Inadequate |  | [NAME] | Financial and | Intercompany | Complex
 |  | Transactions/ | Financial | Deal | of | Portfolio | Data | Monitoring of | Transaction | of | Operational Completeness | & Related Party | Transaction
Projects |  | Transaction Levels | Markets | Capture | Price Curves | Valuation | Integrity | Credit Exposure | Settlements | Management Reports | & Accuracy | Activity | Accounting
Credit Risk Management (Phase I) |  |  | X |  |  | X |  | X
Financial Operations (Phase I) |  |  |  |  |  |  |  |  |  | X | X | X | X
Market Risk Management |  | X | X
Database System Management Review |  |  |  |  |  |  | X
Investment Compliance/Due Diligence |  |  |  |  |  |  |  |  |  |  | X
Related Party & Affiliate |  |  |  | X |  | X |  |  |  |  |  | X
Operational Analysis |  |  |  |  |  |  |  |  | X |  | X
Rate Server Applications |  |  |  |  | X |  | X
Paper & Steel Trading |  | X | X | X | X | X | X |  | X |  | X | X
Weather Derivatives Trading |  | X | X | X | X | X | X |  | X |  | X | X
Enron Online |  | X |  | X |  |  | X | X |  | X
Risk Controls Group |  | X |  | X | X |  | X |  |  | X
Market Data Network |  |  |  |  |  |  | X
Capital Structuring |  |  | X |  |  | X
Canada Trading |  | X | X | X | X | X | X |  | X |  | X | X
Coal Trading |  | X | X | X | X | X | X |  | X |  | X | X
Origination & Structuring |  | X | X |  |  |  |  |  |  |  |  |  | X
Natural Gas Trading |  | X | X | X | X | X | X |  | X |  | X | X
GRMS/ RisktRAC |  |  |  | X |  |  | X |  |  | X
South America Trading |  | X | X | X | X | X | X |  | X |  | X | X
Liquids Trading |  | X | X | X | X | X | X |  | X |  | X | X
Equity/Debt Trading |  | X | X | X | X | X | X |  | X |  | X
Model Development |  |  |  |  |  | X | X
Portfolio Management |  |  |  |  |  | X
Global Database Applications |  | X |  | X |  |  | X
Power Trading |  | X | X | X | X | X | X |  | X |  | X | X
Financial Settlements |  |  |  |  |  |  |  |  | X |  | X | X
Flash to Actual |  |  |  |  |  |  |  |  |  |  | X
Underwriting |  | X | X
Financial Operations (PhaseII) |  |  |  |  |  |  |  |  |  | X | X | X | X
F/X - Interest Rate Trading |  | X | X | X | X | X | X |  | X |  | X | X
Credit Risk Management (Phase II) |  |  | X |  |  | X |  | X
Standards Audit (IT) |  |  |  |  |  |  | X
Investment Valuation |  |  |  |  |  | X
Financial Business Analysis & Reporting |  |  |  |  |  |  |  |  |  | X | X
Spreadsheet: 856510d1705728467-create-button-that-will-autofill-invoice-sample-invoice
Sheet: Customer Data

Customer No | Name | Phone | eMail | Address | Suburb | State
1001 | [NAME] | 1-1234-5678 | [EMAIL] | 123 Home Drive | New York | NY
1002 | [NAME] | 1-4567-2345 | [EMAIL] | 333 My House | Dallas | TX
1003 | [NAME] | 1-1111-1111 | [EMAIL] | 321 MyPlace | Los Angeles | CAL
2203 | [NAME] | 1-9999-0000 | [EMAIL] | Test Place 23 | Manhattan | NY
Spreadsheet: 104676d1302188156-creating-a-time-series-sample-sheet
Sheet: Sheet1

 |  |  |  | Par | 1000
 |  |  |  | Int % | 0.05
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: tracy_geaccone__40332__Enron Goodwill Analysis-June 30 version tt
Sheet: GW on equ. invtees books

Enron Goodwill Analysis Unconsolidated Goodwill - Impairment Analysis on Equity Method Investees' Books
(in millions)
 |  | December 2000 Goodwill |  | Exposure Items
EOTT |  | 3 |  | 0
Northern Border Partners, L.P. |  | 22 |  | 0
Stadacona |  | 141 |  | 0
SK Enron |  | 140 |  | 0
Transredes |  | 36 |  | 0
Promigas |  | 1 |  | 0
Azurix/Wessex |  | 707 |  | 707
Azurix/PUMC |  | 119 |  | 119
Azurix/AMX |  | 45 |  | 45
Azurix/IASA |  | 12 |  | 12
Azurix/Ecopreneur |  | 2 |  | 2
Azurix/BHIS-Industrials |  | 8 |  | 8
Azurix/Lurgi |  | 31 |  | 31
Industrial Markets - Pulp & Paper (Fishtail) |  | 114 |  | 0
TOTALS
Spreadsheet: jeff_dasovich__14247__s00 cohorts
Sheet: Sheet1

LNAME | Day (m=m/w, t=t/th)
Abernathy | m
[NAME] | t
Asbo | t
Bansal | t
Blanchard | m
Boyle | t
Brewer | t
[NAME] | m
Bukowski | t
[NAME] | t
[NAME] | t
[NAME] | t
Cornes | m
[NAME] | t
[NAME] | m
D'Couto | t
DeBruyn | m
deVroede | m
Ellis | t
Esarte | m
Fiske | m
Fontana | m
Frye | t
[NAME] | m
Guinney | t
Hajela | m
Hari | m
Hornbeck | t
Howe | m
Hudacko | t
Huey | m
Hurley | t
Huss | t
Iyer | m
[NAME] | m
Jenkins | t
Jerian | m
Kang | m
Kannan | m
[NAME] | m
[NAME] | t
Kelly | m
Kerudi | m
Keshav | t
Kiem | m
[NAME] | t
Klotz-Guest | m
Krishnaswamy | t
[NAME] | m
[NAME] | m
[NAME] | t
Kwon | t
[NAME] | m
[NAME], Chrystine | m
[NAME], [NAME] | m
[NAME] | m
[NAME] | m
Lysaght | t
Magner | m
Martinez | t
McVey | m
Meirelles | m
Mellencamp | t
Mendelson | m
Mi, amy | t
Mi, ping | t
Murthy | m
Muthukumarasamy | m
Napolitana | m
Neale | m
Nimmagadda | m
O'Connor | t
Parker | t
[NAME] | m
[NAME] | t
Pestoni | m
Pine | t
Prabhakaran | t
[NAME] | m
Rangarajan | t
[NAME] | m
Ravinutala | t
[NAME] | t
[NAME] | t
Roukema | t
Sama | m
Sanghi | t
Scharf | t
Shah | t
Shao | t
[NAME] | t
Sidbury | t
Siddiqi | m
Singh | t
Sklarin | m
Smith, M | t
Smith, P | t
Sundaresan | m
Swann | t
[NAME] | m
[NAME] | t
Turner | m
Vavrek | t
Vinson | m
Viswanath | t
Wadhwa | m
Wang, O | t
Wang, V | m
Wen | m
Windham | t
Wise | m
[NAME] | m
[NAME] | m
Yarak | t
Zhao | t
Spreadsheet: 711127d1609451296-most-current-date-in-a-row-dates
Sheet: Revisions

Location | AOR | CD Completed | HL Received LL Comments | AOR Received LL Comments | LL Comments Completed And Sent To HL | # of Days | (H) [NAME]) AHJ-(L)LL | First Time To AHJ | Plans to HL | Submited To City | Comments or Approved | Received Back From AHJ | # of Days | Rev# | (H) [NAME]) AHJ-(L)LL | Plans Submitted to HL | Date Submitted to AHJ | Received Back From AHJ | Comments or Approved | # of Days | Rev# | (H) [NAME]) AHJ-(L)LL | Plans Submitted to HL | Date Submitted to AHJ | Received Back From AHJ | Comments or Approved | # of Days | Rev# | (H) [NAME]) AHJ-(L)LL | Plans Submitted to HL | Date Submitted to AHJ | Received Back From AHJ | Comments or Approved | # of Days
Spreadsheet: 775286d1648984434-finding-highest-rated-department-by-the-sum-of-total-sales-and-employee-id-excel-training-help-aligw
Sheet: Sheet1

 |  |  |  | Employee ID | Department | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | Total Sales | Row Labels | Count of Jan-16
Emoloyee ID | Department |  |  | 1006 | Development | 1 | 9 | 3 |  | Development | 2
1006 |  |  |  | 1007 | Finance | 2 | 7 | 5 |  | Finance | 2
1007 |  |  |  | 1009 | Finance | 6 | 1 | 4 |  | MD | 2
1009 |  |  |  | 1100 | Finance | 54 | 67 | 7 |  | Support | 5
1100 |  |  |  | 3900 | Support | 5 | 2 | 1 |  | Grand Total | 11
3900 |  |  |  | 4500 | Support | 41 | 45 | 7
4500 |  |  |  | 133 | Support | 66 | 77 | 21
133 |  |  |  | 133 | Support | 44 | 33 | 88
133 |  |  |  | 133 | Support | 8 | 7 | 5
133 |  |  |  | 1007 | Support | 2 | 7 | 5
1007 |  |  |  | 1007 | Support | 55 | 87 | 5
1007 |  |  |  | 99 | MD | 5 | 56 | 5
99 |  |  |  | 100 | Support | 2 | 2 | 56
100 |  |  |  | 100 | Support | 1 | 56 | 5
100 |  |  |  | 1009 | Finance | 3 | 6 | 5
1009 |  |  |  | 1009 | Development | 2 | 5 | 1
1009 |  |  |  | 1009 | Development | 500 | 700 | 700
1009 |  |  |  | 3900 | MD | 77 | 23 | 29
3900 |  |  |  | 3900 | MD | 55 | 33 | 44
3900 |  |  |  | 3900 | Development | 99 | 66 | 99
3900 |  |  |  | 3900 | Development | 7 | 8 | 9
3900 |  |  |  | 1100 | Finance | 54 | 67 | 7
1100 |  |  |  | 1006 | Development | 76 | 8 | 78
 |  |  |  | 1006 | Finance | 34 | 44 | 65
 |  |  |  | 1006 | Finance | 22 | 28 | 7
 |  |  |  | 1006 | MD | 9 | 110 | 21
 |  |  |  | 1006 | MD | 45 | 34 | 8
 |  |  |  | 1007 | MD | 78 | 78 | 8
 |  |  |  | 1100 | Finance | 54 | 67 | 7
 |  |  |  | 1100 | Finance | 54 | 67 | 7
 |  |  |  | 1100 | MD | 98 | 106 | 99
 |  |  |  | 1100 | MD | 3 | 2 | 3
 |  |  |  | 1100 | Development | 101 | 101 | 101
 |  |  |  | 1100 | Development | 6 | 4 | 3
 | Hi all,
In G13 I am trying to get the department by Employee Id with the highest number of sales based on column J, so for example for B3 the result shoud be MD.
Tried index and match with [NAME] but gives the wrong answer as I am looking for the total amount of sales for a department based on the iD.
Much , much appreciated your help!
Spreadsheet: louise_kitchen__22633__SepQTD Orig w notes Faith
Sheet: Central Gas

Central Gas
For the Quarter Ended September 30
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Luce |  | Gas |  | Central Gas |  | 1880000
Pollan |  | Gas |  | Central Gas |  | 221528
Frihart |  | Gas |  | Central Gas |  | 188259
Thurston |  | Gas |  | Central Gas |  | 140169
Otto |  | Gas |  | Central Gas |  | 10775
Culota |  | Gas |  | Central Gas |  | 9125
Giron |  | Gas |  | Central Gas |  | 7866
Total
Spreadsheet: 887589d1737828318-lost-in-a-challenging-formula-challenge-costs
Sheet: Identifier

 |  |  | Identifier | contract type | cost type
 |  |  | SE.100 | open book | direct cost
 |  |  | SE.101 | lumpsum | indirect cost
 |  |  | SE.102 | open book | indirect cost
 |  |  | SE.103 | open book | indirect cost
 |  |  | SE.104 | lumpsum | indirect cost
 |  |  | SE.105 | lumpsum | direct cost
 |  |  | SE.106 | lumpsum | direct cost
 |  |  | SE.107 | open book | direct cost
 |  |  | [NAME] | open book | direct cost
Spreadsheet: 39858d1238112099-inserting-a-line-on-my-reference-sheet-test-for-help
Sheet: 2009 Summerfest Sponsors

Sponsor Number | Sponsor Company Name | Sponsor Company Contact Name | Sponsor Contact Email | Sponsor Address | Sponsor Phone | SAM Family Responsible for Sponsorship | SAM Sponsorship Team Name | Sponsor or In-Kind (where assigned) | Sponsor Level Description | Cash Sponsor Amount | In-Kind Donation Value Amount |  |  |  |  |  |  |  |  |  |  |  | Notes
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | Title | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | Diamond | 2 | 2
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Platinum | 3 | 3
8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | Title | 8 | 8
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Corporate | 4 | 4
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Gold | 5 | 5
6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | Cougar | 6 | 6
Spreadsheet: f6d3c381-608b-416b-be28-a0a29778061e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
5191 | 5486 | Anastasiya | Polyanskaya | RUS | 23 | 00:00:00 | 00:00:00 | 00:15:14 | 00:00:09 | [NAME] | 1 | 00:25:17
5191 | 9820 | [NAME] | Ivanovskaya | RUS | 21 | 00:00:00 | 00:00:00 | 00:15:16 | 00:00:07 | 00:09:56 | 2 | 00:25:19
5191 | 6744 | [NAME] | Langit | PHI | 22 | 00:00:00 | 00:00:00 | 00:15:16 | 00:00:08 | 00:10:07 | 3 | 00:25:31
5191 | 32605 | Regina | [NAME] | AUS | 0 | 00:00:00 | 00:00:00 | 00:15:45 | 00:00:11 | 00:10:25 | 4 | 00:26:22
5191 | 31820 | [NAME] | Ying | SIN | 0 | 00:00:00 | 00:00:00 | 00:15:41 | 00:00:07 | [NAME] | 5 | 00:26:31
Spreadsheet: 525115d1498558563-nested-if-formula-but-with-other-functions-included-possible-dates-or-not
Sheet: Sheet1

Product | DATE PO INTO WHS (36) | Need Sample? | Request Sample by... | Sample due date  (2 weeks prior to PO due date) | Sample Here? Enter Date (37) | Sample grade | [NAME] to WHS (40)
Item 1 | 2017-07-10 00:00:00 | yes |  |  | 2017-06-23 00:00:00 |  |  | If I enter a YES in column C, then the formulas as shown to apply in the cells D-G If I enter a NO in column C I would like rows D-H to show N/A in all the cells.
Item 2 | 2017-08-01 00:00:00 | yes |  |  | 2017-06-27 00:00:00
Item 3 | 2017-10-10 00:00:00 | no
Item 4 | 2017-11-25 00:00:00 | no
Item 5 | 2017-12-01 00:00:00 | yes
Spreadsheet: 187845d1350593572-multiple-look-up-testcase
Sheet: Desired Output

[NAME] | Contracts
123_ABCD | 127650~[NAME]
 | 1244360-ZZRO~8792x3
 | 1895436-LLGT~90422vT
 | 1244360-ZZRO~872x3
456_DEFG | 127650~[NAME]
 | 1244360-ZZRO~8792x3
 | 1895436-LLGT~90422vT
 | 1244360-ZZRO~872x3
789_GHIJ | 127650~[NAME]
 | 1244360-ZZRO~8792x3
 | 1895436-LLGT~90422vT |  |  | THOUGHT PROCESSES
 | 1244360-ZZRO~872x3
000_JKLM | 127650~[NAME] |  |  |  |  |  | FORMULA For COL | FORMULA For ROW
 | 1244360-ZZRO~8792x3 |  |  | We Want | Col 1 | Row 1
 | 1895436-LLGT~90422vT |  |  |  | Col 2 | Row 1
 | 1244360-ZZRO~872x3 |  |  |  | Col 3 | Row 1
111_PPPP | 17960-bbCD-123 |  |  |  | Col 4 | Row 1
999_CCCC | 123960-KbLM-12x3 |  |  |  | Col 1 | Row 2
 | 196780-nuLM-2Yx3 |  |  |  | Col 2 | Row 2
 | 123960-KbLM-12x3 |  |  |  | Col 3 | Row 2
999_DDDD | 123960-KbLM-12x3 |  |  |  | Col 4 | Row 2
 | 196780-nuLM-2Yx3 |  |  |  | Col 1 | Row 3
 | 123960-KbLM-12x3 |  |  |  | Col 2 | Row 3
 |  |  |  |  | Col 3 | Row 3
SOLUTION |  |  |  |  | Col 4 | Row 3
 |  |  |  |  | Col 1 | Row 4
 |  |  |  |  | Col 2 | Row 4
 |  |  |  |  | Col 3 | Row 4
 |  |  |  |  | Col 4 | Row 4
 |  |  |  |  | Col 1 | Row 5
 |  |  |  |  | Col 1 | Row 6
 |  |  |  |  | Col 2 | Row 6
 |  |  |  |  | Col 3 | Row 6
 |  |  |  |  | Col 1 | Row 7
 |  |  |  |  | Col 2 | Row 7
 |  |  |  |  | Col 3 | Row 7
Spreadsheet: 227253d1365644663-if-a-cell-contains-codes-listed-i-a-column-it-will-show-its-equivalent-description-copy-of-delivery-order-format
Sheet: LIST OF PRODUCTS

ITEM CODE | [NAME] | LIST PRICE
 |  | CASE | PIECE
LPP150 | LO-PATIS POUCH 48X150ML | 398.1 | 8.293750000000001 | LPP150 | <<< this is the trim to delete the leading spaces
LPGG350 | LO-PATIS GGLASS 24X350ML | 407.43 | 16.97625 | LPGG350
LPGP350 | LO-PATIS GPLASTIC 24X350ML | 419.11 | 17.46291666666667 | LPGP350
LP1L | LO-PATIS LITER 12X1000ML | 549.95 | 45.82916666666667 | LP1L
LPHG | LO-PATIS H.GALLON 6X1892ML | 500.58 | 83.42999999999999 | LPHG
LPG | LO-PATIS GALLON 4X3785ML | 584.01 | 146.0025 | LPG
LCP370 | LO-CHILI PATIS 24X370ML | 476.51 | 19.85458333333333 | LCP370
LPP200 | LO-PREMIUM PATIS 24X200ML | 912 | 38 | LPP200
[NAME] | LO-SOYSAUCE GGLASS 24X350ML | 305 | 12.70833333333333 | [NAME]
LSOGP350 | LO-SOYSAUCE GPLASTIC 24X350ML | 335.4 | 13.975 | LSOGP350
LSO1L | LO-SOYSAUCE LITER 12X1000ML | 388.8 | 32.4 | LSO1L
LSUGG350 | LO-SUKA SASA GGLASS 24X350ML | 235.62 | 9.8175 | LSUGG350
LSUGP350 | LO-SUKA SASA GPLASTIC 24X350ML | 279.93 | 11.66375 | LSUGP350
LSU1L | LO-SUKA SASA LITER 12X1000ML | 318.78 | 26.565 | LSU1L
LSUG | LO-SUKA SASA GALLON 4X3785ML | 356.69 | 89.1725 | LSUG
LBS11 | LO-BALAYAN SAUCE 24X11OZ | 541.2 | 22.55 | LBS11
LBSG11 | LO-BALAYAN SAUCEW/GINGER 24X11OZ | 567.6 | 23.65 | LBSG11
LBSGC11 | LO-BALAYAN W/GINGERCHILI 24X11OZ | 594 | 24.75 | LBSGC11
[NAME] | LO-ALAMANG GUISADO 24X8OZ | 1651.86 | 68.8275 | [NAME]
FTCM400 | FILTASTE COCONUT MILK 24X400ML | 1269.6 | 52.9 | FTCM400
FTTT8 | FILTASTE TABA TALANGKA 24X8OZ | 2448 | 102 | FTTT8
LBP | LORINS BUDGET PACK | 335 | 41.875 | LBP
Spreadsheet: 267851d1380241631-creating-a-list-of-people-who-have-an-outstanding-balance-ef488_golfspreadsheet_help
Sheet: What I have

Sponsor Level | Recognize as | Pledge | Rec'd | Outstanding
 | [NAME] | 5000 | 0
 | [NAME] | 1000 | 0
 | [NAME] | 125 | 0
 | [NAME] | 2500 | 0
Spreadsheet: 888133d1738576351-how-complete-cells-depeding-another-exemplo-1-
Sheet: Folha1

 |  |  |  |  |  |  |  |  | A | 2025-01-01 00:00:00 | 100 |  |  |  | A
 |  |  |  |  |  |  |  |  |  | 2025-01-05 00:00:00 | 125 |  |  |  |  | 100 | ?
 |  |  |  |  |  |  |  |  |  | 2025-01-12 00:00:00 | 50 |  |  | ? |  | 125 | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ? |  | 50 | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ? |  |  | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ? |  |  | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ? |  |  | ?
 |  |  |  |  |  |  |  |  | B | 2025-01-03 00:00:00 | 35
 |  |  |  |  |  |  |  |  |  | 2025-01-12 00:00:00 | 75
 |  |  |  |  |  |  |  |  | C | 2025-01-04 00:00:00 | 50
 |  |  |  |  |  |  |  |  |  | 2025-01-12 00:00:00 | 50
Spreadsheet: 793143d1661336025-extracting-data-for-a-visit-repeat-test
Sheet: Sheet1

ID | event | facility | gend | test 1 | test 2
1 | visit1 | 1 | 1 | 3.6848
1 | visit2
1 | visit3
1 | visit4
1 | visit5
2 | visit1 | 2 | 1 | 2.3724
2 | visit2
2 | visit3 |  |  |  | 15.7
2 | visit4
2 | visit5
3 | visit1 | 2 | 2 | 4.2709
3 | visit2
3 | visit3 |  |  |  | 11.5
3 | visit4
3 | visit5
4 | visit1 | 2 | 1 | 3.2265
4 | visit6
5 | visit1 | 2 | 2 | 2.0822
5 | visit3
5 | visit4
5 | visit6
6 | visit1 | 2 | 2 | 2.1275
6 | visit2
6 | visit3 |  |  |  | 11.6
6 | visit4
6 | visit5
7 | visit1 | 2 | 2 | 1.8907
7 | visit2
7 | visit3 |  |  |  | 11.5
7 | visit4
7 | visit5
8 | visit1 | 2 | 2
8 | visit2
8 | visit3 |  |  |  | 10.8
8 | visit4
8 | visit5
9 | visit1 | 2 | 2 | 2.1719
9 | visit2
9 | visit3
10 | visit1 | 2 | 2 | 2.8525
10 | visit2
10 | visit3 |  |  |  | 12.5
10 | visit4
10 | visit5
Spreadsheet: 92df7497-c0ce-4f02-ab99-8e2fee07035d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42225345 | 2014-07-09 10:45:02 | AXIS | 0 | 4 | 5 | 592252 | adrienbastien | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42225479 | 2014-07-09 11:02:28 | ALLIES | 1 | 5 | 4 | 592252 | adrienbastien | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42225667 | 2014-07-09 11:28:11 | AXIS | 1 | 6 | 4 | 592252 | adrienbastien | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
42225804 | 2014-07-09 11:37:50 | ALLIES | 1 | 6 | 2 | 592252 | adrienbastien | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
42245020 | 2014-07-10 20:17:36 | ALLIES | 1 | 5 | 4 | 443223 | southoftheborder | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42245218 | 2014-07-10 20:30:52 | AXIS | 1 | 5 | 3 | 443223 | southoftheborder | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42258104 | 2014-07-11 19:44:39 | AXIS | 1 | 6 | 2 | 1240562 | Big Taz | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42258266 | 2014-07-11 20:03:24 | ALLIES | 1 | 6 | 5 | 1240562 | Big Taz | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
Spreadsheet: 847964d1698791225-cannot-get-closest-match-to-work-within-reverse-lookup-with-a-2-dimensional-array-testdata-revlookup-closestmatch-2darray
Sheet: Rev Lkup TestData

Category | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 |  | SAMPLE REVERSE LOOKUP -2 INPUTS, 1 OUTPUT
1001 | 100 | 150 | 250 | 300 | 500 | 700 |  | Exact match works; Closest match does not work.
1002 | 50 | 60 | 70 | 80 | 95 | 120 |  | 2 INPUTS: | Category | Units |  | 1 OUTPUT: | Percentile
1003 | 1000 | 2000 | 3000 | 5000 | 6000 | 7000 |  | Example: Sold 68 Units of Category 1002.  Closest percentile rank for that category is 3%tile.
1004 | 5 | 15 | 25 | 30 | 35 | 37 |  | Category | 1002
1005 | 30000 | 35000 | 40000 | 42000 | 44000 | 50000 |  | Units Sold | 68
 |  |  |  |  |  |  |  | %tile |  | Any value between the two table values returns the lower value, instead of closest match.
Issue: Difficulty applying closest match reverse lookup in a 2 dimensional array.
 |  |  |  |  |  |  |  | SAMPLE REVERSE LOOKUP -1 INPUT, 1 OUTPUT
 |  |  |  |  |  |  |  | Both exact match and closest match work.
 |  |  |  |  |  |  |  | 1 INPUT: | Units |  |  | 1 OUTPUT: | Percentile
 |  |  |  |  |  |  |  | Example: Sold 68 Units of Category 1002.  Closest percentile rank for that category is 3%tile.
 |  |  |  |  |  |  |  | Category = 1001 |  | ONLY OPTION AVAILABLE WITHIN FORMULA
 |  |  |  |  |  |  |  | Units Sold | 295
 |  |  |  |  |  |  |  | %tile |  | Note: Current version of Excel requires [Ctrl+Shift+Enter] instead of just [Enter]
Spreadsheet: 73540d1274198239-staff-rota-date-and-day-calculation-rotadate
Sheet: Dates

Month | Year
1 | 2010 | Change A2 & B2 to change dates from A5 onwards