tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 82397d1282437208-data-concatenate-if-vlookup-data-concatenate-if-vlookup
Sheet: AIM (Object)

LN No. | MR No. | KP No.
51 | 12344321 | 12321
56 | 65432109 | 12021
52 | 23456780 | 54321
50 | 1234567 | 4321
50 | 123456 | 321
50 | 12345 | 21
50 | 1234 | 1
 | 123 | 50
 | 12 | 465
 | 1 | 487
 |  | 24
50 | 4321 | 847
50 | 54321 | 5623
50 | 654321 | 2410
50 | 7654321 | 665544
 | 201000ACM002011
 | 201005ACM122011
 | 201003ACM452011 | 78
 | 201005ACM802011 | 123456
 | 201046ACM1232011
 | 2010123ACM3212011
 | 2010876ACM042011 | 225
50 | 551364 | 1
50 | 24153 | 12
51 | 12345678 | 123
52 | 23456789 | 123
53 | 34567890 | 1234
54 | 45678901 | 12345
55 | 56789012 | 123456
56 | 67890123 | 18
50 | 3214123 | 121
Spreadsheet: d4255746-839b-4f62-8e56-1cc78f7caf9f
Sheet: Sheet1

COMMUNITY PROJECT/ZONING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Case No. 361-S-2 |  |  |  | Companion Case No. 385-S-14
Brief Title |  |  | Approval Deadline |  | Reason
 | Approving the 2nd Modification to the 33rd and Montgall Urban Renewal Plan
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor | [NAME], AICP, Director
 |  |  |  |  |  | Department of City Planning and Development
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  | 3rd District
 |  |  |  |  | or Groups |  | (McFadden-Weaver, Nash)
 | Reason for Legislation |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | City Development
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | none known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For |  | with conditions
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or |  | City Plan Commission |  |  |  |  |  |  |  | (4-0)    6-20-06
 |  |  |  |  | Commission |  | By |  |  | (Holwick
 |  |  |  |  | Recommendation |  | Jenks, Martin, Myers)
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  | X |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Fact Sheet Prepared By: |  |  | Date:   7-21-06
 | [NAME] |  |  |  | Initial application filed 3-15-2006
 | Planner |  |  |  | Revised plans per CPC received 7-21-2006
Reviewed by: |  |  | Date:   7-21-06
 | [NAME], Manager
 | Development Management
Reference Numbers
 | Case No. 361-S-2 |  |  |  | Companion Case No. 385-S-14
 | [NAME] (continued)
Spreadsheet: 112652d1308702105-supply-demand-formula-help-stockmaster
Sheet: Overview

Company | Shares | Value |  | Starting Cash
[NAME] | 5000 | 10 |  | 100000
Excel Inc. | 5000 | 10
Cool LLC | 5000 | 10
Surfers Paradise Co. | 5000 | 10
[NAME] | 5000 | 10
Player | Current Money
[NAME]
Excel
Cool
Surfer
[NAME]
Spreadsheet: 124822d1318623264-a-vlookup-function-within-another-vlookup-funtion-hills
Sheet: Item List

Items
Item # | Item | Vendor ID | Minimum Inventory Level | Cost | Weight
1001 | Takeout Containers | 1 | 4 | 5.5 | 2
1002 | Chafers | 2 | 3 | 4.25 | 4
1003 | Ramekins | 2 | 12 | 3.8 | 1
1004 | Half Pan | 3 | 9 | 9.34 | 2.2
1005 | Full Pan | 3 | 5 | 12.98 | 3.8
1006 | [NAME] | 4 | 10 | 1.76 | 0.8
1007 | Spatula | 4 | 15 | 2.05 | 0.8
1008 | [NAME] | 3 | 6 | 9.9 | 2.4
1009 | [NAME] | 1 | 4 | 6.88 | 2.5
1010 | Plates | 5 | 75 | 2.24 | 0.9
1011 | Glasses | 5 | 125 | 0.75 | 0.82
1012 | Soup Bowl | 2 | 75 | 0.8 | 0.75
1013 | Soup Cup | 2 | 50 | 0.65 | 0.5
1014 | Salad Bowl | 2 | 75 | 1 | 0.75
1015 | [NAME] | 1 | 100 | 0.5 | 0.88
Spreadsheet: 869173d1715812655-countifs-test1
Sheet: On hands

Report Type | Cost Centre Most Used Codes
Cost Centre | 21602 | Operaton of street cleaning services
Organization Name | Inventory Item | Description | Sub Inventory Name | On Hand |  |  | 216105
NCOD | 5601741 | BAG, PLASTIC, FOR COMPACTOR BINS (P06219) | STORE |  |  |  | 216102
NCOD | 7008225 | GLOVES ALL GRIP GREEN SIZE XL | STORE
NCOD | 5601205 | BAG, PLASTIC D.C.C. ROLL 26x56  (P06837) | STORE
NCOD | 5606300 | CLOTH, WHITE WASTE, 8KG BAG | STORE
NCOD | 7014050 | RUNNERS, INDUSTRIAL  SIZE 9 | STORE
NCOD | 5614100 | TOILET ROLL, STANDARD SIZE | STORE
NCOD | 5608300 | DISINFECTANT, PINE | STORE
NCOD | 7008220 | GLOVES ALL GRIP GREEN SIZE L | STORE
NCOD | 7014060 | RUNNERS, INDUSTRIAL  SIZE 10 | STORE
NCOD | 7014040 | RUNNERS, INDUSTRIAL  SIZE 8 | STORE
NCOD | 5614800 | TOWEL, PAPER ROLL SMALL 2 PLY CENTER FEED | STORE
NCOD | 5615900 | WIPES, HAND INDUSTRIAL | STORE
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: Credit Card

Credit Card
MONTH | YEAR | APR | PAYMENT | BALANCE
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009
April | 2009
May | 2009
June | 2009
July | 2009
August | 2009
September | 2009
October | 2009 |  | 200
November | 2009 |  | 300
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 705043d1605866150-sumproduct-and-sumifs-not-working-sumproduct_sumifs_not_working
Sheet: Sheet1

 | COUNTRY | NEPAL |  | MYANMAR |  | VIETNAM |  | PHILIPPINES |  | INDONESIA |  | PAKISTAN |  | SRI LANKA
 |  | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved
 | 2020-01-01 00:00:00 | 0 | 5 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0
 | 2020-02-01 00:00:00 | 0 | 3 | 0 | 2 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | 2020-03-01 00:00:00 | 0 | 4 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL | 0 | 12 | 0 | 6 | 0 | 2 | 0 | 2 | 3 | 0 | 0 | 0 | 0 | 0
 |  |  | SUMPRODUCT
 |  |  | Achieved | Unachieved
 |  | MYANMAR
 |  | VIETNAM
 |  | PHILIPPINES
 |  | INDONESIA
 |  | PAKISTAN
 |  | SRI LANKA
 |  |  | SUMIFS
 |  |  | Achieved | Unachieved
 |  | MYANMAR
 |  | VIETNAM
 |  | PHILIPPINES
 |  | INDONESIA
 |  | PAKISTAN
 |  | SRI LANKA
 | COUNTRY | NEPAL |  | MYANMAR |  | VIETNAM |  | PHILIPPINES |  | INDONESIA |  | PAKISTAN |  | SRI LANKA
 |  | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved | Achieved | Unachieved
 |  | Enterprise 1:2 | Enterprise 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2 | Factory 1:2
 | 2020-01-01 00:00:00
 | 2020-02-01 00:00:00
 | 2020-03-01 00:00:00
 | TOTAL
Spreadsheet: 778580d1651160261-index-match-on-multiply-columns-test_f
Sheet: Sheet2

Posting Date | [NAME] | Product | Difference Quantity
2022-03-24 00:00:00 | A-LBL-003 | 10104.A | 1
2022-03-24 00:00:00 | A-LBL-010 | 131031.A | 1
2022-03-09 00:00:00 | A-LBL-001 | 132690.A | 1
2022-03-07 00:00:00 | A-LBL-007 | 132693.A | 1
2022-03-07 00:00:00 | A-LBL-001 | 132693.A | 1
2022-03-16 00:00:00 | A-LBL-007 | 132696.A | 1
2022-03-17 00:00:00 | A-LBL-001 | 132696.A | 1
2022-03-22 00:00:00 | A-LBL-002 | 132696.A | 1
2022-03-15 00:00:00 | A-LBL-005 | 132698.A | 1
2022-03-17 00:00:00 | A-LBL-002 | 132698.A | 1
2022-03-16 00:00:00 | A-LBL-005 | 132699.A | 1
2022-03-03 00:00:00 | A-LBL-010 | 134561.A | 1
Spreadsheet: 161421d1339515741-excel-2007-macro-needed-to-transfer-data-between-tabs-example-doc
Sheet: Capital List

GROUNDS CAPITAL |  |  | Today' Date | 2012-06-12 00:00:00
AREA OF OPERATION | Pur.Date | Age | SRD | Need Level | Cost | Notes
IRRIGATION
Pumphouse | 2001-01-01 00:00:00 | 11 |  | 1
[NAME] | 2001-01-01 00:00:00 | 11 |  | 1
3- 75 HP PUMPS | 2001-01-01 00:00:00 | 11 |  | 1
Pm Pump | 2010-01-01 00:00:00 | 2 |  | 3
[NAME] | 2001-01-01 00:00:00 | 11 |  | 3
Acid Injection System | 2001-01-01 00:00:00 | 11 |  | 2
Fertigation | 2001-01-01 00:00:00 | 11 |  | 2
Intake | 2001-01-01 00:00:00 | 11 |  | 1 |  | Need Serviced
[NAME] |  | future
Spreadsheet: 22a32d41-e2ce-4319-86d5-4d6432317ad5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  | Cause of Death
ID | Sex |  | Age
A1 | male | MVA* | 29
A2 | male | MVA | 29
A3 | male | MVA | 54
A4 | male | MVA | 25
A5 | male | MVA | 24
A6 | male | MVA | 18
A7 | male | MVA | 40
A8 | male | MVA | 23
*MVA: motor vehicle accident
Spreadsheet: 108485d1305554951-how-to-change-a-list-of-addresses-from-one-column-into-rows-address-example-mg
Sheet: Sheet1

Contacts
Smith and Sons
1 Casey Street
Torquay
01803 202020
Jones The Steam
1 Livermead Road
Torquay
01803 287622
[NAME]
Snooker Tables
147 Green Bay Road
[PHONE]
 | Would like to go from this format to below:- |  |  |  |  | (not too worried about the column titles so doesn’t matter if a phone number comes under wrong heading)
 | Name | Address | Address | Contact
 | Smith and Sons | 1 Casey Street | Torquay | 01803 202020
 | Jones The Steam | 1 Livermead Road | Torquay | 01803 287622
 | etc
Spreadsheet: bc2818a3-264e-4cb2-af74-5a21a38ed209
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: March 9, 2014 (7:06 pm)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229175
Q2-2004 | 233474
Q3-2004 | 235336
Q4-2004 | 238105
Q1-2005 | 241837
Q2-2005 | 244380
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276013
Q2-2008 | 278199
Q3-2008 | 280692
Q4-2008 | 273583
Q1-2009 | 267567
Q2-2009 | 267416
Q3-2009 | 268461
Q4-2009 | 271132
Q1-2010 | 273221
Q2-2010 | 275247
Q3-2010 | 279408
Q4-2010 | 281844
Q1-2011 | 284136
Q2-2011 | 290132
Q3-2011 | 292370
Q4-2011 | 293684
Q1-2012 | 296354
Q2-2012 | 298357
Q3-2012 | 300019
Q4-2012 | 308848
Q1-2013 | 309155
Q2-2013 | 311078
Q3-2013 | 314603
Q4-2013 | X
Spreadsheet: 37407d1235414221-calculating-over-two-sheets-imaging-consumables-stock-list-new
Sheet: Olivetti

Model A | Model B | Part Description | OEM Part Number | Katun Part Number | Yield | CPC Black | CPC Colour | Stock Level | Unit Value | Total Unit Value
D-Copia 600 | D-Copia 800 | Black Toner | B0528 |  |  |  |  | 0 | 68.25 | 0
D-Copia 600 | D-Copia 800 | Waste Toner Bottle | B0407 |  |  |  |  | 0 | 0 | 0
D-Copia 600 |  | Staples | B0192 |  |  |  |  | 0 | 0 | 0
MF2000 | MF1600 | Black Toner | [NAME] |  |  |  |  | 0 | 0 | 0
MF2000 | MF1600 | [NAME] | B0684 |  |  |  |  | 0 | 32.28 | 0
MF2000 | MF1600 | [NAME] | B0683 |  |  |  |  | 0 | 0 | 0
MF2000 | MF1600 | [NAME] | B0682 |  |  |  |  | 0 | 32.28 | 0
MF2000 | MF1600 | Black Imaging Unit | B0685 |  |  |  |  | 0 | 0 | 0
MF2000 | MF1600 | Yellow Imaging Unit | B0688 |  |  |  |  | 0 | 0 | 0
MF2000 | MF1600 | Magenta Imaging Unit | B0687 |  |  |  |  | 0 | 0 | 0
MF2000 | MF1600 | Cyan Imaging Unit | B0686 |  |  |  |  | 0 | 0 | 0
MF2000 | MF1600 | Transfer Belt | B0691 |  |  |  |  | 0 | 0 | 0
MF2000 |  | Fusing Unit | [NAME] |  |  |  |  | 0 | 0 | 0
MF1600 |  | Fusing Unit | B0689 |  |  |  |  | 0 | 0 | 0
MF25 |  | Black Toner | B0533 | 35301 |  |  |  | 0 | 68.25 | 0
MF25 |  | [NAME] | B0534 | 35304 |  |  |  | 0 | 0 | 0
MF25 |  | [NAME] | B0535 | 35303 |  |  |  | 0 | 0 | 0
MF25 |  | [NAME] | B0536 | 35302 |  |  |  | 0 | 0 | 0
MF25 |  | Black Imaging Unit | B0537 |  |  |  |  | 0 | 70.37 | 0
MF25 |  | Yellow Imaging Unit | B0538 |  |  |  |  | 0 | 0 | 0
MF25 |  | Magenta Imaging Unit | B0539 |  |  |  |  | 0 | 0 | 0
MF25 |  | Cyan Imaging Unit | B0540 |  |  |  |  | 0 | 0 | 0
MF25 |  | Fusing Unit | B0645 |  |  |  |  | 0 | 176.68 | 0
MF25 |  | Transfer Belt | B0644 |  |  |  |  | 0 | 269.944 | 0
MF25 |  | Staples MS-2C | [NAME] |  |  |  |  | 0 | 0 | 0
MF25 |  | Staples SK-602 | B0586 |  |  |  |  | 0 | 0 | 0
MF25 |  | Waste Toner Bottle | B0541 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | Total Consumable Units |  | 0
 |  |  |  |  |  |  |  | Total Unit Value |  | 0
Spreadsheet: 770289d1645978878-excel-formula-to-produce-balance-sheet-balance-sheet-2021b
Sheet: Balance Sheet

 | SUM(((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$C$4:$C$19))-((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$D$4:$D$19)))
 | Desired Outcome
 | Non-current Assets
 | Current Assets
 | Debtors and other receivables
 | Cash and equivalents
 | Total Assets
 | FINANCED BY:
 | EQUITY AND LIABILITIES
 | Accumulated funds
 | Net Surplus for the year
 | School development funds
 | Capital Per Grant
 | Total
 | Current Liabilities
 | Provisions
 | Other obligations
 | Total Equity and Liabilities
 | Fees
 | Sundry
 | Interest
 | Total Income
 | EXPENDITURE
 | Accounting Fees
 | Subs to association
 | Workshops & Conferences
 | Depreciation
 | Bank Charges
 | Electricity & Water
 | Teas & Cleaning
 | Funeral cover
 | Printing & Stationery
 | Salaries & Wages
 | Telephone & Internet
 | Medical Aid
 | Insurance & Licence
 | Repairs & Maintenance
 | Security
 | [NAME] expenses
 | NSSA
 | Sundry expenses
 | Fuel
 | Bad debts written off
 | Total Expenditure
 | Net Surplus for the year
Spreadsheet: 853229d1703127615-formula-to-mimic-nested-for-loops-to-loop-through-two-dynamic-arrays-sample-array-calculation
Sheet: Sheet1

 | Total Sales by Employee per Year |  |  |  |  |  | Filtered Data |  |  |  |  | Raw Data
 |  |  | 2022 | 2021 |  |  | Employee | Year | Sale Amount | Eligible? |  | Employee | Year | Sale Amount | Eligible?
 |  |  | #N/A | #N/A |  |  |  | 2023 | 1000 | Y |  | A | 2023 | 1000 | Y
 | B | #N/A | #N/A | #N/A |  |  | B | 2023 | 345 | Y |  | B | 2023 | 345 | Y
 | C | #N/A | #N/A | #N/A |  |  | C | 2023 | 2342 | Y |  | C | 2023 | 2342 | Y
 | D | #N/A | #N/A | #N/A |  |  | D | 2023 | 12 | Y |  | D | 2023 | 12 | Y
 | F | #N/A | #N/A | #N/A |  |  | A | 2023 | 4234 | Y |  | A | 2023 | 4234 | Y
 | G | #N/A | #N/A | #N/A |  |  | D | 2023 | 134 | Y |  | D | 2023 | 134 | Y
 | E | #N/A | #N/A | #N/A |  |  | F | 2023 | 515 | Y |  | F | 2023 | 515 | Y
 |  |  |  |  |  |  | G | 2023 | 325 | Y |  | G | 2023 | 325 | Y
 |  |  |  |  |  |  | E | 2023 | 453 | Y |  | E | 2023 | 453 | Y
 |  |  |  |  |  |  | B | 2022 | 5675 | Y |  | A | 2022 | 6 | N
 |  |  |  |  |  |  | C | 2022 | 345 | Y |  | B | 2022 | 5675 | Y
 |  |  |  |  |  |  | D | 2022 | 24 | Y |  | C | 2022 | 345 | Y
 |  |  |  |  |  |  | D | 2022 | 345 | Y |  | D | 2022 | 24 | Y
 |  |  |  |  |  |  | F | 2022 | 243 | Y |  | A | 2022 | 35 | N
 | When only one array is passed: |  |  |  |  |  | G | 2022 | 53 | Y |  | D | 2022 | 345 | Y
 |  |  | 2022 | 2021 |  |  | E | 2022 | 54 | Y |  | F | 2022 | 243 | Y
 |  |  |  |  |  |  | A | 2021 | 4654 | Y |  | G | 2022 | 53 | Y
 | B | 345 |  |  |  |  | B | 2021 | 234 | Y |  | E | 2022 | 54 | Y
 | C | 2342 |  |  |  |  | C | 2021 | 23 | Y |  | A | 2021 | 4654 | Y
 | D | 146 |  |  |  |  | D | 2021 | 64 | Y |  | B | 2021 | 234 | Y
 | F | 515 |  |  |  |  | D | 2021 | 34 | Y |  | C | 2021 | 23 | Y
 | G | 325 |  |  |  |  | F | 2021 | 643 | Y |  | D | 2021 | 64 | Y
 | E | 453 |  |  |  |  | G | 2021 | 42 | Y |  | A | 2021 | 75 | N
 |  |  |  |  |  |  | E | 2021 | 123 | Y |  | D | 2021 | 34 | Y
 |  |  |  |  |  |  |  |  |  |  |  | F | 2021 | 643 | Y
 |  |  |  |  |  |  |  |  |  |  |  | G | 2021 | 42 | Y
 |  |  |  |  |  |  |  |  |  |  |  | E | 2021 | 123 | Y
Spreadsheet: 525691d1498840068-dynamic-seasonality-forecast-season-forecast-example-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Need to take this dynamic balance here…
 |  |  |  |  |  |  |  |  |  |  |  |  |  | …and apply the balance over each future weeks here…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | …but is based on the seasonality trends here
 | 2017 Actuals/Forecast | week 31 | week 32 | week 33 | week 34 | week 35 | week 36 | week 37 | week 38 | week 39 | week 40 | week 41 | week 42 | week 43 | week 44 | week 45 | week 46 | week 47 | week 48 | week 49 | week 50 | week 51 | week 52 | Total
 | 2016 Actuals | week 31 | week 32 | week 33 | week 34 | week 35 | week 36 | week 37 | week 38 | week 39 | week 40 | week 41 | week 42 | week 43 | week 44 | week 45 | week 46 | week 47 | week 48 | week 49 | week 50 | week 51 | week 52 | Total
 | Seasonality --> | 6000 | 7000 | 9000 | 11000 | 13000 | 15000 | 20000 | 25000 | 30000 | 40000 | 30000 | 25000 | 20000 | 15000 | 14000 | 13000 | 12000 | 11000 | 10000 | 9000 | 8000 | 7000
 |  |  |  |  |  |  |  |  |  |  |  |  | Challenges:
 |  |  |  |  |  |  |  |  |  |  |  |  | * Forecast for remaining weeks (yellow) based on seasonality of last year, in green (not a FLAT forecast)
 |  |  |  |  |  |  |  |  |  |  |  |  | * Balance (applied to dynamic forecast) changes every week.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Incorrect "flat" forecast |  | (balance of 153,650 divided evenly across 10 remaining weeks)
 | 2017 Actuals/Forecast | week 31 | week 32 | week 33 | week 34 | week 35 | week 36 | week 37 | week 38 | week 39 | week 40 | week 41 | week 42 | week 43 | week 44 | week 45 | week 46 | week 47 | week 48 | week 49 | week 50 | week 51 | week 52 | Total
 |  | 5100 | 5950 | 7650 | 9350 | 11050 | 12750 | 17000 | 21250 | 25500 | 34000 | 25500 | 21250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct "dynamic" forecast |  | (balance of 153,650 applied across 10 remaining weeks in proportion to seasonality trends)
 | 2017 Actuals/Forecast | week 31 | week 32 | week 33 | week 34 | week 35 | week 36 | week 37 | week 38 | week 39 | week 40 | week 41 | week 42 | week 43 | week 44 | week 45 | week 46 | week 47 | week 48 | week 49 | week 50 | week 51 | week 52 | Total
 |  | 5100 | 5950 | 7650 | 9350 | 11050 | 12750 | 17000 | 21250 | 25500 | 34000 | 25500 | 21250
Spreadsheet: 167108d1341903743-lowest-value-with-corresponding-name-book1
Sheet: Sheet1

Broj djelatnika | Cijena | Cijena po čovjeku | [NAME] | Proračun ukupno |  | Ili zaokruženo | [NAME] | Proračun ukupno
1 | #N/A | #N/A | 592.5 | 592.5 |  |  | 600 | 600
2 | 1092 | 546 | 546 | 1092 |  |  | 550 | 1100
3 | #N/A | #N/A | 499.5 | 1498.5 |  |  | 500 | 1500
4 | 1812 | 453 | 453 | 1812 |  |  | 450 | 1800
Spreadsheet: 9348e880-ee33-46fc-a33b-92851300224d
Sheet: Sheet1

State of New Hampshire - General Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
2012-11-06 00:00:00 | State Senate District 5
 | [NAME], r | [NAME], d | [NAME]
Canaan | 693 | 1018 | 8
Charlestown | 1012 | 1129
Claremont Ward 1 | 784 | 781 | 3
Claremont Ward 2 | 1026 | 1002 | 3
Claremont Ward 3 | 886 | 828 | 1
Cornish | 488 | 524 | 1
Enfield | 819 | 1451 | 3
Hanover | 1448 | 4881 | 5
Lebanon Ward 1 | 686 | 1464 | 1
Lebanon Ward 2 | 632 | 1424 | 1
Lebanon Ward 3 | 721 | 1472 | 3
Lyme | 260 | 884 | 1
Plainfield | 485 | 861 | 1
Totals | 9940 | 17719 | 31
 | State Senate District 6
 | [NAME], r | [NAME], d | [NAME]
Alton | 1965 | 1172 | 2
Barnstead* | 1169 | 1027
Gilmanton | 1079 | 891 | 2
Farmington | 1459 | 1311 | 2
New Durham | 815 | 671 | 2
Rochester Ward 1 | 1069 | 1236
[NAME] | 1141 | 1190 | 2
[NAME] 3 | 1188 | 1156 | 6
Rochester Ward 4 | 914 | 1136 | 1
Rochester Ward 5 | 1123 | 1167 | 4
Rochester Ward 6 | 842 | 1170 | 3
Totals | 12764 | 12127 | 24
*correction received from clerk
Spreadsheet: 100755d1299008789-auto-sum-with-time-format-book1
Sheet: Sheet1

[NAME] of calls >60 secs Time (SECONDS)
159
0
0
0
0
0
107
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
70
0
0
0 |  |  | 159
77 |  |  | 107
0 |  |  | 70
 |  |  | 77
 |  |  | 103.25
Spreadsheet: 201143d1355873576-trying-to-merge-two-formulas-in-one-cell-updated_example
Sheet: Sheet1

NAME |  | AGE |  | HEIGHT |  | WEIGHT |  | RACE | Check Boxes |  | NAME | RESULT1 CASE 1 - AGE | RESULT2 CASE1 - HEIGHT | RESULT1 CASE 2 - WEIGHT | [NAME]
 |  |  |  |  |  |  |  |  | CASE 1 | CASE 2
[NAME] |  | 30 |  | 1.85 |  | 99 |  | 2 | a
[NAME] |  | 42 |  | 1.9 |  | 102 |  | 3 |  | a
[NAME] |  | 25 |  | 1.65 |  | 77 |  | 1
DOE |  | 19 |  | 1.77 |  | 84 |  | 2
 |  |  |  |  | ^
 |  |  | These columns will be hidden.
 |  |  |  |  |  |  |  |  | ^ | ^
 |  |  |  |  |  |  |  |  | Make here (column J and K , put an "a") the choice in the first sheet. Ignore column A:H.
 |  |  |  |  |  |  |  |  | From one side or the other but not two simultaneously.
 |  |  |  |  |  |  |  |  | Results should appear in sheet "Desired Results" column E and G, as my choice (case).
 |  |  |  |  |  |  |  |  | Case 1. - In sheet "Desired Results" column E and G must appear RESULT1-YEARS AND RESULT2-HEIGHT.
 |  |  |  |  |  |  |  |  | Case 2. - In sheet "Desired Results" column E and G must appear RESULT1-WEIGHT AND RESULT2-RACE.
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: INPUT

[NAME] | 2 | 3 | 5 | 6 | 7 | 8 | 9 |  |  |  |  |  | 10 | 11
 | PALO VERDE | Mead-230KV | Four Corners-345KV | Four Corners-230KV | West Wing | Ault-PSCO | Midway-PSCO | Bonanza | [NAME] | [NAME] | San Juan | VEA @ Mead | Financial Deal - SW | Financial Deal - SW
 |  |  |  |  |  |  |  |  |  |  |  |  | DJ-PV Index | PMW-PV
 | Physical | Physical | Physical | Physical | Physical | Physical | Physical | Physical | Physical | Physical | Physical | Physical | Financial | Financial
Ave off Peak
Ave off Peak
Ave off Peak
Ave off Peak
 |  |  |  |  |  | Ault-PSCO | Midway-PSCO | Bonanza | [NAME] | [NAME] | San Juan | VEA @ Mead
 |  |  |  |  |  | Physical | Physical | Physical | Physical | Physical | Physical | Physical
Spreadsheet: 854242d1704196942-daily-percentage-on-a-weekly-basis-percentage-calculation
Sheet: Metric Comparasion

 | Gastos Diversos | Quilomet. GPS (Km) | [NAME] | Produção Aplicativo (YANGO) | Produção [NAME] (YANGO) | Valor Depositado (Kz) |  | N. | Week interval | Date | Values | Daily Precentage (%)
2024-01-01 00:00:00 |  |  |  |  |  |  |  | 1 | 01/01/2024 07/01/2024 | 2024-01-01 00:00:00 | 18673
 |  |  |  |  |  |  |  |  |  |  | 31670
 |  |  |  |  |  |  |  |  |  |  | 19618
 |  |  |  |  |  |  |  |  |  |  | 22576
 |  |  |  |  |  |  |  |  |  |  | 20271
 |  |  |  |  |  |  |  |  |  |  | 16965
 |  |  |  |  |  |  |  |  |  |  | 45088
 |  |  |  |  |  |  |  | 2 | 08/01/2024 14/01/2024 |  | 6090
 |  |  |  |  |  |  |  |  |  |  | 9303
 |  |  |  |  |  |  |  |  |  |  | 20358
 |  |  |  |  |  |  |  |  |  |  | 17183
 |  |  |  |  |  |  |  |  |  |  | 33713
 |  |  |  |  |  |  |  |  |  |  | 38106
 |  |  |  |  |  |  |  |  |  |  | 41412
 |  |  |  |  |  |  |  | 3 | 15/01/2024 21/01/2024 |  | 13963
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 23273
 |  |  |  |  |  |  |  |  |  |  | 24751
 |  |  |  |  |  |  |  | 4 | 22/01/2024 28/01/2024
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Banner

233-A Jefferson Street • Newnan, GA 30263 |  |  |  | Phone: [PHONE]
 | Quantity
Size | 24 | 48 | 36 | 48 | 72 | 96 | 120
24 | 5 | 10 | 13 | 13 | 13 | 16 | 19
36 | 8 | 15 | 18 | 18 | 18 | 23 | 27
48 | 12 | 24 | 24 | 24 | 24 | 27 | 34