tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50ebf641-c5b0-4ced-b1d5-54ea56a9ccff
Sheet: Sheet1

Table 3--Soybean oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning | Production | Imports | Total |  | Domestic |  |  | Exports | Total | Ending
October 1 | stocks |  |  |  |  | Total | Biodiesel | Food |  |  | stocks
 | Million pounds
2011/12 | 2425.347 | 19740 | 149.294 | 22314.641 |  | 18310.278 | 4870 | 13440.278 | 1464.363 | 19774.641 | 2540
2012/131 | 2540 | 19605 | 350 | 22495 |  | 18550 | 4800 | 13750 | 2200 | 20750 | 1745
2013/142 | 1745 | 19495 | 250 | 21490 |  | 18550 | 5500 | 13050 | 1300 | 19850 | 1640
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2013-07-15 08:34:12.970000
Spreadsheet: 770219d1645897113-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Average Checkins per AG+Week

Weeks | Start Date | End Date
Week 1 | 2022-01-03 00:00:00 | 2022-01-09 00:00:00
Week 2 | 2022-01-10 00:00:00 | 2022-01-16 00:00:00 |  |  |  | IS THERE A WAY TO TAKE WHAT'S ON THE AVERAGE CHECKINS PER AGE GROUP TAB AND DO IT PER WEEK?
Week 3 | 2022-01-17 00:00:00 | 2022-01-23 00:00:00
Week 4 | 2022-01-24 00:00:00 | 2022-01-30 00:00:00
Starting Age | Ending Age
13 | 19
20 | 29
30 | 39
40 | 49
50 | 59
60 | 69
70 | 79
80 | 89
90 | 99999
Spreadsheet: 647748d1572612065-closest-match-with-multiple-criteria-3-criteria-boxes-breakdown-closest-match-sample
Sheet: Sheet1

ID | length | width |  |  |  | [NAME] | length | width
1 | 600 | 400 |  |  |  | Cont1 | 450 | 305
2 | 400 | 300 |  |  |  | Cont2 | 800 | 500
3 | 200 | 150 |  |  |  | Cont3 | 600 | 402
 |  |  |  |  |  | Cont4 | 250 | 200
 |  | WORKING
ID | length | width | depth |  |  | [NAME] | length | width | depth
1 | 600 | 400 | 119 |  |  | Cont1 | 450 | 305 | 430
2 | 400 | 300 | 220 |  |  | Cont2 | 800 | 500 | 135
3 | 200 | 150 | 420 |  |  | Cont3 | 600 | 402 | 250
 |  |  |  |  |  | Cont4 | 250 | 200 | 175
 |  | DON'T KNOW HOW TO GET WORKING
 | MOCKUP: | For ID 1
 | Length 600 matches: |  | Cont2 |  | CLOSEST MATCH |  |  | ANSWER:
 |  |  | Cont3 |  | Cont3 |  |  | Cont3
 | [NAME] 400 matches: |  | Cont2 |  | CLOSEST MATCH
 |  |  | Cont3 |  | Cont3
 | Depth 119 matches: |  | Cont2 |  | CLOSEST MATCH
 |  |  | Cont3 |  | Cont2
Spreadsheet: michelle_lokay__26693__Accomplishments 2001
Sheet: Sheet1

2001 Accomplishments
Marketer:  [NAME]
Customer | MMBtu/d | Rate | Term | Revenue |  | Notes:
Western Gas | 10000 | 0.385 | 15 years | $21.0 million |  | Red Rock expansion contract
Conoco | 20000 | [NAME] | 5 years | $14.0 million |  | renewed ROFR capacity
Western Gas | 10000 | [NAME] | 15 years | $5.6 million |  | alternate supply for Red Rock expansion contract
PPL Energy | 7500 | 0.225 | 5 years | $3.1 million |  | Red Rock expansion contract
Oneok | 5000 | 1.75 | 22 months | $2.3 million |  | Red Rock expansion contract
Burlington | 33000 | [NAME] | 3 months | 265000 |  | sold stranded LaMaquina capacity
North Star Steel | 1300 | [NAME] | 13 months | 200000 |  | incremental firm from East of California to border
PPL Energy | 20000 | [NAME] | 4 months | 175000 |  | incremental interruptible from East of California to border
PPL Energy | 20000 | 0.1 | 2 months | 100000 |  | incremental firm from East of California to border
Burlington | 20000 | 0.05 | 2 months | 70000 |  | sold stranded LaMaquina capacity through EnronOnLine
ePrime | 10000 | 0.05 | 2 days | 1000 |  | first EnronOnLine transaction for TW, new shipper
EnronOnLine |  |  |  | ? |  | launched electronic capacity trading system for Transwestern
Oasis Pipeline |  |  |  | ? |  | executed new dollar-valued OBA, cancelled old volumetric OBA
Pogo |  |  |  | ? |  | completed new facility interconnect, unfortunately dry well
Virginia Power | 50000 | [NAME] | 1 year | ? |  | new shipper on TW, with incremental revenue opportunities
CMS Marketing | 100000 | [NAME] | 1 year | ? |  | new shipper on TW, with incremental revenue opportunities
PPL Energy | 20000 | 0.38 | 30 years | $83.5 million |  | assisted with execution, continuing with maintenance
Oneok/Westex | 200000 |  |  | ? |  | assisted with new facility interconnect, ongoing marketing
 |  |  |  | ____________
 |  |  |  | $46.9 million
