tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 781227d1653068267-toc-that-notifies-if-todays-date-occurs-in-any-other-wkbk-sheets-01-attorney-tracking-template-forum
Sheet: Sample Sheet (2)

email | fp_id | first_name | middle_name | last_name | title | firm | location | phone | bar_admissions | practice_areas | specialties | law_school | graduation_year | undergraduate | advanced_degree | raw_education | languages | profile_url | sectors_primary | jobs_practice_primary | jobs_practice_secondary | degree | leadership_matches | Deposition/Notes
[EMAIL] | 1 | [NAME] | G. | Mcleod | of counsel | Adams And Reese Llp | Alabama-Birmingham | [PHONE] | Alabama, Texas | Litigation | Appellate, Professional Liability | University of Alabama | 2008 | University of Mobile |  | Education University of Alabama School of Law, J.D., 2008 University of Mobile, B.A., 2004 |  | https://www.adamsandreese.com/people/aaron-mcleod | appellate work, trial work | commercial litigation | appellate litigation, personal injury/death litigation, lawyer/firm defense litigation, insurance litigation, professional liability litigation, education/research litigation, real estate litigation |  |  | Geographical Interests: Firm Size Interests: Partnership Interests: Practice-based Interests: Remote Work Interests:  Notes:
 |  |  |  | Resume Send | Resume Follow Up |  |  | [NAME] back and forth with firm until the date/time is scheduled. |  |  | Int. Follow Up Firm |  |  | Int. Sched-Prep 2 |  |  | Int. Follow Up Firm |  |  | Offer-Close
Firm-side |  |  |  | Resume Send | Resume Follow Up |  |  | Interview Schedule/Prep |  |  | Interview 1 Follow Up |  |  | Interview Schedule/Prep |  |  | Interview 2 Follow Up |  |  | Offer/Close - Firm
Notes | Law Firm | Name | Hiring Partner - Email | Initial Send | 1 | 2 | 3 | Interview 1 - Scheduled | Interviewers and details sent to Candidate. | Interview Date | 1 | 2 | 3 | Interview 2 - Scheduled | Interview Prep - Email/Scheduled | Interview Date | 1 | 2 | 3 | Offer/Close - Firm
Introduction |  |  |  |  |  |  |  | Int. Sched-Prep 1 |  |  | Interview 1 Follow Up |  |  |  |  |  | Interview 2 Follow Up |  |  | Int. Close
Candidate-side |  |  |  |  |  |  |  | Interview Schedule/Prep |  |  | Interview 1 Follow Up |  |  |  |  |  | Interview 2 Follow Up |  |  | Offer/Close - Candidate
Notes | Law Firm | Name | Candidate email | Sending Process (firm Name) | Keep Candidate Up To Date on Firm Feedback |  |  | Interview Prep - Email Sent | Interview scheduled | Interview Date | 1 | 2 | 3 |  |  | Interview Date | 1 | 2 | 3 | Offer/Close - Candidate
Spreadsheet: 88459d1288273094-formula-to-return-text-on-a-set-condition-20101027-estimate-pack
Sheet: Materials breakdown

 |  |  |  |  |  |  |  | Estimate:
Materials breakdown (inc. Sub contractors)
 |  |  |  |  |  |  | NET
