tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73703d1274312390-how-to-do-calculations-using-undetermined-cells-hilo
Sheet: Sheet1

Date | Close | High Crossing | [NAME] | Date |  | High: | 1.6
2010-05-17 00:00:00 | 0.98 |  |  |  |  | Low: | 0.55
2010-05-10 00:00:00 | 1.01
2010-05-03 00:00:00 | 1.03
2010-04-26 00:00:00 | 1.22
2010-04-19 00:00:00 | 1.24
2010-04-12 00:00:00 | 1.24
2010-04-05 00:00:00 | 1.1
2010-03-29 00:00:00 | 1.02
2010-03-22 00:00:00 | 1.06
2010-03-15 00:00:00 | 1.15
2010-03-08 00:00:00 | 1.08
2010-03-01 00:00:00 | 1.01
2010-02-22 00:00:00 | 0.99
2010-02-16 00:00:00 | 1.02
2010-02-08 00:00:00 | 1.02
2010-02-01 00:00:00 | 0.97
2010-01-25 00:00:00 | 0.96
2010-01-19 00:00:00 | 0.99
2010-01-11 00:00:00 | 1.1
2010-01-04 00:00:00 | 1.15
2009-12-28 00:00:00 | 1.18
2009-12-21 00:00:00 | 1.05
2009-12-14 00:00:00 | 1.1
2009-12-07 00:00:00 | 1.04
2009-11-30 00:00:00 | 0.92
2009-11-23 00:00:00 | 0.94
2009-11-16 00:00:00 | 1.02
2009-11-09 00:00:00 | 1
2009-11-02 00:00:00 | 1.04
2009-10-26 00:00:00 | 1.08
2009-10-19 00:00:00 | 1.18
2009-10-12 00:00:00 | 1.46
2009-10-05 00:00:00 | 1.43
2009-09-28 00:00:00 | 1.42
2009-09-21 00:00:00 | 1.57
2009-09-14 00:00:00 | 1.58
2009-09-08 00:00:00 | 1.65 | 1.65 |  | 2009-09-08 00:00:00
2009-08-31 00:00:00 | 1.77
2009-08-24 00:00:00 | 2.04
2009-08-17 00:00:00 | 1.2
2009-08-10 00:00:00 | 1.03
2009-08-03 00:00:00 | 0.66
2009-07-27 00:00:00 | 0.58
2009-07-20 00:00:00 | 0.57
2009-07-13 00:00:00 | 0.58
2009-07-06 00:00:00 | 0.51
2009-06-29 00:00:00 | 0.59 |  | 0.59 | 2009-06-29 00:00:00
2009-06-22 00:00:00 | 0.51
2009-06-15 00:00:00 | 0.67 |  | 0.67 | 2009-06-15 00:00:00
2009-06-08 00:00:00 | 0.66
2009-06-01 00:00:00 | 0.7
2009-05-26 00:00:00 | 0.73
2009-05-18 00:00:00 | 0.75
2009-05-11 00:00:00 | 0.78
2009-05-04 00:00:00 | 0.86
2009-04-27 00:00:00 | 0.75
2009-04-20 00:00:00 | 0.8
2009-04-13 00:00:00 | 0.85
2009-04-06 00:00:00 | 0.74
2009-03-30 00:00:00 | 0.7
2009-03-23 00:00:00 | 0.72
2009-03-16 00:00:00 | 0.7
2009-03-09 00:00:00 | 0.42
2009-03-02 00:00:00 | 0.36
2009-02-23 00:00:00 | 0.42
2009-02-17 00:00:00 | 0.54
2009-02-13 00:00:00 | 0.6 |  | 0.6 | 2009-02-13 00:00:00
Spreadsheet: michelle_lokay__26794__sharris0600wk3
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  | June, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
West Demand Revenues |  | 9.53 |  |  |  | Lower actual demand rates than in plan
West Commodity Revenues |  | 0.723 | 0.769
East Demand Revenues |  | 1.089 | 1.031 |  |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.166 | 0.163
[NAME] |  | 0.644 | 0.627
[NAME] Revenues |  | 0.0594 | 0.284 |  |  | 100/d IT Ignacio to Blanco vs. 0/day in plan
 |  | ------------- | ------------- | -------------
