tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109568d1306396908-lookup-countif-sumiif-copy-of-example-questionnaire
Sheet: Summary Results

 | Very Satisfied | Satisfied | Neither satisfied nor dissatisfied | Dissatisfied | Very dissatisfied | Did not use | Applicant Comments
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 |  | Data
 | Question Number | Sum of Satisfied | Sum of Very Satisfied | Sum of Neither satisfied nor dissatisfied | Sum of Dissatisfied | Sum of Very dissatisfied | Sum of Did not use
 | 1 | 1 | 1 | 2 | 0 | 0 | 0
 | 2 | 1 | 1 | 1 | 1 | 0 | 0
 | 3 | 4 | 0 | 0 | 0 | 0 | 1
 | 4 | 1 | 0 | 1 | 0 | 1 | 1
 | 5 | 0 | 0 | 4 | 0 | 0 | 0
 | 6 | 0 | 1 | 1 | 1 | 1 | 0
 | 7 | 0 | 3 | 0 | 0 | 0 | 1
 | 8 | 1 | 1 | 1 | 1 | 0 | 0
 | 9 | 2 | 2 | 0 | 0 | 0 | 0
 | 10 | 0 | 0 | 2 | 2 | 0 | 0
 | 11 | 0 | 4 | 0 | 0 | 0 | 0
 | 12 | 1 | 1 | 0 | 1 | 1 | 0
 | 13 | 0 | 0 | 0 | 4 | 0 | 0
 | 14 | 1 | 1 | 1 | 1 | 0 | 0
 | 15 | 0 | 0 | 0 | 3 | 1 | 0
 | 16 | 0 | 4 | 0 | 0 | 0 | 0
 | 17 | 0 | 0 | 0 | 1 | 3 | 0
 | Grand Total | 12 | 19 | 13 | 15 | 7 | 3
Spreadsheet: 058a01ee-b8a4-449d-9c7e-9ea654e1dfbd
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
 | 8731.0 Building Approvals, Australia
 | TABLE 80. Value of Building Approved, Chain Volume Measures, Original - Tasmania
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total houses ;  New ; |  |  | Original | A590527L | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total other residential building ;  New ; |  |  | Original | A590528R | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A590529T | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590530A | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590531C | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590532F | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590533J | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 135621d1326141900-excel-2007-conditional-formatting-doesnt-print-in-color-which-is-what-i-want-shows-up-in-b-and-w-copy-of-sample-workbook-4
Sheet: Dora's Use - Cum TO Data

Authorized Values
FY2009
 | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
Misc. [NAME] | 14000000 | 14000000 | 14000000 | 14000000 | 14000000 | 14000000 | 14000000 | 14000000 | 14000000 | 14000000 | 14000000 | 14000000
Mitchell - Authorized Amount | 3150000 | 3650000 | 3950000 | 3950000 | 3950000 | 3950000 | 3950000 | 3950000 | 3950000 | 4400000 | 4400000
Phillips May - Authorized Amount | 3050000 | 3050000 | 3750000 | 4250000 | 4550000
Vestal Builders - Authorized Amount |  |  | 2250000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000
Cumulative Task Order Amounts
 | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
Mitchell -          Task Orders Awarded | 3145677 | 3145677 | 3145677 | 3331393 | 3331393 | 3723313 | 3740713 | 3740713 | 3740713 | 4072030 | 4172308 | 4186724
Phillips May -     Task Orders Awarded | 2947867 | 2947867 | 2947867 | 4220660 | 4220660 | 4220660 | 4220660 | 4220660 | 4220660 | 4245660 | 4354993 | 4478425
Vestal -               Task Orders  Awarded | 2239186 | 2239186 | 2239186 | 2243080 | 2243080 | 2282251 | 2282251 | 2282251 | 2282251 | 2282251 | 2282251 | 2328471
Spreadsheet: 737828d1624622801-formula-to-extract-items-from-one-list-not-present-in-a-second-list-book2
Sheet: Sheet1

