tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 806324d1669232362-matching-columns-a-and-b-with-data-in-c-and-d-sample-file
Sheet: Sheet1

Repair Area |  |  |  | Parts on Cart |  |  |  | Parts on Line
BOARD | SEQ | LINE |  | Part Carts | BOARD | SEQ |  | BOARD | SEQ
1004 | 913 | V90 |  | F | 926 | 924 |  | 815 | 1618
1006 | 916 | V30 |  | F | 926 | 924 |  | 915 | 463
1011 | 1698 | VTO |  | F | 1006 | 831 |  | 922 | 1650
1012 | 1229 | V30 |  | F | 1006 | 831 |  | 1019 | 1505
1018 | 1057 | V30 |  | F | 1006 | 723 |  | 1004 | 1705
1019 | 1505 | VFO |  | F | 1006 | 723 |  | 1004 | 1721
1019 | 1505 | VFO |  | C | 1006 | 916 |  | 1004 | 1756
1021 | 1193 | V30 |  | C | 1020 | 1767 |  | 1006 | 1280
Spreadsheet: 65655d1266347931-selective-data-to-get-a-printed-report-budget-to-actual-expenditure-2010-slots
Sheet: 11

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Duty / Tax / Transport = |  | 0.45
 | Details |  |  |  |  | Quotation |  |  |  |  |  | Invoice |  |  |  |  |  |  |  | Local Duty, TAX & Local Transport
I / Q | # | Sequence # | Company | Discription |  | Quotation # | Quotation (Euro) | X rate | RSD | Date (processed) |  | Invoice # | Act invoice (Euro) | X rate | RSD | SHIP invoice | Difference % | Process (date) |  | Duty & Transport | Act invoice | Difference % | Paid (date) |  | Total cost (actual) | Special NOTES
 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 2 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 3 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 4 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 6 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 9 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 10 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 11 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 12 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 13 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 14 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 15 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 16 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 17 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 18 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 19 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 20 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 |  |  |  | Total = |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | Total spent = |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget total = |  | 640000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining = |  | 640000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % = |  | 1
Spreadsheet: 692841d1598605086-multiple-spreadsheet-values-required-and-data-returned-over-48hrs-excel-forum-1-sumproduct-new-model
Sheet: WIP Formula

Emp No |  | Name | 48+ Hrs | 10.08.2020 | 17.08.2020 | 24.08.2020
1 | [NAME] | Smith |  |  |  | 49
2 | [NAME] | Jones |  | 56.03
3 | Bobbi | [NAME] |  |  | 48 | 51
4 | [NAME] | Singh |  | 49.71 |  | 62
5 | [NAME] | [NAME] |  | 49.86 | 53
6 | Bertie | Davies |  |  | 47.5
7 | Obi | Stanley |  |  | 49.23
8 | Bobba | [NAME]
9 | [NAME] | Bloggs |  |  | 56 | 47.08
Spreadsheet: 165902d1341392978-convert-multiple-row-data-to-single-row-with-multiple-columns-rows-data-convert-to-column
Sheet: Sheet6

Calculated Field
[NAME] | Field | [NAME]
Calculated Item
[NAME] | Item | [NAME]
1 | Formula1 | = 0
2 | Formula2
3 | Formula3
4 | Formula4
5 | Formula5
6 | Formula6
7 | Formula7
8 | Formula8
9 | Formula9
10 | Formula10
11 | Formula11
12 | Formula12
13 | Formula13
Note: | When a cell is updated by more than one formula,
 | the value is set by the formula with the last solve order.
 | To change the solve order for multiple calculated items or fields,
 | on the Options tab, in the [NAME] group, click [NAME], and then click [NAME].
Spreadsheet: michelle_cash__26487__DC Expense Overlap Duplicate Review
Sheet: Summary

 |  |  | Employee: Diomedes Christodoulou
