tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: TTM Recon Q1FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended June 30, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Gain on strategic Investments |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 3773 |  | 0 |  | 40 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3813
Cost of revenue | 1517 |  | -12 |  | 0 |  | 1 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1504
Gross profit | 2256 |  | 12 |  | 40 |  | -1 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2309
Operating expenses:
Marketing and sales | 760 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -22 |  | 0 |  | 738
General and administrative | 301 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -37 |  | 0 |  | 264
Research and development | 1163 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -104 |  | 0 |  | 1059
Acquisition-related contingent consideration | -17 |  | 17 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 55 |  | -55 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -
Restructuring and other | 177 |  | 0 |  | 0 |  | 0 |  | 0 |  | -177 |  | 0 |  | 0 |  | -
Total operating expenses | 2439 |  | -38 |  | 0 |  | 0 |  | 0 |  | -177 |  | -163 |  | 0 |  | 2061
Operating income (loss) | -183 |  | 50 |  | 40 |  | -1 |  | 0 |  | 177 |  | 165 |  | 0 |  | 248
Gain on strategic investments | 28 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 0 |  | 0 |  | -
Interest and other income (expense), net | 13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 13
Income (loss) before provision for income taxes | -142 |  | 50 |  | 40 |  | -1 |  | -28 |  | 177 |  | 165 |  | 0 |  | 261
Provision for income taxes | 9 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 64 |  | 73
Net income (loss) | -151 |  | 50 |  | 40 |  | -1 |  | -28 |  | 177 |  | 165 |  | -64 |  | 188
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Sharon Durgin-Campbell

[NAME], MS
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
The provision should be standard between employers and employees because it is only fair that the persons who receive the benefits of the
negotiation should contribute their fair share.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
Not meeting this committment would lack transparency that the voters have a right to expect from their government concerning existing
commitments it has made.
Health Care: Continuing System Reform
Disagree
Explain your health care reform position, if you choose
The statement is convoluted and does little to acknowledge the contributions of other employee groups throughout the state who may be
more vulnerable due to lack of representation.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Sadly there are not enough teaching positions available and the union has improved the career choice of teaching so that many teachers
tend to stay in the profession. The state should encourage youth to enter the profession but not manufacture jobs or unfairly  reward
education professionals over other state employees.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
The Vermont Department of Education is top heavy. We need fewer supervisors and less stringent re-certification procedures.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME], MS | [EMAIL] | 82 Baxter Street | House of Representatives | No |  | Rutland
Spreadsheet: 726143d1617071462-automatically-shift-data-in-cells-according-to-date-change-sliding-dates-referencing-input-table-manishman-
Sheet: Sheet3

 |  |  |  | DAYS:
 |  |  |  | Agent 1
 |  |  |  | Agent 2
Date | Agent 1 | Agent 2 |  | Sun-Sat
 |  | 3 |  | Mon-Sun
 |  | 6 |  | Tue-Mon
 |  | 6 |  | Wed-Tue
 |  |  |  | [NAME]
 |  | 3 |  | Fri-Thu
 |  |  |  | Sat-Fri
 |  |  |  | Sun-Sat
 |  | 3.5
 |  | 6
 |  | 3
 | 2
 | 3
 | 3
 |  | 2
 | 3
 |  | 2
 | 3
 |  | 2
 | 3
 |  | 2
Spreadsheet: 887110d1737254583-generating-1-column-of-data-into-a-calendar-generating-1-column-of-data-into-a-calendar
Sheet: Calendar

Treatment Plan Reviews Calendar
 |  | Spiderman | Su | M | [NAME] | W | Th | F | Sa
 |  |  |  | 1990-01-01 00:00:00 | 1990-01-02 00:00:00 | 1990-01-03 00:00:00 | 1990-01-04 00:00:00 | 1990-01-05 00:00:00 | 1990-01-06 00:00:00
 |  |  | 1990-01-07 00:00:00 | 1990-01-08 00:00:00 | 1990-01-09 00:00:00 | 1990-01-10 00:00:00 | 1990-01-11 00:00:00 | 1990-01-12 00:00:00 | 1990-01-13 00:00:00
 |  |  | 1990-01-14 00:00:00 | 1990-01-15 00:00:00 | 1990-01-16 00:00:00 | 1990-01-17 00:00:00 | 1990-01-18 00:00:00 | 1990-01-19 00:00:00 | 1990-01-20 00:00:00
 |  |  | 1990-01-21 00:00:00 | 1990-01-22 00:00:00 | 1990-01-23 00:00:00 | 1990-01-24 00:00:00 | 1990-01-25 00:00:00 | 1990-01-26 00:00:00 | 1990-01-27 00:00:00
 |  |  | 1990-01-28 00:00:00 | 1990-01-29 00:00:00 | 1990-01-30 00:00:00 | 1990-01-31 00:00:00
