tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 745342d1629875238-budget-and-cash-flow-formula-test-repeat-fixed-cost
Sheet: Ark1

 |  |  |  |  |  | Year | Year | Year | Year | Year | Total
 | Acquisition Year | Product Lifetime | Cost |  |  | 1 | 2 | 3 | 4 | 5
 | 2 | 3 | 999 |  | Row 1 |  |  |  |  |  |  | Writes data according to the ACQUISITION YEAR
 | 3 | 3 | 0 |  | Row 2 |  |  |  |  |  |  | Writes data according to the PRODUCT LIFETIME
 | 4 | 1 | 0 |  |  |  |  |  |  |  |  | How do i merge the two statements?
 | 5 | 3 | 0
 | 5 | 1 | 0
 | Total
Spreadsheet: 437548d1451399359-complex-if-statement-if-with-zone-and-date-_-for-shadmani
Sheet: Sheet1

Zone | [NAME] date | Late? | Late? |  | Zone | Last on time date
North | 2015-05-10 00:00:00 |  |  |  | East | 2015-05-20 00:00:00
North | 2015-05-26 00:00:00 |  |  |  | West | 2015-05-22 00:00:00
West | 2015-05-10 00:00:00 |  |  |  | North | 2015-05-25 00:00:00
West | 2015-05-23 00:00:00 |  |  |  | South | 2015-05-28 00:00:00
South | 2015-05-10 00:00:00
South | 2015-05-29 00:00:00
East | 2015-05-10 00:00:00
East | 2015-05-21 00:00:00
East | 2015-01-01 00:00:00
East | 2015-04-01 00:00:00
East | 2015-05-01 00:00:00
East | 2015-05-20 00:00:00
East | 2015-05-21 00:00:00
East | 2015-05-30 00:00:00
East | 2015-06-01 00:00:00
East | 2015-10-01 00:00:00
East | 2015-12-31 00:00:00
East | 2016-01-01 00:00:00
Spreadsheet: 703060d1604707683-count-quantity-of-varied-documents-by-month-jpfc-bt-count-dates
Sheet: FC Insights

[NAME] by Month | July | August | September | October | November | December | January | February | March | April | May | June | Total
SOA - Full | 5 | 7 | 4 | 8 | 1
Scoped SOA - Complex | 1 | 1 | 0 | 2 | 0
Scoped SOA - Simple | 6 | 2 | 5 | 0 | 1
Scoped SOA - Hold | 0 | 0 | 0 | 0 | 0
ROA - Complex | 3 | 2 | 5 | 3 | 0
ROA - Simple | 10 | 10 | 6 | 13 | 0
ROA - Transactional | 16 | 13 | 10 | 17 | 0
ROA - Hold | 0 | 1 | 0 | 18 | 3
EO | 6 | 3 | 1 | 2 | 1
Research - Simple | 2 | 0 | 1 | 0 | 0
Research - Complex |  | 0 | 0 | 0 | 0
Current Position |  | 0 | 0 | 0 | 0
Discovery Profile | 1 | 1 | 0 | 2 | 0
Nod - ROA Hold |  | 0 | 0 | 5 | 0
Nod - ROA Simple |  | 0 | 0 | 0 | 0
Nod - SOA Hold |  | 0 | 0 | 0 | 0
Nod - SOA Simple |  | 0 | 0 | 0 | 0
Total
Spreadsheet: 69872d1270560400-pulling-data-from-another-sheet-with-drop-down-menu-testsports
Sheet: Sheet2

Sports |  | NFL |  | NBA |  | MLB
NFL |  | Vikings |  | Lakers |  | Cardinals |  | 5 | Lakers | 2010-03-01 00:00:00 | @ | Celtics | [NAME] vs. [NAME], tonight, on ESPN!
NBA |  | Chiefs |  | Celtics |  | Diamondbacks |  |  | Lakers | 2010-03-02 00:00:00 | vs | Cavaliers | [NAME] wishes he was 24!
MLB |  | [NAME] |  | Magic |  | Yankees |  |  | Lakers | 2010-03-03 00:00:00 | vs | Magic | Can the Magic and [NAME] pull off the major upset?
MLS |  | Eagles |  | Spurs |  | Red Sox |  |  | Lakers | 2010-03-04 00:00:00 | @ | Spurs | [NAME] is a baby!
NHL |  | Cowboys |  |  |  |  |  |  | Lakers | 2010-03-05 00:00:00 | @ | Nets | The Nets are bad, and are willing to prove it, tonight on TNT!
Spreadsheet: 759769d1639720263-sort-function-with-indirect-formula-sample
Sheet: ExpectedResult

Date | 2021-12-13 00:00:00 | <---Sheet Name
S No | Project | [NAME] | Dept | Ranking | Comments
1 | B65 | ABR | TR | RED | Needs discussion on resource planning
2 | HGXY | YPS | IR | RED | Additional Task from Client
3 | YZM | [NAME] | IR | RED | 456466
4 | Test | [NAME] | IR | RED | NA
5 | ABC | Inc11 | TR | Amber | Needs support from automation
6 | Auto | [NAME] | IR | Amber | xxxx
7 | VRT | PTD | TR | Green
 | Cell B4 formula =sort('13-Dec-21'!B2:F100,match('13-Dec-21'!E2:E100,{"RED";"Amber";"Green"},0),true,match('13-Dec-21'!D2:D100,{"TR";"IR"},0),true)
 | The formula should check the B1 cell value as "Sheet Name" and calculate the value
 | Sort Criteria 1 | RED
 |  | Amber
 |  | Green
 | Sort Criteria 2 | TR
 |  | IR
Spreadsheet: 136560d1326724251-how-do-i-calculate-the-value-in-a-column-within-a-particular-month-book5
Sheet: Sheet1

Date | Total
2012-01-02 00:00:00 | 10
2012-01-30 00:00:00 | 10
2012-02-02 00:00:00 | 10
2012-01-01 00:00:00 | 10
2012-01-24 00:00:00 | 10
2012-03-05 00:00:00 | 10
2012-03-30 00:00:00 | 40
2012-01-01 00:00:00 | 40
2012-02-01 00:00:00 | 10
2012-03-01 00:00:00 | 50
2012-04-01 00:00:00 | 0
Spreadsheet: d4088125-d319-4877-b2b3-39f25654f48d
Sheet: InstructionalMethod

Code | Type | Definition | K8 or 9-12 usage
CR | Classroom | Instruction is predominately face-to-face in a classroom setting; internet and other instructional management systems maybe employed to track grades, assignments and homework. | 9-12
CS | Classroom Self-Contained | Instruction is delivered by a single teacher and is predominately face-to-face in a classroom setting; internet maybe used as an instructional tool.  Management systems maybe employed to track grades, assignments and homework. | K8
CT | Classroom Team | Instruction is delivered by multiple teachers assigned to a single or multiple grade levels or content areas. | K8
CC | Classroom Collaborative | External and/or internal instructional leaders model lessons, observer and coach classroom teachers; often a purchased instructional program with substantial teacher professional development may be associated with a college or university. | K8
CL | Classroom Looped | One or more teachers continue instruction with a group of students through two or more grade levels. | K8
CP | Computer Program | All instruction is delivered through a computer program which may be online or from a CD-ROM. | Both
ITVS | ITV Sending | Interactive live video course.  This designation denotes the section where the instructor is present. | Both
ITVR | ITV Receiving | Interactive live video course.  This designation denotes the section in which students receive the course via ITV. | Both
BH | Blended/Hybrid | This designation denotes reduced classroom seat time and some instruction delivered online.  This designation blends online and face-to-face delivery. | Both
G | Guided | Teacher acts as guide or mentor to student independent work.  Use this designation for scheduled courses classified according to the MCCC as Independent Study. | Both
CO | Completely Online | All instruction is delivered online.  This designation has no required face-to-face meetings.  A student may arrange meetings with small groups of classmates or the instructor. | Both
O | Other | Use this designation when no other designation adequately describes the course delivery type. | Both
Spreadsheet: 823819d1680155160-copy-if-not-isblank-formula-in-multiple-cells-of-spreadsheet-at-one-time-matrix-excel-help-
Sheet: Grade Selection

 | Relevant Experience | Diversity of Experience | Education | Certification | PME | Supervisor [NAME] |  | total
N/A | N/A | Choose a Matrix above in Cell D2 | N/A | N/A | N/A | N/A
GS-12/13 (NH-03/NJ-04) Non-Supervisory / No Certification | 60 | 20 | 15 | 0 | 5 | 0
GS-12/13 (NH-03/NJ-04) Non-Supervisory / with Certification | 50 | 20 | 15 | 10 | 5 | 0
GS-12/13 (NH-03/NJ-04) Supervisory or Lead / No Certification | 60 | 20 | 15 | 0 | 5 | 15
GS-12/13 (NH-03/NJ-04) Supervisory or Lead / with Certification | 50 | 20 | 15 | 10 | 5 | 15
GS-11/Below (NH-02/NJ-03/NK-03 & Below) Non-Supervisory / No Certification | 70 | 15 | 15 | 0 | 0 | 0
GS-11/Below (NH-02/NJ-03/NK-03 & Below) Non-Supervisory / with Certification | 60 | 15 | 15 | 10 | 0 | 0
GS-11/Below (NH-02/NJ-03/NK-03 & Below) Supervisory or Lead / No Certification | 70 | 15 | 15 | 0 | 0 | 15
GS-11/Below (NH-02/NJ-03/NK-03 & Below) Supervisory or Lead / with Certification | 60 | 15 | 15 | 10 | 0 | 15
FWS Non-Supervisory / No Certification | 80 | 10 | 10 | 0 | 0 | 0
FWS Non-Supervisory / with Certification | 70 | 10 | 10 | 10 | 0 | 0
FWS Supervisory or Lead / No Certification | 80 | 10 | 10 | 0 | 0 | 15
FWS Supervisory or Lead / with Certification | 70 | 10 | 10 | 10 | 0 | 15
Spreadsheet: 229619d1366472836-its-complicated-to-explain-see-the-tables-i-made-book11
Sheet: Sheet1

Column1 | Column2 | Column3 | Helper |  |  |  |  | Result
61 | 250 | 7890
62 | 450 | 7890
63 | 300 | 7890
65 | 690 | 7769
69 | 480 | 7769
85 | 900 | 6922
Spreadsheet: 149524d1334001107-insert-output-of-the-formula-in-a-different-cell-book1
Sheet: Sheet1

 | Jan | Feb | Mar | April | May | June
 | IF(B8>0,B8*B9,0) | IF(C8>0,C8*C9,0) | IF(D8>0,D8*D9,0)
completion time | 3 | 3 | 3
Units bought | 2 | 0 | 4
Estimated sales price per unit | 10 | 9 | 11
Units completed and sold |  |  |  | 20 | 0 | 40
Requirement | [NAME] in B6 should automatically put the output in E10 because  B is column #2 and when we add 3 (from B7 ) the column # for output cell will become E. Row number is constant at 10 This can be achieved by =[NAME]) which will give E$10
 | How can I get the output of the formula in [NAME]  to display in E10 (B7 could be any number)
 | E$10 | F$10 | G$10
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: December

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 150
Name 151
Name 152 |  |  |  |  |  |  |  |  | Done Totals
Name 153 |  |  |  |  | q |  |  |  | Outstanding Totals
Name 154 |  |  |  |  | w
Name 155 |  |  |  |  | ew
Name 156 |  |  |  |  | ew
Name 157
Name 158
Name 159
Name 160
Name 161
Spreadsheet: 786055d1656949146-getpivotdata-sum-of-different-fields-some-are-empty-some-are-not-test
Sheet: Sheet1

