tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 749243d1632637130-inventory-database-daily-prep-sheet
Sheet: v1

 |  | PAR Level Based Preparation
 |  | Week Ending | 2021-09-26 00:00:00
 | CATEGORIES | ITEM | SIZE | MIN | MAX | OPEN | PREP | MIN | MAX | OPEN | PREP | MIN | MAX | OPEN | PREP | MIN | MAX | OPEN | PREP | MIN | MAX | OPEN | PREP | MIN | MAX | OPEN | PREP | MIN | MAX | OPEN | PREP
 | DOUGH | Neapolitan Italian Crust | 24X12 Tray | 2 | 7 |  |  | 3 | 7 |  |  | 3 | 7 |  |  | 3 | 7 |  |  | 3 | 3 |  |  | 3 | 3 |  |  | 3 | 3
 |  | Cauliflower Crust | -
 | SAUCES | [NAME] | 5.3 L
 |  | BBQ | -
 |  | Olive Oil | -
 |  | [NAME] | -
 |  | Red Sauce | 5.3 L
 |  | Vegan Sauce | 3.7 L
 |  | White Sauce | 5.3 L
 | CHEESES | Blue Cheese | 1.53 L
 |  | Cheddar Blend | 10.6 L
 |  | Feta | 2.3 L
 |  | Fresh Mozzarella | 2.3 L
 |  | [NAME] | 10.6 L
 |  | Vegan Cheese | 2.3 L
 | PROTEINS | Anchovies | -
 |  | Bacon | 2.3 L
 |  | Chicken | 5.3 L
 |  | [NAME] | 2.3 L
 |  | Ham | 5.3 L
 |  | Pepperoni | 5.3 L
 |  | Philly Beef Steak | 2.3 L
 |  | Prosciutto | 2.3 L
 |  | Pulled Pork | 2.3 L
 |  | Sausage | 2.3 L
 |  | Eggs | 3.7 L
 | VEGETABLES | Artichoke | 2.3 L
 |  | Banana Pepper | 2.3 LK
 |  | Basil | 1.53 L
 |  | Black Olive | 2.3 L
 |  | Blueberries | 2.3 L
 |  | Celery | 1.53 L
 |  | [NAME] | 2.3 L
 |  | Green Onion | 1.53 L
 |  | Green Pepper | 2.3 L
 |  | Jalapeno | 2.3  L
 |  | [NAME] | 1.53 L
 |  | Mushrooms | 2.3 L
 |  | Peach | 2.3 L
 |  | Pickle | 2.3 L
 |  | Pineapple | 2.3 L
 |  | Red Onion | 2.3 L
 |  | Spinach | 10.6 L
 |  | Tomato | 2.3 L
 |  | Yellow Onion | 2.3 L
Spreadsheet: 755252d1636734498-articles-by-client-ef1557_products
Sheet: Folha1

Nº CLIENT | NAME | Nº ARTICLE | NAME ARTICLE | PRICE | DISCOUNT | FINAL PRICE |  | Helper
1 | [NAME] | 001 | COFFEE | 10 | 0.2
1 | [NAME] | 00456 | BEER | 15.5 | 0.2
3 | [NAME] | 001 | COFFEE | 10 | 0.15
4 | LOUIS | 0010500 | SANDWICH | 8.4 | 0.11
5 | JEAN | 00107107 | STRAWBERRIES | 4 | 0.25
5 | JEAN | 0012345 | POTATOES | 2.5 | 0.25
5 | JEAN | 000101 | ORANGES | 3.5 | 0.25
5 | JEAN | 00342 | GRAPE | 7 | 0.25
6 | ROSE | 00107107 | STRAWBERRIES | 4 | 0.14
7 | PETER | 00107107 | STRAWBERRIES | 4 | 0.12
7 | PETER | 001 | COFFEE | 10 | 0.11
Spreadsheet: dutch_quigley__9238__011203 GIS 2
Sheet: Deal Sheet for Printing

 |  |  |  |  |  |  |  |  |  |  |  |  |  | PURCHASE BEHIND  PLANT |  |  |  |  |  | DEDICATED RESERVES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME PLANT:________________ |  |  |  |  |  | FIRST PURCHASER
Enron Captial & Trade Resources Corp.
 |  |  |  |  |  |  |  | Executed Deal Ticket |  |  |  |  |  | DEAL NUMBER |  |  |  |  | Deal | #________________
COUNTERPARTY/CUSTOMER |  |  | CONTACT |  |  |  |  | ORIGINATOR |  |  | DEAL DATE |  |  | TRANSACTION TYPE(SWAP, CAP, INDEX, ETC.)
Grupo Industrial Saltillo |  |  | [NAME] |  |  |  |  | [NAME] |  |  | 2001-12-03 00:00:00 |  |  | Swap
ECTR COUNTERPARTY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHYSICAL DELIVERY POINT/PIPELINE |  |  |  |  | COMMODITY
ENA |  |  |  |  |  |  |  |  |  |  | [NAME] (Tecto STX / EPGT) |  |  |  | --- |  |  |  |  | NG
UNIT OF MEASURE |  |  | MW |  |  |  | CURRENCY |  | BROKER |  | FEE |  |  | DEAL STATUS |  |  |  | SETTLEMENT
 |  |  |  | --- |  |  |  |  | --- |  | ---
 |  |  | RISK MANAGER INITIALS:
PHYSICAL  NOTIONAL DEL  START DATE | PHYSICAL  NOTIONAL DEL  END DATE | REFERENCE  CODE (e.g. NX3) | FINANCIAL  REFERENCE  START DATE |  | FINANCIAL REFERENCE END  DATE |  | FIRM  QUANTITY  (A) | OPTION/OMICRON  QUANTITY (B) |  | TOTAL MAXIMUM  QUANTITY (A+B) | FIXED  PRICE | BASIS | C PHYSICAL  PREMIUM | C ADMIN/ OTHER | C TRANSPORT  PRICE |  | C OMICRON  PRICE | CONTRACT  PRICE/ STRIKE | C OPTION  PREMIUM |  | ORIGINATION
 |  |  |  |  |  |  |  |  |  |  |  | EFP
 |  | NX1 | 2003-01-01 00:00:00 |  | 2003-12-01 00:00:00 |  | 60000 |  |  |  | 3.275 | -0.145 |  |  |  |  |  | 3.13 |  |  | 0.01
 | Basis: |  |  |  | Tetco STX |  |  |  |  |  |  | -0.12
 |  |  |  |  | EPGT |  |  |  |  |  |  | -0.17
[NAME]:
Spreadsheet: 126835d1319993951-dynamic-cell-reference-example_dynamiccell_reference
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | x | y
 |  |  |  |  |  | Constraint | 8 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 42706d1241269020-transfer-data-to-3-worksheets-copy-of-time-sheet-test
Sheet: Datasheet3

Start Time | Finish Time | Start Place | Finish Place | Total Hours
dd | dd | dd | dd | dd
dd | dd | dd | dd | dd
ss | ss | ss | ss | ss
Spreadsheet: 0e1110bf-f1d7-4590-9d0e-d3e626a88d8d
Sheet: Sheet1

NASP Equipment  - Supplemental Order Form
Brennan Industries, Inc. - The Official Equipment Distributor for the National Archery in the Schools Program
Brennan Industries |  |  | Prices effective: |  |  |  |  |  |  | Phone: (608) 269-0832
2035 Riley Road |  |  | January 1 - December 31, 2012 |  |  |  |  |  |  | Fax:     (608) 269-0172
Sparta, WI  54656 |  |  |  |  |  | email: [EMAIL]
 |  |  |  |  |  | www.archeryintheschools.org
