tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: frank_ermis__11033__Expansion Offer Sheet
Sheet: Excel Offer

Wild Goose Storage Inc. |  |  | April 1, 2004 Expansion Open Season |  |  |  | Offer Sheet
Term | commencing at | 2004-04-01 00:00:00 | and ending on
Inventory Capacity : |  |  | Dth. |  |  | [NAME] is 2:00 MST, Tuesday May 22, 2001
 | Maximum | Injection | Injection | Inventory | Inventory | Maximum Daily | Withdrawal | Withdrawal | Monthly
 | Daily Injection | Demand | Demand | Demand | Demand | Withdrawal | Demand | Demand | Storage Demand
Month | Quantity | Rate | Charge (A) | Rate | Charge (B) | Quantity | Rate | Charge (C) | Charge
 |  |  |  |  |  |  |  |  | (A)+(B)+(C)
 | Dth/day/month | $US/Dth/day/month | $US/month | $US/Dth/month | $US/month | Dth/day/month | $US/Dth/day/month | $US/month | $US/month
Rack Rate: |  | 3 |  | 0.03 |  |  | 2
April | 0 | 0 |  | 0 |  | 0 | 0 |  |  |  | Rack Rate
May | 0 | 0 |  |  |  | 0 | 0
June | 0 | 0 |  |  |  | 0 | 0
July | 0 | 0 |  |  |  | 0 | 0
August | 0 | 0 |  |  |  | 0 | 0
September | 0 | 0 |  |  |  | 0 | 0
October | 0 | 0 |  |  |  | 0 | 0
November | 0 | 0 |  |  |  | 0 | 0
December | 0 | 0 |  |  |  | 0 | 0
January | 0 | 0 |  |  |  | 0 | 0
February | 0 | 0 |  |  |  | 0 | 0
March | 0 | 0 |  |  |  | 0 | 0
 |  |  |  |  | Total Storage Demand Charge (US$) |  |  |  |  | Annual Demand charge effective April 1, 2004
 |  |  |  |  | Rack Rate
Injection Commodity Rate: |  |  | 0.02 | $US/Dth | 0.02 | $US/Dth |  |  | of Rack Rate
Withdrawal Commodity Rate: |  |  | 0.02 | $US/Dth | 0.02 | $US/Dth
This offer is open for acceptance by Wild Goose Storage Inc. until 2:00 pm MST, Thursday June 28, 2001.
 |  |  |  |  |  | Fax Offer Sheets to: [PHONE]
 |  |  |  |  |  | Attention: [NAME]
Company Name
Per:
 |  |  |  |  |  |  |  | 3900, 421 - 7th Avenue S.W.
 |  |  |  |  |  |  |  | Calgary, Alberta
 |  |  |  |  |  |  |  | Canada
Name: |  |  |  |  |  |  |  | T2P 4K9
Title:
Spreadsheet: 266655d1379690356-need-help-regarding-calculating-growth-rate-bigfive
Sheet: Sheet1

Year | Mar'04 | Mar'05 | Mar'06 | Mar'07 | Mar'08 | Mar'09 | Mar'10 | Mar'11 | Mar'12 | Mar'13 | 10 Year | 5 Year | 3 Year | 1 Year
ROIC | 6.07 | 11.74 | 16.71 | 24.22 | 20.42 | 17.21 | 16.69 | 5.21 | 3.48 | 1.78
Sales | 5002.48 | 8112.3 | 11664.09 | 18420.2 | 27012.24 | 37352.08 | 41847.2 | 59467.2 | 71450.8 | 80311.2
EPS | 3.15 | 6.53 | 10.78 | 21.43 | 34.23 | 41.4 | 23.67 | 15.93 | 11.22 | 6
Equity | 4914.62 | 5320.03 | 7362.39 | 11488.38 | 21724.38 | 32368.8 | 44722.5 | 51623.1 | 53380.8 | 54410.3
Cash | -565.53 | 736.33 | -664.41 | -150.54 | -1313.16 | -3147.4 | 3186 | -8936.4 | 7408.1 | 9587.4
Spreadsheet: 523cd828-433f-40e6-b02c-cea051c83335
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259421 | 57307 | Yulia | Chernoy | ISR | 60 | 00:19:02 | 00:02:09 | 00:44:29 | 00:01:17 | 00:35:40 | 1 | 1:42:35
Spreadsheet: 1da7eaca-269e-4e2f-a8e9-db7cb9496951
Sheet: 2013 Interns By Industry