Spreadsheet: 777422d1650376082-fix-values-according-to-min-value-in-another-column-example
Sheet: Foglio1

 | Possible values |  |  |  | size | Min.Value
 | A |  | Increasing Values |  | 2" | L |  |  | insert data |  |  | Result
 | B | ↓ |  |  | 3" | L |  |  | size | Value |  | Fixed Value
 | C | ↓ |  |  | 4" | L |  |  | 4" | B | --> | L | because for 4" the Min.Value is "L"
 | D | ↓ |  |  | 5" | L |  |  | 4" | P | --> | P | because for 4" Value "P" is bigger than min.Value "G"
 | E | ↓ |  |  | 6" | L |  |  | 10" | B | --> | G | because for 10" the Min.Value is "G"
 | F | ↓ |  |  | 8" | G |  |  | 10" | P | --> | P | because for 10" Value "P" is bigger than min.Value "G"
 | G | ↓ |  |  | 10" | G |  |  | ...
 | H | ↓ |  |  | 12" | G
 | J | ↓ |  |  | 14" | G
 | K | ↓ |  |  | 16" | G
 | L | ↓ |  |  | 18" | G
 | M | ↓ |  |  | 20" | G
 | N | ↓ |  |  | 22" | G
 | P | ↓ |  |  | 24" | G
 | Q | ↓
 | R
Spreadsheet: 76927d1277385888-display-most-current-answer-in-monthly-results-list-widgets
Sheet: Completed Inspections 

Maintain productivity at an average of at least 12 completed widgets per day.
Month |  | Number of widgets Completed | Number of Working Days Per Month | Number of Full Time Widgeters | Average Number of Completed widgets per widgeters |  |  |  |  | YTD Average
January | #N/A | 3000 | 22 | 10 | 13.63636363636364
February | #N/A | 2900 | 21 | 11 | 12.55411255411255 | 5900 | 43 |  | 21 | 13.06755260243632
March | #N/A | 3100 | 21 | 11 | 13.41991341991342 | 9000 | 64 |  | 32 | 13.18359375
April | #N/A | 2800 | 21 | 10 | 13.33333333333333 | 11800 | 85 | 0 | 42 | 13.22128851540616
May | #N/A | 2900 | 22 | 10 | 13.18181818181818 | 14700 | 107 |  | 52 | 13.2099209202013
June | #N/A |  |  |  | 0 | 14700 | 107 |  | 52 | 0
July | #N/A |  |  |  | 0 | 14700 | 107 |  | 52 | 0
August | #N/A |  |  |  | 0 | 14700 | 107 |  | 52 | 0
September | #N/A |  |  |  | 0 | 14700 | 107 |  | 52 | 0
October | #N/A |  |  |  | 0 | 14700 | 107 |  | 52 | 0
November | #N/A |  |  |  | 0 | 14700 | 107 |  | 52 | 0
December | #N/A |  |  |  | 0 | 14700 | 107 |  | 52 | 0
Year to Date |  | 14700 | 107 | 52 | 31.70381020848311
REPORTING: DIFFERENT WORKBOOK TO PICK UP THE MOST CURRENT YTD. IN THE EXAMPLE ABOVE, MAY. BUT THEN, SELECT JUNE ONCE
THERE IS JUNE DATA IN K 14.
Spreadsheet: 808737d1670606776-top-ten-percentile-s666-pq_amjad-sample-period_end_p11_2022-test_v2
Sheet: Entries calculation

Lane_State | Sample data | Entries | I need 10% entries with maximum number
CA--->ON | Week 41 have | 87
CA--->ON | Week 42 have | 78
CA--->ON | Week 43 have | 91
CA--->ON | Week 44 have | 6
Spreadsheet: 128556d1321089731-sum-total-of-specific-criteria-book2
Sheet: Sheet1

 |  |  | total value contract | opportunity stage
 |  |  | 1070 | Close Opportunity
 |  |  | 1631 | Close Opportunity
 |  |  | 709 | Close Opportunity
 |  |  | 1338 | keep trying
 |  |  | 35 | Close Opportunity
 |  |  | 20 | n/a
 |  |  | 3500 | Close Opportunity
 |  |  | 500 | n/a
 |  |  | 100000 | Keep trying
 |  |  | 70000 | Close Opportunity
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 15 March 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-03-15 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS | Emergency Leave (Comp off)
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 845171d1696685673-sum-values-of-matched-input-with-pool-of-texts-or-word-bank-excelforum3
Sheet: Sheet1

 |  | Companies | Emps | Hrs. |  |  |  |  |  | Company List name | Word Bank
 |  | Company1 | 1 | 348 |  |  |  |  |  | Company1 | Company   1 | Company1 | 1 -Company 1 | Company 1- | 1 -Company
 |  | Company-2 | 1 | 299 |  |  |  |  |  | Company2 | Company 2 | Company-2
 |  | Company   1 | 3 | 884 |  |  |  |  |  | Company3 | 3- Company3 | Company-3
 |  | Company4- | 3 | 936 |  |  |  |  |  | Company4 | Company4- | Company4 | [NAME]
 |  | Company1 | 64 | 5421
 |  | Company3 | 2 | 753
 |  | Company4 | 5 | 1058
 |  | 1 -Company 1 | 1 | 966
 |  | Company 1- | 1 | 314
 |  | [NAME] | 64 | 14416
 |  | Company2 | 8 | 2444
 |  | 1 -Company | 1 | 216
 |  | 3- Company3 | 2 | 753
 |  | Company-3 | 1 | 216
 |  | Company 2 | 10 | 999
 |  |  |  |  |  | Required Output Table Sum of Company Name
 |  |  |  |  |  | Companies | Emps | Total Hrs.
 |  |  |  |  |  | Company1 | 71 | 8149
 |  |  |  |  |  | Company2 | 19 | 3742
 |  |  |  |  |  | Company3 | 5 | 1722
 |  |  |  |  |  | Company4 | 72 | 16410
Spreadsheet: 845155d1696679239-calculating-minutes-and-rewards-over-time-rewards-and-sanctions
Sheet: Week 3

Name | Reward | 5 Min | 10 Min | No. Time outs | Total Min in time out this week | Orange | Red | Reward Total | Average Reward For Week | Total no. Time outs
Test | 20 | 1 | 2 |  |  | Yes | Yes
Kelly | 25 | 2 | 0
[NAME] | 15 | 1 | 1
Arya | 30 | 3 | 1 |  |  | Yes
[NAME] | 10 | 0 | 2 |  |  |  | Yes
Spreadsheet: 186583d1350089712-combining-several-duplicate-rows-summing-one-column-and-removing-original-duplicates-todedupe2
Sheet: Current

Category | SKU | Title | D | Image # | Brand | Fabric | Color/Description** | [NAME] | Euro | Retail Price | Price | Qty | Clearance (Y) | Tack Room
Dress Shirts | Dshrt-4387 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 15.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4388 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 15.75 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4389 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 15.75 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | [NAME] |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 15.75 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | [NAME] |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4392 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4393 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4394 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4395 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4396 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4397 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4398 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4399 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 17 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4400 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 17 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4400-1 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 16 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Dress Shirts | Dshrt-4400-2 |  |  | 24757,24758 | Finamore | Cotton | Cotton candy pink/white stripe dress shirt | 17.5 |  | 495 | 149 | 1 | Y |  | Medium Spread | Barrel | No
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-24-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 07ad4830-ec64-47f1-a3b3-ac096b5ed9cd
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
 | CITY & COUNTY OF SAN FRANCISCO |  |  |  |  |  |  |  |  | Page____of____
 | LEASED EQUIPMENT DETAIL REPORT