List 1 | List 2 | Unique Values
T7750 | T7890 |  | T7890
T1650 | T0990 | T1650 | T0990
T2580 | T7460 | T2580 | T7460
C0550 | T3050 | C0550 | T3050
T1520 | T1650 | T1520 | T1650
T1550 | T2920 | T1550 | T2920
T2920 | C0550 | T2920 | C0550
T0990 | T0770 | T0990 | T0770
T1550 | T1550 | T1550 | T1550
T1520 | T1640 | T1520 | T1640
T0480 | T3330 | T0480 | T3330
T7280 | T7280 | T7280 | T7280
T0620 | T7810 | T0620 | T7810
T1480 | T7830 | T1480 | T7830
T0820 | T2580 | T0820 | T2580
T7760 | T3380 | T7760 | T3380
T7820 | T7780 | T7820 | T7780
T7860 | T7820 | T7860 | T7820
T0210 | T7860 | T0210 | T7860
T0090 | T8010 | T0090 | T8010
T7460 | T0090 | T7460 | T0090
T0390 | T0240 | T0390 | T0240
T0880 | T7770 | T0880 | T7770
T4420 | T7800 | T4420 | T7800
00669 | T1480 | 00669 | T1480
[NAME] | C0310 | [NAME] | C0310
T7750 | T0230 | T7750 | T0230
T7770 | T3040 | T7770 | T3040
T7780 | T0620 | T7780 | T0620
T7810 | T1280 | T7810 | T1280
T0240 | T0820 | T0240 | T0820
T0600 | T2810 | T0600 | T2810
T0770 | T0010 | T0770 | T0010
T1280 | T2910 | T1280 | T2910
C0310 | T0210 | C0310 | T0210
T3040 | T7390 | T3040 | T7390
 | T7710 | 0 | T7710
 | T0390 | 0 | T0390
 | T7750 | 0 | T7750
Spreadsheet: 701349d1603718348-how-to-track-production-target-date-job-work-production-tracking
Sheet: Sheet1

FABRIC | DAILY PRODUCTION REPORT |  |  |  |  |  |  |  |  | JANUARY |  |  |  |  |  |  |  |  |  | TO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLEUR | BASKET | DIAMOND | GEO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER EXECUTED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDER | ORDER EXECUTION DATE | LEAD TIME | TOTAL | DIFFERENCE | DAILY EXPECTED | EXPECTED COMPLETION DATE | CHANGED DATE
FLEUR | 50 | 40 | 100 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  | 8000 | 2020-01-01 00:00:00 | 60
BASKET |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 2020-01-15 00:00:00 | 60 |  |  |  | 2020-01-15 00:00:00
DIMOND |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
CELTIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
GEO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
Spreadsheet: 22f4c20d-5137-4749-af19-5944479c1c55
Sheet: Sheet1

 | D. melanogaster | D. simulans | interspecific hybrids
mRNA deep sequencing
total reads | 20749397 | 16260481 | 17751772
mappable reads | 16016325 | 11222087 | 13633828
non-rRNA | 12213849 | 9662349 | 10478379
TE derived reads (mapped to consensus with <= 3mis-matches) | 110,214 (1%) | 33,581 ( <1%) | 371,051(4%)
TE derived reads (mapped to all annotated insertions) | 122,598 (1%) | 106,289 (1%) | 414,609 (4%)
piRNA deep sequencing
total reads | 25352717 | 27293275 | 27821836
usable reads (length >18bp, linker sequence detected) | 20494507 | 22909649 | 20232683
mappable reads | 17597930 | 19152227 | 16793422
candidate miRNAs and siRNAs | 7,281,477 (41%) | 6,925,546 (36%) | 10,985,031 (65%)
candidate piRNAs | 10,316,453 (59%) | 12,226,681 (64%) | 5,808,391 (35%)
TE derived candidate [NAME] (mapped to consensus with <=3mis-matches) | 7,102,168 (69%) | 7,151,245 (58%) | 2799049
 |  |  | -0.48
TE derived candidate [NAME] (mapped to all annotated insertions) | 6,362,718 (62%) | 8,724,310 (71%) | 2656339
 |  |  | -0.46
Spreadsheet: 857073d1706152661-calculating-data-from-multiple-sheets-manually-calculated-example
Sheet: Consolidated

 | Pro Forma Summary
 |  |  |  |  | Pro Forma
 |  |  |  |  |  | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033
 |  |  |  |  |  | 1
 |  |  |  |  |  | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma
 | Revenue
 | [NAME]
 | Gross Profit
 | Operating Expenses
 | NOI
 | Management Fee Allocation |  | 0.05
 | EBITDA
 | [NAME] |  | 0.015
 | DCF (Unlevered)
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: ManualInspection

Detail No. | Quantity | [NAME] | Check Tight Tolerances | Check General Tolerances | First Offs | Stamp Certificate | Sign/Stamp Paperwork | Check Stamped Paperwork | Other | Total Time (hours) | NOTES
 | 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 |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  | 0