The following is a list of potential conflicting charges based upon information available from receipts and copies of the expense reports.
Expense Report Month | Vendor | From Date | To Date | Amount (US$) | Category | No Receipt | [NAME] | Comments | Potential Min. Recovery Amount | Potential [NAME]
Oct 98 ER | Am Airlines | 1998-09-23 00:00:00 | 1998-10-11 00:00:00 | 6792 | F |  | X | Rio to ... Houston to ...Madrid to…London to Sao Paulo (SP) |  | 6792
Oct 98 ER | Am Airlines | 1998-10-06 00:00:00 |  | 3512 | F | X |  | No receipt - Purchased in Tulsa, OK | 3512
Feb 00 ER | Continental Air | 2000-02-03 00:00:00 | 2000-02-03 00:00:00 | 2219.4 | F |  | X | SP to Houston |  | 2219.4
Feb 00 ER | Continental Air | 2000-02-04 00:00:00 | 2000-02-04 00:00:00 | 2011.4 | F |  | X | Houston to SP
Feb 00 ER | Omni Hotel | 2000-02-01 00:00:00 | 2000-02-04 00:00:00 | 909.93 | H |  | X | Houston for 3 Nights | 909.93
Jul 00 ER | British Airways | 2000-06-28 00:00:00 | 2000-06-28 00:00:00 | 4991.77 | F |  | X | London/SP | 4991.77
Jul 00 ER | Grosvenor House Hotel | 2000-06-24 00:00:00 | 2000-07-02 00:00:00 | 5984.83 | H |  | X | London for 8 Nights |  | 5984.83
Aug 00 ER | British Airways | 2000-07-17 00:00:00 | 2000-07-17 00:00:00 | 3477.36 | F |  | X | Rio to London |  | 3477.36
Aug 00 ER | American Airlines | 2000-07-14 00:00:00 | 2000-07-14 00:00:00 | 3414.4 | F |  | X | Houston to Miami
Aug 00 ER | Omni Hotel | 2000-07-11 00:00:00 | 2000-07-18 00:00:00 | 1874.1 | H |  | X | Houston for 7 Nights | 1874.1
 |  |  |  |  |  |  |  | Total
Legend
F- Flight
H- Hotel
O- Other
*  Results were obtained through review of the following queries:
Comparison of flight dates and destinations to each other.
Comparison of hotel dates and locations to each other.
Comparison of other charges dates and locations to each other.
Comparison of flight dates and locations to hotel dates and locations.
Comparison of other charges dates and locations to both flight and hotel dates and locations.
Our scope was limited to approximately $1,000 threshold and included expense reports submitted from Oct. '98 to Dec. '98 and Jan. '00 to Jan. '01.
Spreadsheet: 765671d1643477302-index-match-formula-only-works-for-a-portion-of-columns-cocktail-cost-calculator_support
Sheet: Conversion Table

Conversion Table
 |  |  |  |  |  | Currency Symbol |  | €
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | ML | CL | LTR | Oz | GR | KG | 1 Piec/Pck | 6-Pack | 12-Pack | 24-Pack
ML | 1 | 0.01 | 0.001 | 0.0338140225589194 | 0 | 0 | 0 | 0 | 0 | 0 | 1
CL | 10 | 1 | 0.01 | 0.338140225589 | 0 | 0 | 0 | 0 | 0 | 0 | 2
[NAME] | 1000 | 100 | 1 | 33.8140225589194 | 0 | 0 | 0 | 0 | 0 | 0 | 3
Oz | 29.5735296875 | 2.95735296875 | 0.0295735296875 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4
GR | 0 | 0 | 0 | 0 | 1 | 0.001 | 0 | 0 | 0 | 0 | 5
KG | 0 | 0 | 0 | 0 | 1000 | 1 | 0 | 0 | 0 | 0 | 6
6-Pack | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 0.5 | 0.25 | 7
1 Piec/Pck | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.16666 | 0.083333 | 0.041666 | 8
24-Pack | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 4 | 2 | 1 | 9
12-Pack | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 2 | 1 | 0.5 | 10
Spreadsheet: 526102d1499116300-multiple-criteria-within-date-range-and-matching-value-within-row-s666-excelforum
Sheet: BeforeSheet1