2013 Interns
Industry | % | Monthly Salary Range* | Median
Consulting | 0.1987829614604463
Strategic / Management | 0.18052738336714 | 4,500 - 12,083 | 11250
Other | 0.01825557809330629 | 2,000 - 9,000 | 6850
Financial Services | 0.4137931034482758
Diversified Financial Services | 0.01622718052738337 | 3,222 - 9,000 | 7646
Investment Banking/Brokerage | 0.2210953346855984 | 4,000 - 10,833 | 8333
Investment Management
Hedge Funds/Mutual Funds | 0.06085192697768763 | 2,000 - 15,000 | 7700
Private Equity/Venture Capital | 0.04056795131845842 | 1,000 - 10,000 | 4250
Other Investment Management | 0.04665314401622718 | 2,692 - 12,083 | 8333
Other | 0.02839756592292089 | 2,500 - 10,000 | 7728
Manufacturing | 0.08113590263691683
Consumer Products - Beverages / Food | 0.02839756592292089 | 1,650 - 7,100 | 6923
Consumer Products - Other | 0.03651115618661258 | 1,200 - 8,000 | 5120
Other | 0.01622718052738337 | 3,680 - 8,000 | 7200
Media/Technology (Nonhealth) | 0.154158215010142
Digital/Hardware/Software/Telecom | 0.03245436105476673 | 4,000 - 9,000 | 6400
Entertainment (Film/Music/TV/Sports/Publishing) | 0.03245436105476673 | 3,200 - 9,600 | 4800
Internet Services / E-Commerce | 0.08924949290060852 | 1,500 - 8,000 | 8000
Other | 0.1521298174442191
Economic Development / Microfinance | + | - | 2200
Education/Government/Nonprofit | 0.03448275862068965 | 2,240 - 7,500 | 3200
Healthcare (including Pharmaceuticals) | 0.03042596348884381 | 1,600 - 7,900 | 6400
Real Estate | 0.0486815415821501 | 1,200 - 9,167 | 5000
Retail | 0.01825557809330629 | 1,500 - 6,666 | 5000
Other | 0.01217038539553753 | 5,000 - 7,000 | 7000
Spreadsheet: 161341d1339502436-help-with-if-or-and-formula-excel-help
Sheet: Sheet1

Name | Role | Status |  | Name Database
Scott | [NAME] |  |  | Scott
[NAME] | [NAME] |  |  | Mark
[NAME] | [NAME] |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME]
[NAME]
[NAME]
[NAME] | Chef
Ricky | Chef
[NAME] | [NAME]
Sue
[NAME]
Sue
[NAME] | Plumber
[NAME]
[NAME] | [NAME]
[NAME]
Mark
[NAME]
Spreadsheet: 868229d1714978281-need-excel-formula-to-split-string-and-write-output-in-another-column-sample-excel
Sheet: Sheet1

 |  | Field1 | Field2 | Required Output | Requirement
 | 1 | JU | NE,,,PL | [NAME] | IF [NAME] or NEJU come it should only bring one value
 | 2 | XX | MA,UR,CH,YY,NE, | JUPL | if No value in field 1 then no output
 | 3 |  | ,PL,UR,CH,NE | XXMA
 | 4 | MA,ME,MO,NE,RA,KE | PL,,YY, | XXUR
 |  |  | JU,ZZ,MA,ME,MO,NE,RA,KE,XX, | XXCH
 |  |  | ,SU,VE,UR,CH,MA,ZZ,XX | XXYY
 |  |  | ,JU,SA,ZZ | XXNE
 |  | YY | ,XX,, | for 3rd row  field 1 value is not exist so no value should come
 |  | PL | ,ZZ,JU, | MAPL
 |  | SA | YY,,, | MAYY
 |  | SU,VE,UR,CH | SA,,PL,YY | MEPL
 |  |  | ME,MO,SU,VE,RA,KE,,ME,MO,SU,VE,RA,KE,MA,ME,MO,SU,VE,JU,SA,RA,KE | [NAME]
 |  |  |  | MOPL
 |  |  |  | MOYY
 |  |  |  | So on
Spreadsheet: 267571d1380114479-rank-function-tie-break-rank-tie-break-alphabetical
Sheet: Other version without alph.