Revenue Variance
[NAME] due to Price |  |  |  | 0.667 |  | Index price $4.07!!!
[NAME] due to transport volumes |  |  |  | -0.10691
Hedging Adjustment |  |  |  | -0.0135
Unaccounted for Variance |  |  |  | 0.215
 |  |  |  | -------------
Fuel Variance
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE
 |  |  |  | ========
[NAME]:
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (throughJune)
Actuals through May, June est.
 |  | ------------- | ------------- | -------------
Variance from Plan
 |  | ------------- | ------------- | -------------
Spreadsheet: 690513d1597149657-using-if-formulas-in-conditional-formatting-example
Sheet: Sheet1

 | Company 1 | Company 2 | Company 3 | Question Priority
Question 1 | 3 | 2 | 1 | H
Question 2 | 3 | 2 | 1 | M
Question 3 | 3 | 2 | 1 | L
 | Scoring is done on the bases from 1 to 3
 | Each Priority has weight on the score
Spreadsheet: daren_farmer__6363__CES INFO
Sheet: GPPP

Purchase
 | From [NAME]
 | At the Gulf Plains Processing Plant (8348)
 | For IF-.09 (Base vols) and GD AD
Sale
 | Vols are transported into HPL
Term
 | Thru 6/2001
Other
 | Stella Morris confirms this point
 | All of the gas is given to us at the Gulf Plains Plant.
 | [NAME] are about 13,000
 | [NAME] determines base/swing breakout
Deal #'s | Jan | Feb
 | 139248 |  | P
 | 143533 |  | S
 | 144963 | 154553 | DD
Spreadsheet: 356390d1415097308-over-under-2-5-goals-book1
Sheet: Sheet2

COUNTRY | LEAGUE | TEAM | OVERALL FORM |  |  |  |  |  | OVERALL VALUE | COUNTRY | LEAGUE | TEAM | HOME FORM |  |  |  |  |  | HOME VALUE | COUNTRY | LEAGUE | TEAM | AWAY FORM
England | English League 1 | Preston
Spreadsheet: 119181d1314250893-conditional-formatting-jw01-2011-08-24
Sheet: Sheet1

aaa | bbb | [NAME] | ddd | eee | 1 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 10 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 2 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 9 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 3 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 8 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 4 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 7 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 5 | ggg | hhh
aaa | bbb | [NAME] | ddd | eee | 6 | ggg | hhh
Spreadsheet: 853311d1703180016-count-blank-cells-based-on-criteria-count-blank-cells-based-on-criteria
Sheet: Sheet1

[NAME]
[NAME]
 |  |  |  |  |  |  |  | Owner | Count Of Blank Cells
 |  | Plant | Owner
 |  | Pothos | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  | Pothos | [NAME]
 |  |  | [NAME]
 |  | Pothos | [NAME]
 |  | Pothos | [NAME]
 |  |  | [NAME]
 |  | Sun Flower | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  | Sun Flower | [NAME]
 |  |  | [NAME]
 |  | Pothos | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 718043d1612963738-index-match-function-gives-different-results-based-on-cell-location-indexproblem
Sheet: Blad1

 | School holidays |  |  |  | [NAME] step by step
 | Holiday | Begin | End
 | Christmas | 2021-01-01 00:00:00 | 2021-01-03 00:00:00
 | Early | 2021-02-13 00:00:00 | 2021-02-21 00:00:00 |  | True | False | 0 | 2 | 0
 | Spring | 2021-05-01 00:00:00 | 2021-05-09 00:00:00 |  | True | False | 0 | 3 | 0
 | Summer | 2021-07-24 00:00:00 | 2021-09-05 00:00:00 |  | False | True | 0 | 4 | 0
 | Fall | 2021-10-23 00:00:00 | 2021-10-31 00:00:00 |  | False | True | 0 | 5 | 0 |  |  | Output 2
 | Christmas | 2021-12-25 00:00:00 | 2021-12-31 00:00:00 |  | False | True | 0 | 6 | 0
 | Input date | 2021-07-23 00:00:00
 | Output 1
Spreadsheet: 75329d1275920137-expert-macro-excel-i-need-help-dhp-calendar-for-currentmo
Sheet: today

 | TODAY IS:
 |  | No. of Employees on Leave today
 | LEAVE TYPE | [NAME] | BI | CG | DHPOC | DS | MIS | Tech/SP | TOTAL
 | [NAME]
 | Emergency Leave
 | Vacation Leave
 | Total No. of Employees Absent
 | Reporting for Work
 |  | Accumulated Leaves for this month ( as of today)
 | LEAVE TYPE | [NAME] | BI | CG | DHPOC | DS | MIS | Tech/SP | TOTAL
 | [NAME]
 | Emergency Leave
 | Vacation Leave
 | Total
 | Employees Reporting for Work | [NAME] | BI | CG | DHPOC | DS | MIS | Tech/SP | TOTAL
 | 2PM
 | 3PM
 | 4PM
 | 5PM
 | 6PM
 | 7PM
 | 8PM
 | 9PM
 | 10PM
 | Other Schedule
 | Total
 | S U M M A R Y
Spreadsheet: 698456d1601989793-need-to-get-reports-from-badly-formatted-exported-data-leave-example
Sheet: Raw data

Between 01-Sep-2020 and 30-Sep-2020
Location
Location
Surname, Name A
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-14 00:00:00 | 2020-09-18 00:00:00 | 5 | 37.5
Total Holiday | 5 | 37.5
Employee Total: Surname, Name A | 5 | 37.5
Surname, Name B
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-28 00:00:00 | 2020-09-29 00:00:00 | 2 | 15
Total Holiday | 2 | 15
Employee Total: Surname, Name B | 2 | 15
Surname, Name C
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-25 00:00:00 | 2020-09-25 00:00:00 | 0.5 | 3.75
Total Holiday | 0.5 | 3.75
Employee Total: Surname, Name C | 0.5 | 3.75
Surname, Name D
Ordinary Maternity Leave | [NAME] | Absence End | Duration | Hours | Reason
2020-05-10 00:00:00 | 2020-11-07 00:00:00 | 130 | 975
Total Ordinary Maternity Leave | 22 | 165
Employee Total: Surname, Name D | 22 | 165
Surname, Name E
Holiday | [NAME] | Absence End | Duration | Hours | Reason
2020-09-01 00:00:00 | 2020-09-04 00:00:00 | 4 | 28.5
Total Holiday | 4 | 28.5
Employee Total: Surname, Name E | 4 | 28.5
Totals: Location | 33.5 | 249.75
Want a table on a separate tab that shows
Leave type
# Days (col c)
Who that employee is
Spreadsheet: 3eeef0ac-b5fd-4169-8177-9fd1c5e6066a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Please click on required table number:
Circulatory Disease Prevalence |  | Definition
9.1.1 | [NAME] (CHD) Prevalence Rate (Unadjusted): 2006/07 | Click here for data definition
9.1.2 | [NAME] (CHD) Prevalence Rate (Adjusted): 2006/07 | Click here for data definition
9.1.3 | Stroke / Transient Ischaemic Attack (TIA) Prevalence Rate (Unadjusted): 2006/07 | Click here for data definition
9.1.4 | Stroke / Transient Ischaemic Attack (TIA) Prevalence Rate (Adjusted): 2006/07 | Click here for data definition
Circulatory Disease Management |  | Definition
9.2.1 | CHD Management - % of Patients With a Blood Pressure Reading of 150/90 or Less: 2006/07 | Click here for data definition
9.2.2 | Stroke / TIA Management - % of Patients With a Blood Pressure Reading of 150/90 or Less: 2006/07 | Click here for data definition
9.2.3 | Prescribing of Lipid Regulating Drugs: 2006/07 | Click here for data definition
Spreadsheet: 136712d1326802036-index-match-formula-index-and-match-formula-1-
Sheet: UserSheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 1 | 1 | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 2 | 2 | May
 | Customer | Customer 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 3 | 3 | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 4 | 4 | July
 | Month | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 5 | 5 | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 6 | 6 | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 7 | 7 | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 8 | 8 | November
 | [NAME] | Name | Units | m2 | £000s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 9 | 9 | December
 | 3 | Customer 3 | 1140 | 577.9849919059498 | 17.72502131389372 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 10 | 10 | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 | Example Based on the cells [NAME] and C5
 | [NAME] | Customer Name | Units | m2 | £000s
 | 2 | Customer 2 | 3420 | 1891.101210727786 | 54.41281207933216