. |  |  |  |  |  |  |  | Grand Total |  | 0
Spreadsheet: 884134d1733157069-sum-by-month-for-multiple-dates-excelhelp_sum
Sheet: Sheet1

Input format |  |  |  |  |  | OUTPUT format
Customer | Product | Plant | Date | Amount |  | Customer | Product | Plant | Date | Amount
CUSTABC | A | 1000 | 2024-01-02 00:00:00 | 0 |  | CUSTABC | A | 1000 | 2024-01-01 00:00:00 | 0
CUSTABC | A | 1000 | 2024-01-20 00:00:00 | 0 |  | CUSTABC | A | 1000 | 2024-02-01 00:00:00 | 3
CUSTABC | A | 1000 | 2024-02-02 00:00:00 | 1 |  | CUSTABC | A | 1000 | 2024-03-12 00:00:00 | 1
CUSTABC | A | 1000 | 2024-02-13 00:00:00 | 2 |  | CUSTABC | A | 1000 | 2024-06-01 00:00:00 | 2
CUSTABC | A | 1000 | 2024-03-12 00:00:00 | 1 |  | CUSTABC | A | 1000 | 2024-07-01 00:00:00 | 2
CUSTABC | A | 1000 | 2024-06-04 00:00:00 | 1
CUSTABC | A | 1000 | 2024-06-18 00:00:00 | 1
CUSTABC | A | 1000 | 2024-07-07 00:00:00 | 1
CUSTABC | A | 1000 | 2024-07-20 00:00:00 | 1
Spreadsheet: 788122d1658292996-random-generating-number-list-no-duplicates-in-columns-or-rows-rand-15-numbers-in-col-and-row
Sheet: Sheet1

 |  |  |  |  |  |  | Press F9 until H1 is Zero.  Then Column B and C give you what you want.
Spreadsheet: 790117d1659539825-sum-hours-sum-hours-1-
Sheet: Sheet1

 |  | WORK ORDER ID | TIME START | TIME FINISH | TOTAL HOURS |  | WORK ORDER ID | 21-1375
 |  | AUGUST22 | 07:00:00 | 08:00:00
 |  | 18-1370 | 08:00:00 | 10:00:00 |  |  | Sum of TOTAL HOURS
 |  | AUGUST22 | 10:00:00 | 12:30:00 |  |  | 01:30:00
 |  | 21-1375 | 12:30:00 | 13:30:00
 |  | 18-1370 | 13:30:00 | 14:00:00
 |  | 22-1976 | 14:00:00 | 15:00:00 |  |  | https://www.excelforum.com/newreply.php?do=postreply&t=1384227
 |  | 21-1375 | 15:00:00 | 15:30:00
Spreadsheet: 692427d1598334578-weighted-distribution-of-diminishing-values-based-on-multiple-criteria-weighted-distribution-of-values-based-on-multiple-criteria
Sheet: Finished Example

***Ignore these cells***
Pathologists | cFTE | On service? | Which service? | Daily available cFTE | % distribution | BE quota | Service-specific BE | BE deficit/surplus |  | Starting distribution load |  | Distribution |  |  |  |  | BE deficit/surplus
 |  |  |  |  |  |  |  | Today AM | Previous day |  |  | BAL | PBS | CSF | Total |  | Today PM
AA | 0.7 | Y | HEME |  |  |  |  |  | 0 |  |  | 1 | 2 | 1
BB | 1 | Y | MPLS |  |  |  |  |  | 0 |  |  | 1 | 1 | 1
CC | 0.7 | Y | STP |  |  |  |  |  | 0 |  |  |  | 1 | 1
DD | 1 | N | N/A |  |  |  |  |  | 0
EE | 1 | Y | GI |  |  |  |  |  | 0 |  |  |  | 1
 |  |  |  | Total available cFTE
 |  |  |  |  |  |  | Cases to distribute
 |  |  |  |  |  |  |  | Total | Left to distribute
 |  |  |  |  |  |  | BAL | 2
 |  |  |  |  |  |  | PBS | 5
 |  |  |  |  |  |  | CSF | 3
Y | N
 |  |  |  |  |  |  | Total
N/A | MPLS | STP | HEME | GI | MISC
 | 20 | 15 | 10 | 26
Spreadsheet: 872397d1718796799-countifs-but-ignoring-duplicates-in-1-column-testdata-clientcountv2
Sheet: Data