Date Obtained | One month before date obtained | One week after date obtained | Identifier |  | Date of Measurement | Identifier | Measurement |  | Identifier | Measurement | Rows |  | ROW number
2015-01-30 00:00:00 |  |  | ABC123 |  | 2015-01-10 00:00:00 | ABC123 | 1.2 |  | ABC123 | 1.2 | True
2014-01-30 00:00:00 |  |  | ABC123 |  | 2015-03-01 00:00:00 | ABC123 | 3.4 |  | ABC123 | 3.4 | False
2013-01-30 00:00:00 |  |  | ABC123 |  | 2015-04-01 00:00:00 | ABC123 | 5.2 |  | ABC123 | 5.2 | False
2012-01-30 00:00:00 |  |  | ABC123 |  | 2015-01-12 00:00:00 | ABC456 | 3.4 |  | ABC456 | 3.4 | False
2015-12-30 00:00:00 |  |  | ABC456 |  | 2015-01-10 00:00:00 | ABC456 | 7.2 |  | ABC456 | 7.2 | False
2014-12-30 00:00:00 |  |  | ABC456 |  | 2015-12-11 00:00:00 | ABC456 | 5 |  | ABC456 | 5 | True
2013-12-30 00:00:00 |  |  | ABC456 |  | 2015-12-10 00:00:00 | ABC456 | 3.3 |  | ABC456 | 3.3 | True
2012-12-30 00:00:00 |  |  | ABC456
Spreadsheet: 46707d1245652142-date-range-lookup-in-excel-test
Sheet: Rates

Level | Start Date | End Date | Rate
L10 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 | 5
L10 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 10
L11 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 | 8
L11 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 12
L12 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 | 10
L12 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 14
Spreadsheet: 814532d1674473152-copy-project-data-to-respective-tabs-ef1601_extract_to_sheets
Sheet: E

Project | Data field 1 | Data field 2 | Data field 3 | Data field 4 | Data field 5 |  | E
Spreadsheet: 45194315-e05b-422e-abbc-c34c9c94dc5b
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
Anlage [NAME]
Vorschlagsliste des kommunalen Aufgabenträgers [NAME] im [NAME]
kommunaler [NAME] |  |  |  | Adresse, Telefon, [NAME]
1 | 2 | 2 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
[NAME].    Nr. | Name, Vorname des Antragstellers | Adresse des Antragstellers | Investitionsort, PLZ, [NAME], [NAME] | Art der Anlage | [NAME] | weitergehende [NAME] | [NAME]. Entscheidung vom | [NAME] (WRE / SanAO) | Förder-gegenstand (Nr. 2 a - c lt. [NAME]) | Zuschuss/Darlehen | beantragte [NAME]
 |  |  |  |  |  |  |  |  |  | Summe | 0
Einzureichende [NAME] durch den [NAME]
 | farbiger grundstücksgenauer Auszug aus dem aktuellen Abwasserbeseitigungskonzept für den jeweiligen Ortsteil oder Teile davon
und
 | Kopie der [NAME] ([NAME] ist ein [NAME] auf [NAME] Abwasserbeseitigungskonzept ausreichend, wenn es bei der bewilligenden Stelle hinterlegt wurde.)
Ich erkläre / Wir erklären, dass die oben genannten Antragsteller nur 10 % der möglichen Antragsteller sind, die gemäß Anlage 1 des ABK innerhalb der nächsten 15 Jahre nicht an eine kommunale [NAME] angeschlossen werden. Die Erschließung dieser Antragsteller erfolgt abwassertechnisch über Kleinkläranlagen.  (Anzahl der nicht an kommunale [NAME] angeschlossenen Einwohner / 2,6 Einwohner je Kleinkläranlage = Anzahl der Kleinkläranlagen bzw. Anzahl der möglichen Antragsteller)
 | 10 % sind:
Wir beantragen zudem eine Zuwendung für die [NAME] und Organisationsleistungen nach [NAME] für [NAME].
Datum: |  | Stempel / rechtsverbindliche Unterschrift des kommunalen Aufgabenträgers:
Spreadsheet: 102171d1300190229-draft-day-registration-help-team-draft2
Sheet: Teams

Team | B1 | B2 | B3 | B4 | B5 | B6 | B7 | B8
Player
1 | 15 | 16 | 17 | 18 | 22 | 24
 |  | Player is picked on more than one team
 |  | Player's partner has not been drafted but other players at a lower rank have been drafted
Spreadsheet: 807621d1669971777-how-to-highlight-increase-decrease-using-the-values-in-next-column-as-benchmark-example-increase-decrease-
Sheet: Sheet1

Week 1 | Week 2
10 | 4
4 | 3
3 | 6
7 | 8
2 | 4
7 | 5
9 | 3
3 | 5
5 | 5
6 | 3
9 | 2
2 | 4
Spreadsheet: 687169d1595004406-index-match-with-multiple-criteria-dates-and-names-example-index-match-copy-johncap-
Sheet: Sheet1

 |  |  | Value Wanted to Retrieve | Rotation | Out Of Office
 | 2020-07-02 00:00:00 | [NAME] |  | [NAME] | 2020-07-02 00:00:00 | [NAME]
 | 2020-07-03 00:00:00 | Fred |  | Fred | 2020-07-02 00:00:00 | Fred
 | 2020-07-04 00:00:00 |  |  | [NAME] | 2020-07-03 00:00:00 | [NAME]
 | 2020-07-05 00:00:00 |  |  | [NAME] | 2020-07-03 00:00:00 | [NAME]
 |  |  |  | Amanda | 2020-07-04 00:00:00 | Fred
 |  | *I'd like to have a INDEX MATCH Function that will look at the date in column B and will retrieve a value from the column E (the rotation list) that does not match someone who is out of Office for that particular [NAME] in column B. Currently the value I'm retrieving is matching individuals who are out of office in column H |  | [NAME] | 2020-07-05 00:00:00 | [NAME]
Spreadsheet: 773183d1647672322-creating-a-sequence-based-on-criteria-book1
Sheet: Sheet1

 |  |  |  | Result
1 | a |  |  | 1
2 | b |  |  | 2
3 | c |  |  | 3
4 | d |  |  | 4
5 | e |  |  | 5
6 | f |  |  | 6
7 | g |  |  | 7
8 |  |  |  | 8
9 |  |  |  | 9
10 |  |  |  | 10
11 |  |  |  | 11a
12 |  |  |  | 11ai
13 |  |  |  | 11aii
14 |  |  |  | 11aiii
15 |  |  |  | 11aiv
16 |  |  |  | 11av
17 |  |  |  | 11bi
18 |  |  |  | 11bii
19 |  |  |  | 11biii
20
Spreadsheet: 277946d1384478659-trying-to-copy-master-data-sheet-rows-if-criteria-exists-to-a-new-sheet-277939d1384472308-trying-to-copy-master-data-sheet-rows-if-criteria-exists-to-a-new-sheet-11-13
Sheet: 2013 Job Log

 | East Job Information |  |  |  |  |  |  |  |  |  |  |  |  | Quote Information |  |  |  |  |  |  |  |  |  |  |  |  |  | Quote Information  Dollar Amount Selling Price |  |  |  |  |  |  |  |  |  |  | Customers Salesman
 | Job Name | Customer | Job Location | Date In | Due Date | Time | Prints DL | Days to Bid | Quote Number | [NAME] | Memo | Status | Reject Critiera | Commercial Door | Framing | Truss Systems | Floor System | Millwork | [NAME] | Windows | Other | Installed Sales | Wall Panels | Roofing | Siding | Quote $ Submitted | Comments | Commercial Door | Framing | Roof  System | Floor System | Millwork | [NAME] | Windows | Other | Installed Sales | Wall Panels | Roofing | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Other
 | [NAME] | [NAME] structures | PA | 2013-11-01 00:00:00 | 2013-11-14 00:00:00 | 15:00:00 | √ |  | 130139 |  |  | Accepted |  |  | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | 1000 | 2000 | 30000 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 | [NAME] | bob Builders/ Cnote Construction |  | 2013-11-12 00:00:00 | 2013-11-14 00:00:00 | 11:00:00 |  |  | 1356698 |  |  | Accepted | Non Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 2000 | 3000 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 | Library | Jt Enterprises |  | 2013-10-29 00:00:00 | 2013-11-14 00:00:00 | 15:00:00 | √ |  | 1302255 | [NAME] | Memo-2 | Accepted |  |  | Not Quoting | Not Quoting |  |  |  |  |  |  |  |  |  |  |  | 22000 | 13000 | 10000 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