Acct # |  |  |  |  |  |  | Return with Declaration to:
OWNER |  |  |  |  |  |  | Assessor-Recorder |  |  | 2012
DBA |  |  |  |  |  |  | 875 Stevenson St #300
ADDRESS |  |  |  |  |  |  | San Francisco, CA 94103
 |  |  | How Aquired | Lease Information |  |  | Cost or Selling Information |  |  | Assessor Use Only
Lease | Name of Lessee | Quantity | (a) Purchased | Date | Duration | Monthly | Year | Original | Selling
or I.D. | and | and | (b) Mfg | of | in | Rent | Acq'd/ | Cost* | Price* | Factor | FCV
Number | Location of Property | Description of Property | (c) Explain | Lease | Months |  | Mfgd
 | *Includes Sales Tax, Freight, Installation, etc. |  |  |  | Totals
Spreadsheet: 885975d1735916930-conditional-formatting-formulas-pivot-tables-example
Sheet: Data

SUPPLIER | LOT DETAILS
SUPPLIER | REFERENCE | TOTAL  OPTION 1 | MIN | MAX | AVG
Supplier 1 | Code 1 | 1638.702 |  |  |  |  |  |  |  | Lower Than 10%
Supplier 1 | Code 2 | 3749.328 |  |  |  |  |  |  |  | Within 10%
Supplier 1 | Code 3 | 3397.68 |  |  |  |  |  |  |  | Higher Than 10%
Supplier 1 | Code 4 | 3006.596103896104
Supplier 1 | Code 5 | 10556.22857142857
Supplier 1 | Code 6 | 10668.84
Supplier 1 | Code 7 | 10310.4
Supplier 1 | Code 8 | 7535.466666666667
Supplier 1 | Code 9 | 11639.50666666667
Supplier 1 | Code 10 | 6771.093333333333
Supplier 2 | Code 1 | 1139.85
Supplier 2 | Code 2 | 3313.8
Supplier 2 | Code 3 | 2938
Supplier 2 | Code 4 | 2858.59
Supplier 2 | Code 5 | 9385.98
Supplier 2 | Code 6 | 8460.27
Supplier 2 | Code 7 | 8750.4
Supplier 2 | Code 8 | 5607.82
Supplier 2 | Code 9 | 9646
Supplier 2 | Code 10 | 5032.059999999999
Supplier 3 | Code 1 | 804.6
Supplier 3 | Code 2 | 4655.1
Supplier 3 | Code 3 | 4217.2
Supplier 3 | Code 4 | 1010.4
Supplier 3 | Code 5 | 13463.19
Supplier 3 | Code 6 | 12874.68
Supplier 3 | Code 7 | 12148.8
Supplier 3 | Code 8 | 8155.02
Supplier 3 | Code 9 | 14023.8
Supplier 3 | Code 10 | 7113.76
Supplier 4 | Code 1 | 2467.44
Supplier 4 | Code 2 | 5628.200000000001
Supplier 4 | Code 3 | 5059.6
Supplier 4 | Code 4 | 6668.64
Supplier 4 | Code 5 | 12362.25
Supplier 4 | Code 6 | 14266.98
Supplier 4 | Code 7 | 11217.6
Supplier 4 | Code 8 | 7729.160000000001
Supplier 4 | Code 9 | 13407.94
Supplier 4 | Code 10 | 11611.26
Spreadsheet: 31422b65-0d8f-485e-b089-48d6ec6f793f
Sheet: SpecificProcedures