Customer #:
Organization: |  |  |  |  | [NAME]:
Contact Name: |  |  |  |  | (If different)
Ship-To Address: |  |  |  |  | City State Zip:
(NO PO Box) |  |  |  |  | Phone:
City State Zip: |  |  |  |  | Fax:
 | Commercial |  | Residential |  | E-mail:
 | Evidence of Non-Profit Status: |  |  |  | Copy of 501c3 |  |  | Copy of Sales Tax Exemption
Payment accepted by Check, MasterCard, Visa, or [NAME]:
 |  |  |  |  |  | VISA / MasterCard:
PO Number: |  |  |  |  |  | Name:
*PO Number is REQUIRED if order is not prepaid. |  |  |  |  |  | Card #:
 |  |  |  |  |  | Expires: |  |  | 3-Digit Code
 |  |  |  |  |  |  | Retain CC# for future orders?       Yes       No
 | Number | Item |  |  |  | Qty |  | (Includes Shipping) | Price
Mini | 11413 | Mini Right Hand Red |  |  |  |  | Ea | $111/bow
Genesis | 11415 | Mini Right Hand Blue |  |  |  |  | Ea | $111/bow
Bows: | 11417 | Mini Right Hand Black |  |  |  |  | Ea | $111/bow
 | 11414 | [NAME] Red |  |  |  |  | Ea | $111/bow
 | 11416 | [NAME] |  |  |  |  | Ea | $111/bow
 | 11418 | [NAME] Black |  |  |  |  | Ea | $111/bow
Genesis | 10492A | Genesis Pro Right Hand Black |  |  |  |  | Ea | $131/bow |  | ***
Pro | 10496A | Genesis Pro Right Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Bows: | 10491A | Genesis Pro Left Hand Black |  |  |  |  | Ea | $131/bow |  | ***
 | 10497A | Genesis Pro Left Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Replacement | BG20014 | Right Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
Parts: | BG20015 | Left Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
 | BG11498 | String (Orig or Pro) 94 13/16" (Blk & Wht) |  |  |  |  | Ea | $17/each
 | BG10897 | String (Orig or Pro) 94 13/16" (Blk & Red) |  |  |  |  | Ea | $17/each
 | BG11490 | [NAME] 77 11/16" (Blk and Wht) |  |  |  |  | Ea | $17/each
 | BG11491 | [NAME] 77 11/16" (Black and Red) |  |  |  |  | Ea | $17/each
 | BG11497 | Power Cable Genesis & Pro 37.25" |  |  |  |  | Ea | $10/each
 | BG11492 | Power Cable Mini 30 13/16" |  |  |  |  | Ea | $10/each
 | 50138 | Cable Rod Slide |  |  |  |  | Ea | $1/each
 | ** All prices include shipping to a commercial
 | address in the lower 48 States |  |  |  |  |  |  | Total
*** Please note - Genesis Pro does NOT include a rest.  You will have to purchase a rest separately ***
from another source.  [NAME] and [NAME] are not eligible for NASP tournament competition.
*** BY SUBMITTING THIS ORDER TO BRENNAN INDUSTRIES, INC. YOU AGREE THAT NO ITEMS WILL BE RESOLD
Spreadsheet: sally_beck__36190__Consolidated Analytics - 2
Sheet: Total

 |  | Cost Center NAME: | Consolidated Analytics |  |  | Due Date: | 2000-09-29 00:00:00
 |  | Cost Center OWNER: | [NAME]
STAFFING SUMMARY |  |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
Sr Director
Director
Manager
Sr Specialist
Specialist
Administrative Asst.
Associates/Analysts
Administrative Asst.
Subtotal Employee Headcount |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contractors
TOTAL HEADCOUNT |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DIRECT EXPENSES | Account Number |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Total
Salaries & Wages
Special Pays
Subtotal Compensation
Benefits
Payroll Taxes
Subtotal Benefits and Payroll Taxes
Club Dues | 52001500
Tuition Reimbursement/Registration Fee/Ed | 52002000
Expenses Other | 52002500
Group Meals & Entertainment | 52003000
Client Meals & Entertainment | 52003500
Professional Memberships | 52004000
Travel & Lodging | 52004500
General Business & Admin Expenses | 54005000
Subtotal Employee Expenses
Legal | 52507000
Audit | 52507100
Contract for Overhead | 52507200
Tax | 52507300
IT | 52507400
Other | 52507500
Engineering | 52507600
Accounting | 52507700
Professionals | 52508000
Subtotal Outside Services
Subscriptions & Publications | 52508500
Postage & Freight Expense | 52508100
Fees & Permits | 52505500
Company Membership & Dues | 52504000
Materials & Supplies - Stock | 53500000
Materials & Supplies - Non Stock | 53500500
Price [NAME] | 53550000
Supplies & Expense | 53600000
Provision for Scrap | 53551000
Subtotal Materials & Supplies
Advertising Expense | 52500500
Subtotal Marketing
Charitable Contributions
Rent - Personal Property | 53800000
Rent - Real Property | 53801000
Subtotal Rent (3rd Party)
Communications Expense | 52503500
Computer Expense | 52504500
Subtotal Technology
Vehicle/Equpment Fuel | 54000000
Subtotal Transportation
Bad Debt
Corporate Charges
Other Expenses
Subtotal Corporate Expenses
Depreciation
Amortization
Subtotal Depreciation & Amortization
TOTAL DIRECT EXPENSES
 |  | [ position | 9
 |  | ] position | 32
 |  | difference | 23
 |  | total length | 43
 |  |  | 2001 Plan - 105170
 |  |  | [NAME]
Spreadsheet: 126693d1319824625-any-way-of-updating-the-current-price-copy-of-price-change-test
Sheet: Sheet1

Totadys Date | 2011-10-28 00:00:00
Items | Current Sale Price | Date of Last price Change |  | Price Table | Price | Date | Price | Date | Price | Date | Price | Date | Price | Date | Price | Date
scissors | 9 | 2010-07-11 00:00:00 |  | scissors | 8 | 2010-05-11 00:00:00 | 9 | 2010-07-11 00:00:00 |  | 2011-01-09 00:00:00 |  | 2011-07-01 00:00:00
pencils | 7 | 2011-01-09 00:00:00 |  | pencils | 2 | 2010-05-11 00:00:00 | 8 | 2010-07-11 00:00:00 | 7 | 2011-01-09 00:00:00 |  | 2011-07-01 00:00:00
razors | 10 | 2011-07-01 00:00:00 |  | razors | 3 | 2010-05-11 00:00:00 | 6 | 2010-07-11 00:00:00 | - | 2011-01-09 00:00:00 | 10 | 2011-07-01 00:00:00
table cloth | 2 | 2010-05-11 00:00:00 |  | table cloth | 2 | 2010-05-11 00:00:00 |  | 2010-07-11 00:00:00 |  | 2011-01-09 00:00:00 |  | 2011-07-01 00:00:00
roller skates | 8 | 2011-01-09 00:00:00 |  | roller skates | 5 | 2010-05-11 00:00:00 | 3 | 2010-07-11 00:00:00 | 8 | 2011-01-09 00:00:00 |  | 2011-07-01 00:00:00
 | The cells B7 to B 11 need to reflect the last price change in each row as per the date in relevence to todays date.  The cells C7 to C 11 need to show the date of the last price amendment.
Spreadsheet: 577bac00-c455-4e44-954d-f4402b60b54e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-05-10 09:30:53.850000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.849 | 101.724 | 101.599 | 101.224 |  | and are added to price quote
4.75 | 100.91 | 100.785 | 100.66 | 100.285
4.625 | 99.996 | 99.871 | 99.746 | 99.371 |  | Note: | Refer To Price [NAME]
4.5 | 99.543 | 99.418 | 99.293 | 98.918 |  |  | For all Price Adjs
4.375 | 98.967 | 98.842 | 98.717
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.25 | 101.685 | 101.56 | 101.435 | 101.06
4.125 | 100.996 | 100.871 | 100.746 | 100.371
4 | 100.673 | 100.548 | 100.423 | 100.048
3.875 | 100.243 | 100.118 | 99.993 | 99.618
3.75 | 99.694 | 99.569 | 99.444
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-05-24 09:30:53.850000
30 DAY | 2011-06-08 09:30:53.850000
45 DAY | 2011-06-23 09:30:53.850000
60 DAY | 2011-07-08 09:30:53.850000
90 DAY | 2011-08-07 09:30:53.850000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 827733d1683009374-my-excel-file-is-so-slow-with-some-functions-simple-mar-and-apr-2023
Sheet: Dashboard

Year | Month | Total Trade | Win | Loss | WinRate | C Win | C Loss | Result |  | Average Duration
Live Result
2022 | December | 41 | 21 | 20 | 0.5122 | 5 | 4 | 0.215 |  | -
2023 | January | 38 | 21 | 17 | 0.5526 | 5 | 5 | 0.23 |  | -
 | February | 35 | 18 | 17 | 0.5143 | 6 | 5 | 0.185 |  | -
 | March | 47 | 25 | 22 | 0.5319 | 4 | 4 | 0.265 |  | 22 Hour
 | April | 46 | 15 | 31 | 0.3261 | 4 | 12 | 0.07 |  | 21 Hour
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
2024 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
2025 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
Spreadsheet: 886012d1735947342-issues-with-printing-to-pdf-time-line-exerpt
Sheet: Cindy's TIme Line

 | Timeline of Events in the Development of Colonial America
 | Date | Event
 | 1620 | The Mayflower Compact
 |  | The Mayflower Compact signed on November 21, 1620, was a set of rules for self-governance established by the English settlers who traveled to the New World on the Mayflower. When Pilgrims and other settlers set out on the ship for America in 1620, they intended to lay anchor in northern Virginia. But after treacherous shoals and storms drove their ship off course, the settlers landed in Massachusetts instead, near Cape Cod, outside of Virginia’s jurisdiction. Knowing life without laws could prove catastrophic, colonist leaders created the Mayflower Compact to ensure a functioning social structure would prevail.
 | 1620 | The Mayflower Pilgrims disembarked to settle in Plymouth Colony, Massachusetts
 |  | The second successful English settlement in America following Jamestown, Virginia was formed in Plymouth Colony, Massachusetts upon the disembarking of the Mayflower Pilgrims.
 | 1620 -     1642 | The Great Puritan Migration
 |  | As noted in several events above regarding religious turmoil in England, the Great Puritan Migration was where English puritans migrated to New England, the Chesapeake, and the West Indies.  English migration to Massachusetts consisted of a few hundred pilgrims who went to the Plymouth Colony in the 1620s and many who went to the Massachusetts Bay Colony between 1630 and 1642.  The puritans were a sect of religious dissidents who felt the Church of England was too closely associated with the Catholic religion and needed to be reformed.
 | 1623 | First Thanksgiving
 |  | Governor [NAME] of Plymouth Colony proclaims a "Day of Thanksgiving" often cited as the First Official Thanksgiving Celebration between the separatist settlers of the Plymouth Colony in Massachusetts and the Indians to celebrate surviving a harsh winter and producing a first harvest.
 | 1626 | The purchase of Manhattan Island
 |  | A Dutch colonist named [NAME] purchased the island of Manhattan from the Indians. He named it New Amsterdam.
 | 1675 | King Philip's War OF 1675 - 76
 |  | The first major armed conflict between the Indian inhabitants of New England and the colonists in Massachusetts, Connecticut, and Rhode Island.  The Indian inhabitants burned Providence in totality in the greatest calamity in seventeenth-century New England and is considered by many to be the deadliest battle in Colonial American history.  More than half of New England's towns were attacked.
Spreadsheet: 829890d1684511096-sequential-transactions-based-on-data-in-another-field-sequential-transactions
Sheet: Sheet1

Existing Results |  |  | Desired Results
Transaction # | Item # |  | Transaction # | Item #
1 | 1 |  | 1 | 1
1 | 2 |  | 1 | 2
1 | 3 |  | 1 | 3
3 | 1 |  | 2 | 1
5 | 1 |  | 3 | 1
5 | 2 |  | 3 | 2
7 | 1 |  | 4 | 1
7 | 2 |  | 4 | 2
In the Existing Results, the |  |  | Would like the Transaction # to be
Transaction # is not sequential |  |  | sequential every time the Item #
 |  |  | changes to "1"
Spreadsheet: d12c9a22-06ea-40de-98f0-558f75cbb6cc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261344 | 66282 | Toshihiro | Shirae | JPN | 3 | 00:15:29 | 00:02:14 | 00:34:05 | 00:02:16 | [NAME] | 1 | 01:18:51
261344 | 57735 | [NAME] | Nakazawa | JPN | 2 | 00:18:55 | [NAME] | 00:32:27 | [NAME] | 00:28:03 | 2 | 01:23:13
Spreadsheet: 867588d1714418023-distribute-amount-in-column-according-to-date-and-duration-test
Sheet: Data

Column1 | Current address | End of current OA | Square-meters occupation | Premises | Current occupants (FTE or workstations) | Destination | Target Occupants | Delivery Date | Type of Development | Cost of Works | Duration of Works (in years) | Start Date of Works | Estimated Cost of Works by Type of Development | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
client 1 | Address 1 | 2027-10-31 00:00:00 | 1000 | Office | 327 | Address 1 | 209 | 2028-04-01 00:00:00 | Complete Development (BB + Office) | 3000 | 3
client 1 | Address 1 | 2027-10-31 00:00:00 | 250 | PUP | 0 | Address 1 | 0 | 2028-04-01 00:00:00 | Complete Development (BB + Office) | 3000 | 3
client 1 | Address 1 | 2027-10-31 00:00:00 | 365 | Office | 25 | Address 1 | 16 | 2030-04-01 00:00:00 | Complete Development (BB + Office) | 3000 | 3
client 2 | Address 5 | 2026-03-31 00:00:00 | 280 | Office | 12 | Address 2 | 8 | 2027-04-01 00:00:00 | Office Only | 1500 | 1
client 3 | Address 3 | 2029-03-31 00:00:00 | 355 | Office | 16 | Address 2 | 10 | 2029-04-01 00:00:00 | Full | 3000 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need a formula to distribute the amounts according to the following information and get the same result as the rows above :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The date in column I (i) and the duration of work, column L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 Years | 0.2 | 0.3 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 Years | 0.3 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Year | 1
Spreadsheet: 525279d1498656498-need-help-in-my-time-sheet-count-if-9hrs-worked-then-calculate-as-1-day-working-time-table-estevaoba
Sheet: Calender

 | 2017 |  |  | Month: |  | 2
 | 2017-02-01 00:00:00
 | Sun | Mon | Tue | Wed | Thur | Fri | Sat
 |  |  |  | 2017-02-01 00:00:00 | 2017-02-02 00:00:00 | 2017-02-03 00:00:00 | 2017-02-04 00:00:00
 | 2017-02-05 00:00:00 | 2017-02-06 00:00:00 | 2017-02-07 00:00:00 | 2017-02-08 00:00:00 | 2017-02-09 00:00:00 | 2017-02-10 00:00:00 | 2017-02-11 00:00:00
 | 2017-02-12 00:00:00 | 2017-02-13 00:00:00 | 2017-02-14 00:00:00 | 2017-02-15 00:00:00 | 2017-02-16 00:00:00 | 2017-02-17 00:00:00 | 2017-02-18 00:00:00
 | 2017-02-19 00:00:00 | 2017-02-20 00:00:00 | 2017-02-21 00:00:00 | 2017-02-22 00:00:00 | 2017-02-23 00:00:00 | 2017-02-24 00:00:00 | 2017-02-25 00:00:00
 | 2017-02-26 00:00:00 | 2017-02-27 00:00:00 | 2017-02-28 00:00:00
