tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2fd5456f-3a21-4475-86ef-115432e385b5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8501.0 Retail Trade, Australia
 | TABLE 14. Retail Turnover; Completely Enumerated (large) and Sample (small), By Industry Group
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total Sample Sector ;  Total (State) ;  Food retailing ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Food retailing ; |  |  | Original | A3350086L | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350186W | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350102A | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350182L | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350190L | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Department stores ; |  |  | Original | A3350104F | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Other retailing ; |  |  | Original | A3350187X | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Other retailing ; |  |  | Original | A3350128X | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350074C | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350097V | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350099X | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350113J | 1994-04-01 00:00:00 | 2011-05-01 00:00:00 | 206 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: jonathan_mckay__16926__Area Managers
Sheet: Springbank

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Springbank Park For All Seasons |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 1457.29
 | February | 0 | 1433.48
 | March | 0 | 1162.28
 | April | 0 | 1125.75
 | May | 0 | 869.16
 | June | 0 | 597.4
 | July | 0 | 469.71
 | August | 0 | 87.34
 | September | 0 | 55.21
 | October | 0 | 663.47
 | November | 0 | 1070.27
 | December | 0 | 1377.31
 | TOTAL:
Spreadsheet: 686755d1594803061-cell-referencing-from-multiple-sheets-if-value-of-specific-cell-matches-trial-outstanding-returns-small
Sheet: Client List

 |  | CLIENT LIST
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | Lina | Ornina | Ash
 |  |  |  |  |  |  | Total Clients
Ref | Comments | Name | Form  Type | Accountant | Management Comments | Status
 |  |  |  | [NAME]
 |  |  |  | Lina
 |  |  |  | Lina
 |  |  |  | Lina
 |  |  |  | Lina
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Ash
 |  |  |  | Ash
 |  |  |  | Ash
 |  |  |  | Ash
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Ornina
 |  |  |  | Ornina
Spreadsheet: 761949d1641310403-formula-to-calculate-sales-up-to-todays-date-sales-up-to-todays-date
Sheet: Sheet1

Kindly asking for help on sumif formula on cell G7. It does not produce my desired outcome on cell G10. I want the formula to calculate all sales up to today's date, WHICH IS ON cell H5.
Transactions |  |  |  |  | Sales up to date
Date | Reference | Amount | Financial Category |  | Current Sumifs formula on cell G7
2022-01-01 00:00:00 | FW001 | 10000 | Sales |  | Sales
2022-01-02 00:00:00 | FW002 | 1000 | Sales
2022-01-03 00:00:00 | [NAME] | 5000 | Purchase |  | Desired outcome
2022-01-04 00:00:00 | FW004 | 4000 | Sales |  | Sales | 15000
2022-01-05 00:00:00 | FW005 | 3000 | Purchase
2022-01-06 00:00:00 | FW006 | 10000 | Sales
2022-01-07 00:00:00 | FW007 | 6000 | Sales
2022-02-01 00:00:00 | FW008 | 3000 | Sales
Spreadsheet: 772117d1647012513-pq-columnname-taken-from-cell-value-columnfromcellvalue
Sheet: Table1

 |  | CopyColumnValue
 |  | Choose column to copy: |  | Column2
 |  | let
 |  | Source = Excel.CurrentWorkbook(){[Name="CopyColumn"]}[Content]{0}[Column1]
 |  | in
 |  | Source
 |  | Table2 (using value from E3) |  |  |  |  |  |  |  |  |  | Table1 (expected result)
 |  | Column1 | Column2 | CopyColumn |  |  |  |  |  |  |  | Column1 | Column2 | CopyColumn
 |  | [NAME] | more bla bla |  |  |  |  |  |  |  |  | [NAME] | more bla bla | more bla bla
 |  | [NAME] | more bla bla |  |  |  |  |  |  |  |  | [NAME] | more bla bla | more bla bla
 |  | let |  |  |  |  |  |  |  |  |  | let
 |  | Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], |  |  |  |  |  |  |  |  |  | Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
 |  | #"Added Custom" = Table.AddColumn(Source, "CopyColumn", each [CopyColumnValue]) |  |  |  |  |  |  |  |  |  | #"Added Custom" = Table.AddColumn(Source, "CopyColumn", each [Column2])
 |  | in |  |  |  |  |  |  |  |  |  | in
 |  | #"Added Custom" |  |  |  |  |  |  |  |  |  | #"Added Custom"
Spreadsheet: 781762d1653531039-tree-network-aginn_test_finding_route_node
Sheet: Sheet3

Node | Node | Length |  | route |  | Route No | Last | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv
1 | 2 | 19 |  |  |  | 1
2 | 3 | 11
2 | 10 | 10
5 | 10 | 14
6 | 10 | 8
7 | 10 | 11
 |  |  |  |  | Route
 |  |  |  |  | 1 |  | Node | Node | Length
 |  |  |  |  |  | 1
 |  |  |  |  | Route
 |  |  |  |  | 2 |  | Node | Node | Length
 |  |  |  |  | Route
 |  |  |  |  | 3 |  | Node | Node | Length
 |  |  |  |  | Route
 |  |  |  |  | 4 |  | Node | Node | Length
 |  |  |  |  | Route
 |  |  |  |  | 5 |  | Node | Node | Length
Spreadsheet: 5deead2c-7500-48cb-9896-440f96c74113
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40926928 | 2014-04-10 13:21:55 | AXIS | 1 | 6 | 3 | 1444429 | michelecannone | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
40927092 | 2014-04-10 13:36:49 | ALLIES | 0 | 2 | 6 | 1444429 | michelecannone | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
Spreadsheet: 866968d1713878492-generating-a-list-of-all-possible-variants-tolerance-variables-updated
Sheet: Sheet1

Material | [NAME] ([NAME]) | [NAME] (mm) | Thickness ([NAME]) | Thickness Tolerance (mm) | Length (M) | Length Tolerance (mm)
Solid Flat | ≤ 35 | ± 0.5 | ≤ 10 | ± 0.4 | 4 - 7 | + 50 / - 0
Solid Flat | >35 -75 | ± 0.8 | >10 - 20 | ± 0.5 | 4 - 7 | + 50 / - 0
Solid Flat | >75 - 100 | ± 1 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
Solid Flat | >100 - 125 | ± 1.3 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
Solid Flat | >125 - 150 | ± 1.5 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
 |  | Example of Results:
 |  | Material | [NAME] ([NAME]) | [NAME] (mm) | Thickness ([NAME]) | Thickness Tolerance (mm) | Length (M) | Length Tolerance (mm)
 |  | Solid Flat | ≤ 35 | ± 0.5 | ≤ 10 | ± 0.4 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | ≤ 35 | ± 0.5 | >10 - 20 | ± 0.5 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | ≤ 35 | ± 0.5 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >35 -75 | ± 0.8 | ≤ 10 | ± 0.4 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >35 -75 | ± 0.8 | >10 - 20 | ± 0.5 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >35 -75 | ± 0.8 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >75 - 100 | ± 1 | ≤ 10 | ± 0.4 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >75 - 100 | ± 1 | >10 - 20 | ± 0.5 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >75 - 100 | ± 1 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >100 - 125 | ± 1.3 | ≤ 10 | ± 0.4 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >100 - 125 | ± 1.3 | >10 - 20 | ± 0.5 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >100 - 125 | ± 1.3 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >125 - 150 | ± 1.5 | ≤ 10 | ± 0.4 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >125 - 150 | ± 1.5 | >10 - 20 | ± 0.5 | 4 - 7 | + 50 / - 0
 |  | Solid Flat | >125 - 150 | ± 1.5 | >20 - 40 | ± 0.6 | 4 - 7 | + 50 / - 0
Spreadsheet: 854069d1704036541-relating-employee-names-to-duty-numbers-and-posting-elsewhere-duty-allocation
Sheet: Duty Allocation

 | 2023-12-01 00:00:00 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 |  |  |  | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty
 | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME] | OFF | OFF | 7 |  |  |  |  |  |  | 2023-12-01 00:00:00 | [NAME] | Stuart | NA | [NAME] | [NAME] | NA | NA | NA | NA | NA
[NAME] | 1 |  |  | OFF | OFF |  |  |  |  | 2023-12-02 00:00:00
Stuart | 2 |  |  |  |  | OFF | OFF |  |  | 2023-12-03 00:00:00 |  |  |  |  |  |  | [NAME]
[NAME] | 5 | OFF | OFF |  |  |  |  |  |  | 2023-12-04 00:00:00
[NAME] | 4 |  | OFF | OFF |  |  |  |  |  | 2023-12-05 00:00:00
[NAME] | OFF |  |  |  |  |  | OFF |  |  | 2023-12-06 00:00:00
Duties to Cover | 3 | 1,2,3,4,5, | 6,8,9,10, | 6,7,8,9,10, | 6,7,8,9,10, | 6,7,8,9,10, | 1,2,3,4,5, |  |  | 2023-12-07 00:00:00
Spreadsheet: 5d0d3fcb-cb19-42b1-991c-2c90c95b0975
Sheet: Sheet1

Example - Supporting Calculations for the Year One Budget | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Enrollment | Attendance |  | FSP | FSP
Year one [NAME]. |  | 0.8 |  | Total $
450 |  | 360 | 6000 | 2160000
6100 - Salaries: |  |  |  |  | FTEs
Superintendent/Principal |  |  |  | 106090 | 1
Assistant Principal |  |  |  | 61180 | 1
Counselor |  |  |  | 54075 | 1
Business Manager |  |  |  | 53045 | 1
PEIMS Coordinator |  |  |  | 40000 | 1
Office Assistant |  |  |  | 30900 | 1
Parent Coordinator |  |  |  | 36050 | 1
Security Guard (1/2) |  |  |  | 25750
Teachers & other Professional Personnel
Support Personnel
Teachers (22) @ $ 42,500 (average) |  |  |  | 935000 | 22
Intern |  |  |  | 30900 | 1
Teacher ([NAME].) |  |  |  | 50923 | 1
[NAME]. Aide |  |  |  | 30000 | 1
 |  |  |  |  | 32 | Total FTEs
6112 - Substitutes-$80/day, 5 days/teacher (13) |  |  |  | 8800
Total Salaries |  |  |  | 1462713
6141 - Medicare - 1.45% of total salaries |  |  |  | 21209
6141 - Social Security - 6.2% of substitute salaries |  |  |  | 545.6
6142 - Insurance Benefits - $300/mo *12mos. per F-T employee (32) |  |  |  | 115200
6143 - Worker's Compensation Insurance - 0.90% of total salaries |  |  |  | 13164
6146 - TRS - Reporting Entity 0.55% of total salaries |  |  |  | 8045
6146 - TRS - New Member match 6.446% for 25% of total salaries for 90 days |  |  |  | 23572
 |  | Total Payroll Cost (6100) |  | 1644448.6
Professional & Contracted Services (6200):
6211 - Legal Services |  |  |  | 5000
6212 - Audit Services |  |  |  | 12500
6219 - Professional Svs. |  |  |  | 0
6249 - Contracted Maintenance & Repair |  |  |  | 0
6259 - Utilities | $250/mo. Phone |  | 12 | 3000
 | $2,000/mo. Electricity |  | 12 | 24000
6269 - Rentals | $400/mo. [NAME] |  | 12 | 4800
 | $10,000/mo. Rent - new facility |  | 12 | 120000
 |  |  |  | 0
6299 - Misc. Svs.-housekeep & supplies |  | $2,000/mo. | 12 | 24000
Total Professional & Contracted Services (6200) |  |  |  | 193300
Supplies (6300):
6321 - Textbooks | $75/book, 5/student enrollment |  | $75 x 5 books per student | 135000
6329 - Books -library | 500/$10 each |  |  | 5000
6339 - Testing mat. | $20/student |  | $20  per student | 7200
6399 - Other mat. | $20/student |  | $20  per student | 7200
6399 - Class supplies | $8/student |  | $8 per student | 2880
6399 - Computer hardware | 40 @ $750 each |  | 30000 | 30000
6399 - Band/drama | $30/student |  | $30  per student | 10800
Total Supplies (6300) |  |  |  | 198080
[NAME]. Operating Costs (6400):
6412 - Misc. Student Transportation | $5/student X 4 trips |  | $5 x 4 trips | 7200
6499 - Student Field Trips | $40/student |  |  | 14400
[NAME]. Operating Costs (6400) |  |  |  | 21600
 | Total Estimated Expenses   >>>> |  |  | 2057428.6
Spreadsheet: 847171d1698227565-help-please-trying-to-add-a-within-one-year-contingency-to-a-formula-example-workbook
Sheet: Sheet1

Name | Type of contact | Date planned for | Actual Date held | Next activity | Date planned for | Actual Date held | Next activity | Date planned for | Actual Date held
bill | [NAME] | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | [NAME] | 2023-10-15 00:00:00 | 2023-10-15 00:00:00 | Meeting | 2023-10-25 00:00:00 | 2023-10-25 00:00:00
[NAME] | [NAME] | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | No more contact
[NAME] | Meeting | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | Meeting | 2023-10-17 00:00:00 | 2023-10-17 00:00:00 | Meeting | 2023-10-27 00:00:00
[NAME] | No more contact | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | Phonecall | 2023-10-18 00:00:00 | 2023-10-18 00:00:00 | Meeting | 2023-10-28 00:00:00
[NAME] | Phonecall | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | Proposal | 2023-10-19 00:00:00 | 2023-10-19 00:00:00 | Proposal | 2023-10-29 00:00:00
cara | Proposal | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | Phonecall | 2023-10-20 00:00:00 | 2023-10-20 00:00:00 | Meeting | 2023-10-30 00:00:00
Spreadsheet: 81598d1281713910-excel-2007-counting-once-741438
Sheet: Sheet1

IBM | 2002 |  |  |  | IBM
IBM | 2002 |  |  |  | Capita
IBM | 2003 |  |  |  | Serco
Capita | 2004 |  |  |  | Liberata
Capita | 2005
Serco | 2005
Serco | 2006
Liberata | 2001
Liberata | 2007
Spreadsheet: 75112d1275640820-how-to-incorporate-if-and-vlookup-formula-to-a-match-index-formula-sample-match-index-and-if
Sheet: Sheet1

 |  |  |  |  |  | MY FORMULA
Date | Country | Code | ID | QTY |  | Country | ID | Code | QTY
2010-05-27 00:00:00 | AUSTRALIA | 73681 | 359110 | 2533 |  | JAPAN | 359765
2010-05-27 00:00:00 | CHINA | 2301380 | 359110 | 0 |  | AUSTRALIA | 359110
2010-05-27 00:00:00 | INDIA | 117276 | 359110 | 856 |  | CHINA | 359110
2010-05-27 00:00:00 | JAPAN | 3795400 | 359110 | 145 |  | CHINA | 358635
2010-05-27 00:00:00 | CHINA | 25646 | 359110 | 2489
2010-05-27 00:00:00 | JAPAN | 6454300 | 359765 | 2564 |  | Since there is 2 lines that has China and 359110 criterias it always return the first China+359110 that it finds
2010-05-27 00:00:00 | JAPAN | 6454200 | 359764 | 8541 |  | My problem is I want an IF function incorporated in my formula so instead of returning the first data that excel finds
2010-05-27 00:00:00 | CHINA | F22937200 | 358635 | 0 |  | It will return the data that is Greater than zero
2010-05-27 00:00:00 | CHINA | 117117 | 358635 | 0
2010-05-27 00:00:00 | CHINA | 3790300 | 358635 | 4569
 |  |  |  |  |  | OUTPUT I WANT
 |  |  |  |  |  | Country | ID | Code | QTY
 |  |  |  |  |  | JAPAN | 359765 | 6454300 | 2564
 |  |  |  |  |  | AUSTRALIA | 359110 | 73681 | 2533
 |  |  |  |  |  | CHINA | 359110 | 25646 | 2489
 |  |  |  |  |  | CHINA | 358635 | 3790300 | 4569
Spreadsheet: 771389d1646652009-how-will-index-match-work-with-name-range-over-12-sheets-or-with-a-vba-test
Sheet: Credit Note

THE KOMBO TEAM
NTN No. 5327436-3
STRN: 32-77-8761-969-90
65-KM, Multan Road, [NAME], Kasur.
CREDIT NOTE
TO: LOFTEX LIMITED
NTN# 4111664-0 |  |  |  |  |  | Credit Note No. |  | TKT/03/2022
STRN# 03-00-4111-664-14 |  |  |  |  |  | Date:
1-KM Defence Road, Off Bhobhatian, Near UOL Lahore PK.
Inv. No. | Description |  | Style No. | QTY | Rate | Ex. Value | GST | Inc Value
1
TOTAL |  |  |  |  | -
 |  |  |  |  |  |  | Approved By:
Spreadsheet: 3414f8ae-6125-43a9-a7db-941ee9f18aca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  |  | Sezione successiva
QUESTIONARIO PER LA RACCOLTA DEI DATI AMBIENTALI NEL DISTRETTO DEL MOBILE LIVENZA
Introduzione
[NAME] lo scopo di raccogliere i dati [NAME] di una nuova Analisi Ambientale Territoriale, trascorsi tre anni dall’ottenimento dell’attestato EMAS, come previsto dallo stesso regolamento di ecogestione, per la verifica dei miglioramenti ottenuti e delle eventuali nuove criticità territoriali.
[NAME] analisi si rende indispensabile per il mantenimento [NAME] elemento di base per la qualificazione ambientale dei prodotti del Distretto medesimo.
I dati che vengono richiesti debbono essere riferiti a due annualità, 2007-2008, in quanto quelli dell’ultimo anno potrebbero essere influenzati dalla congiuntura [NAME] produzione.
[NAME] suddiviso in 8 Sezioni, all'interno di ogni sezione trovano spazio delle tabelle da compilare con i dati che interessano la vostra unità produttiva.
Le Sezioni che compongono il questionario sono le seguenti:
Sezione A: Informazioni generali sull'Unità Produttiva
Sezione B: Attività produttiva
Sezione C, C1, C2: Consumi di materie prime, di semilavorati e di prodotti ausiliari
Sezione D, D1, D2, D3: Dati ambientali quantitativi
Sezione E, E1: Impianti e tecnologie di verniciatura
Sezione F: Tutela del suolo
Sezione G: Altre informazioni
Sezione H: Informazioni sulla gestione della sicurezza
Si consiglia la compilazione del questionario direttamente su [NAME] (foglio di lavoro MS Excel). Le risposte preordinate, indicate dalla colorazione azzurra, vengono date apponendo una X all'interno della cella corrispondente.
La compilazione su PC riduce gli sprechi di carta e aiuta a rispettare l’ambiente nell’ottica della gestione ecosostenibile del nostro territorio.
Grazie per la gentile collaborazione.
Spreadsheet: 681573d1591640779-count-values-in-one-range-if-the-cells-in-a-corresponding-range-are-not-empty-forum-help
Sheet: Sheet1

[0-10 yrs/oed] | [11-15 yrs/oed] | [16-24 yrs/oed] | [25-34 yrs/oed] | [35-44 yrs/oed] | [45-54 yrs/oed] | [55-64 yrs/oed] | [65-74 yrs/oed] | [75+]
 | 1 | 2 |  | 2 | 1
2 |  | 3 | 1 |  | 2
 | 2 |  |  |  | 2
 |  | 3 |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 | 1 | 1 |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  | 1 |  | 1
 |  | 2 |  |  | 1 | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  |  | 2
2 | 2 |  | 1 | 1
1 | 1 |  |  |  | 1 | 1
 |  | 2 | 1 |  | 1 | 1
1 | 1 |  |  |  | 2
1 |  |  | 1 | 1
Spreadsheet: 833761d1687248091-calculator-with-inputs-and-outputs-in-same-cells-fermentation-salt-calculator
Sheet: Sheet1

Ingredient mass (grams)
Desired salt percentage
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1
MSG | 0.123 | --
ingt 1 |  |  | 0 |  | <<<FIRST, I'D LIKE THE USER TO BE ABLE TO FILL IN EITHER THE SODIUM OR SALT % FOR HOWEVER MANY OF THESE 5 INGREDIENTS THEY ARE USING
ingt 2 |  |  | 0
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Ingredient mass (grams)
Desired salt percentage
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1
MSG | 0.123 | --
Soy sauce |  | 0.23 |  |  | <<<SO, LET'S SAY THE PERSON IS USING SOY SAUCE THAT SHOWS A SALT  % OF 23%, AND  A FISH SAUCE THAT SHOWS A SODIUM  PERCENTAGE OF 11%
Fish sauce | 0.11
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Ingredient mass (grams) |  | 1210
Desired salt percentage |  | 0.02
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1 | 6.05
MSG | 0.123 | -- | 19.08
Soy sauce |  | 0.23 | 26.3 |  | <<<NOW, I'D LIKE IT TO CALCULATE HOW MUCH OF EACH INGREDIENT IS NECESSARY TO ACHIEVE THE DESIRED 2% SALT IN 1210 [NAME], AND DISPLAY THESE AS 4 EQUAL AMOUNTS
Fish sauce | 0.11 |  | 21.34
ingt 3 |  |  | 0 |  |  |  | 2.0% OF 1210 IS 24.2 GRAMS
ingt 4 |  |  | 0 |  |  | EACH INGREDIENT SHOULD THEREFORE SUPPLY THE EQUIVELENT OF 6.05G OF SALT, AND WOULD BE SHOWN AS SUCH
ingt 5 |  |  | 0
Ingredient mass (grams) |  | 1210
Desired salt percentage |  | 0.02
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1 | 7.09 | <<newly calculated
MSG | 0.123 | -- | 10 | <<my new input
Soy sauce |  | 0.23 | 28.41 | <<newly calculated | <<<BUT I'D LIKE TO BE ABLE TO OVERRIDE ANY OF THEM. SO SAY I  ONLY WANT TO ADD 10g OF MSG, I CAN PUT 10 IN THAT CELL AND THE REST WOULD BE RE-CALCULATED
Fish sauce | 0.11 |  | 26.48 | <<newly calculated
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Ingredient mass (grams) |  | 1210
Desired salt percentage |  | 0.02
Ingredient | Sodium % | Salt % | grams
Salt | 0.388 | 1 | 10 | <<my new input
MSG | 0.123 | -- | 10 | <<my new input
Soy sauce |  | 0.23 | 22.41 | <<newly calculated | <<<AND SAY I WANT ALSO 10G OF SALT, THE REMAINING 2 WOULD AGAIN BE RE-CALCULATED
Fish sauce | 0.11 |  | 23.98 | <<newly calculated
ingt 3 |  |  | 0
ingt 4 |  |  | 0
ingt 5 |  |  | 0
Spreadsheet: 159938d1338909451-conditional-sum-without-changing-source-sheet-sumproduct
Sheet: Sheet1

 |  | 20 | 20 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 22 | 22
 | [NAME] | 1 | 0 | 4 | 5 | 6 | 7 | 8 | 3 | 2 | 4 | 1
 | [NAME] | 2 | 9 | 16 | 23 | 30 | 37 | 44 | 51 | 58 | 65 | 72
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | April | 4 | 7 | 10 | 13 | 16 | 19 | 22 | 25 | 28 | 31 | 34
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | Sumproduct Week 21 |  |  | JB
 |  |  | [NAME] | 10 |  | 10
 |  |  | [NAME] | 29 |  | 29
 |  |  | [NAME] | 185 |  | 185
 |  |  | April | 95 |  | 95
 |  |  | Now: | All entries with 21 taken into account
 |  |  | Goal: | Only taking the green entries into account (neglect the first and the last entry 21)