Client | Team | Purchase Type | Review Completed |  |  |  | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00
1 | ICT | SPOT | 2024-04-15 00:00:00 |  |  | ICT
2 | ICT | Commission | 2024-04-15 00:00:00 |  |  | BAU
3 | BAU | Commission | 2024-04-15 00:00:00 |  |  | Review
4 | Review | Commission | 2024-04-15 00:00:00
5 | ICT | Commission | 2024-04-15 00:00:00
6 | Review | SPOT | 2024-04-15 00:00:00
6 | Review | SPOT | 2024-04-15 00:00:00
7 | Review | Commission | 2024-04-15 00:00:00
8 | BAU | SPOT | 2024-04-15 00:00:00
9 | BAU | SPOT | 2024-05-15 00:00:00
10 | ICT | Commission | 2024-05-15 00:00:00
10 | ICT | Commission | 2024-05-15 00:00:00
11 | ICT | SPOT | 2024-05-15 00:00:00
12 | BAU | SPOT | 2024-05-15 00:00:00
12 | BAU | SPOT | 2024-05-15 00:00:00
13 | BAU | Commission | 2024-05-15 00:00:00
14 | BAU | Commission | 2024-05-15 00:00:00
111 | ICT | SPOT | 2025-04-15 00:00:00
112 | ICT | Commission | 2025-04-15 00:00:00
113 | BAU | Commission | 2025-04-15 00:00:00
114 | Review | Commission | 2025-04-15 00:00:00
115 | BAU | Commission | 2025-04-15 00:00:00
116 | Review | SPOT | 2025-04-15 00:00:00
116 | Review | SPOT | 2025-04-15 00:00:00
117 | BAU | Commission | 2025-04-15 00:00:00
118 | BAU | SPOT | 2025-04-15 00:00:00
119 | BAU | SPOT | 2025-05-15 00:00:00
110 | BAU | Commission | 2025-05-15 00:00:00
110 | BAU | Commission | 2025-05-15 00:00:00
111 | ICT | SPOT | 2025-05-15 00:00:00
112 | ICT | SPOT | 2025-05-15 00:00:00
112 | ICT | SPOT | 2025-05-15 00:00:00
113 | ICT | Commission | 2025-05-15 00:00:00
114 | ICT | Commission | 2025-05-15 00:00:00
Spreadsheet: 484346d1476219361-certain-data-pulling-up-in-a-range-of-data-sets-and-wanting-any-info-to-pull-up-along-it-variance-template_replyv1
Sheet: Sheet1

 |  |  |  |  | Areas | types
 |  |  | Helper Column |  |  | school | car | food | Date
 |  |  |  |  | Location1 | 150 | 500 | 200 | 2016-04-09 00:00:00
 |  |  |  |  | Location2 | 900 | 450 | 325 | 2016-04-09 00:00:00
 |  |  |  |  | Location3 | 436 | 543 | 764 | 2016-04-09 00:00:00
 |  |  |  |  | Location4 | 8565 | 2342 | 4635 | 2016-04-09 00:00:00
 |  |  |  |  | Location5 | 967 | 876 | 65 | 2016-04-09 00:00:00
 |  |  |  |  | Location6 | 8565 | 2342 | 123 | 2016-04-09 00:00:00
 |  |  |  |  | [NAME] | 904345 | 8765 | 6546 | 2016-04-09 00:00:00
 |  |  |  |  | 99999999
 |  |  |  |  | Location3 | 234 | 342 | 657 | 2016-04-16 00:00:00
 |  |  |  |  | Location1 | 554 | 8797 | 23423 | 2016-04-16 00:00:00
 |  |  |  |  | Location6 | 234 | 34576 | 75 | 2016-04-16 00:00:00
 |  |  |  |  | Location4 | 967 | 6456 | 655464 | 2016-04-16 00:00:00
 |  |  |  |  | Location2 | 905 | 873 | 1232 | 2016-04-16 00:00:00
 |  |  |  |  | Location5 | 2347 | 345 | 4546 | 2016-04-16 00:00:00
 |  |  |  |  | Location 8 | 5000 | 4000 | 2000
 |  |  |  | removed
 |  |  |  | removed
 |  |  |  | added
Spreadsheet: 881764d1729929683-data-driven-from-prime-data-to-abstract-as-requires-requet-formula
Sheet: Abs