Rank | Name | Cost |  |  |  | Name | Cost
 | George | 100000 |  |  | 1
 | [NAME] |  |  |  | 2
 | [NAME] | 100001 |  |  | 3
 | [NAME] |  |  |  | 4
 | Helen | 100000 |  |  | 5
 | [NAME] |  |  |  | 6
 | [NAME] | 60000 |  |  | 7
 | Maria | 50000 |  |  | 8
 | [NAME] | 100000 |  |  | 9
 | Rona |  |  |  | 10
Spreadsheet: 178316d1346763506-vlookup-problem-michelle
Sheet: Summary

acno* | Age of Account | Agent Group | AmexEntitlement_group | Annual Card Turnover Band | Attrition Model Score | Avg Monthly Sales Transactions Band | 2011 net sales | 2012 net sales YTD | Rolling 12
878505750884 | 4: 3-4 years | BCC | Y | E:40-50k | 0.286350832086719 | 1:0-10
878515549888 | 4: 3-4 years | BCC | Y | C:20-30k | 0.274328241740842 | 1:0-10
878594606880 | 5: 4-5 years | BCC | Y | F:50-100k | 0.220049233638432 | 6:200-500
878219953881 | 7: 10yrs plus | BCC | N | B:10-20k | 0.21254171594267 | 4:50-100
878565606885 | 4: 3-4 years | BCC | Y | F:50-100k | 0.210747526825223 | 1:0-10
878520980888 | 5: 4-5 years | BCC | Y | B:10-20k | 0.208999129833936 | 4:50-100
878545794884 | 4: 3-4 years | CNG | Y | B:10-20k | 0.365422940208165 | 4:50-100
Spreadsheet: 269255d1381078686-multiple-ifs-query-excel-fletchk-3-oeldere3-
Sheet: Oeldere

 |  |  |  |  | VLOOKUP($G2,$N$5:$O$7,2,0)-VLOOKUP(OFFSET($G2,0,(COUNTA($D2:$G2)-1)*-1,,),$N$5:$O$7,2,0)
 |  |  | [NAME] | Term 2 | Term 3 | Term 4 |  | Progress |  |  |  |  | 40-60a | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 30-50a | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 22-36a | 1
 |  |  | In I6 I want to look at the progress from the beginning to the end.
 |  |  | It is always calculated from Term 4 - so it would be term 4 take take 1, however if term 1 is blank, take it from [NAME], however if term 2 is blank take it from term 3, however if term 3 is blank return ""
 |  |  | The v look up table converts the numerical ranges to a number format.
Spreadsheet: 683178d1592543702-conditional-formatting-and-empty-cells-kaliper-m-linger
Sheet: Ark1

Dato | Ab1 | Ab2 | Ab3 | Ab (snitt) | Waist1 | Waist2 | Waist3 | Waist (snitt) | Thigh1 | Thight2 | Thigh3 | Thight (snitt)
2020-06-05 00:00:00 | 7 | 6.5 | 6.75 |  | 11 | 11 | 12 |  | 5.5 | 5.5 | 5.5
2020-06-08 00:00:00 | 7 | 7 | 7 |  | 7.5 | 8 | 8 |  | 5 | 5 | 5
2020-06-12 00:00:00 | 6.25 | 6.25 | 6.5 |  | 12 | 12.25 | 11.5 |  | 5 | 5 | 5
2020-06-15 00:00:00
2029-06-19 00:00:00 | 6.5 | 6.25 | 6 |  | 11 | 11.5 | 12 |  | 5 | 5 | 5
2020-06-22 00:00:00
2020-06-26 00:00:00
2020-06-29 00:00:00
2020-07-03 00:00:00
2020-07-06 00:00:00
2020-07-10 00:00:00
2020-07-13 00:00:00
2020-07-17 00:00:00
2020-07-20 00:00:00
2020-07-24 00:00:00
Spreadsheet: 3237ae3e-58ea-49d3-9afb-e10a91b4a945
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PTOX | Test | PTOX | Toxoplasma gondii, Molecular Detection, PCR | Toxoplasma gondii PCR | Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME], sterile container: SrwStlCont |  |  | 0.5 | mL | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:    Preferred: [NAME] fluid Container/Tube: Amniotic fluid container [NAME]: 0.5 mL Collection Instructions: Do not centrifuge. Specimen Stability Information: Refrigerated (preferred)/Frozen   Specimen Type: Spinal fluid Container/Tube: Sterile vial [NAME]: 0.5 mL Collection Instructions: Do not centrifuge. Specimen Stability Information: Refrigerated (preferred)/Frozen   Specimen Type: Fresh tissue Container/Tube: Sterile container with 1 to 2 mL of sterile saline or multi-microbe medium (M5) (Supply T484) [NAME]: Entire collection Collection Instructions: Submit only fresh tissue Specimen Stability Information: Refrigerated  Specimen Type: Ocular fluid Container/Tube: Body fluid container [NAME]: 0.3 mL Collection Instructions: Do not centrifuge. Specimen Stability Information: Refrigerated (preferred)/Frozen | [NAME], [NAME], Sp | Hemolysis	NA Thawing	Warm reject; Cold OK (CSF, amniotic or ocular fluid) Lipemia	NA Icterus	NA Other	NA | Negative for the presence of Toxoplasma gondii DNA | Monday through Saturday; Varies | 1 day/same day | 4 days | 1 | 87798 |  |  |  |  | Rochester
PTOX | [NAME] | VARIES | Varies |  |  |  | See instructions | 7 days
PTOX | Order Question | SRC74 | [NAME] |  | Plain Text
PTOX | Result | SRC74 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
PTOX | Result | 81795 | Toxoplasma gondii PCR | Toxoplasma gondii PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42626-2
Spreadsheet: 214695d1361056307-multi-level-bill-of-material-multi-level-bom-calculation
Sheet: Sheet2

Row Labels | Count of Parent Demand | [NAME]
aa1 | 3 | 2
aa2 | 2 | 6
aa3 | 4 | 36
aa5 | 1 | 10
aa7 | 1 | 10
aa8 | 1 | 840
Grand Total | 12 | 840
Spreadsheet: 857850d1706719712-formula-to-extract-data-in-col-a-and-b-into-col-c-formula-to-extract-data-from-col-a-and-b-into-col-c
Sheet: Sheet1

876689
876982
877822
877888
877850
877851
877859
877860
877861
877863
877865
877868
877870
707127Y
877881
877886
877897
877500
877508
877507
877509
877511
877515
877518
877520
Unallocated
877586
877556 | 876915
876708 | 877018
877037 | 817255
877219 | 877088
109952 | 877061
877828 | 877078
877871 | 877075
877878 | 877076
9985524X | 972023
877889 | 972025
877505
877506
877523
877525
877527
877529
877531
877551
877555
Spreadsheet: 879213d1726665704-choosing-the-right-workbook-architecture-for-a-capacity-model-sample-3
Sheet: Totals & averages

Product | Year 1 qty | Year 2 qty | Year 3 qty | Year 4 qty | Year 1 hrs | Year 2 hrs | Year 3 hrs | Year 4 hrs | Av. Qty | Av. Hrs
Product 1 new | 6 | 1 | 6 | 5 | 3000 | 500 | 3000 | 2500
Product 2 new | 0 | 3 | 2 | 0 | 0 | 600 | 400 | 0
Product 3 new | 2 | 0 | 2 | 0 | 2000 | 0 | 2000 | 0
Product 4 new | 0 | 4 | 0 | 0 | 0 | 2800 | 0 | 0
Product 5 new | 0 | 4 | 0 | 4 | 0 | 1200 | 0 | 1200
Product 1 repair | 4 | 4 | 1 | 1 | 800 | 800 | 200 | 200
Product 2 repair | 0 | 2 | 1 | 1 | 0 | 150 | 75 | 75
Product 3 repair | 9 | 1 | 9 | 8 | 3735 | 415 | 3735 | 2905
Product 4 repair | 2 | 1 | 2 | 0 | 340 | 170 | 340 | 0
Product 5 repair | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New all | 8 | 12 | 10 | 9 | 5000 | 5100 | 5400 | 3700
Repair all | 15 | 8 | 13 | 10 | 4875 | 1535 | 4350 | 3180
New 100% | 7 | 8 | 10 | 9 | 4500 | 2300 | 5400 | 3700
New 70% | 1 | 4 | 0 | 0 | 500 | 2800 | 0 | 0
New 50% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New 30% | 0 | 2 | 0 | 2 | 0 | 1400 | 0 | 1400
Repair 100% | 6 | 6 | 4 | 3 | 4500 | 2300 | 5400 | 3700
Repair 70% | 0 | 2 | 1 | 1 | 2800 | 0 | 0 | 0
Repair 50% | 9 | 0 | 8 | 5 | 0 | 1400 | 0 | 1400
Repair 30% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 764144d1642605455-order-scheduler-formula-help-required-please-order-schedule-test-jt
Sheet: WK-Orders