Spreadsheet: 887520d1737745468-multiple-formulas-peds
Sheet: Product

 |  |  | Production Record |  |  |  |  |  |  |  |  |  | <<<<<If all of the products listed contained the words NOP &/or Organic, it should return the logo from Z8
Description of Work: | P/I/P/S |  |  |  |  |  | Date |  | Customer Abbreviation |  | Issued By |  |  | Customer abbreviation | Stacking /Pallet requirements | Label Type | Auto Populated Label | Packaging | Shipping address | Incoterms | [NAME] (F2 then F9)
Input Inventory Location: | FG: L1-L3 T/B/M |  |  |  |  |  | Jan-01-1990 |  | [NAME] |  | You |  |  | [NAME] | Heat Treated |  |  | [NAME] and Tray | [NAME] 1 Patriot Pl Foxborough MA, 02035 | DAP | Latin: Common: Lot#: Gross/Tare/Net: kgs PO #:
Packaging Requirements: |  |  |  |  |  |  | REF: | SO# | PO # |  | Incoterms |  |  | [NAME] | Heat Treated |  |  | [NAME] and Tray | [NAME] Lucas Oil Stadium 500 S Capitol Ave, Indianapolis IN, 46225 | DAP | Latin: Common: Lot#: Gross/Tare/Net: kgs PO #: Item #:
Pallet Requirements: |  |  |  |  |  |  | 1234 |  | TB12 |  | DAP - Delivered at Place |  |  | [NAME] | FedEx Express |  |  | FedEx Pak | [NAME] Georgia Dome 1 Georgia Dome Drive NW Atlanta GA, 30303 | DAP | Latin: Lot#: Net: kgs
This section has properitary information.  C7:G13 has moved to the Label! Sheet. C7:D:13 has merged with this section. E7:G13 has merged with the sections in H7:[NAME] |  | Labeling Specifications |  |  |  |  | Customer - Shipping Address |  |  |  |  |  |  | [NAME] | Heat Treated |  |  | [NAME] | [NAME] Candlestick Park 602 Jamestown Avenue San Francisco CA, 94124 | DAP | Common: Lot#: Net kgs:
 |  | Label Type: |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FedEx Express |  |  | Box, liner, & tray | [NAME] Paycor Stadium 1 Paycor Stadium Cincinnati, OH 45202 | DAP | Latin: Common: Lot#: Net kgs: |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Standard |  |  | [NAME] | [NAME] Dog ([NAME]) Gillette Stadium - Broom Closet 1 Patriot Pl Foxborough MA, 02035 | DAP | Common: Lot#: Net kgs:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Heat Treated |  |  | [NAME] | [NAME] Assistant Candlestick Park 602 Jamestown Avenue San Francisco CA, 94124 | DAP | Common: Lot#: Net kgs:
[NAME] (Latin name) |  |  |  |  | Lot# |  | Quantity |  |  | Product #:
AAS (Anabolic-Androgenic Steroids) |  |  |  |  | Wilson-1-24 |  | 10 |  | kgs | 1
HGH - NOP (Human Growth Hormone) |  |  |  |  | 23-23-1961 |  | 10 |  | kgs | 2
EPO (Erythropoietin) |  |  |  |  | 22-44-2025 |  | 10 |  | kgs | 3
PED (Androstenedione) |  |  |  |  | Wilson-12-1 |  | 10 |  | kgs | 4
Instructions/Goals | Correlating SO/WO#'s:
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-19-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: 486257d1477401977-variable-weight-question-weight-average
Sheet: Sheet1

Rank | Company | Sector | Industy | Total | Event Attendance | Strong Connections | Average Connections | Weak Connections | Score | Giving | Lookup ID | Helper 2 | Score 2 | Related Philanthropy (Low range) | Helper 3 | Score3 | Cause giving | Score4
 | A | Retail | Apparel |  | Yes | 0 | 4 | 4 |  | 50000 | 8-46186792 |  |  | 352250 |  |  | Yes
 | B | Retail | - |  | No | 0 | 1 | 1 |  | 45102.08 | 8-19413117 |  |  | 763100 |  |  | Yes
 | C | Health Care | Pharmaceuticals, Biotech |  | No | 2 | 0 | 0 |  | 0 | 0 |  |  | 1223227 |  |  | Yes
 | D | Personal Products | - |  | No | 0 | 0 | 0 |  | 23006.28 | 8-46405084 |  |  | 400000 |  |  | Yes
 | E | Public sector, Plastics | - |  | No | 2 | 0 | 0 |  | 0 | 8-47129991 |  |  | 200000 |  |  | Yes
 | F | Consumer Durables | Apparel |  | Yes | 0 | 0 | 0 |  | 6060.95 | 8-19440261 |  |  | 737500 |  |  | Yes
 | G | Retail | Wellness & Skincare Products |  | No | 0 | 0 | 0 |  | 20000 | 8-46197870 |  |  | 5000 |  |  | Yes
 | H | Benefit Adminnistration | - |  | No | 0 | 0 | 0 |  | 30832.52 | 8-19407419 |  |  | 0 |  |  | Yes
 | I | Retail | Footwear |  | Yes | 1 | 0 | 1 |  | 45 | 8-19404945 |  |  | 28000 |  |  | Yes
 | J | Business & Consumer Services | Medical Products |  | Yes | 1 | 0 | 0 |  | 0 | 0 |  |  | 207500 |  |  | Yes
 | K | Energy | Oil & Gas |  | No | 0 | 0 | 1 |  | 125.54 | 8-46639118 |  |  | 135000 |  |  | Yes
 | L | Hospitality | Restaurants |  | No | 0 | 0 | 3 |  | 231.71 | 8-37931456 |  |  | 300 |  |  | Yes
 | M | Retail | Personal Products |  | No | 0 | 0 | 1 |  | 500 | 8-19466824 |  |  | 1050 |  |  | Yes
 | N | Retail | - |  | No | 0 | 0 | 0 |  | 0 | 0 |  |  | 570250 |  |  | Yes
 | O | - | Hospitals & Patient Services |  | No | 0 | 0 | 2 |  | 0 | 0 |  |  | 11501 |  |  | Yes
 | P | Retail | - |  | No | 0 | 0 | 0 |  | 11000 | 8-46347696 |  |  | 75000 |  |  | No
 | Q | Other | - |  | No | 0 | 0 | 0 |  | 0 | 8-48528649 |  |  | 300 |  |  | Yes
 | R | - | Textiles |  | Yes | 2 | 0 | 0 |  | 0 | 0 |  |  | 100 |  |  | No
 | S | Business & Consulting Services | - |  | No | 0 | 0 | 0 |  | 12241 | 8-46145049 |  |  | 0 |  |  | No
 | T | Technology | Computer Software |  | No | 0 | 2 | 1 |  | 0 | 0 |  |  | 0 |  |  | No
 | U | - | Textiles |  | Yes | 0 | 1 | 1 |  | 0 | 0 |  |  | 0 |  |  | No
 | V | Consumer Durables | Footwear |  | Yes | 0 | 0 | 1 |  | 0 | 0 |  |  | 0 |  |  | No
 | W | Basic Materials | Plastics & Synthetics |  | No | 0 | 0 | 1 |  | 0 | 0 |  |  | 0 |  |  | No
 | X | Retail | - |  | No | 0 | 0 | 0 |  | 0 | 0 |  |  | 0 |  |  | No