This is the master data -(A)
Item No | Description of work | BOQ QTY | Qty | Perday Output | Actual Duration | Rounded Duration | Planned Start | Planned Finish | Bricks | Cement | Fine Sand | Mason | Helper | W-Helper | Stone aggregate 20mm | Stone aggregate 10mm | Sand | Mixer | Vibrator
1 | [NAME] 1:4 | 35 | M3 | 10 |  |  | 2024-10-16 00:00:00
2 | [NAME] 1:6 | 75 | M3 | 20 |  |  | 2024-10-19 00:00:00
3 | RCC 1:2:4 | 55 | M3 | 25 |  |  | 2024-10-22 00:00:00
 | Work Items | Qty |  | One Day Output |  |  | Start | Finish | Material Constant For 1 Unit of the work Items
Total Quantity Statement Drived from Above Given data (B)
 |  |  |  |  |  |  |  |  | Bricks | Cement | Fine Sand | Mason | Helper | W-Helper | Stone aggregate 20mm | Stone aggregate 10mm | Sand | Mixer | Vibrator
 |  |  |  |  |  |  |  | Total Qty
Material Requirement Date wise as described as per above data( C )
Sl.No. | Material Description |  |  |  |  | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00
1 | Bricks | For Item -1 |  |  |  |  |  | 4940 | 4940
2 | Bricks | For Item -2
Lookup the Start Date and  Duration of the activity  Consumed Quantity of that period to be ABSTRACTED  As per timeline Direct Formula by skipping Step B and Step C
Sl.No. | Material Description | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00
1 | Bricks
2 | Cement
3 | Fine Sand
4 | Mason
5 | Helper
6 | W-Helper
7 | Stone aggregate 20mm
8 | Stone aggregate 10mm
9 | Sand
10 | Mixer
11 | Vibrator
Spreadsheet: 851795d1701932609-need-help-with-adding-multiple-leaves-for-an-employee-employee-attendance-record-2023
Sheet: Employee Leave Tracker

 | Employee leave tracker
 | Employee name | Start date | End date | Type of leave | Days
 | [NAME] |  |  | Sick leave
 | ABDULNABI |  |  | Sick leave
 | ABINASH
 | ARJUN NEPALI
 | BISHOK
 | C.SENTHIL
 | FAROOQ
 | GOURAKHA BAHADUR RAI |  |  | Vacation
 | HARI NARAYAN
 | HARI NATH KANWAR
 | HARIS FAJRI
 | IMRAN [NAME]
 | JIWAN BHAIYA
 | MAHADEV PARIYAR |  |  | Other
 | MD KHUSHAL |  |  | Other
 | MOHAMAD SALMAN
 | MOHAMMAD FIROZ |  |  | Sick leave
 | MUHAMMED SINAN |  |  | Other
 | N.AYYAPPAN
 | N.SELVAM
 | NIYASUDEEN
 | [NAME]
 | PURNA DANGI |  |  | Vacation
 | RAHUL C.M
 | RAHUL P
 | RAM GURUNG
 | ROSHAN RAI |  |  | Sick leave
 | SAIDUL HAQUE
 | SAILALO |  |  | Vacation
 | THOUFEEQ BASHEER
 | VINOD KUMAR
 | YADAV GAJUREL
Spreadsheet: 710268d1608816086-running-balance-need-to-shows-in-another-sheet-bili
Sheet: Bilal

Bilal
S.no | Date | Voucher # | Received | Paid | Balance
 |  |  | 54 | 1
Spreadsheet: 771664d1646780686-index-and-match-not-returning-the-correct-value-2-circuit-fix-pricing
Sheet: PRICING

 | Business |  |  |  | CELL TOWER