Allowed CCAD Specific Procedure | Specific Procedure used in Model
Anomalous coronary artery repair | Anomalous coronary artery repair
Aortic root replacement (not [NAME]) | Low volume group
Aortic Valve Replacement - non Ross | Aortic Valve Replacement - non Ross
Aortic valve replacement - Ross | Aortic valve replacement - Ross
Aortic valvoplasty | Aortic valvoplasty
Aortic valvotomy | Aortic valvotomy
Aortopulmonary window repair | Low volume group
Arterial shunt | Arterial shunt
Arterial switch (for isolated transposition) | Arterial switch (for isolated transposition)
Arterial switch + VSD closure | Arterial switch + VSD closure
ASD repair | ASD repair
Atrioventricular septal defect (complete) repair | Atrioventricular septal defect (complete) repair
Atrioventricular septal defect (partial) repair | Atrioventricular septal defect (partial) repair
Atrioventricular septal defect and tetralogy repair | Low volume group
AVR - non [NAME] | Aortic Valve Replacement - non Ross
AVR - Ross | Aortic valve replacement - Ross
Bidirectional cavopulmonary shunt | Bidirectional cavopulmonary shunt
Cor triatriatum repair | Low volume group
Fontan procedure | Fontan procedure
Heart Transplant | Heart Transplant
Interrupted aortic arch repair | Interrupted aortic arch repair
Isolated coarctation repair | Isolated coarctation repair
Isolated coarctation repair | Isolated coarctation repair
Isolated Pulmonary artery band | Isolated Pulmonary artery band
Mitral valve replacement | Mitral valve replacement
Multiple VSD Closure | Low volume group
Norwood procedure (Stage 1) | Norwood procedure (Stage 1)
PDA ligation (surgical) | PDA ligation (surgical)
[NAME] atresia VSD repair | [NAME] atresia VSD repair
[NAME] valve replacement | [NAME] valve replacement
[NAME] procedure | [NAME] procedure
Repair of total anomalous pulmonary venous drainage | Repair of total anomalous pulmonary venous drainage
Senning or Mustard procedure | Low volume group
Subvalvar aortic stenosis repair | Subvalvar aortic stenosis repair
Supravalvar aortic stenosis repair | Supravalvar aortic stenosis repair
TAPVD Repair + Arterial Shunt | Low volume group
Tetralogy repair | Tetralogy repair
Tetralogy with absent pulmonary valve repair | Low volume group
Tricuspid valve replacement | Low volume group
Truncus and interruption repair | Low volume group
Truncus arteriosus repair | Truncus arteriosus repair
VSD Repair | VSD Repair
 | No specific procedure
Spreadsheet: 489235d1479151206-urgent-help-vlookup-scorecard-november
Sheet: SP

 | Onboarding | VR | Compliance | [NAME] | Abbvie | QA | Medical Group | Market Access | CVS | Invalidation Queue | Rotation | Others | Vacation | Sick/Emergency | MISC | System Issues | Coaching | Meeting | Total Minutes | Remarks
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Isabella Comia
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Reyes
[NAME]
[NAME]
Morena Untiveros
[NAME]
[NAME]
[NAME]
[NAME]
 | Onboarding | VR | Compliance | [NAME] | Abbvie | QA | Medical Group | Market Access | CVS | Invalidation Queue |  | Others | Vacation | Sick | MISC | System Issues | Coaching | Meeting | Total Minutes | Remarks
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Isabella Comia
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Reyes
[NAME]
[NAME]
Morena Untiveros
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 193143d1352742284-3-level-matrix-dynamicnamedrangedvlist
Sheet: Sheet2

listA | listB | [NAME] |  |  |  |  | 50 | 50
40 | 40 | 40
45 | 45 | 60
50 | 40 | 30
50 | 50 | 70
50 | 50 | 120
60 | 40 | 30
60 | 40 | 40
Spreadsheet: 848393d1699112323-profitability-calculation-with-formulas-and-formatting-book3-fusionista-
Sheet: Sheet5

 | Initial investment: | 1000 |  | Length of period: |  | 20
 | Income 1st year: | 5
 | Income change per year.: | 0.03
 | Invstment value change per year.: | 0.02
 |  | 0
 | Initial investment
 | Income
 | Ending value
 | Total cash flow
 | IRR
 | Example of 3 year period:
 |  | 0 | 1 | 2 | 3
 | Initial investment | -1000
 | Income |  | 5 | 5.15 | 5.3045
 | Ending value |  |  |  | 1040.4
 | Total cash flow | -1000 | 5 | 5.15 | 1045.7045
 | IRR | 0.01837191317310838
 | Example of 20 year period:
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Initial investment | -1000
 | Income |  | 5 | 5.15 | 5.3045 | 5.463635 | 5.627544049999999 | 5.796370371499999 | 5.970261482644999 | 6.14936932712435 | 6.33385040693808 | 6.523865919146222 | 6.719581896720609 | 6.921169353622227 | 7.128804434230894 | 7.342668567257819 | 7.562948624275555 | 7.789837083003822 | 8.023532195493935 | 8.264238161358753 | 8.512165306199517 | 8.767530265385501
 | Ending value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1456.811172527798
 | Total cash flow | -1000 | 5 | 5.15 | 5.3045 | 5.463635 | 5.627544049999999 | 5.796370371499999 | 5.970261482644999 | 6.14936932712435 | 6.33385040693808 | 6.523865919146222 | 6.719581896720609 | 6.921169353622227 | 7.128804434230894 | 7.342668567257819 | 7.562948624275555 | 7.789837083003822 | 8.023532195493935 | 8.264238161358753 | 8.512165306199517 | 1465.578702793184
 | IRR | 0.0245278895159291