Week | Product Code | Description | Order | [NAME] | Date Required (Week Commencing) | [NAME] | New Order | Amended Order | Delayed | Brought forward
1 | Product 1 |  | 468549 | 2028 | 2021-12-13 00:00:00
1 | Product 1 |  | 468550 | 2028 | 2021-12-13 00:00:00
1 | Product 10 |  | 456820 | 3042 | 2022-01-03 00:00:00
1 | Product 10 |  | 477069 | 3042 | 2022-03-07 00:00:00
1 | Product 2 |  | 460308 | 1820 | 2021-12-27 00:00:00
1 | Product 2 |  | 464637 | 1820 | 2022-01-03 00:00:00
1 | Product 2 |  | 469944 | 1820 | 2022-01-24 00:00:00
1 | Product 2 |  | 477063 | 1820 | 2022-02-21 00:00:00
1 | Product 3 |  | 468542 | 1820 | 2022-01-10 00:00:00
1 | Product 3 |  | 472923 | 1820 | 2022-01-24 00:00:00
1 | Product 4 |  | 463345 | 1820 | 2021-12-20 00:00:00
1 | Product 4 |  | 469945 | 1820 | 2022-01-31 00:00:00
1 | Product 4 |  | 477064 | 1820 | 2022-02-21 00:00:00
1 | Product 5 |  | 477065 | 2028 | 2022-02-21 00:00:00
1 | Product 6 |  | 467287 | 3042 | 2022-02-07 00:00:00
1 | Product 7 |  | 439127 | 3042 | TBC
1 | Product 7 |  | 442911 | 3042 | TBC
1 | Product 7 |  | 444593 | 3042 | TBC
1 | Product 8 |  | 456819 | 3042 | 2021-12-27 00:00:00
1 | Product 8 |  | 463348 | 3042 | 2022-01-17 00:00:00
1 | Product 8 |  | 477066 | 3042 | 2022-02-28 00:00:00
1 | Product 9 |  | 455372 | 2704 | 2022-01-03 00:00:00
1 | Product 9 |  | 463349 | 2704 | 2022-01-10 00:00:00
1 | Product 9 |  | 477067 | 2704 | 2022-02-07 00:00:00
1 | Product 9 |  | 477068 | 2704 | 2022-02-28 00:00:00
2 | Product 1 |  | 468550 | 2000 | 2021-12-13 00:00:00
2 | Product 10 |  | 456820 | 3042 | 2022-02-07 00:00:00
2 | Product 10 |  | 477069 | 4000 | 2022-03-14 00:00:00
2 | Product 2 |  | 469944 | 1850 | 2022-01-24 00:00:00
2 | Product 3 |  | 472923 | 1820 | 2022-01-17 00:00:00
2 | Product 3 |  | 479841 | 1820 | 2022-03-07 00:00:00
2 | Product 4 |  | 469945 | 1820 | 2022-01-17 00:00:00
2 | Product 4 |  | 477064 | 1820 | 2022-01-31 00:00:00
2 | Product 4 |  | 478386 | 1820 | 2022-03-07 00:00:00
2 | Product 4 |  | 478387 | 1820 | 2022-03-28 00:00:00
2 | Product 6 |  | 467287 | 3042 | 2022-01-24 00:00:00
2 | Product 6 |  | 481161 | 3042 | 2022-02-07 00:00:00
2 | Product 6 |  | 481162 | 3042 | 2022-03-07 00:00:00
2 | Product 8 |  | 463348 | 3042 | 2022-02-17 00:00:00
2 | Product 9 |  | 477068 | 2660 | 2022-02-28 00:00:00
2 | Product 9 |  | 479842 | 2704 | 2022-03-21 00:00:00
3 | Product 8 |  | 477066 | 4000 | 2022-02-28 00:00:00
4 | Product 2 |  | 464637 | 1820 | 2022-01-23 00:00:00
Spreadsheet: 95982d1295471787-bar-chart-testchart2
Sheet: Chart

 |  |  |  |  |  |  |  | Base | Positive | 2010
 |  |  |  |  |  |  | 2009 |  | 400
 |  |  |  |  |  |  | 1 | 400 | 10 | 0
 |  |  |  |  |  |  | 2 | 410 | 20 | 0
 |  |  |  |  |  |  | 3 | 430 | 4 | 0
 |  |  |  |  |  |  | 4 | 434 | 1 | 0
 |  |  |  |  |  |  | 5 | 435 | 1 | 0
 |  |  |  |  |  |  | 2010 |  |  | 436
Spreadsheet: 704570d1605626230-formula-to-populate-data-from-a-single-tab-to-other-tabs-and-then-back-to-the-single-tab-sample
Sheet: Michelle

Date | Sales order number | Account owner | Order value | Vendor | Expected Month of Delivery | % Probability | Comments
2020-01-15 00:00:00 | [PHONE] | Michelle | 7726 | Hikvision | DEC | [NAME] | DELETE
2020-02-10 00:00:00 | [PHONE] | Michelle | 4449.77 | Apollo | DEC | [NAME] | DELETE
2020-02-10 00:00:00 | [PHONE] | Michelle | 3710.19 | [NAME] | DEC | PIPELINE | DELETE
Spreadsheet: f472372f-496a-4260-83a0-979f3794cc83
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Not Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: June 19, 2013 (3:07 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008 | 44 | 48 | 49 | 49 | 49 | 45 | 43 | 38 | 35 | 32 | 27 | 26
2009 | 24 | 29 | 31 | 32 | 34 | 37 | 38 | 36 | 30 | 33 | 26 | 24
2010 | 24 | 27 | 36 | 41 | 26 | 28 | 26 | 23 | 25 | 23 | 20 | 23
2011 | 21 | 22 | 28 | 30 | 28 | 28 | 27 | 25 | 24 | 25 | 23 | 24
2012 | 23 | 30 | 34 | 34 | 35 | 34 | 33 | 31 | 30 | 29 | 28 | 28
Spreadsheet: 164168d1340672075-excel-2007-what-formula-and-how-should-i-use-it-vlookup-or-indext-or-diet-plan-3-aussietommyson
Sheet: monday 

food name | Alternate grams | Multiplier | grams | Measurements |  | Calories | Protein | Fat | Carbs | Fibre
Quaker,  Oats | 54
Quaker,  Oats
Abbott's Bread: Harvest Seeds & Grains | 21
Abbott's Bread: Harvest Seeds & Grains
Spreadsheet: 686279d1594470671-sumproduct-of-these-data-with-a-maximum-capping-of-quantity-to-15-highest-value-first-sample-sheet
Sheet: Sheet1

CuT | Qty | Rate
NOKIA 2.2 DS (2/16) | 1 | 6136
NOKIA 2.2 DS (3/32) | 2 | 7159
NOKIA 2.3 DS (2/32) | 3 | 8737
NOKIA 3.1 Plus | 4 | 10228
NOKIA 3.2 (2/16) | 5 | 8182
NOKIA 3.2 (3/32) | 6 | 9205
 | This should be sum to [NAME] 15
 | In above table my result should be |  | 4*10228+6*9205+3*8737 & balance should be from model with value 8182 i.e 2*8182
Spreadsheet: 176177d1345747722-customer-delivery-tracking-example-for-len351
Sheet: Sheet1

Value | CUSTOMER | ORDER FREQUENCY | ORDER FREQUENCY | FIRST SHIPMENT |  | NEXT ORDER | DAYS LEFT | TODAY?
Unit | name | # weeks | # days | date |  | date | # days | boolean
 | A | 1 |  | 2012-03-21 00:00:00
 | B | 2 |  | 2012-03-21 00:00:00
 | C | 3 |  | 2012-03-21 00:00:00
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: Septembrie

NR | DATA TAIERE | NR CAP | LOT | GREUTATE VIU | MEDIE VIU | GREUTATE CARCASA | GREUTATE ORGANE |  | AVIZ CLF | AVIZ MRC | AVIZ CRH | DATA | CPT CLF | CARC CLF | TRANS CLF | ORG CLF | CPT MRC | CARC MRC | TRANS MRC | ORG  MRC | CPT CRH | CARC CRH | TRANS CRH | ORG CRH | Nr.Lot | Nr Aviz
1 | 2022-09-02 00:00:00 | 12 | 346 | 1522 |  |  |  |  | 611 | 612 | 613 |  | 5 |  |  |  | 3.5 |  |  |  | 2.5
2 | 2022-09-05 00:00:00 | 5 | 347 | 597 |  |  |  |  | 614 | 615 | 616 |  | 1 |  |  |  | 2.5 |  |  |  | 1.5
3
4
5
6
7
8
9
10
11
12
13
14
15
Total |  |  |  |  |  |  |  |  | Total
Spreadsheet: 60126d1260657597-sort-data-without-using-code-players
Sheet: Sheet1

SOURCE DATA |  |  |  | INDEX |  |  |  |  | DESIRED OUTCOME
 |  |  |  | A |  | B |  |  | A |  | B
 | Team | Position |  | Block | Tackle | Block | Tackle |  | Block | Tackle | Block | Tackle
Player A | A | Block
Player B | B | Tackle
Player C | A | Block
Player D | B | Tackle
Player E | A | Tackle
Player F | A | Block
Player G | A | Tackle
Player H | B | Block
Player I | B | Tackle
Player J | A | Block
Player K | A | Tackle
Player L | B | Tackle
Player M | B | Block |  |  |  |  |  |  | Problem:
Player N | B | Tackle |  |  |  |  |  |  | Can the above array be produced from the
Player O | A | Tackle |  |  |  |  |  |  | Source Data without resorting to writng code?
Player P | B | Tackle
Player Q | A | Block |  |  |  |  |  |  | And if code has to be written, what is the simplest?
Player R | B | Tackle
Player S | A | Block
Player T | B | Tackle
Player U | B | Block
Player V | A | Tackle
Player W | B | Block
Player X | A | Tackle
Player Y | B | Tackle
Player Z | B | Tackle
Spreadsheet: 09905008-5e92-4396-ba5e-a57eb6f6952e
Sheet: Sample

What is DBH?
 | Circumference measured (1) | Circumference measured (2) | Circumference measured (3) | Circumference average (C1+C2+C3)/3 | Circumference calculated (3.14*diameter) | Notes
Cookie 1 | 36 | 36.4 | 36.8
[NAME] | 78.5 | 78.2 | 78.8
Cookie 3 | 26 | 26.3 | 26.2
[NAME] | 63 | 63.1 | 63.2
 | Diameter measured | Diameter measured | Diameter measured | Diameter average | Diameter calculated (circumference/ 3.14) | Notes
Cookie 1 | 11 | 12 | 11.4
[NAME] | 23 | 26 | 25.7
Cookie 3 | 7 | 7.8 | 7.6 |  |  | very small
[NAME] | 21.4 | 15.5 | 17.4 |  |  | irregularly shaped
Spreadsheet: 859427d1707825220-if-function-not-working-book-6
Sheet: Sheet1

 |  |  |  |  |  |  |  | IF | IF
 |  |  |  |  |  | 1 | 4
 |  |  |  |  |  | 2
 |  |  |  |  |  | 4
 |  |  |  |  |  | 23
 |  |  |  |  |  | 12 | 2
 |  |  |  |  |  |  | 1
 |  |  |  |  |  | 4 | 3
 |  |  |  |  |  | 56 | 5
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1 | 6
Spreadsheet: 772442d1647275682-not-sure-if-formula-or-code-required-drawing-data-across-sheets-with-cell-value-dependency-test-draft
Sheet: agreement

 |  |  | XX
1
1.1
1.2
1.3
2
2.1
2.2
2.3
2.4
2.5
2.6
 |  |  |  |  |  |  | Date
 |  |  |  |  |  |  | Date
Spreadsheet: 867292d1714130995-deferred-revenue-and-balance-report-example-reports
Sheet: Sheet1

Name | Details | Start | End | Amount | Months | InvoiceDate | InvoiceNumber | Deferred Balance | Months Remaining |  | Invoice Date | Start Date | End Date | Amount | Monthly Value | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00
CLIENT 1 | Service 1 | 2024-04-25 00:00:00 | 2025-04-24 00:00:00 | 1967.4 | 12 | 2024-04-15 00:00:00 | 1718190
CLIENT 2 | Service 2 | 2024-03-27 00:00:00 | 2025-03-26 00:00:00 | 39348 | 12 | 2024-04-15 00:00:00 | 1718291
CLIENT 3 | Service 3 | 2024-04-05 00:00:00 | 2025-04-04 00:00:00 | 5913.51 | 12 | 2024-04-10 00:00:00 | 1717495
CLIENT 4 | Service 4 | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 931.83 | 12 | 2024-04-10 00:00:00 | 1717495
CLIENT 5 | Service 5 | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 4918.19 | 12 | 2024-04-10 00:00:00 | 1717495