Spreadsheet: 24a9782c-ced5-4c77-a6c8-c8158fa42ff1
Sheet: Sheet1

SIU NAME  (POTW)= CDC (Rocky Mount) | Unnamed: 1 | 6/23/98; from synopsis/application | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
COMBINED WASTESTREAM FORMULA CALCULATIONS PERFORMED by DRF of DWQ Pretreatment Unit using data from source listed above
 |  |  |  |  | 1.A. GET FLOWS FROM SIU/POTW DATA
REGULATED WASTEFLOWS, gpd: | 27000
UNREGULATED WASTEFLOWS, gpd:
DILUTION WASTEFLOWS, gpd: | 45000
 |  |  |  |  | 2. [NAME]
TOTAL WASTEFLOWS, gpd: | 72000
CWF RATIO = (TOTAL FLOW - DILUTION FLOW) / TOTAL FLOW = |  |  | 0.375
 |  | ALTERNATIVE |  | ALTERNATIVE
 | CATEGORICAL | CATEGORICAL | CATEGORICAL | CATEGORICAL
 | DAILY MAXIMUM | DAILY MAXIMUM | MONTHLY AVERAGE | MONTHLY AVERAGE
PARAMETER | LIMIT, MG/L | LIMIT, MG/L | LIMIT, MG/L | LIMIT, MG/L
CADMIUM (Existing Sources) | 0.69 | 0.25875 | 0.26 | 0.0975
CADMIUM (New Sources) | 0.11 | 0.04125 | 0.07 | 0.02625
[NAME] | 2.77 | 1.03875 | 1.71 | 0.64125
COPPER | 3.38 | 1.2675 | 2.07 | 0.7762499999999999
LEAD | 0.69 | 0.25875 | 0.43 | 0.16125
NICKEL | 3.98 | 1.4925 | 2.38 | 0.8925
SILVER | 0.43 | 0.16125 | 0.24 | 0.09
ZINC | 2.61 | 0.97875 | 1.48 | 0.5549999999999999
CYANIDE, TOTAL | 1.2 | 0.45 | 0.65 | 0.24375
TTO | 2.13 | 0.79875
1. B. GET APPLICABLE CATEGORICAL STANDARDS
 |  |  |  |  | 3. MULITPLY RATIO TIMES STANDARD TO GET ALTERNATIVE STANDARDS
 |  |  |  |  | 4. THE LIMITS APPLIED IN THE PERMIT CANNOT BE LARGER THAN THESE VALUES
Spreadsheet: 115874d1311345578-excel-claim-sorting-claims-sorting
Sheet: Sheet1

2007-02-02 00:00:00 | 2008-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2006-02-02 00:00:00 | To | 2007-02-01 00:00:00
Serial | Date | Paid | Oustanding | Total | Title |  |  |  |  |  |  | 2007-02-02 00:00:00 | To | 2008-02-01 00:00:00
3 | 2007-02-04 00:00:00 | 12132 | 0 | 12132 | MD |  |  |  |  |  |  | 2008-02-02 00:00:00 | To | 2009-02-01 00:00:00
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  | 2009-02-02 00:00:00 | To | 2010-02-01 00:00:00
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  | 2010-02-02 00:00:00 | To | 2011-02-01 00:00:00
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  | Note: | Select the date from Cell A1 |  |  |  | 2011-02-02 00:00:00 | To | 2012-02-01 00:00:00
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  |  | Copy paste the formula in A3:F3 below
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  |  | Hide column M:O
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  |  | there is similar formula in A3&C3:F3
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  |  | There is separate formula in B3
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A |  |  | These are array formulas and should be confirmed throgh Ctrl+Shift+Enter
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | 2007-02-04 00:00:00 | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 496246d1483950139-get-names-that-meet-multi-criteria-book2-1-
Sheet: Sheet1