Spreadsheet: 128165d1320834094-sorting-a-list-by-first-rows-value-equal-to-a-specific-character-simone77example
Sheet: Hoja3

[1] | H | D | U | 0 | 0 | 0 | 0 | 0 | 0
[10] | 0 | 0 | U | 0 | 0 | 0 | 0 | 0 | 0
[100] | U | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[104] | U | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[105] | 0 | 0 | 0 | 0 | U | 0 | 0 | 0 | 0
[106] | D | U | U | U | 0 | 0 | 0 | 0 | 0
[108] | U | 0 | U | D | U | 0 | 0 | 0 | 0
[11] | D | 0 | U | U | 0 | 0 | 0 | 0 | 0
[110] | U | 0 | U | 0 | U | U | 0 | 0 | 0
Spreadsheet: 859814d1708065636-separating-employee-id-and-employee-name-formula-or-vba-extract
Sheet: Sheet1

 |  | EmpID | Emp Name |  |  | Emp Name
EmpIDAA1219 [NAME] EmpIDAC6543 [NAME] |  | AA1219 | [NAME] |  | AA1219 | [NAME]
EmpIDAB5978 [NAME] and EmpIDPG6187 [NAME] |  | AC6543 | [NAME] |  | AC6543 | [NAME]
EmpIDDR5612 [NAME] |  | AB5978 | [NAME] |  | AB5978 | [NAME]
[NAME], EmpIDBB4569-Mark Twain |  | PG6187 | [NAME] |  | PG6187 | [NAME]
 |  | DR5612 | [NAME] |  | DR5612 | [NAME]
 |  | AA8630 | [NAME] |  | AA8630 | [NAME]
 |  | BB4569 | [NAME] |  | BB4569 | [NAME]
Spreadsheet: 127703d1320495350-find-uniques-and-duplicates-values-in-different-sheets-uniques-and-same-values
Sheet: Sheet4

Copy of all numbers |  | Unique numbers | CountIF
100 |  | 100 | 2
150 |  | 150 | 2
200 |  | 200 | 2
250 |  | 250 | 1
300 |  | 300 | 1
350 |  | 350 | 1
100 |  | 600 | 1
150 |  | 700 | 1
200 |  | 800 | 1
600
700
800
Spreadsheet: 41653d1240218095-if-name-then-cell-reference-book7
Sheet: Sheet1

Names | Percentages
[NAME] | 0.8
[NAME] | 0.9 |  | Product of Percentages | Percentages
[NAME] | 1 |  | Names | 0.45 | 0.5 | 0.55 | 0.6 | 0.65 | 0.7 | 0.8 | 0.9 | 1 | Grand Total
[NAME] | 0.6 |  | [NAME] |  |  | 0.55 | 0.36 |  |  |  |  | 1 | 0.198
[NAME] | 0.7 |  | [NAME] | 0.45 | 0.5 |  |  | 0.65 | 0.7 | 0.8 | 0.9 |  | 0.07371000000000001
[NAME] | 0.65 |  | Grand Total | 0.45 | 0.5 | 0.55 | 0.36 | 0.65 | 0.7 | 0.8 | 0.9 | 1 | 0.01459458
[NAME] | 0.6
[NAME] | 0.55
[NAME] | 0.5
[NAME] | 0.45
 |  | yes
Spreadsheet: 720092d1614008371-correcting-a-formula-to-display-blank-if-result-is-0-and-fix-any-errors-custom-formatting-to-hide-zeros-dexter2-
Sheet: Sheet2

 |  |  |  |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  | 50 | 50 | 50 | 50
 |  |  |  |  | 5 | 5 |  |  | 5 | 5
 |  |  |  |  | 2 |  | 2 |  | 2 |  | 2
 |  |  |  | Tested with G6 formula
 |  |  |  | Tested with attempted combo formula | Yes | Yes | Yes | No | Yes | No | No | No
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: Oct

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]