Bandwidth | 3 YEAR | 5 YEAR | 7 YEAR | 10 YEAR | 3 YEAR | 5 YEAR | 7 YEAR | 10 YEAR
10 Mbps | 31 | 51 |  |  |  | NA | NA
20 Mbps | 32 | 52 |  |  |  | NA | NA
50 [NAME] | 33 | 53 |  |  |  | NA | NA
100 Mbps | 34 | 54 |  |  |  | 151 | 171
200 Mbps | 35 | 55 |  |  |  | 152 | 172
300 Mbps | 36 | 56 |  |  |  | 153 | 173
400 Mbps | 37 | 57 |  |  |  | 154 | 174
500 [NAME] | 38 | 58 |  |  |  | 155 | 175
600 Mbps | 39 | 59 |  |  |  | 156 | 176
700 Mbps | 40 | 60 |  |  |  | 157 | 177
800 Mbps | 41 | 61 |  |  |  | 158 | 178
900 Mbps | 42 | 62 |  |  |  | 159 | 179
1250 Mbps | 43 | 63 |  |  |  | 160 | 180
1 Gig | 44 | 64 |  |  |  | 161 | 181
2 Gig | 45 | 65 |  |  |  | 162 | 182
3 Gig | 46 | 66 |  |  |  | 163 | 183
4 Gig | 47 | 67 |  |  |  | 164 | 184
5 Gig | 48 | 68 |  |  |  | 165 | 185
6 Gig | 49 | 69 |  |  |  | 166 | 186
7 Gig | 50 | 70 |  |  |  | 167 | 187
8 Gig | 51 | 71 |  |  |  | 168 | 188
9 Gig | 52 | 72 |  |  |  | 169 | 189
10 Gig | 53 | 73 |  |  |  | 170 | 190
Spreadsheet: 879153d1726595487-most-efficient-way-to-program-this-book-copy-of-employee-sales-target-week-37
Sheet: Sun

Employee | Sales transactions | Gross Sales | Net Sales | Discount | Gross Margin | Gross Margin Ratio | Cost of Goods |  |  |  | ATV
Camron J | 3 | 360 | 360 | 205 | 223 | 0.621 | 136
[NAME] | 3 | 656 | 655 | 0 | 519 | 0.793 | 136
Return | 1 | 30 | 31 | 125 | 0 | -0.006 | 31
Total | 7 | 1047 | 1045 | 330 | 742 | 0.71 | 303
Spreadsheet: 466796d1466447217-report-formula-query-profitability-may-2016
Sheet: Sheet2

 |  |  | Data
Years | Date | Project | Sum of Quantity | Sum of Cost Amount | Sum of Charge Amount | Sum of Invoiced
2014 | Feb | Thirty | 1 | 10 | 500 | 17613
 |  | Twenty |  |  |  | 85250
 | Feb Total |  | 1 | 10 | 500 | 102863
2015 | Feb | Twenty | 1 | 20 | 120 | 1655
 | Feb Total |  | 1 | 20 | 120 | 1655
2016 | Jan | Thirty | 1 | 13 | 150 | 10000
 |  | Twenty | 1 | 13 | 150 | 100
 | Jan Total |  | 2 | 26 | 300 | 10100
 | Feb | Thirty | 1 | 32 | 100 | 1950
 |  | Twenty | 1 | 32 | 100 | 13823
 | Feb Total |  | 2 | 64 | 200 | 15773
 | Mar | Thirty | 1 | 52 | 160 | 12433
 |  | Twenty | 1 | 52 | 160 | 12001
 | [NAME] |  | 2 | 104 | 320 | 24434
Grand Total |  |  | 8 | 224 | 1440 | 154825
Spreadsheet: louise_kitchen__23825__Combined Com  and Com Supt 3_23
Sheet: Chart Data

 | COMPANY | NO [NAME] | TOTAL | Count: NO [NAME]
 | ENA (2) |  | 72 | 2
 | ENW (2) |  | 111 | 2
 | EGM (0) |  | 23 | 0
 | EIM (0) |  | 8 | 0
 | CALME (1) |  | 10 | 1
 | APACHI (0) |  | 2 | 0
 | ESA(0) |  | 6 | 0
 |  |  | Calme
Spreadsheet: 00b27eb0-08b6-47b4-820b-7e9bc21f43fd
Sheet: Inventory

[NAME] %: | 0.15
CA Sales Tax: | 0.0825
Item | Wholsale Price | [NAME] | Sales Tax | Retail Price | Quantity | Total $
Ruler | 1.21 |  |  |  | 110
Highlighter | 0.92 |  |  |  | 200
Eraser | 0.36 |  |  |  | 55
Notepad | 1.21 |  |  |  | 250
Stapler | 1.95 |  |  |  | 35
Post-It Note | 3.95 |  |  |  | 900
Copier Paper | 3.87 |  |  |  | 60
Calculator | 6.98 |  |  |  | 12
CD-R | 0.55 |  |  |  | 150
[NAME] | 10 |  |  |  | 50
[NAME] | 1.5 |  |  |  | 50
Keyboard | 12 |  |  |  | 20
[NAME] | 5.9 |  |  |  | 120
Pencils | 0.12 |  |  |  | 400
[NAME] | 0.89 |  |  |  | 70
Grand Total: