tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f3a5ee4d-c958-4468-a2ae-4f79f0fdd1d9
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 7/31/2014 6:26:25 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 04 | 456 | 456
District 31 | 702 | 702
District 36 | 4705 | 4705
District 37 | 6028 | 6028
District 39 | 3922 | 3922
TOTAL | 15813 | 15813
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: expenses

 |  |  |  | Expenses |  |  |  |  |  |  |  |  |  |  |  | Prog.Vers.: | V5.0
 |  | 1000 |  | Project1 |  |  |  |  |  |  |  |  |  |  |  | Print Date: | 2011-06-28 00:00:00
 |  |  |  | 321 |  |  |  |  |  |  |  |  |  |  |  | Respons.: | [NAME]
 | [NAME] (1.000) EUR
 | ONE-OFF CASH EXPENSES
 | a-1) 05 - One-off Cash Expenses | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
 | Severance Payments | 1111.179745006839
 | Recruiting Costs | 409.4430889000678
 | Consulting Expenses | 1000
 | Relocation Costs | 22.275 | 22.275 | 22.275 | 22.275
 | Total | 2542.897833906907 | 22.275 | 22.275 | 22.275 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | a-2) 01 - IT Opex (One-off-cash expenses) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 | Subtotal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OPERATING CASH EXPENSES
 | b-1) 06 - Operating Cash Expenses - BUSINESS | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
 | SSC | 800 | 800 | 800 | 800
 | Subtotal | 800 | 800 | 800 | 800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | b-2) 02 - IT
 | ACD | 80 | 80 | 80 | 80
 | Subtotal | 80 | 80 | 80 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL
 | Cash Expenses (One-off + Operating) | 3422.897833906907 | 902.275 | 902.275 | 902.275 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BUDGETED NON CASH INTERNAL EXPENSES (1.000) EUR
 | 07 - Non-Cash Internal Expenses (mandays of staff) | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
Internal
 | Total Internal expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rates for internal manpower in EUR*
 | per employee, per year AT | 83000
 | per employee, per month AT | 6916.666666666667
 | per employee, per day AT | 395.2380952380952
 | * for international projects you will find the internal manpower rates of each country in the sheet "Planning frame"
Spreadsheet: 035a3782-bc18-49d8-ad7a-38500da29657
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/21/2013 10:32:58 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 04 | 456 | 456
District 31 | 702 | 702
District 36 | 4705 | 4705
Results provided by the Office of North Dakota Secretary of State | 6028 | 6028
District 39 | 3922 | 3922
TOTAL | 15813 | 15813
Spreadsheet: 867985d1714716352-calculate-average-depending-on-criteria-sample-data-37-aligw
Sheet: Average

 | Start Week | End Week
Weeks | 1 | 7
 | Rolling 4 Month Average
 | Volume Type 1 | Volume Type 2 | Volume Type 3 | Total Volume
ABC123
ZYX123
Spreadsheet: 695146d1600075060-vlookup-based-on-the-results-exam-vlookup-formula
Sheet: Sheet1

 | STUDENT RESULT
 | SUBJECT | MATH |  | SCIENCE |  | ART |  | ECONOMIC |  | COMPUTER |  | BIOLOGY |  | PHYSIC |  | CHEMISTRY
 | SCORE / GRED | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G
 |  | 100 | A | 80 | A | 70 | B | 40 | D | 65 | C | 95 | A | 83 | A | 67 | C
 | CRITERIA CLASS |  |  |  |  |  |  |  | YOUR CLASS 2021
 | CLASS |  | SUBJECT |  | MINIMUM GRED |  |  |  | T4
 | SCIENCE STREAM |  | MATH |  | B
 |  |  | BIOLOGY |  | A
 |  |  | PHYSIC |  | A
 |  |  | CHEMISTRY |  | A
 | ECONOMY |  | MATH |  | B
 |  |  | SCIENCE |  | C
 |  |  | ART |  | C
 |  |  | ECONOMIC |  | A
 |  |  | COMPUTER |  | B
 |  |  | BIOLOGY
 |  |  | PHYSIC
 |  |  | CHEMISTRY
 | LITERATURE |  | MATH |  | B
 |  |  | SCIENCE |  | D
 |  |  | ART |  | A
 |  |  | ECONOMIC
 |  |  | COMPUTER |  | C
 |  |  | BIOLOGY
 |  |  | PHYSIC |  | C
 |  |  | CHEMISTRY