Name | ID | Rank | Country | City
[NAME] | 1001 | 0 | USA | Washington
[NAME] | 1002 | 0 | USA | Washington
[NAME] | 1003 | 1 | USA | California
Mark | 1004 | 0 | USA | Los Angeles
Leo | 1005 | 1 | USA | Washington
[NAME] | 1006 | 2 | UK | London
Rafael | 1007 | 2 | UK | Birmingham
Smith | 1008 | 2 | UK | Bristol
[NAME] | 1009 | 0 | UK | Canterbury
Spreadsheet: 219752d1362930903-inputed-transactions-get-assigned-to-category-financial-accounting-columbia-cu-practice-b
Sheet: Transactions

Transaction History
Account | Date | Check # | Payee | Memo | Category | Payment Amount | Deposit Amount | Amounts for Report | Cleared Payment | Cleared Deposit | Account Balance
 |  |  |  |  | AV Cash Deposits
Spreadsheet: 188527d1350916707-vlookup-syntax-required-to-look-up-period-date-if-i-put-yes-in-a-cell-period-dates
Sheet: Admin

Current Month |  | FY 13
 | April | 2012-03-31 00:00:00 | 2012-04-27 00:00:00
 | May | 2012-04-28 00:00:00 | 2012-05-25 00:00:00
 | June | 2012-05-26 00:00:00 | 2012-06-29 00:00:00
 | July | 2012-06-30 00:00:00 | 2012-07-27 00:00:00
 | August | 2012-07-28 00:00:00 | 2012-08-24 00:00:00
 | September | 2012-08-25 00:00:00 | 2012-09-28 00:00:00
Yes | October | 2012-09-29 00:00:00 | 2012-10-26 00:00:00
 | November | 2012-10-27 00:00:00 | 2012-11-23 00:00:00
 | December | 2012-11-24 00:00:00 | 2012-12-28 00:00:00
 | January | 2012-12-29 00:00:00 | 2013-01-25 00:00:00
 | February | 2013-01-26 00:00:00 | 2013-02-22 00:00:00
 | March | 2013-02-23 00:00:00 | 2013-03-29 00:00:00
 | April | 2013-03-30 00:00:00 | 2013-04-26 00:00:00
 |  | If Yes is input in the range A2:A14 then look up the period dates for the month in the data table C2:C14
 |  | and input these dates in C5 and C7 on the 'This Period' tab
Spreadsheet: 227198d1365625742-structure-problem-got-to-read-the-the-problem-book1
Sheet: Sheet1

Store 1 |  | Store 2 |  | Store 3 |  | Store 4 |  | Store 5 |  | Store 6
Products | Price | Products | Price | Products | Price | Products | Price | Products | Price | Products | Price
Apples | 32 | Apples | 32 | [NAME] | 13 | Apples | 32 | Oranges | 54 | Apples | 32
Oranges | 54 | Oranges | 54 | [NAME] | 96 | Oranges | 54 | Kiwi | 52 | Kiwi | 52
Kiwi | 52 | Kiwi | 52 | Watermellon | 22 | Kiwi | 52 | [NAME] | 76 | [NAME] | 13
[NAME] | 76 | [NAME] | 76 | Blueberry | 56 | [NAME] | 76 | [NAME] | 13 | [NAME] | 96
[NAME] | 13 | [NAME] | 96 | [NAME] | 76 | [NAME] | 13 | [NAME] | 96 | Watermellon | 22
[NAME] | 96 | Watermellon | 22 | Papaya | 23 | [NAME] | 96 | Watermellon | 22 | Papaya | 23
Watermellon | 22 | Blueberry | 56 | [NAME] | 74 | [NAME] | 74 | [NAME] | 74 | [NAME] | 74
Blueberry | 56 |  |  | Ananas | 23 | Ananas | 23 |  |  | Ananas | 23
Papaya | 23
[NAME] | 74
Ananas | 23
Would like to have like this.
Store 1 |  | Store 2 |  | Store 3 |  | Store 4 |  | Store 5 |  | Store 6
Products | Price | Products | Price | Products | Price | Products | Price | Products | Price | Products | Price
Apples | 32 | Apples | 32 | Apples |  | Apples | 32 | Apples |  | Apples | 32
Oranges | 54 | Oranges | 54 | Oranges |  | Oranges | 54 | Oranges | 54 | Oranges
Kiwi | 52 | Kiwi | 52 | Kiwi |  | Kiwi | 52 | Kiwi | 52 | Kiwi | 52
[NAME] | 76 | [NAME] | 76 | [NAME] | 76 | [NAME] | 76 | [NAME] | 76 | [NAME]
[NAME] | 13 | [NAME] |  | [NAME] | 13 | [NAME] | 13 | [NAME] | 13 | [NAME] | 13
[NAME] | 96 | [NAME] | 96 | [NAME] | 96 | [NAME] | 96 | [NAME] | 96 | [NAME] | 96
Watermellon | 22 | Watermellon | 22 | Watermellon | 22 | Watermellon |  | Watermellon | 22 | Watermellon | 22
Blueberry | 56 | Blueberry | 56 | Blueberry | 56 | Blueberry |  | Blueberry |  | Blueberry
Papaya | 23 | Papaya |  | Papaya | 23 | Papaya |  | Papaya |  | Papaya | 23
[NAME] | 74 | [NAME] |  | [NAME] | 74 | [NAME] | 74 | [NAME] | 74 | [NAME] | 74
Ananas | 23 | Ananas |  | Ananas | 23 | Ananas | 23 | Ananas |  | Ananas | 23
Spreadsheet: 09a27248-1702-4558-935b-b739e127a123
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
GDUR | Test | GDUR | Gadolinium, Random, [NAME] | Gadolinium, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 2 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. | 0.4 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-0.4 mcg/L Reference values apply to all ages. | Thursday; 11 a.m. | 1 day | 7 days | 1 | 83018 |  |  |  |  | Rochester
GDUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
GDUR | Result | 29276 | Gadolinium, Random, U | Gadolinium, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 8200-8 | Gadolinium:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 167951d1342167229-formula-to-auto-calculate-total-amount-at-the-last-row-of-the-day-formula
Sheet: Sheet1

Product | Amount | Total amount of the day
20-06-2012
AAA | 5
BBB | 6
CCC | 10
21-06-2012
BBB | 3
CCC | 2
DDD | 3
BBB | 5
22-06-2012
AAA | 1
BBB | 2
CCC | 3
DDD | 4
EEE | 5
BBB | 6
CCC | 7
Query
Is there any formula that we can enter at column C which is able to auto calculate total amount of the day at the last row of the day?
Set a formula to pull down, total amount of the day will be calculated at the last row of the day
Currently I enter sum formula at the last row of the day to calculate total amount of the day manually. It is not smart enough for a very big file.
Please help
Spreadsheet: 697963d1601647293-ranking-based-on-criteria-test-wk
Sheet: Test

 |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Rank | Desired Rank | WK9128 | Bo_Ry | Bo_Ry
CTR_01 | 3.5 | Urgent | 2020-04-15 00:00:00 |  | 1 |  |  |  | * Ranking is getting sarted from 0 rather than 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  | * Ranking is needed for only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.44 | Urgent | 2020-05-11 00:00:00 |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  | 2
CTR_06 | 3.4 | Urgent | 2020-04-09 00:00:00
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  | 3
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00
CTR_11 | 3.4 | Urgent | 2020-05-14 00:00:00 |  |  |  |  |  | *As the date is before H2, it should not be considered for ranking
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-15 00:00:00 |  | 4
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 5
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 5
Spreadsheet: 38124d1236251550-excel-2007-significant-loss-of-functionality-error-forex-journal-live
Sheet: NOVTOTALS

DATE | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | Gross P/L | PIPS | DEPOSITS & WITHDRAWALS
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
 | WINS | LOSSES | WIN $ | LOSS $ | WIN % | LOSS % | ACCOUNT $ TOTAL | TOTAL PIPS | TOTAL $ IN/OUT
TOTALS
 | ACTUAL WIN/LOSS $ |  |  |  |  |  | AV. $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)
Spreadsheet: 586279d1534283542-conditional-formatting-to-highlight-rows-excel-forum
Sheet: Sheet1

 | A | B | C | D | E
 | 2017-08-01 00:00:00 | Foodsby, Inc |  | 321.96 | ACH CREDIT
 | 2017-08-01 00:00:00 | Square Inc |  | 861.87 | ACH CREDIT
 | 2017-08-01 00:00:00 | Square Inc | 1500 |  | BOOK TRANSFER
 | 2017-08-02 00:00:00 | UBER |  | 571.87 | ACH CREDIT
 | 2017-08-02 00:00:00 | Square Inc |  | 1238 | ACH CREDIT
 | 2017-08-02 00:00:00 | 1211 | 3027.63 |  | PAID CHECK
 | 2017-08-02 00:00:00 | Square Inc | 47.97 |  | ACH CREDIT
 | 2017-08-02 00:00:00 | CSG/GUARDIANALRM  AC | 37.83 |  | ACH CREDIT
 | 2017-08-02 00:00:00 | AUTHNET GATEWAY   BI | 15 |  | ACH CREDIT
 | 2017-08-03 00:00:00 | Square Inc |  | 846.49 | ACH CREDIT
 | 2017-08-03 00:00:00 | OASISINVBATCH     IN |  | 4250 | BOOK TRANSFER
 | 2017-08-03 00:00:00 | OASISINVBATCH     IN |  | 2200 | BOOK TRANSFER
 | 2017-08-03 00:00:00 | OASISINVBATCH     IN | 3792.02 |  | ACH CREDIT
 | 2017-08-03 00:00:00 | UBER | 2310 |  | PAID CHECK
 | 2017-08-04 00:00:00 | Square Inc |  | 893.03 | ACH CREDIT
 | 2017-08-04 00:00:00 | UBER | 68.63 |  | PAID CHECK
Spreadsheet: 104064d1301682483-create-macro-reimbursements-village2
Sheet: Sheet1

Name: | Location | TOWN | SUBURB | RURAL | TOWN Limit $1500 | Suburb 50% refund on amount | Rural Max $1000
[NAME] legend | Village | 1000
[NAME] legend | Village | 600
[NAME] legend | Village |  |  | 400
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T4

الجدول 4: السكان في مصر بحسب [NAME] تعداد 1996
Table 4: Population of Egypt by age groups, 1996 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total |  | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | … | … | … | … | 1274892 | 1221449 | 2236884 | 2122017 | 3511776 | 3343466 | 6855242
5-9 | … | … | … | … | 1464520 | 1387698 | 2474601 | 2299433 | 3939121 | 3687131 | 7626252
10-14 | … | … | … | … | 1602009 | 1514199 | 2474592 | 2273202 | 4076601 | 3787401 | 7864002
15-19 | … | … | … | … | 1510230 | 1420081 | 2092627 | 1878673 | 3602857 | 3298754 | 6901611
20-24 | … | … | … | … | 1167895 | 1105656 | 1474725 | 1326860 | 2642620 | 2432516 | 5075136
25-29 | … | … | … | … | 933765 | 982469 | 1171298 | 1282990 | 2105063 | 2265459 | 4370522
30-34 | … | … | … | … | 917762 | 929346 | 1075450 | 1057162 | 1993212 | 1986508 | 3979720
35-39 | … | … | … | … | 879215 | 896879 | 1035152 | 1048859 | 1914367 | 1945738 | 3860105
40-44 | … | … | … | … | 810931 | 763029 | 805518 | 793748 | 1616449 | 1556777 | 3173226
45-49 | … | … | … | … | 687877 | 609035 | 720621 | 678636 | 1408498 | 1287671 | 2696169
50-54 | … | … | … | … | 503584 | 481233 | 491352 | 545967 | 994936 | 1027200 | 2022136
55-59 | … | … | … | … | 372516 | 313625 | 404021 | 386511 | 776537 | 700136 | 1476673
60-64 | … | … | … | … | 349766 | 315675 | 356423 | 377130 | 706189 | 692805 | 1398994
65-69 | … | … | … | … | 232503 | 172142 | 274582 | 251349 | 507085 | 423491 | 930576
70-74 | … | … | … | … | 144153 | 124912 | 171614 | 176990 | 315767 | 301902 | 617669
75+ | … | … | … | … | 106154 | 91128 | 134148 | 133428 | 240302 | 224556 | 464858
غير محدد    Not stated | … | … | … | … | 3 | 4 | 7 | 9 | 10 | 13 | 23
المجموع    Total | ... | ... | ... | ... | 12957775 | 12328560 | 17393615 | 16632964 | 30351390 | 28961524 | 59312914
Spreadsheet: 888215d1738688145-additional-ifs-or-another-approach-average-time-grid
Sheet: Grid

Home Team | Road Team
Eagles | Dragons
 |  |  |  | [NAME] | Lucas | [NAME] | [NAME] | [NAME] | [NAME]
Event |  | [NAME]
100m |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Eagles
Falcons
Dragons
Bears
M
F
Spreadsheet: 772786d1647461663-data-table-how-to-rearrange-dataset-sample-data
Sheet: Sheet1

Current DataSet |  |  | Prefer Data Format
ID | 1 |  | ID | First | Last
First | [NAME] |  | 1 | [NAME] | Doe
Last | Doe |  | 2 | [NAME] | [NAME]
ID | 2 |  | 3 | Jones | Daa
First | [NAME] |  | 4 | [NAME] | Dew
Last | [NAME]
ID | 3
First | Jones
Last | Daa
ID | 4
First | [NAME]
Last | Dew
Spreadsheet: 856416d1705664323-calculate-days-needed-from-month-to-month-question-for-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | CityCode | City | Regular Road | Com  Time | Start Date | Cars Month | Prod. Hours Per day | Correction Hours | KM Per Day | Downtime | Days Needed | End Date
 |  |  |  |  |  |  |  |  |  |  | GM0158 | Haaksbergen | 408 | 63 | 2024-04-24 00:00:00 | 4 | 7 | 1 | 240 | 30 | 3 | 2024-04-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  | GM0153 | Enschede | 963 | 62
 |  |  |  |  |  |  |  |  |  |  | GM0668 | West Maas en Waal | 297 | 62
 |  |  |  |  |  |  |  |  |  |  | GM1859 | Berkelland | 1000 | 60
 |  |  |  |  |  |  |  |  |  |  | GM1700 | Twenterand | 399 | 60
 |  |  |  |  |  |  |  |  |  |  | GM0406 | Huizen | 188 | 60
 |  |  |  |  |  |  |  |  |  |  | GM1581 | [NAME] | 439 | 59
 |  |  |  |  |  |  |  |  |  |  | GM0376 | Blaricum | 93 | 59
 |  |  |  |  |  |  |  |  |  |  | GM0995 | Lelystad | 692 | 58
 |  |  |  |  |  |  |  |  |  |  | GM0173 | Oldenzaal | 208 | 58
 |  |  |  |  |  |  |  |  |  |  | GM1509 | Oude IJsselstreek | 532 | 57
 |  |  |  |  |  |  |  |  |  |  | GM0164 | [NAME] | 510 | 57
 |  |  |  |  |  |  |  |  |  |  | GM0342 | Soest | 221 | 57
 |  |  |  |  |  |  |  |  |  |  | GM0183 | Tubbergen | 536 | 56
 |  |  |  |  |  |  |  |  |  |  | GM0308 | [NAME] | 177 | 56
 |  |  |  |  |  |  |  |  |  |  | GM0317 | Eemnes | 98 | 56
Spreadsheet: 740278d1626264937-sequence-numbers-based-on-condition-of-more-than-one-cell-wo-ser-wip
Sheet: Serials

Customer | Customer PO | Date | Works Order | Job Number | Qty | S/N Rqd? | Start Ser No | End Ser No | Notes: USE QTY 1 FOR CUSTOMER SPECIFIC SER NOS AND A RECORD DETAILS ON APPROPRIATE SHEET
A | 12110355 | 2021-06-25 00:00:00 | 2021-06-0045 | HCD1829 | 6 | Y | 186301
B | 102234B | 2021-06-28 00:00:00 | 2021-06-0046 | HCD5114 | 7 | N
C | 102233 | 2021-06-28 00:00:00 | 2021-06-0047 | HCD5054 | 5 | Y
D | 37658 | 2021-07-01 00:00:00 | 2021-07-001 | HCD4994 | 15 | Y
E | 36758 | 2021-07-01 00:00:00 | 2021-07-002 | HCD4993 | 10 | Y
F | [NAME] | 2021-07-02 00:00:00 | 2021-07-003 | HCD3252 | 52 | Y
G | [NAME] | 2021-07-06 00:00:00 | 2021-07-005 | HCD5042 | 30 | Y
H | [NAME] | 2021-07-06 00:00:00 | 2021-07-006 | HCD5044 | 30 | Y
D | E56341 | 2021-07-06 00:00:00 | 2021-07-007 | HCD2843 | 60 | Y