Description of materials used |  |  |  |  |  | Quantity | Cost per unit |  | Total cost
Concrete to footings |  |  |  |  |  | 1 | 85
Trench block 300mm
Commons to DPC
Class B to DPC
100x75 Concrete lintels at 0.6m
Tons of MOT
Sheets of 100mm polystyrene insulation
Sheets of 75[NAME] insulation polystyrene
Rolls of Visqueen 1200g DPM
Sheets of A193 mesh
Concrete to floor slab
450 Manholes with 1m risers and lids
[NAME]
Bends (assorted)
Rest bends
Junctions
Pipe 110mm
Grease
Packs of wallstarters
Rolls of 100mm DPC
Rolls of 225mm DPC
Roll of 600mm DPC
Weepholes
Facing bricks
100mm Stranlite Blocks
100mm Theramalite block
Dritherm insulation 100mm
Dritherm insulation 85mm
Wall ties 225mm
CB70 at 1.5m
CB70 at 1.8m
CB70 at 2.7m
CB70 at 0.75m
CB70 at 0.9m
CB70HD at 2.1m
100x150 Concrete lintels at 1.2m
Roof trusses
Ladder end set
Roof trusses
125x50 at 3.6m Spars
100x50 at 6m wallplate
Backplate 125x50/6m
50x50
Valley set
100x25 Bracing
170x50 Floor joists
Restraint irons 1.5x0.5mm
Eaves trays
100x50
Over [NAME] vents
175x100
225x25 uPVC fascia
300mm uPVC Flat board
150mm Flat board
200mm Flat board
Corners
Jointers
Boxes of 65mm Nails
Boxes of 50mm nails
Gutter
Brackets
Stop ends
Running outlets
Offsets
Unions
Downspout
Brackets
[NAME] (*******)
Ridges
Dry Ridge
Dry verge
Tile Batten
Rolls of Felt
Sheets of 22[NAME] chipboard
75x50 Scant at 2.4m
Internal door casings
38x38
50x50
225x25
275mm Windowboard
Windows 600x1050 - 2.2x1050 1.2x1050
Clips and silicone
Conservatory separate price (GHW)
Sheets of 12.5mm Duplex
Sheets of 12.5m Tapered edged boards
[NAME] of board finish
[NAME] of dry lining adhesive
Scrim
Sound deadening
Skim beads
Screws
Nails & fixings
Internal doors and furniture
75mm Architrave MDF PR
125mm Skirting MDF PR
[NAME] c/c toilet and seat
Vanity unit (Aquadelva)
[NAME] tray and door (no side panel)
700x1700 Genova Bath
Cloakroom basin
Sets of taps (Roca)
Showers (Grohe 1000ev)
Plumbing materials ******** and wastes
Heating [NAME], Radiators & valves
Wall tiling
Floor tiling
Ton bags of building sand
Bags of Cement
Plasticiser
Scaffold
Skips
Tons of Pipe Bedding
Toilet
Plant
[NAME]
Decorating
Suntube to Landing
Labourer
PC sum Electrics
PC sum Plumbing
PC sum Plastering
Tiling to Conservatory Floor
Air Bricks
Vent Pipes 100m drain
Liners Telescopic
Ton of Pipe bedding
Door firths sliding sash door low cill (20mm)
Lead 9m of 300mm code 4
Insulation 100m [NAME] type
Insulation 25mm Kingspan type
Tough coat
Multi Finish
Garden wall Stone (as site)
Flags - mid range
Aco drainage or similar
Grit sand
Cement
10no 4ftx9" posts 9 bases 9 Panels ('2')
Concrete
Skips
 |  |  |  |  |  |  |  | Subtotal
 |  |  |  |  |  |  |  | Mark-up (20%)
 |  |  |  |  |  |  |  | Total cost of materials
Spreadsheet: 697672d1601473865-search-formula-for-several-results-with-3-search-criteria-geraetkartei_table_forum
Sheet: Access point sensorik

 | Gerät | 17i | <---- Criteria 1
 | Zelle / Kanal | NOx | <----- [NAME]
 | Display kommastellen bereich |  |  |  |  |  |  |  |  | [NAME] | Modell liste
 |  |  |  |  |  |  |  |  |  |  | 17i
 |  |  |  |  |  |  |  |  |  |  | 42i-HL
Spreadsheet: 854130d1704110585-choose-col-with-with-filter-choose-cols-filter-data-added_glen
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 1 | 75 | The  American Insurance Company Limited. (409024794) |  |  |  |  |  |  | 30 |  |  |  |  |  | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland (300700851) |  |  |  |  |  |  | 40.4 |  |  |  |  |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd (300494201) |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 7 | 9 | [NAME] ([NAME] (200010449 (Main)) |  |  |  |  |  |  | 60 |  |  |  |  |  | 45 | 40
 | x | 2
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd (900049782) |  |  |  |  |  |  | 2 |  |  |  |  |  | 9 | 11
 | 145 |  | Jenite Licohetic (606916857)
 |  |  | [NAME].Ltd. (609747221)
 |  |  | Asimbia Pokiol
 |  |  | Agraj Foods Pvt.Ltd,Kathmandu (304463444)
 |  |  | Aarti Soap & Chemical Industries Pvt Ltd,Birkune (300020639) | 4286.39 | 0 | 0 | 4286.39 |  |  |  | #N/A | << NO MES >> | #N/A | SAM |  | 0 | 0
 |  |  | Aashis Plastic Traders (600443562) |  |  |  |  |  |  |  | #N/A | << NO MES >> | #N/A | SAM |  | 0 | 0
 |  |  | Alive Pharmaceutical Pvt. Ltd.,Nrt (300270330) | 12453.5 | 0 | 12453.5 | 0 |  |  |  | #N/A | << NO MES >> | #N/A | SAM |  | 0 | 0
Spreadsheet: 803149d1667292123-how-to-find-and-locate-results-with-id-via-hyperlink-sample-hyperlink
Sheet: Cover

ID | Task | Status | [NAME] to Task | Target:
 | Task 10 | Open |  | 05.5 - 00
05.6 - 00 | Task 11 | Open |  | 05.6 - 00
05.9 - 00 | Task 14 | Open |  | 05.9 - 00
05.10 - 01 | Task 15 | Open |  | …
05.24 - 00 | Task 16 | Open |  | …
05.28 - 00 | Task 19 | Open |  | …
04.3 - 00 | Task 2 | Open |  | …
05.29 - 00 | Task 20 | Open |  | …
05.32 - 00 | Task 22 | Open |  | …
04.4 - 00 | Task 3 | Open |  | …
04.6 - 01 | Task 6 | Open |  | …
04.7 - 01 | Task 7 | Open |  | …
05.2 - 00 | Task 8 | Open |  | …
05.3 - 00 | Task 9 | Open |  | …
 | 0 | 0
Spreadsheet: 838116d1690740678-if-formula-returning-incorrect-value-rota-sample
Sheet: Sheet1

 | Start | Finish | 05:00:00 | 05:15:00 | 05:30:00 | 05:45:00 | 06:00:00 | 06:15:00 | 06:30:00 | 06:45:00 | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00 | 23:15:00 | 23:30:00 | 23:45:00 | 1900-01-01 00:00:00 | 1900-01-01 00:15:00 | 1900-01-01 00:30:00 | 1900-01-01 00:45:00 | 1900-01-01 01:00:00 | 1900-01-01 01:15:00 | 1900-01-01 01:30:00 | 1900-01-01 01:45:00 | 1900-01-01 02:00:00 | 1900-01-01 02:15:00 | 1900-01-01 02:30:00 | 1900-01-01 02:45:00 | 1900-01-01 03:00:00 | 1900-01-01 03:15:00 | 1900-01-01 03:30:00 | 1900-01-01 03:45:00 | 1900-01-01 04:00:00 | 1900-01-01 04:15:00 | 1900-01-01 04:30:00 | 1900-01-01 04:45:00
Name 1 | 20:00:00 | 01:00:00
Name 2 | Sick | 00:00:00
Name 3 | Hols | 00:00:00
Name 4 | 18:00:00 | 00:30:00
Name 5 | 19:30:00 | 01:00:00
Name 6 | 20:30:00 | 01:00:00
Name 7 | Hols | 00:00:00
Spreadsheet: 814266d1674246104-how-to-add-another-series-to-calculation-depending-on-how-many-data-points-i-have-twr-calculation-jared1097-
Sheet: Sheet1

 |  |  |  |  |  |  | rate of return |  |  |  | account balances |  |  | all amounts are in usd
 | starting balance | deposit/withdrawl | ending balance | sub period rate of return | 1+ sub period rate of return | january |  |  |  | date | [NAME] | itrade | total
2023-01-01 00:00:00 | 9223 |  | 10000 |  |  | february |  |  |  | 2023-01-01 00:00:00 | 1601 | 7622
2023-01-13 00:00:00 |  | 5000 | 17000 |  |  | march |  |  |  | 2023-02-01 00:00:00
2023-01-31 00:00:00 |  |  | 15000 |  |  | april |  |  |  | 2023-03-01 00:00:00
2023-02-05 00:00:00 |  |  |  | 0 |  | may |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  | june |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  | july |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  |  | august |  |  |  | 2023-07-01 00:00:00
 |  |  |  |  |  | september |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  |  | october |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  |  | november |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  | december |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2023-12-01 00:00:00
 |  | ((1+E3)*(1+E4)*(1+E5)-1) |  | formula for rate of return is add 1 to sub period rate of return and multiply by all others in same month then subtract 1 from the product
 |  |  |  | start balance at month beginning and end balance before deposit is nessesary. As is end balance at end of the month
 |  |  |  | balance will be combined balances across trading platforms.
Spreadsheet: 80369d1280531492-replace-remove-exact-words-advfilter-formula
Sheet: Sheet2

list1
col mmm | 1 | 1
collars |  |  | 0 |  |  | list range is a1:a11
color |  |  |  | 0 |  | criteria range is c1:e4
col b | 2
a col b | 3
a col | 4
a collar
collar sbbb
no collar
but col | 5
Spreadsheet: 687093d1594951321-calculate-total-in-range-that-are-before-specific-time-sample-3-
Sheet: Change format

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700
 |  |  |  |  |  |  |  |  | Time Opened | Time Closed | Hours   Open |  |  |  |  |  | 1800
 |  |  |  |  |  |  |  | A | 1700 | 2200 | 3 |  |  |  |  |  | 1900
 |  |  |  |  |  |  |  | B | 1700 | 2150 | 2.75 |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  | C | 1700 | 2305 | 6 |  |  |  |  |  | 2100
 |  |  |  |  |  |  |  | D | 1700 | 2315 | 6.25 |  |  |  |  |  | 2200
 |  |  |  |  |  |  |  | E | 1700 | 2110 | 2.25 |  |  |  |  |  | 2300
 |  |  |  |  |  |  |  | F | 1700 | 1820 | 1.25 |  |  |  |  |  | 2400
Time | Open
1700
Total
Spreadsheet: 03cf4d69-4fce-4989-82ec-888f8cdb635d
Sheet: Sheet1

MINORS and MAJOR AREAS By FACULTY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2012-13
MINOR | FACULTY of MAJOR AREA
 | APHS | BUSI | HUMA | MASC | SOSC | OTHER | SUB-TOTAL | SHARE
BUSI | 23 | 0 | 11 | 10 | 35 | 0 | 79 | 0.08710033076074973
HUMA | 26 | 6 | 235 | 20 | 134 | 5 | 426 | 0.4696802646085998
MASC | 6 | 4 | 16 | 36 | 9 | 0 | 71 | 0.0782800441014333
SOSC | 52 | 3 | 116 | 11 | 148 | 1 | 331 | 0.3649393605292172
UNIVERSITY TOTAL | 107 | 13 | 378 | 77 | 326 | 6 | 907 | 1
 | 0.1179713340683572 | 0.0143329658213892 | 0.4167585446527012 | 0.08489525909592062 | 0.3594266813671445 | 0.006615214994487321 |  | 0
Note: * Major areas by Faculty for students with a minor.
Spreadsheet: benjamin_rogers__1011__TVADraw121499
Sheet: Caledonia

Enron Capital & Trade Services
Business Analysis & Reporting
Power Plants - 1999
 |  | 1998 | 1999
 |  | Total | January | February | March | April | May | June | July | August | September | October | November | December | Total
Capital
Caledonia, MS
( [NAME]:  [NAME])
GE 7EA's (6ea) |  | 37377776 | 6859220 | 6859220 | 12326714 | 12919710 | 15213392 | 0 | 0 | 3280101 | 0 | 0 | 4852796 | 1940179
ABB |  | 1897561 | 4007308 | 0 | 615000 | 1398550 | 821775 | 445570 | 0 | 0 | 1100956 | 0 | 0 | 1
EECC |  | 232364 | 0 | 0 | 0 | 0 | 0 | 316915 | 143865 | 41523 | 0 | 27419 | 10884
NEPCO |  | 167072 | 899776 | 810086 | 1831143 | 0 | 3372514 | 2932107 | 9360536 | 4662889 | 2317012 | 1167995 | 960719
EI (Mobilization of O&M) |  | 0 | 0 | 0 | 0 | 72162 | 162075 | 232977 | 64037 | 17168 | 19696 | 464 | 0 | 0
PARTS |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 157467 | 525706 | 11614 | 1988 | 91025
LAND |  | 532310 | 0 | 0 | 22050 | 0 | 3333 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ENVIR PERMITTING |  | 207085 | 0 | 0 | 0 | 0 | 29791 | 0 | 0 | 227 | 0 | 250 | 0 | 0
GAS INTERCONNECT |  | 738500 | 0 | 242359 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 141
ELECT INTERCONNECT |  | 0 | 110523 | 0 | 0 | 1651484 | 0 | 59847 | 230834 | 864906 | 146302 | 0 | 3218 | 440706
START UP FUEL |  | 0 | 0 | 0 | 0 | 10000 | 53741 | 61014 | 11281 | 0 | 0 | 0 | 0 | 0
SALES TAX |  | 280627 | 6383 | 0 | 0 | 0 | 0 | 0 | 85968 | 0 | 0 | 0 | 0 | -272978
[NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
INSURANCE |  | 0 | 145042 | 0 | 0 | 0 | 0 | 0 |  | 0 | 38633 | 0 | 0 | 2615
SALARIES |  | 0 | 0 | 8735 | 0 | 5963 | 23696 | 9719 | 5091 | 0 | 0 | 0 | 0 | 0
DEVELOPMENT |  |  | 27824 |  | -21839 | 2188 | 205652 | 74162 | 109970 | 67695 | 29497 | 3271 | 163989 | -6113
LEGAL |  | 105274 | 6484 |  | 0 | 0 |  |  |  | 0 | 33731 | 3474 | 8180 | 1
OTHER |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0
Total Plant
Cumulative Total Plant
$$/Kw
IDC |  |  |  |  |  |  | 124517 | 725143 | 684126 | -684126 | -326769 | 0 | 0 | 0
IDC Credit on Unused Cash |  |  |  |  | -309104 | -117884
Commitment Fee |  | 0 | 11785.189 | 10279.417625 | 6207.39975 | 6088.634125 | 5897 |  |  |  |  |  | 0 | 0
Swap Gain/Loss |  |  |  |  | -5266 |  |  | 0 |  | 0 | 0 | 0 | 0 | 1
FINANCING FEE |  | 68386 | 942288 | 0 | 0 | 0 | 83333 | 0 | 0 | 0 | 0 | 0 | 83333 | 107680
CONTINGENCY |  | 0
Subtotal
Cumulative subtotal
Total Capital
Cumulative Total
$$/Kw
DEBT RESERVE |  | 0 |  |  |  |  |  | 0
Total Current month less IDC
Monthly Draw, including accr int and comm fee |  |  |  |  |  |  | 0 | 0 | 0 | 0
Cumulative Outstanding Balance |  |  |  |  |  |  | 0
Total Project Cost (w/o Debt Reserve)
Total Cumul Project Cost (w/o Debt Reserve)
Total Project Cost (with Debt Reserve)
IDC 5.75%  (Actuals through April) |  | 0.1 | 0.06367500000000001 | 0.0568969 | 0.0568813 | 0.0568719 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065 | 0.065
+ 15 Bps Com Fee (thru 5/21/99 only) |  | 0.0015
 |  | 442 | MW
 |  | Blue | Actuals
Spreadsheet: 150229d1334342082-pivot-table-pivot-table-subtotal_jpr73
Sheet: PT

Month | (Tous) |  |  |  |  | Pivot Table
 |  |  | Valeurs
Department | Mgmt Level | Division | Actual Dollars | Budget Dollars | Difference
Management | 10 | 10 | 33584.66 | 31968 | -1616.660000000003
 |  | 20 | 33592.56 | 29026 | -4566.559999999998
 | Total 10 |  | 67177.22 | 60994 | -6183.220000000001
 | 15 | 30 | 44969.62 | 42504 | -2465.620000000003
 | Total 15 |  | 44969.62 | 42504 | -2465.620000000003
Total Management |  |  | 112146.84 | 103498 | -8648.839999999997
Non Management | 10 | 30 | 60003.2 | 40050 | -19953.2
 | Total 10 |  | 60003.2 | 40050 | -19953.2
 | 15 | 10 | 79995.82 | 63538 | -16457.82000000001
 |  | 20 | 43433.13999999999 | 29884 | -13549.13999999999
 | Total 15 |  | 123428.96 | 93422 | -30006.96000000002
Total Non Management |  |  | 183432.16 | 133472 | -49960.15999999995
Total général |  |  | 295579 | 236970 | -58608.99999999994
Spreadsheet: 104014d1301640802-compare-and-fill-from-two-workbooks-example
Sheet: Workbook #1

First Name | Last Name | Full Name | Match? | ID Number
[NAME] | [NAME] | [NAME] | YES | 876556
Shane | [NAME] | [NAME] | NO
[NAME] | Oneill | [NAME] | NO
Kelly | [NAME] | [NAME] | YES | 341343
[NAME] | [NAME] | [NAME] | YES | 324353
[NAME] | Tibbo | [NAME] | YES | 965478
[NAME] | Cranford | [NAME] | NO
[NAME] | O'Neill | [NAME] | NO
[NAME] | [NAME] | [NAME] | NO
Donn | [NAME] | [NAME] | NO
[NAME] | Stymest | [NAME] | YES | 236433
I need for it to check from Workbook #2 - Column J for a full match of Workbook #1 - Column C. So if the full name matches on both sheets, there should be a YES in Workbook #1 - Column D. If there is a YES in Workbook #1 - Column D, I need it to get the ID Number from Workbook #2 - Column K for the same person listed and have it put in Workbook #1 - Column E.
Spreadsheet: 221429d1363550027-beerfest-bracket-creation-brewfest
Sheet: Bracket

 |  |  |  |  |  |  |  | WINNER'S BRACKET
 | AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AFRICA
 | Anchorman |  | Flip Cup |  | Beer Pong |  | Turbo Quarters |  |  |  |  |  |  |  |  | Turbo Quarters |  | Beer Pong |  | Flip Cup |  | Anchorman
1 | USA | 25 |  | 41 |  | 53 |  |  |  | Civil War |  |  |  |  |  |  | 54 |  | 43 |  | 29 | South Africa | 9
 | Colonial America |  |  |  |  |  |  |  | 59 |  |  |  |  |  |  |  |  |  |  |  |  | Namibia
2 | Confederacy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kenya | 10
 | Bermuda |  |  |  |  |  |  |  |  |  |  | DAS BOOT |  |  |  |  |  |  |  |  |  | Zimbabwe
3 | Bahamas | 26 |  |  |  |  |  |  |  |  |  |  |  | CHAMPS |  |  |  |  |  |  | 30 | Ivory Coast | 11
 | Canada |  |  |  |  |  |  |  |  |  | CHAMPIONSHIP |  | CHAMPIONSHIP |  |  |  |  |  |  |  |  | Egypt
4 | Cuba |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Madagascar | 12
 | Alaska |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Somolia
 | EUROPE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER
5 | France | 27 |  | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  | 31 | India | 13
 | Vatican City |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rock Nation
6 | Switzerland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sandyland | 14
 | Holland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
7 | Sweden | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | USSR | 15
 | Scotland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Naughty America
8 | Greece |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | African Ref. | 16
 | Italy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North Korea
 | Anchorman |  | Flip Cup |  | Beer Pong |  | Turbo Quarters
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Civil War
 |  |  |  |  |  |  |  |  |  |  |  |  | 61 |  | LOSER'S BRACKET CHAMPION ADVANCES TO DAS BOOT
 | Anchormand |  | Flip Cup |  | Chandeliers |  | Beer Pong | Baseball |  | Turbo Quarters |  | 40 Hands
 |  |  |  |  |  | 51 |  |  | 58
 |  | 37 |  | 47
 |  |  |  |  |  |  |  |  |  |  | 60
21
22 |  | 38
 |  |  |  |  |  |  | 5
 |  | 39 |  | 48 |  |  | 6
23 |  |  |  |  |  | 52
24 |  | 40
 |  |  |  |  |  | 49 |  |  | 57
 |  | 33 |  | 45
17
18 |  | 34
 |  |  |  |  |  |  | 5
 |  | 35 |  | 46 |  |  | 5
19 |  |  |  |  |  | 50
20 |  | 36
Spreadsheet: 828393d1683468908-summarise-a-matrix-example-108-aligw
Sheet: Sheet1

 | AR_A01 | AR_A02 | AR_A03 | AT_A01 | AT_A02 | AT_A03
AR_A01 | 1 | 28.63 | 1 | 5 | 1 | 2
AR_A02 | 2 | 92.242 | 2 | 3 | 4 | 5
AR_A03 | 11.284 | 0.067 | 3 | 0.096 | 1 | 2
BE_A01 | 0.113 | 5 | 4 | 3 | 4 | 5
BE_A02 | 5 | 6 | 5 | 0.096 | 1 | 2
BE_A03 | 1 | 6 | 6 | 3 | 4 | 5
BG_A01 | 0.034 | 23 | 7 | 0.096 | 1 | 2
BG_A02 | 0.001 | 10 | 8 | 3 | 4 | 5
BG_A03 | 3 | 12 | 9 | 3 | 4 | 5
 | A01 | A02 | A03
A01
A02
A03
Spreadsheet: 810193d1671593120-if-a-value-from-column-a-in-a-table-is-in-the-cell-return-column-b-from-the-table-s666-pq-if-a-value-from-column-a-in-a-table-is-in-the-cell-return-column-b-from-the-table
Sheet: Sheet1

Property Name | Lookup |  |  | Property Name | Lookup
Dark Wells Fargo (Ground Lease) |  |  |  | Walgreens | Walgreens
Valvoline (DARK) | Move-in Ready Building |  |  |  | [NAME] So Cal Abs Net 7.2 CAP 8 Yrs | Walgreens
Capital One (Dark Ground Lease) |  |  |  | 7-Eleven (Dark) | 7-Eleven
2 Asset Portfolio- NNN- High Yields |  |  |  | 7-Eleven | 7-Eleven
Bank Of America (Dark) |  |  |  | Dark Wells Fargo (Ground Lease) | Wells Fargo
7-Eleven (Dark) |  |  |  | [NAME] | Price Below Replacement Cost | Rite Aid
Former SunTrust Bank |  |  |  | Valvoline (DARK) | Move-in Ready Building | Valvoline Instant Oil Change
Walgreens |  |  |  | Bojangles (Dark) - 9.5 Yr Corporate Lease | Bojangles' Famous Chicken 'n Biscuits
[NAME] | Price Below Replacement Cost |  |  |  | Capital One (Dark Ground Lease) | Capital One
[NAME] So Cal Abs Net 7.2 CAP 8 Yrs
7-Eleven
Bojangles (Dark) - 9.5 Yr Corporate Lease
Circle K (Dark)
Spreadsheet: 143364d1330381793-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (18) Machine

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | Weld/Mason/Blacksmith & Machine Shops
 |  | 0
MACHINE SHOP
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
1 | clean up hydraulic oil on floor | around boring machine & nw corner | carryover
2 | repair hydraulic leak | geddings & lewis boring machine | carryover
3
4
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - Housekeeping okay, oil/water puddled on floor
ESCORT: | M. Hotchkiss
Spreadsheet: 741560d1627139193-auto-populate-table-with-start-and-end-year-expanding-fill-and-border-formatting-zainmerchant-
Sheet: Comparison BC

 |  |  |  | Business case
 |  |  |  |  |  | Scenario 1 | Scenario 2 | Scenario 3
 |  |  |  | Sales |  | 500 | 500 | 500
 |  |  |  | EBIT |  | 200 | 200 | 200
 |  |  |  | EBIT Margin |  | 0.03 | 0.03 | 0.03
 |  |  |  | Free Cashflow |  | 123 | 123 | 123
 |  |  |  | NPV |  | 23 | 23 | 23
 |  |  |  | 1. Total purchase price
 |  |  |  | 2. Total repair & inspection costs
 |  |  |  | 3. Final valuation
 |  |  |  | ROI per project
 |  |  |  | Project duration
 |  |  |  | ROI per year
 |  |  |  | Debt to equity ratio