Spreadsheet: 877614d1724412693-formulas-for-a-maintenance-table-examplesheet
Sheet: LCRP 10year

 | Units | No of Units | 1 | How many units in calculation, do not mind this right now.
 |  |  |  |  |  |  |  |  |  | Total 10 Y LCR Price
 | Hours/ Day | Hours/Day | 10 | How many hours / day the unit runs.
 | Hours/Year | Hours/Year |  | How many hours / year the unit runs
 |  |  |  |  |  |  | M-F
 |  |  |  |  |  | Year |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  | Change when either of these are met |  |  | Accummulated hours after x year ->
 | Description | Pcs / Unit | Yearly intervalls | Hour intervalls | Guide Parts Price/Module | Cost of replacement | MHrs req. per change | Guide  Labour Price per change | Guide Parts & Labour Price * No. of Units | 10 Year LCR Price
 |  |  | Years | Hours
 | Article 1 | 1 | 4 | 9000 | 5000 |  | 40
 | Article 2 | 3 | 2 | 5000 | 3000 |  | inc
 | Article 3 | 1 | 8 | 20000 | 35000 |  | 36
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  | Sum
 |  |  |  | Article 1 should be replaced after 4 years or 9000 hours, depending on what comes first. In this example, it is in the third year (Cell N11). Currently the code calculates on the year, not the hours (Hence it presents the cost in O4 (4th year).
 |  |  |  | I've tried to show this with the fill color. My aim is to present the cost in N11 (Y3) as the accumulated hours have overstepped 9000hours (E11). After After N11, the formulas should once again calculate when the next replacement is depending on year or hours.
 |  |  |  | But this time take into consideration that the article was replaced in the third year. So that it doesn’t propose an replacement again in year 4. As it does now.
 |  |  |  | Article 2 works correct in this example as 5000 hours (E12) and 2 year (D12) is reached in the same year. But the coding is only working in these cases when year and hours align such as this.
 |  |  |  | Article 3 is affected in the same way as article 1. The change should be in Year 6 (Q13) as 20000 hour have been exeeded (shown in Q8). |  |  |  |  |  |  |  |  |  |  |  |  | Not in year 8 as the hourly limit is reached before.
Spreadsheet: 552482d1513607841-index-match-formula-not-returning-expected-result-example2
Sheet: Summary

Month | May 2017
Temperature | Integrated Mean |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean Speed |  | Wind
 | Simple Mean
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Mean Minimum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean |  | Barometric Pressure
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean |  | Relative Humidity
 | Frost Duration
Rainfall | Total
 | Rolling Rainfall
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean |  | Dew Point
 | Rain Days
 | Wet Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Air frost |  | Miscellaneous
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sleet/ snow falling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 50% snow at 0900 GMT
 | Rain Duration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thunder heard
Sunshine | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hail
 | Rolling Percentage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fog at 0900 GMT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean |  | 09-09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean Minimum
 | Sunless Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rainfall
 | Missing Hours |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wet Days
 | Absolute Maximum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Air frost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Temperature |  | vs Last Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rainfall
 | Summary |  |  |  |  |  |  |  |  |  |  |  |  | May 2016
Date | [NAME] | Min | Rainfall | Sunshine | Wind Spd | [NAME] | Barometer | Humidity | Events |  |  |  |  | Temperature |  |  |  | Sunshine
2017-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean |  | N/A |  | Total |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | N/A |  | Sunniest Day |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean Minimum |  | N/A |  | Sunless Days |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Minimum |  | N/A |  | Wind
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean Speed |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Rainfall |  |  |  | Maximum Gust |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | N/A |  | Windiest Day |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Rain Days |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wet Days |  | N/A |  | Barometric Pressure |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wettest Day |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Rain Rate |  | N/A |  | Relative Humidity |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dew Point |  | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes
Spreadsheet: hunter_shively__12754__EnovateDPR0204
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | 208.3089264000002 | 4178.602162709999 | -8.732504219997674 | -436.9593313999998
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: a78b1053-5bf1-4738-a92c-b1c2835a0e10
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2010-01-19 | 2010 | Canadian AHL All-Stars | 10 | PlanetUSA AHL All-Stars | 9 | Final SO * | Cumberland County Civic Center Portland, ME
Spreadsheet: 109747d1306511955-excel-2007-lock-unlock-cells-containing-drop-down-validation-based-results-of-another-drop-down-it-recovery-requirements
Sheet: IT Recovery requirements 1

IT Recovery requirements
Sustained Recovery Team
Name | Individuals able to perform role from home | Equipment currently available at home |  |  |  |  |  |  | Currently able to work from home | Further equipment required to work from home |  |  |  |  |  | Able to work from another office |  |  |  | Equipment required to work from alternative office
 |  | MPS  Laptop | Own PC / Laptop | Broadband / Router | Citrix access | Printer | [NAME] | Landline phone |  | PC / Laptop | Broadband / Router | Citrix access | Printer | [NAME] | Landline phone | Day 1 | > 3 days | > 1 Wk | 1 - 3 Wks | PC / Laptop | [NAME] | Printer | Landline phone
 |  |  |  |  |  |  |  |  | For IT use |  |  |  |  |  |  |  |  |  | For IT use
Remainder of staff
Name | Individuals able to perform role from home | Equipment currently available at home |  |  |  |  |  |  | Currently able to work from home | Further equipment required to work from home |  |  |  |  |  | Able to work from another office |  |  |  | Equipment required to work from alternative office
 |  | MPS  Laptop | Own PC / Laptop | Broadband / Router | Citrix access | Printer | [NAME] | Landline phone |  | PC / Laptop | Broadband / Router | Citrix access | Printer | [NAME] | Landline phone | Day 1 | > 3 days | > 1 Wk | 1 - 3 Wks | PC / Laptop | [NAME] | Printer | Landline phone
 |  |  |  |  |  |  |  |  | For IT use |  |  |  |  |  |  |  |  |  | For IT use
Spreadsheet: benjamin_rogers__1294__Caledonia
Sheet: Tax Calculations

State and Federal Tax Calculation
 |  |  | 1
STATE TAXES
State Franchise Taxes
Shareholders Equity & Long Term Debt
State Franchise Tax Rate
State Franchise Tax Liability (See Book Inc.)
State Gross Receipts Taxes
Gross Revenue
Gross Receipts Tax Rate
Gross Receipts Tax Liability |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
State Income Taxes
Pretax Book Income
Less: Gross Receipts Tax
Adjusted Pretax Book Income
Plus Book Depreciation & Amortization
Less State Tax Depreciation
State Taxable Income
Taxable Income
State Income Tax Rate
State Income Tax Expense (Benefit)
Beginning NOL's
New NOL's
NOL Expired  (5 Year) |  | 5 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
State Cash Taxes Payable/(Benefit)
Plus: Gross Receipts Tax Liability
Total State Taxes
FEDERAL TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less: Federal Tax Depreciation
Less: State Taxes
Taxable Income
Federal Tax Rate
Federal Tax Expense (Benefit)
NOL Carryforward
NOL Utilization
Total Federal Cash Taxes Payable/(Benefit)
Deferred Tax Liability
Total Cash Taxes
Total Book Taxes
Total Deferred Tax Liability
Cumulative DTL
Spreadsheet: 877107d1723788861-how-to-list-unpaid-payment-help4
Sheet: Sheet2

 |  |  |  |  | Data |  |  |  |  |  | Result I want using formula
 |  |  |  |  | Date | Name | Total | Paid |  |  | Unpaid
 |  |  |  |  | 2024-07-02 00:00:00 | A | 2000 | False |  |  | Date | Name | Total
 |  |  |  |  | 2024-07-04 00:00:00 | B | 1222 | True |  |  | 2024-07-02 00:00:00 | A | 2000
 |  |  |  |  | 2024-07-06 00:00:00 | C | 1347 | True |  |  | 2024-07-08 00:00:00 | D | 1592
 |  |  |  |  | 2024-07-08 00:00:00 | D | 1592 | False |  |  | 2024-07-14 00:00:00 | G | 2548
 |  |  |  |  | 2024-07-10 00:00:00 | E | 2100 | True |  |  | 2024-07-16 00:00:00 | H | 1269
 |  |  |  |  | 2024-07-12 00:00:00 | F | 3456 | True
 |  |  |  |  | 2024-07-14 00:00:00 | G | 2548 | False
 |  |  |  |  | 2024-07-16 00:00:00 | H | 1269 | False
 |  |  |  |  | 2024-07-18 00:00:00 | J | 1998 | True
 |  |  |  |  | 2024-07-20 00:00:00 | K | 1569 | True
Spreadsheet: d8dbc333-dc3a-4e56-8efa-1bbd9ec9c8f8
Sheet: Sheet1

ADVANCED MICRO DEVICES INC | Unnamed: 1 | Unnamed: 2
10-Q
05/06/2009
INCOME STATEMENT
 | Quarter Ended | Quarter Ended
 | March 28, 2009 | March 29, 2008
 | (In millions, except per share amounts) | (In millions, except per share amounts)
Net revenue | 1177 | 1487
Cost of sales | 666 | 866
Gross margin | 511 | 621
Research and development | 444 | 478
Marketing, general and administrative | 287 | 337
Amortization of acquired intangible assets | 18 | 40
Restructuring charges | 60
Operating income (loss) | -298 | -234
Interest income | 3 | 15
Interest expense | -97 | -101
Other income (expense), net | 94 | -1
Income (loss) before income taxes | -298 | -321
Provision (benefit) for income taxes | 116
Income (loss) from continuing operations | -414 | -321
Income (loss) from discontinued operations, net of tax |  | -30
Net income (loss) | -414 | -351
Net (income) loss attributable to noncontrolling interest | 6 | -13
Class B preferred share accretion | -8
Net income (loss) attributable to AMD common stockholders | -416 | -364
Net income (loss) attributable to AMD common stockholders per share
Basic and diluted
Continuing operations | -0.66 | -0.55
Discontinued operations |  | -0.05
Basic and diluted net income (loss) attributable to AMD common stockholders per share | -0.66 | -0.6
Shares used in per share calculation:
Basic and diluted | 626 | 606
Spreadsheet: 867127d1714018022-singale-line-data-sample
Sheet: Purchase Register

Purchase Register |  |  |  |  |  |  |  |  |  |  | required data
1-Apr-23 to 31-Mar-24
Date | Particulars |  |  |  |  | Vch Type | Vch No. | Debit | Credit
 |  |  |  |  |  |  |  | Amount | Amount
2023-04-01 00:00:00 | VENKATESH AGENCIES |  |  |  |  | Purchase | Apr-1 |  | 52437
 | New Ref | 3 |  | 52437 | Cr
 | WIP Electric Installation & Equipment |  |  |  |  |  |  | 44438
 | CGST Receivable 9% |  |  |  |  |  |  | 3999.42
 | SGST Receivable 9% |  |  |  |  |  |  | 3999.42
 | Round Off |  |  |  |  |  |  | 0.16
 | USED FOR ELECTRIC CONTROL PANEL FITTING
2023-04-01 00:00:00 | NEW CHAKRAPANI AUTOMOBILES(OLD) |  |  |  |  | Purchase | Apr-2 |  | 1402
 | New Ref | Credit-7 |  | 1402 | Cr
 | Repairs and Maintenance - Machinery |  |  |  |  |  |  | 1188.13
 | CGST Receivable 9% |  |  |  |  |  |  | 106.93
 | SGST Receivable 9% |  |  |  |  |  |  | 106.93
 | Round Off |  |  |  |  |  |  | 0.01
 | [NAME] 728.81, 90 NO OIL  - 2 LTR @402.54, 8X9 PATTI PANA - 01 NOS @56.78 UESD FOR MACHINE REPAIR AND MAINTENANCE
Spreadsheet: 836616d1689530608-create-formula-in-pivot-score-kimudao-
Sheet: Sheet1

 | Name | Score | Score2 |  | Row Labels | Average of Score2
 | AAA | 79/100 |  |  | AAA | 76
 | BBB | 77/100 |  |  | BBB | 77
 | AAA | 73/100 |  |  | DDD | 79
 | DDD | 79/100