Spreadsheet: 141162d1329135687-excel-2007-help-merging-rows-test1
Sheet: men_zgsl_l340

12345679 | 1165874 | Miss | SARAH | JONES | 1994-05-11 00:00:00 | B521 | Nutrition and Dietetics BSc |  |  | UK Submission | im studying year 0
12365897 | 1201235 | Miss | GRACE | SMITH | 1995-04-21 00:00:00 | A152 | Medicine Programme MBBS | R |  | Beechwood College | none | ILC:Biology = A2
ILC:Chemistry = A2 ILC:English = B1 ILC:French = B1 ILC:Irish = A1 ILC:Mathematics = C2 ILC:Accounting = A2
12445101 | 1227842 | Mr | [NAME] | BEACH | 1983-05-25 00:00:00 | C698 | Biochemistry BSc |  | 56420 | [NAME] | [NAME]
12357654 | 1298563 | Miss | MASARET | ISLAM | 1990-01-17 00:00:00 | B124 | Post Graduate Diploma in Nursing
R | 10956 | Lambeth College, [NAME] | PASELLLN | QCFBED:Business = MMM
13245872 | 1212045 | Mr | FAISAL | BEGUM | 1996-06-16 00:00:00 | N245 | Bachelor of Science in Business Management |  | 10956 | Aquinas College
Spreadsheet: 41027d1239452568-datedif-question-daily-report2
Sheet: Sheet1

Daily Report
2009-04-10 00:00:00
 | Today | MTD | YTD
Rooms Available | 132 | 1320 | 13200
Rooms Sold
Room Rev
Occupancy % | 0 | 0 | 0
ADR
REVPar | 0 | 0 | 0
Comments:
Spreadsheet: 101458d1299589743-sumproduct-match-example
Sheet: Sheet1

2010 Feb |  |  |  | 2011 Feb
REGION_DESC_L | REGION_DESC_D | Total |  | REGION_DESC_L | REGION_DESC_D | Total | 2010-02-01 00:00:00
SOUTH EAST ASIA | EC | 2181 |  | SOUTH EAST ASIA | WEST ASIA | 2007 | 1717
 | WEST ASIA | 1717 |  |  | EC | 1942 | 2181
 | SOUTH EAST ASIA | 1494 |  |  | SOUTH EAST ASIA | 1834
 | NORTH EAST ASIA | 1198 |  |  | NORTH EAST ASIA | 1269
 | NORTH AMERICA | 848 |  |  | NORTH AMERICA | 771
 | OCEANIA | 484 |  |  | OCEANIA | 492
 | SOUTH ASIA | 220 |  |  | SOUTH ASIA | 115
 | AFRICA | 113 |  |  | AFRICA | 106
 | OTHER EUROPE | 65 |  |  | C & S AMERICA | 82
 | C & S AMERICA | 17 |  |  | OTHER EUROPE | 17
NORTH EAST ASIA | SOUTH EAST ASIA | 2806 |  | NORTH EAST ASIA | SOUTH EAST ASIA | 2416
 | EC | 506 |  |  | SOUTH ASIA | 695
 | SOUTH ASIA | 469 |  |  | EC | 304
 | WEST ASIA | 195 |  |  | WEST ASIA | 182
 | AFRICA | 177 |  |  | OCEANIA | 141
 | OCEANIA | 142 |  |  | AFRICA | 97
 | NORTH AMERICA | 93 |  |  | C & S AMERICA | 81 | 86
 | C & S AMERICA | 86 |  |  | NORTH AMERICA | 31
 | OTHER EUROPE | 8 |  |  | OTHER EUROPE | 24
 | NORTH EAST ASIA | 2 |  |  | NORTH EAST ASIA | 11