Notes and Methodology
Rankings are based on a consideration of the following variables: RelSci connections and St. Jude giving are worth up to 30% each while philanthropic giving to health-related organizations and donations to cancer-specifc organizations are worth up to 20% each.
Additional 2nd degree connections are available for the each of the above companies with RelSci profiles.
Spreadsheet: 830137d1684746184-check-for-date-range-within-date-range-for-forumv2-ans
Sheet: Sheet1

Last year start | 2022-04-01 00:00:00 |  | Current year start | 2023-04-01 00:00:00 |  | Next year start | 2024-04-01 00:00:00
Last year end | 2023-03-31 00:00:00 |  | Current year end | 2024-03-31 00:00:00 |  | Next year end | 2025-03-31 00:00:00
 |  |  | Full Months in last year | Full Months in actual year | Full Months in next year |  |  |  | Full Months in last year | Full Months in actual year | Full Months in next year
Project | Start | End | 2022-04-01 00:00:00 | 2023-04-01 00:00:00 | 2024-04-01 00:00:00 |  |  |  | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2023-04-01 00:00:00
Project A | 2022-05-01 00:00:00 | 2024-06-28 00:00:00 |  |  |  |  |  |  | 11 | 12 | 2
Project B | 2023-08-01 00:00:00 | 2023-12-01 00:00:00 |  |  |  |  |  |  | 0 | 4 | 0
Project C | 2023-02-01 00:00:00 | 2023-11-01 00:00:00 |  |  |  |  |  |  | 2 | 7 | 0
Project D | 2025-04-02 00:00:00 | 2030-08-04 00:00:00 |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 830791d1685114382-formula-for-daily-cash-balancing-book1
Sheet: Sheet1

2023-05-25 00:00:00 |  | 2023-05-26 00:00:00 |  | 2023-05-27 00:00:00
 |  | opening balance | 1000
 |  | less expense
 |  | wages | 800
 |  | Advt | 100
 |  | cleaning cost | 100
 |  | printing | 100
 |  | Crop insurance |  | 4% of total expenses
 |  | Loan | 0 | loan is taken to have enough funds to meet expense
 |  | interest |  | interest is 5% of loan
Closing Balance | 1000 | Closing Balance
 |  |  |  |  | Crop Insurance is to cover expenses and pay off their loan, quoted for 5% of Insurance Amount (expenses+loans+interest)
 |  |  |  |  | Loan is to cover the expenses
 |  |  |  |  | Interest is to paid in next month
 |  |  |  |  | I need to find a formula to find these 3 highlighted ones, but closing cash balance will never go below 0, zero is okay
Spreadsheet: 329433d1404309719-calculating-percentage-attendance-from-symbols-attendance
Sheet: Sheet1

 |  | /= Attended
 |  | L=Late
 |  | D=Departed Early
 |  | A=Authorised Absense
 |  | U=Unauthorised Absense
 |  | E=Explained Absense
 |  | N=Not Expected
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
Pupil | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | / | L | D | A | U | E | Total | / | L | D | A | U | E
[NAME] | / | L | D | A | U | E | D | A | N | N
[NAME]
[NAME]