Spreadsheet: 1215b678-aa91-4410-8a16-77beb51d9314
Sheet: Sheet1

Start Date | End Date | Meeting Name | HQ Hotel | Venues | Attendees
2014-04-19 00:00:00 | 2014-04-19 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
2014-06-04 00:00:00 | 2014-06-04 00:00:00 | Clark County School District Veterans Tribute CTA Graduation | Cashman Center | Cashman Center | 2000
2014-10-25 00:00:00 | 2014-10-25 00:00:00 | Seventh-Day Adventist Church Nevada / Utah Conference Las Vegas Convocation | Cashman Center | Cashman Center | 5000
2014-11-19 00:00:00 | 2014-11-19 00:00:00 | Project Homeless Connect | Cashman Center | Cashman Center | 2000
2014-11-22 00:00:00 | 2014-11-22 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
Spreadsheet: 137818d1327400124-two-dimentional-search-for-non-exact-results-prova
Sheet: Foglio1

950 | 350
 | xxx | 915 | 1120 | 1830 | 2135
 | 305 | 1 | 2 | 3 | 4
 | 610 | 2.25 | 3.25 | 4.25 | 5.25
 | 1525 | 3.5 | 4.5 | 5.5 | 6.5
 |  | 1
Spreadsheet: 198001d1354634285-numbers-are-disappearing-when-linking-to-another-worksheet-workbook131-clean-b
Sheet: REPARTEE B

Base Numbers
4 | 10 | 15 | 16 | 19 | 24 | 25 | 26 | 32 | 35 | 36 | 34 | 39 | 50 | 52 | 55 | 59 | 67 | 69 | 72 | 74 | 80
Spreadsheet: 698782d1602173895-combining-formulas-indirect-and-lookup-and-vlookup-excel-indirect-lookup-v2
Sheet: Overview

 | App1 | App2 | App3 | App4 | App5 |  | English formula used in B2 & B3
Data1 |  |  |  |  |  |  | =INDIRECT(B1&"!B3")
Data2 |  |  |  |  |  |  | =LOOKUP(2;1/(1-ISBLANK('App1'!B:[NAME]:B)
Data3
Data4 |  |  |  |  |  |  | 15 different Applications (row 1)
Data5 |  |  |  |  |  |  | Each application have 20 data points (col 1)
Data6 |  |  |  |  |  |  | There is a sheet per application
Data7
Data8 |  |  |  |  |  |  | I would like to get the last value of Data1, Data2, Data3 per Application
Data9 |  |  |  |  |  |  | but to minimize manual correction of formula.
Data10
 |  |  |  |  |  |  | So goal is formula should pick something like formula in H2 to find right sheet
 |  |  |  |  |  |  | then use formula in H3 to get last cell (all numbers)
 |  |  |  |  |  |  | then use vlookup? to get data for Data1, Data2, Data3
 |  |  |  |  |  |  | How of this possible to combine into 1 formula which can be copied out to
 |  |  |  |  |  |  | each application & data set?
Spreadsheet: 879771d1727331953-capture-data-from-multiple-sheets-sample-data-new-
Sheet: 312-XYZ

 |  |  | GAP
 |  |  | BU2424 | BU2525 | BU2424 | BU2525 | BU2424 | BU2525
 |  |  | 105 OOO | 105 OOO | 120 PPP | 120 PPP | 122 QQQ | 122 QQQ
PN | Buyer | Type | Total | Total | Total | Total | Total | Total
312X | [NAME] | JJ | 10 |  | 20 |  | 100 | 90
312X | Mint | MM |  | 70 |  | 20
312X | Mark | CC | 30 |  | 10 |  | 40
312X | New | JJ |  | 80 |  | 10 |  | 10
312X | Neo | MM | 50 |  | 60 |  | 20
312X | Nick | CC |  | 10 |  | 30 |  | 10