Spreadsheet: 763111d1641996930-count-based-on-entry-uk-prod-lt-holiday-calendar-2022-copy-v-2
Sheet: Sept 22

 | Absence Type Key | V | Vacation |  |  | H | Public Holiday |  |  | S | Sick |  | ML/PL | Maternity/ Paternity leave |  |  | BD | Birthday |  |  | T | Training
 | 2022-09-01 00:00:00 | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 |  | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | Total Days
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T
 | Fran
 | Oakthorpe
 | [NAME]
 | Jo
 | Maria
 | Mark
 | Michelle | V | V
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Zak |  | BD
Spreadsheet: 328983d1404152066-dynamic-top-5-customer-per-month-dynamic-top-5-customer-ans
Sheet: Desired Result (old data)

Helper Columns |  |  |  |  | [NAME] TOP 5
 |  |  |  |  | Customer Month | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | Total
Spreadsheet: 844334d1696058387-please-help-error-formula-fill-in-map-error
Sheet: Sheet1

 |  |  |  |  | target no need help column (only one column)
 |  |  |  | Data | need help to fix |  | help column | Target Result
 |  |  |  | Text 1
 |  |  |  |  | #[NAME]! |  | 0 | Text 1 | Text 1
 |  |  |  |  | #[NAME]! |  | 0 | Text 1 | Text 1
 |  |  |  | Text 2 | #[NAME]! |  | Text 2 | Text 2 | Text 2
 |  |  |  |  | #[NAME]! |  | 0 | Text 2 | Text 2
 |  |  |  |  | #[NAME]! |  | 0 | Text 2 | Text 2
 |  |  |  | Text 3 | #[NAME]! |  | Text 3 | Text 3 | Text 3
 |  |  |  |  | #[NAME]! |  | 0 | Text 3 | Text 3
 |  |  |  | subt | #[NAME]! |  | 0 | Text 3 | Text 3
 |  |  |  |  | #[NAME]! |  | 0 | Text 3 | Text 3
 |  |  |  | Text 4 | #[NAME]! |  | Text 4 | Text 4 | Text 4
 |  |  |  |  | #[NAME]! |  | 0 | Text 4 | Text 4
 |  |  |  | subt | #[NAME]! |  | 0 | Text 4 | Text 4
 |  |  |  |  | #[NAME]! |  | 0 | Text 4 | Text 4
 |  |  |  |  | #[NAME]! |  | 0 | Text 4 | Text 4
 |  |  |  | Text 5 | #[NAME]! |  | Text 5 | Text 5 | Text 5
 |  |  |  |  | #[NAME]! |  | 0 | Text 5 | Text 5
 |  |  |  |  | #[NAME]! |  | 0 | Text 5 | Text 5
 |  |  |  |  | #[NAME]! |  | 0 | Text 5 | Text 5
 |  |  |  |  | #[NAME]! |  | 0 | Text 5 | Text 5
 |  |  |  |  | #[NAME]! |  | 0 | Text 5 | Text 5
Spreadsheet: 105002d1302501336-excel-2007-sum-if-macro-excel-2007-test
Sheet: Sheet2

Article | Article Description | Site | MvT | Art.Doc. | User name | Postg Date | Period | EA's | [NAME] | Pack Size | Pac's | [NAME] | Amt | Comment
1066804 | [NAME] CHERRY 60ML ARX | DC01 | 712 | 4919014592 |  | 2011-04-04 00:00:00 | 4 | 360 | 0 | 24 | 15 | 0 | 140.12
1066804 | [NAME] CHERRY 60ML ARX | DC01 | 711 | 4918985178 |  | 2011-04-01 00:00:00 | 4 | -360 | 0 | 24 | -15 | 0 | -140.11
1015181 | BODY BUTTER COCOA BUTTER 50ML A0 | DC01 | 712 | 4919052668 |  | 2011-04-07 00:00:00 | 4 | 192 | 0 | 48 | 4 | 0 | 99.78
1015181 | BODY BUTTER COCOA BUTTER 50ML A0 | DC01 | 711 | 4918580206 |  | 2011-02-28 00:00:00 | 2 | -192 | 0 | 48 | -4 | 0 | -99.79
Spreadsheet: benjamin_rogers__1036__Consolidated 6 Peaker- 051100-NewPrices
Sheet: Tax

GENCO FEDERAL TAXES
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
STATE TAXES
Total State Taxes Utilizing NOLs
FEDERAL TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less: Tax Depreciation
Less: State Taxes
Federal Taxable Income
Federal Tax Rate
Federal Tax Expense/ (Benefit)
NOL Carryforward | 0
NOL Utilization
Total Federal Cash Taxes Payable/(Benefit)
Spreadsheet: 215065d1361248945-got-cache-making-timetable-on-spreadsheet-book1
Sheet: Sheet1

 |  | Monday | Tuesday | Wenesday | Thursday | Friday
 | 08:30:00
 | 09:30:00
 | 10:30:00 | [NAME] | HET105 Lecture
 | 11:30:00
 | 12:30:00 |  | HET182 Lecture 1
 | 13:30:00
 | 14:30:00 |  |  | HET182 Lecture 2
 | 15:30:00
 | 16:30:00 |  |  |  | HET182 Lecture 3
 | 17:30:00
 | 18:30:00
 | 19:30:00
 | 20:30:00
Spreadsheet: 0bae6706-f527-4f77-a0b6-3b761d77f0da
Sheet: School Summary

 | NWF Eco-Schools USA
 | Audit summary
 | Add it all up!
 | Below is a summary of your school's total carbon impact, both before and after implementing your action plan.
 |  | SCHOOL AUDIT SUMMARY
 |  | Audit category |  | Estimated CO2 emissions per year |  |  |  | Potential savings per year
 |  |  |  | Before Taking Action (lbs) |  | After Taking Action  (lbs) |  | CO2 Emissions Savings (lbs) |  | Electricity Savings (kWh) |  | Cost Savings ($)
 |  | Classroom lighting
 |  | Energy "vampires"
 |  | Other appliances
 |  | Transportation |  |  |  |  |  |  |  | n/a
 |  | Heating |  | n/a |  | n/a |  |  |  | n/a
 |  | Classroom trash |  |  |  |  |  |  |  | n/a
 |  | Classroom paper |  |  |  |  |  |  |  | n/a
 |  | Plastic water bottles |  |  |  |  |  |  |  | n/a
 |  | Beverage cups |  |  |  |  |  |  |  | n/a
 |  | TOTAL
 |  | This is equal to |  |  |  |  |  |  | lbs of CO2 per student |  |  |  |  |  |  |  | Number of students
 | Check it out!
 |  | CO2 Emissions: Before and after taking action
 | This bar graph shows the difference between this classroom's emissions before and after taking action to reduce its carbon footprint.  The orange bars represent the classroom's emissions before implementing changes; the blue bars represent the classroom's emissions after making changes.
 | What does it mean?
 |  | Through your actions to reduce your carbon footprint, your school could save
 |  |  | pounds of CO2 emissions per year.  This is the same as:
 |  | The CO2 emitted by driving a car |  |  |  |  | miles.
 |  | The CO2 emitted running a lightbulb for |  |  |  |  | hours (using standard U.S. electricity mix).
 |  | The CO2 sequestered by |  |  |  |  | tree seedlings grown for 10 years.
 | 2008 © Puget Sound Clean Air Agency. All Rights Reserved.
Spreadsheet: 867372d1714200380-copying-data-to-another-sheet-consolidation-aligw
Sheet: Sheet1

Title | Count
TTT333391100020 | 0 |  | TTT333391100020 | 0 |  |  | 0
TTT333391100020 | 0 |  | TTT333305201161 | 1 |  | TTT333305201161 | 1
TTT333391100020 | 0 |  | TTT333356301413 | 5 |  | TTT333356201678 | 3
TTT333305201161 | 0 |  | TTT333356401666 | 0 |  | TTT333356301413 | 5
TTT333305201161 | 0 |  | TTT320509101666 | 0 |  | TTT333356401666 | 0
TTT333305201161 | 1 |  | TTT333356201678 | 3 |  | TTT333391100020 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333356301413 | 0
0 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
Spreadsheet: andy_zipper__154__ICE - Mar28 Power & Gas VOL
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  |  | EOL PERCENTAGE: |  |  | ICE POWER VOLUME: |  |  | EOL PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Count of Deal ID | Sum of Total Quantity |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 465000 |  | Carson , M | Firm-LD Peak | MWhs | 1 | 16800
Grand Total |  |  | 1 | 465000 |  | Dorland , C | Firm-LD Peak | MWhs | 9 | 59200
 |  |  |  |  |  | Motley, M | Firm-LD Peak | MWhs | 4 | 81600
 |  |  |  |  |  | Grand Total |  |  | 14 | 157600
Spreadsheet: 751616d1634209299-use-sumifs-to-look-up-specific-date-dd-mm-yyyy-based-on-just-month-as-criteria-excel-forum
Sheet: sheet 1 

MARKETPLACE | PROGRAM_TYPE | TRANSACTION_TYPE | TAX_CALCULATION_DATE | PRICE_OF_ITEMS_AMT_VAT_EXCL
amazon.co.uk | REGULAR | SALE | 2021-09-29 00:00:00 | 74.94
amazon.co.uk | REGULAR | SALE | 2021-09-29 00:00:00 | 12.49
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 24.99
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 3.32
amazon.co.uk | REGULAR | SALE | 2021-09-29 00:00:00 | 3.41
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 14.98
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 6.66
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 4.57
amazon.co.uk | REGULAR | REFUND | 2021-08-01 00:00:00 | 6.66
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 0.82
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 5.82
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 23.32
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 37.49
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 5.82
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 6.24
Spreadsheet: 745058d1629721406-count-function-based-upon-another-cell-golf-average
Sheet: Sheet1

 | 18 hole Ave | # Matches | 2021-08-05 00:00:00 | 2002-08-09 00:00:00 | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | 2021-08-14 00:00:00 | 2021-08-16 00:00:00 | 2021-08-21 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00
 |  |  | 18 | 18 | 9 | 18 | 18 | 18 | 18 | 9 | 9
Player A |  |  |  |  |  |  | 79 | 76 | 86 | 41
Player B |  |  |  | 80 | 41 | 84 | 78 | 87 | 86 | 43 | 48
Player C |  |  | 77 | 81 | 38 | 87 | 82 | 81 | 78 |  | 47
Player D |  |  | 75 | 76 | 42 | 72 |  |  |  | 39 | 41
Player E |  |  | 76 | 87 | 45 | 82 | 78 | 84 | 85 | 39 | 40
Player F |  |  | 75 | 82 | 41 | 77 | 77 |  |  | 41
Spreadsheet: 843219d1695134946-error-in-the-formula-order-file
Sheet: Output

Acct No | Qty | Price
M1 | 2 | 2 |  |  | 2 | 2
M4 | 3 | 1 |  | M4 | 3 | 1
M5 | 2 | 3 |  | M5 | 2 | 3
M2 | 5 | 1 |  | M1 | 2 | 2
M3 | 2 | 6 |  | M1 | 2 | 2
M1 | 3 | 3 |  | M4 | 3 | 1
M2 | 2 | 1 |  | M5 | 2 | 3
M3 | 3 | 1 |  | M1 | 2 | 2
M4 | 1 | 1 |  | M1 | 2 | 2
 |  |  |  | M4 | 3 | 1
 |  |  |  | M5 | 2 | 3
 |  |  |  | M1 | 2 | 2
 |  |  |  | M1 | 2 | 2
 |  |  |  | M4 | 3 | 1
 |  |  |  | M5 | 2 | 3
 |  |  |  | M1 | 2 | 2
 |  |  |  | M1 | 2 | 2
 |  |  |  | M4 | 3 | 1
 |  |  |  | M5 | 2 | 3
 |  |  |  | M1 | 2 | 2
 |  |  |  | M1 | 2 | 2
 |  |  |  | M4 | 3 | 1
 |  |  |  | M5 | 2 | 3
 |  |  |  | M1 | 2 | 2
Spreadsheet: 1d055522-a61a-4914-9308-b69a9b483a2e
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (4 Entries):
 | 1 Semiconductors 1.4 Opto semiconductor components 1.4.11 Photoresistors
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME]Vertriebs GmbH | Germany | Nagold | 72202 | A5.138
2 | Everlight Electronics Europe GmbH | Germany | Karlsruhe | 76135 | A3.307
3 | Hamamatsu Photonics Deutschland GmbH | Germany | Herrsching | 82211 | A2.315
4 | PerkinElmer, Inc. | Germany | Wiesbaden | 65199 | A2.107
Spreadsheet: 840183d1692539809-transforming-database-with-formulas-transforming-database-with-formula_2
Sheet: Starting Base

 | This is the original database, I need to transform this with formula or power query or somethong to result like: [NAME]
 | in [NAME] | some information is simplified..
 | Date | Account | General ledger account | Mapped | Our ref. | Your reference | Entry number | Debit | Credit
 | 2022-01-01 00:00:00 | AeroConnections | 148000 | Trade and other receivables | 20003686 | AC121020M | 24320016 | 0 | 26121.69
 | 2022-01-01 00:00:00 | AeroConnections | 311000 | Trade and other payables | 20003686 | AC121020M | 24320016 | 26121.69 | 0
Spreadsheet: 844787d1696465258-using-if-function-in-excel-with-multiple-conditions-density-to-gravty-5
Sheet: Sheet1

 |  | Density | gravity
 |  | 0.785 | 7851
 |  | 0.7809
 |  | 0.8
 |  | 0.85
 |  | 0.86
 |  | 0.9533
 |  | 0.9617
Spreadsheet: a70d44c9-1f22-4c57-b0fd-2151e26304d3
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
PTENK | Test | PTENK | PTEN Gene, Known Mutation | PTEN Gene, Known Mutation | Polymerase Chain Reaction (PCR) Amplification/DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.  [NAME] must arrive within 96 hours of draw.  Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL	 Collection Instructions:	 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Colon Cancer Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Note: No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Wednesday; 10 a.m. | 10 days | 16 days | 1 | 81322 |  |  |  |  | Rochester
PTENK | [NAME] | VARIES | Varies |  |  |  | Ambient
PTENK | Result | 34241 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
PTENK | Result | 34242 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PTENK | Result | 34243 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PTENK | Result | 34244 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
PTENK | Result | 34245 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PTENK | Result | 34246 | [NAME] | [NAME] | Alphanumeric
PTENK | Result | 34247 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
PTENK | Result | 34248 | Reviewed By | Reviewed By | Alphanumeric
PTENK | Result | 34249 | Release Date | Release Date | Alphanumeric
Spreadsheet: 08172964-84f9-4cec-8ed6-dd8dc6c970ca
Sheet: 2ED

2ED RANKING OUT OF 76
ANON# | RANK
3758 | 14
6241 | 15
6544 | 5
6737 | 18
17032 | 3
23370 | 4
23606 | 2
52725 | 7
53337 | 9
69465 | 19
70029 | 1
75976 | 10
76152 | 16
76275 | 8
76391 | 6
98833 | 13
99163 | 12
99616 | 17
99760 | 11