OrderNumber | Product | Status |  |  | Row Labels | Count of OrderNumber |  | Explanation of problem | I want the sum of all canceled orders.
1 | A | Completed |  |  | A | 3 |  |  | A has 1 canceled orders
2 | B | Completed |  |  | Canceled | 1 |  |  | B has 0 canceled orders
3 | C | Completed |  |  | Completed | 2 |  |  | C has 2 canceled orders
4 | C | Canceled |  |  | B | 3
5 | B | Completed |  |  | Completed | 3 |  |  | So, I should get 3.
6 | A | Completed |  |  | C | 4 |  |  | But I can only get "-" (my iferror result) or #[NAME] because there is no canceled orders for product B
7 | C | Canceled |  |  | Canceled | 2 |  | [NAME] (with IFERROR)
8 | B | Completed |  |  | Completed | 2 |  | [NAME] (without IFERROR)
9 | A | Canceled |  |  | Grand Total | 10
10 | C | Completed
Spreadsheet: 65258b08-3145-4362-889b-4a2ef65410e2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Student Payroll       STUDENT HOURLY HIRE LIST        School Year: ____________________
 | Please complete all information. |  |  |  |  | Please Circle Term:         ( Fall / Spring )         Summer
 | Business Office                             Use Only | STUDENT LEGAL NAMES                      (No Nicknames) (must match SU information) |  |  | Use Student ID #'s                      on all Payroll Forms |  |  |  |  |  | [NAME].# of Hours Per Semester
 |  | Last | First | M.I. | Student ID # | [NAME] # | New          or          Rehire | Start Date | End Date | [NAME] | Unless limited by FA Office. | Pay Code Financial Aid Use Only
 | Example: | Doe | [NAME] | L. | 1234567 | 7488 | R | 2011-08-27 00:00:00 | 2012-12-16 00:00:00 | 7.25 | 374
 |  | Fall Hours - Semester Limit (Unless limited by the Financial Aid Office) |  |  |  |  |  | 2012-08-27 00:00:00 | 2012-12-16 00:00:00 |  | 374
 |  | Spring Hours - Semester Limit (Unless limited by the Financial Aid Office) |  |  |  |  |  | 2013-01-14 00:00:00 | 2013-05-12 00:00:00 |  | 289
 |  | Summer Hours - Semester Limit (Unless limited by the Financial Aid Office) |  |  |  |  |  | 2013-05-13 00:00:00 | 2013-08-25 00:00:00 |  | 221
 | Students are never to earn over 884 total hours for the "Calendar Year".  (Financial Aid may also limit hours.)
 | Dept. [NAME] (Please Print):___________________________________________ |  |  |  |  | Ext. #__________  Dept._________________________________
 | Department Supervisor Signature:____________________________________________________ |  |  |  |  |  | Department Account   # | _____-_________-____________*
 | Authorization to sign student time sheets: |  |  |  |  | *Academic Year Term: - 51830   *Summer Term: - 51835
 | Name: ______________________________ Signature: _______________________________________________
 | Date Signed: _________________________         Budget Officer Approval:___________________________________________
 | Students are never to earn over 884 total hours for the "Calendar Year".  (Financial Aid may also limit hours.)
 | **Please Complete all Information and Return This Form To The Business Office**
 | For Pay Period Calendar and other Payroll Information visit our web site:     http://www.southwestern.edu/businessoffice/
 | [NAME]
Spreadsheet: ef4bfbc7-8eb4-474b-8ac7-9294be2a99b3
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SDEX | Test | SDEX | [NAME], Screen, Blood | [NAME], Scrn, B | [NAME] | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD (solution B), heparin [NAME]: 1 mL  Additional Information: 1. Patient's age is required. 2. Include recent transfusion information. Forms: If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | Negative Precautions: The procedure does not distinguish hemoglobin S trait from homozygous sickle cell disease nor any of the following combinations: S/C, S/D, S/G, S/E, S/thalassemia, S/O-Arab, S/New York and C-Georgetown trait (Hb C-Harlem). | Monday through Saturday | 1 day | 4 days | 1 | 85660 |  |  |  |  | Rochester
SDEX | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
SDEX | Result | 9180 | [NAME], Scrn, B | [NAME], Scrn, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4621-9 | [NAME]:ACnc:Pt:[NAME]:Ord:
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: Book Income Statement

 | Income Statement
 |  |  | 1
 | REVENUE
 | Energy Revenues
1 | Capacity Revenues
 | Variable Energy Payment
 | Block Revenue
 | Energy Margin
 | Ancillary Services
 | Fees
 | Total Revenue
 | EXPENSES
 | Variable Expenses:
 | Fuel and start up fuel
3 | Water Treatment
3 | FERC Fee
3 | Variable Maintenance
 | Total Variabl Op. Costs
 | Total Variable Expenses
 | Per Start Expenses:
4 | Start-Up Fuel
5 | Major [NAME]
 | Total Per Start Expenses
 | Fixed Expenses:
2 | Payroll & Burden
2 | Other O&M Expenses
12 | Admin Fee
 | Marketing Fee
9 | O&M Fee
 | Total Fixed Expenses
 | Fixed [NAME]:
6 | Total Insurance
7 | Utilities : Start Up Power
 | Utilities : Facility Load
7 | Interconnection Fees
7 | Gas Pipeline Metering
7 | Miscellaneous
 | Total Fixed G&A
8 | Property Taxes
 | Operating Taxes
8 | Franchise Tax
8 | Gross Receipts Tax
 | Total Operating Taxes
 | TOTAL EXPENSES
 | EBITDA
11 | Book Depreciation & Amortization
 | Project Cost Expensed |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | EBIT
 | Interest Expense
10 | Interest Income
 | Net Interest Expense
 | EBT
 | Book Provision for Taxes
 | After Tax Book Income
 | NPV of 2001 EBTD |  | 0 | 0
 | NPV of 2001 Earnings |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 847765d1698647612-extracting-values-vertically-based-on-two-categories-sample-workbook-for-horizontally
Sheet: Output_Horizontally

S.No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  | India
Apple | 12 |  |  |  |  |  |  |  |  | Singapore |  | Singapore
Orange | 6 | 9 | 12 |  |  |  |  |  |  |  |  | Nepal
Pineapple | 12 |  |  |  |  |  |  |  |  |  |  | France
Mango | 9 | 12 | 17 |  |  |  |  |  |  |  |  | USA
Spreadsheet: 867683d1714489496-randomize-golf-teams-based-on-skill-level-teams-carcher05-
Sheet: START

PLAYERS | UNIQUE | RANK |  | NUMBER OF TEAMS
AL P |  |  |  | 5
BILLY
[NAME]
CHIP MANNING
[NAME]
DOCTOR BOB
[NAME]
[NAME]
GENE DUDLEY
JACK SWAN
JIMMY
LYNN HOLYFIELD
[NAME]
[NAME]
NICK COUCH
NOLAN COUCH
PHIL KELLY
[NAME]
[NAME]
RICK RICHTER
TERRY DANIEL
[NAME]
[NAME]
Spreadsheet: 826925d1682375398-accumulating-monthly-data-into-annual-based-on-indicate-in-group-b-excel_help
Sheet: Sheet1

Group A
Date | A
2026 Jan | 3 |  |  |  |  | Group B
2026 Feb | 4 |  |  |  |  | Year | 2026 | 2027
2026 Mar | 5 |  |  |  |  | A
2026 Apr | 2
2026 May | 4 |  |  |  |  | Date | Sum
2026 Jun | 46 |  |  |  |  | 2026 | 100
2026 Jul | 7 |  |  |  |  | 2027 | 50
2026 Aug | 8
2026 Sep | 9
2026 Oct | 4 |  |  | I want to accumulate monthly data into annual based on indicate in group B
2026 Nov | 3
2026 Dec | 5
2027 Jan | 6
2027 Feb | 7
2027 Mar | 8
2027 Apr | 9
2027 May | 0
2027 Jun | 4
2027 Jul | 4
2027 Aug | 4
2027 Sep | 2
2027 Oct | 2
2027 Nov | 2
2027 Dec | 2
Spreadsheet: 73012d1273678175-calculate-intersection-point-of-2-products-sales-book1
Sheet: Sheet1

Old Product Sales |  | Old | New
2009-09-30 00:00:00 | 1 | 2975 | 34 |  |  |  | co-efficient | constant
2009-10-31 00:00:00 | 2 | 3040 | 102 |  |  | old sales | -65.357 | 2995.7
2009-11-30 00:00:00 | 3 | 2550 | 280 |  |  | new sales | 142 | -139.71
2009-12-31 00:00:00 | 4 | 2704 | 455
2010-01-31 00:00:00 | 5 | 2757 | 582 |  | Period | 15.12083025892543 | -207.357 | 3135.41
2010-02-28 00:00:00 | 6 | 2374 | 655
2010-03-31 00:00:00 | 7 | 2740 | 890
Spreadsheet: 12c6b00a-d4e3-42b7-9570-7bbf154551e4
Sheet: Calculation

Worksheet for Calculating Grain Contributions from a Recipe
1. Creditable Grain Ingredient | 2. Quantity | 3. [NAME] to [NAME] | [NAME]
4. Total [NAME]
5. Total grams divided by number of portions in recipe:
Total grams of creditable grains from step 4
Enter Number of portions
[NAME] of creditable grains per portion
6. Divide number of grams per portion
Grains/serving
7. Round down to the nearest 0.25 grains/serving
Ounce equivalent grains
* Must enter information into silver fields
Spreadsheet: ec74e5d8-9582-472d-afae-ad9dc3b11549
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
08/31/2013 | Football | William & Mary | Noon
09/07/2013 | Football | at Oklahoma* | 7 p.m.
09/14/2013 | Football | Georgia State | Noon
09/21/2013 | Football | vs. Maryland (Baltimore, Md.) | TBA
[NAME] | Football | Oklahoma State* | TBA
10/05/2013 | Football | at Baylor* | TBA
10/19/2013 | Football | Texas Tech* | TBA
10/26/2013 | Football | at Kansas State* | TBA
11/02/2013 | Football | at TCU* | TBA
11/09/2013 | Football | Texas* | TBA
11/16/2013 | Football | at Kansas* | TBA
11/30/2013 | Football | Iowa State (or played on Nov. 29)* | TBA
Spreadsheet: 888407d1738884301-create-summary-by-month-for-data-on-multiple-monthly-sheets-mobsync-cust-info
Sheet: Jan2025

Cust_# | Name | Qty | Total | Maj
9097 | Central | 3 | 340 | YO
9097 | Central | 3 | 380 | YO
9097 | Central | 3 | 457.88 | HK
9097 | Central | 3 | 232.92 | AB
709 | 49 CENTER | 5 | 973.76 | YO
709 | 49 CENTER | 7 | 111.56 | YO
709 | 49 CENTER | 1 | 105.98 | AB
709 | 49 CENTER | 2 | 198 | HK
709 | 49 CENTER | 8 | 581 | HK
Spreadsheet: 824690d1680772851-create-table-from-many-tables-at-different-sheets-book2
Sheet: Table 2

Column1 | Column2 | Column3
Acetamiprid
Atenolol
[NAME]
Benzotriazole
Bisoprolol
Bisphenol A
[NAME]
Ciprofloxacin
Citalopram
Clarithromycin
Diclofenac
Erythromycin
[NAME] (E2)
Estrone
Etinylestradiol (EE2)
Fluconazole
Furosemide
Hydrochlorothiazide
Fluoxetine
Spreadsheet: 819767d1677685237-how-many-days-in-each-calendar-year-based-on-start-and-finish-date-sample-chrismattock
Sheet: Sheet1

 |  | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
Start | Finish | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2025-01-01 00:00:00 | 2026-01-01 00:00:00 | 2027-01-01 00:00:00 | 2028-01-01 00:00:00
2023-02-01 00:00:00 | 2028-05-01 00:00:00
2023-05-01 00:00:00 | 2023-07-01 00:00:00
2024-02-01 00:00:00 | 2025-09-01 00:00:00
Spreadsheet: 808251d1670366886-multiple-replace-of-partial-texts-multiple-replace-of-partial-texts
Sheet: Sample

Input | Output |  | Replace | WITH
XX FIAT | AA FIAT |  | XX | AA
XX GM | [NAME] |  | YY | BB
[NAME] | [NAME] |  | ZZ | CC
YY FIAT | BB FIAT
YY GM | BB GM
YY HONDA | [NAME]
FIAT ZZ | FIAT CC
GM ZZ | GM CC
HONDA ZZ | HONDA CC
Spreadsheet: 146206d1331976414-when-full-shortage-quantity-is-getting-received-when-is-receipts
Sheet: Shortage Details

 | Mar | Apr | May | Jun | Jul | Aug
Product 1 | -100 | -500 | -1100 | -2100 | -5100 | -5400
Product 2 | 0 | -5000 | -9000 | -16000 | -16700 | -20700
Product 3 | -3000 | -3015 | -10015 | -10285 | -10585 | -10675
Product 4 | -600 | -1000 | -6000 | -6700 | -12700 | -15900
Product 5 | -4000 | -6300 | -13300 | -16500 | -19500 | -24500
Product 6 | 0 | -3300 | -3400 | -3700 | -3730 | -6730
Product 7 | -4000 | -4050 | -9050 | -9110 | -11110 | -11200
Product 8 | -1000 | -1100 | -3400 | -3800 | -7100 | -7700
Product 9 | -10000 | -25000 | -34900 | -35300 | -38600 | -39100
Product 10 | -6000 | -10000 | -13000 | -15000 | -18800 | -19800
Spreadsheet: tracy_geaccone__40346__sharris1001wk3
Sheet: Plan vs. Forecast

Transwestern Pipeline Company
($[NAME])
October:  10/01/01 thru 10/16/01 |  |  |  |  |  | 2001-10-18 09:49:49.190000
Plan vs. Forecast |  | October, 2001
 |  |  | Weekly
 |  | Plan | Forecast | [NAME] |  | Comments
West Demand Revenues |  | 10.272 | 10.539 | 0.2669999999999995 |  | New Contracts; Higher rates
West Commodity Revenues |  | 0.853135 | 0.9064820000000005 | 0.05334700000000048
East Demand Revenues |  | 1.044 | 1.228 | 0.1839999999999999 |  | New Contracts
East Commodity Revenues |  | 0.138 | 0.1579999999999999 | 0.01999999999999991
[NAME] |  | 0.635 | 0.694 | 0.05899999999999994 |  | New Contracts; [NAME] rates
[NAME] Revenues |  | 0.08299999999999996 | 0.06200000000000006 | -0.02099999999999991
[NAME] |  | 0 | 0.005047899999999999 | 0.005047899999999999
Revenue Variance |  | 13.026135 | 13.5925299 | 0.5663948999999988
Fuel Price [NAME] |  | 1.104 | 0.599 | -0.505 |  | MTD index price of $1.84 vs. Plan index price of $3.39
Fuel Volume Variance-Unhedged |  | 0 | -0.227 | -0.227
Sales Margin Variance on Unhedged |  | 0 | 0.048 | 0.048
Hedging Adjustment |  | 2.199 | 2.206 | 0.007000000000000117
Other Adjustment |  | 0.002 |  | -0.002
Fuel Variance (Excludes UAF) |  | 3.305 | 2.626 | -0.6789999999999999
Monthly Stretch |  | 0.838 | 0 | -0.838
Target Adjustment |  | -0.3 | 0 | 0.3
Current Month Margin Variance |  | 16.869135 | 16.2185299 | -0.650605100000001
Expenses |  | -1.018 | -0.944 | 0.07400000000000007
Non-Recurring |  | 0 | 0 | 0
Other |  | -0.004 | -0.004 | 0
Total Current Month Variance |  | 15.847135 | 15.2715299 | -0.576605100000001
[NAME] |  | 44.342 | 47.153 | 2.811
2nd Qtr |  | 43.266 | 52.278 | 9.012
1st Qtr |  | 45.571 | 47.784 | 2.213000000000001
October 31, 2001 YTD |  | 149.026135 | 162.4865299 | 13.46039489999998 |  | Includes YTD Target adjustment of ($3.3)
 |  |  |  |  |  | Includes September Actuals
 |  |  |  |  |  | YTD variance decreased due to OBA re-evaluations for August & September